Hi Jeremy,
Thanks for your response.
Yes, apparently doing exactly what I want is a job for Batch Lists and XML tweaking.
I don’t have the knowledge or the time to tackle cracking open an XML file. Oh, the things I could do if I had time to learn how to do them… i’d just have no time left to do them.
Anyways, for people looking in the future, the answer is a program called exceLogger for FCP.
https://assistedediting.com/exceLogger/
This software costs, but it will (ostensibly) parse a Batch List file with an XML export of the entire project and then let the user enter new data into a spreadsheet file, including subclip information, and finally turn out a modified XML and Batch List for re-import. I haven’t tried it yet, and it sounds kinda… long-winded, but it’s worth investigating if you want to log in a spreadsheet and your editor insists upon true subclips.
FCP 7.0, MacBook Pro, OS X 10.5.8, 2.53 GHz Intel Core 2 Duo, 4 GB 1067 MHz DDR3, NVIDIA GeForce 9600M GT 512 MB