• Corpus ID: 14244783

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

@article{Grossman2010SpreadsheetsGU,
  title={Spreadsheets Grow Up: Three Spreadsheet Engineering Methodologies for Large Financial Planning Models},
  author={Thomas A. Grossman and {\"O}zg{\"u}r {\"O}zl{\"u}k},
  journal={ArXiv},
  year={2010},
  volume={abs/1008.4174}
}
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… 
Alternative Spreadsheet Model Designs for an Operations Management Model Embedded in a Periodic Business Process
We present a widely-used operations management model used in supply and distribution planning, that is typically embedded in a periodic business process that necessitates model modification and
Controls over Spreadsheets for Financial Reporting in Practice
TLDR
It is indicated that there are problems in all stages of a spreadsheet’s life cycle and several important areas for future research are suggested.
Towards Evaluating the Quality of a Spreadsheet: The Case of the Analytical Spreadsheet Model
TLDR
This work proposes for discussion a framework and terminology for evaluating the quality of analytical spreadsheet models, which categorizes and generalizes the findings of previous work on the more narrow domain of financial spreadsheet models.
Exploring Spreadsheet Use and Practices in a Technologically Constrained Setting
TLDR
Findings indicate that the proliferation of spreadsheets in the organization has provided an enabling environment for business automation and there is ample room for improvement in many areas such as implementation of comprehensive policies and regulations governing spreadsheet development processes and adoption.
From Good Practices to Effective Policies for Preventing Errors in Spreadsheets
TLDR
An expert-based, retrospective approach to the identification of good practices for spreadsheets is proposed, based on an evaluation loop that cross-validates the findings of human domain experts against rules implemented in a semi-automated spreadsheet workbench, taking into account the context in which the spreadsheets are used.
Evolution of model-driven spreadsheets
TLDR
The strategy described is based on a model-driven approach, and is achieved by embedding spreadsheet models within spreadsheets themselves, which facilitates the establishment and maintenance of a consistency relationship between models and instances throughout the spreadsheet development life cycle.
A Case Study of Spreadsheet Use within the Finance and Academic Registry units within a Higher Education Institution
TLDR
The results show a large volume of spreadsheets being created and used, that the profile of spreadsheet developers is typical of other studies of spreadsheet use and the need for the organisation to have clear principles and guidelines for the development of spreadsheet models in the organisation.
Accountants’ Perceptions of the Use of Excel Spreadsheet in Financial Reporting: A Survey of Accounts Personnel in Manufacturing Firms
Spreadsheet, a widely accepted critical business application tool with its benefits and unavoidable inadequacies is relied on by many accountants for financial reporting and operational processes
Textbooks for Responsible Data Analysis in Excel
TLDR
There is a need to re-evaluate the teaching approaches being used in office application courses, and a wide range of approaches are shown, and none of the 10 books fully cover the methodologies needed to create well-rounded Excel data analysts.
...
...

References

SHOWING 1-10 OF 29 REFERENCES
Lessons from Mission-Critical Spreadsheets
TLDR
It is concluded that spreadsheets are vitally important to business, and merit sustained research to discover techniques to enhance quality, productivity, and maintainability.
Integrating Spreadsheet Engineering in a Management Science Course: A Hierarchical Approach
TLDR
Embracing spreadsheet engineering provides a magnificent opportunity for management science instructors to increase relevance and student satisfaction while increasing the likelihood of management science application by the authors' graduates.
A Paradigm for Spreadsheet Engineering Methodologies
TLDR
This paradigm provides a framework for evaluation, comparison, and selection of methodologies, and a list of essential elements for developers or codifiers of new methodologies.
Spreadsheet Engineering: A Research Framework
TLDR
Spreadsheet engineering adapts the lessons of software engineering to spreadsheets, providing eight principles as a framework for organizing spreadsheet programming recommendations to overcome the heterogeneity of spreadsheet users.
Guide to Business Modelling
This is the new, fully updated and expanded edition of the definitive guide to creating business models that can be used to evaluate anything from a modest business proposal to a major acquisition.
Practical Financial Modelling: A Guide to Current Practice
Context: Introduction Definitions Descriptions Common approaches Structure Inputs Workings Outputs Variations Support Documentation Navigation Content: Formulae Range names Corkscrews Masks and
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.
Code Complete, 2 nd Edition
  • Code Complete, 2 nd Edition
  • 2004
...
...