• Corpus ID: 8944849

Excelsior: Bringing the Benefits of Modularisation to Excel

@article{Paine2008ExcelsiorBT,
  title={Excelsior: Bringing the Benefits of Modularisation to Excel},
  author={Jocelyn Paine},
  journal={ArXiv},
  year={2008},
  volume={abs/0803.2027}
}
  • J. Paine
  • Published 13 March 2008
  • Computer Science
  • ArXiv
Excel lacks features for modular design. Had it such features, as do most programming languages, they would save time, avoid unneeded programming, make mistakes less likely, make code-control easier, help organisations adopt a uniform house style, and open business opportunities in buying and selling spreadsheet modules. I present Excelsior, a system for bringing these benefits to Excel. 
User Defined Spreadsheet Functions in Excel
TLDR
This paper presents a method to create a limited form of UDSFs in Excel without any use of VBA, which utilizes what-if data tables to execute the same part of a worksheet several times, thus turning it into a reusable function definition.
Rapid Spreadsheet Reshaping with Excelsior: multiple drastic changes to content and layout are easy when you represent enough structure
TLDR
Excelsior, the first ever tool for modularising spreadsheets, represents spreadsheets in a way that makes these components explicit, separates them from layout, and allows both components and layout to be changed without breaking dependent formulae.
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.
Automated model-based spreadsheet debugging
TLDR
Several new algorithmic enhancements of the general MBD approach are combined in this thesis to allow spreadsheet users to debug their spreadsheets and to efficiently find the reason of the observed unexpected output values.
Spreadsheet Components For All
TLDR
A "spreadsheet component repository" Web site, from which users can copy "components" into their own Excel or Google spreadsheets, where instead of subroutines, the library contains such components.
Maintaining Liveness in a Spreadsheet with Logic Programming
TLDR
This paper addresses the problem of maintaining liveness in L-sheets, a recently proposed extension to spreadsheets that is augmented with a form of visual logic programming in which term unification is replaced by array unification, providing both improved programmability and a means to specify the high-level structure of sheets.
Structuring Spreadsheets with the "Lish" Data Model
TLDR
This work explores a novel data model (called the “lish”) that could form an alternative to the traditional grid in a spreadsheet-like environment, based on cells organised into nested lists, in each of which the user may optionally employ a template to prototype repeating structures.
Toward model-based debugging of spreadsheet programs
TLDR
This paper proposes to apply model-based diagnosis techniques for the systematic localization of faults in spreadsheet programs using an extended Hitting-Set algorithm and user-specified or historical test cases and assertions to calculate possible error causes.
The 'lish': a data model for grid free spreadsheets
TLDR
A “lish calculus” is developed, an extension to vector arithmetic for hierarchical structures that provides a concise notation for calculations with lishes that simplifies the usual spreadsheet formula expressions, and enables the machine to interpret them consistently with the context in which they are located.
...
...

References

SHOWING 1-10 OF 18 REFERENCES
A Toolkit for Scalable Spreadsheet Visualization
TLDR
This paper presents a toolkit for spreadsheet visualization based on logical areas, semantic classes and data modules, which can process large, industry scale spreadsheet programs in reasonable time and is tightly integrated with its host spreadsheet system.
Spreadsheet Structure Discovery with Logic Programming
TLDR
The objective is an "intelligent structure monitor" to run beside Excel, allowing users to reconfigure spreadsheets to the representational needs of the task at hand, and describes a formulation of spreadsheet reverse-engineering based on "arrows".
Using Layout Information for Spreadsheet Visualization
This paper extends a spreadsheet visualization technique by using layout information. The original approach identifies logically or semantically related cells by relying exclusively on the content of
Parameterized programming and software architecture
  • J. Goguen
  • Computer Science
    Proceedings of Fourth IEEE International Conference on Software Reuse
  • 1996
TLDR
An approach to software architecture based on concepts from parameterized programming, particularly its language of "module expressions", is discussed, to ease the development of large systems and to make reuse more effective in practice.
Principles of Programming Languages
  • Gilles Dowek
  • Computer Science
    Undergraduate Topics in Computer Science
  • 2009
TLDR
Imperactive Core explains how to program with Lists, Records, Objects, and Dynamic Data Types to solve the challenge of dynamic data types in programming with Trees.
Sheaf Semantics for Concurrent Interacting Objects
  • J. Goguen
  • Computer Science
    Math. Struct. Comput. Sci.
  • 1992
TLDR
Concepts from sheaf theory are used to explain phenomena in concurrent systems, including object, inheritance, deadlock, and non-interference, as used in computer security, not only to concurrent object oriented systems, but also to systems of differential equations, electrical circuits, hardware description languages, and much more.
Simple Cellular Automata on a Spreadsheet
TLDR
This paper illustrates how simple CAs can be run on a spreadsheet, using the diffusion of a product innovation as an example.
A Categorical Manifesto
This paper tries to explain why and how category theory is useful in computing science, by giving guidelines for applying seven basic categorical concepts: category, functor, natural transformation,
...
...