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} }
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.
2 Citations
Documenting Problem-Solving Knowledge: Proposed Annotation Design Guidelines and their Application to Spreadsheet Tools
- Computer ScienceArXiv
- 2009
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
- Computer ScienceArXiv
- 2008
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
- PhysicsArXiv
- 2008
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.
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