When you need to
do more advanced analytics on your Monte
Carlo simulation's output data, often simply
setting recalculation to "manual" is
insufficient. This may be the case
when you want to do sorting of the data, use
it in a pivot table, graphing the data, etc.
For this kind of
analysis it is best to have a clean "hard
copy" of the data, with no embedded formulas
and no RAND() functions to bother with.
To achieve this, follow these steps:
-
Create a
new worksheet or workbook where you want
to save the new "hard copy".
-
In your
Monte Carlo simulation worksheet, select
the entire output data range. You
can also include the model calculation
cells if they are relevant for your
analysis.
-
Copy the
selection to your clipboard (CTRL+C or
"EDIT - COPY").
-
Return
to the new worksheet or workbook where
you want the hard copy, and place the
cursor in the cell where you want the
upper left corner of the data range
pasted.
-
Use the
"PASTE SPECIAL..." item on the EDIT
menu, then select "Values and number
formats" and click "OK" (see
illustration below).
-
The data
will be pasted at the location of your
cursor, with all the formulas now
replaced by the numeric values they
returned. If you have placed the
hard copy in a new workbook, rather than
just a new worksheet in the active
simulation workbook, you can now
manipulate this data table for analysis
without triggering recalculations.
In either case you can work with the
data without risk of damaging your
model.
Prev
|
Contents
|
Next
|