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

Daisy chains are referenced links in the model that do not go back to the original source. Daisy chains are not good because if a calculation is deleted or changed the repercussions can be difficult and time-consuming to predict and repair.

Suppose that the RPI index is used by two different costs as part of the creation of nominal cost lines in the model. Figure 3 shows the trace precedent arrows in Excel showing the two types of references that could be made. Example 1 shows that Cost 2 uses the index from Cost 1, whereas Example 2 shows that in both Cost 1 and Cost 2 the reference to the index is the same.