Jump to content


Calling All Techheads: Let's Make A Wicked Spreadsheet


  • Please log in to reply
106 replies to this topic

#1 checkymcfold

checkymcfold

    almost back to real stakes.

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

Posted 05 January 2007 - 03:18 PM

it's 2007 and everyone's going to start keeping new records, right? and we'd all like a wicked spreadsheet to help do that, right?so i say let's all pool resources and make something better than we've been using in the past. i have something that works for me and would be glad to offer it as a starting point, but if anyone has something more involved then by all means, let's start with that instead.by all means, post suggestions for new features, etc. in this thread.here's a link to what i've started with: http://s26.quickshar...rkbook.xls.htmlFYI: if you want to use this, don't type in the red cells, and don't delete the sample sessions. they aren't calculated into the overall stats tab.what i and others want to add so far: -more detailed charts with session by session info and some sort of trendline type deal-some more advanced analysis of what parts of my money are coming from what games/limits-tab for bonuses/rakeback-a way of better automating bankroll situations
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.





#2 Marc-O

Marc-O

    Poker Forum Groupie

  • Members
  • 626 posts
  • Location:Ontario, CAN

Posted 05 January 2007 - 03:24 PM

I use a good one from flopturnriver.comIll find the link for you if interested
Pokerstars - Marc-0
Full Tilt - MacroMarc
Ultimate Bet - Marc-O
Party Poker - Marc_O

#3 checkymcfold

checkymcfold

    almost back to real stakes.

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

Posted 05 January 2007 - 03:27 PM

View PostMarc-O, on Friday, January 5th, 2007, 5:24 PM, said:

I use a good one from flopturnriver.comIll find the link for you if interested
i've seen that one. it's ok, but i think we can do better, for real. that one's not very customizable and doesn't easily support multiple games and structures.
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.





#4 Bubba83

Bubba83

    Poker Forum Veteran

  • Members
  • 1,425 posts
  • Gender:Male
  • Location:Sunnyvale, CA
  • Interests:Web Programming<br />Computer Games<br />Beer Tasting<br />Roller Coasters
  • Favorite Poker Game:7 Stud Hi/Lo

Posted 05 January 2007 - 03:30 PM

Mine sucks.It works.I carry on.

#5 antistuff

antistuff

    monotonously monotonous

  • Members
  • 5,466 posts
  • Gender:Male
  • Location:new york city

Posted 05 January 2007 - 03:43 PM

a tab to keep track of bonuses and rakeback would be nice.
QUOTE ( Barry Greenstein)
Successful gamblers are compulsive winners.

#6 fleung22

fleung22

    PokerStars Global Events Rep (PokerStars Macau)

  • Members
  • 7,006 posts
  • Gender:Male
  • Location:Vancouver-->Toronto-->Macau

Posted 05 January 2007 - 03:44 PM

View Postcheckymcfold, on Friday, January 5th, 2007, 3:18 PM, said:

it's 2007 and everyone's going to start keeping new records, right? and we'd all like a wicked spreadsheet to help do that, right?so i say let's all pool resources and make something better than we've been using in the past. i have something that works for me and would be glad to offer it as a starting point, but if anyone has something more involved then by all means, let's start with that instead.by all means, post suggestions for new features, etc. in this thread.here's a link to what i've started with: http://s26.quickshar...rkbook.xls.htmlwhat i want to add so far: -more detailed charts with session by session info and some sort of trendline type deal-some more advanced analysis of what parts of my money are coming from what games/limits
i think what you want is to have is a combination of excel and ms access.it'll do everything you're asking and your data entry could be on either format before using access to hold the database and produce data, graphs, etc.tell me exactly what you need and i can help Jamie.


#7 checkymcfold

checkymcfold

    almost back to real stakes.

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

Posted 05 January 2007 - 03:49 PM

View Postfleung22, on Friday, January 5th, 2007, 5:44 PM, said:

i think what you want is to have is a combination of excel and ms access.it'll do everything you're asking and your data entry could be on either format before using access to hold the database and produce data, graphs, etc.tell me exactly what you need and i can help Jamie.
i want you to stop using big fancy computer words, lol. i honestly wrote the spreadsheet with my wits and the excel help files, but i know it can be better. you play poker, you know what stats are useful--make my thing give those stats. :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.





#8 fleung22

fleung22

    PokerStars Global Events Rep (PokerStars Macau)

  • Members
  • 7,006 posts
  • Gender:Male
  • Location:Vancouver-->Toronto-->Macau

Posted 05 January 2007 - 04:08 PM

View Postcheckymcfold, on Friday, January 5th, 2007, 3:49 PM, said:

i want you to stop using big fancy computer words, lol. i honestly wrote the spreadsheet with my wits and the excel help files, but i know it can be better. you play poker, you know what stats are useful--make my thing give those stats. :club:
what am i? your biotch?!oh wait...maybe i am...who won that last round of golf again?meh...i'll see what i can do when i'm bored. i like building things in access but i won't be able to do it fast


#9 hungerfan

hungerfan

    Poker Forum Newbie

  • Members
  • 25 posts

Posted 05 January 2007 - 04:14 PM

here is an outdated screenshot of what i created. some columns have been moved around and i now calculate total time and $ per hour that i make. oh and i have a tab after each month for a chart to see how my bankroll moves. i prefer an upward direction but the last thre months of 2006 it was more of a rollercoaster.There are some issues with rounding at certain times but I have used it enough now I can catch it and make a slight tweak to that cell and it works fine. Nothing I ever cared to look into and fix.Posted ImageEd

#10 Actuary

Actuary

    .

  • Members
  • 19,028 posts

Posted 05 January 2007 - 04:16 PM

fleung is right.Get this into a database first.I'd suggest FoxProFaster than Access.But Access is user friendlier and more people know how to write VB than whatever programs in FoxPro

#11 fleung22

fleung22

    PokerStars Global Events Rep (PokerStars Macau)

  • Members
  • 7,006 posts
  • Gender:Male
  • Location:Vancouver-->Toronto-->Macau

Posted 05 January 2007 - 04:19 PM

View PostActuary, on Friday, January 5th, 2007, 4:16 PM, said:

fleung is right.Get this into a database first.I'd suggest FoxProFaster than Access.But Access is user friendlier and more people know how to write VB than whatever programs in FoxPro
You know your stuff.Indeed, Access isn't the best but I just don't see how a single user could possibly fill the database to a point where it'll become unstable.It'll do just fine and it's a common piece of MS Office so a lot of people can benefit and find the software easily. I'd say as old as Access'95 will do the trick.


#12 checkymcfold

checkymcfold

    almost back to real stakes.

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

Posted 05 January 2007 - 04:20 PM

View Postfleung22, on Friday, January 5th, 2007, 6:19 PM, said:

You know your stuff.Indeed, Access isn't the best but I just don't see how a single user could possibly fill the database to a point where it'll become unstable.It'll do just fine and it's a common piece of MS Office so a lot of people can benefit and find the software easily. I'd say as old as Access'95 will do the trick.
ok, geekface. i've never used access. make it go :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.





#13 Abbaddabba

Abbaddabba

    breaking even like it's 1999

  • Members
  • 5,225 posts

Posted 05 January 2007 - 04:27 PM

I like the one i made. It's got a lot of other functions besides just tracking results. If anyone wants it, write down your email here and ill send it.

#14 No_Neck

No_Neck

    this is how i roll

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

Posted 05 January 2007 - 04:27 PM

View Postcheckymcfold, on Friday, January 5th, 2007, 7:20 PM, said:

make it go :club:.
I loled

#15 checkymcfold

checkymcfold

    almost back to real stakes.

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

Posted 05 January 2007 - 04:35 PM

View PostAbbaddabba, on Friday, January 5th, 2007, 6:27 PM, said:

I like the one i made. It's got a lot of other functions besides just tracking results. If anyone wants it, write down your email here and ill send it.
can you host it somewhere and share? this may go better if we do some sort of open source type deal.
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.





#16 Abbaddabba

Abbaddabba

    breaking even like it's 1999

  • Members
  • 5,225 posts

Posted 05 January 2007 - 04:36 PM

If you want to upload it, i can send it to you.

#17 checkymcfold

checkymcfold

    almost back to real stakes.

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

Posted 05 January 2007 - 04:38 PM

View PostAbbaddabba, on Friday, January 5th, 2007, 6:36 PM, said:

If you want to upload it, i can send it to you.
sure, zed013 at aim.com
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.





#18 flyingdonkey

flyingdonkey

    Mexican Transformers

  • Members
  • 2,956 posts
  • Gender:Male
  • Interests:I love play pokah!

Posted 05 January 2007 - 04:42 PM

View PostAbbaddabba, on Friday, January 5th, 2007, 5:27 PM, said:

I like the one i made. It's got a lot of other functions besides just tracking results. If anyone wants it, write down your email here and ill send it.
ciscoxrivera@gmail.comThanks!

#19 2bthebest

2bthebest

    Quad Kings 2 times in 5 hands, no its not rigged.

  • Members
  • 1,116 posts
  • Gender:Male
  • Location:Running goot in satellites and 2/4 NL apparently

Posted 05 January 2007 - 05:23 PM

I am currently using this one from a P5er.Link

<pocket3s> who is this 2bthebest guy?
<Janfor99> lol
<_2bthebest> hey 3s
<Janfor99> some guy who 'runs goot'
<FlyingDonkey> He is FCP's hero
<pocket3s> what's up man
<Janfor99> lol

#20 nutzbuster

nutzbuster

    Point taken....

  • Members
  • 11,378 posts
  • Gender:Male
  • Location:Phoenix / Motor City

Posted 05 January 2007 - 05:37 PM

NERDS!Posted Image



F Cancer




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users