cpw Good thread.
I've only scratched the surface using Chat gpt for excel functions/conditions in relation to compiling horse race ratings.
My approach is slow and steady as I want to ensure each piece of data is relevant to the whole rating, convert to a tissue price and compare the live market for value...etc
Some of the data sets you've posted look promising, as it gives the total ratings at the end. It's just a question of how much weighting/adjustment is made for each piece of data to obtain consistent results. That bit will take time, dependant on your own knowledge/experience.