{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["ダッシュボード","データ入力","BMI 情報"],"not_rendered":{"charts":7,"defined_names":20},"read":"whole","date_system":"1900"}

{"sheet":"ダッシュボード","index":0,"n_rows":41,"n_cols":10,"rows_kept":41,"merged":[[4,1,4,4],[5,9,8,10],[9,1,9,2],[9,9,9,10],[12,2,12,3],[13,3,13,4],[15,3,15,4],[16,1,16,2]]}
[]
[]
[]
[]
[null," 開始時の詳細データと目標",{"$nulls":4},"目標に向けた全体的な進捗"]
[{"$nulls":9},{"$f":"PercentThere","v":{"v":0.36666666666666664,"d":"37%"}}]
[null,"開始日","開始時体重","身長"]
[null,"2012-06-01",94.5,{"v":1,"d":"1M"},{"v":78,"d":"78CM"}]
[]
[null,"身長 (センチ単位の計算)",null,"BMI (体格指数)",{"$nulls":5},{"$f":"IF(J6>=1,\"おめでとうございます !\",\"がんばってください!\")","v":"がんばってください!"}]
[null,{"$f":"(D8*100+E8)","v":178},null,{"$f":"(Weight/0.45/(Height/2.54)^2)*703","v":{"v":30.060904809998743,"d":"30"}}]
[]
[null,"目標体重","対象期間"]
[null,{"v":81,"d":"81.0"},8,"か月"]
[]
[null,"目標日",null,"合計日数"]
[null,{"$f":"B8+D17","v":"2012-07-27"},null,56,null,"Date","Weight"]
[{"$nulls":5},{"$f":"StartDate","v":"2012-06-01"},{"$f":"(Weight/0.45-TargetWeight/0.45)","v":{"v":30,"d":"30.0"}}]
[{"$nulls":5},{"$f":"TargetDate","v":"2012-07-27"},{"$f":"((Weight/0.45-TargetWeight/0.45)-(LastWeight/0.45-TargetWeight/0.45))/(Weight/0.45-TargetWeight/0.45)","v":{"v":0.36666666666666664,"d":"36.67%"}}]
[null,"体重と消費カロリー"]
{"$rows_empty":9}
[null,"摂取の傾向"]
[]
[]
[]
[null,{"$f":"TEXT(C34/SUM($C$34:$C$38),\"0%\")&\" \"&データ[[#Headers],[タンパク質]]","v":"16% タンパク質"},{"$f":"SUM(データ[タンパク質])","v":915}]
[null,{"$f":"TEXT(C35/SUM($C$34:$C$38),\"0%\")&\" \"&データ[[#Headers],[炭水化物]]","v":"59% 炭水化物"},{"$f":"SUM(データ[炭水化物])","v":3460}]
[null,{"$f":"TEXT(C36/SUM($C$34:$C$38),\"0%\")&\" \"&データ[[#Headers],[脂肪]]","v":"13% 脂肪"},{"$f":"SUM(データ[脂肪])","v":745}]
[null,{"$f":"TEXT(C37/SUM($C$34:$C$38),\"0%\")&\" \"&データ[[#Headers],[糖分]]","v":"12% 糖分"},{"$f":"SUM(データ[糖分])","v":675}]
[null,{"$f":"TEXT(C38/SUM($C$34:$C$38),\"0%\")&\" \"&データ[[#Headers],[水 (リットル)]]","v":"1% 水 (リットル)"},{"$f":"SUM(データ[水 (リットル)])","v":30.54}]
[]
[]
[null,"VITALS TREND"]

{"sheet":"データ入力","index":1,"n_rows":21,"n_cols":13,"rows_kept":21,"merged":[[4,4,4,8],[4,9,4,12]]}
[]
[]
[]
[]
[{"$nulls":4},"摂取",{"$nulls":4},"身体機能"]
[null,"日付","体重","消費カロリー","タンパク質","炭水化物","脂肪","糖分","水 (リットル)","最高血圧","最低血圧","安静時心拍数","呼吸数"]
[null,"2012-06-01",92.25,1500,50,200,20,50,1.5,125,75,65,10]
[null,"2012-06-02",91.35,2000,60,200,40,40,1.92,125,75,63,10]
[null,"2012-06-03",90.9,2000,55,220,25,35,1.92,124,75,65,10]
[null,"2012-06-04",90.9,2000,55,260,45,45,1.65,135,70,60,10]
[null,"2012-06-05",90.45,1500,60,250,70,35,3,130,75,60,10]
[null,"2012-06-06",90,1400,50,195,45,40,2.7,120,75,65,10]
[null,"2012-06-07",90.9,2000,45,185,75,50,1.95,120,75,65,10]
[null,"2012-06-08",90,1100,60,250,75,50,1.8,130,70,65,10]
[null,"2012-06-09",89.55,1100,80,280,40,50,3,130,75,65,10]
[null,"2012-06-10",88.65,1800,65,185,60,25,1.35,130,75,60,10]
[null,"2012-06-11",87.75,2000,75,240,65,65,2.7,125,75,55,10]
[null,"2012-06-12",88.2,2000,60,290,60,50,1.5,130,75,65,10]
[null,"2012-06-13",87.3,1300,75,245,75,30,1.65,120,75,60,10]
[null,"2012-06-14",86.4,1100,65,275,25,35,2.25,125,75,60,10]
[null,"2012-06-15",89.55,1200,60,185,25,75,1.65,130,75,55,10]

{"sheet":"BMI 情報","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"merged":[[12,1,12,3]]}
["   "]
[]
[]
[]
[]
[null,"BMI カテゴリ","下限","上限"]
[null,"体重不足",0,18.49]
[null,"正常体重",18.5,24.99]
[null,"体重超過",25,29.99]
[null,"肥満 (クラス 1)",30,34.99]
[null,"肥満 (クラス 2)",35,39.99]
[null,"病的な肥満",40]