VIM Technologies has released our latest version of the CEMLink 6 Excel Add-In – a CEMLink 6 tool designed to reduce the challenges associated with assembling and populating CEDRI reporting templates, state-specific reporting, and corporate fleet-wide data aggregation spreadsheets. This latest CEMLink 6 Excel Add-In is now available in the latest release (6.2.100), released on March 1, 2021.
Populate Excel Reports with the Click of a Mouse
The CEMLink 6 Excel Add-In will allow users to retrieve their compliance data directly, reliably, safely, and repeatedly from the CEMLink 6 server and use it to populate Excel 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.
Once licensed, users will be prompted to download the Excel Add-In from the DAHS server and can load the CEMLink6 plugin directly into Microsoft Excel. There are no limits on the number of workstations, users, or spreadsheets that can interface with a CEMLink6 DAS.
The first step in retrieving data is to configure and manage each of the CEMLink6 server connections. Users have the ability to collect and combine data from one or more servers across their fleet, all being tied into a single spreadsheet.
The next step involves the configuration of lists. “Lists” define the type of data that is being retrieved and contain details on the location where data is to be placed in each spreadsheet. Typically these steps are only done once, unless the reporting requirement or CEDRI template changes.
The final step entails running the report by using the “Get Data” feature and passing through a date range. With a few clicks of a mouse, it populates the Excel spreadsheet.
How to Get the CEMLink 6 Excel Add-In
To gain access to this feature in CEMLink 6, users will need to purchase a license. Complete configuration of your report(s) by VIM is also available, but not required. Please send an e-mail to email@example.com with the following information:
- Desired delivery date
- Number of DAS(s) the Excel add-in will communicate with
- Type(s) of data needed (raw, calculated, other)
- How are you planning to use the Excel Add-in? (provide sample files)
- Ad-hoc query
- Custom dashboards
- Title V / Emission inventory / CEDRI / Other Sample Reports
Our Support Team will review your requirements and issue a proposal for the license and any configuration needed.
Want to know more about CEMLink6 Excel Add-In and CEDRI reporting requirements? Read VIM’s article in December’s World Cement Magazine