I am currently trying to optimize certain parameters based on historical data. I have the historical data and some calculations in an Excel worksheet. I want...
I think this should work: Sub Opt() Set A = CommandBars("Worksheet Menu Bar").Controls("C&BTools").Controls("&OptQuest") A.execute End Sub Jim McBurney ...
We have built a prototype simulation model in Crystal Ball. For various reasons it would be nice to integrate the model with SAS (data management). Do any of...
Hi! I have a forecasting case where data are available for 3 years. During this period three events occurred: a) product launch b) product approval 1 c)...
... I have a simple-appearing correlation puzzle which may be of interest to board members. The challenge is that no one has solved it - neither academics...
Hello Rado, Standard forecasting tools make sense if you expect that product approvals will continue at roughly this pace for the foreseeable future. In the...
Bob and others who may want to show or include attachments, You may upload your .gif files to either our "Photos" section or to our "Files" section. Both may...
Thanx, Bill. I need to attach at least four of ten .gif files to set up the correlation puzzle, but it appears that they can be only posted one at a time,...
Could anyone help me work out how to set up a weibull assumption from VBA? Currently I am using: aName = "Impact" & n aMin = "=" & objXLrange.Offset(0,...
Bob, As I said in an email sent direct to your registered address, but I guess you did not receive it, I have set up a folder in the Photos section for your...
Issue: When I try to enumerate assumptions in CB I only get a small number - if any - of the assumptions in the workbook. My code looks like: For Each W In...
I am trying to create an OptQuest model that has about 1500 decision variables and 300 constraints. I have defined the decision variables and generated a text...
Hello all, I need a large set (about 4.000.000.000) of random numbers which should have a uniform distribution. - does anybody knows something about the...
Here are some facts I am aware of that may help answer your question: Crystal Ball uses a multiplicative congruential random number generator. The sequence of...
... second ... thanks.. when the number of categories is too many, we'd like to have one command implemented in crystall ball or or @risk. i like your book,...
Thank you in advance for any help. I suspect that bimodal can be used for that purpose but not sure how. Is there any other way?. I appreciate your response.. ...
I am looking for a way to turn off the warning messages in Crystal Ball such as "Maximum Number of Trials Reached" and "One or more values resulting from...
For the crystal ball reports I have to interpret what everything means into basic english, for instance Coefficient of variation is the measure of variation of...
I don't have a good example at this time. However, I can offer a hint as to 2 ways to do this: 1. A spliced distribution where you start with one distribution...
Standard Deviation is a measure of how dispersed the data are. It can be loosely defined as the average distance of the data from the mean. It is calculated...
To stop messages in an excel VBA you can use Application.DisplayAlerts = False Remember to reset at the end of your macro: Application.DisplayAlerts = True -...
The model only requires as many distributions as the number of outputs (classes). You can't really reduce the number of cells you are using. There might be a...
There are lots of ways of combining distributions together (in fact, that is what Monte Carlo simulation is doing anyway), but the answer to your question...
Hi David, Thank you for your inputs. My request seems very simple. I have multiple distributions and I need to produce a unique output distribution resulting...
When I load the "Futura with OptQuest" file, and then select "CBTools -> OptQuest" from the main menu bar, I get the following dialog: "Problem initializing...
Please. How can I incorporate Net Present Value functions in Crystal Ball simulation? I am trying to build a model which in addition to forecasting, give me...
I think you have it backward - you should build your NPV model the way you always would, and then convert it into a CB model. You do this by converting your...
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.
