You need to have the Oracle Crystal Ball application for Excel to work on this project.
Take a look at the attached rd2 - John Deere [login to view URL] file.
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. 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.
This is the process for one file. This project to complete this process for 350 files.
Thanks for reading.
Dear Hiring Manager,
Hope you doing well.I have gone through your job-posting and become very eager to work with you.I have a group of young energetic team please inbox me.
Thanks!!
Rokunzzaman
$155 USD v 2 dnech
0,0 (0 recenze)
0,0
0,0
6 freelanceři nabízejí v průměru $146 USD za tuto práci
Greeting,
I have understood your Oracle Crystal Ball simulation task and can do it with your 100% satisfaction. Please ping me for more discussion.
I have more than 5 years of experience in Excel, Excel Macros, Excel VBA, Oracle