My PlayDensity habit has slowly been spreading across Southern Wisconsin over the past 7 months. Any day now it's going to jump the shark and go mainstream. Or at least make it to Iowa. Doesn't everybody want to know what their most commonly played songs are‽ I never stop thinking about mine, and yours. I hope that's not kreepy, I'm just curious. With that in mind, I'm ready to release the PlayDensity 2.0 update which has been in public beta testing for the last month.
What began as a simple ratio of (playcount) ÷ (# of days in library) had been updated to exclude songs less than 7 days old by the time Version 1.0 was released. Why 7 days? A song that's played twice in 2 days may not be that special, but one that's played 7 times in 7 days deserves some recognition. So what does v2.0 have to offer? More standardization(!) and a playlist. To account for the increasing variability as the # of Days increases we'll now be taking the logarithmus naturali of each of our variables, and then doing a small correction to convert into percentages.
pd 2.0 = 100(e^(ln(playcount)/ln(# of Days))/100 -1)
Now it's your turn.
⓷ Download this Excel sheet:
⓸ Open the Excel sheet. It'll try to read the exported text file, you'll have to tell it where it is the 1st time you open it by editing the text import settings. Once you've chosen your file the other settings should be set already; click through to 'Finish'.