Hi I need to make a shift in my mean of 5% and believe I can do this in the formulae. Unfortunately I do not know how. Any one out there done this in Crystal...
Hi Otto, What I hear you saying is that you would like to have the user type on a single row the type of assumption, the distribution parameters, and the...
Hi, ... correlation ... You could create a set of random variables with [0;1] uniform distributions with Crystal Ball and apply the correlation matrix tool on ...
Hello, Can anyone help with this problem? I've written a macro using the CB developer kit and have used the command: CB.ExtractDataND cbDatValues to bring up a...
Does anyone have a CB template where I can download task information from MS Project and the template will recognize the Lag Type and Predecessors info to help...
Hi everyone, Am new to CB. Is there a way to chart the random variable for a given range vs. the forecast variable? I want to be able to find out that for...
Hi Ketan, Great question. An easy and very good way to do this is actually to extract the individual iteration results (i.e. trial values) of the assumption ...
Huybert: Is there a way to automate this so that you don't have to do the menu picks each time? I'd like to be able to set this up so that a MC sim is run...
RobJWardlow@...
Sep 18, 2006 2:49 pm
1481
Hi Rod, As you may have seen already, I just uploaded a new file (see http://groups.yahoo.com/group/cbug2/files/Individual%20Trials.xls) that illustrates how...
Does anyone have a shortcut solution in Crystal Ball for the following: I have a large number of forecast cells ( about 300 ) that have three values...
My company uses Argus fairly heavily in the analysis of our real estate transactions. We have recently begun to use Crystal Ball with Excel on our Excel based...
The current version of Crystal Ball 7.2.2 is not supported on any of Microsoft's beta releases of Excel 2007. A version of Crystal Ball is currently under...
Is it true that OptQuest is the only optimization package which can work properly within Crystal Ball monte carlo simulations? If so, and assuming you only do...
This is my first foray into the CB DK and I haven't managed to find anything similar in the database. I'm reading values in from the sheet to be various CB...
As of the current version of Crystal Ball (version 7.2.2), the error handling via the CB.MacroResultDetail type class is robust as any information on errors is...
For weeks I have been succesfully using Crystal Ball in a multiple sheet workbook with only 2 types of distributions (Yes No and Triangular) and when I run...
Dear BB'ers, I would like to know if anyone in the forum has experience using CB to study correlation. Situation: I am doing a study of two business segments....
Are you setting a "seed" value under run preferences? If not, each run will return different results. William J McKibbin PhD LLC ... From: "irie_sis99"...
Hello, This discussion of graphing an assumption versus a forecast variable and the example posted by Huybert have been very helpful and I wanted to post a...
Hello, I wanted to follow-up on the guidance offered by Huybert on graphing assumption-values (for one assumption) versus forecast-values (for one forecast). I...
Hi Derek, assuming you can't solve your problem analytically and assuming you have no 6D-monitor at hand, the best thing you can probably do is to hold ...
... to ... B. ... Perhaps it ... Perform your Regression Analysis. You might look at line A's buniness in months 1 - 18 to see the growth rate. At month 18...
Was wondering if anyone has tried to use Crystal Ball to calculate a composite dew point where the natural gas sample analysis (mol%, temp, pressure range,...
I'd like to share the results of a series of exchanges with TechSupport (with their approval) arising from the limited and misleading info contained in the...
Hi I am a new user of CB and VBA. I hope the following aren't dumb questions but I would be grateful for any help. I have a model written in VBA. It is too...
Hi Andy! Those certainly aren't dumb questions at all. We all learn this by asking! As I understand what you're saying, it sounds like you need either the ...
Good morning. Earlier I saw a response from Hilary to a request that was what I also wanted to get - specfically how to get the parameters of this best fit...
Jimmy, If all that you need is the parameters that define the best fit distribution for forecast data, then all the you need to do is select Forecast > Fit...
Hi, I am a brand new CB user, so I would greatly appreciate any help and/or advice with regards to my problem. I am basically trying to emulate the approach...
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.
