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...
Ladies and Gents, there are quite a few additional Excel functions coming with CB (I am using CB 2000 Standard Edition). Functions like CB.GetPercentFN, ... ...
Hervé These functions are defined by CB. The documentation is found in the CB Developer's Kit. The thin manual you received with your software, that is if you...
I am trying to perform a multiple regression using CB Predictor. When I am defining my variables I am getting an error message stating not enough data to...
I am new to Crystal Ball, but I just tried to run a simulation and got the unexpected error message. It will run one step at a time, but not the full...
My experience has been that this often results from a division by zero or some similar error in the Excel spreadsheet when you hit some extreme combinations of...
Two quick reply questions: (1) Do you have any gaps in your data? CB Predictor does not like blanks. I know that this sounds simplistic, but do you have data...
... view each variable on the graph in step 3 everything looks fine. Initially I was using 1 dependent and 5 independent variables with 15 years of historical...
I'm just thinking off the top of my head here, and I'm trying to remember stuff I learned quite a while ago, so if anyone can add to or correct what I'm...
Dear all, I am developing a model in which I use a binomial distribution if certain condition is true. I can model that situation with the logical function...
Andres, I don't think you have to worry about it. When the expression is not true, the value CB generates for that binomial distribution will just sit there...
I am looking for an annual budget model that has proven successful. I am new to Crystal Ball - I just purchased Crystall Ball Standard - and am trying to...
To add a point, the potential for sensitivity testing or generating Tornado diagrams is lost in Pat's approach. The CB formula keeps on generating 'output' in...
I am new to the group, having just found out about it in a Crystal Ball News letter. Looking over the last few months postings, it looks like a very...
Excellent point. I got so focussed on Andres's concern about getting an error message, I forgot what his original problem was - namely, that he couldn't...
Your comment on the daunting nature of the mathematics in statistics books prompts me to recommend another recently published book: Gerd Gigerenzer, "Reckoning...
Thanks to Jon and Pat for their opinnions regarding this issue. I also would like to ask the following questions: 1. In message 267 of this forum I have read...
One alternative to using the inbuilt sensitivity analysis is to define as forecasts all cells of interest including the CB.Function formulae and then do your...
I am a new user of CB and just getting a rough understanding of how it works. Can anyone help me with this: I have the percent increase/decrease for each year...
Hi All, I am trying to understand how Crystal Ball combines various distributions. I have a problem at hand, which involves computing a combined Value at Risk...
Mike, This is a good application for Crystal Ball where you can take a large amount of data ( 75 years of market returns in your case ), and have CB fit a...
To the best of my knowledge, the only assumption Crystal Ball makes (unless you tell it otherwise) is that the input distributions are completely independent...
Mike, I played around with a couple of different ways to accomplish what you want and have uploaded a file showing the work. It is "data set sampling-CBUG" in...
There is a direct and easy way to achieve the original objective. You use a custom distribution, click the data button and enter the range containing the raw...
As we see from this discussion, there are several ways to accomplish specific tasks. The method you chose will depend as much on your philosophy and approach...
Bill raises a few points worthy of further comment. His approach is to minimize the use of CB functions, which is perfectly valid (my approach is to use them...
Does anyone know of a conference for users of Crystal Ball (or Monte Carlo in general) that is geared toward those working in the manufacturing sector? In ...
Hi Stephen, thank you for your help. I am trying to work through everyone's suggestions. I think I followed your instructions: I clicked on "define assumption"...
Hi Jim, I'd recommend the Decision Analysis Affinity Group (www.DAAG.org), however, you just missed the 2003 conference May 14 to 16th. They are planning the...
I attended a class given by Decision Strategies Inc. on integrated decision management and there were a lot of people in the class that work for a large...
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.
