{"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 and L3 to the right. Replace the sample data in the first seven columns of the data table below; the last four (grey) 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)",1]
[{"$nulls":10},"Height (cm)",68]
[{"$nulls":10},"Total (cm)",{"$f":"HeightMetres*100+HeightCentimetres","v":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,{"$f":"TODAY()-25","v":"2018-05-06"},{"v":58.5,"d":"58.50"},{"v":78.7,"d":"78.70"},66.04,{"v":88.9,"d":"88.90"},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.83070615407643,"d":"43.83"}},{"$f":"Data[[#This Row],[Weight (kg)]]-Data[[#This Row],[Estimated lean body weight]]","v":{"v":14.669293845923569,"d":"14.67"}},{"$f":"(Data[[#This Row],[Estimated body fat weight]]*100)/Data[[#This Row],[Weight (kg)]]","v":{"v":25.075715975937726,"d":"25.08"}},{"$f":"C7/(TotalHeight/100)^2","v":{"v":20.727040816326532,"d":"20.73"}}]
[null,{"$f":"TODAY()-20","v":"2018-05-11"},{"v":58.5,"d":"58.50"},{"v":78.7,"d":"78.70"},66.04,{"v":88.9,"d":"88.90"},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.83070615407643,"d":"43.83"}},{"$f":"Data[[#This Row],[Weight (kg)]]-Data[[#This Row],[Estimated lean body weight]]","v":{"v":14.669293845923569,"d":"14.67"}},{"$f":"(Data[[#This Row],[Estimated body fat weight]]*100)/Data[[#This Row],[Weight (kg)]]","v":{"v":25.075715975937726,"d":"25.08"}},{"v":20.727040816326532,"d":"20.73"}]
[null,{"$f":"TODAY()-15","v":"2018-05-16"},{"v":58.5,"d":"58.50"},{"v":78.7,"d":"78.70"},66.04,{"v":88.9,"d":"88.90"},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.83070615407643,"d":"43.83"}},{"$f":"Data[[#This Row],[Weight (kg)]]-Data[[#This Row],[Estimated lean body weight]]","v":{"v":14.669293845923569,"d":"14.67"}},{"$f":"(Data[[#This Row],[Estimated body fat weight]]*100)/Data[[#This Row],[Weight (kg)]]","v":{"v":25.075715975937726,"d":"25.08"}},{"v":20.727040816326532,"d":"20.73"}]
[null,{"$f":"TODAY()-10","v":"2018-05-21"},{"v":58.5,"d":"58.50"},{"v":78.7,"d":"78.70"},66.04,{"v":88.9,"d":"88.90"},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.83070615407643,"d":"43.83"}},{"$f":"Data[[#This Row],[Weight (kg)]]-Data[[#This Row],[Estimated lean body weight]]","v":{"v":14.669293845923569,"d":"14.67"}},{"$f":"(Data[[#This Row],[Estimated body fat weight]]*100)/Data[[#This Row],[Weight (kg)]]","v":{"v":25.075715975937726,"d":"25.08"}},{"v":20.727040816326532,"d":"20.73"}]
[null,{"$f":"TODAY()-5","v":"2018-05-26"},{"v":58.5,"d":"58.50"},{"v":78.7,"d":"78.70"},66.04,{"v":88.9,"d":"88.90"},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.83070615407643,"d":"43.83"}},{"$f":"Data[[#This Row],[Weight (kg)]]-Data[[#This Row],[Estimated lean body weight]]","v":{"v":14.669293845923569,"d":"14.67"}},{"$f":"(Data[[#This Row],[Estimated body fat weight]]*100)/Data[[#This Row],[Weight (kg)]]","v":{"v":25.075715975937726,"d":"25.08"}},{"v":20.727040816326532,"d":"20.73"}]
[null,{"$f":"TODAY()","v":"2018-05-31"},{"v":58.5,"d":"58.50"},{"v":78.7,"d":"78.70"},66.04,{"v":88.9,"d":"88.90"},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.83070615407643,"d":"43.83"}},{"$f":"Data[[#This Row],[Weight (kg)]]-Data[[#This Row],[Estimated lean body weight]]","v":{"v":14.669293845923569,"d":"14.67"}},{"$f":"(Data[[#This Row],[Estimated body fat weight]]*100)/Data[[#This Row],[Weight (kg)]]","v":{"v":25.075715975937726,"d":"25.08"}},{"v":20.727040816326532,"d":"20.73"}]