Excel Spreadsheets

Drag to rearrange sections
Rich Text Content

In the video, I quickly show the conclusions generated by four excel spreadsheets, but should you be interested in searching them further, they can be found below. Each one uses a formula, to use already calculated information in order to produce information for future calculations. In essence, a few initial conditions as well as some laws of physics governs everything that happens later, much like the VPython program does. This is just a little bit more messy and laggy (sorry).Each consequent spreadsheet adds an element of complexity to the problem (excluding the 3rd, which is the one that shows how far we make past the center with constant air pressure).

And remember, all of these spreadsheets just used algorithims that were copied many many times. So if you are interested, continue the formulas down and see what would happen later, especially in the 4th spreadsheet which does not end when we hit the center. However, realize when the spreadsheet is no longer valid. For instance, the signs of the accelerations may need to be flipped when we hit the center.  

rich_text    
Drag to rearrange sections
Rich Text Content
rich_text    

Page Comments