Pure Functional Programming in Excel • Felienne Hermans • GOTO 2016
Channel:GOTO Conferences · Length:43:16 · Published:2016-08-09 · Views:25646
Summary
Felienne Hermans argues that Excel is the world's most popular programming language and shows how spreadsheets work as a pure functional language. She implements a few mathematical problems in spreadsheet formulas to illustrate why they are so powerful and approachable.
Why HN recommends it
HN commenters point to it whenever Excel, spreadsheets or functional programming come up, as a fun and serious take on spreadsheets as real programming.
Felienne has a great talk on functional programming in Excel — HN, 2020
Functional programming · Software (other)
Subtitles (excerpt)
[Music] [Applause] hello everyone my name is Fen hermans I'm assistant professor at Del University of Technology I'm on Twitter as well so if you want to rate me not through the app but by sending a tweet then uh feel free to do so so maybe you're wondering at a developers conference why we are talking about spreadsheets so my view on this is is spreadsheets are definitely mislabels many people think of spreadsheets as being data but spreadsheets are not data spreadsheets are code this is the gospel of my life spreadsheets are code I go to all sorts of conferences to share the happy word that spreadsheets our code so if you want to leave now or fall asleep or do some email that's fine because this is already the most important message of my talk right there spreadsheets are CES so you might wonder why well I have three reasons for this the first reason that spreadsheets are code is they're used for similar problems as you see here this is an investment calculation where you put in some numbers and an investment advice comes out you could make this in any programming language I mean you could do it in in C or in Objective C if you want an iPad app or in Java or in a spreadsheet it doesn't really
On Hacker News
OT, but Felienne has a great talk on functional programming in Excel (thanks for reminding me of her name): [VIDEO] — rzzzt, 2020-05
Related to this, I recommend Felienne Hermans' talks on Excel as a functional programming language - [VIDEO] . — robertknight, 2024-01
This is the talk that I first saw that builds on that: [VIDEO] I found it interesting, fun and great. Still, I would stick to using Excel for the personal analysis of data and not as the language/tool on which software is developed: data & programming logic intermixed, the default way to index cells, the difference between normal cells and array cells, and tables, etc., the fact that some things … — ggrrhh_ta, 2021-02
You may enjoy "Pure Functional Programming in Excel" by Felienne Hermans presented at GOTO 2016 [VIDEO] — brohee, 2020-08
Excel itself is functional and reactive already, wouldn't adding an FRP language on top of that be a bit superfluous? Check out Felienne Hermans' work if you haven't already: [VIDEO] [LINK] — vanderZwan, 2017-12
Related videos
- RSA ANIMATE: Language as a Window into Human Nature · Royal Society of Arts · 10:53
- Why Are You So Angry? Part 1: A Short History of Anita Sarkeesian · Innuendo Studios · 9:35
- The Marvel Symphonic Universe · Every Frame a Painting · 13:35
- Confessions of a Converted Lecturer: Eric Mazur · UMBCtube · 1:20:08
- Interactive notebooks ~ Pluto.jl | Fons van der Plas | JuliaCon 2020 · The Julia Programming Language · 23:37
- A Better Default Colormap for Matplotlib | SciPy 2015 | Nathaniel Smith and Stéfan van der Walt · Enthought · 19:08
- Geoffrey West on COMPLEXITY · FQxI · 40:50
- 4 2 1 Christopher Domas The future of RE Dynamic Binary Visualization · Adrian Crenshaw · 48:39
- Stanford Seminar: Beyond Floating Point: Next Generation Computer Arithmetic · Stanford Online · 1:31:28
- "Performance (Really) Matters" with Emery Berger · Association for Computing Machinery (ACM) · 1:04:47
- "Performance Matters" by Emery Berger · Strange Loop Conference · 42:15
- The Ingenious Design of the Aluminum Beverage Can · engineerguy · 11:39
- Brandt Bucher – A JIT Compiler for CPython · encukou · 47:50
- Plover: Thought to Text at 240 WPM · Next Day Video · 34:21
- Bytebeat: Experimental music from very short C programs · Ville-Matias Heikkilä (viznut) · 4:11
- DIY haptic input knob: BLDC motor + round LCD · scottbez1 · 2:11
- Project Code Rush - The Beginnings of Netscape / Mozilla Documentary · The Documentary Network · 56:08
- Hareraiser (The Worst Game Ever) - Stuart Ashen - Norwich Gaming Festival 2017 · Norwich Games Festival · 36:19