search

pyscripter / XLRisk

Excell addin for performing Monte Carlo simulation
MIT License
112 stars 24 forks source link

Input Variable Missing from Correlations and Risk Tornado Diagram #15

Closed vinunderwood closed 8 months ago

vinunderwood commented 8 months ago

I created a workbook with 4 input variables. I ran a simulation that appears to be successful. However, on the Risk Results tab only the first 3 input variables are listed in the Correlations area and in the Risk Tornado Diagram.

The input variable missing is ''Final Calc'!$F$17 - it is a lognormal distribution.

The workbook is "Provenir Decision Engines - Queuing Perspective v3.0.xlsm" - I copied it to Google Docs. Link is https://docs.google.com/spreadsheets/d/1Z2MI_9kisowW70XRjCVWTZLAcQ83bFGy/edit?usp=sharing&ouid=111926237364535382821&rtpof=true&sd=true.

Feel free to download a local copy to look at it. Please let me know when you have done so - I would like to disable this link.

Thanks, Vin Underwood

pyscripter commented 8 months ago

I tried the link but access was denied.

vinunderwood commented 8 months ago

oops. I gave you a link before that worked. Let me try again.

vinunderwood commented 8 months ago

ok, try this. https://docs.google.com/spreadsheets/d/1Z2MI_9kisowW70XRjCVWTZLAcQ83bFGy/edit?usp=sharing&ouid=111926237364535382821&rtpof=true&sd=true

It's the same link but I changed the sharing options.

pyscripter commented 8 months ago

Cell ''Final Calc'!$F$17" has no dependent cells and it certainly does not affect the output cell ''Final Calc'!$F$19. This is why the correlation is empty.

vinunderwood commented 8 months ago

I see it now. Major logic error on the sheet "Final Calc". thank you