Assignary and spreadsheets and group texts

A spreadsheet and a group text

On this page, “a spreadsheet and a group text” means running the weekend with no assigning product. The games are rows in a sheet, such as Google Sheets or Excel for the web. The crew is asked in a group text or a chat. Each official is paid however the club pays them: cash or a check at the game, a payment app, a bank transfer or payroll.

Assignary

A club puts its games in once, offers each seat to somebody who can take it, and pays its crew through Stripe. A seat is one official’s place on a game’s crew. Assignary is new. Your club would be among its first.

A spreadsheet and a group text

A spreadsheet. In Google Sheets, multiple people can work on the same spreadsheet at the same time, and its sharing settings control who can view and edit it [1]. Excel for the web lets people collaborate online in real time from any device, and to collaborate, its files must be saved in and shared from OneDrive [2].

Assignary

Import the league’s .csv or .xlsx workbook, or write the games in. Either way, your club’s weekend ends up on one schedule. One file carries up to 200 games.

A spreadsheet and a group text

A cell in Google Sheets can hold a dropdown drawn from a range of cells, and an entry that matches nothing on the list is rejected unless the sheet is set to show a warning instead [3]. Conditional formatting changes a cell’s text or background color when it meets a condition, and a custom formula can format cells by the contents of other cells [4].

Assignary

For each seat, you see everyone who can work it. They’re free, close enough, certified and cleared for the day of the game, with no conflict and no other game in the way. You also see why everyone else is out. You choose who to offer it to. It knows what your club records: each official’s level, the clearances they hold with the day each runs out, and the conflicts they’ve declared. A seat goes only to somebody who passes every check. They’re free at that time and inside their own travel radius. They’re at the level the game asks for, and hold every clearance its sport requires when the game starts. They have no declared conflict, no other game in the way, and room under their own cap for the day. The club records each clearance itself. Assignary never contacts whoever issued it.

A spreadsheet and a group text

A group text. On an iPhone, the Messages app chooses whether a group message goes as an iMessage, as SMS or MMS, or as RCS, based on settings, network connection and carrier plan [5]. In a group iMessage or a group MMS, everyone can see all responses from the group [5]. In a group SMS, each response is sent as an individual text message, and the recipients can’t see the other responses [5]. In a group iMessage, everyone can name the group and add or remove people [5]. A poll in an iMessage conversation shows how people voted and who hasn’t voted yet [6]. Apple’s page, read October 20, 2026, says starting, seeing or voting in one takes “iMessage on iOS 26, iPadOS 26, macOS 26, watchOS 26, visionOS 26, or later” [6]. Those who can’t see a poll receive a message that one was sent to the group [6].

A spreadsheet. A Google Form’s responses can be stored in a linked Google Sheet [7]. Google Sheets can email whoever set up its notifications when someone fills out a form, right away or as a daily digest [8].

Assignary

You send every first offer. Email is the only way an offer is sent. There’s no app to install. The offer’s link opens in the phone’s browser. Its email shows the seat, the game, its sport and level, when it starts and ends, the venue and its address, and the pay. They answer Accept or Turn down. Every offer has a time limit. If nobody answers before then, the offer runs out. An official can say yes ahead of time, before anyone asks. Then a seat that matches is theirs the moment it’s offered. A private link puts an official’s games in the calendar they already use.

A spreadsheet and a group text

If the crew can edit the sheet and you set up its notifications, Google Sheets emails you when one of them changes it, right away or as a daily digest [8].

Assignary

If someone turns an offer down, or lets it run out, it goes to the next person who can take it. Assignary asks the nearest first, and the better record of turning up breaks a tie. The game’s history shows that Assignary moved it. If an official says they’re out, their seats on games that haven’t started are offered to the next person the same way. You can turn off a game’s automatic re-offers. Then a seat that opens up on that game waits for you.

A spreadsheet and a group text

A spreadsheet. Google Sheets shows who was the last person to update a file and when, lets an editor browse and restore earlier versions, and shows who changed a specific cell in its edit history [9].

Assignary

Each seat keeps a history of who offered it, who took it and who marked it. You mark who didn’t show or was excused. An official can say the record of their seat is wrong. That seat stays out of the weekend’s payment until an assigner answers. The assigner answers by changing the record or by leaving it as it is. An official can download a signed record of their own work in a club. It shows their offers and accepts, whether the work happened, and the clearances they hold. It has no pay figure in it. Whoever they hand it to can check it against a published key, without asking Assignary.

A spreadsheet and a group text

Each official is paid however the club pays them.

Assignary

Every accepted seat on a game that has started is paid. The seats left out are the ones marked a no-show or excused, and any whose official disputes the record. If an official hasn’t finished setting up payouts with Stripe, their seat is left out of the weekend’s payment until they do. The rest of the crew is paid without it. The treasurer pays the total through Stripe. Each referee and judge is sent the whole fee on their seat. The club pays at Stripe’s checkout. It doesn’t open a payments account of its own. Officials give their bank details to Stripe, never to Assignary.

Once the club pays for the weekend, each official’s fee goes out after a wait. How long depends on how the club paid:

• A card the bank confirmed, or Apple Pay or Google Pay: as the charge clears
• A US wire for the whole weekend: as it arrives
• A bank debit from an account Stripe reports as a business account: 2 business days after it clears
• Any other bank transfer: 6 business days after it arrives
• Any other bank debit, the wait to plan on: 65 days after it clears
• A card the bank didn’t confirm: 120 days after it clears

Pay sent to an official lands in their Stripe balance first. It reaches their bank on Stripe’s usual schedule, at no cost to them. They can ask for it right away instead, which costs 1.75% of what is paid out, at least $1. They see the fee before they confirm. One payment carries up to 50 seats. A bigger weekend is paid for in batches of 50, earliest games first. Each batch is a payment of its own, from the same Pay page. A club starts with a limit of $5,000 on payments that could still be taken back at any one time.

If a club’s bank or card issuer takes a payment back, the club owes what that cost. That’s the amount, plus the fees Stripe charges for it. If the club has not paid within 30 days, each official that payment paid can have their share of the crew’s part of what is still owed, and no more, taken back from their Stripe account. It is paid back to them once the club has paid what it owes and that payment can no longer be taken back. The Pay page shows what the club paid each official in a calendar year. It counts each payment on the date the money moved.

A spreadsheet and a group text

Asked “How much does Google Sheets cost?”, Google’s page for Sheets answers “Anyone with a Google Account can create in Sheets” and adds that “some Gemini in Sheets features are only available on Google Workspace plans” [1]. Microsoft’s page for its web apps says “Get free access to Word, Excel, and PowerPoint using Microsoft 365 for the web (formerly Office)” [2]. Apple’s page on group texts names no price [5]. It says a group iMessage goes through Apple instead of the carrier, and a group SMS, MMS or RCS message goes through the carrier [5]. Each of the three pages was read on October 20, 2026.

Assignary

Assigning is free. Each seat your club pays through Assignary has a price. Each seat you pay for adds $3.50 plus 3.5% of its fee by card, or $3.50 plus 1.25% by bank, and its referee or judge is sent the whole fee. The percentage is worked out on each seat’s fee and rounded up to the cent. There’s no subscription, no setup fee and no contract. Assignary charges for a weekend only when you pay its refs through Assignary. A seat with no fee is never part of a payment and never charged for. A bank debit through Stripe’s checkout adds Stripe’s $1.50 fee for linking the bank account, as a line of its own. A wire adds Stripe’s $15 to what the club owes. These prices hold from October 6, 2026.

Assignary

Every club has a join code. Anyone who signs up through a link with the code in it joins your roster as an official. So one message in the group chat you already run brings the crew over. If you replace the code, the link stops letting anyone in. They sign in with a code sent to their email, so there’s no password to set. They also state that they’re 18 or older. Import a .csv or .xlsx workbook and each row becomes a game. Before anything is saved, Assignary shows you every row. For a row it can’t read, it says what’s wrong. If a sheet has no fee column, Assignary asks you for one fee before it’s saved. A fee of 0 means the games are unpaid. You can put one weekend’s games in here, offer their seats and fill them, while the spreadsheet still runs the rest. Assignary charges nothing for a weekend your club doesn’t pay for here.

Assignary

A club’s owner can download one zip of spreadsheets for a range of dates. It holds the games and every offer of a seat on them, and the roster and members as they are now. It also holds what the club was charged and what its officials were paid. The games file uses the column names the import reads, so you can import it again. Each person can download their own record as one file from their Account page.

Assignary

Assignary doesn’t replace a system an association requires.

Assignary

Assignary opens to new clubs in January 2027, and until then the way in is the waitlist.