Excel Workbook for Tracking Progress

Aside

I really was not comfortable with waiting 3 months to see if my plan to combat diabetes was effective. I also needed some tool to keep me motivated on a daily basis. What I was looking for was a way to predict what my blood numbers were going to be in the future if I stuck with my plan. I also wanted to know ahead of time if I needed to adjust my plan based on an unfavorable prediction.

In my reading I ran across an article on the “5% Club” (http://www.tudiabetes.org/group/the5club). This is a forum for diabetics who have managed to get their HbA1C numbers down below 6%. That sounded exactly like my goal. While reading the 5% Club members forum I stumbled upon a link to an Excel spreadsheet (http://www.loanuniverse.com/Diabetes/) That could be used to predict/estimate  HbA1C numbers. The spreadsheet uses the Nathan formula to perform the HbA1C calculation.

In my reading, I discovered that there are a lot of HbA1C / Blood Glucose equations in use. The Nathan formula is one. It appears that most labs use the DCCT formula. There is also some literature that suggests that the new ADAG formula may give a better indication of average glucose levels based on HbA1C values. So, not knowing which methodology was best I decided to modify the spreadsheet to use them all. I also wanted to use only 1 Excel workbook to do all of my diabetes-related tracking.

The following is a link to my version of the workbook.

Carbs Glucose and A1c Tracking.xlsm

Here is a list of the modifications I made:

  • Added a daily calorie and carb log
  • Added a few more columns on the glucose log for more glucose data entry (calculation accuracy increases as you increase the number of data points)
  • Expanded the glucose log from 120 days to 360 ( HbA1C values are still base on 120 days of data. Each month (30-day period) the HbA1C calculation uses the previous 120 days of data.)
  • Added both the DCCT & ADAG formulae calculations in addition to the Nathan formula calculation
  • Added the ability to change the glucose concentration units (mmole/mL = mg.dL / 18.05)
  • Added the ability to select between Whole Blood Glucose or Plasma Glucose (PG = 1.11 * WBG)
  • Added the ability to set high alarm values for calories, carbs, glucose concentration and HbA1C values (cell background and font color change if the alarm value is exceeded)
  • Daily calorie and carb numbers are imported onto the Glucose / HbA1c sheet to facilitate side-by-side comparison of food intake vs glucose levels
  • Added a worksheet for recording calorie and carb values for food one might routinely eat.

NOTE:

It is not required that an data entry be made in every cell of the daily glucose log. If a cell is left empty it is not used in the HbA1c calculation. The calculation does not use a zero for a blank cell. Blank cells are ignored.This workbook has been updated as of 01/21/2017. The update was done to correct a couple of minor errors in the calculation using the Nathan and DTTC equations.


If you have any questions or comments about this workbook you can contact me at 

carbcounting@heinemannpage.com.

One Month In

Well, it has been 1 month since I decided to get serious about my diabetes. That is when I started my reduced calorie / carb diet. My goal at the time was to stay below 1800 calories and 100 grams of carbohydrates per day. So far I am actually averaging about 1500 calories and 88 grams of carbs per day.

I have lost 12 pounds since I started. I know that most of this is water; but, I have taken in a notch on my belt and my wife says she can tell I am loosing. But, I seem to have hit a plateau for the last couple of weeks. At 1500 calories a day I should be dropping 2 or 3 pounds per week. Yesterday I added exercise to my daily routine –

  • treadmill – 1.5 miles at 3 mph on a 5 degree incline
  • weights — 100 pound bench press, 3 reps of 10

I will increase both of these as I loose weight (hopefully) and gain strength. I sure hope that the exercise kick starts my metabolism and I start to loose weight again.

Six weeks ago my fasting blood glucose was 148 mg/dL and HbA1c was 6.7%. This morning the blood glucose was 128 (mid morning with no breakfast). My average (average the tests I have taken) blood glucose over the month is 130 mg/dL. That should correlate to a HbA1c of about 6.5%. It is an improvement. But, in order to get into the 5% club (membership is a HbA1c of less that 6%) I need to get the average glucose down to less than 114 mg/dL. That is 13% lower than where I am now. I may try eliminating the carbs in my evening snack. That has been averaging 76 grams of carbs. That should do it if there is a linear relationship between carbs consumed and average blood glucose levels.