Hello everyone - I posted this in the Top 50 thread pinned at the top, but it was suggested I should probably make this into its own thread. Hopefully you will find this interesting. Here is my post from the other thread (with a couple of modifications) . . .
I took all of the top 50 lists that have been posted thus far and listed every selection in a spreadsheet including Album, Artist, Year of Release, and Forum User. I also assigned points to each User's list based on their album ranking. Their top ranked album received 50 points, 2nd ranked got 49 and so on. If more than 50 albums were listed, the extra albums each received 1 point as if it were ranked 50th.
I combined some artists to hopefully simplify things. Here are the combinations:
Porcupine Tree/Steven Wilson/No-Man/Bass Communion (I didn't include Blackfield as that seems to be more of a collaboration, and one that SW is taking a step back from)
Devin Townsend solo projects/Strapping Young Lad
Arjen Lucassen/Ayreon/Star One
maudlin of the Well/Kayo Dot
Dave Matthews Band/Dave Matthews
Let me know if something doesn't make sense about these or if you think others should be combined that I have missed.
Now onto the good stuff.
Here is the link to the google spreadsheet:
https://docs.google.com/spreadsheet/ccc?key=0Av7hhWXD5VkadEtTOTNyN0ZfdTZaWWF3N3BjOFROeGcFirst tab shows how the points were distributed by year. Interesting that the odd years of the 2000's seem to be the most popular. And the only year to be ranked ahead of any of any year beyond 2000 was 1999. 1992 made a good showing, although more than half those points came from one album (I&W, obviously). 1975 was also impressive, primarily due to Wish You Were Here.
Second tab is the combined album ranking. This is pretty much what I was shooting for when I started this project. Gives an aggregate ranking from all the lists - self explanatory. Probably not a lot of surprises if you've been following the various threads. I know I am going to be going through this list to see what I have and see what I want to check out next.
Third tab is a ranking by artist. Also includes how each artist's albums stack up. Formatting isn't ideal, but I was trying to import from a more robust excel file. Sorry.
Anyway, I thought it was interesting info and I will be updating this periodically as more people continue to post their lists. I also want to give everyone access to the database I compiled for these summaries. That way, if someone is interested in checking out a particular album, they can go back and see who ranked it where and also go find their thread to see what they said about it. I just need to figure out the best way to do that. Maybe another google spreadsheet is the best option.
Lastly, if you see any errors, please let me know. I tried to eliminate any duplicate Album/Artist listings that might have been caused by incorrect spellings or an extra space at the end of the entry. I keep finding those every time I comb through the data.