Andy's formula is (almost) the same as Huybert's formula. We use a small proprietary variation of this formula to calculate the number of bins for CS ...
Hi Andres, Great questions! Question 1: In almost all of the CB models we build for our clients we link the output of some distributions to the input for other...
Hi, I am trying to extract the values that a user sets for a crystal ball assumption to my program that controls a stochastic mixed integer program. I am using...
Dear Group, I am trying to set a simple sequence of 7 assumptions using triangular distribution, being the first correlated to the next and so on. My...
Steve, Not sure what could be causing such a dramatic slowdown. Generally, Excel 2007 is quite a bit slower in recalculating spreadsheets than Excel 2003. In...
Eric . . . Attached is the one assumption/one forecast file. I doubt that you will see the same problems as I am experiencing, but it is worth a shot. Others...
Dear Group, One solution for the problem I posted was to uninstall the Microsoft .NET Framework 2.0 pack 1 and install the Microsoft .NET Framework 2.0. I did...
Does you model use data from some other file which are located on the network (may be some reference in the macros)? That seems to fit your description:...
Hi, I am a new member and have been having problems exporting my Overlay charts into excel so that I can change the format of the charts. When I use the...
I was given a supply chain problem at work to solve and have been spinning my wheels for the last couple days trying different ideas but not really getting...
Hello, I would appreciate it if someone can assist me. I have Windows Vista, Excel 2007 in my laptop and recently installed Crystal Ball 7 and Real Options...
Hi I know very little about 2d-simulation but I think I've got a problem where I'll need to go this route. I need to multiply two triangular distributions...
Hi Otto, Great questions! First, to calculate the probability that the P50 of the multiplication of the two Triangular distribution is above a certain value,...
Hello, I was wondering if anyone here is using simple lead and/or weighted lead forecasting of CB Predictor for their projects, and can provide me with some...
I have a question about how to use "Define assumptions" for a value where I know the percentiles but not the distribution. For example, if I have a value named...
I have a question about how to use "Define assumptions" for a value where I know the percentiles but not the distribution. For example, if I have a value named...
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 : /Fitting a...
cbug2@yahoogroups.com
Aug 20, 2008 10:11 pm
2101
Hi Greg, Great question - what you are asking for is how to construct a non-parametric distribution using this cumulative data. Since this involves a number of...
Hi Huybert, Thanks - that was exactly the info I needed. It worked perfectly. I wish they would put that in the manual for Crystal Ball! Cheers, Greg Greg...
Hi, I am new to Crystall ball. I want to get the values of assumptions and put them into some cells on the existing sheets, how can I do that? Also another...
Dear Hailey, One of the easiest ways to get the values (i.e. random samples from the assumptions) into your existing sheet is to simulate for example 1000 ...
Hi, Dear Huybert Thank you so much for your reply. I am sorry that I forgot a key thing in my question: All my questions are regarding to VBA coding. So my...
I am reading the document and it already answered the question I have. Thank you so much!! ... the ... of ... you ... Ball> ... page ... coding. ... the ... in...
Hello, Everyone (with fond memories and apologies to Karl Haas) I suspect this is a common situation. We are building a model that will be used by several...
Hi Hailey: I would like to add that the USER MANUAL has a very important section on how to sequence macro call in your project... I have written a brief blog...
I am maintaining an application which determines if Crystal Ball is installed by reading the registry key - HKEY_LOCAL_MACHINE\"Software\Decisioneering,...
When I try to create a report into a 'report' sheet in the current workbook, it does not work in Excel 2007. Is this a known bug that I can get a patch for? It...
