Home page and introduction About the Lifestyle Health Center Answers to frequently asked questions Useful resources to improve health with lifestyle Program results and personal stories of participants Information for corporations seeking better employee health Directions to the Center with map Interesting news about the Center How to contact the Center
The CHIPwit Software Suite

(Click here to visit the official CHIP website to learn about the CHIP program itself.)

CHIPwit is a software suite specifically developed to automate administration of the CHIP lifestyle program. It uses computer-generated forms in place of paper ones. (e.g. Registration form, Lifestyle Evaluations, Medication form, Attendance & mileage records) CHIPwit includes a set of Excel workbooks and a Powerpoint presentation that use Visual-Basic macros executed by clicking "function buttons." It generates a file containing the same information generated by the CHIP Assistant that can be transmitted to the CHIP central database. (click image below to view enlarger image)
CHIPwit was developed to help you run successful CHIP lifestyle programs.

Click here to download a Powerpoint presentation of how CHIP HeartScreen and lifestyle evaluation procedures work using CHIPwit.

This web page contains information about CHIPwit with pictures and examples. The key features of the software include the following:

  • Easy to understand master Control Panel more...
  • Fully-automated markup of the lifestyle evaluations more...
  • Quick and easy data entry with extensive error-checking more...
  • Time-saving file importation of digital blood test results more...
  • Powerpoint slides are generated with stratified analyses more...
  • Summary data is automatically analyzed more...
  • Graduation awards are automatically assigned more...
  • Miles are totaled at each meeting with table totals more...
  • SF-36 and Beck Depression Inventory questionnaires are included more...
  • Clinical progress notes are automated with password protection more...
  • A user-friendly comprehensive UserGuide is built in more...
  • Additional help is provided on each of the participant forms more...
  • New data items have been added more...
  • External measures can easily be added to the HeartScreen more...
  • Answers to the great questions asked by CHIP Directors and others more...



  • An easy to understand control panel outlining the various functions in the order they are performed, with numbered "function buttons" to execute each step of the CHIP program. The buttons change color when they are used to easily keep track of which steps have been completed and which one is next. (notice that some buttons on the control panel are darker than the others)

  • Fully automated markup of the lifestyle evaluations, including "up" and "down" arrows indicating lifestyle change recommendations with a color-gradient classification of blood test results for easy interpretation of their significance by the participants. WordArt comments are easily pasted using a macro to provide brief feedback comments to the lifestyle evaluations. (e.g. "Great Job!" or "Good beginning")

  • Quick and easy data entry with extensive error-checking to prevent erroneous entry. Many fields use in-cell drop-down lists, including the medication list. Usual indication and dosing are prompted for recognized medications, and may be accepted or easily revised as needed. Data can be entered directly into the computer forms (which look exactly like the paper forms used to collect information), or entered using Excel dataforms by clicking a "function button." (dataforms are pop-up boxes Excel uses to enter data into spreadsheets.)

  • Time-saving entry of digital blood test results using CHIPwit's file-import function eliminates typing lab values from paper reports. Labs can also be typed directly into the computerized forms to override imported values. (Paper lab reports can also be scanned into digital form using OCR software and imported.) This is one of the more complex processes to set up, but once it is established and working for your lab report layout it needs no further attention.

  • Powerpoint slides with stratified outcomes are generated showing changes by user-specified strata for BMI and moajor risk factors, and by quartiles for major lifestyle factors.

  • The second lifestyle evaluation includes a 1-page summary showing relevant HeartScreen #1 and HeartScreen #2 measures with changes and % change. It also shows changes in key lifestyle behaviors and medications. This summary is included as a slide in the Powerpoint presentation.

  • Data is automatically summarized in a summary workbook with analyses by quartile and gender showing p-values and bar charts. A summary workbook can be used to aggregate outcomes within a CHIP chapter or for multiple chapters to provide easy stratified data analyses.

  • Graduation awards are automatically assigned to participants with the greatest improvements, while limiting awards to one-per-participant by giving awards to runner-ups.

  • Miles are recorded at each meeting for each participant and totals are calculated for each table to assign the mascot. Attendance is recorded and Certificates of completion are printed automatically. (all printouts are easily previewed before printing)

  • SF-36 (Rand) and Beck Depression Inventory questionnaires are included as optional measures during the HeartScreens. Scores are reported with lifestyle evaluations on a separate page designed specifically for reporting the meaning of these health assessment instruments.

  • Clinical progress notes are automated with password protection to provide tight security. Risk factors are summarized for each participant with automatic color-coding to quickly identify risk levels. Details are quick and easy via pop-up comments shown by floating the cursor over the various items. Progress notes are written using a simple form with check-boxes and a user-defined narrative template. Previous notes can easily be reviewed. A 1-page clinical summary for each participant including key risk factors and progress notes can be printed. Super bills can also be printed for services provided. (These clinical components are available only in the Professional version of CHIPwit.)

  • A user-friendly comprehensive User Guide is included with a hyperlinked Table of Contents and Glossary-Appendix. A "look up" function is provided to quickly find needed help information. Many of the paragraphs include illustrations that are viewed by clicking an icon button.

  • An additional help feature is provided on each of the participant forms. Brief 'post-it notes' are easily displayed for any field on these forms. (registration, HeartScreen and lifestyle evaluations) The post-it help notes can be edited to read as desired by the user, making them even more helpful. All worksheets / forms include a fixed panel at the top containing function buttons. Clicking on the panel displays a description of the form and the use of each of the buttons it contains.

  • New items have been added to the medical history and HeartScreen measures. The HeartScreen forms now include non-alcoholic fatty liver disease (NAFLD), Reflux/Gerd and polycystic ovary syndrome (PCOS) under medical history. An entry has been added for "Other" to catch unanticipated important conditions. Also, waist-size, ankle-brachial index (ABI) and HbA1c have also been added to the clinical measures that may be collected.

  • External measures can easily be added to the HeartScreen, SF-36 and BDI questionnaires. External measures (instruments) can include 1-50 items each that are easily exported for use with other software, and can be recorded at five user-defined measurement points. This provides almost unlimited capacity for data collection in a single data repository.

  • The following questions have been asked by CHIP Directors and others.

    Q1: Will CHIPwit run on Mac computers or just on PCs?
    The software will run on any computer that runs MS Excel 2000 or later. A "Mac" version of the software will be available shortly after the PC version is released.

    Q1a: Will the "right-click" shortcut menu feature work on the Mac?
    The software provides context-sensitive shortcut menu options on the PC that are implemented using a double-click on the Mac. All functionality is equivalent between the PC and the Mac versions of the software, but implemented in the manner consistent with the two operating systems and platforms.

    Q2: I hear this software replaces the paper forms. Does it require that participants have or use a computer? Will it allow paper forms to be used at all?
    While CHIPwit does replace the multipart forms (lifestyle assessment and medication forms) with computer printed ones, it does not require participants to have or use a computer, or even to know the forms are different. (The only difference is they do not have to press hard enough to go through three layers, but just one.)
    The forms to be filled out before HeartScreen are printed out as a 1-page single-layer form participants take home and fill out before coming to HeartScreen, just as they do with the paper forms. The completed forms are then used to record measures and enter data into the computer during and after HeartScreen.
    After the data is entered into the computer, and after labs are entered (or imported electronically), lifestyle evaluation forms are printed for each participant and a copy is made for their physician. The form looks similar to the form they filled out but includes the lifestyle recommendations that were not shown on the HeartScreen assessment form. (medications are listed in that space to keep everything on one page so forms do not get separated and lost)
    Another HeartScreen assessment form is printed for participants to complete before the second HeartScreen. It looks like the first one except that it now includes their name, address, medical history and medication list with a place for them to write in any changes. This form is used to record and enter measures during and after HeartScreen #2. After the data and labs are entered into the computer, a second lifestyle evaluation form is printed and a copy is made for their physician.
    For those wanting to go paperless, the assessment forms can be produced as fillable PDF files and emailed to the participants. Alternatively, forms can be completed online at your webpage. The lifestyle evaluations can be produced as PDF files and emailed to participants and they can print or forward a copy for their physician. Few CHIP programs are ready for this level of automation, but it is now available.

    Q3: What are the benefits to me as a CHIP Director?
    This question is largely answered by viewing the lifestyle evaluation comparison slides. After conducting a couple of CHIP programs you learn that there is a push to get the evaluations all marked up and completed before night #4 after the labs are available. The process is non-trivial -- instructions for marking the forms consume many pages of the Director's Manual.
    With CHIPwit all you have to do is enter the information from the HeartScreen forms into the computer and import the digital lab report (or manually enter the labs into the "Labs" worksheet) and click a button. All of the evaluations are immediately ready to print out with beautiful, crisp colors and clarity. Every copy looks link an original copy and no one has to struggle to read what the form says.
    The advantages are even greater after the second HeartScreen when the software makes before and after comparisons for not only changes in the lab values, but also the changes in diet, exercise and stress. When participants see their blood work changes next to their lifestyle changes, the all-important message of the cause and effect relationship is reinforced.
    Then it also automatically creates a PowerPoint with slides containing bar charts of the results stratified by baseline measure to make the changes more evident. AND, it exports the data to a summary workbook that calculates aggregate outcomes with stratified analyses, including calculating p-values. All of this happens "as if by magic." CHIPwit really does make you look and feel like "a Pro." And this makes a more positive impression on your participants, increasing the effectiveness of your program and providing immeasurable good will and PR.

    Q4: How does this program lower the cost of my staff overhead?
    While it is hard to lower the costs for volunteer staff, it is easy to reduce the workloads with well-designed automation. The most valuable staff is consumed marking up the lifestyle evaluations and making sure the medications are entered with the proper indications and dosing. CHIPwit has been designed by medical experts to automate these vital functions. The functions requiring more expensive staff are replaced by a simpler data entry function. Most folks find the amount of time required to enter data into CHIPwit is less than the time required to enter data into the existing CHIP Assistant. Staff costs are thus reduced in two ways -- by using less expensive staff, and by cutting data entry time. Training costs are also reduced since it is much easier to train someone to do data entry than to teach them to properly mark up the lifestyle evaluation forms.

    Q5: Are there additional licensing rights that we need to address?
    The Adventist CHIP Association plans to acquire licensing rights to use the "Basic version" of the software. This will eliminate any need for church CHIP programs to secure additonal licensing rights to use the software.
    Use of the "Advanced version" of the software will require an additonal license. The Lifestyle Medicine Institute (developer and owner of the CHIP Program) plans to secure licensing rights for corporate and medical CHIP programs to use the full-featured "Advanced version." The software can also be licensed directly from the developer.

    Q6: Have instructional materials already been created for execution of the software?
    The software includes extensive built-in context-sensitive help information for every worksheet and form. An automated User Guide with over 350 lines of documentation with an automated word search make it easy to find the topic of interest. The User guide Table of Contents is hyperlinked to make it easy to quickly scroll to the needed chapters in the Guide. A Glossary includes key words and phrases to make it easy to understand terms that may be new to the user. And the Guide includes graphic illustrations that are viewed with a click of the mouse.
    Probably the best instructional tools are the help notes provided for the computerized forms. Any field on the forms (i.e. cell in the worksheet) can be selected and the 'Help' button clicked to display a pop-up "post-it" note with information specifically about that field and what goes there. These pop-up notes can be edited by the user to make them more helpful. This software is truly one of the most user-friendly, well-documented programs you will find anywhere.
    And, it is designed so that every step is outlined and explained as the "Auto-pilot" feature of the Control Panel guides execution as the CHIP program proceeds from HeartScreen to labs, to evals, to HeartScreen #2, etc. Perhaps the nicest thing about its simple design is that you can sit down with the software and just start using it. Since the computer forms look like the paper documents, there is a very low learning curve. Since non-data entry fields on the forms are locked to prevent unintended alterations to the forms, there is little danger of even doing any harm accidently.
    Last but not least, a Tutorial will soon be available that works like the real thing (but without altering any files) so that a user can "play" with it to get the feel of how the software works. In fact, the software can teach you plenty about how to run a successful CHIP program.

    Q7: Who addresses potential glitches to the program? Do you have an IT support team that can troubleshoot if our staff needs help?
    The developer is the sole support person at present. There is little need for "IT support" since this software is built on the widely-used MS Excel spreadsheet software. If the entire set of macros were to fail, the worksheets could still be utilized by manually performing the various steps to fill out the forms and print them. For example, the automated mark-up of the lifestyle evaluation forms is done using spreadsheet formulas and is not dependent on the macros. While the macros automate almost every task, they do not prevent a user from using the spreadsheet in its "native" (manual) mode.
    Support will be provided through the ACA when they start using CHIPwit. The developer will bring aboard qualified support personnel as the demand indicates. Well-designed software requires much less support than not-so-well-designed software. The developer is committed to suporting this product and will not let it fail because of poor or inadequate support.

    Q8: How will this new software change the cost structure of our CHIP administrative overhead?
    The answer to this question depends on whether you are running a CHIP program under the Adventist CHIP Association or not, and whether you utilize the Basic version or the Advanced version of the software. The Advanced version adds significant functionality and potential for revenue and cost savings, and thus it costs more to license. If your needs are met with the Basic version, costs will likely be little different from present costs. Contact ACA or LMI or the developer for licensing costs and provisions. The software is licensed for a single CHIP chapter, but volume licenses are available.

    Q9: Can I get some of the "advanced" features without all of them? How about automatic importing of labs reports and 1-year follow-up?
    The software only comes in the two configurations. The features included in the basic version were selected to provide all of the functionality in the existing CHIP operational package, plus the additional features that can be utilized fairly easily with the paper forms. Most components are modular but it is not practical to allow users to pick and choose features in a "cafeteria fashion." The two features you mention are features that would typically be utilized in a more professional application.
    Keep in mind that all features included in the advanced version do not have to be utilized. You can license the advanced version and not utilize all features included, such as the progress notes and billing functions. Please feel free to inquire further by contacting the developer. (JHKelly@llu.edu)

    Do you still have questions?
    Email your questions to the developer and they will be answered promptly. Those of general interest will then be posted here.

CHIPwit has been used by the Rocky Mount Lifestyle Health Center to conduct CHIP programs for over a year with success. Clinical / medical management functions are being expanded in preparation for use with a new Intensive Cardiac Rehabilitation version of CHIP. (CHIP-ICR)

Dr. Kelly (Med Director for the Center) is using the expanded software with our recent CHIP programs with excellent results. He reports,

"I just imported labs Friday without typing but one set of values for a participant who got blood drawn separately from the HeartScreen. I am amazed at how powerful the clinical summary is with its color-coding in identifying participants needing monitoring and clinical follow-up. Writing a focused progress note takes just a minute and easily records everything needed to bill the services provided."


Click here to download a Powerpoint presentation of how HeartScreen and lifestyle evaluation procedures work using CHIPwit.

Coming soon... A beta-version of CHIPwit software. Contact Dr. Kelly for more information or to request a copy of the software.