Forum Discussion

George Carlisle's avatar
George Carlisle
Brass Contributor
May 30, 2022

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...
BI & Data Analysis
Formulas and Functions
George Carlisle's avatar
George Carlisle
Brass Contributor
May 31, 2022

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.

 

 

mathetes's avatar
mathetes
Silver Contributor
May 31, 2022
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.
  • mathetes's avatar
    mathetes
    Silver Contributor
    May 31, 2022

    George Carlisle 

     

    No worries. I didn't take it personally. We just approach design differently.

  • George Carlisle's avatar
    George Carlisle
    Brass Contributor
    May 31, 2022

    mathetes, My comment was not to be taken personally. I hear your comments about validation but my data is not fixed and the sheet WILL change in the future. Formulas I can update faster. Dropdowns must be individually edit. I made changes to hundreds of sheets at the same time with formulas, I cannot do that with dropdowns in Excel...yet.

  • mathetes's avatar
    mathetes
    Silver Contributor
    May 31, 2022

    George Carlisle 

     

    Try this. I disagree with you regarding drop downs. They make for consistency--via their "data validation" usage; as I've done here they save a lot of space (file space). If consistency doesn't matter, but you still want to record time of testing to some degree of precision, you could just enter per your own comfort.

     

    Anyway, it's your database, so do what seems right to you. Best wishes for controlling your condition.

  • George Carlisle's avatar
    George Carlisle
    Brass Contributor
    May 31, 2022

    mathetes 

     

    Maybe I need to attach as file not post as image. See attachment.

    I completed late last night. I put field on daily and referenced from other monthly a1c. Dropdowns are too time consuming.

     

     

Resources