Page 251 - Excel for Scientists and Engineers: Numerical Methods
P. 251
228 EXCEL NUMERICAL METHODS
Figure 10-8. Simulation of first-order kinetics by using a Runge-Kutta custom function.
(folder 'Chapter 10 Examples', workbook 'ODE Examples', worksheet 'First Order')
If you compare Figure 10-8 with Figure 10-3, you can see that the
spreadsheet calculations are simplified considerably.
Systems of First-Order Differential
Equations
Sometimes a system is described by several differential equations. For
example, the coupled reaction scheme
kl k3
A%B%C
k2 k4
results in the simultaneous equations
d[All
-- - -4 [All + k, [BI, (10-17)
dt
(1 0-1 8)
