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.
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.You may need a PDF reader to view some of the files on this page. See EPA’s About PDF page to learn more.