elvum: (Default)
[personal profile] elvum
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.
From:
Anonymous( )Anonymous This account has disabled anonymous posting.
OpenID( )OpenID You can comment on this post while signed in with an account from many other sites, once you have confirmed your email address. Sign in using OpenID.
User
Account name:
Password:
If you don't have an account you can create one now.
Subject:
HTML doesn't work in the subject.

Message:

 
Notice: This account is set to log the IP addresses of everyone who comments.
Links will be displayed as unclickable URLs to help prevent spam.

Profile

elvum: (Default)
elvum

April 2009

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

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Jul. 21st, 2017 12:33 pm
Powered by Dreamwidth Studios