You need to have the Oracle Crystal Ball add-in for Excel to work on this project. A 15-day free trial version is available here - [login to view URL] No particular knowledge of this add-in is needed; the instructions below are sufficient and I can answer any queries.
Take a look at the attached rd2 - John Deere [login to view URL] file. The colour-coded cells mean that it is already set up to work with Crystal Ball.
First, you will need to copy the assumptions in cells F2-G2 (in green) downwards and copy the forecast in cell I2 (in blue) downwards. Note: this is not copy and paste within Excel, but copy and paste within the Crystal Ball tab. Start the simulation (10,000 trials; Monte Carlo sampling; Extreme speed run mode within 'Run Preferences') and extract the data to a new worksheet with the same title as the value in cell E2. Replace the value in E2 with '3.35' and re-start the simulation. Repeat this exercise the next number in the range M1-V1.
Once this is complete, you should have an Excel file that looks like the attached rd2 - John Deere Classic - [login to view URL] file.
The purpose is to calculate the differing win probabilities via monte carlo simulation with differing standard deviation values within the lognormal distribution.
Looking at the Oracle Crystal Ball Developer Kit documentation, there appears to be a way to use VB to run the simulations with differing standard deviations (cell E2) with one script, but I do not know enough VB to prepare this.
This is the process for one file. This project to complete this process for 350 files.
Thanks for reading.
I have a huge experience of excel, especially crystal ball simulation. I Know how to determine constraints, how to set input and output cells, and how to generate reports from it
$155 USD në 3 ditë
4,5 (3 përshtypje)
2,4
2,4
6 freelancers are bidding on average $153 USD for this job
Greetings!
I have reviewed your requirements and process steps - I understand what needs to be done. I wil first attempt to automate the simulations. If it turns out that it is not viable to do this automation quickly, I would do the process manually for all the 350 files.
If awarded, I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you.
Have a Great Day!
Srinivasan Krishnamoorthi