How do I set up a model where I analyze real estate properties? I have a simple model House 1 House 2 House 3 House 4 and so on Average price of homes in that...
I am running several scenarios [simulation running] and while the scenarios are running how do I capture the lowest or highest value from 1 Cell to another...
Hello Phil, If I understand your question correctly, you can define a Crystal Ball function on your spreadsheet to retrieve the minimum and maximum values from...
Hey Phil, From your question, I am guessing that you do not have much experience with Crystal Ball. So if this answer seems aimed lower than you were hoping, I...
Hi Phil, Happy New Year to all! Just to add to Nick's useful comments, retrieving the minimum and maximum values of a forecast has a few weaknesses to it: 1....
Windows Vista and Microsoft Office 2007 (Office 12) have been released to manufacturing (RTM). A general release of these two Microsoft products is scheduled...
Hi all, I have the following question: I have a number of percentile values for some data (for instance I know that the 10% = $1, 20% = $5, …, ). Is it...
Hello Ioannis, You can definitely do this with CB. Only requirement is that you must have an idea about the distribution. For e.g., if you have 10% and 20% ...
Hi Ioannis, Just a quick note to add to Samik's useful comment on how to fit a distribution to your percentile data. Samik suggestion works well but assumes...
Hi Bo, This is an interesting and fun questions, because you can actually do the majority of you logic just in Excel with Crystal Ball (without using any VBA)....
any familiarity with this message? i see no "merged cells" where the message refernces them or anywhere else in my workbook. i have the workbook in the...
I have experienced this error in the past. It occurred when the cell that contained the CB definition corresponded to a merged or locked cell on another...
Here is a reposting of some information that I provided to the CBUG email list a few months back. Hopefully this helps. I would need a bit more information...
Hi, I have a problem when running the Tornado. Usually, I lose many assumptions and forecasts. No problem with the forecasts since you can manually select a...
Matt, I have figured out what is going on with your model. It turns out that the Min and Max values that you have defined in the spreadsheet for cell...
hello all- i'd like to use VBA to automate OptQuest runs. My question is: to what degree can OptQuest be controlled programmatically with VBA? I saw one users'...
Regarding the cb. Functions, is there a way to test multiple trials off the same distribution. For example, in the cb.binomial distribution we can enter a...
Dear Jephwong, Good question. You should really duplicate the assumption variable 3 times (i.e. in 3 different cells) to simulate 3 exploration wells. A good...
I am new to Crystal Ball & to CBUG. I am specifically interested in developing a model to determine capital required for operational risk at a bank. I have...
Hi Adrew, Thanks for the posting; good questions. I just posted a new (simple) example Crystal Ball model at the CBUC website (see link below), which I think...
Just an FYI for all of our CBUG friends: Microsoft will be announcing the official release of Windows Vista and Microsoft Office 2007 today. Crystal Ball...
I would like to notify the members of the Crystal Ball user group of a statement regarding support for Crystal Ball on the Windows Vista operating system and...
Dear Jamel et al., My apologies - the file is at http://groups.yahoo.com/group/cbug2/files/Simple%20Basel%20II%20Example.xls. If this doesn't work, then you...
Hi We've just updated CB to version 7.2. from 7 and now my spreadsheet won't work. If I try to run a simulation that works in version 7, i get the error...
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.
