A aviation & planes forum. AviationBanter

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.

Go Back   Home » AviationBanter forum » rec.aviation newsgroups » Piloting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Flight planning spreadsheet



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old August 5th 03, 12:53 AM
Roger Long
external usenet poster
 
Posts: n/a
Default Flight planning spreadsheet

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
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


All times are GMT +1. The time now is 10:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 AviationBanter.
The comments are property of their posters.