By: James Juncker
New: 14-01-2016 13:07
Updated: 15-01-2016 06:32
Total downloads: 775 times

An Excel document able to find the range in which you can shoot into the goal at a given speed and angle. The Document may have some updates but should remain the same.

All you should need is the speed at which you are firing the ball, an angle and a shooter height. As a note TONS of credit to Ether with the original posting of the basic sheet. I hope to be able to update this every year there is a ball involved in the game... well see though. If there is anything else that would be useful on here let me know so that I can attempt to add that to this sheet for the use of other teams! Good luck this year!

You shouldnt need the Field Drawing in order to get the spreadsheet to work.

Changing the numbers in the boxes in the upper left changes the trajectory which is visible on a graph just underneath with the green lines being the goal height. as well the effective range (rough estimate) is shown on the field to give the range a perspective.

Attached Files

• Ball Trajectory with drag revD

  parabola vs air drag revD.xlsx

  download file

  uploaded: 14-01-2016 13:07
  filetype: lsx
  filesize: 377.1kb
  downloads: 466

  
  

• Modified Field Drawing

  Modified Field.png

  download file

  uploaded: 14-01-2016 13:07
  filetype: png
  filesize: 246.42kb
  downloads: 307

  
  

Recent Downloaders

• Guest
• jvdiv

Tags

Add Tags