spreadsheets: the dark matter of it felienne hermans (@felienne)
TRANSCRIPT
![Page 1: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/1.jpg)
Spreadsheets: The dark matter of ITFelienne Hermans (@felienne)
![Page 2: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/2.jpg)
95% of all U.S. firms use spreadsheets for financial reporting
![Page 3: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/3.jpg)
50% of spreadsheets form the basis for decisions
![Page 4: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/4.jpg)
Spreadsheet exist ‘under the radar’
![Page 5: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/5.jpg)
Spreadsheets can have a long life, 5 years on average
![Page 6: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/6.jpg)
Average sheet is used by 12 different people
![Page 7: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/7.jpg)
Only 33% of spreadsheets has a manual
![Page 8: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/8.jpg)
Complex spreadsheets lead to disaster
![Page 9: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/9.jpg)
The European Spreadsheet Risk Interest Group (Eusprig.org) collects horror stories
![Page 10: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/10.jpg)
![Page 11: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/11.jpg)
Loss 2.4 million dollarsCause typo
![Page 12: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/12.jpg)
Loss 2.4 million dollarsCause typo
Loss 24 million dollars
Cause copy-paste error
![Page 13: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/13.jpg)
What can we do?
![Page 14: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/14.jpg)
No docs, errors, long lifeIt looks like…
![Page 15: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/15.jpg)
No docs, errors, long lifeIt looks like software!
![Page 16: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/16.jpg)
In software, tools have been created tohelp programmers understand code
![Page 17: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/17.jpg)
![Page 18: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/18.jpg)
![Page 19: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/19.jpg)
![Page 20: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/20.jpg)
We bring understandability tools to spreadsheets
![Page 21: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/21.jpg)
![Page 22: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/22.jpg)
Then we tried the tool in practice
![Page 23: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/23.jpg)
![Page 24: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/24.jpg)
![Page 25: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/25.jpg)
![Page 26: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/26.jpg)
![Page 27: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/27.jpg)
Users started diagnosing with the diagrams
![Page 28: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/28.jpg)
“This is too complex”
![Page 29: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/29.jpg)
![Page 30: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/30.jpg)
“This arrow is too fat”
![Page 31: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/31.jpg)
Move C11:F20 to POA Project
![Page 32: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/32.jpg)
We tried the tool in practice again
![Page 33: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/33.jpg)
Complicated formulas still got in the way of understanding details
![Page 34: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/34.jpg)
This formula can be simplified
![Page 35: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/35.jpg)
The analyses are combined in ourtool PerfectXL
![Page 36: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/36.jpg)
The analyses are combined in ourtool PerfectXL (www.infotron.nl/strata)
![Page 37: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/37.jpg)
We build tools to visualize and improvespreadsheets
![Page 38: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/38.jpg)
What can we learn from the success of spreadsheets?
![Page 39: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/39.jpg)
Most alternatives still look like this
![Page 40: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/40.jpg)
BI Spreadsheets Complex Simple
![Page 41: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/41.jpg)
BI Spreadsheets Complex Simple
Plan Serendipity
![Page 42: Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)](https://reader036.vdocuments.us/reader036/viewer/2022062314/56649dbf5503460f94ab3b4d/html5/thumbnails/42.jpg)
Spreadsheets: The dark matter of ITFelienne Hermans (@felienne)