My calcs are for a six deck game, play all approach with a 1-8 spread. I've used one of Mr Snyder's tables from Blackbelt in Blackjack (%ages of hands at a given favourable and house edge) as the basis for them. The spreadsheet's nothing fancy, and calcs the wins/losses at each count/edge, based on an entered spread, and tallys the lot up to give a bottom line expected win/loss for "x" number of hands played. It doesn't take into account the effect of pushes (7% of all hands played across all counts? - I might build that in a bit later), and the Std Dev calc is one that is programmed into Excel for calculating it on a single figure (STDEVPA)
So it certainly isn't pin-point accurate, but I'm not sure it needs to be at my level of play. My results do fall into line with what others post and they do provide an instant indication of what is the maximum expected loss for any given amount of play - handy for knowing how much I need to take to the House of Chance so as not to blow out.
If I was playing several times a week with a decent amount behind me I would want something more robust and would invest in a decent sim program. But for the time being Excel, combined with an understanding of the underlying numbers gleaned over the last 8 months or so, suffices.
Newb99
