Poker Tournament Formula Spreadsheet

1. Poker Tournament Formula Spreadsheet Examples
2. Poker Tournament Formula Spreadsheet
3. Poker Tournament Formula Spreadsheet Excel
4. Poker Tournament Formula Spreadsheet Calculator

I’ve added some test values that are kind of arbitrary, but I’ve also highlighted the formula used for the EV equation in the image so that you can check it against your own results. If you don’t know how to do this, or if you’re completely lost, then go back through the EV Calculations series and the Studying Poker With Spreadsheets. Nothing is easier, quicker, and more useful that to program a spreadsheet to your own standards. Just like in Poker, the tough part is to get the math right. I am looking for the formulas that will allow me to turn a spreadsheet into an equity and pot odds calculator. Each poker deck has fifty-two cards, each designated by one of four suits (clubs, diamonds, hearts and spades) and one of thirteen ranks (the numbers two through ten, Jack, Queen, King, and Ace). Therefore, the odds of getting any Ace as your first card are 1 in 13 (7.7%), while the odds of getting any spade as your first card are 1 in 4 (25%). The last step is to divide your profit or loss by your total hours to get an hourly rate. Once again we put in an equal sign to indicate a formula, then enter the very simple A2/A4 and hit return. Since this formula is calculating two other formulas that have no data yet, it will show an odd message.

Poker Tournament Strategy: The Differences between Harrington on Hold'em and Snyder's Poker Tournament Formula

A Difference in the Primary Focus of the Strategies

A number of players and commentators seem confused about the differences between the poker tournament strategy presented in Harrington on Hold 'em, and the poker tournament strategy presented by Arnold Snyder in The Poker Tournament Formula

Specifically, commentators like Mason Malmuth of 2+2 Publishing and Steve Zolotow of Card Player have been confused by one particular superficial similarity between the strategies—the fact that both strategies advocate looser starting hand requirements as your chip stack grows smaller. Because of this superficial similarity, Malmuth and Zolotow have called Snyder's strategy a weak imitation of Harrington's. Nothing could be further from the truth.

Actually, the specific starting hand requirements advocated by Harrington and Snyder are vastly different, and so is the criterion by which they judge the adequacy of stack size and determine how much to loosen up. But these are not the most important differences between the two strategies. Arnold Snyder is writing a separate article that will address the differences in starting hand requirements and the significance of these differences. In this article, I will address the deeper, fundamental differences between the Snyder and Harrington strategies.

Harrington's strategy is a conservative, or tight, strategy. The decision to play is almost always initiated by the cards you receive: You wait for the best hand you are likely to receive, mathematically, within a given amount of time. Harrington advocates bluffing, including blind steals, only once every hour and a half. With such infrequent bluffing in the Harrington strategy, poker skill comes into play chiefly in how you play your cards.
Snyder emphasizes the importance of tournament factors other than cards in making decisions both on whether to enter pots and how to play hands. In fact, Snyder specifically states in The Poker Tournament Formula that cards are the least important weapon at your disposal in poker tournaments, no matter how well you play those cards.

In The Poker Tournament Formula, Snyder emphasizes the importance of chips and position over cards in a winning poker tournament strategy. Chips and position are the keys to player manipulation, and the whole Poker Tournament Formula strategy is built around player psychology and player manipulation for the purpose of much more frequent bluffs.
To oversimplify a key difference, the Harrington strategy is focused on cards, while the Snyder strategy is focused on theft.

Current M versus Tournament Structure

And there are other important disagreements between the Harrington and Snyder strategies that sharpen the light on this difference in focus. For example, Harrington emphasizes current M (the size of your stack relative to the costs of a round) in making tournament hand selection decisions. He doesn't consider overall structure (future M, or acceleration of M) except when you're within a few minutes of entering the next blind level.
Snyder emphasizes the importance of overall tournament structure, rather than current stack relative to the costs of a round, in determining whether to enter a pot and how to play any hand. Basically, Snyder's idea is that by the time you're forced to play according to M, you're in bad shape in a tournament.

In focusing on M, Harrington is focused on survival, on giving himself the best possible chance of hitting 'good cards.' He is focused on calculating the cost of a round because he wants to know how long he can go without playing a hand before he gets short or blinded-off. When you are not short in chips, Harrington advocates patience.

Snyder, who thinks cards are the least important weapon in a tournament, is focused on chips and the psychological and strategic power of a big stack. He advocates emphasizing earning with skills related to chips and position long before tournament structure starts to limit opportunities to earn with skill. For more information on the importance of a chip lead in Snyder's strategy, see Snyder's article Reverse Chip Value Theory: Good Math, Bad Logic (A Reply to David Sklansky), particularly the article's discussion of 'Chip Utility Value.'
One of the chief disadvantages of the Harrington style is that you get short more often, which means a Harrington player will be forced into low-skill all-in confrontations too often in tournaments. Some players seem to believe that the style advocated by Snyder will get you busted out early more often, and that's true to an extent, but these players greatly overstate both the frequency of this occurrence and the frequency with which Harrington's waiting style will pay off.
Harrington understands, and specifically states (in Harrington on Hold 'em II) the value of maintaining enough chips to play a poker hand after the flop. Again, he is focused on cards, and on playing his cards with skill. While Harrington does briefly address the importance of average stack size, he does very little with it in determining overall tournament strategy.

All decisions about what cards to play are based on your current stack relative to the costs of a round (or the costs of a round in the next 15 minutes), and decisions about how to play those hands are based primarily on your current M and the M of opponents, with only a glance at current average stack size, and no consideration of tournament structure.
Snyder understands the value of chips in playing a hand with skill (again, see Snyder's chip utility discussion), but his book focuses on the more overarching value of a chip lead in terms of overall tournament strategy. To Snyder, a chip lead both maximizes your gains from manipulating your opponents, and sets a player up for the luck portion of a tournament.

Unlike Harrington, Snyder looks at the overall structure of a tournament to determine when the luck portion of a tournament will start and how many chips a player needs to have earned by that point. Snyder correctly points out that the tournament effectively ends at that point, which may be hours before the final table, and that being short at this point is the mathematical equivalent of losing.

The Most Important Difference: Why Snyder's Poker Tournament Strategy Inevitably Beats Harrington's Over the Long Run

In closing, it is a fact of professional gambling that those who can get their money in action with an edge more frequently will earn more than those whose strategies identify profitable betting opportunities less frequently.

And the biggest difference between Snyder's Poker Tournament Formula strategy and Harrington's strategy is that Snyder's strategy will identify profitable betting opportunities more frequently than Harrington's strategy will. Therefore, Snyder's strategy is superior to Harrington's. Let me say that again, to make it absolutely plain: You will make more money in tournaments with Snyder's strategy than you will with Harrington's strategy.

It should be noted that the basic strategy presented in The Poker Tournament Formula is geared for tournaments of a particular speed (meaning a specific blind structure relative to starting chips). Specifically, Snyder's basic strategy and specific hand-play recommendations were designed for tournaments of a speed he calls Skill Level 3.

Snyder is the first author to present an easy method of identifying which fast tournaments offer significant advantages for skillful players, and which don't. Authors like Steve Zolotow claim that fast tournaments are unbeatable, and I have no doubt whatsoever that Zolotow has not been able to beat them, but it's not because fast tournaments are truly unbeatable. Players like Zolotow lose at fast tournaments partly because they are failing to identify which fast tournaments can be beaten, and partly because they are using the wrong strategies for the tournaments, out of the mistaken belief that tournament structure doesn't matter.

In any case, since tournament structure is crucial to optimal poker tournament strategy, Snyder's specific 'basic strategy' (hand-playing tactics and other details) for Skill Level 3 tournaments will have to be adjusted by players for tournaments of different speeds. But the underlying principles of the strategy in The Poker Tournament Formula, with starting hand selections and hand-playing tactics adjusted for tournament structure, will beat Harrington's strategies in any tournament, fast or slow. ♠

[Note: Again, there are numerous other specific differences between the Harrington and Snyder strategies that are important enough that Arnold Snyder will be discussing them in a separate article.

Return to the Blackjack Forum Professional Gambling Library
Return to Blackjack Forum Online Home.

Tournaments are an appealing way to play poker for a number
of reasons. For starters, they can be a lot of fun and provide
players with an opportunity to win large sums of money relative
to the amount risked. The rules for tournament play are also
usually relatively simple, so you can easily take part in them
even if you’re not an expert player.

However, tournament poker is somewhat complicated by the fact
that there are so many different formats and structures that can
be used. None of these are particularly complex individually,
but it can take more time to understand all of the different
types of tournaments and how they work.

In this article we attempt to make the various aspects of
tournament poker as clear as we possibly can. We look at the
main ways in which tournaments can be classified, along with the
basic formats that are part of those classifications. We also
provide details on some other specific types of tournaments and
explain blind structures and payout structures.

Tournament Classifications & Basic Formats

There are a few ways to classify the basic formats of poker
tournaments, with each classification relating to a particular
aspect of a tournament. For example, a tournament can either be
played in a single table format or multi-table format. This
particular classification relates to the number of tables in
play.

The following are all the main classifications and the aspect
of a tournament they relate to.

The way the tournament starts.

The speed that the blind increases by.

Whether players can buy additional chips.

The number of players per table.

Please note that a tournament will generally fit into one
format from each of the above classifications. This might all
seem a little complicated but it should be fairly clear once you
fully understand all of the different formats. We’ll now explain
each of the main classifications in detail, and take a deeper
look at how each individual format works.

Single Table/Multi Table

The distinction between a single table tournament (STT) and a
multi table tournament (MTT) is as obvious as the names suggest.
An STT is played on just one table, while an MTT is played
across two or more tables.

STTs are the simpler of the two formats, as all the entrants
are seated at one table and play basically continues
uninterrupted until the winner is determined. Because MTTs take
place over more than one table, and possibly hundreds of tables
for particularly large tournaments, it becomes more complicated.

As and when players are eliminated during an MTT, other
players may have to move tables to ensure that the number of
players at each table is as close to equal as possible. As a
tournament progresses, the total number of tables in play is
reduced until the last few players are all sitting at just one
table. This is known as the “final table” and it’s where the
tournament is then played out until its conclusion.

Sit & Go/Scheduled

The difference between sit and go tournaments (SNGs) and
scheduled tournaments is equally simple. An SNG has no fixed
start time, but rather starts as soon as the required number of
players has entered. The majority of SNGs take place over a
single table, although small MTT SNGs are fairly common too.

A scheduled tournament does have a fixed start time.
Tournaments of this type have a registration period during which
players can enter and then they’ll start at the pre-arranged
time. They’ll typically run regardless of how many players enter
but some tournaments do require a minimum number of entrants in
order to go ahead. Some have a maximum number of entrants
allowed too.

Regular/Turbo

The terms regular and turbo refer to the overall speed of a
tournament. They are basically a way of describing which blind
structure is being used. We’ll explain more about blind
structures later, but in very simple terms, they relate to the
speed and rate at which the blinds increase through the
different levels. During a regular tournament, they’ll increase
relatively slowly, whereas in a turbo tournament they increase
more quickly.

There are also super turbo or hyper tournaments. These are
typically only available online and the blinds go up at a very
fast rate to make them even quicker than standard turbos.

Freezeout/Rebuy

The term freezeout applies to any tournament where players
are eliminated as soon as they lose all of their chips. Most
tournaments fall into this category, but there are some rebuy
tournaments that allow players to buy more chips when they have
lost their starting stack.

Poker Tournament Formula Spreadsheet Examples

Typically a player will have to pay an additional amount of
money equal to the original entry fee in order to rebuy. They’ll
then receive additional chips, usually the same amount they
started with. All the additional money spent by players on
rebuying goes into the prize pool. Rebuying is only allowed for
a fixed period of time (this varies from one tournament to the
next), but the number of rebuys allowed by each player is
usually unlimited. Once the rebuy period comes to an end, the
tournament effectively reverts to a freezeout.

Full Ring/Shorthanded/Heads Up

Just like cash games, tournaments can be classified based on
the number of players allowed on each table. A full ring game
allows for the maximum, which can be nine or ten, while a heads
up game is limited to just two players per table. A shorthanded
game typically allows up to six players per table.

Specific Types of Tournament

In addition to the main formats and classifications that
we’ve discussed above, there are a few other specific types of
tournaments that you should be aware of. We’ve explained each
one of these below.

Guarantee

A guarantee tournament means that the prize pool is
guaranteed to be at least a certain amount, regardless of how
many players enter. Poker rooms, casinos, and poker sites add
guarantees to tournaments in order to make them more attractive
to players. The idea is that by doing so they should get enough
entrants to cover the guarantee anyway.

If the entrance fees don’t cover the guarantee, then the
organizers of the tournament have to make up the difference from
their own funds. Any amount that they have to add to the prize
pool is known as an overlay.

• Multi table freeze-out tournament.
• $50 + $5 entry fee.
• $10,000 Guarantee.

• If 200 or more players enter, the guarantee is covered.
• If less than 200 players enter, there’s an overlay.

Shootout

A shootout is a type of multi table tournament. In most MTTs
the tables are balanced as and when players are eliminated, but
shootouts work differently. They consist of two or more
“rounds”, where all players stay at their designated table until
there’s just one player remaining. This marks the end of the
round, the tables are rebalanced at that point, and another
round begins. Eventually all the remaining players end up at one
table and then the tournament is played to a conclusion.

Poker Tournament Formula Spreadsheet

• 100 players enter.
• Ten tables are used, with ten players on each.
• Each table is played down to one player.
• The ten players who “won” their table are then moved.
• Ten players make up a final table, which is played as normal.

Satellite

A satellite tournament is one where players are competing to
win entry into another tournament that has a higher value entry
fee. The prize pool doesn’t consist of cash, but instead is
effectively made up of one or more entries to the relevant
tournament. In some satellites, however, there may be some cash
awarded to players who just miss out on the main prize.

If satellite tournaments have more than one tournament entry
up for grabs, then they generally won’t be played until just one
player is remaining. For example, if there are three entries in
the prize pool, then the tournament will finish when there are
three players remaining. Each of those three players will win an
entry to the relevant tournament.

Poker Tournament Formula Spreadsheet Excel

• Satellite to a $100 + 10 buy in tournament.
• $10 + $ 1 entry fee.
• 38 players enter.
• Total prize pool is $380.
• Top three players each win a tournament entry.
• Fourth place wins remaining cash ($50).

Poker Tournament Formula Spreadsheet Calculator

Bounty/Knockout

Bounty, or knockout, tournaments are ones where a percentage
of the prize pool is allocated towards paying players a prize
for eliminating other players. These tournaments award prizes
for every player that’s eliminated, while others only award
prizes for knocking out specific players such as resident pros.

• $10 + $1 entry fee.
• 75% of the prize pool is distributed to the highest finishers.
• 25% of the prize pool is for bounties.
• All players have a bounty on their head.
• Players are awarded $2.50 for every player they eliminate.

Blind Structures

We referred to blind structures earlier and these are an
important part of any poker tournament. The blind structure,
which can also be referred to simply as the tournament
structure, stipulates the blind levels used and the length of
time that each blind level lasts. It’ll also stipulate how many
chips each player starts with.

These things have a big impact on how long a tournament will
last, and they also affect the strategy involved to some extent.
A structure where the blind levels increase steeply and quickly,
for example, will take less time than where the levels increase
more gently and at a slower rate. With the former, a good
strategy would be to act aggressively and try to win chips
early, whereas with the latter, a good strategy would be to be
act patiently and wait for good opportunities.

The following illustrates a typical structure that could be
used for a single table sit and go tournament.

Sample Structure

• Starting Stacks: 1,500 Chips
• Time Per Level: 10 Minutes

The following structure illustrates a typical structure that
could be used for a larger multi table tournament. There would
be more levels than we’ve shown here but this gives you a better
idea of how they progress.

Sample Structure

• Starting Stacks: 1,500 Chips
• Time Per Level: 10 Minutes

The payout structure of a tournament is also very important,
as it determines how many players win money and how much money
each player wins. Technically a payout structure can be whatever
the tournament host wants it to be, but there are some general
rules that they tend to follow.

A payout structure is usually based primarily on the number
of total entrants. A large tournament with lots of entrants will
pay out more to players than a small tournament will. You’ll
typically see just two or three players getting paid in an STT
for example, while a big MTT could see a hundred or more players
getting paid.

The exact size of each prize is then based on a percentage of
the prize pool. In a small tournament this will be something
simple like 50% to the winner, 30% to second place and 20% to
third place. It gets a little more complicated in larger
tournaments with more people to pay but the basic principle is
the same. First place gets the biggest percentage; the
percentages get smaller the earlier in the game the players
finish.

Here are a couple of sample payout structures to give you an
idea of what they can look like.