Graphical Tracking of Patient Outcomes With the KCCQ, SAQ, and PAQ Calculators

Monitoring serial changes in health status is one of the principal clinical uses of the Kansas City Cardiomyopathy Questionnaire, the Seattle Angina Questionnaire, and the Peripheral Artery Questionnaire. Such changes can be difficult to perceive in tables of numeric data, but they become obvious when graphed. To facilitate review of individual patient trends at the point of care, we have added graphing capabilities to the our calculation tools — the KCCQ Calculator, the SAQ Calculator, and the PAQ Calculator. Here is information about how this works.

Monitoring serial changes in health status is one of the principal clinical uses of the Kansas City Cardiomyopathy Questionnaire, the Seattle Angina Questionnaire, and the Peripheral Artery Questionnaire. Such changes can be difficult to perceive in tables of numeric data, but they become obvious when graphed. To facilitate review of individual patient trends at the point of care, we have added graphing capabilities to the our calculation tools — the KCCQ Calculator, the SAQ Calculator, and the PAQ Calculator. Here is information about how this works.

Each of these Calculators is a simple but elegant spreadsheet that runs within Microsoft Excel to assist data entry of patient responses, calculate scale scores from the raw responses, generate tabular data collections, and graph results of any patient. These functions are handled in three worksheets within the Calculators — Data Entry, Data, and Graph. (Note: we show the Mac OS X version in the following screenshots, but the Windows version behaves identically and looks nearly the same.)

Installation

Each Calculator is a custom Excel spreadsheet. Thus you must have Excel installed on a computer in order to use the Calculator. Simply unzip the distribution file to get to the Calculator itself and then open it with Excel. As it opens the Calculator, Excel will ask if you want to “enable macros.” You must enable the “macros” in the Calculator because they are what allow it to function. If your IT department has configured your copy of Excel so that it may never enable macros, then you will have to have them fix that configuration before the Calculator will work. Also, you may not copy or install the Calculators on any more computers than you have a license for — typically just one.

Data Entry

The basic data entry user interface provides fields for a patient identifier (whatever is appropriate for your deployment) and the date the patient performed the questionnaire, as well as fields for all the questions in the instrument. Patient responses are entered using integers ranging from 1 to n, where 1 corresponds to the first option in the question and n is the last option.

Data entry filters insure that only valid dates and valid responses for each question can be entered. Once all the data are typed in, clicking on the “Save Values” button copies the entered values into the Data worksheet along with the calculated scale scores.

Data

The Calculators store accumulating patient data in the “Data” worksheet. Each new result is appended at the bottom of the worksheet as a new row. Columns hold the patient IDs, the study date, the calculated scale scores, and the raw question responses.

These data can then be cut&pasted or exported into other analytical applications. The “Delete All Data” clears the worksheet — after giving appropriate warning about the irreversible nature of this step.

Graphing

The “Graph” worksheet extracts a specific patient’s data from the “Data” worksheet and graphs it. Because often only summary scale results are desired at the point of care, each scale can be selected and deselected individually for inclusion in this report.

Once the scales are selected, clicking on the “Graph” button brings up a dialog box into which the patient’s ID is typed. All rows for this patient are then extracted from the data, sorted into chronological order, and then displayed in both tabular and graphical form.

Printing

This information can be viewed on screen, but more commonly we’ve found that clinical users prefer a printed copy for review with the patient and inclusion in the (paper) chart. The “Graph” worksheet can simply be printed using the Print commands in Excel to generate a nicely-formatted final report.

Created: December 11, 2005 12:10
Last updated: August 30, 2016 16:11


Comments

  1. Ning Chuanyi — 02 September 2009 - 09:56

    How I can get scores calculator systemic.


  2. Stan Kaufman — 16 September 2009 - 18:52

    The Calculators can be licensed along with the instruments. We do not license any of the optional calculation tools apart from a valid license for the instruments themselves. More information is in this detailed FAQ.


  3. Francis Martin Armada — 18 October 2009 - 00:35

    how will i download the SAQ calculator? thank you.


  4. Ing Shing — 28 May 2016 - 08:48

    How I can get scores calculator systemic?Thank you.


If you signup and login, you can post comments.