elvum: (Default)
I discovered the delightful inclusion of a "map" function ("ARRAYFORMULA") in Google Spreadsheets today. Those of you with experience programming in functional languages will appreciate the elegance of this, and of the other higher-order functions (HOFs), none of which have yet made it into the world of spreadsheets as far as I can determine, Google or otherwise.

[livejournal.com profile] terpsichore1980 (whose job requires her to be an Excel wizard) informs me that Microsoft have gone down the road of implementing custom functions for every combination of HOFs they think their users might need (eg COUNTIF, which is equivalent to FOLD(ADD(),(MAP(IF(condition, 1, 0)))) in some vaguely spreadsheety functional pseudocode, or ARRAYFORMULA(SUM(IF(rangecondition, 1, 0))) in Googlese.

Anyway, it made me happy, and I thought I'd share it.

Profile

elvum: (Default)
elvum

April 2009

S M T W T F S
   1 234
567891011
12131415161718
19202122232425
2627282930  

Syndicate

RSS Atom

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Jul. 28th, 2017 10:51 am
Powered by Dreamwidth Studios