1 / 42

Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)

Spreadsheets: The dark matter of IT Felienne Hermans (@felienne). 95% of all U.S. firms use spreadsheets for financial reporting. 50% of spreadsheets form the basis for decisions. Spreadsheet exist ‘under the radar’. Spreadsheets can have a long life, 5 years on average.

morey
Download Presentation

Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)

  2. 95% of all U.S. firms use spreadsheets for financial reporting

  3. 50% of spreadsheets form the basis for decisions

  4. Spreadsheet exist ‘under theradar’

  5. Spreadsheets can have a long life, 5 years on average

  6. Average sheet is used by 12 different people

  7. Only 33% of spreadsheets has a manual

  8. Complex spreadsheets lead to disaster

  9. The European Spreadsheet Risk Interest Group (Eusprig.org) collects horror stories

  10. Loss 2.4 million dollars Cause typo

  11. Loss 2.4 million dollars Cause typo Loss 24 million dollars Cause copy-paste error

  12. What can we do?

  13. No docs, errors, long life It looks like…

  14. No docs, errors, long life It looks like software!

  15. In software, tools have been created to help programmers understand code

  16. We bring understandability tools to spreadsheets

  17. Then we tried the tool in practice

  18. Users started diagnosing with the diagrams

  19. “This is too complex”

  20. “This arrow is too fat”

  21. Move C11:F20 to POA Project

  22. We tried the tool in practice again

  23. Complicated formulas still got inthe way of understanding details

  24. This formula can be simplified

  25. The analyses are combined in our tool PerfectXL

  26. The analyses are combined in our tool PerfectXL (www.infotron.nl/strata)

  27. We build tools to visualize and improve spreadsheets

  28. What can we learn from the success of spreadsheets?

  29. Most alternatives still look like this

  30. BI Spreadsheets Complex Simple

  31. BI Spreadsheets Complex Simple Plan Serendipity

  32. Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)

More Related