Skip to the page
Toneinux

Turn a spreadsheet into a board everyone reads

How teams use it

Three ways a team reads a board

Described as work, not as stories. No names, no figures, no savings claimed; just the shape of the sheet and the board that reads it.

A weekly operations board

The sheet. A tab per week, or one long tab with a row per week, maintained by the person who runs the operation and updated as things happen rather than at the end of the week.

The named ranges. This week's headline figures; the last twelve weeks of each of them; a short table of open issues; one note cell for the person who owns the week.

The board. Four figures across the top, three trends beneath them, the issues table down the side, the note at the foot. Under a dozen panels, on purpose.

The rhythm. The connector reads every few minutes during working hours. The Monday meeting opens the board instead of a slide, and the meeting stops being a recital of numbers and becomes a discussion of the two that moved. Nobody exports anything. When the week rolls over, the ranges move with the new row and the board carries on without being touched.

A hand with a pen writing calculations on a spiral notebook page
The week's figures are worked out in the sheet, by hand if need be. The board only reads the result.

Second

A month-end summary

The sheet. The working file the finance or planning owner already closes each month, with its own variance formulas that nobody wants rebuilt anywhere else.

The named ranges. The month's totals by line; the same lines for the previous month and the same month a year earlier; the variance table the sheet already computes; a note cell for the owner's commentary.

The board. A table panel holding the variance table exactly as the sheet holds it, figures for the three or four totals that matter, one trend across the year, the note.

The rhythm. The connector reads once a day. On the first working day after the close, the owner presses refresh and takes a snapshot deliberately. When someone asks in March what the board said in early February, a viewer picks the date and reads it. The board never changes the sheet, so a closed month stays closed.

Third

A board for one project

The sheet. The project tracker one person keeps: milestones with dates, a budget line with spent-to-date computed in the sheet, a risk list, a next-steps cell.

The named ranges. The milestone table, the spent figure, the remaining figure, the risk table, the next-steps note.

The board. Two figures, two tables, one note. Nothing else. Editor seats for the project lead and the person who keeps the tracker; viewer seats for the sponsor and for anyone who asks where things are more than once a week.

The rhythm. Read on demand, refreshed when the lead updates the tracker. When the project ends, the board is archived with its snapshots, the connector is removed, and the tracker file stays with the team, untouched.

A pale desk with a notebook, a pen, a calculator and a laptop under a shaft of window light
A project board is small enough to read before the call starts.

Pattern

What the three have in common

In each case the sheet already existed and someone already maintained it. The board did not ask them to change how they work; it asked them to name the blocks that mattered. The panels are few, under a dozen on every board above, because a board with forty panels is a spreadsheet with worse formatting. And in each case the people who only read the board were given viewer seats, which turned out to be most of the seats, and they never had to open the sheet at all.

The other thing they share is what did not happen. No export was scheduled. No slide was rebuilt. No figure was retyped from one place into another, which is where most wrong numbers in meetings come from.

Limits

What a board is not for

Say no early

  • A board is not a place to enter data. If your process needs people to type into the board, it needs a form or a database, not a window on a sheet.
  • A board is not a substitute for a well-kept sheet. If the tab is a mess, the board shows the same mess with nicer typography.
  • A board is not for personal customer records. We decline those, and the security page says why.
  • A board is not a report you send outside the company. There is no public link, deliberately.