Agilent_7900_ICPMS #58
Description
<style>
</style>
Parser Name: Agilent_7900_ICPMS
Example Data File: 20200303 SPLP TCLP CMT ICP-MS Batch Report
| Instrument File Field Location | Universal Template File Field Location | Special Notes |
|---|---|---|
| Column G (Beginning with row 3) | Column A (Aliquot) | |
| Column D (Beginning with row 3) | Column F (Analysis Date/Time) | |
| Row 1 (Beginning with column H) | Column B (Analyte Identifier) | The number of columns may vary. Column H through the last column (Column EM in the example data file I have attached) will need to be parsed |
| Column H (Beginning with row 4) | Column C (Measured Value) | Convert blank cells, “N/A”, and “<0.00” to be imported as “0” Beginning with Column H of the instrument file, every other column will need to be parsed. For example, Column H values will need to be mapped starting in row 3, Column I will be skipped, Column J will be mapped, and Column K will be skipped, etc. If it is any easier for you, cell 2 in the column that needs parsed will read either “Conc. [ ppb ]” or “CPS” whereas cell 2 in the column that will be skipped will read either “Conc. RSD” or “CPS RSD” The number of columns may vary. Column H through the last column (Column EM in the example data file I have attached) will need to be parsed |