Skip to main content

NLRS Scenario Development

2020 Illinois Nutrient Loss Reduction Strategy Scenarios (December 2020)
This document contains additional implementation scenarios for agricultural conservation practices to meet both interim and long-term water quality goals of the Illinois Nutrient Loss Reduction Strategy.

To view the 2020 Scenario Development Spreadsheet, please visit this webpage and click on the language "spreadsheet was developed".

This spreadsheet documents specific information used to develop the new interim and full water quality scenarios. Additionally, there is background information on land use and nitrogen and phosphorus loads, which factors into calculations. A blank scenario tab is available for users to enter acreages of specific practices to develop their scenario. Instructions are included in this tab. Except for selected cells in the blank scenario tab, this spreadsheet is locked to maintain the published scenarios, which should help with comparisons to custom scenarios. Questions regarding calculations or comments regarding bugs can be directed to Dr. Reid Christianson (