Open Access Open Access  Restricted Access Subscription Access
Open Access Open Access Open Access  Restricted Access Restricted Access Subscription Access

An Excel/VBA Teaching-Learning Solution of Velocity Triangle Analysis of Hydraulic Turbines


Affiliations
1 Department of Mechanical Engineering, School of Advanced Engineering, UPES Dehradun, Uttarakhand, India
     

   Subscribe/Renew Journal


This study reports an investigation into the use of computational techniques applied to selected Turbo machinery problems. Students in their third year of a B.S./ B.Tech in Mechanical Engineering program often focus on this topic. As a result of being exposed to an overwhelming quantity of hypothetical ideas, loads of recipes, and references from information handbooks, students sometimes become overwhelmed during lessons on Turbomachinery. An intuitive learning scenario, such as a computerized setting, can be useful in some circumstances. Thus, computer-based exercises are essential to improve dynamic learning. This study will present an alternate technique of demonstrating the turbo machinery analysis using Excel/VBA. The classroom isn't the only setting where a powerful computer application can alter the way subjects are learned and homework is completed. Both students and teachers can benefit from the introduction of this technology. Students will benefit from having this tool available because it will eliminate the need for lengthy calculations and allow them to easily observe the effects of changing values on various variables, thereby improving their understanding of the subject matter and increasing their interest in and enthusiasm for studying it. Further, it will aid educators in conveying a variety of turbomachinery ideas to their students. In addition, students can use these resources in the project's design phase. This program can do more than just solve the equations; it can also tell you how the various parameters influence the forces. This means that students can complete as many calculations as they need with the touch of a button, without the risk of making a mistake or growing bored with the process.

Keywords

Computational tool; engineering tool; Excel/VBA; innovative pedagogy; turbomachinery tool.
Subscription Login to verify subscription
User
Notifications
Font Size


  • Agarwal, R., Dwivedi, P., Mahawar, R., & Karn, A. (2022). Design and Analysis of Longitudinal Butt Joints Using an Excel/VBA Computational Tool BT - Recent Advances in Mechanical Engineering (S. Narendranth, P. G. Mukunda, & U. K. Saha (eds.); pp. 119–130). Springer Nature Singapore.
  • Cheetancheri, K., & Cheng, H. (2009). Spreadsheet-based interactive design and analysis of mechanisms using Excel and Ch. Advances in Engineering Software Elsevier, 274-280.
  • Dick, E. (2015). Fundamentals of turbomachines (Vol. 109). Dordrecht, The Netherlands: Springer.
  • Dixon, S. (1998). Fluid Mechanics and Thermodynamics of biomachinery. Butterworth-Heinemann.
  • Dwivedi, A., Sawant, G., & Karn, A. (2022b). Computational Solvers for Iterative Hydraulic loss Calculations in Pipe Systems. Journal of Engineering Education Transformations 35(4).
  • Dwivedi, A., Sawant, G., Vyas, A., & Karn, A. (2022a). Effective Computational Tools for Teaching and Learning of Heat Transfer Through Extended Surfaces BT - Recent Advances in Mechanical Engineering (S. Narendranth, P. G. Mukunda, & U. K. Saha (eds.); pp. 131–140). Springer Nature Singapore.
  • Karn, A., Vyas, A., Upadhyaya, A. & Dwivedi, A. (2023). Elegant Computational Frameworks for the analysis of cantilevers and beams. Journal of Engineering Education Transformations.
  • Kumashiro, T., Alimirzazadeh, S., Maertens, A., Jahanbakhsh, E., Leguizamón, S., Avellan, F., et al. (2019). Numerical investigation of the jet velocity profile and its influence on the Pelton turbine performance. 29th IAHR Symposium on Hydraulic Machinery and Systems (pp. 1-10). IOP Conference Series: Earth and Environmental Science.
  • Moukalled, F., & Honein, A. (1995). computeraided analysis of the Pelton wheel. International Journal of Mechanical Engineering Education, 1- 18.
  • Oo, T., Nyi, N., & Khaing, C. C. (2019). Design Calculation of Pelton Turbine for 220 kW. International Journal of Scientific and Research Publications, 1-7.
  • Pujol, T., Montoro, L., Pelegri, M., & Gonzalez, J. (2010, November 1). Learning Hydraulic Turbomachinery With Computational Fluid Dynamics (CFD) Codes. 2010 Wiley Periodicals, pp. 1-7. [12] Sanchis, E., Alcaraz, J., Borrell, J., & Vañó, J. (2011). An Application of an Optimization Tool to Solve Problems of Mechanics of Materials. Spreadsheets in Education (eJSiE), 1-12.
  • Tay, K. G., Kek, S. L., & Kahar, R. A. (2012). A Spreadsheet Solution of a System of Ordinary Differential Equations Using the Fourth-Order Runge-Kutta Method. Spreadsheets in Education (eJSiE), 1-12.
  • Turner, M., Merchant, A., & Bruna, D. (2011). A Turbomachinery Design Tool for Teaching De si gn Conc ep ts for Axi al -Flow Fans, Compressors, and Turbines . Journal o f Turbomachinery, 1-12.

Abstract Views: 140

PDF Views: 1




  • An Excel/VBA Teaching-Learning Solution of Velocity Triangle Analysis of Hydraulic Turbines

Abstract Views: 140  |  PDF Views: 1

Authors

Ashish Karn
Department of Mechanical Engineering, School of Advanced Engineering, UPES Dehradun, Uttarakhand, India
Rohit Mahawar
Department of Mechanical Engineering, School of Advanced Engineering, UPES Dehradun, Uttarakhand, India
Priyanshu Dwivedi
Department of Mechanical Engineering, School of Advanced Engineering, UPES Dehradun, Uttarakhand, India
Raghav Agarwal
Department of Mechanical Engineering, School of Advanced Engineering, UPES Dehradun, Uttarakhand, India

Abstract


This study reports an investigation into the use of computational techniques applied to selected Turbo machinery problems. Students in their third year of a B.S./ B.Tech in Mechanical Engineering program often focus on this topic. As a result of being exposed to an overwhelming quantity of hypothetical ideas, loads of recipes, and references from information handbooks, students sometimes become overwhelmed during lessons on Turbomachinery. An intuitive learning scenario, such as a computerized setting, can be useful in some circumstances. Thus, computer-based exercises are essential to improve dynamic learning. This study will present an alternate technique of demonstrating the turbo machinery analysis using Excel/VBA. The classroom isn't the only setting where a powerful computer application can alter the way subjects are learned and homework is completed. Both students and teachers can benefit from the introduction of this technology. Students will benefit from having this tool available because it will eliminate the need for lengthy calculations and allow them to easily observe the effects of changing values on various variables, thereby improving their understanding of the subject matter and increasing their interest in and enthusiasm for studying it. Further, it will aid educators in conveying a variety of turbomachinery ideas to their students. In addition, students can use these resources in the project's design phase. This program can do more than just solve the equations; it can also tell you how the various parameters influence the forces. This means that students can complete as many calculations as they need with the touch of a button, without the risk of making a mistake or growing bored with the process.

Keywords


Computational tool; engineering tool; Excel/VBA; innovative pedagogy; turbomachinery tool.

References