hi,

i am in an IT lesson at the moment and i have to create a computer model using excel, this model needs to simulate a cannon firing a cannon ball, but i need some help with the physics, i know that gravity speed is 9.8m/s and the distance the ball travel is to do with it's velocity, but i need a formula to work out the distance traveled, and i will also be changing the angle of the cannon and i want to know what the formula is for this

different angle of cannon effects the distance of the ball traveled, the velocity on this can be anything as long as it is the same.

Thanks for any help, if you don't understand what i have written sorry, mail me and i will try and re-word it

Thanks again