# Book 1 Resources

In the navigation panel you can download a zip file containing **all** the resources for Book 1,
or you can click on the links below to download them individually.
(You may need to right-click and choose** 'save link as ...'**).

**bisection_method.xlsm**. Relates to the computer code in Chapter 1, page 32. This Excel spreadsheet shows you how to create a function that uses the bisection method to solve an equation.**basic_maple_commands.mw**. Relates to Chapter 1, page 33. This Maple worksheet introduces you to the basic Maple commands for solving equations, plotting functions, working with vectors and matrices, and working with complex numbers in polar and rectangular coordinates.**gauss-jordan.xlsm**. Relates to the computer code in Chapter 2, page 49. This Excel spreadsheet shows how to create a macro that does Gauss-Jordan elimination.**matrix_arithmetic.xlsx**. Relates to Chapter 3, page 96. This spreadsheet shows how matrix arithmetic is implemented in Excel.**loans_and_mortgages.xlsx**. Relates to Example 4.20. This Excel spreadsheet has two sheets. The first sheet shows how a debt grows when a loan has different types of compounding applied. The second sheet shows how a mortgage is calculated.**power.xlsm**. Relates to Example 5.14. This macro-enabled Excel spreadsheet shows the instantaneous and average electric power when the AC current and voltage are out of phase.**complex_exp_x_as_limit.xlsx**. Relates to Problem Set 7.3, #6. This Excel spreadsheet shows how*e*can be computed for any^{x}*x*, real or complex, as the limit of repeated multiplication.**RLC_circuits.xlsm**. Relates to Chapter 8, page 257, and resonance. This macro-enabled Excel spreadsheet shows how to implement slider and button controls to set values of*R*,*L*,*C*and*ω*and see the effect on the*Z*diagram and on the phase shift between the voltage and current.**gauss-jordan_complex.xlsm**. Relates to the computer code in Chapter 8, page 277. This Excel spreadsheet contains a macro that does Gauss-Jordan elimination with complex numbers.