I have a workbook with several worksheets. On two of these worksheets I have CBall forecasts and assumptions defined. I want to programatically run those on...
I have no knowledge on VBA code. There is a Run, Freeze dropdown which you could use to freeze the worksheet. You can select the assumptions and forecasts to...
Thanks for the response, but it's not working for me. My code looks something like this: CB.Simulation ...run the assumptions and forecasts on Sheet1 ...get...
Where is your code located - ThisWorkbook or as a Module? What happens when you try putting the code into the individual sheets? ... From: WaterGod_1...
Michael, The issue here is that the CB.FreezeND Developer Kit call is not designed to work with multiple-cell selections and unfortunately the documentation is...
Alright, thanks everyone. I see the problem now. I've solved my problem in a crude fashion by having no assumptions or forecasts in my workbook. What I do is...
I had a similar problem which I was able to solve in a different way. In my case I had multiple workbooks instead of worksheets, but the problem was still the...
Hi, I'm a newbee to CB. I'm using CB 7.3 on Excel 2007. Can anyone plese let me know how can I get my company's name & address in CB generated reports...
Hi Everyone, I work for the exploration area of an oil and gas company. We are using crystal ball to forecast the distribution of MMBLS to be discovered in our...
Hi Juan, If you have one prospect and the risks are properly characterized the simulation will be accurate. But I don;t think that's what you're asking. What I...
Let me elaborate a bit on Tony's comments about appropriately characterizing your portfolio. I agree with what he says - I'd just like to make sure you ...
When .net framework 1.1 updated with KB928366, trial Crystal Ball 7.2.2 refuses to start. When I remove KB928366 using Control Panel,add/remove programs,...
Thank you very Tony and Pat, Now it's a lot clearer, I think based on what you have said that my simulation its ok. I have a final question, If the portfolio...
I think it's ALWAYS a bad idea to represent other than EV. I have heard of people wanting to use the mode to try to set expectations low. A better approach, in...
Hi, We are licensed user of CB 7.2 and let me know is it possible to automate Crystal Ball using asp.net (2.0). I will be creating a dynamic excel which should...
Hi Arun, Others will have to respond to your asp.net question, but I wanted to send a quick email about your distributions. A triangular distribution can't...
I am having a problem with a large model with a large number of correlations in that when I re-open the file sometimes I lose all the correlation. Checking in...
Hi All, I am integrating CBDevKit with ASP.Net. When I open the CBDevKit.xla file in Visual Basic Editor, Its asking a password to open. If anyone knows the...
I'm trying to build a model with both a 1st order and a 2nd order uncertainty analysis, that means that I want to account for both variability and uncertainty....
Hello, The 2D simulation tool is designed so that the user can simulate uncertainty in the 1st loop and variability in the 2nd one. That way you can what the ...
Hi- We just transitioned from CB 5.5 to CB 7.3. We have kept CB 5.5 on some machines so we can compare the results that different versions of CB generate. One...
Hello Huybert, Thanks for your response. I was planning on using the inner loop (the variability part) for my individual patient data (so age, sex and clinical...
Hello, I'm trying to develop content requirements for a Crystal Ball class at a national conference next June. I'm on a planning committee for the National...
Jason, June is Las Vegas? That's too hot man. You need to get them to schedule in Jan-Feb to coincide with it being colder than a WTIABB if you know what I...
Hi Thea, If the patients are real patients of whom you know their characteristics (age, sex etc.), you actually don't have to use Monte Carlo simulation at ...
Hi Kevin, Thanks for the email. I agree with you about Vegas in June. I live in Alaska & that's the absolute worst time of year to travel outside of the...
Hallo Huybert, I see it is quite difficult to get the problem across in an unambiguous way. The patients are real in the sense that their risk factors are...
Hi Thea, That sounds like a rather depressing model ;-), although as an epidemiologist I've enjoyed developing similar modeling in the past myself. Your...
I have a question about the algorithm used to do a Batch Fit in CB version 7. It is supposed to be superior to the one used in CB version 5. If that were so...
Hi Marina, Great questions and probably a good moment to first explain distribution fitting a bit. Basically, Crystal Ball uses two general steps: 1. 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.
