Manipulating an excel file with some VBA (or possibly other language)...RE-POSTED
$30-250 USD
Pagato alla consegna
(RE-POSTED PROJECT: I made a mistake in setting the budget, so I have closed the former project, and have created this one).
This project involves the conversion of a number rating into a win % probability (and decimal odds) for every runner in a horse race.
This example data set has around 500 runners. I want a simple GUI, so I can load files that are the same format as this example file (however they will be MUCH larger).
In order to achieve what needs to happen, the following steps need to occur:
Step 1: Identify and separate each race. (This can be done by either detecting a change in column B or column K).
Step 2: Extract the 'CP rating'. This is in column Y. Also keep reference information from column A to H. Everything else can disposed of.
Step 3: The rating from column Y is used as part of a formula to generate a win % probability and decimal odds. An example of how to do this is attached.
Step 4: Generate a new file with information from columns A to H, keep column Y, and the new calculated win % probabilities and decimal odds.
There are two slightly different methods I want to test. Therefore two slightly different files will be generated.
I think this is a fairly simple project, but if there's any questions, please let me know.
Rif. progetto: #4012616
Info sul progetto
Assegnato a:
13 freelance hanno fatto un'offerta media di $66 per questo lavoro
Hi, I can build a Windows standalone program to manipulate the excel file - not vba. Let me know if you're interested. Thank you.
Hi, I can develop a standalone Windows software that will do this for you. Can deliver in 3 days. Regards, Larry
Hi, I specialise in financial and trading applications in VBA. This project is very similar to my field of expertise.
Hi, would be great fun to work with you on this topic.I think I have enough knowledge and experience to make this project successful. With respect, Vytas
Hi, I have experience creating excel based solutions using formulas, macros or both. I would like to take up this project. Let me know if we can go forward. thanks & regards