VIM Technologies is in high gear and getting ready to release the CEMLink6 Excel Add-In – a CEMLink6 tool designed to reduce the challenges associated with assembling and populating CEDRI reporting.
Over the last four years, PC MACT affected facility managers have witnessed the EPA change its demand regarding CEDRI reporting formats and requirements numerous times. The most recent change took effect on September 24, 2020, discontinuing the web format and replacing it with a new, consolidated, Excel spreadsheet template. The change effectively mandates all PC MACT sources to use the latest Excel template in the upcoming reporting period.
VIM Technologies has carefully monitored EPA’s changes in the report formats. In 2018, the Environmental Products Group team, lead by Rudi Muenster, along with valuable input from the VIM Steering Committee, looked for ways to alleviate CEDRI reporting challenges and define the best-fit solution for its partners and the cement industry. After a series of careful evaluations, the team agreed that an Excel Add-In solution was the best option to streamline the delivery of CEDRI reports.
CEMLink6 Excel Add-In
CEMLink6 Excel Add-In will allow users to retrieve their compliance data directly, reliably, safely, and repeatedly from the CEMLink6 server and use it to populate CEDRI reports with the click of a mouse. Users can manage and maintain connections to multiple servers, making it easy to run reports across an entire fleet.
The Excel Add-In can be downloaded from the DAHS server and installed on one or more remote workstations. Once downloaded, the workstation will need to be configured to define the report’s contents and how they will be populated. This process involves creating server connections and configuring the lists, called placeholders, in the Excel workbook where data from the CEMLink 6 server will be specified. Most users will typically only do these steps once unless the reporting requirement or CEDRI template changes. The next phase entails running the report and populating the Excel spreadsheet, which involves querying the server’s data and populating the list within the report. With CEMLink6 Excel Add-In, CEMLink6 users can utilize the “Get Data” feature of Excel to retrieve and analyze data from multiple sources and create CEDRI reports in just a few clicks of the mouse.
Want to know more about CEMLink6 Excel Add-In and CEDRI reporting requirements? Read VIM’s article in December’s World Cement Magazine