|
Field |
Cell |
Description |
Example |
| 1 |
Permitted Feature ID |
H7,H13... |
Feature is everything before the "-" |
001 |
| 2 |
Limit Set Designator |
H7,H13... |
Everything after "-" in Cell |
A |
| 3 |
Monitoring Period End Date |
J3 |
End Date formatted yyyy-mm-dd |
2025-03-31 |
| 4 |
Parameter Code |
A7, A13... |
Everything before the "-" in cell |
00310 |
| 5 |
Monitoring Location Code |
J7,J13... |
Everything before the ( |
G |
| 6 |
Season Number |
H8,H14 |
|
0 |
| 7 |
Quantity 1 Nodi Code |
B11,B17 |
|
|
| 8 |
Quantity 1 Qualifier Text |
B9,B15... |
Reports the qualifier, if no qualifier reports as "=" |
|
| 9 |
Quantity 1 Sample Value |
B9,B15... |
Reports the numeric result |
|
| 10 |
Not Used |
|
|
|
| 11 |
Quantity 2 Nodi Code |
C11,C17... |
|
|
| 12 |
Quantity 2 Qualifier Text |
C9,C15... |
Reports the qualifier, if no qualifier reports as "=" |
|
| 13 |
Quantity 2 Sample Value |
C9,C15... |
Reports the numeric result |
|
| 14 |
Not Used |
|
|
|
| 15 |
Quantity Units |
D9,D15... |
Reports the Unit code for the units specified. The unit code can be specified in one of two ways. If the cell is a the code-description (i.e. "19-mg/L), 19 would be used as the code. If the cell is just the string (i.e. "mg/L") it will be looked up (not case sensitive) on the Units sheet column C and the corresponding value in column B will be used. |
19 |
| 16 |
Concentration 1 Nodi Code |
|
|
|
| 17 |
Concentration 1 Qualifier Text |
E9,E15... |
Reports the qualifier, if no qualifier reports as "=" |
|
| 18 |
Concentration 1 Sample Value |
E9,E15... |
Reports the numeric result |
|
| 19 |
Not Used |
|
|
|
| 20 |
Concentration 2 Nodi Code |
|
|
|
| 21 |
Concentration 2 Qualifier Text |
F9,F15... |
Reports the qualifier, if no qualifier reports as "=" |
= |
| 22 |
Concentration 2 Sample Value |
F9,F15... |
Reports the numeric result |
227.4 |
| 23 |
Not Used |
|
|
|
| 24 |
Concentration 3 Nodi Code |
|
|
|
| 25 |
Concentration 3 Qualifier Text |
G9,G15... |
Reports the qualifier, if no qualifier reports as "=" |
= |
| 26 |
Concentration 3 Sample Value |
G9,G15... |
Reports the numeric result |
374.0 |
| 27 |
Not Used |
|
|
|
| 28 |
Concentration Units |
H9,H15... |
Reports the Unit code for the units specified. The unit code can be specified in one of two ways. If the cell is a the code-description (i.e. "19-mg/L), 19 would be used as the code. If the cell is just the string (i.e. "mg/L") it will be looked up (not case sensitive) on the Units sheet column C and the corresponding value in column B will be used. |
19 |
| 29 |
Number of excursions |
J9,J15... |
|
0 |
| 30 |
Frequency of Analysis Code |
J11,J17... |
Reports the code for the frequency of analysis specified. The code can be specified in one of two ways. If the cell is a the code-description (i.e. "01/01-Daily), 01/01 would be used as the code. If the cell is just the string (i.e. "Daily") it will be looked up (not case sensitive) on the Freq of Analysis sheet column C and the corresponding value in column B will be used. |
01/01 |
| 31 |
Sample Type Code |
J10,J16... |
Reports the code for the sample type specified. The code can be specified in one of two ways. If the cell is a the code-description (i.e. "24-Comp24), 24 would be used as the code. If the cell is just the string (i.e. "Comp24") it will be looked up (not case sensitive) on the Sample Type sheet column C and the corresponding value in column B will be used. |
24 |