Example Spreadsheets for Phys 1101 & Phys 1120 Labs - RICHMOND

Phys 1101-1120 Example Spreadsheets


  • Below are PDFs of spreadsheets with (fake) example data entered into them in red. After creating your own spreadsheets for the labs, use these data to check whether you have typed your formulae correctly. You should be able to reproduce the calculated values in black.
  • Caveat: These spreadsheets were created in August 2010, and although they have been checked carefully, there is still the possibility that typos remain in them. If you are unable to reproduce one of the answers, ask your lab instructor to help check your calculations.

 Mini-Lab 1:
Resonance of a string

 Mini-Lab 2:
Resonance of Air Columns

 Expt 1:
Uniform Linear Motion

 Expt 2:

 Expt 3:
The Ideal Spring (2 pages)

 Expt 4:
The Simple Pendulum

 Expt 5:
Collisions in One Dimension (2 pages)

 Expt 7:
Uniform Circular Motion

 Expt 8:
Projectile Motion

 Expt 9:
Moment of Inertia (2 pages)

 Expt 10:
The Physical Pendulum

 Expt 11:

 Expt 12:
Leaning Ladder