Spreadsheet links map
In practice a full discovery process inside a real business environment is likely to generate a very complex picture, as seen below. Here the precedents of the topmost file include many hundreds of additional spreadsheets. This type of map serves as an ideal starting point for creating the future architectural road map of the business. This planning will determine which spreadsheets should be retained within the business and which should be replaced by more robust solutions, together with the relative priority of each step. To explore this map in more detail click the 'Download Map' option below this image.Download map. Please note that this is a large (4MB) image.
Download map. Please note that this is a large (4MB) image.
"I still see audit reports or project plans that recommend replacing spreadsheets and manual processes with an ‘IT solution’. This will never happen. It is impractical to replace 2 or more fragmented systems with a single system. Replacing the spreadsheet operations with ‘IT designed’ ones only compounds the problem and removes any ability of users to address problems. The only ‘solution’ is to eliminate the worst processes, and to apply appropriate controls to the ones that remain."Dean Buckner, FSA