Thanks Huybert and Martin for your help! It is all working now :o) Frances ... (see ... and Y ... in the ... yORAiOniFY2TMeE4xHBGSINObVZ ... 20Correlation ... ...
Hi, My name is Brenda and have just joined the group. I have developed a spreadsheet model for predicting the risk of groundwater pollution from pathogens....
Hi Brenda, Without seeing your model, it is difficult to say what the reason for the high values is. What I would recommend however is that you run a...
I am bothering to ask if someone can share some excel models included in the ModelAssist software: finally retired.xls, basel II.xls, NPV of a capital...
Jose V. Please be advised that the material and model within ModelAssist for Crystal Ball are copyrighted material. Therefore, please do not distribute the ...
Hi Marina, Great question! And the answer to your question actually is 'Yes and No'. read below: Basically, to answer your questions we need to first look at...
Thanks for your help! ... and No'. ... the ... linear ... (this is quite ... coefficient!). In ... the two ... if the line ... (also ... variation. ... to...
Hello all-- I'm new to Crystal Ball and am unfortunately on a short deadline for the project I'm working on. I've been through the manuals but can't find an...
I am in the evaluation period with CB and did a batch fit on all of the historical data in large spreadsheet- added correlations to all the variables. Several...
I am using several assumptions to which I understand the relative correlations and have calculated these. However, there is an error occuring that prevents me...
When using the natural log distribution, is it true that the calculated SD and mean are not accurate when using the arithmatic (as apposed to logrithmic)...
Hi all, I'm modelling a problem in which, for every iteration, I need to run a simulation. In other words, each iteration changes the parameters of a set of...
Hi Otto, The technique you are describing is called 'dynamic referencing' in Crystal Ball's users-manual and is extremely useful (and very often used) in risk ...
has anyone ever had problems with the mean of assumptions nor resetting each time to the mean designated by the referred-to cell? Even though I have set it to...
Hi n3019c, A couple of comments: * First, for any non-symmetric distribution (i.e. most of them), the mean is not equal to the mode and median. In fact,...
Thanks for the help. I have reset and reset again the assumption cell preferences to "mean" and they continue to reflect a significantly larger number. I am...
Update to lognormal assumption mean: Strange but True. The average is set at $6 by reference to a arithmatic average on a different sheet. That referred to...
I am working on a models similar to the Portfolio Allocation CB example. Say you have defined as assumption certain interest rates as uniform distributions...
Has anyone else gotten the error: cannot run an assumption as part of a merged cell. This has ocurred and it is not part of any merged cell, and in fact there...
I have a model that was built by somebody else in version 7.xx that uses the CB.DiscreteUniform function. However, I only have version 5.xx, so instead of...
Hi Steve, In Crystal Ball 5.xx you can also construct a DiscreteUniform distribution, using the Custom Distribution. With the Custom Distribution you can...
I would need a bit more information about exactly which version of Crystal Ball 7.x you are running, but if we assume that you are running the latest version...
Hi, I need to make a model in which the user can define the type of distributions (assumptions) by typing the distribution name in a cell instead of defining...
Hi I need to make a shift in my mean of 5% and believe I can do this in the formulae. Unfortunately I do not know how. Any one out there done this in Crystal...
Hi Otto, What I hear you saying is that you would like to have the user type on a single row the type of assumption, the distribution parameters, and the...
Hi, ... correlation ... You could create a set of random variables with [0;1] uniform distributions with Crystal Ball and apply the correlation matrix tool on ...
Hello, Can anyone help with this problem? I've written a macro using the CB developer kit and have used the command: CB.ExtractDataND cbDatValues to bring up a...
Does anyone have a CB template where I can download task information from MS Project and the template will recognize the Lag Type and Predecessors info to help...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
