Quality of life change: option to write on the same sheet/csv rather than multiple sheet in same excel

[TKMarkCheng]

Instead of writing each plate to a different sheet (with 10 columns each), output to a big sheet/CSV with all samples with sensible naming of the columns. Column naming can be in the fashion of
<brightGlo_readout_filename>_<column_number> OR
<brightGlo_readout_filename>_<pre-determined column name defined in a metadata sheet>

[TKMarkCheng]

This is an extension of #5 and the ideal program should allow for:

1. Generation of a plate map template for the user to fill (in excel or CSV form)
2. feeding in the plate maps (this thread)

The current format is

Group	Individual_sample	Virus	Plate	Plate_Name	Well
1	bruh	WT	plate1	26102023_plate1_WT_RBM	A3
1	bruh	WT	plate1	26102023_plate1_WT_RBM	A4
1	bruh2	WT	plate1	26102023_plate1_WT_RBM	A5
1	bruh2	WT	plate1	26102023_plate1_WT_RBM	A6
1	bruh3	WT	plate1	26102023_plate1_WT_RBM	A7
1	bruh3	WT	plate1	26102023_plate1_WT_RBM	A8
1	bruh4	WT	plate1	26102023_plate1_WT_RBM	A9
1	bruh4	WT	plate1	26102023_plate1_WT_RBM	A10
1	bruh5	WT	plate1	26102023_plate1_WT_RBM	A11
1	bruh5	WT	plate1	26102023_plate1_WT_RBM	A12

Group	Individual_condition	Virus	Plate	Plate_Name	Well	dilution_or_concentration	Starting_Dilution_or_concentration	dilution series
1	bruh	Virus1	plate1	26102023_plate1_Virus1	A3	dilution	20	1 in 3
1	bruh	Virus1	plate1	26102023_plate1_Virus1	A4	dilution	20	1 in 3
1	bruh2	Virus1	plate1	26102023_plate1_Virus1	A5	dilution	20	1 in 3
1	bruh2	Virus1	plate1	26102023_plate1_Virus1	A6	dilution	20	1 in 3
1	bruh3	Virus1	plate1	26102023_plate1_Virus1	A7	dilution	20	1 in 3
1	bruh3	Virus1	plate1	26102023_plate1_Virus1	A8	dilution	20	1 in 3
1	bruh4	Virus1	plate1	26102023_plate1_Virus1	A9	dilution	20	1 in 3
1	bruh4	Virus1	plate1	26102023_plate1_Virus1	A10	dilution	20	1 in 3
1	bruh5	Virus1	plate1	26102023_plate1_Virus1	A11	dilution	20	1 in 3
1	bruh5	Virus1	plate1	26102023_plate1_Virus1	A12	dilution	20	1 in 3
1	bruh	Virus2	plate2	26102023_plate2_Virus2	A3	dilution	20	1 in 3
1	bruh	Virus2	plate2	26102023_plate2_Virus2	A4	dilution	20	1 in 3
1	bruh2	Virus2	plate2	26102023_plate2_Virus2	A5	dilution	20	1 in 3
1	bruh2	Virus2	plate2	26102023_plate2_Virus2	A6	dilution	20	1 in 3
1	bruh3	Virus2	plate2	26102023_plate2_Virus2	A7	dilution	20	1 in 3
1	bruh3	Virus2	plate2	26102023_plate2_Virus2	A8	dilution	20	1 in 3
1	bruh4	Virus2	plate2	26102023_plate2_Virus2	A9	dilution	20	1 in 3
1	bruh4	Virus2	plate2	26102023_plate2_Virus2	A10	dilution	20	1 in 3
1	bruh5	Virus2	plate2	26102023_plate2_Virus2	A11	dilution	20	1 in 3
1	bruh5	Virus2	plate2	26102023_plate2_Virus2	A12	dilution	20	1 in 3

Where dilution_or_concentration, Starting_Dilution_or_concentration and dilution_series can be defined.

dilution_or_concentration: either dilution or concentration mode can be selected (default=dilution).

• if dilution mode, the Starting_Dilution_or_concentration will be multiplied by dilution_series at every x value
• else if it is in concentration mode, Starting_Dilution_or_concentration will be divided by dilution_series

dilution_series: can be given in prose (x in x) or as fraction (x/x).
The should be consistent over the whole plate (for version 1, but will aim for additional support for future version).

[TKMarkCheng]

Group	Negative_Control_Column	Positive_Control_Column	Individual_condition	Virus	Plate	Plate_Name	Well	dilution_or_concentration	Starting_Dilution_or_concentration	dilution_series	promega_plate_path	file_creation_date	column
sera	1	2	patient1	Virus1		example1	A3	dilution	10	1 in 3	../Validation/2022-09-04_reads/example1.xlsx	09/04/2022	3

updated final required 14 columns. The group column also be used to assign some other values, like vaccination dose.

[TKMarkCheng]

Addressed in v2.0.0 update

with tutorial and example plate map available