Your Status: Logged out Log in

Setting up Microsoft Excel spreadsheet to simulate projectile motion.  

Member rating: No Rating | Words: | Submitted: Mon Jun 19 2006

Page Preview
Preview
Previous 1 of 5 Next

On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:

Access Physics Simulating Projectile Motion Using Microsoft Excel V.J. Clarke Setting up Microsoft Excel spreadsheet to simulate projectile motion. The study of the motion of a projectile, called ballistics can be simulated mathematically by use of a spreadsheet, i.e. Microsoft Excel. To create a simulation, a few assumptions have to be made about the projectile, its launch device, and the forces acting on it in a perfect situation. The mass of the projectile is irrelevant because the acceleration due to gravity is roughly the same wherever you are on Earth, and what ever the mass of the object. I assumed that acceleration due to gravity was a constant 9.8 meters/s/s, that air resistance was negligible, and that the projectile itself was suitably streamlined to reduce drag. In fact, for calculations concerning short-range projectile motion, air resistance can be totally disregarded, but calculations concerning real life long-range artillery would need to include a compensation factor to make...

Get instant access



  • Instant, unlimited access to our documents in full
  • Swap your work for free access, or pay £4.99
  • To see the full version of this document and 149,958 others
Register Now