![how to download a template for excel how to download a template for excel](https://db-excel.com/wp-content/uploads/2019/01/microsoft-spreadsheet-free-regarding-009-microsoft-excel-spreadsheet-free-download-unique-templates-for-1598x970.jpg)
Save your progress regularly when using Excel.To ensure this works correctly when CMDP processes the content of the Template, enter the routine sample into a row in the template and then enter any associated repeat samples in the rows below. It is important that the value (ID) entered in the Original Sample ID field exists in CMDP before the associated repeat samples are reported, otherwise the repeat samples will be rejected. When entering repeat samples, make sure that you populate the routine (Original) Sample ID and optionally the Repeat Location field.If multiple samples share the same information (same collection date, sample time, etc.), you can copy the information contained in a row and paste it in the next row.
![how to download a template for excel how to download a template for excel](https://db-excel.com/wp-content/uploads/2018/11/14-best-of-inventory-tracking-spreadsheet-template-download-within-excel-template-inventory-tracking-download.jpg)
Because the CMDP templates are in MS Excel, copy and paste features are available for use.Alternatively your state primacy agency may already provide a reference for submitters, for example, Drinking Water Watch, or another state website, where these values are stored. To help avoid these kinds of errors, please log into CMDP and view the PWS Profiles or Laboratory Profiles to check for the reference data stored in CMDP for critical fields such as: Water System ID, Water System Facility ID, Sampling Point ID, and Laboratory ID. If a record contains a value not stored in CMDP as reference data for these fields, then the value will not be considered valid, and CMDP will reject the record.For example, entering “oh0000001” as a Water System ID is not a valid value the correct value is “OH0000001.” It is critical that users take into consideration the stored reference data in CMDP and that data are case-sensitive.Please refer to the CMDP Web Services Sampling Data Dictionary for valid values for the fields used by CMDP. If any cell contains invalid data or formats, the record will be rejected. Be sure to enter valid data in appropriate formats in each cell so that a record is not rejected.Some data validations are included in the templates to help ensure that the data are valid and will be accepted by CMDP.The name you give to the XML file will be recorded in CMDP when you upload the XML file. You likely will want to use the same name when you generate an XML file from the template, so have it handy. You may want to make a copy of the template you'll use and name the file to reflect the data you'll be entering into it.Things to know when using Excell templates for CMDP submission: Note: The latest version of the CMDP templates should be downloaded directly from the CMDP application ( or ). Example files, including sample data, are also included for your reference. Download two Excel templates at the bottom of the page below - Sample Results and Operational Data.