{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Calculator","Instr-Info","Tables"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":3,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Calculator","index":0,"n_rows":163,"n_cols":10,"rows_kept":163,"cut":false,"hidden":false,"merged":[[141,6,141,8],[142,5,162,8],[137,3,138,3],[137,4,138,4],[137,5,138,5],[137,6,138,6],[137,7,138,7],[137,8,138,8],[157,4,158,4],[159,4,160,4],[161,4,162,4],[155,4,156,4],[58,2,59,2],[79,2,80,2],[81,2,82,2],[75,4,76,4],[77,4,78,4],[79,4,80,4],[81,4,82,4],[118,1,120,1],[121,1,135,1],[118,8,119,8],[110,1,117,1],[110,2,110,4],[115,3,115,4],[155,1,162,1],[155,2,156,2],[155,3,156,3],[157,2,158,2],[157,3,158,3],[159,2,160,2],[161,2,162,2],[159,3,160,3],[161,3,162,3],[148,1,154,1],[140,1,147,1],[136,1,139,1],[40,1,42,1],[40,2,41,2],[57,1,60,1],[61,1,68,1],[75,1,82,1],[69,1,74,1],[118,2,119,2],[43,1,56,1],[137,2,138,2],[109,1,109,8],[110,5,110,8],[75,2,76,2],[77,2,78,2],[120,9,124,9],[109,9,110,9],[58,8,59,8],[61,5,82,8],[118,3,118,5],[118,6,119,6],[118,7,119,7],[58,5,59,5],[58,6,59,6],[58,7,59,7],[58,4,59,4],[58,3,59,3],[75,3,76,3],[77,3,78,3],[79,3,80,3],[81,3,82,3],[30,9,31,9],[42,9,46,9],[40,7,41,7],[40,8,41,8],[40,3,40,5],[40,6,41,6],[31,5,31,8],[30,1,30,8],[31,1,39,1],[37,2,39,4],[36,3,36,4],[0,2,0,4],[6,2,6,3],[8,2,8,3],[7,2,7,3],[31,2,31,4],[16,2,16,4],[4,2,5,4],[13,4,13,7],[14,4,14,6],[1,1,2,8],[3,1,3,8]]}
[null,null,"Please \"Enable Active Content\", so the Calculator can perform as expected."]
[null,"NDSU Manure Application Calculator for Corn"]
[]
[null,"(Solid Beef Feedlot Manure)"]
[null,null,"Manure to be applied based on: (Please click in one of the options below)"]
[]
[null,null,"Nitrogen Corn Requirement"]
[null,null,"OR"]
[null,null,"Phosphorus Corn Requirement"]
[]
[]
[]
[{"$nulls":4},"Developed by: Paulo Flores"]
[{"$nulls":4},"Precision Agriculture Specialist"]
[{"$nulls":4},"NDSU Carrington REC"]
[null,null,"To learn more about this spreadsheet click here."]
[null,null,"For comments, questions and/or suggestions contact the developer by clicking here."]
{"$rows_empty":13}
[null,"NDSU Manure Application Calculator for Corn - Phosphorus",{"$nulls":7},"Change/Add values in/to the light blue cells to reflect the values of your operation."]
[null,"General","General Information",null,null,"…………………..….... Fertilizer Prices ………..………..…….."]
[null,null,"1. Field ID",null,null,null,"$/ton","$/lb of Nutrient","$/lb Fertilizer","Manure Incorporation - Please Select One"]
[null,null,"2. Field Area (ac)",null,"ac","Urea",420,{"$f":"G34/920","v":0.45652173913043476},{"$f":"G34/2000","v":0.21},"Immediately"]
[null,null,"3. Soil Test P (Olsen)",null,"ppm P2O5","Anhydrous NH3",700,{"$f":"G35/1640","v":0.42682926829268292},{"$f":"G35/2000","v":0.35},"Nitrogen Source - Please Select One"]
[null,null,"4. Soil Test K",null,"ppm K2O","UAN-28%",325,{"$f":"G36/560","v":0.5803571428571429},0.16250000000000001,"Urea"]
[null,null,"5. Region in the State and Irrigation Status","West river-non irrigated",null,"11-52-00",565,{"$f":"G37/1040","v":0.54326923076923073},0.28249999999999997,"Phosphorus Source - Please Select One"]
[null,null,"Notes:",null,null,"18-46-00",555,{"$f":"G38/920","v":0.60326086956521741},0.27750000000000002,"11-52-00"]
[{"$nulls":5},"00-00-60",425,{"$f":"G39/1200","v":0.35416666666666669},0.21249999999999999,"Do you have a manure analysis report?"]
[{"$nulls":5},"21-00-00-24",325,{"$f":"G40/480","v":0.67708333333333337},0.16250000000000001,"YES"]
[null,null,null,"Nitrogen",null,null,"P2O5","K2O","Sulfur",{"$f":"IF(J40=\"YES\",\"Please enter the nutrient values on line 7.\",IF(J40=\"NO\",\"Average nutrient values for manure being used.\"))","v":"Please enter the nutrient values on line 7."}]
[null,null,null,"Ammonium-N","Organic N","Total N"]
[null,null,"6. Nutrient Recommendation, lbs/ac",null,null,null,{"$f":"IF(D35=\"\",\"\",IF(AND(D37=\"West river-non irrigated\",D35<=3),78,IF(AND(D37=\"West river-non irrigated\",D35>=4,D35<=7),52,IF(AND(D37=\"West river-non irrigated\",D35>=8,D35<=11),39,IF(AND(D37=\"West river-non irrigated\",D35>=12,D35<=15),26,IF(AND(D37=\"West river-non irrigated\",D35>=16),10,IF(AND(D37=\"East river-non irrigated\",D35<=3),104,IF(AND(D37=\"East river-non irrigated\",D35>=4,D35<=7),78,IF(AND(D37=\"East river-non irrigated\",D35>=8,D35<=11),52,IF(AND(D37=\"East river-non irrigated\",D35>=12,D35<=15),39,IF(AND(D37=\"East river-non irrigated\",D35>=16),10,IF(AND(D37=\"Irrigated\",D35<=3),156,IF(AND(D37=\"Irrigated\",D35>=4,D35<=7),104,IF(AND(D37=\"Irrigated\",D35>=8,D35<=11),78,IF(AND(D37=\"Irrigated\",D35>=12,D35<=15),52,IF(AND(D37=\"Irrigated\",D35>=16),26))))))))))))))))","v":""},{"$f":"IF(D36=\"\",\"\",IF(AND(D37=\"West river-non irrigated\",D36<=40),120,IF(AND(D37=\"West river-non irrigated\",D36>=41,D36<=80),90,IF(AND(D37=\"West river-non irrigated\",D36>=81,D36<=120),60,IF(AND(D37=\"West river-non irrigated\",D36>=121,D36<=160),30,IF(AND(D37=\"West river-non irrigated\",D36>=161),0,IF(AND(D37=\"East river-non irrigated\",D36<=40),120,IF(AND(D37=\"East river-non irrigated\",D36>=41,D36<=80),90,IF(AND(D37=\"East river-non irrigated\",D36>=81,D36<=120),60,IF(AND(D37=\"East river-non irrigated\",D36>=121,D36<=160),60,IF(AND(D37=\"East river-non irrigated\",D36>=161),60,IF(AND(D37=\"Irrigated\",D36<=40),120,IF(AND(D37=\"Irrigated\",D36>=41,D36<=80),90,IF(AND(D37=\"Irrigated\",D36>=81,D36<=120),60,IF(AND(D37=\"Irrigated\",D36>=121,D36<=160),60,IF(AND(D37=\"Irrigated\",D36>=161),0))))))))))))))))","v":""},null,"Click here to calculate the Corn Nitrogen Recommendation for your operation (North Dakota Corn Nitrogen Calculator). You will need to be connected to the internet to complete this step."]
[null,"Manure","7. Manure Nutrient Content, lbs/ton"]
[null,null,"  7.1 Nutrient Availability Factor",{"$f":"IF(J34=\"Immediately\",0.95,IF(J34=\"One day later\", 0.5,IF(J34=\"Two days later\", 0.25,IF(J34=\"Three days later\",0.15,IF(J34=\"Seven or more days later\",0)))))","v":0.95},0.5,null,0.8,0.9,0.55000000000000004]
[null,null,"  7.2 Nutrient Available, lbs/ton",{"$f":"IF(J40=\"YES\",D45*D44,IF(J40=\"NO\",D45*E48))","v":0},{"$f":"IF(J40=\"YES\",E45*E44,IF(J40=\"NO\",E45*E49))","v":0},{"$f":"E46+D46","v":0},{"$f":"IF(J40=\"YES\",G45*G44,IF(AND(J40=\"YES\",G44=\"\"),0,IF(J40=\"NO\",G45*E50)))","v":0},{"$f":"IF(J40=\"YES\",H45*H44,IF(AND(H44=\"\",J40=\"YES\"),0,IF(J40=\"NO\",H45*E51)))","v":0},{"$f":"IF(J40=\"YES\",I45*I44,IF(AND(I44=\"\",J40=\"YES\"),0,IF(J40=\"NO\",I45*E52)))","v":0}]
[null,null,"  7.3 Nutrient Available, lb/ac","West river-non irrigated",null,{"$f":"F50*F46","v":0},{"$f":"IF(G46=0,0,F50*G46)","v":0},{"$f":"F50*H46","v":0},{"$f":"I46*F50","v":0}]
[null,null,"  7.4 Nutrient Balance, lbs/ac","East river-non irrigated",0.76,{"$f":"IF(I43>0,(F47-F43)+(I49*0.21),F47-F43)","v":0},{"$f":"IF(G43=\"\",0,G47-G43)","v":0},{"$f":"IF(H43=\"\",0,H47-H43)","v":0},{"$f":"I47-I43","v":0}]
[null,null,"  7.5 Commercial Fertilizer Application Rates, lbs/ac","Irrigated",12.96,{"$f":"IF(AND(J36=\"Urea\",F48<0),ABS(F48)*2.1739,IF(AND(J36=\"Anhydrous NH3\",F48<0),ABS(F48)*1.2195,IF(AND(J36=\"UAN-28%\",F48<0),ABS(F48)*3.5714,IF(F48>0,0,IF(F43=\"\",0)))))","v":0},null,{"$f":"IF(H48=0,0,IF(H48>0,0, IF(H48<0,ABS(H48)*1.6666)))","v":0},{"$f":"IF(I48>=0,0,IF(I48<0,ABS(I48)*4.1667))","v":0},"CLICK HERE TO GO BACK TO THE TOP"]
[null,null,"  7.6 Application Rate, ton/ac","P205",6.1,{"$f":"IF(G46=0,0,G43/G46)","v":0},null,"YES"]
[null,null,"  7.7 Application Cost per Load, $/load","K2O",11.92,0]
[null,null,"  7.8 Hauling Cost, $/mile","S-SO4",2.36,0,null,"NO"]
[null,null,"  7.9 Hauling Distance, miles",null,null,0,null,{"$f":"IF(J40=\"NO\",1,0)","v":0}]
[null,null,"  7.10 Incorporation Cost, $/ac",null,null,0]
[null,null,"  7.11 Manure Hauler Truck/Spreader Capacity, tons",null,null,1]
[null,null,"  7.12 Amount for the Field, ton",null,null,{"$f":"F50*D34","v":0}]
[null,null,"  7.13 Number of Loads for the Field",null,null,{"$f":"IF(F55=\"\",0,F56/F55)","v":0}]
[null,"Fertilizer","8. Nutrient Recommendation, lb/ac",null,null,{"$f":"F43","v":0},{"$f":"IF(G43=\"\",0,G43)","v":0},{"$f":"IF(H43=\"\",0,H43)","v":0},{"$f":"I43","v":0}]
[null,null,"  8.1 Fertilizer Apllication Rate, lbs/ac",{"$f":"IF(J38=\"11-52-00\",(G59*0.11)+(I59*0.21),IF(J38=\"18-46-00\",(G59*0.18)+(I59*0.21)))","v":0},{"$f":"IF(J38=\"11-52-00\",((G59*0.11)+(I59*0.21))-F58,IF(J38=\"18-46-00\",((G59*0.18)+(I59*0.21))-F58))","v":0},{"$f":"IF(AND(J36=\"Urea\",E59<0),ABS(E59)*2.1739,IF(AND(J36=\"Anhydrous NH3\",E59<0),ABS(E59)*1.2195,IF(AND(J36=\"UAN-28%\",E59<0),ABS(E59)*3.5714,IF(E59>0,0,IF(F43=\"\",0)))))","v":0},{"$f":"IF(J38=\"11-52-00\",G58*1.9231,IF(J38=\"18-46-00\",G58*2.1739))","v":0},{"$f":"IF(D37=\"\",0,H58*1.6667)","v":0},{"$f":"IF(I43=\"\",0,I58*4.16667)","v":0}]
[]
[null,null,"  8.2 Nutrient Balance, lbs/ac",null,null,{"$f":"(ABS(E59)+D59)-F58","v":0},{"$f":"IF(J38=\"11-52-00\",(G59/1.9231)-G58,IF(J38=\"18-46-00\",(G59/2.1739)-G58))","v":0},{"$f":"(H59/1.6667)-H58","v":0},{"$f":"(I59/4.16667)-I58","v":0}]
[null,"Costs","9. Costs","Manure","Fertilizer"]
[null,null,"  9.1 Nitrogen, $/ac",{"$f":"IF(J36=\"Urea\",F49*G34/2000,IF(J36=\"Anhydrous NH3\",F49*G35/2000,IF(J36=\"UAN-28%\",F49*G36/2000)))","v":0},{"$f":"IF(J36=\"Urea\",F59*G34/2000,IF(J36=\"Anhydrous NH3\",F59*G35/2000,IF(J36=\"UAN-28%\",F59*G36/2000)))","v":0}]
[null,null,"  9.2 Phosphorus (P2O5), $/ac",{"$f":"IF(J38=\"11-52-00\",H37*F50*G46,IF(J38=\"18-46-00\",H38*F50*G46))","v":0},{"$f":"IF(J38=\"11-52-00\",G37/2000*G59,IF(J38=\"18-46-00\",G38/2000*G59))","v":0}]
[null,null,"  9.3 Potassium (K2O), $/ac",{"$f":"H49*G39/2000","v":0},{"$f":"H59*G39/2000","v":0}]
[null,null,"  9.4 Sulfur (S-SO4), $/ac",{"$f":"IF(OR(I48>0, I43=\"\"),0,IF(I48<0,ABS(I48)*H40))","v":0},{"$f":"IF(OR(I43=0, I43=\"\"),0,I59*G40/2000)","v":0}]
[null,null,"  9.5 Application Cost, $/ac",{"$f":"IF(OR(F50=\"\", F50=0, F55=\"\", F55=0 ),0,((F51+(F52*F53))/(F55/F50))+F54+E67)","v":0},7]
[null,null,"  9.6 TOTAL Cost, $/ac",{"$f":"SUM(D63:D67)","v":0},{"$f":"IF(F43=\"\",0,SUM(E63:E67))","v":0}]
[null,null,"  9.7 TOTAL Cost for the Field, $",{"$f":"D68*D34","v":0},{"$f":"E68*D34","v":0}]
[null,"Extra Value","10. Extra Nutrient Value"]
[null,null,"  10.1 Nitrogen (1st+2nd Year), $/ac",{"$f":"IF(AND(J36=\"Urea\",J40=\"NO\"),(H34*F47)+(E49*0.15*H34*F50),IF(J36=\"Urea\",(H34*F47)+(E44*0.15*H34*F50),IF(AND(J36=\"Anhydrous NH3\",J40=\"NO\"),(H35*F47)+(E49*0.15*H35*F50),IF(J36=\"Anhydrous NH3\",(H35*F47)+(E44*0.15*H35*F50),IF(AND(J36=\"UAN-28%\",J40=\"NO\"),(H34*F47)+(E49*0.15*H36*F50),IF(J36=\"UAN-28%\",(H36*F47)+(E44*0.15*H36*F50)))))))","v":0},{"$f":"IF(J36=\"Urea\",H34*(F58-ABS(E59)),IF(J36=\"Anhydrous NH3\",H35*(F58-ABS(E59)),IF(J36=\"UAN-28%\",H36*(F58-ABS(E59)))))","v":0}]
[null,null,"  10.2 Potassium (K2O), $/ac",{"$f":"H47*H39","v":0},0]
[null,null,"  10.3 Sulfur (S-SO4), $/ac",{"$f":"I47*H40","v":0},0]
[null,null,"  10.4 TOTAL Extra Nutrient Value, $/ac",{"$f":"SUM(D71:D73)","v":0},{"$f":"SUM(E71:E73)","v":0}]
[null,null,"  10.5 TOTAL Extra Nutrient Value for the  Field, $",{"$f":"D74*D34","v":0},{"$f":"E74*D34","v":0},{"$nulls":4},"Contact Information"]
[null," Manure Cash Value","11. NET CASH VALUE , $/ac",{"$f":"IF(OR(D34=\"\", G43=0),0,E68-D68+D74-E74)","v":0},{"$nulls":5},"Paulo Flores"]
[{"$nulls":9},"Precision Agriculture Specialist"]
[null,null,"12. NET CASH VALUE  minus Extra K2O value , $/ac",{"$f":"IF(D34=\"\",0,D76-D72)","v":0},{"$nulls":5},"NDSU Carrington REC"]
[{"$nulls":9},"Email: paulo.flores@ndsu.edu"]
[null,null,"13. NET CASH VALUE for the  Field  , $",{"$f":"IF(D34=\"\",0,D76*D34)","v":0},{"$nulls":5},"Phone:701-652-2951"]
[]
[null,null,"14. NET CASH VALUE for the  Field minus Extra K2O value, $",{"$f":"IF(D34=\"\",0,D78*D34)","v":0}]
[{"$nulls":9},"Updated on 02/04/2017"]
{"$rows_empty":26}
[null,"NDSU Manure Application Calculator for Corn - Nitrogen",{"$nulls":7},"Change/Add values in/to the light blue cells to reflect the values of your operation."]
[null,"General","General Information",null,null,"……………………...….. Fertilizer Prices ………………...……….."]
[null,null,"1. Field ID",null,null,null,"$/ton","$/lb of Nutrient","$/lb Fertilizer","Manure Incorporation - Please Select One"]
[null,null,"2. Field Area (ac)",null,"ac","Urea",420,{"$f":"G113/920","v":0.45652173913043476},{"$f":"G113/2000","v":0.21},"Two days later"]
[null,null,"3. Soil Test P (Olsen)",null,"ppm P2O5","Anhydrous NH3",700,{"$f":"G114/1640","v":0.42682926829268292},{"$f":"G114/2000","v":0.35},"Nitrogen Source - Please Select One"]
[null,null,"4. Soil Test K",null,"ppm K2O","UAN-28%",325,{"$f":"G115/560","v":0.5803571428571429},0.16250000000000001,"Urea"]
[null,null,"5. Region in the State and Irrigation Status","East river-non irrigated",null,"11-52-00",565,{"$f":"G116/1040","v":0.54326923076923073},0.28249999999999997,"Do you have a manure analysis report?"]
[{"$nulls":5},"00-00-60",425,{"$f":"G117/1200","v":0.35416666666666669},0.21249999999999999,"NO"]
[{"$nulls":5},"21-00-00-24",325,{"$f":"G118/480","v":0.67708333333333337},{"$f":"G118/2000","v":0.16250000000000001},{"$f":"IF(J117=\"YES\",\"Please enter the nutrient values on line 7.\",IF(J117=\"NO\",\"Average nutrient values for manure being used.\"))","v":"Average nutrient values for manure being used."}]
[null,null,null,"Nitrogen",null,null,"P2O5","K2O","Sulfur"]
[null,null,null,"Ammonium-N","Organic N","Total N"]
[null,null,"6. Nutrient Recommendation, lbs/ac",null,null,3,{"$f":"IF(D114=\"\",\"\",IF(AND(D116=\"West river-non irrigated\",D114<=3),78,IF(AND(D116=\"West river-non irrigated\",D114>=4,D114<=7),52,IF(AND(D116=\"West river-non irrigated\",D114>=8,D114<=11),39,IF(AND(D116=\"West river-non irrigated\",D114>=12,D114<=15),26,IF(AND(D116=\"West river-non irrigated\",D114>=16),10,IF(AND(D116=\"East river-non irrigated\",D114<=3),104,IF(AND(D116=\"East river-non irrigated\",D114>=4,D114<=7),78,IF(AND(D116=\"East river-non irrigated\",D114>=8,D114<=11),52,IF(AND(D116=\"East river-non irrigated\",D114>=12,D114<=15),39,IF(AND(D116=\"East river-non irrigated\",D114>=16),10,IF(AND(D116=\"Irrigated\",D114<=3),156,IF(AND(D116=\"Irrigated\",D114>=4,D114<=7),104,IF(AND(D116=\"Irrigated\",D114>=8,D114<=11),78,IF(AND(D116=\"Irrigated\",D114>=12,D114<=15),52,IF(AND(D116=\"Irrigated\",D114>=16),26))))))))))))))))","v":""},{"$f":"IF(D115=\"\",\"\",IF(AND(D116=\"West river-non irrigated\",D115<=40),120,IF(AND(D116=\"West river-non irrigated\",D115>=41,D115<=80),90,IF(AND(D116=\"West river-non irrigated\",D115>=81,D115<=120),60,IF(AND(D116=\"West river-non irrigated\",D115>=121,D115<=160),30,IF(AND(D116=\"West river-non irrigated\",D115>=161),0,IF(AND(D116=\"East river-non irrigated\",D115<=40),120,IF(AND(D116=\"East river-non irrigated\",D115>=41,D115<=80),90,IF(AND(D116=\"East river-non irrigated\",D115>=81,D115<=120),60,IF(AND(D116=\"East river-non irrigated\",D115>=121,D115<=160),60,IF(AND(D116=\"East river-non irrigated\",D115>=161),60,IF(AND(D116=\"Irrigated\",D115<=40),120,IF(AND(D116=\"Irrigated\",D115>=41,D115<=80),90,IF(AND(D116=\"Irrigated\",D115>=81,D115<=120),60,IF(AND(D116=\"Irrigated\",D115>=121,D115<=160),60,IF(AND(D116=\"Irrigated\",D115>=161),0))))))))))))))))","v":""},null,"Click here to calculate the Corn Nitrogen Recommendation for your operation (North Dakota Corn Nitrogen Calculator). You will need to be connected to the internet to complete this step."]
[null,"Manure","7. Manure Nutrient Content, lbs/ton",null,5]
[null,null,"  7.1 Nutrient Availability Factor, %",{"$f":"IF(J113=\"Immediately\",0.95,IF(J113=\"One day later\", 0.5,IF(J113=\"Two days later\", 0.25,IF(J113=\"Three days later\",0.15,IF(J113=\"Seven or more days later\",0)))))","v":0.25},0.5,null,0.8,0.9,0.55000000000000004]
[null,null,"  7.2 Nutrient Available, lbs/ton",{"$f":"IF(J117=\"YES\",D123*D122,IF(J117=\"NO\",D123*E126))","v":0.19},{"$f":"IF(J117=\"YES\",E123*E122,IF(J117=\"NO\",E123*E127))","v":6.48},{"$f":"E124+D124","v":6.6700000000000008},{"$f":"IF(J117=\"YES\",G123*G122,IF(J117=\"NO\",G123*E128))","v":4.88},{"$f":"IF(J117=\"YES\",H123*H122,IF(J117=\"NO\",H123*E129))","v":10.728},{"$f":"IF(J117=\"YES\",I123*I122,IF(J117=\"NO\",I123*E130))","v":1.298}]
[null,null,"  7.3 Nutrient Available, lb/ac","West river-non irrigated",null,{"$f":"F129*F124","v":0},{"$f":"F129*G124","v":0},{"$f":"F129*H124","v":0},{"$f":"F129*I124","v":0}]
[null,null,"  7.4 Nutrient Balance, lbs/ac","East river-non irrigated",0.76,{"$f":"IF(I121>0,(F125-F121)+(I127*0.21),F125-F121)","v":-3},{"$f":"IF(G121=\"\",0,G125-G121)","v":0},{"$f":"IF(H121=\"\",0,H125-H121)","v":0},{"$f":"I125-I121","v":0}]
[null,null,"  7.5 Commercial Fertilizer Application Rate, lbs/ac","Irrigated",12.96,{"$f":"IF(F126>0,0,IF(AND(F126>=-3,F126<=-0.5),0,IF(F125>=F121,0,IF(AND(F126<0,F129=0),F138,IF(AND(J115=\"Urea\",F126<0),ABS(F126)*2.1739,IF(AND(J115=\"Anhydrous NH3\",F126<0),ABS(F126)*1.2195,IF(AND(J115=\"UAN-28%\",F126<0),ABS(F126)*3.5714,IF(F121=\"\",0))))))))","v":0},{"$f":"IF(G126>=0,0,IF(G126<0,ABS(G126)*1.9231))","v":0},{"$f":"IF(H126=0,0,IF(H126>0,0,IF(H126<0,ABS(H126)*1.66667)))","v":0},{"$f":"IF(I126>=0,0,IF(I126<0,ABS(I126)*4.1667))","v":0}]
[null,null,"  7.6 Application Rate, ton/ac","P205",6.1,{"$f":"IF(F124=0,0,F121/F124)","v":0.44977511244377805},null,"YES",null,"CLICK HERE TO GO BACK TO THE TOP."]
[null,null,"  7.7 Actual Application Rate, ton/ac","K2O",11.92]
[null,null,"  7.8 Application Cost per Load, $/load","S-SO4",2.36,null,{"$f":"IF(OR(F129=\"\", F129=0, F134=\"\", F134=0),0,((F130+(F131*F132))/(F134/F129))+F133)","v":0},"NO"]
[null,null,"  7.9 Hauling Cost, $/mile",null,null,null,{"$f":"IF(F129=0,0,G130+E146)","v":0},{"$f":"IF(J117=\"NO\",1,0)","v":1}]
[null,null,"  7.10 Hauling Distance, miles"]
[null,null,"  7.11 Incorporation Cost, $/ac"]
[null,null,"  7.12 Manure Hauler Truck/Spreader Capacity, tons"]
[null,null,"  7.13 Amount for the Field, ton",null,null,{"$f":"F129*D113","v":0}]
[null,null,"  7.14 Number of Loads for the Field",null,null,{"$f":"IF(F134=\"\",0,F135/F134)","v":0}]
[null,"Fertilizer","8. Nutrient Recommendation, lbs/ac",null,null,{"$f":"F121","v":3},{"$f":"IF(G212=\"\",0,G121)","v":0},{"$f":"IF(H121=\"\",0,H121)","v":0},{"$f":"I121","v":0}]
[null,null,"  8.1 Fertilizer Application Rate, lbs/ac",{"$f":"(G138*0.11)+(I138*0.21)","v":0},{"$f":"((G138*0.11)+(I138*0.21))-F137","v":-3},{"$f":"IF(F121<10,0,IF(J115=\"Urea\",ABS(E138)*2.17391,IF(J115=\"Anhydrous NH3\",ABS(E138)*1.2195,IF(J115=\"UAN-28%\",ABS(E138)*3.5714))))","v":0},{"$f":"IF(D116=\"\",0,G137*1.9231)","v":0},{"$f":"IF(D116=\"\",0,H137*1.6667)","v":0},{"$f":"IF(I121=\"\",0,I137*4.16667)","v":0}]
[]
[null,null,"  8.2 Nutrient Balance, lbs/ac",null,null,{"$f":"(ABS(E138)+D138-F137)","v":0},{"$f":"(G138/1.9231)-G137","v":0},{"$f":"(H138/1.6667)-H137","v":0},{"$f":"(I138/4.16667)-I137","v":0}]
[null,"Costs","9. Costs","Manure","Fertilizer"]
[null,null,"  9.1 Nitrogen, $/ac",{"$f":"IF(AND(J115=\"Urea\", F127>5),(F127*G113/2000)+(F125*H113),IF(J115=\"Urea\",H113*F129*F124,IF(AND(J115=\"Anhydrous NH3\", F127>5),(F127*G114/2000)+(F125*H114),IF(J115=\"Anhydrous NH3\",H114*F129*F124,IF(AND(J115=\"UAN-28%\", F127>5),(F127*G115/2000)+(F125*H115),IF(J115=\"UAN-28%\",H115*F129*F124))))))","v":0},{"$f":"IF(J115=\"Urea\",G113/2000*F138,IF(J115=\"Anhydrous NH3\",G114/2000*F138,IF(J115=\"UAN-28%\",G115/2000*F138)))","v":0},{"$f":"IF(F127=0,0,IF(J115=\"Urea\",F127*I113, IF(J115=\"Anhydrous NH3\",F127*I114,IF(J115=\"UAN-28%\",F127*I115))))","v":0},"N-Fertilizer Cost/ac  when Line 7.7 < Line 7.6"]
[null,null,"  9.2 Phosphorus (P2O5), $/ac",{"$f":"IF(OR(F129=0,G126>0),0,IF(G126<0,ABS(G126)*H116,IF(G122=\"\",0)))","v":0},{"$f":"IF(D116=\"\",0,G138*G116/2000)","v":0}]
[null,null,"  9.3 Potassium (K2O), $/ac",{"$f":"IF(OR(F129=0,H126>0),0,IF(H126<0,ABS(H126)*H117,IF(H122=\"\",0)))","v":0},{"$f":"IF(OR(D116=\"\",H121=0),0,H138*G117/2000)","v":0}]
[null,null,"  9.4 Sulfur (S-SO4), $/ac",{"$f":"IF(OR(I126>0, I121=\"\"),0,IF(I126<0,ABS(I126)*H118))","v":0},{"$f":"IF(OR(I121=0, I121=\"\"),0,I138*G118/2000)","v":0}]
[null,null,"  9.5 Application Cost, $/ac",{"$f":"IF(F129=\"\",0,IF(AND(F129>0, F127>5),G131,IF(F129>0,G130,IF(F129=0,0))))","v":0},6.5]
[null,null,"  9.6 TOTAL Cost, $/ac",{"$f":"SUM(D142:D146)","v":0},{"$f":"IF(F121=\"\",0,SUM(E142:E146))","v":6.5}]
[null,null,"  9.7 TOTAL Cost for the Field, $",{"$f":"D147*D113","v":0},{"$f":"E147*D113","v":0}]
[null,"Extra Value","10. Extra Nutrient Value"]
[null,null,"  10.1 Nitrogen (1st+2nd Year), $/ac",{"$f":"IF(AND(J115=\"Urea\", J117=\"NO\"), H113*F129*E127*0.15,IF(J115=\"Urea\",H113*F129*E122*0.15,IF(AND(J115=\"Anhydrous NH3\", J117=\"NO\"), H114*F129*E127*0.15,IF(J115=\"Anhydrous NH3\",H114*F129*E122*0.15,IF(AND(J115=\"UAN-28%\", J117=\"NO\"), H115*F129*E127*0.15,IF(J115=\"UAN-28%\",H115*F129*E122*0.15))))))","v":0},{"$f":"IF(J115=\"Urea\",(F137-ABS(E138))*H113,IF(J115=\"Anhydrous NH3\",(F137-ABS(E138))*H114,IF(J115=\"UAN-28%\",(F137-ABS(E138))*H115)))","v":0}]
[null,null,"  10.2 Phosphorus, $/ac",{"$f":"G125*H116","v":0},{"$f":"0","v":0}]
[null,null,"  10.3 K2O, $/ac",{"$f":"H125*H117","v":0},{"$f":"0","v":0}]
[null,null,"  10.4 Sulfur (S-SO4), $/ac",{"$f":"I125*H118","v":0},0]
[null,null,"  10.5 TOTAL Extra Nutrient Value, $/ac",{"$f":"SUM(D150:D153)","v":0},{"$f":"SUM(E150:E153)","v":0}]
[null,null,"  10.6 TOTAL Extra Nutrient Value for the Field, $",{"$f":"D154*D113","v":0},{"$f":"E154*D113","v":0},{"$nulls":4},"Contact Information"]
[null," Manure Cash Value","11. NET CASH VALUE, $/ac",{"$f":"IF(D113=\"\",0,E147-D147+D154-E154)","v":0},{"$nulls":5},"Paulo Flores"]
[{"$nulls":9},"Precision Agriculture Specialist"]
[null,null,"12. NET CASH VALUE  minus Extra K2O value , $/ac",{"$f":"IF(D113=\"\",0,D156-D152)","v":0},{"$nulls":5},"NDSU Carrington REC"]
[{"$nulls":9},"Email: paulo.flores@ndsu.edu"]
[null,null,"13. NET CASH VALUE for the Field  , $",{"$f":"IF(D148=0,0,D156*D113)","v":0},{"$nulls":5},"Phone:701-652-2951"]
[]
[null,null,"14. NET CASH VALUE for the  Field minus Extra K2O value, $",{"$f":"IF(D147=0,0,D158*D113)","v":0}]
[{"$nulls":9},"Updated on 02/04/2017"]

{"sheet":"Instr-Info","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,66,1]]}
[]
[null,"About the Spreadsheet\n- Please \"Enable Active Content\" (Microsoft Excel disables those functions as default) on Microsoft Excel so the calculator can perform as expected. \n- The fields highlighted in light blue throughout the spreadsheets are customizable and producers should add/change the values in those cells to reflect the values of their operation.\n- This calculator was designed to serve as a tool for producers to assess the nutrient value, on a cash basis, of beef feedlot manure when compared to commercial fertilizer, and to assist them with nutrient management on their operation. \n- On the calculator home screen, producers can select if the manure is going to be applied to meet \"Nitrogen Crop Requirements\" or \"Phosphorus Crop Requirements\". When applying manure to meet “Nitrogen Crop Requirements”, the spreadsheet calculates the \"Application Rate\" (Line 7.6) that will supply the total amount of N recommended for corn (Line 6). Because the recommended rate may be considered too high for some producers, there is a cell to enter the \"Actual Manure Application Rate\" (Line 7.7), that can be the same or smaller than the one listed on Line 7.6. Rates higher than the one on Line 7.6 are not recommended, since that would result in over application of nutrients, which can become an environmental issue.\n- The calculator provides a “Nutrients Balance” (Line 7.4) taking into consideration the nutrient contributions from manure and commercial fertilizers (when appropriate).  A negative number means that there is a deficit of that specific nutrient and that amount should be supplemented using a commercial fertilizer. This rate is shown on Line 7.5 (for the fertilizer sources listed in each spreadsheet). \n- The “Manure Net Cash Value” is calculated taking into consideration the amount of nutrients applied as manure and the cost per unit of N, P2O5, K2O and S in each of the fertilizers listed on the spreadsheets.  Therefore, a change on the source of N (Urea, Anhydrous Ammonia, or UAN-28%) or P (11-52-00 or 18-46-00) will change the final “Manure Net Cash Value”. The consideration or not of S application will change that value as well.\n- This calculator is not intended to provide N recommendations for corn production in ND. For that, producers are directed to the North Dakota Corn Nitrogen Calculator’ website, to determine the N recommendation for their operation, and then enter that number on Line 6 (Nutrient Recommendation), under the Nitrogen column of this calculator. The nutrient recommendations for P and K are determined using tables presented on the NDSU publication SF-882 (Revised) (North Dakota Fertilizer Recommendations Tables and Equations).\n- This calculator can be used to: 1) calculate nutrient balance when using manure and different sources of commercial fertilizer; 2) calculate the individual cost of nutrients plus the application cost when applying manure and/or fertilizer; 3) assess the maximum cost for manure per load; 4) determine the maximum manure hauling distance; 5) determine the amount of manure and number of loads necessary for a specific field.\n- The calculator has an option to perform the calculations using average values for manure nutrient content. As the amount of nutrients in manure show great variability, it is strongly recommended that producers have an analysis report for the manure that they are planning to apply on their fields. For that reason, the default option selected for the question \"Do you have a manure analysis report?\" is \"YES\" (Lines 5 and 6 in the furthest right column).\n\nSpreadsheet Content\nGeneral Information \nGeneral information about the user's field (ID, area), soil (nutrient content) and yield potential.\nManure Incorporation - Please Select One\nThe amount of the Ammonium-N that will be available for the crop is affected the number of the days that the manure remains in the soil surface without being incorporated. This choice will be reflected on the Nutrient Availability Factor (Line 7.1) and on the amount of N that will be available from manure to the crop (Line 7.2).\nNitrogen Source - Please Select One\nSelect from the dropdown list the N fertilizer you will be using on your operation. When a new source of N is selected, the spreadsheet automatically recalculates a series of new values associated with the N content and the cost of the new N source selected.\nPhosphorus Source - Please Select One\nSelect from the dropdown list the P fertilizer you will be using on your operation. When a new source of P is selected, the spreadsheet automatically recalculates a series of new values associated with the P and N content and the cost of the new P source selected.\nDo you have a manure analysis report?\nIf \"YES\" is selected, the user will be asked to enter the values for Ammonium-N, Organic-N, P2O5, K2O and S (all in lbs./ton) in line 7. If \"NO\" is selected, all the calculations will be done using average nutrient values for manure. Those average values are listed in the “Tables” tab in the Excel workbook.\nFertilizer (Sources and Prices)\nThe fertilizer sources listed in both spreadsheets are the ones most commonly used for crop production in ND.\nManure Nutrient Content (Line 7)\nThis refers to the nutrient content listed on your Manure Analysis Report. Make sure to use the values that are listed as lbs./ton.\nManure - Actual Application Rate (Line 7.7 - Nitrogen Spreadsheet)\nIn Line 7.6, there is a calculated \"Application Rate\" that will supply all of the N required by the crop. If manure is the only source of N to be used, the values in Lines 7.6 and 7.7 should be the same. If the value in Line 7.7 is smaller than the one on Line 7.6, the amount of manure to be applied will not be enough to supply all of the N required by the corn. So, some extra N has to be supplied as commercial fertilizer. The amount of nutrient will be shown in Line 7.4 (Nutrients Balance), as a negative number, and the fertilizer rate will be shown in Line 7.5.\nCommercial Fertilizer (Line 8)\nCalculates the commercial fertilizer needs for corn based on the sources of nutrients selected when there is no manure application. \nCosts (Line 9)\nThe cost per unit of nutrient (N, P2O5, K2O and S) contained in the manure or commercial fertilizer is the same, and it is based on the price of the different sources of N, P, K, and S fertilizers. With that in mind, the cost of N ($/ac, Line 9.1) for “Manure” and “Fertilizer” should be the same if the other sources of nutrients (P, K and S) would have no N. As an example, the most commonly used source of P fertilizer in ND is 11-52-00, which contains 11% N. Therefore, that N should be accounted for in the balance of nutrients and a lower rate of N fertilizer should be applied per acre, resulting in a slight lower N cost per unit area when using only commercial fertilizer. When relaying only on commercial fertilizer applications, producers will have a cost associated with each individual nutrient (S only if needed) recommended for corn production. When manure is used as source of nutrients, producers will see a cost associated with the target nutrient (N or P), and for those nutrients which the manure application did not reach the corn nutrient recommendations, which need to be supplemented as commercial fertilizer. In the case of N, the cost of the supplemental N fertilizer will show as a white line in the large gray box (on top of the “Print Nirtogen Report” button). The cost to apply that supplemental fertilizer amount is figured out in the application cost.\nAdditional Nutrient Value (Line 10)\nThe calculation of the additional nutrient values when applying manure is different when using the N or P spreadsheets. When using the first spreadsheet the N value is based on the assumption that 15% of the organic N in the manure will be available for the second year plus all the other nutrients (P2O5, K2O, and S) provided with the manure application. When using the P spreadsheet, the additional nutrient value of manure is calculated based on the value of the amount of N provided in the first year, plus the assumption that 15% of the organic N in the manure will be available for the second year, plus all the K2O and S provided with that manure application. For this calculator, the commercial fertilizer additional nutrient value is considered the N amounts present in P and S fertilizer sources used in the calculations (i.e. 11-52-00 is a source of P, and it contains 11%  N; 21-00-00-24 is a source of S, and it contains 21% sulfur). \nManure Cash Value (Lines 11 and 14)\nThe “Net Cash Value” per acre (Line 11) is calculated by the following expression: (Fertilizer Total Cost, $/ac) - (Manure Total Cost, $/ac) + (Manure Additional Nutrient Value, $/ac) - (Fertilizer Additional Nutrient Value, $/ac). Due to the natural high soil K content, several producers do not apply K fertilizers. For that reason, in Line 12 there is a “Net Cash Value” without considering the K2O additional nutrient value in manure. Lines 13 and 14 show the net cash values for the whole field, based on the area entered in Line 2.\n"]

{"sheet":"Tables","index":2,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,4,0,5],[0,0,0,1],[1,0,2,0],[7,4,8,5],[9,0,12,1]]}
["Average Nutrient Values for Solid Beef Manure.",null,null,null,"Fraction of ammonium nitrogen available the year of application"]
["Nutrients*","Concentration",null,null,"Preplant Application and Incorporated","Availability"]
[null,"lb/ton",null,null,"Immediately",0.95]
["Total Nitrogen (Total-N)",13.72,null,null,"One day later",0.5]
["Inorganic Nitrogen (Inorganic-N)",0.76,null,null,"Two days later",0.25]
["Organic Nitrogen (Organic-N)",12.96,null,null,"Three days later",0.15]
["Phosphorus (P2O5)",6.1,null,null,"Seven or more days later",0]
["Potassium (K2O)",11.92,null,null," Source: Wortman, C.S. & Shapiro, C.A. (2012). Calculating the Value of Manure for Crop Production (NebGuide G1519). University of Nebraska-Lincoln."]
["Sulfur (S)",2.36]
["* Average values from 193 cattle beef feedlot samples collected across North Dakota. Samples collected by NDSU-CREC Nutrient Management and Livestock Environmental Management Specialists and 319 Watershed Coordinators."]