DVD-BOY wrote: Do we know at what points the reel changes occur?

Yes, Mallwalker figured them out earlier (see his reel thread), using math and analysis of the orchestra segments, but we are also confirming the locations by finding pics of them: http://fd.noneinc.com/Reel_Changes/Reel_Changes.html

So with each scene, you restart the numbering of shots, how does the sub-shot lettering work? I get 97A, But AA ZB etc I don't follow.

The Shot/Sub/Scene values were my initial idea for connecting the shot list with other production information like storyboards. The values were lifted from a production script. (it's listed at the top of the spreadsheet) So for SW used: http://starwarz.com/starkiller/2010/03/star-wars-the-adventures-of-luke-starkiller-revised-fourth-draft/

But with any of these scripts there are issues which affect the numbers and until more time is spent documenting pre-production artwork this is all a little nebulous.

As we migrate towards a wiki presentation, the columns on the far right are probably a better place to start. They are just a sequential counting of the scenes. There will be some flux, once the existing spreadsheet is incorporated with the GOUT frame data provided by negative1. One spot where we differed was early on negative1 broke out the pauses between Fox Logo and Lucasfilm Logo. I hadn't but will revise to his methodology, these should be very few.

If you look at the other movies you'll see I gave up mostly on the Shot/Sub/Scene data. If there was a definitive number in the script then it's in the spreadsheet, but otherwise didn't go much further with those columns. The 97A is completely my made up designation.

For those into the Shot/Sub/Scene info from the scripts, it does inform you of how they juggled scenes during production.

Hopefully there's some easy spreadsheet to wiki conversion, haven't looked for it yet, but will eventually if no one else finds anything.