gropf.blogg.se - Excell pilot logbook

I still keep that logbook up, in addition to, and also in addition to a paper log. I do have a "dividing line/border" every 13 entries though, like the logbook pages.) (I highlight the appropriate entries and look at the total it calculates at the bottom of the screen. I can see where having your logbook add up the times for each page automatically would be nice. Looks very similar to yours, except no division of pages. I have been using a similar excel logbook since about 1995, also based on the Jeppesen logbook. Printing double-sided, rear page is up-side down "Start Page" must be set to a numerical number only.Delete any additional Rows below the Logbook pages (there may be blank rows up to row #1000 in Google Sheets).Delete any additional Columns to the right of the Logbook pages.Rest assured this won't affect the format of the Printed pages.Īre there dozens or even hundreds of Pages to be printed instead of the default, 3-4? So if you have multiple blank rows, then the total will not be correct. This formula calculates the total number of entries you have in your Logbook Entries page (and divides by 23 entries), but it does not take into account any blank rows you may have.Note: There should be no Vertical or Horizontal lines within each Page.Ĭommon Errors "Total pages" to Print incorrect Move the Vertical Page Break to the far right (where the logbook ends).

Move the Horizontal Page Break to below "b of #" (the bottom of the first page).

The dotted blue lines indicate the Custom Page Breaks.

Select " Custom Page Breaks " then " Edit".

Highlight Rows 1-2, right click and select "Hide" (hide the "Start Page" settings, so that they don't print).

You can click and drag the Blue lines to the correct Page break (in between the pages) if they are out of alignment. The Horizontal and Vertical Blue lines indicate the content which will be printed on each Page. This will allow you to see which areas of the sheet will be printed. Select: Menu -> "View" -> " Page Break Preview". If you are having difficulties determining the Print Area.