Timecode / Music Sync Point Calculator

	B	C	D	E	F	G	H	I	K	L	M
1	Timecode / Music Sync Point Calculator
2	Timecode / Music Sync Point Calculator										Version 1.0
3	This calculator is used to find the timecode and/or standard time value of a given measure and beat in a score.										Made by Owen Meadows
4	This is primarily used for aligning timecode or Qlab times with a synchronous musical beat from a given start point in a song.										Found a bug? Email OwenMeadowsDesign@gmail.com
5
6	Inputs							Enter your variables here	How to Use this Calculator
7	Music Variables		Your target measure must be after your start measure						1. Copy this sheet to your drive using File > Make a Copy
8	Music Variables		Starting Measure / Beat		Measure / Beat to Measure to		Count In?		2. Enter your musical variables (BPM, Time Sig.)
9	BPM	Time Signature	Measure	Beat	Measure	Beat	ON/OFF	Length	3. Enter the measure/beat you want to start from (Your zero point)
10	120	4/4	1	1	2	1		Full Bar	4. Enter the measure/beat you are trying to measure to (Your target)
11			Your Zero Point		Your Target		Use this if your click has a count in bar		5. Add a count-in bar if necessary, this comes before your zero point
12									6. Enter your Timecode Frame Rate
13	Time Variables								7. If necessary you may enter an initial TC or Time value to add to the calculation. Both outputs will include the selction in their final calculations.
14	Frame Rate			Use Initial Value?		Use this if measuring from an initial TC or Time stamp
15	30			Timecode		Only the selected value will be used in calculation			8. The TC and Standard time of the Target is calculated in Outputs. The top value is the measurement from the starting measure (including count in). The bottom value adds any Initial Timecode OR Initial Time Standard if selected.
16		Initial Timecode				Initial Time Standard
17	Hours	Minutes	Seconds	Frames		Hours	Minutes	Seconds
18	01	00	00	00		00	00	00.000	9. Only Edit Values in GREEN
19	Use this if starting from a given timecode stamp					Use this if starting in the from a given time stamp			Sub-Calculations		Do not edit this data
20									Sub-Calculations		Do not edit this data
21
22	Outputs								Measures / Beats From Init		Count In Frame Offset
23	Outputs							Time outputs here	1	0	00
24
25	Timecode From Start M/B (Zero Point)					Time Standard From Start M/B			Seconds / Frame	Frames / Beat	Seconds / Beat
26	Hours	Minutes	Seconds	Frames		Hours	Minutes	Seconds	0.033	15	0.500
27	00	00	02	00		00	00	02.000
28				Rounds to nearest frame				Rounds to nearest .001 Sec	Count In Beats	Frames / Bar	Seconds / Bar
29	Timecode Total Incl. Init Val					Time Standard Total Incl. Init Val			0	60	2.000
30	Hours	Minutes	Seconds	Frames		Hours	Minutes	Seconds
31	01	00	02	00		01	00	02.000	Beats From Start	Frames From Start (Incl. CI)	Seconds From Start (Incl. CI)
32				Rounds to nearest frame				Rounds to nearest .001 Sec	4	60	2.000
33
34									Total Beats	Total Frames	Total Seconds
35									4	108060	3602.000
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