KaydedilenlerDerginizi ekleyin

Dergiler / 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
Sayfa
88–101
Yayın Tarihi
2018-06-30
DOI
—
🏛️Bu makalenin bibliyografik verileri ve tam metin bağlantısı DergiPark üzerinden sağlanmıştır.
DergiPark Kaydı ↗
✨

Yapay Zeka Hızlı Bakış & Çıkarımlar

AI Insight
⚡ TL;DR(1 Cümlede Hızlı Çıkarım)

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

📌 3 Maddede Bu Makale

🎯
Amaç & Hipotez: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.
📊
Temel Bulgular & Veri: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.
💡
Sonuç & Katkı:This solver is user-friendly especially for beginner users of Excel and VBA.
🔬Tür:Araştırma Makalesi
📍Kapsam:Genişletilmiş Akademik Örneklem
⚙️Değişkenler: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.

🔖

Bu Makaleye Atıf Yap

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

📄 Tam Metin PDF Okuyucu

📄

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

Kaynakça (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