Just downloaded, and tried the two new versions. When I open the .ods version, I get a message saying “This document uses an unsupported version of the Open Document Format. Some features may not be displayed correctly.” It asks me if I would like to try to update Open Office, I do that, but I have the latest version already. The following answers also apply to the two new versions as well.
Yes, it also already displays the error in the results section of the second tab.
Yes, in every row all the way down to row 101.
Yes, the error remains regardless of whether I copy and paste or type in the timecode.
Sweet, thank you for testing that out. Turns out that the TEXTJOIN function I used in that column is not supported by OpenOffice, only LibreOffice. I downloaded OpenOffice and checked it there, and I was seeing the same problem as you were. I’ve adjusted the spreadsheets to use the CONCATENATE function instead, and it should work now. I opened the new version and confirmed that OpenOffice was able to run it.
You can use either the .ods or the .sxc file. I’ve put both up just to cover my bases, but they’re the same thing. Each day we get a little closer to figuring this out!
It looks like the final display of the calculation is using only the minutes and milliseconds but dropping the seconds entirely. After the column G divider, it just has column H “Calculated Minutes,” column I “Calculated Millisecs,” and then column J “Combined (MM:SSmss).” The result is a format that looks like XX:XXXX instead of XX:XX.XXX.
I really like that the results tab lets you save the final doc. That’s a really nice touch.
I made a multi-vid compilation and used the spreadsheet before I realized it wasn’t working. When I got done I realized that I forgot to change the framerate in the spreadsheet for any of the vids. I foresee this happening a lot. This is the time that I would really appreciate some kind of nag screen. Maybe the first tab of the spreadsheet could be nothing but the framerate option so it’s the first thing you see when you open it up.
Oops! Lol. Ok, I updated both files to fix that little mistake. I also updated them with a new tab that is just for the framerate. That was a good idea, and hopefully it will help people to remember to update it.
Both files should be fixed and available using the links from my last comment. (I’m new to using Mega, so if for some reason the fixed versions aren’t available at that link, let me know!)
I’ve had some time to try out the spreadsheet tool, and I think it works really well. Thank you very much for making this!
Unfortunately I’m still banging my head against the framerate problem. I thought I had found a solution, but when I put it to the test by making a compilation of videos with multiple framerates it didn’t work out. I even rendered the video with fsVideoMergerSplitter on the slow setting, and I think it might be even more out of sync in places than my DR rendered video.
Awesome, glad to hear the spreadsheet is doing its job!
I wish I was able to be more help with the framerate issue, but I have a pretty limited knowledge in that area. If I was taking a stab at it, I would think that it has something to do with this drop frame thing. I found an interesting article that discussed framerate timing in relation to subtitles. It didn’t give a satisfactory solution for our use-case, but it did have a nice explanation of the framerate differences. How Drop and Non-Drop Frame Timecodes Affect Closed Captions (3playmedia.com)
I’ve been circling around the drop frame rate and non-drop frame rate concept from the very beginning, but I’ve been unable to work out ways that I can use it. That article actually gives me some ideas to work with.
Instead of setting up my project with a framerate of 60 fps, maybe I should use 59.94 and enable drop frames. Maybe I need to also convert the original videos to 59.94 with drop frames. The final solution might be one or the other or both.
Video with funscripts and video with subtitles are not too dissimilar. They both involve a separate file that syncs up with their respective video. This means I can potentially expand my research on the topic outside of EroScripts. If I can find solutions for making compilations of videos with various frame rates sync up properly to a subtitle file, then I may be able to apply that same knowledge to funscripts.
Maybe there’s already an editor that splices and merges video and subtitle files. I could rename the funscript file as a subtitle file, work with it in the editor, and then after rendering rename it back to a funscript file.
Maybe I could do the same as #3 above but treat the funscript file as an audio file. Then I export the audio track which is really the funscript track.
I don’t think #3 and #4 will work, but I’m documenting the ideas here before I try it just in case it sparks a better idea for someone else who might be reading this.
Hi, I got confused in part 4 with creating the CSV file.
Should I open it in notepad and what should It look like if I want the first part of the scene and funscript to start at 5:55, pause at 6:45 and resume at 7:03?
I converted them to millisecond
355,000 ms
405,000 ms
423,000 ms
Make sure to download the timecode conversion tool (HHMMSSFF_Timecode_Conversion
.sxc or HHMMSSFF_Timecode_Conversion
.ods) from the megas just a few posts up. When you open the spreadsheet, there are instructions on how to use it including how to create the csv file. Make sure you know your video’s frame rate and update it in the spreadsheet. Once you create the csv file, you’ll need to open it to remove the extra semicolons (as per the instructions). I usually just use notepad to do this.
don’t know if I filled the spreadsheet correctly. the FPS was 59.94 should that have automatically been entered in the HH:MM:SS:FF - in the FF slot? or should that just be 00?
I don’t know how you ended up with that. Make sure you’re using the most recent version of either of those spreadsheet tools. The other versions do not work properly.
The very first tab should say “Enter the framerate of your video!” This is the only place you need to enter your frame rate.
HH:MM:SS:FF reads as “hours:minutes:seconds:frame.” If you’re not clear on this, make sure to read the very first post by @TheObsidianGeneral. I use DaVinci Resolve which uses this timecode format. Each frame adds a certain number of milliseconds depending on what the framerate is, but it sounds like you’re not using a video editor so just leave “FF” at 0.
I used your values for creating two parts. Part 1 begins at 00:05:55:00 and ends at 00:06:45:00. Part 2 begins at 00:07:03:00 and since I don’t know when your video ends I just said 00:10:00:00.
Then I went to the third tab that says “Save This as a CSV.” I clicked “save as.” Renamed it and saved as .csv. Before it finishes saving, you get a pop up that asks about formatting. “Field delimiter” must be set to use “;” otherwise it will default to “,” which wont work with the splitter/merger tool.
After I saved I opened it up in notepad, this is what I got. Note: delete all the semicolons below this.
sorry to be a pain again but, I’m trying to split a 8k scene and was wondering do they lose any quality when splitting or is there a setting I should check so that it stays 8k after the split? Also have you split any VR scenes and how have they turned out? Any loss of quality?
Hey, sorry it’s taken me so long to get back to you. Don’t apologize. I’m happy to help in any way I can, and I hope the information in this post helps others.
I have not done any VR scenes nor have I used the software for anything over 1080p. You would honestly be better off asking this question in the original software post.
However, I’m glad you asked it here because I would like to point out that you don’t have to use the Funscript Splitter/Merger software for your final video. You can edit your video with any video editing software you like. For instance, I’m using DaVinci Resolve. If you do it this way, you should get your timecodes from your video editing software. This way you can be certain that your final script and video match up (unless you’re running into the problems I’m having here which are related to videos with different frame rates).
Here’s a tip for using transitions (fades, dissolves, wipes): When you insert a transition, most software will automatically seek to the timecode in the middle of the transition. If you use this timecode, script B will only begin playing once the image on screen is 50% video A and 50% video B. In my experience, this tends to disrupt the flow of the final script because your brain is already trying to figure out what the next scene is and has already started following the action of video B. This means when you have a transition from video A to video B, use the timecode at the very start of the transition for the cuts in your script and you should end up with a really nice flow even when you’re transitioning between action of very different speeds.
So you’re saying I could just use the splitter for the scripts and then cut the video in Davinci and then… I could “fuse” the scripts with the video in Openfunscripter?
Was wondering cause I’ve been getting different timestamps in DaVinci and OFS which has also got me confused although OFS seems to be more reliable for the timestamps. But if I cut the video in DaVinci the timestamps might not line up with the script.
I also updated them with a new tab that is just for the framerate. That was a good idea, and hopefully it will help people to remember to update it.
