{"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 で身長のデータを更新します。下のデータ テーブルの最初の 7 つの列でサンプル データを置き換えます。最後の 4 つの列 (灰色) が自動的に計算されます。測定値、体重と 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)","推定除脂肪体重","推定体脂肪重量","推定体脂肪率","推定 Body Mass Index (BMI)"]
[null,{"$f":"TODAY()-25","v":"2018-05-07"},{"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/(TotalHeight/100)^2","v":{"v":20.727040816326532,"d":"20.73"}}]
[null,{"$f":"TODAY()-20","v":"2018-05-12"},{"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-17"},{"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-22"},{"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-27"},{"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-06-01"},{"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"}]