Strata Conference in London 2013: Felienne Hermans
summary
Research finds a 1,500‑employee bank has 2.5 million spreadsheets, spreadsheets live five years on average and are edited by about 12 people, and 50% are used to base decisions while only one third have any manual. Visual tools detect structure, smells and clones, surface a fat inter‑sheet data flow and suggest refactorings, and an integrated tool called Perfect Excel (try infotron.net/strata) reduces errors that have cost organizations $2.5M and $24M and caused a 10,000‑ticket overbooking.
AI-written summary · about
chapters (11)
- 0:00Start
- 0:2895% of all U.S. firms use spreadsheets for financial reporting
- 1:12Spreadsheet exist 'under the radar
- 3:28Average sheet is used by 12 different people
- 4:01Only 33% of spreadsheets has a manual
- 4:39Complex spreadsheets lead to disaster
- 6:18What can we do?
- 6:41No docs, errors, long life It looks like software
- 11:31Complicated formulas still got in the way of understanding details
- 12:04We build tools to visualize and improve spreadsheets
- 12:18What can we learn from the success of spreadsheets?
related talks
17mFive signs your spreadsheet might smell (and what you can do about it)
16mEXCELsioR!
48mSmart Spreadsheets
18mBold indicates negative?
44mSpreadsheets are Code
39mSpreadsheets for developers
23mMichael Setticasi: Sr. Director of Business Development for Alteryx at Cypher 2017
48mSpreadsheets for Developers