Better Than “Optimal” Method for Designing Drainage Systems
Publication: Journal of Water Resources Planning and Management
Volume 114, Issue 5
Abstract
The Lotus 1‐2‐3 spreadsheet package has been used to develop a stormwater drainage design method which is based on the Florida Department of Transportation's (FDOT) hand tabulation form (FDOT 1987). By using the FDOT procedure, the spreadsheet method allows engineers already familiar with the manual calculation procedure to more easily adapt to the new microcomputer environment. The spreadsheet performs the necessary calculations quickly and easily while not hindering the user with tedious input procedures and confusing algorithms typical of many computer codes. The spreadsheet method also employs a heuristic cost estimation approach which allows the user to find a least cost design. This method has been used to solve a problem previously solved with two dynamic programming algorithms. Since the spreadsheet method does not use a sophisticated optimization algorithm, many simplifying assumptions made in the dynamic programming algorithms are not necessary. The results show that the spreadsheet method was able to significantly improve on the dynamic programming designs while more consistently meeting the design criteria.
Get full access to this article
View all available purchase options and get full access to this article.
References
1.
American Society of Civil Engineers and Water Pollution Control Federation. (1969). “Design and construction of sanitary and storm sewers.” ASCE Manual 37, New York, N.Y.
2.
Brown, K. G., and Koussis, A. D. (1987). “LOTUS spreadsheet design for storm drain networks.” J. of Comp. in Civ. Engrg., ASCE, 1(3), 197–213.
3.
Christensen, B. A. (1984). “Analysis of partially filled circular storm sewers.” Proc. of Water for Resource Development. Hydr. Div., ASCE, New York, N.Y., 163–167.
4.
Florida Department of Transportation (1987). Drainage Manual, Tallahassee, Fla.
5.
Hancock, M. C., and Heaney, J. P. (1987). “Water resources analysis using electronic spreadsheets.” J. of Water Resour. Plng. and Mgmt., ASCE, 113(5), 639–658.
6.
Hillier, F. S., and Lieberman, G. J. (1986). Introduction to Operations Research, Fourth Ed., Holden Day, Inc., Oakland, Calif.
7.
Klemes, V. (1979). “Storage mass‐curve analysis in a systems‐analytic perspective.” Water Resour. Research, 15(2), 359–370.
8.
Labadie, J. W. (1987). “Dynamic programming with the microcomputer.” Encyclopedia of Microcomputers, Marcel Dekker, Inc., New York, N.Y.
9.
Lotus Development Corp. (1986). Lotus 1‐2‐3 User's Manual, Release 2.01. Cambridge, Mass.
10.
Mays, L. W., and Wenzel, H. G. (1976). “Optimal design of multilevel branching sewer systems.” Water Resour. Research, 12(5), 913–917.
11.
Meredith, D. D. (1972). “Dynamic programming with case study on planning and design of urban water facilities.” Treatise on Urban Water Systems, Colorado State Univ., Fort Collins, Colo., 37–47.
12.
Merrit, L. B., and Bogan, R. H. (1973). “Computer‐based optimal design of sewer systems.” J. of Envir. Engrg. Div., ASCE, 99(EE1), 35–53.
13.
Miles, S. W., Potter, T. G., and Heaney, J. P. (1987). “The use of detailed cost estimation for drainage design parameter analysis on spreadsheets.” Proc. of Stormwater and Water Quality Model Users Group Meeting, Denver, Colo., EPA/600/9‐87/016, U.S. Environmental Protection Agency, Athens, Ga., 180–193.
14.
Robinson, D. K., and Labadie, J. W. (1981). “Optimal design of urban storm water drainage systems.” International Symp. on Urban Hydrology, Hydraulics, and Sediment Control, Univ. of Kentucky, Lexington, Ky., 145–156.
15.
Smith, A. A., Hinton, E., and Lewis, R. W. (1983). Civil engineering systems analysis and design. John Wiley and Sons, New York, N.Y.
16.
Tang, W. H., Mays, L. W., and Yen, B. C. (1975). “Optimal risk‐based design of storm sewer networks.” J. of the Envir. Engrg. Div., ASCE, 101(EE3), 381–397.
17.
Yen, B. C., et al. (1984). “Illinois least‐cost sewer system design model: ILSD—1&2 User's guide.” Univ. of Illinois Water Resources Center Research Report 188.
18.
Zepp, P. L., and Leary, A. (1969). “A computer program for sewer design and cost estimation.” Regional Planning Council, Baltimore, Md., PB 185 592, Clearinghouse, U.S. Dept. of Commerce, Springfield, Va.
Information & Authors
Information
Published In
Journal of Water Resources Planning and Management
Volume 114 • Issue 5 • September 1988
Pages: 477 - 499
Copyright
Copyright © 1988 ASCE.
History
Published online: Sep 1, 1988
Published in print: Sep 1988
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.