Print Pilot Logbook

Print 2 double-sided pages at a time
Written by Max
Updated 1 month ago
The Print tab is a new feature added into Versions 4.0 (released circa July 2021) and newer. It allows you to print 2 double-sided pages at a time.

For users with older versions, please see How Updates work.

Overview

On the PRINT tab, there are 3-4 sheets. 

When START PAGE is set to Page 1, it will display #VALUE! or #NUM! or there will be no flights displayed on "Page 0b"  - this is normal.

Your first logbook entry will be found on Page 1a - this first page should be the only page you print that is single-sided (do not print Page 0).

  1. On the first piece of A4 paper that you print, select "single-sided" with Page 1a only.
  2. On the second piece of A4 paper that you print, select "double-sided" with Page 1b on the front and Page 2a on the back.
  3. Change the START PAGE number accordingly and continue printing "double-sided" for subsequent pages.

Can I Print my whole Logbook at once?

Unfortunately, not. If this was the case, the Excel Pilot Logbook file size would be astronomical, as it would require unique formulas for over 200+ pages. Once you've initially printed your logbook, moving forward, printing the latest 2 pages at a time is easy.

Microsoft Excel

In Excel, the required Print settings should be setup, by default.
  1. Enter which page number you would like to populate in the red box "START PAGE"
  2. File -> "Print..."
If you are having difficulties determining the Print Area. Select: Menu -> "View" -> "Page Break Preview".

This will allow you to see which areas of the sheet will be printed. The Horizontal and Vertical Blue lines indicate the content which will be printed on each Page. You can click and drag the Blue lines to the correct Page break (in between the pages) if they are out of alignment.

Google Sheets

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

Google Sheets: Print Settings

  • Paper Size: Letter (or as required)
  • Scale: Fit to Page Breaks
  • Margins: Normal (or as required)
  • Select "Custom Page Breaks" then "Edit
  • The dotted blue lines indicate the Custom Page Breaks. Move the Horizontal Page Break to below "Page 0b of #" (the bottom of the first page). Move the Vertical Page Break to the far right (where the logbook ends). Repeat this step for all 4 Pages. Note: There should be no Vertical or Horizontal lines within each Page.

Common Errors

"Total pages" to Print incorrect

  • 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. So if you have multiple blank rows, then the total will not be correct. Rest assured this won't affect the format of the Printed pages.

More than 3-4 pages to be Printed?

Are there dozens or even hundreds of Pages to be printed instead of the default, 3-4?

  • Delete any additional Columns to the right of the Logbook pages.
  • Delete any additional Rows below the Logbook pages (there may be blank rows up to row #1000 in Google Sheets)

No data showing up at all

  • "Start Page" must be set to a numerical number only. E.g. "1" not "1a".
Customisations: unfortunately any customisations to the Logbook or Dashboard page will not carry over to the Print Page and will create mis-alignments with formulas. Please do not make any customisations for the Print page to work as described.
Did this answer your question?