Spreadsheets ahead of the game

I am fairly regularly bombarded with negative news about spreadsheets. Excel in multimillion pound error, Excel causes wrong contract choice, etc etc.

I get it, spreadsheets have errors…like most things.

Anyway, on my quest to understand why something as ridiculous as Object Oriented programming has pervaded our world I came across this, which paints spreadsheets in a much more positive light (IMO) .

A video where Simon P-J, (a Microsoft boffin), points outs something I have been bleating on about for a while – that Excel is the most widely used Functional programming language in the world.

If you don’t know what functional programming is, it’s the future. OO was vaguely useful for one or two specific use cases in the 80’s, but in the modern world, apart from those selling books or consulting on how to make OO less completely shit, most people are recognising Functional approaches as more useful.

Functional programming is what we do in a spreadsheet grid, a key tenant of which is no side effects, which is why UDFs have such limitations on what they can do. Although I notice Ms has opened these up a little in recent times.

So anyway, when all the propeller heads from IT are moaning about spreadsheets, its probably because they are locked into a 1980s paradigm and don’t understand our functional approach.

Bless…

Advertisements

2 Responses to “Spreadsheets ahead of the game”

  1. fastexcel Says:

    See Simon P-J’s ideas on extending Excel

  2. Simon Says:

    Thanks for that Charles. I’ve been down that function definition rabbit hole myself, but I like their joined up thinking.
    Is it in 2016??

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.


%d bloggers like this: