Application of Lotus 1-2-3 to SWMM Preprocessing

by S. Wayne Miles, Univ of Florida, Gainesville, FL, USA,
James P. Heaney, Univ of Florida, Gainesville, FL, USA,
Wayne C. Huber, Univ of Florida, Gainesville, FL, USA,
Thomas G. Potter, Univ of Florida, Gainesville, FL, USA,

Document Type: Proceeding Paper

Part of: Computing in Civil Engineering


This paper describes a preprocessor for the EPA Stormwater Management Model (SWMM) which is based on a Lotus 1-2-3 spreadsheet. Currently-used methods to input data into SWMM are described and are compared to the Lotus-based preprocessor. The advantages and disadvantages of Lotus as a preprocessor host are discussed. The internal structure of the preprocessor commands as written in Lotus' macro language is described including the 'Help' command which allows access to a number of reference files. Future improvements to the preprocessor are explained and conclusions as to its development are made. Use of the Lotus spreadsheet as a knowledge base and postprocessor for various calculation methods is discussed.

Subject Headings: Runoff | Spreadsheets | Computer models | Stormwater management | Hydrologic models | Knowledge-based systems | Management methods | Environmental Protection Agency

Services: Buy this book/Buy this article


Return to search