| This spreadsheet automates the calculations described in the document. It calculates yield loss based on the following user-inputs:
1) recommended rate of nutrient
2) amount to reduce the recommended rate
3) cost of a unit of nutrient
4) price of a unit of harvested crop
5) expected yield
6) yield with no nutrient applied (optional – but will improve estimates if used correctly)
When using the spreadsheet, please take note of the assumptions being made. Using improper assumptions can adversely affect the quality of the yield loss estimate. |