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.
  
  



• e^x = limit (1+1/n)ⁿ. This Excel spreadsheet shows how e^x 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.