Hi I have a problem. I have forecasted a number of cash flows like these: 100 150 400 600 800 Using a normal distribution in crystal ball one can get it...
I've got Crystal Ball 2000 v 5.1. I'd like to be able to select two distribution types (Logtriangular, Loguniform) that are not options for my version of...
Ole, Yes there is a method to do what you are wanting to do. Here's a couple of suggestions... First, you can correlate the distributions (dependency and ...
Logtriangular eh? Hmmm, there is only one company that I know of that uses that distribution and from what I understand it was developed internally (many...
Here's my suggestion. Set an assumption cell with a triangular distribution. Range of the triangle should be the log (10 or e) range of the distribution you...
Mike Rightmire
cm.rightmire@...
Jan 4, 2003 3:40 am
359
I'm setting up a model and would need to extract the data from certain assumptions. I found this =CB.GetAssumFN(arg1, arg2, arg3) but no documentation of this...
Hi, I'm working for a risk analysis department. We use the VaR (Value at Risk) to measure the risk of not accomplishing the estimated profit in the yearly...
If you're using Crystal Ball 2000, the command CB.GetAssumFN has been changed to CB.GetAssum and is described on page 151 of the Developer Kit. The three...
In our reserves assessment product we use the following code to get at the mean of the assumption... cb.CellPrefsND cb.cbCelAssum, cb.cbCelDistMean, 4, False ...
Hi, I had an Excel related question: I used Crystal ball to generate probablistic forecasts for market prices and am now backtesting my model. I'm trying to...
You can indeed use the Countif function to work with a variable or cell reference. Yes, it may at first seem like it can't be done but that is because you have...
Thnks for your reply. In your example, you have set the test cell as a single cell. What if i want the test cell to be a range of data? For example: A B...
I have uploaded an example that has the formula that you are looking for. Check the file called "Arrays - CBUG Example.xls" in our files section (on the board,...
Bill, Thanks for your answer. I'd like to implement the first approach you mentioned, ... can I work just with this one on excel? I'm working with v 5.2.2 -...
Yes, though it should be placed in a macro. We run this for a series of cells given a change in any input to an assumption. See the developer's kit for more...
I have created a spreadsheet that utilizes Crystal Ball and am now creating a version that doesn't use CB (deterministic) for those who don't have the...
Hi, I have a model with four assumptions A,B,C,D. B,C and D are correlated to A with a .8 factor. When building the matrix, I set the coeficients for the...
The application is the modeling of a contaminant uptake from water into the tissue of an aquatic organism. Often the estimates of the bioconcentration factor...
Mariana, CB actually uses an algorithm to "fill-in" the unspecified correlation coefficients much as you described. First, the second- order coefficients are...
To all, I would like to know if the results of a forecasted distribution can be affected where the equation for the forecasted value has the same assumption...
I had the student version of CB 4.0 and now can't install the student version of CB 2000. It tells me that it has detected a previous version on my computer...
Hmmm, If I am interpreting your question correctly, no. I'll assume thatyou are not in the .01% of people who like to write the equations into formuli and that...
Dwight... Sounds like you need to call tech support or email them from their website http://crystalball.com/helpdesk.html They are the ones that need to...
A quick general interest message... Yesterday I received for review the long awaited second edition of a book that was originally published 29 years ago. I...
Hi to all, I need help, I´ve a problem closing Excel in my VB6 application. My VB6 application runs Excel and CB2000 Professional in this way: Dim appexcel As...
Hi to all again, When i run CB2000 from my VB6 application, it´s showed on screen the CB2000 'welcome' window, and in task bar too. I´d like to hide both of...
Experts! Whenever I load CB or Predictor the "Personal.xls" or a new workbook is opened. Can this be avoided so that CB / Predictor loads without opening ...
When using exponentiation in a model and the exponent is modeled by anything other than the normal, log-normal, uniform, or triangular distributions, my...
Upon fitting a Weibull distribution to a set of data of bank credit lost due to client default, I am trying to determine the 99.95th percentile. It appears...
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.
