As so many people across various threads have complimented my spreadsheet (once again, thank you to all of you who have expressed your gratitude, I love that sharing some of my aviation passion can have such a powerful impact on the community during these times), I was wondering what method you would like in differentiating the different registrations on my 777-9 flight testing log? Right now, I just highlighted only the registration part of N779XX's maiden flight in orange (bc it's a color that allows the font to be seen, but it stands out. Also, by not highlighting the whole row it isn't as 'annoying'). I was thinking of highlighting the other 2, N779XY/N779XZ (when they join the program), in different colors that are easy on the eyes while still standing out (maybe green and blue? Those seemed ok when I was going through the color palette) as well, while keeping N779XW, the most active 777-9, in white. Is that something that everyone would prefer? Is there another way you would like to see them differentiated?
As others have said, thank you for all this effort and the planned effort in the future. As someone that has kept databases going, simple is essential so that it is easy to keep up with when 4 or 5 planes are flying. Here are some of my suggestions, but adapt to how things work for you.
- The line number spreadsheet at some point should be separate from the flight test sheet, that allows the column widths to be sized for the normal data.
- Row 3 - narrow the column headers to fit the typical data, widen the right most column for additional notes.
- Row 4 - some data this row is wide, the static frame can just be LN9995, put the 'write off' in the notes column with dismantled.
- Col B - I would bold and use either WH001 or BOE1 as the primary identifier, by the test data do you really want to type out the LN every time. This spreadsheet tells what line number is BOE1.
-Col F - the data in this is going to be changing constantly - simpler more general locations: BFI and PAE already imply flight line, PP (pre production), PFA (prefinal assembly), FAL, Paint, and of course DEL.
-Col's - do you want first flight date and delivery date?
-the flight test spreadsheet
- Date in simple mm/dd/yr, pick the same as where you are getting the date from or that you like: 05MAY20, MM-DD-YY, OR DD-MM-YY depending on your own preference, but the column can be half the width.
- Drop the registration #, just use BOE1 callout.
- Sort the columns to match your source info, much faster entry.
- Add remarks column - Like today would be "broke 400 knots", FL35 or similar info.
- Every month do a banner line "June 2020 Flight Test"
You would probably see the same in a few weeks but then it is a lot of work to move around.
With the flight test data having the BOE1 column, the data can be worked and divided out or sorted after entry. Multiple spreadsheets is more work.
This looks quite promising.