Governor Phil Murphy • Lt. Governor Tahesha Way
new jersey department of environmental protection
NJ Home Page Services A to Z NJ FAQs NJ Departments/Agencies departments
site remediation program

SRP Home | DEP Home

HazsiteSRP-EDI ManualAppendix 1 Excel Template


Appendix 1

EDSA Excel Template

SRP provides a template to make it easier to generate an acceptabe EDD that will pass the EDSA7 checker. There are 6 rules that must be followed when using the template.

  1. Never write directly to the original template – always use a copy of the spreadsheet;
  2. Don't change the format of the template;
  3. Copy and paste text only to the spreadsheet tabs. If the source is from spreadsheet cells that are not in a text format, paste what is copied to Notepad then copy the text from Notepad into the template;
  4. Once data input to the template has been completed, “Save As” DTST.TXT or HZSAMPLE.TXT or HZRESULT.TXT from their corresponding tabs. Make sure the format selected is Tab-delimited Text;
  5. If manual data entry is necessary, enter the information directly into the copy of the template; and
  6. Finally run the EDD through EDSA7 and send it to SRP when it passes EDSA7.