Form 5900-597 63.6650_h_and_i-compliance-report-template

---

Overview

Welcome
Company Information
Engine Information
Revisions
Worksheet Map

---

Sheet 1: Welcome

63.6650 Semiannual and Annual Report

63.6650(h)(3) and (i)

v5.00

8/26/2024

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 ZZZZ - National Emissions Standards for Hazardous Air Pollutants for Stationary Reciprocating Internal Combustion Engines:
§63.6650(h)(3) and (i) Spreadsheet Template

Instructions for Spreadsheet Template

Purpose:
This spreadsheet template was designed by the U.S. EPA to facilitate Semiannual and annual reporting for facilities subject under the 40 CFR part 63, subpart ZZZZ National Emission Standard for Hazardous Air Pollutants for Stationary Reciprocating Internal Combustion Engines

Electronic reporting:
Electronic submission of Semiannual and Annual Reports through the EPA's Compliance and Emissions Data Reporting Interface (CEDRI) is required under §63.6650(h)(3) and (i). 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 facility or multiple facilities, as well as multiple sites, using this EPA provided Excel workbook. Data for each company must be entered into the worksheet labeled Company Information and Engine 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 worksheet to the appropriate company. The Engine Record Number is used to match the information in each workbook to a specific engine.

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 submit a complete report, including any information claimed to be CBI, to EPA. The preferred method is to be received electronically using email attachments, File trasfer Protocol, or other online sharing services. Electronic submissions must be transmitted directly to the OAQPS CBI Office at the email address oaqpscbi@epa.gov, and as described above, should include clear CBI markings and be flagged to the attention of the Reciprocating Internal Combustion Engine Sector Lead. If assistance is needed with submitting large electronic files that exceed the file size limit for email attachments, and if you do not have your own file sharing service, please email oaqpscbi@epa.gov to request a file transfer link. If you cannot transmit the file electronically, you may send CBI information through the postal service to the following address:
OAQPS Document Control Officer (C404-02)
Attention: Reciprocating Internal Combustion Engine Sector Lead
OAQPS, U.S. Environmental Protection Agency
109 T.W. Alexander Drive, P.O. Box 12088
Research Triangle Park, North Carolina 27711

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.

Template Navigation and Tabs to Complete:
Gray Tabs (Complete first): The gray tabs (Company Information, Engine Information) contain general information that is likely to be mostly unchanged from report to report. These tabs do contain dates and the operating time of the sources over the reporting period, which must be updated with each 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. Once selections are made inthe Engine Information tab as to what reporting provisions apply, other tabs will become visible as needed.

Colored Tabs: Colored tabs are completed as necessary for the facility, not all tabs are required for a particular engine type, and only those necessary for that particular type of engine are required. These tabs are displayed through a macro that must be enabled (Enable Content if a yellow bar is diplayeed at teh top). If you cannot enable the macros, the hidden tabs may be displayed by right clicking on any visible tab name and selecting Unhide.

For engines reporting deviations according to §63.6650(d) (deviations where the engine is not using a CMS), select §63.6650(d) in Column K of the Engine Information tab and the grey Malfunctions, and Description of Changes tabs and also the light red Non CMS Deviation tab will appear in order to be completed. On the Malfunctions tab, the detailed information required by §63.6650(d) in Columns D through G are not required, and only Columns B, C, H, I and J are required.

For engines complying with §63.6650(e), select §63.6650(e) in Column K of the Engine Information tab and the grey Malfunctions, Number of Malfunctions, and Description of Changes tabs and the green CMS Description, CMS Detail, CMS Summary, CMS Deviation Detail, and CMS Deviation Summary tabs will appear in order to be completed. The CMS Summary and CMS Deviation Summary tabs will autocomplete based on entries in the respective Detail tabs. Please review these tabs for accuracy. On the Malfunctions tab, all information required, however, for engine using CMS, the Number of Deviations is calculated on the Number of Deviations tab, and Column I on the Malfunctions tab may be left blank.

For engines complying with §63.6650(g), select Yes in Column L of the Engine Information tab and the light blue Landfill Digester Gas and Landfill Digester Gas Deviation tabs will appear in order to be completed.

For engines complying with §63.6650(h), select Yes in column M of the Engine Information and the purple Non-emergency Use and Fuel Req. Deviation tabs will appear in order to be completed.

Some cells are linked to previous tabs or are calculations dependent upon data entry.

The statement of truth accuracy and completeness required by §63.7751(b)(2) is completed in the certifcation step within CEDRI.

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 ZZZZ - National Emissions Standards for Hazardous Air Pollutants for Stationary Reciprocating Internal Combustion Engines: §63.6650(h)(3) and (i) Spreadsheet Template

COMPANY INFORMATION

REPORTING INFORMATION

ADDITIONAL INFORMATION

Company Record No. (Field value will automatically generate once Company Name is added in Column C.)

Company Name (§§63.6650(c)(1) and (h)(1)(i))

Address Where the Engine Is Located (§§63.6650(c)(1) and (h)(1)(i))

Address 2 (§§63.6650(c)(1) and (h)(1)(i))

City (§§63.6650(c)(1) and (h)(1)(i))

County (§§63.6650(c)(1) and (h)(1)(i))

State Abbreviation (§§63.6650(c)(1) and (h)(1)(i)) (Select from dropdown)

Zip Code (§§63.6650(c)(1) and (h)(1)(i))

Responsible Agency Facility ID (State Facility Identifier)

Beginning Date of Reporting Period (§63.6650(c)(3) and (h)(1)(ii))

Ending Date of Reporting Period (§63.6650(c)(3) and (h)(1)(ii))

Does the statement "There were no deviations from any emission or operating limitations during the reporting period" apply to this facility? (§63.6650(c)(5)) (Select from dropdown)

Does the statement "There were no periods during which the CMS was out-of-control during the reporting period" apply to this facility? (§63.6650(c)(6)) (Select from dropdown)

Please enter any additional information

Enter associated file name reference.

RecordId

CompanyName

AddressLine1

AddressLine2

CityName

CountyName

StateName

ZIPCode

StateFacID

PeriodStartDate

PeriodEndDate

DeviationFlag

CMSFlag

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

e.g.: 01/01/2020

e.g.: 06/30/2020

e.g.: Yes

e.g.: Not Applicable

e.g.:

e.g.: addfile.zip

---

Sheet 3: Engine Information

40 CFR Part 63, Subpart ZZZZ - National Emissions Standards for Hazardous Air Pollutants for Stationary Reciprocating Internal Combustion Engines: §63.6650(h)(3) and (i) Spreadsheet Template

Engine Record No. (Autocompleted once Column C filled)

Company Record No. (Select from dropdown)

Engine Type (§63.6650(c)(7) and (h)(1)(iii))

Engine Site Rating (Brake Horsepower) (§63.6650(c)(7) and (h)(1)(iii))

Year Construction Commenced (§63.6650(c)(7) and (h)(1)(iii))

Latitude of the Engine in Decimal Degrees (at least five decimal places) (§63.6650(c)(8) and (h)(1)(iv))

Longitude of the Engine (at least five decimal places) (§63.6650(c)(8) and (h)(1)(iv))

Due to national security considerations, the exact latitude and longitude are not contained in this report (§63.6650(c)(9)) (Select from dropdown)

This engine is reporting deviations under either §63.6650(d) or §63.6650(e) (Select from dropdown)

Total Operating Time of Engine During Reporting Period (Required when there is a deviation) (hours) (§63.6650(d)(1) and (e)(13))

Identification of Each Parameter and Pollutant Monitored (Required when there is a deviation) (§63.6650(e)(8))

This engine fires 10% or more of the annual gross heat input from landfill gas or Digester Gas and is subject to the §63.6650(g) (Select from dropdown)

This engine is subject to the reporting provisions of §63.6650(h) (Select from dropdown)

Did you use this engine for the purpose specified in §63.6640(f)(4)(ii): 50 hours per year for non-emergency situations? (§63.6650(h)) (Select from dropdown)

Were there deviations from the fuel requirements in §63.6604? (§63.6650(h)(1)(viii)) (Select from dropdown)

EngineId

RecordId

EngineDescription

EngineRating

EngineYear

EngineLatitude

EngineLongitude

NatSec

DeviationToggle

OperatingTime

ParametersMonitored

LandfillDigesterToggle

EmergencyToggle

NonEmergencyFlag

DeviationFlag

e.g.: 1

e.g.: 1

e.g.: SI 2SLB

e.g.: 100

e.g.: 2020

e.g.: 12.12345

e.g.: -12.12345

e.g.: Not Applicable

e.g.: §63.6650(d)

e.g.: 610

e.g.: Temperature, Carbon Monoxide

e.g.: Yes

e.g.: No

e.g.: Yes

e.g.: No

---

Sheet 4: Revisions

40 CFR Part 63, Subpart ZZZZ - National Emissions Standards for Hazardous Air Pollutants for Stationary Reciprocating Internal Combustion Engines:
§63.6650(h)(3) and (i) Spreadsheet Template
Revision Number	Date	Revisions
1.00	2/1/2016	Initial Release Version
1.01	3/14/2019	Updated the State dropdown to include VI, PR, AS, MP, and GU. Added the CBI Disclaimer to Welcome worksheet
2.00	3/27/2020	Added hidden mapping sheet and hidden column A to accommodate CEDRI EXCEL JSON Parser.
2.01	5/12/2020	Updated CBI Disclaimer.
3.00	8/10/2020	Updated XML tags on hidden columns in Engine Information, Hid rows 15-23 for data entry on Fuel Req. Deviation; Updated duplicate XML tags; renamed template name
4.00	1/22/2021	Removed hidden columns found on the Engine Information tab: columns I through L due to issues with parsing data elements without XML tags; updated instructions/headers on data entry tabs
4.01	3/1/2021	Updated sheet formatting and list formatting, added rule citations
4.02	3/20/2023	Added header to Revisions tab, Updated data validation on Engine Information tab to all entry of dates older than 1950
4.03	3/20/2023	Revised the Welcome tab, forgot to revise the report name when making the 4.02 revision.
4.04	12/6/2023	Revised the Engine Information tab, revised the example for the last column, row 14 to "Yes"
4.05	4/9/2024	Revised the welcome tab
ICR Draft (Future v5)	9/9/2022	Incorporated Emergency Demand Response and Voltage Frequency Deviation into file. Added reporting for 63.6650(d), (e), and (g) reporting. Revised some formatting for consistency and appearance. Added PRA information to Welcome, added header rows to Revisions, Removed Number of Malfunctions tab and Number of Malfunctions column from Malfunctions tab, updated citations for Malfunctions
5.00	8/26/2024	Welcome: updated CBI submittal language and address; Engine Information: Added not Applicable option to Column O, Expanded instructions for colored tabs, Moved the Deviation reporting indicator column (formerly column K) to Column I position so deviation indication would be before columns only required when there is a deviation, Inserted column to indicate when latitude and longitude are witheld for national security. elimiated references to 63.6650(g)(3) through (7) throughout

---

Sheet 5: Worksheet Map

Worksheet Name	Parent	JSON Key	Parent Primary Key	Child Foreign Key
Company Information		records
Engine Information	records	EngineInformation	RecordId	RecordId
CMS Description	EngineInformation	CMSDescription	EngineId	EngineId
Malfunctions	EngineInformation	Malfunctions	EngineId	EngineId
Non CMS Deviation	EngineInformation	NonCMSDeviation	EngineId	EngineId
CMS Detail	EngineInformation	CMSDetail	EngineId	EngineId
CMS Summary	EngineInformation	CMSSummary	EngineId	EngineId
CMS Deviation Detail	EngineInformation	CMSDeviationDetail	EngineId	EngineId
CMS Deviation Summary	EngineInformation	CMSDeviationSummary	EngineId	EngineId
Description of Changes	EngineInformation	DescriptionofChanges	EngineId	EngineId
Non-emergency Use	EngineInformation	NonemergencyUse	EngineId	EngineId
Fuel Req. Deviation	EngineInformation	FuelReqDeviation	EngineId	EngineId
Landfill Digester Gas	EngineInformation	LandfillDigesterGas	EngineId	EngineId
Landfill Digester Gas Deviation	EngineInformation	LandfillDigesterGasDeviation	EngineId	EngineId