Spreadsheet: 34db85eb-d4b4-4622-ade8-4f56979e9beb
Sheet: G1519-example

 | Calculating the Value of Manure
 | for Crop Production |  |  |  |  |  |  |  |  |  |  |  |  | Select Type of P Analysis
 | Field Information |  |  |  |  |  | Date: | 2012-11-05 00:00:00 |  |  |  |  |  | [NAME], Mehlich-3
 | Field: |  | Dad's 80, [NAME] |  |  |  | Air Temperature (°F): | 52 |  |  |  |  |  | Olsen
 |  | Next Crop: | corn / sorghum |  |  |  | Manure Source: | [NAME] |  |  |  |  |  | yes
 |  |  | no |  |  |  | Manure Type: | Beef/Dairy - Solid |  |  |  |  |  | no
 |  | Is the soil sandy? | no |  |  |  | Incorporation time: | 1 day later |  |  |  |  |  | corn / sorghum
 |  | Soil Test P: | 12 | ppm P2O5 |  |  |  |  |  |  |  |  |  | soybeans
 |  | Type of P Analysis: | [NAME], Mehlich-3 |  |  |  |  |  |  |  |  |  |  | grass
 |  | Soil Test K: | 205 | [NAME] |  | Nitrogen |  |  | P2O5 | K2O | Sulfur | Zinc |  | 2+ years of forage legume
 |  | Soil Test S: | 0 | [NAME] |  | Ammonium N | Organic N | Total N |  |  |  |  |  | Not Incorporated
 |  | Soil Test Zn: | 0.7 | [NAME] |  |  |  |  |  |  |  |  |  | Immediately
 | Nutrient Plan | 1. Manure nutrient content from manure test report (lbs/ton, lbs/1000 gal, or lbs/acre-inch). |  |  |  | 2 | 16 |  | 18 | 14 | 5 | 0.3 |  | 1 day later |  |  | Ammonium N available this year
 |  | 2. Nutrient availablility factors. See Tables 1 and 2 for nitrogen availability. |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  | 2 days later |  |  |  | liquid >50 | liquid <=50 | solid
 |  | 3. Available nutrients (lbs/ton, lbs/1000 gal, or lbs/acre-inch). |  |  |  |  |  |  |  |  |  |  |  | 3 days later |  |  | Not Incorporated |  |  | 0
 |  | 4. Nutrient recommendations for the next crop (lbs/acre/year). |  |  |  |  |  | 90 | 40 | 0 | 0 | 2.5 |  | 7+ days later | organic N this year ↓ |  | immediately | 0.95 | 0.95 | 0.95
 |  | 5a. Manure application rate to meet crop nitrogen rate (tons/acre, 1000 gal/acre, or acre-inches). |  |  |  |  |  |  |  |  |  |  |  | Beef/Dairy - Solid | 0.25 |  | 1 day later | 0.7 | 0.7 | 0.5
 |  | 5b. Actual manure application rate (tons/acre, 1000 gal/acre, or acre-inches). |  |  |  |  |  | 18 |  |  |  |  |  | Beef/Dairy - Stored liquid | 0.35 |  | 2 days later | 0.5 | 0.55 | 0.25
 | Nitrients of Value | 6. Total nutrients available (lbs/acre). |  |  |  |  |  |  |  |  |  |  |  | Beef/Dairy - Compost | 0.15 |  | 3 days later | 0.25 | 0.45 | 0.15
 |  | 7. Nutrient need for four years (except N) (lbs/acre). |  |  |  |  |  |  |  |  |  |  |  | Poultry - Deep pit | 0.45 |  | 7+ days later | 0 | 0.4 | 0
 |  | 8. Additional nutrients of value (lbs/acre). |  |  |  |  |  |  |  |  |  |  |  | Poultry - Solid with litter | 0.3
 |  | 9. Total nutrients of value (lbs/acre). |  |  |  |  |  |  |  |  |  |  |  | Poultry - Solid without litter | 0.35
 | Total and Net Value | 10. Fertilizer nutrient costs ($/lb). |  |  |  |  |  | 0.6 | 0.6 | 0.6 | 0.2 | 1.2 |  | Swine - Fresh | 0.5
 |  | 11. Manure nutrient values ($/acre). |  |  |  |  |  |  |  |  |  |  |  | Swine - stored liquid | 0.35
 |  | 12. Estimated value of yield increase ($/acre). |  |  |  | year 1 yield increase | year 1 crop value | year 2 yield increase | year 2 crop price
 |  |  |  |  |  | 5 | 5 | 1.5 | 12
 |  |  |  |  |  | year 3 yield increase | year 3 crop value | year 4 yield increase | year 4 crop price
 |  | 13. Total value of applied manure ($/acre).
 |  | 14. Manure value per unit ($[NAME], $/1000 gal, $/acre-inch).
 |  | 15. Manure costs: hauling, spreading, and incorporation ($/acre). |  |  |  | 15
 |  | 16. Net value of manure ($/acre).
 | Need | 17. Nutrients still needed for this year's crop (lbs/acre).