On my way to a DIY "ballistics" calculator.. sort of. :)

WWWJD · May 12, 2011, 10:02 PM

I always like trying new stuff in Excel, work or pleasure; anyway, tonight was a quiet night, so I dug in. Using Federal's basic information for the .308 Gold Medal Match, I set up a curve fit calculation, and now I can plug in target height, Observed target height in MILS, get a range, and the calculated hold-over. I thought it was pretty sweet. It's accurate plus/minus 1" out to 500.

Of course, I'll actually have to go out and shoot these ranges to get real numbers, but all in all, it was pretty satisfying to see this work (so well).

Dr_Rich · May 14, 2011, 06:33 PM

I stopped reading after I saw the red/yellow/green dots.

I'm kidding. Sweet spread sheet man.

Eghad · May 23, 2011, 11:02 PM

Winchester Ammo has a ballistics application on line that can be downloaded for use with the I phone.

I have seen a ballistics caculator from Nikon also.

As you say Excel is your friend too

May 12, 2011, 10:02 PM	#1
WWWJD Senior Member Join Date: February 9, 2011 Location: Central KY Posts: 552	On my way to a DIY "ballistics" calculator.. sort of. :) I always like trying new stuff in Excel, work or pleasure; anyway, tonight was a quiet night, so I dug in. Using Federal's basic information for the .308 Gold Medal Match, I set up a curve fit calculation, and now I can plug in target height, Observed target height in MILS, get a range, and the calculated hold-over. I thought it was pretty sweet. It's accurate plus/minus 1" out to 500. Of course, I'll actually have to go out and shoot these ranges to get real numbers, but all in all, it was pretty satisfying to see this work (so well). __________________ *~Mark* NRA Endowment FTW

May 23, 2011, 11:02 PM	#3
Eghad Senior Member Join Date: May 28, 2005 Location: Texas Posts: 6,231	Winchester Ammo has a ballistics application on line that can be downloaded for use with the I phone. I have seen a ballistics caculator from Nikon also. As you say Excel is your friend too __________________ Have a nice day at the range NRA Life Member

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

May 14, 2011, 06:33 PM	#2
Dr_Rich Senior Member Join Date: February 15, 2011 Location: Gods waiting room. Posts: 103	I stopped reading after I saw the red/yellow/green dots. I'm kidding. Sweet spread sheet man.