{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Editable Worksheet","G1519-ReadOnlyExample","Reference Tables"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[19,1,19,2],[10,1,10,2],[11,1,11,2],[13,1,13,2],[14,1,14,2],[16,1,16,2],[17,1,17,2],[8,1,8,2],[0,1,0,2],[1,1,1,2],[3,1,3,2],[4,1,4,2],[7,1,7,2]]}
[]
[null,"General Information"]
[null,null,"Fill in all blue and yellow boxes. For your convenience, yellow boxes have drop down lists.\n\nFill in the date, air temperature at the time of application, and manure source. Air temperature is important for calculating ammonia loss, particularly for liquid manures. Select the manure type and time to incorporation. If you select a liquid type manure, two more drop down boxes will appear below asking if this is applied as a sidedress or via sprinkler irrigation. Select your answer from the drop down list."]
[]
[null,"Field Information"]
[null,null,"Enter the name of the field in the first blue box. Select the next crop (or most similar) following manure application from the drop down list. If you select \"corn / sorghum\", another drop down box will appear below asking if this is in rotation or whether it is continuous. Select your answer from the drop down list.\n\nEnter your soil information including soil test numbers. For P2O5, you will need to select from the drop down list the type of analysis performed.\n\nIn addition to these instructions. More information can be found in NebGuide G1519: \"Calculating the Value of Manure for Crop Production\"."]
[null,null,"Calculating the Value of Manure for Crop Production"]
[]
[null,"Nutrient Plan"]
[null,null,"Enter your manure analysis information in line 1 and your nutrient recommendations for the next crop in line 4. If you do not know these numbers, typical manure nutrient values and crop removal rates can be found in reference tables 4 and 5. The manure application rate to meet N needs will automatically calculate in line 5a. Enter your actual manure application rate in line 5b."]
[]
[null,"Nutrients of Value"]
[null,null,"This section will automatically calculate `for you. If you are seeing errors in the cells, verify that you have entered all necessary information above. \n\nTotal available N in line 6 should not exceed total nitrogen on line for by more than 20 percent. If it does, the box will turn red, indicating there is a problem. \n\nLines 6, 7, 8 and 9 calculate the amount of nutrients in the manure that can be credited as contributing to future crop production, given the soil test and nutrient recommendations given in the Field Information box and line 4. The NebGuide explains the calculations for each nutrient separately. The nitrogen calculations are bit more complicated since there is only value of the nitrogen released if a grass crop is grown, therefore the future crop rotation is important. "]
[]
[null,"Total and Net Value"]
[null,null,"Fill in the nutrient costs if you were using commercial fertilizer instead of manure in line 10.\n\nIn line 12, estimate the yield increase for the next 4 years crops as well as the price of that crop per unit. \n\nEnter the total costs for hauling, spreading and and incorporation of the manure in line 15."]
[]
[null,"Need"]
[null,null,"Line 17 reports the amount of nutrients that are still needed for the next crop after manure application. "]

{"sheet":"Editable Worksheet","index":1,"n_rows":35,"n_cols":21,"rows_kept":35,"cut":false,"hidden":false,"merged":[[33,6,33,12],[34,2,34,5],[26,10,29,12],[30,2,30,5],[30,6,30,12],[31,2,31,5],[31,6,31,12],[32,2,32,5],[32,6,32,12],[20,1,23,1],[20,2,20,5],[21,2,21,5],[22,2,22,5],[23,2,23,5],[24,1,33,1],[24,2,24,5],[25,2,25,5],[26,2,29,5],[33,2,33,5],[11,12,13,12],[12,6,13,6],[12,7,13,7],[12,8,13,8],[14,17,14,20],[14,1,19,1],[14,2,14,5],[9,8,9,11],[10,3,10,5],[10,8,10,11],[11,6,11,8],[11,9,13,9],[11,10,13,10],[11,11,13,11],[19,2,19,5],[15,2,15,5],[16,2,16,5],[17,2,17,5],[18,2,18,5],[6,3,6,5],[6,8,6,11],[7,3,7,5],[7,8,7,11],[8,3,8,5],[8,8,8,11],[1,1,1,12],[2,1,2,12],[4,1,4,5],[4,8,4,11],[5,1,5,2],[5,3,5,5],[5,8,5,11],[3,1,3,12]]}
[]
[null,"Calculating the Value of Manure"]
[null," for Crop Production"]
[null,"This worksheet is part of NebGuide G1519, Calculating the Value of Manure for Crop Production."]
[null,"Field Information",null,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2022-09-27"},null,null,null,null,null,"Bray-1 P, Mehlich-3"]
[null,"Field:",null,null,null,null,null,"Air Temperature (°F):",null,null,null,null,null,null,"Olsen"]
[null,null,"Next Crop:",null,null,null,null,"Manure Source:",null,null,null,null,null,null,"yes","Yes, more than 0.40\""]
[null,null,{"$f":"IF(D7=O9,\"Continuous Corn?\",\"\")","v":""},null,null,null,null,"Manure Type:",null,null,null,null,null,null,"no","Yes, 0.40\" or less"]
[null,null,"Is the soil sandy?",null,null,null,null,"Incorporation time:",null,null,null,null,null,null,"corn / sorghum","No"]
[null,null,"Soil Test P:",null,"ppm P2O5",null,null,{"$f":"IF(OR(O28=S16,O28=T16),\"Sprinkler irrigated?\",\"\")","v":""},"Yes, more than 0.40\"",null,null,null,null,null,"soybeans"]
[null,null,"Type of P Analysis:",null,null,null,null,{"$f":"IF(OR(O28=S16,O28=T16),\"Sidedressed?\",\"\")","v":""},"no",null,null,null,null,null,"grass"]
[null,null,"Soil Test K:",null,"ppm",null,"Nitrogen",null,null,"P2O5","K2O","Sulfur","Zinc",null,"2+ years of forage legume"]
[null,null,"Soil Test S:",null,"ppm",null,"Ammonium N","Organic N","Total N",null,null,null,null,null,"Not Incorporated"]
[null,null,"Soil Test Zn:",null,"ppm",null,null,null,null,null,null,null,null,null,"Immediately"]
[null,"Nutrient Plan","1. Manure nutrient content from manure test report (lbs/ton, lbs/1000 gal, or lbs/acre-inch).\nBook values can be found in Reference Table 4.",null,null,null,null,null,null,null,null,null,null,null,"1 day later",null,null,"Ammonium N available this year"]
[null,null,"2. Nutrient availablility factors. \nSee Tables 1 and 2 for nitrogen availability.",null,null,null,{"$f":"IF(O28=S16,VLOOKUP(I9,R17:U22,2,FALSE),IF(O28=T16,VLOOKUP(I9,R17:U22,3,FALSE),IF(O28=U16,VLOOKUP(I9,R17:U22,4,FALSE),\"\")))","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(I8,O19:P27,2,FALSE)","v":{"$error":"#N/A"}},null,1,1,1,1,null,"2 days later",null,null,null,"liquid >50","liquid <=50","solid"]
[null,null,"3. Available nutrients (lbs/ton, lbs/1000 gal, or lbs/acre-inch). ",null,null,null,{"$f":"G15*G16","v":{"$error":"#N/A"}},{"$f":"H15*H16","v":{"$error":"#N/A"}},{"$f":"H17+G17","v":{"$error":"#N/A"}},{"$f":"J15*J16","v":0},{"$f":"K15*K16","v":0},{"$f":"L15*L16","v":0},{"$f":"M15*M16","v":0},null,"3 days later",null,null,"Not Incorporated",{"$f":"IF(AND(H11=\"Sidedressed?\",I11=O7),0.95,IF(AND(H10=\"Sprinkler irrigated?\",I10=P7),0.8,IF(AND(H10=\"Sprinkler irrigated?\",I10=P8),0.4,0)))","v":0},{"$f":"IF(AND(H11=\"Sidedressed?\",I11=O7),0.95,IF(AND(H10=\"Sprinkler irrigated?\",I10=P7),0.8,IF(AND(H10=\"Sprinkler irrigated?\",I10=P8),0.4,0)))","v":0},0]
[null,null,"4. Nutrient recommendations for the next crop (lbs/acre/year).\nIf you do not have recommendations, nutrient removal rates can be found in Reference Table 5.",null,null,null,null,null,null,null,null,null,null,null,"7+ days later","organic N this year ↓",null,"immediately",{"$f":"'Reference Tables'!D11","v":0.95},{"$f":"'Reference Tables'!F11","v":0.95},{"$f":"'Reference Tables'!C11","v":0.95}]
[null,null,"5a. Manure application rate to meet crop nitrogen rate (tons/acre, 1000 gal/acre, or acre-inches).",null,null,null,null,null,{"$f":"I18/I17","v":{"$error":"#N/A"}},null,null,null,null,null,"Beef Solid",0.4,null,"1 day later",{"$f":"'Reference Tables'!D12","v":0.7},{"$f":"'Reference Tables'!F12","v":0.7},{"$f":"'Reference Tables'!C12","v":0.5}]
[null,null,"5b. Actual manure application rate (tons/acre, 1000 gal/acre, or acre-inches).",null,null,null,null,null,null,null,null,null,null,null,"Beef Liquid",0.4,null,"2 days later",{"$f":"'Reference Tables'!D13","v":0.45},{"$f":"'Reference Tables'!F13","v":0.55000000000000004},{"$f":"'Reference Tables'!C13","v":0.25}]
[null,"Nitrients of Value","6. Total nutrients available (lbs/acre).",null,null,null,null,null,{"$f":"I17*$I20","v":{"$error":"#N/A"}},{"$f":"ROUND(J17*$I20,0)","v":0},{"$f":"ROUND(K17*$I20,0)","v":0},{"$f":"ROUND(L17*$I20,0)","v":0},{"$f":"ROUND(M17*$I20,0)","v":0},null,"Dairy Solid",0.4,null,"3 days later",{"$f":"'Reference Tables'!D14","v":0.25},{"$f":"'Reference Tables'!F14","v":0.45},{"$f":"'Reference Tables'!C14","v":0.15}]
[null,null,"7. Nutrient need for four years (except N) (lbs/acre).",null,null,null,null,null,null,{"$f":"J18*4","v":0},{"$f":"K18*4","v":0},{"$f":"L18*4","v":0},{"$f":"IF(M18*4>5,5,M18*4)","v":0},null,"Dairy Liquid",0.4,null,"7+ days later",{"$f":"'Reference Tables'!D15","v":0},{"$f":"'Reference Tables'!F15","v":0.4},{"$f":"'Reference Tables'!C15","v":0}]
[null,null,"8. Additional nutrients of value (lbs/acre).",null,null,null,null,null,{"$f":"IF(OR(AND(D7=O9,D8=O7),D7=O10,D7=O11),0.2,IF(D7=O12,0,IF(AND(D7=O9,D8=O8),0.1,FALSE)))*H15*I20","v":0},{"$f":"IF(ISBLANK(D10),\"Enter Soil Test P\",IF(ISBLANK(D11),\"Select P Analysis Type\",IF(AND(J22<J21,ISNUMBER(D10)),IF(D11=O5,IF(D10<15,IF(J21-J22<250,J21-J22,250),IF(D10<25,IF(J21-J22<150,J21-J22,150),0)),IF(D11=O6,IF(D10<10,IF(J21-J22<250,J21-J22,250),IF(D10<18,IF(J21-J22<150,J21-J22,150),0)),0)),0)))","v":"Enter Soil Test P"},{"$f":"IF(ISBLANK(D12),\"Enter Soil Test K\",IF(AND(K22<K21,ISNUMBER(D12)),IF(D12<150,IF(K21-K22<200,K21-K22,200),0),0))","v":"Enter Soil Test K"},{"$f":"IF(ISBLANK(D13),\"Enter Soil Test S\",IF(AND(L22<L21,ISNUMBER(D13)),IF(AND(D13<10,D9=\"yes\"),IF(L21-L22<40,L21-L22,40),0),0))","v":"Enter Soil Test S"},{"$f":"IF(ISBLANK(D14),\"Enter Soil Test Zn\",IF(AND(M22<M21,ISNUMBER(D14)),IF(D14<1,IF(M21-M22<20,M21-M22,20),0),0))","v":"Enter Soil Test Zn"},null,"Composted Feedlot",0.15]
[null,null,"9. Total nutrients of value (lbs/acre). ",null,null,null,null,null,{"$f":"ROUND(IF(D7=O9,I23+I21,I23),0)","v":0},{"$f":"IF(ISNUMBER(J23),IF(IF(J21<J22,J21+J23,IF(J21>J22,J22+J23,\"\"))<J21,IF(J21<J22,J21+J23,IF(J21>J22,J22+J23,\"\")),J21),\"\")","v":""},{"$f":"IF(ISNUMBER(K23),IF(IF(K21<K22,K21+K23,IF(K21>K22,K22+K23,\"\"))<K21,IF(K21<K22,K21+K23,IF(K21>K22,K22+K23,\"\")),K21),\"\")","v":""},{"$f":"IF(ISNUMBER(L23),IF(IF(L21<L22,L21+L23,IF(L21>L22,L22+L23,\"\"))<L21,IF(L21<L22,L21+L23,IF(L21>L22,L22+L23,\"\")),L21),\"\")","v":""},{"$f":"IF(ISNUMBER(M23),IF(IF(M21<M22,M21+M23,IF(M21>M22,M22+M23,\"\"))<M21,IF(M21<M22,M21+M23,IF(M21>M22,M22+M23,\"\")),M21),\"\")","v":""},null,"Layer (no bedding)",0.45]
[null,"Total and Net Value","10. Fertilizer nutrient costs ($/lb).",null,null,null,null,null,null,null,null,null,null,null,"Poultry",0.4]
[null,null,"11. Manure nutrient values ($/acre).",null,null,null,null,null,{"$f":"I25*I24","v":0},{"$f":"IF(J25>0,J25*J24,0)","v":0},{"$f":"IF(K25>0,K25*K24,0)","v":0},{"$f":"IF(L25>0,L25*L24,0)","v":0},{"$f":"IF(M25>0,M25*M24,0)","v":0},null,"Swine Solid",0.4]
[null,null,"12. Estimated value of yield increase ($/acre).",null,null,null,"year 1 yield increase","year 1 crop price","year 2 yield increase","year 2 crop price",{"$f":"G28*H28+I28*J28+G30*H30+I30*J30","v":0},null,null,null,"Swine Liquid",0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(O27=I8,I8=O20,I8=O22),IF(I6>50,S16,T16),U16)","v":"solid"}]
[null,null,null,null,null,null,"year 3 yield increase","year 3 crop price","year 4 yield increase","year 4 crop price"]
[]
[null,null,"13. Total value of applied manure ($/acre).",null,null,null,{"$f":"SUM(I26:M26,K27)","v":0}]
[null,null,"14. Manure value per unit ($/ton, $/1000 gal, $/acre-inch).",null,null,null,{"$f":"G31/I20","v":{"$error":"#DIV/0!"}}]
[null,null,"15. Manure costs: hauling, spreading, and incorporation ($/acre)."]
[null,null,"16. Net value of manure ($/acre).",null,null,null,{"$f":"G31-G33","v":0}]
[null,"Need","17. Nutrients still needed for this year's crop (lbs/acre). ",null,null,null,null,null,{"$f":"IF(I18-I21<0,0,I18-I21)","v":{"$error":"#N/A"}},{"$f":"IF(J18-J21<0,0,J18-J21)","v":0},{"$f":"IF(K18-K21<0,0,K18-K21)","v":0},{"$f":"IF(L18-L21<0,0,L18-L21)","v":0},{"$f":"IF(M18-M21<0,0,M18-M21)","v":0}]

{"sheet":"G1519-ReadOnlyExample","index":2,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":false,"merged":[[33,6,33,12],[34,2,34,5],[26,10,29,12],[30,2,30,5],[30,6,30,12],[31,2,31,5],[31,6,31,12],[32,2,32,5],[32,6,32,12],[20,1,23,1],[20,2,20,5],[21,2,21,5],[22,2,22,5],[23,2,23,5],[24,1,33,1],[24,2,24,5],[25,2,25,5],[26,2,29,5],[33,2,33,5],[11,12,13,12],[12,6,13,6],[12,7,13,7],[12,8,13,8],[14,1,19,1],[14,2,14,5],[15,2,15,5],[16,2,16,5],[17,2,17,5],[18,2,18,5],[19,2,19,5],[9,8,9,11],[10,3,10,5],[10,8,10,11],[11,6,11,8],[11,9,13,9],[11,10,13,10],[11,11,13,11],[6,3,6,5],[6,8,6,11],[7,3,7,5],[7,8,7,11],[8,3,8,5],[8,8,8,11],[5,1,5,2],[5,3,5,5],[5,8,5,11],[1,1,1,12],[2,1,2,12],[3,1,3,12],[4,1,4,5],[4,8,4,11]]}
[]
[null,"Calculating the Value of Manure"]
[null," for Crop Production"]
[null,"This worksheet is part of NebGuide G1519, Calculating the Value of Manure for Crop Production."]
[null,"Field Information",null,null,null,null,null,"Date:","2021-07-20"]
[null,"Field:",null,"Dad's 80, S-20 Ac",null,null,null,"Air Temperature (°F):",85]
[null,null,"Next Crop:","corn / sorghum",null,null,null,"Manure Source:","Upper Lots"]
[null,null,"Continuous Corn?","no",null,null,null,"Manure Type:","Beef Solid"]
[null,null,"Is the soil sandy?","no",null,null,null,"Incorporation time:","1 day later"]
[null,null,"Soil Test P:",12,"ppm P2O5",null,null,"","Yes, more than 0.40\""]
[null,null,"Type of P Analysis:","Bray-1 P, Mehlich-3",null,null,null,"","no"]
[null,null,"Soil Test K:",205,"ppm",null,"Nitrogen",null,null,"P2O5","K2O","Sulfur","Zinc"]
[null,null,"Soil Test S:",0,"ppm",null,"Ammonium N","Organic N","Total N"]
[null,null,"Soil Test Zn:",0.7,"ppm"]
[null,"Nutrient Plan","1. Manure nutrient content from manure test report (lbs/ton, lbs/1000 gal, or lbs/acre-inch).\nBook values can be found in Reference Table 4.",null,null,null,2,16,18,18,14,5,0.3]
[null,null,"2. Nutrient availablility factors. \nSee Tables 1 and 2 for nitrogen availability.",null,null,null,0.5,0.4,null,1,1,1,1]
[null,null,"3. Available nutrients (lbs/ton, lbs/1000 gal, or lbs/acre-inch). ",null,null,null,1,6.4,7.4,18,14,5,0.3]
[null,null,"4. Nutrient recommendations for the next crop (lbs/acre/year).\nIf you do not have recommendations, nutrient removal rates can be found in Reference Table 5.",null,null,null,null,null,90,40,0,0,2.5]
[null,null,"5a. Manure application rate to meet crop nitrogen rate (tons/acre, 1000 gal/acre, or acre-inches).",null,null,null,null,null,12.162162162162161]
[null,null,"5b. Actual manure application rate (tons/acre, 1000 gal/acre, or acre-inches).",null,null,null,null,null,12]
[null,"Nitrients of Value","6. Total nutrients available (lbs/acre).",null,null,null,null,null,88.800000000000011,216,168,60,4]
[null,null,"7. Nutrient need for four years (except N) (lbs/acre).",null,null,null,null,null,null,160,0,0,5]
[null,null,"8. Additional nutrients of value (lbs/acre).",null,null,null,null,null,19.200000000000003,56,0,0,0]
[null,null,"9. Total nutrients of value (lbs/acre). ",null,null,null,null,null,108,216,0,0,4]
[null,"Total and Net Value","10. Fertilizer nutrient costs ($/lb).",null,null,null,null,null,0.65,0.65,0.5,0.5,3]
[null,null,"11. Manure nutrient values ($/acre).",null,null,null,null,null,70.2,140.4,0,0,12]
[null,null,"12. Estimated value of yield increase ($/acre).",null,null,null,"year 1 yield increase","year 1 crop price","year 2 yield increase","year 2 crop price",47]
[null,null,null,null,null,null,5,5.5,1.5,13]
[null,null,null,null,null,null,"year 3 yield increase","year 3 crop price","year 4 yield increase","year 4 crop price"]
[]
[null,null,"13. Total value of applied manure ($/acre).",null,null,null,269.60000000000002]
[null,null,"14. Manure value per unit ($/ton, $/1000 gal, $/acre-inch).",null,null,null,22.466666666666669]
[null,null,"15. Manure costs: hauling, spreading, and incorporation ($/acre).",null,null,null,8]
[null,null,"16. Net value of manure ($/acre).",null,null,null,261.60000000000002]
[null,"Need","17. Nutrients still needed for this year's crop (lbs/acre). ",null,null,null,null,null,1.1999999999999886,0,0,0,0]

{"sheet":"Reference Tables","index":3,"n_rows":76,"n_cols":8,"rows_kept":76,"cut":false,"hidden":false,"merged":[[33,4,33,5],[33,3,34,3],[75,0,75,6],[57,0,57,7],[35,4,35,7],[53,4,53,7],[44,4,44,7],[33,7,34,7],[33,6,34,6],[18,2,18,3],[30,2,30,3],[29,2,29,3],[28,2,28,3],[22,2,22,3],[21,2,21,3],[19,2,19,3],[23,2,23,3],[27,2,27,3],[10,3,10,4],[9,3,9,4],[14,5,14,6],[13,5,13,6],[12,5,12,6],[11,5,11,6],[10,5,10,6],[9,5,9,6],[14,3,14,4],[13,3,13,4],[12,3,12,4],[11,3,11,4]]}
["Table 1. Fraction of ammonium nitrogen available this year."]
["Sidedress Application"]
[null,"Injected",0.95]
["Sprinkler Irrigated"]
[null,"> 0.4\" applied",0.8]
[null,"≤ 0.4\" applied",0.4]
["Preplant Application and Not Incorporated"]
[null,"Surface - spring or fall",0]
["Preplant Application and Incorporated"]
[null,null,"Solid","Liquid Applied When Air Temperature is Above 50°F",null,"Liquid Applied When Air Temperature is At or Below 50°F"]
[null,"Immediately",0.95,0.95,null,0.95]
[null,"One day later",0.5,0.7,null,0.7]
[null,"Two days later",0.25,0.45,null,0.55000000000000004]
[null,"Three days later",0.15,0.25,null,0.45]
[null,"Seven or more days later",0,0,null,0.4]
[]
["Table 2. Fraction of organic nitrogen available this year."]
["Beef/Dairy Manure"]
[null,"Solid or stored liquid",0.4]
[null,"Composted feedlot",0.15]
["Poultry Manure"]
[null,"Layers with no bedding",0.45]
[null,"All other poultry",0.4]
["Swine Manure",null,0.4]
[]
["Table 3. Organic nitrogen released over time."]
["Rotation"]
[null,"corn-soybeans",7.0000000000000007E-2]
[null,"corn-corn",0.35]
[null,"soybeans - corn",7.0000000000000007E-2]
[null,"corn-alfalfa-alfalfa",0]
[]
["Table 4. Typical Manure Values"]
[null,null,null,"% Dry Matter","Nitrogen",null,"P2O5","K2O"]
[null,null,null,null,"Ammonium-N","Organic-N"]
["Slurry Manure",null,null,null,"----- lbs. of nutrient per 1,000 gallons of manure -----"]
[null,"Dairy",null,8,12,13,25,40]
[null,"Beef†",null,10,21,24,24,36]
[null,"Swine (finisher, wet-dry feeder)",null,9,42,17,40,24]
[null,"Swine (slurry storage, dry feeder)",null,6,28,11,34,24]
[null,"Swine (flush building)",null,2,12,5,13,17]
[null,"Layer¥",null,null,42,20,59,37]
[null,"Dairy (lagoon sludge)*",null,10,4,17,20,16]
[null,"Swine (lagoon sludge)",null,10,6,16,48,7]
["Solid Manure",null,null,null,"----- lbs. of nutrient per ton of manure -----"]
[null,"Beef (dirt lot)",null,67,2,22,23,30]
[null,"Beef (paved lot)*",null,29,5,9,9,16]
[null,"Beef (bedded pack barn)†",null,30,1,17,11,14]
[null,"Swine (hoop barns)‡",null,40,6,20,15,18]
[null,"Dairy (scraped earthen lots)",null,46,null,14,11,16]
[null,"Broiler (litter from house)",null,69,15,60,27,33]
[null,"Layer",null,41,18,19,55,32]
[null,"Turkey (grower house litter)",null,70,null,44,15,30]
["Liquid Effluent from lagoon or holding pond",null,null,null,"----- lbs. of nutrient per acre-inch -----"]
[null,"Beef (runoff holding pond)†",null,5,44,5,20,109]
[null,"Swine (lagoon)",null,0.4,91,45,104,192]
[null,"Dairy (lagoon)",null,2,181,null,83,302]
["Values are based upon ASABE, 2005, D384.2; Manure Production and Characteristics with exception of those noted with the superscripts described below. Please note that these values have not been updated by the ASABE since 2005 and therefore might not accurately reflect manure produced by livestock systems that are feeding distillers grains."]
["† Values based upon Iowa State publication PM1867, revised 2015."]
["¥ Values based upon North Carolina State University publication AG-439-5, revised 1997."]
["‡ Values based upon University of Missouri publication EQ 352, revised 2003."]
[]
["Table 5. Crop removal rates."]
[null,"Crop","Test Weight","Dry Matter, %","N","P2O5","Units"]
[null,"Corn (grain)",56,85,0.7,0.31,"lb/bu"]
[null,"Corn (stover)",null,85,17.7,3.5,"lb/ton"]
[null,"Corn (silage)",null,35,9,3.2,"lb/ton"]
[null,"Oats (grain)",32,86,0.6,0.23,"lb/bu"]
[null,"Oats (straw)",null,90,12.7,2.5,"lb/ton"]
[null,"Wheat (grain)",60,86.5,1.2,0.5,"lb/bu"]
[null,"Wheat (straw)",null,90,10.1,2.1,"lb/ton"]
[null,"Small grain hay",null,85,34,11.7,"lb/ton"]
[null,"Soybeans (grain)",60,87,3.5,0.79,"lb/bu"]
[null,"Alfalfa (hay)",null,85,46.2,9.3000000000000007,"lb/ton"]
[null,"Alfalfa (silage)",null,40,21.8,4.9000000000000004,"lb/ton"]
["Other crop information can be found on page 89 of the Manure Application Workbook, which can be found at http://go.unl.edu/manure_workbooks"]