Jump to content


Poker Spreadsheet


  • Please log in to reply
142 replies to this topic

#1 cwik

cwik

    Bully for you.

  • Members
  • 3,606 posts
  • Gender:Male
  • Location:Monterey, CA

Posted 12 March 2007 - 04:14 PM

----------------------------------------------------------------------------------------------------------------Sorry guys. Not supporting this anymore. No new updates. --- 7/7/2011----------------------------------------------------------------------------------------------------------------Hey guys.Awhile ago I made a simple spreadsheet on excel to help track my tourney stats that I didn't feel PokerTracker was adequate doing. At some point I started looking for a better spread sheet on the internet, and while there are several good ones that you could tell people put a lot of time into, I thought I could still do better (knowing very little about excel). Basically trying to simplify a lot (the original goal was to have everything on one page) and add more of the important part of tracking your play, stats. Over the past few months, I have been slowing updating my original spreadsheet into a total bankroll manager. I am fairly happy with the outcome: something simple, eloquent, and easy to use; which satisfies my purposes. While this whole process took a large amount of time out of my actually poker playing activity (I needed to learn excel from the ground up), I feel like the result has substantially helped my poker play since. That is, having real stats to judge my poker playing preformence has encouraged me to play my best poker. Basically I it has helped me decrease tilt, I consciously try to avoid putting myself in -EV situations, as I hate typing in negative(-) numbers.Because I'm a happy with the result I thought I'd make it public, if anyone is interested in using it (note: I still highly recommend using pokertrack as well, as what it offers is far and beyond the scope of an excel spreadsheet. However this poker spread sheet should help with a large amount of bankroll management tracking and playing stats for both online and live play). Also, this was made in office 2007 to fit my screen 1600x1200 screen. While I did make a version compatible with earlier versions, it may not have transitioned perfectly (for example, there is a much smaller scale of color options on earlier versions, and I do not think it looks as visually as good). Office 2007 version:https://netfiles.uiu...okerSpread.xlsmOffice 97-03 version:https://netfiles.uiu...PokerSpread.xlsI would love to hear some feedback, let me know if I could improve/add a feature, or something does not work. Thanks guys.Edit: Spreadsheet last updated 4/25/2007Some people have expressed the wish to donate for my troubles. They will be gladly accepted! :club: cwik1 on Full Tilt PokerCwik1 on PokerStarsAlso, want to thank BKice for currently hosting this for me as I know longer have access to my old server (check out the www.thepokerhaus.com)

#2 No_Neck

No_Neck

    this is how i roll

  • Members
  • 11,522 posts
  • Location:New Jersey OBV

Posted 12 March 2007 - 04:20 PM

View Postcwik, on Monday, March 12th, 2007, 8:14 PM, said:

Hey guys.Awhile ago I made a simple spreadsheet on excel to help track my tourney stats that I didn't feel PokerTracker was adequate doing. At some point I started looking for a better spread sheet on the internet, and while there are several good ones that you could tell people put a lot of time into, I thought I could still do better (knowing very little about excel). Basically trying to simplify a lot (the original goal was to have everything on one page) and add more of the important part of tracking your play, stats. Over the past few months, I have been slowing updating my original spreadsheet into a total bankroll manager. I am fairly happy with the outcome: something simple, eloquent, and easy to use; which satisfies my purposes. While this whole process took a large amount of time out of my actually poker playing activity (I needed to learn excel from the ground up), I feel like the result has substantially helped my poker play since. That is, having real stats to judge my poker playing preformence has encouraged me to play my best poker. Basically I it has helped me decrease tilt, I consciously try to avoid putting myself in -EV situations, as I hate typing in negative(-) numbers.Because I'm a happy with the result I thought I'd make it public, if anyone is interested in using it (note: I still highly recommend using pokertrack as well, as what it offers is far and beyond the scope of an excel spreadsheet. However this poker spread sheet should help with a large amount of bankroll management tracking and playing stats for both online and live play). Also, this was made in office 2007 to fit my screen 1600x1200 screen. While I did make a version compatible with earlier versions, it may not have transitioned perfectly (for example, there is a much smaller scale of color options on earlier versions, and I do not think it looks as visually as good). Office 2007 version:http://home.csumb.ed...okerSpread.xlsmOffice 97-03 version:http://home.csumb.ed...PokerSpread.xlsI would love to hear some feedback, let me know if I could improve/add a feature, or something does not work. Thanks guys.
holy crap this is easily the most well designed spread sheet I have seen. Well done!!!

#3 Ouch-8s

Ouch-8s

    It's not a flying tour group, Jerome

  • Members
  • 8,919 posts
  • Gender:Male
  • Location:Easter Island

Posted 12 March 2007 - 04:43 PM

Very nice work. I work a lot in excel, and just by looking at this quickly, this looks very good.
I'm retired.

#4 checkymcfold

checkymcfold

    almost back to real stakes.

  • Members
  • 9,114 posts
  • Gender:Male
  • Location:stanley mission, sk
  • Favorite Poker Game:night baseball

Posted 12 March 2007 - 04:57 PM

:club:
QUOTE (Dirtydutch @ Tuesday, December 2nd, 2008, 12:21 AM) <{POST_SNAPBACK}>
If there are two things LHE players like, they are weed and pornography. The third would be kittens. LHE does not appear on the list.





#5 JoeyFinngars

JoeyFinngars

    Poker Forum Veteran

  • Members
  • 1,044 posts
  • Location:Canada
  • Interests:What do you think? Poker of course...
  • Favorite Poker Game:NLHE, RAZZ

Posted 12 March 2007 - 05:12 PM

That is an amazing design...I will now be using this as my poker stat/BR tracker. Thanks!!! :club:
It's hard work. Gambling. Playing poker. Don't let anyone tell you different. Think about what it's like sitting at a poker table with people whose only goal is to cut your throat, take your money, and leave you out back talking to yourself about what went wrong inside.

-- Stu Ungar, Three-time WSOP Champion





#6 pokerinc

pokerinc

    insomniac

  • Members
  • 1,641 posts

Posted 12 March 2007 - 06:10 PM

great design. One thing, shouldn't total bankroll be updated when you plug in cash game results? Yes no? I've just started using this kind of stuff so maybe it updates funds elsewhere.Very cool, it's a keeper.ok, found the total cash profit box, I'm happy.
Now working and pokering. It's like two incomes in one.
UFC July 4th weekend. Vegas!

#7 mikeysong

mikeysong

    Poker Forum Veteran

  • Members
  • 2,033 posts

Posted 12 March 2007 - 06:13 PM

this is pretty intensethere's one thing I'd like for you to add stats wise. A Risk of Ruin calculator so we can see what kind of br we need to avoid going broke :DOh, and a column for rakeback as well.

#8 No_Neck

No_Neck

    this is how i roll

  • Members
  • 11,522 posts
  • Location:New Jersey OBV

Posted 12 March 2007 - 06:14 PM

View Postmikeysong, on Monday, March 12th, 2007, 10:13 PM, said:

Oh, and a column for rakeback as well.
I believe there is...

#9 mikeysong

mikeysong

    Poker Forum Veteran

  • Members
  • 2,033 posts

Posted 12 March 2007 - 07:49 PM

?where do u put in the rake #s

#10 yourboygsarida

yourboygsarida

    special delivery

  • Members
  • 1,940 posts
  • Gender:Male
  • Location:SLO
  • Favorite Poker Game:plo8

Posted 12 March 2007 - 07:57 PM

you have anything that works for open office? seems like it wont work with mine like regular spreadsheets usually do.

#11 MisterB

MisterB

    I still wear big belt buckles.

  • Members
  • 4,266 posts
  • Gender:Male
  • Location:Connect I Cut...formerly. now Misssssssissippi

Posted 12 March 2007 - 08:02 PM

wowwphow long did this take you to make?
QUOTE(JoeyJoJo @ Tuesday, October 2nd, 2007, 7:21 PM) View Post
MisterB - Tired of getting b-bombed? Well now you can return the favor! With MisterB in the calendar, you'll have at least 30 days to practice your technique. A vote for MisterB is a vote for big belt buckles everywhere.

#12 silkyjonson

silkyjonson

    steppin out

  • Members
  • 6,907 posts
  • Location:windsor

Posted 12 March 2007 - 08:03 PM

Cant get it to open. dont really use excel anybody have any suggestions?

#13 joethepro

joethepro

    Poker Forum Nut

  • Members
  • 324 posts
  • Gender:Male
  • Location:toronto

Posted 12 March 2007 - 08:15 PM

this is truly amazing. i'm going to definitely use it with poker tracker. cwik, how can i add another column in the cash table area to add how many poker points i've earned?

View Postsilkyjonson, on Monday, March 12th, 2007, 11:03 PM, said:

Cant get it to open. dont really use excel anybody have any suggestions?
silky, both versions don't work? did you download two?

#14 Actuary

Actuary

    .

  • Members
  • 19,028 posts

Posted 12 March 2007 - 08:20 PM

dork.well done.I say that without checking anything, but you're a good man to go thru the effort and help so many people

#15 silkyjonson

silkyjonson

    steppin out

  • Members
  • 6,907 posts
  • Location:windsor

Posted 12 March 2007 - 08:39 PM

View Postjoethepro, on Monday, March 12th, 2007, 9:15 PM, said:

this is truly amazing. i'm going to definitely use it with poker tracker. cwik, how can i add another column in the cash table area to add how many poker points i've earned?silky, both versions don't work? did you download two?
got it, did'nt even realize that, thanks joe

#16 cwik

cwik

    Bully for you.

  • Members
  • 3,606 posts
  • Gender:Male
  • Location:Monterey, CA

Posted 12 March 2007 - 09:58 PM

View PostNo_Neck, on Monday, March 12th, 2007, 5:20 PM, said:

holy crap this is easily the most well designed spread sheet I have seen. Well done!!!
Hey guys, thanks for the kind feedback.

View Postpokerinc, on Monday, March 12th, 2007, 7:10 PM, said:

great design. One thing, shouldn't total bankroll be updated when you plug in cash game results? Yes no? I've just started using this kind of stuff so maybe it updates funds elsewhere.Very cool, it's a keeper.ok, found the total cash profit box, I'm happy.
yes, it should add your cash results to your total bankroll.

View Postmikeysong, on Monday, March 12th, 2007, 8:49 PM, said:

?where do u put in the rake #s
I just add them in when I am entering the buy-in. I could have made another column or a drop down list with all the possible buy-ins, however remember the idea here was simplicity, and I think it is easiest to just type in a number instead of scrolling through a huge list. (note, usually when entering information I just copy/paste from the line above it.)

View Postyourboygsarida, on Monday, March 12th, 2007, 8:57 PM, said:

you have anything that works for open office? seems like it wont work with mine like regular spreadsheets usually do.
Sorry, can't really help you there. I do not really have any experience with open office so I don't know, however there are many very complicated functions in this and I do not know how compatible they are. Did you try the older office .xls file?

View PostMisterB, on Monday, March 12th, 2007, 9:02 PM, said:

wowwphow long did this take you to make?
lol, a long time. Would been a lot quicker if I knew I was doing. But the whole thing evolved over quite awhile, I thought I was done about six or seven versions ago, but I kept thinking of new things to add to it.Again, this whole thing was all done on office 2007, so I do not know how it all transitioned over to the office 97-03 file. If something does not work like you think it should let me know. A good place to start when using the spreadsheet is reading the notes a posted in the top right.

#17 WowThats

WowThats

    Poker Forum Nut

  • Members
  • 312 posts

Posted 13 March 2007 - 09:00 AM

Great piece of work.... thank you

#18 checkymcfold

checkymcfold

    almost back to real stakes.

  • Members
  • 9,114 posts
  • Gender:Male
  • Location:stanley mission, sk
  • Favorite Poker Game:night baseball

Posted 14 March 2007 - 01:43 AM

this should be pinned in a strat section or something, IMHO. this thing is hotter than winona ryder circa the early 90s.
QUOTE (Dirtydutch @ Tuesday, December 2nd, 2008, 12:21 AM) <{POST_SNAPBACK}>
If there are two things LHE players like, they are weed and pornography. The third would be kittens. LHE does not appear on the list.





#19 DoinSublime

DoinSublime

    awake at the lectern and asleep at the switch.

  • Members
  • 5,990 posts
  • Gender:Male
  • Location:Coast of Maine
  • Interests:winning
  • Favorite Poker Game:sickaments

Posted 14 March 2007 - 01:54 AM

View Postcheckymcfold, on Wednesday, March 14th, 2007, 4:43 AM, said:

this should be pinned in a strat section or something, IMHO. this thing is hotter than winona ryder's merchandise when she leaves a store.
fyp
QUOTE(Acid_Knight @ Tuesday, July 22nd, 2008, 2:10 AM) View Post
That's why I just blindly fling money into the pots until they fold.


#20 Dubey

Dubey

    Poker Forum God

  • Members
  • 10,939 posts
  • Location:Lethbridge, Alberta

Posted 14 March 2007 - 01:56 AM

View PostDoinSublime, on Wednesday, March 14th, 2007, 2:54 AM, said:

fyp
well played sir..And Cwik, AWESOME spreadsheet.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users