Return to Our Portfolio

Project:     EPA Emissions Monitoring System
Industry:      Oil Manufacturing
Programming Language:      Visual Basic for Applications
Database:      Microsoft Access/Excel
Application Type:      Integrated Calculation and Monitoring System
Operating Systems:      Windows 95/98
Project Description
By working hand-in-hand with the Phoenix Consultants Group's OSHA Compliance Management appliation, this project specifically focused on the DEP's Clean Air Act permit application. PCG's database development design accomodated multi-user regulatory compliance databases to facilitate the filing of proper New Jersey DEP and federal DEP applications for this client's Clean Air Act permit..

Tracking thousands of fields from an Excel Spreadsheet and automating calculations to effectively monitor all devices (plant devices that were "on line", such as control valves, flow adapters, pressure sensors, etc.,), PCG integraed an "add-on" in Excel called Solver to run "best" and "worst case" scenarios, Solver focused on changes in realtime flows and pressures and how those changes would affect emission statistics. By performing realtime analytic scenarios, this client could and did develop higher production efficiency while maintaining compliance with the Clean Air Act.