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

DOWNLOAD Jesters EXCEL Tracker V5.0 Released Tonight (Hyperlinks inside)

Reply to Thread
  1. jesterwords jesterwords is offline

    Posts: 20,676
    Joined: Jan 06

    Nov 6th, 2006 (11/6/2006 9:44pm)

    OK,

    I've gotten several suggestions and spent all night working on the new vesion. This is not what I would call a massive overhaul, but it is a significant change to the previous version. For those who are interested, here is the link to the new spreadsheet.

    For those who questioned how to work the satelite issue, please see the test data in November of the below sheet.

    Jesters Tracker

    -

    Jesters Tracker with test data

    -Steve
  2. jesterwords jesterwords is offline

    Posts: 20,676
    Joined: Jan 06

    Nov 6th, 2006 (11/6/2006 9:56pm) in reply to jesterwords

    its still uploading... posted b4 it was done.
    Thread Starter
  3. jesterwords jesterwords is offline

    Posts: 20,676
    Joined: Jan 06

    Nov 6th, 2006 (11/6/2006 10:23pm) in reply to jesterwords

    going to bed... any questions, find me on chat tomorrow... or mail me.
    Thread Starter
  4. beanie beanie is offline

    Saint Paul, MN
    United States

    Posts: 6,272
    Joined: Jan 05

    Nov 6th, 2006 (11/6/2006 10:34pm) in reply to jesterwords

    just downloaded it, will recommend it to everyone I know.
  5. jesterwords jesterwords is offline

    Posts: 20,676
    Joined: Jan 06

    Nov 7th, 2006 (11/7/2006 4:39am) in reply to beanie

    wow beanie, thanks.
    Thread Starter
  6. jesterwords jesterwords is offline

    Posts: 20,676
    Joined: Jan 06

    Nov 7th, 2006 (11/7/2006 4:52am) in reply to jesterwords

    for B&M players... please start listing what Casinos you would like on the sheet and I can start working on that section as the next improvement.

    or mail me a jesterwords@yahoo.com
    Thread Starter
  7. nuht nuht is offline

    Bakersfield, CA
    United States

    Posts: 188
    Joined: Oct 05

    Nov 7th, 2006 (11/7/2006 9:19am) in reply to jesterwords

    Hey Jester,

    I am sure many people are downloading this file but do you think you can get some more links open? It's not slow but yet, it's not fast either. Thanks for the hard work Sir.

    Take care,
    nuht
  8. jeremyw jeremyw is offline

    Marietta, GA
    United States

    Posts: 213
    Joined: Sep 05

    Nov 7th, 2006 (11/7/2006 9:25am) in reply to jesterwords

    Jester,

    Just a suggestion, but what about putting the Sites on a separate sheet like you did with the buyins so the user can just add as new sites or B&M's as needed.

    Thanks again for a great sheet.
  9. jesterwords jesterwords is offline

    Posts: 20,676
    Joined: Jan 06

    Nov 7th, 2006 (11/7/2006 9:27am) in reply to nuht

    Unless someone else hosts the file, I have no other sites to host it from currently. Comcast gives me 25mb free space and the two sheets are taking up close to 19mb right now. All I can do is ask for your patience when pulling it down.

    -Steve
    Thread Starter
  10. jesterwords jesterwords is offline

    Posts: 20,676
    Joined: Jan 06

    Nov 7th, 2006 (11/7/2006 9:35am) in reply to jeremyw

    good idea... I can add them to the same sheet as the others, but with sites, I have direct references in formulas, so if users were to add sites, they would end up having to go through and deal with changing the references in the formulas.

    I'm self taught with excel, so we are getting into areas that would need VBA (which I've done some work in, but I'm no where near where I would need to be do all automation of fomulas for users to add sites). I would welcome anyone who is a VBA nut to help with such a thing, but I imagine adding in more VBA suff will start to make this thing close to 15mb - 20mb.

    As this is a work in progress, and I'm doing it for free, I'll see what I can do for you, but I can't promise that it would be easy on the end user for such a request. At the present time though, if you have sites that I am not listing, please let me know and I'll add them into the current format for V5.0.

    -Steve
    Thread Starter
  11. fishfinder fishfinder is offline

    Miami, FL
    United States

    Posts: 153
    Joined: Jun 06

    Nov 7th, 2006 (11/7/2006 9:24pm) in reply to jesterwords

    Keep up the good work Jester
  12. Bode-ist Bode-ist is offline

    Fishers, IN
    United States

    Posts: 49
    Joined: Jun 06

    Nov 9th, 2006 (11/9/2006 7:59am) in reply to jesterwords

    thanks jester.

    is there anyway to track bonuses? or do you have to just add it as a transaction type.
  13. jesterwords jesterwords is offline

    Posts: 20,676
    Joined: Jan 06

    Nov 9th, 2006 (11/9/2006 8:23am) in reply to Bode-ist

    Thats a good point. I need to add that in, for now enter it in as a deposit and put a note that it was a bonus earned in the BR page.
    Thread Starter
  14. Bode-ist Bode-ist is offline

    Fishers, IN
    United States

    Posts: 49
    Joined: Jun 06

    Nov 9th, 2006 (11/9/2006 2:53pm) in reply to jesterwords

    i just added "Bonus" to the list under "deposits" "withdraws" etc.

    it would be nice to see just your bonus total somewhere. anyway, thanks again.
  15. jesterwords jesterwords is offline

    Posts: 20,676
    Joined: Jan 06

    Nov 9th, 2006 (11/9/2006 3:26pm) in reply to Bode-ist

    I'll be adding in for the next version... looking at doing a complete overhaul with VBA... but I've got to relearn it while I'm doing it. UGH!
    Thread Starter
  16. BigSlickNYC BigSlickNYC is offline

    Irvington, NY
    United States

    Posts: 85
    Joined: Jul 05

    Nov 9th, 2006 (11/9/2006 4:04pm) in reply to jesterwords

    I can host it for you if you would like. Just PM me.
  17. jesterwords jesterwords is offline

    Posts: 20,676
    Joined: Jan 06

    Nov 9th, 2006 (11/9/2006 9:18pm) in reply to Bode-ist

    I added in Bonus cleared option into the BR section to track those now.

    Test data sheet has some entered in so you can see how it looks.
    Thread Starter
  18. TheProf1 TheProf1 is offline

    The Colony, TX
    United States

    Posts: 255
    Joined: Sep 06

    Nov 9th, 2006 (11/9/2006 9:48pm) in reply to jesterwords

    not letting me go to the site from the link can i have the actual site to just type it in.
  19. jesterwords jesterwords is offline

    Posts: 20,676
    Joined: Jan 06

    Nov 10th, 2006 (11/10/2006 4:10am) in reply to TheProf1

    sorry, fixed the link
    Thread Starter
  20. DDSpade DDSpade is offline

    Henderson, NV
    United States

    Posts: 551
    Joined: Apr 06

    Nov 10th, 2006 (11/10/2006 4:14am) in reply to jesterwords

    i downloaded version 5 and i get this upon opening it: missing file: C:css\pwplocal.css
  21. jesterwords jesterwords is offline

    Posts: 20,676
    Joined: Jan 06

    Nov 10th, 2006 (11/10/2006 4:31am) in reply to DDSpade

    DD... a css file is part of the sheet itself, I tried downloading to a different computer and had no problems. I have hyperlinking in the spreadsheet that uses css formatting.

    Here is the definition of a css file:

    <h3>Cascading Style Sheets</h3>
    (C-S-S)

    A developing specification that allows style sheets to be applied toWeb pages. With a style sheet one can design a particular look and thenapply that look in many places with a simple command. Cascading is usedto allow you to have styles within styles.

    Try downloading the file again, sounds like the download was corrupt.

    -Steve
    Thread Starter
  22. malignant malignant is offline

    Australia

    Posts: 3
    Joined: Nov 06

    Nov 10th, 2006 (11/10/2006 5:12am) in reply to jesterwords

    Jester, do you mind if we edit this spreadsheet ourselves and post our modifications (With appropriate acknowledgement of your work)?

    I wish to go in a slightly different direction with a similar project to this, hopefully with your blessing and support.
  23. tjbird13 tjbird13 is offline

    Lancaster, PA
    United States

    Posts: 130
    Joined: Mar 06

    Nov 11th, 2006 (11/11/2006 2:08am) in reply to jesterwords

    VN ty sir
  24. jesterwords jesterwords is offline

    Posts: 20,676
    Joined: Jan 06

    Nov 11th, 2006 (11/11/2006 6:31am) in reply to tjbird13

    There a a couple of fixes that need to get put in... went out with friends for birthday, got drunk, didn't work on it a lick. Keep on the lookout though. For those excel heads... on your sheets, in the A2 column...<table x:str="" border="0" cellpadding="0" cellspacing="0" width="121"><col width="121"><col> <tbody><tr><td x:str="" height="17" width="121"></td></tr></tbody></table>=IF(A3="","",(T2+(S3-R3)+(IF(F3=U10,M3-G3,M3))-L3)) <table x:str="" border="0" cellpadding="0" cellspacing="0" width="121"><col width="121"><col> <tbody><tr><td x:str="" height="17" width="121"></td></tr></tbody></table>
    Thread Starter
  25. Bode-ist Bode-ist is offline

    Fishers, IN
    United States

    Posts: 49
    Joined: Jun 06

    Nov 12th, 2006 (11/12/2006 4:35pm) in reply to jesterwords

    thanks for adding the bonus option, but there is still a slight problem with it.

    it tracks the bonus on the front page, but doesnt add it to your total BR on each months page.

    thanks,

    Bode
  26. jesterwords jesterwords is offline

    Posts: 20,676
    Joined: Jan 06

    Nov 12th, 2006 (11/12/2006 5:25pm) in reply to Bode-ist

    will look into that for you... working on some major ideas for changes right now, thats why I haven't put an update out in the past few days.

    I'm looking to reduce the size of it as well as fix a few bugs.

    Thanks,

    Steve
    Thread Starter
Reply to Thread