Rangewide OA-Larvae and Eggs-Summer 2016

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO	CP	CQ	CR	CS	CT	CU	CV
1	Date started	ID	H1 or H2	Population	Tote/Bucket	Live/mL	Dead/mL	# Added	Notes	Dumped	Tile added	7/5/2016_Live	7/5/2016_Dead	7/5/2016_Survival	7/8/2016_Live	7/8/2016_Dead	7/8/2016_Survival	7/12/2016_Live	7/12/2016_Dead	7/12/2016_Survival	7/13/2016_Live	7/13/2016_Dead	7/13/2016_Survival	7/15/2016_Live	7/15/2016_Dead	7/15/2016_Survival	7/18/2016_Live	7/18/2016_Dead	7/18/2016_Survival	7/19/2016_Live	7/19/2016_Dead	7/19/2016_Survival	7/20/2016_Live	7/20/2016_Dead	7/20/2016_Survival	7/22/2016_Live	7/22/2016_Dead	7/22/2016_Survival	7/25/2016_Live	7/25/2016_Dead	7/25/2016_Survival	7/26/2016_Live	7/26/2016_Dead	7/26/2016_Survival	7/27/2016_Live	7/27/2016_Dead	7/27/2016_Survival	7/28/2016_Live	7/28/2016_Dead	7/28/2016_Survival	7/29/2016_Live	7/29/2016_Dead	7/29/2016_Survival	8/1/2016_Live	8/1/2016_Dead	8/1/2016_Survival	8/2/2016_Live	8/2/2016_Dead	8/2/2016_Survival	8/3/2016_Live	8/3/2016_Dead	8/3/2016_Survival	8/4/2016_Live	8/4/2016_Dead	8/4/2016_Survival	8/5/2016_Live	8/5/2016_Dead	8/5/2016_Survival	8/7/2016_Live	8/7/2016_Dead	8/7/2016_Survival	8/8/2016_Live	8/8/2016_Dead	8/8/2016_Survival	8/9/2016_Live	8/9/2016_Dead	8/9/2016_Survival	8/10/2016_Live	8/10/2016_Dead	8/10/2016_Survival	8/11/2016_Live	8/11/2016_Dead	8/11/2016_Survival	8/12/2016_Live	8/12/2016_Dead	8/12/2016_Survival	8/14/2016_Live	8/14/2016_Dead	8/14/2016_Survival	8/15/2016_Live	8/15/2016_Dead	8/15/2016_Survival	8/16/2016_Live	8/16/2016_Dead	8/16/2016_Survival	8/17/2016_Live	8/17/2016_Dead	8/17/2016_Survival	8/18/2016_Live	8/18/2016_Dead

2	7/1/2016	A60	H1	BC	BC1_T			10000		7/26/2016		12266.67	5866.67	0.6765	250.00	750.00	0.2500	1050.00	2100.00	0.3333																						250.00	750.00	0.25
3	7/1/2016	A61	H1	BC	BC1_T			10000	dumped			0.00	266.40	0.0000
4	7/1/2016	A62	H1	BC	BC1_T			10000	dumped 7/28	7/28/2016		14133.33	5333.33	0.7260	5618.75	4262.50	0.5686	2975.00	525.00	0.8500
5	7/1/2016	A63	H1	BC	BC3_T			10000		7/28/2016		7200.00	3200.00	0.6923	7218.75	3093.75	0.7000	2625.00	8750.00	0.2308																												750.00	3875.00	0.1621621622
6	7/1/2016	A64	H1	BC	BC3_T			10000		7/12/2016		8800.00	5066.67	0.6346	1000.00	600.00	0.6250	175.00	350.00	0.3333
7	7/1/2016	A65	H1	BC	BC3_T			10000	dumped?			800.00	1333.33	0.3750
8	7/1/2016	A66	H1	BC	BC2_T			10000		7/26/2016		6666.67	1600.00	0.8065	5800.00	2000.00	0.7436	7740.00	3960.00	0.6615																						625.00	5500.00	0.1020408163
9	7/1/2016	A67	H1	BC	BC2_T			10000		7/18/2016		6933.33	1866.67	0.7879	6800.00	2600.00	0.7234	4725.00	2100.00	0.6923							3150	2850	0.525
10	7/1/2016	A68	H1	BC	BC2_T			10000		7/28/2016		8266.67	2666.67	0.7561	6000.00	4000.00	0.6000	6300.00	2800.00	0.6923																												2500.00	2750.00	0.4761904762
11	7/1/2016	B60	H2	BC	BC2_T			10000		7/18/2016		9066.67	1066.67	0.8947	5000.00	800.00	0.8621	8910.00	1890.00	0.8250							4000	1600	0.7142857143
12	7/1/2016	B68	H2	BC	BC1_T			10000		7/22/2016		6600.00	550.00	0.9231	9400.00	4000.00	0.7015	2800.00	0.00	1.0000																918.75	525.00	0.6363636364
13	7/1/2016	B72	H2	BC	BC2_T			10000		7/28/2016		4800.00	2133.33	0.6923	6277.50	1000.00	0.8626	5833.33	700.00	0.8929																												405.00	6210.00	0.0612244898
14	7/1/2016	B79	H2	BC	BC1_T			10000		7/22/2016		6400.00	1333.33	0.8276	10106.25	2475.00	0.8033	6390.00	0.00	1.0000																1250.00	2000.00	0.3846153846
15	7/1/2016	B81	H2	BC	BC1_T			10000		7/22/2016		7733.33	4000.00	0.6591	12250.00	4250.00	0.7424	11902.50	3795.00	0.7582																4500.00	2875.00	0.6101694915
16	7/1/2016	B83a	H2	BC	BC3_T			10000	Dumped out day 11			5600.00	5333.33	0.5122	0.00	0.00	0.0000	0.00	0.00	0.0000
17	7/1/2016	B86a	H2	BC	BC3_T			10000		7/5/2016		0.00	0.00	0.0000				8575.00	1400.00	0.8596
18	7/1/2016	B89a	H2	BC	BC2_T			10000		7/12/2016		11825.00	550.00	0.9556	800.00	400.00	0.6667	0.00	0.00	0.0000
19	7/1/2016	B90a	H2	BC	BC3_T			10000		7/5/2016		0.00	0.00	0.0000
20	7/7/2016	A2	H1	BC	BC1_T			10000		7/18/2016					7218.75	5362.50					3000.00	11,100.00	0.21				168.75	0	1.00
21	7/7/2016	A3	H1	BC	BC1_T			10000		7/13/2016					15500.00	6000.00					150.00	600.00	0.20
22	7/7/2016	B78	H2	BC	BC1_T			10000		7/20/2016					11412.50	4772.50		4000.00	7750.00	0.3404													166.6666667	18000	0.01
23	7/7/2016	B88	H2	BC	BC1_T			10000		7/18/2016					8000.00	4800.00		1866.67	9100.00	0.1702							750	10200	0.07
24	7/8/2016	A69	H1	BC	BC2_T			10000	15 worms 8/3, D17 on D26												8845.00	1,015.00	0.90							7920	2280	0.78																												3162.5	1787.5	0.6388888889																1000.0000	3200.0000	0.2381
25	7/8/2016	A70	H1	BC	BC2_T			10000	D17 8/3, 1 worm/ml 8/3												10350.00	600.00	0.95							6250	3375	0.65																												3125	3625	0.462962963
26	7/8/2016	A77	H1	BC	BC1_T			10000		7/13/2016											300.00	11,700.00	0.03
27	7/8/2016	A78	H1	BC	BC1_T			10000	dumped												600.00	6,450.00	0.09
28	7/8/2016	A98	H1	BC	BC5_B			10000		7/28/2016																				5100	3825	0.57																2175.00	5800.00	0.2727272727
29	7/8/2016	A99	H1	BC	BC5_B			10000		7/28/2016																				8085	3430	0.70																		#DIV/0!
30	7/8/2016	B82	H2	BC	BC5_B			10000		7/28/2016											8937.50	975.00	0.90							6187.5	1575	0.80																		#DIV/0!
31	7/8/2016	B85	H2	BC	BC1_T			10000	dumped												0.00	13,000.00	0.00									#DIV/0!																		#DIV/0!
32	7/8/2016	B86b	H2	BC	BC2_T			10000													7680.00	1,600.00	0.83							8212.5	2137.5	0.79																		#DIV/0!										4107.5	2517.5	0.62
33	7/8/2016	B90b	H2	BC	BC2_T			10000	sample for 7/13 and 7/11, D17 8/3, dump									8750.00	700.00	0.9259	7950.00	1,800.00	0.82							6110	705	0.90																		#DIV/0!										2640	1375	0.6575342466																			1440.0000	4800.0000	0.2308
34	7/8/2016	B92	H2	BC	BC1_T			10000		7/13/2016											600.00	12450.00	0.05									#DIV/0!																		#DIV/0!
35	7/8/2016	B93	H2	BC	BC5_B			10000		7/28/2016											10562.50	1137.50	0.90							10368.75	2231.25	0.82																2082.50	6370.00	0.2463768116
36	7/10/2016	A4	H1	BC	BC2_T			10000		7/15/2016														7/15/2016
37	7/10/2016	A5	H1	BC	BC2_T			10000		7/15/2016														7/15/2016
38	7/10/2016	A6	H1	BC	BC2_T			10000		7/28/2016
39	7/10/2016	B73	H2	BC	BC2_T			10000		7/15/2016														7/15/2016
40	7/10/2016	B75	H2	BC	BC2_T			10000		7/20/2016																							1750	17625	0.09
41	7/10/2016	B87	H2	BC	BC2_T			10000		7/15/2016														7/15/2016
42	7/11/2016	A100	H1	BC	BC1_T			10000		7/18/2016														3,400.00	3200.00	0.52																						1650	2100	0.44
43	7/11/2016	A12	H1	OR	OR2_T			10000		7/15/2016														0		0.00
44	7/11/2016	A13	H1	OR	OR2_T			10000		7/15/2016														150.00	150.00	0.50
45	7/11/2016	A97	H1	BC	BC1_T			10000	5 worms 7/28	7/28/2016																																						1000	9125	0.0987654321
46	7/11/2016	B51	H2	BC	BC1_T			10000	left in silo over 2 nights 7/24	7/28/2016																										2625	2625	0.50										625	7625	0.07575757576
47	7/11/2016	B66	H2	OR	OR2_T			10000	mightve flooded 7/25, 1 worm 7/28	7/28/2016																																						125	10750	0.01149425287
48	7/11/2016	B80	H2	OR	OR2_T			10000		7/28/2016
49	7/11/2016	B84	H2	BC	BC1_T			10000		7/18/2016																	5850	3150	0.65
50	7/12/2016	A7	H1	BC	BC2_T			10000	Lefit in bucket overnight, 2 worms/ml 8/3	8/3/2016																				4125	4000	0.5076923077																												575.00	6600.00	0.08013937282
51	7/12/2016	A8	H1	BC	BC2_T			10000	Left in bucket overnight, 3 worms/ml 8/3	8/3/2016																				3000	5750	0.3428571429																												0.00	9625.00	0
52	7/12/2016	B77	H2	BC	BC2_T			10000	Lefit in bucket overnight	8/3/2016																				5625	5250	0.5172413793																												0.00	10375.00	0
53	7/12/2016	B97	H2	BC	BC2_T			10000	Left in bucket overnight, .25 worms/ml 8/3	8/3/2016																				4000	3625	0.5245901639																												0.00	10250.00	0
54	7/13/2016	A93	H1	BC	BC2_T			10000	sean 7/20, .5 woms/ml 8/3	8/3/2016																							2625	14250	0.1555555556				2125	21375	0.09																			0.00	3250.00	0
55	7/13/2016	A94	H1	BC	BC2_T			10000	sean 7/20, dump 7/20?, mislabel?																								125	0	1				6247.5	980	0.86																					#DIV/0!
56	7/13/2016	B57	H2	BC	BC2_T			10000	sean 7/20	8/3/2016																							3250	5500	0.3714285714				1500	9250	0.14																			255.00	7522.50	0.03278688525
57	7/13/2016	B71	H2	BC	BC2_T			10000	sean 7/20, D11 7/25 morning	8/4/2016																							625	5500	0.1020408163				1080	8520	0.11																						525.00	7743.75	0.06349206349
58	7/15/2016	A1	H1	OR	OR1_T																												8375.00	500.00	0.94							9375	1125	0.89																6750	2750	0.7105263158																2800	4200	0.4000
59	7/15/2016	A10	H1	OR	OR1_T						8/3/2016																						13625.00	875.00	0.94							9775	980	0.91																6825	2125	0.7625698324																4500	6666.666667	0.4030
60	7/15/2016	B83b	H2	OR	OR1_T				D17 8/3, dumpex																								6750.00	500.00	0.93							3062.5	3797.5	0.45																875	3375	0.2058823529																145	3480	0.0400
61	7/15/2016	B89b	H2	OR	OR1_T				dump																								10250.00	250.00	0.98							3500	4750	0.42																1625	7125	0.1857142857																125	6625	0.0185
62	7/17/2016	A89	H1	CA	CA4_B			10000		7/29/2016																										7595.00	1347.50	0.85										0	0	0.00												#DIV/0!
63	7/17/2016	A90	H1	CA	CA4_B			10000	D11 7/29 morning	8/17/2016	8/3/2016																									7125.00	1500.00	0.83										1200	7350	0.14										1375	4750	0.2244897959																																		250.00	2250.00	0.10
64	7/17/2016	A91	H1	OR	OR5_B			10000	D11 7/29 morning, dump	8/11/2016	8/3/2016																									8481.25	287.50	0.97										8531.25	1706.25	0.83										6956.25	1312.5	0.8412698413																			2500.0000	3500.0000	0.4167
65	7/17/2016	A92	H1	OR	OR5_B			10000	D11 7/29 morning		8/3/2016																									8760.00	720.00	0.92										7800	812.5	0.91										6345	656.25	0.9062667381																			4147.5000	5925.0000	0.4118
66	7/17/2016	B52	H2	CA	CA4_B			10000	D11 7/29 morning, 8/15 count out long time	8/15/2016	8/3/2016																									4532.50	857.50	0.84										4625	3125	0.60										525	3675	0.125																					#DIV/0!							0.00	356.25	0
67	7/17/2016	B54	H2	OR	OR5_B			10000	D11 7/29 morning, mightve flooded 7/25, D17 8/5, tile added, added swimmers 8/15																											9843.75	262.50	0.97										3562.5	3681.25	0.49																1375	7875	0.1486486486															#DIV/0!							750	675	0.5263157895
68	7/17/2016	B58	H2	OR	OR5_B			10000	mightve flooded 7/25, D11 7/29 morning																											11515.00	490.00	0.96										8875	875	0.91										4200	4200	0.5																			693.3333	4680.0000	0.1290
69	7/17/2016	B64	H2	CA	CA4_B			10000	D11 7/29 morning, 1 worm 7/28	8/11/2016	8/3/2016																									9000.00	1750.00	0.84										4080	4560	0.47										1875	6625	0.2205882353																			690.0000	4715.0000	0.1277
70	7/18/2016	A87	H1	BC	BC3_T					8/14/2016																													9125	1875	0.8295454545										8207.5	2082.5	0.80																														#DIV/0!				0.00	2625.00	0.0000
71	7/18/2016	A88	H1	BC	BC3_T					7/28/2016																													240	120	0.6666666667							287.5	0	1.00																																	#DIV/0!
72	7/18/2016	B56	H2	BC	BC3_T					7/25/2016																													0	0	0																																										#DIV/0!
73	7/18/2016	B98	H2	BC	BC3_T					8/15/2016																													10080	1440	0.875										7000	2125	0.77																														#DIV/0!
74	7/22/2016	A83	H1	CA	CA2_T																																								9000.00	1000.00	0.90																5087.5	1210	0.81																4375.0000	2875.0000	0.6034
75	7/22/2016	A84	H1	CA	CA2_T				D11 8/4	8/11/2016																																			7287.50	662.50	0.92																7500	3250	0.70																1410.0000	8695.0000	0.1395
76	7/22/2016	A85	H1	OR	OR2_T					8/14/2016																																			8250.00	375.00	0.96																5700	450	0.93																		#DIV/0!				2018.75	2137.50	0.4857
77	7/22/2016	A86	H1	OR	OR2_T						8/14/2016																																		9900.00	450.00	0.96																7000	875	0.89																		#DIV/0!				3250.00	3443.75	0.4855
78	7/22/2016	B59	H2	CA	CA2_T					8/11/2016																																			9750.00	1375.00	0.88																4080	3060	0.57																1125.0000	5625.0000	0.1667						#DIV/0!
79	7/22/2016	B61	H2	CA	CA2_T																																								8400.00	140.00	0.98																2915	3710	0.44																1000.0000	5500.0000	0.1538						#DIV/0!
80	7/22/2016	B63	H2	OR	OR2_T					8/11/2016																																			7950.00	750.00	0.91																7743.75	918.75	0.89																1500.0000	4250.0000	0.2609						#DIV/0!
81	7/22/2016	B65	H2	OR	OR2_T					8/14/2016																																			6562.50	393.75	0.94																7000	1500	0.82																		#DIV/0!				225.00	5512.50	0.0392
82	7/25/2016	A79	H1	BC	BC1_T					8/14/2016																																												4920	3360	0.5942028986										2250	2375	0.49																			250.00	3250.00	0.0714
83	7/25/2016	A80	H1	BC	BC1_T					8/16/2016																																												7750	625	0.9253731343										6375	750	0.89																					#DIV/0!				1493.33	5973.33	0.2
84	7/25/2016	A81	H1		OR1_T					8/14/2016																																												9750	500	0.9512195122										6325	962.5	0.87																			2082.50	6125.00	0.2537
85	7/25/2016	A82	H1		OR1_T						8/14/2016																																											7080	590	0.9230769231										4995	405	0.93																			3240.00	2970.00	0.5217
86	7/25/2016	B104	H2		OR1_T					8/12/2016																																												6187.5	412.5	0.9375										6630	875	0.88																1000.0000	6166.6667	0.1395			#DIV/0!
87	7/25/2016	B106	H2		OR1_T				8/15 count out since 8/11	8/15/2016																																												7350	0	1										5375	1125	0.83																		#DIV/0!			#DIV/0!	0.00	4945.00	0
88	7/25/2016	B14	H2		BC1_T				dumped																																													6450	600	0.914893617										4625	1750	0.73																		#DIV/0!			#DIV/0!
89	7/25/2016	B25	H2		BC1_T					8/12/2016																																												5750	250	0.9583333333										4875	1875	0.72																1000.0000	6125.0000	0.1404			#DIV/0!
90	7/26/2016	A101	H1	CA	CA1_T			10000		8/14/2016																																															8540	915	0.9032258065																											#DIV/0!	3206.25	6650.00	0.3253
91	7/26/2016	A74	H1	CA	CA1_T			20000	ounted 8/3	7/28/2016																																						10462.50	2025.00	0.8378378378									#DIV/0!																											#DIV/0!			#DIV/0!
92	7/26/2016	A75	H1	CA	CA1_T			10000		8/14/2016																																															8820	152.5	0.9830036222																											#DIV/0!	1760.00	7150.00	0.1975
93	7/26/2016	A76	H1	BC	BC23_T			Eggs																																																																														#DIV/0!			#DIV/0!
94	7/26/2016	B09	H2	CA	CA1_T			20000		7/28/2016																																																																												#DIV/0!			#DIV/0!
95	7/26/2016	B102	H2	BC	BC23_T			Eggs																																																																														#DIV/0!			#DIV/0!
96	7/26/2016	B21	H2	CA	CA1_T			10000		8/12/2016																																															8370	305	0.9648414986																									875.0000	5375.0000	0.1400			#DIV/0!
97	7/26/2016	B27	H2	CA	CA1_T			10000		8/12/2016																																															7950	152.5	0.9811786486																									2250.0000	3875.0000	0.3673			#DIV/0!
98	7/27/2016	A53	H1	BC	BC23_T			15000		8/16/2016																																												14000.00	1000.00	0.93													10730	1305	0.89																		#DIV/0!				1750	7250	0.1944444444
99	7/27/2016	A54	H1	BC	BC23_T			15000		8/17/2016																																												11375.00	1000.00	0.92													9432.5	2327.5	0.80																		#DIV/0!							4125.00	5250.00	0.44
100	7/27/2016	A55	H1	CA	CA2_T			15000	D17 on D20	8/22/2016	8/17/2016																																											9375.00	1000.00	0.90													9315	2295	0.80																		#DIV/0!							4000	6000	0.40