Check out our brand new Local Poker Communities! Get updates and interact with poker players in your area.
Visit the United States Poker Community | Visit the California Poker Community | Read more about the Launch of P5s Local

To anyone good with microsoft excel/open office

Reply to Thread
  1. Plattsburgh Plattsburgh is offline

    Red Hook, NY
    United States

    Posts: 3,371
    Joined: Aug 05

    May 7th, 2006 (5/7/2006 6:44pm)

    I just got open office, its alot like excel but free. I am looking to play poker as a summer job this summer, so I want to be able to track my tournaments and cash games to see what I make per hour etc etc.. Does anyone have a good program or could help me with where to get one, or familiarize me with open office I would appreciate it, thanks guys.
     
  2. jesterwords jesterwords is offline

    Posts: 20,674
    Joined: Jan 06

    May 7th, 2006 (5/7/2006 6:49pm) in reply to Plattsburgh

    http://www.mrexcel.com/articles.shtml
  3. Plattsburgh Plattsburgh is offline

    Red Hook, NY
    United States

    Posts: 3,371
    Joined: Aug 05

    May 7th, 2006 (5/7/2006 6:57pm) in reply to Plattsburgh

    bump, anyone I can get their IM and talk me through setting something up? that website just confuses me more ahha.
     
    Thread Starter
  4. Plattsburgh Plattsburgh is offline

    Red Hook, NY
    United States

    Posts: 3,371
    Joined: Aug 05

    May 7th, 2006 (5/7/2006 7:13pm) in reply to jesterwords

    anyone please?
     
    Thread Starter
  5. Plattsburgh Plattsburgh is offline

    Red Hook, NY
    United States

    Posts: 3,371
    Joined: Aug 05

    May 7th, 2006 (5/7/2006 7:58pm) in reply to Plattsburgh

    one last bump.... trying to get help plz
     
    Thread Starter
  6. Fish Beans Fish Beans is offline

    Posts: 6
    Joined: Feb 06

    May 7th, 2006 (5/7/2006 8:30pm) in reply to Plattsburgh

    It helps if you've had a little bit of programming.

    I put one buy-in one one sheet. In one column, I put the SNG number, as in the first one ever gets a 1, then the next gets a 2, the 37th gets 37 and so on up until however many SNGs I've played at that level. I then put my finish in that particular SNG in the column next to it. I keep good track of 1st thru 4th, but some of the others I forget and put them as a 5, 6 or 7.

    Then I tally up how many 1sts, 2nds, 3rds, bubbles, and Other Finishes. In excel they have a function COUNTIF('range','criterion '). Put the column with your finishes in the range, and a 1 for the criteria. For example: "=COUNTIF(B:B,1)" The stuff inside quotation marks is what you need to put in one of the cells in the spreadsheet, and this will count your first place finishes in column B. I do that for 1st-4th, and for other I just do #played minus the total of the top four finishes. Calc total investment by doing the buyin times #played. Then calc total win by multiplying the # of firsts by its prize, and adding what you got from all your seconds and thirds. Return is Total Win minus Total Invested, at least the way I name these things. ROI is Return/Total Invested.

    Just screw around with the spreadsheet, it takes a little time but it's kinda useful for this strff. It sure beats writing it all down and hacking at it with a calculator.

    Hope this helps.
  7. nowicki2005 nowicki2005 is offline

    Portland, MI
    United States

    Posts: 1,044
    Joined: Mar 05

    May 7th, 2006 (5/7/2006 8:34pm) in reply to Plattsburgh

    if your going to be playing poker this summer as a job, just get pokertracker for twenty five bucks. it keeps all your stats
  8. Fish Beans Fish Beans is offline

    Posts: 6
    Joined: Feb 06

    May 7th, 2006 (5/7/2006 8:48pm) in reply to nowicki2005

    Or do that. Yeah. Less time consuming by far. LOL
  9. cmitch cmitch is offline

    Posts: 1,112
    Joined: Feb 05

    May 7th, 2006 (5/7/2006 8:58pm) in reply to Plattsburgh

    Platt - PM me with your email address and i will send u a copy of the spreadsheet that i use. I spent a lot of time creating it and it probably has way too many stats.

    cmitch
Reply to Thread