> <; Fɀ\pMike Ba==h<L,8X@"1Arial1Arial1Arial1Arial1Arial1
Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)0.0
#\ ???/???0.000000000
0.00000000 0.0000000
0.0000000.000000.0000
0.000 mmm\-yyyy + ) , * # @ #P "
8@ @ 8@ @
0@ @ 0@ @ @ @ ! 0@ @ 8@ @ (@ @ 0@ @ 0@ @
0 P `97 well tray w ColilertU?cheat sheetKHardcopy lab data sheet ;T Sample IDPositive LG yellowPositive SM yellowMPN Total Coliform in trayMPN Total coliform in samplePositive fluor LGPositive fluor SMMPN E.coli in trayMPN E.coli in sample>95% LCI in tray95% UCI in traycode95% LCI in Sample95% UCI in SampleExamples
Field NameContent SequencerLSR172; DB30-3dupResult Unit MPN/100mlColumnABCDEFGHIJKLMNOPQRSTUResult unit}Lower 95% confidence interval for the concentration in column E; a number derived from an additional table provided by IDEXX }Upper 95% confidence interval for the concentration in column E; a number derived from an additional table provided by IDEXX 2A symbol to attach to Result if it is out of rangeIdentical to column F if the original sample was poured into the quantitray (I.e., it was not diluted); if the sample was diluted this cell has the Result in F multiplied by the dilution factor.Identical to column G if the original sample was poured into the quantitray (I.e., it was not diluted); if the sample was diluted this cell has the Result in G multiplied by the dilution factor.tThe concentration of E. coli in the water poured into the quantitray; a number derived from the IDEXX lookup table }Lower 95% confidence interval for the concentration in column N; a number derived from an additional table provided by IDEXX }Upper 95% confidence interval for the concentration in column N; a number derived from an additional table provided by IDEXX Identical to column N if the original sample was poured into the quantitray (i.e., it was not diluted); if the sample was diluted this cell has the Result in N multiplied by the dilution factor.Identical to column O if the original sample was poured into the quantitray (I.e., it was not diluted); if the sample was diluted this cell has the Result in O multiplied by the dilution factor.Identical to column P if the original sample was poured into the quantitray (I.e., it was not diluted); if the sample was diluted this cell has the Result in P multiplied by the dilution factor.The unit of measurement Unique identifier of a container collected in the field (dup stands for field duplicate, which is an independent container filled out at the same time and place as the regular sample). {The concentration of total Coliform in the water poured into the QuantiTray; a number derived from the IDEXX lookup table MPN Total Coliform in sampleIdentical to column E if the original sample was poured into the QuantiTray (i.e., it was not diluted); if the sample was diluted this cell has the Result in E multiplied by the dilution factor.MPN E. coli in trayMPN E. coli in sampleHA number showing the place of this record within the order of data entryYNumber of large wells that had a yellow color (positive for total Coliform) - your countsNYnumber of small wells that had a yellow color (positive for total Coliform) - your countsNoNumber of small wells that had fluorescence when illuminated with UV lamp (positive for E. coli) - your countsaoNumber of large wells that had fluorescence when illuminated with UV lamp (positive for E. coli) - your countsarecord #CommentsNumber of yellow Large wellsNumber of yellow Small wells!Number of fluorescent Large wells!Number of fluorescent Small wellsProject ID ___________&Setup Date and Time __________________Page ___ of ___Operator ___________________4Checked by: _________________ Date ______________Run ID_________Reading date and time _________T13CTime CollectedDate CollectedSet up TimeReading DateReading TimeSet up DateDilution FactorT5C12:15PM11:00PM11:45PMMPN/100Martin1:50PM
Trip Blank2:30PM1:15PM<1<1002:25PMGrotzman Rep1:00PMGrotzman Dup12:30PMT13N1:35PMT13E3:10PMGrotzman1:30PM12:50PMT13O1:40PM12:45PM$1 empty number of yellow large wellsT13O DupT13B2:50PM3:40PM2:35PM12:35PM11:45AMleaky whirl pakT13F
unlabelled2:58PMCooper Gulch 14th St
7Yy(A}3;
C*fw2n
Fɀ!:>>
dMbP?_*+%M^Lexmark Z52 Series ColorFinehX⤗Lexmark Z52 Series ColorFine8⤗RL⤗"dXX??U}m
}I}
}
}$}}
I}
}}}}I}}}$}}}
Sample IDTime Collected!
0
S
R
W
T
U
V
X
E~
:@
3~
2@
3{~
2@
[~
2@
[3H@3H@3a@
~
3`@3G@32@3@~
@
.]~
Y@
|~
@
3~
2@
3i~
2@
[~
2@
\3H@3G@3O@
~
3O@3G@31@3@~
@
.]~
Y@~
*@
3~
2@
3p~
2@
[~
2@
\3H@3H@3a@
~
3`@3G@3.@3@~
@
.]~
Y@~
9@
3n~
2@
3g~
2@
[~
2@
[3H@3G@3s@
~
3s@3H@3:@3A@~
@@
.]~
Y@~
(@
3n~
2@
3o~
2@
[~
2@
\3H@3H@3a@
~
3`@3F@3,@3@~
@
.]~
Y@~
&@
3n~
2@
3i~
2@
[~
2@
\3H@3H@3a@
~
3`@3H@3=@3z@~
P@
.]~
Y@~
@
3h~
2@
3g~
2@
[~
2@
\3H@3H@3a@
~
3`@3H@31@3C@~
C@
.]~
Y@~
@
f~
2@
g~
2@
[~
2@
\H@F@A@
~
A@H@2@N@~
N@
.]~
Y@~
@
^~
2@
_~
2@
[~
2@
\ H@G@s@
~
s@ B@@t@~
t@
.]~
Y@~
@
^~
2@
e~
2@
[~
2@
\
H@C@@
~
@
<@@@~
@
.]~
Y@~
=@
3^~
2@
3~
2@
[~
2@
[3H@3F@3A@
~
3A@38@3@3@@~
@@
.]~
Y@~
7@
3v~
2@
3z~
2@
[~
2@
[3H@3E@3@
~
3R@3G@3$@3c@~
c@
.]~
Y@~
3@
3v~
2@
3w~
2@
[~
2@
[
3H@3D@3!@
~
3 @
3G@36@30o@~
]@
.]~
Y@~
?
Q~
2@
Z~
2@
[~
2@
\H@4@@
~
@
&@@~
@
.]~
-y@,~
?@
3Q~
2@
3Z~
2@
[~
2@
[3H@3E@3@
~
3R@3@@3@3Z@~
Z@
.]~
Y@~
>@
3Q~
2@
3a~
2@
[~
2@
[3H@3F@3A@
~
3A@3;@3@3^@~
^@
.]~
Y@~
8@
3l~
2@
3g~
2@
[~
2@
[3H@3G@3O@
~
3O@3B@3@3r@~
r@
.]~
Y@~
$@
3l~
2@
3m~
2@
[~
2@
\3H@3H@3a@
~
3`@3E@3@3W@~
@
.]~
Y@~
;@
3}~
2@
3b~
2@
[~
2@
[3H@3B@3̂@
~
3^@3"@3@3&@~
0@
.]~
Y@~
<@
3}~
2@
3~~
2@
[~
2@
[3H@3C@3A@
~
3@@3 @33@~
@
.]~
Y@~
"@
3j~
2@
3k~
2@
[~
2@
\3H@3E@3@
~
3q@3G@3@3_@~
8@
.]~
Y@~
5@
3j~
2@
3x~
2@
[~
2@
[3H@3G@3O@
~
3O@3G@3&@3b@~
@
.]~
Y@~
.@
3q~
2@
3r~
2@
[~
2@
\3H@3H@3a@
~
3`@3C@3@3@U@~
@
.]~
Y@~
4@
3q~
2@
3r~
2@
[~
2@
[3H@3A@3@
~
3 A3 @33@~
@
.]~
y@~
,@
3q~
2@
3p~
2@
[~
2@
\3H@3G@3s@
~
3s@3A@3 @3>@~
>@
.]~
Y@~
2@
3u~
2@
3r~
2@
[~
2@
[3H@3D@3!@
~
3 @3>@3?3F@~
Ʊ@
.]~
Y@~
@
/Y~
2@
/b~
2@
[~
2@
\/H@/H@/a@
///
~
/`@
///G@/"@/@///~
/@/
.]~
1Y@~
1@
3Y~
2@
3Z~
2@
[~
2@
[3G@3G@3!>@
~
3 >@3G@3>@3@~
@
.]~
Y@
t~
0@
3Y~
2@
3s~
2@
[~
2@
\3H@3H@3a@
~
3`@3H@3C@3A@~
@@
.]~
Y@~
@
`~
2@
a~
2@
[~
2@
\
c
d
.]~
6@
3`~
2@
y~
2@
[~
2@
[33
3333
c
d
.]~
Y@Dl
>>@A
@7 qq?
FɀyD_K
dMbP?_*+%MdHP LaserJet1574q?XX",HP LaserJet 4050 Series PCL 6.\
ƣQp1Pf0BTH|DsE 15
eV+.d҈Dr6KR9k)JD2
)\z]Mtٽr7URW¥ӪD*LFsujUN}JV1 1TqnMZ7n738gpE3(qܲIXm^sNh4{lݛeάClUƷ̈3e'oC1d:~ViӇ;v}ՂsHJ!cJ~^'q
AשYJHY 8t!s iGtڇ0)& R
_YxȺ9\cաAti
at Az
*
^de0ՃX"GP5wC?kQHZ9iJ*eM`|
d)JyN)E-6Yw#t)^7wB[z7*,
BpmI>Eifpn)*
,ڎ'e5`jmH@ËJ`k"g'M+WdIqn|/[\H)KѻAfBr^р9_W6Xi2'R2_ʆNzb2DXql9J|g4цYFdVG}yr@"dXX??U}m }m}0}$
(
)
"
!
'
$
$?~
#@
'
$
$9
#
'
$
$@~
#H@
'
$
$A~
#H@
(
"
$:~
#
A
'
*
$-#
'
*
$.#
'
+
$/
#
'
$;
$<
#
A Dd
'
*
$0#
'!
*
$1#
'"
$
$B~
#H@
'#
$
$C~
#F@
($
"=
$2~
#YA
'%
*
$3#
'&
*
$4#
''
+
$/#
'(
$>
$5#XA
Dd
')
*
$6#
'*
*
$7#
'+
*,
$8
#0888888448M44888444M44>@7
FɀO U
dMbP?_*+%)?M6Auto HP OfficeJet K60 on FORESTXC
odXXLetterDINU"4$$$$$"dXX??U} }}}}}}Column AX@@ @
@@@
@@@@@@@
&J
&K
P
O
L
!D
"
"F
"G
"E
"H
"I
"E!"""""""~
'?$$$$$$$~
'@$$$$$$$~
'@%%%%%%%~
'@%%%%%%%~
'@ %%%%%%%~
'@
%%%%%%%~
'@%%%%%%%~
' @%%%%%%%~
'"@
%%%%%%%~
'$@%%%%%%%~
'&@%%%%%%%~
'(@%%%%%%%~
'*@%%%%%%%~
',@%%%%%%%~
'.@%%%%%%%
&M
N*hFp&&&&&&&&&&&&&&&>@A
@7
Oh+'0HPl|
Revital KatznelsonMikeal Microsoft Excel@kv@+ov@2՜.+,D՜.+,D PXlt|
SFBRWQCBlA
97 well tray w Colilertcheat sheetHardcopy lab data sheet'cheat sheet'!Print_TitlesWorksheets
Named Ranges8_AdHocReviewCycleID_EmailSubject
_AuthorEmail_AuthorEmailDisplayName,Dspreadsheetmike@ccwi.orgsp
Mike Sandlersp
!"#$%&'()*,-./012456789:Root Entry FWorkbookUSummaryInformation(+DocumentSummaryInformation83