Forum
Kicking off the 2010 asr!
|
superxchloe wrote
at 12:43 AM, Tuesday September 7, 2010 EDT
My excel looks like a mess! :D
Guys, keep in mind that I use no programming aside from formulas in excel and have to update this by hand, so I'm only going to update data when I add someone new or at the end of each month. Please be patient. The formula I decided on includes a small bonus for playing a large number of games (1 point per 25 games): (games*PPG)*(4*%1sts+3*%2nds+2*%3rds+%4ths-%6ths-2*%7ths)+(#games/25) 40 games a month are required. I have included everyone in the yearly tazd competition. 2584 yellowfin 2525 the full monte 2059 caesar-blue 1355 greekboi 1350 dasfury 1009 Fonias 0520 AlexBallDrop 0392 ZIGIBOOM 0289 cool g 0065 noamlang1 0035 vIRGI 0011 speciale528 -0088 pooch723 |
Replies 1 - 5 of 5
|
KDICEMOD__ wrote
at 3:20 AM, Tuesday September 7, 2010 EDT Chloe do you have a job?
|
|
|
superxchloe wrote
at 10:33 AM, Tuesday September 7, 2010 EDT I work about 15-20 hours a week and am a full time student.
|
|
skrumgaer wrote
at 2:33 PM, Tuesday September 7, 2010 EDT Chloe:
One nice thing about spreadsheets is that once you get it up and running correctly for one person, you can duplicate it as many times as needed for more people. So you've done the hard work. To list more people, make duplicates of "yellowfin", then grab the new player's stats, overwrite the "yellowfin" stats, and overwrite the new player's name over "yellowfin". The first year you will also need to create a new line for "yellowfin" each month, unless you have already done so. Put zeros in the number of games for months not be used. It takes me not more than an hour to do a monthly update for the yearly TAZD. |
|
KDICEMOD wrote
at 2:33 PM, Tuesday September 7, 2010 EDT Sorry, KDICEMOD__ is unavailable to take your call at the moment. Please leave your name , number, and a brief message, and he'll return your call as soon as he's unbanned.
BEEEEEP |
|
|
superxchloe wrote
at 2:55 PM, Tuesday September 7, 2010 EDT yeah skrum, I've done that. it's still messy. The monthly spreadsheets are much cleaner.
|
