You searched for Excel Add in

CEMLink 6 Excel Add-In Released

Posted March 2, 2021April 21, 2022

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 support@vimtechnologies.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

Discover the New LME EDR Tool for ECMPS 2.0 by VIM Technologies

Posted April 26, 2023May 8, 2023

Beginning in the first quarter of 2024, Part 75 sources will be required to report their Electronic Data Reports (EDRs) using the new web-based ECMPS 2.0 platform. This change means that the original ECMPS standalone client tool will no longer be an option for reporting EDRs. This can create some challenges for organizations that need to prepare for this change.

VIM Technologies, a leading provider of innovative solutions for the energy industry, has developed a solution to address this challenge. VIM’s LME EDR Tool for ECMPS 2.0 is an advanced web-based utility tool that provides an efficient and cost-effective solution for creating Part 75 Low Mass Emitter (LME) XML & JSON formatted Electronic Data Reports (EDR).

The upcoming webinar, “LME EDR Tool for ECMPS 2.0,” hosted by VIM on May 24th from 1:00 PM to 1:45 PM ET, will provide an opportunity to learn more about this innovative tool. During the webinar, attendees will see a demonstration of the tool’s features and capabilities and have the chance to ask questions. REGISTER HERE

The LME EDR Tool for ECMPS 2.0 is designed to help LME sources create and format their EDRs with ease and efficiency while ensuring the accuracy and completeness of their data. The tool is user-friendly and intuitive, allowing LME sources to quickly and easily create EDRs without requiring technical expertise. This feature ensures that users can adapt to the new system quickly.

Platform users can also manually enter operating and long-term fuel flow data or import a CSV file, one that’s been used for years in the current ECMPS client tool. If the existing CSV file import format isn’t suitable for you, or if it takes hours or labor, and resources to convert it, VIM can develop a custom import utility that matches your exact file format needs, thus reducing the need to convert and risk transcription errors.

In addition to being easy to use, the LME EDR Tool for ECMPS 2.0 is also highly secure and dependable. VIM has taken measures to ensure that the tool is safe and that data remains confidential. Users can trust that their data is protected and that they will be in compliance with regulations.

LME EDR Tool for ECMPS 2.0 is web-based, which means that LME sources can access it from anywhere with an internet connection. This feature allows users to work on their EDRs at any time that is convenient for them without needing to be in the same physical location.

Overall, the LME EDR Tool for ECMPS 2.0 is an essential solution for LME sources who want to improve their EDR reporting processes and ensure that their data is accurate, complete, and compliant with regulations. The upcoming webinar provides an excellent opportunity to learn more about this innovative tool and discover how it can benefit your organization.

Try out the LME EDR Tool for ECMPS 2.0 Today! Launch LME EDR Tool

If you’re interested in hearing more about this utility or want a private demonstration, please reach out to a sales representative at sales@vimtechnologies.com.

Digital Transformation: The Fourth Industrial Revolution

Posted July 6, 2022July 8, 2022

The Fourth Industrial Revolution, called 4IR or Industry 4.0, is named for the rapid change in technology, data connectivity, and smart automation that is driving improvement trends throughout the industrial world. Roughly starting in the early 2000s, companies have been implementing changes to improve productivity, efficiencies, and profitability by investing in digital technologies. Machine Learning, Industrial Internet of Things (IIoT), and decision-based software systems are becoming commonplace as costs come down and the need to stay competitive drives buying choices. Regardless of the industry type, companies are making strategic decisions on how best to apply digital technology to their day-to-day operations.

Research shows the primary focus for most digital transformation projects is on process improvements that enhance the customer experience, reduce energy usage, and minimize unplanned downtime. Beyond these main objectives, Industry 4.0 uses technology to help meet Environmental, Social, and Governance (ESG) sustainability by focusing on social development and environmental stewardship. Through these initiatives, companies are addressing not only how they do business now, but the way they will do business in the future. Many ESG digital investment decisions are driven by which aspect of sustainability nets the best results the fastest. Unlike the impact of manufacturing process changes, digitalization investments in ESG are about the long game.

The rewards from these efforts may not hit the bottom line immediately but they do go a long way towards shoring up interest from investors and meeting company sustainability goals. The commitment to a digital strategy gives companies the opportunity to use data connectivity and transparency in conjunction with technology to achieve all of their transformation objectives. All efforts are focused on finding the balance between the digital world while enhancing the human experience, profitability, and ESG sustainability. The urgency to act now and the speed of technological advances opens the potential for implementation pitfalls. Clear thinking and dedication to involving all the company stakeholders are critical before expecting any digital strategy to have the desired impact.Read more »

5 New Years Resolutions to Consider in 2022

Posted January 24, 2022January 24, 2022

It’s the start of a new year, and the VIM Technologies team couldn’t be more excited. Many of us have made our New Year’s Resolutions and are on our way to making changes in the ways we live and work, and how we impact our surroundings. If you haven’t already, it’s time to start thinking about New Year’s Resolutions for yourself and your air compliance initiatives. We’ve pulled together our top ﬁve ideas to help improve your air compliance program and quality of work life while you’re at it…

Advanced Lessons in Track III of CEMLink6 Training

Posted June 21, 2019April 29, 2020

The 2019 VIM User Group is a great opportunity to get training on the CEMLink 6 software. If you already have a lot of experience with CEMLink 6, you may find it difficult to decide what sessions – if any – would be an effective use of your time. The sessions in Track III are carefully crafted for advanced users like you, with information on tips, tricks, and features that will make you more effective in your day-to-day job. Here are some of the sessions that are available in Track III:

Advanced Tips-n-Tricks

Our new Advanced Tips and Tricks session covers a variety of features within CEMLink 6, as opposed to just one feature. We’ll focus on showing off lesser known tips, tricks, and features that will help you become a more productive and efficient user. This session is perfect for users who want to become well-rounded, or don’t know which of our advanced sessions to attend.