What is the procedure to create a sensitivity (tornado) chart and to copy forecast charts in a determined worksheet through macros? Greetings Felipe...
I am sure this is an incredibly easy one (read newbie question) but I can't seem to figure out how to use a conditional, an IF() in a cell where the result of...
You could try putting your triangular distribution in separate assumption cell e.g. F14 and then have the formula IF(AND(B13>0,E13<>G13),F14,0). Jim McBurney ...
I have a non-technical question. I apologize for posting it here. I thought old license holders (I got mine in 2002) may be able to help me. With the take-over...
Regarding the second license, I also sent an email to Crystal Ball to have the authorization to use one for my desktop, while I am using CrystalBall on my...
Hello, This is the technical support manager. I'm sorry, but this really isn't the place to ask this type of question. I believe we forwarded you to the...
I am not completly sure what you are asking for, but try using the cb.sensprefs Allows you to handle the sensitivity chart, you can copy and paste with other...
Can anyone from the Vose Group point me towards a source for the derivation of the CLT in the form N(n*mu, sigma*sqrt(n))? Specifically, it's usage in...
Hi Jeff, Actually, the derivation of the CLT in that form is surprisingly simple. Typically in statistics (as most people are used to), CLT is used to ...
Hi Huybert- Thanks for the reply, the link did not work when I clicked it though. While I have you, can I ask one additional question :)? When it comes to...
Saludos, estoy tratando de escribir una macro y cuando utilizo CB.Fit me devuelve el error 2015 y en la celda aparece #VALOR!. Alguien sabe como hago para...
Hi Jeff, You can also find the paper when Googling for "Groenendaal" and "Did You Loathe Statistics, Too?". With regards to your question on fitting univariate...
I have 2 Excel workbooks: lets call them A and B. I am running a CB simulation in workbook B that uses data (lets call the data $data) produced in workbook A....
I believe that CB will run simultaneously in all open workbooks. So if you open both A and B and run CB, you should get the results you want. Unless I'm...
Dear Leonardo: CB.Fit returns an integer value between 0 and 23 (even though there are numbers in between that are blanks) I have never come across that...
Hi, I am very new to Crystal Ball and OptQuest, I would like to find out if Crystal Ball with OptQuest support any large scale optimization problem such as...
Hello, I have the following problem: When I want to save the simulation results using "Run-Save results" I get the following error message: Unable to complete...
CBUGers, Hello! I am new to this group, and hopeful I'm asking an interesting question. I am puzzling about how to model the following kind of scenario in ...
Hello Brent, If I understand your situation correctly, an approach that I have used is to decouple the event probability from the range of uncertainty on the...
Hello Brent, I agree with Nick's approach on the first part: defining each of A1, B1, . with the normal distribution stated. Regarding the second part, I would...
Nick and Sherman, I greatly appreciate your responses. Either I don't really understand them, or I haven't described the problem effectively, though! Let me...
I just installed and ran CB 7.3 and upon extraction find all my forecasts are listed alphabetically by column heading instead of the order I had them set up in...
Hi Brent, Let me see if I understand your problem by making it more concrete. Assuming only two "things," for simplicity, let's say we have an urn full of...
Joe, Thanks so much for your thoughts. I think I'm getting closer, but not there yet. Since this is one piece of the larger model, a trial in this case ...
When you are in the Extract Data dialog box, go to the options tab and check the box to include cell locations. You can then sort the columns into order via...
Hi Could someone be kind enough to post an example on how to copy a chart and paste it in another workbook? Or if someone could explain me the procedure on how...
Let's stick with the juice example... The thing with having a bunch of normal distributions is that normally they'd be independent, picking values from across...
Hi - I tried to use the manual to solve this but there is no guidance for for the dialog box I am writing about. I built a model with a ton of forecasts in...
Sorry my fault... I want to copy & paste variuos charts (forecast and sensibility)in a new workbook but through VBA. I am really lost with this so all help es...
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.
