Excel-based Macro Analysis Tool for Air Sensor Data

EPA’s Excel-based macro analysis tool was created to help citizen scientists, and other non-experts, compare data from low-cost sensors with data from regulatory monitors, and interpret their results. The tool allows users to input data from low-cost and regulatory monitors for comparison, even if the data sets don’t have matching time-date stamps or were collected at different time intervals. This tool addresses one of the major hurdles in citizen-led community air monitoring projects – working with and understanding the data.

• Excel-based Macro Analysis Tool for Air Sensor Data(7 pp, 1 MB)

Instruction Guide: How to Evaluate Low-Cost Sensor by Collocation with Federal Reference Monitors

EPA has developed an instruction guide on conducting a successful collocation evaluation of low-cost air sensors with regulatory grade monitors. The instruction guide contains links to web-based supporting materials, and introduces users to EPA’s Excel-based macro analysis tool for comparing and interpreting air sensor data.

• Instruction Guide: How to Evaluate Low-Cost Sensors by Collocation with Federal Reference Monitors (PDF)(45 pp, 3 MB)