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?

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.

One common problem is an output graph showing just a vertical line, and the statistics showing minimum = mean = maximum. In other words, this output has the same value in every iteration. Most likely, that means none of your input distributions are precedents of this output.

Maybe you have an output where the graph window shows that there were no values to graph. In this case, look at the number of errors in the statistics, and you'll probably see that it equals the number of iterations. Or maybe the statistics grid shows a number of errors above 0, and you don't know why @RISK is finding errors during some iterations. Either way, here are some tools:

If you have calculations that seem wrong, or aren't working as expected, 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, we'll gladly answer it for you.

Last edited: 2017-05-16

This page was: Helpful | Not Helpful