When Excel breaks: the 4,000-colaborador inflection

What "Excel breaks" actually means

Excel doesn't break dramatically. It degrades. The first symptom is that the SSOMA worksheet takes 4 minutes to open. The second is that the roster reconciliation across sub-contractors stops being trustworthy because two cells refer to slightly different definitions of "colaborador activo". The third is that the supervisor in charge of dotación stops trusting the file and goes back to clipboard counts.

By the time the file is unusable for daily decisions, you're already in collapse.

Why 4,000

The inflection comes from three multiplications stacking: - Workers × shifts: a 4,000-worker contract on rotational shifts produces 8,000–12,000 weekly roster entries - Sub-contractor depth: each sub-contractor's roster is its own sheet, and merges happen via VLOOKUP across mismatched IDs - SSOMA matrix: every certification has an expiry date, every worker has 4–8 certs, that's 16,000–32,000 cell-level dates to track

Excel handles each of those independently. Cross-referenced together with formulas that have to be right every time, the failure mode is silent corruption — not visible errors.

What replaces it

The replacement isn't another tool; it's a different model. A roster service that treats colaboradores as records with state (active / on-leave / rotating-out), sub-contractor hierarchies as graphs (who reports to whom this week), and SSOMA as a constraint engine (this person can't be on this front because their working-at-heights expires Friday) is the difference between scaling to 30,000 workers and rebuilding the spreadsheet every quarter.

That's what Roster Digital ships. It's been deployed 14× across our portfolio. It is the single most consistent first-build in any new contractor engagement — because every contractor has the same problem at scale.