370 likes | 379 Views
Step-by-step instructions for submitting EER via the DEP Online Portal. Includes guidance on creating, validating, and certifying spreadsheets. Follow the outlined process to ensure accurate submission.
E N D
Popular Mechanic 1954 prediction of how the “2004 Home Computer” will look like.
Click on Excess Emission Monitoring Performance Reports (EEMPR)
Select Facility ID by clicking on the dropdown arrow. Click on the Access Facility.
Verify mailing address - scroll down and complete Facility Contact(s).
Using dropdown arrow. Select appropriate year and quarter; Click Request Spreadsheet.
Verify if spreadsheet(s) is requested by going to the EER Submittal Folder. Logout.
Save the spreadsheet file to a location where you can find it.
Logout and work on the downloaded spreadsheet(s) from your desktop.
Fill out all the tabs on the bottom of the spreadsheet. Each tab represents a page.
Common eEER Questions. • MACROS: Upon opening the Excel Spreadsheet, always click Enable. You may need to lower security in order to enable Macros. Go to Tools > Macros > Security > Low. • The source monitor downtime reported on the “General Monitor Info tab” has to match the downtime reported in the “Monitor Downtime tab”. • New CEMs: Facilities can’t change anything on the “General Info Tab”. Please send the new monitor info to the Inspector. The Inspector can update the monitor info on NJEMS. • Not enough rows for downtime or Excursions? Call you inspector. • No Military time allowed.
Common eEER Questions. Part 2 • Please don’t enter any signs on Row 19 under the “General Info Tab”. Just enter a number followed by a single space then the units. For Example: 250 ppm = Good <= 250 ppm = Bad • ERASING AN EXCURSION: Erase a mistake on the “CMS Excursion Tab” by clicking on Clear Excursion Row Button. Do not delete by using back space or delete key. • ADD all additional info under the “Supporting Data tab”. ATTACHMENTS: We recommend jpg files. Please don’t attached pdf files greater than 5 pages. The files will be to big and won’t upload properly. • SENDING TO EPA: eEERs do not automatically go to EPA. Please print out a copy and mail to EPA with a cover letter if required.
When the spreadsheet is completed validate it. Items with an Asterisk must be fixed.
When you lock it you will be prompted to save an unlock copy of the spreadsheet as a backup.
Write down the Confirmation Code. You will need it for submitting the EER to DEP.
Select spreadsheet to upload. Click “Browse” to find the spreadsheet on your computer.
Select the spreadsheet to be uploaded. * Make sure the IDs match.
Spreadsheet is awaiting certification by Responsible Official. Select EER Certification.