Moderator: Clan Directors
Commander62890 wrote:I know for a fact that Bigroo, Hambone, and Aspalm are legit.
Should be a great battle... looking forward to seeing what the 10-man TFFS can bring.
elfish_lad wrote:Wow. This is looking pretty even (from what I can see anyway) through the first set of games? 10-10 do you think?
Be interesting to see how this turns out. Good luck all.
E.
aaronvollrath wrote:
Tentative Results Speadsheet
aaronvollrath wrote:below is a link to a spreadsheet displaying tentative results. with tentative meaning i have took the liberty of prognosticating on the outcomes of unfinished games. (your mileage and opinion may vary on the current win/loss totals, but things will be adjusted when the depleted uranium dust settles and an accurate metaphorical body count takes place)
Tentative Results Speadsheet
Commander62890 wrote:aaronvollrath wrote:below is a link to a spreadsheet displaying tentative results. with tentative meaning i have took the liberty of prognosticating on the outcomes of unfinished games. (your mileage and opinion may vary on the current win/loss totals, but things will be adjusted when the depleted uranium dust settles and an accurate metaphorical body count takes place)
Tentative Results Speadsheet
This is awesome
aaronvollrath wrote:thanks! (i think) i guess it stands as a testament to the extent of my social life.... plus, it helped me keep track of how many # of games people were in. there was a 15 game limit/person. also, when people like hambone and aspalm give me shit about the way i play, i can just point to the numbers and say "the percentages don't lie, young grasshoppers!"
yeah it was meant to be a compliment and a ? about how you calculated win percentages...like what formula did you use?
aaronvollrath wrote:yeah it was meant to be a compliment and a ? about how you calculated win percentages...like what formula did you use?
ok, so i created a function to calculate the winning percentages given the layout of the spreadsheet. here is the formula for my winning percentage:
=round(100 * sumif(D2:D21,1,N2:N21)/D22,2)
i used a sumif function to do this. here is the example i used:
functions example
so basically, sum the values in n2:n21 if there is a 1 in the respective row from d2:21 i then divide by the total # of games in d22.
Users browsing this forum: No registered users