New Guidelines For Spreadsheets

Abstract

Current prescriptions for spreadsheet style specify modular separation of data, calcu1ation and output, based on the notion that writing a spreadsheet is like writing a computer program. Instead of a computer programming style, this article examines rules of style for text, graphics, and mathematics. Much 'common wisdom' in spreadsheets contradicts rules for these well-developed arts. A case is made here for a new style for spreadsheets that emphasises readability. The new style is described in detail with an example, and contrasted with the programming style.

16 pages, 5 figures, 1 table

Cited by in corpus (9)

• Spreadsheets Grow Up: Three Spreadsheet Engineering Methodologies for Large Financial Planning Models
• Spreadsheet Auditing Software
• Correctness is not enough
• Teaching Spreadsheets: Curriculum Design Principles
• In Search of a Taxonomy for Classifying Qualitative Spreadsheet Errors
• A Structured Approach to the development of Solutions in Excel
• Characteristics of Spreadsheets Developed with the SSMI Methodology
• Developing a Repeating Model Using the Structured Spreadsheet Modelling and Implementation Methodology
• Implementation Strategies for Multidimensional Spreadsheets