Five Signs Your Manufacturing Program Has Outgrown Its EHS Spreadsheet

3 days ago

4 min read

By: Gav Orman, PE, Director of Compliance Technologies

Almost every environmental compliance program starts with a spreadsheet. One facility, one EHS manager, a handful of permits, and a workbook with a tab for each report. For a single site with a stable process, that can work. The problem is that manufacturing programs rarely stay that size. A second site comes online, a new product line brings new chemicals, or a state agency starts asking for a report you have never filed before. The spreadsheet grows to keep up, and at some point the tool you built to manage risk becomes the risk.

The tricky part is that the spreadsheet doesn't fail all at once. It keeps opening, the formulas keep calculating, and the deadlines mostly get met. So how do you know when you have crossed the line? Let's walk through five signs that your program has outgrown its tracking system.

1. You added a site, and the spreadsheet added a tab

When a company acquires or builds a new facility, the fastest fix is to copy the existing workbook and rename it. Now you have two versions of the same logic, and they start to drift apart the first time someone updates one and not the other.

That drift matters because applicability is facility specific. Tier II reporting is triggered when a hazardous chemical is on site at or above 10,000 pounds, or when an Extremely Hazardous Substance is present at or above 500 pounds or its Threshold Planning Quantity, whichever is lower [1]. SPCC planning applies when aggregate aboveground oil storage exceeds 1,320 gallons, counting only containers of 55 gallons or more [2]. A new site might cross those lines on day one or not for years. A copied tab has no way of telling you which.

2. A new product line brought new chemicals, and nobody re-ran applicability

Production changes are the most common reason a compliance determination goes stale. A new resin, solvent, or coating gets approved through purchasing, the SDS gets filed, and the EHS spreadsheet never hears about it. Six months later, that chemical has pushed the facility over a TRI or Tier II threshold, or it contains a PFAS that is now reportable at 100 pounds with no de minimis exemption [3].

If your applicability review only happens once a year, or only when an auditor asks, your spreadsheet is describing last year's facility, not this one.

3. You answer to more regulators than you did two years ago

Growth brings new relationships: a state air agency or county air district, a local POTW with its own pretreatment requirements, a Local Emergency Planning Committee, a different EPA region. Each one has its own forms, due dates, and expectations. A spreadsheet can list those deadlines, but it can't assign them to a person, send a reminder, or escalate when a task is overdue.

When your compliance calendar depends on one person remembering to open the file, the number of regulators you answer to is also the number of ways a deadline can be missed.

4. Only one person can explain the formulas

We wrote about this in our post on the hidden cost of tribal knowledge: if Bob is the only one who can complete a certain report, the program is only as reliable as Bob's calendar. Spreadsheets make this worse, because the logic lives inside cells that nobody else reads. Emission factors get hardcoded, unit conversions get buried, and a formula that references the wrong row can sit unnoticed for years.

That last point isn't hypothetical. Raymond Panko's review of five rigorous field audits of operational spreadsheets found important errors in 91% of the 55 spreadsheets examined [4]. Your compliance workbook isn't exempt from that math just because it was built by a careful engineer.

5. Audit prep takes weeks, not hours

Recordkeeping requirements assume you can produce the supporting data on request. A Title V permit requires monitoring data and support information to be kept for at least five years [5]. Small and large quantity hazardous waste generators must keep records supporting their waste determinations for at least three years from when the waste was last sent for treatment, storage, or disposal [6].

If preparing for an inspection means pulling files from shared drives, email inboxes, and five versions of the same workbook, your records exist, but your system doesn't. The time your team spends reconstructing the story is time not spent on actual compliance work.

What these signs have in common

None of these signs mean your team is doing a bad job. They mean the program has scaled faster than the tools supporting it. The common thread is that a spreadsheet stores information but doesn't manage it. It can't tell you when applicability changed, who owns a task, or whether a calculation is still using the right inputs. In a growing manufacturing program, those are exactly the questions that matter most.

If two or more of these signs sound familiar, it's worth stepping back and asking what your program needs to look like in two years, not just what it needs to get through this reporting season.

How Toolkit Can Help

Toolkit's Compliance Tool replaces spreadsheets and calendar reminders with a library of more than 200 regulatory task templates, automated reminders, and an escalation schedule that notifies the right people before and after a due date [7]. Completed tasks carry their documentation with them, so your records are ready when an inspector asks. For new sites and new product lines, the Determination Tool walks each facility through plain-language applicability questions, shows which standards apply and why, and lets you re-run the determination each year starting from the prior year's answers [7]. Enterprise managers can see applicability and open issues across every facility in one place. Ready to move past the spreadsheet? Reach out to the Toolkit team today to talk through your program!