Plog spreadsheet
Thread Starter
Join Date: Jan 2006
Location: Lichfield
Age: 38
Posts: 16
Likes: 0
Received 0 Likes
on
0 Posts
Plog spreadsheet
Does anyone know where I can get/find a good, easy-to-use spreadsheet for planning my flights, and also for working out the weight and balance for a C152?
TIA
TIA
Join Date: Feb 2002
Location: london uk
Posts: 373
Likes: 0
Received 0 Likes
on
0 Posts
I use a piece of A5 paper. Date at the top, plane reg and hobbs/tacho start
Then brakes off/on
field of departure/arrival
a few notes around the edge like QNH transponder etc.
Its all you need VFR. Could make a wind vector on the chart too!
As for weight and balance in a 152? you only have two seats pretty much in the area of balance(one third chord usually works) So just look at the MTOW minus the empty weight and take yours and your paessengers weight and thats it! Not a lot you can do if your pax is too light/heavy. Cant exaclty put him in the back
and before some smart R's says some 152's have a third seat, well its only for baby's, little people and Dwarfs
Please accept my appologies in advance if you are vertically challenged
Then brakes off/on
field of departure/arrival
a few notes around the edge like QNH transponder etc.
Its all you need VFR. Could make a wind vector on the chart too!
As for weight and balance in a 152? you only have two seats pretty much in the area of balance(one third chord usually works) So just look at the MTOW minus the empty weight and take yours and your paessengers weight and thats it! Not a lot you can do if your pax is too light/heavy. Cant exaclty put him in the back
and before some smart R's says some 152's have a third seat, well its only for baby's, little people and Dwarfs Please accept my appologies in advance if you are vertically challenged
Join Date: Feb 2002
Location: Dublin
Posts: 2,547
Likes: 0
Received 0 Likes
on
0 Posts
If you have Excel, you can use my plog.
You can get it by clicking here.
Nothing for you on the w&b though. Sorry.
dp
You can get it by clicking here.
Nothing for you on the w&b though. Sorry.
dp
Join Date: Sep 2006
Location: Aylesbury,Bucks
Posts: 116
Likes: 0
Received 0 Likes
on
0 Posts
I have an excell spreadsheet (http://www.the-hardings.org/the-hard...rg/vfrplan.xlt) it uses macros just adjust the gph for your plane.
Also I have a w/b for my 182 should be easy to change (go to the second page for table of the graph and enter your own CoG figures)
http://www.the-hardings.org/the-hardings.org/wb_182.xlt
Cheers
Also I have a w/b for my 182 should be easy to change (go to the second page for table of the graph and enter your own CoG figures)
http://www.the-hardings.org/the-hardings.org/wb_182.xlt
Cheers
Join Date: Sep 2002
Location: London, UK
Posts: 778
Likes: 0
Received 0 Likes
on
0 Posts
Much easier and quicker (though ultimately less flexible) than a spreadsheet, try: http://fly.dsc.net/u/Plan
Join Date: Jun 2003
Location: EuroGA.org
Posts: 13,787
Likes: 0
Received 0 Likes
on
0 Posts
This may not be the answer anticipated by the original poster, but there is a number of ways to do this.
If you use Navbox Pro - www.navbox.nl , a super VFR flight planning program which IMHO no VFR pilot should be without - then you get rapid plog generation. Just draw out your route, click on the plog item, enter the wind if you want to, and it's done in an instant.
Navbox also does W&B very nicely. You have to configure it initially for your particular plane, with the envelope corner values from the POH.
Other ways to do this are on a PDA, Palm or Pocket/PC. There are various programs. I used to keep a Palm PDA in the back of the plane with Co-Pilot on it; a Canadian freebie program which was poor for flight planning (poor database) but the W&B feature was very good. Unfortunately, as with all PDAs, the batteries are often flat when you pull them out of the bag...
I would not use Excel for a plog. Excel implies having some sort of reasonable computer, and while one is lugging that around, one may as well run Navbox on it and get the whole lot. The huge attraction of using Navbox is that its database already contains the airports and the navaids, intersections, etc. I don't see how Excel alone is going to be much good.
There are more expensive solution for flight planning, of course...
If you use Navbox Pro - www.navbox.nl , a super VFR flight planning program which IMHO no VFR pilot should be without - then you get rapid plog generation. Just draw out your route, click on the plog item, enter the wind if you want to, and it's done in an instant.
Navbox also does W&B very nicely. You have to configure it initially for your particular plane, with the envelope corner values from the POH.
Other ways to do this are on a PDA, Palm or Pocket/PC. There are various programs. I used to keep a Palm PDA in the back of the plane with Co-Pilot on it; a Canadian freebie program which was poor for flight planning (poor database) but the W&B feature was very good. Unfortunately, as with all PDAs, the batteries are often flat when you pull them out of the bag...
I would not use Excel for a plog. Excel implies having some sort of reasonable computer, and while one is lugging that around, one may as well run Navbox on it and get the whole lot. The huge attraction of using Navbox is that its database already contains the airports and the navaids, intersections, etc. I don't see how Excel alone is going to be much good.
There are more expensive solution for flight planning, of course...
Join Date: Sep 2006
Location: Aylesbury,Bucks
Posts: 116
Likes: 0
Received 0 Likes
on
0 Posts
Very nice - but does anyone know of programs for the mac?
Until then getting submerged with numerous charts,bottlang manuals and a laptop running excel is where Im at.....
I carry my laptop for stop over planning/breifing etc. before going to the airport.
Until then getting submerged with numerous charts,bottlang manuals and a laptop running excel is where Im at.....
I carry my laptop for stop over planning/breifing etc. before going to the airport.
Join Date: Feb 2002
Location: Dublin
Posts: 2,547
Likes: 0
Received 0 Likes
on
0 Posts
Excel can be quite a useful too for a plog, if the user knows a little about excel.
These days the headings and timings on my plog are just there to keep me honest in case something happens to my pda gps.....I should be able to continue without too much trouble.
But back when I was DR'ing around the country relying on my PLOG for headings and timings, I can remember a number of occasions when I read the wrong figure off the PLOG (flying speed as heading for example), simply because it's layout didn't suit me (some of these mistakes were repeated, and I needed to do something about it.) The benefit of Excel is that you can quickly change the layout of your PLOG to something that suits you.
In my case, a simple change of the format, and these mistakes instantly disappeared.
dp
These days the headings and timings on my plog are just there to keep me honest in case something happens to my pda gps.....I should be able to continue without too much trouble.
But back when I was DR'ing around the country relying on my PLOG for headings and timings, I can remember a number of occasions when I read the wrong figure off the PLOG (flying speed as heading for example), simply because it's layout didn't suit me (some of these mistakes were repeated, and I needed to do something about it.) The benefit of Excel is that you can quickly change the layout of your PLOG to something that suits you.
In my case, a simple change of the format, and these mistakes instantly disappeared.
dp
Thread Starter
Join Date: Jan 2006
Location: Lichfield
Age: 38
Posts: 16
Likes: 0
Received 0 Likes
on
0 Posts
