Environmental Analysis Training



Advanced Spreadsheet Functionality for Air Quality Compliance

Microsoft® Excel® is widely used by environmental professionals in calculating emissions, compiling environmental reports, keeping operational records, and complying with permit limits. A properly designed spreadsheet can significantly reduce the time spent and potential errors in permitting, compliance and reporting tasks. In this 1-day workshop, new and seasoned environmental professionals learn to use advanced Microsoft Excel functions to streamline environmental tasks. Exercises throughout the class demonstrate real life applications of each function. Topics include:

  • Optimizing spreadsheet design and flexibility
  • Most commonly used Excel functions by environmental professionals
  • Introduction to Pivot Tables
  • Tips and keyboard shortcuts
  • Electronic recordkeeping/reporting using Excel
  • Type Date Location
    Classroom Oct 19, 2017 - 8:00 AM - 5:00 PM Houston, TX
    Classroom May 03, 2018 - 8:00 AM - 5:00 PM Philadelphia, PA
    Classroom May 17, 2018 - 8:00 AM - 5:00 PM Orlando, FL


    Advanced Tank Emission Calculation

    Companies are required to perform proper tank emission calculations based on the methodology provided in U.S. EPA’s Compilation of Air Pollutant Emission Factors (AP-42). This complicated process was previously facilitated by EPA’s tanks emissions estimation software, TANKS 4.09d. However, in 2014, EPA announced it would no longer maintain the TANKS 4.09d software. While TANKS 4.09d is still available on EPA's website, EPA States that the model should be "used at your own risk". Instead, EPA recommends using the equations/algorithms specified in AP-42 Chapter 7 for estimating VOC emissions from storage tanks. This one-day course covers VOC emission calculation methods based on the algorithms specified in AP-42 Chapter 7 and API Technical Report 2568, November 2007 and some local agency guidance.

    The course provides a detailed look into air emission issues related to aboveground storage tanks and provides insight on best practices for emission calculations, regulatory compliance, and recordkeeping. Due to the complexity of the AP-42 Chapter 7 methodology and equations, the course will include demonstrations of popular tank emission calculation programs which follow the AP-42 methodology and will cover emissions estimates from fixed roof storage tanks and floating roof tanks. Attendees will be prepared with the TankESP program database version for practice. Some other hot spots (e.g., short term emission estimates, throughput determination, heated tanks) are also discussed. Finally, the course provides recommendations on how to improve tank data quality and the accuracy of emissions estimates.

    Type Date Location
    Classroom Sep 28, 2017 - 8:00 AM - 5:00 PM Dallas, TX
    Classroom Oct 26, 2017 - 8:00 AM - 5:00 PM Oakbrook Terrace, IL
    Classroom Mar 15, 2018 - 8:00 AM - 5:00 PM Oakland, CA


    Ambient Monitoring Fundamentals

    This course provides a fundamental understanding of the considerations and requirements of ambient air quality and meteorological monitoring. This course covers station siting criteria all the way through data submittal, and includes specific treatment of the siting process, as well as the operation of a number of tools of the trade. Further instrumentation discussion and examples are conducted in a classroom setting. Real-world monitoring challenges will be discussed and experiences shared.

    Type Date Location
    Classroom May 08, 2018 - 9:00 AM - 4:00 PM Houston, TX


    Continuous Emission Monitoring Systems (CEMS) – Best Practices and Program Management

    This 2-day course provides a thorough overview of what CEMS are and how they work, the different types of CEMS, and technologies used to analyze emissions. It details why CEMS are used and the regulations that require their use to demonstrate compliance, and addresses best management practices to ensure reliability, accuracy, and efficient use of facility resources. The CEMS quality assurance plan (QAP) is also discussed in detail. The course is intended for environmental managers, CEMS technicians and managers, and anyone who works with CEMS or CEMS data on a regular basis.

  • Tools to build successful CEMS maintenance and management programs
  • Review frequently occurring CEMS performance issues and methods to prevent those issues from occurring
  • Overview of different types of CEMS and the essentials of how they work
  • Type Date Location
    Classroom Mar 22 - 23, 2018 - 8:00 AM - 5:00 PM Boston, MA


    Effective Management of Stack Test Programs

    Learn about managing stack test programs during this 1½-day course. You won’t learn how to be a stack tester, but you will learn how to write effective stack testing RFPs, how to separate the wheat from the chaff among contractors, tricks of the trade that stack testers use (sometime to your benefit and sometimes not), how to review stack test reports, and other insider information from an instructor who has been involved in stack testing for 30 thirty years. Learn about:

  • Regulatory requirements for emissions measurement and fundamental principles
  • Test program design and preparation
  • Test methods, data reduction, and calculation
  • Relative accuracy test audits (RATAs)
  • Type Date Location
    Classroom Mar 20 - 21, 2018 - 8:00 AM - 5:00 PM Boston, MA


    Managing Environmental Nuisances: Odor and Noise

    This 1-day course is for corporate/facility environmental personnel who need to assess, control, and manage odor and noise concerns. The course examines regulatory thresholds, how to measure and objectively analyze readings, how to model off-site odor impacts, strategies to successfully control and minimize off-site impacts, and complaint management and investigative practices. The course includes a review of case studies, how-to develop odor and noise control response plans, and a pseudo-field component, allowing for attendees to use basic odor and noise measuring equipment. Attendees learn about:

    • Methods to quantify and characterize odor and noise levels
    • Methods to evaluate and predict potential impacts
    • Benefits and potential shortcomings of mitigation and abatement strategies
    • Developing an effective Nuisance Complaint Response Plan and ongoing nuisance management programs
    • Roles of industry / environmental managers with respect to nuisances

    Type Date Location
    Classroom May 03, 2018 - 8:00 AM - 5:00 PM Banff, AB