Here are some spreadsheets you might wish to download

Dan Hatten's sheets


Template for analysis of video avi files.

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)