TimeCode-MagiKs - TCUtils functions
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

ABCDEFGHIJKLMNOPQR
1

You must install and enable the following add-on in the spreadsheets where you want these wonderful timecode custom functions to be available:
2
3
(For now only integer frame rates are supported)
4
TimeCode-MagiKs version :#NAME?
5
Blue cells = input data
6
Green Cells = cells containing a formula
7
Yellow cells = cells containg more results from the cells in green
8
24 FPS time codes: 01:32:24:18
02:42:34:07
1:0002:09:40:0701:29:39:1001:33:41:0302:00:08:1101:29:19:1501:28:49:1702:36:22:1101:14:55:18
9
Available functions with usage examples as used in column B

Each of the functions below is applied on a range, they can also be used on a specific cell or literal value

(Click each cell in green to checkout their formula)
10
TC_CONV(B5:T5, 24, 25) :
(24 to 25 conversion)
#NAME?
11
TC_TO_FRAME(B5:T5, 24) :
(Convert a range of timecodes at 24 fps to frame number)
#NAME?
12
TC_TO_FRAME(B7:T7, 25) :
(Convert a range of timecodes at 25 fps to frame number)
#NAME?
13
FRAME_TO_TC(B9:T9, 24) :
(Convert a frame number to its 24 fps timecode representation)
#NAME?
14
TC_OFFSET(B10:T10, -1 * TC_TO_FRAME("2:00",24), 24) :
(Apply a negative offset of 2 seconds to a range of 24 fps timecode)
#NAME?
15
HFROMI(\$B\$9:\$9, 24) :
(Get the integer number of hours from a range of frame numbers at 24fps)
#NAME?
16
MFROMI(\$B\$9:\$9, 24) :
(Get the integer number of minutes from a range of frame numbers at 24fps)
#NAME?
17
SFROMI(\$B\$9:\$9, 24) :
(Get the integer number of seconds from a range of frame numbers at 24fps)
#NAME?
18
IFROMI(\$B\$9:\$9, 24) :
(Get the integer number of image from a range of frame numbers at 24fps)
#NAME?
19
MFROMIRAW(\$B\$9:\$9, 24) :
(Get the total integer number of minutes from a range of frame numbers at 24fps)
#NAME?
20
21
22
23
Function to work with EDLs imported via the 'import EDL' in the Add-ons menu:
In the folowing examples, we use the EDL imported in the EDLExample sheet
24
TC_MATCHBACK(timeCode, fps, a_edl, offset)
Example:
TC_MATCHBACK("10:01:02:03", 24, sheet3!A3:H, 0)

Summary:
Use an EDL to get a record timeCode's related source timeCode. (most effects are not supported yet.)

timeCode:
The record timeCode for wich you want the related source timeCode (Can be a range)

fps:
The frame rate of the provided record timeCode and EDL

a_edl:
The EDL represented by a range containing rows of 8 cells each [Event#, Source, Track, EventType, TCSourceIn, TCSourceOut, TCRecordIn, TCRecordOut]

offset:
An optional offset to apply to the returned TC
25
Exemple :

TC_MATCHBACK("01:02:03:04", 24, EDLExample!A3:H)

"get the time code of the source edited at 01:02:03:04 and 01:02:03:05"

(using a multiline input in this example to show that it's supported but it's best to provide a range of multiple cells)

When source timecodes are not unique throughout the timeline the source name and the event number are added with the returned timecode
If there is a Dissolve at this record location boths source timecodes are returned
#NAME?
01:02:03:04
01:02:03:05
26
TC_REVERSE_MATCHBACK(timeCode, fps, a_edl, offset)Example:

TC_REVERSE_MATCHBACK("10:01:02:03", 24, sheet3!A3:H, 0)

Summary:

Use an EDL to get a source timeCode's related record timeCode. (most effects are not supported yet.) @author wej

timeCode:

The source timeCode for wich you want the related record timeCode (Can be a range)

fps:

The frame rate of the provided source timeCode and EDL

a_edl:

The EDL represented by a range containing rows of 8 cells each [Event#, Source, Track, EventType, TCSourceIn, TCSourceOut, TCRecordIn, TCRecordOut]

offset:

An optional offset to apply to the returned TC
27
Exemple :

TC_REVERSE_MATCHBACK("01:02:03:04", 24, EDLExample!A3:H)

"where is the source timecodes 07:02:18:00 and 07:02:18:01 edited ?"

(as a multiline input in this example to show that it's supported but it's best to provide it as an array if possible else it can get confusing when multiple values are returned for each input...)

When source timecodes are not unique throughout the timeline the source name and the event number are added with the returned timecode.
Additionaly if this source timecode is edited at several locations, all the record, source and event numbers are returned
#NAME?
28
EDL_SUMMARY(a_edl, fps)
Example:

EDL_SUMMARY(sheet3!A3:H, 24)

Summary:

Returns various useful details avout an EDL (Most effects are not supported yet.)

a_edl:

The EDL represented by a range containing rows of 8 cells each [Event#, Source, Track, EventType, TCSourceIn, TCSourceOut, TCRecordIn, TCRecordOut]

fps:

The frame rate of the provided record timeCode and EDL
29
30
Example :

EDL_SUMMARY(EDLExample!A3:H,24)
#NAME?
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100