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) (1).xlsm
NESHAP for Iron and Steel Foundries (Large Foundries)
OMB: 2060-0605
Document [xlsx]
Download: xlsx | pdf
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
Overview
WelcomeCompany_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 Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
| File Modified | 0000-00-00 |
| File Created | 0000-00-00 |
© 2024 OMB.report | Privacy Policy