I'm trying to model how a few different products will perform as they enter a new market. They will launch over the next 2 years or so and each will have...
I trend market or product sales using 36 months of history but the data "spikes" every third month when there are 5 weeks instead of 4 so there's an artificial...
It worked! Awesome! Thank you very much!!! Elena ... date format try using the TEXT function. For example if your reference cell in A1 had today's date, you...
Another (vice) presidential debate, another version of the model to determine the number of same letters in a 5-letter word.. ;-) I just uploaded a new version...
You could divide your monthly data by the number of weekends, so you are putting sales per weekend into CB Predictor. Then multiply the projections by the...
Lil3Dog, Great question - I'm fairly certain that Predictor would not pick up the 5-week spikes since the spikes are likely not perfectly regular with months ...
Hi Lil3Dog, Great question too! Interestingly, I'm just working with a client on a very similar modeling problem. As you already described in your email,...
Thanks for your reply. I should add that I don't necessarily use the output of the forecast directly and I'm looking at the performance for an overall market...
Hi Lil3Dog, Thanks for the explanation. Using your forecasted growth rates to determine a probability distribution to forecast growth does indeed not help...
Hello, I'm a new user of CB ; I'm running a CB simulation with several forecasts How can I display automatically forecast statistics (median only) in the...
Hi David, To display a forecast statistic (for example the median, but many others are possible) within a cell, you can use the following function. For...
Thanks Huybert; Is it possible to generate this statistic in the original cell A1 without delete formula ? best regards, David Méneur, Lab Manager Team «...
Dear David, Maybe someone else has an idea, but I don’t think you are able to do this. Could you describe how/why you would like to do this in a bit more...
David, You really don't want to overwrite the formula in the forecast cell with the median value, for it will end up changing your model (i.e., that forecast...
Hello, I would like to build a model like this: Let's say, there are cash-flows over 10 years. These figures should be assumptions by Crystal ball (normal...
Hello, overnight I found a solution to this myself: I modelled the cash- flows via the NORMINV() functions, which is provided by the Excel Analytics Pack. Via...
Hi DontShootItsMe, Regarding all your questions.. Everything can very well be done with Crystal Ball. With regards to your first question (of your first...
Crystal Ball gives me the option to adjust the correlation coefficients to allow the simulation to continue. Even if I choose to adjust coefficients...
Is anyone aware of any examples for modeling sales force compensation or bonus payout plans? My company is trying to evaluate the risk to the budget if sales...
Hi Sntsjh, Thank you for the email - interestingly, we have been working with several companies lately with pretty much exactly the same situation/problem. We ...
HI, I created a model for a similar problem a few month ago, which is unfortunately confidential, too. So I just can give you the core-ideas: I think it is...
Has anyone noticed this? I have a requirement that OptQuest displays as "The Final Value of G32 must be less than 17.00". But when I run it, it behaves as...
Dear All, I want to conduct risk anaylysis on the income statement ofproject 1 and 2. Iam usining triangular distribution for assumtion on revenue generated...
Dear Yasir, Thank you for your email - you have quite a few questions! There are a number of free resources out that that may help you. For example, at...
Hello Friends, I have a concern with crystal ball simulation. 1. When i try to copy paste data to include the same distribution, i am not able to get that...
I have posted my file as financial statement simulation. It would be great if you one of you could look into the model and run it for about 100 runs and check...
Pete, Thanks ... that's a big help going forward. ... From: p_hronovsky <peter.hronovsky@...> Subject: [CBUG] Re: Any examples of bonus / compensation...
Huybert, Can you explain a little more the reason for not modeling revenue by year? Are you suggesting that one should model the revenue or operating...
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.
