SavedAdd your journal

Journals / Fundamental Journal of Mathematics and Applications / 2018 / Cilt: 1 - Sayı: 1

Initial value problems spreadsheet solver using VBA for engineering education

Çiğdem DİNÇKAL
Pages
88–101
Publication Date
2018-06-30
DOI
—
🏛️Bibliographic metadata and full text access for this article are provided via DergiPark.
DergiPark Record ↗
✨

AI Summary & Key Takeaways

AI Insight
⚡ TL;DR(Too Long; Didn't Read)

This solver is user-friendly especially for beginner users of Excel and VBA.

📌 3 Key Takeaways

🎯
Objective & Hypothesis:Spreadsheet solver using VBA programming has been designed for solving initial value problems (IVPs), analytically and numerically by all Runge-Kutta (RK) methods including also fifth order with calculation of true percent relative error for corresponding RK method.
📊
Key Findings & Data:Spreadsheet solver using VBA programming has been designed for solving initial value problems (IVPs), analytically and numerically by all Runge-Kutta (RK) methods including also fifth order with calculation of true percent relative error for corresponding RK method.
💡
Conclusion & Impact:This solver is user-friendly especially for beginner users of Excel and VBA.
🔬Design:Research Article
📍Scope:Comprehensive Sample
⚙️Variables:Excel spreadsheet · VBA programming · Initial Value Problems (IVPs) spreadsheet solver

Abstract

Spreadsheet solver using VBA programming has been designed for solving initial value problems (IVPs), analytically and numerically by all Runge-Kutta (RK) methods including also fifth order with calculation of true percent relative error for corresponding RK method. This solver is user-friendly especially for beginner users of Excel and VBA.

🔖

Cite This Article

DİNÇKAL, Ç. (2018). Initial value problems spreadsheet solver using VBA for engineering education. Fundamental Journal of Mathematics and Applications, Cilt: 1 - Sayı: 1, 88–101. https://ajindex.com/articles/759344

📄 Full Text PDF Viewer

📄

PDF görüntüleyici hazırlanıyor...

References (18)

  1. S.C. Chapra, R.P. Canale, Numerical Methods for Engineers, McGraw Hill, 2006
  2. D.G. Lilley, Numerical Methods Using Excel/VBA for Engineers, Cambridge University Press, 2010
  3. E.D. Laughbaum, K. Seidel, Business Math Excel Applications, Prentice Hall, 2008
  4. R.W. Larsen, Engineering with Excel, Pearson Prentice Hall, 2009
  5. D.M. Bourq, Excel Scientific and Engineering, Cookbook. O’Reilly, 2006
  6. E. J. Billo, Excel for Scientists and Engineers, Wiley –Interscience, 2007
  7. S.C. Chapra, Power Programming with VBA/Excel, Prentice Hall, Upper Saddle River, 2003
  8. S.L. Kek, K.G. Tay, Design of spreadsheet solver for polynomial interpolation, National Seminar on Science and Technology (PKPST 2009), 69-73 (2009)
  9. K.G. Tay, S.L. Kek, R. Abdul-Kahar, A bivariate approximation spreadsheet calculator by Lagrange interpolation, Spreadsheets in Education (eJSiE), 7, 1-8 (2014)
  10. S.L. Kek, K.G. Tay, Solver for system of linear equations, Proceeding of the National Symposium on Application of Science Mathematics 2008 (SKASM 2008), 605-615 (2008)
  11. K.G. Tay, S.L. Kek, R. Abdul-Kahar, Solving non-linear systems by Newton’s method using spreadsheet Excel, Proceeding of the 3rd International Conference on Science and Mathematics Education (CoSMED 2009), 452-456 (2009)
  12. K.G. Tay, S.L. Kek, Approximating the dominant eigenvalue using Power method through spreedsheet Excel, Proceeding of the National Symposium on Application of Science Mathematics 2008 (SKASM 2008), 599-604 (2008)
  13. K.G. Tay, S.L. Kek, Approximating the Smallest Eigenvalue Using Inverse Method Through Spreadsheet Excel, Proceeding of the 17th National Symposium on Mathematical Science (SKSM 2009), 653-658 (2009)
  14. K.G. Tay, S.L. Kek, R. Abdul-Kahar, Improved Richardson’s Eextrapolation spreadsheet calculator for numerical differentiation, AIP Conference Proceedings, 1605, 740-743 (2014)
  15. K.G. Tay, S.L. Kek, R. Abdul-Kahar, M.A. Azlan, M.F. Lee, A Richardson’s extrapolation spreadsheet calculator for numerical differentiation, Spreadsheets in Education (eJSiE), 6, 1-5 (2013)
  16. K.G. Tay, S.L. Kek, R. Abdul-Kahar, Numerical differentiation spreadsheet calculator, Proceedings of the National Symposium on Application of Science Mathematics 2008 (SKASM 2013), 111-120 (2013)
  17. C.K. Ghaddar, Unlocking the spreadsheet utility for calculus: A pure worksheet solver for differential equations, Spreadsheets in Education (eJSiE), 9, 1-16 (2016)
  18. K.G. Tay, S.L