{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["数据","测量值","体重和 BMI","体重和体脂"],"not_rendered":{"charts":6,"defined_names":17},"unopened":[{"sheet":"测量值","index":1,"reason":"not_a_worksheet"},{"sheet":"体重和 BMI","index":2,"reason":"not_a_worksheet"},{"sheet":"体重和体脂","index":3,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"数据","index":0,"n_rows":12,"n_cols":12,"rows_kept":12,"merged":[[1,1,4,9]]}
[null,"女性健身计划图表"]
[null,"说明：更新右侧单元格 L2 和 L3 的身高数据。替换以下数据表前七列中的示例数据；将自动计算最后四（灰色）列。在此工作簿中的各个图表和工作表中查看测量值、体重和 BMI、体重和体脂方面的进展。",{"$nulls":8},"身高 (m)",{"v":1,"d":"1 "}]
[{"$nulls":10},"身高 (cm)",{"v":68,"d":"68 "}]
[{"$nulls":10},"总身高 (cm)",{"$f":"HeightMeters*100+HeightCentimeters","v":{"v":168,"d":"168 "}}]
[]
[null,"日期","体重 (kg)","胸围 (cm)","腰围 (cm)","臀围 (cm)","手腕 (cm)","前臂 (cm)","估计的去脂体重","估计的体脂重量","估计的体脂百分比","估计的身体质量指数 (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":"((((数据[[#This Row],[体重 (kg)]]/0.45359)*0.732)+ 8.987)+((数据[[#This Row],[手腕 (cm)]]/2.54)/3.14)-((数据[[#This Row],[腰围 (cm)]]/2.54)*0.157)-((数据[[#This Row],[臀围 (cm)]]/2.54)*0.249)+((数据[[#This Row],[前臂 (cm)]]/2.54)*0.434))*0.45359","v":{"v":43.83070615407643,"d":"43.83"}},{"$f":"数据[[#This Row],[体重 (kg)]]-数据[[#This Row],[估计的去脂体重]]","v":{"v":14.669293845923569,"d":"14.67"}},{"$f":"(数据[[#This Row],[估计的体脂重量]]*100)/数据[[#This Row],[体重 (kg)]]","v":{"v":25.075715975937726,"d":"25.08"}},{"$f":"C7/(总身高/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":"((((数据[[#This Row],[体重 (kg)]]/0.45359)*0.732)+ 8.987)+((数据[[#This Row],[手腕 (cm)]]/2.54)/3.14)-((数据[[#This Row],[腰围 (cm)]]/2.54)*0.157)-((数据[[#This Row],[臀围 (cm)]]/2.54)*0.249)+((数据[[#This Row],[前臂 (cm)]]/2.54)*0.434))*0.45359","v":{"v":43.83070615407643,"d":"43.83"}},{"$f":"数据[[#This Row],[体重 (kg)]]-数据[[#This Row],[估计的去脂体重]]","v":{"v":14.669293845923569,"d":"14.67"}},{"$f":"(数据[[#This Row],[估计的体脂重量]]*100)/数据[[#This Row],[体重 (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":"((((数据[[#This Row],[体重 (kg)]]/0.45359)*0.732)+ 8.987)+((数据[[#This Row],[手腕 (cm)]]/2.54)/3.14)-((数据[[#This Row],[腰围 (cm)]]/2.54)*0.157)-((数据[[#This Row],[臀围 (cm)]]/2.54)*0.249)+((数据[[#This Row],[前臂 (cm)]]/2.54)*0.434))*0.45359","v":{"v":43.83070615407643,"d":"43.83"}},{"$f":"数据[[#This Row],[体重 (kg)]]-数据[[#This Row],[估计的去脂体重]]","v":{"v":14.669293845923569,"d":"14.67"}},{"$f":"(数据[[#This Row],[估计的体脂重量]]*100)/数据[[#This Row],[体重 (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":"((((数据[[#This Row],[体重 (kg)]]/0.45359)*0.732)+ 8.987)+((数据[[#This Row],[手腕 (cm)]]/2.54)/3.14)-((数据[[#This Row],[腰围 (cm)]]/2.54)*0.157)-((数据[[#This Row],[臀围 (cm)]]/2.54)*0.249)+((数据[[#This Row],[前臂 (cm)]]/2.54)*0.434))*0.45359","v":{"v":43.83070615407643,"d":"43.83"}},{"$f":"数据[[#This Row],[体重 (kg)]]-数据[[#This Row],[估计的去脂体重]]","v":{"v":14.669293845923569,"d":"14.67"}},{"$f":"(数据[[#This Row],[估计的体脂重量]]*100)/数据[[#This Row],[体重 (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":"((((数据[[#This Row],[体重 (kg)]]/0.45359)*0.732)+ 8.987)+((数据[[#This Row],[手腕 (cm)]]/2.54)/3.14)-((数据[[#This Row],[腰围 (cm)]]/2.54)*0.157)-((数据[[#This Row],[臀围 (cm)]]/2.54)*0.249)+((数据[[#This Row],[前臂 (cm)]]/2.54)*0.434))*0.45359","v":{"v":43.83070615407643,"d":"43.83"}},{"$f":"数据[[#This Row],[体重 (kg)]]-数据[[#This Row],[估计的去脂体重]]","v":{"v":14.669293845923569,"d":"14.67"}},{"$f":"(数据[[#This Row],[估计的体脂重量]]*100)/数据[[#This Row],[体重 (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":"((((数据[[#This Row],[体重 (kg)]]/0.45359)*0.732)+ 8.987)+((数据[[#This Row],[手腕 (cm)]]/2.54)/3.14)-((数据[[#This Row],[腰围 (cm)]]/2.54)*0.157)-((数据[[#This Row],[臀围 (cm)]]/2.54)*0.249)+((数据[[#This Row],[前臂 (cm)]]/2.54)*0.434))*0.45359","v":{"v":43.83070615407643,"d":"43.83"}},{"$f":"数据[[#This Row],[体重 (kg)]]-数据[[#This Row],[估计的去脂体重]]","v":{"v":14.669293845923569,"d":"14.67"}},{"$f":"(数据[[#This Row],[估计的体脂重量]]*100)/数据[[#This Row],[体重 (kg)]]","v":{"v":25.075715975937726,"d":"25.08"}},{"v":20.727040816326532,"d":"20.73"}]