2022-01-02_Carillon Case Report of Asymptomatic Positive Family Pool

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	FLOODLAMP DATA with EXTRA COLUMNS ADDED									EXTRA COLUMNS							CALENDAR INFO from PEOPLE
2	TUBE ID	SPONSOR	PARTICIPANT	MINOR	NOTE	RESULT	COLLECTION DATE	COLLECTION TIME	RESULT DATE	TEST TYPE	TEST MODEL	SYMPTOMS	POOLED	TAT	NOTES		Jan 2nd
3	FLT1134	Jane Doe	Kid1 Doe			Negative	11/28/2021		11/28/2021	Molecular	FloodLAMP QC		1				- FloodLAMP pool samples – Positive result as a household
4	FLY1134	Jane Doe	Kid1 Doe			Negative	11/28/2021		11/28/2021	Molecular	FloodLAMP QC		1				- Abbott Binaxnow Home antigen test – John & Jane, Negative result
5	FLT1134	Jane Doe	Kid2 Doe			Negative	11/28/2021		11/28/2021	Molecular	FloodLAMP QC		1				Jan 3rd
6	FLY1134	Jane Doe	Kid2 Doe			Negative	11/28/2021		11/28/2021	Molecular	FloodLAMP QC		1				FloodLAMP individual samples provided – John & Jane positive, Kid2 Kid1 negative
7	FLT1134	Jane Doe	John Doe			Negative	11/28/2021		11/28/2021	Molecular	FloodLAMP QC		1				- John PCR test taken
8	FLY1134	Jane Doe	John Doe			Negative	11/28/2021		11/28/2021	Molecular	FloodLAMP QC		1
9	FLT1134	Jane Doe	Jane Doe			Negative	11/28/2021		11/28/2021	Molecular	FloodLAMP QC		1				Jan 4th
10	FLY1134	Jane Doe	Jane Doe			Negative	11/28/2021		11/28/2021	Molecular	FloodLAMP QC		1				- Jane PCR test taken
11	FLE484	Jane Doe	Kid1 Doe			Negative	12/6/2021		12/7/2021	Molecular	FloodLAMP QC		1				- John PCR test results – Positive
12	FLE484	Jane Doe	Kid2 Doe			Negative	12/6/2021		12/7/2021	Molecular	FloodLAMP QC		1				- Kid2 & Kid1 home antigen test taken – Positive
13	FLE484	Jane Doe	John Doe			Negative	12/6/2021		12/7/2021	Molecular	FloodLAMP QC		1				Jan 6th
14	FLE484	Jane Doe	Jane Doe			Negative	12/6/2021		12/7/2021	Molecular	FloodLAMP QC		1				- Kid2 PCR test taken
15	FLT1433	Jane Doe	Kid1 Doe			Positive	1/2/2022		1/2/2022	Molecular	FloodLAMP QC		1	2 hours			Jan 7th
16	FLT1433	Jane Doe	Kid2 Doe			Positive	1/2/2022		1/2/2022	Molecular	FloodLAMP QC		1	2 hours			- Kid1 PCR test taken
17	FLT1433	Jane Doe	John Doe			Positive	1/2/2022		1/2/2022	Molecular	FloodLAMP QC		1	2 hours			- Kid2 PCR results – Positive
18	FLT1433	Jane Doe	Jane Doe			Positive	1/2/2022		1/2/2022	Molecular	FloodLAMP QC		1	2 hours			- Jane PCR results – Positive
19	FLT1570	Jane Doe	Kid1 Doe			Negative	1/3/2022		1/3/2022	Molecular	FloodLAMP QC		0	1 hour			Jan 8th
20	FLT14	Jane Doe	Kid2 Doe			Negative	1/3/2022		1/3/2022	Molecular	FloodLAMP QC		0	1 hour			- Kid1 PCR results – Positive
21	FLT1128	Jane Doe	John Doe			Positive	1/3/2022		1/3/2022	Molecular	FloodLAMP QC		0	1 hour			Jan 13th
22	FLE810	Jane Doe	Kid1 Doe			Positive	1/9/2022		1/10/2022	Molecular	FloodLAMP QC		0	2 hours			- Kid2 home antigen test – Mostly negative with a slight second line
23	FLE885	Jane Doe	Kid2 Doe			Positive	1/9/2022		1/10/2022	Molecular	FloodLAMP QC		0	2 hours			Jan 14th
24	FLE895	Jane Doe	John Doe			Positive	1/9/2022		1/10/2022	Molecular	FloodLAMP QC		0	2 hours			- John, Kid2, Kid1, Jane home antigen test – Negative (no slight second line)
25	FLE812	Jane Doe	Jane Doe			Positive	1/9/2022		1/10/2022	Molecular	FloodLAMP QC		0	2 hours			Jan 17th
26	FLB7156	Jane Doe	Kid1 Doe			Positive	1/17/2022		1/17/2022	Molecular	FloodLAMP QC		1	3 hours			- FloodLAMP pool samples dropped off – still detected positive as a household
27	FLB7156	Jane Doe	Jane Doe			Positive	1/17/2022		1/17/2022	Molecular	FloodLAMP QC		1	3 hours
28	FLB7156	Jane Doe	Kid2 Doe			Positive	1/17/2022		1/17/2022	Molecular	FloodLAMP QC		1	3 hours
29	FLB7156	Jane Doe	John Doe			Positive	1/17/2022		1/17/2022	Molecular	FloodLAMP QC		1	3 hours
30
31	NON FLOODLAMP TEST DATA (can be from before or after FloodLAMP test)
32			PARTICIPANT	MINOR	NOTE	RESULT	COLLECTION DATE	COLLECTION TIME	RESULT DATE	TEST TYPE	TEST MODEL	SYMPTOMS	POOLED	TAT	NOTES		DAY SP
33			John Doe			Negative	1/2/2022		1/2/2022	Antigen	BinaXNow	Asym	0	immediate	evening after referral
34			Jane Doe			Negative	1/2/2022		1/2/2022	Antigen	BinaXNow	Asym	0	immediate	evening after referral
35			John Doe			Positive	1/3/2022		1/4/2022	Molecular	PCR Lab		0	1 day
36			Kid2 Doe			Positive	1/4/2022		1/4/2022	Antigen	Unknown	Sympt	0	immediate
37			Kid1 Doe			Positive	1/4/2022		1/4/2022	Antigen	Unknown	Sympt	0	immediate
38			Jane Doe			Positive	1/4/2022		1/7/2022	Molecular	PCR Lab		0	3 days
39			Kid2 Doe			Positive	1/6/2022		1/7/2022	Molecular	PCR Lab		0	1 day
40			Kid1 Doe			Positive	1/7/2022		1/8/2022	Molecular	PCR Lab		0	1 day
41			Kid2 Doe			Positive	1/13/2022		1/13/2022	Antigen	Unknown		0	immediate	slight second line
42			John Doe			Negative	1/14/2022		1/14/2022	Antigen	Unknown		0	immediate
43			Jane Doe			Negative	1/14/2022		1/14/2022	Antigen	Unknown		0	immediate
44			Kid2 Doe			Negative	1/14/2022		1/14/2022	Antigen	Unknown		0	immediate
45			Kid1 Doe			Negative	1/14/2022		1/14/2022	Antigen	Unknown		0	immediate
46
47	COMBINED TEST DATA
48			PARTICIPANT	MINOR	NOTE	RESULT	COLLECTION DATE	COLLECTION TIME	RESULT DATE	TEST TYPE	TEST MODEL		POOLED	TAT	NOTES		DAY SP
49			Kid1 Doe			Positive	1/2/2022		1/2/2022	Molecular	FloodLAMP QC		1	2 hours			0
50			Kid2 Doe			Positive	1/2/2022		1/2/2022	Molecular	FloodLAMP QC		1	2 hours			0
51			John Doe			Positive	1/2/2022		1/2/2022	Molecular	FloodLAMP QC		1	2 hours			0
52			John Doe			Negative	1/2/2022		1/2/2022	Antigen	BinaXNow		0	immediate	evening after referral		0
53			Jane Doe			Positive	1/2/2022		1/2/2022	Molecular	FloodLAMP QC		1	2 hours			0
54			Jane Doe			Negative	1/2/2022		1/2/2022	Antigen	BinaXNow		0	immediate	evening after referral		0
55			Kid1 Doe			Negative	1/3/2022		1/2/2022	Molecular	FloodLAMP QC		0	1 hour			1
56			Kid2 Doe			Negative	1/3/2022		1/3/2022	Molecular	FloodLAMP QC		0	1 hour			1
57			John Doe			Positive	1/3/2022		1/3/2022	Molecular	FloodLAMP QC		0	1 hour			1
58			John Doe			Positive	1/3/2022		1/4/2022	Molecular	PCR Lab		0	1 day			1
59			Jane Doe			Positive	1/4/2022		1/7/2022	Molecular	PCR Lab		0	3 days			2
60			Kid2 Doe			Positive	1/4/2022		1/4/2022	Antigen	Unknown		0	immediate			2
61			Kid1 Doe			Positive	1/4/2022		1/4/2022	Antigen	Unknown		0	immediate			2
62			Kid2 Doe			Positive	1/6/2022		1/7/2022	Molecular	PCR Lab		0	1 day			4
63			Kid1 Doe			Positive	1/7/2022		1/8/2022	Molecular	PCR Lab		0	1 day			5
64			Kid1 Doe			Positive	1/9/2022		1/10/2022	Molecular	FloodLAMP QC		0	2 hours			7
65			Kid2 Doe			Positive	1/9/2022		1/10/2022	Molecular	FloodLAMP QC		0	2 hours			7
66			John Doe			Positive	1/9/2022		1/10/2022	Molecular	FloodLAMP QC		0	2 hours			7
67			Jane Doe			Positive	1/9/2022		1/10/2022	Molecular	FloodLAMP QC		0	2 hours			7
68			Kid2 Doe			Positive	1/13/2022		1/13/2022	Antigen	Unknown		0	immediate	slight second line		11
69			Kid1 Doe			Negative	1/14/2022		1/14/2022	Antigen	Unknown		0	immediate			12
70			Kid2 Doe			Negative	1/14/2022		1/14/2022	Antigen	Unknown		0	immediate			12
71			John Doe			Negative	1/14/2022		1/14/2022	Antigen	Unknown		0	immediate			12
72			Jane Doe			Negative	1/14/2022		1/14/2022	Antigen	Unknown		0	immediate			12
73			Kid1 Doe			Positive	1/17/2022		1/17/2022	Molecular	FloodLAMP QC		1	3 hours			15
74			Kid2 Doe			Positive	1/17/2022		1/17/2022	Molecular	FloodLAMP QC		1	3 hours			15
75			John Doe			Positive	1/17/2022		1/17/2022	Molecular	FloodLAMP QC		1	3 hours			15
76			Jane Doe			Positive	1/17/2022		1/17/2022	Molecular	FloodLAMP QC		1	3 hours			15
77
78	TABLE VIEW for FAMILY
79				1/2/2022	1/3/2022	1/4/2022	1/6/2022		1/7/2022	1/8/2022	1/9/2022		1/10/2022	1/13/2022	1/14/2022	1/17/2022
80				0	1	2	4		5	6	7		8	11	12	15
81			Family Pool	POS FloodLAMP												POS FloodLAMP
82		Jane Doe	Parent 1	Asymptomatic
83				POS FloodLAMP (Family Pool)	POS FloodLAMP (Indiv)						POS FloodLAMP (Indiv)		> POS FL Result			POS FloodLAMP (Family Pool)
84				NEG Antigen											NEG Antigen
85						POS PCR Lab >	> > > > >		> POS PCR Result
86		John Doe	Parent 2	Asymptomatic		Symptoms
87				POS FloodLAMP (Family Pool)	POS FloodLAMP						POS FloodLAMP (Indiv)		> POS FL Result			POS FloodLAMP (Family Pool)
88				NEG Antigen											NEG Antigen
89					POS PCR Lab >	> POS PCR Result
90		Kid1 Doe	Child 1	Asymptomatic		Symptoms	Asymptomatic
91				POS FloodLAMP (Family Pool)	NEG FloodLAMP						POS FloodLAMP (Indiv)		> POS FL Result			POS FloodLAMP (Family Pool)
92						POS Antigen									NEG Antigen
93									POS PCR Lab >	> POS PCR Result
94		Kid2 Doe	Child 2	Asymptomatic		Symptoms	Asymptomatic
95				POS FloodLAMP (Family Pool)	NEG FloodLAMP						POS FloodLAMP (Indiv)		> POS FL Result			POS FloodLAMP (Family Pool)
96						POS Antigen								POS Antigen (slight)	NEG Antigen
97							POS PCR Lab >		> POS PCR Result
98
99
100