Lessons from Mission-Critical Spreadsheets

@article{Grossman2007LessonsFM,
  title={Lessons from Mission-Critical Spreadsheets},
  author={Thomas A. Grossman and Vijay Mehrotra and {\"O}zg{\"u}r {\"O}zl{\"u}k},
  journal={Commun. Assoc. Inf. Syst.},
  year={2007},
  volume={20},
  pages={60}
}
We present eighteen examples of mission-critical spreadsheets used by diverse people and organizations for application software development, financial risk management, executive information systems, sales and marketing business processes, business operations, and complex analytics. We argue the spreadsheet is a Rapid Development Language, an Integrated Development Environment, and a Fourth Generation Language, and has unusual challenges regarding source code protection. We note that intentional… 

Figures and Tables from this paper

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

It is found credible the assertion that these spreadsheet engineering methodologies provide enhanced productivity, accuracy and maintainability for large financial planning models.

Integrating Spreadsheet Engineering in a Management Science Course: A Hierarchical Approach

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.

Source Code Protection for Applications Written in Microsoft Excel and Google Spreadsheet

By critically examining the suitability of spreadsheet computer programming languages for application development, six “application development features” are identified, with source code protection being the most important.

Towards Evaluating the Quality of a Spreadsheet: The Case of the Analytical Spreadsheet Model

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.

Source Code Protection for Applications Written in Microsoft Excel and Google Spreadsheet

By critically examining the suitability of spreadsheet computer programming languages for application development, six "application development features" are identified, with source code protection being the most important.

ASP, The Art and Science of Practice: Increasing Productivity and Minimizing Errors in Operations Research Spreadsheet Models

This work examines some problem areas for spreadsheet design and programming and suggests techniques intended to increase productivity and reduce the risk of errors, especially in situations in which someone other than the original author is using or maintaining the spreadsheets.

Introduction: The Use of Spreadsheet Software in the Application of Management Science and Operations Research

The benefits of spreadsheet MS/OR are highlighted across 10 different high-impact applications, supporting powerful commercial MS/ OR add-ins and providing advantages in deploying models to clients.

Spreadsheet guardian: An approach to protecting semantic correctness throughout the evolution of spreadsheets

While collaboration on spreadsheets for maintenance tasks is common, there has been almost no support for ensuring that the spreadsheets remain correct during this process.

References

SHOWING 1-10 OF 47 REFERENCES

What we know about spreadsheet errors

Although spreadsheet programs are used for small "scratchpad" applications, they are also used to develop many large applications, and error rates are in line with those in programming and other human cognitive domains.

A Paradigm for Spreadsheet Engineering Methodologies

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.

Source Code Protection for Applications Written in Microsoft Excel and Google Spreadsheet

By critically examining the suitability of spreadsheet computer programming languages for application development, six “application development features” are identified, with source code protection being the most important.

Source Code Protection for Applications Written in Microsoft Excel and Google Spreadsheet

By critically examining the suitability of spreadsheet computer programming languages for application development, six "application development features" are identified, with source code protection being the most important.

Spreadsheet Engineering: A Research Framework

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.

Spreadsheets and Sarbanes-Oxley: Regulations, Risks, and Control Frameworks

  • R. Panko
  • Economics
    Commun. Assoc. Inf. Syst.
  • 2006
This paper examines spreadsheet risks for Sarbanes-Oxley (and other regulations) and discusses how general and IT-specific control frameworks can be used to address the control risks created by spreadsheets.

An ethnographic study of distributed problem solving in spreadsheet development

In contrast to the common view of spreadsheets as “single-user” programs, we have found that spreadsheets offer surprisingly strong support for cooperative development of a wide variety of

A Software Development Methodology for Research and Prototyping in Financial Markets

A standardized methodology for software development in the very unique industry and culture of financial markets is developed and the prototyping process presented allows the development team to deliver for review and comment intermediate-level models based upon clearly defined customer requirements.