5900-647 63.5580g Semiannual Compliance Report

NESHAP for Cellulose Products Manufacturing (40 CFR part 63, subpart UUUU) (Renewal)

Form 5900-647 --63.5580_g_semiannual_compliance_report (1974.12).xlsm

OMB: 2060-0488

Document [xlsx]
Download: xlsx | pdf

Overview

Welcome
Company_Information
No CMS - Deviation - Limits
Process_&_CMS_Identification
Using CMS - Malfunction
Using CMS - Inop_OoC - CMS
Downtime - CMS Summary
Using CMS - Deviation - Limits
Using CMS - Deviation - Summary
Deviation - Daily Averages
Using CMS - Descrip of Changes
Semiannual - Certification
Revisions


Sheet 1: Welcome

63.5580(g) Semiannual Compliance Report (Spreadsheet Template)
63.5580(g)
ICR Draft
9/7/2023
OMB No.: 2060-0488 Form 5900-647 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 UUUU National Emission Standards for Hazardous Air Pollutants for Cellulose Products Manufacturing - §63.5580 Semiannual Compliance Report Spreadsheet Template
Welcome and Instructions
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 UUUU National Emission Standard for Hazardous Air Pollutants for Cellulose Products Manufacturing.
Electronic reporting:
Electronic submission of Semiannual Compliance Reports through the EPA's Compliance and Emissions Data Reporting (CEDRI) is required under §63.5580(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.
Do not submit information you claim as confidential business information (CBI) to EPA via CEDRI. EPA will make all the information submitted through CEDRI available to the public without further notice to you. Anything submitted using CEDRI cannot later be claimed to be CBI. Furthermore, under CAA section 114(c) emissions data is not entitled to confidential treatment and requires EPA to make emissions data available to the public. Thus, emissions data will not be protected as CBI and will be made publicly available.

Although we do not expect persons to assert a claim of CBI, if persons wish to assert a CBI claim, you must submit the report via CEDRI with the CBI omitted and mail a complete report, including any information claimed to be CBI, to EPA on a compact disc, flash drive, or other commonly used electronic storage media via U.S. postal service. You must mark the outside of the digital storage media as CBI and then identify electronically within the digital storage media the specific information that is claimed as CBI. Mail the media to the address in the referencing federal regulation. If no address is specified, mail the media to:

U.S. EPA/OAQPS/CORE CBI Office Attention: Group Leader,
Measurement Policy Group MD C404-02
4930 Old Page Rd
Durham, North Carolina 27703
IMPORTANT: The spreadsheet must be uploaded into CEDRI as a single ZIP file, which must include this Excel workbook and any related attachments that were referenced in the workbook (i.e., additional information file found in the "Company Information" worksheet).

Note: If you are uploading file attachments for your report, the uploaded files may be in any format (e.g., ZIP, docx, PDF). If you would like to include an Excel file(s) as an attachment, you must first zip the Excel file(s) into a separate ZIP file to the master ZIP file that will be uploaded into CEDRI.

Once all data have been entered in the worksheet, combine this Excel workbook and all attachment files (including any ZIP file containing separate excel file(s), if applicable) into a single ZIP file for upload to CEDRI.

Please ensure your report includes all of the required data elements found in the listed citations below for this spreadsheet upload submission.
Template Navigation and Tabs to Complete:
White Tabs: The white tabs (Welcome and Revisions) contain instructions and information about the spreadsheet. t 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 for use in subsequent reports to limit subsequent data entry.

Green Tabs: Green tabs (Process_&_CMS_Identification, Using CMS - Malfunction, Using CMS - Inop_OoC - CMS, Downtime - CMS Summary, Using CMS - Deviation - Limits, Using CMS - Deviation Summary, Deviation - Daily Averages, Using CMS - Descrip of Changes) are to be completed as necessary to complete the Semiannual report. Some cells are linked to previous tabs or are calculations dependant upon data entry. t Blue Tab: The blue tab (No CMS - Deviation - Limits) is to be completed for deviations that occur where there is no continuous monitoring system. t Yellow Tab: The yellow tab (Semiannual - Certification) is to be completed for deviations that occur where there is no continuous monitoring system.

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.
Certification:
Fill out the Semiannual - Certification tab to complete the certification statements of §§63.5580(c)(2), (c)(5)-(6), and (f).

Sheet 2: Company_Information

40 CFR Part 63, Subpart UUUU National Emission Standards for Hazardous Air Pollutants for Cellulose Products Manufacturing - §63.5580 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.5580(c)(1))
Address
(§63.5580(c)(1))
Address 2 City
(§63.5580(c)(1))
County State Abbreviation
(§63.5580(c)(1))
Zip Code
(§63.5580(c)(1))
Responsible Agency Facility ID
(State Facility Identifier)
Date of Report
(§63.5580(c)(3))
Beginning Date of Reporting Period
(§63.5580(c)(3))
Ending Date of
Reporting Period
(§63.5580(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.: 7/15/2020 e.g.: 01/01/2020 e.g.: 6/30/2020 e.g.: e.g.: addlinfo.zip













































































































































Sheet 3: No CMS - Deviation - Limits

40 CFR Part 63, Subpart UUUU National Emission Standards for Hazardous Air Pollutants for Cellulose Products Manufacturing - §63.5580 Semiannual Compliance Report Spreadsheet Template





Company Record No.
(Select from Dropdown)
Affected Source
(§63.5580(d))
Total
Operating Time of Affected Source During the Reporting Period
(§63.5580(d)(1))
Number of Deviations (§63.5580(d)(2)) Duration of
Deviation
(§63.5580(d)(2))
Cause of Deviation
(including unkown cause, if applicable)
(§63.5580(d)(2))
Corrective Action Taken
(§63.5580(d)(2))
RecordId AffectedSource TotalOperatingTime DeviationCount DeviationDuration DeviationCause CorrectiveAction
e.g.: 1 e.g.: Line 1 e.g. : 6240 hrs e.g.: 10 e.g.: 16.08 hrs e.g.: Control Equipment Problems e.g.: replaced thermocouple




























































































































































































































































































































































































































































































































































Sheet 4: Process_&_CMS_Identification

40 CFR Part 63, Subpart UUUU National Emission Standards for Hazardous Air Pollutants for Cellulose Products Manufacturing -



§63.5580 Semiannual Compliance Report Spreadsheet Template



Company Record No.
(Select from Dropdown)
Process Unit Description
(§63.5580(e)(9))
Brief Description of CMS
(§63.5580(e)(10))
Identification of Hazardous Air Pollutant Known To Be in Emission Stream
(§63.5580(e)(8))
Date of Latest CEMS
Certification or Audit or CPMS Inspection, Calibration, or Validation Check
(§63.5580(e)(11))
RecordId ProcessUnitDesc MonitorEqDesc Pollutant CPMSAuditDate
e.g.: 1 e.g. Line 1 e.g.: TC1792 PM Filter Bank Inlet Temperature e.g.: Methanol e.g.: 2/2/2020


































































































































































































































































































































































































Sheet 5: Using CMS - Malfunction

40 CFR Part 63, Subpart UUUU National Emission Standards for Hazardous Air Pollutants for Cellulose Products Manufacturing -




§63.5580 Semiannual Compliance Report Spreadsheet Template




Company Record No.
(Select from Dropdown)
Process Unit Description
(§63.5580(e)(9))
(Select from Dropdown)
Starting Date Malfunction
(§63.5580(e)(1))
Starting Time Malfunction
(§63.5580(e)(1))
Ending Date Malfunction
(§63.5580(e)(1))
Ending Time Malfunction
(§63.5580(e)(1))
RecordId ProcessUnitDesc MalfunctionStartDate MalfunctionStartTime MalfunctionEndDate MalfunctionEndTime
e.g.: 1 e.g. Line 1 e.g.: 3/2/2020 e.g.: 15:52 e.g.: 3/2/2020 e.g.: 17:45











































































































































































































































































































































































































































































Sheet 6: Using CMS - Inop_OoC - CMS

40 CFR Part 63, Subpart UUUU National Emission Standards for Hazardous Air Pollutants for Cellulose Products Manufacturing - §63.5580 Semiannual Compliance Report Spreadsheet Template





Company Record No.
(Select from Dropdown)
Process Unit Description
(§63.5580(e)(9))
(Select from Dropdown)
Brief Description of CMS
(§63.5580(e)(10))
(Select from Dropdown)
CMS Inoperative or
Out of Control (§63.5580(e)(2) and (3))
(Select from Dropdown)
Date CMS
Inoperative or
Out of Control
(§63.5580(e)(2) or (3))
Time CMS Inoperative or
Out of Control
(§63.5580(e)(2) or (3))
Duration CMS Inoperative
or Out of Control (hours)
(§63.5580(e)(2) or (3))
RecordId ProcessUnitDesc MonitorEqDesc CMSOutageDescription CMSOutageDate CMSOutageTime CMSOutageDuration
e.g.: 1 e.g. Line 1 e.g.: TC1792 PM Filter Bank Inlet Temperature e.g. Inoperative e.g.: 3/2/2020-3/5/2020 e.g.: 15:52 e.g.: 72




























































































































































































































































































































































































































































































































































Sheet 7: Downtime - CMS Summary

40 CFR Part 63, Subpart UUUU National Emission Standards for Hazardous Air Pollutants for Cellulose Products Manufacturing - §63.5580 Semiannual Compliance Report Spreadsheet Template




Company Record No.
(Autocompleted)
Process Unit Description
(§63.5580(e)(9))
(Autocompleted)
Brief Description of CMS
(§63.5580(e)(10))
(Autocompleted)
Total Source
Operating Time
(hours) (§63.5580(e)(7))
Total Duration of
CMS Downtime
(hours)
(§63.5580(e)(7))
(Calculated value)
Total Duration of
CMS Downtime as
a per cent of Total
Source Operating Time
(§63.5580(e)(7))
(Calculated value)
RecordId ProcessUnitDesc MonitorEqDesc TotalOperatingTime CMSDowntimeDuration CMSDowntimePercent
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















































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 8: Using CMS - Deviation - Limits

40 CFR Part 63, Subpart UUUU National Emission Standards for Hazardous Air Pollutants for Cellulose Products Manufacturing - §63.5580 Semiannual Compliance Report Spreadsheet Template









Company Record No.
(Select from Dropdown)
Process Unit Description
(§63.5580(e)(9))
(Select from Dropdown)
Type of Operating Period
(§63.5580(e)(4))
(Select from Dropdown)
Starting Date of Deviation
(§63.5580(e)(4))
Starting Time of
Deviation
(§63.5580(e)(4))
Ending Date of
Deviation
(§63.5580(e)(4))
Ending Time of
Deviation
(§63.5580(e)(4))
Duration of Deviation
(hours)
(§63.5580(e)(5))
(Used for calculations on Deviation - Summary tab)
Cause of Deviation
(§63.5580(e)(6))
(Select from Dropdown)
Estimate of the Quantity of Each Regulated Pollutant (§63.5580(e)(14)) Method Used to Estimate Emissions (§63.5580(e)(14))
RecordId ProcessUnitDesc OperatingPeriod DeviationStartDate DeviationStartTime DeviationEndDate DeviationEndTime DeviationDuration DeviationCause EmissionQuantity EstimationMethod
e.g.: 1 e.g.: Line 1 e.g.: Other Operating Period e.g.: 2/12/2020 e.g.: 13:05 e.g.: 2/13/2020 e.g.: 08:00 e.g.: 18.92 e.g.: Control Equipment Problems e.g.: 16 lbs e.g.: engineering estimate











































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 9: Using CMS - Deviation - Summary

40 CFR Part 63, Subpart UUUU National Emission Standards for Hazardous Air Pollutants for Cellulose Products Manufacturing - §63.5580 Semiannual Compliance Report Spreadsheet Template









Company Record No.
(Autocompleted)
Process Unit Description
(§63.5580(e)(9))
(Autocompleted)
Total Source
Operating Time
(hours)
(For autocalculation of Total Duration as a percent of operating time, may also be manually entered)
Total Duration of
Deviations from Emission or Operating Limit
(hours)
(§63.5580(e)(5))
(Calculated Value)
Total Duration of
Deviations from Emission or Operating Limit as a
Percent of
Total Source Operating Time
(§63.5580(e)(5))
(Calculated Value or Manual Entry)
Total Duration of
Deviations from
Emission or Operating
Limit Due to Startup
(hours)
(§63.5580(e)(6))
(Calculated Value)
Total Duration of
Deviations from
Emission or Operating
Limit Due to Shutdown
(hours)
(§63.5580(e)(6))
(Calculated Value)
Total Duration of
Deviations from
Emission or Operating
Limit Due to Control Equipment Problems
(hours)
(§63.5580(e)(6))
(Calculated Value)
Total Duration of
Deviations from
Emission or Operating
Limits Due to
Process Problems
(hours)
(§63.5580(e)(6))
(Calculated Value)
Total Duration of
Deviations from
Emission or Operating
Limits Due to
Other Known Causes
(hours)
(§63.5580(e)(6))
(Calculated Value)
Total Duration of Deviations from Emission or Operating Limits Due to Other Unknown Causes (hours)
(§63.5580(e)(6))
(Calculated Value)
RecordId ProcessUnitDesc TotalOperatingTime TotalDeviationDuration TotalDeviationPercent StartupCausedDeviation ShutdownCausedDeviation EquipmentCausedDeviation ProcessCausedDeviation OtherCausedDeviation UnknownCausedDeviation
e.g.: 1 e.g.: Line 1 e.g.: 6240 e.g.: 18.92 e.g.: 0.30% e.g.: 0.00 e.g.: 0.00 e.g.: 18.92 e.g.: 0.00 e.g.: 0.00 e.g.: 0.00
















































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 10: Deviation - Daily Averages

40 CFR Part 63, Subpart UUUU National Emission Standards for Hazardous Air Pollutants for Cellulose Products Manufacturing - §63.5580 Semiannual Compliance Report Spreadsheet Template




Company Record No.
(Select from Dropdown)
Process Unit Description
(§63.5580(e)(9))
(Select from Dropdown)
Emission or Operating
Limit Deviated From or Failed to Meet
(§63.5580(e))
(Select from dropdown or Type site specific limit)
Applicable Operating Parameter Limit
(§63.5580(e))
Date of Deviation
(§63.5580(e))
Daily Average of Monitored Operating Parameter
(§63.5580(e)(13))
RecordId ProcessUnitDesc OperatingLimit ParameterLimit DeviationDate ParameterAverage
e.g.: 1 e.g.: Line 1 e.g.: Maximum gas temperature at inlet to PM control device e.g. 500 F e.g.: 2/12/2020 e.g.: 16.08














































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 11: Using CMS - Descrip of Changes

40 CFR Part 63, Subpart UUUU National Emission Standards for Hazardous Air Pollutants for Cellulose Products Manufacturing -
§63.5580 Semiannual Compliance Report Spreadsheet Template
CMS, Process, or Control Changes
Company Record No.
(Autocompleted)
Description of any changes in CMS, processes, or controls since the last reporting period
(§63.5580(e)(12))
RecordId PeriodChangeDesc





















Sheet 12: Semiannual - Certification

40 CFR Part 63, Subpart UUUU National Emission Standards for Hazardous Air Pollutants for Cellulose Products Manufacturing -


§63.5580 Semiannual Compliance Report Spreadsheet Template


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


Company Record No.
(Autocompleted)
There were no deviations from emission limits, operating limits, or work practice standards during the reporting period
(§63.5580(c)(5))
(Select from Dropdown)
There were no periods during which CMS was out of control during the reporting period
(§63.5580(c)(6))
(Select from Dropdown)
Pursuant to §63.5580(f), all required deviation information was submitted in the semiannial monitoring report required by §70.6(a)(3)(iii)(A) or §71.6(a)(3)(iii)(A).
(Select from Dropdown)
RecordId OperationDeviationFlag PeriodDeviationFlag DeviationInformationFlag









































Sheet 13: Revisions

40 CFR Part 63, Subpart UUUU National Emission Standards for Hazardous Air Pollutants for Cellulose Products Manufacturing -

§63.5580 Semiannual Compliance Report Spreadsheet Template

Revision Number Date Revisions
1.00 1/20/2020 Version for comment
1.10
Finalized Release Version - wrap text added and fixed duration formulas
2.00 3/27/2020 Added hidden mapping sheet and hidden column A to accommodate CEDRI EXCEL JSON Parser
2.01 5/12/2020 Updated CBI Disclaimer
3.00 8/10/2020 Corrected spelling mistake on DeviationStartTime field XML tag; file name changed
ICR Draft 9/7/2023 Added PRA information and form number to Welcome tab, Removed "*" and Required Field" labelling (redundant with addition of regulatory citation), revise cell orientation throughout, added e.g. to blank example rows to ease filtering, enabled filtering on Summary tabs, hid blank non-data entry rows, Added Header to Revisions tab









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

© 2024 OMB.report | Privacy Policy