Project #3 - Wind Direction Chart for Bombing
Posted 27 January 2011 - 19:30
So let's make a chart for all 360 degrees and then later we'll compile it into something more useful for the fledgling bombadiers out there.
Where did my formula gurus run off to?
Posted 27 January 2011 - 19:46
Posted 27 January 2011 - 20:47
Level Bombing in Rise of Flight: A Guide
This thread is where Flashy has the PDF available for download. I think it also contains the program BeePee has already written that performs these calculations you are after if you don't want to do it mentally.
The problem I come across with this is trying to get excel to determine whether to make a correction to the left or to the right is required. Good luck Excel magicians
Posted 27 January 2011 - 21:05
Posted 27 January 2011 - 21:10
All you need do then is take note of the wind direction and speed and feed it in.
Beepees program also works well, especially as it has the speed and altitude conversion tables on as well.
Posted 27 January 2011 - 22:27
If we can figure out the Headings and Distances we can do it also for Wind directions. And by we I mean people better at math than I.
Again, I'm looking for the raw data to be worked with in some way later.
What Isay and BeePee have done are fantastic, but my requests are separate from what they have done already.
And Req you are right it is 360x360 and I do want wind direction as From not To.
Posted 27 January 2011 - 23:29
NOTE: the formula in this file is WRONG. It gives incorrect results in one section of the table.
If you downloaded it, please delete it.
Posted 28 January 2011 - 08:36
Can you send me one with the formula intact? I expand it to all 360. Maybe it got erased when I opened with Excel?
Posted 28 January 2011 - 18:04
However, you can't possibly read a compass in an airplane with a precision finer than 5 degrees, and + or - 5 degrees will still get you to your target unless you are flying enormous distances, and the little calculator will give you all the intermediate numbers if you want them… and by eyeballing the chart you can interpolate easily enough.
Sometimes less data is more useful than too much. We aren't rewriting the Chemical Rubber Handbook of Physics and Chemistry mathematical tables here.
Hold on, I just spotted an error in my calculations. Be back in a few minutes.
OK, here we go with a corrected edition. Sorry 'bout that! Haste makes waste!
wind adjustment (excel).zip 86.83KB 62 downloads
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users