EOD 1990s Spreadsheet

Post Reply
Mason
Wannabe
Posts: 106
Joined: Wed Dec 11, 2019 6:01 pm

EOD 1990s Spreadsheet

Post by Mason »

I made a '90s EOD spreadsheet for lists on AM that came out in either 1999 or 2000. I used one of the various 2010s EOD album spreadsheet updates as a template (I left any formulas alone). I don't know the formulas or how they work, so if there are any errors with the formulas I'm going to need help fixing them.

Here is the spreadsheet:
album1990s.xlsx
Some notes:
  • I used Discogs for the album release years. In hindsight this might have been a mistake, because as far as I'm aware AM uses RYM for its dates. Most of the dates should be correct, though, but please tell me if there are any errors I may have missed.
  • This will be a point of contention, but because I wanted to include every placement on every list, compilation albums are included.
  • The Pause and Play column has 99 albums instead of 100, because in the original list posted on their website (which you can find in the link provided in the sheet), they listed Beastie Boys' 'Check Your Head' twice.
  • In the rocklist.net page for the Q list, there are only 89 albums, because whoever transcribed the list forgot an album from 1992. Through some research on AM I discovered the missing album to be The Orb's 'U.F.Orb'.
  • The 1996 Christie Front Drive album is labeled as 'Stereo' on LostAtSea's website. This looks to be a mistake, as according to RYM the album is self-titled. Its correct name is listed on the spreadsheet.
  • The Q list is the most interesting in terms of format, and I wanted to explain how I handled the list. For how the list is formatted, the rocklist.net page here lays it out pretty well. For how I added the list to the spreadsheet, I assigned different values to each album depending on how they were ranked: the album of the decade (Oasis's "Morning Glory") was assigned a value of 1, the albums of the year were assigned a value of 5.5, and all of the other albums were assigned a value of 45.5.
That's all the notes off the top of my head. Once again, if you spot any errors please let me know, though I will need some help with the formulas. Enjoy!
You do not have the required permissions to view the files attached to this post.
Last edited by Mason on Mon Jun 07, 2021 9:18 pm, edited 2 times in total.
Mason
Wannabe
Posts: 106
Joined: Wed Dec 11, 2019 6:01 pm

Re: EOD 1990s Spreadsheet

Post by Mason »

The Top 200:

1 | Nirvana | Nevermind | 1991
2 | Radiohead | OK Computer | 1997
3 | Massive Attack | Blue Lines | 1991
4 | Beck | Odelay | 1996
5 | Portishead | Dummy | 1994
6 | My Bloody Valentine | Loveless | 1991
7 | Primal Scream | Screamadelica | 1991
8 | R.E.M. | Automatic for the People | 1992
9 | DJ Shadow | Endtroducing... | 1996
10 | Public Enemy | Fear of a Black Planet | 1990
11 | Nirvana | In Utero | 1993
12 | Liz Phair | Exile in Guyville | 1993
13 | Beastie Boys | Check Your Head | 1992
14 | U2 | Achtung Baby | 1991
15 | Pavement | Slanted and Enchanted | 1992
16 | Tricky | Maxinquaye | 1995
17 | The Smashing Pumpkins | Mellon Collie and the Infinite Sadness | 1995
18 | Lauryn Hill | The Miseducation of Lauryn Hill | 1998
19 | Pulp | Different Class | 1995
20 | Nine Inch Nails | The Downward Spiral | 1994
21 | Rage Against the Machine | Rage Against the Machine | 1992
22 | Björk | Post | 1995
23 | Jane's Addiction | Ritual De Lo Habitual | 1990
24 | Smashing Pumpkins | Siamese Dream | 1993
25 | Red Hot Chili Peppers | Blood Sugar Sex Magik | 1991
26 | PJ Harvey | To Bring You My Love | 1995
27 | Dr. Dre | The Chronic | 1992
28 | Jeff Buckley | Grace | 1994
29 | Pavement | Crooked Rain, Crooked Rain | 1994
30 | A Tribe Called Quest | The Low End Theory | 1991
31 | Radiohead | The Bends | 1995
32 | Wu-Tang Clan | Enter the Wu-Tang (36 Chambers) | 1993
33 | Hole | Live Through This | 1994
34 | Slint | Spiderland | 1991
35 | Björk | Debut | 1993
36 | Beastie Boys | Ill Communication | 1994
37 | Blur | Parklife | 1994
38 | Oasis | (What's the Story) Morning Glory? | 1995
39 | Fugazi | In on the Kill Taker | 1993
40 | Soundgarden | Badmotorfinger | 1991
41 | Bob Dylan | Time Out of Mind | 1997
42 | Tortoise | Millions Now Living Will Never Die | 1996
43 | Depeche Mode | Violator | 1990
44 | Roni Size / Represent | New Forms | 1997
45 | Tori Amos | Little Earthquakes | 1991
46 | PJ Harvey | Rid of Me | 1993
47 | The Chemical Brothers | Dig Your Own Hole | 1997
48 | Metallica | Metallica ["The Black Album"] | 1991
49 | Oasis | Definitely Maybe | 1994
50 | Johnny Cash | American Recordings | 1994
51 | Fugees | The Score | 1996
52 | Fugazi | Repeater | 1990
53 | Pet Shop Boys | Behaviour | 1990
54 | Aphex Twin | Selected Ambient Works Volume II | 1994
55 | Stereolab | Emperor Tomato Ketchup | 1996
56 | Pearl Jam | Vs. | 1993
57 | Daft Punk | Homework | 1997
58 | Pearl Jam | Ten | 1991
59 | Nirvana | MTV Unplugged in New York | 1994
60 | The Chemical Brothers | Exit Planet Dust | 1995
61 | Air | Moon Safari | 1998
62 | Happy Mondays | Pills 'n' Thrills and Bellyaches | 1990
63 | Sinéad O'Connor | I Do Not Want What I Haven't Got | 1990
64 | Neil Young and Crazy Horse | Ragged Glory | 1990
65 | Orbital | Orbital ["The Brown Album"] | 1993
66 | Missy Misdemeanor Elliott | Supa Dupa Fly | 1997
67 | The Prodigy | Music for the Jilted Generation | 1994
68 | TLC | CrazySexyCool | 1994
69 | Built to Spill | There's Nothing Wrong with Love | 1994
70 | Pet Shop Boys | Very | 1993
71 | Beck | Mellow Gold | 1994
72 | Sonic Youth | Dirty | 1992
73 | Helmet | Meantime | 1992
74 | Goldie | Timeless | 1995
75 | Tool | Ænima | 1996
76 | The Jon Spencer Blues Explosion | Orange | 1994
77 | Moby | Play | 1999
78 | Mercury Rev | Deserter's Songs | 1998
79 | R.E.M. | Out of Time | 1991
80 | Björk | Homogenic | 1997
81 | Ministry | ΚΕΦΑΛΗΞΘ [Psalm 69: The Way to Succeed & the Way to Suck Eggs] | 1992
82 | Pixies | Bossanova | 1990
83 | Guided By Voices | Bee Thousand | 1994
84 | Weezer | Weezer ["The Blue Album"] | 1994
85 | Pixies | Trompe Le Monde | 1991
86 | Mercury Rev | Yerself Is Steam | 1991
87 | Garbage | Garbage | 1995
88 | World Party | Goodbye Jumbo | 1990
89 | Tom Waits | Bone Machine | 1992
90 | Neutral Milk Hotel | In the Aeroplane Over the Sea | 1998
91 | Built to Spill | Perfect from Now On | 1997
92 | Cocteau Twins | Heaven or Las Vegas | 1990
93 | The Afghan Whigs | Gentlemen | 1993
94 | The Prodigy | The Fat of the Land | 1997
95 | 2Pac | All Eyez on Me | 1996
96 | Elliott Smith | XO | 1998
97 | The Beta Band | The Three EP's | 1998
98 | Green Day | Dookie | 1994
99 | Leftfield | Leftism | 1995
100 | The Verve | Urban Hymns | 1997
101 | Sonic Youth | Goo | 1990
102 | Madonna | Ray of Light | 1998
103 | The Wedding Present | Seamonsters | 1991
104 | Soundgarden | Superunknown | 1994
105 | Sebadoh | Bake Sale | 1994
106 | Mogwai | Young Team | 1997
107 | The Lemonheads | It's a Shame About Ray | 1992
108 | The Boo Radley | Giant Steps | 1993
109 | Disco Inferno | D.I. Go Pop | 1994
110 | The Breeders | Last Splash | 1993
111 | Alanis Morissette | Jagged Little Pill | 1995
112 | Sugar | Copper Blue | 1992
113 | Underworld | Dubnobasswithmyheadman | 1994
114 | Cypress Hill | Cypress Hill | 1991
115 | Jawbox | For Your Own Special Sweetheart | 1994
116 | Kristin Hersh | Hips and Makers | 1994
117 | Carcass | Necroticism – Descanting The Insalubrious | 1991
118 | Sarah MacLachlan | Fumbling Towards Ecstasy | 1993
119 | Uncle Tupelo | Anodyne | 1993
120 | Sublime | Sublime | 1996
121 | Yo La Tengo | I Can Hear the Heart Beating As One | 1997
122 | Kyuss | Welcome to Sky Valley | 1994
123 | Korn | Korn | 1994
124 | Built to Spill | Keep It Like a Secret | 1999
125 | Arrested Development | 3 Years, 5 Months, and 2 Days in the Life of... | 1992
126 | The Young Gods | T.V. Sky | 1992
127 | Mogwai | Come On Die Young | 1999
128 | Belle and Sebastian | If You're Feeling Sinister | 1996
129 | Patti Smith | Gone Again | 1996
130 | Manic Street Preachers | Everything Must Go | 1996
131 | Hum | You'd Prefer an Astronaut | 1995
132 | Shudder to Think | Pony Express Record | 1994
133 | Bruce Springsteen | The Ghost of Tom Joad | 1995
134 | k.d. Lang | Ingénue | 1992
135 | LL Cool J | Mama Said Knock You Out | 1990
136 | Talk Talk | Laughing Stock | 1991
137 | Spiritualized | Lazer-Guided Melodies | 1992
138 | Pearl Jam | No Code | 1996
139 | Alice in Chains | Dirt | 1992
140 | Various Artists | The Simpsons: Songs in the Key of Springfield | 1997
141 | Rollins Band | The End of Silence | 1992
142 | Fatboy Slim | You've Come a Long Way, Baby | 1998
143 | Erykah Badu | Baduizm | 1997
144 | Guns N' Roses | Use Your Illusion I / Use Your Illusion II | 1991
145 | Moby | Everything is Wrong | 1995
146 | Blur | Blur | 1997
147 | Lucinda Williams | Car Wheels on a Gravel Road | 1998
148 | Frank Black | Teenager of the Year | 1994
149 | Aphex Twin | Selected Ambient Works 85-92 | 1992
150 | Stereolab | Transient Random-Noise Bursts With Announcements | 1993
151 | Placebo | Without You I'm Nothing | 1998
152 | Blumfeld | L'Etat Et Moi | 1994
153 | Suede | Dog Man Star | 1994
154 | Faith No More | Angel Dust | 1992
155 | Nick Cave and the Bad Seeds | The Good Son | 1990
156 | Matthew Sweet | Girlfriend | 1991
157 | Wilco | Being There | 1996
158 | Nick Cave and the Bad Seeds | Let Love In | 1994
159 | Spiritualized | Ladies and Gentlemen We Are Floating in Space | 1997
160 | Pearl Jam | Vitalogy | 1994
161 | Ben Harper | Fight for Your Mind | 1995
162 | Pantera | Vulgar Display of Power | 1992
163 | Low | I Could Live in Hope | 1994
164 | Elliott Smith | Either/Or | 1997
165 | Refused | The Shape Of Punk To Come (A Chimerical Bombination In 12 Bursts) | 1998
166 | The Verve | A Storm in Heaven | 1993
167 | De La Soul | De La Soul Is Dead | 1991
168 | Hot Water Music | Forever and Counting | 1997
169 | The Notorious B.I.G. | Ready to Die | 1994
170 | Monster Magnet | Spine of God | 1991
171 | Regurgitator | Unit | 1997
172 | Tindersticks | Tindersticks | 1993
173 | Massive Attack | Mezzanine | 1998
174 | D'Angelo | Brown Sugar | 1995
175 | Yo La Tengo | Electr-O-Pura | 1995
176 | Sepultura | Roots | 1996
177 | Castor | Tracking Sounds Alone | 1997
178 | Fugazi | Steady Diet of Nothing | 1991
179 | Fugazi | Red Medicine | 1995
180 | Marilyn Manson | Antichrist Superstar | 1996
181 | Billy Bragg and Wilco | Mermaid Avenue | 1998
182 | Portishead | Portishead | 1997
183 | Cornershop | When I Was Born for the 7th Time | 1997
184 | The Sundays | Reading, Writing, and Arithmetic | 1990
185 | Chamberlain | The Moon My Saddle | 1998
186 | Suede | Suede | 1993
187 | OutKast | Aquemini | 1998
188 | The Beach Boys | The Pet Sounds Sessions | 1997
188 | The Dismemberment Plan | The Dismemberment Plan Is Terrified | 1997
188 | Temple of the Dog | Temple of the Dog | 1991
191 | Lenny Kravitz | Mama Said | 1991
192 | The Flaming Lips | Zaireeka | 1997
193 | Sleater-Kinney | Dig Me Out | 1997
194 | Nas | Illmatic | 1994
195 | The Orb | The Orb's Adventures Beyond the Ultraworld | 1991
196 | Various Artists | Law of the Jungle | 1994
197 | You Am I | Sound As Ever | 1993
198 | The Sea and Cake | The Fawn | 1997
199 | Weezer | Pinkerton | 1996
200 | Melvins | Houdini | 1993
User avatar
Holden
Never Going Back Again
Posts: 3781
Joined: Wed Nov 20, 2019 11:06 pm

Re: EOD 1990s Spreadsheet

Post by Holden »

Hard to argue with the results
"The better a singer's voice, the harder it is to believe what they're saying."
User avatar
Henrik
Site Admin
Posts: 6439
Joined: Sun Feb 05, 2012 10:09 am
Location: Älvsjö, Stockholm, Sweden
Contact:

Re: EOD 1990s Spreadsheet

Post by Henrik »

Mason, this is fantastic (and unexpected)! Thanks a lot!!

I will add it to the main AM site sometime next week.
Everyone you meet fights a battle you know nothing about. Be kind. Always.
Mason
Wannabe
Posts: 106
Joined: Wed Dec 11, 2019 6:01 pm

Re: EOD 1990s Spreadsheet

Post by Mason »

Henrik wrote: Mon Jun 07, 2021 7:45 pm Mason, this is fantastic (and unexpected)! Thanks a lot!!

I will add it to the main AM site sometime next week.
Awesome! Glad you enjoyed it! :D
User avatar
Holden
Never Going Back Again
Posts: 3781
Joined: Wed Nov 20, 2019 11:06 pm

Re: EOD 1990s Spreadsheet

Post by Holden »

I’m always surprised by how highly Blue Lines ranks. I absolutely adore the album (better than OK Computer and Nevermind in my opinion) but it often feels like I’m in the minority with that opinion.
"The better a singer's voice, the harder it is to believe what they're saying."
Jackson
Into the Groove
Posts: 2075
Joined: Sun Feb 12, 2012 6:05 am
Location: Los Angeles

Re: EOD 1990s Spreadsheet

Post by Jackson »

Mason wrote: Sun Jun 06, 2021 9:12 pm 13 | Beastie Boys | Check Your Head | 1992
23 | Jane's Addiction | Ritual De Lo Habitual | 1990
39 | Fugazi | In on the Kill Taker | 1993
44 | Roni Size / Represent | New Forms | 1997
These ones stood out as higher than they would probably be on a modern list...
Mason wrote: Sun Jun 06, 2021 9:12 pm 58 | Pearl Jam | Ten | 1991
78 | Mercury Rev | Deserter's Songs | 1998
79 | R.E.M. | Out of Time | 1991
80 | Björk | Homogenic | 1997
84 | Weezer | Weezer ["The Blue Album"] | 1994
90 | Neutral Milk Hotel | In the Aeroplane Over the Sea | 1998
92 | Cocteau Twins | Heaven or Las Vegas | 1990
96 | Elliott Smith | XO | 1998
98 | Green Day | Dookie | 1994
100 | The Verve | Urban Hymns | 1997
104 | Soundgarden | Superunknown | 1994
121 | Yo La Tengo | I Can Hear the Heart Beating As One | 1997
128 | Belle and Sebastian | If You're Feeling Sinister | 1996
136 | Talk Talk | Laughing Stock | 1991
149 | Aphex Twin | Selected Ambient Works 85-92 | 1992
159 | Spiritualized | Ladies and Gentlemen We Are Floating in Space | 1997
187 | OutKast | Aquemini | 1998
194 | Nas | Illmatic | 1994
199 | Weezer | Pinkerton | 1996
...and these are more acclaimed today.
Post Reply

Return to “Music, Music, Music...”