Export Button

The export button can be used to save either a binary workspace or a comma-separated-values (CSV) format file.
The binary workspace can be re-loaded for further analysis in FirePlex Analysis Workbench.
The CSV file can be read into R, Matlab, Excel, or other data analysis program for further processing.

CSV file format

The exported file contains a matrix of data.   The format of the matrix is shown below.
The samples are in the rows (A01, A02, A03... in the figure).
The probes are in the columns (p1, p2, p3, p4... in the figure).


By default, only probes and samples which are not marked as hidden are exported.   If desired, the hidden probes and samples can also be exported using the checkbox on the export options form.

Each probe is represented by several potential statistics, including mean, standard error of the mean, inter-particle standard deviation, inter-particle coefficient of variation, and particle count.  These are represented as the suffices a,b,c... on the probe names in the figure.   The sample/probe matrix for each statistic is contiguous, so all the signal values are together, all the CoV values are together, etc.
The signals in the matrix represent the values at the end of the signal processing pipeline, and are potentially blank subtracted, negative subtracted, and normalized, depending on user choices.

If only the signal values and not the std. deviation, CoV etc are desired, select "simple" on the export popup form.   The column headers indicated as "p1a" in the table below, will be written either as a single cell "p1a-signal" or as two cells, with "signal" in the top row and "p1a" in the second row, according to the popup item "combine headers".   Downstream programs such as Excel or R should skip either one row or two rows when they read the data.

Three dummy columns are added, including a negative column to represent whether the sample in a row is a negative sample, a probes column giving the total number of probes detected in a particular sample, and a particles column, giving the total number of particles detected in that sample (over all probes).

Three dummy rows are added.  The first is a blank row to indicate for each probe whether it was used as a blank probe, the second one is a normal row, to indicate whether it was used as a normalization probe.  The third row is the minimum detectable dose of that probe.

One matrix is exported for each experiment.   All matrices can be written to one file, or each to a separate file, according to the export popup.


p1a
p2a
p3a
p4a
p1b
p2b
p3b
p4b
p1c
p2c
p3c
p4c
negatives
probes
particles
A01












0
np
N
A02












0
np N
A03












0
np N
A04












0
np N
A05












0
np N
B01












0
np N
B02












0
np N
B03












0
np N
B04












1
np N
B05












1
np N
blank



1



1



1



normal


1



1



1




MDD
z1
z2 z3 z4 z1
z2
z3
z4
z1
z2
z3
z4



See Also

Data statistics
Data processing
Help Front Page