part_60_subpart_ooooa_60.5420a_annual_report.xlsm

---

Overview

Welcome
Site Information
Associated Well ID
General Info
Well
Centrifugal Compressor
Reciprocating Compressor
Controllers
Storage Vessels
Collection of Fugitives
Fugitive Surveys
Fugitives Found
Alternative Fugitive
Pneumatic Pumps
Sweetening Unit
Closed Vent Systems
Deviations
Revisions

---

Sheet 1: Welcome

60.5420a(b) Annual Report (Spreadsheet Template)

60.5420a(b)

draft

9/26/2023

OMB Control Number: 2060-0721
Form 5900-648
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.5420a(b) Annual Report Spreadsheet Template

Instructions for Spreadsheet Template

Purpose:
This spreadsheet template was designed by the U.S. EPA to facilitate annual reporting for Oil and Gas 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 annual reports through the EPA's Compliance and Emissions Data Reporting (CEDRI) is required under §60.5420a(b). Additionally, excess emissions periods for sweetening units is required to be reported in the annual report under §60.5423a(b). 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, Fuels and Incineration 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, as well as 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 worksheet titled "General Info" contains a list of questions about the information you will be reporting. You are not required to complete this tab, but doing so will make navigation of the remaining tabs easier. Selecting "No" in the list of questions will hide the tabs associated with worksheets that are not relevant to your reporting. For example, if you answer "No" to whether you will be reporting for affected pneumatic controllers, the "Controllers" worksheet will be hidden from that point forward, unless you change the answer back to "Yes".

Within some of the worksheets, there are questions which are linked to conditional formatting. Depending on your answer to these questions, certain cells will be blacked out, indicating that those data fields are no longer relevant based on your answer.

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.5420a(b) Annual Report

For each affected facility included in the report, an owner or operator must include the information specified in §60.6420a(b)(1)(i) through (iv) in all annual reports.

Note: The Site Record No. will be automatically generated from your Company and Site Name. You must enter a physical address for the site, or if a physical address is not available, you must enter a description of the site location and the coordinates for the site. If you provide an answer in Column E, cells that are not relevant will be shaded in black.

SITE INFORMATION

ALTERNATIVE ADDRESS INFORMATION (IF NO PHYSICAL ADDRESS AVAILABLE FOR SITE)

STATE IDENTIFIER

REPORTING PERIOD

ADDITIONAL INFORMATION

Site Record No. (Field value will automatically generate.)

Company Name (§60.5420a(b)(1)(i))

Facility Site Name (§60.5420a(b)(1)(i))

Does the site have a physical address? (Select from dropdown list)

Address of Affected Facility (§60.5420a(b)(1)(i))

Address 2

City (§60.5420a(b)(1)(i))

County (§60.5420a(b)(1)(i))

State Abbreviation (§60.5420a(b)(1)(i)) (Select from dropdown list)

Zip Code (§60.5420a(b)(1)(i))

Description of Site Location (§60.5420a(b)(1)(i))

Latitude of the Site (decimal degrees to 5 decimals using the North American Datum of 1983) (§60.5420a(b)(1)(i))

Longitude of the Site (decimal degrees to 5 decimals using the North American Datum of 1983) (§60.5420a(b)(1)(i))

Responsible Agency Facility ID (State Facility Identifier)

Beginning Date of Reporting Period (§60.5420a(b)(1)(iii))

Ending Date of Reporting Period (§60.5420a(b)(1)(iii))

Please enter any additional information.

Enter associated file name reference.

RecordId

FacilityName

SiteName

AddressFlag

AddressLine1

AddressLine2

CityName

CountyName

StateName

ZipCode

SiteDescription

SiteLatitude

SiteLongitude

StateFacId

PeriodStartDate

PeriodEndDate

AddInfo

AddFile

e.g.: ABC Company XYZ Compressor Station

e.g.: ABC Company

e.g.: XYZ Compressor Station

e.g.: No

e.g.:

e.g.:

e.g.:

e.g.: Cook

e.g.: IL

e.g.:

e.g.: 7 miles NE of the intersection of Hwy 123 and Hwy 456

e.g.: 34.12345

e.g.: -101.12345

e.g.:

e.g.: 01/01/16

e.g.: 06/30/16

e.g.:

e.g.: addlinfo.zip

e.g.: DEF Company DEF Well Site

e.g.: DEF Company

e.g.: DEF Well Site

e.g.: Yes

e.g.: 456 Broad Street

e.g.: Suite 250

e.g.: Houston

e.g.: Houston

e.g.: TX

e.g.: 77002

e.g.:

e.g.:

e.g.:

e.g.:

e.g.: 01/01/18

e.g.: 06/30/18

e.g.:

e.g.: DEFWellSite.pdf

---

Sheet 3: Associated Well ID

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.5420a(b) Annual Report
(b)(1) The general information specified in paragraphs (b)(1)(i) through (iv) of this section is required for all reports.
(i) ...US Well ID or US Well ID associated with the affected facility, if applicable…
Note: This tab is only required for affected facilities that are associated with a Well ID. Site Record No. selections appear once Facility Site Name(s) are added to Site Information worksheet. Each row should contain one facility and one Well ID. If multiple wells are associated with an affected facility, add a line for each Well ID associated with the affected facility. If a single Well ID is associated with multiple affected facilities, list each affected facility to which it is associated on a separate line.
Site Record No. (Select from dropdown list)	Affected Facility Identification (§60.5420a(b)(1)(i))	Type of Affected Facility	US Well ID or US Well ID Associated with the Affected Facility (§60.5420a(b)(1)(i))
RecordId	AffectedFacID	AffectedFacType	WellId
e.g.: DEF Company DEF Well Site	e.g.: Comp-12a	e.g.: centrifugal compressor	e.g.: 12-345-67890-12

---

Sheet 4: General Info

Based on your answers to the following questions, relevant tabs will stay visible or be hidden in this workbook.
This worksheet is optional. You are not required to provide the information below.
Will you be reporting for the following affected facilities:
Wells?
Centrifugal Compressor?
Reciprocating Compressor?
Pneumatic Controller?
Storage Vessel?
Collection of Fugitive Emissions Components?
Pneumatic Pump?
Sweetening Unit?
For Collections of Fugitives:
Do you need to report information for a fugitive monitoring survey?
Do you need to report information for a collection of fugitive emissions components complying with an alternative fugitive emissions standard under §60.5399a?
If you are complying with an alternative fugitive emissions standard under §60.5399a, are you required to report information specified in §60.5420a(b)(7)(i) and (ii) because the reports required by the alternative fugitive emission standard are not site-specific?
Are you required to report information on cover and closed vent system inspections and monitoring for reciprocating compressors, centrifugal compressors, storage vessels or pneumatic pumps?
Do you need to report deviations for a well, centrifugal compressor, reciprocating compressor, pneumatic controller, storage vessel, pneumatic pump, or a control device tested by the device manufacturer under §60.5413a(d)?

---

Sheet 5: Well

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.5420a(b) Annual Report

For each well affected facility that is subject to §60.5375a(a) or (f), the records of each well completion operation conducted during the reporting period, including the information specified in §60.5420a(b)(2)(i) through (xiv), if applicable. In lieu of submitting the records specified in (b)(2)(i) through (xiv), the owner or operator may submit a list of each well completion with hydraulic fracturing and the digital photograph required by (c)(1)(v). For each well affected facility that routes flowback entirely through one or more production separators, only the information required by (b)(2)(i) through (b)(2)(iv) and (b)(2)(vi) are required to be reported.

For periods where salable gas is unable to be separated, the information required by (b)(2)(iv) and (b)(2)(viii) through (xii) must also be reported, as applicable.

For each well affected facility that is subject to §60.5375a(g), the information required by (b)(2)(xv) is required to be reported.

Note: Deviation information required by §60.5420a(b)(2)(xii) should be reported on the Deviations tab. List each well completion operation conducted during the reporting period on a separate line. Site Record No. selections appear once Facility Site Name(s) are added to Site Information worksheet. If you provide answers in Columns D, F, H, L, Y and/or AB, cells that are not relevant will be shaded in black.

Site Record No. (Select from dropdown list)

Identification of Affected Well (§60.5420a(b)(1)(ii), §60.5420a(b)(2)(iii))

Does the well produce less than 300 scf of gas per stock tank barrel of oil produced? (Select from dropdown list)

List the attachment file name that contains the supporting analysis performed in order to make that claim. List each well on a separate line. (§60.5420a(b)(2)(xv))

Are you submitting a digital photo in lieu of the records specified in §60.5420a(b)(2)(i) through (b)(2)(xiv)? (Select from dropdown list)

§60.5410a(a)(4) For each well affected facility subject to both §60.5375a(a)(1) and (3), as an alternative to retaining the records specified in §60.5420a(c)(1)(i) through (iv), you may maintain records in accordance with §60.5420a(c)(1)(v) of one or more digital photographs with the date the photograph was taken and the latitude and longitude of the well site imbedded within or stored with the digital file showing the equipment for storing or re-injecting recovered liquid, equipment for routing recovered gas to the gas flow line and the completion combustion device (if applicable) connected to and operating at each well completion operation that occurred during the initial compliance period. As an alternative to imbedded latitude and longitude within the digital photograph, the digital photograph may consist of a photograph of the equipment connected and operating at each well completion operation with a photograph of a separately operating GPS device within the same digital picture, provided the latitude and longitude output of the GPS unit can be clearly read in the digital photograph. List the attachment file name that contains the digital photograph that meets the requirements of §60.5410a(a)(4). List each event on a separate line. (§60.5420a(b)(2))

Latitude of the Well (decimal degrees to 5 decimals using the North American Datum of 1983) (§60.5420a(b)(2)(ii))

Longitude of the Well (decimal degrees to 5 decimals using the North American Datum of 1983) (§60.5420a(b)(2)(ii))

Well Completion ID (§60.5420a(b)(2)(i))

Did the well immediately start production following hydraulic fracturing or refracturing? (§60.5420a(b)(2)(iv) (Select from dropdown list)

Date of Onset of Flowback Following Hydraulic Fracturing or Refracturing (§60.5420a(b)(2)(iv))

Time of Onset of Flowback Following Hydraulic Fracturing or Refracturing (§60.5420a(b)(2)(iv))

Date of Attempt to Direct Flowback to a Separator as Required in §60.5375a(a)(1)(ii) (§60.5420a(b)(2)(v))

Time of Attempt to Direct Flowback to a Separator as Required in §60.5375a(a)(1)(ii) (§60.5420a(b)(2)(v))

Date Well was Shut In and Flowback Equipment was Permanently Disconnected or the Startup of Production (§60.5420a(b)(2)(vi))

Time Well was Shut In and Flowback Equipment was Permanently Disconnected or the Startup of Production (§60.5420a(b)(2)(vi))

Duration of Flowback (in hours) (§60.5420a(b)(2)(vii))

Duration of Recovery (in hours) (§60.5420a(b)(2)(viii))

Routed to the gas flow line or collection system should not be selected if you answered Yes in Column K. Disposition of Recovery (§60.5420a(b)(2)(viii)) (Select from dropdown list)

Duration of Combustion (in hours) (§60.5420a(b)(2)(ix))

Duration of Venting (in hours) (§60.5420a(b)(2)(x))

Specific Reasons for Venting In Lieu of Capture or Combustion (§60.5420a(b)(2)(xi))

60.5375a(f) (f) For each well affected facility specified in paragraphs (f)(1) and (2) of this section, you must comply with the requirements of paragraphs (f)(3) and (4) of this section. (1) Each well completion operation with hydraulic fracturing at a wildcat or delineation well. (2) Each well completion operation with hydraulic fracturing at a non-wildcat low pressure well or non-delineation low pressure well. Is the well affected facility subject to §60.5375a(f)? (Select from dropdown list)

Well Type (§60.5420a(b)(2)(xiii)) (Select from dropdown list)

List the attachment file name that contains the supporting inputs and calculations. (§60.5420a(b)(2)(xiii))

§60.5375a(a)(3) (3) If it is technically infeasible to route the recovered gas as required in §60.5375a(a)(1)(ii), then you must capture and direct recovered gas to a completion combustion device, except in conditions that may result in a fire hazard or explosion, or where high heat emissions from a completion combustion device may negatively impact tundra, permafrost or waterways. Completion combustion devices must be equipped with a reliable continuous pilot flame. Are you claiming an exception under §60.5375a(a)(3)? (Select from dropdown list)

Specific Exception Claimed (§60.5420a(b)(2)(xiv)) (Select from dropdown list)

Why the Well Meets the Claimed Exception (§60.5420a(b)(2)(xiv))

RecordId

AffectedWell

GasRequirementFlag

GasAnalysisFile

CompletionPhotoFlag

WellFile

AffWellLat

AffWellLong

WellCompletionId

WellProductionFlag

AffOnsetDate

AffOnsetTime

AffAttemptDate

AffAttemptTime

AffShutInDate

AffShutInTime

AffFlowbackHrs

AffRecoveryHrs

AffRecoveryDesc

AffCombustionHrs

AffVentingHrs

AffVentingReason

WellFlag

WellType

WellSupportingCalcs

WellExemptionFlag

ExcExceptionClaimed

ExcExceptionDesc

e.g.: DEF Company DEF Well Site

e.g.: 12-345-67890-12

e.g.: No

e.g.:

e.g.: No

e.g.:

e.g.: 38.88948

e.g.: -77.03526

e.g.: Completion ABC

e.g.: Yes, flowback was routed through a production separator and production immediately started

e.g.:

e.g.:

e.g.:

e.g.:

e.g.: 10/16/16

e.g.: 10:00 AM

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.: DEF Company ABC Well Site

e.g.: 12-345-67890-13

e.g.: No

e.g.:

e.g.: No

e.g.:

e.g.: 38.88950

e.g.: -77.03528

e.g.: Completion ABC

e.g.: No, production did not immediately start

e.g.: 11/16/16

e.g.: 10:00 AM

e.g.: 11/16/16

e.g.: 10:00 AM

e.g.: 11/16/16

e.g.: 10:00 AM

e.g.: 7

e.g.: 7

e.g.: Used as on onsite fuel source

e.g.: 7

e.g.: 7

e.g.: No onsite storage or combustion unit was available at the time of completion.

e.g.: No

e.g.:

e.g.:

e.g.: No

e.g.:

e.g.:

e.g.: DEF Company XYZ Well Site

e.g.: 12-345-67890-16

e.g.: Yes

e.g.: GORcalcs.pdf

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.: DEF Company 123 Well Site

e.g.: 12-345-67890-17

e.g.: No

e.g.:

e.g.: Yes

e.g.: completion16.pdf

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.: DEF Company 345 Well Site

e.g.: 12-345-67890-18

e.g.: No

e.g.:

e.g.: No

e.g.:

e.g.: 38.88950

e.g.: -77.03528

e.g.: Completion ABC

e.g.: Yes, flowback was routed through a production separator, but saleable gas was unable to be separated

e.g.:

e.g.:

e.g.:

e.g.:

e.g.: 11/16/16

e.g.: 10:00 AM

e.g.:

e.g.: 7

e.g.: Used as on onsite fuel source

e.g.: 7

e.g.: 7

e.g.: No onsite storage or combustion unit was available at the time of completion.

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.: DEF Company 678 Well Site

e.g.: 12-345-67890-19

e.g.: No

e.g.:

e.g.: No

e.g.:

e.g.: 38.88950

e.g.: -77.03528

e.g.: Completion ABC

e.g.: No, production did not immediately start

e.g.: 11/16/16

e.g.: 10:00 AM

e.g.: 11/16/16

e.g.: 10:00 AM

e.g.: 11/16/16

e.g.: 10:00 AM

e.g.: 7

e.g.: 7

e.g.: Used as on onsite fuel source

e.g.: 7

e.g.: 7

e.g.: No onsite storage or combustion unit was available at the time of completion.

e.g.: Yes

e.g.: Wildcat well

e.g.: supportingdata12.pdf

e.g.: Yes

e.g.: Technically infeasible to use for another useful purpose

e.g.:

---

Sheet 6: Centrifugal Compressor

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.5420a(b) Annual Report

For each centrifugal compressor affected facility, an owner or operator must include the information specified in §60.5420a(b)(3)(i) through (v) in all annual reports.

Note: Deviation information required by §60.5420a(b)(3)(ii) and (iv)(C) should be reported on the Deviations tab. Information required by §60.5420a(b)(3)(iii) should be reported on the Closed Vent Systems tab. Site Record No. selections appear once Facility Site Name(s) are added to Site Information worksheet. If you provide an answer in Columns E and/or F, cells that are not relevant will be shaded in black.

Centrifugal Compressors with Control

Centrifugal Compressors with Control Device Tested Under §60.5413a(d) Which Meets the Criteria in §60.5413a(d)(11) and §60.5413a(e)

Device Not Tested Under §60.5413a(d)

Visible Emissions Test Following Return to Operation From Maintenance or Repair

Site Record No. (Select from dropdown list)

Centrifugal Compressor ID (§60.5420a(b)(1)((ii), §60.5420a(b)(3)(i), §60.5420a(b)(3)(iv)(A))

Was the centrifugal compressor using a wet seal system and constructed, modified, or reconstructed during the reporting period? (§60.5420a(b)(3)(i)) (Select from dropdown list)

Was a control device used to reduce emissions? (Select from dropdown list)

Was the control device tested under §60.5413a(d)? (Select from dropdown list)

Was the control device returned to operation from a maintenance or repair activity? (Select from dropdown list)

Date the Performance Test Was Conducted (§60.5420a(b)(3)(v))

Pollutant(s) Tested (§60.5420a(b)(3)(v))

Make of Purchased Device (§60.5420a(b)(3)(iv)(B))

Model of Purchased Device (§60.5420a(b)(3)(iv)(B))

Date of Purchase (§60.5420a(b)(3)(iv)(B))

Date of Visible Emissions Test (§60.5420a(b)(3)(iv)(D))

Length of the Test (in minutes) (§60.5420a(b)(3)(iv)(D))

Amount of Time Visible Emissions Present (in minutes) (§60.5420a(b)(3)(iv)(D))

RecordId

CentCompressorId

CompressorConstruct

CompControlFlag

CompManfTestFlag

CompReturnOpFlag

CompTestDate

CompTestPollutant

WetDeviceMake

WetDeviceModel

WetPurchaseDate

CompVETestDate

CompVETestLength

CompVEMinutes

e.g.: ABC Company XYZ Compressor Station

e.g.: Comp-12a

e.g.: Constructed

e.g.: Yes

e.g.: Yes

e.g.: Yes

e.g.:

e.g.:

e.g.: Incinerator Guy

e.g.: 400 Combustor

e.g.: 12/10/16

e.g.: 10/15/20

e.g.: 60

e.g.: 0

e.g.: ABC Company XYZ Compressor Station

e.g.: Comp-12c

e.g.: Modified

e.g: No

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.: ABC Company XYZ Compressor Station

e.g.: Comp-12d

e.g.: Reconstructed

e.g.: Yes

e.g.: No

e.g.:

e.g.: 10/16/20

e.g.: THC

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

---

Sheet 7: Reciprocating Compressor

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.5420a(b) Annual Report
For each reciprocating compressor affected facility, an owner or operator must include the information specified in §60.5420a(b)(4)(i) through (iii) in all annual reports.
Note: Deviation information required by §60.5420a(b)(4)(ii) should be reported on the Deviations tab. Information required by §60.5420a(b)(4)(iii) should be reported on the Closed Vent Systems tab. Site
Record No. selections appear once Facility Site Name(s) are added to Site Information worksheet. If you answer yes in Column D, cells that are not relevant will be shaded in black.
Site Record No. (Select from dropdown list)	Reciprocating Compressor ID (§60.5420a(b)(1)(ii))	Are emissions from the rod packing being routed to a process through a closed vent system under negative pressure? (§60.5420a(b)(4)(i)) (Select from dropdown list)	What are the cumulative number of hours or months of operation since initial startup, since August 2, 2016, or since the previous reciprocating compressor rod packing replacement (whichever is later)? (§60.5420a(b)(4)(i))	Units of Time Measurement (§60.5420a(b)(4)(i)) (Select from dropdown list)
RecordId	RecipCompressorID	RodEmissionsFlag	OpCumTime	OpCumUnit
e.g.: ABC Company XYZ Compressor Station	e.g.: Comp-12b	e.g.: Yes	e.g.:	e.g.:
e.g.: ABC Company 123 Compressor Station	e.g.: Comp-6a	e.g.: No	e.g.: 6	e.g.: months

---

Sheet 8: Controllers

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.5420a(b) Annual Report
For each pneumatic controller affected facility, an owner or operator must include the information specified in §60.5420a(b)(5)(i) through (iii) in all annual reports.
Note: Deviation information required by §60.5420a(b)(5)(iii) should be reported on the Deviations tab. Site Record No. selections appear once Facility Site Name(s) are added to Site Information worksheet. If you answer no in Column D and/or G, cells that are
not relevant will be shaded in black.
Site Record No. (Select from dropdown list)	Pneumatic Controller Identification (must allow traceability to the records in §60.5420a(c)(4)(iii) and (iv)) (§60.5420a(b)(1)(ii), (b)(5)(i))	Was the pneumatic controller constructed, modified, or reconstructed during the reporting period? (§60.5420a(b)(5)(i)) (Select from dropdown list)	Month of Installation, Reconstruction, or Modification (§60.5420a(b)(5)(i)) (Select from dropdown list)	Year of Installation, Reconstruction, or Modification (§60.5420a(b)(5)(i))	Does the pneumatic controller affected facility have a natural gas bleed rate greater than the applicable standard? (§60.5420a(b)(5)(ii)) (Select from dropdown list)	Reason(s) Why the Pneumatic Controller Affected Facility has a Natural Gas Bleed Rate Greater than the Applicable Standard (§60.5420a(b)(5)(ii))
RecordId	ControllerId	ControllerConstruct	ConstructMonth	ConstructYear	CtrlBleedRateFlag	CtrlBleedRateReason
e.g.: DEF Company DEF Well Site	e.g.: Controller 12A	e.g.: Reconstructed	e.g.: March	e.g.: 2017	e.g.: No	e.g.:
e.g.: DEF Company DEF Well Site	e.g.: Controller 12B	e.g.: No	e.g.:	e.g.:	e.g.: Yes	e.g.: safety bypass controller requires use of a high-bleed controller

---

Sheet 9: Storage Vessels

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.5420a(b) Annual Report

For each storage vessel affected facility, an owner or operator must include the information specified in §60.5420a(b)(6)(i) through (ix) in all annual reports:

Note: Deviation information required by §60.5420a(b)(6)(iii) and (v)(C) should be reported on the Deviations tab. Information required by §60.5420a(b)(6)(vii) should be reported on the Closed Vent Systems tab. Site Record No. selections appear once Facility Site Name(s) are added to Site Information worksheet. Depending on answers in Columns D, H, J, M, N, and O, cells that are not relevant will be shaded in black.

Storage Vessels with Control

Storage Vessels with Control Device Tested Under §60.5413a(d) Which Meets the Criteria in §60.5413a(d)(11) and §60.5413a(e)

Device Not Tested Under §60.5413a(d)

Visible Emissions Test Following Return to Operation From Maintenance or Repair

Site Record No. (Select from dropdown list)

Storage Vessel ID (§60.5420a(b)(1)(ii), §60.5420a(b)(6)(i), §60.5420a(b)(6)(v)(A), §60.5420a(b)(6)(vi), §60.5420a(b)(6)(viii), §60.5420a(b)(6)(ix))

Was the storage vessel constructed, modified or reconstructed during the reporting period? (§60.5420a(b)(6)(i)) (Select from dropdown list)

Latitude of Storage Vessel (Decimal Degrees to 5 Decimals Using the North American Datum of 1983) (§60.5420a(b)(6)(i))

Longitude of Storage Vessel (Decimal Degrees to 5 Decimals Using the North American Datum of 1983) (§60.5420a(b)(6)(i))

§60.5410a(h)(2) and (3) (2) You must reduce VOC emissions in accordance with §60.5395a(a). (3) If you use a control device to reduce emissions, you must equip the storage vessel with a cover that meets the requirements of §60.5411a(b) and is connected through a closed vent system that meets the requirements of §60.5411a(c) and (d) to a control device that meets the conditions specified in §60.5412a(d) within 60 days after startup for storage vessels constructed, modified, or reconstructed at well sites with no other wells in production, or upon startup for storage vessels constructed, modified, or reconstructed at well sites with one or more wells already in production. Have you met the requirements specified in §60.5410a(h)(2) and (3)? (§60.5420a(b)(6)(iv)) (Select from dropdown list)

Was the storage vessel removed from service during the reporting period? (§60.5420a(b)(6)(viii)) (Select from dropdown list)

Date Removed from Service (§60.5420a(b)(6)(viii))

Was the storage vessel returned to service during the reporting period? (§60.5420a(b)(6)(ix)) (Select from dropdown list)

Date Returned to Service (§60.5420a(b)(6)(ix))

§60.5365a(e)(1) (1) A single storage vessel that commenced construction, reconstruction, or modification after September 18, 2015, and on or before November 16, 2020, is a storage vessel affected facility if its potential for VOC emissions is equal to or greater than 6 tons per year (tpy) as determined according to this paragraph (e)(1). The potential for VOC emissions must be calculated using a generally accepted model or calculation methodology, based on the maximum average daily throughput (as defined in §60.5430a) determined for a 30-day period prior to the applicable emission determination deadline specified in paragraphs (e)(2)(i) and (ii) of this section, except as provided in paragraph (e)(5)(iv). The determination may take into account requirements under a legally and practicably enforceable limit in an operating permit or other requirement established under a Federal, state, local, or tribal authority. Documentation of the VOC Emission Rate Determination According to §60.5365a(e)(1) (§60.5420a(b)(6)(ii))

§60.5395a(a)(2) (2) Reduce VOC emissions by 95.0 percent within 60 days after startup. For storage vessel affected facilities receiving liquids pursuant to the standards for well affected facilities in §60.5375a(a)(1)(i) or (ii), you must achieve the required emissions reductions within 60 days after startup of production as defined in §60.5430a. Does the storage vessel comply with §60.5395a(a)(2) using a control device? (Select from dropdown list)

Was the control device tested under §60.5413a(d)? (Select from dropdown list)

Was the control device returned to operation from a maintenance or repair activity? (Select from dropdown list)

Date the performance test was conducted (§60.5420a(b)(6)(vi))

Pollutant(s) tested (§60.5420a(b)(6)(vi))

Make of Control Device (§60.5420a(b)(6)(v)(B))

Model of Control Device (§60.5420a(b)(6)(v)(B))

Date of Purchase of Control Device (§60.5420a(b)(6)(v)(B))

Date of Visible Emissions Test (§60.5420a(b)(6)(v)(D))

Length of the Test (in minutes) (§60.5420a(b)(6)(v)(D))

Amount of Time Visible Emissions Present (in minutes) (§60.5420a(b)(6)(v)(D))

RecordId

VesselId

VesselConstruct

VesselLatitude

VesselLongitude

VesselRequirementFlag

VesselRemoveFlag

VesselRemoveDate

VesselReturnFlag

VesselReturnDate

VesselVocRateDesc

SVControlFlag

SvManfTestFlag

SvReturnOpFlag

SVTestDate

SVTestPollutant

SvMake

SvModel

SvPurchaseDate

SVVETestDate

SVVETestLength

SVVEMinutes

e.g.: DEF Company DEF Well Site

e.g.: Tank 125

e.g.: Constructed

e.g.: 34.12345

e.g.: -101.12345

e.g.: Yes

e.g.: Yes

e.g.: 11/15/20

e.g.: No

e.g.:

e.g.: VOC emission rate is 6.5 tpy. See file rate_determination.pdf for more information.

e.g.: Yes

e.g.: Yes

e.g.: Yes

e.g.:

e.g.:

e.g.: Incinerator Guy

e.g.: 400 Combustor

e.g.: 12/10/16

e.g.: 10/15/20

e.g.: 60

e.g.: 0

e.g.: DEF Company 123 Well Site

e.g.: Tank 120

e.g.: No

e.g.:

e.g.:

e.g.: Yes

e.g.: No

e.g.:

e.g.: Yes

e.g.: 11/15/20

e.g.: VOC emission rate is 6.5 tpy. See file rate_determination.pdf for more information.

e.g.: No

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.: DEF Company 123 Well Site

e.g.: Tank 121

e.g.: Reconstructed

e.g.: 34.12349

e.g.: -101.12349

e.g.: Yes

e.g.: No

e.g.:

e.g.: No

e.g.:

e.g.: VOC emission rate is 6.5 tpy. See file rate_determination.pdf for more information.

e.g.: Yes

e.g.: No

e.g.:

e.g.: 10/15/20

e.g.: THC

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

e.g.:

---

Sheet 10: Collection of Fugitives

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.5420a(b) Annual Report
For the collection of fugitive emissions components at each well site and the collection of fugitive emissions components at each compressor station, submit the information specified in §60.5420a(b)(7)(i), as applicable.
Note: Identification of Each Affected Facility selections appear once Facility Site Name(s) are added to Site Information worksheet. Depending on answers in Columns D, H, J, M, and N, cells that are not relevant will be shaded in black.
Identification of Each Affected Facility (§60.5420a(b)(1)(ii)) (Select from dropdown list)	Type of Site (§60.5420a(b)(7)(i)(A)) (Select from dropdown list)	Did this site become an affected facility during the reporting period? (Select from dropdown list)	Date of the Startup of Production or Date of the First Day of Production After Modification (§60.5420a(b)(7)(i)(B))	Date of Startup or the Date of Modification (§60.5420a(b)(7)(i)(B))	§60.5397a(a)(1) (i) First 30-day production. For the collection of fugitive emissions components at a well site, where the total production of the well site is at or below 15 barrels of oil equivalent (boe) per day for the first 30 days of production, according to §60.5415a(j), you must comply with the provisions of either paragraph (a)(1) or (2) of this section. Except as provided in this paragraph (a)(1)(i), the calculation must be performed within 45 days of the end of the first 30 days of production. To convert gas production to equivalent barrels of oil, divide the cubic feet of gas produced by 6,000. For well sites that commenced construction, reconstruction, or modification between October 15, 2019, and November 16, 2020, the owner or operator may use the records of the first 30 days of production after becoming subject to this subpart, if available, to determine if the total well site production is at or below 15 boe per day, provided this determination is completed by December 14, 2020. (ii) Well site production decline. For the collection of fugitive emissions components at a well site, where, at any time, the total production of the well site is at or below 15 boe per day based on a rolling 12-month average, you must comply with the provisions of either paragraph (a)(1) or (2) of this section. To convert gas production to equivalent barrels of oil, divide the cubic feet of gas produced by 6,000. Does the well site meet the conditions specified in either §60.5397a(a)(1)(i) or (ii)? (§60.5420a(b)(7)(i)(C)) (Select from dropdown list)	What is the total production for the well site? (boe per day) (§60.5420a(b)(7)(i)(C))	Did you complete the removal of all major production and processing equipment during the reporting period? (Select from dropdown list)	Date of Change to Status as a Wellhead Only Well Site (§60.5420a(b)(7)(i)(D))	During the reporting period, did you add back major production and processing equipment after previously reporting the removal of all major production and processing period? (Select from dropdown list)	Date First Piece of Major Production and Processing Equipment Was Added Back (§60.5420a(b)(7)(i)(E))
RecordId	SiteType	FugNewFlag	FugWellStartDate	FugCompStartDate	FugLowProdFlag	FugBOE	FugRemovalFlag	FugWellheadDate	FugAddBackFlag	FugAddBackDate
e.g.: ABC Company XYZ Compressor Station	e.g.: compressor station	e.g.: Yes	e.g.:	e.g.: 01/01/18	e.g.:	e.g.:	e.g.:	e.g.:	e.g.:	e.g.:
e.g.: DEF Company DEF Well Site	e.g.: well site	e.g.: No	e.g.:	e.g.:	e.g.: No	e.g.:	e.g.: Yes	e.g.: 01/01/18	e.g.:	e.g.:
e.g.: ABC Company GHI Well Site	e.g.: well site	e.g.: Yes	e.g.: 01/01/18	e.g.:	e.g.: Yes	e.g.: 12	e.g.: No	e.g.:	e.g.:	e.g.:
e.g.: DEF Company JKL Well Site	e.g.: well site	e.g.: No	e.g.:	e.g.:	e.g.: No	e.g.:	e.g.: No	e.g.:	e.g.: Yes	e.g.: 01/01/18

---

Sheet 11: Fugitive Surveys

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.5420a(b) Annual Report
For the collection of fugitive emissions components at each well site and the collection of fugitive emissions components at each compressor station, submit the information specified in §60.5420a(b)(7)(ii), as applicable.
For each fugitive emissions monitoring survey performed during the annual reporting period, the information specified in §60.5420a(b)(7)(ii)(A) through (G). (Information will be continued on Fugitives Found Tab.)
Note: Identification of Each Affected Facility selections appear once Facility Site Name(s) are added to Site Information worksheet. Only suveys with a yes in Column E will appear on the Fugitives Found worksheet.
Identification of Each Affected Facility (§60.5420a(b)(1)(ii)) (Select from dropdown list)	Date of Survey (§60.5420a(b)(7)(ii)(A))	Do you need to report fugitives found during the survey? (§60.5420a(b)(7)(ii)(D)) (Select from dropdown list)	Monitoring Instrument Used (§60.5420a(b)(7)(ii)(B))	§60.5397a(c)(1), (2), (7), and (8)(i) (1) Frequency for conducting surveys. Surveys must be conducted at least as frequently as required by paragraphs (f) and (g) of this section. (2) Technique for determining fugitive emissions (i.e., Method 21 of appendix A-7 to this part or optical gas imaging meeting the requirements in paragraphs (c)(7)(i) through (vii) of this section). (7) If you are using optical gas imaging, your plan must also include the elements specified in paragraphs (c)(7)(i) through (vii) of this section. (i) Verification that your optical gas imaging equipment meets the specifications of paragraphs (c)(7)(i)(A) and (B) of this section. This verification is an initial verification, and may either be performed by the facility, by the manufacturer, or by a third party. For the purposes of complying with the fugitive emissions monitoring program with optical gas imaging, a fugitive emission is defined as any visible emissions observed using optical gas imaging. (A) Your optical gas imaging equipment must be capable of imaging gases in the spectral range for the compound of highest concentration in the potential fugitive emissions. (B) Your optical gas imaging equipment must be capable of imaging a gas that is half methane, half propane at a concentration of 10,000 ppm at a flow rate of ≤60g/hr from a quarter inch diameter orifice. (ii) Procedure for a daily verification check. (iii) Procedure for determining the operator's maximum viewing distance from the equipment and how the operator will ensure that this distance is maintained. (iv) Procedure for determining maximum wind speed during which monitoring can be performed and how the operator will ensure monitoring occurs only at wind speeds below this threshold. (v) Procedures for conducting surveys, including the items specified in paragraphs (c)(7)(v)(A) through (C) of this section. (A) How the operator will ensure an adequate thermal background is present in order to view potential fugitive emissions. (B) How the operator will deal with adverse monitoring conditions, such as wind. (C) How the operator will deal with interferences (e.g., steam). (vi) Training and experience needed prior to performing surveys. (vii) Procedures for calibration and maintenance. At a minimum, procedures must comply with those recommended by the manufacturer. (8) If you are using Method 21 of appendix A-7 of this part, your plan must also include the elements specified in paragraphs (c)(8)(i) through (iii) of this section. For the purposes of complying with the fugitive emissions monitoring program using Method 21 of appendix A-7 of this part a fugitive emission is defined as an instrument reading of 500 ppm or greater. (i) Verification that your monitoring equipment meets the requirements specified in Section 6.0 of Method 21 at 40 CFR part 60, appendix A-7. For purposes of instrument capability, the fugitive emissions definition shall be 500 ppm or greater methane using a FID-based instrument. If you wish to use an analyzer other than a FID-based instrument, you must develop a site-specific fugitive emission definition that would be equivalent to 500 ppm methane using a FID-based instrument (e.g., 10.6 eV PID with a specified isobutylene concentration as the fugitive emission definition would provide equivalent response to your compound of interest). Deviations From Monitoring Plan Elements Under §60.5397a(c)(1), (2), (7), and (8)(i) or Statement that There Were No Deviations From These Monitoring Plan Elements (§60.5420a(b)(7)(ii)(C))	Date of Planned Shutdown(s) that Occurred During the Reporting Period if Components are on Delay of Repair (§60.5420a(b)(7)(ii)(G))
RecordId	SurveyDate	FugFlag	MonitoringInstrument	PlanDeviation	FugShutdownDate
e.g.: ABC Company XYZ Compressor Station	e.g.: 01/15/20	e.g.: yes	e.g.: Company ABC optical gas imaging camera	e.g.: There were no deviations from the monitoring plan.	e.g.: 01/02/20

---

Sheet 12: Fugitives Found

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.5420a(b) Annual Report
For the collection of fugitive emissions components at each well site and the collection of fugitive emissions components at each compressor station, submit the information specified in §60.5420a(b)(7)(ii), as applicable.
For each fugitive emissions monitoring survey performed during the annual reporting period, the information specified in §60.5420a(b)(7)(ii)(A) through (G). (Information continued from Fugitive Survey Tab.)
Note: Affected Facility and Survey Date selections appear once information is added to Fugitive Surveys worksheet. Depending on answers in Columns D and H, cells that are not relevant will be shaded in black.
Affected Facility and Survey Date (§60.5420a(b)(7)(ii)) (Select from dropdown list)	Type of Component for which Fugitive Emissions Detected (§60.5420a(b)(7)(ii)(D)) (Select from dropdown list)	Type of Component If "Other" Selected in Column D (§60.5420a(b)(7)(ii)(D))	Number of Each Component Type for which Fugitive Emissions Detected (§60.5420a(b)(7)(ii)(D))	§60.5397a(h) (h) Each identified source of fugitive emissions shall be repaired, as defined in §60.5430a, in accordance with paragraphs (h)(1) and (2) of this section. (1) A first attempt at repair shall be made no later than 30 calendar days after detection of the fugitive emissions. (2) Repair shall be completed as soon as practicable, but no later than 30 calendar days after the first attempt at repair as required in paragraph (h)(1) of this section. (3) If the repair is technically infeasible, would require a vent blowdown, a compressor station shutdown, a well shutdown or well shut-in, or would be unsafe to repair during operation of the unit, the repair must be completed during the next scheduled compressor station shutdown for maintenance, scheduled well shutdown, scheduled well shut-in, after a scheduled vent blowdown, or within 2 years, whichever is earliest. For purposes of this paragraph (h)(3), a vent blowdown is the opening of one or more blowdown valves to depressurize major production and processing equipment, other than a storage vessel. (4) Each identified source of fugitive emissions must be resurveyed to complete repair according to the requirements in paragraphs (h)(4)(i) through (iv) of this section, to ensure that there are no fugitive emissions. Number of Each Component Type Not Repaired as Required in §60.5397a(h) (§60.5420a(b)(7)(ii)(E))	Number of Each Component Type Placed on Delay of Repair (§60.5420a(b)(7)(ii)(F))	Explanation for Delay of Repair (§60.5420a(b)(7)(ii)(F))
FugSurvey	FugitiveType	FugOtherType	FugitiveNum	NotRepairedNum	DelayRepairNum	DelayRepairExplanation
e.g.: ABC Company XYZ Compressor Station 01/05/21	e.g.: thief hatch	e.g.:	e.g.: 2	e.g.: 1	e.g.: 1	e.g.: Unsafe to repair until next shutdown
e.g.: ABC Company XYZ Compressor Station 01/05/21	e.g.: valve	e.g.:	e.g.: 1	e.g.: 1	e.g.: 0	e.g.:
e.g.: ABC Company XYZ Compressor Station 01/05/21	e.g.: connector	e.g.:	e.g.: 2	e.g.: 0	e.g.: 0	e.g.:
e.g.: ABC Company XYZ Compressor Station 01/05/21	e.g.: flange	e.g.:	e.g.: 1	e.g.: 0	e.g.: 0	e.g.:

---

Sheet 13: Alternative Fugitive

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.5420a(b) Annual Report
For the collection of fugitive emissions components at each well site and the collection of fugitive emissions components at each compressor station, submit the information specified in §60.5420a(b)(7)(iii), as applicable.
For each collection of fugitive emissions components at a well site or collection of fugitive emissions components at a compressor station complying with an alternative fugitive emissions standard under §60.5399a, in lieu of the
information specified in §60.5420a(b)(7)(i) and (ii), you must provide the information specified in §60.5420a(b)(7)(iii)(A) through (C).
Note: Identification of Each Affected Facility selections appear once Facility Site Name(s) are added to Site Information worksheet. If you answer "No" in Column E, you must provide the information specified in §60.5420a(b)(7)(i) and (ii).
Identification of Each Affected Facility (§60.5420a(b)(1)(ii)) (Select from dropdown list)	The alternative standard with which you are complying. (§60.5420a(b)(7)(iii)(A))	Is the report specified by the alternative fugitive emission standard site-specific? (Select from dropdown list)	If you answered "Yes" in Column E, list the attachment file name that contains the site-specific report specified by the alternative fugitive emissions standard. (§60.5420a(b)(7)(iii)(B))
RecordId	FugAltStandard	FugAltReportFlag	FugAltReportFile
e.g.: DEF Company Well Site ABC	e.g.: Ohio General Permit 18.1, effective February 7, 2017	e.g.: Yes	e.g.: wellsiteabc2020survey.pdf
e.g.: GHI Company Well Site MNO	e.g.: Colorado Regulation 7, Part D, §I.L or II.E, effective February 14, 2020	e.g.: No	e.g.:

---

Sheet 14: Pneumatic Pumps

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.5420a(b) Annual Report
For each pneumatic pump affected facility, an owner or operator must include the information specified in §60.5420a(b)(8)(i) through (iv) in all annual reports.
Note: Deviation information required by §60.5420a(b)(8)(iii) should be reported on the Deviations tab. Information required by §60.5420a(b)(8)(iv) should be reported on the Closed Vent Systems tab. Site Record No. selections appear once Facility Site Name(s) are added to Site Information worksheet. Depending on answers in
Columns D, E, and G, cells that are not relevant will be shaded in black.
Site Record No. (Select from dropdown list)	Pump ID (§60.5420a(b)(1)(ii), §60.5420a(b)(8)(ii))	Was the pneumatic pump constructed, modified, or reconstructed during the reporting period? (§60.5420a(b)(8)(i)) (Select from dropdown list)	What condition does the pneumatic pump meet? (§60.5420a(b)(8)(i)) (Select from dropdown list)	Date Pump Was Previously Reported (§60.5420a(b)(8)(ii))	Which condition does the pneumatic pump meet? * (§60.5420a(b)(8)(ii)) (Select from dropdown list)	What is the percent emissions reduction the control device is designed to achieve? (§§60.5420a(b)(8)(i)(C) and (ii)(A))
RecordId	PumpId	PumpConstruct	PumpCondition	PumpChangeDate	PumpChangeCondition	PumpReductionPercent
e.g.: DEF Company DEF Well Site	e.g.: Pump 12	e.g.: Constructed	e.g.: §60.5420a(b)(8)(i)(C)-Emissions are routed to a control device or process that achieves less than 95% emissions reduction.	e.g.:	e.g.:	e.g.: 90.50%
e.g.: DEF Company ABC Well Site	e.g.: Pump 22	e.g.: No	e.g.:	e.g.: 10/10/17	e.g.: §60.5420a(b)(8)(ii)(A)-A control device was added, and emissions are routed to a control device or process that achieves less than 95% emissions reduction.	e.g.: 90.50%
e.g.: DEF Company 123 Well Site	e.g.: Pump 15	e.g.: No	e.g.:	e.g.: 10/01/18	e.g.: §60.5420a(b)(8)(ii)(D)-A control device or process has been removed from the location or otherwise is no longer available, and it is technically infeasible to capture and route the emissions to an on site control device or process.	e.g.:
e.g.: DEF Company XYZ Well Site	e.g.: Pump 27	e.g.: Modified	e.g.: §60.5420a(b)(8)(i)(A)-No control device or process is available on site.	e.g.:	e.g.:	e.g.:

---

Sheet 15: Sweetening Unit

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.5420a(b) Annual Report
§60.5423a What additional recordkeeping and reporting requirements apply to my sweetening unit affected facilities at onshore natural gas processing plants? You must submit a report of excess emissions to the Administrator in your annual report if you had excess emissions during the reporting period. The report must contain
the information specified in paragraph (b)(3).
Note: Site Record No. selections appear once Facility Site Name(s) are added to Site Information worksheet. Depending on the answer in Column H, cells that are not relevant will be shaded in black.
Site Record No. (Select from dropdown list)	Identification of Sweetening Unit (§60.5420a(b)(1)(ii))	Time of Commencement of Excess Emissions Period (§60.5423a(b)(3)(i))	Date of Commencement of Excess Emissions Period (§60.5423a(b)(3)(i))	Time of Completion of Excess Emissions Period (§60.5423a(b)(3)(i))	Date of Completion of Excess Emissions Period (§60.5423a(b)(3)(i))	Which type of excess emissions is this? (Select from dropdown list)	Required Minimum Efficiency (Z) (§60.5423a(b)(3)(ii))	Actual Average Sulfur Emissions Reduction Efficiency (R) (§60.5423a(b)(3)(ii))	Appropriate Operating Temperature (§60.5423a(b)(3)(iii))	Actual Average Temperature of the Gases Leaving the Combustion Zone (§60.5423a(b)(3)(iii))
RecordId	SweeteningID	ExcessTimeStart	ExcessDateStart	ExcessTimeStop	ExcessDateStop	ExcessEventType	ReqMinEfficiency	AvgSulfurReduction	OpTemp	AvgExitGasTemp
e.g.: ABC Company XYZ Compressor Station	e.g.: Sweetening Unit 1	e.g.: 10:00 AM	e.g.: 01/01/19	e.g.: 2:00 PM	e.g.: 01/02/19	e.g.: Sulfur emission reduction efficiency	e.g.: 97.50	e.g.: 95.00	e.g.:	e.g.:
e.g.: ABC Company XYZ Compressor Station	e.g.: Sweetening Unit 2	e.g.: 10:00 AM	e.g.: 01/01/19	e.g.: 2:00 PM	e.g.: 01/02/19	e.g.: Temperature of the gases leaving the combustion zone	e.g.:	e.g.:	e.g.: 820 C	e.g.: 750 C

---

Sheet 16: Closed Vent Systems

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.5420a(b) Annual Report
If required to comply with §60.5380a(a)(2), §60.5385a(a)(3), §60.5395a(b)(1), or §60.5393a(b), include the information required in this worksheet.
Note: Site Record No. selections appear once Facility Site Name(s) are added to Site Information worksheet. Enter a date into either Column G or H, depending on whether the repair has been completed. The column not used will be blacked out.
Site Record No. (Select from dropdown list)	Type of Affected Facility (§60.5420a(b)(1)(ii)) (Select from dropdown list)	Identification of Affected Facility (§60.5420a(b)(1)(ii))	Date of Inspection (§60.5420a(b)(3)(iii)(A), §60.5420a(b)(4)(iii)(A), §60.5420a(b)(6)(vii)(A), §60.5420a(b)(8)(iv)(A))	Leak or Defect Identified During Inspection (§60.5420a(b)(3)(iii)(B), §60.5420a(b)(4)(iii)(B), §60.5420a(b)(6)(vii)(B), §60.5420a(b)(8)(iv)(B))	Date of Repair (§60.5420a(b)(3)(iii)(B), §60.5420a(b)(4)(iii)(B), §60.5420a(b)(6)(vii)(B), §60.5420a(b)(8)(iv)(B))	Anticipated Date of Repair (§60.5420a(b)(3)(iii)(B), §60.5420a(b)(4)(iii)(B), §60.5420a(b)(6)(vii)(B), §60.5420a(b)(8)(iv)(B))	Date of Bypass Alarm or Key Checked Out (§60.5420a(b)(3)(iii)(C), §60.5420a(b)(4)(iii)(C), §60.5420a(b)(6)(vii)(C), §60.5420a(b)(8)(iv)(C))	Time of Bypass Alarm or Key Checked Out (§60.5420a(b)(3)(iii)(C), §60.5420a(b)(4)(iii)(C), §60.5420a(b)(6)(vii)(C), §60.5420a(b)(8)(iv)(C))	List the attachment file name that contains the certification signed by a qualified professional engineer or in-house engineer for each closed vent system routing to a control device or process. (§60.5420a(b)(12))
RecordId	CVSFacType	CVSFacID	CVSInspectDate	CVSDefect	CVSRepairDate	CVSAnticipatedDate	CVSBypassDate	CVSBypassTime	PeCertFile
e.g.: ABC Company XYZ Compressor Station	e.g.: centrifugal compressor	e.g.: Comp-S2a	e.g.: 10/16/20	e.g.: Compressor seal leaking	e.g.: 10/17/20	e.g.: 12/10/20	e.g.: 10/17/20	e.g.: 7:00 AM	e.g.: Certification.pdf

---

Sheet 17: Deviations

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.5420a(b) Annual Report
For each deviation that occurred during the reporting period and recorded as specified in §60.5420a(c), the date and time the deviation began, duration of the deviation and a description of the deviation.
For each instance where the inlet gas flow rate exceeds the manufacturer’s listed maximum gas flow rate, where there is no indication of the presence of a pilot flame, or where visible emissions exceeded 1 minute in any 15-minute period, include the date and time the deviation began, the duration of the deviation, and a description of the deviation.
Note: Site Record No. selections appear once Facility Site Name(s) are added to Site Information worksheet. Depending on the answer in Columns C and E, cells that are not relevant will be shaded in black.
Site Record No. (Select from dropdown list)	Type of Affected Facility (§60.5420a(b)(1)(ii)) (Select from dropdown list)	Identification of Affected Facility (§60.5420a(b)(1)(ii))	Is this a deviation of a control device tested under §60.5413a(d) which meets the criteria in §60.5413a(d)(11) and §60.5413a(e)? (§60.5420a(b)(3)(iv)(C), §60.5420a(b)(6)(v)(C)) (Select from dropdown list)	Type of Deviation (§60.5420a(b)(3)(iv)(C), §60.5420a(b)(6)(v)(C)) (Select from dropdown list)	Description of Deviation (§60.5420a(b)(2)(xii), §60.5420a(b)(3)(ii), §60.5420a(b)(4)(ii), §60.5420a(b)(5)(iii), §60.5420a(b)(6)(iii), §60.5420a(b)(8)(iii))	Date Deviation Began (§60.5420a(b)(2)(xii), §60.5420a(b)(3)(ii), §60.5420a(b)(3)(iv)(C), §60.5420a(b)(4)(ii), §60.5420a(b)(5)(iii), §60.5420a(b)(6)(iii), §60.5420a(b)(6)(v)(C), §60.5420a(b)(8)(iii))	Time Deviation Began (§60.5420a(b)(2)(xii), §60.5420a(b)(3)(ii), §60.5420a(b)(3)(iv)(C), §60.5420a(b)(4)(ii), §60.5420a(b)(5)(iii), §60.5420a(b)(6)(iii), §60.5420a(b)(6)(v)(C), §60.5420a(b)(8)(iii))	Duration of Deviation (§60.5420a(b)(2)(xii), §60.5420a(b)(3)(ii), §60.5420a(b)(3)(iv)(C), §60.5420a(b)(4)(ii), §60.5420a(b)(5)(iii), §60.5420a(b)(6)(iii), §60.5420a(b)(6)(v)(C), §60.5420a(b)(8)(iii))	Units of Time for Duration (§60.5420a(b)(2)(xii), §60.5420a(b)(3)(ii), §60.5420a(b)(3)(iv)(C), §60.5420a(b)(4)(ii), §60.5420a(b)(5)(iii), §60.5420a(b)(6)(iii), §60.5420a(b)(6)(v)(C), §60.5420a(b)(8)(iii)) (Select from dropdown list)
RecordId	DeviationFacType	DeviationFacID	DeviationManfTestFlag	DeviationType	DeviationDesc	DeviationStartDate	DeviationStartTime	DeviationDuration	DeviationDurationUnits
e.g.: ABC Company XYZ Compressor Station	e.g.: centrifugal compressor	e.g.: Comp-2A-1	e.g.: Yes	e.g.: No indication of the presence of a pilot flame	e.g.:	e.g.:10/16/20	e.g.: 10:00 AM	e.g.: 5	e.g.: hours
e.g.: DEF Company DEF Well Site	e.g.: well	e.g.: Pump 46	e.g.:	e.g.:	e.g.: A separator was not onsite for part of the flowback period.	e.g.:10/16/20	e.g.: 10:00 AM	e.g.: 5	e.g.: hours
e.g.: DEF Company DEF Well Site	e.g.: storage vessel	e.g.: Tank 345	e.g.: No	e.g.:	e.g.: A separator was not onsite for part of the flowback period.	e.g.:10/16/20	e.g.: 10:00 AM	e.g.: 5	e.g.: hours

---

Sheet 18: Revisions

Revision Number	Date	Description
1.00		Draft version that was never finalized
2.00		Draft version that was never finalized
3.00	4/8/2021	Finalized Release Version