There's been a lot of chatter about viewing the spreadsheets. In the past I've been embedding the sheets in my posts (not all of the posts though). I'm going to continue to embed them in most of my posts but I'm also going to add a web link.
If it proves to be popular I may discontinue to embed them and just use a web link. I'm trying to see if there is a way I can add the ability for viewers to filter the spreadsheets but not edit or alter the information (I need to keep control over that process, I'm kinda of a control freak that way). If someone knows how to add the filtering capabilities to published sheets, I appreciate if you would let me know.
Here are the web links for the more popular sheets:
Full 787 List
Current 787 Production List
Delivered 787 List
787 Monthly Delivery Tracking
787 Customer Delivery
I hope it makes the blog more enjoyable.
Uresh
separate spreadsheets are great !!
ReplyDeleteThis is much better.
ReplyDeleteGood move.
Check out my 747-8 spreadsheet. I use filtering and sorting for a number of things, sort by delivery, sort by airline, and all I have to do is update the first tab. The one thing google docs doesn't do is keep cell color, so I have to do that manually. If you like I can share the formulas i use. It's literally just one formula entry into the top left cell for each of the "sort by" pages
ReplyDeleteI recently started adding links to flight trackers and fleet information as well, which is great for tracking the utilization and history of each frame.
747-8 Report
747-8 Spreadsheet
Thanks, for now I want to add the ability for people to filter. How do I activate that ability?
ReplyDeleteIts much better. Specially for my ipad.tks
ReplyDeleteIts much better. Specially for my ipad.tks
ReplyDeleteIn the BBJ tab, I filter each column I want to pull from the Production tab with something like this:
ReplyDelete=filter(Production!A:A; Production!F:F="BBJ")
which means copy column 'A' in production to this column for each entry where column 'F' matches "BBJ". Unfortunately this is all static so the user can't dynamically create their own filter, if that's what you're looking for.
All now work on iPad. Big improvement. Thanks
ReplyDeleteHaroldEJr
Huge improvement on the iPad thanks !
ReplyDeleteIts great, if you are on chrome just pin the tabs with you're favorite spreadsheets and you get quick easy access to them
ReplyDeleteI like this, but do both. Otherwise new readers won't know how informative the lists are. Oh, by both, mostly do links, but at least once per week embed the spreadsheets. Just my twocents.
ReplyDeleteThanks for doing this great work!
Neil/Lightsaber from a.net
Uresh, do you have any idea when Hainan will start taking planes?
ReplyDeleteNext week
ReplyDeleteAnyone with knowledge about why the LN20+21 are taking forever to finish off change incorporation? They have been worked on since last summer..
ReplyDeleteWhat is the estimate of delvivered EMC frames this year?
I agree the sheets are great. They could be even better if could have the open in a new window automatically.
ReplyDeleteKudos, I have been for a while pulling the google doc link out of the page source to examine the large sheet. I'm glad you now have links. The big sheet not embedded is so much easier to use. Much cleaner!
ReplyDeleteBoeing expects to deliver 9 frames that have underwent change incorporation this year. So far they delivered 1.
ReplyDeleteMuch better, the embedded spreadsheets crash my ipod
ReplyDeleteExcellent ideas!
ReplyDeleteMuch better. Loads so much quicker on mobile
ReplyDeleteSo the first British Airways plane has been delivered? I thought delivery was on the 26th. (Does "delivered" here just mean it has left the Boeing plant and is flying to LHR for delivery there tomorrow?)
ReplyDeleteDelivery is defined when the airlines receives the aircraft and pays for it. Not actual flyaway by the customer which may or may not occur on the same day.
ReplyDeleteI see. Thanks for the response.
ReplyDeleteHey Uresh
ReplyDeleteCan you confirm at all if the first 787-9 ZB001 will be going to Air NZ? Down here in nz i keep hearing reports from media and some trade that this is the case,however im wouldnt completely trust them,
Thanks for all your efforts on this blog
Links to the spreadsheets are great. Easier than trying to scroll back and forth in the embedded version.
ReplyDeleteIt would be good to add an entry in the sheets the show when you last updated them so we know how current the information is.
I like the separate spreadsheets, easier to see for me. Thanks as always for your great work!
ReplyDeleteI like them both ways, but agree that the link alleviates the bother of troublesome scrolling.
ReplyDeleteLooks like one of the BA planes has relocated to its new home.
ReplyDeletehttp://flightaware.com/live/flight/BAW787/history/20130627/0115Z/KPAE/EGLL
Am I reading this right? From the xls it appears there has not been a single first flight in nearly two weeks. With 25 frames in "pre-flight prep", it seems to be at odds with them rushing to get these planes to their owners. I can see all the B-2, and C-n flights happening so they are doing something, but one would think from a flow perspective they should have gotten several B-1's in during 13 days.
ReplyDeleteEnd of the quarter, if it will not be delivered before the first, they are not putting work into it. I would expect several B-1's after the first.
ReplyDeleteGreat job on this blog! Just curious - on your monthly delivery tracking spreadsheet, the last row of tables 1 and 3, "Undelivered" doesn't seem to be updated to reflect new orders this year. Am I mis-interpreting what those numbers mean?
ReplyDeleteKeep up the great work!
It's working fine.
DeleteJust caught Hainan's aircraft coming into Columbia from Charleston on video. Anyway to post here?
ReplyDeleteYou can post a link in the comments. Thanks for sharing!
ReplyDeleteOkay I can't see to find a link function on here or maybe my blog skills need fine tuning:) It is a cell phone video link. I can E-mail it to someone with more skills than I to post if needed.
ReplyDeleteDoes anyone know what the technical issues with the following are
ReplyDeletea ba dreamliner delivery flight delayed due technicalissue
b the thomson tuib issue in ireland
c the issue with a japanese 787 today with the airconditioning fault
My first sighting of a 787 coming in to Columbia from Charleston. Beautiful aircraft proudly made in SC! Sorry about the low quality. Change the settings to 480P.
ReplyDeletehttps://www.youtube.com/watch?v=mnCsakV0RxU
BA took delivery, so no problem there.
ReplyDeleteThomson was a bird strike
http://www.airliners.net/aviation-forums/general_aviation/read.main/5801175/
On the ANA problem
http://news.airwise.com/story/view/1372336968.html
Pics of Norwegian's first delivery over here:
ReplyDeletehttp://747-8.blogspot.com/
Looks like the second British Airways plane is on its way to LHR.
ReplyDeletehttp://flightaware.com/live/flight/BAW787
line 3 za003 N787BX has been stored at moses lake (KMWH) without engines for almost a year now.
ReplyDeletehttp://www.flickr.com/photos/royalscottking/9069930509/
http://flightaware.com/live/flight/N787BX
With the 34 planes (Pre-flight Prep 25, Production testing - 7, ready for delivery - 2) at these stages, Boeing should have a VERY busy July ands August delivery schedule.
ReplyDelete