Search for tag: "tribal"

Underground Injection Control Class I and PFAS

On February 8, 2024, the Tribal PFAS Working Group invited Dana Gava, EPA, to provide a presentation on underground injection wells. The underground injection wells may be used as a method for the…

From  Elaina Doral 0 plays 0  

Session 11-4 Forest County Potawatomi Community

From  ITEP Team 1 plays 0  

Session 11-3 Forest County Potawatomi Community

From  ITEP Team 1 plays 0  

Session 11-2 Forest County Potawatomi Community

From  ITEP Team 1 plays 0  

Session 11-1 Forest County Potawatomi Community

From  ITEP Team 1 plays 0  

Tribal PFAS Working Group Open House Webinar

On December 14, 2023, the Tribal PFAS Working Group hosted an open house to provide more information on the working group activities and to hear a presentation on PFAS on Tribal Lands by Dr. Kimberly…

From  Elaina Doral 10 plays 0  

VW Final Distribution Webinar

NOTE: There is an error in this video regarding the deadline to complete the call-back with the Trustee so they can wire the funds. This call-back must be completed by 5 PM Eastern on December 20,…

From  ITEP Team 51 plays 0  

PFAS Settlements with DuPont and 3M

Frank Holleman (Sonosky, Chambers, Sachse, Endreson & Perry, LLP) provided an update on the settlements with DuPont and 3M regarding PFAS contaminated drinking water systems.

From  Elaina Doral 10 plays 0  

Protecting Our Sacred Waters: An Introduction to the National Tribal Water Council

The National Tribal Water Council (NTWC) was established to advocate for the best interests of federally-recognized Indian and Alaska Native Tribes in matters pertaining to water. It is the intent of…

From  Elaina Doral 111 plays 0  

Excel B: Multiple 5-min Files Cleaned Appended Summarized Charted

This demonstration shows how to use MS Excel Power Query (with a user interface) to go from two excel files of 5 minute data, append the files, remove duplicates, filter AQS-nulled values, and…

From  ITEP Team 5 plays 0  

QC Data Sheets Pt 1-Field QC Data on Paper and into Excel Overview

This video provides an overview of one way (free to anyone) to set up a form that can be accessed on a smartphone in the field, enabling users to type in the results of field QC checks, and then…

From  ITEP Team 7 plays 0  

Excel 6 Pivot Chart to Present Data

Continuing to use the minute sensor data, this demonstration is of inserting a pivot chart that can be collapsed and expanded to generate summary statistics by hour, day, month and year.

From  ITEP Team 7 plays 0  

Excel 5 Pivot Table for Summary Statistics

Demonstration of how to summarize minute sensor data by average and max, by hour and day, using a pivot table. Caution: check for gaps in your data, which may not be represented clearly in a pivot…

From  ITEP Team 10 plays 0  

Excel 4 Fun: Excel Map from Lat Long

This video demonstrates using the same sensor data that has been used in the importing videos, and excel’s ability to understand geographic identifiers and incorporate maps, to generate a map…

From  ITEP Team 11 plays 0  

Excel 3 Use Named Ranges as Brain Savers

Very brief demonstration of how to name a range of data (and if this range is in an excel Table it will automatically expand to include more rows), which allows you to refer to that range by name…

From  ITEP Team 8 plays 0  

Excel 2 Import Anything Using Power Query

Demonstration of the import of the same sensor data into excel as was demonstrated in the legacy import video, but this import is done using the self-documenting excel power query feature.

From  ITEP Team 15 plays 0