{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Calculate","Saved1","Saved2","SavedTemp","Compare","Defaults","Machinery"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":1,"defined_names":35,"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":"Calculate","index":0,"n_rows":50,"n_cols":33,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,2,0,6],[41,1,45,12],[2,0,2,14],[1,2,1,3],[1,30,2,30],[1,16,2,16],[1,5,1,6],[1,22,2,22],[18,7,19,13],[5,11,6,11],[5,12,6,12],[4,1,5,1],[7,5,8,5],[5,13,6,13],[4,12,4,13],[4,3,5,3],[4,4,5,4],[4,2,5,2],[7,2,8,2],[14,22,14,23],[5,7,6,7],[5,8,6,8],[4,7,4,11],[5,9,6,9],[5,10,6,10],[15,22,15,23],[4,19,5,19],[7,16,8,16],[7,17,8,17],[7,18,8,18],[7,19,8,19],[4,16,5,16],[4,17,5,17],[4,18,5,18],[41,25,42,25],[41,23,42,23],[41,24,42,24],[7,1,8,1],[7,3,8,3],[7,4,8,4],[7,20,8,20],[8,22,8,23],[7,22,7,23],[13,22,13,23],[12,22,12,23],[11,22,11,23],[10,22,10,23],[19,22,19,23],[41,22,42,22],[35,1,35,4],[32,1,32,4],[29,1,29,4],[20,7,20,8],[21,7,21,8],[22,7,22,8],[23,7,23,8],[25,1,26,4],[25,7,26,12]]}
[null,null,"Operating Scenarios"]
[null,null,"Default Saved",null,null,"Sample",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,"Saved Match Counter  ",{"$f":"IF(OR(Saved1!Y2=0,Saved2!Y2=0),0,1)","v":0},null,null,null,null,null,5]
["Pasture Aeration and Fertilization Payoff Calculator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Saved1!Y2=0,Saved1!C2,IF(Saved2!Y2=0,Saved2!F2))","v":"Sample"}]
[]
[null,"Tractor","Purchase \nPrice","Hours at\nPurchase","Expected\nAnnual Use",null,null,"Benchmark Operation (before aeration &/or gypsum application)",null,null,null,null,"After aeration &/or gypsum application",null,null,null,"Tractor","Purchase Price","Hours @\nPurchase","Expected Annual Use",null,null,"Defaults",null,null,null,null,null,null,null,"Expected Yield Increase","Calculated BE Yield Increase","BE Yield with other values at 0"]
[null,null,null,null,null,null,null,"Operation/\n   Operating Input","Unit","# of Trips/\n           App. Rate","Unit Cost","Total Cost\n($/acre)","# of Trips/\n              App. Rate","Total Cost\n($/acre)",null,null,null,null,null,null,null,null,"Operation/\n   Operating Input",null,"Unit","# of trips/\nQuantity","Unit Cost",null,null,null,0.05,5.3114997133036815E-2]
[null,"2 WD 50",32200,0,600,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B7","v":"2 WD 50"},{"$f":"VLOOKUP(Q7,Defaults!$B$22:$C$29,2,FALSE)","v":32200},{"$f":"VLOOKUP(Q7,Defaults!$B$22:$D$29,3,FALSE)","v":0},{"$f":"VLOOKUP(B7,Defaults!$B$22:$L$29,11,FALSE)","v":600}]
[null,"Implement                    Rent","Width","Speed (mph)","Purchase Price/\nRental Rate","Hours @\nPurchase",null,"Fertilizer Spreader",null,1,null,{"$f":"IF(Q14=TRUE,(E10/C16)*J8+Machinery!$AM$3,Machinery!$AM$3)","v":1.2},{"$f":"+J8+IF(M12>0,1,0)","v":2},{"$f":"IF(Q14=TRUE,(E10/C16)+Machinery!$AM$6,Machinery!$AM$6)*M8","v":2.4},null,null,"Implement","Width (ft)","Speed (mph)","Purchase Price","Hours @\nPurchase",null,"Fertilizer Spreader",null,null,{"$f":"Defaults!$E$5","v":1},{"$f":"\"\"","v":""},null,null,null,"Expected N&P Runoff Reduction","Calculated BE N&P Runoff Reduction","BE N&P with other values at 0"]
[null,null,null,null,null,null,null,"Urea [46-0-0]","lb",65,0.15,{"$f":"J9*K9","v":9.75},{"$f":"J9*IF(OR(M15=0,M15=\"\"),1,(1-B32))","v":64.674999999999997},{"$f":"M9*K9","v":9.7012499999999999},null,null,null,null,null,null,null,null,"Urea [46-0-0]",null,"lb",{"$f":"Defaults!$E$6","v":200},{"$f":"Defaults!F6","v":0.15},null,null,null,5.0000000000000001E-3,-0.1209262942515129]
[null,"Fertilizer Spreader Rental","40 ft",7,0,null,null,"Triple Superphosphate [0-45-0]","lb",0,0.22,0,{"$f":"J10*IF(OR(M15=0,M15=\"\"),1-IF(OR(M12=0,M12=\"\"),0,B35),1-B32-IF(OR(M12=0,M12=\"\"),0,B35))","v":0},{"$f":"M10*K10","v":0},null,null,{"$f":"B10","v":"Fertilizer Spreader Rental"},"40 ft",{"$f":"VLOOKUP(R10,Defaults!$C$32:$I$32,7,FALSE)","v":7},{"$f":"IF(Q14=TRUE,Defaults!C42,VLOOKUP(R10,Defaults!$C$32:$D$32,2,FALSE))","v":0},{"$f":"IF(Q14=TRUE,\"\",0)","v":""},null,"Triple Superphosphate [0-45-0]",null,"lb",{"$f":"Defaults!$E$7","v":110},{"$f":"Defaults!F7","v":0.22}]
[null,"Manure Spreader","Small",5,10266.299999999999,0,null,"Potash [0-0-60]","lb",0,0.15,0,{"$f":"J11*IF(OR(M15=0,M15=\"\"),1,(1-B32))","v":0},{"$f":"M11*K11","v":0},null,null,"Manure Spreader","Small",{"$f":"VLOOKUP(R11,Defaults!$C$33:$I$35,7,FALSE)","v":5},{"$f":"IF(Q15,Defaults!C43,VLOOKUP(R11,Defaults!$C$33:$D$35,2,FALSE))","v":10266.300000000001},{"$f":"IF(Q15=TRUE,\"\",0)","v":0},null,"Potash [0-0-60]",null,"lb",{"$f":"Defaults!$E$8","v":100},{"$f":"Defaults!F8","v":0.15},null,null,null,"Expected P Runoff Reduction","Calculated BE P Runoff Reduction","BE P Runoff with other values at 0"]
[null,"Aerator Rental","10 ft",4,200,null,null,"Gypsum","ton",null,31,"na",0.25,{"$f":"M12*K12","v":7.75},null,null,"Aerator Rental","10 ft",{"$f":"VLOOKUP(R12,Defaults!$C$36:$I$40,7,FALSE)","v":5},{"$f":"IF(Q13=TRUE,Defaults!C41,VLOOKUP(R12,Defaults!$C$36:$D$40,2,FALSE))","v":0},{"$f":"IF(Q13=TRUE,\"\",0)","v":""},null,"Gypsum",null,"ton",{"$f":"Defaults!$E$9","v":1},{"$f":"Defaults!F9","v":31},null,null,null,5.0000000000000001E-3,0.1315358116565172]
[null,null,null,null,null,null,null,"Manure Spreader",null,1,null,{"$f":"IF(Q15=TRUE,(E11/C16)*M13+Machinery!$AM$4,Machinery!$AM$4)","v":7.7200000000000006},{"$f":"J13","v":1},{"$f":"IF(Q15=TRUE,(E11/C16)*M13+Machinery!$AM$4,Machinery!$AM$4)","v":7.7200000000000006},null,null,true,"<< Aerator Rental",null,null,null,null,"Manure Spreader",null,{"$f":"\"\"","v":""},{"$f":"Defaults!$E$10","v":1},{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,"Poultry Litter [3-3-3]","ton",2,20,{"$f":"J14*K14","v":40},{"$f":"J14*IF(OR(M15=0,M15=\"\"),1-IF(OR(M12=0,M12=\"\"),0,B35),1-B32-IF(OR(M12=0,M12=\"\"),0,B35))","v":1.98},{"$f":"M14*K14","v":39.6},null,null,true,"<< Fertilizer Spreader Rental",null,null,null,null,"Poultry Litter [3-3-3]",null,"ton",{"$f":"Defaults!$E$11","v":1},{"$f":"Defaults!F11","v":20}]
[null,null,null,null,null,null,null,"Aerator",null,null,null,null,1,{"$f":"IF(Q13=TRUE,(E12/C16)*M15+Machinery!$AM$5,Machinery!$AM$5)","v":8.3066666666666649},null,null,false,"<< Manure Spreader Rental",null,null,null,null,"Aerator",null,{"$f":"\"\"","v":""},{"$f":"Defaults!$E$12","v":1},{"$f":"\"\"","v":""}]
[null,"Area affected",300,"in acres"]
[null,"Exp. Hay Price",30,"per 1,200 lb. bale",null,null,null,null,null,null,"Operating Interest ($/acre)",{"$f":"((SUM(L8:L12)+SUM(L13:L14))-(IFERROR(Machinery!$AH$3/Machinery!$R$3,0)*J8+IFERROR(Machinery!$AH$4/Machinery!$R$4,0)*J13))/2*C23","v":1.3133483555242005},null,{"$f":"((SUM(N8:N12)+SUM(N13:N14)+N15)-(+IFERROR(Machinery!$AH$6/Machinery!$R$6,0)*J8+IFERROR(Machinery!$AH$4/Machinery!$R$4,0)*J13+IFERROR(Machinery!$AH$5/Machinery!$R$5,0)*M15))/2*C23","v":1.6792432915639541},null,null,"Exp. Hay Price",{"$f":"Defaults!I6","v":35},"per bale"]
[null,"Exp. Hay Yields",5,"bales/acre",null,null,null,null,null,null,"Total Specified Expenses ($/acre)",{"$f":"SUM(L8:L14)+L17","v":59.9833483555242},null,{"$f":"SUM(N8:N17)","v":77.157159958230608},null,null,"Exp. Hay Yields",{"$f":"Defaults!I9","v":5},"bales/acre"]
[null,"Fuel Cost",1.75,"per gallon",null,null,null,"Check to convert custom blend fertilizers to urea, phosphate, and potash quanity and price equivalents:",null,null,null,null,null,null,null,null,"Fuel Cost",{"$f":"Defaults!L11","v":1.75},"per gallon"]
[null,"Operator Labor",13.14,"per hour",null,null,null,null,null,null,null,null,null,null,null,null,"Operator Labor",{"$f":"Defaults!M3","v":13.14},"per hour",null,null,null,"Apply custom fertilizer price and quantity",null,false]
[null,"Hired Labor",9.06,"per hour",null,null,null,"Custom Fertilizer Name",null,"N","P2O5","K2O","App. Rate (lb/acre)","Cost ($/lb)","Total Cost",null,"Hired Labor",{"$f":"Defaults!M4","v":9.06},"per hour",null,null,null,"Fertilizer Equivalent","N","P2O5","K2O","App. Rate (lbs)","Unit Cost ($/lb)","Cost ($/acre)"]
[null,"Equipment Capital Recovery Rate",0.06,"annual",null,null,null,"Ammonium Nitrate",null,34,0,0,0,0.28000000000000003,{"$f":"M22*N22","v":0},null,"Ammoritization",{"$f":"Defaults!M7","v":0.06},null,null,null,null,{"$f":"$H$9","v":"Urea [46-0-0]"},46,0,0,{"$f":"SUM(AA26,AA30,AA34)","v":7.0652173913043477},{"$f":"IFERROR((AC26+AC30+AC34)/(AA26+AA30+AA34),0)","v":0.23589743589743589},{"$f":"AA22*AB22","v":1.6666666666666665}]
[null,"Operating Interest",4.7500000000000001E-2,"annual",null,null,null,"DAP",null,18,46,0,0,0.32,{"$f":"M23*N23","v":0},null,"Operating",{"$f":"Defaults!M8","v":4.7500000000000001E-2},null,null,null,null,{"$f":"$H$10","v":"Triple Superphosphate [0-45-0]"},0,45,0,{"$f":"SUM(AA27,AA31,AA35)","v":7.2222222222222223},{"$f":"IFERROR((AC27+AC31+AC35)/(AA27+AA31+AA35),0)","v":0.23076923076923075},{"$f":"AA23*AB23","v":1.6666666666666665}]
[null,null,null,null,null,null,null,"Custom Blend",null,13,13,13,25,0.2,{"$f":"M24*N24","v":5},null,null,null,null,null,null,null,{"$f":"$H$11","v":"Potash [0-0-60]"},0,0,60,{"$f":"SUM(AA28,AA32,AA36)","v":5.416666666666667},{"$f":"IFERROR((AC28+AC32+AC36)/(AA28+AA32+AA36),0)","v":0.30769230769230765},{"$f":"AA24*AB24","v":1.6666666666666665}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H22","v":"Ammonium Nitrate"},"N","P2O5","K2O","App. Rate (lbs)","Unit Cost ($/lb)","Cost ($/acre)"]
[null,"Breakeven Analysis",null,null,null,null,null,"Profitability and GHG Implications of Modified Practices",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$H$9","v":"Urea [46-0-0]"},{"$f":"X22","v":46},{"$f":"Y22","v":0},0,{"$f":"IFERROR(($M$22*$J$22/100)/(X26/100),0)","v":0},{"$f":"IFERROR(AC26/AA26,0)","v":0},{"$f":"IFERROR(J22/SUM(J22:L22)*O22,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$H$10","v":"Triple Superphosphate [0-45-0]"},{"$f":"X23","v":0},45,0,{"$f":"IFERROR(($M$22*$K$22/100)/(Y27/100),0)","v":0},{"$f":"IFERROR(AC27/AA27,0)","v":0},{"$f":"IFERROR(K22/SUM(J22:L22)*O22,0)","v":0}]
[null,"Expected Yield Increase",null,null,null,null,null,null,null,null,null,"Benchmark total specified expenses ($/acre)",{"$f":"$L$18","v":59.9833483555242},null,null,null,null,null,null,null,null,null,{"$f":"$H$11","v":"Potash [0-0-60]"},{"$f":"X24","v":0},0,60,{"$f":"IFERROR(($M$22*$L$22/100)/(Z28/100),0)","v":0},{"$f":"IFERROR(AC28/AA28,0)","v":0},{"$f":"IFERROR(L22/SUM(J22:L22)*O22,0)","v":0}]
[null,0.05,null,null,null,null,null,null,null,null,null,"Modified total specified expenses ($/acre)",{"$f":"$N$18","v":77.157159958230608},null,null,null,null,null,null,null,null,null,{"$f":"H23","v":"DAP"},"N","P2O5","K2O","App. Rate (lbs)","Unit Cost ($/lb)","Cost ($/acre)"]
[null,{"$f":"IF(AND(OR(M15=0,M15=\"\"),OR(M12=0,M12=\"\")),\"No yield increase when no aeration is not in use and gypsum is not applied\",\"\")","v":""},null,null,null,null,null,null,null,null,null,"Expected Yield Increase (bales/acre)",{"$f":"$C$18*IF(OR(M15=0,M15=\"\"),0,$B$29)","v":0.25},null,null,null,null,null,null,null,null,null,{"$f":"$H$9","v":"Urea [46-0-0]"},{"$f":"X26","v":46},{"$f":"Y26","v":0},0,{"$f":"IFERROR(($M$23*$J$23/100)/(X30/100),0)","v":0},{"$f":"IFERROR(AC30/AA30,0)","v":0},{"$f":"IFERROR(J23/SUM(J23:L23)*O23,0)","v":0}]
[null,"Expected N & P Runoff Reduction from Aeration",null,null,null,null,null,null,null,null,null,"Expected Revenue from Yield Increase ($/acre)",{"$f":"M30*$C$17","v":7.5},null,null,null,null,null,null,null,null,null,{"$f":"$H$10","v":"Triple Superphosphate [0-45-0]"},{"$f":"X27","v":0},45,0,{"$f":"IFERROR(($M$23*$K$23/100)/(Y31/100),0)","v":0},{"$f":"IFERROR(AC31/AA31,0)","v":0},{"$f":"IFERROR(K23/SUM(J23:L23)*O23,0)","v":0}]
[null,5.0000000000000001E-3,null,null,null,null,null,null,null,null,null,"Total Expected Revenue from Yield Increase",{"$f":"M31*$C$16","v":2250},null,null,null,null,null,null,null,null,null,{"$f":"$H$11","v":"Potash [0-0-60]"},{"$f":"X28","v":0},0,60,{"$f":"IFERROR(($M$23*$L$23/100)/(Z32/100),0)","v":0},{"$f":"IFERROR(AC32/AA32,0)","v":0},{"$f":"IFERROR(L23/SUM(J23:L23)*O23,0)","v":0}]
[null,{"$f":"IF(OR(M15=0,M15=\"\"),\"No N & P reduction from aeration when not in use\",\"\")","v":""},null,null,null,null,null,null,null,null,null,"Expected Cost Savings from N Runoff ($/acre)",{"$f":"$L$9-$N$9+$L$14*IF(OR(M15=0,M15=\"\"),0,B32/2)","v":0.14875000000000008},null,null,null,null,null,null,null,null,null,{"$f":"H24","v":"Custom Blend"},"N","P2O5","K2O","App. Rate (lbs)","Unit Cost ($/lb)","Cost ($/acre)"]
[null,"Expected P Runoff Reduction from Gypsum",null,null,null,null,null,null,null,null,null,"Expected Cost Savings from P Runoff ($/acre)",{"$f":"$L$10-$N$10+$L$14*IF(OR(M12=0,M12=\"\"),IF(OR(M15=0,M15=\"\"),0,B32/2),B35+IF(OR(M15=0,M15=\"\"),0,B32/2))","v":0.3},null,null,null,null,null,null,null,null,null,{"$f":"$H$9","v":"Urea [46-0-0]"},{"$f":"X30","v":46},{"$f":"Y30","v":0},0,{"$f":"IFERROR(($M$24*$J$24/100)/(X34/100),0)","v":7.0652173913043477},{"$f":"IFERROR(AC34/AA34,0)","v":0.23589743589743589},{"$f":"IFERROR(J24/SUM(J24:L24)*O24,0)","v":1.6666666666666665}]
[null,5.0000000000000001E-3,null,null,null,null,null,null,null,null,null,"Expected profitability of aeration &/or gypsum application ($/acre)",{"$f":"(M28-M29)+M31+M33+M34","v":-9.2250616027064076},null,null,null,null,null,null,null,null,null,{"$f":"$H$10","v":"Triple Superphosphate [0-45-0]"},{"$f":"X31","v":0},45,0,{"$f":"IFERROR(($M$24*$K$24/100)/(Y35/100),0)","v":7.2222222222222223},{"$f":"IFERROR(AC35/AA35,0)","v":0.23076923076923075},{"$f":"IFERROR(K24/SUM(J24:L24)*O24,0)","v":1.6666666666666665}]
[null,{"$f":"IF(OR(M12=0,M12=\"\"),\"No additional P reduction from gypsum when not applied\",\"\")","v":""},null,null,null,null,null,null,null,null,null,"Farm Total ($)",{"$f":"M35*$C$16","v":-2767.5184808119225},null,null,null,null,null,null,null,null,null,{"$f":"$H$11","v":"Potash [0-0-60]"},{"$f":"X32","v":0},0,60,{"$f":"IFERROR(($M$24*$L$24/100)/(Z36/100),0)","v":5.416666666666667},{"$f":"IFERROR(AC36/AA36,0)","v":0.30769230769230765},{"$f":"IFERROR(L24/SUM(J24:L24)*O24,0)","v":1.6666666666666665}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Expected Decrease in CEQ GHG Emissions (lbs/bale)",{"$f":"Y50/C18-Z50/(C18+M30)","v":8.7778603668691346}]
[null,null,null,null,null,null,null,null,null,null,null,"Farm Total Expected Decrease in CEQ GHG Emissions (tons)",{"$f":"+(Y50-Z50)*C16/2000","v":-1.3962105257893653}]
[]
[]
[null,"Disclaimer:  The information provided within represents estimates that are a result of a set of complex calculations that are described in more detail in the accompanying publication.  Changes in parameter values and its implications on returns and GHG emissions are estimates and the user should use their own reasonable judgment to reflect whether the direction of change in returns and GHG emissions is appropriate before acting on the results.  As such, this software is provided ‘as is’ and without warranties as to performance of merchantability.  Further, statements may have been made to you about this software.  Any such statements do not constitute warranties and shall not be relied on by the user in deciding whether to use the program or act on its results.  This program is provided without any expressed or implied warranties whatsoever.  Because the diversity of conditions and hardware under which this program may be used, no warranty of merchantability or warranty of fitness for a particular purpose is offered.  The user is advised to test the program thoroughly before relying on it.  The user assumes the entire risk of using the program.  The University of Arkansas will not be liable for any claim or damage brought against the user by any third party, nor will the University of Arkansas be liable for any consequential, indirect or special damages suffered by the user as a result of the software.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Input","lbs of C Eq. per Input Unit","Before\nAeration","After\nAeration"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urea [46-0-0]",{"$f":"Defaults!L15","v":1.2081676585230345},{"$f":"J9*$X44","v":78.530897803997249},{"$f":"M9*$X44","v":78.13824331497726}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Triple Superphosphate [0-45-0]",{"$f":"Defaults!L16","v":0.63244783378866498},{"$f":"J10*$X45","v":0},{"$f":"M10*$X45","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Potash [0-0-60]",{"$f":"Defaults!L17","v":0.10836075979937405},{"$f":"J11*$X46","v":0},{"$f":"M11*$X46","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Poultry Litter [3-3-3]",{"$f":"Defaults!L18","v":0.25732646103896106},{"$f":"J14*$X47*2000","v":1029.3058441558442},{"$f":"M14*$X47*2000","v":1019.0127857142859}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gypsum",{"$f":"Defaults!L19","v":2.9597671423259329E-2},null,{"$f":"+X48*M12*2000","v":14.798835711629664}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuel use change",{"$f":"0.893*3.78/0.453592","v":7.4417979153071485},null,{"$f":"+Machinery!AE5/Machinery!R5*X49*M15","v":5.194947390877874}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exp. Carbon Footprint (lbs/acre)",{"$f":"SUM(Y44:Y47)","v":1107.8367419598414},{"$f":"SUM(Z44:Z49)","v":1117.1448121317705}]

{"sheet":"Saved1","index":1,"n_rows":39,"n_cols":50,"rows_kept":39,"cut":false,"hidden":false,"merged":[[20,7,20,8],[21,7,21,8],[22,7,22,8],[23,7,23,8],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[7,5,8,5],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,7,4,11],[5,7,6,7],[5,8,6,8],[5,9,6,9],[5,10,6,10],[5,13,6,13],[21,32,21,33],[22,32,22,33],[23,32,23,33],[4,12,4,13],[5,12,6,12]]}
[]
[null,null,"Default Saved",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"saved match counter",{"$f":"SUM(AA2:AX35)","v":14},null,null,{"$f":"IF(C2=Calculate!C2,0,1)","v":0}]
[]
[]
[null,{"$f":"Calculate!B5","v":"Tractor"},{"$f":"Calculate!C5","v":"Purchase \nPrice"},{"$f":"Calculate!D5","v":"Hours at\nPurchase"},{"$f":"Calculate!E5","v":"Expected\nAnnual Use"},null,null,"Benchmark Operation (before aeration)",null,null,null,null,"After Aeration"]
[null,null,null,null,null,null,null,"Operation/\n   Operating Input","Unit","# of Trips/\nApplication Rate","Unit Cost",null,"# of Trips/\nApplication Rate","Total Cost\n($/acre)"]
[null,"MFWD 50",39100,0,600,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B7=Calculate!B7,0,1)","v":1},{"$f":"IF(C7=Calculate!C7,0,1)","v":1},{"$f":"IF(D7=Calculate!D7,0,1)","v":0},{"$f":"IF(E7=Calculate!E7,0,1)","v":0}]
[null,{"$f":"Calculate!B8","v":"Implement                    Rent"},{"$f":"Calculate!C8","v":"Width"},{"$f":"Calculate!D8","v":"Speed (mph)"},"Purchase Price/\nRental Rate",{"$f":"Calculate!F8","v":"Hours @\nPurchase"},null,"Fertilizer Spreader",null,1,null,null,{"$f":"+J8+IF(M12>0,1,0)","v":2},5.82,null,null,false,"<< Modified Fert trips",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J8=Calculate!J8,0,1)","v":0}]
[null,null,null,null,null,null,null,"Urea [46-0-0]","lb",200,0.15,null,{"$f":"J9*IF(OR(M15=0,M15=\"\"),1,(1-B32))","v":199},{"$f":"M9*K9","v":29.849999999999998},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J9=Calculate!J9,0,1)","v":1},{"$f":"IF(K9=Calculate!K9,0,1)","v":0}]
[null,"Fertilizer Spreader","40 ft",7,11800,0,null,"Triple Superphosphate [0-45-0]","lb",110,0.22,null,{"$f":"J10*IF(OR(M15=0,M15=\"\"),1-IF(OR(M12=0,M12=\"\"),0,B35),1-B32-IF(OR(M12=0,M12=\"\"),0,B35))","v":108.9},{"$f":"M10*K10","v":23.958000000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C10=Calculate!C10,0,1)","v":0},{"$f":"IF(D10=Calculate!D10,0,1)","v":0},{"$f":"IF(E10=Calculate!E10,0,1)","v":1},{"$f":"IF(F10=Calculate!F10,0,1)","v":0},null,null,null,{"$f":"IF(J10=Calculate!J10,0,1)","v":1},{"$f":"IF(K10=Calculate!K10,0,1)","v":0}]
[null,"Manure Spreader","Small",5,10266.299999999999,0,null,"Potash [0-0-60]","lb",100,0.15,null,{"$f":"J11*IF(OR(M15=0,M15=\"\"),1,(1-B32))","v":99.5},{"$f":"M11*K11","v":14.924999999999999},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C11=Calculate!C11,0,1)","v":0},{"$f":"IF(D11=Calculate!D11,0,1)","v":0},{"$f":"IF(E11=Calculate!E11,0,1)","v":0},{"$f":"IF(F11=Calculate!F11,0,1)","v":0},null,null,null,{"$f":"IF(J11=Calculate!J11,0,1)","v":1},{"$f":"IF(K11=Calculate!K11,0,1)","v":0}]
[null,"Aerator Rental","8 ft",5,7860.6,0,null,"Gypsum","ton",null,31,null,1,{"$f":"M12*K12","v":31},null,null,"Rentals",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C12=Calculate!C12,0,1)","v":1},{"$f":"IF(D12=Calculate!D12,0,1)","v":1},{"$f":"IF(E12=Calculate!E12,0,1)","v":1},{"$f":"IF(F12=Calculate!F12,0,1)","v":0},null,null,null,{"$f":"IF(M12=Calculate!M12,0,1)","v":1},{"$f":"IF(K12=Calculate!K12,0,1)","v":0}]
[null,null,null,null,null,null,null,"Manure Spreader",null,1,null,null,{"$f":"J13","v":1},{"$f":"IF(Q15=TRUE,(E11/C16)*M13+Machinery!$AM$4,Machinery!$AM$4)","v":7.7200000000000006},null,null,false,"<< Aerator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J13=Calculate!J13,0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Q13=Calculate!Q13,0,1)","v":1}]
[null,null,null,null,null,null,null,"Poultry Litter [3-3-3]","ton",1,20,null,{"$f":"J14*IF(OR(M15=0,M15=\"\"),1-IF(OR(M12=0,M12=\"\"),0,B35),1-B32-IF(OR(M12=0,M12=\"\"),0,B35))","v":0.99},{"$f":"M14*K14","v":19.8},null,null,false,"<< Fertilizer Spreader",null,null,null,null,null,null,null,null,null,{"$f":"IF(C16=Calculate!C16,0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(J14=Calculate!J14,0,1)","v":1},{"$f":"IF(K14=Calculate!K14,0,1)","v":0},null,null,null,null,null,{"$f":"IF(Q14=Calculate!Q14,0,1)","v":1}]
[null,null,null,null,null,null,null,"Aerator",null,null,null,null,1,{"$f":"IF(Q13=TRUE,(E12/C16)*M15+Machinery!$AM$5,Machinery!$AM$5)","v":7.6399999999999988},null,null,false,"<< Manure Spreader",null,null,null,null,null,null,null,null,null,{"$f":"IF(C17=Calculate!C17,0,1)","v":1},null,null,null,null,null,null,null,null,null,{"$f":"IF(M15=Calculate!M15,0,1)","v":0},null,null,null,{"$f":"IF(Q15=Calculate!Q15,0,1)","v":0}]
[null,{"$f":"Calculate!B16","v":"Area affected"},300,{"$f":"Calculate!D16","v":"in acres"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C18=Calculate!C18,0,1)","v":0}]
[null,{"$f":"Calculate!B17","v":"Exp. Hay Price"},35,{"$f":"Calculate!D17","v":"per 1,200 lb. bale"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C19=Calculate!C19,0,1)","v":0}]
[null,{"$f":"Calculate!B18","v":"Exp. Hay Yields"},5,{"$f":"Calculate!D18","v":"bales/acre"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C20=Calculate!C20,0,1)","v":0}]
[null,{"$f":"Calculate!B19","v":"Fuel Cost"},1.75,{"$f":"Calculate!D19","v":"per gallon"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C21=Calculate!C21,0,1)","v":0}]
[null,{"$f":"Calculate!B20","v":"Operator Labor"},13.14,{"$f":"Calculate!D20","v":"per hour"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"custom fertilizer",false,null,null,{"$f":"IF(C22=Calculate!C22,0,1)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y20=Calculate!Y20,0,1)","v":0}]
[null,{"$f":"Calculate!B21","v":"Hired Labor"},9.06,{"$f":"Calculate!D21","v":"per hour"},null,null,null,"Custom Fertilizer Name",null,"N","P2O5","K2O","App. Rate (lb/acre)","Cost ($/lb)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C23=Calculate!C23,0,1)","v":0}]
[null,{"$f":"Calculate!B22","v":"Equipment Capital Recovery Rate"},0.06,null,null,null,null,"Ammonium Nitrate",null,34,0,0,0,0.28000000000000003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H22=Calculate!H22,0,1)","v":0},null,{"$f":"IF(J22=Calculate!J22,0,1)","v":0},{"$f":"IF(K22=Calculate!K22,0,1)","v":0},{"$f":"IF(L22=Calculate!L22,0,1)","v":0},{"$f":"IF(M22=Calculate!M22,0,1)","v":0},{"$f":"IF(N22=Calculate!N22,0,1)","v":0}]
[null,{"$f":"Calculate!B23","v":"Operating Interest"},4.7500000000000001E-2,null,null,null,null,"DAP",null,18,46,0,0,0.32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H23=Calculate!H23,0,1)","v":0},null,{"$f":"IF(J23=Calculate!J23,0,1)","v":0},{"$f":"IF(K23=Calculate!K23,0,1)","v":0},{"$f":"IF(L23=Calculate!L23,0,1)","v":0},{"$f":"IF(M23=Calculate!M23,0,1)","v":0},{"$f":"IF(N23=Calculate!N23,0,1)","v":0}]
[null,null,null,null,null,null,null,"Custom Blend",null,13,13,13,25,0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H24=Calculate!H24,0,1)","v":0},null,{"$f":"IF(J24=Calculate!J24,0,1)","v":0},{"$f":"IF(K24=Calculate!K24,0,1)","v":0},{"$f":"IF(L24=Calculate!L24,0,1)","v":0},{"$f":"IF(M24=Calculate!M24,0,1)","v":0},{"$f":"IF(N24=Calculate!N24,0,1)","v":0}]
[]
[]
[]
[null,{"$f":"Calculate!B28","v":"Expected Yield Increase"}]
[null,0.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B29=Calculate!B29,0,1)","v":0}]
[]
[null,{"$f":"Calculate!B31","v":"Expected N & P Runoff Reduction from Aeration"}]
[null,5.0000000000000001E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B32=Calculate!B32,0,1)","v":0}]
[]
[null,{"$f":"Calculate!B34","v":"Expected P Runoff Reduction from Gypsum"}]
[null,5.0000000000000001E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B35=Calculate!B35,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculate!L36","v":"Farm Total ($)"},-10112.370000000001]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculate!L38","v":"Expected Decrease in CEQ GHG Emissions (lbs/bale)"},-2.9430725308697561]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculate!L39","v":"Farm Total Expected Decrease in CEQ GHG Emissions (tons)"},-8.5928580541540782]

{"sheet":"Saved2","index":2,"n_rows":39,"n_cols":50,"rows_kept":39,"cut":false,"hidden":false,"merged":[[7,1,8,1],[7,2,8,2],[22,7,22,8],[23,7,23,8],[7,3,8,3],[7,4,8,4],[7,5,8,5],[20,7,20,8],[21,7,21,8],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,7,4,11],[5,7,6,7],[5,8,6,8],[5,9,6,9],[5,10,6,10],[5,13,6,13],[21,32,21,33],[22,32,22,33],[23,32,23,33],[4,12,4,13],[5,12,6,12]]}
[]
[null,null,null,null,null,"Sample",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"saved match counter",{"$f":"SUM(AA2:AX35)","v":0},null,null,{"$f":"IF(F2=Calculate!F2,0,1)","v":0}]
[]
[]
[null,{"$f":"Calculate!B5","v":"Tractor"},{"$f":"Calculate!C5","v":"Purchase \nPrice"},{"$f":"Calculate!D5","v":"Hours at\nPurchase"},{"$f":"Calculate!E5","v":"Expected\nAnnual Use"},null,null,"Benchmark Operation (before aeration)",null,null,null,null,"After Aeration"]
[null,null,null,null,null,null,null,"Operation/\n   Operating Input","Unit","# of Trips/\nApplication Rate","Unit Cost",null,"# of Trips/\nApplication Rate","Total Cost\n($/acre)"]
[null,"2 WD 50",32200,0,600,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B7=Calculate!B7,0,1)","v":0},{"$f":"IF(C7=Calculate!C7,0,1)","v":0},{"$f":"IF(D7=Calculate!D7,0,1)","v":0},{"$f":"IF(E7=Calculate!E7,0,1)","v":0}]
[null,{"$f":"Calculate!B8","v":"Implement                    Rent"},{"$f":"Calculate!C8","v":"Width"},{"$f":"Calculate!D8","v":"Speed (mph)"},"Purchase Price/\nRental Rate",{"$f":"Calculate!F8","v":"Hours @\nPurchase"},null,"Fertilizer Spreader",null,1,null,null,{"$f":"+J8+IF(M12>0,1,0)","v":2},2.4,null,null,false,"<< Modified Fert trips",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J8=Calculate!J8,0,1)","v":0}]
[null,null,null,null,null,null,null,"Urea [46-0-0]","lb",65,0.15,null,{"$f":"J9*IF(OR(M15=0,M15=\"\"),1,(1-B32))","v":64.674999999999997},{"$f":"M9*K9","v":9.7012499999999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J9=Calculate!J9,0,1)","v":0},{"$f":"IF(K9=Calculate!K9,0,1)","v":0}]
[null,"Fertilizer Spreader Rental","40 ft",7,0,null,null,"Triple Superphosphate [0-45-0]","lb",0,0.22,null,{"$f":"J10*IF(OR(M15=0,M15=\"\"),1-IF(OR(M12=0,M12=\"\"),0,B35),1-B32-IF(OR(M12=0,M12=\"\"),0,B35))","v":0},{"$f":"M10*K10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C10=Calculate!C10,0,1)","v":0},{"$f":"IF(D10=Calculate!D10,0,1)","v":0},{"$f":"IF(E10=Calculate!E10,0,1)","v":0},{"$f":"IF(F10=Calculate!F10,0,1)","v":0},null,null,null,{"$f":"IF(J10=Calculate!J10,0,1)","v":0},{"$f":"IF(K10=Calculate!K10,0,1)","v":0}]
[null,"Manure Spreader","Small",5,10266.299999999999,0,null,"Potash [0-0-60]","lb",0,0.15,null,{"$f":"J11*IF(OR(M15=0,M15=\"\"),1,(1-B32))","v":0},{"$f":"M11*K11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C11=Calculate!C11,0,1)","v":0},{"$f":"IF(D11=Calculate!D11,0,1)","v":0},{"$f":"IF(E11=Calculate!E11,0,1)","v":0},{"$f":"IF(F11=Calculate!F11,0,1)","v":0},null,null,null,{"$f":"IF(J11=Calculate!J11,0,1)","v":0},{"$f":"IF(K11=Calculate!K11,0,1)","v":0}]
[null,"Aerator Rental","10 ft",4,200,null,null,"Gypsum","ton",null,31,null,0.25,{"$f":"M12*K12","v":7.75},null,null,"Rentals",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C12=Calculate!C12,0,1)","v":0},{"$f":"IF(D12=Calculate!D12,0,1)","v":0},{"$f":"IF(E12=Calculate!E12,0,1)","v":0},{"$f":"IF(F12=Calculate!F12,0,1)","v":0},null,null,null,{"$f":"IF(M12=Calculate!M12,0,1)","v":0},{"$f":"IF(K12=Calculate!K12,0,1)","v":0}]
[null,null,null,null,null,null,null,"Manure Spreader",null,1,null,null,{"$f":"J13","v":1},{"$f":"IF(Q15=TRUE,(E11/C16)*M13+Machinery!$AM$4,Machinery!$AM$4)","v":7.7200000000000006},null,null,true,"<< Aerator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J13=Calculate!J13,0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Q13=Calculate!Q13,0,1)","v":0}]
[null,null,null,null,null,null,null,"Poultry Litter [3-3-3]","ton",2,20,null,{"$f":"J14*IF(OR(M15=0,M15=\"\"),1-IF(OR(M12=0,M12=\"\"),0,B35),1-B32-IF(OR(M12=0,M12=\"\"),0,B35))","v":1.98},{"$f":"M14*K14","v":39.6},null,null,true,"<< Fertilizer Spreader",null,null,null,null,null,null,null,null,null,{"$f":"IF(C16=Calculate!C16,0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(J14=Calculate!J14,0,1)","v":0},{"$f":"IF(K14=Calculate!K14,0,1)","v":0},null,null,null,null,null,{"$f":"IF(Q14=Calculate!Q14,0,1)","v":0}]
[null,null,null,null,null,null,null,"Aerator",null,null,null,null,1,{"$f":"IF(Q13=TRUE,(E12/C16)*M15+Machinery!$AM$5,Machinery!$AM$5)","v":8.3066666666666649},null,null,false,"<< Manure Spreader",null,null,null,null,null,null,null,null,null,{"$f":"IF(C17=Calculate!C17,0,1)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(M15=Calculate!M15,0,1)","v":0},null,null,null,{"$f":"IF(Q15=Calculate!Q15,0,1)","v":0}]
[null,{"$f":"Calculate!B16","v":"Area affected"},300,{"$f":"Calculate!D16","v":"in acres"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C18=Calculate!C18,0,1)","v":0}]
[null,{"$f":"Calculate!B17","v":"Exp. Hay Price"},30,{"$f":"Calculate!D17","v":"per 1,200 lb. bale"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C19=Calculate!C19,0,1)","v":0}]
[null,{"$f":"Calculate!B18","v":"Exp. Hay Yields"},5,{"$f":"Calculate!D18","v":"bales/acre"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C20=Calculate!C20,0,1)","v":0}]
[null,{"$f":"Calculate!B19","v":"Fuel Cost"},1.75,{"$f":"Calculate!D19","v":"per gallon"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C21=Calculate!C21,0,1)","v":0}]
[null,{"$f":"Calculate!B20","v":"Operator Labor"},13.14,{"$f":"Calculate!D20","v":"per hour"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"custom fertilizer",false,null,null,{"$f":"IF(C22=Calculate!C22,0,1)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y20=Calculate!Y20,0,1)","v":0}]
[null,{"$f":"Calculate!B21","v":"Hired Labor"},9.06,{"$f":"Calculate!D21","v":"per hour"},null,null,null,"Custom Fertilizer Name",null,"N","P2O5","K2O","App. Rate (lb/acre)","Cost ($/lb)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C23=Calculate!C23,0,1)","v":0}]
[null,{"$f":"Calculate!B22","v":"Equipment Capital Recovery Rate"},0.06,null,null,null,null,"Ammonium Nitrate",null,34,0,0,0,0.28000000000000003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H22=Calculate!H22,0,1)","v":0},null,{"$f":"IF(J22=Calculate!J22,0,1)","v":0},{"$f":"IF(K22=Calculate!K22,0,1)","v":0},{"$f":"IF(L22=Calculate!L22,0,1)","v":0},{"$f":"IF(M22=Calculate!M22,0,1)","v":0},{"$f":"IF(N22=Calculate!N22,0,1)","v":0}]
[null,{"$f":"Calculate!B23","v":"Operating Interest"},4.7500000000000001E-2,null,null,null,null,"DAP",null,18,46,0,0,0.32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H23=Calculate!H23,0,1)","v":0},null,{"$f":"IF(J23=Calculate!J23,0,1)","v":0},{"$f":"IF(K23=Calculate!K23,0,1)","v":0},{"$f":"IF(L23=Calculate!L23,0,1)","v":0},{"$f":"IF(M23=Calculate!M23,0,1)","v":0},{"$f":"IF(N23=Calculate!N23,0,1)","v":0}]
[null,null,null,null,null,null,null,"Custom Blend",null,13,13,13,25,0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H24=Calculate!H24,0,1)","v":0},null,{"$f":"IF(J24=Calculate!J24,0,1)","v":0},{"$f":"IF(K24=Calculate!K24,0,1)","v":0},{"$f":"IF(L24=Calculate!L24,0,1)","v":0},{"$f":"IF(M24=Calculate!M24,0,1)","v":0},{"$f":"IF(N24=Calculate!N24,0,1)","v":0}]
[]
[]
[]
[null,{"$f":"Calculate!B28","v":"Expected Yield Increase"}]
[null,0.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B29=Calculate!B29,0,1)","v":0}]
[]
[null,{"$f":"Calculate!B31","v":"Expected N & P Runoff Reduction from Aeration"}]
[null,5.0000000000000001E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B32=Calculate!B32,0,1)","v":0}]
[]
[null,{"$f":"Calculate!B34","v":"Expected P Runoff Reduction from Gypsum"}]
[null,5.0000000000000001E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B35=Calculate!B35,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculate!L36","v":"Farm Total ($)"},-2767.52]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculate!L38","v":"Expected Decrease in CEQ GHG Emissions (lbs/bale)"},8.7778603668691346]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculate!L39","v":"Farm Total Expected Decrease in CEQ GHG Emissions (tons)"},-1.3962105257893653]

{"sheet":"SavedTemp","index":3,"n_rows":39,"n_cols":25,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Default Saved",null,null,"Sample",null,null,null,"Karen"]
[]
[]
[]
[]
[null,"2 WD 50",32200,0,600]
[null,null,null,null,null,null,null,null,null,1,null,null,{"$f":"+J8+IF(M12>0,1,0)","v":1},null,null,null,false]
[null,null,null,null,null,null,null,null,null,65,0.15,null,64.674999999999997,9.6999999999999993]
[null,"Fertilizer Spreader Rental","40 ft",7,0,null,null,null,null,0,0.22,null,0,0]
[null,"Manure Spreader","Small",5,10266.299999999999,0,null,null,null,0,0.15,null,0,0]
[null,"Aerator Rental","10 ft",4,200,null,null,null,null,null,31,null,0,0]
[null,null,null,null,null,null,null,null,null,1,null,null,1,7.72,null,null,true]
[null,null,null,null,null,null,null,null,null,2,20,null,1.99,39.799999999999997,null,null,true]
[null,null,null,null,null,null,null,null,null,null,null,null,1,8.31,null,null,false]
[null,null,300]
[null,null,30]
[null,null,5]
[null,null,1.75]
[null,null,13.14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,9.06]
[null,null,0.06,null,null,null,null,"Ammonium Nitrate",null,34,0,0,0,0.28000000000000003]
[null,null,4.7500000000000001E-2,null,null,null,null,"DAP",null,18,46,0,0,0.32]
[null,null,null,null,null,null,null,"Custom Blend",null,13,13,13,25,0.2]
[]
[]
[]
[]
[null,0.05]
[]
[]
[null,5.0000000000000001E-3]
[]
[]
[null,5.0000000000000001E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,-140.16999999999999]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,10.616394936554968]
[null,null,null,null,null,null,null,null,null,null,null,null,5.1635447838225448E-2]

{"sheet":"Compare","index":4,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[[6,6,6,8],[2,0,2,8],[6,2,6,4],[40,1,46,7]]}
[]
[]
["Pasture Aeration and Fertilization Payoff Comparison"]
[]
[]
[]
[null,"Operation Parameters",{"$f":"Saved1!C2","v":"Default Saved"},null,null,null,{"$f":"Saved2!F2","v":"Sample"}]
[null,{"$f":"Saved1!B16","v":"Area affected"},{"$f":"Saved1!C16","v":300},{"$f":"Saved1!D16","v":"in acres"},null,null,{"$f":"Saved2!C16","v":300},{"$f":"Saved2!D16","v":"in acres"},null,null,null,"Yes"]
[null,{"$f":"Saved1!B17","v":"Exp. Hay Price"},{"$f":"Saved1!C17","v":35},{"$f":"Saved1!D17","v":"per 1,200 lb. bale"},null,null,{"$f":"Saved2!C17","v":30},{"$f":"Saved2!D17","v":"per 1,200 lb. bale"},null,null,null,"No"]
[null,{"$f":"Saved1!B18","v":"Exp. Hay Yields"},{"$f":"Saved1!C18","v":5},{"$f":"Saved1!D18","v":"bales/acre"},null,null,{"$f":"Saved2!C18","v":5},{"$f":"Saved2!D18","v":"bales/acre"}]
[null,{"$f":"Saved1!B19","v":"Fuel Cost"},{"$f":"Saved1!C19","v":1.75},{"$f":"Saved1!D19","v":"per gallon"},null,null,{"$f":"Saved2!C19","v":1.75},{"$f":"Saved2!D19","v":"per gallon"}]
[null,{"$f":"Saved1!B20","v":"Operator Labor"},{"$f":"Saved1!C20","v":13.14},{"$f":"Saved1!D20","v":"per hour"},null,null,{"$f":"Saved2!C20","v":13.14},{"$f":"Saved2!D20","v":"per hour"}]
[null,{"$f":"Saved1!B21","v":"Hired Labor"},{"$f":"Saved1!C21","v":9.06},{"$f":"Saved1!D21","v":"per hour"},null,null,{"$f":"Saved2!C21","v":9.06},{"$f":"Saved2!D21","v":"per hour"}]
[null,{"$f":"Saved1!B22","v":"Equipment Capital Recovery Rate"},{"$f":"Saved1!C22","v":0.06},null,null,null,{"$f":"Saved2!C22","v":0.06}]
[null,{"$f":"Saved1!B23","v":"Operating Interest"},{"$f":"Saved1!C23","v":4.7500000000000001E-2},null,null,null,{"$f":"Saved2!C23","v":4.7500000000000001E-2}]
[]
[null,"Machinery Selection",{"$f":"Calculate!C8","v":"Width"},"Purchase Price/\nRental Rate","Rental\n(Y/N)",null,{"$f":"Calculate!C8","v":"Width"},"Purchase Price/\nRental Rate","Rental\n(Y/N)"]
[null,{"$f":"Calculate!B5","v":"Tractor"},{"$f":"Calculate!B7","v":"2 WD 50"},{"$f":"Saved1!C7","v":39100},null,null,{"$f":"Saved2!B7","v":"2 WD 50"},{"$f":"Saved2!C7","v":32200}]
[null,{"$f":"Defaults!B32","v":"Fertilizer Spreader"},{"$f":"Saved1!C10","v":"40 ft"},{"$f":"Saved1!E10","v":11800},{"$f":"IF(Saved1!Q14=TRUE,L8,L9)","v":"No"},null,{"$f":"Saved2!C10","v":"40 ft"},{"$f":"Saved2!E10","v":0},{"$f":"IF(Saved2!Q14=TRUE,L8,L9)","v":"Yes"}]
[null,{"$f":"Defaults!B33","v":"Manure Spreader"},{"$f":"Saved1!C11","v":"Small"},{"$f":"Saved1!E11","v":10266.299999999999},{"$f":"IF(Saved1!Q15=TRUE,L8,L9)","v":"No"},null,{"$f":"Saved2!C11","v":"Small"},{"$f":"Saved2!E11","v":10266.299999999999},{"$f":"IF(Saved2!Q15=TRUE,L8,L9)","v":"No"}]
[null,{"$f":"Defaults!B36","v":"Aerator"},{"$f":"Saved1!C12","v":"8 ft"},{"$f":"Saved1!E12","v":7860.6},{"$f":"IF(Saved1!Q13=TRUE,L8,L9)","v":"No"},null,{"$f":"Saved2!C12","v":"10 ft"},{"$f":"Saved2!E12","v":200},{"$f":"IF(Saved2!Q13=TRUE,L8,L9)","v":"Yes"}]
[]
[null,"Operation/\n   Operating Input",{"$f":"Calculate!J6","v":"# of Trips/\n           App. Rate"},"Total Cost\n($/acre)",null,null,{"$f":"Calculate!J6","v":"# of Trips/\n           App. Rate"},"Total Cost\n($/acre)"]
[null,{"$f":"Calculate!H8","v":"Fertilizer Spreader"},{"$f":"Saved1!M8","v":2},{"$f":"Saved1!N8","v":5.82},null,null,{"$f":"Saved2!M8","v":2},{"$f":"Saved2!N8","v":2.4}]
[null,{"$f":"Calculate!H9","v":"Urea [46-0-0]"},{"$f":"Saved1!M9","v":199},{"$f":"Saved1!N9","v":29.849999999999998},null,null,{"$f":"Saved2!M9","v":64.674999999999997},{"$f":"Saved2!N9","v":9.7012499999999999}]
[null,{"$f":"Calculate!H10","v":"Triple Superphosphate [0-45-0]"},{"$f":"Saved1!M10","v":108.9},{"$f":"Saved1!N10","v":23.958000000000002},null,null,{"$f":"Saved2!M10","v":0},{"$f":"Saved2!N10","v":0}]
[null,{"$f":"Calculate!H11","v":"Potash [0-0-60]"},{"$f":"Saved1!M11","v":99.5},{"$f":"Saved1!N11","v":14.924999999999999},null,null,{"$f":"Saved2!M11","v":0},{"$f":"Saved2!N11","v":0}]
[null,{"$f":"Calculate!H12","v":"Gypsum"},{"$f":"Saved1!M12","v":1},{"$f":"Saved1!N12","v":31},null,null,{"$f":"Saved2!M12","v":0.25},{"$f":"Saved2!N12","v":7.75}]
[null,{"$f":"Calculate!H13","v":"Manure Spreader"},{"$f":"Saved1!M13","v":1},{"$f":"Saved1!N13","v":7.7200000000000006},null,null,{"$f":"Saved2!M13","v":1},{"$f":"Saved2!N13","v":7.7200000000000006}]
[null,{"$f":"Calculate!H14","v":"Poultry Litter [3-3-3]"},{"$f":"Saved1!M14","v":0.99},{"$f":"Saved1!N14","v":19.8},null,null,{"$f":"Saved2!M14","v":1.98},{"$f":"Saved2!N14","v":39.6}]
[null,{"$f":"Calculate!H15","v":"Aerator"},{"$f":"Saved1!M15","v":1},{"$f":"Saved1!N15","v":7.6399999999999988},null,null,{"$f":"Saved2!M15","v":1},{"$f":"Saved2!N15","v":8.3066666666666649}]
[null,null,"Breakeven (holding other effects at zero)","Current User Expectation",null,null,"Breakeven (holding other effects at zero)","Current User Expectation"]
[null,"Yield Increase",0.24990164799172609,{"$f":"+Saved1!B29","v":0.05},null,null,5.6471052572422235E-2,{"$f":"+Saved2!B29","v":0.05}]
[null,"N, P, & K Runoff Reduction from Aeration",0.26421696862259847,{"$f":"+Saved1!B32","v":5.0000000000000001E-3},null,null,8.413314915734231E-2,{"$f":"+Saved2!B32","v":5.0000000000000001E-3}]
[null,"P Runoff Reduction from Gypsum",0.47965657719334553,{"$f":"+Saved1!B35","v":5.0000000000000001E-3},null,null,0,{"$f":"+Saved2!B35","v":5.0000000000000001E-3}]
[]
[null,{"$f":"Saved1!L36","v":"Farm Total ($)"},null,{"$f":"Saved1!M36","v":-10112.370000000001},null,null,null,{"$f":"Saved2!M36","v":-2767.52}]
[null,"Expected Decrease in CEQ GHG Emissions (lbs/bale)",null,{"$f":"Saved1!M38","v":-2.9430725308697561},null,null,null,{"$f":"Saved2!M38","v":8.7778603668691346}]
[null,"Farm Total Exp. Decrease in CEQ GHG Emissions (tons)",null,{"$f":"Saved1!M39","v":-8.5928580541540782},null,null,null,{"$f":"Saved2!M39","v":-1.3962105257893653}]
[]
[null,"Disclaimer:  The information provided within represents estimates that are a result of a set of complex calculations that are described in more detail in the accompanying publication.  Changes in parameter values and its implications on returns and GHG emissions are estimates and the user should use their own reasonable judgment to reflect whether the direction of change in returns and GHG emissions is appropriate before acting on the results.  As such, this software is provided ‘as is’ and without warranties as to performance of merchantability.  Further, statements may have been made to you about this software.  Any such statements do not constitute warranties and shall not be relied on by the user in deciding whether to use the program or act on its results.  This program is provided without any expressed or implied warranties whatsoever.  Because the diversity of conditions and hardware under which this program may be used, no warranty of merchantability or warranty of fitness for a particular purpose is offered.  The user is advised to test the program thoroughly before relying on it.  The user assumes the entire risk of using the program.  The University of Arkansas will not be liable for any claim or damage brought against the user by any third party, nor will the University of Arkansas be liable for any consequential, indirect or special damages suffered by the user as a result of the software."]

{"sheet":"Defaults","index":5,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":false,"merged":[[12,10,13,10],[12,11,13,11],[2,5,3,5],[4,1,4,2],[2,1,3,2],[2,3,3,3],[2,4,3,4],[10,1,10,2],[11,1,11,2],[12,1,12,2],[5,1,5,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[6,1,6,2],[2,6,3,6]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"Labor Rates"]
[null,"Operation/\n   Operating Input",null,"Unit","# of trips/\nQuantity","Unit Cost","# of trips/\nQuantity",null,null,null,null,"Operator",13.14,"per hour"]
[null,null,null,null,null,null,null,null,null,null,null,"Hired Labor",9.06,"per hour"]
[null,"Fertilizer Spreader",null,null,1,{"$f":"\"\"","v":""},{"$f":"Calculate!J8+IF(Calculate!M12>0,1,0)","v":2},null,"Exp. Hay Price"]
[null,"Urea [46-0-0]",null,"lb",{"$f":"F16","v":200},0.15,null,null,35,"per bale",null,"Interest Rates"]
[null,"Triple Superphosphate [0-45-0]",null,"lb",{"$f":"F17","v":110},0.22,null,null,null,null,null,"Ammoritization",0.06]
[null,"Potash [0-0-60]",null,"lb",{"$f":"F18","v":100},0.15,null,null,"Exp. Hay Yields",null,null,"Operating",4.7500000000000001E-2]
[null,"Gypsum",null,"ton",1,{"$f":"31","v":31},null,null,5,"bales/acre"]
[null,"Manure Spreader",null,{"$f":"\"\"","v":""},1,{"$f":"\"\"","v":""},null,null,null,null,null,"Fuel Cost"]
[null,"Poultry Litter [3-3-3]",null,"ton",1,20,null,null,null,null,null,1.75,"per gallon"]
[null,"Aerator",null,{"$f":"\"\"","v":""},1,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Input","lbs of C Eq. per Input Unit"]
[]
[null,"Our Budget Spec",null,null,null,"w/rounding",null,null,null,null,"Urea [46-0-0]",1.2081676585230345]
[null,"Urea",92,{"$f":"+C16/0.46","v":200},"lbs of Urea fertilizer",{"$f":"ROUND(D16,0)","v":200},"Use Urea (46-0-0) to add remaining N",null,null,null,"Triple Superphosphate [0-45-0]",0.63244783378866498]
[null,"Phosphate",50,{"$f":"+C17/0.45","v":111.11111111111111},"lbs of TSP needed to apply 10 lbs of P2O5 also delivers",{"$f":"ROUND(D17,-1)","v":110},"Use TSP (0-45-0) to add P",null,null,null,"Potash[0-0-60]",0.10836075979937405]
[null,"Potash",60,{"$f":"C18/0.6","v":100},"lbs of potash fertilizer",{"$f":"ROUND(D18,0)","v":100},"Use Potash (0-0-60)",null,null,null,"Poultry Litter [3-3-3]",0.25732646103896106]
[null,null,null,null,null,null,null,null,null,null,"Gypsum",2.9597671423259329E-2]
[null,null,null,null,null,null,null,null,null,null,null,"Exp. Carbon Footprint (lbs/acre)"]
[30,"Tractors","Suggested\nPrice","Hours at \nPurchase (New)","HP","Estimated \nUL Hours","Estimated\nUL Years","Adj. Operating Years for Used Tractor","RV","SV","Fuel","Standard\nUse Hours",null,"C1","C2","C3","Repair Factor\n(% of list price)"]
[1,"2 WD 50",32200,0,50,12000,{"$f":"IF(F22/L22>$A$21,$A$21,F22/L22)","v":20},{"$f":"IF((F22-D22)/L22>$A$21,$A$21,(F22-D22)/L22)","v":20},{"$f":"(VLOOKUP(B22,$M$22:$P$29,2,FALSE)-(VLOOKUP(B22,$M$22:$P$29,3,FALSE)*G22^0.5)-VLOOKUP(B22,$M$22:$P$29,4,FALSE)*L22^0.5)^2","v":0.17894672507260678},{"$f":"C22*(I22)","v":5762.0845473379386},{"$f":"0.044*E22","v":2.1999999999999997},600,{"$f":"B22","v":"2 WD 50"},0.98099999999999998,9.2999999999999999E-2,5.7999999999999996E-3,1]
[2,"MFWD 50",39100,0,50,16000,{"$f":"IF(F23/L23>$A$21,$A$21,F23/L23)","v":26.666666666666668},{"$f":"IF((F23-D23)/L23>$A$21,$A$21,(F23-D23)/L23)","v":26.666666666666668},{"$f":"(VLOOKUP(B23,$M$22:$P$29,2,FALSE)-(VLOOKUP(B23,$M$22:$P$29,3,FALSE)*G23^0.5)-VLOOKUP(B23,$M$22:$P$29,4,FALSE)*L23^0.5)^2","v":0.12865109848972134},5030.2579509481047,2.1999999999999997,600,"MFWD 50",0.98099999999999998,9.2999999999999999E-2,5.7999999999999996E-3,0.8]
[3,"2 WD 75",48300,0,75,12000,20,20,0.17894672507260678,8643.1268210069084,3.3,600,"2 WD 75",0.98099999999999998,9.2999999999999999E-2,5.7999999999999996E-3,1]
[4,"MFWD 75",54100,0,75,16000,26.666666666666668,26.666666666666668,0.12865109848972134,6960.0244282939248,3.3,600,"MFWD 75",0.98099999999999998,9.2999999999999999E-2,5.7999999999999996E-3,0.8]
[5,"2 WD 105",63300,0,105,12000,20,20,0.22580599851501637,14293.519706000536,4.62,600,"2 WD 105",0.94199999999999995,0.1,8.0000000000000004E-4,1]
[6,"MFWD 105",77400,0,105,16000,26.666666666666668,26.666666666666668,0.16484111772121302,12758.702511621887,4.62,600,"MFWD 105",0.94199999999999995,0.1,8.0000000000000004E-4,0.8]
[7,"2 WD 130",103000,0,130,12000,20,20,0.22580599851501637,23258.017847046685,5.72,600,"2 WD 130",0.94199999999999995,0.1,8.0000000000000004E-4,1]
[8,"MFWD 130",123000,0,130,16000,26.666666666666668,26.666666666666668,0.16484111772121302,20275.457479709199,5.72,600,"MFWD 130",0.94199999999999995,0.1,8.0000000000000004E-4,0.8]
[]
["Standards","Implement","Size/HP","Implement\nSuggested (list)\nPurchase Price","Implement\nStandard\nEstimated \nUL Hours","Implement Standard\nAnnual\nUse Hours","Implement\nRepair Factor\n(% of list price)","Implement\nField Efficiency\n(%)","Implement\nField Speed\n(mph)","Tractor \nRequirements","C1","C2","C3"]
[null,"Fertilizer Spreader","40 ft",11800,1200,100,0.8,0.7,7,50,0.94299999999999995,0.111,0]
[null,"Manure Spreader","Small",{"$f":"11407*0.9","v":10266.300000000001},2000,{"$f":"F32","v":100},0.5,0.65,5,50,0.94299999999999995,0.111,0]
[null,null,"Medium",{"$f":"13361*0.9","v":12024.9},2000,100,0.5,0.7,5,75,0.94299999999999995,0.111,0]
[null,null,"Large",{"$f":"19175*0.9","v":17257.5},2000,100,0.5,0.75,5,100,0.94299999999999995,0.111,0]
[null,"Aerator","6 ft",{"$f":"6528*0.9","v":5875.2},2000,{"$f":"F33","v":100},0.5,0.65,5,40,0.94299999999999995,0.111,0]
[null,null,"8 ft",{"$f":"8734*0.9","v":7860.6},{"$f":"E36","v":2000},100,{"$f":"G36","v":0.5},0.65,5,50,0.94299999999999995,0.111,0]
[null,null,"10 ft",{"$f":"9377*0.9","v":8439.3000000000011},2000,100,0.5,0.65,5,75,0.94299999999999995,0.111,0]
[null,null,"12 ft",{"$f":"10935*0.9","v":9841.5},2000,100,0.5,0.65,5,100,0.94299999999999995,0.111,0]
[null,null,"15 ft",{"$f":"14683*0.9","v":13214.7},2000,100,0.5,0.65,5,130,0.94299999999999995,0.111,0]
[null,"Aerator Rental",0]
[null,"Fertilizer Spreader Rental",0]
[null,"Manure Spreader Rental",0]

{"sheet":"Machinery","index":6,"n_rows":10,"n_cols":39,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Implement","Size/HP","Implement\nSuggested (list)\nPurchase Price","Implement\nHours at \nPurchase","Implement\nStandard\nEstimated \nUL Hours","Implement\nAcre-based Operating Years","Implement Expected\nSV","Implement\nRepair Factor\n(% of list price)","Implement\nField Efficiency\n(%)","Implement\nField Speed\n(mph)","Tractor \nRequirements","C1","C2","C3","Implement\nRV","Implement\nHours/Acre","Implement\nAcres/Hour","Implement\nAcre-based\nAnnual Use Hours","Implement\nCapital Recovery\n($/hr)","Implement\nR&M\n($/hr)","Selected\nTractor Size","Tractor\nPP","Tractor\nHrs at Purchase","Tractor\nHP","Tractor\nEst. UL Hours","Tractor\nEst. UL Years","Tractor\nRV","Tractor\nSV","Tractor\nAnnual\nUse Hrs","Tractor\nFuel Use\n(gal/hr)","Tractor\nCapital Recovery\n($/hr)","Tractor\nR&M\n($/hr)","Combined\nCapital Recovery\n($/hr)","Combined\nR&M\n($/hr)","Labor\n($/hr)","Fuel\n($/hr)","Cost/Unit\n($/acre)","Total Cost\n($/acre)"]
[{"$f":"LEFT($C$3,SEARCH(\" \",$C$3,1))","v":"40 "},{"$f":"Defaults!B32","v":"Fertilizer Spreader"},{"$f":"Calculate!$C$10","v":"40 ft"},{"$f":"IF(Calculate!Q14,0,Calculate!$E$10)","v":0},{"$f":"Calculate!$F$10","v":0},{"$f":"VLOOKUP(C3,Defaults!C32:E32,3,FALSE)","v":1200},{"$f":"IF((F3-E3)/S3>Defaults!$A$21,Defaults!$A$21,(F3-E3)/S3)","v":30},{"$f":"D3*P3","v":0},{"$f":"VLOOKUP($C$3,Defaults!$C$32:G32,5,FALSE)","v":0.8},{"$f":"VLOOKUP($C$3,Defaults!$C$32:H32,6,FALSE)","v":0.7},{"$f":"+Calculate!D10","v":7},{"$f":"VLOOKUP($C$3,Defaults!$C$32:J32,8,FALSE)","v":50},{"$f":"VLOOKUP($C$3,Defaults!$C$32:K32,9,FALSE)","v":0.94299999999999995},{"$f":"VLOOKUP($C$3,Defaults!$C$32:L32,10,FALSE)","v":0.111},{"$f":"VLOOKUP($C$3,Defaults!$C$32:M32,11,FALSE)","v":0},{"$f":"(M3-N3*G3^0.5-O3*S3^0.5)^2","v":0.11224373476523493},{"$f":"(1/((5280/43560)*A3*J3*K3))","v":4.2091836734693876E-2},{"$f":"1/Q3","v":23.757575757575758},{"$f":"Calculate!$J$8*Q3*Calculate!$C$16","v":12.627551020408163},{"$f":"IFERROR((((D3-H3)*(Calculate!$C$22/(1-((1+Calculate!$C$22)^(-G3))))+((H3*Calculate!$C$22)))/S3),0)","v":0},{"$f":"I3*D3/F3","v":0},{"$f":"Calculate!$B$7","v":"2 WD 50"},{"$f":"+Calculate!$C$7","v":32200},{"$f":"Calculate!$D$7","v":0},{"$f":"VLOOKUP(V3,Defaults!$B$22:$Q$29,4,FALSE)","v":50},{"$f":"VLOOKUP(V3,Defaults!$B$22:$Q$29,5,FALSE)","v":12000},{"$f":"IF((Z3-X3)/AD3>Defaults!$A$21,Defaults!$A$21,(Z3-X3)/AD3)","v":20},{"$f":"(VLOOKUP(V3,Defaults!$M$22:$P$29,2,FALSE)-VLOOKUP(V3,Defaults!$M$22:$P$29,3,FALSE)*AA3^0.5-VLOOKUP(V3,Defaults!$M$22:$P$29,4,FALSE)*AD3^0.5)^2","v":0.17894672507260678},{"$f":"W3*AB3","v":5762.0845473379386},{"$f":"Calculate!$E$7","v":600},{"$f":"0.044*Y3","v":2.1999999999999997},{"$f":"IFERROR((((W3-AC3)*(Calculate!$C$22/(1-((1+Calculate!$C$22)^(-AA3))))+((AC3*Calculate!$C$22)))/AD3),0)","v":4.4178383649534538},{"$f":"IFERROR(VLOOKUP(V3,Defaults!$B$22:$Q$29,16,FALSE)*W3/Z3,0)","v":2.6833333333333331},{"$f":"T3+AF3","v":4.4178383649534538},2.6833333333333331,{"$f":"Calculate!$C$20+Calculate!$C$21*(1.5-1)","v":17.670000000000002},{"$f":"AE3*Calculate!$C$19","v":3.8499999999999996},{"$f":"ROUND(1/R3*(1*Calculate!$C$20+(1.5-1)*Calculate!$C$21),2)+ROUND(AE3*Calculate!$C$19/R3,2)+ROUND(AI3/R3,2)+ROUND(AH3/R3,2)","v":1.2},{"$f":"AL3*Calculate!$J$8","v":1.2}]
[15,{"$f":"Defaults!B33","v":"Manure Spreader"},{"$f":"Calculate!$C$11","v":"Small"},{"$f":"IF(Calculate!Q15,0,Calculate!$E$11)","v":10266.299999999999},{"$f":"Calculate!$F$11","v":0},{"$f":"VLOOKUP(C4,Defaults!C33:E35,3,FALSE)","v":2000},{"$f":"IF((F4-E4)/S4>Defaults!$A$21,Defaults!$A$21,(F4-E4)/S4)","v":30},{"$f":"D4*P4","v":1152.3278542203313},{"$f":"VLOOKUP($C$4,Defaults!$C$33:G35,5,FALSE)","v":0.5},{"$f":"VLOOKUP($C$4,Defaults!$C$33:H35,6,FALSE)","v":0.65},{"$f":"+Calculate!D11","v":5},{"$f":"VLOOKUP($C$4,Defaults!$C$33:J35,8,FALSE)","v":50},{"$f":"VLOOKUP($C$4,Defaults!$C$33:K35,9,FALSE)","v":0.94299999999999995},{"$f":"VLOOKUP($C$4,Defaults!$C$33:L35,10,FALSE)","v":0.111},{"$f":"VLOOKUP($C$4,Defaults!$C$33:M35,11,FALSE)","v":0},{"$f":"(M4-N4*G4^0.5-O4*S4^0.5)^2","v":0.11224373476523493},{"$f":"(1/((5280/43560)*A4*J4*K4))","v":0.16923076923076924},{"$f":"1/Q4","v":5.9090909090909092},{"$f":"Calculate!$J$13*Q4*Calculate!$C$16","v":50.769230769230774},{"$f":"IFERROR((((D4-H4)*(Calculate!$C$22/(1-((1+Calculate!$C$22)^(-G4))))+((H4*Calculate!$C$22)))/S4),0)","v":14.403602652926351},{"$f":"I4*D4/F4","v":2.5665749999999998},{"$f":"Calculate!$B$7","v":"2 WD 50"},{"$f":"+Calculate!$C$7","v":32200},{"$f":"Calculate!$D$7","v":0},{"$f":"VLOOKUP(V4,Defaults!$B$22:$Q$29,4,FALSE)","v":50},{"$f":"VLOOKUP(V4,Defaults!$B$22:$Q$29,5,FALSE)","v":12000},{"$f":"IF((Z4-X4)/AD4>Defaults!$A$21,Defaults!$A$21,(Z4-X4)/AD4)","v":20},{"$f":"(VLOOKUP(V4,Defaults!$M$22:$P$29,2,FALSE)-VLOOKUP(V4,Defaults!$M$22:$P$29,3,FALSE)*AA4^0.5-VLOOKUP(V4,Defaults!$M$22:$P$29,4,FALSE)*AD4^0.5)^2","v":0.17894672507260678},{"$f":"W4*AB4","v":5762.0845473379386},{"$f":"Calculate!$E$7","v":600},{"$f":"0.044*Y4","v":2.1999999999999997},{"$f":"IFERROR((((W4-AC4)*(Calculate!$C$22/(1-((1+Calculate!$C$22)^(-AA4))))+((AC4*Calculate!$C$22)))/AD4),0)","v":4.4178383649534538},{"$f":"IFERROR(VLOOKUP(V4,Defaults!$B$22:$Q$29,16,FALSE)*W4/Z4,0)","v":2.6833333333333331},18.821441017879806,5.249908333333333,{"$f":"Calculate!$C$20","v":13.14},{"$f":"AE4*Calculate!$C$19","v":3.8499999999999996},{"$f":"ROUND(1/R4*(1*Calculate!$C$20+(1.5-1)*Calculate!$C$21),2)+ROUND(AE4*Calculate!$C$19/R4,2)+ROUND(AI4/R4,2)+ROUND(AH4/R4,2)","v":7.7200000000000006},{"$f":"AL4*Calculate!$J$13","v":7.7200000000000006}]
[{"$f":"LEFT($C$5,SEARCH(\" \",$C$5,1))","v":"10 "},{"$f":"Defaults!B36","v":"Aerator"},{"$f":"Calculate!$C$12","v":"10 ft"},{"$f":"IF(Calculate!Q13,0,Calculate!$E$12)","v":0},{"$f":"Calculate!$F$12","v":0},{"$f":"VLOOKUP(C5,Defaults!C36:E40,3,FALSE)","v":2000},{"$f":"IF((F5-E5)/S5>Defaults!$A$21,Defaults!$A$21,(F5-E5)/S5)","v":21.01010101010101},{"$f":"D5*P5","v":0},{"$f":"VLOOKUP($C$5,Defaults!$C$36:G40,5,FALSE)","v":0.5},{"$f":"VLOOKUP($C$5,Defaults!$C$36:H40,6,FALSE)","v":0.65},{"$f":"+Calculate!D12","v":4},{"$f":"VLOOKUP($C$5,Defaults!$C$36:J40,8,FALSE)","v":75},{"$f":"VLOOKUP($C$5,Defaults!$C$36:K40,9,FALSE)","v":0.94299999999999995},{"$f":"VLOOKUP($C$5,Defaults!$C$36:L40,10,FALSE)","v":0.111},{"$f":"VLOOKUP($C$5,Defaults!$C$36:M40,11,FALSE)","v":0},0.18853986841034662,{"$f":"(1/((5280/43560)*A5*J5*K5))","v":0.31730769230769229},{"$f":"1/Q5","v":3.1515151515151518},{"$f":"Calculate!$M$15*Q5*Calculate!$C$16","v":95.192307692307693},{"$f":"IFERROR((((D5-H5)*(Calculate!$C$22/(1-((1+Calculate!$C$22)^(-G5))))+((H5*Calculate!$C$22)))/S5),0)","v":0},{"$f":"I5*D5/F5","v":0},{"$f":"Calculate!$B$7","v":"2 WD 50"},{"$f":"+Calculate!$C$7","v":32200},{"$f":"Calculate!$D$7","v":0},{"$f":"VLOOKUP(V5,Defaults!$B$22:$Q$29,4,FALSE)","v":50},{"$f":"VLOOKUP(V5,Defaults!$B$22:$Q$29,5,FALSE)","v":12000},{"$f":"IF((Z5-X5)/AD5>Defaults!$A$21,Defaults!$A$21,(Z5-X5)/AD5)","v":20},{"$f":"(VLOOKUP(V5,Defaults!$M$22:$P$29,2,FALSE)-VLOOKUP(V5,Defaults!$M$22:$P$29,3,FALSE)*AA5^0.5-VLOOKUP(V5,Defaults!$M$22:$P$29,4,FALSE)*AD5^0.5)^2","v":0.17894672507260678},{"$f":"W5*AB5","v":5762.0845473379386},{"$f":"Calculate!$E$7","v":600},{"$f":"0.044*Y5","v":2.1999999999999997},{"$f":"IFERROR((((W5-AC5)*(Calculate!$C$22/(1-((1+Calculate!$C$22)^(-AA5))))+((AC5*Calculate!$C$22)))/AD5),0)","v":4.4178383649534538},{"$f":"IFERROR(VLOOKUP(V5,Defaults!$B$22:$Q$29,16,FALSE)*W5/Z5,0)","v":2.6833333333333331},4.4178383649534538,2.6833333333333331,{"$f":"Calculate!$C$20","v":13.14},{"$f":"AE5*Calculate!$C$19","v":3.8499999999999996},{"$f":"ROUND(1/R5*Calculate!$C$20,2)+ROUND(AE5*Calculate!$C$19/R5,2)+ROUND(AI5/R5,2)+ROUND(AH5/R5,2)","v":7.6399999999999988},{"$f":"AL5*Calculate!$M$15","v":7.6399999999999988}]
[{"$f":"LEFT($C$6,SEARCH(\" \",$C$6,1))","v":"40 "},{"$f":"Defaults!B32","v":"Fertilizer Spreader"},{"$f":"Calculate!$C$10","v":"40 ft"},{"$f":"IF(Calculate!Q14,0,Calculate!$E$10)","v":0},{"$f":"Calculate!$F$10","v":0},{"$f":"VLOOKUP(C3,Defaults!C32:E32,3,FALSE)","v":1200},{"$f":"IF((F6-E6)/S6>Defaults!$A$21,Defaults!$A$21,(F6-E6)/S6)","v":30},{"$f":"D6*P6","v":0},{"$f":"VLOOKUP($C$3,Defaults!$C$32:G32,5,FALSE)","v":0.8},{"$f":"VLOOKUP($C$3,Defaults!$C$32:H32,6,FALSE)","v":0.7},{"$f":"+Calculate!D10","v":7},{"$f":"VLOOKUP($C$3,Defaults!$C$32:J32,8,FALSE)","v":50},{"$f":"VLOOKUP($C$3,Defaults!$C$32:K32,9,FALSE)","v":0.94299999999999995},{"$f":"VLOOKUP($C$3,Defaults!$C$32:L32,10,FALSE)","v":0.111},{"$f":"VLOOKUP($C$3,Defaults!$C$32:M32,11,FALSE)","v":0},{"$f":"(M6-N6*G6^0.5-O6*S6^0.5)^2","v":0.11224373476523493},{"$f":"(1/((5280/43560)*A6*J6*K6))","v":4.2091836734693876E-2},{"$f":"1/Q6","v":23.757575757575758},{"$f":"Calculate!$M$8*Q6*Calculate!$C$16","v":25.255102040816325},{"$f":"IFERROR((((D6-H6)*(Calculate!$C$22/(1-((1+Calculate!$C$22)^(-G6))))+((H6*Calculate!$C$22)))/S6),0)","v":0},{"$f":"I6*D6/F6","v":0},{"$f":"Calculate!$B$7","v":"2 WD 50"},{"$f":"+Calculate!$C$7","v":32200},{"$f":"Calculate!$D$7","v":0},{"$f":"VLOOKUP(V6,Defaults!$B$22:$Q$29,4,FALSE)","v":50},{"$f":"VLOOKUP(V6,Defaults!$B$22:$Q$29,5,FALSE)","v":12000},{"$f":"IF((Z6-X6)/AD6>Defaults!$A$21,Defaults!$A$21,(Z6-X6)/AD6)","v":20},{"$f":"(VLOOKUP(V6,Defaults!$M$22:$P$29,2,FALSE)-VLOOKUP(V6,Defaults!$M$22:$P$29,3,FALSE)*AA6^0.5-VLOOKUP(V6,Defaults!$M$22:$P$29,4,FALSE)*AD6^0.5)^2","v":0.17894672507260678},{"$f":"W6*AB6","v":5762.0845473379386},{"$f":"Calculate!$E$7","v":600},{"$f":"0.044*Y6","v":2.1999999999999997},{"$f":"IFERROR((((W6-AC6)*(Calculate!$C$22/(1-((1+Calculate!$C$22)^(-AA6))))+((AC6*Calculate!$C$22)))/AD6),0)","v":4.4178383649534538},{"$f":"IFERROR(VLOOKUP(V6,Defaults!$B$22:$Q$29,16,FALSE)*W6/Z6,0)","v":2.6833333333333331},{"$f":"T6+AF6","v":4.4178383649534538},{"$f":"U6+AG6","v":2.6833333333333331},{"$f":"Calculate!$C$20+Calculate!$C$21*(1.5-1)","v":17.670000000000002},{"$f":"AE6*Calculate!$C$19","v":3.8499999999999996},{"$f":"ROUND(1/R6*(1*Calculate!$C$20+(1.5-1)*Calculate!$C$21),2)+ROUND(AE6*Calculate!$C$19/R6,2)+ROUND(AI6/R6,2)+ROUND(AH6/R6,2)","v":1.2},{"$f":"AL6*Calculate!$J$8","v":1.2}]
[]
[null,"Bottom row is for added use of fertilizer spreader if gypsum is applied"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AF5,AG5,AJ5,AK5)","v":24.091171698286786}]