Calculating minimum call $
10-25-2015
, 03:07 AM
10-25-2015
, 04:19 AM
Quote:
I have an excel spreadsheet with formulas to tell me the EV of a given hand, that's straight forward.
(Win %, win amount($), Lose %, lose amount($) and then it spits out the EV)
What I want to do now is create one where I input everything except the Lose amount($) so for instance I'd put in:
(0.42 x $1.00) + (0.58 x ____) = 1
Where 1 is the minimum EV I would want. Then the formula would tell me the blank (aka the max amount I should call in this situation).
I basically want the calculator to spit out the minimum calling amount (that I can then convert to a percentage of the pot) where the EV would be at least 1.
I can't do basic maths obviously!
(Win %, win amount($), Lose %, lose amount($) and then it spits out the EV)
What I want to do now is create one where I input everything except the Lose amount($) so for instance I'd put in:
(0.42 x $1.00) + (0.58 x ____) = 1
Where 1 is the minimum EV I would want. Then the formula would tell me the blank (aka the max amount I should call in this situation).
I basically want the calculator to spit out the minimum calling amount (that I can then convert to a percentage of the pot) where the EV would be at least 1.
I can't do basic maths obviously!
I'm going to rename "lose amount" as "lamo" and "minimum EV" "me." So from (0.42 * $1.00) + (0.58 * me) = lamo we can derive:
me = (lamo - 1.00)/0.58 + 1.00As you can see, I have me as a linear function of lamo
10-25-2015
, 05:05 AM
That's great but I need lamo on the left of the equation 
(I need to figure out what lamo will be)
So I can go to the lamo cell in excel and make it "=(blah blah blah*blah blah blah)+1 " etc
(I need to figure out what lamo will be)
So I can go to the lamo cell in excel and make it "=(blah blah blah*blah blah blah)+1 " etc
10-25-2015
, 06:19 AM
"...from (0.42 * $1.00) + (0.58 * lamo) = me we can derive:
lamo = (me - 1.00)/0.58 + 1.00"
10-25-2015
, 06:27 AM
10-26-2015
, 07:19 PM