Part 2. MM4XL Tools > 1. Strategic Tools > Risk Analyst > 1. How to run Risk Analyst > 1. Model Building > Locked cells

Risk Analyst

Locked cells

Locked cells

When there are many variable cells in a model, either outputs or another kind, we can use the property function mmLOCK to avoid collecting the simulation results for one variable. This way, the simulation runs faster, the results can be printed more quickly, the report looks less crowded, and it is easier to understand. Adding the Lock property to a cell would result, for example, in the following formula:

=mmNORMAL(50, 5) +mmLOCK()

The formula above will still work in Excel, but it will not be accounted for by the simulation runs and it will not be shown in the final report.

Lifetime license:
MM4XL All Tools
Price: euro 238.00

Vote this tool
335 votes: vote vote vote vote vote
5 stars:
133
4 stars:
178
3 stars:
16
2 stars:
6
1 star:
2
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5
Email:
Gender:
M
F
Age:
Position:
Department:
Comment: