robilaruk Posted July 5, 2006 Author Share Posted July 5, 2006 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 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. :\ Quote Link to comment Share on other sites More sharing options...
DAC Posted July 22, 2006 Share Posted July 22, 2006 Re: STT/SNG Spreadsheet - a beginners guide Thanks for this mate - I hate spreadsheets but am going to give this a go, thanks again. Quote Link to comment Share on other sites More sharing options...
psychosi Posted January 2, 2007 Share Posted January 2, 2007 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. Quote Link to comment Share on other sites More sharing options...
robilaruk Posted January 2, 2007 Author Share Posted January 2, 2007 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 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. Quote Link to comment Share on other sites More sharing options...
psychosi Posted January 2, 2007 Share Posted January 2, 2007 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? Quote Link to comment Share on other sites More sharing options...
GaF Posted January 2, 2007 Share Posted January 2, 2007 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" :ok Quote Link to comment Share on other sites More sharing options...
psychosi Posted January 2, 2007 Share Posted January 2, 2007 Re: STT/SNG Spreadsheet - a beginners guide Cheers Gaf found it now. Quote Link to comment Share on other sites More sharing options...
robilaruk Posted January 2, 2007 Author Share Posted January 2, 2007 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 Quote Link to comment Share on other sites More sharing options...
Penelopeys Posted January 2, 2007 Share Posted January 2, 2007 Re: STT/SNG Spreadsheet - a beginners guide Excellent work Damo :clap :clap Will try it out myself when I get some more time on my hands :ok Quote Link to comment Share on other sites More sharing options...
Hodgey Posted January 2, 2007 Share Posted January 2, 2007 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 Mine appears to be working without updating that date. :unsure Edit: I see the problem is with the money tab. I don't use that tab. :) Quote Link to comment Share on other sites More sharing options...
psychosi Posted January 2, 2007 Share Posted January 2, 2007 Re: STT/SNG Spreadsheet - a beginners guide Cheers Damo that's sorted it. Great work. Quote Link to comment Share on other sites More sharing options...
the croc Posted January 2, 2007 Share Posted January 2, 2007 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? profit by dayyesterday1-Jan$1.25 today2-Jan($1.25)last 7 days$0.00 last 14 days$0.00 the figure in red is actually from yesterday,but had 67.50 in stt games today,it shows on overall bankroll only. Quote Link to comment Share on other sites More sharing options...
robilaruk Posted January 2, 2007 Author Share Posted January 2, 2007 Re: STT/SNG Spreadsheet - a beginners guide 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 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? profit by dayyesterday1-Jan$1.25 today2-Jan($1.25)last 7 days$0.00 last 14 days$0.00 the figure in red is actually from yesterday,but had 67.50 in stt games today,it shows on overall bankroll only. Quote Link to comment Share on other sites More sharing options...
psychosi Posted January 2, 2007 Share Posted January 2, 2007 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. Quote Link to comment Share on other sites More sharing options...
AJ Posted January 2, 2007 Share Posted January 2, 2007 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 Quote Link to comment Share on other sites More sharing options...
the croc Posted January 2, 2007 Share Posted January 2, 2007 Re: STT/SNG Spreadsheet - a beginners guide Try reading post #38 by Damo in this thread' date=' explains how to rectify it as i had the same problem.[/quote'] cheers psychosi sorted now :ok Quote Link to comment Share on other sites More sharing options...
psychosi Posted January 2, 2007 Share Posted January 2, 2007 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?? Quote Link to comment Share on other sites More sharing options...
tipstar Posted January 2, 2007 Share Posted January 2, 2007 Re: STT/SNG Spreadsheet - a beginners guide Nor mine which cell do you put your bankroll in ? Cant find one :$ Quote Link to comment Share on other sites More sharing options...
psychosi Posted January 2, 2007 Share Posted January 2, 2007 Re: STT/SNG Spreadsheet - a beginners guide Bankroll goes in cell C3 in the money tab Quote Link to comment Share on other sites More sharing options...
tipstar Posted January 2, 2007 Share Posted January 2, 2007 Re: STT/SNG Spreadsheet - a beginners guide cheers wouldnt work before but is now for some reason Quote Link to comment Share on other sites More sharing options...
robilaruk Posted January 2, 2007 Author Share Posted January 2, 2007 Re: STT/SNG Spreadsheet - a beginners guide 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......:sad The Graph: RIP 2007 ;) Damo ps I am sure some bright spark will figure this out :ok Right being a bit picky now but has anyone else got problems with their year graph not showing anything at all?? Quote Link to comment Share on other sites More sharing options...
Absalon Posted January 9, 2007 Share Posted January 9, 2007 Re: STT/SNG Spreadsheet - a beginners guide 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. :loon 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? :tongue2 (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.) ps I am sure some bright spark will figure this out :ok Quote Link to comment Share on other sites More sharing options...
robilaruk Posted January 9, 2007 Author Share Posted January 9, 2007 Re: STT/SNG Spreadsheet - a beginners guide EXCELLENT 1st post :clap welcome to the forum :) Damo 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? :tongue2 (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 Quote Link to comment Share on other sites More sharing options...
psychosi Posted January 9, 2007 Share Posted January 9, 2007 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. :welcome to the forum anyway. Si Quote Link to comment Share on other sites More sharing options...
AJ Posted January 9, 2007 Share Posted January 9, 2007 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.................. Quote Link to comment Share on other sites More sharing options...
spireitedaz Posted February 11, 2007 Share Posted February 11, 2007 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. Quote Link to comment Share on other sites More sharing options...
robilaruk Posted February 11, 2007 Author Share Posted February 11, 2007 Re: STT/SNG Spreadsheet - a beginners guide can anyone here host it? (or doing similarly clever with it?) I could try and email you it - let me have your addy Damo 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. Quote Link to comment Share on other sites More sharing options...
spireitedaz Posted February 11, 2007 Share Posted February 11, 2007 Re: STT/SNG Spreadsheet - a beginners guide Thanks Damo spireitedaz at hotmail dot com Quote Link to comment Share on other sites More sharing options...
KevinTHFC Posted February 11, 2007 Share Posted February 11, 2007 Re: STT/SNG Spreadsheet - a beginners guide Now you've done it Damo:rollin 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:lol Kevin Quote Link to comment Share on other sites More sharing options...
Valiant23 Posted February 11, 2007 Share Posted February 11, 2007 Re: STT/SNG Spreadsheet - a beginners guide I do have the original but I think the calendar would need fixing? :unsure Want me to host it somewhere Damo? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.