This diffusion tube data processing tool has been developed to assist local authorities in processing their NO2 diffusion tube monitoring data. It allows annual mean NO2 concentration results to be calculated from NO2 diffusion tube raw monthly data, by consolidating previous LAQM tools for processing diffusion tube monitoring data into a single tool. This serves to streamline the data processing requirements of NO2 diffusion tubes and improve the quality assurance associated with NO2 diffusion tube data processing. Through alignment of the output result tables with the annual reporting template requirements, the tool facilitates ease of population of the associated annual reporting data tables.
In addition, it provides an output table which can be directly uploaded into the LAQM Portal via the new Diffusion Tube Data Entry System (DTDES), which is part of the annual submission requirements for English local authorities (excluding London boroughs).
Diffusion Tube Data Processing Tool v3.0
Released: March 2023 (XLS, 6.5 MB)
The tool includes steps to assist with:
- Annualisation – the process of estimating annual mean NO2 concentrations when data capture for the year is below 75%.
- Bias Adjustment – the process of accounting for the variable accuracy of annual mean NO2 concentrations as measured by diffusion tubes relative to the chemiluminescent reference method.
- Fall off with Distance Adjustment – the process of estimating an annual mean NO2 concentration at a receptor location that is close to a monitoring site.
- Calculation of the Annual Mean Concentration.
Further information with regards to the use of the Diffusion Tube Data Processing Tool is provided within Technical Guidance LAQM.TG(22).