{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Example","Blank","MachComp","Data"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Example","index":0,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,2,49,8],[47,2,48,8],[2,2,2,6],[4,2,4,3],[23,3,23,4],[23,7,23,8],[7,3,7,4],[23,5,23,6],[24,7,26,8]]}
[null,null,"Machinery Cost Calculator"]
[null,null,"Ag Decision Maker -- Iowa State University Extension"]
[null,null,"For more Information, see Information File A3-29 Estimating Farm Machinery Costs."]
[]
[null,null,"Place the cursor over cells with red triangles to read comments."]
[null,null,"This example shows how you must enter the annual use and field capacity for a self-propelled implement."]
[]
[null,null,"Input Data","Power Unit",1,"Implement or Attachment"]
[]
[null,null,"Type of machine",5,null,1]
[null,null,"Current list price of comparable machine (new)",375000]
[null,null,"Current value of machine",300000]
[null,null,"Accumulated hours of use",500,"hours"]
[null,null,"Current age",2,"years",null,"years"]
[null,null,"Years of ownership remaining",8,"years",null,"years"]
[null,null,"Interest rate",7.0000000000000007E-2,"%",null,"%"]
[null,null,"Annual use ",250,"hours",2500,"acres or tons"]
[null,null,"Field capacity in acres or tons per hour",null,null,13,"/hour"]
[null,null,"Engine horsepower",300,"hp"]
[null,null,"Price of diesel fuel",2,"/gal."]
[null,null,"Wage or labor value for machine operator",20,"/hour"]
[null,null,"Annual repair and maintenance costs"]
[null,null,"(leave blank to use calculator estimate)"]
[null,null,null,"Power Unit Alone",null,"Implement or Attachment",null,"Combination"]
[null,null,null,{"$f":"IF(D14>0,D11*((VLOOKUP(D10,Data!C5:J14,6)-VLOOKUP(D10,Data!C5:J14,7)*((D14)^0.5)-VLOOKUP(D10,Data!C5:J14,8)*(((D13)/(D14))^0.5))^2),D12)","v":224799.75256560254},null,{"$f":"IF(F14>0,F11*((VLOOKUP(F10,Data!C16:J44,6)-VLOOKUP(F10,Data!C16:J44,7)*((F14)^0.5)-VLOOKUP(F10,Data!C16:J44,8)*(((F17)/(F18))^0.5))^2),F12)","v":0},null,"Includes power unit costs only for the hours used with this implement or attachment."]
[null,null,"Estimated value at end of the ownership period",{"$f":"IF(D15>0,D11*((VLOOKUP(D10,Data!C5:J14,6)-VLOOKUP(D10,Data!C5:J14,7)*((D14+D15)^0.5)-VLOOKUP(D10,Data!C5:J14,8)*(((D13+D17*D15)/(D14+D15))^0.5))^2),0)*IF(D25>0,D12/D25,1)","v":118541.68617017008},null,{"$f":"IF(F$18>0,F$11*((VLOOKUP(F$10,Data!C$16:J$44,6)-VLOOKUP(F$10,Data!C$16:J$44,7)*((F$15+F$14)^0.5)-VLOOKUP(F$10,Data!C$16:J$44,8)*((F$17/F$18)^0.5))^2),0)*IF(F25>0,F12/F25,1)","v":0}]
[]
[null,null,"Ownership Costs","$/year","$/acre","$/year","$/acre","$/year","$/acre"]
[null,null,"Capital recovery (interest and depreciation)",{"$f":"IF(D15>0,PMT(D16,D15,-(D12-D26))+D16*D26,D15)","v":38686.335834338686},{"$f":"IF(D17*F18>0,D29/D$17/F$18,0)","v":11.903487949027287},{"$f":"IF(F15,PMT(F16,F15,-(F12-F26))+F16*F26,0)","v":0},{"$f":"IF(F$17>0,F29/F17,0)","v":0},{"$f":"IF(F$18*D$17>0,D29*(F$17/F$18)/D$17+F29,0)","v":29758.719872568225},{"$f":"E29+G29","v":11.903487949027287}]
[null,null,"Taxes, insurance and housing",{"$f":"0.01*D12","v":3000},{"$f":"IF(D17*F18>0,D30/D$17/F$18,0)","v":0.92307692307692313},{"$f":"0.01*F12","v":0},{"$f":"IF(F$17>0,F30/F17,0)","v":0},{"$f":"IF(F$18*D$17>0,D30*(F$17/F$18)/D$17+F30,0)","v":2307.6923076923081},{"$f":"E30+G30","v":0.92307692307692313}]
[null,null,"Total ownership cost",{"$f":"SUM(D29:D30)","v":41686.335834338686},{"$f":"SUM(E29:E30)","v":12.82656487210421},{"$f":"SUM(F29:F30)","v":0},{"$f":"SUM(G29:G30)","v":0},{"$f":"SUM(H29:H30)","v":32066.412180260533},{"$f":"E31+G31","v":12.82656487210421}]
[]
[null,null,"Operating Costs"]
[null,null,"Repair cost ",{"$f":"IF(D22>0,D22,IF(D15>0,MIN(D11*VLOOKUP($D10,Data!$C5:$J14,3)*((((VLOOKUP($D10,Data!$C5:$J14,5)*0.001)^VLOOKUP($D10,Data!$C5:$J14,4))-((VLOOKUP($D10,Data!$C5:$J14,5)-D17)*0.001)^VLOOKUP($D10,Data!$C5:$J14,4))),D11*VLOOKUP($D10,Data!$C5:$J14,3)*((((D13+D15*D17)*0.001)^VLOOKUP($D10,Data!$C5:$J14,4))-((D13*0.001)^VLOOKUP($D10,Data!$C4:$J14,4)))/D15),0))","v":3101.4753126672222},{"$f":"IF(D$17*F$18>0,D34/D$17/F$18,0)","v":0.9543000962052991},{"$f":"IF(F22>0,F22,IF(F15*F18>0,MIN(F11*VLOOKUP($F10,Data!$C16:$J44,3)*((((VLOOKUP($F10,Data!$C16:$J44,5)*0.001)^VLOOKUP($F10,Data!$C16:$J44,4))-((VLOOKUP($F10,Data!$C16:$J44,5)-F17/F18)*0.001)^VLOOKUP($F10,Data!$C16:$J44,4))),F11*VLOOKUP($F10,Data!$C16:$J44,3)*(((((F14+F15)*(F17/F18))*0.001)^VLOOKUP($F10,Data!$C16:$J44,4))-(((F14*F17/F18)*0.001)^VLOOKUP($F10,Data!$C16:$J44,4)))/F15),0))","v":0},{"$f":"IF(F$17>0,F34/F17,0)","v":0},{"$f":"IF(F$18*D$17>0,D34*(F$17/F$18)/D$17+F34,0)","v":2385.7502405132477},{"$f":"E34+G34","v":0.9543000962052991}]
[null,null,"Fuel and lubrication cost",{"$f":"0.044*D19*D20*1.15*D17","v":7589.9999999999991},{"$f":"IF(D$17*F$18>0,D35/D$17/F$18,0)","v":2.3353846153846152},null,null,{"$f":"IF(F$18*D$17>0,D35*(F$17/F$18)/D$17+F35,0)","v":5838.4615384615381},{"$f":"E35+G35","v":2.3353846153846152}]
[null,null,"Labor cost ",{"$f":"1.1*D21*D17","v":5500},{"$f":"IF(D$17*F$18>0,D36/D$17/F$18,0)","v":1.6923076923076923},null,null,{"$f":"IF(F$18*D$17>0,D36*(F$17/F$18)/D$17+F36,0)","v":4230.7692307692314},{"$f":"E36+G36","v":1.6923076923076923}]
[null,null,"Total operating cost ",{"$f":"SUM(D34:D36)","v":16191.475312667222},{"$f":"SUM(E34:E36)","v":4.9819924038976069},{"$f":"SUM(F34:F36)","v":0},{"$f":"SUM(G34:G36)","v":0},{"$f":"SUM(H34:H36)","v":12454.981009744017},{"$f":"E37+G37","v":4.9819924038976069}]
[]
[null,null,"Total Ownership plus Operating Costs",{"$f":"D31+D37","v":57877.811147005908},17.808557276001817,0,0,44521.39319000455,17.808557276001817]
[]
[]
[null,null,"Version 1.2"]
[null,null,"Author: William Edwards"]
[null,null,"Date Printed:"]
[null,null,{"$f":"TODAY()","v":"2009-04-22"}]
[null,null," "]
[null,null,". . . and justice for all"]
[null,null,"The U.S. Department of Agriculture (USDA) prohibits discrimination in all its programs and activities on the basis of race, color, national origin, gender, religion, age, disability, political beliefs, sexual orientation, and marital or family status. (Not all prohibited bases apply to all programs.) Many materials can be made available in alternative formats for ADA clients. To file a complaint of discrimination, write USDA, Office of Civil Rights, Room 326-W, Whitten Building, 14th and Independence Avenue, SW, Washington, DC 20250-9410 or call 202-720-5964."]
[]
[null,null,"Issued in furtherance of Cooperative Extension work, Acts of May 8 and June 30, 1914, in cooperation with the U.S. Department of Agriculture. Jack M. Payne, director, Cooperative Extension Service, Iowa State University of Science and Technology, Ames, Iowa."]

{"sheet":"Blank","index":1,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[50,2,50,8],[48,2,49,8],[2,2,2,6],[4,2,4,3],[24,3,24,4],[24,7,24,8],[8,3,8,4],[24,5,24,6],[25,7,27,8]]}
[null,null,"Machinery Cost Calculator"]
[null,null,"Ag Decision Maker -- Iowa State University Extension (with additional features written by Leroy Stodick.)"]
[null,null,"For more Information, see Information File A3-29 Estimating Farm Machinery Costs."]
[]
[null,null,"Place the cursor over cells with red triangles to read comments."]
[null,null,"Enter your input values in shaded cells."]
[null,null,"If you click Add Operation, your output will be saved in the MachComp tab. This way you can save data for many machines."]
[]
[null,null,"Input Data","Power Unit",1,"Implement or Attachment"]
[]
[null,null,"Type of machine",5,null,7]
[null,null,"Current list price of comparable machine (new)",160000]
[null,null,"Current value of machine",125000]
[null,null,"Accumulated hours of use",2500,"hours"]
[null,null,"Current age",4,"years",null,"years"]
[null,null,"Years of ownership remaining",15,"years",null,"years"]
[null,null,"Interest rate",7.0000000000000007E-2,"%",null,"%"]
[null,null,"Annual use ",600,"hours",2000,"acres or tons"]
[null,null,"Field capacity in acres or tons per hour",null,null,10,"/hour"]
[null,null,"Engine horsepower",400,"hp"]
[null,null,"Price of diesel fuel",3,"/gal."]
[null,null,"Wage or labor value for machine operator",15,"/hour"]
[null,null,"Annual repair and maintenance costs"]
[null,null,"(leave blank to use calculator estimate)"]
[null,null,null,"Power Unit Alone",null,"Implement or Attachment",null,"Combination"]
[null,null,null,{"$f":"IF(D15>0,D12*((VLOOKUP(D11,Data!C5:J14,6)-VLOOKUP(D11,Data!C5:J14,7)*((D15)^0.5)-VLOOKUP(D11,Data!C5:J14,8)*(((D14)/(D15))^0.5))^2),D13)","v":58622.094399999994},null,{"$f":"IF(F15>0,F12*((VLOOKUP(F11,Data!C16:J44,6)-VLOOKUP(F11,Data!C16:J44,7)*((F15)^0.5)-VLOOKUP(F11,Data!C16:J44,8)*(((F18)/(F19))^0.5))^2),F13)","v":0},null,"Includes power unit costs only for the hours used with this implement or attachment."]
[null,null,"Estimated value at end of the ownership period",{"$f":"IF(D16>0,D12*((VLOOKUP(D11,Data!C5:J14,6)-VLOOKUP(D11,Data!C5:J14,7)*((D15+D16)^0.5)-VLOOKUP(D11,Data!C5:J14,8)*(((D14+D18*D16)/(D15+D16))^0.5))^2),0)*IF(D26>0,D13/D26,1)","v":16573.331538666407},null,{"$f":"IF(F$19>0,F$12*((VLOOKUP(F$11,Data!C$16:J$44,6)-VLOOKUP(F$11,Data!C$16:J$44,7)*((F$16+F$15)^0.5)-VLOOKUP(F$11,Data!C$16:J$44,8)*((F$18/F$19)^0.5))^2),0)*IF(F26>0,F13/F26,1)","v":0}]
[]
[null,null,"Ownership Costs","$/year","$/acre","$/year","$/acre","$/year","$/acre"]
[null,null,"Capital recovery (interest and depreciation)",{"$f":"IF(D16>0,PMT(D17,D16,-(D13-D27))+D17*D27,D16)","v":13064.798578999233},{"$f":"IF(D18*F19>0,D30/D$18/F$19,0)","v":2.1774664298332054},{"$f":"IF(F16,PMT(F17,F16,-(F13-F27))+F17*F27,0)","v":0},{"$f":"IF(F$18>0,F30/F18,0)","v":0},{"$f":"IF(F$19*D$18>0,D30*(F$18/F$19)/D$18+F30,0)","v":4354.9328596664109},{"$f":"E30+G30","v":2.1774664298332054}]
[null,null,"Taxes, insurance and housing",{"$f":"0.01*D13","v":1250},{"$f":"IF(D18*F19>0,D31/D$18/F$19,0)","v":0.20833333333333334},{"$f":"0.01*F13","v":0},{"$f":"IF(F$18>0,F31/F18,0)","v":0},{"$f":"IF(F$19*D$18>0,D31*(F$18/F$19)/D$18+F31,0)","v":416.66666666666669},{"$f":"E31+G31","v":0.20833333333333334}]
[null,null,"Total ownership cost",{"$f":"SUM(D30:D31)","v":14314.798578999233},{"$f":"SUM(E30:E31)","v":2.3857997631665389},{"$f":"SUM(F30:F31)","v":0},{"$f":"SUM(G30:G31)","v":0},{"$f":"SUM(H30:H31)","v":4771.5995263330778},{"$f":"E32+G32","v":2.3857997631665389}]
[]
[null,null,"Operating Costs"]
[null,null,"Repair cost ",{"$f":"IF(D23>0,D23,IF(D16>0,MIN(D12*VLOOKUP($D11,Data!$C5:$J14,3)*((((VLOOKUP($D11,Data!$C5:$J14,5)*0.001)^VLOOKUP($D11,Data!$C5:$J14,4))-((VLOOKUP($D11,Data!$C5:$J14,5)-D18)*0.001)^VLOOKUP($D11,Data!$C5:$J14,4))),D12*VLOOKUP($D11,Data!$C5:$J14,3)*((((D14+D16*D18)*0.001)^VLOOKUP($D11,Data!$C5:$J14,4))-((D14*0.001)^VLOOKUP($D11,Data!$C4:$J14,4)))/D16),0))","v":6012.9702955936918},{"$f":"IF(D$18*F$19>0,D35/D$18/F$19,0)","v":1.002161715932282},{"$f":"IF(F23>0,F23,IF(F16*F19>0,MIN(F12*VLOOKUP($F11,Data!$C16:$J44,3)*((((VLOOKUP($F11,Data!$C16:$J44,5)*0.001)^VLOOKUP($F11,Data!$C16:$J44,4))-((VLOOKUP($F11,Data!$C16:$J44,5)-F18/F19)*0.001)^VLOOKUP($F11,Data!$C16:$J44,4))),F12*VLOOKUP($F11,Data!$C16:$J44,3)*(((((F15+F16)*(F18/F19))*0.001)^VLOOKUP($F11,Data!$C16:$J44,4))-(((F15*F18/F19)*0.001)^VLOOKUP($F11,Data!$C16:$J44,4)))/F16),0))","v":0},{"$f":"IF(F$18>0,F35/F18,0)","v":0},{"$f":"IF(F$19*D$18>0,D35*(F$18/F$19)/D$18+F35,0)","v":2004.3234318645641},{"$f":"E35+G35","v":1.002161715932282}]
[null,null,"Fuel and lubrication cost",{"$f":"0.044*D20*D21*1.15*D18","v":36431.999999999993},{"$f":"IF(D$18*F$19>0,D36/D$18/F$19,0)","v":6.0719999999999983},null,null,{"$f":"IF(F$19*D$18>0,D36*(F$18/F$19)/D$18+F36,0)","v":12143.999999999996},{"$f":"E36+G36","v":6.0719999999999983}]
[null,null,"Labor cost ",{"$f":"1.1*D22*D18","v":9900},{"$f":"IF(D$18*F$19>0,D37/D$18/F$19,0)","v":1.65},null,null,{"$f":"IF(F$19*D$18>0,D37*(F$18/F$19)/D$18+F37,0)","v":3300},{"$f":"E37+G37","v":1.65}]
[null,null,"Total operating cost ",{"$f":"SUM(D35:D37)","v":52344.970295593681},{"$f":"SUM(E35:E37)","v":8.7241617159322811},{"$f":"SUM(F35:F37)","v":0},{"$f":"SUM(G35:G37)","v":0},{"$f":"SUM(H35:H37)","v":17448.323431864563},{"$f":"E38+Blank!G38","v":8.7241617159322811}]
[]
[null,null,"Total Ownership plus Operating Costs",{"$f":"D32+D38","v":66659.768874592919},11.109961479098819,0,0,22219.92295819764,11.109961479098819,null,{"$f":"5280*8.25","v":43560}]
[]
[]
[null,null,"Version 1.2"]
[null,null,"Author: William Edwards"]
[null,null,"Date Printed:"]
[null,null,{"$f":"TODAY()","v":"2009-04-22"}]
[null,null," "]
[null,null,". . . and justice for all"]
[null,null,"The U.S. Department of Agriculture (USDA) prohibits discrimination in all its programs and activities on the basis of race, color, national origin, gender, religion, age, disability, political beliefs, sexual orientation, and marital or family status. (Not all prohibited bases apply to all programs.) Many materials can be made available in alternative formats for ADA clients. To file a complaint of discrimination, write USDA, Office of Civil Rights, Room 326-W, Whitten Building, 14th and Independence Avenue, SW, Washington, DC 20250-9410 or call 202-720-5964."]
[]
[null,null,"Issued in furtherance of Cooperative Extension work, Acts of May 8 and June 30, 1914, in cooperation with the U.S. Department of Agriculture. Jack M. Payne, director, Cooperative Extension Service, Iowa State University of Science and Technology, Ames, Iowa."]

{"sheet":"MachComp","index":2,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Machinery Complement"]
[]
["Totals",null,null,{"$f":"Table1[[#Totals],[Repair]]","v":4.2482296282220293},{"$f":"Table1[[#Totals],[Fuel & Lube]]","v":14.167999999999996},{"$f":"Table1[[#Totals],[Labor]]","v":3.85},{"$f":"Table1[[#Totals],[Capital Recovery]]","v":5.9403305337555832},{"$f":"Table1[[#Totals],[THI]]","v":0.63603614859237056}]
[]
[null,"Power Unit","Implement","Repair","Fuel & Lube","Labor","Capital Recovery","THI"]
[null,null,null,1.002161715932282,6.0719999999999983,1.65,2.1774664298332054,0.20833333333333334]
[null,"Tractor 80-150 hp, 2wd","Roller, mulcher",1.4520627492373364,4.0479999999999992,1.1000000000000001,1.9233061159810148,0.2138514076295186]
[null,"Tractor, 4-wheel drive","Moldboard plow",1.7940051630524112,4.0479999999999992,1.1000000000000001,1.8395579879413635,0.2138514076295186]
[null,"Total",null,{"$f":"SUBTOTAL(109,[Repair])","v":4.2482296282220293},{"$f":"SUBTOTAL(109,[Fuel & Lube])","v":14.167999999999996},{"$f":"SUBTOTAL(109,[Labor])","v":3.85},{"$f":"SUBTOTAL(109,[Capital Recovery])","v":5.9403305337555832},{"$f":"SUBTOTAL(109,[THI])","v":0.63603614859237056}]

{"sheet":"Data","index":3,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[[2,4,2,5],[2,7,2,9]]}
[null,null,"Machinery Type Numbers and Constant Values"]
[null,null,null,null,null,null,"Wearout"]
[null,null,null,null,"Repair Cost Factors",null,"Hours","Remaining value factors"]
[null,null,"Type no.","     Description","RC1","RC2","HWOL","intercept","agecoeff","hrscoeff"]
[null,null,1,"Tractor, under 80 hp, 2wd",7.0000000000000001E-3,2,12000,0.98099999999999998,9.2999999999999999E-2,5.7999999999999996E-3]
[null,null,2,"Tractor 80-150 hp, 2wd",7.0000000000000001E-3,2,12000,0.94210000000000005,9.9699999999999997E-2,8.0000000000000004E-4]
[null,null,3,"Tractor over 150 hp, 2wd",7.0000000000000001E-3,2,16000,0.97560000000000002,0.1187,1.9E-3]
[null,null,4,"Tractor, 4-wheel drive",3.0000000000000001E-3,2,16000,0.97560000000000002,0.1187,1.9E-3]
[null,null,5,"Combine SP unit",0.01,2.1,3000,1.1317999999999999,0.16450000000000001,7.9000000000000008E-3]
[null,null,6,"SP forage harvester",0.03,2,4000,0.79110000000000003,9.1300000000000006E-2,0]
[null,null,7,"SP windrower",0.06,2,3000,0.75570000000000004,6.7199999999999996E-2,0]
[null,null,8,"SP sprayer",0.1,1.3,1500,0.88260000000000005,7.7799999999999994E-2,0]
[null,null,9,"Skid-steer loader",7.0000000000000001E-3,2,3000,0.78600000000000003,6.3E-2,3.3E-3]
[null,null,10,"SP cotton picker",0.11,1.8,3000,1.1317999999999999,0.16450000000000001,7.9000000000000008E-3]
[]
[null,null,1,"Moldboard plow",0.28999999999999998,1.8,2000,0.73819999999999997,5.0999999999999997E-2,0]
[null,null,2,"Disk",0.18,1.7,2000,0.89059999999999995,0.1095,0]
[null,null,3,"Chisel plow, subsoiler",0.28000000000000003,1.4,5000,0.73819999999999997,5.0999999999999997E-2,0]
[null,null,4,"Field cultivator",0.27,1.4,2000,0.89059999999999995,0.1095,0]
[null,null,5,"Harrow",0.27,1.4,2000,0.89059999999999995,0.1095,0]
[null,null,6,"Cultivator",0.17,2.2000000000000002,2000,0.89059999999999995,0.1095,0]
[null,null,7,"Roller, mulcher",0.16,1.3,2000,0.89059999999999995,0.1095,0]
[null,null,8,"Rotary hoe",0.23,1.4,2000,0.89059999999999995,0.1095,0]
[null,null,9,"Rotary tiller",0.36,2,1500,0.89059999999999995,0.1095,0]
[null,null,10,"Planter,grain drill",0.32,2.1,1500,0.88260000000000005,7.7799999999999994E-2,0]
[null,null,11,"Corn picker",0.05,2.2999999999999998,2000,1.1317999999999999,0.16450000000000001,0]
[null,null,12,"Combine head",0.05,2.2999999999999998,2000,1.1317999999999999,0.16450000000000001,7.9000000000000008E-3]
[null,null,13,"Mower (sickle bar)",0.46,1.7,2000,0.75570000000000004,6.7199999999999996E-2,0]
[null,null,14,"Mower (rotary)",0.44,2,null,0.75570000000000004,6.7199999999999996E-2,0]
[null,null,15,"Mower-conditioner",0.18,1.6,2500,0.75570000000000004,6.7199999999999996E-2,0]
[null,null,16,"Windrower",0.18,1.6,2500,0.75570000000000004,6.7199999999999996E-2,0]
[null,null,17,"Small square baler",0.23,1.8,2000,0.85209999999999997,0.1014,0]
[null,null,18,"Large square baler",0.1,1.8,null,0.85209999999999997,0.1014,0]
[null,null,19,"Round baler",0.43,1.8,1500,0.85209999999999997,0.1014,0]
[null,null,20,"Rake",0.17,1.4,2500,0.79110000000000003,9.1300000000000006E-2,0]
[null,null,21,"Forage harvester-pull",0.15,1.6,2500,0.79110000000000003,9.1300000000000006E-2,0]
[null,null,22,"Sugar beet harvester",0.59,1.3,null,0.79110000000000003,9.1300000000000006E-2,0]
[null,null,23,"Potato harvester",0.19,1.4,null,0.79110000000000003,9.1300000000000006E-2,0]
[null,null,24,"Fert. spreader",0.63,1.3,1200,0.88260000000000005,7.7799999999999994E-2,0]
[null,null,25,"Sprayer",0.41,1.3,1500,0.88260000000000005,7.7799999999999994E-2,0]
[null,null,26,"Forage wagon",0.16,1.6,2000,0.94269999999999998,0.1111,0]
[null,null,27,"Grain wagon",0.19,1.3,3000,0.94269999999999998,0.1111,0]
[null,null,28,"Manure handling equipment",0.16,1.6,3000,0.94269999999999998,0.1111,0]
[null,null,29,"Feed grinders and mixers",1.4999999999999999E-2,1.6,3000,0.94269999999999998,0.1111,0]
[null,null,null,"Source: American Society of Agricultural and Biological Engineers Standards"]
[null,null,null,"Combine repair cost coefficients were adjusted based on recent survey data."]