Assuming there isn't an option in OptQuest to solve your problem you could try a transform of your functions to make them symetrical. I think such things are...
... Upper ... Semi-standard deviation is not currently available in CB. I suggest that you use "Certainty." For example, if you have an estimate of the...
Tony, I've got a couple of ideas, depending on exactly what you're trying to do. You're building an Expected Return vs. Risk efficient frontier, but the issue...
Of course, it depends on your needs but a good proxy to SSD might be the standard deviation of returns below the risk-free rate, or some other threshold that...
If you're asking how to correlate a function that you've defined using CB.NormalFN, I don't think you can. If you use the CB.[distribution] functions (rather...
Hello everyone. A new member here so apologies if this subject has been covered before, but I could not find it in the history Has anyone written a VBA...
You don't need a VBA routine. In the Name field, you can pull in text from two sources - e.g., "=A2+$F$1". If you then copy and paste the assumption, the...
Bill, First, let me thank you for all the hard work that you have been putting into moderating this CBUG forum. The risk analysis community in general and the...
Hello, i'm a new member, but an old CB User. I need to do an MTTR and MTBF model analisis, and i'm thinking to use CB for it, Someone have done something near...
If someone is keeping track of desired new CB features, I'd like to see a more robust set of functions available in CB Developer and expanded functionality...
Greetings all. I work in the petroleum business, exploration and production as a petrophysicist. My Exploration Manager came to me yesterday and during the...
Arthur, Welcome to the group! Yes, there is at least one really good Excel and CB resource assessment tool that several name E&P companies are using. But I...
Hi, I browsed through the Decisioneering website and didn't see any reference to CB being able to interact with MS Project. Does anyone know if Decisioneering...
I apologize for sending this to the entire group, but I have tried several times to reply off-line, and I keep getting a "mail undeliverable" response. So...
I am part of a government Dose Reconstruction effort. We are using Crystal Ball in the arena of uncertainties. Our CB simulations generate anywhere from...
Jamie, You have at least three choices. First you must decide whether you want to use the traditional lognormal distribution, which is always skewed right and...
My top three improvements would be: * The use of named excel ranges as inputs to uncertainty definitions. * The same control over recalculation/correlation etc...
I shouldn't need to stress that if you model does generate negative numbers and there are no errors in it, then some distributions cannot fit the data! In...
Hi everybody: I am a new CB user and work in the chemical industry. I am working in one of my first models and tried to define an assumption using cell...
Hello Andres, I doubt that the problem is the Static vs. Dynamic option, especially since you checked Dynamic. That option simply tells CB whether or not the...
Hi, The model that I am building will have many project sheets. Each Project sheet will have "Assumptions". These assumptions will drive the results for each...
If I understand the problem correctly I think you could simply use "Freeze Assumptions" in the cell menu to freeze the assumptions on the appropriate project...
Hi, When engaging in a run, I might initially have 20 Forecast windows open. I then go to Run | Forecasts Windows | Open Selected Forecasts and choose four...
Hi Jim, Yes, that is very much what I am looking for. I wonder if I am able to have a VBA "freeze" all assumptions on a sheet before hiding it? Part of the...
As far as I know, you would need to build a VBA routine to select each assumption on the page. Perhaps a loop using CB.EnumAssum and then use CB.FreezeAssumND...
Hi Jim, That gives some great ideas as to how to move forwards. I will have to do some homework on this. But I do very much appreciate your help. Best...
Here is a follow-up to the discussion on eliminating non-positive numbers... Crystal Ball does not have the ability to "screen" out the non-positives at this...
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.
