{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduction","User input","Time and Tax (TT)","Analysis summary","Baler Models"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":1,"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":128,"n_cols":12,"rows_kept":128,"cut":false,"hidden":false,"merged":[[39,1,40,4],[39,6,40,10],[44,1,44,3],[50,1,50,11],[1,1,2,6],[29,1,32,11],[25,1,25,4],[26,1,28,11],[36,1,36,9],[37,1,38,8],[4,1,5,8],[7,2,7,3],[7,4,7,5]]}
[]
[null,"KSU-Own Baler"]
[]
[]
[null,"An Excel spreadsheet to evaluate the economic costs of owning and operating a large square or large round hay baler."]
[]
[]
[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 Baler Ownership with the Own Baler 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"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Red numbers are our inputs (don't want users changing any of this stuff)"]
[]
[null,"Coefficients from lotus working spreadsheet (Balers2006.123)"]
[null,null,"size","age","usage","constant","lb/cu-ft","RF1","RF2","useful life",null,"date"]
[null,"round",5.5190586961876495E-3,-5.7636583260407437E-2,-1E-3,9.5325537622679537,12.025040144720981,0.55000000000000004,1.8,1500,null,"2011-07-12"]
[null,"square",4.7694346583588704E-3,-7.7698505043562113E-2,-2.5000000000000001E-4,11.036526575980044,14.673311184939092,0.25,1.8,3000,null,"2011-07-12"]
[]
[]
[null,"Information below is from Balers2006.123 spreadsheet"]
[null,null,"Information assumed for calculating hours from bale counts for purchased balers"]
[]
[null,"Round Balers:",null,null,null,null,null,"Square Balers:"]
[null,"avg mph when baling",null,null,null,7,null,"avg mph when baling",null,null,null,6.3]
[null,"avg crop width baled in feet",null,null,null,28,null,"avg crop width baled in feet",null,null,null,29]
[null,"calculated acre/hr when moving",null,null,null,{"$f":"F94*F95*5280/43560","v":23.757575757575758},null,"calculated acre/hr when moving",null,null,null,{"$f":"L94*L95*5280/43560","v":22.145454545454541}]
[null,"avg crop yield in T/acre/operation",null,null,null,1.3,null,"avg crop yield in T/acre/operation",null,null,null,1.2]
[null,"avg wt of Vermeer 5x6 round bale in lb",null,null,null,1700,null,"avg wt of 3x4 sq bale in lb",null,null,null,1325]
[null,"calculated bales per acre",null,null,null,{"$f":"F97*2000/F98","v":1.5294117647058822},null,"calculated bales per acre",null,null,null,{"$f":"L97*2000/L98","v":1.8113207547169812}]
[null,"calculated no-stopping bales/hr",null,null,null,{"$f":"F96*F99","v":36.33511586452763},null,"calculated bales per hour",null,null,null,{"$f":"L96*L99","v":40.112521440823322}]
[null,"minutes to make a bale",null,null,null,{"$f":"60/F100","v":1.6512951334379906},null,"calculated tons per hour",null,null,null,{"$f":"L98*L100/2000","v":26.574545454545451}]
[null,"total seconds stopped to wrap with twine",null,null,null,35]
[null,"total time in minutes per bale",null,null,null,{"$f":"F101+F102/60","v":2.2346284667713241}]
[null,"actual bales/hour",null,null,null,{"$f":"60/F103","v":26.850100986447323}]
[null,"actual acres/hour",null,null,null,{"$f":"F104/F99","v":17.555835260369406}]
[null,"calculated tons per hour",null,null,null,{"$f":"F98*F104/2000","v":22.822585838480222}]
[]
[]
[null,"Custom rate info to facilitate testing"]
[null,"2005 KAS custom rates are:",null,null,null,"per bale","guess at wt","$/ton"]
[null,"Round (under 1500) twine",null,null,null,8.1199999999999992,1000,{"$f":"F111/(G111/2000)","v":16.239999999999998}]
[null,"Round (over 1500) twine",null,null,null,8.24,1750,{"$f":"F112/(G112/2000)","v":9.4171428571428581}]
[null,"Round (under 1500) net wrap",null,null,null,9,1000,{"$f":"F113/(G113/2000)","v":18}]
[null,"Round (over 1500) net wrap",null,null,null,9.2100000000000009,1750,{"$f":"F114/(G114/2000)","v":10.525714285714287}]
[null,"Big square (about 1T)",null,null,null,12.8,2000,{"$f":"F115/(G115/2000)","v":12.8}]
[null,"Rental rates from Fall 2006 NAEDA",null,null,null,"per bale"]
[null,"Round (over 1600+)",null,null,null,5.75,1800,{"$f":"F117/(G117/2000)","v":6.3888888888888884}]
[null,"Round (1100-1500)",null,null,null,5.25,1250,{"$f":"F118/(G118/2000)","v":8.4}]
[null,"Round (<1000)",null,null,null,4.75,800,{"$f":"F119/(G119/2000)","v":11.875}]
[null,"Square (large)",null,null,null,7,1250,{"$f":"F120/(G120/2000)","v":11.2}]
[]
[null,"Bill Smith (Nov 04) said Vermeer 605M w/ net wrap would sell for $29,000"]
[null,"After he uses it for one year (5000 bales) it will sell for $25,000"]
[null,"My guess is that net wrap and related options are about $3,500"]
[]
[]
[]
[null,"NAEDA reported the same rental rates in 2006 as in 2005"]

{"sheet":"User input","index":1,"n_rows":75,"n_cols":13,"rows_kept":75,"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 baler depreciation and repairs"]
[null,null,null,null,null,null,null,null,"repair factors"]
[null,"Baler class",null,null,null,null,"age","usage","RF1","RF2","useful life"]
[null,1,"Large round baler",null,null,null,{"$f":"+Introduction!D86","v":-5.7636583260407437E-2},{"$f":"+Introduction!E86","v":-1E-3},{"$f":"Introduction!H86","v":0.55000000000000004},{"$f":"Introduction!I86","v":1.8},{"$f":"Introduction!J86","v":1500}]
[null,2,"Large square baler",null,null,null,{"$f":"+Introduction!D87","v":-7.7698505043562113E-2},{"$f":"+Introduction!E87","v":-2.5000000000000001E-4},{"$f":"Introduction!H87","v":0.25},{"$f":"Introduction!I87","v":1.8},{"$f":"Introduction!J87","v":3000}]
[null,"Factors used in analysis =>",null,null,null,{"$f":"IF($F12=1,C7,IF($F12=2,C8,\"NA\"))","v":"Large round baler"},{"$f":"IF($F12=1,G7,IF($F12=2,G8,\"NA\"))","v":-5.7636583260407437E-2},{"$f":"IF($F12=1,H7,IF($F12=2,H8,\"NA\"))","v":-1E-3},{"$f":"IF($F12=1,I7,IF($F12=2,I8,\"NA\"))","v":0.55000000000000004},{"$f":"IF($F12=1,J7,IF($F12=2,J8,\"NA\"))","v":1.8},{"$f":"IF($F12=1,K7,IF($F12=2,K8,\"NA\"))","v":1500}]
[]
[null,"Information on baler considered for purchase",null,null,null,null,null,"Tractor, labor, and fuel information"]
[null,"   Baler class:  big round = 1;  big square = 2",null,null,null,1,null,"   PTO horsepower of tractor used on baler",null,null,null,150]
[null,"   Round bale only:  percent of bales with net wrap",null,null,null,1,null,"   Tractor rental rate in dollars per hp per hour",null,null,null,0.2]
[null,"   Baler age in years",null,null,null,0,null,"   Tractor rental rate in dollars per hourmeter hour",null,null,null,{"$f":"L12*L13","v":30}]
[null,"   Accumulated number of bales on purchased baler",null,null,null,0,null,"   Tractor fuel consumption per hourmeter hour (gal.)",null,null,null,8]
[null,"   Bale width in inches",null,null,null,60,null,"   Average fuel price ($/gallon)",null,null,null,2.25]
[null,"   Bale height in inches (max. diameter if round bale)",null,null,null,72,null,"   Oil and lubrication percent of fuel cost",null,null,null,0.1]
[null,"   Maximum bale length in inches (square bale only)",null,null,null,96,null,"   Expected tractor-hours-to-baler-hours ratio",null,null,null,1.75]
[null,"   Estimated no. of hours on baler when purchase",null,null,null,{"$f":"F15/IF(F12=1,Introduction!F104,IF(F12=2,Introduction!L100,\"NA\"))","v":0},null,"   Expected tractor hours used in baling operation",null,null,null,{"$f":"F43*L18","v":295.57023164814717}]
[null,"   Purchase price of baler w/o trade-in",null,null,null,30000,null,"   Total labor hours per tractor hourmeter hour",null,null,null,2]
[null,"   Market price of baler",null,null,null,30000,null,"   Labor cost per labor hour",null,null,null,13]
[null,"   Cash downpayment",null,null,null,12000,null,"Financial information"]
[null,"   Estimated new equivalent price (NEP) of baler",null,null,null,{"$f":"F21/EXP(G9*F14+H9*F19)","v":30000},null,"   Bank interest rate (%)",null,null,null,0.05]
[null,"   No. of seasons (years) before trade (maximum 20)",null,null,null,3,null,"   Calculated after-tax discount rate",null,null,null,{"$f":"L23*(1-L25-L26)","v":3.2350000000000004E-2}]
[null,"Information on bales you intend to make",null,null,null,null,null,"   State + U.S. marginal income tax rate (%)",null,null,null,0.2]
[null,"   Bale capacity:  max. no. of cu. ft. in bale",null,null,null,{"$f":"IF(F12=2,F16/12*F17/12*F18/12,IF(F12=1,PI()*(F17/12/2)^2*F16/12,\"NA\"))","v":141.37166941154069},null,"   Self-employment tax (0 if corporation)",null,null,null,0.153]
[null,"   Expected bale density in lb per cu. ft.",null,null,null,{"$f":"IF(F12=1,Introduction!G86,IF(F12=2,Introduction!G87,\"NA\"))","v":12.025040144720981},null,"   Section-179 allowance limit (set by law)",null,null,null,500000]
[null,"   User-input bale density in lb per cu. ft.",null,null,null,{"$f":"F27","v":12.025040144720981},null,"   Section-179 deduction desired (you determine)",null,null,null,0]
[null,"   Diameter of round bale you will make in inches",null,null,null,72,null,"   Bonus depreciation allowed (%)",null,null,null,0.5]
[null,"   Length of square bale you will make in inches",null,null,null,96,null,"   Bonus 1st-yr dep. On new equip. (yes=1, no=0)",null,null,null,0]
[null,"   Cu. ft. of the bale you plan to make",null,null,null,{"$f":"IF(F12=2,F16/12*F17/12*F30/12,IF(F12=1,PI()*(F29/12/2)^2*F16/12,\"NA\"))","v":141.37166941154069},null,"   Calculated bonus yr-1 depreciation",null,null,null,{"$f":"IF(AND(F14=0,L30=1),(F20-MIN(F20,MIN(L27,L28)))*L29,0)","v":0}]
[null,"   Estimated weight of your bales in lb.",null,null,null,{"$f":"F31*F28","v":1700},null,"   Calculated net $ amount to depreciate",null,null,null,{"$f":"F20-MIN(F20,MIN(L27,L28))-L31","v":30000}]
[null,"Information on the scale of youroperation",null,null,null,null,null,"      1st year MACRS depreciation rate",null,null,null,0.1429]
[null,"   Average travel speed in mph when baling",null,null,null,6.5,null,"      2nd year MACRS depreciation rate",null,null,null,0.24490000000000001]
[null,"   Average swath width in feet when baling",null,null,null,29,null,"      3rd year MACRS depreciation rate",null,null,null,0.1749]
[null,"   Average crop yield in T/acre/operation",null,null,null,1.2,null,"      4th year MACRS depreciation rate",null,null,null,0.1249]
[null,"   Bales per acre per cutting",null,null,null,{"$f":"F36*2000/F32","v":1.411764705882353},null,"      5th year MACRS depreciation rate",null,null,null,8.9300000000000004E-2]
[null,"   Bales per hour",null,null,null,{"$f":"IF(F$12=1,F$13*L73+(1-F$13)*L65,IF(F$12=2,F68,\"NA\"))","v":29.603793153351717},null,"      6th year MACRS depreciation rate",null,null,null,8.9200000000000002E-2]
[null,"   Acres per hour",null,null,null,{"$f":"IF(F$12=1,F$13*L74+(1-F$13)*L66,IF(F$12=2,F69,\"NA\"))","v":20.969353483624133},null,"      7th year MACRS depreciation rate",null,null,null,8.9300000000000004E-2,{"$f":"IF(OR(L41>1.01,L41<0.99),\"<= Error!\",\" \")","v":" "}]
[null,"   Tons per hour",null,null,null,{"$f":"IF(F$12=1,F$13*L75+(1-F$13)*L67,IF(F$12=2,F70,\"NA\"))","v":25.163224180348958},null,"      8th year MACRS depreciation rate",null,null,null,4.4600000000000001E-2]
[null,"   Expected no. of bales made by baler annually",null,null,null,5000,null,"   Calculated error check of depreciation rates",null,null,null,{"$f":"SUM(L33:L40)","v":1.0000000000000002}]
[null,"   Implied acres baled per year",null,null,null,{"$f":"F41/F37","v":3541.6666666666665},null,{"$f":"IF(OR(L41>1.01,L41<0.99),\"Total depreciation rate should add to 100%!\",\" \")","v":" "}]
[null,"   Implied baler hours per year",null,null,null,{"$f":"F41/F38","v":168.89727522751267},null,"   Calculated after-tax NPVc from TT section",null,null,null,{"$f":"'Time and Tax (TT)'!U4","v":7737.3249746155079}]
[null,"Miscellaneous",null,null,null,null,null,"   Calculated after-tax amortized NPV from TT",null,null,null,{"$f":"F49*L43","v":2747.7472385912156}]
[null,"   Annual inflation % on machinery prices ",null,null,null,0.01,null,"   Calculated pre-tax amortized NPV from TT",null,null,null,{"$f":"L44/(1-L25-L26)","v":4246.9045418720489}]
[null,"   Trade ding (% of market value lost in a trade)",null,null,null,0.05,null,"      Prorated to opportunity interest",null,null,null,{"$f":"L45*'Time and Tax (TT)'!G7","v":1243.8269696294522}]
[null,"   Repair adjustment factor (0.8-1.2, usually 1) (RAF)",null,null,null,1,null,"      Prorated to market depreciation",null,null,null,{"$f":"L45*'Time and Tax (TT)'!H7","v":1198.4542910971716}]
[null,"   Tax, insurance, & shelter (TIS - % of value)",null,null,null,1.4999999999999999E-2,null,"      Prorated to repairs",null,null,null,{"$f":"L45*'Time and Tax (TT)'!Q7","v":1431.4751902565904}]
[null,"   Calculated after-tax amortization factor",null,null,null,{"$f":"L24/(1-(1+L24)^-F24)","v":0.35512883943817541},null,"      Prorated to tax, insurance, & shelter (TIS)",null,null,null,{"$f":"L45*'Time and Tax (TT)'!O7","v":373.14809088883567}]
[null,"   Calculated 1-year after-tax discount factor",null,null,null,{"$f":"1/(1+L24)","v":0.96866372838669046}]
[]
[]
[]
[null,"Twine and net wrap section"]
[]
[null,"Information about twine"]
[null,"   Cost of a 4,000 foot ball of square baler twine, $",null,null,null,26,null,"Section just below is for round bales using twine (twin tie)"]
[null,"   Cost of a 20,000 foot ball of round baler twine, $",null,null,null,23,null,"   Twine spacing in inches",null,null,null,5]
[null,"   Cost of a 7,000 foot roll of round baler net wrap, $",null,null,null,210,null,"   Number of inches from end of bale for first wrap",null,null,null,4]
[null,"   Cost of twine or net wrap per bale for selected baler",null,null,null,{"$f":"IF(F$12=1,F$13*F59+(1-F$13)*F58,IF(F$12=2,F57,\"NA\"))/IF(F$12=1,F$13*L70+(1-F$13)*L62,IF(F$12=2,F66,\"NA\"))","v":1.4702653618800232},null,"   Number of extra wraps at each end of the bale",null,null,null,4]
[null,null,null,null,null,null,null,"   Total number of wraps per bale",null,null,null,{"$f":"IF(F12=1,(F16-L59*2)/L58+1+L60*2,\"N/A\")","v":19.399999999999999}]
[null,"Section just below is for square bales only ",null,null,null,null,null,"   No. of bales per 20,000 ft. ball of twine",null,null,null,{"$f":"IF(F12=1,20000/(PI()*F29/12*L61),\"N/A\")","v":54.692420306493247}]
[null,"   Number of twines per bale",null,null,null,6,null,"   No. of seconds stopped to tie bale",null,null,null,{"$f":"IF(F12=1,F74/2*L61+F75,\"N/A\")","v":29.120098919846562}]
[null,"   Number of inches used for a knot",null,null,null,6,null,"   Minutes to make, tie, and eject a bale",null,null,null,{"$f":"IF(F12=1,60/(F34*F35*5280/43560*F37)+L63/60,\"N/A\")","v":2.3454145575942595}]
[null,"   Feet of twine used per bale",null,null,null,{"$f":"IF(F12=2,(F17*2+F30*2+F64)*F63/12,\"N/A\")","v":"N/A"},null,"   Bales per hour",null,null,null,{"$f":"IF(F12=1,60/L64,\"N/A\")","v":25.581831495726387}]
[null,"   No. of bales per 4,000 ft. ball of twine",null,null,null,{"$f":"IF(F12=2,4000/F65,\"N/A\")","v":"N/A"},null,"   Acres per hour",null,null,null,{"$f":"IF(F12=1,L65/F37,\"N/A\")","v":18.120463976139522}]
[null,"   Minutes to make a bale",null,null,null,{"$f":"IF(F12=2,60/F68,\"N/A\")","v":"N/A"},null,"   Tons per hour",null,null,null,{"$f":"IF(F12=1,F32*L65/2000,\"N/A\")","v":21.744556771367428}]
[null,"   Bales per hour",null,null,null,{"$f":"IF(F12=2,F69*F37,\"N/A\")","v":"N/A"},null,"Section just below is for round bales using net wrap"]
[null,"   Acres per hour",null,null,null,{"$f":"IF(F12=2,F34*F35*5280/43560,\"N/A\")","v":"N/A"},null,"   Number of wraps per bale",null,null,null,2.6]
[null,"   Tons per hour",null,null,null,{"$f":"IF(F12=2,F32*F68/2000,\"N/A\")","v":"N/A"},null,"   No. of bales per 7,000 ft. roll of net wrap",null,null,null,{"$f":"IF(F12=1,7000/(PI()*F29/12*L69),\"N/A\")","v":142.83135918503427}]
[null,null,null,null,null,null,null,"   Total no. of seconds stopped to wrap bale",null,null,null,{"$f":"IF(F12=1,F74*L69+F75,\"N/A\")","v":10.00126362800011}]
[null,"Section just below is for round bales only",null,null,null,null,null,"   Minutes to make, wrap, and eject a bale",null,null,null,{"$f":"IF(F12=1,60/(F34*F35*5280/43560*F37)+L71/60,\"N/A\")","v":2.026767302730152}]
[null,"   Baler belt speed in feet per minute",null,null,null,420,null,"   Bales per hour",null,null,null,{"$f":"IF(F12=1,60/L72,\"N/A\")","v":29.603793153351717}]
[null,"   Seconds per wrap for baler",null,null,null,{"$f":"IF(F12=1,PI()*F29/12*60/F73,\"N/A\")","v":2.6927937030769655},null,"   Acres per hour",null,null,null,{"$f":"IF(F12=1,L73/F37,\"N/A\")","v":20.969353483624133}]
[null,"   No. of seconds delay before wrapping begins",null,null,null,3,null,"   Tons per hour",null,null,null,{"$f":"IF(F12=1,F32*L73/2000,\"N/A\")","v":25.163224180348958}]

{"sheet":"Time and Tax (TT)","index":2,"n_rows":36,"n_cols":24,"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":7737.3249746155079}]
[]
[null,null,null,null,null,"after-tax NPV =>",{"$f":"SUMPRODUCT($C12:$C32,G12:G32)*(1-'User input'!$L25-'User input'!$L26)","v":2605.9961005561586},{"$f":"SUMPRODUCT($C12:$C32,H12:H32)*(1-'User input'!$L25-'User input'!$L26)","v":2510.9338240386005},null,null,null,null,null,"after-tax NPV =>",{"$f":"SUMPRODUCT($C12:$C32,O12:O32)*(1-'User input'!$L25-'User input'!$L26)","v":781.79883016684767},null,{"$f":"SUMPRODUCT($C12:$C32,Q12:Q32)*(1-'User input'!$L25-'User input'!$L26)","v":2999.1460668865275}]
[null,null,null,null,null,"% of total =>",{"$f":"G6/($G6+$H6+$O6+$Q6)","v":0.29287848534527439},{"$f":"H6/($G6+$H6+$O6+$Q6)","v":0.28219477958148059},null,null,null,null,null,"% of total =>",{"$f":"O6/($G6+$H6+$O6+$Q6)","v":8.7863545603582324E-2},null,{"$f":"Q6/($G6+$H6+$O6+$Q6)","v":0.3370631894696629}]
[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,{"$f":"SUM(Q12:Q32)/'User input'!F24","v":1666.732205737386},{"$f":"SUM(R12:R32)/'User input'!F24","v":9.8683190921358488}]
[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$24,\"\",'User input'!F$50^B12)","v":1},{"$f":"IF(B12>'User input'!F$24,\"\",IF(B12=0,'User input'!F$14,D11+1))","v":0},{"$f":"IF(B12>'User input'!F$24,\"\",IF(B12=0,'User input'!F$19,E11+'User input'!F$43))","v":0},{"$f":"IF(B12>'User input'!F$24,\"\",EXP('User input'!G$9*(D12-'User input'!F$14)+'User input'!H$9*((E12-'User input'!F$19)/100))*'User input'!F$21*(1+'User input'!F$45)^B12)","v":30000},{"$f":"IF(B12>'User input'!F$24,\"\",IF(B12>0,F11*'User input'!L$23,0))","v":0},{"$f":"IF(B12>'User input'!F$24,\"\",IF(B12>0,F11-F12,0))","v":0},{"$f":"IF(B12>'User input'!F$24,\"\",IF(B12>7,0,IF(SUM(I$11:I11)<1,IF(B12='User input'!F$24,'User input'!L33/2,'User input'!L33),0)))","v":0.1429},{"$f":"IF(B12>'User input'!F$24,\"\",IF(B12=0,MIN('User input'!F$20,'User input'!L$28)+'User input'!L$31+'User input'!L$32*I12,'User input'!L$32*I12))","v":4287},{"$f":"IF(B12>'User input'!F$24,\"\",IF(B12=0,'User input'!F$20-J12,K11-J12))","v":25713},{"$f":"IF(B12>'User input'!F$24,\"\",IF(B12>0,('User input'!F$20-'User input'!F$22)*'User input'!L$23,0))","v":0},{"$f":"IF(B12>'User input'!F$24,\"\",IF(B12='User input'!F$24,'User input'!F$20-'User input'!F$22,0))","v":0},{"$f":"IF(B12>'User input'!F$24,\"\",IF(B12=0,'User input'!F$22,IF(B12='User input'!F$24,-F12*(1-'User input'!F$46),0)))","v":12000},{"$f":"IF(B12>'User input'!F$24,\"\",IF(B12>0,'User input'!F$48*F11,0))","v":0},{"$f":"IF(B12>'User input'!F$24,\"\",(IF(E12>'User input'!K$9,(E12-'User input'!K$9)*('User input'!F$23*(1+'User input'!F$45)^B12*'User input'!J$9*'User input'!I$9*('User input'!K$9/1000)^('User input'!J$9-1))/1000+'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B12*('User input'!K$9/1000)^'User input'!J$9,'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B12*(E12/1000)^'User input'!J$9))*'User input'!F$47)","v":0},{"$f":"IF(B12>'User input'!F$24,\"\",IF(B12>0,(P12-P11),0))","v":0},{"$f":"IF(B12>'User input'!F$24,\"\",Q12/'User input'!F$43)","v":0},{"$f":"IF(B12>'User input'!F$24,\"\",(J12+L12+O12+Q12)*('User input'!L$25+'User input'!L$26)-IF(B12='User input'!F$24,(F12-K12)*'User input'!L$25,0))","v":1513.3109999999999},{"$f":"IF(B12>'User input'!F$24,\"\",L12+M12+N12+O12+Q12-S12)","v":10486.689},{"$f":"IF(B12>'User input'!F$24,\"\",C12*T12)","v":10486.689}]
[null,{"$f":"IF(B12>='User input'!F$24,\"\",B12+1)","v":1},{"$f":"IF(B13>'User input'!F$24,\"\",'User input'!F$50^B13)","v":0.96866372838669046},{"$f":"IF(B13>'User input'!F$24,\"\",IF(B13=0,'User input'!F$14,D12+1))","v":1},{"$f":"IF(B13>'User input'!F$24,\"\",IF(B13=0,'User input'!F$19,E12+'User input'!F$43))","v":168.89727522751267},{"$f":"IF(B13>'User input'!F$24,\"\",EXP('User input'!G$9*(D13-'User input'!F$14)+'User input'!H$9*((E13-'User input'!F$19)/100))*'User input'!F$21*(1+'User input'!F$45)^B13)","v":28554.717432135029},{"$f":"IF(B13>'User input'!F$24,\"\",IF(B13>0,F12*'User input'!L$23,0))","v":1500},{"$f":"IF(B13>'User input'!F$24,\"\",IF(B13>0,F12-F13,0))","v":1445.2825678649715},{"$f":"IF(B13>'User input'!F$24,\"\",IF(B13>7,0,IF(SUM(I$11:I12)<1,IF(B13='User input'!F$24,'User input'!L34/2,'User input'!L34),0)))","v":0.24490000000000001},{"$f":"IF(B13>'User input'!F$24,\"\",IF(B13=0,MIN('User input'!F$20,'User input'!L$28)+'User input'!L$31+'User input'!L$32*I13,'User input'!L$32*I13))","v":7347},{"$f":"IF(B13>'User input'!F$24,\"\",IF(B13=0,'User input'!F$20-J13,K12-J13))","v":18366},{"$f":"IF(B13>'User input'!F$24,\"\",IF(B13>0,('User input'!F$20-'User input'!F$22)*'User input'!L$23,0))","v":900},{"$f":"IF(B13>'User input'!F$24,\"\",IF(B13='User input'!F$24,'User input'!F$20-'User input'!F$22,0))","v":0},{"$f":"IF(B13>'User input'!F$24,\"\",IF(B13=0,'User input'!F$22,IF(B13='User input'!F$24,-F13*(1-'User input'!F$46),0)))","v":0},{"$f":"IF(B13>'User input'!F$24,\"\",IF(B13>0,'User input'!F$48*F12,0))","v":450},{"$f":"IF(B13>'User input'!F$24,\"\",(IF(E13>'User input'!K$9,(E13-'User input'!K$9)*('User input'!F$23*(1+'User input'!F$45)^B13*'User input'!J$9*'User input'!I$9*('User input'!K$9/1000)^('User input'!J$9-1))/1000+'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B13*('User input'!K$9/1000)^'User input'!J$9,'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B13*(E13/1000)^'User input'!J$9))*'User input'!F$47)","v":678.46285551765425},{"$f":"IF(B13>'User input'!F$24,\"\",IF(B13>0,(P13-P12),0))","v":678.46285551765425},{"$f":"IF(B13>'User input'!F$24,\"\",Q13/'User input'!F$43)","v":4.0170148073953973},{"$f":"IF(B13>'User input'!F$24,\"\",(J13+L13+O13+Q13)*('User input'!L$25+'User input'!L$26)-IF(B13='User input'!F$24,(F13-K13)*'User input'!L$25,0))","v":3309.5383879977321},{"$f":"IF(B13>'User input'!F$24,\"\",L13+M13+N13+O13+Q13-S13)","v":-1281.075532480078},{"$f":"IF(B13>'User input'!F$24,\"\",C13*T13)","v":-1240.931401637117}]
[null,{"$f":"IF(B13>='User input'!F$24,\"\",B13+1)","v":2},{"$f":"IF(B14>'User input'!F$24,\"\",'User input'!F$50^B14)","v":0.93830941869200402},{"$f":"IF(B14>'User input'!F$24,\"\",IF(B14=0,'User input'!F$14,D13+1))","v":2},{"$f":"IF(B14>'User input'!F$24,\"\",IF(B14=0,'User input'!F$19,E13+'User input'!F$43))","v":337.79455045502533},{"$f":"IF(B14>'User input'!F$24,\"\",EXP('User input'!G$9*(D14-'User input'!F$14)+'User input'!H$9*((E14-'User input'!F$19)/100))*'User input'!F$21*(1+'User input'!F$45)^B14)","v":27179.062920969209},{"$f":"IF(B14>'User input'!F$24,\"\",IF(B14>0,F13*'User input'!L$23,0))","v":1427.7358716067515},{"$f":"IF(B14>'User input'!F$24,\"\",IF(B14>0,F13-F14,0))","v":1375.6545111658197},{"$f":"IF(B14>'User input'!F$24,\"\",IF(B14>7,0,IF(SUM(I$11:I13)<1,IF(B14='User input'!F$24,'User input'!L35/2,'User input'!L35),0)))","v":0.1749},{"$f":"IF(B14>'User input'!F$24,\"\",IF(B14=0,MIN('User input'!F$20,'User input'!L$28)+'User input'!L$31+'User input'!L$32*I14,'User input'!L$32*I14))","v":5247},{"$f":"IF(B14>'User input'!F$24,\"\",IF(B14=0,'User input'!F$20-J14,K13-J14))","v":13119},{"$f":"IF(B14>'User input'!F$24,\"\",IF(B14>0,('User input'!F$20-'User input'!F$22)*'User input'!L$23,0))","v":900},{"$f":"IF(B14>'User input'!F$24,\"\",IF(B14='User input'!F$24,'User input'!F$20-'User input'!F$22,0))","v":0},{"$f":"IF(B14>'User input'!F$24,\"\",IF(B14=0,'User input'!F$22,IF(B14='User input'!F$24,-F14*(1-'User input'!F$46),0)))","v":0},{"$f":"IF(B14>'User input'!F$24,\"\",IF(B14>0,'User input'!F$48*F13,0))","v":428.32076148202543},{"$f":"IF(B14>'User input'!F$24,\"\",(IF(E14>'User input'!K$9,(E14-'User input'!K$9)*('User input'!F$23*(1+'User input'!F$45)^B14*'User input'!J$9*'User input'!I$9*('User input'!K$9/1000)^('User input'!J$9-1))/1000+'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B14*('User input'!K$9/1000)^'User input'!J$9,'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B14*(E14/1000)^'User input'!J$9))*'User input'!F$47)","v":2386.1703330274195},{"$f":"IF(B14>'User input'!F$24,\"\",IF(B14>0,(P14-P13),0))","v":1707.7074775097653},{"$f":"IF(B14>'User input'!F$24,\"\",Q14/'User input'!F$43)","v":10.110923786126225},{"$f":"IF(B14>'User input'!F$24,\"\",(J14+L14+O14+Q14)*('User input'!L$25+'User input'!L$26)-IF(B14='User input'!F$24,(F14-K14)*'User input'!L$25,0))","v":2923.9089683641023},{"$f":"IF(B14>'User input'!F$24,\"\",L14+M14+N14+O14+Q14-S14)","v":112.11927062768837},{"$f":"IF(B14>'User input'!F$24,\"\",C14*T14)","v":105.20256764683775}]
[null,{"$f":"IF(B14>='User input'!F$24,\"\",B14+1)","v":3},{"$f":"IF(B15>'User input'!F$24,\"\",'User input'!F$50^B15)","v":0.90890629989054483},{"$f":"IF(B15>'User input'!F$24,\"\",IF(B15=0,'User input'!F$14,D14+1))","v":3},{"$f":"IF(B15>'User input'!F$24,\"\",IF(B15=0,'User input'!F$19,E14+'User input'!F$43))","v":506.69182568253802},{"$f":"IF(B15>'User input'!F$24,\"\",EXP('User input'!G$9*(D15-'User input'!F$14)+'User input'!H$9*((E15-'User input'!F$19)/100))*'User input'!F$21*(1+'User input'!F$45)^B15)","v":25869.682059283143},{"$f":"IF(B15>'User input'!F$24,\"\",IF(B15>0,F14*'User input'!L$23,0))","v":1358.9531460484604},{"$f":"IF(B15>'User input'!F$24,\"\",IF(B15>0,F14-F15,0))","v":1309.3808616860661},{"$f":"IF(B15>'User input'!F$24,\"\",IF(B15>7,0,IF(SUM(I$11:I14)<1,IF(B15='User input'!F$24,'User input'!L36/2,'User input'!L36),0)))","v":6.2449999999999999E-2},{"$f":"IF(B15>'User input'!F$24,\"\",IF(B15=0,MIN('User input'!F$20,'User input'!L$28)+'User input'!L$31+'User input'!L$32*I15,'User input'!L$32*I15))","v":1873.5},{"$f":"IF(B15>'User input'!F$24,\"\",IF(B15=0,'User input'!F$20-J15,K14-J15))","v":11245.5},{"$f":"IF(B15>'User input'!F$24,\"\",IF(B15>0,('User input'!F$20-'User input'!F$22)*'User input'!L$23,0))","v":900},{"$f":"IF(B15>'User input'!F$24,\"\",IF(B15='User input'!F$24,'User input'!F$20-'User input'!F$22,0))","v":18000},{"$f":"IF(B15>'User input'!F$24,\"\",IF(B15=0,'User input'!F$22,IF(B15='User input'!F$24,-F15*(1-'User input'!F$46),0)))","v":-24576.197956318985},{"$f":"IF(B15>'User input'!F$24,\"\",IF(B15>0,'User input'!F$48*F14,0))","v":407.68594381453812},{"$f":"IF(B15>'User input'!F$24,\"\",(IF(E15>'User input'!K$9,(E15-'User input'!K$9)*('User input'!F$23*(1+'User input'!F$45)^B15*'User input'!J$9*'User input'!I$9*('User input'!K$9/1000)^('User input'!J$9-1))/1000+'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B15*('User input'!K$9/1000)^'User input'!J$9,'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B15*(E15/1000)^'User input'!J$9))*'User input'!F$47)","v":5000.1966172121583},{"$f":"IF(B15>'User input'!F$24,\"\",IF(B15>0,(P15-P14),0))","v":2614.0262841847389},{"$f":"IF(B15>'User input'!F$24,\"\",Q15/'User input'!F$43)","v":15.477018682885921},{"$f":"IF(B15>'User input'!F$24,\"\",(J15+L15+O15+Q15)*('User input'!L$25+'User input'!L$26)-IF(B15='User input'!F$24,(F15-K15)*'User input'!L$25,0))","v":-879.12649537288439},{"$f":"IF(B15>'User input'!F$24,\"\",L15+M15+N15+O15+Q15-S15)","v":-1775.3592329468236},{"$f":"IF(B15>'User input'!F$24,\"\",C15*T15)","v":-1613.6351913942133}]
[null,{"$f":"IF(B15>='User input'!F$24,\"\",B15+1)","v":""},{"$f":"IF(B16>'User input'!F$24,\"\",'User input'!F$50^B16)","v":""},{"$f":"IF(B16>'User input'!F$24,\"\",IF(B16=0,'User input'!F$14,D15+1))","v":""},{"$f":"IF(B16>'User input'!F$24,\"\",IF(B16=0,'User input'!F$19,E15+'User input'!F$43))","v":""},{"$f":"IF(B16>'User input'!F$24,\"\",EXP('User input'!G$9*(D16-'User input'!F$14)+'User input'!H$9*((E16-'User input'!F$19)/100))*'User input'!F$21*(1+'User input'!F$45)^B16)","v":""},{"$f":"IF(B16>'User input'!F$24,\"\",IF(B16>0,F15*'User input'!L$23,0))","v":""},{"$f":"IF(B16>'User input'!F$24,\"\",IF(B16>0,F15-F16,0))","v":""},{"$f":"IF(B16>'User input'!F$24,\"\",IF(B16>7,0,IF(SUM(I$11:I15)<1,IF(B16='User input'!F$24,'User input'!L37/2,'User input'!L37),0)))","v":""},{"$f":"IF(B16>'User input'!F$24,\"\",IF(B16=0,MIN('User input'!F$20,'User input'!L$28)+'User input'!L$31+'User input'!L$32*I16,'User input'!L$32*I16))","v":""},{"$f":"IF(B16>'User input'!F$24,\"\",IF(B16=0,'User input'!F$20-J16,K15-J16))","v":""},{"$f":"IF(B16>'User input'!F$24,\"\",IF(B16>0,('User input'!F$20-'User input'!F$22)*'User input'!L$23,0))","v":""},{"$f":"IF(B16>'User input'!F$24,\"\",IF(B16='User input'!F$24,'User input'!F$20-'User input'!F$22,0))","v":""},{"$f":"IF(B16>'User input'!F$24,\"\",IF(B16=0,'User input'!F$22,IF(B16='User input'!F$24,-F16*(1-'User input'!F$46),0)))","v":""},{"$f":"IF(B16>'User input'!F$24,\"\",IF(B16>0,'User input'!F$48*F15,0))","v":""},{"$f":"IF(B16>'User input'!F$24,\"\",(IF(E16>'User input'!K$9,(E16-'User input'!K$9)*('User input'!F$23*(1+'User input'!F$45)^B16*'User input'!J$9*'User input'!I$9*('User input'!K$9/1000)^('User input'!J$9-1))/1000+'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B16*('User input'!K$9/1000)^'User input'!J$9,'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B16*(E16/1000)^'User input'!J$9))*'User input'!F$47)","v":""},{"$f":"IF(B16>'User input'!F$24,\"\",IF(B16>0,(P16-P15),0))","v":""},{"$f":"IF(B16>'User input'!F$24,\"\",Q16/'User input'!F$43)","v":""},{"$f":"IF(B16>'User input'!F$24,\"\",(J16+L16+O16+Q16)*('User input'!L$25+'User input'!L$26)-IF(B16='User input'!F$24,(F16-K16)*'User input'!L$25,0))","v":""},{"$f":"IF(B16>'User input'!F$24,\"\",L16+M16+N16+O16+Q16-S16)","v":""},{"$f":"IF(B16>'User input'!F$24,\"\",C16*T16)","v":""}]
[null,{"$f":"IF(B16>='User input'!F$24,\"\",B16+1)","v":""},{"$f":"IF(B17>'User input'!F$24,\"\",'User input'!F$50^B17)","v":""},{"$f":"IF(B17>'User input'!F$24,\"\",IF(B17=0,'User input'!F$14,D16+1))","v":""},{"$f":"IF(B17>'User input'!F$24,\"\",IF(B17=0,'User input'!F$19,E16+'User input'!F$43))","v":""},{"$f":"IF(B17>'User input'!F$24,\"\",EXP('User input'!G$9*(D17-'User input'!F$14)+'User input'!H$9*((E17-'User input'!F$19)/100))*'User input'!F$21*(1+'User input'!F$45)^B17)","v":""},{"$f":"IF(B17>'User input'!F$24,\"\",IF(B17>0,F16*'User input'!L$23,0))","v":""},{"$f":"IF(B17>'User input'!F$24,\"\",IF(B17>0,F16-F17,0))","v":""},{"$f":"IF(B17>'User input'!F$24,\"\",IF(B17>7,0,IF(SUM(I$11:I16)<1,IF(B17='User input'!F$24,'User input'!L38/2,'User input'!L38),0)))","v":""},{"$f":"IF(B17>'User input'!F$24,\"\",IF(B17=0,MIN('User input'!F$20,'User input'!L$28)+'User input'!L$31+'User input'!L$32*I17,'User input'!L$32*I17))","v":""},{"$f":"IF(B17>'User input'!F$24,\"\",IF(B17=0,'User input'!F$20-J17,K16-J17))","v":""},{"$f":"IF(B17>'User input'!F$24,\"\",IF(B17>0,('User input'!F$20-'User input'!F$22)*'User input'!L$23,0))","v":""},{"$f":"IF(B17>'User input'!F$24,\"\",IF(B17='User input'!F$24,'User input'!F$20-'User input'!F$22,0))","v":""},{"$f":"IF(B17>'User input'!F$24,\"\",IF(B17=0,'User input'!F$22,IF(B17='User input'!F$24,-F17*(1-'User input'!F$46),0)))","v":""},{"$f":"IF(B17>'User input'!F$24,\"\",IF(B17>0,'User input'!F$48*F16,0))","v":""},{"$f":"IF(B17>'User input'!F$24,\"\",(IF(E17>'User input'!K$9,(E17-'User input'!K$9)*('User input'!F$23*(1+'User input'!F$45)^B17*'User input'!J$9*'User input'!I$9*('User input'!K$9/1000)^('User input'!J$9-1))/1000+'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B17*('User input'!K$9/1000)^'User input'!J$9,'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B17*(E17/1000)^'User input'!J$9))*'User input'!F$47)","v":""},{"$f":"IF(B17>'User input'!F$24,\"\",IF(B17>0,(P17-P16),0))","v":""},{"$f":"IF(B17>'User input'!F$24,\"\",Q17/'User input'!F$43)","v":""},{"$f":"IF(B17>'User input'!F$24,\"\",(J17+L17+O17+Q17)*('User input'!L$25+'User input'!L$26)-IF(B17='User input'!F$24,(F17-K17)*'User input'!L$25,0))","v":""},{"$f":"IF(B17>'User input'!F$24,\"\",L17+M17+N17+O17+Q17-S17)","v":""},{"$f":"IF(B17>'User input'!F$24,\"\",C17*T17)","v":""}]
[null,{"$f":"IF(B17>='User input'!F$24,\"\",B17+1)","v":""},{"$f":"IF(B18>'User input'!F$24,\"\",'User input'!F$50^B18)","v":""},{"$f":"IF(B18>'User input'!F$24,\"\",IF(B18=0,'User input'!F$14,D17+1))","v":""},{"$f":"IF(B18>'User input'!F$24,\"\",IF(B18=0,'User input'!F$19,E17+'User input'!F$43))","v":""},{"$f":"IF(B18>'User input'!F$24,\"\",EXP('User input'!G$9*(D18-'User input'!F$14)+'User input'!H$9*((E18-'User input'!F$19)/100))*'User input'!F$21*(1+'User input'!F$45)^B18)","v":""},{"$f":"IF(B18>'User input'!F$24,\"\",IF(B18>0,F17*'User input'!L$23,0))","v":""},{"$f":"IF(B18>'User input'!F$24,\"\",IF(B18>0,F17-F18,0))","v":""},{"$f":"IF(B18>'User input'!F$24,\"\",IF(B18>7,0,IF(SUM(I$11:I17)<1,IF(B18='User input'!F$24,'User input'!L39/2,'User input'!L39),0)))","v":""},{"$f":"IF(B18>'User input'!F$24,\"\",IF(B18=0,MIN('User input'!F$20,'User input'!L$28)+'User input'!L$31+'User input'!L$32*I18,'User input'!L$32*I18))","v":""},{"$f":"IF(B18>'User input'!F$24,\"\",IF(B18=0,'User input'!F$20-J18,K17-J18))","v":""},{"$f":"IF(B18>'User input'!F$24,\"\",IF(B18>0,('User input'!F$20-'User input'!F$22)*'User input'!L$23,0))","v":""},{"$f":"IF(B18>'User input'!F$24,\"\",IF(B18='User input'!F$24,'User input'!F$20-'User input'!F$22,0))","v":""},{"$f":"IF(B18>'User input'!F$24,\"\",IF(B18=0,'User input'!F$22,IF(B18='User input'!F$24,-F18*(1-'User input'!F$46),0)))","v":""},{"$f":"IF(B18>'User input'!F$24,\"\",IF(B18>0,'User input'!F$48*F17,0))","v":""},{"$f":"IF(B18>'User input'!F$24,\"\",(IF(E18>'User input'!K$9,(E18-'User input'!K$9)*('User input'!F$23*(1+'User input'!F$45)^B18*'User input'!J$9*'User input'!I$9*('User input'!K$9/1000)^('User input'!J$9-1))/1000+'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B18*('User input'!K$9/1000)^'User input'!J$9,'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B18*(E18/1000)^'User input'!J$9))*'User input'!F$47)","v":""},{"$f":"IF(B18>'User input'!F$24,\"\",IF(B18>0,(P18-P17),0))","v":""},{"$f":"IF(B18>'User input'!F$24,\"\",Q18/'User input'!F$43)","v":""},{"$f":"IF(B18>'User input'!F$24,\"\",(J18+L18+O18+Q18)*('User input'!L$25+'User input'!L$26)-IF(B18='User input'!F$24,(F18-K18)*'User input'!L$25,0))","v":""},{"$f":"IF(B18>'User input'!F$24,\"\",L18+M18+N18+O18+Q18-S18)","v":""},{"$f":"IF(B18>'User input'!F$24,\"\",C18*T18)","v":""}]
[null,{"$f":"IF(B18>='User input'!F$24,\"\",B18+1)","v":""},{"$f":"IF(B19>'User input'!F$24,\"\",'User input'!F$50^B19)","v":""},{"$f":"IF(B19>'User input'!F$24,\"\",IF(B19=0,'User input'!F$14,D18+1))","v":""},{"$f":"IF(B19>'User input'!F$24,\"\",IF(B19=0,'User input'!F$19,E18+'User input'!F$43))","v":""},{"$f":"IF(B19>'User input'!F$24,\"\",EXP('User input'!G$9*(D19-'User input'!F$14)+'User input'!H$9*((E19-'User input'!F$19)/100))*'User input'!F$21*(1+'User input'!F$45)^B19)","v":""},{"$f":"IF(B19>'User input'!F$24,\"\",IF(B19>0,F18*'User input'!L$23,0))","v":""},{"$f":"IF(B19>'User input'!F$24,\"\",IF(B19>0,F18-F19,0))","v":""},{"$f":"IF(B19>'User input'!F$24,\"\",IF(B19>7,0,IF(SUM(I$11:I18)<1,IF(B19='User input'!F$24,'User input'!L40/2,'User input'!L40),0)))","v":""},{"$f":"IF(B19>'User input'!F$24,\"\",IF(B19=0,MIN('User input'!F$20,'User input'!L$28)+'User input'!L$31+'User input'!L$32*I19,'User input'!L$32*I19))","v":""},{"$f":"IF(B19>'User input'!F$24,\"\",IF(B19=0,'User input'!F$20-J19,K18-J19))","v":""},{"$f":"IF(B19>'User input'!F$24,\"\",IF(B19>0,('User input'!F$20-'User input'!F$22)*'User input'!L$23,0))","v":""},{"$f":"IF(B19>'User input'!F$24,\"\",IF(B19='User input'!F$24,'User input'!F$20-'User input'!F$22,0))","v":""},{"$f":"IF(B19>'User input'!F$24,\"\",IF(B19=0,'User input'!F$22,IF(B19='User input'!F$24,-F19*(1-'User input'!F$46),0)))","v":""},{"$f":"IF(B19>'User input'!F$24,\"\",IF(B19>0,'User input'!F$48*F18,0))","v":""},{"$f":"IF(B19>'User input'!F$24,\"\",(IF(E19>'User input'!K$9,(E19-'User input'!K$9)*('User input'!F$23*(1+'User input'!F$45)^B19*'User input'!J$9*'User input'!I$9*('User input'!K$9/1000)^('User input'!J$9-1))/1000+'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B19*('User input'!K$9/1000)^'User input'!J$9,'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B19*(E19/1000)^'User input'!J$9))*'User input'!F$47)","v":""},{"$f":"IF(B19>'User input'!F$24,\"\",IF(B19>0,(P19-P18),0))","v":""},{"$f":"IF(B19>'User input'!F$24,\"\",Q19/'User input'!F$43)","v":""},{"$f":"IF(B19>'User input'!F$24,\"\",(J19+L19+O19+Q19)*('User input'!L$25+'User input'!L$26)-IF(B19='User input'!F$24,(F19-K19)*'User input'!L$25,0))","v":""},{"$f":"IF(B19>'User input'!F$24,\"\",L19+M19+N19+O19+Q19-S19)","v":""},{"$f":"IF(B19>'User input'!F$24,\"\",C19*T19)","v":""}]
[null,{"$f":"IF(B19>='User input'!F$24,\"\",B19+1)","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",'User input'!F$50^B20)","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",IF(B20=0,'User input'!F$14,D19+1))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",IF(B20=0,'User input'!F$19,E19+'User input'!F$43))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",EXP('User input'!G$9*(D20-'User input'!F$14)+'User input'!H$9*((E20-'User input'!F$19)/100))*'User input'!F$21*(1+'User input'!F$45)^B20)","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",IF(B20>0,F19*'User input'!L$23,0))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",IF(B20>0,F19-F20,0))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",IF(B20>7,0,IF(SUM(I$11:I19)<1,IF(B20='User input'!F$24,'User input'!L41/2,'User input'!L41),0)))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",IF(B20=0,MIN('User input'!F$20,'User input'!L$28)+'User input'!L$31+'User input'!L$32*I20,'User input'!L$32*I20))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",IF(B20=0,'User input'!F$20-J20,K19-J20))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",IF(B20>0,('User input'!F$20-'User input'!F$22)*'User input'!L$23,0))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",IF(B20='User input'!F$24,'User input'!F$20-'User input'!F$22,0))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",IF(B20=0,'User input'!F$22,IF(B20='User input'!F$24,-F20*(1-'User input'!F$46),0)))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",IF(B20>0,'User input'!F$48*F19,0))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",(IF(E20>'User input'!K$9,(E20-'User input'!K$9)*('User input'!F$23*(1+'User input'!F$45)^B20*'User input'!J$9*'User input'!I$9*('User input'!K$9/1000)^('User input'!J$9-1))/1000+'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B20*('User input'!K$9/1000)^'User input'!J$9,'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B20*(E20/1000)^'User input'!J$9))*'User input'!F$47)","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",IF(B20>0,(P20-P19),0))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",Q20/'User input'!F$43)","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",(J20+L20+O20+Q20)*('User input'!L$25+'User input'!L$26)-IF(B20='User input'!F$24,(F20-K20)*'User input'!L$25,0))","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",L20+M20+N20+O20+Q20-S20)","v":""},{"$f":"IF(B20>'User input'!F$24,\"\",C20*T20)","v":""}]
[null,{"$f":"IF(B20>='User input'!F$24,\"\",B20+1)","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",'User input'!F$50^B21)","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",IF(B21=0,'User input'!F$14,D20+1))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",IF(B21=0,'User input'!F$19,E20+'User input'!F$43))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",EXP('User input'!G$9*(D21-'User input'!F$14)+'User input'!H$9*((E21-'User input'!F$19)/100))*'User input'!F$21*(1+'User input'!F$45)^B21)","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",IF(B21>0,F20*'User input'!L$23,0))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",IF(B21>0,F20-F21,0))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",IF(B21>7,0,IF(SUM(I$11:I20)<1,IF(B21='User input'!F$24,'User input'!L42/2,'User input'!L42),0)))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",IF(B21=0,MIN('User input'!F$20,'User input'!L$28)+'User input'!L$31+'User input'!L$32*I21,'User input'!L$32*I21))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",IF(B21=0,'User input'!F$20-J21,K20-J21))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",IF(B21>0,('User input'!F$20-'User input'!F$22)*'User input'!L$23,0))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",IF(B21='User input'!F$24,'User input'!F$20-'User input'!F$22,0))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",IF(B21=0,'User input'!F$22,IF(B21='User input'!F$24,-F21*(1-'User input'!F$46),0)))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",IF(B21>0,'User input'!F$48*F20,0))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",(IF(E21>'User input'!K$9,(E21-'User input'!K$9)*('User input'!F$23*(1+'User input'!F$45)^B21*'User input'!J$9*'User input'!I$9*('User input'!K$9/1000)^('User input'!J$9-1))/1000+'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B21*('User input'!K$9/1000)^'User input'!J$9,'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B21*(E21/1000)^'User input'!J$9))*'User input'!F$47)","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",IF(B21>0,(P21-P20),0))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",Q21/'User input'!F$43)","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",(J21+L21+O21+Q21)*('User input'!L$25+'User input'!L$26)-IF(B21='User input'!F$24,(F21-K21)*'User input'!L$25,0))","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",L21+M21+N21+O21+Q21-S21)","v":""},{"$f":"IF(B21>'User input'!F$24,\"\",C21*T21)","v":""}]
[null,{"$f":"IF(B21>='User input'!F$24,\"\",B21+1)","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",'User input'!F$50^B22)","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",IF(B22=0,'User input'!F$14,D21+1))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",IF(B22=0,'User input'!F$19,E21+'User input'!F$43))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",EXP('User input'!G$9*(D22-'User input'!F$14)+'User input'!H$9*((E22-'User input'!F$19)/100))*'User input'!F$21*(1+'User input'!F$45)^B22)","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",IF(B22>0,F21*'User input'!L$23,0))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",IF(B22>0,F21-F22,0))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",IF(B22>7,0,IF(SUM(I$11:I21)<1,IF(B22='User input'!F$24,'User input'!L43/2,'User input'!L43),0)))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",IF(B22=0,MIN('User input'!F$20,'User input'!L$28)+'User input'!L$31+'User input'!L$32*I22,'User input'!L$32*I22))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",IF(B22=0,'User input'!F$20-J22,K21-J22))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",IF(B22>0,('User input'!F$20-'User input'!F$22)*'User input'!L$23,0))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",IF(B22='User input'!F$24,'User input'!F$20-'User input'!F$22,0))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",IF(B22=0,'User input'!F$22,IF(B22='User input'!F$24,-F22*(1-'User input'!F$46),0)))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",IF(B22>0,'User input'!F$48*F21,0))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",(IF(E22>'User input'!K$9,(E22-'User input'!K$9)*('User input'!F$23*(1+'User input'!F$45)^B22*'User input'!J$9*'User input'!I$9*('User input'!K$9/1000)^('User input'!J$9-1))/1000+'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B22*('User input'!K$9/1000)^'User input'!J$9,'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B22*(E22/1000)^'User input'!J$9))*'User input'!F$47)","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",IF(B22>0,(P22-P21),0))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",Q22/'User input'!F$43)","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",(J22+L22+O22+Q22)*('User input'!L$25+'User input'!L$26)-IF(B22='User input'!F$24,(F22-K22)*'User input'!L$25,0))","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",L22+M22+N22+O22+Q22-S22)","v":""},{"$f":"IF(B22>'User input'!F$24,\"\",C22*T22)","v":""}]
[null,{"$f":"IF(B22>='User input'!F$24,\"\",B22+1)","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",'User input'!F$50^B23)","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",IF(B23=0,'User input'!F$14,D22+1))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",IF(B23=0,'User input'!F$19,E22+'User input'!F$43))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",EXP('User input'!G$9*(D23-'User input'!F$14)+'User input'!H$9*((E23-'User input'!F$19)/100))*'User input'!F$21*(1+'User input'!F$45)^B23)","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",IF(B23>0,F22*'User input'!L$23,0))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",IF(B23>0,F22-F23,0))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",IF(B23>7,0,IF(SUM(I$11:I22)<1,IF(B23='User input'!F$24,'User input'!L44/2,'User input'!L44),0)))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",IF(B23=0,MIN('User input'!F$20,'User input'!L$28)+'User input'!L$31+'User input'!L$32*I23,'User input'!L$32*I23))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",IF(B23=0,'User input'!F$20-J23,K22-J23))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",IF(B23>0,('User input'!F$20-'User input'!F$22)*'User input'!L$23,0))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",IF(B23='User input'!F$24,'User input'!F$20-'User input'!F$22,0))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",IF(B23=0,'User input'!F$22,IF(B23='User input'!F$24,-F23*(1-'User input'!F$46),0)))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",IF(B23>0,'User input'!F$48*F22,0))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",(IF(E23>'User input'!K$9,(E23-'User input'!K$9)*('User input'!F$23*(1+'User input'!F$45)^B23*'User input'!J$9*'User input'!I$9*('User input'!K$9/1000)^('User input'!J$9-1))/1000+'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B23*('User input'!K$9/1000)^'User input'!J$9,'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B23*(E23/1000)^'User input'!J$9))*'User input'!F$47)","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",IF(B23>0,(P23-P22),0))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",Q23/'User input'!F$43)","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",(J23+L23+O23+Q23)*('User input'!L$25+'User input'!L$26)-IF(B23='User input'!F$24,(F23-K23)*'User input'!L$25,0))","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",L23+M23+N23+O23+Q23-S23)","v":""},{"$f":"IF(B23>'User input'!F$24,\"\",C23*T23)","v":""}]
[null,{"$f":"IF(B23>='User input'!F$24,\"\",B23+1)","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",'User input'!F$50^B24)","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",IF(B24=0,'User input'!F$14,D23+1))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",IF(B24=0,'User input'!F$19,E23+'User input'!F$43))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",EXP('User input'!G$9*(D24-'User input'!F$14)+'User input'!H$9*((E24-'User input'!F$19)/100))*'User input'!F$21*(1+'User input'!F$45)^B24)","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",IF(B24>0,F23*'User input'!L$23,0))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",IF(B24>0,F23-F24,0))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",IF(B24>7,0,IF(SUM(I$11:I23)<1,IF(B24='User input'!F$24,'User input'!L45/2,'User input'!L45),0)))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",IF(B24=0,MIN('User input'!F$20,'User input'!L$28)+'User input'!L$31+'User input'!L$32*I24,'User input'!L$32*I24))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",IF(B24=0,'User input'!F$20-J24,K23-J24))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",IF(B24>0,('User input'!F$20-'User input'!F$22)*'User input'!L$23,0))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",IF(B24='User input'!F$24,'User input'!F$20-'User input'!F$22,0))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",IF(B24=0,'User input'!F$22,IF(B24='User input'!F$24,-F24*(1-'User input'!F$46),0)))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",IF(B24>0,'User input'!F$48*F23,0))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",(IF(E24>'User input'!K$9,(E24-'User input'!K$9)*('User input'!F$23*(1+'User input'!F$45)^B24*'User input'!J$9*'User input'!I$9*('User input'!K$9/1000)^('User input'!J$9-1))/1000+'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B24*('User input'!K$9/1000)^'User input'!J$9,'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B24*(E24/1000)^'User input'!J$9))*'User input'!F$47)","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",IF(B24>0,(P24-P23),0))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",Q24/'User input'!F$43)","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",(J24+L24+O24+Q24)*('User input'!L$25+'User input'!L$26)-IF(B24='User input'!F$24,(F24-K24)*'User input'!L$25,0))","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",L24+M24+N24+O24+Q24-S24)","v":""},{"$f":"IF(B24>'User input'!F$24,\"\",C24*T24)","v":""}]
[null,{"$f":"IF(B24>='User input'!F$24,\"\",B24+1)","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",'User input'!F$50^B25)","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",IF(B25=0,'User input'!F$14,D24+1))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",IF(B25=0,'User input'!F$19,E24+'User input'!F$43))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",EXP('User input'!G$9*(D25-'User input'!F$14)+'User input'!H$9*((E25-'User input'!F$19)/100))*'User input'!F$21*(1+'User input'!F$45)^B25)","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",IF(B25>0,F24*'User input'!L$23,0))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",IF(B25>0,F24-F25,0))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",IF(B25>7,0,IF(SUM(I$11:I24)<1,IF(B25='User input'!F$24,'User input'!L46/2,'User input'!L46),0)))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",IF(B25=0,MIN('User input'!F$20,'User input'!L$28)+'User input'!L$31+'User input'!L$32*I25,'User input'!L$32*I25))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",IF(B25=0,'User input'!F$20-J25,K24-J25))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",IF(B25>0,('User input'!F$20-'User input'!F$22)*'User input'!L$23,0))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",IF(B25='User input'!F$24,'User input'!F$20-'User input'!F$22,0))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",IF(B25=0,'User input'!F$22,IF(B25='User input'!F$24,-F25*(1-'User input'!F$46),0)))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",IF(B25>0,'User input'!F$48*F24,0))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",(IF(E25>'User input'!K$9,(E25-'User input'!K$9)*('User input'!F$23*(1+'User input'!F$45)^B25*'User input'!J$9*'User input'!I$9*('User input'!K$9/1000)^('User input'!J$9-1))/1000+'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B25*('User input'!K$9/1000)^'User input'!J$9,'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B25*(E25/1000)^'User input'!J$9))*'User input'!F$47)","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",IF(B25>0,(P25-P24),0))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",Q25/'User input'!F$43)","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",(J25+L25+O25+Q25)*('User input'!L$25+'User input'!L$26)-IF(B25='User input'!F$24,(F25-K25)*'User input'!L$25,0))","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",L25+M25+N25+O25+Q25-S25)","v":""},{"$f":"IF(B25>'User input'!F$24,\"\",C25*T25)","v":""}]
[null,{"$f":"IF(B25>='User input'!F$24,\"\",B25+1)","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",'User input'!F$50^B26)","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",IF(B26=0,'User input'!F$14,D25+1))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",IF(B26=0,'User input'!F$19,E25+'User input'!F$43))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",EXP('User input'!G$9*(D26-'User input'!F$14)+'User input'!H$9*((E26-'User input'!F$19)/100))*'User input'!F$21*(1+'User input'!F$45)^B26)","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",IF(B26>0,F25*'User input'!L$23,0))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",IF(B26>0,F25-F26,0))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",IF(B26>7,0,IF(SUM(I$11:I25)<1,IF(B26='User input'!F$24,'User input'!L47/2,'User input'!L47),0)))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",IF(B26=0,MIN('User input'!F$20,'User input'!L$28)+'User input'!L$31+'User input'!L$32*I26,'User input'!L$32*I26))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",IF(B26=0,'User input'!F$20-J26,K25-J26))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",IF(B26>0,('User input'!F$20-'User input'!F$22)*'User input'!L$23,0))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",IF(B26='User input'!F$24,'User input'!F$20-'User input'!F$22,0))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",IF(B26=0,'User input'!F$22,IF(B26='User input'!F$24,-F26*(1-'User input'!F$46),0)))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",IF(B26>0,'User input'!F$48*F25,0))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",(IF(E26>'User input'!K$9,(E26-'User input'!K$9)*('User input'!F$23*(1+'User input'!F$45)^B26*'User input'!J$9*'User input'!I$9*('User input'!K$9/1000)^('User input'!J$9-1))/1000+'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B26*('User input'!K$9/1000)^'User input'!J$9,'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B26*(E26/1000)^'User input'!J$9))*'User input'!F$47)","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",IF(B26>0,(P26-P25),0))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",Q26/'User input'!F$43)","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",(J26+L26+O26+Q26)*('User input'!L$25+'User input'!L$26)-IF(B26='User input'!F$24,(F26-K26)*'User input'!L$25,0))","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",L26+M26+N26+O26+Q26-S26)","v":""},{"$f":"IF(B26>'User input'!F$24,\"\",C26*T26)","v":""}]
[null,{"$f":"IF(B26>='User input'!F$24,\"\",B26+1)","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",'User input'!F$50^B27)","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",IF(B27=0,'User input'!F$14,D26+1))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",IF(B27=0,'User input'!F$19,E26+'User input'!F$43))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",EXP('User input'!G$9*(D27-'User input'!F$14)+'User input'!H$9*((E27-'User input'!F$19)/100))*'User input'!F$21*(1+'User input'!F$45)^B27)","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",IF(B27>0,F26*'User input'!L$23,0))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",IF(B27>0,F26-F27,0))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",IF(B27>7,0,IF(SUM(I$11:I26)<1,IF(B27='User input'!F$24,'User input'!L48/2,'User input'!L48),0)))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",IF(B27=0,MIN('User input'!F$20,'User input'!L$28)+'User input'!L$31+'User input'!L$32*I27,'User input'!L$32*I27))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",IF(B27=0,'User input'!F$20-J27,K26-J27))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",IF(B27>0,('User input'!F$20-'User input'!F$22)*'User input'!L$23,0))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",IF(B27='User input'!F$24,'User input'!F$20-'User input'!F$22,0))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",IF(B27=0,'User input'!F$22,IF(B27='User input'!F$24,-F27*(1-'User input'!F$46),0)))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",IF(B27>0,'User input'!F$48*F26,0))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",(IF(E27>'User input'!K$9,(E27-'User input'!K$9)*('User input'!F$23*(1+'User input'!F$45)^B27*'User input'!J$9*'User input'!I$9*('User input'!K$9/1000)^('User input'!J$9-1))/1000+'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B27*('User input'!K$9/1000)^'User input'!J$9,'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B27*(E27/1000)^'User input'!J$9))*'User input'!F$47)","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",IF(B27>0,(P27-P26),0))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",Q27/'User input'!F$43)","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",(J27+L27+O27+Q27)*('User input'!L$25+'User input'!L$26)-IF(B27='User input'!F$24,(F27-K27)*'User input'!L$25,0))","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",L27+M27+N27+O27+Q27-S27)","v":""},{"$f":"IF(B27>'User input'!F$24,\"\",C27*T27)","v":""},null,"",""]
[null,{"$f":"IF(B27>='User input'!F$24,\"\",B27+1)","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",'User input'!F$50^B28)","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",IF(B28=0,'User input'!F$14,D27+1))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",IF(B28=0,'User input'!F$19,E27+'User input'!F$43))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",EXP('User input'!G$9*(D28-'User input'!F$14)+'User input'!H$9*((E28-'User input'!F$19)/100))*'User input'!F$21*(1+'User input'!F$45)^B28)","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",IF(B28>0,F27*'User input'!L$23,0))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",IF(B28>0,F27-F28,0))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",IF(B28>7,0,IF(SUM(I$11:I27)<1,IF(B28='User input'!F$24,'User input'!L49/2,'User input'!L49),0)))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",IF(B28=0,MIN('User input'!F$20,'User input'!L$28)+'User input'!L$31+'User input'!L$32*I28,'User input'!L$32*I28))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",IF(B28=0,'User input'!F$20-J28,K27-J28))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",IF(B28>0,('User input'!F$20-'User input'!F$22)*'User input'!L$23,0))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",IF(B28='User input'!F$24,'User input'!F$20-'User input'!F$22,0))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",IF(B28=0,'User input'!F$22,IF(B28='User input'!F$24,-F28*(1-'User input'!F$46),0)))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",IF(B28>0,'User input'!F$48*F27,0))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",(IF(E28>'User input'!K$9,(E28-'User input'!K$9)*('User input'!F$23*(1+'User input'!F$45)^B28*'User input'!J$9*'User input'!I$9*('User input'!K$9/1000)^('User input'!J$9-1))/1000+'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B28*('User input'!K$9/1000)^'User input'!J$9,'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B28*(E28/1000)^'User input'!J$9))*'User input'!F$47)","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",IF(B28>0,(P28-P27),0))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",Q28/'User input'!F$43)","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",(J28+L28+O28+Q28)*('User input'!L$25+'User input'!L$26)-IF(B28='User input'!F$24,(F28-K28)*'User input'!L$25,0))","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",L28+M28+N28+O28+Q28-S28)","v":""},{"$f":"IF(B28>'User input'!F$24,\"\",C28*T28)","v":""},null,"",""]
[null,{"$f":"IF(B28>='User input'!F$24,\"\",B28+1)","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",'User input'!F$50^B29)","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",IF(B29=0,'User input'!F$14,D28+1))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",IF(B29=0,'User input'!F$19,E28+'User input'!F$43))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",EXP('User input'!G$9*(D29-'User input'!F$14)+'User input'!H$9*((E29-'User input'!F$19)/100))*'User input'!F$21*(1+'User input'!F$45)^B29)","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",IF(B29>0,F28*'User input'!L$23,0))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",IF(B29>0,F28-F29,0))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",IF(B29>7,0,IF(SUM(I$11:I28)<1,IF(B29='User input'!F$24,'User input'!L50/2,'User input'!L50),0)))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",IF(B29=0,MIN('User input'!F$20,'User input'!L$28)+'User input'!L$31+'User input'!L$32*I29,'User input'!L$32*I29))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",IF(B29=0,'User input'!F$20-J29,K28-J29))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",IF(B29>0,('User input'!F$20-'User input'!F$22)*'User input'!L$23,0))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",IF(B29='User input'!F$24,'User input'!F$20-'User input'!F$22,0))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",IF(B29=0,'User input'!F$22,IF(B29='User input'!F$24,-F29*(1-'User input'!F$46),0)))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",IF(B29>0,'User input'!F$48*F28,0))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",(IF(E29>'User input'!K$9,(E29-'User input'!K$9)*('User input'!F$23*(1+'User input'!F$45)^B29*'User input'!J$9*'User input'!I$9*('User input'!K$9/1000)^('User input'!J$9-1))/1000+'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B29*('User input'!K$9/1000)^'User input'!J$9,'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B29*(E29/1000)^'User input'!J$9))*'User input'!F$47)","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",IF(B29>0,(P29-P28),0))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",Q29/'User input'!F$43)","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",(J29+L29+O29+Q29)*('User input'!L$25+'User input'!L$26)-IF(B29='User input'!F$24,(F29-K29)*'User input'!L$25,0))","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",L29+M29+N29+O29+Q29-S29)","v":""},{"$f":"IF(B29>'User input'!F$24,\"\",C29*T29)","v":""},null,"",""]
[null,{"$f":"IF(B29>='User input'!F$24,\"\",B29+1)","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",'User input'!F$50^B30)","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",IF(B30=0,'User input'!F$14,D29+1))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",IF(B30=0,'User input'!F$19,E29+'User input'!F$43))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",EXP('User input'!G$9*(D30-'User input'!F$14)+'User input'!H$9*((E30-'User input'!F$19)/100))*'User input'!F$21*(1+'User input'!F$45)^B30)","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",IF(B30>0,F29*'User input'!L$23,0))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",IF(B30>0,F29-F30,0))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",IF(B30>7,0,IF(SUM(I$11:I29)<1,IF(B30='User input'!F$24,'User input'!L51/2,'User input'!L51),0)))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",IF(B30=0,MIN('User input'!F$20,'User input'!L$28)+'User input'!L$31+'User input'!L$32*I30,'User input'!L$32*I30))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",IF(B30=0,'User input'!F$20-J30,K29-J30))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",IF(B30>0,('User input'!F$20-'User input'!F$22)*'User input'!L$23,0))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",IF(B30='User input'!F$24,'User input'!F$20-'User input'!F$22,0))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",IF(B30=0,'User input'!F$22,IF(B30='User input'!F$24,-F30*(1-'User input'!F$46),0)))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",IF(B30>0,'User input'!F$48*F29,0))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",(IF(E30>'User input'!K$9,(E30-'User input'!K$9)*('User input'!F$23*(1+'User input'!F$45)^B30*'User input'!J$9*'User input'!I$9*('User input'!K$9/1000)^('User input'!J$9-1))/1000+'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B30*('User input'!K$9/1000)^'User input'!J$9,'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B30*(E30/1000)^'User input'!J$9))*'User input'!F$47)","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",IF(B30>0,(P30-P29),0))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",Q30/'User input'!F$43)","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",(J30+L30+O30+Q30)*('User input'!L$25+'User input'!L$26)-IF(B30='User input'!F$24,(F30-K30)*'User input'!L$25,0))","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",L30+M30+N30+O30+Q30-S30)","v":""},{"$f":"IF(B30>'User input'!F$24,\"\",C30*T30)","v":""},null,"",""]
[null,{"$f":"IF(B30>='User input'!F$24,\"\",B30+1)","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",'User input'!F$50^B31)","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",IF(B31=0,'User input'!F$14,D30+1))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",IF(B31=0,'User input'!F$19,E30+'User input'!F$43))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",EXP('User input'!G$9*(D31-'User input'!F$14)+'User input'!H$9*((E31-'User input'!F$19)/100))*'User input'!F$21*(1+'User input'!F$45)^B31)","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",IF(B31>0,F30*'User input'!L$23,0))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",IF(B31>0,F30-F31,0))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",IF(B31>7,0,IF(SUM(I$11:I30)<1,IF(B31='User input'!F$24,'User input'!L52/2,'User input'!L52),0)))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",IF(B31=0,MIN('User input'!F$20,'User input'!L$28)+'User input'!L$31+'User input'!L$32*I31,'User input'!L$32*I31))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",IF(B31=0,'User input'!F$20-J31,K30-J31))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",IF(B31>0,('User input'!F$20-'User input'!F$22)*'User input'!L$23,0))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",IF(B31='User input'!F$24,'User input'!F$20-'User input'!F$22,0))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",IF(B31=0,'User input'!F$22,IF(B31='User input'!F$24,-F31*(1-'User input'!F$46),0)))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",IF(B31>0,'User input'!F$48*F30,0))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",(IF(E31>'User input'!K$9,(E31-'User input'!K$9)*('User input'!F$23*(1+'User input'!F$45)^B31*'User input'!J$9*'User input'!I$9*('User input'!K$9/1000)^('User input'!J$9-1))/1000+'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B31*('User input'!K$9/1000)^'User input'!J$9,'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B31*(E31/1000)^'User input'!J$9))*'User input'!F$47)","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",IF(B31>0,(P31-P30),0))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",Q31/'User input'!F$43)","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",(J31+L31+O31+Q31)*('User input'!L$25+'User input'!L$26)-IF(B31='User input'!F$24,(F31-K31)*'User input'!L$25,0))","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",L31+M31+N31+O31+Q31-S31)","v":""},{"$f":"IF(B31>'User input'!F$24,\"\",C31*T31)","v":""},null,"",""]
[null,{"$f":"IF(B31>='User input'!F$24,\"\",B31+1)","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",'User input'!F$50^B32)","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",IF(B32=0,'User input'!F$14,D31+1))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",IF(B32=0,'User input'!F$19,E31+'User input'!F$43))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",EXP('User input'!G$9*(D32-'User input'!F$14)+'User input'!H$9*((E32-'User input'!F$19)/100))*'User input'!F$21*(1+'User input'!F$45)^B32)","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",IF(B32>0,F31*'User input'!L$23,0))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",IF(B32>0,F31-F32,0))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",IF(B32>7,0,IF(SUM(I$11:I31)<1,IF(B32='User input'!F$24,'User input'!L53/2,'User input'!L53),0)))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",IF(B32=0,MIN('User input'!F$20,'User input'!L$28)+'User input'!L$31+'User input'!L$32*I32,'User input'!L$32*I32))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",IF(B32=0,'User input'!F$20-J32,K31-J32))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",IF(B32>0,('User input'!F$20-'User input'!F$22)*'User input'!L$23,0))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",IF(B32='User input'!F$24,'User input'!F$20-'User input'!F$22,0))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",IF(B32=0,'User input'!F$22,IF(B32='User input'!F$24,-F32*(1-'User input'!F$46),0)))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",IF(B32>0,'User input'!F$48*F31,0))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",(IF(E32>'User input'!K$9,(E32-'User input'!K$9)*('User input'!F$23*(1+'User input'!F$45)^B32*'User input'!J$9*'User input'!I$9*('User input'!K$9/1000)^('User input'!J$9-1))/1000+'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B32*('User input'!K$9/1000)^'User input'!J$9,'User input'!I$9*'User input'!F$23*(1+'User input'!F$45)^B32*(E32/1000)^'User input'!J$9))*'User input'!F$47)","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",IF(B32>0,(P32-P31),0))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",Q32/'User input'!F$43)","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",(J32+L32+O32+Q32)*('User input'!L$25+'User input'!L$26)-IF(B32='User input'!F$24,(F32-K32)*'User input'!L$25,0))","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",L32+M32+N32+O32+Q32-S32)","v":""},{"$f":"IF(B32>'User input'!F$24,\"\",C32*T32)","v":""},null,"",""]
[]
[]
[null,"* EOY = End of year",null,null,null,null,null,null,{"$f":"IF(OR('User input'!L41>1.01,'User input'!L41<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'!L41>1.01,'User input'!L41<0.99),\"Go back to User Input tab and check entered values!\",\" \")","v":" "}]

{"sheet":"Analysis summary","index":3,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Baler analysis summary section"]
[]
[null,"Analysis highlights:"]
[null,"Baler class used",null,null,null,{"$f":"VLOOKUP('User input'!F12,'User input'!B7:I8,2)","v":"Large round baler"},null,{"$f":"IF('User input'!F12=2,\"\",\"(using \"&FIXED((1-'User input'!F13)*100,0)&\"% twine and \"&FIXED('User input'!F13*100,0)&\"% net wrap)\")","v":"(using 0% twine and 100% net wrap)"}]
[]
[null,"Baler purchase price",null,null,null,{"$f":"'User input'!F20","v":30000}]
[null,"Baler age when purchased",null,null,null,{"$f":"'User input'!F14","v":0}]
[null,"Bales on baler when purchased",null,null,null,{"$f":"'User input'!F15","v":0}]
[null,"Estimated hours on baler when purchased",null,null,null,{"$f":"'User input'!F19","v":0}]
[null,"Average weight of bales in lb",null,null,null,{"$f":"'User input'!F32","v":1700}]
[null,"Bales made by baler per year",null,null,null,{"$f":"'User input'!F41","v":5000}]
[null,"Tons of hay baled per year",null,null,null,{"$f":"F11*F12/2000","v":4250}]
[null,"Hours put on baler per year",null,null,null,{"$f":"'User input'!F43","v":168.89727522751267}]
[null,"Hours put on tractor hourmeter per year",null,null,null,{"$f":"'User input'!L19","v":295.57023164814717}]
[null,"Total acres baled per year",null,null,null,{"$f":"'User input'!F42","v":3541.6666666666665}]
[null,"Number of years baler will be used",null,null,null,{"$f":"'User input'!F24","v":3}]
[null,"Baler value when sold",null,null,null,{"$f":"-MIN('Time and Tax (TT)'!N12:N32)","v":24576.197956318985}]
[null,"Accumulated repairs over lifetime",null,null,null,{"$f":"MAX('Time and Tax (TT)'!P12:P32)","v":5000.1966172121583}]
[]
[null,"Cost breakdown:"]
[null,null,null,null,null,"$/year","$/bale","$/ton","$/hour","$/acre"]
[null,null,"Opportunity interest",null,null,{"$f":"'User input'!L46","v":1243.8269696294522},{"$f":"F23/F$12","v":0.24876539392589042},{"$f":"F23/F$13","v":0.29266516932457698},{"$f":"F23/F$14","v":7.3643992654941179},{"$f":"F23/F$16","v":0.35119820318949241}]
[null,null,"Market depreciation",null,null,{"$f":"'User input'!L47","v":1198.4542910971716},{"$f":"F24/F$12","v":0.23969085821943431},{"$f":"F24/F$13","v":0.28198924496404038},{"$f":"F24/F$14","v":7.0957585874774862},{"$f":"F24/F$16","v":0.33838709395684846}]
[null,null,"Repair and maintenance",null,null,{"$f":"'User input'!L48","v":1431.4751902565904},{"$f":"F25/F$12","v":0.28629503805131806},{"$f":"F25/F$13","v":0.33681769182508009},{"$f":"F25/F$14","v":8.4754190873021802},{"$f":"F25/F$16","v":0.40418123019009611}]
[null,null,"Tax, insurance, & shelter (TIS)",null,null,{"$f":"'User input'!L49","v":373.14809088883567},{"$f":"F26/F$12","v":7.4629618177767129E-2},{"$f":"F26/F$13","v":8.7799550797373102E-2},{"$f":"F26/F$14","v":2.2093197796482356},{"$f":"F26/F$16","v":0.10535946095684773}]
[null,"SUBTOTAL1",null,null,null,{"$f":"SUM(F23:F26)","v":4246.9045418720498},{"$f":"SUM(G23:G26)","v":0.84938090837440994},{"$f":"SUM(H23:H26)","v":0.99927165691107056},{"$f":"SUM(I23:I26)","v":25.14489671992202},{"$f":"SUM(J23:J26)","v":1.1991259882932848}]
[]
[null,null,"Twine or net wrap",null,null,{"$f":"'User input'!F41*'User input'!F60","v":7351.326809400116},{"$f":"F29/F$12","v":1.4702653618800232},{"$f":"F29/F$13","v":1.7297239551529684},{"$f":"F29/F$14","v":43.525431653634016},{"$f":"F29/F$16","v":2.0756687461835623}]
[null,null,"Tractor rental charge",null,null,{"$f":"'User input'!L19*'User input'!L14","v":8867.1069494444146},{"$f":"F30/F$12","v":1.7734213898888829},{"$f":"F30/F$13","v":2.0863781057516269},{"$f":"F30/F$14","v":52.5},{"$f":"F30/F$16","v":2.5036537269019523}]
[null,null,"Labor",null,null,{"$f":"'User input'!L19*'User input'!L20*'User input'!L21","v":7684.8260228518266},{"$f":"F31/F$12","v":1.5369652045703652},{"$f":"F31/F$13","v":1.8081943583180768},{"$f":"F31/F$14","v":45.5},{"$f":"F31/F$16","v":2.1698332299816925}]
[null,null,"Fuel and lubrication",null,null,{"$f":"'User input'!L19*'User input'!L15*'User input'!L16*(1+'User input'!L17)","v":5852.290586633314},{"$f":"F32/F$12","v":1.1704581173266628},{"$f":"F32/F$13","v":1.3770095497960739},{"$f":"F32/F$14","v":34.65},{"$f":"F32/F$16","v":1.6524114597552888}]
[null,"SUBTOTAL",null,null,null,{"$f":"SUM(F29:F32)","v":29755.55036832967},{"$f":"SUM(G29:G32)","v":5.9511100736659346},{"$f":"SUM(H29:H32)","v":7.0013059690187456},{"$f":"SUM(I29:I32)","v":176.17543165363404},{"$f":"SUM(J29:J32)","v":8.4015671628224968}]
[]
[null,"Total for baling operation2",null,null,null,{"$f":"F27+F33","v":34002.454910201719},{"$f":"G27+G33","v":6.8004909820403441},{"$f":"H27+H33","v":8.0005776259298163},{"$f":"I27+I33","v":201.32032837355607},{"$f":"J27+J33","v":9.6006931511157809}]
[]
[null,"1 Can be compared to baler rental rates since tractor, labor, and fuel & lubrication are excluded."]
[null,"2 Can be approximately compared to custom rates for baling if cost of related vehicles such as pickups is added."]
[]
[null,"Date of analysis =====>",null,null,{"$f":"NOW()","v":"2016-06-29T11:05:50.150"}]

{"sheet":"Baler Models","index":4,"n_rows":197,"n_cols":6,"rows_kept":197,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Table 1.  Selected baler models and associated measurements1"]
[]
[null,null,null,null,"Bale width","Bale height"]
[null,null,"Brand","Model","(inches)","(inches)"]
[null,"Square Balers"]
[null,null,"AGCO Hesston ",2170,47,34.4]
[null,null,"AGCO Hesston ",2190,47.25,50]
[null,null,"AGCO Hesston ",4700,31,32.5]
[null,null,"AGCO Hesston ",4750,31.5,34.4]
[null,null,"AGCO Hesston ",4755,31.5,34.4]
[null,null,"AGCO Hesston ",4760,31.5,34.4]
[null,null,"AGCO Hesston ",4790,47.25,34.4]
[null,null,"AGCO Hesston ",4800,46.5,50]
[null,null,"AGCO Hesston ",4900,46.5,50]
[null,null,"AGCO Hesston ",4910,46.5,50]
[null,null,"AGCO Hesston ",7434,47,34.4]
[null,null,"AGCO Hesston ",7444,46.5,50]
[null,null,"New Holland",590,31.5,35.4]
[null,null,"New Holland",595,47.3,35.4]
[null,null,"New Holland","BB9060",35,32]
[null,null,"New Holland","BB9080",47,35]
[null,null,"New Holland","BB940",31.5,35.4]
[null,null,"New Holland","BB940A",31.5,35.4]
[null,null,"New Holland","BB960",47.3,35.4]
[null,null,"New Holland","BB960A",47.3,35.4]
[null,null,"New Holland","D1000",24,36]
[null,null,"New Holland","D2000",47.3,35.4]
[null,null,"New Holland","D800",24,36]
[]
[null,"Round Balers"]
[null,null,"AGCO Hesston  ",514,60,72]
[null,null,"AGCO Hesston  ",530,39.4,52]
[null,null,"AGCO Hesston  ",540,47,51]
[null,null,"AGCO Hesston  ",545,47,60]
[null,null,"AGCO Hesston  ",550,46.5,75]
[null,null,"AGCO Hesston  ",560,61.5,72]
[null,null,"AGCO Hesston  ",730,39.4,52]
[null,null,"AGCO Hesston  ",740,47,51]
[null,null,"AGCO Hesston  ",745,46.5,60]
[null,null,"AGCO Hesston  ",814,60,72]
[null,null,"AGCO Hesston  ",830,39.4,52]
[null,null,"AGCO Hesston  ",840,47,51]
[null,null,"AGCO Hesston  ",845,46.5,60]
[null,null,"AGCO Hesston  ",855,61.5,60]
[null,null,"AGCO Hesston  ",945,46.5,60]
[null,null,"AGCO Hesston  ",946,46.5,72]
[null,null,"AGCO Hesston  ",955,61.5,60]
[null,null,"AGCO Hesston  ",956,61.5,72]
[null,null,"AGCO Hesston  ",1734,39,52]
[null,null,"AGCO Hesston  ",1745,46.5,60]
[null,null,"AGCO Hesston  ",1746,46.5,72]
[null,null,"AGCO Hesston  ",1756,61.5,72]
[null,null,"AGCO Hesston  ",2745,46.5,60]
[null,null,"AGCO Hesston  ",2846,46.5,72]
[null,null,"AGCO Hesston  ",2856,61.5,72]
[null,null,"AGCO Hesston  ",5134,39,52]
[null,null,"AGCO Hesston  ",5145,46.5,60]
[null,null,"AGCO Hesston  ",5146,46.5,72]
[null,null,"AGCO Hesston  ",5156,61.5,72]
[null,null,"AGCO Hesston  ",5510,60,60]
[null,null,"AGCO Hesston  ",5530,39.4,52]
[null,null,"AGCO Hesston  ",5540,47,72]
[null,null,"AGCO Hesston  ",5545,48,70]
[null,null,"AGCO Hesston  ",5545,46.5,60]
[null,null,"AGCO Hesston  ",5546,46.5,72]
[null,null,"AGCO Hesston  ",5556,61.5,72]
[null,null,"AGCO Hesston  ",5580,60,72]
[null,null,"AGCO Hesston  ",5585,60,70]
[null,null,"AGCO Hesston  ","5456A",61.5,72]
[null,null,"AGCO Hesston  ","5546A",46.5,72]
[null,null,"AGCO Hesston  ","555 S",46.5,75]
[null,null,"AGCO Hesston  ","555 S",46.5,72]
[null,null,"AGCO Hesston  ","565A",61.5,72]
[null,null,"AGCO Hesston  ","565A",61.5,72]
[null,null,"AGCO Hesston  ","846A",46.5,72]
[null,null,"AGCO Hesston  ","856A",61.5,72]
[null,null,"AGCO Hesston  ","856A",61.5,72]
[null,null,"Gehl  ",1450,45,60]
[null,null,"Gehl  ",1460,45,60]
[null,null,"Gehl  ",1465,45,60]
[null,null,"Gehl  ",1470,45,60]
[null,null,"Gehl  ",1475,45,60]
[null,null,"Gehl  ",1850,61,72]
[null,null,"Gehl  ",1860,61,72]
[null,null,"Gehl  ",1865,61,72]
[null,null,"Gehl  ",1870,61,72]
[null,null,"Gehl  ",1875,61,72]
[null,null,"Gehl  ",2580,45,60]
[null,null,"Gehl  ",2880,61,72]
[null,null,"Gehl  ","1860A",61,72]
[null,null,"John Deere",330,46.1,51]
[null,null,"John Deere",335,46.1,51]
[null,null,"John Deere",375,61.6,51]
[null,null,"John Deere",385,46.1,60]
[null,null,"John Deere",410,48,60]
[null,null,"John Deere",430,46.1,72]
[null,null,"John Deere",435,46.1,72]
[null,null,"John Deere",446,46.1,51]
[null,null,"John Deere",447,46.1,51]
[null,null,"John Deere",448,46,51]
[null,null,"John Deere",456,46.1,60]
[null,null,"John Deere",457,46.1,60]
[null,null,"John Deere",458,46.1,60]
[null,null,"John Deere",466,46.1,72]
[null,null,"John Deere",467,46.1,72]
[null,null,"John Deere",468,46,72]
[null,null,"John Deere",510,63,72]
[null,null,"John Deere",530,61.6,72]
[null,null,"John Deere",535,61.6,72]
[null,null,"John Deere",546,61.6,51]
[null,null,"John Deere",547,61.6,51]
[null,null,"John Deere",566,61.6,72]
[null,null,"John Deere",567,61.6,72]
[null,null,"John Deere",568,61.6,72]
[null,null,"John Deere","582SS",46.1,61]
[null,null,"John Deere","854SS",46.1,60]
[null,null,"Krone",1250,48,48]
[null,null,"Krone",1800,48,72]
[null,null,"Krone","KR125",48,48]
[null,null,"Krone","KR125B",48,48]
[null,null,"Krone","KR130",48,48]
[null,null,"Krone","KR130B",48,48]
[null,null,"Krone","KR181",60,72]
[null,null,"Krone","KR230",48,48]
[null,null,"Krone","KR280",60,72]
[null,null,"Krone","VP1800",48,72]
[null,null,"Krone","VP1810",48,72]
[null,null,"New Holland",630,46.5,48]
[null,null,"New Holland",634,46.5,48]
[null,null,"New Holland",638,46.5,48]
[null,null,"New Holland",640,46.5,60]
[null,null,"New Holland",644,46.5,60]
[null,null,"New Holland",648,46.5,60]
[null,null,"New Holland",650,46.5,72]
[null,null,"New Holland",654,46.5,70]
[null,null,"New Holland",658,46.5,70]
[null,null,"New Holland",660,61.5,72]
[null,null,"New Holland",664,61.5,70]
[null,null,"New Holland",668,61.5,70]
[null,null,"New Holland",688,61.5,70]
[null,null,"New Holland",847,48,54]
[null,null,"New Holland",848,48,54]
[null,null,"New Holland",849,57,60]
[null,null,"New Holland",852,66,66]
[null,null,"New Holland",853,57,60]
[null,null,"New Holland",855,66,66]
[null,null,"New Holland","BR7050",46.5,48]
[null,null,"New Holland","BR7060",46.5,60]
[null,null,"New Holland","BR7070",46.5,72]
[null,null,"New Holland","BR7090",61.5,72]
[null,null,"New Holland","BR730",46.5,48]
[null,null,"New Holland","BR730A",46.5,48]
[null,null,"New Holland","BR740",46.5,60]
[null,null,"New Holland","BR740A",46.5,60]
[null,null,"New Holland","BR750",46.5,72]
[null,null,"New Holland","BR750A",46.5,72]
[null,null,"New Holland","BR780",61.5,72]
[null,null,"New Holland","BR780A",61.5,72]
[null,null,"Vermeer",5400,48,60]
[null,null,"Vermeer",5500,60,60]
[null,null,"Vermeer","403F",36,48]
[null,null,"Vermeer","403SG",36,48]
[null,null,"Vermeer","503 l",36,60]
[null,null,"Vermeer","504 I",48,60]
[null,null,"Vermeer","504L",48,60]
[null,null,"Vermeer","504M ",47,60]
[null,null,"Vermeer","504M Classic",47,60]
[null,null,"Vermeer","504SG",48,60]
[null,null,"Vermeer","504Sl",48,60]
[null,null,"Vermeer","505 l",60,60]
[null,null,"Vermeer","505L",60,60]
[null,null,"Vermeer","505M Classic",60,60]
[null,null,"Vermeer","505Sl",60,60]
[null,null,"Vermeer","505Sl",60,60]
[null,null,"Vermeer","5400Rebel",48,60]
[null,null,"Vermeer","5410Rebel",48,60]
[null,null,"Vermeer","5500Rebel",60,60]
[null,null,"Vermeer","554XL",48,60]
[null,null,"Vermeer","555XL",60,60]
[null,null,"Vermeer","604J",48,72]
[null,null,"Vermeer","604K",48,72]
[null,null,"Vermeer","604L",48,72]
[null,null,"Vermeer","604L",48,72]
[null,null,"Vermeer","604M",48,72]
[null,null,"Vermeer","604SJ",48,72]
[null,null,"Vermeer","604SM",48,72]
[null,null,"Vermeer","604XL",48,72]
[null,null,"Vermeer","605H",60,72]
[null,null,"Vermeer","605J",60,72]
[null,null,"Vermeer","605K",60,72]
[null,null,"Vermeer","605L",60,72]
[null,null,"Vermeer","605M",60,72]
[null,null,"Vermeer","605SJ",60,72]
[null,null,"Vermeer","605SM",60,72]
[null,null,"Vermeer","605XL",60,72]
[null,null,"Vermeer","Ensiler",48,60]