I'm looking for some inspiration.

Since i have being playing thrones i have recorded every single game that has been played . This data incorporates the following :

Person playing

House

House name ( refelctive of the nature of the deck build )

Points result

Plots used

Jouse and Melee recorded

What initially started as a potentially interesting analysis ( most powerful house, player etc etc )

became an obsession......

Anyway.... i now have this huge amount of data i wish to compile in some form of spreadsheet or programme but find myself overwhelmed as to where to start.

Any ideas regarding layout, format ?

Thanks

I advise you to use excel to make a chart. This allows you to make automatic charts and graphs and makes it easy for storing data.

I advise you to use excel to make a chart. This allows you to make automatic charts and graphs and makes it easy for storing data.

Excel is the natural choice but even then i am struggling as to how to complie with all the parameters.

I might be overthinking it but i want it show all the data at a snapshot depending on what you were looking for, As an example i would want to be able to look by house won, house lost, player won, house name etc

You could simply make a table?

You could simply make a table?

Yep and it may be some form of table but it is the formatting of this that i am struggling with. I think i will play about in excel and see what i come up with , at least i willm have a starting point

I have an excel spreadsheet where I did the same thing for my games. Shoot me a pm and I will send it to you. It's nothing fancy, but I Iike it.

I have an excel spreadsheet where I did the same thing for my games. Shoot me a pm and I will send it to you. It's nothing fancy, but I Iike it.

Thanks for this , i will definately have a look.

How do i send a pm ? I have looked at your profile but cant see the option ?

How do i send a pm ? I have looked at your profile but cant see the option ?

Good question. I thought they implemented a working pm solution with the forum update, but I can't find any.

Anyway, send me an email at helmut.hohberger AT gmail.com

How do i send a pm ? I have looked at your profile but cant see the option ?

Good question. I thought they implemented a working pm solution with the forum update, but I can't find any.

Anyway, send me an email at helmut.hohberger AT gmail.com

Hover over each other's name, there should be a user card that pops up. Left hand side 'Send Message'.

You can also go to your user control panel in the messages section

http://community.fantasyflightgames.com/index.php?app=members&module=messaging

How do i send a pm ? I have looked at your profile but cant see the option ?

Good question. I thought they implemented a working pm solution with the forum update, but I can't find any.

Anyway, send me an email at helmut.hohberger AT gmail.com

Thanks, email sent

I've often considered compiling this kind of data, but in general even if I'm playing many games, the datasets aren't large enough to draw meaningful conclusions by the time the meta changes (eg; chapter pack release or FAQ) and the data is obsolete.

I have been working on a user-friendly spreadsheet system to standardize regional/tournament data collection, and hope to spread that around the community to get some meaningful stats there.

Put the data in Excel, then make a Pivot table on that table. The Pivot table will then let you slice and dice the data however you want.

Waste of time imo. Not only does the meta change but the different skill levels of different opponents playing the same HAR makes a huge difference. Ultimately those stats will teach you nothing.

Well it looks like i will compile some kind of excel spreadsheet ,

I understand the meta changes but i do not consider it a waste of time, i am not looking to be taught anything but i find statistics interesting to find out information such as best player, best house and also following trends as the meta changes and subsequently the dominant houses/ decks.

If you have access to or the knowhow, you can use programs like R, SPSS, or SAS to run your statistical analyses. R is free and open source, but has a sharp learning curve.

If you have access to or the knowhow, you can use programs like R, SPSS, or SAS to run your statistical analyses. R is free and open source, but has a sharp learning curve.

Unfortunately this is beyond my skillset so will have to stick with excel.

I advise you to use excel to make a chart. This allows you to make automatic charts and graphs and makes it easy for storing data.

Excel is the natural choice but even then i am struggling as to how to complie with all the parameters.

I might be overthinking it but i want it show all the data at a snapshot depending on what you were looking for, As an example i would want to be able to look by house won, house lost, player won, house name etc

Google Pivot Tables. They pretty much do everything it sounds like you're looking to do.

Hijacking this thread a bit, but if I ever get my Tourney-Keeper(this is a tournament organizer application) ready, it most propably has somekind of statistic for tournament games.

What kind of statistic would be useful? Currently I'm thinking that you should be able to easily export at least tournament standings with house, agenda and restricted information, but I'm also storing all the games played trough tournament. So what kind of data should be stored to be useful for at least some kind of analysis of tournament(s)?

Also current plan is to store all the data to relational database.

If I were compiling stats I'd want to know:

House

Agenda

Restricted Card

Cards in Deck

Avg. Plots to Win

Avg. Plots to Lose

Avg. Plots

Avg. Power Advantage for Win (Winning Player - Losing Player)

Avg. Power Advantage for Loss

Avg. Power Difference

Overall Wins

Wins Against each House

Wins Against each Agenda

Wins Against each House/Agenda

Wins Against each House/Agenda/Restricted

Overall Losses

Losses Against each House

Losses Against each Agenda

Losses Against each House/Agenda

Losses Against each House/Agenda/Restricted

It might seem like a lot, but it really isn't. Just a bunch of calculations (which might be a lot depending on processor power I guess). That's what I can think of at the moment.

Even assuming you were given House/Agenda/Restricted and final result for each match, you'd still be missing number of plots (which, due to the existence of plot cycling is not necessarily the same for both players) and power gained, which are not recorded in any tournament I know of.

Well, my program is meant to be used by TO and they should know restricted/house/agenda of each player. Also at least in tournaments I have been running we ask power gained as well as winner of the game. Power gained is also needed now to calculate melee results.

Gathering plot information is out of scope for my application. Also not going to include cards in deck, because I think that is more "confidential" information and up to player does he/she want to share it.

Understandable. I just figured I'd name as many things off the top of my head I could think of that would be statistically significant and interesting to report on. Hope something helped there! Haha.

@Khudzlin - Hmmm... Interesting point on plots not being equivalent to turns played. Maybe it should've been rounds to victory instead of plots.

I'm literally salivating at the thought of this data.

If possible, could you get it into Google Fusion Tables? I think it's pretty awesome (even though I'm biased), and you can share it easily. It would also allow people to query it more ways pretty easily and add visualizations etc.

http://www.google.com/drive/apps.html#fusiontables

Maybe I should have started own thread instead of hijacking this one. Because I'm not entirely sure is sbarnabas refering to me or OP. Yes I think it is really neat idea to have lot of data, but to get data is tricky part. First I need to do the actual program and then people need to find it and start using it to run tournaments.

Also they need to agree that this data is good and publish it to somewhere, I'm not going to do application so that it sends tournament information to anywhere without permission.

Also any data gathering and/or mining features are now on low priority. First I need to do application that eases the pain on tournament handling, with correct seating algorithms for melee and joust, standigs, SoS and elimination rounds. I'm thinking of also starting of blog so people would be tuned on how things are proceeding, but first I need to start to do something to get things proceeding.

I was referring to the OP...

But - regarding tournament handling, it seems like there are probably programs already that handle that; is there some specific thing to thrones that I'm not seeing that wouldn't be covered? The only thing i can think of is that melee (at least at gencon) was random, and not even close to "swiss".