Sewer System Design Using Simulated Annealing in Excel

Omer Karovic () and Larry Mays ()

Water Resources Management: An International Journal, Published for the European Water Resources Association (EWRA), 2014, vol. 28, issue 13, 4565 pages

Abstract: An optimization procedure has been developed for branching storm and sanitary sewer systems with a pre-determined layout for determining the minimum total cost. The model was developed within Microsoft Excel using simulated annealing as the optimization procedure. The total cost of the storm sewer system that was obtained with this optimal design procedure was compared to the total cost of the system as obtained from the conventional straight slope design procedure. Applying the simulated annealing optimizer to the design of the branching storm sewer network resulted in a cost savings of over $77,100 or about 7 % (a reduction from $1,117,700 to $1,040,600). These significant savings were realized by simply going an extra step and implementing an optimization technique during the design phase. Use of Excel should enhance the availability and the usage of such an optimization model for the design of storm and sanitary sewer systems by consulting engineers and various agencies. Copyright Springer Science+Business Media Dordrecht 2014

Keywords: Storm sewer systems; Optimization; Cost minimization; Simulated annealing (search for similar items in EconPapers)
Date: 2014
References: View references in EconPapers View complete reference list from CitEc
Citations: View citations in EconPapers (6)

Downloads: (external link)
http://hdl.handle.net/10.1007/s11269-014-0750-8 (text/html)
Access to full text is restricted to subscribers.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:spr:waterr:v:28:y:2014:i:13:p:4551-4565

Ordering information: This journal article can be ordered from
http://www.springer.com/economics/journal/11269

DOI: 10.1007/s11269-014-0750-8

Access Statistics for this article

Water Resources Management: An International Journal, Published for the European Water Resources Association (EWRA) is currently edited by G. Tsakiris

More articles in Water Resources Management: An International Journal, Published for the European Water Resources Association (EWRA) from Springer, European Water Resources Association (EWRA)
Bibliographic data for series maintained by Sonal Shukla () and Springer Nature Abstracting and Indexing ().