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
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 are deliberately run in training sessions with many small groups, many sessions and occasionally ad-hoc swims …

Uncategorized

National Arena Swim League 2019 2021 (NAL) Ares21 events file.

Posted on October 14, 2019 by lemanadmin / 8 Comments

Here is a quick and dirty spreadsheet I used to make all the files for the Omega Ares21 AOE system for a NAL swim meet.

Why use a spread sheet, because I don’t like typing all the events in to …

Uncategorized

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

Posted on September 15, 2019 by lemanadmin / 4 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 Unify in the first place.

Using …

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 if it took just 1 min to check each one on rankings it …

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, and you can then manipulate the times with ease, but the …

Uncategorized

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

Posted on August 18, 2019 by lemanadmin / 0 Comment

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 …

Uncategorized

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

Posted on December 11, 2018 by lemanadmin / 0 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 compete in, ready to import in the Team Unify.…

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 for the Kent champs.

If you have not uploaded your …

Search

Recent Posts

  • A simple spread sheet to generate rankings results files for Level-X May 21, 2021
  • National Arena Swim League 2019 2021 (NAL) Ares21 events file. 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
  • Working in Excel with MM:SS.00 swim times (part 2) August 22, 2019

Tags

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