The Hotness
Games|People|Company
Princes of the Dragon Throne
Total War
Mage Knight: Board Game
Infiltration
Winter Tales
Eclipse
Empires of the Void
The Lord of the Rings: Nazgul
Dominion
Lords of Waterdeep
Doctor Who: The Card Game
Ground Floor
Mice and Mystics
Descent: Journeys in the Dark (Second Edition)
Virgin Queen
A Game of Thrones: The Board Game (Second Edition)
Android: Netrunner
Twilight Struggle
King of Tokyo
Glory to Rome
The Lord of the Rings: The Card Game
Dominion: Dark Ages
Agricola
Agricola: All Creatures Big and Small
Hegemonic
Snowdonia
Conquest Tactics
Munchkin
7 Wonders
Pirate Dice: Voyage on the Rolling Seas
7 Wonders: Cities
Arkham Horror
Through the Ages: A Story of Civilization
7 Wonders: Catan Island
Village
1989: Dawn of Freedom
Among the Stars
Race for the Galaxy
The Castles of Burgundy
Libertalia
Dominant Species
War of the Ring
Last Night on Earth: Timber Peak
Ora et Labora
King of Tokyo: Heidelbärger Brockenbär Promo Character
Star Wars: X-Wing Miniatures Game
Space Pirates
City of Horror
Kingdom Builder
Goa
File Info Subscribe sub options | File Rolls
Board Game:
Title:
Language:
English
Uploaded By:
Curt Carpenter
United States

Washington
flag msg tools
Avatar
mbmbmbmbmb
License: © All rights reserved
Tags:
Your Tags: Add tags
Popular Tags: [View All]
Recommendations:
Recommend
12 
 Thumb up
0.26
 tip
Files
Mar 26, 2009
grands.xlsx (171 KB) (Log in or Register to download.)
What can we learn from 9 million real hands of Tichu? It turns out quite a lot. This file provides a pivot table which gives a view into 800 combinations of starting 8 cards and tells you how often people call grand with each combination, and how often they succeed. Discussed here: http://www.boardgamegeek.com/article/3213030. Please keep the discussion there.

But I should mention, as a quick instruction guide, that to use the pivot table, you simply click the plus/minus buttons to construct the starting hand you're interested in. You can drill down as little or as much as you want. If you don't drill down all the way to specify every field in the pivot, the fields not specified are simply rolled up (still independent). You can also reorder or take fields out of the pivot (or add dog or mahjong back in the pivot, since it's out by default after I realized it makes very little difference). The order of the fields is the order the boxes were checked on the right. So, for example, you can uncheck all the boxes (except the bottom 4, see below), and re-add the fields you care about, in the order you care about.

An important note: NEVER uncheck any of the four last fields. They (and their order) are required to make the Win% and Call% columns work. If you ever accidentally uncheck any of those, simply close (without saving) and reopen..

History:
1.1: Added 2 new fields. 1: Number of queens. 2: Whether partner passed their highest card. Both are off by default. See above for how to add.
Downloads:363
Mar 6, 2009
grands.xlsx (75 KB) (Log in or Register to download.)
What can we learn from 9 million real hands of Tichu? It turns out quite a lot. This file provides a pivot table which gives a view into 800 combinations of starting 8 cards and tells you how often people call grand with each combination, and how often they succeed. Discussed here: http://www.boardgamegeek.com/article/3213030. Please keep the discussion there.

But I should mention, as a quick instruction guide, that to use the pivot table, you simply click the plus/minus buttons to construct the starting hand you're interested in. You can drill down as little or as much as you want. If you don't drill down all the way to specify every field in the pivot, the fields not specified are simply rolled up (still independent). You can also reorder or take fields out of the pivot (or add dog or mahjong back in the pivot, since it's out by default after I realized it makes very little difference). The order of the fields is the order the boxes were checked on the right. So, for example, you can uncheck all the boxes (except the bottom 4, see below), and re-add the fields you care about, in the order you care about.

An important note: NEVER uncheck any of the four last fields. They (and their order) are required to make the Win% and Call% columns work. If you ever accidentally uncheck any of those, simply close (without saving) and reopen..
Downloads:91
Post Comment
Front Page | Welcome | Contact | Privacy Policy | Terms of Service | Advertise | Support BGG | Feeds RSS
Geekdo, BoardGameGeek, the Geekdo logo, and the BoardGameGeek logo are trademarks of BoardGameGeek, LLC.