Help needed with EOY songs spreadsheet

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

Help needed with EOY songs spreadsheet

Post by Henrik » Mon Dec 03, 2012 6:24 pm

Anybody up for it?
Everyone you meet fights a battle you know nothing about. Be kind. Always.

User avatar
BleuPanda
Die Mensch Maschine
Posts: 3352
Joined: Thu Aug 30, 2012 1:20 am

Re: Help needed with EOY songs spreadsheet

Post by BleuPanda » Mon Dec 03, 2012 8:40 pm

I would do it if someone could show me how.

ColmD
Start Me Up
Posts: 24
Joined: Fri Feb 10, 2012 10:25 am

Re: Help needed with EOY songs spreadsheet

Post by ColmD » Tue Dec 04, 2012 5:24 pm

It can be done but the formulas and calculations I presume rest with you?

Kingoftonga
Rust Never Sleeps
Posts: 716
Joined: Thu Feb 09, 2012 9:50 pm

Re: Help needed with EOY songs spreadsheet

Post by Kingoftonga » Tue Dec 04, 2012 11:32 pm

I think Henrik has a blank spreadsheet that's formatted with all the formulas. All that's needed is for someone to fill in the names and numbers. But I'm not sure where that spreadsheet is...

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

Re: Help needed with EOY songs spreadsheet

Post by Henrik » Wed Dec 05, 2012 4:48 pm

Thanks BleuPanda and ColmD! Maybe one of you could do the updates in December and the other one takes over in January? I will leave this up to you to decide.

Sorry to keep you waiting, but here is an "empty" spreadsheet to fill in.

For every new list, you should do the following:
* Enter "no. of albums + 30", or the value "8" for non-ranked lists.
* Enter the value "1" in row 4 for every new critics' list.
* Add artists, songs and positions. For unranked lists, every song should have place 1.

That should be it. You can also look at Harold's album spreadsheet.
Before posting an update, sort the spreadsheet using the button in cell A1 and save the document. Then open and save again which will make the document a lot smaller. It should be less than 2 MB.

Let me know (in this thread) if there are lists from sources that are not in the spreadsheet, and I will decide if they're eligible.

Thanks again!
You do not have the required permissions to view the files attached to this post.
Everyone you meet fights a battle you know nothing about. Be kind. Always.

User avatar
BleuPanda
Die Mensch Maschine
Posts: 3352
Joined: Thu Aug 30, 2012 1:20 am

Re: Help needed with EOY songs spreadsheet

Post by BleuPanda » Wed Dec 05, 2012 11:07 pm

I can get started now, though it might be slow for the next week and a half as I finish this semester, but I'll have nothing to do for the month after that.

Post Reply