Form 5900-579 Semiannual Reporting Template_Gasoline Distribution

---

Overview

Welcome
Facility_Information
General_Information
CMS_Deviation_Outage
Flares
Vapor_Tightness
Vapor_Collection
Monitored_Leaks
AVO_Leaks
Delay_of_Repair
LEL
Revisions

---

Sheet 1: Welcome

DO NOT REMOVE OR EDIT INFORMATION IN ROWS 1 THROUGH 5 FOR INTERNAL USE ONLY
Template Name	Gasoline Distribution Semiannual Reports (Spreadsheet Template)
CitationID	60.505a(c)
Template Version	draft
Last Updated Date	9/28/2023
	OMB Control Numbers: 2060-xxxx (40 CFR Part 60, Subpart XXa); 2060-0325 (40 CFR Part 63, Subpart R); 2060-0620 (40 CFR Part 63, Subpart 6B) Form 5900-579 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 60, Subpart XXa Standards of Performance for Bulk Gasoline Terminals 40 CFR Part 63, Subpart R National Emission Standards for Gasoline Distribution Facilities (Bulk Gasoline Terminals and Pipeline Breakout Stations) 40 CFR Part 63, Subpart BBBBBB National Emission Standards for Hazardous Air Pollutants for Source Category: Gasoline Distribution Bulk Terminals, Bulk Plants, and Pipeline Facilities
	§60.505a(c), §63.428(m), and §63.11095(d) Semiannual Report Spreadsheet Template
	Instructions for Spreadsheet Template
	Purpose:
	This spreadsheet template was designed by the U.S. EPA to facilitate compliance reporting for facilities subject under 40 CFR part 60, subpart XXa - Standards of Performance for Bulk Gasoline Terminals (NSPS XXa), 40 CFR Part 63, Subpart R National Emission Standards for Gasoline Distribution Facilities (Bulk Gasoline Terminals and Pipeline Breakout Stations), and 40 CFR Part 63 (NESHAP R), and Subpart BBBBBB National Emission Standards for Hazardous Air Pollutants for Source Category: Gasoline Distribution Bulk Terminals, Bulk Plants, and Pipeline Facilities (NESHAP 6B).
	Electronic reporting:
	Electronic submission of Semiannual Reports through the EPA's Compliance and Emissions Data Reporting Interface (CEDRI) is required under §60.505a(c), §63.428(m), and §63.11095(d). CEDRI is accessed through the EPA's Central Data Exchange (https://cdx.epa.gov).
	Do not submit 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. All CBI claims must be asserted at the time of submission. 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 EPA is required 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 for some of the information in this report, you must submit a version of the report with the CBI omitted via CEDRI and submit a complete report, including any information claimed to be CBI, to EPA. The preferred method to receive CBI is for it to be transmitted electronically using email attachments, File Transfer Protocol, or other online file sharing services. Electronic submissions must be transmitted directly to the OAQPS CBI Office at the email address oaqpscbi@epa.gov to the attention of the Bulk Gasoline Terminal Sector Lead. If assistance is needed with submitting large electronic files that exceed the file size limit for email attachments, and if you do not have your own file sharing service, please email oaqpscbi@epa.gov to request a file transfer link. If you cannot transmit the file electronically, you may send CBI information through the postal service to the following address:
	OAQPS Document Control Officer (C404-02) OAQPS, U.S. Environmental Protection Agency Attn: Bulk Gasoline Terminal Sector Lead. Research Triangle Park, North Carolina 27711
	The mailed CBI material should be double wrapped and clearly marked. Any CBI markings should not show through the outer envelope. Clearly mark the part or all of the information that you claim to be CBI. Information not marked as CBI may be authorized for public release without prior notice. Information marked as CBI will not be disclosed except in accordance with procedures set forth in 40 CFR part 2.
	The CEDRI spreadsheet template upload feature allows you to submit data in a single report for a single facility or multiple facilities using this EPA provided Excel workbook. Data for each facility must be entered into the worksheet labeled "Facility_Information" in this Excel workbook. Each row in the "Facility_Information" worksheet includes the data for a single facility. The Facility Record No. will be used to match the information on each tab to the appropriate facility.
	IMPORTANT: The final CEDRI upload file must be 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 "Facility_Information" worksheet).
	For each facility record found in the "Facility_Information" worksheet, you may reference a single file attachment that includes additional information. 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. For example, the file “Jan-June2019-Report.zip” uploaded into CEDRI may contain 2 files: 1. Completed_semiannual_reporting_spreadsheet_Jan-June2019.xlsx 2. Attachments.zip The “Attachments.zip” file could contain as many attachments of any format (xlsx, xls, docx, pdf, zip, etc.) as needed. If you only have one file to attach, you do not need to zip it unless it is an Excel file (.xlsx, .xls).
	Template Navigation and Tabs to Complete: Within the tabs, example rows are colored light orange (rows 14 through 23), and the XML tag row (row 13) is colored green. These rows are locked; no data entry is made in these rows.

---

Sheet 2: Facility_Information

40 CFR Part 60, Subpart XXa, 40 CFR Part 63, Subpart R, 40 CFR Part 63, Subpart BBBBBB - Gasoline Distribution

§60.505a(c), §63.428(m), and §63.11095(d) Semiannual Report Spreadsheet Template

This tab includes information on the site(s) for which you are reporting and the reporting period.

SITE INFORMATION

Physical Location

FACILITY CONTACT

REPORTING PERIOD

ADDITIONAL INFORMATION

Facility Record No. (Field value will automatically generate if a value is not entered.)

Facility Name (§60.505a(c)(1)(i), §63.428(m)(1)(i), §63.11095(d)(1)(i))

Regulation(s) Covered by This Report (§60.505a(c), §63.428(m), §63.11095(d))

Address (§60.505a(c)(1)(ii), §63.428(m)(1)(ii), §63.11095(d)(1)(ii))

Address 2

City (§60.505a(c)(1)(ii), §63.428(m)(1)(ii), §63.11095(d)(1)(ii))

County (§60.505a(c)(1)(ii), §63.428(m)(1)(ii), §63.11095(d)(1)(ii))

State Abbreviation (§60.505a(c)(1)(ii), §63.428(m)(1)(ii), §63.11095(d)(1)(ii)) (Select from dropdown)

Zip Code (§60.505a(c)(1)(ii), §63.428(m)(1)(ii), §63.11095(d)(1)(ii))

Responsible Agency Facility ID (State Facility Identifier)

Latitude (decimal degrees to at least five decimal places) (§60.505a(c)(1)(iii), §63.428(m)(1)(iii), §63.11095(d)(1)(iii))

Longitude (decimal degrees to at least five decimal places) (§60.505a(c)(1)(iii), §63.428(m)(1)(iii), §63.11095(d)(1)(iii))

Name (§60.505a(c)(1)(iv)(A), §63.428(m)(1)(iv)(A), §63.11095(d)(1)(iv)(A))

Mailing Address (§60.505a(c)(1)(iv)(B), §63.428(m)(1)(iv)(B), §63.11095(d)(1)(iv)(B))

City (§60.505a(c)(1)(iv)(B), §63.428(m)(1)(iv)(B), §63.11095(d)(1)(iv)(B))

State Abbreviation (§60.505a(c)(1)(iv)(B), §63.428(m)(1)(iv)(B), §63.11095(d)(1)(iv)(B)) (Select from dropdown)

Zip Code (§60.505a(c)(1)(iv)(B), §63.428(m)(1)(iv)(B), §63.11095(d)(1)(iv)(B))

Telephone Number (§60.505a(c)(1)(iv)(C), §63.428(m)(1)(iv)(C), §63.11095(d)(1)(iv)(C))

E-mail Address (§60.505a(c)(1)(iv)(D), §63.428(m)(1)(iv)(D), §63.11095(d)(1)(iv)(D))

Beginning Date of Reporting Period (§60.505a(c)(1)(v), §63.428(m)(1)(vi), §63.11095(d)(1)(vi))

Ending Date of Reporting Period (§60.505a(c)(1)(v), §63.428(m)(1)(vi), §63.11095(d)(1)(vi))

Please enter any additional information.

Enter associated file name reference.

RecordId

FacilityName

Regulation

AddressLine1

AddressLine2

CityName

CountyName

StateName

ZipCode

StateFacId

SiteLatitude

SiteLongitude

ContactName

ContactAddress

ContactCity

ContactState

ContactZip

ContactNumber

ContactEmail

PeriodStartDate

PeriodEndDate

AddInfo

AddFile

e.g.: 1

e.g.: ABC Facility

e.g.: NESHAP R only

e.g.: 123 Main Street

e.g.: Suite 100

e.g.: Brooklyn

e.g.: Kings

e.g.: NY

e.g.: 11221

e.g.: AI 555

e.g.: 34.12345

e.g.: -101.12345

e.g.: John Doe

e.g.: P.O. Box 123

e.g.: Brooklyn

e.g.: NY

e.g.: 11221

e.g.: (555) 555-5555

e.g.: johndoe@company.xyz

e.g.: 01/01/23

e.g.: 06/30/23

e.g.:

e.g.: addinfo.zip

---

Sheet 3: General_Information

40 CFR Part 60, Subpart XXa, 40 CFR Part 63, Subpart R, 40 CFR Part 63, Subpart BBBBBB - Gasoline Distribution
§60.505a(c), §63.428(m), and §63.11095(d) Semiannual Report Spreadsheet Template
This worksheet contains general information and general declarations about each site.
Note: Facility Record No. appears automatically once a Facility(s) is added to the Facility_Information worksheet.
Facility Record No. (Autofilled)	Type of Facility (§63.428(m)(1)(v), §63.11095(d)(1)(v))	Leaks on Delay of Repair at Start of Reporting Period (§60.505a(c)(6)(iii), §63.428(m)(6)(iii), §63.11095(d)(7)(iii))	Leaks on Delay of Repair at End of Reporting Period (§60.505a(c)(6)(iv), §63.428(m)(6)(iv), §63.11095(d)(7)(iv))	Were there deviations from the emission limitations, operating parameters, or work practice standards? (§60.505a(c)(7), §63.428(m)(8), §63.11095(d)(9))	Were there periods during which a continuous monitoring system (including a CEMS or CPMS) was inoperable or out-of-control? (§60.505a(c)(7), §63.428(m)(8), §63.11095(d)(9))	List the name of the attachment with the information specified in §60.115b or §63.1066(b) for each gasoline storage vessel subject to requirements in §63.423 or item 2 of Table 1 of 40 CFR part 63 subpart BBBBBB. (§63.428(m)(7)(i), §63.11095(d)(8)(i))
RecordId	FacType	DelayNoPeriodStart	DelayNoPeriodEnd	PeriodDeviationFlag	CMSOutOfControlFlag	TankAttach
e.g.: 1	e.g.: pipeline breakout station	e.g.: 2	e.g.: 0	e.g.: There were no deviations from the emission limitations or loading pressure requirements during the reporting period.	e.g.: Yes	e.g.: N/A
e.g.: 2	e.g.: bulk gasoline terminal < 250,000 gallons/day, gasoline throughput (total of all racks)	e.g.: 1	e.g.: 1	e.g.: Yes	e.g.: There were no periods during which a continuous monitoring system was inoperable or out-of-control during the reporting period.	e.g.: storagevessel.pdf

---

Sheet 4: CMS_Deviation_Outage

40 CFR Part 60, Subpart XXa, 40 CFR Part 63, Subpart R, 40 CFR Part 63, Subpart BBBBBB - Gasoline Distribution

§60.505a(c), §63.428(m), and §63.11095(d) Semiannual Report Spreadsheet Template

Note: Facility Record No. selections appear once a Facility(s) is added to Facility_Information worksheet. This tab is used to report periods when a CEMS or CPMS is out-of-control or nonoperational or when a deviation from an operating limit or concentration limit has occurred.

Deviation From Limits Only

When the limited alternative for vapor recovery systems in §60.504a(e) is used

Facility Record No. (Select from dropdown)

Unique CMS Identifier (§60.505a(c)(2)(i)(D), §60.505a(c)(ii)(C), §63.428(m)(2)(i)(D), §63.428(m)(2)(ii)(C), §63.11095(d)(2)(i)(D), §63.11095(d)(2)(ii)(C))

CMS Make (§60.505a(c)(2)(i)(E), §60.505a(c)(ii)(D), §63.428(m)(2)(i)(E), §63.428(m)(2)(ii)(D), §63.11095(d)(2)(i)(E), §63.11095(d)(2)(ii)(D))

CMS Model Number (§60.505a(c)(2)(i)(E), §60.505a(c)(ii)(D), §63.428(m)(2)(i)(E), §63.428(m)(2)(ii)(D), §63.11095(d)(2)(i)(E), §63.11095(d)(2)(ii)(D))

Date of Last CMS Calibration Check (§60.505a(c)(2)(i)(E), §60.505a(c)(ii)(D), §63.428(m)(2)(i)(E), §63.428(m)(2)(ii)(D), §63.11095(d)(2)(i)(E), §63.11095(d)(2)(ii)(D))

Deviation From Limit, Out of Control, or Not Operating? (§60.505a(c)(2), §63.428(m)(2), §63.11095(d)(2))

Date of Deviation (§60.505a(c)(2)(i)(A), §60.505a(c)(2)(ii)(A), §63.428(m)(2)(i)(A), §63.428(m)(2)(ii)(A), §63.11095(d)(2)(i)(A), §63.11095(d)(2)(ii)(A))

Start Time of Deviation (§60.505a(c)(2)(i)(A), §60.505a(c)(2)(ii)(A), §63.428(m)(2)(i)(A), §63.428(m)(2)(ii)(A), §63.11095(d)(2)(i)(A), §63.11095(d)(2)(ii)(A))

Duration of Deviation (hours) (§60.505a(c)(2)(i)(B), §60.505a(c)(2)(ii)(B), §63.428(m)(2)(i)(B), §63.428(m)(2)(ii)(B), §63.11095(d)(2)(i)(B), §63.11095(d)(2)(ii)(B))

Cause of Deviation (§60.505a(c)(2)(i)(F), §60.505a(c)(2)(ii)(E), §63.428(m)(2)(i)(F), §63.428(m)(2)(ii)(E), §63.11095(d)(2)(i)(F), §63.11095(d)(2)(ii)(E))

Corrective Action Taken (§60.505a(c)(2)(i)(F), §60.505a(c)(2)(ii)(E), §63.428(m)(2)(i)(F), §63.428(m)(2)(ii)(E), §63.11095(d)(2)(i)(F), §63.11095(d)(2)(ii)(E))

3-Hour Rolling Average Combustion Zone Temperature, 3-Hour Rolling Average TOC Concentration, Average Pressure (§60.505a(c)(2)(i)(C), §63.428(m)(2)(i)(C), §63.11095(d)(2)(i)(C))

Unit of Measure for Column M (§60.505a(c)(2)(i)(C), §63.428(m)(2)(i)(C), §63.11095(d)(2)(i)(C))

Were there deviations from the operating limits when using the limited alternative? (§60.505a(c)(2)(ii)(F), §63.428(m)(2)(ii)(F), §63.11095(d)(2)(ii)(F))

Number of adsorption cycles when the quantity of liquid product loaded in gasoline cargo tanks exceeded the operating limit established in §60.504a(e)(1) (§60.505a(c)(2)(ii)(F)(1), §63.428(m)(2)(ii)(F)(1), §63.11095(d)(2)(ii)(F)(1))

Number of desorption cycles when the vacuum pressure was below the average vacuum pressure as specified in §60.504a(e)(2)(i) (§60.505a(c)(2)(ii)(F)(2), §63.428(m)(2)(ii)(F)(2), §63.11095(d)(2)(ii)(F)(2))

Number of desorption cycles when the quantity of purge gas used was below the average quantity of purge gas as specified in §60.504a(e)(2)(ii) (§60.505a(c)(2)(ii)(F)(3), §63.428(m)(2)(ii)(F)(3), §63.11095(d)(2)(ii)(F)(3))

Number of desorption cycles when the duration of the vacuum/purge cycle was less than the average duration as specified in §60.504a(e)(2)(iii) (§60.505a(c)(2)(ii)(F)(4), §63.428(m)(2)(ii)(F)(4), §63.11095(d)(2)(ii)(F)(4))

RecordId

CMSDescription

EquipmentMfr

EquipmentModelNo

CMSAuditDate

CMSDeviationType

ParameterExcessStartDate

ParameterExcessStartTime

ParameterExcessDuration

ExceedanceCause

CorrectiveAction

CMSValue

CMSUnits

CMSAltDevFlag

CMSAltDev1

CMSAltDev2

CMSAltDev3

CMSAltDev4

e.g.: 1

e.g.: Unit 1 Temp A

e.g.: Company X

e.g.: AB-20

e.g.: 01/01/22

e.g.: Deviation from Limit

e.g.: 02/02/22

e.g.: 1:30 PM

e.g. 2

e.g.:

e.g.:

e.g.: 1060

e.g.: ° C

e.g.: yes

e.g.: 1

e.g.: 0

e.g.: 0

e.g.: 0

---

Sheet 5: Flares

40 CFR Part 60, Subpart XXa, 40 CFR Part 63, Subpart R, 40 CFR Part 63, Subpart BBBBBB - Gasoline Distribution

§60.505a(c), §63.428(m), and §63.11095(d) Semiannual Report Spreadsheet Template

Note: Facility Record No. selections appear once a Facility(s) is added to Facility_Information worksheet. Columns I-Y will be blacked out depending on the answers provided in Column D.

Visible Emissions Exceeded

Operating Limits Not Met

Information on CMS Involved (if applicable)

Facility Record No. (Select from dropdown)

Flare or Thermal Oxidizer ID (§60.505a(c)(3), §63.428(m)(3), §63.11095(d)(3))

Type of Event (§60.505a(c)(3), §63.428(m)(3), §63.11095(d)(3)) (Select from dropdown)

Start Date (§60.505a(c)(3), §63.428(m)(3), §63.11095(d)(3))

Start Time (§60.505a(c)(3), §63.428(m)(3), §63.11095(d)(3))

End time (§60.505a(c)(3)(i), §63.428(m)(3)(i), §63.11095(d)(3)(i))

Duration (minutes) (§60.505a(c)(3)(ii), §63.428(m)(3)(ii), §63.11095(d)(3)(ii))

Number or Estimate of Number of Minutes for Which Emissions Were Visible (§60.505a(c)(3)(i)(B), §63.428(m)(3)(i)(B), §63.11095(d)(3)(i)(B))

Which operating limit was not met? (§60.505a(c)(3)(i)(C), §63.428(m)(3)(i)(C), §63.11095(d)(3)(i)(C)) (Select from dropdown)

Value of Net Heating Value Operating Parameter (§60.505a(c)(3)(i)(C)(3), §63.428(m)(3)(i)(C)(3), §63.11095(d)(3)(i)(C)(3))

Units of Measure for Operating Parameter (§60.505a(c)(3)(i)(C)(3), §63.428(m)(3)(i)(C)(3), §63.11095(d)(3)(i)(C)(3)) (Autofilled)

Required Minimum Supplemental Gas Flow Rate (§60.505a(c)(3)(i)(C)(2), §63.428(m)(3)(i)(C)(2), §63.11095(d)(3)(i)(C)(2))

Actual Supplemental Gas Flow Rate (§60.505a(c)(3)(i)(C)(2), §63.428(m)(3)(i)(C)(2), §63.11095(d)(3)(i)(C)(2))

Units of Measure for Gas Flow Rate (§60.505a(c)(3)(i)(C)(2), §63.428(m)(3)(i)(C)(2), §63.11095(d)(3)(i)(C)(2))

Required Minimum Ratio of Gasoline Loaded to Total Product Loaded (§60.505a(c)(3)(i)(C)(1), §63.428(m)(3)(i)(C)(1), §63.11095(d)(3)(i)(C)(1))

Actual Ratio of Gasoline Loaded to Total Product Loaded (§60.505a(c)(3)(i)(C)(1), §63.428(m)(3)(i)(C)(1), §63.11095(d)(3)(i)(C)(1))

Required Minimum Quantity of Gasoline Loaded (gallons) (§60.505a(c)(3)(i)(C)(1), §63.428(m)(3)(i)(C)(1), §63.11095(d)(3)(i)(C)(1))

Actual Quantity of Gasoline Loaded (gallons) (§60.505a(c)(3)(i)(C)(1), §63.428(m)(3)(i)(C)(1), §63.11095(d)(3)(i)(C)(1))

Unique Identifier for CMS (§60.505a(c)(3)(iii)(A), §63.428(m)(3)(iii)(A), §63.11095(d)(3)(iii)(A))

CMS Make (§60.505a(c)(3)(iii)(B), §63.428(m)(3)(iii)(B), §63.11095(d)(3)(iii)(B))

CMS Model Number (§60.505a(c)(3)(iii)(B), §63.428(m)(3)(iii)(B), §63.11095(d)(3)(iii)(B))

Date of Last CMS Calibration Check (§60.505a(c)(3)(iii)(B), §63.428(m)(3)(iii)(B), §63.11095(d)(3)(iii)(B))

Cause of Deviation or Downtime (§60.505a(c)(3)(iii)(C), §63.428(m)(3)(iii)(C), §63.11095(d)(3)(iii)(C))

Corrective Action Taken (§60.505a(c)(3)(iii)(C), §63.428(m)(3)(iii)(C), §63.11095(d)(3)(iii)(C))

RecordId

FlareId

FlareEventType

FlareStartDate

FlareStartTime

FlareEndTime

FlareDuration

VETime

FlareOpLimitExceeded

FlareOpLimitValue

FlareOpLimitUnits

FlareReqMinGas

FlareActualGas

FlareGasUnits

FlareReqMinRatio

FlareActualRatio

FlareReqMinLoaded

FlareActualLoaded

FlareCMSId

FlareCMSMake

FlareCMSModel

FlareCMSAuditDate

FlareCMSDevCause

FlareCMSCorrective

e.g.: 1

e.g.: Flare ABC

e.g.: No pilot flame present

e.g.: 06/01/23

e.g.: 9:20 AM

e.g.: 9:35 AM

e.g.:

e.g.: 20

e.g.: NHVcz

e.g.: 450

e.g.: Btu/scf

e.g.:

e.g.:

e.g.: scfh

e.g.:

e.g.:

e.g.:

e.g.:

e.g.: Unit 1 Temp A

e.g.: Company X

e.g.: AB-20

e.g.: 01/01/22

e.g.:

e.g.:

---

Sheet 6: Vapor_Tightness

40 CFR Part 60, Subpart XXa, 40 CFR Part 63, Subpart R, 40 CFR Part 63, Subpart BBBBBB - Gasoline Distribution
§60.505a(c), §63.428(m), and §63.11095(d) Semiannual Report Spreadsheet Template
Use this worksheet to report any instance in which liquid product was loaded into a cargo tank for which vapor tightness documentation required under §60.502a(e)(1) or §63.11094(b) was not provided or available in the terminal’s records.
Note: Facility Record No. selections appear once a Facility(s) is added to the Facility_Information worksheet. Column L will be blocked out if you indicated no documentation was received in Column K.
Facility Record No. (Select from dropdown)	Date Liquid Product Was Loaded Without Proper Documentation. (§60.505a(c)(4)(iii), §63.428(m)(4)(iii), §63.11095(d)(4)(iii))	Time Liquid Product Was Loaded Without Proper Documentation. (§60.505a(c)(4)(iii), §63.428(m)(4)(iii), §63.11095(d)(4)(iii))	Cargo Tank Identification Number (§60.505a(c)(4)(ii), §63.428(m)(4)(ii), §63.11095(d)(4)(ii))	Cargo Tank Owner (§60.505a(c)(4)(i), §63.428(m)(4)(i), §63.11095(d)(4)(i))	Address (§60.505a(c)(4)(i), §63.428(m)(4)(i), §63.11095(d)(4)(i))	City (§60.505a(c)(4)(i), §63.428(m)(4)(i), §63.11095(d)(4)(i))	State (§60.505a(c)(4)(i), §63.428(m)(4)(i), §63.11095(d)(4)(i)) (Select from dropdown)	Zip Code (§60.505a(c)(4)(i), §63.428(m)(4)(i), §63.11095(d)(4)(i))	Was Proper Documentation Received? (§60.505a(c)(4)(iv), §63.428(m)(4)(iv), §63.11095(d)(4)(iv))	Date Proper Documentation Was Received (§60.505a(c)(4)(iv), §63.428(m)(4)(iv), §63.11095(d)(4)(iv))
RecordId	TightLoadDate	TightLoadTime	TightTankId	TightTankOwner	TightAddress	TightCity	TightState	TightZip	TightDocumentationFlag	TightDocumentationDate
e.g.: 1	e.g.: 05/01/23	e.g.: 1:00 PM	e.g.:	e.g.:	e.g.: 123 Main Street	e.g.: Brooklyn	e.g.: NY	e.g.: 11221	e.g.: Yes	e.g.: 05/02/23

---

Sheet 7: Vapor_Collection

40 CFR Part 60, Subpart XXa, 40 CFR Part 63, Subpart R, 40 CFR Part 63, Subpart BBBBBB - Gasoline Distribution
§60.505a(c), §63.428(m), and §63.11095(d) Semiannual Report Spreadsheet Template
Use this worksheet to report each instance when: (1) liquid product was loaded into cargo tanks not using submerged filling, as defined in §60.501a, §63.421, or §63.11100; (2) liquid prodcut was loaded into cargo tanks that were not equipped with vapor collection equipment that is compatible with the terminal's vapor collection system; and (3) each instance liquid product was loaded into cargo tanks when the terminal's and the cargo tank's vapor collection systems were not properly connected.
Use this worksheet to also report instances for 40 CFR part 63 subpart BBBBBB when gasoline was loaded between gasoline cargo tanks and storage tanks and the plant’s vapor balancing system was not properly connected between the gasoline cargo tank and storage tank.
Note: Facility Record No. selections appear once a Facility(s) is added to the Facility_Information worksheet.
Facility Record No. (Select from dropdown)	Date Liquid Product/Gasoline Loaded Into Improperly Equipped or Improperly Connected Cargo Tank or Gasoline Storage Tank (§60.505a(c)(5)(i), §63.428(m)(5)(i), §63.11095(d)(5)(i), §63.11095(d)(6)(i))	Time Liquid Product/Gasoline Loaded Into Improperly Equipped or Improperly Connected Cargo Tank or Gasoline Storage Tank (§60.505a(c)(5)(i), §63.428(m)(5)(i), §63.11095(d)(5)(i), §63.11095(d)(6)(i))	Type of Deviation (§60.505a(c)(5)(ii), §63.428(m)(5)(ii), §63.11095(d)(5)(ii), §63.11095(d)(6))	Cargo Tank Identification Number (§60.505a(c)(5)(iii), §63.428(m)(5)(iii), §63.11095(d)(5)(iii), §63.11095(d)(6)(ii))	Storage Tank Identification Number (§63.11095(d)(6)(ii))
RecordId	CollectionLoadDate	CollectionLoadTime	CollectionDeviation	CollectionCargoId	CollectionStorageId
e.g.: 1	e.g.: 05/01/23	e.g.: 12:30 PM	e.g.: not submerged filling	e.g.:	e.g.:

---

Sheet 8: Monitored_Leaks

40 CFR Part 60, Subpart XXa, 40 CFR Part 63, Subpart R, 40 CFR Part 63, Subpart BBBBBB - Gasoline Distribution
§60.505a(c), §63.428(m), and §63.11095(d) Semiannual Report Spreadsheet Template
Use this worksheet to report information on leaks detected during a leak inspection required under §60.502a(j)(1), §60.503a(a)(2), §63.424(c), or §63.11089(c).
Note: Facility Record No. selections appear once a Facility(s) is added to the Facility_Information worksheet.
Facility Record No. (Select from dropdown)	Date of Inspection (§60.505a(c)(6)(i)(A), §63.428(m)(6)(i)(A), §63.11095(d)(7)(i)(A))	Leak Determination Method (§60.505a(c)(6)(i)(B), §63.428(m)(6)(i)(B), §63.11095(d)(7)(i)(B)) (Select from dropdown list)	Type of Component for which Leak is Detected (§60.505a(c)(6)(i)(C)-(F), §63.428(m)(6)(i)(C)-(F), §63.11095(d)(7)(i)(C)-(F))	Specify Component Type if Column E is "Other" (§60.505a(c)(6)(i)(C)-(F), §63.428(m)(6)(i)(C)-(F), §63.11095(d)(7)(i)(C)-(F))	Number of Leaks Detected for Component Type (§60.505a(c)(6)(i)(C), §63.428(m)(6)(i)(C), §63.11095(d)(7)(i)(C))	Number of Leaks Repaired in 15 Calendar Days for Component Type (§60.505a(c)(6)(i)(D), §63.428(m)(6)(i)(D), §63.11095(d)(7)(i)(D))	Number of Leaks For Which There Was No Repair Attempt Within 5 Days for Component Type (§60.505a(c)(6)(i)(E), §63.428(m)(6)(i)(E), §63.11095(d)(7)(i)(E))	Number of Components Placed on Delay of Repair for Component Type (§60.505a(c)(6)(i)(F), §63.428(m)(6)(i)(F), §63.11095(d)(7)(i)(F))
RecordId	LeakInspectDate	LeakMethod	LeakComponent	LeakCompOther	LeakNumber	LeakRepaired	LeakFirstAttempt	LeakRepairDelayed
e.g.: 1	e.g.: 04/02/23	e.g.: OGI	e.g.: valve	e.g.:	e.g.: 3	e.g.: 1	e.g.: 1	e.g.: 1

---

Sheet 9: AVO_Leaks

40 CFR Part 60, Subpart XXa, 40 CFR Part 63, Subpart R, 40 CFR Part 63, Subpart BBBBBB - Gasoline Distribution
§60.505a(c), §63.428(m), and §63.11095(d) Semiannual Report Spreadsheet Template
Use this worksheet to report leaks identified by audio, visual, or olfactory methods under §60.502a(j)(2), §63.424(c), or §63.11089(c).
Note: Facility Record No. selections appear once a Facility(s) is added to the Facility_Information worksheet.
Facility Record No. (Select from dropdown)	Type of Component for which Leak is Detected (§60.505a(c)(6)(ii)(A)-(D), §63.428(m)(6)(ii)(A)-(D), §63.11095(d)(7)(ii)(A)-(D))	Specify Component Type if Column C is "Other" (§60.505a(c)(6)(ii)(A)-(D), §63.428(m)(6)(ii)(A)-(D), §63.11095(d)(7)(ii)(A)-(D))	Number of Leaks Detected for Component Type (§60.505a(c)(6)(ii)(A), §63.428(m)(6)(ii)(A), §63.11095(d)(7)(ii)(A))	Number of Leaks Repaired in 15 Calendar Days for Component Type (§60.505a(c)(6)(ii)(B), §63.428(m)(6)(ii)(B), §63.11095(d)(7)(ii)(B))	Number of Leaks For Which There Was No Repair Attempt Within 5 Days for Component Type (§60.505a(c)(6)(ii)(C), §63.428(m)(6)(ii)(C), §63.11095(d)(7)(ii)(C))	Number of Components Placed on Delay of Repair for Component Type (§60.505a(c)(6)(ii)(D), §63.428(m)(6)(ii)(D), §63.11095(d)(7)(ii)(D))
RecordId	AvoComponent	AvoCompOther	AvoNumber	AvoRepaired	AvoFirstAttempt	AvoRepairDelayed
e.g.: 1	e.g.: valve	e.g.:	e.g.: 2	e.g.: 1	e.g.: 1	e.g.: 1

---

Sheet 10: Delay_of_Repair

40 CFR Part 60, Subpart XXa, 40 CFR Part 63, Subpart R, 40 CFR Part 63, Subpart BBBBBB - Gasoline Distribution
§60.505a(c), §63.428(m), and §63.11095(d) Semiannual Report Spreadsheet Template
Use this worksheet to report information for each leak that was on the delay of repair list at any time during the reporting period.
Note: Facility Record No. selections appear once a Facility(s) is added to the Facility_Information worksheet.
Facility Record No. (Select from dropdown)	Unique Equipment Component Identification Number (§60.505a(c)(6)(v)(A), §63.428(m)(6)(v)(A), §63.11095(d)(7)(v)(A))	Type of Equipment Component (§60.505a(c)(6)(v)(B), §63.428(m)(6)(v)(B), §63.11095(d)(7)(v)(B))	Specify Component Type if Column D is "Other" (§60.505a(c)(6)(v)(B), §63.428(m)(6)(v)(B), §63.11095(d)(7)(v)(B))	Leak Determination Method (§60.505a(c)(6)(v)(C), §63.428(m)(6)(v)(C), §63.11095(d)(7)(v)(C)) (Select from dropdown)	Reason Why Repair Was Not Feasible Within 15 days (§60.505a(c)(6)(v)(D), §63.428(m)(6)(v)(D), §63.11095(d)(7)(v)(D))	Specify Reason if Column G is "Other"	Date Repair Completed (If Applicable) (§60.505a(c)(6)(v)(E), §63.428(m)(6)(v)(E), §63.11095(d)(7)(v)(E))
RecordId	DelayCompId	DelayCompType	DelayCompTypeOther	DelayLeakMethod	DelayReason	DelayOtherReason	DelayRepairDate
e.g.: 1	e.g.:HRLVLV2891	e.g.: valve	e.g.:	e.g.: OGI	e.g.: Replacement parts unavailable	e.g.:	e.g.: 05/31/23

---

Sheet 11: LEL

40 CFR Part 60, Subpart XXa, 40 CFR Part 63, Subpart R, 40 CFR Part 63, Subpart BBBBBB - Gasoline Distribution
§60.505a(c), §63.428(m), and §63.11095(d) Semiannual Report Spreadsheet Template
Use this worksheet to report deviations in LEL monitoring if you are complying with §63.423(c)(2) or options 2(c) or 2(e) in Table 1 to 40 CFR part 63 subpart BBBBBB.
Note: Facility Record No. selections appear once a Facility(s) is added to the Facility_Information worksheet.
Facility Record No. (Select from dropdown)	Storage Vessel Being Monitored (§63.428(m)(7)(ii)(A), §63.11095(d)(8)(ii)(A))	Date of Monitoring (§63.428(m)(7)(ii)(A), §63.11095(d)(8)(ii)(A))	Start Time of Monitoring (§63.428(m)(7)(ii)(A), §63.11095(d)(8)(ii)(A))	End Time of Monitoring (§63.428(m)(7)(ii)(A), §63.11095(d)(8)(ii)(A))	Description of the Monitoring Event (§63.428(m)(7)(ii)(B), §63.11095(d)(8)(ii)(B))	Wind Speed at Top of Storage Vessel on Date of Monitoring (miles per hour) (§63.428(m)(7)(ii)(C), §63.11095(d)(8)(ii)(C))	Highest 5-Minute Rolling Average LEL During Monitoring (percent) (§63.428(m)(7)(ii)(D), §63.11095(d)(8)(ii)(D))	Which action was taken? (§63.428(m)(7)(ii)(E), §63.11095(d)(8)(ii)(E))
RecordId	LelTankId	LelDate	LelStartTime	LelEndTime	LelDescription	LelWindSpeed	LelPercent	LelAction
e.g.: 1	e.g.: Tank 123AB	e.g.: 11/21/24	e.g.: 2:30 PM	e.g.: 2:50 PM	e.g.: Re-monitoring due to high winds	e.g.: 3	e.g.: 30.1%	e.g.: Roof repaired

---

Sheet 12: Revisions

Revision Number	Date	Description
1.00		Finalized Release Version