{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Data","Report","Plan","Reference"],"not_rendered":{"charts":10,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Data","index":0,"n_rows":95,"n_cols":31,"rows_kept":95,"cut":false,"hidden":false,"merged":[[3,14,9,27],[0,27,0,30],[11,7,12,7],[0,13,0,14],[0,0,0,6],[11,12,12,12],[11,3,11,5],[11,6,12,6],[11,8,12,8],[11,9,12,9],[11,10,12,10],[11,11,12,11],[94,1,94,2],[50,14,63,27],[11,13,11,15],[11,20,11,27],[11,1,11,2]]}
["Blood Glucose Control Chart",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2014-08-02"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Health Tracker Version 7a (2014-08-01)"]
[]
["Report for:","JohnW",null,null,null,null," ",null,null,null,null,null,null,null,"Notes:"]
["Start date:","2014-08-01",null,null,null,null," ",null," ",null,null,null,null,null,"This data table and contents can be easily modified to suit.  The number of samples per day can also be reduced. If Sampe 2 and 3 are removed, then change the macros for Mean and Standard Deviation. Take Sample1 before breakfast (ie. overnight fasting). Enter month Start Date in cell B8.\nVary the tolerance levels (UCL and LCL) by changing the desired Control Limit value at B10.  (1s - 100%, 2s - 200%, 3s - 300%).\nDesired Weight and Waist measurements are set for males (Reduce for females as appropriate)\n(Suggestion - Change initial values in columns D, N, O, P, U and X to averages from previous month)\n  Version 6 - Added tracking for waist size"]
["End date:",{"$f":"B44","v":"2014-08-31"},null,null," ",null,null,null,null,null,null,null,null," "]
[null,null,null," "]
["Blood Glucose Unit:","mmol/L"]
["Control Limits:",1,null,null," "]
["Desired Weight:",80,"(kg)"]
["Desired Stomach:",108,"(cm)"]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[" ","Sample Date",null,"Blood Glucose",null,null,"Mean (Daily Average)","Sample Mean (Average of All Sample1)","Sample Mean (Average of All Means)","Standard Deviation (since day 1)","Standard Deviation (for month)","Lower Control Limit","Upper Control Limit","Blood Pressure",null,null,null,null,null,null,"Other Health Factors"]
[" ","Date","Time","Sample 1 (Morning)","Sample 2","Sample 3",null,null,null,null,null,null,null,"Systolic","Diastolic","Pulse","(UCL Syst)","(Av Syst)","(UCL Diast)","(Av Diast)","Weight (Kg)","Av. Weight","Desired Target Weight","Stomach (cm)","Av. Waist","Desired Target Waist","Diet","Medication / Exercise"]
[" ",{"$f":"$B$4","v":"2014-08-01"},"06:00:00",6.5,{"$f":"AVERAGE(D14)","v":6.5},{"$f":"AVERAGE(D14:E14)","v":6.5},{"$f":"AVERAGE(D14:F14)","v":6.5},{"$f":"AVERAGE($D$14:$D$44)","v":6.5032258064516126},{"$f":"AVERAGE($G$14:$G$44)","v":6.5032258064516126},{"$f":"STDEV($D$14:F14)","v":0},{"$f":"AVERAGE($J$14:$J$44)","v":5.7303981810390831E-4},{"$f":"I14-($B$8*K14)","v":6.502652766633509},{"$f":"I14+($B$8*K14)","v":6.5037988462697163},130,80,85,139,131.87096774193549,89,82.096774193548384,83,83.787096774193543,80,110,{"$f":"AVERAGE($X$14:$X$44)","v":110},{"$f":"$B$10","v":108},"Fair"," "]
[" ",{"$f":"B14+1","v":"2014-08-02"},"06:00:00",6.5,6.5,6.5,6.5,{"$f":"AVERAGE($D$14:$D$44)","v":6.5032258064516126},6.5032258064516126,{"$f":"STDEV($D$14:F15)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,{"$f":"AVERAGE($N$14:$N$44)","v":130},89,{"$f":"AVERAGE($O$14:$O$44)","v":80},83,{"$f":"AVERAGE($U$14:$U$44)","v":83},{"$f":"$B$9","v":80},110,{"$f":"AVERAGE($X$14:$X$44)","v":110},{"$f":"$B$10","v":108},"Fair"," "]
[" ",{"$f":"B15+1","v":"2014-08-03"},"06:00:00",6.5,{"$f":"AVERAGE(D16)","v":6.5},{"$f":"AVERAGE(D16:E16)","v":6.5},6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F16)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-04","06:00:00",6.5,{"$f":"AVERAGE(D17)","v":6.5},{"$f":"AVERAGE(D17:E17)","v":6.5},6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F17)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-05","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F18)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-06","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F19)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-07","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F20)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-08","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F21)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-09","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F22)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-10","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F23)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-11","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F24)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[" ","2014-08-12","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F25)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-13","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F26)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-14","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F27)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-15","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F28)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-16","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F29)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-17","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F30)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-18","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F31)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-19","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F32)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-20","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F33)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-21","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F34)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-22","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F35)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-23","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F36)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-24","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F37)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-25","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F38)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-26","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F39)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-27","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F40)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-28","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F41)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-29","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F42)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-30","06:00:00",6.5,6.5,6.5,6.5,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F43)","v":0},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[null,"2014-08-31","06:00:00",6.6,{"$f":"AVERAGE(D44)","v":6.6},{"$f":"AVERAGE(D44:E44)","v":6.6},6.5999999999999988,6.5032258064516126,6.5032258064516126,{"$f":"STDEV($D$14:F44)","v":1.7764234361221157E-2},5.7303981810390831E-4,6.502652766633509,6.5037988462697163,130,80,85,139,130,89,80,83,83,80,110,110,108,"Fair"," "]
[" ",null,null,{"$f":"AVERAGE(D14:D44)","v":6.5032258064516126}," ",{"$f":"AVERAGE($G$14:$G$44)","v":6.5032258064516126},null,null,null,null,null," ",null,{"$f":"AVERAGE(N14:N44)","v":130},{"$f":"AVERAGE(O14:O44)","v":80},85,null,null,null,null,{"$f":"AVERAGE(U14:U44)","v":83}," ",null,{"$f":"AVERAGE(X14:X44)","v":110}]
[]
[" "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Notes:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\nThe monthly progress data collects accumulated month averages for tracking progress over the full year.\n\nAt the start of end of each month, the final averges should be copied and pasted (values only) into the appropriate row. All accumulative values in this table should be then carried across to the templated used to create a new month HealthTracker.\n\nThe progress bar graphs are generated in the Report worksheet.\n\nSome individual customisation of charts may be advised to adjust vertical column (axis) dimensions. Right click on required axis in the Report chart, then selct \"format Axis\". This should apply for weight and stomach measurements only."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Monthly Progress Data"]
[]
[]
[]
[]
[" ",null,null,"Month Avg. Sugar Fasting"," ","Month Avg. Blood Sugar",null,null,null,null,null,null,null,"Month Avg. - Systolic","Month Avg. - Dyastolic","Month Avg. - Pulse",null,null,null,null,"Month Avg. Weight (Kg)","Av. Weight","Desired Target Weight","Month Avg. Stomach"]
[null,null,"NOV"," "," "," ",null,null,null,null," ",null,138," "," "," ",null,null,null,83.2," "," ",null," "]
[null,null,"DEC"," ",null," ",null,null,null,null," ",null,134," "," "," ",null,null,null,82.6," ",null,null," "]
[null,null,"JAN"," ",null," ",null,null,null,null,null," ",null," "," "," ",null,null,null,null," "," ",null," "]
[null,null,"FEB"," ",null," ",null,null,null,null,null," ",null," "," "," ",null,null,null,null," "," ",null," "]
[null,null,"MAR"," ",null," ",null,null,null,null,null," ",null," "," "," ",null,null,null,null," ",null,null," "]
[null,null,"APR"," ",null," ",null,null,null,null,null," ",null," "," "," ",null,null,null,null," "," ",null," "]
[null,null,"MAY"," ",null," ",null,null,null,null,null,null,null," "," "," ",null,null,null,null," ",null,null," "]
[null,null,"JUN"," ",null," ",null,null,null,null,null,null,null," "," "," ",null,null,null,null," ",null,null," "]
[null,null,"JUL"," "," "," ",null,null,null,null,null," ",null," "," "," ",null,null,null,null," "," ",null," "]
[null,null,"AUG"," "," "," ",null,null,null,null,null," ",null," "," "," ",null,null,null,null," "," ",null," "]
[null,null,"SEP"," "," "," ",null,null,null,null,null," ",null," "," "," ",null,null,null,null," "," ",null," "]
[null,null,"OCT"," "," "," ",null,null,null,null,null," ",null," "," "," ",null,null,null,null," "," ",null," "]
[null,null,"NOV"," "," "," ",null,null,null,null,null," ",null," "," "," ",null,null,null,null," "," ",null," "]
[null,null,"DEC"," "," "," ",null,null,null,null,null," ",null," "," "," ",null,null,null,null," "," ",null," "]
[null,null,null," "," "," ",null,null,null,null,null," ",null," "," "," ",null,null,null,null," "," ",null," "]
[]
[null,"Current Month Avg.",null,{"$f":"AVERAGE($D14:$D44)","v":6.5032258064516126}," ",{"$f":"AVERAGE($G$14:$G$44)","v":6.5032258064516126},null,null,null,null,null," ",null,{"$f":"AVERAGE($N14:$N44)","v":130},{"$f":"AVERAGE($O14:$O44)","v":80},{"$f":"AVERAGE($P14:$P44)","v":85},null,null,null,null,{"$f":"AVERAGE($U14:$U44)","v":83}," ",null,{"$f":"AVERAGE($X14:$X44)","v":110}]

{"sheet":"Report","index":1,"n_rows":171,"n_cols":12,"rows_kept":171,"cut":false,"hidden":false,"merged":[[0,11,0,12]]}
["Health Trend Reports",null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2014-08-02"}]
[]
[]
[]
[]
["Blood"]
["Pressure"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Weight"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]

{"sheet":"Plan","index":2,"n_rows":65,"n_cols":8,"rows_kept":65,"cut":false,"hidden":false,"merged":[[20,0,20,2],[0,0,0,2],[20,3,20,4],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[33,3,33,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[44,3,44,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[50,3,50,4],[51,3,51,4],[52,3,52,4],[62,3,62,4],[53,3,53,4],[54,3,54,4],[55,3,55,4],[56,3,56,4],[57,3,57,4],[58,1,58,2],[59,1,59,2],[60,1,60,2],[61,1,61,2],[58,3,58,4],[59,3,59,4],[60,3,60,4],[61,3,61,4],[62,1,62,2],[63,1,63,2],[64,1,64,2],[33,0,39,0],[63,3,63,4],[64,3,64,4],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[57,1,57,2]]}
["Analysis and Improvement Plan",null,null,{"$f":"TODAY()","v":"2014-08-02"},{"$f":"Data!AB1","v":"Health Tracker Version 7a (2014-08-01)"}]
[]
["Health Risk Factor","Severity","Impact","Self-Assessment\n(or Medical Assessments)","Improvement or  Mitigation Plan","Percent of Total","Cumulative %","Line Value"]
["Diet: Over-eating",10,20,"General diet is good, but still too much snacking","1. Contiuous (daily) focus on both diet and food intake\n2. Reduce causes for \"snacking\" - stress and anziety for a start",{"$f":"(C4*100/$C$19)","v":14.184397163120567},{"$f":"F4","v":14.184397163120567},{"$f":"$B$23","v":80}]
["Diet: Sugar product intake",9,18,"Needs greater self control","1.  Have been using sugar sometimes in tea - will completely remove\n2.  Will reduce any cake, biscuit or dessert to 1 per fortnight",12.76595744680851,{"$f":"(G4+F5)","v":26.950354609929079},{"$f":"$B$23","v":80}]
["Abdominal Fat (Waistline)",9,16,"This defect has developed over many years, and has no overnight solution","1. Should start to see improvement if I maintain all other actions\n2. Gym and crunches will help but is not main solution",11.347517730496454,{"$f":"(G5+F6)","v":38.297872340425535},80]
["Over-weight",8,15,"About 5kg above optimum; BMI = 26","1. Concentrate more on daily diet and food intake\n2. Restart gym visits (when it re-opens)",10.638297872340425,48.936170212765958,80]
["Diet: Poor nutrition",7,12,"Need to improve ratio of salads, fresh vegies and fruit to meats and carbs ","1. Better diet management\n2.  ork harde on maintaing a daily regimen",8.5106382978723403,57.446808510638299,80]
["High Blood Pressure",7,11,"12/01/14 This seems to be getting well under control, due to better sleep, intense walking  etc","1.  Increase the consistency and distance of daily walks.\n2.  Improve sleeping times and length.  3. Keep working on reducing stress levels",7.8014184397163122,65.248226950354606,80]
["Excessive Stress / Anxiety",6,9,"A number of factors","1. Daily walks, and weekly gym work-outs\n2. Move to Better and consistent sleep patterns",6.3829787234042552,71.631205673758856,80]
["Diet: High fat intake",5,8,"Too much meat and butter in diet","1. Reduce or limit meat in diet\n2. Use low-fat spreads to replace butter",5.6737588652482271,77.304964539007088,80]
["Lack of general fitness",5,7,"Due to work anxieties and lack of consistent, restful sleeo","1. Aim to get more consistent sleep\n2. Gym work helps, but longer walks (at reasonable pace) are better",4.9645390070921982,82.269503546099287,80]
["Lack of Sleep / Poor Sleep",6,6,"Need to have improved sleep time patterns","1. Reduce late nights.  2.  Minimise low sugar levels overnght (vary Glimel)",4.2553191489361701,86.524822695035454,80]
["No Gym or Sport activity",7,5,null,null,3.5460992907801416,90.070921985815602,80]
["Poor Cholesterol Levels",5,5," ",null,3.5460992907801416,93.61702127659575,80]
["Medication Balance",4,4,null," ",2.8368794326241136,96.453900709219866,80]
["Lack of Physical Activity",5,3,null,null,2.1276595744680851,98.581560283687949,80]
["Sedentary Work Practice",3,2,null,null,1.4184397163120568,100,80]
["Totals",{"$f":"SUM(B4:B18)","v":96},{"$f":"SUM(C4:C18)","v":141},null," ",{"$f":"SUM(F4:F18)","v":100},{"$f":"G18","v":100}]
[null,null,null,null," "]
["( <--  Sort on C then B for these cells A3 through to E18  -->  )",null,null,"Severity / Impact Level Guidance"]
[null,null,null,"0.   No issues or Impact; Monitor only","10.  A number of issues; minimal control; noticeable impact"]
["Set Line Value:",80,null,"1.   Negligible issues; No Impact; Monitor & control","12.  Frequent issues; minimal control; undesirable impact"]
[null,null,null,"2.   Negligible issues or Impact; Monitor and control","14.  Frequent issues; poor control; medium impact"]
[" ",null,null,"4.   Minimal issues; Minimal impact; Well controlled","16.  Frequent issues; poor control; high impact"]
[null,null,null,"6.   Occasional issues; Some Impact; Some control","18.  Many issues; very poor control; very high impact"]
[null,null,null,"8.   Number of issues; Noticeable impact; Basic control","20, Critical issue and impact / completely out of control"]
[" ",null,null," "," "]
[null," "]
[]
[]
[]
[]
[" Daily Notes and Analysis on Data Results","Date",null,"Daily Observations and Suggestions"]
[null,{"$f":"Data!$B$4","v":"2014-08-01"}]
[null,{"$f":"B35+1","v":"2014-08-02"},null," "]
[null,"2014-08-03",null," "]
[null,"2014-08-04",null," "]
[null,"2014-08-05"]
[null,"2014-08-06",null," "]
[null,"2014-08-07"]
[null,"2014-08-08"]
[null,"2014-08-09",null," "]
[null,"2014-08-10",null," "]
[null,"2014-08-11",null," "]
[null,"2014-08-12",null," "]
[null,"2014-08-13",null," "]
[null,"2014-08-14",null," "]
[null,"2014-08-15"]
[null,"2014-08-16"]
[null,"2014-08-17",null," "]
[null,"2014-08-18",null," "]
[null,"2014-08-19"]
[null,"2014-08-20",null," "]
[null,"2014-08-21"]
[null,"2014-08-22"]
[null,"2014-08-23"]
[null,"2014-08-24"]
[null,"2014-08-25"]
[null,"2014-08-26",null," "]
[null,"2014-08-27"]
[null,"2014-08-28"]
[null,"2014-08-29"]
[null,"2014-08-30",null," "]
[null,"2014-08-31",null," "]

{"sheet":"Reference","index":3,"n_rows":46,"n_cols":4,"rows_kept":46,"cut":false,"hidden":true,"merged":[]}
["Diet","Comments"]
["Excellent","Conforming all day (No sugar, cheese, bread, fat, excesses)"]
["Good","Minor deviation;  Conforming afternoon / evening"]
["Fair","Reasonable day diet; conforming in evening"]
["Poor","Some deviations; especially evening"]
["Bad","Totally lost the plot"]
[]
[{"$f":"TODAY()","v":"2014-08-02"},"Chart Titles"]
["Chart1",{"$f":"\"Blood Pressure Chart  \"&TEXT($A$8,\"yyyy-mm-dd\")&\"  (\"&Data!$B$3&\")\"","v":"Blood Pressure Chart  2014-08-02  (JohnW)"}]
["Chart2",{"$f":"\"Weight Control Chart  \"&TEXT($A$8,\"yyyy-mm-dd\")&\"  (\"&Data!$B$3&\")\"","v":"Weight Control Chart  2014-08-02  (JohnW)"}]
["Chart3",{"$f":"\"Daily Glucose Levels (mmol/L) - Average  \"&TEXT($A$8,\"yyyy-mm-dd\")&\"  (\"&Data!$B$3&\")\"","v":"Daily Glucose Levels (mmol/L) - Average  2014-08-02  (JohnW)"}]
["Chart4",{"$f":"\"Daily Glucose Levels (mmol/L) - Fasting  \"&TEXT($A$8,\"yyyy-mm-dd\")&\"  (\"&Data!$B$3&\")\"","v":"Daily Glucose Levels (mmol/L) - Fasting  2014-08-02  (JohnW)"}]
["Chart5",{"$f":"\"Pareto Analysis  \"&TEXT($A$8,\"yyyy-mm-dd\")&\"  (\"&Data!$B$3&\")\"","v":"Pareto Analysis  2014-08-02  (JohnW)"}]
["Chart6",{"$f":"\"Waist/Stomach Control Chart  \"&TEXT($A$8,\"yyyy-mm-dd\")&\"  (\"&Data!$B$3&\")\"","v":"Waist/Stomach Control Chart  2014-08-02  (JohnW)"}]
["Chart7",{"$f":"\"Monthly Sugar Level Averages  \"&TEXT($A$8,\"yyyy\")&\"  (\"&Data!$B$3&\")\"","v":"Monthly Sugar Level Averages  2014  (JohnW)"}]
["Chart8",{"$f":"\"Monthly Blood Pressure Averages  \"&TEXT($A$8,\"yyyy\")&\"  (\"&Data!$B$3&\")\"","v":"Monthly Blood Pressure Averages  2014  (JohnW)"}]
["Chart9",{"$f":"\"Monthly Weight Averages  \"&TEXT($A$8,\"yyyy\")&\"  (\"&Data!$B$3&\")\"","v":"Monthly Weight Averages  2014  (JohnW)"}]
["Chart10",{"$f":"\"Monthly Stomach Measurements  \"&TEXT($A$8,\"yyyy\")&\"  (\"&Data!$B$3&\")\"","v":"Monthly Stomach Measurements  2014  (JohnW)"}]
[null,null,null," "]
["Level","Severity / Impact"]
[0,"No issues or Impact, but need to monitor and control"]
[1]
[2,"Negligible issues; no Impact; completely under control"]
[3]
[4,"Minimal issues; well controlled; minimal impact"]
[5]
[6,"Occasional issues; some control; some impact"]
[7]
[8,"A number of issues; basic control; noticeable impact"]
[9]
[10,"A number of issues; minimal control; noticeable impact"]
[11]
[12,"Frequent issues; minimal control; undesirable impact"]
[13]
[14,"Frequent issues; poor control; medium impact"]
[15]
[16,"Frequent issues; poor control; high impact"]
[17]
[18,"Many issues; very poor control; very high impact"]
[19]
[20,"Critical issue and impact / completely out of control"]
[" "]
[" "]
[" "]
[" "]
[" "]