Thank you for this brilliant lecture Vandweller.
Thanks for your kind words.
nice! looking forward to push videos
Thanks. I actually prefer making these blackboard-style videos, but I gots to give the people what they want. So live play it is.
nice vid watched and made the spreadsheet, glad to know your SnG's skillz > Excel skillz Wink haha but seriously good vid just beginning to donk around with sngs as a break from cash. I got SNG wiz etc, but like learnt a lot more in this vid than playin' around with that thing for a few days. waitin on ya next vid, keep up the good work, peace.
Doing this kind of stuff is certainly going to help you more than just screwing around with SNGWiz. The spreadsheet engages your mind by making you consider the inputs and the calculations, while SNGWiz spoon-feeds it to you. SNGWiz is a great tool, obviously, but over-reliance on it can stunt your growth as a SNG thinker.
Make sure and watch my first vid if you haven't already.
Hey, im trying to learn MTTs, can i use this ICM for those? or will this only work for SNGs?
This particular spreadsheet won't cover MTTs, because there are too many payouts and players for me to have the knowledge, time, and patience to add, from a programming/Excel perspective. The basic method however of calculating your tournament equity is exactly the same whether it's 3 or 3000 entrants, it's just longer.
In larger-field MTTs though, especially early, your starting equity is so low relative to the final attainable equity, that the hand-value skewing effects of the payout structure are largely irrelevant from a practical perspective, until you get fairly close to the bubble. And even then, depending on the how flat the payouts are it might not change very much besides.
We'll have some content about MTT and SNG payouts, in some form, in the relative near future. So be on the lookout.
Very nice Vid.
I already used your spreadsheet in practice and it turned out to be very helpful because using pokerstove u can assign more accurate Hand Ranges than e.g. in SNG Wiz.
But there is one thing i got a little confused about. I wanted to calculate a shove SB vs BB. When i set up stacks for equity "now" i have to substract the SB from my Stack and add it to BBs Stack, is that right? Because in Minute 81, it seems you do calculate a SB vs BB shove, but dont substract the 100 Chips from SBs Stack.
There is actually somewhat of a hot-button issue for me, and actually quite interesting. The SNG orthodoxy, I am to understand, considers primarily your equity before posting the blinds in risk/reward analysis. I wanted to give what is more or less the standard presentation, because my view, I am continually suprised to understand, is controversial.
I believe that your equity should be calculated on the basis of decision points. And your decisions come at the point of having already posted the blinds and antes, and the risk and reward scenarios similarly should account for what your equity will be on the next hand after the blinds and antes are posted.
A question then arises, do the blinds in the middle have an equity value? If they don't, then all players equities should total 100%. If they do have a value, then that means the total equities of the players would total slightly less than 100%. I tend to favor the latter viewpoint, for the simple reason that if we assume players equities will total 100%, that means the blinds have no equity value...but if they don't, why are we fighting over them and why do they add value to our equity when we win them?
These are all really more technical/philosophic issues which are outside the scope of this video, but I do intend to cover them in future content. But to answer your question, I personally use equity values *after* posting, but don't be surprised when you run into people who believe otherwise.
Thanks for your comments and questions, guys. I truly believe this video has potential to be the least-watched video in DC history. And I am ok with that. 95 minutes on a spreadsheet for SNGs...what was I thinking?