{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Medication Data Entry","Printable Weekly Schedule","Medication Setup"],"not_rendered":{"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Medication Data Entry","index":0,"n_rows":7,"n_cols":8,"rows_kept":7}
[]
[{"$nulls":3},"MEDICATION DATA ENTRY"]
[]
[{"$nulls":3},"Day","Date","Medication","Taken At","Daily Remaining"]
[{"$nulls":3},{"$f":"IF(Schedule[[#This Row],[Date]]=\"\",\"-\",CHOOSE(WEEKDAY(Schedule[[#This Row],[Date]]),\"Sunday\",\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\",\"Saturday\"))","v":"Tuesday"},"2013-06-04","Thyroid medication","07:00:00",{"$f":"IFERROR(VLOOKUP(Schedule[[#This Row],[Medication]],Meds[],5,0)-COUNTIFS(Schedule[Medication],Schedule[[#This Row],[Medication]],Schedule[Date],Schedule[[#This Row],[Date]]),\"\")","v":1}]
[{"$nulls":3},{"$f":"IF(Schedule[[#This Row],[Date]]=\"\",\"-\",CHOOSE(WEEKDAY(Schedule[[#This Row],[Date]]),\"Sunday\",\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\",\"Saturday\"))","v":"Tuesday"},"2013-06-04","Multi-vitamin","08:00:00",{"$f":"IFERROR(VLOOKUP(Schedule[[#This Row],[Medication]],Meds[],5,0)-COUNTIFS(Schedule[Medication],Schedule[[#This Row],[Medication]],Schedule[Date],Schedule[[#This Row],[Date]]),\"\")","v":0}]
[{"$nulls":3},{"$f":"IF(Schedule[[#This Row],[Date]]=\"\",\"-\",CHOOSE(WEEKDAY(Schedule[[#This Row],[Date]]),\"Sunday\",\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\",\"Saturday\"))","v":"Tuesday"},"2013-06-04","Eye vitamins","10:00:00",{"$f":"IFERROR(VLOOKUP(Schedule[[#This Row],[Medication]],Meds[],5,0)-COUNTIFS(Schedule[Medication],Schedule[[#This Row],[Medication]],Schedule[Date],Schedule[[#This Row],[Date]]),\"\")","v":0}]

{"sheet":"Printable Weekly Schedule","index":1,"n_rows":7,"n_cols":10,"rows_kept":7}
[]
[{"$nulls":3},"MEDICATION SCHEDULE"]
[]
[{"$nulls":3},"Sun Meds","Mon Meds","Tue Meds","Wed Meds","Thu Meds","Fri Meds","Sat Meds"]
[{"$nulls":3},"Thyroid medication","Thyroid medication","Thyroid medication","Thyroid medication","Thyroid medication","Thyroid medication","Thyroid medication"]
[{"$nulls":3},"Eye Vitamins","Eye Vitamins","Eye Vitamins","Eye Vitamins","Eye Vitamins","Eye Vitamins","Eye Vitamins"]
[{"$nulls":3},"Multi-vitamin","Multi-vitamin","Multi-vitamin","Multi-vitamin","Multi-vitamin","Multi-vitamin","Multi-vitamin"]

{"sheet":"Medication Setup","index":2,"n_rows":8,"n_cols":8,"rows_kept":8}
[]
[{"$nulls":3},"MEDICATION SETUP"]
[]
[{"$nulls":3},"Medications","Every","Frequency","Active","Per Day"]
[{"$nulls":3},"Thyroid medication",2,"Day","Yes",{"$f":"IF(OR(Meds[[#This Row],[Frequency]]=\"As needed\",Meds[[#This Row],[Active]]=\"No\"),0,Meds[[#This Row],[Every]]*LOOKUP(Meds[[#This Row],[Frequency]],{\"Day\",1;\"Hours\",3}))","v":2}]
[{"$nulls":3},"Multi-vitamin",1,"Day","Yes",{"$f":"IF(OR(Meds[[#This Row],[Frequency]]=\"As needed\",Meds[[#This Row],[Active]]=\"No\"),0,Meds[[#This Row],[Every]]*LOOKUP(Meds[[#This Row],[Frequency]],{\"Day\",1;\"Hours\",3}))","v":1}]
[{"$nulls":3},"Eye vitamins",1,"Day","Yes",{"$f":"IF(OR(Meds[[#This Row],[Frequency]]=\"As needed\",Meds[[#This Row],[Active]]=\"No\"),0,Meds[[#This Row],[Every]]*LOOKUP(Meds[[#This Row],[Frequency]],{\"Day\",1;\"Hours\",3}))","v":1}]
[{"$nulls":3},"Ibuprofen",1,"As needed","No",{"$f":"IF(OR(Meds[[#This Row],[Frequency]]=\"As needed\",Meds[[#This Row],[Active]]=\"No\"),0,Meds[[#This Row],[Every]]*LOOKUP(Meds[[#This Row],[Frequency]],{\"Day\",1;\"Hours\",3}))","v":0}]