Please Help Me With Excel Programing

Discussion in 'Gaming' started by White B O I, Nov 29, 2006.

  1. Nov 29, 2006 at 10:05 PM #1
    White B O I

    White B O I Well-Known Member

    Age:
    36
    Posts:
    813
    Likes Received:
    0
    Joined:
    Apr 11, 2006
    Location:
    Table Town, Arizona
    ok im doing this physics project right now and im completly stumped so im here to ask you people for help ill explain as much in depth as possible but read all this before asking a question please:

    Problem:
    To model the position. velocity, and acceleration of a rocket from lift off until it returns to earth. The Excel model will be designed to model the flight for a 30 second time period. Time will step up in increments of 0.02s. The rocket will only travel in the vertical direction.

    N = Newtons; 1 N = 4.45lbs, 1N = 10kg

    Variables:
    mr: mass of rockect excluding the engine (0 to 0.20kg)
    FT: The thurst of the rocket while it is fireing (0 to 20N)
    me: The initial Mass of the Engine (0 to 0.20kg)
    b: The mass burn rate of the engine (0 to 0.2kg/s)
    d: The drag coefficient used to calculate tje drage force (0 to .2); if you ever taken a physics class this would be equivilent to the force of friction
    T: The burn rate of the engine (0 to 5s)

    Equations Variables Explained:
    X = horizontal position (in meters (m))
    Xo(x sub o) = initial/original horizontal position (in meters (m))
    V = velocity (meters per second (m/s))
    Y = vertical position (in meters (m))
    Yo(y sub o) = initial vertical position (in meters (m))
    Vo(v sub o) = Initial/original Velocity (meters per second (m/s))
    a = Acceleration/force due to gravity (we use a constant for this and it is -10m/s²)
    me = Mass of the rocket (0 to 0.20kg)
    meo = Initial Mass of rocket (0 to 0.20kg)
    b = burn rate (0 to 0.2kg/s)
    t = the burn rate of the engine (0 to 5s)

    Equations (all equations can be switched aroudn to find a different variable):
    X=Xo+Vot+(1/2)at² (used to find horizontal postion)
    Y=Yo+Vot+(1\2)at² (used to find vertical position)
    V=Vo+at (used to find velocity)
    me=meo-bt (used to find the mass of the engine)
    F=-dv (used to find the force of the drag coefficient and velocity)

    to get a good grade on this i need to have this:
    A working model for the rocket with an engine thrust (Ft) for a burn time (T). The rocket mass (mr) will be constant, but the engine mass (me) wil
    be decrease according to the function (me = meo -bt) Air friction will depend on the velocity of the rocket as described in the following function: F = -dv

    i constructed the .xls file but i am completly lost on what to do
    .xls file download

    any help at all appreciated thanks
    -Travis
     

Share This Page