News for hackers. Stuff that matters.
Re:The Importance of Excel by thirsteh on Sunday February 10, 2013 @06:26PM (#5198429)
Excel is an easy-to-use functional programming language.
Re:The Importance of Excel by nandemo on Sunday February 10, 2013 @07:35PM (#5198652)
Reminds of this paper by Simon Peyton-Jones at al.:

Improving the world's most popular functional language: user-defined functions in Excel

http://research.microsoft.com/en-us/um/people/simonpj/Papers...

Re:The Importance of Excel by Evbn on Monday February 11, 2013 @12:21AM (#5199523)
That was kind of a PR gimmick. Excel is declarative, but misses a lot of functional. For example, first class functions.
Re:The Importance of Excel by gruseom on Monday February 11, 2013 @01:09AM (#5199628)
Can you imagine a spreadsheet with first-class functions, and possibly other functional features? What would such a thing look like?

Strictly speaking, Excel doesn't have functions at all, let alone first-class, since you can't define a new function using only cells and formulas. You have to go to VBA.

Re:The Importance of Excel by keithalewis on Wednesday February 13, 2013 @07:26AM (#5212694)
Like this: http://xllfunctional.codeplex.com/. Not easy to use at all, but it is possible. Barely.
Re:The Importance of Excel by jccodez on Sunday February 10, 2013 @07:55PM (#5198702)
vba?
Re:The Importance of Excel by bgilroy26 on Sunday February 10, 2013 @11:32PM (#5199393)
I think thirsteh was talking about the big models that operate at the spreadsheet layer, without VBA. VBA is imperative, but when you chain worksheet functions together, you have a more explicit, more visible way of manipulating data the way you might with a functional programming language.
Re:The Importance of Excel by thirsteh on Monday February 11, 2013 @08:24AM (#5200612)
Indeed. Some people have even used e.g. Haskell to provide more "real" logic, but with Excel as the user interface:

http://qconlondon.com/london-2008/speaker/Lennart+Augustsson

http://urchin.earth.li/~ganesh/icfp08.pdf

Re:The Importance of Excel by bgilroy26 on Monday February 11, 2013 @10:56AM (#5201382)
These are cool! Thank you!