Water Resources Analysis Using Electronic Spreadsheets
Publication: Journal of Water Resources Planning and Management
Volume 113, Issue 5
Abstract
Electronic spreadsheet software developed for microcomputers provides a means by which an engineer can prepare and analyze data, estimate model parameters, perform desktop calculations, and thoroughly document all work. This paper presents ways to use spreadsheets to perform a variety of tasks related to solving water resources problems. Applications include database management, simple computer mapping, spatial data analysis, a hydrologic budget, trend analysis, a runoff simulation, a flood routing simulation, and a continuous surface‐groundwater model. Examples from a recently completed water resources study are included.
Get full access to this article
View all available purchase options and get full access to this article.
References
1.
Anderson, D., and Cobb, D. F. (1984). 1‐2‐3 tips, tricks, and traps. Que Corp., Indianapolis, Ind.
2.
Cruetin, J. D., and Obled, C. (1982). “Objective analysis and mapping techniques for rainfall fields: an objective comparison.” Water Resour. Res., 18(2), 413–431.
3.
Golden Software. (1985). “Golden graphics systems.” Version 2.00, Golden Software, Inc., Golden, Colo.
4.
Hancock, M. C. (1986). “Analysis of water resources problems using electronic spreadsheets.” Publication No. 92, Florida Water Resour. Res. Center, Univ. of Florida, Gainesville, Fla.
5.
Heaney, J. P., et al. (1986). “Impacts of development on the water resources of Cypress Creek north of Tampa.” Publication No. 89, Florida Water Resour. Res. Center, Univ. of Florida, Gainesville, Fla.
6.
Hicks, C. N. (1985). “Continuous simulation of surface and subsurface flows in Cypress Creek Basin, Florida, using hydrological simulation program—fortran (HSPF),” thesis presented to the University of Florida, Gainesville, Florida, in partial fulfillment of the requirements for the degree of Master of Science.
7.
Johnson, L. E. (1986). “Water resource management decision support systems.” J. Water Resour. Planning Mgmt., ASCE, 112(3), Jul., 308–325.
8.
LeBlond, G. T., and Cobb, D. F. (1983). Using 1‐2‐3. Que Corp., Indianapolis, Ind.
9.
Lotus Development Corporation. (1985). Lotus 1‐2‐3. Release 2, Cambridge, Mass.
10.
McDonald, M. G., and Harbaugh, A. W. (1984). A modular three‐dimensional groundwater flow model. USGS, Reston, Va.
11.
Miles, S. W., et al. (1986). “Application of Lotus 1‐2‐3 to SWMM preprocessing.” Proceedings, Fourth Conference on Computing in Civ. Engrg., Boston, Mass.
12.
Olsthoorn, T. N. (1985). “The power of the electronic worksheet: modeling without special programs.” Ground Water J., 23(3), 381–390.
13.
Ridington, R. W., and Williams, M. M. (1985). The hidden power of Lotus 1‐2‐3: using macros. Brady Communications Co., Inc., Bowie, Md.
14.
Rouhani, S. (1985). “Variance reduction analysis.” Water Resour. Res., 21(6), 837–846.
15.
Sampson, R. J. (1978). “Surface II graphics system.” Kansas Geological Survey Series in Spatial Analysis, 1, Univ. of Kansas, Lawrence, Kans.
16.
South Florida Water Mgmt. Dist. (1984). “Permitting information manual, Vol. IV.” Management and Storage of Surface Waters, Resour. Control Dept., West Palm Beach, Fla.
17.
Tabios, G. Q. III, and Salas, J. D. (1985). “A comparative analysis of techniques for spatial interpolation of precipitation.” Water Resour. Bulletin, 21(3), 365–380.
Information & Authors
Information
Published In
Journal of Water Resources Planning and Management
Volume 113 • Issue 5 • September 1987
Pages: 639 - 658
Copyright
Copyright © 1987 ASCE.
History
Published online: Sep 1, 1987
Published in print: Sep 1987
Authors
Metrics & Citations
Metrics
Citations
Download citation
If you have the appropriate software installed, you can download article citation data to the citation manager of your choice. Simply select your manager software from the list below and click Download.