3 ms·
Ah, fair enough. I mean, I'm not debating the power of Lisp, and it would be great first languages for someone not trained in programming. OTOH, there is of cou
by vanderZwan 9y ago
Ah, fair enough. I mean, I'm not debating the power of Lisp, and it would be great first languages for someone not trained in programming. OTOH, there is of course the trade-off to make it as useful for as broad a selection of users as possible; Python has a lot more mind-share, and the SciPy ecosystem would be a great complement.
If Excel adds some practical convenience functions to the global namespace, would it be that hard to make Python fit the reactive paradigm in this context?
About those variables: maybe the Bumblebee tool she and her team made[0][1][2] would work for you
Our language is an extension of regular Excel formulas,
so you can write a transformation like
A1+A2 <-> SUM(A1:A2)
which allows BumbleBee to transform exactly the formula
A1+A2 to SUM(A1:A2) or vice versa.
In addition to using exact cell references, you may also
use variables instead of cell references:
{i,j} + {i,j+1} <-> SUM({i,j}:{i,j+1})
I hope it can be useful to you! :)
In the video I linked before she mentions it at 31m33s. Oh and here[3] are the slides for that video, in case you prefer those.
(Disclaimer: I don't use Excel myself; I'm just a programmer who wants to get more people into programming, so I was both happy and impressed when I saw her presentation on how people not trained as programmers use it to do really complex tasks)
[0] http://www.felienne.com/BumbleBee http://www.felienne.com/BumbleBee
[1] http://www.felienne.com/archives/2964 http://www.felienne.com/archives/2964
[2] https://figshare.com/articles/BumbleBee_A_Transformation_Environment_for_Spreadsheet_Formulas/813347 https://figshare.com/articles/BumbleBee_A_Transformation_Env... Paper on BumbleBee
[3] http://gotocon.com/dl/goto-amsterdam-2016/slides/FelienneHermans_PureFunctionalProgrammingInExcel.pdf http://gotocon.com/dl/goto-amsterdam-2016/slides/FelienneHer...