mytest > help > Part 2. MM4XL Tools > 1. Strategic Tools > Risk Analyst > 4. Functions > 1. Property Functions > mmOUTPUT()

Risk Analyst

mmOUTPUT()

This is perhaps the most important function of Risk Analyst. It is used to identify output cells in a model. The results of the simulation of output variables are reported in a separate sheet together with the respective histogram charts showing the distribution of each variable. Moreover, at least one output variable is needed to run the Sensitivity Analysis in the final report. Models without output cells do not tell the analyst very much.

The function does not take any arguments, its only job is to identify output variables and make them available as such to the simulation engine.

Like any other MM4XL function, mmOUTPUT may be typed directly in the cell. It is entered by adding it to a formula already present in the cell, which this way becomes an output variable.

Example

When entered as an output this formula

=MAX(G1:G10)

becomes

=mmOUTPUT()+MAX(G1:G10)

Lifetime license:

Price: euro

Vote this tool
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5
Email:
Gender:
M
F
Age:
Position:
Department:
Comment: