NMP Spreadsheet 5.2 Released
Posted: October 21, 2016
Planners can continue to use any NMP Spreadsheet 5.x Version. However the best practice is to use the latest version when starting a new plan. If a planner experiences any of the problems summarized below, then NMP Spreadsheet 5.2– October 2016 must be used. Highlights of these updates include:
Column and Row Header Input Messages Added
Column header pop-up notes were added throughout the spreadsheet. Users can click on column headers to help understand each entry or result and how to complete the input sheets. Column header pop-up notes were added to the input worksheets, optional worksheets, the NMP Summary, Table 5, and Table 6.
The planned manure application season cells in Table 5 that’s based on Agronomy Guide Table 1.2-14 A and B have a pop-up message appear when you select them. Additional details are provided to explain when the planned manure application season should be used.
The planned manure application season cells in Table 6 that’s based on Agronomy Guide Table 1.2-15 have a pop-up message appear when you select them. Additional details are provided to explain when the planned manure application season should be used.
Table 5 also updated to reflect an update to Table 1.2-14A in the 2017-2018 edition of the Penn State Agronomy Guide.
Manure Average Input Tab
The maximum value that can be entered for manure group analysis values for nitrogen, phosphate, potash was increased to 200 (lb/ton or lb/1000 gallons). The Organic N cell was formatted to display two decimal places.
Manure Average Printed Tab
The Total Organic N (lb/ton or lb/1000 gallons) value was displayed as whole number. The formatting on the Manure Average Printed tab was changed so the Total Organic N is displayed to hundredths (two decimal places).
App 4 Input Tab
An option to complete the P Index Part B was added if none of the Part B questions apply to a field and the planner wants to run the complete P Index on any fields. A check box called “Run P Index Part B” was added next to the Part A questions. If no P Index Part A questions for a field apply, then check this cell to add this field to the P Index.
In Version 5.1 when Summer: 1.2-15 was selected Spring: 1.2-15 would be displayed. In earlier versions of the spreadsheet the Spring/Summer were combined into a single selection. In Version 5.1 they were separated out but the N availabilities are the same and Spring: 1.2-15 was displayed for both selections. This has been corrected in Version 5.2 so that the Planned application season will state Summer: 1.12-15 instead of Spring: 1.2-15.
The colored conditional formatting for the N balanced rate, P removal Rate, and Planned rate cells are based on the P Index result. The red/green conditional formatting would reference the incorrect field when a field was inserted above a P index field. This issue has been resolved in Version 5.2.
Crops that receive a carryover legume nitrogen credit are considered a “summer annual”. The Crop List Options Tab lists all the crops that can be selected for a plan and will indicate if the crop is considered a summer annual and will receive the legume nitrogen credit. The cell color in App 4 Input will be light green if the crop selected is not a summer annual. In previous versions of the spreadsheet, only corn would receive the carryover legume nitrogen credit.
When Compost is selected as the manure type and Table 1.2-15 was used to calculate the nitrogen availability, the compost nitrogen availability was not available. The formula was updated to properly assign the Compost nitrogen availability factor.
When Compost is selected as the manure type and Table 1.2- 14 is used for the N availability determination, the spreadsheet will return a message “Use Table 1.2-15” in the App 4 Input N Balanced rate and in the Total N availability factors cell in the printed Appendix 4 Crop & Manure Management sheet.
When a grass hay crop was selected and Table 1.2-15 was used to calculate the nitrogen availability, the Organic N Availability was not properly calculated. The spreadsheet Crop List Options tab that lists all the crops was updated to include a “grass hay” column. This provides a look-up table to properly calculate the organic nitrogen availability for a grass hay crop when using Table 1.2-15.
Appendix 4 Crop & Manure Management Tab
Added a row titled: “Nutrients Applied at Planned Manure Rate (lb/A)” immediately after the planned manure rate. This row is the N-P2O5-K2O applied to the field at the planned manure application rate.
NMP Summary Tab
The total acres reported would sometimes display a #N/A when a field was added then deleted in App 4 Input. The formula was updated to fix this issue. The NMP Summary didn’t display a note to indicate that no manure was applied to a field. The spreadsheet was updated so “No Manure Applied” will be displayed in the Planned Manure Rate column of the NMP Summary.
Print NMP Report Tab
The print code to select sheets from a populated list was updated to work properly after a printing issue caused by an update by Microsoft Office was discovered.
Animal-Type Manure Production Tab
The Animal Type-Daily Manure Production Table was added to this worksheet. This was integrated into the previous “Add Animal Type” tab that was renamed “Animal-Type Manure Production”. This sheet lists all the animal types and the daily manure production values. Planners can still add animal types not listed in the spreadsheet and the associated uncollected manure production and nutrient content values. This was also updated to reflect an update to Table 1.2-13 in the 2017-2018 edition of the Penn State Agronomy Guide.
Crop List Options Tab
Additional columns were added for crop designations and will be used to assign the appropriate nitrogen availability for a crop. The following characteristic columns were added: Grass Hay – The "Grass Hay" designation will appropriately assign the Nitrogen availability when using the N fractions method, Table 1.2-15 in the Agronomy Guide. Legume – Crops with a legume designation will have a nitrogen balance of zero for the nutrient balance after manure. Summer Annual – Summer annual crops will receive a carryover legume nitrogen credit. They will utilize organic nitrogen that is mineralized during the warmer summer months.
Residual N Calculator Tab
The table was updated to include the organic nitrogen value for each year.
Table 6 Tab
Table 6 (Representing Table 1.2-15 in the Agronomy Guide) has been updated to include Nitrogen availability factors for manures that are very liquid manures (<5% solids). This update properly assigns the ammonium N availabilities to very liquid manures <5% solids after one day to account for soaking in after application.
PSU Nitrogen Recommendations Tab
The PSU N Rec worksheet table was made available as a displayed table so planners and reviewers can view the AASL soil test recommendations and yield groups. The yield groups for corn, soybeans, and wheat were updated to match the current Penn State AASL Tables.
PSU Phosphorous Recommendations Tab
The PSU P2O5 Rec worksheet table was made available as a displayed table so planners and reviewers can view the AASL soil test recommendations and yield groups.
PSU Potassium Recommendations Tab
The PSU K2O Rec worksheet table was made available as a displayed table so planners and reviewers can view the AASL soil test recommendations and yield groups.
The current version and release date of the NMP Standard Format Spreadsheet is “NMP Version 5.2 – October 2016”. It is available in Excel 2007-2010.