I'm having a hell of a time right now...
The venue that I have been recording at has given me access to their soundboards so that I can mix them with my audience recordings. Awesome! So I take the SBD (recorded at 48k) and my AUD (also recorded at 48k) and load them in to Audacity v2.1 (I was using the newer version until I read this thread so I uninstalled that and installed 2.1). I lined both of the recordings up at the 0:00:03.725 (178,791 samples) point and then find a common point towards the end of the show, for the soundboard this is 2:12:43.275 (382,237,217 samples) and for the audience this is 2:13:05.196 (383,289,428 samples). I use morst's Audio Speed Converter spreadsheet:
and I get a % speed change of -0.27527696236864200000. I put this in to Audacity (without the negative sign) and run the Change Speed effect on the audience recording:
This is where things get funky...
At 0:00:27 the recordings are off by 77 msecs
At 2:15:00 the recordings are off by 500 msecs
but at 1:08:00 the recordings are off by 6 seconds!
This is my first time trying to combine two sources and I'm going nuts. I don't understand how they could be so close at either end of the show, but so far apart in the middle.