{"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":"完成百分比","v":{"v":0.36666666666666664,"d":"37%"}}]
[null,"开始日期","初始体重","身高"]
[null,"2012-06-01",{"v":210,"d":"210.0"},{"v":7,"d":"7英尺"},{"v":10,"d":"10英寸"}]
[]
[null,"身高（英寸）",null,"BMI",{"$nulls":5},{"$f":"IF(J6>=1,\"祝贺你！\",\"已完成！\")","v":"已完成！"}]
[null,{"$f":"D8*12+E8","v":94},null,{"$f":"(体重/身高^2)*703","v":{"v":16.707786328655498,"d":"17"}}]
[]
[null,"目标体重","期间"]
[null,{"v":180,"d":"180.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":"(体重-目标体重)","v":{"v":30,"d":"30.0"}}]
[{"$nulls":5},{"$f":"目标日期","v":"2012-07-27"},{"$f":"((体重-目标体重)-(LastWeight-目标体重))/(体重-目标体重)","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",205,1500,50,200,20,50,50,125,75,65,10]
[null,"2012-06-02",203,2000,60,200,40,40,64,125,75,63,10]
[null,"2012-06-03",202,2000,55,220,25,35,64,124,75,65,10]
[null,"2012-06-04",202,2000,55,260,45,45,55,135,70,60,10]
[null,"2012-06-05",201,1500,60,250,70,35,100,130,75,60,10]
[null,"2012-06-06",200,1400,50,195,45,40,90,120,75,65,10]
[null,"2012-06-07",202,2000,45,185,75,50,65,120,75,65,10]
[null,"2012-06-08",200,1100,60,250,75,50,60,130,70,65,10]
[null,"2012-06-09",199,1100,80,280,40,50,100,130,75,65,10]
[null,"2012-06-10",197,1800,65,185,60,25,45,130,75,60,10]
[null,"2012-06-11",195,2000,75,240,65,65,90,125,75,55,10]
[null,"2012-06-12",196,2000,60,290,60,50,50,130,75,65,10]
[null,"2012-06-13",194,1300,75,245,75,30,55,120,75,60,10]
[null,"2012-06-14",192,1100,65,275,25,35,75,125,75,60,10]
[null,"2012-06-15",199,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]