blonde poker forum

Hey,

downloaded that SNG spreadsheet from 2+2 a few days ago, and only just realised how much I like it. Was using pokerdroid.com up to now to keep track of my poker, but I find that spreadsheet so much better. And (as it's only
got the data of the last three days) it tells me I have an overall ROI of 51% :)
Is anyone else using that file to keep track of their poker or what do you guys use? Just curious, as I've been looking
for a good free alternative to pokerdroid for a while and the only other one I found (pokerdominator?) I didn't like very
much, either.

www.pokercharts.com (http://www.pokercharts.com) $19 P/A

www.pokertracker.com (http://www.pokertracker.com) $55

I use this  http://www.chrishalverson.com/poker/spreadsheet/ its free and quite comprehensive.

Just had a look at that one. It seems to round values to the nearest $, though, which is a bit irritating with my WH 3+.60 and 5+.50 game. Also you don't seem to be able to pre-define SNG's, which is quite handy. Think I'll stick to the 2+2 one, just quite like looking at graphs a lot, too, so that one is pretty perfect for me ;)

I found the rounding irritating and I may address it if I can be bothered. I like it because of the multiple sites option and the ability to track cash, tourneys and sng's.

I have my own spreadsheet which tracks money credited to poker sites and money debited. That's it! +/- I also do one for live poker and then total the two.

I don't like to over analyse my play. This is a hobby and should remain fun as long as I remain in the black!

I bet I'm not alone...

and remember this is just a forum and just an opinion!

I use one from 2+2 too, not sure if it's the same as yours or not but it's good for me.

Sure, there's no need to over analyse, but being a bit of a mathmo, I find graphs quite attractive to look at in a weird way, and it increases the fun I have in poker rather than the not. That said, even though poker is just a hobby, why not try to do well at it? Using stats to find my right level to play at, the right time of day (it seems I play best between 11pm and 3am and also three hours after getting up) is quite useful for that, I believe.
Fair enough, if you never had any problems staying in the black and are not too bothered about actual figures. In my case, I was a loosing player until recently, and _know_ that analysing my play helped me turn my game around.

Silo: I use version 2.7f (says so in the Readme tab).

I use www.checkyourbets.com

It's really basic which is the best thing about it. All you do it click start and click on your game type then when you're finished click end and your amount of winnings. Superbly easy and it's free.

If you want more in depth stuff though it's probably not for you.

I've been in the black since week 6. Week 180odd now. If you play small but win one or two MTT's your balance sheet looks great!

I've got a very detailed spreadsheet that tracks my play, bonuses, etc and also keeps a running total of my balance at each site and my bankroll by currency.  I'd recommend people keeping an eye on this as I've had more than one discrepancy in the past where sites have made errors with funds!!

The main spreadsheet then links into other spreadsheets which analyse the data into whichever form I want.

It does a great job, but the files eventually get huge.  My intention is to get the same functionality into an Access database which will be a much slicker way of doing the same thing, but my Access skills aren't yet a match for my Excel skills!

I also use Poker Tracker for the session history but this isn't 100% compatible everywhere, discrepancies sometimes occur and, of course, it doesn't track live play so I wouldn't rely on it totally.

Sheriff

I am very low-tech; I keep a little black notebook next to my PC into which all of my results go.

At the end of the month I crunch the numbers and see where my money actually went...  :D

Every now and again I get little surprises - I expected to be slightly in the red last month, for example, but when I added everything up I was ever-so-slightly in the black (in fact, I was perfectly breaking even on the 31st and got a good result which pushed me up over the line).

I kept a spreadsheet record for one month, some time ago - but kept forgetting to input the results; the notebook gets instant updates ( as well as chip counts on every level, and notes on critical hands played, etc.)

An Access database does sound very slick. Might look into that, too, at some point, although my access skills would probably be restricted to googling for someone generously offering their own database to use, abuse and improve. Meh, and I'm meant to be a politics and computer science student, oh well ...

mmm, It is a different one then  - mine doesn't have a version number!

I'm using the same spread sheet as u moritzey, i love it. Well i did love it last week when i was winning a lot with over 50%ROI but it keeps telling me I'm losing a lot of money this week i don't know whats going wrong, either i was getting very lucky last week and im a bad player or im just getting unlucky this week and im a good player, i hope its the latter.

I love the graphs too, easy to read and to follow how your playing. Good stuff!

do you have a link for your spreadsheet please?

Here:

http://www.bluefeetpoker.com/2p2SNGspreadsheet.zip (http://www.bluefeetpoker.com/2p2SNGspreadsheet.zip)

You will want to change the SNG tabs to match your own games, and in my case I needed
to adjust the times in the lookup tab, on the very left to match the Morning/Afternoon/Night .. setting.
If you don't know what I mean/how to do it after looking at it, let me know and I'll post a detailed
instructions.

i downloaded the spreadsheet but when i went to open it i had a warning come up saying "This file contains macros which can contain harmfull virusus, Do you wish to open"

Is it ok to open?

Yes it is safe to open.
I have been using it for a while with no problems.

when i try to start a new session i get directed to this page..

Help needed please

[attachment deleted by admin]

I would download it and start again

I have just found this MTT spread sheet on 2+2 at  http://www.our2centz.com/poker/MTT_Spreadsheet_BLANK.xls

Jim-D, have you got it working now? Didn't have that problem myself, but if it's still not working, I can have a look at the sourcecode and try to figure what causes that error..

Moritzey,

I downloaded the spreadsheet and I'm pretty impressed by it. Got a question for you.

I'm using the SNG1 page and checking results on STATS1 page, everything looks ok except the Multitable Utilization. STATS1 page in field F1466 is using the following calculation: =SUM(SNG1!Y12) - in an attempt to work out how many real minutes you have been playing for. But looking at SNG1, there isn't a Y column, never mind a Y12 field.

Are you seeing this issue? I have version 2.7f also. I have checked the other SNG pages and none of them have the Y column, so problem will affect all STATS Multitable Utilization pages.

It means my #hrs and $/hr stats are missing - which I kinda wanted to see.

I haven't switched the macros on, I'm happy manually updating my results and I think they are only there for importing stats.

Cheers,

Eoan

Column Y exists, you just can't see it. If you look at the columns between T and AB, there is a slightly thicker line, you can expand that to look at the hidden columns, but I don't think you will need them to get the multitable utilization, it works fine for me.
Do you enter data/time and duration? I think these fields will be used to calculate the stats you are missing. If you enable macros, you can use the "Start Tournaments" button, which I find quite handy - you chose which level you are playing and in the end just click a button and enter where you placed. Calculates date/duration etc automatically.
If you already entered duration date and time, I'm not sure where your problem comes from, maybe take a screenshot of your two pages if you still have the same problem.

Hello,

Found the missing columns cheers.

Had a look and noticed that the value of V15 was set to (=#REF + C15) whereas the other V fields were (=E16+C16) etc... this was skewing up the results of all other fields. I think it's probably because of manual editing.

Set it to (=E15+C15) and it's got values now...

Also turned on the macro, and tested the "Start Recording Tournaments" button, that's pretty neat, and will save me a bit of typing and working out times.

Noticed that if you enter a tourney in one row, with a later start time than a tourney in the next row it skews up the total poker time results, so from now on I'll use the "Start Recording Tournaments" button so I don't need to think about it too much.

I don't know if I want to go as far as importing the stats, I'll work with it without for now.

Thanks for your help,

Eoan

Did you change the times to match UK times? They look like they are set for importing from a different timezone.

Is it the times in column A and B you modified? Not the ones in E/F and HI?

Final Question

Did you leave the 2 Night entries? e.g., A1:C1 & A7:C7

No more questions hopefully,

Cheers.

Eoan

Hey,

I changed the times in cols A and B, left the others as they were. Got rid of row 7, so only one night entry, but
it seems to work either way (having two night entries or not).

Not sure what you mean with UK times - just changed them to the ones described in the Readme, think that's independent of timezone/depends on the time your computer is set to.
Haven't actually used the import function myself, so I'm not sure what the entries on columns E,F,H,I are good
for, I think it might have something to do with that..

Thanks for your help, I'm sure the times are currently set for importing tournaments from stars.

I'll change them to UK - good to know removing that row is not a problem.

Cheers,

Eoan