Statistics / Keeping Records

[Rusty]

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!

[Graham C]

do you have a link for your spreadsheet please?

[moritzey]

Here:

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.

[Jim-D]

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?

[feedthegoat]

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

[Jim-D]

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

Help needed please

[attachment deleted by admin]

[CelticGeezeer]

I would download it and start again

[CelticGeezeer]

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

[moritzey]

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..

[Decider]

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

[moritzey]

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.

[Decider]

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

[Decider]

Here:

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.

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:

No more questions hopefully,

Cheers.

Eoan

[moritzey]

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..

[Decider]

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