{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Main","Full Screen Weight Graph","Predictions","Notes and Instructions","FAQ","About the Dynamic Model","Printable Graph","Regression Models","Video Tutorial"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Full Screen Weight Graph","index":1,"reason":"not_a_worksheet"},{"sheet":"Printable Graph","index":6,"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":"Main","index":0,"n_rows":162,"n_cols":11,"rows_kept":162,"cut":false,"hidden":false,"merged":[[0,1,1,1],[15,4,15,9]]}
[null,"User Inputs","Energy Units","Measurement Units","Gender","Age","Height","Weight","Duration","Intake Reduction (kcal/d)","3500 kcal/d \nWeight Graph?"]
[null,null,"kcal/d","lb & inches","Male",67,"67 inches","200 lb","500 days","600 kcal/d","Yes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"A161+1","v":1}]

{"sheet":"Predictions","index":2,"n_rows":502,"n_cols":14,"rows_kept":502,"cut":false,"hidden":false,"merged":[]}
["Day","Dynamic Model","3500 Rule Predictions","Below Healthy BMI","Energy Units","Measurement Units","Gender","Age","Height","Weight","Duration","Intake Reduction (kcal/d)","3500 kcal/d \nWeight Graph?","View Msg?"]
[0,200,200,null,"kcal/d","lb & inches","Male",67,"67 inches","200 lb","500 days","600 kcal/d","Yes","No"]
[1,199.86094196970373,199.82857142857145]
[2,199.72246926161102,199.65714285714287]
[3,199.58457998154196,199.48571428571429]
[4,199.44727223827752,199.31428571428572]
[5,199.31054414356765,199.14285714285717]
[6,199.17439381214115,198.97142857142859]
[7,199.03881936171453,198.8]
[8,198.90381891300058,198.62857142857143]
[9,198.76939058971797,198.45714285714286]
[10,198.63553251860012,198.28571428571431]
[11,198.50224282940397,198.11428571428573]
[12,198.36951965491929,197.94285714285715]
[13,198.23736113097792,197.77142857142857]
[14,198.10576539646198,197.60000000000002]
[15,197.9747305933135,197.42857142857144]
[16,197.84425486654337,197.25714285714287]
[17,197.7143363642399,197.08571428571429]
[18,197.58497323757854,196.91428571428571]
[19,197.45616364083003,196.74285714285716]
[20,197.32790573136961,196.57142857142858]
[21,197.20019766968602,196.4]
[22,197.07303761939042,196.22857142857143]
[23,196.94642374722534,196.05714285714288]
[24,196.82035422307331,195.8857142857143]
[25,196.69482721996567,195.71428571428572]
[26,196.56984091409186,195.54285714285714]
[27,196.44539348480762,195.37142857142859]
[28,196.32148311464468,195.20000000000002]
[29,196.19810798931809,195.02857142857144]
[30,196.07526629773668,194.85714285714286]
[31,195.95653933877875,194.68571428571428]
[32,195.83831370434851,194.51428571428573]
[33,195.72058769029513,194.34285714285716]
[34,195.60335959560638,194.17142857142858]
[35,195.48662772241423,194]
[36,195.37039037600411,193.82857142857145]
[37,195.2546458648211,193.65714285714287]
[38,195.13939250047827,193.48571428571429]
[39,195.02462859776398,193.31428571428572]
[40,194.91035247464956,193.14285714285717]
[41,194.79656245229575,192.97142857142859]
[42,194.68325685506107,192.8]
[43,194.57043401050885,192.62857142857143]
[44,194.45809224941476,192.45714285714286]
[45,194.34622990577313,192.28571428571431]
[46,194.23484531680521,192.11428571428573]
[47,194.12393682296599,191.94285714285715]
[48,194.013502767951,191.77142857142857]
[49,193.9035414987043,191.60000000000002]
[50,193.79405136542402,191.42857142857144]
[51,193.68503072157068,191.25714285714287]
[52,193.57647792387411,191.08571428571429]
[53,193.46839133233968,190.91428571428571]
[54,193.36076931025545,190.74285714285716]
[55,193.25361022419938,190.57142857142858]
[56,193.14691244404523,190.4]
[57,193.04067434297056,190.22857142857143]
[58,192.93489429746205,190.05714285714288]
[59,192.82957068732333,189.8857142857143]
[60,192.72470189568108,189.71428571428572]
[61,192.62028630899147,189.54285714285714]
[62,192.51632231704667,189.37142857142859]
[63,192.41280831298135,189.20000000000002]
[64,192.30974269327933,189.02857142857144]
[65,192.20712385777964,188.85714285714286]
[66,192.10495020968332,188.68571428571428]
[67,192.00322015555861,188.51428571428573]
[68,191.90193210534812,188.34285714285716]
[69,191.80108447237464,188.17142857142858]
[70,191.70067567334755,188]
[71,191.60070412836788,187.82857142857145]
[72,191.5011682609356,187.65714285714287]
[73,191.40206649795456,187.48571428571429]
[74,191.30339726973889,187.31428571428572]
[75,191.20515901001838,187.14285714285717]
[76,191.10735015594472,186.97142857142859]
[77,191.00996914809681,186.8]
[78,190.9130144304865,186.62857142857143]
[79,190.8164844505643,186.45714285714286]
[80,190.72037765922477,186.28571428571431]
[81,190.62469251081217,186.11428571428573]
[82,190.52942746312553,185.94285714285715]
[83,190.43458097742416,185.77142857142857]
[84,190.34015151843309,185.60000000000002]
[85,190.24613755434819,185.42857142857144]
[86,190.15253755684114,185.25714285714287]
[87,190.05935000106501,185.08571428571429]
[88,189.96657336565852,184.91428571428571]
[89,189.87420613275165,184.74285714285716]
[90,189.78224678797037,184.57142857142858]
[91,189.69069382044142,184.4]
[92,189.5995457227969,184.22857142857143]
[93,189.5088009911797,184.05714285714288]
[94,189.4184581252475,183.8857142857143]
[95,189.32851562817757,183.71428571428572]
[96,189.23897200667119,183.54285714285714]
[97,189.14982577095793,183.37142857142859]
[98,189.06107543480076,183.20000000000002]
[99,188.97271951549908,183.02857142857144]
[100,188.88475653389483,182.85714285714286]
[101,188.79718501437478,182.68571428571428]
[102,188.71000348487576,182.51428571428573]
[103,188.62321047688866,182.34285714285716]
[104,188.53680452546195,182.17142857142858]
[105,188.45078416920595,182]
[106,188.36514795029655,181.82857142857145]
[107,188.27989441447892,181.65714285714287]
[108,188.19502211107118,181.48571428571429]
[109,188.11052959296848,181.31428571428572]
[110,188.02641541664596,181.14285714285717]
[111,187.9426781421628,180.97142857142859]
[112,187.8593163331646,180.8]
[113,187.77632855688876,180.62857142857143]
[114,187.69371338416565,180.45714285714286]
[115,187.61146938942267,180.28571428571431]
[116,187.5295951506879,180.11428571428573]
[117,187.44808924959221,179.94285714285715]
[118,187.36695027137284,179.77142857142857]
[119,187.28617680487636,179.60000000000002]
[120,187.20576744256095,179.42857142857144]
[121,187.12572078050013,179.25714285714287]
[122,187.04603541838526,179.08571428571429]
[123,186.96670995952678,178.91428571428571]
[124,186.88774301085823,178.74285714285716]
[125,186.80913318293904,178.57142857142858]
[126,186.73087908995569,178.4]
[127,186.65297934972429,178.22857142857143]
[128,186.57543258369421,178.05714285714288]
[129,186.49823741694857,177.8857142857143]
[130,186.42139247820691,177.71428571428572]
[131,186.34489639982772,177.54285714285714]
[132,186.26874781781052,177.37142857142859]
[133,186.1929453717965,177.20000000000002]
[134,186.11748770507162,177.02857142857144]
[135,186.04237346456785,176.85714285714286]
[136,185.96760130086497,176.68571428571428]
[137,185.89316986819213,176.51428571428573]
[138,185.81907782442917,176.34285714285716]
[139,185.74532383110909,176.17142857142858]
[140,185.67190655341781,176]
[141,185.5988246601965,175.82857142857145]
[142,185.52607682394307,175.65714285714287]
[143,185.45366172081276,175.48571428571429]
[144,185.3815780306187,175.31428571428572]
[145,185.30982443683411,175.14285714285717]
[146,185.23839962659289,174.97142857142859]
[147,185.16730229069046,174.8]
[148,185.0965311235839,174.62857142857143]
[149,185.02608482339349,174.45714285714286]
[150,184.9559620919029,174.28571428571431]
[151,184.88616163456007,174.11428571428573]
[152,184.81668216047734,173.94285714285715]
[153,184.74752238243246,173.77142857142857]
[154,184.67868101686835,173.60000000000002]
[155,184.61015678389336,173.42857142857144]
[156,184.54194840728215,173.25714285714287]
[157,184.47405461447505,173.08571428571429]
[158,184.40647413657859,172.91428571428571]
[159,184.33920570836534,172.74285714285716]
[160,184.27224806827348,172.57142857142858]
[161,184.2055999584075,172.4]
[162,184.13926012453712,172.22857142857143]
[163,184.07322731609716,172.05714285714288]
[164,184.00750028618737,171.8857142857143]
[165,183.94207779157233,171.71428571428572]
[166,183.8769585926795,171.54285714285714]
[167,183.81214145360082,171.37142857142859]
[168,183.74762514208982,171.20000000000002]
[169,183.68340842956212,171.02857142857144]
[170,183.61949009109486,170.85714285714286]
[171,183.55586890542469,170.68571428571428]
[172,183.49254365494775,170.51428571428573]
[173,183.42951312571816,170.34285714285716]
[174,183.36677610744721,170.17142857142858]
[175,183.30433139350208,170]
[176,183.24217778090429,169.82857142857145]
[177,183.18031407032922,169.65714285714287]
[178,183.11873906610359,169.48571428571429]
[179,183.05745157620507,169.31428571428572]
[180,182.99645041225989,169.14285714285717]
[181,182.93573438954201,168.97142857142859]
[182,182.87530232697114,168.8]
[183,182.81515304711047,168.62857142857143]
[184,182.7552853761658,168.45714285714286]
[185,182.69569814398275,168.28571428571431]
[186,182.63639018404587,168.11428571428573]
[187,182.57736033347567,167.94285714285715]
[188,182.518607433027,167.77142857142857]
[189,182.46013032708728,167.60000000000002]
[190,182.40192786367314,167.42857142857144]
[191,182.34399889442935,167.25714285714287]
[192,182.28634227462618,167.08571428571429]
[193,182.22895686315627,166.91428571428571]
[194,182.17184152253307,166.74285714285716]
[195,182.11499511888775,166.57142857142858]
[196,182.05841652196705,166.4]
[197,182.00210460512969,166.22857142857143]
[198,181.9460582453452,166.05714285714288]
[199,181.8902763231892,165.8857142857143]
[200,181.83475772284257,165.71428571428572]
[201,181.77950133208643,165.54285714285714]
[202,181.72450604230133,165.37142857142859]
[203,181.66977074846258,165.20000000000002]
[204,181.61529434913695,165.02857142857144]
[205,181.56107574648124,164.85714285714286]
[206,181.5071138462371,164.68571428571428]
[207,181.45340755772912,164.51428571428573]
[208,181.39995579386073,164.34285714285716]
[209,181.34675747111126,164.17142857142858]
[210,181.29381150953151,164]
[211,181.24111683274151,163.82857142857145]
[212,181.18867236792585,163.65714285714287]
[213,181.13647704583065,163.48571428571429]
[214,181.08452980075938,163.31428571428572]
[215,181.03282957056962,163.14285714285717]
[216,180.98137529666869,162.97142857142859]
[217,180.93016592401,162.80000000000001]
[218,180.87920040108855,162.62857142857143]
[219,180.8284776799382,162.45714285714286]
[220,180.7779967161261,162.28571428571431]
[221,180.7277564687495,162.11428571428573]
[222,180.67775590043178,161.94285714285715]
[223,180.62799397731695,161.77142857142857]
[224,180.57846966906629,161.60000000000002]
[225,180.52918194885365,161.42857142857144]
[226,180.48012979336212,161.25714285714287]
[227,180.43131218277759,161.08571428571429]
[228,180.3827281007859,160.91428571428571]
[229,180.33437653456772,160.74285714285716]
[230,180.28625647479294,160.57142857142858]
[231,180.23836691561789,160.4]
[232,180.19070685467923,160.22857142857143]
[233,180.14327529308954,160.05714285714288]
[234,180.09607123543248,159.8857142857143]
[235,180.04909368975805,159.71428571428572]
[236,180.00234166757758,159.54285714285714]
[237,179.95581418385837,159.37142857142859]
[238,179.90951025701932,159.20000000000002]
[239,179.86342890892496,159.02857142857144]
[240,179.81756916488129,158.85714285714286]
[241,179.77193005363,158.68571428571428]
[242,179.72651060734299,158.51428571428573]
[243,179.68130986161788,158.34285714285716]
[244,179.63632685547256,158.17142857142858]
[245,179.59156063133892,158]
[246,179.54701023505814,157.82857142857145]
[247,179.50267471587537,157.65714285714287]
[248,179.45855312643326,157.48571428571429]
[249,179.41464452276784,157.31428571428572]
[250,179.37094796430168,157.14285714285717]
[251,179.32746251383884,156.97142857142859]
[252,179.28418723755919,156.80000000000001]
[253,179.24112120501215,156.62857142857143]
[254,179.19826348911155,156.45714285714286]
[255,179.15561316612963,156.28571428571431]
[256,179.11316931569067,156.11428571428573]
[257,179.0709310207657,155.94285714285715]
[258,179.02889736766627,155.77142857142857]
[259,178.98706744603871,155.60000000000002]
[260,178.94544034885752,155.42857142857144]
[261,178.9040151724198,155.25714285714287]
[262,178.86279101633934,155.08571428571429]
[263,178.82176698353973,154.91428571428571]
[264,178.78094218024893,154.74285714285716]
[265,178.7403157159921,154.57142857142858]
[266,178.6998867035866,154.4]
[267,178.65965425913453,154.22857142857143]
[268,178.61961750201706,154.05714285714288]
[269,178.57977555488773,153.8857142857143]
[270,178.54012754366622,153.71428571428572]
[271,178.50067259753217,153.54285714285714]
[272,178.46140984891747,153.37142857142859]
[273,178.42233843350149,153.20000000000002]
[274,178.38345749020309,153.02857142857144]
[275,178.34476616117507,152.85714285714286]
[276,178.30626359179669,152.68571428571428]
[277,178.2679489306675,152.51428571428573]
[278,178.22982132960036,152.34285714285716]
[279,178.19187994361494,152.17142857142858]
[280,178.15412393093123,152]
[281,178.11655245296242,151.82857142857145]
[282,178.07916467430755,151.65714285714287]
[283,178.04195976274585,151.48571428571429]
[284,178.00493688922873,151.31428571428572]
[285,177.96809522787362,151.14285714285717]
[286,177.93143395595649,150.97142857142859]
[287,177.89495225390544,150.80000000000001]
[288,177.85864930529377,150.62857142857143]
[289,177.82252429683155,150.45714285714286]
[290,177.78657641836082,150.28571428571431]
[291,177.75080486284679,150.11428571428573]
[292,177.71520882637097,149.94285714285715]
[293,177.6797875081246,149.77142857142857]
[294,177.64454011040144,149.60000000000002]
[295,177.60946583858981,149.42857142857144]
[296,177.57456390116656,149.25714285714287]
[297,177.5398335096888,149.08571428571429]
[298,177.5052738787868,148.91428571428571]
[299,177.47088422615809,148.74285714285716]
[300,177.43666377255784,148.57142857142858]
[301,177.4026117417927,148.4]
[302,177.36872736071462,148.22857142857143]
[303,177.33500985921086,148.05714285714288]
[304,177.3014584701989,147.8857142857143]
[305,177.26807242961794,147.71428571428572]
[306,177.23485097642197,147.54285714285714]
[307,177.20179335257114,147.37142857142859]
[308,177.16889880302659,147.20000000000002]
[309,177.13616657573996,147.02857142857144]
[310,177.10359592164841,146.85714285714286]
[311,177.07118609466565,146.68571428571428]
[312,177.0389363516752,146.51428571428573]
[313,177.00684595252199,146.34285714285716]
[314,176.9749141600054,146.17142857142858]
[315,176.94314023987167,146]
[316,176.91152346080543,145.82857142857145]
[317,176.88006309442326,145.65714285714287]
[318,176.84875841526537,145.48571428571429]
[319,176.81760870078747,145.31428571428572]
[320,176.78661323135432,145.14285714285717]
[321,176.75577129023054,144.97142857142859]
[322,176.7250821635742,144.80000000000001]
[323,176.69454514042803,144.62857142857143]
[324,176.66415951271267,144.45714285714286]
[325,176.63392457521775,144.28571428571431]
[326,176.60383962559507,144.11428571428573]
[327,176.57390396435036,143.94285714285715]
[328,176.54411689483558,143.77142857142857]
[329,176.5144777232413,143.60000000000002]
[330,176.48498575858824,143.42857142857144]
[331,176.45564031272025,143.25714285714287]
[332,176.42644070029522,143.08571428571429]
[333,176.39738623877895,142.91428571428571]
[334,176.3684762484356,142.74285714285716]
[335,176.33971005232118,142.57142857142858]
[336,176.31108697627482,142.4]
[337,176.28260634891069,142.22857142857143]
[338,176.25426750161034,142.05714285714288]
[339,176.22606976851537,141.8857142857143]
[340,176.19801248651891,141.71428571428572]
[341,176.17009499525761,141.54285714285714]
[342,176.14231663710345,141.37142857142859]
[343,176.1146767571567,141.20000000000002]
[344,176.08717470323711,141.02857142857144]
[345,176.05980982587673,140.85714285714286]
[346,176.0325814783105,140.68571428571428]
[347,176.00548901646997,140.51428571428573]
[348,175.97853179897405,140.34285714285716]
[349,175.95170918712148,140.17142857142858]
[350,175.92502054488335,140]
[351,175.89846523889395,139.82857142857145]
[352,175.87204263844387,139.65714285714287]
[353,175.84575211547082,139.48571428571429]
[354,175.81959304455302,139.31428571428572]
[355,175.79356480289945,139.14285714285717]
[356,175.7676667703436,138.97142857142859]
[357,175.74189832933433,138.80000000000001]
[358,175.71625886492805,138.62857142857143]
[359,175.69074776478084,138.45714285714286]
[360,175.66536441913971,138.28571428571431]
[361,175.64010822083634,138.11428571428573]
[362,175.61497856527666,137.94285714285715]
[363,175.58997485043457,137.77142857142857]
[364,175.56509647684328,137.60000000000002]
[365,175.54034284758683,137.42857142857144]
[366,175.51571336829269,137.25714285714287]
[367,175.49120744712383,137.08571428571429]
[368,175.46682449477009,136.91428571428571]
[369,175.44256392444012,136.74285714285716]
[370,175.41842515185388,136.57142857142858]
[371,175.39440759523393,136.4]
[372,175.37051067529802,136.22857142857143]
[373,175.34673381525087,136.05714285714288]
[374,175.32307644077571,135.8857142857143]
[375,175.29953798002634,135.71428571428572]
[376,175.27611786361979,135.54285714285714]
[377,175.25281552462721,135.37142857142859]
[378,175.22963039856688,135.20000000000002]
[379,175.20656192339521,135.02857142857144]
[380,175.18360953949917,134.85714285714286]
[381,175.16077268968849,134.68571428571428]
[382,175.13805081918733,134.51428571428573]
[383,175.11544337562603,134.34285714285716]
[384,175.09294980903397,134.17142857142858]
[385,175.07056957183022,134]
[386,175.04830211881668,133.82857142857145]
[387,175.02614690716976,133.65714285714287]
[388,175.00410339643162,133.48571428571429]
[389,174.98217104850363,133.31428571428572]
[390,174.96034932763689,133.14285714285717]
[391,174.93863770042529,132.97142857142859]
[392,174.91703563579719,132.80000000000001]
[393,174.89554260500691,132.62857142857143]
[394,174.87415808162814,132.45714285714286]
[395,174.85288154154424,132.28571428571431]
[396,174.83171246294148,132.11428571428573]
[397,174.81065032630104,131.94285714285715]
[398,174.78969461439036,131.77142857142857]
[399,174.76884481225557,131.60000000000002]
[400,174.74810040721425,131.42857142857144]
[401,174.7274608888462,131.25714285714287]
[402,174.70692574898641,131.08571428571429]
[403,174.68649448171701,130.91428571428571]
[404,174.66616658335937,130.74285714285716]
[405,174.64594155246593,130.57142857142858]
[406,174.62581888981308,130.4]
[407,174.60579809839217,130.22857142857143]
[408,174.5858786834024,130.05714285714288]
[409,174.56606015224304,129.8857142857143]
[410,174.54634201450529,129.71428571428572]
[411,174.52672378196414,129.54285714285714]
[412,174.50720496857159,129.37142857142859]
[413,174.48778509044777,129.20000000000002]
[414,174.46846366587337,129.02857142857144]
[415,174.44924021528229,128.85714285714286]
[416,174.43011426125344,128.68571428571428]
[417,174.41108532850311,128.51428571428573]
[418,174.39215294387765,128.34285714285716]
[419,174.37331663634495,128.17142857142858]
[420,174.35457593698678,128]
[421,174.33593037899169,127.82857142857144]
[422,174.31737949764656,127.65714285714287]
[423,174.29892283032962,127.48571428571429]
[424,174.28055991650248,127.31428571428573]
[425,174.26229029770224,127.14285714285715]
[426,174.24411351753378,126.97142857142858]
[427,174.22602912166224,126.80000000000001]
[428,174.20803665780556,126.62857142857143]
[429,174.19013567572699,126.45714285714287]
[430,174.17232572722656,126.28571428571429]
[431,174.15460636613469,126.11428571428573]
[432,174.13697714830366,125.94285714285715]
[433,174.11943763160059,125.77142857142859]
[434,174.10198737589923,125.60000000000001]
[435,174.08462594307323,125.42857142857144]
[436,174.06735289698818,125.25714285714287]
[437,174.05016780349399,125.0857142857143]
[438,174.03307023041774,124.91428571428573]
[439,174.01605974755554,124.74285714285715]
[440,173.99913592666545,124.57142857142858]
[441,173.98229834146025,124.4]
[442,173.96554656760031,124.22857142857144]
[443,173.94888018268418,124.05714285714286]
[444,173.93229876624369,123.8857142857143]
[445,173.91580189973496,123.71428571428572]
[446,173.89938916653168,123.54285714285716]
[447,173.88306015191722,123.37142857142858]
[448,173.86681444307757,123.20000000000002]
[449,173.85065162909405,123.02857142857144]
[450,173.83457130093615,122.85714285714286]
[451,173.81857305145331,122.6857142857143]
[452,173.80265647536859,122.51428571428572]
[453,173.78682116927115,122.34285714285716]
[454,173.77106673160901,122.17142857142858]
[455,173.75539276268071,122.00000000000001]
[456,173.73979886462993,121.82857142857144]
[457,173.72428464143661,121.65714285714287]
[458,173.70884969891102,121.48571428571429]
[459,173.69349364468579,121.31428571428573]
[460,173.67821608820887,121.14285714285715]
[461,173.6630166407362,120.97142857142858]
[462,173.64789491532517,120.80000000000001]
[463,173.63285052682673,120.62857142857143]
[464,173.61788309187898,120.45714285714287]
[465,173.60299222889918,120.28571428571429]
[466,173.58817755807786,120.11428571428573]
[467,173.57343870137078,119.94285714285715]
[468,173.55877528249212,null,119.77142857142859]
[469,173.54418692690797,null,119.60000000000001]
[470,173.52967326182835,null,119.42857142857144]
[471,173.51523391620066,null,119.25714285714287]
[472,173.50086852070342,null,119.0857142857143]
[473,173.48657670773804,null,118.91428571428573]
[474,173.47235811142292,null,118.74285714285715]
[475,173.45821236758601,null,118.57142857142858]
[476,173.44413911375773,null,118.4]
[477,173.43013798916465,null,118.22857142857144]
[478,173.41620863472187,null,118.05714285714286]
[479,173.40235069302696,null,117.8857142857143]
[480,173.38856380835301,null,117.71428571428572]
[481,173.37484762664062,null,117.54285714285716]
[482,173.36120179549309,null,117.37142857142858]
[483,173.34762596416732,null,117.20000000000002]
[484,173.33411978356941,null,117.02857142857144]
[485,173.3206829062463,null,116.85714285714286]
[486,173.30731498637925,null,116.6857142857143]
[487,173.29401567977769,null,116.51428571428572]
[488,173.2807846438721,null,116.34285714285716]
[489,173.2676215377075,null,116.17142857142858]
[490,173.25452602193687,null,116.00000000000001]
[491,173.24149775881381,null,115.82857142857144]
[492,173.22853641218691,null,115.65714285714287]
[493,173.2156416474925,null,115.48571428571429]
[494,173.2028131317484,null,115.31428571428573]
[495,173.19005053354721,null,115.14285714285715]
[496,173.17735352304939,null,114.97142857142858]
[497,173.1647217719775,null,114.80000000000001]
[498,173.15215495360894,null,114.62857142857143]
[499,173.13965274277027,null,114.45714285714287]
[500,173.12721481582955,null,114.28571428571429]

{"sheet":"Notes and Instructions","index":3,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,4,1,9]]}
["Introduction"]
["Instructions: To use the program, simply select the green button on the main sheet.  You will be prompted to enter age, height, gender, weight and changes in energy intake. You will be given choices of which units (metric, US Standard, kcal, MJ) you would like to apply. After making these selections, if you mistakenly enter data with incorrect units or incorrect ranges, the program will alert you to modify your inputs.  "]

{"sheet":"FAQ","index":4,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[8,2,8,7],[23,2,23,7],[24,2,24,7],[18,2,18,7],[17,2,17,7],[20,2,20,7],[21,2,21,7],[9,2,9,7],[11,2,11,7],[12,2,12,7],[15,2,15,7],[0,3,0,6],[2,2,2,7],[3,2,3,7],[5,2,5,7],[6,2,6,7]]}
[null,null,null,"FAQ"]
[]
["Q.",null,"Can I modify the excel file by typing or changing the way the graphs look?"]
["A.",null,"That is the beauty of housing the model in Microsoft Excel.  You may type in any of the cells so long as data is not being placed into the cells by the program.  You can change any graph characteristics by using the normal chart tools (right click the graphs to access chart tool display).  In case you enter data into a cell which corrupts the program, simply go and download a fresh copy from the original URL."]
[]
["Q.",null,"Does the model include the slowing of resting metabolic rate during weight loss?"]
["A.",null,"Yes it does.  It even includes the effects of metabolic adaptation during caloric restriction."]
[]
["Q.",null,"What kind of statistical method does this model rely on?"]
["A.",null,"The model was not developed using statistical methods.  Rather, model development relies on formulas from physics. In  this case, the model is constructed using the first law of thermodynamics.  Instead of statistically based regression formulas, the model uses differential equations."]
[]
["Q.",null,"What is the difference between statistical models and differential equations?"]
["A.",null,"Statistical models rely on fitting pre-designated formulas to data.  For example, if we want to predict what force would be required to hit a home run, we would need to gather data and all variables that we think may influence hitting a ball out of the park (wind speed, type of stadium, distance from sea level, height of individual hitting the ball, etc.)  Using these variables and the data, we would use regression to   predict the force.  Another approach would be to use Newton's second law of motion Force = mass X acceleration.  Knowledge of the ball's mass and a representation of acceleration using calculus allows one to solve for force.  "]
[]
["Q.",null,"Are differential equation models better than statistical models?"]
["A.",null,"Mathematical modeling is driven by the type of question and the resources that are available.  Statistical models are very important for establishing relationships between variables.  They can also be used to predict changes over time, but it is not the strength of statistical models.  Differential equation models generate time dependent trajectories, which is well suited for modeling changes in body weight over time.  Differential equations can also be used to identify relationships between variables, but this process is unnatural and not the best strategy.  Thus, appropriate modeling strategies should be applied for the specific problem at hand."]
[]
["Q.",null,"Does the model predict weight loss in response to aerobic exercise?"]
["A.",null,"The body's response to exercise is dependent on exercise dose.  The model applies for changes in response to a low dose of exercise (~50 kcal/d).  Behavioral compensations of increased intake and reduced resting metabolic rate have been observed in higher doses of exercise and are not yet well understood enough for rigorous model development. Although a model could be developed, the lack of sufficient knowledge on the response of the components of energy balance and body composition to higher doses of exercise will make such predictions questionable."]
[]
["Q.",null,"What about resistance training?"]
["A.",null,"Even less is known about body weight and energy balance responses to resistance training.  While these answers may not seem satisfactory, it is important to base models on well-established conclusions before it is applied to guide patient expectations."]
[]
["Q.",null,"I thought the 3500 kcal rule says that one should lose a lb. a week.  Why does the graph not show a lb. of weight loss per week?"]
["A.",null,"The 3500 kcal rule states that a 3500 kcal deficit will yield a lb. of weight loss.  If you restrict by 500 kcal/d the blue line will display a lb. of weight loss per week.  If you restrict by a different amount, for example, 250 kcal/d, then the 3500 kcal rule projects a lb. of weight loss in 2 weeks.  The program automatically rescales to display this change."]

{"sheet":"About the Dynamic Model","index":5,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,0,1,5],[3,0,3,5],[4,0,4,5]]}
["About the dynamic model used in this program."]
["This program simulates a variation of the model presented in (1). The model is dynamic, which means that the model generates a weight trajectory over time.  The model is based on the first law of thermodynamics which in humans is referred to as the energy balance equation: ES = EI - EE where ES represents the changed body energy stores, EI  represents the rate of energy intake, and EE represents the rate of energy expenditures in kcal/d.  The model includes all known whole body metabolic and physiological time and weight dependent changes during weight loss or weight gain and was validated against weight change data where energy intake was objectively measured."]
[]
["Specific details of model development appear in (1) which we summarize.\n\n1. The rate of energy stored/lost,ES, is modeled by the sum of the change in energy stores from fat free mass and the change in energy stores arising from fat mass.  Specifically, ES= 1020 dFFM/dt + 9500 dFM/dt.\n\n2. The rate of energy expended per day is divided into four components.  Specifically, EE is the sum of resting metabolic rate (RMR), physical activity (PA), spontaneous physical activity (activity expended in daily life), and the thermic effect of feeding (TEF).\n \n3. RMR is modeled by the validated regression formula developed by Livingston & Kohlstadt (2).\n\n4. Metabolic adaptation (the reduction of RMR below expected during weight loss) was set to 2% lower using the conclusions determined by Martin et al. (3).\n \n5. The TEF is modeled as a direct proportion of intake.  This  proportionality constant is different for overfeeding.\n\n6. The dynamic portion of individual PA (which does not include non-weight related changes in activity) is modeled as a direct proportion of body mass.  \n\n7. Spontaneous physical activity (SPA) is modeled by integrating the equation:  ΔSPA = sΔTEE where s=0.56 (overfeeding) and s=2/3 (underfeeding). The SPA term is bounded below by zero as a piecewise defined function during underfeeding.\n\n8.  Changes in body composition during weight change was modeled by the Forbes curve (4).\n\n9.   Baseline fat mass and fat free mass from regression models developed from the National Health and Nutrition Examination Survey (NHANES).  \n       The applied model appears in the sheet labeled Regression Models.\n\n10.  Baseline energy requirements were determined from a regression model developed from the Institute of Medicine's doubly labeled water database. \n        The model appears in the sheet labeled \"Regression Models\"."]
[]
["(1)","Thomas D.M., et al. A simple model predicting individual weight change in humans. Journal of Biological Dynamics. 2011;5(6):579-599."]
["(2)","Livingston EH, Kohlstadt I. Simplified resting metabolic rate-predicting formulas for normal-sized and obese individuals. Obes Res. Jul 2005;13(7):1255-1262."]
["(3)","Martin CK, Heilbronn LK, de Jonge L, et al. Effect of calorie restriction on resting metabolic rate and spontaneous physical activity. Obesity (Silver Spring). Dec 2007;15(12):2964-2973."]
["(4)","Forbes GB. Longitudinal changes in adult fat-free mass: influence of body weight. Am J Clin Nutr. Dec 1999;70(6):1025-1031."]

{"sheet":"Regression Models","index":7,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"Males","Females"]
["Baseline Fat Mass","24.96493 + 0.064761 * Age (years) - 0.28889 * Height (cm) + 0.55342 * Weight (kg)","18.19812 + 0.043109 * Age (years) - 0.23014 * Height (cm) + 0.641413 * Weight (kg)"]
["Baseline Energy Requirements "," 892.721 - 16.7 * Age (years) + 1.29 * Height (cm)+ 42.9 * Weight (kg) - 0.11435 * Weight ^ 2","430.29 - 12.86 * Age (years) + 12.19 * Height (cm) + 4.066 * Weight (kg) + 0.043 * Weight^2"]

{"sheet":"Video Tutorial","index":8,"n_rows":8,"n_cols":17,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Watch Video"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To watch the tutorial double click the URL in Cell A1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\nSelect the highest viewing resolution (720p) by clicking the wheel shaped icon at the bottom of the youtube video (see image on left)."]