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 条

[1]

Avc A., 2009, J FLUID ENG, V131

[2] An Explicit Approximation of Colebrook's Equation for Fluid Flow Friction Factor [J].

Brkic, D. .

PETROLEUM SCIENCE AND TECHNOLOGY, 2011, 29 (15) :1596-1602

[3]

BUZZELLI D., 2008, Machine Design, v, V80, n, P54

[4] Experiments with fluid friction in roughened pipes [J].

Colebrook, CF ;

White, CM .

PROCEEDINGS OF THE ROYAL SOCIETY OF LONDON SERIES A-MATHEMATICAL AND PHYSICAL SCIENCES, 1937, 161 (A906) :367-381

[5]

Demir S, 2008, FRESEN ENVIRON BULL, V17, P1045

[6] An MS Excel tool for water distribution network design in environmental engineering education [J].

Demir, Selami ;

Demir, Neslihan Manav ;

Karadeniz, Aykut .

COMPUTER APPLICATIONS IN ENGINEERING EDUCATION, 2018, 26 (02) :203-214

[7] Artificial Neural Network Simulation of Cyclone Pressure Drop: Selection of the Best Activation Function in Iraq [J].

Demir, Selami ;

Karadeniz, Aykut ;

Demir, Neslihan Manav .

POLISH JOURNAL OF ENVIRONMENTAL STUDIES, 2016, 25 (05) :1891-1899

[8] Using Steepness Coefficient to Improve Artificial Neural Network Performance for Environmental Modeling [J].

Demir, Selami ;

Karadeniz, Aykut ;

Demir, Neslihan Manav .

POLISH JOURNAL OF ENVIRONMENTAL STUDIES, 2016, 25 (04) :1467-1477

[9] Reformulated Co-Tree Flows Method Competitive with the Global Gradient Algorithm for Solving Water Distribution System Equations [J].

Elhay, Sylvan ;

Simpson, Angus R. ;

Deuerlein, Jochen ;

Alexander, Bradley ;

Schilders, Wil H. A. .

JOURNAL OF WATER RESOURCES PLANNING AND MANAGEMENT, 2014, 140 (12)

[10] New correlations of single-phase friction factor for turbulent pipe flow and evaluation of existing single-phase friction factor correlations [J].

Fang, Xiande ;

Xu, Yu ;

Zhou, Zhanru .

NUCLEAR ENGINEERING AND DESIGN, 2011, 241 (03) :897-902

← 1 2 3 4 →