/itb-vba-numerical-analysis-course

Numerical analysis course using VBA in Excel by Bandung Institute of Technology (ITB)

ITB VBA Numerical Analysis Course

This repository contains my portfolio of numerical analysis using VBA in excel experience, practice and final task practiced and completed by me in metallugical engineering undergraduate program, faculty of mining and petroleum engineering, Bandung Institute of Technology (ITB), Indonesia.

Curriculum

  1. One Variable Equation Solution
    • Bisection Method
    • Regula Falsi Method
    • Fixed Point Method
    • Newton - Raphson Method
    • Secant Method
  2. Simultaneous Equation Solution
    • Newton - Raphson Method
    • Steepest Descent Method
  3. System of Linear Equations
    • Gauss Method
    • Gauss - Jordan Method
  4. Numerical Integration
    • Trapezoid Method
    • Midpoint Method
    • 1/3 Simpson Method
    • 3/8 Simpson Method
  5. Solution of Ordinary Differential Equations
    • Euler Method
    • D. Taylor Method
    • Heun Method
    • R-K 4 Method
  6. Numerical Solution of Partial Differential Equations
    • Finite Difference Method

Practice

  1. One Variable Equation Solution
  • Bisection Method

image

  • Regula Falsi Method

image

  • Fixed Point Method

image

  • Newton - Raphson Method

image

  • Secant Method

image

  1. Simultaneous Equation Solution
  • Newton - Raphson Method

image image

  • Steepest Descent Method

image

  1. System of Linear Equations
  • Gauss Method

image image

  • Gauss - Jordan Method
  1. Numerical Integration
  • Trapezoid Method

image

  • Midpoint Method

image

  • 1/3 Simpson Method

image

  • 3/8 Simpson Method

image

  1. Solution of Ordinary Differential Equations
  • Euler Method
  • D. Taylor Method
  • Heun Method
  • R-K 4 Method
  1. Numerical Solution of Partial Differential Equations
  • Finite Difference Method

Final Task

All in one numerical analysis methods for finding the solutions of the given question in Final Task_Numerical Analysis_ITB.pdf

image

References

  1. J. Douglas Faires and Richard Burden, “Numerical Methods”, Brooks Cole Publisher, Fourth Edition, 2012
  2. Steven C. Chapra and Raymond P. Canale, “Numerical Methods for Engineers,“ 6th edition, Mc.Graw-Hill International Edition, 2009
  3. SS. Rao,“Applied Numerical Methods for Engineers and Scientists“, Prentice-Hall, 2001
  4. Kenneth J. Beer, “Numerical Methods for Chemical Engineering: Applications in MATLAB,“ Cambridge University Press, first edition, 2006