Projectile Motion Simulator

I created a projectile motion simulator which accounts for the effect of air resistance (drag) and the Magnus effect. This simulator is programmed in Microsoft Excel and simulates the motion of a projectile traveling through the air, while being acted upon by the force of gravity, drag, and (optionally) the Magnus effect. This projectile motion simulation program is very useful for estimating the actual flight path of a projectile (e.g. a baseball), with often much greater accuracy than is predicted by equations of motion which account only for the effect of gravity.

A user manual in PDF format is included with the Excel program. The manual shows you how to use the Excel program, and also shows the derivation of the equations of motion for a projectile which is acted upon by the force of gravity, drag, and (optionally) the Magnus effect. The Excel program optionally allows you to include the influence of the Magnus effect for spherical spinning objects which rotate in the vertical plane (i.e. the plane of motion of the projectile).

The simulator is straightforward to use and since it is programmed in Excel the data is displayed automatically in charts, for easy reference.

The two figures below show examples of the charts generated by the Excel spreadsheet. In the first chart you can compare the motion of a projectile under the influence of gravity, drag, and (optionally) the Magnus effect, to the theoretical motion of the projectile with only gravity present. This gives you an easy way of seeing the difference between the two.

x and y position for projectile motion simulation

x and y position versus time for projectile motion simulation

Below is a screen capture of the Excel spreadsheet.

screen capture of excel spreadsheet for projectile motion simulator

With the simulator you can also:

• Determine the terminal speed of a projectile under the influence of gravity and drag, and determine approximately how long it takes to reach terminal speed. For example, you can estimate how long it takes a skydiver to reach terminal speed after jumping from the plane.

• Determine the instantaneous acceleration of a projectile under the influence of gravity, drag, and (optionally) the Magnus effect.

Assumptions made when using the simulator:

• The motion of the projectile occurs in the vertical plane. Thus, its motion is two-dimensional.

• There is negligible wind.

All the files that come with this projectile motion simulator are contained in a single (compressed) file, in the "zip" format. This file is 2.5 MB in size. You need to uncompress this file before you can do anything. This file can be uncompressed with several different types of compression software (such as WinZip, which may already be installed on your computer). If you don't have compression software on your computer, or you are unable to uncompress the file with the software you do have, you can download and install the 7-zip compression software on to your computer. It's available for free at:

To use the projectile motion simulator program you need to have Microsoft Excel installed on your computer. The program is compatible with all versions of Excel.

The cost of the Excel program plus manual is $4.95 CAD. It's available as an instant download via PayPal and PayLoadz.

To purchase, click on the Buy Now button below. This will open another browser window, which will take you to the PayPal site. From there you can enter your purchase information, and then download the product.

Support is available if you have any questions or need assistance with anything. You may email me via my contact page. My alternate email address is: email address proj. If possible, write me with the same email address that you entered in the purchase form. This isn't necessary but it just makes it easier for me to confirm that you actually purchased the product. If you didn't purchase the product your support questions will go unanswered.

Finally, if you are not satisfied with the product, let me know within 30 days of purchasing and I'll refund your money, no questions asked.

Return from Projectile Motion Simulator to Kinematics page

Return from Projectile Motion Simulator to Real World Physics Problems home page