Form 5900-521 Semiannual Compliance Report

NESHAP for Iron and Steel Foundries (40 CFR part 63, subpart ZZZZZ) (Renewal)

63.10899c_Semiannual_Compliance_Report (v1.01).xlsm

NESHAP for Iron and Steel Foundries (Small Foundaries)

OMB: 2060-0605

Document [xlsx]
Download: xlsx | pdf

Overview

Welcome
Company_Information
Affected_Sources
CMS_Identification
Description_of_Changes
CMS_Deviation_Detail
CMS_Deviation_Summary
Limit_Deviation_Detail
Limit_Deviation_Summary
Mercury_Switches_Scrap_Option
Mercury_Switches
Certification
Revisions


Sheet 1: Welcome

63.10899(c) Semiannual Compliance Report (Spreadsheet Template)
63.10899(c)
v1.01
6/15/2021
OMB No.: 2060-0605 Form 5900-521 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 ZZZZZ National Emission Standards for Hazardous Air Pollutants: Iron and Steel Foundries Area Sources -
§63.10899(c) 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 ZZZZZ National Emission Standard for Hazardous Air Pollutants: Iron and Steel Foundries.
Electronic reporting:
Electronic submission of Semiannual Compliance Reports through the EPA's Compliance and Emissions Data Reporting Interface (CEDRI) is required under §63.10899(c). 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 worksheet 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.
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 Tabs: The gray tabs (complete in the following order; Company_Information, Affected_Sources, and CMS_Identification) contains mostly general information that is likely to be unchanged from report to report with the exception of dates and operating hours and is used in completing later tabs. 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 are completed as necessary for the facility. Complete in the following order: Description_of_Changes, CMS_Deviation_Detail, CMS_Deviation_Summary, Limit_Deviation_Detail, Limit_Deviation_Summary, Mercury_Switches_Scrap_Option, and Mercury_Switches tabs, as required. Some cells are linked to previous tabs or are calculations dependent upon data entry. The two Summary tabs, CMS_Deviation_Summary and Limit_Deviation_Summary, are autocompleted based upon entries in the respective Detail tabs.

Blue Tab: The blue tab (Certification) must be completed for each report.

Within the tabs, example rows are colored light red (from row 14 up to potentially row 23), and the XML tags (row 13) are colored green. These rows are locked; no data entry is made in these rows. Cells shaded light pink are locked and contain calculations that may not be changed. Data entry begins on row 24.

Sheet 2: Company_Information

40 CFR Part 63, Subpart ZZZZZ National Emission Standards for Hazardous Air Pollutants: Iron and Steel Foundries Area Sources-












§63.10899(c) Semiannual Compliance Report Spreadsheet Template



























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













































































































































Sheet 3: Affected_Sources

40 CFR Part 63, Subpart ZZZZZ National Emission Standards for Hazardous Air Pollutants:

Iron and Steel Foundries Area Sources - §63.10899(c) Semiannual Compliance Report Spreadsheet Template

Company Record No.
(Select from dropdown)
Brief Description of Affected Source
(§63.10899(c)(6)(i) or (c)(7)(iii))
Total Operating Hours During the Reporting Period
(§63.10899(c)(6)(i) or (c)(7)(iii))
RecordId AffectedSource_AS TotalOperatingHours_AS
e.g.: 1 e.g. Line 1 e.g.: 4221.0








































































































































































































































Sheet 4: CMS_Identification

40 CFR Part 63, Subpart ZZZZZ National Emission Standards for Hazardous Air Pollutants: Iron and Steel Foundries Area Sources -



§63.10899(c) Semiannual Compliance Report Spreadsheet Template



Company Record No.
(Autocompleted from Column D)
Brief Description of Affected Source
(§63.10899(c)(7)(iii))
(Autocompleted from Column D)
Company Record Number and Affected Source
(Select from dropdown)
Monitoring Equipment Manufacturer and Model Number
(§63.10899(c)(7)(i))
Date of Last CMS
Certification or Audit
(§63.10899(c)(7)(ii))
RecordId AffectedSource_Identification RecordSource_Identification Manufacturer_Identification CMSAuditDate_Identification
e.g.: 1 e.g. Line 1 e.g.: 1 Line 1 e.g.: TC1792 PM Filter Bank Inlet Temperature e.g.: 2/2/2020


































































































































































































































































































































































































Sheet 5: Description_of_Changes

40 CFR Part 63, Subpart ZZZZZ National Emission Standards for Hazardous Air Pollutants: Iron and Steel Foundries Area Sources -
§63.10899(c) Semiannual Compliance Report Spreadsheet Template
CPMS, CEMS, COMS, Processes, or Control Changes
Company Record No.
(Select from dropdown)
Description of any changes in continuous monitoring systems, processes, or controls since the last reporting period
(§63.10899(c)(7)(iv))
RecordId CmsChangesDesc





















Sheet 6: CMS_Deviation_Detail

40 CFR Part 63, Subpart ZZZZZ National Emission Standards for Hazardous Air Pollutants: Iron and Steel Foundries Area Sources -








§63.10899(c) Semiannual Compliance Report Spreadsheet Template








Company Record No.
(Autocompleted from Column E)
Brief Description of Affected Source
(§63.10899(c)(7)(iii))
(Autocompleted from Column E)
Monitoring Equipment Manufacturer and Model Number
(§63.10899(c)(7)(i))
(Autocompleted from Column E)
Company Record Number, Affected Source, and Brief Description of Monitoring Equipment
(Select from dropdown)
Type of Deviation
(§63.10899(c)(7)(v)(B))
(Select from dropdown)
Starting Date CMS
Inoperable or Out of Control
(§63.10899(c)(7)(v)(A))
Starting Time CMS Inoperable or Out of Control
(§63.10899(c)(7)(v)(A))
Duration CMS Inoperable
or Out of Control (hours)
(§63.10899(c)(7)(v)(A))
Cause of Deviation
(§63.10899(c)(7)(v)(C))
(Select from dropdown)
Corrective Action Taken
(§63.10899(c)(7)(v)(C))
RecordId AffectedSource_CMSDetail Manufacturer_CMSDetail RecordSource_CMSDetail DeviationDescription_CMSDetail DeviationStartDate_CMSDetail DeviationStartTime_CMSDetail DeviationDuration_CMSDetail DeviationCause_CMSDetail DeviationAction_CMSDetail
e.g.: 1 e.g. Line 1 e.g.: TC1792 PM Filter Bank Inlet Temperature e.g.: 1 Line 1 TC1792 PM Filter Bank Inlet Temperature e.g.: Out-of-control e.g.: 3/25/2020 e.g.: 15:52 e.g.: 72.00 e.g.: Monitoring System Malfunction e.g.: Replaced wire harness



































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 7: CMS_Deviation_Summary

40 CFR Part 63, Subpart ZZZZZ National Emission Standards for Hazardous Air Pollutants: Iron and Steel Foundries Area Sources -









§63.10899(c) Semiannual Compliance Report Spreadsheet Template









Company Record No.
(Autocompleted)
Affected Source or Equipment
(§63.10899(c)(7)(iii))
(Autocompleted)
Monitoring Equipment Manufacturer and Model Number
(§63.10899(c)(7)(i))
(Autocompleted)
Total Source Operating Time (Hours)
(§63.10899(c)(7)(iii))
(Autocompleted)
Total Duration of
CMS Downtime (hours)
(§63.10899(c)(7)(vi))
(Calculated value)
Total Duration of
CMS Downtime as
a per cent of Total
Source Operating Time
(§63.10899(c)(7)(vi))
(Calculated value )
Total Duration of
CMS Downtime Due to
Monitoring System Malfunctions
(§63.10899(c)(7)(vi))
(Calculated value)
Total Duration of
CMS Downtime Due to
Nonmonitoring Equipment Malfunctions
(§63.10899(c)(7)(vi))
(Calculated value)
Total Duration of
CMS Downtime Due to
Quality Assurance/Quality Control Calibrations
(§63.10899(c)(7)(vi))
(Calculated value)
Total Duration of
CMS Downtime Due to
Other Known Causes
(§63.10899(c)(7)(vi))
(Calculated value)
Total Duration of
CMS Downtime Due to Unknown Causes
(§63.10899(c)(7)(vi))
(Calculated value)
RecordId AffectedSource_CMSSummary Manufacturer_CMSSummary TotalOperatingTime_CMSSummary DowntimeDuration_CMSSummary DowntimePercent_CMSSummary DowntimeMonitoring_CMSSummary DowntimeNonmonitoring_CMSSummary DowntimeControl_CMSSummary DowntimeOther_CMSSummary DowntimeUnknown_CMSSummary
e.g.: 1 e.g.: Line 1 e.g.: TC1792 PM Filter Bank Inlet Temperature e.g.: 6240 e.g.: 0 e.g.: N/A e.g.: 36.2 e.g.: 36.2 e.g.: 0 e.g.: 0 e.g.: 0
















































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 8: Limit_Deviation_Detail

40 CFR Part 63, Subpart ZZZZZ National Emission Standards for Hazardous Air Pollutants: Iron and Steel Foundries Area Sources -


























§63.10899(c) Semiannual Compliance Report Spreadsheet Template


























Company Record No.
(Autocompleted from Column D)
Brief Description of Affected Source
(§63.10899(c)(6)(i))
(Autocompleted from Column D)
Company Record Number and Affected Source
(Select from dropdown)
Emission Limitation or Work Practice Deviated From
(§63.10899(c)(6)(ii))
(Select from dropdown)
Starting Date of Deviation
(§63.10899(c)(6)(ii)(A))
Starting Time of
Deviation
(§63.10899(c)(6)(ii)(A))
Duration of
Deviation
(hours)
(§63.10899(c)(6)(ii)(A))
Cause of Deviation
(§63.10899(c)(6)(ii)(A))
(Select from dropdown)
Corrective Action Taken
(§63.10899(c)(6)(ii)(A))
Method Used to Estimate Emissions
(§63.10899(c)(6)(ii)(B))
(Select from dropdown)
Pollutant 1
(§63.10899(c)(6)(ii)(B))
(Select from dropdown)
Estimate of Emissions
Pollutant 1
(§63.10899(c)(6)(ii)(B))
Units of Emissions Estimate
Pollutant 1
(§63.10899(c)(6)(ii)(B))
(Select from dropdown)
Pollutant 2
(§63.10899(c)(6)(ii)(B))
(Select from dropdown)
(If necessary)
Estimate of Emissions
Pollutant 2
(§63.10899(c)(6)(ii)(B))
(If necessary)
Units of Emissions Estimate
Pollutant 2
(§63.10899(c)(6)(ii)(B))
(Select from dropdown)
(If necessary)
Pollutant 3
(§63.10899(c)(6)(ii)(B))
(Select from dropdown)
(If necessary)
Estimate of Emissions
Pollutant 3
(§63.10899(c)(6)(ii)(B))
(If necessary)
Units of Emissions Estimate
Pollutant 3
(§63.10899(c)(6)(ii)(B))
(Select from dropdown)
(If necessary)
Pollutant 4
(§63.10899(c)(6)(ii)(B))
(Select from dropdown)
(If necessary)
Estimate of Emissions
Pollutant 4
(§63.10899(c)(6)(ii)(B))
(If necessary)
Units of Emissions Estimate
Pollutant 4
(§63.10899(c)(6)(ii)(B))
(Select from dropdown)
(If necessary)
Pollutant 5
(§63.10899(c)(6)(ii)(B))
(Select from dropdown)
(If necessary)
Estimate of Emissions
Pollutant 5
(§63.10899(c)(6)(ii)(B))
(If necessary)
Units of Emissions Estimate
Pollutant 5
(§63.10899(c)(6)(ii)(B))
(Select from dropdown)
(If necessary)
Pollutant 6
(§63.10899(c)(6)(ii)(B))
(Select from dropdown)
(If necessary)
Estimate of Emissions
Pollutant 6
(§63.10899(c)(6)(ii)(B))
(If necessary)
Units of Emissions Estimate
Pollutant 6
(§63.10899(c)(6)(ii)(B))
(Select from dropdown)
(If necessary)
RecordId ProcessUnitDesc_LimitDetail RecordSource_LimitDetail DeviceDeviation_LimitDetail DeviationStartDate_LimitDetail DeviationStartTime_LimitDetail DeviationDuration_LimitDetail DeviationCause_LimitDetail CorrectiveAction_LimitDetail EstimationMethod_LimitDetail Pollutant1_LimitDetail Pollutant1Emissions_LimitDetail Pollutant1Units_LimitDetail Pollutant2_LimitDetail Pollutant2Emissions_LimitDetail Pollutant2Units_LimitDetail Pollutant3_LimitDetail Pollutant3Emissions_LimitDetail Pollutant3Units_LimitDetail Pollutant4_LimitDetail Pollutant4Emissions_LimitDetail Pollutant4Units_LimitDetail Pollutant5_LimitDetail Pollutant5Emissions_LimitDetail Pollutant5Unit_LimitDetail Pollutant6_LimitDetail Pollutant6Emissions_LimitDetail Pollutant6Unit_LimitDetail
e.g.: 1 e.g.: Line 1 e.g.: 1 Line 1 e.g.: ESP Voltage e.g.: 2/12/2020 e.g.: 13:05 e.g.: 16.08 e.g.: Control Equipment Problems e.g.: Replaced wire harness e.g.: Engineering calculations e.g.: Particulate Matter e.g.: 0.1 e.g.: tons e.g.: Total Metal HAP e.g.: 0.1 e.g.: tons e.g.: Lead e.g.: 0.07 e.g.: tons e.g.: Lead e.g.: 0.08 e.g.: tons e.g.: Lead e.g.: 0.09 e.g.: tons e.g.: Lead e.g.: 0.10 e.g.: tons













































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 9: Limit_Deviation_Summary

40 CFR Part 63, Subpart ZZZZZ National Emission Standards for Hazardous Air Pollutants: Iron and Steel Foundries Area Sources -









§63.10899(c) Semiannual Compliance Report Spreadsheet Template









Company Record No.
(Autocompleted)
Affected Source
(§63.10899(c)(6)(i))
(Autocompleted)
Emission Limitation or Work Practice Deviated From
(§63.10899(c)(6)(ii))
(Autocompleted)
Total Source Operating Time (Hours)
(§63.10899(c)(6)(i))
(Autocompleted)
Total Duration of
Deviations from
Emission Limitation or Work Practice
(§63.10899(c)(6)(iii))
(Calculated value)
Total Duration of Deviations from Emission Limitation or Work Practice as a percent of Total Source Operating Time
(§63.10899(c)(6)(iii))
(Calculated value)
Total Duration of
Deviations from
Emission Limitation or Work Practice Due to
Startup/Shutdown
(§63.10899(c)(6)(iii))
(Calculated value)
Total Duration of Deviations from Emission Limitation or Work Practice Due to Control Equipment Problems
(§63.10899(c)(6)(iii))
(Calculated value)
Total Duration of
Deviations from
Emission Limitation or Work Practice Due to
Process Problems
(§63.10899(c)(6)(iii))
(Calculated value)
Total Duration of
Deviations from
Emission or
Opacity Limits Due to
Other Known Causes
(§63.10899(c)(6)(iii))
(Calculated value)
Total Duration of Deviations from Emission or Opacity Limits Due to Unknown Causes
(§63.10899(c)(6)(iii))
(Calculated value)
RecordId AffectedSource_LimitSummary DeviceDeviationBypass_DeviationSummary TotalOperatingTime_DeviationSummary TotalDeviationDuration_DeviationSummary TotalDeviationPercent_DeviationSummary StartupCausedDeviation_DeviationSummary EquipmentCausedDeviation_DeviationSummary ProcessCausedDeviation_DeviationSummary OtherCausedDeviation_DeviationSummary UnknownCausedDeviation_DeviationSummary
e.g.: 1 e.g.: Line 1 e.g.: Particulate Matter e.g.: 6240 e.g.: 36.2 e.g.: 0.58% e.g.: 36.2 e.g.: 36.2 e.g.: 0 e.g.: 0 e.g.: 0
















































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 10: Mercury_Switches_Scrap_Option

40 CFR Part 63, Subpart ZZZZZ National Emission Standards for Hazardous Air Pollutants: Iron and Steel Foundries Area Sources -

§63.10899(c) Semiannual Compliance Report Spreadsheet Template

Company Record No.
(Select from dropdown)
Scrap Provider, Contract, or Shipment
(§63.10899(c)(8))
Option in §63.10885(b)
(§63.10899(c)(8))
(Select from dropdown)
RecordId ScrapProvider ScrapOption
e.g.: 1 e.g.: AAA Auto Scrap e.g.: Site Specific Mercury Plan

Sheet 11: Mercury_Switches

40 CFR Part 63, Subpart ZZZZZ National Emission Standards for Hazardous Air Pollutants: Iron and Steel Foundries Area Sources -






§63.10899(c) Semiannual Compliance Report Spreadsheet Template






This sheet only needs to be completed if the site-specific mercury plan is used as the compliance option.






Company Record No.
(Select from dropdown)
Number of Mercury Switches Removed
(§63.10899(c)(9)(i))
(Enter either Number (Column C) or Weight (Column D))
Weight of Mercury Recovered and Properly Managed
(§63.10899(c)(9)(i))
(Enter either Number (Column C) or Weight (Column D))
Units of Weight of Mercury
(§63.10899(c)(9)(i))
(Select from dropdown)
Estimate of Number of Vehicle Processed
(§63.10899(c)(9)(i))
Estimate of Percent of Mercury Switches Recovered
(§63.10899(c)(9)(i))
I Certify That The Recovered Mercury Switches Were Recycled at RCRA-Permitted Facilities.
(§63.10899(c)(9)(ii))
(Select from dropdown)
The Facility Has Conducted Periodic Inspections or Taken Other Means of Corroboration as Required Under §63.10885(b)(1)(ii)(C).
(§63.10899(c)(9)(iii))
(Select from dropdown)
RecordId SwitchesRemoved MercuryWeightRemoved MercuryUnits VehiclesProcessed PercentSwitchesRecovered SwitchRecycledFlag InspectionsFlag
e.g.: 1 e.g.: 640 e.g.: 5.25 e.g.: kg e.g.: 650 e.g.: 80.00% e.g.: Yes e.g.: Yes

















































































Sheet 12: Certification

40 CFR Part 63, Subpart ZZZZZ National Emission Standards for Hazardous Air Pollutants:

Iron and Steel Foundries Area Sources - §63.10899(c) Semiannual Compliance Report Spreadsheet Template

Company Record No.
(Autocompleted)
Is the statement "There were no deviations from the emissions limitations, pollution prevention management practices, or operation and maintenance requirements during the reporting period" applicable?
(§63.10899(c)(4))
(Select from Dropdown)
Is the statement "There were no periods during which a CMS was inoperable or out-of-control during the reporting period" applicable?
(§63.10899(c)(5))
(Select from Dropdown)
RecordId DeviationsFlag CMSPeriodFlag































Sheet 13: Revisions

Revision Number Date Revisions
1.00 6/9/2020 Initial Release Version
1.01 6/15/2021 Removed confusing and inconsistent asterisk and required field labelling, adjusted some column widths and orientations, added PRA information and form number





















File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy