My colleagues and I are experiencing somewhat erratic behavior with the extreme speed setting in Crystal Ball: the run speeds seem to vary dramatically at...
Yup, I have a macro that I want to do the same as you with called do_max_volume ... I used a legacy function (used to be in an older version of Crystal Ball)...
Jim, Others may come in with more technical advice, and I hope they do, but generally I advise people to stick with normal mode if they have look-ups or tables...
Thanks Bill ... I like the joke: CB never says Extreme Speed is extremely fast. I hope our students like that as well ... there are about 375 in our class...
Hi Jim, Thanks for uploading the CB model, that helps. I had a look at the model and agree with Jim - I would recommend running the model in Normal Speed,...
Hi Jim, I also took a look at your retirement model. The Data Table function was a fairly recent addition to Extreme Speed in CB 7.3. Due to the way Extreme...
Eric - Thanks for your feedback. Yes, please feel to pass the example along to the developers of the Extreme Speed (Frontline systems?) for further research. ...
Hi there, I am new to this group and a user of CB for over a year for varies applications. I make use of the sensitivity charts a lot and always run into...
Hi Ritske, Thank you for your question. There is indeed a solution, which is to construct a CB Sensitivity Analysis (i.e. Tornado Chart) 'by hand'. Basically,...
Is there a way to get an output of the values of all of the assumptions and forecasts for each iteration of a simulation? Greg [Non-text portions of this...
You can always use the Extract Data function. Select Trial Values, all Forecasts, and all Assumptions. It will create a table for you in a new workbook. ...
Does anyone know a good way to count the number of times a forecast cell is a certain value during the simulation?, I couldn’t find a CB function that did...
Aaron . . . One way to do this is to set up a cell that references the forecast cell you are testing. For example, if A1 is your forecast cell and you want to...
Hi Aaron, The way Steve describes is indeed the most logical way to do this. The one handy think you could add (referring to the example cell that Steve gives)...
Aaron, As Steve said, there is a way to do it with filters... You can also try this... Set up your filter to exclude any range of numbers you want. Then create...
Hello all, I would appreciate some opinions on what assumptions are made when we use CB to multiply consequence distributions time likelihood distributions....
Hello, new member here with a question that a search query did not answer. When I perform my Monte Carlo simulations the resulting distribution violates both...
Hi GH_Ley, Can you give us an example of a CB distribution function you used? Ideally copy and paste the specific function(s) into the email, so we can exactly...
Hi, I just simulated all three distributions and they all three worked as expected. It is correct that distribution #1 and #3 don't always generate simulated ...
If one is forecasting the sum of several other forecasted cells, why is the summed figure (at a chosen conf interval) significantly different from the strict...
Hi H, To my recollection nobody replied to your email yet. What you are doing when you are "summing several forecasts" is that you are "adding distributions". ...
Hello everyone ! I had just subscribed this group yesterday. I am very glad to take part in a grup with more than 10 years of existence ! I work with R&D in a...
Can anyone share with me the file "Project.xls" from the book Finacial Modeling with Crystal Ball by John Charnes? Ref Chapter 5, page 80 (top), Using...
Thank you so very much Bill _____ From: cbug2@yahoogroups.com [mailto:cbug2@yahoogroups.com] On Behalf Of hils1978 Sent: Monday, June 01, 2009 11:09 AM To:...
When I attempt to perform subject step in setting up a simulation, I receive a message "Assumptions can only be defined for simple value cells". This raises...
This is not a shortcoming in Crystal Ball. Basically, what the message means is that you can't define a distribution 'on top of' a formula, which makes sense. ...
I have experienced the same for some time and also thought of it as a shortcoming. Can you please supply an example for: ".you can 'reference' a CB assumption...
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.
