Microsoft Excel Tutorial - Economic Based Nitrogen Rate Calculator
|Microsoft Excel Tutorial - Economic Based Nitrogen Rate Calculator
| FREE DOWNLOAD THIS TUTORIAL
Tutorial in pdf format so you can save it to your PC, e-book reader or print.
Note: The tutorial you are about to download is compressed format. Rar, if you do not have a decompressor rar files you can download 7-zip and you can display the Foxit PDF Reader.
Index Microsoft Excel Tutorial - Economic Based Nitrogen Rate Calculator
User’s Guide for the Microsoft Excel Economic Based Nitrogen Rate Calculator
Robert Mullen, Maurice Watson, Ed Lentz, and Greg LaBarge
Changing the Parameters to Meet Your Information
The first option to consider is the previous crop which can be located on the left hand side of the spreadsheet
Previous crop options that can be selected from a drop down menu (circled in red)
The next step is to identify the cost in dollars per pound of the nitrogen source you will be applying
Fertilizer material and material cost parameters that can be altered to calculate the price of the material in dollars per pound of nitrogen (circled in red)
The only other step involves altering the ‘Corn price’ and ‘N cost’ to provide the economic nitrogen rate recommendations
THE EXCEL SPREADSHEET DOES NOT PULL THE VALUE INTO THIS CELL AUTOMATICALLY
Corn price and nitrogen cost parameters that can be altered to generate the economic recommendations (circled in red)
Evaluating the Recommendation
Once you have entered in the corn price and nitrogen cost, the cells below titled
Lowest recommended N rate
Maximum return to nitrogen rate
Highest recommended N rate
Range of economic nitrogen recommendations based on corn price and nitrogen cost (circled in red)
Agronomic risk of the recommended nitrogen rate (circled in red)
Nitrogen rate necessary to achieve 95% of max yield 100% of the time not considering economic parameters (circled in red)
Understanding the Graphical Representation of the Data
Graphical representation of the information used to compute the economic range of nitrogen recommendations
Download the file decompressor 7-zip.
Download the PDF reader Foxit PDF Reader.