Page 1 of 1

My new BPM Bars Time Calculator for everyone

Posted: Fri Apr 14, 2017 12:56 pm
by Paulie
I created this basic Microsoft Excel spreadsheet to help me figure out the right tempo, number of bars, or seconds I need to create a cue of a certain length. Right now this only works with 4/4/ time, I hope to have an update that accounts for other time signatures.

It's quite simple to use, just enter two of the three values to get your unknown value. For example, want to know what tempo you need for 16 bars to fit into 30 seconds? Enter those to values and the tempo cell will give you the answer. Zero out the tool to start over.

Let me know if you find any bugs or have suggestions. I created this on a Mac with a slightly older version of office, I may recreated it a PC since it has a much better version of Excel. I'd like to eventually turn this into a smartphone app (surprisingly I couldn't find one out there that does this).

Microsoft Excel (.xlsx) file is here:
https://app.box.com/s/cgrojvwswsk9aczms62lbqcoq2kep02h

Paulie

Re: My new BPM Bars Time Calculator for everyone

Posted: Sun Apr 16, 2017 11:20 am
by waveheavy
I tried it, but it wouldn't work with my old copy of Office 2000.

Re: My new BPM Bars Time Calculator for everyone

Posted: Mon Apr 17, 2017 12:20 pm
by LamarPecorino
Hey Paulie. Thanks for the cool app. It works perfectly with Open Office. :D

Re: My new BPM Bars Time Calculator for everyone

Posted: Mon Apr 17, 2017 1:53 pm
by edmondredd
you may want to check this also, if you score music to pictures.. it comes in handy
http://www.bandcoach.org/calculators/timeCalc.html

Re: My new BPM Bars Time Calculator for everyone

Posted: Tue Apr 25, 2017 6:45 pm
by annayarbrough
This is handy! Thanks Paulie!

Re: My new BPM Bars Time Calculator for everyone

Posted: Thu Apr 27, 2017 4:33 am
by mojobone
You'd think they'd build this into every DAW. Mine can display bars/beats, absolute time or SMPTE. That's usually enough for me, but there are literally dozens of online calculators.

Re: My new BPM Bars Time Calculator for everyone

Posted: Thu May 11, 2017 6:19 am
by piwacquet
Hey Paulie,

Works great for me in Open Office too. Good tool to have. You are so kind to share with everyone.

Thanks
Mike

Re: My new BPM Bars Time Calculator for everyone

Posted: Mon May 22, 2017 5:53 am
by Tunesmith
Paulie wrote:I created this basic Microsoft Excel spreadsheet to help me figure out the right tempo, number of bars, or seconds I need to create a cue of a certain length. R

Paulie
Thank you Paulie! This is very helpful and thank you for creating and sharing this with us!

Best,
Linda C