{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["儀表板","資料項儀表板目","BMI 資訊"],"not_rendered":{"charts":7,"defined_names":22},"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":"達成百分比","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":"(體重/0.45/(身高/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,{"$f":"C14*LOOKUP(D14,{\"days\",\"months\",\"weeks\"},{1,30,7})","v":56},null,"Date","體重"]
[{"$nulls":5},{"$f":"列印區域","v":"2012-06-01"},{"$f":"(體重/0.45-目標體重/0.45)","v":{"v":30,"d":"30.0"}}]
[{"$nulls":5},{"$f":"目標日期","v":"2012-07-27"},{"$f":"((體重/0.45-目標體重/0.45)-(LastWeight/0.45-目標體重/0.45))/(體重/0.45-目標體重/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":"13% 蛋白質"},{"$f":"SUM(資料[蛋白質])","v":915}]
[null,{"$f":"TEXT(C35/SUM($C$34:$C$38),\"0%\")&\" \"&資料[[#Headers],[碳水化合物]]","v":"51% 碳水化合物"},{"$f":"SUM(資料[碳水化合物])","v":3460}]
[null,{"$f":"TEXT(C36/SUM($C$34:$C$38),\"0%\")&\" \"&資料[[#Headers],[脂肪]]","v":"11% 脂肪"},{"$f":"SUM(資料[脂肪])","v":745}]
[null,{"$f":"TEXT(C37/SUM($C$34:$C$38),\"0%\")&\" \"&資料[[#Headers],[糖類]]","v":"10% 糖類"},{"$f":"SUM(資料[糖類])","v":675}]
[null,{"$f":"TEXT(C38/SUM($C$34:$C$38),\"0%\")&\" \"&資料[[#Headers],[水 (盎司)]]","v":"15% 水 (盎司)"},{"$f":"SUM(資料[水 (盎司)])","v":1018}]
[]
[]
[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,50,125,75,65,10]
[null,"2012-06-02",91.35,2000,60,200,40,40,64,125,75,63,10]
[null,"2012-06-03",90.9,2000,55,220,25,35,64,124,75,65,10]
[null,"2012-06-04",90.9,2000,55,260,45,45,55,135,70,60,10]
[null,"2012-06-05",90.45,1500,60,250,70,35,100,130,75,60,10]
[null,"2012-06-06",90,1400,50,195,45,40,90,120,75,65,10]
[null,"2012-06-07",90.9,2000,45,185,75,50,65,120,75,65,10]
[null,"2012-06-08",90,1100,60,250,75,50,60,130,70,65,10]
[null,"2012-06-09",89.55,1100,80,280,40,50,100,130,75,65,10]
[null,"2012-06-10",88.65,1800,65,185,60,25,45,130,75,60,10]
[null,"2012-06-11",87.75,2000,75,240,65,65,90,125,75,55,10]
[null,"2012-06-12",88.2,2000,60,290,60,50,50,130,75,65,10]
[null,"2012-06-13",87.3,1300,75,245,75,30,55,120,75,60,10]
[null,"2012-06-14",86.4,1100,65,275,25,35,75,125,75,60,10]
[null,"2012-06-15",89.55,1200,60,185,25,75,55,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]