Timecode / Score Mapping Calculator

	B	C	D	E	G	H	I	J	L	M	N	O	P	Q	R	S	T
1	Timecode / Score Mapping Calculator																Version 1.0
2	This calculator is used to find the timecode and time standard value at chosen markers in a piece of music, factoring in tempo and time signature changes throughout.																Made by Owen Meadows
3	This is a great tool when using ableton to synchronize click track and timecode across multiple scenes.																Found a bug? Email OwenMeadowsDesign@gmail.com
4	How to Use this Calculator
5	1. Copy this sheet to your drive using File > Make a Copy
6	2. Set your timecode framerate
7	3. Set any initial Timecode and Time Standard Values in the top green line
8	4. For each marker enter your BPM, Time Signature, and starting measure for this section
9	5. The Time columns will output the value corresponding to beat 1 of the marker measure, remeber the time output is based on the values of the section preceeding the marker
10	6. Only edit values in GREEN
11							Frame Rate						Sub Calulations
12		BPM/ Time Sig. at measure			Timecode		30		Time Standard				Sub Calulations				Do Not Edit These Values
13	Marker	BPM	Time Sig	Measure	HH	MM	SS	FF	HH	MM	SS		Inter Mes.	Inter Frames	Inter Sec	Running FR	Running Sec
14	Start	120	4/4	1	01	00	00	00	00	00	00.000	Enter Init. Values Here				108000	00.000
15	A	60	4/4	2	01	00	02	00	00	00	02.000		1	60	02.000	108060	02.000
16	B		4/4	4	01	00	10	00	00	00	10.000		2	240	08.000	108300	10.000
17	C		4/4
18	D		4/4
19	E		4/4
20	F		4/4
21	G		4/4
22	H		4/4
23	I		4/4
24	J		4/4
25	K		4/4
26	L		4/4
27	M		4/4
28	N		4/4
29	O		4/4
30	P		4/4
31	Q		4/4
32	R		4/4
33	S		4/4
34	T		4/4
35	U		4/4
36	V		4/4
37	W		4/4
38	X		4/4
39	Y		4/4
40	Z		4/4
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