Google Sheets Functions

Convert performances into World Athletics points directly in your spreadsheet.

What does it do?

It adds five formulas to Google Sheets. With WA_SCORE and WA_MARK you convert any athletics performance into World Athletics points, or the other way round, and compare results across events, athletes or rivals without leaving your spreadsheet or doing the maths by hand. With WA_COMBINED_SCORE and WA_COMBINED_MARK you calculate the points of each event in a decathlon, heptathlon or pentathlon. And WA_VERSION tells you which tables it uses.

Buy for €29

One-time payment. Instant download. Ready-made template included.

Your scoresheet, calculated

Type the event, the athlete and the mark. The points appear on their own, and so does the team total.

G6fx=WA_SCORE($B$2, A6, F6)
EventAthleteMarkPoints
100mMaría García12.61874
200mLaura Pérez25.95856
400mSofía López57.28931
800mCarla Fernández2:14.14923
100mHAlba Ruiz14.041013
Total (18 events)15197
The Scoresheet tab of the template, with real results calculated by the formulas.

Two ways to start

Choose the one that suits you. Both give you exactly the same formulas.

Recommended

Use the template

Nothing to install. A spreadsheet with the script already inside, plus a scoresheet, a decathlon, examples and the list of events.

  1. Open the template link in the README you download.
  2. Click Make a copy: it's saved to your Google Drive.
  3. Start typing marks. That's it.

Add it to your own spreadsheet

If you already have a spreadsheet and want the formulas there.

  1. Go to Extensions → Apps Script.
  2. Delete the sample content in Code.gs and paste the script.
  3. Save, close the editor and reload your spreadsheet.
  4. The WA 2025 menu appears and the formulas are ready.

Why does Google ask for permission? The first time any custom script runs in a spreadsheet, Google shows an authorisation screen. It's the standard process for every script, not a sign that something is wrong, and it only appears once.

Adding the script to your own spreadsheet takes under 30 seconds.

How to use the formulas

This video shows how to write WA_SCORE to convert a performance into points. Like every formula in Google Sheets, it starts with =.

WA_SCORE(gender, event, mark)

You can select cells or type the values directly in quotes, for example =WA_SCORE("w", "800m", "2:14.14"). Depending on your spreadsheet's language, the separator is a comma or a semicolon.

Available functions

These are the five formulas the script adds. Use them as many times as you like, in as many spreadsheets as you need.

Quick reference for the available formulas.
FunctionDescription
=WA_VERSION()Returns the version of the tables in use.
=WA_SCORE(gender, event, mark)Converts a performance into World Athletics points.
=WA_MARK(gender, event, points)Converts World Athletics points into the equivalent performance.
=WA_COMBINED_SCORE(gender, event, mark, [manual])Points of one event inside a decathlon, heptathlon or pentathlon. The optional fourth parameter applies the manual timing adjustment.
=WA_COMBINED_MARK(gender, event, points)Mark needed for a score in one event of a combined event.

If something isn't valid, such as an unknown event, the formula shows a message explaining why instead of a cryptic error.

Times of one minute or longer

Google Sheets turns entries like 2:14.14 into a clock time. To avoid it, format the Mark column as Format → Number → Plain text, or type an apostrophe first: '2:14.14. In the template, this is already done for you.

Made with care, by one person

Hi, I'm David Ballester Ribó, national athlete, and I built every tool on this website myself. I made these formulas so that clubs, coaches and athletes can do in their own spreadsheets what my calculator does on the web, without copying numbers by hand.

Behind them is the same work as the rest of the site: I turned the official PDFs into clean data, applied the rounding rules exactly as World Athletics publishes them, worked out the formulas behind the tables and compared the results value by value until every one matched. That work is also why the script went from 1.8 MB in its first version to just 81 KB today.

David

David Ballester Ribó competing in the 400 metres hurdles at the Spanish U20 Championships, 2024

Use your own names

From the WA 2025 → Configure Aliases menu, you can use the names you already have in your spreadsheet, such as "Women" instead of w or "High Jump" instead of HJ. Set them up once and use them in all your formulas, including the combined events ones.

How to set up an alias, step by step.

Aliases are optional: the official identifiers always work, and the full list is included in the download. An original identifier, such as HJ, can't be reused as an alias for another event.

Import and export

If you work with several spreadsheets, export your aliases from one and import them into the others, so you only set them up once.

Import previously configured aliases.Export previously configured aliases.
Import and export aliases to use them in several spreadsheets.

Frequently asked questions

Do I need to know how to code?

No. With the template you don't install anything: make a copy and start typing. If you'd rather use your own spreadsheet, you paste the script once and never touch the code again.

Does it work in Excel or LibreOffice?

There's a LibreOffice Calc version with the same formulas, and an Excel version is in the works. I'll release it once it's fully tested.

Is there a limit on how many times I can use the formulas?

No. Use them as many times as you like, in as many spreadsheets and cells as you need.

What happens when World Athletics publishes new tables?

This version uses the 2025 tables and always will. When new tables are published, I'll release a new version, and previous buyers will receive a discount link. If an error is found in this version, you'll receive the correction for free.

Does it depend on an external server?

No. The tables are built into the script, so the calculations don't depend on my website or any external service. Like any Apps Script function, they run while Google Sheets is online.

Is this an official World Athletics product?

No. It's an independent project that reproduces the official World Athletics Scoring Tables 2025.

Get started

Everything you need to calculate World Athletics points in your own spreadsheets, in a single purchase.

Google Sheets Functions

€29

For clubs, coaches, athletes and anyone who works with marks.

  • All five formulas, including the combined events ones
  • Template with a scoresheet, a decathlon and examples
  • Aliases to use your own names
  • No limit on spreadsheets or uses
  • Script, template and documentation in English
  • Free corrections and email support
Buy for €29

Questions about the formulas, or not sure if they fit your project? Write to me and I'll help you.

One-time payment. Instant download. Ready-made template included.