part_60_subpart_ooooa_60.5422a_semiannual_report.xlsx

---

Overview

Welcome (Instructions)
Site_Information
Initial_Report
Semiannual_Report
Revisions

---

Sheet 1: Welcome (Instructions)

60.5422a Semiannual Report (Spreadsheet Template)
60.5422a
draft
9/26/2023
OMB Control Number: 2060-0721 Form 5900-649 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 60, Subpart OOOOa Standards of Performance for Crude Oil and Natural Gas Facilities for which Construction, Modification or Reconstruction Commenced After September 18, 2015, and on or before December 6, 2022 - §60.5422a(a) and (b) Semiannual Report Spreadsheet Template
Instructions for Spreadsheet Template
Purpose: This spreadsheet template was designed by the U.S. EPA to facilitate semiannual reporting for process unit equipment affected facilities subject under 40 CFR part 60, subpart OOOOa New Source Performance Standard for Crude Oil and Natural Gas Facilities Constructed, Modified, or Reconstructed after September 18, 2015, and on or before December 6, 2022.
Electronic reporting: Electronic submission of semiannual reports through the EPA's Compliance and Emissions Data Reporting (CEDRI) is required under §60.5422b and §60.5422c. CEDRI is accessed through the EPA's Central Data Exchange (https://cdx.epa.gov).
Confidential Business Information:
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. All CBI claims must be asserted at the time of submission. 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 for some of the information in this report, you must submit a version of the report with the CBI omitted via CEDRI and submit a complete report, including any information claimed to be CBI, to EPA. The preferred method to receive CBI is for it to be transmitted electronically using email attachments, File Transfer Protocol, or other online file sharing services. Electronic submissions must be transmitted directly to the OAQPS CBI Office at the email address [email protected] to the attention of the Oil and Gas Sector Lead. If assistance is needed with submitting large electronic files that exceed the file size limit for email attachments, and if you do not have your own file sharing service, please email [email protected] to request a file transfer link. If you cannot transmit the file electronically, you may send CBI information through the postal service to the following address:
OAQPS Document Control Officer (C404-02) OAQPS, U.S. Environmental Protection Agency Attn: Oil and Gas Sector Lead Research Triangle Park, North Carolina 27711
The mailed CBI material should be double wrapped and clearly marked. Any CBI markings should not show through the outer envelope. Clearly mark the part or all of the information that you claim to be CBI. Information not marked as CBI may be authorized for public release without prior notice. Information marked as CBI will not be disclosed except in accordance with procedures set forth in 40 CFR part 2.
Using this Template:
The CEDRI spreadsheet template upload feature allows you to submit data in a single report for a single site or multiple sites using this EPA provided Excel workbook. Data for each site must be entered into the worksheet labeled "Site Information" in this Excel workbook. Each row in the "Site Information" worksheet includes the data for a single site. The Site Record No. will be used to match the information on each tab to the appropriate site.
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 "Site Information" worksheet).
For each site record found in the "Site 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 “2019Report.zip” uploaded into CEDRI may contain 2 files: 1. Completed_annual_reporting_spreadsheet_2019.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:
The relevant regulatory citations are listed for each data element. Some data elements provide information that is not required for federal reporting purposes, but may be helpful for report navigation (such as linked to conditional formatting) or may be needed for state or local reporting purposes (e.g., Responsible Agency Facility ID). These data elements do not have a regulatory citation associated with them.
Within each worksheet, 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: Site_Information

40 CFR Part 60 - Standards of Performance for Crude Oil and Natural Gas Facilities for which Construction, Modification or Reconstruction Commenced After September 18, 2015, and on or before December 6, 2022 - 60.5422a Semiannual Report

Use this tab to provide information on the sites for which you are reporting.

Note: The Site Record No. will automatically generate if you do not enter one.

FACILITY INFORMATION

REPORTING PERIOD

ADDITIONAL INFORMATION

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

Site Name

Address of Processing Plant

Address 2

City

County

State Abbreviation

Zip Code

Responsible Agency Facility ID (State Facility Identifier)

Beginning Date of Reporting Period

Ending Date of Reporting Period

Please enter any additional information

Enter associated file name reference.

RecordId

FacilityName

AddressLine1

AddressLine2

CityName

CountyName

StateName

ZIPCode

StateFacID

PeriodStartDate

PeriodEndDate

AddInfo

AddFile

e.g.: 1

e.g.: ABC Company

e.g.: 123 Main Street

e.g.: Suite 100

e.g.: Brooklyn

e.g.: Kings County

e.g.: NY

e.g.: 11221

e.g.:

e.g.: 01/01/2016

e.g.: 06/30/2016

e.g.: filename.pdf

---

Sheet 3: Initial_Report

40 CFR Part 60 - Standards of Performance for Crude Oil and Natural Gas Facilities for which Construction, Modification or Reconstruction Commenced After September 18, 2015, and on or before December 6, 2022 - 60.5422a Semiannual Report
An owner or operator must include the following information in the initial semiannual report in addition to the information required in §60.487a(b)(1) through (4): Number of pressure relief devices subject to the requirements of §60.5401a(b)
except for those pressure relief devices designated for no detectable emissions under the provisions of §60.482-4a(a) and those pressure relief devices complying with §60.482-4a(c).
Note: Site Record No. selections will appear once information entered onto the Site_Information tab.
Site Record No. (Select from dropdown list)	Process unit Identification (§60.487a(b)(1), §60.5422a(b))	Number of pressure relief devices subject to the requirements of §60.5401a(b) except for those designated for no detectable emissions and those complying with §60.482-4a(c) (§60.5422a(b))	Number of valves subject to the requirements of §60.482–7a, excluding those valves designated for no detectable emissions under the provisions of §60.482–7a(f) (§60.487a(b)(2), §60.5422a(b))	Number of pumps subject to the requirements of §60.482–2a, excluding those pumps designated for no detectable emissions under the provisions of §60.482–2a(e) and those pumps complying with §60.482–2a(f) (§60.487a(b)(3), §60.5422a(b))	Number of connectors subject to the requirements of §60.482–11a (§60.487a(b)(5), §60.5422a(b))
RecordId	ProcessUnitID	InPreRelDevCt	InValveCt	InPumpCt	InConnectorCt
e.g.: 1	e.g.: HVDry-1a	e.g.: 5	e.g.: 5	e.g.: 5	e.g.: 5

---

Sheet 4: Semiannual_Report

40 CFR Part 60 - Standards of Performance for Crude Oil and Natural Gas Facilities for which Construction, Modification or Reconstruction Commenced After September 18, 2015, and on or before December 6, 2022 - 60.5422a Semiannual Report
An owner or operator must include the information specified in paragraphs (c)(1) and (2) of this section in all semiannual reports in addition to the information required in § 60.487a(c)(2)(i) through (iv) and (vii) through (viii):
(1) Number of pressure relief devices for which leaks were detected as required in § 60.5401a(b)(2); and (2) Number of pressure relief devices for which leaks were not repaired as required in § 60.5401a(b)(3).
Note: Site Record No. selections will appear once information entered onto the Site_Information tab.
Facility Record No. (Select from dropdown list)	Month Identification (Select from dropdown list)	Number of pressure relief devices for which leaks were detected (§60.5422a(c)(1))	Number of pressure relief devices for which leaks were not repaired as required in §60.5401a(b)(3) (§60.5422a(c)(2))	Number of valves for which leaks were detected (§60.487a(c)(2)(i), §60.5422a(c))	Number of valves for which leaks were not repaired as required in §60.482–7a(d)(1) (§60.487a(c)(2)(ii), §60.5422a(c))	Number of pumps for which leaks were detected (§60.487a(c)(2)(iii), §60.5422a(c))	Number of pumps for which leaks were not repaired as required in §60.482–2a(c)(1) and (d)(6) (§60.487a(c)(2)(iv), §60.5422a(c))	Number of connectors for which leaks were detected (§60.487a(c)(2)(vii), §60.5422a(c))	Number of connectors for which leaks were not repaired as required in §60.482–11a(d) (§60.487a(c)(2)(viii), §60.5422a(c))
RecordId	MonthID	SAPreRelDevCt	SAPreRelDevNRCt	SAValveCt	SAValveNRCt	SAPumpCt	SAPumpNRCt	SAConnectorCt	SAConnectorNRCt
e.g.: 1	e.g.: March	e.g.: 5	e.g.: 5	e.g.: 5	e.g.: 5	e.g.: 5	e.g.: 5	e.g.: 5	e.g.: 5

---

Sheet 5: Revisions

Revision Number	Date	Description