Form 5900-603 40 CFR Part 63, Subpart VVV National Emission Stan

---

Overview

Welcome
Company_Information
Covers
HAP_Fraction
Deviations
Revisions

---

Sheet 1: Welcome

63.1590(b) Annual Report (Spreadsheet Template)

63.1590(b)

ICR Draft

9/13/2022

OMB No.: 2060-0428 Form 5900-603 For further Paperwork Reduction Act information see:
https://www.epa.gov/electronic-reporting-air-emissions/paperwork-reduction-act-pra-cedri-and-ert

40 CFR Part 63, Subpart VVV National Emission Standards for Hazardous Air Pollutants: Publicly Owned Treatment Works
§63.1590(b) Annual Report Spreadsheet Template

Instructions for Spreadsheet Template

Purpose:
This spreadsheet template was designed by the U.S. EPA to facilitate compliance reporting for facilities subject to annual reporting under the 40 CFR part 63, subpart VVV National Emission Standard for Hazardous Air Pollutants for Publicly Owned Treatment Works.

Electronic reporting:
Electronic submission of Compliance Reports through the EPA's Compliance and Emissions Data Reporting Interface (CEDRI) is required under §63.1590(b)(5). CEDRI is accessed through the EPA's Central Data Exchange (https://cdx.epa.gov).

Do not submit confidential business information (CBI) to EPA via CEDRI. EPA will make all the information submitted through this form via CEDRI available to the public without further notice to you. Anything submitted using CEDRI cannot later be claimed to be CBI. Furthermore, under CAA section 114(c) emissions data is not entitled to confidential treatment, and EPA is required to make emissions data available to the public. Thus, emissions data will not be protected as CBI and will be made publicly available.

Although we do not expect persons to assert a claim of CBI, if persons wish to assert a CBI claim, you must submit the report via CEDRI with the CBI omitted and mail a complete report, including any information claimed to be CBI, to EPA on a compact disc, flash drive, or other commonly used electronic storage media via U.S. postal service. You must mark the outside of the digital storage media as CBI and then identify electronically within the digital storage media the specific information that is claimed as CBI. Mail the media to:

U.S. EPA/OAQPS/SPPD/CORE CBI Office
Attention: Group Leader, Measurement Policy Group
MD C404-02
4930 Old Page Rd
Durham, North Carolina 27703

The CEDRI spreadsheet template upload feature allows you to submit data in a single report for a single facility or multiple facilities using this EPA-provided Excel workbook. Data for each facility must be entered into the worksheet labeled "Company Information" in this Excel workbook. Each row in the "Company Information" worksheet includes the data for a single facility location. The Site Record No. will be used to match the information on each tab to the appropriate facility.

IMPORTANT: The final CEDRI upload file must be a single ZIP file, which must include this Excel workbook and any related attachments that were referenced in the workbook (i.e., additional information file found in the "Company Information" worksheet).

For each facility (site) record found in the "Company Information" worksheet, you may reference a single file attachment that includes additional information. If you are uploading file attachments for your report, the uploaded files may be in any format (e.g., zip, docx, PDF). If you would like to include an Excel file(s) as an attachment, you must first zip the excel file(s) into a separate ZIP file to the master ZIP file that will be uploaded into CEDRI.

For example, the file “Jan-June2019-Report.zip” uploaded into CEDRI may contain 2 files:
1. Completed_semiannual_reporting_spreadsheet_Jan-June2019.xlsx
2. Attachments.zip
The “Attachments.zip” file could contain as many attachments of any format (xlsx, xls, docx, pdf, zip, etc.) as needed.
If you only have one file to attach, you do not need to zip it unless it is an Excel file (.xlsx, .xls).

Template Navigation and Tabs to Complete:
Gray Tab: The gray tab (Company_Information) contains general information, most of which is likely to be unchanged from report to report. After completing the gray tab, the workbook may be saved as a site-specific template for use in subsequent reports to limit subsequent data entry.

Green Tabs: The green tabs (Covers, HAP_Fraction) are to be completed as necessary, depending on which standard the POTW complies with.

Blue Tab: The blue tab (Deviations) applies to all facilities, regardless of which standard is used for compliance.

Within the tabs, example rows are colored light orange (rows 14 through 23), and the XML tag row (row 13) is colored green. These rows are locked; no data entry is made in these rows.

---

Sheet 2: Company_Information

40 CFR Part 63, Subpart VVV National Emission Standards for Hazardous Air Pollutants: Publicly Owned Treatment Works

§63.1590(b) Annual Report Spreadsheet Template

The Responsible Agency Facility ID is an optional field that can be used to provide information that allows a state or local agency to identify the site. These IDs are provided by the state or local agency and are not required for federal reporting purposes.

SITE INFORMATION

REPORTING PERIOD

ADDITIONAL INFORMATION

Site Record No. (Field value will automatically generate if a value is not entered.)

Company Name (§63.1590(b)(1)(i))

POTW Treatment Plant Name (§63.1590(b)(1)(i))

POTW Treatment Plant Address (§63.1590(b)(1)(i))

Address 2

City (§63.1590(b)(1)(i))

County (§63.1590(b)(1)(i))

State Abbreviation (§63.1590(b)(1)(i)) (Select from dropdown)

Zip Code (§63.1590(b)(1)(i))

Responsible Agency Facility ID (State Facility Identifier)

Beginning Date of Reporting Period (§63.1590(b)(1)(ii))

Ending Date of Reporting Period (§63.1590(b)(1)(ii))

Please enter any additional information.

Enter associated file name reference.

RecordId

CompanyName

PlantName

AddressLine1

AddressLine2

CityName

CountyName

StateName

ZIPCode

StateFacID

PeriodStartDate

PeriodEndDate

AddInfo

AddFile

e.g.: 1

e.g.: ABC Company

e.g.: XYZ POTW

e.g.: 123 Main Street

e.g.: Suite 100

e.g.: Brooklyn

e.g.: Kings

e.g.: NY

e.g.: 11221

e.g.: 9145555555

e.g.: 01/01/20

e.g.: 12/31/20

e.g.:

e.g.: addlinfo.zip

---

Sheet 3: Covers

40 CFR Part 63, Subpart VVV National Emission Standards for Hazardous Air Pollutants: Publicly Owned Treatment Works
§63.1590(b) Annual Report Spreadsheet Template
Note: Site Record No. selections appear once POTW Treatment Plant Name(s) are added to Company_Information worksheet.
Site Record No. (Select from dropdown)	Date of Visual Inspection (§63.1590(b)(2)(i))	Defects Found During Visual Inspection (§63.1590(b)(2)(ii))	How Defect Was Repaired (§63.1590(b)(2)(iii))	Has the Repair Been Completed? (§63.1590(b)(2)(iii)) (Select from dropdown)	Date Repair Was Completed or Date Repair is Expected to be Completed (§63.1590(b)(2)(iii))
RecordId	InspectionDate	InspectionDefect	DefectRepair	RepairComplete	RepairDate
e.g.: 1	e.g.: 12/20/21	e.g.: broken, cracked, or damaged seals on closure devices	e.g.: replaced broken seal	e.g.: Yes	e.g.: 12/22/21

---

Sheet 4: HAP_Fraction

40 CFR Part 63, Subpart VVV National Emission Standards for Hazardous Air Pollutants: Publicly Owned Treatment Works
§63.1590(b) Annual Report Spreadsheet Template
Note: Site Record No. selections appear once POTW Treatment Plant Name(s) are added to Company_Information worksheet.
Site Record No. (Select from dropdown)	Annual Rolling Average HAP Fraction Emitted as Calculated in §63.1588(c)(3)(vii) (§63.1590(b)(3))	Final Month Included in the Calculation of this Annual Average Value (§63.1590(b)(3)) (Select from dropdown)
RecordId	HapFraction	FinalMonthAverage
e.g.: 1	e.g.: 0.008	e.g.: February

---

Sheet 5: Deviations

40 CFR Part 63, Subpart VVV National Emission Standards for Hazardous Air Pollutants: Publicly Owned Treatment Works
§63.1590(b) Annual Report Spreadsheet Template
Note: Site Record No. selections appear once POTW Treatment Plant Name(s) are added to Company_Information worksheet.
Site Record No. (Select from dropdown)	Standard Which Was Not Met (§63.1590(b)(4))	Failure Start Date (§63.1590(b)(4))	Failure Start Time (§63.1590(b)(4))	Failure Duration (§63.1590(b)(4))	Duration Units (§63.1590(b)(4)) (Select from dropdown)	Affected Sources or Equipment (§63.1590(b)(4))	If complying with the cover and control standard, what was the percent control achieved? (§63.1590(b)(4))	If complying with the HAP fraction emitted standard, what HAP fraction was emitted? (§63.1590(b)(4))	Regulated Pollutant Emitted Over Emission Limit (§63.1590(b)(4))	Estimate of Pollutant Emitted Over Emission Limit (tons/year) (§63.1590(b)(4))	Description of the Method Used to Estimate the Emissions (§63.1590(b)(4))
RecordId	LimitDeviation	DeviationStartDate	DeviationStartTime	DeviationDuration	DeviationDurationUnits	AffectedSource	ControlAchieved	FractionEmitted	DeviationPollutant	EmissionQuantity	EstimationMethod
e.g.: 1	e.g.: HAP Fraction Emitted	e.g.: 12/1/22	12:00 AM	e.g.: 2	e.g.: months	e.g.: carbon adsorption unit	e.g.: 65.00%	e.g.: 0.200	e.g.: Styrene, Tolulene	e.g.: Styrene = 1.8, Tolulene=0.013	e.g.: Performance test

---

Sheet 6: Revisions

40 CFR Part 63, Subpart VVV National Emission Standards for Hazardous Air Pollutants: Publicly Owned Treatment Works
§63.1590(b) Annual Report Spreadsheet Template
Revision Number	Date	Description
1.00	8/13/2020	Finalized Release Version
ICR Draft	9/13/2022	Welcome - Add PRA information, hide column A; Revisions - Add header rows and change formatting; All tabs updated cell oreintation, hid blank row, added "e.g.:" to all blank example cells