• Corpus ID: 9903071

Spreadsheet Engineering: A Research Framework

@article{Grossman2007SpreadsheetEA,
  title={Spreadsheet Engineering: A Research Framework},
  author={Thomas A. Grossman},
  journal={ArXiv},
  year={2007},
  volume={abs/0711.0538}
}
Spreadsheet engineering adapts the lessons of software engineering to spreadsheets, providing eight principles as a framework for organizing spreadsheet programming recommendations. Spreadsheets raise issues inadequately addressed by software engineering. Spreadsheets are a powerful modeling language, allowing strategic rapid model change, and enabling exploratory modeling. Spreadsheets users learn slowly with experience because they focus on the problem domain not programming. The… 

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.

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.

Research Strategy and Scoping Survey on Spreadsheet Practices

A research strategy for creating and deploying prescriptive recommendations for spreadsheet practice and a scoping survey to gather non-anecdotal data on spreadsheet usage is proposed.

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.

Spreadsheet Use and Programming Experience: An Exploratory Survey

There are significant correlations between self-reported formula experience, programming experience, and overall spreadsheet experience and the implications for spreadsheet research and end-user programming research, more generally.

Lessons from Mission-Critical Spreadsheets

It is concluded that spreadsheets are vitally important to business, and merit sustained research to discover techniques to enhance quality, productivity, and maintainability.

Test-driven development: can it work for spreadsheets?

Through a set of case studies it is demonstrated that Test-Driven Development can be applied to the development of spreadsheets and a supporting tool under development by the authors is documented along with proposed research to determine the effectiveness of the methodology and the associated tool.

Evolution of model-driven spreadsheets

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.

Teaching Business Modeling Using Spreadsheets

With its simple intuitive interface, direct interactivity, and universal presence, the humble spreadsheet has made business modeling much easier and has been considered by many analysts as the tool of choice for exploring business opportunities.

Investigating the Potential of Test-Driven Development for Spreadsheet Engineering

Through a pair of case studies it is demonstrated that Test-Driven Development can be applied to the development of spreadsheets and a supporting tool under development by the authors is documented along with proposed research to determine the effectiveness of the methodology and the associated tool.
...

References

SHOWING 1-10 OF 23 REFERENCES

Quality control in spreadsheets: a software engineering-based approach to spreadsheet development

The principles and techniques of tree-based formula representation, unique definition of spreadsheet elements, and separation of data and operations are among the main features explored.

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

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.

Applying Code Inspection to Spreadsheet Testing

  • R. Panko
  • Business
    J. Manag. Inf. Syst.
  • 1999
Findings were that subjects were overconfident when inspecting alone, that certain types of errors are especially difficult to detect, and that the benefits of the group phase is greatest for these difficult-to-detect type of errors.

Rapid Development: Taming Wild Software Schedules

From the Book: Corporate and commercial software development teams all want solutions for one important problem--how to get their high-pressure development schedules under control. In Rapid

Applying the CobiT Control Framework to Spreadsheet Developments

This paper illustrates how spreadsheet risk and control issues can be mapped onto the CobiT framework and thus brought to managers attention in a familiar format.

Code complete - a practical handbook of software construction, 2nd Edition

This book focuses on programming technique rather than the requirements of a specific programming language or environment, and Topics include: front-end planning, applying good design techniques to construction, using data effectively, using common and advanced control structures, secrets of self-documenting code, testing and debugging techniques.

A Small Matter of Programming: Perspectives on End User Computing

From the Publisher: A Small Matter of Programming asks why it has been so difficult for end users to command programming power and explores the problems of end-user-driven application development

The Purpose of Mathematical Programming is Insight, Not Numbers

This paper advocates the use of highly simplified analytic models to help explain the “whys” behind the solutions of conventional mathematical programming models and a methodological approach is described which permits the development of richer insights than would otherwise be possible.

Serious Play: How the World's Best Companies Simulate to Innovate

This chapter discusses Prototyping Paybacks, Preparing for Surprise, and An Interaction Way of Knowledge: Evolving with The authors' Prototypes.