{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["DATA","MEASUREMENTS","WEIGHT & BMI","WEIGHT & BODY FAT"],"not_rendered":{"charts":6,"defined_names":17},"unopened":[{"sheet":"MEASUREMENTS","index":1,"reason":"not_a_worksheet"},{"sheet":"WEIGHT & BMI","index":2,"reason":"not_a_worksheet"},{"sheet":"WEIGHT & BODY FAT","index":3,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"DATA","index":0,"n_rows":12,"n_cols":12,"rows_kept":12,"merged":[[1,1,4,9]]}
[null,"FITNESS PROGRESS CHART for WOMEN"]
[null,"Instructions: Update the data for Height in cells L2 & L3, at right. Replace the sample data in the first seven columns of the Data table, below; the last four (gray) columns will be automatically calculated. Check your progress for MEASUREMENTS, WEIGHT & BMI, and WEIGHT & BODY FAT in their respective charts and worksheets in this workbook.",{"$nulls":8},"Height (m)",{"v":1,"d":"1 "}]
[{"$nulls":10},"Height (cm)",{"v":68,"d":"68 "}]
[{"$nulls":10},"Total (cm)",{"$f":"HeightMeters*100+HeightCentimeters","v":{"v":168,"d":"168 "}}]
[]
[null,"Date","Weight (kg)","Chest (cm)","Waist (cm)","Hips (cm)","Wrist (cm)","Forearm (cm)","Estimated Lean Body Weight","Estimated Body Fat Weight","Estimated Body Fat Percentage","Estimated Body Mass Index (BMI)"]
[null,"2019-01-30",{"v":58.5,"d":"58.50"},{"v":78.7,"d":"78.70"},{"v":66,"d":"66.00"},{"v":88,"d":"88.00"},15.24,24.13,{"$f":"((((Data[[#This Row],[Weight (kg)]]/0.45359)*0.732)+ 8.987)+((Data[[#This Row],[Wrist (cm)]]/2.54)/3.14)-((Data[[#This Row],[Waist (cm)]]/2.54)*0.157)-((Data[[#This Row],[Hips (cm)]]/2.54)*0.249)+((Data[[#This Row],[Forearm (cm)]]/2.54)*0.434))*0.45359","v":{"v":43.87184712423391,"d":"43.87"}},{"$f":"Data[[#This Row],[Weight (kg)]]-Data[[#This Row],[Estimated Lean Body Weight]]","v":{"v":14.62815287576609,"d":"14.63"}},{"$f":"(Data[[#This Row],[Estimated Body Fat Weight]]*100)/Data[[#This Row],[Weight (kg)]]","v":{"v":25.005389531224086,"d":"25.01"}},{"$f":"C7/(TotalHeight/100)^2","v":{"v":20.727040816326532,"d":"20.73"}}]
[null,"2019-02-28",{"v":56.5,"d":"56.50"},{"v":77.7,"d":"77.70"},{"v":65,"d":"65.00"},{"v":86,"d":"86.00"},15.24,23.98,{"$f":"((((Data[[#This Row],[Weight (kg)]]/0.45359)*0.732)+ 8.987)+((Data[[#This Row],[Wrist (cm)]]/2.54)/3.14)-((Data[[#This Row],[Waist (cm)]]/2.54)*0.157)-((Data[[#This Row],[Hips (cm)]]/2.54)*0.249)+((Data[[#This Row],[Forearm (cm)]]/2.54)*0.434))*0.45359","v":{"v":42.5131907230528,"d":"42.51"}},{"$f":"Data[[#This Row],[Weight (kg)]]-Data[[#This Row],[Estimated Lean Body Weight]]","v":{"v":13.986809276947199,"d":"13.99"}},{"$f":"(Data[[#This Row],[Estimated Body Fat Weight]]*100)/Data[[#This Row],[Weight (kg)]]","v":{"v":24.75541464946407,"d":"24.76"}},{"v":20.018424036281182,"d":"20.02"}]
[null,"2019-03-31",{"v":55.5,"d":"55.50"},{"v":76,"d":"76.00"},{"v":64,"d":"64.00"},{"v":84,"d":"84.00"},15.24,{"v":23.7,"d":"23.70"},{"$f":"((((Data[[#This Row],[Weight (kg)]]/0.45359)*0.732)+ 8.987)+((Data[[#This Row],[Wrist (cm)]]/2.54)/3.14)-((Data[[#This Row],[Waist (cm)]]/2.54)*0.157)-((Data[[#This Row],[Hips (cm)]]/2.54)*0.249)+((Data[[#This Row],[Forearm (cm)]]/2.54)*0.434))*0.45359","v":{"v":41.876458909352024,"d":"41.88"}},{"$f":"Data[[#This Row],[Weight (kg)]]-Data[[#This Row],[Estimated Lean Body Weight]]","v":{"v":13.623541090647976,"d":"13.62"}},{"$f":"(Data[[#This Row],[Estimated Body Fat Weight]]*100)/Data[[#This Row],[Weight (kg)]]","v":{"v":24.546920884050405,"d":"24.55"}},{"v":19.664115646258505,"d":"19.66"}]
[null,"2019-04-30",{"v":54.5,"d":"54.50"},{"v":74.6,"d":"74.60"},{"v":62,"d":"62.00"},{"v":82,"d":"82.00"},15.24,{"v":23,"d":"23.00"},{"$f":"((((Data[[#This Row],[Weight (kg)]]/0.45359)*0.732)+ 8.987)+((Data[[#This Row],[Wrist (cm)]]/2.54)/3.14)-((Data[[#This Row],[Waist (cm)]]/2.54)*0.157)-((Data[[#This Row],[Hips (cm)]]/2.54)*0.249)+((Data[[#This Row],[Forearm (cm)]]/2.54)*0.434))*0.45359","v":{"v":41.235212625100054,"d":"41.24"}},{"$f":"Data[[#This Row],[Weight (kg)]]-Data[[#This Row],[Estimated Lean Body Weight]]","v":{"v":13.264787374899946,"d":"13.26"}},{"$f":"(Data[[#This Row],[Estimated Body Fat Weight]]*100)/Data[[#This Row],[Weight (kg)]]","v":{"v":24.33905940348614,"d":"24.34"}},{"v":19.309807256235832,"d":"19.31"}]
[null,"2019-05-31",{"v":57.5,"d":"57.50"},{"v":77,"d":"77.00"},{"v":65,"d":"65.00"},{"v":86,"d":"86.00"},15.24,{"v":24,"d":"24.00"},{"$f":"((((Data[[#This Row],[Weight (kg)]]/0.45359)*0.732)+ 8.987)+((Data[[#This Row],[Wrist (cm)]]/2.54)/3.14)-((Data[[#This Row],[Waist (cm)]]/2.54)*0.157)-((Data[[#This Row],[Hips (cm)]]/2.54)*0.249)+((Data[[#This Row],[Forearm (cm)]]/2.54)*0.434))*0.45359","v":{"v":43.24674078651738,"d":"43.25"}},{"$f":"Data[[#This Row],[Weight (kg)]]-Data[[#This Row],[Estimated Lean Body Weight]]","v":{"v":14.253259213482622,"d":"14.25"}},{"$f":"(Data[[#This Row],[Estimated Body Fat Weight]]*100)/Data[[#This Row],[Weight (kg)]]","v":{"v":24.788276893013258,"d":"24.79"}},{"v":20.37273242630386,"d":"20.37"}]
[null,"2019-06-30",{"v":56.5,"d":"56.50"},{"v":75.5,"d":"75.50"},{"v":64,"d":"64.00"},{"v":85,"d":"85.00"},15.24,{"v":22.8,"d":"22.80"},{"$f":"((((Data[[#This Row],[Weight (kg)]]/0.45359)*0.732)+ 8.987)+((Data[[#This Row],[Wrist (cm)]]/2.54)/3.14)-((Data[[#This Row],[Waist (cm)]]/2.54)*0.157)-((Data[[#This Row],[Hips (cm)]]/2.54)*0.249)+((Data[[#This Row],[Forearm (cm)]]/2.54)*0.434))*0.45359","v":{"v":42.4942399471473,"d":"42.49"}},{"$f":"Data[[#This Row],[Weight (kg)]]-Data[[#This Row],[Estimated Lean Body Weight]]","v":{"v":14.0057600528527,"d":"14.01"}},{"$f":"(Data[[#This Row],[Estimated Body Fat Weight]]*100)/Data[[#This Row],[Weight (kg)]]","v":{"v":24.78895584575699,"d":"24.79"}},{"v":20.018424036281182,"d":"20.02"}]