Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[pisskop]

My lesson is that I should be taking notes.  :/  Seat of my pants action got me knocked on it.

Also, I agree on how good those look.  I tried notepad before and got irritated.

---

Also, what is dumbtell?  In the context of the game?

[flabort]

According to the nice wikis I've been sent to, they are tenancies that look like scum tells, but are just inexperience.

I've learned a lot of lingo between two games here one B12 that I was previously unfamiliar with.

Here are my notes for anyone who wants to see them.

I forgot to say this earlier: that is an amazing technique. I hope you don't mind if I borrow it.

I don't mind at all. The key is the spreadsheet formula =Arrayformula(Sum(If($A$2:$A202=$A202, $F$2:$F202, 0))) , which means "In all rows above this one (including this one), if the name in that row is equal to the name in this row, then put the change in scummyness into an array, else put 0. Sum the array." By using absolute values, it adjusts itself with autocomplete, by summing all changes and not any previous totals I avoid messy math, and I don't believe I've ever nested an If inside a Sum before.
I also used conditional formatting to color the squares in the entire column.

The pivot tables took forever to sort out and create. And didn't add very much to the value of the sheet.

[notquitethere]

I like your intent with the spreadsheet Flabort, but the scumminess tracker is obviously useless if it doesn't actually pick out scum.

At a tool for close analysis of the game and people's posts it looked good: persistently revising your view on people helps avoid false positives.