Hello, I am using Crystal Ball 5.5. When I try to use a correlation between two variables, I get funny results. To test the correlation function I use the same...
Everybody, If you've visited the CB site recently you will have noticed that they've just issued a new version in the 7.x series... 7.1.2 to be exact. It...
Hello, Bo, When Crystal Ball establishes a correlation between two variables, it is really a rank correlation. A perfect positive (rank) correlation of 1.0...
Hi, ... Except for some extreme cases, like the one you mentioned, there is no unambiguous way of deducing the conjoint distribution function of two random...
I'm using the latest version of CB, and I've created a custom distribution of only 3 values with 3 probabilities associated with them (none of the values are...
Does anybody knows why the functions "CB.GetForeStat", "CB.GetForePercent" and "CB.GetCertainty" are so unstable?. I have a model where they just return values...
Terry, After the simulation is run the cells will revert to whatever was entered before the simulation started - this will happen even if they contain a number...
OptQuest has its own optmization search strategy - which sometimes not fitting my needs. Occassionally, I would like to have OptQuest (instead of running,...
Okay, first of all, "unstable" is probably not the word you are looking for as that implies causes crashes, has different results for the same circumstance, or...
Many thanks for your comments Bill. I've checked all your suggestions and everything seems to be ok. When the cells do not return a value they return: #VALUE! ...
When using CB.GetForeStatFN, you must copy/paste or otherwise save the results immediately after a simulation run. After the simulation is reset, the results...
Hi, ... You should check, whether your simulation model contains equations which can be provided with inadmissible inputs depending on the realizations of the...
With OptQuest, the constraints must be linear. This restricts multiplication of a variable to just constants, not other variables. - Julie ... not be ... it...
Greetings, I was told by Steve Hoye to come here in order to get in touch with other CB users (most of which are more proficient than I). I'm working on a...
Daniel, Yes, I'm sure there are several of us that can help. I teach this topic in our CB classes and in a risk analysis for development and production classes...
Daniel, Assuming we are talking about a "conventional " oil or gas well here (not CBM or some sort of tertiary recovery ) , my suggestion would be to build ...
Bill, First, thank you very much for the quick reply. I know that my question was somewhat vague, and I appreciate you attempting to work through it, despite...
Daniel, Working the problem backwards, I would think that the investors in the wells / pipeline system are interested in the range of economic outcomes of...
Bill, I appreciate all of the thought over my questions. You guys have given me a lot of perspective on other ways to go about solving this problem....
Hey Folks, Been a long time since I needed to post to this forum. I am still using CB 2000 due to functions that have been omitted in CB 7. I have two serious...
James, If you are referring to the behavior of the Developer Kit in the Crystal Ball 2000.5 (5.5) release, please note that the Developer Kit User Manual does...
Hi David, Checked my manual and found this line on the bottom of page 45 "Before you call this macro, select a single cell". However page 41 of CB.DefineAssum...
Hi I am trying to upgrade an application which used Crystal Ball 2000 to use Crystal Ball 7.1 I want to set up a Weibull assumption which uses P10, P50 and P90...
Hello all- I know CB is designed to handle simulations with independent, random variables, but I'd really like to use it for simulations where distributions...
Hello Pecan Log Roll, If I understand your question well then what you are actually asking for is called the 'Hypergeometric process, which is available in...
Answering my own question: The Excel calculation engine proceeds in a predictable manner (although I'm not quite sure what it is), so all you have to do is...
<smacks head> I forgot about hypergeometric distros. Thanks! But a more basic question persists: can I relate distributions within each trial through CB (as...
Robert, One option is to define the parameters of the dependent distribution based on the variable output of the predecessor distribution. For example, to...
Nick, I've tried the method below - and I knew it should work - but it didn't work for my model. I think I finally figured out why - the dependence wasn't...
I think it would be great if we can do what you want - have parameters of distributions depend on other variables in the spreadsheet. It seems like it ought...
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.
