![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
I'm working on an Excel spreadsheet to do flight planning using formulas
from Ed Williams site: http://williams.best.vwh.net/avform.htm Basically, it will duplicate what I used to do with an E6B and a paper form. The log is set up so that all the information needed in flight is on one half of an 8 1/2 x 11 sheet with the input data on the other half. You can then fold it in half and have the rest of a clipboard size kneeboard available for other stuff. I like putting in the distance, course data, etc. well ahead of time and then plugging in the weather information just before I go. Driving the Sporty's E6B through it all is just too much work now that I'm no longer a student and don't have to show my work to anyone. This spreadsheet should make it easier. (Yeah, I know there are all sorts of flight planners out there but I'm a tightwad. Besides, I like simple, homebrew stuff that I can set up the way I want.) I've got good agreement between the spreadsheet and the E6B on heading but a few percent disagreement on ground speed. I haven't done a complete hand verification yet but the spreadsheet actually looks more accurate. When there is an exact headwind, the spreadsheet give the right answer while the E6B is off a couple knots. Does the Sporty's E6B use some approximations? If anyone who is a wiz with formulas and Excel would like to take a look at this, I'd appreciate it. Anyone who wants, to play with it, further develop it, use it, whatever, feel free to download the in-progress file at: http://home.maine.rr.com/rlma/Flightplan.xls Strictly as-is, use at own risk, public domain. Just let me know if you have any corrections, ideas, or comments. -- Roger Long |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
AOPA Stall/Spin Study -- Stowell's Review (8,000 words) | Rich Stowell | Aerobatics | 28 | January 2nd 09 02:26 PM |
Want simple flight planning software | marc | Home Built | 13 | December 20th 04 04:36 AM |
Logging approaches | Ron Garrison | Instrument Flight Rules | 109 | March 2nd 04 05:54 PM |
us air force us air force academy us air force bases air force museum us us air force rank us air force reserve adfunk | Jehad Internet | Military Aviation | 0 | February 7th 04 04:24 AM |
"I Want To FLY!"-(Youth) My store to raise funds for flying lessons | Curtl33 | General Aviation | 7 | January 9th 04 11:35 PM |