A Spreadsheet Is Not a Notebook

A spreadsheet has two kinds of cells. Inputs—the numbers you put in. Outputs—the results that follow, calculated from those inputs. That is the entire architecture.

The problem is that most spreadsheets sent across desks do not work this way. They work like notebooks—numbers entered where they fit, some cells calculated and some typed over, logic buried inside formulas that nobody can follow. The outputs look precise. The assumptions are invisible. The model cannot be questioned because nobody can find where it starts.

The fix is simple and takes five minutes.

Mark your inputs. A subtle yellow highlight on every cell that contains an assumption or a number that can legitimately be changed. Everything else—every output—stays white. Yellow means this is where the model breathes. White means hands off.

That convention does two things. It forces you to think clearly about what is an input and what is a result—which is itself a useful discipline. And it tells whoever receives the file exactly where to look when they want to test your assumptions.

A spreadsheet is not a notebook. It is a model built from assumptions, producing results that are only as credible as the inputs that generated them. Make the inputs visible. Make the outputs earned.

The person on the other end will notice. Not always consciously. But they will notice.

What happens when they cannot—and what it costs when a model becomes a crystal ball—is in the next layer: The Crystal Ball.