Spreadsheet tracking

BandonBob
By BandonBob Latest Reply 2011-03-22 14:15:07 -0500
Started 2011-03-21 17:21:47 -0500

Some people have asked about racking their diabetes and how to set it up. My first tracking was on a spreadsheet that came with my old Tandy computer. It works though with any spreadsheet. I first set up my columns. I label then in Row 1. Column 1 is the date. Column two is the time. Column 3 Is the systolic BP. Column 4 is the diastolic BP. Column 5 is the pulse. Column 6 is the BG level. Column 7 is for Fasting or after meals. Column 8 is weight. Column 9 is physical activity. Column 10 is How I'm feeling. Column 11 has my latest A1c, Cholesterol, HDL, LDL and triglycerides and the date they were taken. . Then at row 32 I have in Column 1 Averages. Column 2 is a formula =average (B2:B31). The same formula goes in columns3 through 10. This is an example but you can make your own. I also include columns for my evening BP and Other BG readings on mine but this gives an idea of what can be done. I hope this is of good to someone.


7 replies

realsis77
realsis77 2011-03-22 11:34:00 -0500 Report

That's a great idea! I personally use a applacation I have on my smart phone . It tracks my blood sugar and insulin use and provides graphs that I show my doctor! There are several wonderful tracking ideas! I like the idea you have and if I didn't use my application id use that! Thanks for explaining that clearly! This will help many people! :)

BandonBob
BandonBob 2011-03-22 13:26:27 -0500 Report

Thanks for your reply. I appreciate it. I have complete computer records, backups and hard copies from he day I was diagnosed and it helps to refer back when I see something unusual and can almost always say, Oh here's a place that happened before.

Graylin Bee
Graylin Bee 2011-03-21 20:13:07 -0500 Report

Thanks for your clear explanaion of a good set up for a spreadsheet. I am wanting to start one and am spreadsheet illiterate. How do I figure out what the formula should be?

BandonBob
BandonBob 2011-03-21 20:57:48 -0500 Report

A lot depends on what you want to do in the cell. In the example I used you get an average of a group of cells to tell you what the average is. If you wanted to add those cells the formula would be =sum(b2:B31) Excel also offers help in making formulas in their help section.

MOMMY_OF_AN_ANGEL
MOMMY_OF_AN_ANGEL 2011-03-21 18:44:10 -0500 Report

A great website to track your bloodsugars and meds you take for your diabetes is www.Sugarstats.com. Since joining, it has motivated me SOOO much! Its free to join as well. It will track your sugars, give you your daily, 7-Day, AND 30 Day average as well. It also has bar graphs and such so you can see the dips and/or spikes in your sugars.

BandonBob
BandonBob 2011-03-21 20:03:21 -0500 Report

Nowadays there are a lot of sites on line that you can use. I also use Heart360.org from the American Heart Assn because the info can be downloaded directly to your doctor. The one thing I can't find on line is a site that tracks every aspect - meds, readings, foods, emotions,exercise and all that I want to know. That is why I still have my own Excel spreadsheet I use that has everything about my health on one page. Thanks for your response.