Instrument File Field Location (.txt) | Instrument File Field Location (.xlsx) | Universal Template File Field Location | Special Notes
-- | -- | -- | --
Text in the row beginning with “Data File” following the “: ” | Cell E4 | Column A (Aliquot) | Apply this to all result lines in the file.
In the “Compound” column of the table, following the numbers under “Target Compounds” | Column C, beginning at row 28 | Column B (Analyte Identifier) |
In the “Conc” column of the table. | Column F, beginning at row 28 | Column C (Measured Value) |
Date and time in the row beginning with “Quant Time” | Cells D13 – G13 | Column F (Analysis Date / Time) | Please convert to MM:DD:YYYY HH:MM format. Instrument file uses abbreviated month (eg: Oct).
<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">
Instrument File Field Location (.txt) | Instrument File Field Location (.xlsx) | Universal Template File Field Location | Special Notes -- | -- | -- | -- Text in the row beginning with “Data File” following the “: ” | Cell E4 | Column A (Aliquot) | Apply this to all result lines in the file. In the “Compound” column of the table, following the numbers under “Target Compounds” | Column C, beginning at row 28 | Column B (Analyte Identifier) | In the “Conc” column of the table. | Column F, beginning at row 28 | Column C (Measured Value) | Date and time in the row beginning with “Quant Time” | Cells D13 – G13 | Column F (Analysis Date / Time) | Please convert to MM:DD:YYYY HH:MM format. Instrument file uses abbreviated month (eg: Oct).