Forum Discussion

MBC023's avatar
MBC023
Copper Contributor
Jul 08, 2020

Graphing daily medicine usage w excell

New user.

I'm trying to use data from a pill logger app to track my personal medicine usage. the app tracks medicine, time (12h), date, dosage, units (mg, ml, mcg), qty, total dose (if using widget to assign 2+ tablets per entry), and notes (currently unused).


total dose does not stack w previous tablets, the app isn't that smart. for me r/n it just replicates the dosage output, as i take one tablet at a time.


i need to track 4 medications (currently) of which 2 "stack", being different sizes and time releases of the same medication.


what i want to do is incorporate dosage timing, track dose totals (ie, one dose at 1.21pm, second at 2.01pm, therefore total dose is X until Y) into a dose over time graph format. daily (by half hour or hour), weekly, monthly and up would be nice.  one of my meds is a 24hr medication, so arrangling that on the daily graphs is a requirement.


sanitized sample of current data set is attached. there's only about a week of data b/c i only found this app recently; i've been looking for more than a year.

excel
Formulas and Functions

2 Replies

  • mathetes's avatar
    mathetes
    Silver Contributor
    Jul 08, 2020

    MBC023 

    What you posted is simply a CSV file. Can you post a still sanitized version, but in Excel, with whatever efforts you've already made to accomplish your goals. You say that it's an "app" that you've located, so I'm presuming there is some kind of data manipulation already included.

Resources