Sewer System Design Using Simulated Annealing in Excel

Omer Karovic, Larry Mays

Research output: Contribution to journalArticlepeer-review

37 Scopus citations


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.

Original languageEnglish (US)
Pages (from-to)4551-4565
Number of pages15
JournalWater Resources Management
Issue number13
StatePublished - Oct 2014


  • Cost minimization
  • Optimization
  • Simulated annealing
  • Storm sewer systems

ASJC Scopus subject areas

  • Civil and Structural Engineering
  • Water Science and Technology


Dive into the research topics of 'Sewer System Design Using Simulated Annealing in Excel'. Together they form a unique fingerprint.

Cite this