Sewer System Design Using Simulated Annealing in Excel

Omer Karovic, Larry Mays

Research output: Contribution to journalArticle

26 Citations (Scopus)

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.

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

Fingerprint

Storm sewers
simulated annealing
Sewers
Simulated annealing
Systems analysis
Sanitary sewers
Costs
cost
savings
sewer network
Availability
Engineers

Keywords

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

ASJC Scopus subject areas

  • Water Science and Technology
  • Civil and Structural Engineering

Cite this

Sewer System Design Using Simulated Annealing in Excel. / Karovic, Omer; Mays, Larry.

In: Water Resources Management, Vol. 28, No. 13, 2014, p. 4551-4565.

Research output: Contribution to journalArticle

Karovic, Omer ; Mays, Larry. / Sewer System Design Using Simulated Annealing in Excel. In: Water Resources Management. 2014 ; Vol. 28, No. 13. pp. 4551-4565.
@article{9af4d3d90fb840a594f31270940e0f80,
title = "Sewer System Design Using Simulated Annealing in Excel",
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.",
keywords = "Cost minimization, Optimization, Simulated annealing, Storm sewer systems",
author = "Omer Karovic and Larry Mays",
year = "2014",
doi = "10.1007/s11269-014-0750-8",
language = "English (US)",
volume = "28",
pages = "4551--4565",
journal = "Water Resources Management",
issn = "0920-4741",
publisher = "Springer Netherlands",
number = "13",

}

TY - JOUR

T1 - Sewer System Design Using Simulated Annealing in Excel

AU - Karovic, Omer

AU - Mays, Larry

PY - 2014

Y1 - 2014

N2 - 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.

AB - 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.

KW - Cost minimization

KW - Optimization

KW - Simulated annealing

KW - Storm sewer systems

UR - http://www.scopus.com/inward/record.url?scp=84920708342&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84920708342&partnerID=8YFLogxK

U2 - 10.1007/s11269-014-0750-8

DO - 10.1007/s11269-014-0750-8

M3 - Article

AN - SCOPUS:84920708342

VL - 28

SP - 4551

EP - 4565

JO - Water Resources Management

JF - Water Resources Management

SN - 0920-4741

IS - 13

ER -