Form 5900-523 Compliance Report

NESHAP for Engine Test Cells/Stands (40 CFR part 63, subpart PPPPP) (Renewal)

63.9350a_Compliance_Report_v2.01_2021_08_02.xlsm

NESHAP for Engine Test Cells/Stands (40 CFR Part 63, Subpart PPPPP)(Renewal)

OMB: 2060-0483

Document [xlsx]
Download: xlsx | pdf

Overview

Welcome
Company_Information
Emission_Limits_Details
Summary_Report_EmissionLimits
CMS_Identification
CMS_Detail
Summary_Report_CMS
Operating_Limits_Details
Summary_Report_OperatingLimits
Description_of_Changes
Certification
Version

Sheet 1: Welcome
63.9350(a) Semiannual Compliance Report (Spreadsheet Template)
63.9350(a)
v2.01
8/2/2021
OMB No.: 2060-0483 Form 5900-523 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 PPPPP National Emission Standards for Hazardous Air Pollutants for Engine Test Cells/Stands -
§63.9350(a) Semiannual Compliance Report Spreadsheet Template
Instructions for Spreadsheet Template
Purpose:
This spreadsheet template was designed by the U.S. EPA to facilitate Semiannual Compliance reporting for facilities subject under the 40 CFR part 63, subpart PPPPP National Emission Standard for Hazardous Air Pollutants for Engine Test Cells/Stands.
Electronic reporting:
Electronic submission of Semiannual Compliance Reports through the EPA's Compliance and Emissions Data Reporting Interface (CEDRI) is required under §63.9350(a)(7). 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. You may assign any value or text as a Company Record No. or allow the spreadsheet to assign a number.


For each facility record found in the "Company Information" worksheet, you may reference a single file attachment that includes additional information.
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.
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
Template Navigation and Tabs to Complete:
Gray Tab: The gray tab (Company_Information) contains mostly general information that is likely to be unchanged from report to report. After completing the gray tab, the workbook may be saved as a site specific template for use in subsequent reports to limit subsequent data entry. The reporting period dates and the date of report will need to be changed each report.

Green Tabs: Green tabs (Emission_Limits_Details, Summary_Report_EmissionLimits, CMS_Identification, CMS_Detail, Summary_Report_CMS, Operating_Limits_Details, Summary_Report_OperatingLimits, Description_of_Changes, and Certification) are to be completed as necessary to complete the Semiannual report. Some cells are linked to previous tabs or are calculations dependent upon data entry. Many cells have a dynamic dropdown which changes based upon entries in preceding tabs, these dropdown menus will be blank if the appropriate data has not been completed. The Certification tab must be completed for every report.

Within the tabs, example rows are colored light orange (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. Locked columns containing calculations are colored light pink, no data entry is possible in these columns.
Certification per §63.9350(b)(2):
Certification of your report in CEDRI satisfies the requirement in §63.93500(b)(2) that a certifying official certify the accuracy of the content of the report.

Sheet 2: Company_Information
40 CFR Part 63, Subpart PPPPP National Emission Standards for Hazardous Air Pollutants for Engine Test Cells/Stands - §63.9350(a) Semiannual Compliance Report Spreadsheet Template













SITE INFORMATION
REPORTING PERIOD ADDITIONAL INFORMATION
Company Record No.
(Field value will automatically generate if a value is not entered.)		 Company Name
(§63.9350(b)(1))		 Address
(§63.9350(b)(1))		 Address 2 City
(§63.9350(b)(1))		 County State Abbreviation
(§63.9350(b)(1))		 Zip Code
(§63.9350(b)(1))		 Responsible Agency Facility ID
(State Facility Identifier)		 Date of Report
(§63.9350(b)(3))		 Beginning Date of Reporting Period
(§63.9350(b)(3))		 Ending Date of
Reporting Period
(§63.9350(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/2019 e.g.: 01/01/2020 e.g.: 6/30/2019 e.g.: e.g.: addlinfo.zip












































































































































Sheet 3: Emission_Limits_Details
40 CFR Part 63, Subpart PPPPP National Emission Standards for Hazardous Air Pollutants for Engine Test Cells/Stands - §63.9350(a) Semiannual Compliance Report Spreadsheet Template









Company Record No.
(Select from dropdown)		 Emission Limit Deviated From
(§63.9350(c))
(Select from dropdown)		 Starting Date of Deviation
(§63.9350(c)(1))		 Starting Time of
Deviation
(§63.9350(c)(1))		 Ending Date of Deviation
(§63.9350(c)(1))		 Ending Time of
Deviation
(§63.9350(c)(1))		 Duration of Deviation
(hours)
(Calculated value)		 Cause of Deviation
(§63.9350(c)(4))
(Select from dropdown)		 Estimate of Emissions
(§63.9350(c)(5))		 Units of Emissions Estimate
(§63.9350(c)(5))
(Select from dropdown)		 Method Used to Estimate Emissions
(§63.9350(c)(5))
RecordId EmissionOperatingLimit EmissionOutageStartDate EmissionOutageStartTime EmissionOutageEndDate EmissionOutageEndTime EmissionOutageDuration DeviationCause EmissionQuantity EmissionUnits EstimationMethod
e.g.: 1 e.g.: CO Concentration 20 ppmvd at 15% Oxygen e.g.: 2/12/2019 e.g.: 13:05 e.g.: 2/12/2019 e.g.: 19:05 e.g.: 6.00 e.g.: Control Equipment Problems e.g.: 0.1 e.g.: tons e.g.: Engineering calculations































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 4: Summary_Report_EmissionLimits
40 CFR Part 63, Subpart PPPPP National Emission Standards for Hazardous Air Pollutants for Engine Test Cells/Stands - §63.9350(a) Semiannual Compliance Report Spreadsheet Template







§63.8693(c) Semiannual Compliance Report Spreadsheet Template







Company Record No.
(Select from dropdown)		 Emission Limit Deviated From
(§63.9350(c))
(Select from dropdown)		 Total
Operating Time
(hours)
(§63.9350(c)(2))		 Total Duration of
Deviations from
Emission Limits
(hours)
(§63.9350(c)(3))
(Calculated value)		 Total Duration of
Deviations from
Emission Limits as a
percent of
Total Source Operating Time
(§63.9350(c)(3))
(Calculated value)		 Total Duration of
Deviations from
Emission Limits Due to
Control Equipment Problems
(hours)
(§63.9350(c)(4))
(Calculated value)		 Total Duration of
Deviations from
Emission Limits Due to
Process Problems
(hours)
(§63.9350(c)(4))
(Calculated value)		 Total Duration of
Deviations from
Emission Limits Due to
Other Known Causes
(hours)
(§63.9350(c)(4))
(Calculated value)		 Total Duration of Deviations from Emission Limits Due to Other Unknown Causes
(hours)
(§63.9350(c)(4))
(Calculated value)
RecordId EmissionOperatingLimit TotalOperatingTime TotalDeviationDuration TotalDeviationPercent EquipmentCausedDeviation ProcessCausedDeviation OtherCausedDeviation UnknownCausedDeviation
e.g.: 1 e.g.: CO Concentration 20 ppmvd at 15% Oxygen e.g.: 4310 e.g.: 6.00 e.g.: 0.14% e.g.: 6.00 e.g.: 0.00 e.g.: 0.00 e.g.: 0.00





















































































































































































































































































































































































































































































































































































































































































































Sheet 5: CMS_Identification
40 CFR Part 63, Subpart PPPPP National Emission Standards for Hazardous Air Pollutants for Engine Test Cells/Stands -

§63.9350(a) Semiannual Compliance Report Spreadsheet Template




Company Record No.
(Select from dropdown)		 Monitoring Equipment Manufacturer and Model Number
(§63.9350(d)(5))		 Date of Last CPMS or CEMS Certification or Audit
(§63.9350(d)(6))
RecordId MonitorEqDesc CPMSAuditDate
e.g.: 1 e.g.: TC1792 PM Filter Bank Inlet Temperature e.g.: 2/2/2019







































































































































































































































Sheet 6: CMS_Detail
40 CFR Part 63, Subpart PPPPP National Emission Standards for Hazardous Air Pollutants for Engine Test Cells/Stands -







§63.9350(a) Semiannual Compliance Report Spreadsheet Template







Company Record No.
(Select from dropdown)		 Monitoring Equipment Manufacturer and Model Number
(§63.9350(d)(5))
(Select from dropdown)		 CMS Inoperative or
Out of Control
(Select from dropdown)		 Starting Date CMS
Inoperative or Out of Control
(§63.9350(d)(1) or (2))		 Starting Time CMS Inoperative or Out of Control
(§63.9350(d)(1) or (2))		 Ending Date CMS
Inoperative or Out of Control
(§63.9350(d)(1) or (2))		 Ending Time CMS Inoperative or Out of Control
(§63.9350(d)(1) or (2))		 Duration CMS Inoperative
or Out of Control (hours)
(Calculated value used in calculations on Summary_Report_CMS tab)		 Cause of Deviation
(§63.9350(d)(4))
RecordId MonitorEqDesc CPMSOutageDescription CPMSOutageStartDate CPMSOutageStartTime CPMSOutageEndDate CPMSOutageEndTime CPMSOutageDuration CPMSOutageCause
e.g.: 1 e.g.: TC1792 PM Filter Bank Inlet Temperature e.g. Inoperative e.g.: 3/2/2019 e.g.: 15:52 3/5/2019 e.g.: 15:52 e.g.: 72.0 e.g.: Monitoring Equipment Malfunction





































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 7: Summary_Report_CMS
40 CFR Part 63, Subpart PPPPP National Emission Standards for Hazardous Air Pollutants for Engine Test Cells/Stands -








§63.9350(a) Semiannual Compliance Report Spreadsheet Template








Company Record No.
(Autocompleted)		 Monitoring Equipment Manufacturer and Model Number
(§63.9350(d)(5))
(Autocompleted)		 Total
Operating Time
(hours)
(§63.9350(d)(11))		 Total Duration of CMS
Downtime (hours)
(§63.9350(d)(3))
(Calculated value)		 Total Duration of
CMS Downtime as
a percent of Total
Source Operating Time
(§63.9350(d)(3))
(Calculated value)		 Total Duration of
CMS Downtime Due
to Monitoring Equipment
Malfunctions (hours)
(§63.9350(d)(4))
(Calculated value)		 Total Duration of
CMS Downtime
Due to Nonmonitoring Equipment Malfunctions (hours)
(§63.9350(d)(4))
(Calculated value)		 Total Duration of
CMS Downtime
Due to Quality Assurance/Quality Control Calibrations (hours)
(§63.9350(d)(4))
(Calculated value)		 Total Duration of
CMS Downtime
Due to Other Known
Causes (hours)
(§63.9350(d)(4))
(Calculated value)		 Total Duration of
CMS Downtime
Due to Other Unknown
Causes (hours)
(§63.9350(d)(4))
(Calculated value)
RecordId MonitorEqDesc TotalOperatingTime CPMSDowntimeDuration CPMSDowntimePercent CPMSDowntimeMonitoringMal CPMSDowntimeNonmonitoringMal CPMSDowntimeCalibrations CPMSDowntimeOtherKnown CPMSDowntimeOtherUnknown
e.g.: 1 e.g.: TC1792 PM Filter Bank Inlet Temperature e.g.: 4310 e.g.: 0.00 e.g.: N/A e.g.: 0.00 e.g.: 0.00 e.g.: 0.00 e.g.: 0.00 e.g.: 0.00


































































































































































































































































































































































































































































































































































































































































































































































































Sheet 8: Operating_Limits_Details
40 CFR Part 63, Subpart PPPPP National Emission Standards for Hazardous Air Pollutants for Engine Test Cells/Stands - §63.9350(a) Semiannual Compliance Report Spreadsheet Template







Company Record No.
(Select from dropdown)		 Deviation from Operating Limit or
Bypass of Control Device
(§63.9350(d)(7))
(Select from dropdown)		 During Startup, Shutdown, Malfunction, or Other Period
(§63.9350(d)(7))
(Select from dropdown)		 Starting Date of Deviation
(§63.9350(d)(7))		 Starting Time of
Deviation
(§63.9350(d)(7))		 Ending Date of Deviation
(§63.9350(d)(7))		 Ending Time of
Deviation
(§63.9350(d)(7))		 Duration of Deviation
(hours)
(Calculated value used in calculations on Summary_Report_OperatingLimits)		 Cause of Deviation
(§63.9350(d)(9))
(Select from dropdown)
RecordId DeviceDeviationBypass SSMorOther DeviationStartDate DeviationStartTime DeviationEndDate DeviationEndTime DeviationDuration DeviationCause
e.g.: 1 e.g.: Catalytic Oxidizer Minimum Catalyst Bed Temperature e.g.: Other Period e.g.: 2/12/2019 e.g.: 13:05 e.g.: 2/12/2019 e.g.: 19:05 e.g.: 6.00 e.g.: Control Equipment Problems





































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 9: Summary_Report_OperatingLimits
40 CFR Part 63, Subpart PPPPP National Emission Standards for Hazardous Air Pollutants for Engine Test Cells/Stands - §63.9350(a) Semiannual Compliance Report Spreadsheet Template









Company Record No.
(Autocompleted)		 Deviation from Operating Limit or
Bypass of Control Device
(§63.9350(d)(7))
(Autocompleted)		 Total
Operating Time
(hours)
(§63.9350(d)(11))		 Total Duration of
Deviations from Operating Limit or
Bypass of Control Device
(hours)
(§63.9350(d)(8))
(Calculated value)		 Total Duration of
Deviations from
Operating Limit or
Bypass of Control Device as a
percent of
Total Source Operating Time
(§63.9350(d)(8))
(Calculated value)		 Total Duration of
Deviations from
Operating Limit or
Bypass of Control Device Due to
Startup
(hours)
(§63.9350(d)(9))
(Calculated value)		 Total Duration of
Deviations from
Operating Limit or
Bypass of Control Device Due to
Shutdown
(hours)
(§63.9350(d)(9))
(Calculated value)		 Total Duration of
Deviations from
Operating Limit or
Bypass of Control Device Due to
Control Equipment Problems
(hours)
(§63.9350(d)(9))
(Calculated value)		 Total Duration of
Deviations from
Operating Limit or
Bypass of Control Device Due to
Process Problems
(hours)
(§63.9350(d)(9)))
(Calculated value)		 Total Duration of
Deviations from
Operating Limit or
Bypass of Control Device Due to
Other Known Causes
(hours)
(§63.9350(d)(9)))
(Calculated value)		 Total Duration of Deviations from Operating Limit or
Bypass of Control Device Due to Other Unknown Causes (hours)
(§63.9350(d)(9)))
(Calculated value)
RecordId DeviceDeviationBypass TotalOperatingTime TotalDeviationDuration TotalDeviationPercent StartupCausedDeviation ShutdownCausedDeviation EquipmentCausedDeviation ProcessCausedDeviation OtherCausedDeviation UnknownCausedDeviation
e.g.: 1 e.g.: Catalytic Oxidizer Minimum Catalyst Bed Temperature e.g.: 4310 e.g.: 6.00 e.g.: 0.14% e.g.: 0.00 e.g.: 0.00 e.g.: 6.00 e.g.: 0.00 e.g.: 0.00 e.g.: 0.00















































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 10: Description_of_Changes
40 CFR Part 63, Subpart PPPPP National Emission Standards for Hazardous Air Pollutants for Engine Test Cells/Stands -
§63.9350(a) Semiannual Compliance Report Spreadsheet Template
CPMS, CEMS, Processes, or Control Changes
A description of any changes in the CEMS, CPMS, or controls since the last semiannual reporting period.
Company Record No.
(Select from dropdown)		 Description of any changes in CEMS, CPMS, or controls which have occurred since the last reporting period
(§63.9350(d)(10))
RecordId PeriodChangeDesc




















Sheet 11: Certification
40 CFR Part 63, Subpart PPPPP National Emission Standards for Hazardous Air Pollutants
for Engine Test Cells/Stands -
§63.9350(a) Semiannual Compliance Report Spreadsheet Template
Complete this form when you have completed the semiannual compliance report.
Company Record No.
(Autocompleted)		 Does the statement "There were no deviations from the emission limit and no CEM or CPMS was out of control as specified in §63.8(c)(7) during this reporting period" apply? §63.9350(b)(4)
(Select from dropdown)
RecordId DeviationControlFlag




















Sheet 12: Version
Version Number Date Description
1.00 3/12/2020 Initial Release Version
2.00 7/7/2020 Inserted a column before column A on each data entry tab, added a Mapping worksheet, updated column headers to remove COMS throughout, Corrected Title on Summary_Report_EmissionLimits tab, Replaced CPMS on the CMS_Detail and Summary_Report_CMS tabs with CMS to clarify that CEMs and CPMS are included, added clarifying statement to the calculated duration column on CMS_Detail and Operating_Limits_Details, clarified the certifying statetent on Certification, updated the Welcome page adn CBI disclaimer, and corrected several spelling errors.
2.01 8/2/2021 Updated Welcome page for spacing, adding PRA language, updated CBI language, and additional instruction for certiying statement, Removed "Required Field" and * from all tabs due to potential confusion of data being required when not applicable. Enabled sorting and filtering in Company_Information, inserted "e.g.:" in all blank example cells to ease hiding of blank example rows after removing a filter, Corrected claculations on Line 24 of CMS_Detail (calculation of duration) and CMS SUmmary (autocompletion of row 24)
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00
© 2024 OMB.report | Privacy Policy