|
Excel Model Maintenance
The update process
When a broker wants changes to the Excel models, all
the models are updated at once which makes sure that the
models for different companies remain similar.
The process takes about 30 seconds per file and it can
be run at night, so when analysts come to work, they have
the latest versions of the models.
Detailed update process
In practise the process goes so that first Valuatum or
broker makes the changes to a file called empty model.
The change can be e.g. a new output sheet or change in
a formula anywhere in the model.
Then someone starts a macro and selects all the models
that will be updated. The beginning of the process can
be delayed e.g. to the late night so that no analyst work
will be interrupted. When the macro finishes, all the
selected models include the latest changes.
During the process the macro copies all the input values
(history and estimates) and own sheets to the selected
empty model.
Click
here if you would like to find out about Excel integration.
|
