A parachutist jumps from a stationary platform. Until the rip cord is pulled, the jumper's velocity can be computed with the following equation:
v(t) = voe-(cd/m)t +gm/cd(1-e-(cd/m)t)
where v(t) is the downward velocity [m/s], v0 is the initial downward velocity, t is time [s], g is the gravitational acceleration constant [≈9.81 m/s2], m is the jumper's mass [kg], and cd is the drag coefficient [kg/s], which parameterizes air resistance.
Develop an Excel workbook where the user can enter the mass, the drag coefficient, initial velocity, and end time. The user should be able to see the calculated velocity of the time period [0,end_time] in table and chart formats. Your submitted file should include:
1- Named Cells and Range
2- A properly created and labeled graph of velocity vs. time (i.e. good graph as we discussed in class).
3- Table shows the calculated velocity at each time step.
4- Discuss the behavior of the jumper's velocity as the velocity increase, i.e. as an engineer what is the information you can extract from the equation above?