Race Record Spreadsheet

Race Record (2025 WAVA)

We are excited to share a much needed updated version of the old Race Record sheet that Danny been developing over the last few months of 2025! This is a comprehensive spreadsheet for tracking and logging races and parkruns, but it goes much deeper than just a simple list. It automatically calculates WAVA (Age-Graded) scores, tracks Club Standard Times (Copper through to Platinum+), highlights Personal Bests, and gives you a full Yearly Review of your stats.

Try the Google Sheets Version: You can grab a clean copy by clicking the button below

(Note: You will need a Google Account to make a copy and save it to your own Drive.)

Race Record (2025 WAVA)

Calling all Excel Experts!

While the Google Sheets version is running smoothly, Danny is currently working on an Excel conversion so people can use it offline. However, He's finding it a challenge to translate some of the complex QUERY functions and dynamic array logic from Google’s language into Excel’s native formulas.

If there are any Excel wizards out there who are familiar with advanced Power Query or dynamic arrays and fancy a challenge, please get in touch! I’d love some help getting the Excel version over the finish line.

In the meantime, enjoy the Google Sheets version helps you.

How to Use

Introduction

Welcome to your central hub for race and parkrun tracking. Including:

Calculate Age-Graded scores (WAVA) automatically for races.
Monitor progress toward your Club Standard Times.
Track Personal Bests across multiple race distances.
Milestone Planning: Calculate the exact times needed to hit your next WAVA goal.

⚡ Quick Start Tips

The Foundation: Accuracy depends on the User Details tab. Ensure your Gender and DOB are correct before entering data.
Data Integrity: Always use DD/MM/YYYY for dates and HH:MM:SS for times.
Road vs. Road (NAD): Use "Road (NAD)" (Near As Damit) for short courses or races without a certificate to keep your official PB's and Club Standard stats accurate.

📖 Key Terminology

WAVA (World Association of Veteran Athletes): A percentage score comparing your performance against the world record for your age and gender.
- Note: 60% is generally considered a solid club-level performance.
Club Standard Times: A tiered award system (Copper....Platinum +) based on your age category and times.
Note: Our club standards and WAVA are slightly different to those published by WMA
Chip Time: Your actual official running time from start line to finish line, if that isn't available use the official gun time.

🔄 Upgrading from a Previous Version?

If you have been using the older version of this record sheet, you can easily move your data across to this new version.

Important Tip: Because there are new columns and a slightly different layout, do not copy and paste your entire table at once.

How to migrate your data safely:

Column by Column: Copy data one column at a time from your old sheet (e.g., just the "Race Name" column) and paste it into the corresponding column in the new "FILL IN" tabs.
Important: Data Only: When copying, select only your race data. Do not copy the headers or sub-headers from your old sheet, as these will interfere with the new formulas.
Values Only: When pasting, it is highly recommended to use Right Click > Paste Special > Values only. This ensures you don't accidentally bring over any old formatting, borders, or hidden formulas.
Check the "Type" Column: The new version relies heavily on the Type (Road, Trail, etc.) being selected correctly from the dropdown. Make sure these match the new categories to ensure your WAVA and Standard Times calculate correctly.
Date & Time Check: Once pasted, double-check that your dates and times are still in the correct DD/MM/YYYY and HH:MM:SS formats.

🛠️ How To Use (The Basics)

Step 1: Go to "User Details - FILL IN" and select your gender and date of birth.
Step 2: Go to "Races - FILL IN" to log race data (Date, Name, Type, Distance, Positions, and Time).
Step 3 (Optional): Go to "Parkrun - FILL IN" to log your parkrun results.

🧠 Enabling the Spreadsheet "Brain" (App Script)

Some features like automatic resetting require Google App Script. You don't need to write any code, but you must "Authorise" it once for it to work.

How to Enable:

Open Editor: At the top go to Extensions > Apps Script.
Run Setup: Click the Run (triangle) icon in the toolbar.
Permissions: A "Google hasn't verified this app" warning will appear. This is normal for private scripts.
- Click Advanced.
- Click Go to [Delete on Start / Edit] (unsafe).
- Click Allow.

FAQ:

Is it safe? Yes. Only you have access to this script.
Why "Unsafe"? This is Google's standard label for personal, unreviewed scripts.
Do I do this every time? No, just once!

🖥️ Sheet Tabs Overview

Interactive Tabs (Where you enter data)

User Details: Set up your profile for WAVA and Club Standard calculations.
Races - FILL IN: Your main logbook. This can then calculates PB status, Pace, and WAVA for every entry.
Parkrun - FILL IN: Dedicated space for parkrun history.
Year Review: Select a year from the dropdown for a complete statistical overview.
LOOK UP - Race: Filter and sort your past races by type, distance, or name.
WAVA Calculator: Look up a score based on a time, or find a target time based on a percentage.

Analysis Tabs (View Only)

League Races: A filtered view showing only club league appearances.
STATISTICS: Your overall and yearly totals in one place.
STATISTICS - PBs: View current PBs and compare them to your previous bests.
STANDARD TIMES - List: Your personalised time targets for each award tier.
Standard Time (Current/Previous): Displays your best qualifying races for the season—perfect for award submissions.

📝 Detailed Data Entry Guide

Race Type Definitions

Road: Certified road courses. Use for official PBs and Club Standards.
Road (NAD): Use for uncertified or slightly short courses to exclude them from official PBs.
Cross Country: Off-road league or championship races.
Mixed Terrain: Road races with sections of grass/trail that prevent official measurement.
Trail: Marked paths with undulations.
Fell: Steep, technical, mountainous terrain.
Track: Races run on a 400m track (Enter distance in KMs, e.g., 1500m = 1.5).

WAVA - Calculator

Age (Today): Uses your current age.
Age (Insert Date): Enter a race date in cell A3 to see what your score would be on that day.
Standard Time Age Cat: Calculates based on your specific club award age bracket.
DOB: Enter a custom birth date in cell A3 for flexible lookups.

🔍 Troubleshooting & FAQ

Why is my WAVA or Standard Time showing "No Details" or blank?

Missing User Details: Ensure you have filled in your Gender and Date of Birth in the "User Details - FILL IN" tab. The spreadsheet cannot calculate age-graded stats or club standards without these.
Incomplete Row: Check that both the Distance and Time have been entered for that specific race.
Zero Values: Ensure the distance entered is greater than 0.
Race Type: The Race Type must be set exactly to "Road".
Non-Standard Distance: To appear, the race must be one of the following recognised distances:
- 5K (3.1 Miles)
- 5 Miles (8.04KM)
- 6 Miles (9.65KM)
- 10K (6.2 Miles)
- 7 Miles (11.26KM)
- 8 Miles (12.87KM)
- 10 Miles (16.09KM)
- Half Marathon (21.08KM / 13.1 Miles)
- 20 Miles (32.18KM)
- Marathon (42.16KM / 26.2 Miles)

The "Best Road Races" block in the Year Review is empty. Why?

Check the "Type" Column: The Year Review specifically looks for the exact word "Road" in the Type column. If you categorised a race as "Road (NAD)" or "Mixed Terrain," it will not appear in the Road Race summary.
Distance Match: The Year Review looks for standard distances (5KM, 5 Mile, 6 Mile, etc.). If your race was a non-standard distance (e.g., 4.3 miles), it will be counted in your total stats but won't appear in the "Best" list.

The "LOOK UP" filters aren't showing any results.

Filter Order: Remember to fill in the filters from left to right. The "Distance" filter depends on the "Race Type" filter. If you jump straight to the name, it may be empty or the logic might get confused.
Clear Filters: If you get stuck, clear all filter dropdowns (set them back to blank) and start from the first column again.

Can I use this on my phone?

Viewing: Yes, the Google Sheets app is great for viewing your stats on the go.
Data Entry: You can enter data on mobile, but for the best experience (and to use the App Script features like automatic sorting), it's recommend to use a Desktop/Laptop browser.

I accidentally deleted a formula! What do I do?

Undo: Use Ctrl + Z (Windows) or Cmd + Z (Mac) immediately.
Version History: If it's too late, go to File > Version History > See version history. You can restore the sheet to a point before the formula was deleted.
Fresh Start: If the sheet is still acting up, you can always click the original link to download a new, clean copy. You can then simply copy your race data from the old sheet into the new one to get back up and running.