Economic Model of Deficit Irrigation II (spreadsheet)
Principal Investigator(s): View help for Principal Investigator(s) US Department of Agriculture; National Agricultural Library
Version: View help for Version V1
| Name | File Type | Size | Last Modified |
|---|---|---|---|
|
|
application/pdf | 131.8 KB | 06/26/2026 12:02:PM |
|
|
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet | 159.1 KB | 06/26/2026 12:02:PM |
|
|
application/json | 23.3 KB | 06/27/2026 06:24:AM |
|
|
text/html | 11.1 KB | 06/26/2026 12:02:PM |
Project Citation:
US Department of Agriculture, and National Agricultural Library. Economic Model of Deficit Irrigation II (spreadsheet). Ann Arbor, MI: Inter-university Consortium for Political and Social Research [distributor], 2026-06-27. https://doi.org/10.3886/E250420V1
Project Description
Project Title:
View help for Project Title
Economic Model of Deficit Irrigation II (spreadsheet)
Summary:
View help for Summary
This spreadsheet model calculates the net income for irrigated agricultural production. The model is designed to evaluate the economics of deficit irrigation (irrigation at less than the amount required to produce maximum yield).
The spreadsheet first models the water production function for a crop, then uses that relationship along with crop price and production costs to calculate net income and the irrigation amount that maximizes net income.
This spreadsheet is similar to another posted at Ag Data Commons: "Economic Model of Deficit Irrigation" (http://dx.doi.org/10.15482/USDA.ADC/1504421). That model was designed primarily to evaluate deficit irrigation as a means to compare revenue with reduced water consumption to income gained by transferring the saved water.
The model includes two common scenarios: 1) irrigation water supply is adequate but expensive, and 2) irrigation water supply is inadequate to fully irrigate the available land. In the first scenario, net income is maximized when the marginal costs of production, including water, is equal to the marginal revenue. In the second scenario, net income is maximized when the value of the water is maximized by selecting the portion of the land that should be irrigated. In the second scenario, the value and costs of the un-irrigated land are included.
The first worksheet of the spreadsheet describes the relationships used in each worksheet and the input parameters required. Additional worksheets calculate the water production function, the irrigation water production function, and the net income for each of the two scenarios. The worksheets allow the user to input the various biophysical and economic parameters relevant to their conditions and allows evaluating various parameter combinations. Each worksheet contains graphs to visualize the results.
Resources in this dataset:
Resource Title: Economic Model of Deficit Irrigation II (spreadsheet). File Name: WPF Econ Model V2 Mod.xlsxResource Description: Spreadsheet contains 5 worksheets. The first worksheet describes the relationships in the remaining worksheets and the parameters required by the model.Resource Software Recommended: Microsoft Excel 365 (may work on earlier versions),url: https://www.microsoft.com/en-us/microsoft-365/get-started-with-office-2019
Resource Title: Economic Model of Deficit Irrigation II (spreadsheet).
File Name: WPF Econ Model V2 Mod.xlsx
Resource Description: Spreadsheet contains 5 worksheets. The first worksheet describes the relationships in the remaining worksheets and the parameters required by the model.
Resource Software Recommended: Microsoft Excel 365 (may work on earlier versions),url: https://www.microsoft.com/en-us/microsoft-365/get-started-with-office-2019
Resource Title: Description of the Model. File Name: DataDictionary.pdfResource Description: Description of the model and input parameters.Resource Software Recommended: Adobe Reader,url: https://get.adobe.com/reader/otherversions/
Resource Title: Description of the Model.
File Name: DataDictionary.pdf
Resource Description: Description of the model and input parameters.
Resource Software Recommended: Adobe Reader,url: https://get.adobe.com/reader/otherversions/
The spreadsheet first models the water production function for a crop, then uses that relationship along with crop price and production costs to calculate net income and the irrigation amount that maximizes net income.
This spreadsheet is similar to another posted at Ag Data Commons: "Economic Model of Deficit Irrigation" (http://dx.doi.org/10.15482/USDA.ADC/1504421). That model was designed primarily to evaluate deficit irrigation as a means to compare revenue with reduced water consumption to income gained by transferring the saved water.
The model includes two common scenarios: 1) irrigation water supply is adequate but expensive, and 2) irrigation water supply is inadequate to fully irrigate the available land. In the first scenario, net income is maximized when the marginal costs of production, including water, is equal to the marginal revenue. In the second scenario, net income is maximized when the value of the water is maximized by selecting the portion of the land that should be irrigated. In the second scenario, the value and costs of the un-irrigated land are included.
The first worksheet of the spreadsheet describes the relationships used in each worksheet and the input parameters required. Additional worksheets calculate the water production function, the irrigation water production function, and the net income for each of the two scenarios. The worksheets allow the user to input the various biophysical and economic parameters relevant to their conditions and allows evaluating various parameter combinations. Each worksheet contains graphs to visualize the results.
Resources in this dataset:
Resource Title: Economic Model of Deficit Irrigation II (spreadsheet). File Name: WPF Econ Model V2 Mod.xlsxResource Description: Spreadsheet contains 5 worksheets. The first worksheet describes the relationships in the remaining worksheets and the parameters required by the model.Resource Software Recommended: Microsoft Excel 365 (may work on earlier versions),url: https://www.microsoft.com/en-us/microsoft-365/get-started-with-office-2019
Resource Title: Economic Model of Deficit Irrigation II (spreadsheet).
File Name: WPF Econ Model V2 Mod.xlsx
Resource Description: Spreadsheet contains 5 worksheets. The first worksheet describes the relationships in the remaining worksheets and the parameters required by the model.
Resource Software Recommended: Microsoft Excel 365 (may work on earlier versions),url: https://www.microsoft.com/en-us/microsoft-365/get-started-with-office-2019
Resource Title: Description of the Model. File Name: DataDictionary.pdfResource Description: Description of the model and input parameters.Resource Software Recommended: Adobe Reader,url: https://get.adobe.com/reader/otherversions/
Resource Title: Description of the Model.
File Name: DataDictionary.pdf
Resource Description: Description of the model and input parameters.
Resource Software Recommended: Adobe Reader,url: https://get.adobe.com/reader/otherversions/
Original Distribution URL:
View help for Original Distribution URL
https://agdatacommons.nal.usda.gov/articles/software/Economic_Model_of_Deficit_Irrigation_II_spreadsheet_/24665592
Scope of Project
Subject Terms:
View help for Subject Terms
Irrigation and Water Use;
deficit irrigation;
agricultural economics;
economic model;
NP211;
data.gov;
ARS
Geographic Coverage:
View help for Geographic Coverage
United States
Time Period(s):
View help for Time Period(s)
6/5/2020 – 6/5/2020
Data Type(s):
View help for Data Type(s)
program source code
Collection Notes:
View help for Collection Notes
DOI: 10.15482/USDA.ADC/1518761
Citation: Trout, Thomas (2020). Economic Model of Deficit Irrigation II (spreadsheet). Ag Data Commons. https://doi.org/10.15482/USDA.ADC/1518761 (Downloaded 2026-06-26)
Related Publications
Published Versions
Report a Problem
Found a serious problem with the data, such as disclosure risk or copyrighted content? Let us know.
This material is distributed exactly as received from the data depositor. ICPSR has not reviewed, checked, or processed this material. For additional information about the study, please contact the investigator(s) directly. If you have questions about the accessibility of materials distributed by ICPSR or require further assistance, please visit ICPSR's Accessibility Center.