Hey guys i'm a newbie of crysball I need your help. Just wondering if anybody knows how I can extract the percent of Contribution to Variance by using Visual...
I also had this problem. I wanted to ignore the forecasts for the first N trials (as these N trials 'warmed up' my model). So i ran a CB simulation for N runs,...
Hi. I used CB to fit a random variable. CB fit my r.v. as a Weibull distribution. Unfortunately, I cannot use CB assumption cells with the Weibull distribution...
This does the trick: Public Function Rnd_Weibull(ByVal shp As Double, ByVal scl As Double) As Double Rnd_Weibull = scl * ((-WorksheetFunction.Ln(openRnd)) ^ (1...
Hi Niti_ie, If you already have the rank order correlations, you are almost there. The two types of sensitivity analysis parameters shown in Crystal Ball are ...
Hi. I need to know how to generate random lognormally distributed numbers from VBA. I cannot use CB to do this (varible amount of numbers needed per ...
Is there a way for Crystal Ball to show the worst and/ or best trial so one can dig down and see what kind of scenario causes worst case or best case results? ...
Hi Kramarz, The easiest and best way of doing is, is by extracting the data, i.e. the values of the individual iterations. If you do that (go to "Analyze" >> ...
If you have access to CB DevKit, you can use VBA to create an assumption, run a simulation with the number of trials you need and then extract the trial values...
Hi, I have access to the CB DevKit, but it takes a significant amount of runtime to define an assumtion, so I wanted a VBA alternative. I did not think that...
Thanks for those suggestions guys. I just figured out what my problem was. CB and VBA both have "mean" and "std. dev." as parameters their lognormal...
Thank you so much for your suggestion, Huybert . I quite doubt why Crystall ball provide me two option in (CB.SensPrefsND cbSenMeasure) function. that is -...
Hi Vivek, Given that you have data, I would recommend that you consider not only including variability within your model, but also including the uncertainty ...
Hi, I have a variable, say 'x', in my simulation. In each iteration, x takes one multiple values (a random amount). I wish to obtain forcast data for each of...
How are you getting intermediate values to calculate in that cell? Are you calculating an unknown multiple of times via VBA? There must be a better way to do...
Yes, VBA calculates the mutilple values per iteration. I can't use multiple forecast cells as the amount of multiple values is quite large and random. Is there...
Hi Vivek, I don't think that CB will give you an easy solution for this situation, though I could be wrong. The first thought that came to my head was to try...
Hi Vivek, Maybe you could describe what you are trying to model (in general terms), since there may be a solution that involves taking a bit of a different ...
Vivek, I agree with Huybert. If we knew more about the context, we might be able to make some suggestions to help. If I interpret your problem correctly, you...
Hi. I've considered spitting all the information to another spreadsheet and using CB's functions (such as FitParam) to fit the datapoints to a distribution. It...
Yeah, CB does have a feature that fits distributions. I think its called FitParam and GetParam... I've used them in other parts of my model, and you are right....
Hey Vivek, Reading through your emails, I am wondering why you put so much efforts in fitting distributions to your forecast distribution(s)? The whole goal of...
I am new to the group and I've taken a quick look for this topic, but I haven't found it addressed here. If it is I apologize. I am wondering how CB actually...
Hi Chip, Thanks for the interesting question - new to the group, but certainly not a "beginner question" ;-) In the section below this email, it is explained...
I have a set of data that is majorly described by a lognormal distribution and minorly described by a fixed value. This is the best fit for the data, and...
Hi Susan, Great question. Without seeing the data and the distribution fits to it, it is difficult to be sure of the best answer, but from your description it...
Hi Huybert, Thanks very much for your message! I think that this is exactly what we needed, and helps us so much. Best wishes, Susan ... difficult to ... that...
Hi, I am working on a school project that asks me to estimate the size of the shampoo market in an emerging market. I have information about the sales of the...
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.
