Page 1 of 2

EOY 2017 Songs Spreadsheet Updates

Posted: Thu Dec 07, 2017 1:59 am
by Sweepstakes Ron
Updates will be a bit slow at first due to final exams, but I figured I could show you what's up so far. Remember that once all the lists are filled in, Henrik will add additional formulas to make the list more accurate to how it will be in the next AM update.

The following lists are featured:

USA: Consequence of Sound, Fader, Grammy (nominees), Latin Grammy, Paste, Pretty Much Amazing, Rolling Stone, Treblezine
UK: NME, The Guardian
Rest of the World: Mondosonoro (International) [Spain]

[1] Kendrick Lamar | HUMBLE.
[2] Lorde | Green Light
[3] Charli XCX | Boys
[4] Future | Mask Off / Mask Off (Remix feat. Kendrick Lamar)
[5] Cardi B | Bodak Yellow
[6] Selena Gomez | Bad Liar
[7] Frank Ocean | Chanel
[8] Paramore | Hard Times
[9] Perfume Genius | Slip Away
[10] Calvin Harris feat. Frank Ocean and Migos | Slide
[11] Kendrick Lamar | DNA.
[12] Lil Uzi Vert | XO Tour Llif3
[13] Carly Rae Jepsen | Cut to the Feeling
[14] Kamasi Washington | Truth
[15] Spoon | Hot Thoughts
[16] Sampha | (No One Knows Me) Like the Piano
[17] Drake | Passionfruit
[18] Luis Fonzi and Daddy Yankee | Despacito / Despacito (Remix feat. Justin Bieber)
[19] Stormzy | Big for Your Boots
[20] The National | The System Only Dreams in Total Darkness
[21] Father John Misty | Pure Comedy
[22] SZA feat. Travis Scott | Love Galore
[23] St. Vincent | New York
[24] Slowdive | Sugar for the Pill
[25] Superorganism | Something for your M.I.N.D.
[26] Kelela | LMK
[27] J Hus | Did You See
[28] Portugal. The Man | Feel It Still
[29] Lana Del Rey | Love
[30] Harry Styles | Sign of the Times

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Thu Dec 07, 2017 3:07 am
by Nick
It's pretty awesome how "Truth", a 13 minute long spiritual jazz instrumental, is in the top 20 songs of the year. It's easily one of my favorite pieces of music from this decade.

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Thu Dec 07, 2017 5:50 am
by Setherex
Updated 12/31 through top 382 songs


Re: EOY 2017 Songs Spreadsheet Updates

Posted: Thu Dec 07, 2017 2:46 pm
by JohnnyBGoode
Thanks Sweepsatekes Ron & Setherex. To be pinned?

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Thu Dec 07, 2017 3:25 pm
by BleuPanda
I'm going to be so confused if LCD Soundsystem ends up with an album in the top 5 and nothing in the top 10 songs...where is the love for How Do You Sleep and Tonite?

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Fri Dec 08, 2017 2:00 am
by EGrignon
BleuPanda wrote:I'm going to be so confused if LCD Soundsystem ends up with an album in the top 5 and nothing in the top 10 songs...where is the love for How Do You Sleep and Tonite?
The way I see it, there is no clear choice for the highlight of American Dream. I've seen call the police, how do you sleep and tonite all getting votes here and there, including in lists that are not in the spreadsheet yet.

Really surprised to see Boys at number 3 right now, but that has a lot to do with NME and Guardian ranking it at #2. I think it will be able to hold on to the top 10 but it should slip down a little I think as other lists pour in.

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Fri Dec 08, 2017 1:19 pm
by Illiniq
Nick wrote:It's pretty awesome how "Truth", a 13 minute long spiritual jazz instrumental, is in the top 20 songs of the year. It's easily one of my favorite pieces of music from this decade.
I love the whole EP - the five song suite that precedes Truth is almost as awesome.

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Fri Dec 08, 2017 3:42 pm
by andyd1010
Nick wrote:It's pretty awesome how "Truth", a 13 minute long spiritual jazz instrumental, is in the top 20 songs of the year. It's easily one of my favorite pieces of music from this decade.
I'm not a jazz fan at all, but that song is fantastic. Probably my favorite jazz song since Take Five.

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Sat Dec 09, 2017 10:01 pm
by Jonathon
BleuPanda wrote:I'm going to be so confused if LCD Soundsystem ends up with an album in the top 5 and nothing in the top 10 songs...where is the love for How Do You Sleep and Tonite?
It's definitely odd for an artist who's song ranking is 50 spots higher than their album ranking. I never really felt a monster single on this album though, and This is Happening had way less of a song splash than their previous two albums. Maybe they're simply becoming an album band?

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Mon Dec 11, 2017 7:59 am
by Setherex
Jonathon wrote:
BleuPanda wrote:I'm going to be so confused if LCD Soundsystem ends up with an album in the top 5 and nothing in the top 10 songs...where is the love for How Do You Sleep and Tonite?
It's definitely odd for an artist who's song ranking is 50 spots higher than their album ranking. I never really felt a monster single on this album though, and This is Happening had way less of a song splash than their previous two albums. Maybe they're simply becoming an album band?
"becoming"

There's literally a song on "This Is Happening" that directly addresses your point lol.

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Mon Dec 11, 2017 3:00 pm
by BleuPanda
Setherex wrote:
Jonathon wrote:
BleuPanda wrote:I'm going to be so confused if LCD Soundsystem ends up with an album in the top 5 and nothing in the top 10 songs...where is the love for How Do You Sleep and Tonite?
It's definitely odd for an artist who's song ranking is 50 spots higher than their album ranking. I never really felt a monster single on this album though, and This is Happening had way less of a song splash than their previous two albums. Maybe they're simply becoming an album band?
"becoming"

There's literally a song on "This Is Happening" that directly addresses your point lol.
I'm pretty sure LCD Soundsystem has always been both, only at a disadvantage in the album rank due to their relatively small number of albums. But the three albums they do have are all the way in the top 400, and it looks like American Dream will likely join them.

I feel like they could be in a Lemonade situation, but where Lemonade had "Formation" attached kind of like "A Day in the Life" was on Sgt. Pepper's, American Dream didn't have one song designed to stand out from the rest; "Call the Police" is getting the lead single advantage but I doubt that sticks with time. I'm sure with the album receiving as much acclaim as it is, we'll see it have something like an "Idioteque" on the end of decade lists - Kid A being another album that pretty much let time decide which song was the big hit. A lot of critics are mentioning LCD Soundsystem songs; the problem is they're rarely the same one.

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Mon Dec 11, 2017 9:09 pm
by musicmanminard
Not sure if this is the appropriate forum for this post, but I crosschecked the song list artists vs. the album list artists and found these spelling/format discrepancies (excluding typical variations for featured artists):

Song Artist / Album Artist

(Sandy) Alex G / (Sandy) Alex G. (period on end)
Alvvways / Alvvays
Björk / Bjork
Cécile McLorin Salvant / Cecile McLorin Salvant
Courtney Barnett and Kurt Vile / Courtney Barnett & Kurt Vile
Él Mató a un Policía Motorizado / El Mato a un Policia Motorizado
King Gizzard & The Lizard Wizard / King Gizzard and The Lizard Wizard
Lily Hiatt / Lilly Hiatt
Lindsey Buckingham/Christine McVie / Lindsey Buckingham & Christine McVie
Mark Lanegan / Mark Lanegan Band
Noel Gallagher’s High Flying Birds / Noel Gallagher's High Flying Birds (curly apostrophe vs. straight)
Oumou Sangaré / Oumou Sangare
Playboy Carti / Playboi Carti
Ryuchi Sakamoto / Ryuichi Sakamoto
YoungBoy NBA / NBA Youngboy

Thanks as always for all the hard work in putting these together every year. While I was consolidating, I figured I could help in some small way.

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Wed Dec 13, 2017 9:04 pm
by Henrik
Setherex: Thanks for doing the Spotify playlist again! It’s no rush but when do you think it will be ready? (I figured it would be better to ask than to continue checking several times per day if you have added it to your post above.)

Sweepstakes Ron: Thanks for your work and good luck with the exams! Do not feel pressured to make a spreadsheet update!

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Wed Dec 13, 2017 9:48 pm
by TVFan365
Based on how well "Redbone" is doing on the lists that it has appeared on this year. I have a feeling it would have been number one for 2016 if it were released earlier last year or it would have been number one for 2017 if it was actually released this year. I have a feeling this song is going to be near the top of a lot of decade end lists.

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Wed Dec 13, 2017 11:37 pm
by Setherex
Henrik wrote:Setherex: Thanks for doing the Spotify playlist again! It’s no rush but when do you think it will be ready? (I figured it would be better to ask than to continue checking several times per day if you have added it to your post above.)
Haha, sorry to keep you guessing and checking. It's up! Updated through the top 181.

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Thu Dec 14, 2017 1:21 am
by StevieFan13
I'd be surprised if Stormzy stays that high. He's largely ignored in the American press (sadly, so's Wolf Alice, I think). Also surprised by the lack of love for Foo Fighters. I thought that was a great album myself, and the critics seemed to like it too, but it hasn't gotten much love.

On the bright side, I think Japandroids are showing up more.

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Thu Dec 14, 2017 1:22 am
by StevieFan13
I'd also predict a jump up for St. Vincent's two big songs.

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Sat Dec 16, 2017 7:12 am
by Henrik
Setherex wrote:
Henrik wrote:Setherex: Thanks for doing the Spotify playlist again! It’s no rush but when do you think it will be ready? (I figured it would be better to ask than to continue checking several times per day if you have added it to your post above.)
Haha, sorry to keep you guessing and checking. It's up! Updated through the top 181.
Thanks Setherex!

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Thu Dec 21, 2017 5:28 am
by Nick
Any chance of an update soon, Sweepstakes Ron?

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Thu Dec 21, 2017 5:40 am
by Sweepstakes Ron
Nick wrote:Any chance of an update soon, Sweepstakes Ron?
I finished final exams just a few days ago, so I'm still catching up. I was going to save the next update until Christmas... but it's been quite a while, and I've added quite a bit, so... Here it is!

New sources:

USA: Billboard, Complex, Entertainment Weekly, Gorilla vs. Bear, Noisey, NPR, Pigeons & Planes, Pitchfork, Spectrum Culture, Spin, Uproxx, XXL
UK: Fact, The 405, The Line of Best Fit
Rest of the World: Les Inrocks [France], Mowno [France], Intro [Germany], Zündfunk [Germany], MeHaceRuido (English) [Mexico], MeHaceRudio (Spanish) [Mexico]

[1] Kendrick Lamar | HUMBLE.
[2] Cardi B | Bodak Yellow
[3] Lil Uzi Vert | XO Tour Llif3
[4] Future | Mask Off / Mask Off (Remix feat. Kendrick Lamar)
[5] Lorde | Green Light
[6] Kendrick Lamar | DNA.
[7] Charli XCX | Boys
[8] Frank Ocean | Chanel
[9] Selena Gomez | Bad Liar
[10] Calvin Harris feat. Frank Ocean and Migos | Slide
[11] Carly Rae Jepsen | Cut to the Feeling
[12] Sampha | (No One Knows Me) Like the Piano
[13] Perfume Genius | Slip Away
[14] SZA feat. Travis Scott | Love Galore
[15] Kelela | LMK
[16] King Krule | Dum Surfer
[17] Drake | Passionfruit
[18] Playboi Carti | Magnolia
[19] St. Vincent | New York
[20] Paramore | Hard Times
[21] GoldLink feat. Brent Faiyaz & Shy Glizzy | Crew [2016]
[22] Jay-Z | The Story of O.J.
[23] Luis Fonzi and Daddy Yankee | Despacito / Despacito (Remix feat. Justin Bieber)
[24] Arcade Fire | Everything Now
[25] Stormzy | Big for Your Boots
[26] Kesha | Praying
[27] J Hus | Did You See
[28] Harry Styles | Sign of the Times
[29] Migos | T-Shirt
[30] Yaeji | Raingurl
[31] Lana Del Rey | Love
[32] The National | The System Only Dreams in Total Darkness
[33] Dua Lipa | New Rules
[34] SZA | Drew Barrymore
[35] The War on Drugs | Thinking of a Place
[36] Fever Ray | To the Moon and Back
[37] Portugal. The Man | Feel It Still
[38] Kamasi Washington | Truth
[39] Slowdive | Sugar for the Pill
[40] DJ Khaled feat. Rihanna and Bryson Tiller | Wild Thoughts
[41] Courtney Barnett and Kurt Vile | Over Everything
[42] Phoebe Bridgers | Motion Sickness
[43] Superorganism | Something for your M.I.N.D.
[44] (Sandy) Alex G | Bobby
[45] Jorja Smith X Preditah | On My Mind
[46] Big Thief | Mary
[47] Frank Ocean feat. Jay-Z & Tyler, the Creator | Biking / Biking (Solo)
[48] Sigrid | Don't Kill My Vibe
[49] Vince Staples | Big Fish
[50] Spoon | Hot Thoughts
[51] Father John Misty | Pure Comedy
[52] Jay Som | The Bus Song
[53] J Balvin and Willy William | Mi Gente / Mi Gente (Remix feat. Beyoncé)
[54] SZA | The Weekend
[55] LCD Soundsystem | Call the Police
[56] The xx | On Hold [2016] / On Hold (Jamie xx Remix)
[57] N.E.R.D. feat. Rihanna | Lemon
[58] French Montana feat. Swae Lee | Unforgettable
[59] Jason Isbell and The 400 Unit | If We Were Vampires
[60] Hurray for the Riff Raff | Pa'lante
[61] Björk | The Gate
[62] Thundercat feat. Kenny Loggins & Michael McDonald | Show You the Way
[63] Vince Staples | BagBak
[64] Big Thief | Shark Smile
[65] Shabazz Palaces | Shine a Light
[66] Lorde | Perfect Places
[67] Father John Misty | Ballad of the Dying Man
[68] Haim | Want You Back
[69] LCD Soundsystem | American Dream
[70] Charlotte Gainsbourg | Deadly Valentine
[71] Vince Staples | Yeah Right
[72] Migos feat. Lil Uzi Vert | Bad and Boujee [2016]
[73] Tay-K | The Race
[74] 21 Savage | Bank Account
[75] Alvvays | Dreams Tonite
[76] The War on Drugs | Holding On
[77] Lorde | The Louvre
[78] Algiers | The Underside of Power
[79] Slowdive | Star Roving
[80] The Horrors | Something to Remember Me By
[81] Mount Eerie | Real Death
[82] Creek Boyz | With My Team
[83] Tyler, the Creator feat. Frank Ocean & Steve Lacy | 911/Mr. Lonely
[84] Charly Bliss | Glitter
[85] DeJ Loaf | No Fear
[86] Lorde | Homemade Dynamite
[87] Childish Gambino | Redbone [2016]
[88] Fleet Foxes | Third of May/Ōdaigahara
[89] Feist | Pleasure
[90] Tove Lo | Disco Tits
[91] Julien Baker | Turn Out the Lights
[92] The xx | I Dare You
[93] Phoebe Bridgers | Funeral
[94] Mount Kimbie feat. King Krule | Blue Train Lines
[95] St. Vincent | Los Ageless
[96] YBN Nahmir | Rubbin Off the Paint
[97] Nilüfer Yanya | Baby Luv
[98] LCD Soundsystem | Tonite
[99] MUNA | I Know a Place [2016]
[100] Arca | Desafío

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Thu Dec 21, 2017 7:16 am
by Setherex
Spotify playlist updated through top 241 songs.

https://open.spotify.com/user/126045751 ... kBRPWip8uN

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Thu Dec 21, 2017 11:30 am
by Nick
Thanks for the update!

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Thu Dec 21, 2017 1:50 pm
by Bruno
Thanks, Sweepstakes Ron!

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Fri Dec 22, 2017 7:05 pm
by andyd1010
Thanks Sweepstakes Ron!

Glad to see Praying and Everything Now jump into the top 30, and that Drew Barrymore is close. Surprised Los Ageless isn't doing better. I think it's much better than New York. There are some other great secondary songs that I think are being overlooked because of another standout song on their album.

Arcade Fire - Creature Comfort (not on any USA/UK lists in this update, although I see it barely made Pop Matters)
Father John Misty - Total Entertainment Forever
The War on Drugs - Nothing to Find
Wolf Alice - Formidable Cool
The xx - Say Something Loving; Replica
Kendrick Lamar - Pride

For Wolf Alice, Kendrick Lamar, and The War on Drugs, I liked those songs way better than the critics' top choices, so what do I know. I'm definitely having a disconnect with most of the rap choices this year, so I'll need to come around on some of the merits of this movement.

I'm surprised Laura Marling has been largely snubbed. Wild Fire and Nothing, Not Nearly are fantastic.

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Fri Dec 22, 2017 10:59 pm
by TVFan365
Thanks for the update Sweepstakes Ron! Is there a reason PopMatters wasn't included in the update?

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Fri Dec 22, 2017 11:35 pm
by Sweepstakes Ron
TVFan365 wrote:Thanks for the update Sweepstakes Ron! Is there a reason PopMatters wasn't included in the update?
I just wasn't able to get to every list before releasing the update. It'll be in the next one for sure.

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Thu Dec 28, 2017 3:18 pm
by Future Critic
Am I the only one who thinks this is probably the worst top 10 we've ever had? Bodak Yellow is the second best song of the year? Sorry, but I just don't see it. And I don't understand all the love for XO TOUR Llif3 and Mask Off either. They're alright, but to me they're maybe top 50 songs of the year - not top 5.

Boys is catchy, but even calling that a top 10 song of the year seems like a major stretch to me. And Selena Gomez is able to crack the top 10 by taking the bass line from a Talking Head's song and making it significantly worse?

I can totally get behind HUMBLE., Green Light, DNA., Chanel and Slide though! :)

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Thu Dec 28, 2017 3:33 pm
by andyd1010
Future Critic wrote:Am I the only one who thinks this is probably the worst top 10 we've ever had? Bodak Yellow is the second best song of the year? Sorry, but I just don't see it. And I don't understand all the love for XO TOUR Llif3 and Mask Off either. They're alright, but to me they're maybe top 50 songs of the year - not top 5.

Boys is catchy, but even calling that a top 10 song of the year seems like a major stretch to me. And Selena Gomez is able to crack the top 10 by taking the bass line from a Talking Head's song and making it significantly worse?

I can totally get behind HUMBLE., Green Light, DNA., Chanel and Slide though! :)
I agree. I think the only outstanding song in the top 10 is Green Light. I think XO Tour Llif3 and DNA. are good, Bad Liar and Slide are pretty good, and I haven't been able to get into the other ones, especially not Mask Off.

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Thu Dec 28, 2017 4:54 pm
by santacosta
I don't really worry about this year selections; I'm positive that every shitty decision will be unmade once the Decade End charts come. Just 2 years now :happy-partydance:

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Thu Dec 28, 2017 8:42 pm
by Nick
Future Critic wrote:Am I the only one who thinks this is probably the worst top 10 we've ever had? Bodak Yellow is the second best song of the year? Sorry, but I just don't see it. And I don't understand all the love for XO TOUR Llif3 and Mask Off either. They're alright, but to me they're maybe top 50 songs of the year - not top 5.

Boys is catchy, but even calling that a top 10 song of the year seems like a major stretch to me. And Selena Gomez is able to crack the top 10 by taking the bass line from a Talking Head's song and making it significantly worse?

I can totally get behind HUMBLE., Green Light, DNA., Chanel and Slide though! :)
It's a pretty bad top 10, but there are at least 4 songs here I really like.

Here's how I'd sort the list...

Great tier:

Humble, Boys, Green Light, DNA

Okay tier:

Bad Liar, Chanel, Slide

Bad tier:

Mask Off, XO Tour Llif3

Abysmal tier:

Bodak Yellow

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Fri Dec 29, 2017 12:09 am
by jamieW
Every year I have less in common with the critics. (Just a sign of aging, I suppose - I am about to turn 47.) This year, however, will be the first year I don't give a single song in the top 10 as high as a 7. (Though I do give most a 6, which is my rating for when I kinda like a song but it has no chance at my year-end top 200.) Here's how I'd rank/rate them personally...

Cardi B | Bodak Yellow 6
Kendrick Lamar | DNA. 6 (I much prefer "The Heart Part IV" and "Lust.")
Kendrick Lamar | HUMBLE. 6
Future | Mask Off 6
Lil Uzi Vert | XO Tour Llif3 6
Lorde | Green Light 6 (Prefer "Sober II (Melodrama)" and "Homemade Dynamite.")
Charli XCX | Boys 6
Frank Ocean | Chanel 5
Paramore | Hard Times 5 (I remember the good old days when I used to like this band.)
Selena Gomez | Bad Liar 5 (Prefer "Fetish." I don't get the acclaim for the last two at all.)

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Fri Dec 29, 2017 2:34 am
by panam
I can't wait for the next update ;)

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Fri Dec 29, 2017 7:34 am
by Setherex
Nick wrote:Okay tier:

Chanel, Slide
You have greatly offended me and my people.

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Fri Dec 29, 2017 12:22 pm
by Nick
Setherex wrote:
Nick wrote:Okay tier:

Chanel, Slide
You have greatly offended me and my people.
While I absolutely adore Channel Orange, nothing Frank has put out since then has wowed me. Blonde included.

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Sat Dec 30, 2017 5:42 pm
by fabrizioalbertini
Future Critic wrote:Am I the only one who thinks this is probably the worst top 10 we've ever had? Bodak Yellow is the second best song of the year? Sorry, but I just don't see it. And I don't understand all the love for XO TOUR Llif3 and Mask Off either. They're alright, but to me they're maybe top 50 songs of the year - not top 5.

Boys is catchy, but even calling that a top 10 song of the year seems like a major stretch to me. And Selena Gomez is able to crack the top 10 by taking the bass line from a Talking Head's song and making it significantly worse?

I can totally get behind HUMBLE., Green Light, DNA., Chanel and Slide though! :)

Agree. My Personal Top 10:

1- Pure Comedy (Father John Misty)
2- Sola (Anuel AA)
3- Gold (Brockhampton)
4- The Underside of Power (Algiers)
5- DNA (Kendrick Lamar)
6- 4:44 (Jay-Z)
7- El Farsante (Ozuna)
8- Afterlife (Rina)
9- Living Each Day (Kirin J Callinan)
10- Die 4 You (Perfume Genius)
11- Real Death (Mount Eerie)
12- Little Dark Age (MGMT)
13- O Farao Volto na Tumba (MC Bin Laden)
14- Brujas (Princess Nokia) (technically a 2016 song)
15- Si Tu Novio Te Deja Sola (J Balvin, Bad Bunny)

I just think that the critics are trying to award the most popular songs with an “edgy” sound and discrediting amazing artist that are so obviously better than the ones they choose. They don’t take the time to look for and listen to non-american or new artists, which is probably their job as music critics (to recommend and introduce new artist to a wider audience).

And don’t mistake me, i’m not saying that they should only award new artists as you can see from my list but i just think it’s pretty disgusting that they completely ignore artist from the past decade that have been breaking new ground with their projects (like Death Grips, Big Krit, Ibibio Sound Machine, SOPHIE, Iglooghost, Oh Sees, Ghost, Nails, clipping, Oxbow) and not to mention how they completely ignore Grime, Metal and Latin Genres

I mean, at the end of the day, do you really think that Cardi B, Future, Selena Gomez or Lil Uzi Vert deserve a top ten spot with so many ground breaking artist out there??

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Sun Dec 31, 2017 1:01 am
by Sweepstakes Ron
I've got a treat for you!

New sources:

USA: American Songwriter, HipHopDX, PopMatters, Slant
UK/Ireland: Crack Magazine, Mixmag, The Quietus, State [Ireland]
Rest of the World: The Music [Australia], Indiestyle [Belgium], Knack Focus [Belgium], Radiónica [Colombia], Goûte Mes Disques [France/Belgium], Musikexpress [Germany], NBHAP [Germany], PULS [Germany], Tonspion [Germany], Kalporz [Italy], Noisey en Español [Mexico], Reactor 105.7 [Mexico], Dagsavisen [Norway], Jenesaispop [Spain], Muzikalia [Spain], Aftonbladet [Sweden]

Also, after Tonspion listed the original version of "On Hold" and the Jamie xx remix as separate entries, I decided to separate them on the spreadsheet as well. I don't want this to be a permanent thing, and I think I already figured out the solution, but I'll cross that bridge later, because I want to see how far the remix can get on it's own.

[1] Kendrick Lamar | HUMBLE.
[2] Lorde | Green Light
[3] Cardi B | Bodak Yellow
[4] Kendrick Lamar | DNA.
[5] Lil Uzi Vert | XO Tour Llif3
[6] Future | Mask Off / Mask Off (Remix feat. Kendrick Lamar)
[7] Charli XCX | Boys
[8] Frank Ocean | Chanel
[9] Sampha | (No One Knows Me) Like the Piano
[10] King Krule | Dum Surfer
[11] Calvin Harris feat. Frank Ocean and Migos | Slide
[12] Kelela | LMK
[13] Selena Gomez | Bad Liar
[14] Arcade Fire | Everything Now
[15] Drake | Passionfruit
[16] Perfume Genius | Slip Away
[17] Carly Rae Jepsen | Cut to the Feeling
[18] SZA feat. Travis Scott | Love Galore
[19] St. Vincent | New York
[20] The National | The System Only Dreams in Total Darkness
[21] Fever Ray | To the Moon and Back
[22] Playboi Carti | Magnolia
[23] Portugal. The Man | Feel It Still
[24] Algiers | The Underside of Power
[25] J Hus | Did You See
[26] Harry Styles | Sign of the Times
[27] The War on Drugs | Thinking of a Place
[28] Migos | T-Shirt
[29] Vince Staples | Big Fish
[30] Stormzy | Big for Your Boots
[31] Jay-Z | The Story of O.J.
[32] St. Vincent | Los Ageless
[33] Paramore | Hard Times
[34] GoldLink feat. Brent Faiyaz & Shy Glizzy | Crew [2016]
[35] Luis Fonzi and Daddy Yankee | Despacito / Despacito (Remix feat. Justin Bieber)
[36] Lana Del Rey | Love
[37] Kesha | Praying
[38] Courtney Barnett and Kurt Vile | Over Everything
[39] Slowdive | Sugar for the Pill
[40] Dua Lipa | New Rules
[41] Haim | Want You Back
[42] Thundercat feat. Kenny Loggins & Michael McDonald | Show You the Way
[43] Father John Misty | Pure Comedy
[44] LCD Soundsystem | Call the Police
[45] Yaeji | Raingurl
[46] SZA | Drew Barrymore
[47] The Horrors | Something to Remember Me By
[48] Björk | The Gate
[49] Jorja Smith X Preditah | On My Mind
[50] Lorde | Perfect Places
[51] LCD Soundsystem | Tonite
[52] Superorganism | Something for your M.I.N.D.
[53] Big Thief | Shark Smile
[54] Spoon | Hot Thoughts
[55] Slowdive | Star Roving
[56] Objekt | Theme from Q
[57] Arca | Desafío
[58] DJ Khaled feat. Rihanna and Bryson Tiller | Wild Thoughts
[59] Wolf Alice | Don't Delete the Kisses
[60] The xx | On Hold [2016]
[61] Queens of the Stone Age | The Way You Used to Do
[62] Kamasi Washington | Truth
[63] J Balvin and Willy William | Mi Gente / Mi Gente (Remix feat. Beyoncé)
[64] Sigrid | Don't Kill My Vibe
[65] Jason Isbell and The 400 Unit | If We Were Vampires
[66] Childish Gambino | Redbone [2016]
[67] (Sandy) Alex G | Bobby
[68] Phoebe Bridgers | Motion Sickness
[69] French Montana feat. Swae Lee | Unforgettable
[70] Charlotte Gainsbourg | Deadly Valentine
[71] Tyler, the Creator feat. Frank Ocean & Steve Lacy | 911/Mr. Lonely
[72] The War on Drugs | Holding On
[73] Frank Ocean feat. Jay-Z & Tyler, the Creator | Biking / Biking (Solo)
[74] LCD Soundsystem | American Dream
[75] Father John Misty | Ballad of the Dying Man
[76] The xx | I Dare You
[77] Vince Staples | Yeah Right
[78] The xx | Say Something Loving
[79] Jay Som | The Bus Song
[80] Big Thief | Mary
[81] Bilderbuch | Bungalow
[82] Shabazz Palaces | Shine a Light
[83] Mount Kimbie feat. King Krule | Blue Train Lines
[84] The Black Madonna | He Is the Voice I Hear
[85] Future Islands | Ran
[86] Él Mató a un Policía Motorizado | El tesoro
[87] Arcade Fire | Creature Comfort
[88] Bicep | Glue
[89] SZA | The Weekend
[90] Tove Lo | Disco Tits
[91] LCD Soundsystem | Oh Baby
[92] 21 Savage | Bank Account
[93] Vince Staples | BagBak
[94] Mount Eerie | Real Death
[95] N.E.R.D. feat. Rihanna | Lemon
[96] Phoenix | J-Boy
[97] Lanark Artefax | Touch Absence
[98] alt-J | In Cold Blood
[99] Grizzly Bear | Mourning Sound
[100] Cigarettes After Sex | Apocalypse
[101] Aldous Harding | Imagining My Man
[102] Alvvays | Dreams Tonite
[103] Phoenix | Ti Amo
[104] Julien Baker | Turn Out the Lights
[105] Hurray for the Riff Raff | Pa'lante
[106] Migos feat. Lil Uzi Vert | Bad and Boujee [2016]
[107] Porter | Cuxillo
[108] Fleet Foxes | Third of May/Ōdaigahara
[109] Tay-K | The Race
[110] The Blaze | Territory
[111] Tove Styrke | Say My Name
[112] Young Fathers feat. Leith Congregational Choir | Only God Knows
[113] Craig Finn | God in Chicago
[114] Moses Sumney | Quarrel
[115] Phoebe Bridgers | Funeral
[116] Miley Cyrus | Malibu
[117] Feist | Pleasure
[118] Creek Boyz | With My Team
[119] Japanese Breakfast | Road Head
[120] Camila Cabello feat. Young Thug | Havana
[121] Gorillaz feat. DRAM | Andromeda
[122] Ariel Pink | Another Weekend
[123] Ibeyi feat. Kamasi Washington | Deathless
[124] Katy Perry feat. Skip Marley | Chained to the Rhythm
[125] Tyler, the Creator feat. Rex Orange County & Anna of the North | Boredom
[126] Everything Everything | Can't Do
[127] Bad Gyal | Jacaranda
[128] A Boogie Wit Da Hoodie feat. Kodak Black | Drowning
[129] Nine Inch Nails | Less Than
[130] Lorde | The Louvre
[131] Alvvays | In Undertow
[132] YBN Nahmir | Rubbin Off the Paint
[133] Priests | Nothing Feels Natural
[134] Lana Del Rey feat. The Weeknd | Lust for Life
[135] Miguel feat. Travis Scott | Sky Walker
[136] Foxygen | Follow the Leader [2016]
[137] Gorillaz feat. Vince Staples | Ascension
[138] Julia Michaels | Issues
[139] The War on Drugs | Strangest Thing
[140] Four Tet | Planet
[141] IDLES | Mother
[142] Charly Bliss | Glitter
[143] Mount Kimbie feat. Micachu | Marilyn
[144] DeJ Loaf | No Fear
[145] Destroyer | Tinseltown Swimming in Blood
[146] Lorde | Homemade Dynamite
[147] Kodak Black | Tunnel Vision
[148] Los Planetas | Islamabad
[149] Foo Fighters | Run
[150] The National | Day I Die

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Sun Dec 31, 2017 9:40 am
by Federico
Many thanks for the update, Sweepstakes Ron. I hope, everything's fine with your examina. But I think you didn't notice the list of laut.de, which is published and posted since a long time. What about the lists of ANTENNA 3, 1live and Visions, which are all eligible?

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Sun Dec 31, 2017 10:46 am
by Henrik
Thank you so much, Sweepstakes Ron!

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Sun Dec 31, 2017 10:55 am
by panam
Federico wrote:Many thanks for the update, Sweepstakes Ron. I hope, everything's fine with your examina. But I think you didn't notice the list of laut.de, which is published and posted since a long time. What about the lists of ANTENNA 3, 1live and Visions, which are all eligible?
They are new sources and needs to be indicated in the checklist section

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Sun Dec 31, 2017 1:57 pm
by BleuPanda
The top 100 looks like it's taking better shape, and the two new songs in the top 10 are much better than the two that left. Good.

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Sun Dec 31, 2017 7:57 pm
by Sweepstakes Ron
Federico wrote:Many thanks for the update, Sweepstakes Ron. I hope, everything's fine with your examina. But I think you didn't notice the list of laut.de, which is published and posted since a long time. What about the lists of ANTENNA 3, 1live and Visions, which are all eligible?
It just seemed like time for an update. I'll make sure to get those lists in for the next update.

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Sun Dec 31, 2017 8:22 pm
by Setherex
Spotify playlist updated through top 382 songs.

https://open.spotify.com/user/126045751 ... kBRPWip8uN

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Wed Jan 10, 2018 2:54 pm
by Beatsurrender24
Hi there. Thanks a lot for creating this spreadsheet – it's a really useful way of discovering great songs that I may have missed last year.

I'm a little confused by some of the maths, though. From what I can tell from a quick look over the formulae, the final song on a list receives the same score as the final song on any other list, regardless of how long the list is. So, for example, Something Just Like This by The Chainsmokers was named the 50th best song of 2017 in Uproxx's Top 50, and it therefore has approximately the same score as On + Off by Maggie Rogers, which Pitchfork named the 100th best song of 2017 in their Top 100.

Doesn't this mean that the spreadsheet is biased towards longer lists? The song that Pitchfork named as the 50th best of 2017 (Show You the Way by Thundercat) would have received twice the score of Something Just Like This, even though they were both at the same position (number 50) on their respective lists.

If you follow that through to its logical conclusion, that would then mean that, for example, being named the third best song on Reactor 105.7's list (106 entries long) is worth almost 11 times more than being named the third best song on The Music's list (only 10 entries long), heavily biasing the spreadsheet in Reactor 105.7's favour. This seems a little unintuitive to me. Surely a song's position on a list should be worth the same score irrespective of how long the list is, or how many other songs are beneath it?

Anyway, those are just my thoughts. It's your spreadsheet, so you can compile it however you want. Apologies if I'm reading the maths completely wrong and misrepresenting your calculations. Thanks again for the great work!

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Wed Jan 10, 2018 3:17 pm
by BleuPanda
Beatsurrender24 wrote:Hi there. Thanks a lot for creating this spreadsheet – it's a really useful way of discovering great songs that I may have missed last year.

I'm a little confused by some of the maths, though. From what I can tell from a quick look over the formulae, the final song on a list receives the same score as the final song on any other list, regardless of how long the list is. So, for example, Something Just Like This by The Chainsmokers was named the 50th best song of 2017 in Uproxx's Top 50, and it therefore has approximately the same score as On + Off by Maggie Rogers, which Pitchfork named the 100th best song of 2017 in their Top 100.

Doesn't this mean that the spreadsheet is biased towards longer lists? The song that Pitchfork named as the 50th best of 2017 (Show You the Way by Thundercat) would have received twice the score of Something Just Like This, even though they were both at the same position (number 50) on their respective lists.

If you follow that through to its logical conclusion, that would then mean that, for example, being named the third best song on Reactor 105.7's list (106 entries long) is worth almost 11 times more than being named the third best song on The Music's list (only 10 entries long), heavily biasing the spreadsheet in Reactor 105.7's favour. This seems a little unintuitive to me. Surely a song's position on a list should be worth the same score irrespective of how long the list is, or how many other songs are beneath it?

Anyway, those are just my thoughts. It's your spreadsheet, so you can compile it however you want. Apologies if I'm reading the maths completely wrong and misrepresenting your calculations. Thanks again for the great work!

The problem is, if you were to simply make every position worth the same no matter the size of the list, it harms a lot of songs that don't make smaller lists simply due to lack of space. I believe the main purpose to having such a scale is so that not appearing on a list is generally the same value. I'm not sure what the numbers in this case are, but imagine a scale where rank 1-100 were given 100-1 points depending on their rank. In a list with 100 songs, the difference between being #100 and #101 is essentially 1 point. If a list only contains 10 songs, the difference between #10 and #11 would be 91 points! That would give a lot of weight towards lists that frankly give us less information to actually work with, and gives an unfair advantage to those few songs that manage to make short lists. The issue isn't raw value as much as the difference assigned between positions.

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Wed Jan 10, 2018 8:09 pm
by andyd1010
Interesting. So longer lists allocate way more points than shorter lists - per song in addition to the larger number of songs. I didn't realize that. I can see the pros and cons of both approaches. I have a similar project I've mentioned before, and I initially went with Sweepstakes Ron's approach before switching to Beatsurrender24's approach. But I just don't give any points to songs that don't appear on a list, which makes it a little different than the problem BleuPanda mentions about assigning an appropriate amount of points to songs that didn't make the cut.

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Wed Jan 10, 2018 8:59 pm
by BleuPanda
andyd1010 wrote:Interesting. So longer lists allocate way more points than shorter lists - per song in addition to the larger number of songs. I didn't realize that. I can see the pros and cons of both approaches. I have a similar project I've mentioned before, and I initially went with Sweepstakes Ron's approach before switching to Beatsurrender24's approach. But I just don't give any points to songs that don't appear on a list, which makes it a little different than the problem BleuPanda mentions about assigning an appropriate amount of points to songs that didn't make the cut.

Well, it's not like anyone's assigning points to songs that don't appear on a list; the problem is how much higher than zero the songs that are on the list are getting. Being #3 on a list of the top 100 songs is different than being #3 on a top 10. In the end, what really matters is the point difference, not the total value of points. So, in my example distribution, every song ranked outside the top 100 would be 98 points less than song #3; but there are 97 songs that have smaller differences! The problem is that smaller lists have an additional 90 songs that we gain no information on. To me, with a top 100 list, I can go ahead and agree that the point distribution between an imagined #101 and #200 would be so small that it wouldn't matter; but for a top 10 list, I think the imagined difference between the non-existent #11 and #101 does matter. Somewhere out there is a song that should be getting 90 points that isn't (if I'm using 100 as the ideal size).

The easiest solution is to lower that size difference; it's messy, but you need some method that accommodates for different list sizes. In other words, it's better to treat every unranked song as #11 if the list only has 10 songs. Why should they be treated as #101, other than the fact that other lists go to 100? That's essentially what using a flat rate suggests. A flat rate statistically gives more weight to smaller lists; which I hope we would agree is a bad thing, right?

In a way, you are always assigning every song points; zero is a value. It's all relative.


Of course, this is just me giving my own analysis for why there should be different weighing based off the size of a list; Henrik likely has entirely different reasons.

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Thu Jan 11, 2018 2:40 pm
by andyd1010
I made a new topic yesterday in the EOY 2017 thread called "Ideal Point Distribution for Lists of Different Lengths" in case anyone wants to discuss the topic further. I didn't want the discussion to totally take over this thread, but I am interested figuring out the best system, since it's a topic that will be relevant to many lists used on the site and on the forum.

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Fri Jan 12, 2018 3:29 pm
by Harold
Sweepstakes Ron, can you please post or PM me a list of the sources you've added/are planning to add to the spreadsheet since the last posted update? I want to make sure I add the album lists from those sources (if they have them) to my spreadsheet as well. Thanks!

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Fri Jan 19, 2018 6:29 pm
by Romain
I never listened or even heard the first 13 songs of the list this year. :o (and only listened or heard 19 of the top 100 songs).

I wonder what's really going on and how is it possible as I listen and search for music all year round.

Re: EOY 2017 Songs Spreadsheet Updates

Posted: Sat Jan 20, 2018 7:49 am
by Henrik
Sweepstakes Ron wrote:Remember that once all the lists are filled in, Henrik will add additional formulas to make the list more accurate to how it will be in the next AM update.
Do you plan to post a ”final” update before the end of February? I’ll be back from a trip to Kenya on March 1st and it would be great if I could add the additional formulas then.