Let me suggest some subjects to cover in your documentation: If you have a hard time describing what a worksheet is for, perhaps it needs reconsidering!īut this is the bare minimum Proper documentation is serious work. The tool is explained in an article I wrote some time ago: Building an Excel add-in. You can find a little tool on my website which makes this very easy. While you are at it, include a short description of the purpose of each worksheet. Studies have shown that only 33 percent of all spreadsheets have some form of manual (documentation).Īt the very least, include a table of contents with your model in which each worksheet is listed.
So keep this in mind the next time you start building a spreadsheet. On average, Spreadsheets are used by 12 different people. Many spreadsheet builders start developing a model for themselves. It is highly likely that the model you are developing is not just for you! Go ahead and do cherry-picking: use what you like, ignore what you don't. Nor do I think they must allways be followed. I'm not implying these rules are complete. I have gathered some golden rules for you which you should keep in mind when you embark on a new journey to develop a spreadsheet model. I have been developing spreadsheet models for over two decades now so I am vain enough to think I have some wisdom to share about this field of work. I certainly plan to be :-) Golden rules for developing spreadsheets Newsletter for July 2015 WelcomeĪs you are reading this I am probably somewhere nice and sunny with my feet up enjoying a great novel.
0 kommentar(er)
