{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Blood Pressure & Glucose"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Blood Pressure & Glucose","index":0,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,7,1,9],[1,4,1,6],[0,1,4,3],[0,4,0,9],[3,9,4,9],[3,8,4,8],[3,7,4,7]]}
[null,"Blood Pressure\n& Glucose Tracker",null,null,"Customize the scale values in cells E2 through J5, below."]
[null,null,null,null,"BLOOD PRESSURE",null,null,"GLUCOSE SCALE"]
[null,null,null,null,120,"SYSTOLIC",140,70,100,150]
[null,null,null,null,80,"DIASTOLIC",90,"LOW","NORMAL","HIGH"]
[null,null,null,null,"TARGET PRESSURE",null,"CALL PHYSICIAN"]
[null,"Date","Time","Event","Systolic","Diastolic","Heart Rate","Glucose","Level","Status","Notes"]
[null,{"$f":"TODAY()","v":"2017-10-17"},"06:00:00","Wake",129,79,72,55,{"$f":"BloodPressureAndGlucose[[#This Row],[Glucose]]","v":55},{"$f":"IFERROR(IF(BloodPressureAndGlucose[[#This Row],[Level]]=0,\"\",IF(BloodPressureAndGlucose[[#This Row],[Level]]<=GLow,\"Low\",IF(AND(BloodPressureAndGlucose[[#This Row],[Level]]>GLow,BloodPressureAndGlucose[[#This Row],[Level]]<GHigh),\"Normal\",\"High\"))), \"\")","v":"Low"}]
[null,{"$f":"TODAY()","v":"2017-10-17"},"07:00:00","Before Meal",120,80,74,70,{"$f":"BloodPressureAndGlucose[[#This Row],[Glucose]]","v":70},{"$f":"IFERROR(IF(BloodPressureAndGlucose[[#This Row],[Level]]=0,\"\",IF(BloodPressureAndGlucose[[#This Row],[Level]]<=GLow,\"Low\",IF(AND(BloodPressureAndGlucose[[#This Row],[Level]]>GLow,BloodPressureAndGlucose[[#This Row],[Level]]<GHigh),\"Normal\",\"High\"))), \"\")","v":"Low"}]
[null,"2017-10-17","09:00:00","After Meal",133,80,75,75,{"$f":"BloodPressureAndGlucose[[#This Row],[Glucose]]","v":75},{"$f":"IFERROR(IF(BloodPressureAndGlucose[[#This Row],[Level]]=0,\"\",IF(BloodPressureAndGlucose[[#This Row],[Level]]<=GLow,\"Low\",IF(AND(BloodPressureAndGlucose[[#This Row],[Level]]>GLow,BloodPressureAndGlucose[[#This Row],[Level]]<GHigh),\"Normal\",\"High\"))), \"\")","v":"Normal"}]
[null,"2017-10-17","10:00:00","BP only",143,91,75,190,{"$f":"BloodPressureAndGlucose[[#This Row],[Glucose]]","v":190},{"$f":"IFERROR(IF(BloodPressureAndGlucose[[#This Row],[Level]]=0,\"\",IF(BloodPressureAndGlucose[[#This Row],[Level]]<=GLow,\"Low\",IF(AND(BloodPressureAndGlucose[[#This Row],[Level]]>GLow,BloodPressureAndGlucose[[#This Row],[Level]]<GHigh),\"Normal\",\"High\"))), \"\")","v":"High"}]
[null,"2017-10-17","12:00:00","Before Meal",141,84,70,140,{"$f":"BloodPressureAndGlucose[[#This Row],[Glucose]]","v":140},{"$f":"IFERROR(IF(BloodPressureAndGlucose[[#This Row],[Level]]=0,\"\",IF(BloodPressureAndGlucose[[#This Row],[Level]]<=GLow,\"Low\",IF(AND(BloodPressureAndGlucose[[#This Row],[Level]]>GLow,BloodPressureAndGlucose[[#This Row],[Level]]<GHigh),\"Normal\",\"High\"))), \"\")","v":"Normal"}]
[null,{"$f":"TODAY()","v":"2017-10-17"},"15:00:00","After Meal",132,80,68,90,{"$f":"BloodPressureAndGlucose[[#This Row],[Glucose]]","v":90},{"$f":"IFERROR(IF(BloodPressureAndGlucose[[#This Row],[Level]]=0,\"\",IF(BloodPressureAndGlucose[[#This Row],[Level]]<=GLow,\"Low\",IF(AND(BloodPressureAndGlucose[[#This Row],[Level]]>GLow,BloodPressureAndGlucose[[#This Row],[Level]]<GHigh),\"Normal\",\"High\"))), \"\")","v":"Normal"},"Took BP medication with meal"]
[null,"Averages",null,null,{"$f":"SUBTOTAL(101,BloodPressureAndGlucose[Systolic])","v":133},{"$f":"SUBTOTAL(101,BloodPressureAndGlucose[Diastolic])","v":82.333333333333329},{"$f":"SUBTOTAL(101,BloodPressureAndGlucose[Heart Rate])","v":72.333333333333329},{"$f":"SUBTOTAL(101,BloodPressureAndGlucose[Glucose])","v":103.33333333333333}]