• Corpus ID: 28567010

Spreadsheet Components For All

@article{Paine2008SpreadsheetCF,
  title={Spreadsheet Components For All},
  author={Jocelyn Paine},
  journal={ArXiv},
  year={2008},
  volume={abs/0809.3584}
}
  • J. Paine
  • Published 21 September 2008
  • Computer Science
  • ArXiv
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 cells containing formulae: in real life, they would do useful calculations that many practitioners find hard to program, and would be rigorously tested and documented. Crucially, the user can tell the repository which cells in their spreadsheet to use for a componen's inputs and outputs. The repository will then… 
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.
Hands-Off Spreadsheets
TLDR
This paper applies to those spreadsheets which involve significant operator intervention, describes a method that has been used to improve reliability and efficiency, and reports on how it has worked in practice.

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.
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
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.
Remove non-matches -Index page, www.jpaine .org/excelsior/repository/remove_non_matches/index
  • Remove non-matches -Index page, www.jpaine .org/excelsior/repository/remove_non_matches/index
  • 2007
SF story-generator -Index, www.j-paine.org/excelsior/repository/spin/index
  • SF story-generator -Index, www.j-paine.org/excelsior/repository/spin/index
  • 2007
Spreadlet Demo form, www.j-paine.org/cgi-bin/google/filter_form
  • Spreadlet Demo form, www.j-paine.org/cgi-bin/google/filter_form
  • 2008
Spreadsheet Components, Google Spreadsheets, and Code Reuse, www.jpaine .org/dobbs/spreadlets
  • Spreadsheet Components, Google Spreadsheets, and Code Reuse, www.jpaine .org/dobbs/spreadlets
  • 2008
In Pursuit of Spreadsheet Excellence
TLDR
A simple sampling test - The Clean Sheet Test - which can be used to objectively evaluate if an organisation is in control of the spreadsheets it is using in important processes such as financial reporting.
Google Spreadsheets Adds Gadgets, a Directory of Features blog posting for 19/3/2008, googlesystem.blogspot.com/2008/03/google-spreadsheets-adds-gadgets.html 1:08pm
  • Google Spreadsheets Adds Gadgets, a Directory of Features blog posting for 19/3/2008, googlesystem.blogspot.com/2008/03/google-spreadsheets-adds-gadgets.html 1:08pm
Google Spreadsheets Adds Gadgets, a Directory of Features blog posting for 19/3/2008, googlesystem.blogspot.com/2008/03/google-spreadsheets-adds-gadgets.html 1:08pm, 20/6/08
  • Google a. Google Spreadsheets Data API developer’s guide, code.google.com/apis/spreadsheets/developers_guide_protocol.html
  • 2008
...
...