Abstract:There have been many articles and mishaps published about the risks of uncontrolled spreadsheets in today's business environment, including non-compliance, operational risk, errors, and fraud all leading to significant loss events. Spreadsheets fall into the realm of end user developed applications and are often absent the proper safeguards and controls an IT organization would enforce for enterprise applications. There is also an overall lack of software programming discipline enforced in how spreadsheets are developed. However, before an organization can apply proper controls and discipline to critical spreadsheets, an accurate and living inventory of spreadsheets across the enterprise must be created, and all critical spreadsheets must be identified. As such, this paper proposes an automated approach to the initial stages of the spreadsheet management lifecycle - discovery, inventory and risk assessment. Without the use of technology, these phases are often treated as a one-off project. By leveraging technology, they become a sustainable business process.

Strategies for Addressing Spreadsheet Compliance Challenges

Managing Critical Spreadsheets in a Compliant Environment

Automating Spreadsheet Discovery & Risk Assessment

Comparison of Spreadsheets with other Development Tools (limitations, solutions, workarounds and alternatives)

A Practical Approach to Managing Spreadsheet Risk in a Global Business

Leveraging User Profile and Behaviour to Design Practical Spreadsheet Controls for the Finance Function

Investigating the use of Software Agents to Reduce The Risk of Undetected Errors in Strategic Spreadsheet Applications

Spreadsheet Risk - A New Direction for HMRC?

Mitigating Spreadsheet Risk in Complex Multi-Dimensional Models in Excel

Controlling the Information Flow in Spreadsheets

Development and Experimentation of a Software Tool for Identifying High Risk Spreadsheets for Auditing

Exploring Spreadsheet Use and Practices in a Technologically Constrained Setting

From Good Practices to Effective Policies for Preventing Errors in Spreadsheets

Spreadsheets Grow Up: Three Spreadsheet Engineering Methodologies for Large Financial Planning Models

Qtier-Rapor: Managing Spreadsheet Systems & Improving Corporate Performance, Compliance and Governance

A Computational Framework for the Near Elimination of Spreadsheet Risk

Reducing Spreadsheet Risk with FormulaDataSleuth

Audit and Change Analysis of Spreadsheets

Protecting Spreadsheets Against Fraud

Spreadsheet Assurance by "Control Around" is a Viable Alternative to the Traditional Approach

Transforming Critical Spreadsheets into Web Applications at Zurich Financial