EOY 2019 Songs Spreadsheet Updates

User avatar
Sweepstakes Ron
Full of Fire
Posts: 2723
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron »

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
Full of Fire
Posts: 2723
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron »

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: 2526
Joined: Wed May 01, 2019 5:08 pm
Location: Nottingham, England

Re: EOY 2019 Songs Spreadsheet Updates

Post by mileswide »

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
All I got inside is vacancy!
User avatar
JohnnyBGoode
Rust Never Sleeps
Posts: 706
Joined: Fri Feb 19, 2016 10:11 am

Re: EOY 2019 Songs Spreadsheet Updates

Post by JohnnyBGoode »

Thanks Sweepstakes Ron

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

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

Re: EOY 2019 Songs Spreadsheet Updates

Post by mileswide »

slowthai feat. Mura Masa - Doorman also 2018

I forgot to say it but great work on putting this all together, Sweepstakes Ron!
All I got inside is vacancy!
panam
Full of Fire
Posts: 2691
Joined: Fri Jul 08, 2016 4:21 am

Re: EOY 2019 Songs Spreadsheet Updates

Post by panam »

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 »

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: 6439
Joined: Sun Feb 05, 2012 10:09 am
Location: Älvsjö, Stockholm, Sweden
Contact:

Re: EOY 2019 Songs Spreadsheet Updates

Post by Henrik »

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
Movin' On Up
Posts: 885
Joined: Wed May 09, 2012 2:57 am

Re: EOY 2019 Songs Spreadsheet Updates

Post by Setherex »

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
Movin' On Up
Posts: 885
Joined: Wed May 09, 2012 2:57 am

Re: EOY 2019 Songs Spreadsheet Updates

Post by Setherex »

-- #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].
Cold Butterfly
Different Class
Posts: 484
Joined: Sun Dec 09, 2018 2:28 am

Re: EOY 2019 Songs Spreadsheet Updates

Post by Cold Butterfly »

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
Full of Fire
Posts: 2723
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron »

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
Full of Fire
Posts: 2723
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron »

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 »

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
Shake Some Action
Posts: 1490
Joined: Sun Apr 15, 2012 3:16 pm
Location: Atlanta, GA

Re: EOY 2019 Songs Spreadsheet Updates

Post by acroamor »

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 »

Is Rolling Stones going to be on the next update?
User avatar
Sweepstakes Ron
Full of Fire
Posts: 2723
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron »

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 »

Oh right, I see it now! Btw "A Lot" by 21 Savage featuring J. Cole was released in 2018.
Jackson
Into the Groove
Posts: 2075
Joined: Sun Feb 12, 2012 6:05 am
Location: Los Angeles

Re: EOY 2019 Songs Spreadsheet Updates

Post by Jackson »

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
Movin' On Up
Posts: 885
Joined: Wed May 09, 2012 2:57 am

Re: EOY 2019 Songs Spreadsheet Updates

Post by Setherex »

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: 2691
Joined: Fri Jul 08, 2016 4:21 am

Re: EOY 2019 Songs Spreadsheet Updates

Post by panam »

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: 2526
Joined: Wed May 01, 2019 5:08 pm
Location: Nottingham, England

Re: EOY 2019 Songs Spreadsheet Updates

Post by mileswide »

More 2018s:

Ava Max - Sweet but Psycho
Billie Eilish - When the Party's Over
Little Simz - Boss
All I got inside is vacancy!
User avatar
Sweepstakes Ron
Full of Fire
Posts: 2723
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron »

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
Full of Fire
Posts: 2723
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron »

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: 6439
Joined: Sun Feb 05, 2012 10:09 am
Location: Älvsjö, Stockholm, Sweden
Contact:

Re: EOY 2019 Songs Spreadsheet Updates

Post by Henrik »

Sorry. I’ll have a look at it tonight.
Everyone you meet fights a battle you know nothing about. Be kind. Always.
Harold
Into the Groove
Posts: 2331
Joined: Fri Feb 10, 2012 3:56 pm

Re: EOY 2019 Songs Spreadsheet Updates

Post by Harold »

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: 6439
Joined: Sun Feb 05, 2012 10:09 am
Location: Älvsjö, Stockholm, Sweden
Contact:

Re: EOY 2019 Songs Spreadsheet Updates

Post by Henrik »

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
Full of Fire
Posts: 2723
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron »

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
Full of Fire
Posts: 2723
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron »

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
Full of Fire
Posts: 2723
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron »

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
Into the Groove
Posts: 2331
Joined: Fri Feb 10, 2012 3:56 pm

Re: EOY 2019 Songs Spreadsheet Updates

Post by Harold »

I copied/pasted the revised formulas into the albums spreadsheet - it seems to have worked. Thanks!
User avatar
Henrik
Site Admin
Posts: 6439
Joined: Sun Feb 05, 2012 10:09 am
Location: Älvsjö, Stockholm, Sweden
Contact:

Re: EOY 2019 Songs Spreadsheet Updates

Post by Henrik »

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
Full of Fire
Posts: 2723
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron »

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: 6439
Joined: Sun Feb 05, 2012 10:09 am
Location: Älvsjö, Stockholm, Sweden
Contact:

Re: EOY 2019 Songs Spreadsheet Updates

Post by Henrik »

Only national.
Everyone you meet fights a battle you know nothing about. Be kind. Always.
User avatar
Sweepstakes Ron
Full of Fire
Posts: 2723
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron »

Henrik wrote: Sun Dec 22, 2019 5:50 amOnly 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: 6439
Joined: Sun Feb 05, 2012 10:09 am
Location: Älvsjö, Stockholm, Sweden
Contact:

Re: EOY 2019 Songs Spreadsheet Updates

Post by Henrik »

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
Full of Fire
Posts: 2723
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron »

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: 6439
Joined: Sun Feb 05, 2012 10:09 am
Location: Älvsjö, Stockholm, Sweden
Contact:

Re: EOY 2019 Songs Spreadsheet Updates

Post by Henrik »

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
Full of Fire
Posts: 2723
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron »

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
Movin' On Up
Posts: 885
Joined: Wed May 09, 2012 2:57 am

Re: EOY 2019 Songs Spreadsheet Updates

Post by Setherex »

The Spotify Playlist is updated through the Top 346.

-- #342: The song is titled "Unsainted."
User avatar
Sweepstakes Ron
Full of Fire
Posts: 2723
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron »

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
Movin' On Up
Posts: 885
Joined: Wed May 09, 2012 2:57 am

Re: EOY 2019 Songs Spreadsheet Updates

Post by Setherex »

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
Full of Fire
Posts: 2723
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron »

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
Let's Get It On
Posts: 218
Joined: Mon Dec 17, 2012 1:56 pm

Re: EOY 2019 Songs Spreadsheet Updates

Post by Federico »

What about Tonspion and Plattentests?
User avatar
Sweepstakes Ron
Full of Fire
Posts: 2723
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron »

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: 2526
Joined: Wed May 01, 2019 5:08 pm
Location: Nottingham, England

Re: EOY 2019 Songs Spreadsheet Updates

Post by mileswide »

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.
All I got inside is vacancy!
Monte
Let's Get It On
Posts: 291
Joined: Fri Dec 09, 2016 9:10 am

Re: EOY 2019 Songs Spreadsheet Updates

Post by Monte »

Edit.
Last edited by Monte on Sun Feb 02, 2020 1:27 am, edited 2 times in total.
User avatar
apagauss
The Only Way Is Up
Posts: 12
Joined: Mon May 27, 2013 7:24 am

Re: EOY 2019 Songs Spreadsheet Updates

Post by apagauss »

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
Full of Fire
Posts: 2723
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron »

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
Full of Fire
Posts: 2723
Joined: Sat May 18, 2013 3:32 pm
Location: Here, There, and Everywhere

Re: EOY 2019 Songs Spreadsheet Updates

Post by Sweepstakes Ron »

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

Return to “EOY 2019”