Jump to main content.


Generic Spreadsheet Files to calculate the certified elemental mercury gas concentrations and associated uncertainty values

Note: In addition to using these generic spreadsheets, it is recommended that you contact your specific mercury generator vendor to see if they have vendor-specific spreadsheets you can use.

Certification from Bracketing (Excel, 113 KB) - This workbook can be used at several steps in the certification process (i.e., certifying Vendor Prime, Field Reference, or User generators), but is most likely to be used by a vendor, since its primary purpose is to bring together results from dual-bracketing or multi-bracketing certification procedures. It is not specific to the type of detection technology (such as a concentrating detector developed by Tekran or a continuous detector developed Thermo-Fisher Scientific). Vendors who do not have their own certification spreadsheet/software must use this workbook (along with the appropriate companion workbook below) for certifying Field Reference generators.

Concentrating Detector Bracketing Only (Excel, 2.47 MB) - This workbook processes the data from one bracketing procedure using a concentrating detector. It is not a stand-alone certification workbook. It is a companion to the "Certification from Bracketing.xls" workbook which receives processed data from two or more "Bracketing only" workbooks to certify generators. Vendors are the most likely users (using it to certify Field Reference generators), though field analysts may choose this certification option for User generators (e.g., if incorporating the Type-B default reproducibility causes the target uncertainty to be exceeded).

Continuous Detector Bracketing Only (Excel, 738 KB) - This workbook processes the data from one bracketing procedure using a continuous detector. It is not a stand-alone certification workbook. It is a companion to the "Certification from Bracketing.xls" workbook which receives processed data from two or more "Bracketing only" workbooks to certify generators. Vendors are the most likely users (using it to certify Field Reference generators), though field analysts may choose this certification option for User generators (e.g., if incorporating the Type-B default reproducibility causes the target uncertainty to be exceeded).

User Generator Certification with Concentrating Detector (Excel, 2.50 KB) - The primary purpose of this workbook is to provide a time-efficient option for certifying User generators in the field, though the interim elemental Hg gas protocol does not currently prohibit its use for certifying User generators at vendor facilities. The workbook is specific to concentrating detectors. It can not be used to certify Vendor Prime or Field Reference generators, because it only supports the Type-B default reproducibility calculation.

User Generator Certification with Continuous Detector (Excel, 782 MB) - The primary purpose of this workbook is to provide a time-efficient option for certifying User generators in the field, though the interim protocol does not currently prohibit its use for certifying User generators at vendor facilities. The workbook is specific to continuous detectors. It can not be used to certify Vendor Prime or Field Reference generators, because it only supports the Type-B default reproducibility calculation.

 


Local Navigation


Jump to main content.