Tag Archive for: Reporting

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.

              5 tools to get more EHS tasks done with less staff

              EHS software can be a boon or a bane of your life at work. Here are the 5 time- saving tools Locus’s EIM provides that can be the difference between the former versus the latter.

               

              1. Mobile

              Do you enter field data onto a paper form, and then have to manually type it into a spreadsheet or database when you get back to the office?  Or have you ever been in the field and entered data into your remote mobile device and have lost the data due to the lack of internet signal? Locus’ Mobile application allows you to sync with your server to create data collection profiles on a mobile device, whether it’s your phone or a tablet. This application will allow you to click through and enter data on the device and store the data, even when you are offline. As a result, data only need to be entered once on your device, and then they are seamlessly loaded into your  cloud-hosted solution.

              Using Mobile you have data entry directly on the mobile device, with immediate data availability on the cloud when you reach an internet signal. Other advantages include location metadata and mapping integration, bar-code/or code scanning, voice recognition and form customization. If you would like to know more, check out the Top 10 cool features in Locus Mobile.

              Locus mobile environmental field data collection app for iOS

              2. EDD Loader

              With EIM’s electronic data deliverables (EDD) loader, you can upload and validate several thousand records within a minute. Laboratories are not required to use the same reporting format, yet the results will still end up at the same place in the database where sample data came from. Locus EIM also has a special lab interface so that your labs (with your permission) can upload their own EDDs. You no longer need to spend time receiving and processing EDD files from your lab. The labs simply log in directly, upload your reports, and they are immediately available to you.

              EIM provides you access to popular features such as a planning module, forms for entering field data, a utility to upload EDDs, built-in mapping tools, and an extensive reporting and plotting module. It also has a calendar module for viewing information on sampling events and uploaded EDDs, automated exceedance notifications, and sophisticated statistical evaluation tools designed specifically for environmental data.

              Locus EIM - EDD Loader

               

              3. Sample planning

              Setting up and implementing a complex sampling plan can be a time-consuming effort. Depending on the purpose and extent of the sampling plan, you may have dozens of analyses to complete at varying frequencies and locations.  You may also have multiple compliance programs with overlapping requirements.  EIM’s sample planning can save you valuable time and effort by assembling your requirements into a concise calendar, preprinting all of your chain of custody records and bottle labels, and tracking the collection of samples from the field to the lab.  As an added bonus, the automation of this process ensures you’ll never miss another required sample.

              EIM screenshot of sample planning edit form with email notification and calendars popouts

                

              4. Discharge Monitoring Reports

              Locus’ EIM DMR tool solves the problem of time-consuming, labor-intensive, and expensive manual report generation by automating the data assembly, calculations, and formatting of Discharge Monitoring Reports.  Depending on the type of discharge and the regulatory jurisdiction, you may be required to report information such as analytical chemistry of pollutants, flow velocity, total maximum daily load, and other parameters. For companies that report from 100 to 1,000 facilities, producing a DMR also becomes a major expense.

              Thanks to Locus’ DMR reporting tool, companies can generate DMRs within minutes with validated data in approved formats, with all of the calculations completed according to regulatory requirements. Companies can set up EIM for its permitted facilities and realize immediate cost and time savings during each reporting period.

              DMR builder and report in EIM

               

              5. Formatted Data Tables

              For most environmental database systems, getting the right data out is just the first step in assembling your reports.  Comprehensive systems rarely store data in a format that is ready to submit to a regulatory agency or other party.  Typically, you have a labor-intensive process of restructuring, labelling, footnoting, formatting, and paginating the data into tables that can be readily interpreted. EIM’s formatted reporting tools allow you to set up any number of table formats with specific grouping, sorting, footnotes, headers, and other data processing steps.  Then you just select your data range, pick your format, and the table is ready to download or print directly from your web browser.  And if you make a mistake, the report can be instantly regenerated without any effort.

              Locus EIM - Formatted Reports

               

               

              Tag Archive for: Reporting

              Nothing Found

              Sorry, no posts matched your criteria