Programming and Numerical Methods - Visual Basic for Applications (VBA)
From 49.97 C$ /h
In this class, you will be learning how to use Visual Basic for Applications (VBA) to program and solve engineering problems. The type of class can be adapted to your needs, from a beginner (VBA basics) to an experienced user (advanced numerical methods).
Complete Program:
Programming
-Introduction to Visual Basic for Applications (VBA)
-Subroutines basics: variables and syntax
-Indexed variables and input data
-Communication Excel/VBA: read and write to/from the worksheet
-Loops and conditional statements
-External Functions
Numerical Methods
-Introduction to numerical methods: linear, non-linear equations and convergence criteria
-Errors and approximations
-Solving non-linear equations – Bracketing methods: Bisection and False Position
-Solving non-linear equations – Iterative methods: Newton, Secant and Fixed Point
-Solving systems of linear equations – Direct methods (n < 1000): Gauss Elimination and LU Decomposition
-Solving systems of linear equations – Direct methods (n < 3): Substitution method and Crame Rule
-Solving systems of linear equations – Direct methods (Tridiagonal matrices): Thomas algorithm
-Solving systems of linear equations – Iterative methods (large matrices): Jacobi, Gauss-Seidel
-Solving systems of linear equations – Gauss-Seidel convergence and relaxations
-Solving systems of non-linear equations – Newton and Fixed-point
-Differentiation: Taylor series and approximations
-Differentiation: first and second order differences: centred, forward and backward
-Integration: Lagrange interpolating polynomials
-Integration: Trapezoidal, Simpson’s 1/3, Simpson’s 3/8 Rules
-Integration: Composite rules
Advanced Numerical Methods
-Introduction to ODE’s and PDE’s
-Solving ODE’s – Initial Value Problems: Euler and Runge-Kutta
-Solving ODE’s – Boundary Value Problems: Shooting Method, Finite Differences
-Solving ODE’s – Finite Differences for linear BVP: Gauss and Thomas
-Solving ODE’s – Finite Differences for non-linear BVP: Newton-Raphson, Gauss-Seidel
-Solving PDE’s – Discretization and transformation into SODE
-Solving PDE’s – Application to Elliptic and Navier-Stokes
-Solving PDE’s – SEDO’s Stiff problems: Runge-Kutta and Predictor/Corrector methods.
Complete Program:
Programming
-Introduction to Visual Basic for Applications (VBA)
-Subroutines basics: variables and syntax
-Indexed variables and input data
-Communication Excel/VBA: read and write to/from the worksheet
-Loops and conditional statements
-External Functions
Numerical Methods
-Introduction to numerical methods: linear, non-linear equations and convergence criteria
-Errors and approximations
-Solving non-linear equations – Bracketing methods: Bisection and False Position
-Solving non-linear equations – Iterative methods: Newton, Secant and Fixed Point
-Solving systems of linear equations – Direct methods (n < 1000): Gauss Elimination and LU Decomposition
-Solving systems of linear equations – Direct methods (n < 3): Substitution method and Crame Rule
-Solving systems of linear equations – Direct methods (Tridiagonal matrices): Thomas algorithm
-Solving systems of linear equations – Iterative methods (large matrices): Jacobi, Gauss-Seidel
-Solving systems of linear equations – Gauss-Seidel convergence and relaxations
-Solving systems of non-linear equations – Newton and Fixed-point
-Differentiation: Taylor series and approximations
-Differentiation: first and second order differences: centred, forward and backward
-Integration: Lagrange interpolating polynomials
-Integration: Trapezoidal, Simpson’s 1/3, Simpson’s 3/8 Rules
-Integration: Composite rules
Advanced Numerical Methods
-Introduction to ODE’s and PDE’s
-Solving ODE’s – Initial Value Problems: Euler and Runge-Kutta
-Solving ODE’s – Boundary Value Problems: Shooting Method, Finite Differences
-Solving ODE’s – Finite Differences for linear BVP: Gauss and Thomas
-Solving ODE’s – Finite Differences for non-linear BVP: Newton-Raphson, Gauss-Seidel
-Solving PDE’s – Discretization and transformation into SODE
-Solving PDE’s – Application to Elliptic and Navier-Stokes
-Solving PDE’s – SEDO’s Stiff problems: Runge-Kutta and Predictor/Corrector methods.
Extra information
Not required, but better to have access to a computer with Excel.
Location
Online from Portugal
About Me
Doctor in Chemical Engineering
Specialised in programming, modelling and numerical methods
2022 – present | Senior CFD Researcher | University of Porto
Chaotic Flow Analysis for New Technology Development
2019 – 2022 | CFD Researcher | University of Porto
Mixing and Controlled Combustion
2017 – 2019 | CFD Researcher| University of Porto
Novel Lagrangian Algorithms for Flow Analysis
2016 – 2017 | Researcher | University of Porto
Evolutionary Algorithms for Process Optimisation
Specialised in programming, modelling and numerical methods
2022 – present | Senior CFD Researcher | University of Porto
Chaotic Flow Analysis for New Technology Development
2019 – 2022 | CFD Researcher | University of Porto
Mixing and Controlled Combustion
2017 – 2019 | CFD Researcher| University of Porto
Novel Lagrangian Algorithms for Flow Analysis
2016 – 2017 | Researcher | University of Porto
Evolutionary Algorithms for Process Optimisation
Education
Ph. D. Degree
2022 Ph. D. in Chemical and Biological Engineering
Faculdade de Engenharia da Universidade do Porto, Portugal
M. S. Degree
2017 M. S. in Chemical Engineering – Process and Product
Faculdade de Engenharia da Universidade do Porto, Portugal
Internship Program
2016 Algorithm Development for the Production of Carbon Nanofibers
École Nationale supérieure des Industries Chimiques, Nancy, France
2022 Ph. D. in Chemical and Biological Engineering
Faculdade de Engenharia da Universidade do Porto, Portugal
M. S. Degree
2017 M. S. in Chemical Engineering – Process and Product
Faculdade de Engenharia da Universidade do Porto, Portugal
Internship Program
2016 Algorithm Development for the Production of Carbon Nanofibers
École Nationale supérieure des Industries Chimiques, Nancy, France
Experience / Qualifications
8 years of experience:
Chaotic Flows: Strange Attractors & Poincaré Maps
Heat Transfer Analysis
Lagrangian Programming
Reactor Design
High-Performance Computing
Lean Controlled Combustion
Hydrogen Combustion
Particles Swarm Optimisation
Process Simulation
Cyclic Adsorption Modelling
Chaotic Flows: Strange Attractors & Poincaré Maps
Heat Transfer Analysis
Lagrangian Programming
Reactor Design
High-Performance Computing
Lean Controlled Combustion
Hydrogen Combustion
Particles Swarm Optimisation
Process Simulation
Cyclic Adsorption Modelling
Age
Teenagers (13-17 years old)
Adults (18-64 years old)
Seniors (65+ years old)
Student level
Beginner
Intermediate
Advanced
Duration
60 minutes
The class is taught in
English
French
Portuguese
Skills
Availability of a typical week
(GMT -05:00)
New York
Mon
Tue
Wed
Thu
Fri
Sat
Sun
00-04
04-08
08-12
12-16
16-20
20-24
Good-fit Instructor Guarantee