5900-604 Semiannual Compliance Report

---

Overview

Welcome
Company_Information
Limit_Deviation_Details_No_CMS
CMS_Identification
CMS_Malfunctions
CMS_Inoperative_OoC
CMS_Downtime_Summary
Limit_Deviation_w_CMS_Detail
Limit_Deviation_w_CMS_Summary
Description_of_Changes
No_Deviations_no_out_control
Revisions

---

Sheet 1: Welcome

63.7131(g) Semiannual Compliance Report (Spreadsheet Template)

63.7131(g)

ICR Draft

9/28/2022

OMB No.: 2060-0544 Form 5900-604 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 AAAAA National Emission Standards for Hazardous Air Pollutants for Lime Manufacturing Plants

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 AAAAA National Emission Standard for Hazardous Air Pollutants: for Lime Manufacturing Plants.

Electronic reporting:
Electronic submission of Semiannual Compliance Reports through the EPA's Compliance and Emissions Data Reporting Interface (CEDRI) is required under §63.7131(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 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: Sector Lead Lime Manufacturing 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:
Gray Tabs (Complete first): 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 are completed as necessary for the facility. If a facility does not use a continuous monitoring system (CMS) to comply, complete in the following order; Limit_Deviation_Detail_No_CMS, Description_of_Changes, and No_Deviations_no_out_of_control. If the facility uses CMS to comply , complete in the following order; CMS_Identification, CMS_Deviation_Detail, CMS_Deviation_Summary, Limit_Deviation_w_CMS_Detail, Limit_Deviation_w_CMS_Summary, Description_of_Changes, and No_Deviations_no_out_of_control. Some cells are linked to previous tabs or are calculations dependent upon data entry.

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.

The statement by a responsible official certifying the truth, accuracy, and completeness of the report required by §63.7131(c)(2) is accomplished by the certifying step during submittal to CEDRI.

---

Sheet 2: Company_Information

40 CFR Part 63, Subpart AAAAA National Emission Standards for Hazardous Air Pollutants for Lime Manufacturing Plants

§63.7131 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.7131(c)(1))

Address (§63.7131(c)(1))

Address 2

City (§63.7131(c)(1))

County

State Abbreviation (§63.7131(c)(1)) (Select from dropdown)

Zip Code (§63.7131(c)(1))

Responsible Agency Facility ID (State Facility Identifier)

Date of Report (§63.7131(c)(3))

Beginning Date of Reporting Period (§63.7131(c)(3))

Ending Date of Reporting Period (§63.7131(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: Limit_Deviation_Details_No_CMS

40 CFR Part 63, Subpart AAAAA National Emission Standards for Hazardous Air Pollutants for Lime Manufacturing Plants
§63.7131 Semiannual Compliance Report Spreadsheet Template
Company Record No. (Select from dropdown)	Emission or Operating Limit Deviated From (§63.7131(d)) (Select from Dropdown)	Total Source Operating Time (hours) (§63.7131(d)(1))	Number of Deviations (§63.7131(d)(2))	Duration of Deviation (hours and minutes for opacity) (§63.7131(d)(2))	Cause of Deviation (§63.7131(d)(2)) (Select from dropdown)	Corrective Action (§63.7131(d)(2))	Estimate of quantity of regulated pollutant emitted over emission limit (§63.7131(d)(3))	Description of method used to estimate the emissions (§63.7131(d)(3))
RecordId	DeviceDeviationBypass	TotalOperatingTime	DeviationNumber	DeviationDuration	DeviationCause	CorrectiveAction	EmissionQuantity	EstimationMethod
e.g.: 1	e.g.: Particulate Matter	e.g.: 4380	e.g.:1	e.g.: 16.08	e.g.: Control Equipment Problems	e.g.: Increased water spray	e.g.: 2.1 tons	e.g.: Engineering judgement
e.g.: 1	e.g.: Operation of capture system	e.g.: 4380	e.g.:1	e.g.: 22.35	e.g.: Control Equipment Problems	e.g.: repaired broken ductwork	e.g.: 1.5 lb PM, 0.05 lb Hg, 2.0 lb HCl	e.g.: Engineering judgement and emission factors

---

Sheet 4: CMS_Identification

40 CFR Part 63, Subpart AAAAA National Emission Standards for Hazardous Air Pollutants for Lime Manufacturing Plants
§63.7131 Semiannual Compliance Report Spreadsheet Template
Company Record No. (Select from dropdown)	Brief Description of the Process Unit (§63.7131(e)(8))	Brief Description of CMS (§63.7131(e)(9))	Date of Last CMS Certification or Audit (§63.7131(e)(10))
RecordId	ProcessUnitDesc	CMSDescription	CMSAuditDate
e.g.: 1	e.g. Line 1	e.g.: TC1792 PM Filter Bank Inlet Temperature	e.g.: 2/2/2017

---

Sheet 5: CMS_Malfunctions

40 CFR Part 63, Subpart AAAAA National Emission Standards for Hazardous Air Pollutants for Lime Manufacturing Plants
§63.7131 Semiannual Compliance Report Spreadsheet Template
Company Record No. (Select from dropdown)	Brief Description of the Process Units (§63.7131(e)(8)) (Select from dropdown)	Brief Description of the CMS (§63.7131(e)(9)) (Select from dropdown)	Starting Date Malfunction (§63.7131(e)(1))	Starting Time Malfunction (§63.7131(e)(1))	Ending Date Malfunction (§63.7131(e)(1))	Ending Time Malfunction (§63.7131(e)(1))
RecordId	ProcessUnitDesc	CMSDescription	MalfunctionStartDate	MalfunctionStartTime	MalfunctionEndDate	MalfunctionEndTime
e.g.: 1	e.g. Line 1	e.g.: TC1792 PM Filter Bank Inlet Temperature	e.g.: 3/2/2017	e.g.: 15:52	e.g.: 3/5/2017	e.g.: 15:52

---

Sheet 6: CMS_Inoperative_OoC

40 CFR Part 63, Subpart AAAAA National Emission Standards for Hazardous Air Pollutants for Lime Manufacturing Plants
§63.7131 Semiannual Compliance Report Spreadsheet Template
Company Record No. (Select from dropdown)	Brief Description of the Process Units (§63.7131(e)(8)) (Select from dropdown)	Brief Description of the CMS (§63.7131(e)(9)) (Select from dropdown)	CMS Inoperative or Out of Control (Select from dropdown)	Starting Date CMS Inoperative or Out of Control (§63.7131(e)(2) or (3))	Starting Time CMS Inoperative or Out of Control (§63.7131(e)(2) or (3))	Ending Date CMS Inoperative or Out of Control (§63.7131(e)(2) or (3))	Ending Time CMS Inoperative or Out of Control (§63.7131(e)(2) or (3))	Duration CMS Inoperative or Out of Control (hours) (§63.7131(e)(2) or (3)) (Calculated value for use in Summary)	Corrective Action if Out of Control (§63.8(c)(8))
RecordId	ProcessUnitDesc	CMSDescription	CMSOutageDescription	CMSOutageStartDate	CMSOutageStartTime	CMSOutageEndDate	CMSOutageEndTime	CMSOutageDuration	CorrectiveAction
e.g.: 1	e.g. Line 1	e.g.: TC1792 PM Filter Bank Inlet Temperature	e.g. Inoperative	e.g.: 3/2/2017	e.g.: 15:52	e.g.: 3/5/2017	e.g.: 15:52	e.g.: 72.00	e.g.: Reduced Power Supply

---

Sheet 7: CMS_Downtime_Summary

40 CFR Part 63, Subpart AAAAA National Emission Standards for Hazardous Air Pollutants for Lime Manufacturing Plants
§63.7131 Semiannual Compliance Report Spreadsheet Template
Company Record No. (Autocompleted)	Brief Description of the Process Units (§63.7131(e)(8)) (Autocompleted)	Brief Description of the CMS (§63.7131(e)(9)) (Autocompleted)	Total Source Operating Time (hours) (Optional, only necessary for using auto calculation of Total Duration as % of Operating Time)	Total Duration of CMS Downtime (hours) (§63.7131(e)(7)) (Calculated value)	Total Duration of CMS Downtime as a percent of Total Emission Unit Operating Time (§63.7131(e)(7)) (Calculated value or Manual Entry)
RecordId	ProcessUnitDesc	CMSDescription	TotalOperatingTime	CMSDowntimeDuration	CMSDowntimePercent
e.g.: 1	e.g.: Line 1	e.g.: TC1792 PM Filter Bank Inlet Temperature	e.g.: 6240	e.g.: 72.00	e.g.: N/A

---

Sheet 8: Limit_Deviation_w_CMS_Detail

40 CFR Part 63, Subpart AAAAA National Emission Standards for Hazardous Air Pollutants for Lime Manufacturing Plants

§63.7131 Semiannual Compliance Report Spreadsheet Template

Company Record No. (Select from dropdown)

Brief Description of the Process Units (§63.7131(e)(8)) (Select from dropdown)

Emission Limitation (Emission Limit, Operating Limit, Opacity Limit, and VE Limit) Deviated From (§63.7131(e)) (Select from Dropdown)

Type of Operating Period (§63.7131(e)(4)) (Select from dropdown)

Starting Date of Deviation (§63.7131(e)(4))

Starting Time of Deviation (§63.7131(e)(4))

Ending Date of Deviation (§63.7131(e)(4))

Ending Time of Deviation (§63.7131(e)(4))

Duration of Deviation (hours, minutes for opacity) (§63.7131(e)(5) and (6)) (Calculated value)

Cause of Deviation (§63.7131(e)(6)) (Select from dropdown)

Method Used to Estimate Emissions (§63.7131(e)(12))

Regulated Pollutant Emitted in Excess of Standard 1 (§63.7131(e)(12)) (Select from dropdown)

Estimate of Emissions Regulated Pollutant 1 (§63.7131(e)(12))

Units of Emissions Estimate Regulated Pollutant 1 (§63.7131(e)(12))

Regulated Pollutant Emitted in Excess of Standard 2 (§63.7131(e)(12)) (If necessary) (Select from dropdown)

Estimate of Emissions Regulated Pollutant 2 (§63.7131(e)(12)) (If necessary)

Units of Emissions Estimate Regulated Pollutant 2 (§63.7131(e)(12)) (If necessary)

Regulated Pollutant Emitted in Excess of Standard 3 (§63.7131(e)(12)) (If necessary) (Select from dropdown)

Estimate of Emissions Regulated Pollutant 3 (§63.7131(e)(12)) (If necessary)

Units of Emissions Estimate Regulated Pollutant 3 (§63.7131(e)(12)) (If necessary)

Regulated Pollutant Emitted in Excess of Standard 4 (§63.7131(e)(12)) (If necessary) (Select from dropdown)

Estimate of Emissions Regulated Pollutant 4 (§63.7131(e)(12)) (If necessary)

Units of Emissions Estimate Regulated Pollutant 4 (§63.7131(e)(12)) (If necessary)

Regulated Pollutant Emitted in Excess of Standard 5 (§63.7131(e)(12)) (If necessary) (Select from dropdown)

Estimate of Emissions Regulated Pollutant 5 (§63.7131(e)(12)) (If necessary)

Units of Emissions Estimate Regulated Pollutant 5 (§63.7131(e)(12)) (If necessary)

RecordId

ProcessUnitDesc

EmissionDeviation

OperatingPeriod

DeviationStartDate

DeviationStartTime

DeviationEndDate

DeviationEndTime

DeviationDuration

DeviationCause

EstimationMethod

EmissionPollutant1

EmissionsEstimate1

EmissionsUnits1

EmissionPollutant2

EmissionsEstimate2

EmissionsUnits2

EmissionPollutant3

EmissionsEstimate3

EmissionsUnits3

EmissionPollutant4

EmissionsEstimate4

EmissionsUnits4

EmissionPollutant5

EmissionsEstimate5

EmissionsUnits5

e.g.: 1

e.g.: Line 1

e.g.: Particulate Matter

e.g.: Other Period

e.g.: 2/12/2017

e.g.: 13:05

e.g.: 2/13/2017

e.g.: 5:10

e.g.: 16.08

e.g.: Control Equipment Problems

e.g.: Engineering calculations

e.g.: Particulate Matter

e.g.: 0.1

e.g.: tons

e.g.: Mercury

e.g.: 0.02

e.g.: pounds

e.g.: None

e.g.:

e.g.:

e.g.: None

e.g.:

e.g.:

e.g.: None

e.g.:

e.g.:

---

Sheet 9: Limit_Deviation_w_CMS_Summary

40 CFR Part 63, Subpart AAAAA National Emission Standards for Hazardous Air Pollutants for Lime Manufacturing Plants
§63.7131 Semiannual Compliance Report Spreadsheet Template
Company Record No. (Autocompleted)	Brief Description of the Process Units (§63.7131(e)(8)) (Autocompleted)	Emission Limitation (emission limit, operating limit, opacity limit, and VE limit) Deviated From (§63.7131(e)) (Autocompleted)	Total Source Operating Time (hours) (Optional for auto calculation of Durations as % of Total Operating Time)	Total Duration of Deviations from Emission Limitation (emission limit, operating limit, opacity limit, and VE limit) (hours, minutes for opacity) (§63.7131(e)(5)) (Calculated value)	Total Duration of Deviations from Emission Limitation (emission limit, operating limit, opacity limit, and VE limit) as a per cent of Total Source Operating Time (§63.7131(e)(5)) (Calculated value or Manual Entry)	Total Duration of Deviations from Emission Limitation (emission limit, operating limit, opacity limit, and VE limit) Due to Startup (hours, minutes for opacity) (§63.7131(e)(6)) (Calculated value)	Total Duration of Deviations from Emission Limitation (emission limit, operating limit, opacity limit, and VE limit) Due to Shutdown (hours, minutes for opacity) (§63.7131(e)(6)) (Calculated value)	Total Duration of Deviations from Emission Limitation (emission limit, operating limit, opacity limit, and VE limit) Due to Control Equipment Problems (hours, minutes for opacity) (§63.7131(e)(6)) (Calculated value)	Total Duration of Deviations from Emission Limitation (emission limit, operating limit, opacity limit, and VE limit) Due to Process Problems (hours, minutes for opacity) (§63.7131(e)(6)) (Calculated value)	Total Duration of Deviations from Emission Limitation (emission limit, operating limit, opacity limit, and VE limit) Due to Other Known Causes (hours, minutes for opacity) (§63.7131(e)(6)) (Calculated value)	Total Duration of Deviations from Emission Limitation (emission limit, operating limit, opacity limit, and VE limit) Due to Other Unknown Causes (hours, minutes for opacity) (§63.7131(e)(6)) (Calculated value)
RecordId	ProcessUnitDesc	EmissionDeviation	TotalOperatingTime	TotalDeviationDuration	TotalDeviationPercent	StartupCausedDeviation	ShutdownCausedDeviation	EquipmentCausedDeviation	ProcessCausedDeviation	OtherCausedDeviation	UnknownCausedDeviation
e.g.: 1	e.g.: Line 1	e.g.: Particulate Matter	e.g.: 6240	e.g.: 16.08	e.g.: 0.27%	e.g.: 0.00	e.g.: 0.00	e.g.: 16.08	e.g.: 0	e.g.: 0.00	e.g.: 0.00

---

Sheet 10: Description_of_Changes

40 CFR Part 63, Subpart AAAAA National Emission Standards for Hazardous Air Pollutants for Lime Manufacturing Plants
§63.7131(b) Semiannual Compliance Report Spreadsheet Template
CPMS, CEMS, COMS, Processes, or Control Changes
Company Record No. (Select from dropdown)	Description of any changes to continuous monitoring systems, processes, or controls which have occurred since the last reporting period (§63.7131(e)(11))
RecordId	CMSChangesDesc

---

Sheet 11: No_Deviations_no_out_control

40 CFR Part 63, Subpart AAAAA National Emission Standards for Hazardous Air Pollutants for Lime Manufacturing Plants
§63.7131 Semiannual Compliance Report Spreadsheet Template
Company Record No. (Autocompleted)	Selecting Yes certifies that there were no deviations from any emission limitations (emission limit, operating limit, opacity limit, and VE limit) during the reporting period (§63.7131(c)(5)) (Select from Dropdown)	Selecting Yes certifies that there were no periods during which continuous monitoring system were out of control as specified in §63.8(c)(7) during the reporting period (§63.7131(c)(6)) (Select from Dropdown)
RecordId	ApplicableStatement1	ApplicableStatement2

---

Sheet 12: Revisions

	40 CFR Part 63, Subpart AAAAA National Emission Standards for Hazardous Air Pollutants for Lime Manufacturing Plants
	§63.7131 Semiannual Compliance Report Spreadsheet Template
Revision Number	Date	Version	Revisions
1.00	7/17/2019	1.00	Draft version released in Docket
2.00	6/5/2020	2.00	Initial Release Version
	9/22/2022	ICR Draft	Added PRA information, removed * from headers and misleading "required field" , updated cell orientation, added "e.g.:" to all blank example rows to ease filtering, Updated headers on No_Deviations_no_out_control to be clearer what the answer selection means, on Welcome tab updated the alternate CBI mailing address and added sentence clarifying that the certifying statement is completed in CEDRI, Added header to Revisions tab, Updated list of Limits to match proposed rule, Limit_Deviation_Details_No_CMS added additional example for when multiple emission limits are exceed by a single deviation, Limit_Deviations_CMS_Detail - added additional columns to allow for reporting multiple exceded emision limits for a single deviation