News for hackers. Stuff that matters.
Re:Damn Excel – How the 'most important application' is ruin... by UnoriginalGuy on Saturday April 20, 2013 @06:11PM (#5583029)
I hate it when people generate these contrived examples where they intentionally stack the scenario to favour whichever way proves their point the most.

Which is easier to understand:

=SUM(profits01_2012:profits12_2012)

Or:

SELECT * FROM dassaddasads WHERE date > 1325394000 AND date < 1356930000

Which is easier to understand?!

Re:Damn Excel – How the 'most important application' is ruin... by omni on Saturday April 20, 2013 @07:33PM (#5583241)
I have seen literally hundreds of Excel spreadsheets from banks, consultancies, and VC firms and I have never, ever seen anyone name individual cells the way you are proposing here. If I had to name individual cells in a monthly model spanning the next 10 years over 250 line items, I'd quit that job.

I'm not saying that Excel can't do it, but a) it sounds like it would take a huge amount of time, so b) it is not practically done in "the real world."

Re:Damn Excel – How the 'most important application' is ruin... by jodrellblank on Sunday April 21, 2013 @11:37AM (#5585165)
If I had to name individual cells in a monthly model spanning the next 10 years over 250 line items, I'd quit that job.

Why would you quit the job over a few minutes of scripting with "WorkSheet.Names.Add"?

http://msdn.microsoft.com/en-us/library/office/ff835300.aspx

Re:Damn Excel – How the 'most important application' is ruin... by InclinedPlane on Saturday April 20, 2013 @06:31PM (#5583083)
This ignores the common use case. yummyfajitas' examples were exceedingly stereotypical of both excel and mysql usage.
Re:Damn Excel – How the 'most important application' is ruin... by UnoriginalGuy on Saturday April 20, 2013 @06:36PM (#5583094)
They aren't stereotypical of the kind of Excel that gets written by people who use it as a major part of their job. They're stereotypical of people writing poor Excel queries against unnamed cells via location reference.
Re:Damn Excel – How the 'most important application' is ruin... by dspeyer on Saturday April 20, 2013 @06:36PM (#5583096)
Is that first one valid Excel? I've never seen it before.
Re:Damn Excel – How the 'most important application' is ruin... by UnoriginalGuy on Saturday April 20, 2013 @06:48PM (#5583129)
Yes, it is valid Excel. Naming cells is something they teach in beginners courses.

http://www.computerhope.com/issues/ch000704.htm

http://support.microsoft.com/kb/274504