morst-Audio-Speed-Converter.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Shorter Source Length	Computed Ratio	Difference	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
2
3	Main Audacity tool with Computed LENGTH when you input the length of audio to match, in samples, as well as the offset between the two start points for the file to be Speed Changed
4	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Computed Shorter Source Length	Computed Ratio	Enter Difference Here:	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
5	2015-08-09	test	n/a	Long Aud maybe	2222222	Short SBD perhaps	2220988	0.99944469994447000000	1234	0.99944469994447000000	1.00055560858501000000	-0.05556085850080270000	-555.60858500802700000000	User Inputs the Difference, Worksheet Calculates Shorter source length
6
7
8	Optional version with Computed DIFFERENCE, useful for other workstations, and wild-guesstimations
9	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Enter Short Source Length Here:	Computed Ratio	Computed Difference	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
10	2015-08-09	test	n/a	Long Aud maybe	123456789	Short SBD perhaps	113456789	0.91899999926290000000	10000000	0.91899999926290000000	1.08813928270084000000	-8.81392827008352000000	-88139.28270083520000000000	User Inputs both Source Lengths, Worksheet Calculates difference
11
12	style 3 for Audacity 2.4.2 and other situations where you need to enter the length of the clip to be adjusted
13	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Computed Shorter Source Length	Computed Ratio	Enter Difference Here:		ENTIRE CLIP Length		TELL CHANGE SPEED THIS IS WHAT YOU WANT:	Notes	(Audacity %S.C.)
14	1/2/22	example	SBD	longer SBD this time	110491757	Shorter AUD source	110489906	0.99998324761909600000	1851		116625329		116623375.2		-0.00167526615508784000
15
16
17	This spreadsheet is a tool which can calculate the precise amount of "Speed Change" needed, in order to synchronize two uninterrupted audio tracks, made with different digital recorders which did not have timing clocks locked together. This tool was made for use along with the Audacity workstation software. Audacity is availble as a free download for PC, MAC, and Linux. This tool's results can likely be used for other workstation software, as well. Note that versions of Audacity beyond 2.1.0 do NOT allow as much precision as this operation requires, via the part of the interface where the user enters a percentage to change. In later versions of Audacity such as 2.4.2, the user may input an exact total length for resampling. Please refer to Rows 13-14 of this sheet, with the red highlighted section which reads TELL CHANGE SPEED THIS IS WHAT YOU WANT for the v2.4.2 method.
18
19	Before using this tool, the user should precisely locate and mark four points within the two tracks to be synchronized, in order to determine the two values to feed this tool. To make a track mark (label) in Audacity on PC, use the mouse and click the point in the track, then use Control-B keyboard shortcut, or go to Tracks > Add Label At Selection. On MacOS, it's Command B. For greatest accuracy over long files, the two points at which the files are to be synchronized should be as far apart in time as is practical, that is, one near the start of the shortest segment, and one near the end of it. As each point is located and marked, the start time of the file which is being moved should also be marked. (thus the total of four points) The two marked start times are where the difference in time between the sync points of the file to be changed may be most easily measured, as the waveform of the first spot moves from its marked location when the user finds the second spot. Rather than having to find the same bit of the pattern to mark again, it is much easier to simply use the start of the track as a proxy. If it is not practical to use the start times, the file end points may alternately be used.
20

21	To use this tool, the user enters two values, and the desired output is the Speed Change value (% difference), which can then be used in the AUDACITY workstation software's Speed Change plugin, in order to synchronize the tracks. Note that a positive number in the Difference field will give the value to squash, negative sign will result in file stretching The original version on lines 4-5 allows the user to enter the length of the reference file, in samples, and the number of samples in between the marked start points. (see above) The optional version on lines 9-10 allows the user to enter two track lengths, in samples. This might be useful for matching a soundtrack to the scratch audio of a video production, for instance, or making guesstimations The new version for Audacity v2.4.2 and newer (or other DAW's which require user to enter new length in samples rather than specify by percentage) is on lines 13-14.
22
23	SELECT AND COPY THE 2 LINES YOU PREFER TO USE, EITHER LINES 4 & 5 or Lines 9 & 10 FOR EACH SET OF FILES REQUIRING SYNCHRONIZATION, AND DUPLICATE THEM BELOW. You can keep all your previous work to see if any given set of recorders is consistent over time.
24	FEEL FREE TO DELETE ANYTHING BELOW THIS AND REPLACE IT WITH YOUR OWN RESULTS. You can't edit this posted version, so download it yourself!
25
26	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Computed Shorter Source Length	Computed Ratio	Enter Difference Here:	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
27	2017-02-26	Hip Replacements	197224_01	KM140s - DR70D	464154680	SBD - EMTEN	464138286	0.99996467987783700000	16394	0.99996467987783700000	1.00003532136972000000	-0.00353213697177335000	-35.32136971773350000000	Cool, this is correct
28
29
30	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Computed Shorter Source Length	Computed Ratio	Enter Difference Here:	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
31	2018-12-02	dSATZ sync	n/a	Long Aud maybe	220320000	Short SBD perhaps	220319240	0.99999655047204100000	760	0.99999655047204100000	1.00000344953986000000	-0.00034495398586464900	-3.44953985864649000000	User Inputs the Difference, Worksheet Calculates Shorter source length
32
33	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Computed Shorter Source Length	Computed Ratio	Enter Difference Here:	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
34	7/1/19	GaryGatesBand	090609_01	SBD - D100	234796353	_00	234793008	0.99998575361176900000	3345	0.99998575361176900000	1.00001424659119000000	-0.00142465911932010000	-14.24659119320100000000	User Inputs the Difference, Worksheet Calculates Shorter source length
35
36	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Computed Shorter Source Length	Computed Ratio	Enter Difference Here:	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
37	2019-07-12	Indi2017-12-26	from mark	4011s	343362257	Short SBD perhaps	343338579	0.99993104076083700000	23678	0.99993104076083700000	1.00006896399487000000	-0.00689639948676657000	-68.96399486766570000000	User Inputs the Difference, Worksheet Calculates Shorter source length
38
39	Work Date	Fileset Name	File Name	Shorter Source Name	Shorter Source Length	Longer Source Name	Computed Longer Source Length	Computed Ratio	Enter Difference Here:	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
40	2019-09-06	8/13 Armando's - JES	n/a	MixPre KM140s	357965431	EMTEN SBD	357987356	1.00006124893105000000	-21925	1.00006124893105000000	0.99993875482015600000	0.00612451798437386000	61.24517984373860000000	Swapped labels because. +0.00612451 was sufficient precision for this fileset, gets me within 42 samples of close.
41
42	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Computed Shorter Source Length	Computed Ratio	Enter Difference Here:	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
43	2019-10-19	Hopmonk indoor session	190728_0283S12 SBD	SBD on DR70D	280552640	Neumanns on stage > MixPre6	280547464	0.99998155069936300000	5176	0.99998155069936300000	1.00001844964102000000	-0.00184496410204904000	-18.44964102049040000000	shrunk AUD by 0.0018449
44
45	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Enter Short Source Length Here:	Computed Ratio	Computed Difference	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
46	2019-11-24	checht example	see ts thread	Long Aud maybe	267844464	Short SBD perhaps	267840000	0.99998333361110700000	4464	0.99998333361110700000	1.00001666666667000000	-0.00166666666667759000	-16.66666666677590000000	User Inputs both Source Lengths, Worksheet Calculates difference
47
48	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Computed Shorter Source Length	Computed Ratio	Enter Difference Here:	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
49	2020-02-20	CVB1986-10-18 MCAS	SBD-MCAS	SBD	109007069	AUD-MCAS	108222853	0.99280582436355600000	784216	0.99280582436355600000	1.00724630684057000000	-0.72463068405708200000	-7246.30684057082000000000	0.71450062 is not enough- I just can't make this work.
50
51	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Computed Shorter Source Length	Computed Ratio	Enter Difference Here:	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
52	2020-04-14	RFL2000-09-16	n/a	Long SBD	145306293	Short AUD	145304190	0.99998552712372900000	2103	0.99998552712372900000	1.00001447308574000000	-0.00144730857383202000	-14.47308573832020000000	0.0014473
53
54	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Computed Shorter Source Length	Computed Ratio	Enter Difference Here:	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
55	2020-05-16	SC video sync	from M4a scratch	Rabbi video	244592562	Beyer Mics > DAT	244577947	0.99994024756975200000	14615	0.99994024756975200000	1.00005975600081000000	-0.00597560008139819000	-59.75600081398190000000	Let's try Speed Change on the DAT by -0.0059756%
56
57	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Computed Shorter Source Length	Computed Ratio	Enter Difference Here:	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
58	2020-06-09	RFL2000-12-01	n/a	Longer SBD SV3700 at 44.1	151825125	Shorter AUD D10 Pro	151828215	1.00002035236263000000	-3090	1.00002035236263000000	0.99997964805158300000	0.00203519484175407000	20.35194841754070000000	change of +0.00203051 seems good for set 1
59
60	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Computed Shorter Source Length	Computed Ratio	Enter Difference Here:	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
61	2020-06-19	JBB2001-03-09	n/a	SBD at 44.1 to match	282826433	KM140 at 48kHz	282820260	0.99997817389296100000	6173	0.99997817389296100000	1.00002182658343000000	-0.00218265834279752000	-21.82658342797520000000	change of +0.002182658 is sufficient precision
62
63	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Computed Shorter Source Length	Computed Ratio	Enter Difference Here:	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
64	2020-07-03	RFL2006-03-08	SHNTOOL JOINED	SBD at 44.1	234800834	KM140 DAUD	234794399	0.99997259379410900000	6435	0.99997259379410900000	1.00002740695701000000	-0.00274069570118662000	-27.40695701186620000000	note +0.0027406 is all I need
65
66	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Computed Shorter Source Length	Computed Ratio	Enter Difference Here:	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
67	2020-07-12	video sync	_0062S12	scratch	163539228	_0062S12	162568330	0.99406321032651600000	970898	0.99406321032651600000	1.00597224563973000000	-0.59722456397257600000	-5972.24563972576000000000	VERY LARGE CORRECTION! first try -0.59722456
68
69	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Computed Shorter Source Length	Computed Ratio	Enter Difference Here:	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
70	2020-07-19	test	n/a	SBD 441 but this math is for 48k	126660564	VP88	126655552	0.99996042967249100000	5012	0.99996042967249100000	1.00003957189338000000	-0.00395718933821065000	-39.57189338210650000000	Try -0.003957189
71
72	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Computed Shorter Source Length	Computed Ratio	Enter Difference Here:	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
73	2020-06-19	JBB2001-03-09	n/a	SBD at 44.1 to match	282826433	KM140 at 48kHz	282820260	0.99997817389296100000	6173	0.99997817389296100000	1.00002182658343000000	-0.00218265834279752000	-21.82658342797520000000	change of +0.002182658 is sufficient precision
74	2020-07-22	RFL2001-03-09	WAV	Shrink SBD to match	170820866	KM140 at 48kHz	170817073	0.99997779545269400000	3793	0.99997779545269400000	1.00002220504036000000	-0.00222050403591023000	-22.20504035910230000000	change of +0.0022205 is take 3 for good luck
75
76	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Computed Shorter Source Length	Computed Ratio	Enter Difference Here:	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
77	2020-08-02	RFL2004-02-07-remix ad nevermind	WAVs	Longer AUD	110473403	Short SBD yep	110471463	0.99998243921208800000	1940	0.99998243921208800000	1.00001756109630000000	-0.00175610962986905000	-17.56109629869050000000	shrink 0.0017561 of AUD is within 50-75 samples on a spot check
78
79	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Computed Shorter Source Length	Computed Ratio	Enter Difference Here:	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
80	2020-10-12	morglbl 2011-08-28	n/a	aud	224637136	Short SBD perhaps	224635521	0.99999281062771400000	1615	0.99999281062771400000	1.00000718942397000000	-0.00071894239737080300	-7.18942397370803000000	0.000718942
81
82	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Computed Shorter Source Length	Computed Ratio	Enter Difference Here:	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
83	2021-04-07	JTE 2011-04-08	T294	longer SBD	250138176	Shorter 4022 feed from stack	250122930	0.99993904968748200000	15246	0.99993904968748200000	1.00006095402769000000	-0.00609540276854670000	-60.95402768546700000000	-0.0060954 I still hear flanging, no bueno
84
85	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Computed Shorter Source Length	Computed Ratio	Enter Difference Here:	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
86	2021-05-06	WAV > PMD661 > analog > DA-302 > DAT > s/Pdif > PMD661	18 Doom Bot Dust	DA302 > PMD661>SD card	1637590	original WAV file from official CD	1636571	0.99937774412398700000	1019	0.99937774412398700000	1.00062264331948000000	-0.06226433194771450000	-622.64331947714500000000	very short sample let's use .06226 OH THAT IS RIGHT AUDACITY ONLY GOES TO 0.062 on the latest v2... gotta use 2.1.0 if you care -0.062 is about 7 samples off but that shows that the math is about right.
87
88					SHEETS BELOW ARE FOR AUDACITY v 2.42 or later				SHEETS BELOW ARE FOR AUDACITY v 2.42 or later					SHEETS BELOW ARE FOR AUDACITY v 2.42 or later
89	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Computed Shorter Source Length	Computed Ratio	Enter Difference Here:	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
90	2021-07-02	Indecision 20210619	sbd vs mics	SBD	199083099	mics	199087291	1.00002105653378000000	-4192	1.00002105653378000000	0.99997894390958400000	0.00210560904161383000	21.05609041613830000000	-0.002 is all audacity can take. TRY TYPING IN A LENGTH, MORSTY!
91	Work Date	Fileset Name	File Name	Longer Source Name	ENTIRE CLIP Length	Shorter Source Name	TELL CHANGE SPEED THIS IS WHAT YOU WANT:	Computed Ratio	Computed Difference	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
92	2021-07-02	Indecision 20210619	SBD PT 1	SBD	224908400	mics	224913135.8	1.00002105653378000000	-4735.791323	1.00002105653378000000	0.99997894390958400000	0.00210560904160273000	21.05609041602730000000	AUDACITY 2.4.2 LETS YOU TYPE IN VALUES AND THEN IT ADJUSTS WITH PRECISION!
93	2021-07-02	Indecision 20210619	pt 2	SBD	280839228	mics	280845141.5	1.00002105653378000000	-5913.500692	Ratio	0.99997894390958400000	0.00210560904161383000	21.05609041613830000000	AUDACITY 2.4.2 LETS YOU TYPE IN VALUES AND THEN IT ADJUSTS WITH PRECISION!
94	2021-07-02	Indecision 20210619	pt 3	SBD	20416558	mics	20416987.9	1.00002105653378000000	-429.9019433	1.00002105653378000000	0.99997894390958400000	0.00210560904161383000	21.05609041613830000000	AUDACITY 2.4.2 LETS YOU TYPE IN VALUES AND THEN IT ADJUSTS WITH PRECISION!
95
96	Work Date	Fileset Name	File Name	Longer Source Name	Longer Source Length	Shorter Source Name	Computed Shorter Source Length	Computed Ratio	Enter Difference Here:	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
97		INdecsion Korg	sbd vs mics	KORG mics	199083099	KORG SBD	199078907	0.99997894346621600000	4192	0.99997894346621600000	1.00002105697717000000	-0.00210569771714741000	-21.05697717147410000000	CORRECTED SIGN ON DIFFERENCE
98	Work Date	Fileset Name	File Name	Longer Source Name	ENTIRE CLIP Length	Shorter Source Name	TELL CHANGE SPEED THIS IS WHAT YOU WANT:	Computed Ratio	Computed Difference	Ratio	Reciprocal	Audacity %S.C.	Extra Precison	Notes
99	2021-07-07	INdecsion Korg	pt 1	SBD	224808961	mics	224804227.3	0.99997894346621600000	4733.697482	0.99997894346621600000	1.00002105697717000000	-0.00210569771712521000	-21.05697717125210000000	AUDACITY 2.4.2 LETS YOU TYPE IN VALUES AND THEN IT ADJUSTS WITH PRECISION!
100	2021-07-02	INdecsion Korg	pt 2	SBD	280839228	mics	280833314.5	0.99997894346621600000	5913.500692	0.99997894346621600000	1.00002105697717000000	-0.00210569771712521000	-21.05697717125210000000	AUDACITY 2.4.2 LETS YOU TYPE IN VALUES AND THEN IT ADJUSTS WITH PRECISION!