blood glucose spreadsheet
The accompanying spreadsheet allows you to enter and statistically interpret your blood glucose readings. This gives you a method to identify early warning signals for readings that are outside acceptable limits.
The spreadsheet calculates a Z-value or Z-score which is a comparative statistic allowing you to know how far your blood glucose reading is from an expected result given your past record of results. The further away from the expected result this statistics is the more likely the results is a critical one.
Save the spreadsheet to your desktop. Download blood_glucose.xls It’s is a Microsoft Excel spreadsheet.
Open the spreadsheet.
In cell B1 enter the name of last month.
In column B, there are four cells highlighted (Cells B5-B8). These cells represent the times you monitor your blood glucose readings each day.
- waking
- breakfast
- lunch
- dinner
You can change the names of these categories to ones you are more familiar with.
To change these categories select the cell you wish to change and type in your category name. Changing the category names in cells the B5-B8, the spreadsheet automatically changes these names of these categories for all other days.
Enter your results (Column C) for your blood glucose readings in each category for each day for the whole of last month.
When you have completed this for the whole month save the file under that month’s name.
Archive this file for your records.
Duplicate the file, change the name of the file to the current month, and open this new file.
Change the month in cell B1.
Enter your data for this month.
The program calculates results on a rolling basis, that is it uses some of last month’s data and combines it with data for this month to calculate new Z-scores and interpretations.
For each result entered, the spreadsheet calculates a Z-score, comparing it
against other data you’ve entered and gives a written interpretation. The interpretation returns one of five results.
These results are:
• alarm, too low
• low
• expected
• high
• alarm, too high
It should be pointed out that a single result should not be viewed on it’s own as critical, but needs to be interpreted within the context of the other results.
When you are in doubt, you should consult your medical practitioner.
The control limits for interpretation maybe altered in column S, Cells S3, S5 and S7.
• Limit 1 (Cell S3) relates to the extreme lower and higher limits.
• Limit 2 (Cell S5) relates to the low and high categories
• Limit 3 (Cell S7) defines the boundaries for expected results.
By altering these limits one can narrow or broaden the ranges in which each category falls, and therefore their interpretation.
Enter your blood glucose results in Column C as you do them each day.













