Spreadsheet bibliography

Title Spreadsheet hell
Authors Simon Murphy
Year 2007
Type Proceedings
Publication EuSpRIG
Series  
Abstract

This management paper looks at the real world issues faced by practitioners managing spreadsheets through the production phase of their life cycle.

It draws on the commercial experience of several developers working with large corporations, either as employees or consultants or contractors. It provides commercial examples of some of the practicalities involved with spreadsheet use around the enterprise.

Full version Available
Sample
Spreadsheet management

Ideally a program of spreadsheet management would include:

  • Policies on when to use, and when not to use, spreadsheets.
  • Procedures for safe and effective development of valuable spreadsheets.
  • Features to use and those to avoid, with justifications.
  • Adequate training and coaching appropriate to job role.
  • Procedures and policies for managing the modification of live systems.
  • Policies for safely archiving retired spreadsheets.
  • Full consideration of all aspects of the systems life cycle.