Spreadsheet: 736616d1623767163-auto-populate-cells-based-on-drop-down-list-selection-test-36-ans
Sheet: test

 | SAMPLE NUMBERS | ADDITIONAL INFORMATION | ANALYTES & SAMPLE #'S
 | SAMPLE NUMBERS |  |  |  |  |  |  |  |  | ADDITIONAL INFORMATION |  |  |  |  |  |  |  |  |  |  |  |  | ANALYTES & NUMBERS
 |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  |  | COD (8000) | ISE | 8190 | 10205 | 10210 | pH | E. coli | [NAME] | TN | NO3 | TKN |  | MONDAY | Sample Location: | Sample Type: | Sample ID: | Collection Time: | Volume (L) | Temp (C) | [NAME] | Analytes: | [NAME]?
 |  | 2021-06-13 00:00:00 |  |  |  |  |  |  |  | Sample Analysis Date |  |  |  |  |  |  |  |  |  |  |  |  |  | Influent-24HC: | 24-HC |  |  |  |  |  | TSS, NH3 | Ditches:
 | Influent |  |  |  |  |  |  |  |  | Analyst Initials | NJC | NJC | NJC | NJC | NJC | NJC | NJC | NJC | NJC | NJC | NJC |  |  | Effluent-24HC: | 24-HC |  |  |  |  |  | TSS, NH3 | Yes | Yes
 | Effluent |  |  |  |  |  |  |  |  | Qualifier |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTE: | Jug volume should be at least 9.6 L. |  | Check samplers if jug volume is below 9 L. |  |  |  |  |  | No
 | pH |  |  |  |  |  |  |  |  | [NAME] | Hach 8000 | SM 4500NH3 D-2011 | Hach 8190 | Hach 10205 | Hach 10210 | SM 4500H+ B-2011 | Colilert-18 | Colilert-18 | Hach 10206 + 10242 | Hach 10206 | Hach 10242 |  |  | Effluent Grab (pH): | Grab |  |  |  |  |  |  | Bridges:
 | E.coli |  |  |  |  |  |  |  |  | MRL |  | 0.1 | 0.25 | 0.04 | 0.25 |  | 1 | 1 | 1.2 | 0.6 | 0.6 |  |  | Effluent Grab (E. coli): | Grab
 | Ditch 1 |  |  |  |  |  |  |  |  |  | TSS | CBOD | MLSS | MLVSS | Settleability | SVI | Volatile | Cake & Sludge |  |  |  |  |  | Clarifer 3: | Grab
 | Ditch 2 |  |  |  |  |  |  |  |  | Sample Analysis Date |  |  |  |  |  |  |  |  |  |  |  |  |  | Ditch #1: | Grab |  |  |  |  |  |  | Digesters:
 | Ditch 3 |  |  |  |  |  |  |  |  | Analyst Initials | NJC | NJC | NJC | NJC | NJC | NJC | NJC | NJC |  |  |  |  |  | Ditch #2: | Grab
 | Clarifier 3 |  |  |  |  |  |  |  |  | Qualifier |  |  |  |  |  |  |  |  |  |  |  |  |  | Ditch #3: | Grab
 | Cake |  |  |  |  |  |  |  |  | [NAME] | SM 2540 D-2011 | SM 5210 B-2011 | SM 2540 D-2011 | SM 2540 E-2011 | SM 2710 C-2011 | SM 2710 D-2011 |  | SM 2540 G-2011 |  |  |  |  |  | E.W.C Bridge: | Composite |  |  |  |  |  |  | Sludge & Cake:
 | Sludge |  |  |  |  |  |  |  |  | MRL | 2.5 | 2 | 2.5 | 2.5 |  |  |  |  |  |  |  |  |  | [NAME]: | Composite
 | EWC Bridge |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Digester #1: | Grab
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Digester #2: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Digester #3: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sludge: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cake: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUESDAY | Sample Location: | Sample Type: | Sample ID: | Collection Time: | Volume (L) | Temp (C) | [NAME] | Analytes:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Influent-24HC: | 24-HC |  |  |  |  |  | COD, TSS, cBOD, NH3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Effluent-24HC: | 24-HC |  |  |  |  |  | COD, TSS, cBOD, NH3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTE: | Jug volume should be at least 9.6 L. |  | Check samplers if jug volume is below 9 L.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Effluent Grab (pH): | Grab |  |  |  |  |  | pH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Effluent Grab (E. coli): | Grab |  |  |  |  |  | Total Coliform, E.Coli
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Clarifer 3: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ditch #1: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ditch #2: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ditch #3: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E.W.C Bridge: | Composite
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]: | Composite
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Digester #1: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Digester #2: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Digester #3: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sludge: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cake: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEDNESDAY | Sample Location: | Sample Type: | Sample ID: | Collection Time: | Volume (L) | Temp (C) | [NAME] | Analytes:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Influent-24HC: | 24-HC |  |  |  |  |  | COD, TSS, cBOD, NH3, TP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Effluent-24HC: | 24-HC |  |  |  |  |  | COD, TSS, cBOD, NH3, TP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTE: | Jug volume should be at least 9.6 L. |  | Check samplers if jug volume is below 9 L.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Effluent Grab (pH): | Grab |  |  |  |  |  | pH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Effluent Grab (E. coli): | Grab |  |  |  |  |  | Total Coliform, E.Coli
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Clarifer 3: | Grab |  |  |  |  |  | Added to Polyseed for cBOD test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ditch #1: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ditch #2: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ditch #3: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E.W.C Bridge: | Composite
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]: | Composite
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Digester #1: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Digester #2: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Digester #3: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sludge: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cake: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | THURSDAY | Sample Location: | Sample Type: | Sample ID: | Collection Time: | Volume (L) | Temp (C) | [NAME] | Analytes:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Influent-24HC: | 24-HC |  |  |  |  |  | COD, TSS, cBOD, NH3, TP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Effluent-24HC: | 24-HC |  |  |  |  |  | COD, TSS, cBOD, NH3, TP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTE: | Jug volume should be at least 9.6 L. |  | Check samplers if jug volume is below 9 L.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Effluent Grab (pH): | Grab |  |  |  |  |  | pH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Effluent Grab (E. coli): | Grab |  |  |  |  |  | Total Coliform, E.Coli
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Clarifer 3: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ditch #1: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ditch #2: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ditch #3: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E.W.C Bridge: | Composite
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]: | Composite
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Digester #1: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Digester #2: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Digester #3: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sludge: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cake: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FRIDAY | Sample Location: | Sample Type: | Sample ID: | Collection Time: | Volume (L) | Temp (C) | [NAME] | Analytes:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Influent-24HC: | 24-HC |  |  |  |  |  | COD, TSS, cBOD, BOD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Effluent-24HC: | 24-HC |  |  |  |  |  | COD, TSS, cBOD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTE: | Jug volume should be at least 9.6 L. |  | Check samplers if jug volume is below 9 L.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Effluent Grab (pH): | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Effluent Grab (E. coli): | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Clarifer 3: | Grab |  |  |  |  |  | Added to Polyseed for cBOD test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ditch #1: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ditch #2: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ditch #3: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E.W.C Bridge: | Composite
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]: | Composite
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Digester #1: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Digester #2: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Digester #3: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sludge: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cake: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SATURDAY | Sample Location: | Sample Type: | Sample ID: | Collection Time: | Volume (L) | Temp (C) | [NAME] | Analytes:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Influent-24HC: | 24-HC |  |  |  |  |  | TSS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Effluent-24HC: | 24-HC |  |  |  |  |  | TSS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTE: | Jug volume should be at least 9.6 L. |  | Check samplers if jug volume is below 9 L.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Effluent Grab (pH): | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Effluent Grab (E. coli): | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Clarifer 3: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ditch #1: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ditch #2: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ditch #3: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E.W.C Bridge: | Composite
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]: | Composite
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Digester #1: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Digester #2: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Digester #3: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sludge: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cake: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUNDAY | Sample Location: | Sample Type: | Sample ID: | Collection Time: | Volume (L) | Temp (C) | [NAME] | Analytes:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Influent-24HC: | 24-HC |  |  |  |  |  | TSS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Effluent-24HC: | 24-HC |  |  |  |  |  | TSS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTE: | Jug volume should be at least 9.6 L. |  | Check samplers if jug volume is below 9 L.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Effluent Grab (pH): | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Effluent Grab (E. coli): | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Clarifer 3: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ditch #1: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ditch #2: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ditch #3: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E.W.C Bridge: | Composite
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]: | Composite
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Digester #1: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Digester #2: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Digester #3: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sludge: | Grab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cake: | Grab