Homemade Ballistics Reference

[BTGuard]

So, after some fiddling on excel i was able to put together this little spreasheet that will (roughly) calculate hold for wind and distance. These numbers are for my .308 and are all generic numbers found online. The beauty of this is that as I experiment more with my gun I can tweak this spreadsheet to fit my gun exactly. It includes distances from 100-1000 yards in 25 yard increments, and in theory can calculate for any wind value. I will attach a short video of my screen while I am playing with it, as well as showing you the hidden sheet that holds the guts of the setup. Please feel free to ask any questions.

[BTGuard]

Sorry, i have to convert the format of the video. Ill post it as soon as i get that done.

[Mac...]

When at first you don't succeed.... Try try again!

[hellbndr23]

Can't load a video to the Internet, and you tried ur hand at a ballistics program?...... [emoji2] jk

[BTGuard]

Can't load a video to the Internet, and you tried ur hand at a ballistics program?...... [emoji2] jk

O haha the screen recorder downloads in .avi which TBH doesn't support... So I have to download software to switch it to a more friendly file type. My WiFi is painfully slow at home and I have class from 10-1... So if I can get it done during class I will other wise look for it at about 2 lol

[Cajun Blake]

are you shooting over a chronograph to confirm your real world velocity ?

if not, your tinkling in the wind

[BTGuard]

are you shooting over a chronograph to confirm your real world velocity ?

if not, your tinkling in the wind

O im aware! I asked for a chrono for christmas, so once real load development starts I will be able to confirm numbers and get everything really dialed in. This is more of a form then a final product.

[westtexducks]

If i sent you my email would you mind sending me your excel file? Been thinking about this for a awhile and not sure why it couldnt be done.

[BTGuard]

If i sent you my email would you mind sending me your excel file? Been thinking about this for a awhile and not sure why it couldnt be done.

Sure, shoot me a pm and I'll get it sent out this afternoon.

[BTGuard]

https://youtu.be/-1etGYoq7Xc

And here is a video! Any questions about how it works, etc. feel free to post or pm me.

[BTGuard]

Here is a picture showing how the wind angles work. The shooter is at the 6 o'clock position, with the target at the 12 o'clock position. By using the 3 and 9 o'clock position as full wind vales, you are able to calculate different angle values by multiplying the percent of effect it has on the shot. I think anyway!

[Cajun Blake]

Here is a picture showing how the wind angles work. The shooter is at the 6 o'clock position, with the target at the 12 o'clock position. By using the 3 and 9 o'clock position as full wind vales, you are able to calculate different angle values by multiplying the percent of effect it has on the shot. I think anyway!

your pie graph above

KISS

[BTGuard]

your pie graph above

KISS

While I'm normally all about kiss... I needed something excel could calculate. I'm not sure if my formula is 100% accurate, only time will tell.

[BTGuard]

your pie graph above

KISS

And why dont the 1 and 2 o'clock pictures have the poi placement below the crosshair? Wouldn't poi be lower shooting into a head wind much like the 10 and 11 o'clock ones are?

[hellbndr23]

And why dont the 1 and 2 o'clock pictures have the poi placement below the crosshair? Wouldn't poi be lower shooting into a head wind much like the 10 and 11 o'clock ones are?

And why do cross winds at 3 and 9 cause rise and fall in opposite directions and not just lateral shift? Does it have to do with bullet rotation?