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

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

2010-08-24

arxiv.org/abs/1008.4174v1

Proc. European Spreadsheet Risks Int. Grp. (EuSpRIG) 2010 1-15 ISBN 978-1-905404-50-6

Computer Science

Software Engineering

14 pages

Scientific paper

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

Affiliated with

Also associated with

No associations

Rating

Spreadsheets Grow Up: Three Spreadsheet Engineering Methodologies for Large Financial Planning Models does not yet have a rating. At this time, there are no reviews or comments for this scientific paper.

If you have personal experience with Spreadsheets Grow Up: Three Spreadsheet Engineering Methodologies for Large Financial Planning Models, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Spreadsheets Grow Up: Three Spreadsheet Engineering Methodologies for Large Financial Planning Models will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFWR-SCP-O-524598