Here are some spreadsheets you might wish to download

Dan Hatten's sheets

- charging a capacitor
- some nuclear decay data
- a linear fit using sliders
- a linear fit using solver
- monkey and hunter
- sine and RLC circuit

Template for analysis of video avi files.

- This lets you calibrate distances, then click on a point in the video
- The x, y coordinates are placed in columns in the sheet, along with the time
- A frame is also advanced, so at the end, you can plot the xy data.

An avi file of a bicycle wheel rotating due to a string attached to a descending weight

A sheet for calculating acoustical transmission through several layers of material

A sheet showing axes of a body which has undergone rotation according to the Euler angles

A ray-trace sheet with a slider controlling the lens focal length. You could add a slider to control object distance.

An animated sheet which numerically integrates vertical motion of a body under gravity and air drag

A sheet showing how a vector appears when the coordinate axes undergo a 1-D rotation

A sheet using sliders to 'scroll through' data on a graph. (VBA is use here)

A heavy-duty version of the previous sheet: scrolling and fitting of data, calculations in VBA

Numerical integration of particle on a tabletop connected through a hole in the table to a hanging mass

Heavy duty numerical integration and animated graphing of a trebuchet

Demo of VBA used to do some looping operations. Illustrates the use of VBA and buttons or labels.

A pivoted rod wins a 'race' with a ball placed on its end (acceleration of the end of the rod is greater downward than g)