The Best Heroes-A Statistical Community Effort

386 posts / 0 new
Last post
lynkfox
lynkfox's picture
Offline
Last seen: 14 hours 27 min ago
ModeratorPlaytester
Joined: Nov 01, 2012

Yeah I agree its a great stat to have - But I don't think it will be filled in very often. I may put an 'Average Game Length' field tho somewhere


Lynkfox.
http://sentinelswiki.com/ The Sentinels of the Multiverse Wiki

http://mindwanderer.net/sotm/ - SoTM Statistics! Updated DAILY!

PM me if you're interested in playing with the Statistics Data!

josul0215
josul0215's picture
Offline
Last seen: 3 years 2 weeks ago
Playtester
Joined: Apr 05, 2012

Oh geeze, I didn't even realize this thread existed. I have a chart with around 260 games I've played, just for fun... It's heavily skewed with alot of outliers though because I have 3 different playgroups and each playgroup has different amounts of experience and playstyles. I think I'll keep it out of the mix. I'm curious to see how my results differ from the collect forumites data which HAS to be more accurate then mine. (Legacy, Haka, then Mr. Fixer have the highest Win % for reasons I can explain in the case of Haka and Fixer)

zelink551
Offline
Last seen: 1 year 4 months ago
Joined: Dec 03, 2012

It didn't exist before a couple days ago :) And why are your groups any different from anyone elses? I can't speak for everyone, but 260 games seems like a gem of data.

lynkfox
lynkfox's picture
Offline
Last seen: 14 hours 27 min ago
ModeratorPlaytester
Joined: Nov 01, 2012

Considering Josul this thread just started this morning, Its not surprising :p

 

Awesome that you have that data though! Share some of it perhaps in this thread? It be cool to look at.


Lynkfox.
http://sentinelswiki.com/ The Sentinels of the Multiverse Wiki

http://mindwanderer.net/sotm/ - SoTM Statistics! Updated DAILY!

PM me if you're interested in playing with the Statistics Data!

josul0215
josul0215's picture
Offline
Last seen: 3 years 2 weeks ago
Playtester
Joined: Apr 05, 2012

I have three playgroups.

The First is the university crowd, where I run games for the local gaming organization. It's not uncommon for people who are "half-baked" or new to the game and want to try it out or are very easily distracted and not pay attention or unable to play except on rare occasions. Their skill level is low, and they are very biased on who they pick based on how they look, so Tempest, Nightmist, Absolute Zero, Expatriette, Ra, and Fanatic are picked alot in this group. This group also tends to play extremely selfishly and end up losing close games. 

I also have a casual group, they play with the "pubbies" but know the decks fairly well and do pay attention. They tend to pick heroes at random and have a better win/loss rate. With this group, I have about a 40% win rate due to random heroes sometimes resulting in games where all the heroes dogpiled Ra due to a complete lack of ongoing/environment removal. 

My last playgroup is the "pro" card players. They take all games really seriously (One of them actually became the top sealed MTG player in my state for a short stint). They skew the graph because this group has an 80% win rate on normal modes, and 40% win rate on hardmodes (Not counting classic BB/omnitron from before EE since they count for alot of the advanced mode wins). Haka, and Fixer are two of the players' favorite heroes, and in the meanwhile the university crowd pick them rarely so their win ratio is inflated. 

As a result, I have distinct population separation in my samples. I am willing to wager that if a mass of people enter their data, you will have a better distribution of skill-levels instead of having distinct peaks making for a more accurate representation. 

I only kept track of how many times a hero was picked, how many times they won, how many times a villian was fought/won with hard-mode being separate.

lynkfox
lynkfox's picture
Offline
Last seen: 14 hours 27 min ago
ModeratorPlaytester
Joined: Nov 01, 2012

You raise interesting points... but ... thats awesome part of data collection

 

What I would suggest? Enter a few games in a week - not all 260 of em. Do like 20 or 30 games total a month (5 or 10 from each of your play groups, for instance) and put them in over time. You're right - if you enter /all/ the data in right now, it would skew the comparisions to be -your- playgroup, cause even in a months time there probably wont be enough data otherwise.

 

But this is overall data. When I put in games?  Its going to be very much like your last group. We're all pro(ish) players. We have a 80-90% win rate. We all play Legend of the Five Rings competitively (Some better than others << >> ... ie not me.) - we have a couple of players who routinely get into the final cut of the Koteis.  - Or very very close to doing so. 

 

The data we're collecting is going to (eventually, months down the road) be all inclusive. Its going to include the ones just having fun and screwing around (Your college group) and its going to include the pros. And its going to include the middleground. We need it all.  Afterall, if Tachyon routinely ends up in a winning group even with a hundred 'screwing around' games with her, its going to show she is more effecient at winning than others (I'm not convinced this will be the case but thats what the data is for! :P)

 

But i would suggest slowly entering it. Put in 15-30 games a month until you get through them, then just put in the games you usually play each month. That way you wont overly skew the first couple months data.

 

 

I am going to say, however - This is not going to be like the Akrham horror one. Having played that game a few times, its a Fantasy Flight Game - and a lot of those games are kinda -ment- for you to loose more than you win XD

 

I think that even against 4s, you are still ment to win quite a lot - I'm willing to bet there will be far far far more wins than looses. I mean in my playgroup, like I said, we only loose one or two times a month.  

 

 

edit:::

 

Assuming your data fits with what we're collecting. If it doesnt, well then that makes sense  too :P


Lynkfox.
http://sentinelswiki.com/ The Sentinels of the Multiverse Wiki

http://mindwanderer.net/sotm/ - SoTM Statistics! Updated DAILY!

PM me if you're interested in playing with the Statistics Data!

flamethrower49
Offline
Last seen: 1 year 6 months ago
Playtester
Joined: Apr 04, 2012

The win rate on the Arkham Horror one is currently 63%, which is quite definitively won more than lost.  The data set is perhaps skewed, though it's hard to really tell in what way.  The people who are the type to fill out an online form to log their plays are the type of people who spend their time on the forums, seeking perhaps to better their play.  They would also, perhaps, be more the type to try out the harder villains and not mind losing to them as much, or keep using the weaker characters in an effort to get them to do better.

Yeah, Sentinels is in general an easier game, but the complex levels of difficulty make for some interesting numbers to track.  I suspect we'll see a good share of losses as well.

lynkfox
lynkfox's picture
Offline
Last seen: 14 hours 27 min ago
ModeratorPlaytester
Joined: Nov 01, 2012

Indeed. And ive put together some different trackign ways then they are in that AH one - they just track by individual Old One and Investigator, im going to see if a given hero wins more often against a given Villain or in a given environment ect. 


Lynkfox.
http://sentinelswiki.com/ The Sentinels of the Multiverse Wiki

http://mindwanderer.net/sotm/ - SoTM Statistics! Updated DAILY!

PM me if you're interested in playing with the Statistics Data!

ketigid
Offline
Last seen: 3 months 22 hours ago
Joined: Oct 11, 2011

I've submitted a play. Now, where do I see the stats?

lynkfox
lynkfox's picture
Offline
Last seen: 14 hours 27 min ago
ModeratorPlaytester
Joined: Nov 01, 2012

The stats arent put together yet. We don't have nearly enough data (only something like 30 or 40 games atm)

 

You can look at the list of games submitted and get an inkling of what you see - 

 

https://docs.google.com/spreadsheet/ccc?key=0AqClP82b_XgZdFVreEhkOWJYcmlvcDNMbWppejh5aGc#gid=0

 

is all the submitted games to date. Gives you some idea, but no hard data. 46 (as of this posting) games is such a small slice of data to even be close to useless. :P

 

Its going to be months before we get any signifigant data. But its worthwhile to build too!


Lynkfox.
http://sentinelswiki.com/ The Sentinels of the Multiverse Wiki

http://mindwanderer.net/sotm/ - SoTM Statistics! Updated DAILY!

PM me if you're interested in playing with the Statistics Data!

lynkfox
lynkfox's picture
Offline
Last seen: 14 hours 27 min ago
ModeratorPlaytester
Joined: Nov 01, 2012

hey guys

 

I just want to say about halfway through the month we have about 75 games. Thats pretty awesome! If this keeps up we can easily see around 125-150 games for the month, which while not a definitive statistical pool, ist still a pretty awesome one for our first month.

 

This stuff is great, encourage your friends, reference this sticky, get people posting games! :)


Lynkfox.
http://sentinelswiki.com/ The Sentinels of the Multiverse Wiki

http://mindwanderer.net/sotm/ - SoTM Statistics! Updated DAILY!

PM me if you're interested in playing with the Statistics Data!

zelink551
Offline
Last seen: 1 year 4 months ago
Joined: Dec 03, 2012

I was wondering, can we get this stickied on other forums as well on this site? I feel like a lot of proficient gamers hang out on this one, but perhaps we would get a broader pool on the other threads?

lynkfox
lynkfox's picture
Offline
Last seen: 14 hours 27 min ago
ModeratorPlaytester
Joined: Nov 01, 2012

I was actually considering seeing if we could get a 'Awesome Stuff For Sentinels Fans!" thread stickied in theGeneral, with links to the Wiki, this thread, Spiffs stuff, anything else we can come up with that should go in there...

 


Lynkfox.
http://sentinelswiki.com/ The Sentinels of the Multiverse Wiki

http://mindwanderer.net/sotm/ - SoTM Statistics! Updated DAILY!

PM me if you're interested in playing with the Statistics Data!

ax0r
Offline
Last seen: 1 month 2 weeks ago
Playtester
Joined: Oct 06, 2011

I don't visit the Rules and Gameplay forum enough, clearly. This is an awesome idea! Hopefully youll get a nice big data set to do some interesting analysis. Do we have any bond fide statisticians on the board? Or anyone who knows one? Some advice on how best to organise the data would be helpful, to make analysis easier down the road.

On the topic of analysis, I'd be really interested in more complex analysis that could be done to check certain combinations of heroes or other combinations of factors. For instance, how often does Fanatic win when paired with Legacy compared to without him? How much worse is the Chairman in Rook City compared to Insula Primalis? Or how often does [REDACTED] win in [REDACTED] games? (often, I expect). How does the presence or absence of healing heroes affect games against plague rat? Or how important is it to have [REDACTED] in games against [REDACTED]? (pretty important).

Also, knowing how often people lose to villains of particular difficulties will be very interesting when developing further villains - how often does >G want a level 4 villain to win?

Answering most of these questions with a usefully small confidence interval will require many hundreds or even thousands of data points. Sounds like fun!

lynkfox
lynkfox's picture
Offline
Last seen: 14 hours 27 min ago
ModeratorPlaytester
Joined: Nov 01, 2012

i would love to do which 'Teams' win most often, but given the number of combinations of heroes (yeaaah. thats a lot. if i remember my  math right its... 15x14x13+15x14x13x12+15x14x13x12x11 ... but i was always bad at math) without a computer crunching the data i don't know if that would be even possible to do. 

 

The advantage is that allll the data will always be stored in the file. And I believe ive set it up well enough that we can crunch new information from old data eventually, if we choose to. Like I made sure we're asking about team order, but havent figured out a way to accurately figure out how that effects heroes (like is Team Leader Tachyon better in first slot or last slot? When is it best to put Argent Adept?) 

I'm also not a statitician :P

 

But at least by the end of the month we should be looking at 150-200 usuable entries in one month. Thats awesome and a good starting point. Put 3 in myself last night!


Lynkfox.
http://sentinelswiki.com/ The Sentinels of the Multiverse Wiki

http://mindwanderer.net/sotm/ - SoTM Statistics! Updated DAILY!

PM me if you're interested in playing with the Statistics Data!

j1hopki1
Offline
Last seen: 2 years 7 months ago
Joined: Oct 05, 2012

Just put in my first contributions. Great work on this, guys.

lynkfox
lynkfox's picture
Offline
Last seen: 14 hours 27 min ago
ModeratorPlaytester
Joined: Nov 01, 2012

After this weekend ill be compiling the first months data. We have about 150 entries at the moment (most of them from Sound of Trees lol!) and we'll take a look on what that means. We'll loose a few due to having Playtesting stuff in them before it was pretty much finalized, but still a good start. Not nearly enough to create truely accurate data, but it is a -start-.

 

So far I'm surprised to see that about 25% of games are a loss. That is surpising to me given that in my playgroup we only loose about 10%


Lynkfox.
http://sentinelswiki.com/ The Sentinels of the Multiverse Wiki

http://mindwanderer.net/sotm/ - SoTM Statistics! Updated DAILY!

PM me if you're interested in playing with the Statistics Data!

TheSoundOfTrees
Offline
Last seen: 1 month 2 weeks ago
Joined: Sep 29, 2012

I did not enter my last games - I am jobless and play at least three games a day, if I keep entering everything there will be too big a bias.

 

Edit : I made a little analysis of the data some times ago, and many results were quite surprising. Barn Blade, especially, seemed more dangerous than we are used to think - maybe because some entries are from newer teams ?


Any view of things that is not strange is false - Neil Gaiman

flamethrower49
Offline
Last seen: 1 year 6 months ago
Playtester
Joined: Apr 04, 2012

Go ahead and post all your games.  We want raw data now.  A little more bias towards the SoundofTrees playstyle won't ruin anything.  I'm sure we'll get a lot of interesting people logging their plays here, and things will even out.  I'm storing up a bunch of post-playtest games to post once the known incarnations of the new guys are confirmed as accurate.

On another note, I have seen people talking about how they were doing something particular (like sprucing up his mechanics to have fun with Gloomweaver), but had to stop because they want to post their games.  I say just have the fun you want to have, and don't post the game.  If this results in fewer games against the official Gloomweaver, so be it.

NAL0781
NAL0781's picture
Offline
Last seen: 1 day 8 hours ago
Playtester
Joined: Nov 09, 2012

Just to say that I'm totally stoked about this initiative, I'm a stat freak.  As a matter of fact, once I become more familiar with the game I may be able to help you compile some of these statistics.  I will let you know (i am receiveing the game soon), that I will totally contribute to this although the majority of my submissions (likely between 66% - 75%) will be solo plays.

sealedangel
Offline
Last seen: 3 years 11 months ago
Joined: Dec 29, 2012

lynkfox wrote:

After this weekend ill be compiling the first months data. We have about 150 entries at the moment (most of them from Sound of Trees lol!) and we'll take a look on what that means. We'll loose a few due to having Playtesting stuff in them before it was pretty much finalized, but still a good start. Not nearly enough to create truely accurate data, but it is a -start-. So far I'm surprised to see that about 25% of games are a loss. That is surpising to me given that in my playgroup we only loose about 10%

 

I have been watching the forum for quite a while but this is my first post. I only started to upload data since this week and so far I have uploaded 8 games if I'm not wrong and my winning rate is around 50%. I only play solo with 3 heroes and there are a lot of times I can tell I can win by having just one more hero. However I prefer the challenge of using 3 heroes, plus 4 characters do take up a lot of space.

 

I did go through all the data had been collected, and it is pretty obvious that the winning ratio of 3 heroes is much lower than that of 4 heroes. So I guess it is safe to say that it's not really fair to judge the rate merely from winning or loser while neglecting the number of players. Although the H mechanics was introduced to have a better balance among different number of players, that does not change the fact that the more heroes there are, the easier it will be.

lynkfox
lynkfox's picture
Offline
Last seen: 14 hours 27 min ago
ModeratorPlaytester
Joined: Nov 01, 2012

yeah im excited to get into this  - probably will be transfering over the stuff to the 'data sheet' on tuesday afternoon, or weds morning (Have a new years eve party to go to, dont know when Ill be home lol)

 

As for the Playtest, I believe they have hit their final iteration and any changes that occur will be minor in effect that it -should- be fine for us to start including them now as of Jan. Unless something major shows up in the playtesting forms...


Lynkfox.
http://sentinelswiki.com/ The Sentinels of the Multiverse Wiki

http://mindwanderer.net/sotm/ - SoTM Statistics! Updated DAILY!

PM me if you're interested in playing with the Statistics Data!

lynkfox
lynkfox's picture
Offline
Last seen: 14 hours 27 min ago
ModeratorPlaytester
Joined: Nov 01, 2012

The First Statistics are POSTED!!!

 

 

https://docs.google.com/spreadsheet/ccc?key=0AqClP82b_XgZdGJKUVJRakJmZ3RMX2pFUjB3MEtBWHc#gid=0

 

 

(zelinke, if you dont mind addding that link to the first post please?)

 

Couple things

 

1) I gotta find a better way to do this. It took me nigh on 9 hours to input everything. Admittedly i was getting up and moving, and reorganizing the charts, setting up some auto populating fields so i wouldnt have to enter everything 3 times, and completely started over after about an hours worth of work cause i wanted a better way to do it... but still. Oy. )

2) So with that above thought - They are not currently sorted by most effecient or whatever - becaue apparently googledoc excell cannot sort a field once it has a formula in it and i used a lot of formulas to make it much easier for me to enter things.

3) I am going to work over the next few days on seeing if i can make this much quicker and easier for myself, so that form may change somewhat in the final days. I think I have a way to do it, but we'll see.

 

 

4) I threw out ALL the playtester data entries. The decks I think are 99% done now, so any future ones ill put in, but just to be safe, there is no playtester data in this release. So with that in mind there are only 170ish data points - meaning that this data is far from conlusive in anyway, so PLEASE remember that.

 

 

5) Chairman is the most dangerous with a only a 60% loss rate.

6) Baron Blade is surprisingly second with a 43% loss rate - i chalk this up to new players and baron being their first one. With more data this will probably smooth out.

7) Legacy Trounced his Nemisis with a 100% win rate (including Mad Bomber, and promo Legacies) over like 10 games

8) Fanatic did well to at 100% over Apostate with 2 games

9) Sadly for my feelings, Expatriette and Mr Fixer could not defeat their Nemisis with 0% win rate (1 game for Expat, and 4 games for Fixer)

10) Regular Ra did not ever play the Ennead, but Ra: Horus of the Two Horizons played them once and defeated them.

11) Megalopolis was the most played in enviorment, but the Ruins of Atlantis were the most dangerous with a 44.44% loss rate.

12) 4 Hero teams won nearly 80% of t he time, while 3 hero teams barely 54%. 5 hero teams (with only a 9 count of games) won 88%of the time.

13) The most played hero is Absolute Zero (with 43 games)

14) Spiffs Randomizer is the most popluar way to play, while Picking your team follows next.

 

 

Anyway. Thats some interesting stuff i saw.

 

Feel free to browse through it but please remember again, this is a small data pool and we have a long way to go before any conclusive information is presented.


Lynkfox.
http://sentinelswiki.com/ The Sentinels of the Multiverse Wiki

http://mindwanderer.net/sotm/ - SoTM Statistics! Updated DAILY!

PM me if you're interested in playing with the Statistics Data!

Cosmonaut Zero
Cosmonaut Zero's picture
Offline
Last seen: 1 year 7 months ago
Joined: Sep 03, 2012

If it makes you feel better, I logged a play last night with Mr. Fixer beating The Chairman.

 

Also, a big thank you for putting this together :D


This is a Greater than Games forum signature virus. Copy this text, add one to the generation, and replace your signature with this one so that this may take over the multiverse of forum signatures.
Generation: 1

arenson9
arenson9's picture
Offline
Last seen: 1 day 4 hours ago
ModeratorPlaytester
Joined: Aug 08, 2011

When I think of the hundreds of games I've played that are not represented here ... I want to make sure I put all the future ones in.


Hi. My name's Andy. Feel free to call me Andy, since, ya know, that's my name. (he/him/his)

If I am not for myself, who will be for me? If not now, when? If I am for myself alone, what am I? -- Hillel

Ronway
Ronway's picture
Offline
Last seen: 2 hours 56 min ago
PlaytesterTruth Seeker
Joined: Aug 02, 2011

I'm going to try to keep better track of all the games I have played and post them up as well. I tend to play a lot of solo games with only three heroes, that would probably increase the percentage of wins for that catergory at least if I were to tally that in there. So from now on I will carry a sheet of paper inside my game box so I can right down the stuff.

tommy.yeoh
Offline
Last seen: 3 years 6 months ago
Joined: Oct 02, 2012

Not sure if this was mentioned, but I think tracking if the game was played solo or multi player might provide some good information.

Solo wise, I would suspect players would tend to win more - being able to strategize and coordinate better, etc.

Cosmonaut Zero
Cosmonaut Zero's picture
Offline
Last seen: 1 year 7 months ago
Joined: Sep 03, 2012

I dunno. We coordinate pretty heavily in our multiplayer games. I would actually expect multiplayer games to have a higher win rate because you have more eyes on everything to catch stuff the one person might miss.


This is a Greater than Games forum signature virus. Copy this text, add one to the generation, and replace your signature with this one so that this may take over the multiverse of forum signatures.
Generation: 1

Paul
Paul's picture
Offline
Last seen: 1 week 3 days ago
Admin
Joined: Jul 27, 2011

I just want to say that this is incredibly awesome. Keep up the great work!


Truth is an excuse for a lack of imagination. ~Elim Garak

lynkfox
lynkfox's picture
Offline
Last seen: 14 hours 27 min ago
ModeratorPlaytester
Joined: Nov 01, 2012

Wow. With some deep research there is a lot that excell sheets can do!

 

If you go take a look at the 'raw data' of the form youll see a few additional sheets - live time updating! (sorta, mostly, up to a certain point then it seems i have to manually update the ranges it pulls data from)

 

https://docs.google.com/spreadsheet/ccc?key=0AqClP82b_XgZdFVreEhkOWJYcmlvcDNMbWppejh5aGc#gid=0 -- to take a look - see the new sheets on the bottom? 

 

 

Anyways, villain is done, still have to do Hero - but im going to have to go through all 187 games and add the incap field in manually, since i changed how it was done on the form - and its a good thing I did, cause it makes the method ive learned to gather the data much easier.

 

once all this is done, next month ill be able to just manually enter the data into the 'official statistics' one (the one that looks pretty with colors) and then can sort by greatest to least, makint it -much- clearer, and get some awesome looking graphs in there as well :)


Lynkfox.
http://sentinelswiki.com/ The Sentinels of the Multiverse Wiki

http://mindwanderer.net/sotm/ - SoTM Statistics! Updated DAILY!

PM me if you're interested in playing with the Statistics Data!

lynkfox
lynkfox's picture
Offline
Last seen: 14 hours 27 min ago
ModeratorPlaytester
Joined: Nov 01, 2012

another post on the update

 

I only have a few more forumals to work out (man all these paranthesis are driving me INSANE!) and then all the data can be pulled automatically from the sheet ...

 

and in the process ive already noticed some issues - like some how i missed a game here, or there, or input things wrong :P With 175ish entries its no surprise i made some mistakes! When I finish these formulas I may 'rerelease' the january update, in order to make things perfect :)

 

 

 

(if any of you are curious, here is the formulat to determine if a hero was in a 5 player game)

 

=if($A$1="is_calculation_on",ArrayFormula(SUMPRODUCT( ((first_hero=$A3)+(second_hero=$A3)+(third_hero=$A3)+(fourth_hero=$A3)+(fifth_hero=$A3))-( (first_hero=$A3)+(second_hero=$A3)+(third_hero=$A3)+(fourth_hero=$A3))*(fifth_hero="(None)") ) ),"off")

 

 

there - might- be a more effecient way to do that? but... im not a mathmatician, statician, or engineer :p


Lynkfox.
http://sentinelswiki.com/ The Sentinels of the Multiverse Wiki

http://mindwanderer.net/sotm/ - SoTM Statistics! Updated DAILY!

PM me if you're interested in playing with the Statistics Data!

arenson9
arenson9's picture
Offline
Last seen: 1 day 4 hours ago
ModeratorPlaytester
Joined: Aug 08, 2011

lynkfox wrote:

 (if any of you are curious, here is the formulat to determine if a hero was in a 5 player game) =if($A$1="is_calculation_on",ArrayFormula(SUMPRODUCT( ((first_hero=$A3)+(second_hero=$A3)+(third_hero=$A3)+(fourth_hero=$A3)+(fifth_hero=$A3))-( (first_hero=$A3)+(second_hero=$A3)+(third_hero=$A3)+(fourth_hero=$A3))*(fifth_hero="(None)") ) ),"off")  

This formula seems to add up all of the times a hero was used and then remove the times in which that hero was used in a 4-hero game. What about 3-hero (or even 2-hero) games?

Suggestion: Use some intermediate cells. One possibility is to first calculate how many times a hero was used in a two-hero game, than use that result to help calculate how many times a hero was used in a three-hero game, then use that result to help calculate how many times a hero was used in a four-hero game, etc. Another possibility is for each game to calculate a cell that marks the game as to how many heroes were in it, and then calculate how many heroes were in a five-hero game by only adding up games that are already marked as five-hero games.

 

What would _REALLY_ help you is if you could use functions. Apologies if this is something you know already, but what a function does is wrap up a set of calculations that you want to use more than once so you don't have to write it more than once. There are lots of heroes, so you are probably copying and pasting the formula you use to calculate the number of times a hero was used in a five hero game for each hero. If you could write the formula once and put in into the function, than you could just call that function for each hero, so if you ever needed to fix/change/upgrade the formula, you could just fix/change/upgrade the function. Welcome to the world of programming! This can be done in Microsoft Excel using Visual Basic for Applications.


Hi. My name's Andy. Feel free to call me Andy, since, ya know, that's my name. (he/him/his)

If I am not for myself, who will be for me? If not now, when? If I am for myself alone, what am I? -- Hillel

lynkfox
lynkfox's picture
Offline
Last seen: 14 hours 27 min ago
ModeratorPlaytester
Joined: Nov 01, 2012

im not sure if Gdocs Sheets can handle functions - as once a budding computer scientist (before i flunked physics 3 times and decided to  be a chef :P) I did indeed try to see if i could use functions, but was unable to find the process for doing so. Because for some reason attempting to download the gdoc corrupts the file every time, ive kept everything in gdoc for now Yet to find a way around this (it might be because im using gdoc regions, which are namesets in excell and may not translate properly. Or because im still using 2010 excell?) -- If you know how to use functions in Gdocs Sheets ill gladly take the advice for ease of updating later.

 

and i am not certain why it does not -need- the - 3 hero games (i remove the 2 hero games from the data sheet manually)  -- when I put in the - 3 hero game section it ends up giving me like 30 games. Which is far from correct. I /believe/ it is because of the way the data is laid out -- 

hero name, incap, heroname, incap, heroname, incap, heroname, incap, heroname, incap -- all in seperate cells-

 

so a 3 hero game looks like

 

heroname, incap, heroname, incap, heroname, incap, none, incap, none, incap

 

and a four looks like

 

heroname, incap, heroname, incap, heroname, incap, heroname, incap, none, incap

 

so in calculating the pair, and removing the 4 hero games from a the pool of 5 player games, it is automatically removing the 3 hero games as well.... that -shouldn-t be what its doing but everything ive double check and manually checked says its calculating the correct number. I don't know enough to tell you why

(im still trying to figure out exactly how ArrayFormula and SUMPRODUCT work, actually - why does finding the number of times a villain used give the same value with both -  =ArrayFormula(SUMPRODUCT((villains=$A3))) and =ArrayFormula(SUMPRODUCT((villains=$A3)*(villains=$A3))) --- shouldnt that expodentially give a value thats all wrong for the second formula? But it doesn't - they give the same value. Why?

it has been a long time since my programming days (10 years about) and trying to keep all the () straight in a single line is killer. Why can't excell (gdoc sheets in this case :P) have a multi line editor? (and if it does and you know where it is pleeeassee tell me?)

 


Lynkfox.
http://sentinelswiki.com/ The Sentinels of the Multiverse Wiki

http://mindwanderer.net/sotm/ - SoTM Statistics! Updated DAILY!

PM me if you're interested in playing with the Statistics Data!

lynkfox
lynkfox's picture
Offline
Last seen: 14 hours 27 min ago
ModeratorPlaytester
Joined: Nov 01, 2012

double post cause i think my post got too long and it stopped putting carriage returns in  (oor because i copied directly out of gdoc sheets it left some residue cell information somwhere in there and wouldnt process a return - silly things)

 

 

for instance you can see here(maybe)

 

 

 
Absolute Zero 51 35 68.63% 18 2 35.29% 11 9 16 9 12 6 9 8 3 3 17 7 28 22 6 6
 
 
the last 6 numbers are - 3hero games, 3 hero gamewins, 4 hero games, 4 hero game wins, 5 hero games, 5 hero games wins
so if you add them them up - 17+28+6 - you get 51 (the first number, or number of games played) and 7+22+6 = 35 (the second number, number of wins)
 
 
so... no idea why the formula that -seems- to need another subtraction of games isn't needing it.
 
 
 
the values if you are curious are (games played, win, win percent, times incapped, but still won, %incap, 1st Pos, win, 2nd pos, win, 3rd pos, win, 4th pos, win, 5th pos, win, 3 player team, win, 4player team, win, 5player team, win)

 


Lynkfox.
http://sentinelswiki.com/ The Sentinels of the Multiverse Wiki

http://mindwanderer.net/sotm/ - SoTM Statistics! Updated DAILY!

PM me if you're interested in playing with the Statistics Data!

flamethrower49
Offline
Last seen: 1 year 6 months ago
Playtester
Joined: Apr 04, 2012

There is no way in the stats page to relate an alternate victory condition.  As of right now, we have to write them in the notes field.  I think this would be best solved by having different answers to the game won/lost section.  It seems to me like this would be easier to code, too, but hell if I know anything about that.  smiley

What was the result of the game?

  • Victory by destroying the villain
  • Victory by destroying Gloomweaver's Relics
  • Defeat by incapacitation
  • Defeat by Terralunar Impulsion Beam
  • Defeat by Voss's Minion Overrun
  • Defeat by Omnitron's devices after Omnitron's defeat
  • Defeat by [redacting] [redacted]
ketigid
Offline
Last seen: 3 months 22 hours ago
Joined: Oct 11, 2011
  • Defeat by Mars explosion.
  • Defeat by Silver Gulch [redacted].
lynkfox
lynkfox's picture
Offline
Last seen: 14 hours 27 min ago
ModeratorPlaytester
Joined: Nov 01, 2012

Given the way that i am pulling the stats, that doesn't ... quite... work

 

but ill change the question on 

 

If you Lost, was it because of HP or an Alternate Loss Condition?Enter: Incapacitated if every hero was taken out, or a cards alternate loss - such as TerraLunar Beam, or Self Destruct Sequence

 

to something more easy to understand (a checkbox like that, probably)


Lynkfox.
http://sentinelswiki.com/ The Sentinels of the Multiverse Wiki

http://mindwanderer.net/sotm/ - SoTM Statistics! Updated DAILY!

PM me if you're interested in playing with the Statistics Data!

flamethrower49
Offline
Last seen: 1 year 6 months ago
Playtester
Joined: Apr 04, 2012

It's not just the alternate loss conditions to worry about - it's any alternate win conditions, like Gloomweaver's relics.  We need to try to have a way to put that into the form proper, rather than just the notes field.

lynkfox
lynkfox's picture
Offline
Last seen: 14 hours 27 min ago
ModeratorPlaytester
Joined: Nov 01, 2012

gloomweaver relic is on that new version of that question and it now says how did the game end rather the how you lost


Lynkfox.
http://sentinelswiki.com/ The Sentinels of the Multiverse Wiki

http://mindwanderer.net/sotm/ - SoTM Statistics! Updated DAILY!

PM me if you're interested in playing with the Statistics Data!

Ironic
Ironic's picture
Offline
Last seen: 8 months 3 weeks ago
Joined: Jan 09, 2013

Excuse me, but I am a little confused by these "most effective" numbers.  I would assume that means one hero from every game is considered the most effective from the game, but then they shouldbe averaging out in the high twenties, insteaf of the low seventies.  Is every hero except one considered "most effective" each game?  If so, why?


"Is it a bird?"
"Is it a plane?"
"No... it's ironic!"

flamethrower49
Offline
Last seen: 1 year 6 months ago
Playtester
Joined: Apr 04, 2012

If I'm not mistaken, Most Effective is merely the percentage of winning games that the hero played in, not a title assigned to one character per game.  Legacy was in 36 games, 31 of which the heroes won.  If we define "effective" as (at least theoretically) contributing to a win, then he is 86.11% effective.  

lynkfox
lynkfox's picture
Offline
Last seen: 14 hours 27 min ago
ModeratorPlaytester
Joined: Nov 01, 2012

Flamethrower is right. Without sitting down and watching every single game, and then coming up with some way to measure 'effectiveness' within the game, there is no way to determine who is most effective in any indivdiual game.

 

Rather that stat is simply - THis hero wins more than others - Legacy rarely ever is in a loosing game.  -- 83percentof the time (as of this post) if legacy isin the game,  the heroes win. You can draw from that (moreso once we have more data) that legacy is a large contributing force to wining the game 

 

of course with our current data #s its not perfect. Wraith:Price of freedom has won 100% of her games. Of course shes only been in 2 games XD  But we're easily pushing 200-300 games a month (we have over 130ish new games n the tracker already and its only half way through the month!)  and that just means that it will continue to get more and more accurate as time goes on. 

 

 

But you also can't look at a hero just by that single stat - its ment to be a quick 'This is the most likely to be in a winning game' stat yes, but ther are other things to consider

 

like Legacy -also- has a 23% incap rate. Meaning in 23% of his games he was incapitated. But that doesnt add up to a 100 if you notice with the wins... because ~30%  of the time if he was incapitated, the heroes still won.  -- which is one of the better numbers in that category. Which all this does is prove with numbers and hard data that Legacy is one of the 'More Successful' heroes in the game (i refuse to say /better/ but there is clearly a track record here that needs to be noted.


Lynkfox.
http://sentinelswiki.com/ The Sentinels of the Multiverse Wiki

http://mindwanderer.net/sotm/ - SoTM Statistics! Updated DAILY!

PM me if you're interested in playing with the Statistics Data!

Matchstickman
Matchstickman's picture
Offline
Last seen: 11 hours 30 sec ago
Playtester
Joined: Apr 10, 2012

The one statistic I can't see on the sheet, and the on I am most interested in, is of the wins how many occurred with at least one hero incapacitated? Almost all of the wins in my group are with all heroes up, we find that heroes are like dominos, once one falls it's hard to keep any standing.


Stop lurking, it makes you look like a villain target
When you do things right, people won’t be sure you’ve done anything at all

Temporary image until an H emoticon is added!

lynkfox
lynkfox's picture
Offline
Last seen: 14 hours 27 min ago
ModeratorPlaytester
Joined: Nov 01, 2012

hmm. Im not sure how to formulate that to pull information from the sheet, though I think I could. 

 

But you can also look at the Raw Data  at https://docs.google.com/spreadsheet/ccc?key=0AqClP82b_XgZdFVreEhkOWJYcml... 

and do a quick scan yourself - ill try to see if i can't pull a formula out for that one - might not make it onto the official sheet but would be availabel to view elsewhere


Lynkfox.
http://sentinelswiki.com/ The Sentinels of the Multiverse Wiki

http://mindwanderer.net/sotm/ - SoTM Statistics! Updated DAILY!

PM me if you're interested in playing with the Statistics Data!

stormire
Offline
Last seen: 4 years 4 months ago
Playtester
Joined: Nov 17, 2012

I think I can be of assistance with that. If I download the raw data as an excel file I'm fairly certain I can write a formula which would calculate the percentage of games won with various heroes/positions incapped. The only thing I don't know is if Google Docs uses the same formula commands as excel.

lynkfox
lynkfox's picture
Offline
Last seen: 14 hours 27 min ago
ModeratorPlaytester
Joined: Nov 01, 2012

it does and it doesnt - it does not have all the commands (other wise i would be using Functions instead of arrayFormula 's ... bleh.)

 

you can look at the format for the setup to see if you can try to write a formula, but again - a good chunk of the commands that excell has arent in gdocs yet


Lynkfox.
http://sentinelswiki.com/ The Sentinels of the Multiverse Wiki

http://mindwanderer.net/sotm/ - SoTM Statistics! Updated DAILY!

PM me if you're interested in playing with the Statistics Data!

Matchstickman
Matchstickman's picture
Offline
Last seen: 11 hours 30 sec ago
Playtester
Joined: Apr 10, 2012

Having actually had some free time that I did not spend on playing Sentinels, I spent my free time making some quick formulas to analyse data about Sentinels!

 

Just some quick calculations on incapacitated heroes and the current results;

There are 48 wins with incapacitated hereoes (12.73%)

There are 203 wins with no incapacitated hereoes (53.85%)

There are 126 losses (no matter the status of the heroes) (33.42%)

 

Looks like 1 in 7 wins is a win with an incapacitated hero, higher than I would have thought. My personal stat is 3 incap wins out of 27 total wins (48 games total), so I'm at average for incap wins but letting the side down with almost 50% losses!

 

 

(I can provide the formulas I used if people want them for the spreadsheet, I wrote them on Excel)


Stop lurking, it makes you look like a villain target
When you do things right, people won’t be sure you’ve done anything at all

Temporary image until an H emoticon is added!

lynkfox
lynkfox's picture
Offline
Last seen: 14 hours 27 min ago
ModeratorPlaytester
Joined: Nov 01, 2012

I just want to say.

 

Vossh has now overwhelmed the earth with his Minions once.

 

And Baron Blade has crashed the moon into it /twice/

 

Awesome. Just. Awesome.


Lynkfox.
http://sentinelswiki.com/ The Sentinels of the Multiverse Wiki

http://mindwanderer.net/sotm/ - SoTM Statistics! Updated DAILY!

PM me if you're interested in playing with the Statistics Data!

Ameena
Ameena's picture
Offline
Last seen: 17 hours 5 min ago
Joined: Oct 15, 2012

I've started keeping a note of our game stats so I can contribute here - Just uploaded our stats for this weekend :). I went home early 'cause of the snow and didn't want to risk that the trains might not be running later this evening (plus it'd be dark and even colder by then). So we didn't get round to fighting Blade, Rat, Gloomy, or the Ennead. We did the other eight, though. And finally beat the Matriarch after ages of failing to do so! And we did it in Atlantis (we choose our villain and environment combos via dice roll, so this is never our choice!), where she kicked our arses twice last week! Legacy's combo of Fortitude, Lead from the Front, and Next Evolution (Psychic immunity) meant we could basically ignore all penalties for killing birdies even before she flipped :D. Plus Haka had eaten most of her stuff by the latter half of the game - he had the Mask, both cohorts, and a load of other birdies all stuffed under Savage Mana. Bunker managed to get a few cards under his Omni-Cannon and in the last round he let rip with this (buffed by both Legacy and the Adept, as was Haka), dropping the Matriarch's health to the point where Haka could unleash his own assult with Savage Mana, finishing her off :D.

We had a similar victory earlier against Citizen Dawn, in which Haka had about nine(ish) cards under Savage Mana, plus was buffed by Legacy. He then used Haka of Battle and poured his entire hand (about 17 cards or something like that) into fuelling the damage Savage Mana was about to do. Just to make a big finish of things. Because Dawn had something like 2hp left. Ahh, now that was satisfying :D.


I am the Wordweaver...

Basically, I like writing stuff ;)

Melonball
Offline
Last seen: 3 years 8 months ago
Joined: Jan 19, 2013

This initiative is superb! Excellent work!

Pages