I have used it in calculating a distribution NPVs and IRRs. Frank Feuquay Senior Fundamental Analyst Fundamental Analysis, Market Analysis FPL Energy 700...
In my view what is and isn't possible is down to how you construct your spreadsheet. If you can construct functions so their parameters reference Excel cells...
There is a new version of CB available... http://www.crystalball.com/upgrades.html Functionally, the biggest difference you may see is that it *officially*...
Several of the contributors to this forum (including me) will be attending the Decision Analysis Affinity Group annual meeting in San Francisco at the end of...
Dear all, I am trying out CB right now to see if I can incorporate Monte Carlo simulation into my futures trading system analysis. Running a historical test of...
Hi guys! Has anyone worked with a variable on which he appointed a beta distribution? When it comes to beta, CB asks for three parameters: alpha, beta and ...
Question 1: If you have some historic daily change data, yes get CB fit a distribution to it. Will all equities have the same distribution? May be worth...
Bill, Thank you very much for the informative reply! I was a little stuck yesterday because I couldn't find the copy and paste function in CB. With your...
Hi Jimmy, Glad to be of some use. Tried to send this to you direct rather than post to news group but your postmaster keeps blocking my e-mails Re Latin hyper...
In earlier versions of CB (I am now using CB 2000) I distinctly remember having the option to include forecasts only, assumptions only, or both assumptions and...
I have a macro that I have defined in the "Run Preference" to execute prior to each sample within a simulation. Works well except that when I get CB to...
I am attempting to adapt the example on "Critical Pathway/Time to Market" to the design of a medical device clinical trial. I have a basic question: How are...
Dear Dr. Ivanhoe, The Critical Pathway model is applicable to one aspect of clinical trials: projection of how long it will take a sequence of trials to ...
Dr. Ivanhoe, As an alternative to including lead and lag times, you could specify your tasks as only those portions which are truly sequential. In other ...
All: John has agreed to post his example file to our files section. Look for it there shortly. Bill ... specify ... other ... starting ... make the ... This ...
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 : /CriticalPath.xls...
cbug2@yahoogroups.com
Feb 19, 2004 4:27 pm
755
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
Feb 19, 2004 7:20 pm
757
Andre, Are you asking how to utilize CB in calculating IRR and NPVs? Specifically what are you modeling? Frank Feuquay Senior Fundamental Analyst Special...
How do I view the parameters of a fitted distribution to a greater number of decimals than the two that show in the "Define Assumption" screen? I am trying to...
You need to reformat the underlying cell format in Excel. As the default, Crystal Ball will only show two decimal places. To change this setting, you will need...
The multinomial can be created very easily with nested binomial distributions. For example Multi(n, {p,q,r,s}) where p+q+r+s = 1 can be created as follows: sp...
Hi The two parameter Beta distibution is mostly used to model uncertainty about a fraction, proportion or prevalence, as it varies between zero and 1. The two...
I am currently trying to optimize certain parameters based on historical data. I have the historical data and some calculations in an Excel worksheet. I want...
I think this should work: Sub Opt() Set A = CommandBars("Worksheet Menu Bar").Controls("C&BTools").Controls("&OptQuest") A.execute End Sub Jim McBurney ...
We have built a prototype simulation model in Crystal Ball. For various reasons it would be nice to integrate the model with SAS (data management). Do any of...
Hi! I have a forecasting case where data are available for 3 years. During this period three events occurred: a) product launch b) product approval 1 c)...
... I have a simple-appearing correlation puzzle which may be of interest to board members. The challenge is that no one has solved it - neither academics...
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.
