Help wanted - additional info for over 4,000 songs!

Sweepstakes Ron · Post by **Sweepstakes Ron** » Sat Mar 15, 2014 8:04 pm

I'm willing to do N, maybe O as well, but I feel like I should probably wait until Luke is finished with his part.

Henrik, for the songs that were added after the spreadsheet was made, will those need to be added to the spreadsheet? Or will you handle those yourself?

Luke JR68 · Post by **Luke JR68** » Sat Mar 15, 2014 9:12 pm

Sorry to keep you waiting Ron, it shouldn't take too much longer now

Post by **Henrik** » Tue Mar 18, 2014 4:17 pm

This great set of songs will be added because they appeared in Musikexpress' recent top 700 songs list.

The 13th Floor Elevators - Slip Inside This House
Adriano Celentano - Prisencolinensinaiciusol
The Beach Boys - You Still Believe in Me
Big Star - Holocaust
Black Sabbath   - Planet Caravan
Brandy - What About Us
The Byrds - My Back Pages
Can - Spoon
Captain Beefheart   - Zig Zag Wanderer
Carole King - (You Make Me Feel Like) A Natural Woman
Carpenters - Yesterday Once More
Cat Stevens - Where Do the Children Play
The Clash - Clampdown
The Cure - All Cats Are Grey
The Cure - Disintegration
David Bowie - China Girl
Dillard & Clark   - Polly
Electric Light Orchestra - Turn to Stone
Elliott Smith - Say Yes
Falco - Der Kommissar
Fehlfarben   - Paul ist tot
Fela Kuti   - Water No Get Enemy
Frank Zappa   - Call Any Vegetable
George Harrison - All Things Must Pass
Geto Boys - Six Feet Deep
The Gun Club - Mother of Earth
Hank Williams - Ramblin' Man
Jackson C. Frank - Blues Run the Game
John Cale - (I Keep a) Close Watch
Judee Sill - The Kiss
Kraftwerk   - Tanzmusik
Led Zeppelin - The Rain Song
Lee Hazlewood & Nancy Sinatra - Sundown, Sundown
Leonard Cohen - The Stranger Song
Lightnin' Hopkins - Baby Please Don't Go
Max Romeo - Chase the Devil
Mazzy Star - Into Dust
Nat King Cole - Smile
Nina Simone - Feeling Good
Nina Simone   - The Other Woman
Nina Simone   - Wild Is The Wind
Nirvana - Drain You
Orange Juice - Falling and Laughing
Pink Floyd   - Fearless
Prince - Erotic City
Rodriguez   - Crucify Your Mind
The Rolling Stones - As Tears Go By
The Rolling Stones - Doo Doo Doo Doo Doo (Heartbreaker)
Roxy Music   - For Your Pleasure
Scott Walker   - Duchess
Son House - Death Letter
The Style Council - Shout to the Top
Talk Talk - I Believe in You
Tocotronic - Jackpot
Ton Steine Scherben   - Wir müssen hier raus
Van Morrison   - The Way Young Lovers Do
The Velvet Underground - Run Run Run

Sweepstakes Ron · Post by **Sweepstakes Ron** » Mon Mar 24, 2014 11:40 pm

Luke JR68 wrote:Sorry to keep you waiting Ron, it shouldn't take too much longer now

How's it going, Luke?

Luke JR68 · Post by **Luke JR68** » Wed Mar 26, 2014 7:25 pm

I won't be able to get to the computer with my work on the spreadsheet for a while, so you should probably start with N and O, sorry to keep you waiting

Daniel · Post by **Daniel** » Thu Apr 03, 2014 1:23 am

Henrik wrote:This great set of songs will be added because they appeared in Musikexpress' recent top 700 songs list.

Cat Stevens - Where Do the Children Play
David Bowie - China Girl
Electric Light Orchestra - Turn to Stone
George Harrison - All Things Must Pass
Led Zeppelin - The Rain Song
Pink Floyd - Fearless
The Rolling Stones - As Tears Go By
The Rolling Stones - Doo Doo Doo Doo Doo (Heartbreaker)

Sweepstakes Ron · Post by **Sweepstakes Ron** » Thu Apr 03, 2014 1:31 am

I have done N already, I will try to do O this weekend.

Sweepstakes Ron · Post by **Sweepstakes Ron** » Sat Apr 05, 2014 2:25 am

Here's N+O!

Henrik, is there is a certain date you want this finished by?

Luke JR68 · Post by **Luke JR68** » Tue Apr 15, 2014 3:02 pm

Sorry it took so long, this week has been the first free time i've had in a while, but here is L and M

Luke JR68 · Post by **Luke JR68** » Tue Apr 15, 2014 3:04 pm

Wow... I feel sorry for whoever does T, that is going to take a really long time

Post by **Henrik** » Tue Apr 15, 2014 4:24 pm

Thanks Nassim, Ron and Luke! Am I correct that what's left is P, Q, R, S and T? T could probably be divided into "The" bands and others.

For quite a while I haven't done much work myself on the site update, but I will give it focus from May 1st. So if it's possible to complete this spreadsheet by the end of April, that would be awesome!

Luke JR68 · Post by **Luke JR68** » Tue Apr 15, 2014 4:50 pm

I've got free time the rest of the week, so i could knock out P and Q if that sounds all right

Sweepstakes Ron · Post by **Sweepstakes Ron** » Tue Apr 15, 2014 7:10 pm

I have a vacation next week and I'm not going anywhere, so I could probably do R and S during that time.

Luke JR68 · Post by **Luke JR68** » Thu Apr 17, 2014 12:42 am

For some reason, it seemed much quicker this time around (probably because Q was so tiny), but here's P and Q

Nassim · Post by **Nassim** » Fri Apr 18, 2014 10:35 am

Here an update file with the "non The" T

I went very quickly through the ones starting with The too to fill the obvious ones (though I did not want to decide if the B-52s are male or female fronted).

Sweepstakes Ron · Post by **Sweepstakes Ron** » Fri Apr 18, 2014 2:39 pm

Nassim wrote:Here an update file with the "non The" T
I went very quickly through the ones starting with The too to fill the obvious ones (though I did not want to decide if the B-52s are male or female fronted).

Well, for the B-52s, it may depend on the song. "Roam", for example, is definitely female-fronted.

Sweepstakes Ron · Post by **Sweepstakes Ron** » Fri Apr 18, 2014 11:42 pm

Alright, I've got some issues here.

1. Several songs that are initially listed as having been released as a single did not get a proper single release, but did get released on EPs. Are we counting EPs as singles in this case?

2. One of the songs in the spreadsheet is "My Funny Valentine", with the artist being Richard/Lorenz Hart Rodgers. The song was written by Richard Rodgers and Lorenz Hart (I don't now why the artist listing is all weird), but I can't find any evidence of a recording actually existing in 1937, as the spreadsheet says. Rodgers and Hart were the songwriters, but never the performers on any of the countless recordings of this song I could bring up. I'm not sure we'll be able to keep it on the spreadsheet.

Harold · Post by **Harold** » Sat Apr 19, 2014 1:06 am

Sweepstakes Ron wrote:Alright, I've got some issues here.

1. Several songs that are initially listed as having been released as a single did not get a proper single release, but did get released on EPs. Are we counting EPs as singles in this case?

The songs list is just that - it hasn't been strictly a "singles" list for quite some time now. Henrik opened up the database years ago to songs that were never released as singles (e.g., "Stairway to Heaven"). If a song appeared on an EP, it's not the EP that's on the database - just the individual song.

Sweepstakes Ron · Post by **Sweepstakes Ron** » Sat Apr 19, 2014 1:13 am

Harold wrote:
Sweepstakes Ron wrote:Alright, I've got some issues here.

1. Several songs that are initially listed as having been released as a single did not get a proper single release, but did get released on EPs. Are we counting EPs as singles in this case?
The songs list is just that - it hasn't been strictly a "singles" list for quite some time now. Henrik opened up the database years ago to songs that were never released as singles (e.g., "Stairway to Heaven"). If a song appeared on an EP, it's not the EP that's on the database - just the individual song.

I am aware of that, but one of the columns of this spreadsheet asks if a song did or did not have a commercial single release in the artist's home country, or in the US/UK. I was asking whether or not an EP counts as a "commercial single".

Wait a minute, just as I was typing this, I realized that it actually says "Commercial single/EP in UK/US or the artist's country?" So that solves that problem.

Harold · Post by **Harold** » Sat Apr 19, 2014 2:05 am

Sweepstakes Ron wrote: I am aware of that, but one of the columns of this spreadsheet asks if a song did or did not have a commercial single release in the artist's home country, or in the US/UK. I was asking whether or not an EP counts as a "commercial single".

Wait a minute, just as I was typing this, I realized that it actually says "Commercial single/EP in UK/US or the artist's country?" So that solves that problem.

Sorry - I misunderstood the question. I actually had a feeling that might have been the case even as I was writing, but I posted anyway, just in case.

Post by **Henrik** » Sat Apr 19, 2014 2:14 pm

The question about EP's is important, as I use the information to blank the non-single songs for singles lists, i.e. if a song isn't a single it is not used in match-ups for critics' singles lists. To be regarded as a non-single gives the song a big handicap. Which is totally fair if they were never considered eligible (by the critics) for a singles list. The EP's are definitely somewhere between though. The question should be "Has this song probably been considered for singles lists?" There isn't even a uniform answer to this across all EP's. For "You Made Me Realize" I think the answer is yes, but for "Minor Threat" I think it's no. Pretty much I have considered UK EP's as singles and US EP's as non-singles as that is usually how they were marketed, and how the critics handled them in the EOY lists. Let me know if you think I'm wrong.

Sweepstakes Ron · Post by **Sweepstakes Ron** » Tue Apr 22, 2014 2:03 am

I'm making good progress on R+S. I have also gone back and edited some earlier info (mostly regarding the EP issue). I expect to be finished within the next day or two. If anybody wants to start on "The", they can go right ahead.

Luke JR68 · Post by **Luke JR68** » Tue Apr 22, 2014 7:59 pm

I've pretty much got nothing but tests for the next 4 weeks, so i unfortunately don't have the time

Post by **Henrik** » Tue Apr 22, 2014 8:16 pm

No problem, Luke. Good luck with your tests!

So when Ron has finished R+S, only "The" is left, right?

Sweepstakes Ron · Post by **Sweepstakes Ron** » Tue Apr 22, 2014 8:38 pm

Henrik wrote:No problem, Luke. Good luck with your tests!

So when Ron has finished R+S, only "The" is left, right?

Yes, only "The" is left. Actually, I am not yet finished with R+S but I am close.

And again, good luck with the tests, Luke!

Luke JR68 · Post by **Luke JR68** » Tue Apr 22, 2014 11:21 pm

Thanks Henrik and Ron, the finals shouldn't be too bad, but the AP exams are going to be rather irksome

Sweepstakes Ron · Post by **Sweepstakes Ron** » Wed Apr 23, 2014 2:36 am

Here's R+S (with Nassim's edits included)! Now we just need "The" and we're all finished!

Sweepstakes Ron · Post by **Sweepstakes Ron** » Fri Apr 25, 2014 8:36 pm

You know what, I have time, I think I can get the rest done.

The "My Funny Valentine" issue I brought up before is still unresolved. Henrik, would it be possible to check which lists it shows up on?

Post by **Henrik** » Fri Apr 25, 2014 9:48 pm

Sweepstakes Ron wrote:You know what, I have time, I think I can get the rest done.

The "My Funny Valentine" issue I brought up before is still unresolved. Henrik, would it be possible to check which lists it shows up on?

Thanks Sweepstakes!!

I'll get back on the "My Funny Valentine" issue when I find time.

DDD troll account · Post by **DDD troll account** » Fri Apr 25, 2014 10:54 pm

Ron, there are a couple of capitalization and spelling errors on German language tracks in the spreadsheet, which you might want to correct if you find the time:

Fettes Brot - Schwule Mädchen
Justus Köhncke - Was ist Musik?
Kraftwerk - Die Mensch-Maschine
Kraftwerk - Computer Liebe
Superpunk - Neue Zähne für meinen Bruder und mich

Sweepstakes Ron · Post by **Sweepstakes Ron** » Sat Apr 26, 2014 2:18 am

pauldrach wrote:Ron, there are a couple of capitalization and spelling errors on German language tracks in the spreadsheet, which you might want to correct if you find the time:

Fettes Brot - Schwule Mädchen
Justus Köhncke - Was ist Musik?
Kraftwerk - Die Mensch-Maschine
Kraftwerk - Computer Liebe
Superpunk - Neue Zähne für meinen Bruder und mich

Danke schön, Pauldrach!

Sweepstakes Ron · Post by **Sweepstakes Ron** » Sat Apr 26, 2014 7:39 pm

Alright, I'm having a problem with one band in regards to the male/female column. The Go! Team was originally a project by one guy, Ian Parton, and their debut album Thunder, Lightning, Strike utilized various vocal samples, most (if not all) of them containing female voices. After the album was originally released, Parton was able to form a complete band (with a woman on lead vocals), and rereleased the album for the American market with many of the samples replaced with new recordings. Should the songs from this album count as male or female fronted?

Post by **Henrik** » Sat Apr 26, 2014 8:10 pm

Sweepstakes Ron wrote:Alright, I'm having a problem with one band in regards to the male/female column. The Go! Team was originally a project by one guy, Ian Parton, and their debut album Thunder, Lightning, Strike utilized various vocal samples, most (if not all) of them containing female voices. After the album was originally released, Parton was able to form a complete band (with a woman on lead vocals), and rereleased the album for the American market with many of the samples replaced with new recordings. Should the songs from this album count as male or female fronted?

Go with female, in this case and I would say almost any time when you're in doubt.

Sweepstakes Ron · Post by **Sweepstakes Ron** » Sat Apr 26, 2014 8:18 pm

Henrik wrote:
Sweepstakes Ron wrote:Alright, I'm having a problem with one band in regards to the male/female column. The Go! Team was originally a project by one guy, Ian Parton, and their debut album Thunder, Lightning, Strike utilized various vocal samples, most (if not all) of them containing female voices. After the album was originally released, Parton was able to form a complete band (with a woman on lead vocals), and rereleased the album for the American market with many of the samples replaced with new recordings. Should the songs from this album count as male or female fronted?
Go with female, in this case and I would say almost any time when you're in doubt.

Thanks. However, one of those tracks ("Junior Kickstart") is instrumental, so for only that song, I will put it as male.

Sweepstakes Ron · Post by **Sweepstakes Ron** » Sun Apr 27, 2014 6:40 pm

And... DONE!

Post by **Henrik** » Sun Apr 27, 2014 8:51 pm

Sweepstakes Ron wrote:And... DONE!

That's fantastic! Thanks to everyone who helped me with this!

To those who merged spreadsheets somewhere at some point (this must have been done since the letters were many times carried out by different people in parallel):
1. Thank you for doing this as well!
2. Could you please confirm that you did it carefully and checked that the spreadsheets were sorted exactly the same way before you merged/pasted any information.

Sweepstakes Ron · Post by **Sweepstakes Ron** » Sun Apr 27, 2014 9:05 pm

Henrik wrote:Could you please confirm that you did it carefully and checked that the spreadsheets were sorted exactly the same way before you merged/pasted any information.

Yep, I checked, everything's in place.

Post by **Henrik** » Sun Apr 27, 2014 10:24 pm

Sweepstakes Ron wrote:
Henrik wrote:Could you please confirm that you did it carefully and checked that the spreadsheets were sorted exactly the same way before you merged/pasted any information.
Yep, I checked, everything's in place.

Thank you!!

Post by **Henrik** » Fri May 16, 2014 10:11 am

Wow, thanks again to everyone who helped me with the first spreadsheet. I didn't realize how much work you had put into it until I went through all corrections this week. Thank you so much!!!

But it doesn't end there. Now I have a (much smaller) additional spreadsheet, with songs that were included in recent critics' lists or because I had made mistakes and forgotten to include entries from older lists. As usual there are some debatable songs included...

Link to Google Drive for people without Excel: https://docs.google.com/spreadsheets/d/ ... sp=sharing

I would be really grateful if I could get help with this spreadsheet as well. Also expect spreadsheets with 2013 albums and songs coming soon.

Thanks in advance!

Sweepstakes Ron · Post by **Sweepstakes Ron** » Sat May 17, 2014 1:53 am

I think I can do at least A-M. I can probably take the rest if nobody else does.

Luke JR68 · Post by **Luke JR68** » Sat May 17, 2014 3:25 am

I'm working on the Woxy lists, so I unfortunatly can't help...

Post by **Henrik** » Sat May 17, 2014 5:56 am

Thanks Ron!

And thanks Luke for your work on the woxy file!

Post by **Henrik** » Sat May 17, 2014 9:59 am

Bruce, it would be really awesome if you could check also for this last bunch of songs, which of them that made Billboard top 40 popularity chart between 1955 and 1980. Let me know if you need another format than the Google Spreadsheet.

santacosta · Post by **santacosta** » Wed May 21, 2014 7:46 pm

So many new songs. Is it going to be a new Top 4000 or a Top 5000?
By the way, I really want to help, but my schedule for the time being is not helping. I only have time for like playing Random Rules, wanna cry.

Luke JR68 · Post by **Luke JR68** » Wed May 21, 2014 8:19 pm

Last I heard, there would be around 8000 songs on the site, so I'd guess a top 5000, though there might be enough for a top 6000 (fingers crossed)

Sweepstakes Ron · Post by **Sweepstakes Ron** » Thu May 22, 2014 1:17 am

Here's A-M. I'll probably do the rest if nobody signs up in the next couple of days.

Post by **Henrik** » Thu May 22, 2014 6:11 am

Thanks, Ron!

santacosta · Post by **santacosta** » Thu May 22, 2014 5:02 pm

I have some spare time today. I will complete what's left in the Excel file

Post by **Henrik** » Thu May 22, 2014 6:01 pm

That's great santacosta! Thanks!

santacosta · Post by **santacosta** » Thu May 22, 2014 6:15 pm

Finished, I think everything's OK