Hi Goose, I tried this macro and didn't have a problem with it. Did you make sure the worksheet is the active one? What version of CB are you using? -Eric W....
Hi, I have been using Crystall Ball 7 for over a year now which we use to come up with a valuation of an electricity contract. As new information comes in, it...
Dear Jarangote, While I can't help you with the specific error you are getting, I do want to add a comment to your posting regarding the use of the K-S ...
Thanks Huybert. Tino Engr. Florentino B. Dela Cruz Department of Engineering Science College of Engineering and Agro-Industial Technology (CEAT) University of...
Dear Huybert, Thank you very much for this tip. I had never experienced this phenomenon until this afternoon when I just spent some time debugging one of my...
Huybert, May I ask a follow-up question on this "bug" where row data is deleted/moved ? What version of CB and Excel did this appear in when you have...
Hi Bill et al., We have encountered this "row 256 bug" in Crystal Ball version 7.2 as well as in Crystal Ball version 11 (within our company, we currently work...
Suppose I have a population {1,2,3,4,5,...,20} of 20 values. Now I need to select randomly 3 values from this population of 20, and assumpe each of these 20...
Hi, you don't need CB to do that. Use the excel function randbetween. For example: =randbetween(1,20) will produce a random integer number between 1 and 20. ...
I assume that the problem is you don’t ever want two of the three values selected to equal each other, right? So the question is how to arrange the CB...
Hi, Luciano Thanks for your comment. But in my problem, I need to generate 3 different numbers between 1 and 20 for each simulation trial. I understand that...
Pat  Thanks for your solution. Since I have to rely on CB for monte carlo simulation for estimating the average, deviation, confidence interval, etc., I...
Fred, Yes, that’s the idea. And of course, you would have more CB Assumption cells for the third value (Cell V3-1, Cell V3-2, etc.), and a regular Excel...
How about using 3 CB custom distributions, each containing the numbers 1-20 as the source (as unweighted values), and then using an after trial macro to ...
As food for thought, I have attached another option using Randbetween (note you must have the Analysis ToolPak Add-in in Excel activated to see this formula)....
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the cbug2 group. File :...
cbug2@yahoogroups.com
Jul 13, 2009 7:06 pm
2354
Hi Fred, This is actually a very interesting problem. I looked at both solution models offered so far and it appears that in each case there is a probability...
As further food for thought, I propose a solution that is much simpler than the first one I proposed (and never has two values that are equal): 1) Create 20...
Last week I enrolled in the Crystal Ball User Group. I am not that experienced in modeling or Crystal Ball, but I did attend an Introductory 2-day training...
Hi, Luciano, Steven, Pat and Greg  Thank you so much for your kind help in thinking deeping of my problem and producing the code example for demonstration. ...
There are a lot of aspects to your problem, but a preliminary question to me would be what kind of forecast does CB Predictor give you based on your 11 years...
Hi, I inherited an excel contract valuation model where the data points are hourly prices (revenues and costs). However, I am running low on rows in excel...
a new book on financial/dealmaking risk analysis, including application of Crystal Ball, and Real Options, has just been published by John Wiley & Sons;...
... The list is sooooo long and copius, that to share here would take up several pages. I've sent the Excel sheet to your email address. Mike Franden Academic...
Hi usa.man.2009, Quite a few questions indeed. I would indeed recommend (as Dale also proposed) to use a time-series forecasting technique to predict next...
Crystal Ball was working great until a few months ago. When opening Crystal Ball 7.3.1 Academic Edition I get the error: error loading crystal ball -...
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.
