Excel Maths Genius Needed - Project 2

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.

Evner: Matematik

Se mere: poker icm excel, www excel, www 3000 com, works need excel, win project, we excell, we excel, number mathematics, me excel, make money with excel, find where a person works, Find mathematics, find chips, excel 16, do your math, teq poker icm, modeling in excel, google excell, beat b, modeling information, get math, poker chip, Maths\ , maths project, mathematics problem

Om arbejdsgiveren:
( 11 bedømmelser ) london, United Kingdom

Projekt ID: #976270

Tildelt til:


Friend, us again :) Contact me by PM lets do business, this is on my level :D

$50 USD på 1 dag
(1 bedømmelse)