For race directors

Sheets

Spreadsheets for your race, with formulas, charts and your race's live numbers built in. Keep your budget, shirt order, volunteer plan and more next to your documents, where your co-directors can open them too.

Making a sheet

In your event's dashboard, open Documents under Setup, press New, and pick Sheet for a blank one. Like documents, a sheet opens in its own tab, full screen, and saves as you type. Only your race's directors can open it.

Sheet from a template starts from one of these, already set up with your race's live numbers where they help:

Race budget
Shirt and giveaway order
Medal and award order
Aid station supplies
Volunteer plan
Sponsor tracker
Race-day timeline

Working in a sheet

Formulas work like Excel and Google Sheets (SUM, AVERAGE, IF and the rest), and so do the keyboard shortcuts you know.
The Start tab has fonts, colors, borders, number formats and alignment.
The Data tab sorts and filters, adds dropdown lists to cells, and sets color rules, like making every "Paid" cell green.
Tabs along the bottom hold more than one sheet in the same file.

Your race's live numbers

Live formulas pull numbers from your race and update by themselves as people register, volunteer and check in. The Live data button lists them all: click one to put it in the selected cell.

=REGISTRATIONS(): How many people are registered, not counting cancellations.
=REGISTRATIONS_BY("distance"): A table of registrations by distance, day, week, age group or gender.
=SPOTS_LEFT(): Spots left before the race or a distance fills. Blank when nothing caps it.
=CAPACITY(): The race's or a distance's cap.
=CHECKED_IN(): Runners checked in.
=PACKETS(): Runners who picked up their packet.
=SHIRTS("M"): Shirts claimed by runners and volunteers, for one size or every size.
=GIVEAWAYS("Finisher hat"): Any giveaway claimed, for one size or every size.
=GIVEAWAY_TABLE(): A table of a giveaway's sizes by distance, then volunteers and totals.
=VOLUNTEERS(): Volunteer sign-ups, for every role or one.
=VOLUNTEERS_NEEDED(): Volunteers still needed, for every role or one.
=VOLUNTEER_TABLE(): A table of each role with its shift, sign-ups, check-ins and how many are still needed.
=DISCOUNTS(): Discounts given with coupon codes, for every code or one.
=MONEY_BY("week"): A table of registration revenue by distance, day or week, or discounts by coupon.
=NET(): What your race keeps, the same as the Finance page: registration revenue and donations, minus refunds and card disputes.
=SALES(): Registration revenue at your prices, before fees.
=DONATIONS(): Donations made during registration and through your donate link.
=SPONSORS(): Sponsor payments collected through Run This.
=GROSS(): Everything collected: your prices, donations, sponsor payments and the fees.
=REFUNDS(): Money refunded to registrants.
=FEES(): The processing fees registrants paid on top of your prices.
=RACE_NAME(): Your race's name.
=RACE_DATE(): Race day, as a date.
=DAYS_TO_RACE(): Days until race day: 0 on race day, below 0 after it.

Most of them take extras inside the brackets:

A distance, like "5K", to count only that distance. The start of a name works too, like "Half".
An earlier race: a year like 2025, or "last" for the race before.
"at this point" counts an earlier race only up to the same number of days before its race day as today is before this year's, so you can see if you're ahead or behind.

The ones that make a table fill the cells below and to the right, and grow as the numbers change, so keep that space empty. The money figures match your Finance page.

Charts

Charts makes a bar, line or pie chart from a block of cells: names down the first column, numbers beside them. Charts redraw whenever the numbers change, live ones included.

Your own templates

In the ⋯ menu, Save as a template keeps the sheet on your account, so you can start a new one from it at any of your races with Sheet from a template. Only you see your templates. A template keeps your layout, words and formulas, never a race's numbers.

Opening an Excel or CSV file

Press New, then Open a Word, Excel or CSV file, and pick an Excel file (.xlsx) or a CSV file up to 10 MB. It becomes a new sheet with its tabs, values, formulas, number formats, fonts, colors (Excel's theme colors too), fills, borders, merged cells, column widths, frozen rows, dropdown lists, color rules, links and tab colors.

If anything can't come across, like icon sets in color rules, you'll see a note saying so.

From Google Sheets: choose File, Download, Microsoft Excel (.xlsx), then open that file.
From Numbers: choose File, Export To, Excel, then open that file.
An older Excel file (.xls): open it in Excel and save it as .xlsx first.

Downloading

The ⋯ menu has Download as Excel (.xlsx) for the whole sheet and Download this tab as CSV. Live formulas go into the file as their numbers at that moment. In a CSV, text that starts like a formula gets an apostrophe in front, so a spreadsheet app shows it as text.

Deleting and your co-directors

Sheets work like documents: one director edits at a time, and Delete moves a sheet to Recently deleted, where any of your race's directors can put it back. See Documents.

Making a sheet

Sheet from a template starts from one of these, already set up with your race's live numbers where they help:

Race budget

Shirt and giveaway order

Medal and award order

Aid station supplies

Volunteer plan

Sponsor tracker

Race-day timeline

Working in a sheet

Formulas work like Excel and Google Sheets (SUM, AVERAGE, IF and the rest), and so do the keyboard shortcuts you know.

The Start tab has fonts, colors, borders, number formats and alignment.

The Data tab sorts and filters, adds dropdown lists to cells, and sets color rules, like making every "Paid" cell green.

Tabs along the bottom hold more than one sheet in the same file.

Your race's live numbers

Live formulas pull numbers from your race and update by themselves as people register, volunteer and check in. The Live data button lists them all: click one to put it in the selected cell.

=REGISTRATIONS()

How many people are registered, not counting cancellations.

=REGISTRATIONS_BY("distance")

A table of registrations by distance, day, week, age group or gender.

=SPOTS_LEFT()

Spots left before the race or a distance fills. Blank when nothing caps it.

=CAPACITY()

The race's or a distance's cap.

=CHECKED_IN()

Runners checked in.

=PACKETS()

Runners who picked up their packet.

=SHIRTS("M")

Shirts claimed by runners and volunteers, for one size or every size.

=GIVEAWAYS("Finisher hat")

Any giveaway claimed, for one size or every size.

=GIVEAWAY_TABLE()

A table of a giveaway's sizes by distance, then volunteers and totals.

=VOLUNTEERS()

Volunteer sign-ups, for every role or one.

=VOLUNTEERS_NEEDED()

Volunteers still needed, for every role or one.

=VOLUNTEER_TABLE()

A table of each role with its shift, sign-ups, check-ins and how many are still needed.

=DISCOUNTS()

Discounts given with coupon codes, for every code or one.

=MONEY_BY("week")

A table of registration revenue by distance, day or week, or discounts by coupon.

=NET()

What your race keeps, the same as the Finance page: registration revenue and donations, minus refunds and card disputes.

=SALES()

Registration revenue at your prices, before fees.

=DONATIONS()

Donations made during registration and through your donate link.

=SPONSORS()

Sponsor payments collected through Run This.

=GROSS()

Everything collected: your prices, donations, sponsor payments and the fees.

=REFUNDS()

Money refunded to registrants.

=FEES()

The processing fees registrants paid on top of your prices.

=RACE_NAME()

Your race's name.

=RACE_DATE()

Race day, as a date.

=DAYS_TO_RACE()

Days until race day: 0 on race day, below 0 after it.

Most of them take extras inside the brackets:

A distance, like "5K", to count only that distance. The start of a name works too, like "Half".

An earlier race: a year like 2025, or "last" for the race before.

"at this point" counts an earlier race only up to the same number of days before its race day as today is before this year's, so you can see if you're ahead or behind.

The ones that make a table fill the cells below and to the right, and grow as the numbers change, so keep that space empty. The money figures match your Finance page.

Opening an Excel or CSV file

If anything can't come across, like icon sets in color rules, you'll see a note saying so.

From Google Sheets: choose File, Download, Microsoft Excel (.xlsx), then open that file.

From Numbers: choose File, Export To, Excel, then open that file.

An older Excel file (.xls): open it in Excel and save it as .xlsx first.

Downloading

Deleting and your co-directors

Sheets work like documents: one director edits at a time, and Delete moves a sheet to Recently deleted, where any of your race's directors can put it back. See Documents.