Good design – introduction

Spreadsheets mean that things can be tried out very quickly; and changes and improvements made (almost) immediately.

However, in a ‘mature’ spreadsheet, the only changes should be to the data, with the functionality locked down and well documented.

There are various ways of doing this: eg, good naming conventions (making the spreadsheet easier to understand); clear logic (once again clarity triumphs over brevity); restricting allowed data.

These types of controls mean that the spreadsheets are less likely to go wrong; that they’ll produce the correct results; and if a change or development is required then it is much more efficient.

Locking a spreadsheet down, and restricting input can also help with security.

In the next blog I’ll talk about naming.

About spreadsheetexpertblog

Working as a computer professional since 1983, on projects varying in size from one person to multi-million pounds. Working on Excel projects since the mid 1990s.
This entry was posted in Uncategorized and tagged , , , , , , . Bookmark the permalink.

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s