• Corpus ID: 13404113

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

@article{Paine2008ItAW,
  title={It Ain't What You View, But The Way That You View It: documenting spreadsheets with Excelsior, semantic wikis, and literate programming},
  author={Jocelyn Paine},
  journal={ArXiv},
  year={2008},
  volume={abs/0802.3478}
}
  • J. Paine
  • Published 23 February 2008
  • Computer Science
  • ArXiv
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 documentation, easy to use by those unfamiliar with the spreadsheets documented. I discuss why so much documentation is hard to use, and briefly explain semantic wikis and literate programming; although parts of the paper are Excelsior-specific, these sections may be of more general interest. 
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.
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.

References

SHOWING 1-10 OF 16 REFERENCES
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.
A Rational Design Process: How and Why to Fake It
  • TAPSOFT, Vol.2
  • 1985
How to Write More Clearly, Think More Clearly, and Learn Complex Material More Easily
  • How to Write More Clearly, Think More Clearly, and Learn Complex Material More Easily
  • 2002
Wikipedia entry for Inverted pyramid " . en.wikipedia.org/wiki
  • Wikipedia entry for Inverted pyramid " . en.wikipedia.org/wiki
Advertisement for Literate Programming, www-cs-faculty.stanford.edu/~knuth/lp
  • Advertisement for Literate Programming, www-cs-faculty.stanford.edu/~knuth/lp
ZGRViewer, a GraphViz/DOT Viewer, zvtm.sourceforge.net/zgrviewer
  • ZGRViewer, a GraphViz/DOT Viewer, zvtm.sourceforge.net/zgrviewer
Literate Programming, CSLI Lecture Notes
  • Literate Programming, CSLI Lecture Notes
  • 1992
The DOT Language, www.graphviz.org/doc/info/lang
  • The DOT Language, www.graphviz.org/doc/info/lang
Semantic MediaWiki. wiki.ontoworld.org/index
  • Semantic MediaWiki. wiki.ontoworld.org/index
ZGRViewer , a GraphViz / DOT Viewer , zvtm
  • 2007
...
...