{"text_format":"1","workbook":"xlsx","n_sheets":30,"sheets":["INSTRUCTIONS","EXAMPLE WEEK"," MY STATS","Graph","Fave foods","Wk 1","Wk 2","Wk 3","Wk 4","Wk 5","Wk 6","Wk 7","Wk 8","Wk 9","Wk 10","Wk 11","Wk 12","Week 1","week 2","week 3","Week 4","week 5","Week 6","Week 7","Week 8","Week 9","Week 10","Week 11","Week 12","David - Week 1"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":0,"defined_names":22,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"Graph","index":3,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INSTRUCTIONS","index":0,"n_rows":36,"n_cols":19,"rows_kept":36,"cut":false,"hidden":false,"merged":[[36,1,36,2],[31,1,31,2],[31,15,31,16],[22,0,30,0],[1,12,2,16],[0,4,0,10],[0,0,5,0],[6,0,21,0],[8,15,8,16],[17,15,17,16]]}
["If you want to use this spreadsheet more than once, I suggest saving this as a template: Go to File, Save As - Excel Macro-Enabled template. Then you can open a new spreadsheet via: File, New, My Templates","My Stats","Pre season",null,"Select from Pre season, Round 1, Round 2 or Round 3 from the dropdown list.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre season"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Enter your goal weight in B3. As you go along each week and update your weight loss, this will be reflected in cell G3 and update how much weight you have to lose to reach your goal weight (cell K3)",null,null,null,null,null,"Round 1"]
[null,"Goal weight",65,null,null,null,"Current weight lost",{"$f":"SUM(P10)","v":0},null,null,"Weight to lose",{"$f":"SUM(C8-C3-H3)","v":46.7},null,null,null,null,null,null,"Round 2"]
[null,null,"Enter the start date. The dates will automatically calculate the rest of the season dates."]
[null,null,"Enter your start weight in cell B8. The rest of your weight cells will be updated each week from the weekly menu/eating pages. This will then update your BMI, BMR, weight lost etc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Round 3"]
[null,null,"2012-01-02",{"$f":"SUM(C6)+2","v":"2012-01-04"},{"$f":"SUM(D6)+7","v":"2012-01-11"},"2012-01-18","2012-01-25","2012-02-01","2012-02-08","2012-02-15","2012-02-22","2012-02-29","2012-03-07","2012-03-14","2012-03-21","FINAL STATISTICS"]
["All cells shaded in grey on this sheet (these cells are not shaded on active sheet) are locked and do not need to be edited. These cells contain the functions and sums to add and subtract your weight loss, BMI, BMR etc. Cells highlighted in yellow are fields that need to be completed by you on the first set up (and weekly in the case of fat%, water% and bone density).","Week","Kick off",1,2,3,4,5,6,7,8,9,10,11,12,"Final weight"]
[null,"Weight",111.7,{"$f":"'Wk 1'!G11","v":111.7},{"$f":"'Wk 2'!G11","v":111.7},{"$f":"'Wk 3'!G11","v":111.7},{"$f":"'Wk 4'!G11","v":111.7},{"$f":"'Wk 5'!G11","v":111.7},{"$f":"'Wk 6'!G11","v":111.7},{"$f":"'Wk 7'!G11","v":111.7},{"$f":"'Wk 8'!G11","v":111.7},{"$f":"'Wk 9'!G11","v":111.7},{"$f":"'Wk 10'!G11","v":111.7},{"$f":"'Wk 11'!G11","v":111.7},{"$f":"'Wk 12'!G11","v":111.7},{"$f":"O8","v":111.7}]
[null,"Weight lost this week",null,{"$f":"SUM(C8-D8)","v":0},0,0,0,0,0,0,0,0,0,0,0,"Total weight lost"]
[null,"Weight loss so far",null,{"$f":"SUM(C9:D9)","v":0},{"$f":"SUM(D9:E9)","v":0},{"$f":"SUM(D9:F9)","v":0},{"$f":"SUM(D9:G9)","v":0},{"$f":"SUM(D9:H9)","v":0},{"$f":"SUM(D9:I9)","v":0},{"$f":"SUM(D9:J9)","v":0},{"$f":"SUM(D9:K9)","v":0},{"$f":"SUM(D9:L9)","v":0},{"$f":"SUM(D9:M9)","v":0},{"$f":"SUM(D9:N9)","v":0},{"$f":"SUM(D9:O9)","v":0},{"$f":"SUM(D9:O9)","v":0},"Kgs"]
[null,"% of starrt weight lost",null,{"$f":"+((D10)/(C8-B2))","v":0},{"$f":"+((E10)/(C8-B2))","v":0},{"$f":"+((F10)/(C8-B2))","v":0},{"$f":"+((G10)/(C8-B2))","v":0},{"$f":"+((H10)/(C8-B2))","v":0},{"$f":"+((I10)/(C8-B2))","v":0},{"$f":"+((J10)/(C8-B2))","v":0},{"$f":"+((K10)/(C8-B2))","v":0},{"$f":"+((L10)/(C8-B2))","v":0},{"$f":"+((M10)/(C8-B2))","v":0},{"$f":"+((N10)/(C8-B2))","v":0},{"$f":"+((O10)/(C8-B2))","v":0},{"$f":"+((P10)/(C8-B2))","v":0}," of start weight lost"]
[null,"% of goal achieved",null,{"$f":"+(D10/$L$3)","v":0},{"$f":"+(E10/$L$3)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+(P10/$L$3)","v":0},"of final goal achieved"]
[null,"Fat %",40.5,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C13-O13)","v":40.5},"% fat lost"]
[null,"Water %",43.4,"If you have a set of scales that will measure your fat%, water% and bone density, you can insert those details here.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C14-O14)","v":43.4},"% water lost"]
[null,"Bone density",7.3,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C15-O15)","v":7.3}]
[null,"BMI",{"$f":"C8/($C$36*$C$36)","v":38.650519031141876},38.650519031141876,38.650519031141876,38.650519031141876,38.650519031141876,38.650519031141876,38.650519031141876,38.650519031141876,38.650519031141876,38.650519031141876,38.650519031141876,38.650519031141876,38.650519031141876,{"$f":"O16","v":38.650519031141876},"BMI"]
[null,"BMR",{"$f":"655.1+(9.46*C8)+(1.85*C35)-(4.48*C33)","v":1869.4820000000002},{"$f":"655.1+(9.46*D8)+(1.85*C35)-(4.48*C33)","v":1869.4820000000002},{"$f":"655.1+(9.46*E8)+(1.85*C35)-(4.48*C33)","v":1869.4820000000002},{"$f":"655.1+(9.46*F8)+(1.85*C35)-(4.48*C33)","v":1869.4820000000002},{"$f":"655.1+(9.46*G8)+(1.85*C35)-(4.48*C33)","v":1869.4820000000002},{"$f":"655.1+(9.46*H8)+(1.85*C35)-(4.48*C33)","v":1869.4820000000002},{"$f":"655.1+(9.46*I8)+(1.85*C35)-(4.48*C33)","v":1869.4820000000002},{"$f":"655.1+(9.46*J8)+(1.85*C35)-(4.48*C33)","v":1869.4820000000002},{"$f":"655.1+(9.46*K8)+(1.85*C35)-(4.48*C33)","v":1869.4820000000002},{"$f":"655.1+(9.46*L8)+(1.85*C35)-(4.48*C33)","v":1869.4820000000002},{"$f":"655.1+(9.46*M8)+(1.85*C35)-(4.48*C33)","v":1869.4820000000002},{"$f":"655.1+(9.46*N8)+(1.85*C35)-(4.48*C33)","v":1869.4820000000002},{"$f":"655.1+(9.46*O8)+(1.85*C35)-(4.48*C33)","v":1869.4820000000002},{"$f":"O17","v":1869.4820000000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total CMs lost"]
[null,"Chest",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C19-O19)","v":0}]
[null,"Waist",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Hips",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Dist from knee",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["The MY STATS page is locked to avoid the risk of overwriting any of the formulas. If you would like to change any of those cells however, the password to unlock is: password (oh yes, I'm original!!!)","R Thigh",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"L Thigh",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"1km time trial",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C26-O26","v":"00:00:00"}]
[null,"Push ups",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O27-C27","v":0}]
[null,"Wall sit",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O28-C28","v":"00:00:00"}]
[null,"Ab stage",null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,"Sit'n'reach",null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[]
[null,"Personal details",null,null,null,null,null,null,null,null,null,null,null,null,null,"Average weight loss per week"]
[null,"Age",35,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(C8)","v":111.7},"Start weight"]
[null,"Gender","Female",null,null,null,null,null,null,null,null,null,null,null,null,0,"Current weight"]
[null,"Height in Centimetres",170,null,null,null,null,null,null,null,null,null,null,null,null,1,"Week #"]
[null,"Height in Meters",{"$f":"CONVERT(C35,\"cm\",\"m\")","v":1.7},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+(P33-P34)/P35","v":111.7},"Average"]

{"sheet":"EXAMPLE WEEK","index":1,"n_rows":46,"n_cols":18,"rows_kept":46,"cut":false,"hidden":false,"merged":[[37,17,45,18],[32,0,35,0],[32,15,32,16],[33,15,33,16],[34,15,34,16],[35,15,35,16],[36,0,38,0],[36,15,36,16],[37,15,37,16],[38,15,38,16],[26,15,26,16],[27,0,31,0],[27,15,27,16],[28,15,28,16],[29,15,29,16],[30,15,30,16],[31,15,31,16],[17,0,26,0],[17,15,17,16],[18,15,18,16],[19,15,19,16],[20,15,20,16],[21,15,21,16],[22,15,22,16],[23,15,23,16],[24,15,24,16],[16,1,16,2],[16,3,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[13,11,13,12],[13,13,13,14],[13,15,13,16],[25,15,25,16],[14,15,14,16],[15,15,15,16],[16,11,16,12],[16,13,16,14],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[11,9,11,10],[11,11,11,12],[11,13,11,14],[11,15,11,16],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,14],[12,15,12,16],[0,1,7,3],[0,5,7,7],[11,1,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,8]]}
["Week 1","THIS WEEKS GOALS: To stick to a week of healthy eating and to exercise at least three times over the course of the week. Ensure that I drink my minimum of 2 litres of water daily.",null,null,null,"TO ACHIEVE THIS I NEED TO: Fill out the whole weeks menu plan in here and stick to it. Organise my diary to fit in the exercise, and make use of the reminder function on my phone and not dismiss it and ignore it.",null,null,null,"How to use the weekly sheet:"]
[null,null,null,null,null,null,null,null,null,"Update your weekly goals, and how you are going to achieve these goals."]
["Calorie limit - 1200",null,null,null,null,null,null,null,null,"Starting weight is automatically updated from the MY STATS page."]
[null,null,null,null,null,null,null,null,null,"Weekly weigh ins on Wednesday will transfer across to the following weeks to help keep MY STATS page looking neat and tidy. Overwrite this each week with new weigh-ins obviously."]
[null,null,null,null,null,null,null,null,null,"Water intake is set to 12 glasses a day and is just a little tick box. I find it helps me keep track of whether I'm drinking enough water."]
[null,null,null,null,null,null,null,null,null,"For those of you who do two training sessions a day, there are two rows for training. Enter what you have completed and how many calories burnt."]
[null,null,null,null,null,null,null,null,null,"Your BMR is automatically updated from the MY STATS page."]
[]
[]
[]
[null,"Starting weight",{"$f":"' MY STATS'!B7","v":111.7},null,null,"Weekly Weigh In",{"$f":"C11","v":111.7}]
[null,"Monday",null,"Tuesday",null,"Wednesday",null,"Thursday",null,"Friday",null,"Saturday",null,"Sunday",null,"Notes"]
[null,{"$f":"' MY STATS'!B5","v":"2012-01-02"},null,{"$f":"' MY STATS'!B5+1","v":"2012-01-03"},null,{"$f":"' MY STATS'!B5+2","v":"2012-01-04"},null,{"$f":"' MY STATS'!B5+3","v":"2012-01-05"},null,{"$f":"' MY STATS'!B5+4","v":"2012-01-06"},null,{"$f":"' MY STATS'!B5+5","v":"2012-01-07"},null,{"$f":"' MY STATS'!B5+6","v":"2012-01-08"}]
[null,"Notes: Aim to eat healthy for the day and drink 12 glasses of water. Exercise a little.",null,"Notes:",null,"Notes:",null,"Notes: \n",null,"Notes: \n",null,"Notes: Super Saturday Session for Training!\n",null,"Notes: \n"]
["Training Session 1","Walk around after work",350,"Zumba",500,"walk around after work",350,"No training today",0,"Zumba",500,"Zumba",500,"insert training plans here","calories burnt here"]
["Training Session 2","Zumba",500,"insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","Walk/shuffle run",300,"insert training plans here","calories burnt here"]
["Water intake"]
["Breakfast"]
[null,"2 Pieces bread",170,"Oats with 2t brown sugar, ",null,"Oats with 2t brown sugar, ",null,"Oats with 2t brown sugar, ",null,"Oats with 2t brown sugar, ",null,"Oats with 2t brown sugar, ",null,"Oats with 2t brown sugar, "]
[null,"1tsp margarine",21,"1/2 cup milk and medium apple",307,"1/2 cup milk and medium apple",307,"1/2 cup milk and medium apple",307,"1/2 cup milk and medium apple",307,"1/2 cup milk and medium apple",307,"1/2 cup milk and medium apple",307]
[null,"40g cheese",163]
[]
[null,"1 cup coffee",3]
[null,"2t sugar (white)",30]
[null,"1/2C Pura skimmer milk",63]
[null,"(standard coffee = 96 cals)"]
[null,"sub-total",{"$f":"SUM(C18:C26)","v":450},"sub-total",{"$f":"SUM(E18:E26)","v":307},"sub-total",{"$f":"SUM(G18:G26)","v":307},"sub-total",{"$f":"SUM(I18:I26)","v":307},"sub-total",{"$f":"SUM(K18:K26)","v":307},"sub-total",{"$f":"SUM(M18:M26)","v":307},"sub-total",{"$f":"SUM(O18:O26)","v":307}]
["Lunch","Leek and potato soup",213,"Leek and potato soup",213,"Chicken and corn soup",316,"Chicken and corn soup",316,"Tuna 6\" subway, no cheese",300,"Beetroot soup",256,"Turkey and swiss cheese"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"wrap, with salad",225]
[]
[]
[null,"sub-total",{"$f":"SUM(C28:C31)","v":213},"sub-total",{"$f":"SUM(E28:E31)","v":213},"sub-total",{"$f":"SUM(G28:G31)","v":316},"sub-total",{"$f":"SUM(I28:I31)","v":316},"sub-total",{"$f":"SUM(K28:K31)","v":300},"sub-total",{"$f":"SUM(M28:M31)","v":256},"sub-total",{"$f":"SUM(O28:O31)","v":225}]
["Dinner","Hoisin beef stir fry",300,"Nat's lasagna",320,"Prawn pad thai",300,"Cajun chickn, sweet potato",null,"Lamb roast",400,"Lamb and bean casserole",null,"Chicken stir fry",285]
[null,null,null,null,null,null,null,"wedges and salad",300,null,null,"with rice",378]
[]
[null,"sub-total",{"$f":"SUM(C33:C35)","v":300},"sub-total",{"$f":"SUM(E33:E35)","v":320},"sub-total",{"$f":"SUM(G33:G35)","v":300},"sub-total",{"$f":"SUM(I33:I35)","v":300},"sub-total",{"$f":"SUM(K33:K35)","v":400},"sub-total",{"$f":"SUM(M33:M35)","v":378},"sub-total",{"$f":"SUM(O33:O35)","v":285}]
["Snacks","Small apple",45,"Be natural bar",117,"1 Forme satisfy strawberry yoghurt",85,"Bodywise bar",121,"Banana",99,"1 medium pear",71,"Muffin",159]
[null,"1 cup coffee (as per breakfast)",96,"Punnet of strawberries",58,"Punnet strawberries be natural bar",175,"Medium orange",68,null,null,"Banana muffin",105,"1 vanilla forme yoghurt",90,"Weekly totals",null,"These cells give you an overview of your total calorie intake for the week, what your overall BMR is for the week, how many calories burnt through training, and what your overall energy balance is for the week. You want the energy balance to be in the minus.  *7000 calories in deficit = 1kg weight loss (approximately)"]
[null,"sub-total",{"$f":"SUM(C37:C38)","v":141},"sub-total",{"$f":"SUM(E37:E38)","v":175},"sub-total",{"$f":"SUM(G37:G38)","v":260},"sub-total",{"$f":"SUM(I37:I38)","v":189},"sub-total",{"$f":"SUM(K37:K38)","v":99},"sub-total",{"$f":"SUM(M37:M38)","v":176},"sub-total",{"$f":"SUM(O37:O38)","v":249},"*7000 calories in deficit = 1kg weight loss (approximately)"]
["Total Calorie Intake",null,{"$f":"SUM(C27+C32+C36+C39)","v":1104},null,{"$f":"SUM(E27+E32+E36+E39)","v":1015},null,{"$f":"SUM(G27+G32+G36+G39)","v":1183},null,{"$f":"SUM(I27+I32+I36+I39)","v":1112},null,{"$f":"SUM(K27+K32+K36+K39)","v":1106},null,{"$f":"SUM(M27+M32+M36+M39)","v":1117},null,{"$f":"SUM(O27+O32+O36+O39)","v":1066},{"$f":"SUM(O40,M40,K40,I40,G40,E40,C40)","v":7703},"Total Calorie Intake"]
[]
["Basal Metabolic Rate (BMR)","This is automatically filled in from BMR on My Stats tab",{"$f":"' MY STATS'!B16","v":1869.4820000000002},null,{"$f":"' MY STATS'!B16","v":1869.4820000000002},null,{"$f":"' MY STATS'!B16","v":1869.4820000000002},null,{"$f":"' MY STATS'!B16","v":1869.4820000000002},null,{"$f":"' MY STATS'!B16","v":1869.4820000000002},null,{"$f":"' MY STATS'!B16","v":1869.4820000000002},null,{"$f":"' MY STATS'!B16","v":1869.4820000000002},{"$f":"SUM(C42:O42)","v":13086.374000000002},"Basal Metabolic Rate (BMR)"]
[null,null,null,null,null,null,null," "]
["Training ","Adds up cals burnt from training log above. ",{"$f":"SUM(C15:C16)","v":850},null,{"$f":"SUM(E15:E16)","v":500},null,{"$f":"SUM(G15:G16)","v":350},null,{"$f":"SUM(I15:I16)","v":0},null,{"$f":"SUM(K15:K16)","v":500},null,{"$f":"SUM(M15:M16)","v":800},null,{"$f":"SUM(O15:O16)","v":0},{"$f":"SUM(C44:O44)","v":3000},"Training "]
[]
["Energy balance","This is energy in (food) + energy out (BMR & training). You want more energy OUT than IN to lose weight & if you have done this, the number will be negative & appear red",{"$f":"SUM(C40-(C42+C44))","v":-1615.482},null,{"$f":"SUM(E40-(E42+E44))","v":-1354.482},null,{"$f":"SUM(G40-(G42+G44))","v":-1036.482},null,{"$f":"SUM(I40-(I42+I44))","v":-757.4820000000002},null,{"$f":"SUM(K40-(K42+K44))","v":-1263.482},null,{"$f":"SUM(M40-(M42+M44))","v":-1552.482},null,{"$f":"SUM(O40-(O42+O44))","v":-803.4820000000002},{"$f":"SUM(C46:O46)","v":-8383.3739999999998},"Energy balance"]

{"sheet":" MY STATS","index":2,"n_rows":36,"n_cols":18,"rows_kept":36,"cut":false,"hidden":false,"merged":[[7,14,7,15],[16,14,16,15],[31,14,31,15],[31,0,31,1]]}
["My Stats","Pre season",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre season"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Round 1"]
["Goal weight",65,null,null,null,"Current weight lost",{"$f":"SUM(O9)","v":0},null,null,"Weight to lose",{"$f":"SUM(B7-B3-G3)","v":46.7},null,null,null,null,null,null,"Round 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Round 3"]
[null,"2012-01-02",{"$f":"SUM(B5)+2","v":"2012-01-04"},{"$f":"SUM(C5)+7","v":"2012-01-11"},"2012-01-18","2012-01-25","2012-02-01","2012-02-08","2012-02-15","2012-02-22","2012-02-29","2012-03-07","2012-03-14","2012-03-21","FINAL STATISTICS"]
["Week","Kick off",1,2,3,4,5,6,7,8,9,10,11,12,"Final weight"]
["Weight",111.7,{"$f":"'Wk 1'!G11","v":111.7},{"$f":"'Wk 2'!G11","v":111.7},{"$f":"'Wk 3'!G11","v":111.7},{"$f":"'Wk 4'!G11","v":111.7},{"$f":"'Wk 5'!G11","v":111.7},{"$f":"'Wk 6'!G11","v":111.7},{"$f":"'Wk 7'!G11","v":111.7},{"$f":"'Wk 8'!G11","v":111.7},{"$f":"'Wk 9'!G11","v":111.7},{"$f":"'Wk 10'!G11","v":111.7},{"$f":"'Wk 11'!G11","v":111.7},{"$f":"'Wk 12'!G11","v":111.7},{"$f":"N7","v":111.7}]
["Weight lost this week",null,{"$f":"SUM(B7-C7)","v":0},0,0,0,0,0,0,0,0,0,0,0,"Total weight lost"]
["Weight loss so far",null,{"$f":"SUM(B8:C8)","v":0},{"$f":"SUM(C8:D8)","v":0},{"$f":"SUM(C8:E8)","v":0},{"$f":"SUM(C8:F8)","v":0},{"$f":"SUM(C8:G8)","v":0},{"$f":"SUM(C8:H8)","v":0},{"$f":"SUM(C8:I8)","v":0},{"$f":"SUM(C8:J8)","v":0},{"$f":"SUM(C8:K8)","v":0},{"$f":"SUM(C8:L8)","v":0},{"$f":"SUM(C8:M8)","v":0},{"$f":"SUM(C8:N8)","v":0},{"$f":"SUM(C8:N8)","v":0},"Kgs"]
["% of starrt weight lost",null,{"$f":"+((C9)/(B7-A2))","v":0},{"$f":"+((D9)/(B7-A2))","v":0},{"$f":"+((E9)/(B7-A2))","v":0},{"$f":"+((F9)/(B7-A2))","v":0},{"$f":"+((G9)/(B7-A2))","v":0},{"$f":"+((H9)/(B7-A2))","v":0},{"$f":"+((I9)/(B7-A2))","v":0},{"$f":"+((J9)/(B7-A2))","v":0},{"$f":"+((K9)/(B7-A2))","v":0},{"$f":"+((L9)/(B7-A2))","v":0},{"$f":"+((M9)/(B7-A2))","v":0},{"$f":"+((N9)/(B7-A2))","v":0},{"$f":"+((O9)/(B7-A2))","v":0}," of start weight lost"]
["% of goal achieved",null,{"$f":"+(C9/$K$3)","v":0},{"$f":"+(D9/$K$3)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+(O9/$K$3)","v":0},"of final goal achieved"]
["Fat %",40.5,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B12-N12)","v":40.5},"% fat lost"]
["Water %",43.4,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B13-N13)","v":43.4},"% water lost"]
["Bone density",7.3,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B14-N14)","v":7.3}]
["BMI",{"$f":"B7/($B$36*$B$36)","v":38.650519031141876},38.650519031141876,38.650519031141876,38.650519031141876,38.650519031141876,38.650519031141876,38.650519031141876,38.650519031141876,38.650519031141876,38.650519031141876,38.650519031141876,38.650519031141876,38.650519031141876,{"$f":"N15","v":38.650519031141876},"BMI"]
["BMR",{"$f":"655.1+(9.46*B7)+(1.85*B35)-(4.48*B33)","v":1869.4820000000002},{"$f":"655.1+(9.46*C7)+(1.85*B35)-(4.48*B33)","v":1869.4820000000002},{"$f":"655.1+(9.46*D7)+(1.85*B35)-(4.48*B33)","v":1869.4820000000002},{"$f":"655.1+(9.46*E7)+(1.85*B35)-(4.48*B33)","v":1869.4820000000002},{"$f":"655.1+(9.46*F7)+(1.85*B35)-(4.48*B33)","v":1869.4820000000002},{"$f":"655.1+(9.46*G7)+(1.85*B35)-(4.48*B33)","v":1869.4820000000002},{"$f":"655.1+(9.46*H7)+(1.85*B35)-(4.48*B33)","v":1869.4820000000002},{"$f":"655.1+(9.46*I7)+(1.85*B35)-(4.48*B33)","v":1869.4820000000002},{"$f":"655.1+(9.46*J7)+(1.85*B35)-(4.48*B33)","v":1869.4820000000002},{"$f":"655.1+(9.46*K7)+(1.85*B35)-(4.48*B33)","v":1869.4820000000002},{"$f":"655.1+(9.46*L7)+(1.85*B35)-(4.48*B33)","v":1869.4820000000002},{"$f":"655.1+(9.46*M7)+(1.85*B35)-(4.48*B33)","v":1869.4820000000002},{"$f":"655.1+(9.46*N7)+(1.85*B35)-(4.48*B33)","v":1869.4820000000002},{"$f":"N16","v":1869.4820000000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total CMs lost"]
["Chest",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B18-N18)","v":0}]
["Waist",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Hips",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["L Thigh",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["R Thigh",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["L Arm"]
["R Arm",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
["1km time trial",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B26-N26","v":"00:00:00"}]
["Push ups",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N27-B27","v":0}]
["Wall sit",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N28-B28","v":"00:00:00"}]
["Ab stage",null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["Sit'n'reach",null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[]
["Personal details",null,null,null,null,null,null,null,null,null,null,null,null,null,"Average weight loss per week"]
["Age",35,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(B7)","v":111.7},"Start weight"]
["Gender","Female",null,null,null,null,null,null,null,null,null,null,null,null,0,"Current weight"]
["Height in Centimetres",170,null,null,null,null,null,null,null,null,null,null,null,null,1,"Week #"]
["Height in Meters",{"$f":"CONVERT(B35,\"cm\",\"m\")","v":1.7},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+(O33-O34)/O35","v":111.7},"Average"]

{"sheet":"Fave foods","index":4,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,1],[5,0,5,1]]}
["Calorie calculator",null,null,"FAVOURITE FOODS"]
["Calories per 100g",378]
["Serving size",65,null,"Food & portion size / weight","Calories",null,"Food & portion size / weight","Calories",null,"Food & portion size / weight","Calories",null,"Food & portion size / weight","Calories"]
["Calories",{"$f":"SUM(B2/100)*(B3)","v":245.7},null,"Fruits",null,null,"Dairy",null,null,"Breakfast",null,null,"Vegetables (raw)"]
[null,null,null,"Apple (medium)",70,null,"Forme satisfy yoghurt (berry cheesecake)",90,null,"Brown sugar (1 teaspoon)",16,null,"100g Lettuce",10]
["Calorie converter",null,null,"Apple (small)",45,null,"Forme satisfy yoghurt (blueberry)",95,null,"Brown sugar (2 teaspoons)",32,null,"100g Tomatoes",18]
["Kilojoules",640,null,"Banana (medium)",110,null,"Forme satisfy yoghurt (caramel tart)",90,null,"Crumpets (per crumpet)",83,null,"100g Red capsicum",25]
["Converted to cals",{"$f":"SUM(B7/4.2)","v":152.38095238095238},null,"Mandarine (medium)",42,null,"Forme satisfy yoghurt (crumble)",92,null,"Flora light margarine (1 Tablespoon)",85,null,"100g Cucumber",12]
[null,null,null,"Nectarine (medium)",48,null,"Forme satisfy yoghurt (passionfruit)",94,null,"Nescafe (1 teaspoon)",3,null,"100g Red cabbage",29]
[null,null,null,"Orange (mdium)",70,null,"Forme satisfy yoghurt (strawberry)",85,null,"Serve of oats (30g / 1/3 cup)",114,null,"100g Carrot",32]
[null,null,null,"Peach (large)",72,null,"Forme satisfy yoghurt (vanilla)",90,null,"Serve of oats (40g / 1/2 cup)",153,null,"100g Onion",30]
[null,null,null,"Peach (medium)",51,null,"Pura skim milk (125ml / 1/2 cup)",63,null,"Serve of oats (65g / 3/4 cup)",246,null,"100g Mushrooms",25]
[null,null,null,"Peach (small)",36,null,"Pura skim milk (250ml / 1 cup)",125,null,"Vegemite (1 teaspoon)",11,null,"100g Zucchini",15]
[null,null,null,"Punnet strawberries 250g (243g)",63,null,"Pura Light Start milk (250ml / 1 cup)",110,null,"White sugar (2 teaspoons)",30]
[null,null,null,"Punnet strawberries 250g ",65,null,"Pura Light Start milk (250ml / 1/2 cup)",55]
[]
[]
[null,null,null,"Condiments",null,null,"Seafood"]
[null,null,null,"Soy sauce (1T)",15,null,"100g King George Whiting (raw)",86]
[null,null,null,null,null,null,"85g Blue Fin Tuna",122]
[null,null,null,null,null,null,"100g Scallops - steamed, grilled",112]

{"sheet":"Wk 1","index":5,"n_rows":46,"n_cols":17,"rows_kept":46,"cut":false,"hidden":false,"merged":[[16,13,16,14],[16,11,16,12],[13,11,13,12],[11,7,11,8],[12,11,12,12],[12,13,12,14],[13,13,13,14],[13,7,13,8],[11,11,11,12],[11,9,11,10],[13,3,13,4],[38,15,38,16],[37,15,37,16],[12,5,12,6],[12,7,12,8],[11,13,11,14],[18,15,18,16],[13,9,13,10],[11,15,11,16],[12,15,12,16],[20,15,20,16],[21,15,21,16],[22,15,22,16],[17,15,17,16],[0,1,7,3],[0,5,7,7],[12,1,12,2],[12,3,12,4],[12,9,12,10],[11,1,11,2],[11,3,11,4],[11,5,11,6],[13,1,13,2],[13,5,13,6],[24,15,24,16],[36,0,38,0],[32,0,35,0],[27,0,31,0],[17,0,26,0],[13,15,13,16],[14,15,14,16],[15,15,15,16],[36,15,36,16],[30,15,30,16],[31,15,31,16],[32,15,32,16],[33,15,33,16],[19,15,19,16],[23,15,23,16],[34,15,34,16],[35,15,35,16],[25,15,25,16],[26,15,26,16],[27,15,27,16],[28,15,28,16],[29,15,29,16],[16,1,16,2],[16,3,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10]]}
["Week 1","THIS WEEKS GOALS: To stick to a week of healthy eating and to exercise at least three times over the course of the week. Ensure that I drink my minimum of 2 litres of water daily.",null,null,null,"TO ACHIEVE THIS I NEED TO: Fill out the whole weeks menu plan in here and stick to it. Organise my diary to fit in the exercise, and make use of the reminder function on my phone and not dismiss it and ignore it."]
[]
["Calorie limit - 1200"]
[]
[]
[]
[]
[]
[]
[]
[null,"Starting weight",{"$f":"' MY STATS'!B7","v":111.7},null,null,"Weekly Weigh In",{"$f":"C11","v":111.7}]
[null,"Monday",null,"Tuesday",null,"Wednesday",null,"Thursday",null,"Friday",null,"Saturday",null,"Sunday",null,"Notes"]
[null,{"$f":"' MY STATS'!B5","v":"2012-01-02"},null,{"$f":"' MY STATS'!B5+1","v":"2012-01-03"},null,{"$f":"' MY STATS'!B5+2","v":"2012-01-04"},null,{"$f":"' MY STATS'!B5+3","v":"2012-01-05"},null,{"$f":"' MY STATS'!B5+4","v":"2012-01-06"},null,{"$f":"' MY STATS'!B5+5","v":"2012-01-07"},null,{"$f":"' MY STATS'!B5+6","v":"2012-01-08"}]
[null,"Notes: Aim to eat healthy for the day and drink 12 glasses of water. Exercise a little.",null,"Notes:",null,"Notes:",null,"Notes: \n",null,"Notes: \n",null,"Notes: Super Saturday Session for Training!\n",null,"Notes: \n"]
["Training Session 1","Walk around after work","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here"]
["Training Session 2","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here"]
["Water intake"]
["Breakfast"]
[null,"2 Pieces bread",170,"2 pieces bread",175]
[null,"1tsp margarine",21,"1/2 T butter",51]
[null,"40g cheese",163,"2 slices cheddar cheese",140]
[]
[null,"1 cup coffee",3,"Standard coffee",96]
[null,"2t sugar (white)",30]
[null,"1/2C Pura skimmer milk",63]
[null,"(standard coffee = 96 cals)"]
[null,"sub-total",{"$f":"SUM(C18:C26)","v":450},"sub-total",{"$f":"SUM(E18:E26)","v":462},"sub-total",{"$f":"SUM(G18:G26)","v":0},"sub-total",{"$f":"SUM(I18:I26)","v":0},"sub-total",{"$f":"SUM(K18:K26)","v":0},"sub-total",{"$f":"SUM(M18:M26)","v":0},"sub-total",{"$f":"SUM(O18:O26)","v":0}]
["Lunch","Cabbage, bacon and potato",400]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C28:C31)","v":400},"sub-total",{"$f":"SUM(E28:E31)","v":0},"sub-total",{"$f":"SUM(G28:G31)","v":0},"sub-total",{"$f":"SUM(I28:I31)","v":0},"sub-total",{"$f":"SUM(K28:K31)","v":0},"sub-total",{"$f":"SUM(M28:M31)","v":0},"sub-total",{"$f":"SUM(O28:O31)","v":0}]
["Dinner","Italian stew with pasta",550]
[]
[]
[null,"sub-total",{"$f":"SUM(C33:C35)","v":550},"sub-total",{"$f":"SUM(E33:E35)","v":0},"sub-total",{"$f":"SUM(G33:G35)","v":0},"sub-total",{"$f":"SUM(I33:I35)","v":0},"sub-total",{"$f":"SUM(K33:K35)","v":0},"sub-total",{"$f":"SUM(M33:M35)","v":0},"sub-total",{"$f":"SUM(O33:O35)","v":0}]
["Snacks","1/2 Cranberry mueslie bar",93,"Apricot almond muesli bar",199]
[null,"1 cup coffee (as per breakfast)",96,null,null,null,null,null,null,null,null,null,null,null,null,"Weekly totals"]
[null,"sub-total",{"$f":"SUM(C37:C38)","v":189},"sub-total",{"$f":"SUM(E37:E38)","v":199},"sub-total",{"$f":"SUM(G37:G38)","v":0},"sub-total",{"$f":"SUM(I37:I38)","v":0},"sub-total",{"$f":"SUM(K37:K38)","v":0},"sub-total",{"$f":"SUM(M37:M38)","v":0},"sub-total",{"$f":"SUM(O37:O38)","v":0},"*7000 calories in deficit = 1kg weight loss (approximately)"]
["Total Calorie Intake",null,{"$f":"SUM(C27+C32+C36+C39)","v":1589},null,{"$f":"SUM(E27+E32+E36+E39)","v":661},null,{"$f":"SUM(G27+G32+G36+G39)","v":0},null,{"$f":"SUM(I27+I32+I36+I39)","v":0},null,{"$f":"SUM(K27+K32+K36+K39)","v":0},null,{"$f":"SUM(M27+M32+M36+M39)","v":0},null,{"$f":"SUM(O27+O32+O36+O39)","v":0},{"$f":"SUM(O40,M40,K40,I40,G40,E40,C40)","v":2250},"Total Calorie Intake"]
[]
["Basal Metabolic Rate (BMR)",null,{"$f":"' MY STATS'!B16","v":1869.4820000000002},null,{"$f":"' MY STATS'!B16","v":1869.4820000000002},null,{"$f":"' MY STATS'!C16","v":1869.4820000000002},null,{"$f":"' MY STATS'!C16","v":1869.4820000000002},null,{"$f":"' MY STATS'!C16","v":1869.4820000000002},null,{"$f":"' MY STATS'!C16","v":1869.4820000000002},null,{"$f":"' MY STATS'!C16","v":1869.4820000000002},{"$f":"SUM(C42:O42)","v":13086.374000000002},"Basal Metabolic Rate (BMR)"]
[null,null,null,null,null,null,null," "]
["Training ",null,{"$f":"SUM(C15:C16)","v":0},null,{"$f":"SUM(E15:E16)","v":0},null,{"$f":"SUM(G15:G16)","v":0},null,{"$f":"SUM(I15:I16)","v":0},null,{"$f":"SUM(K15:K16)","v":0},null,{"$f":"SUM(M15:M16)","v":0},null,{"$f":"SUM(O15:O16)","v":0},{"$f":"SUM(C44:O44)","v":0},"Training "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C46:O46)","v":-10836.374000000002},"Energy balance (Mon - Sun)"]
["Energy balance",null,{"$f":"SUM(C40-(C42+C44))","v":-280.4820000000002},null,{"$f":"SUM(E40-(E42+E44))","v":-1208.4820000000002},null,{"$f":"SUM(G40-(G42+G44))","v":-1869.4820000000002},null,{"$f":"SUM(I40-(I42+I44))","v":-1869.4820000000002},null,{"$f":"SUM(K40-(K42+K44))","v":-1869.4820000000002},null,{"$f":"SUM(M40-(M42+M44))","v":-1869.4820000000002},null,{"$f":"SUM(O40-(O42+O44))","v":-1869.4820000000002},{"$f":"SUM(C46:E46)","v":-1488.9640000000004},"Energy balance (Wed - Tue)"]

{"sheet":"Wk 2","index":6,"n_rows":46,"n_cols":17,"rows_kept":46,"cut":false,"hidden":false,"merged":[[35,15,35,16],[18,15,18,16],[25,15,25,16],[26,15,26,16],[37,15,37,16],[23,15,23,16],[24,15,24,16],[36,15,36,16],[27,15,27,16],[28,15,28,16],[33,15,33,16],[38,15,38,16],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[16,5,16,6],[19,15,19,16],[20,15,20,16],[21,15,21,16],[22,15,22,16],[34,15,34,16],[29,15,29,16],[30,15,30,16],[31,15,31,16],[32,15,32,16],[17,15,17,16],[17,0,26,0],[27,0,31,0],[11,9,11,10],[32,0,35,0],[36,0,38,0],[12,1,12,2],[12,3,12,4],[11,5,11,6],[11,7,11,8],[12,5,12,6],[12,7,12,8],[11,1,11,2],[11,3,11,4],[16,1,16,2],[16,3,16,4],[16,7,16,8],[12,9,12,10],[0,1,7,3],[0,5,7,7],[11,15,11,16],[12,15,12,16],[16,9,16,10],[16,11,16,12],[13,9,13,10],[11,13,11,14],[11,11,11,12],[13,11,13,12],[12,11,12,12],[12,13,12,14],[14,15,14,16],[15,15,15,16],[13,15,13,16],[13,13,13,14],[16,13,16,14]]}
["Week 2","THIS WEEKS GOALS:",null,null,null,"TO ACHIEVE THIS I NEED TO:"]
[]
["Calorie limit - 1200"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Weekly Weigh In",{"$f":"'Wk 1'!G11","v":111.7}]
[null,"Monday",null,"Tuesday",null,"Wednesday",null,"Thursday",null,"Friday",null,"Saturday",null,"Sunday",null,"Notes"]
[null,{"$f":"' MY STATS'!D5-2","v":"2012-01-09"},null,{"$f":"' MY STATS'!D5-1","v":"2012-01-10"},null,{"$f":"' MY STATS'!D5","v":"2012-01-11"},null,{"$f":"' MY STATS'!D5+1","v":"2012-01-12"},null,{"$f":"' MY STATS'!D5+2","v":"2012-01-13"},null,{"$f":"' MY STATS'!D5+3","v":"2012-01-14"},null,{"$f":"' MY STATS'!D5+4","v":"2012-01-15"}]
[null,"Notes:",null,"Notes:",null,"Notes:",null,"Notes: \n",null,"Notes: \n",null,"Notes: Super Saturday Session for Training!\n",null,"Notes: \n"]
["Training Session 1","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here"]
["Training Session 2","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here"]
["Water intake"]
["Breakfast"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C18:C26)","v":0},"sub-total",{"$f":"SUM(E18:E26)","v":0},"sub-total",{"$f":"SUM(G18:G26)","v":0},"sub-total",{"$f":"SUM(I18:I26)","v":0},"sub-total",{"$f":"SUM(K18:K26)","v":0},"sub-total",{"$f":"SUM(M18:M26)","v":0},"sub-total",{"$f":"SUM(O18:O26)","v":0}]
["Lunch"]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C28:C31)","v":0},"sub-total",{"$f":"SUM(E28:E31)","v":0},"sub-total",{"$f":"SUM(G28:G31)","v":0},"sub-total",{"$f":"SUM(I28:I31)","v":0},"sub-total",{"$f":"SUM(K28:K31)","v":0},"sub-total",{"$f":"SUM(M28:M31)","v":0},"sub-total",{"$f":"SUM(O28:O31)","v":0}]
["Dinner"]
[]
[]
[null,"sub-total",{"$f":"SUM(C33:C35)","v":0},"sub-total",{"$f":"SUM(E33:E35)","v":0},"sub-total",{"$f":"SUM(G33:G35)","v":0},"sub-total",{"$f":"SUM(I33:I35)","v":0},"sub-total",{"$f":"SUM(K33:K35)","v":0},"sub-total",{"$f":"SUM(M33:M35)","v":0},"sub-total",{"$f":"SUM(O33:O35)","v":0}]
["Snacks"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekly totals"]
[null,"sub-total",{"$f":"SUM(C37:C38)","v":0},"sub-total",{"$f":"SUM(E37:E38)","v":0},"sub-total",{"$f":"SUM(G37:G38)","v":0},"sub-total",{"$f":"SUM(I37:I38)","v":0},"sub-total",{"$f":"SUM(K37:K38)","v":0},"sub-total",{"$f":"SUM(M37:M38)","v":0},"sub-total",{"$f":"SUM(O37:O38)","v":0},"*7000 calories in deficit = 1kg weight loss (approximately)"]
["Total Calorie Intake",null,{"$f":"SUM(C27+C32+C36+C39)","v":0},null,{"$f":"SUM(E27+E32+E36+E39)","v":0},null,{"$f":"SUM(G27+G32+G36+G39)","v":0},null,{"$f":"SUM(I27+I32+I36+I39)","v":0},null,{"$f":"SUM(K27+K32+K36+K39)","v":0},null,{"$f":"SUM(M27+M32+M36+M39)","v":0},null,{"$f":"SUM(O27+O32+O36+O39)","v":0},{"$f":"SUM(O40,M40,K40,I40,G40,E40,C40)","v":0},"Total Calorie Intake"]
[]
["Basal Metabolic Rate (BMR)",null,{"$f":"' MY STATS'!C16","v":1869.4820000000002},null,{"$f":"' MY STATS'!C16","v":1869.4820000000002},null,{"$f":"' MY STATS'!D16","v":1869.4820000000002},null,{"$f":"' MY STATS'!D16","v":1869.4820000000002},null,{"$f":"' MY STATS'!D16","v":1869.4820000000002},null,{"$f":"' MY STATS'!D16","v":1869.4820000000002},null,{"$f":"' MY STATS'!D16","v":1869.4820000000002},{"$f":"SUM(C42:O42)","v":13086.374000000002},"Basal Metabolic Rate (BMR)"]
[null,null,null,null,null,null,null," "]
["Training ",null,{"$f":"SUM(C15:C16)","v":0},null,{"$f":"SUM(E15:E16)","v":0},null,{"$f":"SUM(G15:G16)","v":0},null,{"$f":"SUM(I15:I16)","v":0},null,{"$f":"SUM(K15:K16)","v":0},null,{"$f":"SUM(M15:M16)","v":0},null,{"$f":"SUM(O15:O16)","v":0},{"$f":"SUM(C44:O44)","v":0},"Training "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C46:O46)","v":-13086.374000000002},"Energy balance (Mon - Sun)"]
["Energy balance",null,{"$f":"SUM(C40-(C42+C44))","v":-1869.4820000000002},null,{"$f":"SUM(E40-(E42+E44))","v":-1869.4820000000002},null,{"$f":"SUM(G40-(G42+G44))","v":-1869.4820000000002},null,{"$f":"SUM(I40-(I42+I44))","v":-1869.4820000000002},null,{"$f":"SUM(K40-(K42+K44))","v":-1869.4820000000002},null,{"$f":"SUM(M40-(M42+M44))","v":-1869.4820000000002},null,{"$f":"SUM(O40-(O42+O44))","v":-1869.4820000000002},{"$f":"SUM('Wk 1'!G46:O46)+SUM(C46:E46)","v":-13086.374000000002},"Energy balance (Wed - Tue)"]

{"sheet":"Wk 3","index":7,"n_rows":46,"n_cols":17,"rows_kept":46,"cut":false,"hidden":false,"merged":[[38,15,38,16],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[13,13,13,14],[37,15,37,16],[18,15,18,16],[25,15,25,16],[26,15,26,16],[27,15,27,16],[28,15,28,16],[29,15,29,16],[30,15,30,16],[11,13,11,14],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,14],[11,1,11,2],[11,3,11,4],[11,11,11,12],[0,1,7,3],[0,5,7,7],[11,5,11,6],[11,7,11,8],[11,9,11,10],[17,0,26,0],[27,0,31,0],[32,0,35,0],[36,0,38,0],[11,15,11,16],[12,15,12,16],[13,15,13,16],[14,15,14,16],[15,15,15,16],[17,15,17,16],[19,15,19,16],[20,15,20,16],[21,15,21,16],[22,15,22,16],[23,15,23,16],[24,15,24,16],[36,15,36,16],[16,13,16,14],[16,1,16,2],[16,3,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[31,15,31,16],[32,15,32,16],[33,15,33,16],[34,15,34,16],[35,15,35,16]]}
["Week 3","THIS WEEKS GOALS:",null,null,null,"TO ACHIEVE THIS I NEED TO:"]
[]
["Calorie limit - 1200"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Weekly Weigh In",{"$f":"'Wk 2'!G11","v":111.7}]
[null,"Monday",null,"Tuesday",null,"Wednesday",null,"Thursday",null,"Friday",null,"Saturday",null,"Sunday",null,"Notes"]
[null,{"$f":"' MY STATS'!E5-2","v":"2012-01-16"},null,{"$f":"' MY STATS'!E5-1","v":"2012-01-17"},null,{"$f":"' MY STATS'!E5","v":"2012-01-18"},null,{"$f":"' MY STATS'!E5+1","v":"2012-01-19"},null,{"$f":"' MY STATS'!E5+2","v":"2012-01-20"},null,{"$f":"' MY STATS'!E5+3","v":"2012-01-21"},null,{"$f":"' MY STATS'!E5+4","v":"2012-01-22"}]
[null,"Notes:",null,"Notes:",null,"Notes:",null,"Notes: \n",null,"Notes: \n",null,"Notes: Super Saturday Session for Training!\n",null,"Notes: \n"]
["Training Session 1","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here"]
["Training Session 2","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here"]
["Water intake"]
["Breakfast"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C18:C26)","v":0},"sub-total",{"$f":"SUM(E18:E26)","v":0},"sub-total",{"$f":"SUM(G18:G26)","v":0},"sub-total",{"$f":"SUM(I18:I26)","v":0},"sub-total",{"$f":"SUM(K18:K26)","v":0},"sub-total",{"$f":"SUM(M18:M26)","v":0},"sub-total",{"$f":"SUM(O18:O26)","v":0}]
["Lunch"]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C28:C31)","v":0},"sub-total",{"$f":"SUM(E28:E31)","v":0},"sub-total",{"$f":"SUM(G28:G31)","v":0},"sub-total",{"$f":"SUM(I28:I31)","v":0},"sub-total",{"$f":"SUM(K28:K31)","v":0},"sub-total",{"$f":"SUM(M28:M31)","v":0},"sub-total",{"$f":"SUM(O28:O31)","v":0}]
["Dinner"]
[]
[]
[null,"sub-total",{"$f":"SUM(C33:C35)","v":0},"sub-total",{"$f":"SUM(E33:E35)","v":0},"sub-total",{"$f":"SUM(G33:G35)","v":0},"sub-total",{"$f":"SUM(I33:I35)","v":0},"sub-total",{"$f":"SUM(K33:K35)","v":0},"sub-total",{"$f":"SUM(M33:M35)","v":0},"sub-total",{"$f":"SUM(O33:O35)","v":0}]
["Snacks"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekly totals"]
[null,"sub-total",{"$f":"SUM(C37:C38)","v":0},"sub-total",{"$f":"SUM(E37:E38)","v":0},"sub-total",{"$f":"SUM(G37:G38)","v":0},"sub-total",{"$f":"SUM(I37:I38)","v":0},"sub-total",{"$f":"SUM(K37:K38)","v":0},"sub-total",{"$f":"SUM(M37:M38)","v":0},"sub-total",{"$f":"SUM(O37:O38)","v":0},"*7000 calories in deficit = 1kg weight loss (approximately)"]
["Total Calorie Intake",null,{"$f":"SUM(C27+C32+C36+C39)","v":0},null,{"$f":"SUM(E27+E32+E36+E39)","v":0},null,{"$f":"SUM(G27+G32+G36+G39)","v":0},null,{"$f":"SUM(I27+I32+I36+I39)","v":0},null,{"$f":"SUM(K27+K32+K36+K39)","v":0},null,{"$f":"SUM(M27+M32+M36+M39)","v":0},null,{"$f":"SUM(O27+O32+O36+O39)","v":0},{"$f":"SUM(O40,M40,K40,I40,G40,E40,C40)","v":0},"Total Calorie Intake"]
[]
["Basal Metabolic Rate (BMR)",null,{"$f":"' MY STATS'!D16","v":1869.4820000000002},null,{"$f":"' MY STATS'!D16","v":1869.4820000000002},null,{"$f":"' MY STATS'!E16","v":1869.4820000000002},null,{"$f":"' MY STATS'!E16","v":1869.4820000000002},null,{"$f":"' MY STATS'!E16","v":1869.4820000000002},null,{"$f":"' MY STATS'!E16","v":1869.4820000000002},null,{"$f":"' MY STATS'!E16","v":1869.4820000000002},{"$f":"SUM(C42:O42)","v":13086.374000000002},"Basal Metabolic Rate (BMR)"]
[null,null,null,null,null,null,null," "]
["Training ",null,{"$f":"SUM(C15:C16)","v":0},null,{"$f":"SUM(E15:E16)","v":0},null,{"$f":"SUM(G15:G16)","v":0},null,{"$f":"SUM(I15:I16)","v":0},null,{"$f":"SUM(K15:K16)","v":0},null,{"$f":"SUM(M15:M16)","v":0},null,{"$f":"SUM(O15:O16)","v":0},{"$f":"SUM(C44:O44)","v":0},"Training "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C46:O46)","v":-13086.374000000002},"Energy balance (Mon - Sun)"]
["Energy balance",null,{"$f":"SUM(C40-(C42+C44))","v":-1869.4820000000002},null,{"$f":"SUM(E40-(E42+E44))","v":-1869.4820000000002},null,{"$f":"SUM(G40-(G42+G44))","v":-1869.4820000000002},null,{"$f":"SUM(I40-(I42+I44))","v":-1869.4820000000002},null,{"$f":"SUM(K40-(K42+K44))","v":-1869.4820000000002},null,{"$f":"SUM(M40-(M42+M44))","v":-1869.4820000000002},null,{"$f":"SUM(O40-(O42+O44))","v":-1869.4820000000002},{"$f":"SUM('Wk 2'!G46:O46)+SUM(C46:E46)","v":-13086.374000000002},"Energy balance (Wed - Tue)"]

{"sheet":"Wk 4","index":8,"n_rows":46,"n_cols":17,"rows_kept":46,"cut":false,"hidden":false,"merged":[[38,15,38,16],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[13,13,13,14],[37,15,37,16],[18,15,18,16],[25,15,25,16],[26,15,26,16],[27,15,27,16],[28,15,28,16],[29,15,29,16],[30,15,30,16],[11,13,11,14],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,14],[11,1,11,2],[11,3,11,4],[11,11,11,12],[0,1,7,3],[0,5,7,7],[11,5,11,6],[11,7,11,8],[11,9,11,10],[17,0,26,0],[27,0,31,0],[32,0,35,0],[36,0,38,0],[11,15,11,16],[12,15,12,16],[13,15,13,16],[14,15,14,16],[15,15,15,16],[17,15,17,16],[19,15,19,16],[20,15,20,16],[21,15,21,16],[22,15,22,16],[23,15,23,16],[24,15,24,16],[36,15,36,16],[16,13,16,14],[16,1,16,2],[16,3,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[31,15,31,16],[32,15,32,16],[33,15,33,16],[34,15,34,16],[35,15,35,16]]}
["Week 4","THIS WEEKS GOALS:",null,null,null,"TO ACHIEVE THIS I NEED TO:"]
[]
["Calorie limit - 1200"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Weekly Weigh In",{"$f":"'Wk 3'!G11","v":111.7}]
[null,"Monday",null,"Tuesday",null,"Wednesday",null,"Thursday",null,"Friday",null,"Saturday",null,"Sunday",null,"Notes"]
[null,{"$f":"' MY STATS'!F5-2","v":"2012-01-23"},null,{"$f":"' MY STATS'!F5-1","v":"2012-01-24"},null,{"$f":"' MY STATS'!F5","v":"2012-01-25"},null,{"$f":"' MY STATS'!F5+1","v":"2012-01-26"},null,{"$f":"' MY STATS'!F5+2","v":"2012-01-27"},null,{"$f":"' MY STATS'!F5+3","v":"2012-01-28"},null,{"$f":"' MY STATS'!F5+4","v":"2012-01-29"}]
[null,"Notes:",null,"Notes:",null,"Notes:",null,"Notes: \n",null,"Notes: \n",null,"Notes: Super Saturday Session for Training!\n",null,"Notes: \n"]
["Training Session 1","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here"]
["Training Session 2","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here"]
["Water intake"]
["Breakfast"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C18:C26)","v":0},"sub-total",{"$f":"SUM(E18:E26)","v":0},"sub-total",{"$f":"SUM(G18:G26)","v":0},"sub-total",{"$f":"SUM(I18:I26)","v":0},"sub-total",{"$f":"SUM(K18:K26)","v":0},"sub-total",{"$f":"SUM(M18:M26)","v":0},"sub-total",{"$f":"SUM(O18:O26)","v":0}]
["Lunch"]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C28:C31)","v":0},"sub-total",{"$f":"SUM(E28:E31)","v":0},"sub-total",{"$f":"SUM(G28:G31)","v":0},"sub-total",{"$f":"SUM(I28:I31)","v":0},"sub-total",{"$f":"SUM(K28:K31)","v":0},"sub-total",{"$f":"SUM(M28:M31)","v":0},"sub-total",{"$f":"SUM(O28:O31)","v":0}]
["Dinner"]
[]
[]
[null,"sub-total",{"$f":"SUM(C33:C35)","v":0},"sub-total",{"$f":"SUM(E33:E35)","v":0},"sub-total",{"$f":"SUM(G33:G35)","v":0},"sub-total",{"$f":"SUM(I33:I35)","v":0},"sub-total",{"$f":"SUM(K33:K35)","v":0},"sub-total",{"$f":"SUM(M33:M35)","v":0},"sub-total",{"$f":"SUM(O33:O35)","v":0}]
["Snacks"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekly totals"]
[null,"sub-total",{"$f":"SUM(C37:C38)","v":0},"sub-total",{"$f":"SUM(E37:E38)","v":0},"sub-total",{"$f":"SUM(G37:G38)","v":0},"sub-total",{"$f":"SUM(I37:I38)","v":0},"sub-total",{"$f":"SUM(K37:K38)","v":0},"sub-total",{"$f":"SUM(M37:M38)","v":0},"sub-total",{"$f":"SUM(O37:O38)","v":0},"*7000 calories in deficit = 1kg weight loss (approximately)"]
["Total Calorie Intake",null,{"$f":"SUM(C27+C32+C36+C39)","v":0},null,{"$f":"SUM(E27+E32+E36+E39)","v":0},null,{"$f":"SUM(G27+G32+G36+G39)","v":0},null,{"$f":"SUM(I27+I32+I36+I39)","v":0},null,{"$f":"SUM(K27+K32+K36+K39)","v":0},null,{"$f":"SUM(M27+M32+M36+M39)","v":0},null,{"$f":"SUM(O27+O32+O36+O39)","v":0},{"$f":"SUM(O40,M40,K40,I40,G40,E40,C40)","v":0},"Total Calorie Intake"]
[]
["Basal Metabolic Rate (BMR)",null,{"$f":"' MY STATS'!E16","v":1869.4820000000002},null,{"$f":"' MY STATS'!E16","v":1869.4820000000002},null,{"$f":"' MY STATS'!F16","v":1869.4820000000002},null,{"$f":"' MY STATS'!F16","v":1869.4820000000002},null,{"$f":"' MY STATS'!F16","v":1869.4820000000002},null,{"$f":"' MY STATS'!F16","v":1869.4820000000002},null,{"$f":"' MY STATS'!F16","v":1869.4820000000002},{"$f":"SUM(C42:O42)","v":13086.374000000002},"Basal Metabolic Rate (BMR)"]
[null,null,null,null,null,null,null," "]
["Training ",null,{"$f":"SUM(C15:C16)","v":0},null,{"$f":"SUM(E15:E16)","v":0},null,{"$f":"SUM(G15:G16)","v":0},null,{"$f":"SUM(I15:I16)","v":0},null,{"$f":"SUM(K15:K16)","v":0},null,{"$f":"SUM(M15:M16)","v":0},null,{"$f":"SUM(O15:O16)","v":0},{"$f":"SUM(C44:O44)","v":0},"Training "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C46:O46)","v":-13086.374000000002},"Energy balance (Mon - Sun)"]
["Energy balance",null,{"$f":"SUM(C40-(C42+C44))","v":-1869.4820000000002},null,{"$f":"SUM(E40-(E42+E44))","v":-1869.4820000000002},null,{"$f":"SUM(G40-(G42+G44))","v":-1869.4820000000002},null,{"$f":"SUM(I40-(I42+I44))","v":-1869.4820000000002},null,{"$f":"SUM(K40-(K42+K44))","v":-1869.4820000000002},null,{"$f":"SUM(M40-(M42+M44))","v":-1869.4820000000002},null,{"$f":"SUM(O40-(O42+O44))","v":-1869.4820000000002},{"$f":"SUM('Wk 3'!G46:O46)+SUM(C46:E46)","v":-13086.374000000002},"Energy balance (Wed - Tue)"]

{"sheet":"Wk 5","index":9,"n_rows":46,"n_cols":17,"rows_kept":46,"cut":false,"hidden":false,"merged":[[38,15,38,16],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[13,13,13,14],[37,15,37,16],[18,15,18,16],[25,15,25,16],[26,15,26,16],[27,15,27,16],[28,15,28,16],[29,15,29,16],[30,15,30,16],[11,13,11,14],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,14],[11,1,11,2],[11,3,11,4],[11,11,11,12],[0,1,7,3],[0,5,7,7],[11,5,11,6],[11,7,11,8],[11,9,11,10],[17,0,26,0],[27,0,31,0],[32,0,35,0],[36,0,38,0],[11,15,11,16],[12,15,12,16],[13,15,13,16],[14,15,14,16],[15,15,15,16],[17,15,17,16],[19,15,19,16],[20,15,20,16],[21,15,21,16],[22,15,22,16],[23,15,23,16],[24,15,24,16],[36,15,36,16],[16,13,16,14],[16,1,16,2],[16,3,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[31,15,31,16],[32,15,32,16],[33,15,33,16],[34,15,34,16],[35,15,35,16]]}
["Week 5","THIS WEEKS GOALS:",null,null,null,"TO ACHIEVE THIS I NEED TO:"]
[]
["Calorie limit - 1200"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Weekly Weigh In",{"$f":"'Wk 4'!G11","v":111.7}]
[null,"Monday",null,"Tuesday",null,"Wednesday",null,"Thursday",null,"Friday",null,"Saturday",null,"Sunday",null,"Notes"]
[null,{"$f":"' MY STATS'!G5-2","v":"2012-01-30"},null,{"$f":"' MY STATS'!G5-1","v":"2012-01-31"},null,{"$f":"' MY STATS'!G5","v":"2012-02-01"},null,{"$f":"' MY STATS'!G5+1","v":"2012-02-02"},null,{"$f":"' MY STATS'!G5+2","v":"2012-02-03"},null,{"$f":"' MY STATS'!G5+3","v":"2012-02-04"},null,{"$f":"' MY STATS'!G5+4","v":"2012-02-05"}]
[null,"Notes:",null,"Notes:",null,"Notes:",null,"Notes: \n",null,"Notes: \n",null,"Notes: Super Saturday Session for Training!\n",null,"Notes: \n"]
["Training Session 1","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here"]
["Training Session 2","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here"]
["Water intake"]
["Breakfast"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C18:C26)","v":0},"sub-total",{"$f":"SUM(E18:E26)","v":0},"sub-total",{"$f":"SUM(G18:G26)","v":0},"sub-total",{"$f":"SUM(I18:I26)","v":0},"sub-total",{"$f":"SUM(K18:K26)","v":0},"sub-total",{"$f":"SUM(M18:M26)","v":0},"sub-total",{"$f":"SUM(O18:O26)","v":0}]
["Lunch"]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C28:C31)","v":0},"sub-total",{"$f":"SUM(E28:E31)","v":0},"sub-total",{"$f":"SUM(G28:G31)","v":0},"sub-total",{"$f":"SUM(I28:I31)","v":0},"sub-total",{"$f":"SUM(K28:K31)","v":0},"sub-total",{"$f":"SUM(M28:M31)","v":0},"sub-total",{"$f":"SUM(O28:O31)","v":0}]
["Dinner"]
[]
[]
[null,"sub-total",{"$f":"SUM(C33:C35)","v":0},"sub-total",{"$f":"SUM(E33:E35)","v":0},"sub-total",{"$f":"SUM(G33:G35)","v":0},"sub-total",{"$f":"SUM(I33:I35)","v":0},"sub-total",{"$f":"SUM(K33:K35)","v":0},"sub-total",{"$f":"SUM(M33:M35)","v":0},"sub-total",{"$f":"SUM(O33:O35)","v":0}]
["Snacks"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekly totals"]
[null,"sub-total",{"$f":"SUM(C37:C38)","v":0},"sub-total",{"$f":"SUM(E37:E38)","v":0},"sub-total",{"$f":"SUM(G37:G38)","v":0},"sub-total",{"$f":"SUM(I37:I38)","v":0},"sub-total",{"$f":"SUM(K37:K38)","v":0},"sub-total",{"$f":"SUM(M37:M38)","v":0},"sub-total",{"$f":"SUM(O37:O38)","v":0},"*7000 calories in deficit = 1kg weight loss (approximately)"]
["Total Calorie Intake",null,{"$f":"SUM(C27+C32+C36+C39)","v":0},null,{"$f":"SUM(E27+E32+E36+E39)","v":0},null,{"$f":"SUM(G27+G32+G36+G39)","v":0},null,{"$f":"SUM(I27+I32+I36+I39)","v":0},null,{"$f":"SUM(K27+K32+K36+K39)","v":0},null,{"$f":"SUM(M27+M32+M36+M39)","v":0},null,{"$f":"SUM(O27+O32+O36+O39)","v":0},{"$f":"SUM(O40,M40,K40,I40,G40,E40,C40)","v":0},"Total Calorie Intake"]
[]
["Basal Metabolic Rate (BMR)",null,{"$f":"' MY STATS'!F16","v":1869.4820000000002},null,{"$f":"' MY STATS'!F16","v":1869.4820000000002},null,{"$f":"' MY STATS'!G16","v":1869.4820000000002},null,{"$f":"' MY STATS'!G16","v":1869.4820000000002},null,{"$f":"' MY STATS'!G16","v":1869.4820000000002},null,{"$f":"' MY STATS'!G16","v":1869.4820000000002},null,{"$f":"' MY STATS'!G16","v":1869.4820000000002},{"$f":"SUM(C42:O42)","v":13086.374000000002},"Basal Metabolic Rate (BMR)"]
[null,null,null,null,null,null,null," "]
["Training ",null,{"$f":"SUM(C15:C16)","v":0},null,{"$f":"SUM(E15:E16)","v":0},null,{"$f":"SUM(G15:G16)","v":0},null,{"$f":"SUM(I15:I16)","v":0},null,{"$f":"SUM(K15:K16)","v":0},null,{"$f":"SUM(M15:M16)","v":0},null,{"$f":"SUM(O15:O16)","v":0},{"$f":"SUM(C44:O44)","v":0},"Training "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C46:O46)","v":-13086.374000000002},"Energy balance (Mon - Sun)"]
["Energy balance",null,{"$f":"SUM(C40-(C42+C44))","v":-1869.4820000000002},null,{"$f":"SUM(E40-(E42+E44))","v":-1869.4820000000002},null,{"$f":"SUM(G40-(G42+G44))","v":-1869.4820000000002},null,{"$f":"SUM(I40-(I42+I44))","v":-1869.4820000000002},null,{"$f":"SUM(K40-(K42+K44))","v":-1869.4820000000002},null,{"$f":"SUM(M40-(M42+M44))","v":-1869.4820000000002},null,{"$f":"SUM(O40-(O42+O44))","v":-1869.4820000000002},{"$f":"SUM('Wk 4'!G46:O46)+SUM(C46:E46)","v":-13086.374000000002},"Energy balance (Wed - Tue)"]

{"sheet":"Wk 6","index":10,"n_rows":46,"n_cols":17,"rows_kept":46,"cut":false,"hidden":false,"merged":[[38,15,38,16],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[13,13,13,14],[37,15,37,16],[18,15,18,16],[25,15,25,16],[26,15,26,16],[27,15,27,16],[28,15,28,16],[29,15,29,16],[30,15,30,16],[11,13,11,14],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,14],[11,1,11,2],[11,3,11,4],[11,11,11,12],[0,1,7,3],[0,5,7,7],[11,5,11,6],[11,7,11,8],[11,9,11,10],[17,0,26,0],[27,0,31,0],[32,0,35,0],[36,0,38,0],[11,15,11,16],[12,15,12,16],[13,15,13,16],[14,15,14,16],[15,15,15,16],[17,15,17,16],[19,15,19,16],[20,15,20,16],[21,15,21,16],[22,15,22,16],[23,15,23,16],[24,15,24,16],[36,15,36,16],[16,13,16,14],[16,1,16,2],[16,3,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[31,15,31,16],[32,15,32,16],[33,15,33,16],[34,15,34,16],[35,15,35,16]]}
["Week 6","THIS WEEKS GOALS:",null,null,null,"TO ACHIEVE THIS I NEED TO:"]
[]
["Calorie limit - 1200"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Weekly Weigh In",{"$f":"'Wk 5'!G11","v":111.7}]
[null,"Monday",null,"Tuesday",null,"Wednesday",null,"Thursday",null,"Friday",null,"Saturday",null,"Sunday",null,"Notes"]
[null,{"$f":"' MY STATS'!H5-2","v":"2012-02-06"},null,{"$f":"' MY STATS'!H5-1","v":"2012-02-07"},null,{"$f":"' MY STATS'!H5","v":"2012-02-08"},null,{"$f":"' MY STATS'!H5+1","v":"2012-02-09"},null,{"$f":"' MY STATS'!H5+2","v":"2012-02-10"},null,{"$f":"' MY STATS'!H5+3","v":"2012-02-11"},null,{"$f":"' MY STATS'!H5+4","v":"2012-02-12"}]
[null,"Notes:",null,"Notes:",null,"Notes:",null,"Notes: \n",null,"Notes: \n",null,"Notes: Super Saturday Session for Training!\n",null,"Notes: \n"]
["Training Session 1","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here"]
["Training Session 2","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here"]
["Water intake"]
["Breakfast"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C18:C26)","v":0},"sub-total",{"$f":"SUM(E18:E26)","v":0},"sub-total",{"$f":"SUM(G18:G26)","v":0},"sub-total",{"$f":"SUM(I18:I26)","v":0},"sub-total",{"$f":"SUM(K18:K26)","v":0},"sub-total",{"$f":"SUM(M18:M26)","v":0},"sub-total",{"$f":"SUM(O18:O26)","v":0}]
["Lunch"]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C28:C31)","v":0},"sub-total",{"$f":"SUM(E28:E31)","v":0},"sub-total",{"$f":"SUM(G28:G31)","v":0},"sub-total",{"$f":"SUM(I28:I31)","v":0},"sub-total",{"$f":"SUM(K28:K31)","v":0},"sub-total",{"$f":"SUM(M28:M31)","v":0},"sub-total",{"$f":"SUM(O28:O31)","v":0}]
["Dinner"]
[]
[]
[null,"sub-total",{"$f":"SUM(C33:C35)","v":0},"sub-total",{"$f":"SUM(E33:E35)","v":0},"sub-total",{"$f":"SUM(G33:G35)","v":0},"sub-total",{"$f":"SUM(I33:I35)","v":0},"sub-total",{"$f":"SUM(K33:K35)","v":0},"sub-total",{"$f":"SUM(M33:M35)","v":0},"sub-total",{"$f":"SUM(O33:O35)","v":0}]
["Snacks"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekly totals"]
[null,"sub-total",{"$f":"SUM(C37:C38)","v":0},"sub-total",{"$f":"SUM(E37:E38)","v":0},"sub-total",{"$f":"SUM(G37:G38)","v":0},"sub-total",{"$f":"SUM(I37:I38)","v":0},"sub-total",{"$f":"SUM(K37:K38)","v":0},"sub-total",{"$f":"SUM(M37:M38)","v":0},"sub-total",{"$f":"SUM(O37:O38)","v":0},"*7000 calories in deficit = 1kg weight loss (approximately)"]
["Total Calorie Intake",null,{"$f":"SUM(C27+C32+C36+C39)","v":0},null,{"$f":"SUM(E27+E32+E36+E39)","v":0},null,{"$f":"SUM(G27+G32+G36+G39)","v":0},null,{"$f":"SUM(I27+I32+I36+I39)","v":0},null,{"$f":"SUM(K27+K32+K36+K39)","v":0},null,{"$f":"SUM(M27+M32+M36+M39)","v":0},null,{"$f":"SUM(O27+O32+O36+O39)","v":0},{"$f":"SUM(O40,M40,K40,I40,G40,E40,C40)","v":0},"Total Calorie Intake"]
[]
["Basal Metabolic Rate (BMR)",null,{"$f":"' MY STATS'!G16","v":1869.4820000000002},null,{"$f":"' MY STATS'!G16","v":1869.4820000000002},null,{"$f":"' MY STATS'!H16","v":1869.4820000000002},null,{"$f":"' MY STATS'!H16","v":1869.4820000000002},null,{"$f":"' MY STATS'!H16","v":1869.4820000000002},null,{"$f":"' MY STATS'!H16","v":1869.4820000000002},null,{"$f":"' MY STATS'!H16","v":1869.4820000000002},{"$f":"SUM(C42:O42)","v":13086.374000000002},"Basal Metabolic Rate (BMR)"]
[null,null,null,null,null,null,null," "]
["Training ",null,{"$f":"SUM(C15:C16)","v":0},null,{"$f":"SUM(E15:E16)","v":0},null,{"$f":"SUM(G15:G16)","v":0},null,{"$f":"SUM(I15:I16)","v":0},null,{"$f":"SUM(K15:K16)","v":0},null,{"$f":"SUM(M15:M16)","v":0},null,{"$f":"SUM(O15:O16)","v":0},{"$f":"SUM(C44:O44)","v":0},"Training "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C46:O46)","v":-13086.374000000002},"Energy balance (Mon - Sun)"]
["Energy balance",null,{"$f":"SUM(C40-(C42+C44))","v":-1869.4820000000002},null,{"$f":"SUM(E40-(E42+E44))","v":-1869.4820000000002},null,{"$f":"SUM(G40-(G42+G44))","v":-1869.4820000000002},null,{"$f":"SUM(I40-(I42+I44))","v":-1869.4820000000002},null,{"$f":"SUM(K40-(K42+K44))","v":-1869.4820000000002},null,{"$f":"SUM(M40-(M42+M44))","v":-1869.4820000000002},null,{"$f":"SUM(O40-(O42+O44))","v":-1869.4820000000002},{"$f":"SUM('Wk 5'!G46:O46)+SUM(C46:E46)","v":-13086.374000000002},"Energy balance (Wed - Tue)"]

{"sheet":"Wk 7","index":11,"n_rows":46,"n_cols":17,"rows_kept":46,"cut":false,"hidden":false,"merged":[[38,15,38,16],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[13,13,13,14],[37,15,37,16],[18,15,18,16],[25,15,25,16],[26,15,26,16],[27,15,27,16],[28,15,28,16],[29,15,29,16],[30,15,30,16],[11,13,11,14],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,14],[11,1,11,2],[11,3,11,4],[11,11,11,12],[0,1,7,3],[0,5,7,7],[11,5,11,6],[11,7,11,8],[11,9,11,10],[17,0,26,0],[27,0,31,0],[32,0,35,0],[36,0,38,0],[11,15,11,16],[12,15,12,16],[13,15,13,16],[14,15,14,16],[15,15,15,16],[17,15,17,16],[19,15,19,16],[20,15,20,16],[21,15,21,16],[22,15,22,16],[23,15,23,16],[24,15,24,16],[36,15,36,16],[16,13,16,14],[16,1,16,2],[16,3,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[31,15,31,16],[32,15,32,16],[33,15,33,16],[34,15,34,16],[35,15,35,16]]}
["Week 7","THIS WEEKS GOALS:",null,null,null,"TO ACHIEVE THIS I NEED TO:"]
[]
["Calorie limit - 1200"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Weekly Weigh In",{"$f":"'Wk 6'!G11","v":111.7}]
[null,"Monday",null,"Tuesday",null,"Wednesday",null,"Thursday",null,"Friday",null,"Saturday",null,"Sunday",null,"Notes"]
[null,{"$f":"' MY STATS'!I5-2","v":"2012-02-13"},null,{"$f":"' MY STATS'!I5-1","v":"2012-02-14"},null,{"$f":"' MY STATS'!I5","v":"2012-02-15"},null,{"$f":"' MY STATS'!I5+1","v":"2012-02-16"},null,{"$f":"' MY STATS'!I5+2","v":"2012-02-17"},null,{"$f":"' MY STATS'!I5+3","v":"2012-02-18"},null,{"$f":"' MY STATS'!I5+4","v":"2012-02-19"}]
[null,"Notes:",null,"Notes:",null,"Notes:",null,"Notes: \n",null,"Notes: \n",null,"Notes: Super Saturday Session for Training!\n",null,"Notes: \n"]
["Training Session 1","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here"]
["Training Session 2","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here"]
["Water intake"]
["Breakfast"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C18:C26)","v":0},"sub-total",{"$f":"SUM(E18:E26)","v":0},"sub-total",{"$f":"SUM(G18:G26)","v":0},"sub-total",{"$f":"SUM(I18:I26)","v":0},"sub-total",{"$f":"SUM(K18:K26)","v":0},"sub-total",{"$f":"SUM(M18:M26)","v":0},"sub-total",{"$f":"SUM(O18:O26)","v":0}]
["Lunch"]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C28:C31)","v":0},"sub-total",{"$f":"SUM(E28:E31)","v":0},"sub-total",{"$f":"SUM(G28:G31)","v":0},"sub-total",{"$f":"SUM(I28:I31)","v":0},"sub-total",{"$f":"SUM(K28:K31)","v":0},"sub-total",{"$f":"SUM(M28:M31)","v":0},"sub-total",{"$f":"SUM(O28:O31)","v":0}]
["Dinner"]
[]
[]
[null,"sub-total",{"$f":"SUM(C33:C35)","v":0},"sub-total",{"$f":"SUM(E33:E35)","v":0},"sub-total",{"$f":"SUM(G33:G35)","v":0},"sub-total",{"$f":"SUM(I33:I35)","v":0},"sub-total",{"$f":"SUM(K33:K35)","v":0},"sub-total",{"$f":"SUM(M33:M35)","v":0},"sub-total",{"$f":"SUM(O33:O35)","v":0}]
["Snacks"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekly totals"]
[null,"sub-total",{"$f":"SUM(C37:C38)","v":0},"sub-total",{"$f":"SUM(E37:E38)","v":0},"sub-total",{"$f":"SUM(G37:G38)","v":0},"sub-total",{"$f":"SUM(I37:I38)","v":0},"sub-total",{"$f":"SUM(K37:K38)","v":0},"sub-total",{"$f":"SUM(M37:M38)","v":0},"sub-total",{"$f":"SUM(O37:O38)","v":0},"*7000 calories in deficit = 1kg weight loss (approximately)"]
["Total Calorie Intake",null,{"$f":"SUM(C27+C32+C36+C39)","v":0},null,{"$f":"SUM(E27+E32+E36+E39)","v":0},null,{"$f":"SUM(G27+G32+G36+G39)","v":0},null,{"$f":"SUM(I27+I32+I36+I39)","v":0},null,{"$f":"SUM(K27+K32+K36+K39)","v":0},null,{"$f":"SUM(M27+M32+M36+M39)","v":0},null,{"$f":"SUM(O27+O32+O36+O39)","v":0},{"$f":"SUM(O40,M40,K40,I40,G40,E40,C40)","v":0},"Total Calorie Intake"]
[]
["Basal Metabolic Rate (BMR)",null,{"$f":"' MY STATS'!H16","v":1869.4820000000002},null,{"$f":"' MY STATS'!H16","v":1869.4820000000002},null,{"$f":"' MY STATS'!I16","v":1869.4820000000002},null,{"$f":"' MY STATS'!I16","v":1869.4820000000002},null,{"$f":"' MY STATS'!I16","v":1869.4820000000002},null,{"$f":"' MY STATS'!I16","v":1869.4820000000002},null,{"$f":"' MY STATS'!I16","v":1869.4820000000002},{"$f":"SUM(C42:O42)","v":13086.374000000002},"Basal Metabolic Rate (BMR)"]
[null,null,null,null,null,null,null," "]
["Training ",null,{"$f":"SUM(C15:C16)","v":0},null,{"$f":"SUM(E15:E16)","v":0},null,{"$f":"SUM(G15:G16)","v":0},null,{"$f":"SUM(I15:I16)","v":0},null,{"$f":"SUM(K15:K16)","v":0},null,{"$f":"SUM(M15:M16)","v":0},null,{"$f":"SUM(O15:O16)","v":0},{"$f":"SUM(C44:O44)","v":0},"Training "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C46:O46)","v":-13086.374000000002},"Energy balance (Mon - Sun)"]
["Energy balance",null,{"$f":"SUM(C40-(C42+C44))","v":-1869.4820000000002},null,{"$f":"SUM(E40-(E42+E44))","v":-1869.4820000000002},null,{"$f":"SUM(G40-(G42+G44))","v":-1869.4820000000002},null,{"$f":"SUM(I40-(I42+I44))","v":-1869.4820000000002},null,{"$f":"SUM(K40-(K42+K44))","v":-1869.4820000000002},null,{"$f":"SUM(M40-(M42+M44))","v":-1869.4820000000002},null,{"$f":"SUM(O40-(O42+O44))","v":-1869.4820000000002},{"$f":"SUM('Wk 6'!G46:O46)+SUM(C46:E46)","v":-13086.374000000002},"Energy balance (Wed - Tue)"]

{"sheet":"Wk 8","index":12,"n_rows":46,"n_cols":17,"rows_kept":46,"cut":false,"hidden":false,"merged":[[38,15,38,16],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[13,13,13,14],[37,15,37,16],[18,15,18,16],[25,15,25,16],[26,15,26,16],[27,15,27,16],[28,15,28,16],[29,15,29,16],[30,15,30,16],[11,13,11,14],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,14],[11,1,11,2],[11,3,11,4],[11,11,11,12],[0,1,7,3],[0,5,7,7],[11,5,11,6],[11,7,11,8],[11,9,11,10],[17,0,26,0],[27,0,31,0],[32,0,35,0],[36,0,38,0],[11,15,11,16],[12,15,12,16],[13,15,13,16],[14,15,14,16],[15,15,15,16],[17,15,17,16],[19,15,19,16],[20,15,20,16],[21,15,21,16],[22,15,22,16],[23,15,23,16],[24,15,24,16],[36,15,36,16],[16,13,16,14],[16,1,16,2],[16,3,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[31,15,31,16],[32,15,32,16],[33,15,33,16],[34,15,34,16],[35,15,35,16]]}
["Week 8","THIS WEEKS GOALS:",null,null,null,"TO ACHIEVE THIS I NEED TO:"]
[]
["Calorie limit - 1200"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Weekly Weigh In",{"$f":"'Wk 7'!G11","v":111.7}]
[null,"Monday",null,"Tuesday",null,"Wednesday",null,"Thursday",null,"Friday",null,"Saturday",null,"Sunday",null,"Notes"]
[null,{"$f":"' MY STATS'!J5-2","v":"2012-02-20"},null,{"$f":"' MY STATS'!J5-1","v":"2012-02-21"},null,{"$f":"' MY STATS'!J5","v":"2012-02-22"},null,{"$f":"' MY STATS'!J5+1","v":"2012-02-23"},null,{"$f":"' MY STATS'!J5+2","v":"2012-02-24"},null,{"$f":"' MY STATS'!J5+3","v":"2012-02-25"},null,{"$f":"' MY STATS'!J5+4","v":"2012-02-26"}]
[null,"Notes:",null,"Notes:",null,"Notes:",null,"Notes: \n",null,"Notes: \n",null,"Notes: Super Saturday Session for Training!\n",null,"Notes: \n"]
["Training Session 1","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here"]
["Training Session 2","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here"]
["Water intake"]
["Breakfast"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C18:C26)","v":0},"sub-total",{"$f":"SUM(E18:E26)","v":0},"sub-total",{"$f":"SUM(G18:G26)","v":0},"sub-total",{"$f":"SUM(I18:I26)","v":0},"sub-total",{"$f":"SUM(K18:K26)","v":0},"sub-total",{"$f":"SUM(M18:M26)","v":0},"sub-total",{"$f":"SUM(O18:O26)","v":0}]
["Lunch"]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C28:C31)","v":0},"sub-total",{"$f":"SUM(E28:E31)","v":0},"sub-total",{"$f":"SUM(G28:G31)","v":0},"sub-total",{"$f":"SUM(I28:I31)","v":0},"sub-total",{"$f":"SUM(K28:K31)","v":0},"sub-total",{"$f":"SUM(M28:M31)","v":0},"sub-total",{"$f":"SUM(O28:O31)","v":0}]
["Dinner"]
[]
[]
[null,"sub-total",{"$f":"SUM(C33:C35)","v":0},"sub-total",{"$f":"SUM(E33:E35)","v":0},"sub-total",{"$f":"SUM(G33:G35)","v":0},"sub-total",{"$f":"SUM(I33:I35)","v":0},"sub-total",{"$f":"SUM(K33:K35)","v":0},"sub-total",{"$f":"SUM(M33:M35)","v":0},"sub-total",{"$f":"SUM(O33:O35)","v":0}]
["Snacks"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekly totals"]
[null,"sub-total",{"$f":"SUM(C37:C38)","v":0},"sub-total",{"$f":"SUM(E37:E38)","v":0},"sub-total",{"$f":"SUM(G37:G38)","v":0},"sub-total",{"$f":"SUM(I37:I38)","v":0},"sub-total",{"$f":"SUM(K37:K38)","v":0},"sub-total",{"$f":"SUM(M37:M38)","v":0},"sub-total",{"$f":"SUM(O37:O38)","v":0},"*7000 calories in deficit = 1kg weight loss (approximately)"]
["Total Calorie Intake",null,{"$f":"SUM(C27+C32+C36+C39)","v":0},null,{"$f":"SUM(E27+E32+E36+E39)","v":0},null,{"$f":"SUM(G27+G32+G36+G39)","v":0},null,{"$f":"SUM(I27+I32+I36+I39)","v":0},null,{"$f":"SUM(K27+K32+K36+K39)","v":0},null,{"$f":"SUM(M27+M32+M36+M39)","v":0},null,{"$f":"SUM(O27+O32+O36+O39)","v":0},{"$f":"SUM(O40,M40,K40,I40,G40,E40,C40)","v":0},"Total Calorie Intake"]
[]
["Basal Metabolic Rate (BMR)",null,{"$f":"' MY STATS'!I16","v":1869.4820000000002},null,{"$f":"' MY STATS'!I16","v":1869.4820000000002},null,{"$f":"' MY STATS'!J16","v":1869.4820000000002},null,{"$f":"' MY STATS'!J16","v":1869.4820000000002},null,{"$f":"' MY STATS'!J16","v":1869.4820000000002},null,{"$f":"' MY STATS'!J16","v":1869.4820000000002},null,{"$f":"' MY STATS'!J16","v":1869.4820000000002},{"$f":"SUM(C42:O42)","v":13086.374000000002},"Basal Metabolic Rate (BMR)"]
[null,null,null,null,null,null,null," "]
["Training ",null,{"$f":"SUM(C15:C16)","v":0},null,{"$f":"SUM(E15:E16)","v":0},null,{"$f":"SUM(G15:G16)","v":0},null,{"$f":"SUM(I15:I16)","v":0},null,{"$f":"SUM(K15:K16)","v":0},null,{"$f":"SUM(M15:M16)","v":0},null,{"$f":"SUM(O15:O16)","v":0},{"$f":"SUM(C44:O44)","v":0},"Training "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C46:O46)","v":-13086.374000000002},"Energy balance (Mon - Sun)"]
["Energy balance",null,{"$f":"SUM(C40-(C42+C44))","v":-1869.4820000000002},null,{"$f":"SUM(E40-(E42+E44))","v":-1869.4820000000002},null,{"$f":"SUM(G40-(G42+G44))","v":-1869.4820000000002},null,{"$f":"SUM(I40-(I42+I44))","v":-1869.4820000000002},null,{"$f":"SUM(K40-(K42+K44))","v":-1869.4820000000002},null,{"$f":"SUM(M40-(M42+M44))","v":-1869.4820000000002},null,{"$f":"SUM(O40-(O42+O44))","v":-1869.4820000000002},{"$f":"SUM('Wk 7'!G46:O46)+SUM(C46:E46)","v":-13086.374000000002},"Energy balance (Wed - Tue)"]

{"sheet":"Wk 9","index":13,"n_rows":46,"n_cols":17,"rows_kept":46,"cut":false,"hidden":false,"merged":[[38,15,38,16],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[13,13,13,14],[37,15,37,16],[18,15,18,16],[25,15,25,16],[26,15,26,16],[27,15,27,16],[28,15,28,16],[29,15,29,16],[30,15,30,16],[11,13,11,14],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,14],[11,1,11,2],[11,3,11,4],[11,11,11,12],[0,1,7,3],[0,5,7,7],[11,5,11,6],[11,7,11,8],[11,9,11,10],[17,0,26,0],[27,0,31,0],[32,0,35,0],[36,0,38,0],[11,15,11,16],[12,15,12,16],[13,15,13,16],[14,15,14,16],[15,15,15,16],[17,15,17,16],[19,15,19,16],[20,15,20,16],[21,15,21,16],[22,15,22,16],[23,15,23,16],[24,15,24,16],[36,15,36,16],[16,13,16,14],[16,1,16,2],[16,3,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[31,15,31,16],[32,15,32,16],[33,15,33,16],[34,15,34,16],[35,15,35,16]]}
["Week 9","THIS WEEKS GOALS:",null,null,null,"TO ACHIEVE THIS I NEED TO:"]
[]
["Calorie limit - 1200"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Weekly Weigh In",{"$f":"'Wk 8'!G11","v":111.7}]
[null,"Monday",null,"Tuesday",null,"Wednesday",null,"Thursday",null,"Friday",null,"Saturday",null,"Sunday",null,"Notes"]
[null,{"$f":"' MY STATS'!K5-2","v":"2012-02-27"},null,{"$f":"' MY STATS'!K5-1","v":"2012-02-28"},null,{"$f":"' MY STATS'!K5","v":"2012-02-29"},null,{"$f":"' MY STATS'!K5+1","v":"2012-03-01"},null,{"$f":"' MY STATS'!K5+2","v":"2012-03-02"},null,{"$f":"' MY STATS'!K5+3","v":"2012-03-03"},null,{"$f":"' MY STATS'!K5+4","v":"2012-03-04"}]
[null,"Notes:",null,"Notes:",null,"Notes:",null,"Notes: \n",null,"Notes: \n",null,"Notes: Super Saturday Session for Training!\n",null,"Notes: \n"]
["Training Session 1","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here"]
["Training Session 2","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here"]
["Water intake"]
["Breakfast"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C18:C26)","v":0},"sub-total",{"$f":"SUM(E18:E26)","v":0},"sub-total",{"$f":"SUM(G18:G26)","v":0},"sub-total",{"$f":"SUM(I18:I26)","v":0},"sub-total",{"$f":"SUM(K18:K26)","v":0},"sub-total",{"$f":"SUM(M18:M26)","v":0},"sub-total",{"$f":"SUM(O18:O26)","v":0}]
["Lunch"]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C28:C31)","v":0},"sub-total",{"$f":"SUM(E28:E31)","v":0},"sub-total",{"$f":"SUM(G28:G31)","v":0},"sub-total",{"$f":"SUM(I28:I31)","v":0},"sub-total",{"$f":"SUM(K28:K31)","v":0},"sub-total",{"$f":"SUM(M28:M31)","v":0},"sub-total",{"$f":"SUM(O28:O31)","v":0}]
["Dinner"]
[]
[]
[null,"sub-total",{"$f":"SUM(C33:C35)","v":0},"sub-total",{"$f":"SUM(E33:E35)","v":0},"sub-total",{"$f":"SUM(G33:G35)","v":0},"sub-total",{"$f":"SUM(I33:I35)","v":0},"sub-total",{"$f":"SUM(K33:K35)","v":0},"sub-total",{"$f":"SUM(M33:M35)","v":0},"sub-total",{"$f":"SUM(O33:O35)","v":0}]
["Snacks"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekly totals"]
[null,"sub-total",{"$f":"SUM(C37:C38)","v":0},"sub-total",{"$f":"SUM(E37:E38)","v":0},"sub-total",{"$f":"SUM(G37:G38)","v":0},"sub-total",{"$f":"SUM(I37:I38)","v":0},"sub-total",{"$f":"SUM(K37:K38)","v":0},"sub-total",{"$f":"SUM(M37:M38)","v":0},"sub-total",{"$f":"SUM(O37:O38)","v":0},"*7000 calories in deficit = 1kg weight loss (approximately)"]
["Total Calorie Intake",null,{"$f":"SUM(C27+C32+C36+C39)","v":0},null,{"$f":"SUM(E27+E32+E36+E39)","v":0},null,{"$f":"SUM(G27+G32+G36+G39)","v":0},null,{"$f":"SUM(I27+I32+I36+I39)","v":0},null,{"$f":"SUM(K27+K32+K36+K39)","v":0},null,{"$f":"SUM(M27+M32+M36+M39)","v":0},null,{"$f":"SUM(O27+O32+O36+O39)","v":0},{"$f":"SUM(O40,M40,K40,I40,G40,E40,C40)","v":0},"Total Calorie Intake"]
[]
["Basal Metabolic Rate (BMR)",null,{"$f":"' MY STATS'!J16","v":1869.4820000000002},null,{"$f":"' MY STATS'!J16","v":1869.4820000000002},null,{"$f":"' MY STATS'!K16","v":1869.4820000000002},null,{"$f":"' MY STATS'!K16","v":1869.4820000000002},null,{"$f":"' MY STATS'!K16","v":1869.4820000000002},null,{"$f":"' MY STATS'!K16","v":1869.4820000000002},null,{"$f":"' MY STATS'!K16","v":1869.4820000000002},{"$f":"SUM(C42:O42)","v":13086.374000000002},"Basal Metabolic Rate (BMR)"]
[null,null,null,null,null,null,null," "]
["Training ",null,{"$f":"SUM(C15:C16)","v":0},null,{"$f":"SUM(E15:E16)","v":0},null,{"$f":"SUM(G15:G16)","v":0},null,{"$f":"SUM(I15:I16)","v":0},null,{"$f":"SUM(K15:K16)","v":0},null,{"$f":"SUM(M15:M16)","v":0},null,{"$f":"SUM(O15:O16)","v":0},{"$f":"SUM(C44:O44)","v":0},"Training "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C46:O46)","v":-13086.374000000002},"Energy balance (Mon - Sun)"]
["Energy balance",null,{"$f":"SUM(C40-(C42+C44))","v":-1869.4820000000002},null,{"$f":"SUM(E40-(E42+E44))","v":-1869.4820000000002},null,{"$f":"SUM(G40-(G42+G44))","v":-1869.4820000000002},null,{"$f":"SUM(I40-(I42+I44))","v":-1869.4820000000002},null,{"$f":"SUM(K40-(K42+K44))","v":-1869.4820000000002},null,{"$f":"SUM(M40-(M42+M44))","v":-1869.4820000000002},null,{"$f":"SUM(O40-(O42+O44))","v":-1869.4820000000002},{"$f":"SUM('Wk 8'!G46:O46)+SUM(C46:E46)","v":-13086.374000000002},"Energy balance (Wed - Tue)"]

{"sheet":"Wk 10","index":14,"n_rows":46,"n_cols":17,"rows_kept":46,"cut":false,"hidden":false,"merged":[[38,15,38,16],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[13,13,13,14],[37,15,37,16],[18,15,18,16],[25,15,25,16],[26,15,26,16],[27,15,27,16],[28,15,28,16],[29,15,29,16],[30,15,30,16],[11,13,11,14],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,14],[11,1,11,2],[11,3,11,4],[11,11,11,12],[0,1,7,3],[0,5,7,7],[11,5,11,6],[11,7,11,8],[11,9,11,10],[17,0,26,0],[27,0,31,0],[32,0,35,0],[36,0,38,0],[11,15,11,16],[12,15,12,16],[13,15,13,16],[14,15,14,16],[15,15,15,16],[17,15,17,16],[19,15,19,16],[20,15,20,16],[21,15,21,16],[22,15,22,16],[23,15,23,16],[24,15,24,16],[36,15,36,16],[16,13,16,14],[16,1,16,2],[16,3,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[31,15,31,16],[32,15,32,16],[33,15,33,16],[34,15,34,16],[35,15,35,16]]}
["Week 10","THIS WEEKS GOALS:",null,null,null,"TO ACHIEVE THIS I NEED TO:"]
[]
["Calorie limit - 1200"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Weekly Weigh In",{"$f":"'Wk 9'!G11","v":111.7}]
[null,"Monday",null,"Tuesday",null,"Wednesday",null,"Thursday",null,"Friday",null,"Saturday",null,"Sunday",null,"Notes"]
[null,{"$f":"' MY STATS'!L5-2","v":"2012-03-05"},null,{"$f":"' MY STATS'!L5-1","v":"2012-03-06"},null,{"$f":"' MY STATS'!L5","v":"2012-03-07"},null,{"$f":"' MY STATS'!L5+1","v":"2012-03-08"},null,{"$f":"' MY STATS'!L5+2","v":"2012-03-09"},null,{"$f":"' MY STATS'!L5+3","v":"2012-03-10"},null,{"$f":"' MY STATS'!L5+4","v":"2012-03-11"}]
[null,"Notes:",null,"Notes:",null,"Notes:",null,"Notes: \n",null,"Notes: \n",null,"Notes: Super Saturday Session for Training!\n",null,"Notes: \n"]
["Training Session 1","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here"]
["Training Session 2","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here"]
["Water intake"]
["Breakfast"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C18:C26)","v":0},"sub-total",{"$f":"SUM(E18:E26)","v":0},"sub-total",{"$f":"SUM(G18:G26)","v":0},"sub-total",{"$f":"SUM(I18:I26)","v":0},"sub-total",{"$f":"SUM(K18:K26)","v":0},"sub-total",{"$f":"SUM(M18:M26)","v":0},"sub-total",{"$f":"SUM(O18:O26)","v":0}]
["Lunch"]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C28:C31)","v":0},"sub-total",{"$f":"SUM(E28:E31)","v":0},"sub-total",{"$f":"SUM(G28:G31)","v":0},"sub-total",{"$f":"SUM(I28:I31)","v":0},"sub-total",{"$f":"SUM(K28:K31)","v":0},"sub-total",{"$f":"SUM(M28:M31)","v":0},"sub-total",{"$f":"SUM(O28:O31)","v":0}]
["Dinner"]
[]
[]
[null,"sub-total",{"$f":"SUM(C33:C35)","v":0},"sub-total",{"$f":"SUM(E33:E35)","v":0},"sub-total",{"$f":"SUM(G33:G35)","v":0},"sub-total",{"$f":"SUM(I33:I35)","v":0},"sub-total",{"$f":"SUM(K33:K35)","v":0},"sub-total",{"$f":"SUM(M33:M35)","v":0},"sub-total",{"$f":"SUM(O33:O35)","v":0}]
["Snacks"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekly totals"]
[null,"sub-total",{"$f":"SUM(C37:C38)","v":0},"sub-total",{"$f":"SUM(E37:E38)","v":0},"sub-total",{"$f":"SUM(G37:G38)","v":0},"sub-total",{"$f":"SUM(I37:I38)","v":0},"sub-total",{"$f":"SUM(K37:K38)","v":0},"sub-total",{"$f":"SUM(M37:M38)","v":0},"sub-total",{"$f":"SUM(O37:O38)","v":0},"*7000 calories in deficit = 1kg weight loss (approximately)"]
["Total Calorie Intake",null,{"$f":"SUM(C27+C32+C36+C39)","v":0},null,{"$f":"SUM(E27+E32+E36+E39)","v":0},null,{"$f":"SUM(G27+G32+G36+G39)","v":0},null,{"$f":"SUM(I27+I32+I36+I39)","v":0},null,{"$f":"SUM(K27+K32+K36+K39)","v":0},null,{"$f":"SUM(M27+M32+M36+M39)","v":0},null,{"$f":"SUM(O27+O32+O36+O39)","v":0},{"$f":"SUM(O40,M40,K40,I40,G40,E40,C40)","v":0},"Total Calorie Intake"]
[]
["Basal Metabolic Rate (BMR)",null,{"$f":"' MY STATS'!K16","v":1869.4820000000002},null,{"$f":"' MY STATS'!K16","v":1869.4820000000002},null,{"$f":"' MY STATS'!L16","v":1869.4820000000002},null,{"$f":"' MY STATS'!L16","v":1869.4820000000002},null,{"$f":"' MY STATS'!L16","v":1869.4820000000002},null,{"$f":"' MY STATS'!L16","v":1869.4820000000002},null,{"$f":"' MY STATS'!L16","v":1869.4820000000002},{"$f":"SUM(C42:O42)","v":13086.374000000002},"Basal Metabolic Rate (BMR)"]
[null,null,null,null,null,null,null," "]
["Training ",null,{"$f":"SUM(C15:C16)","v":0},null,{"$f":"SUM(E15:E16)","v":0},null,{"$f":"SUM(G15:G16)","v":0},null,{"$f":"SUM(I15:I16)","v":0},null,{"$f":"SUM(K15:K16)","v":0},null,{"$f":"SUM(M15:M16)","v":0},null,{"$f":"SUM(O15:O16)","v":0},{"$f":"SUM(C44:O44)","v":0},"Training "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C46:O46)","v":-13086.374000000002},"Energy balance (Mon - Sun)"]
["Energy balance",null,{"$f":"SUM(C40-(C42+C44))","v":-1869.4820000000002},null,{"$f":"SUM(E40-(E42+E44))","v":-1869.4820000000002},null,{"$f":"SUM(G40-(G42+G44))","v":-1869.4820000000002},null,{"$f":"SUM(I40-(I42+I44))","v":-1869.4820000000002},null,{"$f":"SUM(K40-(K42+K44))","v":-1869.4820000000002},null,{"$f":"SUM(M40-(M42+M44))","v":-1869.4820000000002},null,{"$f":"SUM(O40-(O42+O44))","v":-1869.4820000000002},{"$f":"SUM('Wk 9'!G46:O46)+SUM(C46:E46)","v":-13086.374000000002},"Energy balance (Wed - Tue)"]

{"sheet":"Wk 11","index":15,"n_rows":46,"n_cols":17,"rows_kept":46,"cut":false,"hidden":false,"merged":[[38,15,38,16],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[13,13,13,14],[37,15,37,16],[18,15,18,16],[25,15,25,16],[26,15,26,16],[27,15,27,16],[28,15,28,16],[29,15,29,16],[30,15,30,16],[11,13,11,14],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,14],[11,1,11,2],[11,3,11,4],[11,11,11,12],[0,1,7,3],[0,5,7,7],[11,5,11,6],[11,7,11,8],[11,9,11,10],[17,0,26,0],[27,0,31,0],[32,0,35,0],[36,0,38,0],[11,15,11,16],[12,15,12,16],[13,15,13,16],[14,15,14,16],[15,15,15,16],[17,15,17,16],[19,15,19,16],[20,15,20,16],[21,15,21,16],[22,15,22,16],[23,15,23,16],[24,15,24,16],[36,15,36,16],[16,13,16,14],[16,1,16,2],[16,3,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[31,15,31,16],[32,15,32,16],[33,15,33,16],[34,15,34,16],[35,15,35,16]]}
["Week 11","THIS WEEKS GOALS:",null,null,null,"TO ACHIEVE THIS I NEED TO:"]
[]
["Calorie limit - 1200"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Weekly Weigh In",{"$f":"'Wk 10'!G11","v":111.7}]
[null,"Monday",null,"Tuesday",null,"Wednesday",null,"Thursday",null,"Friday",null,"Saturday",null,"Sunday",null,"Notes"]
[null,{"$f":"' MY STATS'!M5-2","v":"2012-03-12"},null,{"$f":"' MY STATS'!M5-1","v":"2012-03-13"},null,{"$f":"' MY STATS'!M5","v":"2012-03-14"},null,{"$f":"' MY STATS'!M5+1","v":"2012-03-15"},null,{"$f":"' MY STATS'!M5+2","v":"2012-03-16"},null,{"$f":"' MY STATS'!M5+3","v":"2012-03-17"},null,{"$f":"' MY STATS'!M5+4","v":"2012-03-18"}]
[null,"Notes:",null,"Notes:",null,"Notes:",null,"Notes: \n",null,"Notes: \n",null,"Notes: Super Saturday Session for Training!\n",null,"Notes: \n"]
["Training Session 1","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here"]
["Training Session 2","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here"]
["Water intake"]
["Breakfast"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C18:C26)","v":0},"sub-total",{"$f":"SUM(E18:E26)","v":0},"sub-total",{"$f":"SUM(G18:G26)","v":0},"sub-total",{"$f":"SUM(I18:I26)","v":0},"sub-total",{"$f":"SUM(K18:K26)","v":0},"sub-total",{"$f":"SUM(M18:M26)","v":0},"sub-total",{"$f":"SUM(O18:O26)","v":0}]
["Lunch"]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C28:C31)","v":0},"sub-total",{"$f":"SUM(E28:E31)","v":0},"sub-total",{"$f":"SUM(G28:G31)","v":0},"sub-total",{"$f":"SUM(I28:I31)","v":0},"sub-total",{"$f":"SUM(K28:K31)","v":0},"sub-total",{"$f":"SUM(M28:M31)","v":0},"sub-total",{"$f":"SUM(O28:O31)","v":0}]
["Dinner"]
[]
[]
[null,"sub-total",{"$f":"SUM(C33:C35)","v":0},"sub-total",{"$f":"SUM(E33:E35)","v":0},"sub-total",{"$f":"SUM(G33:G35)","v":0},"sub-total",{"$f":"SUM(I33:I35)","v":0},"sub-total",{"$f":"SUM(K33:K35)","v":0},"sub-total",{"$f":"SUM(M33:M35)","v":0},"sub-total",{"$f":"SUM(O33:O35)","v":0}]
["Snacks"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekly totals"]
[null,"sub-total",{"$f":"SUM(C37:C38)","v":0},"sub-total",{"$f":"SUM(E37:E38)","v":0},"sub-total",{"$f":"SUM(G37:G38)","v":0},"sub-total",{"$f":"SUM(I37:I38)","v":0},"sub-total",{"$f":"SUM(K37:K38)","v":0},"sub-total",{"$f":"SUM(M37:M38)","v":0},"sub-total",{"$f":"SUM(O37:O38)","v":0},"*7000 calories in deficit = 1kg weight loss (approximately)"]
["Total Calorie Intake",null,{"$f":"SUM(C27+C32+C36+C39)","v":0},null,{"$f":"SUM(E27+E32+E36+E39)","v":0},null,{"$f":"SUM(G27+G32+G36+G39)","v":0},null,{"$f":"SUM(I27+I32+I36+I39)","v":0},null,{"$f":"SUM(K27+K32+K36+K39)","v":0},null,{"$f":"SUM(M27+M32+M36+M39)","v":0},null,{"$f":"SUM(O27+O32+O36+O39)","v":0},{"$f":"SUM(O40,M40,K40,I40,G40,E40,C40)","v":0},"Total Calorie Intake"]
[]
["Basal Metabolic Rate (BMR)",null,{"$f":"' MY STATS'!L16","v":1869.4820000000002},null,{"$f":"' MY STATS'!L16","v":1869.4820000000002},null,{"$f":"' MY STATS'!M16","v":1869.4820000000002},null,{"$f":"' MY STATS'!M16","v":1869.4820000000002},null,{"$f":"' MY STATS'!M16","v":1869.4820000000002},null,{"$f":"' MY STATS'!M16","v":1869.4820000000002},null,{"$f":"' MY STATS'!M16","v":1869.4820000000002},{"$f":"SUM(C42:O42)","v":13086.374000000002},"Basal Metabolic Rate (BMR)"]
[null,null,null,null,null,null,null," "]
["Training ",null,{"$f":"SUM(C15:C16)","v":0},null,{"$f":"SUM(E15:E16)","v":0},null,{"$f":"SUM(G15:G16)","v":0},null,{"$f":"SUM(I15:I16)","v":0},null,{"$f":"SUM(K15:K16)","v":0},null,{"$f":"SUM(M15:M16)","v":0},null,{"$f":"SUM(O15:O16)","v":0},{"$f":"SUM(C44:O44)","v":0},"Training "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C46:O46)","v":-13086.374000000002},"Energy balance (Mon - Sun)"]
["Energy balance",null,{"$f":"SUM(C40-(C42+C44))","v":-1869.4820000000002},null,{"$f":"SUM(E40-(E42+E44))","v":-1869.4820000000002},null,{"$f":"SUM(G40-(G42+G44))","v":-1869.4820000000002},null,{"$f":"SUM(I40-(I42+I44))","v":-1869.4820000000002},null,{"$f":"SUM(K40-(K42+K44))","v":-1869.4820000000002},null,{"$f":"SUM(M40-(M42+M44))","v":-1869.4820000000002},null,{"$f":"SUM(O40-(O42+O44))","v":-1869.4820000000002},{"$f":"SUM('Wk 10'!G46:O46)+SUM(C46:E46)","v":-13086.374000000002},"Energy balance (Wed - Tue)"]

{"sheet":"Wk 12","index":16,"n_rows":46,"n_cols":17,"rows_kept":46,"cut":false,"hidden":false,"merged":[[38,15,38,16],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[13,13,13,14],[37,15,37,16],[22,15,22,16],[32,15,32,16],[33,15,33,16],[16,13,16,14],[16,1,16,2],[16,3,16,4],[16,5,16,6],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[0,1,7,3],[0,5,7,7],[11,5,11,6],[11,7,11,8],[11,9,11,10],[11,1,11,2],[11,3,11,4],[17,0,26,0],[27,0,31,0],[32,0,35,0],[36,0,38,0],[36,15,36,16],[35,15,35,16],[34,15,34,16],[19,15,19,16],[20,15,20,16],[21,15,21,16],[27,15,27,16],[28,15,28,16],[18,15,18,16],[29,15,29,16],[30,15,30,16],[31,15,31,16],[24,15,24,16],[25,15,25,16],[26,15,26,16],[12,15,12,16],[13,15,13,16],[14,15,14,16],[15,15,15,16],[17,15,17,16],[16,7,16,8],[16,9,16,10],[16,11,16,12],[11,15,11,16],[23,15,23,16],[11,13,11,14],[12,11,12,12],[12,13,12,14],[11,11,11,12]]}
["Week 12","THIS WEEKS GOALS:",null,null,null,"TO ACHIEVE THIS I NEED TO:"]
[]
["Calorie limit - 1200"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Weekly Weigh In",{"$f":"'Wk 11'!G11","v":111.7}]
[null,"Monday",null,"Tuesday",null,"Wednesday",null,"Thursday",null,"Friday",null,"Saturday",null,"Sunday",null,"Notes"]
[null,{"$f":"' MY STATS'!N5-2","v":"2012-03-19"},null,{"$f":"' MY STATS'!N5-1","v":"2012-03-20"},null,{"$f":"' MY STATS'!N5","v":"2012-03-21"},null,{"$f":"' MY STATS'!N5+1","v":"2012-03-22"},null,{"$f":"' MY STATS'!N5+2","v":"2012-03-23"},null,{"$f":"' MY STATS'!N5+3","v":"2012-03-24"},null,{"$f":"' MY STATS'!N5+4","v":"2012-03-25"}]
[null,"Notes:",null,"Notes:",null,"Notes:",null,"Notes: \n",null,"Notes: \n",null,"Notes: Super Saturday Session for Training!\n",null,"Notes: \n"]
["Training Session 1","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here"]
["Training Session 2","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here","insert training plans here","calories burnt here"]
["Water intake"]
["Breakfast"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C18:C26)","v":0},"sub-total",{"$f":"SUM(E18:E26)","v":0},"sub-total",{"$f":"SUM(G18:G26)","v":0},"sub-total",{"$f":"SUM(I18:I26)","v":0},"sub-total",{"$f":"SUM(K18:K26)","v":0},"sub-total",{"$f":"SUM(M18:M26)","v":0},"sub-total",{"$f":"SUM(O18:O26)","v":0}]
["Lunch"]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C28:C31)","v":0},"sub-total",{"$f":"SUM(E28:E31)","v":0},"sub-total",{"$f":"SUM(G28:G31)","v":0},"sub-total",{"$f":"SUM(I28:I31)","v":0},"sub-total",{"$f":"SUM(K28:K31)","v":0},"sub-total",{"$f":"SUM(M28:M31)","v":0},"sub-total",{"$f":"SUM(O28:O31)","v":0}]
["Dinner"]
[]
[]
[null,"sub-total",{"$f":"SUM(C33:C35)","v":0},"sub-total",{"$f":"SUM(E33:E35)","v":0},"sub-total",{"$f":"SUM(G33:G35)","v":0},"sub-total",{"$f":"SUM(I33:I35)","v":0},"sub-total",{"$f":"SUM(K33:K35)","v":0},"sub-total",{"$f":"SUM(M33:M35)","v":0},"sub-total",{"$f":"SUM(O33:O35)","v":0}]
["Snacks"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekly totals"]
[null,"sub-total",{"$f":"SUM(C37:C38)","v":0},"sub-total",{"$f":"SUM(E37:E38)","v":0},"sub-total",{"$f":"SUM(G37:G38)","v":0},"sub-total",{"$f":"SUM(I37:I38)","v":0},"sub-total",{"$f":"SUM(K37:K38)","v":0},"sub-total",{"$f":"SUM(M37:M38)","v":0},"sub-total",{"$f":"SUM(O37:O38)","v":0},"*7000 calories in deficit = 1kg weight loss (approximately)"]
["Total Calorie Intake",null,{"$f":"SUM(C27+C32+C36+C39)","v":0},null,{"$f":"SUM(E27+E32+E36+E39)","v":0},null,{"$f":"SUM(G27+G32+G36+G39)","v":0},null,{"$f":"SUM(I27+I32+I36+I39)","v":0},null,{"$f":"SUM(K27+K32+K36+K39)","v":0},null,{"$f":"SUM(M27+M32+M36+M39)","v":0},null,{"$f":"SUM(O27+O32+O36+O39)","v":0},{"$f":"SUM(O40,M40,K40,I40,G40,E40,C40)","v":0},"Total Calorie Intake"]
[]
["Basal Metabolic Rate (BMR)",null,{"$f":"' MY STATS'!M16","v":1869.4820000000002},null,{"$f":"' MY STATS'!M16","v":1869.4820000000002},null,{"$f":"' MY STATS'!N16","v":1869.4820000000002},null,{"$f":"' MY STATS'!N16","v":1869.4820000000002},null,{"$f":"' MY STATS'!N16","v":1869.4820000000002},null,{"$f":"' MY STATS'!N16","v":1869.4820000000002},null,{"$f":"' MY STATS'!N16","v":1869.4820000000002},{"$f":"SUM(C42:O42)","v":13086.374000000002},"Basal Metabolic Rate (BMR)"]
[null,null,null,null,null,null,null," "]
["Training ",null,{"$f":"SUM(C15:C16)","v":0},null,{"$f":"SUM(E15:E16)","v":0},null,{"$f":"SUM(G15:G16)","v":0},null,{"$f":"SUM(I15:I16)","v":0},null,{"$f":"SUM(K15:K16)","v":0},null,{"$f":"SUM(M15:M16)","v":0},null,{"$f":"SUM(O15:O16)","v":0},{"$f":"SUM(C44:O44)","v":0},"Training "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C46:O46)","v":-13086.374000000002},"Energy balance (Mon - Sun)"]
["Energy balance",null,{"$f":"SUM(C40-(C42+C44))","v":-1869.4820000000002},null,{"$f":"SUM(E40-(E42+E44))","v":-1869.4820000000002},null,{"$f":"SUM(G40-(G42+G44))","v":-1869.4820000000002},null,{"$f":"SUM(I40-(I42+I44))","v":-1869.4820000000002},null,{"$f":"SUM(K40-(K42+K44))","v":-1869.4820000000002},null,{"$f":"SUM(M40-(M42+M44))","v":-1869.4820000000002},null,{"$f":"SUM(O40-(O42+O44))","v":-1869.4820000000002},{"$f":"SUM('Wk 11'!G46:O46)+SUM(C46:E46)","v":-13086.374000000002},"Energy balance (Wed - Tue)"]

{"sheet":"Week 1","index":17,"n_rows":35,"n_cols":18,"rows_kept":35,"cut":false,"hidden":true,"merged":[[3,9,3,10],[3,11,3,12],[3,13,3,14],[2,13,2,14],[2,11,2,12],[2,9,2,10],[3,1,3,2],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8],[3,3,3,4],[3,5,3,6],[3,7,3,8]]}
["Week 1","Calorie limit",1200,{"$f":"C1*7","v":8400}]
[]
[null,"Monday",null,"Tuesday",null,"Wednesday",null,"Thursday",null,"Friday",null,"Saturday",null,"Sunday",null,null,"Notes"]
[null,"Notes: at home\n",null,"Notes: 8am RBH, 12pm PAH, 3pm home\n** Pack lunch & snacks **",null,"Notes: at home for meals\n3.30 - 5pm tutoring",null,"Notes: at home\n",null,"Notes: 8am RBH, 10am PAH\nGym @ 3pm then home ",null,"Notes: at home\n",null,"Notes: at home\n"]
["breakfast",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"for me yoghurt",40,"meds, celery",0]
[null,"meds, celery",0,"meds, celery",0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"meds, celery",0,"meds, celery",0,"museli",40,"green tea x2",0]
[null,null,null,"skinny cap (starbucks tall)",65,"meds, celery",0,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"meds, celery",0,"baked beans + toast",300]
[null,null,null,null,null,null,null,null,null,"sugar 1 teaspoon",20]
[]
[null,"sub-total",{"$f":"SUM(C5:C6)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(E5:E8)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(G5:G8)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(I5:I8)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(K5:K9)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M5:M8)","v":80},"sub-total",{"$f":"SUM(O5:O8)","v":300}]
["lunch",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"for me yoghurt",80,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"celery x 2",0]
[]
[null,"sub-total",{"$f":"SUM(C11:C14)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(E11:E14)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(G11:G14)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(I11:I14)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(K11:K14)","v":80},"sub-total",{"$f":"SUM(M11:M14)","v":0},"sub-total",{"$f":"SUM(O11:O14)","v":{"$error":"#REF!"}}]
["dinner","1.5 cups pumpkin soup",218,"cauliflower soup",123,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"1 cup pumpkin soup",145,"steak",274,"sushi",700,"salmon",328]
[null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"carrots, broccoli",60,null,null,"strem fresh veg",55]
[null,null,null,null,null,null,null,null,null,"sweet potato chips",200]
[null,"sub-total",{"$f":"SUM(C16:C18)","v":218},"sub-total",{"$f":"SUM(E16:E18)","v":123},"sub-total",{"$f":"SUM(G16:G18)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(I16:I18)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(K16:K18)","v":534},"sub-total",{"$f":"SUM(M16:M18)","v":700},"sub-total",{"$f":"SUM(O16:O18)","v":383}]
["snacks","forme yoghurt",40,"For me youghurt",80,"rice cracker + CC + tomato",80,null,null,null,null,"carmans museli",170]
[null,"rice crackers 7",50]
[null,"sub-total",{"$f":"SUM(C20:C21)","v":90},"sub-total",{"$f":"SUM(E20:E21)","v":80},"sub-total",{"$f":"SUM(G20:G21)","v":80},"sub-total",{"$f":"SUM(I20:I21)","v":0},"sub-total",{"$f":"SUM(K20:K21)","v":0},"sub-total",{"$f":"SUM(M20:M21)","v":170},"sub-total",{"$f":"SUM(O20:O21)","v":0}]
["Total",null,{"$f":"SUM(C10+C15+C19+C22)","v":{"$error":"#REF!"}},null,{"$f":"SUM(E10+E15+E19+E22)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G10+G15+G19+G22)","v":{"$error":"#REF!"}},null,{"$f":"SUM(I10+I15+I19+I22)","v":{"$error":"#REF!"}},null,{"$f":"SUM(K10+K15+K19+K22)","v":{"$error":"#REF!"}},null,{"$f":"SUM(M10+M15+M19+M22)","v":950},null,{"$f":"SUM(O10+O15+O19+O22)","v":{"$error":"#REF!"}},null,"weekly total",{"$f":"SUM(C23:O23)","v":{"$error":"#REF!"}}]
[]
[null,null,{"$f":"C23-$C$1","v":{"$error":"#REF!"}},null,{"$f":"E23-$C$1","v":{"$error":"#REF!"}}," ",{"$f":"G23-$C$1","v":{"$error":"#REF!"}},null,{"$f":"I23-$C$1","v":{"$error":"#REF!"}},null,{"$f":"K23-$C$1","v":{"$error":"#REF!"}},null,{"$f":"M23-$C$1","v":-250},null,{"$f":"O23-$C$1","v":{"$error":"#REF!"}},null,"left over",{"$f":"R23-D1","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null," "]
["Exercise","4.77km in 55 mins",400,null,260,"nil",0,null,null,"pushup 1km etc",null,"sick",null,null,null,null,"avg cal / day",{"$f":"R23/7","v":{"$error":"#REF!"}}]
[]
[null,"Energy balance",{"$f":"C23-C27","v":{"$error":"#REF!"}},null,{"$f":"E23-E27","v":{"$error":"#REF!"}},null,{"$f":"G23-G27","v":{"$error":"#REF!"}},null,{"$f":"I23-I27","v":{"$error":"#REF!"}},null,{"$f":"K23-K27","v":{"$error":"#REF!"}},null,{"$f":"M23-M27","v":950},null,{"$f":"O23-O27","v":{"$error":"#REF!"}}]
[]
[null,"basal metabolic rate",1806,null,1806,null,1806]
[]
[null,"balance for day",{"$f":"C23-C31-C27","v":{"$error":"#REF!"}},null,{"$f":"E23-E31-E27","v":{"$error":"#REF!"}},null,{"$f":"G23-G31-G27","v":{"$error":"#REF!"}}]
[]
["every step you take, every change you make on the 12WBT takes you in the right direction away from the person you were in that before photo :D"]

{"sheet":"week 2","index":18,"n_rows":35,"n_cols":18,"rows_kept":35,"cut":false,"hidden":true,"merged":[[3,9,3,10],[3,11,3,12],[3,13,3,14],[2,13,2,14],[2,11,2,12],[2,9,2,10],[3,1,3,2],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8],[3,3,3,4],[3,5,3,6],[3,7,3,8]]}
["Week 1","Calorie limit",1200,{"$f":"C1*7","v":8400}]
[]
[null,"Monday 28 June",null,"Tuesday 29 June",null,"Wednesday 30 June",null,"Thursday 1 July",null,"Friday 2 July",null,"Saturday 3 July",null,"Sunday 4 July",null,null,"Notes"]
[null,"Notes: at home\n",null,"Notes: 8am RBH, 12pm PAH, 3pm home\n** Pack lunch & snacks **",null,"Notes: at home for meals\n3.30 - 5pm tutoring",null,"Notes: at home\n",null,"Notes: 8am RBH, 10am PAH\nGym @ 3pm then home ",null,"Notes: at home\n",null,"Notes: at home\n"]
["breakfast",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"rye, tuna, cottage cheese, tomato",267]
[null,"meds, celery",0,"meds, celery",0,null,null,"meds, celery",0,"meds, celery",0,"meds, celery",0,"meds, celery",0]
[null,"skinny cap",65,null,null,"meds, celery",0,"skin cap",65,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"museli round",170]
[]
[null,"sub-total",{"$f":"SUM(C5:C6)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(E5:E8)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(G5:G8)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(I5:I8)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(K5:K9)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M5:M8)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O5:O8)","v":267}]
["lunch",null,null,"beef and rice",300,"carmanns museli round",170,"wrap with tuna & salad",300,"japanese",450,"treat meal",600,"rye, tuna, cottage cheese, tomato",267]
[null,null,null,"skin cap",65,"cake",150,"carmans museli",170]
[null,null,null,null,110]
[]
[null,"sub-total",{"$f":"SUM(C11:C14)","v":0},"sub-total",{"$f":"SUM(E11:E14)","v":475},"sub-total",{"$f":"SUM(G11:G14)","v":320},"sub-total",{"$f":"SUM(I11:I14)","v":470},"sub-total",{"$f":"SUM(K11:K14)","v":450},"sub-total",{"$f":"SUM(M11:M14)","v":600},"sub-total",{"$f":"SUM(O11:O14)","v":267}]
["dinner","cauliflower soup",123,"white wine",null,"treat meal",400,"sushi",450,"wine",623,"roast beef and veg",400,"cauliflower soup",123]
[null,null,null,null,null,"cocktail",157,null,null,"salmon",327,null,null,null,null,null,"   "]
[null,null,null,null,null,"white wing",157,null,null,"salmon",327]
[null,"sub-total",{"$f":"SUM(C16:C18)","v":123},"sub-total",{"$f":"SUM(E16:E18)","v":0},"sub-total",{"$f":"SUM(G16:G18)","v":714},"sub-total",{"$f":"SUM(I16:I18)","v":450},"sub-total",{"$f":"SUM(K16:K18)","v":1277},"sub-total",{"$f":"SUM(M16:M18)","v":400},"sub-total",{"$f":"SUM(O16:O18)","v":123}]
["snacks","for me yoghurt",80,"museli round",170,"carmans museli round",170,null,null,null,null,null,null,"rice crackers",60]
[null,"banana",110,"6 rice crackers",50,"skiim cap",65]
[null,"sub-total",{"$f":"SUM(C20:C21)","v":190},"sub-total",{"$f":"SUM(E20:E21)","v":220},"sub-total",{"$f":"SUM(G20:G21)","v":235},"sub-total",{"$f":"SUM(I20:I21)","v":0},"sub-total",{"$f":"SUM(K20:K21)","v":0},"sub-total",{"$f":"SUM(M20:M21)","v":0},"sub-total",{"$f":"SUM(O20:O21)","v":60}]
["Total",null,{"$f":"SUM(C10+C15+C19+C22)","v":{"$error":"#REF!"}},null,{"$f":"SUM(E10+E15+E19+E22)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G10+G15+G19+G22)","v":{"$error":"#REF!"}},null,{"$f":"SUM(I10+I15+I19+I22)","v":{"$error":"#REF!"}},null,{"$f":"SUM(K10+K15+K19+K22)","v":{"$error":"#REF!"}},null,{"$f":"SUM(M10+M15+M19+M22)","v":{"$error":"#REF!"}},null,{"$f":"SUM(O10+O15+O19+O22)","v":717},null,"weekly total",{"$f":"SUM(C23:O23)","v":{"$error":"#REF!"}}]
[]
[null,null,{"$f":"C23-$C$1","v":{"$error":"#REF!"}},null,{"$f":"E23-$C$1","v":{"$error":"#REF!"}}," ",{"$f":"G23-$C$1","v":{"$error":"#REF!"}},null,{"$f":"I23-$C$1","v":{"$error":"#REF!"}},null,{"$f":"K23-$C$1","v":{"$error":"#REF!"}},null,{"$f":"M23-$C$1","v":{"$error":"#REF!"}},null,{"$f":"O23-$C$1","v":-483},null,"left over",{"$f":"R23-D1","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null," "]
["Exercise",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"avg cal / day",{"$f":"R23/7","v":{"$error":"#REF!"}}]
[]
[null,"Energy balance",{"$f":"C23-C27","v":{"$error":"#REF!"}},null,{"$f":"E23-E27","v":{"$error":"#REF!"}},null,{"$f":"G23-G27","v":{"$error":"#REF!"}},null,{"$f":"I23-I27","v":{"$error":"#REF!"}},null,{"$f":"K23-K27","v":{"$error":"#REF!"}},null,{"$f":"M23-M27","v":{"$error":"#REF!"}},null,{"$f":"O23-O27","v":717}]
[]
[null,"basal metabolic rate",1806,null,1806,null,1806]
[]
[null,"balance for day",{"$f":"C23-C31-C27","v":{"$error":"#REF!"}},null,{"$f":"E23-E31-E27","v":{"$error":"#REF!"}},null,{"$f":"G23-G31-G27","v":{"$error":"#REF!"}}]
[]
["every step you take, every change you make on the 12WBT takes you in the right direction away from the person you were in that before photo :D"]

{"sheet":"week 3","index":19,"n_rows":36,"n_cols":18,"rows_kept":36,"cut":false,"hidden":true,"merged":[[3,9,3,10],[3,11,3,12],[3,13,3,14],[2,13,2,14],[2,11,2,12],[2,9,2,10],[3,1,3,2],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8],[3,3,3,4],[3,5,3,6],[3,7,3,8]]}
["Week 3","Calorie limit",1200,{"$f":"C1*7","v":8400}]
[]
[null,"Monday 5 July",null,"Tuesday 6 July",null,"Wednesday 7 July",null,"Thursday 8 July",null,"Friday 9 July",null,"Saturday 10 July",null,"Sunday 11 July",null,null,"Notes"]
["red flags","**Tyrone's party **\nTeaching all day",null,"day before weigh in - exercise hard, eat light",null,"WEIGH IN - GOAL = 93",null,null,null,"** Thai lunch for Mel **"]
["exercise",null,null,null,null,"PT Session @ FF"]
["breakfast","metamucil",60,"carmans",170,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"meds, celery",0,"meds, celery",0,"meds, celery",0,"meds, celery",0,"meds, celery",0,"meds, celery",0,"meds, celery",0]
[null,"skinny cap",65,"metmucil",60,"green tea"]
[null,null,null,"skinny cap",65,"rye tuna leaves toms onion",300]
[null,null,null,null,null,"skinny cap",50]
[null,"sub-total",{"$f":"SUM(C6:C7)","v":60},"sub-total",{"$f":"SUM(E6:E9)","v":295},"sub-total",{"$f":"SUM(G6:G9)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(I6:I9)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(K6:K10)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M6:M9)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O6:O9)","v":{"$error":"#REF!"}}]
["lunch","rye tuna leaves toms onion",300,"skinny cap",65,"rye tuna leaves toms onion",300,"pumpkin soup",246.5,"treat meal - thai",450,"pumpkin soup",246.5,"cauliflower soup",123]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C12:C15)","v":300},"sub-total",{"$f":"SUM(E12:E15)","v":65},"sub-total",{"$f":"SUM(G12:G15)","v":300},"sub-total",{"$f":"SUM(I12:I15)","v":246.5},"sub-total",{"$f":"SUM(K12:K15)","v":450},"sub-total",{"$f":"SUM(M12:M15)","v":246.5},"sub-total",{"$f":"SUM(O12:O15)","v":123}]
["dinner","rye tuna toms onion",267,"sushi",700,"sushi",600,"cauliflower soup",123,"pumpkin soup",246.5,"cauliflower soup",123,"pumpkin soup",246.5]
[null,"steak etc",300,null,null,null,null,null,null,null,null,null,null,null,null,null,"   "]
[null,"cake",200]
[null,"sub-total",{"$f":"SUM(C17:C19)","v":767},"sub-total",{"$f":"SUM(E17:E19)","v":700},"sub-total",{"$f":"SUM(G17:G19)","v":600},"sub-total",{"$f":"SUM(I17:I19)","v":123},"sub-total",{"$f":"SUM(K17:K19)","v":246.5},"sub-total",{"$f":"SUM(M17:M19)","v":123},"sub-total",{"$f":"SUM(O17:O19)","v":246.5}]
["snacks"]
[]
[null,"sub-total",{"$f":"SUM(C21:C22)","v":0},"sub-total",{"$f":"SUM(E21:E22)","v":0},"sub-total",{"$f":"SUM(G21:G22)","v":0},"sub-total",{"$f":"SUM(I21:I22)","v":0},"sub-total",{"$f":"SUM(K21:K22)","v":0},"sub-total",{"$f":"SUM(M21:M22)","v":0},"sub-total",{"$f":"SUM(O21:O22)","v":0}]
["Total",null,{"$f":"SUM(C11+C16+C20+C23)","v":1127},null,{"$f":"SUM(E11+E16+E20+E23)","v":1060},null,{"$f":"SUM(G11+G16+G20+G23)","v":{"$error":"#REF!"}},null,{"$f":"SUM(I11+I16+I20+I23)","v":{"$error":"#REF!"}},null,{"$f":"SUM(K11+K16+K20+K23)","v":{"$error":"#REF!"}},null,{"$f":"SUM(M11+M16+M20+M23)","v":{"$error":"#REF!"}},null,{"$f":"SUM(O11+O16+O20+O23)","v":{"$error":"#REF!"}},null,"weekly total",{"$f":"SUM(C24:O24)","v":{"$error":"#REF!"}}]
[]
[null,null,{"$f":"C24-$C$1","v":-73},null,{"$f":"E24-$C$1","v":-140}," ",{"$f":"G24-$C$1","v":{"$error":"#REF!"}},null,{"$f":"I24-$C$1","v":{"$error":"#REF!"}},null,{"$f":"K24-$C$1","v":{"$error":"#REF!"}},null,{"$f":"M24-$C$1","v":{"$error":"#REF!"}},null,{"$f":"O24-$C$1","v":{"$error":"#REF!"}},null,"left over",{"$f":"R24-D1","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null," "]
["Exercise",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"avg cal / day",{"$f":"R24/7","v":{"$error":"#REF!"}}]
[]
[null,"Energy balance",{"$f":"C24-C28","v":1127},null,{"$f":"E24-E28","v":1060},null,{"$f":"G24-G28","v":{"$error":"#REF!"}},null,{"$f":"I24-I28","v":{"$error":"#REF!"}},null,{"$f":"K24-K28","v":{"$error":"#REF!"}},null,{"$f":"M24-M28","v":{"$error":"#REF!"}},null,{"$f":"O24-O28","v":{"$error":"#REF!"}}]
[]
[null,"basal metabolic rate",1750,null,1750,null,1750,null,1750,null,1750,null,1750,null,1750]
[]
[null,"balance for day",{"$f":"C24-C32-C28","v":-623},null,{"$f":"E24-E32-E28","v":-690},null,{"$f":"G24-G32-G28","v":{"$error":"#REF!"}},null,{"$f":"I24-I32-I28","v":{"$error":"#REF!"}},null,{"$f":"K24-K32-K28","v":{"$error":"#REF!"}},null,{"$f":"M24-M32-M28","v":{"$error":"#REF!"}},null,{"$f":"O24-O32-O28","v":{"$error":"#REF!"}}]
[]
["every step you take, every change you make on the 12WBT takes you in the right direction away from the person you were in that before photo :D"]

{"sheet":"Week 4","index":20,"n_rows":35,"n_cols":18,"rows_kept":35,"cut":false,"hidden":true,"merged":[[3,9,3,10],[3,11,3,12],[3,13,3,14],[2,13,2,14],[2,11,2,12],[2,9,2,10],[3,1,3,2],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8],[3,3,3,4],[3,5,3,6],[3,7,3,8]]}
["Week 1","Calorie limit",1200,{"$f":"C1*7","v":8400}]
[]
[null,"Monday",null,"Tuesday",null,"Wednesday",null,"Thursday",null,"Friday",null,"Saturday",null,"Sunday",null,null,"Notes"]
[null,"Notes: 8-2 PBL\n",null,"Notes: 11-2 PAH\n** Pack lunch & snacks **",null,"Notes: at home for meals\n",null,"Notes: at home\n",null,"Notes: 10 - 12 PAH. \nDrinks for Mel\n",null,"Notes: at home\n",null,"Notes: at home\n"]
["breakfast",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"meds, celery",0,"meds, celery",0]
[null,"meds, celery",0,"meds, celery",0,"meds, celery",0,"meds, celery",0,"meds, celery",0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"banana",110,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"banana",110,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"banana",110]
[null,"forme yoghurt",40,null,null,null,null,"banana",110]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"sub-total",{"$f":"SUM(C5:C9)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(E5:E8)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(G5:G8)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(I5:I8)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(K5:K9)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M5:M8)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O5:O8)","v":{"$error":"#REF!"}}]
["lunch","flat bread, tuna, tom, onion, leaves, beetroot",300,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"wrap tuna salad ",300]
[null,"2 x museli bars",220]
[]
[null,"sub-total",{"$f":"SUM(C11:C14)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(E11:E14)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(G11:G14)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(I11:I14)","v":300},"sub-total",{"$f":"SUM(K11:K14)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M11:M14)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O11:O14)","v":{"$error":"#REF!"}}]
["dinner","2 rye, steak",275,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"mels drinks",450,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"tomato, cottage cheese",50,null,null,"cauli soup 1.5cups",92,"sushi",350]
[]
[null,"sub-total",{"$f":"SUM(C16:C18)","v":325},"sub-total",{"$f":"SUM(E16:E18)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(G16:G18)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(I16:I18)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(K16:K18)","v":450},"sub-total",{"$f":"SUM(M16:M18)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O16:O18)","v":{"$error":"#REF!"}}]
["snacks","forme yoghurt",40,"make up for Monday",52,"make up for Monday",52,"make up for Monday",52,"make up for Monday",52,"make up for Monday",52,"make up for Monday",52]
[null,"rye with honey",90,"save for drinks",150,"save for drinks",150,"save for drinks",150,"save for drinks",150,"save for drinks",150,"save for drinks",150]
[null,"sub-total",{"$f":"SUM(C20:C21)","v":130},"sub-total",{"$f":"SUM(E20:E21)","v":202},"sub-total",{"$f":"SUM(G20:G21)","v":202},"sub-total",{"$f":"SUM(I20:I21)","v":202},"sub-total",{"$f":"SUM(K20:K21)","v":202},"sub-total",{"$f":"SUM(M20:M21)","v":202},"sub-total",{"$f":"SUM(O20:O21)","v":202}]
["Total",null,{"$f":"SUM(C10+C15+C19+C22)","v":{"$error":"#REF!"}},null,{"$f":"SUM(E10+E15+E19+E22)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G10+G15+G19+G22)","v":{"$error":"#REF!"}},null,{"$f":"SUM(I10+I15+I19+I22)","v":{"$error":"#REF!"}},null,{"$f":"SUM(K10+K15+K19+K22)","v":{"$error":"#REF!"}},null,{"$f":"SUM(M10+M15+M19+M22)","v":{"$error":"#REF!"}},null,{"$f":"SUM(O10+O15+O19+O22)","v":{"$error":"#REF!"}},null,"weekly total",{"$f":"SUM(C23:O23)","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"E23-E22","v":{"$error":"#REF!"}},null,{"$f":"G23-G22","v":{"$error":"#REF!"}},null,{"$f":"I23-I22","v":{"$error":"#REF!"}},null,{"$f":"K23-K22","v":{"$error":"#REF!"}},null,{"$f":"M23-M22","v":{"$error":"#REF!"}},null,{"$f":"O23-O22","v":{"$error":"#REF!"}}]
[null,null,{"$f":"C23-$C$1","v":{"$error":"#REF!"}},null,{"$f":"E23-$C$1","v":{"$error":"#REF!"}}," ",{"$f":"G23-$C$1","v":{"$error":"#REF!"}},null,{"$f":"I23-$C$1","v":{"$error":"#REF!"}},null,{"$f":"K23-$C$1","v":{"$error":"#REF!"}},null,{"$f":"M23-$C$1","v":{"$error":"#REF!"}},null,{"$f":"O23-$C$1","v":{"$error":"#REF!"}},null,"left over",{"$f":"R23-D1","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null," ",null,null,{"$f":"E21*4","v":600}]
["Exercise",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"avg cal / day",{"$f":"R23/7","v":{"$error":"#REF!"}}]
[]
[null,"Energy balance",{"$f":"C23-C27","v":{"$error":"#REF!"}},null,{"$f":"E23-E27","v":{"$error":"#REF!"}},null,{"$f":"G23-G27","v":{"$error":"#REF!"}},null,{"$f":"I23-I27","v":{"$error":"#REF!"}},null,{"$f":"K23-K27","v":{"$error":"#REF!"}},null,{"$f":"M23-M27","v":{"$error":"#REF!"}},null,{"$f":"O23-O27","v":{"$error":"#REF!"}}]
[]
[null,"basal metabolic rate",1806,null,1806,null,1806,null,1806,null,1806,null,1806,null,1806]
[]
[null,"balance for day",{"$f":"C23-C31-C27","v":{"$error":"#REF!"}},null,{"$f":"E23-E31-E27","v":{"$error":"#REF!"}},null,{"$f":"G23-G31-G27","v":{"$error":"#REF!"}},null,{"$f":"I23-I31-I27","v":{"$error":"#REF!"}},null,{"$f":"K23-K31-K27","v":{"$error":"#REF!"}},null,{"$f":"M23-M31-M27","v":{"$error":"#REF!"}},null,{"$f":"O23-O31-O27","v":{"$error":"#REF!"}}]
[]
["every step you take, every change you make on the 12WBT takes you in the right direction away from the person you were in that before photo :D"]

{"sheet":"week 5","index":21,"n_rows":35,"n_cols":18,"rows_kept":35,"cut":false,"hidden":true,"merged":[[3,9,3,10],[3,11,3,12],[3,13,3,14],[2,13,2,14],[2,11,2,12],[2,9,2,10],[3,1,3,2],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8],[3,3,3,4],[3,5,3,6],[3,7,3,8]]}
["Week 1","Calorie limit",1200,{"$f":"C1*7","v":8400}]
[]
[null,"Monday",null,"Tuesday",null,"Wednesday",null,"Thursday",null,"Friday",null,"Saturday",null,"Sunday",null,null,"Notes"]
[null,"Notes: 8-2 PBL\n",null,"Notes: 11-2 PAH\n** Pack lunch & snacks **",null,"Notes: at home for meals\n",null,"Notes: at home\n",null,"Notes: 10 - 12 PAH. \nDrinks for Mel\n",null,"Notes: at home\n",null,"Notes: at home\n"]
["breakfast","cartmans",null,"special K",null,"special k",null,"special K"]
[null,null,null,null,null,null,null,"metamucil"]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C5:C9)","v":0},"sub-total",{"$f":"SUM(E5:E8)","v":0},"sub-total",{"$f":"SUM(G5:G8)","v":0},"sub-total",{"$f":"SUM(I5:I8)","v":0},"sub-total",{"$f":"SUM(K5:K9)","v":0},"sub-total",{"$f":"SUM(M5:M8)","v":0},"sub-total",{"$f":"SUM(O5:O8)","v":0}]
["lunch",null,null,null,null,"rye, tuna, tomato, cottage cheese",null,"flat bread, tuna and salad",300]
[null,null,null,null,null,"1 bear biscuit"]
[null,null,null,null,null,"hot chocolate"]
[]
[null,"sub-total",{"$f":"SUM(C11:C14)","v":0},"sub-total",{"$f":"SUM(E11:E14)","v":0},"sub-total",{"$f":"SUM(G11:G14)","v":0},"sub-total",{"$f":"SUM(I11:I14)","v":300},"sub-total",{"$f":"SUM(K11:K14)","v":0},"sub-total",{"$f":"SUM(M11:M14)","v":0},"sub-total",{"$f":"SUM(O11:O14)","v":0}]
["dinner",null,null,null,null,"mecca bah",null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"cocktail"]
[null,null,null,null,null,"hot chocolate"]
[null,"sub-total",{"$f":"SUM(C16:C18)","v":0},"sub-total",{"$f":"SUM(E16:E18)","v":0},"sub-total",{"$f":"SUM(G16:G18)","v":0},"sub-total",{"$f":"SUM(I16:I18)","v":0},"sub-total",{"$f":"SUM(K16:K18)","v":0},"sub-total",{"$f":"SUM(M16:M18)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O16:O18)","v":{"$error":"#REF!"}}]
["snacks"]
[]
[null,"sub-total",{"$f":"SUM(C20:C21)","v":0},"sub-total",{"$f":"SUM(E20:E21)","v":0},"sub-total",{"$f":"SUM(G20:G21)","v":0},"sub-total",{"$f":"SUM(I20:I21)","v":0},"sub-total",{"$f":"SUM(K20:K21)","v":0},"sub-total",{"$f":"SUM(M20:M21)","v":0},"sub-total",{"$f":"SUM(O20:O21)","v":0}]
["Total",null,{"$f":"SUM(C10+C15+C19+C22)","v":0},null,{"$f":"SUM(E10+E15+E19+E22)","v":0},null,{"$f":"SUM(G10+G15+G19+G22)","v":0},null,{"$f":"SUM(I10+I15+I19+I22)","v":300},null,{"$f":"SUM(K10+K15+K19+K22)","v":0},null,{"$f":"SUM(M10+M15+M19+M22)","v":{"$error":"#REF!"}},null,{"$f":"SUM(O10+O15+O19+O22)","v":{"$error":"#REF!"}},null,"weekly total",{"$f":"SUM(C23:O23)","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"E23-E22","v":0},null,{"$f":"G23-G22","v":0},null,{"$f":"I23-I22","v":300},null,{"$f":"K23-K22","v":0},null,{"$f":"M23-M22","v":{"$error":"#REF!"}},null,{"$f":"O23-O22","v":{"$error":"#REF!"}}]
[null,null,{"$f":"C23-$C$1","v":-1200},null,{"$f":"E23-$C$1","v":-1200}," ",{"$f":"G23-$C$1","v":-1200},null,{"$f":"I23-$C$1","v":-900},null,{"$f":"K23-$C$1","v":-1200},null,{"$f":"M23-$C$1","v":{"$error":"#REF!"}},null,{"$f":"O23-$C$1","v":{"$error":"#REF!"}},null,"left over",{"$f":"R23-D1","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null," ",null,null,{"$f":"E21*4","v":0}]
["Exercise",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"avg cal / day",{"$f":"R23/7","v":{"$error":"#REF!"}}]
[]
[null,"Energy balance",{"$f":"C23-C27","v":0},null,{"$f":"E23-E27","v":0},null,{"$f":"G23-G27","v":0},null,{"$f":"I23-I27","v":300},null,{"$f":"K23-K27","v":0},null,{"$f":"M23-M27","v":{"$error":"#REF!"}},null,{"$f":"O23-O27","v":{"$error":"#REF!"}}]
[]
[null,"basal metabolic rate",1806,null,1806,null,1806,null,1806,null,1806,null,1806,null,1806]
[]
[null,"balance for day",{"$f":"C23-C31-C27","v":-1806},null,{"$f":"E23-E31-E27","v":-1806},null,{"$f":"G23-G31-G27","v":-1806},null,{"$f":"I23-I31-I27","v":-1506},null,{"$f":"K23-K31-K27","v":-1806},null,{"$f":"M23-M31-M27","v":{"$error":"#REF!"}},null,{"$f":"O23-O31-O27","v":{"$error":"#REF!"}}]
[]
["every step you take, every change you make on the 12WBT takes you in the right direction away from the person you were in that before photo :D"]

{"sheet":"Week 6","index":22,"n_rows":40,"n_cols":18,"rows_kept":40,"cut":false,"hidden":true,"merged":[[8,9,8,10],[8,11,8,12],[8,13,8,14],[7,13,7,14],[7,11,7,12],[7,9,7,10],[8,1,8,2],[7,1,7,2],[7,3,7,4],[7,5,7,6],[7,7,7,8],[8,3,8,4],[8,5,8,6],[8,7,8,8]]}
["Week 6","Calorie limit",1200,{"$f":"C1*7","v":8400}]
[]
[]
[]
[]
[]
[]
[null,"Monday 26 July",null,"Tuesday 27 July",null,"Wednesday 28 July",null,"Thursday 29 July",null,"Friday 30 July",null,"Saturday 31 July",null,"Sunday 1 August",null,null,"Notes"]
[null,"Notes: 8-2 PBL. \nBuy salad sandwich, pack snacks",null,"Notes:",null,"Notes: ",null,"Notes:  10 - 3 PBL. \nBuy salad sandwich, pack snacks\n",null,"CSIRO Ed - pack lunch & snacks for whole day",null,"Notes: \n",null,"Notes: \n"]
["breakfast","skinny cap",65,"Baked Beans (220g), 1x toast, no butter",290,"Baked Beans (220g), 1x toast, no butter",290,"skinny cap",65,"carmans",190,"scrambled eggs, tomato",153,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"meds, celery",0,"1 x rye bread toast",75,"1 x rye bread toast",75,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"meds, celery",0,"meds, celery",0,"meds, celery",0,"meds, celery",0]
[null,null,null,"meds, celery",0,"meds, celery",0,"carmans",190,null,null,"2 x rye bread",193]
[null,null,null,null,null,null,null,"strawberries",55,null,null,"logicol",10]
[null,"sub-total",{"$f":"SUM(C10:C14)","v":65},"sub-total",{"$f":"SUM(E10:E13)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(G10:G13)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(I10:I14)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(K10:K14)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M10:M14)","v":356},"sub-total",{"$f":"SUM(O10:O12)","v":{"$error":"#REF!"}}]
["lunch","rye bread, tuna, salad",300,"carmans museli",190,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"1/2 carmans",95,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"carmans",170,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null," ",null,null,null,"soup",250,null,null,"carmans",190,null,null,"soup ",250]
[]
[]
[null,"sub-total",{"$f":"SUM(C16:C19)","v":300},"sub-total",{"$f":"SUM(E16:E19)","v":190},"sub-total",{"$f":"SUM(G16:G19)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(I16:I19)","v":95},"sub-total",{"$f":"SUM(K16:K19)","v":{"$error":"#REF!"}},null,{"$f":"SUM(M16:M19)","v":170},"sub-total",{"$f":"SUM(O16:O19)","v":{"$error":"#REF!"}}]
["dinner","chicken kantong & rice",400,"sushi",350,null,null,"sushi",400,"rye tuna salad",300,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"2 x rye toast and honey",200,null,null,null,null,null,null,null,null,null,null,"soup",250]
[]
[null,"sub-total",{"$f":"SUM(C21:C23)","v":600},"sub-total",{"$f":"SUM(E21:E23)","v":350},"sub-total",{"$f":"SUM(G21:G23)","v":0},"sub-total",{"$f":"SUM(I21:I23)","v":400},"sub-total",{"$f":"SUM(K21:K23)","v":300},"sub-total",{"$f":"SUM(M21:M23)","v":0},"sub-total",{"$f":"SUM(O21:O23)","v":{"$error":"#REF!"}}]
["snacks","carman's museli bar",190,"carman's museli bar",190,"carmans",190]
[null,"carman's museli bar",190]
[null,"sub-total",{"$f":"SUM(C25:C26)","v":380},"sub-total",{"$f":"SUM(E25:E26)","v":190},"sub-total",{"$f":"SUM(G25:G26)","v":190},"sub-total",{"$f":"SUM(I25:I26)","v":0},"sub-total",{"$f":"SUM(K25:K26)","v":0},"sub-total",{"$f":"SUM(M25:M26)","v":0},"sub-total",{"$f":"SUM(O25:O26)","v":0}]
["Total",null,{"$f":"SUM(C15+C20+C24+C27)","v":1345},null,{"$f":"SUM(E15+E20+E24+E27)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G15+G20+G24+G27)","v":{"$error":"#REF!"}},null,{"$f":"SUM(I15+I20+I24+I27)","v":{"$error":"#REF!"}},null,{"$f":"SUM(K15+K20+K24+K27)","v":{"$error":"#REF!"}},null,{"$f":"SUM(M15+M20+M24+M27)","v":526},null,{"$f":"SUM(O15+O20+O24+O27)","v":{"$error":"#REF!"}},null,"weekly total",{"$f":"SUM(C28:O28)","v":{"$error":"#REF!"}}]
[]
["remaining calories",null,{"$f":"C28-$C$1","v":145},null,{"$f":"E28-$C$1","v":{"$error":"#REF!"}}," ",{"$f":"G28-$C$1","v":{"$error":"#REF!"}},null,{"$f":"I28-$C$1","v":{"$error":"#REF!"}},null,{"$f":"K28-$C$1","v":{"$error":"#REF!"}},null,{"$f":"M28-$C$1","v":-674},null,{"$f":"O28-$C$1","v":{"$error":"#REF!"}},null,"left over",{"$f":"R28-D1","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null," "]
["Exercise",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"avg cal / day",{"$f":"R28/7","v":{"$error":"#REF!"}}]
[]
[null,"Energy balance",{"$f":"C28-C32","v":1345},null,{"$f":"E28-E32","v":{"$error":"#REF!"}},null,{"$f":"G28-G32","v":{"$error":"#REF!"}},null,{"$f":"I28-I32","v":{"$error":"#REF!"}},null,{"$f":"K28-K32","v":{"$error":"#REF!"}},null,{"$f":"M28-M32","v":526},null,{"$f":"O28-O32","v":{"$error":"#REF!"}}]
[]
[null,"basal metabolic rate",1738,null,1730,null,1730,null,1730,null,1738,null,1738,null,1738]
[]
[null,"balance for day",{"$f":"C28-C36-C32","v":-393},null,{"$f":"E28-E36-E32","v":{"$error":"#REF!"}},null,{"$f":"G28-G36-G32","v":{"$error":"#REF!"}},null,{"$f":"I28-I36-I32","v":{"$error":"#REF!"}},null,{"$f":"K28-K36-K32","v":{"$error":"#REF!"}},null,{"$f":"M28-M36-M32","v":-1212},null,{"$f":"O28-O36-O32","v":{"$error":"#REF!"}}]
[]
["every step you take, every change you make on the 12WBT takes you in the right direction away from the person you were in that before photo :D"]

{"sheet":"Week 7","index":23,"n_rows":41,"n_cols":18,"rows_kept":41,"cut":false,"hidden":true,"merged":[[9,9,9,10],[9,11,9,12],[9,13,9,14],[8,13,8,14],[8,11,8,12],[8,9,8,10],[9,1,9,2],[8,1,8,2],[8,3,8,4],[8,5,8,6],[8,7,8,8],[9,3,9,4],[9,5,9,6],[9,7,9,8]]}
["Week 6","Calorie limit",1200,{"$f":"C1*7","v":8400}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"35 min walk in AM"]
[null,null,null,null,null,null,null,null,null,null,null,"lowest wt to date! Yay!"]
[]
[null,null,null,null,null,null,null,null,null,null,null,96.5]
[null,"Monday 2 August",null,"Tuesday 3 ",null,"Wednesday 4",null,"Thursday 5",null,"Friday 6",null,"Saturday 7",null,"Sunday 8",null,null,"Notes"]
[null,"Notes: 8-2 PBL. \nBuy salad sandwich, pack snacks",null,"Notes:",null,"Notes: ",null,"Notes:  10 - 3 PBL. \nBuy salad sandwich, pack snacks\n",null,"CSIRO Ed - pack lunch & snacks for whole day",null,"Notes: \n"]
["breakfast","special k and milk",166,"special k and milk",166,"carmans",190,"special k",166,"special k",166,"2 egs & 2 rye + logicol",350]
[null,"meds",0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"meds, celery",0,"meds, celery",0,"meds, celery",0,"meds, celery",0,"meds, celery",0,"meds, celery",0]
[]
[]
[null,"sub-total",{"$f":"SUM(C11:C15)","v":166},"sub-total",{"$f":"SUM(E11:E14)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(G11:G14)","v":190},"sub-total",{"$f":"SUM(I11:I14)","v":166},"sub-total",{"$f":"SUM(K11:K15)","v":166},"sub-total",{"$f":"SUM(M11:M14)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O11:O14)","v":{"$error":"#REF!"}}]
["lunch","rye tuna salad",250,null,null,null,null,"carmans",190,"carmans",190,"soup",250]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[null,"sub-total",{"$f":"SUM(C17:C20)","v":250},"sub-total",{"$f":"SUM(E17:E20)","v":0},"sub-total",{"$f":"SUM(G17:G20)","v":0},"sub-total",{"$f":"SUM(I17:I20)","v":190},"sub-total",{"$f":"SUM(K17:K20)","v":190},"sub-total",{"$f":"SUM(M17:M20)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O17:O20)","v":{"$error":"#REF!"}}]
["dinner","soup",246,"soup",246,"carmans",190,"sushi",350,"salmon x 2",300]
[null,null,null,null,null,null,null,"carmans",190,"rye tuna salad",250,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"sub-total",{"$f":"SUM(C22:C24)","v":246},"sub-total",{"$f":"SUM(E22:E24)","v":246},"sub-total",{"$f":"SUM(G22:G24)","v":190},"sub-total",{"$f":"SUM(I22:I24)","v":540},"sub-total",{"$f":"SUM(K22:K24)","v":550},"sub-total",{"$f":"SUM(M22:M24)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O22:O24)","v":{"$error":"#REF!"}}]
["snacks",null,null,null,null,null,null,"sorbet",200,"carmans",190]
[null,null,null,null,null,null,null,null,null,"carmans",190]
[null,"sub-total",{"$f":"SUM(C26:C27)","v":0},"sub-total",{"$f":"SUM(E26:E27)","v":0},"sub-total",{"$f":"SUM(G26:G27)","v":0},"sub-total",{"$f":"SUM(I26:I27)","v":200},"sub-total",{"$f":"SUM(K26:K27)","v":380},"sub-total",{"$f":"SUM(M26:M27)","v":0},"sub-total",{"$f":"SUM(O26:O27)","v":0}]
["Total",null,{"$f":"SUM(C16+C21+C25+C28)","v":662},null,{"$f":"SUM(E16+E21+E25+E28)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G16+G21+G25+G28)","v":380},null,{"$f":"SUM(I16+I21+I25+I28)","v":1096},null,{"$f":"SUM(K16+K21+K25+K28)","v":1286},null,{"$f":"SUM(M16+M21+M25+M28)","v":{"$error":"#REF!"}},null,{"$f":"SUM(O16+O21+O25+O28)","v":{"$error":"#REF!"}},null,"weekly total",{"$f":"SUM(C29:O29)","v":{"$error":"#REF!"}}]
[]
["remaining calories",null,{"$f":"C29-$C$1","v":-538},null,{"$f":"E29-$C$1","v":{"$error":"#REF!"}}," ",{"$f":"G29-$C$1","v":-820},null,{"$f":"I29-$C$1","v":-104},null,{"$f":"K29-$C$1","v":86},null,{"$f":"M29-$C$1","v":{"$error":"#REF!"}},null,{"$f":"O29-$C$1","v":{"$error":"#REF!"}},null,"left over",{"$f":"R29-D1","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null," "]
["Exercise",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"avg cal / day",{"$f":"R29/7","v":{"$error":"#REF!"}}]
[]
[null,"Energy balance",{"$f":"C29-C33","v":662},null,{"$f":"E29-E33","v":{"$error":"#REF!"}},null,{"$f":"G29-G33","v":380},null,{"$f":"I29-I33","v":1096},null,{"$f":"K29-K33","v":1286},null,{"$f":"M29-M33","v":{"$error":"#REF!"}},null,{"$f":"O29-O33","v":{"$error":"#REF!"}}]
[]
[null,"basal metabolic rate",1738,null,1738,null,1738,null,1738,null,1738,null,1738,null,1738]
[]
[null,"balance for day",{"$f":"C29-C37-C33","v":-1076},null,{"$f":"E29-E37-E33","v":{"$error":"#REF!"}},null,{"$f":"G29-G37-G33","v":-1358},null,{"$f":"I29-I37-I33","v":-642},null,{"$f":"K29-K37-K33","v":-452},null,{"$f":"M29-M37-M33","v":{"$error":"#REF!"}},null,{"$f":"O29-O37-O33","v":{"$error":"#REF!"}}]
[]
["every step you take, every change you make on the 12WBT takes you in the right direction away from the person you were in that before photo :D"]

{"sheet":"Week 8","index":24,"n_rows":45,"n_cols":19,"rows_kept":45,"cut":false,"hidden":true,"merged":[[10,9,10,10],[10,11,10,12],[10,13,10,14],[9,13,9,14],[9,11,9,12],[9,9,9,10],[10,1,10,2],[9,1,9,2],[9,3,9,4],[9,5,9,6],[9,7,9,8],[10,3,10,4],[10,5,10,6],[10,7,10,8]]}
["Week 8","Calorie limit",1200,{"$f":"C1*7","v":8400}]
[]
[]
[]
[]
[]
[]
[null,"14km bike","YES","10 km walk"]
[null,"ACCELERATOR DAY","YES","ACCELERATOR DAY",null,null,null,null,94.5]
[null,"Monday 9 August",null,"Tuesday 10",null,"Wednesday 11",null,"Thursday 12",null,"Friday 13",null,"Saturday 14",null,"Sunday 15",null,null,"Notes"]
[null,"Notes: 8-2 PBL. \nBuy salad sandwich, pack snacks",null,"Notes:",null,"Notes: ",null,"Notes:  10 - 3 PBL. \nBuy salad sandwich, pack snacks\n",null,null,null,"Notes: \n",null,"Notes: \n"]
["breakfast","meds, celery",0,null,null,"carmans",190,"carmans",190,"carmans",190,"2 rye",193,null,300]
[null,"green tea x 2",0,null,null,null,null,null,null,"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"1 egg",71,"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,"meds, celery",0,"egg white",13,"meds, celery",0]
[null,null,null,null,null,null,null,null,null,null,null,"1/2 cup physical",53]
[null,null,null,null,null,null,null,null,null,null,null,"1 tomato",18]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M12:M16)","v":348}]
[null,null,null,null,null,null,null,null,null,null,null,"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"meds, celery",0]
[null,"sub-total",{"$f":"SUM(C12:C15)","v":0},"sub-total",{"$f":"SUM(E12:E15)","v":0},"sub-total",{"$f":"SUM(G12:G15)","v":190},"sub-total",{"$f":"SUM(I12:I15)","v":190},"sub-total",{"$f":"SUM(K12:K19)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M12:M19)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O12:O15)","v":{"$error":"#REF!"}}]
["lunch","casserole",285,null,null,"casserole & 1 bread",300,"carmans",190,"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"green tea x 2",0,null,null,null,null,"half orange",40,"wrap ",350,"cauli soup",125]
[null,null,null,null,null,null,null,null,null,"carmans",190]
[]
[null,"sub-total",{"$f":"SUM(C21:C24)","v":285},"sub-total",{"$f":"SUM(E21:E24)","v":0},"sub-total",{"$f":"SUM(G21:G24)","v":300},"sub-total",{"$f":"SUM(I21:I24)","v":230},"sub-total",{"$f":"SUM(K21:K24)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M21:M24)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O21:O24)","v":{"$error":"#REF!"}}]
["dinner","casserole",285,"sushi",350,"soup",246," ",null,"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"casserole",285,"hot choc",45,null,null,null,null,"soup",120]
[null,null,null,null,null,null,null,null,null,"wrap",250]
[null,"sub-total",{"$f":"SUM(C26:C28)","v":570},"sub-total",{"$f":"SUM(E26:E28)","v":395},"sub-total",{"$f":"SUM(G26:G28)","v":246},"sub-total",{"$f":"SUM(I26:I28)","v":0},"sub-total",{"$f":"SUM(K26:K28)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M26:M28)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O26:O28)","v":{"$error":"#REF!"}}]
["snacks"]
[]
[null,"sub-total",{"$f":"SUM(C30:C31)","v":0},"sub-total",{"$f":"SUM(E30:E31)","v":0},"sub-total",{"$f":"SUM(G30:G31)","v":0},"sub-total",{"$f":"SUM(I30:I31)","v":0},"sub-total",{"$f":"SUM(K30:K31)","v":0},"sub-total",{"$f":"SUM(M30:M31)","v":0},"sub-total",{"$f":"SUM(O30:O31)","v":0}]
["Total",null,{"$f":"SUM(C20+C25+C29+C32)","v":855},null,{"$f":"SUM(E20+E25+E29+E32)","v":395},null,{"$f":"SUM(G20+G25+G29+G32)","v":736},null,{"$f":"SUM(I20+I25+I29+I32)","v":420},null,{"$f":"SUM(K20+K25+K29+K32)","v":{"$error":"#REF!"}},null,{"$f":"SUM(M20+M25+M29+M32)","v":{"$error":"#REF!"}},null,{"$f":"SUM(O20+O25+O29+O32)","v":{"$error":"#REF!"}},null,"weekly total",{"$f":"SUM(C33:O33)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,{"$f":"SUM(C33+D33+G33)","v":1591}]
["remaining calories",null,{"$f":"C33-$C$1","v":-345},null,{"$f":"E33-$C$1","v":-805}," ",{"$f":"G33-$C$1","v":-464},null,{"$f":"I33-$C$1","v":-780},null,{"$f":"K33-$C$1","v":{"$error":"#REF!"}},null,{"$f":"M33-$C$1","v":{"$error":"#REF!"}},null,{"$f":"O33-$C$1","v":{"$error":"#REF!"}},null,"left over",{"$f":"R33-D1","v":{"$error":"#REF!"}},{"$f":"R35/1200","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null," "]
["Exercise",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"avg cal / day",{"$f":"R33/7","v":{"$error":"#REF!"}}]
[]
[null,"Energy balance",{"$f":"C33-C37","v":855},null,{"$f":"E33-E37","v":395},null,{"$f":"G33-G37","v":736},null,{"$f":"I33-I37","v":420},null,{"$f":"K33-K37","v":{"$error":"#REF!"}},null,{"$f":"M33-M37","v":{"$error":"#REF!"}},null,{"$f":"O33-O37","v":{"$error":"#REF!"}}]
[]
[null,"basal metabolic rate",1728,null,1728,null,1728,null,1728,null,1728,null,1728,null,1728]
[]
[null,"balance for day",{"$f":"C33-C41-C37","v":-873},null,{"$f":"E33-E41-E37","v":-1333},null,{"$f":"G33-G41-G37","v":-992},null,{"$f":"I33-I41-I37","v":-1308},null,{"$f":"K33-K41-K37","v":{"$error":"#REF!"}},null,{"$f":"M33-M41-M37","v":{"$error":"#REF!"}},null,{"$f":"O33-O41-O37","v":{"$error":"#REF!"}}]
[]
["every step you take, every change you make on the 12WBT takes you in the right direction away from the person you were in that before photo :D"]

{"sheet":"Week 9","index":25,"n_rows":42,"n_cols":18,"rows_kept":42,"cut":false,"hidden":true,"merged":[[10,9,10,10],[10,11,10,12],[10,13,10,14],[9,13,9,14],[9,11,9,12],[9,9,9,10],[10,1,10,2],[9,1,9,2],[9,3,9,4],[9,5,9,6],[9,7,9,8],[10,3,10,4],[10,5,10,6],[10,7,10,8]]}
["Week 8","Calorie limit",1200,{"$f":"C1*7","v":8400}]
[]
[]
[]
[]
[]
[]
[]
[null,"ACCELERATOR DAY",null,"ACCELERATOR DAY"]
[null,"Monday 16 August",null,"Tuesday 17",null,"Wednesday 18",null,"Thursday 19",null,"Friday 20",null,"Saturday 21",null,"Sunday 22",null,null,"Notes"]
[null,"Notes: 8-2 PBL. \nBuy salad sandwich, pack snacks",null,"Notes:",null,"Notes: ",null,"Notes:  10 - 3 PBL. \nBuy salad sandwich, pack snacks\n",null,null,null,"Notes: \n",null,"Notes: \n"]
["breakfast","strawberries (6 large)",45,"strawberries (6 large)",45,"special k",166,"special k",166,"special k",166,"eggs & toast",300,"baked beans & toast",300]
[null,"orange",90,"orange",90,"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"for me yoghurt",80,"for me yoghurt",80,"meds, celery",0,"meds, celery",0,"meds, celery",0,"meds, celery",0,"meds, celery",0]
[null,"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,"banana",110]
[null,"meds, celery",0,"meds, celery",0]
[null,"sub-total",{"$f":"SUM(C12:C16)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(E12:E15)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(G12:G15)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(I12:I15)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(K12:K16)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M12:M15)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O12:O15)","v":{"$error":"#REF!"}}]
["lunch","metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"soup",250,"soup",250,"soup",250,"wrap tuna salad",300,"wrap tuna salad",300,"soup",250,"soup",250]
[]
[]
[null,"sub-total",{"$f":"SUM(C18:C21)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(E18:E21)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(G18:G21)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(I18:I21)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(K18:K21)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M18:M21)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O18:O21)","v":{"$error":"#REF!"}}]
["dinner","metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"soup",250,"soup",250,"sushi",350,"soup",250,"soup",250,"soup",250,"soup",250]
[]
[null,"sub-total",{"$f":"SUM(C23:C25)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(E23:E25)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(G23:G25)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(I23:I25)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(K23:K25)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M23:M25)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O23:O25)","v":{"$error":"#REF!"}}]
["snacks","for me yoghurt",80,"for me yoghurt",80]
[null,"fruit",80,"fruit",80]
[null,"sub-total",{"$f":"SUM(C27:C28)","v":160},"sub-total",{"$f":"SUM(E27:E28)","v":160},"sub-total",{"$f":"SUM(G27:G28)","v":0},"sub-total",{"$f":"SUM(I27:I28)","v":0},"sub-total",{"$f":"SUM(K27:K28)","v":0},"sub-total",{"$f":"SUM(M27:M28)","v":0},"sub-total",{"$f":"SUM(O27:O28)","v":0}]
["Total",null,{"$f":"SUM(C17+C22+C26+C29)","v":{"$error":"#REF!"}},null,{"$f":"SUM(E17+E22+E26+E29)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G17+G22+G26+G29)","v":{"$error":"#REF!"}},null,{"$f":"SUM(I17+I22+I26+I29)","v":{"$error":"#REF!"}},null,{"$f":"SUM(K17+K22+K26+K29)","v":{"$error":"#REF!"}},null,{"$f":"SUM(M17+M22+M26+M29)","v":{"$error":"#REF!"}},null,{"$f":"SUM(O17+O22+O26+O29)","v":{"$error":"#REF!"}},null,"weekly total",{"$f":"SUM(C30:O30)","v":{"$error":"#REF!"}}]
[]
["remaining calories",null,{"$f":"C30-$C$1","v":{"$error":"#REF!"}},null,{"$f":"E30-$C$1","v":{"$error":"#REF!"}}," ",{"$f":"G30-$C$1","v":{"$error":"#REF!"}},null,{"$f":"I30-$C$1","v":{"$error":"#REF!"}},null,{"$f":"K30-$C$1","v":{"$error":"#REF!"}},null,{"$f":"M30-$C$1","v":{"$error":"#REF!"}},null,{"$f":"O30-$C$1","v":{"$error":"#REF!"}},null,"left over",{"$f":"R30-D1","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null," "]
["Exercise",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"avg cal / day",{"$f":"R30/7","v":{"$error":"#REF!"}}]
[]
[null,"Energy balance",{"$f":"C30-C34","v":{"$error":"#REF!"}},null,{"$f":"E30-E34","v":{"$error":"#REF!"}},null,{"$f":"G30-G34","v":{"$error":"#REF!"}},null,{"$f":"I30-I34","v":{"$error":"#REF!"}},null,{"$f":"K30-K34","v":{"$error":"#REF!"}},null,{"$f":"M30-M34","v":{"$error":"#REF!"}},null,{"$f":"O30-O34","v":{"$error":"#REF!"}}]
[]
[null,"basal metabolic rate",1728,null,1728,null,1728,null,1728,null,1728,null,1728,null,1728]
[]
[null,"balance for day",{"$f":"C30-C38-C34","v":{"$error":"#REF!"}},null,{"$f":"E30-E38-E34","v":{"$error":"#REF!"}},null,{"$f":"G30-G38-G34","v":{"$error":"#REF!"}},null,{"$f":"I30-I38-I34","v":{"$error":"#REF!"}},null,{"$f":"K30-K38-K34","v":{"$error":"#REF!"}},null,{"$f":"M30-M38-M34","v":{"$error":"#REF!"}},null,{"$f":"O30-O38-O34","v":{"$error":"#REF!"}}]
[]
["every step you take, every change you make on the 12WBT takes you in the right direction away from the person you were in that before photo :D"]

{"sheet":"Week 10","index":26,"n_rows":41,"n_cols":27,"rows_kept":41,"cut":false,"hidden":true,"merged":[[10,9,10,10],[10,11,10,12],[10,13,10,14],[9,13,9,14],[9,11,9,12],[9,9,9,10],[10,1,10,2],[9,1,9,2],[9,3,9,4],[9,5,9,6],[9,7,9,8],[10,3,10,4],[10,5,10,6],[10,7,10,8]]}
["Week 10","Calorie limit",1200,{"$f":"C1*7","v":8400}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93.5,null,"Loss","LTD","TO GO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wed","2010-08-25",93.5,{"$f":"S3/2.96","v":31.587837837837839},null,"wed pm",93.4,"J"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thu","2010-08-26",{"$f":"S3-0.75","v":92.75},{"$f":"S4/2.96","v":31.33445945945946},null,"thur am"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fri","2010-08-27",{"$f":"S4-0.75","v":92},31.081081081081081,null,"thur pm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sat","2010-08-28",91.25,30.827702702702702,null,"fri am",92.7,"J",{"$f":"W2-W6","v":0.79999999999999716},{"$f":"105-W6","v":12.299999999999997},{"$f":"20-Z6","v":7.7000000000000028}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sun","2010-08-29",90.5,30.574324324324326,null,"fri pm",null,91.5,{"$f":"W6-X7","v":1.2000000000000028},{"$f":"105-X7","v":13.5},{"$f":"20-Z7","v":6.5}]
[null,95.5,null,94.3,93.8,93.5,null,null,null,null,null,null,null,null,null,null,"Mon","2010-08-30",89.75,30.320945945945947,"Sub 90 kg","sat am",null,91,{"$f":"X7-X8","v":0.5},14,6]
[null,"ACCELERATOR DAY",null,"ACCELERATOR DAY",null,93.4,null,"ACCELERATOR DAY",null,null,null,"ACCELERATOR DAY",null,null,null,null,"Tue","2010-08-31",89,30.067567567567568,null,"sat pm",null,90.8,{"$f":"X8-X9","v":0.20000000000000284},14.200000000000003,5.7999999999999972]
[null,"Monday 23 August",null,"Tuesday 24",null,"Wednesday 25",null,"Thursday 26",null,"Friday 27",null,"Saturday 28",null,"Sunday 29",null,null,"Wed","2010-09-01",88.25,29.814189189189189,"Next 12WBT weigh in\nUnder 30 BMI & 90kgs","sun am",null,90.2,0.59999999999999432,14.799999999999997,5.2000000000000028]
[null,"Notes: 8-2 PBL. \nBuy salad sandwich, pack snacks",null,"Notes:",null,"Notes: ",null,"Notes:  10 - 3 PBL. \nBuy salad sandwich, pack snacks\n",null,null,null,"Notes: \n",null,"Notes: \n",null,null,"Thu","2010-09-02",{"$f":"S10-0.75","v":87.5},29.560810810810811,null,"sun pm",null,90,0.20000000000000284,15,5]
["breakfast","metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"omlette",260,null,null,"omelette",260,"porridge",140,"omelette",140,"porridge",140,null,"Fri","2010-09-03",86.75,29.307432432432432,null,"mon am",null,89.8,0.20000000000000284,15.200000000000003,4.7999999999999972]
[null,"meds, celery",0,"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"1/4 cup physical",26,"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"1/4 cup physical",26,null,"Sat","2010-09-04",86,29.054054054054056,null,"mon pm",null,89.5,0.29999999999999716,15.5,4.5]
[null,null,null,"meds, celery",0,"meds, celery",0,"meds, celery",0,"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"meds, celery",0,"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},null,"Sun","2010-09-05",85.25,28.800675675675677,null,"tues am",null,89,0.5,16,4]
[null,null,null,null,null,null,null,null,null,"meds, celery",0,null,null,"meds, celery",0,null,"Mon","2010-09-06",84.5,28.547297297297298,"GOAL 20kg loss","tues pm",null,88.8,0.20000000000000284,16.200000000000003,3.7999999999999972]
[null,"sub-total",{"$f":"SUM(C12:C13)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(E12:E13)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(G12:G14)","v":0},"sub-total",{"$f":"SUM(I12:I14)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(K12:K15)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M12:M14)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O12:O15)","v":{"$error":"#REF!"}},null,"Tue","2010-09-07",83.75,28.293918918918919,null,"wed am",null,88.3,0.5,16.700000000000003,3.2999999999999972]
["lunch","metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},null,"Wed","2010-09-08",83,28.04054054054054,"Last weigh in","wed pm",null,88,0.29999999999999716,17,3]
[null,"casserol",280,"soup",120,"omlette",260,"soup",250,"soup",250,"soup",250,"soup",250,null,"Thu","2010-09-09",82,27.702702702702702]
[null,"grilled zucchini",80,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fri","2010-09-10",81,27.364864864864867]
[null,"celery",0,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sat","2010-09-11",80,27.027027027027028,"Party"]
[null,"sub-total",{"$f":"SUM(C17:C20)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(E17:E20)","v":120},"sub-total",{"$f":"SUM(G17:G20)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(I17:I20)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(K17:K20)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M17:M20)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O17:O20)","v":{"$error":"#REF!"}}]
["dinner","metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"biscuit, tuna & tom",200,"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"grilled zucchini & p.kin",80,null,null,"sushi",350,"soup",250,"soup",250,"soup",250,"soup",250]
[]
[null,"sub-total",{"$f":"SUM(C22:C24)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(E22:E24)","v":200},"sub-total",{"$f":"SUM(G22:G24)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(I22:I24)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(K22:K24)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M22:M24)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O22:O24)","v":{"$error":"#REF!"}}]
["snacks"]
[]
[null,"sub-total",{"$f":"SUM(C26:C27)","v":0},"sub-total",{"$f":"SUM(E26:E27)","v":0},"sub-total",{"$f":"SUM(G26:G27)","v":0},"sub-total",{"$f":"SUM(I26:I27)","v":0},"sub-total",{"$f":"SUM(K26:K27)","v":0},"sub-total",{"$f":"SUM(M26:M27)","v":0},"sub-total",{"$f":"SUM(O26:O27)","v":0}]
["Total",null,{"$f":"SUM(C16+C21+C25+C28)","v":{"$error":"#REF!"}},null,{"$f":"SUM(E16+E21+E25+E28)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G16+G21+G25+G28)","v":{"$error":"#REF!"}},null,{"$f":"SUM(I16+I21+I25+I28)","v":{"$error":"#REF!"}},null,{"$f":"SUM(K16+K21+K25+K28)","v":{"$error":"#REF!"}},null,{"$f":"SUM(M16+M21+M25+M28)","v":{"$error":"#REF!"}},null,{"$f":"SUM(O16+O21+O25+O28)","v":{"$error":"#REF!"}},null,"weekly total",{"$f":"SUM(C29:O29)","v":{"$error":"#REF!"}}]
[]
["remaining calories",null,{"$f":"C29-$C$1","v":{"$error":"#REF!"}},null,{"$f":"E29-$C$1","v":{"$error":"#REF!"}}," ",{"$f":"G29-$C$1","v":{"$error":"#REF!"}},null,{"$f":"I29-$C$1","v":{"$error":"#REF!"}},null,{"$f":"K29-$C$1","v":{"$error":"#REF!"}},null,{"$f":"M29-$C$1","v":{"$error":"#REF!"}},null,{"$f":"O29-$C$1","v":{"$error":"#REF!"}},null,"left over",{"$f":"R29-D1","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null," "]
["Exercise",null,null,"30 min bike",null,"1hr 10 bike",300,null,null,null,null,null,null,null,null,null,"avg cal / day",{"$f":"R29/7","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"30 min bike",120]
[null,"Energy balance",{"$f":"C29-C33","v":{"$error":"#REF!"}},null,{"$f":"E29-E33","v":{"$error":"#REF!"}},null,{"$f":"G29-G33","v":{"$error":"#REF!"}},null,{"$f":"I29-I33","v":{"$error":"#REF!"}},null,{"$f":"K29-K33","v":{"$error":"#REF!"}},null,{"$f":"M29-M33","v":{"$error":"#REF!"}},null,{"$f":"O29-O33","v":{"$error":"#REF!"}}]
[]
[null,"basal metabolic rate",1728,null,1728,null,1728,null,1728,null,1728,null,1728,null,1728]
[]
[null,"balance for day",{"$f":"C29-C37-C33","v":{"$error":"#REF!"}},null,{"$f":"E29-E37-E33","v":{"$error":"#REF!"}},null,{"$f":"G29-G37-G33","v":{"$error":"#REF!"}},null,{"$f":"I29-I37-I33","v":{"$error":"#REF!"}},null,{"$f":"K29-K37-K33","v":{"$error":"#REF!"}},null,{"$f":"M29-M37-M33","v":{"$error":"#REF!"}},null,{"$f":"O29-O37-O33","v":{"$error":"#REF!"}}]
[]
["every step you take, every change you make on the 12WBT takes you in the right direction away from the person you were in that before photo :D"]

{"sheet":"Week 11","index":27,"n_rows":42,"n_cols":23,"rows_kept":42,"cut":false,"hidden":true,"merged":[[10,9,10,10],[10,11,10,12],[10,13,10,14],[9,13,9,14],[9,11,9,12],[9,9,9,10],[10,1,10,2],[9,1,9,2],[9,3,9,4],[9,5,9,6],[9,7,9,8],[10,3,10,4],[10,5,10,6],[10,7,10,8]]}
["Week 8","Calorie limit",1200,{"$f":"C1*7","v":8400}]
[]
[]
[]
[]
[]
[]
[]
[null,"ACCELERATOR DAY",null,"ACCELERATOR DAY"]
[null,"Monday 30 August",null,"Tuesday 31",null,"Wednesday 1",null,"Thursday 2",null,"Friday 3",null,"Saturday 4",null,"Sunday 5",null,null,"Notes"]
[null,"Notes: 8-2 PBL. \nBuy salad sandwich, pack snacks",null,"Notes:",null,"Notes: ",null,null,null,null,null,"Notes: \n",null,"Notes: \n"]
["breakfast","salmon",327,"salmon",327,null,null,"omlette",260,"salmon",327,"salmon",327,"special k",166]
[null,"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"meds, celery",0,"meds, celery",0,"meds, celery",0,"meds, celery",0,"meds, celery",0,"meds, celery",0,"meds, celery",0]
[null,null,null,"chicken breast",165]
[]
[null,"sub-total",{"$f":"SUM(C12:C16)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(E12:E15)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(G12:G15)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(I12:I15)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(K12:K16)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M12:M15)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O12:O15)","v":{"$error":"#REF!"}}]
["lunch","cauli soup",125,"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"celery tab",null,"chicken breast",165,null,null,"soup",125,"soup",125,"soup",125,"soup",125]
[null,"carmans",190,"vegies",80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ideal"]
[null,"sub-total",{"$f":"SUM(C18:C21)","v":315},"sub-total",{"$f":"SUM(E18:E21)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(G18:G21)","v":0},"sub-total",{"$f":"SUM(I18:I21)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(K18:K21)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M18:M21)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O18:O21)","v":{"$error":"#REF!"}},null,null,null,null,null,"cals in",{"$f":"7*1200","v":8400}]
["dinner","metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,"exer out",{"$f":"7*500","v":3500}]
[null,"tomato soup",125,null,null,"sushi",400,"soup",125,"soup",125,"soup",125,"treat dinner",400,null,null,null,null,null,"bmr",{"$f":"1698*7","v":11886}]
[null,"beef",244,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V22-V23-V24","v":-6986}]
[null,"sub-total",{"$f":"SUM(C23:C25)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(E23:E25)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(G23:G25)","v":400},"sub-total",{"$f":"SUM(I23:I25)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(K23:K25)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M23:M25)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O23:O25)","v":{"$error":"#REF!"}}]
["snacks","carmans",150]
[null,"carmans",150]
[null,"sub-total",{"$f":"SUM(C27:C28)","v":300},"sub-total",{"$f":"SUM(E27:E28)","v":0},"sub-total",{"$f":"SUM(G27:G28)","v":0},"sub-total",{"$f":"SUM(I27:I28)","v":0},"sub-total",{"$f":"SUM(K27:K28)","v":0},"sub-total",{"$f":"SUM(M27:M28)","v":0},"sub-total",{"$f":"SUM(O27:O28)","v":0}]
["Total",null,{"$f":"SUM(C17+C22+C26+C29)","v":{"$error":"#REF!"}},null,{"$f":"SUM(E17+E22+E26+E29)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G17+G22+G26+G29)","v":{"$error":"#REF!"}},null,{"$f":"SUM(I17+I22+I26+I29)","v":{"$error":"#REF!"}},null,{"$f":"SUM(K17+K22+K26+K29)","v":{"$error":"#REF!"}},null,{"$f":"SUM(M17+M22+M26+M29)","v":{"$error":"#REF!"}},null,{"$f":"SUM(O17+O22+O26+O29)","v":{"$error":"#REF!"}},null,"weekly total",{"$f":"SUM(C30:O30)","v":{"$error":"#REF!"}},null,null,null,"food cal",{"$f":"R30","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"exer out",{"$f":"SUM(C34,E34,G34,I34,K34,M34,O34)","v":2500}]
["remaining calories",null,{"$f":"C30-$C$1","v":{"$error":"#REF!"}},null,{"$f":"E30-$C$1","v":{"$error":"#REF!"}}," ",{"$f":"G30-$C$1","v":{"$error":"#REF!"}},null,{"$f":"I30-$C$1","v":{"$error":"#REF!"}},null,{"$f":"K30-$C$1","v":{"$error":"#REF!"}},null,{"$f":"M30-$C$1","v":{"$error":"#REF!"}},null,{"$f":"O30-$C$1","v":{"$error":"#REF!"}},null,"left over",{"$f":"R30-D1","v":{"$error":"#REF!"}},null,null,null,"bmr",{"$f":"SUM(C38,E38,G38,I38,K38,M38,O38)","v":11886}]
[null,null,null,null,null,null,null," "]
["Exercise",null,0,null,0,null,500,null,500,null,500,null,500,null,500,null,"avg cal / day",{"$f":"R30/7","v":{"$error":"#REF!"}},null,null,null,"total",{"$f":"W30-W31-W32","v":{"$error":"#REF!"}}]
[]
[null,"Energy balance",{"$f":"C30-C34","v":{"$error":"#REF!"}},null,{"$f":"E30-E34","v":{"$error":"#REF!"}},null,{"$f":"G30-G34","v":{"$error":"#REF!"}},null,{"$f":"I30-I34","v":{"$error":"#REF!"}},null,{"$f":"K30-K34","v":{"$error":"#REF!"}},null,{"$f":"M30-M34","v":{"$error":"#REF!"}},null,{"$f":"O30-O34","v":{"$error":"#REF!"}}]
[]
[null,"basal metabolic rate",1698,null,1698,null,1698,null,1698,null,1698,null,1698,null,1698,null,null,{"$f":"SUM(C38,E38,G38,I38,K38,M38,O38)","v":11886}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"deficit",{"$f":"R30-R38","v":{"$error":"#REF!"}},{"$f":"V22-R38","v":-3486}]
[null,"balance for day",{"$f":"C30-C38-C34","v":{"$error":"#REF!"}},null,{"$f":"E30-E38-E34","v":{"$error":"#REF!"}},null,{"$f":"G30-G38-G34","v":{"$error":"#REF!"}},null,{"$f":"I30-I38-I34","v":{"$error":"#REF!"}},null,{"$f":"K30-K38-K34","v":{"$error":"#REF!"}},null,{"$f":"M30-M38-M34","v":{"$error":"#REF!"}},null,{"$f":"O30-O38-O34","v":{"$error":"#REF!"}}]
[]
["every step you take, every change you make on the 12WBT takes you in the right direction away from the person you were in that before photo :D"]

{"sheet":"Week 12","index":28,"n_rows":42,"n_cols":18,"rows_kept":42,"cut":false,"hidden":true,"merged":[[10,9,10,10],[10,11,10,12],[10,13,10,14],[9,13,9,14],[9,11,9,12],[9,9,9,10],[10,1,10,2],[9,1,9,2],[9,3,9,4],[9,5,9,6],[9,7,9,8],[10,3,10,4],[10,5,10,6],[10,7,10,8]]}
["Week 8","Calorie limit",1200,{"$f":"C1*7","v":8400}]
[]
[]
[]
[]
[]
[]
[]
[null,"ACCELERATOR DAY",null,"ACCELERATOR DAY",null,null,null,"ACCELERATOR DAY",null,null,null,"ACCELERATOR DAY"]
[null,"Monday 6 August",null,"Tuesday 7",null,"Wednesday 8",null,"Thursday 9",null,"Friday 10",null,"Saturday 11",null,"Sunday 12",null,null,"Notes"]
[null,"Notes: 8-2 PBL. \nBuy salad sandwich, pack snacks",null,"Notes:",null,"Notes: ",null,"Notes:  10 - 3 PBL. \nBuy salad sandwich, pack snacks\n",null,null,null,"Notes: \n",null,"Notes: \n"]
["breakfast",null,null,null,null,"special k",166,"omelette",327,"special k",166,"omelette",327,"baked beans & toast",300]
[null,"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"meds, celery",0,"meds, celery",0,"meds, celery",0,"meds, celery",0,"meds, celery",0,"meds, celery",0,"meds, celery",0]
[]
[]
[null,"sub-total",{"$f":"SUM(C12:C16)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(E12:E15)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(G12:G15)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(I12:I15)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(K12:K16)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M12:M15)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O12:O15)","v":{"$error":"#REF!"}}]
["lunch","metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"soup",250,"tuna, tomato, beet",200,"soup",250,"soup",250,"wrap tuna salad",300,"soup",250,"soup",250]
[null,"dates",50]
[]
[null,"sub-total",{"$f":"SUM(C18:C21)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(E18:E21)","v":200},"sub-total",{"$f":"SUM(G18:G21)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(I18:I21)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(K18:K21)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M18:M21)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O18:O21)","v":{"$error":"#REF!"}}]
["dinner","tuna, tomato, beetroot",150,"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}},"metamucil (3tsp)",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"soup",250,null,null,"sushi",350,"soup",250,"soup",250,"soup",250,"soup",250]
[]
[null,"sub-total",{"$f":"SUM(C23:C25)","v":400},"sub-total",{"$f":"SUM(E23:E25)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(G23:G25)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(I23:I25)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(K23:K25)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M23:M25)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O23:O25)","v":{"$error":"#REF!"}}]
["snacks"]
[]
[null,"sub-total",{"$f":"SUM(C27:C28)","v":0},"sub-total",{"$f":"SUM(E27:E28)","v":0},"sub-total",{"$f":"SUM(G27:G28)","v":0},"sub-total",{"$f":"SUM(I27:I28)","v":0},"sub-total",{"$f":"SUM(K27:K28)","v":0},"sub-total",{"$f":"SUM(M27:M28)","v":0},"sub-total",{"$f":"SUM(O27:O28)","v":0}]
["Total",null,{"$f":"SUM(C17+C22+C26+C29)","v":{"$error":"#REF!"}},null,{"$f":"SUM(E17+E22+E26+E29)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G17+G22+G26+G29)","v":{"$error":"#REF!"}},null,{"$f":"SUM(I17+I22+I26+I29)","v":{"$error":"#REF!"}},null,{"$f":"SUM(K17+K22+K26+K29)","v":{"$error":"#REF!"}},null,{"$f":"SUM(M17+M22+M26+M29)","v":{"$error":"#REF!"}},null,{"$f":"SUM(O17+O22+O26+O29)","v":{"$error":"#REF!"}},null,"weekly total",{"$f":"SUM(C30:O30)","v":{"$error":"#REF!"}}]
[]
["remaining calories",null,{"$f":"C30-$C$1","v":{"$error":"#REF!"}},null,{"$f":"E30-$C$1","v":{"$error":"#REF!"}}," ",{"$f":"G30-$C$1","v":{"$error":"#REF!"}},null,{"$f":"I30-$C$1","v":{"$error":"#REF!"}},null,{"$f":"K30-$C$1","v":{"$error":"#REF!"}},null,{"$f":"M30-$C$1","v":{"$error":"#REF!"}},null,{"$f":"O30-$C$1","v":{"$error":"#REF!"}},null,"left over",{"$f":"R30-D1","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null," "]
["Exercise",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"avg cal / day",{"$f":"R30/7","v":{"$error":"#REF!"}}]
[]
[null,"Energy balance",{"$f":"C30-C34","v":{"$error":"#REF!"}},null,{"$f":"E30-E34","v":{"$error":"#REF!"}},null,{"$f":"G30-G34","v":{"$error":"#REF!"}},null,{"$f":"I30-I34","v":{"$error":"#REF!"}},null,{"$f":"K30-K34","v":{"$error":"#REF!"}},null,{"$f":"M30-M34","v":{"$error":"#REF!"}},null,{"$f":"O30-O34","v":{"$error":"#REF!"}}]
[]
[null,"basal metabolic rate",1728,null,1728,null,1728,null,1728,null,1728,null,1728,null,1728]
[]
[null,"balance for day",{"$f":"C30-C38-C34","v":{"$error":"#REF!"}},null,{"$f":"E30-E38-E34","v":{"$error":"#REF!"}},null,{"$f":"G30-G38-G34","v":{"$error":"#REF!"}},null,{"$f":"I30-I38-I34","v":{"$error":"#REF!"}},null,{"$f":"K30-K38-K34","v":{"$error":"#REF!"}},null,{"$f":"M30-M38-M34","v":{"$error":"#REF!"}},null,{"$f":"O30-O38-O34","v":{"$error":"#REF!"}}]
[]
["every step you take, every change you make on the 12WBT takes you in the right direction away from the person you were in that before photo :D"]

{"sheet":"David - Week 1","index":29,"n_rows":29,"n_cols":18,"rows_kept":29,"cut":false,"hidden":true,"merged":[[3,9,3,10],[3,11,3,12],[3,13,3,14],[2,13,2,14],[2,11,2,12],[2,9,2,10],[3,1,3,2],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8],[3,3,3,4],[3,5,3,6],[3,7,3,8]]}
["Week 1","Calorie limit",1800,{"$f":"C1*7","v":12600}]
[]
[null,"Monday",null,"Tuesday",null,"Wednesday",null,"Thursday",null,"Friday",null,"Saturday",null,"Sunday",null,null,"Notes"]
[null,"Notes: \n",null,"Notes: \n",null,"Notes: \n",null,"Notes: \n",null,"Notes: \n",null,"Notes: \n",null,"Notes: \n"]
["breakfast",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[null,"sub-total",{"$f":"SUM(C5:C9)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(E5:E9)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(G5:G9)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(I5:I9)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(K5:K9)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M5:M9)","v":0},"sub-total",{"$f":"SUM(O5:O9)","v":0}]
["lunch",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[null,"sub-total",{"$f":"SUM(C11:C14)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(E11:E14)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(G11:G14)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(I11:I14)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(K11:K14)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M11:M14)","v":0},"sub-total",{"$f":"SUM(O11:O14)","v":0}]
["dinner"]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"cauliflower soup",300,"cauliflower soup",300,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"sub-total",{"$f":"SUM(C16:C18)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(E16:E18)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(G16:G18)","v":300},"sub-total",{"$f":"SUM(I16:I18)","v":300},"sub-total",{"$f":"SUM(K16:K18)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M16:M18)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(O16:O18)","v":{"$error":"#REF!"}}]
["snacks",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[null,"sub-total",{"$f":"SUM(C20:C21)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(E20:E23)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(G20:G23)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(I20:I23)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(K20:K23)","v":{"$error":"#REF!"}},"sub-total",{"$f":"SUM(M20:M23)","v":0},"sub-total",{"$f":"SUM(O20:O23)","v":0}]
["Total",null,{"$f":"SUM(C10+C15+C19+C24)","v":{"$error":"#REF!"}},null,{"$f":"SUM(E10+E15+E19+E24)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G10+G15+G19+G24)","v":{"$error":"#REF!"}},null,{"$f":"SUM(I10+I15+I19+I24)","v":{"$error":"#REF!"}},null,{"$f":"SUM(K10+K15+K19+K24)","v":{"$error":"#REF!"}},null,{"$f":"SUM(M10+M15+M19+M24)","v":{"$error":"#REF!"}},null,{"$f":"SUM(O10+O15+O19+O24)","v":{"$error":"#REF!"}},null,"weekly total",{"$f":"SUM(C25:O25)","v":{"$error":"#REF!"}}]
[]
[null,null,{"$f":"C25-$C$1","v":{"$error":"#REF!"}},null,{"$f":"E25-$C$1","v":{"$error":"#REF!"}},null,{"$f":"G25-$C$1","v":{"$error":"#REF!"}},null,{"$f":"I25-$C$1","v":{"$error":"#REF!"}},null,{"$f":"K25-$C$1","v":{"$error":"#REF!"}},null,{"$f":"M25-$C$1","v":{"$error":"#REF!"}},null,{"$f":"O25-$C$1","v":{"$error":"#REF!"}},null,"left over",{"$f":"R25-D1","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"avg cal / day",{"$f":"R25/7","v":{"$error":"#REF!"}}]