*Author

Offline JangooTopic starter

  • Sr. Member
  • ****
  • Posts: 877
  • Reputation Power: 0
  • Jangoo hides under a Cloak.
  • New to You
STATMASTA™realtec - Keep it real (FG-statkeeping tool) https://elementscommunity.org/forum/index.php?topic=21654.msg277191#msg277191
« on: February 23, 2011, 07:08:02 pm »
Sick and tired of fiddling with your notepad?

Too busy to punch that wall of numbers into your calculator?

"Normalized" is Chinese to you?





    Jangoo-Enterprises proudly presents:

  S T A T M A S T A™ r e a l t e c
                                     Keep it real 


- Easy to handle data-input
- Childproof data-input warning system
- Fully automated calculation of stats
- Hundreds of stats, including normalized win-rate, time per game, EM-percentage, FGeis,
  electrum won, score/h, card-spin percentage and many many more
- Automated statsheet-generator and god by god-generator for posting on the forums
- Optional input of advanced data: taylor the test-design to your personal needs
- Beautiful graphics
- 100% freeware


The next generation of FG-stat-taking-technology awaits you!

Hit the download-button today!




STATMASTA™realtec intool pictures:
(actually from an earlier version but you'll get the idea)


Input-sheet ... your grandma could take those stats!





Stat-sheet ... really? There is an FGei(c) for individual gods?





Side-stats ... holy crap, 100k electrum made!





Forum-code generators ... Feel like posting? How about right now?





DOWNLOAD STATMASTA™realtec
              (FOR OPEN OFFICE ONLY)

PLEASE, if you intend to produce valid, unadulterated stats DO NOT
change anything in the tools code, formatting, sheets, rows, columns etc.
You WILL most likely break it.
Just use the tool as is delivered ... thank you.


In case you encounter something you consider irregular, be it a strangely high
or low stat,  broken forum-codes, an obvious difference between the formatting- or
display of the tool as viewed on the above screenshots and your tool  etc.,

Please file a short bug-report in this thread or via pm.
Include your version of OpenOffice and a short description of the problem.



Highly recommended reading just one post away:     
                 
                       S T A T M A S T A™ r e a l t e c
                                     Quick-Guide




« Last Edit: February 09, 2013, 02:22:36 am by Jangoo »

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.msg277192#msg277192
« Reply #1 on: February 23, 2011, 07:09:10 pm »



        S T A T M A S T A™ r e a l t e c

                                                               Quick-Guide



Welcome to the STATMASTA™realtec quick-guide.

The STATMASTA™realtec is an MS-Excel- or open-office-file which will ease the pains of taking
comprehensive stats when playing against FalseGods with a specific FG-deck.

This short illustrated tutorial will show how to use this tool correctly
and explain some of the stats and background-mechanics.
(Yes, all illustrations are actually from an earlier version but in terms of
functionality and where everything is, nothing has changed.)


Content of this post:

1. Getting started
     Requirements
     Setting up your software
2. Deciding on your test-design
3. The 3 sheets
     Input-sheet -> How to take your data
     Sheet2: "Hard" stats
     Sheet3: "Soft"- and side stats
4. Forum-codes = Posting made easy
5. End of Quick-guide / FAQs



1. Getting started


Requirements:

In order to use the STATMASTA™realtec you will need MS-Excel or open-office.
Any Excel release from 2002 to 2007 should do just fine.
2010 is said to be very downward compatible, but there has been no conclusive
testing for the STATMASTA.

For open-office, dowloading the latest release (3.41. as of now) is highly recommended.

MS-Excel, LibreOffice and google-docs are currently not supported!

The STATMASTA™realtec is a very delicate tool in need of specific formulas, formats and macros
to function correctly. The abovementioned software CANNOT correctly employ the provided
.xls or .ods file and will yield incorrect data, limited content as well as severly reduced usability!


Setting up your software:

First of all, make sure you have downloaded the correct version!
If you are using Excel, get the Excel-release.
If you are using open-office, get the OO-release.

Once you open the file, Excel/OO will ask you whether you want to activate the macros which are
built into the STATMASTA. In order to do so, you will have to change the security settings
in your program to medium (or low, not recommended):
 
extras -> options -> security (tab) -> macro-security (very bottom of dialogue) -> medium

Now close and open the STATMASTA-file again and click "activate" once Excel/OO asks you about the macros.

No worries, the STATMASTA™realtec uses exactly one macro to perform a task which Excel/OO can't perform on its own.
Jangoo-Enterprises vouches for the harmlessness of this macro (which is much easier than actually getting it
certified *cough)

Congratulations, you are good to go!



2. Deciding on your test-design

Before you get going with your deck-testing, you should decide on what it
is you want to be testing for. The STATMASTA™realtec features a large variety
of stats. In order to calculate and display most of them, specific data about
your FG-games beyond the win/loss structure of the games is needed.

Generally, these three test-designs are intended:


:fire Minimal testing :fire

You only put in the number of games won, lost, skipped and EMed.
This "historical" method of taking stats for FG-decks is very time-saving
but only produces the win-rate and EM-rate as somewhat significant stats.
In all honesty, that approach is outdated as of now and compares to
e.g. evaluating a cars performance by looking at its horsepower only.

:time Timed testing :time

In addition to the number of games won, lost, skipped and EMed, you also
put in the time you played each game, which is displayed after each match in
the details screen.

This method of taking stats for FG-decks produces a variety of stats that express
your decks true efficiency, most significant of which are the FGei-stats.
It also yields a few interesting side-stats such as min/game played.

Unless you really want to have an accurate account of your decks score-performance,
I suggest using this method for your regular, everyday FG-deck-testing as a perfect
compromise between effort and results.

:life Scientific testing: Timed and electrum-based :life

In addition to the data used in Minimal- and Timed testing, you also put in
the number of "raw" (before card-spins) electrum won after each non-EM game.
.
This is undoubtedly THE method for getting 100% accurate and conclusive stats.
The accuracy of your electrum-related stats will be improved by up to 3%.
Most importantly though, this method will fully validate all score-related stats
since the exact score gained can be calculated from your raw electrum-gain per game.

Testers that participate in a study, really want to produce 100%-pro stats and/or
want to gain conclusive stats about a decks score-performance should use this design.



3. The 3 sheets

The STATMASTA™realtec features three sheets:

An input-sheet ("Input"), where all the data gathered during the playing-process is entered
and some sub-totals are calculated and displayed.

The first statsheet ("Stats") features only the most significant "hard" stats which are suited for
comparing deck- and playerperformance because they generalize a decks performance without tapping
into your luck when spinning cards from the slotmachine.
On this sheet you can also find the hard facts about your testing-sample, such as games played, time played etc.

The second stat-sheet ("Side") features a variety of "soft-" and side-stats that give a realistic account
of your game-experience. These stats are entirely "empirical", meaning they show what actually happened
as in, e.g., "I was sooo lucky to get a card every time I won, so I made like 10k electrum in one hour."
 
You can access those three sheets by clicking on the tabs in the bottom left corner of your Excel-window.
The following sections deal with handling and meaning of each of these three sheets.


The Input-sheet -> How to take your data




On this sheet, all your data-input is done while playing your matches.
The input-fields "wins", "losses", "skips", "EMs", "$ won (noEM)", "time win", "time loss", "time skip",
"cards won" and the "background" fields can be easily identified by their dark-red bold framing.
They are the only fields in the table that can and should be altered by the user.

It is helpful to keep two things in mind when using Excel/OO to avoid complications:

Use ENTER to finish data-input
Click ONCE -> press F2 to get to the end of a cells content


The use of the input-fields is as follows:

:fire I (wins, losses, skips)  :fire

unlock: games played, win-rate and normalized win-rate,
approximation to the stats score/total and score/game

Use these three columns to enter your basic data about winning,
losing and skipping games against each False God. Directly increase
the number in the respective cell by one whenever you won, lost or
skipped a game. (Click cell -> enter new number)
In order to take ANY stats, noting down this data is absolutely required!

:fire Ib (EMs/wins)  :fire

unlock: EM%
+accuracy: FGei-stats, $-earned-, $/game-, all score-related stats

Whenever you win a match with an Elemental Mastery, meaning with 100%
of your HPs, you should increase the number in the respective cell by one.
Note, that the input in this column is EMs out of all the wins you had,
meaning that you should add 1 in the win-column AND 1 the EM-column.

(For decks that have more than 100HPs max. health, refer to the FAQs
at the end of this post)

:time II (times: win, loss, skip)  :time

unlock: time-total, time/game, FGei(e), FGei(c), FGei(cn), score/h and score/h (n).
The two score-related stats will remain an approximation unless you also record
electrum won. See below -> III.

These three columns are used to enter your pure time needed for each of the games
you played and noted down in the "games" columns. After each game, Elements will show
you a game-time in seconds in the upper right corner of the "win-" or "details"-screen.
Enter this number into the respective cell by using the following formula:

=[time1]+[time2]+ etc.   (without "[" brackets of course)

It is imperative that you don't forget to enter a "=" when you put your first time into a cell.
Without it, Excel cannot properly calculate the time-related stats!
Also, if you record skipped matches, always enter a time of at least 1 (sec) in the respective cell!
(Realistically you should enter the time actually needed to quit the god. The actual issue here
is however that Excel needs a value > 0 here to calculate all of your stats.)

Hint: Click cell -> F2  will take you directly to the end of the cells formula, so all you will have
to do is enter a "+" and your next time once you get going.

:life III ($ won (noEM:life

unlock: HPs left/win
100% accuracy: all electrum related stats, all score related stats

This is a recent addition to the STATMASTA-series.
If you are interested in testing your deck to the max (see above: Scientific test-design),
you should enter the "raw" electrum won after each regular win in this column:

After each game you win, Elements will show you electrum won right above the
slotmachine in the middle of the "win-screen".
- It is important that you use the electrum-amount displayed BEFORE you spin the slotmachine!
- Make sure you only enter regular wins here, no EMs and certainly no losses
- win-electrum ranges: 35-59 electrum*, no more, no less ... be exact about this

- If the electrum-amount is 120 or higher, you got an EM-win
DO NOT enter this into the $-won(noEM) column!*

(You already entered your EM, and the electrum that goes with it,
by upping the count in the "EMs/wins"-column.)
- If the electrum-amount is -30, you got a loss. DO NOT enter this either.
(Your loss, and the electrum that goes with it, is already entered
by upping the count in the normal "losses"-column.)

To enter the electrum-amount into the respective gods cell, use the following formula:

=[electrum]+[electrum]+ etc.   (without "[" brackets of course)

It is imperative that you don't forget to enter a "=" when you put your first electrum
amount into a cell
. Without it, Excel cannot properly calculate the respective stats!

Hint: Click cell -> F2 will take you directly to the end of the cells formula,
so all you will have to do is enter a "+" and your next electrum-amount once you get going.

*For decks that have more than 100HPs max. health, refer to the FAQs
at the end of this post


:time !!! -> the async warning :time

As long as there is an active async-warning, a large number of stats cannot be
displayed on sheet2+3: All time-related stats - time-total, time/game, all FGeis,
score/h, score/h (n) - will be set to "n.a."

See on top under "deciding on your test design" and below under the detailed
stat-sheet descriptions for more information.

This field is not an input field.
It will show you when something went wrong with the data-entry in field "games"
and/or "times" by displaying "!!!" in the respective cell. In the example, something
 is wrong with the wins or times (for wins) against the FG Incarnate.

A !!! async-warning will show whenever:

- You did not activate macros when opening the file
- You forgot to enter a time (or game), which means that the number of games and
the number of times noted are not the same (asynchronous).
- You made a formula mistake entering a time. Most likely you forgot to start the
cell with a "=" but you could also have accidently entered an invalid value like a
second "+" or any other value that is not a number, a "+" or a "=" .
See above "II: Time" for how the formula should look like.

:life $?! -> $won(noEM) async warning :life

As long as there is a "disabled", all score-related stats - score-total, score/game,
score/h, score/h (n) - are just an approximation. All electrum-related stats
will be slightly less accurate and the HPs left/win stat will be set to "n.a."

See on top under "deciding on your testing-design" and below under the detailed
stat-sheet descriptions for more information.

This field is not an input field.
It works similar to the games<>time-async-warning:
It will show you when something went "wrong" with the data-entry under "wins"
and/or "$ won(noEM)" by displaying "disabled" in the respective cell and consecutively
for the entire column in the top row. In the example, the $-tracking is disabled (=invalid)
for the FG Seism.

A "disabled" will show whenever:

- You did not activate macros when opening the file
- You did not enter an electrum-amount for a regular win (not EMs!),
which means that the number of wins and the number of electrum-
amounts noted are not the same (asynchronous).
- You made a formula mistake while entering an electrum-amount.
Most likely you forgot to start the cell with a "=" but you could also
have accidently entered an invalid value like a second "+" or any other
value that is not a number, a "+" or a "=" .
See above "III: $ won(noEM)" for how the formula should look like.

:underworld Cards won  :underworld

unlock: $ earned, $ per game, card-win% and FGei(e)]

Whenever you win a card (or two, or three) from a FalseGod you can enter the
number of cards won in this column. Recording this is not critical for any of the
"hard" stats, so significant data for comparing decks will still be intact if you
don't record your card-wins. It can be interesting to see how much electrum
you actually made though, or how good a cardwin-rate certain FGs have ...
Directly increase the number in the respective cell by clicking and typing
the new number.

:underworld Background  :underworld   

Here, you should enter your deck-name, your player-name and the version
of Elements you have been using while taking your stats.
These will show up on your forum-code-statsheet later.

The Deck-code field is just for your convenience so you will always know
which exact deck you played while taking the stats. In this version, an
automated deck-posting is not included.

The deck-code should be entered as follows:

Right-click the cell -> paste contents (just below the regular "paste")
  -> unicode-text  OR text


The cell will then resize the code but it can be copied and pasted again
by simply right-clicking on it.

Congratulations!
You now know everything you need to know to use the STATMASTA™realtec !

The following section deals with the two stat-sheets.
Detailed information on the stats calculated by the STATMASTA will be given,
as well as a short guide on how to quickly post your results on the forums.



Sheet2: "Hard" stats




This is the first and most important stat-sheet.
Here, all the basic data on your games and advanced "hard" stats are displayed as
long as you took the required data and entered it correctly in sheet1:Input (see above).

These stats are called "hard" because they are untouched by your luck when spinning cards.
This means, they are likely to be replicated by someone else playing your deck.
"Hard" stats are suited for comparing decks and individual player performance
as long as the number of games played is sufficiently high.


Main-stats
This row displays the totals of all the stats calculated, meaning it shows your decks
(and your) overall performance against ALL FalseGods.
The main-stats on this sheet are bound to display fully valid stats for your entire
series of games. This implies, that even if you have just a single active async-warning
(times or $won) on the Input-sheet, the respective main-stat will be influenced by it.
E.g., if you made a mistake recording time in a match ("!!!") all time-related stats will
be set to "n.a.". Similarly, if you have a gods $won-track "disabled", the score/h and
score/h (n) stat will be displayed with a "~" to signify that this stat is just an approximation.


Hard-stats details
The details for each stat can be viewed for each individual FalseGod in this field.
Each gods stats operate autonomously, meaning that the STATMASTA gathers
the specific data for each god seperately and calculates an individual display of
your decks performance against this one god.
As long as there is no active async-warning in the Input-sheet for a particular god,
all the stats are available. Active warnings for single gods do not block the others:
  • !!!-async (time missing) does block time-related stats for each god seperately
  • "disabled" $won-track does set score-related stats to "~" to signify an approximation
  • "disabled" $won-track will also lead to this gods FGei(c) using the average amount
    of 47electrum/regular win but the mainstat will still consider detailed electrum entered
    on the Input-sheet for all the other gods

Normalized-stats  (n)
The three stats on the bottom of the sheet are calculated by "normalizing" your FalseGod-
encounters, which means that uneven numbers of encounters are evened out to make a
good statistical guess as to what your decks win-rate, score/h and FGei(c) against ALL
the gods should actually be.
E.g., if you lost 20 times against Hermes but generally played only around 4 matches against
all the other gods, your Hermes encounters will be balanced in your favour:
Your norm-win-rate, score/h (n) and FGei(cn) will be higher than your actual win-rate, score/h and FGei(c).

The norm-stats will be unlocked once you have played at least 3 games against each
FalseGod. Note that this is still much too low from a statistical standpoint. If you want
more reliable norm-stats, you should try and play at least 10 matches against each god.
(Common opinion in this community.)[/font]


Sheet3: "Soft-" + Side-stats



This is the second stat-sheet.
Here, all your "soft" stats and some side-stats are displayed.

Main-stats:
FGei(e) and HPs left/win are bound to ALL gods stats similarly to the main-stats
on Stat-sheet1, meaning if there is an active async-warning (II: time for the FGei(e)
and $won-track for the HP-stat) they will be set to "n.a."
All the other stats on this sheet tie in directly with the detailed stats for all gods
and display a direct, empirical total of all gods no matter if there is an async-warning:

When there is a $won-async warning on the Input-sheet for a single god only,
this gods electrum-gain from regular wins will be calculated by using the average
amount of 47electrum/win but the mainstat will still consider detailed electrum entered
on the Input-sheet for all the other gods.
Similarly, the stats score/total and score/game will display a "~" in this case but
they will still consider detailed score-gain from the other gods, which is calculated based
on the electrum-amount entered in the $won(noEM) column on the Input-sheet.


"Soft" stats:  FGei(e), $earned, $/game, cardwin%
"Soft"-stats are stats that relate to your luck when spinning cards.
Soft stats generally give a nice account of how much you made against which FG but
they are not really suited for comparing deck- and playerperformance. Hence, they are
more or less just "for your interest".
However, if a sufficiently high number of games is played, these stats can indeed indicate
which FGs are most profitable due to a higher chance of winning a card. This has nothing
to do with the specific deck used though.


Side-stats: score/total, score/game, HPs left/win
A selection of stats that are also not really suited for comparing deck-performance but
are nevertheless "good to know".
In Elements, the HPs you have left when scoring a win determine your electrum- and
score-gain through a linear function, while electrum and score are directly proportional.
This is used to recalculate scoregain and HPs left from the electrum-amount entered
by the player. HPs left/win refers to regular wins only since it is obvious with how
many HPs EMed games are finished.



4. Forum-codes -> posting made easy




On the very bottom of sheet2:Stats you can copy -> paste the forum codes for

- a comprehensive statsheet featuring the most significant hard stats
- a god by god breakdown showing all your FG encounters in a table

Any stats that cannot be calculated for any reason will be displayed as "n.a." in the statsheet.
Score-stats that are merely an approximation (because there is an active $won async-warning)
will be displayed with a "~" as in the OO/Excel-table.

I suggest: right-click on the cell -> copy -> open post in forum -> insert OR ctrl+v

Whatever you do, make sure not to erase any values from the code you just inserted into
your forum-reply window, not even the blanks and line-breaks that make the god by god-code
look so long in your reply-window!

The statsheet will look as follows:

  deck     Shak'ar (juked)   
  players     Jangoo   
  version    1.27 
  win-rate     32%   
  $ track ?    enabled 
  win-rate (n)     33,56%   
  games    150 
  Score/h     108   
  win-loss-(EM)     48-102-(0)   
  Score/h (n)    148   
  time (h:m:s)     05:54:42   
  FGei[c]*    4386   
  min/game     02:22   
  FGei[cn]*    4548   
      Statmasta™realtec                                                               
 
     

The god by god breakdown will look as follows:


Spoiler for god by god:
  score/h  FGei(c)   Statmasta™realtec    wins losses skips EM/Wins
   136
   136
   -268
   -1346
   439
   549
   -135
   378
   -527
   146
   405
   -311
   -519
   -519   
   -1082
   621
   621
   621
   1023
   124
   821
   139
   -220
   -80
   406
   319
   -342
   13
   13
   5331
   3482
   2531
   -1346
   5012
   7859
   4076
   5144
   1939
   4326
   7499
   2018
   2068
   2526   
   -1082
   6405
   7844
   6281
   7254
   3110
   8252
   4454
   3168
   3807
   7124
   4196
   1504
   2935
   3402
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
   2
   2
   1
   
   2 
   3
   1
   2
   1
   1
   2
   1
   1
   1
   
   3
   3
   3
   3
   1
   3
   1
   1
   1
   2
   2
   1
   2
   2
    4
    4
    4
    4
    2 
    2
    3
    3
    7
    2
    3
    5
    6
    6
    6
    2
    2
    2
    1
    2
    2
    2
    4
    3
    3
    3
    5
    5
    5
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     

     
If you do not wish to post your breakdown in a spoiler (which is pretty common), you can also
remove the [ spoiler] and [ /spoiler] brackets at the end and beginning of the code.



5. End of Quick-guide / FAQs

You have reached the end of the STATMASTA™realtec Quick-guide.

Although the tool has been carefully crafted and bugtested, there is always the
possibility that unexpected errors, mainly through compatibility issues, occur.

In case you encounter something you consider irregular, be it a strangely high
or low stat,  broken forum-codes, an obvious difference between the formatting- or
display of the tool as viewed on the above screenshots and your tool  etc.,

Please file a short bug-report in this thread or via pm.
Include your version of OpenOffice and a short description of the problem.

Your help is greatly appreciated.


I would like to thank you for using this product and wish you all the best in your
future FG-encounters.



FAQs:

- What is an FGei?
-> FGeis are stats that measure a FG-decks efficiency more accurately than a mere win-rate
or actual income generated. The rather accurate number stands for: Electrum / hour  earned
Further reading: FGei (http://elementscommunity.org/forum/index.php/topic,14626.0.html)     


- Some of my stats are not calculated, instead, there is "n.a." all over the place.
-> First of all, make sure you followed the instructions for activating macros under
"setting up your software" at the beginning of this guide.
If your macros do work, you probably didn't enter the required data in the respective
input-fields on sheet1:Input OR you made a mistake when entering the data.
Mistakes can be tracked by checking the async-warning columns on sheet1.
Most commonly, the times entered for the games played are not adhering to the formula
"=time+time..." or you simply forgot to enter a time for a game or the game as such
(while you did enter a time). A single times-mistake (= ansychronisation between games
played and times) will yield "n.a." for all timed stats concerning this particular god as well
as all time-related main-stats.
Note that in order to get the three normalized stats win-rate(n), score/h(n)
and FGei[cn] you will have to have played at least 3 games against each FG
or else the norm-stats will show "n.a."


- The games I mark as "skipped" in my input-field are counted as losses! Wth?
-> Yes, the STATMASTA will count these games as losses.
This is mostly because comparing deck-performances is hard when all kinds of exceptions
are made. FG-stats in Elements traditionally express a deckperformance against ALL gods,
with skip-stats being a nice extra at times.
Consider first, that you did in fact lose those games and the electrum and score that
go with this loss.
Also, the times you entered for these games will likely be =1+1+1 ... or at least very small
realistic times if you had to check out how the draw was before "skipping" the game. ;)
This means that your time-related stats, most notably your FGeis, will still go up   and your
time-saving skip-strategy is being taken into account after all.
Skipping should not be about artificially bumping your win-rate but all about farming-efficiency ...
so are the FGei-values.   


- How do I create so called "skip-stats"?
-> Very good question! In order to truly show the community what your deck can do, you
should indeed provide skip-stats since they are pretty much the "farming-guide" for the deck:
Which god is (literally) worth your time and which one isn't?
Many good players will post two sets of stats:
1. The statsheet against all gods as played during testing
(including those miserable 6min-losses against Rainbow where you thought you might still win)
2. A statsheet that will omit all the gods that yield a low winrate and/or too lengthy games

The procedure to create skip-stats with the STATMASTA is, unfortunately, manual but easy to do:
0) Make sure you have played enough games. You should at least have unlocked the normalized stats ...
a) Choose which gods you wouldn't waste any time on by comparing the individual gods FGei(c)s.
-> There are numerous ways to mathematically "optimize" the deck performance by setting gods as skip-gods.
-> Generally, any god that doesn't have an FGei(c) as high or higher than your FGei(cn) (the average) wouldn't be
worth it since he will only drag the overall peformance down.
-> Yet, there are various reasons for going a somewhat softer approach. Read this prodecure used in the FG-efficiency study to get an idea how to chose skip-gods sensibly

For each skip-god:
b) Move ALL GAMES PLAYED to the games-column "skip" on the input sheet
c) Then delete ALL electrum gains and all EMs noted (and all cards won)
d) Now enter "=1+1+1+1+1 ..." in the times-column, with the number of "1"s being as high as the total number of games skipped

Result:
-> You now have skipped (and therefore lost) every single game against this god but only spent 1sec of time on each game
-> The Statmasta recalculates your FGeis based on this very efficient strategy ... even losing constantly won't drag down a stat that means "electrum/hour" when only a few seconds each hour are actually spent losing.  :D


- My deck uses Shards of Divinity/StoneSkins and thus has more than 100HPs ... anything to consider here?

1. For regular wins (no EMs) Elements does not make any difference.
Spoiler for examples: electrum + score gains for regular wins:
1/100 HPs  = 35 elec + 65 score
1/200 HPs  = 35 elec + 65 score
50/100 HPs = 47 elec + 77 score
50/148 HPs = 47 elec + 77 score
99/100 HPs = 59 elec + 89 score
99/300 HPs = 59 elec + 89 score
132/??? HPs = 68 elec + 98 score
... as long as its not an EM, you will always get electrum based on your HPs with score = electrum + 30
-> If you use the scientific test-design, you can just go ahead and enter your win-electrum as usual even if its more than 59 electrum. Besides taking these coins into account, the Statmasta will also correctly display your HPs left/win on the third statsheet.
-> If you don't use the scientific test-design, you probably should do so, since gaining more electrum from higher HPs is a vital part of your decks electrum-performance. If you don't enter values in the $won(noEM)-column, the Statmasta will assume an average 47electrum (=50HPs) for each regular win ... not exactly what your deck does on average, right?


2. For EMs Elements will add 0.5 electrum + 0.25 score as a bonus for every 1HP above 100HPs
Spoiler for examples:electrum + score gains for EMs:
100/100 HPs = 120 elec + 120 score
124/124 HPs = 132 elec + 126 score
148/148 HPs = 144 elec + 132 score
... and so forth ... note how 100HPs is the reference-value with electrum = score, while score falls off the more HPs are involved

-> Unfortunately, the Statmasta currently doesn't have an option to enter these special EMs.
Depending on your deck this could make a notable difference though.
Spoiler for Example-calculation for missing electrum + score through high HP-EMs:
E.g. using a deck with 2 SoDs (148HPs max., 48x0.5=24electrum more, 48x0.25=12score more), a 50% win-rate, 50% EM-rate and 2min games will get you:
30 games/h
  15 losses
  15 wins
    7.5 regular wins => no problem here (see above)
    7.5 EMs => 7.5 x 24 elec = 180 elec/h missing
                => 7.5 x 12 score = 90 score/h missing

~180 FGei-points and ~90 score/h-points ... not very much indeed but likely ~2-4% of your total FGei and ~10% of your total score/h. A future version of the Statmasta will address this.

You have two options/workarounds to address this problem for the time being:

a) You just note down these EMs as regular EMs while recording your data.
-> When you are done with your set, you look at the numer of wins, the EM-rate, the time played in hours and make a good guess for a typical HP-level to EM-finish a game, from which you get the typical Bonus in electrum and score (0.5elec/1HP, 0.25score/1HP).
-> You then recalculate the missing electrum and score:
    wins x EM-rate x bonus elec / time played (h) = FGei-Bonus missing
    wins x EM-rate x bonus score / time played (h) = score/h-Bonus missing
-> For the purpose of posting the statsheet, you could simply add these values to the ones the Statmasta gave and make a little note what you did.

b) You note down all your EMs as regular wins.
-> This way your electrum stats (including FGeis of course) will be perfectly accurate
-> The downside 1: Your score stats will get totally screwed over, since regular wins pay out relatively much more score than EMs
(see above how in regular wins electrum+30=score, but in EMs its electrum=score or even electrum>score)
-> The downside 2: Your HPs left/win stats will display way to high values. Not that they matter all that much ...
-> Either way, if you go this path, you should delete the score-stats from the stat-sheet and/or leave a note about this when posting.


« Last Edit: February 11, 2013, 04:06:59 pm by Jangoo »

kobisjeruk

  • Guest
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) https://elementscommunity.org/forum/index.php?topic=21654.msg277194#msg277194
« Reply #2 on: February 23, 2011, 07:15:48 pm »
link unavailable bruh

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.msg277199#msg277199
« Reply #3 on: February 23, 2011, 07:26:10 pm »

link unavailable bruh
Should work now ... somehow the forum didn't permit to upload it directly to server even though the file doesn't breach the 5MBs. I went with a hosting-site ...  ???



Offline 3D House of Beef

  • Full Member
  • ***
  • Posts: 255
  • Reputation Power: 4
  • 3D House of Beef is a Spark waiting for a buff.
  • Greetings and salutations.
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) https://elementscommunity.org/forum/index.php?topic=21654.msg277216#msg277216
« Reply #4 on: February 23, 2011, 08:01:37 pm »
Yeah.  Blank images followed by "Waiting for abload.de"

I'll check back.  Looking forward to it.

Edit:  A Wild Image Appears!  (just took a few minutes)

Edit:  10 minutes in... still downloading...  still eager.

Edit:  One hour in, still waiting for download to start.  Starting to have fantasies about google docs.

Edit:  Some hours later.  Stopping the download and restarting it results in, "Download-Ticket abgelaufen."  I can only imagine that is some kind of hex that is being hurled against me by a council of foreign witches.  For now, they have won.  I will steel my resolve and return to crush these heretics and receive my rightful reward.  This excel file will be mine.  Oh yes.  It will be mine.

Offline Acsabi44

  • Hero Member
  • *****
  • Posts: 1954
  • Country: hu
  • Reputation Power: 28
  • Acsabi44 is a proud Wyrm taking wing for the first time.Acsabi44 is a proud Wyrm taking wing for the first time.Acsabi44 is a proud Wyrm taking wing for the first time.Acsabi44 is a proud Wyrm taking wing for the first time.Acsabi44 is a proud Wyrm taking wing for the first time.
  • Coming to get ya.
  • Awards: Slice of Elements 6th Birthday CakeBronze DonorWeekly Tournament WinnerSlice of Elements 4th Birthday CakeWeekly Tournament Winner14 Club - Most Expensive players during War AuctionWeekly Tournament WinnerWeekly Tournament Winner
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) https://elementscommunity.org/forum/index.php?topic=21654.msg277229#msg277229
« Reply #5 on: February 23, 2011, 08:13:40 pm »
Awsum, good sire!
+ karma.
[17:04:00] Dragon6: ‹@Acsabi44› You are Rage Potion, Phase Dragon and Momentum all in one
Interested in game strategy,  theory and other kinds of advice? Clicky clicky!

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.msg277353#msg277353
« Reply #6 on: February 23, 2011, 11:57:11 pm »

Yeah.  Blank images followed by "Waiting for abload.de"

I'll check back.  Looking forward to it.

Edit:  A Wild Image Appears!  (just took a few minutes)

Edit:  10 minutes in... still downloading...  still eager.

Edit:  One hour in, still waiting for download to start.  Starting to have fantasies about google docs.

Edit:  Some hours later.  Stopping the download and restarting it results in, "Download-Ticket abgelaufen."  I can only imagine that is some kind of hex that is being hurled against me by a council of foreign witches.  For now, they have won.  I will steel my resolve and return to crush these heretics and receive my rightful reward.  This excel file will be mine.  Oh yes.  It will be mine.
Hmmm ... that sucks, funny description though. ;D

I tried downloading it myself and it worked just fine so ... lets see if anybody else has these
problems. I will also provide a different hosting-service for your convenience. ;-)


hrmmm

  • Guest
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) https://elementscommunity.org/forum/index.php?topic=21654.msg278033#msg278033
« Reply #7 on: February 25, 2011, 12:17:15 am »
got it downloaded without problems (file upload).

and im pretty impressed ... awsome work!

+karma &
gonna link (http://elementscommunity.org/forum/index.php/topic,16745.0.html) this one ^^

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.msg279991#msg279991
« Reply #8 on: February 27, 2011, 11:28:15 pm »

got it downloaded without problems (file upload).

and im pretty impressed ... awsome work!

+karma &
gonna link (http://elementscommunity.org/forum/index.php/topic,16745.0.html) this one ^^
Thanks hrmmm ... that tool-thread of yours is pretty awesome.
Funny how you end up completely missing certain things just because you never look
at certain sections.  ;)



Offline GG

  • Legendary Member
  • ******
  • Posts: 2253
  • Reputation Power: 28
  • GG is a proud Wyrm taking wing for the first time.GG is a proud Wyrm taking wing for the first time.GG is a proud Wyrm taking wing for the first time.GG is a proud Wyrm taking wing for the first time.GG is a proud Wyrm taking wing for the first time.
  • Retired from everything...
  • Awards: Slice of Elements 5th Birthday Cake3rd Trials - Master of Gravity2nd Trials - Master of GravityC-C-C-Combo Maker Winner!Weekly Tournament WinnerChampionship League 1/2011 WinnerWeekly Tournament WinnerWeekly Tournament WinnerChampionship League 3/2010 2nd PlaceNew Passive Ability Competition Winner
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) https://elementscommunity.org/forum/index.php?topic=21654.msg279999#msg279999
« Reply #9 on: February 27, 2011, 11:55:56 pm »
......amazing. +karma.

You're gonna get karma rained down upon you.
Ex-Master of :gravity, still a fervid supporter! GO GRAVY!

hrmmm

  • Guest
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) https://elementscommunity.org/forum/index.php?topic=21654.msg280298#msg280298
« Reply #10 on: February 28, 2011, 12:44:06 pm »
(...)
Thanks hrmmm ... that tool-thread of yours is pretty awesome.
Funny how you end up completely missing certain things just because you never look
at certain sections.  ;)
dont tell me ... this place is getting huge^^

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.

Offline RavingRabbid

  • Legendary Member
  • ******
  • Posts: 5044
  • Country: it
  • Reputation Power: 85
  • RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.RavingRabbid is a mythical and divine giver of immortality, one of the Turquoise Nymphs.
  • Lord Seagull
  • Awards: Slice of Elements 11th Birthday CakeSlice of Elements 10th Birthday CakeSlice of Elements 7th Birthday CakeDeckbuilding Competition: The Face of Mother NatureSlice of Elements 6th Birthday Cake7th Trials - Master of WaterWinner of Warrior's Preparation - PvP Event14 Club - Most Expensive Players during War AuctionWeekly Tournament WinnerWeekly Tournament WinnerSlice of Elements 3rd Birthday CakeTeam PVP #1 Winner5th Trials - Master of Water3rd Trials - Master of WaterChampionship League 3/2011 WinnerWinner of 2nd Off-Topic Quiz LeagueWinner of 2nd Element Quiz LeagueWinner of 1st Off-Topic Quiz LeagueWinner of 1st Element Quiz LeagueChampionship League 2/2011 WinnerSlice of Elements 2nd Birthday Cake3-Man Team PvP #1 Winner
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) https://elementscommunity.org/forum/index.php?topic=21654.msg280361#msg280361
« Reply #11 on: February 28, 2011, 04:45:09 pm »
Can you also upload it on localhostr.com?
There are things worse than eating tuna directly from the tin

 

anything
blarg: