This is an archive of the mabination.com forums which were active from 2010 to 2018. You can not register, post or otherwise interact with the site other than browsing the content for historical purposes. The content is provided as-is, from the moment of the last backup taken of the database in 2019. Image and video embeds are disabled on purpose and represented textually since most of those links are dead.

To view other archive projects go to https://archives.mabination.com

[Today!] Identify the Item — Sign Up



How Scoring Works:

I threw together a small little excel sheet. All of the names are listed in rows as such:

[Image: http://puu.sh/p8yl]


The total scores are organized into the following Top 5 scoreboard, which will be posted on the thread each time somebody scores:

[Image: http://puu.sh/p8yn]


How it looks completely:

[Image: http://puu.sh/p8yr]


For excel geeks:
[SPOILER="Spoiler"]Listed the participant names in column A. Columns C:J auto-sum into the "total score" (Column L). For "Nobody's" Total Score, for example, the formula is =SUM(C5:J5). Pretty Basic.

For the scoreboard, it gets a bit more... complicated. I'll start from the right and move left. Each "Points" cell follows the following format: =LARGE(L:L,#) where L:L is the "Total Score" column, and # is whatever rank it is determining. (For first place, then, it would look like this: =LARGE(L:L,1)) It detects the #th largest amount in the column, and lists it. For the "Name:" column, I used: =INDEX(A:A,MATCH(LARGE(L:L,#),L:L,0)) What this does is detect the #th largest amount (you have to substitute, again) and detects/displays the name listed in Column A in that same row.

Hope this will help for your own scoreboard system creation! :)[/SPOILER]