{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["GOALS","DIET","EXERCISE","Chart Calculations"],"not_rendered":{"charts":2,"defined_names":24},"read":"whole","date_system":"1900"}

{"sheet":"GOALS","index":0,"n_rows":40,"n_cols":3,"rows_kept":40,"merged":[[0,0,2,0],[3,0,4,0],[5,0,8,0],[7,2,8,10],[9,0,10,0],[11,0,14,0],[15,0,16,0],[17,0,20,0],[19,2,20,10],[21,0,22,0],[23,0,26,0],[27,0,28,0],[29,0,32,0],[33,0,34,0],[35,0,38,0],[39,0,40,0]]}
["2013-03-01"]
[]
[null,null,"GOALS"]
["START DATE",null,"DIET & EXERCISE JOURNAL"]
[]
["2013-07-30"]
[]
[null,null,"DIETARY ANALYSIS"]
[]
["END DATE"]
[]
[{"v":220,"d":"220.00"}]
[]
[]
[]
["START WEIGHT"]
[]
[{"v":180,"d":"180.00"}]
[]
[null,null,"EXERCISE ANALYSIS"]
[]
["END WEIGHT"]
[]
[{"$f":"StartWeight-EndWeight","v":40}]
[]
[]
[]
["GOAL LOSS"]
[]
[{"$f":"EndDate-StartDate","v":151}]
[]
[]
[]
["DAYS TO LOSE"]
[]
[{"$f":"WeightGoal/A30","v":{"v":0.26490066225165565,"d":"0.26"}}]
[]
[]
[]
["LOSS PER DAY"]

{"sheet":"DIET","index":1,"n_rows":20,"n_cols":9,"rows_kept":20}
[]
[null,"DIET"]
[null,{"$f":"Subtitle","v":"DIET & EXERCISE JOURNAL"}]
[]
[null,"DATE","TIME","DESCRIPTION","CALORIES","CARBS","SUGARS","FIBER","NOTES"]
[null,"2013-03-01","07:00:00","Coffee",10,10,0,0,"Morning coffee"]
[null,"2013-03-01","08:00:00","Bagel",10,10,2,10,"Light breakfast"]
[null,"2013-03-01","12:00:00","Lunch",350,35,12,45,"Turkey sandwich"]
[null,"2013-03-01","19:00:00","Dinner",575,75,32,95,"Tater tot casserole"]
[null,"2013-03-02","07:00:00","Coffee",10,10,0,0,"Morning coffee"]
[null,"2013-03-02","08:00:00","Toast",10,10,2,10,"Light breakfast"]
[null,"2013-03-02","12:00:00","Lunch",325,40,15,55,"Sandwich"]
[null,"2013-03-02","19:00:00","Dinner",445,45,45,45,"Dinner"]
[null,"2013-03-03","07:00:00","Coffee",10,10,0,0,"Morning coffee"]
[null,"2013-03-03","08:00:00","Bagel",10,10,2,10,"Light breakfast"]
[null,"2013-03-03","12:00:00","Lunch",50,10,2,2,"Salad"]
[null,"2013-03-03","19:00:00","Dinner",456,64,32,22,"Dinner"]
[null,"2013-03-04","07:00:00","Coffee",10,10,5,0,"Coffee"]
[null,"2013-03-04","10:00:00","Coffee",10,10,5,0,"Coffee"]
[null,"2013-03-04","12:15:00","Lunch",125,15,0,35,"Salad"]

{"sheet":"EXERCISE","index":2,"n_rows":22,"n_cols":5,"rows_kept":22}
[]
[null,"EXERCISE"]
[null,{"$f":"Subtitle","v":"DIET & EXERCISE JOURNAL"}]
[]
[null,"DATE","DURATION (MIN)","CALORIES BURNED","NOTES"]
[null,"2013-03-05",30,120,"Treadmill workout"]
[null,"2013-03-06",60,180,"Low impact aerobics"]
[null,"2013-03-07",60,350,"Extreme workout"]
[null,"2013-03-08",30,150,"Treadmill workout"]
[null,"2013-03-09",25,125,"Run"]
[null,"2013-03-10",20,285,"Treadmill workout"]
[null,"2013-03-11",40,205,"Run"]
[null,"2013-03-12",30,335,"Run"]
[null,"2013-03-13",40,175,"Run"]
[null,"2013-03-14",45,325,"Treadmill workout"]
[null,"2013-03-15",40,270,"Run"]
[null,"2013-03-16",20,295,"Treadmill workout"]
[null,"2013-03-17",45,350,"Run"]
[null,"2013-03-18",35,320,"Run"]
[null,"2013-03-19",40,290,"Run"]
[null,"2013-03-20",25,265,"Treadmill workout"]
[null,"2013-03-21",20,195,"Run"]

{"sheet":"Chart Calculations","index":3,"n_rows":36,"n_cols":10,"rows_kept":36,"hidden":true,"merged":[[1,1,1,9],[19,1,19,9]]}
[]
[null,"EXERCISE ANALYSIS CHARTING DATA"]
[]
[null,"Starting row",{"$f":"ROW(tblDiet[[#Headers],[DATE]])+1","v":6},"DATE","DAY","FIBER","SUGARS","CARBS","CALORIES","Num"]
[null,"Last diet entry",{"$f":"MATCH(9.99E+307,tblDiet[DATE])+DietRowStart-1","v":20},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J5,1),\"\")","v":"2013-03-04"},{"$f":"UPPER(TEXT(D5,\"DDD\"))","v":"MON"},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J5,7),NA())","v":35},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J5,6),NA())","v":0},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J5,5),NA())","v":15},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J5,4),NA())","v":125},-1]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J6,1),\"\")","v":"2013-03-04"},"MON",{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J6,7),NA())","v":0},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J6,6),NA())","v":5},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J6,5),NA())","v":10},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J6,4),NA())","v":10},0]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J7,1),\"\")","v":"2013-03-04"},"MON",{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J7,7),NA())","v":0},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J7,6),NA())","v":5},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J7,5),NA())","v":10},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J7,4),NA())","v":10},1]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J8,1),\"\")","v":"2013-03-03"},"SUN",{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J8,7),NA())","v":22},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J8,6),NA())","v":32},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J8,5),NA())","v":64},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J8,4),NA())","v":456},2]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J9,1),\"\")","v":"2013-03-03"},"SUN",{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J9,7),NA())","v":2},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J9,6),NA())","v":2},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J9,5),NA())","v":10},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J9,4),NA())","v":50},3]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J10,1),\"\")","v":"2013-03-03"},"SUN",{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J10,7),NA())","v":10},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J10,6),NA())","v":2},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J10,5),NA())","v":10},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J10,4),NA())","v":10},4]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J11,1),\"\")","v":"2013-03-03"},"SUN",{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J11,7),NA())","v":0},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J11,6),NA())","v":0},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J11,5),NA())","v":10},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J11,4),NA())","v":10},5]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J12,1),\"\")","v":"2013-03-02"},"SAT",{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J12,7),NA())","v":45},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J12,6),NA())","v":45},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J12,5),NA())","v":45},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J12,4),NA())","v":445},6]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J13,1),\"\")","v":"2013-03-02"},"SAT",{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J13,7),NA())","v":55},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J13,6),NA())","v":15},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J13,5),NA())","v":40},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J13,4),NA())","v":325},7]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J14,1),\"\")","v":"2013-03-02"},"SAT",{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J14,7),NA())","v":10},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J14,6),NA())","v":2},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J14,5),NA())","v":10},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J14,4),NA())","v":10},8]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J15,1),\"\")","v":"2013-03-02"},"SAT",{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J15,7),NA())","v":0},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J15,6),NA())","v":0},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J15,5),NA())","v":10},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J15,4),NA())","v":10},9]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J16,1),\"\")","v":"2013-03-01"},"FRI",{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J16,7),NA())","v":95},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J16,6),NA())","v":32},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J16,5),NA())","v":75},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J16,4),NA())","v":575},10]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J17,1),\"\")","v":"2013-03-01"},"FRI",{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J17,7),NA())","v":45},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J17,6),NA())","v":12},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J17,5),NA())","v":35},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J17,4),NA())","v":350},11]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J18,1),\"\")","v":"2013-03-01"},"FRI",{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J18,7),NA())","v":10},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J18,6),NA())","v":2},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J18,5),NA())","v":10},{"$f":"IFERROR(INDEX(tblDiet[],DietLastEnd-DietRowStart-J18,4),NA())","v":10},12]
[]
[null,"DIET ANALYSIS CHARTING DATA"]
[]
[null,"Starting row",{"$f":"ROW(tblExercise[[#Headers],[DATE]])+1","v":6},"DATE","DAY","DURATION (MIN)","CALORIES BURNED","Num"]
[null,"Last diet entry",{"$f":"MATCH(9.99E+307,tblExercise[DATE])+ExerciseRowStart-1","v":22},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H23,1),\"\")","v":"2013-03-21"},{"$f":"UPPER(TEXT(D23,\"DDD\"))","v":"THU"},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H23,2),NA())","v":20},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H23,3),NA())","v":195},-1]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H24,1),\"\")","v":"2013-03-20"},"WED",{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H24,2),NA())","v":25},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H24,3),NA())","v":265},0]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H25,1),\"\")","v":"2013-03-19"},"TUE",{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H25,2),NA())","v":40},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H25,3),NA())","v":290},1]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H26,1),\"\")","v":"2013-03-18"},"MON",{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H26,2),NA())","v":35},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H26,3),NA())","v":320},2]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H27,1),\"\")","v":"2013-03-17"},"SUN",{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H27,2),NA())","v":45},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H27,3),NA())","v":350},3]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H28,1),\"\")","v":"2013-03-16"},"SAT",{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H28,2),NA())","v":20},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H28,3),NA())","v":295},4]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H29,1),\"\")","v":"2013-03-15"},"FRI",{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H29,2),NA())","v":40},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H29,3),NA())","v":270},5]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H30,1),\"\")","v":"2013-03-14"},"THU",{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H30,2),NA())","v":45},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H30,3),NA())","v":325},6]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H31,1),\"\")","v":"2013-03-13"},"WED",{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H31,2),NA())","v":40},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H31,3),NA())","v":175},7]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H32,1),\"\")","v":"2013-03-12"},"TUE",{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H32,2),NA())","v":30},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H32,3),NA())","v":335},8]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H33,1),\"\")","v":"2013-03-11"},"MON",{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H33,2),NA())","v":40},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H33,3),NA())","v":205},9]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H34,1),\"\")","v":"2013-03-10"},"SUN",{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H34,2),NA())","v":20},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H34,3),NA())","v":285},10]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H35,1),\"\")","v":"2013-03-09"},"SAT",{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H35,2),NA())","v":25},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H35,3),NA())","v":125},11]
[{"$nulls":3},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H36,1),\"\")","v":"2013-03-08"},"FRI",{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H36,2),NA())","v":30},{"$f":"IFERROR(INDEX(tblExercise[],ExerciseLastEnd-ExerciseRowStart-H36,3),NA())","v":150},12]