How to schedule referees without living in a spreadsheet

Settle these two before the season starts. If nobody decides them, the rest of the process is much harder to run.

One document is the schedule. Pick one place where an assignment is recorded. The group chat, the printout at the field and anything else are copies, and copies go out of date. Two referees at one game, none at another, an official sure they were told: these usually come from two documents that disagreed.

Availability comes before assignment. Assigning first gets a schedule out on Tuesday. Then you spend Wednesday to Friday renegotiating it one official at a time, with a message, a reply and an edit for each change.

The league gives you the games — usually as a PDF, a portal export, or an email with a table in it. Turn that into rows you can work with. The shape matters more than the tool.

Use one row per position.A game that needs three officials is three rows. It looks redundant, but “what is still open” becomes a filter instead of a scan across columns. That is the shape the free spreadsheet template uses.

Each row needs enough for an official to show up at the right place:

• Date and start time — and end time if you have it.
• Location, written the way you would say it out loud: “Harborside Complex, Field 1” rather than a venue code from the league portal.
• Level or division. It decides who is eligible, so keep it on the row.
• Teams, so people know what they walked into.
• The position name. Center, AR1, AR2; plate and bases; referee 1 and 2. Use your sport’s words.

A referee pool is often split across a phone’s contacts, last year’s registration export and the assignor’s memory. Put it in one list with four things per person:

• Name, spelled one way, used consistently everywhere.
• Mobile number and email address.
• Which channel they actually answer on. This is the one rosters usually leave out. Some officials read email within the hour and ignore texts from unknown numbers. Others are the reverse.
• Level, grade or certification, plus anything else you sort by — travel radius, age groups they will not take, whether they can be trusted with a rivalry game.

Update it before the season, then whenever something changes. If you rebuild the pool from scratch every August, you lose the notes that took seasons to learn.

Ask for it in a structured form with a deadline. “Let me know when you’re free” gets replies like “most Saturdays, not the 19th, and Sundays after 1 unless it’s in Rivermill”, and you will re-read that every week for four months.

Aim for one row per person per date they have told you about, with a status you can filter on. Treat an official who hasn’t answered as unknown, not available. Assigning them is a guess.

Ref Grid collects part of this: officials use a link you send to set the days, times of day and divisions they prefer, and the roster shows when each one last confirmed. Dated blackouts stay wherever you collect them. For what to ask and when, see how to collect referee availability before the season.

Start with the games that have the fewest eligible officials: the highest level, the furthest venue, the Sunday 8am. If you fill the easy games first, you may find at row 40 that the only three people who can take the varsity game are already booked.

Then, in rough priority order:

1. Hard constraints first

   Availability and eligibility. Rule out anyone unavailable or not qualified for the level.

2. Then the schedule shape

   Travel and timing. Two back-to-back games at one complex work. The same two games forty minutes apart means the second one starts late. The checks that catch this are in how to avoid double-booking referees.

3. Then fairness and development

   Spread the workload, and put newer officials where they will improve, usually next to someone experienced rather than alone at the quietest game. More on that in how to assign referees fairly across a season.

Assign the whole block before you send anything. If assignments go out as you make them, every later change means a second message to someone who has already read the first.

An official working four games this weekend should get one message about the weekend rather than four separate ones.

Keep it short enough to read at a glance, and include:

• Date, time, position.
• Venue, specific enough to navigate to.
• Level and teams.
• How to accept or decline, in one action.
• Who to contact if something is wrong.

Send it on the channel that official actually reads. Wording for this and the follow-ups is in the assignment email and text templates.

Sending an assignment doesn’t mean it’s accepted. A game isn’t covered until the official says yes, so track replies as their own step:

• A reply deadline early enough to act on: Wednesday for a Saturday game.
• One follow-up for anyone who hasn’t replied.
• A record of when each official accepted.
• A rule for the deadline. Usually an assignment nobody has accepted goes back to open, and you find someone else.

Games move, fields flood, officials get sick on Friday at 9pm. When that happens, update the schedule first and contact people second.

If you text a replacement before the record changes, the schedule and someone’s phone disagree for a while. That is how two officials end up at the same game.

The full sequence is in what to do when a referee cancels at the last minute. When the game itself moves or is called off, see rainouts, reschedules and game changes.

In practice, one source of truth means:

• Every change goes into the schedule first, then out to people.
• If two people assign, they work in one shared document rather than two copies.
• Acceptances given in person or by phone get recorded the same day.
• Anything you print or export shows when it was produced, so a stale copy is easy to spot.

None of this requires software. A spreadsheet handles the first four steps well, which is why we publish a free template.

A spreadsheet can’t do steps five and six. It doesn’t send anything, so you write every assignment message yourself, read every reply, and copy it into a cell. Copying replies by hand is where the sheet and reality drift apart.

Ref Grid covers those two steps. Assignments go out by text and email from the board where you made them, officials accept or decline from a link without an account, and each reply shows on the game. Each assignment goes out as its own message with its own link, rather than one message for the weekend. Whether that is worth paying for depends on the size of your pool and how often the schedule changes. See referee scheduling software vs. spreadsheets.