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

As the analyst works with the model they are sure to be carrying out changes to inputs to discover how related outputs are affected. If these changes become repetitious and involved there grows a need to see both the inputs and the results in a single place rather than across sheets.

My normal way of dealing with this is to temporarily bring the inputs and outputs to a sheet called the control panel. Figure 13 shows a simple control panel with a mixture of outputs, charts and a yellow-shaded input. By changing the input the effect on the outputs and charts can be quickly gauged. The analyst can build up a feeling for the movements in model outputs and thus better understand the dynamics of the project or company finances.