HomeTroubleshooting@RISK for Excel: Other IssuesResults Not as Expected (Debugging Tips)

8.1. Results Not as Expected (Debugging Tips)

Applies to: @RISK 5.x–7.x

"Errors" that really aren't?
Error message appears?
Output has just one value?
No values to graph?
Calculations seem wrong
Visual Basic errors?

See also:
"No inputs found that affect this output" instead of Tornado Graph

My simulation results in @RISK don't seem right. Can you recommend any techniques for finding my mistakes in my model?

Consider the possibility that your model is actually behaving correctly. We're frequently asked about these "errors", but they make sense when they're explained:

If an error message appears, there's probably an explanation and a fix in the Troubleshooting section of this Knowledge Base. Type a few key words in the search window at the bottom of this page.

My output graph is just a vertical line, and the statistics table shows minimum = mean = maximum.

This output has the same value in every iteration. Most likely, that means none of your input distributions are precedents of this output.

My output shows "no values to graph", or it shows a graph but the statistics table shows that some iterations were errors.

Either way, here are some tools:

Numbers seem wrong in my calculated results.

Here are some suggestions. (Save the workbook under a new name before you make debugging-type edits.)

I think my worksheets are okay, but my VBA code isn't working right.

Debugging Visual Basic for Applications code can be tricky. Here are some hints:

Can you look at my model and tell me what's wrong?

We're sorry, but the scope of free Tech Support services doesn't include debugging customer models. If you have a question about how a particular @RISK feature works, or if @RISK is not behaving correctly, Tech Support will gladly help. If you want a more detailed review or audit of your model, please ask your Palisade sales manager to book some time with one of our custom developers or industry consultants.

Additional keywords: Precedent and dependent cells, precedent and dependant cells

Last edited: 2018-03-29

This page was: Helpful | Not Helpful