An easy MS Excel software to use for water distribution system design: A real case distribution network design solution

References

• Brkic D. 2017. Solution of the implicit Colebrook equation for flow friction using Excel. Spreadsheets Educ. 10(2):2.
   Web of Science ®Google Scholar
• Brusco M. 2019. An Excel spreadsheet and VBA macro for model selection and predictor importance using all-possible subsets regression. Spreadsheets Educ. 12(1):1.
   Google Scholar
• Christie DS. 2018. Build your own Monte Carlo spreadsheet. Spreadsheets Educ. 11(1):1.
   Web of Science ®Google Scholar
• Demir S. 2018. Evaluation of the suitability of global gradient algorithm and inverse matrix method for steady-state analysis of water distribution networks in engineering education. Ömer Halisdemir Univ J Eng Sci. 7(1):23–33.
   Google Scholar
• Demir S, Duman S, Manav Demir N, Karadeniz A, Lubura E. 2018b. An MS Excel add-in for teaching hydraulics of pipe flow. Comput Appl Eng Educ. 26(3):449–459. doi: 10.1002/cae.21898
   Web of Science ®Google Scholar
• Demir S, Duman S, Manav Demir N, Karadeniz A. 2018d. An MS Excel add-in for calculating Darcy friction factor. Spreadsheets Educ. 10(3):2.
   Web of Science ®Google Scholar
• Demir S, Karadeniz A, Civelek Yoruklu H, Manav Demir N. 2017. An MS Excel tool for parameter estimation by multivariate nonlinear regression in environmental engineering education. Sigma J Eng. Nat Sci. 35:265–273.
   Google Scholar
• Demir S, Karadeniz A, Manav Demir N, Duman S. 2018c. Excel VBA-based solution to pipe flow measurement problem. Spreadsheets Educ. 10(3):1.
   Web of Science ®Google Scholar
• Demir S, Karadeniz A, Manav Demir N. 2016. Using steepness coefficient to improve artificial neural network performance for environmental modeling. Pol J Environ Stud. 25(4):1467–1477. doi: 10.15244/pjoes/61958
   Web of Science ®Google Scholar
• Demir S, Manav Demir N, Karadeniz A, Civelek Yoruklu H. 2018e. Implementation of an MS Excel tool for backpropagation neural network algorithm in environmental engineering education. Sigma J Eng Nat Sci. 36:251–260.
   Google Scholar
• Demir S, Manav Demir N, Karadeniz A. 2018a. An MS Excel tool for water distribution network design in environmental engineering. Comput Appl Eng Educ. 26(2):203–214. doi: 10.1002/cae.21870
   Web of Science ®Google Scholar
• Demir S, Yetilmezsoy K, Manav Demir N. 2008. Development of a modified Hardy-Cross algorithm for time-dependent simulations of water distribution networks. Fresen Environ Bull. 17(8a):1045–1053.
   Web of Science ®Google Scholar
• El-Awad MM. 2019. An Excel add-in for refrigerants properties and its use for optimizing multi-stage compression refrigeration cycles. Spreadsheets Educ. 12(1):3.
   Google Scholar
• Elhay S, Angus R, Deurlein J, Alexander B, Schilders WHA. 2014. Reformulated co-tree flows method competitive with the global gradient algorithm for solving water distribution system equations. J Water Res Plan Man. 140(12):04014040-1/10.
   Web of Science ®Google Scholar
• Fellah G. 2019. Excel spreadsheet as a tool for simulating the performance of steam power plants. Spreadsheets Educ. 12(1):2.
   Web of Science ®Google Scholar
• Geyer FH. 2017. A spreadsheet implementation of the Hodgkin-Huxley model for action potentials in neurons. Spreadsheets Educ. 10(1):1.
   Web of Science ®Google Scholar
• Hwang NHC, Houghtalen RJ. 1996. Fundamentals of Hydraulic engineering systems, 3th ed. London (UK): Prentice-Hall International.
   Google Scholar
• Hydraulic Institute. 1990. Engineering Data Book, 2nd ed. Cleveland (OH): Hydraulic Institute.
   Google Scholar
• Lewis J. 2018. Learning spreadsheet tools: the case of temperature dependent molar heat capacity and change in molar enthalpy. Spreadsheets Educ. 10(3):6.
   Web of Science ®Google Scholar
• Lopes AMG. 2004. Implementation of the Hardy-Cross method for the solution of piping networks. Comput Appl Eng Educ. 12(2):117–125. doi: 10.1002/cae.20006
   Web of Science ®Google Scholar
• Manav Demir N, Demir S. 2017. An MS Excel tool for wastewater treatment modeling in undergraduate education: activated Sludge Model No.1. Fresen Environ Bull. 26(12):7008–7017.
   Web of Science ®Google Scholar
• Moosavian M, Jaefarzadeh MR. 2014. Hydraulic analysis of water supply networks using a modified hardy cross method. International Journal of Engineering. 27(9):1331–1338.
   Google Scholar
• Niazkar M, Afzali SH. 2017a. Analysis of water distribution networks using MATLAB and Excel spreadsheet: H-based methods. Comput Appl Eng Educ. 25(1):129–141. doi: 10.1002/cae.21786
   Web of Science ®Google Scholar
• Niazkar M, Afzali SH. 2017b. Analysis of water distribution networks using MATLAB and Excel spreadsheet: Q-based methods. Comput Appl Eng Educ. 25(2):277–289. doi: 10.1002/cae.21796
   Web of Science ®Google Scholar
• Todini E, Pilati S. 1988. A Gradient Algorithm for the Analysis of Pipe Networks, computer applications in water supply, vol. 1. Taunton (UK): Research Studies Press; p. 1–20.
   Google Scholar
• Wahba EM. 2015. An improved computational algorithm for teaching hydraulics of branching pipes in engineering curricula. Comput Appl Eng Educ. 23(3):537–541. doi: 10.1002/cae.21624
   Google Scholar
• Zhang H, Xu JL, Cheng X. 2016. Interactive educational software for teaching water distribution network design. Comput Appl Eng Educ. 24(4):615–628. doi: 10.1002/cae.21736
   Web of Science ®Google Scholar