HI Huybert: Thanks for your detail reply. I am still crunching through the cases and if time allows will do some testing on whether randomness etc would...
Hello! I´m running a CB simulation using VBA code. How can I define or edit the forecast cells, to display/show the mean value? After simulation the...
Hi - I would recommend that you use the Extract Data functionality to extract the forecast statistics for the forecast of interest to another worksheet or...
I am new to the group and had some questions regarding the output of the data generated by a model. I recently took both the beginner and advance training...
Thanks for your quick reply. The spreadsheet with the forecast cells I´m using is already defined and will be used in another application, so if I want to...
Matthias, There is not a CB.CellPrefsND Developer Kit call (or an equivalent command in the user interface) to setup the spreadsheet to show specific...
I have a model that runs without issue on its own. My model determines the upper bound on pareto distributions by referring to the source data. Specifically,...
My model uses about 200 separate assumptions which correspond to 200 similar but separate events. I want to count the number of these that exceed some value...
I am getting the same error Matt described below when I try to run a spreadsheet created in an older version of CB in version 7.2. I remember having this...
You can separate out the exceedence test into a boolean equation and then sum all of the boolean cells... A1 is the data cell =1*(A1>testvalue) then sum these...
Good Morning I seem to have a problem with this marco. Could you please help? Sheets ("Report").Select Range ("O6:O46").Select CB.ClearDataND I get the error...
Norman, Most likely, the problem that you are encountering is related to not having established a reference to the VBA Developer Kit's XLA file. You need to...
Thank you, Thank you. It works! ... From: David Blankinship To: cbug2@yahoogroups.com Sent: Friday, March 09, 2007 10:20 AM Subject: Re: [CBUG] Re: =Countif...
Dear all: I am using Crystal Ball 7.2.2 and I am trying to use the Batch Fit tool in order to fit probability distributions to a 60,000-cells column. I go...
Dear Yiannis, This is an interesting issue that I don't believe has been reported before. What is going on is that internally in the Batch Fit tool's Visual...
Thanks David! I had not realized I could use the fit button from the distribution gallery! This looks nice. (I prefered this, rather than splitting my data,...
Martin et al, do you (or does anyone else in the forum) know of a macro that could run a univariate relationship without having to freeze and unfreeze (and...
Hi - i'm trying to get my VBA program in excel to reference CBDevKit. i followed the instructions in the developer kit manual, found the CBDevKit.xla module...
Randall, The VBA code in the CBDevKit.xla is password protected, which explains why you are not able to access it by clicking on the module in the Visual Basic...
Dear all: CB Manual states that the software uses a multiplicative congruential generator with the following iteration routine: r < - (62089911 r) mod (2^31 -...
Hi all, I'm surprised to see no replies to Tony Kenck's query. Add to the uncertainty of the Oracle bid for Hyperion and I really start to wonder how/if...
Dear Yiannis, Your are correct. The random number generator uses the formula: X(n+1) = 62089911 X(n) mod (2^31 - 1) The notation in the reference manual uses...
Hello Randall, I wonder if you may be better off going in a different direction with this. If I understand correctly, what you're after is the functional ...
I can hopefully shed some light on three of your questions, perhaps someone else has insight on the other. 1. Although the simulation will forecast the entire...
Hello, I am attempting to run CB7 Premium on a multiple-sheet DCF model. When I run the simulation, I receive the following error message. "Simulation can not...
We have encountered this message when the combination of the name of the workbook + sheet names + variable names gets too long. Crystal Ball appends all this...
If you are setting your assumptions to cells that contain values, you might try setting assumptions to empty cells instead. ... Hello, I am attempting to run...
I am a new CB user. I am working on a project for budget optimization. There's a fixed budget amount and several marketing channels to allocate the money to....
Ladies and Gentlemen: I am constructing a very large value chain model across several products and FX using Crystal Ball. Execution times are measured in ...
Hello, I have a DCF model that has several assumptions in it. We use Crystal ball to model different scenarios (i.e. what if price is between 3,000 and 5,000)...
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.
