The anti-spreadsheet jihad continues

I’ve LOL’ed before at the idea of blaming the financial crisis on too much reliance on Excel, but James Kwak does have some balanced and intelligent thoughts about it, and its problems, here.

It still has always seemed to me that to focus on the Use Of Spreadsheets is to go for the capillary when it comes to financial-sector leverage, ‘innovation’ and bubble-blowing. It’s a symptom rather than a cause, and it’s a tool for shenanigans, perhaps an enabling one – but it’s just not the shenanigans themselves. Moreover, as Kwak points out, you can never really get rid of spreadsheets:

For all the talk about end-to-end financial suites like SAP, Oracle, and Peoplesoft, at the end of the day people do financial analysis by extracting data from those back-end systems and shoving it around in Excel spreadsheets.

Exactly. Imagine the most perfect Secure Spreadsheet Replacement, and now imagine every single user on a day to day basis mostly using it to scrape numbers out of it so that they can actually play with the numbers.

In a spreadsheet.

5 Responses to The anti-spreadsheet jihad continues

  1. Kid Dynamite says:

    blaming spreadsheets for their user’s errors is like blaming the rope when a guy hangs himself…

    • Well, there are fair points to be made (as Kwak does) about how their errors will only be caught asymetrically, i.e. only when those errors were to the bank’s disadvantage. But that’s not only true of ‘spreadsheets’, it’s true of underlying models and calculations wherever they’re performed.

      More to the point, the anti-spreadsheet crusade in practice mostly seems to lead to a wasteful cul-de-sac, throwing resources at the myopic cause of Reducing The Number Of Spreadsheets.

  2. http://www.anaplan.com might be an interesting middle-ground. You get the flexibility to ‘play’ (and in a spreadsheet paradigm) while keeping the central control (security) and transparency (visibility into the formulae) that organizations say they want.

    • Interesting thanks. i had not heard of that.

  3. Pingback: Got em all laid out on my bedsheets | Rhymes With Cars & Girls

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 313 other followers

%d bloggers like this: