Tag Archive for: Reporting

6 Ways To Get Data Into Your EHS System

Locus provides multiple methods to populate EHS, ESG, or any environmental data, including the following:

6 Ways to Input Data

 

Integrations

Locus provides a full suite of REST API’s, and SDK that can be used to populate data from external data sources. Typical uses include utility data, CEMS, meter data and IoT data.

 

Surveys

Locus Survey tool enables you to issue survey questionnaires to people outside your organization, and enables them to securely and seamlessly respond directly into the survey form. Typical uses include supplier surveys, audits and customer questionnaires.

 

Mobile

User input forms can be optimized for input on a phone or tablet, which allows quick uploads of photos and also geotags your data so you can ensure it was collected at the right location.

 

Excel and Text Files

Locus provides a full suite of Excel upload tools that allow you to import data directly from Excel or CSV files. This option also allows you to work offline and re-sync your data later. Typical uses include laboratory data, periodic monitoring data and data migrations.

 

Manual Data

Like any system, Locus provides tools for users to directly enter data into the system. These include Locus sophisticated data validation tools which employs machine learning techniques to identify data entries which may be invalid, with visual indications of the expect range or ranges.

 

Email

Locus can be configured to directly read email input (as text) and place it into the system. Typical uses include instances where external users initiate a conversation, which then may be responded to from within the system, such as an inquiry, issue, or an incident report.

Contact us to learn more

Send us your contact information and a Locus representative will be in touch to discuss your organization’s environmental data management needs and provide an estimate, or set up a free demo of our enterprise environmental software solutions.

    Name

    Company Email

    Phone

    Tell us about your company's needs

    Locus is committed to preserving your privacy.

    Automate Your Vapor Intrusion Management

    The Vapor Intrusion tools in Locus’ Environmental Information Management (EIM) software solve the problem of time-consuming monitoring, reporting, and mitigation by automating data assembly, calculations, and reporting.

    Locus Vapor Intrusion Solutions

    Quickly and easily generate validated reports in approved formats, with all of the calculations completed according to your specific regulatory requirements. Companies can set up EIM for its investigation sites and realize immediate cost and time savings during each reporting period.

    Locus EIM Devices

    Contact us to see the Vapor Intrusion tool in action

    Send us your contact information and a Locus representative will be in touch to discuss your organization’s environmental data management needs and provide an estimate, or set up a free demo of our enterprise environmental software solutions.

      Name

      Company Email

      Phone

      Tell us about your company's needs

      Locus is committed to preserving your privacy.

      Environmental Reports Tailored to Your Needs

      Companies across a wide array of industries utilize Locus Environmental Information Management (EIM) software. Some examples include petroleum companies with over 6,000 sites, fracking companies with 3,000 plus sites, leading chemical corporations, engineering firms, private and public water utilities, DOE facilities, Native American tribes, aerospace companies, representatives of the electronics industry, and more. There is not a single report that these companies share in common, and as such, our approach to reporting recognizes our customers’ diversity.

      DMR builder and report in EIM

      Instead of focusing on canned reports, we provide users with the tools to build their own custom reports—enabling them to design exactly what they need, either independently or along with our stellar support team. To make the transition to Locus EIM as easy as possible, we ask our customers about their top reporting priorities. Then, we build reports to match their specifications during the implementation process to be up and running from day one. Not only does this facilitate the transition to our system, but it also gives our customers examples of how to build their custom reports.

       

      Grid Reports

      Before we delve into EIM’s formatted reports module, keep in mind that many of our customers’ reporting needs are met by EIM’s grids. For example, here is a sample grid populated with analytical results that match some previously chosen selection criteria:

      Locus EIM Grids

      One-click and this becomes an Excel spreadsheet (or any of a range of file formats) to which you can add a title, edit the column headers as needed, and if required, engage in further formatting.

      Locus EIM Grid Report

       

      Formatted Reports

      Let’s now move on to EIM’s formatted reports module. Templates provide EIM with instructions concerning report layouts, content, and formatting. They do not address which records stored in EIM are to appear in the report. Template creation requires more in-depth knowledge of EIM and needs to be done only once for any given report format. Running a report is a more straightforward task. The same report can be re-run any number of times using different selection criteria. For example, it is not uncommon for a customer to print a monthly, quarterly, or even annual report using the same template. All that changes from one reporting period to the next is the selected sampling or measurement date range. Upon saving your entries, the report is ready to be used by others, unless designated as private.

      To run a formatted report in EIM, all you need to know is what filters should be chosen to display only the relevant set of data. Aside from date ranges, what are examples of selection criteria available to you when executing a formatted report? For example, you can select individual locations or named location groups; individual or named groups of parameters; one or more sample types, sample purposes, samples, sampling programs, sampling events, or sample delivery groups; a range of sample depths; only filtered or unfiltered samples; only leached or not leached analyses; one or more EDDs; and one or more work order numbers to name a few.

      Locus Formatted Reports

       

      Expert SQL Query Reports

      The expert query tool allows the user to retrieve records from many EIM data tables with a flexible interface, where join and column definitions are customized. The expert query output can be scheduled as an attachment to an email or run as needed, private or public, or saved on the dashboard for ultimate access by all user levels.

      The EIM Expert Query Tool (EQT) lets users create their database queries using a drag-and-drop table interface. Users can also directly write T-SQL language requests to pull data from EIM. This powerful tool empowers the super users to take full advantage of the data managed in EIM and creates “custom reports” without the need for a developer.

      Locus Expert SQL Query

       

      Additional Reports

      Additional reports include DMR reports (formatted and NetDMR); Self-monitoring; Regulatory formatted exports (various EPA regions); Consumer Confidence Reports; Data Validation (in association with the Data Validation Module); Coliform reports (Water configuration); custom DMR reports and custom MSGP reports; and a wide range of metric reports for usage statistics, records, sites, and management reports including holding table metrics, SDG turnaround times, reporting tool metrics, and LocusDocs metrics.

       

      Contact us for a demo of Locus EIM

        Name

        Company Email

        Phone

        Tell us about your company's needs

        Locus is committed to preserving your privacy.

        Preparing for Your ESG Audit

        Recently, Locus CEO Neno Duplan described the need for credible ESG Reporting, and the evolving corporate, financial, and political drivers leading to the proliferation of ESG reporting. Here, we look at some of the practical aspects of building and maintaining an ESG reporting program.  After leading audits for greenhouse gas emissions and other ESG metrics for the past ten years, I wanted to highlight the pitfalls that many organizations face when it comes to supporting their ESG reports, and provide some solutions to improve their auditability.

        Locus Engineer Laptop

        With the current wave of popularity for Environmental, Social, and Governance (ESG) reporting, many organizations are scrambling to assemble reports that cover these metrics.  While a spreadsheet can be readily put together with enterprise-level totals for emissions, resource consumption, community involvement and other metrics, most of those reports won’t stand up to a full audit process. And increasingly savvy investors and stakeholders aren’t necessarily willing to take these reports at face value.

        Whether you are getting started on a new ESG reporting program for your organization, or transforming an existing CSR program to cover ESG elements, it is critical to plan ahead for ensuring your final report is audit-ready. That means not only maintaining full visibility for the raw data, calculations, and various factors that went into the report, but also making that data easily accessible and traceable. Consider the case where a stakeholder is comparing two ESG reports where the overall metrics are similar. But one of the reports has a fully transparent data flow back to the source, and the other report can only be verified through a lengthy documentation request to a consultant. Although the final reports may be similar, the stakeholder gains more trust with less effort when the supporting data is readily available.

        Locus Sustainability Metrics

        There is quite a bit of uncertainty over how comprehensive ESG audits should be. Current audit protocols for ESG reporting vary widely. Organizations like the Center for Audit Quality have put forth guidance on how ESG reports could be audited. However, there are no strict requirements and little consensus on what should or should not be included in the audit of an ESG report. Established reporting frameworks like GRI, SASB, and TCFD have programs in place for assurance of those reports, which include a third-party audit for the accuracy and completeness of that data.  However, organizations have the choice of achieving either limited assurance or reasonable assurance, and they may choose to have only select metrics or disclosures audited, or they may opt to undergo a more thorough examination that covers the full report. That flexibility is likely to change, however, as stakeholders apply additional pressure for better quality and reliability in ESG reports.

        So how do you go about developing an ESG program that can meet current and potential future audit requirements?  Based on my auditing experience, here are a few key concepts to keep in mind:

        [sc_icon_with_text icon=”cloud” icon_shape=”circle” icon_color=”#ffffff” icon_background_color=”#52a6ea” icon_size=”big” level=”h3″]

        1. Centralize your data flow

        Centralize your data flow, with consistent data quality controls. A unified data collection program is key to streamlining the audit process and having greater confidence in your report. Historically, reporting for ESG has been the responsibility of multiple departments with little intercommunication. The result of that separation is widely different practices when it comes to assuring data quality. Integrations between systems can help and are sometimes the best option to bring together data from different sectors of the ESG report.  But ultimately, a consistent approach to the overall data collection and processing effort will result in a much smoother (and cheaper) audit.[/sc_icon_with_text]

        [sc_icon_with_text icon=”automation” icon_shape=”circle” icon_color=”#ffffff” icon_background_color=”#52a6ea” icon_size=”big” level=”h3″]

        2. Automate data collection

        Automate data collection wherever possible. Auditors know that manual data entry or transcription is typically one of the major weak points in any data collection program. We’re trained to focus in on those parts of the process with additional data sampling and review to find errors.  If you have any opportunities to collect data through automated tools or direct connections to reliable data sources, those tools are the quickest ways to shore up those potential weaknesses, and also have the benefit of substantially reducing your ESG data collection effort.[/sc_icon_with_text]

        [sc_icon_with_text icon=”documents” icon_shape=”circle” icon_color=”#ffffff” icon_background_color=”#52a6ea” icon_size=”big” level=”h3″]

        3. Maintain documentation

        Maintain documentation throughout the data collection process. During one audit years ago, I asked the reporter for their documentation on their electricity consumption, and they pointed to a scribbled sticky note on their wall. Of course, that didn’t quite suffice for audit purposes, and neither does an email from a co-worker, or any number of other data sources that reporters have tried to pass off as their documentation. For inputs that derive from sources outside your organization, like utility invoices or supplier surveys, data are considered more reliable if they are directly tied to a financial transaction between entities that do not share ownership. The general thought is that if the data quality was considered sufficient to exchange money based on the value, it can be considered reasonably accurate.  If that is not the case, ideally an attestation, or at least the source’s contact information, should be maintained for each data source. For data inputs derived from internal sources (e.g. meter readings), the documentation will need to include the data itself, as well as information on the devices used and their maintenance (e.g. calibration records).[/sc_icon_with_text]

        [sc_icon_with_text icon=”calculation-engine” icon_shape=”circle” icon_color=”#ffffff” icon_background_color=”#52a6ea” icon_size=”big” level=”h3″]

        4. Avoid black box calculators

        Given the many issues with spreadsheet data handling including lack of unification, security, and error proliferation and persistence, many organizations are correctly concluding that a dedicated software application provides numerous process improvements for ESG reporting. But unfortunately there are many software tools that take the input data and generate an ESG report with little or no visibility into how the input data were processed or calculated. And to an auditor, those part of the process are critical to achieving assurance for an ESG report. Sometimes the data processing steps can be viewed, but they’re buried within the configuration settings and require navigation by a system administrator to extract. In this situation, auditors can try to replicate the calculations from the raw data on their own, and attempt to yield the same results. This approach can work for many accounting metrics, which are largely standardized, and easily replicable from the input data.  However, other metrics like Scope 3 emission calculations can follow a number of different methodologies with different factors. Without knowing which methods and factors were used, the auditor is unlikely to yield the same results. Having a transparent calculation engine that can visualize the data flow and processing can make a huge difference when it comes to your audit.[/sc_icon_with_text]

        Assembling an ESG reporting program is a significant undertaking, and it may be a monumental effort to simply get the report done, especially if you’re just getting your program started. But to fully set yourself up for long-term success, be sure to assess the audit readiness of your ESG program. Even though ESG auditing is not yet fully codified, more formalized audit protocols are expected soon. Some simple considerations early in your program development will make sure you are prepared for whatever those audit requirements may include.

        [sc_image width=”150″ height=”150″ src=”16265″ style=”11″ position=”centered” disable_lightbox=”1″ alt=”Steve Paff”]

        About the Author—J. Wesley Hawthorne, President of Locus Technologies

        Mr. Hawthorne has been with Locus since 1999, working on development and implementation of services and solutions in the areas of environmental compliance, remediation, and sustainability. As President, he currently leads the overall product development and operations of the company. As a seasoned environmental and engineering executive, Hawthorne incorporates innovative analytical tools and methods to develop strategies for customers for portfolio analysis, project implementation, and management. His comprehensive knowledge of technical and environmental compliance best practices and laws enable him to create customized, cost-effective and customer-focused solutions for the specialized needs of each customer.

        Mr. Hawthorne holds an M.S. in Environmental Engineering from Stanford University and B.S. degrees in Geology and Geological Engineering from Purdue University. He is registered both as a Professional Engineer and Professional Geologist, and is also accredited as Lead Verifier for the Greenhouse Gas Emissions and Low Carbon Fuel Standard programs by the California Air Resources Board.

        5 Powerful Features of Locus Environmental Software

        Maybe you are a user of Locus’ Environmental Software (EIM) and are looking to get more out of our product. Or perhaps you are using another company’s software platform and looking to make a switch to Locus’ award-winning solution. Either way, there are some features that you may not know exist, as Locus software is always evolving by adding more functionality for a range of customer needs. Here are five features of our environmental software that you may not know about:

        1. APIs for Queries

        Locus expanded the EIM application programming interface (API) to support running any EIM Expert Query. Using a drag and drop interface, an EIM user can create an Expert Query to construct a custom SQL query that returns data from any EIM data table. The user can then call the Expert Query through the API from a web browser or any application that can consume a REST API. The API returns the results in JSON format for download or use in another program. EIM power users will find the expanded API extremely useful for generating custom data reports and for bringing EIM data into other applications.

        Locus EIM API

        2. Scheduled Queries for Expert Query Tool

        The Expert Query Builder lets users schedule their custom queries to run at given times with output provided in an FTP folder or email attachment. Users can view generated files through the scheduler in a log grid, and configure notifications when queries are complete. Users can scheduled queries to run on a daily, weekly, monthly, or yearly basis, or to run after an electronic data deliverable (EDD) of a specified format is loaded to EIM. Best of all, these queries can be instantly ran and configured from the dashboard.

        Scheduled Queries in Locus EIM

        Scheduled Queries in Locus EIM

        3. Chart Formatting

        Multiple charts can be created in EIM at one time. Charts can then be formatted using the Format tab. Formatting can include the ability to add milestone lines and shaded date ranges for specific dates on the x axis. The user can also change font, legend location, line colors, marker sizes and types, date formats, legend text, axis labels, grid line intervals or background colors. In addition, users can choose to display lab qualifiers next to non-detects, show non-detects as white filled points, show results next to data points, add footnotes, change the y-axis to log scale, and more. All of the format options can be saved as a chart style set and applied to sets of charts when they are created.

        Chart Formatting in Locus EIM

        Chart Formatting in Locus EIM

        4. Quick Search

        To help customers find the correct EIM menu function, Locus added a search box at the top right of EIM. The search box returns any menu items that match the user’s entered search term.

        Locus EIM Quick Search

        Locus EIM Quick Search

        5. Data Callouts in Locus’ Premium GIS Software

        When the user runs the template for a specific set of locations, EIM displays the callouts in Locus’ premium GIS software, GIS+, as a set of draggable boxes. The user can finalize the callouts in the GIS+ print view and then send the resulting map to a printer or export the map to a PDF file.

        Locus GIS+ Data Callouts

        Locus GIS+ Data Callouts

         

        [sc_button link=”/applications/environmental-information-management/” text=”See more features” link_target=”_self” color=”ffffff” background_color=”52a6ea” centered=”1″]

        Top 10 Enhancements to Locus Environmental Software in 2020

        Let’s look back on the most exciting new features and changes made in EIM, Locus’ environmental data management software, during 2020!

        5 Ways To Save With Locus

        For over 20 years, Locus environmental software customers have saved enormously on their setup and and data entry costs. This infographic highlights the aggregate savings of all users based on conservative estimates of time and cost for different aspects related to our software.

        5-ways-to-save

         

        Contact us today to discuss how you can save with Locus

          Name

          Company Email

          Phone

          Tell us about your company's needs

          Locus is committed to preserving your privacy.

          Unified EHS Platform: Enter Once, Report to Many

          Is your organization still using multiple software systems for EHS&S when you can (and should) be using one robust and unified platform? Unify your compliance, sustainability, water, air, and environmental data with Locus’ cloud platform for EHS&S. It’s easier, cheaper, and more efficient.

          Unified EHS Platform - Infographic

          With Locus Platform, you can easily and securely feed all of your different EHS data sources to the cloud via a wide array of import options. You will then be able to analyze and report to virtually any regulatory agency, meeting any specific requirements they may have. We believe in making EHS compliance simpler.

          Contact us to see Locus’ Unified EHS Platform in action

            Name

            Company Email

            Phone

            Tell us about your company's needs

            Locus is committed to preserving your privacy.

            Simple and reliable tank emissions calculation tool for accurate reports

            EPA announced that it will no longer support its TANKS 4.09D emission calculation tool. Have you been researching various software options in the market? Look no further, Locus has a reliable, easy to use, scalable replacement Tanks Emission application for you!

            Infographic | Locus Platform Tank Emissions application

             

            Contact us to learn more about the Tank Emissions app

              First name

              Last name

              Email address

              Phone number

              Company

              Job title

              Tell us about your company's needs

              Locus is committed to preserving your privacy.

              Simplify your EPA fenceline regulatory reporting

              Locus Platform provides the solution for managing and submitting fenceline monitoring data.

              Locus handles all the EPA required environmental data collected at your refinery giving you a simple solution for all your data management and reporting needs. Our enhanced GIS+ mapping, data reports, formatted outputs, and charts help you streamline, consolidate, and take control of all your crucial environmental information.

              Infographic - Locus Fenceline Monitoring

               

              Contact us to learn more about Locus’ Fenceline app

                First name

                Last name

                Email address

                Phone number

                Company

                Job title

                Tell us about your company's needs

                Locus is committed to preserving your privacy.

                Tag Archive for: Reporting

                Nothing Found

                Sorry, no posts matched your criteria