Applying EXCEL Solver to a watershed management goal-programming problem

J. E. de Steiguer

Treesearch

Applying EXCEL Solver to a watershed management goal-programming problem

Informally Refereed

Authors:

J. E. de Steiguer

Year:

2000

Type:

Proceedings

Station:

Rocky Mountain Research Station

Source:

In: Ffolliott, Peter F.; Baker Jr., Malchus B.; Edminster, Carleton B.; Dillon, Madelyn C.; Mora, Karen L., tech. coords. Land Stewardship in the 21st Century: The Contributions of Watershed Management; 2000 March 13-16; Tucson, AZ. Proc. RMRS-P-13. Fort Collins, CO: U.S. Department of Agriculture, Forest Service, Rocky Mountain Research Station. p. 325-329.

Download (PDF 192 KB)

Download (PDF 192 KB): https://research.fs.usda.gov/download/treesearch/42057.pdf

Abstract

This article demonstrates the application of EXCEL® spreadsheet linear programming (LP) solver to a watershed management multiple use goal programming (GP) problem. The data used to demonstrate the application are from a published study for a watershed in northern Colorado. GP has been used by natural resource managers for many years. However, the GP solution by means of EXCEL® spreadsheet presented here is thought to be novel.

Parent Publication

Land Stewardship in the 21st Century: The Contributions of Watershed Management; 2000 March 13-16; Tucson, AZ

Keywords

land stewardship, watershed management, ecosystem-based management, natural resources, conservation, sustainable development, sustainable use

Citation

de Steiguer, J. E. 2000. Applying EXCEL Solver to a watershed management goal-programming problem. In: Ffolliott, Peter F.; Baker Jr., Malchus B.; Edminster, Carleton B.; Dillon, Madelyn C.; Mora, Karen L., tech. coords. Land Stewardship in the 21st Century: The Contributions of Watershed Management; 2000 March 13-16; Tucson, AZ. Proc. RMRS-P-13. Fort Collins, CO: U.S. Department of Agriculture, Forest Service, Rocky Mountain Research Station. p. 325-329.