Jump to content


Poker Spreadsheet


  • Please log in to reply
142 replies to this topic

#21 dtukkers

dtukkers

    Poker Forum Newbie

  • Members
  • 2 posts
  • Favorite Poker Game:NLHE

Posted 14 March 2007 - 05:25 AM

Great excell sheet but when I try to activate macro's I get this error, anyone know why?"The visual basic for applications (VBA) Macros in this workbook are corrupted and have been deleted. The macro corruption most likely exsist in the current file. To recover the macros, open a backup copy of this file if you have one."

#22 RDog

RDog

    I'm Barry Sanders bitches!!!

  • Members
  • 10,919 posts
  • Gender:Male
  • Location:Orange County, CA

Posted 14 March 2007 - 05:42 AM

This is pretty cool but it isn't calculating MTT ROI correctly.MTT Entry MTT Type MTT Results SNG Entry SNG Type SNG Result Entrants Place Profit215 NL $860.00 $645.00$109.00 NL $4,500.00 $4,391.00 $0.00MTT ROI: 97.97% (Should be over 1000%)

#23 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 - 05:56 AM

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

fyp
i LOLed, even if you did dare make fun of my biggest crush ever. :icon_biggrin:edit: i haven't actually moved stuff from my own spreadsheet to this big fancy one yet. does it still have some kinks that need to get worked out?
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.





#24 BudBundy

BudBundy

    The Sacred Geometry of Chance

  • Members
  • 3,754 posts
  • Gender:Male
  • Location:Turk
  • Favorite Poker Game:PLO

Posted 14 March 2007 - 08:02 AM

I hate to ask but......Is it possible to download Excell?

#25 cwik

cwik

    Bully for you.

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

Posted 14 March 2007 - 12:13 PM

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

this should be pinned in a strat section or something, IMHO. this thing is hotter than winona ryder circa the early 90s.
I was thinking the same thing myself, was gonna get around to PMing Zach6367298283

View Postdtukkers, on Wednesday, March 14th, 2007, 6:25 AM, said:

Great excell sheet but when I try to activate macro's I get this error, anyone know why?"The visual basic for applications (VBA) Macros in this workbook are corrupted and have been deleted. The macro corruption most likely exsist in the current file. To recover the macros, open a backup copy of this file if you have one."
Does anyone else have this problem?? Are you using excel to open it?? what version? I'd either recommend trying to redownload it, and if that does not work, PM me or msg me on AIM and I'll give you the VBA codeing.

View PostRDog, on Wednesday, March 14th, 2007, 6:42 AM, said:

This is pretty cool but it isn't calculating MTT ROI correctly.MTT Entry MTT Type MTT Results SNG Entry SNG Type SNG Result Entrants Place Profit215 NL $860.00 $645.00$109.00 NL $4,500.00 $4,391.00 $0.00MTT ROI: 97.97% (Should be over 1000%)
heh, opps. Thanks for the catch, I've updated the link on the first page, but if anyones already entered in a lot of information and does not wanna redownload it. just change cell J8 to " =-J6/J5 ", you'll have to do this for sat, sng, and cash ROI too.

View PostBudBundy, on Wednesday, March 14th, 2007, 9:02 AM, said:

I hate to ask but......Is it possible to download Excell?
I just checked thepiratebay really fast and looks like it is there. However, this does not mean I recommend... nm.

View PostDubey, on Wednesday, March 14th, 2007, 2:56 AM, said:

And Cwik, AWESOME spreadsheet.
And thanks again guys for the support.

#26 RDog

RDog

    I'm Barry Sanders bitches!!!

  • Members
  • 10,919 posts
  • Gender:Male
  • Location:Orange County, CA

Posted 14 March 2007 - 01:04 PM

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.

#27 cwik

cwik

    Bully for you.

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

Posted 14 March 2007 - 01:22 PM

View PostRDog, on Wednesday, March 14th, 2007, 2:04 PM, said:

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.

#28 silkyjonson

silkyjonson

    steppin out

  • Members
  • 6,907 posts
  • Location:windsor

Posted 14 March 2007 - 01:30 PM

:club: :D I applaud you cwik. you are a man among men

#29 SpeedKills

SpeedKills

    Poker Forum Veteran

  • Members
  • 3,516 posts
  • Gender:Male
  • Location:Chicago
  • Interests:Poker, Soccer

Posted 14 March 2007 - 02:02 PM

thanks man, ive been looking for a new one

#30 milojones

milojones

    Poker Forum Regular

  • Members
  • 225 posts
  • Favorite Poker Game:Limit Omaha 8O

Posted 14 March 2007 - 07:18 PM

cwik, this is absolutely rediculous.i just got done inputting all my data from that first sreadsheet you gave me. very very impressive
"It can be argued that man's instinct to gamble is the only reason he is still not a monkey up in the trees." -Mario Puzo

#31 SpeedKills

SpeedKills

    Poker Forum Veteran

  • Members
  • 3,516 posts
  • Gender:Male
  • Location:Chicago
  • Interests:Poker, Soccer

Posted 18 March 2007 - 09:29 PM

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

#32 Marchione

Marchione

    brad booth fanboy !

  • Members
  • 1,464 posts
  • Location:Downunder
  • Interests:i love to eat

Posted 19 March 2007 - 12:28 AM

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
~I rake in his stack and punch his ticket on the valuetown express. And its was only one way~

#33 mk

mk

    nord-américain racaille

  • Members
  • 9,878 posts

Posted 19 March 2007 - 08:11 AM

i like that both of rdog's posts in this thread are v v thinly veiled brag posts.nice spreadsheet, cwik.

#34 HermanKahn

HermanKahn

    Poker Forum Nut

  • Members
  • 400 posts

Posted 19 March 2007 - 08:33 AM

I agree--put something up so we can all send you $5!! This is just too useful to go unrewarded. :club: Thanks again...
.
.

#35 mrdannyg

mrdannyg

    Cheese Salesman

  • Members
  • 20,310 posts
  • Gender:Male

Posted 19 March 2007 - 08:53 AM

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.
Long signatures are really annoying.

#36 milbucksfans

milbucksfans

    Poker Forum Regular

  • Members
  • 106 posts
  • Location:Milwaukee, WI

Posted 19 March 2007 - 09:22 AM

Good stuff, man. Really nice work.Only one question: What happened to the "a" in tournaments? :club:

#37 NoSup4U

NoSup4U

    Making Poppinfresh look like a nit

  • Members
  • 10,674 posts
  • Gender:Male
  • Location:Phoenix, AZ
  • Favorite Poker Game:Shorthanded NLHE

Posted 19 March 2007 - 09:29 AM

View Postcheckymcfold, on Monday, March 12th, 2007, 5:57 PM, said:

:club: clay aiken.
FYPMark

#38 cwik

cwik

    Bully for you.

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

Posted 19 March 2007 - 01:07 PM

View PostSpeedKills, on Sunday, March 18th, 2007, 10:29 PM, said:

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.

View Postmrdannyg, on Monday, March 19th, 2007, 9:53 AM, said:

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.

View Postmilbucksfans, on Monday, March 19th, 2007, 10:22 AM, said:

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?

View PostMarchione, on Monday, March 19th, 2007, 1:28 AM, said:

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

#39 mrdannyg

mrdannyg

    Cheese Salesman

  • Members
  • 20,310 posts
  • Gender:Male

Posted 19 March 2007 - 01:47 PM

View Postcwik, on Monday, March 19th, 2007, 4:07 PM, said:

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.

View Postcwik, on Monday, March 19th, 2007, 4:07 PM, said:

Donations will be accepted! :club: cwik1 on Full Tilt PokerCwik1 on PokerStars
will definitely be sent. thanks for your hard work.
Long signatures are really annoying.

#40 cwik

cwik

    Bully for you.

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

Posted 19 March 2007 - 01:59 PM

View Postmrdannyg, on Monday, March 19th, 2007, 2:47 PM, said:

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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users