{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["대시보드","데이터 입력","BMI 정보"],"not_rendered":{"charts":7,"external_links":1,"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",94.5,{"v":5,"d":"5FT"},{"v":10,"d":"10IN"}]
[]
[null,"신장(cm)",null,"BMI",{"$nulls":5},{"$f":"IF(J6>=1,\"축하합니다\",\" 진행률\")","v":" 진행률"}]
[null,{"$f":"D8*12+E8","v":70},null,{"$f":"(체중/0.45/신장^2)*703","v":{"v":30.12857142857143,"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]