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.
41 Citations
Developing a Repeating Model Using the Structured Spreadsheet Modelling and Implementation Methodology
- Economics, BusinessArXiv
- 2016
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?
- EconomicsArXiv
- 2010
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
- Computer ScienceArXiv
- 2017
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
- Computer Science
- 2019
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
- Computer Science
- 2013
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
- Education
- 2015
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
- BusinessArXiv
- 2009
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
- PhysicsArXiv
- 2008
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
- EconomicsArXiv
- 2010
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
- Computer Science2012 28th IEEE International Conference on Software Maintenance (ICSM)
- 2012
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
- Computer ScienceInt. J. Hum. Comput. Stud.
- 1996
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
- Education
- 1996
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
- Education
- 1993
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
- Computer ScienceProceedings of HICSS-29: 29th Hawaii International Conference on System Sciences
- 1996
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.
Modeling Optimization Problems in the Unstructured World of Spreadsheets
- Computer Science
- 1997
A framework for building spreadsheet based decision models
- Economics, BusinessJ. Oper. Res. Soc.
- 1999
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
- Computer Science
- 1996
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
- EducationDecis. Support Syst.
- 1998
The role of OR specialists in 'do it yourself' spreadsheet development
- MedicineEur. J. Oper. Res.
- 2000