• Corpus ID: 22588325

New Guidelines For Spreadsheets

@article{Raffensperger2008NewGF,
  title={New Guidelines For Spreadsheets},
  author={John F. Raffensperger},
  journal={ArXiv},
  year={2008},
  volume={abs/0807.3186}
}
This article examines rules of style for text, graphics, and mathematics and applies these rules to spreadsheets. The article describes the new style in detail with an example and contrasts the new style with the existing programming style. 

Figures and Tables from this paper

Developing a Repeating Model Using the Structured Spreadsheet Modelling and Implementation Methodology
TLDR
This paper presents a conceptual modelling approach that takes advantage of similarities in variables and formulas and leads the spreadsheet developer to the formula Revenues = Price * Quantity, and presents simple but strict rules to implement the spreadsheet.
Spreadsheet good practice: is there any such thing?
TLDR
The author urges that EuSpRIG does not succumb to internal or external pressures to champion a particular set of "best practices", because no such set is optimal in all spreadsheet applications.
Characteristics of Spreadsheets Developed with the SSMI Methodology
TLDR
The major characteristics of the spreadsheets developed using the SSMI methodology are described and how they contribute to reduce many error causing factors are shown.
The 'lish': a data model for grid free spreadsheets
TLDR
A “lish calculus” is developed, an extension to vector arithmetic for hierarchical structures that provides a concise notation for calculations with lishes that simplifies the usual spreadsheet formula expressions, and enables the machine to interpret them consistently with the context in which they are located.
Analyzing and Visualizing Spreadsheets
TLDR
This dissertation aims at developing methods to support spreadsheet users to understand, update and improve spreadsheets and found that methods from software engineering can be applied to spreadsheets very well, and that these methods support end-users in working with spreadsheets.
Textbooks for Responsible Data Analysis in Excel
TLDR
There is a need to re-evaluate the teaching approaches being used in office application courses, and a wide range of approaches are shown, and none of the 10 books fully cover the methodologies needed to create well-rounded Excel data analysts.
The Lookup Technique to Replace Nested-IF Formulas in Spreadsheet Programming
TLDR
The "lookup technique" is investigated as an alternative to nested-IF formulas, its benefits for testing and auditing, and its limitations are described.
Correctness is not enough
TLDR
This paper presents the key criteria for judging a spreadsheet and discusses how those criteria can be achieved.
Spreadsheets Grow Up: Three Spreadsheet Engineering Methodologies for Large Financial Planning Models
TLDR
It is found credible the assertion that these spreadsheet engineering methodologies provide enhanced productivity, accuracy and maintainability for large financial planning models.
Refactoring meets spreadsheet formulas
  • Sandro Badame, Danny Dig
  • Computer Science
    2012 28th IEEE International Conference on Software Maintenance (ICSM)
  • 2012
TLDR
Seven refactorings for spreadsheet formulas implemented in RefBook, a plugin for Microsoft Excel are presented, showing that users prefer the improved quality of refactored formulas, RefBook is faster and more reliable than manual refactoring, and the refactoring are widely applicable.
...
...

References

SHOWING 1-10 OF 36 REFERENCES
Tools for spreadsheet auditing
  • J. Davis
  • Computer Science
    Int. J. Hum. Comput. Stud.
  • 1996
TLDR
Two interactive tools which aid in investigating data dependencies, an on-line flowchart-like diagram and a tool which represents dependencies by drawing arrows among cells on the display of the spreadsheet are developed and evaluated.
The Teachers' Forum: Management Science with Spreadsheets for MBAs at Indiana University
A highly successful spreadsheet-based management science course for MBA students at Indiana University deals mainly with simulation and mathematical optimization with spreadsheet solvers and includes
Handbook of writing for the mathematical sciences
TLDR
The author's tools and recommended reading for writers and research, including TeX and LaTeX, and aids and resources for writing and research are provided.
Hitting the wall: errors in developing and debugging a "simple" spreadsheet model
  • R. Panko
  • Computer Science
    Proceedings of HICSS-29: 29th Hawaii International Conference on System Sciences
  • 1996
TLDR
Undergraduate MIS business students developed and debugged a spreadsheet model from a word problem that consisted of a bid to build a wall to address the concern that past spreadsheet experiments may have used problems that were too difficult or that required domain knowledge that subjects did not have.
Electronic spreadsheet structures
  • N. Archer
  • Mathematics, Computer Science
    Comput. Oper. Res.
  • 1989
Modeling Optimization Problems in the Unstructured World of Spreadsheets
A framework for building spreadsheet based decision models
  • D. Mather
  • Economics, Business
    J. Oper. Res. Soc.
  • 1999
TLDR
This paper presents an example of the type of framework that can be used when developing spreadsheet based business models and encourages the efficient development of more effective models that are easy to use and easy to modify.
How to Make Spreadsheets Error-Proof
TLDR
It's possible to make spreadsheets not only virtually error-proof, but easier to use and more understandable, and to exploit the three-dimensional capabilities of today's popular spreadsheets--using multiple worksheets in the same file.
Hitting the wall: errors in developing and code inspecting a 'simple' spreadsheet model
...
...