Curtis @ 9/4/2018 10:46

What are the asterisks on the stats page?

Those lines have cells that my formula for some reason didn't work correctly. So I did them differently, now if I have an issue with the totals at the bottom not being the same, then I look at those with the asterisks first for they are generally the problems childs.

Some quick stats from the spreadsheet.

Games Played	+
Games Played Curtis - 71 IM317 - 67 Angi - 61 Herm - 55 Rose - 54

Overall Wins	+
Wins Curtis - 36 im317 - 32 Angi - 32 Lamps - 27 Ahoda - 27

Town Roles Played	+
Town Roles Angi - 44 im317 - 43 Curtis - 39 Merc - 39 Ahoda - 33 JJ - 33

Mafia Roles Played	+
Mafia Roles Rose - 16 im317 - 14 Vern - 14 Angi - 13 Curtis - 13 Herm - 13 Wikey - 13 Brian - 13 Ari - 13

Cult Roles Played	+
Cult Roles Curtis - 8 Brian - 4 Malion - 4

Third Party Roles Played	+
Third Party Roles Christian - 7 Curtis - 6 Vlady - 6

I may post more later.

Ahoda @ 9/4/2018 13:15

I have 27 town wins. That means 27 times the town has had to carry me and won in spite of me being on their team.

Actually only 20 are as town, 6 are as mafia and 1 as a third party.

But the same still holds true, someone carried you to those wins!

Primate @ 21/5/2018 19:20

Will google docs not allow you to do tabs/separate pages?

Separate pages for what?

I’ll gladly send you the file and you can break it down anyway you want. The way I set it up was to limit the amount of work to keep it updated, which it isn’t bad right now. The biggest problem with a spreadsheet this size is the stupid gremlins. Everything is right but for some reason it still doesn’t calculate the right answer. Aren’t the top and sides locked so when you scroll around you still see the names and top headings?

Two other solutions, get a larger screen and zoom out til the whole thing fits. That’s what I have the time for.

Primate @ 22/5/2018 8:37

I haven't messed with google docs much, so IDK if all the SS functions will transfer. That's more the reason I was asking. I wasn't trying to say your current sheet sucks or anything.

I didn't think you were saying that, I originally created it in excel and it worked just fine, but when I transferred it to Google docs so that everyone had access to it easier, that's when the bugs started.

PM me your email address and I'll get you set up with it.

I haven't updated this in a few games, if you've won recently maybe it's improved. I'm still needing Darkus' info to add his game.