{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Introduction","User input","Time and tax (TT)","Analysis summary"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":21,"comments":1,"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":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[[27,1,27,4],[4,1,5,8],[4,13,5,23],[7,2,7,3],[7,4,7,5],[7,13,8,13],[43,15,43,16],[44,1,44,3],[50,1,50,11],[28,1,29,11],[30,1,31,11],[36,1,36,9],[37,1,38,8],[39,1,40,4],[39,6,40,10]]}
[]
[]
[null,"KSU-Own Sprayer"]
[]
[null,"An Excel spreadsheet to evaluate the economic costs of owning and operating a self-propelled crop sprayer."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Version- 6.30.16"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INSTRUCTIONS FOR THE USER:"]
[null,"Be sure to \"Enable Content\" and \"Enable Macros\" for the spreadsheet to function correctly. This spreadsheet uses macros to print the three different pages, however printing can also be done manually by highlighting the desired range and using the menu print commands."]
[]
[null,"In the \"User input\" tab all blue numbers are inputs and all black numbers are calculated from these inputs.  Several input cells (i.e., blue number) have a red diamond in the upper right hand corner of the cell.  By moving your mouse cursor over this diamond, a brief description of the input will be displayed on the screen."]
[]
[]
[]
[null,"FOR MORE INFORMATION:"]
[null,"For explanation of the inputs used in this spreadsheet see the supporting paper:"]
[null,"Evaluating Self-Propelled Sprayer Ownership with Own Sprayer Spreadsheet"]
[null,"*This publication provides information on how to use the tool, however some values in the tool have been updated since the paper was written."]
[]
[null,"With Questions contact:",null,null,null,null,"Originally Developed by:"]
[]
[null,"Rich Llewelyn",null,null,null,null,"Kevin C. Dhuyvetter, Ph.D."]
[null,"Extension Assistant",null,null,null,null,"Former Agricultural Economist"]
[null,"Kansas State University",null,null,null,null,"Kansas State University"]
[null,"rvl@ksu.edu"]
[null,"785-532-1504",null,null,null,null,"Terry L. Kastens, Ph.D."]
[null,null,null,null,null,null,"Emeritus Agricultural Economist"]
[null,null,null,null,null,null,"Kansas State University"]
[]
[]
[null,"Copyright 2016 AgManager.info, K-State Department of Agricultural Economics"]

{"sheet":"User input","index":1,"n_rows":77,"n_cols":13,"rows_kept":77,"cut":false,"hidden":false,"merged":[[5,1,5,2]]}
[" "]
[null,"User Input and related calculations section (blue shaded cells are inputs)"]
[]
[null,"Information pertaining to sprayer depreciation and repairs"]
[null,null,null,null,null,null,null,null,null,"repair factors"]
[null,"Sprayer class",null,null,null,null,"age","100 hrs","age*100hrs","RF1","RF2","useful life"]
[null,1,"CaseIH-Patriot3230tankPoly750boom90",null,null,null,-6.1642690197482426E-2,-1.569304718143098E-2,0,0.06,2,3000]
[null,2,"CaseIH-Patriot4420tankSS1200boom90",null,null,null,-4.9242995457910478E-2,-1.0081075408571625E-2,0,0.06,2,3000]
[null,3,"JD4830tankSS800boom90",null,null,null,-6.9864952813407294E-2,-1.0804953704999431E-2,0,0.06,2,3000]
[null,4,"JD4930tankSS1200boom90",null,null,null,-7.2455046670936912E-2,-9.3354441547398147E-3,0,0.06,2,3000]
[null,5,"RoGator984HtankSS900boom90",null,null,null,-7.4236520680335552E-2,-1.2933229587339813E-2,0,0.06,2,3000]
[null,6,"SpraCoupe4460tankPoly400boom80",null,null,null,-4.364375105325799E-2,-1.064220636553184E-2,0,0.06,2,3000]
[]
[null,null,"Factors used in analysis =>",null,null,{"$f":"IF($F16=1,C7,IF($F16=2,C8,IF($F16=3,C9,IF($F16=4,C10,IF($F16=5,C11,IF($F16=6,C12,\"NA\"))))))","v":"RoGator984HtankSS900boom90"},{"$f":"IF($F16=1,G7,IF($F16=2,G8,IF($F16=3,G9,IF($F16=4,G10,IF($F16=5,G11,IF($F16=6,G12,\"NA\"))))))","v":-7.4236520680335552E-2},-1.2933229587339813E-2,0,0.06,2,3000]
[]
[null,"Sprayer class",null,null,null,5,null,"Bank interest rate (percent)",null,null,null,0.05]
[null,"Sprayer age in years",null,null,null,0,null,"Calculated after-tax discount rate",null,null,null,{"$f":"L16*(1-L18-L19)","v":3.2350000000000004E-2}]
[null,"Hours on sprayer",null,null,null,0,null,"State + U.S. marginal income tax rate (percent)",null,null,null,0.2]
[null,"Purchase price of sprayer w/o trade-in",null,null,null,200000,null,"Self-employment tax (0 if corporation)",null,null,null,0.153]
[null,"Market price of sprayer",null,null,null,200000,null,"Section-179 deduction ($500,000 max)",null,null,null,0]
[null,"Cash downpayment",null,null,null,40000,null,{"$f":"FIXED('User input'!F74*100,0)&\"% bonus 1st-yr dep. On new equip. (yes=1, no=0)\"","v":"50% bonus 1st-yr dep. On new equip. (yes=1, no=0)"},null,null,null,1]
[null,"Calculated new equivalent price (NEP)",null,null,null,{"$f":"F20/EXP(G14*F17+H14*F18/100+I14*F17*F18/100)","v":200000},null,"Calculated bonus yr-1 depreciation",null,null,null,{"$f":"IF(AND(F17=0,L21=1),(F22-MIN(F22,MIN('User input'!F73,L20)))*'User input'!F74,0)","v":100000}]
[null,null,null,null,null,null,null,"Calculated net $ amount to depreciate",null,null,null,{"$f":"F19-MIN(F19,MIN(L20,'User input'!F73))-L22","v":100000}]
[null,"No. of seasons (years) before trade (max. 20)",null,null,null,7]
[null,"Sprayer boom width in feet",null,null,null,90,null,"1st year MACRS depreciation rate",null,null,null,0.1429]
[null,"Sprayer travel speed in mph",null,null,null,12,null,"2nd year MACRS depreciation rate",null,null,null,0.24490000000000001]
[null,"Calculated acres per hour at 100% efficiency",null,null,null,{"$f":"F25*F26*5280/43560","v":130.90909090909091},null,"3rd year MACRS depreciation rate",null,null,null,0.1749]
[null,"Average expected efficiency (percent)",null,null,null,0.35249999999999998,null,"4th year MACRS depreciation rate",null,null,null,0.1249]
[null,"Calculated acres per hour",null,null,null,{"$f":"F27*F28","v":46.145454545454541},null,"5th year MACRS depreciation rate",null,null,null,8.9300000000000004E-2]
[null,"Total acres sprayed annually",null,null,null,50000,null,"6th year MACRS depreciation rate",null,null,null,8.9200000000000002E-2]
[null,"Calculated total hours accumulated annually",null,null,null,{"$f":"F30/F29","v":1083.5303388494879},null,"7th year MACRS depreciation rate",null,null,null,8.9300000000000004E-2]
[null,null,null,null,null,null,null,"8th year MACRS depreciation rate",null,null,null,4.4600000000000001E-2]
[null,"Labor",null,null,null,null,null,"Calculated error check of depreciation rates",null,null,null,{"$f":"SUM(L25:L32)","v":1.0000000000000002}]
[null,"   Total labor hours per sprayer engine hour",null,null,null,1.25,null,"Calculated after-tax amortization factor",null,null,null,{"$f":"L17/(1-(1+L17)^-F24)","v":0.16193090426268791}]
[null,"   Labor cost per hour",null,null,null,15,null,"Calculated first-year after-tax discount factor",null,null,null,{"$f":"1/(1+L17)","v":0.96866372838669046}]
[null,"   Calculated labor cost per acre",null,null,null,{"$f":"F35*F34/F29","v":0.40632387706855794}]
[null,"Fuel and lubrication",null,null,null,null,null,"Tendering cost per hour",null,null,null,12]
[null,"   Sprayer fuel consumption per hour (gallons)",null,null,null,10,null,"Tendering cost per acre",null,null,null,1.2]
[null,"   Average fuel price ($/gal)",null,null,null,2.25,null,"Calculated total tendering cost per acre",null,null,null,{"$f":"L37/F29+L38","v":1.460047281323877}]
[null,"   Oil and lubrication percent of fuel cost",null,null,null,0.1]
[null,"   Calculated fuel and lubrication cost per hour",null,null,null,{"$f":"F38*F39*(1+F40)","v":24.750000000000004},null,"Calculated after-tax NPVc from TT section",null,null,null,{"$f":"'Time and tax (TT)'!U4","v":356001.55379824637},{"$f":"IF(OR(L33>1.01,L33<0.99),\"<= Error!\",\" \")","v":" "}]
[null,"   Calculated fuel and lubrication cost per acre",null,null,null,{"$f":"F41/F29","v":0.5363475177304966},null,"Calculated after-tax amortized NPV from TT",null,null,null,{"$f":"L34*L41","v":57647.653525471971}]
[null,"Repairs and maintenance",null,null,null,null,null,"Calculated pre-tax amortized NPV from TT",null,null,null,{"$f":"L42/(1-L18-L19)","v":89099.928169199338}]
[null,"   Repair adjustment factor (0.8 to 1.2, usually 1) (RAF)",null,null,null,1,null,"   Prorated to opportunity interest",null,null,null,{"$f":"L43*'Time and tax (TT)'!G7","v":5731.5220838646583}]
[null,"   Repairs per hour after useful life",null,null,null,{"$f":"(K14*J14*F22*'User input'!F77*(L14/1000)^(K14-1))/1000","v":72},null,"   Prorated to market depreciation",null,null,null,{"$f":"L43*'Time and tax (TT)'!H7","v":22118.159487297904}]
[null,null,null,null,null,null,null,"   Prorated to repairs",null,null,null,{"$f":"L43*'Time and tax (TT)'!Q7","v":59530.789972877385}]
[null,"Tax, insurance, & shelter (TIS - % of value, decimal)",null,null,null,1.4999999999999999E-2,null,"   Prorated to tax, insurance, & shelter (TIS)",null,null,null,{"$f":"L43*'Time and tax (TT)'!O7","v":1719.4566251593974}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Year",null,null,null,2016]
[null,"Section 179 allowance",null,null,null,500000]
[null,"Bonus depreciation",null,null,null,0.5]
[null,"Min age for bonus dep (new=0)",null,null,null,0]
[null,"Market ding when trade",null,null,null,0]
[null,"NEP adjustment to approximate list price",null,null,null,1]

{"sheet":"Time and tax (TT)","index":2,"n_rows":36,"n_cols":21,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Time and tax (TT) section"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"After-tax net present value of costs (NPVc) =>",{"$f":"SUM(U12:U32)","v":356001.55379824637}]
[]
[null,null,null,null,null,"after-tax NPV =>",{"$f":"SUMPRODUCT($C12:$C32,G12:G32)*(1-'User input'!$L18-'User input'!$L19)","v":23592.582222864017},{"$f":"SUMPRODUCT($C12:$C32,H12:H32)*(1-'User input'!$L18-'User input'!$L19)","v":91044.66295114388},null,null,null,null,null,"after-tax NPV =>",{"$f":"SUMPRODUCT($C12:$C32,O12:O32)*(1-'User input'!$L18-'User input'!$L19)","v":7077.7746668592054},null,{"$f":"SUMPRODUCT($C12:$C32,Q12:Q32)*(1-'User input'!$L18-'User input'!$L19)","v":245045.73770745037}]
[null,null,null,null,null,"% of total =>",{"$f":"G6/($G6+$H6+$O6+$Q6)","v":6.4326899040598434E-2},{"$f":"H6/($G6+$H6+$O6+$Q6)","v":0.24823992501201428},null,null,null,null,null,"% of total =>",{"$f":"O6/($G6+$H6+$O6+$Q6)","v":1.9298069712179528E-2},null,{"$f":"Q6/($G6+$H6+$O6+$Q6)","v":0.66813510623520778}]
[null,null,null,null,null,null,null,null,null,null,"EOY*"]
[null,null,"after-tax","EOY*","EOY*","est.",null,null,"tax","Sec. 179","or year",null,null,null,null,null,null,{"$f":"SUM(R12:R27)/'User input'!F24","v":1.2517122593718337}]
[null,null,"discount","machine","machine","machine","opp.","market","deprec.","and tax","of sale","loan","loan","downpmt",null,"accum.","annual","repairs","tax","net","discounted"]
[null,"year","factor","age","hours","value","interest","deprec.","rate","deprec.","tax basis","interest","principal","or sale","TIS**","repairs","repairs","per acre","savings","cash out","cash out"]
[null,0,{"$f":"IF(B12>'User input'!F$24,\"\",'User input'!L$35^B12)","v":1},{"$f":"IF(B12>'User input'!F$24,\"\",IF(B12=0,'User input'!F$17,D11+1))","v":0},{"$f":"IF(B12>'User input'!F$24,\"\",IF(B12=0,'User input'!F$18,E11+'User input'!F$31))","v":0},{"$f":"IF(B12>'User input'!F$24,\"\",EXP('User input'!G$14*(D12-'User input'!F$17)+'User input'!H$14*((E12-'User input'!F$18)/100)+'User input'!I$14*(D12-'User input'!F$17)*(E12-'User input'!F$18)/100)*'User input'!F$20*IF(B12=0,1,(1-'User input'!F$76)))","v":200000},{"$f":"IF(B12>'User input'!F$24,\"\",IF(B12>0,F11*'User input'!L$16,0))","v":0},{"$f":"IF(B12>'User input'!F$24,\"\",IF(B12>0,F11-F12,0))","v":0},{"$f":"IF(B12>'User input'!F$24,\"\",IF(B12>7,0,IF(SUM(I$11:I11)<1,IF(B12='User input'!F$24,'User input'!L25/2,'User input'!L25),0)))","v":0.1429},{"$f":"IF(B12>'User input'!F$24,\"\",IF(B12=0,MIN('User input'!F$19,'User input'!L$20)+'User input'!L$22+'User input'!L$23*I12,'User input'!L$23*I12))","v":114290},{"$f":"IF(B12>'User input'!F$24,\"\",IF(B12=0,'User input'!F$19-J12,K11-J12))","v":85710},{"$f":"IF(B12>'User input'!F$24,\"\",IF(B12>0,('User input'!F$19-'User input'!F$21)*'User input'!L$16,0))","v":0},{"$f":"IF(B12>'User input'!F$24,\"\",IF(B12='User input'!F$24,'User input'!F$19-'User input'!F$21,0))","v":0},{"$f":"IF(B12>'User input'!F$24,\"\",IF(B12=0,'User input'!F$21,IF(B12='User input'!F$24,-F12,0)))","v":40000},{"$f":"IF(B12>'User input'!F$24,\"\",IF(B12>0,'User input'!F$47*F11,0))","v":0},{"$f":"IF(B12>'User input'!F$24,\"\",(IF(E12>'User input'!L$14,(E12-'User input'!L$14)*'User input'!F$45+'User input'!J$14*'User input'!F$22*'User input'!F$77*('User input'!L$14/1000)^'User input'!K$14,'User input'!J$14*'User input'!F$22*'User input'!F$77*(E12/1000)^'User input'!K$14))*'User input'!F$44)","v":0},{"$f":"IF(B12>'User input'!F$24,\"\",IF(B12>0,(P12-P11),0))","v":0},{"$f":"IF(B12>'User input'!F$24,\"\",Q12/'User input'!F$30)","v":0},{"$f":"IF(B12>'User input'!F$24,\"\",(J12+L12+O12+Q12)*('User input'!L$18+'User input'!L$19)-IF(B12='User input'!F$24,(F12-K12)*'User input'!L$18,0))","v":40344.369999999995},{"$f":"IF(B12>'User input'!F$24,\"\",L12+M12+N12+O12+Q12-S12)","v":-344.36999999999534},{"$f":"IF(B12>'User input'!F$24,\"\",C12*T12)","v":-344.36999999999534}]
[null,{"$f":"IF(B12>='User input'!F$24,\" \",B12+1)","v":1},{"$f":"IF(B13>'User input'!F$24,\"\",'User input'!L$35^B13)","v":0.96866372838669046},{"$f":"IF(B13>'User input'!F$24,\"\",IF(B13=0,'User input'!F$17,D12+1))","v":1},{"$f":"IF(B13>'User input'!F$24,\"\",IF(B13=0,'User input'!F$18,E12+'User input'!F$31))","v":1083.5303388494879},{"$f":"IF(B13>'User input'!F$24,\"\",EXP('User input'!G$14*(D13-'User input'!F$17)+'User input'!H$14*((E13-'User input'!F$18)/100)+'User input'!I$14*(D13-'User input'!F$17)*(E13-'User input'!F$18)/100)*'User input'!F$20*IF(B13=0,1,(1-'User input'!F$76)))","v":161409.62354561139},{"$f":"IF(B13>'User input'!F$24,\"\",IF(B13>0,F12*'User input'!L$16,0))","v":10000},{"$f":"IF(B13>'User input'!F$24,\"\",IF(B13>0,F12-F13,0))","v":38590.376454388606},{"$f":"IF(B13>'User input'!F$24,\"\",IF(B13>7,0,IF(SUM(I$11:I12)<1,IF(B13='User input'!F$24,'User input'!L26/2,'User input'!L26),0)))","v":0.24490000000000001},{"$f":"IF(B13>'User input'!F$24,\"\",IF(B13=0,MIN('User input'!F$19,'User input'!L$20)+'User input'!L$22+'User input'!L$23*I13,'User input'!L$23*I13))","v":24490},{"$f":"IF(B13>'User input'!F$24,\"\",IF(B13=0,'User input'!F$19-J13,K12-J13))","v":61220},{"$f":"IF(B13>'User input'!F$24,\"\",IF(B13>0,('User input'!F$19-'User input'!F$21)*'User input'!L$16,0))","v":8000},{"$f":"IF(B13>'User input'!F$24,\"\",IF(B13='User input'!F$24,'User input'!F$19-'User input'!F$21,0))","v":0},{"$f":"IF(B13>'User input'!F$24,\"\",IF(B13=0,'User input'!F$21,IF(B13='User input'!F$24,-F13,0)))","v":0},{"$f":"IF(B13>'User input'!F$24,\"\",IF(B13>0,'User input'!F$47*F12,0))","v":3000},{"$f":"IF(B13>'User input'!F$24,\"\",(IF(E13>'User input'!L$14,(E13-'User input'!L$14)*'User input'!F$45+'User input'!J$14*'User input'!F$22*'User input'!F$77*('User input'!L$14/1000)^'User input'!K$14,'User input'!J$14*'User input'!F$22*'User input'!F$77*(E13/1000)^'User input'!K$14))*'User input'!F$44)","v":14088.455942487433},{"$f":"IF(B13>'User input'!F$24,\"\",IF(B13>0,(P13-P12),0))","v":14088.455942487433},{"$f":"IF(B13>'User input'!F$24,\"\",Q13/'User input'!F$30)","v":0.28176911884974865},{"$f":"IF(B13>'User input'!F$24,\"\",(J13+L13+O13+Q13)*('User input'!L$18+'User input'!L$19)-IF(B13='User input'!F$24,(F13-K13)*'User input'!L$18,0))","v":17501.194947698063},{"$f":"IF(B13>'User input'!F$24,\"\",L13+M13+N13+O13+Q13-S13)","v":7587.2609947893689},{"$f":"IF(B13>'User input'!F$24,\"\",C13*T13)","v":7349.5045234555801}]
[null,{"$f":"IF(B13>='User input'!F$24,\" \",B13+1)","v":2},{"$f":"IF(B14>'User input'!F$24,\"\",'User input'!L$35^B14)","v":0.93830941869200402},{"$f":"IF(B14>'User input'!F$24,\"\",IF(B14=0,'User input'!F$17,D13+1))","v":2},{"$f":"IF(B14>'User input'!F$24,\"\",IF(B14=0,'User input'!F$18,E13+'User input'!F$31))","v":2167.0606776989757},{"$f":"IF(B14>'User input'!F$24,\"\",EXP('User input'!G$14*(D14-'User input'!F$17)+'User input'!H$14*((E14-'User input'!F$18)/100)+'User input'!I$14*(D14-'User input'!F$17)*(E14-'User input'!F$18)/100)*'User input'!F$20*IF(B14=0,1,(1-'User input'!F$76)))","v":130265.33286567994},{"$f":"IF(B14>'User input'!F$24,\"\",IF(B14>0,F13*'User input'!L$16,0))","v":8070.4811772805697},{"$f":"IF(B14>'User input'!F$24,\"\",IF(B14>0,F13-F14,0))","v":31144.290679931451},{"$f":"IF(B14>'User input'!F$24,\"\",IF(B14>7,0,IF(SUM(I$11:I13)<1,IF(B14='User input'!F$24,'User input'!L27/2,'User input'!L27),0)))","v":0.1749},{"$f":"IF(B14>'User input'!F$24,\"\",IF(B14=0,MIN('User input'!F$19,'User input'!L$20)+'User input'!L$22+'User input'!L$23*I14,'User input'!L$23*I14))","v":17490},{"$f":"IF(B14>'User input'!F$24,\"\",IF(B14=0,'User input'!F$19-J14,K13-J14))","v":43730},{"$f":"IF(B14>'User input'!F$24,\"\",IF(B14>0,('User input'!F$19-'User input'!F$21)*'User input'!L$16,0))","v":8000},{"$f":"IF(B14>'User input'!F$24,\"\",IF(B14='User input'!F$24,'User input'!F$19-'User input'!F$21,0))","v":0},{"$f":"IF(B14>'User input'!F$24,\"\",IF(B14=0,'User input'!F$21,IF(B14='User input'!F$24,-F14,0)))","v":0},{"$f":"IF(B14>'User input'!F$24,\"\",IF(B14>0,'User input'!F$47*F13,0))","v":2421.144353184171},{"$f":"IF(B14>'User input'!F$24,\"\",(IF(E14>'User input'!L$14,(E14-'User input'!L$14)*'User input'!F$45+'User input'!J$14*'User input'!F$22*'User input'!F$77*('User input'!L$14/1000)^'User input'!K$14,'User input'!J$14*'User input'!F$22*'User input'!F$77*(E14/1000)^'User input'!K$14))*'User input'!F$44)","v":56353.823769949733},{"$f":"IF(B14>'User input'!F$24,\"\",IF(B14>0,(P14-P13),0))","v":42265.367827462302},{"$f":"IF(B14>'User input'!F$24,\"\",Q14/'User input'!F$30)","v":0.84530735654924605},{"$f":"IF(B14>'User input'!F$24,\"\",(J14+L14+O14+Q14)*('User input'!L$18+'User input'!L$19)-IF(B14='User input'!F$24,(F14-K14)*'User input'!L$18,0))","v":24772.308799768205},{"$f":"IF(B14>'User input'!F$24,\"\",L14+M14+N14+O14+Q14-S14)","v":27914.203380878269},{"$f":"IF(B14>'User input'!F$24,\"\",C14*T14)","v":26192.159947562261}]
[null,{"$f":"IF(B14>='User input'!F$24,\" \",B14+1)","v":3},{"$f":"IF(B15>'User input'!F$24,\"\",'User input'!L$35^B15)","v":0.90890629989054483},{"$f":"IF(B15>'User input'!F$24,\"\",IF(B15=0,'User input'!F$17,D14+1))","v":3},{"$f":"IF(B15>'User input'!F$24,\"\",IF(B15=0,'User input'!F$18,E14+'User input'!F$31))","v":3250.5910165484638},{"$f":"IF(B15>'User input'!F$24,\"\",EXP('User input'!G$14*(D15-'User input'!F$17)+'User input'!H$14*((E15-'User input'!F$18)/100)+'User input'!I$14*(D15-'User input'!F$17)*(E15-'User input'!F$18)/100)*'User input'!F$20*IF(B15=0,1,(1-'User input'!F$76)))","v":105130.39169446578},{"$f":"IF(B15>'User input'!F$24,\"\",IF(B15>0,F14*'User input'!L$16,0))","v":6513.2666432839978},{"$f":"IF(B15>'User input'!F$24,\"\",IF(B15>0,F14-F15,0))","v":25134.941171214159},{"$f":"IF(B15>'User input'!F$24,\"\",IF(B15>7,0,IF(SUM(I$11:I14)<1,IF(B15='User input'!F$24,'User input'!L28/2,'User input'!L28),0)))","v":0.1249},{"$f":"IF(B15>'User input'!F$24,\"\",IF(B15=0,MIN('User input'!F$19,'User input'!L$20)+'User input'!L$22+'User input'!L$23*I15,'User input'!L$23*I15))","v":12490},{"$f":"IF(B15>'User input'!F$24,\"\",IF(B15=0,'User input'!F$19-J15,K14-J15))","v":31240},{"$f":"IF(B15>'User input'!F$24,\"\",IF(B15>0,('User input'!F$19-'User input'!F$21)*'User input'!L$16,0))","v":8000},{"$f":"IF(B15>'User input'!F$24,\"\",IF(B15='User input'!F$24,'User input'!F$19-'User input'!F$21,0))","v":0},{"$f":"IF(B15>'User input'!F$24,\"\",IF(B15=0,'User input'!F$21,IF(B15='User input'!F$24,-F15,0)))","v":0},{"$f":"IF(B15>'User input'!F$24,\"\",IF(B15>0,'User input'!F$47*F14,0))","v":1953.979992985199},{"$f":"IF(B15>'User input'!F$24,\"\",(IF(E15>'User input'!L$14,(E15-'User input'!L$14)*'User input'!F$45+'User input'!J$14*'User input'!F$22*'User input'!F$77*('User input'!L$14/1000)^'User input'!K$14,'User input'!J$14*'User input'!F$22*'User input'!F$77*(E15/1000)^'User input'!K$14))*'User input'!F$44)","v":126042.55319148939},{"$f":"IF(B15>'User input'!F$24,\"\",IF(B15>0,(P15-P14),0))","v":69688.729421539669},{"$f":"IF(B15>'User input'!F$24,\"\",Q15/'User input'!F$30)","v":1.3937745884307933},{"$f":"IF(B15>'User input'!F$24,\"\",(J15+L15+O15+Q15)*('User input'!L$18+'User input'!L$19)-IF(B15='User input'!F$24,(F15-K15)*'User input'!L$18,0))","v":32522.846423327279},{"$f":"IF(B15>'User input'!F$24,\"\",L15+M15+N15+O15+Q15-S15)","v":47119.862991197588},{"$f":"IF(B15>'User input'!F$24,\"\",C15*T15)","v":42827.540322678818}]
[null,{"$f":"IF(B15>='User input'!F$24,\" \",B15+1)","v":4},{"$f":"IF(B16>'User input'!F$24,\"\",'User input'!L$35^B16)","v":0.88042456520612644},{"$f":"IF(B16>'User input'!F$24,\"\",IF(B16=0,'User input'!F$17,D15+1))","v":4},{"$f":"IF(B16>'User input'!F$24,\"\",IF(B16=0,'User input'!F$18,E15+'User input'!F$31))","v":4334.1213553979514},{"$f":"IF(B16>'User input'!F$24,\"\",EXP('User input'!G$14*(D16-'User input'!F$17)+'User input'!H$14*((E16-'User input'!F$18)/100)+'User input'!I$14*(D16-'User input'!F$17)*(E16-'User input'!F$18)/100)*'User input'!F$20*IF(B16=0,1,(1-'User input'!F$76)))","v":84845.284733031978},{"$f":"IF(B16>'User input'!F$24,\"\",IF(B16>0,F15*'User input'!L$16,0))","v":5256.5195847232899},{"$f":"IF(B16>'User input'!F$24,\"\",IF(B16>0,F15-F16,0))","v":20285.106961433805},{"$f":"IF(B16>'User input'!F$24,\"\",IF(B16>7,0,IF(SUM(I$11:I15)<1,IF(B16='User input'!F$24,'User input'!L29/2,'User input'!L29),0)))","v":8.9300000000000004E-2},{"$f":"IF(B16>'User input'!F$24,\"\",IF(B16=0,MIN('User input'!F$19,'User input'!L$20)+'User input'!L$22+'User input'!L$23*I16,'User input'!L$23*I16))","v":8930},{"$f":"IF(B16>'User input'!F$24,\"\",IF(B16=0,'User input'!F$19-J16,K15-J16))","v":22310},{"$f":"IF(B16>'User input'!F$24,\"\",IF(B16>0,('User input'!F$19-'User input'!F$21)*'User input'!L$16,0))","v":8000},{"$f":"IF(B16>'User input'!F$24,\"\",IF(B16='User input'!F$24,'User input'!F$19-'User input'!F$21,0))","v":0},{"$f":"IF(B16>'User input'!F$24,\"\",IF(B16=0,'User input'!F$21,IF(B16='User input'!F$24,-F16,0)))","v":0},{"$f":"IF(B16>'User input'!F$24,\"\",IF(B16>0,'User input'!F$47*F15,0))","v":1576.9558754169866},{"$f":"IF(B16>'User input'!F$24,\"\",(IF(E16>'User input'!L$14,(E16-'User input'!L$14)*'User input'!F$45+'User input'!J$14*'User input'!F$22*'User input'!F$77*('User input'!L$14/1000)^'User input'!K$14,'User input'!J$14*'User input'!F$22*'User input'!F$77*(E16/1000)^'User input'!K$14))*'User input'!F$44)","v":204056.7375886525},{"$f":"IF(B16>'User input'!F$24,\"\",IF(B16>0,(P16-P15),0))","v":78014.184397163102},{"$f":"IF(B16>'User input'!F$24,\"\",Q16/'User input'!F$30)","v":1.560283687943262},{"$f":"IF(B16>'User input'!F$24,\"\",(J16+L16+O16+Q16)*('User input'!L$18+'User input'!L$19)-IF(B16='User input'!F$24,(F16-K16)*'User input'!L$18,0))","v":34071.962516220767},{"$f":"IF(B16>'User input'!F$24,\"\",L16+M16+N16+O16+Q16-S16)","v":53519.17775635932},{"$f":"IF(B16>'User input'!F$24,\"\",C16*T16)","v":47119.598806332047}]
[null,{"$f":"IF(B16>='User input'!F$24,\" \",B16+1)","v":5},{"$f":"IF(B17>'User input'!F$24,\"\",'User input'!L$35^B17)","v":0.85283534189579735},{"$f":"IF(B17>'User input'!F$24,\"\",IF(B17=0,'User input'!F$17,D16+1))","v":5},{"$f":"IF(B17>'User input'!F$24,\"\",IF(B17=0,'User input'!F$18,E16+'User input'!F$31))","v":5417.6516942474391},{"$f":"IF(B17>'User input'!F$24,\"\",EXP('User input'!G$14*(D17-'User input'!F$17)+'User input'!H$14*((E17-'User input'!F$18)/100)+'User input'!I$14*(D17-'User input'!F$17)*(E17-'User input'!F$18)/100)*'User input'!F$20*IF(B17=0,1,(1-'User input'!F$76)))","v":68474.227341894497},{"$f":"IF(B17>'User input'!F$24,\"\",IF(B17>0,F16*'User input'!L$16,0))","v":4242.2642366515993},{"$f":"IF(B17>'User input'!F$24,\"\",IF(B17>0,F16-F17,0))","v":16371.057391137481},{"$f":"IF(B17>'User input'!F$24,\"\",IF(B17>7,0,IF(SUM(I$11:I16)<1,IF(B17='User input'!F$24,'User input'!L30/2,'User input'!L30),0)))","v":8.9200000000000002E-2},{"$f":"IF(B17>'User input'!F$24,\"\",IF(B17=0,MIN('User input'!F$19,'User input'!L$20)+'User input'!L$22+'User input'!L$23*I17,'User input'!L$23*I17))","v":8920},{"$f":"IF(B17>'User input'!F$24,\"\",IF(B17=0,'User input'!F$19-J17,K16-J17))","v":13390},{"$f":"IF(B17>'User input'!F$24,\"\",IF(B17>0,('User input'!F$19-'User input'!F$21)*'User input'!L$16,0))","v":8000},{"$f":"IF(B17>'User input'!F$24,\"\",IF(B17='User input'!F$24,'User input'!F$19-'User input'!F$21,0))","v":0},{"$f":"IF(B17>'User input'!F$24,\"\",IF(B17=0,'User input'!F$21,IF(B17='User input'!F$24,-F17,0)))","v":0},{"$f":"IF(B17>'User input'!F$24,\"\",IF(B17>0,'User input'!F$47*F16,0))","v":1272.6792709954796},{"$f":"IF(B17>'User input'!F$24,\"\",(IF(E17>'User input'!L$14,(E17-'User input'!L$14)*'User input'!F$45+'User input'!J$14*'User input'!F$22*'User input'!F$77*('User input'!L$14/1000)^'User input'!K$14,'User input'!J$14*'User input'!F$22*'User input'!F$77*(E17/1000)^'User input'!K$14))*'User input'!F$44)","v":282070.92198581563},{"$f":"IF(B17>'User input'!F$24,\"\",IF(B17>0,(P17-P16),0))","v":78014.184397163132},{"$f":"IF(B17>'User input'!F$24,\"\",Q17/'User input'!F$30)","v":1.5602836879432627},{"$f":"IF(B17>'User input'!F$24,\"\",(J17+L17+O17+Q17)*('User input'!L$18+'User input'!L$19)-IF(B17='User input'!F$24,(F17-K17)*'User input'!L$18,0))","v":33961.022874859984},{"$f":"IF(B17>'User input'!F$24,\"\",L17+M17+N17+O17+Q17-S17)","v":53325.840793298623},{"$f":"IF(B17>'User input'!F$24,\"\",C17*T17)","v":45478.161664833686}]
[null,{"$f":"IF(B17>='User input'!F$24,\" \",B17+1)","v":6},{"$f":"IF(B18>'User input'!F$24,\"\",'User input'!L$35^B18)","v":0.82611066198072092},{"$f":"IF(B18>'User input'!F$24,\"\",IF(B18=0,'User input'!F$17,D17+1))","v":6},{"$f":"IF(B18>'User input'!F$24,\"\",IF(B18=0,'User input'!F$18,E17+'User input'!F$31))","v":6501.1820330969267},{"$f":"IF(B18>'User input'!F$24,\"\",EXP('User input'!G$14*(D18-'User input'!F$17)+'User input'!H$14*((E18-'User input'!F$18)/100)+'User input'!I$14*(D18-'User input'!F$17)*(E18-'User input'!F$18)/100)*'User input'!F$20*IF(B18=0,1,(1-'User input'!F$76)))","v":55261.996289159011},{"$f":"IF(B18>'User input'!F$24,\"\",IF(B18>0,F17*'User input'!L$16,0))","v":3423.7113670947251},{"$f":"IF(B18>'User input'!F$24,\"\",IF(B18>0,F17-F18,0))","v":13212.231052735486},{"$f":"IF(B18>'User input'!F$24,\"\",IF(B18>7,0,IF(SUM(I$11:I17)<1,IF(B18='User input'!F$24,'User input'!L31/2,'User input'!L31),0)))","v":8.9300000000000004E-2},{"$f":"IF(B18>'User input'!F$24,\"\",IF(B18=0,MIN('User input'!F$19,'User input'!L$20)+'User input'!L$22+'User input'!L$23*I18,'User input'!L$23*I18))","v":8930},{"$f":"IF(B18>'User input'!F$24,\"\",IF(B18=0,'User input'!F$19-J18,K17-J18))","v":4460},{"$f":"IF(B18>'User input'!F$24,\"\",IF(B18>0,('User input'!F$19-'User input'!F$21)*'User input'!L$16,0))","v":8000},{"$f":"IF(B18>'User input'!F$24,\"\",IF(B18='User input'!F$24,'User input'!F$19-'User input'!F$21,0))","v":0},{"$f":"IF(B18>'User input'!F$24,\"\",IF(B18=0,'User input'!F$21,IF(B18='User input'!F$24,-F18,0)))","v":0},{"$f":"IF(B18>'User input'!F$24,\"\",IF(B18>0,'User input'!F$47*F17,0))","v":1027.1134101284174},{"$f":"IF(B18>'User input'!F$24,\"\",(IF(E18>'User input'!L$14,(E18-'User input'!L$14)*'User input'!F$45+'User input'!J$14*'User input'!F$22*'User input'!F$77*('User input'!L$14/1000)^'User input'!K$14,'User input'!J$14*'User input'!F$22*'User input'!F$77*(E18/1000)^'User input'!K$14))*'User input'!F$44)","v":360085.10638297873},{"$f":"IF(B18>'User input'!F$24,\"\",IF(B18>0,(P18-P17),0))","v":78014.184397163102},{"$f":"IF(B18>'User input'!F$24,\"\",Q18/'User input'!F$30)","v":1.560283687943262},{"$f":"IF(B18>'User input'!F$24,\"\",(J18+L18+O18+Q18)*('User input'!L$18+'User input'!L$19)-IF(B18='User input'!F$24,(F18-K18)*'User input'!L$18,0))","v":33877.86812597391},{"$f":"IF(B18>'User input'!F$24,\"\",L18+M18+N18+O18+Q18-S18)","v":53163.429681317604},{"$f":"IF(B18>'User input'!F$24,\"\",C18*T18)","v":43918.876087198791}]
[null,{"$f":"IF(B18>='User input'!F$24,\" \",B18+1)","v":7},{"$f":"IF(B19>'User input'!F$24,\"\",'User input'!L$35^B19)","v":0.80022343389424211},{"$f":"IF(B19>'User input'!F$24,\"\",IF(B19=0,'User input'!F$17,D18+1))","v":7},{"$f":"IF(B19>'User input'!F$24,\"\",IF(B19=0,'User input'!F$18,E18+'User input'!F$31))","v":7584.7123719464144},{"$f":"IF(B19>'User input'!F$24,\"\",EXP('User input'!G$14*(D19-'User input'!F$17)+'User input'!H$14*((E19-'User input'!F$18)/100)+'User input'!I$14*(D19-'User input'!F$17)*(E19-'User input'!F$18)/100)*'User input'!F$20*IF(B19=0,1,(1-'User input'!F$76)))","v":44599.090087060649},{"$f":"IF(B19>'User input'!F$24,\"\",IF(B19>0,F18*'User input'!L$16,0))","v":2763.0998144579507},{"$f":"IF(B19>'User input'!F$24,\"\",IF(B19>0,F18-F19,0))","v":10662.906202098362},{"$f":"IF(B19>'User input'!F$24,\"\",IF(B19>7,0,IF(SUM(I$11:I18)<1,IF(B19='User input'!F$24,'User input'!L32/2,'User input'!L32),0)))","v":2.23E-2},{"$f":"IF(B19>'User input'!F$24,\"\",IF(B19=0,MIN('User input'!F$19,'User input'!L$20)+'User input'!L$22+'User input'!L$23*I19,'User input'!L$23*I19))","v":2230},{"$f":"IF(B19>'User input'!F$24,\"\",IF(B19=0,'User input'!F$19-J19,K18-J19))","v":2230},{"$f":"IF(B19>'User input'!F$24,\"\",IF(B19>0,('User input'!F$19-'User input'!F$21)*'User input'!L$16,0))","v":8000},{"$f":"IF(B19>'User input'!F$24,\"\",IF(B19='User input'!F$24,'User input'!F$19-'User input'!F$21,0))","v":160000},{"$f":"IF(B19>'User input'!F$24,\"\",IF(B19=0,'User input'!F$21,IF(B19='User input'!F$24,-F19,0)))","v":-44599.090087060649},{"$f":"IF(B19>'User input'!F$24,\"\",IF(B19>0,'User input'!F$47*F18,0))","v":828.92994433738511},{"$f":"IF(B19>'User input'!F$24,\"\",(IF(E19>'User input'!L$14,(E19-'User input'!L$14)*'User input'!F$45+'User input'!J$14*'User input'!F$22*'User input'!F$77*('User input'!L$14/1000)^'User input'!K$14,'User input'!J$14*'User input'!F$22*'User input'!F$77*(E19/1000)^'User input'!K$14))*'User input'!F$44)","v":438099.29078014183},{"$f":"IF(B19>'User input'!F$24,\"\",IF(B19>0,(P19-P18),0))","v":78014.184397163102},{"$f":"IF(B19>'User input'!F$24,\"\",Q19/'User input'!F$30)","v":1.560283687943262},{"$f":"IF(B19>'User input'!F$24,\"\",(J19+L19+O19+Q19)*('User input'!L$18+'User input'!L$19)-IF(B19='User input'!F$24,(F19-K19)*'User input'!L$18,0))","v":22968.991345137543},{"$f":"IF(B19>'User input'!F$24,\"\",L19+M19+N19+O19+Q19-S19)","v":179275.03290930233},{"$f":"IF(B19>'User input'!F$24,\"\",C19*T19)","v":143460.08244618517}]
[null,{"$f":"IF(B19>='User input'!F$24,\" \",B19+1)","v":" "},{"$f":"IF(B20>'User input'!F$24,\"\",'User input'!L$35^B20)","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",IF(B20=0,'User input'!F$17,D19+1))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",IF(B20=0,'User input'!F$18,E19+'User input'!F$31))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",EXP('User input'!G$14*(D20-'User input'!F$17)+'User input'!H$14*((E20-'User input'!F$18)/100)+'User input'!I$14*(D20-'User input'!F$17)*(E20-'User input'!F$18)/100)*'User input'!F$20*IF(B20=0,1,(1-'User input'!F$76)))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",IF(B20>0,F19*'User input'!L$16,0))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",IF(B20>0,F19-F20,0))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",IF(B20>7,0,IF(SUM(I$11:I19)<1,IF(B20='User input'!F$24,'User input'!L33/2,'User input'!L33),0)))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",IF(B20=0,MIN('User input'!F$19,'User input'!L$20)+'User input'!L$22+'User input'!L$23*I20,'User input'!L$23*I20))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",IF(B20=0,'User input'!F$19-J20,K19-J20))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",IF(B20>0,('User input'!F$19-'User input'!F$21)*'User input'!L$16,0))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",IF(B20='User input'!F$24,'User input'!F$19-'User input'!F$21,0))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",IF(B20=0,'User input'!F$21,IF(B20='User input'!F$24,-F20,0)))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",IF(B20>0,'User input'!F$47*F19,0))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",(IF(E20>'User input'!L$14,(E20-'User input'!L$14)*'User input'!F$45+'User input'!J$14*'User input'!F$22*'User input'!F$77*('User input'!L$14/1000)^'User input'!K$14,'User input'!J$14*'User input'!F$22*'User input'!F$77*(E20/1000)^'User input'!K$14))*'User input'!F$44)","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",IF(B20>0,(P20-P19),0))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",Q20/'User input'!F$30)","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",(J20+L20+O20+Q20)*('User input'!L$18+'User input'!L$19)-IF(B20='User input'!F$24,(F20-K20)*'User input'!L$18,0))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",L20+M20+N20+O20+Q20-S20)","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",C20*T20)","v":""}]
[null,{"$f":"IF(B20>='User input'!F$24,\" \",B20+1)","v":" "},{"$f":"IF(B21>'User input'!F$24,\"\",'User input'!L$35^B21)","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",IF(B21=0,'User input'!F$17,D20+1))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",IF(B21=0,'User input'!F$18,E20+'User input'!F$31))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",EXP('User input'!G$14*(D21-'User input'!F$17)+'User input'!H$14*((E21-'User input'!F$18)/100)+'User input'!I$14*(D21-'User input'!F$17)*(E21-'User input'!F$18)/100)*'User input'!F$20*IF(B21=0,1,(1-'User input'!F$76)))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",IF(B21>0,F20*'User input'!L$16,0))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",IF(B21>0,F20-F21,0))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",IF(B21>7,0,IF(SUM(I$11:I20)<1,IF(B21='User input'!F$24,'User input'!L34/2,'User input'!L34),0)))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",IF(B21=0,MIN('User input'!F$19,'User input'!L$20)+'User input'!L$22+'User input'!L$23*I21,'User input'!L$23*I21))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",IF(B21=0,'User input'!F$19-J21,K20-J21))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",IF(B21>0,('User input'!F$19-'User input'!F$21)*'User input'!L$16,0))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",IF(B21='User input'!F$24,'User input'!F$19-'User input'!F$21,0))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",IF(B21=0,'User input'!F$21,IF(B21='User input'!F$24,-F21,0)))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",IF(B21>0,'User input'!F$47*F20,0))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",(IF(E21>'User input'!L$14,(E21-'User input'!L$14)*'User input'!F$45+'User input'!J$14*'User input'!F$22*'User input'!F$77*('User input'!L$14/1000)^'User input'!K$14,'User input'!J$14*'User input'!F$22*'User input'!F$77*(E21/1000)^'User input'!K$14))*'User input'!F$44)","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",IF(B21>0,(P21-P20),0))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",Q21/'User input'!F$30)","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",(J21+L21+O21+Q21)*('User input'!L$18+'User input'!L$19)-IF(B21='User input'!F$24,(F21-K21)*'User input'!L$18,0))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",L21+M21+N21+O21+Q21-S21)","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",C21*T21)","v":""}]
[null,{"$f":"IF(B21>='User input'!F$24,\" \",B21+1)","v":" "},{"$f":"IF(B22>'User input'!F$24,\"\",'User input'!L$35^B22)","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",IF(B22=0,'User input'!F$17,D21+1))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",IF(B22=0,'User input'!F$18,E21+'User input'!F$31))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",EXP('User input'!G$14*(D22-'User input'!F$17)+'User input'!H$14*((E22-'User input'!F$18)/100)+'User input'!I$14*(D22-'User input'!F$17)*(E22-'User input'!F$18)/100)*'User input'!F$20*IF(B22=0,1,(1-'User input'!F$76)))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",IF(B22>0,F21*'User input'!L$16,0))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",IF(B22>0,F21-F22,0))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",IF(B22>7,0,IF(SUM(I$11:I21)<1,IF(B22='User input'!F$24,'User input'!L35/2,'User input'!L35),0)))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",IF(B22=0,MIN('User input'!F$19,'User input'!L$20)+'User input'!L$22+'User input'!L$23*I22,'User input'!L$23*I22))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",IF(B22=0,'User input'!F$19-J22,K21-J22))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",IF(B22>0,('User input'!F$19-'User input'!F$21)*'User input'!L$16,0))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",IF(B22='User input'!F$24,'User input'!F$19-'User input'!F$21,0))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",IF(B22=0,'User input'!F$21,IF(B22='User input'!F$24,-F22,0)))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",IF(B22>0,'User input'!F$47*F21,0))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",(IF(E22>'User input'!L$14,(E22-'User input'!L$14)*'User input'!F$45+'User input'!J$14*'User input'!F$22*'User input'!F$77*('User input'!L$14/1000)^'User input'!K$14,'User input'!J$14*'User input'!F$22*'User input'!F$77*(E22/1000)^'User input'!K$14))*'User input'!F$44)","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",IF(B22>0,(P22-P21),0))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",Q22/'User input'!F$30)","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",(J22+L22+O22+Q22)*('User input'!L$18+'User input'!L$19)-IF(B22='User input'!F$24,(F22-K22)*'User input'!L$18,0))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",L22+M22+N22+O22+Q22-S22)","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",C22*T22)","v":""}]
[null,{"$f":"IF(B22>='User input'!F$24,\" \",B22+1)","v":" "},{"$f":"IF(B23>'User input'!F$24,\"\",'User input'!L$35^B23)","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",IF(B23=0,'User input'!F$17,D22+1))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",IF(B23=0,'User input'!F$18,E22+'User input'!F$31))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",EXP('User input'!G$14*(D23-'User input'!F$17)+'User input'!H$14*((E23-'User input'!F$18)/100)+'User input'!I$14*(D23-'User input'!F$17)*(E23-'User input'!F$18)/100)*'User input'!F$20*IF(B23=0,1,(1-'User input'!F$76)))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",IF(B23>0,F22*'User input'!L$16,0))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",IF(B23>0,F22-F23,0))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",IF(B23>7,0,IF(SUM(I$11:I22)<1,IF(B23='User input'!F$24,'User input'!#REF!/2,'User input'!#REF!),0)))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",IF(B23=0,MIN('User input'!F$19,'User input'!L$20)+'User input'!L$22+'User input'!L$23*I23,'User input'!L$23*I23))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",IF(B23=0,'User input'!F$19-J23,K22-J23))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",IF(B23>0,('User input'!F$19-'User input'!F$21)*'User input'!L$16,0))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",IF(B23='User input'!F$24,'User input'!F$19-'User input'!F$21,0))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",IF(B23=0,'User input'!F$21,IF(B23='User input'!F$24,-F23,0)))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",IF(B23>0,'User input'!F$47*F22,0))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",(IF(E23>'User input'!L$14,(E23-'User input'!L$14)*'User input'!F$45+'User input'!J$14*'User input'!F$22*'User input'!F$77*('User input'!L$14/1000)^'User input'!K$14,'User input'!J$14*'User input'!F$22*'User input'!F$77*(E23/1000)^'User input'!K$14))*'User input'!F$44)","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",IF(B23>0,(P23-P22),0))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",Q23/'User input'!F$30)","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",(J23+L23+O23+Q23)*('User input'!L$18+'User input'!L$19)-IF(B23='User input'!F$24,(F23-K23)*'User input'!L$18,0))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",L23+M23+N23+O23+Q23-S23)","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",C23*T23)","v":""}]
[null,{"$f":"IF(B23>='User input'!F$24,\" \",B23+1)","v":" "},{"$f":"IF(B24>'User input'!F$24,\"\",'User input'!L$35^B24)","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",IF(B24=0,'User input'!F$17,D23+1))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",IF(B24=0,'User input'!F$18,E23+'User input'!F$31))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",EXP('User input'!G$14*(D24-'User input'!F$17)+'User input'!H$14*((E24-'User input'!F$18)/100)+'User input'!I$14*(D24-'User input'!F$17)*(E24-'User input'!F$18)/100)*'User input'!F$20*IF(B24=0,1,(1-'User input'!F$76)))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",IF(B24>0,F23*'User input'!L$16,0))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",IF(B24>0,F23-F24,0))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",IF(B24>7,0,IF(SUM(I$11:I23)<1,IF(B24='User input'!F$24,'User input'!F38/2,'User input'!F38),0)))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",IF(B24=0,MIN('User input'!F$19,'User input'!L$20)+'User input'!L$22+'User input'!L$23*I24,'User input'!L$23*I24))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",IF(B24=0,'User input'!F$19-J24,K23-J24))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",IF(B24>0,('User input'!F$19-'User input'!F$21)*'User input'!L$16,0))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",IF(B24='User input'!F$24,'User input'!F$19-'User input'!F$21,0))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",IF(B24=0,'User input'!F$21,IF(B24='User input'!F$24,-F24,0)))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",IF(B24>0,'User input'!F$47*F23,0))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",(IF(E24>'User input'!L$14,(E24-'User input'!L$14)*'User input'!F$45+'User input'!J$14*'User input'!F$22*'User input'!F$77*('User input'!L$14/1000)^'User input'!K$14,'User input'!J$14*'User input'!F$22*'User input'!F$77*(E24/1000)^'User input'!K$14))*'User input'!F$44)","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",IF(B24>0,(P24-P23),0))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",Q24/'User input'!F$30)","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",(J24+L24+O24+Q24)*('User input'!L$18+'User input'!L$19)-IF(B24='User input'!F$24,(F24-K24)*'User input'!L$18,0))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",L24+M24+N24+O24+Q24-S24)","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",C24*T24)","v":""}]
[null,{"$f":"IF(B24>='User input'!F$24,\" \",B24+1)","v":" "},{"$f":"IF(B25>'User input'!F$24,\"\",'User input'!L$35^B25)","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",IF(B25=0,'User input'!F$17,D24+1))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",IF(B25=0,'User input'!F$18,E24+'User input'!F$31))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",EXP('User input'!G$14*(D25-'User input'!F$17)+'User input'!H$14*((E25-'User input'!F$18)/100)+'User input'!I$14*(D25-'User input'!F$17)*(E25-'User input'!F$18)/100)*'User input'!F$20*IF(B25=0,1,(1-'User input'!F$76)))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",IF(B25>0,F24*'User input'!L$16,0))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",IF(B25>0,F24-F25,0))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",IF(B25>7,0,IF(SUM(I$11:I24)<1,IF(B25='User input'!F$24,'User input'!F39/2,'User input'!F39),0)))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",IF(B25=0,MIN('User input'!F$19,'User input'!L$20)+'User input'!L$22+'User input'!L$23*I25,'User input'!L$23*I25))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",IF(B25=0,'User input'!F$19-J25,K24-J25))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",IF(B25>0,('User input'!F$19-'User input'!F$21)*'User input'!L$16,0))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",IF(B25='User input'!F$24,'User input'!F$19-'User input'!F$21,0))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",IF(B25=0,'User input'!F$21,IF(B25='User input'!F$24,-F25,0)))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",IF(B25>0,'User input'!F$47*F24,0))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",(IF(E25>'User input'!L$14,(E25-'User input'!L$14)*'User input'!F$45+'User input'!J$14*'User input'!F$22*'User input'!F$77*('User input'!L$14/1000)^'User input'!K$14,'User input'!J$14*'User input'!F$22*'User input'!F$77*(E25/1000)^'User input'!K$14))*'User input'!F$44)","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",IF(B25>0,(P25-P24),0))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",Q25/'User input'!F$30)","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",(J25+L25+O25+Q25)*('User input'!L$18+'User input'!L$19)-IF(B25='User input'!F$24,(F25-K25)*'User input'!L$18,0))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",L25+M25+N25+O25+Q25-S25)","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",C25*T25)","v":""}]
[null,{"$f":"IF(B25>='User input'!F$24,\" \",B25+1)","v":" "},{"$f":"IF(B26>'User input'!F$24,\"\",'User input'!L$35^B26)","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",IF(B26=0,'User input'!F$17,D25+1))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",IF(B26=0,'User input'!F$18,E25+'User input'!F$31))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",EXP('User input'!G$14*(D26-'User input'!F$17)+'User input'!H$14*((E26-'User input'!F$18)/100)+'User input'!I$14*(D26-'User input'!F$17)*(E26-'User input'!F$18)/100)*'User input'!F$20*IF(B26=0,1,(1-'User input'!F$76)))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",IF(B26>0,F25*'User input'!L$16,0))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",IF(B26>0,F25-F26,0))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",IF(B26>7,0,IF(SUM(I$11:I25)<1,IF(B26='User input'!F$24,'User input'!F40/2,'User input'!F40),0)))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",IF(B26=0,MIN('User input'!F$19,'User input'!L$20)+'User input'!L$22+'User input'!L$23*I26,'User input'!L$23*I26))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",IF(B26=0,'User input'!F$19-J26,K25-J26))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",IF(B26>0,('User input'!F$19-'User input'!F$21)*'User input'!L$16,0))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",IF(B26='User input'!F$24,'User input'!F$19-'User input'!F$21,0))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",IF(B26=0,'User input'!F$21,IF(B26='User input'!F$24,-F26,0)))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",IF(B26>0,'User input'!F$47*F25,0))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",(IF(E26>'User input'!L$14,(E26-'User input'!L$14)*'User input'!F$45+'User input'!J$14*'User input'!F$22*'User input'!F$77*('User input'!L$14/1000)^'User input'!K$14,'User input'!J$14*'User input'!F$22*'User input'!F$77*(E26/1000)^'User input'!K$14))*'User input'!F$44)","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",IF(B26>0,(P26-P25),0))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",Q26/'User input'!F$30)","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",(J26+L26+O26+Q26)*('User input'!L$18+'User input'!L$19)-IF(B26='User input'!F$24,(F26-K26)*'User input'!L$18,0))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",L26+M26+N26+O26+Q26-S26)","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",C26*T26)","v":""}]
[null,{"$f":"IF(B26>='User input'!F$24,\" \",B26+1)","v":" "},{"$f":"IF(B27>'User input'!F$24,\"\",'User input'!L$35^B27)","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",IF(B27=0,'User input'!F$17,D26+1))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",IF(B27=0,'User input'!F$18,E26+'User input'!F$31))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",EXP('User input'!G$14*(D27-'User input'!F$17)+'User input'!H$14*((E27-'User input'!F$18)/100)+'User input'!I$14*(D27-'User input'!F$17)*(E27-'User input'!F$18)/100)*'User input'!F$20*IF(B27=0,1,(1-'User input'!F$76)))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",IF(B27>0,F26*'User input'!L$16,0))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",IF(B27>0,F26-F27,0))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",IF(B27>7,0,IF(SUM(I$11:I26)<1,IF(B27='User input'!F$24,'User input'!F41/2,'User input'!F41),0)))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",IF(B27=0,MIN('User input'!F$19,'User input'!L$20)+'User input'!L$22+'User input'!L$23*I27,'User input'!L$23*I27))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",IF(B27=0,'User input'!F$19-J27,K26-J27))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",IF(B27>0,('User input'!F$19-'User input'!F$21)*'User input'!L$16,0))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",IF(B27='User input'!F$24,'User input'!F$19-'User input'!F$21,0))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",IF(B27=0,'User input'!F$21,IF(B27='User input'!F$24,-F27,0)))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",IF(B27>0,'User input'!F$47*F26,0))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",(IF(E27>'User input'!L$14,(E27-'User input'!L$14)*'User input'!F$45+'User input'!J$14*'User input'!F$22*'User input'!F$77*('User input'!L$14/1000)^'User input'!K$14,'User input'!J$14*'User input'!F$22*'User input'!F$77*(E27/1000)^'User input'!K$14))*'User input'!F$44)","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",IF(B27>0,(P27-P26),0))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",Q27/'User input'!F$30)","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",(J27+L27+O27+Q27)*('User input'!L$18+'User input'!L$19)-IF(B27='User input'!F$24,(F27-K27)*'User input'!L$18,0))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",L27+M27+N27+O27+Q27-S27)","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",C27*T27)","v":""}]
[null,{"$f":"IF(B27>='User input'!F$24,\" \",B27+1)","v":" "},{"$f":"IF(B28>'User input'!F$24,\"\",'User input'!L$35^B28)","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",IF(B28=0,'User input'!F$17,D27+1))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",IF(B28=0,'User input'!F$18,E27+'User input'!F$31))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",EXP('User input'!G$14*(D28-'User input'!F$17)+'User input'!H$14*((E28-'User input'!F$18)/100)+'User input'!I$14*(D28-'User input'!F$17)*(E28-'User input'!F$18)/100)*'User input'!F$20*IF(B28=0,1,(1-'User input'!F$76)))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",IF(B28>0,F27*'User input'!L$16,0))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",IF(B28>0,F27-F28,0))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",IF(B28>7,0,IF(SUM(I$11:I27)<1,IF(B28='User input'!F$24,'User input'!F42/2,'User input'!F42),0)))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",IF(B28=0,MIN('User input'!F$19,'User input'!L$20)+'User input'!L$22+'User input'!L$23*I28,'User input'!L$23*I28))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",IF(B28=0,'User input'!F$19-J28,K27-J28))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",IF(B28>0,('User input'!F$19-'User input'!F$21)*'User input'!L$16,0))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",IF(B28='User input'!F$24,'User input'!F$19-'User input'!F$21,0))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",IF(B28=0,'User input'!F$21,IF(B28='User input'!F$24,-F28,0)))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",IF(B28>0,'User input'!F$47*F27,0))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",(IF(E28>'User input'!L$14,(E28-'User input'!L$14)*'User input'!F$45+'User input'!J$14*'User input'!F$22*'User input'!F$77*('User input'!L$14/1000)^'User input'!K$14,'User input'!J$14*'User input'!F$22*'User input'!F$77*(E28/1000)^'User input'!K$14))*'User input'!F$44)","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",IF(B28>0,(P28-P27),0))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",Q28/'User input'!F$30)","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",(J28+L28+O28+Q28)*('User input'!L$18+'User input'!L$19)-IF(B28='User input'!F$24,(F28-K28)*'User input'!L$18,0))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",L28+M28+N28+O28+Q28-S28)","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",C28*T28)","v":""}]
[null,{"$f":"IF(B28>='User input'!F$24,\" \",B28+1)","v":" "},{"$f":"IF(B29>'User input'!F$24,\"\",'User input'!L$35^B29)","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",IF(B29=0,'User input'!F$17,D28+1))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",IF(B29=0,'User input'!F$18,E28+'User input'!F$31))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",EXP('User input'!G$14*(D29-'User input'!F$17)+'User input'!H$14*((E29-'User input'!F$18)/100)+'User input'!I$14*(D29-'User input'!F$17)*(E29-'User input'!F$18)/100)*'User input'!F$20*IF(B29=0,1,(1-'User input'!F$76)))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",IF(B29>0,F28*'User input'!L$16,0))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",IF(B29>0,F28-F29,0))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",IF(B29>7,0,IF(SUM(I$11:I28)<1,IF(B29='User input'!F$24,'User input'!F35/2,'User input'!F35),0)))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",IF(B29=0,MIN('User input'!F$19,'User input'!L$20)+'User input'!L$22+'User input'!L$23*I29,'User input'!L$23*I29))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",IF(B29=0,'User input'!F$19-J29,K28-J29))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",IF(B29>0,('User input'!F$19-'User input'!F$21)*'User input'!L$16,0))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",IF(B29='User input'!F$24,'User input'!F$19-'User input'!F$21,0))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",IF(B29=0,'User input'!F$21,IF(B29='User input'!F$24,-F29,0)))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",IF(B29>0,'User input'!F$47*F28,0))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",(IF(E29>'User input'!L$14,(E29-'User input'!L$14)*'User input'!F$45+'User input'!J$14*'User input'!F$22*'User input'!F$77*('User input'!L$14/1000)^'User input'!K$14,'User input'!J$14*'User input'!F$22*'User input'!F$77*(E29/1000)^'User input'!K$14))*'User input'!F$44)","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",IF(B29>0,(P29-P28),0))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",Q29/'User input'!F$30)","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",(J29+L29+O29+Q29)*('User input'!L$18+'User input'!L$19)-IF(B29='User input'!F$24,(F29-K29)*'User input'!L$18,0))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",L29+M29+N29+O29+Q29-S29)","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",C29*T29)","v":""}]
[null,{"$f":"IF(B29>='User input'!F$24,\" \",B29+1)","v":" "},{"$f":"IF(B30>'User input'!F$24,\"\",'User input'!L$35^B30)","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",IF(B30=0,'User input'!F$17,D29+1))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",IF(B30=0,'User input'!F$18,E29+'User input'!F$31))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",EXP('User input'!G$14*(D30-'User input'!F$17)+'User input'!H$14*((E30-'User input'!F$18)/100)+'User input'!I$14*(D30-'User input'!F$17)*(E30-'User input'!F$18)/100)*'User input'!F$20*IF(B30=0,1,(1-'User input'!F$76)))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",IF(B30>0,F29*'User input'!L$16,0))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",IF(B30>0,F29-F30,0))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",IF(B30>7,0,IF(SUM(I$11:I29)<1,IF(B30='User input'!F$24,'User input'!F36/2,'User input'!F36),0)))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",IF(B30=0,MIN('User input'!F$19,'User input'!L$20)+'User input'!L$22+'User input'!L$23*I30,'User input'!L$23*I30))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",IF(B30=0,'User input'!F$19-J30,K29-J30))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",IF(B30>0,('User input'!F$19-'User input'!F$21)*'User input'!L$16,0))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",IF(B30='User input'!F$24,'User input'!F$19-'User input'!F$21,0))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",IF(B30=0,'User input'!F$21,IF(B30='User input'!F$24,-F30,0)))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",IF(B30>0,'User input'!F$47*F29,0))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",(IF(E30>'User input'!L$14,(E30-'User input'!L$14)*'User input'!F$45+'User input'!J$14*'User input'!F$22*'User input'!F$77*('User input'!L$14/1000)^'User input'!K$14,'User input'!J$14*'User input'!F$22*'User input'!F$77*(E30/1000)^'User input'!K$14))*'User input'!F$44)","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",IF(B30>0,(P30-P29),0))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",Q30/'User input'!F$30)","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",(J30+L30+O30+Q30)*('User input'!L$18+'User input'!L$19)-IF(B30='User input'!F$24,(F30-K30)*'User input'!L$18,0))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",L30+M30+N30+O30+Q30-S30)","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",C30*T30)","v":""}]
[null,{"$f":"IF(B30>='User input'!F$24,\" \",B30+1)","v":" "},{"$f":"IF(B31>'User input'!F$24,\"\",'User input'!L$35^B31)","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",IF(B31=0,'User input'!F$17,D30+1))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",IF(B31=0,'User input'!F$18,E30+'User input'!F$31))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",EXP('User input'!G$14*(D31-'User input'!F$17)+'User input'!H$14*((E31-'User input'!F$18)/100)+'User input'!I$14*(D31-'User input'!F$17)*(E31-'User input'!F$18)/100)*'User input'!F$20*IF(B31=0,1,(1-'User input'!F$76)))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",IF(B31>0,F30*'User input'!L$16,0))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",IF(B31>0,F30-F31,0))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",IF(B31>7,0,IF(SUM(I$11:I30)<1,IF(B31='User input'!F$24,'User input'!#REF!/2,'User input'!#REF!),0)))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",IF(B31=0,MIN('User input'!F$19,'User input'!L$20)+'User input'!L$22+'User input'!L$23*I31,'User input'!L$23*I31))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",IF(B31=0,'User input'!F$19-J31,K30-J31))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",IF(B31>0,('User input'!F$19-'User input'!F$21)*'User input'!L$16,0))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",IF(B31='User input'!F$24,'User input'!F$19-'User input'!F$21,0))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",IF(B31=0,'User input'!F$21,IF(B31='User input'!F$24,-F31,0)))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",IF(B31>0,'User input'!F$47*F30,0))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",(IF(E31>'User input'!L$14,(E31-'User input'!L$14)*'User input'!F$45+'User input'!J$14*'User input'!F$22*'User input'!F$77*('User input'!L$14/1000)^'User input'!K$14,'User input'!J$14*'User input'!F$22*'User input'!F$77*(E31/1000)^'User input'!K$14))*'User input'!F$44)","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",IF(B31>0,(P31-P30),0))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",Q31/'User input'!F$30)","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",(J31+L31+O31+Q31)*('User input'!L$18+'User input'!L$19)-IF(B31='User input'!F$24,(F31-K31)*'User input'!L$18,0))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",L31+M31+N31+O31+Q31-S31)","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",C31*T31)","v":""}]
[null,{"$f":"IF(B31>='User input'!F$24,\" \",B31+1)","v":" "},{"$f":"IF(B32>'User input'!F$24,\"\",'User input'!L$35^B32)","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",IF(B32=0,'User input'!F$17,D31+1))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",IF(B32=0,'User input'!F$18,E31+'User input'!F$31))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",EXP('User input'!G$14*(D32-'User input'!F$17)+'User input'!H$14*((E32-'User input'!F$18)/100)+'User input'!I$14*(D32-'User input'!F$17)*(E32-'User input'!F$18)/100)*'User input'!F$20*IF(B32=0,1,(1-'User input'!F$76)))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",IF(B32>0,F31*'User input'!L$16,0))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",IF(B32>0,F31-F32,0))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",IF(B32>7,0,IF(SUM(I$11:I31)<1,IF(B32='User input'!F$24,'User input'!L37/2,'User input'!L37),0)))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",IF(B32=0,MIN('User input'!F$19,'User input'!L$20)+'User input'!L$22+'User input'!L$23*I32,'User input'!L$23*I32))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",IF(B32=0,'User input'!F$19-J32,K31-J32))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",IF(B32>0,('User input'!F$19-'User input'!F$21)*'User input'!L$16,0))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",IF(B32='User input'!F$24,'User input'!F$19-'User input'!F$21,0))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",IF(B32=0,'User input'!F$21,IF(B32='User input'!F$24,-F32,0)))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",IF(B32>0,'User input'!F$47*F31,0))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",(IF(E32>'User input'!L$14,(E32-'User input'!L$14)*'User input'!F$45+'User input'!J$14*'User input'!F$22*'User input'!F$77*('User input'!L$14/1000)^'User input'!K$14,'User input'!J$14*'User input'!F$22*'User input'!F$77*(E32/1000)^'User input'!K$14))*'User input'!F$44)","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",IF(B32>0,(P32-P31),0))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",Q32/'User input'!F$30)","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",(J32+L32+O32+Q32)*('User input'!L$18+'User input'!L$19)-IF(B32='User input'!F$24,(F32-K32)*'User input'!L$18,0))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",L32+M32+N32+O32+Q32-S32)","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",C32*T32)","v":""}]
[]
[]
[null,"* EOY = End of year",null,null,null,null,null,null,{"$f":"IF(OR('User input'!L33>1.01,'User input'!L33<0.99),\"Total depreciation rate should add to 100%\",\" \")","v":" "}]
[null,"** TIS = Property tax, insurance, and shelter",null,null,null,null,null,null,{"$f":"IF(OR('User input'!L33>1.01,'User input'!L33<0.99),\"Go back to User Input tab and check entered values!\",\" \")","v":" "}]

{"sheet":"Analysis summary","index":3,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Sprayer analysis summary section"]
[]
[null,"Analysis highlights:"]
[null,"Sprayer purchase price",null,null,{"$f":"'User input'!F19","v":200000}]
[null,"Sprayer age when purchased",null,null,{"$f":"'User input'!F17","v":0}]
[null,"Hours on sprayer when purchased",null,null,{"$f":"'User input'!F18","v":0}]
[null,"Total acres covered per year",null,null,{"$f":"'User input'!F30","v":50000}]
[null,"Hours used per year",null,null,{"$f":"'User input'!F31","v":1083.5303388494879}]
[null,"Number of years sprayer is used",null,null,{"$f":"'User input'!F24","v":7}]
[]
[]
[null,"Cost breakdown (total cost can be compared to custom rates):"]
[]
[null,null,null,null,"$/year","$/hour","$/acre"]
[null,"Opportunity interest",null,null,{"$f":"'User input'!L44","v":5731.5220838646583},{"$f":"E16/E$9","v":5.2896738359449094},{"$f":"E16/E$8","v":0.11463044167729317}]
[null,"Market depreciation",null,null,{"$f":"'User input'!L45","v":22118.159487297904},20.413050465004392,0.44236318974595806]
[null,"Repair and maintenance",null,null,{"$f":"'User input'!L46","v":59530.789972877385},54.941507254968286,1.1906157994575477]
[null,"Labor",null,null,{"$f":"'User input'!F35*'User input'!F34*E9","v":20316.193853427896},18.75,0.40632387706855794]
[null,"Fuel and lubrication",null,null,{"$f":"'User input'!F41*E9","v":26817.375886524827},24.750000000000004,0.53634751773049649]
[null,"Tax, insurance, & shelter (TIS)",null,null,{"$f":"'User input'!L47","v":1719.4566251593974},1.5869021507834729,3.4389132503187946E-2]
[]
[null,"Total for sprayer only",null,null,{"$f":"SUM(E16:E21)","v":136233.49790915207},{"$f":"SUM(F16:F21)","v":125.73113370670106},{"$f":"SUM(G16:G21)","v":2.7246699581830409}]
[]
[null,"Tendering cost",null,null,{"$f":"'User input'!L39*E8","v":73002.364066193841},{"$f":"E25/E$9","v":67.374545454545441},{"$f":"E25/E$8","v":1.4600472813238767}]
[]
[null,"Total for sprayer and tendering",null,null,{"$f":"E23+E25","v":209235.86197534591},{"$f":"F23+F25","v":193.10567916124648},{"$f":"G23+G25","v":4.1847172395069174}]
[]
[]
[null,"Date of analysis =====>",null,{"$f":"NOW()","v":"2016-07-07T14:12:32.920"}]