|
|
#42
12-12-2004, 05:40 PM
|
|||
|
|||
possible bug?
The spreadsheet is great...except that there seems to be a bug in the ROI/ITM graph of the 50+5 page...on all the other levels, the graph works fine, but on the $50 it doesn't...
anyone else having this problem, and if so, how can I fix it? 
|
|
#44
12-13-2004, 11:06 PM
|
|||
|
|||
|
Re: possible bug?
[ QUOTE ]
on all the other levels, the graph works fine, but on the $50 it doesn't... [/ QUOTE ] I've been looking at it, and I don't think I'm seeing anything out of the ordinary. What is it that makes you say it's not working? What is it doing? Regards Brad S
|
|
#45
12-14-2004, 12:02 AM
|
|||
|
|||
|
Re: New Penultimate 2005 SNG Spreadsheet
[ QUOTE ]
OK. Stupid question. Wouldn't it be easier to have excel figure out what day of the week it is instead of the dropdown menu? =TEXT(WEEKDAY(!REF), "ddd") [/ QUOTE ] Nevermind. I see how it works now. Just more proof that I'm an idiot [img]/images/graemlins/confused.gif[/img]. Thanks for the sheet! Sam
|
|
#46
12-14-2004, 01:22 AM
|
|||
|
|||
|
Re: possible bug?
[ QUOTE ]
[ QUOTE ] on all the other levels, the graph works fine, but on the $50 it doesn't... [/ QUOTE ] I've been looking at it, and I don't think I'm seeing anything out of the ordinary. What is it that makes you say it's not working? What is it doing? Regards Brad S [/ QUOTE ] well, the numbers of my ROI and ITM are fine under the poker summary. It says that I've played 58 SNGs and have an ROI of 43.9% and an ITM of 55.5%....but if I look at the graph, it has the two lines starting at the bottom - SNG #3, actually, and both go basically straight up and BACK a little all the way to the top. Actually, I've noticed that the ROI/ITM graph is messed up in most of the different SNG levels...the profit graph is always fine....I'll try copying and pasting into a new spreadsheet...see if that works. **** I figured it out - I had put in some finishes from when I first started that I didn't have the dates for, so I just left the daets blank - apparently, however, the graph needs dates in order to calulate ROI/ITM for some reason - when I put in dates the graphs all worked. [img]/images/graemlins/laugh.gif[/img]
|
|
#48
12-15-2004, 11:44 AM
|
|||
|
|||
|
Re: New Penultimate 2005 SNG Spreadsheet
Cool spreadsheet--thanks guys I particularly like the idea of day of the week and time of day breakdowns.
My time of day still are divide by 0 errors--is this cause I'm only at 38 tourneys? Also the start importing thing doesn't "launch" anything for me. Is it supposed to? Thanks
|
|
#50
12-15-2004, 01:32 PM
|
|||
|
|||
|
Re: New Penultimate 2005 SNG Spreadsheet
If you don't have any tournys in a time period (eg. 12am to 4am) you will get a #DIV/0 error for that time period.
If you want to use the UI to input data and get the start/stop time stamp, you must enable macros when you open the sheet. If macros are enabled, a dialog box pop open when you click on the button on the spreadsheet. If you are still having trouble with this, PM me your email address.
|
 |
|
|
Linear Mode
