INTERACT FORUM
More => Old Versions => JRiver Media Center 27 for Windows => Topic started by: MarkCoutinho on January 08, 2021, 01:08:29 am
-
Hi all,
I hope and think this is an easy question for some of you.
This is what I want:
- I have weekly playlists of the Top 40 in MC
- the number 1 of that week receives 40 points, number 2 receives 39, .... number 40 receives 1 point
- the value of all the weeks that a song is in the Top 40 has to be added up. So if a song for instance was 4 weeks in the Top 40 on number 35, 30, 25 and 33, the total points would be 41 points
Is it possible to do such a thing in one or two calculated fields?
-
I'm going to say no.
A slightly more expansive answer: Technically yes, the calculations can be achieved. But not with just "one or two calculated fields" and Bob's your uncle, and not without a level of cumbersomeness that you would consider unacceptable. So no.
-
This is best done with some external script/tool that reads the playlists and computes the aggregated scores. McUtils can likely be used for this - but it requires some programming knowledge.
Alternatively, you could paste the playlists into Excel (rows 1 to 40, and 1 column per week), and write some VBA function to compute the data and show it in another sheet. Again, some programming required.
-
Thanks guys.
Leaves me to do it manually in one way or another, as I'm not that much of a programming guru :-\
-
You can just use the compiled stats from some site:
https://www.billboard.com/charts/hot-100 (sort by Wks On Chart)
Of course, you'd still need to get the info into MC to create the corresponding playlist.
PS: This is amazing - The Dark Side of The Moon, 955 weeks on the Top200!