When all you have is Excel, every problem looks like a nail worksheet.
If I had to use a spreadsheet for this, I would import a file generated
by "cal -y". It may well be easier to use a PIM for this, though.
Posts made by Ben_Hutchings
-
RE: Better living through Excel calculations
-
RE: Www.howtohackamailstation.com
If you cut the power halfway through the reset then the stored
configuration will be invalid and the unit will presumably ignore it
and let you start configuration from scratch. It's still a bit weird
that it doesn't just use the default configuration in that case though. -
RE: Insurance WTF
@Mike R said:
Except in this case, the only risk I took was getting laid off. Whups,
silly me, guess I shouldn't have gotten myself laid off. I could have
prevented that, you know.
As I said, correlation, not causality.
-
RE: Insurance WTF
Speaking of which, insurance can be cheaper with one's spouse as a
second driver, because the statistics suggest married people are safer
drivers. -
RE: Insurance WTF
If someone has a tendency to take silly risks, they're more likely to
get bad credit and more likely to crash their car, I suppose. We're
talking about statistics here, so they're really interested in
correlation rather than causality. -
RE: A whole database of WTF
Yes, I know, having implemented strftime a couple of times and thus
dealt with three different week numbering schemes. The above
manipulations of WD1 can only produce week numbers between 1 and 52
inclusive. -
RE: A whole database of WTF
Does it do anything else with WD1 after this? I'm somewhat bothered by
the fact that there can be more than 52 weeks in the year. -
RE: VC demands Oracle?
"Sequel" is historically accurate too, because that was the name of
SQL's predecessor, standing for Simple English QUEry Language.
Presumably it was English in the sense that it used some English words,
and Simple in the sense that, um, marketing thought that would sound
good. -
RE: America vs Europe
I think the theory of evolution is an excellent theory and I think, to some degree, that it's been observed in a micro level (if I understand it right we haven't had enough time to observe it on a macro level yet). But evolution as a theory for the 'origin of species' is a more interesting one. ... We have a few theories, lets enjoy them and investigate them, but why do we need to take sides?
The scientific term "theory" means a rational system of ideas with evidence behind it, not just a hypothesis. There is good evidence for evolution, and none for creation (beyond the bible). I encourage you to read Darwin's original work on evolution, The Origin of Species, which is quite readable and not only explains the evidence behind his theory but anticipates and responds to many of the objections that ignorant creationisms still make today. The reason for "taking sides" is that knowledge of the origin of species is actually useful in understanding the similarities and differences between them.
-
RE: Re: Test Thread
Hmm, so there's no way to talk about Java script at all. Reminds me of medireview and such nonsense.
-
RE: Official Membership Thread -- Just Reply Here!
"Can't have upper and lower case letters in field names..."
You can, but you have to put them in double quotes in your SQL.
-
RE: Now you're asking for it
The filter can be evaded anyway (see my previous comment).
-
RE: Phear my m4d sk1llz
I'm a little suspicious that this is an uncredited copy of an old version of the Wikpedia article.
-
RE: The "I hate SOAP" club.
Katja wrote:
"Anyway, when you are creating server applications that need an open
protocol for clients then you have not much choice."
Er, yes you do. There's XML-RPC, REST, and CORBA may sometimes be an option. -
RE: Quicken sucks
TrendyTime: It's not a regional difference. The Quicken brand is used
for personal finance software whereas QuickBooks is used for
business-oriented software that presumably follows legal accounting
regulations. -
RE: Microtext and 3-inch wide columns...
I think the narrow columns may be due to a bug in Mozilla's incremental
layout. If I see a forum page with a narrow column of comments, then go
back and then forward again, the column appears full-width the second
time round. -
RE: Just a test
If I reply, quoting a comment which itself quotes another comment, any
editing I do is lost. At a guess this has something to do with the
markup in the quoted comment. The same problem doesn't occur when
replying to a comment that is merely marked up as bold though. -
RE: Just a test
@Ben Hutchings said:
There's some kind of bug in FreeTextBox or Firefox that causes editing
to be lost sometimes. I'm going to use this thread to experiment with
it.
First reply.
-
Just a test
There's some kind of bug in FreeTextBox or Firefox that causes editing
to be lost sometimes. I'm going to use this thread to experiment with
it. -
RE: Oracle and NULL
@rpresser said:
The problem is that relational logic is not a two-valued, boolean logic. The middle is not excluded. It's not "you're either for us, or against us."
I'll have to take issue with your use of "relational" there. Relational theory doesn't have NULLs, because NULL is a non-value indicating a missing relation. SQL includes NULLs as a kluge to allow incompletely normalised data, and I agree that that results in a need for three-valued logic (among many other unpleasant complications).
On an unrelated note, the editing widget is broken in Firefox. Pressing "Post" always posts the original text - hence my last comment and the many others that quote comments in full but add nothing.
-
RE: Oracle and NULL
@rpresser said:
Alex Papadimoulis wrote: Whoops -- typo in the original post. replace AND with OR.
But still, it's pretty stupid that you need to put that clause in anyway. Any value that is not 'XYZ' should include values that are NULL as well.But you didn't ask for "any value that is not 'XYZ'". You asked for "All values that are not-equal-to 'XYZ'". This would be "any value that is not 'XYZ'":<FONT style="BACKGROUND-COLOR: #efefef"> SELECT * FROM SM_STPD_TB
WHERE NOT SM_STPD_CD = 'XYZ'</FONT><FONT style="BACKGROUND-COLOR: #efefef"></FONT><FONT style="BACKGROUND-COLOR: #efefef">And as usual, this isn't just Oracle, it's all SQL.</FONT><FONT style="BACKGROUND-COLOR: #efefef"></FONT><FONT style="BACKGROUND-COLOR: #efefef">The problem is that relational logic is not a two-valued, boolean logic. The middle is not excluded. It's not "you're either for us, or against us." </FONT><FONT style="BACKGROUND-COLOR: #efefef"></FONT><FONT style="BACKGROUND-COLOR: #efefef">Suppose I asked you to list the names of all people in your family who prefer haggis to blood pudding. I think there's a fair chance that such a question would *not* be the same as asking for the names of all people who do not prefer blood pudding to haggis. There very likely are people who hate both concoctions equally; there very likely are people who have never tasted either and hence have no opinion.</FONT>