Find Jobs
Hire Freelancers

Oracle Crystal Ball simulation -- 2

$30-250 USD

In Progress
Posted over 6 years ago

$30-250 USD

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

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
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 in 3 days
4.5 (3 reviews)
2.4
2.4
6 freelancers are bidding on average $153 USD for this job
User Avatar
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
$180 USD in 3 days
5.0 (132 reviews)
6.4
6.4
User Avatar
$200 USD in 1 day
4.7 (26 reviews)
5.1
5.1
User Avatar
Hi....I have 4 years of experience in excel,VBA development . Ready to work on this project. .
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have read your job post carefully and understood clearly about your need. I am really interested to work for you.
$30 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Wilpshire, United Kingdom
5.0
129
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.