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. |
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 |
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 |
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)? |
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.: |
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 |
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 |
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.: |
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.: |
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 |
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 |
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 |
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 |
File Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
File Modified | 0000-00-00 |
File Created | 0000-00-00 |