Tuesday, March 22, 2011

Today's Camp Perry Wind

This should update every day. Yes, I'm a big nerd. I found out you could get weather XML data out of Wunderground, and into a Excel or a Google spreadsheet. Google spreadsheets will let you share easily, but I can't make it do a 'wind rose.' You kind of need a pivot table/chart to do that. Easy in Excel, but not Google docs.
For your entertainment, the spreadsheet is below.

The chart is the right windage in MOA one should have to put on one's sights shooting 69gr. SMKs at Perry. The weather xml gives wind direction in degrees. Just take the TAN wind direction in radians, and it gives you the wind percentage. Multiply by windspeed, and you get the effective cross-wind speed. From there, it's proportional.


No comments: