dkarius
19 posts
Joined 07/2010
I think part of the reason we didn't see much of change with the stack sizes was because we didn't adjust his bet/calling range on the turn for the stack size. The villain will probably fold more of his range on the turn to the check/raise when stacks are deeper making a slow play higher ev.
Also, you said we should fast play versus a tight range, but is it clearer to say we should fast play versus a strong range. Versus a tight range, we should have a better idea of the correct play but a tight range still could be very weak and unable to call a raise.
Thanks for a series and all your hard work. I got a ton out of it and enjoyed watching it.
Posted almost 2 years ago
Reply to Topic
Reply w/Quote
AlephOne
9 posts
Joined 02/2009
Great series Josh - definitely a powerful tool if you are willing to put the effort into creating the model.
Have you looked at Tools -> Scenarios or Data -> Multiple Operations in Open Office Calc? The former might be just what you need to create the various scenarios you discussed in this episode without having to save and reload the model each time. I am currently investigating the latter to see if I can generalize the way in which each different river card is handled without having to copy great swathes of spreadsheet as you have done.
By the way, my automatic combo calculator did pick up a couple of errors in your hand-calculated combos. Nothing very significant and remarkably few given you doing it all by hand. For what it's worth:
Flop.B36 should be 4 (not 5)
Turn.C53 should be 3 (not 4)
Turn.D53 should be 7 (not 10)
The last of these has copying implications for the River (eg B128, B213 and so on).
Posted almost 2 years ago
Reply to Topic
Reply w/Quote
onehundred47
400 posts
Joined 10/2009
sthief09
2131 posts
Joined 07/2007
Great series Josh - definitely a powerful tool if you are willing to put the effort into creating the model.
Have you looked at Tools -> Scenarios or Data -> Multiple Operations in Open Office Calc? The former might be just what you need to create the various scenarios you discussed in this episode without having to save and reload the model each time. I am currently investigating the latter to see if I can generalize the way in which each different river card is handled without having to copy great swathes of spreadsheet as you have done.
By the way, my automatic combo calculator did pick up a couple of errors in your hand-calculated combos. Nothing very significant and remarkably few given you doing it all by hand. For what it's worth:
Flop.B36 should be 4 (not 5)
Turn.C53 should be 3 (not 4)
Turn.D53 should be 7 (not 10)
The last of these has copying implications for the River (eg B128, B213 and so on).
Ahh thanks for pointing that out. I figured I probably made some mistakes there even after double checking. Sooooo many cells.
So how did you create a combo counter? It's something I tried to count awhile back but just couldn't figure out how it could be done without breaking up the hands.
Posted almost 2 years ago
Reply to Topic
Reply w/Quote
sthief09
2131 posts
Joined 07/2007
sthief09
2131 posts
Joined 07/2007
I think part of the reason we didn't see much of change with the stack sizes was because we didn't adjust his bet/calling range on the turn for the stack size. The villain will probably fold more of his range on the turn to the check/raise when stacks are deeper making a slow play higher ev.
Also, you said we should fast play versus a tight range, but is it clearer to say we should fast play versus a strong range. Versus a tight range, we should have a better idea of the correct play but a tight range still could be very weak and unable to call a raise.
Thanks for a series and all your hard work. I got a ton out of it and enjoyed watching it.
I didn't adjust the ranges with the stack sizes? I thought I did it, fairly quickly, but maybe that was off camera?
I see your point in the 2nd paragraph. I thought tight implied strong but it can also be thought of as narrow, as you're saying. It's something I'll keep in mind for my videos going forward. Thanks for pointing that out.
Glad you enjoyed!
Posted almost 2 years ago
Reply to Topic
Reply w/Quote
AlephOne
9 posts
Joined 02/2009
Ahh thanks for pointing that out. I figured I probably made some mistakes there even after double checking. Sooooo many cells.
So how did you create a combo counter? It's something I tried to count awhile back but just couldn't figure out how it could be done without breaking up the hands.
Initially I did it without breaking up the hands and using formulae like (4-COUNTIF(RanksT;$A15))*(4-COUNTIF(RanksT;$B15)) where 'A15' and 'B15' are the ranks of the two cards, but then I wanted to extend the capability to include automatically ranking the hands as "nutted", "strong" etc and to do that it was easier to have tables of all 1,326 possible hands. In so doing the formulae for combos became a lot simpler, reducing to logic rather than arithmetic. I then create the standard Poker shorthand for suited and off-suit cards from the complete table, and use Regular Expressions to represent groups of hands which can then be 'SUMIF'ed over the extended table.
So far I have recreated your JJ scenario up to the flop with everything except the reads on the villain automated. Automating the ranking of hands on the flop is proving an interesting exercise from which I am learning a fair bit. It (obviously) gets more complicated on draw-heavy boards, but I am optimistic that I can create a harness that will allow me to analyze any hand at least as far as the Turn by inputting nothing more than reads on the (single) villain. This will then be a VERY useful tool...
Posted almost 2 years ago
Reply to Topic
Reply w/Quote
mrcleanhands
666 posts
Joined 01/2010
MayContainNuts
318 posts
Joined 03/2010
Just wanted to say how much I feel I have benefited from watching this series.
To be honest I was just expecting basic maths from the WoT series laid out in some easy-to-use spreadsheets.
Infact in a way it relates more to The Haj School. It provides the tools necessary to take possession of learning about poker through the numbers rather than being spoonfed. It's like a science lab where we can test hypothesis.
It has given me a clearer and deeper understanding about a lot of the concepts discussed in other videos and on the forums, so much so I want to watch many of them again.
It has really helped in terms of breaking down ranges, combos, value betting and multi-street play, as well as simplifying more complex stuff like Bayes' and indifference points.
Thanks for all the hard work.
Posted over 1 year ago
Reply to Topic
Reply w/Quote
ralphcifaretto
155 posts
Joined 12/2010
sthief09
2131 posts
Joined 07/2007
Hows the combinatorics video coming on (episode 9)?
I recently had an email exchange with threads13 about this and feel pretty refreshed as to how to calculate these. That was the biggest hurdle for me for creating that video. Also, Propokertools Odds Oracle is a great tool for calculating this yourself.
Posted over 1 year ago
Reply to Topic
Reply w/Quote
baboonbummer
7 posts
Joined 12/2011
Awesome series, thanks for putting in the effort and for making the spreadsheets available. I probably learned more from this series than I have from any other, ever. Or from any book for that matter.
Did you end up figuring out how to make a combo counter? I know AlephOne explained how he made one above but I don't have a clue what he means. 
I think a combo counter is the only thing missing.
Posted about 1 year ago
Reply to Topic
Reply w/Quote
sthief09
2131 posts
Joined 07/2007
Awesome series, thanks for putting in the effort and for making the spreadsheets available. I probably learned more from this series than I have from any other, ever. Or from any book for that matter.
Did you end up figuring out how to make a combo counter? I know AlephOne explained how he made one above but I don't have a clue what he means. 
I think a combo counter is the only thing missing.
thanks! everyone's comments and feedback are what make late nights trudging through spreadsheets and #s worth it.
to answer your question, not quit, but fortunately I discovered ProPokerTools Odds Oracle does it for me.
http://deucescracked.com/forums/4-General-Discussion/topics/478871-So-Fresh-and-So-Clean-Epi?#post_4384191
the above video has a breakdown of how often certain hands hit the flop in different ways. it shows how to use PPT to calculate combos for you. it's easier and leaves us less susceptible to small careless errors.
Posted about 1 year ago
Reply to Topic
Reply w/Quote
baboonbummer
7 posts
Joined 12/2011
The part where I'm having most problems though is when I'm splitting the hands and figuring out their combos relative to the known cards. When doing it with a large range it takes me forever and is usually peppered with errors. Is there a way to do this with PPT? I watched the video but don't quite get how you can deduce that info from a hand's floppability. Am I being really stupid here?
Posted about 1 year ago
Reply to Topic
Reply w/Quote