EOY 2019 Songs Spreadsheet Updates

Critics’ end of year 2019 lists.
User avatar
Sweepstakes Ron
Die Mensch Maschine
Posts: 2234
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron » Sat Dec 07, 2019 2:07 am

Sources:
Latin Grammy (US)
Grammy (US) [nominees only]
Treblezine (US)
Paste (US)
Uproxx (US)
Revolver (US)
Consequence of Sound (US)
FLOOD Magazine (US)
Rolling Stone (US)
The Guardian (UK)
NBHAP (Germany)
MeHaceRuido [Spanish] (Mexico)
MeHaceRuido [English] (Mexico)

1 | Sharon Van Etten | Seventeen
2 | Billie Eilish | Bad Guy
3 | Lizzo | Juice
4 | Big Thief | Not
5 | Lil Nas X feat. Billy Ray Cyrus | Old Town Road
6 | Angel Olsen | Lark
7 | Clairo | Bags
8 | FKA twigs | Cellophane
9 | Vampire Weekend | Harmony Hall
10 | Tyler, the Creator | Earfquake
11 | Mannequin Pussy | Drunk II
12 | Charli XCX feat. Christine and the Queens | Gone
13 | Lana Del Rey | The Greatest
14 | Denzel Curry | Ricky
15 | Strand of Oaks | Weird Ways
16 | Rosalía and J Balvin | Con altura
17 | Bon Iver | Hey, Ma
18 | Stella Donnelly | Old Man
19 | DaBaby | Suge
20 | Lizzo | Truth Hurts [2017]
You do not have the required permissions to view the files attached to this post.
Splish splash, I was raking in the cash

User avatar
Sweepstakes Ron
Die Mensch Maschine
Posts: 2234
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron » Sat Dec 07, 2019 2:09 am

Again, please let me know if any song on the spreadsheet was released in an earlier year!
Splish splash, I was raking in the cash

User avatar
mileswide
Full of Fire
Posts: 1207
Joined: Wed May 01, 2019 5:08 pm
Location: Nottingham, England

Re: EOY 2019 Songs Spreadsheet Updates

Post by mileswide » Sun Dec 08, 2019 11:22 am

There may be more but these are all 2018:

Little Simz - 101 FM and Offence
Post Malone & Swae Lee - Sunflower
Fontaines D.C. - Too Real
Waat a liiv an bambaie when the two sevens clash

User avatar
JohnnyBGoode
Unquestionable Presence
Posts: 656
Joined: Fri Feb 19, 2016 10:11 am

Re: EOY 2019 Songs Spreadsheet Updates

Post by JohnnyBGoode » Mon Dec 09, 2019 9:59 am

Thanks Sweepstakes Ron

Faye Webster - Kingston
Maggie Rogers - Light On
Toro y Moi - Freelance

were 2018

User avatar
mileswide
Full of Fire
Posts: 1207
Joined: Wed May 01, 2019 5:08 pm
Location: Nottingham, England

Re: EOY 2019 Songs Spreadsheet Updates

Post by mileswide » Mon Dec 09, 2019 11:37 am

slowthai feat. Mura Masa - Doorman also 2018

I forgot to say it but great work on putting this all together, Sweepstakes Ron!
Waat a liiv an bambaie when the two sevens clash

panam
Full of Fire
Posts: 1037
Joined: Fri Jul 08, 2016 4:21 am

Re: EOY 2019 Songs Spreadsheet Updates

Post by panam » Tue Dec 10, 2019 4:45 am

Old Town Road is not from 2018?

TVFan365
Strange Fruit
Posts: 50
Joined: Thu Dec 18, 2014 10:16 pm

Re: EOY 2019 Songs Spreadsheet Updates

Post by TVFan365 » Tue Dec 10, 2019 7:39 am

panam wrote:
Tue Dec 10, 2019 4:45 am
Old Town Road is not from 2018?
Yeah Old Town Road is from 2018. The remix with Billy Ray Cyrus is from 2019 though. I've seen both versions mentioned on lists.

User avatar
Henrik
Site Admin
Posts: 5422
Joined: Sun Feb 05, 2012 10:09 am
Location: Älvsjö, Stockholm, Sweden
Contact:

Re: EOY 2019 Songs Spreadsheet Updates

Post by Henrik » Tue Dec 10, 2019 5:13 pm

Thanks for this, Sweepstakes Ron!!!

Will anyone create a spotify playlist for this? I have made a short top 30 list, but I’d be very happy if someone else takes over.
Everyone you meet fights a battle you know nothing about. Be kind. Always.

User avatar
Setherex
Rust Never Sleeps
Posts: 854
Joined: Wed May 09, 2012 2:57 am

Re: EOY 2019 Songs Spreadsheet Updates

Post by Setherex » Tue Dec 10, 2019 5:38 pm

Apologies, I've been super busy. Here's the version I'll keep updated!

Spotify Playlist - Thru Top 500
Last Updated: Dec. 26

Last edited by Setherex on Thu Dec 26, 2019 8:14 am, edited 3 times in total.

User avatar
Setherex
Rust Never Sleeps
Posts: 854
Joined: Wed May 09, 2012 2:57 am

Re: EOY 2019 Songs Spreadsheet Updates

Post by Setherex » Tue Dec 10, 2019 6:10 pm

-- #42: Freddie Gibbs is misspelled.
-- #53: The version listed should mention it is "Hot (Remix)," which includes Travis Scott. The album version is only Young Thug & Gunna. For what it's worth, only one of the two sources listed (Uproxx) specifically mentions the remix over the original.
-- #70: The song seems to be properly titled "Green & Blue."
-- #75: Bad Bunny's "La Romana" is [2018].
-- #100: Nilufer Yanya's "Heavyweight Champion of the World" is [2018].

User avatar
Cold Butterfly
Different Class
Posts: 470
Joined: Sun Dec 09, 2018 2:28 am
Location: Washington D.C. area

Re: EOY 2019 Songs Spreadsheet Updates

Post by Cold Butterfly » Wed Dec 11, 2019 2:10 am

Setherex wrote:
Tue Dec 10, 2019 6:10 pm
-- #42: Freddie Gibbs is misspelled.
You’re right. It should be spelled as either Freddie Kane, Freddie Corleone or Gangsta Gibbs :)

User avatar
Sweepstakes Ron
Die Mensch Maschine
Posts: 2234
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron » Wed Dec 11, 2019 7:26 pm

Setherex wrote:
Tue Dec 10, 2019 5:38 pm
Apologies, I've been super busy. Here's the version I'll keep updated!

Spotify Playlist - Thru Top 100
Last Updated: Dec. 10

Thanks for this, Setherex! But I'm planning to do an update tonight, so be prepared!
Splish splash, I was raking in the cash

User avatar
Sweepstakes Ron
Die Mensch Maschine
Posts: 2234
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron » Wed Dec 11, 2019 9:45 pm

New sources:
Pitchfork (US)
Gorilla vs Bear (US)
NPR (US)
Billboard (US)
The Irish Times [National] (Ireland)
The Irish Times [International] (Ireland)
Fact (UK)
Crack (UK)
Laut (Germany)
Humo (Belgium)

1 | Sharon Van Etten | Seventeen
2 | Billie Eilish | Bad Guy
3 | Big Thief | Not
4 | Lizzo | Juice
5 | Lil Nas X feat. Billy Ray Cyrus | Old Town Road
6 | FKA twigs | Cellophane
7 | Clairo | Bags
8 | Charli XCX feat. Christine and the Queens | Gone
9 | Lana Del Rey | The Greatest
10 | Angel Olsen | Lark
11 | Tyler, the Creator | Earfquake
12 | Vampire Weekend | Harmony Hall
13 | Lana Del Rey | Hope Is a Dangerous Thing for a Woman Like Me to Have – but I Have It
14 | Rosalía and J Balvin | Con altura
15 | Mannequin Pussy | Drunk II
16 | DaBaby | Suge
17 | Normani | Motivation
18 | Lizzo | Truth Hurts [2017]
19 | Thom Yorke | Dawn Chorus
20 | Bon Iver | Hey, Ma
21 | Aldous Harding | The Barrel
22 | Denzel Curry | Ricky
23 | Jenny Hval | Ashes to Ashes
24 | Haim | Summer Girl
25 | Danny Brown | Dirty Laundry
26 | Ariana Grande | NASA
27 | Angel Olsen | All Mirrors
28 | 21 Savage feat. J. Cole | A Lot
29 | Megan Thee Stallion feat. DaBaby | Cash Shit
30 | Strand of Oaks | Weird Ways
31 | (Sandy) Alex G | Gretel
32 | Ariana Grande | 7 rings
33 | Billie Eilish | Bury a Friend
34 | Taylor Swift | Cruel Summer
35 | Vampire Weekend | Sympathy
36 | Stella Donnelly | Old Man
37 | Lil Tecca | Ransom
38 | Polo G feat. Lil Tjay | Pop Out
39 | Jonas Brothers | Sucker
40 | The National | Rylan
41 | Rosalía | Aute Cuture
42 | Toro y Moi | Freelance [2018]
43 | Frank Ocean | In My Room
44 | Jai Paul | He
45 | Georgia | About Work the Dancefloor
46 | FKA twigs | Sad Day
47 | Carly Rae Jepsen | Want You in My Room
48 | Nilüfer Yanya | In Your Head
49 | Pop Smoke | Welcome to the Party
50 | Young Nudy / Playboi Carti | Pissy Pamper (Kid Cudi)
51 | Maggie Rogers | Light On [2018]
52 | Weyes Blood | Movies
53 | Stormzy | Vossi Bop
54 | Mark Ronson feat. Angel Olsen | True Blue
55 | Solange | Binz
56 | Faye Webster | Kingston [2018]
57 | Jay Som | Superbike
58 | Taylor Swift | Lover
59 | Young Thug feat. Gunna | Hot / Hot (Remix feat. Travis Scott)
60 | The Murder Capital | Green & Blue
61 | 100 Gecs | Money Machine
62 | Post Malone and Swae Lee | Sunflower [2018]
63 | The National | Light Years
64 | Saweetie | My Type
65 | Julia Jacklin | Don’t Know How to Keep Loving You
66 | Carly Rae Jepsen | Too Much
67 | Ariana Grande | ghostin
68 | The Highwomen | Highwomen
69 | Khalid | Talk
70 | Charly Bliss | Capacity
You do not have the required permissions to view the files attached to this post.
Splish splash, I was raking in the cash

User avatar
mattadam
Start Me Up
Posts: 21
Joined: Wed Oct 31, 2012 6:14 pm

Re: EOY 2019 Songs Spreadsheet Updates

Post by mattadam » Wed Dec 11, 2019 10:00 pm

I look forward to EOY every year, you guys are awesome. Great website.
Best album of 2013: Reflektor by Arcade Fire

How did it only get an 80 on metacritic!?

User avatar
acroamor
Full of Fire
Posts: 1089
Joined: Sun Apr 15, 2012 3:16 pm
Location: Atlanta, GA

Re: EOY 2019 Songs Spreadsheet Updates

Post by acroamor » Thu Dec 12, 2019 12:03 am

Thought "Movies" would be guaranteed in the top 10. I'm sure it will be in the forum poll, but disappointing here.

TVFan365
Strange Fruit
Posts: 50
Joined: Thu Dec 18, 2014 10:16 pm

Re: EOY 2019 Songs Spreadsheet Updates

Post by TVFan365 » Thu Dec 12, 2019 3:08 am

Is Rolling Stones going to be on the next update?

User avatar
Sweepstakes Ron
Die Mensch Maschine
Posts: 2234
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron » Thu Dec 12, 2019 3:20 am

TVFan365 wrote:
Thu Dec 12, 2019 3:08 am
Is Rolling Stones going to be on the next update?
It was already in the original post.
Splish splash, I was raking in the cash

TVFan365
Strange Fruit
Posts: 50
Joined: Thu Dec 18, 2014 10:16 pm

Re: EOY 2019 Songs Spreadsheet Updates

Post by TVFan365 » Thu Dec 12, 2019 6:35 pm

Oh right, I see it now! Btw "A Lot" by 21 Savage featuring J. Cole was released in 2018.

Jackson
Full of Fire
Posts: 1246
Joined: Sun Feb 12, 2012 6:05 am
Location: Los Angeles

Re: EOY 2019 Songs Spreadsheet Updates

Post by Jackson » Fri Dec 13, 2019 5:29 pm

acroamor wrote:
Thu Dec 12, 2019 12:03 am
Thought "Movies" would be guaranteed in the top 10. I'm sure it will be in the forum poll, but disappointing here.
Seconded. I think it will rise as more lists are added, but it is going to way overperform in the AMF poll. It will definitely be my #1.

User avatar
Setherex
Rust Never Sleeps
Posts: 854
Joined: Wed May 09, 2012 2:57 am

Re: EOY 2019 Songs Spreadsheet Updates

Post by Setherex » Sat Dec 14, 2019 6:16 pm

The Spotify Playlist is updated through the Top 200.

-- #5: Probably should specify that it is "Old Town Road (Remix)," not the original version.
-- #86: Kano's "Class of Deja" features D Double E & Ghetts.
-- #88: Mango x MathMan's "Deep Blue" features Lisa Hannigan.
-- #108: Blueface's "Thotiana" is [2018].
-- #183: Soule's "Love Tonight" features C Cane.
-- #192: Cimafunk's "El Potaje" features Omara Portuondo, Chucho Valdés, Orquesta Aragón & Pancho Amat.
-- #195: Nicholas Britell's "Succession (Main Title Theme)" is [2018].
-- #198: Jamila Woods' "BASQUIAT" features Saba.

panam
Full of Fire
Posts: 1037
Joined: Fri Jul 08, 2016 4:21 am

Re: EOY 2019 Songs Spreadsheet Updates

Post by panam » Sun Dec 15, 2019 8:20 pm

Setherex wrote:
Sat Dec 14, 2019 6:16 pm
The Spotify Playlist is updated through the Top 200.

-- #5: Probably should specify that it is "Old Town Road (Remix)," not the original version.
-- #86: Kano's "Class of Deja" features D Double E & Ghetts.
-- #88: Mango x MathMan's "Deep Blue" features Lisa Hannigan.
-- #108: Blueface's "Thotiana" is [2018].
-- #183: Soule's "Love Tonight" features C Cane.
-- #192: Cimafunk's "El Potaje" features Omara Portuondo, Chucho Valdés, Orquesta Aragón & Pancho Amat.
-- #195: Nicholas Britell's "Succession (Main Title Theme)" is [2018].
-- #198: Jamila Woods' "BASQUIAT" features Saba.
-- #14: Rosalía and J Balvin's "Con altura" features El Guincho

User avatar
mileswide
Full of Fire
Posts: 1207
Joined: Wed May 01, 2019 5:08 pm
Location: Nottingham, England

Re: EOY 2019 Songs Spreadsheet Updates

Post by mileswide » Sun Dec 15, 2019 11:48 pm

More 2018s:

Ava Max - Sweet but Psycho
Billie Eilish - When the Party's Over
Little Simz - Boss
Waat a liiv an bambaie when the two sevens clash

User avatar
Sweepstakes Ron
Die Mensch Maschine
Posts: 2234
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron » Wed Dec 18, 2019 2:54 am

New sources:
Slant (US)
Loud and Quiet (UK)
Dazed (UK)
Q Magazine (UK)
Musikexpress (Germany)
Rolling Stone (Argentina)
Mowno (France)

Something seems to have gone wrong... the "rest of the world" section is giving negative points? Can anyone figure out how to fix this?

1 | Billie Eilish | Bad Guy
2 | Sharon Van Etten | Seventeen
3 | Lizzo | Juice
4 | Lil Nas X feat. Billy Ray Cyrus | Old Town Road (Remix)
5 | Big Thief | Not
6 | Clairo | Bags
7 | FKA twigs | Cellophane
8 | Vampire Weekend | Harmony Hall
9 | Tyler, the Creator | Earfquake
10 | Charli XCX feat. Christine and the Queens | Gone
11 | Lana Del Rey | The Greatest
12 | Rosalía and J Balvin feat. El Guincho | Con altura
13 | Angel Olsen | Lark
14 | Mannequin Pussy | Drunk II
15 | Lana Del Rey | Hope Is a Dangerous Thing for a Woman Like Me to Have – but I Have It
16 | Normani | Motivation
17 | Aldous Harding | The Barrel
18 | Thom Yorke | Dawn Chorus
19 | DaBaby | Suge
20 | Bon Iver | Hey, Ma
21 | Lizzo | Truth Hurts [2017]
22 | Danny Brown | Dirty Laundry
23 | Angel Olsen | All Mirrors
24 | Haim | Summer Girl
25 | FKA twigs | Sad Day
26 | Denzel Curry | Ricky
27 | Stormzy | Vossi Bop
28 | Ariana Grande | 7 rings
29 | Jenny Hval | Ashes to Ashes
30 | Megan Thee Stallion feat. DaBaby | Cash Shit
31 | Stella Donnelly | Old Man
32 | Weyes Blood | Movies
33 | (Sandy) Alex G | Gretel
34 | Ariana Grande | NASA
35 | 21 Savage feat. J. Cole | A Lot [2018]
36 | Nilüfer Yanya | In Your Head
37 | Fat White Family | Feet
38 | Rosalía | Aute Cuture
39 | The National | Rylan
40 | Strand of Oaks | Weird Ways
41 | Lana Del Rey | Doin' Time
42 | Taylor Swift | Lover
43 | Billie Eilish | Bury a Friend
44 | Solange feat. Playboi Carti | Almeda
45 | Georgia | About Work the Dancefloor
46 | Taylor Swift | Cruel Summer
47 | Vampire Weekend | Sympathy
48 | Lil Tecca | Ransom
49 | Polo G feat. Lil Tjay | Pop Out
50 | 100 Gecs | Money Machine
51 | Bruce Springsteen | Hello Sunshine
52 | Jonas Brothers | Sucker
53 | Purple Mountains | All My Happiness Is Gone
54 | Lana Del Rey | Fuck It I Love You
55 | Fontaines D.C. | Big
56 | Toro y Moi | Freelance [2018]
57 | Big Thief | U.F.O.F.
58 | Frank Ocean | In My Room
59 | Jai Paul | He
60 | JPEGMAFIA feat. Helena Deland | Free the Frail
61 | slowthai + Mura Masa | Doorman [2018]
62 | Alex Cameron | Miami Memory
63 | Caroline Polachek | Door
64 | Nick Cave & The Bad Seeds | Bright Horses
65 | Michael Kiwanuka | You Ain't the Problem
66 | Carly Rae Jepsen | Want You in My Room
67 | Kano feat. D Double E & Ghetts | Class of Deja
68 | Pop Smoke | Welcome to the Party
69 | Young Nudy / Playboi Carti | Pissy Pamper (Kid Cudi)
70 | Maggie Rogers | Light On [2018]
71 | Daddy Yankee feat. Snow | Con Calma / Con Calma (Remix with Katy Perry)
72 | Weyes Blood | Andromeda
73 | Mark Ronson feat. Angel Olsen | True Blue
74 | Solange | Binz
75 | Faye Webster | Kingston [2018]
76 | Tame Impala | Borderline
77 | Cate Le Bon | Daylight Matters
78 | Better Oblivion Community Center | Dylan Thomas
79 | Jay Som | Superbike
80 | Young Thug feat. Gunna | Hot / Hot (Remix feat. Travis Scott)
81 | JPEGMAFIA | Jesus Forgive Me, I Am a Thot
82 | The Murder Capital | Green & Blue
83 | Post Malone and Swae Lee | Sunflower [2018]
84 | The National | Light Years
85 | Black Midi | 953
86 | Saweetie | My Type
87 | Julia Jacklin | Don’t Know How to Keep Loving You
88 | The Comet Is Coming | Summon the Fire
89 | MUNA | Number One Fan
90 | Tyler, the Creator | What's Good
91 | Jamila Woods | ZORA
92 | Carly Rae Jepsen | Too Much
93 | Róisín Murphy | Incapable
94 | Ariana Grande | ghostin
95 | The Highwomen | Highwomen
96 | Khalid | Talk
97 | Charly Bliss | Capacity
98 | Little Simz | Boss [2018]
99 | Steve Lacy | Playground
100 | Caribou | Home
You do not have the required permissions to view the files attached to this post.
Splish splash, I was raking in the cash

User avatar
Sweepstakes Ron
Die Mensch Maschine
Posts: 2234
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron » Wed Dec 18, 2019 4:25 am

It seems the problem has something to do with Mowno's entry, as clearing that column changes it back to normal.
Splish splash, I was raking in the cash

User avatar
Henrik
Site Admin
Posts: 5422
Joined: Sun Feb 05, 2012 10:09 am
Location: Älvsjö, Stockholm, Sweden
Contact:

Re: EOY 2019 Songs Spreadsheet Updates

Post by Henrik » Wed Dec 18, 2019 11:50 am

Sorry. I’ll have a look at it tonight.
Everyone you meet fights a battle you know nothing about. Be kind. Always.

Harold
Die Mensch Maschine
Posts: 2124
Joined: Fri Feb 10, 2012 3:56 pm

Re: EOY 2019 Songs Spreadsheet Updates

Post by Harold » Wed Dec 18, 2019 12:26 pm

Sweepstakes Ron wrote:
Wed Dec 18, 2019 2:54 am
Something seems to have gone wrong... the "rest of the world" section is giving negative points? Can anyone figure out how to fix this?
The same thing is happening with the albums spreadsheet - I emailed Henrik about this.

User avatar
Henrik
Site Admin
Posts: 5422
Joined: Sun Feb 05, 2012 10:09 am
Location: Älvsjö, Stockholm, Sweden
Contact:

Re: EOY 2019 Songs Spreadsheet Updates

Post by Henrik » Wed Dec 18, 2019 6:58 pm

Sorry, I'm stuck with work, so you'll have to wait another day or two... :-(
Everyone you meet fights a battle you know nothing about. Be kind. Always.

User avatar
Sweepstakes Ron
Die Mensch Maschine
Posts: 2234
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron » Wed Dec 18, 2019 7:08 pm

Henrik wrote:
Wed Dec 18, 2019 6:58 pm
Sorry, I'm stuck with work, so you'll have to wait another day or two... :-(
No worries, I've got nothing but free time for the next few weeks. Thanks for looking into this.
Splish splash, I was raking in the cash

User avatar
Sweepstakes Ron
Die Mensch Maschine
Posts: 2234
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron » Thu Dec 19, 2019 7:02 pm

Actually, I think I've found the problem. Rows 3 and 4 in hidden columns L through R. You'll see code like LN(1+U3) + LN(1+V3) + LN(1+W3) + ...

For the "rest of the world" section, some of these appear as, for example, LN(1+DX3)+LN(1+DY3)/2+LN(1+DZ3)/2+LN(1+EA3)+LN(1+EB3)/2+LN(1+EC3), etc. A few random columns have their value here divided by two, seemingly causing negative points to display (though the actual rankings seem to be unaffected). Any particular reason for this, Henrik?
Splish splash, I was raking in the cash

User avatar
Sweepstakes Ron
Die Mensch Maschine
Posts: 2234
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron » Fri Dec 20, 2019 6:10 pm

New sources:
Fader (USA)
Spin (USA)
Complex (USA)
NME (UK)
Jenesaispop (Spain)
ANTENA 3 [International] (Portugal)
ANTENA 3 [National] (Portugal)

1 | Billie Eilish | Bad Guy
2 | Sharon Van Etten | Seventeen
3 | Lizzo | Juice
4 | Lil Nas X feat. Billy Ray Cyrus | Old Town Road (Remix)
5 | Big Thief | Not
6 | Clairo | Bags
7 | Tyler, the Creator | Earfquake
8 | Vampire Weekend | Harmony Hall
9 | FKA twigs | Cellophane
10 | Charli XCX feat. Christine and the Queens | Gone
11 | Lana Del Rey | The Greatest
12 | Rosalía and J Balvin feat. El Guincho | Con altura
13 | Angel Olsen | Lark
14 | DaBaby | Suge
15 | Normani | Motivation
16 | Aldous Harding | The Barrel
17 | Mannequin Pussy | Drunk II
18 | Lana Del Rey | Hope Is a Dangerous Thing for a Woman Like Me to Have – but I Have It
19 | Thom Yorke | Dawn Chorus
20 | Ariana Grande | 7 rings
21 | Angel Olsen | All Mirrors
22 | FKA twigs | Sad Day
23 | Bon Iver | Hey, Ma
24 | Georgia | About Work the Dancefloor
25 | Megan Thee Stallion feat. DaBaby | Cash Shit
26 | Michael Kiwanuka | You Ain't the Problem
27 | Haim | Summer Girl
28 | Lizzo | Truth Hurts [2017]
29 | Ariana Grande | NASA
30 | Danny Brown | Dirty Laundry
31 | Fontaines D.C. | Big
32 | Jenny Hval | Ashes to Ashes
33 | Stormzy | Vossi Bop
34 | Nilüfer Yanya | In Your Head
35 | Denzel Curry | Ricky
36 | Billie Eilish | Bury a Friend
37 | The Chemical Brothers | Got to Keep On
38 | Rosalía | Aute Cuture
39 | Taylor Swift | Lover
40 | Purple Mountains | All My Happiness Is Gone
41 | Stella Donnelly | Old Man
42 | Weyes Blood | Movies
43 | Lana Del Rey | Doin' Time
44 | Solange | Binz
45 | Weyes Blood | Andromeda
46 | Solange feat. Playboi Carti | Almeda
47 | The National | Rylan
48 | (Sandy) Alex G | Gretel
49 | Polo G feat. Lil Tjay | Pop Out
50 | 21 Savage feat. J. Cole | A Lot [2018]
51 | Lil Tecca | Ransom
52 | Young Thug feat. Gunna | Hot / Hot (Remix feat. Travis Scott)
53 | Fat White Family | Feet
54 | Strand of Oaks | Weird Ways
55 | Pop Smoke | Welcome to the Party
56 | Dua Lipa | Don't Start Now
57 | Vampire Weekend | This Life
58 | James Blake feat. Rosalía | Barefoot in the Park
59 | Little Simz feat. Cleo Sol | Selfish
60 | Little Simz | Boss [2018]
61 | Taylor Swift | Cruel Summer
62 | Vampire Weekend | Sympathy
63 | Caroline Polachek | So Hot You’re Hurting My Feelings
64 | Girl in Red | Dead Girl in the Pool
65 | Tame Impala | Borderline
66 | 100 Gecs | Money Machine
67 | Bruce Springsteen | Hello Sunshine
68 | Jonas Brothers | Sucker
69 | Tame Impala | Patience
70 | Caribou | Home
71 | J Balvin and Bad Bunny | La canción
72 | Lana Del Rey | Fuck It I Love You
73 | Mark Ronson feat. Lykke Li | Late Night Feelings
74 | The 1975 | People
75 | Solange | Stay Flo
76 | Post Malone | Circles
77 | Ariana Grande | ghostin
78 | Toro y Moi | Freelance [2018]
79 | The Highwomen | Highwomen
80 | Steve Lacy | Playground
81 | Big Thief | U.F.O.F.
82 | Frank Ocean | In My Room
83 | Jai Paul | He
84 | JPEGMAFIA feat. Helena Deland | Free the Frail
85 | slowthai + Mura Masa | Doorman [2018]
86 | Alex Cameron | Miami Memory
87 | Rosalía | Milionária
88 | J. Cole | Middle Child
89 | Lil Uzi Vert | Free Uzi
90 | Caroline Polachek | Door
91 | Nick Cave & The Bad Seeds | Bright Horses
92 | Carly Rae Jepsen | Want You in My Room
93 | Sampa The Great | Final Form
94 | Kano feat. D Double E & Ghetts | Class of Deja
95 | Young Nudy / Playboi Carti | Pissy Pamper (Kid Cudi)
96 | Los Punsetes | Una persona sospechosa
97 | Maggie Rogers | Light On [2018]
98 | Daddy Yankee feat. Snow | Con Calma / Con Calma (Remix with Katy Perry)
99 | Mark Ronson feat. Angel Olsen | True Blue
100 | Freddie Gibbs & Madlib feat. Pusha T and Killer Mike | Palmolive
You do not have the required permissions to view the files attached to this post.
Splish splash, I was raking in the cash

Harold
Die Mensch Maschine
Posts: 2124
Joined: Fri Feb 10, 2012 3:56 pm

Re: EOY 2019 Songs Spreadsheet Updates

Post by Harold » Fri Dec 20, 2019 7:22 pm

I copied/pasted the revised formulas into the albums spreadsheet - it seems to have worked. Thanks!

User avatar
Henrik
Site Admin
Posts: 5422
Joined: Sun Feb 05, 2012 10:09 am
Location: Älvsjö, Stockholm, Sweden
Contact:

Re: EOY 2019 Songs Spreadsheet Updates

Post by Henrik » Sat Dec 21, 2019 7:56 pm

Sweepstakes Ron and Harold, I'm sorry for the delay, but now I finally had a look at this.

I use /2 (divisions by 2) to give lower scores to national lists. And this time I planned for you to add those lists in columns GA-HA. In cells Q6-R6 and below there are /2 for the GA-HA columns, but I forgot to change the formulas in cells Q3, Q4, R3 and R4.

If you want to use the GA-HA columns for national lists, you should change the formulas as follows:

Q3: =LN(1+FF3)+LN(1+FG3)+LN(1+FH3)+LN(1+FI3)+LN(1+FJ3)+LN(1+FK3)+LN(1+FL3)+LN(1+FM3)+LN(1+FN3)+LN(1+FO3)+LN(1+FP3)+LN(1+FQ3)+LN(1+FR3)+LN(1+FS3)+LN(1+FT3)+LN(1+FU3)+LN(1+FV3)+LN(1+FW3)+LN(1+FX3)+LN(1+FY3)+LN(1+FZ3)+LN(1+GA3)/2+LN(1+GB3)/2+LN(1+GC3)/2+LN(1+GD3)/2+LN(1+GE3)/2+LN(1+GF3)/2+LN(1+GG3)/2+LN(1+GH3)/2+LN(1+GI3)/2+LN(1+GJ3)/2+LN(1+GK3)/2+LN(1+GL3)/2+LN(1+GM3)/2+LN(1+GN3)/2+LN(1+GO3)/2+LN(1+GP3)/2+LN(1+GQ3)/2+LN(1+GR3)/2

Q4: =LN(1+FF4)+LN(1+FG4)+LN(1+FH4)+LN(1+FI4)+LN(1+FJ4)+LN(1+FK4)+LN(1+FL4)+LN(1+FM4)+LN(1+FN4)+LN(1+FO4)+LN(1+FP4)+LN(1+FQ4)+LN(1+FR4)+LN(1+FS4)+LN(1+FT4)+LN(1+FU4)+LN(1+FV4)+LN(1+FW4)+LN(1+FX4)+LN(1+FY4)+LN(1+FZ4)+LN(1+GA4)/2+LN(1+GB4)/2+LN(1+GC4)/2+LN(1+GD4)/2+LN(1+GE4)/2+LN(1+GF4)/2+LN(1+GG4)/2+LN(1+GH4)/2+LN(1+GI4)/2+LN(1+GJ4)/2+LN(1+GK4)/2+LN(1+GL4)/2+LN(1+GM4)/2+LN(1+GN4)/2+LN(1+GO4)/2+LN(1+GP4)/2+LN(1+GQ4)/2+LN(1+GR4)/2

R3: =LN(1+GS3)/2+LN(1+GT3)/2+LN(1+GU3)/2+LN(1+GV3)/2+LN(1+GW3)/2+LN(1+GX3)/2+LN(1+GY3)/2+LN(1+GZ3)/2+LN(1+HA3)/2

R4: =LN(1+GS4)/2+LN(1+GT4)/2+LN(1+GU4)/2+LN(1+GV4)/2+LN(1+GW4)/2+LN(1+GX4)/2+LN(1+GY4)/2+LN(1+GZ4)/2+LN(1+HA4)/2
Everyone you meet fights a battle you know nothing about. Be kind. Always.

User avatar
Sweepstakes Ron
Die Mensch Maschine
Posts: 2234
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron » Sat Dec 21, 2019 8:48 pm

Henrik wrote:
Sat Dec 21, 2019 7:56 pm
Sweepstakes Ron and Harold, I'm sorry for the delay, but now I finally had a look at this.

I use /2 (divisions by 2) to give lower scores to national lists. And this time I planned for you to add those lists in columns GA-HA. In cells Q6-R6 and below there are /2 for the GA-HA columns, but I forgot to change the formulas in cells Q3, Q4, R3 and R4.

If you want to use the GA-HA columns for national lists, you should change the formulas as follows:

Q3: =LN(1+FF3)+LN(1+FG3)+LN(1+FH3)+LN(1+FI3)+LN(1+FJ3)+LN(1+FK3)+LN(1+FL3)+LN(1+FM3)+LN(1+FN3)+LN(1+FO3)+LN(1+FP3)+LN(1+FQ3)+LN(1+FR3)+LN(1+FS3)+LN(1+FT3)+LN(1+FU3)+LN(1+FV3)+LN(1+FW3)+LN(1+FX3)+LN(1+FY3)+LN(1+FZ3)+LN(1+GA3)/2+LN(1+GB3)/2+LN(1+GC3)/2+LN(1+GD3)/2+LN(1+GE3)/2+LN(1+GF3)/2+LN(1+GG3)/2+LN(1+GH3)/2+LN(1+GI3)/2+LN(1+GJ3)/2+LN(1+GK3)/2+LN(1+GL3)/2+LN(1+GM3)/2+LN(1+GN3)/2+LN(1+GO3)/2+LN(1+GP3)/2+LN(1+GQ3)/2+LN(1+GR3)/2

Q4: =LN(1+FF4)+LN(1+FG4)+LN(1+FH4)+LN(1+FI4)+LN(1+FJ4)+LN(1+FK4)+LN(1+FL4)+LN(1+FM4)+LN(1+FN4)+LN(1+FO4)+LN(1+FP4)+LN(1+FQ4)+LN(1+FR4)+LN(1+FS4)+LN(1+FT4)+LN(1+FU4)+LN(1+FV4)+LN(1+FW4)+LN(1+FX4)+LN(1+FY4)+LN(1+FZ4)+LN(1+GA4)/2+LN(1+GB4)/2+LN(1+GC4)/2+LN(1+GD4)/2+LN(1+GE4)/2+LN(1+GF4)/2+LN(1+GG4)/2+LN(1+GH4)/2+LN(1+GI4)/2+LN(1+GJ4)/2+LN(1+GK4)/2+LN(1+GL4)/2+LN(1+GM4)/2+LN(1+GN4)/2+LN(1+GO4)/2+LN(1+GP4)/2+LN(1+GQ4)/2+LN(1+GR4)/2

R3: =LN(1+GS3)/2+LN(1+GT3)/2+LN(1+GU3)/2+LN(1+GV3)/2+LN(1+GW3)/2+LN(1+GX3)/2+LN(1+GY3)/2+LN(1+GZ3)/2+LN(1+HA3)/2

R4: =LN(1+GS4)/2+LN(1+GT4)/2+LN(1+GU4)/2+LN(1+GV4)/2+LN(1+GW4)/2+LN(1+GX4)/2+LN(1+GY4)/2+LN(1+GZ4)/2+LN(1+HA4)/2
Thanks for the explanation. Does this apply only for national lists or for the corresponding international lists as well?
Splish splash, I was raking in the cash

User avatar
Henrik
Site Admin
Posts: 5422
Joined: Sun Feb 05, 2012 10:09 am
Location: Älvsjö, Stockholm, Sweden
Contact:

Re: EOY 2019 Songs Spreadsheet Updates

Post by Henrik » Sun Dec 22, 2019 5:50 am

Only national.
Everyone you meet fights a battle you know nothing about. Be kind. Always.

User avatar
Sweepstakes Ron
Die Mensch Maschine
Posts: 2234
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron » Sun Dec 22, 2019 6:35 pm

Henrik wrote:
Sun Dec 22, 2019 5:50 am
Only national.
And what about the case for MeHaceRuido, which divides into Spanish-language and "English" (which contains at least one song in French)?
Splish splash, I was raking in the cash

User avatar
Henrik
Site Admin
Posts: 5422
Joined: Sun Feb 05, 2012 10:09 am
Location: Älvsjö, Stockholm, Sweden
Contact:

Re: EOY 2019 Songs Spreadsheet Updates

Post by Henrik » Sun Dec 22, 2019 6:44 pm

I think this is pretty equivalent to the divide between national and foreign/international lists, i.e. the country/language of the publication and the rest.
Everyone you meet fights a battle you know nothing about. Be kind. Always.

User avatar
Sweepstakes Ron
Die Mensch Maschine
Posts: 2234
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron » Sun Dec 22, 2019 6:56 pm

Henrik wrote:
Sun Dec 22, 2019 6:44 pm
I think this is pretty equivalent to the divide between national and foreign/international lists, i.e. the country/language of the publication and the rest.
One last question: is adding this formula meant to display negative points, or is that an error?

EDIT: Nevermind, I found where I messed up, it's fixed now.

EDIT 2: Okay, actual other question: Does Latin Grammy count as a national list?
Splish splash, I was raking in the cash

User avatar
Henrik
Site Admin
Posts: 5422
Joined: Sun Feb 05, 2012 10:09 am
Location: Älvsjö, Stockholm, Sweden
Contact:

Re: EOY 2019 Songs Spreadsheet Updates

Post by Henrik » Sun Dec 22, 2019 8:49 pm

Sweepstakes Ron wrote:
Sun Dec 22, 2019 6:56 pm
EDIT 2: Okay, actual other question: Does Latin Grammy count as a national list?
Good question. I leave it up to you. It’s your spreadsheet. For the all-time list, the method is completely different anyway.
Everyone you meet fights a battle you know nothing about. Be kind. Always.

User avatar
Sweepstakes Ron
Die Mensch Maschine
Posts: 2234
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron » Mon Dec 23, 2019 12:19 am

Okay, I've decided that, for now, I'll use the deweighting formula only if the source has both a national and international list.
Splish splash, I was raking in the cash

User avatar
Setherex
Rust Never Sleeps
Posts: 854
Joined: Wed May 09, 2012 2:57 am

Re: EOY 2019 Songs Spreadsheet Updates

Post by Setherex » Tue Dec 24, 2019 4:00 am

The Spotify Playlist is updated through the Top 346.

-- #342: The song is titled "Unsainted."

User avatar
Sweepstakes Ron
Die Mensch Maschine
Posts: 2234
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron » Wed Dec 25, 2019 2:54 pm

New sources:
HipHopDX (US)
Spectrum Culture (US)
Complex UK (UK)
Mixmag (UK)
Resident Advisor (UK)
DJ Mag (UK)
Muzikalia (Spain)
Zündfunk (Germany)
Reactor 105.7 (Mexico)

1 | Billie Eilish | Bad Guy
2 | Sharon Van Etten | Seventeen
3 | Lizzo | Juice
4 | Lil Nas X feat. Billy Ray Cyrus | Old Town Road (Remix)
5 | Big Thief | Not
6 | Tyler, the Creator | Earfquake
7 | Clairo | Bags
8 | FKA twigs | Cellophane
9 | Vampire Weekend | Harmony Hall
10 | Charli XCX feat. Christine and the Queens | Gone
11 | Lana Del Rey | The Greatest
12 | Rosalía and J Balvin feat. El Guincho | Con altura
13 | DaBaby | Suge
14 | Angel Olsen | Lark
15 | Aldous Harding | The Barrel
16 | The Chemical Brothers | Got to Keep On
17 | Normani | Motivation
18 | Lizzo | Truth Hurts [2017]
19 | Mannequin Pussy | Drunk II
20 | Angel Olsen | All Mirrors
21 | Thom Yorke | Dawn Chorus
22 | Georgia | About Work the Dancefloor
23 | Bon Iver | Hey, Ma
24 | Megan Thee Stallion feat. DaBaby | Cash Shit
25 | Lana Del Rey | Hope Is a Dangerous Thing for a Woman Like Me to Have – but I Have It
26 | KH [Four Tet] | Only Human
27 | Ariana Grande | 7 rings
28 | FKA twigs | Sad Day
29 | Peggy Gou | Starry Night
30 | Michael Kiwanuka | You Ain't the Problem
31 | Stormzy | Vossi Bop
32 | Haim | Summer Girl
33 | Jenny Hval | Ashes to Ashes
34 | Ariana Grande | NASA
35 | Denzel Curry | Ricky
36 | Danny Brown | Dirty Laundry
37 | Kano feat. D Double E & Ghetts | Class of Deja
38 | Fontaines D.C. | Big
39 | Taylor Swift | Lover
40 | Purple Mountains | All My Happiness Is Gone
41 | Schacke | Kisloty People
42 | Young Thug feat. Gunna | Hot / Hot (Remix feat. Travis Scott)
43 | Nilüfer Yanya | In Your Head
44 | Vampire Weekend | This Life
45 | Weyes Blood | Andromeda
46 | Polo G feat. Lil Tjay | Pop Out
47 | Fat White Family | Feet
48 | Billie Eilish | Bury a Friend
49 | The Comet Is Coming | Summon the Fire
50 | Róisín Murphy | Incapable
51 | Rosalía | Aute Cuture
52 | Lil Tecca | Ransom
53 | Los Punsetes | Una persona sospechosa
54 | Stella Donnelly | Old Man
55 | Caribou | Home
56 | Weyes Blood | Movies
57 | Lana Del Rey | Doin' Time
58 | Solange | Binz
59 | J. Cole | Middle Child
60 | Marie Davidson | Work It (Soulwax Remix)
61 | James Blake feat. Rosalía | Barefoot in the Park
62 | Solange feat. Playboi Carti | Almeda
63 | The National | Rylan
64 | (Sandy) Alex G | Gretel
65 | Metronomy | Salted Caramel Ice Cream
66 | 21 Savage feat. J. Cole | A Lot [2018]
67 | Vampire Weekend | Sympathy
68 | Sampa The Great | Final Form
69 | Burial | Claustro
70 | Solange | Stay Flo
71 | Strand of Oaks | Weird Ways
72 | Special Request | Vortex 150
73 | Pop Smoke | Welcome to the Party
74 | Dua Lipa | Don't Start Now
75 | Little Simz feat. Cleo Sol | Selfish
76 | Little Simz | Boss [2018]
77 | Nick Cave & The Bad Seeds | Bright Horses
78 | Karen O and Danger Mouse | Woman
79 | Taylor Swift | Cruel Summer
80 | Octo Octa | I Need You
81 | Acemo feat. John FM | Where They At???
82 | Nipsey Hussle feat. Roddy Ricch and Hit-Boy | Racks in the Middle
83 | Caroline Polachek | So Hot You’re Hurting My Feelings
84 | Mark Ronson feat. Angel Olsen | True Blue
85 | DJ Bogdan | Love Inna Basement (Midnight XTC)
86 | Brittany Howard | Stay High
87 | Girl in Red | Dead Girl in the Pool
88 | Cate Le Bon | Daylight Matters
89 | Tame Impala | Borderline
90 | James Massiah | Natural Born Killers (Ride for Me)
91 | Beak> | Life Goes On
92 | 100 Gecs | Money Machine
93 | Bruce Springsteen | Hello Sunshine
94 | Jonas Brothers | Sucker
95 | El Shirota | Carreta Furacão
96 | Tame Impala | Patience
97 | Black Midi | 953
98 | Lana Del Rey | Fuck It I Love You
99 | Mark Ronson feat. Lykke Li | Late Night Feelings
100 | S.A.M. | Fury's Laughter
You do not have the required permissions to view the files attached to this post.
Splish splash, I was raking in the cash

User avatar
Setherex
Rust Never Sleeps
Posts: 854
Joined: Wed May 09, 2012 2:57 am

Re: EOY 2019 Songs Spreadsheet Updates

Post by Setherex » Thu Dec 26, 2019 8:14 am

The Spotify Playlist is updated through the Top 500.

-- #173: The song is titled "Get Centred."
-- #218: The song is titled "Cab Sauve."

User avatar
Sweepstakes Ron
Die Mensch Maschine
Posts: 2234
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron » Sat Jan 11, 2020 5:12 pm

New sources:
Noisey (US)
XXL Magazine (US)
HipHopDX [R&B] (US)
Knack Focus (Belgium)
HYMN (Sweden)
Indiestyle (Belgium)
CrazyMinds (Spain)
Goûte Mes Disques (Belgium)
Kalporz (Italy)
Radiónica (Colombia)

1 | Billie Eilish | Bad Guy
2 | Sharon Van Etten | Seventeen
3 | Lizzo | Juice
4 | Lil Nas X feat. Billy Ray Cyrus | Old Town Road (Remix)
5 | Big Thief | Not
6 | FKA twigs | Cellophane
7 | Tyler, the Creator | Earfquake
8 | Clairo | Bags
9 | Charli XCX feat. Christine and the Queens | Gone
10 | Vampire Weekend | Harmony Hall
11 | Lana Del Rey | The Greatest
12 | Rosalía and J Balvin feat. El Guincho | Con altura
13 | Aldous Harding | The Barrel
14 | Angel Olsen | Lark
15 | DaBaby | Suge
16 | Thom Yorke | Dawn Chorus
17 | Angel Olsen | All Mirrors
18 | Normani | Motivation
19 | The Chemical Brothers | Got to Keep On
20 | Megan Thee Stallion feat. DaBaby | Cash Shit
21 | Mannequin Pussy | Drunk II
22 | Stormzy | Vossi Bop
23 | Georgia | About Work the Dancefloor
24 | Bon Iver | Hey, Ma
25 | KH [Four Tet] | Only Human
26 | Lizzo | Truth Hurts [2017]
27 | Fat White Family | Feet
28 | Lana Del Rey | Hope Is a Dangerous Thing for a Woman Like Me to Have – but I Have It
29 | Danny Brown | Dirty Laundry
30 | Jenny Hval | Ashes to Ashes
31 | Peggy Gou | Starry Night
32 | FKA twigs | Sad Day
33 | Weyes Blood | Andromeda
34 | Fontaines D.C. | Big
35 | Denzel Curry | Ricky
36 | Purple Mountains | All My Happiness Is Gone
37 | Ariana Grande | 7 rings
38 | Michael Kiwanuka | You Ain't the Problem
39 | Ariana Grande | NASA
40 | Young Thug feat. Gunna | Hot / Hot (Remix feat. Travis Scott)
41 | Pop Smoke | Welcome to the Party
42 | Marie Davidson | Work It (Soulwax Remix)
43 | Róisín Murphy | Incapable
44 | Kano feat. D Double E & Ghetts | Class of Deja
45 | Polo G feat. Lil Tjay | Pop Out
46 | Solange | Binz
47 | The Comet Is Coming | Summon the Fire
48 | Haim | Summer Girl
49 | Taylor Swift | Lover
50 | Billie Eilish | Bury a Friend
51 | 100 Gecs | Money Machine
52 | Lil Tecca | Ransom
53 | Rosalía | Aute Cuture
54 | Nilüfer Yanya | In Your Head
55 | Weyes Blood | Movies
56 | (Sandy) Alex G | Gretel
57 | Solange | Stay Flo
58 | Acemo feat. John FM | Where They At???
59 | Little Simz feat. Cleo Sol | Selfish
60 | slowthai + Mura Masa | Doorman [2018]
61 | Nick Cave & The Bad Seeds | Bright Horses
62 | Schacke | Kisloty People
63 | Caroline Polachek | So Hot You’re Hurting My Feelings
64 | Caribou | Home
65 | Stella Donnelly | Old Man
66 | Sampa The Great | Final Form
67 | Tame Impala | Borderline
68 | Vampire Weekend | This Life
69 | J. Cole | Middle Child
70 | The National | Rylan
71 | Metronomy | Salted Caramel Ice Cream
72 | 21 Savage feat. J. Cole | A Lot [2018]
73 | Brittany Howard | Stay High
74 | James Blake feat. Rosalía | Barefoot in the Park
75 | Charly Bliss | Capacity
76 | Jai Paul | He
77 | Mark Ronson feat. Angel Olsen | True Blue
78 | Burial | Claustro
79 | Frank Ocean | In My Room
80 | Los Punsetes | Una persona sospechosa
81 | Big Thief | U.F.O.F.
82 | Dua Lipa | Don't Start Now
83 | Lana Del Rey | Doin' Time
84 | Black Midi | 953
85 | Solange feat. Playboi Carti | Almeda
86 | Strand of Oaks | Weird Ways
87 | Better Oblivion Community Center | Dylan Thomas
88 | Caroline Polachek | Door
89 | Helado Negro | Running
90 | Vampire Weekend | Sympathy
91 | Nipsey Hussle feat. Roddy Ricch and Hit-Boy | Racks in the Middle
92 | Cate Le Bon | Daylight Matters
93 | James Massiah | Natural Born Killers (Ride for Me)
94 | JPEGMAFIA | Jesus Forgive Me, I Am a Thot
95 | Kate Tempest | Firesmoke
96 | Saweetie | My Type
97 | Mura Masa feat. slowthai | Deal Wiv It
98 | Toro y Moi | Freelance [2018]
99 | Jay Som | Superbike
100 | Special Request | Vortex 150
You do not have the required permissions to view the files attached to this post.
Splish splash, I was raking in the cash

Federico
Wannabe
Posts: 147
Joined: Mon Dec 17, 2012 1:56 pm

Re: EOY 2019 Songs Spreadsheet Updates

Post by Federico » Sun Jan 12, 2020 3:45 pm

What about Tonspion and Plattentests?

User avatar
Sweepstakes Ron
Die Mensch Maschine
Posts: 2234
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron » Sun Jan 12, 2020 3:59 pm

Federico wrote:
Sun Jan 12, 2020 3:45 pm
What about Tonspion and Plattentests?
I missed Plattentests by mistake, it will be in the next update. As for Tonspion, I'm still holding out hope that someone will get to them about the one missing song. If nothing happens by the end of the month, then I'll just add it as a 199-song list.
Splish splash, I was raking in the cash

User avatar
mileswide
Full of Fire
Posts: 1207
Joined: Wed May 01, 2019 5:08 pm
Location: Nottingham, England

Re: EOY 2019 Songs Spreadsheet Updates

Post by mileswide » Thu Jan 16, 2020 4:16 pm

Sweepstakes Ron wrote:
Sun Jan 12, 2020 3:59 pm
Federico wrote:
Sun Jan 12, 2020 3:45 pm
What about Tonspion and Plattentests?
I missed Plattentests by mistake, it will be in the next update. As for Tonspion, I'm still holding out hope that someone will get to them about the one missing song. If nothing happens by the end of the month, then I'll just add it as a 199-song list.
I've given up trying to get hold of Tonspion on Twitter, I'm trying Facebook as their Fb page seems more active, will set up an Instagram account to bother them on there if nothing by tomorrow.
Waat a liiv an bambaie when the two sevens clash

Monte
Let's Get It On
Posts: 274
Joined: Fri Dec 09, 2016 9:10 am

Re: EOY 2019 Songs Spreadsheet Updates

Post by Monte » Fri Jan 17, 2020 9:45 pm

Edit.
Last edited by Monte on Sun Feb 02, 2020 1:27 am, edited 2 times in total.

User avatar
apagauss
Superunknown
Posts: 5
Joined: Mon May 27, 2013 7:24 am

Re: EOY 2019 Songs Spreadsheet Updates

Post by apagauss » Fri Jan 31, 2020 4:58 pm

Hi, sorry for the question, I know that what you do costs a lot of work and takes time, but as every year I compile songs using your list I would like to know when the next update will come out. Greetings and thank you very much for your work. :greetings-waveyellow:

User avatar
Sweepstakes Ron
Die Mensch Maschine
Posts: 2234
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron » Fri Jan 31, 2020 5:42 pm

apagauss wrote:
Fri Jan 31, 2020 4:58 pm
Hi, sorry for the question, I know that what you do costs a lot of work and takes time, but as every year I compile songs using your list I would like to know when the next update will come out. Greetings and thank you very much for your work. :greetings-waveyellow:
All I have left to do is add Tonspion, so probably within the next 24 hours!
Splish splash, I was raking in the cash

User avatar
Sweepstakes Ron
Die Mensch Maschine
Posts: 2234
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron » Sat Feb 01, 2020 3:19 am

This will be my final update for the year. Henrik will take over from here in case anything else comes up.

New sources:
Nashville Scene (US)
Warp Magazine (Mexico)
Revista O Grito! (Brazil)
Plattentests (Germany)
Les Inrockuptibles (France)
Revista Shock [National] (Colombia)
Rockdelux [International] (Spain)
Rockdelux [National] (Spain)
The Music (Australia)
Aftonbladet (Sweden)
Musikguiden P3 (Sweden)
Screenagers (Poland)
Dagsavisen (Norway)
Tonspion (Germany)

As well as the results of the Grammys.

1 | Billie Eilish | Bad Guy
2 | Sharon Van Etten | Seventeen
3 | FKA twigs | Cellophane
4 | Lil Nas X feat. Billy Ray Cyrus | Old Town Road (Remix)
5 | Lizzo | Juice
6 | Big Thief | Not
7 | Tyler, the Creator | Earfquake
8 | Charli XCX feat. Christine and the Queens | Gone
9 | Clairo | Bags
10 | Lana Del Rey | The Greatest
11 | Vampire Weekend | Harmony Hall
12 | Rosalía and J Balvin feat. El Guincho | Con altura
13 | Aldous Harding | The Barrel
14 | Angel Olsen | Lark
15 | Thom Yorke | Dawn Chorus
16 | Angel Olsen | All Mirrors
17 | Bon Iver | Hey, Ma
18 | DaBaby | Suge
19 | Normani | Motivation
20 | Mannequin Pussy | Drunk II
21 | The Chemical Brothers | Got to Keep On
22 | Megan Thee Stallion feat. DaBaby | Cash Shit
23 | FKA twigs | Sad Day
24 | Fat White Family | Feet
25 | Stormzy | Vossi Bop
26 | Jenny Hval | Ashes to Ashes
27 | Nick Cave & The Bad Seeds | Bright Horses
28 | Georgia | About Work the Dancefloor
29 | Weyes Blood | Andromeda
30 | KH [Four Tet] | Only Human
31 | Vampire Weekend | This Life
32 | Peggy Gou | Starry Night
33 | Lizzo | Truth Hurts [2017]
34 | Purple Mountains | All My Happiness Is Gone
35 | Haim | Summer Girl
36 | Nilüfer Yanya | In Your Head
37 | Ariana Grande | 7 rings
38 | Lana Del Rey | Hope Is a Dangerous Thing for a Woman Like Me to Have – but I Have It
39 | Fontaines D.C. | Big
40 | Danny Brown | Dirty Laundry
41 | Weyes Blood | Movies
42 | Tame Impala | Borderline
43 | Michael Kiwanuka | You Ain't the Problem
44 | Denzel Curry | Ricky
45 | (Sandy) Alex G | Gretel
46 | The Comet Is Coming | Summon the Fire
47 | Billie Eilish | Bury a Friend
48 | Caroline Polachek | So Hot You’re Hurting My Feelings
49 | Rosalía | Aute Cuture
50 | Ariana Grande | NASA
51 | Young Thug feat. Gunna | Hot / Hot (Remix feat. Travis Scott)
52 | Pop Smoke | Welcome to the Party
53 | Sampa The Great | Final Form
54 | Marie Davidson | Work It (Soulwax Remix)
55 | Róisín Murphy | Incapable
56 | Kano feat. D Double E & Ghetts | Class of Deja
57 | Polo G feat. Lil Tjay | Pop Out
58 | Schacke | Kisloty People
59 | Solange | Binz
60 | Taylor Swift | Lover
61 | 100 Gecs | Money Machine
62 | James Blake feat. Rosalía | Barefoot in the Park
63 | Little Simz feat. Cleo Sol | Selfish
64 | Lil Tecca | Ransom
65 | slowthai + Mura Masa | Doorman [2018]
66 | Big Thief | U.F.O.F.
67 | Caribou | Home
68 | Solange feat. Playboi Carti | Almeda
69 | Brittany Howard | Stay High
70 | Better Oblivion Community Center | Dylan Thomas
71 | Metronomy | Salted Caramel Ice Cream
72 | Lana Del Rey | Doin' Time
73 | Solange | Stay Flo
74 | Acemo feat. John FM | Where They At???
75 | Charly Bliss | Capacity
76 | Stella Donnelly | Old Man
77 | Fontaines D.C. | Boys in the Better Land [2018]
78 | J. Cole | Middle Child
79 | The National | Rylan
80 | Nipsey Hussle feat. Roddy Ricch and Hit-Boy | Racks in the Middle
81 | Helado Negro | Running
82 | Los Punsetes | Una persona sospechosa
83 | 21 Savage feat. J. Cole | A Lot [2018]
84 | Mark Ronson feat. Lykke Li | Late Night Feelings
85 | J Balvin and Bad Bunny | La canción
86 | Ariana Grande | ghostin
87 | Jai Paul | He
88 | Mark Ronson feat. Angel Olsen | True Blue
89 | Burial | Claustro
90 | Frank Ocean | In My Room
91 | Caroline Polachek | Door
92 | Dave feat. Burna Boy | Location
93 | Jay Som | Superbike
94 | Freddie Gibbs & Madlib | Crime Pays
95 | Dua Lipa | Don't Start Now
96 | Jamila Woods | Zora
97 | Koffee | Rapture
98 | The Highwomen | Highwomen
99 | Weyes Blood | Everyday
100 | Black Midi | 953
You do not have the required permissions to view the files attached to this post.
Splish splash, I was raking in the cash

Post Reply