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.

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)