Chronology Current Month Current Thread Current Date
[Year List] [Month List (current year)] [Date Index] [Thread Index] [Thread Prev] [Thread Next] [Date Prev] [Date Next]

Re: animated motion made easy on spreadsheets



Hi,

Sliders in spreadsheet is a great tool. Thanks

Here at U of AZ in our Advance Lab measure Big G
with a Cavendish balance. The actual primary
measurement of position of a light spot is a
damped oscillation in time. Full analysis
requires a five parameter non-linear least-squares
fit. Using Sliders and some reasonable first
guess, one can do a quick grid search by cycling
through the five parameters to minimize
chi-squared. Four or five iterations gets one
very close. Sweet.

An example is available at:

http://www.physics.arizona.edu/~haar/ADV_LAB/Big_G_Slider.xls

This example is designed as a starting point for
our students, and as such is not optimized. For
example, the search stepsize is to large. Also
some of the parameters enter the fitting equation
simply, but would need translation into the
standard form of things.

Thanks
Roger

***************************************************************

Date: Sun, 16 Feb 2003 13:17:45 -0500
From: "Michael J. Moloney" <Michael.J.Moloney@ROSE-HULMAN.EDU>
Subject: animated motion made easy on spreadsheets

In addition to all the fine stuff at Pat Cooney's site, everyone
should have
a try at an animated spreadsheet.

Here are some instructions on how to do it.

http://www.rose-hulman.edu/~moloney/PH112/AnimatedTravWaveInstr.htm

Mike

--
Mike Moloney, Physics & Optical Engineering Department
Rose-Hulman Inst of Tech, 812 877 8302
moloney@rose-hulman.edu http://www.rose-hulman.edu/~moloney