Florin's Sheet for Ranking Songs in a game - TennisForum.com
 
LinkBack Thread Tools
post #1 of 3 (permalink) Old Mar 5th, 2015, 06:21 PM Thread Starter
Senior Member
 
traddles's Avatar
 
Join Date: Jan 2012
Posts: 3,779
                     
Florin's Sheet for Ranking Songs in a game

Thanks again, guys Still thinking what theme to choose

Meanwhile, I want to share a little Excel sheet I created in order to help me to have a faster and easiest ranking system of BSG songs. I already gave it to Alin and he said I should share it with you, some of you might be interested in it.

I'm just beginner in Excel, so some formulas and methods were inspired from the TT Rankings sheet, so all the (possible) credits should go to the creators of it.

So this is it:

https://www.dropbox.com/s/kihtk84tfk...ongs.xlsx?dl=0

You'll find the instructions in first file, How To. Please read them carefully
Just let me now if you notice any errors. Of course, suggestions for improvements are more than welcomed

Last edited by traddles; Mar 7th, 2015 at 03:12 AM.
traddles is offline  
Sponsored Links
Advertisement
 
post #2 of 3 (permalink) Old Mar 7th, 2015, 03:23 AM Thread Starter
Senior Member
 
traddles's Avatar
 
Join Date: Jan 2012
Posts: 3,779
                     
Re: Sheet for Ranking Songs in a game

For those who already downloaded the sheet. There is an error in the original sheet. If you want to correct it:

Select Columns M & R
Right click, press Unhide
Go to cell O11 and write =P11
Then select Columns N, O & P and Press Hide

That's all. If not corrected, it might show (some) wrong grades in Column W (The pre-final rankings won't be affected, though).

The link to the corrected version is already in the OP.
traddles is offline  
post #3 of 3 (permalink) Old Mar 23rd, 2015, 06:44 AM
Senior Member
 
stromatolite's Avatar
 
Join Date: Aug 2011
Posts: 33,504
                     
Re: Sheet for Ranking Songs in a game

Thanks for this, it looks good.

I already had a system using excel, but it required a lot more manual work than this, so I think this should definitely save me some time

Btw, I think it should be possible to lock the non-grey cells, to prevent the risk of changing anything. I will try to find out how to do this and get back to you if I figure it out
stromatolite is offline  
Reply

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the TennisForum.com forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page



Posting Rules  
You may not post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome