Name
Title | ||
|---|---|---|
Spreadsheets Grow Up: Three Spreadsheet Engineering Methodologies for Large Financial Planning Models |
Abstract | ||
|---|---|---|
Many large financial planning models are written in a spreadsheet programming
language (usually Microsoft Excel) and deployed as a spreadsheet application.
Three groups, FAST Alliance, Operis Group, and BPM Analytics (under the name
"Spreadsheet Standards Review Board") have independently promulgated
standardized processes for efficiently building such models. These spreadsheet
engineering methodologies provide detailed guidance on design, construction
process, and quality control. We summarize and compare these methodologies.
They share many design practices, and standardized, mechanistic procedures to
construct spreadsheets. We learned that a written book or standards document is
by itself insufficient to understand a methodology. These methodologies
represent a professionalization of spreadsheet programming, and can provide a
means to debug a spreadsheet that contains errors. We find credible the
assertion that these spreadsheet engineering methodologies provide enhanced
productivity, accuracy and maintainability for large financial planning models |
Year | Venue | Keywords |
|---|---|---|
2010 | Clinical Orthopaedics and Related Research | programming language,financial planning,quality control,software engineering |
Field | DocType | Volume |
Professionalization,Systems engineering,Software engineering,Computer science,Assertion,Analytics,Maintainability,Financial plan,Debugging | Journal | abs/1008.4 |
ISSN | Citations | PageRank |
Proc. European Spreadsheet Risks Int. Grp. (EuSpRIG) 2010 1-15
ISBN 978-1-905404-50-6 | 4 | 0.47 |
References | Authors | |
4 | 2 | |
Name | Order | Citations | PageRank |
|---|---|---|---|
| Thomas A. Grossman | 1 | 81 | 15.91 |
| Ozgur Ozluk | 2 | 56 | 8.92 |