Spreadsheet Programming

@inproceedings{Abraham2008SpreadsheetP,
  title={Spreadsheet Programming},
  author={Robin Abraham and Margaret M. Burnett and Martin Erwig},
  booktitle={Wiley Encyclopedia of Computer Science and Engineering},
  year={2008}
}
Spreadsheets are among the most widely used programming systems in the world. Individuals and businesses use spreadsheets for a wide variety of applications, ranging from performing simple calculations to building complex financial models. In this article, we first discuss how spreadsheet programs are actually functional programs. We then describe concepts in spreadsheet programming, followed by a brief history of spreadsheet systems. Widespread use of spreadsheets, coupled with their high… Expand
Comprehensive review for common types of errors using spreadsheets
TLDR
This research work is a comprehensive review that describes and classifies approaches on finding and fixing errors in spreadsheet in terms of definition, how they work, and kinds of errors they can find in spreadsheets. Expand
An Empirical Study on Spreadsheet Shortcomings from an Information Systems Perspective
TLDR
This paper presents the results of an empirical study on spreadsheet shortcomings from an information systems perspective, focusing particularly on how spreadsheets perform in their respective business context. Expand
The spreadsheet paradigm: a basis for powerful and accessible programming
TLDR
This paper calls for the design and implementation of several language features to enhance the expressiveness of spreadsheet programming and describes a plan for rigorous empirical studies to retain the learnability of spreadsheet Programming. Expand
Triggered expressions : event driven manipulation of cell states in spreadsheets
TLDR
This thesis proposes triggered expressions, which supplement the spreadsheet paradigm that enables event driven manipulation of cell events, and details a practical implementation within spreadsheets, and analyzes some potential use cases. Expand
AskSheet: efficient human computation for decision making with spreadsheets
TLDR
AskSheet is presented, a general system that leverages human computation to acquire the inputs to an arbitrary decision spreadsheet provided by the user, with the ability to prioritize the inputs by analyzing the user's spreadsheet formulas to calculate value of information for each of the blanks. Expand
Programming in spreadsheet: Use of cell block as an indent space in Python
TLDR
Concept of using cellblock in spreadsheet as an indent space for python source code is introduced to eliminate the problem that is causing problems in Python. Expand
Managing Student's Grades and Attendance Records using Google Forms and Google Spreadsheets
TLDR
Google Forms and Spreadsheet not only offer the more innovative ways of of managing students ‘grades and attendance records but also provide a useful platform for exploring and experimenting with Google Spreadsheet’ functions. Expand
Dynamic Translation of Spreadsheet Formulas to Problem Domain Narratives
TLDR
An algorithm is given that can be used to dynamically translate traditional spreadsheet formulas to their problem domain equivalents which are easier to understand to ease the cognitive load on the spreadsheet user and hence improving the error-prone spreadsheet development process. Expand
Appsheet : Efficient use of web workers to support decision making
The wealth of information and social resources online has raised the bar for the quality of decisions that individuals and businesses can make. Human computation and social mediums have alsoExpand
Optimization of material delivery time analysis by using Visual Basic for applications in Excel
TLDR
This report was automated for to minimize the chance of error and report preparation time, and comparison of old and automated methods indicated that suggested method took 70.86% less time as compared to the old method of preparing material delivery time analysis report. Expand
...
1
2
...

References

SHOWING 1-10 OF 51 REFERENCES
Quantitative and qualitative errors in spreadsheet development
TLDR
It is shown that spreadsheet errors can be difficult to detect during "what-if" analysis (i.e. when design parameters are changed) when the spreadsheets are not properly designed, and that most students do not take due care in designing their spreadsheets. Expand
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. Expand
Validating the unit correctness of spreadsheet programs
TLDR
XeLda, the authors' tool for unit checking Excel spreadsheets, is described, which highlights cells if their formulas process values with incorrect units and if derived units clash with unit annotations. Expand
Spreadsheet development and ‘what-if’ analysis: quantitative versus qualitative errors
TLDR
The results show that most students do not take due care in designing spreadsheets, and the techniques in teaching spreadsheets should really focus on how to design a comprehensive spreadsheet that is both easy to maintain and debug rather than just demonstrating the many features of spreadsheets. Expand
Gencel: a program generator for correct spreadsheets
TLDR
A template specification language that allows the definition of spreadsheet templates that describe possible spreadsheet evolutions and a type system for this calculus that can prevent type, reference, and omission errors from occurring in spreadsheets. Expand
Spreadsheets on trial: a survey of research on spreadsheet risks
  • R. Panko, R. Halverson
  • Computer Science
  • Proceedings of HICSS-29: 29th Hawaii International Conference on System Sciences
  • 1996
TLDR
The paper presents a framework for risks in spreadsheeting and organizes selected research findings in terms of this framework. Expand
A type system for statically detecting spreadsheet errors
TLDR
An implementation of the system that allows the user to check Microsoft Excel spreadsheets and defines the concept of a header and discusses two types of relationships between headers, namely is-a and has-a relationships. Expand
Spreadsheet Errors: What We Know. What We Think We Can Do
TLDR
To date, only one technique, cell-by-cell code inspection, has been demonstrated to be effective, and the degree to which other techniques can reduce spreadsheet errors needs to be determined. Expand
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. Expand
Enhancing the Programmability of Spreadsheets with Logic Programming
  • P. Cox
  • Computer Science
  • IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC 2007)
  • 2007
TLDR
This work proposes an enhancement in which sheets can be programmed using logic programming, and achieves a natural integration of logic-based and sheet-based computation, providing a concrete visualisation of operations that divide and assemble arrays of cells. Expand
...
1
2
3
4
5
...