Читать книгу See-Through Modelling - Dominic Robertson - Страница 52

I like to keep the formulae as simple as possible.

There is a frequently encountered and often laudable human desire to achieve perfection. When considering Excel formulae it is possible that some combination of formulae will do what we want, so this becomes the end goal. Experience then shows us that the model can suffer in a number of ways that can be hugely detrimental to the purpose of the model. Here is a list of those areas:

 complex formulae are harder to understand and maintain

 complex formulae copied and repeated can substantially add to the file size

 complex formulae can cause unforeseen Excel problems such as inter-sheet link excess that then causes a loss of basic Excel functionality

 complex formulae need to be properly understood to avoid unforeseen behaviour as this can be very time consuming to solve.