1. Open Excel on your computer
2. Choose TOOLS, MACROS, SECURITY
3. Click MEDIUM
4. Close Excel.
Now download the spread sheet from the web site and click ENABLE MACROS when asked. The macros format your times properly for you so that you only need type digits as you enter times.
SPREAD SHEET HAS BEEN CORRECTED. OUR APOLOGIES!
Click HERE to download spread sheet (Choose ENABLE Macros when opening)
DEADLINE: FRIDAY, OCTOBER 12TH
EMAIL COMPLETED SPREAD SHEET TO: lonny.kerman@dmps.k12.ia.us
Psych Sheet will be posted HERE by Monday 10/15
Email individual corrections AFTER this date (NOT a spread sheet)
Corrections accepted until TUESDAY, 10/16
Meet RESULTS posted here after the meet!
Directions are at the top of the Spread Sheet
Fill in the top section (Team name, Team initials, Coach’s name, Email etc..)
Fill in your athlete’s information: FIRST NAME, LAST NAME, GRADE (9,10,11,12), then enter a TIME under each event into which that athlete is to be entered. Times will be formatted for you as you leave each cell so you just type digits with the last being the HUNDREDTHS PLACE.
EXAMPLES: Type 12345 for 1:23.45 , Type 3456 for 34.56 , NT for No Time
To enter a relay type A or B or C for the FIRST NAME and then enter a time under the events for that relay.
To enter the individuals for each relay type A1, A2, A3, A4 under the relay event on the row for each swimmer who will be first, second, third or fourth on the A RELAY. Do the same for the other relays.EXAMPLE:
| FIRST | MI | LAST | 200 MEDLEY RELAY | 200 FREE | 200 IM | |
| John | Doe | A3 | 1:59.99 | |||
| Bill | Smith | A1 | 2:10.00 | |||
| A | 1:47.70 |
The above entry shows the team is entering a 200 Medley Relay
and that Bill Smith is the first and John Does is third on that relay
Meet Results