GTA
All Springer/NP/PCP Air Gun Discussion General => Air Gun Gate => Topic started by: BushWacker on February 15, 2016, 04:35:50 AM
-
I worked out a simple Excel spreadsheet to compare pellets. Not sure if anyone can use it but you are welcome to it. If there is a way to post it here someone please let me know and I will do that.
Here is a copy of the Blank one to take in the field and fill out. Input the Pellet Weight & Shot Speed numbers and it will calculate the rest at the bottom.
(http://i589.photobucket.com/albums/ss340/WackyBush/Guns/blank_zpsojaf4qb7.jpg) (http://s589.photobucket.com/user/WackyBush/media/Guns/blank_zpsojaf4qb7.jpg.html)
Here is a copy of a draft filled out one (these are not real Shot Speed numbers, only a draft to see if it works) Fill in information above the double line and it calculates the numbers below the double line.
(http://i589.photobucket.com/albums/ss340/WackyBush/Guns/FilledOut_zpshlbkqvzn.jpg) (http://s589.photobucket.com/user/WackyBush/media/Guns/FilledOut_zpshlbkqvzn.jpg.html)
I'm not great at spreadsheets but it's very simple. I'm not even sure if it got the FPE formula correct. Here is what I used, please correct me if I'm wrong. Average Speed x Average Speed ÷ 450,240 x Pellet Weight = FPE
Hopefully this will make it easier to compare which pellets do the best in your particular gun.
PM or email me your email address and I'll send it to you.