Opens in a new tab

Industry

Why Grid Modeling Still Runs on Spreadsheets

Walk into almost any grid planning team today and you’ll find the same scene: a load-flow tool from the 1990s, a spreadsheet holding the assumptions the tool can’t, a second spreadsheet reconciling the first one, and an analyst who has become, without ever applying for the role, the informal owner of a system nobody fully understands anymore.

This isn’t a failure of the people doing the work. It’s a failure of the tools they’ve been given.

The bulk power system has changed faster in the last five years than in the previous thirty. Distributed generation, storage, electrification, and a wave of new interconnection requests have made the grid more dynamic, more interdependent, and harder to reason about with static, single-purpose software. Meanwhile, the modeling stack most teams rely on was built for a grid that mostly didn’t change.

The result is a familiar pattern: fragmented tools, manual handoffs, and institutional knowledge that lives in someone’s head instead of in the system itself. When that person is out sick, or leaves, the model doesn’t just get harder to run — it gets harder to trust.

The real cost isn’t the spreadsheet. It’s the delay.

Every manual reconciliation is a place where an assumption can drift quietly out of date. Every handoff between tools is a place where context gets lost. None of this shows up as a single dramatic failure — it shows up as decisions that take longer than they should, and confidence that’s lower than it needs to be.

Grid intelligence shouldn’t require becoming an expert in the seams between five different tools. It should be built as infrastructure from the start: one place where the data, the modeling, and the decision converge — so the spreadsheet can go back to being a spreadsheet, not the backbone of how a $6 trillion industry keeps the lights on.