How Do You Calculate Air Resistance for Projectiles in Excel?

[Peter G.]

My teacher wants me to use an excel spreadsheet to show the difference in the movement of projectiles using air resistance.

Can anyone help me with the equation for air resistance?

Thanks,
Peter G.

 

[jhae2.718]

The standard equation for air resistance is:
$$\mathbf{F_D} = C_D \frac{1}{2}\rho V^2 S (-\hat{\mathbf{V}})$$,
where:
$C_D$ is the coefficient of drag,
$\rho$ is density of air,
$V^2$ is the square of velocity,
S is the cross-sectional area normal to the flow, and
$-\hat{\mathbf{V}}$ is the unit vector opposite the velocity vector.