Staffing an Architecture Firm in Excel: Where Spreadsheets Break Down
Nearly every architecture firm staffs its projects in Excel at some point, and for good reason: it's already on every machine, everyone knows how to use it, and a staffing grid is a natural fit for rows and columns. People down the side, weeks across the top, hours in the cells. Done.
This article is an honest look at that approach — what spreadsheets genuinely do well, the specific ways they fail as a firm grows, and how to recognize the moment when the cost of the spreadsheet quietly exceeds the cost of replacing it.
What Excel does well
Let's give the spreadsheet its due, because the case for it is real:
- Zero cost and zero onboarding. Everyone in the firm can read a grid of names and hours. No procurement, no training, no IT involvement.
- Total flexibility. Want to color-code by studio? Add a row for a hypothetical hire? Model a project you haven't won yet? Nothing stops you.
- Good enough at small scale. For a firm of five to ten people running a handful of projects, a well-kept staffing spreadsheet genuinely works. If that's your firm and your spreadsheet isn't causing pain, keep it.
The problems below aren't about Excel being bad software. They're about what happens when a document is asked to behave like a system.
Where it starts to break
1. The spreadsheet is always slightly wrong
A staffing plan changes every week: a deadline moves, someone takes PTO, a project gets put on hold, a consultant coordination meeting eats a Tuesday. Each change has to be typed into the spreadsheet by whoever owns it — usually one operations person or a principal who does it Sunday night.
The result is a plan that describes the firm as it was at the last update, not as it is. The ritual will be familiar at most growing firms: a Monday meeting where the first twenty minutes are spent correcting the spreadsheet out loud.
2. One file, one owner, one bottleneck
Spreadsheets handle concurrent editing badly, so most firms appoint a gatekeeper. Project managers email their staffing needs to the owner, who merges them by hand. That introduces lag (changes wait for the owner), errors (transcription from email to cell), and fragility (the owner goes on vacation and the plan freezes).
Shared cloud spreadsheets soften this but introduce their own failure mode: anyone can change anything, nothing validates the input, and a dragged cell or a sort applied to half the columns silently corrupts the plan. There is no audit trail to tell you who changed what, or why the intern is suddenly booked 80 hours a week in October.
3. Hours and dollars live in different files
This is the structural flaw that causes the most financial damage. The staffing grid tracks hours; the fee and budget live somewhere else — a fee proposal, an accounting export, another spreadsheet. Connecting them ("if Maria spends 24 hours a week on this project through DD, are we still inside the design fee?") requires someone to do the math by hand, project by project.
Almost nobody does that math weekly. So firms routinely discover budget overruns at invoicing time — weeks after the hours were already spent. We wrote a separate case study on exactly this failure mode.
4. No view of the future, only the present
A staffing spreadsheet answers "who is working on what this week?" It struggles to answer the questions that actually determine a firm's health:
- Who has capacity in three weeks when the new project kicks off?
- If the schedule slips a month, what does our utilization look like in Q3?
- Are we about to burn out the same three people we always burn out?
Building forward-looking projections in Excel means duplicating the grid for future weeks and keeping every copy in sync with reality. In practice, the future tabs go stale first.
5. PTO is invisible until it isn't
Vacation requests live in email, an HR tool, or a wall calendar — anywhere except the staffing plan. The plan says Dana is modeling the facade the week she's in Portugal. Nobody notices until the week before, and the scramble begins. At small scale you catch these collisions in conversation. Past about fifteen people, you don't.
The real cost is decision quality
None of these failures announces itself loudly. The spreadsheet never crashes; it just drifts away from reality, and the firm's decisions drift with it: hiring too late because nobody trusted the capacity numbers, saying yes to a project the team couldn't actually absorb, discovering a blown design budget after it was spent.
A useful test: how confidently could your firm answer "can we take on a 20,000 sf project starting next month?" — today, in under five minutes, without a meeting? If the answer involves opening four files and calling two people, the spreadsheet is costing more than it looks.
When to switch — and what to look for
Rough rules of thumb (these are judgment calls, not research findings — your project mix and how disciplined your spreadsheet owner is shift the boundaries):
| Firm size | Spreadsheet status |
|---|---|
| 1–10 people | Usually fine, if one person keeps it current |
| 10–25 people | Painful: weekly corrections, budget surprises, PTO collisions |
| 25+ people | The spreadsheet is now a part-time job, and it's still wrong |
If you're in the second or third row, what should replace the spreadsheet? The honest answer is: something that fixes the structural flaws above, whether that's Resource or another tool. Look for:
- One shared, live plan — everyone sees the same data, updates land instantly, no gatekeeper.
- Hours connected to budgets — staffing allocations reconciled against project fees and phases, so overruns surface while there's still time to act.
- Forward-looking projections — utilization weeks and months out, not just this week's grid.
- PTO in the same view — time off visible exactly where staffing decisions are made.
Resource was built by people who lived the spreadsheet era at a growing A/E firm, and those four requirements are essentially its feature list: weekly staffing and project projections, budget tracking by phase, PTO management, and color-coded utilization. The Starter plan is free for up to 10 people — which, not coincidentally, is about the size where the spreadsheet stops being the right answer.
But even if you never look at Resource: stop trusting the future tabs of a spreadsheet. Your firm's margins live there.