{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Intro","User info","Calculations","Blank form"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":7,"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":"Intro","index":0,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[[50,1,50,11],[37,1,37,11],[38,1,39,8],[40,1,41,4],[40,6,41,11],[44,15,44,16],[45,1,45,3],[4,1,5,8],[4,13,5,23],[7,2,7,3],[7,4,7,5],[7,13,8,13],[35,1,36,11]]}
[]
[]
[null,"KSU-Machinery Costs"]
[]
[null,"An Excel spreadsheet to assist producers in calculating farm specific custom farming rates and benchmarking machinery costs"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Version- 6.30.16"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"DESCRIPTION OF \"SHEETS\" (see tabs at bottom of screen)"]
[null,"Intro - Sheet that provides directions for using spreadsheet and author contact information."]
[null,"User info - Sheet that contains basic information about using the spreadsheet (i.e., explanation of inputs and outputs)."]
[null,"Calculations - Sheet that contains formulas for automatic calculations to estimate farm-specific machinery costs."]
[null,"Blank form - Sheet that contains a worksheet that can be used to perform machinery cost calculations manually."]
[]
[]
[null,"FOR MORE INFORMATION:"]
[null,"This spreadsheet was developed as a tool to automatically perform the calculations demonstrated and discussed in Custom Rates and the Total Cost to Own and Operate Farm Machinery in Kansas, which can be found at :"]
[]
[null,"Custom Rates and the Total Cost to Own and Operate Farm Machinery in Kansas"]
[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,"Aaron J. Beaton",null,null,null,null,"Kevin C. Dhuyvetter, Ph.D."]
[null,"Extension Assistant",null,null,null,null,"Former Graduate Research Assistant",null,null,null,null,"Former Agricultural Economist"]
[null,"Kansas State University",null,null,null,null,"Agricultural Economics",null,null,null,null,"Kansas State University"]
[null,"rvl@ksu.edu",null,null,null,null,"Kansas State University"]
[null,"785-532-1504",null,null,null,null,null,null,null,null,null,"Terry L. Kastens, Ph.D."]
[null,null,null,null,null,null,null,null,null,null,null,"Professor Emeritus"]
[null,null,null,null,null,null,null,null,null,null,null,"Kansas State University"]
[]
[null,"Copyright 2016 AgManager.info, K-State Department of Agricultural Economics"]

{"sheet":"User info","index":1,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[13,2,20,11],[22,2,31,11],[2,5,3,11]]}
[]
[]
[null,null,"KSU-Machinery Cost -----",null,null,"An Excel spreadsheet to assist producers in calculating farm specific custom farming rates and benchmarking machinery costs"]
[]
[null,null,{"$f":"Intro!L8","v":"Version- 6.30.16"}]
[]
[null,"  INPUTS, COEFFICIENTS, and CALCULATED VALUES"]
[null,"  In the Calculations sheet, numerical values are color coded for ease of use according to the following:"]
[null,null,"Blue font with light blue shading represents inputs required by the user"]
[null,null,"Green font with light green shading represents model coefficients"]
[null,null,"Black font with light yellow shading represent calculated values based on user input and model coefficients"]
[]
[null,"  INPUT CELLS"]
[null,null,"All blue cells are input cells, the number of harvested acres and actual crop machinery costs must be entered.  The number of units of each operation (Column F) must be entered, if none of a particular operation was perfromed, enter \"0\".  All operations that are performed must be enterered as an operation, otherwise the farms total crop machinery costs will be prorated over too few operations and units, causing incorrect calculations.  If a particular operation is performed that is not listed in Column D, pick the operation that most closely resembles it.  Additionally, all operations performed for others (on a custom farming basis) must be entered (in Column F) as well.  Red diamond comment boxes are included on various inputs to help clarify what should be entered where."]
[]
[]
[]
[]
[]
[]
[]
[null,"  OUPUT CELLS"]
[null,null,"All black cells are output cells (i.e., calculated values).  This spreadsheet automatically recalculates every time an additional input is entered.  Thus, it is important to wait until all data have been entered and reviewed before interpreting any of the calculated results (i.e., black numbers).  Column M represents the farm-specific per unit cost to perform each of the operations for the farm being analyzed.  The relative crop machinery cost coefficient, Part N, represents the aggregate crop machinery costs relative to other producers of the same size, performing similar operations and similar units of each operation.  If the relative crop machinery costs coefficient is less than, equal to, or greater than one, then machinery costs are less than, equal to, or greater than what would be expected, respectively, indicating whether machinery operations are a strength or weakness of the business.  Red diamond comment boxes are included on various cells to help clarify what the output means."]

{"sheet":"Calculations","index":2,"n_rows":66,"n_cols":32,"rows_kept":66,"cut":false,"hidden":false,"merged":[[17,22,18,22],[9,1,9,4],[11,1,11,4],[6,1,6,4],[7,1,7,4],[17,2,17,3],[18,2,18,3],[10,1,10,4],[12,1,12,4],[14,1,14,4],[13,1,13,4],[1,1,1,9],[8,1,8,4],[2,1,2,4],[3,1,3,4],[4,1,4,4],[5,1,5,4]]}
[]
[null,"Estimates of Farm-Specific Per Unit Machinery Costs"]
[null,"A.  Scale Factor Coefficients"]
[null,"       Constant",null,null,null,1.2410000000000001,null,"Coefficient adjustment"]
[null,"       1 / harvested acres",null,null,null,33.026000000000003,null,null,{"$f":"AF17","v":1.5495886020022376}]
[]
[null,"B.  Harvested Acres (required)",null,null,null,0,null,null,"Year"]
[null,null,null,null,null,null,null,null,2016]
[null,"C.  Scale Factor  (Scale factor = 1.241 + 33.026 x (1 / harvested acres))",null,null,null,{"$f":"IF(F7>0,F4+F5*(1/F7),0)","v":0}]
[]
[null,"I.  Step 3 -- Expected whole-farm crop machinery costs (Sum of Column H) ",null,null,null,{"$f":"SUM(G20:G62)","v":0}]
[]
[null,"K.  Step 5 -- Actual whole-farm crop machinery costs (required)",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimates of Coefficient adjustment"]
[]
[null,"N.  Relative crop machinery cost coefficient (K / I)",null,null,null,{"$f":"IF(F11>0,F13/F11,\"-----\")","v":"-----"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total cost",{"$f":"SUMPRODUCT($W20:$W62,X20:X62)","v":75014.465961999987},{"$f":"SUMPRODUCT($W20:$W62,Y20:Y62)","v":90362.226995999983},94769.181434666651,111336.03867599998,111563.76698000001,104721.41383866667,111246.56718066669,113687.36171466665,116241.56143999999]
[null,"D.","       E.",null,"          F.  ","          G.  ","          H.  ","          J.  ","          L.  ","          M.  ",null,"E.",null,null,null,null,null,null,null,null,null,"Coefficient adjustment (relative to 2001)","% of 2001",{"$f":"X16/$X16","v":1},{"$f":"Y16/$X16","v":1.2045973511532388},1.2633454123725121,1.4841942450460073,1.4872300368906815,1.3960162549409512,1.4830015218267469,1.5155391731010543,1.5495886020022376]
[null,null,"Adjusted",null,null,"Step 1","Step 2","Step 4","Step 6","Step 7",null,"Estimated",null,null,null,null,null,null,null,null,null,null,"Mean Units","KAS Custom rates"]
[null,"Operations (required units)","Coefficients",null,"Units","(C × E)","(F × G)","(H / I)","(J × K)","(L / F)",null,"Coefficients",null,null,null,null,null,null,null,null,null,"Operation",null,2001,2006,2007,2008,2009,2010,2011,2012,2013]
[null,"Field cultivate without fertilizer (acres)",{"$f":"L20*I$5","v":8.6002167411124191},null,0,{"$f":"C20*$F$9","v":0},{"$f":"F20*E20","v":0},{"$f":"IF($F$11>0,G20/$F$11,0)","v":0},{"$f":"H20*$F$13","v":0},{"$f":"IF(E20>0,I20/E20,\"n/a\")","v":"n/a"},null,5.55,null,null,null,null,null,null,null,null,null,{"$f":"B20","v":"Field cultivate without fertilizer (acres)"},920.2,5.92,7.37,7.25,8.9499999999999993,8.84,8.2899999999999991,9.1300000000000008,9.3699999999999992,9.48]
[null,"Field cultivate with fertilizer (acres)",9.6694328764939623,null,0,{"$f":"C21*$F$9","v":0},{"$f":"F21*E21","v":0},{"$f":"IF($F$11>0,G21/$F$11,0)","v":0},{"$f":"H21*$F$13","v":0},{"$f":"IF(E21>0,I21/E21,\"n/a\")","v":"n/a"},null,6.24,null,null,null,null,null,null,null,null,null,{"$f":"B21","v":"Field cultivate with fertilizer (acres)"},88.6,{"$f":"X20*X$63","v":6.7132799999999992},8.3575799999999987,8.2214999999999989,10.149299999999998,10.024559999999999,9.400859999999998,10.35342,10.625579999999998,10.75032]
[null,"Sweep/undercut without fertilizer (acres)",8.3522825647920609,null,0,{"$f":"C22*$F$9","v":0},{"$f":"F22*E22","v":0},{"$f":"IF($F$11>0,G22/$F$11,0)","v":0},{"$f":"H22*$F$13","v":0},{"$f":"IF(E22>0,I22/E22,\"n/a\")","v":"n/a"},null,5.39,null,null,null,null,null,null,null,null,null,"Sweep/undercut without fertilizer (acres)",338.5,5.38,6.43,6.66,7.73,7.42,7.05,7.76,7.88,7.93]
[null,"Sweep/undercut with fertilizer (acres)",9.3905069281335596,null,0,{"$f":"C23*$F$9","v":0},{"$f":"F23*E23","v":0},{"$f":"IF($F$11>0,G23/$F$11,0)","v":0},{"$f":"H23*$F$13","v":0},{"$f":"IF(E23>0,I23/E23,\"n/a\")","v":"n/a"},null,6.06,null,null,null,null,null,null,null,null,null,"Sweep/undercut with fertilizer (acres)",68.900000000000006,{"$f":"X22*X$63","v":6.1009199999999995},7.2916199999999991,7.5524399999999998,8.7658199999999997,8.4142799999999998,7.994699999999999,8.7998399999999997,8.9359199999999994,8.9926199999999987]
[null,"Disk (acres)",9.8088958506741637,null,0,0,0,0,0,{"$f":"IF(E24>0,I24/E24,\"n/a\")","v":"n/a"},null,6.33,null,null,null,null,null,null,null,null,null,"Disk (acres)",675.2,6.48,7.79,7.93,9.02,9.06,8.68,9.5,9.75,9.8800000000000008]
[null,"Chisel less than 12 inches deep (acres)",12.210758183777632,null,0,0,0,0,0,"n/a",null,7.88,null,null,null,null,null,null,null,null,null,"Chisel less than 12 inches deep (acres)",155.30000000000001,7.79,9.1,9.75,11.19,10.06,10.18,11.24,11.47,11.58]
[null,"Chisel greater than 12 inches deep (acres)",14.597124630861078,null,0,0,0,0,0,"n/a",null,9.42,null,null,null,null,null,null,null,null,null,"Chisel greater than 12 inches deep (acres)",54,9.5399999999999991,11.88,11.46,15.81,13.7,13.26,15.13,15.44,15.55]
[null,"Disk-chisel/disk deep-chisel (acres)",14.364686340560741,null,0,0,0,0,0,"n/a",null,9.27,null,null,null,null,null,null,null,null,null,"Disk-chisel/disk deep-chisel (acres)",109.5,{"$f":"X26","v":9.5399999999999991},11.88,11.46,15.81,13.7,13.26,15.13,15.44,15.55]
[null,"Moldboard plow (acres)",13.88431387394005,null,0,0,0,0,0,"n/a",null,8.9600000000000009,null,null,null,null,null,null,null,null,null,"Moldboard plow (acres)",38.799999999999997,8.98,11.04,10.64,15.41,14,12.73,14.4,14.57,14.6]
[null,"Row crop cultivate (acres)",9.9173670528143205,null,0,0,0,0,0,"n/a",null,6.4,null,null,null,null,null,null,null,null,null,"Row crop cultivate (acres)",72,6.25,7.09,6.32,8.4600000000000009,7.24,7.76,8.1999999999999993,8.41,8.5299999999999994]
[null,"Drill/air-seed no-till without fertilizer (acres)",15.542373678082441,null,0,0,0,0,0,"n/a",null,10.029999999999999,null,null,null,null,null,null,null,null,null,"Drill/air-seed no-till without fertilizer (acres)",99.2,9.89,11.77,12.1,13.73,13.31,13.71,14.46,15,15.31]
[null,"Drill/air-seed no-till with fertilizer (acres)",17.479359430585237,null,0,{"$f":"C31*$F$9","v":0},{"$f":"F31*E31","v":0},{"$f":"IF($F$11>0,G31/$F$11,0)","v":0},{"$f":"H31*$F$13","v":0},"n/a",null,11.28,null,null,null,null,null,null,null,null,null,"Drill/air-seed no-till with fertilizer (acres)",92.9,{"$f":"X30*X$63","v":11.215259999999999},13.347179999999998,13.721399999999999,15.569819999999998,15.093539999999999,15.547139999999999,16.397639999999999,17.009999999999998,17.361539999999998]
[null,"Drill/air-seed conventional till without fertilizer (acres)",9.1115809797731568,null,0,0,0,0,0,"n/a",null,5.88,null,null,null,null,null,null,null,null,null,"Drill/air-seed conventional till without fertilizer (acres)",279.3,6.49,8.52,9.5399999999999991,11.09,11.14,10.43,11.64,12.08,12.31]
[null,"Drill/air-seed conventional till with fertilizer (acres)",10.242780659234791,null,0,{"$f":"C33*$F$9","v":0},{"$f":"F33*E33","v":0},{"$f":"IF($F$11>0,G33/$F$11,0)","v":0},{"$f":"H33*$F$13","v":0},"n/a",null,6.61,null,null,null,null,null,null,null,null,null,"Drill/air-seed conventional till with fertilizer (acres)",142.4,{"$f":"X32*X$63","v":7.3596599999999999},9.6616799999999987,10.818359999999998,12.576059999999998,12.632759999999999,11.827619999999998,13.199759999999999,13.698719999999998,13.959539999999999]
[null,"Plant no-till without fertilizer (acres)",15.170472413601905,null,0,0,0,0,0,"n/a",null,9.7899999999999991,null,null,null,null,null,null,null,null,null,"Plant no-till without fertilizer (acres)",107.8,{"$f":"(9.56+10+10.5)/3","v":10.020000000000001},{"$f":"(11.26+11.57+12)/3","v":11.61},{"$f":"(12.04+12.09+12.34)/3","v":12.156666666666666},{"$f":"(13.49+13.57+14.07)/3","v":13.71},{"$f":"(13.63+13.7+13.68)/3","v":13.67},{"$f":"(13.6+13.69+14.19)/3","v":13.826666666666666},{"$f":"(14.38+14.44+14.85)/3","v":14.556666666666667},{"$f":"(14.99+15.02+15.46)/3","v":15.156666666666666},{"$f":"(15.35+15.36+15.82)/3","v":15.51}]
[null,"Plant no-till with fertilizer (acres)",17.045474622024614,null,0,{"$f":"C35*$F$9","v":0},{"$f":"F35*E35","v":0},{"$f":"IF($F$11>0,G35/$F$11,0)","v":0},{"$f":"H35*$F$13","v":0},"n/a",null,11,null,null,null,null,null,null,null,null,null,"Plant no-till with fertilizer (acres)",160.80000000000001,{"$f":"X34*X$63","v":11.362680000000001},13.165739999999998,13.785659999999998,15.547139999999999,15.501779999999998,15.679439999999998,16.507259999999999,17.187659999999997,17.588339999999999]
[null,"Plant conventional till without fertilizer (acres)",12.567163562238147,null,0,0,0,0,0,"n/a",null,8.11,null,null,null,null,null,null,null,null,null,"Plant conventional till without fertilizer (acres)",203.1,{"$f":"(7.72+8.19+8.17)/3","v":8.0266666666666655},{"$f":"(9.65+10.3+10.33)/3","v":10.093333333333334},{"$f":"(10.65+10.91+10.94)/3","v":10.833333333333334},{"$f":"(12.3+12.51+12.87)/3","v":12.56},{"$f":"(12.61+12.52+12.58)/3","v":12.57},{"$f":"(11.8+12.25+12.45)/3","v":12.166666666666666},{"$f":"(12.94+13.29+13.58)/3","v":13.269999999999998},{"$f":"(13.45+13.82+14.15)/3","v":13.806666666666667},{"$f":"(13.73+14.12+14.47)/3","v":14.106666666666667}]
[null,"Plant conventional till with fertilizer (acres)",14.116752164240383,null,0,{"$f":"C37*$F$9","v":0},{"$f":"F37*E37","v":0},{"$f":"IF($F$11>0,G37/$F$11,0)","v":0},{"$f":"H37*$F$13","v":0},"n/a",null,9.11,null,null,null,null,null,null,null,null,null,"Plant conventional till with fertilizer (acres)",84.1,{"$f":"X36*X$63","v":9.1022399999999983},11.445839999999999,12.285,14.243039999999999,14.254379999999999,13.796999999999999,15.048179999999997,15.656759999999998,15.99696]
[null,"Spray chemical (acres)",5.6250066252681226,null,0,0,0,0,0,"n/a",null,3.63,null,null,null,null,null,null,null,null,null,"Spray chemical (acres)",1083.8,{"$f":"(3.72+3.77)/2","v":3.7450000000000001},{"$f":"(4.4+4.51)/2","v":4.4550000000000001},{"$f":"(4.5+4.49)/2","v":4.4950000000000001},{"$f":"(5.01+5.07)/2","v":5.04},{"$f":"(4.98+4.95)/2","v":4.9649999999999999},{"$f":"(4.9+4.97)/2","v":4.9350000000000005},{"$f":"(5.24+5.3)/2","v":5.27},{"$f":"(5.38+5.44)/2","v":5.41},{"$f":"(5.45+5.52)/2","v":5.4849999999999994}]
[null,"Spray fertilizer (acres)",5.7799654854683462,null,0,0,0,0,0,"n/a",null,3.73,null,null,null,null,null,null,null,null,null,"Spray fertilizer (acres)",78.2,{"$f":"X38","v":3.7450000000000001},4.4550000000000001,4.4950000000000001,5.04,4.9649999999999999,4.9350000000000005,5.27,5.41,5.4849999999999994]
[null,"Spray chemical and fertilizer (acres)",5.7954613714883685,null,0,0,0,0,0,"n/a",null,3.74,null,null,null,null,null,null,null,null,null,"Spray chemical and fertilizer (acres)",287.3,{"$f":"X38","v":3.7450000000000001},4.4550000000000001,4.4950000000000001,5.04,4.9649999999999999,4.9350000000000005,5.27,5.41,5.4849999999999994]
[null,"Anhydrous ammonia application (acres)",8.5227373110123068,null,0,0,0,0,0,"n/a",null,5.5,null,null,null,null,null,null,null,null,null,"Anhydrous ammonia application (acres)",206.4,5.61,6.75,8.4600000000000009,10.199999999999999,10.55,9.19,10.32,10.68,10.87]
[null,"Broadcast dry fertilizer (acres)",5.2840971328276307,null,0,0,0,0,0,"n/a",null,3.41,null,null,null,null,null,null,null,null,null,"Broadcast dry fertilizer (acres)",288.7,3.53,4.1500000000000004,4.2,4.96,4.68,4.75,5.0999999999999996,5.26,5.34]
[null,"Inject liquid fertilizer (acres)",5.4390559930278535,null,0,0,0,0,0,"n/a",null,3.51,null,null,null,null,null,null,null,null,null,"Inject liquid fertilizer (acres)",62.3,3.57,4.42,4.37,4.9800000000000004,4.82,4.84,5.21,5.35,5.42]
[null,"Harvest wheat (acres)",21.136388531310523,null,0,0,0,0,0,"n/a",null,{"$f":"IF(W48>=0,13.64,(13.64+3.47))","v":13.64},null,null,null,null,null,null,null,null,null,"Harvest wheat (acres)",462.8,13.77,15.78,16.850000000000001,21.65,20.86,18.25,20.47,20.69,20.74]
[null,"Wheat yield above 20 bu/ac (bushels)",0.20144651826029089,null,0,0,0,0,0,"n/a",null,0.13,null,null,null,null,null,null,null,null,null,"Wheat yield above 20 bu/ac (bushels)",{"$f":"W44*(45-21)","v":11107.2},0.13100000000000001,0.14899999999999999,0.16,0.21099999999999999,0.2,0.17599999999999999,0.19700000000000001,0.2,0.20100000000000001]
[null,"Harvest corn (acres)",31.115739128204929,null,0,0,0,0,0,"n/a",null,{"$f":"IF(W52>=0,20.08,(20.08+7.88))","v":20.079999999999998},null,null,null,null,null,null,null,null,null,"Harvest corn (acres)",180,19.43,21.75,22.14,26.51,26.35,23.92,25.93,26.18,26.26]
[null,"Corn yield above 48 bu/ac (bushels)",0.19524816385228194,null,0,0,0,0,0,"n/a",null,0.126,null,null,null,null,null,null,null,null,null,"Corn yield above 48 bu/ac (bushels)",{"$f":"W46*(125-74)","v":9180},0.11899999999999999,0.15,0.16400000000000001,0.20300000000000001,0.192,0.183,0.19800000000000001,0.20300000000000001,0.20599999999999999]
[null,"Harvest grain sorghum (acres)",21.911182832311642,null,0,0,0,0,0,"n/a",null,{"$f":"IF(W54>=0,14.14,(14.14+4.77))","v":14.14},null,null,null,null,null,null,null,null,null,"Harvest grain sorghum (acres)",230.9,14.58,16.64,17.45,22.99,22.37,19.21,21.5,21.68,21.7]
[null,"Grain sorghum yield above 35 bu/ac (bushels)",0.1983473410562864,null,0,0,0,0,0,"n/a",null,0.128,null,null,null,null,null,null,null,null,null,"Grain sorghum yield above 35 bu/ac (bushels)",{"$f":"W48*(80-36)","v":10159.6},0.129,0.14799999999999999,0.159,0.216,0.20399999999999999,0.17799999999999999,0.20100000000000001,0.20399999999999999,0.20499999999999999]
[null,"Harvest soybeans (acres)",29.426687552022489,null,0,0,0,0,0,"n/a",null,{"$f":"IF(W56>=0,18.99,(18.99+1.41))","v":18.989999999999998},null,null,null,null,null,null,null,null,null,"Harvest soybeans (acres)",234.3,19.48,21.88,22.61,26.47,25.66,23.89,25.99,26.25,26.32]
[null,"Soybean yield above 24 bu/ac (bushels)",0.19679775245428419,null,0,0,0,0,0,"n/a",null,0.127,null,null,null,null,null,null,null,null,null,"Soybean yield above 24 bu/ac (bushels)",{"$f":"W50*(35-27)","v":1874.4},0.127,0.17199999999999999,0.158,0.20599999999999999,0.19800000000000001,0.17399999999999999,0.19900000000000001,0.20100000000000001,0.20100000000000001]
[null,"Harvest sunflowers (acres)",27.877098950020251,null,0,0,0,0,0,"n/a",null,17.989999999999998,null,null,null,null,null,null,null,null,null,"Harvest sunflowers (acres)",13.6,17.93,19.55,20.88,26.28,26.26,23.54,25.36,25.85,26.08]
[null,"Swath (acres)",12.954560712738706,null,0,0,0,0,0,"n/a",null,8.36,null,null,null,null,null,null,null,null,null,"Swath (acres)",238.1,8.1999999999999993,9.65,10.27,11.49,11.52,10.81,11.73,11.97,12.09]
[null,"Rake hay (acres)",4.5402946038665561,null,0,0,0,0,0,"n/a",null,2.93,null,null,null,null,null,null,null,null,null,"Rake hay (acres)",164.7,2.88,3.4,3.54,4.21,3.82,3.71,4.1100000000000003,4.16,4.18]
[null,"Round bales less than 1,500 lbs (bales)",11.40497211073647,null,0,0,0,0,0,"n/a",null,7.36,null,null,null,null,null,null,null,null,null,"Round bales less than 1,500 lbs (bales)",166.7,7.19,8.59,9.3000000000000007,9.83,10.45,9.66,10.31,10.55,10.69]
[null,"Round bales greater than 1,500 lbs (bales)",12.381212929997879,null,0,0,0,0,0,"n/a",null,7.99,null,null,null,null,null,null,null,null,null,"Round bales greater than 1,500 lbs (bales)",132.19999999999999,7.64,8.85,9.11,11.52,10.56,9.89,10.91,11.06,11.1]
[null,"Large square bales (bales)",18.71903031218703,null,0,0,0,0,0,"n/a",null,12.08,null,null,null,null,null,null,null,null,null,"Large square bales (bales)",55,11.7,12.9,13.07,14.76,13.58,13.14,14.17,14.12,14.04]
[null,"Small square bales (bales)",0.82593072486719266,null,0,0,0,0,0,"n/a",null,0.53300000000000003,null,null,null,null,null,null,null,null,null,{"$f":"B58","v":"Small square bales (bales)"},432.8,0.49,0.67,0.71,0.81,0.92,0.83,0.89,0.93,0.95]
[null,"Chop silage (no hauling or ensiling) tons",4.7572370081468689,null,0,0,0,0,0,"n/a",null,3.07,null,null,null,null,null,null,null,null,null,"Chop silage (no hauling or ensiling) tons",273.2,3.09,4.03,4.17,5.61,4.68,4.68,5.25,5.36,5.41]
[null,"Rotary mow (acres)",12.133278753677521,null,0,0,0,0,0,"n/a",null,7.83,null,null,null,null,null,null,null,null,null,"Rotary mow (acres)",39.9,7.9,10.35,10.44,12.85,12,11.37,12.99,13.28,13.39]
[null,"Miles on farm pickups (miles)",0.52066177027275184,null,0,0,0,0,0,"n/a",null,0.33600000000000002,null,null,null,null,null,null,null,null,null,"Miles on farm pickups (miles)",16295.1,0.34499999999999997,0.44500000000000001,0.48499999999999999,0.505,0.58499999999999996,0.55000000000000004,0.5,0.51,0.55500000000000005]
[null,"Miles on grain/hay trucks (miles)",2.7892594836040279,null,0,0,0,0,0,"n/a",null,1.8,null,null,null,null,null,null,null,null,null,"Miles on grain/hay trucks (miles)",3072.8,2.0699999999999998,{"$f":"Y61/X61*X62","v":2.6700000000000004},2.9100000000000006,3.0300000000000007,3.5100000000000007,3.3000000000000012,3.0000000000000009,3.0600000000000009,{"$f":"AF61/Z61*Z62","v":3.330000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fertilizer operation =>",1.1339999999999999,1.1339999999999999,1.1339999999999999,1.1339999999999999,1.1339999999999999,1.1339999999999999,1.1339999999999999,1.1339999999999999,1.1339999999999999]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mileage rates from"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://www.owcc.state.ok.us/PDF/Mileage%20Rate%20History%20Chart.pdf"]

{"sheet":"Blank form","index":3,"n_rows":64,"n_cols":10,"rows_kept":64,"cut":false,"hidden":false,"merged":[[5,1,5,4],[13,1,13,4],[14,1,14,4],[1,1,1,9],[63,1,65,9],[17,2,17,3],[18,2,18,3],[6,1,6,4],[7,1,7,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[2,1,2,4],[3,1,3,4],[4,1,4,4]]}
[]
[null,"Estimates of Farm-Specific Per Unit Machinery Costs -- Worksheet"]
[null,"A.  Scale Factor Coefficients"]
[null,"       Constant",null,null,null,1.2410000000000001]
[null,"       1 / harvested acres",null,null,null,33.026000000000003]
[]
[null,"B.  Harvested Acres"]
[]
[null,"C.  Scale Factor  (Scale factor = 1.241 + 33.026 x (1 / harvested acres))"]
[]
[null,"I.  Step 3 - Expected whole-farm crop machinery costs (Sum of Column H) "]
[]
[null,"K.  Step 5 - Actual whole-farm crop machinery costs"]
[]
[null,"N.  Relative crop machinery cost coefficient (K / I)"]
[]
[null,"D.","       E.",null,"F.  ","G.  ","H.  ","J.  ","L.  ","M.  "]
[null,null,"Estimated",null,null,"Step 1","Step 2","Step 4","Step 6","Step 7"]
[null,"Operations (required units)","Coefficients",null,"Units*","(C × E)","(F × G)","(H / I)","(J × K)","(L / F)"]
[null,"Field cultivate without fertilizer (acres)",{"$f":"Calculations!C20","v":8.6002167411124191}]
[null,"Field cultivate with fertilizer (acres)",{"$f":"Calculations!C21","v":9.6694328764939623}]
[null,"Sweep/undercut without fertilizer (acres)",{"$f":"Calculations!C22","v":8.3522825647920609}]
[null,"Sweep/undercut with fertilizer (acres)",{"$f":"Calculations!C23","v":9.3905069281335596}]
[null,"Disk (acres)",{"$f":"Calculations!C24","v":9.8088958506741637}]
[null,"Chisel less than 12 inches deep (acres)",{"$f":"Calculations!C25","v":12.210758183777632}]
[null,"Chisel greater than 12 inches deep (acres)",{"$f":"Calculations!C26","v":14.597124630861078}]
[null,"Disk-chisel/disk deep-chisel (acres)",{"$f":"Calculations!C27","v":14.364686340560741}]
[null,"Moldboard plow (acres)",{"$f":"Calculations!C28","v":13.88431387394005}]
[null,"Row crop cultivate (acres)",{"$f":"Calculations!C29","v":9.9173670528143205}]
[null,"Drill/air-seed no-till without fertilizer (acres)",{"$f":"Calculations!C30","v":15.542373678082441}]
[null,"Drill/air-seed no-till with fertilizer (acres)",{"$f":"Calculations!C31","v":17.479359430585237}]
[null,"Drill/air-seed conventional till without fertilizer (acres)",{"$f":"Calculations!C32","v":9.1115809797731568}]
[null,"Drill/air-seed conventional till with fertilizer (acres)",{"$f":"Calculations!C33","v":10.242780659234791}]
[null,"Plant no-till without fertilizer (acres)",{"$f":"Calculations!C34","v":15.170472413601905}]
[null,"Plant no-till with fertilizer (acres)",{"$f":"Calculations!C35","v":17.045474622024614}]
[null,"Plant conventional till without fertilizer (acres)",{"$f":"Calculations!C36","v":12.567163562238147}]
[null,"Plant conventional till with fertilizer (acres)",{"$f":"Calculations!C37","v":14.116752164240383}]
[null,"Spray chemical (acres)",{"$f":"Calculations!C38","v":5.6250066252681226}]
[null,"Spray fertilizer (acres)",{"$f":"Calculations!C39","v":5.7799654854683462}]
[null,"Spray chemical and fertilizer (acres)",{"$f":"Calculations!C40","v":5.7954613714883685}]
[null,"Anhydrous ammonia application (acres)",{"$f":"Calculations!C41","v":8.5227373110123068}]
[null,"Broadcast dry fertilizer (acres)",{"$f":"Calculations!C42","v":5.2840971328276307}]
[null,"Inject liquid fertilizer (acres)",{"$f":"Calculations!C43","v":5.4390559930278535}]
[null,"Harvest wheat (acres)",{"$f":"Calculations!C44","v":21.136388531310523}]
[null,"   Wheat yield above 20 bu/ac (bushels)",{"$f":"Calculations!C45","v":0.20144651826029089}]
[null,"Harvest corn (acres)",{"$f":"Calculations!C46","v":31.115739128204929}]
[null,"   Corn yield above 48 bu/ac (bushels)",{"$f":"Calculations!C47","v":0.19524816385228194}]
[null,"Harvest grain sorghum (acres)",{"$f":"Calculations!C48","v":21.911182832311642}]
[null,"   Grain sorghum yield above 35 bu/ac (bushels)",{"$f":"Calculations!C49","v":0.1983473410562864}]
[null,"Harvest soybeans (acres)",{"$f":"Calculations!C50","v":29.426687552022489}]
[null,"   Soybean yield above 24 bu/ac (bushels)",{"$f":"Calculations!C51","v":0.19679775245428419}]
[null,"Harvest sunflowers (acres)",{"$f":"Calculations!C52","v":27.877098950020251}]
[null,"Swath (acres)",{"$f":"Calculations!C53","v":12.954560712738706}]
[null,"Rake hay (acres)",{"$f":"Calculations!C54","v":4.5402946038665561}]
[null,"Round bales less than 1,500 lbs (bales)",{"$f":"Calculations!C55","v":11.40497211073647}]
[null,"Round bales greater than 1,500 lbs (bales)",{"$f":"Calculations!C56","v":12.381212929997879}]
[null,"Large square bales (bales)",{"$f":"Calculations!C57","v":18.71903031218703}]
[null,"Small square bales (bales)",{"$f":"Calculations!C58","v":0.82593072486719266}]
[null,"Chop silage (no hauling or ensiling) tons",{"$f":"Calculations!C59","v":4.7572370081468689}]
[null,"Rotary mow (acres)",{"$f":"Calculations!C60","v":12.133278753677521}]
[null,"Miles on farm pickups (miles)",{"$f":"Calculations!C61","v":0.52066177027275184}]
[null,"Miles on grain/hay trucks (miles)",{"$f":"Calculations!C62","v":2.7892594836040279}]
[]
[null,"* Units entered must match the \"required units\" listed in Column D.  All operations that were performed (either for yourself or for others, with or without compensation)  must be entered in this column, or the farm's \"Actual whole farm machinery costs\" in Part K will be prorated over too few operations and units, resulting in incorrection calcuations. "]