
FROM:	Jeff Coburn, RTI International
TO:		Karen Marsh, EPA
FOR:		EPA Docket No. EPA-HQ-OAR-2021-0317
DATE:	November 1, 2021
SUBJECT:	Summary of Spreadsheets used for Tank Battery Impact Estimates
	A number of spreadsheets were used to develop cost and emission impacts for potential regulatory options considered for storage vessels // tank batteries. Table 1 provides a listing and brief description of the files used for these analyses.
            Table 1. Files Used for Tank Battery Impact Estimates.
                                   File Name
                                  Description
EPA_Flares_Calc_Sheet_MP1
Cost estimation sheet for small flare(s)
EPA_Flares_Calc_Sheet_MP1plusmonitors
Cost estimation sheet for small flare with flow monitor and calorimeter
EPA_Flares_Calc_Sheet_MP2
Cost estimation sheet for medium flare
EPA_Flares_Calc_Sheet_MP-G
Cost estimation sheet for large flare
EPA_Flares_Calc_Sheet_MP-H
Cost estimation sheet for largest flare
EPA_IncineratorsOxidizers_Calc_Sheet_MP2
Cost estimation sheet for small to medium non-recuperative thermal oxidizer
StTanks_Model_VRU_sizing_flows1.1
Calculation of design flow rates and hydrocarbon loadings for model tank batteries 
EPA_Carbon_Adsorber_Calc_Sheet_mod-VRU_MP0
Cost estimation sheet for smallest vapor recovery unit (VRU)  -  model plant MP0
EPA_Carbon_Adsorber_Calc_Sheet_mod-VRU_MP1
Cost estimation sheet for VRU for model plant MP1
EPA_Carbon_Adsorber_Calc_Sheet_mod-VRU_MP2
Cost estimation sheet for VRU for model plant MP2
EPA_Carbon_Adsorber_Calc_Sheet_mod-VRU_MP3
Cost estimation sheet for VRU for model plant MP3
EPA_Carbon_Adsorber_Calc_Sheet_mod-VRU_MP4
Cost estimation sheet for VRU for model plant MP4
EPA_Carbon_Adsorber_Calc_Sheet_mod-VRU_MP5
Cost estimation sheet for VRU for model plant MP5
EPA_Carbon_Adsorber_Calc_Sheet_mod-VRU_MP6
Cost estimation sheet for VRU for model plant MP6
EPA_Carbon_Adsorber_Calc_Sheet_mod-VRU_MP7
Cost estimation sheet for VRU for model plant MP7
EPA_Carbon_Adsorber_Calc_Sheet_mod-VRU_MP8
Cost estimation sheet for VRU for model plant MP8
EPA_Carbon_Adsorber_Calc_Sheet_mod-VRU_MP9
Cost estimation sheet for VRU for model plant MP9
EPA_Carbon_Adsorber_Calc_Sheet_mod-VRU_MP10
Cost estimation sheet for VRU for model plant MP10
EPA_Carbon_Adsorber_Calc_Sheet_mod-VRU_MP11
Cost estimation sheet for VRU for model plant MP11
StTanks_Control_Costs_v5.1
This file compiles the cost estimates from the individual control system spreadsheets and develops emission reduction estimates by model control system.
Model_Tank_Battery_with_Emiss_ Distribution_08-11-21
This file summarizes national numbers of tank batteries of a given throughput, the historic E&P model results, the emission distribution developed from the E&P data used to distribute tank batteries to model control systems, and calculations used to assess national impacts of various regulatory options based on the tank battery emissions distribution. 





