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). |
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 | |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
File Modified | 0000-00-00 |
File Created | 0000-00-00 |