Application of Lotus 1-2-3 to SWMM Preprocessingby 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,
Abstract: 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 | Stormwater management | Spreadsheets | Environmental Protection Agency | Computer models | Knowledge-based systems | Structural models
Services: Buy this book/Buy this article
Return to search