Cover from Ormetis

Date: 26th February, 2010
Format: InBrief

Free Download (subject to terms)

Spreadsheets are widely used within many business processes. However, these processes often lack rigour. There are various steps to be gone through in terms of loading data into spreadsheets and manipulating that data, often involving operations such as cut and paste, but this is not enforced or governed in any way. In practice, what this means is that these processes have, in a sense, to be re-created every time they are performed. Moreover, the processes themselves are not documented, there is significant risk of error and such processes will not be compliant with Sarbanes-Oxley or other similar regulations.

There are various products in the market that will audit what you do with spreadsheets for compliance purposes but what is really required is a solution that supports business process optimisation for those processes involving spreadsheets. In particular, these informal processes need to be made formal, so you need to be able to capture the complete process flow.