Converting times between different lengths of course is a necessary evil in swimming, even though it is rarely accurate. Many competitions will accept converted times but care must be taken to use the correct conversion method to avoid confusion and …
A simple spread sheet to generate rankings results files for Level-X
Probably suitable for Level-X, level-4 meets or small inter-club galas etc.
Introduction:
Producing the results for level X events is a PITA. The events are deliberately run in training sessions with many small groups, many sessions and occasionally ad-hoc swims …
National Arena Swim League 2019 2024 (NAL) Ares21 events file (also for Quantum)
Here is a quick and dirty much improved spreadsheet I used to make all the files for the Omega Ares21 AOE system for a NAL swim meet. Now our club has upgraded to Quantum I have found this can also …
Problems with Team Unify, swim times, club records and swimmers age
Our club uses Team Unify. I love and hate it with equal measure, which is a bit of an odd thing to say as I was instrumental in pushing the club to use Team Unify in the first place.
Using …
Using ‘Club Rankings’ to find club records
Maintaining club records manually is a chore! Our club records have 12 age bands, 18 events, 2 genders and Short Course/Long Course. That is 864 records. Even if it took just 1 min to check each one on rankings it …
Working in Excel with MM:SS.00 swim times (part 2)
In Part one I gave a method to work with MM:SS.00 times in excel, stored as text to prevent excel corrupting them. Converting them to decimal seconds works well, and you can then manipulate the times with ease, but the …
Working in Excel with MM:SS.00 swim times (part 1)
Excel is an amazing tool and is used and abused to perform many tasks it was not originally intended for. One thing it should be good at is calculating times, however in swimming we tend to use times in the …
Using ‘Club Rankings’ to fetch Gala results and import in to Team Unify
I have spoken to many clubs who use Team Unify and don’t know that there is an easy way to get a results file for any gala licenced their club members compete in, ready to import in the Team Unify.…
Using TeamUnify to see who in your club has qualified for the Kent county swimming championships 2019 2020
If your club uses TeamUnify and if you have uploaded the gala results for your club in to TeamUnify, then you can produce a report which shows who has qualified for the Kent champs.
If you have not uploaded your …