*Author

Offline JangooTopic starter

  • Sr. Member
  • ****
  • Posts: 877
  • Reputation Power: 0
  • Jangoo hides under a Cloak.
  • New to You
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) https://elementscommunity.org/forum/index.php?topic=21654.msg280376#msg280376
« Reply #12 on: February 28, 2011, 05:31:24 pm »

i tested your tool a bit... and im totally gonna use it.
only a little improvment i like to have:
a place where you can put in a deckcode.
(made me one below the decksize/version cell)

im used to place my deckcode in the sheet, to be sure to use the same deck again and for obvious practical reasons.
Ok will do when updating the Statmasta to 1.27.

I actually had a deck-code cell in there and was going to include it in the
forum-code-generator but then I thought "what the hell ... people are going
to post their deck anyways, its no that hard after all ..." so, like some other
things, it had to go for the sake of keeping the sheets clean and focused
on essentials.
But you're right, just for keeping ones data 100% in order, it is pretty useful.

Waiting for some clarifications as to what will happen with those 5 new gods,
then I'll update the sheets.


Can you also upload it on localhostr.com?
May I ask why? Are the others not working or ... ?

At first, I only had file-upload because it counts the dowloads which is pretty
awesome as a kind of feedback. Then Beef caused me to also upload on rapidshare,
and now this ...   :D


Offline Olidot

  • Full Member
  • ***
  • Posts: 212
  • Reputation Power: 3
  • Olidot is a Spark waiting for a buff.
  • New to Elements
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) https://elementscommunity.org/forum/index.php?topic=21654.msg280398#msg280398
« Reply #13 on: February 28, 2011, 06:54:37 pm »
Does this work with openoffice...?


twixy10

  • Guest
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) https://elementscommunity.org/forum/index.php?topic=21654.msg283883#msg283883
« Reply #14 on: March 05, 2011, 05:11:07 pm »
After searching for an hour for a nice excel spread sheet i finally found a good one (yours). So i hope you will update it soon ;)

slayerboy

  • Guest
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) https://elementscommunity.org/forum/index.php?topic=21654.msg284773#msg284773
« Reply #15 on: March 06, 2011, 05:41:29 pm »
Does this work with openoffice...?
Nope, and it doesn't work with Google Docs either.  Macro support for everything that Excel does is where Open Office/ Libre Office are lacking.

Looks like a cool tool, but unusable by me because I don't have windows.  :P

Offline JangooTopic starter

  • Sr. Member
  • ****
  • Posts: 877
  • Reputation Power: 0
  • Jangoo hides under a Cloak.
  • New to You
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) https://elementscommunity.org/forum/index.php?topic=21654.msg286145#msg286145
« Reply #16 on: March 08, 2011, 01:49:42 pm »

After searching for an hour for a nice excel spread sheet i finally found a good one (yours). So i hope you will update it soon ;)
Will do soon. 
I am a little confused as to what timeframe we can expect for any changes
concerning the new gods ... Are there any conclusive news about Jezebel
staying in the Pandemonium or being taken out yet?


Does this work with openoffice...?
Nope, and it doesn't work with Google Docs either.  Macro support for everything that Excel does is where Open Office/ Libre Office are lacking.

Looks like a cool tool, but unusable by me because I don't have windows.  :P
Sorry to hear that.
I guess I could come up with a version that bypasses the macro sometime.
The thing is: It is needed to ensure proper data-input and even while I was
thinking "Aww hell, I made the darn table so I certainly won't screw up my
data-input" it actually happened all the time that I forgot to enter something.




Offline JangooTopic starter

  • Sr. Member
  • ****
  • Posts: 877
  • Reputation Power: 0
  • Jangoo hides under a Cloak.
  • New to You
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) https://elementscommunity.org/forum/index.php?topic=21654.msg290814#msg290814
« Reply #17 on: March 15, 2011, 03:32:43 am »


Allright, seems like any final tweaks to the new FGs may be weeks down the road
and so is a possible response from Zanz as to what the card-spin rate currently really is.


So I went ahead and added Akebono, Hectate, Jezebel, Lionheart and Serket to the list,
changed the tables formulas accordingly and thus:


UPDATED to Elements 1.27


Enjoy.



Offline Olidot

  • Full Member
  • ***
  • Posts: 212
  • Reputation Power: 3
  • Olidot is a Spark waiting for a buff.
  • New to Elements
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) https://elementscommunity.org/forum/index.php?topic=21654.msg294545#msg294545
« Reply #18 on: March 20, 2011, 07:31:45 am »
After searching for an hour for a nice excel spread sheet i finally found a good one (yours). So i hope you will update it soon ;)
Will do soon. 
I am a little confused as to what timeframe we can expect for any changes
concerning the new gods ... Are there any conclusive news about Jezebel
staying in the Pandemonium or being taken out yet?


Does this work with openoffice...?
Nope, and it doesn't work with Google Docs either.  Macro support for everything that Excel does is where Open Office/ Libre Office are lacking.

Looks like a cool tool, but unusable by me because I don't have windows.  :P
Sorry to hear that.
I guess I could come up with a version that bypasses the macro sometime.
The thing is: It is needed to ensure proper data-input and even while I was
thinking "Aww hell, I made the darn table so I certainly won't screw up my
data-input" it actually happened all the time that I forgot to enter something.
:( I'll just have to do it the old fashioned way...

Offline Essence

  • Legendary Member
  • ******
  • Posts: 4340
  • Country: us
  • Reputation Power: 57
  • Essence is truly a Titan, worthy of respect and acknowledgement.Essence is truly a Titan, worthy of respect and acknowledgement.Essence is truly a Titan, worthy of respect and acknowledgement.Essence is truly a Titan, worthy of respect and acknowledgement.Essence is truly a Titan, worthy of respect and acknowledgement.Essence is truly a Titan, worthy of respect and acknowledgement.Essence is truly a Titan, worthy of respect and acknowledgement.Essence is truly a Titan, worthy of respect and acknowledgement.Essence is truly a Titan, worthy of respect and acknowledgement.Essence is truly a Titan, worthy of respect and acknowledgement.Essence is truly a Titan, worthy of respect and acknowledgement.
  • Voice of the Oracle -- Jezzie's Pimp -- Often Gone
  • Awards: 2nd Trials - Master of Water1st Trials - Master of WaterFG Deck-Designer - The OutcastsShard Madness! Competition WinnerEpic 3 Card Design Competition WinnerElder Recruiter
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) https://elementscommunity.org/forum/index.php?topic=21654.msg297070#msg297070
« Reply #19 on: March 24, 2011, 04:17:02 am »
GG said make it rain.

Go, go gadget rainmaker.

+Karma.  Leik...srsly.
If something happens and you think it deserves my attention, feel free to PM me. Other than that, I'm probably here if you want to shoot the breeze.

Offline JangooTopic starter

  • Sr. Member
  • ****
  • Posts: 877
  • Reputation Power: 0
  • Jangoo hides under a Cloak.
  • New to You
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) https://elementscommunity.org/forum/index.php?topic=21654.msg302226#msg302226
« Reply #20 on: March 31, 2011, 12:13:50 pm »


Does this work with openoffice...?
Nope, and it doesn't work with Google Docs either.  Macro support for everything that Excel does is where Open Office/ Libre Office are lacking.

Looks like a cool tool, but unusable by me because I don't have windows.  :P
:( I'll just have to do it the old fashioned way...
Sorry for replying so late, my new provider considers weeks of waiting for a new
line as regular procedure. Gotta go to public places for the time being.  :(

Concerning OpenOffice, etc.:

What exactly is the problem/error-message you get when trying to open the file?
I am asking because you might as well accept the fact that the Macro doesn't work
and still use the table as long as it is opened ... All stats will still be calculated, just
the async-warning won't work.


GG said make it rain.

Go, go gadget rainmaker.

+Karma.  Leik...srsly.
Lol, I used to watch Inspector Gadget when I was a kid. When I recently came across
an episode on some old-school childrens channel it just wasn't the same anymore ...  :(




kirchj33

  • Guest
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) https://elementscommunity.org/forum/index.php?topic=21654.msg317698#msg317698
« Reply #21 on: April 22, 2011, 04:49:15 pm »
This thing is a breeze to use!  +karma since I haven't done that yet.

Here is a sample of how it looks when posting...


deck  1.27 CCYB - unupped 
player  kirchj33 
version  1.27 
games  25 
win-loss-(EM)    5-20-(4) 
time (h:m:s)  01:25:07 
min/game  03:24 
win-rate  020% 
normalized   n.a. 
FGei[c]* (http://elementscommunity.org/forum/index.php/topic,14626.0.html)  1372 
FGei[cn]* (http://elementscommunity.org/forum/index.php/topic,14626.0.html)  n.a. 
    Statmasta™3000     *assumed card-spin /win: 35%        
      

"
winslossesskipsEM/Wins
Akebono
Chaos Lord
Dark Matter
Decay
Destiny
Divine Glory
Dream Catcher
Elidnis
Eternal Phoenix
Ferox
Fire Queen
Gemini
Graviton
Hecate
Hermes
Incarnate
Jezebel
Lionheart
Miracle
Morte
Neptune
Obliterator
Octane
Osiris
Paradox
Rainbow
Scorpio
Seism
Serket
 
 
  1
  2
  1 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
  1
 
 
 
 
 
 
 
 
 
  3
  1
 
  2 
 
 
 
 
 
 
 
  2
  1
 
  2
 
  1
  2
  1
  1
 
 
  1
 
 
  1
 
 
 
 
 
 
 
 
 
 
 
 
 
 
  1
 
 
 
 
 
 
 
 
  1
 
 
 
 
 
 
 
 
 
 
  2
  1
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
  1
 
 
 
 
 
 
 
 
"      

A couple of thoughts...

1.  The enter deck code cell on the first page seems to be protected?  I couldn't enter mine (fairly unimportant)
2.  (We've already discussed this)  It would be great to get uber accurate win results for HP/dependant non-EM wins.  Also an electrum tracker would be great!

To show the simplicity... this post took me less than 60 seconds to show great stats!
      

tdog0001

  • Guest
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) https://elementscommunity.org/forum/index.php?topic=21654.msg318548#msg318548
« Reply #22 on: April 23, 2011, 10:46:18 pm »
Oh wow, as Kirch said, it's a breeze to use.

I love it.

Offline JangooTopic starter

  • Sr. Member
  • ****
  • Posts: 877
  • Reputation Power: 0
  • Jangoo hides under a Cloak.
  • New to You
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) https://elementscommunity.org/forum/index.php?topic=21654.msg319902#msg319902
« Reply #23 on: April 25, 2011, 11:02:41 pm »

This thing is a breeze to use!  +karma since I haven't done that yet.
Oh wow, as Kirch said, it's a breeze to use.

I love it.
Thanks guys ... glad you like it.  :)

@kirch:  What happened to the display of your win-rate?
It is set to format to "00,00%" so I am kind of puzzled how you got "020%"   .


Quote
A couple of thoughts...

1.  The enter deck code cell on the first page seems to be protected?  I couldn't enter mine (fairly unimportant)
2.  (We've already discussed this)  It would be great to get uber accurate win results for HP/dependant non-EM wins.  Also an electrum tracker would be great!

To show the simplicity... this post took me less than 60 seconds to show great stats!
1. Damn, the "bug" is back. I thought I had dealt with this but apparently not.
For some reason, my Excel seems to reset the cell-formatting for this particular field,
hence joining 3 cells to make a large one keeps failing. Whyever the error-message claims
it has something to do with sheet-protection.
In the next update, this field will simply be 1 cell to avoid complications.



2. Hehe, yes. For our study-purpose, I will create the Statmasta-"Pro":
Über-accurate results based on HP-left for any match that is not a straight loss or EM.

However, the regular Statmasta will just get an update featuring an approximation
to score- and electrum-gain (as is already done with electrum won/game right now) because I hear
too many people complaining that entering the times for ones games is waaay too much work already.
I don't think anybody would bother to mark down HPs considering how little impact it has, especially on
electrum-gain.

Here is the math behind HPs left and elec-/score-gain:



x -> HPs left
y (top) -> score-gain dependent on HPs left
y (bottom) -> electrum-gain dependent on HPs left
HP=0 (loss) and HP=100 (EM) are not in this graph

So elec- and score-gain is a linear function.
If you finish with 1HP you get 35elec and 65score.
If you finish with 99HP you get 59elec and 89score.
The exact middle-ground is at 50HPs with 47elec and 77score. 

47elec and 77score are the values used by the regular Statmasta in the next update.
Speaking for electrum won (outside of card wins) the worst possible case of
miscalculation would be something like this:

"CCYB", 50% win-rate, 6min games, 20% EM-rate
100 games -> 50won, 10/50 EM, 50 lost, 10hours played

Now if the player were to win every single match that is not an EM (=40matches) with 99HPs,
the Statmasta would cheat him out of 12 electrum per match, so:
40x12=480electrum ... over the course of 100 games played in 10 hours!

With the above assumptions about the decks speed, that would amount to only 48 elec/hour (FGei).
Now considering nobody will ever win every match with either 99HPs or EM and considering that most
likely some of those unrecorded gains are balanced by some matches barely won with e.g. 20HPs,
that is really not worth worrying about.


Now for score-gain the case is a little different since there are no card-wins that make
the actual per-game score-gain just a sideshow ... there's just one way to increase score:
65-89 (120 for EM) per game and that's it.
If I were to play a deck that consistently finishes above the 50HPs-line and yet only gets
77 score per match accounted for, the difference would be worth noting:

"CCYB", 50% win-rate, 6min games, 20% EM-rate
100 games -> 50won, 10/50 EM, 50 lost, 10hours played
all non-EM games won = 72HPs left on average

72HPs left mean a score-gain of 83 for the match, so the player actually won:

40x83=3320score (wins)
10x120=1200score (EMs)
50x-30=-1500score (losses)
Sum: 3020score net-profit

The Statmaste, assuming HP50 for each game won, awards:

40x77=3080score
10x120=1200score (EMs)
50x-30=-1500score (losses)
Sum: 2780score net-profit

Basically, the HP-oriented deck got cheated out of 240score over the course of 100 games here.
That is 8% of the actual score-gain total ... not really acceptable for testing-purposes even when
considering that other speed-based contenders wind up with a score-gain of 0 or even a slight loss.
(Meaning the tendency of a decks score-gain should be obvious either way ...)

Either way, the score-track in the regular Statmasta will really just be an approximation whereas
electrum-gain can be considered accurate in both future versions.



 

blarg: