Book 1 Resources
In the navigation panel you can download a zip file containing all the Book 1 resources, or you can click on the links below to download them individually. (On some browsers you may need to right-click and choose 'save link as ...' ).
- Basic Maple commands. This
Maple workbook 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. It relates to Chapter 1,
page 33 of the book.
- The bisection method. This
is an Excel spreadsheet that shows you how to find the roots of an equation
using the bisection method. Programmers: See how to do this with a Visual Basic
function. It relates to the computer code in Chapter 1, page
30
of the book.
- The Gauss-Jordan elimination method.
This Excel spreadsheet does Gauss-Jordan elimination.
Programmers: See how this is done with a VB subroutine (macro).
Relates to the computer code in Chapter 2,
page 48.
- Matrix arithmetic in Excel.
This spreadsheet shows how matrix arithmetic is implemented in Excel.
Relates to Chapter 3,
page 96.
- Calculating loans and mortgages.
This Excel spreadsheet shows how a debt grows when a loan has different types of
compounding applied, and how a mortgage is paid off. Relates to
Example 4.20.
- Calculating AC power. This Excel spreadsheet
shows the instantaneous and average electric power that results when an AC current and
voltage are out of phase. Relates to
Example 5.14.
-
ex = limit (1+1/n)n.
This Excel spreadsheet shows how ex can be computed for any x,
real or complex, as the limit of repeated multiplication.
It also explains how complex numbers are implemented in Excel. Relates to
Problem Set 7.3, #6.
- RLC circuits. This Excel
spreadsheet shows how in an AC series circuit the values of
R, L, C and ω affect
the Z diagram and the phase shift between the voltage and current.
Programmers: See how to write code to implement slider and button controls to set
the values of R, L, C and ω. Relates to Chapter
8, page 257, and resonance.
- The Gauss-Jordan elimination method
(with complex numbers). This
Excel spreadsheet contains a macro that does Gauss-Jordan elimination with
complex numbers. This can be used, for example, to solve AC network problems.
Relates to the computer code in Chapter 8,
page 276.







