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

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

Comments

Do your homework yourself!

You are correct; however, we should still try to help as long as they show that they have tried, which is missing here.

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.

What have you done to accomplish this so far?

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

Exactly!

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

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject,
503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada
+1 416-849-8900 x 100