Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[MarkCoutinho]

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?

[wer]

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.

[zybex]

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.

[MarkCoutinho]

Thanks guys.
Leaves me to do it manually in one way or another, as I'm not that much of a programming guru 

[zybex]

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!