Display MoreI've reviewed your spreadsheet, and the data contained within doesn't appear to match what's presented in this thread.
In the Weekly_Data tab, Score column, you assign a score based on the formula Score = (1 - (Rank - 1) / 100), so a #1 song has a score of 1, while a #100 song has a score of 0.01.
In the Total_Score tab, you then sum up all the scores for each artist, with, for example, IU coming out on top with 1458.59 points in total.
This conflicts with IU's total of 259.75 shown above. Basically, I'm not seeing how the exponential point distribution function you mentioned earlier is being incorporated.
I was just testing with the linear formula to see how it works. You can copy to your own and change it back.
Surprisingly linear worked pretty well despite the forthcoming. Probably because if an artist has many weeks at middle positions on the charts, they tend to had high positions many weeks before too. Artists with only several weeks at 40-50 won't have the advantages over #1 for too long.
