Jump to content

Poker Spreadsheet


Recommended Posts

Awesome. A few things I amended as well. The first buyin of MTT to Currency format. MTT cost should start at G15 instead of G16. I also widened the profit column as 5 digit scores weren't showing.This is great. Nice job bud.

Link to post
Share on other sites
  • Replies 142
  • Created
  • Last Reply

Top Posters In This Topic

Awesome. A few things I amended as well. The first buyin of MTT to Currency format. MTT cost should start at G15 instead of G16. I also widened the profit column as 5 digit scores weren't showing.This is great. Nice job bud.
Thanks RDog, I updated the spreadsheet. yeah, 5 digit scores, thats something I'm gonna have to start working on. I know a few things are a bit squeezed, but it was formated to fit my 1600x1200 screen.Let me know if there is any other functions you'd be interested in having.Also, if someone is really good with excel charts PM me. There is something I'd like to do, but haven't figured out how to do so yet.
Link to post
Share on other sites

so the older one worked for me, but then when i open it it says macros are disabled because of the security level and because the macros havent been signed. Any help guys>? nm, got that fixed. but how do i add different sites. thanks

Link to post
Share on other sites

whats your user name on stars ~ i would like to send you 5$dude thanks for this ~ i have been doing my by hand for for tooo long and other ones have not cut it like this one

Link to post
Share on other sites

this is pretty fantastic. i don't play tourneys, so is it possible to separate the features and have a 'cash games only' spreadsheet, or to somehow hide the tourney features?also, another feature that might be useful for cash games is columns to simply type in the start and end time for a session, and have the hours played calculated. this would be particularly useful for multi-tablers.thanks again for all the hard work, and for sharing it. i'm looking for some motivation to put in some hours, and this should help.

Link to post
Share on other sites
so the older one worked for me, but then when i open it it says macros are disabled because of the security level and because the macros havent been signed. Any help guys>? nm, got that fixed. but how do i add different sites. thanks
The are a couple ways of adding additional sites. On the info sheet, under the "site" section I left a couple extra lines do add additional sites. You can even go further to add more sites by going to insert>name>define and selecting "sites" then changeing the range from "=Info!$A$3:$A$13" to "=Info!$A$3:$A$17". (note there is "site" and "sites" you want the later). You can also simply change the name of any site already listed to another one if you would rather. However way you do it ,you will need to also add the same name to the "more stats" page. This is something I will attempt to fix when I get home, so it auto adjusts on the more stats page.
this is pretty fantastic. i don't play tourneys, so is it possible to separate the features and have a 'cash games only' spreadsheet, or to somehow hide the tourney features?also, another feature that might be useful for cash games is columns to simply type in the start and end time for a session, and have the hours played calculated. this would be particularly useful for multi-tablers.thanks again for all the hard work, and for sharing it. i'm looking for some motivation to put in some hours, and this should help.
Right now it would be a bit difficult to have just the cash section, however the first thing that came to mind that might help you is if you copy/paste the cash games botton you can put add it to another location, that might help you quickly get to the cash imput row. Also in the long run you might decide to play a few tourneys/sng's and it will be helpful to have that section as well.
Good stuff, man. Really nice work.Only one question: What happened to the "a" in tournaments? :club:
hehe, opps.I'm at my parents place down in LA for the week, but will fix that when I get home.On that note, anyone one gonna be playing at Commerce in the next couple days?
whats your user name on stars ~ i would like to send you 5$dude thanks for this ~ i have been doing my by hand for for tooo long and other ones have not cut it like this one
Thanks complements guys, it is appreciated as I put a lot of work into this. Donations will be accepted! :D cwik1 on Full Tilt PokerCwik1 on PokerStars
Link to post
Share on other sites
Right now it would be a bit difficult to have just the cash section, however the first thing that came to mind that might help you is if you copy/paste the cash games botton you can put add it to another location, that might help you quickly get to the cash imput row. Also in the long run you might decide to play a few tourneys/sng's and it will be helpful to have that section as well.
definitely - i'll work on separating them, maybe altering it slightly and/or adding a worksheet for cash game multi-tablers to input sessions, though i'm not too good with excel. a lot of the other stuff available with it is gold.
Donations will be accepted! :club: cwik1 on Full Tilt PokerCwik1 on PokerStars
will definitely be sent. thanks for your hard work.
Link to post
Share on other sites
definitely - i'll work on separating them, maybe altering it slightly and/or adding a worksheet for cash game multi-tablers to input sessions, though i'm not too good with excel. a lot of the other stuff available with it is gold.will definitely be sent. thanks for your hard work.
I considered adding a start time/end session colums, however I just figured this is easy to caluclate and would be adding unnessasary columns. Again I was trying to keep things simple. But feel free to edit the worksheet in what ever way would best fit you.You can also, cut/paste the cash section onto another sheet and it should still work, if that is easier for you. (copying will not work).As for my self. I also multitable (4x) cash sessions and find it easier to just record my sessions on a piece of paper and then imput the data at the end. (same when muli tabling sng's). Basically wrting down the start time and buy in for all the tables, and then add amounts whenever I rebuy, then total it at the end.
Link to post
Share on other sites

cwik i think i fked mine up a little. I was looking for a place to insert my starting BR, and I put it in where the equation for current BR is, how can i fix this? Thanks so much. i am a complete excel newb, but this looks great to me :club:

Link to post
Share on other sites
cwik i think i fked mine up a little. I was looking for a place to insert my starting BR, and I put it in where the equation for current BR is, how can i fix this? Thanks so much. i am a complete excel newb, but this looks great to me :club:
edit, undo.Or you could open up a clean copy of the fule, copy the formula, and then put it into the appropriate cell. Or, if you haven't done much, you could simply redownload the file and start over.edit: Awesome spreadsheet Cwik.
Link to post
Share on other sites
edit, undo.Or you could open up a clean copy of the fule, copy the formula, and then put it into the appropriate cell. Or, if you haven't done much, you could simply redownload the file and start over.edit: Awesome spreadsheet Cwik.
ok i restarted, where do i put in starting BR?and what do you guys do for rebuys? Just make the entry total number of rebuys+ add ons?thanks
Link to post
Share on other sites
ok i restarted, where do i put in starting BR?
It says in the comments I left at the top right. Starting bankroll is listed under transactions.
Link to post
Share on other sites
i like that both of rdog's posts in this thread are v v thinly veiled brag posts.nice spreadsheet, cwik.
Ummmm....not really. The first one was completely made up numbers to see if it would work and the other was purely a hypothetical. Not any of those to plug in recently :club:. Thanks for reminding me though.
Link to post
Share on other sites
  • 2 weeks later...

Hey guys.I made a few changes and added the update on the original post.a. Fix a lot of the columns on the more stats page so they auto-update when you make changes on the info page.b. Added a new column for Cash Games, "number of tables played".c. Also added a table on the More Stats page, that calculates ROI based on number of tables played. This will be useful for multitablers.d. Put the "a" in Tournaments.Let me know if there are any problems.

Link to post
Share on other sites
Hey guys.I made a few changes and added the update on the original post.a. Fix a lot of the columns on the more stats page so they auto-update when you make changes on the info page.b. Added a new column for Cash Games, "number of tables played".c. Also added a table on the More Stats page, that calculates ROI based on number of tables played. This will be useful for multitablers.d. Put the "a" in Tournaments.Let me know if there are any problems.
So does that mean we have to re-enter all our stats?Thanks for updating man. I only play on bodog, so if they ever offer transfers ill transfer you some
Link to post
Share on other sites
So does that mean we have to re-enter all our stats?Thanks for updating man. I only play on bodog, so if they ever offer transfers ill transfer you some
I'm not really sure about this. Anyone know a good way to transfer data? I'm thinking it's gonna wanna refer to the old one if you copy/paste.
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Announcements


×
×
  • Create New...