Saturday, June 22, 2013

787 spreadsheets

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

41 comments:

Ralph Walker said...

separate spreadsheets are great !!

graeme77 said...

This is much better.
Good move.

TurtleLuv said...

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

I 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

Uresh said...

Thanks, for now I want to add the ability for people to filter. How do I activate that ability?

LEONARDO SG said...

Its much better. Specially for my ipad.tks

TurtleLuv said...

In the BBJ tab, I filter each column I want to pull from the Production tab with something like this:

=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.

Harold E Jr said...

All now work on iPad. Big improvement. Thanks
HaroldEJr

Chris Turnbull said...

Huge improvement on the iPad thanks !

Andrew Munsell said...

Its great, if you are on chrome just pin the tabs with you're favorite spreadsheets and you get quick easy access to them

wannabuy said...

I 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.

Thanks for doing this great work!
Neil/Lightsaber from a.net

Rob said...

Uresh, do you have any idea when Hainan will start taking planes?

Uresh said...

Next week

entrophian said...

Anyone with knowledge about why the LN20+21 are taking forever to finish off change incorporation? They have been worked on since last summer..

What is the estimate of delvivered EMC frames this year?

FL Phil said...

I agree the sheets are great. They could be even better if could have the open in a new window automatically.

Kevin Flanagan said...

Kudos, 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!

Uresh said...

Boeing expects to deliver 9 frames that have underwent change incorporation this year. So far they delivered 1.

Mcass777 said...

Much better, the embedded spreadsheets crash my ipod

Cedarglen said...

Excellent ideas!

harty236 said...

Much better. Loads so much quicker on mobile

Alumino said...

So 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?)

Uresh said...

Delivery 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.

Alumino said...

I see. Thanks for the response.

nskiwi said...

Hey Uresh
Can 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

dynamicsguy said...

Links to the spreadsheets are great. Easier than trying to scroll back and forth in the embedded version.

It 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.

Don said...

I like the separate spreadsheets, easier to see for me. Thanks as always for your great work!

TravelingMan said...

I like them both ways, but agree that the link alleviates the bother of troublesome scrolling.

Alumino said...

Looks like one of the BA planes has relocated to its new home.

http://flightaware.com/live/flight/BAW787/history/20130627/0115Z/KPAE/EGLL

Daetrin said...

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.

Kevin Flanagan said...

End 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.

Nick Johnson said...

Great 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?

Keep up the great work!

Coleman76 said...

Just caught Hainan's aircraft coming into Columbia from Charleston on video. Anyway to post here?

Uresh said...

It's working fine.

Uresh said...

You can post a link in the comments. Thanks for sharing!

Coleman76 said...

Okay 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.

David Cummings said...

Does anyone know what the technical issues with the following are

a 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

Coleman76 said...

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.

https://www.youtube.com/watch?v=mnCsakV0RxU

agincourt said...

BA took delivery, so no problem there.

Thomson 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

TurtleLuv said...

Pics of Norwegian's first delivery over here:

http://747-8.blogspot.com/

Alumino said...

Looks like the second British Airways plane is on its way to LHR.

http://flightaware.com/live/flight/BAW787

TurtleLuv said...

line 3 za003 N787BX has been stored at moses lake (KMWH) without engines for almost a year now.

http://www.flickr.com/photos/royalscottking/9069930509/

http://flightaware.com/live/flight/N787BX

1coolguy1 said...

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.