In order to enhance the information that I present on my spreadsheet, I'm attempting to track the certain metrics to help understand how the 787 program is doing. It all has to do with time and the amount of it that the 787 spends on being assembled, tested and finally delivered to customers. I'm tracking the time the aircraft spends in final assembly, the time it spends in pre-flight and the amount of time in production flight tests.
Unfortunately I don't have all the information that I need for all the aircraft particularly the dates that the aircraft loads into final assembly and the date that the aircraft exits final assembly. If there was traveled work or time needed for change incorporation, that is lumped into the pre-flight time....it's easier that way instead of trying to track when each airframe is where at a particular point in time.
If anyone has any information they can share, it is appreciated. Please check out the spreadsheet below and you'll see which information I am missing.
Full 787 List