Find Jobs
Hire Freelancers

Oracle Crystal Ball simulation

$30-250 USD

In Progress
Posted over 6 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 15908200

About the project

6 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 2 days
0.0 (0 reviews)
0.0
0.0
6 freelancers are bidding on average $146 USD for this job
User Avatar
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
$150 USD in 3 days
4.9 (206 reviews)
7.2
7.2
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Wilpshire, United Kingdom
5.0
127
Payment method verified
Member since Nov 11, 2003

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.