Home : NPDES Row
Q11180 - INFO: NPDES Row

Used to quickly fill in a row of the NPDES DMR (National Pollutant Discharge Elimination System Discharge Monitoring Report) report.  Works with the following spread templates:

US WW NPDES PORTRAIT.SS3
US WW NPDES.SS3
US_WW_NPDES_REV399_(No Numbers).SS3

NJ_WW_Surface_Water_Discharge_Monitoring_Report.ss3
VA_WW_NPDES_V2.SS3
VA_WW_NPDES_V3.SS3
WV_WW_NPDES.ss3

USING:

To use this function place your cursor on a row that you want to fill in with information and then either select Locate, NPDES Row from the menu items or click on the N button at the top of the screen.   The different boxes on this form correspond to the different areas in the NPDES report.

There are 4 dropdown lists for each section (minimum, average, etc.).

Sample Measurement:  The top dropdown list in sample measurement is used to select a variable. The 2nd dropdown list in sample measurement is used to select the statistic that you want to perform on the variable.

Permit Requirement:  The top dropdown list in permit requirement is used to select a limit from the database that is displayed on the report. If you select REPORT then no number is put on the report. If you select Daily Min the program will look up the daily minimum limit for the variable in question and display that number on the form. The 2nd  dropdown list in permit requirement is used to select the text that is displayed on the report. This can be over written with what ever you want to display.

Units: The units boxes should be automatically filled in depending on which variable you select. This text can be over written with what ever you want to display.

Print <,> and Print OPV boxes:  These will be filled in automatically from the database depending on which variable you select. You can override the database settings for each report if you desire.

Count box:  Check this box to display the number of violations that occurred.

FIELDS:

Parameter: The text used to fill in the Parameter box.  When choosing a variable for one of the columns, if the Storet Code for the variable is filled in the text will be entered automatically. Example:

AVERAGE:  Choose the variable, summary statistic, Permit Requirement Limit, and Permit Requirement Description.  Check  to have the count of violations (exceedances) for this column added to the No Ex column.

 

MAXIMUM:  Choose the variable, summary statistic, Permit Requirement Limit, and Permit Requirement Description for Quantity or Loading Maximum.  Check  to have the count of violations (exceedances) for this column added to the No Ex column.

MINIMUM: Choose the variable, summary statistic, Permit Requirement Limit, and Permit Requirement Description for Quality or Concentration Maximum.  Check  to have the count of violations (exceedances) for this column added to the No Ex column.

AVERAGE: Choose the variable, summary statistic, Permit Requirement Limit, and Permit Requirement Description for Quality or Concentration Maximum.  Check  to have the count of violations (exceedances) for this column added to the No Ex column.

MAXIMUM:  Choose the variable, summary statistic, Permit Requirement Limit, and Permit Requirement Description for Quality or Concentration Maximum.  Check  to have the count of violations (exceedances) for this column added to the No Ex column.The average and maximum for quantity or loading and the minimum, average and maximum for quality or concentration are all filled out in a similar manner.

 

 

Video: Designing the NPDES Report

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 5/9/2008 9:23 AM.
Last Modified on 8/8/2008 4:17 PM.
Last Modified by Scott Dorner.
Article has been viewed 5060 times.
Rated 7 out of 10 based on 2 votes.
Print Article
Email Article