Worksheet Instructions

The sample worksheets provided above contain the groundwater monitoring parameter names listed in the order they must be submitted to the Solid Waste Management Program.  Parameter names and units must be submitted as provided in the sample worksheets.  All organic parameters must be submitted with the Solid Waste Management Program prescribed chemical name.

Parameters not shown in the list or required as part of the facilities approved monitoring parameters (Bicarbonate, potassium, quality assurance/quality control, field blanks, trip blanks, additional results for dissolved metals etc.) must be placed and submitted in a separate file.

The data must be entered in the format shown on the sample worksheet page.  The Solid Waste Management Program suggests that the downloadable worksheet be the basis for your master list and must include all wells in one file. The file must be saved in a Microsoft® Excel® comma separated value, also known as CSV, format. The following guidelines must be observed for the data to be considered submitted in the Solid Waste Management Program prescribed format:

Column 1:  This column contains the well designation. It must be eight characters or less and must be provided as approved by the Solid Waste Management Program. Changes to the designations from this point forward are not permitted.  Please review each submittal to ensure consistency with previous well designations.

Column 2: This column contains the monitoring parameter name. The names occur in the exact order as shown in Appendix I of the regulations. It also includes the indicator parameters (Chemical Oxygen Demand, Chlorides, Iron, pH, Specific Conductance, Total Dissolved Solids). 

*Note that values for pH and Specific Conductance must be field values obtained during well purging.

Each submittal must be exactly the same format as shown in the example worksheet as provided above.  Absolutely no changes can be made to this column.  Data fields may not be left blank. If a parameter is not tested, indicate so in the flag column and reported value column as necessary. If the format does not conform to what is supplied, your data will be rejected and sent back to you for correction.

Column 3:  This column contains the sampling date. The date must be entered in the mm/dd/yyyy format.

Column 4: This column contains the reporting units for each parameter. No changes will be permitted. You will need to be sure of your units and possibly convert them before entering them.  Please ensure that if unit conversions are performed, both the units and reported values are consistent.

Column 5: This column contains the reported (quantified) value. If a parameter was not tested, ‘n/a’ must be entered in this column and ‘NT’ must be placed in the flag column. If the parameter was not detected, the practical quantitation limit should be entered in this column and ‘ND’ or ‘U’ must be placed in the flag column. If a trace is reported, we must have a value in both the method detection limit and practical quantitation limit columns. In this case a ‘J’ must be placed in the flag column. The trace value must be between the method detection limit and practical quantitation limit. For duplicate samples, place the duplicate sample data below the original sample date and place a ‘D’ in the flag column.  Duplicate samples may be submitted in a separate file along with other QA/QC data such as trip blanks.  When you report a duplicate sample, the well designation for which it applies must be listed in Column 1.  Do not place a “D” or other notation in Column 1.

Column 6:  This column contains the practical quantitation limit value. This value is the laboratory’s achievable quantitation limit. It must always be reported within plus or minus 25 percent of the median practical quantitation limit for each specific parameter. If it is not included, the Solid Waste Management Program will return your data.

Column 7:   This column contains data flags. Enter flags ‘U’ or ‘ND’ for non-detects, ‘J’ for trace values, ‘NT’ for not tested, ‘D’ for duplicate, or leave blank for detected values.  No other flags are to be used.  Other flags must be explained in either the text of the email submittal or a separate file.

Column 8: This column contains the method detection limit value. The method detection limit as established by the U.S. Environmental Protection Agency or other appropriate source must be placed in this column. If it is not reported, the Solid Waste Management Program will return your data.

Field blanks, trip blanks, equipment blanks, matrix spikes, water level elevations or other Quality Assurance/Quality Control data must be placed in a separate file for reference. This data may be used for other purposes such as demonstrations at a later date, but, have no impact on routine statistical analyses.

These guidelines must be followed to ensure reliable data conversion to our software packages. This is a modification to your groundwater sampling and analysis plan. If you have questions, call the Solid Waste Management Program first at 573-751-5401.

Email must include the facility name and sampling event date in the subject line and the file name must be site descriptive (i.e. SMHL1108)

Data must be submitted to the SWMP groundwater email data address at

Paper reports and other groundwater correspondence may be mailed to:

Missouri Department of Natural Resources
Solid Waste Management Program
Attn: Permits Unit
P.O. Box 176
Jefferson City, MO 65102-0176