Electronic Flying Logbook - FAQ

Is there an Excel version?

No. LibreOffice/OpenOffice.org Calc is free and hard-disk space is cheap so please consider installing it. If you are unable to do that, you have the following options:

Use the Open Document import filter, which comes with newer versions of Excel.
Download the Open XML/ODF Translator Add-Ins for Office to open/convert the spreadsheet.
Find a friend who has Calc installed on his computer and ask him to save the spreadsheet as Microsoft Excel file.

None of these conversion methods is perfect. It is very likely that some of the formulas and graphs are corrupted. Do not rely on the statistics calculations of a converted document unless you have checked everything very carefully.

I have entered a lot of flights, and the last ones do not show up in the statistics.

To keep calculation time short, the number of processed database entries is limited to 500. If you have more entries than that, increase the limits on the 'Misc' worksheet. The higher the limit, the longer it takes to update results. For large databases, you may want to turn off automatic updating in Tools → Cell Contents → Auto Calculate. You then have to press the 'F9' key to recalculate everything.

The spreadsheet feels very sluggish.

See above. For large databases and/or slow computers, you may want to turn off automatic updating in Tools → Cell Contents → Auto Calculate. You then have to press the 'F9' key to recalculate everything.

The document is protected - does that prevent me from making changes?

You can still change anything you want! All worksheets are protected to prevent unintentional changes to formulas. If you know what you are doing and want to make modifications, simply unprotect each sheet (Tools → Protect Document → Sheet). Remember to turn on protection after you have finished. Please understand that I am unable to provide any support for modified spreadsheets.

I have made some changes and they totally messed up the calculations. What shall I do?

Download the spreadsheet again from this website and copy and paste your data from your old document.

I have downloaded the logbook version ≥v2.6 and all fields in the statistics show '#NAME?'.

This is a bug in LibreOffice Calc 3.4.4 and some older versions with logbook releases v2.6 onwards, which use named cell ranges. Please use LibreOffice Calc 3.5.2 or newer. If you can not upgrade, you may use the older logbook release v2.5 with fixed database ranges.