I’m so glad to hear that you’re making good progress! I’m going to work on that spreadsheet soon, which should make doing the batch timecodes much easier. I’m excited to hear that you can copy/paste the timecode, because that should save a LOT of time. Would you do me a favor and paste an example of what gets copied when you use that method? That way I can set up the spreadsheet to correctly read the timecode without you having to tweak it at all before pasting. (Also, it breaks my heart a little that the audio timecode solution didn’t work for DaVinci Resolve. I didn’t realize that was for a different application, and I was hoping we had stumbled onto a great solution!)
As for the framerate issue… That is a bit beyond my knowledge of video editing. As I understand it, the funscript format uses timecodes, not frames. So in theory, things should continue to match up. I looked around a little and I was able to find a topic regarding framerate conversions. You may find it helpful. You could also consider reaching out to some of the more knowledgeable people in that topic and see if any of them have suggestions for you.
Does scripting a 60FPS in 30FPS mess any thing up? - Help - EroScripts