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...
Hi, I guess i was a bit misleading. What i meant is that I wanted to use crystal ball to give me those useful values such as std. dev, percentiles etc. at the...
Hi, I worked on a project that used CB as a statistical engine for the past 3 months. I extensively used the dev kit. I have a 2 suggestions that i think can...
Regarding suggestion 2, the CB.<distribution> functions available in Excel (e.g., CB.Normal(..) etc.) can generate random numbers from a distribution with...
Vivek, To add to Samik's comments, the CB.Normal, CB.Lognormal, CB.Binomial, etc., class of functions can be entered directly into Excel cells and therefore...
I'm involved a project that looks at a sector of the pharmaceutical market from 2008 to 2020. The consensus is that the makeup of market will change over that...
Good question - A way think about it (and also to model it) would be to think of this as two step process. First, you would model the branded market share....
Hello I also have a OptQuest question related to portfolio optimization. I wanted to test the results between Solver and OptQuest for a simple allocation...
Hello, With regards to the two questions: 1. It is very surprising that OptQuest did not find the optimal solution since it is actually truly much better...
I'm not sure that I understand the question well, but solver is a deterministic optimizer, whereas OptQuest is stochastic. If the model is big or complex, you...
Thanks for the help! ... be to ... branded market ... but this ... model ... market ... 83% of ... would be ... there is ... and down ... this, but a ... ...
I have a graphical layout in the Excel spreadsheet. In this spreadsheet, I have 3 selected cells for 3 different forecasts. I like to add 3 forecast charts...
I am considering using the g-and-h distribution. This presents two challenges arising in that g-and-h is not included in CB7.3: first, estimation of the...
Hi, I have the latest version of Crystal Ball for Excel 2007 and I'm having trouble using OptQuest. I heard that there were some bugs in the first version of...
Hello, As you have pointed out, CB does not support g-and-h natively. You can still model the distribution by using a forecast. You can setup a forecast having...
Operational risk capital estimation models. G-and-H has arisen as the leading candidate to describe the loss per event (severity). Reference: Dutta, K. and...
When I do forecast model with CB predictor, the forecast labels I have setup are overwritten. The labels CB Predictor puts in are not correct in terms of...
I have a workbook with several worksheets. On two of these worksheets I have CBall forecasts and assumptions defined. I want to programatically run those on...
I have no knowledge on VBA code. There is a Run, Freeze dropdown which you could use to freeze the worksheet. You can select the assumptions and forecasts to...
Thanks for the response, but it's not working for me. My code looks something like this: CB.Simulation ...run the assumptions and forecasts on Sheet1 ...get...
Where is your code located - ThisWorkbook or as a Module? What happens when you try putting the code into the individual sheets? ... From: WaterGod_1...
Michael, The issue here is that the CB.FreezeND Developer Kit call is not designed to work with multiple-cell selections and unfortunately the documentation is...
Alright, thanks everyone. I see the problem now. I've solved my problem in a crude fashion by having no assumptions or forecasts in my workbook. What I do is...
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.
