Help wanted!

panam
Unquestionable Presence
Posts: 557
Joined: Fri Jul 08, 2016 4:21 am

Re: Help wanted!

Postby panam » Wed Jul 19, 2017 7:00 pm

Pierre wrote:
panam wrote:
StevieFan13 wrote:Ideally, I'll try to have a few more lists added by the start of next week. It's been hard keeping up, and I'm almost positive I won't be able to add all the lists I've wanted to add out of pure fatigue, but I'll add a few more and then break for a while. Pierre or panam or whoever wants to have a whack at it might be able to add some.



I don't understand very well what you said but the list of "300 discos importantes de musica brasileira" should be on the xls
viewtopic.php?f=3&t=5050


He said he's almost done with most of what he planned to add to the spreadsheet, but he's also giving up on some because he's tired of working on it. Stevie doesn't plan to add the 300 Brazilian albums list. Once he posts the spreadsheet, I'll take it and I will try to add the Brazilian albums list.


Oh! That's fine. thanks for the interpretation! I want to provide more lists but i think will be better after the update because it's the priority and only is needed some details of our part. (Bad grammar, I know)

User avatar
Pierre
Die Mensch Maschine
Posts: 1691
Joined: Sat Mar 10, 2012 8:21 pm

Re: Help wanted!

Postby Pierre » Thu Jul 20, 2017 1:00 pm

panam wrote:
Pierre wrote:
panam wrote:

I don't understand very well what you said but the list of "300 discos importantes de musica brasileira" should be on the xls
viewtopic.php?f=3&t=5050


He said he's almost done with most of what he planned to add to the spreadsheet, but he's also giving up on some because he's tired of working on it. Stevie doesn't plan to add the 300 Brazilian albums list. Once he posts the spreadsheet, I'll take it and I will try to add the Brazilian albums list.


Oh! That's fine. thanks for the interpretation! I want to provide more lists but i think will be better after the update because it's the priority and only is needed some details of our part. (Bad grammar, I know)


By the way, panam, before I start to work on this one whenever I'll do, I'm a bit confused about the internal order of the list. It seems to be made out of five blocks in alphabetical order in the Google Docs spreadsheet, but I don't understand why it's that way. Any idea?

panam
Unquestionable Presence
Posts: 557
Joined: Fri Jul 08, 2016 4:21 am

Re: Help wanted!

Postby panam » Thu Jul 20, 2017 3:37 pm

Pierre wrote:
panam wrote:
Pierre wrote:
He said he's almost done with most of what he planned to add to the spreadsheet, but he's also giving up on some because he's tired of working on it. Stevie doesn't plan to add the 300 Brazilian albums list. Once he posts the spreadsheet, I'll take it and I will try to add the Brazilian albums list.


Oh! That's fine. thanks for the interpretation! I want to provide more lists but i think will be better after the update because it's the priority and only is needed some details of our part. (Bad grammar, I know)


By the way, panam, before I start to work on this one whenever I'll do, I'm a bit confused about the internal order of the list. It seems to be made out of five blocks in alphabetical order in the Google Docs spreadsheet, but I don't understand why it's that way. Any idea?


It's divided by decades (the last block is 90s and 2000s as one) and the order is alphabetically

User avatar
Pierre
Die Mensch Maschine
Posts: 1691
Joined: Sat Mar 10, 2012 8:21 pm

Re: Help wanted!

Postby Pierre » Thu Jul 20, 2017 4:00 pm

panam wrote:
Pierre wrote:
panam wrote:
Oh! That's fine. thanks for the interpretation! I want to provide more lists but i think will be better after the update because it's the priority and only is needed some details of our part. (Bad grammar, I know)


By the way, panam, before I start to work on this one whenever I'll do, I'm a bit confused about the internal order of the list. It seems to be made out of five blocks in alphabetical order in the Google Docs spreadsheet, but I don't understand why it's that way. Any idea?


It's divided by decades (the last block is 90s and 2000s as one) and the order is alphabetically


OK, so no obscure whacky ranking.Thanks a lot!

User avatar
StevieFan13
Die Mensch Maschine
Posts: 3123
Joined: Mon Jan 02, 2017 5:00 pm
Location: New York, New York
Contact:

Re: Help wanted!

Postby StevieFan13 » Thu Jul 20, 2017 4:06 pm

Pierre wrote:
panam wrote:
Pierre wrote:
By the way, panam, before I start to work on this one whenever I'll do, I'm a bit confused about the internal order of the list. It seems to be made out of five blocks in alphabetical order in the Google Docs spreadsheet, but I don't understand why it's that way. Any idea?


It's divided by decades (the last block is 90s and 2000s as one) and the order is alphabetically


OK, so no obscure whacky ranking.Thanks a lot!

Hope you haven't aded anything yet - I'm not quite done!
Music is a world within itself, with a language we all understand - Sir Duke (1976)

User avatar
Pierre
Die Mensch Maschine
Posts: 1691
Joined: Sat Mar 10, 2012 8:21 pm

Re: Help wanted!

Postby Pierre » Thu Jul 20, 2017 4:27 pm

StevieFan13 wrote:
Pierre wrote:
panam wrote:
It's divided by decades (the last block is 90s and 2000s as one) and the order is alphabetically


OK, so no obscure whacky ranking.Thanks a lot!

Hope you haven't aded anything yet - I'm not quite done!


No, don't worry ;) I'm only doing some early planning :P

User avatar
StevieFan13
Die Mensch Maschine
Posts: 3123
Joined: Mon Jan 02, 2017 5:00 pm
Location: New York, New York
Contact:

Re: Help wanted!

Postby StevieFan13 » Thu Jul 20, 2017 4:40 pm

Pierre wrote:
StevieFan13 wrote:
Pierre wrote:
OK, so no obscure whacky ranking.Thanks a lot!

Hope you haven't aded anything yet - I'm not quite done!


No, don't worry ;) I'm only doing some early planning :P

Okey-doke. Should I tell you the last lists I'm going to add/the lists I was planning to add but won't as a point of reference for you?
Music is a world within itself, with a language we all understand - Sir Duke (1976)

User avatar
Pierre
Die Mensch Maschine
Posts: 1691
Joined: Sat Mar 10, 2012 8:21 pm

Re: Help wanted!

Postby Pierre » Thu Jul 20, 2017 4:59 pm

StevieFan13 wrote:
Pierre wrote:
StevieFan13 wrote:Hope you haven't aded anything yet - I'm not quite done!


No, don't worry ;) I'm only doing some early planning :P

Okey-doke. Should I tell you the last lists I'm going to add/the lists I was planning to add but won't as a point of reference for you?


Just do that when you'll post the spreadsheet :)

User avatar
StevieFan13
Die Mensch Maschine
Posts: 3123
Joined: Mon Jan 02, 2017 5:00 pm
Location: New York, New York
Contact:

Re: Help wanted!

Postby StevieFan13 » Sun Jul 30, 2017 3:07 am

I'll try again for this week - I've been busy this weekend and didn't bring my computer, so hopefully I'll put the finishing touches on it soon.
Music is a world within itself, with a language we all understand - Sir Duke (1976)

User avatar
StevieFan13
Die Mensch Maschine
Posts: 3123
Joined: Mon Jan 02, 2017 5:00 pm
Location: New York, New York
Contact:

Re: Help wanted!

Postby StevieFan13 » Tue Aug 29, 2017 4:45 pm

OK, for whatever reason, the subsequent Israeli album lists didn't save, so that was a whole lot of pointless. But the rest did, so here's everything I've added:
- Consequence of Sound - Masterpiece Reviews
- CTV News - The Best Canadian Albums of the '00s
- The Boombox - Top 20 Hip-Hop Albums of All Time
- Vinyl Me, Please - 52 Best Albums to Own on Vinyl
- Yedioth Ahronoth - Top 100 Israeli Albums Through '89
- Jason Paul Preston - The 111 Best Albums of the '00s/The Next-Best 111 Albums of the '00s
- Loudwire - The Best Metal Album from Every Year Since 1970
- Loudwire - The Best Hard Rock Album from Every Year Since 1970
- Consequence of Sound - Top 50 Albums of 1997
- The Blues - The 20 Greatest British Blues Albums: 1960-1966
- All Radio X lists
- All Ultimate Classic Rock lists
- All Pigeons and Planes lists
- All Boot lists
- Elspeth Beidas - 100 Essential Albums
- FNAC - Pop-Rock: 1960-1979
- FNAC - Pop-Rock: 1980-1999
- Ben Westhoff - Dirty South Recommended Listening
- Slant Magazine - '90s lists
- Loudwire - Top 50 Hard Rock + Metal Debut Albums
- Sean Egan - The Little Black Book of Music: Essential Albums
- Q - The Album That Changed My Life
- Simon Reynolds - '90s and '00s lists
- MTV2/MTV Base/VH1 lists
- Billboard - All 90 Diamond-Certified Albums Ranked
Sorry I couldn't get to more!
You do not have the required permissions to view the files attached to this post.
Music is a world within itself, with a language we all understand - Sir Duke (1976)

User avatar
StevieFan13
Die Mensch Maschine
Posts: 3123
Joined: Mon Jan 02, 2017 5:00 pm
Location: New York, New York
Contact:

Re: Help wanted!

Postby StevieFan13 » Tue Aug 29, 2017 4:46 pm

Wowee, exactly a month since the last time I promised I'd finish. Whatever.
Music is a world within itself, with a language we all understand - Sir Duke (1976)

User avatar
Pierre
Die Mensch Maschine
Posts: 1691
Joined: Sat Mar 10, 2012 8:21 pm

Re: Help wanted!

Postby Pierre » Tue Aug 29, 2017 7:26 pm

StevieFan13 wrote:Sorry I couldn't get to more!


Just what exactly do you mean? That's amazing! Great job! :o

I'm taking over from here.

User avatar
StevieFan13
Die Mensch Maschine
Posts: 3123
Joined: Mon Jan 02, 2017 5:00 pm
Location: New York, New York
Contact:

Re: Help wanted!

Postby StevieFan13 » Tue Aug 29, 2017 8:10 pm

Pierre wrote:
StevieFan13 wrote:Sorry I couldn't get to more!


Just what exactly do you mean? That's amazing! Great job! :o

I'm taking over from here.

Oh good! Do what you gotta.
Music is a world within itself, with a language we all understand - Sir Duke (1976)

fns4565
I'm New Here
Posts: 2
Joined: Wed Aug 30, 2017 6:40 am
Contact:

Re: Help wanted!

Postby fns4565 » Wed Aug 30, 2017 6:52 am

Pierre wrote:One more quick question: if there are more than 200 albums, I presume you'll fix it yourself (since the ranking formulas aren't going that far)? Or is this something I can do myself (baby steps please)?

can anyone answer this please?

User avatar
Pierre
Die Mensch Maschine
Posts: 1691
Joined: Sat Mar 10, 2012 8:21 pm

Re: Help wanted!

Postby Pierre » Mon Sep 04, 2017 4:24 pm

StevieFan13 wrote:- Soundtrack - 118 Great New Zealand Albums (2007)


Note for the future: Stevie, if you go back to this, forget about this one, it's already been added in the "first spreadsheet" of this thread ;)

User avatar
StevieFan13
Die Mensch Maschine
Posts: 3123
Joined: Mon Jan 02, 2017 5:00 pm
Location: New York, New York
Contact:

Re: Help wanted!

Postby StevieFan13 » Mon Sep 04, 2017 4:50 pm

Pierre wrote:
StevieFan13 wrote:- Soundtrack - 118 Great New Zealand Albums (2007)


Note for the future: Stevie, if you go back to this, forget about this one, it's already been added in the "first spreadsheet" of this thread ;)

For real? Alright, gotcha.
Music is a world within itself, with a language we all understand - Sir Duke (1976)

User avatar
StevieFan13
Die Mensch Maschine
Posts: 3123
Joined: Mon Jan 02, 2017 5:00 pm
Location: New York, New York
Contact:

Re: Help wanted!

Postby StevieFan13 » Tue Oct 10, 2017 7:09 pm

Pierre wrote:
StevieFan13 wrote:- Soundtrack - 118 Great New Zealand Albums (2007)


Note for the future: Stevie, if you go back to this, forget about this one, it's already been added in the "first spreadsheet" of this thread ;)

Hi, Pierre! Just checking in to see how you're doing.
Music is a world within itself, with a language we all understand - Sir Duke (1976)

User avatar
Pierre
Die Mensch Maschine
Posts: 1691
Joined: Sat Mar 10, 2012 8:21 pm

Re: Help wanted!

Postby Pierre » Tue Oct 10, 2017 7:44 pm

StevieFan13 wrote:
Pierre wrote:
StevieFan13 wrote:- Soundtrack - 118 Great New Zealand Albums (2007)


Note for the future: Stevie, if you go back to this, forget about this one, it's already been added in the "first spreadsheet" of this thread ;)

Hi, Pierre! Just checking in to see how you're doing.


I'm making progress :) I have specifically added the following lists:

- John M. Borack - Shake Some Action: 200 Greatest Power-Pop Albums (2007)
- Charles Gavin, Tarik de Souza, Carlos Calado and Arthur Dapieve: 300 important albums of Brazilian music (2008)
- Volume: Making Music in Aotearoa (New Zealand) 185 Vinyl Albums 1957-1989 (2016)
- The Rock FM (NZ) Album Almanac (2017)
- Panamerika - Best Albums of the 2000s (2009)
- XXL - 30 Albums That Will Make You Appreciate Hip-Hop (2016)
- BBC 2 - Classic Albums (1992-2013)
- Thierry Aznar: Hard rock & heavy metal: 40 years of purgatory (2014-2015) (Camion blanc book)
- Stefano Cerati, Daniele Purrone, Andrea Raffaldini, Edoardo Tepes & Nikola Grukevitch: The 100 best NWOBHM albums (2010)
- Stefano Cerati, Niccolò Caroli & Alessio Oriani: The 100 best Thrash albums (2011)
- Cristiano Canali & Gennaro Dileo: The 100 best AOR albums (2013) (all three Tsunami Edizioni books)
- Rock Hard France: The ideal metaltheque Vol. 1 (2017)

And now I'm currently slowly making my way through the Le Mot et le Reste spreadsheet, adding the lists in this one into the main spreadsheet (I'm doing it tab by tab, right now I'm in the French Exp one). It's a very long work, as most lists have entries between the 400-1000 albums range. Besides, I've added the Mixtapes list to the Le Mot et le Reste spreadsheet and on the 19th I'll also buy the French Touch one to add it as well, further lengthening my work. I'll post an updated version of the Le Mot et le Reste spreadsheet in the dedicated thread once I've added the French Touch list. I'm not really looking forward to working on the Mixtapes list (I didn't add it simultaneously to the main spreadsheet), because as fascinating as this one may be, sorting out the compilations might be a chore.

Once I'm done, you should know that the list "Triple J (Australia) - Hottest 100 Australian Albums (2011)" was also added to the first spreadsheet from this thread, so you can delete this one too ;)

User avatar
madzong
Let's Get It On
Posts: 245
Joined: Fri Jan 11, 2013 7:36 am
Location: New Zealand

Re: Help wanted!

Postby madzong » Tue Oct 10, 2017 10:39 pm

I'm making progress :) I have specifically added the following lists:

- John M. Borack - Shake Some Action: 200 Greatest Power-Pop Albums (2007)
- Charles Gavin, Tarik de Souza, Carlos Calado and Arthur Dapieve: 300 important albums of Brazilian music (2008)
- Volume: Making Music in Aotearoa (New Zealand) 185 Vinyl Albums 1957-1989 (2016)
- The Rock FM (NZ) Album Almanac (2017)
- Panamerika - Best Albums of the 2000s (2009)
- XXL - 30 Albums That Will Make You Appreciate Hip-Hop (2016)
- BBC 2 - Classic Albums (1992-2013)
- Thierry Aznar: Hard rock & heavy metal: 40 years of purgatory (2014-2015) (Camion blanc book)
- Stefano Cerati, Daniele Purrone, Andrea Raffaldini, Edoardo Tepes & Nikola Grukevitch: The 100 best NWOBHM albums (2010)
- Stefano Cerati, Niccolò Caroli & Alessio Oriani: The 100 best Thrash albums (2011)
- Cristiano Canali & Gennaro Dileo: The 100 best AOR albums (2013) (all three Tsunami Edizioni books)
- Rock Hard France: The ideal metaltheque Vol. 1 (2017)

And now I'm currently slowly making my way through the Le Mot et le Reste spreadsheet, adding the lists in this one into the main spreadsheet (I'm doing it tab by tab, right now I'm in the French Exp one). It's a very long work, as most lists have entries between the 400-1000 albums range. Besides, I've added the Mixtapes list to the Le Mot et le Reste spreadsheet and on the 19th I'll also buy the French Touch one to add it as well, further lengthening my work. I'll post an updated version of the Le Mot et le Reste spreadsheet in the dedicated thread once I've added the French Touch list. I'm not really looking forward to working on the Mixtapes list (I didn't add it simultaneously to the main spreadsheet), because as fascinating as this one may be, sorting out the compilations might be a chore.

Once I'm done, you should know that the list "Triple J (Australia) - Hottest 100 Australian Albums (2011)" was also added to the first spreadsheet from this thread, so you can delete this one too ;)


Sorry if this is an annoying question (as you and Steve have already done so much hard work) but did this updated list get added along the way:

viewtopic.php?f=19&t=5485&p=75667&hilit=Essential#p75667

I think the original (pre updated) one is already on the site?

User avatar
Pierre
Die Mensch Maschine
Posts: 1691
Joined: Sat Mar 10, 2012 8:21 pm

Re: Help wanted!

Postby Pierre » Wed Oct 11, 2017 6:18 am

madzong wrote:
I'm making progress :) I have specifically added the following lists:

- John M. Borack - Shake Some Action: 200 Greatest Power-Pop Albums (2007)
- Charles Gavin, Tarik de Souza, Carlos Calado and Arthur Dapieve: 300 important albums of Brazilian music (2008)
- Volume: Making Music in Aotearoa (New Zealand) 185 Vinyl Albums 1957-1989 (2016)
- The Rock FM (NZ) Album Almanac (2017)
- Panamerika - Best Albums of the 2000s (2009)
- XXL - 30 Albums That Will Make You Appreciate Hip-Hop (2016)
- BBC 2 - Classic Albums (1992-2013)
- Thierry Aznar: Hard rock & heavy metal: 40 years of purgatory (2014-2015) (Camion blanc book)
- Stefano Cerati, Daniele Purrone, Andrea Raffaldini, Edoardo Tepes & Nikola Grukevitch: The 100 best NWOBHM albums (2010)
- Stefano Cerati, Niccolò Caroli & Alessio Oriani: The 100 best Thrash albums (2011)
- Cristiano Canali & Gennaro Dileo: The 100 best AOR albums (2013) (all three Tsunami Edizioni books)
- Rock Hard France: The ideal metaltheque Vol. 1 (2017)

And now I'm currently slowly making my way through the Le Mot et le Reste spreadsheet, adding the lists in this one into the main spreadsheet (I'm doing it tab by tab, right now I'm in the French Exp one). It's a very long work, as most lists have entries between the 400-1000 albums range. Besides, I've added the Mixtapes list to the Le Mot et le Reste spreadsheet and on the 19th I'll also buy the French Touch one to add it as well, further lengthening my work. I'll post an updated version of the Le Mot et le Reste spreadsheet in the dedicated thread once I've added the French Touch list. I'm not really looking forward to working on the Mixtapes list (I didn't add it simultaneously to the main spreadsheet), because as fascinating as this one may be, sorting out the compilations might be a chore.

Once I'm done, you should know that the list "Triple J (Australia) - Hottest 100 Australian Albums (2011)" was also added to the first spreadsheet from this thread, so you can delete this one too ;)


Sorry if this is an annoying question (as you and Steve have already done so much hard work) but did this updated list get added along the way:

viewtopic.php?f=19&t=5485&p=75667&hilit=Essential#p75667

I think the original (pre updated) one is already on the site?


It's not annoying at all. However, I don't know about this one, but it looks like it's not on the website and it might have got lost along the way. You'll need to confirm with Henrik as he's added some lists by himself; if he confirms this one was never added, I may do it.

User avatar
madzong
Let's Get It On
Posts: 245
Joined: Fri Jan 11, 2013 7:36 am
Location: New Zealand

Re: Help wanted!

Postby madzong » Thu Oct 12, 2017 5:56 am

StevieFan13 wrote:Wowee, exactly a month since the last time I promised I'd finish. Whatever.


Hey Stevie - I asked Pierre and haven't heard back from Henrik yet but this list was confirmed as being eligible years ago and then I added an update to it. Pierre wasn't sure the original or the update has been added. Do you know anything about it?

Original List:

viewtopic.php?f=3&t=2875&p=42512&hilit=Essential+nz+Essential+New+Zealand#p42512

Updated List

viewtopic.php?f=19&t=5485&p=75667&hilit=Essential#p75667

Cheers :)
Last edited by madzong on Thu Oct 12, 2017 6:07 am, edited 1 time in total.

User avatar
StevieFan13
Die Mensch Maschine
Posts: 3123
Joined: Mon Jan 02, 2017 5:00 pm
Location: New York, New York
Contact:

Re: Help wanted!

Postby StevieFan13 » Thu Oct 12, 2017 6:03 am

madzong wrote:
StevieFan13 wrote:Wowee, exactly a month since the last time I promised I'd finish. Whatever.


Hey Stevie - I asked Pierre and haven't heard back from Henrik yet but this list was confirmed as being eligible years ago and then I added an update to it. Pierre wasn't sure the original or the update has been added. Do you know anything about it?

viewtopic.php?f=19&t=5485&p=75667&hilit=Essential#p75667

Cheers :)

I think I didn't add it for the same reason Pierre didn't, so I think Henrik's your best bet for a definitive answer on whether or not it should be included.
Music is a world within itself, with a language we all understand - Sir Duke (1976)

User avatar
madzong
Let's Get It On
Posts: 245
Joined: Fri Jan 11, 2013 7:36 am
Location: New Zealand

Re: Help wanted!

Postby madzong » Thu Oct 12, 2017 6:14 am

Oh and this list too - it was also declared eligible

viewtopic.php?f=3&t=5297&hilit=On+song+Simon+sweetman

User avatar
StevieFan13
Die Mensch Maschine
Posts: 3123
Joined: Mon Jan 02, 2017 5:00 pm
Location: New York, New York
Contact:

Re: Help wanted!

Postby StevieFan13 » Thu Oct 12, 2017 6:22 am

madzong wrote:Oh and this list too - it was also declared eligible

viewtopic.php?f=3&t=5297&hilit=On+song+Simon+sweetman

That's a song list - Henrik added it to his spreadsheets and I put it on the spreadsheet of critics' lists.
Music is a world within itself, with a language we all understand - Sir Duke (1976)

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

Re: Help wanted!

Postby Henrik » Sat Oct 14, 2017 1:44 pm

StevieFan13 wrote:
madzong wrote:
StevieFan13 wrote:Wowee, exactly a month since the last time I promised I'd finish. Whatever.


Hey Stevie - I asked Pierre and haven't heard back from Henrik yet but this list was confirmed as being eligible years ago and then I added an update to it. Pierre wasn't sure the original or the update has been added. Do you know anything about it?

viewtopic.php?f=19&t=5485&p=75667&hilit=Essential#p75667

Cheers :)

I think I didn't add it for the same reason Pierre didn't, so I think Henrik's your best bet for a definitive answer on whether or not it should be included.

I have not included the list either.
Everyone you meet fights a battle you know nothing about. Be kind. Always.

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

Re: Help wanted!

Postby Henrik » Sat Oct 14, 2017 1:44 pm

By the way, should I move this topic to the critics' lists forum?
Everyone you meet fights a battle you know nothing about. Be kind. Always.

User avatar
StevieFan13
Die Mensch Maschine
Posts: 3123
Joined: Mon Jan 02, 2017 5:00 pm
Location: New York, New York
Contact:

Re: Help wanted!

Postby StevieFan13 » Sat Oct 14, 2017 1:58 pm

Henrik wrote:
StevieFan13 wrote:
madzong wrote:
Hey Stevie - I asked Pierre and haven't heard back from Henrik yet but this list was confirmed as being eligible years ago and then I added an update to it. Pierre wasn't sure the original or the update has been added. Do you know anything about it?

viewtopic.php?f=19&t=5485&p=75667&hilit=Essential#p75667

Cheers :)

I think I didn't add it for the same reason Pierre didn't, so I think Henrik's your best bet for a definitive answer on whether or not it should be included.

I have not included the list either.

There you go! Thanks for the clarification, Henrik.
Music is a world within itself, with a language we all understand - Sir Duke (1976)

User avatar
StevieFan13
Die Mensch Maschine
Posts: 3123
Joined: Mon Jan 02, 2017 5:00 pm
Location: New York, New York
Contact:

Re: Help wanted!

Postby StevieFan13 » Sat Oct 14, 2017 1:58 pm

Henrik wrote:By the way, should I move this topic to the critics' lists forum?

That'd make sense.
Music is a world within itself, with a language we all understand - Sir Duke (1976)

User avatar
Pierre
Die Mensch Maschine
Posts: 1691
Joined: Sat Mar 10, 2012 8:21 pm

Re: Help wanted!

Postby Pierre » Sat Oct 14, 2017 2:16 pm

StevieFan13 wrote:
Henrik wrote:
StevieFan13 wrote:I think I didn't add it for the same reason Pierre didn't, so I think Henrik's your best bet for a definitive answer on whether or not it should be included.

I have not included the list either.

There you go! Thanks for the clarification, Henrik.


Indeed! :greetings-waveyellow:

panam
Unquestionable Presence
Posts: 557
Joined: Fri Jul 08, 2016 4:21 am

Re: Help wanted!

Postby panam » Sat Oct 14, 2017 3:11 pm

Henrik wrote:By the way, should I move this topic to the critics' lists forum?


For me it's ok in here, but you're the boss and have the last word :P

User avatar
madzong
Let's Get It On
Posts: 245
Joined: Fri Jan 11, 2013 7:36 am
Location: New Zealand

Re: Help wanted!

Postby madzong » Sun Oct 15, 2017 6:12 am

Pierre wrote:
StevieFan13 wrote:
Henrik wrote:I have not included the list either.

There you go! Thanks for the clarification, Henrik.


Indeed! :greetings-waveyellow:


Thanks for clearing that up everyone - I guess my next question is how can I get it added?

Cheers once again.

User avatar
Pierre
Die Mensch Maschine
Posts: 1691
Joined: Sat Mar 10, 2012 8:21 pm

Re: Help wanted!

Postby Pierre » Sun Oct 15, 2017 7:09 am

madzong wrote:
Pierre wrote:
StevieFan13 wrote:There you go! Thanks for the clarification, Henrik.


Indeed! :greetings-waveyellow:


Thanks for clearing that up everyone - I guess my next question is how can I get it added?

Cheers once again.


I'll probably add it to the spreadsheet.

User avatar
madzong
Let's Get It On
Posts: 245
Joined: Fri Jan 11, 2013 7:36 am
Location: New Zealand

Re: Help wanted!

Postby madzong » Sun Oct 15, 2017 9:59 am

Pierre wrote:
madzong wrote:
Pierre wrote:
Indeed! :greetings-waveyellow:


Thanks for clearing that up everyone - I guess my next question is how can I get it added?

Cheers once again.


I'll probably add it to the spreadsheet.


Thanks Pierre!

Also, unless I missed it, It didn't look like these other two eligible albums lists have been added (I read through this thread but couldn't see them):

NZ Album Of The Year:

viewtopic.php?f=3&t=5293&p=75410#p75410

Taite Music Prize:

viewtopic.php?f=19&t=5486

User avatar
Pierre
Die Mensch Maschine
Posts: 1691
Joined: Sat Mar 10, 2012 8:21 pm

Re: Help wanted!

Postby Pierre » Fri Nov 10, 2017 3:37 pm

StevieFan13, out of curiosity, what's your procedure when you add an entry to the spreadsheet? Because I've run into several instances where the value in column D had been filled in manually, while normally, Henrik's formula should adapt the value from column C automatically on the same line. :)

User avatar
StevieFan13
Die Mensch Maschine
Posts: 3123
Joined: Mon Jan 02, 2017 5:00 pm
Location: New York, New York
Contact:

Re: Help wanted!

Postby StevieFan13 » Fri Nov 10, 2017 4:17 pm

Pierre wrote:StevieFan13, out of curiosity, what's your procedure when you add an entry to the spreadsheet? Because I've run into several instances where the value in column D had been filled in manually, while normally, Henrik's formula should adapt the value from column C automatically on the same line. :)

I am...not sure. What I always did was:
1) Shrink the column
2) Include title and link and rotate it up
3) Search for albums and add corresponding numerical value.

I assumed that's how you did it too.
Music is a world within itself, with a language we all understand - Sir Duke (1976)

User avatar
Pierre
Die Mensch Maschine
Posts: 1691
Joined: Sat Mar 10, 2012 8:21 pm

Re: Help wanted!

Postby Pierre » Fri Nov 10, 2017 4:21 pm

StevieFan13 wrote:
Pierre wrote:StevieFan13, out of curiosity, what's your procedure when you add an entry to the spreadsheet? Because I've run into several instances where the value in column D had been filled in manually, while normally, Henrik's formula should adapt the value from column C automatically on the same line. :)

I am...not sure. What I always did was:
1) Shrink the column
2) Include title and link and rotate it up
3) Search for albums and add corresponding numerical value.

I assumed that's how you did it too.


What I meant with "adding an entry" was when you were adding an album that was not at all in the spreadsheet in the first place :)

User avatar
StevieFan13
Die Mensch Maschine
Posts: 3123
Joined: Mon Jan 02, 2017 5:00 pm
Location: New York, New York
Contact:

Re: Help wanted!

Postby StevieFan13 » Fri Nov 10, 2017 4:46 pm

Pierre wrote:
StevieFan13 wrote:
Pierre wrote:StevieFan13, out of curiosity, what's your procedure when you add an entry to the spreadsheet? Because I've run into several instances where the value in column D had been filled in manually, while normally, Henrik's formula should adapt the value from column C automatically on the same line. :)

I am...not sure. What I always did was:
1) Shrink the column
2) Include title and link and rotate it up
3) Search for albums and add corresponding numerical value.

I assumed that's how you did it too.


What I meant with "adding an entry" was when you were adding an album that was not at all in the spreadsheet in the first place :)

Oh that. Sorry! my strategy was typically to find either the artists' name (if I knew they were already there) or a name with a similar beginning (say I wanted to add Manny Begar. Marvin Gaye has the same first two letters, so I'd search him and add Manny Begar close by). It usually automatically fills in, though sometimes it's off.
Music is a world within itself, with a language we all understand - Sir Duke (1976)

User avatar
Pierre
Die Mensch Maschine
Posts: 1691
Joined: Sat Mar 10, 2012 8:21 pm

Re: Help wanted!

Postby Pierre » Fri Nov 10, 2017 5:06 pm

StevieFan13 wrote:
Pierre wrote:
StevieFan13 wrote:I am...not sure. What I always did was:
1) Shrink the column
2) Include title and link and rotate it up
3) Search for albums and add corresponding numerical value.

I assumed that's how you did it too.


What I meant with "adding an entry" was when you were adding an album that was not at all in the spreadsheet in the first place :)

Oh that. Sorry! my strategy was typically to find either the artists' name (if I knew they were already there) or a name with a similar beginning (say I wanted to add Manny Begar. Marvin Gaye has the same first two letters, so I'd search him and add Manny Begar close by). It usually automatically fills in, though sometimes it's off.


I actually have another strategy: first I make sure that the album isn't in the spreadsheet (by looking for the artist in a similar way to yours); then, thanks to some genius at Microsoft, the formula in column D automatically spreads to the first empty line after the end (i.e. at the bottom of the spreadsheet). Therefore, I just stack up all the new entries at the end, and once I'm done with adding a new list I select the entire column E (album) by clicking on the "E", sort it out from A to Z (the first line is locked, so it doesn't break anything at the top), and after that I select column D and repeat the process. That way, the new entries automatically fall into place.

Anyway, I just descended through column D and I believe I've corrected all the entries which were filled in manually (replaced them with the formula), so you've got nothing to worry about ;)

User avatar
StevieFan13
Die Mensch Maschine
Posts: 3123
Joined: Mon Jan 02, 2017 5:00 pm
Location: New York, New York
Contact:

Re: Help wanted!

Postby StevieFan13 » Fri Nov 10, 2017 5:25 pm

Pierre wrote:
StevieFan13 wrote:
Pierre wrote:
What I meant with "adding an entry" was when you were adding an album that was not at all in the spreadsheet in the first place :)

Oh that. Sorry! my strategy was typically to find either the artists' name (if I knew they were already there) or a name with a similar beginning (say I wanted to add Manny Begar. Marvin Gaye has the same first two letters, so I'd search him and add Manny Begar close by). It usually automatically fills in, though sometimes it's off.


I actually have another strategy: first I make sure that the album isn't in the spreadsheet (by looking for the artist in a similar way to yours); then, thanks to some genius at Microsoft, the formula in column D automatically spreads to the first empty line after the end (i.e. at the bottom of the spreadsheet). Therefore, I just stack up all the new entries at the end, and once I'm done with adding a new list I select the entire column E (album) by clicking on the "E", sort it out from A to Z (the first line is locked, so it doesn't break anything at the top), and after that I select column D and repeat the process. That way, the new entries automatically fall into place.

Anyway, I just descended through column D and I believe I've corrected all the entries which were filled in manually (replaced them with the formula), so you've got nothing to worry about ;)

Perfect! Many thanks, Pierre!
Music is a world within itself, with a language we all understand - Sir Duke (1976)


Return to “Critics' lists”

Who is online

Users browsing this forum: Yahoo [Bot] and 46 guests