STT/SNG Spreadsheet - a beginners guide

[GotaFancy?]

If you upload to rapidshare Damo then you can post the link here and as many as want it can grab it (though the download will disappear after a month without use.....)

[robilaruk]

sure - would be easier - have tried to email it but as I only have a yahoo a/c it goes over the limit allowed (sorry folks)

Damo

re calendar - the fix for that is in an earlier post

Originally Posted by Valiant23

I do have the original but I think the calendar would need fixing?


Want me to host it somewhere Damo?

[spireitedaz]

Bump for a reminder.

Or is it already there ?

No idea what rapidshare is

[Valiant23]

Daz, despite you winning 3-0 last Sat I ain't holding it against you honest.

Send us a PM as a reminder co I'm off to bed now.


But the PM will prompt me for tomorrow.

[Valiant23]

Right I followed the instructions in post #38

and I've uploaded it in Winrar form.

http://rapidshare.com/files/18179442..._2007.rar.html

If you need winrar you can download THAT here;

http://www.download.com/WinRAR/3000-...ml?tag=lst-0-1

[aimar21]

I guess I fcuked up in this one. Once, by mistake I pushed the button twice and it recorded two tournaments at the same time while I was playing one, then I just wrote 3 in the place you finished section only to change it later (for the second one I never played). Then the next game I was 6th and I changed the 3 with 6 but now my bankroll is .30 more in the spreadsheet, what do you think could be wrong?

[GotaFancy?]

You can email me the spreadsheet if you want me to look - plpoker at punterslounge dot com

[aimar21]

I guess it's too big, and it's not so fast here sorry . I just autofilled as 3 after pressing end existing button then manually changed the 3 by 6, what could be wrong it's not such a big move.

[GotaFancy?]

Can you copy and paste the range? Something like this....

55	10-Jun	Su	11:26 AM	1	15
56	10-Jun	Su	1:10 PM	3	18
57	10-Jun	Su	2:44 PM	1	21
58	10-Jun	Su	3:11 PM	4	10
59	10-Jun	Su	3:42 PM	1	18
60	10-Jun	Su	4:52 PM	3	12

[aimar21]

guess it got too big

12	1-Jun	Fr	7:38 PM	2	40
13	2-Jun	Sa	7:22 PM	7	30
14	2-Jun	Sa	7:53 PM	2	59
15	2-Jun	Sa	7:53 PM	6	59
16	3-Jun	Su	11:41 PM	6	41
17	5-Jun	Tu	2:15 PM	5	29

[aimar21]

the 15th one, I just wrote 3 (it was really stupid) and then changed it to 6 later on manually.

[aimar21]

all the calculations add up correct if you're gonna do that. I guess "boss" took .30 cent more from me once. Where should I write that??

Edit: OK, I've just lowered my starting bankroll .30c, no big deal I guess there is nothing wrong with the spreadsheet. Cheers..

[spannerjago]

I suspect it is boss doing an exchange rate adjustment on your account.

Your money is held in their account in £s but you see it in the poker account in the currency of your choice. In my case in $s.

Once a month the adjust the value of the amount held in £s to the current exchange rate and this will adjust the amount held in your poker account.

Hope this makes sense.

[friskyfitz]

Originally Posted by spannerjago

Once a month the adjust the value of the amount held in £s to the current exchange rate and this will adjust the amount held in your poker account.

Hope this makes sense.

Spot on - Thats exactly what happens - noticed it in my account twice and both times were negative

[aimar21]

oh god I knew it

so what do you do in the spreadsheet when that happens? Do you just lower the starting bankroll like I did?

[GotaFancy?]

Originally Posted by spannerjago

I suspect it is boss doing an exchange rate adjustment on your account.

Your money is held in their account in £s but you see it in the poker account in the currency of your choice. In my case in $s.

Once a month the adjust the value of the amount held in £s to the current exchange rate and this will adjust the amount held in your poker account.

Hope this makes sense.

Of course it is

[aimar21]

down from 34.96 to 34.60 without playing any poker. Is there a way to prevent this? And how do you record it in the spreadsheet? do you just lower the bankroll?

[GotaFancy?]

I'd make an adjustment in one of hte columns in the "extras" sheet

I don't think you need to worry about it - If I understand correctly, your balance in your native currency is remaining unchanged .... all that is happening is the amount, as displayed in US$ is changing as the exchange rate changes....

If you watch your balance in your native currency, outside of the poker software, in the sports book, you should see it remain constant I think....

[robilaruk]

Originally Posted by GotaFancy?

I'd make an adjustment in one of hte columns in the "extras" sheet

I don't think you need to worry about it - If I understand correctly, your balance in your native currency is remaining unchanged .... all that is happening is the amount, as displayed in US$ is changing as the exchange rate changes....

If you watch your balance in your native currency, outside of the poker software, in the sports book, you should see it remain constant I think....

correct

Damo

[aimar21]

of course, I know I won't lose any money but I just asked because of the spreadsheet. thank you both mates, I will try the extra section