View Full Version : I don't get Stats- Homer's Streaks Spreadsheet - Xpost

08-29-2005, 03:02 PM
Is this really possible?

I’ve played around a lot with Homer’s Streak spreadsheet.

Those of you not familiar with the spreadsheet, it’s designed to show how streaky your play can be. At the same time, it shows the effect of the “long run” and despite any short term streak, if you are a proven winner, you will have a positive trend line over the “long run”.

It uses a combination of win rate and Standard Deviation to come up with potential results.

More on the design, and spreadsheet can be found here:

http://archiveserver.twoplustwo.com/showflat.php?Cat=&Board=&Number=445039&page=&view= &sb=5&o=&fpart=1

I’ve created a few additional charts to extrapolate what 4 tabling, 2-4, 5 hours a day, 20 days a month, for a year. What I would consider Semi Pro, Pro Hours in a year.

I have “Streaks” graphs representing:

1hr session, 4 tables = 4 Table Hours (Representing a possible hour in a 5 hour session – relevance = Extremely Low/Irrelevant

5 hr session, 4 tables = 20 Hours (Representing one full day/full session – relevance = Very Low

5 Days, @ 5 hr sessions, @ 4 tables = 100 Table Hours (Representing one week – relevance = Low
20 Days @ 5 hr Sessions @ 4 tables = 400 Table Hours (Representing one month play – relevance = somewhat relevant

12 Months @ 5 hr Sessions @ 4 tables = 4800 table hours (Representing one year of play – relevance = very relevant

So anyway my ultimate question is, how reliable of a tool is this.

By SD is 15 BB HR.
My WR is 2.0/BB per HR
BB = 4.00
(These figures can be gathered out of PT)

I recalculated the spreadsheet 100 times (representing 100 different poker years)

Lowest Year: $28,745
Highest Year: $50,489

Average Year: $38,884

The Avg Year is what I have a question about. The win rate isn’t anything extravagant, and the SD is what I believe “typical” (though I’m not as sure on SD)

However averaging nearly $39,000 a year at $2/$4 seems high to me.

Is the spreadsheet calculations inaccurate?
Are my playing time assumptions wrong?
Could one expect to put in 5 hours a day, 20 days a month, and expect to make $39,000 a year?


08-29-2005, 06:23 PM
4 tabling 5 hours = 20 table hours / day, * 240 days / year = 4800 table hours, if you make 2.00BB/hr, thats 8* $4800/year so $38400, ~39000, that does seem pretty good, but accurate if you can make 2BB/hr.