Help wanted!

[Henrik]

March was supposed to be my working month but I have mostly been in bed with the flu so far. My whole family has been ill, and I have still not recovered actually, but at least the kids are well enough to be at kindergarten today, which makes the work a bit easier...

Anyway, I have created a spreadsheet of songs from 2010-2012 that will be included in the coming update. I would be grateful if you could help me fill in the missing information. Thanks!

[JWFORD]

What do you need me to do?

[Henrik]

Hi JWFORD and welcome to the forum!

I need someone to fill in the empty cells in column B-J, in the attached spreadsheet above.

Exceptions:
Column H is not needed for countried other than UK and US.
Column I is not needed if if the song is sung in English or it's an intrumental track.

[JWFORD]

Okay, I can do that.

[JWFORD]

Done!

[JWFORD]

P.S. I was a little unsure of which bands were female fronted. For example, The xx.

[Henrik]

Excellent job, JWFORD! Thank you!!

[Nick]

This might seem unimportant, but "The High Road" by Broken Bells is technically a 2009 song, and so it should have [2009] next to it. I wouldn't want to see it added in the wrong year during the AM update.

[Henrik]

This might seem unimportant, but "The High Road" by Broken Bells is technically a 2009 song, and so it should have [2009] next to it. I wouldn't want to see it added in the wrong year during the AM update.

Thanks, Nick.

[Henrik]

Here is a similar spreadsheet for albums. And similarly, I'd be very grateful if someone fills in the missing info!

[Harold]

Here is a similar spreadsheet for albums. And similarly, I'd be very grateful if someone fills in the missing info!

I'm in for this one. So, if I'm reading right, you need:

Column B for 2011 and 2012 albums.
Column D for 2010 albums.
Column G.
Column H for US artists.
Columns I and J where applicable (Henrik, just a "Y" in column J?)

Also, you have Song instead of Album as the heading for Column D. I can change that.

[Henrik]

Thanks Harold! If you can do column H for UK artists as well (England/Wales/Scotland/Northern Ireland) that would be great.

[Harold]

Thanks Harold! If you can do column H for UK artists as well (England/Wales/Scotland/Northern Ireland) that would be great.

Sure thing. Quick question: how do you want the lists for each year sorted once both artist columns are completed - by column D (which would be my guess) or column B? Thanks!

[Henrik]

Quick question: how do you want the lists for each year sorted once both artist columns are completed - by column D (which would be my guess) or column B? Thanks!

That doesn't matter at all.

[Bruno]

No "Pyramids" by Frank Ocean?

[Harold]

No "Pyramids" by Frank Ocean?

"Pyramids" is most definitely on the songs spreadsheet, which is higher up in this thread. You may be looking at the albums spreadsheet (the albums column was mislabeled as songs when Henrik initially uploaded it).

[Harold]

The missing information has been added to the 2010-2012 albums spreadsheet. A couple of notes:

*The only album here, I believe, whose vocals are non-English (give or take a couple of tracks on the M83 album) is Ali & Toumani, and I cannot for the life of me remember what language(s) they are in (French? Bambara?). I don't feel like digging out my copy, and trying to look it up was no help at all (thanks, Internet!). I put a question mark in the column, and anyone is welcome to fill it in.

*Several acts - Kylesa, Salem, Low, The xx, and of course David Byrne & St. Vincent - are co-fronted by men and women. I put "Yes" in the Female-Fronted column to reflect that.

*I think most people consider Scott Walker to be both a USA and a UK artist, but I'm happy to give Ohio sole claim to him if you'd like to keep it that way.

*Please feel free to suggest any corrections you may see fit. I used Wikipedia to fill out the State column, for the most part.

[Bruno]

No "Pyramids" by Frank Ocean?

"Pyramids" is most definitely on the songs spreadsheet, which is higher up in this thread. You may be looking at the albums spreadsheet (the albums column was mislabeled as songs when Henrik initially uploaded it).

Yeah, I saw now ... Thanks, Harold!

[Henrik]

Thanks Harold!

[Harold]

Several 2010-2012 albums that had 30 or more points on their respective EOY spreadsheets do not appear on Henrik's list for the update, undoubtedly owing to their relatively poor ratings from other sources (Metacritic, AMG) - which aligns quite well with my own spectacularly unscientific predictions posted in another thread. You'd need to go all the way down to #176 on my list - World, You Need a Change of Mind - to find the first album that won't be included in the update.

Here are the albums in question:

2010:
Broken Bells - Broken Bells (36)
Mumford & Sons - Sigh No More (31) [2009 album]

2011:
Peaking Lights - 936 (33)
Beyoncé - 4 (33)
Panda Bear - Tomboy (30)
Katy B - On a Mission (30)

2012:
Kindness - World, You Need a Change of Mind (36)
Mark Lanegan Band - Blues Funeral (32)

[Nick]

How is "Kill for Love" by Chromatics a 2011 song? I can't find any information supporting that, but that's what it's listed as on the spreadsheet.

[Henrik]

How is "Kill for Love" by Chromatics a 2011 song? I can't find any information supporting that, but that's what it's listed as on the spreadsheet.

http://rateyourmusic.com/release/single ... _for_love/

[Nick]

I actually have another question in regards to the spreadsheet-

Why is it that a song like "Love the Way You Lie" by Eminem, which is ranked number 38 on the 2010 EOY songs spreadsheet with a total of 41 points not going to be added in the next update, but a song like "Rill Rill" by Sleigh Bells, which is ranked number 67 on the 2010 EOY songs spreadsheet with a total of 28 points is going to be added?

Not that I have a particular problem with this- I've never really cared for "Love the Way You Lie", while I think "Rill Rill" is a fantastic song. But I'm just curious. Have there been enough new EOY song lists for 2010 taken into account on the recent "songs to be added spreadsheet" that were never taken into account on the original 2010 EOY songs spreadsheet?

[Henrik]

I actually have another question in regards to the spreadsheet-

Why is it that a song like "Love the Way You Lie" by Eminem, which is ranked number 38 on the 2010 EOY songs spreadsheet with a total of 41 points not going to be added in the next update, but a song like "Rill Rill" by Sleigh Bells, which is ranked number 67 on the 2010 EOY songs spreadsheet with a total of 28 points is going to be added?

Not that I have a particular problem with this- I've never really cared for "Love the Way You Lie", while I think "Rill Rill" is a fantastic song. But I'm just curious. Have there been enough new EOY song lists for 2010 taken into account on the recent "songs to be added spreadsheet" that were never taken into account on the original 2010 EOY songs spreadsheet?

Nick, good question. The reason is that the spreadsheet on the website has unfortunately not been updated after I added another eligibility criterion - to have at least 10 album reviews per month. "Love the Way You Lie" was included on no less than four lists that are now ineligible; MTV, New York Post, Rhapsody and The Sun.

I have a spreadsheet with the ineligible lists removed. It's cluttered with some other information so I need to clean it up before I can upload it. Anyway, in this spreadsheet "Love the Way You Lie" is #60 and "Rill Rill" is #66. Furthermore, "Rill Rill" was released as a music video but not as a single so it made its way to #66 even though some EOY lists only included singles.

[Nick]

Ah, okay. That makes quite a bit of sense, Henrik. Thanks for the answer!

[o.m.]

Hi Harold, I tried -unsuccessfully I must admit- to find out what languages were used for the album "Ali & Toumani"...I just found this very detailed article about Ali Farka Touré on a site called www.afrisson.com (a site I recommend that I recommend for any lovers of African Music...) It's written in french, but I'm sure you would decipher most of it...Or use a translating device on internet like "reverso"...At the beginning of the third paragraph, the author claims that A.F.Touré came from an "agricultural region in Niafounké, 250 km south west of Tombouctou, Mali...that is rich with different languages/dialects called songhaï, peule, tamachek, bambara, zarma, malinké…Later on, A.F.Touré included several traditional songs on his grammy winning albums that could be sung in several of these different languages...
I know, it's a bit of a headache trying to know which language is used on any specific song, but well, luckily the beauty of his guitar licks are universal, aren't they? Hope this not too confusing...

http://www.afrisson.com/Ali-Farka-Toure-353.html

[Henrik]

I need help again. These lists all had a missing or wrong link in the EOY songs spreadsheets.

Beats Per Minute (USA) - Top Songs of 2012
Club Fonograma (Mexico) - Top Songs of 2011
Dagsavisen (Norway) - Top Songs of 2011
Dummy (UK) - Top Songs of 2011
Goûte mes disques (France) - Top Songs of 2011
Groove (Germany) - Top Songs of 2011
Jenesaispop (Spain) - Top Songs of 2010
Jenesaispop (Spain) - Top Songs of 2011
Le Vif (Belgium) - Top Songs of 2011
Les Inrockuptibles (France) - Top Singles of 2010
Magic (France) - Top Singles of 2010
Metromix (USA) - Top Songs of 2011
MSN (USA) - Top Songs of 2011
Musikexpress (Germany) - Top Singles of 2011
Muzikalia (Spain) - Top Songs of 2010
Muzikalia (Spain) - Top Songs of 2011
New Musical Express (UK) - Top Songs of 2011
NPR (USA) - Top Songs of 2012
Pedestrian.tv (Australia) - Top Songs of 2010
Playground (Spain) - Top Songs of 2010
Playground (Spain) - Top Songs of 2011
Porcys (Poland) - Top Singles of 2011
Rock de Lux (Spain) - Top Songs of 2011
Scanner FM (Spain) - Top Songs of 2010
Screenagers (Poland) - Top Songs of 2010
SoundsXP (UK) - Top Songs of 2011
Spex (Germany) - Top Songs of 2010
Spex (Germany) - Top Songs of 2011
State (Ireland) - Top Songs of 2011
Technikart (France) - Top Songs of 2011
The Silent Ballet (USA) - Top Songs of 2010
Tiny Mix Tapes (USA) - Top Songs of 2011
XXL (USA) - Top Songs of 2011

If you could post the links (if available) here in this thread, that would be most helpful.

[jimmyj]

Beats Per Minute (USA) - Top Songs of 2012
http://beatsperminute.com/features/the- ... s-of-2012/

[jimmyj]

Club Fonograma (Mexico) - Top Songs of 2011
http://www.clubfonograma.com/2011/10/songs-2011.html

[Poliuks]

All I've gathered for now:
http://beatsperminute.com/features/the- ... s-of-2012/
http://www.clubfonograma.com/2010/12/cl ... -20-1.html
Could not find Dagavisen list
http://www.dummymag.com/lists/2011/12/1 ... s-of-2011/
http://www.goutemesdisques.com/dossiers ... gles-2011/
Could not find Groove list
http://jenesaispop.com/2010/12/14/mejor ... ones-2010/
http://jenesaispop.com/2011/12/13/mejor ... ones-2011/
Could not find Le Vif list
http://www.lesinrocks.com/2011/12/28/mu ... 11-114781/
http://www.magicrpm.com/a-lire/intervie ... bilan-2011
http://yearendlists.com/2011/12/metromi ... s-of-2011/
http://music.msn.com/year-in-review-bes ... photoidx=2
I will do the rest later if nobody else takes it.

[Poliuks]

http://www.poplist.de/poplist.php?m=2&y=2011
http://muzikalia.com/leerreportajes.php ... es-de-2010
http://muzikalia.com/leerreportajes.php ... es-de-2011
http://www.nme.com/list/50-best-tracks-of-2011/255134
http://www.npr.org/blogs/bestmusic2012/ ... gs-of-2012
http://www.pedestrian.tv/features/enter ... /30327.htm
Links to the Playground lists Otisredding once posted seem to be dead, these are threads themselves:
http://pub37.bravenet.com/forum/static/ ... 6&cmd=show
http://pub37.bravenet.com/forum/static/ ... 3&cmd=show
http://www.porcys.com/Others.aspx?id=345
http://www.relojes-especiales.com/foros ... xe-218562/
http://archivo.scannerfm.com/lo-mejor-d ... ales-2010/
http://www.screenagers.pl/index.php?ser ... how&id=260
I'm gonna finish it tomorrow. I should be able to find missing lists too - once I've figured out that I can use old AM forum, things got much easier (actually I should have thought of this at the very beginning...).

[Henrik]

Thanks Poliuks (and jimmyj)!

[Poliuks]

http://soundsxp.com/artman2/publish/spe ... 2011.shtml
http://www.poplist.de/poplist.php?m=4&y=2010
http://www.poplist.de/poplist.php?m=4&y=2011
http://www.state.ie/features/states-top ... gs-of-2011
http://pub37.bravenet.com/forum/static/ ... 3&cmd=show (seems not to be available elsewhere online)
The Silent Ballet has closed down, here is the thread: http://pub37.bravenet.com/forum/static/ ... 8&cmd=show
http://www.tinymixtapes.com/features/20 ... r-mix-2011
http://www.xxlmag.com/news/2012/01/top- ... s-of-2011/
Update of first post coming soon.

EDIT: Done. Lists I couldn't find might be available somewhere, but they are not mentioned in the old AM forum and I lack language skills to provide them.

[jenykiron]

Great work!