{"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":4,"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":[[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],[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 Tractor"]
[]
[null,"An Excel spreadsheet to evaluate the economic costs of owning and operating a tractor."]
[]
[]
[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 Tractor Ownership with the Own Tractor 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":65,"n_cols":13,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[]
[null,"User Input and related calculations section (blue shaded cells are inputs)"]
[]
[null,"Information pertaining to tractor depreciation and repairs"]
[null,null,null,null,null,null,null,"Depreciation factors",null,"Repair factors"]
[null,null,"Tractor class",null,null,null,null,"year","100 hrs use","RF1","RF2"]
[null,null,1,"John Deere 2wd and MFWD",null,null,null,-5.2432507741369733E-2,-3.3801403928660737E-3,5.0000000000000001E-3,2]
[null,null,2,"Case-IH 2wd and MFWD",null,null,null,-5.8768899516356568E-2,-3.5819670311883355E-3,5.0000000000000001E-3,2]
[null,null,3,"AGCO 2wd and MFWD",null,null,null,-6.2191398791518818E-2,-4.8999105159627876E-3,5.0000000000000001E-3,2]
[null,null,4,"John Deere full time 4wd",null,null,null,-5.1666339475911371E-2,-3.9555385619431324E-3,3.0000000000000001E-3,2]
[null,null,5,"Case-IH full time 4wd",null,null,null,-6.0271955056237635E-2,-4.3340175544377959E-3,3.0000000000000001E-3,2]
[null,null,6,"Cat / JD Track tractors",null,null,null,-6.5900919231600852E-2,-5.8505755817096182E-3,3.0000000000000001E-3,2]
[]
[null,null,null,"Factors used in analysis =>",{"$f":"IF($F17=1,D7,IF($F17=2,D8,IF($F17=3,D9,IF($F17=4,D10,IF($F17=5,D11,IF($F17=6,D12,\"NA\"))))))","v":"Case-IH 2wd and MFWD"},null,null,{"$f":"IF($F17=1,H7,IF($F17=2,H8,IF($F17=3,H9,IF($F17=4,H10,IF($F17=5,H11,IF($F17=6,H12,\"NA\"))))))","v":-5.8768899516356568E-2},{"$f":"IF($F17=1,I7,IF($F17=2,I8,IF($F17=3,I9,IF($F17=4,I10,IF($F17=5,I11,IF($F17=6,I12,\"NA\"))))))","v":-3.5819670311883355E-3},{"$f":"IF($F17=1,J7,IF($F17=2,J8,IF($F17=3,J9,IF($F17=4,J10,IF($F17=5,J11,IF($F17=6,J12,\"NA\"))))))","v":5.0000000000000001E-3},{"$f":"IF($F17=1,K7,IF($F17=2,K8,IF($F17=3,K9,IF($F17=4,K10,IF($F17=5,K11,IF($F17=6,K12,\"NA\"))))))","v":2}]
[]
[null,null,null,null,null,null,null,{"$f":"IF(L17>'User input'!F63,\"Section-179 exceeds maximum allowed!\",IF(AND(F18>'User input'!F65,L18=1),\"Bonus 1st-yr depreciation is NOT available!\",\"\"))","v":""}]
[null,"Tractor class (1-6)",null,null,null,2,null,{"$f":"\"Section-179 deduction (max of $\"&FIXED('User input'!F63,0)&\" in \"&FIXED('User input'!F62,0,1)&\")\"","v":"Section-179 deduction (max of $500,000 in 2016)"},null,null,null,0]
[null,"Tractor age in years",null,null,null,0,null,{"$f":"FIXED('User input'!F64*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,"Hours on tractor",null,null,null,0,null,"Calculated bonus yr-1 depreciation",null,null,null,{"$f":"IF(AND(F18=0,L18=1),(F21-MIN(F21,MIN('User input'!F63,L17)))*'User input'!F64,0)","v":80000}]
[null,null,null,null,null,null,null,"Calculated net $ amount to depreciate",null,null,null,{"$f":"F21-MIN(F21,MIN('User input'!F63,L17))-L19","v":80000}]
[null,"Purchase price of tractor w/o trade-in",null,null,null,160000,null,"1st year MACRS depreciation rate",null,null,null,0.1429]
[null,"Market price of tractor",null,null,null,160000,null,"2nd year MACRS depreciation rate",null,null,null,0.24490000000000001]
[null,"Cash downpayment",null,null,null,50000,null,"3rd year MACRS depreciation rate",null,null,null,0.1749]
[null,"Calculated new equivalent price (NEP)",null,null,null,{"$f":"F22/EXP(H14*F18+I14*F19/100)","v":160000},null,"4th year MACRS depreciation rate",null,null,null,0.1249]
[null,null,null,null,null,null,null,"5th year MACRS depreciation rate",null,null,null,8.9300000000000004E-2]
[null,"No. of seasons (years) before trade (maximum 20)",null,null,null,4,null,"6th year MACRS depreciation rate",null,null,null,8.9200000000000002E-2]
[null,"Hours tractor will be used annually",null,null,null,600,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,"Repair adjustment factor (0.8 to 1.2, usually 1) (RAF)",null,null,null,1,null,"Calculated error check of depreciation rates",null,null,null,{"$f":"SUM(L21:L28)","v":1.0000000000000002},{"$f":"IF(OR(L29>1.01,L29<0.99),\"<= Error!\",\" \")","v":" "}]
[null,"Tax, insurance, & shelter (TIS - % of value, decimal)",null,null,null,1.4999999999999999E-2,null,{"$f":"IF(OR(L29>1.01,L29<0.99),\"Total depreciation rate should add to 100%!\",\" \")","v":" "}]
[null,null,null,null,null,null,null,"Calculated after-tax NPVc from TT section",null,null,null,{"$f":"'Time and Tax (TT)'!U4","v":34381.035095396364}]
[null,"Bank interest rate (enter as decimal)",null,null,null,0.05,null,"Calculated after-tax amortized NPV from TT",null,null,null,{"$f":"F36*L31","v":9301.4630241851173}]
[null,"State + U.S. marginal income tax rate (decimal)",null,null,null,0.2,null,"Calculated pre-tax amortized NPV from TT",null,null,null,{"$f":"L32/(1-F33-F34)","v":14376.29524603573}]
[null,"Self-employment tax (0 if corporation)",null,null,null,0.153,null,"  Prorated to opportunity interest",null,null,null,{"$f":"L33*'Time and Tax (TT)'!G7","v":4791.244756442361}]
[null,"Calculated after-tax discount rate",null,null,null,{"$f":"F32*(1-F33-F34)","v":3.2350000000000004E-2},null,"  Prorated to market depreciation",null,null,null,{"$f":"L33*'Time and Tax (TT)'!H7","v":7390.4260668568768}]
[null,"Calculated after-tax amortization factor",null,null,null,{"$f":"F35/(1-(1+F35)^-F26)","v":0.27054051742120433},null,"  Prorated to repairs",null,null,null,{"$f":"L33*'Time and Tax (TT)'!Q7","v":757.25099580378173}]
[null,"Calculated 1-year after-tax discount factor",null,null,null,{"$f":"1/(1+F35)","v":0.96866372838669046},null,"  Prorated to tax, insurance, & shelter (TIS)",null,null,null,{"$f":"L33*'Time and Tax (TT)'!O7","v":1437.3734269327085}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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]

{"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":34381.035095396364}]
[]
[null,null,null,null,null,"after-tax NPV =>",{"$f":"SUMPRODUCT($C12:$C32,G12:G32)*(1-'User input'!$F33-'User input'!$F34)","v":17084.665849497826},{"$f":"SUMPRODUCT($C12:$C32,H12:H32)*(1-'User input'!$F33-'User input'!$F34)","v":26352.851139131148},null,null,null,null,null,"after-tax NPV =>",{"$f":"SUMPRODUCT($C12:$C32,O12:O32)*(1-'User input'!$F33-'User input'!$F34)","v":5125.399754849348},null,{"$f":"SUMPRODUCT($C12:$C32,Q12:Q32)*(1-'User input'!$F33-'User input'!$F34)","v":2700.2127599746068}]
[null,null,null,null,null,"% of total =>",{"$f":"G6/($G6+$H6+$O6+$Q6)","v":0.33327395371652158},{"$f":"H6/($G6+$H6+$O6+$Q6)","v":0.5140702761300614},null,null,null,null,null,"% of total =>",{"$f":"O6/($G6+$H6+$O6+$Q6)","v":9.9982186114956489E-2},null,{"$f":"Q6/($G6+$H6+$O6+$Q6)","v":5.2673584038460397E-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'!F26","v":1.92}]
[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$26,\"\",'User input'!F$37^B12)","v":1},{"$f":"IF(B12>'User input'!F$26,\"\",IF(B12=0,'User input'!F$18,D11+1))","v":0},{"$f":"IF(B12>'User input'!F$26,\"\",IF(B12=0,'User input'!F$19,E11+'User input'!F$27))","v":0},{"$f":"IF(B12>'User input'!F$26,\"\",EXP('User input'!H$14*(D12-'User input'!F$18)+'User input'!I$14*((E12-'User input'!F$19)/100))*'User input'!F$22)","v":160000},{"$f":"IF(B12>'User input'!F$26,\"\",IF(B12>0,F11*'User input'!F$32,0))","v":0},{"$f":"IF(B12>'User input'!F$26,\"\",IF(B12>0,F11-F12,0))","v":0},{"$f":"IF(B12>'User input'!F$26,\"\",IF(B12>7,0,IF(SUM(I$11:I11)<1,IF(B12='User input'!F$26,'User input'!L21/2,'User input'!L21),0)))","v":0.1429},{"$f":"IF(B12>'User input'!F$26,\"\",IF(B12=0,MIN('User input'!F$21,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I12,'User input'!L$20*I12))","v":91432},{"$f":"IF(B12>'User input'!F$26,\"\",IF(B12=0,'User input'!F$21-J12,K11-J12))","v":68568},{"$f":"IF(B12>'User input'!F$26,\"\",IF(B12>0,('User input'!F$21-'User input'!F$23)*'User input'!F$32,0))","v":0},{"$f":"IF(B12>'User input'!F$26,\"\",IF(B12='User input'!F$26,'User input'!F$21-'User input'!F$23,0))","v":0},{"$f":"IF(B12>'User input'!F$26,\"\",IF(B12=0,'User input'!F$23,IF(B12='User input'!F$26,-F12,0)))","v":50000},{"$f":"IF(B12>'User input'!F$26,\"\",IF(B12>0,'User input'!F$30*F11,0))","v":0},{"$f":"IF(B12>'User input'!F$26,\"\",'User input'!J$14*'User input'!F$24*(E12/1000)^'User input'!K$14*'User input'!F$29)","v":0},{"$f":"IF(B12>'User input'!F$26,\"\",IF(B12>0,(P12-P11),0))","v":0},{"$f":"IF(B12>'User input'!F$26,\"\",Q12/'User input'!F$27)","v":0},{"$f":"IF(B12>'User input'!F$26,\"\",(J12+L12+O12+Q12)*('User input'!F$33+'User input'!F$34)-IF(B12='User input'!F$26,(F12-K12)*'User input'!F$33,0))","v":32275.495999999999},{"$f":"IF(B12>'User input'!F$26,\"\",L12+M12+N12+O12+Q12-S12)","v":17724.504000000001},{"$f":"IF(B12>'User input'!F$26,\"\",C12*T12)","v":17724.504000000001}]
[null,{"$f":"IF(B12>='User input'!F$26,\"\",B12+1)","v":1},{"$f":"IF(B13>'User input'!F$26,\"\",'User input'!F$37^B13)","v":0.96866372838669046},{"$f":"IF(B13>'User input'!F$26,\"\",IF(B13=0,'User input'!F$18,D12+1))","v":1},{"$f":"IF(B13>'User input'!F$26,\"\",IF(B13=0,'User input'!F$19,E12+'User input'!F$27))","v":600},{"$f":"IF(B13>'User input'!F$26,\"\",EXP('User input'!H$14*(D13-'User input'!F$18)+'User input'!I$14*((E13-'User input'!F$19)/100))*'User input'!F$22)","v":147660.11515997862},{"$f":"IF(B13>'User input'!F$26,\"\",IF(B13>0,F12*'User input'!F$32,0))","v":8000},{"$f":"IF(B13>'User input'!F$26,\"\",IF(B13>0,F12-F13,0))","v":12339.884840021376},{"$f":"IF(B13>'User input'!F$26,\"\",IF(B13>7,0,IF(SUM(I$11:I12)<1,IF(B13='User input'!F$26,'User input'!L22/2,'User input'!L22),0)))","v":0.24490000000000001},{"$f":"IF(B13>'User input'!F$26,\"\",IF(B13=0,MIN('User input'!F$21,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I13,'User input'!L$20*I13))","v":19592},{"$f":"IF(B13>'User input'!F$26,\"\",IF(B13=0,'User input'!F$21-J13,K12-J13))","v":48976},{"$f":"IF(B13>'User input'!F$26,\"\",IF(B13>0,('User input'!F$21-'User input'!F$23)*'User input'!F$32,0))","v":5500},{"$f":"IF(B13>'User input'!F$26,\"\",IF(B13='User input'!F$26,'User input'!F$21-'User input'!F$23,0))","v":0},{"$f":"IF(B13>'User input'!F$26,\"\",IF(B13=0,'User input'!F$23,IF(B13='User input'!F$26,-F13,0)))","v":0},{"$f":"IF(B13>'User input'!F$26,\"\",IF(B13>0,'User input'!F$30*F12,0))","v":2400},{"$f":"IF(B13>'User input'!F$26,\"\",'User input'!J$14*'User input'!F$24*(E13/1000)^'User input'!K$14*'User input'!F$29)","v":288},{"$f":"IF(B13>'User input'!F$26,\"\",IF(B13>0,(P13-P12),0))","v":288},{"$f":"IF(B13>'User input'!F$26,\"\",Q13/'User input'!F$27)","v":0.48},{"$f":"IF(B13>'User input'!F$26,\"\",(J13+L13+O13+Q13)*('User input'!F$33+'User input'!F$34)-IF(B13='User input'!F$26,(F13-K13)*'User input'!F$33,0))","v":9806.34},{"$f":"IF(B13>'User input'!F$26,\"\",L13+M13+N13+O13+Q13-S13)","v":-1618.3400000000001},{"$f":"IF(B13>'User input'!F$26,\"\",C13*T13)","v":-1567.6272581973167}]
[null,{"$f":"IF(B13>='User input'!F$26,\"\",B13+1)","v":2},{"$f":"IF(B14>'User input'!F$26,\"\",'User input'!F$37^B14)","v":0.93830941869200402},{"$f":"IF(B14>'User input'!F$26,\"\",IF(B14=0,'User input'!F$18,D13+1))","v":2},{"$f":"IF(B14>'User input'!F$26,\"\",IF(B14=0,'User input'!F$19,E13+'User input'!F$27))","v":1200},{"$f":"IF(B14>'User input'!F$26,\"\",EXP('User input'!H$14*(D14-'User input'!F$18)+'User input'!I$14*((E14-'User input'!F$19)/100))*'User input'!F$22)","v":136271.93505661341},{"$f":"IF(B14>'User input'!F$26,\"\",IF(B14>0,F13*'User input'!F$32,0))","v":7383.0057579989316},{"$f":"IF(B14>'User input'!F$26,\"\",IF(B14>0,F13-F14,0))","v":11388.180103365215},{"$f":"IF(B14>'User input'!F$26,\"\",IF(B14>7,0,IF(SUM(I$11:I13)<1,IF(B14='User input'!F$26,'User input'!L23/2,'User input'!L23),0)))","v":0.1749},{"$f":"IF(B14>'User input'!F$26,\"\",IF(B14=0,MIN('User input'!F$21,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I14,'User input'!L$20*I14))","v":13992},{"$f":"IF(B14>'User input'!F$26,\"\",IF(B14=0,'User input'!F$21-J14,K13-J14))","v":34984},{"$f":"IF(B14>'User input'!F$26,\"\",IF(B14>0,('User input'!F$21-'User input'!F$23)*'User input'!F$32,0))","v":5500},{"$f":"IF(B14>'User input'!F$26,\"\",IF(B14='User input'!F$26,'User input'!F$21-'User input'!F$23,0))","v":0},{"$f":"IF(B14>'User input'!F$26,\"\",IF(B14=0,'User input'!F$23,IF(B14='User input'!F$26,-F14,0)))","v":0},{"$f":"IF(B14>'User input'!F$26,\"\",IF(B14>0,'User input'!F$30*F13,0))","v":2214.9017273996792},{"$f":"IF(B14>'User input'!F$26,\"\",'User input'!J$14*'User input'!F$24*(E14/1000)^'User input'!K$14*'User input'!F$29)","v":1152},{"$f":"IF(B14>'User input'!F$26,\"\",IF(B14>0,(P14-P13),0))","v":864},{"$f":"IF(B14>'User input'!F$26,\"\",Q14/'User input'!F$27)","v":1.44},{"$f":"IF(B14>'User input'!F$26,\"\",(J14+L14+O14+Q14)*('User input'!F$33+'User input'!F$34)-IF(B14='User input'!F$26,(F14-K14)*'User input'!F$33,0))","v":7967.5283097720867},{"$f":"IF(B14>'User input'!F$26,\"\",L14+M14+N14+O14+Q14-S14)","v":611.37341762759297},{"$f":"IF(B14>'User input'!F$26,\"\",C14*T14)","v":573.65743609789058}]
[null,{"$f":"IF(B14>='User input'!F$26,\"\",B14+1)","v":3},{"$f":"IF(B15>'User input'!F$26,\"\",'User input'!F$37^B15)","v":0.90890629989054483},{"$f":"IF(B15>'User input'!F$26,\"\",IF(B15=0,'User input'!F$18,D14+1))","v":3},{"$f":"IF(B15>'User input'!F$26,\"\",IF(B15=0,'User input'!F$19,E14+'User input'!F$27))","v":1800},{"$f":"IF(B15>'User input'!F$26,\"\",EXP('User input'!H$14*(D15-'User input'!F$18)+'User input'!I$14*((E15-'User input'!F$19)/100))*'User input'!F$22)","v":125762.06014707916},{"$f":"IF(B15>'User input'!F$26,\"\",IF(B15>0,F14*'User input'!F$32,0))","v":6813.596752830671},{"$f":"IF(B15>'User input'!F$26,\"\",IF(B15>0,F14-F15,0))","v":10509.87490953425},{"$f":"IF(B15>'User input'!F$26,\"\",IF(B15>7,0,IF(SUM(I$11:I14)<1,IF(B15='User input'!F$26,'User input'!L24/2,'User input'!L24),0)))","v":0.1249},{"$f":"IF(B15>'User input'!F$26,\"\",IF(B15=0,MIN('User input'!F$21,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I15,'User input'!L$20*I15))","v":9992},{"$f":"IF(B15>'User input'!F$26,\"\",IF(B15=0,'User input'!F$21-J15,K14-J15))","v":24992},{"$f":"IF(B15>'User input'!F$26,\"\",IF(B15>0,('User input'!F$21-'User input'!F$23)*'User input'!F$32,0))","v":5500},{"$f":"IF(B15>'User input'!F$26,\"\",IF(B15='User input'!F$26,'User input'!F$21-'User input'!F$23,0))","v":0},{"$f":"IF(B15>'User input'!F$26,\"\",IF(B15=0,'User input'!F$23,IF(B15='User input'!F$26,-F15,0)))","v":0},{"$f":"IF(B15>'User input'!F$26,\"\",IF(B15>0,'User input'!F$30*F14,0))","v":2044.0790258492011},{"$f":"IF(B15>'User input'!F$26,\"\",'User input'!J$14*'User input'!F$24*(E15/1000)^'User input'!K$14*'User input'!F$29)","v":2592},{"$f":"IF(B15>'User input'!F$26,\"\",IF(B15>0,(P15-P14),0))","v":1440},{"$f":"IF(B15>'User input'!F$26,\"\",Q15/'User input'!F$27)","v":2.4},{"$f":"IF(B15>'User input'!F$26,\"\",(J15+L15+O15+Q15)*('User input'!F$33+'User input'!F$34)-IF(B15='User input'!F$26,(F15-K15)*'User input'!F$33,0))","v":6698.555896124768},{"$f":"IF(B15>'User input'!F$26,\"\",L15+M15+N15+O15+Q15-S15)","v":2285.5231297244336},{"$f":"IF(B15>'User input'!F$26,\"\",C15*T15)","v":2077.3263711520926}]
[null,{"$f":"IF(B15>='User input'!F$26,\"\",B15+1)","v":4},{"$f":"IF(B16>'User input'!F$26,\"\",'User input'!F$37^B16)","v":0.88042456520612644},{"$f":"IF(B16>'User input'!F$26,\"\",IF(B16=0,'User input'!F$18,D15+1))","v":4},{"$f":"IF(B16>'User input'!F$26,\"\",IF(B16=0,'User input'!F$19,E15+'User input'!F$27))","v":2400},{"$f":"IF(B16>'User input'!F$26,\"\",EXP('User input'!H$14*(D16-'User input'!F$18)+'User input'!I$14*((E16-'User input'!F$19)/100))*'User input'!F$22)","v":116062.75177546169},{"$f":"IF(B16>'User input'!F$26,\"\",IF(B16>0,F15*'User input'!F$32,0))","v":6288.1030073539587},{"$f":"IF(B16>'User input'!F$26,\"\",IF(B16>0,F15-F16,0))","v":9699.3083716174733},{"$f":"IF(B16>'User input'!F$26,\"\",IF(B16>7,0,IF(SUM(I$11:I15)<1,IF(B16='User input'!F$26,'User input'!L25/2,'User input'!L25),0)))","v":4.4650000000000002E-2},{"$f":"IF(B16>'User input'!F$26,\"\",IF(B16=0,MIN('User input'!F$21,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I16,'User input'!L$20*I16))","v":3572},{"$f":"IF(B16>'User input'!F$26,\"\",IF(B16=0,'User input'!F$21-J16,K15-J16))","v":21420},{"$f":"IF(B16>'User input'!F$26,\"\",IF(B16>0,('User input'!F$21-'User input'!F$23)*'User input'!F$32,0))","v":5500},{"$f":"IF(B16>'User input'!F$26,\"\",IF(B16='User input'!F$26,'User input'!F$21-'User input'!F$23,0))","v":110000},{"$f":"IF(B16>'User input'!F$26,\"\",IF(B16=0,'User input'!F$23,IF(B16='User input'!F$26,-F16,0)))","v":-116062.75177546169},{"$f":"IF(B16>'User input'!F$26,\"\",IF(B16>0,'User input'!F$30*F15,0))","v":1886.4309022061873},{"$f":"IF(B16>'User input'!F$26,\"\",'User input'!J$14*'User input'!F$24*(E16/1000)^'User input'!K$14*'User input'!F$29)","v":4608},{"$f":"IF(B16>'User input'!F$26,\"\",IF(B16>0,(P16-P15),0))","v":2016},{"$f":"IF(B16>'User input'!F$26,\"\",Q16/'User input'!F$27)","v":3.36},{"$f":"IF(B16>'User input'!F$26,\"\",(J16+L16+O16+Q16)*('User input'!F$33+'User input'!F$34)-IF(B16='User input'!F$26,(F16-K16)*'User input'!F$33,0))","v":-14348.576246613555},{"$f":"IF(B16>'User input'!F$26,\"\",L16+M16+N16+O16+Q16-S16)","v":17688.255373358057},{"$f":"IF(B16>'User input'!F$26,\"\",C16*T16)","v":15573.174546343696}]
[null,{"$f":"IF(B16>='User input'!F$26,\"\",B16+1)","v":""},{"$f":"IF(B17>'User input'!F$26,\"\",'User input'!F$37^B17)","v":""},{"$f":"IF(B17>'User input'!F$26,\"\",IF(B17=0,'User input'!F$18,D16+1))","v":""},{"$f":"IF(B17>'User input'!F$26,\"\",IF(B17=0,'User input'!F$19,E16+'User input'!F$27))","v":""},{"$f":"IF(B17>'User input'!F$26,\"\",EXP('User input'!H$14*(D17-'User input'!F$18)+'User input'!I$14*((E17-'User input'!F$19)/100))*'User input'!F$22)","v":""},{"$f":"IF(B17>'User input'!F$26,\"\",IF(B17>0,F16*'User input'!F$32,0))","v":""},{"$f":"IF(B17>'User input'!F$26,\"\",IF(B17>0,F16-F17,0))","v":""},{"$f":"IF(B17>'User input'!F$26,\"\",IF(B17>7,0,IF(SUM(I$11:I16)<1,IF(B17='User input'!F$26,'User input'!L26/2,'User input'!L26),0)))","v":""},{"$f":"IF(B17>'User input'!F$26,\"\",IF(B17=0,MIN('User input'!F$21,'User input'!L$17)+'User input'!L$19+'User input'!L$20*I17,'User input'!L$20*I17))","v":""},{"$f":"IF(B17>'User input'!F$26,\"\",IF(B17=0,'User input'!F$21-J17,K16-J17))","v":""},{"$f":"IF(B17>'User input'!F$26,\"\",IF(B17>0,('User input'!F$21-'User input'!F$23)*'User input'!F$32,0))","v":""},{"$f":"IF(B17>'User input'!F$26,\"\",IF(B17='User input'!F$26,'User input'!F$21-'User input'!F$23,0))","v":""},{"$f":"IF(B17>'User input'!F$26,\"\",IF(B17=0,'User input'!F$23,IF(B17='User input'!F$26,-F17,0)))","v":""},{"$f":"IF(B17>'User input'!F$26,\"\",IF(B17>0,'User input'!F$30*F16,0))","v":""},{"$f":"IF(B17>'User input'!F$26,\"\",'User input'!J$14*'User input'!F$24*(E17/1000)^'User input'!K$14*'User input'!F$29)","v":""},{"$f":"IF(B17>'User input'!F$26,\"\",IF(B17>0,(P17-P16),0))","v":""},{"$f":"IF(B17>'User input'!F$26,\"\",Q17/'User input'!F$27)","v":""},{"$f":"IF(B17>'User input'!F$26,\"\",(J17+L17+O17+Q17)*('User input'!F$33+'User input'!F$34)-IF(B17='User input'!F$26,(F17-K17)*'User input'!F$33,0))","v":""},{"$f":"IF(B17>'User input'!F$26,\"\",L17+M17+N17+O17+Q17-S17)","v":""},{"$f":"IF(B17>'User input'!F$26,\"\",C17*T17)","v":""}]
[null,{"$f":"IF(B17>='User input'!F$26,\"\",B17+1)","v":""},{"$f":"IF(B18>'User input'!F$26,\"\",'User input'!F$37^B18)","v":""},{"$f":"IF(B18>'User input'!F$26,\"\",IF(B18=0,'User input'!F$18,D17+1))","v":""},{"$f":"IF(B18>'User input'!F$26,\"\",IF(B18=0,'User input'!F$19,E17+'User input'!F$27))","v":""},{"$f":"IF(B18>'User input'!F$26,\"\",EXP('User input'!H$14*(D18-'User input'!F$18)+'User input'!I$14*((E18-'User input'!F$19)/100))*'User input'!F$22)","v":""},{"$f":"IF(B18>'User input'!F$26,\"\",IF(B18>0,F17*'User input'!F$32,0))","v":""},{"$f":"IF(B18>'User input'!F$26,\"\",IF(B18>0,F17-F18,0))","v":""},{"$f":"IF(B18>'User input'!F$26,\"\",IF(B18>7,0,IF(SUM(I$11:I17)<1,IF(B18='User input'!F$26,'User input'!L27/2,'User input'!L27),0)))","v":""},{"$f":"IF(B18>'User input'!F$26,\"\",IF(B18=0,MIN('User input'!F$21,'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$26,\"\",IF(B18=0,'User input'!F$21-J18,K17-J18))","v":""},{"$f":"IF(B18>'User input'!F$26,\"\",IF(B18>0,('User input'!F$21-'User input'!F$23)*'User input'!F$32,0))","v":""},{"$f":"IF(B18>'User input'!F$26,\"\",IF(B18='User input'!F$26,'User input'!F$21-'User input'!F$23,0))","v":""},{"$f":"IF(B18>'User input'!F$26,\"\",IF(B18=0,'User input'!F$23,IF(B18='User input'!F$26,-F18,0)))","v":""},{"$f":"IF(B18>'User input'!F$26,\"\",IF(B18>0,'User input'!F$30*F17,0))","v":""},{"$f":"IF(B18>'User input'!F$26,\"\",'User input'!J$14*'User input'!F$24*(E18/1000)^'User input'!K$14*'User input'!F$29)","v":""},{"$f":"IF(B18>'User input'!F$26,\"\",IF(B18>0,(P18-P17),0))","v":""},{"$f":"IF(B18>'User input'!F$26,\"\",Q18/'User input'!F$27)","v":""},{"$f":"IF(B18>'User input'!F$26,\"\",(J18+L18+O18+Q18)*('User input'!F$33+'User input'!F$34)-IF(B18='User input'!F$26,(F18-K18)*'User input'!F$33,0))","v":""},{"$f":"IF(B18>'User input'!F$26,\"\",L18+M18+N18+O18+Q18-S18)","v":""},{"$f":"IF(B18>'User input'!F$26,\"\",C18*T18)","v":""}]
[null,{"$f":"IF(B18>='User input'!F$26,\"\",B18+1)","v":""},{"$f":"IF(B19>'User input'!F$26,\"\",'User input'!F$37^B19)","v":""},{"$f":"IF(B19>'User input'!F$26,\"\",IF(B19=0,'User input'!F$18,D18+1))","v":""},{"$f":"IF(B19>'User input'!F$26,\"\",IF(B19=0,'User input'!F$19,E18+'User input'!F$27))","v":""},{"$f":"IF(B19>'User input'!F$26,\"\",EXP('User input'!H$14*(D19-'User input'!F$18)+'User input'!I$14*((E19-'User input'!F$19)/100))*'User input'!F$22)","v":""},{"$f":"IF(B19>'User input'!F$26,\"\",IF(B19>0,F18*'User input'!F$32,0))","v":""},{"$f":"IF(B19>'User input'!F$26,\"\",IF(B19>0,F18-F19,0))","v":""},{"$f":"IF(B19>'User input'!F$26,\"\",IF(B19>7,0,IF(SUM(I$11:I18)<1,IF(B19='User input'!F$26,'User input'!L28/2,'User input'!L28),0)))","v":""},{"$f":"IF(B19>'User input'!F$26,\"\",IF(B19=0,MIN('User input'!F$21,'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$26,\"\",IF(B19=0,'User input'!F$21-J19,K18-J19))","v":""},{"$f":"IF(B19>'User input'!F$26,\"\",IF(B19>0,('User input'!F$21-'User input'!F$23)*'User input'!F$32,0))","v":""},{"$f":"IF(B19>'User input'!F$26,\"\",IF(B19='User input'!F$26,'User input'!F$21-'User input'!F$23,0))","v":""},{"$f":"IF(B19>'User input'!F$26,\"\",IF(B19=0,'User input'!F$23,IF(B19='User input'!F$26,-F19,0)))","v":""},{"$f":"IF(B19>'User input'!F$26,\"\",IF(B19>0,'User input'!F$30*F18,0))","v":""},{"$f":"IF(B19>'User input'!F$26,\"\",'User input'!J$14*'User input'!F$24*(E19/1000)^'User input'!K$14*'User input'!F$29)","v":""},{"$f":"IF(B19>'User input'!F$26,\"\",IF(B19>0,(P19-P18),0))","v":""},{"$f":"IF(B19>'User input'!F$26,\"\",Q19/'User input'!F$27)","v":""},{"$f":"IF(B19>'User input'!F$26,\"\",(J19+L19+O19+Q19)*('User input'!F$33+'User input'!F$34)-IF(B19='User input'!F$26,(F19-K19)*'User input'!F$33,0))","v":""},{"$f":"IF(B19>'User input'!F$26,\"\",L19+M19+N19+O19+Q19-S19)","v":""},{"$f":"IF(B19>'User input'!F$26,\"\",C19*T19)","v":""}]
[null,{"$f":"IF(B19>='User input'!F$26,\"\",B19+1)","v":""},{"$f":"IF(B20>'User input'!F$26,\"\",'User input'!F$37^B20)","v":""},{"$f":"IF(B20>'User input'!F$26,\"\",IF(B20=0,'User input'!F$18,D19+1))","v":""},{"$f":"IF(B20>'User input'!F$26,\"\",IF(B20=0,'User input'!F$19,E19+'User input'!F$27))","v":""},{"$f":"IF(B20>'User input'!F$26,\"\",EXP('User input'!H$14*(D20-'User input'!F$18)+'User input'!I$14*((E20-'User input'!F$19)/100))*'User input'!F$22)","v":""},{"$f":"IF(B20>'User input'!F$26,\"\",IF(B20>0,F19*'User input'!F$32,0))","v":""},{"$f":"IF(B20>'User input'!F$26,\"\",IF(B20>0,F19-F20,0))","v":""},{"$f":"IF(B20>'User input'!F$26,\"\",IF(B20>7,0,IF(SUM(I$11:I19)<1,IF(B20='User input'!F$26,'User input'!L29/2,'User input'!L29),0)))","v":""},{"$f":"IF(B20>'User input'!F$26,\"\",IF(B20=0,MIN('User input'!F$21,'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$26,\"\",IF(B20=0,'User input'!F$21-J20,K19-J20))","v":""},{"$f":"IF(B20>'User input'!F$26,\"\",IF(B20>0,('User input'!F$21-'User input'!F$23)*'User input'!F$32,0))","v":""},{"$f":"IF(B20>'User input'!F$26,\"\",IF(B20='User input'!F$26,'User input'!F$21-'User input'!F$23,0))","v":""},{"$f":"IF(B20>'User input'!F$26,\"\",IF(B20=0,'User input'!F$23,IF(B20='User input'!F$26,-F20,0)))","v":""},{"$f":"IF(B20>'User input'!F$26,\"\",IF(B20>0,'User input'!F$30*F19,0))","v":""},{"$f":"IF(B20>'User input'!F$26,\"\",'User input'!J$14*'User input'!F$24*(E20/1000)^'User input'!K$14*'User input'!F$29)","v":""},{"$f":"IF(B20>'User input'!F$26,\"\",IF(B20>0,(P20-P19),0))","v":""},{"$f":"IF(B20>'User input'!F$26,\"\",Q20/'User input'!F$27)","v":""},{"$f":"IF(B20>'User input'!F$26,\"\",(J20+L20+O20+Q20)*('User input'!F$33+'User input'!F$34)-IF(B20='User input'!F$26,(F20-K20)*'User input'!F$33,0))","v":""},{"$f":"IF(B20>'User input'!F$26,\"\",L20+M20+N20+O20+Q20-S20)","v":""},{"$f":"IF(B20>'User input'!F$26,\"\",C20*T20)","v":""}]
[null,{"$f":"IF(B20>='User input'!F$26,\"\",B20+1)","v":""},{"$f":"IF(B21>'User input'!F$26,\"\",'User input'!F$37^B21)","v":""},{"$f":"IF(B21>'User input'!F$26,\"\",IF(B21=0,'User input'!F$18,D20+1))","v":""},{"$f":"IF(B21>'User input'!F$26,\"\",IF(B21=0,'User input'!F$19,E20+'User input'!F$27))","v":""},{"$f":"IF(B21>'User input'!F$26,\"\",EXP('User input'!H$14*(D21-'User input'!F$18)+'User input'!I$14*((E21-'User input'!F$19)/100))*'User input'!F$22)","v":""},{"$f":"IF(B21>'User input'!F$26,\"\",IF(B21>0,F20*'User input'!F$32,0))","v":""},{"$f":"IF(B21>'User input'!F$26,\"\",IF(B21>0,F20-F21,0))","v":""},{"$f":"IF(B21>'User input'!F$26,\"\",IF(B21>7,0,IF(SUM(I$11:I20)<1,IF(B21='User input'!F$26,'User input'!L30/2,'User input'!L30),0)))","v":""},{"$f":"IF(B21>'User input'!F$26,\"\",IF(B21=0,MIN('User input'!F$21,'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$26,\"\",IF(B21=0,'User input'!F$21-J21,K20-J21))","v":""},{"$f":"IF(B21>'User input'!F$26,\"\",IF(B21>0,('User input'!F$21-'User input'!F$23)*'User input'!F$32,0))","v":""},{"$f":"IF(B21>'User input'!F$26,\"\",IF(B21='User input'!F$26,'User input'!F$21-'User input'!F$23,0))","v":""},{"$f":"IF(B21>'User input'!F$26,\"\",IF(B21=0,'User input'!F$23,IF(B21='User input'!F$26,-F21,0)))","v":""},{"$f":"IF(B21>'User input'!F$26,\"\",IF(B21>0,'User input'!F$30*F20,0))","v":""},{"$f":"IF(B21>'User input'!F$26,\"\",'User input'!J$14*'User input'!F$24*(E21/1000)^'User input'!K$14*'User input'!F$29)","v":""},{"$f":"IF(B21>'User input'!F$26,\"\",IF(B21>0,(P21-P20),0))","v":""},{"$f":"IF(B21>'User input'!F$26,\"\",Q21/'User input'!F$27)","v":""},{"$f":"IF(B21>'User input'!F$26,\"\",(J21+L21+O21+Q21)*('User input'!F$33+'User input'!F$34)-IF(B21='User input'!F$26,(F21-K21)*'User input'!F$33,0))","v":""},{"$f":"IF(B21>'User input'!F$26,\"\",L21+M21+N21+O21+Q21-S21)","v":""},{"$f":"IF(B21>'User input'!F$26,\"\",C21*T21)","v":""}]
[null,{"$f":"IF(B21>='User input'!F$26,\"\",B21+1)","v":""},{"$f":"IF(B22>'User input'!F$26,\"\",'User input'!F$37^B22)","v":""},{"$f":"IF(B22>'User input'!F$26,\"\",IF(B22=0,'User input'!F$18,D21+1))","v":""},{"$f":"IF(B22>'User input'!F$26,\"\",IF(B22=0,'User input'!F$19,E21+'User input'!F$27))","v":""},{"$f":"IF(B22>'User input'!F$26,\"\",EXP('User input'!H$14*(D22-'User input'!F$18)+'User input'!I$14*((E22-'User input'!F$19)/100))*'User input'!F$22)","v":""},{"$f":"IF(B22>'User input'!F$26,\"\",IF(B22>0,F21*'User input'!F$32,0))","v":""},{"$f":"IF(B22>'User input'!F$26,\"\",IF(B22>0,F21-F22,0))","v":""},{"$f":"IF(B22>'User input'!F$26,\"\",IF(B22>7,0,IF(SUM(I$11:I21)<1,IF(B22='User input'!F$26,'User input'!L31/2,'User input'!L31),0)))","v":""},{"$f":"IF(B22>'User input'!F$26,\"\",IF(B22=0,MIN('User input'!F$21,'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$26,\"\",IF(B22=0,'User input'!F$21-J22,K21-J22))","v":""},{"$f":"IF(B22>'User input'!F$26,\"\",IF(B22>0,('User input'!F$21-'User input'!F$23)*'User input'!F$32,0))","v":""},{"$f":"IF(B22>'User input'!F$26,\"\",IF(B22='User input'!F$26,'User input'!F$21-'User input'!F$23,0))","v":""},{"$f":"IF(B22>'User input'!F$26,\"\",IF(B22=0,'User input'!F$23,IF(B22='User input'!F$26,-F22,0)))","v":""},{"$f":"IF(B22>'User input'!F$26,\"\",IF(B22>0,'User input'!F$30*F21,0))","v":""},{"$f":"IF(B22>'User input'!F$26,\"\",'User input'!J$14*'User input'!F$24*(E22/1000)^'User input'!K$14*'User input'!F$29)","v":""},{"$f":"IF(B22>'User input'!F$26,\"\",IF(B22>0,(P22-P21),0))","v":""},{"$f":"IF(B22>'User input'!F$26,\"\",Q22/'User input'!F$27)","v":""},{"$f":"IF(B22>'User input'!F$26,\"\",(J22+L22+O22+Q22)*('User input'!F$33+'User input'!F$34)-IF(B22='User input'!F$26,(F22-K22)*'User input'!F$33,0))","v":""},{"$f":"IF(B22>'User input'!F$26,\"\",L22+M22+N22+O22+Q22-S22)","v":""},{"$f":"IF(B22>'User input'!F$26,\"\",C22*T22)","v":""}]
[null,{"$f":"IF(B22>='User input'!F$26,\"\",B22+1)","v":""},{"$f":"IF(B23>'User input'!F$26,\"\",'User input'!F$37^B23)","v":""},{"$f":"IF(B23>'User input'!F$26,\"\",IF(B23=0,'User input'!F$18,D22+1))","v":""},{"$f":"IF(B23>'User input'!F$26,\"\",IF(B23=0,'User input'!F$19,E22+'User input'!F$27))","v":""},{"$f":"IF(B23>'User input'!F$26,\"\",EXP('User input'!H$14*(D23-'User input'!F$18)+'User input'!I$14*((E23-'User input'!F$19)/100))*'User input'!F$22)","v":""},{"$f":"IF(B23>'User input'!F$26,\"\",IF(B23>0,F22*'User input'!F$32,0))","v":""},{"$f":"IF(B23>'User input'!F$26,\"\",IF(B23>0,F22-F23,0))","v":""},{"$f":"IF(B23>'User input'!F$26,\"\",IF(B23>7,0,IF(SUM(I$11:I22)<1,IF(B23='User input'!F$26,'User input'!L32/2,'User input'!L32),0)))","v":""},{"$f":"IF(B23>'User input'!F$26,\"\",IF(B23=0,MIN('User input'!F$21,'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$26,\"\",IF(B23=0,'User input'!F$21-J23,K22-J23))","v":""},{"$f":"IF(B23>'User input'!F$26,\"\",IF(B23>0,('User input'!F$21-'User input'!F$23)*'User input'!F$32,0))","v":""},{"$f":"IF(B23>'User input'!F$26,\"\",IF(B23='User input'!F$26,'User input'!F$21-'User input'!F$23,0))","v":""},{"$f":"IF(B23>'User input'!F$26,\"\",IF(B23=0,'User input'!F$23,IF(B23='User input'!F$26,-F23,0)))","v":""},{"$f":"IF(B23>'User input'!F$26,\"\",IF(B23>0,'User input'!F$30*F22,0))","v":""},{"$f":"IF(B23>'User input'!F$26,\"\",'User input'!J$14*'User input'!F$24*(E23/1000)^'User input'!K$14*'User input'!F$29)","v":""},{"$f":"IF(B23>'User input'!F$26,\"\",IF(B23>0,(P23-P22),0))","v":""},{"$f":"IF(B23>'User input'!F$26,\"\",Q23/'User input'!F$27)","v":""},{"$f":"IF(B23>'User input'!F$26,\"\",(J23+L23+O23+Q23)*('User input'!F$33+'User input'!F$34)-IF(B23='User input'!F$26,(F23-K23)*'User input'!F$33,0))","v":""},{"$f":"IF(B23>'User input'!F$26,\"\",L23+M23+N23+O23+Q23-S23)","v":""},{"$f":"IF(B23>'User input'!F$26,\"\",C23*T23)","v":""}]
[null,{"$f":"IF(B23>='User input'!F$26,\"\",B23+1)","v":""},{"$f":"IF(B24>'User input'!F$26,\"\",'User input'!F$37^B24)","v":""},{"$f":"IF(B24>'User input'!F$26,\"\",IF(B24=0,'User input'!F$18,D23+1))","v":""},{"$f":"IF(B24>'User input'!F$26,\"\",IF(B24=0,'User input'!F$19,E23+'User input'!F$27))","v":""},{"$f":"IF(B24>'User input'!F$26,\"\",EXP('User input'!H$14*(D24-'User input'!F$18)+'User input'!I$14*((E24-'User input'!F$19)/100))*'User input'!F$22)","v":""},{"$f":"IF(B24>'User input'!F$26,\"\",IF(B24>0,F23*'User input'!F$32,0))","v":""},{"$f":"IF(B24>'User input'!F$26,\"\",IF(B24>0,F23-F24,0))","v":""},{"$f":"IF(B24>'User input'!F$26,\"\",IF(B24>7,0,IF(SUM(I$11:I23)<1,IF(B24='User input'!F$26,'User input'!L33/2,'User input'!L33),0)))","v":""},{"$f":"IF(B24>'User input'!F$26,\"\",IF(B24=0,MIN('User input'!F$21,'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$26,\"\",IF(B24=0,'User input'!F$21-J24,K23-J24))","v":""},{"$f":"IF(B24>'User input'!F$26,\"\",IF(B24>0,('User input'!F$21-'User input'!F$23)*'User input'!F$32,0))","v":""},{"$f":"IF(B24>'User input'!F$26,\"\",IF(B24='User input'!F$26,'User input'!F$21-'User input'!F$23,0))","v":""},{"$f":"IF(B24>'User input'!F$26,\"\",IF(B24=0,'User input'!F$23,IF(B24='User input'!F$26,-F24,0)))","v":""},{"$f":"IF(B24>'User input'!F$26,\"\",IF(B24>0,'User input'!F$30*F23,0))","v":""},{"$f":"IF(B24>'User input'!F$26,\"\",'User input'!J$14*'User input'!F$24*(E24/1000)^'User input'!K$14*'User input'!F$29)","v":""},{"$f":"IF(B24>'User input'!F$26,\"\",IF(B24>0,(P24-P23),0))","v":""},{"$f":"IF(B24>'User input'!F$26,\"\",Q24/'User input'!F$27)","v":""},{"$f":"IF(B24>'User input'!F$26,\"\",(J24+L24+O24+Q24)*('User input'!F$33+'User input'!F$34)-IF(B24='User input'!F$26,(F24-K24)*'User input'!F$33,0))","v":""},{"$f":"IF(B24>'User input'!F$26,\"\",L24+M24+N24+O24+Q24-S24)","v":""},{"$f":"IF(B24>'User input'!F$26,\"\",C24*T24)","v":""}]
[null,{"$f":"IF(B24>='User input'!F$26,\"\",B24+1)","v":""},{"$f":"IF(B25>'User input'!F$26,\"\",'User input'!F$37^B25)","v":""},{"$f":"IF(B25>'User input'!F$26,\"\",IF(B25=0,'User input'!F$18,D24+1))","v":""},{"$f":"IF(B25>'User input'!F$26,\"\",IF(B25=0,'User input'!F$19,E24+'User input'!F$27))","v":""},{"$f":"IF(B25>'User input'!F$26,\"\",EXP('User input'!H$14*(D25-'User input'!F$18)+'User input'!I$14*((E25-'User input'!F$19)/100))*'User input'!F$22)","v":""},{"$f":"IF(B25>'User input'!F$26,\"\",IF(B25>0,F24*'User input'!F$32,0))","v":""},{"$f":"IF(B25>'User input'!F$26,\"\",IF(B25>0,F24-F25,0))","v":""},{"$f":"IF(B25>'User input'!F$26,\"\",IF(B25>7,0,IF(SUM(I$11:I24)<1,IF(B25='User input'!F$26,'User input'!L34/2,'User input'!L34),0)))","v":""},{"$f":"IF(B25>'User input'!F$26,\"\",IF(B25=0,MIN('User input'!F$21,'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$26,\"\",IF(B25=0,'User input'!F$21-J25,K24-J25))","v":""},{"$f":"IF(B25>'User input'!F$26,\"\",IF(B25>0,('User input'!F$21-'User input'!F$23)*'User input'!F$32,0))","v":""},{"$f":"IF(B25>'User input'!F$26,\"\",IF(B25='User input'!F$26,'User input'!F$21-'User input'!F$23,0))","v":""},{"$f":"IF(B25>'User input'!F$26,\"\",IF(B25=0,'User input'!F$23,IF(B25='User input'!F$26,-F25,0)))","v":""},{"$f":"IF(B25>'User input'!F$26,\"\",IF(B25>0,'User input'!F$30*F24,0))","v":""},{"$f":"IF(B25>'User input'!F$26,\"\",'User input'!J$14*'User input'!F$24*(E25/1000)^'User input'!K$14*'User input'!F$29)","v":""},{"$f":"IF(B25>'User input'!F$26,\"\",IF(B25>0,(P25-P24),0))","v":""},{"$f":"IF(B25>'User input'!F$26,\"\",Q25/'User input'!F$27)","v":""},{"$f":"IF(B25>'User input'!F$26,\"\",(J25+L25+O25+Q25)*('User input'!F$33+'User input'!F$34)-IF(B25='User input'!F$26,(F25-K25)*'User input'!F$33,0))","v":""},{"$f":"IF(B25>'User input'!F$26,\"\",L25+M25+N25+O25+Q25-S25)","v":""},{"$f":"IF(B25>'User input'!F$26,\"\",C25*T25)","v":""}]
[null,{"$f":"IF(B25>='User input'!F$26,\"\",B25+1)","v":""},{"$f":"IF(B26>'User input'!F$26,\"\",'User input'!F$37^B26)","v":""},{"$f":"IF(B26>'User input'!F$26,\"\",IF(B26=0,'User input'!F$18,D25+1))","v":""},{"$f":"IF(B26>'User input'!F$26,\"\",IF(B26=0,'User input'!F$19,E25+'User input'!F$27))","v":""},{"$f":"IF(B26>'User input'!F$26,\"\",EXP('User input'!H$14*(D26-'User input'!F$18)+'User input'!I$14*((E26-'User input'!F$19)/100))*'User input'!F$22)","v":""},{"$f":"IF(B26>'User input'!F$26,\"\",IF(B26>0,F25*'User input'!F$32,0))","v":""},{"$f":"IF(B26>'User input'!F$26,\"\",IF(B26>0,F25-F26,0))","v":""},{"$f":"IF(B26>'User input'!F$26,\"\",IF(B26>7,0,IF(SUM(I$11:I25)<1,IF(B26='User input'!F$26,'User input'!L35/2,'User input'!L35),0)))","v":""},{"$f":"IF(B26>'User input'!F$26,\"\",IF(B26=0,MIN('User input'!F$21,'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$26,\"\",IF(B26=0,'User input'!F$21-J26,K25-J26))","v":""},{"$f":"IF(B26>'User input'!F$26,\"\",IF(B26>0,('User input'!F$21-'User input'!F$23)*'User input'!F$32,0))","v":""},{"$f":"IF(B26>'User input'!F$26,\"\",IF(B26='User input'!F$26,'User input'!F$21-'User input'!F$23,0))","v":""},{"$f":"IF(B26>'User input'!F$26,\"\",IF(B26=0,'User input'!F$23,IF(B26='User input'!F$26,-F26,0)))","v":""},{"$f":"IF(B26>'User input'!F$26,\"\",IF(B26>0,'User input'!F$30*F25,0))","v":""},{"$f":"IF(B26>'User input'!F$26,\"\",'User input'!J$14*'User input'!F$24*(E26/1000)^'User input'!K$14*'User input'!F$29)","v":""},{"$f":"IF(B26>'User input'!F$26,\"\",IF(B26>0,(P26-P25),0))","v":""},{"$f":"IF(B26>'User input'!F$26,\"\",Q26/'User input'!F$27)","v":""},{"$f":"IF(B26>'User input'!F$26,\"\",(J26+L26+O26+Q26)*('User input'!F$33+'User input'!F$34)-IF(B26='User input'!F$26,(F26-K26)*'User input'!F$33,0))","v":""},{"$f":"IF(B26>'User input'!F$26,\"\",L26+M26+N26+O26+Q26-S26)","v":""},{"$f":"IF(B26>'User input'!F$26,\"\",C26*T26)","v":""}]
[null,{"$f":"IF(B26>='User input'!F$26,\"\",B26+1)","v":""},{"$f":"IF(B27>'User input'!F$26,\"\",'User input'!F$37^B27)","v":""},{"$f":"IF(B27>'User input'!F$26,\"\",IF(B27=0,'User input'!F$18,D26+1))","v":""},{"$f":"IF(B27>'User input'!F$26,\"\",IF(B27=0,'User input'!F$19,E26+'User input'!F$27))","v":""},{"$f":"IF(B27>'User input'!F$26,\"\",EXP('User input'!H$14*(D27-'User input'!F$18)+'User input'!I$14*((E27-'User input'!F$19)/100))*'User input'!F$22)","v":""},{"$f":"IF(B27>'User input'!F$26,\"\",IF(B27>0,F26*'User input'!F$32,0))","v":""},{"$f":"IF(B27>'User input'!F$26,\"\",IF(B27>0,F26-F27,0))","v":""},{"$f":"IF(B27>'User input'!F$26,\"\",IF(B27>7,0,IF(SUM(I$11:I26)<1,IF(B27='User input'!F$26,'User input'!L36/2,'User input'!L36),0)))","v":""},{"$f":"IF(B27>'User input'!F$26,\"\",IF(B27=0,MIN('User input'!F$21,'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$26,\"\",IF(B27=0,'User input'!F$21-J27,K26-J27))","v":""},{"$f":"IF(B27>'User input'!F$26,\"\",IF(B27>0,('User input'!F$21-'User input'!F$23)*'User input'!F$32,0))","v":""},{"$f":"IF(B27>'User input'!F$26,\"\",IF(B27='User input'!F$26,'User input'!F$21-'User input'!F$23,0))","v":""},{"$f":"IF(B27>'User input'!F$26,\"\",IF(B27=0,'User input'!F$23,IF(B27='User input'!F$26,-F27,0)))","v":""},{"$f":"IF(B27>'User input'!F$26,\"\",IF(B27>0,'User input'!F$30*F26,0))","v":""},{"$f":"IF(B27>'User input'!F$26,\"\",'User input'!J$14*'User input'!F$24*(E27/1000)^'User input'!K$14*'User input'!F$29)","v":""},{"$f":"IF(B27>'User input'!F$26,\"\",IF(B27>0,(P27-P26),0))","v":""},{"$f":"IF(B27>'User input'!F$26,\"\",Q27/'User input'!F$27)","v":""},{"$f":"IF(B27>'User input'!F$26,\"\",(J27+L27+O27+Q27)*('User input'!F$33+'User input'!F$34)-IF(B27='User input'!F$26,(F27-K27)*'User input'!F$33,0))","v":""},{"$f":"IF(B27>'User input'!F$26,\"\",L27+M27+N27+O27+Q27-S27)","v":""},{"$f":"IF(B27>'User input'!F$26,\"\",C27*T27)","v":""}]
[null,{"$f":"IF(B27>='User input'!F$26,\"\",B27+1)","v":""},{"$f":"IF(B28>'User input'!F$26,\"\",'User input'!F$37^B28)","v":""},{"$f":"IF(B28>'User input'!F$26,\"\",IF(B28=0,'User input'!F$18,D27+1))","v":""},{"$f":"IF(B28>'User input'!F$26,\"\",IF(B28=0,'User input'!F$19,E27+'User input'!F$27))","v":""},{"$f":"IF(B28>'User input'!F$26,\"\",EXP('User input'!H$14*(D28-'User input'!F$18)+'User input'!I$14*((E28-'User input'!F$19)/100))*'User input'!F$22)","v":""},{"$f":"IF(B28>'User input'!F$26,\"\",IF(B28>0,F27*'User input'!F$32,0))","v":""},{"$f":"IF(B28>'User input'!F$26,\"\",IF(B28>0,F27-F28,0))","v":""},{"$f":"IF(B28>'User input'!F$26,\"\",IF(B28>7,0,IF(SUM(I$11:I27)<1,IF(B28='User input'!F$26,'User input'!L37/2,'User input'!L37),0)))","v":""},{"$f":"IF(B28>'User input'!F$26,\"\",IF(B28=0,MIN('User input'!F$21,'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$26,\"\",IF(B28=0,'User input'!F$21-J28,K27-J28))","v":""},{"$f":"IF(B28>'User input'!F$26,\"\",IF(B28>0,('User input'!F$21-'User input'!F$23)*'User input'!F$32,0))","v":""},{"$f":"IF(B28>'User input'!F$26,\"\",IF(B28='User input'!F$26,'User input'!F$21-'User input'!F$23,0))","v":""},{"$f":"IF(B28>'User input'!F$26,\"\",IF(B28=0,'User input'!F$23,IF(B28='User input'!F$26,-F28,0)))","v":""},{"$f":"IF(B28>'User input'!F$26,\"\",IF(B28>0,'User input'!F$30*F27,0))","v":""},{"$f":"IF(B28>'User input'!F$26,\"\",'User input'!J$14*'User input'!F$24*(E28/1000)^'User input'!K$14*'User input'!F$29)","v":""},{"$f":"IF(B28>'User input'!F$26,\"\",IF(B28>0,(P28-P27),0))","v":""},{"$f":"IF(B28>'User input'!F$26,\"\",Q28/'User input'!F$27)","v":""},{"$f":"IF(B28>'User input'!F$26,\"\",(J28+L28+O28+Q28)*('User input'!F$33+'User input'!F$34)-IF(B28='User input'!F$26,(F28-K28)*'User input'!F$33,0))","v":""},{"$f":"IF(B28>'User input'!F$26,\"\",L28+M28+N28+O28+Q28-S28)","v":""},{"$f":"IF(B28>'User input'!F$26,\"\",C28*T28)","v":""}]
[null,{"$f":"IF(B28>='User input'!F$26,\"\",B28+1)","v":""},{"$f":"IF(B29>'User input'!F$26,\"\",'User input'!F$37^B29)","v":""},{"$f":"IF(B29>'User input'!F$26,\"\",IF(B29=0,'User input'!F$18,D28+1))","v":""},{"$f":"IF(B29>'User input'!F$26,\"\",IF(B29=0,'User input'!F$19,E28+'User input'!F$27))","v":""},{"$f":"IF(B29>'User input'!F$26,\"\",EXP('User input'!H$14*(D29-'User input'!F$18)+'User input'!I$14*((E29-'User input'!F$19)/100))*'User input'!F$22)","v":""},{"$f":"IF(B29>'User input'!F$26,\"\",IF(B29>0,F28*'User input'!F$32,0))","v":""},{"$f":"IF(B29>'User input'!F$26,\"\",IF(B29>0,F28-F29,0))","v":""},{"$f":"IF(B29>'User input'!F$26,\"\",IF(B29>7,0,IF(SUM(I$11:I28)<1,IF(B29='User input'!F$26,'User input'!L38/2,'User input'!L38),0)))","v":""},{"$f":"IF(B29>'User input'!F$26,\"\",IF(B29=0,MIN('User input'!F$21,'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$26,\"\",IF(B29=0,'User input'!F$21-J29,K28-J29))","v":""},{"$f":"IF(B29>'User input'!F$26,\"\",IF(B29>0,('User input'!F$21-'User input'!F$23)*'User input'!F$32,0))","v":""},{"$f":"IF(B29>'User input'!F$26,\"\",IF(B29='User input'!F$26,'User input'!F$21-'User input'!F$23,0))","v":""},{"$f":"IF(B29>'User input'!F$26,\"\",IF(B29=0,'User input'!F$23,IF(B29='User input'!F$26,-F29,0)))","v":""},{"$f":"IF(B29>'User input'!F$26,\"\",IF(B29>0,'User input'!F$30*F28,0))","v":""},{"$f":"IF(B29>'User input'!F$26,\"\",'User input'!J$14*'User input'!F$24*(E29/1000)^'User input'!K$14*'User input'!F$29)","v":""},{"$f":"IF(B29>'User input'!F$26,\"\",IF(B29>0,(P29-P28),0))","v":""},{"$f":"IF(B29>'User input'!F$26,\"\",Q29/'User input'!F$27)","v":""},{"$f":"IF(B29>'User input'!F$26,\"\",(J29+L29+O29+Q29)*('User input'!F$33+'User input'!F$34)-IF(B29='User input'!F$26,(F29-K29)*'User input'!F$33,0))","v":""},{"$f":"IF(B29>'User input'!F$26,\"\",L29+M29+N29+O29+Q29-S29)","v":""},{"$f":"IF(B29>'User input'!F$26,\"\",C29*T29)","v":""}]
[null,{"$f":"IF(B29>='User input'!F$26,\"\",B29+1)","v":""},{"$f":"IF(B30>'User input'!F$26,\"\",'User input'!F$37^B30)","v":""},{"$f":"IF(B30>'User input'!F$26,\"\",IF(B30=0,'User input'!F$18,D29+1))","v":""},{"$f":"IF(B30>'User input'!F$26,\"\",IF(B30=0,'User input'!F$19,E29+'User input'!F$27))","v":""},{"$f":"IF(B30>'User input'!F$26,\"\",EXP('User input'!H$14*(D30-'User input'!F$18)+'User input'!I$14*((E30-'User input'!F$19)/100))*'User input'!F$22)","v":""},{"$f":"IF(B30>'User input'!F$26,\"\",IF(B30>0,F29*'User input'!F$32,0))","v":""},{"$f":"IF(B30>'User input'!F$26,\"\",IF(B30>0,F29-F30,0))","v":""},{"$f":"IF(B30>'User input'!F$26,\"\",IF(B30>7,0,IF(SUM(I$11:I29)<1,IF(B30='User input'!F$26,'User input'!L39/2,'User input'!L39),0)))","v":""},{"$f":"IF(B30>'User input'!F$26,\"\",IF(B30=0,MIN('User input'!F$21,'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$26,\"\",IF(B30=0,'User input'!F$21-J30,K29-J30))","v":""},{"$f":"IF(B30>'User input'!F$26,\"\",IF(B30>0,('User input'!F$21-'User input'!F$23)*'User input'!F$32,0))","v":""},{"$f":"IF(B30>'User input'!F$26,\"\",IF(B30='User input'!F$26,'User input'!F$21-'User input'!F$23,0))","v":""},{"$f":"IF(B30>'User input'!F$26,\"\",IF(B30=0,'User input'!F$23,IF(B30='User input'!F$26,-F30,0)))","v":""},{"$f":"IF(B30>'User input'!F$26,\"\",IF(B30>0,'User input'!F$30*F29,0))","v":""},{"$f":"IF(B30>'User input'!F$26,\"\",'User input'!J$14*'User input'!F$24*(E30/1000)^'User input'!K$14*'User input'!F$29)","v":""},{"$f":"IF(B30>'User input'!F$26,\"\",IF(B30>0,(P30-P29),0))","v":""},{"$f":"IF(B30>'User input'!F$26,\"\",Q30/'User input'!F$27)","v":""},{"$f":"IF(B30>'User input'!F$26,\"\",(J30+L30+O30+Q30)*('User input'!F$33+'User input'!F$34)-IF(B30='User input'!F$26,(F30-K30)*'User input'!F$33,0))","v":""},{"$f":"IF(B30>'User input'!F$26,\"\",L30+M30+N30+O30+Q30-S30)","v":""},{"$f":"IF(B30>'User input'!F$26,\"\",C30*T30)","v":""}]
[null,{"$f":"IF(B30>='User input'!F$26,\"\",B30+1)","v":""},{"$f":"IF(B31>'User input'!F$26,\"\",'User input'!F$37^B31)","v":""},{"$f":"IF(B31>'User input'!F$26,\"\",IF(B31=0,'User input'!F$18,D30+1))","v":""},{"$f":"IF(B31>'User input'!F$26,\"\",IF(B31=0,'User input'!F$19,E30+'User input'!F$27))","v":""},{"$f":"IF(B31>'User input'!F$26,\"\",EXP('User input'!H$14*(D31-'User input'!F$18)+'User input'!I$14*((E31-'User input'!F$19)/100))*'User input'!F$22)","v":""},{"$f":"IF(B31>'User input'!F$26,\"\",IF(B31>0,F30*'User input'!F$32,0))","v":""},{"$f":"IF(B31>'User input'!F$26,\"\",IF(B31>0,F30-F31,0))","v":""},{"$f":"IF(B31>'User input'!F$26,\"\",IF(B31>7,0,IF(SUM(I$11:I30)<1,IF(B31='User input'!F$26,'User input'!L40/2,'User input'!L40),0)))","v":""},{"$f":"IF(B31>'User input'!F$26,\"\",IF(B31=0,MIN('User input'!F$21,'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$26,\"\",IF(B31=0,'User input'!F$21-J31,K30-J31))","v":""},{"$f":"IF(B31>'User input'!F$26,\"\",IF(B31>0,('User input'!F$21-'User input'!F$23)*'User input'!F$32,0))","v":""},{"$f":"IF(B31>'User input'!F$26,\"\",IF(B31='User input'!F$26,'User input'!F$21-'User input'!F$23,0))","v":""},{"$f":"IF(B31>'User input'!F$26,\"\",IF(B31=0,'User input'!F$23,IF(B31='User input'!F$26,-F31,0)))","v":""},{"$f":"IF(B31>'User input'!F$26,\"\",IF(B31>0,'User input'!F$30*F30,0))","v":""},{"$f":"IF(B31>'User input'!F$26,\"\",'User input'!J$14*'User input'!F$24*(E31/1000)^'User input'!K$14*'User input'!F$29)","v":""},{"$f":"IF(B31>'User input'!F$26,\"\",IF(B31>0,(P31-P30),0))","v":""},{"$f":"IF(B31>'User input'!F$26,\"\",Q31/'User input'!F$27)","v":""},{"$f":"IF(B31>'User input'!F$26,\"\",(J31+L31+O31+Q31)*('User input'!F$33+'User input'!F$34)-IF(B31='User input'!F$26,(F31-K31)*'User input'!F$33,0))","v":""},{"$f":"IF(B31>'User input'!F$26,\"\",L31+M31+N31+O31+Q31-S31)","v":""},{"$f":"IF(B31>'User input'!F$26,\"\",C31*T31)","v":""}]
[null,{"$f":"IF(B31>='User input'!F$26,\"\",B31+1)","v":""},{"$f":"IF(B32>'User input'!F$26,\"\",'User input'!F$37^B32)","v":""},{"$f":"IF(B32>'User input'!F$26,\"\",IF(B32=0,'User input'!F$18,D31+1))","v":""},{"$f":"IF(B32>'User input'!F$26,\"\",IF(B32=0,'User input'!F$19,E31+'User input'!F$27))","v":""},{"$f":"IF(B32>'User input'!F$26,\"\",EXP('User input'!H$14*(D32-'User input'!F$18)+'User input'!I$14*((E32-'User input'!F$19)/100))*'User input'!F$22)","v":""},{"$f":"IF(B32>'User input'!F$26,\"\",IF(B32>0,F31*'User input'!F$32,0))","v":""},{"$f":"IF(B32>'User input'!F$26,\"\",IF(B32>0,F31-F32,0))","v":""},{"$f":"IF(B32>'User input'!F$26,\"\",IF(B32>7,0,IF(SUM(I$11:I31)<1,IF(B32='User input'!F$26,'User input'!L41/2,'User input'!L41),0)))","v":""},{"$f":"IF(B32>'User input'!F$26,\"\",IF(B32=0,MIN('User input'!F$21,'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$26,\"\",IF(B32=0,'User input'!F$21-J32,K31-J32))","v":""},{"$f":"IF(B32>'User input'!F$26,\"\",IF(B32>0,('User input'!F$21-'User input'!F$23)*'User input'!F$32,0))","v":""},{"$f":"IF(B32>'User input'!F$26,\"\",IF(B32='User input'!F$26,'User input'!F$21-'User input'!F$23,0))","v":""},{"$f":"IF(B32>'User input'!F$26,\"\",IF(B32=0,'User input'!F$23,IF(B32='User input'!F$26,-F32,0)))","v":""},{"$f":"IF(B32>'User input'!F$26,\"\",IF(B32>0,'User input'!F$30*F31,0))","v":""},{"$f":"IF(B32>'User input'!F$26,\"\",'User input'!J$14*'User input'!F$24*(E32/1000)^'User input'!K$14*'User input'!F$29)","v":""},{"$f":"IF(B32>'User input'!F$26,\"\",IF(B32>0,(P32-P31),0))","v":""},{"$f":"IF(B32>'User input'!F$26,\"\",Q32/'User input'!F$27)","v":""},{"$f":"IF(B32>'User input'!F$26,\"\",(J32+L32+O32+Q32)*('User input'!F$33+'User input'!F$34)-IF(B32='User input'!F$26,(F32-K32)*'User input'!F$33,0))","v":""},{"$f":"IF(B32>'User input'!F$26,\"\",L32+M32+N32+O32+Q32-S32)","v":""},{"$f":"IF(B32>'User input'!F$26,\"\",C32*T32)","v":""}]
[]
[]
[null,"* EOY = End of year",null,null,null,null,null,null,{"$f":"IF(OR('User input'!L29>1.01,'User input'!L29<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'!L29>1.01,'User input'!L29<0.99),\"Go back to User Input tab and check entered values!\",\" \")","v":" "}]

{"sheet":"Analysis summary","index":3,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Tractor analysis summary section"]
[]
[null,"Analysis highlights:"]
[null,"Tractor class used",null,null,{"$f":"VLOOKUP('User input'!F17,'User input'!C7:K12,2)","v":"Case-IH 2wd and MFWD"}]
[]
[null,"Tractor purchase price",null,null,{"$f":"'User input'!F21","v":160000}]
[null,"Tractor age when purchased",null,null,{"$f":"'User input'!F18","v":0}]
[null,"Hours on tractor when purchased",null,null,{"$f":"'User input'!F19","v":0}]
[null,"Hours used per year",null,null,{"$f":"'User input'!F27","v":600}]
[null,"Number of years tractor is used",null,null,{"$f":"'User input'!F26","v":4}]
[null,"Tractor value when sold",null,null,{"$f":"-MIN('Time and Tax (TT)'!N12:N32)","v":116062.75177546169}]
[null,"Accumulated repairs over lifetime",null,null,{"$f":"MAX('Time and Tax (TT)'!P12:P32)","v":4608}]
[]
[]
[null,"Cost breakdown (total cost can be compared to tractor rental rates):"]
[]
[null,null,null,null,"$/year","$/hour"]
[null,"Opportunity interest",null,null,{"$f":"'User input'!L34","v":4791.244756442361},{"$f":"E19/E$10","v":7.9854079274039353}]
[null,"Market depreciation",null,null,{"$f":"'User input'!L35","v":7390.4260668568768},{"$f":"E20/E$10","v":12.317376778094795}]
[null,"Repair and maintenance",null,null,{"$f":"'User input'!L36","v":757.25099580378173},{"$f":"E21/E$10","v":1.2620849930063029}]
[null,"Tax, insurance, & shelter (TIS)",null,null,{"$f":"'User input'!L37","v":1437.3734269327085},{"$f":"E22/E$10","v":2.395622378221181}]
[]
[null,"Total for tractor",null,null,{"$f":"SUM(E19:E22)","v":14376.295246035728},{"$f":"SUM(F19:F22)","v":23.960492076726215}]
[]
[]
[null,"Date of analysis =====>",null,{"$f":"NOW()","v":"2016-06-29T11:25:27.700"}]