• Corpus ID: 7422438

Considering Functional Spreadsheet Operator Usage Suggests the Value of Example Driven Modelling for Decision Support Systems

@article{Thorne2008ConsideringFS,
  title={Considering Functional Spreadsheet Operator Usage Suggests the Value of Example Driven Modelling for Decision Support Systems},
  author={Simon Thorne and David Ball},
  journal={ArXiv},
  year={2008},
  volume={abs/0803.0164}
}
Most spreadsheet surveys both for reporting use and error focus on the practical application of the spreadsheet in a particular industry. Typically these studies will illustrate that a particular percentage of spreadsheets are used for optimisation and a further percentage are used for 'What if' analysis. Much less common is examining the classes of function, as defined by the vendor, used by modellers to build their spreadsheet models. This alternative analysis allows further insight into the… 

Figures and Tables from this paper

Sprego, End-user Programming in Spreadsheets
TLDR
The essence of Sprego programming is provided, which is a high mathability, computer-supported real world problem solving approach in spreadsheet environments, along with its theoretical background and tools, and it is found and proved that it supports knowledge transfer between the subfields of computers sciences and other traditional sciences.
Development and Experimentation of a Software Tool for Identifying High Risk Spreadsheets for Auditing
TLDR
Conference paper published in Proceedings of the European Spreadsheets Risks Interest Group Conference on "Spreadsheet Risk Management" shows the importance of knowing how to manage spreadsheets risk in the event of a financial crisis.

References

SHOWING 1-10 OF 45 REFERENCES
Spreadsheets in business
The commercial spreadsheet is 21 years old and is now a commonplace business tool. To assess its impact on today’s modern business, this paper presents research based on a questionnaire survey of 227
Quality control in spreadsheets: a software engineering-based approach to spreadsheet development
TLDR
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.
A Novel Approach to Formulae Production and Overconfidence Measurement to Reduce Risk in Spreadsheet Modelling
TLDR
A control experiment that compares example driven modelling against traditional approaches over several progressively more difficult tests is discussed and a method for statistically analysing the problem of overconfidence in spreadsheet modellers is proposed.
Detecting Errors in Spreadsheets
TLDR
The paper presents two complementary strategies for identifying errors in spreadsheet programs, grounded on the assumption that spreadsheets are software, albeit of a different nature than conventional procedural software.
Knowledge of command usage in a spreadsheet program
TLDR
A study that examined the use of a popular spreadsheet software by 40 experienced users found that of the 505 commands that could be used, 18 accounted for over 80% of the usage and more than 50% were never used.
Factors influencing risks and outcomes in end-user development
TLDR
Results indicated that subjects using the methodology showed a significant reduction in the number of "linking errors", i.e., mistakes in creating links between values that must flow from one area of the spreadsheet to another or from one worksheet to another in a common workbook.
Spreadsheet structure inspection using low level access and visualisation
TLDR
This paper documents the approach to using new visualisations for spreadsheets, which aims to explore ways to use new visualisation tools forspreadsheets.
The Importance and Criticality of Spreadsheets in the City of London
TLDR
The author suggests that the City of London is presently exposed to significant reputational risk through the continued uncontrolled use of critical spreadsheets in the financial markets and elsewhere.
...
...