ME 209 programming homework need help asap
bufhad
homework_1.pdf
ME209
CSUN-Mechanical Engineering Department
Homework # 1
A parachutist jumps from a stationary platform. Until the rip cord is pulled, the jumper’s velocity can be computed with the following equation:
( / ) ( / ) ( ) (1 )d d
c m t c m t
o
d
gm v t v e e
c
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?
