TODAY IS
RC Aircraft Flight Log-Macro Enabled Excel Workbook
January 1, 2021-Version 1.8
The purpose of this program was to give some data analysis feel of our equipment and aircraft: what we are flying, how often, performance notes, and even some weather observations. I knew I was driving to the field frequently, but, until I started tracking the actual flying times, I was unaware that I made a trip to our club flying field almost every 3 days. So far this year, from January to December 2020, I have made over 800 flights over 108 days in the first 310 days of the year. I have found some of my batteries and planes to be absolute workhorses, while others have shown great disappointment.
The workbook itself is not that complicated. It has many formulas and macros to do the heavy lifting, while simplifying the data collection. Use of the macros ensures accurate labeling of data, so that the counting of time and flights per battery or aircraft is also accurate.
Below are a couple of screenshots of the program and a link to download the workbook . It is freeware; no license nor password is required to operate, except when starting a new year. The password was necessary to keep me from in advertently clearing out the old data. You actually have to do a little extra work to start a new workbook, but that's for next year. If you feel like modifying the program, feel free. Macros are not hidden and can easily be tweaked, One caveat, I made the most flights this year in October, 116. That happened to be the maximum number of flights per month allowed in the program. That can be modified if you have some experience with Excel, but if not, and you are one of those who fly every chance you get, I'd suggest multiple workbooks. If you have more than 49 batteries for your planes, you can group planes and batteries in separate workbooks.
NEW in Version 1.8. Battery and Aircraft usage reports.
Hardware and Software Requirements:
This program (workbook) was developed with Microsoft Excel on a Windows 10 PC. I do not know if it will work on a Mac with Microsoft Office installed.
Hard drive requirements are minimal, but you will need a copy of Excel to run the Flight Log. I think the best option is the annual subscription to Office 365, but you can download a free trial of Excel and see how the program works.
Below are some screen shots of the Flight Log
Hard drive requirements are minimal, but you will need a copy of Excel to run the Flight Log. I think the best option is the annual subscription to Office 365, but you can download a free trial of Excel and see how the program works.
1. Title page. Used to print a cover page for the written flight logs.
6. Data entry form for individual flights: battery information. flight time, and notes about the flight
5. Data entry form for Aircraft