8 citations · 33 across the 8 of their papers we have counts for
8 papers
Documenting Spreadsheets with Pseudo-Code: an Exercise with Cash-Flow and Loans
Jocelyn Paine
"Look before you leap"; "a stitch in time saves nine"; "more haste, less speed". Many proverbs declare the wisdom of planning before doing. We suggest how to apply this to Excel, b…
Spreadsheet Components For All
Jocelyn Paine
We have prototyped a "spreadsheet component repository" Web site, from which users can copy "components" into their own Excel or Google spreadsheets. Components are collections of…
Excelsior: Bringing the Benefits of Modularisation to Excel
Jocelyn Paine
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 c…
Rapid Spreadsheet Reshaping with Excelsior: multiple drastic changes to content and layout are easy when you represent enough structure
Jocelyn Paine, Emre Tek, Duncan Williamson
Spreadsheets often need changing in ways made tedious and risky by Excel. For example: simultaneously altering many tables' size, orientation, and position; inserting cross-tabulat…
Spreadsheet Structure Discovery with Logic Programming
Jocelyn Paine
Our term "structure discovery" denotes the recovery of structure, such as the grouping of cells, that was intended by a spreadsheet's author but is not explicit in the spreadsheet.…
It Ain't What You View, But The Way That You View It: documenting spreadsheets with Excelsior, semantic wikis, and literate programming
Jocelyn Paine
I describe preliminary experiments in documenting Excelsior versions of spreadsheets using semantic wikis and literate programming. The objective is to create well-structured and c…