Excel Profit sheet

So I made this when I was bored figuring out how much I could make in a year when I start playing poker seriously in May. I will upload it to a fileshare website or whatever in the morning, thought some of you might be interested in this.

Its for Pokerstars and assumes you are a supernova, obv.
I think the vpp per hand for 100 nl is .39, 200 nl is .57, 400 nl is .605, dunno 600 nl but assume its like .62 i have no clue tho.

The adjustable stats are: Hands per week, vpp per hand, ptbb, and stakes




EDIT:Fixed everything

Download link: http://rapidshare.com/files/165805079/pokerincome.xls.html

New Download link: http://www.megaupload.com/?d=IZY44807

sigh.. i have to wait til the morning?!

*eagerly awaits download link*

nice thank you.

http://rapidshare.com/files/165805079/pokerincome.xls.html

ty sir

This is wrong Rob, you are assuming we get all the VIP and milestone bonuses while it should be based on the # of hands a week we play

How much tables do you play? Isnt 4 tables about 300 hands per hour?. That would mean you want to play 100 Hours a week?

On November 20 2008 13:50 ytricky wrote: How much tables do you play? Isnt 4 tables about 300 hands per hour?. That would mean you want to play 100 Hours a week?

he plays more than 4 tables

what? are you sure? Its not based on the hands a week alone, its based on the vpp per hand, too. Take a close look at all the cell references, i'm pretty sure that the fpp per year, yearly income from playing, vpp per year are all correct. The mile stone bonus thing miiight not be totally correct because i forgot that they subtract 50k fpp automatically from you when you get it.

I dont get what you mean baal when u say its wrong because i am "assuming we get all the VIP and milestone bonuses while it should be based on the # of hands a week we play".

I did base it on hands per week, but on vpp per hand as well, you have to manually enter the vpp per hand you get at your stake, as well as "600" in stake and "5" or something like that for ptbb for your total estimate.

Hands per week
1


Total Yearly Income
$38,007.92



you see the flaw? you are just adding all the milestone bonuses to supernova elite, when if we play 1 hand a week we would get NO bonuses

shit, you're right, dang it i cant figure out this IF function, i will try to fix it. But I mean you can still eyeball it and it will tell you your "income from playing" and then you can just manually add Total bonuses under "yearly" and then manually add the milestone bonuses based on cell G2's value of yearly vpp's

Rob did you take a bunch of time off from the game or something?

ya i did, tryin to get 4.0 this semester and dont wanna be overloaded.

Anyway thanks for pointing that out baal, i finally hopefully fixed it all up. here is the new link and its also edited into the original post.

http://rapidshare.com/files/165805079/pokerincome.xls.html

ill post it in www.tlpoker.la i hope u dont mind

ya put it wherever its cool

can you reupload it please, download limit exceeded

yeah its exceeded, if you send it to me i'll happily host it

New download link http://www.megaupload.com/?d=IZY44807

http://www.ruination.org.uk/fenner/pokerincome.xls

i put it up here so there is no wait, hope you don't mind