420 likes | 603 Views
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.
E N D
Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)
95% of all U.S. firms use spreadsheets for financial reporting
Spreadsheets can have a long life, 5 years on average
The European Spreadsheet Risk Interest Group (Eusprig.org) collects horror stories
Loss 2.4 million dollars Cause typo
Loss 2.4 million dollars Cause typo Loss 24 million dollars Cause copy-paste error
No docs, errors, long life It looks like…
No docs, errors, long life It looks like software!
In software, tools have been created to help programmers understand code
Users started diagnosing with the diagrams
Complicated formulas still got inthe way of understanding details
The analyses are combined in our tool PerfectXL
The analyses are combined in our tool PerfectXL (www.infotron.nl/strata)
Most alternatives still look like this
BI Spreadsheets Complex Simple
BI Spreadsheets Complex Simple Plan Serendipity
Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)