Thank you. I can try that. I would need to do 24 * 30 * 15 (for 15 nodes). Easy enough to try and see if my PC can handle that in a reasonable time. thanks...
Hello - You can get the split view shown in your 'comparison chart' image by doing the following: 1. Select the cell for your assumption. 2. Click 'Define...
ahhhhhh.......the mystery is solved. I did that once and I cant tell you how many hours I spent trying to figure it out again. thank you andrewlathrop...
Hi, Does anybody know how I can best achiev the following? Simplified I got the following problem: I have got a chain of assumptions. There are Decision Cells...
Hi, I'm using CBpredictor developer KIT in order to create a loop to forecast a very detailed hourly forward curve with more than 100 forcasted values... I...
I am watching this discussion with great interest as I am building a model in a different context but with the need for more than 10,000 random variables. I...
Alberto, Just a quick note related to your first question. A rule of thumb when using forecasting techniques that are based on historical data is to forecast...
Hi Peter, It is a bit difficult to help with this question without an example model. However, one comment I have is that to assess "the minimum value of ...
Thanks for your comments Huybert, Indeed, I'm currently trying to forecast one year of hourly prices having 4 years of hourly historical data. The volume issue...
...To simplify my question using other words, Is it possible to insert a command VBA line that allow to paste forecasts as CB Assumptions ? Thanks for your...
Hi Huybert, thank you for your reply. Do you suggest that I do not use assumptions and simulation but formulas to get the min/max values? Probably my...
Hey Huybert- As a student of the Vose Risk book and writings, wonder if you could give me your expert opinion on the following problem: I am using CLT to model...
I just installed a new version of Crystal Ball and am having difficulty using some of the features I have relied on in the past. My specific questions are as...
Hi All- I am wondering if anyone has any advise for modeling marketing response rates. I have historical data on how many promotions sent segments of customers...
Hi Erinard, I think you could try the following: 1) the lable in the charts is the same as the name of the assumptions. So if you name the assumtions in the...
Hi Peter, For wahtever reason, the labels are not pulling from the assumptions making it difficult to tell what the variables are once the data is pulled. Is a...
Hello everybody, I would like to run a VBA code that paste CBPredictor forecasts as CB Assumptions ? Is there any possible why ? Thanks in advance, Alberto...
If a distribution has a mean and standard deviation such that some schedule duration forecast values are negative, should those negative tasks really be zero?...
Doing this with an IF-statement would NOT be the right thing to do. The reason for this is that any negative random value would then (in the model) be...
Hi Jeff, Thank for the interesting question!! Great that you uploaded the spreadsheet, it helped understand your approached. I just uploaded the model again...
Hi Huybert: I was thinking a negative could be interpreted the same as a 0 schedule duration. A lot of negatives is a lot of 0 durations. The Normal...
When you use the IF-statements with a Normal distribution you would however (a) not really consciously know what the probability of zero would be and (b) have...
Hi Peter, Thanks for posting the model. Interesting model and question. My first comments is that using the "minimum" would not be very useful because the...
Hi Jeff, The reason that in the marketing literature people tend to use a beta-binomial distribution here is that the "story" behind the betabinomial ...
... The VBA code for defining assumptions is simply ... CB.DefineAssump() or CB.DefineAssumpND() Arguments placed in the brackets are: distribution type,...
Hi Huybert- If one has information limited to #attempts and #successes, can BIC be used? It is difficult because I only know this 'response rate' for a segment...
That is a very useful technique! I will have A LOT of assumption cells in my larger model, but the methodology looks very useful to me. Thanks as always for...
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.
