ORBITRAP automatic file processing

[info] Mandatory format of the input excel
  • Format ".xlsx"
  • Columns
    • Column "Compound" (text)
    • Column "Formula" (text)
    • Column "RT" (number)
    • Column "RT Delta" (number)
    • Column "m/z Delta" (number)
    • Column "S/N" (number)
    • Column "Num Isotopes Matched" (?)
    • Column "Adduct" (text) ["M+H","M-H","N/A"]
    • Column "Type" (text) ["Target Compound"]
    • Column "Status" (text) ["Processed"]
    • Column "Sample Type" (text) ["Cal Std","Unknown"]
    • Column "Filename" (text)
    • Column "Area" (number)
    • Column "Peak Label" (text) ["T1","T1C1","T1C2"]
  • Blank name for MM: "MM_Blank_AIF"
  • Blank name for samples: "Blank_HPLC_AIF"
  • The name of the blank for the recovery will be deduced

Column "Peak Label" value to filter:

{{error}}
⏳ working...

Visible filenames
{{[ "Calibration", "Samples", ][i]}}
Blanks Filename Subtract?
MM "{{nom_blanc_MM}}"
Recovery "{{nom_blanc_recovery}}"
Samples "{{nom_blanc_mostres}}"
"{{val}}"
Choose Regression for "ppb computed"


(ask mcelic)
Vol initial sample (ml)
Vol final extract (ml)
Factor Concentration (∅) {{factor_concentration}}



low
high


Results ({{get_sheets_filtrats.length}}/{{sheets.length}})
~No results

{{sheet.nom}}
[{{ Array.from(new Set(sheet.rows.map(r=>r.formula))).join(", ") }}]

blank area
{{key}} {{val}}
groups sample type adduct RT RT Delta m/z Delta S/N type status filename area (raw) area (-blank)
ppb theoric
("level")
ppb computed
ppb computed
(appl. recovery)
exclude
calibration {{row.sample_type}} {{row.adduct}} {{row.RT}} {{row.RT_Delta}}
{{row.mz_Delta}}
{{row.mz_Delta}}
{{row.SN}} {{row.type}} {{row.status}} {{row.filename}}
{{row.area}}
{{row.area}}
{{area_blanked}}
{{row.ppb_teoric}}
{{ppb_computed}}
sample {{row.sample_type}} {{row.adduct}} {{row.RT}} {{row.RT_Delta}}
{{row.mz_Delta}}
{{row.mz_Delta}}
{{row.SN}} {{row.type}} {{row.status}} {{row.filename}}
{{row.area}}
{{row.area}}
{{area_blanked}}
{{row.ppb_teoric}}
{{ppb_computed}}
{{quantifica_area(sheet, area_blanked)*100/rec}}
Regression {{tipus_regressio=='CC'?'CalCurve':tipus_regressio}} (ppb = m·area + n)
m {{sheet.regressio[tipus_regressio].m}}
n {{sheet.regressio[tipus_regressio].n}}
r2 {{sheet.regressio[tipus_regressio].r_squared}}
#points {{sheet.regressio[tipus_regressio].N}}
Recovery (%) {{sheet.recovery}}