{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Introduction","User input","Time and Tax (TT)","Analysis summary"],"not_rendered":{"charts":1,"images":3,"macros":1,"external_links":1,"defined_names":21,"comments":2,"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":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[[43,1,44,11],[28,1,29,11],[30,1,31,11],[35,1,36,4],[35,6,36,10],[39,15,39,16],[40,1,40,3],[4,1,5,8],[4,13,5,23],[7,2,7,3],[7,4,7,5],[7,13,8,13],[27,1,27,4]]}
[]
[]
[null,"KSU-Own Combine"]
[]
[null,"An Excel spreadsheet to evaluate the economic costs of owning and operating a combine."]
[]
[]
[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,"With Questions contact:",null,null,null,null,"Originally Developed by:"]
[]
[null,"Rich Llewelyn",null,null,null,null,"Terry L. Kastens, Ph.D.",null,null,null,"Kevin C. Dhuyvetter, Ph.D."]
[null,"Extension Assistant",null,null,null,null,"Emeritus Agricultural Economist",null,null,null,"Former Agricultural Economist"]
[null,"Kansas State University",null,null,null,null,"Kansas State University",null,null,null,"Kansas State University"]
[null,"rvl@ksu.edu"]
[null,"785-532-1504"]
[]
[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 combine depreciation and repairs"]
[null,null,null,null,null,null,null,null,null,"repair factors"]
[null,"Combine class",null,null,null,null,"age","100 hrs","age*100hrs","RF1","RF2","useful life"]
[null,1,"JD 9670STS (spread 8r corn 30' rigid)",null,null,null,-9.3716922929405477E-2,-2.8173236964901704E-2,1.5204710545111411E-3,0.04,2.1,3000]
[null,2,"JD 9770STS (spread 12r corn 36' draper)",null,null,null,-4.977727849988689E-2,-3.0907359816129798E-2,1.5124023926249563E-4,0.04,2.1,3000]
[null,3,"AGCO R75 (spread 12r corn 36' draper)",null,null,null,-5.5594748747834544E-2,-1.7779504234320953E-2,-7.7802626359957383E-4,0.04,2.1,3000]
[null,4,"Case-IH 2588 (spread 8r corn 30' rigid)",null,null,null,-4.7097098925792835E-2,-2.5067889121032749E-2,-6.4932937438055838E-4,0.04,2.1,3000]
[null,null,"Factors used in analysis =>",null,null,{"$f":"IF($F13=1,C7,IF($F13=2,C8,IF($F13=3,C9,IF($F13=4,C10,IF($F13=5,#REF!,IF($F13=6,#REF!,\"NA\"))))))","v":"JD 9670STS (spread 8r corn 30' rigid)"},{"$f":"IF($F13=1,G7,IF($F13=2,G8,IF($F13=3,G9,IF($F13=4,G10,IF($F13=5,#REF!,IF($F13=6,#REF!,\"NA\"))))))","v":-9.3716922929405477E-2},{"$f":"IF($F13=1,H7,IF($F13=2,H8,IF($F13=3,H9,IF($F13=4,H10,IF($F13=5,#REF!,IF($F13=6,#REF!,\"NA\"))))))","v":-2.8173236964901704E-2},{"$f":"IF($F13=1,I7,IF($F13=2,I8,IF($F13=3,I9,IF($F13=4,I10,IF($F13=5,#REF!,IF($F13=6,#REF!,\"NA\"))))))","v":1.5204710545111411E-3},{"$f":"IF($F13=1,J7,IF($F13=2,J8,IF($F13=3,J9,IF($F13=4,J10,IF($F13=5,#REF!,IF($F13=6,#REF!,\"NA\"))))))","v":0.04},{"$f":"IF($F13=1,K7,IF($F13=2,K8,IF($F13=3,K9,IF($F13=4,K10,IF($F13=5,#REF!,IF($F13=6,#REF!,\"NA\"))))))","v":2.1},{"$f":"IF($F13=1,L7,IF($F13=2,L8,IF($F13=3,L9,IF($F13=4,L10,IF($F13=5,#REF!,IF($F13=6,#REF!,\"NA\"))))))","v":3000}]
[]
[null,"Combine class (1-4)",null,null,null,1,null,"Bank interest rate (enter as decimal)",null,null,null,0.05]
[null,"Combine age in years",null,null,null,0,null,"Calculated after-tax discount rate",null,null,null,{"$f":"L13*(1-L15-L16)","v":3.2350000000000004E-2}]
[null,"Separator hours on combine",null,null,null,0,null,"State + U.S. marginal income tax rate (decimal)",null,null,null,0.2]
[null,"Purchase price of combine w/o trade-in",null,null,null,275000,null,"Self-employment tax (0 if corporation)",null,null,null,0.153]
[null,"Market price of combine",null,null,null,{"$f":"+F16","v":275000},null,"Section 179 Depreciation ($500,000 max)",null,null,null,0]
[null,"Cash downpayment",null,null,null,50000,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,0]
[null,"Calculated new equivalent price (NEP)",null,null,null,{"$f":"F17/EXP(G11*F14+H11*F15/100+I11*F14*F15/100)","v":275000},null,"Calculated bonus yr-1 depreciation",null,null,null,{"$f":"IF(AND(F14=0,L18=1),(F16-MIN(F16,MIN('User input'!F73,L17)))*'User input'!F74,0)","v":0}]
[null,null,null,null,null,null,null,"Calculated net $ amount to depreciate",null,null,null,{"$f":"F16-MIN(F16,MIN('User input'!F73,L17))-L19","v":275000}]
[null,"No. of seasons (years) before trade (maximum 20)",null,null,null,5,null,{"$f":"IF(L17>'User input'!F73,\"Section-179 exceeds maximum allowed!\",IF(AND(F14>0,L18=1),\"Bonus 1st-yr depreciation is NOT available!\",\"\"))","v":""}]
[null,"Hours (separator) combine will be used annually",null,null,null,250,null,"1st year MACRS depreciation rate",null,null,null,0.1429]
[null,"Acres per separator hour",null,null,null,12,null,"2nd year MACRS depreciation rate",null,null,null,0.24490000000000001]
[null,"Labor",null,null,null,null,null,"3rd year MACRS depreciation rate",null,null,null,0.1749]
[null,"   Total labor hours per combine engine hour",null,null,null,1.25,null,"4th year MACRS depreciation rate",null,null,null,0.1249]
[null,"   Labor cost per hour",null,null,null,15,null,"5th year MACRS depreciation rate",null,null,null,8.9300000000000004E-2]
[null,"Fuel and lubrication",null,null,null,null,null,"6th year MACRS depreciation rate",null,null,null,8.9200000000000002E-2]
[null,"   Combine fuel consumption per engine hour (gallons)",null,null,null,11.5,null,"7th year MACRS depreciation rate",null,null,null,8.9300000000000004E-2]
[null,"   Average fuel price ($/gallon)",null,null,null,2.25,null,"8th year MACRS depreciation rate",null,null,null,4.4600000000000001E-2]
[null,"   Oil and lubrication percent of fuel cost",null,null,null,0.1,null,"Calculated error check of depreciation rates",null,null,null,{"$f":"SUM(L22:L29)","v":1.0000000000000002},{"$f":"IF(OR(L30>1.01,L30<0.99),\"<= Error!\",\" \")","v":" "}]
[null,"Repairs and maintenance",null,null,null,null,null,{"$f":"IF(OR(L30>1.01,L30<0.99),\"Total depreciation rate should add to 100%!\",\" \")","v":" "}]
[null,"   NEP adjustment to approximate list price",null,null,null,1.1499999999999999,null,"Calculated after-tax NPVc from TT section",null,null,null,{"$f":"'Time and Tax (TT)'!U4","v":121453.29757077806}]
[null,"   Repair adjustment factor (0.8 to 1.2, usually 1) (RAF)",null,null,null,1,null,"Calculated after-tax amortized NPV from TT",null,null,null,{"$f":"F37*L32","v":26698.082454230687}]
[null,"   Repairs per hour after useful life",null,null,null,{"$f":"(K11*J11*F19*F32*(L11/1000)^(K11-1))/1000","v":88.949436354632013},null,"Calculated pre-tax amortized NPV from TT",null,null,null,{"$f":"L33/(1-L15-L16)","v":41264.424195101528}]
[null,"Tax, insurance, & shelter (TIS - % of value, decimal)",null,null,null,1.4999999999999999E-2,null,"  Prorated to opportunity interest",null,null,null,{"$f":"L34*'Time and Tax (TT)'!G7","v":9326.8150607810603}]
[null,null,null,null,null,null,null,"  Prorated to market depreciation",null,null,null,{"$f":"L34*'Time and Tax (TT)'!H7","v":25631.503497378118}]
[null,"Calculated after-tax amortization factor",null,null,null,{"$f":"L14/(1-(1+L14)^-F21)","v":0.21982179972241697},null,"  Prorated to repairs",null,null,null,{"$f":"L34*'Time and Tax (TT)'!Q7","v":3508.0611187080367}]
[null,"Calculated 1-year after-tax discount factor",null,null,null,{"$f":"1/(1+L14)","v":0.96866372838669046},null,"  Prorated to tax, insurance, & shelter (TIS)",null,null,null,{"$f":"L34*'Time and Tax (TT)'!O7","v":2798.0445182343178}]
[]
[]
[null,"Note:  If user knows something about expected trade differences across time for a particular combine, he/she "]
[null,"can modify the embedded market depreciation formulas -- this is done at the bottom of the Time and Tax (TT) page."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Year"]
[null,"Section 179 allowance",null,null,null,500000]
[null,"Bonus depreciation ",null,null,null,0.5]
[]
[null,"Market ding when trade",null,null,null,0]
[null,"Separator hours/engine hours",null,null,null,0.7]

{"sheet":"Time and Tax (TT)","index":2,"n_rows":83,"n_cols":24,"rows_kept":83,"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":121453.29757077806}]
[]
[null,null,null,null,null,"after-tax NPV =>",{"$f":"SUMPRODUCT($C12:$C32,G12:G32)*(1-'User input'!$L15-'User input'!$L16)","v":30775.112696295026},{"$f":"SUMPRODUCT($C12:$C32,H12:H32)*(1-'User input'!$L15-'User input'!$L16)","v":84574.68102098658},null,null,null,null,null,"after-tax NPV =>",{"$f":"SUMPRODUCT($C12:$C32,O12:O32)*(1-'User input'!$L15-'User input'!$L16)","v":9232.5338088885073},null,{"$f":"SUMPRODUCT($C12:$C32,Q12:Q32)*(1-'User input'!$L15-'User input'!$L16)","v":11575.33151136478}]
[null,null,null,null,null,"% of total =>",{"$f":"G6/($G6+$H6+$O6+$Q6)","v":0.22602557148703023},{"$f":"H6/($G6+$H6+$O6+$Q6)","v":0.6211525787004879},null,null,null,null,null,"% of total =>",{"$f":"O6/($G6+$H6+$O6+$Q6)","v":6.7807671446109066E-2},null,{"$f":"Q6/($G6+$H6+$O6+$Q6)","v":8.5014178366372942E-2}]
[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:R32)/'User input'!F21","v":16.169311949286499}]
[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 hour","savings","cash out","cash out"]
[null,0,{"$f":"IF(B12>'User input'!F$21,\"\",'User input'!F$38^B12)","v":1},{"$f":"IF(B12>'User input'!F$21,\"\",IF(B12=0,'User input'!F$14,D11+1))","v":0},{"$f":"IF(B12>'User input'!F$21,\"\",IF(B12=0,'User input'!F$15,E11+'User input'!F$22))","v":0},{"$f":"IF(B12>'User input'!F$21,\"\",IF(F$57=1,F60,IF(F$57=2,H60,\"Error\")))","v":275000},{"$f":"IF(B12>'User input'!F$21,\"\",IF(B12>0,F11*'User input'!L$13,0))","v":0},{"$f":"IF(B12>'User input'!F$21,\"\",IF(B12>0,F11-F12,0))","v":0},{"$f":"IF(B12>'User input'!F$21,\"\",IF(B12>7,0,IF(SUM(I$11:I11)<1,IF(B12='User input'!F$21,'User input'!L22/2,'User input'!L22),0)))","v":0.1429},{"$f":"IF(B12>'User input'!F$21,\"\",IF(B12=0,MIN('User input'!F$16,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I12,'User input'!L$20*I12))","v":39297.5},{"$f":"IF(B12>'User input'!F$21,\"\",IF(B12=0,'User input'!F$16-J12,K11-J12))","v":235702.5},{"$f":"IF(B12>'User input'!F$21,\"\",IF(B12>0,('User input'!F$16-'User input'!F$18)*'User input'!L$13,0))","v":0},{"$f":"IF(B12>'User input'!F$21,\"\",IF(B12='User input'!F$21,'User input'!F$16-'User input'!F$18,0))","v":0},{"$f":"IF(B12>'User input'!F$21,\"\",IF(B12=0,'User input'!F$18,IF(B12='User input'!F$21,-F12,0)))","v":50000},{"$f":"IF(B12>'User input'!F$21,\"\",IF(B12>0,'User input'!F$35*F11,0))","v":0},{"$f":"IF(B12>'User input'!F$21,\"\",(IF(E12>'User input'!L$11,(E12-'User input'!L$11)*'User input'!F$34+'User input'!J$11*'User input'!F$19*'User input'!F$32*('User input'!L$11/1000)^'User input'!K$11,'User input'!J$11*'User input'!F$19*'User input'!F$32*(E12/1000)^'User input'!K$11))*'User input'!F$33)","v":0},{"$f":"IF(B12>'User input'!F$21,\"\",IF(B12>0,(P12-P11),0))","v":0},{"$f":"IF(B12>'User input'!F$21,\"\",Q12/'User input'!F$22)","v":0},{"$f":"IF(B12>'User input'!F$21,\"\",(J12+L12+O12+Q12)*('User input'!L$15+'User input'!L$16)-IF(B12='User input'!F$21,(F12-K12)*'User input'!L$15,0))","v":13872.0175},{"$f":"IF(B12>'User input'!F$21,\"\",L12+M12+N12+O12+Q12-S12)","v":36127.982499999998},{"$f":"IF(B12>'User input'!F$21,\"\",C12*T12)","v":36127.982499999998}]
[null,{"$f":"IF(B12>='User input'!F$21,\"\",B12+1)","v":1},{"$f":"IF(B13>'User input'!F$21,\"\",'User input'!F$38^B13)","v":0.96866372838669046},{"$f":"IF(B13>'User input'!F$21,\"\",IF(B13=0,'User input'!F$14,D12+1))","v":1},{"$f":"IF(B13>'User input'!F$21,\"\",IF(B13=0,'User input'!F$15,E12+'User input'!F$22))","v":250},{"$f":"IF(B13>'User input'!F$21,\"\",IF(F$57=1,F61,IF(F$57=2,H61,\"Error\")))","v":234257.80975407595},{"$f":"IF(B13>'User input'!F$21,\"\",IF(B13>0,F12*'User input'!L$13,0))","v":13750},{"$f":"IF(B13>'User input'!F$21,\"\",IF(B13>0,F12-F13,0))","v":40742.190245924052},{"$f":"IF(B13>'User input'!F$21,\"\",IF(B13>7,0,IF(SUM(I$11:I12)<1,IF(B13='User input'!F$21,'User input'!L23/2,'User input'!L23),0)))","v":0.24490000000000001},{"$f":"IF(B13>'User input'!F$21,\"\",IF(B13=0,MIN('User input'!F$16,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I13,'User input'!L$20*I13))","v":67347.5},{"$f":"IF(B13>'User input'!F$21,\"\",IF(B13=0,'User input'!F$16-J13,K12-J13))","v":168355},{"$f":"IF(B13>'User input'!F$21,\"\",IF(B13>0,('User input'!F$16-'User input'!F$18)*'User input'!L$13,0))","v":11250},{"$f":"IF(B13>'User input'!F$21,\"\",IF(B13='User input'!F$21,'User input'!F$16-'User input'!F$18,0))","v":0},{"$f":"IF(B13>'User input'!F$21,\"\",IF(B13=0,'User input'!F$18,IF(B13='User input'!F$21,-F13,0)))","v":0},{"$f":"IF(B13>'User input'!F$21,\"\",IF(B13>0,'User input'!F$35*F12,0))","v":4125},{"$f":"IF(B13>'User input'!F$21,\"\",(IF(E13>'User input'!L$11,(E13-'User input'!L$11)*'User input'!F$34+'User input'!J$11*'User input'!F$19*'User input'!F$32*('User input'!L$11/1000)^'User input'!K$11,'User input'!J$11*'User input'!F$19*'User input'!F$32*(E13/1000)^'User input'!K$11))*'User input'!F$33)","v":688.27903910599809},{"$f":"IF(B13>'User input'!F$21,\"\",IF(B13>0,(P13-P12),0))","v":688.27903910599809},{"$f":"IF(B13>'User input'!F$21,\"\",Q13/'User input'!F$22)","v":2.7531161564239923},{"$f":"IF(B13>'User input'!F$21,\"\",(J13+L13+O13+Q13)*('User input'!L$15+'User input'!L$16)-IF(B13='User input'!F$21,(F13-K13)*'User input'!L$15,0))","v":29444.005000804416},{"$f":"IF(B13>'User input'!F$21,\"\",L13+M13+N13+O13+Q13-S13)","v":-13380.725961698417},{"$f":"IF(B13>'User input'!F$21,\"\",C13*T13)","v":-12961.423898579373}]
[null,{"$f":"IF(B13>='User input'!F$21,\"\",B13+1)","v":2},{"$f":"IF(B14>'User input'!F$21,\"\",'User input'!F$38^B14)","v":0.93830941869200402},{"$f":"IF(B14>'User input'!F$21,\"\",IF(B14=0,'User input'!F$14,D13+1))","v":2},{"$f":"IF(B14>'User input'!F$21,\"\",IF(B14=0,'User input'!F$15,E13+'User input'!F$22))","v":500},{"$f":"IF(B14>'User input'!F$21,\"\",IF(F$57=1,F62,IF(F$57=2,H62,\"Error\")))","v":201074.5585882242},{"$f":"IF(B14>'User input'!F$21,\"\",IF(B14>0,F13*'User input'!L$13,0))","v":11712.890487703798},{"$f":"IF(B14>'User input'!F$21,\"\",IF(B14>0,F13-F14,0))","v":33183.251165851747},{"$f":"IF(B14>'User input'!F$21,\"\",IF(B14>7,0,IF(SUM(I$11:I13)<1,IF(B14='User input'!F$21,'User input'!L24/2,'User input'!L24),0)))","v":0.1749},{"$f":"IF(B14>'User input'!F$21,\"\",IF(B14=0,MIN('User input'!F$16,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I14,'User input'!L$20*I14))","v":48097.5},{"$f":"IF(B14>'User input'!F$21,\"\",IF(B14=0,'User input'!F$16-J14,K13-J14))","v":120257.5},{"$f":"IF(B14>'User input'!F$21,\"\",IF(B14>0,('User input'!F$16-'User input'!F$18)*'User input'!L$13,0))","v":11250},{"$f":"IF(B14>'User input'!F$21,\"\",IF(B14='User input'!F$21,'User input'!F$16-'User input'!F$18,0))","v":0},{"$f":"IF(B14>'User input'!F$21,\"\",IF(B14=0,'User input'!F$18,IF(B14='User input'!F$21,-F14,0)))","v":0},{"$f":"IF(B14>'User input'!F$21,\"\",IF(B14>0,'User input'!F$35*F13,0))","v":3513.8671463111391},{"$f":"IF(B14>'User input'!F$21,\"\",(IF(E14>'User input'!L$11,(E14-'User input'!L$11)*'User input'!F$34+'User input'!J$11*'User input'!F$19*'User input'!F$32*('User input'!L$11/1000)^'User input'!K$11,'User input'!J$11*'User input'!F$19*'User input'!F$32*(E14/1000)^'User input'!K$11))*'User input'!F$33)","v":2950.7168357351529},{"$f":"IF(B14>'User input'!F$21,\"\",IF(B14>0,(P14-P13),0))","v":2262.4377966291549},{"$f":"IF(B14>'User input'!F$21,\"\",Q14/'User input'!F$22)","v":9.0497511865166196},{"$f":"IF(B14>'User input'!F$21,\"\",(J14+L14+O14+Q14)*('User input'!L$15+'User input'!L$16)-IF(B14='User input'!F$21,(F14-K14)*'User input'!L$15,0))","v":22988.703144857922},{"$f":"IF(B14>'User input'!F$21,\"\",L14+M14+N14+O14+Q14-S14)","v":-5962.3982019176292},{"$f":"IF(B14>'User input'!F$21,\"\",C14*T14)","v":-5594.5743908515806}]
[null,{"$f":"IF(B14>='User input'!F$21,\"\",B14+1)","v":3},{"$f":"IF(B15>'User input'!F$21,\"\",'User input'!F$38^B15)","v":0.90890629989054483},{"$f":"IF(B15>'User input'!F$21,\"\",IF(B15=0,'User input'!F$14,D14+1))","v":3},{"$f":"IF(B15>'User input'!F$21,\"\",IF(B15=0,'User input'!F$15,E14+'User input'!F$22))","v":750},{"$f":"IF(B15>'User input'!F$21,\"\",IF(F$57=1,F63,IF(F$57=2,H63,\"Error\")))","v":173908.90895266252},{"$f":"IF(B15>'User input'!F$21,\"\",IF(B15>0,F14*'User input'!L$13,0))","v":10053.72792941121},{"$f":"IF(B15>'User input'!F$21,\"\",IF(B15>0,F14-F15,0))","v":27165.649635561684},{"$f":"IF(B15>'User input'!F$21,\"\",IF(B15>7,0,IF(SUM(I$11:I14)<1,IF(B15='User input'!F$21,'User input'!L25/2,'User input'!L25),0)))","v":0.1249},{"$f":"IF(B15>'User input'!F$21,\"\",IF(B15=0,MIN('User input'!F$16,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I15,'User input'!L$20*I15))","v":34347.5},{"$f":"IF(B15>'User input'!F$21,\"\",IF(B15=0,'User input'!F$16-J15,K14-J15))","v":85910},{"$f":"IF(B15>'User input'!F$21,\"\",IF(B15>0,('User input'!F$16-'User input'!F$18)*'User input'!L$13,0))","v":11250},{"$f":"IF(B15>'User input'!F$21,\"\",IF(B15='User input'!F$21,'User input'!F$16-'User input'!F$18,0))","v":0},{"$f":"IF(B15>'User input'!F$21,\"\",IF(B15=0,'User input'!F$18,IF(B15='User input'!F$21,-F15,0)))","v":0},{"$f":"IF(B15>'User input'!F$21,\"\",IF(B15>0,'User input'!F$35*F14,0))","v":3016.1183788233629},{"$f":"IF(B15>'User input'!F$21,\"\",(IF(E15>'User input'!L$11,(E15-'User input'!L$11)*'User input'!F$34+'User input'!J$11*'User input'!F$19*'User input'!F$32*('User input'!L$11/1000)^'User input'!K$11,'User input'!J$11*'User input'!F$19*'User input'!F$32*(E15/1000)^'User input'!K$11))*'User input'!F$33)","v":6913.8376717319306},{"$f":"IF(B15>'User input'!F$21,\"\",IF(B15>0,(P15-P14),0))","v":3963.1208359967777},{"$f":"IF(B15>'User input'!F$21,\"\",Q15/'User input'!F$22)","v":15.85248334398711},{"$f":"IF(B15>'User input'!F$21,\"\",(J15+L15+O15+Q15)*('User input'!L$15+'User input'!L$16)-IF(B15='User input'!F$21,(F15-K15)*'User input'!L$15,0))","v":18559.588942831509},{"$f":"IF(B15>'User input'!F$21,\"\",L15+M15+N15+O15+Q15-S15)","v":-330.34972801136973},{"$f":"IF(B15>'User input'!F$21,\"\",C15*T15)","v":-300.25694895666192}]
[null,{"$f":"IF(B15>='User input'!F$21,\"\",B15+1)","v":4},{"$f":"IF(B16>'User input'!F$21,\"\",'User input'!F$38^B16)","v":0.88042456520612644},{"$f":"IF(B16>'User input'!F$21,\"\",IF(B16=0,'User input'!F$14,D15+1))","v":4},{"$f":"IF(B16>'User input'!F$21,\"\",IF(B16=0,'User input'!F$15,E15+'User input'!F$22))","v":1000},{"$f":"IF(B16>'User input'!F$21,\"\",IF(F$57=1,F64,IF(F$57=2,H64,\"Error\")))","v":151561.25679074231},{"$f":"IF(B16>'User input'!F$21,\"\",IF(B16>0,F15*'User input'!L$13,0))","v":8695.4454476331266},{"$f":"IF(B16>'User input'!F$21,\"\",IF(B16>0,F15-F16,0))","v":22347.65216192021},{"$f":"IF(B16>'User input'!F$21,\"\",IF(B16>7,0,IF(SUM(I$11:I15)<1,IF(B16='User input'!F$21,'User input'!L26/2,'User input'!L26),0)))","v":8.9300000000000004E-2},{"$f":"IF(B16>'User input'!F$21,\"\",IF(B16=0,MIN('User input'!F$16,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I16,'User input'!L$20*I16))","v":24557.5},{"$f":"IF(B16>'User input'!F$21,\"\",IF(B16=0,'User input'!F$16-J16,K15-J16))","v":61352.5},{"$f":"IF(B16>'User input'!F$21,\"\",IF(B16>0,('User input'!F$16-'User input'!F$18)*'User input'!L$13,0))","v":11250},{"$f":"IF(B16>'User input'!F$21,\"\",IF(B16='User input'!F$21,'User input'!F$16-'User input'!F$18,0))","v":0},{"$f":"IF(B16>'User input'!F$21,\"\",IF(B16=0,'User input'!F$18,IF(B16='User input'!F$21,-F16,0)))","v":0},{"$f":"IF(B16>'User input'!F$21,\"\",IF(B16>0,'User input'!F$35*F15,0))","v":2608.6336342899376},{"$f":"IF(B16>'User input'!F$21,\"\",(IF(E16>'User input'!L$11,(E16-'User input'!L$11)*'User input'!F$34+'User input'!J$11*'User input'!F$19*'User input'!F$32*('User input'!L$11/1000)^'User input'!K$11,'User input'!J$11*'User input'!F$19*'User input'!F$32*(E16/1000)^'User input'!K$11))*'User input'!F$33)","v":12649.999999999998},{"$f":"IF(B16>'User input'!F$21,\"\",IF(B16>0,(P16-P15),0))","v":5736.1623282680675},{"$f":"IF(B16>'User input'!F$21,\"\",Q16/'User input'!F$22)","v":22.944649313072269},{"$f":"IF(B16>'User input'!F$21,\"\",(J16+L16+O16+Q16)*('User input'!L$15+'User input'!L$16)-IF(B16='User input'!F$21,(F16-K16)*'User input'!L$15,0))","v":15585.760474782976},{"$f":"IF(B16>'User input'!F$21,\"\",L16+M16+N16+O16+Q16-S16)","v":4009.0354877750287},{"$f":"IF(B16>'User input'!F$21,\"\",C16*T16)","v":3529.6533262202606}]
[null,{"$f":"IF(B16>='User input'!F$21,\"\",B16+1)","v":5},{"$f":"IF(B17>'User input'!F$21,\"\",'User input'!F$38^B17)","v":0.85283534189579735},{"$f":"IF(B17>'User input'!F$21,\"\",IF(B17=0,'User input'!F$14,D16+1))","v":5},{"$f":"IF(B17>'User input'!F$21,\"\",IF(B17=0,'User input'!F$15,E16+'User input'!F$22))","v":1250},{"$f":"IF(B17>'User input'!F$21,\"\",IF(F$57=1,F65,IF(F$57=2,H65,\"Error\")))","v":133093.3100915094},{"$f":"IF(B17>'User input'!F$21,\"\",IF(B17>0,F16*'User input'!L$13,0))","v":7578.0628395371159},{"$f":"IF(B17>'User input'!F$21,\"\",IF(B17>0,F16-F17,0))","v":18467.946699232911},{"$f":"IF(B17>'User input'!F$21,\"\",IF(B17>7,0,IF(SUM(I$11:I16)<1,IF(B17='User input'!F$21,'User input'!L27/2,'User input'!L27),0)))","v":4.4600000000000001E-2},{"$f":"IF(B17>'User input'!F$21,\"\",IF(B17=0,MIN('User input'!F$16,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I17,'User input'!L$20*I17))","v":12265},{"$f":"IF(B17>'User input'!F$21,\"\",IF(B17=0,'User input'!F$16-J17,K16-J17))","v":49087.5},{"$f":"IF(B17>'User input'!F$21,\"\",IF(B17>0,('User input'!F$16-'User input'!F$18)*'User input'!L$13,0))","v":11250},{"$f":"IF(B17>'User input'!F$21,\"\",IF(B17='User input'!F$21,'User input'!F$16-'User input'!F$18,0))","v":225000},{"$f":"IF(B17>'User input'!F$21,\"\",IF(B17=0,'User input'!F$18,IF(B17='User input'!F$21,-F17,0)))","v":-133093.3100915094},{"$f":"IF(B17>'User input'!F$21,\"\",IF(B17>0,'User input'!F$35*F16,0))","v":2273.4188518611345},{"$f":"IF(B17>'User input'!F$21,\"\",(IF(E17>'User input'!L$11,(E17-'User input'!L$11)*'User input'!F$34+'User input'!J$11*'User input'!F$19*'User input'!F$32*('User input'!L$11/1000)^'User input'!K$11,'User input'!J$11*'User input'!F$19*'User input'!F$32*(E17/1000)^'User input'!K$11))*'User input'!F$33)","v":20211.63993660812},{"$f":"IF(B17>'User input'!F$21,\"\",IF(B17>0,(P17-P16),0))","v":7561.6399366081223},{"$f":"IF(B17>'User input'!F$21,\"\",Q17/'User input'!F$22)","v":30.246559746432489},{"$f":"IF(B17>'User input'!F$21,\"\",(J17+L17+O17+Q17)*('User input'!L$15+'User input'!L$16)-IF(B17='User input'!F$21,(F17-K17)*'User input'!L$15,0))","v":-5028.5912659722308},{"$f":"IF(B17>'User input'!F$21,\"\",L17+M17+N17+O17+Q17-S17)","v":118020.33996293208},{"$f":"IF(B17>'User input'!F$21,\"\",C17*T17)","v":100651.91698294542}]
[null,{"$f":"IF(B17>='User input'!F$21,\"\",B17+1)","v":""},{"$f":"IF(B18>'User input'!F$21,\"\",'User input'!F$38^B18)","v":""},{"$f":"IF(B18>'User input'!F$21,\"\",IF(B18=0,'User input'!F$14,D17+1))","v":""},{"$f":"IF(B18>'User input'!F$21,\"\",IF(B18=0,'User input'!F$15,E17+'User input'!F$22))","v":""},{"$f":"IF(B18>'User input'!F$21,\"\",IF(F$57=1,F66,IF(F$57=2,H66,\"Error\")))","v":""},{"$f":"IF(B18>'User input'!F$21,\"\",IF(B18>0,F17*'User input'!L$13,0))","v":""},{"$f":"IF(B18>'User input'!F$21,\"\",IF(B18>0,F17-F18,0))","v":""},{"$f":"IF(B18>'User input'!F$21,\"\",IF(B18>7,0,IF(SUM(I$11:I17)<1,IF(B18='User input'!F$21,'User input'!L28/2,'User input'!L28),0)))","v":""},{"$f":"IF(B18>'User input'!F$21,\"\",IF(B18=0,MIN('User input'!F$16,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I18,'User input'!L$20*I18))","v":""},{"$f":"IF(B18>'User input'!F$21,\"\",IF(B18=0,'User input'!F$16-J18,K17-J18))","v":""},{"$f":"IF(B18>'User input'!F$21,\"\",IF(B18>0,('User input'!F$16-'User input'!F$18)*'User input'!L$13,0))","v":""},{"$f":"IF(B18>'User input'!F$21,\"\",IF(B18='User input'!F$21,'User input'!F$16-'User input'!F$18,0))","v":""},{"$f":"IF(B18>'User input'!F$21,\"\",IF(B18=0,'User input'!F$18,IF(B18='User input'!F$21,-F18,0)))","v":""},{"$f":"IF(B18>'User input'!F$21,\"\",IF(B18>0,'User input'!F$35*F17,0))","v":""},{"$f":"IF(B18>'User input'!F$21,\"\",(IF(E18>'User input'!L$11,(E18-'User input'!L$11)*'User input'!F$34+'User input'!J$11*'User input'!F$19*'User input'!F$32*('User input'!L$11/1000)^'User input'!K$11,'User input'!J$11*'User input'!F$19*'User input'!F$32*(E18/1000)^'User input'!K$11))*'User input'!F$33)","v":""},{"$f":"IF(B18>'User input'!F$21,\"\",IF(B18>0,(P18-P17),0))","v":""},{"$f":"IF(B18>'User input'!F$21,\"\",Q18/'User input'!F$22)","v":""},{"$f":"IF(B18>'User input'!F$21,\"\",(J18+L18+O18+Q18)*('User input'!L$15+'User input'!L$16)-IF(B18='User input'!F$21,(F18-K18)*'User input'!L$15,0))","v":""},{"$f":"IF(B18>'User input'!F$21,\"\",L18+M18+N18+O18+Q18-S18)","v":""},{"$f":"IF(B18>'User input'!F$21,\"\",C18*T18)","v":""}]
[null,{"$f":"IF(B18>='User input'!F$21,\"\",B18+1)","v":""},{"$f":"IF(B19>'User input'!F$21,\"\",'User input'!F$38^B19)","v":""},{"$f":"IF(B19>'User input'!F$21,\"\",IF(B19=0,'User input'!F$14,D18+1))","v":""},{"$f":"IF(B19>'User input'!F$21,\"\",IF(B19=0,'User input'!F$15,E18+'User input'!F$22))","v":""},{"$f":"IF(B19>'User input'!F$21,\"\",IF(F$57=1,F67,IF(F$57=2,H67,\"Error\")))","v":""},{"$f":"IF(B19>'User input'!F$21,\"\",IF(B19>0,F18*'User input'!L$13,0))","v":""},{"$f":"IF(B19>'User input'!F$21,\"\",IF(B19>0,F18-F19,0))","v":""},{"$f":"IF(B19>'User input'!F$21,\"\",IF(B19>7,0,IF(SUM(I$11:I18)<1,IF(B19='User input'!F$21,'User input'!L29/2,'User input'!L29),0)))","v":""},{"$f":"IF(B19>'User input'!F$21,\"\",IF(B19=0,MIN('User input'!F$16,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I19,'User input'!L$20*I19))","v":""},{"$f":"IF(B19>'User input'!F$21,\"\",IF(B19=0,'User input'!F$16-J19,K18-J19))","v":""},{"$f":"IF(B19>'User input'!F$21,\"\",IF(B19>0,('User input'!F$16-'User input'!F$18)*'User input'!L$13,0))","v":""},{"$f":"IF(B19>'User input'!F$21,\"\",IF(B19='User input'!F$21,'User input'!F$16-'User input'!F$18,0))","v":""},{"$f":"IF(B19>'User input'!F$21,\"\",IF(B19=0,'User input'!F$18,IF(B19='User input'!F$21,-F19,0)))","v":""},{"$f":"IF(B19>'User input'!F$21,\"\",IF(B19>0,'User input'!F$35*F18,0))","v":""},{"$f":"IF(B19>'User input'!F$21,\"\",(IF(E19>'User input'!L$11,(E19-'User input'!L$11)*'User input'!F$34+'User input'!J$11*'User input'!F$19*'User input'!F$32*('User input'!L$11/1000)^'User input'!K$11,'User input'!J$11*'User input'!F$19*'User input'!F$32*(E19/1000)^'User input'!K$11))*'User input'!F$33)","v":""},{"$f":"IF(B19>'User input'!F$21,\"\",IF(B19>0,(P19-P18),0))","v":""},{"$f":"IF(B19>'User input'!F$21,\"\",Q19/'User input'!F$22)","v":""},{"$f":"IF(B19>'User input'!F$21,\"\",(J19+L19+O19+Q19)*('User input'!L$15+'User input'!L$16)-IF(B19='User input'!F$21,(F19-K19)*'User input'!L$15,0))","v":""},{"$f":"IF(B19>'User input'!F$21,\"\",L19+M19+N19+O19+Q19-S19)","v":""},{"$f":"IF(B19>'User input'!F$21,\"\",C19*T19)","v":""}]
[null,{"$f":"IF(B19>='User input'!F$21,\"\",B19+1)","v":""},{"$f":"IF(B20>'User input'!F$21,\"\",'User input'!F$38^B20)","v":""},{"$f":"IF(B20>'User input'!F$21,\"\",IF(B20=0,'User input'!F$14,D19+1))","v":""},{"$f":"IF(B20>'User input'!F$21,\"\",IF(B20=0,'User input'!F$15,E19+'User input'!F$22))","v":""},{"$f":"IF(B20>'User input'!F$21,\"\",IF(F$57=1,F68,IF(F$57=2,H68,\"Error\")))","v":""},{"$f":"IF(B20>'User input'!F$21,\"\",IF(B20>0,F19*'User input'!L$13,0))","v":""},{"$f":"IF(B20>'User input'!F$21,\"\",IF(B20>0,F19-F20,0))","v":""},{"$f":"IF(B20>'User input'!F$21,\"\",IF(B20>7,0,IF(SUM(I$11:I19)<1,IF(B20='User input'!F$21,'User input'!L30/2,'User input'!L30),0)))","v":""},{"$f":"IF(B20>'User input'!F$21,\"\",IF(B20=0,MIN('User input'!F$16,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I20,'User input'!L$20*I20))","v":""},{"$f":"IF(B20>'User input'!F$21,\"\",IF(B20=0,'User input'!F$16-J20,K19-J20))","v":""},{"$f":"IF(B20>'User input'!F$21,\"\",IF(B20>0,('User input'!F$16-'User input'!F$18)*'User input'!L$13,0))","v":""},{"$f":"IF(B20>'User input'!F$21,\"\",IF(B20='User input'!F$21,'User input'!F$16-'User input'!F$18,0))","v":""},{"$f":"IF(B20>'User input'!F$21,\"\",IF(B20=0,'User input'!F$18,IF(B20='User input'!F$21,-F20,0)))","v":""},{"$f":"IF(B20>'User input'!F$21,\"\",IF(B20>0,'User input'!F$35*F19,0))","v":""},{"$f":"IF(B20>'User input'!F$21,\"\",(IF(E20>'User input'!L$11,(E20-'User input'!L$11)*'User input'!F$34+'User input'!J$11*'User input'!F$19*'User input'!F$32*('User input'!L$11/1000)^'User input'!K$11,'User input'!J$11*'User input'!F$19*'User input'!F$32*(E20/1000)^'User input'!K$11))*'User input'!F$33)","v":""},{"$f":"IF(B20>'User input'!F$21,\"\",IF(B20>0,(P20-P19),0))","v":""},{"$f":"IF(B20>'User input'!F$21,\"\",Q20/'User input'!F$22)","v":""},{"$f":"IF(B20>'User input'!F$21,\"\",(J20+L20+O20+Q20)*('User input'!L$15+'User input'!L$16)-IF(B20='User input'!F$21,(F20-K20)*'User input'!L$15,0))","v":""},{"$f":"IF(B20>'User input'!F$21,\"\",L20+M20+N20+O20+Q20-S20)","v":""},{"$f":"IF(B20>'User input'!F$21,\"\",C20*T20)","v":""}]
[null,{"$f":"IF(B20>='User input'!F$21,\"\",B20+1)","v":""},{"$f":"IF(B21>'User input'!F$21,\"\",'User input'!F$38^B21)","v":""},{"$f":"IF(B21>'User input'!F$21,\"\",IF(B21=0,'User input'!F$14,D20+1))","v":""},{"$f":"IF(B21>'User input'!F$21,\"\",IF(B21=0,'User input'!F$15,E20+'User input'!F$22))","v":""},{"$f":"IF(B21>'User input'!F$21,\"\",IF(F$57=1,F69,IF(F$57=2,H69,\"Error\")))","v":""},{"$f":"IF(B21>'User input'!F$21,\"\",IF(B21>0,F20*'User input'!L$13,0))","v":""},{"$f":"IF(B21>'User input'!F$21,\"\",IF(B21>0,F20-F21,0))","v":""},{"$f":"IF(B21>'User input'!F$21,\"\",IF(B21>7,0,IF(SUM(I$11:I20)<1,IF(B21='User input'!F$21,'User input'!L31/2,'User input'!L31),0)))","v":""},{"$f":"IF(B21>'User input'!F$21,\"\",IF(B21=0,MIN('User input'!F$16,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I21,'User input'!L$20*I21))","v":""},{"$f":"IF(B21>'User input'!F$21,\"\",IF(B21=0,'User input'!F$16-J21,K20-J21))","v":""},{"$f":"IF(B21>'User input'!F$21,\"\",IF(B21>0,('User input'!F$16-'User input'!F$18)*'User input'!L$13,0))","v":""},{"$f":"IF(B21>'User input'!F$21,\"\",IF(B21='User input'!F$21,'User input'!F$16-'User input'!F$18,0))","v":""},{"$f":"IF(B21>'User input'!F$21,\"\",IF(B21=0,'User input'!F$18,IF(B21='User input'!F$21,-F21,0)))","v":""},{"$f":"IF(B21>'User input'!F$21,\"\",IF(B21>0,'User input'!F$35*F20,0))","v":""},{"$f":"IF(B21>'User input'!F$21,\"\",(IF(E21>'User input'!L$11,(E21-'User input'!L$11)*'User input'!F$34+'User input'!J$11*'User input'!F$19*'User input'!F$32*('User input'!L$11/1000)^'User input'!K$11,'User input'!J$11*'User input'!F$19*'User input'!F$32*(E21/1000)^'User input'!K$11))*'User input'!F$33)","v":""},{"$f":"IF(B21>'User input'!F$21,\"\",IF(B21>0,(P21-P20),0))","v":""},{"$f":"IF(B21>'User input'!F$21,\"\",Q21/'User input'!F$22)","v":""},{"$f":"IF(B21>'User input'!F$21,\"\",(J21+L21+O21+Q21)*('User input'!L$15+'User input'!L$16)-IF(B21='User input'!F$21,(F21-K21)*'User input'!L$15,0))","v":""},{"$f":"IF(B21>'User input'!F$21,\"\",L21+M21+N21+O21+Q21-S21)","v":""},{"$f":"IF(B21>'User input'!F$21,\"\",C21*T21)","v":""}]
[null,{"$f":"IF(B21>='User input'!F$21,\"\",B21+1)","v":""},{"$f":"IF(B22>'User input'!F$21,\"\",'User input'!F$38^B22)","v":""},{"$f":"IF(B22>'User input'!F$21,\"\",IF(B22=0,'User input'!F$14,D21+1))","v":""},{"$f":"IF(B22>'User input'!F$21,\"\",IF(B22=0,'User input'!F$15,E21+'User input'!F$22))","v":""},{"$f":"IF(B22>'User input'!F$21,\"\",IF(F$57=1,F70,IF(F$57=2,H70,\"Error\")))","v":""},{"$f":"IF(B22>'User input'!F$21,\"\",IF(B22>0,F21*'User input'!L$13,0))","v":""},{"$f":"IF(B22>'User input'!F$21,\"\",IF(B22>0,F21-F22,0))","v":""},{"$f":"IF(B22>'User input'!F$21,\"\",IF(B22>7,0,IF(SUM(I$11:I21)<1,IF(B22='User input'!F$21,'User input'!L32/2,'User input'!L32),0)))","v":""},{"$f":"IF(B22>'User input'!F$21,\"\",IF(B22=0,MIN('User input'!F$16,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I22,'User input'!L$20*I22))","v":""},{"$f":"IF(B22>'User input'!F$21,\"\",IF(B22=0,'User input'!F$16-J22,K21-J22))","v":""},{"$f":"IF(B22>'User input'!F$21,\"\",IF(B22>0,('User input'!F$16-'User input'!F$18)*'User input'!L$13,0))","v":""},{"$f":"IF(B22>'User input'!F$21,\"\",IF(B22='User input'!F$21,'User input'!F$16-'User input'!F$18,0))","v":""},{"$f":"IF(B22>'User input'!F$21,\"\",IF(B22=0,'User input'!F$18,IF(B22='User input'!F$21,-F22,0)))","v":""},{"$f":"IF(B22>'User input'!F$21,\"\",IF(B22>0,'User input'!F$35*F21,0))","v":""},{"$f":"IF(B22>'User input'!F$21,\"\",(IF(E22>'User input'!L$11,(E22-'User input'!L$11)*'User input'!F$34+'User input'!J$11*'User input'!F$19*'User input'!F$32*('User input'!L$11/1000)^'User input'!K$11,'User input'!J$11*'User input'!F$19*'User input'!F$32*(E22/1000)^'User input'!K$11))*'User input'!F$33)","v":""},{"$f":"IF(B22>'User input'!F$21,\"\",IF(B22>0,(P22-P21),0))","v":""},{"$f":"IF(B22>'User input'!F$21,\"\",Q22/'User input'!F$22)","v":""},{"$f":"IF(B22>'User input'!F$21,\"\",(J22+L22+O22+Q22)*('User input'!L$15+'User input'!L$16)-IF(B22='User input'!F$21,(F22-K22)*'User input'!L$15,0))","v":""},{"$f":"IF(B22>'User input'!F$21,\"\",L22+M22+N22+O22+Q22-S22)","v":""},{"$f":"IF(B22>'User input'!F$21,\"\",C22*T22)","v":""}]
[null,{"$f":"IF(B22>='User input'!F$21,\"\",B22+1)","v":""},{"$f":"IF(B23>'User input'!F$21,\"\",'User input'!F$38^B23)","v":""},{"$f":"IF(B23>'User input'!F$21,\"\",IF(B23=0,'User input'!F$14,D22+1))","v":""},{"$f":"IF(B23>'User input'!F$21,\"\",IF(B23=0,'User input'!F$15,E22+'User input'!F$22))","v":""},{"$f":"IF(B23>'User input'!F$21,\"\",IF(F$57=1,F71,IF(F$57=2,H71,\"Error\")))","v":""},{"$f":"IF(B23>'User input'!F$21,\"\",IF(B23>0,F22*'User input'!L$13,0))","v":""},{"$f":"IF(B23>'User input'!F$21,\"\",IF(B23>0,F22-F23,0))","v":""},{"$f":"IF(B23>'User input'!F$21,\"\",IF(B23>7,0,IF(SUM(I$11:I22)<1,IF(B23='User input'!F$21,'User input'!L33/2,'User input'!L33),0)))","v":""},{"$f":"IF(B23>'User input'!F$21,\"\",IF(B23=0,MIN('User input'!F$16,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I23,'User input'!L$20*I23))","v":""},{"$f":"IF(B23>'User input'!F$21,\"\",IF(B23=0,'User input'!F$16-J23,K22-J23))","v":""},{"$f":"IF(B23>'User input'!F$21,\"\",IF(B23>0,('User input'!F$16-'User input'!F$18)*'User input'!L$13,0))","v":""},{"$f":"IF(B23>'User input'!F$21,\"\",IF(B23='User input'!F$21,'User input'!F$16-'User input'!F$18,0))","v":""},{"$f":"IF(B23>'User input'!F$21,\"\",IF(B23=0,'User input'!F$18,IF(B23='User input'!F$21,-F23,0)))","v":""},{"$f":"IF(B23>'User input'!F$21,\"\",IF(B23>0,'User input'!F$35*F22,0))","v":""},{"$f":"IF(B23>'User input'!F$21,\"\",(IF(E23>'User input'!L$11,(E23-'User input'!L$11)*'User input'!F$34+'User input'!J$11*'User input'!F$19*'User input'!F$32*('User input'!L$11/1000)^'User input'!K$11,'User input'!J$11*'User input'!F$19*'User input'!F$32*(E23/1000)^'User input'!K$11))*'User input'!F$33)","v":""},{"$f":"IF(B23>'User input'!F$21,\"\",IF(B23>0,(P23-P22),0))","v":""},{"$f":"IF(B23>'User input'!F$21,\"\",Q23/'User input'!F$22)","v":""},{"$f":"IF(B23>'User input'!F$21,\"\",(J23+L23+O23+Q23)*('User input'!L$15+'User input'!L$16)-IF(B23='User input'!F$21,(F23-K23)*'User input'!L$15,0))","v":""},{"$f":"IF(B23>'User input'!F$21,\"\",L23+M23+N23+O23+Q23-S23)","v":""},{"$f":"IF(B23>'User input'!F$21,\"\",C23*T23)","v":""}]
[null,{"$f":"IF(B23>='User input'!F$21,\"\",B23+1)","v":""},{"$f":"IF(B24>'User input'!F$21,\"\",'User input'!F$38^B24)","v":""},{"$f":"IF(B24>'User input'!F$21,\"\",IF(B24=0,'User input'!F$14,D23+1))","v":""},{"$f":"IF(B24>'User input'!F$21,\"\",IF(B24=0,'User input'!F$15,E23+'User input'!F$22))","v":""},{"$f":"IF(B24>'User input'!F$21,\"\",IF(F$57=1,F72,IF(F$57=2,H72,\"Error\")))","v":""},{"$f":"IF(B24>'User input'!F$21,\"\",IF(B24>0,F23*'User input'!L$13,0))","v":""},{"$f":"IF(B24>'User input'!F$21,\"\",IF(B24>0,F23-F24,0))","v":""},{"$f":"IF(B24>'User input'!F$21,\"\",IF(B24>7,0,IF(SUM(I$11:I23)<1,IF(B24='User input'!F$21,'User input'!L34/2,'User input'!L34),0)))","v":""},{"$f":"IF(B24>'User input'!F$21,\"\",IF(B24=0,MIN('User input'!F$16,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I24,'User input'!L$20*I24))","v":""},{"$f":"IF(B24>'User input'!F$21,\"\",IF(B24=0,'User input'!F$16-J24,K23-J24))","v":""},{"$f":"IF(B24>'User input'!F$21,\"\",IF(B24>0,('User input'!F$16-'User input'!F$18)*'User input'!L$13,0))","v":""},{"$f":"IF(B24>'User input'!F$21,\"\",IF(B24='User input'!F$21,'User input'!F$16-'User input'!F$18,0))","v":""},{"$f":"IF(B24>'User input'!F$21,\"\",IF(B24=0,'User input'!F$18,IF(B24='User input'!F$21,-F24,0)))","v":""},{"$f":"IF(B24>'User input'!F$21,\"\",IF(B24>0,'User input'!F$35*F23,0))","v":""},{"$f":"IF(B24>'User input'!F$21,\"\",(IF(E24>'User input'!L$11,(E24-'User input'!L$11)*'User input'!F$34+'User input'!J$11*'User input'!F$19*'User input'!F$32*('User input'!L$11/1000)^'User input'!K$11,'User input'!J$11*'User input'!F$19*'User input'!F$32*(E24/1000)^'User input'!K$11))*'User input'!F$33)","v":""},{"$f":"IF(B24>'User input'!F$21,\"\",IF(B24>0,(P24-P23),0))","v":""},{"$f":"IF(B24>'User input'!F$21,\"\",Q24/'User input'!F$22)","v":""},{"$f":"IF(B24>'User input'!F$21,\"\",(J24+L24+O24+Q24)*('User input'!L$15+'User input'!L$16)-IF(B24='User input'!F$21,(F24-K24)*'User input'!L$15,0))","v":""},{"$f":"IF(B24>'User input'!F$21,\"\",L24+M24+N24+O24+Q24-S24)","v":""},{"$f":"IF(B24>'User input'!F$21,\"\",C24*T24)","v":""}]
[null,{"$f":"IF(B24>='User input'!F$21,\"\",B24+1)","v":""},{"$f":"IF(B25>'User input'!F$21,\"\",'User input'!F$38^B25)","v":""},{"$f":"IF(B25>'User input'!F$21,\"\",IF(B25=0,'User input'!F$14,D24+1))","v":""},{"$f":"IF(B25>'User input'!F$21,\"\",IF(B25=0,'User input'!F$15,E24+'User input'!F$22))","v":""},{"$f":"IF(B25>'User input'!F$21,\"\",IF(F$57=1,F73,IF(F$57=2,H73,\"Error\")))","v":""},{"$f":"IF(B25>'User input'!F$21,\"\",IF(B25>0,F24*'User input'!L$13,0))","v":""},{"$f":"IF(B25>'User input'!F$21,\"\",IF(B25>0,F24-F25,0))","v":""},{"$f":"IF(B25>'User input'!F$21,\"\",IF(B25>7,0,IF(SUM(I$11:I24)<1,IF(B25='User input'!F$21,'User input'!L35/2,'User input'!L35),0)))","v":""},{"$f":"IF(B25>'User input'!F$21,\"\",IF(B25=0,MIN('User input'!F$16,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I25,'User input'!L$20*I25))","v":""},{"$f":"IF(B25>'User input'!F$21,\"\",IF(B25=0,'User input'!F$16-J25,K24-J25))","v":""},{"$f":"IF(B25>'User input'!F$21,\"\",IF(B25>0,('User input'!F$16-'User input'!F$18)*'User input'!L$13,0))","v":""},{"$f":"IF(B25>'User input'!F$21,\"\",IF(B25='User input'!F$21,'User input'!F$16-'User input'!F$18,0))","v":""},{"$f":"IF(B25>'User input'!F$21,\"\",IF(B25=0,'User input'!F$18,IF(B25='User input'!F$21,-F25,0)))","v":""},{"$f":"IF(B25>'User input'!F$21,\"\",IF(B25>0,'User input'!F$35*F24,0))","v":""},{"$f":"IF(B25>'User input'!F$21,\"\",(IF(E25>'User input'!L$11,(E25-'User input'!L$11)*'User input'!F$34+'User input'!J$11*'User input'!F$19*'User input'!F$32*('User input'!L$11/1000)^'User input'!K$11,'User input'!J$11*'User input'!F$19*'User input'!F$32*(E25/1000)^'User input'!K$11))*'User input'!F$33)","v":""},{"$f":"IF(B25>'User input'!F$21,\"\",IF(B25>0,(P25-P24),0))","v":""},{"$f":"IF(B25>'User input'!F$21,\"\",Q25/'User input'!F$22)","v":""},{"$f":"IF(B25>'User input'!F$21,\"\",(J25+L25+O25+Q25)*('User input'!L$15+'User input'!L$16)-IF(B25='User input'!F$21,(F25-K25)*'User input'!L$15,0))","v":""},{"$f":"IF(B25>'User input'!F$21,\"\",L25+M25+N25+O25+Q25-S25)","v":""},{"$f":"IF(B25>'User input'!F$21,\"\",C25*T25)","v":""}]
[null,{"$f":"IF(B25>='User input'!F$21,\"\",B25+1)","v":""},{"$f":"IF(B26>'User input'!F$21,\"\",'User input'!F$38^B26)","v":""},{"$f":"IF(B26>'User input'!F$21,\"\",IF(B26=0,'User input'!F$14,D25+1))","v":""},{"$f":"IF(B26>'User input'!F$21,\"\",IF(B26=0,'User input'!F$15,E25+'User input'!F$22))","v":""},{"$f":"IF(B26>'User input'!F$21,\"\",IF(F$57=1,F74,IF(F$57=2,H74,\"Error\")))","v":""},{"$f":"IF(B26>'User input'!F$21,\"\",IF(B26>0,F25*'User input'!L$13,0))","v":""},{"$f":"IF(B26>'User input'!F$21,\"\",IF(B26>0,F25-F26,0))","v":""},{"$f":"IF(B26>'User input'!F$21,\"\",IF(B26>7,0,IF(SUM(I$11:I25)<1,IF(B26='User input'!F$21,'User input'!L36/2,'User input'!L36),0)))","v":""},{"$f":"IF(B26>'User input'!F$21,\"\",IF(B26=0,MIN('User input'!F$16,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I26,'User input'!L$20*I26))","v":""},{"$f":"IF(B26>'User input'!F$21,\"\",IF(B26=0,'User input'!F$16-J26,K25-J26))","v":""},{"$f":"IF(B26>'User input'!F$21,\"\",IF(B26>0,('User input'!F$16-'User input'!F$18)*'User input'!L$13,0))","v":""},{"$f":"IF(B26>'User input'!F$21,\"\",IF(B26='User input'!F$21,'User input'!F$16-'User input'!F$18,0))","v":""},{"$f":"IF(B26>'User input'!F$21,\"\",IF(B26=0,'User input'!F$18,IF(B26='User input'!F$21,-F26,0)))","v":""},{"$f":"IF(B26>'User input'!F$21,\"\",IF(B26>0,'User input'!F$35*F25,0))","v":""},{"$f":"IF(B26>'User input'!F$21,\"\",(IF(E26>'User input'!L$11,(E26-'User input'!L$11)*'User input'!F$34+'User input'!J$11*'User input'!F$19*'User input'!F$32*('User input'!L$11/1000)^'User input'!K$11,'User input'!J$11*'User input'!F$19*'User input'!F$32*(E26/1000)^'User input'!K$11))*'User input'!F$33)","v":""},{"$f":"IF(B26>'User input'!F$21,\"\",IF(B26>0,(P26-P25),0))","v":""},{"$f":"IF(B26>'User input'!F$21,\"\",Q26/'User input'!F$22)","v":""},{"$f":"IF(B26>'User input'!F$21,\"\",(J26+L26+O26+Q26)*('User input'!L$15+'User input'!L$16)-IF(B26='User input'!F$21,(F26-K26)*'User input'!L$15,0))","v":""},{"$f":"IF(B26>'User input'!F$21,\"\",L26+M26+N26+O26+Q26-S26)","v":""},{"$f":"IF(B26>'User input'!F$21,\"\",C26*T26)","v":""}]
[null,{"$f":"IF(B26>='User input'!F$21,\"\",B26+1)","v":""},{"$f":"IF(B27>'User input'!F$21,\"\",'User input'!F$38^B27)","v":""},{"$f":"IF(B27>'User input'!F$21,\"\",IF(B27=0,'User input'!F$14,D26+1))","v":""},{"$f":"IF(B27>'User input'!F$21,\"\",IF(B27=0,'User input'!F$15,E26+'User input'!F$22))","v":""},{"$f":"IF(B27>'User input'!F$21,\"\",IF(F$57=1,F75,IF(F$57=2,H75,\"Error\")))","v":""},{"$f":"IF(B27>'User input'!F$21,\"\",IF(B27>0,F26*'User input'!L$13,0))","v":""},{"$f":"IF(B27>'User input'!F$21,\"\",IF(B27>0,F26-F27,0))","v":""},{"$f":"IF(B27>'User input'!F$21,\"\",IF(B27>7,0,IF(SUM(I$11:I26)<1,IF(B27='User input'!F$21,'User input'!L37/2,'User input'!L37),0)))","v":""},{"$f":"IF(B27>'User input'!F$21,\"\",IF(B27=0,MIN('User input'!F$16,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I27,'User input'!L$20*I27))","v":""},{"$f":"IF(B27>'User input'!F$21,\"\",IF(B27=0,'User input'!F$16-J27,K26-J27))","v":""},{"$f":"IF(B27>'User input'!F$21,\"\",IF(B27>0,('User input'!F$16-'User input'!F$18)*'User input'!L$13,0))","v":""},{"$f":"IF(B27>'User input'!F$21,\"\",IF(B27='User input'!F$21,'User input'!F$16-'User input'!F$18,0))","v":""},{"$f":"IF(B27>'User input'!F$21,\"\",IF(B27=0,'User input'!F$18,IF(B27='User input'!F$21,-F27,0)))","v":""},{"$f":"IF(B27>'User input'!F$21,\"\",IF(B27>0,'User input'!F$35*F26,0))","v":""},{"$f":"IF(B27>'User input'!F$21,\"\",(IF(E27>'User input'!L$11,(E27-'User input'!L$11)*'User input'!F$34+'User input'!J$11*'User input'!F$19*'User input'!F$32*('User input'!L$11/1000)^'User input'!K$11,'User input'!J$11*'User input'!F$19*'User input'!F$32*(E27/1000)^'User input'!K$11))*'User input'!F$33)","v":""},{"$f":"IF(B27>'User input'!F$21,\"\",IF(B27>0,(P27-P26),0))","v":""},{"$f":"IF(B27>'User input'!F$21,\"\",Q27/'User input'!F$22)","v":""},{"$f":"IF(B27>'User input'!F$21,\"\",(J27+L27+O27+Q27)*('User input'!L$15+'User input'!L$16)-IF(B27='User input'!F$21,(F27-K27)*'User input'!L$15,0))","v":""},{"$f":"IF(B27>'User input'!F$21,\"\",L27+M27+N27+O27+Q27-S27)","v":""},{"$f":"IF(B27>'User input'!F$21,\"\",C27*T27)","v":""},null,"",""]
[null,{"$f":"IF(B27>='User input'!F$21,\"\",B27+1)","v":""},{"$f":"IF(B28>'User input'!F$21,\"\",'User input'!F$38^B28)","v":""},{"$f":"IF(B28>'User input'!F$21,\"\",IF(B28=0,'User input'!F$14,D27+1))","v":""},{"$f":"IF(B28>'User input'!F$21,\"\",IF(B28=0,'User input'!F$15,E27+'User input'!F$22))","v":""},{"$f":"IF(B28>'User input'!F$21,\"\",IF(F$57=1,F76,IF(F$57=2,H76,\"Error\")))","v":""},{"$f":"IF(B28>'User input'!F$21,\"\",IF(B28>0,F27*'User input'!L$13,0))","v":""},{"$f":"IF(B28>'User input'!F$21,\"\",IF(B28>0,F27-F28,0))","v":""},{"$f":"IF(B28>'User input'!F$21,\"\",IF(B28>7,0,IF(SUM(I$11:I27)<1,IF(B28='User input'!F$21,'User input'!L38/2,'User input'!L38),0)))","v":""},{"$f":"IF(B28>'User input'!F$21,\"\",IF(B28=0,MIN('User input'!F$16,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I28,'User input'!L$20*I28))","v":""},{"$f":"IF(B28>'User input'!F$21,\"\",IF(B28=0,'User input'!F$16-J28,K27-J28))","v":""},{"$f":"IF(B28>'User input'!F$21,\"\",IF(B28>0,('User input'!F$16-'User input'!F$18)*'User input'!L$13,0))","v":""},{"$f":"IF(B28>'User input'!F$21,\"\",IF(B28='User input'!F$21,'User input'!F$16-'User input'!F$18,0))","v":""},{"$f":"IF(B28>'User input'!F$21,\"\",IF(B28=0,'User input'!F$18,IF(B28='User input'!F$21,-F28,0)))","v":""},{"$f":"IF(B28>'User input'!F$21,\"\",IF(B28>0,'User input'!F$35*F27,0))","v":""},{"$f":"IF(B28>'User input'!F$21,\"\",(IF(E28>'User input'!L$11,(E28-'User input'!L$11)*'User input'!F$34+'User input'!J$11*'User input'!F$19*'User input'!F$32*('User input'!L$11/1000)^'User input'!K$11,'User input'!J$11*'User input'!F$19*'User input'!F$32*(E28/1000)^'User input'!K$11))*'User input'!F$33)","v":""},{"$f":"IF(B28>'User input'!F$21,\"\",IF(B28>0,(P28-P27),0))","v":""},{"$f":"IF(B28>'User input'!F$21,\"\",Q28/'User input'!F$22)","v":""},{"$f":"IF(B28>'User input'!F$21,\"\",(J28+L28+O28+Q28)*('User input'!L$15+'User input'!L$16)-IF(B28='User input'!F$21,(F28-K28)*'User input'!L$15,0))","v":""},{"$f":"IF(B28>'User input'!F$21,\"\",L28+M28+N28+O28+Q28-S28)","v":""},{"$f":"IF(B28>'User input'!F$21,\"\",C28*T28)","v":""},null,"",""]
[null,{"$f":"IF(B28>='User input'!F$21,\"\",B28+1)","v":""},{"$f":"IF(B29>'User input'!F$21,\"\",'User input'!F$38^B29)","v":""},{"$f":"IF(B29>'User input'!F$21,\"\",IF(B29=0,'User input'!F$14,D28+1))","v":""},{"$f":"IF(B29>'User input'!F$21,\"\",IF(B29=0,'User input'!F$15,E28+'User input'!F$22))","v":""},{"$f":"IF(B29>'User input'!F$21,\"\",IF(F$57=1,F77,IF(F$57=2,H77,\"Error\")))","v":""},{"$f":"IF(B29>'User input'!F$21,\"\",IF(B29>0,F28*'User input'!L$13,0))","v":""},{"$f":"IF(B29>'User input'!F$21,\"\",IF(B29>0,F28-F29,0))","v":""},{"$f":"IF(B29>'User input'!F$21,\"\",IF(B29>7,0,IF(SUM(I$11:I28)<1,IF(B29='User input'!F$21,'User input'!#REF!/2,'User input'!#REF!),0)))","v":""},{"$f":"IF(B29>'User input'!F$21,\"\",IF(B29=0,MIN('User input'!F$16,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I29,'User input'!L$20*I29))","v":""},{"$f":"IF(B29>'User input'!F$21,\"\",IF(B29=0,'User input'!F$16-J29,K28-J29))","v":""},{"$f":"IF(B29>'User input'!F$21,\"\",IF(B29>0,('User input'!F$16-'User input'!F$18)*'User input'!L$13,0))","v":""},{"$f":"IF(B29>'User input'!F$21,\"\",IF(B29='User input'!F$21,'User input'!F$16-'User input'!F$18,0))","v":""},{"$f":"IF(B29>'User input'!F$21,\"\",IF(B29=0,'User input'!F$18,IF(B29='User input'!F$21,-F29,0)))","v":""},{"$f":"IF(B29>'User input'!F$21,\"\",IF(B29>0,'User input'!F$35*F28,0))","v":""},{"$f":"IF(B29>'User input'!F$21,\"\",(IF(E29>'User input'!L$11,(E29-'User input'!L$11)*'User input'!F$34+'User input'!J$11*'User input'!F$19*'User input'!F$32*('User input'!L$11/1000)^'User input'!K$11,'User input'!J$11*'User input'!F$19*'User input'!F$32*(E29/1000)^'User input'!K$11))*'User input'!F$33)","v":""},{"$f":"IF(B29>'User input'!F$21,\"\",IF(B29>0,(P29-P28),0))","v":""},{"$f":"IF(B29>'User input'!F$21,\"\",Q29/'User input'!F$22)","v":""},{"$f":"IF(B29>'User input'!F$21,\"\",(J29+L29+O29+Q29)*('User input'!L$15+'User input'!L$16)-IF(B29='User input'!F$21,(F29-K29)*'User input'!L$15,0))","v":""},{"$f":"IF(B29>'User input'!F$21,\"\",L29+M29+N29+O29+Q29-S29)","v":""},{"$f":"IF(B29>'User input'!F$21,\"\",C29*T29)","v":""},null,"",""]
[null,{"$f":"IF(B29>='User input'!F$21,\"\",B29+1)","v":""},{"$f":"IF(B30>'User input'!F$21,\"\",'User input'!F$38^B30)","v":""},{"$f":"IF(B30>'User input'!F$21,\"\",IF(B30=0,'User input'!F$14,D29+1))","v":""},{"$f":"IF(B30>'User input'!F$21,\"\",IF(B30=0,'User input'!F$15,E29+'User input'!F$22))","v":""},{"$f":"IF(B30>'User input'!F$21,\"\",IF(F$57=1,F78,IF(F$57=2,H78,\"Error\")))","v":""},{"$f":"IF(B30>'User input'!F$21,\"\",IF(B30>0,F29*'User input'!L$13,0))","v":""},{"$f":"IF(B30>'User input'!F$21,\"\",IF(B30>0,F29-F30,0))","v":""},{"$f":"IF(B30>'User input'!F$21,\"\",IF(B30>7,0,IF(SUM(I$11:I29)<1,IF(B30='User input'!F$21,'User input'!L39/2,'User input'!L39),0)))","v":""},{"$f":"IF(B30>'User input'!F$21,\"\",IF(B30=0,MIN('User input'!F$16,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I30,'User input'!L$20*I30))","v":""},{"$f":"IF(B30>'User input'!F$21,\"\",IF(B30=0,'User input'!F$16-J30,K29-J30))","v":""},{"$f":"IF(B30>'User input'!F$21,\"\",IF(B30>0,('User input'!F$16-'User input'!F$18)*'User input'!L$13,0))","v":""},{"$f":"IF(B30>'User input'!F$21,\"\",IF(B30='User input'!F$21,'User input'!F$16-'User input'!F$18,0))","v":""},{"$f":"IF(B30>'User input'!F$21,\"\",IF(B30=0,'User input'!F$18,IF(B30='User input'!F$21,-F30,0)))","v":""},{"$f":"IF(B30>'User input'!F$21,\"\",IF(B30>0,'User input'!F$35*F29,0))","v":""},{"$f":"IF(B30>'User input'!F$21,\"\",(IF(E30>'User input'!L$11,(E30-'User input'!L$11)*'User input'!F$34+'User input'!J$11*'User input'!F$19*'User input'!F$32*('User input'!L$11/1000)^'User input'!K$11,'User input'!J$11*'User input'!F$19*'User input'!F$32*(E30/1000)^'User input'!K$11))*'User input'!F$33)","v":""},{"$f":"IF(B30>'User input'!F$21,\"\",IF(B30>0,(P30-P29),0))","v":""},{"$f":"IF(B30>'User input'!F$21,\"\",Q30/'User input'!F$22)","v":""},{"$f":"IF(B30>'User input'!F$21,\"\",(J30+L30+O30+Q30)*('User input'!L$15+'User input'!L$16)-IF(B30='User input'!F$21,(F30-K30)*'User input'!L$15,0))","v":""},{"$f":"IF(B30>'User input'!F$21,\"\",L30+M30+N30+O30+Q30-S30)","v":""},{"$f":"IF(B30>'User input'!F$21,\"\",C30*T30)","v":""},null,"",""]
[null,{"$f":"IF(B30>='User input'!F$21,\"\",B30+1)","v":""},{"$f":"IF(B31>'User input'!F$21,\"\",'User input'!F$38^B31)","v":""},{"$f":"IF(B31>'User input'!F$21,\"\",IF(B31=0,'User input'!F$14,D30+1))","v":""},{"$f":"IF(B31>'User input'!F$21,\"\",IF(B31=0,'User input'!F$15,E30+'User input'!F$22))","v":""},{"$f":"IF(B31>'User input'!F$21,\"\",IF(F$57=1,F79,IF(F$57=2,H79,\"Error\")))","v":""},{"$f":"IF(B31>'User input'!F$21,\"\",IF(B31>0,F30*'User input'!L$13,0))","v":""},{"$f":"IF(B31>'User input'!F$21,\"\",IF(B31>0,F30-F31,0))","v":""},{"$f":"IF(B31>'User input'!F$21,\"\",IF(B31>7,0,IF(SUM(I$11:I30)<1,IF(B31='User input'!F$21,'User input'!#REF!/2,'User input'!#REF!),0)))","v":""},{"$f":"IF(B31>'User input'!F$21,\"\",IF(B31=0,MIN('User input'!F$16,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I31,'User input'!L$20*I31))","v":""},{"$f":"IF(B31>'User input'!F$21,\"\",IF(B31=0,'User input'!F$16-J31,K30-J31))","v":""},{"$f":"IF(B31>'User input'!F$21,\"\",IF(B31>0,('User input'!F$16-'User input'!F$18)*'User input'!L$13,0))","v":""},{"$f":"IF(B31>'User input'!F$21,\"\",IF(B31='User input'!F$21,'User input'!F$16-'User input'!F$18,0))","v":""},{"$f":"IF(B31>'User input'!F$21,\"\",IF(B31=0,'User input'!F$18,IF(B31='User input'!F$21,-F31,0)))","v":""},{"$f":"IF(B31>'User input'!F$21,\"\",IF(B31>0,'User input'!F$35*F30,0))","v":""},{"$f":"IF(B31>'User input'!F$21,\"\",(IF(E31>'User input'!L$11,(E31-'User input'!L$11)*'User input'!F$34+'User input'!J$11*'User input'!F$19*'User input'!F$32*('User input'!L$11/1000)^'User input'!K$11,'User input'!J$11*'User input'!F$19*'User input'!F$32*(E31/1000)^'User input'!K$11))*'User input'!F$33)","v":""},{"$f":"IF(B31>'User input'!F$21,\"\",IF(B31>0,(P31-P30),0))","v":""},{"$f":"IF(B31>'User input'!F$21,\"\",Q31/'User input'!F$22)","v":""},{"$f":"IF(B31>'User input'!F$21,\"\",(J31+L31+O31+Q31)*('User input'!L$15+'User input'!L$16)-IF(B31='User input'!F$21,(F31-K31)*'User input'!L$15,0))","v":""},{"$f":"IF(B31>'User input'!F$21,\"\",L31+M31+N31+O31+Q31-S31)","v":""},{"$f":"IF(B31>'User input'!F$21,\"\",C31*T31)","v":""},null,"",""]
[null,{"$f":"IF(B31>='User input'!F$21,\"\",B31+1)","v":""},{"$f":"IF(B32>'User input'!F$21,\"\",'User input'!F$38^B32)","v":""},{"$f":"IF(B32>'User input'!F$21,\"\",IF(B32=0,'User input'!F$14,D31+1))","v":""},{"$f":"IF(B32>'User input'!F$21,\"\",IF(B32=0,'User input'!F$15,E31+'User input'!F$22))","v":""},{"$f":"IF(B32>'User input'!F$21,\"\",IF(F$57=1,F80,IF(F$57=2,H80,\"Error\")))","v":""},{"$f":"IF(B32>'User input'!F$21,\"\",IF(B32>0,F31*'User input'!L$13,0))","v":""},{"$f":"IF(B32>'User input'!F$21,\"\",IF(B32>0,F31-F32,0))","v":""},{"$f":"IF(B32>'User input'!F$21,\"\",IF(B32>7,0,IF(SUM(I$11:I31)<1,IF(B32='User input'!F$21,'User input'!L40/2,'User input'!L40),0)))","v":""},{"$f":"IF(B32>'User input'!F$21,\"\",IF(B32=0,MIN('User input'!F$16,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I32,'User input'!L$20*I32))","v":""},{"$f":"IF(B32>'User input'!F$21,\"\",IF(B32=0,'User input'!F$16-J32,K31-J32))","v":""},{"$f":"IF(B32>'User input'!F$21,\"\",IF(B32>0,('User input'!F$16-'User input'!F$18)*'User input'!L$13,0))","v":""},{"$f":"IF(B32>'User input'!F$21,\"\",IF(B32='User input'!F$21,'User input'!F$16-'User input'!F$18,0))","v":""},{"$f":"IF(B32>'User input'!F$21,\"\",IF(B32=0,'User input'!F$18,IF(B32='User input'!F$21,-F32,0)))","v":""},{"$f":"IF(B32>'User input'!F$21,\"\",IF(B32>0,'User input'!F$35*F31,0))","v":""},{"$f":"IF(B32>'User input'!F$21,\"\",(IF(E32>'User input'!L$11,(E32-'User input'!L$11)*'User input'!F$34+'User input'!J$11*'User input'!F$19*'User input'!F$32*('User input'!L$11/1000)^'User input'!K$11,'User input'!J$11*'User input'!F$19*'User input'!F$32*(E32/1000)^'User input'!K$11))*'User input'!F$33)","v":""},{"$f":"IF(B32>'User input'!F$21,\"\",IF(B32>0,(P32-P31),0))","v":""},{"$f":"IF(B32>'User input'!F$21,\"\",Q32/'User input'!F$22)","v":""},{"$f":"IF(B32>'User input'!F$21,\"\",(J32+L32+O32+Q32)*('User input'!L$15+'User input'!L$16)-IF(B32='User input'!F$21,(F32-K32)*'User input'!L$15,0))","v":""},{"$f":"IF(B32>'User input'!F$21,\"\",L32+M32+N32+O32+Q32-S32)","v":""},{"$f":"IF(B32>'User input'!F$21,\"\",C32*T32)","v":""},null,"",""]
[]
[]
[null,"* EOY = End of year",null,null,null,null,null,null,{"$f":"IF(OR('User input'!L30>1.01,'User input'!L30<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'!L30>1.01,'User input'!L30<0.99),\"Go back to User Input tab and check entered values!\",\" \")","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Information to modify current depreciation formulas"]
[]
[null,"Age",null,null,null,null,{"$f":"'User input'!G11","v":-9.3716922929405477E-2},null,1980.2861424268128]
[null,"100 hours",null,null,null,null,{"$f":"'User input'!H11","v":-2.8173236964901704E-2},null,-792.16950038104858]
[null,"Age x 100 hours",null,null,null,null,{"$f":"'User input'!I11","v":1.5204710545111411E-3},null,1.017557235112692E-3]
[]
[null,null,null,null,null,1,"<= 1=original, 2=revised"]
[null,null,null,null,null,null,null,null,null,"Trade"]
[null,"Year",null,"Age","Hours","Original","Depr","Revised","Depr","diff","SSE"]
[null,0,null,{"$f":"IF(B60=0,'User input'!F$14,D59+1)","v":0},{"$f":"IF(B60=0,'User input'!F$15,E59+'User input'!F$22)","v":0},{"$f":"EXP('User input'!G$11*(D60-'User input'!F$14)+'User input'!H$11*((E60-'User input'!F$15)/100)+'User input'!I$11*(D60-'User input'!F$14)*(E60-'User input'!F$15)/100)*'User input'!F$17*IF(B12=0,1,(1-'User input'!F$76))","v":275000},{"$f":"F$60-F60","v":0},{"$f":"EXP(I$53*($D60-'User input'!$F$14)+I$54*(($E60-'User input'!$F$15)/100)+I$55*($D60-'User input'!$F$14)*($E60-'User input'!$F$15)/100)*'User input'!$F$17*IF($B60=0,1,(1-#REF!))","v":275000},{"$f":"H$60-H60","v":0},null,{"$f":"SUM(K61:K80)","v":{"$error":"#REF!"}}]
[null,{"$f":"+B60+1","v":1},null,{"$f":"IF(B61=0,'User input'!F$14,D60+1)","v":1},{"$f":"IF(B61=0,'User input'!F$15,E60+'User input'!F$22)","v":250},{"$f":"EXP('User input'!G$11*(D61-'User input'!F$14)+'User input'!H$11*((E61-'User input'!F$15)/100)+'User input'!I$11*(D61-'User input'!F$14)*(E61-'User input'!F$15)/100)*'User input'!F$17*IF(B13=0,1,(1-'User input'!F$76))","v":234257.80975407595},40742.190245924052,{"$f":"EXP(I$53*($D61-'User input'!$F$14)+I$54*(($E61-'User input'!$F$15)/100)+I$55*($D61-'User input'!$F$14)*($E61-'User input'!$F$15)/100)*'User input'!$F$17*IF($B61=0,1,(1-#REF!))","v":{"$error":"#REF!"}},{"$f":"F$60-H61","v":{"$error":"#REF!"}},38000,{"$f":"IF(J61=0,0,(I61-J61)^2)","v":{"$error":"#REF!"}}]
[null,{"$f":"+B61+1","v":2},null,{"$f":"IF(B62=0,'User input'!F$14,D61+1)","v":2},{"$f":"IF(B62=0,'User input'!F$15,E61+'User input'!F$22)","v":500},{"$f":"EXP('User input'!G$11*(D62-'User input'!F$14)+'User input'!H$11*((E62-'User input'!F$15)/100)+'User input'!I$11*(D62-'User input'!F$14)*(E62-'User input'!F$15)/100)*'User input'!F$17*IF(B14=0,1,(1-'User input'!F$76))","v":201074.5585882242},73925.441411775799,{"$f":"EXP(I$53*($D62-'User input'!$F$14)+I$54*(($E62-'User input'!$F$15)/100)+I$55*($D62-'User input'!$F$14)*($E62-'User input'!$F$15)/100)*'User input'!$F$17*IF($B62=0,1,(1-#REF!))","v":{"$error":"#REF!"}},{"$error":"#REF!"},67000,{"$f":"IF(J62=0,0,(I62-J62)^2)","v":{"$error":"#REF!"}}]
[null,3,null,{"$f":"IF(B63=0,'User input'!F$14,D62+1)","v":3},{"$f":"IF(B63=0,'User input'!F$15,E62+'User input'!F$22)","v":750},{"$f":"EXP('User input'!G$11*(D63-'User input'!F$14)+'User input'!H$11*((E63-'User input'!F$15)/100)+'User input'!I$11*(D63-'User input'!F$14)*(E63-'User input'!F$15)/100)*'User input'!F$17*IF(B15=0,1,(1-'User input'!F$76))","v":173908.90895266252},101091.09104733748,{"$f":"EXP(I$53*($D63-'User input'!$F$14)+I$54*(($E63-'User input'!$F$15)/100)+I$55*($D63-'User input'!$F$14)*($E63-'User input'!$F$15)/100)*'User input'!$F$17*IF($B63=0,1,(1-#REF!))","v":{"$error":"#REF!"}},{"$error":"#REF!"},88000,{"$error":"#REF!"}]
[null,4,null,{"$f":"IF(B64=0,'User input'!F$14,D63+1)","v":4},{"$f":"IF(B64=0,'User input'!F$15,E63+'User input'!F$22)","v":1000},{"$f":"EXP('User input'!G$11*(D64-'User input'!F$14)+'User input'!H$11*((E64-'User input'!F$15)/100)+'User input'!I$11*(D64-'User input'!F$14)*(E64-'User input'!F$15)/100)*'User input'!F$17*IF(B16=0,1,(1-'User input'!F$76))","v":151561.25679074231},123438.74320925769,{"$f":"EXP(I$53*($D64-'User input'!$F$14)+I$54*(($E64-'User input'!$F$15)/100)+I$55*($D64-'User input'!$F$14)*($E64-'User input'!$F$15)/100)*'User input'!$F$17*IF($B64=0,1,(1-#REF!))","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,0]
[null,5,null,{"$f":"IF(B65=0,'User input'!F$14,D64+1)","v":5},{"$f":"IF(B65=0,'User input'!F$15,E64+'User input'!F$22)","v":1250},{"$f":"EXP('User input'!G$11*(D65-'User input'!F$14)+'User input'!H$11*((E65-'User input'!F$15)/100)+'User input'!I$11*(D65-'User input'!F$14)*(E65-'User input'!F$15)/100)*'User input'!F$17*IF(B17=0,1,(1-'User input'!F$76))","v":133093.3100915094},141906.6899084906,{"$f":"EXP(I$53*($D65-'User input'!$F$14)+I$54*(($E65-'User input'!$F$15)/100)+I$55*($D65-'User input'!$F$14)*($E65-'User input'!$F$15)/100)*'User input'!$F$17*IF($B65=0,1,(1-#REF!))","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,0]
[null,6,null,{"$f":"IF(B66=0,'User input'!F$14,D65+1)","v":6},{"$f":"IF(B66=0,'User input'!F$15,E65+'User input'!F$22)","v":1500},{"$f":"EXP('User input'!G$11*(D66-'User input'!F$14)+'User input'!H$11*((E66-'User input'!F$15)/100)+'User input'!I$11*(D66-'User input'!F$14)*(E66-'User input'!F$15)/100)*'User input'!F$17*IF(B18=0,1,(1-'User input'!F$76))","v":117767.62468186117},157232.37531813883,{"$f":"EXP(I$53*($D66-'User input'!$F$14)+I$54*(($E66-'User input'!$F$15)/100)+I$55*($D66-'User input'!$F$14)*($E66-'User input'!$F$15)/100)*'User input'!$F$17*IF($B66=0,1,(1-#REF!))","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,0]
[null,7,null,{"$f":"IF(B67=0,'User input'!F$14,D66+1)","v":7},{"$f":"IF(B67=0,'User input'!F$15,E66+'User input'!F$22)","v":1750},{"$f":"EXP('User input'!G$11*(D67-'User input'!F$14)+'User input'!H$11*((E67-'User input'!F$15)/100)+'User input'!I$11*(D67-'User input'!F$14)*(E67-'User input'!F$15)/100)*'User input'!F$17*IF(B19=0,1,(1-'User input'!F$76))","v":105001.92616864674},169998.07383135328,{"$f":"EXP(I$53*($D67-'User input'!$F$14)+I$54*(($E67-'User input'!$F$15)/100)+I$55*($D67-'User input'!$F$14)*($E67-'User input'!$F$15)/100)*'User input'!$F$17*IF($B67=0,1,(1-#REF!))","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,0]
[null,8,null,{"$f":"IF(B68=0,'User input'!F$14,D67+1)","v":8},{"$f":"IF(B68=0,'User input'!F$15,E67+'User input'!F$22)","v":2000},{"$f":"EXP('User input'!G$11*(D68-'User input'!F$14)+'User input'!H$11*((E68-'User input'!F$15)/100)+'User input'!I$11*(D68-'User input'!F$14)*(E68-'User input'!F$15)/100)*'User input'!F$17*IF(B20=0,1,(1-'User input'!F$76))","v":94334.440311303435},180665.55968869658,{"$f":"EXP(I$53*($D68-'User input'!$F$14)+I$54*(($E68-'User input'!$F$15)/100)+I$55*($D68-'User input'!$F$14)*($E68-'User input'!$F$15)/100)*'User input'!$F$17*IF($B68=0,1,(1-#REF!))","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,0]
[null,9,null,{"$f":"IF(B69=0,'User input'!F$14,D68+1)","v":9},{"$f":"IF(B69=0,'User input'!F$15,E68+'User input'!F$22)","v":2250},{"$f":"EXP('User input'!G$11*(D69-'User input'!F$14)+'User input'!H$11*((E69-'User input'!F$15)/100)+'User input'!I$11*(D69-'User input'!F$14)*(E69-'User input'!F$15)/100)*'User input'!F$17*IF(B21=0,1,(1-'User input'!F$76))","v":85397.459160260129},189602.54083973987,{"$f":"EXP(I$53*($D69-'User input'!$F$14)+I$54*(($E69-'User input'!$F$15)/100)+I$55*($D69-'User input'!$F$14)*($E69-'User input'!$F$15)/100)*'User input'!$F$17*IF($B69=0,1,(1-#REF!))","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,0]
[null,10,null,{"$f":"IF(B70=0,'User input'!F$14,D69+1)","v":10},{"$f":"IF(B70=0,'User input'!F$15,E69+'User input'!F$22)","v":2500},{"$f":"EXP('User input'!G$11*(D70-'User input'!F$14)+'User input'!H$11*((E70-'User input'!F$15)/100)+'User input'!I$11*(D70-'User input'!F$14)*(E70-'User input'!F$15)/100)*'User input'!F$17*IF(B22=0,1,(1-'User input'!F$76))","v":77897.098668612685},197102.90133138731,{"$f":"EXP(I$53*($D70-'User input'!$F$14)+I$54*(($E70-'User input'!$F$15)/100)+I$55*($D70-'User input'!$F$14)*($E70-'User input'!$F$15)/100)*'User input'!$F$17*IF($B70=0,1,(1-#REF!))","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,0]
[null,11,null,{"$f":"IF(B71=0,'User input'!F$14,D70+1)","v":11},{"$f":"IF(B71=0,'User input'!F$15,E70+'User input'!F$22)","v":2750},{"$f":"EXP('User input'!G$11*(D71-'User input'!F$14)+'User input'!H$11*((E71-'User input'!F$15)/100)+'User input'!I$11*(D71-'User input'!F$14)*(E71-'User input'!F$15)/100)*'User input'!F$17*IF(B23=0,1,(1-'User input'!F$76))","v":71597.733819347253},203402.26618065275,{"$f":"EXP(I$53*($D71-'User input'!$F$14)+I$54*(($E71-'User input'!$F$15)/100)+I$55*($D71-'User input'!$F$14)*($E71-'User input'!$F$15)/100)*'User input'!$F$17*IF($B71=0,1,(1-#REF!))","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,0]
[null,12,null,{"$f":"IF(B72=0,'User input'!F$14,D71+1)","v":12},{"$f":"IF(B72=0,'User input'!F$15,E71+'User input'!F$22)","v":3000},{"$f":"EXP('User input'!G$11*(D72-'User input'!F$14)+'User input'!H$11*((E72-'User input'!F$15)/100)+'User input'!I$11*(D72-'User input'!F$14)*(E72-'User input'!F$15)/100)*'User input'!F$17*IF(B24=0,1,(1-'User input'!F$76))","v":66309.985266575371},208690.01473342464,{"$f":"EXP(I$53*($D72-'User input'!$F$14)+I$54*(($E72-'User input'!$F$15)/100)+I$55*($D72-'User input'!$F$14)*($E72-'User input'!$F$15)/100)*'User input'!$F$17*IF($B72=0,1,(1-#REF!))","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,0]
[null,13,null,{"$f":"IF(B73=0,'User input'!F$14,D72+1)","v":13},{"$f":"IF(B73=0,'User input'!F$15,E72+'User input'!F$22)","v":3250},{"$f":"EXP('User input'!G$11*(D73-'User input'!F$14)+'User input'!H$11*((E73-'User input'!F$15)/100)+'User input'!I$11*(D73-'User input'!F$14)*(E73-'User input'!F$15)/100)*'User input'!F$17*IF(B25=0,1,(1-'User input'!F$76))","v":61881.416638216753},213118.58336178324,{"$f":"EXP(I$53*($D73-'User input'!$F$14)+I$54*(($E73-'User input'!$F$15)/100)+I$55*($D73-'User input'!$F$14)*($E73-'User input'!$F$15)/100)*'User input'!$F$17*IF($B73=0,1,(1-#REF!))","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,0]
[null,14,null,{"$f":"IF(B74=0,'User input'!F$14,D73+1)","v":14},{"$f":"IF(B74=0,'User input'!F$15,E73+'User input'!F$22)","v":3500},{"$f":"EXP('User input'!G$11*(D74-'User input'!F$14)+'User input'!H$11*((E74-'User input'!F$15)/100)+'User input'!I$11*(D74-'User input'!F$14)*(E74-'User input'!F$15)/100)*'User input'!F$17*IF(B26=0,1,(1-'User input'!F$76))","v":58189.312252102573},216810.68774789743,{"$f":"EXP(I$53*($D74-'User input'!$F$14)+I$54*(($E74-'User input'!$F$15)/100)+I$55*($D74-'User input'!$F$14)*($E74-'User input'!$F$15)/100)*'User input'!$F$17*IF($B74=0,1,(1-#REF!))","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,0]
[null,15,null,{"$f":"IF(B75=0,'User input'!F$14,D74+1)","v":15},{"$f":"IF(B75=0,'User input'!F$15,E74+'User input'!F$22)","v":3750},{"$f":"EXP('User input'!G$11*(D75-'User input'!F$14)+'User input'!H$11*((E75-'User input'!F$15)/100)+'User input'!I$11*(D75-'User input'!F$14)*(E75-'User input'!F$15)/100)*'User input'!F$17*IF(B27=0,1,(1-'User input'!F$76))","v":55135.061337366016},219864.938662634,{"$f":"EXP(I$53*($D75-'User input'!$F$14)+I$54*(($E75-'User input'!$F$15)/100)+I$55*($D75-'User input'!$F$14)*($E75-'User input'!$F$15)/100)*'User input'!$F$17*IF($B75=0,1,(1-#REF!))","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,0]
[null,16,null,{"$f":"IF(B76=0,'User input'!F$14,D75+1)","v":16},{"$f":"IF(B76=0,'User input'!F$15,E75+'User input'!F$22)","v":4000},{"$f":"EXP('User input'!G$11*(D76-'User input'!F$14)+'User input'!H$11*((E76-'User input'!F$15)/100)+'User input'!I$11*(D76-'User input'!F$14)*(E76-'User input'!F$15)/100)*'User input'!F$17*IF(B28=0,1,(1-'User input'!F$76))","v":52639.791549701942},222360.20845029806,{"$f":"EXP(I$53*($D76-'User input'!$F$14)+I$54*(($E76-'User input'!$F$15)/100)+I$55*($D76-'User input'!$F$14)*($E76-'User input'!$F$15)/100)*'User input'!$F$17*IF($B76=0,1,(1-#REF!))","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,0]
[null,17,null,{"$f":"IF(B77=0,'User input'!F$14,D76+1)","v":17},{"$f":"IF(B77=0,'User input'!F$15,E76+'User input'!F$22)","v":4250},{"$f":"EXP('User input'!G$11*(D77-'User input'!F$14)+'User input'!H$11*((E77-'User input'!F$15)/100)+'User input'!I$11*(D77-'User input'!F$14)*(E77-'User input'!F$15)/100)*'User input'!F$17*IF(B29=0,1,(1-'User input'!F$76))","v":50640.982218242505},224359.01778175749,{"$f":"EXP(I$53*($D77-'User input'!$F$14)+I$54*(($E77-'User input'!$F$15)/100)+I$55*($D77-'User input'!$F$14)*($E77-'User input'!$F$15)/100)*'User input'!$F$17*IF($B77=0,1,(1-#REF!))","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,0]
[null,18,null,{"$f":"IF(B78=0,'User input'!F$14,D77+1)","v":18},{"$f":"IF(B78=0,'User input'!F$15,E77+'User input'!F$22)","v":4500},{"$f":"EXP('User input'!G$11*(D78-'User input'!F$14)+'User input'!H$11*((E78-'User input'!F$15)/100)+'User input'!I$11*(D78-'User input'!F$14)*(E78-'User input'!F$15)/100)*'User input'!F$17*IF(B30=0,1,(1-'User input'!F$76))","v":49089.854085138119},225910.14591486187,{"$f":"EXP(I$53*($D78-'User input'!$F$14)+I$54*(($E78-'User input'!$F$15)/100)+I$55*($D78-'User input'!$F$14)*($E78-'User input'!$F$15)/100)*'User input'!$F$17*IF($B78=0,1,(1-#REF!))","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,0]
[null,19,null,{"$f":"IF(B79=0,'User input'!F$14,D78+1)","v":19},{"$f":"IF(B79=0,'User input'!F$15,E78+'User input'!F$22)","v":4750},{"$f":"EXP('User input'!G$11*(D79-'User input'!F$14)+'User input'!H$11*((E79-'User input'!F$15)/100)+'User input'!I$11*(D79-'User input'!F$14)*(E79-'User input'!F$15)/100)*'User input'!F$17*IF(B31=0,1,(1-'User input'!F$76))","v":47949.382961403986},227050.61703859601,{"$f":"EXP(I$53*($D79-'User input'!$F$14)+I$54*(($E79-'User input'!$F$15)/100)+I$55*($D79-'User input'!$F$14)*($E79-'User input'!$F$15)/100)*'User input'!$F$17*IF($B79=0,1,(1-#REF!))","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,0]
[null,{"$f":"+B79+1","v":20},null,{"$f":"IF(B80=0,'User input'!F$14,D79+1)","v":20},{"$f":"IF(B80=0,'User input'!F$15,E79+'User input'!F$22)","v":5000},{"$f":"EXP('User input'!G$11*(D80-'User input'!F$14)+'User input'!H$11*((E80-'User input'!F$15)/100)+'User input'!I$11*(D80-'User input'!F$14)*(E80-'User input'!F$15)/100)*'User input'!F$17*IF(B32=0,1,(1-'User input'!F$76))","v":47192.823915507746},227807.17608449224,{"$f":"EXP(I$53*($D80-'User input'!$F$14)+I$54*(($E80-'User input'!$F$15)/100)+I$55*($D80-'User input'!$F$14)*($E80-'User input'!$F$15)/100)*'User input'!$F$17*IF($B80=0,1,(1-#REF!))","v":{"$error":"#REF!"}},{"$error":"#REF!"},235000,{"$error":"#REF!"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K60","v":{"$error":"#REF!"}}]

{"sheet":"Analysis summary","index":3,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Combine analysis summary section"]
[]
[null,"Analysis highlights:"]
[null,"Combine class used",null,null,null,{"$f":"VLOOKUP('User input'!F13,'User input'!B7:J10,2)","v":"JD 9670STS (spread 8r corn 30' rigid)"}]
[]
[null,"Combine purchase price",null,null,null,{"$f":"'User input'!F16","v":275000}]
[null,"Combine age when purchased",null,null,null,{"$f":"'User input'!F14","v":0}]
[null,"Hours on combine when purchased",null,null,null,{"$f":"'User input'!F15","v":0}]
[null,"Hours used per year",null,null,null,{"$f":"'User input'!F22","v":250}]
[null,"Total acres harvested per year",null,null,null,{"$f":"'User input'!F22*'User input'!F23","v":3000}]
[null,"Number of years combine is used",null,null,null,{"$f":"'User input'!F21","v":5}]
[null,"Combine value when sold",null,null,null,{"$f":"-MIN('Time and Tax (TT)'!N12:N32)","v":133093.3100915094}]
[null,"Accumulated repairs over lifetime",null,null,null,{"$f":"MAX('Time and Tax (TT)'!P12:P32)","v":20211.63993660812}]
[]
[]
[null,"Cost breakdown:"]
[null,null,null,null,null,"$/year","$/hour","$/acre"]
[null,null,"Opportunity interest",null,null,{"$f":"'User input'!L35","v":9326.8150607810603},{"$f":"F19/F$10","v":37.30726024312424},{"$f":"F19/F$11","v":3.108938353593687}]
[null,null,"Market depreciation",null,null,{"$f":"'User input'!L36","v":25631.503497378118},{"$f":"F20/F$10","v":102.52601398951248},{"$f":"F20/F$11","v":8.5438344991260387}]
[null,null,"Repair and maintenance",null,null,{"$f":"'User input'!L37","v":3508.0611187080367},{"$f":"F21/F$10","v":14.032244474832147},1.1693537062360122]
[null,null,"Tax, insurance, & shelter (TIS)",null,null,{"$f":"'User input'!L38","v":2798.0445182343178},{"$f":"F22/F$10","v":11.192178072937271},{"$f":"F22/F$11","v":0.93268150607810596}]
[null,"SUBTOTAL1",null,null,null,{"$f":"SUM(F19:F22)","v":41264.424195101536},{"$f":"SUM(G19:G22)","v":165.05769678040613},{"$f":"SUM(H19:H22)","v":13.754808065033844}]
[]
[null,null,"Labor",null,null,{"$f":"'User input'!F22/'User input'!F77*'User input'!F25*'User input'!F26","v":6696.4285714285716},{"$f":"F25/F$10","v":26.785714285714285},2.2321428571428572]
[null,null,"Fuel and lubrication",null,null,{"$f":"'User input'!F22/'User input'!F77*'User input'!F28*'User input'!F29*(1+'User input'!F30)","v":10165.178571428572},{"$f":"F26/F$10","v":40.660714285714292},3.3883928571428577]
[null,"SUBTOTAL",null,null,null,{"$f":"SUM(F25:F26)","v":16861.607142857145},{"$f":"SUM(G25:G26)","v":67.446428571428584},{"$f":"SUM(H25:H26)","v":5.6205357142857153}]
[]
[null,"Total for combine",null,null,null,{"$f":"F23+F27","v":58126.031337958681},{"$f":"G23+G27","v":232.50412535183472},{"$f":"H23+H27","v":19.375343779319557}]
[]
[null,"1 Can be compared to combine rental rates if labor and fuel & lubrication are excluded."]
[]
[null,"Date of analysis =====>",null,null,{"$f":"NOW()","v":"2016-06-29T10:31:37.400"}]