Home : Locate CMDP Lead and Copper (LCR) Results
Q14513 - INFO: Locate CMDP Lead and Copper (LCR) Results

Used to locate Lead and Copper results into the Compliance Monitoring Data Portal (CMDP) report.  Use the CMDP-OperationalData.hwr template found in the CMDP Drinking Water Templates.

1 Choose your Lead and Copper Lab Cal Tests.  This tells the report which results for the samples to be reported.
2 Set the criteria to select the Distribution Lead and Copper Lab Cal samples.  In this example, we set the Sample Names to LCR D01, LCR D02, etc... Therefore any sample that starts with LCR D is a Distribution Lead and Copper sample.
3 Set the criteria to select the Entry Point Lead and Copper Lab Cal samples.  In this example, we set the Sample Names to LCR POE1, LCR POE2, etc... Therefore any sample that starts with LCR P is a Point of Entry Lead and Copper sample
4 This what to locate for each column in the report.  NOTE:  An SQL Query returns the results and the formulas refer to those queries.  Cell A3 will contain the query for Distribution Results and A4 will contain the Entry Point Results.

 

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 8/22/2018 7:57 AM.
Last Modified on 8/24/2018 9:17 AM.
Last Modified by Scott Dorner.
Article has been viewed 2013 times.
Rated 6 out of 10 based on 2 votes.
Print Article
Email Article