By December 21st, 2016 facilities are required to submit DMRs electronically via the Pennslylvania eDMR system. The eDMR system replaced the e2 reporting system in December 2015 which allowed for XML upload of data (click here for information on WIMS support of the obsolete e2 XML upload).
According to the eDMR User Guide Version 1.2, Jan 5, 2016 (http://files.dep.state.pa.us/Water/Wastewater%20Management/eDMRPortalFiles/eDMRUserGuide.pdf ) there are NO options to upload data:
Q: Will there be any options to upload electronic data files instead of manually entering the data?
A: No, eDMR does not support XML, Excel, or bulk copy/paste data entry at this time. DEP plans to make enhancements to the eDMR system in the future with this capability.
See http://www.dep.pa.gov/Business/Water/PointNonPointMgmt/WastewaterMgmt/eDMR/Pages/default.aspx#.Vz8WdoQrLRY for more information.
PA_WW_NPDES_DMR_3800-FM-BPNPSM4062.hwr Pennsylvania DMR: preview
Pennsylvania Department of Environment Protection (DEP) National Pollutant Discharge Elimination System (NPDES) Discharge Monitoring Report (DMR) - Form 3800-FM-BPNPSM0462 3/2012
Author: SPD 10/21/2013
PA_WW_CSO_3800-FM-BPNPSM0441.hwr Pennsylvania CSO Report: preview
Pennsylvania Department of Environment Protection (DEP) CSO Supplemental Report - Monthly Inspection Report and Detailed Report - Form 3800-FM-BPNPSM0441 and 0442.
Author: SPD 10/21/2013
Calculation Notes:
WEEKLY AVERAGES
When calculating Weekly Averages, week 18 should be used. See WAVGn.
From the state's DMR Overview and Summary Guidance Manual (see DEP DMR Page for latest information):
How is the weekly average calculated for reporting on DMRs?
A weekly average is calculated by the sum of all daily discharges (concentrations or loads) measured during a calendar week (Sunday – Saturday) divided by the number of daily discharges measured during that week. Unless otherwise specified in the permit, report the maximum weekly average value on DMRs.
Months do not always begin on a Sunday and end on a Saturday – how should weekly average values account for this?
Weekly average values are based on a calendar week of Sunday to Saturday. The first week of the month, for reporting purposes, always begins on a Sunday, and the last week of the month always ends on a Saturday. When a week is split between two months, the weekly average value for that week will be reported with the month containing the most days of that week.
Example – April 2009. April 1 is a Wednesday. The first week of April would include, for the purpose of calculating weekly averages, Sunday, March 29, Monday, March 30 and Tuesday, March 31. April 30 is a Thursday. The last week of April would include Friday, May 1 and Saturday, May 2. Therefore, five weeks would be considered for April 2009: March 29 – April 4 (Week 1), April 5 – 11 (Week 2), April 12 – 18 (Week 3), April 19 – 25 (Week 4) and April 26 – May 2 (Week 5).
Handling of Data Qualifiers
In most cases you should use the "Entered Value" MDL Rule in WIMS. You should use the Cascade Symbol in load calculations and when locating group summary statistics in spread reports you should locate with Place < or > Symbol with statistic on and use "if one value contains a < or >" option - See GAVGZ using MDL Rule 1, etc...)
From the state's DMR Overview and Summary Guidance Manual (see DEP DMR Page for latest information):
How should results below detection limits be reported and how are statistical values with a data set that includes non-detect results calculated?
Laboratories will generally have, for most parameters, a Quantitation Limit (QL) and a Detection Limit (DL). Detection Limit is defined in 25 Pa. Code Chapter 252 (Environmental Laboratory Accreditation) as “The lowest concentration or amount of the target analyte that can be identified, measured and reported with confidence that the analyte concentration is not zero.” Quantitation Limit is defined in Chapter 252 as “The minimum concentration or activity of the component, compound, element or isotope that can be reported with a specified degree of confidence. Typically it is the concentration that produces a signal ten standard deviations above the reagent water blank signal.” The QL is typically a higher value than the DL. The QL is sometimes referred to as the “reporting limit.”
If you receive a report with a parameter value listed as “non-detect”, “ND”, or is qualified by a less than (<) symbol, it indicates that the laboratory has verified that the parameter value is less than the QL, and is reporting the value as a “non-detect” result. For DMR reporting purposes, DEP prefers the following approach to handling non-detect results:
- Report the actual value reported by the laboratory on supplemental reporting forms.
Example – enter “<” into the Qualifier (Q) column of the Daily Effluent Monitoring Form (3800-FM-BPNPSM0435) for non-detect results. Do not enter “<” on this form for detected results.
- Do not report zeroes or “non-detect” for statistical values on the DMR.
Example – use the less than (<) symbol on DMRs instead of “0” or “ND”.
- Ignore the less than (<) symbol and calculate statistics (both concentration and load) based on detected results and the reporting limit(s) for non-detect results, except as noted in No. 4, below, where zero may be substituted for non-detect results. Where there is at least one non-detect result in a data set, include the less than (<) symbol with the statistical result.
Example – the average statistical value for a data set with three results, < 1.0, 2.0, and < 3.0 is < 2.0 for DMR reporting purposes.
- If your permit contains a water quality based limit that is less than the most sensitive DL, as published in 25 Pa. Code Chapter 16 (Appendix A, Tables 2A and 2B), and you receive a result of non-detect in which the reporting limit is less than or equal to the most sensitive DL, zero may be substituted for the