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,...
Jeffrozappa, Great question - let me first say that I'm a "Vose-person" ;-), but fortunately these techniques are not just Vose-techniques, but all based on ...
Jeffrozappa, That's a great question too! First, the observation you made is very good - the Beta distribution is very closely related to the binomial...
Hi Huybert- First, let me say having a forum to get truly expert opinion like this is fantastic - VERY generous of you to help those aspiring like myself. In...
Jeff, You are very welcome. Actually when reconsidering, it is easier to determine the mean and standard deviation of the combined expert opinion distribution...
Thank you both for your suggestions. I guess my idea is more of an enhancement request then: I'd like to be able to turn off "distribution" altogether for one...
Hi Paul, It seems that the tool you need may be the DATA TABLE function within Excel. This is a very powerful tool within Excel that allows you to do many...
Paul, I just uploaded to examples to the files section that might help you. List.xls will pull from the list sequentially for each trial. Because I use an...
Is there any way to automate the Batchfit comand? I mean creating some kind of macro that would recognice certaing columns and determine the best fit for the...
Hello to everyone I want to build a macro that emulates the Batchfit tool, basically I want this tool to recognise certain colums (which will store historical...
I have a function that I've created in Crystal Ball 5. It can be easily converted to Crystal Ball 7. You specify the range of the data (A1:A1000 format) and...
Matt You could send the code to my email (if that is ok with you): a_cadiz@... Either than that I could give you my msn or something like that, anything...
Hi Huybert- First, let me say having a forum to get truly expert opinion like this is fantastic - VERY generous of you to help those aspiring like myself. In...
Has any one heard if there will be a user's conference in 2008? After the merger/acquisition of Decisioneering by Hyperion I know this was in doubt....
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.
