High School Dual Meet Entry Excel Spreadsheet Tool
This spreadsheet will allow you to easily compose your team’s dual meet lineup without losing track of how many individual events and relays you have swimmers entered in. Just follow these steps:
- Download the excel sheet.
- On the sheet called “Reference”, type in the information for your meet, your swimmer’s names (max 35 per team), how many lanes are in the pool, and whether your team is in the odd or even lanes.
- Compose your lineup in the sheets named “Men’s lineup” and “Women’s lineup,” selecting your swimmers’ names from the drop-down in each cell for each event. The page will count the number or individual and relay events you have entered for each swimmer. The cell will turn red if you exceed two individual events or 4 total events for one swimmer.
Determining Goal Paces
Use these excel spreadsheets to create a customized “pace card” for each of your athletes. This will allow you to train precisely at race pace for every event you could possibly swim!
Choose your course: SCY SCM LCM SCM training for SCY events
Be sure to look at the “Pace card instructions”
The Swimming Calculator
Your time in a swimming race depends upon the tempo, cycle count, stroke length, turns, and underwater kicking that you employ. The Swimming Calculator is an excel spreadsheet that allows you to manipulate these factors and see the effect on your time. Do you know how many strokes and at what tempo you need to take them to make that cut? The Swimming Calculator can help you figure it out. This is something I am still tinkering with and would love to have input about from other coaches.
The 15m Chunks Chart for Sprinters. This chart gives race paces for starts, turns, and finishes. Use it for training or in racing to judge these technical elements of your race.
Jon Urbanchek’s Excel Sheets for Aerobic Distance Training
Many of you know and admire the legend, one of the funniest and most successful men on the pool deck. He pioneered distance training based on the T-30. Click here to download his Excel sheets for determining training paces.