neo_tc_calc
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
Comment only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
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.
3

Latest update:

2015-03-29, v0.6.
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.
4
5
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.
6
7
8
9
Addition, cell referencedAddition, manually entered and cell referencedSubtraction, cell referenced all values
10
=tc(B12, C12, 25, "add") =tc(F12, "00:09:23:21", 24, "add") =tc(J12, K12, L12, "sub")
11
TC1TC2TC1 + TC2TC1TC2TC1 + TC2TC1TC2SOURCE FPSTC1 - TC2
12
10:08:40:1800:01:04:1510:09:45:0810:08:40:18--10:18:04:1510:08:40:1800:31:13:092409:37:27:09
13
14
15
Division. TC2 is the divisor in this operationMultiplication. TC2 is the multiplier in this opConvert. TC2 is the target framerate in this operation
16
=tc(B18, C18, 25, "div") =tc(F18, G18, 25, "mult") =tc(J18, K18, L18, "conv")
17
TC1TC2TC1 / TC2TC1TC2TC1 * TC2TC1TC2SOURCE FPSCONVERTED
18
10:08:40:182.304:24:38:1410:08:40:181.414:12:09:0010:08:13:12252409:43:53:19
19
10:08:13:1259.94df2404:03:32:00
20
10:08:13:1223.9829.97df12:39:31:02
21
Percentage. TC2% of TC110:08:13:1223.982000047:27:13:20
22
=tc(B24, C24, 24, "per")10:08:13:1259.94df29.97df05:04:06:42
23
TC1TC2RESULT10:08:13:12400002400:00:21:44
24
10:08:40:182202:13:54:1410:08:13:12223.97621:38:42:00
25
26
27
Convert TC to framesConvert frames to TCSubtraction, cell referenced all values. Negative result support
28
=tc(B30, , 24, "2f") =tc(F30, , 24, "2tc") =tc(J30, K30, L30, "sub")
29
TC1TC2RESULTTC1TC2RESULTTC1TC2SOURCE FPSTC1 - TC2
30
10:08:40:18876498876498Loading...10:08:40:1812:31:13:0925-02:22:32:16
31
32
33
Addition, cell referenced for a rangeConvert TC to frames for a rangeConvert frames to TC for a range
34
=tc(B36:B42, C36:C42,24,"add") =tc(B36:B42, , 24, "2f") =tc(J36:J42, 0 , L36, "2tc")
35
TC1TC2TC1 + TC2TC1TC2RESULTTC1TC2TARGET FPSRESULT
36
00:00:10:2200:00:15:0600:00:26:0400:00:10:2226226224Loading...
37
00:00:15:0600:00:17:0400:00:32:1000:00:15:06366366
38
00:00:17:0400:00:19:0000:00:36:0400:00:17:04412412
39
00:00:19:0000:00:21:2300:00:40:2300:00:19:00456456
40
00:00:21:2300:00:24:0500:00:46:0400:00:21:23527527
41
00:00:24:0500:00:25:1300:00:49:1800:00:24:05581581
42
00:00:25:1300:00:26:2100:00:52:1000:00:25:13613613
43
44
45
46
47
48
49
Loading...
 
 
 
neo_tc_calc
COMMENT/DOCS
KNOWN ISSUES
REQEUSTED EXAMPLES
validate_operations
validate_frame_ranges