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??sf?? and selecting "Save target as". Here are the different features of the spreadsheet:
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.
??sf??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).
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??sf?? page to read more about how to set your tournament payouts.
??sf??This sheet allows you to calculate the different starting chip value combinations. Specifically, it does a couple of things:
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.
??sf??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.
HPG ADMIN on March 1, 2013