Industry:   Oil Manufacturing      Language:   Visual Basic for Applications       Database:   Microsoft Access/Excel     Application Type:   Integrated Calculation and Monitoring System 

 Project Decription:  

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.


Project Components: 

  • Technical Specification
  • Design Model
  • Data Conversion
  • Implementation