• Corpus ID: 5354135

Rapid Spreadsheet Reshaping with Excelsior: multiple drastic changes to content and layout are easy when you represent enough structure

@article{Paine2008RapidSR,
  title={Rapid Spreadsheet Reshaping with Excelsior: multiple drastic changes to content and layout are easy when you represent enough structure},
  author={Jocelyn Paine and Emre Tek and Duncan Williamson},
  journal={ArXiv},
  year={2008},
  volume={abs/0803.0163}
}
Spreadsheets often need changing in ways made tedious and risky by Excel. For example: simultaneously altering many tables' size, orientation, and position; inserting cross-tabulations; moving data between sheets; splitting and merging sheets. A safer, faster restructuring tool is, we claim, Excelsior. The result of a research project into reducing spreadsheet risk, Excelsior is the first ever tool for modularising spreadsheets; i.e. for building them from components which can be independently… 

Tool-assisted Spreadsheet Refactoring and Parsing Spreadsheet Formulas

TLDR
This thesis presents an improved version of the spreadsheet refactoring tool BumbleBee, extended with six refactorings: Extract Formula, Inline Formula, Introduce Cell Name, Group References,introduce Aggregate and Introduce Conditional Aggregate.

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.

It Ain't What You View, But The Way That You View It: documenting spreadsheets with Excelsior, semantic wikis, and literate programming

I describe preliminary experiments in documenting Excelsior versions of spreadsheets using semantic wikis and literate programming. The objective is to create well-structured and comprehensive

Documenting Problem-Solving Knowledge: Proposed Annotation Design Guidelines and their Application to Spreadsheet Tools

TLDR
A 3-level model of annotation is presented and guidelines are proposed for the design of end-user programming environments supporting the explicit and literate annotation levels.

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.

A Review of Spreadsheet Error Reduction Techniques

TLDR
This paper presents a meta-analyses of the EMMARM, a large-scale probabilistic study of the determinants of infectious disease in eight operation rooms of the immune system and its consequences.

FGWM-2012 Workshop on Knowledge and Experience Management

The given paper focuses on the enhancement of product innovation by means of technologies and disciplines like knowledge management, especially knowledge networks, business intelligence, web and

References

SHOWING 1-9 OF 9 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 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".

Excelsior: Bringing the Benefits of Modularisation to Excel

TLDR
Excelsior is presented, a system for bringing modular design features to Excel that 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.

Spreadsheet algebra, 2004(a), www.j-paine.org/spreadsheet_algebra

  • Spreadsheet algebra, 2004(a), www.j-paine.org/spreadsheet_algebra

Basic Statistics, section on Crosstabulation and stub-and-banner tables

    The Making of "The Hitchhiker's Guide to the Galaxy": The Filming of the Douglas Adams Classic

    • The Making of "The Hitchhiker's Guide to the Galaxy": The Filming of the Douglas Adams Classic
    • 2005

    Basic Statistics, section on Crosstabulation and stub-and-banner tables, www.statsoft.com/textbook/stbasic

    • Basic Statistics, section on Crosstabulation and stub-and-banner tables, www.statsoft.com/textbook/stbasic

    Spreadsheet algebra, 2004(a), www.j-paine.org/spreadsheet_algebra.html 3:35pm 11/6/06

    • 2004