If your actual odds are in Column A

Then the "normalised to 100%" odds can be shown in Column B as

=A1/COUNT(A:A)*HARMEAN(A:A)

(replicating for all runners)


Simply delete any scratchings at any time and the thing will still work.