L. Marcus Posted March 18, 2011 Report Share Posted March 18, 2011 Re: Longest Running Thread EVER Or its sister city. Quote Link to comment Share on other sites More sharing options...
Tim Posted March 18, 2011 Report Share Posted March 18, 2011 Re: Longest Running Thread EVER O'R'Lyeh? Quote Link to comment Share on other sites More sharing options...
SteveZilla Posted March 19, 2011 Report Share Posted March 19, 2011 Re: Longest Running Thread EVER Yah! Quote Link to comment Share on other sites More sharing options...
SteveZilla Posted March 19, 2011 Report Share Posted March 19, 2011 Re: Longest Running Thread EVER Hasbro & Jagex Announce Transformers MMO http://www.tweaktown.com/news/19092/hasbro_jagex_announce_transformers_mmo/index.html I'm surprised there isn't a Battlefield Earth MMO yet, or a Waterworld MMO... Quote Link to comment Share on other sites More sharing options...
Cancer Posted March 19, 2011 Report Share Posted March 19, 2011 Re: Longest Running Thread EVER O'R'Lyeh? Yeah, it's still close enough to St Paddy's Day, even Cthulhu is Irish! Quote Link to comment Share on other sites More sharing options...
L. Marcus Posted March 19, 2011 Report Share Posted March 19, 2011 Re: Longest Running Thread EVER ... He's green, right? Quote Link to comment Share on other sites More sharing options...
Cancer Posted March 22, 2011 Report Share Posted March 22, 2011 Re: Longest Running Thread EVER Y'know, I'm not sure a reliable image or eyewitness testimony has ever been taken of him. Quote Link to comment Share on other sites More sharing options...
L. Marcus Posted March 22, 2011 Report Share Posted March 22, 2011 Re: Longest Running Thread EVER ... How about a spectrum? Quote Link to comment Share on other sites More sharing options...
Cancer Posted March 22, 2011 Report Share Posted March 22, 2011 Re: Longest Running Thread EVER Hmm, spectrometers are pretty delicate, usually. They may not be able to handle that. Intriguing idea, though. You have no idea how many maximal geek-out spectroscopic puns leap to mind. Quote Link to comment Share on other sites More sharing options...
L. Marcus Posted March 22, 2011 Report Share Posted March 22, 2011 Re: Longest Running Thread EVER I bet he'd be A Color Out Of Space. Quote Link to comment Share on other sites More sharing options...
Cancer Posted March 22, 2011 Report Share Posted March 22, 2011 Re: Longest Running Thread EVER There's lots of colors like that. That's what most color indexes are, or at least try to be, actually. Quote Link to comment Share on other sites More sharing options...
L. Marcus Posted March 22, 2011 Report Share Posted March 22, 2011 Re: Longest Running Thread EVER No wonder paint shops make people go mad. Quote Link to comment Share on other sites More sharing options...
Cancer Posted March 22, 2011 Report Share Posted March 22, 2011 Re: Longest Running Thread EVER Speaking of going mad, Excel is refusing to sort. It almost sorts, but it has a few things subtly out of order. Very, very strange. Quote Link to comment Share on other sites More sharing options...
SteveZilla Posted March 23, 2011 Report Share Posted March 23, 2011 Re: Longest Running Thread EVER Speaking of going mad' date=' Excel is refusing to sort. It almost sorts, but it has a few things subtly out of order. Very, very strange.[/quote'] Perhaps some data is in ASCII, and some is in Unicode? Quote Link to comment Share on other sites More sharing options...
RPMiller Posted March 23, 2011 Report Share Posted March 23, 2011 Re: Longest Running Thread EVER Speaking of going mad' date=' Excel is refusing to sort. It almost sorts, but it has a few things subtly out of order. Very, very strange.[/quote'] Did you exceed the maximum number of cells for a sort? Incredibly, Excel actually has a limit to the size of the sort. Quote Link to comment Share on other sites More sharing options...
Cancer Posted March 23, 2011 Report Share Posted March 23, 2011 Re: Longest Running Thread EVER No, it's puny, 75 rows. I'm sorting on a computed column. When I force the data into constant-value form (by writing it out to a CSV file, and then opening that in Excel) the sort works just fine. If that really is the problem, that is just unspeakably lame, because it almost sorts, but not quite. Quote Link to comment Share on other sites More sharing options...
RPMiller Posted March 23, 2011 Report Share Posted March 23, 2011 Re: Longest Running Thread EVER Yeah, that size isn't even remotely close to the limit (depending on version it is 1500+ rows). Hm... computed column shouldn't matter, but what are the values that are not sorting correctly? Are they huge/tiny numbers by any chance? Quote Link to comment Share on other sites More sharing options...
SteveZilla Posted March 23, 2011 Report Share Posted March 23, 2011 Re: Longest Running Thread EVER Presumably the whole column is formatted/stored the same way? I can possibly see numbers being sorted differently than "number stored as text" (a message excel sometimes gives me). Quote Link to comment Share on other sites More sharing options...
Cancer Posted March 25, 2011 Report Share Posted March 25, 2011 Re: Longest Running Thread EVER Well, I was sorting on a column that was being computed, a weighted sum of five values, scaled. I'd formatted the whole column (well, the rows of it that were in the sort, anyway) to show three places after the decimal. When I did the RANK() function on it, the ranking came out OK; it was, in fact, that the rank numbers were out of order that confirmed something was goofy with the sort. When I used the Data Analysis --> Histogram tool on the same data, that made the same kind of mistake as the sort did. It was the histogram that got me onto the problem initially. This was for my course grades, and when making my curve, I prefer to make a histogram and then label each box with the student name so I can see if the score breakpoints correspond to what I think the students did, and I couldn't get that to work. I went to the RANK function to let me assign names to histogram boxes, and when the rank column goes 11-12-17-13-14-15-16 (and a couple other glitches as well), and they were clearly out of order (by tenths, when the values range from the low 90s down to the 40s) once it was pointed out. Very weird. I got what I wanted eventually, albeit by forcing out values onto a CSV file and doing the sort (and histogram) on static numbers rather than computed values. And I got my grades in 13 hours early and avoided a snotty email from the assistant dean. Quote Link to comment Share on other sites More sharing options...
L. Marcus Posted March 25, 2011 Report Share Posted March 25, 2011 Re: Longest Running Thread EVER Too tired. Can't parse text. Need sleep. Quote Link to comment Share on other sites More sharing options...
RPMiller Posted March 26, 2011 Report Share Posted March 26, 2011 Re: Longest Running Thread EVER Interesting... I've seen this sort of problem--excel corruption in individual cells--only one other time, but it was similarly frustrating trying to figure out. One of our purchasing managers was trying to do an inventory forecast and the numbers routinely were coming out off by a magnitude of 10. We never figured out what caused the problem, but it was similar to your issue, Cancer. The majority of the cells were all computational. What we ended up doing just as a SWAG was to create a new workbook, and then copy/paste the contents of the spreadsheet from the first workbook into the new one. We did a workbook to rule out any corruptions within the file itself. After we pasted in the content the values all came out correct. I did a small amount of research into finding out if it was a known problem, but didn't come to any concrete answers although there were others with similar stories. Most of those were from earlier versions of Excel though. Quote Link to comment Share on other sites More sharing options...
Cancer Posted March 28, 2011 Report Share Posted March 28, 2011 Re: Longest Running Thread EVER Which earlier versions? I'm doing this with Excel Mac 2004. Quote Link to comment Share on other sites More sharing options...
RPMiller Posted March 29, 2011 Report Share Posted March 29, 2011 Re: Longest Running Thread EVER Windows Excel 4 through 2003. No experience with 2007, and 2010 is too new. Quote Link to comment Share on other sites More sharing options...
L. Marcus Posted March 29, 2011 Report Share Posted March 29, 2011 Re: Longest Running Thread EVER ... So, how about them Cubbs? Quote Link to comment Share on other sites More sharing options...
Cancer Posted March 29, 2011 Report Share Posted March 29, 2011 Re: Longest Running Thread EVER Heh, the Cubbies released Carlos Silva, the Sultan of Suck, and he flamed them for it. (He earned that label from me when he was with the Mariners, who traded him to the Cubs in exchange for a different problem child a couple years back.) The fact that he sucks green slimy rocks from the bottom of the cesspool through three meters of used catheter tubing never crosses his mind. 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.