May 21

Spreadsheet Guidelines and Best Practices

Spreadsheet Guidelines and Best Practices

Today, I found this journal article, The role of OR [Operations Research] specialists in ‘do it yourself’ spreadsheet development, from the European Journal of Operational Research, by John S Edwards, Paul N Finlay, John M Wilson. The article outlines 20 Guidelines for Spreadsheet Development and 21 Best Practices Points, which I excerpt below.

Guidelines for Spreadsheet Development

Fig. 2. Guidelines for spreadsheet development.

Best Practices for Spreadsheet Development

Fig. 3. Best Practices Points. 
My favorite point is #14 from the list of Best Practices: 

Never input the same piece of data more than once.
This rule reminds me of the 17th rule of composition from the Elements of Style: “Omit needless words.” Perhaps Best Practice-point #14 can be rewritten as “Omit needless data.” 
_____
Figure 2 and Figure 3, from John S Edwards, Paul N Finlay, John M Wilson, The role of OR specialists in ‘do it yourself’ spreadsheet development, European Journal of Operational Research, Volume 127, Issue 1, 16 November 2000, Pages 14-27, ISSN 0377-2217, 10.1016/S0377-2217(99)00331-8.

Loved this? Spread the word


About the Author

Jordan Goldmeier

Related posts

Oz’s Excel Tip: Keep a Workbook for Random Data in Excel

Read More

Microsoft Excel Visio Data Visualizer Add In for Excel: A Quick Guide

Read More

Highlighted Timeline Chart in Excel Without VBA: Raw and Uncut

Read More

Make Your Excel Spreadsheet into a Bitmap Image With This Excel Magic Trick

Read More
{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Subscribe to our newsletter now!

>