Create excel sheet with the raw data to be analyzed (background subtracted if required). The data should be in a 8x12 matrix with an additional row and column as margins including row and column labels
More than one plate can be included on the same excel sheet with a separator specifying the plateID. The plateID should be placed in the cell on the top-left corner of the matrix (cf. sheet "IgA") and each plate should be separate with an empty line
Create excel_sheet with the plate layout. The sheet name should be identical to sample data but extended with "_Layout".
The layout should be identical to the sample data format.
Standard curve values should be marked with yellow background color and labelled with a name (e.g. antigen name without spaces) and separate from the concentration with a space (e.g. "IgA 250"). No units should be used
Sample values should be marked with a sampleID (no spaces) and separated from the dilution factor with a space (e.g. "Sample1 500" = Sample1 diluted 500 times)
The standard curve allows you to select range of OD values that you consider within the analytical range. Sample OD values within the range will be translated to the corresponding concentration.
Each sample is displayed with the raw OD value and the corresponding concentration based on the standard curve and the dilution factor.
The concentration is transformed from ng/ml to mg/ml (j.o. divided by 10%). This part needs to be updated to accommodate any type of ELISA data.