So I'm a massive procrastinator and decided to order all the states by size and compile them into a table for fun (instead of studying for my last 2 finals). Not too bad, right? Well, little did I know that this adventure would turn out to be quite the task.

I started by going through and using the newgrounds length for all the songs. This got me the majority of the way there, but surprisingly there were like 8 songs that had the same length listed. I then just opened the files up in apple music, and found that there was a way to get it to tell you the precise length beyond the 1 second mark and using that I was able to order the majority of the rest of them (barring the strange fact that apple music and newgrounds lengths didn't always agree). You'd think that would be the end of it, right?

Except no. New Jersey and Delaware happened to be the EXACT SAME LENGTH on apple music (1:28.424) despite having different tempos.

Because they have unrelated tempos, I obviously thought this was incorrect. I mean, apple music isn't known to be the most accurate, and surely they wouldn't be the exact same?

So I did some more digging and found out you could compute file size of mp3 files using the bitrate and length of the song using the following formula:

Size = length*bitrate/8192

Where the 8192 was just there to deal with the kbps vs megabytes.

Apple music said that New Jersey was 2.2 mb, so I solved the formula above for length and got

Length = 8192*size/bitrate

Using this formula, I computed the length of both New Jersey and Delaware.

And they were several seconds off from both NG and apple music. I'm not sure what is wrong with that formula, but then I tried another approach where I converted 2.2 mb to kb (17600) and divided 17600 over the bitrate (which was 192 kbps) (this is effectively just using the units, kb/s vs mb vs s) and got a more accurate, but still incorrect length of the song.

At this point I was about to give up hope, but I had one last idea. Why not just plug the mp3s into FL mobile and visually verify the lengths?

You won't believe the results; just see for yourself.

(max zoom)

New Jersey and Delaware ARE THE EXACT SAME LENGTH. I had no idea. Please let me know if you guys have any other ways to verify that because FL mobile could technically be wrong too. But I think this is finally a satisfactory answer for me.

Well that was a waste of 3 hours. Enjoy the spreadsheet below.

The reason for the semicolons is because excel is stupid when it comes to decimals and likes to round everything off, so it was the only way to get it to not do that.

I find it funny how basically the entire first half is 2020-early 2021 and the second half is late 2021-2023, I think that kinda says something about the quality of my music over the years lol.

I also put em in some charts cause why not.

And a histogram!

TLDR: Time to get back to studying.