Five Tribes Five Tribes

Forum

Suche
Forum » Ticket to Ride - the Board Game - English » Scoring and Long-term stats opensource sheet / template
Anzeigen: Heutige Nachrichten 
  
VerfasserThema
mkastler
Junior Member

Nachrichten: 7
Registriert:
April 2014
Scoring and Long-term stats opensource sheet / template Sun, 22 June 2014 18:46
Hey all, I just finished creating a template in Google Docs for an advanced ticket to ride scoring sheet that has a LOT of additional bells and whistles ... remaining train count, averages and %'s, charts and graphs, long-term scoring comparison, and more ... I've been play-testing it at home for a few weeks, but would love it if other TTR addicts would try and let me know if there are additions to consider, or things to drop?

I'm sure there's some similarly comprehensive ones already out there in Excel, but I started this one so that it would be available to anyone, open source, web accessible and customizable. It should work on mobile devices too, but I haven't tried that.

You can find it within the google template universe by searching on ticket to ride, or you'll see it here with this link:
https://drive.google.com/templates?q=ticket+to+ride&view =pub...

I think this direct link will also work:
https://docs.google.com/spreadsheet/ccc?key=0Aihqewrs7Ds6dGJ ...

If you search templates, there are actually 3 sheets there, two by me. One is an older one that is only for single games, the second "fully automated" sheet does the stats tracking I mention above, and includes macros and javascript. For the buttons to work you'll need to authorize their use - and that will also give you access to see the source code. My variable naming conventions are for crap, but otherwise it's pretty well documented so you can see what I did.

Appreciate ANY and ALL comments and suggestions - I'd love to tweak and keep making it better! Smile

-michael kastler

PS: Some extra history - this project actually started as a "proof of concept" at the school district my kids are attending - I'm a parent adviser on the tech committee and got into a polite disagreement about whether the free/cheap google apps and sheets for ed could fully supplant the very high priced MS Office that has a lock on us now. The only thing I've had difficulty doing is connect dynamic/live charts and sheets into a google doc - but I think using embed code I could do even that.

Long and short of it is that I showed off the project, people were impressed, and we're going 1:1 with chromebooks and ipads next year. Also, I think I gained some fresh meat .... erm, i mean new TTR players for our next game night! Rolling Eyes
      
Sysyphus - Pommard
Senior Member
T2R All Around Tournament 2011 Winner

Fan-Seite
Nachrichten: 2323
Registriert:
December 2007
Re:Scoring and Long-term stats opensource sheet / template Sun, 22 June 2014 19:25
You may want to know who started the game.
We did some statistics in the past, in a 2er-USA game with 2 players of the same level, we found out that the starter was winning 60% up to 80% against a way lower ranked opponent.
In multis, this factor is less important but still impacts the game.

I think the ultimate stat question in multiplayers :
How many moves the fastest player needed to launch the last round ?
(20 turns to get the necessary number of cards + number of tracks laid+ number of turns to take extra tickets)

The more moves, the more random the game turns to be.
The less moves, the better the table is.
If you are playing with good players, at least one of them should finish in due time, or will have the opportunity to finish in an expected low number of moves.
For Ticket to Ride, a large of range of data is needed : you can not identify skill by observing one or 3 games, but you can identify a pattern of skills over 50 games.
In 2er, you'd need less data to identify which player is the best. But for sure, the more, the better.

[Aktualisiert am: Sun, 22 June 2014 19:47]

      
mkastler
Junior Member

Nachrichten: 7
Registriert:
April 2014
Re:Scoring and Long-term stats opensource sheet / template Mon, 23 June 2014 02:22
Sysyphus - Pommard wrote on Sun, 22 June 2014 12:25

You may want to know who started the game.
We did some statistics in the past, in a 2er-USA game with 2 players of the same level, we found out that the starter was winning 60% up to 80% against a way lower ranked opponent.


That's very interesting ... the official rules state that the most 'experienced' player should start first - I assumed they had play tested and found that starting position was less advantageous. That may only apply, as you suggest, to the 3+ games though.

Quote:

I think the ultimate stat question in multiplayers :
How many moves the fastest player needed to launch the last round ? (20 turns to get the necessary number of cards + number of tracks laid+ number of turns to take extra tickets)


That's also an excellent observation ... my only problem with adding total game turns to the sheet as it stands is that collecting that data seems onerous - you'd have to use a clicker or counter every round, something along those lines, taking time out of the flow of gameplay.

I haven't played the online version of TTR, but is that tracked there? That seems a natural place to keep that data, tougher in an analog world. I'm curious though and will see if i can figure out a relatively easy way to track it.

Thanks - Great input! Quick q; have you played with the sheet itself, notice any issues or difficult figuring out how to enter scores, using the javascript macro buttons, etc? Or does it seem pretty solid?

[Aktualisiert am: Mon, 23 June 2014 02:23]

      
Sysyphus - Pommard
Senior Member
T2R All Around Tournament 2011 Winner

Fan-Seite
Nachrichten: 2323
Registriert:
December 2007
Re:Scoring and Long-term stats opensource sheet / template Mon, 23 June 2014 04:27
Your sheet seems to work well.

But like you said, to enter that amount of data is pretty painful.
I would need a secretary to make a meaningful use of it.

I know we can extract the score of certain players' matches but for the rest, I have no clue.
      
rasmussen81
DoW Content Provider
Designer's Oath

Fan-Seite
Nachrichten: 7095
Registriert:
July 2007
Re:Scoring and Long-term stats opensource sheet / template Mon, 23 June 2014 17:31
mkastler wrote on Sun, 22 June 2014 17:22

Sysyphus - Pommard wrote on Sun, 22 June 2014 12:25

You may want to know who started the game.
We did some statistics in the past, in a 2er-USA game with 2 players of the same level, we found out that the starter was winning 60% up to 80% against a way lower ranked opponent.


That's very interesting ... the official rules state that the most 'experienced' player should start first - I assumed they had play tested and found that starting position was less advantageous. That may only apply, as you suggest, to the 3+ games though.


Which official rules are you looking at to have the most experienced player start first? The rules say that the person who was on a train most recently should start first...
      
mkastler
Junior Member

Nachrichten: 7
Registriert:
April 2014
Re:Scoring and Long-term stats opensource sheet / template Mon, 23 June 2014 17:56
rasmussen81 wrote on Mon, 23 June 2014 10:31

mkastler wrote on Sun, 22 June 2014 17:22

That's very interesting ... the official rules state that the most 'experienced' player should start first - I assumed they had play tested and found that starting position was less advantageous. That may only apply, as you suggest, to the 3+ games though.

Which official rules are you looking at to have the most experienced player start first? The rules say that the person who was on a train most recently should start first...


From the first page of the rules I have, under The Game Turn heading, first sentence: "The player who is the most experienced traveler goes first."

I interpreted "traveler" in the sense of "who's played the game most" ... but in light of your comment, I agree that they may mean it in the RL, traveled the world sense.

Anybody else have thoughts on that? In essence what it would be then is a cop-out on DoW's part that they have no idea if play order impacts game result, so toss it to the wind. The downside with "most experienced traveler" RL status is that this person will not likely change over many games played with the same group ...
      
rasmussen81
DoW Content Provider
Designer's Oath

Fan-Seite
Nachrichten: 7095
Registriert:
July 2007
Re:Scoring and Long-term stats opensource sheet / template Mon, 23 June 2014 18:10
This term is talking about actual traveling...in the real world. If you look at the TTR: Europe rules, it spells it out more clearly and says,

"The player who has visited the most European countries in his lifetime begins the game, and play then proceeds clockwise."
      
Sysyphus - Pommard
Senior Member
T2R All Around Tournament 2011 Winner

Fan-Seite
Nachrichten: 2323
Registriert:
December 2007
Re:Scoring and Long-term stats opensource sheet / template Mon, 23 June 2014 18:43
Quote:

In essence what it would be then is a cop-out on DoW's part that they have no idea if play order impacts game result, so toss it to the wind.

Well, start does not matter in a family game because you mostly play for fun = 99% of the games played irl.

Your sheet has more value if you have a look at the competitive games online : you'll find patterns faster with good players.
      
rasmussen81
DoW Content Provider
Designer's Oath

Fan-Seite
Nachrichten: 7095
Registriert:
July 2007
Re:Scoring and Long-term stats opensource sheet / template Mon, 23 June 2014 18:54
Sysyphus - Pommard wrote on Mon, 23 June 2014 09:43

Quote:

In essence what it would be then is a cop-out on DoW's part that they have no idea if play order impacts game result, so toss it to the wind.

Well, start does not matter in a family game because you mostly play for fun = 99% of the games played irl.

Your sheet has more value if you have a look at the competitive games online : you'll find patterns faster with good players.


I would agree. It wasn't a 'cop-out' as much as a fun way to start a family game.

You can find the online game community over on this forum: http://www.daysofwonder.com/en/thread/?frm_id=78

And you can find the Competitive Play forums over here: http://www.daysofwonder.com/en/thread/?frm_id=45

Good luck and have fun!
      
mkastler
Junior Member

Nachrichten: 7
Registriert:
April 2014
Re:Scoring and Long-term stats opensource sheet / template Tue, 24 June 2014 03:14
Many thanks rass and sys! I will check the other forums out ... I really appreciate the convo on game rules and etc.

Let me know if you use the sheet or have other ideas, and good gaming to you!
      
    
Vorheriges Thema:Marklin, Switzerland and new to be announced map pack.
Nächstes Thema:Avatar change
Gehen Sie zum Forum: