Free £50 Bet!
Bet £25 Get £25 - Code: FTB125
Free £50 Bet!

In association with Sports-Punter Free Bets Odds Comparison BetHelp Limso

We are the Official Forum of FCBet.com


Sports News Sports Stats Live Scores OddsChecker Place Bets Suggest a Site


Go Back   The Punters Lounge - The World's Best Betting Forum > Poker @ PL > Poker Strategy Forum

Poker Strategy Forum Want advice on your play? Want to discuss hand historys and get opinions on how you played them? Here's where you do it. Sponsored by PokerTrillion

UK & Irish Football Forum | Western European Football Forum | UEFA Cup & Champions League Football Forum | International Football Forum | Eastern & Southern European Football Forum | Nordic & Scandinavian Football Forum | Non European Football Forum | Euro 2008 Forum | At The Races Forum | At The Races Systems Forum | Other Sports Forum | USA Sports Forum | Fantasy & Fun Comps Forum | Free Bets Forum | Systems & Strategy Forum | Glory Hunter's Forum | Tipster's Challenge Forum | Daily Racing Comp Forum | Euro & Worldwide Comp Forum | Poker Tourneys Forum | Poker Strategy Forum | Poker Chat Forum | Poker Live Forum | e-Sport Poker League Forum | Bookmakers & Exchanges Forum | Punter's Tools/Betting Help Forum | General Chat Forum | Big Brother 9 Forum | Tech & Gaming Forum | Sports Banter Forum | Live Sports Feeds Forum

Reply
 
Thread Tools Display Modes
Old 05-07-2006, 18:25   #21 (permalink)
Legendary Punter
 
Masterplan's Avatar
 
Join Date: 08 Feb 2006
Posts: 1,315
Default Re: STT/SNG Spreadsheet - a beginners guide

thanks for this guide, decided to start trying stt's a bit more to improve my final table mtt performance(hopefully) just played 8 before dinner.
$2 9 seat tribeca(VictorC)
ROI 73.9%
ITM 50%
__________________
www.allinpokerblog.co.uk
Masterplan is offline   Reply With Quote
Old 05-07-2006, 18:51   #22 (permalink)
Legendary Punter
 
Masterplan's Avatar
 
Join Date: 08 Feb 2006
Posts: 1,315
Default Re: STT/SNG Spreadsheet - a beginners guide

Quote:
Originally Posted by GotaFancy?
I've noticed some rather strange definitions of times (probably from a Time Zone conversion somewhere?) - for example, Afternoon is defined as 9am to 1pm!!! (at least on my version)

Have changed the "Lookup" sheet to the details below to correct this....

<table style="width: 503pt; border-collapse: collapse;" x:str="" border="0" cellpadding="0" cellspacing="0" width="670"><colgroup><col style="width: 63pt;" width="84"><col style="width: 42pt;" span="2" width="56"><col style="width: 69pt;" width="92"><col style="width: 77pt;" width="102"><col style="width: 42pt;" span="5" width="56"></colgroup><tbody><tr style="height: 11.25pt;" height="15"><td class="xl25" style="border: 0.5pt solid windowtext; width: 63pt; height: 11.25pt; background-color: transparent;" x:num="0" align="right" height="15" width="84">12:00 AM</td><td class="xl25" style="border-style: solid solid solid none; border-color: windowtext; border-width: 0.5pt 0.5pt 0.5pt medium; width: 42pt; background-color: transparent;" x:num="4.1666666666666664E-2" align="right" width="56">1:00 AM</td><td class="xl24" style="border-style: solid solid solid none; border-color: windowtext; border-width: 0.5pt 0.5pt 0.5pt medium; width: 42pt; background-color: transparent;" width="56">E</td><td class="xl24" style="border-style: solid solid solid none; border-color: windowtext; border-width: 0.5pt 0.5pt 0.5pt medium; width: 69pt; background-color: transparent;" width="92"></td><td class="xl26" style="border-style: solid solid solid none; border-color: windowtext; border-width: 0.5pt 0.5pt 0.5pt medium; width: 77pt; background-color: transparent;" x:num="0" align="right" width="102">12:00 AM</td><td class="xl26" style="border-style: solid solid solid none; border-color: windowtext; border-width: 0.5pt 0.5pt 0.5pt medium; width: 42pt; background-color: transparent;" x:num="0.16666666666666666" align="right" width="56">4:00 AM</td><td class="xl24" style="border-style: solid solid solid none; border-color: windowtext; border-width: 0.5pt 0.5pt 0.5pt medium; width: 42pt; background-color: transparent;" width="56"></td><td class="xl25" style="border-style: solid solid solid none; border-color: windowtext; border-width: 0.5pt 0.5pt 0.5pt medium; width: 42pt; background-color: transparent;" x:num="0" align="right" width="56">12:00 AM</td><td class="xl25" style="border-style: solid solid solid none; border-color: windowtext; border-width: 0.5pt 0.5pt 0.5pt medium; width: 42pt; background-color: transparent;" x:num="4.1666666666666664E-2" align="right" width="56">1:00 AM</td><td class="xl24" style="border-style: solid solid solid none; border-color: windowtext; border-width: 0.5pt 0.5pt 0.5pt medium; width: 42pt; background-color: transparent;" width="56">E</td></tr><tr style="height: 11.25pt;" height="15"><td class="xl26" style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; height: 11.25pt; background-color: transparent;" x:num="4.1666666666666664E-2" align="right" height="15">1:00 AM</td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0.20833333333333334" align="right">5:00 AM</td><td class="xl24" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;">N</td><td class="xl24" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;"></td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0.16666666666666666" align="right">4:00 AM</td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0.33333333333333331" align="right">8:00 AM</td><td class="xl24" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;"></td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="4.1666666666666664E-2" align="right">1:00 AM</td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0.20833333333333334" align="right">5:00 AM</td><td class="xl24" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;">N</td></tr><tr style="height: 11.25pt;" height="15"><td class="xl26" style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; height: 11.25pt; background-color: transparent;" x:num="0.20833333333333334" align="right" height="15">5:00 AM</td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0.375" align="right">9:00 AM</td><td class="xl24" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;">M</td><td class="xl24" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;"></td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0.33333333333333331" align="right">8:00 AM</td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0.5" align="right">12:00 PM</td><td class="xl24" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;"></td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0.20833333333333334" align="right">5:00 AM</td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0.375" align="right">9:00 AM</td><td class="xl24" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;">M</td></tr><tr style="height: 11.25pt;" height="15"><td class="xl26" style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; height: 11.25pt; background-color: transparent;" x:num="0.375" align="right" height="15">9:00 AM</td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0.54166666666666663" align="right">1:00 PM</td><td class="xl24" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;">F</td><td class="xl24" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;"></td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;"></td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;"></td><td class="xl24" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;"></td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0.375" align="right">9:00 AM</td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0.54166666666666663" align="right">1:00 PM</td><td class="xl24" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;">F</td></tr><tr style="height: 11.25pt;" height="15"><td class="xl26" style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; height: 11.25pt; background-color: transparent;" x:num="0.54166666666666663" align="right" height="15">1:00 PM</td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0.70833333333333337" align="right">5:00 PM</td><td class="xl24" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;">A</td><td class="xl24" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;"></td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0.5" align="right">12:00 PM</td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0.66666666666666663" align="right">4:00 PM</td><td class="xl24" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;"></td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0.54166666666666663" align="right">1:00 PM</td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0.70833333333333337" align="right">5:00 PM</td><td class="xl24" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;">A</td></tr><tr style="height: 11.25pt;" height="15"><td class="xl26" style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; height: 11.25pt; background-color: transparent;" x:num="0.70833333333333337" align="right" height="15">5:00 PM</td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0.875" align="right">9:00 PM</td><td class="xl24" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;">D</td><td class="xl24" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;"></td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0.66666666666666663" align="right">4:00 PM</td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0.83333333333333337" align="right">8:00 PM</td><td class="xl24" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;"></td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0.70833333333333337" align="right">5:00 PM</td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0.875" align="right">9:00 PM</td><td class="xl24" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;">D</td></tr><tr style="height: 11.25pt;" height="15"><td class="xl26" style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; height: 11.25pt; background-color: transparent;" x:num="0.875" align="right" height="15">9:00 PM</td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0" align="right">12:00 AM</td><td class="xl24" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;">E</td><td class="xl24" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;"></td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0.83333333333333337" align="right">8:00 PM</td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0" align="right">12:00 AM</td><td class="xl24" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;"></td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0.875" align="right">9:00 PM</td><td class="xl26" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" x:num="0" align="right">12:00 AM</td><td class="xl24" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;">E</td></tr></tbody></table>
changed mine also, used NNMFADE though
__________________
www.allinpokerblog.co.uk
Masterplan is offline   Reply With Quote
Old 05-07-2006, 18:57   #23 (permalink)
Asst Administrator
 
GotaFancy?'s Avatar
 
Join Date: 18 Jun 2005
Posts: 32,308
Awards Showcase
Tipsters Challenge Oscars Poker Monthly League Champion BPP 
Total Awards: 4
Default Re: STT/SNG Spreadsheet - a beginners guide

Quote:
Originally Posted by Masterplan
changed mine also, used NNMFADE though
That'll make your evening session 3 hours and your night session 5 hours - instead of all being 4 hours - not that it makes any difference.......
GotaFancy? is offline   Reply With Quote
Old 05-07-2006, 19:01   #24 (permalink)
Legendary Punter
 
Masterplan's Avatar
 
Join Date: 08 Feb 2006
Posts: 1,315
Default Re: STT/SNG Spreadsheet - a beginners guide

yeah its more for my benefit rather than pure statistics.
__________________
www.allinpokerblog.co.uk
Masterplan is offline   Reply With Quote
Old 05-07-2006, 19:03   #25 (permalink)
Legendary Punter
 
daftpegasus's Avatar
 
Join Date: 06 Jul 2005
Age: 36
Posts: 1,268
Default Re: STT/SNG Spreadsheet - a beginners guide

Quote:
Originally Posted by GotaFancy?
Have you entered your opening bankroll in cell C3 on the Money tab? If you haven't, that would significantly increase your ROR.....
I have, however I've also entered all my different bankrolls on all the different sites where I've deposited, in cells C4 onwards which I'm not sure the spreadsheet really liked.

To me the most important bits are profit, and what games I get the best results from which is all still there despite having a very worrying ROR figure.

I need to play a lot mor STT's before I really start to panic about it. i think because I've only played 5 and am slightly down in profit on them it is throwing out this figure. Just need to win a few and get back in STT profit!
daftpegasus is offline   Reply With Quote
Old 05-07-2006, 19:19   #26 (permalink)
aka Billy Sollox
 
Valiant23's Avatar
 
Join Date: 06 Aug 2005
Location: On the road
Age: 40
Posts: 12,623
Default Re: STT/SNG Spreadsheet - a beginners guide

Personally I use the original as a template, then duplicate it for each site I use.
__________________
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.
Valiant23 is offline   Reply With Quote
Old 05-07-2006, 19:33   #27 (permalink)
Legendary Punter
 
daftpegasus's Avatar
 
Join Date: 06 Jul 2005
Age: 36
Posts: 1,268
Default Re: STT/SNG Spreadsheet - a beginners guide

Quote:
Originally Posted by Valiant23
Personally I use the original as a template, then duplicate it for each site I use.
That's a good idea, although now I need to enter all the data again

Still it's worth it.
daftpegasus is offline   Reply With Quote
Old 05-07-2006, 19:34   #28 (permalink)
Asst Administrator
 
GotaFancy?'s Avatar
 
Join Date: 18 Jun 2005
Posts: 32,308
Awards Showcase
Tipsters Challenge Oscars Poker Monthly League Champion BPP 
Total Awards: 4
Default Re: STT/SNG Spreadsheet - a beginners guide

Quote:
Originally Posted by Valiant23
Personally I use the original as a template, then duplicate it for each site I use.
me too
GotaFancy? is offline   Reply With Quote
Old 05-07-2006, 19:39   #29 (permalink)
God Punter
 
robilaruk's Avatar
 
Join Date: 28 Dec 2005
Location: Leicester UK
Age: 38
Posts: 3,032
Default Re: STT/SNG Spreadsheet - a beginners guide

if you are only interested in a running total, then I can't see the problem with multiple sites on the same spreadsheet - however, it wont show which sites are profitable for you and does skew the figs (as your bankroll will be disproportionate to the buy-ins)

You might actually be break even at one site and think you are great, and not so good at other but actually doing quite well.

I would chose the option of separate spreadsheets for each site and see where your long term value is

Just my thoughts

Damo

Last edited by robilaruk; 05-07-2006 at 19:40.
robilaruk is offline   Reply With Quote
Old 05-07-2006, 19:41   #30 (permalink)
aka Billy Sollox
 
Valiant23's Avatar
 
Join Date: 06 Aug 2005
Location: On the road
Age: 40
Posts: 12,623
Default Re: STT/SNG Spreadsheet - a beginners guide

Arrgh!

Forgot to add that it doesn't like it if you are multi-tableing using 2 sites and 2 sheets. I cocked up when I was playing Sp odds and Pokerstars at the same time, and had to restart both from scratch.
__________________
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.
Valiant23 is offline   Reply With Quote
Old 05-07-2006, 19:56   #31 (permalink)
God Punter
 
robilaruk's Avatar
 
Join Date: 28 Dec 2005
Location: Leicester UK
Age: 38
Posts: 3,032
Default Re: STT/SNG Spreadsheet - a beginners guide

that shouldn't make a difference unless you attempt to shut down excel completely

There is a lag when the sheet autosaves and it looks like it has crashed - but it should run both files at the same time

unless your RAM is low and is struggling to run 2 poker sites and two open files and your firewall and your antivirus and etc etc etc

That might cause the crash as the 'puter can't cope?

Damo

Quote:
Originally Posted by Valiant23
Arrgh!

Forgot to add that it doesn't like it if you are multi-tableing using 2 sites and 2 sheets. I cocked up when I was playing Sp odds and Pokerstars at the same time, and had to restart both from scratch.
robilaruk is offline   Reply With Quote
Old 22-07-2006, 09:53   #32 (permalink)
DAC
Legendary Punter
 
DAC's Avatar
 
Join Date: 08 Mar 2005
Age: 37
Posts: 1,294
Default Re: STT/SNG Spreadsheet - a beginners guide

Thanks for this mate - I hate spreadsheets but am going to give this a go, thanks again.
__________________
Come Visit My Blog:

http://bettingonice-part2.blogspot.com/
DAC is offline   Reply With Quote
Old 02-01-2007, 10:35   #33 (permalink)
Poker Punter
 
Join Date: 23 Jan 2006
Location: Leicester
Age: 23
Posts: 88
Default Re: STT/SNG Spreadsheet - a beginners guide

Right i've recently started using this poker spreadsheet to record my results and it worked fine until yesterday (any coincidence that its the 1st day of a new year). The stats still record fine but the money tab no longer has details of any winnings from today (cell N27) or yesterday (N24). Also the winnings for January dont show either but everything else is fine. If anyone else has had similar problems or knows how to fix this help would be much appreciated.
__________________
Poker without bad beats just wouldnt be fun
www.psychosi.blogspot.com www.myspace.com/si_pettet
psychosi is offline   Reply With Quote
Old 02-01-2007, 11:09   #34 (permalink)
God Punter
 
robilaruk's Avatar
 
Join Date: 28 Dec 2005
Location: Leicester UK
Age: 38
Posts: 3,032
Default Re: STT/SNG Spreadsheet - a beginners guide

good point - haven't noticed this before - just ran a test win and it doesn't update

I am assuming it has something to do with the date - how you fix it you need to ask a clever person (maybe try the tech forum?)

otherwise if you have the original (you did make a copy as soon as you d/l it didn't you?) intact then i would simply begin again for 2007

Damo


Quote:
Originally Posted by psychosi View Post
Right i've recently started using this poker spreadsheet to record my results and it worked fine until yesterday (any coincidence that its the 1st day of a new year). The stats still record fine but the money tab no longer has details of any winnings from today (cell N27) or yesterday (N24). Also the winnings for January dont show either but everything else is fine. If anyone else has had similar problems or knows how to fix this help would be much appreciated.
robilaruk is offline   Reply With Quote
Old 02-01-2007, 11:40   #35 (permalink)
Poker Punter
 
Join Date: 23 Jan 2006
Location: Leicester
Age: 23
Posts: 88
Default Re: STT/SNG Spreadsheet - a beginners guide

Just tried it again on the original and got the same result. Where's this tech forum you mentioned?
__________________
Poker without bad beats just wouldnt be fun
www.psychosi.blogspot.com www.myspace.com/si_pettet
psychosi is offline   Reply With Quote
Old 02-01-2007, 11:51   #36 (permalink)
Asst Administrator
 
GotaFancy?'s Avatar
 
Join Date: 18 Jun 2005
Posts: 32,308
Awards Showcase
Tipsters Challenge Oscars Poker Monthly League Champion BPP 
Total Awards: 4
Default Re: STT/SNG Spreadsheet - a beginners guide

Near the top you should have a list of links

UK & Irish Football | Western European Football | UEFA Cup & Champions League Football | International Football | Eastern & Southern European Football | Nordic & Scandinavian Football | Non European Football | At The Races | Other Sports | USA Sports | Fantasy & Fun Comps | Free Bets & Bonuses | Systems & Strategy | Glory Hunter's Forum | Tipster's Challenge | Daily Racing Comp | Euro & Worldwide Comp | Poker Forums | Bookies & Exchanges | Punter's Tools/Betting Help | General Chat | Tech & Gaming Forum | Sports Banter | PL Oscars

These are all of the different parts of PuntersLounge - one of them is "Tech and Gaming Forum"
GotaFancy? is offline   Reply With Quote
Old 02-01-2007, 11:53   #37 (permalink)
Poker Punter
 
Join Date: 23 Jan 2006
Location: Leicester
Age: 23
Posts: 88
Default Re: STT/SNG Spreadsheet - a beginners guide

Cheers Gaf found it now.
__________________
Poker without bad beats just wouldnt be fun
www.psychosi.blogspot.com www.myspace.com/si_pettet
psychosi is offline   Reply With Quote
Old 02-01-2007, 13:13   #38 (permalink)
God Punter
 
robilaruk's Avatar
 
Join Date: 28 Dec 2005
Location: Leicester UK
Age: 38
Posts: 3,032
Default Re: STT/SNG Spreadsheet - a beginners guide

sorted

go to the overall tab

cell L57

input start date as 1/1/07

save

it then recalcs any from today or yesterday - I would guess that you need a clean sheet for each year

HTH

Damo
robilaruk is offline   Reply With Quote
Old 02-01-2007, 15:13   #39 (permalink)
Space Cowgirl
 
Penelopeys's Avatar
 
Join Date: 23 Jan 2006
Location: Copenhagen
Age: 31
Posts: 5,991
Default Re: STT/SNG Spreadsheet - a beginners guide

Excellent work Damo

Will try it out myself when I get some more time on my hands
__________________
"I'm sorry, did I break your concentration?"
Penelopeys is offline   Reply With Quote
Old 02-01-2007, 15:16   #40 (permalink)
129 not out!
 
Hodgey's Avatar
 
Join Date: 29 Aug 2002
Location: Essex
Age: 32
Posts: 5,925
Default Re: STT/SNG Spreadsheet - a beginners guide

Quote:
Originally Posted by robilaruk View Post
sorted

go to the overall tab

cell L57

input start date as 1/1/07

save

it then recalcs any from today or yesterday - I would guess that you need a clean sheet for each year

HTH

Damo
Mine appears to be working without updating that date.

Edit: I see the problem is with the money tab. I don't use that tab.
__________________
http://sleekshot.blogspot.com/