Shaun, there are probably two types of macro enabled excel excercises appearing out of all this. There's a pre race visual pattern recognition system as in what Josh's provided (also able to be back tested) and a longer term build a database system for analysis. Similar to what Betfair provides. You would have column headings:
Date
Country
Full Race description
Race No.
Selection name
No. of Runners
Tote Win price
Win Flag
Any others people consider important.

From that you could query the datatbase like:
Find all UK selections between $1 and $1.5 in 8 horse fields and from that determine the strike rate.
What do you think?