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

Spreadsheet for Jennifear's Bankroll/Cashout Plan (Excel UPDATE!)

Reply to Thread
  1. Rycky4Golf Rycky4Golf is offline

    Houston, TX
    United States

    Posts: 233
    Joined: Feb 07

    Dec 17th, 2008 (12/17/2008 7:11am)

    OK, I think I've managed to find a place to post the spreadsheet, this is the link, I hope it works: http://www.megaupload.com/?d=34WJAXD6
    ***UPDATE! Below find a link to an Excel version of the spreadsheet. This was a "rough draft" of the idea I started at work. I tried to bring it up-to-date so that is similar to work I had at home. Hopefully this will work out better for everyone. Its not special, so if you have time to improve on it, be my guest:

    http://www.megaupload.com/?d=ZZK53VN0

    ***

    Let me know if there are any problems since I'm not entirely sure the download went without a hitch. Also, be aware that this is a QuattroPro file. For whatever reason I have that instead of Excel on my computer... who knew?

    Feel free to enhance or otherwise improve on what I have here as I figured I would be the only one to use it. It should be self-explanatory, but just in case:

    The numbers in Column B are ones where you enter in the total dollars spent in buyins for each type of game. You can adjust this by adding a row and putting in a different spread of games like Jen did, I don't play a great variety of games so the 4 categories worked for me. You can also change the percentage that you cashout by changing the formula in each cell in Column D. Right now I have 3%, 4%, 6%, and 8% in there for the four games.

    The Positive and Negative Adjustment areas are to account for things like rakeback, bonuses, and other items that would alter your actual cashout. All of these are numbers you need to input expect for Live Buyins Paid, that number is simply brought down from Cell B17.

    On the right side of the sheet you'll see where I put Max Buyins for your bankroll management, you can again adjust the number of buyins by simply adjusting the formula in the cell. I also put in a spot where you can type in your account balances by site and of course you can change/add/delete rows as you need. If you use this you'll be able to see your actual bankroll below that.

    It may not be an optimal setup, but it should work. I don't know if its what you wanted but it might be a start toward what you do want. Enjoy!
  2. mesaplayeraz mesaplayeraz is online now

    Posts: 3,379
    Joined: Sep 06

    Dec 17th, 2008 (12/17/2008 7:26am) in reply to Rycky4Golf

    I'm hoping someone can take the info Rycky provided and put it into excel and post a link or whatever to be able to use excel.

    I tried to download it and it wont work because I have excel on my computer.
  3. MYBLUEDOG MYBLUEDOG is offline

    Greenville, MS
    United States

    Posts: 1,999
    Joined: May 07

    Dec 17th, 2008 (12/17/2008 9:18am) in reply to Rycky4Golf

    I was also able to download the SS.

    I tried to open it with EXCEL, Staroffice SS, Openoffice Calc SS, and google doc SS.

    Unfortunately I was not able to open the .qpw in a spreadsheet format.

    If I could see the SS as a image file (take a screen shot), then I might be able to build an EXCEL or Google SS.

    Could RYCKY possibly build it on a google SS format and also put that on megaupload then we might have something to work with.

    Openoffice.org has a free package(including CALC the spreadsheet),that could be used to build the SS and it would be transferable to anyone for download
  4. Rycky4Golf Rycky4Golf is offline

    Houston, TX
    United States

    Posts: 233
    Joined: Feb 07

    Dec 17th, 2008 (12/17/2008 10:01am) in reply to MYBLUEDOG

    Somebody (name escapes me) has asked for the file and they intend to convert it into Excel format. Hopefully they'll get it done soon.
    Thread Starter
  5. bonflizubi bonflizubi is offline

    Cambridge, MA
    United States

    Posts: 4,519
    Joined: Sep 07

    Dec 17th, 2008 (12/17/2008 10:27am) in reply to Rycky4Golf

    what version of quattro pro did you use to create it?
     
  6. Rycky4Golf Rycky4Golf is offline

    Houston, TX
    United States

    Posts: 233
    Joined: Feb 07

    Dec 17th, 2008 (12/17/2008 11:03am) in reply to bonflizubi

     
    Originally Posted by bonflizubi View Post


    what version of quattro pro did you use to create it?

    I have no idea, I'll have to take a look at home.
    Thread Starter
  7. bonflizubi bonflizubi is offline

    Cambridge, MA
    United States

    Posts: 4,519
    Joined: Sep 07

    Dec 17th, 2008 (12/17/2008 11:54am) in reply to Rycky4Golf

     
    Originally Posted by Rycky4Golf View Post

     
    Originally Posted by bonflizubi View Post


    what version of quattro pro did you use to create it?

    I have no idea, I'll have to take a look at home.

    I'd convert it but my version of excel 2003 only converts certain quattro versions. I think .wx3 is the latest version it will convert. (second character isn't an x, just cant remember the letter from the excel help I was reading.)
     
  8. wvu138 wvu138 is offline

    Morgantown, WV
    United States

    Posts: 289
    Joined: Oct 07

    Dec 17th, 2008 (12/17/2008 12:27pm) in reply to Rycky4Golf

    I would def love of someone could convert this. Thanks a lot!
  9. Hateflops Hateflops is offline 7 over par. ship it!

    Posts: 7,044
    Joined: Nov 05

    Dec 17th, 2008 (12/17/2008 12:50pm) in reply to wvu138

    Nerds
  10. MYBLUEDOG MYBLUEDOG is offline

    Greenville, MS
    United States

    Posts: 1,999
    Joined: May 07

    Dec 17th, 2008 (12/17/2008 1:29pm) in reply to Rycky4Golf

    Here is the spreadsheet converted to EXCEL 2007


    <span id="lw_1229541816_1">http://www.megaupload.com/?d=LRQBN9FD</span>

    I also have it in openoffice spreadsheet and will add it when the upload is complete.

    <textarea id="texturl">http://www.megaupload.com/?d=LRQBN9FD</textarea>
  11. MYBLUEDOG MYBLUEDOG is offline

    Greenville, MS
    United States

    Posts: 1,999
    Joined: May 07

    Dec 17th, 2008 (12/17/2008 1:39pm) in reply to Rycky4Golf

    If you don't have a current version of OFFICE/EXCEL 2007, here is RYCKYS_SS_CASHOUT_SYSTEM saved in Openoffice software.

    <span id="lw_1229542480_1">http://www.megaupload.com/?d=DL42EHE6</span>

    If you need a full featured office software suite you can download this free suite from SunMicrosystems at openoffice.org
  12. Rycky4Golf Rycky4Golf is offline

    Houston, TX
    United States

    Posts: 233
    Joined: Feb 07

    Dec 17th, 2008 (12/17/2008 1:44pm) in reply to MYBLUEDOG

    Yay! Thanks for making it work.
    Thread Starter
  13. MYBLUEDOG MYBLUEDOG is offline

    Greenville, MS
    United States

    Posts: 1,999
    Joined: May 07

    Dec 17th, 2008 (12/17/2008 1:57pm) in reply to Rycky4Golf

    Hey, guys,

    Jennifears cashout plan covers more levels than what RYCKY's does for himself.

    If you play at different levels you'll need to change the percentages and the buy-in factors to match what levels you play.

    Otherwise the spreadsheet could give you a point to start if you wish to develop your own spreadsheet.
  14. Jennifear Jennifear is offline

    Niagara Falls, NY
    United States

    Posts: 10,222
    Joined: Nov 05

    Dec 17th, 2008 (12/17/2008 2:01pm) in reply to Rycky4Golf

    TY for this Rycky. You rock as always.

    I'm afraid that I cannot answer too many spreadsheet questions because I am somewhat computer illiterate, but I will be messing with this so that hopefully eventually I can help people with questions.
  15. Rycky4Golf Rycky4Golf is offline

    Houston, TX
    United States

    Posts: 233
    Joined: Feb 07

    Dec 17th, 2008 (12/17/2008 2:22pm) in reply to Jennifear

    Jen, just by opening the file you'll know as much about spreadsheets as I do. :)
    Thread Starter
  16. Rycky4Golf Rycky4Golf is offline

    Houston, TX
    United States

    Posts: 233
    Joined: Feb 07

    Dec 17th, 2008 (12/17/2008 2:25pm) in reply to MYBLUEDOG

     
    Originally Posted by MYBLUEDOG View Post

    Hey, guys,

    Jennifears cashout plan covers more levels than what RYCKY's does for himself.

    If you play at different levels you'll need to change the percentages and the buy-in factors to match what levels you play.

    Otherwise the spreadsheet could give you a point to start if you wish to develop your own spreadsheet.

    This. Hopefully somebody that has some time and can work a spreadsheet can take what I have and make it more like something worth having. Thanks!
    Thread Starter
  17. mesaplayeraz mesaplayeraz is online now

    Posts: 3,379
    Joined: Sep 06

    Dec 17th, 2008 (12/17/2008 7:35pm) in reply to Rycky4Golf

    Bump for the night crowd. I got this working and it looks great. Thanks!
Reply to Thread

Similar Threads