Find Jobs
Hire Freelancers

Oracle Crystal Ball simulation -- 2

$30-250 USD

进行中
已发布超过 6 年前

$30-250 USD

货到付款
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: 15954406

关于此项目

6提案
远程项目
活跃6 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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 在3天之内
4.5 (3条评论)
2.4
2.4
6威客以平均价$153 USD来参与此工作竞价
用户头像
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 在3天之内
5.0 (132条评论)
6.4
6.4
用户头像
$200 USD 在1天之内
4.7 (26条评论)
5.1
5.1
用户头像
Hi....I have 4 years of experience in excel,VBA development . Ready to work on this project. .
$100 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
I have read your job post carefully and understood clearly about your need. I am really interested to work for you.
$30 USD 在3天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED KINGDOM的国旗
Wilpshire, United Kingdom
5.0
129
付款方式已验证
会员自11月 11, 2003起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。