Heath, What are the chances of getting prediction intervals implemented in CB? Failing that, I suppose we could calculate the intervals if we understood the...
In CB 5.5 Developers' Toolkit, you can use the spreadsheet function =CB.GetForePercentFN( assumption, percentile ) to extract any given percentile of an...
Brian, I will look into it and get back to you next week some time. Cordially, Heath Dugger Discover innovative applications and learn the latest techniques ...
Hi Eric, Thanks. I'll try that. If that doesn't provide prediction intervals I'll try CB.GetForeStat. Should be able to get there one way or another. Brian ...
I have taken this example from Cliff Ragsdale book, on how to use OptQuest. I am not able to run it here, OQ just pops up a message saying that an unexpected...
I am trying to use the 140 demo that comes with Cliff Ragsdale book, using Windows Xp and Excel XP. The problem is that in some computers it doesn't install,...
Brian, I have forwarded this request to our services team for review. I noticed that an answer had come in from another user. Did that answer your question? ...
Ahhh... not quite. What Eric meant to say was CB.GetAssumPercentFN(assumption,percentile) Any formula using CB.GetFore... works on the forecast cells and not ...
Brian, You are correct, Predictor develops confidence intervals around the means of the forecast. I don't know what the chances of having prediction intervals...
Bill, ????? I'm trying to get prediction intervals on the forecasts in CB Predictor. Brian ... a ... implemented ... if ... prediction ... my ... available ......
Does anyone have a document or URL for a straightforward mechanism to calculate the inverse hypergeometric distribution. I'm looking for something similar to...
Jim, If you're looking for an Excel solution try googling "inverse hypergeometric excel". e.g. http://members.aol.com/iandjmsmith/Examples.xls has VBA macros....
Hello, I'm a new member and just started using Crystal Ball for my research. I'm trying to run a simulation but Excel locks up for some reason after a couple...
Hi Jim, Actually, one can fairly easily construct an Inverse Hypergeometric Distributions in Excel and Crystal Ball, using Crystal Ball's Custom distribution. ...
Derek, Crystal Ball will run everything that is open, including multiple workbooks. You can use the freeze feature and disable some of the CB expressions: Go...
I am currently trying to upgrade a model from version 5.5 to version 7.2. The model is 40MB+. I am using the EnumAssum and EnumFore devkit functions to list...
Hello, I'm trying to run a simulation where I have 1,000 individuals divided into three groups that I follow for 500 days to see how they transition between...
Hello, Memory is possibly the problem. You can see by watching the Performance tab in the Task Manager. If you send me a total count of Forecasts, Decision...
Dear Heath, Thanks for your response. Ideally, I'd like to have 2 forecasts and 12 decision variables (although I could reduce the number of decision variables...
Derek, You should not be running into memory problems with the information you just gave me. Could you send the model and steps to recreate the problem? I will...
Dear Group, I am a new member of this group, studying at Sydney Uni. The reason i have become the member of this group is that Most of the Lecturer at sydney...
Hi I am trying to make portfolio value (consisting of 10 asset classes) forecasts going out 20yrs. To do this, I simulated correlated random draws for each of...
I am trying to figure out some peculiarities between version 5.5 and 7.2. When one sets up the exact same parameters for the exact same model, do both...
Hello, We did change the way random numbers are generated from 5.5 to 7.x. Cordially, Heath Dugger ________________________________ From: cbug2@yahoogroups.com...
I'm trying to run OptQuest on some data but I keep getting the following error message: 'OptQuest has detected more than one Excel process. Close Excel, start ...
Derek, Most likely, you have a renegade Excel.exe process present on your machine. I would recommend that you open the Windows Task Manager (Ctrl-Alt-Delete)...
Hello, In my simulation I have 12 decision variables, no assumptions and one forecast. I'm trying to use OptQuest to identify the mix of values for the 12...
I haven't worked with OptQuest recently but one thing that often works for this type of problem is to define a forecast value X and then try to minimize...
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.
