Document ID: EPA-HQ-OAR-2020-0371-0069
Agency: epa
Document Type: Supporting & Related Material
Title: 
Posted Date: 2022-06-10T04:00Z

Zip-file name: gasoline_distribution_RIA_docket.zip
The zipped file directory docketed here contains the data, code, and outputs produced for the following document:  
Regulatory Impact Analysis for the Proposed National Emission Standards for Hazardous Air Pollutants: Gasoline Distribution Technology Review and Standards of Performance for Bulk Gasoline Terminals Review
This includes code that conducts and produces tables associated with the engineering cost analysis in Chapter 3, the partial equilibrium market analysis in Chapter 5, and the small business impacts analysis in Chapter 5. The zip-file can be requested by contacting the EPA Docket Center's Customer Service Center.
The file structure of the directory is as follows. File and folder names are written in Courier New font. Descriptive text is bolded and in written in Times New Roman.
 README.txt
 This file contains a detailed description of how to replicate each component of the analysis of the RIA, with separate section dedicated to replicating the engineering cost analysis in Chapter 3, the partial equilibrium market analysis in Chapter 5, and the small business impacts analysis in Chapter 5. Additional documentation is included as comments in R/GAMS code files and in README tabs of Excel workbooks that contain links to data.
 Data\
 raw\
 This folder contains .csv and .xlsx data files by the analysis. Descriptions of files appear as comments in the associated R code when necessary.
 aeo_gasoline_price_projections.csv
 aeo_gasoline_quantity_projections.csv
 bea_price_index.csv
 eia_weekly_gasoline_consumption.csv
 options_cost_workbook.xlsx
 options_lookups.xlsx
 parent_company_info_original.xlsx
 parent_company_info_update.xlsx
 tsd-sc-ghg.xlsx
 us_census_enterprise_sizes_2017.xlsx
 int\
 This folder contains intermediate R data files that are produced by and used within R code. They are produced by R code from the .csv and .xlsx files in Data/raw.
 aeo_price_quantity.rdata
 aggregate_cost.rdata
 options_and_worst_case.rdata
 sales_by_employment_group_and_naics_updated.rdata
 source_w_parent_info.rData
 Model\
 The root of this folder contains GAMS code used to conduct the partial equilibrium market analysis presented in Chapter 5 of the RIA. cleanup.bat is a batch file used to remove intermediate GAMS files after running model.gms. model.gams runs the partial equilibrium market analysis and calls the other GAMS code files in the directory. GasDist.gpr is a GAMS project file.
 cleanup.bat
 GasDist.gpr
 model.gms
 model_define.gms
 model_main_data.gms
 model_main_scenario.gms
 write_results_to_csv.gms
 write_to_results_table.gms
 data\
 This folder contains data files used by GAMS in the partial equilibrium market analysis. They are produced and written into the directory by R code, with the exception of model_costs.gdx, which is produced and used by the GAMS code.
 baseline_prices.csv
 baseline_quantities.csv
 costs.csv
 costs.xlsx
 model_costs.csv
 model_costs.gdx
 results\
 This folder contains the results of the partial equilibrium market analysis.  The results files are produced by the GAMS code in the folder one level up and are processed by R code in a separate directory.
 main_scenario_results.csv
 main_scenario_results_old.xlsx
 Output\
 This folder contains the tables and the data used to create the tables in the RIA. The .csv files are linked to in Excel workbooks. When necessary, Excel workbooks contain README tabs that describe their contents.
 Benefits\
 gas_distribution benefits.xlsx
 Emissions Reductions\
 annual_emissions.csv
 area_source.csv
 Gas_Distribution_Options_and Emissions_Reductions.xlsx
 major_source.csv
 Engineering Costs\
 Cost Tables.xlsx contains the main engineering cost tables in the RIA. The csv files in this directory are output by R code and linked to by Cost Tables.xlsx.
 Aggregates_by_Facility_Less.csv
 Aggregates_by_Facility_More.csv
 Aggregates_by_Facility_Rec.csv
 Aggregates_by_source_Less.csv
 Aggregates_by_source_More.csv
 Aggregates_by_source_Rec.csv
 annual_emissions.csv
 Cost Tables.xlsx
 discounted_ cap_aoc_less.csv
 discounted_cap_aoc_more.csv
 discounted_cap_aoc_rec.csv
 discounted_less.csv
 discounted_more.csv
 discounted_rec.csv
 options_data.csv
 per_year_less.csv
 per_year_more.csv
 per_year_rec.csv
 pv_eav_cap_aoc_less.csv
 pv_eav_cap_aoc_more.csv
 pv_eav_cap_aoc_rec.csv
 pv_eav_less.csv
 pv_eav_more.csv
 pv_eav_rec.csv
 Industry\
 Industry Profile Tables and Images.xlsx contains the data and images used in Chapter 2 of the RIA. The other files in this folder contain source data for claims made in the RIA.
 Fueltaxes.xls
 Industry Profile Tables and Images.xlsx
 us_6digitnaics_2012.xls
 us_state_naics_detailedsizes_2017.xlsx
 Images\
 This folder contains the source images used in Chapter 2 of the RIA.
 aeo_gasoline_price_forecast.png
 demand_and_seasonality.png
 gas_distribution_network_image_eia.png
 gas_price_breakdown.png
 gasoline_prices_map.png
 marketing_arrangements.png
 paddmap.png
 paddmap-gasoline-prices.png
 Petroleum Pipelines.png
 reformulated_map.png
 Source Data\
 This folder contains the source data used in the tables in Chapter 2 of the RIA. 
 AEO Projections.xlsx
 annual_quantities_by_sales_type.xls
 Gasoline Expenditure BLS.xlsx
 gasoline_consumption_by_padd.xls
 gasoline_price_by_Padd.xls
 gasoline_price_by_type.xls
 gasoline_product_supplied.xls
 gasoline_refiner_price_by_type.xls
 Motor Gasoline Consumption by Use and End User.xlsx
 Motor Gasoline Energy Usage.xlsx
 padd_pipeline.xlsx
 padd_pipeline_tanker_barge.xlsx
 rack_price_by_year.xls
 Table_11._Petroleum_and_Other_Liquids_Supply_and_Disposition.csv
 Working Storage Capacity.xlsx
 Misc\
 This folder contains miscellaneous tables that are used in the RIA and don't fit neatly into other folders in the directory.
 Aggregates.csv
 climate_disbenefits.xlsx
 gas_monthly_proportions.csv
 Regulatory Options Table.xlsx
 SCC-2030-graphic.png
 Tables.xlsx
 Model\
 model_results.xlsx contains the tables related to the partial equilibrium market analysis in Chapter 5 of the RIA. The .csv files are produced by R code and linked to the Excel workbook.
 model_results.xlsx
 price_change_level.csv
 price_change_pct.csv
 quantity_change_level.csv
 quantity_change_pct.csv
 welfare_.03.csv
 welfare_.03_pv_eav.csv
 welfare_.07.csv
 welfare_.07_pv_eav.csv
 welfare_undiscounted.csv
 SB\
 Sb_impacts.xlsx contains the tables related to the small business impacts analysis in Chapter 5 of the RIA. The .csv files are produced by R code and linked to the Excel workbook.
 census_csr.xlsx
 parent_table.csv
 sb_cost_dist.csv
 sb_impacts.xlsx
 sb_impacts_census_less.csv
 sb_impacts_census_more.csv
 sb_impacts_census_rec.csv
 sb_impacts_facilities.csv
 worst_case_rec.csv
 OUTPUT_README.txt
 This file describes the contents of the subdirectories in this folder in detail.
 R\
 The root of this folder contains R scripts that contain code that produces the analysis and tables contained in the RIA, with the exception of the small business impacts analysis (see next bullet point). Comments in the code describe what each file does, and README.txt in the root folder of this directory describes in detail how to use this code to replicate the tables in the RIA.
 engineering_costs.r
 gas_monthly_consumption.r
 get_aeo_data.r
 get_options_data_and_costs.r
 model_results.r
 run_engineering_costs.r
 setup.r
 SB\
 This folder contains R scripts that contain code that produces the small business impacts analysis contained in Chapter 5 of the RIA.
 clean_census.r
 get_parent_data.r
 parent_table.r
 run_small_business_analysis.r
 small_business.r