Athletics team competition results spreadsheet

An excel spreadsheet that allows you to run an ongoing team competition in PE in core athletics lessons. By using a scoring system of 10, 7, 5 and 3 in each event based on Bronze Silver and Gold standards included at the bottom of the sheet pupils score points for their team based on their performance.
After inputting the score based on the athletic performance, the sheet works out average score per pupil per event, meaning that you can have an ongoing competition over a series of weeks and it does not really matter the size of the team or if a pupil misses an event as the average scores remain relatively close.
You can keep the scores updated and displayed on boards to encourage healthy competition.
We run this every year with year 10 boys and girls groups and it works well and ensures that pupils are motivated. We even treat the top few performing teams in a year group to a KFC meal. We added a column for correct kit on the boys one so took off points for any incorrect kit which led to peer pressure to have the right kit.