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...
Hello, I have created a model and ran a simulation using Crystal Ball. I would like to reference the "Certainty" value found in my forecasts in another cell...
If you have Crystal Ball Professional Edition or Premium Edition, you can refer to the Developer Kit User Manual documentation for the CB.GetCertainty VBA call...
I have a multi-period portfolio model that simulates 30 years of returns. It includes 10 differenet asset classes. I use each assets expected return, standard...
Hi, ... The quickest and easiest solution would be to limit the forecast length of your model substantially. Thirty year portfolio performance forecasts are of...
I understand the concerns wtih my gross assumptions, BUT this is the model that I initially need to create. I am not asking for advice on its suitability. I...
Hi Thomas, Regarding your two issues: 1. You can certainly copy your cell assumptions from one period to the next – this can be done in the same way...
I'll just pop in to say that CB does indeed copy the correlation (I just tested this in v7.2), unfortunately, what it doesn't seem to do is allow you to...
Hey everyone, I would like some help on the following problem I am encountering. I have sales stats for 2004 and 2005 below. What I want to do, is to test the...
Hi Ashokjj2001, The answer to your questions depends on what assumption one can make about this sale time-series. Given that you only have 8 data-points, it is...
Hi, ... The data you provided is not suited to derive any meaningful (conditional) forecast, so I suggest to use the unconditional historical distribution of...
Hello, I would like to know how to specify correllations between stochastic variables when using CB-functions instead of CB-assumptions? I cannot find any...
Bo, regarding your second question the standard textbook result is that the development of financial assets are completely uncorrelated from one year to the...
I'm building a portfolio optimization model using Crystal Ball and a "home made" optimization algorithm for my masters thesis. I've built five simple oil...
Hi, Otto, Here are some suggestions and thoughts. It sounds like your decline rates are deterministic and you have no initial production plateaus, so initial...
I just wanted to let the group know about a free upcoming Web seminar that would benefit many by attending. The educational online Web seminar is Spreadsheet...
Has anyone used Crystal Ball to model Optimal Equipment Replacement. Any help will be appreciated specially if some one can provide an example model. Thanks DN...
Hello everyone, Your help over the summer helped me get an offer for a permanant position! I am having a problem with some of my assumption cells which use the...
New to the group and a quick search didn't reveal anything. Does Crystal Ball 7 support external programs using APIs to create, run and gain information from...
I am attempting to maximize the NPV & ENPV of a portfolio of projects with budgetary constraints on the amount spent on the portfolio (over five time periods)....
Rob Here is how to calculate the portfolio standard deviation... 1. The portfolio standard deviation is equal to the square root of the product of the matrix...
Hi Bob, maybe I do not understand your point but to me the use of the standard deviation as the indicator of risk is pretty similar at the well, field and...
I'm trying to run a macro before CB simulation. The macro iterates the value of a cell until it converges. However, when I run CB simulation, the macro only...
Are you sure that the macro is activating at all? Have it do something that is immediately visible, such as throwing up a msg box with a convergent iteration...
I am wondering if anyone has any advice on how to address this in Excel (pasted from Marco Dias's http://www.puc- rio.br/marco.ind/sim_stoc_proc.html on mean...
Crystal Ball 7.2.1 has been released. This release is a big bug fix release in the Crystal Ball 7.x series. Additional information on the issues addressed in...
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.
