Click Here for AirGunHome.com Main Page
Argentina Australia Belgium Canada Chile Denmark France Germany Greece India
Italy Mexico New Zealand Netherlands Norway Russian Federation South Africa Spain Turkey United Kingdom United States
AirGunHome.com: THE Worldwide Airgun Forum


AirGunSeals.com Main Page Link
Air Gun Home Forum Index Register FAQ Memberlist Search

Air Gun Home Forum Index » General Air Gun Questions and Topics » Trajectory Calculator - Excel Sheet
Post new topic  Reply to topic View previous topic :: View next topic 
Trajectory Calculator - Excel Sheet 
PostPosted: Thu Feb 02, 2012 5:19 pm Reply with quote
shawnhu
Member
Member
Joined: 23 Jan 2012
Posts: 62
Does anyone know where I can find the formulas for calculating trajectory in Excel?

I know of some websites that would do the calculations for you, but was curious to know if there are any Excel sheets out there.

I'm looking to plot a few different senarios and print them out to study or create a cheat sheet.
View user's profile Send private message
 
PostPosted: Thu Feb 02, 2012 6:51 pm Reply with quote
SMP
Silver Status Member
Silver Status Member
Joined: 04 Feb 2011
Posts: 1183
Location: Just south of "Out There"- Land O Lakes Ontario
http://www.hawkeoptics.com/apps/chairgun-pro.html


Download this for free. Simply awesome software

_________________
Sean
View user's profile Send private message
Chairgun is great 
PostPosted: Thu Feb 02, 2012 7:31 pm Reply with quote
Dukemeister
Member
Member
Joined: 08 Feb 2010
Posts: 92
Location: Ontario, Canada
Chairgun is great!
If you do want to do your own tweaks in EXCEL, try this site:
http://www.jacksonrifles.com/ballistics.htm

_________________
Duke ))))----//----------==
View user's profile Send private message
In my opinion.... 
PostPosted: Thu Feb 02, 2012 7:59 pm Reply with quote
NZ Shooter
Suspended
Joined: 17 Dec 2011
Posts: 146
Location: Dunedin, New Zealand
The best 'trajectory calculator' is out at the rifle-range. Putting in serious trigger time is way better than any computer programme. I will admit from my limited experience with trajectory software, it can be freakishly accurate - to a degree. There are so many variables that real-world shooting is, IMHO, the best measure of any given rifle/velocity/pellet combination. I pinned a rabbit at 127 metres - on the 3rd attempt. I'd never shot past 80 odd metres prior, and I'll be dammed if I could have done any better having 'chairgunned' the potential situation prior to seeing the bunny. And yes, that was with my Patriot (as seen in my signature). I will admit that I could see where the slugs hit on the first two shots, as the mental bunny decided to keep nibbling on the grass, as
2 15.43 grainers blew up a dust cloud right above him, on a rocky hill - twice. I'm not knocking the use of such software, however I do know trigger time is a great way too know exactly what your gun can do at range. Cool

_________________
Webley Patriot .22 @ 28 fpe
Nikko MountMaster 4x40 AO
View user's profile Send private message
 
PostPosted: Thu Feb 02, 2012 8:55 pm Reply with quote
rsterne
Moderator
Moderator
Joined: 15 Jan 2008
Posts: 2998
Location: Coalmont, BC
The problem with trying to fine tune a calculator to be better than ChairGun is that the BCs are not a constant, they vary with velocity.... Unless you know the BC for your gun, at every velocity between the muzzle and the target.... you can't do a "perfect" calculation....

Bob

_________________
Dominion Marksman Silver Shield - 5890 x 6000 in 1976, and downhill ever since!
Airsonal: Too many to count!
View user's profile Send private message
Re: In my opinion.... 
PostPosted: Sun Feb 05, 2012 12:06 pm Reply with quote
twalter
Veteran Member
Veteran Member
Joined: 12 Jun 2011
Posts: 180
Location: East TN USA
NZ Shooter wrote:
The best 'trajectory calculator' is out at the rifle-range. Putting in serious trigger time is way better than any computer programme. I will admit from my limited experience with trajectory software, it can be freakishly accurate - to a degree. There are so many variables that real-world shooting is, IMHO, the best measure of any given rifle/velocity/pellet combination. I pinned a rabbit at 127 metres - on the 3rd attempt. I'd never shot past 80 odd metres prior, and I'll be dammed if I could have done any better having 'chairgunned' the potential situation prior to seeing the bunny. And yes, that was with my Patriot (as seen in my signature). I will admit that I could see where the slugs hit on the first two shots, as the mental bunny decided to keep nibbling on the grass, as
2 15.43 grainers blew up a dust cloud right above him, on a rocky hill - twice. I'm not knocking the use of such software, however I do know trigger time is a great way too know exactly what your gun can do at range. Cool


I would tend to agree with most of this post. I have found some odd behaviors of pellets, holds, and temperature that all affect my POI. So I think maybe with some "should be" from the software and "what is" when out in the field with a given pellet to include all the variables one may get what is most likely to happen. Im most intrigued at this point at angles of 30 degrees to 90 in relationship to shots fired -15 (in relation to your shooting angle and ground) to maybe 15 degree as these seems to be a fairly consistent sweet spot for POI taking into account pellet, hold, wind, shooting position, zero, temperature and scope eye relief. I have a lengthy dissertation Ive been working on for your objective viewing. Ive yet to be able to hang a target 30-50 feet up and shoot it for various angles and distances and then retrieve it. Which would be the next step...

_________________
Benjamin Marauder .25 cal scoped with Bushnell 4-16/40AO CF with Hill hand pump
Gamo Hunter 220 .177 with CP 4-16/AO
View user's profile Send private message
 
PostPosted: Sun Feb 05, 2012 12:34 pm Reply with quote
rsterne
Moderator
Moderator
Joined: 15 Jan 2008
Posts: 2998
Location: Coalmont, BC
Shooting at up or down angles is really very simple.... the drop is relative to the horizontal distance to the target, not the straight line distance.... If you shoot straight up and the pellet crosses the line of sight at 10 yards from the muzzle, then after that it gets increasingly higher above the line of sight and never drops below it.... The rule of thumb is 20-20.... If you are within 20 yards and 20 degrees of horizontal, no correction necessary.... After that, your POI will be above where you expect, whether you are shooting uphill or downhill makes no diffference.... If you are shooting at 60 degrees (up or down), the horizontal distance is half the straight line distance.... If you are shooting at 30 yards (straight line) then use the POI for 15 yards....

Bob

_________________
Dominion Marksman Silver Shield - 5890 x 6000 in 1976, and downhill ever since!
Airsonal: Too many to count!
View user's profile Send private message
 
PostPosted: Mon Feb 06, 2012 2:30 am Reply with quote
shawnhu
Member
Member
Joined: 23 Jan 2012
Posts: 62
I think the calculations is much more complicated than the horizontal distance, especially since we need to look into flight time. Gravity acts on a pellet as soon as it leaves the barrel, until it hits the POI.
View user's profile Send private message
 
PostPosted: Mon Feb 06, 2012 11:33 am Reply with quote
rsterne
Moderator
Moderator
Joined: 15 Jan 2008
Posts: 2998
Location: Coalmont, BC
If you don't want to take my word for it, I suggest you Google it and start reading....

http://www.chuckhawks.com/shooting_uphill.htm

http://www.loadammo.com/Topics/April04.htm

The bullet DROP relative to the line of bore is the same for the same actual distance and flight time, you are correct.... However, the way you must hold to make the shot is proportional to the cosine of the angle of the line of sight.... That means you hold the same as you would to make a shot with the same Horizontal distance to the target....

Bob

_________________
Dominion Marksman Silver Shield - 5890 x 6000 in 1976, and downhill ever since!
Airsonal: Too many to count!
View user's profile Send private message
Trajectory Calculator - Excel Sheet 
  Air Gun Home Forum Index » General Air Gun Questions and Topics
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 5 Hours  
Page 1 of 1  

  
  
 Post new topic  Reply to topic  

Note: If you are seeing "Please enter your username and password to log in." Your browser cookies have been reset
or you need to register to access the topic in question. Use the 'Register' button near the top left of this page.


Click Here for AirGunHome.com Main Page


Powered by phpBB © 2001-2004 phpBB Group
Partial Styling Supplied by Vjacheslav Trushkin Themes Database.