A real simple small project.
I require a parse of data everyday, with a small calculation put into the data after it is parsed, then the data needs to be printed.
The website the data needs to be parsed from is
[url removed, login to view]
This is a horse racing website,
An example of the parse required is the horse field is attached.
I need it to end up like this
1 MOONEE VALLEY
1000 Good NMW HCP $24000
1 113368 COUNT TO ZERO 565
2 x30x51 SIZZLED 490
3 281181 MOUNT VERNON 555
4 4205x0 MIGHTY MIRAGE 485
5 377x51 NUCLEAR ROO 395
6 11x133 STAR ROSE 610
7 0x1122 LORD BENBARA 520
8 43x1x1 SWINGBRIDGE 485
9 -72x21 RUSTIC MOON 425
10 7070x1 MAT'S JEWEL 405
Same as above, but would like it from highest number to lowest that is on the right hand side.
The 3 diget number on the side is calculated from the other data in the parse. This number needs to be calculated out out. please see attached data for an example of the number, this is found in the horses form.
last start 50% of the figure
2nd last start 40% of the figure
3rd last start 10% of the figure
The races need to look like what is above, and be able to be printed to a word doc, with meeting to a page, Normally there are 8 races per meeting, sometimes 9 or 10, but that is rare.