I am looking for e-papers/articles describing Monte Carlo simulation for cost/schedule modeling of large software development projects. Would appreciate any...
Hi Folks, My MonteCarlo model includes a d/dt term that I intend to simulate by calculating the difference between each successive result. For doing that, I...
Hi Folks, My MonteCarlo model includes a d/dt term that I intend to simulate by calculating the difference between each successive result. For doing that, I...
Hello Jairo, It's good to hear from you again in CBUG. If the quantity for which you are calculating the d/dt is anything other than a random walk, you will...
Thank you for rapid response Eric, In my model the d/dt represent part of the steadiness of a system .It is the representation of the variability of the...
I am a new user of CB (just installed 7.2 Standard Edition) and need to project a stock price for a single stock "x" number of days into the future using...
Hi Charles, Modeling a single stock is indeed a bit of a tricky problem - I just uploaded a Crystal Ball model onto the CBUG2 (called "Modelling a Stock.xls")...
Thanks very much Huybert!!!! ... just ... value of ... Scholes ... the same). ... Behalf Of ... need ... into ... to ... figured ... emails, may ... notices" ...
Hi all, I am new user of Crystal ball. I jut installed Crystal Ball professional edition. I tried to studies some OptQuest examples. As in the book, it said...
I am reaching out for help to formulate a model to represent the following business situation. A large printing shop prints 1,ooo,ooo pages per month on a...
A Lookup is not needed, and generally, lookups should be avoided (they are slow and often ugly). This is primarily an Excel problem, and as usual there are...
I have an Excel spreadsheet for which I am going to build a package in order to distribute it. I need to distribute Crystal Ball at the same time. Does anyone...
For at least a while in early versions of 5.x Decisioneering also had a run-time version of CB available. They no longer do that. I think that there was a...
Hilary and Others, I finally got around to working with this and I have found that I can get all the macros to work EXCEPT CBBeforeRecalc. Your did not...
It appears that attachments don't seem to work in w-mails to the list. Added the file Macro Syntax - Updated.xls to the files section for those who would like...
Matt, I happened across the following excerpt from the CB User's Manual, Appendix C, Using the Extreme Speed Features which might be relevant. From what is...
Matt, Sue, and Others, To clear up some confusion regarding user-defined macros, the CBBeforeRecalc macro was inadvertently slipped into the CB 7.2 user manual...
Eric, I need to be able to run a macro which uses the assumption values determined by Crystal Ball. The calculation I need to perform using these values is...
Matt, This is a fairly involved subject to discuss online, so it would be best to continue this topic over the phone. I will give you a call within the next...
How to simulate wiener progress to a series of interest rate by Crystal Ball? each scenario is a series of yearly interest rate as a sample of wiener progress...
Not to be able to freely use user-defined macros in the Crystal Ball environment, even at Normal speed, is an enormous handicap. Respectfully suggest resources...
Hello, Can you share with me some web sites (if possible, workbook samples) about "Real Options Analysis" and particularly the usage of Crystal Ball in this...
Jarrod, In my reply titled "User Defined Macros during Simulation", I mentioned that CBBeforeRecalc was not supported as a user-defined macro. You can,...
Merhaba Goksin I teach Real Options Analysis on the MBA program at the University of Cape Town's Graduate School of Business. We use the Copeland and Antikarov...
I have ten numbers, values for ten months . I would like to run a Monte Carlo simulation, to find the mean, median etc. How do I proceed to do that using...
You don't need CB to calculate that statistics. Just use excel's capabilities to compute the historical values. Luciano Machain www.simularsoft.com.ar ... ...
Luciano, Hey!If I am able to use CB to calculate those statistics, it will help me solve a much more complex problem. Any ideas? I would appreciate any help. ...
Ashok Luciano is entirely correct. For ten fixed numbers you don't need CB. Always stay simple. It is bad, ugly, nasty modeling to do otherwise, and you are...