I am creating an excel proramme which is going to used to perform simulations of projected results.
The programme is being created using VBA in excel.
I have already done approximatly 50% of whats need to be done, the rest i need done for me due to very time restraints.
I currently have a programm that has a number of data colums, some generated using a random number generator. Each time the random number chages this changes all the values in other colums and i get my results.
The problem is that i have created everything using macro recorder in excel. I need to creat flexibilty in the programm, where the user is prompted for the 'number of projection years' and the out put affects where the results are read from, and how many process are run, and how many random numbers are generated.
So firstly i need felxibilty created into the programm and a user interface.
Once this is done, i will need the same programm to perform that a small mathematical process of splitting values between columns and letting it run to then have my projected returns.
The basic story is that i have to create a progamm which i can manipulate to obtain data from, which i then analyse. The programme is to project as manyy yeras into the future as the user wants with as much money as they want invested and in the split between equity and gilts that the user chooses. With this information the progamm to go and run (this bit, and the mathematics and the basic infrastructure i have done). But i need the elemets of the responses of the user to be effective in what i have done.
Note this is model one/ I will need two other models, the two bring very similar to the above and only different in the way that the mathematical process is doen. If all these can be combined into one programm i will not mind.
Anyone how can help me change from a rigit proramm to one that is flexible to different inputs, please contact me.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
MS Excel 2000. (and all versions if possible)