Spreadsheet Design:
Documentation
Did you want Working with Numbers: 2007,2010,2013,2016 or
español
|
|
Spreadsheet Design:
|
|
||||
|
|
||||||
|
|
No matter how good your sheet design is, you cannot get everything on it that you might want to know later. For example, you might need to know when you created or updated the sheet's design. Your sheet may have some special features or limitations that you might forget about when modifying the sheet later. Having an explanation of the what-for's and why's can save a lot of brain pain later! This background information and the description of what you did and why is called documentation. So, what kind of information might you need to record?
For example, if you are entering data from a paper form that someone filled out, you will want the columns to be in the same order as the data on the form. That will make it easier to type in the data. Someone who is asked to revise the sheet later needs to know that! Documenting your work this way is a hassle, but it can save a lot of confusion and aggravation in the future. |
|
Project 5: Design Search Glossary Appendix |
||||
Methods of DocumentingThere are a number of ways you can record the reasons for your design choices. External: You could write it down in a notebook or on index cards. But then you'd have to remember where you put them! Would a new user have access to your notes? Internal: Having your notes in the spreadsheet somewhere would keep you from losing your notes. Which method you choose will depend on how long the notes are and how often you expect someone to need to refer to them.
A comment is attached to a specific cell. It can be displayed or invisible except for a comment indicator in the corner of the cell. If you have many notes about formulas or special considerations, using a comment makes it easy for a new user to find the notes about a specific spot on the sheet. |
|||||||
|
|
~~ 1 Cor. 10:31 ...whatever you do, do it all for the glory of God. ~~ |
