Coulomb's law and electric fields (xls)download
Enter the location and charges of up to 4 particles, a field point, and the spreadsheet calculates electric field, potential, and other quantities.
Enter the coefficients of 2 polynomials and the spreadsheet multiplies them, and performs other operations.
Quadratic Equation Solver (xls)download
Enter the coefficients of a quadratic polynomial, and the spreadsheet solves them and presents the answer in several different ways.
Enter coordinates and velocities, and the spreadsheet does Lorentz coordinate transformations and velocity transformations in up to 2 reference frames. This spreadsheet also solves relativistic Doppler shift problems.
Simultaneous Equations (xls)download
Solves simultaneous linear equations in 2 and 3 variables using Cramer's Rule.
Thin Lenses and Mirrors (xls)download
Solves problems where some of the following quantities are given: object distance, image distance, focal length, lens position, image location.
Vector Addition (xls)download
Enter the magnitudes and angles of up to 5 vectors, and the spreadsheet graphically adds them, tip to tail, and calculates the x and y components of each vector and of their sum. It also displays the answer in polar form. Select "re-draw arrowheads" to update the display. Excel's scatter plot does not have an "arrowhead" option when connecting points.