Simple EXCEL calculator

[bdzjlz]

Based upon a forum exchange yesterday from various members, I created the attached simple spread sheet to (a) calculate the required pellet speed to achieve a certain level of energy from a pellet with a known weight, or (b) calculate the resulting FPE with a pellet of a known weight traveling at a known speed.

View attachment Ballistics Calculator.DZ.1617538714.xlsx

 

[B7B]

Thank you, Sir!

 

[FelixS]

Nice one, thanks!



Sorry, my OCD...

 

[dgeesaman]

Ha, I just ran those calculations for 20fpe for several common pellet weights. But it only took a moment for me to guess my way into an fps because I was too lazy to do the algebra.