Archive for March, 2018

Spreadsheets ahead of the game

Monday, 19th March, 2018

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