{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Home","Assumptions","Tractors","Implements","Scenario"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":17,"comments":0,"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":"Home","index":0,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,4,1,14],[3,8,3,10]]}
[]
[null,null,null,null,"TEDDED vs NON-TEDDED COST COMPARISON"]
[]
[null,null,null,null,null,null,null,null,"HOMEPAGE"]

{"sheet":"Assumptions","index":1,"n_rows":3,"n_cols":14,"rows_kept":3,"cut":false,"hidden":false,"merged":[[5,1,7,5]]}
["Assumptions"]
[null,"Interest","Taxes","Insurance","Housing","Labor","Ac","Fuel Cost ($/gal)","Annual Use (hrs)","Purchase Price (% of list price)","Trade-in Value (% of purchase price)","Trade-in Year","Efficiency","Yield (ton/ac)"]
[null,0.08,0.01,7.4999999999999997E-3,2.5000000000000001E-3,20,2000,2.5,1000,0.8,0.7,3,0.8,1]

{"sheet":"Tractors","index":2,"n_rows":11,"n_cols":19,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,15,1,17],[1,11,1,14]]}
["Tractor Data"]
[null,null,null,null,null,null,null,null,null,null,null,"Fixed Cost (Hourly)",null,null,null,"Variable Cost (Hourly)"]
[null,"Model ","Special Uses","Engine hp","PTO hp","List Price","R&M","Purchase Price","Trade in (yrs)","Annual Use (hrs)","Trade in Value","Depreciation","Interest","TIH","Total Fixed","R&M (Hourly)","Labor","Total Variable","Cost Per Hour Without Fuel"]
[null,"John Deere 6155R","Tractor",155,{"$f":"D4*0.8","v":124},153500,{"$f":"0.07*H4*(Assumptions!$I$3/1000)^2","v":8596},{"$f":"F4*Assumptions!$J$3","v":122800},{"$f":"Assumptions!$L$3","v":3},{"$f":"Assumptions!$I$3","v":1000},{"$f":"H4*Assumptions!$K$3","v":85960},{"$f":"((H4-K4)/I4)/Assumptions!$I$3","v":12.28},{"$f":"(Assumptions!$B$3*H4)/Assumptions!$I$3","v":9.8239999999999998},{"$f":"(H4*SUM(Assumptions!$C$3:$E$3))/Assumptions!$I$3","v":2.456},{"$f":"SUM(L4:N4)","v":24.56},{"$f":"G4/Assumptions!$I$3","v":8.5960000000000001},{"$f":"Assumptions!$F$3","v":20},{"$f":"SUM(P4:Q4)","v":28.596},{"$f":"O4+R4","v":53.155999999999999}]
["Tractor","John Deere 7250R","Tractor",250,{"$f":"D5*0.8","v":200},249000,{"$f":"0.07*H5*(Assumptions!$I$3/1000)^2","v":13944.000000000002},{"$f":"F5*Assumptions!$J$3","v":199200},{"$f":"Assumptions!$L$3","v":3},{"$f":"Assumptions!$I$3","v":1000},{"$f":"H5*Assumptions!$K$3","v":139440},{"$f":"((H5-K5)/I5)/Assumptions!$I$3","v":19.920000000000002},{"$f":"(Assumptions!$B$3*H5)/Assumptions!$I$3","v":15.936},{"$f":"(H5*SUM(Assumptions!$C$3:$E$3))/Assumptions!$I$3","v":3.984},{"$f":"SUM(L5:N5)","v":39.840000000000003},{"$f":"G5/Assumptions!$I$3","v":13.944000000000003},{"$f":"Assumptions!$F$3","v":20},33.944000000000003,73.784000000000006]
["Windrower","John Deere 8320R","Tractor",320,256,345000,{"$f":"0.07*H6*(Assumptions!$I$3/1000)^2","v":19320.000000000004},{"$f":"F6*Assumptions!$J$3","v":276000},{"$f":"Assumptions!$L$3","v":3},{"$f":"Assumptions!$I$3","v":1000},{"$f":"H6*Assumptions!$K$3","v":193200},{"$f":"((H6-K6)/I6)/Assumptions!$I$3","v":27.6},{"$f":"(Assumptions!$B$3*H6)/Assumptions!$I$3","v":22.08},{"$f":"(H6*SUM(Assumptions!$C$3:$E$3))/Assumptions!$I$3","v":5.52},55.2,{"$f":"G6/Assumptions!$I$3","v":19.320000000000004},{"$f":"Assumptions!$F$3","v":20},39.320000000000007,94.52000000000001]
["Self-Propelled Forage Harvester","John Deere W235","Windrower",235,188,154646,{"$f":"0.07*H7*(Assumptions!$I$3/1000)^2","v":8660.1760000000013},{"$f":"F7*Assumptions!$J$3","v":123716.8},{"$f":"Assumptions!$L$3","v":3},{"$f":"Assumptions!$I$3","v":1000},{"$f":"H7*Assumptions!$K$3","v":86601.76},{"$f":"((H7-K7)/I7)/Assumptions!$I$3","v":12.371680000000001},{"$f":"(Assumptions!$B$3*H7)/Assumptions!$I$3","v":9.8973440000000004},{"$f":"(H7*SUM(Assumptions!$C$3:$E$3))/Assumptions!$I$3","v":2.4743360000000001},24.743360000000003,{"$f":"G7/Assumptions!$I$3","v":8.6601760000000017},{"$f":"Assumptions!$F$3","v":20},28.660176,53.403536000000003]
[null,"John Deere W260","Windrower",260,208,166610,{"$f":"0.07*H8*(Assumptions!$I$3/1000)^2","v":9330.1600000000017},{"$f":"F8*Assumptions!$J$3","v":133288},{"$f":"Assumptions!$L$3","v":3},{"$f":"Assumptions!$I$3","v":1000},{"$f":"H8*Assumptions!$K$3","v":93301.599999999991},{"$f":"((H8-K8)/I8)/Assumptions!$I$3","v":13.328800000000003},{"$f":"(Assumptions!$B$3*H8)/Assumptions!$I$3","v":10.663040000000001},{"$f":"(H8*SUM(Assumptions!$C$3:$E$3))/Assumptions!$I$3","v":2.6657600000000001},26.657600000000002,{"$f":"G8/Assumptions!$I$3","v":9.3301600000000011},{"$f":"Assumptions!$F$3","v":20},29.330159999999999,55.987760000000002]
[null,"John Deere 8800 SPFH NA","Self-Propelled Forage Harvester",832,665.6,736020,{"$f":"0.03*H9*(Assumptions!$I$3/1000)^2","v":17664.48},{"$f":"F9*Assumptions!$J$3","v":588816},{"$f":"Assumptions!$L$3","v":3},{"$f":"Assumptions!$I$3","v":1000},{"$f":"H9*Assumptions!$K$3","v":412171.19999999995},{"$f":"((H9-K9)/I9)/Assumptions!$I$3","v":58.881600000000013},{"$f":"(Assumptions!$B$3*H9)/Assumptions!$I$3","v":47.10528},{"$f":"(H9*SUM(Assumptions!$C$3:$E$3))/Assumptions!$I$3","v":11.77632},117.76320000000001,{"$f":"G9/Assumptions!$I$3","v":17.664480000000001},{"$f":"Assumptions!$F$3","v":20},37.664479999999998,155.42768000000001]
[null,"John Deere 8600 SPFH NA","Self-Propelled Forage Harvester",617,493.6,615075,{"$f":"0.03*H10*(Assumptions!$I$3/1000)^2","v":14761.8},{"$f":"F10*Assumptions!$J$3","v":492060},{"$f":"Assumptions!$L$3","v":3},{"$f":"Assumptions!$I$3","v":1000},{"$f":"H10*Assumptions!$K$3","v":344442},{"$f":"((H10-K10)/I10)/Assumptions!$I$3","v":49.206000000000003},{"$f":"(Assumptions!$B$3*H10)/Assumptions!$I$3","v":39.364800000000002},{"$f":"(H10*SUM(Assumptions!$C$3:$E$3))/Assumptions!$I$3","v":9.8412000000000006},98.412000000000006,{"$f":"G10/Assumptions!$I$3","v":14.761799999999999},{"$f":"Assumptions!$F$3","v":20},34.761800000000001,133.1738]
[null,"John Deere 8400 SPFH NA","Self-Propelled Forage Harvester",532,425.6,538707,{"$f":"0.03*H11*(Assumptions!$I$3/1000)^2","v":12928.968000000001},{"$f":"F11*Assumptions!$J$3","v":430965.60000000003},{"$f":"Assumptions!$L$3","v":3},{"$f":"Assumptions!$I$3","v":1000},{"$f":"H11*Assumptions!$K$3","v":301675.92},{"$f":"((H11-K11)/I11)/Assumptions!$I$3","v":43.096560000000018},{"$f":"(Assumptions!$B$3*H11)/Assumptions!$I$3","v":34.47724800000001},{"$f":"(H11*SUM(Assumptions!$C$3:$E$3))/Assumptions!$I$3","v":8.6193120000000025},86.193120000000036,{"$f":"G11/Assumptions!$I$3","v":12.928968000000001},{"$f":"Assumptions!$F$3","v":20},32.928967999999998,119.12208800000003]

{"sheet":"Implements","index":3,"n_rows":29,"n_cols":30,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,20,2,22],[2,16,2,19],[2,12,2,15],[2,9,2,10]]}
["Implements"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Productivity",null,null,null,"Fixed Cost (Hourly)",null,null,null,"Variable Costs (Hourly)"]
[null,"Model ","Type","Size (ft)","Attachment","List Price","Purchase Price","Trade-in (yrs)","Trade-in Value","R&M","Power Required (hp)","Range","Tractor Required","Efficiency","Speed (mph)","Effective Field Capacity","Hours of Use (Annual)","Interest","Depreciation","TIH","Total Fixed Costs (Hourly)","R&M (Hourly)","Labor","Total Variable Costs (Hourly)","Tractor Fuel Usage (gal/hr)","Tractor Fuel Cost ($/hr)","Total  Hourly Tractor Cost","Total Cost per Hour","Total Cost per Acre","Total Cost Per Ton"]
[null,"GF 502THA ","Tedder",{"$f":"16+(5/12)","v":16.416666666666668},"Drawbar",9110,{"$f":"F5*Assumptions!$J$3","v":7288},3,{"$f":"G5*Assumptions!$K$3","v":5101.5999999999995},{"$f":"0.17*G5*(Q5/1000)^1.4","v":179.16445269016995},20,null,"John Deere 6155R",0.8,5,{"$f":"O5*N5*D5/8.25","v":7.9595959595959602},{"$f":"Assumptions!$G$3/P5","v":251.26903553299491},{"$f":"Assumptions!$B$3*G5/Q5","v":2.3203814141414143},{"$f":"((G5-I5)/H5)/Q5","v":2.9004767676767687},{"$f":"(G5*SUM(Assumptions!$C$3:$E$3))/Q5","v":0.58009535353535358},{"$f":"SUM(R5:T5)","v":5.8009535353535373},{"$f":"J5/Q5","v":0.7130383268679491},{"$f":"Assumptions!$F$3","v":20},{"$f":"SUM(V5:W5)","v":20.713038326867949},{"$f":"(0.0434*((0.6*D5)/VLOOKUP(M5,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M5,TractorTable[],4,FALSE)","v":2.78349},{"$f":"(FuelCost*Implements!Y5)","v":6.9587250000000003},{"$f":"(VLOOKUP(M5,TractorTable[],18,FALSE))+Z5","v":60.114725},{"$f":"X5+U5+AA5","v":86.628716862221495},{"$f":"AB5/P5","v":10.883557067715644},{"$f":"AC5/Assumptions!$N$3","v":10.883557067715644}]
[null,"GF 7802 ","Tedder",{"$f":"25+(7/12)","v":25.583333333333332},"3-point mounted category 2",19590,{"$f":"F6*Assumptions!$J$3","v":15672},3,{"$f":"G6*Assumptions!$K$3","v":10970.4},{"$f":"0.17*G6*(Q6/1000)^1.4","v":207.02695630340096},75,null,"John Deere 6155R",0.8,5,{"$f":"O6*N6*D6/8.25","v":12.404040404040403},{"$f":"Assumptions!$G$3/P6","v":161.23778501628667},{"$f":"Assumptions!$B$3*G6/Q6","v":7.775844848484847},9.719806060606059,{"$f":"(G6*SUM(Assumptions!$C$3:$E$3))/Q6","v":1.9439612121212118},{"$f":"SUM(R6:T6)","v":19.439612121212118},1.2839853653564461,{"$f":"Assumptions!$F$3","v":20},{"$f":"SUM(V6:W6)","v":21.283985365356447},{"$f":"(0.0434*((0.6*D6)/VLOOKUP(M6,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M6,TractorTable[],4,FALSE)","v":3.0221899999999997},{"$f":"(FuelCost*Implements!Y6)","v":7.5554749999999995},{"$f":"(VLOOKUP(M6,TractorTable[],18,FALSE))+Z6","v":60.711475},{"$f":"X6+U6+AA6","v":101.43507248656857},{"$f":"AB6/P6","v":8.1775832053503983},{"$f":"AC6/Assumptions!$N$3","v":8.1775832053503983}]
[null,"GF 7802 T GII","Tedder",{"$f":"25+(7/12)","v":25.583333333333332},"Drawbar",24650,{"$f":"F7*Assumptions!$J$3","v":19720},3,{"$f":"G7*Assumptions!$K$3","v":13804},260.50099402138,45,null,"John Deere 6155R",0.8,5,{"$f":"O7*N7*D7/8.25","v":12.404040404040403},{"$f":"Assumptions!$G$3/P7","v":161.23778501628667},{"$f":"Assumptions!$B$3*G7/Q7","v":9.7843070707070705},12.230383838383837,{"$f":"(G7*SUM(Assumptions!$C$3:$E$3))/Q7","v":2.4460767676767676},24.460767676767677,1.6156324275669425,{"$f":"Assumptions!$F$3","v":20},21.615632427566943,{"$f":"(0.0434*((0.6*D7)/VLOOKUP(M7,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M7,TractorTable[],4,FALSE)","v":3.0221899999999997},{"$f":"(FuelCost*Implements!Y7)","v":7.5554749999999995},{"$f":"(VLOOKUP(M7,TractorTable[],18,FALSE))+Z7","v":60.711475},106.78787510433463,8.6091202242093878,{"$f":"AC7/Assumptions!$N$3","v":8.6091202242093878}]
["Tedder","GF 10812 T","Tedder",{"$f":"35+(5/12)","v":35.416666666666664},"Drawbar",37600,{"$f":"F8*Assumptions!$J$3","v":30080},3,{"$f":"G8*Assumptions!$K$3","v":21056},252.01682144316638,55,null,"John Deere 6155R",0.8,5,{"$f":"O8*N8*D8/8.25","v":17.171717171717169},{"$f":"Assumptions!$G$3/P8","v":116.47058823529413},{"$f":"Assumptions!$B$3*G8/Q8","v":20.661010101010099},25.826262626262622,{"$f":"(G8*SUM(Assumptions!$C$3:$E$3))/Q8","v":5.1652525252525248},51.652525252525251,2.1637807901685999,{"$f":"Assumptions!$F$3","v":20},22.163780790168602,{"$f":"(0.0434*((0.6*D8)/VLOOKUP(M8,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M8,TractorTable[],4,FALSE)","v":3.2782499999999999},{"$f":"(FuelCost*Implements!Y8)","v":8.1956249999999997},{"$f":"(VLOOKUP(M8,TractorTable[],18,FALSE))+Z8","v":61.351624999999999},135.16793104269385,7.8715442195451137,{"$f":"AC8/Assumptions!$N$3","v":7.8715442195451137}]
["Triple Mower","GF 17012","Tedder",{"$f":"56+(5/12)","v":56.416666666666664},"Drawbar",65420,{"$f":"F9*Assumptions!$J$3","v":52336},3,{"$f":"G9*Assumptions!$K$3","v":36635.199999999997},228.49283728605712,100,null,"John Deere 6155R",0.8,5,{"$f":"O9*N9*D9/8.25","v":27.353535353535353},{"$f":"Assumptions!$G$3/P9","v":73.116691285081245},{"$f":"Assumptions!$B$3*G9/Q9","v":57.262985050505051},71.578731313131328,{"$f":"(G9*SUM(Assumptions!$C$3:$E$3))/Q9","v":14.315746262626263},143.15746262626266,3.1250434513668819,{"$f":"Assumptions!$F$3","v":20},23.125043451366881,{"$f":"(0.0434*((0.6*D9)/VLOOKUP(M9,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M9,TractorTable[],4,FALSE)","v":3.8250899999999999},{"$f":"(FuelCost*Implements!Y9)","v":9.5627250000000004},{"$f":"(VLOOKUP(M9,TractorTable[],18,FALSE))+Z9","v":62.718724999999999},229.00123107762954,8.371906158303295,{"$f":"AC9/Assumptions!$N$3","v":8.371906158303295}]
["Mower","VOLTO 52T","Tedder",17,"Drawbar",7900,{"$f":"F10*Assumptions!$J$3","v":6320},3,{"$f":"G10*Assumptions!$K$3","v":4424},147.95547608376208,20,null,"John Deere 6155R",0.8,5,{"$f":"O10*N10*D10/8.25","v":8.2424242424242422},{"$f":"Assumptions!$G$3/P10","v":242.64705882352942},{"$f":"Assumptions!$B$3*G10/Q10","v":2.0836848484848485},2.6046060606060606,{"$f":"(G10*SUM(Assumptions!$C$3:$E$3))/Q10","v":0.52092121212121212},{"$f":"SUM(R10:T10)","v":5.2092121212121221},0.60975590143611036,{"$f":"Assumptions!$F$3","v":20},{"$f":"SUM(V10:W10)","v":20.60975590143611},{"$f":"(0.0434*((0.6*D10)/VLOOKUP(M10,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M10,TractorTable[],4,FALSE)","v":2.7986800000000001},{"$f":"(FuelCost*Implements!Y10)","v":6.9967000000000006},{"$f":"(VLOOKUP(M10,TractorTable[],18,FALSE))+Z10","v":60.152699999999996},85.971668022648231,10.430386193924233,{"$f":"AC10/Assumptions!$N$3","v":10.430386193924233}]
["Windrower","VOLTO 800TH","Tedder",25.3,"Drawbar",16650,{"$f":"F11*Assumptions!$J$3","v":13320},3,{"$f":"G11*Assumptions!$K$3","v":9324},178.72197317192123,45,null,"John Deere 6155R",0.8,5,12.266666666666667,{"$f":"Assumptions!$G$3/P11","v":163.04347826086956},{"$f":"Assumptions!$B$3*G11/Q11","v":6.5356799999999993},8.1696000000000009,{"$f":"(G11*SUM(Assumptions!$C$3:$E$3))/Q11","v":1.6339199999999998},{"$f":"SUM(R11:T11)","v":16.339199999999998},1.0961614354544502,{"$f":"Assumptions!$F$3","v":20},{"$f":"SUM(V11:W11)","v":21.096161435454452},{"$f":"(0.0434*((0.6*D11)/VLOOKUP(M11,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M11,TractorTable[],4,FALSE)","v":3.014812},{"$f":"(FuelCost*Implements!Y11)","v":7.5370299999999997},{"$f":"(VLOOKUP(M11,TractorTable[],18,FALSE))+Z11","v":60.69303},98.128391435454461,7.9995971278903086,{"$f":"AC11/Assumptions!$N$3","v":7.9995971278903086}]
["Merger","VOLTO 1100T","Tedder",35.1,"2-pt trailed",29655,{"$f":"F12*Assumptions!$J$3","v":23724},3,{"$f":"G12*Assumptions!$K$3","v":16606.8},201.27989987437994,55,null,"John Deere 6155R",0.8,5,17.018181818181819,{"$f":"Assumptions!$G$3/P12","v":117.52136752136751},{"$f":"Assumptions!$B$3*G12/Q12","v":16.149573818181821},20.186967272727276,{"$f":"(G12*SUM(Assumptions!$C$3:$E$3))/Q12","v":4.0373934545454553},40.373934545454546,1.7127089662038149,{"$f":"Assumptions!$F$3","v":20},21.712708966203813,{"$f":"(0.0434*((0.6*D12)/VLOOKUP(M12,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M12,TractorTable[],4,FALSE)","v":3.2700039999999997},{"$f":"(FuelCost*Implements!Y12)","v":8.1750099999999986},{"$f":"(VLOOKUP(M12,TractorTable[],18,FALSE))+Z12","v":61.331009999999999},123.41765351165836,7.2521057084841978,{"$f":"AC12/Assumptions!$N$3","v":7.2521057084841978}]
["Windrow Pickup","VOLTO 1300T","Tedder",42.4,"2-pt trailed",41000,{"$f":"F13*Assumptions!$J$3","v":32800},3,{"$f":"G13*Assumptions!$K$3","v":22960},213.60140248565997,75,null,"John Deere 6155R",0.8,5,20.557575757575759,{"$f":"Assumptions!$G$3/P13","v":97.287735849056602},{"$f":"Assumptions!$B$3*G13/Q13","v":26.971539393939395},33.714424242424244,{"$f":"(G13*SUM(Assumptions!$C$3:$E$3))/Q13","v":6.7428848484848487},67.428848484848487,2.195563506761693,{"$f":"Assumptions!$F$3","v":20},22.195563506761694,{"$f":"(0.0434*((0.6*D13)/VLOOKUP(M13,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M13,TractorTable[],4,FALSE)","v":3.4600959999999996},{"$f":"(FuelCost*Implements!Y13)","v":8.6502399999999984},{"$f":"(VLOOKUP(M13,TractorTable[],18,FALSE))+Z13","v":61.806239999999995},151.43065199161018,7.3661726352050936,{"$f":"AC13/Assumptions!$N$3","v":7.3661726352050936}]
[null,"KW 5.52/ 4x7","Tedder",{"$f":"18+(0.5/12)","v":18.041666666666668},"3-pt linkage",7758,{"$f":"F14*Assumptions!$J$3","v":6206.4000000000005},3,{"$f":"G14*Assumptions!$K$3","v":4344.4800000000005},133.68876186838349,50,null,"John Deere 6155R",0.8,5,8.7474747474747474,{"$f":"Assumptions!$G$3/P14","v":228.63741339491918},{"$f":"Assumptions!$B$3*G14/Q14","v":2.1716130909090912},2.7145163636363634,{"$f":"(G14*SUM(Assumptions!$C$3:$E$3))/Q14","v":0.54290327272727279},{"$f":"SUM(R14:T14)","v":5.4290327272727268},0.58471953423242473,{"$f":"Assumptions!$F$3","v":20},{"$f":"SUM(V14:W14)","v":20.584719534232423},{"$f":"(0.0434*((0.6*D14)/VLOOKUP(M14,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M14,TractorTable[],4,FALSE)","v":2.8258049999999999},{"$f":"(FuelCost*Implements!Y14)","v":7.0645124999999993},{"$f":"(VLOOKUP(M14,TractorTable[],18,FALSE))+Z14","v":60.220512499999998},86.234264761505145,9.858189620541582,{"$f":"AC14/Assumptions!$N$3","v":9.858189620541582}]
[null,"KW 8.82/8","Tedder",{"$f":"28+(10.5/12)","v":28.875},"3-pt linkage",15862,{"$f":"F15*Assumptions!$J$3","v":12689.6},3,{"$f":"G15*Assumptions!$K$3","v":8882.7199999999993},141.5010289402986,75,null,"John Deere 6155R",0.8,5,14,{"$f":"Assumptions!$G$3/P15","v":142.85714285714286},{"$f":"Assumptions!$B$3*G15/Q15","v":7.1061759999999996},8.8827200000000008,{"$f":"(G15*SUM(Assumptions!$C$3:$E$3))/Q15","v":1.7765439999999999},{"$f":"SUM(R15:T15)","v":17.765440000000002},0.99050720258209013,{"$f":"Assumptions!$F$3","v":20},{"$f":"SUM(V15:W15)","v":20.990507202582091},{"$f":"(0.0434*((0.6*D15)/VLOOKUP(M15,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M15,TractorTable[],4,FALSE)","v":3.1079049999999997},{"$f":"(FuelCost*Implements!Y15)","v":7.7697624999999988},{"$f":"(VLOOKUP(M15,TractorTable[],18,FALSE))+Z15","v":60.925762499999998},99.681709702582083,7.1201221216130062,{"$f":"AC15/Assumptions!$N$3","v":7.1201221216130062}]
[null,"KW 7.82 T","Tedder",{"$f":"25+(7/12)","v":25.583333333333332},"Trailed",19450,{"$f":"F16*Assumptions!$J$3","v":15560},3,{"$f":"G16*Assumptions!$K$3","v":10892},205.54743747325927,50,null,"John Deere 6155R",0.8,5,12.404040404040403,{"$f":"Assumptions!$G$3/P16","v":161.23778501628667},{"$f":"Assumptions!$B$3*G16/Q16","v":7.720274747474746},9.6503434343434336,{"$f":"(G16*SUM(Assumptions!$C$3:$E$3))/Q16","v":1.9300686868686865},19.300686868686867,1.2748093596826382,{"$f":"Assumptions!$F$3","v":20},21.274809359682639,{"$f":"(0.0434*((0.6*D16)/VLOOKUP(M16,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M16,TractorTable[],4,FALSE)","v":3.0221899999999997},{"$f":"(FuelCost*Implements!Y16)","v":7.5554749999999995},{"$f":"(VLOOKUP(M16,TractorTable[],18,FALSE))+Z16","v":60.711475},101.28697122836951,8.1656434459353271,{"$f":"AC16/Assumptions!$N$3","v":8.1656434459353271}]
[null,"KWT 1600","Tedder",{"$f":"50+(1/12)","v":50.083333333333336},"Trailed",45000,{"$f":"F17*Assumptions!$J$3","v":36000},3,{"$f":"G17*Assumptions!$K$3","v":25200},185.68398150380094,80,null,"John Deere 6155R",0.8,5,24.282828282828284,{"$f":"Assumptions!$G$3/P17","v":82.362728785357731},{"$f":"Assumptions!$B$3*G17/Q17","v":34.967272727272729},43.709090909090911,{"$f":"(G17*SUM(Assumptions!$C$3:$E$3))/Q17","v":8.7418181818181822},87.418181818181836,2.2544661188643307,{"$f":"Assumptions!$F$3","v":20},22.254466118864329,{"$f":"(0.0434*((0.6*D17)/VLOOKUP(M17,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M17,TractorTable[],4,FALSE)","v":3.6601700000000004},{"$f":"(FuelCost*Implements!Y17)","v":9.1504250000000003},{"$f":"(VLOOKUP(M17,TractorTable[],18,FALSE))+Z17","v":62.306424999999997},171.97907293704617,7.0823328705355948,{"$f":"AC17/Assumptions!$N$3","v":7.0823328705355948}]
[null,"KW 5.52/ 4x7T","Tedder",{"$f":"18+(0.5/12)","v":18.041666666666668},"Trailed",8603,{"$f":"F18*Assumptions!$J$3","v":6882.4000000000005},3,{"$f":"G18*Assumptions!$K$3","v":4817.68},148.25011837505843,25,null,"John Deere 6155R",0.8,5,8.7474747474747474,{"$f":"Assumptions!$G$3/P18","v":228.63741339491918},{"$f":"Assumptions!$B$3*G18/Q18","v":2.4081448080808086},3.0101810101010105,{"$f":"(G18*SUM(Assumptions!$C$3:$E$3))/Q18","v":0.60203620202020214},6.0203620202020209,0.64840708339798281,{"$f":"Assumptions!$F$3","v":20},20.648407083397984,{"$f":"(0.0434*((0.6*D18)/VLOOKUP(M18,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M18,TractorTable[],4,FALSE)","v":2.8258049999999999},{"$f":"(FuelCost*Implements!Y18)","v":7.0645124999999993},{"$f":"(VLOOKUP(M18,TractorTable[],18,FALSE))+Z18","v":60.220512499999998},86.889281603600011,9.9330702987949202,{"$f":"AC18/Assumptions!$N$3","v":9.9330702987949202}]
[null,"Combo 8830D and 3125","Triple Mower",{"$f":"27+(3/12)","v":27.25},"Triple Mower",96840,{"$f":"F19*Assumptions!$J$3","v":77472},3,{"$f":"G19*Assumptions!$K$3","v":54230.399999999994},{"$f":"0.18*G19*(Q19/1000)^1.6","v":396.92123120397002},225,null,"John Deere 8320R",0.8,7,18.4969696969697,{"$f":"Assumptions!$G$3/P19","v":108.12581913499344},{"$f":"Assumptions!$B$3*G19/Q19","v":57.319889454545461},71.649861818181847,{"$f":"(G19*SUM(Assumptions!$C$3:$E$3))/Q19","v":14.329972363636365},143.29972363636367,3.6709199928318688,{"$f":"Assumptions!$F$3","v":20},23.67091999283187,{"$f":"(0.0434*((3.3*D19)/VLOOKUP(M19,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M19,TractorTable[],4,FALSE)","v":8.7667450000000002},{"$f":"(FuelCost*Implements!Y19)","v":21.916862500000001},{"$f":"(VLOOKUP(M19,TractorTable[],18,FALSE))+Z19","v":116.43686250000002},283.40750612919555,15.32183437461247,{"$f":"AC19/Assumptions!$N$3","v":15.32183437461247}]
[null,"Combo 10030 and 3525","Triple Mower",{"$f":"32+(6/12)","v":32.5},"Triple Mower",104460,{"$f":"F20*Assumptions!$J$3","v":83568},3,{"$f":"G20*Assumptions!$K$3","v":58497.599999999999},{"$f":"0.18*G20*(Q20/1000)^1.6","v":322.97774913141853},250,null,"John Deere 8320R",0.8,7,22.060606060606062,{"$f":"Assumptions!$G$3/P20","v":90.659340659340657},{"$f":"Assumptions!$B$3*G20/Q20","v":73.742429090909098},92.17803636363638,{"$f":"(G20*SUM(Assumptions!$C$3:$E$3))/Q20","v":18.435607272727275},184.35607272727276,3.562542444964738,{"$f":"Assumptions!$F$3","v":20},23.562542444964738,{"$f":"(0.0434*((3.3*D20)/VLOOKUP(M20,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M20,TractorTable[],4,FALSE)","v":9.5186500000000009},{"$f":"(FuelCost*Implements!Y20)","v":23.796625000000002},{"$f":"(VLOOKUP(M20,TractorTable[],18,FALSE))+Z20","v":118.31662500000002},326.23524017223752,14.788135886928348,{"$f":"AC20/Assumptions!$N$3","v":14.788135886928348}]
[null,"John Deere 956","Mower ",14.5,"Center-Pivot Rotary",50150,{"$f":"F21*Assumptions!$J$3","v":40120},3,{"$f":"G21*Assumptions!$K$3","v":28084},{"$f":"0.16*G21*(Q21/1000)^2","v":265.0554490523914},100,150,"John Deere 6155R",0.8,7,9.8424242424242436,{"$f":"Assumptions!$G$3/P21","v":203.20197044334972},{"$f":"Assumptions!$B$3*G21/Q21","v":15.795122424242427},19.743903030303034,{"$f":"(G21*SUM(Assumptions!$C$3:$E$3))/Q21","v":3.9487806060606068},39.487806060606069,{"$f":"J21/Q21","v":1.3043940886699505},{"$f":"Assumptions!$F$3","v":20},21.304394088669952,{"$f":"(0.0434*((3.3*D21)/VLOOKUP(M21,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M21,TractorTable[],4,FALSE)","v":4.43269},{"$f":"(FuelCost*Implements!Y21)","v":11.081725},{"$f":"(VLOOKUP(M21,TractorTable[],18,FALSE))+Z21","v":64.237724999999998},125.02992514927601,12.703163577358707,{"$f":"AC21/Assumptions!$N$3","v":12.703163577358707}]
[null,"John Deere 835","Mower ",11.5,"Center-Pivot Rotary",37262,{"$f":"F22*Assumptions!$J$3","v":29809.600000000002},3,{"$f":"G22*Assumptions!$K$3","v":20866.72},{"$f":"0.16*G22*(Q22/1000)^2","v":313.09222638015501},90,150,"John Deere 6155R",0.8,7,7.8060606060606066,{"$f":"Assumptions!$G$3/P22","v":256.21118012422357},{"$f":"Assumptions!$B$3*G22/Q22","v":9.3078217696969716},{"$f":"((G22-I22)/H22)/Q22","v":11.634777212121215},{"$f":"(G22*SUM(Assumptions!$C$3:$E$3))/Q22","v":2.3269554424242429},23.269554424242429,1.2220084472049688,{"$f":"Assumptions!$F$3","v":20},21.222008447204971,{"$f":"(0.0434*((3.3*D22)/VLOOKUP(M22,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M22,TractorTable[],4,FALSE)","v":4.0030299999999999},{"$f":"(FuelCost*Implements!Y22)","v":10.007574999999999},{"$f":"(VLOOKUP(M22,TractorTable[],18,FALSE))+Z22","v":63.163574999999994},107.65513787144739,13.791224960239767,{"$f":"AC22/Assumptions!$N$3","v":13.791224960239767}]
[null,"John Deere 500R","Windrower",16,"Rotary Platform",40566,{"$f":"F23*Assumptions!$J$3","v":32452.800000000003},3,{"$f":"G23*Assumptions!$K$3","v":22716.959999999999},{"$f":"0.06*G23*(Q23/1000)^2","v":129.422970703125},235,260,"John Deere W235",0.8,5,7.7575757575757578,{"$f":"Assumptions!$G$3/P23","v":257.8125},{"$f":"Assumptions!$B$3*G23/Q23","v":10.070202181818182},12.587752727272731,{"$f":"(G23*SUM(Assumptions!$C$3:$E$3))/Q23","v":2.5175505454545455},25.175505454545458,0.50200425000000004,{"$f":"Assumptions!$F$3","v":20},20.502004249999999,{"$f":"(0.0434*((0.5*D23)/VLOOKUP(M23,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M23,TractorTable[],4,FALSE)","v":3.9192},{"$f":"(FuelCost*Implements!Y23)","v":9.798},{"$f":"(VLOOKUP(M23,TractorTable[],18,FALSE))+Z23","v":63.201536000000004},108.87904570454546,14.035189485351562,{"$f":"AC23/Assumptions!$N$3","v":14.035189485351562}]
[null,"John Deere 994R","Windrower",13,"Rotary Platform",30698,{"$f":"F24*Assumptions!$J$3","v":24558.400000000001},3,{"$f":"G24*Assumptions!$K$3","v":17190.88},{"$f":"0.06*G24*(Q24/1000)^2","v":148.35852958579886},235,260,"John Deere W260",0.8,5,6.3030303030303028,{"$f":"Assumptions!$G$3/P24","v":317.30769230769232},{"$f":"Assumptions!$B$3*G24/Q24","v":6.1916935757575766},7.7396169696969697,{"$f":"(G24*SUM(Assumptions!$C$3:$E$3))/Q24","v":1.5479233939393942},15.479233939393941,0.46755415384615395,{"$f":"Assumptions!$F$3","v":20},20.467554153846155,{"$f":"(0.0434*((0.5*D24)/VLOOKUP(M24,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M24,TractorTable[],4,FALSE)","v":4.2340999999999998},{"$f":"(FuelCost*Implements!Y24)","v":10.585249999999998},{"$f":"(VLOOKUP(M24,TractorTable[],18,FALSE))+Z24","v":66.573009999999996},102.5197980932401,16.265160274408284,{"$f":"AC24/Assumptions!$N$3","v":16.265160274408284}]
[null,"KUHN MM 700","Merger",24,"2-pt swivel",82950,{"$f":"F25*Assumptions!$J$3","v":66360},3,{"$f":"G25*Assumptions!$K$3","v":46452},{"$f":"0.17*G25*(Q25/1000)^1.4","v":958.63458773747516},100,null,"John Deere 6155R",0.8,5,11.636363636363637,{"$f":"Assumptions!$G$3/P25","v":171.875},{"$f":"Assumptions!$B$3*G25/Q25","v":30.887563636363637},38.609454545454547,{"$f":"(G25*SUM(Assumptions!$C$3:$E$3))/Q25","v":7.7218909090909094},77.218909090909108,5.5775103286544008,{"$f":"Assumptions!$F$3","v":20},25.577510328654402,{"$f":"(0.0434*((0.8*D25)/VLOOKUP(M25,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M25,TractorTable[],4,FALSE)","v":3.1892800000000001},{"$f":"(FuelCost*Implements!Y25)","v":7.9732000000000003},{"$f":"(VLOOKUP(M25,TractorTable[],18,FALSE))+Z25","v":61.129199999999997},163.9256194195635,14.087357918868738,{"$f":"AC25/Assumptions!$N$3","v":14.087357918868738}]
[null,"KUHN MM 1100","Merger",36,"2-pt swivel",156000,{"$f":"F26*Assumptions!$J$3","v":124800},3,{"$f":"G26*Assumptions!$K$3","v":87360},{"$f":"0.17*G26*(Q26/1000)^1.4","v":1021.9591576946658},140,null,"John Deere 7250R",0.8,5,17.454545454545453,{"$f":"Assumptions!$G$3/P26","v":114.58333333333334},{"$f":"Assumptions!$B$3*G26/Q26","v":87.133090909090896},108.91636363636363,{"$f":"(G26*SUM(Assumptions!$C$3:$E$3))/Q26","v":21.783272727272724},217.83272727272725,8.9189162853352641,{"$f":"Assumptions!$F$3","v":20},28.918916285335264,{"$f":"(0.0434*((0.8*D26)/VLOOKUP(M26,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M26,TractorTable[],4,FALSE)","v":5.0499200000000002},{"$f":"(FuelCost*Implements!Y26)","v":12.6248},{"$f":"(VLOOKUP(M26,TractorTable[],18,FALSE))+Z26","v":86.408800000000014},333.16044355806252,19.087317078847335,{"$f":"AC26/Assumptions!$N$3","v":19.087317078847335}]
[null,"John Deere 640C (Large SPFH)","Windrow Pickup",11.8,"SPFH attachment",30762,{"$f":"F27*Assumptions!$J$3","v":24609.600000000002},3,{"$f":"G27*Assumptions!$K$3","v":17226.72},{"$f":"0.06*G27*(Q27/1000)^2","v":70.485491271814809},500,850,"John Deere 8800 SPFH NA",0.8,8,{"$f":"O27*N27*D27/8.25","v":9.153939393939396},{"$f":"Assumptions!$G$3/P27","v":218.48516949152537},{"$f":"Assumptions!$B$3*G27/Q27","v":9.010991476363639},11.263739345454551,{"$f":"(G27*SUM(Assumptions!$C$3:$E$3))/Q27","v":2.2527478690909097},22.527478690909099,0.32260995762711853,{"$f":"Assumptions!$F$3","v":20},20.322609957627119,{"$f":"(0.0434*((0.8*D27)/VLOOKUP(M27,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M27,TractorTable[],4,FALSE)","v":13.056096},{"$f":"(FuelCost*Implements!Y27)","v":32.640239999999999},{"$f":"(VLOOKUP(M27,TractorTable[],18,FALSE))+Z27","v":188.06792000000002},230.91800864853622,25.226080129110478,{"$f":"AC27/Assumptions!$N$3","v":25.226080129110478}]
[null,"John Deere 640C (Medium SPFH)","Windrow Pickup",11.8,"SPFH attachment",30762,{"$f":"F28*Assumptions!$J$3","v":24609.600000000002},3,{"$f":"G28*Assumptions!$K$3","v":17226.72},{"$f":"0.06*G28*(Q28/1000)^2","v":70.485491271814809},500,850,"John Deere 8600 SPFH NA",0.8,8,9.153939393939396,{"$f":"Assumptions!$G$3/P28","v":218.48516949152537},{"$f":"Assumptions!$B$3*G28/Q28","v":9.010991476363639},11.263739345454551,{"$f":"(G28*SUM(Assumptions!$C$3:$E$3))/Q28","v":2.2527478690909097},22.527478690909099,0.32260995762711853,{"$f":"Assumptions!$F$3","v":20},20.322609957627119,{"$f":"(0.0434*((0.8*D28)/VLOOKUP(M28,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M28,TractorTable[],4,FALSE)","v":9.7880960000000012},{"$f":"(FuelCost*Implements!Y28)","v":24.470240000000004},{"$f":"(VLOOKUP(M28,TractorTable[],18,FALSE))+Z28","v":157.64404000000002},200.49412864853622,21.902496839915564,{"$f":"AC28/Assumptions!$N$3","v":21.902496839915564}]
[null,"John Deere 640C (Small SPFH)","Windrow Pickup",11.8,"SPFH attachment",30762,{"$f":"F29*Assumptions!$J$3","v":24609.600000000002},3,{"$f":"G29*Assumptions!$K$3","v":17226.72},70.485491271814809,500,850,"John Deere 8400 SPFH NA",0.8,8,9.153939393939396,{"$f":"Assumptions!$G$3/P29","v":218.48516949152537},{"$f":"Assumptions!$B$3*G29/Q29","v":9.010991476363639},11.263739345454551,{"$f":"(G29*SUM(Assumptions!$C$3:$E$3))/Q29","v":2.2527478690909097},22.527478690909099,0.32260995762711853,{"$f":"Assumptions!$F$3","v":20},20.322609957627119,{"$f":"(0.0434*((0.8*D29)/VLOOKUP(M29,TractorTable[],4,FALSE))+0.019)*VLOOKUP(M29,TractorTable[],4,FALSE)","v":8.4960959999999996},{"$f":"(FuelCost*Implements!Y29)","v":21.24024},{"$f":"(VLOOKUP(M29,TractorTable[],18,FALSE))+Z29","v":140.36232800000005},183.21241664853625,20.014597952203705,{"$f":"AC29/Assumptions!$N$3","v":20.014597952203705}]

{"sheet":"Scenario","index":4,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[3,10,3,13],[3,6,3,9]]}
[" Cost Scenario"]
[]
[]
[]
[null,"Selected Implement","Implement Type","Cost Per Hour","Cost Per Acre","Cost Per Ton"]
[null,"GF 17012","Tedder",229.00123107762954,8.371906158303295,8.371906158303295]
[null,"KUHN MM 1100","Merger",333.16044355806252,19.087317078847335,19.087317078847335]
[null,"John Deere 640C (Medium SPFH)","Windrow Pickup",200.49412864853622,21.902496839915564,21.902496839915564]
[null,"John Deere 956","Mower ",125.02992514927601,12.703163577358707,12.703163577358707]
[null,null,"TOTALS:",887.69,62.06,62.06]