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

Demi̇r, Selami; Duman, Selin; Demır, Neslihan Manav; Karadeniz, Aykut; Lubura, Edin

doi:10.1002/cae.21898

Cited by 11 publications

(6 citation statements)

References 28 publications

(38 reference statements)

Supporting

Mentioning

Contrasting

Order By: Relevance

“…As the Excel spreadsheet and its built‐in environment for coding (VBA) have been successfully utilized for implementing many engineering problems [1,4‐7,11,13,14,17,21,22,28,30,31], they may be considered a useful tool for comprehensive application to predict resistance grain and form roughness coefficients. In this regard, the spreadsheet developed in this study, which may be found at https://www.dropbox.com/s/0fvl1pdtl6n64ni/estimation.rar?dl=0, has four worksheets, which arev as follows. The notation worksheet: In the first worksheet, all BRPs and the corresponding input and output parameters are introduced, as shown in Figure 2.…”

Section: Methodsmentioning

confidence: 99%

An Excel VBA‐based educational module for bed roughness predictors

Niazkar

2020

Comp Applic In Engineering

View full text Add to dashboard Cite

Estimation of flow resistance coefficients plays an inevitable role in open‐channel flows in hydraulic modeling and water resources engineering. Despite many equations and methods recommended for estimating roughness coefficients, only two standard resistance equations (original Manning's and Keulegan's equations) have been widely taught and utilized in practice. There can be various reasons for not using new bed roughness predictors (BRPs), one of which is the absence of teaching BRPs. A rigorous analysis of available BRPs for estimating grain and form roughness coefficients delineates that most of them are comprised of a scheme rather than a single equation. Also, each BRP is tailored to solve a distinct type of problem; however, a proper definition of a problem statement helps shedding light on this application. This study presents an Excel VBA‐based educational estimator to address the gap. For this purpose, the problem statement is first revisited to accomplish a better understanding in light of proper problem classification. On the basis of different groups of input and output data, each BRP is implemented into an Excel spreadsheet and VBA codes are presented for BRPs incorporating both grain and form roughness. This computer application can help students in open‐channel engineering courses not only to become familiar with modified BRPs but also to acknowledge the merit of the Excel spreadsheet for estimating flow resistance coefficients. Finally, as the VBA codes are presented in detail, they can be modified by users in accordance with their priorities for both educational and practical purposes.

show abstract

Section: Methodsmentioning

confidence: 99%

An Excel VBA‐based educational module for bed roughness predictors

Niazkar

2020

Comp Applic In Engineering

View full text Add to dashboard Cite

show abstract

“…Under turbulent conditions, i.e. Re ≥ 4000, explicit Swamee-Jain formula (Eqn 2b) was employed [21].…”

Section: Hydraulicsmentioning

confidence: 99%

“…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]. The motivation for this study comes from the need of easily teaching the mathematical background of WDN design problems.…”

Section: Introductionmentioning

confidence: 99%

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

“…In view of this, many scholars have studied the characteristics of ows which come from the intersection of ssure-ssure or ssure-conduit. When groundwater ows in the conduit with ssures, in addition to the local head loss at the intersecting point, the existence of ssure will also a ect the ow of the stream in the conduit, resulting in a head loss along the conduit itself [6][7][8]. It is necessary to take the above-given two factors into account when calculating the converted permeability coe cient of the karst conduit, especially when there are many ssures intersecting along the conduit [9,10].…”

Section: Introductionmentioning

confidence: 99%

Study on the Equivalent Permeability Coefficient of Karst Conduit with Single Conduit and Multigroup Fissures

Fan

Yang

et al. 2022

Mathematical Problems in Engineering

View full text Add to dashboard Cite

In order to improve the calculation method of the conversion coefficient of karst conduit under the condition of multiple fissures and conduit intersecting, the indoor test model of karst groundwater seepage with a single conduit and multiple groups of fissures is established. Under the condition of fixed upstream and downstream water heads, the changes of karst conduit water head under different fissures width, fissures combination, and different flow velocity were observed. The test found that the karst conduit water level gradually decreased with the increase of distance, showing an obvious linear relationship. Based on the above-observed water head law, the conversion coefficient of fissures influence is introduced into the Darcy–Weisbach formula, and the regression analysis of test data are used to obtain the calculation formula of the equivalent permeability coefficient of conduit intersecting multiple fissures and karst conduit. The formula is applicable to the case that the fissures are equidistant and the conduit is vertical and does not change dramatically along the conduit.

show abstract

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

Cited by 11 publications

References 28 publications

An Excel VBA‐based educational module for bed roughness predictors

An Excel VBA‐based educational module for bed roughness predictors

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̇

Study on the Equivalent Permeability Coefficient of Karst Conduit with Single Conduit and Multigroup Fissures

Contact Info

Product

Resources

About