Find Jobs
Hire Freelancers

Oracle Crystal Ball simulation -- 2

$30-250 USD

Në vazhdim
Postuar over 6 years ago

$30-250 USD

Paguhet në dorëzim
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.
ID e Projektit: 15954406

Rreth projektit

6 propozime
Projekt në distancë
Aktive 6 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
I dhënë për:
Avatari i Përdoruesit
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
Avatari i Përdoruesit
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 në 3 ditë
5,0 (132 përshtypje)
6,4
6,4
Avatari i Përdoruesit
$200 USD në 1 ditë
4,7 (26 përshtypje)
5,1
5,1
Avatari i Përdoruesit
Hi....I have 4 years of experience in excel,VBA development . Ready to work on this project. .
$100 USD në 3 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
I have read your job post carefully and understood clearly about your need. I am really interested to work for you.
$30 USD në 3 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i UNITED KINGDOM
Wilpshire, United Kingdom
5,0
129
Mënyra e pagesës u verifikua
Anëtar që nga nën 11, 2003

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.