RDog 0 Posted March 14, 2007 Share Posted March 14, 2007 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. Link to post Share on other sites
cwik 0 Posted March 14, 2007 Author Share Posted March 14, 2007 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. Link to post Share on other sites
silkyjonson 1 Posted March 14, 2007 Share Posted March 14, 2007 I applaud you cwik. you are a man among men Link to post Share on other sites
SpeedKills 0 Posted March 14, 2007 Share Posted March 14, 2007 thanks man, ive been looking for a new one Link to post Share on other sites
milojones 0 Posted March 15, 2007 Share Posted March 15, 2007 cwik, this is absolutely rediculous.i just got done inputting all my data from that first sreadsheet you gave me. very very impressive Link to post Share on other sites
SpeedKills 0 Posted March 19, 2007 Share Posted March 19, 2007 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 Link to post Share on other sites
Marchione 0 Posted March 19, 2007 Share Posted March 19, 2007 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 Link to post Share on other sites
mk 11 Posted March 19, 2007 Share Posted March 19, 2007 i like that both of rdog's posts in this thread are v v thinly veiled brag posts.nice spreadsheet, cwik. Link to post Share on other sites
HermanKahn 0 Posted March 19, 2007 Share Posted March 19, 2007 I agree--put something up so we can all send you $5!! This is just too useful to go unrewarded. Thanks again... Link to post Share on other sites
mrdannyg 274 Posted March 19, 2007 Share Posted March 19, 2007 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. Link to post Share on other sites
milbucksfans 0 Posted March 19, 2007 Share Posted March 19, 2007 Good stuff, man. Really nice work.Only one question: What happened to the "a" in tournaments? Link to post Share on other sites
NoSup4U 0 Posted March 19, 2007 Share Posted March 19, 2007 clay aiken.FYPMark Link to post Share on other sites
cwik 0 Posted March 19, 2007 Author Share Posted March 19, 2007 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. thanksThe 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.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.Good stuff, man. Really nice work.Only one question: What happened to the "a" in tournaments? 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?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 oneThanks complements guys, it is appreciated as I put a lot of work into this. Donations will be accepted! cwik1 on Full Tilt PokerCwik1 on PokerStars Link to post Share on other sites
mrdannyg 274 Posted March 19, 2007 Share Posted March 19, 2007 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.Donations will be accepted! cwik1 on Full Tilt PokerCwik1 on PokerStarswill definitely be sent. thanks for your hard work. Link to post Share on other sites
cwik 0 Posted March 19, 2007 Author Share Posted March 19, 2007 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. Link to post Share on other sites
Footballguru 0 Posted March 20, 2007 Share Posted March 20, 2007 cwik i think i fked mine up a little. I was looking for a place to insert my starting BR, and I put it in where the equation for current BR is, how can i fix this? Thanks so much. i am a complete excel newb, but this looks great to me Link to post Share on other sites
kkot 0 Posted March 20, 2007 Share Posted March 20, 2007 cwik i think i fked mine up a little. I was looking for a place to insert my starting BR, and I put it in where the equation for current BR is, how can i fix this? Thanks so much. i am a complete excel newb, but this looks great to me edit, undo.Or you could open up a clean copy of the fule, copy the formula, and then put it into the appropriate cell. Or, if you haven't done much, you could simply redownload the file and start over.edit: Awesome spreadsheet Cwik. Link to post Share on other sites
Footballguru 0 Posted March 20, 2007 Share Posted March 20, 2007 edit, undo.Or you could open up a clean copy of the fule, copy the formula, and then put it into the appropriate cell. Or, if you haven't done much, you could simply redownload the file and start over.edit: Awesome spreadsheet Cwik.ok i restarted, where do i put in starting BR?and what do you guys do for rebuys? Just make the entry total number of rebuys+ add ons?thanks Link to post Share on other sites
cwik 0 Posted March 20, 2007 Author Share Posted March 20, 2007 ok i restarted, where do i put in starting BR?It says in the comments I left at the top right. Starting bankroll is listed under transactions. Link to post Share on other sites
RDog 0 Posted March 20, 2007 Share Posted March 20, 2007 i like that both of rdog's posts in this thread are v v thinly veiled brag posts.nice spreadsheet, cwik.Ummmm....not really. The first one was completely made up numbers to see if it would work and the other was purely a hypothetical. Not any of those to plug in recently . Thanks for reminding me though. Link to post Share on other sites
RDog 0 Posted March 20, 2007 Share Posted March 20, 2007 cwik1 on Full Tilt PokerCwik1 on PokerStarsI'm shipping you some too. Link to post Share on other sites
Footballguru 0 Posted March 20, 2007 Share Posted March 20, 2007 It says in the comments I left at the top right. Starting bankroll is listed under transactions.sorry. thanks alot. Link to post Share on other sites
cwik 0 Posted April 4, 2007 Author Share Posted April 4, 2007 Hey guys.I made a few changes and added the update on the original post.a. Fix a lot of the columns on the more stats page so they auto-update when you make changes on the info page.b. Added a new column for Cash Games, "number of tables played".c. Also added a table on the More Stats page, that calculates ROI based on number of tables played. This will be useful for multitablers.d. Put the "a" in Tournaments.Let me know if there are any problems. Link to post Share on other sites
SpeedKills 0 Posted April 4, 2007 Share Posted April 4, 2007 Hey guys.I made a few changes and added the update on the original post.a. Fix a lot of the columns on the more stats page so they auto-update when you make changes on the info page.b. Added a new column for Cash Games, "number of tables played".c. Also added a table on the More Stats page, that calculates ROI based on number of tables played. This will be useful for multitablers.d. Put the "a" in Tournaments.Let me know if there are any problems.So does that mean we have to re-enter all our stats?Thanks for updating man. I only play on bodog, so if they ever offer transfers ill transfer you some Link to post Share on other sites
cwik 0 Posted April 4, 2007 Author Share Posted April 4, 2007 So does that mean we have to re-enter all our stats?Thanks for updating man. I only play on bodog, so if they ever offer transfers ill transfer you someI'm not really sure about this. Anyone know a good way to transfer data? I'm thinking it's gonna wanna refer to the old one if you copy/paste. Link to post Share on other sites
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now