NEW:- Disease Registry & Action Plans (Revised 7/23/07)

[JParry]

We have developed a chronic disease registry using Excel. The intention of the disease registry is to present the physician with a method of tracking and evaluating their patient population with regard to four chronic disease conditions: CAD, DM, HF, & HTN. Additionally, these four conditions are supported with five prevention measures: breast cancer screening, colonoscopy screening, influenza and pneumonia vaccinations, and tobacco use counseling.

Please feel free to download and use the spreadsheet. As with all things DOQ-IT, it is free. We have also collected from the web, other QIO and medical sites, a selection of patient action plans.

The spreadsheet (8.6mb) is available here (http://jeny.ipro.org/files/doqit/DOQIT_Chronic_Disease_Measures_Registry_VJULY2007. xls) (Revised July 23, 2007)

1.33mb Zip File version (http://jeny.ipro.org/attachment.php?attachmentid=2645&stc=1&d=1185564486) ;)

Please use in conjunction with the data entry sheets (further below), aka Cheat Sheets.

An explanation of the DOQ-IT chronic disease measures can be viewed here: Web-Link (http://jeny.ipro.org/showthread.php?t=1035)

Let me know any questions: jparry@nyqio.sdps.org

[JParry]

Macros

When you open the disease registry spreadsheet, you will be prompted to "Enable Macros" or "Disable Macros". Choose "Enable Macros".

If you are not prompted then you probably have your macro setting at "High". To change this, while within Excel: click on "Tools", then "Macro" and then "Security". Select "Medium" and close the spreadsheet. Reopen the spreadsheet and you will then be prompted to enable or disable macros, select "Enable Macro".

Please let me know any other problems.

Thanks
John

[JParry]

To make the collection and entry of patient data for use with the Registry an easier task, we have created some "Cheat Sheets". ;)

Attached are five sheets:

1) Chronic Disease Measures: All Conditions
2) Chronic Disease Measures: DM
3) Chronic Disease Measures: CAD
4) Chronic Disease Measures: HTN
5) Chronic Disease Measures: HF

Each sheet also contains the preventive measures, Breast Cancer Screening, Colonoscopy Screening, Influenza and Pneumonia Vaccination, and Tobacco Use Discussed (Smoking Cessation).