Quote:
Originally Posted by Ether
|
I've recently received a couple of PMs asking about the formulas in the spreadsheet. I'm going to post summaries of the answers here so interested students may benefit:
Some cells are hidden to make the user interface cleaner. To make those cells visible: Unhide columns GHIJK, move the graph out of the way, and highlight the whole spreadsheet.
The air drag acceleration vector
D always points 180 degrees opposite to the Velocity vector
V.
The magnitude of
D is modeled as:
(V
2/V
t2)*g
... where V
t is the magnitude of the terminal velocity.
The magnitude of the X component of
D is
(V
2/V
t2)*g*cos(θ)
= (V
2/V
t2)*g*(Vx/V)
= (V*V
x/V
t2)*g
The magnitude of the Y component of
D is
(V*V
y/V
t2)*g