Form 5900-706 63.7951f Semiannual Compliance Report

NESHAP for Site Remediation (40 CFR part 63, subpart GGGGG) (Renewal)

63.7951f_semiannual_compliance_report_ICRDraft.xlsm

NESHAP for Site Remediation - Private Sector

OMB: 2060-0534

Document [xlsx]
Download: xlsx | pdf

Overview

Welcome
Company Information
No CMS - Deviation
Process_CMS_Identification
Deviation - CMS
Deviation - CMS Summary
Deviation - Limits
Deviation - Limits Summary
Number of Deviations
Info Pressure Relief Devices
Description of Changes
Info Press Tank Closure Device
Info on Control 1 Equip Leaks
Control 1 Initial Compliance
Info on Control 2 Equip Leaks
Control 2 Monitoring
Control 2 Initial Compliance
Compliance - Certification
Revisions


Sheet 1: Welcome

63.7951(f) Compliance Report (Version 2.06)
63.7951(f)
ICR Draft
5/8/2024
OMB No.: 2060-0534 Form 5900-706 For further Paperwork Reduction Act information see: https://www.epa.gov/electronic-reporting-air-emissions/paperwork-reduction-act-pra-cedri-and-ert
40 CFR Part 63, Subpart GGGGG National Emission Standards for Hazardous Air Pollutants: Site Remediation - §63.7951(f) Compliance Report Spreadsheet Template
Instructions for Spreadsheet Template

Purpose:
This spreadsheet template was designed by the U.S. EPA to facilitate Compliance reporting for facilities subject under the 40 CFR part 63, subpart GGGGG National Emission Standard for Hazardous Air Pollutants: Site Remediation.

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

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

For each facility record found in the "Company Information" worksheet, you may reference a single file attachment that includes additional information.
Do not submit information you claim as 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 requires EPA 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 the address in the referencing federal regulation. If no address is specified, mail the media to:

U.S. EPA/OAQPS/CORE CBI Office Attention: Group Leader,
Measurement Policy Group MD C404-02
4930 Old Page Rd
Durham, North Carolina 27703
IMPORTANT: The spreadsheet must be uploaded into CEDRI as a single ZIP file, which must include this Excel workbook and any related attachments that were referenced in the workbook (i.e., additional information file found in the "Company Information" worksheet).

Note: 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.

Once all data have been entered in the worksheet, combine this Excel workbook and all attachment files (including any ZIP file containing separate excel file(s), if applicable) into a single ZIP file for upload to CEDRI.

Please ensure your report includes all of the required data elements found in the listed citations below for this spreadsheet upload submission.
Template Navigation and Tabs to Complete:
White Tabs: The white tabs (Welcome and Revisions) contain instructions and information about the spreadsheet. t Gray Tabs: The gray tab (Company Information) contain general information that is likely to be unchanged from report to report. After completing the gray tabs, the workbook may be saved as a site specific template for use in subsequent reports to limit subsequent data entry.

Green Tabs: Green tabs (Process_CMS_Identification, Deviation - CMS, Deviation - CMS Summary, Deviation - Limits, Deviation - Limits Summary, Number of Deviations, Description of Changes, Info Pressure Relief Devices, Info Press Tank Closure Device, Info on Control 1 Equip Leaks, Control 1 Initial Compliance, Info on Control 2 Equip Leaks, Control 2 Monitoring, and Control 2 Initial Compliance) are to be completed as necessary to complete the Compliance report. Some cells are linked to previous tabs or are calculations dependant upon data entry.
Blue Tab: The blue tab (No CMS - Deviation) is to be completed for deviations that occur where there is no continuous monitoring system.

Yellow Tab: The yellow tab (Compliance - Certification) contain statements that apply to all facilities, regardless of wheter a continuous monitoring system is present.
Within the tabs, example rows are colored light red (rows 14 through 23), and the XML tags (row 13) are colored green. These rows are locked; no data entry is made in these rows.

Sheet 2: Company Information

40 CFR Part 63, Subpart GGGGG National Emission Standards for Hazardous Air Pollutants: Site Redmediation-












§63.7951(f) Compliance Report Spreadsheet Template












* Required Field













SITE INFORMATION
REPORTING PERIOD ADDITIONAL INFORMATION
Company Record No. *
(Field value will automatically generate if a value is not entered.)
Company Name *
(§63.7951(b)(1))
Address *
(§63.7951(b)(1))
Address 2 City *
(§63.7951(b)(1))
County State Abbreviation *
(§63.7951(b)(1))
Zip Code *
(§63.7951(b)(1))
Responsible Agency Facility ID
(State Facility Identifier)
Date of Report *
(§63.7951(b)(3))
Beginning Date of Reporting Period *
(§63.7951(b)(3))
Ending Date of
Reporting Period*
(§63.7951(b)(3))
Please enter any additional information. Enter associated file name reference.
RecordId CompanyName AddressLine1 AddressLine2 CityName CountyName StateName ZIPCode StateFacID ReportDate 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 e.g.: NY e.g.: 11221 e.g.: 9145555555 e.g.: 7/15/2020 e.g.: 01/01/2020 e.g.: 6/30/2020 e.g.: additional info e.g.: addlinfo.zip













































































































































Sheet 3: No CMS - Deviation

40 CFR Part 63, Subpart GGGGG National Emission Standards for Hazardous Air Pollutants: Site Redmediation-








§63.7951(f) Compliance Report Spreadsheet Template








* Required Field








Company Record No. *
(Select from dropdown)
Affected Source or Equipment *
(§63.7951(b)(7)(ii))
Total Operating Time During Reporting Period *
(§63.7951(b)(7)(i))
Date of Deviation *
(§63.7951(b)(7)(ii))
Time of
Deviation *
(§63.7951(b)(7)(ii))
Duration of Deviation *
(§63.7951(b)(7)(ii))
Estimate of the Quantity of Each Regulated Pollutant Emitted Over Any Emission Limit *
(§63.7951(b)(7)(ii))
Description of the Method Used to Estimate Emissions *
(§63.7951(b)(7)(ii))
Actions Taken to Minimize Emissions and Corrective Actions Taken to Return the Affected Unit to its Normal or Usual Manner of Operation*
(§63.7951(b)(7)(ii))
Cause of Deviation, including Unknown Causes*
(§63.7951(b)(7)(ii))
RecordId AffectedSource TotalOperatingTime DeviationStartDate DeviationStartTime DeviationDuration EmissionQuantity EstimationMethod CorrectiveAction DeviationCause
e.g.: 1 e.g. Line 1 eg.: 4380 hrs e.g.: 2/12/2017 e.g.: 13:05 e.g.: 72.00 hrs e.g.: benzyl chloride 0.65 lb; carbonyl sulfide 0.2 lb e.g.: Engineering calculations e.g.: replaced thermocouple e.g.: Other Known Causes

Sheet 4: Process_CMS_Identification

40 CFR Part 63, Subpart GGGGG National Emission Standards for Hazardous Air Pollutants: Site Redmediation-


§63.7951(f) Compliance Report Spreadsheet Template


* Required Field


Company Record No. *
(Select from dropdown)
Brief Description of Process Unit*
(§63.7951(b)(8)(viii))
Brief Description of CMS (CPMS or CEMS)*
(§63.7951(b)(8)(ix))
Date of Last CMS (CPMS or
CEMS)
Certification or Audit *
(§63.7951(b)(8)(x))
RecordId ProcessUnitDesc MonitorEqDesc CPMSAuditDate
e.g.: 1 e.g. Line 1 e.g.: TC1792 Inlet Temperature e.g.: 2/2/2017



















































































































































































































































































































Sheet 5: Deviation - CMS

40 CFR Part 63, Subpart GGGGG National Emission Standards for Hazardous Air Pollutants: Site Remediation-











§63.7951(f) Compliance Report Spreadsheet Template











* Required Field











Company Record No. *
(Autopopulated)
Brief Description of Process Unit*
(§63.7951(b)(8)(viii))
(Autopopulated)
Brief Description of CMS (CPMS or CEMS)*
(§63.7951(b)(8)(ix))
(Autopopulated)
Company Record No., Process Unit Description, and Brief Description of CMS
(§63.7951(b)(8)(viii) and (ix)) *
(Select from dropdown)
CMS Inoperative or
Out of Control * (§63.7951(b)(8)(ii) or (iii))
(Select from dropdown)
Starting Date CMS
Inoperative or Out of Control *
(§63.8(c)(8); §63.7951(b)(8)(ii) or (iii))
Time CMS Inoperative or Out of Control *
§63.7951(b)(8)(ii) or (iii))
Ending Date CMS Inoperative or
Out of Control *
(§63.8(c)(8); §63.7951(b)(8)(ii) and (iii)))
Duration CMS Out of Control or inoperative (hours) * (§63.8(c)(8);
§63.7951(b)(8)(iii)) and for calculation of Duration of CMS for Inoperative as a percent of Operating Time)
Description of Corrective Actions Taken *
(§63.8(c)(8); §63.7951(b)(8)(iii)))
Date of Deviation or Date Monitoring Data Not Collected *
(§63.7951(b)(8)(iv))
Duration of
Deviation or Duration Monitoring Data Not Collected *
(§63.7951(b)(8)(iv))
If Deviation Caused by Lack of Monitorning Data, Reason Monitoring Data Not Collected * (§63.7951(b)(8)(iv))
RecordId ProcessUnitDesc MonitorEqDesc CPMSDescription CMSOutageDescription CMSOutageStartDate CMSOutageStartTime CMSOutageEndDate CMSOutageDuration CorrectiveAction DeviationDate DeviationDuration NonMonitoringReason
e.g.: 1 e.g. Line 1 e.g.: TC1792 Inlet Temperature e.g. 1 Line 1 TC1792 Inlet Temperature e.g. Inoperative e.g.: 3/2/2017 e.g.: 15:52 e.g.: 3/2/2017 e.g.: 2 e.g.: replaced thermocouple e.g.: 2/12/2017 e.g. 3 hours e.g. loss of power


























































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 6: Deviation - CMS Summary

40 CFR Part 63, Subpart GGGGG National Emission Standards for Hazardous Air Pollutants: Site Remediation -




§63.7951(f) Compliance Report Spreadsheet Template




* Required Field




Company Record No. *
(Autocompleted)
Process Unit Description *
(§63.7951(b)(8)(viii))
(Autocompleted)
Brief Description of CMS *
(§63.7951(b)(8)(ix))
(Autocompleted)
Total Source
Operating Time *
(hours) (§63.7951(b)(8)(vii))
Total Duration of
CMS Downtime *
(hours)
(§63.7951(b)(8)(vii))
(Calculated value)
Total Duration of
CMS Downtime as
a percent of Total
Source Operating Time *
(§63.7951(d)(8)(vii))
(Calculated value)
RecordId ProcessUnitDesc MonitorEqDesc TotalOperatingTime CMSDowntimeDuration CMSDowntimePercent
e.g.: 1 e.g.: Line 1 e.g.: TC1792 Inlet Temperature e.g.: 4380 e.g.: 2 e.g.: 0.05%















































































































































































































































































































































































































































































Sheet 7: Deviation - Limits

40 CFR Part 63, Subpart GGGGG National Emission Standards for Hazardous Air Pollutants: Site Remediation -











§63.7951(f) Compliance Report Spreadsheet Template











* Required Field











Company Record No. *
(Autopopulated)
Brief Description of Process Unit*
(§63.7951(b)(8)(viii))
(Autopopulated)
Brief Description of CMS (CPMS or CEMS)*
(§63.7951(b)(8)(ix))
(Autopopulated)
Company Record No., Process Unit Description, and Brief Description of CMS
(§63.7951(b)(8)(viii) and (ix)) *
(Select from dropdown)
Applicable Operating Parameter Limit * (§63.7951(b)(8)(iv)) Daily Average of Monitored Operating Parameter *
(§63.7951(b)(8)(iv))
Date of Deviation*
(§63.7951(b)(8)(i) and (iv))
Time of
Deviation*
(§63.7951(b)(8)(i) and (iv))
Duration of
Deviation*
(hours)
(§63.7951(b)(8)(i) and (vi))
Cause of Deviation (including unknown causes) *
(§63.7951(b)(8)(i))
(Select from dropdown)
Actions Taken to Minimize Emissions and Corrective Action Taken to Return Affected Unit to Normal or Usual Operation *
(§63.7951(b)(8)(i))
Estimate of the Quantity of each Regulated Pollutant Emitted Over any Emission Limit *
(§63.7951(b)(8)(i))
Description of the Method Used to Estimate Emissions *
(§63.7951(b)(8)(i))
RecordId ProcessUnitDesc MonitorEqDesc CMSDescription ParameterLimit ParameterAverage DeviationStartDate DeviationStartTime DeviationDuration DeviationCause CorrectiveAction EmissionQuantity EstimationMethod
e.g.: 1 e.g. Line 1 e.g.: TC1792 Inlet Temperature e.g. 1 Line 1 TC1792 Inlet Temperature e.g.: Average condenser exit temperature, 50F e.g.: 48F e.g.: 2/12/2017 e.g.: 13:05 e.g.: 21.00 e.g.: Control Equipment Problems e.g.: replaced thermocouple e.g.: benzyl chloride 0.65 lb; carbonyl sulfide 0.2 lb e.g.: Engineering calculations

























































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 8: Deviation - Limits Summary

40 CFR Part 63, Subpart GGGGG National Emission Standards for Hazardous Air Pollutants: Site Remediation -









§63.7951(f) Compliance Report Spreadsheet Template









* Required Field









Company Record No. *
(Autopopulated)
Brief Description of Process Unit*
(§63.7951(b)(8)(viii))
(Autopopulated)
Brief Description of CMS (CPMS or CEMS)*
(§63.7951(b)(8)(ix))
(Autopopulated)
Applicable Operating Parameter Limit * (§63.7951(b)(8)(iv))
(Autocompleted)
Total Source
Operating Time *
(hours) (§63.7951(b)(8)(v))
Total Duration of
Deviations from
Emissions or Operating Limit *
(hours)
(§63.7951(b)(8)(v))
(Calculated value)
Total Duration of
Deviations from
Emissions or Operating Limit
as a percent of
Total Source Operating Time *
(§63.7951(b)(8)(v))
(Calculated value)
Total Duration of
Deviations from
Emissions or Operating Limit Due to
Control Equipment Problems *
(hours)
(§63.7951(b)(8)(vi))
(Calculated value)
Total Duration of
Deviations from
Emissions or Operating Limit Due to
Process Problems *
(hours)
(§63.7951(b)(8)(vi))
(Calculated value)
Total Duration of
Deviations from
Emissions or Operating Limit Due to
Other Known Causes *
(hours)
(§63.7951(b)(8)(vi))
(Calculated value)
Total Duration of
Deviations from
Emissions or Operating Limit Due to
Unknown Causes *
(hours)
(§63.7951(b)(8)(vi))
(Calculated value)
RecordId ProcessUnitDesc MonitorEqDesc ParameterLimit TotalOperatingTime TotalDeviationDuration TotalDeviationPercent EquipmentCausedDeviation ProcessCausedDeviation OtherCausedDeviation UnknownCausedDeviation
e.g.: 1 e.g. Line 1 e.g.: TC1792 Inlet Temperature e.g.: Average condenser exit temperature, 50F e.g.: 4300 e.g.: 21.18 e.g.: 0.49% e.g.: 21.18 e.g.: 0.00 e.g.: 0.00 e.g.: 0.00
















































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 9: Number of Deviations

40 CFR Part 63, Subpart GGGGG National Emission Standards for Hazardous Air Pollutants: Site Redmediation-


§63.7951(f) Compliance Report Spreadsheet Template


* Required Field


Company Record No. *
(Autofilled)
Affected Source *
(§63.7951(b)(7)(ii) and (8)(viii))
(Autofilled)
Number of Deviations From Emission or Operating Limits When not Using CMS*
(§63.7951(b)(7)(ii))
(Autofilled)
Number of Deviations From Emission or Operating Limits When Using CMS*
(§63.7951(b)(8)(i))
(Autofilled)
RecordId ProcessUnitDesc DeviationCountNonCMS DeviationCountCMS
e.g.: 1 e.g.: Line 1 e.g.: 0 e.g.: 0





















































































































































































































































































































Sheet 10: Info Pressure Relief Devices

40 CFR Part 63, Subpart GGGGG National Emission Standards for Hazardous Air Pollutants: Site Remediation -













§63.7951(f) Compliance Report Spreadsheet Template













* Required Field













Company Record No. *
(Select from dropdown)

Source of Pressure Release Actuation Event*
(§63.7951(b)(10)(iii)(C))
Nature of Pressure Release*
(§63.7951(b)(10)(iii)(C))
Cause of Pressure Release*
(§63.7951(b)(10)(iii)(C))
Start Date of Pressure Release*
(§63.7951(b)(10)(iii)(A))
Start Time of Pressure Release* (§63.7951(b)(10)(iii)(A)) End Date of Pressure Release* (§63.7951(b)(10)(iii)(A)) End Time of Pressure Release* (§63.7951(b)(10)(iii)(A)) Duration of Pressure Release*
(hours)
(§63.7951(b)(10)(iii)(A))
Estimate of Mass Quantity of Total HAP Emitted During Pressure Release*
(§63.7951(b)(10)(iii)(B))
Method Used for Determing Quantity of Each HAP Emitted During Pressure Release*
(§63.7951(b)(10)(iii)(B))
Actions Taken to Prevent this Pressure Release*
(§63.7951(b)(10)(iii)(D))
Measures Implemented During Reporting Period to Prevent Such Future Pressure Releases and Implementation Schedule for Corrective Actions if Applicable*
(§63.7951(b)(10)(iii)(E))
Confirmation (yes or no) That the Monitoring Required to be Done During the Reporting Period to Show Compliance Was Conducted*
(§63.7951(b)(10)(ii))
(Select from Dropdown)
Number of Occurances of an Instrument Reading of 500 ppm or Greater Above the Background Level When Detected More Than 5 Days After a Pressure Release*
(§63.7951(b)(10)(i))
RecordId ActuationEvent PressureReleaseNature PressureReleaseCause PressureReleaseStartDate PressureReleaseStartTime PressureReleaseEndDate PressureReleaseEndTime PressureReleaseDuration PressureReleaseEmissionQuantity PressureReleaseMethod PreventiveAction CorrectiveAction ComplianceFlag PPMExcessOccuranceCount
e.g.: 1 e.g.: Line 1 PRD3 e.g.: small leak e.g.: leak in valve e.g.: 5/1/2017 e.g.: 15:15 e.g.: 5/1/2017 e.g.: 15:45 e.g.: 0.50 e.g.: 2.37 lb e.g.: Engineering calculations e.g.: Action e.g.: Measures and schedule e.g.: Yes e.g.: 2
































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 11: Description of Changes

40 CFR Part 63, Subpart GGGGG National Emission Standards for Hazardous Air Pollutants: Site Remediation -

§63.7951(f) Compliance Report Spreadsheet Template

CMS, Processes, or Control Changes

A description of any changes in the CMS, processes, or controls since the last reporting period.

* Required Field

Company Record No. *
(Autocompleted)
Description of any CMS, processes, or controls which have occurred since the last reporting period*
(§63.7951(b)(8)(xi))
Description of Pressure Release Device Monitoring System and any changes which have occurred since the last reporting period*
(§63.7951(a)(6)) (Attachment file name containing all info.)
RecordId CMSChangeDesc AddFile
e.g.: 1 e.g.: Additional Changes e.g.: AddFile.pdf































Sheet 12: Info Press Tank Closure Device

40 CFR Part 63, Subpart GGGGG National Emission Standards for Hazardous Air Pollutants: Site Remediation -











§63.7951(f) Compliance Report Spreadsheet Template











* Required Field











Company Record No. *
(Select from dropdown)
Source of the Release *
(§63.7951(b)(11)(iv)(A))
Nature of the Release*
(§63.7951(b)(11)(iv)(A))
Cause of the Release*
(§63.7951(b)(11)(iv)(A))
Start Date of Release
(§63.7951(b)(11)(iv)(B))
Start Time of Release
(§63.7951(b)(11)(iv)(B))
End Date of Release
(§63.7951(b)(11)(iv)(B))
End Time of Release
(§63.7951(b)(11)(iv)(B))
Duration of Release
(hours)
(§63.7951(b)(11)(iv)(B))
Estimate of Quantity of HAP Emitted During Pressure Release
(§63.7951(b)(11)(iv)(C))
Method Used for Determing Quantity Emitted During Pressure Release
(§63.7951(b)(11)(iv)(C))
Actions Taken to Prevent this Pressure Release
(§63.7951(b)(10)(iv)(D))
Measures Adopted to Prevent Such Future Pressure Releases
(§63.7951(b)(10)(iv)(E))
RecordId AffectedSource ReleaseNature ReleaseCause ReleaseStartDate ReleaseStartTime ReleaseEndDate ReleaseEndTime ReleaseDuration ReleaseEmissionQuantity ReleaseEmissionMethod PreventiveAction CorrectiveAction
e.g.: 1 e.g.: tank closure device 1 e.g.: leak e.g.: broken seal e.g.: 5/1/2020 e.g.: 15:15 e.g.: 5/1/2020 e.g.: 15:45 e.g.: 0.50 e.g.: 1.20 lb e.g.: Method e.g.: Actions e.g.: Measures






























































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 13: Info on Control 1 Equip Leaks

§63.7951(f) Compliance Report Spreadsheet Template









* Required Field









Company Record No. *
(Select from dropdown)
Process Unit *
(§63.7951(b)(9); §63.1018(a)(2)(i))
Month *
(§63.7951(b)(9);
§63.1018(a)(2)(ii))
Number of Valves for Which Leaks Were Detected*
(§63.7951(b)(9); §63.1018(a)(2)(ii)(A))
Number of Valves For Which Leaks Were Not Repaired*
(§63.7951(b)(9); §63.1018(a)(2)(ii)(B))
Number of Pumps For Which Leaks Were Detected*
(§63.7951(b)(9); §63.1018(a)(2)(ii)(C))
Number of Pumps For Which Leaks Were Not Repaired*
(§63.7951(b)(9);
§63.1018(a)(2)(ii)(D))
Number of Compressors For Which Leaks Were Detected*
(§63.7951(b)(9); §63.1018(a)(2)(ii)(E))
Number of Compressors For Which Leaks Were Not Repaired*
(§63.7951(b)(9); §63.1018(a)(2)(ii)(F))
Facts That Explain Each Delay of Repair; Why Repair Was Infeasible Without a Process Shutdown*
(§63.7951(b)(9); §63.1018(a)(2)(ii)(G))
Dates of Process Unit or Affected Facility Shutdown Within Reporting Period*
(§63.7951(b)(9); §63.1018(a)(2)(iii))
RecordId ProcessUnitDesc Month ValvesDetected ValvesNotRepaired PumpsDetected PumpsNotRepaired CompressorsDetected CompressorsNotRepaired RepairDelayCause ShutdownDates
e.g.: 1 e.g.: Line 1 e.g.: January e.g.: 10 e.g.:5 e.g.:2 e.g.: 1 e.g.: 2 e.g.: 0 e.g.: reason delay e.g.: 1/2/20-1/15/20

Sheet 14: Control 1 Initial Compliance

§63.7951(f) Compliance Report Spreadsheet Template






* Required Field






Company Record No. *
(Select from dropdown)
Process Unit or Affected Facility Identification *
(§63.7951(b)(9)); (§63.1018(a)(1)(i)); (§63.1018(a)(2)(i))
Number of Valves*
(§63.7951(b)(9)); (§63.1018(a)(1)(ii))
Revisions to Number of Valves* (§63.7951(b)(9)); (§63.1018(a)(2)(iv)) Number of Pumps *
(§63.7951(b)(9)); (§63.1018(a)(1)(iii))
Revisions to Number of Pumps*
(§63.7951(b)(9)); (§63.1018(a)(2)(iv))
Number of Compressors*
(§63.7951(b)(9)); (§63.1018(a)(1)(iv))
Revisions to Number of Compressors*
(§63.7951(b)(9)); (§63.1018(a)(2)(iv))
RecordId ProcessUnitDesc NumberOfValves ValvesRevisions NumberOfPumps PumpsRevisions NumberOfCompressors CompressorsRevisions
e.g.: 1 e.g.: Line 1 e.g.: 100 e.g.: none e.g.:50 e.g.: no revisions e.g.:20 e.g.: 10 new compressors added

Sheet 15: Info on Control 2 Equip Leaks

40 CFR Part 63, Subpart GGGGG National Emission Standards for Hazardous Air Pollutants: Site Remediation -









§63.7951(f) Compliance Report Spreadsheet Template









* Required Field









Company Record No. *
(Select from dropdown)
Monitoring Period Identification *
(§63.7591(b)(9); §63.1039(b))
Equipment Type* (§63.7951(b)(9); §63.1039(b)(1)(i-v)) (Select from dropdown) Total Number of Components Monitored for Valves, Pumps, and Connectors*
(§63.7951(b)(9); §63.1039(b)(1))
Number of Components For Which Leaks Were Detected* (§63.7951(b)(9); §63.1039(b)(1)) Percent Leakers for Valves, Pumps and Connectors * (§63.7951(b)(9); §63.1039(b)(1)) Number of Leaking Components Not Repaired* (§63.7951(b)(9); §63.1039(b)(1)) Number of Components Determined to be Nonrepairable for Valves and Connectors* (§63.7951(b)(9); §63.1039(b)(1)(i)) Has Delay of Repair Occurred?*
(§63.7951(b)(9);
§63.1039(b)(2)) (Select from dropdown)
Number of Instances of Delay of Repair* (§63.7951(b)(9);
§63.1039(b)(2))
Are Alternative Means of Emissions Limitation for Batch Processes is Utilized? If yes, provide file name of attachment with information required by §63.1036(f).*
(§63.7951(b)(9); §63.1018(b)(7))
RecordId MonitoringPeriodIdentificaiton EquipmentType NumberOfComponents ComponentsLeaks LeaksPercentage ComponentsLeaksNotRepaired ComponentsNonrepairable RepairDelay RepairDelayCount AddFile
e.g.: 1 e.g.: January 2020 e.g.: valve e.g.: 1000 e.g.: 100 e.g.: 1% e.g.: 12 e.g.: 25 e.g.: no e.g.: 2 e.g.: AddFile.pdf

Sheet 16: Control 2 Monitoring

40 CFR Part 63, Subpart GGGGG National Emission Standards for Hazardous Air Pollutants: Site Remediation -




§63.7951(f) Compliance Report Spreadsheet Template
















* Required Field




Company Record No. *
(Select from dropdown)
Process Unit or Affected Facility Identification *
(§63.7951(b)(9); §63.1018(a)(1)(i); §63.1018(a)(2)(i))
Valve Subgrouping information (if applicable)* (§63.7951(b)(9); §63.1039(b)(3))
Attachment file name containing all info.
Leak Detection Monitoring Results for Pressure Release Devices and Compressors* (§63.7951(b)(9); §63.1039(b)(4)) Attachment file name containing all info. The Initiation of a Monthly Monitoring Program for Valves*
(§63.7951(b)(9);
§63.1039(b)(5)) (Select from dropdown)
The Initiation of a Quality Improvement Program for Pumps*
(§63.7951(b)(9);
§63.1039(b)(6)) (Select from dropdown)
RecordId ProcessUnitDesc AddFile1 AddFile2 MonthlyMonitoringFlag QualityImprovementFlag
e.g.: 1 e.g.: Line 1 e.g.: file name e.g.:file name e.g.: Yes e.g.: Yes

Sheet 17: Control 2 Initial Compliance

40 CFR Part 63, Subpart GGGGG National Emission Standards for Hazardous Air Pollutants: Site Remediation -











§63.7951(f) Compliance Report Spreadsheet Template











LDAR - Initial Compliance Status Report











* Required Field















Equipment other than those in vacuum service

Subject to Requriements of §63.1036(b) Subject to Requriements of §63.1037
Company Record No. *
(Select from dropdown)
Process Unit or Affected Facility ID *
(§63.7951(b)(9); §63.1039(b)(8); §63.1039(a)(1)(i); §63.1039(a)(3)(i))
Is this information being reported as a revision to items reported in an earlier Initial Compliance Status Report?
(§63.7951(b)(9); §63.1039(b)(8))
(Select from dropdown)
Equipment Type*
(§63.7951(b)(9);
§63.1039(b)(1)(i-v))
(Select from dropdown)
Number of Subject Valves *
(§63.7951(b)(9);
§63.1039(b)(8);
§63.1039(a)(1)(ii))
Number of Subject Pumps *
(§63.7951(b)(9); §63.1039(b)(8); §63.1039(a)(1)(ii))
Number of Subject Sampling Connections *
(§63.7951(b)(9); §63.1039(b)(8); §63.1039(a)(1)(ii))
Method of Compliance With the Standard *
(§63.7951(b)(9); §63.1039(b)(8);
§63.1039(a)(1)(iii))
Planned Schedule for Requirements in §63.1025 and §63.1026 *
(§63.7951(b)(9); §63.1039(b)(8);
§63.1039(a)(1)(iv))
Batch Products or Product Codes Subject to this Subpart *
(§63.7951(b)(9); §63.1039(b)(8); §63.1039(a)(2)(i))
Planned Schedule For Pressure Testing When Equipment Is Configured for Production of Products *
(§63.7951(b)(9); §63.1039(b)(8); §63.1039(a)(2)(ii))
Description of System Used to Create Negative Pressure in the Enclosure *
(§63.7951(b)(9); §63.1039(b)(8); §63.1039(a)(3)(ii))
Control Device *
(§63.7951(b)(9); §63.1039(b)(8); §63.1039(a)(3)(ii))
RecordId ProcessUnitDesc RevisionFlag EquipmentType SubjectValvesCount SubjectPumpsCount SubjectConnectionsCount StandardComplianceMethod RequirementsSchedule ProductsSubjectToSubpart PressureTestingSchedule SystemDescription ControlDevice
e.g.: 1 e.g.: North Tank Farm e.g.: No e.g. valves e.g.: 1 e.g.: 1 e.g.: 1 e.g.: method e.g.: 1/2/20 - 2/2/20 e.g.: Batch products e.g.: 1/2/20 - 2/2/20 e.g.: System description e.g.: Control device





















































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 18: Compliance - Certification

40 CFR Part 63, Subpart GGGGG National Emission Standards for Hazardous Air Pollutants: Site Remdiation-


§63.7951(f) Compliance Report Spreadsheet Template


* Required Field


Instruction: There are no deviations from any emission limitation (including operating limit), work practice standards, or operation and maintenance requirements during this reporting period *
§63.7951(b)(5)
(Select from Dropdown)
There were no periods during which a CMS (including a CPMS or CEMS), was out-of-control as specified in §63.8(c)(7) during the reporting period *
§63.7951(b)(6)
(Select from Dropdown)
Pursuant to §63.7951(d), all necessary deviation information was submitted in the semiannial monitoring report required by §70.6(a)(3)(iii)(A) or §71.6(a)(3)(iii)(A). *
(Select from Dropdown)




RecordId OperationDeviationFlag PeriodDeviationFlag DeviationInformationFlag









































Sheet 19: Revisions

Revision Number Date Revisions
1.00 1/20/2020 Version for comment
2.00 4/3/2020 Finalized Release Version - wrap text added and fixed duration formulas - addressing comments received
2.01 5/1/2020 Updated CBI language on Welcome tab; Info Pressure Relief Devices – Column J formula copied up from line 31 to 24; Info Press Tank Closure Device – Column J formula copied up from line 26 to 24; Control 2 Monitoring – Column D & E Changed XML tags ‘ValveSubgroupingFile’ and ‘LeadDetectionFile’ to ‘AddFile’; Control 2 Initial Compliance –unlocked datasheet.
2.02 6/16/2020 Unlock 'Control 2 Initial Compliance' worksheet
2.03 7/10/2020 Updated duplicate XML Tags in the 'Control 2 Monitoring' tab. The 2 columns with the 'AddFile' XML tag now is listed as 'AddFile1' and 'AddFile2.' Removed spaces at the end of the following tab names: 'Info Press Tank Closure Device ' and 'Control 2 Monitoring '.
2.04 10/8/2020 Enabled wrap text and autofit row height in all data entry cells
2.05 2/1/2021 expanded dropdown list on list table for deviation-CMS tab to work.
2.06 4/10/2024 Revised the welcome tab
ICR Draft 5/8/2024 Added EPA Form number and OMB Control Number
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2025 OMB.report | Privacy Policy