![Page 1: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/1.jpg)
Eusprig 2007
Management Paper Spreadsheet Hell
Simon [email protected] – Codematic LtdWith contributions fromwww.smurfonspreadsheets.co.uk
![Page 2: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/2.jpg)
Eusprig 2007
Question
• Who knows of an organisation that may be suffering from Spreadsheet Hell?
![Page 3: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/3.jpg)
Eusprig 2007
Spreadsheet background• Over 1 trillion dollars ($
1,000,000,000,000)• Often linked to other technologies such
as OLAP, ADO, COM or .net etc.• Finance, Banking and Sales and
Marketing areas
![Page 4: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/4.jpg)
Eusprig 2007
Agenda• Spreadsheet use• Micro spreadsheet hell• Macro spreadsheet hell• Summary• Formulas• Questions
![Page 5: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/5.jpg)
Eusprig 2007
Spreadsheet useTechnology
Spreadsheets - 100%
Source:CFO (2004): http://www.cfo.com/article.cfm/3014451?f=related
![Page 6: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/6.jpg)
Eusprig 2007
Spreadsheet use 2
Organisations with 'some' spreadsheet hell
Admit hell - 60% Deluded? - 40%
Stats source:CFO (2004): http://www.cfo.com/article.cfm/3014451?f=related, interpretation mine
![Page 7: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/7.jpg)
Eusprig 2007
Spreadsheet Lifetimes
0 12 24 36 48 60 72 84 96 108 120
Months
Development 4
Development 3
Development 2
Development 1
Some spreadsheet development times v Lifetimes
Development Live- in use
![Page 8: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/8.jpg)
Eusprig 2007
Spreadsheet hell types
• Micro
•Macro
![Page 9: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/9.jpg)
Eusprig 2007
Frankensheet
![Page 10: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/10.jpg)
Eusprig 2007
Frankensheet
![Page 11: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/11.jpg)
Eusprig 2007
Frankensheet
![Page 12: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/12.jpg)
Eusprig 2007
Micro Spreadsheet hell
![Page 13: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/13.jpg)
Eusprig 2007
Micro Spreadsheet hell 2
![Page 14: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/14.jpg)
Eusprig 2007
Demo
![Page 15: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/15.jpg)
Eusprig 2007
Micro Spreadsheet hell 3
![Page 16: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/16.jpg)
Eusprig 2007
Macro Spreadsheet hell
• 100% considered (mis)management the key factor (SOS)
Biggest Spreadsheet Risk
Management - 100%
![Page 17: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/17.jpg)
Eusprig 2007
Organisational management
![Page 18: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/18.jpg)
Eusprig 2007
Common Folder Structure
![Page 19: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/19.jpg)
Eusprig 2007
Duplicate history
![Page 20: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/20.jpg)
Eusprig 2007
Spreadsheet forest
![Page 21: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/21.jpg)
Eusprig 2007
Common end user computing
Primary data sources
WorkbookWorkbook
Workbook
Workbook
Workbook
Workbook
Workbook
Primary data sources
WorkbookWorkbook
Workbook
Workbook
Workbook Workbook
Workbook
![Page 22: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/22.jpg)
Eusprig 2007
Better end user computing
Primary source data
Reporting data
sources
Workbook
Workbook
Workbook
Reporting data
sources
Primary source data
Reporting data
sources
Workbook
Workbook
Workbook
Reporting data
sources
![Page 23: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/23.jpg)
Eusprig 2007
Summary• Micro spreadsheet hell
– Individual spreadsheet quality– Reasonably well documented– Limited consensus on quality
• Macro spreadsheet hell– Organisational issue– Being replaced(?) by database hell– Effective infrastructure investment helps
![Page 24: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/24.jpg)
Eusprig 2007
Formula Fun
• =SUM(#REF!)• =Cost*50%*1000• =((Area/Floors+IF(Levels>0,gArea/
Levels,0))*200%/2)^0.5*6• ='Standard Cost.xls'!DUMPSTER• =GetExtData(“Some Criteria")
+181970242+5989278
![Page 25: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/25.jpg)
Eusprig 2007
Formula Fun
![Page 26: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/26.jpg)
Eusprig 2007
Formula Fun
![Page 27: Eusprig 2007 Management Paper Spreadsheet Hell Simon Murphy simon.murphy@codematic.net Developer – Codematic Ltd With contributions from](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649ea25503460f94ba62ab/html5/thumbnails/27.jpg)
Eusprig 2007
Questions?
• Email– [email protected]
• Websites– www.codematic.net– www.xlanalyst.co.uk
• Blog– www.smurfonspreadsheets.co.uk