Range Report Generic Wind Chart Spreadsheet

[Lindy]

A poster asked how to produce a wind chart I use. That chart is shown below. It's specific to one load in one of my rifles. The data in the chart cells is wind hold in mils.

If you want to produce a chart for your load under a specific set of conditions, you must set up a ballistic program for your load. It doesn't matter what the ballistic program is. Set that program up to calculate the wind holds for a 10 mph full-value (90 degree) wind.

Then download the Excel spreadsheet linked below. Open the spreadsheet, and fill in the values for the 10 mph wind hold at ranges from 100 to 1100 yards or meters - whatever you set the ballistic program up for - in the indicated cells below the range labels. It doesn't matter whether the holds are in mils, MOA, or IPHY.

Feel free to experiment with formatting the output to suit your preferences, then print it. Alternately, if you have a current version of Excel, you can export the output as a PDF file. You can also copy it by hand onto whatever suits your fancy.

This is not a sophisticed spreadsheet. I am sure that Excel gurus can do something much fancier. It won't change the nature of the data, though. I am married to a CPA, and one rule of CPAs is <span style="font-style: italic">never</span> to trust pretty data, under the assumption that people who spent the time to make output pretty are probably doing so to hide bogus numbers...

Here's the spreadsheet - it's in Excel 97-2003 format:

Generic Excel Windchart

Cheers!
-- Lindy

 

[DaveV]

Re: Generic Wind Chart Spreadsheet

Thanks for the resource, Lindy.

 

[MTETM]

Re: Generic Wind Chart Spreadsheet

Thanks Lindy,
That just saved me lots of time, now I don't have to make one.

 

[kraigWY]

Re: Generic Wind Chart Spreadsheet

Nice,

BUT: For us dudes that shoot high power with iron sights, how can I convert it to MOA?

My old Math Challenged mind, cant do the figuring that fast in my head, converting mills to half min clicks.

OOOPS:, sorry I just re-read the instructions.

Thanks

 

[Doc1911]

Re: Generic Wind Chart Spreadsheet

This looks GREAT. Thanks for the resource.

 

[JSTARSZ]

Re: Generic Wind Chart Spreadsheet

Lindy, I want to tell you thanks a lot for the spreadsheet. it made me go into JBM and really do some ballistic work. I am getting ready to go to my first UKD range in a month and this has really helped me start to prepare for the course.

 

[Lindy]

Re: Generic Wind Chart Spreadsheet

You're welcome - I'm glad you found that useful. Whatever makes us think about what we are doing enhances our learning experience.