Form 5900-600 40 CFR Part 63, Subpart YYYY National Emission Standards

---

Overview

Welcome
Company_Information
Affected_Source
Certification
Revisions

---

Sheet 1: Welcome

63.6150(a), (c) and (e) Semiannual and Annual Compliance Reports (Spreadsheet Template)

63.6150(a), (c), and (e)

ICR Draft

9/1/2022

OMB No.: 2060-0540 Form 5900-600 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 YYYY National Emission Standards for Hazardous Air Pollutants for Stationary Combustion Turbines -
§63.6150(a)-(e) Compliance Reports 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 YYYY National Emission Standard for Hazardous Air Pollutants for Stationary Combustion Turbines.

Electronic reporting:
Electronic submission of Compliance Reports through the EPA's Compliance and Emissions Data Reporting Interface (CEDRI) is required under §63.6150. 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 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 Company_Information and Affected_Sources tab contains general information that is likely to be unchanged from report to report. After completing these tabs, the workbook may be saved as a site specific template for use in subsequent reports to limit subsequent data entry. The dates and the total operating time will need to be amended evey report. Selections in Columns W, X, and Y of Company_Information will unhide applicable tabs for the various fuel types.

Green Tabs: Green tabs (CEM_CPMS_Identification, Deviation_Limits, Deviation_CEM_CPMS, and Description_of_Changes) are to be completed as necessary for a turbine with a formaldehyde emission standard to complete the Semiannual report. Some cells are linked to previous tabs or are calculations dependent upon data entry. These tabs will still contain information when hidden, and should be cleared before completing any subsequent reports. The Deviation_Summary_Limits, Deviation_Summary_CPMS, and Number_of_Deviations tab will be autocompleted based on entries in Deviation_Limits and Deviation_CEM_CPMS.

Blue Tabs: Blue tabs (Landfill_Gas_ID, Landfill_Gas_Fuel, Landfill_Gas_Limits, and Landfill_Gas_Fuel_Meters) are to be completed as necessary to prepare an annual report as described in
§63.6150(c) if you operate stationary combustion turbine which fires landfill gas or digester gas equivalent to 10% or more of the gross heat input on an annual basis. Some cells are linked to previous tabs or are calculations dependent upon data entry. These tabs will still contain information when hidden, and should be cleared before completing any subsequent reports.

Grey Tabs: Grey tabs (Distillate_Oil, Distillate_Oil_Limits, and Distillate_Meters) are to be completed as necessary to prepare the annual report required by §63.6150(e) if you operate a lean premix gas-fired or diffusion flame gas-fired stationary combustion turbine and use any quantity of distillate oil to fire any new or existing stationary combustion turbine which is located at the same major source. Some cells are linked to previous tabs or are calculations dependent upon data entry. These tabs will still contain information when hidden, and should be cleared before completing any subsequent reports.

Certification: The Certification tab must be completed for all reports.

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 YYYY National Emission Standards for Hazardous Air Pollutants for Stationary Combustion Turbines -

§63.6150(a)-(e) Compliance Reports Spreadsheet Template

SITE INFORMATION

Optional Mailing Address Information

REPORTING PERIOD

ADDITIONAL INFORMATION

Report Type

Company Record No. (Field value will automatically generate if a value is not entered.)

Company Name (§63.6150(a)(1) and §63.10(e)(3)(vi))

Address (§63.6150(a)(1) and §63.10(e)(3)(vi))

Address 2

City (§63.6150(a)(1) and §63.10(e)(3)(vi))

County

State Abbreviation (§63.6150(a)(1) and §63.10(e)(3)(vi))

Zip Code (§63.6150(a)(1) and §63.10(e)(3)(vi))

Responsible Agency Facility ID (State Facility Identifier)

Mailing Address (Optional)

Mailing Address 2 (Optional)

Mailing Address City (Optional)

Mailing Address State Abbreviation (Optional)

Mailing Address Zip Code (Optional)

Contact Name (Optional)

Contact Number (Optional)

Date of Report (§63.6150(a)(3))

Beginning Date of Reporting Period (§63.6150(a)(3) and §63.10(e)(3)(vi))

Ending Date of Reporting Period (§63.6150(a)(3) and §63.10(e)(3)(vi))

Please enter any additional information.

Enter associated file name reference.

Semiannual report for stationary combustion turbine with a formaldehyde emission limit (§63.6150(a)) (Select from Dropdown)

Annual Report for Stationary Combustion Turbine which fires landfill gas or digester gas equivalent to 10% or more of gross annual heat input (§63.6150(c)) (Select from Dropdown)

Annual Report for lean premix gas-fired or diffusion flame gas-fired stationary combustion turbine and use any quantity of distillate oil to fire any new or existing stationary combustion turbine (§63.6150(e)) (Select from Dropdown)

RecordId

CompanyName

AddressLine1

AddressLine2

CityName

CountyName

StateName

ZIPCode

StateFacID

MailingAddressLine1

MailingAddressLine2

MailingAddressCity

MailingAddressState

MailingAddressZIP

ContactName

ContactNumber

ReportDate

PeriodStartDate

PeriodEndDate

AddInfo

AddFile

SemiannualFlag

AnnualFlag

AnnualPremixFlag

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.: 123 Main Street

e.g.: Suite 100

e.g.: Brooklyn

e.g.: NY

e.g.: 11221

e.g.: John Smith

e.g.: (555) 555-5555

e.g.: 7/15/2020

e.g.: 01/01/2020

e.g.: 6/30/2020

e.g.: addlinfo.zip

e.g.: Yes

e.g.: Yes

e.g.: No

---

Sheet 3: Affected_Source

40 CFR Part 63, Subpart YYYY National Emission Standards for Hazardous Air Pollutants for Stationary Combustion Turbines -
§63.6150(a)-(e) Compliance Reports Spreadsheet Template
Company Record No. (Select from dropdown)	Affected Source (§63.10(e)(3)(vi) and §63.6150(a)(5)(ii))	Total Source Operating Time (hours) (§63.6150(a)(5)(iv))
RecordId	ProcessUnit	TotalOperatingTime_AS
e.g.: 1	e.g. Turbine 1	e.g.: 3580.00

---

Sheet 4: Certification

40 CFR Part 63, Subpart YYYY National Emission Standards for Hazardous Air Pollutants for Stationary Combustion Turbines -
§63.6150(a)-(e) Compliance Reports Spreadsheet Template
Company Record No. (Autofilled)	There were no excess emissions or exceedances of a parameter during this reporting period. (§63.10(e)(3)(v)) (Select from Dropdown)	There were no periods during which CPMS, CEMS, or COMS were out of control as specified in §63.8(c)(7) during the reporting period (§63.10(e)(3)(v)) (Select from Dropdown)
RecordId	PeriodDeviationFlag	CPMSComplianceFlag

---

Sheet 5: Revisions

40 CFR Part 63, Subpart YYYY National Emission Standards for Hazardous Air Pollutants for Stationary Combustion Turbines -	40 CFR Part 63, Subpart YYYY National Emission Standards for Hazardous Air Pollutants for Stationary Combustion Turbines -	40 CFR Part 63, Subpart YYYY National Emission Standards for Hazardous Air Pollutants for Stationary Combustion Turbines
Revision Number	Date	Revisions
1.00	2/10/2020	Initial Release Version
2.00	6/17/2020	Updated version/CBI, Hidden column A, added Worksheet Map
3.00	8/24/2020	Added missing formulas in cells : Deviation_Limits I24, Deviation_Summary_Limits A-D24 and F24-L24, Deviation_CEMS_CPMS J24, and A24-D25 and F24-L25, and Certification B24
4.00	8/22/2022	Removed "Required Field" notations, duplicative of reg citations and potentially misleading, added "e.g.:" to all blank example rows, Enabled filtering in most tabs, corrected number formatting of Deviation_Summary_Limits and Deviation_Summary_CMS to 2 decimal places, Added Affected_Sources tab to allow input of Total Operating Time for each Affected Source when there were no deviations, and made those values autocomplete on the Deviation Summary tabs, Corrected error on Lists tab causing some rows to not appear on the Deviation_Summary_Limits and Deviation_Summary_CMS tab, re-oriented headers and data entry to bottom align and top align respectively, Updated Welcome tab directions to reflect that all of the Deviation_Summary_Limits and Deviation_Summary_CPMS are autocompleted and the addition of the Affected Sources tab, moved Certifcation tab to after Affected_Sources, Added header to Revisions tab
ICR Draft	9/1/2022	Added PRA Information to Welocme tab