Home Poker Spreadsheet

This free spreadsheet helps you manage your home game. It has 6 different sheets you can use. You can download it by right-clicking spreadsheet-home-game.xlsx and selecting "Save target as". Here are the different features of the spreadsheet:

Tournament deal calculator

This sheet calculates the mathematics of making a deal at the end of a tournament. The formula used in the spreadsheet is based on the assumption that each player's probability of winning the tournament is based on the percent of the total chips that they hold.

For example, let's assume that there are 2 players left in a tournament, and they each have 25% and 75% of the chips respectively, and the payouts for the final two spots are $1,000 and $3,000. Therefore, both players will win a minimum of $1,000 - and will be competing for the rest of the total money ($2,000). If "Player 1" has 75% of the chips then he has a 75% probability of winning that extra $2,000. Based on this, his expected value on the extra money is $1,500 ($2,000 * 75%). "Player 2", who has 25% of the chips, has an expected value of $500 ($2,000 * 25%) on the extra chips. This means "Player 1" has a expected payout of $2,500 (the sure $1,000 plus the expected $1,500) and "Player 2" has an expected payout of $1,500 (the sure $1,000 and the expected $500).

Screenshot

Tournament payout calculator

This sheet is a tournament payout calculator that calculates the amount paid out to tournament winners (for both rebuy tourneys and non-rebuy tourneys). See my tournament payout structure page to read more about how to set your tournament payouts.

Screenshot

Chip requirements

This sheet allows you to calculate the different starting chip value combinations. Specifically, it does a couple of things:

  1. "Each Player" calculations lets you play around with the chip values to see what combinations can give you the required Total Starting Value for players.
  2. "Total" tells you the total value of chips in the tournament (this applies to non-rebuy tourneys only). It also tells you how many chips of each color you will need to start the tournament.

Screenshot

Cost to host game

This sheet calculates the cost to host a home game. It breaks down expenses into fixed (costs you only need to pay once) and variable (recurring costs). It calculates the long-run total cost of the game, and tells you how much of a fee you need to charge each player if you plan on charging a fee in order to earn your costs back.

Screenshot

Blind schedule

This sheet allows you to create a blind schedule and print it out. Included is a sample Party Poker single-table (SNG) tournament blind schedule.

Screenshot

COMMENTS:

Log in to post comments
or Register

HPG Tools - Spreadsheet

HPG ADMIN on March 1, 2013