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 month, I pull all the data from daily sheets and consolidate in a monthly summary for discussion with my dietician. She asked for less data and wants me to just pull just the first day's blood sugar sample whatever time it is. I thought I could use a Vlookup or Hlookup or Xlookup but they require precision to function properly.
I say precision because my blood numbers can go from 0-500, and I may not take sample at the same time daily. Can some make a suggestion on how to solve this problem with Excel? Ultimately, I need to be able to present her a credible summary so we can have discussions about the month.
See the monthly spreadsheet:
If I had a FBC column, how will I get the data despite data being all over the grid/table?
13 Replies
How about changing the way you record the A1c levels. Your daily example only shows two readings; I'm assuming you may only do at most three or four. A layout like this could be used to record, and it would be very easy to show your dietician the first reading only.
- mathetes, tell me the benefits of your spreadsheet design? I felt my design was optimized because it consolidated daily times and columns to make easier to read for a professional. I used hourly to record blood readings because I needed precision but not exact...hourly was satisfactory for medical team.
This was a manual solution I came up with but I would like something more automated.
This solution involves renaming a column to "FBC" and manually monthly just keying in the data from the table to this new column.
What (for the uninitiated) is FBC? And what is the data you're proposing keying in?
Excel can do all kinds of things easily, but I (for one; maybe it's just me) am not following what it is that you're talking about with that reference, and how it connects with the single daily blood sugar reading you've asked about.
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.
