Water Resources Analysis Using Electronic Spreadsheets

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.