Help building Excel sheet for secondary school athletics scoring (track & field)

Body:
Hi everyone,

I’m looking to create an Excel system to score secondary school athletics competitions and could use some guidance or templates. Here’s what I need:

Events included:

• Track: 100 m, 200 m, 400 m, 800 m, 1500 m, 3000 m, 100 m / 110 m hurdles, 400 m hurdles, 4×100 m relay, 4×400 m relay
• Field: Long Jump, High Jump, Triple Jump, Shot Put, Discus, Javelin

Scoring system:

• Position-based scoring for most events: 1st = 10, 2nd = 8, 3rd = 6, 4th = 5, 5th = 4, 6th = 3, 7th = 2, 8th = 1
• Relays may be double points (optional)
• Field events scored by best legal attempt
• Want automatic total points per school/house and rankings

What I need help with:

• Formulas to automatically calculate points based on position or performance
• Conditional formatting to highlight winners per event
• Automatic summing of points across events to rank houses/schools