Spreadsheet

The Golf League Spreadsheet: What It Needs, and Where It Breaks

Can you run a golf league with Excel or Google Sheets? Of course. One league ran on a workbook for years before Golf Mafia existed, and the app is that workbook's shape moved onto twelve phones. This guide is what the sheet needs if you build one, and the exact places it breaks, so you know when to stop.

What the workbook needs

A league spreadsheet is four tabs pretending to be one.

TabWhat it holdsThe formula that does the work
Roster & handicapsEvery player, their team, their number, their current handicap, and the history of changes with dates.None, which is the problem: the history is typed by hand, and it is the sheet nobody updates.
Rounds (one block or sheet per round)Who played, gross by hole, the handicap used, net total, each team's Best-4, each team's skins by hole, the money.=SUM(SMALL(nets,{1,2,3,4})) for the Best-4; per hole, MIN of each team's gross and an IF that awards a skin only when one is strictly lower.
StandingsAverage net over full rounds, rounds played, skins, birdies, money to date, and the hardest holes.AVERAGEIF over the round sheets, which breaks the day someone inserts a column.
Schedule & RSVPThe dates, tee times, who said yes, the groups.None. It lives in the text thread anyway.

If you build it, build it well: lock the formula cells, keep one row per player per round, and never type a net by hand. The Best-4 formula wants the four lowest nets among players with a full round only, so a player who stopped at the turn needs a blank, not a zero.

Where it breaks

Not on day one. The sheet works beautifully for the first month. It breaks in these six places, in roughly this order.

  1. Tuesday night. Somebody types twelve scorecards, 216 numbers, into the sheet after dinner, every league day. That person is the commissioner, and that is the hour that ends commissioners.
  2. The parking lot. The bets are settled before the sheet is updated, from memory and a paper card. When the sheet disagrees two days later, the money has already changed hands.
  3. The missing card. One group's card goes home in a bag. The round is half a round until Thursday.
  4. The handicap argument. "I was a 12 that day, not a 10." Nobody wrote down which handicap each round used, so nobody can prove it.
  5. The one keeper. Only the commissioner can open the book. Everyone else asks, or waits for the Wednesday email. If the commissioner is away, the league is dark.
  6. The second season. Last year's workbook is a file on a laptop. Records across seasons, head-to-head over the years, the longest winning run: nobody keeps them, because the sheet never did.

The test

If your league's standings live somewhere only one person can open, you have a spreadsheet problem, however good the spreadsheet is.

What replaces each tab

Golf Mafia keeps the same four tabs, on every member's phone, and fills the two that the sheet never could.

Golf Mafia's Season tab: team money over 28 rounds, a cumulative chart, the phone owner's line reading 1st of 14 and 2.8 ahead of Gary, and the players table by average net
The standings tab, kept by the app: average net, the gap to the player above you, skins, birdies, holes and money.

Moving a league off the spreadsheet

You do not import the old workbook; you start the new season clean and keep the old file for the record. Create the league with the same teams and numbers, enter each player's current handicap, and schedule the first round. The first thirty days are free from that first scheduled round, so the league has a month to decide before the commissioner keeps the book. The old sheet retires with its last season intact, which is where it belongs.

Retire the workbook. Keep the league.

Golf Mafia was built to replace one league's spreadsheet, tab for tab. The first thirty days are free, and the players pay nothing.

Download on the App Store

Free for every player · A league's first 30 days free · iPhone & iPad, iOS 18 or later