The Triple Thread

Following our July 18th email on Race League Tables, we have developed new features that are now available as BETA versions.

The first updated feature is the Race League Generator. It allows you to create a race league table for male and female club members based on their race finish times. You can choose which event distances to include and for which year. Add the points for first place for each event distance, click Submit, and your club's race league will be generated and downloaded. The table will display names, events, finish times, and points for each club member (registered app users only).

We also have a Results Checker that lets you query the database for finish times over selected distances for a specified period or check results for individual members.

A new feature, Race Results Download/Upload, allows you to download a results spreadsheet for a selected event, showing the finish times (H:M:S:MS) for each club member (registered app users only). Members who haven't entered their finish time or didn't attend the event will show as 00:00:00:00. You can input the finish time on behalf of your club members, edit and save the spreadsheet, then re-upload it. The finish times and any PBs/Season's Best times will be updated.

Why not use Run Britain Ranking/Power of 10 data?

We contacted Run Britain to inquire about an API for connectMyClub to access data from Run Britain Rankings/Power of 10. Unfortunately, there is no API available for third-party use.

Newsletter Events List

In your club's next newsletter, any member who achieves a year's best result in an event will be highlighted in bold for the entire club to celebrate their achievement. Be sure to switch on the Events toggle to see this update.

The features mentioned in this email are BETA versions. If you notice anything incorrect or have suggestions for improvement, please let us know.

We're excited to highlight an improved feature to help clubs to create a race league table throughout the year. Under Organise > Race League, you will now find a Download Full Race League button with a year selector. Clicking this button will generate and download a spreadsheet displaying the best times of the year for all distances from 5k to Full triathlon for all club members.

The spreadsheet includes columns for First Name, Last Name, Event, Distance, Time, Milliseconds, and Points, divided into tabs for Male, Female, and None, the latter for members whose gender isn't recorded.

The first five columns are straightforward. Points is left blank for your club's calculations. Milliseconds stores race finish times from the connectMyClub database, enabling easy sorting from fastest to slowest to identify the quickest times across distances.

If your members have connected their Strava or Garmin accounts to connectMyClub, their assumed parkrun times will be included in the spreadsheet. The criteria for assuming a parkrun are:

• The distance is between 4.85KM and 5.3KM
• The run starts between 8:55am and 9:05am / 9:25am and 9:35am on a Saturday

With a connected Strava or Garmin account, your members' race finish times are obtained from GPS data, in case they forget to manually add their finish time after their race.

We hope this updated feature will assist your club in the challenging task of compiling a race league table.

DON'T FORGET to remind your members to add any events they've entered into their connectMyClub app Upcoming Events. Without their data, connectMyClub cannot obtain their race results.