RiskAMP.Scale

RiskAMP Support Functions

This function creates a scale, in an array of cells, including the values Minimum - Maximum. It’s similar to how the RiskAMP.HistogramTable function creates a scale for the histogram, but you specify the range of values.

The scale attempts to use human-friendly steps, breaking on 1, 2.5, 5, 10, and so on. As a result the actual minimum and maximum may be different than your input values, but the scale will always fully contain the desired range.

This function is intended to be used when you want to compare several random values in your spreadsheet. You can’t use the standard histogram function in that case, because each histogram would have a different set of buckets.

You can use this function to create a scale, and then use the SimulationInterval function to create tables for each random value. That allows for a comparison across variables with the same bucket ranges.

This is an array function. You must enter it into a range of cells using Ctrl + Shift + Enter. We can’t use Excel’s spill function, because we rely on the shape of the range to determine the number of buckets.

Example

Here’s an example of using RiskAMP.Scale with two different ranges:

In the smaller range, you can see that the scale covers more than the full range, in order to use human-friendly buckets. The larger scale covers the full range with integers.

Try changing the min or max value to see what happens to the scales. Depending on the range, you may need to change the number format (increase or decrease decimal places).