Hi all, Does anybody know the VBA for Excel command to Suppress Forecast Windows when running a Crystal Ball simulation? Whenever I run my macro, the forecast...
Greg, Did you get an answer to your question? If so, can you please share your answer. I thought you raised a great question, and I too am interested in the ...
Kevin, I did get an answer to my question. To hide the forecast windows when running a simulation, the HideForecasts parameter for the Cb.Simulation function...
Greg, Thank you for replying. Although I have not had the need to use the cb.simulation function, I suspect I might be requiring that function shortly. Thus,...
Hi all, Thanks to everybody who replied to my earlier message. And now another question about suppressing windows... How would I suppress the windows that pop...
... a ... can ... Try CB.RestoreRunND "Filename" where Filename includes the path. It looks like you really need to get the Developer Kit manual from ...
I've just discovered what may be a bug in CB or at least counter intuitive which may be a useful warning to CB users. I have a model with a large number of...
I can sympathize with Bill, for this feature of CB has bothered me for years. A couple of observations. It is possible (likely?) that Bill's simulation results...
I want to join (really just comment further) in the warning about correlation and static vs. dynamic. Correlated items require static as the only setting...
Apologies for reopening an old thread but I'm new to the group. Run preferences not being associated with a file is a bit of a pain and can catch you out if...
Hi Everybody, I apologize for reposting this question, but I would really like to get around this problem. This will definitely be my last post regarding this...
Greg, What version of CB are you using? It sounds like you must be using CB 5.0 or earlier. Multiple windows on restore was a huge problem for me a while back....
Bill, I think you're right. I'm quickly finding out that the 5.1 version of Crystal Ball I'm running is out of date. Suppressing forecast windows in Run...
Has anyone else installed the beta version of Office 11 -- the one that is publicly available from Microsoft? When I try to open Crystal Ball 2000, I get an...
"Correlating dynamic assumption" -- In current versions of CB you cannot correlate dynamic assumptions. This limitation will be removed in next major version,...
We're going to make a change to CB that removes the user macros from the Run Preferences and instead runs predefined macro names automatically during the...
Walt, We're are currently testing CB with Office 11 beta 2 and will likely be having a maintenance release available soon after Microsoft's official release. ...
All, Eric has given us a hint of what we might expect in the next major release, at least in one area. Thanks Eric for your responses. It is good to see that...
Bill, I have one request for a future improvement: Allow for localized names for assumptions and forecasts. That is, "Project1!2004Opex". Now I must name my...
A couple of suggestions from me: Allowing correlations to be defined across different sheets and to allow the correlation coefficients to refer to Excel cells....
Has anyone ever gotten the error message: Unable to complete the operation due to an unexpected error. Help is greyed out, and in the help files there doesn't...
... a ... Ben, To resolve this issue you will need to try one of the following. Before doing so, please safe all of you work. Reinstall Crystal Ball Shut the...
Ben, It is likely a lot simpler and you probably don't have to do any of the reinstallation or shut-down. The most common cause of this error is having a chart...
Under Office XP in a new location, I am not able to run CBall. The menu shows properly but the simulation will not run. Not responding.. is the message. Now, I...
All, Created by Excel MVP Jan Karel Pieterse, Charles Williams and Matthew Henson who ensured the utility works on Mac Excel. If you use range names in your...
I'm running a portfolio optimization and many of the portfolio element distributions are asymmetric. I have the Variable Req. Upper Bound forecast statistic...
Assuming there isn't an option in OptQuest to solve your problem you could try a transform of your functions to make them symetrical. I think such things are...
... Upper ... Semi-standard deviation is not currently available in CB. I suggest that you use "Certainty." For example, if you have an estimate of the...
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.
