{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Introduction","Basic Demonstration","Demonstration 3","Linear","Full Row Test","Basic","Full Column Demonstration"],"not_rendered":{"charts":3,"images":7,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"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":"Introduction","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Basic Demonstration","index":1,"n_rows":59,"n_cols":25,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Instructions at www.edbodmer.com\t",null,null,null,"Questions: e-mail edwardbodmer@gmail.com"]
[null,null,"ROIC",null,null,null,null,null,null,null,null,null,null,null,null,null,"It is a good idea to use \"This Worksheet\""]
[null,2010,0.3,null,null,"Step 1: ALT, F8 -- Goto Developer Tab and Open the FUNCTIONS Macro"]
[null,2014,0.06,null,null,"Step 2: Select (CNTL A) Entire Macro Module (Functions) "]
[null,2018,0.1,null,null,"Step 3: Copy (CNTL C) Entire Macro Module (Functions) "]
[null,2022,0.08,null,null,"Step 4: Open a Macro in Your Model (F8 and type test or something)"]
[null,2026,0.09,null,null,"Step 5: Copy to your New Model with CNTL V"]
[null,2030,0.12,null,null,"Note: If numbers go to zero or negative, use interpolate_linear"]
[]
[]
[null,null,"Year",2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2030]
[]
[null,null,"ROIC",{"$f":"LOOKUP(D11,$B:$B,$C:$C)","v":0.3},0.3,0.3,0.3,0.06,0.06,0.06,0.06,0.1,0.1,0.1,0.1,0.08,0.08,0.08,0.08,0.09,0.09,0.09,0.09,0.12,0.12]
[]
[null,null,"Basic",{"$f":"basic_look_up(D11,$B$3:$B$8,$C$3:$C$8)","v":0.3},0.3,0.3,0.3,0.06,0.06,0.06,{"$f":"basic_look_up(K11,$B$3:$B$8,$C$3:$C$8)","v":0.06},0.1,0.1,0.1,0.1,0.08,0.08,0.08,0.08,0.12,0.12,0.12,0.12,0.12,{"$f":"basic_look_up(Y11,$B$3:$B$8,$C$3:$C$8)","v":0.12}]
[]
[null,null,"Long",{"$f":"long_look_up(D11,$B:$B,$C:$C)","v":0.3},0.3,0.3,0.3,0.06,0.06,0.06,0.06,0.1,0.1,0.1,0.1,0.08,0.08,0.08,0.08,0.09,0.09,0.09,0.09,0.12,0.12]
[]
[null,null,"Interpolate look up",{"$f":"interpolate_look_up(D11,$B:$B,$C:$C)","v":0.3},{"$f":"interpolate_look_up(E11,$B:$B,$C:$C)","v":0.20062209149292659},0.13416407864998736,8.9720926873273238E-2,0.06,6.8173161988049957E-2,7.7459666924148338E-2,8.8011173679339333E-2,0.1,9.4574160900317589E-2,8.9442719099991588E-2,8.4589701075245133E-2,0.08,8.2390685756284707E-2,8.4852813742385694E-2,8.7388518907318219E-2,0.09,9.671129386411878E-2,0.10392304845413262,0.11167258309225195,0.12,0.12]
[]
[null,null,"Linear Interpolate",{"$f":"interpolate_look_up_linear(D11,$B$3:$B$8,$C$3:$C$8)","v":0.3},{"$f":"interpolate_look_up_linear(E11,$B$3:$B$8,$C$3:$C$8)","v":0.24},0.18,0.12,0.06,7.0000000000000007E-2,0.08,0.09,0.1,9.5000000000000001E-2,0.09,8.5000000000000006E-2,0.08,8.2500000000000004E-2,8.4999999999999992E-2,8.7499999999999994E-2,0.09,9.7500000000000003E-2,0.105,0.11249999999999999,0.12,0.12]
[]
[null,"Demonstration of how it works"]
[null,null,null,{"$f":"D15","v":0.3}]
[null,null,null,{"$f":"H15","v":0.06}]
[null,"First compute Growth"]
[null,null,"Cols -1",{"$f":"COLUMN(H13)-COLUMN(D13)","v":4}]
[null,null,"Growth",{"$f":"(D25/D24)^(1/D27)-1","v":-0.33125969502357799},{"$f":"D28","v":-0.33125969502357799},{"$f":"E28","v":-0.33125969502357799},{"$f":"F28","v":-0.33125969502357799},{"$f":"G28","v":-0.33125969502357799},null,null,{"$f":"show_formula(K19)","v":"=interpolate_look_up(K11,$B:$B,$C:$C)"}]
[]
[null,"Value is Base plus Growth"]
[null,null,"Value",{"$f":"D17","v":0.3},{"$f":"D31*(1+E28)","v":0.20062209149292659},{"$f":"E31*(1+F28)","v":0.13416407864998736},8.972092687327321E-2,5.9999999999999984E-2]
[]
[null,null,"Ratio (named in function)",{"$f":"$D$25/$D$24","v":0.2},{"$f":"$C$4/$C$3","v":0.2},0.2,0.2,0.2]
[null,null,"Numerator - number from 1",null,{"$f":"E11-$B$3","v":1},{"$f":"F11-$B$3","v":2},3,4]
[null,null,"Total (Cols - 1)",null,{"$f":"($B$4-$B$3)","v":4},{"$f":"($B$4-$B$3)","v":4},4,4]
[null,null,"Factor",null,{"$f":"E33^(E34/E35)","v":0.66874030497642201},{"$f":"F33^(F34/F35)","v":0.44721359549995793},0.29906975624424414,0.2]
[]
[null,null,"Value - Initial x Factor",{"$f":"D31","v":0.3},{"$f":"$D$38*E36","v":0.20062209149292659},{"$f":"$D$38*F36","v":0.13416407864998736},8.9720926873273238E-2,0.06]
[]
[null,null,"Interpolate Proof",{"$f":"interpolate_look_up(D11,$B:$B,$C:$C)","v":0.3},{"$f":"interpolate_look_up(E11,$B:$B,$C:$C)","v":0.20062209149292659},{"$f":"interpolate_look_up(F11,$B:$B,$C:$C)","v":0.13416407864998736},{"$f":"interpolate_look_up(G11,$B:$B,$C:$C)","v":8.9720926873273238E-2},{"$f":"interpolate_look_up(H11,$B:$B,$C:$C)","v":0.06}]
[]
[]
[]
["Simple Example"]
[null,null,null,100,null,null,null,130]
[]
[null,null,"Ratio",{"$f":"($H$45/$D$45)","v":1.3},{"$f":"($H$45/$D$45)","v":1.3},1.3,1.3,1.3]
[]
[null,null,"Growth",{"$f":"D47^(1/4)-1","v":6.7789972372440888E-2},{"$f":"E47^(1/4)-1","v":6.7789972372440888E-2},6.7789972372440888E-2,6.7789972372440888E-2,6.7789972372440888E-2]
[null,null,"Growth Value",100,{"$f":"D50*(1+E49)","v":106.77899723724408},{"$f":"E50*(1+F49)","v":114.01754250991381},{"$f":"F50*(1+G49)","v":121.74678856663446},{"$f":"G50*(1+H49)","v":130.00000000000003}]
[]
[null,null,"Compound Growth",1,{"$f":"D52*(1+E49)","v":1.0677899723724409},{"$f":"E52*(1+F49)","v":1.1401754250991381},1.2174678856663446,1.3]
[]
[null,null,"Numerator",0,{"$f":"D54+1","v":1},{"$f":"E54+1","v":2},3,4]
[null,null,"Denominator",{"$f":"$H$54-$D$54","v":4},{"$f":"$H$54-$D$54","v":4},4,4,4]
[]
[null,null,"Combined with Power",{"$f":"D52","v":1},{"$f":"E47^(E54/E55)","v":1.0677899723724409},{"$f":"F47^(F54/F55)","v":1.1401754250991381},1.2174678856663446,1.3]
[]
[null,null,"Compound Value",{"$f":"D50","v":100},{"$f":"$D$59*E57","v":106.77899723724408},{"$f":"$D$59*F57","v":114.01754250991381},121.74678856663445,130]

{"sheet":"Demonstration 3","index":2,"n_rows":19,"n_cols":306,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,"Instructions at www.edbodmer.com\t",null,null,null,"Questions: e-mail edwardbodmer@gmail.com"]
[null,null,"Date","Discount Rate"]
[null,"Development","2016-01-01",0.2]
[null,"FC",{"$f":"EDATE(C3,15)","v":"2017-04-01"},0.15]
[null,"COD",{"$f":"EDATE(C4,13)","v":"2018-05-01"},0.12]
[null,"History",{"$f":"EDATE(C5,36)","v":"2021-05-01"},0.08]
[null,"Death",{"$f":"EDATE(C5,25*12)","v":"2043-05-01"},{"$f":"D6","v":0.08}]
[]
[null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300]
[null,"Timeline",null,null,null,null,{"$f":"C3","v":"2016-01-01"},{"$f":"EDATE(G10,1)","v":"2016-02-01"},{"$f":"EDATE(H10,1)","v":"2016-03-01"},"2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01","2017-01-01","2017-02-01","2017-03-01","2017-04-01","2017-05-01","2017-06-01","2017-07-01","2017-08-01","2017-09-01","2017-10-01","2017-11-01","2017-12-01","2018-01-01","2018-02-01","2018-03-01","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","2020-01-01","2020-02-01","2020-03-01","2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01",{"$f":"EDATE(BT10,1)","v":"2021-07-01"},"2021-08-01","2021-09-01","2021-10-01","2021-11-01","2021-12-01","2022-01-01","2022-02-01","2022-03-01","2022-04-01","2022-05-01","2022-06-01","2022-07-01","2022-08-01","2022-09-01","2022-10-01","2022-11-01","2022-12-01","2023-01-01","2023-02-01","2023-03-01","2023-04-01","2023-05-01","2023-06-01","2023-07-01","2023-08-01","2023-09-01","2023-10-01","2023-11-01","2023-12-01","2024-01-01","2024-02-01","2024-03-01","2024-04-01","2024-05-01","2024-06-01","2024-07-01","2024-08-01","2024-09-01","2024-10-01","2024-11-01","2024-12-01","2025-01-01","2025-02-01","2025-03-01","2025-04-01","2025-05-01","2025-06-01","2025-07-01","2025-08-01","2025-09-01","2025-10-01","2025-11-01","2025-12-01","2026-01-01","2026-02-01","2026-03-01","2026-04-01","2026-05-01","2026-06-01","2026-07-01","2026-08-01","2026-09-01","2026-10-01",{"$f":"EDATE(EF10,1)","v":"2026-11-01"},"2026-12-01","2027-01-01","2027-02-01","2027-03-01","2027-04-01","2027-05-01","2027-06-01","2027-07-01","2027-08-01","2027-09-01","2027-10-01","2027-11-01","2027-12-01","2028-01-01","2028-02-01","2028-03-01","2028-04-01","2028-05-01","2028-06-01","2028-07-01","2028-08-01","2028-09-01","2028-10-01","2028-11-01","2028-12-01","2029-01-01","2029-02-01","2029-03-01","2029-04-01","2029-05-01","2029-06-01","2029-07-01","2029-08-01","2029-09-01","2029-10-01","2029-11-01","2029-12-01","2030-01-01","2030-02-01","2030-03-01","2030-04-01","2030-05-01","2030-06-01","2030-07-01","2030-08-01","2030-09-01","2030-10-01","2030-11-01","2030-12-01","2031-01-01","2031-02-01","2031-03-01","2031-04-01","2031-05-01","2031-06-01","2031-07-01","2031-08-01","2031-09-01","2031-10-01","2031-11-01","2031-12-01","2032-01-01","2032-02-01",{"$f":"EDATE(GR10,1)","v":"2032-03-01"},"2032-04-01","2032-05-01","2032-06-01","2032-07-01","2032-08-01","2032-09-01","2032-10-01","2032-11-01","2032-12-01","2033-01-01","2033-02-01","2033-03-01","2033-04-01","2033-05-01","2033-06-01","2033-07-01","2033-08-01","2033-09-01","2033-10-01","2033-11-01","2033-12-01","2034-01-01","2034-02-01","2034-03-01","2034-04-01","2034-05-01","2034-06-01","2034-07-01","2034-08-01","2034-09-01","2034-10-01","2034-11-01","2034-12-01","2035-01-01","2035-02-01","2035-03-01","2035-04-01","2035-05-01","2035-06-01","2035-07-01","2035-08-01","2035-09-01","2035-10-01","2035-11-01","2035-12-01","2036-01-01","2036-02-01","2036-03-01","2036-04-01","2036-05-01","2036-06-01","2036-07-01","2036-08-01","2036-09-01","2036-10-01","2036-11-01","2036-12-01","2037-01-01","2037-02-01","2037-03-01","2037-04-01","2037-05-01","2037-06-01",{"$f":"EDATE(JD10,1)","v":"2037-07-01"},"2037-08-01","2037-09-01","2037-10-01","2037-11-01","2037-12-01","2038-01-01","2038-02-01","2038-03-01","2038-04-01","2038-05-01","2038-06-01","2038-07-01","2038-08-01","2038-09-01","2038-10-01","2038-11-01","2038-12-01","2039-01-01","2039-02-01","2039-03-01","2039-04-01","2039-05-01","2039-06-01","2039-07-01","2039-08-01","2039-09-01","2039-10-01","2039-11-01","2039-12-01","2040-01-01","2040-02-01","2040-03-01","2040-04-01","2040-05-01","2040-06-01","2040-07-01","2040-08-01","2040-09-01","2040-10-01","2040-11-01","2040-12-01"]
[null,"Development",null,null,{"$f":"C3","v":"2016-01-01"},{"$f":"C4","v":"2017-04-01"},{"$f":"AND(G$10>=$E11,G$10<$F11)","v":true},true,true,true,true,true,true,true,true,true,{"$f":"AND(Q$10>=$E11,Q$10<$F11)","v":true},true,true,true,true,false,false,false,false,false,{"$f":"AND(AA$10>=$E11,AA$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(AK$10>=$E11,AK$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(AU$10>=$E11,AU$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(BE$10>=$E11,BE$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(BO$10>=$E11,BO$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(BY$10>=$E11,BY$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(CI$10>=$E11,CI$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(CS$10>=$E11,CS$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(DC$10>=$E11,DC$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(DM$10>=$E11,DM$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(DW$10>=$E11,DW$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(EG$10>=$E11,EG$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(EQ$10>=$E11,EQ$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(FA$10>=$E11,FA$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(FK$10>=$E11,FK$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(FU$10>=$E11,FU$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(GE$10>=$E11,GE$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(GO$10>=$E11,GO$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(GY$10>=$E11,GY$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(HI$10>=$E11,HI$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(HS$10>=$E11,HS$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(IC$10>=$E11,IC$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(IM$10>=$E11,IM$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(IW$10>=$E11,IW$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(JG$10>=$E11,JG$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(JQ$10>=$E11,JQ$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(KA$10>=$E11,KA$10<$F11)","v":false},false,false,false,false,false,false,false,false,false,{"$f":"AND(KK$10>=$E11,KK$10<$F11)","v":false},false,false,false,false,false,false,false,false,false]
[null,{"$f":"B4","v":"FC"},null,null,{"$f":"C4","v":"2017-04-01"},{"$f":"C5","v":"2018-05-01"},false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,true,true,true,true,true,true,true,true,true,true,true,true,true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,{"$f":"B5","v":"COD"},null,null,{"$f":"C5","v":"2018-05-01"},{"$f":"C6","v":"2021-05-01"},false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,{"$f":"B6","v":"History"},null,null,{"$f":"C6","v":"2021-05-01"},{"$f":"C7","v":"2043-05-01"},false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true]
[]
[null,"Lookup",null,null,null,null,{"$f":"LOOKUP(G10,$C:$C,$D:$D)","v":0.2},{"$f":"LOOKUP(H10,$C:$C,$D:$D)","v":0.2},0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.08,{"$f":"LOOKUP(BT10,$C:$C,$D:$D)","v":0.08},0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,{"$f":"LOOKUP(EF10,$C:$C,$D:$D)","v":0.08},0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,{"$f":"LOOKUP(GR10,$C:$C,$D:$D)","v":0.08},0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,{"$f":"LOOKUP(JD10,$C:$C,$D:$D)","v":0.08},0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,"Lookup Interpolate",null,null,null,null,{"$f":"interpolate_look_up(G10,$C:$C,$D:$D)","v":0.2},{"$f":"interpolate_look_up(H10,$C:$C,$D:$D)","v":0.19612653402161825},0.19257091245394856,0.18884132806486706,0.18530084181591111,0.18171205928321399,0.17830523592651371,0.17485193960087031,0.17146552440438012,0.16825080791437963,0.16499223901292165,0.16189888672931008,0.15876333758089076,0.15568851564722117,0.15296247470876745,0.15,0.14747927871219785,0.14491902682226235,0.14248369031613939,0.14001016223407731,0.13757957479426822,0.13526757637459702,0.13291932059870673,0.13068563685875098,0.12841692391360579,0.12618759600381096,0.12420729282205512,0.12205104443944666,0.12,0.11863164774752288,0.11732229407274472,0.11598447552807621,0.11466191204189938,0.11339637288148351,0.11210332136269091,0.11086602171653354,0.10960182362870857,0.10835204111005906,0.10723545900789279,0.10601265999223557,0.104842583806248,0.10364707059202467,0.10250310373885843,0.10133426746480041,0.10017875935531226,9.9073072726262368E-2,9.794334887438895E-2,9.686233477567481E-2,9.5757819825920756E-2,9.4665899588828289E-2,9.365570065524452E-2,9.25877507473368E-2,9.1565847115529564E-2,9.0521727672608659E-2,8.9522627019234538E-2,8.850180628315589E-2,8.749262590002381E-2,8.6526957856012526E-2,8.5540296541993632E-2,8.4596176623359096E-2,8.3631531883079716E-2,8.2677886924493682E-2,8.1825880374002916E-2,8.0892825142997171E-2,0.08,{"$f":"interpolate_look_up(BT10,$C:$C,$D:$D)","v":0.08},0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,{"$f":"interpolate_look_up(EF10,$C:$C,$D:$D)","v":0.08},0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,{"$f":"interpolate_look_up(GR10,$C:$C,$D:$D)","v":0.08},0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,{"$f":"interpolate_look_up(JD10,$C:$C,$D:$D)","v":0.08},0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,"Lookup Linear",null,null,null,null,{"$f":"interpolate_look_up_linear(G10,$C$3:$C$7,$D$3:$D$7)","v":0.2},{"$f":"interpolate_look_up_linear(H10,$C$3:$C$7,$D$3:$D$7)","v":0.19660087719298247},0.19342105263157897,0.1900219298245614,0.18673245614035089,0.18333333333333335,0.18004385964912281,0.17664473684210527,0.17324561403508773,0.16995614035087719,0.16655701754385965,0.16326754385964912,0.15986842105263158,0.15646929824561404,0.15339912280701753,0.15,0.14772151898734176,0.14536708860759492,0.14308860759493672,0.14073417721518988,0.13837974683544305,0.13610126582278481,0.13374683544303798,0.13146835443037974,0.12911392405063291,0.12675949367088607,0.12463291139240507,0.12227848101265823,0.12,0.11886861313868613,0.11777372262773722,0.11664233576642336,0.11551094890510949,0.11441605839416058,0.11328467153284671,0.11218978102189781,0.11105839416058394,0.10992700729927007,0.10890510948905109,0.10777372262773723,0.10667883211678832,0.10554744525547445,0.10445255474452554,0.10332116788321168,0.10218978102189781,0.1010948905109489,9.9963503649635035E-2,9.8868613138686126E-2,9.7737226277372261E-2,9.6605839416058395E-2,9.5547445255474456E-2,9.441605839416059E-2,9.3321167883211681E-2,9.2189781021897815E-2,9.1094890510948906E-2,8.996350364963504E-2,8.8832116788321175E-2,8.7737226277372266E-2,8.66058394160584E-2,8.5510948905109491E-2,8.4379562043795625E-2,8.324817518248176E-2,8.2226277372262763E-2,8.1094890510948897E-2,0.08,{"$f":"interpolate_look_up_linear(BT10,$C$3:$C$7,$D$3:$D$7)","v":0.08},0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,{"$f":"interpolate_look_up_linear(EF10,$C$3:$C$7,$D$3:$D$7)","v":0.08},0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,{"$f":"interpolate_look_up_linear(GR10,$C$3:$C$7,$D$3:$D$7)","v":0.08},0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,{"$f":"interpolate_look_up_linear(JD10,$C$3:$C$7,$D$3:$D$7)","v":0.08},0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,"Look up adjusted",null,null,null,null,{"$f":"interpolate_look_up_adjusted(G10,$C$3:$C$7,$D$3:$D$7)","v":0.2},{"$f":"interpolate_look_up_adjusted(H10,$C$3:$C$7,$D$3:$D$7)","v":0.19660087719298247},0.19342105263157897,0.1900219298245614,0.18673245614035089,0.18333333333333335,0.18004385964912281,0.17664473684210527,0.17324561403508773,0.16995614035087719,0.16655701754385965,0.16326754385964912,0.15986842105263158,0.15646929824561404,0.15339912280701753,0.15,0.14772151898734176,0.14536708860759492,0.14308860759493672,0.14073417721518988,0.13837974683544305,0.13610126582278481,0.13374683544303798,0.13146835443037974,0.12911392405063291,0.12675949367088607,0.12463291139240507,0.12227848101265823,0.12,0.11886861313868613,0.11777372262773722,0.11664233576642336,0.11551094890510949,0.11441605839416058,0.11328467153284671,0.11218978102189781,0.11105839416058394,0.10992700729927007,0.10890510948905109,0.10777372262773723,0.10667883211678832,0.10554744525547445,0.10445255474452554,0.10332116788321168,0.10218978102189781,0.1010948905109489,9.9963503649635035E-2,9.8868613138686126E-2,9.7737226277372261E-2,9.6605839416058395E-2,9.5547445255474456E-2,9.441605839416059E-2,9.3321167883211681E-2,9.2189781021897815E-2,9.1094890510948906E-2,8.996350364963504E-2,8.8832116788321175E-2,8.7737226277372266E-2,8.66058394160584E-2,8.5510948905109491E-2,8.4379562043795625E-2,8.324817518248176E-2,8.2226277372262763E-2,8.1094890510948897E-2,0.08,{"$f":"interpolate_look_up_adjusted(BT10,$C$3:$C$7,$D$3:$D$7)","v":0.08},0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,{"$f":"interpolate_look_up_adjusted(EF10,$C$3:$C$7,$D$3:$D$7)","v":0.08},0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,{"$f":"interpolate_look_up_adjusted(GR10,$C$3:$C$7,$D$3:$D$7)","v":0.08},0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,{"$f":"interpolate_look_up_adjusted(JD10,$C$3:$C$7,$D$3:$D$7)","v":0.08},0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]

{"sheet":"Linear","index":3,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,null,"Instructions at www.edbodmer.com\t",null,null,null,"Questions: e-mail edwardbodmer@gmail.com"]
[null,null,null,1,5,8]
[null,null,null,100,200,300]
[]
[null,"Value",3]
[null,{"$f":"show_formula(C6)","v":"=interpolate_look_up_linear(C5,D2:F2,D3:F3)"},{"$f":"interpolate_look_up_linear(C5,D2:F2,D3:F3)","v":150}]
[]
[]
[null,"Value",143]
[null,{"$f":"_xlfn.FORMULATEXT(C10)","v":"=interpolate_look_up_linear(C9,D3:F3,D2:F2)"},{"$f":"interpolate_look_up_linear(C9,D3:F3,D2:F2)","v":2.7199999999999998}]
[]
[]
[]
[null,"Declining Series (Reverse)",null,300,200,100]
[null,null,null,1,5,8]
[]
[]
[null,"value",150]
[null,{"$f":"_xlfn.FORMULATEXT(C19)","v":"=interpolate_look_up_reverse(C18,D14:F14,D15:F15)"},{"$f":"interpolate_look_up_reverse(C18,D14:F14,D15:F15)","v":0.5}]
[null,null,{"$f":"AVERAGE(E15:F15)","v":6.5}]
[]
[null,"value",270]
[null,{"$f":"_xlfn.FORMULATEXT(C23)","v":"=interpolate_look_up_reverse(C22,D14:F14,D15:F15)"},{"$f":"interpolate_look_up_reverse(C22,D14:F14,D15:F15)","v":0.9}]
[]
[null,"value",3]
[]
[null,null,null,4.9234999999999998,4.0419999999999998,2.9209999999999998,1.9209999999999998]
[null,null,null,1,2,3,4]
[]
[null,null,3.5]
[null,null,{"$f":"interpolate_look_up_reverse(C30,D27:G27,D28:G28)","v":0.71087640905859661}]

{"sheet":"Full Row Test","index":4,"n_rows":9,"n_cols":304,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"Instructions at www.edbodmer.com\t",null,null,null,"Questions: e-mail edwardbodmer@gmail.com"]
[null,null,null,null,1,5,10,20]
[null,null,null,"Debt to Cap",0.6,0.4,0.3,0.25]
[]
[null,null,null,"Year",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300]
[]
[null,null,null,"Interpolate Lookup",{"$f":"interpolate_look_up(E5,2:2,3:3)","v":0.6},{"$f":"interpolate_look_up(F5,2:2,3:3)","v":0.54216120216590691},0.4898979485566356,0.4426727678801286,0.4,0.37763500451796084,0.35652049159320065,0.33658654363385981,0.3177671523146437,0.3,0.29457991336857381,0.28925775120078817,0.28403174429972217,0.27890015543245689,0.27386127875258304,0.26891343923314254,0.26405499210981453,0.25928432233416204,0.25459984403675606,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,{"$f":"interpolate_look_up(BQ5,2:2,3:3)","v":0.25},0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,{"$f":"interpolate_look_up(EC5,2:2,3:3)","v":0.25},0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,{"$f":"interpolate_look_up(GO5,2:2,3:3)","v":0.25},0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,{"$f":"interpolate_look_up(JA5,2:2,3:3)","v":0.25},0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
[null,null,null,"Interpolate Lookup Linear",{"$f":"interpolate_look_up_linear(E5,2:2,3:3)","v":0.6},0.55000000000000004,0.5,0.45,0.4,0.38,0.36,0.33999999999999997,0.32,0.3,0.29499999999999998,0.28999999999999998,0.28499999999999998,0.27999999999999997,0.27500000000000002,0.27,0.26500000000000001,0.26,0.255,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,{"$f":"interpolate_look_up_linear(BQ5,2:2,3:3)","v":0.25},0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,{"$f":"interpolate_look_up_linear(EC5,2:2,3:3)","v":0.25},0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,{"$f":"interpolate_look_up_linear(GO5,2:2,3:3)","v":0.25},0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,{"$f":"interpolate_look_up_linear(JA5,2:2,3:3)","v":0.25},0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
[null,null,null,"Interpolate Lookup Adjusted",{"$f":"interpolate_look_up_adjusted(E5,2:2,3:3)","v":0.6},0.55000000000000004,0.5,0.45,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,{"$f":"interpolate_look_up_adjusted(BQ5,2:2,3:3)","v":0.25},0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,{"$f":"interpolate_look_up_adjusted(EC5,2:2,3:3)","v":0.25},0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,{"$f":"interpolate_look_up_adjusted(GO5,2:2,3:3)","v":0.25},0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,{"$f":"interpolate_look_up_adjusted(JA5,2:2,3:3)","v":0.25},0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]

{"sheet":"Basic","index":5,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"Instructions at www.edbodmer.com\t",null,null,null,"Questions: e-mail edwardbodmer@gmail.com"]
[]
[]
[null,null,null,1,7]
[null,null,null,2,4]
[]
[]
[]
[null,null,null,1,2,3,4,5,6,7,8,9,10]
[]
[null,"Lookup",null,{"$f":"LOOKUP(D9,4:4,5:5)","v":2},2,2,2,2,2,4,4,4,4]
[]
[null,"Average Lookup",null,{"$f":"look_up_average(D9,4:4,5:5)","v":150},2,2,2,2,2,150,4,4,4]
[]
[null,"Long lookup",null,{"$f":"long_look_up(D9,4:4,5:5)","v":2},2,2,2,2,2,4,4,4,4]
[]
[null,"Basic Lookup",null,{"$f":"basic_look_up(D9,$D$4:$G$4,$D$5:$G$5)","v":2},{"$f":"basic_look_up(E9,$D$4:$G$4,$D$5:$G$5)","v":2},2,2,2,2,0,0,{"$f":"basic_look_up(L9,$D$4:$G$4,$D$5:$G$5)","v":0},{"$f":"basic_look_up(M9,$D$4:$G$4,$D$5:$G$5)","v":0}]

{"sheet":"Full Column Demonstration","index":6,"n_rows":212,"n_cols":12,"rows_kept":212,"cut":false,"hidden":false,"merged":[]}
[null,null,"Base Value",100]
[null,null,"Growth",5.0000000000000001E-3]
[null,null,"Vol",0.03]
[]
[null,null,null,"Value",null,"Avg","Lookup",null,"Avg","Moving"]
[null,null,null,null,{"$f":"C7","v":"2016-01-01"},{"$f":"D7","v":100},{"$f":"F6","v":100},null,"Lookup","Interpolate Lookup"]
[null,{"$f":"EOMONTH(C7,0)","v":"2016-01-31"},"2016-01-01",100,{"$f":"B7","v":"2016-01-31"},{"$f":"AVERAGEIF(B:B,E7,D:D)","v":123.92418766138421},{"$f":"LOOKUP(E7,C:C,D:D)","v":144.35384913179001},null,{"$f":"LOOKUP(B7,E:E,F:F)","v":123.92418766138421},{"$f":"interpolate_look_up(C7,E:E,G:G)","v":100},{"$f":"LOOKUP(C7,E:E,F:F)","v":100}]
[null,{"$f":"EOMONTH(C8,0)","v":"2016-01-31"},{"$f":"C7+1","v":"2016-01-02"},97.669781864740386,{"$f":"EOMONTH(E7,1)","v":"2016-02-29"},141.90543490163921,131.76692762001156,null,123.92418766138421,101.23117527483552,100]
[null,"2016-01-31",{"$f":"C8+1","v":"2016-01-03"},101.81971228439593,{"$f":"EOMONTH(E8,1)","v":"2016-03-31"},148.96996860397661,166.08926587005939,null,123.92418766138421,102.47750847524469,100]
[null,"2016-01-31","2016-01-04",102.02622664972714,"2016-04-30",180.9877602013249,195.00106863683376,null,123.92418766138421,103.73918622185936,100]
[null,"2016-01-31","2016-01-05",104.55140836990961,"2016-05-31",212.31353351533471,247.10315002269996,null,123.92418766138421,105.01639743293848,100]
[null,"2016-01-31","2016-01-06",106.29672425264199,"2016-06-30",226.96413138183701,207.78586266450463,null,123.92418766138421,106.3093333526558,100]
[null,"2016-01-31","2016-01-07",111.99034689977731,"2016-07-31",215.30666459938266,195.54188740551538,null,123.92418766138421,107.61818757973616,100]
[null,"2016-01-31","2016-01-08",108.61344654274686,null,null,null,null,123.92418766138421,108.94315609644399,100]
[null,"2016-01-31","2016-01-09",111.0374812793636,null,null,null,null,123.92418766138421,110.28443729792885,100,{"$f":"show_formula(J15)","v":"=interpolate_look_up(C15,E:E,G:G)"}]
[null,"2016-01-31","2016-01-10",109.76681791572578,null,null,null,null,123.92418766138421,111.64223202193241,100]
[null,"2016-01-31","2016-01-11",114.07719192099879,null,null,null,null,123.92418766138421,113.01674357886095,100]
[null,"2016-01-31","2016-01-12",110.02844826296761,null,null,null,null,123.92418766138421,114.40817778222814,100]
[null,"2016-01-31","2016-01-13",114.6928497976505,null,null,null,null,123.92418766138421,115.81674297947278,100]
[null,"2016-01-31","2016-01-14",114.89957218030014,null,null,null,null,123.92418766138421,117.24265008315584,100]
[null,"2016-01-31","2016-01-15",115.40136297117486,null,null,null,null,123.92418766138421,118.68611260254158,100]
[null,"2016-01-31","2016-01-16",117.90374922123287,null,null,null,null,123.92418766138421,120.1473466755675,100]
[null,"2016-01-31","2016-01-17",120.0685322120916,null,null,null,null,123.92418766138421,121.626571101208,100]
[null,"2016-01-31","2016-01-18",128.93712950717776,null,null,null,null,123.92418766138421,123.12400737223629,100]
[null,"2016-01-31","2016-01-19",132.1292428609388,null,null,null,null,123.92418766138421,124.63987970838993,100]
[null,"2016-01-31","2016-01-20",128.41503526629302,null,null,null,null,123.92418766138421,126.17441508994433,100]
[null,"2016-01-31","2016-01-21",141.50935687048766,null,null,null,null,123.92418766138421,127.72784329170005,100]
[null,"2016-01-31","2016-01-22",142.86807891015494,null,null,null,null,123.92418766138421,129.30039691738813,100]
[null,"2016-01-31","2016-01-23",141.79921369187909,null,null,null,null,123.92418766138421,130.89231143449919,100]
[null,"2016-01-31","2016-01-24",140.84302333225784,null,null,null,null,123.92418766138421,132.50382520954145,100]
[null,"2016-01-31","2016-01-25",143.72151396924542,null,null,null,null,123.92418766138421,134.13517954373256,100]
[null,"2016-01-31","2016-01-26",143.79686083352081,null,null,null,null,123.92418766138421,135.78661870913123,100]
[null,"2016-01-31","2016-01-27",150.96955403005882,null,null,null,null,123.92418766138421,137.45838998521322,100]
[null,"2016-01-31","2016-01-28",146.75857293639012,null,null,null,null,123.92418766138421,139.15074369589814,100]
[null,"2016-01-31","2016-01-29",150.0943865313231,null,null,null,null,123.92418766138421,140.86393324703178,100]
[null,"2016-01-31","2016-01-30",144.61034700594789,null,null,null,null,123.92418766138421,142.59821516433004,100]
[null,"2016-01-31","2016-01-31",144.35384913179001,null,null,null,null,123.92418766138421,144.35384913179001,123.92418766138421]
[null,"2016-02-29","2016-02-01",144.12940469525023,null,null,null,null,141.90543490163921,143.9004309454931,123.92418766138421]
[null,"2016-02-29","2016-02-02",148.96568484280314,null,null,null,null,141.90543490163921,143.44843695434514,123.92418766138421]
[null,"2016-02-29","2016-02-03",147.83074020589942,null,null,null,null,141.90543490163921,142.99786268492204,123.92418766138421]
[null,"2016-02-29","2016-02-04",140.6282219346495,null,null,null,null,141.90543490163921,142.54870367785088,123.92418766138421]
[null,"2016-02-29","2016-02-05",138.88818059968654,null,null,null,null,141.90543490163921,142.10095548776573,123.92418766138421]
[null,"2016-02-29","2016-02-06",139.18074112477532,null,null,null,null,141.90543490163921,141.65461368326353,123.92418766138421]
[null,"2016-02-29","2016-02-07",139.01466725700254,null,null,null,null,141.90543490163921,141.20967384686043,123.92418766138421]
[null,"2016-02-29","2016-02-08",142.1133494609368,null,null,null,null,141.90543490163921,140.76613157494796,123.92418766138421]
[null,"2016-02-29","2016-02-09",146.24272805307126,null,null,null,null,141.90543490163921,140.3239824777495,123.92418766138421]
[null,"2016-02-29","2016-02-10",145.73545825588127,null,null,null,null,141.90543490163921,139.88322217927671,123.92418766138421]
[null,"2016-02-29","2016-02-11",141.66662223232913,null,null,null,null,141.90543490163921,139.44384631728644,123.92418766138421]
[null,"2016-02-29","2016-02-12",148.15957891820162,null,null,null,null,141.90543490163921,139.0058505432373,123.92418766138421]
[null,"2016-02-29","2016-02-13",146.37984201836485,null,null,null,null,141.90543490163921,138.56923052224684,123.92418766138421]
[null,"2016-02-29","2016-02-14",150.92741817311241,null,null,null,null,141.90543490163921,138.13398193304855,123.92418766138421]
[null,"2016-02-29","2016-02-15",147.94078285298832,null,null,null,null,141.90543490163921,137.70010046794906,123.92418766138421]
[null,"2016-02-29","2016-02-16",143.29938577010245,null,null,null,null,141.90543490163921,137.26758183278554,123.92418766138421]
[null,"2016-02-29","2016-02-17",143.04126685195885,null,null,null,null,141.90543490163921,136.83642174688327,123.92418766138421]
[null,"2016-02-29","2016-02-18",148.58283928945946,null,null,null,null,141.90543490163921,136.40661594301318,123.92418766138421]
[null,"2016-02-29","2016-02-19",150.34023882922196,null,null,null,null,141.90543490163921,135.97816016734961,123.92418766138421]
[null,"2016-02-29","2016-02-20",149.20575563782563,null,null,null,null,141.90543490163921,135.55105017942833,123.92418766138421]
[null,"2016-02-29","2016-02-21",144.73575016103183,null,null,null,null,141.90543490163921,135.1252817521044,123.92418766138421]
[null,"2016-02-29","2016-02-22",141.67609781013681,null,null,null,null,141.90543490163921,134.70085067151047,123.92418766138421]
[null,"2016-02-29","2016-02-23",135.95558227691762,null,null,null,null,141.90543490163921,134.27775273701502,123.92418766138421]
[null,"2016-02-29","2016-02-24",129.39847743059681,null,null,null,null,141.90543490163921,133.85598376118079,123.92418766138421]
[null,"2016-02-29","2016-02-25",129.74827629502559,null,null,null,null,141.90543490163921,133.43553956972337,123.92418766138421]
[null,"2016-02-29","2016-02-26",131.81812247617879,null,null,null,null,141.90543490163921,133.01641600146979,123.92418766138421]
[null,"2016-02-29","2016-02-27",132.79895134648882,null,null,null,null,141.90543490163921,132.59860890831746,123.92418766138421]
[null,"2016-02-29","2016-02-28",135.086519727628,null,null,null,null,141.90543490163921,132.18211415519303,123.92418766138421]
[null,"2016-02-29","2016-02-29",131.76692762001156,null,null,null,null,141.90543490163921,131.76692762001156,141.90543490163921]
[null,"2016-03-31","2016-03-01",134.53182381924017,null,null,null,null,148.96996860397661,132.75457262176414,141.90543490163921]
[null,"2016-03-31","2016-03-02",133.03932252387543,null,null,null,null,148.96996860397661,133.7496204116602,141.90543490163921]
[null,"2016-03-31","2016-03-03",132.16223718403211,null,null,null,null,148.96996860397661,134.75212647651151,141.90543490163921]
[null,"2016-03-31","2016-03-04",131.24195664838132,null,null,null,null,148.96996860397661,135.76214671902528,141.90543490163921]
[null,"2016-03-31","2016-03-05",129.21599354904629,null,null,null,null,{"$f":"LOOKUP(B71,E:E,F:F)","v":148.96996860397661},{"$f":"interpolate_look_up(C71,E:E,G:G)","v":136.77973746092158},{"$f":"LOOKUP(C71,E:E,F:F)","v":141.90543490163921}]
[null,{"$f":"EOMONTH(C72,0)","v":"2016-03-31"},"2016-03-06",130.96678934019766,null,null,null,null,148.96996860397661,137.80495544607399,141.90543490163921]
[null,"2016-03-31",{"$f":"C72+1","v":"2016-03-07"},134.75164771192038,null,null,null,null,148.96996860397661,138.83785784367365,141.90543490163921]
[null,"2016-03-31","2016-03-08",131.98258161409561,null,null,null,null,148.96996860397661,139.87850225141742,141.90543490163921]
[null,"2016-03-31","2016-03-09",135.25721994275835,null,null,null,null,148.96996860397661,140.92694669871943,141.90543490163921]
[null,"2016-03-31","2016-03-10",135.38456419738,null,null,null,null,148.96996860397661,141.98324964994728,141.90543490163921]
[null,"2016-03-31","2016-03-11",140.88934159735712,null,null,null,null,148.96996860397661,143.04747000768188,141.90543490163921]
[null,"2016-03-31","2016-03-12",141.20184374037146,null,null,null,null,148.96996860397661,144.11966711600229,141.90543490163921]
[null,"2016-03-31","2016-03-13",134.85468212621703,null,null,null,null,148.96996860397661,145.19990076379474,141.90543490163921]
[null,"2016-03-31","2016-03-14",142.92479887932205,null,null,null,null,148.96996860397661,146.28823118808668,141.90543490163921]
[null,"2016-03-31","2016-03-15",141.68634936835937,null,null,null,null,148.96996860397661,147.38471907740586,141.90543490163921]
[null,"2016-03-31","2016-03-16",142.69999994925752,null,null,null,null,148.96996860397661,148.4894255751644,141.90543490163921]
[null,"2016-03-31","2016-03-17",146.57164219352342,null,null,null,null,148.96996860397661,149.60241228306845,141.90543490163921]
[null,"2016-03-31","2016-03-18",151.96421334977225,null,null,null,null,148.96996860397661,150.72374126455304,141.90543490163921]
[null,"2016-03-31","2016-03-19",154.88418080993091,null,null,null,null,148.96996860397661,151.85347504824321,141.90543490163921]
[null,"2016-03-31","2016-03-20",156.76427779659051,null,null,null,null,148.96996860397661,152.99167663144064,141.90543490163921]
[null,"2016-03-31","2016-03-21",164.48566916664987,null,null,null,null,148.96996860397661,154.13840948363656,141.90543490163921]
[null,"2016-03-31","2016-03-22",161.95812242446195,null,null,null,null,148.96996860397661,155.29373755005108,141.90543490163921]
[null,"2016-03-31","2016-03-23",159.38050107132682,null,null,null,null,148.96996860397661,156.4577252551988,141.90543490163921]
[null,"2016-03-31","2016-03-24",163.65944140283116,null,null,null,null,148.96996860397661,157.63043750648157,141.90543490163921]
[null,"2016-03-31","2016-03-25",168.10576555284922,null,null,null,null,148.96996860397661,158.81193969780765,141.90543490163921]
[null,"2016-03-31","2016-03-26",171.04360106302991,null,null,null,null,148.96996860397661,160.00229771323848,141.90543490163921]
[null,"2016-03-31","2016-03-27",171.53905927202038,null,null,null,null,148.96996860397661,161.20157793066241,141.90543490163921]
[null,"2016-03-31","2016-03-28",174.41461568416608,null,null,null,null,148.96996860397661,162.40984722549621,141.90543490163921]
[null,"2016-03-31","2016-03-29",166.78191018481249,null,null,null,null,148.96996860397661,163.62717297441426,141.90543490163921]
[null,"2016-03-31","2016-03-30",167.6356086894364,null,null,null,null,148.96996860397661,164.85362305910564,141.90543490163921]
[null,"2016-03-31","2016-03-31",166.08926587005939,null,null,null,null,148.96996860397661,166.08926587005939,148.96996860397661]
[null,"2016-04-30","2016-04-01",159.29407230070964,null,null,null,null,180.9877602013249,166.98011135663481,148.96996860397661]
[null,"2016-04-30","2016-04-02",160.88415962057152,null,null,null,null,180.9877602013249,167.87573503087208,148.96996860397661]
[null,"2016-04-30","2016-04-03",164.25083930592848,null,null,null,null,180.9877602013249,168.7761625213204,148.96996860397661]
[null,"2016-04-30","2016-04-04",159.0368725897697,null,null,null,null,180.9877602013249,169.68141959399156,148.96996860397661]
[null,"2016-04-30","2016-04-05",162.5318461615631,null,null,null,null,180.9877602013249,170.59153215309743,148.96996860397661]
[null,"2016-04-30","2016-04-06",164.65906223677695,null,null,null,null,180.9877602013249,171.50652624179102,148.96996860397661]
[null,"2016-04-30","2016-04-07",168.54755483612234,null,null,null,null,180.9877602013249,172.42642804291202,148.96996860397661]
[null,"2016-04-30","2016-04-08",166.94549062782505,null,null,null,null,180.9877602013249,173.35126387973554,148.96996860397661]
[null,"2016-04-30","2016-04-09",165.1372599418643,null,null,null,null,180.9877602013249,174.28106021672596,148.96996860397661]
[null,"2016-04-30","2016-04-10",171.19208829891187,null,null,null,null,180.9877602013249,175.21584366029364,148.96996860397661]
[null,"2016-04-30","2016-04-11",177.62366230395097,null,null,null,null,180.9877602013249,176.15564095955676,148.96996860397661]
[null,"2016-04-30","2016-04-12",187.74614631759857,null,null,null,null,180.9877602013249,177.10047900710637,148.96996860397661]
[null,"2016-04-30","2016-04-13",183.21026435474417,null,null,null,null,180.9877602013249,178.0503848397762,148.96996860397661]
[null,"2016-04-30","2016-04-14",182.32251879302274,null,null,null,null,180.9877602013249,179.0053856394162,148.96996860397661]
[null,"2016-04-30","2016-04-15",181.81332210872984,null,null,null,null,180.9877602013249,179.96550873367033,148.96996860397661]
[null,"2016-04-30","2016-04-16",182.41194884135817,null,null,null,null,180.9877602013249,180.93078159675869,148.96996860397661]
[null,"2016-04-30","2016-04-17",184.35222698592545,null,null,null,null,180.9877602013249,181.90123185026354,148.96996860397661]
[null,"2016-04-30","2016-04-18",179.20003999209663,null,null,null,null,180.9877602013249,182.87688726391977,148.96996860397661]
[null,"2016-04-30","2016-04-19",179.45740043033726,null,null,null,null,180.9877602013249,183.85777575640961,148.96996860397661]
[null,"2016-04-30","2016-04-20",185.27346758914584,null,null,null,null,180.9877602013249,184.84392539616132,148.96996860397661]
[null,"2016-04-30","2016-04-21",190.75856714341447,null,null,null,null,180.9877602013249,185.83536440215269,148.96996860397661]
[null,"2016-04-30","2016-04-22",189.06846068747208,null,null,null,null,180.9877602013249,186.83212114471831,148.96996860397661]
[null,"2016-04-30","2016-04-23",190.34674228101267,null,null,null,null,180.9877602013249,187.83422414636141,148.96996860397661]
[null,"2016-04-30","2016-04-24",191.03864149273406,null,null,null,null,180.9877602013249,188.84170208257001,148.96996860397661]
[null,"2016-04-30","2016-04-25",195.40867913363411,null,null,null,null,180.9877602013249,189.85458378263777,148.96996860397661]
[null,"2016-04-30","2016-04-26",206.6972547364671,null,null,null,null,180.9877602013249,190.8728982304886,148.96996860397661]
[null,"2016-04-30","2016-04-27",204.5417261334554,null,null,null,null,180.9877602013249,191.89667456550609,148.96996860397661]
[null,"2016-04-30","2016-04-28",201.13236876768482,null,null,null,null,180.9877602013249,192.92594208336754,148.96996860397661]
[null,"2016-04-30","2016-04-29",199.74905339008603,null,null,null,null,180.9877602013249,193.96073023688217,148.96996860397661]
[null,"2016-04-30","2016-04-30",195.00106863683376,null,null,null,null,180.9877602013249,195.00106863683376,180.9877602013249]
[null,"2016-05-31","2016-05-01",200.79515516700158,null,null,null,null,212.31353351533471,196.49633405679688,180.9877602013249]
[null,"2016-05-31","2016-05-02",204.64089882070951,null,null,null,null,212.31353351533471,198.00306515072668,180.9877602013249]
[null,"2016-05-31","2016-05-03",207.09939890533838,null,null,null,null,212.31353351533471,199.52134983724798,180.9877602013249]
[null,"2016-05-31","2016-05-04",207.65835513582971,null,null,null,null,212.31353351533471,201.05127670914436,180.9877602013249]
[null,"2016-05-31","2016-05-05",205.5751916269264,null,null,null,null,212.31353351533471,202.59293503852771,180.9877602013249]
[null,"2016-05-31","2016-05-06",208.89114572084185,null,null,null,null,212.31353351533471,204.14641478204706,180.9877602013249]
[null,"2016-05-31","2016-05-07",203.2425354697007,null,null,null,null,212.31353351533471,205.71180658613787,180.9877602013249]
[null,"2016-05-31","2016-05-08",206.02193716006957,null,null,null,null,{"$f":"LOOKUP(B135,E:E,F:F)","v":212.31353351533471},{"$f":"interpolate_look_up(C135,E:E,G:G)","v":207.2892017923111},{"$f":"LOOKUP(C135,E:E,F:F)","v":180.9877602013249}]
[null,{"$f":"EOMONTH(C136,0)","v":"2016-05-31"},"2016-05-09",190.90792686529642,null,null,null,null,212.31353351533471,208.87869244248313,180.9877602013249]
[null,"2016-05-31",{"$f":"C136+1","v":"2016-05-10"},199.36852541153539,null,null,null,null,212.31353351533471,210.48037128434649,180.9877602013249]
[null,"2016-05-31","2016-05-11",195.36634886071852,null,null,null,null,212.31353351533471,212.09433177678164,180.9877602013249]
[null,"2016-05-31","2016-05-12",206.30023490499877,null,null,null,null,212.31353351533471,213.72066809531046,180.9877602013249]
[null,"2016-05-31","2016-05-13",212.42124763695324,null,null,null,null,212.31353351533471,215.35947513759135,180.9877602013249]
[null,"2016-05-31","2016-05-14",217.82533505802346,null,null,null,null,212.31353351533471,217.01084852895656,180.9877602013249]
[null,"2016-05-31","2016-05-15",215.2166402915615,null,null,null,null,212.31353351533471,218.67488462799213,180.9877602013249]
[null,"2016-05-31","2016-05-16",212.30271402830331,null,null,null,null,212.31353351533471,220.35168053216034,180.9877602013249]
[null,"2016-05-31","2016-05-17",213.13503508396749,null,null,null,null,212.31353351533471,222.04133408346539,180.9877602013249]
[null,"2016-05-31","2016-05-18",214.95176945923987,null,null,null,null,212.31353351533471,223.74394387416262,180.9877602013249]
[null,"2016-05-31","2016-05-19",211.74832295138575,null,null,null,null,212.31353351533471,225.45960925251129,180.9877602013249]
[null,"2016-05-31","2016-05-20",204.12598314345399,null,null,null,null,212.31353351533471,227.1884303285718,180.9877602013249]
[null,"2016-05-31","2016-05-21",206.79626103741319,null,null,null,null,212.31353351533471,228.93050798004705,180.9877602013249]
[null,"2016-05-31","2016-05-22",205.94675068164116,null,null,null,null,212.31353351533471,230.68594385816868,180.9877602013249]
[null,"2016-05-31","2016-05-23",206.53764800676461,null,null,null,null,212.31353351533471,232.45484039362861,180.9877602013249]
[null,"2016-05-31","2016-05-24",209.09300668607648,null,null,null,null,212.31353351533471,234.23730080255578,180.9877602013249]
[null,"2016-05-31","2016-05-25",214.24917940155333,null,null,null,null,212.31353351533471,236.03342909253894,180.9877602013249]
[null,"2016-05-31","2016-05-26",217.56506402181373,null,null,null,null,212.31353351533471,237.84333006869559,180.9877602013249]
[null,"2016-05-31","2016-05-27",227.27677375631063,null,null,null,null,212.31353351533471,239.66710933978734,180.9877602013249]
[null,"2016-05-31","2016-05-28",229.08817846822325,null,null,null,null,212.31353351533471,241.50487332438234,180.9877602013249]
[null,"2016-05-31","2016-05-29",239.21618535874569,null,null,null,null,212.31353351533471,243.35672925706473,180.9877602013249]
[null,"2016-05-31","2016-05-30",241.25263983227893,null,null,null,null,212.31353351533471,245.22278519469199,180.9877602013249]
[null,"2016-05-31","2016-05-31",247.10315002269996,null,null,null,null,212.31353351533471,247.10315002269996,212.31353351533471]
[null,"2016-06-30","2016-06-01",236.2247579222331,null,null,null,null,226.96413138183701,245.67985033615676,212.31353351533471]
[null,"2016-06-30","2016-06-02",235.35437795000999,null,null,null,null,226.96413138183701,244.26474877253318,212.31353351533471]
[null,"2016-06-30","2016-06-03",228.93588043175575,null,null,null,null,226.96413138183701,242.85779811112087,212.31353351533471]
[null,"2016-06-30","2016-06-04",235.77748714072365,null,null,null,null,226.96413138183701,241.45895140320002,212.31353351533471]
[null,"2016-06-30","2016-06-05",238.91127095370217,null,null,null,null,226.96413138183701,240.06816197047257,212.31353351533471]
[null,"2016-06-30","2016-06-06",244.64505885325784,null,null,null,null,226.96413138183701,238.68538340350494,212.31353351533471]
[null,"2016-06-30","2016-06-07",235.68904381058445,null,null,null,null,226.96413138183701,237.310569560179,212.31353351533471]
[null,"2016-06-30","2016-06-08",231.11670440306361,null,null,null,null,226.96413138183701,235.94367456415259,212.31353351533471]
[null,"2016-06-30","2016-06-09",227.51120941584531,null,null,null,null,226.96413138183701,234.58465280332859,212.31353351533471]
[null,"2016-06-30","2016-06-10",225.5496168289869,null,null,null,null,226.96413138183701,233.23345892833285,212.31353351533471]
[null,"2016-06-30","2016-06-11",224.77929836489844,null,null,null,null,226.96413138183701,231.89004785100099,212.31353351533471]
[null,"2016-06-30","2016-06-12",241.14409142404759,null,null,null,null,226.96413138183701,230.55437474287388,212.31353351533471]
[null,"2016-06-30","2016-06-13",234.53733348916018,null,null,null,null,226.96413138183701,229.22639503370161,212.31353351533471]
[null,"2016-06-30","2016-06-14",231.72070905561071,null,null,null,null,226.96413138183701,227.90606440995634,212.31353351533471]
[null,"2016-06-30","2016-06-15",219.41857727985405,null,null,null,null,226.96413138183701,226.59333881335351,212.31353351533471]
[null,"2016-06-30","2016-06-16",224.44324380892627,null,null,null,null,226.96413138183701,225.28817443938175,212.31353351533471]
[null,"2016-06-30","2016-06-17",223.65695903124958,null,null,null,null,226.96413138183701,223.99052773584111,212.31353351533471]
[null,"2016-06-30","2016-06-18",227.73869931458646,null,null,null,null,226.96413138183701,222.70035540138974,212.31353351533471]
[null,"2016-06-30","2016-06-19",224.39047253414435,null,null,null,null,226.96413138183701,221.41761438409904,212.31353351533471]
[null,"2016-06-30","2016-06-20",216.25360178936353,null,null,null,null,226.96413138183701,220.14226188001689,212.31353351533471]
[null,"2016-06-30","2016-06-21",227.5694731743958,null,null,null,null,226.96413138183701,218.87425533173959,212.31353351533471]
[null,"2016-06-30","2016-06-22",231.75193210069614,null,null,null,null,226.96413138183701,217.61355242699139,212.31353351533471]
[null,"2016-06-30","2016-06-23",231.5588345825461,null,null,null,null,226.96413138183701,216.36011109721295,212.31353351533471]
[null,"2016-06-30","2016-06-24",225.53366916514122,null,null,null,null,226.96413138183701,215.11388951615734,212.31353351533471]
[null,"2016-06-30","2016-06-25",220.76634239828013,null,null,null,null,226.96413138183701,213.87484609849426,212.31353351533471]
[null,"2016-06-30","2016-06-26",217.76469465142267,null,null,null,null,226.96413138183701,212.64293949842261,212.31353351533471]
[null,"2016-06-30","2016-06-27",218.74397771957828,null,null,null,null,226.96413138183701,211.41812860829057,212.31353351533471]
[null,"2016-06-30","2016-06-28",207.84489188711908,null,null,null,null,226.96413138183701,210.20037255722409,212.31353351533471]
[null,"2016-06-30","2016-06-29",211.80586930942235,null,null,null,null,226.96413138183701,208.98963070976291,212.31353351533471]
[null,"2016-06-30","2016-06-30",207.78586266450463,null,null,null,null,226.96413138183701,207.78586266450463,226.96413138183701]
[null,"2016-07-31","2016-07-01",219.77034112322968,null,null,null,null,215.30666459938266,207.37917898098132,226.96413138183701]
[null,"2016-07-31","2016-07-02",227.77168317256886,null,null,null,null,215.30666459938266,206.97329126892751,226.96413138183701]
[null,"2016-07-31","2016-07-03",222.83583610105595,null,null,null,null,215.30666459938266,206.56819797044793,226.96413138183701]
[null,"2016-07-31","2016-07-04",226.71917201716886,null,null,null,null,215.30666459938266,206.16389753069649,226.96413138183701]
[null,"2016-07-31","2016-07-05",222.82327878100907,null,null,null,null,215.30666459938266,205.76038839787026,226.96413138183701]
[null,"2016-07-31","2016-07-06",218.11050814077973,null,null,null,null,215.30666459938266,205.35766902320356,226.96413138183701]
[null,"2016-07-31","2016-07-07",222.59914428682998,null,null,null,null,215.30666459938266,204.95573786096193,226.96413138183701]
[null,"2016-07-31","2016-07-08",223.43345748589311,null,null,null,null,215.30666459938266,204.5545933684364,226.96413138183701]
[null,"2016-07-31","2016-07-09",227.20632216060335,null,null,null,null,215.30666459938266,204.1542340059373,226.96413138183701]
[null,"2016-07-31","2016-07-10",225.4590668928422,null,null,null,null,215.30666459938266,203.75465823678852,226.96413138183701]
[null,"2016-07-31","2016-07-11",235.8515409923219,null,null,null,null,{"$f":"LOOKUP(B199,E:E,F:F)","v":215.30666459938266},{"$f":"interpolate_look_up(C199,E:E,G:G)","v":203.35586452732156},{"$f":"LOOKUP(C199,E:E,F:F)","v":226.96413138183701}]
[null,{"$f":"EOMONTH(C200,0)","v":"2016-07-31"},"2016-07-12",231.06826583233149,null,null,null,null,215.30666459938266,202.95785134686966,226.96413138183701]
[null,"2016-07-31",{"$f":"C200+1","v":"2016-07-13"},222.92965791349778,null,null,null,null,215.30666459938266,202.56061716776199,226.96413138183701]
[null,"2016-07-31","2016-07-14",211.09482325947988,null,null,null,null,215.30666459938266,202.16416046531756,226.96413138183701]
[null,"2016-07-31","2016-07-15",200.72139266250713,null,null,null,null,215.30666459938266,201.76847971783965,226.96413138183701]
[null,"2016-07-31","2016-07-16",205.65499757635706,null,null,null,null,215.30666459938266,201.37357340660984,226.96413138183701]
[null,"2016-07-31","2016-07-17",200.1805919781882,null,null,null,null,215.30666459938266,200.97944001588206,226.96413138183701]
[null,"2016-07-31","2016-07-18",203.86102160368694,null,null,null,null,215.30666459938266,200.58607803287708,226.96413138183701]
[null,"2016-07-31","2016-07-19",205.22338491477367,null,null,null,null,215.30666459938266,200.1934859477764,226.96413138183701]
[null,"2016-07-31","2016-07-20",216.91801406186354,null,null,null,null,215.30666459938266,199.80166225371659,226.96413138183701]
[null,"2016-07-31","2016-07-21",209.42879439359177,null,null,null,null,215.30666459938266,199.41060544678348,226.96413138183701]
[null,"2016-07-31","2016-07-22",199.18990152022553,null,null,null,null,215.30666459938266,199.02031402600645,226.96413138183701]
[null,"2016-07-31","2016-07-23",192.96686610886221,null,null,null,null,215.30666459938266,198.63078649335256,226.96413138183701]
[null,"2016-07-31","2016-07-24",195.54188740551538,null,null,null,null,215.30666459938266,198.24202135372093,226.96413138183701]