oEtG Forum

General Category => Decks => Studies and Statistics => Topic started by: cg on September 12, 2014, 05:27:53 pm

Title: Automatic Stats Tracking Spreadsheet
Post by: cg on September 12, 2014, 05:27:53 pm

edit Dec 2014: This is the current version: https://docs.google.com/spreadsheets/d/1EN8KpgOJeWypOe4l1xlQtA4WeBaQbU4fYkoKeK3OaTU/edit?usp=sharing

Copy it to your account/computer/whatever, delete my bit of sample data, copy output of Stats tab into the "paste" column. Sheet does the rest.

Will add detailed explanation of what things mean at some point, but for right now:

https://docs.google.com/spreadsheets/d/1qMZm9Y7cyNVHOBje9JTi5aU8SWNVvFyzUKXDnxOXEME/edit?usp=sharing

Note I transferred this over to gdocs before I'd had very much coffee this morning, so there's probably problems somewhere. If you find one, let me know.

Title: Re: Automatic Stats Tracking Spreadsheet
Post by: serprex on September 12, 2014, 10:49:06 pm

Own copy (https://docs.google.com/spreadsheets/d/1OF5kG9Aw-AEFI1TjbiQUP7GzW3tMXCqosN_Z-dV_akY/#gid=1998586860)

(Will update this post into a listing of copies as copies are made/shared)

Own copy (https://docs.google.com/spreadsheets/d/1EKC0GyQjzA9HSxqxZS04Np86J7FNiqSVQfWqwT3hv80/#gid=72642018)
Another copy (https://docs.google.com/spreadsheets/d/1u9NCBTlcyL87o7CRg9JKRacPnBc85kAyXG4genlNsxg)

Title: Re: Automatic Stats Tracking Spreadsheet
Post by: cg on September 13, 2014, 02:10:35 am

edit: Does not work properly. New version will be coming whenever I get around to it. Do not use this. The version in the OP works fine.

BROKEN AND OUTDATEDUpdated version (https://docs.google.com/spreadsheets/d/12GVKfw_08MFjms8n-kECnd1kGREUo3_U02ZEYodFGkg/edit?usp=sharing)

Added automatic normalizing for non-random opponents. Not tested. To turn it on, put a lowercase "y" into the box by whatever target you want to normalize for. To use it for arena, whenever you fight a new arena opponent, go into the "NormalizeSettings" sheet and copy the "name" column from the stats sheet over one of the "empty" slots next to arena. You can have multiple tests vs arena without multiple copies of the spreadsheet by saving your NormalizeSettings arena opponent list somewhere and copy/pasting over whichever one you are looking at the stats for. Arena stuff may get user-friendlier later. It's mostly just there because it was easy to add along with the dg/mage normalizing, which should work much easier.

Instructions/userfriendliness still coming someday.

edit: Unless you specifically want to normalize, use the first version. It's a lot faster. This is probably best for just DGs really

Title: Re: Automatic Stats Tracking Spreadsheet
Post by: cg on December 11, 2014, 05:08:44 pm

Updated version:

https://docs.google.com/spreadsheets/d/1EN8KpgOJeWypOe4l1xlQtA4WeBaQbU4fYkoKeK3OaTU/edit?usp=sharing (https://docs.google.com/spreadsheets/d/1EN8KpgOJeWypOe4l1xlQtA4WeBaQbU4fYkoKeK3OaTU/edit?usp=sharing)

Updated version includes handling for updated type of autostats, and also includes the value of won spun cards, and allows a per-game delay to be added (to account for the time taken between matches). Note that these updates mean that results of OUEI calculations will change.

Options are now available on the left side in case you want to look at old-style OUEI calcs or use a different between-game time or whatever:

"Spins?" - defaults to "y". Setting to "n" will remove spin value from the results.
"s/game" - defaults to 2. Changing to 0 will remove per-game delay. Changing to whatever else will add that many seconds delay to each game.