Regarding calculating the BPM, it was getting much more complicated than I expected. There's probably more than one way to solve the problem using math, but after reading the math on the link below, I gave up doing it automatically, and decided a manual approach was better. So I created a new macro and uploaded it to the macro forums page on this site.
Here's the page that described the math needed to calculate the BPM of a song using a 2 second sample of audio from the song.
https://www.clear.rice.edu/elec301/Projects01/beat_sync/beatalgo.html