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
<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
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