Numerics for PDE using EXCEL

1
Numerics for PDE using EXCEL

• Anthony Peirce
• Department of Mathematics
• University of British Columbia

2
First derivative Approximations
3
Second derivative Approximation
4
1D heat equation
5
Discrete from of 1D heat equation
6
Laplaces Equation
7
Discretization of Laplaces Equation
8
Features of point iterative methods

• Consider solving
• By iterating the difference equations
• Using Jacobi iteration
• Iterate to equilibrium using diffusion equation

9
The wave equation