|Disclaimer: Im no expert in this and I created it since I needed it myself. I encourage you to come with feedback such as feature requests, bugs or other stuffs. |
You will find the script in the 'script editor' under the 'Tools'-menu. You will have to manually copy and paste this script into all documents you want to use it in. If there's a bug and it needs update, all these instances would have to be manually updated. =/
Make a copy of this document to your own gDocs/gDrive, once there you can edit it and access the script in the script editor. If that doesn't work, write something in the comments.
There's a built-in limitation in gDocs for how many times a script can be called per second. This is important to have in mind and if you see a lot of '#ERROR!' cells, hover over them to see what the issue is. If it's related to this limitation try to work with ranges instead, examples below. Ranges also improves speed a lot!
Sometimes a script can error out for no apparent reason, reloading normally helps.
29.97 and 59.94 drop frame support implemented. During this process i've learnt that there is no such thing as 23.976 drop frame so that has ben dropped, no pun intented. =) There is support for 23.976 calculations though. Use the drop frame framerates in calculations with "29.97df" and "59.94df" or with cell reference.
I've added some sheets at the bottom with auto validation's so that I more ealisy can test the script. Works as a good validation for you as well, so that you can see that it works and what it does. In the 'validate_frame_ranges' sheet you can see that it drop frames when it should for 29.97df and 59.94df.
I still haven't gotten inter-column math to work. With inter-column I mean that it should be possible to add tc's from one single column, A1:A5, in one operation. Sadly, with my lack of skills and experience it probably means that I have to re-do alot of the script. It's next on the list and it'll be part of a major rewrite where you should also be able to do calculations on spread out cells. Turned out it's not that easily achieved though and might require
a bigger brain than mine.
|Apparently google hade changed something that might affect how scripts in a shared document works. Make sure to make a copy to your gDrive or sheets or whatever they call it this particular day.|
|Addition, cell referenced||Addition, manually entered and cell referenced||Subtraction, cell referenced all values|
|=tc(B12, C12, 25, "add")||=tc(F12, "00:09:23:21", 24, "add")||=tc(J12, K12, L12, "sub")|
|TC1||TC2||TC1 + TC2||TC1||TC2||TC1 + TC2||TC1||TC2||SOURCE FPS||TC1 - TC2|
|Division. TC2 is the divisor in this operation||Multiplication. TC2 is the multiplier in this op||Convert. TC2 is the target framerate in this operation|
|=tc(B18, C18, 25, "div")||=tc(F18, G18, 25, "mult")||=tc(J18, K18, L18, "conv")|
|TC1||TC2||TC1 / TC2||TC1||TC2||TC1 * TC2||TC1||TC2||SOURCE FPS||CONVERTED|
|Percentage. TC2% of TC1||10:08:13:12||23.98||20000||47:27:13:20|
|=tc(B24, C24, 24, "per")||10:08:13:12||59.94df||29.97df||05:04:06:42|
|Convert TC to frames||Convert frames to TC||Subtraction, cell referenced all values. Negative result support|
|=tc(B30, , 24, "2f")||=tc(F30, , 24, "2tc")||=tc(J30, K30, L30, "sub")|
|TC1||TC2||RESULT||TC1||TC2||RESULT||TC1||TC2||SOURCE FPS||TC1 - TC2|
|Addition, cell referenced for a range||Convert TC to frames for a range||Convert frames to TC for a range|
|=tc(B36:B42, C36:C42,24,"add")||=tc(B36:B42, , 24, "2f")||=tc(J36:J42, 0 , L36, "2tc")|
|TC1||TC2||TC1 + TC2||TC1||TC2||RESULT||TC1||TC2||TARGET FPS||RESULT|