New Zealand's $16B health dept managed finances with single Excel spreadsheet

Original Article ↗ Hacker News Discussion ↗

Excel’s Role: Impressive Capability vs Wrong Tool

  • Some see the story as inadvertent advertising for Excel: running consolidated finances for a multibillion‑dollar health system at all is “impressively” within its capabilities, analogous to running a huge app on a single SQLite file.
  • Others argue this is like digging a tunnel with a fork: technically possible but fundamentally inappropriate, especially given documented errors and lack of traceability.
  • Several commenters stress that the real issue is as much process and governance as tooling: poor controls, hard‑coded numbers, no audit trail, slow consolidation, and easy data manipulation.

Why Excel Dominates in Practice

  • Excel is described as the de facto ERP for many large organizations: ubiquitous, already installed, highly flexible, and familiar to non‑engineers.
  • Managers can iterate models, reports, and workflows without going through IT, procurement, or long change cycles, which is contrasted with “glorified spreadsheet” ERPs and BI tools that are slower and more expensive to change.
  • The thread notes a constant tradeoff: Excel’s flexibility vs its “mean‑time‑to‑catastrophe” from silent errors (off‑by‑one, truncation, hard‑coding).

Alternatives and “Middle Ground” Tools

  • Commenters mention Access, FileMaker, Airtable, Panorama X, and Power BI as “database with a spreadsheet UI” options that could add constraints and auditability.
  • Yet these tools often lose out because they require more specialized skills, trigger internal IT politics, or get displaced by large “enterprise‑grade” ERPs.

ERP, Consultants, and Cost vs Risk

  • Some insist a national health system with a ~NZD 16–28B budget needs a proper ERP/financial system with full audit trails.
  • Others counter that ERP implementations (SAP, PeopleSoft, bespoke systems) often cost tens or hundreds of millions, take years, and still spawn new spreadsheets around their gaps.
  • Skepticism is expressed about the consulting firm’s incentives: highlighting the spreadsheet may be a prelude to selling an enormous ERP project.

Politics and System Design

  • A political subthread disputes whether the situation reflects genuine incompetence, deliberate underfunding aimed at privatization, or overblown rhetoric by the current government.
  • Comparisons are drawn to Austria’s health‑insurance consolidation, which reportedly increased costs despite promised savings, reinforcing a broader cynicism that reorganizations rarely reduce bureaucracy.