• Corpus ID: 856959

A Paradigm for Spreadsheet Engineering Methodologies

@article{Grossman2008APF,
  title={A Paradigm for Spreadsheet Engineering Methodologies},
  author={Thomas A. Grossman and {\"O}zg{\"u}r {\"O}zl{\"u}k},
  journal={ArXiv},
  year={2008},
  volume={abs/0802.3919}
}
Spreadsheet engineering methodologies are diverse and sometimes contradictory. It is difficult for spreadsheet developers to identify a spreadsheet engineering methodology that is appropriate for their class of spreadsheet, with its unique combination of goals, type of problem, and available time and resources. There is a lack of well-organized, proven methodologies with known costs and benefits for well-defined spreadsheet classes. It is difficult to compare and critically evaluate… 
View PDF on arXiv
28 Citations
Highly Influential Citations
3
Background Citations
9
Methods Citations
9

28 Citations

Citation Type

Citation Type

Spreadsheets Grow Up: Three Spreadsheet Engineering Methodologies for Large Financial Planning Models
TLDR
It is found credible the assertion that these spreadsheet engineering methodologies provide enhanced productivity, accuracy and maintainability for large financial planning models.
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.
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.
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.
Towards a Spreadsheet Engineering
TLDR
The need to rigorously lay the foundations of a spreadsheet engineering discipline is proposed, since multiple research teams would be required to tackle such a big task.
IMPROVEMENT OF SPREADSHEET SKILLS IN BUSINESS- ORIENTED UNIVERSITY COURSES
TLDR
Based on a selection of current best practices, this paper presents several proposals for updating/innovating courses related to spreadsheet development, and suggests that spreadsheet error prevention and reduction techniques are used rarely.
Automated Spreadsheet Development
TLDR
The challenge is to find a way of creating spreadsheets which will preserve the benefit of their power and flexibility while making their creation more transparent and safer.
A Spreadsheet Scenario Analysis Technique That Integrates with Optimization and Simulation
TLDR
A tutorial for a better scenario analysis technique that can be programmed into an existing spreadsheet in a matter of minutes and integrated with the Excel Solver to allow for rapid optimization of multiple scenarios and with the Crystal Ball add-in for Monte Carlo simulation.
ExSched: Solving Constraint Satisfaction Problems with the Spreadsheet Paradigm
TLDR
The development of a general tool called ExSched, implemented as a plug-in for Microsoft Excel, for solving a class of constraint satisfaction problems, which acts as an interface between CLP(FD) and Microsoft Excel and thus enables even novice users to solve constraints satisfaction problems interactively.
Analyzing Supply Chains at HP Using Spreadsheet Models
TLDR
Why and how spreadsheets are used to analyze supply chains are reviewed and some of the ways of overcoming their limitations are discussed.
...
...

References

SHOWING 1-10 OF 17 REFERENCES
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.
A methodology for testing spreadsheets
TLDR
A testing methodology that adapts data flow adequacy criteria and coverage monitoring to the task of testing spreadsheets is presented and it is found that test suites created according to the methodology detected, on average, 81% of the faults in a set of faulty spreadsheets, significantly outperforming randomly generated test suites.
Research Strategy and Scoping Survey on Spreadsheet Practices
TLDR
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.
What we know about spreadsheet errors
TLDR
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.
Modeling Optimization Problems in the Unstructured World of Spreadsheets
Twinkling Lights and Nested Loops: Distributed Problem Solving and Spreadsheet Development
The Art of Modeling with Spreadsheets: Management Science, Spreadsheet Engineering, and Modeling Craft
TLDR
This book presents a meta-modelling framework that automates the very labor-intensive and therefore time-heavy and expensive process of designing and implementing models for solving problems.
Advanced Spreadsheet Design Using Lotus Macros
TLDR
This book presents full problem analyses of input and output components, layout, testing, and documentation, and readers learn how to fully exploit the Lotus macro language in the creation and application of spreadsheets.
Applying Code Inspection to Spreadsheet Testing
  • R. Panko
  • Business
    J. Manag. Inf. Syst.
  • 1999
TLDR
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…
...
...