STT/SNG Spreadsheet - a beginners guide - Page 3 - The Punters Lounge

psychosi · 02-01-2007, 15:37

Cheers Damo that's sorted it. Great work.

the croc · 02-01-2007, 17:33

one quick question
i started a new database yesterday,everything looked fine,but when i enter results for today although they add onto the overall bankroll they do not show on the daily winnings for jan 2 it just stays the same,,,any ideas?

<TABLE style="WIDTH: 110pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=146 border=0><COLGROUP><COL style="WIDTH: 110pt; mso-width-source: userset; mso-width-alt: 6229" width=146><TBODY><TR style="HEIGHT: 14.25pt" height=19><TD class=xl67 style="WIDTH: 110pt; HEIGHT: 14.25pt" width=146 height=19>profit by day</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl68 style="HEIGHT: 13.5pt" height=18>yesterday</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl69 style="HEIGHT: 12.75pt" align=right height=17>1-Jan</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl70 style="HEIGHT: 12.75pt" align=right height=17>$1.25 </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl68 style="HEIGHT: 12.75pt" height=17>today</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl69 style="HEIGHT: 12.75pt" align=right height=17>2-Jan</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl71 style="HEIGHT: 13.5pt" align=right height=18>($1.25)</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl68 style="HEIGHT: 13.5pt" height=18>last 7 days</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl70 style="HEIGHT: 12.75pt" align=right height=17>$0.00 </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl68 style="HEIGHT: 12.75pt" height=17>last 14 days</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl71 style="HEIGHT: 13.5pt" align=right height=18>$0.00 </TD></TR></TBODY></TABLE>
the figure in red is actually from yesterday,but had 67.50 in stt games today,it shows on overall bankroll only.

robilaruk · 02-01-2007, 17:40

have you got the correct date in the cell I mentioned earlier?

otherwise it should work fine? have just changed the date on my comp and did a dummy win for jan 3 and it appears fine in the money section

Damo

Quote:

Originally Posted by the croc

one quick question
i started a new database yesterday,everything looked fine,but when i enter results for today although they add onto the overall bankroll they do not show on the daily winnings for jan 2 it just stays the same,,,any ideas?

<TABLE style="WIDTH: 110pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=146 border=0><COLGROUP><COL style="WIDTH: 110pt; mso-width-source: userset; mso-width-alt: 6229" width=146><TBODY><TR style="HEIGHT: 14.25pt" height=19><TD class=xl67 style="WIDTH: 110pt; HEIGHT: 14.25pt" width=146 height=19>profit by day</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl68 style="HEIGHT: 13.5pt" height=18>yesterday</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl69 style="HEIGHT: 12.75pt" align=right height=17>1-Jan</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl70 style="HEIGHT: 12.75pt" align=right height=17>$1.25 </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl68 style="HEIGHT: 12.75pt" height=17>today</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl69 style="HEIGHT: 12.75pt" align=right height=17>2-Jan</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl71 style="HEIGHT: 13.5pt" align=right height=18>($1.25)</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl68 style="HEIGHT: 13.5pt" height=18>last 7 days</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl70 style="HEIGHT: 12.75pt" align=right height=17>$0.00 </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl68 style="HEIGHT: 12.75pt" height=17>last 14 days</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl71 style="HEIGHT: 13.5pt" align=right height=18>$0.00 </TD></TR></TBODY></TABLE>
the figure in red is actually from yesterday,but had 67.50 in stt games today,it shows on overall bankroll only.

psychosi · 02-01-2007, 17:41

Try reading post #38 by Damo in this thread, explains how to rectify it as i had the same problem.

AJ · 02-01-2007, 17:54

I did one of these last year.

For anyone playing STT's with an eye on long term profit, this file is a must

the croc · 02-01-2007, 17:58

Quote:

Originally Posted by psychosi

Try reading post #38 by Damo in this thread, explains how to rectify it as i had the same problem.

cheers psychosi sorted now

psychosi · 02-01-2007, 18:18

Right being a bit picky now but has anyone else got problems with their year graph not showing anything at all??

tipstar · 02-01-2007, 18:24

Nor mine

which cell do you put your bankroll in ?
Cant find one

psychosi · 02-01-2007, 18:27

Bankroll goes in cell C3 in the money tab

tipstar · 02-01-2007, 18:32

cheers wouldnt work before but is now for some reason

robilaruk · 02-01-2007, 19:33

yes - and this time I don't have a clue - have gone into chart options and its picking up the correct range of data but not displaying it?

looks like the pretty picture will be sadly missed......

The Graph: RIP 2007

Damo
ps I am sure some bright spark will figure this out

Quote:

Originally Posted by psychosi

Right being a bit picky now but has anyone else got problems with their year graph not showing anything at all??

Absalon · 09-01-2007, 14:38

Hi,

I actually opened an Account just for this post, but as I was titled "bright spark" i couldn't resist. My ego demands it.

To fix the Prob with the Graph, you have to rightclick the y-Axis (time Axis). Then go to the scaling Tab ("Skalierung" - I'm german. The 2nd Tab anyway) and change the Start and End Date. That's it. I'm a bright spark aint I?

(By the way: You can simply "add on" to your 2006-chart, and create a 2 years graph (or even more years) but to rectify the Prob with the money tab, you then need to add on in the Overall tab (below line 417) and do the same in the differnet "Stats" Tabs and the money tab. - Its quite some work an probably not worth the Trouble, but this way you can create a chart for more than one Year. It's easier to start an new chart, and keep a 2nd one with all your tourneys to see you overall ROI etc.)

Quote:

Originally Posted by robilaruk

ps I am sure some bright spark will figure this out

robilaruk · 09-01-2007, 17:23

EXCELLENT 1st post

welcome to the forum

Damo

[quote=Absalon;682835]Hi,
To fix the Prob with the Graph, you have to rightclick the y-Axis (time Axis). Then go to the scaling Tab ("Skalierung" - I'm german. The 2nd Tab anyway) and change the Start and End Date. That's it. I'm a bright spark aint I?

(By the way: You can simply "add on" to your 2006-chart, and create a 2 years graph (or even more years) but to rectify the Prob with the money

psychosi · 09-01-2007, 18:51

Awesome work Absolon, love that graph and it was sadly missed while it was away. Think i'll just stick to having different graphs for different years tho.

to the forum anyway.

Si

AJ · 09-01-2007, 19:08

I did mean to post and tell you guys that, I fixed it last week.

After eventing I know..................

spireitedaz · 11-02-2007, 14:52

The link doesn't seem to work anymore. Is the spreadsheet available anywhere else ?

I was going to use this for my Sit N Go's and remove them from the Card Player Analyst, so I can see a proper win rate for MTT's only.

robilaruk · 11-02-2007, 15:09

can anyone here host it?
(or doing similarly clever with it?)

I could try and email you it - let me have your addy

Damo

Quote:

Originally Posted by spireitedaz

The link doesn't seem to work anymore. Is the spreadsheet available anywhere else ?

I was going to use this for my Sit N Go's and remove them from the Card Player Analyst, so I can see a proper win rate for MTT's only.

spireitedaz · 11-02-2007, 15:20

Thanks Damo

spireitedaz at hotmail dot com

KevinTHFC · 11-02-2007, 17:26

Now you've done it Damo

could you email me a copy as well please?
kevin at asgard-consulting dot co dot uk

I expect you will get loads of 'me please' type messages

Kevin

Valiant23 · 11-02-2007, 17:28

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

Want me to host it somewhere Damo?

02-01-2007, 15:37	#41 (permalink)
psychosi Poker Punter Join Date: 23 Jan 2006 Location: Leicester Age: 23 Posts: 88	Re: STT/SNG Spreadsheet - a beginners guide Cheers Damo that's sorted it. Great work. __________________ Poker without bad beats just wouldnt be fun www.psychosi.blogspot.com www.myspace.com/si_pettet

02-01-2007, 17:33	#42 (permalink)
the croc God Punter Join Date: 05 May 2006 Posts: 2,612 Awards Showcase Total Awards: 3	Re: STT/SNG Spreadsheet - a beginners guide one quick question i started a new database yesterday,everything looked fine,but when i enter results for today although they add onto the overall bankroll they do not show on the daily winnings for jan 2 it just stays the same,,,any ideas? <TABLE style="WIDTH: 110pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=146 border=0><COLGROUP><COL style="WIDTH: 110pt; mso-width-source: userset; mso-width-alt: 6229" width=146><TBODY><TR style="HEIGHT: 14.25pt" height=19><TD class=xl67 style="WIDTH: 110pt; HEIGHT: 14.25pt" width=146 height=19>profit by day</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl68 style="HEIGHT: 13.5pt" height=18>yesterday</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl69 style="HEIGHT: 12.75pt" align=right height=17>1-Jan</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl70 style="HEIGHT: 12.75pt" align=right height=17>$1.25 </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl68 style="HEIGHT: 12.75pt" height=17>today</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl69 style="HEIGHT: 12.75pt" align=right height=17>2-Jan</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl71 style="HEIGHT: 13.5pt" align=right height=18>($1.25)</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl68 style="HEIGHT: 13.5pt" height=18>last 7 days</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl70 style="HEIGHT: 12.75pt" align=right height=17>$0.00 </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl68 style="HEIGHT: 12.75pt" height=17>last 14 days</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl71 style="HEIGHT: 13.5pt" align=right height=18>$0.00 </TD></TR></TBODY></TABLE> the figure in red is actually from yesterday,but had 67.50 in stt games today,it shows on overall bankroll only. __________________ http://thecrocpl.blogspot.com/ (updated 20th jan) Last edited by the croc; 02-01-2007 at 17:36.

02-01-2007, 17:41	#44 (permalink)
psychosi Poker Punter Join Date: 23 Jan 2006 Location: Leicester Age: 23 Posts: 88	Re: STT/SNG Spreadsheet - a beginners guide Try reading post #38 by Damo in this thread, explains how to rectify it as i had the same problem. __________________ Poker without bad beats just wouldnt be fun www.psychosi.blogspot.com www.myspace.com/si_pettet

02-01-2007, 17:54	#45 (permalink)
AJ Niko Bellic is my homeboy Join Date: 06 Jan 2002 Location: Aotearoa Age: 37 Posts: 9,260 Awards Showcase Total Awards: 2	Re: STT/SNG Spreadsheet - a beginners guide I did one of these last year. For anyone playing STT's with an eye on long term profit, this file is a must __________________ Turns out Accountable and Responsible aren't the same thing......

02-01-2007, 18:18	#47 (permalink)
psychosi Poker Punter Join Date: 23 Jan 2006 Location: Leicester Age: 23 Posts: 88	Re: STT/SNG Spreadsheet - a beginners guide Right being a bit picky now but has anyone else got problems with their year graph not showing anything at all?? __________________ Poker without bad beats just wouldnt be fun www.psychosi.blogspot.com www.myspace.com/si_pettet Last edited by psychosi; 02-01-2007 at 18:19.

02-01-2007, 18:24	#48 (permalink)
tipstar Legendary Punter Join Date: 07 Jan 2001 Posts: 1,856	Re: STT/SNG Spreadsheet - a beginners guide Nor mine which cell do you put your bankroll in ? Cant find one __________________ "Man who catch fly with chopsticks can accomplish anything"-miyagi

02-01-2007, 18:27	#49 (permalink)
psychosi Poker Punter Join Date: 23 Jan 2006 Location: Leicester Age: 23 Posts: 88	Re: STT/SNG Spreadsheet - a beginners guide Bankroll goes in cell C3 in the money tab __________________ Poker without bad beats just wouldnt be fun www.psychosi.blogspot.com www.myspace.com/si_pettet

02-01-2007, 18:32	#50 (permalink)
tipstar Legendary Punter Join Date: 07 Jan 2001 Posts: 1,856	Re: STT/SNG Spreadsheet - a beginners guide cheers wouldnt work before but is now for some reason __________________ "Man who catch fly with chopsticks can accomplish anything"-miyagi

09-01-2007, 17:23	#53 (permalink)
robilaruk God Punter Join Date: 28 Dec 2005 Location: Leicester UK Age: 38 Posts: 3,032	Re: STT/SNG Spreadsheet - a beginners guide EXCELLENT 1st post welcome to the forum Damo [quote=Absalon;682835]Hi, To fix the Prob with the Graph, you have to rightclick the y-Axis (time Axis). Then go to the scaling Tab ("Skalierung" - I'm german. The 2nd Tab anyway) and change the Start and End Date. That's it. I'm a bright spark aint I? (By the way: You can simply "add on" to your 2006-chart, and create a 2 years graph (or even more years) but to rectify the Prob with the money

09-01-2007, 18:51	#54 (permalink)
psychosi Poker Punter Join Date: 23 Jan 2006 Location: Leicester Age: 23 Posts: 88	Re: STT/SNG Spreadsheet - a beginners guide Awesome work Absolon, love that graph and it was sadly missed while it was away. Think i'll just stick to having different graphs for different years tho. to the forum anyway. Si __________________ Poker without bad beats just wouldnt be fun www.psychosi.blogspot.com www.myspace.com/si_pettet

09-01-2007, 19:08	#55 (permalink)
AJ Niko Bellic is my homeboy Join Date: 06 Jan 2002 Location: Aotearoa Age: 37 Posts: 9,260 Awards Showcase Total Awards: 2	Re: STT/SNG Spreadsheet - a beginners guide I did mean to post and tell you guys that, I fixed it last week. After eventing I know.................. __________________ Turns out Accountable and Responsible aren't the same thing......

11-02-2007, 14:52	#56 (permalink)
spireitedaz Dedicated Punter Join Date: 06 Feb 2007 Location: Bolsover, Chesterfield Posts: 259	Re: STT/SNG Spreadsheet - a beginners guide The link doesn't seem to work anymore. Is the spreadsheet available anywhere else ? I was going to use this for my Sit N Go's and remove them from the Card Player Analyst, so I can see a proper win rate for MTT's only. __________________ http://www.spireitedaz.blogspot.com/

11-02-2007, 15:20	#58 (permalink)
spireitedaz Dedicated Punter Join Date: 06 Feb 2007 Location: Bolsover, Chesterfield Posts: 259	Re: STT/SNG Spreadsheet - a beginners guide Thanks Damo spireitedaz at hotmail dot com __________________ http://www.spireitedaz.blogspot.com/

11-02-2007, 17:26	#59 (permalink)
KevinTHFC Seasoned Punter Join Date: 08 Oct 2006 Posts: 311	Re: STT/SNG Spreadsheet - a beginners guide Now you've done it Damo could you email me a copy as well please? kevin at asgard-consulting dot co dot uk I expect you will get loads of 'me please' type messages Kevin

11-02-2007, 17:28	#60 (permalink)
Valiant23 aka Billy Sollox Join Date: 06 Aug 2005 Location: On the road Age: 40 Posts: 12,623	Re: STT/SNG Spreadsheet - a beginners guide I do have the original but I think the calendar would need fixing? Want me to host it somewhere Damo? __________________ You can spend your time alone re digesting past regrets, Or you can come to terms and realize you're the only one who can forgive yourself. Makes much more sense to live in the present tense.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Football Betting Tips	Australian Free Bet Offers HOT	Free Bets HOT	Odds Comparison	BetDevil
Soccer Punter	Free Betting Tips	Free Online Bets	BetPortfolio	SFstats
TotalFootballPredict	1Picks	Footy Yield