{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["lbs","kg"],"not_rendered":{"charts":2,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"lbs","index":0,"n_rows":118,"n_cols":11,"rows_kept":118}
["Weight Loss Chart"]
["https://www.excel-template.net/weight-loss-chart/",{"$nulls":8},"© 2016 excel-template.net"]
[]
[null,"Start Weight (lbs):",222,null,"Goal Weight:",200,null,"Height (ft)",5]
[null,"Start Date:","2016-01-01",null,"Goal Date:",{"$f":"C5+90","v":"2016-03-31"},null,"Height (in)",10.5]
[null,"Start BMI:",{"$f":"IF(OR(ISBLANK(C4),ISERROR(C4*703/($I$4*12+$I$5)^2)),\" --- \",C4*703/($I$4*12+$I$5)^2)","v":{"v":31.400030179568432,"d":"31.40"}},null,"Goal BMI:",{"$f":"IF(OR(ISBLANK(F4),ISERROR(F4*703/($I$4*12+$I$5)^2)),\" --- \",F4*703/($I$4*12+$I$5)^2)","v":{"v":28.288315477088677,"d":"28.29"}}]
[]
[]
[null,"Chart Settings",{"$nulls":8},"To Change the Scale of the Vertical Axis (pounds)"]
[null,"Start Date",{"$f":"C5","v":"2016-01-01"},{"$nulls":7},"1. Right-click on the vertical axis and go to Format Axis"]
[null,"End Date",{"$f":"MAX(C27:C118)","v":"2016-03-31"},{"$nulls":7},"2. Edit the Minimum and Maximum values, then click OK"]
[]
[null,"BMI Values","BMI","Weight"]
[null,{"$f":"\"BMI=\"&C14","v":"BMI=19"},19,{"$f":"C14*($I$4*12+$I$5)^2/703","v":{"v":134.3310810810811,"d":"134.33"}}]
[null,{"$f":"\"BMI=\"&C15","v":"BMI=25"},25,{"$f":"C15*($I$4*12+$I$5)^2/703","v":{"v":176.7514224751067,"d":"176.75"}}]
[null,{"$f":"\"BMI=\"&C16","v":"BMI=30"},30,{"$f":"C16*($I$4*12+$I$5)^2/703","v":{"v":212.10170697012802,"d":"212.10"}}]
{"$rows_empty":10}
[null,null,"Date","Weight (lbs)","+/-","BMI ","1 lb/wk","2 lb/wk"]
[null,null,{"$f":"C5+1","v":"2016-01-02"},222,{"$f":"IF(D28=\"\",\"\",D28-$C$4)","v":{"v":0,"d":"0.00"}},{"$f":"IF(ISBLANK(D28),\"\",D28*703/($I$4*12+$I$5)^2)","v":{"v":31.400030179568432,"d":"31.40"}},{"$f":"$C$4-($C28-$C$5)*(1/7)","v":{"v":221.85714285714286,"d":"221.86"}},{"$f":"$C$4-($C28-$C$5)*(2/7)","v":{"v":221.71428571428572,"d":"221.71"}},null,null,"◄ Delete the sample data in the Weight column"]
[null,null,{"$f":"C28+1","v":"2016-01-03"},221,{"$f":"IF(D29=\"\",\"\",D29-$C$4)","v":{"v":-1,"d":"-1.00"}},{"$f":"IF(ISBLANK(D29),\"\",D29*703/($I$4*12+$I$5)^2)","v":{"v":31.25858860218299,"d":"31.26"}},{"v":221.71428571428572,"d":"221.71"},{"v":221.42857142857142,"d":"221.43"},null,null,"◄ 1 lb/wk: Appears as dark blue diagonal line in graph"]
[null,null,{"$f":"C29+1","v":"2016-01-04"},221.5,{"v":-0.5,"d":"-0.50"},{"v":31.32930939087571,"d":"31.33"},{"v":221.57142857142858,"d":"221.57"},{"v":221.14285714285714,"d":"221.14"},null,null,"◄ 2 lb/wk: Appears as light blue diagonal line in graph"]
[null,null,"2016-01-05",222,{"v":0,"d":"0.00"},{"v":31.400030179568432,"d":"31.40"},{"v":221.42857142857142,"d":"221.43"},{"v":220.85714285714286,"d":"220.86"}]
[null,null,"2016-01-06",220.5,{"v":-1.5,"d":"-1.50"},{"v":31.187867813490268,"d":"31.19"},{"v":221.28571428571428,"d":"221.29"},{"v":220.57142857142858,"d":"220.57"}]
[null,null,"2016-01-07",220.4,{"v":-1.5999999999999943,"d":"-1.60"},{"v":31.173723655751726,"d":"31.17"},{"v":221.14285714285714,"d":"221.14"},{"v":220.28571428571428,"d":"220.29"}]
[null,null,"2016-01-08",220.8,{"v":-1.1999999999999886,"d":"-1.20"},{"v":31.230300286705898,"d":"31.23"},{"v":221,"d":"221.00"},{"v":220,"d":"220.00"}]
[null,null,"2016-01-09",223.2,{"v":1.1999999999999886,"d":"1.20"},{"v":31.569760072430967,"d":"31.57"},{"v":220.85714285714286,"d":"220.86"},{"v":219.71428571428572,"d":"219.71"}]
[null,null,"2016-01-10",221.7,{"v":-0.30000000000001137,"d":"-0.30"},{"v":31.3575977063528,"d":"31.36"},{"v":220.71428571428572,"d":"220.71"},{"v":219.42857142857142,"d":"219.43"}]
[null,null,"2016-01-11",220.8,{"v":-1.1999999999999886,"d":"-1.20"},{"v":31.230300286705898,"d":"31.23"},{"v":220.57142857142858,"d":"220.57"},{"v":219.14285714285714,"d":"219.14"}]
[null,null,"2016-01-12",222.3,{"v":0.30000000000001137,"d":"0.30"},{"v":31.442462652784062,"d":"31.44"},{"v":220.42857142857142,"d":"220.43"},{"v":218.85714285714286,"d":"218.86"}]
[null,null,"2016-01-13",220.8,{"v":-1.1999999999999886,"d":"-1.20"},{"v":31.230300286705898,"d":"31.23"},{"v":220.28571428571428,"d":"220.29"},{"v":218.57142857142858,"d":"218.57"}]
[null,null,"2016-01-14",219.8,{"v":-2.1999999999999886,"d":"-2.20"},{"v":31.088858709320455,"d":"31.09"},{"v":220.14285714285714,"d":"220.14"},{"v":218.28571428571428,"d":"218.29"}]
[null,null,"2016-01-15",219.6,{"v":-2.4000000000000057,"d":"-2.40"},{"v":31.060570393843367,"d":"31.06"},{"v":220,"d":"220.00"},{"v":218,"d":"218.00"}]
[null,null,"2016-01-16",216,{"v":-6,"d":"-6.00"},{"v":30.55138071525577,"d":"30.55"},{"v":219.85714285714286,"d":"219.86"},{"v":217.71428571428572,"d":"217.71"}]
[null,null,"2016-01-17",217.4,{"v":-4.599999999999994,"d":"-4.60"},{"v":30.749398923595393,"d":"30.75"},{"v":219.71428571428572,"d":"219.71"},{"v":217.42857142857142,"d":"217.43"}]
[null,null,"2016-01-18",216.5,{"v":-5.5,"d":"-5.50"},{"v":30.622101503948493,"d":"30.62"},{"v":219.57142857142858,"d":"219.57"},{"v":217.14285714285714,"d":"217.14"}]
[null,null,"2016-01-19",218.2,{"v":-3.8000000000000114,"d":"-3.80"},{"v":30.86255218550375,"d":"30.86"},{"v":219.42857142857142,"d":"219.43"},{"v":216.85714285714286,"d":"216.86"}]
[null,null,"2016-01-20",217.4,{"v":-4.599999999999994,"d":"-4.60"},{"v":30.749398923595393,"d":"30.75"},{"v":219.28571428571428,"d":"219.29"},{"v":216.57142857142858,"d":"216.57"}]
[null,null,"2016-01-21",null,"","",{"v":219.14285714285714,"d":"219.14"},{"v":216.28571428571428,"d":"216.29"}]
[null,null,"2016-01-22",null,"","",{"v":219,"d":"219.00"},{"v":216,"d":"216.00"}]
[null,null,"2016-01-23",null,"","",{"v":218.85714285714286,"d":"218.86"},{"v":215.71428571428572,"d":"215.71"}]
[null,null,"2016-01-24",null,"","",{"v":218.71428571428572,"d":"218.71"},{"v":215.42857142857142,"d":"215.43"}]
[null,null,"2016-01-25",null,"","",{"v":218.57142857142858,"d":"218.57"},{"v":215.14285714285714,"d":"215.14"}]
[null,null,"2016-01-26",null,"","",{"v":218.42857142857142,"d":"218.43"},{"v":214.85714285714286,"d":"214.86"}]
[null,null,"2016-01-27",null,"","",{"v":218.28571428571428,"d":"218.29"},{"v":214.57142857142858,"d":"214.57"}]
[null,null,"2016-01-28",null,"","",{"v":218.14285714285714,"d":"218.14"},{"v":214.28571428571428,"d":"214.29"}]
[null,null,"2016-01-29",null,"","",{"v":218,"d":"218.00"},{"v":214,"d":"214.00"}]
[null,null,"2016-01-30",null,"","",{"v":217.85714285714286,"d":"217.86"},{"v":213.71428571428572,"d":"213.71"}]
[null,null,"2016-01-31",null,"","",{"v":217.71428571428572,"d":"217.71"},{"v":213.42857142857142,"d":"213.43"}]
[null,null,"2016-02-01",null,"","",{"v":217.57142857142858,"d":"217.57"},{"v":213.14285714285714,"d":"213.14"}]
[null,null,"2016-02-02",null,"","",{"v":217.42857142857142,"d":"217.43"},{"v":212.85714285714286,"d":"212.86"}]
[null,null,"2016-02-03",null,"","",{"$f":"$C$4-($C60-$C$5)*(1/7)","v":{"v":217.28571428571428,"d":"217.29"}},{"$f":"$C$4-($C60-$C$5)*(2/7)","v":{"v":212.57142857142858,"d":"212.57"}}]
[null,null,"2016-02-04",null,"","",{"v":217.14285714285714,"d":"217.14"},{"v":212.28571428571428,"d":"212.29"}]
[null,null,"2016-02-05",null,"","",{"v":217,"d":"217.00"},{"v":212,"d":"212.00"}]
[null,null,"2016-02-06",null,"","",{"v":216.85714285714286,"d":"216.86"},{"v":211.71428571428572,"d":"211.71"}]
[null,null,"2016-02-07",null,"","",{"v":216.71428571428572,"d":"216.71"},{"v":211.42857142857142,"d":"211.43"}]
[null,null,"2016-02-08",null,"","",{"v":216.57142857142858,"d":"216.57"},{"v":211.14285714285714,"d":"211.14"}]
[null,null,"2016-02-09",null,"","",{"v":216.42857142857142,"d":"216.43"},{"v":210.85714285714286,"d":"210.86"}]
[null,null,"2016-02-10",null,"","",{"v":216.28571428571428,"d":"216.29"},{"v":210.57142857142858,"d":"210.57"}]
[null,null,"2016-02-11",null,"","",{"v":216.14285714285714,"d":"216.14"},{"v":210.28571428571428,"d":"210.29"}]
[null,null,"2016-02-12",null,"","",{"v":216,"d":"216.00"},{"v":210,"d":"210.00"}]
[null,null,"2016-02-13",null,"","",{"v":215.85714285714286,"d":"215.86"},{"v":209.71428571428572,"d":"209.71"}]
[null,null,"2016-02-14",null,"","",{"v":215.71428571428572,"d":"215.71"},{"v":209.42857142857142,"d":"209.43"}]
[null,null,"2016-02-15",null,"","",{"v":215.57142857142858,"d":"215.57"},{"v":209.14285714285714,"d":"209.14"}]
[null,null,"2016-02-16",null,"","",{"v":215.42857142857142,"d":"215.43"},{"v":208.85714285714286,"d":"208.86"}]
[null,null,"2016-02-17",null,"","",{"v":215.28571428571428,"d":"215.29"},{"v":208.57142857142858,"d":"208.57"}]
[null,null,"2016-02-18",null,"","",{"v":215.14285714285714,"d":"215.14"},{"v":208.28571428571428,"d":"208.29"}]
[null,null,"2016-02-19",null,"","",{"v":215,"d":"215.00"},{"v":208,"d":"208.00"}]
[null,null,"2016-02-20",null,"","",{"v":214.85714285714286,"d":"214.86"},{"v":207.71428571428572,"d":"207.71"}]
[null,null,"2016-02-21",null,"","",{"v":214.71428571428572,"d":"214.71"},{"v":207.42857142857142,"d":"207.43"}]
[null,null,"2016-02-22",null,"","",{"v":214.57142857142858,"d":"214.57"},{"v":207.14285714285714,"d":"207.14"}]
[null,null,"2016-02-23",null,"","",{"v":214.42857142857142,"d":"214.43"},{"v":206.85714285714286,"d":"206.86"}]
[null,null,"2016-02-24",null,"","",{"v":214.28571428571428,"d":"214.29"},{"v":206.57142857142858,"d":"206.57"}]
[null,null,"2016-02-25",null,"","",{"v":214.14285714285714,"d":"214.14"},{"v":206.28571428571428,"d":"206.29"}]
[null,null,"2016-02-26",null,"","",{"v":214,"d":"214.00"},{"v":206,"d":"206.00"}]
[null,null,"2016-02-27",null,"","",{"v":213.85714285714286,"d":"213.86"},{"v":205.71428571428572,"d":"205.71"}]
[null,null,"2016-02-28",null,"","",{"v":213.71428571428572,"d":"213.71"},{"v":205.42857142857144,"d":"205.43"}]
[null,null,"2016-02-29",null,"","",{"v":213.57142857142858,"d":"213.57"},{"v":205.14285714285714,"d":"205.14"}]
[null,null,"2016-03-01",null,"","",{"v":213.42857142857142,"d":"213.43"},{"v":204.85714285714286,"d":"204.86"}]
[null,null,"2016-03-02",null,"","",{"v":213.28571428571428,"d":"213.29"},{"v":204.57142857142858,"d":"204.57"}]
[null,null,"2016-03-03",null,"","",{"v":213.14285714285714,"d":"213.14"},{"v":204.28571428571428,"d":"204.29"}]
[null,null,"2016-03-04",null,"","",{"v":213,"d":"213.00"},{"v":204,"d":"204.00"}]
[null,null,"2016-03-05",null,"","",{"v":212.85714285714286,"d":"212.86"},{"v":203.71428571428572,"d":"203.71"}]
[null,null,"2016-03-06",null,"","",{"$f":"$C$4-($C92-$C$5)*(1/7)","v":{"v":212.71428571428572,"d":"212.71"}},{"$f":"$C$4-($C92-$C$5)*(2/7)","v":{"v":203.42857142857144,"d":"203.43"}}]
[null,null,"2016-03-07",null,{"$f":"IF(D93=\"\",\"\",D93-$C$4)","v":""},{"$f":"IF(ISBLANK(D93),\"\",D93*703/($I$4*12+$I$5)^2)","v":""},{"v":212.57142857142858,"d":"212.57"},{"v":203.14285714285714,"d":"203.14"}]
[null,null,{"$f":"C93+1","v":"2016-03-08"},null,"","",{"v":212.42857142857142,"d":"212.43"},{"v":202.85714285714286,"d":"202.86"}]
[null,null,"2016-03-09",null,"","",{"v":212.28571428571428,"d":"212.29"},{"v":202.57142857142858,"d":"202.57"}]
[null,null,"2016-03-10",null,"","",{"v":212.14285714285714,"d":"212.14"},{"v":202.28571428571428,"d":"202.29"}]
[null,null,"2016-03-11",null,"","",{"v":212,"d":"212.00"},{"v":202,"d":"202.00"}]
[null,null,"2016-03-12",null,"","",{"v":211.85714285714286,"d":"211.86"},{"v":201.71428571428572,"d":"201.71"}]
[null,null,"2016-03-13",null,"","",{"v":211.71428571428572,"d":"211.71"},{"v":201.42857142857144,"d":"201.43"}]
[null,null,"2016-03-14",null,"","",{"v":211.57142857142858,"d":"211.57"},{"v":201.14285714285714,"d":"201.14"}]
[null,null,"2016-03-15",null,"","",{"v":211.42857142857142,"d":"211.43"},{"v":200.85714285714286,"d":"200.86"}]
[null,null,"2016-03-16",null,"","",{"v":211.28571428571428,"d":"211.29"},{"v":200.57142857142858,"d":"200.57"}]
[null,null,"2016-03-17",null,"","",{"v":211.14285714285714,"d":"211.14"},{"v":200.28571428571428,"d":"200.29"}]
[null,null,"2016-03-18",null,"","",{"v":211,"d":"211.00"},{"v":200,"d":"200.00"}]
[null,null,"2016-03-19",null,"","",{"v":210.85714285714286,"d":"210.86"},{"v":199.71428571428572,"d":"199.71"}]
[null,null,"2016-03-20",null,"","",{"v":210.71428571428572,"d":"210.71"},{"v":199.42857142857144,"d":"199.43"}]
[null,null,"2016-03-21",null,"","",{"v":210.57142857142858,"d":"210.57"},{"v":199.14285714285714,"d":"199.14"}]
[null,null,"2016-03-22",null,"","",{"v":210.42857142857142,"d":"210.43"},{"v":198.85714285714286,"d":"198.86"}]
[null,null,"2016-03-23",null,"","",{"v":210.28571428571428,"d":"210.29"},{"v":198.57142857142858,"d":"198.57"}]
[null,null,"2016-03-24",null,"","",{"v":210.14285714285714,"d":"210.14"},{"v":198.28571428571428,"d":"198.29"}]
[null,null,"2016-03-25",null,"","",{"v":210,"d":"210.00"},{"v":198,"d":"198.00"}]
[null,null,"2016-03-26",null,"","",{"v":209.85714285714286,"d":"209.86"},{"v":197.71428571428572,"d":"197.71"}]
[null,null,"2016-03-27",null,"","",{"v":209.71428571428572,"d":"209.71"},{"v":197.42857142857144,"d":"197.43"}]
[null,null,"2016-03-28",null,"","",{"v":209.57142857142858,"d":"209.57"},{"v":197.14285714285714,"d":"197.14"}]
[null,null,"2016-03-29",null,"","",{"v":209.42857142857142,"d":"209.43"},{"v":196.85714285714286,"d":"196.86"}]
[null,null,"2016-03-30",null,"","",{"v":209.28571428571428,"d":"209.29"},{"v":196.57142857142858,"d":"196.57"}]
[null,null,"2016-03-31",null,"","",{"v":209.14285714285714,"d":"209.14"},{"v":196.28571428571428,"d":"196.29"}]
[{"$nulls":10},"◄ Insert new rows ABOVE this one, then copy formulas down (in columns C-F)"]

{"sheet":"kg","index":1,"n_rows":118,"n_cols":11,"rows_kept":118}
["Weight Loss Chart (metric)"]
["https://www.excel-template.net/weight-loss-chart/",{"$nulls":8},"© 2016 excel-template.net"]
[]
[null,"Start Weight (kg):",84,null,"Goal Weight:",73,null,"Height (cm)",177]
[null,"Start Date:","2016-01-01",null,"Goal Date:",{"$f":"C5+90","v":"2016-03-31"}]
[null,"Start BMI:",{"$f":"IF(OR(ISBLANK(C4),ISERROR(C4/($I$4/100)^2)),\" --- \",C4/($I$4/100)^2)","v":{"v":26.812218711098343,"d":"26.81"}},null,"Goal BMI:",{"$f":"IF(OR(ISBLANK(F4),ISERROR(F4/($I$4/100)^2)),\" --- \",F4/($I$4/100)^2)","v":{"v":23.301094832264035,"d":"23.30"}}]
[]
[]
[null,"Chart Settings"]
[null,"Start Date",{"$f":"C5","v":"2016-01-01"},{"$nulls":7},"To Change the Scale of the Vertical Axis (pounds)"]
[null,"End Date",{"$f":"MAX(C27:C118)","v":"2016-03-31"},{"$nulls":7},"1. Right-click on the vertical axis and go to Format Axis"]
[{"$nulls":10},"2. Edit the Minimum and Maximum values, then click OK"]
[null,"BMI Values","BMI","Weight"]
[null,{"$f":"\"BMI=\"&C14","v":"BMI=19"},19,{"$f":"C14*($I$4/100)^2","v":{"v":59.5251,"d":"59.53"}}]
[null,{"$f":"\"BMI=\"&C15","v":"BMI=25"},25,{"$f":"C15*($I$4/100)^2","v":{"v":78.3225,"d":"78.32"}}]
[null,{"$f":"\"BMI=\"&C16","v":"BMI=30"},30,{"$f":"C16*($I$4/100)^2","v":{"v":93.98700000000001,"d":"93.99"}}]
{"$rows_empty":10}
[null,null,"Date","Weight (kg)","+/-","BMI ","½ kg/wk","1 kg/wk"]
[null,null,{"$f":"C5+1","v":"2016-01-02"},84.2,{"$f":"IF(D28=\"\",\"\",D28-$C$4)","v":{"v":0.20000000000000284,"d":"0.20"}},{"$f":"IF(ISBLANK(D28),\"\",D28/($I$4/100)^2)","v":{"v":26.87605732707715,"d":"26.88"}},{"$f":"$C$4-($C28-$C$5)*(0.5/7)","v":{"v":83.92857142857143,"d":"83.93"}},{"$f":"$C$4-($C28-$C$5)*(1/7)","v":{"v":83.85714285714286,"d":"83.86"}},null,null,"◄ Delete the sample data in the Weight column"]
[null,null,{"$f":"C28+1","v":"2016-01-03"},83.7,{"v":-0.29999999999999716,"d":"-0.30"},{"$f":"IF(ISBLANK(D29),\"\",D29/($I$4/100)^2)","v":{"v":26.716460787130135,"d":"26.72"}},{"v":83.85714285714286,"d":"83.86"},{"v":83.71428571428571,"d":"83.71"},null,null,"◄ 1/2 kg/wk: Appears as dark blue diagonal line in graph"]
[null,null,"2016-01-04",84,{"v":0,"d":"0.00"},{"v":26.812218711098343,"d":"26.81"},{"v":83.78571428571429,"d":"83.79"},{"v":83.57142857142857,"d":"83.57"},null,null,"◄ 1 kg/wk: Appears as light blue diagonal line in graph"]
[null,null,"2016-01-05",84.1,{"v":0.09999999999999432,"d":"0.10"},{"v":26.844138019087744,"d":"26.84"},{"v":83.71428571428571,"d":"83.71"},{"v":83.42857142857143,"d":"83.43"}]
[null,null,"2016-01-06",83.7,{"v":-0.29999999999999716,"d":"-0.30"},{"v":26.716460787130135,"d":"26.72"},{"v":83.64285714285714,"d":"83.64"},{"v":83.28571428571429,"d":"83.29"}]
[null,null,"2016-01-07",83.5,{"v":-0.5,"d":"-0.50"},{"v":26.65262217115133,"d":"26.65"},{"v":83.57142857142857,"d":"83.57"},{"v":83.14285714285714,"d":"83.14"}]
[null,null,"2016-01-08",83.6,{"v":-0.4000000000000057,"d":"-0.40"},{"v":26.68454147914073,"d":"26.68"},{"v":83.5,"d":"83.50"},{"v":83,"d":"83.00"}]
[null,null,"2016-01-09",84.5,{"v":0.5,"d":"0.50"},{"v":26.971815251045356,"d":"26.97"},{"v":83.42857142857143,"d":"83.43"},{"v":82.85714285714286,"d":"82.86"}]
[null,null,"2016-01-10",84,{"v":0,"d":"0.00"},{"v":26.812218711098343,"d":"26.81"},{"v":83.35714285714286,"d":"83.36"},{"v":82.71428571428571,"d":"82.71"}]
[null,null,"2016-01-11",83.6,{"v":-0.4000000000000057,"d":"-0.40"},{"v":26.68454147914073,"d":"26.68"},{"v":83.28571428571429,"d":"83.29"},{"v":82.57142857142857,"d":"82.57"}]
[null,null,"2016-01-12",84.2,{"v":0.20000000000000284,"d":"0.20"},{"v":26.87605732707715,"d":"26.88"},{"v":83.21428571428571,"d":"83.21"},{"v":82.42857142857143,"d":"82.43"}]
[null,null,"2016-01-13",83.6,{"v":-0.4000000000000057,"d":"-0.40"},{"v":26.68454147914073,"d":"26.68"},{"v":83.14285714285714,"d":"83.14"},{"v":82.28571428571429,"d":"82.29"}]
[null,null,"2016-01-14",83.3,{"v":-0.7000000000000028,"d":"-0.70"},{"v":26.588783555172522,"d":"26.59"},{"v":83.07142857142857,"d":"83.07"},{"v":82.14285714285714,"d":"82.14"}]
[null,null,"2016-01-15",83.2,{"v":-0.7999999999999972,"d":"-0.80"},{"v":26.55686424718312,"d":"26.56"},{"v":83,"d":"83.00"},{"v":82,"d":"82.00"}]
[null,null,"2016-01-16",83,{"v":-1,"d":"-1.00"},{"v":26.493025631204315,"d":"26.49"},{"v":82.92857142857143,"d":"82.93"},{"v":81.85714285714286,"d":"81.86"}]
[null,null,"2016-01-17",82.4,{"v":-1.5999999999999943,"d":"-1.60"},{"v":26.3015097832679,"d":"26.30"},{"v":82.85714285714286,"d":"82.86"},{"v":81.71428571428571,"d":"81.71"}]
[null,null,"2016-01-18",82,{"v":-2,"d":"-2.00"},{"v":26.173832551310287,"d":"26.17"},{"v":82.78571428571429,"d":"82.79"},{"v":81.57142857142857,"d":"81.57"}]
[null,null,"2016-01-19",82.7,{"v":-1.2999999999999972,"d":"-1.30"},{"v":26.397267707236107,"d":"26.40"},{"v":82.71428571428571,"d":"82.71"},{"v":81.42857142857143,"d":"81.43"}]
[null,null,"2016-01-20",82.4,{"v":-1.5999999999999943,"d":"-1.60"},{"v":26.3015097832679,"d":"26.30"},{"v":82.64285714285714,"d":"82.64"},{"v":81.28571428571429,"d":"81.29"}]
[null,null,"2016-01-21",null,"","",{"v":82.57142857142857,"d":"82.57"},{"v":81.14285714285714,"d":"81.14"}]
[null,null,"2016-01-22",null,"","",{"v":82.5,"d":"82.50"},{"v":81,"d":"81.00"}]
[null,null,"2016-01-23",null,"","",{"v":82.42857142857143,"d":"82.43"},{"v":80.85714285714286,"d":"80.86"}]
[null,null,"2016-01-24",null,"","",{"v":82.35714285714286,"d":"82.36"},{"v":80.71428571428571,"d":"80.71"}]
[null,null,"2016-01-25",null,"","",{"v":82.28571428571429,"d":"82.29"},{"v":80.57142857142857,"d":"80.57"}]
[null,null,"2016-01-26",null,"","",{"v":82.21428571428571,"d":"82.21"},{"v":80.42857142857143,"d":"80.43"}]
[null,null,"2016-01-27",null,"","",{"v":82.14285714285714,"d":"82.14"},{"v":80.28571428571429,"d":"80.29"}]
[null,null,"2016-01-28",null,"","",{"v":82.07142857142857,"d":"82.07"},{"v":80.14285714285714,"d":"80.14"}]
[null,null,"2016-01-29",null,"","",{"v":82,"d":"82.00"},{"v":80,"d":"80.00"}]
[null,null,"2016-01-30",null,"","",{"v":81.92857142857143,"d":"81.93"},{"v":79.85714285714286,"d":"79.86"}]
[null,null,"2016-01-31",null,"","",{"v":81.85714285714286,"d":"81.86"},{"v":79.71428571428571,"d":"79.71"}]
[null,null,"2016-02-01",null,"","",{"v":81.78571428571429,"d":"81.79"},{"v":79.57142857142857,"d":"79.57"}]
[null,null,"2016-02-02",null,"","",{"v":81.71428571428571,"d":"81.71"},{"v":79.42857142857143,"d":"79.43"}]
[null,null,"2016-02-03",null,{"$f":"IF(D60=\"\",\"\",D60-$C$4)","v":""},"",{"$f":"$C$4-($C60-$C$5)*(0.5/7)","v":{"v":81.64285714285714,"d":"81.64"}},{"$f":"$C$4-($C60-$C$5)*(1/7)","v":{"v":79.28571428571429,"d":"79.29"}}]
[null,null,"2016-02-04",null,"","",{"v":81.57142857142857,"d":"81.57"},{"v":79.14285714285714,"d":"79.14"}]
[null,null,"2016-02-05",null,"","",{"v":81.5,"d":"81.50"},{"v":79,"d":"79.00"}]
[null,null,"2016-02-06",null,"","",{"v":81.42857142857143,"d":"81.43"},{"v":78.85714285714286,"d":"78.86"}]
[null,null,"2016-02-07",null,"","",{"v":81.35714285714286,"d":"81.36"},{"v":78.71428571428571,"d":"78.71"}]
[null,null,"2016-02-08",null,"","",{"v":81.28571428571429,"d":"81.29"},{"v":78.57142857142857,"d":"78.57"}]
[null,null,"2016-02-09",null,"","",{"v":81.21428571428571,"d":"81.21"},{"v":78.42857142857143,"d":"78.43"}]
[null,null,"2016-02-10",null,"","",{"v":81.14285714285714,"d":"81.14"},{"v":78.28571428571429,"d":"78.29"}]
[null,null,"2016-02-11",null,"","",{"v":81.07142857142857,"d":"81.07"},{"v":78.14285714285714,"d":"78.14"}]
[null,null,"2016-02-12",null,"","",{"v":81,"d":"81.00"},{"v":78,"d":"78.00"}]
[null,null,"2016-02-13",null,"","",{"v":80.92857142857143,"d":"80.93"},{"v":77.85714285714286,"d":"77.86"}]
[null,null,"2016-02-14",null,"","",{"v":80.85714285714286,"d":"80.86"},{"v":77.71428571428571,"d":"77.71"}]
[null,null,"2016-02-15",null,"","",{"v":80.78571428571429,"d":"80.79"},{"v":77.57142857142857,"d":"77.57"}]
[null,null,"2016-02-16",null,"","",{"v":80.71428571428571,"d":"80.71"},{"v":77.42857142857143,"d":"77.43"}]
[null,null,"2016-02-17",null,"","",{"v":80.64285714285714,"d":"80.64"},{"v":77.28571428571429,"d":"77.29"}]
[null,null,"2016-02-18",null,"","",{"v":80.57142857142857,"d":"80.57"},{"v":77.14285714285714,"d":"77.14"}]
[null,null,"2016-02-19",null,"","",{"v":80.5,"d":"80.50"},{"v":77,"d":"77.00"}]
[null,null,"2016-02-20",null,"","",{"v":80.42857142857143,"d":"80.43"},{"v":76.85714285714286,"d":"76.86"}]
[null,null,"2016-02-21",null,"","",{"v":80.35714285714286,"d":"80.36"},{"v":76.71428571428571,"d":"76.71"}]
[null,null,"2016-02-22",null,"","",{"v":80.28571428571429,"d":"80.29"},{"v":76.57142857142857,"d":"76.57"}]
[null,null,"2016-02-23",null,"","",{"v":80.21428571428571,"d":"80.21"},{"v":76.42857142857143,"d":"76.43"}]
[null,null,"2016-02-24",null,"","",{"v":80.14285714285714,"d":"80.14"},{"v":76.28571428571429,"d":"76.29"}]
[null,null,"2016-02-25",null,"","",{"v":80.07142857142857,"d":"80.07"},{"v":76.14285714285714,"d":"76.14"}]
[null,null,"2016-02-26",null,"","",{"v":80,"d":"80.00"},{"v":76,"d":"76.00"}]
[null,null,"2016-02-27",null,"","",{"v":79.92857142857143,"d":"79.93"},{"v":75.85714285714286,"d":"75.86"}]
[null,null,"2016-02-28",null,"","",{"v":79.85714285714286,"d":"79.86"},{"v":75.71428571428572,"d":"75.71"}]
[null,null,"2016-02-29",null,"","",{"v":79.78571428571429,"d":"79.79"},{"v":75.57142857142857,"d":"75.57"}]
[null,null,"2016-03-01",null,"","",{"v":79.71428571428571,"d":"79.71"},{"v":75.42857142857143,"d":"75.43"}]
[null,null,"2016-03-02",null,"","",{"v":79.64285714285714,"d":"79.64"},{"v":75.28571428571429,"d":"75.29"}]
[null,null,"2016-03-03",null,"","",{"v":79.57142857142857,"d":"79.57"},{"v":75.14285714285714,"d":"75.14"}]
[null,null,"2016-03-04",null,"","",{"v":79.5,"d":"79.50"},{"v":75,"d":"75.00"}]
[null,null,"2016-03-05",null,"","",{"v":79.42857142857143,"d":"79.43"},{"v":74.85714285714286,"d":"74.86"}]
[null,null,"2016-03-06",null,{"$f":"IF(D92=\"\",\"\",D92-$C$4)","v":""},"",{"$f":"$C$4-($C92-$C$5)*(0.5/7)","v":{"v":79.35714285714286,"d":"79.36"}},{"$f":"$C$4-($C92-$C$5)*(1/7)","v":{"v":74.71428571428572,"d":"74.71"}}]
[null,null,{"$f":"C92+1","v":"2016-03-07"},null,"",{"$f":"IF(ISBLANK(D93),\"\",D93/($I$4/100)^2)","v":""},{"v":79.28571428571429,"d":"79.29"},{"v":74.57142857142857,"d":"74.57"}]
[null,null,"2016-03-08",null,"","",{"v":79.21428571428571,"d":"79.21"},{"v":74.42857142857143,"d":"74.43"}]
[null,null,"2016-03-09",null,"","",{"v":79.14285714285714,"d":"79.14"},{"v":74.28571428571429,"d":"74.29"}]
[null,null,"2016-03-10",null,"","",{"v":79.07142857142857,"d":"79.07"},{"v":74.14285714285714,"d":"74.14"}]
[null,null,"2016-03-11",null,"","",{"v":79,"d":"79.00"},{"v":74,"d":"74.00"}]
[null,null,"2016-03-12",null,"","",{"v":78.92857142857143,"d":"78.93"},{"v":73.85714285714286,"d":"73.86"}]
[null,null,"2016-03-13",null,"","",{"v":78.85714285714286,"d":"78.86"},{"v":73.71428571428572,"d":"73.71"}]
[null,null,"2016-03-14",null,"","",{"v":78.78571428571429,"d":"78.79"},{"v":73.57142857142857,"d":"73.57"}]
[null,null,"2016-03-15",null,"","",{"v":78.71428571428571,"d":"78.71"},{"v":73.42857142857143,"d":"73.43"}]
[null,null,"2016-03-16",null,"","",{"v":78.64285714285714,"d":"78.64"},{"v":73.28571428571429,"d":"73.29"}]
[null,null,"2016-03-17",null,"","",{"v":78.57142857142857,"d":"78.57"},{"v":73.14285714285714,"d":"73.14"}]
[null,null,"2016-03-18",null,"","",{"v":78.5,"d":"78.50"},{"v":73,"d":"73.00"}]
[null,null,"2016-03-19",null,"","",{"v":78.42857142857143,"d":"78.43"},{"v":72.85714285714286,"d":"72.86"}]
[null,null,"2016-03-20",null,"","",{"v":78.35714285714286,"d":"78.36"},{"v":72.71428571428572,"d":"72.71"}]
[null,null,"2016-03-21",null,"","",{"v":78.28571428571429,"d":"78.29"},{"v":72.57142857142857,"d":"72.57"}]
[null,null,"2016-03-22",null,"","",{"v":78.21428571428571,"d":"78.21"},{"v":72.42857142857143,"d":"72.43"}]
[null,null,"2016-03-23",null,"","",{"v":78.14285714285714,"d":"78.14"},{"v":72.28571428571429,"d":"72.29"}]
[null,null,"2016-03-24",null,"","",{"v":78.07142857142857,"d":"78.07"},{"v":72.14285714285714,"d":"72.14"}]
[null,null,"2016-03-25",null,"","",{"v":78,"d":"78.00"},{"v":72,"d":"72.00"}]
[null,null,"2016-03-26",null,"","",{"v":77.92857142857143,"d":"77.93"},{"v":71.85714285714286,"d":"71.86"}]
[null,null,"2016-03-27",null,"","",{"v":77.85714285714286,"d":"77.86"},{"v":71.71428571428572,"d":"71.71"}]
[null,null,"2016-03-28",null,"","",{"v":77.78571428571429,"d":"77.79"},{"v":71.57142857142857,"d":"71.57"}]
[null,null,"2016-03-29",null,"","",{"v":77.71428571428571,"d":"77.71"},{"v":71.42857142857143,"d":"71.43"}]
[null,null,"2016-03-30",null,"","",{"v":77.64285714285714,"d":"77.64"},{"v":71.28571428571429,"d":"71.29"}]
[null,null,"2016-03-31",null,"","",{"v":77.57142857142857,"d":"77.57"},{"v":71.14285714285714,"d":"71.14"}]
[{"$nulls":9},"◄ Insert new rows ABOVE this one, then copy formulas down (in columns C-F)"]