12,956,197 members (99,553 online)
Rate this:
See more:
The x and y coordinates, as a function of time, t, of a projectile (a ball) fired with an initial velocity, v, at an angle of θ with respect to the ground, are given by these formulas:

dx = v. cos(θ).dt
dy =v.sin(θ).dt – (g.dt2)/2 (where gravitational acceleration, g = 9.81 m/sec2)
a. Using these formulas, write a VB/Excel program that displays a table of x and y values for a projectile fired with an initial velocity of 400 m/sec at an angle of 22.8 degrees. (Hint: best to convert to radian measure). As an initial test, the table should contain values corresponding to the time interval 0 to 10 seconds in increments of 0.1 seconds.
b. Modify your program to take user input on elevation, initial velocity and time-step increments.
c. Devise a method to show the time and distance the projectile travelled and lands.
d. Can you determine when the projectile reaches terminal velocity?

this is question that i have to solve but i dont get anything
Posted 11-Feb-13 8:07am
Updated 11-Feb-13 8:35am
v2
Maciej Los 11-Feb-13 14:37pm

ryanb31 11-Feb-13 17:02pm

You are correct; however, we should still try to help as long as they show that they have tried, which is missing here.
Richard MacCutchan 11-Feb-13 15:01pm

The first thing you need to do is write it out as mathematical formulas. Once you have done that then converting it to VBA should be less of a difficult issue.
joshrduncan2012 11-Feb-13 15:51pm

What have you done to accomplish this so far?
CHill60 11-Feb-13 16:25pm

You need to refer to your course notes first. Secondly, use that information to draft some code. Next, run that code and decide that it doesn't work *quite* the way you expected. Fourth, work out whereabouts your problem is and THEN post an actual question in this forum - the last step is completely optional ... you might actually not have to do that bit if you do step 1 properly
Maciej Los 11-Feb-13 16:31pm

Exactly!
ryanb31 11-Feb-13 17:02pm

There are many, many ways to do this. What do you have so far so that we can help with where you are stuck?

Top Experts
Last 24hrsThis month
 OriginalGriff 325 Kornfeld Eliyahu Peter 270 Maciej Los 100 omerkamran 80 CHill60 60
 OriginalGriff 6,849 CHill60 3,550 Maciej Los 3,223 ppolymorphe 2,060 Jochen Arndt 1,975