Werewolf Statistics

updated stats with overwatch game, and new players. (alert if you see anything wrong, your input always welcome)

as formulas needed to be pushed around, i have created 4 x 'newplayer' slots, which can be rename with new players, and 3 next games.
when you run out of spaces, give me a shout to add more, or carefully do it yourself.

Now, whoever beautifys that sheet can beautify it again, i dont make thing look pretty

updated. already found an error

Bounty Hunter wrote: »

Happy enough with my stats so far:

6 times a villager and a 50% win ratio
1 time as a wolf and 100%
1 time as other (Mogwai) and 100%

5/8 or 62.5% overall isn't amazing but crosstownk is the only one to have played as much or more than me to have better. Now that that has officially been stated though I feel my ratio will start to drop and tbh I expect the more one plays the harder it is to keep a good ratio like that anyway.

Pter wrote: »

Very impressive record BH. Looking forward to see if its a good start or you are just that good in general

BH's record is very impressive.


Out of the 654 entries into the games.
275 got called Winners.


out of those 275,

219 of those wins are due to being part of a winning village team.
55 of those wins are due to being part of a winning wolf team.
Only 1 of those wins was a solo win.


Congrats BH, the only solo win as of yet.

quickbeam wrote: »

Updated for JP.

When I click on the Players List to sort by player name, it only sorts up to Row 92, so not sure why that is.

I kept the SK win the same colour as an SK player, but added the asterix. For some reason it wouldn't let me change the colour.

Feel free to amend if I got anything wrong.

[/bored on a Wednesday morning]

Pter wrote: »

It's conditional formatting that changes the colour to match the text. I'll take a look when I get back from hols, unless someone else wants to mess around with it in the meantime.

open sheet,
click the top left box to select whole sheet.
click format, conditional formatting.
find rule that say, turn it purple if it contains 'sk'
edit it to exact text, and add new rule for exact text 'sk*'


Edit: not doing myself, as i don't beautify stuff it too difficult, i don't have any idea what colour sk or sk* should be...

quickbeam wrote: »

Thanks. Done.

Any idea on...

haha, think you have it already, seen it change, (filter view)

I case you haven't , find bottom right of the data you want sorted, drag it up to top left of data you want sorted, Data, filter view, create new filter view.

Probably clean up chatter too, keep it to the data..

quickbeam wrote: »

We should play a whole game in binary. For the craic like!

I'd love it, but ..

Some people wont like that, i think it was the mods of xmas game that gave me a pretty hard NO to that kind of stuff.

context: i was suggesting in that game, that our FFAs where secret but we post checksums of our FFAs so that we cant lie. a checksum in a one way hash, that is, we can use it to prove something is exactly as somebody said it was, but it being impossible to recreate the data from the checksum.
the mods then said they didn't want people to have to go to another site in the game, which is fair enough, but i wasn't saying go to another site, i was just saying do the checksum thing.

the checksum thing is only a few sums

http://www.rfc-base.org/txt/rfc-1321.txt

not a website.

Similar to how binary to text conversion is jsut a lookup that can be done easily with a few printouts

Hello

H is decimal 72 or 48 in hex or 0100 1000
e is 65 in hex or 0110 0101
l is 6C in hex or 0110 1100
l is 6C in hex or 0110 1100
o is 6F in hex or 0110 1111

so Hello is 0100 1000 0110 0101 0110 1100 0110 1100 0110 1111
so you can do it with out going to a site to do it, but its a hell of a lot quicker letting the site do it for you.

What's the most games played by those in the 100% win club?