logo Sign In

Post #543208

Author
none
Parent topic
Shot List Spreadsheet - v0.6.05 - 6 films - Multiple SW Audio Mix Changes Added Recently
Link to post in topic
https://originaltrilogy.com/post/id/543208/action/topic#543208
Date created
3-Oct-2011, 5:43 PM

This is a thread for discussion of spreadsheets which list every shot in the Star Wars movies.  After each shot gets listed, additional information can be added.  For example: script pieces, duration/length, Special Edition changes, etc.

Currently working on: **First Pass ALL Films Complete

ShotList-StarWars-v0.6.05 :
https://docs.google.com/spreadsheets/d/1H0eg40PEY3B7zF-dL6H41ntBRlp4gZo3V3pAjkgcTR0/edit?usp=sharing

Not sure how this public version will work out.  But feel free to save your own copy and make changes.  If you do make a change, let me know, so I can incorporate it into a backup version.  As this is public, it might get corrupted so might periodically revert it back to it’s original state.  I guess if anyone reading does make a change, maybe change the border so it <span style=“text-decoration: underline;”>STANDS OUT</span>.  This will make it easier to find when I do a review.

Current Progress :

Ver.0.6.05: Added Audio Changes for 2004, 2011 and 2019 mixes. Additional visual changes from DIF review.

Ver.0.6.04: Added Audio Changes for 77 70mm, 1985 & 1993 mixes.

Ver.0.6.03: Added Audio Changes between 77 Stereo and 1997 SE.

Ver.0.6.02: Added changes in the 35mm Mono Mix.

Ver.0.6.01: Added 2019 changes. Findings from Forums and DIF Review.

Ver.0.5.05: Completed RotJ SE analysis.

Ver.0.5.00: Completed RotS first pass and incorporated some of the 2005 and 2011 changes.

Ver.0.4.00: Completed AotC first pass and incorporated some of the 2002 and 2011 changes.

Ver.0.3.03: Completed TPM first pass and incorporated some of the 2001 and 2011 changes.

Ver.0.2.08: Completed initial ESB set up.  ESB 80 ended up around 1804 shots, which jumps to 1826 for the Special Editions.  More shots were modified for the SE but to a lesser extent.

Ver.0.2.08: First pass thru RotJ yield about 2105 shots.  Thru a Wall Street Journal Article, Star Wars is confirmed as 2,228 shots.  (Shot Spreadshit is missing two.)  Also from that article is mention that 748 shots were redone in various ways.

Ver.0.2.06: First pass thru Empire yields about 1850 shots.

Ver.0.2.05: Added the script number for the other 5 movies.  Have begun the change slog through ESB.  Added a page with just links to reference material which will hopefully get included over time.

Ver.0.2.03: Added preliminary 2011 and 35mm Mono change info.

Ver.0.2.01a: Finished doing the GOUT, 97, 2004 pass in the change category.  As this was the second pass through, the shot total increased to 2,221.  The 97 Se jumps to 2,241 and 2004 goes down to 2,238.  The 97SE change percentage is just under 11%.

Ver.0.1.01a: Finished the first pass which gives the shot total as 2,209.  With 181 Omitted or Removed script scenes.  (this can probably be reduced with a second reading/pass)

Ver.0.09a : Have completed the SW Shot List from beginning to middle of the Death Star attack.  10 minutes left to do.  Current count is 2,128 shots.  General estimate may finish at around 2,200-2,350.

Current Problems : Shot/Sub-Scene title is inconsistent, started by listing unlisted shots with a ‘Sub’ title (using a number), realized a ways in that I should just start a ‘Shot’ column count.  The ‘Added’ shot and ‘Removed’ values may reduce as I better read the script, since scenes are moved around and sequences shifted, keeping track of everything requires a re-read.

To Do: figure out mechanical way to transport frame count and shot length into the document.  May add a ‘moved’ change category, so that variations between the script and final film can be identified beyond the V9/A9 ‘removed’ material.  Example the “3po in wires” would be considered a ‘move’ from script (Tantive) to screen (Millennium Falcon).

Idea started from: http://originaltrilogy.com/forum/topic.cfm/Complete-Comparison-of-Special-Edition-Visual-Changes/topic/11927/page/31/

Where zombie84 had created spreadsheet of Special Edition and 2004 changes.  Had always been curious of the number of shots in the movie, will incorporate this data, but also expand as i’ve introduced a category for the 2004 color timing issue and have columns for audio changes.

Hopefully can figure out a way to save as a jpg so the change colors could make an image which visually tells the SW changes over time story.  Each shot would equal one pixel.

Would hope that this spreadsheet could be converted into something fan editors could use to document their changes.  (similar to TV’s Frink’s fan edit change documents)  But as it’s a spreadsheet might be easier to convert into a database/.HTML format.

Past Versions :

ShotList-StarWars-v0.6.02 :

https://docs.google.com/spreadsheets/d/1PzcHuIAV4JPfgJViPbOvEZkqNwiCguGWglrbJjR5rn8/edit?usp=sharing

ShotList-StarWars-v0.5.05 :

https://docs.google.com/spreadsheet/ccc?key=0AtjXdIjRQo5NdDJORXlfTDBIN0NaQXlWMk51Q2tOR0E

ShotList-StarWars-v0.5.00 :

https://docs.google.com/spreadsheet/ccc?key=0AtjXdIjRQo5NdHd1U19DZXdjYXduMF9EN1ZWVjN4NFE

**ShotList-StarWars-v0.5.00_public : **

https://docs.google.com/spreadsheet/ccc?key=0AtjXdIjRQo5NdE9RcndMaU9tSGNvd3J6eC1KemRoMlE

ShotList-StarWars-v0.4.00 :

https://docs.google.com/spreadsheet/ccc?key=0AtjXdIjRQo5NdEE0VHZtWFBhS1FBSW9vbzh6azN6QUE

ShotList-StarWars-v0.3.03 :

https://docs.google.com/spreadsheet/ccc?key=0AtjXdIjRQo5NdHVfd2E3LWdubkkwRW5MWEtyTHlOVnc

ShotList-StarWars-v0.3.00 :

https://docs.google.com/spreadsheet/ccc?key=0AtjXdIjRQo5NdFpaTTVrYy05dkN0c2ZndHlQTG1rWXc

ShotList-StarWars-v0.2.08 :

https://docs.google.com/spreadsheet/ccc?key=0AtjXdIjRQo5NdEVjZ1VrOFBUUDNyV2hoNnV1RFp6MHc

ShotList-StarWars-v0.2.06 :

https://docs.google.com/spreadsheet/ccc?key=0AtjXdIjRQo5NdFFNMWxCQWlNemU4dzFra1I0S3Vfd2c&hl=en_US

ShotList-StarWars-v0.2.05 :

https://docs.google.com/spreadsheet/ccc?key=0AtjXdIjRQo5NdHRmMlNNVjJXQmtfSlZyMHVVYUxvaUE&hl=en_US

ShotList-StarWars-v0.2.04 :

https://docs.google.com/spreadsheet/ccc?key=0AtjXdIjRQo5NdEYwVmFXQlpnZHNVcGtURTVVY05OckE&hl=en_US

ShotList-StarWars-v0.2.03 :

https://docs.google.com/spreadsheet/ccc?key=0AtjXdIjRQo5NdDNiMHc4X1d5RF9pbWZuSldqN3R0NWc&hl=en_US

ShotList-StarWars-v0.2.01a :

https://docs.google.com/spreadsheet/ccc?key=0AtjXdIjRQo5NdExTNWp4dDdmZXVGUllic29SUS1iaFE&hl=en_US

ShotList-StarWars-v0.1.01a :

https://docs.google.com/spreadsheet/ccc?key=0AtjXdIjRQo5NdHljZ3U0aW02MlhsZGRaWUI5eFgtQVE&hl=en_US