We have a tool that performs it work using CB. It opens correctly only with CB present. With the 7.3 version we have not found a way to ensure CB starts prior...
Bill, Since you are using Crystal Ball 7.3 or later, please read in the Developer Kit User Manual about the CB.Startup call. This call should do exactly what...
Hi Orkun, I would recommend that you examine that the time-series forecast you use fits the data well and does "behave" in a way that is credible. It his ...
As the topic shows I need to select , copy and paste 2 forecast charts using Visual Basic. My code actually generates this 2 charts correctly. I have gone over...
Hi... I got such great assistance the last time I came here, that I thought I'd try again. I'm trying to model some outcomes for which I have a custom ...
Hi Brent, What you are referring to is "how to simulate the sum of a random number of random variables". This is an often asked question, and the following...
Im a new CB user. I have a 24 intervals (Excel cells) for each hour of the day and a CB normal distribution function driving each cell. How can I plot the ...
Hello: Yes I did recently did a similar calculation. In my calculation I set up two loops. In the outer loop, I randomly selected a value from a distribution....
Huybert, Thanks again for your help. I was coming to a similar conclusion, but I fear that I have a scale problem that will prevent me from executing it. In...
Dear Brent, There is fortunately a good solution for you. If the number of distribution you have to average (or sum) is very large, and they are identical and ...
Huybert, Thanks so much for your help. I think I follow. Just two questions. 1) In your example, do you mean to put the standard deviation in cell B2? 2) This...
Dear Brent, Good questions. 1). Yes, you are right, B2 should be the std.dev; this was a spelling mistake. Thank you. 2). The "rule of thumb" is that the more...
So, for the groups that are sure to be less than 50 (and close to Exponentially distributed), it would seem I need to use the technique you sent, right? Did my...
When the frequency is (or can be) less than 50, you'd have to use the technique of simulating the individual projects. Your proposed solution of using the fit...
Huybert, Thanks again for your help here. I face a new problem, now. To implement this solution, I need 50+ assumptions for each "bucket" in case the...
Hi Brent, It's difficult to give you a solution that would certainly work, but here are some thoughts: 1) The Custom Distribution is relatively slow...
Huybert, Thanks for your response. In answer to your comments: 1) I'll check that out. I believe I'm generating a continuous distribution, but I don't know....
Jamel - yes, you can access all the XLS-files when you go to http://tech.groups.yahoo.com/group/cbug2/files/. You do need to log in with you yahoo password...
Just started work here and the company uses CB, but there was never training course or anything. And I'm one of the only people that need to use it so i can't...
... When I first started using Crystal Ball we had a CD based training called "Risk Analysis Using Crystal Ball" by Prof. John Charmes, which covered well all...
I think you'd find Patrick Leach's "Why Can't You Just Give Me the Number?" helpful: http://www.amazon.com/Number-Executives-Probabilistic-Thinking-Decisions\ ...
Here's the link to the training CD http://www.crystalball.com/train_cd/index.html You can download a trial version which contains portions of the class. We...
Hi All- I am simulating and optimizing with OptQuest. My [current :)] specific problem is centered around how to best simulate / forecast the effect of greater...
Hello to everyone I dont seem to be able to extract contribution to variance and correlation data usign VBA. I Can actually generate both views and extract...
Hi All, I have uploaded a file called "example.xls" that reproduces a problem that I have been experiencing with CB and VBA. The file just attempts to add two...
I got an error message when starting Excel that CB caused a serious error and was removed from the plug-ins. I unstalled and reinstalled CB and did a repair of...
Why do you say that ? I tested with your file and got the forecast values as the addition of the random value from the normal distribution (N(2,0.2)) and 3. If...
Not sure what version of Excel you're running , but with 2k3 I'd go to Help >> About Microsoft Excel and see if it's been added to the Disabled Items list. ...
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.
