Spreadsheet for school sportsday

This spreadsheet records, counts and ranks placings for a school sportsday. Basically for Primary age pupils up to 3 form entry.

There is a tab for team events (up to 16 team events by up to 16 teams) - but you can use as many or as few as you wish -(we have red, blue, green and yellow houses and Yr3,4,5 and 6)

There are also Year 3,4,5 and 6 tabs for sprints (again 4 houses) and lastly a tab which does the relays.

It works really well, saves lots of frantic recording and calculating and makes it a lot easier for the poor scorer.

I have been using it for 5 years now. This latest version is a bit tweaked since 2019 - just a few minor changes.