New to the group and a quick search didn't reveal anything. Does Crystal Ball 7 support external programs using APIs to create, run and gain information from...
I am attempting to maximize the NPV & ENPV of a portfolio of projects with budgetary constraints on the amount spent on the portfolio (over five time periods)....
Rob Here is how to calculate the portfolio standard deviation... 1. The portfolio standard deviation is equal to the square root of the product of the matrix...
Hi Bob, maybe I do not understand your point but to me the use of the standard deviation as the indicator of risk is pretty similar at the well, field and...
I'm trying to run a macro before CB simulation. The macro iterates the value of a cell until it converges. However, when I run CB simulation, the macro only...
Are you sure that the macro is activating at all? Have it do something that is immediately visible, such as throwing up a msg box with a convergent iteration...
I am wondering if anyone has any advice on how to address this in Excel (pasted from Marco Dias's http://www.puc- rio.br/marco.ind/sim_stoc_proc.html on mean...
Crystal Ball 7.2.1 has been released. This release is a big bug fix release in the Crystal Ball 7.x series. Additional information on the issues addressed in...
Crystal Ball 7.2.1 has been released. This release is a big bug fix release in the Crystal Ball 7.x series. It can be accessed by anyone with current...
I am trying to dynamically create assumption correlations using the developer kit, but I can't get it to work when the assumption cells are not adjacent. For...
Mike, It turns out that the CB.CorrelateND Developer Kit call (as of the Crystal Ball 7.2.1 release) does not handle multiple-area selections when setting up ...
Hi, wondering if anyone has done a similar thing or is well versed in the above mentioned. I have a set of input data which I put them through a Normal and ...
Hi Benjamin, This is a common problem in risk analysis and one that people (very) often make mistakes with. While in the "deterministic world" we can multiply...
Hi Huybert, Sorry, hope that you will be patient with me as I'm rather new in this field. I'm still quite blur after going through the excel workbook and the...
Hi Benjamin, No problem - the CBUG is a discussion and learning forum and if you have questions then others may have too. A. DETERMINING LOSS DISTRIBUTION: I...
Hi Huybert, Sorry but I can't seem to find the file "airplane crashes 1.xls" at the Files section in the forum. Do you mind directing me to the place I can...
Hi Benjamin, 1. The model is now available at http://groups.yahoo.com/group/cbug2/files/. 2. Using the distributions you mention, the complete flow should be...
Hi Huyber, thanks for the prompt reply. I was going through the excel file that you have posted and have some questions about it. 1. Am I right to say that for...
Benjamin, I think this will be useful for others on the CBUG-list, who are interested, so I'll post this to the list. Answers: 1. Cell D9 represents the...
My assumptions occur on mulitple worksheets, and are not adjacent cells. The Help file claims that "Avaiilable Assumptions" will list all the assumptions...
Troy, The ability to correlate assumptions across multiple worksheets within the same workbook was not added until the Crystal Ball 7.0 release. The text that...
Can anyone help please. I am trying to do some work within Crystal Ball 7.0 and either my book is out of date, wrong or my software is. I am assured by the ...
Hi Ade, In the upper right hand corner, you see a small button with a "double arrow" that points downwards. If you hover over it, it actually says "more"....
Hi, we have just purchased the new version of CB and we wanted to make sure that all the Excel models we already have work properly. I've checked that the new ...
Hello, There is not a way to convert the old .run files to be useable with 7.x. Cordially, Heath Dugger Discover innovative applications and learn the latest...
Mikel, The Crystal Ball 2000.x (5.x) simulation results file (*.run files) cannot be read in by Crystal Ball 7.x because of the change in the paradigm for what...
Hi All, I just got upgraded to CB7.X...I miss the functiong of "paste to excel" of CB2000 in the new version. It takes much longer time to extract data into...
Dear Dai, The ability to directly paste the contents of a Crystal Ball chart to Excel chart format was indeed removed from Crystal Ball in the 7.x releases,...
Dear David, Thank you very much for the prompt reply. I am at the same time exploring the reporting function. Thanks for your suggestion, I have just found...
Dear Dai, Your other request about including the goodness-of-fit data and fitted distributions in the data extracted when creating a report is another ...
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.
