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

被引：14

作者：

Demir, Selami ^{[1
]}

Duman, Selin ^{[1
]}

Demir, Neslihan Manav ^{[1
]}

Karadeniz, Aykut ^{[1
]}

Lubura, Edin ^{[1
]}

机构：

[1] Yildiz Tech Univ, Dept Environm Engn, Davutpasa Campus, TR-34220 Istanbul, Turkey

来源：

COMPUTER APPLICATIONS IN ENGINEERING EDUCATION | 2018年 / 26卷 / 03期

关键词：

engineering education; environmental hydraulics; MS excel; pipe flow; visual basic for applications; FRICTION FACTOR; SPREADSHEETS; IMPLEMENTATION; OPTIMIZATION;

D O I：

10.1002/cae.21898

中图分类号：

TP39 [计算机的应用];

学科分类号：

081203 ; 0835 ;

摘要：

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.

引用

页码：449 / 459

页数：11

共 32 条

[11]

Ghanbari A., 2011, Journal of Chemical Engineering and Materials Science, V2, P83

[12] Numerical modeling of Darcy-Weisbach friction factor and branching pipes problem [J].

Haktanir, T ;

Ardiçlioglu, M .

ADVANCES IN ENGINEERING SOFTWARE, 2004, 35 (12) :773-779

[13] Application of Spreadsheets in Developing Flexible-Multiple-Reach and Multiple-Branch Methods of Muskingum Flood Routing [J].

Hosseini, S. M. .

COMPUTER APPLICATIONS IN ENGINEERING EDUCATION, 2009, 17 (04) :448-454

[14]

Iglesias OA, 1999, COMPUT APPL ENG EDUC, V7, P227, DOI 10.1002/(SICI)1099-0542(1999)7:4<227::AID-CAE4>3.0.CO

[15]

2-W

[16]

KahnJetter ZL, 1997, COMPUT APPL ENG EDUC, V5, P199, DOI 10.1002/(SICI)1099-0542(1997)5:3<199::AID-CAE7>3.0.CO

[17]

2-8

[18] Using Computer Software Packages to Enhance the Teaching in Engineering Management Science-Part 2: Programming Techniques [J].

Ku, H. ;

Fulcher, R. .

COMPUTER APPLICATIONS IN ENGINEERING EDUCATION, 2012, 20 (01) :114-123

[19] Implementation of the Hardy-Cross method for the solution of piping networks [J].

Lopes, AMG .

COMPUTER APPLICATIONS IN ENGINEERING EDUCATION, 2004, 12 (02) :117-125

[20] Analysis of Water Distribution Networks Using MATLAB and Excel Spreadsheet: h-Based Methods [J].

Niazkar, Majid ;

Afzali, Seied Hosein .

COMPUTER APPLICATIONS IN ENGINEERING EDUCATION, 2017, 25 (01) :129-141

← 1 2 3 4 →