This is my second Project related to Poker
Maths Genius Required for Excel Poker Math Problem.
Attached you'll find an excel file that works out your ICM in Poker. See SNGWIZ link for further information or Google "ICM POKER" - [url removed, login to view]
Poker Sit and Go's work like this
9 Players pay $100 each for a Prize pool of $900, everyone starts with the same ammount of chips, once you lose those chips you're out. The final 3 players left all make money
1st gets 50% of prize pool for $450
2nd gets 30% of prize pool for $270
3rd gets 20% of prize pool for $180
Everyone else loses $100
Breakdown of Excell Sheet:
The light blue boxes are there to be editted, this is where Id type in my information.
Column A is the Number of Players A, B, C, D etc.. there are 10 in total
Column B is the amount of chips each player has
Column C is the Chance of comming 1st
Column D is the Chance of comming 2nd
Column E is the Chance of comming 3rd
Column F is the Chance of placing out of the money
Column G is the playerss tournament equity %
Column H is the amount of Money each person is currently winning.
As you can see Player A's equity in the tournament is 11.11% TEQ
if you change players B's chips to 0 and Players A's chips to 6000 you'll see the equity change for player A to 18.75% TEQ. This is all correct.
Let's see what happens if we do the same against player C,
1)Now to work out whether it's correct Equity to gamble those 6000 chips we need to goto B23 type in 18.75% under NOW, as that's our current Equity.
2)If we beat player C our chips will be 9000 and Player 0 chips, our equity now is 26.26%, goto C23 and type this in.
3)If we lose against Player C, our chips will go from 6000 to 3000 and his chips from 3000 to 6000, our equity would be 11.13%, type this in under "IF LOSE".
If you now goto F23 you'll see the calculation shows us we need 50.36% Equity in the hand in order to make this risk possible.
All the calculations work however it's still very manual.
Id like to be able to just type in the following options to get the same results
1) My chips now
2) My chips if I win
3) My chips if I lose
4) Total number of players now
As I said before you can do the same calculations using this software [url removed, login to view] it has a free trial, but I want this in excel. Also google Poker ICM ([url removed, login to view])
Please message me if you have any questions.