|
|
Last video in a series of four, demonstrating how to:set up a query that uses a previous query as a source (the RAW data), generate calculated fields (% difference from a standard), send this…
|
|
|
Demonstration of reproducibly importing one table from a multi page adobe report (NCAI.pdf, attached), to generate summary statistics, and a calculated field (population change in ten years, by…
|
|
|
This very short demonstration shows how to create a query that automatically goes to the EPA AQS air data codes database online, queries their website and filters parameters including just ozone and…
|
|
|
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…
|
|
|
Demonstration of establishing a free outlook.com account and setting up a form for smartphone or computer, for gathering field data that must be hand entered, such as flow rate checks, and accessing…
|
|
|
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…
|
|
|
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.
|
|
|
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…
|
|
|
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…
|
|
|
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…
|
|
|
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.
|
|
|
Demonstration of importing sensor minute data (follow along using the raw comma separated values .csv data file attached to this video) into an excel file using the excel legacy wizard. Legacy…
|
|
|
Quality Review and Exchange System for Tribes (QREST) online meeting, including informal discussions of:
0:00 What is Polling
2:53 Raw Data
7:10…
|
|
|
(To request closed captioning or transcripts, contact
[email protected] with the title and URL of the video.)
This presentation reviewed the Native American Environmental
Protection Coalition's…
|
|
|
(To request closed captioning or transcripts, contact [email protected] with the title and URL of the video.) This presentation reviewed the migration of an End-to-End Digital Data Management System for…
|
|
|
NOTE: Due to technical difficulties, the audio portion of this presentation is unavailable until approximately the 12:45 mark. (To request closed captioning or transcripts, contact [email protected] with…
|
