Find Jobs
Hire Freelancers

Correlating Inputs In Monte-Carlo Simulation Excel Add-In (VBA & C++)

$500-5000 USD

已关闭
已发布超过 20 年前

$500-5000 USD

货到付款
This project requires experience with simulations, statistics and VB and C++. Please include relevant experience in bid. I have an Excel Add-in developed by a rent-a-coder. The add-in addes Monte-Carlo Simulation ability to Excel. The user can define random inputs using Normal, Lognormal, Weibull, Uniform, Discrete and Triangular Distributions. The add-in then allows the user to process 1,000's of iterations and display the results. The problem we ran into is that we do not know how to appropriately correlate the inputs. For example, if the inputs are five rivers flowing into a single reserovir, their flows will be highly correlated. We need to add the functionality that allows the user to enter correlations or a correlation matrix for the inputs and have the program generate appropriately correlated random inputs from the defined underlying distributions. The correlations need to work across different inputs (the five rivers) and over time (Nov. flows are correlated with Oct. flows, and there is a seasonal shape, March is the highest, September is the lowest). This needs to be easy to use for a non-technical user, and we have to avoid overly complex and internally inconsistent correlation matrices. Attached Example shows type of data and analysis we will be dealing with and the problems with correlations between inputs and over time. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. 4) Well documented code that can be interpreted and modified by others familiar with C++ and VB. 5) Professional looking input and output in Excel 6) Thoroughly debugged and error checked product 7) Program that produces statistically valid results in Monte-Carlo simulations ## Platform I have a add-in written in C++ and VBA which I will provide upon request to potential bidders. Input and Output provided in Excel. Would like this to work with Excel 97 and higher, on Microsoft Windows.
项目 ID: 2957706

关于此项目

2提案
远程项目
活跃21 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
2 freelancers are bidding on average $1,700 USD for this job
用户头像
See private message.
$1,700 USD 在60天之内
0.0 (0条评论)
0.0
0.0
用户头像
See private message.
$1,700 USD 在60天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
United States
4.6
13
会员自6月 8, 2002起

客户认证

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