Use the correlation matrix tool. Crystal Ball give me the option of adjusting the coefficients to consistent values permanently or only for the current...
Hi all, Does anybody know how to show the forcast cell that is a new input for another forecast cell in sensitivity chart? For example Y = A+B+C+D ----> set Y...
I have about 12 data points on absolute forecast errors. The standard procedure to calculate Safety Stock is as follows: Mean Absolute Deviation (MAD) =...
Hi Nitie, Great question. There is a way to do this with using a (dynamic referenced) Custom Distribution within Crystal Ball. Instead of explaining it in...
Hi Ranga, To estimate the uncertainty about the mean, there are different methods of which here two common ones: 1. You assume that the data is normally...
Huybert, Thank you for the article. The article talks about an example but I could not find the example in the article. Is there a separate example attachment?...
Hi Ranga, Assuming that you would are referring to a "non-parametric bootstrap example", I just updated an example model (you should be getting an email soon,...
Hi, You have a challenging problem (especially for presentation materials) but I like you to know the essence of the CB senstivity chart. For example; Y = A +...
While Pat would be the last person to use this site to "promote" his work, it is useful for all of you to know that he has in fact written a very good book on...
I have found his book to be the best at 'executive messaging' (see p. 46 "How Fear of CLM's Causes CEs to be Less Than EVs, thereby reducing NPVs*) and I have...
Good afternoon I have been trying to use visual basic to program an excel cell as a uniform distribution. The following program is what I have used ...
Well, you should be good to go with only cb.DefineAssumND(cbDfaUniform,low,high). You should not use cb.DefineAltParms... for defining the assumption with...
Hi, Is it possible to insert an event to predict the future value for CB Predictor? Say, I have yearly sales data for last 10 years. I would like to use the...
Dear CBUG, I am building a stochastic environmental exposure model. There are 5 exposure sources, but the relative contribution of each of these sources to the...
I would scale each of your random variables by the sum of the random variables. For example, for a draw of x1, x2, ..., and x5 create the sum y=x1+x2+x3+x4+x5...
Yimchiking, When you have a "baseline forecast" (which would assume no competitor) it is relatively simple to introduce an impact of a competitor using Crystal...
I will be out of the office starting 12/03/2007 and will not return until 12/10/2007. I will have limited access to email and voicemail during this period. I...
I am trying to automate CB using Excel VBA macros. I unchecked the "automatically launch CB" from Application manager and trying the below code. I am creating...
Hi I need to automate CB 7.2 using Excel - Macros by programatically adding the CBExcel developer kit addin (.xla) to the excel file. Kindly send me sample...
Not sure if this is what you are after... Of course, you also need to have CVBDevKit added in the project's references. (VBA / Tools/References) I find that...
hi, i have built a monte carlo model for expected 10-yr cash flows by investing upfront in a highly uncertain project; the npv is negative, but has a long tail...
Does anyone know how to feed a list of values to an assumption directly? Is there an assumption type that allows for that? The first use case I ran across is...
If you choose the Custom distribution, there's a button labeled "Load Data". You can use this to create a distribution out of a series of data points. It may...
In version 7.2, a user macro identified as CBBeforeTrial runs for each seed prior to selection of values for the assumption cells. Does anyone know if in...
Good Evening- I am looking for some advise (I am a novice at risk analysis). I am building a financial model for the database marketing industry (catalog,...
Can anyone help with the following problem? I am interested in simulating the proportion of customers who are retained from one period to the next. I have...
Alankar, In case you have a large upfront investment (at year 0 or 1), but the uncertainty does not get resolved until year 2, there is no really a lot of ...
I should note here that I was using an uninformed prior for BETA as in beta(s+1,n-s+1).... Thanks ... says ... for ... how ... 33%. ... is ... you ... survey. ...
Phopper0001, The Custom distribution in Crystal Ball is quite flexible, but can therefore also be a bit more difficult than the other distributions. Therefore,...
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.
