Turns to Win helper spreadsheet

[GG]

I looked through the forums looking for a spreadsheet I could use, and couldn't find any. So, I made one myself on Excel

The basic explanation is written in the spreadsheet. Enjoy!



The spreadsheet contains extra columns for extra information such as scores or money. If you don't have to use them, just don't.

Same with the first two columns ask for type of AI5. You obviously don't need it if you're testing AI3, etc. It's just that I realized, after going through 12 entropy AI5s in a row, that I should keep track of what AI5s I face as well.

[GG]

Now that I realize it, we could ask people to submit the Excel file instead of simply posting the ttw results so that we have the detailed results of every single game

[jmdt]

I use this for basic testing

[GG]

Updated with some bug fixes

[Kamietsu]

Don't have Excel So this is rather useless for me unless that google spreadsheet thing can open them.

[Scaredgirl]

Yea. This topic needs more Google Spreadsheet.

[hrmmm]

Yea. This topic needs more Google Spreadsheet.

indeed.

with the help from TimerClock14 (thank you again)...

let me introduce:
the copy paste friendly test sheet


Updates 2.3:
- win% included in the 1. line
- excel version is has now celle protection included.

link to the sheet (https://spreadsheets.google.com/ccc?key=0AkZwdvsMXcULdHU3ZmxMT25Lc3JGMlJnTFA5bWdIVXc&hl=de&authkey=CLX49Aw)

how to use it:

1. download it, from this post or in the google sheets for other formats.
wont make sense to let 10 ppl use this at the same time online
2. take a look
please note, that this sheed has lots of references between the different sheets.
only change the red block on the "information/results" sheet.
the "statdata" sheet is not that vulnerable to changes.
dont touch "copy this".
if you download it from this post (.xls), dont worry about this: you will get a warning if you try to write in vulnurable parts.

3. the sheets:

information/results:
- replace the red words with the correct information. these will be added in your deckpost automaticly.
- below you have the statistics overview, filled automaticly. you dont need to change anything there.

statdata:

- the "real" work sheet. here you add your testing results (you can get them all from the win/loose screen ingame, after a fight).
- just note a "1" for a win, em or losses.
if you win by a elemental mastery, only mark the "Em" field with a "1". (otherwise you get that counted as 2 wins, if you mark Win and Em).
- for getting the electrum/score statistics, just note your electrum/score before you start testing, and after a test session.

copy this:

- ctrl+a, ctrl+c, ctrl+v.
- just copy everything on this page to get a full forum post with all your data.

Deckname: (http://elementscommunity.org/forum)

Games: 12

Avg ttw: 6.111

Avg. sec/game: 75.556

Wins: 10

Losses: 2

Ems: 3

Win%: 83.33

posted by - Yourname

Code: [Select]

Deckcode

Score gained: 50 Electrum gained: 49 Time overall (min.): 11.333 Sec/Turn: 12.364 Score/Min: 4.412 Electrum/Min: 4.324

ttw 3: 0 ttw 4: 2 ttw 5: 2 ttw 6: 1 ttw 7: 2 ttw 8: 1 ttw 9: 1 ttw 10: 0 ttw 11: 0 ttw 12: 0 ttw 13: 0 ttw 14: 0 ttw 15: 0 ttw 16: 0 ttw 17: 0 ttw 18: 0 ttw 19: 0 ttw 20: 0

Add here a comment for this test/deck

i might do a better/more detailed tutorial later (if i get some time spared^^)

comming up next:
- stattool version of this
- fg version

[3D House of Beef]

I am interested, and nice work.

Take some Karma as a down payment on that tutorial you promised.

[GG]

Fixed the error that counted losses as wins with turn to win of 0.

[hrmmm]

the stats are now all rounded in the whole sheet.
looks better this way.^^

[darkfrogger]

add more features to it. right now its still easier to just tally it by hand and then calculate the averages on a pocket calculator.

[willng3]

add more features to it. right now its still easier to just tally it by hand and then calculate the averages on a pocket calculator.

I use a very similar spreadsheet like this for my stats calculations.  It's much easier and faster than doing things by hand.