3.0 Data Formats

The analysis of sample data must be completed by a certified lab.  However, if your lab is not satisfying all of the EDI criteria or you have old non compliant data or hard copy data or you’re preparing sample data for submittal to a lab…etc, SRP has supplied the required format below. There are three options that can be used to create your electronic data deliverable. It is extremely important to follow the required format for all your EDDs.  If the format shown below is not the final format that is submitted to the SRP, the submittal will fail. An EDD may be prepared by a Licensed Site Remediation Professional (LSRP) or a qualified data preparer on behalf of the responsible party, but the obligation of submitting an accurate EDD lies with the person responsible for conducting the remediation.

3.1 The SRP Template Format

An LSRP or data preparer having access to a computer but limited means of computer support, may find it easier to use the SRP Template Format to meet the data deliverable requirements. The SRP Template Format is a basic, stand-alone spreadsheet which outputs to a text, tab-delimited format. All of the required fields are identified in the spreadsheet by column headers. This option is most suitable where the number of samples and the number of analytes for each sample are relatively small, since every result of every sample will have a separate record (separate row in the spreadsheet). The SRP Template and instructions on how to use this option are available in Appendix 1.

3.2 The Spreadsheet Format

An LSRP or data preparer having access to and familiarity with spreadsheet software can create files with a spreadsheet product. Each table must be a separate spreadsheet and saved as a "tab delimited text ” (i.e., ASCII, tab-delimited) format. The table definitions and field definitions are described in section 4.0 of this manual. It is absolutely essential that the formats shown below are strictly followed for field names, widths, order, formatting, etc., or the submission will fail.

3.3 The Database Format

An LSRP or data preparer having access to and familiarity with database software can create files with a database product and save each table in a "tab delimited text” (i.e., ASCII, tab-delimited) format. The table definitions and field definitions are described in section 4.0 of this manual. It is absolutely essential that the formats shown below are strictly followed for field names, widths, order, formatting, etc., or the submission will fail.