Forum Discussion
Diabetic Searches in Excel.
I have this spreadsheet that I track my blood sugars. My blood sugar numbers fluctuate depending on what I eat and drink. The daily spreadsheet looks like this: At the end of the mon...
mathetes You are funny !!🙂
About the blood count, in the first image at the bottom is table with the whole day by hour. I devised this since I don't know when I'll take the blood readings.
The second is a "summary" blood count from the whole month by day.
FBC = First Blood Count. Dietician wants that set out for review.
I hope this is clearer but if it isn't, you don't have to comment.
mathetes, my images may be too small. let me break them out better for discussion.
This is my daily spreadsheet. This includes my food items, calories, and blood readings
This potential A1C sheet I designed for at-a-glance, future dax calculations, and shareability. Doctors only give patients maybe 30-40 minutes of time so this design can let them scan and consult.
- I can't see it clearly (too small), but if each of those columns is A1c data, that looks fine. My format was essentially the same idea, one row per day, with the separate readings separated with space for time (I left those Time fields blank, figuring you knew how you wanted to record them). If it were mine, I'd make the hours drop down menu items, with the options you have In your vertical array.
Basic point, though, a database in Excel is typically based on rows of data for days, or for days and times.....without lots of blank spaces. Your A1c original has blank spaces predominating over data.
