๐Ÿ  Home ๐Ÿ“ R Script

๐Ÿ“Š Data Merger & Sorting System

Upload multiple Excel files, align by CAS number, and sort by Retention Time

1. Upload Excel Files

Instructions: Upload multiple Excel files containing GC/MS data. Each file should have the following columns:
  • Group - Classification of the compound
  • Name - Name of the compound
  • RT - Retention Time (used for sorting)
  • IR - Retention Index (optional but recommended)
  • CAS - CAS number (used for alignment)
  • RA1, RA2, RA3 - Replicate area values
  • RC1, RC2, RC3 - Relative content values
The system will merge all files, align compounds by CAS number, sort by Retention Time, and create a master matrix. Upload format is identical to the Paste Data format.
๐Ÿ“

Drop Excel files here or click to browse

Supports .xlsx and .xls files (multiple files allowed)

2. Paste Data (Standard Format)

Paste tab-separated data with the exact column order below. The pasted data will replace any previously merged results.

Choose a sample to revise; the pasted data will overwrite that sample.

3. Paste Transposed Data (Samples as Rows)

Format: Paste data where samples are rows and compounds are columns.
  • First row: First column can be "Sample" or empty, then compound names (Pentanal, Hexanal, etc.)
  • Second row (optional): Numbers (1, 2, 3...) - will be ignored
  • Data rows: Sample name in first column, then values for each compound
  • Multiple rows per sample: Replicates are automatically grouped by sample name
  • Multiple data sets: Paste each data set in a separate area below. Click "Parse & Load All Data Sets" to merge them all together.
Example format: 
	Hexanal	2-Hexenal, (E)-	Heptanal	Octanal
Patriot (F)	19.77	0.40	0.67	0.32
Patriot (F)	18.25	0.30	0.75	0.39
Patriot (F)	17.48	0.36	0.70	0.34
HOLL (F)	7.91	0.09	0.89	1.15
HOLL (F)	7.10	0.10	0.94	1.25
HOLL (F)	7.44	0.11	1.12	1.24

4. Paste Simple Data (Compound + Value)

Instructions: Each data set represents one sample. For each set:
  1. Type the sample name
  2. Step 1: Paste compound names (one per line) โ†’ click "Submit Compounds"
  3. Step 2: Select value type (OAV or Relative Content) โ†’ paste values (one per line) โ†’ click "Submit Values"
Add multiple data sets for different samples.
โ ฟ Drag to move | Master Sheet

๐Ÿ“‹ Master Sheet Generated

Processed files and found unique compounds.