Regulatory reporting is due next month and I'm scrambling to compile data from six different spreadsheets
Our Tier II report is due in less than a month and I'm trying to reconcile chemical inventory data from six spreadsheets maintained by six different departments. None of them use the same format, product naming convention, or units of measurement.
This happens every year. Every year I spend three weeks manually cross-referencing spreadsheets, looking up CAS numbers, converting between gallons and pounds, and trying to figure out whether the methanol in maintenance is the same as the methyl alcohol in the lab, because of course nobody uses consistent names.
Last year I submitted two days before the deadline and I'm sure there were errors. Nobody noticed because EPA doesn't audit most Tier II reports, but it's only a matter of time before we get selected and I'll have to explain any inconsistencies.
We have Chemscape for SDS management and I recently learned it can generate Tier II data directly from the chemical inventory if we maintained the inventory in the system, which we don't. About half our chemicals are in there and the rest live in those six departmental spreadsheets. I know what needs to happen, but I need to survive this reporting cycle first.