|
Bet sizing spreadsheet
Gents,
Just been fiddling with excel, and I am going bog-eyed (too many nested brackets). I have created a spreadsheet to look at how pot sizes grow with different sizing on the various streets.
3bet pots and multiway etc. are accomodated. Different starting stacks are correctly handled. It also correctly handles getting all-in. For total profit when they call and you win at showdown, or they fold, there is a column, for how much you lose if it goes to showdown and you lose there's a "total bet" column.
Just change the numbers in the section highlighted yellow, and the main results bit will calculate. There are standard lines (variants like pot-pot-pot, half-half-half etc. etc.) all of them are editable for the sizing, however to make it easier to work on a custom betting line whilst leaving those standard ones alone, there is also another line at the bottom where the sizings are highlighted yellow for editing, they can be entered as decimals or fractions.
http://ge.tt/2bYV0zu/v/0 (This link will be updated if I update the spreadsheet)
There may be egregious errors or bogosity present, I haven't fully tested it yet, so any bug reports and amendments would be great.
Hope some of you find it useful.
|