New Guidelines For Spreadsheets
نویسنده
چکیده
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.
منابع مشابه
Controls over Spreadsheets for Financial Reporting in Practice
Past studies show that only a small percent of organizations implement and enforce formal rules or informal guidelines for the designing, testing, documenting, using, modifying, sharing and archiving of spreadsheet models. Due to lack of such policies, there has been little research on how companies can effectively govern spreadsheets throughout their life cycle. This paper describes a survey i...
متن کاملSpreadsheet Auditing Software
It is now widely accepted that errors in spreadsheets are both common and potentially dangerous. Further research has taken place to investigate how frequently these errors occur, what impact they have, how the risk of spreadsheet errors can be reduced by following spreadsheet design guidelines and methodologies, and how effective auditing of a spreadsheet is in the detection of these errors. H...
متن کاملSpreadsheets Use in Budgeting: A Dialectic Process Theory Perspective
In this paper we describe and explain how and why spreadsheets are used in budgeting from a dialectic process theory perspective. It starts from the assumption that organizations in the new information age face a tension in a decision-making process between local and organizational levels. To describe this, budgeting is used to represent a decision-making process. To deal with the tension, busi...
متن کاملSpreadsheet Use in Budgeting: a Dialectic Process Theory Perspective
In this paper we describe and explain how and why spreadsheets are used in budgeting from a dialectic process theory perspective. It starts from the assumption that organizations in the new information age face a tension in a decision-making process between local and organizational levels. To describe this, budgeting is used to represent a decision-making process. To deal with the tension, busi...
متن کاملEnron versus EUSES: A Comparison of Two Spreadsheet Corpora
Spreadsheets are widely used within companies and often form the basis for business decisions. Numerous cases are known where incorrect information in spreadsheets lead to incorrect decisions. Such cases underline the relevance of research on the professional use of spreadsheets. Recently a new dataset became available for research, containing over 15.000 business spreadsheets that were extract...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
- CoRR
دوره abs/0807.3186 شماره
صفحات -
تاریخ انتشار 2002