Excel logbook
#1
Excel logbook
Everyone,
I got this idea from Pilot41.
I was reading the thread about an excel logbook and I started looking online because I wanted to have an electronic logbook as a backup where I could easily keep all my hours logged and have the totals added for me worry free as well as be able to recieve yearly/monthly averages. Another perk is that every so often you could burn the document onto a disk and keep it in a safe place as a backup.
This is a very rough copy and it took me only about 30 minutes to complete the numbers and times and everything in there is purely factual to test the columns
here are some of the features
It adds up all of your totals for you and then adds the column totals and the brought forward totals to tell you your comulative total to date
It gives you plenty of space to type what you need but when you print it, it fits the whole document to one page to simplify things
It has columns for most everything I can think of for the professional pilot
It is not intended for every pilot but is easily modified..ie substitute complex or high performance which is not really needed for turbine , >12,000, FE, etc or those columns can just be added
My intention with this posting is for you all to take a look at it for those who care and are excel savvy and make your changes or edits to improve it and let others know what you did. Hopefully after a few changes and modifications we will all (those who want it) have a good working excel logbook that cost nothing but a few minutes of our time
A few things that I will work on...is find a way to make the font a little easier to read when you print it out, when it shrinks it to one page for printing the font gets fairly small, but a good downfall I feel for being able to keep it one page.
Also I will add ways to average monthly totals and yearly totals by category and class etc
I will also add more pages and have the feature of brought forward automatic from page to page so you will not have to enter anything in the totals columns. I have no current need to add more pages but I will in the future if I get more time.
**EDIT NEW ATTACHMENT IS BELOW ON POST 2**
I got this idea from Pilot41.
I was reading the thread about an excel logbook and I started looking online because I wanted to have an electronic logbook as a backup where I could easily keep all my hours logged and have the totals added for me worry free as well as be able to recieve yearly/monthly averages. Another perk is that every so often you could burn the document onto a disk and keep it in a safe place as a backup.
This is a very rough copy and it took me only about 30 minutes to complete the numbers and times and everything in there is purely factual to test the columns
here are some of the features
It adds up all of your totals for you and then adds the column totals and the brought forward totals to tell you your comulative total to date
It gives you plenty of space to type what you need but when you print it, it fits the whole document to one page to simplify things
It has columns for most everything I can think of for the professional pilot
It is not intended for every pilot but is easily modified..ie substitute complex or high performance which is not really needed for turbine , >12,000, FE, etc or those columns can just be added
My intention with this posting is for you all to take a look at it for those who care and are excel savvy and make your changes or edits to improve it and let others know what you did. Hopefully after a few changes and modifications we will all (those who want it) have a good working excel logbook that cost nothing but a few minutes of our time
A few things that I will work on...is find a way to make the font a little easier to read when you print it out, when it shrinks it to one page for printing the font gets fairly small, but a good downfall I feel for being able to keep it one page.
Also I will add ways to average monthly totals and yearly totals by category and class etc
I will also add more pages and have the feature of brought forward automatic from page to page so you will not have to enter anything in the totals columns. I have no current need to add more pages but I will in the future if I get more time.
**EDIT NEW ATTACHMENT IS BELOW ON POST 2**
Last edited by usmc-sgt; 07-27-2006 at 04:06 PM.
#2
New and improved
New and improved!
Added two more pages so it keeps running totals on its own now
Also fixed the brought forward so that it will enter the appropriate data for you as I wanted it to do earlier
To add new pages just copy an entire page and then paste that page in the cell where you want the new page to start (Example A302 for the next page)
formulas should automatically adjust for you
A bug I have found is sometime when you add a new page columns X and Y the dual received and as instructor tries to add to itself you have to change the X99 to X98 in the formula to fix that
I was thinking of making a column that shows total IFR as well as having the simulated and the actual IFR but I am not sure if that is necessary
MAN IT IS BORING AT 4:03am....I am usually actually working...honest
Added two more pages so it keeps running totals on its own now
Also fixed the brought forward so that it will enter the appropriate data for you as I wanted it to do earlier
To add new pages just copy an entire page and then paste that page in the cell where you want the new page to start (Example A302 for the next page)
formulas should automatically adjust for you
A bug I have found is sometime when you add a new page columns X and Y the dual received and as instructor tries to add to itself you have to change the X99 to X98 in the formula to fix that
I was thinking of making a column that shows total IFR as well as having the simulated and the actual IFR but I am not sure if that is necessary
MAN IT IS BORING AT 4:03am....I am usually actually working...honest
Thread
Thread Starter
Forum
Replies
Last Post