Tournament discussion

[Drivehud.com]

Originally Posted by bailey

It's "easy" enough to export the data into a spreadsheet, but to eliminate the duplicate lines is the hard part. If someone could just explain how to do it and sticky the info, that would be really helpful. Kris? Matt? anyone?

Agreed. Export is easy. To eliminate unnecessary lines and combine all data is not as easy. I'm super surprised there's not some 3rd party tool for this by now, or some spreadsheet someone has created and shared.

[chazzycat]

Originally Posted by bailey

It's "easy" enough to export the data into a spreadsheet, but to eliminate the duplicate lines is the hard part. If someone could just explain how to do it and sticky the info, that would be really helpful. Kris? Matt? anyone?

Not sure if this is exactly what you're asking, but if it helps I basically use the "subtotals" feature in Excel.

First you have to combine all data together on one sheet (sorted by player name) and select the entire dataset. Then use "subtotals" feature and at every change in "player name" you add subtotals to "WAR" or whatever stat you want. Then you hit the little box with the number 2 towards the top left and that collapses everything to just show the totals, which you can then copy/paste out.

[ubernoob]

I'm trying to do some testing on player archetypes at least, if not specific players themselves.

What do you think a good run of tournaments is, accounting for RNG. 20-25 tournaments or so with the lineup? Obviously the more data points the better, but as a starting point to test some out where do you think is a fair number to start at?

[chazzycat]

I would suggest you start collecting data now. When tournaments get too old you won't be able to access the stats anymore. So the only way to get a sizable sample is to start collecting periodically and keep it up for days/weeks depending on how many tourneys you enter.

I like to aim for 400 IP / 1000 PA (about 2 seasons of data), but more is always better.

[skep]

Would like to see prizes in the 32s upgraded so that 3-4th get a pack instead of 200pp. That's the logical prize progression and right now getting 3-4th feels bad man.

Could improve and smooth out prizes quite a bit actually. To give you a few examples.

SnaggleJ Silver 64

1st 2Dpacks
2nd 1Dpack
3rd 2Gpacks (probably a future version thing, but why not have 3rd/4th play for a difference in prizes? They gotta wait till end anyways.
4th 1Gpack
5th-8th 2Rpacks
9th-16th 1Rpacks

TWIPT Silver 128

1st 4Dpacks
2nd 2Dpacks
3rd 1Dpack
4th 2Gpacks
5th-8th 1Gpack
9th-16th 2Rpacks
17-32nd 1Rpack

People like getting something and it won't hurt the economy to push a few more packs out.