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.
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)
Event
Athlete
Mark
Points
100m
María García
12.61
874
200m
Laura Pérez
25.95
856
400m
Sofía López
57.28
931
800m
Carla Fernández
2:14.14
923
100mH
Alba Ruiz
14.04
1013
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.
Open the template link in the README you download.
Click Make a copy: it's saved to your Google Drive.
Start typing marks. That's it.
Add it to your own spreadsheet
If you already have a spreadsheet and want the formulas there.
Go to Extensions → Apps Script.
Delete the sample content in Code.gs and paste the script.
Save, close the editor and reload your spreadsheet.
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.
Function
Description
=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
Checked value by value
Every mark of every table, from the 50 metres to the mixed relays.
Official rounding rules
Applied exactly as World Athletics publishes them, such as road events in whole seconds.
Free corrections
If an error is ever found, every buyer receives the corrected version.
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 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