Maintaining statistics of swimming results for your athlete

Many of us have children who play sports. This article is for those whose children are engaged in swimming.

We see the results of many years of trips to the pool in two ways:

• in medals and photos of our athlete on the wall,
• and also in seconds and milliseconds for which he swims a particular distance.

Medals and photos are easy to save. But the results of the swims can only be saved by recording them. In this article we will look at an Excel spreadsheet for collecting statistics on swims for your athlete.

What is such a table for?

The statistics of the results are necessary so that you can track the dynamics of changes in the results. Has your athlete improved or worsened his performance after the next competition. You and I know that a medal is certainly good, but in fact it is important to improve your own performance. Therefore, it is important to monitor whether the athlete improves his performance or worsens. Or maybe it's standing still. Well, take action. At least discuss it with the coach.

The structure of the file in question

The file consists of two tables:

• Results;
• Data entry.

Results table

This sheet displays accumulated statistics on swims in the format of minutes: seconds, milliseconds. As always, let's look at the columns:

Column A "Date" — date of the swim.

Columns from B to Z — swimming styles with distance indication. There are five distances in each style.

Column AA "Number of swims" — it is calculated how many swims there were on the specified date.

Оplease note that the cells with the swim data are painted in different colors. This is an automatic coloring where dark green indicates the best result, and red indicates the worst. The color of the data cells will constantly change as new swim data is entered. And now, at some point, the green result will turn yellow, and then red. Because your athlete is swimming faster and faster, and accordingly, what was the best indicator a year ago, today will already be a mediocre indicator.

Important! You will not be able to simply enter data on the results of the swims, due to the fact that Excel does not have a standard data format for displaying minutes, seconds and milliseconds. Therefore, to get the results table, you need to fill in the data entry table.

Data entry table

In this table, you enter data about the swim in columns: minutes, seconds, milliseconds (this is columns B, C and D accordingly). After making the Column E you will get the result of the swim in the correct format. Moreover, it will be a digital format with which you can manipulate in Excel, as with a digit.

To get data from column E got into the results table — you need to specify: swimming style, distance, date of the swim (this is columns F, G and H accordingly).

Please note that data needs to be entered only in those columns that are highlighted in orange and only on the Data Entry sheet. Nothing is entered manually on the Results sheet!