Form 5900-566 Semiannual Compliance Spreadsheet Template

NESHAP for Reinforced Plastic Composites Production (40 CFR part 63, subpart WWWW) (Renewal)

Form 5900-566_ICR No 1976_10.xlsm

NESHAP for Reinforced Plastic Composites Production (40 CFR Part 63, Subpart WWWW)

OMB: 2060-0509

Document [xlsx]
Download: xlsx | pdf

Overview

Welcome
Company_Information
No_CMS
HAP_ID
CMS_Info
CMS_Detail
Limits_Detail
Summary_Report_CMS
Summary_Report_Limits
Description_of_CMS_Changes
Certification
Revisions

Sheet 1: Welcome
63.5912 (d) Semiannual Compliance Report (Spreadsheet Template)
63.5912(d)
ICR DRAFT v1.01
11/3/2021
OMB No.: 2060-0509 Form 5900-566 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 WWWW National Emission Standards for Hazardous Air Pollutants: Reinforced Plastic Composites Production - §63.5912(d) 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 WWWW National Emission Standards for Hazardous Air Pollutants: Reinforced Plastic Composites Production.
Electronic reporting:
Electronic submission of Semiannual Compliance Reports through the EPA's Compliance and Emissions Data Reporting Interface (CEDRI) is required under §63.5912(g). 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.
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 tab (Company_Information) contains 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 to use in subsequent reports to limit subsequent data entry.

Green Tabs: The green tab (Certification) is to be completed for all sources for the Semiannual report.

Orange Tabs: The orange tab (No_CMS) is to be completed for all sources with no continuous monitoring systems (CMS). Some cells are linked to previous tabs or are calculations dependent upon data entry.

Blue Tabs: Blue tabs (HAP_ID, CMS_Info, CMS_Detail, Limits_Details, Summary_Report_CMS, Summary_Report_Limits, , and Description_of_CMS_Changes) are to be completed for sources which use CMS to comply with the organic HAP emission limit. The Summary_Report_CMS and Summary_Report_Limits tabs use information entered in the Deviation_CMS_Detail and Deviation_Limits_Detail tabs to complete.

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. Some cells have dynamic dropdown menus dependant on entry on other tabs, these will be blank until the appropriate data is completed.

Sheet 2: Company_Information
40 CFR Part 63, Subpart WWWW National Emission Standards for Hazardous Air Pollutants: Reinforced Plastic Composites Production












§63.5912(d) 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.5910(c)(1))		 Address
(§63.5910(c)(1))		 Address 2 City
(§63.5910(c)(1))		 County State Abbreviation
(§63.5910(c)(1))		 Zip Code
(§63.5910(c)(1))		 Responsible Agency Facility ID
(State Facility Identifier)		 Date of Report
(§63.5910(c)(3)		 Beginning Date of Reporting Period
(§63.5764(c)(3))		 Ending Date of
Reporting Period
(§63.5764(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/2017 e.g.: 01/01/2017 e.g.: 6/30/2017
e.g.: addlinfo.zip












































































































































Sheet 3: No_CMS
40 CFR Part 63, Subpart WWWW National Emission Standards for Hazardous Air Pollutants: Reinforced Plastic Composites Production






§63.5912(d) Semiannual Compliance Report Spreadsheet Template






Company Record No.
(Select from dropdown)		 Operation/Process Unit
(§63.5910(d))		 Organic HAP Emission Limit or Work Practice Standard Deviated From
(§63.5910(d))		 Total Operating Time of Affected Source (Hours)
(§63.5910(d)(1))		 Number of Deviations
(§63.5910(d)(2))		 Duration of Deviations
(Hours)
(§63.5910(d)(2))		 Cause of Deviation
(§63.5910(d)(2))
(Select From dropdown)		 Corrective Action Taken
(§63.5910(d)(2))
RecordId ProcessUnitDesc HAPDeviation TotalOperatingTime NumberOfDeviations DeviationDuration DeviationCause CorrectiveAction
e.g.: 1 e.g.: Spray Nozzle Cleaning e.g.: Not Use Cleaning solvent that contain HAP e.g.: 3120 e.g.: 5 e.g.: 5.05 e.g.: Other Known Causes e.g.: Replaced cleaner with HAP free








































































































































































































































































































































































































































































































































































































































Sheet 4: HAP_ID
40 CFR Part 63, Subpart WWWW National Emission Standards for Hazardous Air Pollutants: Reinforced Plastic Composites Production


§63.5912(d) Semiannual Compliance Report Spreadsheet Template


Company Record No.
(Select from dropdown)		 Process Unit Description
(§63.5910(e)(9))		 Identification of Hazardous Air Pollutant Monitored
(§63.5910(e)(8))
 Identification of Emission or Operating Parameter Limit
(§63.10(e)(3)(vi)(E))
RecordId ProcessUnitDesc HAPMonitored ParameterLimit
e.g.: 1 e.g.: North Production Line e.g.: Total Organic HAP e.g.: Total Organic HAP 95% Reduction




















































































































































































































































































































Sheet 5: CMS_Info
40 CFR Part 63, Subpart WWWW National Emission Standards for Hazardous Air Pollutants: Reinforced Plastic Composites Production


§63.5912(d) Semiannual Compliance Report Spreadsheet Template


Company Record No.
(Select from dropdown)		 Process Unit Description
(§63.5910(e)(9))
(Select from dropdown)		 Brief Description of CMS/Monitoring Equipment Manufacturer and Model Number
(§63.5910(e)(10) and §63.10(e)(3)(vi)(F))		 Date of Latest CMS Certification or Audit
(§63.5910(e)(11))
RecordId ProcessUnitDesc CMSDescription CMSAuditDate
e.g.: 1 e.g.: North Production Line e.g. Omega NB1-ICSS-14U-12 e.g. 5/7/2017




















































































































































































































































































































Sheet 6: CMS_Detail
40 CFR Part 63, Subpart WWWW National Emission Standards for Hazardous Air Pollutants: Reinforced Plastic Composites Production









§63.5912(d) Semiannual Compliance Report Spreadsheet Template









Company Record No.
(Select from dropdown)		 Process Unit Description
(§63.5910(e)(9))
(Select from dropdown)		 Brief Description of CMS/Monitoring Equipment Manufacturer and Model Number
(§63.5910(e)(10) and §63.10(e)(3)(vi)(F))
(Select From dropdown)		 Type of Deviation: CMS Inoperative or
Out of Control
(Select from dropdown)		 Starting Date CMS
Inoperative or
Out of Control
(§63.5910(e)(2) or (3))		 Starting Time CMS Inoperative or
Out of Control
(§63.5910(e)(2) or (3))		 Ending Date CMS
Inoperative or
Out of Control
(§63.5910(e)(2) or (3))		 Ending Time CMS Inoperative or
Out of Control
(§63.5910(e)(2) or (3))		 Duration CMS Inoperative
or Out of Control * (hours)
(Calculated value for use in Total Deviation Calculations on Summary Report tab)		 Cause of CMS Being
Inoperative or Out of Control
(§63.10(c)(10))
(Select From dropdown)		 Nature of Repairs or Adjustment to CMS
(§63.10(c)(12))
RecordId ProcessUnitDesc CMSDescription CMSOutageDescription CMSOutageStartDate CMSOutageStartTime CMSOutageEndDate CMSOutageEndTime CMSOutageDuration CMSOutageCause CMSAdjustment
e.g.: 1 e.g. North Production Line e.g. Omega NB1-ICSS-14U-12 e.g. CMS Inoperative e.g.: 3/2/2017 e.g.: 15:52 e.g.: 3/2/2017 e.g.: 19:15 e.g.: 72.00 e.g.: Other known causes e.g.: replaced thermocouple































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 7: Limits_Detail



40 CFR Part 63, Subpart WWWW National Emission Standards for Hazardous Air Pollutants: Reinforced Plastic Composites Production





40 CFR Part 63, Subpart WWWW National Emission Standards for Hazardous Air Pollutants: Reinforced Plastic Composites Production - §63.5910(c) Semiannual Compliance Report Spreadsheet Template

§63.5912(d) Semiannual Compliance Report Spreadsheet Template





Company Record No.
(Select from dropdown)		 Process Unit Description
(§63.5910(e)(9))
(Select from dropdown)		 Emission and Operating Parameter Limitations
(§63.10(e)(3)(vi)(E))
 Starting Date Emission Limit or Operating Parameter Limit Exceeded
(§63.10(c)(7) or (8) and §63.5910(e)(4))		 Starting Time Emission Limit or Operating Parameter Limit Exceeded
(§63.10(c)(7) or (8) and §63.5910(e)(4))		 Ending Date Emission Limit or Operating Parameter Limit Exceeded
(§63.10(c)(7) or (8) and §63.5910(e)(4))		 Ending Time Emission Limit or Operating Parameter Limit Exceeded
(§63.10(c)(7) or (8) and §63.5910(e)(4))		 Cause of Exceedance
(§63.10(c)(10) and §63.5910(e)(4)))
(Select from dropdown)		 Corrective Action Taken
(§63.10(c)(11) and §63.5910(e)(4))
(Select from dropdown)		 Calculated Duration (hours)
(Calculated value used to complete Summary Report)
RecordId ProcessUnitDesc ParameterLimit ParameterExcessStartDate ParameterExcessStartTime ParameterExcessEndDate ParameterExcessEndTime ExceedanceCause CorrectiveAction ParameterExcessDuration
e.g.: 1 e.g.: Open Molding e.g.: Carbon Absorber Carbon Bed Temperature e.g.: 3/2/2017 e.g.: 15:52 e.g.: 3/3/2017 e.g.: 15:00 e.g.: Other known causes e.g.: increased natural gas service pressure e.g.: 23.13


































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 8: Summary_Report_CMS
40 CFR Part 63, Subpart WWWW National Emission Standards for Hazardous Air Pollutants: Reinforced Plastic Composites Production









§63.5912(d) Semiannual Compliance Report Spreadsheet Template









Company Record No.
(Select from Dropdown)		 Process Unit Description
(§63.5910(e)(9)) and
(§63.10(e)(3)(vi)(D))
(Select from Dropdown)		 Brief Description of CMS/Monitoring Equipment Manufacturer and Model Number
(§63.5910(e)(10) and §63.10(e)(3)(vi)(F))
(Select From dropdown)		 Total Source
Operating Time
(hours)
(§63.10(e)(3)(vi)(H) and §63.10(c)(13)))		 Total Duration of
CMS, CEMS, or COMS
Downtime (hours)
(§63.10(e)(3)(vi)(J) and §63.5910(e)(7))
(Direct import from CMS Detail)		 Total Duration of
CMS Downtime as
a per cent of Total
Source Operating Time
(§63.10(e)(3)(vi)(J) and §63.5910(e)(7))
(Calculated result)		 Total Duration of
CMS Downtime Due
to Monitoring Equipment
Malfunctions (hours)
(§63.10(e)(3)(vi)(J))
(Direct import from CMS Detail Report)		 Total Duration of
CMS Downtime
Due to Nonmonitoring Equipment Malfunctions (hours)
(§63.10(e)(3)(vi)(J))
(Direct import from CMS Detail Report)		 Total Duration of
CMS Downtime
Due to Quality Assurance/Quality Control Calibrations (hours)
(§63.10(e)(3)(vi)(J))
(Direct import from CMS Detail Report)		 Total Duration of
CMS Downtime
Due to Other Known
Causes (hours)
(§63.10(e)(3)(vi)(J))
(Direct import from CMS Detail Report)		 Total Duration of
CMS Downtime
Due to Other Unknown
Causes (hours)
(§63.10(e)(3)(vi)(J))
(Direct import from CMS Detail Report)
RecordId ProcessUnitDesc CMSDescription TotalOperatingTime CMSDowntimeDuration CMSDowntimePercent CMSDowntimeMonitoringMal CMSDowntimeNonmonitoringMal CMSDowntimeQuality CMSDowntimeOtherKnown CMSDowntimeUnknown
e.g.: 1 e.g.: Open Molding e.g. Omega NB1-ICSS-14U-12 e.g.: 6240 e.g.: 0 e.g.: N/A e.g.: 0 e.g.: 0 e.g.: 0 e.g.: 0 e.g.: 0















































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 9: Summary_Report_Limits
40 CFR Part 63, Subpart WWWW National Emission Standards for Hazardous Air Pollutants: Reinforced Plastic Composites Production








§63.5912(d) Semiannual Compliance Report Spreadsheet Template








Company Record No.
(Select from Dropdown)		 Process Unit Description
(§63.10(e)(3)(vi)(D))
(Select from Dropdown)		 Emission and Operating Parameter Limitations
(§63.10(e)(3)(vi)(E))
(Select from dropdown)
 Total Source
Operating Time
(hours)
(§63.10(e)(3)(vi)(H) and §63.10(c)(13)))		 Total Duration of
Deviations from
Emission, Operating,
Opacity, or Visible
Emissions Limits
(hours)
(§63.10(e)(3)(vi)(I))
(Direct import from Limits Detail)		 Total Duration of
Deviations from
Emission, Operating,
Opacity, or Visible
Emissions Limits as a
per cent of
Total Source Operating Time
(§63.10(e)(3)(vi)(I))
(Calculated result)		 Total Duration of
Deviations from
Emission, Operating,
Opacity, or Visible
Emissions Limits Due to
Control Equipment Problems
(hours)
(§63.10(e)(3)(vi)(I))
(Direct import from Limits Detail)		 Total Duration of
Deviations from
Emission, Operating,
Opacity, or Visible
Emissions Limits Due to
Process Problems
(hours)
(§63.10(e)(3)(vi)(I))
(Direct import from Limits Detail)		 Total Duration of
Deviations from
Emission, Operating,
Opacity, or Visible
Emissions Limits Due to
Other Known Causes
(hours)
(§63.10(e)(3)(vi)(I))
(Direct import from Limits Detail)		 Total Duration of Deviations from Emission, Operating, Opacity, or Visible Emissions Limits Due to Other Unknown Causes (hours)
(§63.10(e)(3)(vi)(I))
(Direct import from Limits Detail)
RecordId ProcessUnitDesc ParameterLimit TotalOperatingTime EmissionsDeviationDuration EmissionsDeviationPercent EmissionsDeviationEquipment EmissionsDeviationProcess EmissionsDeviationOther EmissionsDeviationUnknown
e.g.: 1 e.g.: Open Molding e.g.: Carbon Absorber Carbon Bed Temperature e.g.: 6240 e.g.: 23.13 e.g.: 0.58% e.g.: 23.13 e.g.: 0 e.g.: 0 e.g.: 0


































































































































































































































































































































































































































































































































































































































































































































































































Sheet 10: Description_of_CMS_Changes
40 CFR Part 63, Subpart WWWW National Emission Standards for Hazardous Air Pollutants: Reinforced Plastic Composites Production
§63.5912(d) Semiannual Compliance Report Spreadsheet Template
CPMS, CEMS, COMS, Processes, or Control Changes
A description of any changes in the CPMS, CEMS, COMS, processes or controls since the last semiannual reporting period.
Company Record No.
(Select from Dropdown)		 Description of any CMS, processes, or controls which have occurred since the last reporting period (§63.5910(e)(12))
RecordId CMSChangesDesc
e.g.: 1




















Sheet 11: Certification
40 CFR Part 63, Subpart WWWW National Emission Standards for Hazardous Air Pollutants: Reinforced Plastic Composites Production



§63.5912(d) Semiannual Compliance Report Spreadsheet Template



Complete this form when you have completed the semiannual compliance report.



Company Record No.
(Autocompleted)		 Is the statement "There were no deviations from the organic HAP emissions limitations or work practice standards during the reporting period." applicable to this report? (§63.5910(c)(5))
(Select from dropdown)		 Is the statement "There were no periods during which the CMS, including CEMS, and an operating parameter system were out of control during the reporting period." applicable to this report? (§63.5910(c)(6))
(Select from dropdown)		 Have the compliance options have changed since the last compliance report?
(§63.5910(i))
(Select from dropdown)		 Was the 100 tpy organic HAP emissions threshold exceeded making the facility subject to §63.5805(a)(1) or (d)? (Any Relevant Exemption Requests Under §63.5805(e) Attached)
(§63.5910(f))
(Select from dropdown)
RecordId HAPDeviationsFlag CMSOutOfControlFlag ComplianceFlag HAPEmissionsFlag
Complete the Company_Information tab first
















































Sheet 12: Revisions
40 CFR Part 63, Subpart WWWW National Emission Standards for Hazardous Air Pollutants: Reinforced Plastic Composites Production

§63.5912(d) Semiannual Compliance Report Spreadsheet Template

Revision Number Date Revisions
1.00 5/18/2020 Initial Release Version
ICR Draft 1.01 11/3/2021 Added PRA information to Welcome tab, added header to Revisions tab, Added "e.g.:" to blank example rows to facilitate filtering, updated formatting of data entry cells to top align, wrap text, and auto-fit row height, and header row to bottom align. Revised Certification tab header rows to clarify the meaning of responses and added Not Applicable choices to dropdowns for CMS certifying statement (Column D) and for the 100 tpy statement (Column F). Updated dynamic dropdown lists to display a direction to complete teh appropriate tab rather than providing a blank list.





















File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00
© 2024 OMB.report | Privacy Policy