• Corpus ID: 5780747

Breaking Out of the Cell: On The Benefits of a New Spreadsheet User-Interaction Paradigm

@article{Hellman2008BreakingOO,
  title={Breaking Out of the Cell: On The Benefits of a New Spreadsheet User-Interaction Paradigm},
  author={Ziv Hellman},
  journal={ArXiv},
  year={2008},
  volume={abs/0803.1875}
}
  • Ziv Hellman
  • Published 12 March 2008
  • Computer Science
  • ArXiv
Contemporary spreadsheets are plagued by a profusion of errors, auditing difficulties, lack of uniform development methodologies, and barriers to easy comprehension of the underlying business models they represent. This paper presents a case that most of these difficulties stem from the fact that the standard spreadsheet user-interaction paradigm - the 'cell-matrix' approach - is appropriate for spreadsheet data presentation but has significant drawbacks with respect to spreadsheet creation… 
A Structured Approach to the development of Solutions in Excel
TLDR
This paper considers the use of controversial or lesser-used techniques to create a coherent solution strategy in which the problem is solved by a sequence of formulas resembling the steps of a programmed language.
Will Dynamic Arrays finally change the way Models are built?
TLDR
The thesis that fully dynamic arrays adoption within a more professional development environment could replace traditional techniques where solution integrity is important is examined.

References

SHOWING 1-10 OF 17 REFERENCES
Ensuring Spreadsheet Integrity with Model Master
TLDR
The Model Master (MM) language for describing spreadsheets, and tools for converting MM programs to and from spreadsheet, which makes possible a new style of development, in which spreadsheets are generated from textual specifications.
Spreadsheet Assurance by "Control Around" is a Viable Alternative to the Traditional Approach
TLDR
Not all distinct formulas are audited separately, but the relationship between input data and output data of a spreadsheet is audited through comparison with a shadow model developed in a modelling language.
Spreadsheet Accuracy Theory
TLDR
The analysis of academic literature suggests three categories of issues spreadsheet developers must address to create more accurate spreadsheets including: planning and design; formula complexity; and testing/debugging.
RMM: a methodology for structured hypermedia design
TLDR
The Relationship Management Data model (RMDM) and the Relationship Management (RMM) methodology are presented and design activities are addressed within the first three steps of the methodology.
Stop that Subversive Spreadsheet!
This paper documents the formation of the European Spreadsheet Risks Interest Group (EuSpRIG www.eusprig.org) and outlines some of the research undertaken and reported upon by interested parties in
Design of Everyday Things
Revealing how smart design is the new competitive frontier, this innovative book is a powerful primer on how--and why--some products satisfy customers while others only frustrate them.
The Ecological Approach to Visual Perception
Contents: Preface. Introduction. Part I: The Environment To Be Perceived.The Animal And The Environment. Medium, Substances, Surfaces. The Meaningful Environment. Part II: The Information For Visual
The theory of affordances
A small matter of programming
The spreadsheet interface: A basis for end user programming
...
...