R Script System

Instructions: Upload an Excel file with raw data. The file should have:

• First column: Group (required) - e.g., "total aldehyde", "total alcohol", "alkane", etc.
• Optional columns: RT, Name, IR, CAS (in any order after Group)
• Subsequent columns: Column headers with format "SampleName_RC1", "SampleName_RC2", "SampleName_RC3" (underscore or space also accepted)
• Data cells: Relative content (RC) values for each group/category and sample

Example format 1 (with RT/Name/IR/CAS):

Group	RT	Name	IR	CAS	HX-Patriot_RC1	HX-Patriot_RC2	HX-Patriot_RC3
alkane	1.93	2-methyl-pentane	579	107-83-5	4.11	3.08	4.64

Example format 2 (Group only - for category totals):

Group	HX-Patriot_RC1	HX-Patriot_RC2	HX-Patriot_RC3	HX-HOLL_RC1	HX-HOLL_RC2	HX-HOLL_RC3
total aldehyde	12.5	13.2	12.8	15.3	14.9	15.1
total alcohol	8.3	8.7	8.5	9.2	9.0	9.1

Note: The system will automatically detect sample names from the RC column headers and perform ANOVA with Tukey HSD post-hoc tests for each group/category, assigning letter comparisons (a, b, c, etc.) to indicate significant differences. RT, Name, IR, and CAS columns are optional - you can perform statistical analysis on category totals (e.g., "total aldehyde", "total alcohol") without individual compound details.

Instructions: Upload an Excel file containing R statistical analysis results. The file should have:

• Group column: Category/group names (e.g., "aldehyde", "alcohol", etc.) - Required
• Compound column: Compound names (optional - will be included if present)
• RT, IR, CAS columns: Retention Time, Retention Index, and CAS numbers (optional - will be included if present)
• Sample columns: For each sample, there should be Mean, SD, and Significance (letter) columns
• Column naming: Format should be "SampleName_Mean", "SampleName_SD", "SampleName_Sig" (or similar variations)

Example format:

Group	Compound	RT	IR	CAS	HX_Patriot_Mean	HX_Patriot_SD	HX_Patriot_Sig	HX_HOLL_Mean	HX_HOLL_SD	HX_HOLL_Sig
aldehyde	Pentanal	3.15	705	110-62-3	2.533333	0.355715	b	0	0	e

Note: The system will automatically detect sample names and organize the data into a clean format with No., Group, Compound (if present), and Mean±SD/Significance columns for each sample.