I need excel specialist.
Project is pulling data and converting into calculative numbers.
We start from greyhound race card. http://www.racingpost.com/greyhounds/card.sd#resultDay=2012-10-18&raceId=1190892
If you press on dogs name you get his history runs. Looks like that. [url removed, login to view]
We need 16 last races wish has betting odds, same track and same distance,pulled into excel for all six dogs.
We need to change POS from 1234 into sum number of 12 its 3 and 34 its 7 in this case.
We need to change FIN from 1st to only number 1 no letters.
We need to change BY from 11½ to 11.5
We need to change PRICE from 7/2 to 3.5
We need to change GRD from A5 to only 5
I see this like i open excel and import race im intersted in to do my calculations. I will let you know my formulas after awarding project.
In the next page i get my results. And after race i get result updates, into excel next to my calculated card.
Please let me know if you could do this.