Plog spreadsheet

Joined: Feb 2002
Posts: 375
Likes: 0
From: london uk
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 DwarfsJoined: Feb 2002
Posts: 2,547
Likes: 0
From: Dublin
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
Joined: Sep 2006
Posts: 116
Likes: 0
From: Aylesbury,Bucks
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
Joined: Sep 2002
Posts: 778
Likes: 0
From: London, UK
Much easier and quicker (though ultimately less flexible) than a spreadsheet, try: http://fly.dsc.net/u/Plan

Joined: Jun 2003
Posts: 13,787
Likes: 0
From: EuroGA.org
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...
Joined: Sep 2006
Posts: 116
Likes: 0
From: Aylesbury,Bucks
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.
Joined: Feb 2002
Posts: 2,547
Likes: 0
From: Dublin
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
Joined: Jan 2006
Posts: 16
Likes: 0
From: Lichfield




