An MS Excel tool for water distribution network design in environmental engineering education

Demi̇r, Selami; Demır, Neslihan Manav; Karadeniz, Aykut

doi:10.1002/cae.21870

Cited by 18 publications

(20 citation statements)

References 17 publications

(27 reference statements)

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Further, students can use Excel for more capable task such as calculation of water distribution networks (both tree-and loop-like) where multiple simultaneous calculation of friction factor is needed [58][59][60][61][62][63][64][65][66][67][68][69][70].…”

Section: Additional Tasksmentioning

confidence: 99%

Solution of the Implicit Colebrook Equation for Flow Friction Using Excel

Brkić

2017

Preprint

View full text Add to dashboard Cite

Empirical Colebrook equation implicit in unknown flow friction factor (λ) is an accepted standard for calculation of hydraulic resistance in hydraulically smooth and rough pipes. The Colebrook equation gives friction factor (λ) implicitly as a function of the Reynolds number (Re) and relative roughness (ε/D) of inner pipe surface; i.e. λ 0 =f(λ 0 , Re, ε/D). The paper presents a problem that requires iterative methods for the solution. In particular, the implicit method used for calculating the friction factor λ 0 is an application of fixedpoint iterations. The type of problem discussed in this "in the classroom paper" is commonly encountered in fluid dynamics, and this paper provides readers with the tools necessary to solve similar problems. Students' task is to solve the equation using Excel where the procedure for that is explained in this "in the classroom" paper. Also, up to date numerous explicit approximations of the Colebrook equation are available where as an additional task for students can be evaluation of the error introduced by these explicit approximations λ≈f(Re, ε/D) compared with the iterative solution of implicit equation which can be treated as accurate.

show abstract

Section: Additional Tasksmentioning

confidence: 99%

Solution of the Implicit Colebrook Equation for Flow Friction Using Excel

Brkić

2017

Preprint

View full text Add to dashboard Cite

show abstract

“…Over the years, a number of algorithms for steady-state hydraulic analysis of WDNs have been proposed and successfully applied including Hardy-Cross method [2], linear theory method [3,4], Newton-Raphson method [5], global gradient algorithm [6], and co-tree flows method [7]. In Turkey, on the other hand, most of design engineers employ dead-end approach or Hardy-Cross method.…”

Section: Introductionmentioning

confidence: 99%

“…GGA is able to handle pipe flow direction without user interference during the analysis, is capable of handling looped-and branched pipe networks, and most importantly initial estimations of pipe flows do not necessarily need to satisfy mass balance. For its overwhelming features over several methods, GGA is preferred in most of today's software packages like EPANET2 and WaterGEMs [6,17]. In view of engineering education, usually Hardy-Cross method is employed in undergraduate projects [2,18].…”

Section: Introductionmentioning

confidence: 99%

“…some instructors teach the computational algorithms using a commercial or open-source software. However, using software packages for this purpose requires licensing of commercial software packages (usually students need to buy a licensed copy of the software) or teaching a scripting language in case of an open-source software is used [6]. In any case, learning the operating aspects of WDNs could be possible while mathematical background of WDN design problems is overlooked [6].…”

Section: Introductionmentioning

confidence: 99%

“…However, using software packages for this purpose requires licensing of commercial software packages (usually students need to buy a licensed copy of the software) or teaching a scripting language in case of an open-source software is used [6]. In any case, learning the operating aspects of WDNs could be possible while mathematical background of WDN design problems is overlooked [6]. In the last few years, the instructors realized the importance of mathematical aspects of the design problem and started to develop their own methods of teaching the mathematical background of WDN design [19][20][21].…”

Section: Introductionmentioning

confidence: 99%

See 2 more Smart Citations

İçme Suyu Şebekeleri̇ni̇n Kararli Durum Anali̇zi̇ İçi̇n Küresel Gradyen Algori̇tmasi Ve Ters Matri̇s Yöntemi̇ni̇n Uygunluğunun Değerlendi̇ri̇lmesi̇

Demi̇r

2018

Ömer Halisdemir Üniversitesi Mühendislik Bilimleri Dergisi

View full text Add to dashboard Cite

Two methods for steady-state analysis of water distribution networks (WDNs) were evaluated in this paper: Global Gradient Algorithm (GGA) and inverse matrix method (IMM). Both methodologies are based on the solution of nonlinear system of equations formed by mass and energy balances within a WDN. A number of WDNs were solved using both methods. Results showed that GGA solves the WDNs in around 70 to 75% less number of iterations than IMM. Besides, single GGA solution of a WDN takes less time compared to IMM solution (about 57% faster for a network of 31 elements). In contrast, single iteration takes 127 to 552 μs with IMM while it takes 235 to 773 μs with GGA depending on the number of network elements. Evaluations are based on the speed, the accuracy, and ease of handling the iteration procedures and it was concluded that, although GGA provides faster solutions, both methods are fast enough and IMM, with its simpler iteration procedure, could be beneficial if employed for teaching WDNs in engineering education. Keywords:Water distribution networks, systems of nonlinear equations, global gradient algorithm, inverse matrix method İÇME SUYU ŞEBEKELERİNİN KARARLI DURUM ANALİZİ İÇİN KÜRESEL GRADYEN ALGORİTMASI VE TERS MATRİS YÖNTEMİNİN UYGUNLUĞUNUN DEĞERLENDİRİLMESİ ÖZBu çalışmada içme suyu şebekelerinin kararlı akım analizi için kullanılabilen iki yöntem değerlendirilmiştir: Küresel Gradyen Algoritması (KGA) ve ters matris yöntemi (TMY). Her iki yöntem de şebeke için yazılan kütle ve enerji korunum denklemlerinden oluşan, doğrusal olmayan denklem sisteminin çözümüne dayanmaktadır. Bu çalışmada her iki yöntem de kullanılarak bir dizi şebeke çözümü yapılmıştır. Sonuçlar, KGA'nın TMY'ye göre yaklaşık %70 ile %75 oranında daha az iterasyonla sonuca ulaştığını göstermiştir. Ayrıca, KGA ile tek şebeke çözümü, TMY'ye göre daha az zaman almaktadır (31 elemanlı bir şebeke için yaklaşık %57 oranında daha hızlı). Buna karşın, şebekedeki eleman sayısına bağlı olmak üzere TMY'de tek iterasyon 127 ile 552 µs'de tamamlanırken KGA'da 235 ile 773 µs sürmektedir. Değerlendirmeler metotların hızı, doğruluğu ve iterasyon prosedürlerinin kolaylığına göre yapılmış olup, KGA daha hızlı çözümler üretmesine karşın her iki yöntemin de yeteri kadar hızlı olduğunu söylemek mümkündür ve iterasyon prosedürleri çok daha kolay olduğu için TMY'nin mühendislik eğitiminde içme suyu şebekelerini öğretmek için kullanılması KGA'ya göre daha avantajlı olabilir.Anahtar Kelimeler: İçme suyu şebekeleri, doğrusal olmayan denklem sistemleri, küresel gradyen algoritması, ters matris yöntemi

show abstract

An MS excel add‐in for teaching hydraulics of pipe flow in engineering curricula

Demi̇r

Duman

Demır

et al. 2018

Comp Applic In Engineering

Self Cite

View full text Add to dashboard Cite

This paper presents implementation of an MS Excel add‐in incorporating Visual Basic for Applications for teaching pipe flow calculations in undergraduate and graduate level. The add‐in contains a total of 108 functions for several purposes ranging from continuity equation to branching pipes and pipe network problems. Tip texts and a number of userforms were developed for easy use of the tool. A user's guide was also prepared that includes the theory of hydraulic calculations and numerical methods involved. Being an add‐in for MS Excel, the tool is a perfect candidate for implementing as an educational tool in undergraduate and graduate level education.

show abstract

An MS Excel tool for water distribution network design in environmental engineering education

Cited by 18 publications

References 17 publications

Solution of the Implicit Colebrook Equation for Flow Friction Using Excel

Solution of the Implicit Colebrook Equation for Flow Friction Using Excel

İçme Suyu Şebekeleri̇ni̇n Kararli Durum Anali̇zi̇ İçi̇n Küresel Gradyen Algori̇tmasi Ve Ters Matri̇s Yöntemi̇ni̇n Uygunluğunun Değerlendi̇ri̇lmesi̇

An MS excel add‐in for teaching hydraulics of pipe flow in engineering curricula

Contact Info

Product

Resources

About