See the note below from Oracle - this is a known bug that will be fixed in the next release: From: CBSUPPORT_WW [mailto:cbsupport_ww@...] Sent: Friday,...
I've noticed CB stops loading w/ Excel when I install Adobe PDF Professional, and it only work again after formatting the HD. I stop using PDF Pro because of...
There are no tools to convert a model from @RISK and Crystal Ball. Therefore you'd have to go through the spreadsheet carefully and replace distributions one...
Hi, I wish to run a user defined macro with crystal ball. The issue is that I need to run it at a point which is different from the ones specified in the use...
I am in the middle of teaching a course using CB and CB support has not responded to me in 24 hours so I am hoping somebody here can help! Suddenly, I am...
Hi we have 2 licences for CB7.3.1, one of which is installed on my machine, however I am no longer working in an area that requires CB, does anyone know how I...
Here is a possibility. It's worked for me when I've encountered similar unexplainable behavior in version 7.3. If strange behavior is being experienced with...
Hi All- Anyone have a quick solution to this problem: I have 5 uniform discrete distributions (1 to 26 representing letters of the alphabet), one in each of 5...
Hi! I am looking for help to define the date format in the Name field of "Define Assumption" or "Define Forecast". I have it linked to a cell in an Excel file...
CB displays all references as text - so if you want to specify a date format try using the TEXT function. For example if your reference cell in A1 had today's...
I'm trying to model how a few different products will perform as they enter a new market. They will launch over the next 2 years or so and each will have...
I trend market or product sales using 36 months of history but the data "spikes" every third month when there are 5 weeks instead of 4 so there's an artificial...
It worked! Awesome! Thank you very much!!! Elena ... date format try using the TEXT function. For example if your reference cell in A1 had today's date, you...
Another (vice) presidential debate, another version of the model to determine the number of same letters in a 5-letter word.. ;-) I just uploaded a new version...
You could divide your monthly data by the number of weekends, so you are putting sales per weekend into CB Predictor. Then multiply the projections by the...
Lil3Dog, Great question - I'm fairly certain that Predictor would not pick up the 5-week spikes since the spikes are likely not perfectly regular with months ...
Hi Lil3Dog, Great question too! Interestingly, I'm just working with a client on a very similar modeling problem. As you already described in your email,...
Thanks for your reply. I should add that I don't necessarily use the output of the forecast directly and I'm looking at the performance for an overall market...
Hi Lil3Dog, Thanks for the explanation. Using your forecasted growth rates to determine a probability distribution to forecast growth does indeed not help...
Hello, I'm a new user of CB ; I'm running a CB simulation with several forecasts How can I display automatically forecast statistics (median only) in the...
Hi David, To display a forecast statistic (for example the median, but many others are possible) within a cell, you can use the following function. For...
Thanks Huybert; Is it possible to generate this statistic in the original cell A1 without delete formula ? best regards, David Méneur, Lab Manager Team «...
Dear David, Maybe someone else has an idea, but I don’t think you are able to do this. Could you describe how/why you would like to do this in a bit more...
David, You really don't want to overwrite the formula in the forecast cell with the median value, for it will end up changing your model (i.e., that forecast...
Hello, I would like to build a model like this: Let's say, there are cash-flows over 10 years. These figures should be assumptions by Crystal ball (normal...