Excel Monte Carlo VBA module for Water Resources Analysis
$100-500 USD
已完成
已发布大约 21 年前
$100-500 USD
货到付款
I am developing a spreadsheet for valuing options on water transfer contracts. I would like to use Excel VBA to perform repetive Monte-Carlo analysis based on historical data. The Functions would include: 1) the ability to grab and properly format historical flow data from 5-10 sources in different .txt and .csv formats (perhaps even automatically from one of two websites), 2) allow the user to select and define appropriate distributions based on the historical data (i.e. normal, lognormal, with the appropriate means, standard deviations etc.) using best fit methods, or to define their own distributions, 3) Run 1,000 to 10,000 simulations using those distributions with some graphical display. Idealy the bidder will have experience with Statistics and Monte-Carlo, Stochastic or Probabilistic Analysis and with Excel VBA. May be additional development work if this goes well. Forgot to add that need ability to define correlations between variables with distributions
## 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 VBA code that can be understood and changed by others familiar with VBA. I'm trying to replicate some of the functionality of Crystal Ball ([login to view URL]), as I can' afford the $300+ resale license for the product I'm trying to develop. See attached file for example of product I'm trying to develop. Don't need all the bells and whistles but do need it to look relatively professional.
## Platform
Excel in Windows enviromnents