• Corpus ID: 40536788

Documenting Spreadsheets

@article{Payette2008DocumentingS,
  title={Documenting Spreadsheets},
  author={Raymond Payette},
  journal={ArXiv},
  year={2008},
  volume={abs/0803.0165}
}
This paper discusses spreadsheets documentation and new means to achieve this end by using Excel’s built-in “Comment” function. By structuring comments, they can be used as an essential tool to fully explain spreadsheet. This will greatly facilitate spreadsheet change control, risk management and auditing. It will fill a crucial gap in corporate governance by adding essential information that can be managed in order to satisfy internal controls and accountability standards. INTRODUCTION The… 
A Practical Approach to Managing Spreadsheet Risk in a Global Business
TLDR
A case-study is presented explaining the practical and pragmatic approach that was recently taken to control spreadsheet risk at one of Protiviti's clients - a global energy firm.
Spreadsheets and the Financial Collapse
TLDR
There is a link between the use of spreadsheets and the recent collapse of the global financial system, and governments and regulating authorities are provided with some simple recommendations to reduce the risks of continued overdependence on unreliable spreadsheets.
On the Interpretation of Spreadsheets within their Environment
TLDR
This work employs indexes to generate a list of relevant evidence that is hyperlinked to the context in which the evidence is discussed, and contends that these presentational differences aid the integrity and understanding of complex models.
Development and Experimentation of a Software Tool for Identifying High Risk Spreadsheets for Auditing
TLDR
Conference paper published in Proceedings of the European Spreadsheets Risks Interest Group Conference on "Spreadsheet Risk Management" shows the importance of knowing how to manage spreadsheets risk in the event of a financial crisis.
End User Computing in AIB Capital Markets: A Management Summary
TLDR
The development of an effective policy is described, as well as the process by which a register of critical EUC applications was assembled and how those applications were brought into a controlled environment.
An Insight into Spreadsheet User Behaviour through an Analysis of EuSpRIG Website Statistics
The European Spreadsheet Risks Interest Group (EuSpRIG) has maintained a website almost since its inception in 2000. We present here longitudinal and cross-sectional statistics from the website log
Evaluating Financial Model Performance: An Empirical Analysis of Some North Sea Investments
TLDR
Several interesting and statistically significant relationships were found which reveal useful information about financial modelling performance, the premia paid to acquire North Sea assets, the contribution oil and gas price uncertainty has on estimates of future financial returns and the median financial return of these North Sea Investments.

References

SHOWING 1-10 OF 17 REFERENCES
Knowing what was done: uses of a spreadsheet log file
Spreadsheet use in educational environments has become widespread, likely because of the ‡exibility and ease of use of these tools. However, they have serious shortcomings if the teacher is to
Spreadsheet Errors: What We Know. What We Think We Can Do
TLDR
To date, only one technique, cell-by-cell code inspection, has been demonstrated to be effective, and the degree to which other techniques can reduce spreadsheet errors needs to be determined.
New Guidelines For Spreadsheets
TLDR
Rules of style for text, graphics, and mathematics are examined and a new style is applied to spreadsheets, which contrasts with the existing programming style.
Spreadsheet Errors:What we know
  • 2000
Spreadsheet Check and Control
Are trademarks of Microsoft Corporation
  • Are trademarks of Microsoft Corporation
Methodology for the Audit of Spreadsheet Models Patrick O'Beirne, (2005) Spreadsheet Check and Control
  • Methodology for the Audit of Spreadsheet Models Patrick O'Beirne, (2005) Spreadsheet Check and Control
  • 2001
Corporate VBA Standards for Users who program http://www.exceluser.com/solutions/vbastds.htm Documenting Spreadsheets
  • Corporate VBA Standards for Users who program http://www.exceluser.com/solutions/vbastds.htm Documenting Spreadsheets
  • 2005
IT Governance Institute
  • IT Governance Institute
  • 2005
SCANXLS add-in is a trademark of Systems Modeling Ltd http://www.sysmod.com 02
  • SCANXLS add-in is a trademark of Systems Modeling Ltd http://www.sysmod.com 02
  • 2006
...
...