Page 256 - Excel for Scientists and Engineers: Numerical Methods
P. 256
CHAPTER 10 ORDINARY DIFFERENTIAL EQUATIONS. PART I 233
The parameters used in the simulation were [A10 = 5.00 x 1O-j mol L-', kl =
0.5 s-' and k2 = 0.4 s-'.
Part of the spreadsheet is shown in Figure 10-11. The formulas for the
derivatives, in cells GI 0, H 10 and I1 0, are
=-k-l *J 10
=k-l*JlO-k-2*KlO
=k_2*KI 0
and the formulas in cells J11, K11 and L11 are
=Runge3(AlO,JI O:L1O,G1O:llO,Al l-Al0,l)
=Runge3(AlO, J10:L10,G10:llO,Al l-A10,2)
=Runge3(AlO,J1O:L1O,G1O:llO,Al l-A10,3)
Figure 10-11. Spreadsheet for the Runge-Kutta simulation
of consecutive first-order reactions.
(folder 'Chapter 10 Examples', workbook 'ODE Examples', worksheet 'A->B->C')
