I need someone that can program excel to do monte carlo simulations on a set of times to determine resulting possible combinations. The times are speed figures. I'd prefer the finished product to work in open office in addition to excel because that is the software I use most. As an example, I would like to be able to enter 3 finish times of car (A), 3 finish times of car (B), 3 finish times of car (C), then run monte carlo simulation to predict finish positions if the 3 were to compete, how many times each would finish in what position as well as a predicted time.
This is not the job, but rather an example of how i would need data manipulated.
attached is a screen shot of a DOS based program that does what I want excel to do. This program can be supplied to you if it helps you complete the job.
Dear Sir
This project seems interesting and doable based on my past experience with this type of problem.
THE SOLUTION:
============
This is an easy task and should take about 3 hours to complete.
I will build an input table to allow user to imput variables assumptions / possible outcomes.
The main routine will then run the monte carlo method to determine the possible outcomes(for a given number of iteractions) and calculating the output %)
I can start working on a FREE SAMPLE. Just send me a example of your files / objectives.
Thanks
ABOUT TABLASSUS SOFTWARE:
==========================
I've been working on this kind of work on the past 8 years (handling complex data in excel files). In my actual work I deal with complex data structures (using excel) so achieving your goal shouldn't be a problem.
I have +20 years of programming experience being highly skilled in Visual Basic (VB or VBA for applications).
I also excel at Math, Statistics and genetic algorithms applied to computation.
I have Skype / MSN in case you need to schedule up a meeting. I have excellent communications skills / english language background.
Even so, it seems a very nice and challeging project.
Feel free to ask for more details / information
Looking forward to hear from you and start this interesting project.
Best regards
Filipe Francisco , VB Expert
==============================
Tablassus Software
"Simple solutions for complex problem
$55 USD in 1 day
5.0 (14 reviews)
4.8
4.8
15 freelancers are bidding on average $111 USD for this job
Hello; I ama 5-star excel and vba coding expert, with a profound statistics & finance know-how. I read your project descriptions and saw your screen shot. I know exactly what you need; I am familiar with MC simulations too. I would like to help your project; kindly get back to me if you wish to proceed with a top-rated and reliable partner here...regards,
Hey radioboy969, yes, please share the DOS program - we like to have a look at it... You like to get this working in excel as well as OpenOffice and we recommend you to get this done by JAVA + CSV... Please reply and we can discuss more... thank you :-)
Hi,
I have plenty of experience implementing Monte Carlo simulation using Excel/VBA. On top of what you need, I can also provide the probability distribution of the results.
Let me know if you have further questions.
Frank
We have expertise in Excel based statistical solutions.
We offer you quality, commitment, priority and flawless execution.
We can even conduct on-line support sessions.
Greetings!
I am a PhD student in statistics. I believe i can help you with your task. If you would please give me the dos program and 2 days I believe I can provide you with the needed code.
I'm trying to cut my teeth on freelancer, so this is my first project, and I'd be willing to do it for the minimum so I can get the experience on here.
Seems to be a rather straight forward project. I run open office so that shouldn't be an issue. If you need any specifics as to how I make it work let me know.
I am known as the the excel guy throughout my fortune 500, and help with projects all across North America, so I could knock this out for you reasonably quickly.