Authors
Paul Mireault & Lindsey Gresham
Abstract
The verification of spreadsheets continues to be tedious and challenging within corporate governance processes. This is primarily due to the fact that spreadsheets are often hard, if not impossible, to understand.
We present a development methodology that produces spreadsheets which are easier to understand and also highly maintainable, regardless of who designed and implemented the model. By following the methodology, the developer also produces the model's documentation, which can be handed off to another developer and can be used in an audit.
Sample
The Formula Diagram is a graphical representation of the model. Its purpose is to provide a global view of the model: we quickly see the relationships between the variables.
Publication
2015, International Conference on Accounting and Finance
Full article
Governance and structured spreadsheets: Your spreadsheets don't need to be black boxes
