Analyzing large spreadsheet programs

Abstract: Spreadsheets are an important device for computer based decision support. In this capacity, they might reach a level of complexity and show evolutionary patterns similar to conventional software. However, as end-user devices, they are not subjected to as rigorous a development and maintenance process as professionally written software. Thus, the significance of the decisions they are supporting and their correctness become increasingly divergent. The properties contributing to the success of small scale sheets tend to become a burden with larger sheets. This paper presents an approach that enables auditors to understand the structure of large spreadsheets by aggregating cells with related properties. It will be shown, how different auditing strategies can be supported by this approach.