DVD-BOY wrote: I currently have ROTJ Project Blu v1 and 2011 BD ripped to my machine as Cineform AVIs so I'm wondering if it is worth incorporating frame numbers from both GOUT and Later releases.
For me the GOUT numbers are a temporarily standard until we become more familiar with an actual 35mm print. There is a thread about the GOUT's missing frames: http://originaltrilogy.com/forum/topic.cfm/Whats-missing-from-GOUT/topic/6725/ which for me reinforces the GOUT's temporary standard claim.
But yes all releases would one day get identified. The spreadsheet format makes this much easier as it's just about identifying where frames are missing and when a new scene was added. With a simple column of -1 here and +269 there, we can then automate the subtitle recreation between releases and help convert audio variations.
Ask your formatting ideas in the wiki thread. There's no best, with wiki's people can create their own navigation, if someone doesn't like the Reel approach they can make their own Sequence, for whatever page to get to the specific data. If an overall page is maintained people can chop it up as they see fit. Don't know if a wiki can cross resource like a database can.
As for your AVIs, no one's looked much at RotJ, so whatever you accomplish is great. Maybe take a block and see how long it takes you to do task-x or task-y just so you can speculate how long it'll take you. With these spreadsheets it took some time, you go thru parts where you're into it then you think it's a waste of time and process greatly slows.
I've been looking into automation of some of these tasks. Found a plug-in for After Effects called 'Magnum - The Edit Detector': http://aescripts.com/magnum-the-edit-detector/ which can take a copy of the film and cut it up where ever it finds what it believes is an edit. Was able to process a quarter of TPM in about a day. It missed a few in the beginning but otherwise worked great, and there are ways to improve it's selection field to get better results. What I was hoping to do then was to either open up the AE file and see if the frame data could be pulled out that way or auto export each clip, then figure out a way to get the frame totals, dump that into excel and let it do the math. Was doing this to help me with the DIF TPM as that one requires each scene to be scaled, but the process can help the frame calculations.
negative1, (if you happen to read this) what was your process for the acquiring of frame counts?