AARRSSTW-WTSSRRAA

Updated
AARRSSTW-WTSSRRAA
Faneditor Name:
Franchise:
Fanedit Type:
Original Release Date:
1997
Original Running Time:
125
Fanedit Release Date:
Fanedit Running Time:
250
Time Cut:
0
Time Added:
0
Available in HD?
Brief Synopsis:
"Continuing the legacy of projects which overcome great technological hurdles, but provide little to zero entertainment value, viewer reward, societal insight or benefit." %20

What is AARRSSTW - WTSSRRAA?
The 1997 Star Wars Special Edition resorted by shot length. Ascending and Descending the 2291 shots of 0002 to 1765 frames. %20's attempt to create a possibly equally perplexing retelling, which lives up to the "Specialer" moniker.
Intention:
to see if I could, computationally.
Additional Notes:
For more information:
http://noneinc.com/AARRSSTW-WTSSRRAA/AARRSSTW-WTSSRRAA.html

History:
Members of OriginalTrilogy.com (OT.com) have been pursuing and documenting aspects of the Star Wars films as the community attempts to preserve the films or at least inform the world of their significance so a proper restoration will take place. Two projects influenced the creation of AARRSSTW - WTSSRRAA. The first, by zombie84, was an attempt to document the changes between Star Wars variations by chronicling the shots modified. The second, by negative1, was a documentation of the 2006 DVD (GOUT) release's shot length. User none expanded the zombie84 Special Edition change documentation so that it listed every shot and then cross referenced with the negative1 GOUT data. At that point %20 thought about what could be accomplished now that this data was public. AARRSSTW-WTSSRRAA was started to showcase the ability of spreadsheet fan editing and the promotion of a more robust data intensive spreadsheet. In which the next group of cultural reformers can create something else, or at least have as a nice reference.

Process:
The initial spreadsheets were created using online spreadsheet tools. As the initial shot data was a documentation of the 2006 DVD, a conversion was done to insert the scenes added in 1997 for the Special Edition.

Figured out the .XML code by reverse engineering an exported video editing project. The spreadsheet was configured to insert the resorted shot length data into the .XML format. The resorted movie in .XML format can then be imported into most video editing software. The resorted video and audio were then exported for the DVD authoring.

To expand the final presentation, in the top black bar space, multiple fields of the spreadsheet were inputted using Comma Separated Value's (.CSW) and JavaScript (.JSX) coding in an expanded subtitle like process. (capitalizing on the inPoint/outPoint feature in After Effects)

To provide a viewer participation aspect the multi-angle DVD feature was used. This required the Group Of Pictures (GOP) structure to be identical. As AARRSSTW and WTSSRRAA do not share any common frames, luckily the edit points could be reused to create 'i' key frame compression markers which with both edits applied to one feature, gave enough GOP structure so the DVD authoring software would consider them GOP equals.

The LaserDisc capture was horizontally stretched from anamorphic to full resolution 720 HD.
[more detailed process discussion is in the DVD_ROM folder's support files]
Released in the defunct HD DVD HVDVD_TS format.

Playback:
For those that can find a playback solution for the obsolete HVDVD_TS, the presentation has active buttons for on the fly switching between AARRSSTW and WTSSRRAA. The video and audio's can be switched and the information data bar in the top can be blacked out with a subtitle option. To switch using a remote, the number keypad's 1 and 2 control the video, 3 and 4 turn the data on and off and 5 and 6 switch the audio. Button 7 is an empty button which will remove all reference to their being buttons.

Files mentioned below available at: Process Files and Spreadsheets

Explanation of the Process of Resorting a Video File

SWSELT00-Explanation.txt
- this file -

[General Note : if you attempt this yourself these files are guides. You'll need to replace various pieces to get them to work on your system. File names and locations for example.]

SWSELT01-ShotList.xlsx
File contains the Shot Start/End points for the Star Wars Special Edition LaserDisc Lee Thorogood capture. Shot length data originated from negative1's GOUT analysis. %20 confirmed and expanded where things went off or shots were missing. Then the data was expanded to the Special Edition's formation.

Believe I have found an automated solution. There is an After Effects' plugin called 'Magnum - The Edit Detector', have run it on part of The Phantom Menace and it worked extremely well. Haven't thought up / figured out a way to export the edits Magnum would find to a spreadsheet or text file. Hopefully it'll be as easy as processing the .aep file or a modified export.

SWSELT02-XML-PreSort.xlsx
File contains the Shot List and the conversion/re-organization tab, which in later versions is sorted to produce AARRSSTW and WTSSRRAA. The later two tabs are the partial XML conversion, one for video, one for audio.

Note: When transitioning from step to step, formulas of the previous spreadsheet version are often removed. In later steps the resorting would not work 100% if the formulas are left intact.

SWSELT02-XML-PreSortBasicXML-ProRes4444-25to24.txt
File contains the basic .XML structure and the two zones in which the reorganized video and audio will be dropped in the next step. The header information is specific to the video file type your files are saved as. (in this case ProRes4444 with the conform 25 fps to 24 fps) To figure out your header information, create a video editing file with your unedited video in it, then export as .XML. I cut out sections of the .XML code to get as bare bones a file which could accomplished my goal.

SWSELT03-XML-AARRSSTW.xlsx and SWSELT04-XML-WTSSRRAA.xlsx
Files contain the resorted/reorganized shot data. Ascending and Descending. In descending not just by shot length but by reverse original order.

SWSELT03a-XML-AARRSSTW-4csv.xlsx and SWSELT04a-XML-WTSSRRAA-4csv.xlsx
Simplified version, removing extraneous columns not required for .CSV (Comma Separated Values) export which is to be used for the JavaScript with After Effects in Step 05.

SWSELT03a-XML-AARRSSTW-4csv - AARRSSTW-4csv.csv and SWSELT04a-XML-WTSSRRAA-4csv - WTSSRRAA-4csv.csv
The raw exported .CSV data which will be used to fill out the text fields in After Effects. (Errors will return if there is a blank field, especially in the 'text' columns.)

SWSELT03b-XML-AARRSSTW - AARRSSTW-XML-Audio.tsv and SWSELT03b-XML-AARRSSTW - AARRSSTW-XML-Video.tsv
SWSELT04b-XML-WTSSRRAA - WTSSRRAA-XML-Audio.tsv and SWSELT04b-XML-WTSSRRAA - WTSSRRAA-XML-Video.tsv
The google spreadsheet exported text version of the .XML data for Audio and Video. Data needs to be cleaned up to removed extraneous spaces. File location needs to be find/replaced. And if you are using a Stereo Mix you'll need to create Audio Left and Right possibly.

Data from SWSELT03b and SWSELT04b can then be dropped into SWSELT02-XML-PreSortBasicXML-ProRes4444-25to24.txt and the file renamed to .XML. Import the .XML into the video editing program of your choice.


SWSELT05-AfterEffects-CSVtoTextLayers-mod-inPointoutPoint.jsx
This is the JavaScript to insert spreadsheet data (Step 03a) into existing text objects in After Effects. The script was found online but was modified so that the new objects would act similar to a subtitle. The script was modified to add inPoint/outPoint data, pulled from the spreadsheet. The script finds a text object with the same name as one of the columns in the .CSV file, each spreadsheet row becoming a new composition element.

Found that my system would greatly slow down the importing of data when the entries passed the 200 count. So split the .CSV into 10 chunks and saved each one individually. Then imported the .AEP pieces into the final After Effects file.

This is probably not the most efficient way but it did the job.

SWSELT06-XML-AARRSSTW-CompMarkers.tsv and SWSELT06-XML-WTSSRRAA-CompMarkers.tsv

SWSELT06z-XML-AARRSSTW - AARRSSTW-XML-Compression Markers.xml
Turns out multi-angle DVDs require extremely similar GOP (Group of Pictures) information. This option is typically used when a movie wants to change a shot. In this case the entire two movies are dissimilar. But we can make them similar by inserting Compression Markers. (just about everywhere) These files take the inPoint data and sets a Compression Marker in .XML. When the Compression Markers from each film are applied to each video file, the hope is that the DVD making program will consider them as having the same GOP structure. Luckily Compression Markers can be unlimited, in this case the two movies each have 2291 scene changes so these files insert 4582 Compression Markers.

SWSELT99a-Subtitles-Converter.txt Not completed in this version of AARRSSTW-WTSSRRAA. Couldn't find a working subtitle track or convert an existing one into something which conformed. Got many of the spreadsheet reconfiguring math to semi-work, but not sure if the problems were with the frame rate calculation.

Other issues along the way.

Originally imported the .XML for AARRSSTW and WTSSRRAA in different Final Cut Pro files. But even with the same compression markers this returned different GoP structures which didn't convince DVD Studio Pro that they were similar enough. So eventually dropped everything into one FCP file and this worked. Also since there was a compression marker a couple frames from the end of the file, added 12 frames of blank.

Had difficulties with video compression. Compressor I think would run out of memory towards the end of some of the processing so multiple versions would be the wrong size or had artifacting towards the end. Specifically WTSSRRAA which is more active at the end. Also when the compression lowered below the 3.85 threshold that also gave WTSSRRAA bad renders. Needed to delete programs to clear out about 9gb of free space, to get everything to work.

The Chapter Markers turned out to be a waste of time. Typically set up 50-99 chapter markers so there are places to jump to. (two groups which remained were for the Title and Copyright shots [which happened to be back to back] and the flip over point for the DVD9 disc) Had set up markers at the first time a shot jumped tens, same with the defending. DVD Studio Pro to get the main feature to have active buttons requires special button highlight markers and as the HD HVDVD_TS format limits to 48 buttons, during the video, to have the buttons constantly active you are limited to the number of Chapter Markers. So ended up deleting many markers.

The HVDVD_TS format is the betamax of the high definition DVD wars. Using this format was another happy accident to reinforce the shit nature of technology at this time, society is inventing new techniques to make things obsolete and to make sure things are difficult for the next generation to view. Were also make new tech which doesn't work with the older formats.
Other Sources:
Source Info:
LaserDisc UK PAL : Star Wars Special Edition (1997) http://www.lddb.com/laserdisc/18974/EE-1232/Star-Wars-Trilogy:-Special-Edition-(1997)
Preservation by Lee Thorogood: http://originaltrilogy.com/forum/topic.cfm/LeeThorogoods-PAL-LaserDisc-Preservation-Project-97-SE-Finished-95-THX-Finished-97-SE-Uploaded-95-THX-Uploaded-to-the-newsgroup/topic/11824/
Special Thanks:
Acknowledgements:
Thanks to Lucasfilm for making a popular yet contentious movie.
Thanks to originaltrilogy.com and fanedit.org who support fan participation in culture.
Lee Thorogood for the LaserDisc transfer.
Release Information:
DVD
Special Features
Technically the obsolete/defunct HVDVD_TS format.
Editing Details:
Files mentioned below available at: Process Files & Spreadsheets

Explanation of the Process of Resorting a Video File

SWSELT00-Explanation.txt
- this file -

[General Note : if you attempt this yourself these files are guides. You'll need to replace various pieces to get them to work on your system. File names and locations for example.]

SWSELT01-ShotList.xlsx
File contains the Shot Start/End points for the Star Wars Special Edition LaserDisc Lee Thorogood capture. Shot length data originated from negative1's GOUT analysis. %20 confirmed and expanded where things went off or shots were missing. Then the data was expanded to the Special Edition's formation.

Believe I have found an automated solution. There is an After Effects' plugin called 'Magnum - The Edit Detector', have run it on part of The Phantom Menace and it worked extremely well. Haven't thought up / figured out a way to export the edits Magnum would find to a spreadsheet or text file. Hopefully it'll be as easy as processing the .aep file or a modified export.

SWSELT02-XML-PreSort.xlsx
File contains the Shot List and the conversion/re-organization tab, which in later versions is sorted to produce AARRSSTW and WTSSRRAA. The later two tabs are the partial XML conversion, one for video, one for audio.

Note: When transitioning from step to step, formulas of the previous spreadsheet version are often removed. In later steps the resorting would not work 100% if the formulas are left intact.

SWSELT02-XML-PreSortBasicXML-ProRes4444-25to24.txt
File contains the basic .XML structure and the two zones in which the reorganized video and audio will be dropped in the next step. The header information is specific to the video file type your files are saved as. (in this case ProRes4444 with the conform 25 fps to 24 fps) To figure out your header information, create a video editing file with your unedited video in it, then export as .XML. I cut out sections of the .XML code to get as bare bones a file which could accomplished my goal.

SWSELT03-XML-AARRSSTW.xlsx and SWSELT04-XML-WTSSRRAA.xlsx
Files contain the resorted/reorganized shot data. Ascending and Descending. In descending not just by shot length but by reverse original order.

SWSELT03a-XML-AARRSSTW-4csv.xlsx and SWSELT04a-XML-WTSSRRAA-4csv.xlsx
Simplified version, removing extraneous columns not required for .CSV (Comma Separated Values) export which is to be used for the JavaScript with After Effects in Step 05.

SWSELT03a-XML-AARRSSTW-4csv - AARRSSTW-4csv.csv and SWSELT04a-XML-WTSSRRAA-4csv - WTSSRRAA-4csv.csv
The raw exported .CSV data which will be used to fill out the text fields in After Effects. (Errors will return if there is a blank field, especially in the 'text' columns.)

SWSELT03b-XML-AARRSSTW - AARRSSTW-XML-Audio.tsv and SWSELT03b-XML-AARRSSTW - AARRSSTW-XML-Video.tsv
SWSELT04b-XML-WTSSRRAA - WTSSRRAA-XML-Audio.tsv and SWSELT04b-XML-WTSSRRAA - WTSSRRAA-XML-Video.tsv
The google spreadsheet exported text version of the .XML data for Audio and Video. Data needs to be cleaned up to removed extraneous spaces. File location needs to be find/replaced. And if you are using a Stereo Mix you'll need to create Audio Left and Right possibly.

Data from SWSELT03b and SWSELT04b can then be dropped into SWSELT02-XML-PreSortBasicXML-ProRes4444-25to24.txt and the file renamed to .XML. Import the .XML into the video editing program of your choice.

SWSELT05-AfterEffects-CSVtoTextLayers-mod-inPointoutPoint.jsx
This is the JavaScript to insert spreadsheet data (Step 03a) into existing text objects in After Effects. The script was found online but was modified so that the new objects would act similar to a subtitle. The script was modified to add inPoint/outPoint data, pulled from the spreadsheet. The script finds a text object with the same name as one of the columns in the .CSV file, each spreadsheet row becoming a new composition element.

Found that my system would greatly slow down the importing of data when the entries passed the 200 count. So split the .CSV into 10 chunks and saved each one individually. Then imported the .AEP pieces into the final After Effects file.

This is probably not the most efficient way but it did the job.

SWSELT06-XML-AARRSSTW-CompMarkers.tsv and SWSELT06-XML-WTSSRRAA-CompMarkers.tsv
SWSELT06z-XML-AARRSSTW - AARRSSTW-XML-Compression Markers.xml
Turns out multi-angle DVDs require extremely similar GOP (Group of Pictures) information. This option is typically used when a movie wants to change a shot. In this case the entire two movies are dissimilar. But we can make them similar by inserting Compression Markers. (just about everywhere) These files take the inPoint data and sets a Compression Marker in .XML. When the Compression Markers from each film are applied to each video file, the hope is that the DVD making program will consider them as having the same GOP structure. Luckily Compression Markers can be unlimited, in this case the two movies each have 2291 scene changes so these files insert 4582 Compression Markers.

SWSELT99a-Subtitles-Converter.txt Not completed in this version of AARRSSTW-WTSSRRAA. Couldn't find a working subtitle track or convert an existing one into something which conformed. Got many of the spreadsheet reconfiguring math to semi-work, but not sure if the problems were with the frame rate calculation.

Other issues along the way.

Originally imported the .XML for AARRSSTW and WTSSRRAA in different Final Cut Pro files. But even with the same compression markers this returned different GoP structures which didn't convince DVD Studio Pro that they were similar enough. So eventually dropped everything into one FCP file and this worked. Also since there was a compression marker a couple frames from the end of the file, added 12 frames of blank.

Had difficulties with video compression. Compressor I think would run out of memory towards the end of some of the processing so multiple versions would be the wrong size or had artifacting towards the end. Specifically WTSSRRAA which is more active at the end. Also when the compression lowered below the 3.85 threshold that also gave WTSSRRAA bad renders. Needed to delete programs to clear out about 9gb of free space, to get everything to work.

The Chapter Markers turned out to be a waste of time. Typically set up 50-99 chapter markers so there are places to jump to. (two groups which remained were for the Title and Copyright shots [which happened to be back to back] and the flip over point for the DVD9 disc) Had set up markers at the first time a shot jumped tens, same with the defending. DVD Studio Pro to get the main feature to have active buttons requires special button highlight markers and as the HD HVDVD_TS format limits to 48 buttons, during the video, to have the buttons constantly active you are limited to the number of Chapter Markers. So ended up deleting many markers.

The HVDVD_TS format is the betamax of the high definition DVD wars. Using this format was another happy accident to reinforce the shit nature of technology at this time, society is inventing new techniques to make things obsolete and to make sure things are difficult for the next generation to view. Were also make new tech which doesn't work with the older formats.
Cuts and Additions:
The 1997 Star Wars Special Edition resorted by shot length. Ascending and Descending the 2291 shots of 0002 to 1765 frames.
Cover art by %20 (DOWNLOAD HERE) image

Cover art by Neglify (DOWNLOAD HERE)
image

User reviews

There are no user reviews for this listing.