Does anyone have a project proposal risk analysis template that they would be willing to share? Looking for things like - Project Risks with probabilities,...
Wardlow, Rob J
RobJWardlow@...
Aug 2, 2004 1:49 pm
915
Hi, Can anyone help me find how to focus on a particular area of a sensitivity chart and see which factors are responsible for that area? I can move the...
Katie, I sometimes make each of the assumptions a forecast as well, and then extract the data to a spreadsheet. This will give you each discrete forecast...
Hello: I would like to know if any of you have tried to model a variable with a mean-reverting process. This is briefly mentioned in the book: Real Options...
Katie, Might I suggest looking into the Scenario Analysis tool, located under the CBTools menu. This tool will run a simulation and then sort and match all the...
Ken, Does your new computer have the current version of Excel (2003)? You may be running into a compatibility issue. Older versions of Crystal Ball are not...
Does anybody know what kind of a distribution fitting method is used in the Batch Fit of CB? Least squares, maximum likelihood, moment matching or something...
Everyone, I have a large spreadsheet with a different assumption in each row. Other information in the row dictates which assumption shape I should use, and...
You could make two copies of the list of assuptions. One is the CB assumptions sorted for copy-pasting, and the other is sorted the way you need for...
Thanks Lance, Using the CB Functions instead of the Assumptions dialog box as indicated in Grossman's paper appears to be the right fix. I've run some tests...
You can choose between Chi-Square, Kolmogorov-Smirnov and Anderson Darling models in the Batch fit input screen. More information about these is inthe CB...
Hi, Maybe a simple question: anyone know how to name precedence cells in a Tornado/Spider chart on CB 5.2? I am now taking for granted cell references names....
Does anyone know how to make correlation coefficients between two assumption variables take a certain distribution (i.e uniform between 0.5 and 0.75)instead of...
Actually, I'm not sure that suggestion works - I'd be interested to hear what a Decisioneering person says. My understanding is that when a correlation is put...
The more I think of it, the more I think Pat is right and that I was dillusional. My bad. I'll wipe out the message. While you can indeed use a cell reference...
I don't know if this works, but if you have the developer's kit and write VB macros could you change the correlation coefficient in an outer loop of a VB...
Hi, For those that follow the financial markets, I am curious if anyone has a reasonable method to estimate the volatility of Google after one week of trading....
I'll comment on it since it's Friday and you've asked, although this isn't really the forum. For those of you curious, but unfamiliar with option pricing...
Hi Lance, Thank you for answering my question. I was curious as to how the markets would attempt to make sense of such a new security. Using the end of day...
It's documented on pages 157-158 of the Developer Kit manual. I'm not sure that it's what you want since it appears to return the correlation coefficient that...
Jim is correct. I was just about to say the same thing. If you want to run correlations on forecast data sets, extract the forecast data and use the Excel...
In fact, I need to get the correlation between two forecast cells ( a way to force Crystal Ball to memorize the data), each forecast cell is the result of a...
I have a system of non-linear equations that I need to solve to generate the result (y). I can set up the system of equations and solve using excel's solver...
hi all members i am a new member in this group. i hope to be in contact wih all of u. i am an instractor at the faculity of engineering. my master interested...
I am trying to set a forecast cell's Display Range Preferences via VBA code to define the display range for the forecast in cell "C7" to use the fixed...
I think you need to make the range preferences one line: cb.RangePrefsND cbRngUseFixed, 0, 100, True should work. Jim McBurney mcburnjc@... ... From:...
I installed student version of CB on XP office 2003. CB tool bar is grayed out. The only two items not grayed out on the Crystal Ball tool bar are Run...
Tim, Not sure what the problem with office 97 is but I think I can explain the behavior in office 2003. Specifically, I believe you need to check your ...
It must be there somewhere, but am dammed if I can find it. Can anyone point me as to where I can find help/descriptions of the Crystal Ball functions you can...
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.
