Skip to content
Wrangling with wires
Random thoughts on Swimming, running swimming events, electronic time keeping, photography and other stuff
  • Twitter
  • Email
  • Home
  • About
  • Photos
  • Contact

Category: Uncategorized

Uncategorized

Converting swim times between short and long course in excel using the British swimming Equivalent Time Algorithm

Posted on November 8, 2024 by lemanadmin / 0 Comment

Converting times between different lengths of course is a necessary evil in swimming, even though it is rarely accurate. Many competitions will accept converted...

Uncategorized

A simple spread sheet to generate rankings results files for Level-X

Posted on May 21, 2021 by lemanadmin / 0 Comment

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 a...

Uncategorized

National Arena Swim League 2019 2024 (NAL) Ares21 events file (also for Quantum)

Posted on October 14, 2019 by lemanadmin / 8 Comments

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 ...

Uncategorized

Problems with Team Unify, swim times, club records and swimmers age

Posted on September 15, 2019 by lemanadmin / 8 Comments

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 Uni...

Uncategorized

Using ‘Club Rankings’ to find club records

Posted on September 8, 2019 by lemanadmin / 0 Comment

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 i...

Uncategorized

Working in Excel with MM:SS.00 swim times (part 2)

Posted on August 22, 2019 by lemanadmin / 3 Comments

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...

Uncategorized

Working in Excel with MM:SS.00 swim times (part 1)

Posted on August 18, 2019 by lemanadmin / 2 Comments

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, h...

Uncategorized

Using ‘Club Rankings’ to fetch Gala results and import in to Team Unify

Posted on December 11, 2018 by lemanadmin / 1 Comment

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 com...

Uncategorized

Using TeamUnify to see who in your club has qualified for the Kent county swimming championships 2019 2020

Posted on November 29, 2018 by lemanadmin / 0 Comment

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...

Search

Recent Posts

  • Converting swim times between short and long course in excel using the British swimming Equivalent Time Algorithm November 8, 2024
  • A simple spread sheet to generate rankings results files for Level-X May 21, 2021
  • National Arena Swim League 2019 2024 (NAL) Ares21 events file (also for Quantum) October 14, 2019
  • Problems with Team Unify, swim times, club records and swimmers age September 15, 2019
  • Using ‘Club Rankings’ to find club records September 8, 2019

Tags

Club Rankings (3) Excel and Swim results (2) Kents19 (1) Kents20 (1) NAL (1) TeamUnify (4)
© 2025 Wrangling with wires
Powered by WordPress | Theme: Graphy by Themegraphy