IDEAS home Printed from https://ideas.repec.org/a/spr/waterr/v28y2014i13p4551-4565.html
   My bibliography  Save this article

Sewer System Design Using Simulated Annealing in Excel

Author

Listed:
  • Omer Karovic
  • Larry Mays

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

Suggested Citation

  • Omer Karovic & Larry Mays, 2014. "Sewer System Design Using Simulated Annealing in Excel," Water Resources Management: An International Journal, Published for the European Water Resources Association (EWRA), Springer;European Water Resources Association (EWRA), vol. 28(13), pages 4551-4565, October.
    • Handle: RePEc:spr:waterr:v:28:y:2014:i:13:p:4551-4565
    DOI: 10.1007/s11269-014-0750-8
    as

    Download full text from publisher

    File URL: http://hdl.handle.net/10.1007/s11269-014-0750-8
    Download Restriction: Access to full text is restricted to subscribers.
    File URL: https://libkey.io/10.1007/s11269-014-0750-8?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Ali Haghighi & Amin Bakhshipour, 2012. "Optimization of Sewer Networks Using an Adaptive Genetic Algorithm," Water Resources Management: An International Journal, Published for the European Water Resources Association (EWRA), Springer;European Water Resources Association (EWRA), vol. 26(12), pages 3441-3456, September.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Upaka Rathnayake & Tiku Tanyimboh, 2015. "Evolutionary Multi-Objective Optimal Control of Combined Sewer Overflows," Water Resources Management: An International Journal, Published for the European Water Resources Association (EWRA), Springer;European Water Resources Association (EWRA), vol. 29(8), pages 2715-2731, June.
    2. Joshua Steele & Kurt Mahoney & Omer Karovic & Larry Mays, 2016. "Heuristic Optimization Model for the Optimal Layout and Pipe Design of Sewer Systems," Water Resources Management: An International Journal, Published for the European Water Resources Association (EWRA), Springer;European Water Resources Association (EWRA), vol. 30(5), pages 1605-1620, March.
    3. Waqed H. Hassan & Musa H. Jassem & Safaa S. Mohammed, 2018. "A GA-HP Model for the Optimal Design of Sewer Networks," Water Resources Management: An International Journal, Published for the European Water Resources Association (EWRA), Springer;European Water Resources Association (EWRA), vol. 32(3), pages 865-879, February.
    4. Joshua C. Steele & Kurt Mahoney & Omer Karovic & Larry W. Mays, 2016. "Heuristic Optimization Model for the Optimal Layout and Pipe Design of Sewer Systems," Water Resources Management: An International Journal, Published for the European Water Resources Association (EWRA), Springer;European Water Resources Association (EWRA), vol. 30(5), pages 1605-1620, March.
    5. Faisal M. Alfaisal & Larry W. Mays, 2021. "Optimization Models for Layout and Pipe Design for Storm Sewer Systems," Water Resources Management: An International Journal, Published for the European Water Resources Association (EWRA), Springer;European Water Resources Association (EWRA), vol. 35(14), pages 4841-4854, November.
    6. Praveen K. Navin & Yogesh P. Mathur, 2016. "Layout and Component Size Optimization of Sewer Network Using Spanning Tree and Modified PSO Algorithm," Water Resources Management: An International Journal, Published for the European Water Resources Association (EWRA), Springer;European Water Resources Association (EWRA), vol. 30(10), pages 3627-3643, August.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Zong Woo Geem & Jin-Hong Kim, 2016. "Sustainable Optimization for Wastewater Treatment System Using PSF-HS," Sustainability, MDPI, vol. 8(4), pages 1-13, March.
    2. Iman Ahmadianfar & Bijay Halder & Salim Heddam & Leonardo Goliatt & Mou Leong Tan & Zulfaqar Sa’adi & Zainab Al-Khafaji & Raad Z. Homod & Tarik A. Rashid & Zaher Mundher Yaseen, 2023. "An Enhanced Multioperator Runge–Kutta Algorithm for Optimizing Complex Water Engineering Problems," Sustainability, MDPI, vol. 15(3), pages 1-28, January.
    3. Praveen K. Navin & Yogesh P. Mathur, 2016. "Layout and Component Size Optimization of Sewer Network Using Spanning Tree and Modified PSO Algorithm," Water Resources Management: An International Journal, Published for the European Water Resources Association (EWRA), Springer;European Water Resources Association (EWRA), vol. 30(10), pages 3627-3643, August.
    4. Anna Petit-Boix & David Sanjuan-Delmás & Sergio Chenel & Desirée Marín & Carles Gasol & Ramon Farreny & Gara Villalba & María Suárez-Ojeda & Xavier Gabarrell & Alejandro Josa & Joan Rieradevall, 2015. "Assessing the Energetic and Environmental Impacts of the Operation and Maintenance of Spanish Sewer Networks from a Life-Cycle Perspective," Water Resources Management: An International Journal, Published for the European Water Resources Association (EWRA), Springer;European Water Resources Association (EWRA), vol. 29(8), pages 2581-2597, June.
    5. Faisal M. Alfaisal & Larry W. Mays, 2021. "Optimization Models for Layout and Pipe Design for Storm Sewer Systems," Water Resources Management: An International Journal, Published for the European Water Resources Association (EWRA), Springer;European Water Resources Association (EWRA), vol. 35(14), pages 4841-4854, November.
    6. Valentina Marchionni & Nuno Lopes & Luis Mamouros & Dídia Covas, 2014. "Modelling Sewer Systems Costs with Multiple Linear Regression," Water Resources Management: An International Journal, Published for the European Water Resources Association (EWRA), Springer;European Water Resources Association (EWRA), vol. 28(13), pages 4415-4431, October.
    7. Pantelis Broukos & Antonios Fragkogios & Nilay Shah, 2022. "A Linearized Mathematical Formulation for Combined Centralized and Distributed Waste Water Treatment Network Design," SN Operations Research Forum, Springer, vol. 3(3), pages 1-29, September.
    8. Hriday Kalita & Arup Sarma & Rajib Bhattacharjya, 2014. "Evaluation of Optimal River Training Work Using GA Based Linked Simulation-Optimization Approach," Water Resources Management: An International Journal, Published for the European Water Resources Association (EWRA), Springer;European Water Resources Association (EWRA), vol. 28(8), pages 2077-2092, June.
    9. Anna Petit-Boix & Núria Roigé & Albert de la Fuente & Pablo Pujadas & Xavier Gabarrell & Joan Rieradevall & Alejandro Josa, 2016. "Integrated Structural Analysis and Life Cycle Assessment of Equivalent Trench-Pipe Systems for Sewerage," Water Resources Management: An International Journal, Published for the European Water Resources Association (EWRA), Springer;European Water Resources Association (EWRA), vol. 30(3), pages 1117-1130, February.
    10. Gustavo Paiva Weyne Rodrigues & Luis Henrique Magalhães Costa & Guilherme Marques Farias & Marco Aurélio Holanda Castro, 2019. "A Depth-First Search Algorithm for Optimizing the Gravity Pipe Networks Layout," Water Resources Management: An International Journal, Published for the European Water Resources Association (EWRA), Springer;European Water Resources Association (EWRA), vol. 33(13), pages 4583-4598, October.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:spr:waterr:v:28:y:2014:i:13:p:4551-4565. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Sonal Shukla or Springer Nature Abstracting and Indexing (email available below). General contact details of provider: http://www.springer.com .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.