Physics Spreadsheets

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.

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.

Solves simultaneous linear equations in 2 and 3 variables using Cramer's Rule.

Solves problems where some of the following quantities are given: object distance, image distance, focal length, lens position, image location.

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. This spreadsheet also calculates dot and cross products when the components of the vectors are provided.