Record for the Final Metal Product and Machinery Rule 1 2 34 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 A B C D E F G H I VARIABLE DESCRIPTIONS FOR SUMMARY_ FINAL. XLS FINAL MP& M RULE FORMULA Long, Short, and Phase 1 Surveys Iron and Steel Surveys Railroad Surveys Municipality Surveys SID Survey ID Data A N = IF([ MPCT_ Final. xls] O2! A7<>"",[ MPCT_ Final. xls] O2! A7,"") =[ RailMPCT_ Final. xls] FacData!$ B6 Railroad Op Unit Railroad Operating Unit ID Data B Y = VLOOKUP( A723,[ RailMPCT_ Final. xls] C osts!$ A$ 4:$ B$ 28,2,0)

In Used to filter data in summary tables Data C N = IF( A7<>"", 1,0) = IF( A294<>"", 1,0) = IF( A723<>"", 1,0) = IF( A770<>"", 1,0)

Subcat Subcategory Data D Y = VLOOKUP( A7,[ facdata_ Final. xls] FacDa ta!$ A$ 6:$ H$ 1860,8,0) = VLOOKUP( A294,[ facdata_ Final. xls] Fac Data!$ A$ 6:$ H$ 1860,8,0) = VLOOKUP( A723,[ facdata_ Final. xls] Fac Data!$ A$ 6:$ H$ 1860,8,0) = VLOOKUP( A770,[ facdata_ Final. xls] Fac Data!$ A$ 6:$ H$ 1860,8,0)

Weight Sample weight Data E Y = VLOOKUP( A7,[ facdata_ Final. xls] FacDa ta!$ A$ 5:$ H$ 1171,6,0) = VLOOKUP( A294,[ facdata_ Final. xls] Fac Data!$ A$ 5:$ H$ 1171,6,0) = VLOOKUP( A723,[ facdata_ Final. xls] Fac Data!$ A$ 5:$ H$ 1171,6,0) = VLOOKUP( A770,[ facdata_ Final. xls] Fac Data!$ A$ 5:$ H$ 1171,6,0)

Sector Sector code Data F Y = VLOOKUP( A7, facdata_ Final. xls! FacDat a, 3,0) = VLOOKUP( A294, facdata_ Final. xls! Fac Data, 3,0) = VLOOKUP( A723, facdata_ Final. xls! Fac Data, 3,0) = VLOOKUP( A770, facdata_ Final. xls! Fac Data, 3,0)

Ind Dir Discharge type: D= Direct; I= Indirect Data G N = IF( A7<>"", VLOOKUP( A7, facdata_ Final. xls! FacData, 11,0), 0) = IF( A294<>"", VLOOKUP( A294, facdata_ Final. xls! FacData, 11,0), 0) = IF( A723<>"", VLOOKUP( A723, facdata_ Final. xls! FacData, 11,0), 0) = IF( A770<>"", VLOOKUP( A770, facdata_ Final. xls! FacData, 11,0), 0)

State State where the facility is located Data H Y New Flow Flow Range: 0: <= 1 million gallons per year ( mgy); 1: 1 2 mgy; 2: 2 3 mgy; 3: 3 4 mgy; 4: 4 5 mgy; 5: 5 6.25 mgy; 6: over 6.25 mgy Data I Y = IF( C7= 1, VLOOKUP( A7,[ facdata_ Final. x ls] FacData!$ A$ 5:$ H$ 1171,5,0), 0) = IF( C294= 1, VLOOKUP( A294,[ facdata_ Fi nal. xls] FacData!$ A$ 5:$ H$ 1171,5,0), 0) = IF( C723= 1, VLOOKUP( A723,[ facdata_ Fi nal. xls] FacData!$ A$ 5:$ H$ 1171,5,0), 0) = IF( C770= 1, VLOOKUP( A770,[ facdata_ Fi nal. xls] FacData!$ A$ 5:$ H$ 1171,5,0), 0)

Small Bus Is the site owned by a small entity? 0= No; 1= Yes; 2= Unclassified Data J Y = VLOOKUP( A7, facdata_ Final. xls! FacDat a, 4,0) = VLOOKUP( A294, facdata_ Final. xls! Fac Data, 4,0) = VLOOKUP( A723, facdata_ Final. xls! Fac Data, 4,0) = VLOOKUP( A770, facdata_ Final. xls! Fac Data, 4,0)

Permit Type M= Mass Based; C= Concentration Based; N= No Permit; D= Direct Discharger Data K Y = VLOOKUP( A7,'[ perm_ typfinal xls] Permit_ Type'!$ A$ 5:$ Z$ 964,14,0) = VLOOKUP( A294,'[ perm_ typfinal xls] Permit_ Type'!$ A$ 5:$ Z$ 964,14,0) = VLOOKUP( A723,'[ perm_ typfinal xls] Permit_ Type'!$ A$ 5:$ Z$ 964,14,0) = VLOOKUP( A770,'[ perm_ typfinal xls] Permit_ Type'!$ A$ 5:$ Z$ 964,14,0)

Unweighted FTE Number of employees at the site Data L Y = IF( ISNA( VLOOKUP( A7, facdata_ Final. xl s! SBA, 5,0)),"", VLOOKUP( A7, facdata_ Fin al. xls! SBA, 5,0)) = IF( ISNA( VLOOKUP( A294, facdata_ Final . xls! SBA, 5,0)),"", VLOOKUP( A294, facdat a_ Final. xls! SBA, 5,0)) = IF( ISNA( VLOOKUP( A723, facdata_ Final . xls! SBA, 5,0)),"", VLOOKUP( A723, facdat a_ Final. xls! SBA, 5,0)) = IF( ISNA( VLOOKUP( A770, facdata_ Final . xls! SBA, 5,0)),"", VLOOKUP( A770, facdat a_ Final. xls! SBA, 5,0))

Revenue, 1996$ Site revenue, 1996$ Data M Y = IF([ MPCT_ Final. xls] Base! F7<>"",[ MPC T_ Final. xls] Base! F7,"") ='[ I& S_ MPCT_ Final. xls] Base'!$ D7*( PPI9 6/ PPI97) = IF( ISNA( VLOOKUP( LEFT($ A770,5),[ M uniMPCT_ Final. xls] MuniFin!$ A$ 6:$ W$ 60 ,2,0)),"", VLOOKUP( LEFT($ A770,5),[ Muni MPCT_ Final. xls] MuniFin!$ A$ 6:$ W$ 60,2, 0)* Defl)

Sample Weighted FTE Sample weighted number of employees Data N Y = IF( L7="","",$ E7* L7) = IF( L294="","",$ E294* L294)

Sample Weighted Revenue Sample weighted site revenue, 1996$ Data O Y = IF( M7="","",$ E7* M7) = IF( M294="","",$ E294* M294) = IF( M770="","",$ E770* M770)

Open in Baseline Is this site projected to be open in the baseline? 0= no; 1= yes Data P N =[ MPCT_ Final. xls] Base! T7 ='[ I& S_ MPCT_ Final. xls] Base'!$ R7 = VLOOKUP($ B723,[ RailMPCT_ Final. xls] Base!$ A$ 6:$ AN$ 15,18,0) 1 Post Compliance Closures: Opt 1 Is this site projected to be open in the baseline but close under option 1? 0= no; 1= yes Data Q N =[ MPCT_ Final. xls] O1!$ T7 ='[ I& S_ MPCT_ Final. xls] O1'!$ T7 = VLOOKUP($ B723,[ RailMPCT_ Final. xls] O1!$ A$ 6:$ AA$ 15,20,0) 0 Post Compliance Closures: Opt 2 Is this site projected to be open in the baseline but close under option 2? 0= no; 1= yes Data R N =[ MPCT_ Final. xls] O2!$ T7 ='[ I& S_ MPCT_ Final. xls] O2'!$ T7 = VLOOKUP($ B723,[ RailMPCT_ Final. xls] O2!$ A$ 6:$ AA$ 15,20,0) 0 Post Compliance Closures: Opt 3 Is this site projected to be open in the baseline but close under option 3? 0= no; 1= yes Data S N =[ MPCT_ Final. xls] O3!$ T7 ='[ I& S_ MPCT_ Final. xls] O3'!$ T7 = VLOOKUP($ B723,[ RailMPCT_ Final. xls] O3!$ A$ 6:$ AA$ 15,20,0) 0 Post Compliance Closures: Opt 4 Is this site projected to be open in the baseline but close under option 4? 0= no; 1= yes Data T N =[ MPCT_ Final. xls] O4!$ T7 ='[ I& S_ MPCT_ Final. xls] O4'!$ T7 = VLOOKUP($ B723,[ RailMPCT_ Final. xls] O4!$ A$ 6:$ AA$ 15,20,0) 0 Weighted After Tax ( Private) Compliance Cost ( 2001$): C1 Sample Weighted Option 1 After Tax Compliance Cost in 2001$ Data U Y = Defl*$ E7*[ MPCT_ Final. xls] O1! G7 =$ E294* I_ S_ Defl*'[ I& S_ MPCT_ Final. xls] O1'!$ G7 = Defl*$ E723*[ RailMPCT_ Final. xls] Costs! E5 = Defl*$ E770* VLOOKUP($ A770,[ MuniMP CT_ Final. xls] Costs!$ A$ 7:$ Z$ 127,6,0) CBI VARIABLE DESCRIPTION WORKSHEET COLUMN February 14, 2003 1 of 187 Summary_ Final numeric. xls  Var Desc Record for the Final Metal Product and Machinery Rule 1 2 34 A B C D E F G H I VARIABLE DESCRIPTIONS FOR SUMMARY_ FINAL. XLS FINAL MP& M RULE FORMULA Long, Short, and Phase 1 Surveys Iron and Steel Surveys Railroad Surveys Municipality Surveys CBI VARIABLE DESCRIPTION WORKSHEET COLUMN 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Weighted After Tax ( Private) Compliance Cost ( 2001$): C2 Sample Weighted Option 2 After Tax Compliance Cost in 2001$ Data V Y = Defl*$ E7*[ MPCT_ Final. xls] O2! G7 =$ E294* I_ S_ Defl*'[ I& S_ MPCT_ Final. xls] O2'!$ G7 = Defl*$ E723*[ RailMPCT_ Final. xls] Costs! H5 = Defl*$ E770* VLOOKUP($ A770,[ MuniMP CT_ Final. xls] Costs!$ A$ 7:$ Z$ 127,9,0)

Weighted After Tax ( Private) Compliance Cost ( 2001$): C3 Sample Weighted Option 3 After Tax Compliance Cost in 2001$ Data W Y = Defl*$ E7*[ MPCT_ Final. xls] O3! G7 =$ E294* I_ S_ Defl*'[ I& S_ MPCT_ Final. xls] O3'!$ G7 = Defl*$ E723*[ RailMPCT_ Final. xls] Costs! K5 = Defl*$ E770* VLOOKUP($ A770,[ MuniMP CT_ Final. xls] Costs!$ A$ 7:$ Z$ 127,12,0)

Weighted After Tax ( Private) Compliance Cost ( 2001$): C4 Sample Weighted Option 4 After Tax Compliance Cost in 2001$ Data X Y = Defl*$ E7*[ MPCT_ Final. xls] O4! G7 =$ E294* I_ S_ Defl*'[ I& S_ MPCT_ Final. xls] O4'!$ G7 = Defl*$ E723*[ RailMPCT_ Final. xls] Costs! N5 = Defl*$ E770* VLOOKUP($ A770,[ MuniMP CT_ Final. xls] Costs!$ A$ 7:$ Z$ 127,15,0)

Weighted Closures: Base Weighted baseline closures Data Y Y = IF( P7= 0, E7,0) = IF( P294= 0, E294,0) = IF( P723= 0, E723,0) = IF( P770= 0, E770,0)

Sample Weighted Incremental Closures: W1 Sample weighted incremental closures in option 1 Data Z Y = Q7*$ E7 = Q294*$ E294 = Q723*$ E723 = Q770*$ E770 Sample Weighted Incremental Closures: W2 Sample weighted incremental closures in option 2 Data AA Y = R7*$ E7 = R294*$ E294 = R723*$ E723 = R770*$ E770 Sample Weighted Incremental Closures: W3 Sample weighted incremental closures in option 3 Data AB Y = S7*$ E7 = S294*$ E294 = S723*$ E723 = S770*$ E770 Sample Weighted Incremental Closures: W4 Sample weighted incremental closures in option 4 Data AC Y = T7*$ E7 = T294*$ E294 = T723*$ E723 = T770*$ E770 Sample Weighted Removals, Lbs Eq: WR1 Sample weighted removals, lbs eq, option 1 Data AD Y = IF( ISNA( VLOOKUP($ A7, Rmvls!$ A$ 11: $ M$ 874, AD$ 1,0)), NA(), VLOOKUP($ A7, Rmvls!$ A$ 11:$ M$ 874, AD$ 1,0)) = IF( ISNA( VLOOKUP($ A294, Rmvls!$ A$ 1 1:$ M$ 874, AD$ 1,0)), NA(), VLOOKUP($ A2 94, Rmvls!$ A$ 11:$ M$ 874, AD$ 1,0)) = IF( ISNA( VLOOKUP($ A723, Rmvls!$ A$ 1 1:$ M$ 874, AD$ 1,0)), NA(), VLOOKUP($ A7 23, Rmvls!$ A$ 11:$ M$ 874, AD$ 1,0)) = IF( ISNA( VLOOKUP($ A770, Rmvls!$ A$ 1 1:$ M$ 874, AD$ 1,0)), NA(), VLOOKUP($ A7 70, Rmvls!$ A$ 11:$ M$ 874, AD$ 1,0))

Sample Weighted Removals, Lbs Eq: WR2 Sample weighted removals, lbs eq, option 2 Data AE Y = IF( ISNA( VLOOKUP($ A7, Rmvls!$ A$ 11: $ M$ 874, AE$ 1,0)), NA(), VLOOKUP($ A7, Rmvls!$ A$ 11:$ M$ 874, AE$ 1,0)) = IF( ISNA( VLOOKUP($ A294, Rmvls!$ A$ 1 1:$ M$ 874, AE$ 1,0)), NA(), VLOOKUP($ A2 94, Rmvls!$ A$ 11:$ M$ 874, AE$ 1,0)) = IF( ISNA( VLOOKUP($ A723, Rmvls!$ A$ 1 1:$ M$ 874, AE$ 1,0)), NA(), VLOOKUP($ A7 23, Rmvls!$ A$ 11:$ M$ 874, AE$ 1,0)) = IF( ISNA( VLOOKUP($ A770, Rmvls!$ A$ 1 1:$ M$ 874, AE$ 1,0)), NA(), VLOOKUP($ A7 70, Rmvls!$ A$ 11:$ M$ 874, AE$ 1,0))

Sample Weighted Removals, Lbs Eq: WR3 Sample weighted removals, lbs eq, option 3 Data AF Y = IF( ISNA( VLOOKUP($ A7, Rmvls!$ A$ 11: $ M$ 874, AF$ 1,0)), NA(), VLOOKUP($ A7, R mvls!$ A$ 11:$ M$ 874, AF$ 1,0)) = IF( ISNA( VLOOKUP($ A294, Rmvls!$ A$ 1 1:$ M$ 874, AF$ 1,0)), NA(), VLOOKUP($ A2 94, Rmvls!$ A$ 11:$ M$ 874, AF$ 1,0)) = IF( ISNA( VLOOKUP($ A723, Rmvls!$ A$ 1 1:$ M$ 874, AF$ 1,0)), NA(), VLOOKUP($ A7 23, Rmvls!$ A$ 11:$ M$ 874, AF$ 1,0)) = IF( ISNA( VLOOKUP($ A770, Rmvls!$ A$ 1 1:$ M$ 874, AF$ 1,0)), NA(), VLOOKUP($ A7 70, Rmvls!$ A$ 11:$ M$ 874, AF$ 1,0))

Sample Weighted Removals, Lbs Eq: WR4 Sample weighted removals, lbs eq, option 4 Data AG Y = IF( ISNA( VLOOKUP($ A7, Rmvls!$ A$ 11: $ M$ 874, AG$ 1,0)), NA(), VLOOKUP($ A7, Rmvls!$ A$ 11:$ M$ 874, AG$ 1,0)) = IF( ISNA( VLOOKUP($ A294, Rmvls!$ A$ 1 1:$ M$ 874, AG$ 1,0)), NA(), VLOOKUP($ A2 94, Rmvls!$ A$ 11:$ M$ 874, AG$ 1,0)) = IF( ISNA( VLOOKUP($ A723, Rmvls!$ A$ 1 1:$ M$ 874, AG$ 1,0)), NA(), VLOOKUP($ A7 23, Rmvls!$ A$ 11:$ M$ 874, AG$ 1,0)) = IF( ISNA( VLOOKUP($ A770, Rmvls!$ A$ 1 1:$ M$ 874, AG$ 1,0)), NA(), VLOOKUP($ A7 70, Rmvls!$ A$ 11:$ M$ 874, AG$ 1,0))

Sample Weighted Incremental Moderate Impacts: Base Sample weighted incremental moderate impacts in the baseline Data AH Y = VLOOKUP($ A7,[ MPCT_ Final. xls] Base! $ A$ 7:$ X$ 932,24,0)*$ E7 = VLOOKUP($ A294,'[ I& S_ MPCT_ Final. xl s] Base'!$ A$ 7:$ V$ 1152,22,0)*$ E294 = VLOOKUP($ B723,[ RailMPCT_ Final. xls] Base!$ A$ 6:$ AN$ 15,22,0)* E723 0 Sample Weighted Incremental Moderate Impacts: M1 Sample weighted incremental moderate impacts in option 1 Data AI Y = IF( AND($ C7= 1,$ P7= 1, Q7= 0), VLOOKU P($ A7,[ MPCT_ Final. xls] O1!$ A$ 7:$ Y$ 110 8,25,0)*$ E7,0) = IF( AND($ C294= 1,$ P294= 1, Q294= 0), VL OOKUP($ A294,'[ I& S_ MPCT_ Final. xls] O 1'!$ A$ 5:$ Y$ 102,25,0)*$ E294,0) = VLOOKUP($ B723,[ RailMPCT_ Final. xls] O1!$ A$ 6:$ AA$ 15,25,0)*$ E723 0 Sample Weighted Incremental Moderate Impacts: M2 Sample weighted incremental moderate impacts in option 2 Data AJ Y = IF( AND($ C7= 1,$ P7= 1, R7= 0), VLOOKU P($ A7,[ MPCT_ Final. xls] O2!$ A$ 7:$ Y$ 110 8,25,0)*$ E7,0) = IF( AND($ C294= 1,$ P294= 1, R294= 0), VL OOKUP($ A294,'[ I& S_ MPCT_ Final. xls] O 2'!$ A$ 5:$ Y$ 102,25,0)*$ E294,0) = VLOOKUP($ B723,[ RailMPCT_ Final. xls] O2!$ A$ 6:$ AA$ 15,25,0)*$ E723 0 Sample Weighted Incremental Moderate Impacts: M3 Sample weighted incremental moderate impacts in option 3 Data AK Y = IF( AND($ C7= 1,$ P7= 1, S7= 0), VLOOKU P($ A7,[ MPCT_ Final. xls] O3!$ A$ 7:$ Y$ 115 0,25,0)*$ E7,0) = IF( AND($ C294= 1,$ P294= 1, S294= 0), VL OOKUP($ A294,'[ I& S_ MPCT_ Final. xls] O 3'!$ A$ 5:$ Y$ 102,25,0)*$ E294,0) = VLOOKUP($ B723,[ RailMPCT_ Final. xls] O3!$ A$ 6:$ AA$ 15,25,0)*$ E723 0 Sample Weighted Incremental Moderate Impacts: M4 Sample weighted incremental moderate impacts in option 4 Data AL Y = IF( AND($ C7= 1,$ P7= 1, T7= 0), VLOOKU P($ A7,[ MPCT_ Final. xls] O4!$ A$ 7:$ Y$ 113 3,25,0)*$ E7,0) = IF( AND($ C294= 1,$ P294= 1, T294= 0), VL OOKUP($ A294,'[ I& S_ MPCT_ Final. xls] O 4'!$ A$ 5:$ Y$ 102,25,0)*$ E294,0) = VLOOKUP($ B723,[ RailMPCT_ Final. xls] O4!$ A$ 6:$ AA$ 15,25,0)*$ E723 0 February 14, 2003 2 of 187 Summary_ Final numeric. xls  Var Desc Record for the Final Metal Product and Machinery Rule 1 2 34 A B C D E F G H I VARIABLE DESCRIPTIONS FOR SUMMARY_ FINAL. XLS FINAL MP& M RULE FORMULA Long, Short, and Phase 1 Surveys Iron and Steel Surveys Railroad Surveys Municipality Surveys CBI VARIABLE DESCRIPTION WORKSHEET COLUMN 43 44 45 46 47 48 49 50 51 52 53 54 55 56 After Tax Compliance Cost as % of Post Compliance Revenue: CPR1 Annualized After Tax Compliance Cost as a percent of Post Compliance Revenue in Option 1 Data AM Y = VLOOKUP($ A7, [ MPCT_ Final. xls] O1!$ A$ 7:$ AA$ 944, 27,0) = VLOOKUP($ A294, '[ I& S_ MPCT_ Final. xls] O1'!$ A$ 7:$ AA$ 94 8, 27,0)

After Tax Compliance Cost as % of Post Compliance Revenue: CPR2 Annualized After Tax Compliance Cost as a percent of Post Compliance Revenue in Option 2 Data AN Y = VLOOKUP($ A7, [ MPCT_ Final. xls] O2!$ A$ 7:$ AA$ 944, 27,0) = VLOOKUP($ A294, '[ I& S_ MPCT_ Final. xls] O2'!$ A$ 7:$ AA$ 94 8, 27,0)

After Tax Compliance Cost as % of Post Compliance Revenue: CPR3 Annualized After Tax Compliance Cost as a percent of Post Compliance Revenue in Option 3 Data AO Y = VLOOKUP($ A7, [ MPCT_ Final. xls] O3!$ A$ 7:$ AA$ 944, 27,0) = VLOOKUP($ A294, '[ I& S_ MPCT_ Final. xls] O3'!$ A$ 7:$ AA$ 94 8, 27,0)

After Tax Compliance Cost as % of Post Compliance Revenue: CPR4 Annualized After Tax Compliance Cost as a percent of Post Compliance Revenue in Option 4 Data AP Y = VLOOKUP($ A7, [ MPCT_ Final. xls] O4!$ A$ 7:$ AA$ 944, 27,0) = VLOOKUP($ A294, '[ I& S_ MPCT_ Final. xls] O4'!$ A$ 7:$ AA$ 94 8, 27,0)

Range of ACC as % of PCR: SPB1 Range of Annualized After Tax Compliance Cost as a percent of Post Compliance Revenue in Option 1: 2 is greater than 3%; 1 is between 1 and 3%; 0 is less than 1% Data AQ N = IF( AM7>= 0.03," 2", IF( AM7>= 0.01," 1"," 0" )) = IF( AM294>= 0.03," 2", IF( AM294>= 0.01," 1"," 0")) = IF( AM723>= 0.03," 2", IF( AM723>= 0.01," 1"," 0"))

Range of ACC as % of PCR: SPB2 Range of Annualized After Tax Compliance Cost as a percent of Post Compliance Revenue in Option 2: 2 is greater than 3%; 1 is between 1 and 3%; 0 is less than 1% Data AR N = IF( AN7>= 0.03," 2", IF( AN7>= 0.01," 1"," 0" )) = IF( AN294>= 0.03," 2", IF( AN294>= 0.01," 1"," 0")) = IF( AN723>= 0.03," 2", IF( AN723>= 0.01," 1"," 0"))

Range of ACC as % of PCR: SPB3 Range of Annualized After Tax Compliance Cost as a percent of Post Compliance Revenue in Option 3: 2 is greater than 3%; 1 is between 1 and 3%; 0 is less than 1% Data AS N = IF( AO7>= 0.03," 2", IF( AO7>= 0.01," 1"," 0" )) = IF( AO294>= 0.03," 2", IF( AO294>= 0.01," 1"," 0")) = IF( AO723>= 0.03," 2", IF( AO723>= 0.01," 1"," 0"))

Range of ACC as % of PCR: SPB4 Range of Annualized After Tax Compliance Cost as a percent of Post Compliance Revenue in Option 4: 2 is greater than 3%; 1 is between 1 and 3%; 0 is less than 1% Data AT N = IF( AP7>= 0.03," 2", IF( AP7>= 0.01," 1"," 0") ) = IF( AP294>= 0.03," 2", IF( AP294>= 0.01," 1 "," 0")) = IF( AP723>= 0.03," 2", IF( AP723>= 0.01," 1 "," 0"))

Pvt v Govt: PVT Is this site owned by a private firm or part of a municipality? 1= private; 0= government Data AU N 1 1 1 0 Sample Weighted Compliance Costs; 2001$: Cap 1 Sample Weighted Capital Costs in Option 1, 2001$ Data AV Y =$ E7* VLOOKUP($ A7,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ Q$ 999,6,0) =$ E294* VLOOKUP($ A294,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ Q$ 999,6,0) =$ E723* VLOOKUP($ A723,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ Q$ 999,6,0) =$ E770* VLOOKUP($ A770,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ Q$ 999,6,0)

Sample Weighted Compliance Costs; 2001$: Ann 1 Sample Weighted Annual Costs in Option 1, 2001$ Data AW Y =$ E7* VLOOKUP($ A7,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ Q$ 999,5,0) =$ E294* VLOOKUP($ A294,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ Q$ 999,5,0) =$ E723* VLOOKUP($ A723,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ Q$ 999,5,0) =$ E770* VLOOKUP($ A770,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ Q$ 999,5,0)

Sample Weighted Compliance Costs; 2001$: Cap 2 Sample Weighted Capital Costs in Option 2, 2001$ Data AX Y =$ E7* VLOOKUP($ A7,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ Q$ 999,9,0) =$ E294* VLOOKUP($ A294,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ Q$ 999,9,0) =$ E723* VLOOKUP($ A723,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ Q$ 999,9,0) =$ E770* VLOOKUP($ A770,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ Q$ 999,9,0)

Sample Weighted Compliance Costs; 2001$: Ann 2 Sample Weighted Annual Costs in Option 2, 2001$ Data AY Y =$ E7* VLOOKUP($ A7,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ Q$ 999,8,0) =$ E294* VLOOKUP($ A294,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ Q$ 999,8,0) =$ E723* VLOOKUP($ A723,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ Q$ 999,8,0) =$ E770* VLOOKUP($ A770,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ Q$ 999,8,0)

Sample Weighted Compliance Costs; 2001$: Cap 3 Sample Weighted Capital Costs in Option 3, 2001$ Data AZ Y =$ E7* VLOOKUP($ A7,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ Q$ 999,12,0) =$ E294* VLOOKUP($ A294,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ Q$ 999,12,0) =$ E723* VLOOKUP($ A723,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ Q$ 999,12,0) =$ E770* VLOOKUP($ A770,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ Q$ 999,12,0)

February 14, 2003 3 of 187 Summary_ Final numeric. xls  Var Desc Record for the Final Metal Product and Machinery Rule 1 2 34 A B C D E F G H I VARIABLE DESCRIPTIONS FOR SUMMARY_ FINAL. XLS FINAL MP& M RULE FORMULA Long, Short, and Phase 1 Surveys Iron and Steel Surveys Railroad Surveys Municipality Surveys CBI VARIABLE DESCRIPTION WORKSHEET COLUMN 57 58 59 60 61 62 63 64 65 66 67 68 69 Sample Weighted Compliance Costs; 2001$: Ann 3 Sample Weighted Annual Costs in Option 3, 2001$ Data BA Y =$ E7* VLOOKUP($ A7,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ Q$ 999,11,0) =$ E294* VLOOKUP($ A294,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ Q$ 999,11,0) =$ E723* VLOOKUP($ A723,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ Q$ 999,11,0) =$ E770* VLOOKUP($ A770,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ Q$ 999,11,0)

Sample Weighted Compliance Costs; 2001$: Cap 4 Sample Weighted Capital Costs in Option 4, 2001$ Data BB Y = VLOOKUP($ A7,'[ CompCost_ Final. xls] 2 001'!$ A$ 7:$ Q$ 999,15,0)*$ E7 = VLOOKUP($ A294,'[ CompCost_ Final. xls ] 2001'!$ A$ 7:$ Q$ 999,15,0)*$ E294 = VLOOKUP($ A723,'[ CompCost_ Final. xls ] 2001'!$ A$ 7:$ Q$ 999,15,0)*$ E723 = VLOOKUP($ A770,'[ CompCost_ Final. xls ] 2001'!$ A$ 7:$ Q$ 999,15,0)*$ E770 Sample Weighted Compliance Costs; 2001$: Ann 4 Sample Weighted Annual Costs in Option 4, 2001$ Data BC Y = VLOOKUP($ A7,'[ CompCost_ Final. xls] 2 001'!$ A$ 7:$ Q$ 999,14,0)*$ E7 = VLOOKUP($ A294,'[ CompCost_ Final. xls ] 2001'!$ A$ 7:$ Q$ 999,14,0)*$ E294 = VLOOKUP($ A723,'[ CompCost_ Final. xls ] 2001'!$ A$ 7:$ Q$ 999,14,0)*$ E723 = VLOOKUP($ A770,'[ CompCost_ Final. xls ] 2001'!$ A$ 7:$ Q$ 999,14,0)*$ E770 Sample Weighted Pre Tax Compliance Costs ( annualized at 7 percent, 2001$): PTCC1 Sample Weighted Pre Tax Compliance Costs in Option 1, annualized at 7%, 2001$ Data BD Y = IF( ISNA( VLOOKUP($ A7,'[ CompCost_ Fi nal. xls] 2001'!$ A$ 7:$ P$ 999, BD$ 1,0)), 0, V LOOKUP($ A7,'[ CompCost_ Final. xls] 200 1'!$ A$ 7:$ P$ 999, BD$ 1,0)*$ E7) = IF( ISNA( VLOOKUP($ A294,'[ CompCost _ Final. xls] 2001'!$ A$ 7:$ P$ 999, BD$ 1,0)), 0 , VLOOKUP($ A294,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ P$ 999, BD$ 1,0)*$ E294) = IF( ISNA( VLOOKUP($ A723,'[ CompCost _ Final. xls] 2001'!$ A$ 7:$ P$ 999, BD$ 1,0)), 0 , VLOOKUP($ A723,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ P$ 999, BD$ 1,0)*$ E723) = IF( ISNA( VLOOKUP($ A770,'[ CompCost _ Final. xls] 2001'!$ A$ 7:$ P$ 999, BD$ 1,0)), 0 , VLOOKUP($ A770,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ P$ 999, BD$ 1,0)*$ E770)

Sample Weighted Pre Tax Compliance Costs ( annualized at 7 percent, 2001$): PTCC2 Sample Weighted Pre Tax Compliance Costs in Option 2, annualized at 7%, 2001$ Data BE Y = IF( ISNA( VLOOKUP($ A7,'[ CompCost_ Fi nal. xls] 2001'!$ A$ 7:$ P$ 999, BE$ 1,0)), 0, V LOOKUP($ A7,'[ CompCost_ Final. xls] 200 1'!$ A$ 7:$ P$ 999, BE$ 1,0)*$ E7) = IF( ISNA( VLOOKUP($ A294,'[ CompCost _ Final. xls] 2001'!$ A$ 7:$ P$ 999, BE$ 1,0)), 0 , VLOOKUP($ A294,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ P$ 999, BE$ 1,0)*$ E294) = IF( ISNA( VLOOKUP($ A723,'[ CompCost _ Final. xls] 2001'!$ A$ 7:$ P$ 999, BE$ 1,0)), 0 , VLOOKUP($ A723,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ P$ 999, BE$ 1,0)*$ E723) = IF( ISNA( VLOOKUP($ A770,'[ CompCost _ Final. xls] 2001'!$ A$ 7:$ P$ 999, BE$ 1,0)), 0 , VLOOKUP($ A770,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ P$ 999, BE$ 1,0)*$ E770)

Sample Weighted Pre Tax Compliance Costs ( annualized at 7 percent, 2001$): PTCC3 Sample Weighted Pre Tax Compliance Costs in Option 3, annualized at 7%, 2001$ Data BF Y = IF( ISNA( VLOOKUP($ A7,'[ CompCost_ Fi nal. xls] 2001'!$ A$ 7:$ P$ 999, BF$ 1,0)), 0, V LOOKUP($ A7,'[ CompCost_ Final. xls] 200 1'!$ A$ 7:$ P$ 999, BF$ 1,0)*$ E7) = IF( ISNA( VLOOKUP($ A294,'[ CompCost _ Final. xls] 2001'!$ A$ 7:$ P$ 999, BF$ 1,0)), 0 , VLOOKUP($ A294,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ P$ 999, BF$ 1,0)*$ E294) = IF( ISNA( VLOOKUP($ A723,'[ CompCost _ Final. xls] 2001'!$ A$ 7:$ P$ 999, BF$ 1,0)), 0 , VLOOKUP($ A723,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ P$ 999, BF$ 1,0)*$ E723) = IF( ISNA( VLOOKUP($ A770,'[ CompCost _ Final. xls] 2001'!$ A$ 7:$ P$ 999, BF$ 1,0)), 0 , VLOOKUP($ A770,'[ CompCost_ Final. xls] 2001'!$ A$ 7:$ P$ 999, BF$ 1,0)*$ E770)

Sample Weighted Pre Tax Compliance Costs ( annualized at 7 percent, 2001$): PTCC4 Sample Weighted Pre Tax Compliance Costs in Option 4, annualized at 7%, 2001$ Data BG Y = IF( ISNA( VLOOKUP($ A7,'[ CompCost_ Fi nal. xls] 2001'!$ A$ 7:$ P$ 999, BG$ 1,0)), 0, V LOOKUP($ A7,'[ CompCost_ Final. xls] 200 1'!$ A$ 7:$ P$ 999, BG$ 1,0)*$ E7) = IF( ISNA( VLOOKUP($ A294,'[ CompCost _ Final. xls] 2001'!$ A$ 7:$ P$ 999, BG$ 1,0)), 0, VLOOKUP($ A294,'[ CompCost_ Final. xl s] 2001'!$ A$ 7:$ P$ 999, BG$ 1,0)*$ E294) = IF( ISNA( VLOOKUP($ A723,'[ CompCost _ Final. xls] 2001'!$ A$ 7:$ P$ 999, BG$ 1,0)), 0, VLOOKUP($ A723,'[ CompCost_ Final. xl s] 2001'!$ A$ 7:$ P$ 999, BG$ 1,0)*$ E723) = IF( ISNA( VLOOKUP($ A770,'[ CompCost _ Final. xls] 2001'!$ A$ 7:$ P$ 999, BG$ 1,0)), 0, VLOOKUP($ A770,'[ CompCost_ Final. xl s] 2001'!$ A$ 7:$ P$ 999, BG$ 1,0)*$ E770)

Sample Weighted Pre Tax Post Closure Compliance Costs ( annualized at 7 percent, 2001$): PPCC1 Sample Weighted Pre Tax Post Closure Compliance Costs in Option 1, annualized at 7% , 2001$ Data BH Y = IF( Q7= 0, BD7,0) = IF( Q294= 0, BD294,0) = IF( Q723= 0, BD723,0) = IF( Q770= 0, BD770,0)

Sample Weighted Pre Tax Post Closure Compliance Costs ( annualized at 7 percent, 2001$): PPCC2 Sample Weighted Pre Tax Post Closure Compliance Costs in Option 2, annualized at 7% , 2001$ Data BI Y = IF( R7= 0, BE7,0) = IF( R294= 0, BE294,0) = IF( R723= 0, BE723,0) = IF( R770= 0, BE770,0)

Sample Weighted Pre Tax Post Closure Compliance Costs ( annualized at 7 percent, 2001$): PPCC3 Sample Weighted Pre Tax Post Closure Compliance Costs in Option 3, annualized at 7% , 2001$ Data BJ Y = IF( S7= 0, BF7,0) = IF( S294= 0, BF294,0) = IF( S723= 0, BF723,0) = IF( S770= 0, BF770,0)

Sample Weighted Pre Tax Post Closure Compliance Costs ( annualized at 7 percent, 2001$): PPCC4 Sample Weighted Pre Tax Post Closure Compliance Costs in Option 4, annualized at 7% , 2001$ Data BK Y = IF( T7= 0, BG7,0) = IF( T294= 0, BG294,0) = IF( T723= 0, BG723,0) = IF( T770= 0, BG770,0)

Closure Data for Removal. mdb: OpenB Is this site projected to be open in the baseline? 0= no; 1= yes Data BL N = P7 = P294 = P723 = P770 Closure Data for Removal. mdb: Open1 Is this site projected to be open in option 1? 0= no; 1= yes Data BM N = IF( Q7= 0,1, IF( Q7= 1,0,2)) = IF( Q294= 0,1, IF( Q294= 1,0,2)) = IF( Q723= 0,1, IF( Q723= 1,0,2)) = IF( Q770= 0,1, IF( Q770= 1,0,2))

February 14, 2003 4 of 187 Summary_ Final numeric. xls  Var Desc Record for the Final Metal Product and Machinery Rule 1 2 34 A B C D E F G H I VARIABLE DESCRIPTIONS FOR SUMMARY_ FINAL. XLS FINAL MP& M RULE FORMULA Long, Short, and Phase 1 Surveys Iron and Steel Surveys Railroad Surveys Municipality Surveys CBI VARIABLE DESCRIPTION WORKSHEET COLUMN 70 71 72 73 74 75 76 77 78 79 Closure Data for Removal. mdb: Open2 Is this site projected to be open in option 2? 0= no; 1= yes Data BN N = IF( R7= 0,1, IF( R7= 1,0,2)) = IF( R294= 0,1, IF( R294= 1,0,2)) = IF( R723= 0,1, IF( R723= 1,0,2)) = IF( R770= 0,1, IF( R770= 1,0,2))

Closure Data for Removal. mdb: Open3 Is this site projected to be open in option 3? 0= no; 1= yes Data BO N = IF( S7= 0,1, IF( S7= 1,0,2)) = IF( S294= 0,1, IF( S294= 1,0,2)) = IF( S723= 0,1, IF( S723= 1,0,2)) = IF( S770= 0,1, IF( S770= 1,0,2))

Closure Data for Removal. mdb: Open4 Is this site projected to be open in option 4? 0= no; 1= yes Data BP N = IF( T7= 0,1, IF( T7= 1,0,2)) = IF( T294= 0,1, IF( T294= 1,0,2)) = IF( T723= 0,1, IF( T723= 1,0,2)) = IF( T770= 0,1, IF( T770= 1,0,2))

Universe of Facilities Subject to Reg. Requirements: Reg1 Is this facility subject to regulatory requirements in option 1? 0= no; 1= yes Data BQ N = VLOOKUP($ A7,' Reg Facs'!$ A$ 4:$ F$ 947,3,0) = VLOOKUP($ A7,' Reg Facs'!$ A$ 4:$ F$ 947,3,0) = VLOOKUP($ A723,' Reg Facs'!$ A$ 4:$ F$ 947,3,0) = VLOOKUP($ A770,' Reg Facs'!$ A$ 4:$ F$ 947,3,0)

Universe of Facilities Subject to Reg. Requirements: Reg2 Is this facility subject to regulatory requirements in option 2? 0= no; 1= yes Data BR N = VLOOKUP($ A7,' Reg Facs'!$ A$ 4:$ F$ 947,4,0) = VLOOKUP($ A294,' Reg Facs'!$ A$ 4:$ F$ 947,4,0) = VLOOKUP($ A723,' Reg Facs'!$ A$ 4:$ F$ 947,4,0) = VLOOKUP($ A770,' Reg Facs'!$ A$ 4:$ F$ 947,4,0)

Universe of Facilities Subject to Reg. Requirements: Reg3 Is this facility subject to regulatory requirements in option 3? 0= no; 1= yes Data BS N = VLOOKUP($ A7,' Reg Facs'!$ A$ 4:$ F$ 947,5,0) = VLOOKUP($ A294,' Reg Facs'!$ A$ 4:$ F$ 947,5,0) = VLOOKUP($ A723,' Reg Facs'!$ A$ 4:$ F$ 947,5,0) = VLOOKUP($ A770,' Reg Facs'!$ A$ 4:$ F$ 947,5,0)

Universe of Facilities Subject to Reg. Requirements: Reg4 Is this facility subject to regulatory requirements in option 4? 0= no; 1= yes Data BT N = VLOOKUP($ A7,' Reg Facs'!$ A$ 4:$ F$ 947,6,0) = VLOOKUP($ A294,' Reg Facs'!$ A$ 4:$ F$ 947,6,0) = VLOOKUP($ A723,' Reg Facs'!$ A$ 4:$ F$ 947,6,0) = VLOOKUP($ A770,' Reg Facs'!$ A$ 4:$ F$ 947,6,0)

CT1 Compliance Type under Option 2 ( Proposed/ NODA): Excl = excluded; Exmpt = below cutoffs in baseline; CH = above cutoff in baseline, goes to contract haul; BCbyP2 = above cutoff in baseline, below cutoff in post compliance ( pollution prevention); Reg = above cutoff in baseline and post compliance Data BU N Regulatory Status: Status1 Regulatory Status under Option 1: Excl = subcategory exclusion; Exmpt = below cutoffs in baseline; Base Close = baseline closure; Reg = subject to regulatory requirements and not a closure or moderate impact; Reg Close = postcompliance closure; Mod = postcompliance moderate impact Data BV N = IF($ A7="","", IF($ P7= 0," base close", IF( BQ7= 0," excl", IF( BQ7= 1, IF( Q7= 1," reg close", IF( AI7> 0," mod"," reg")))))) = IF($ A294="","", IF($ P294= 0," base close", IF( BQ294= 0," excl", IF( BQ294= 1, IF ( Q294= 1," reg close", IF( AI294> 0," mod"," reg")))))) = IF($ A723="","", IF($ P723= 0," base close", IF( BQ723= 0," excl", IF( BQ723= 1, IF ( Q723= 1," reg close", IF( AI723> 0," mod"," reg")))))) = IF($ A770="","", IF($ P770= 0," base close", IF( BQ770= 0," excl", IF( BQ770= 1, IF ( Q770= 1," reg close", IF( AI770> 0," mod"," reg"))))))

Regulatory Status: Status2 Regulatory Status under Option 2: Excl = subcategory exclusion; Exmpt = below cutoffs in baseline; Base Close = baseline closure; Reg = subject to regulatory requirements and not a closure or moderate impact; Reg Close = postcompliance closure; Mod = postcompliance moderate impact Data BW N = IF($ A7="","", IF($ P7= 0," base close", IF( OR($ BU7=" excl",$ BU7=" exmpt" ),$ BU7, IF($ R7= 1," reg close", IF( AJ7> 0," mod"," reg"))))) # REF! # REF!

February 14, 2003 5 of 187 Summary_ Final numeric. xls  Var Desc Record for the Final Metal Product and Machinery Rule 1 2 34 A B C D E F G H I VARIABLE DESCRIPTIONS FOR SUMMARY_ FINAL. XLS FINAL MP& M RULE FORMULA Long, Short, and Phase 1 Surveys Iron and Steel Surveys Railroad Surveys Municipality Surveys CBI VARIABLE DESCRIPTION WORKSHEET COLUMN 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 Regulatory Status: Status3 Regulatory Status under Option 3: Excl = subcategory exclusion; Exmpt = below cutoffs in baseline; Base Close = baseline closure; Reg = subject to regulatory requirements and not a closure or moderate impact; Reg Close = postcompliance closure; Mod = postcompliance moderate impact Data BX N = IF($ A7="","", IF($ P7= 0," base close", IF( BS7= 0," excl", IF( BS7= 1, IF( S7= 1," reg close", IF( AK7> 0," mod"," reg")))))) = IF($ A294="","", IF($ P294= 0," base close", IF( BS294= 0," excl", IF( BS294= 1, IF( S294= 1," reg close", IF( AK294> 0," mod"," reg")))))) = IF($ A723="","", IF($ P723= 0," base close", IF( BS723= 0," excl", IF( BS723= 1, IF( S723= 1," reg close", IF( AK723> 0," mod"," reg")))))) = IF($ A770="","", IF($ P770= 0," base close", IF( BS770= 0," excl", IF( BS770= 1, IF( S770= 1," reg close", IF( AK770> 0," mod"," reg"))))))

Regulatory Status: Status4 Regulatory Status under Option 4: Excl = subcategory exclusion; Exmpt = below cutoffs in baseline; Base Close = baseline closure; Reg = subject to regulatory requirements and not a closure or moderate impact; Reg Close = postcompliance closure; Mod = postcompliance moderate impact Data BY N = IF($ A7="","", IF($ P7= 0," base close", IF( BT7= 0," excl", IF( BT7= 1, IF( T7= 1 ," reg close", IF( AL7> 0," mod"," reg")))))) = IF($ A294="","", IF($ P294= 0," base close", IF( BT294= 0," excl", IF( BT294= 1, IF( T294= 1," reg close", IF( AL294> 0," mod"," reg")))))) = IF($ A723="","", IF($ P723= 0," base close", IF( BT723= 0," excl", IF( BT723= 1, IF( T723= 1," reg close", IF( AL723> 0," mod"," reg")))))) = IF($ A770'"","", IF($ P770= 0," base close", IF( BT770= 0," excl", IF( BT770= 1, IF( T770= 1," reg close", IF( AL770> 0," mod"," reg"))))))

Subcat& Flow Subcategory & Flow Data BZ Y = D7& I7 = D294& I294 = D723& I723 = D770& I770 Subcat Unique Subcategories Data CA Y SID Survey ID by_ Fac A N In Used to filter data in summary tables by_ Fac B N Weight Sample weight by_ Fac C Y = VLOOKUP( A7,[ facdata_ Final. xls] FacDa ta!$ B$ 5:$ F$ 866,5,0)

Sector Sector code by_ Fac D Y = VLOOKUP( A7, Data!$ A$ 6:$ F$ 889,6,0)

Small Bus Is the site owned by a small entity? 0= No; 1= Yes; 2= Unclassified by_ Fac E Y = VLOOKUP( A7, Data!$ A$ 6:$ CA$ 889,10, 0)

Permit Type M= Mass Based; C= Concentration Based; N= No Permit; D= Direct Discharger by_ Fac F Y = VLOOKUP( A7,'[ perm_ typfinal xls] Permit_ Type'!$ A$ 5:$ N$ 915,14,0)

Ind Dir Discharge type: D= Direct; I= Indirect by_ Fac G N = VLOOKUP( A7, Data!$ A$ 6:$ G$ 889,7,0)

Rev_ Src Revenue Source: M= Revenues come from manufacturing only; R= Revenues come from rebuilding and maintenance only; B= Revenues come from both manufacturing and rebuilding and maintenance; U= Unknown; MU= Municipality by_ Fac H N = VLOOKUP( A7,[ facdata_ Final. xls] FacDa ta!$ B$ 5:$ K$ 869,9,0)

Revenues Site revenue, 1996$ by_ Fac I Y = VLOOKUP( A7,[ MPCT_ Final. xls] Base!$ A$ 6:$ F$ 945,6,0)

Open in Baseline Is this site projected to be open in the baseline? 0= no; 1= yes by_ Fac J N = VLOOKUP( A7, Data!$ A$ 7:$ P$ 889, 16, 0)

Post Compliance Closures: Opt 1 Is this site projected to be open in the baseline but close under option 1? 0= no; 1= yes by_ Fac K N = VLOOKUP( A7, Data!$ A$ 6:$ T$ 889, 17, 0)

Post Compliance Closures: Opt 2 Is this site projected to be open in the baseline but close under option 2? 0= no; 1= yes by_ Fac L N = VLOOKUP( A7, Data!$ A$ 6:$ T$ 889, 18, 0)

Post Compliance Closures: Opt 3 Is this site projected to be open in the baseline but close under option 3? 0= no; 1= yes by_ Fac M N = VLOOKUP( A7, Data!$ A$ 6:$ T$ 889, 19, 0)

Post Compliance Closures: Opt 4 Is this site projected to be open in the baseline but close under option 4? 0= no; 1= yes by_ Fac N N = VLOOKUP( A7, Data!$ A$ 6:$ T$ 889, 20, 0) = VLOOKUP( A7,[ facdata_ Final. xls] FacData!$ B$ 5:$ F$ 866,5,0)

= VLOOKUP( A7, Data!$ A$ 6:$ F$ 889,6,0)

= VLOOKUP( A7, Data!$ A$ 6:$ CA$ 889,10,0)

= VLOOKUP( A7,'[ perm_ typ final. xls] Permit_ Type'!$ A$ 5:$ N$ 915,14,0)

= VLOOKUP( A7, Data!$ A$ 6:$ G$ 889,7,0)

= VLOOKUP( A7,[ facdata_ Final. xls] FacData!$ B$ 5:$ K$ 869,9,0)

= VLOOKUP( A7,[ MPCT_ Final. xls] Base!$ A$ 6:$ F$ 945,6,0)

= VLOOKUP( A7, Data!$ A$ 7:$ P$ 889, 16, 0)

= VLOOKUP( A7, Data!$ A$ 6:$ T$ 889, 17, 0)

= VLOOKUP( A7, Data!$ A$ 6:$ T$ 889, 18, 0)

= VLOOKUP( A7, Data!$ A$ 6:$ T$ 889, 19, 0)

= VLOOKUP( A7, Data!$ A$ 6:$ T$ 889, 20, 0)

February 14, 2003 6 of 187 Summary_ Final numeric. xls  Var Desc Record for the Final Metal Product and Machinery Rule 1 2 34 A B C D E F G H I VARIABLE DESCRIPTIONS FOR SUMMARY_ FINAL. XLS FINAL MP& M RULE FORMULA Long, Short, and Phase 1 Surveys Iron and Steel Surveys Railroad Surveys Municipality Surveys CBI VARIABLE DESCRIPTION WORKSHEET COLUMN 98 99 100 101 102 103 104 105 106 107 Sample Weighted Incremental Moderate Impacts: M1 Sample weighted incremental moderate impacts in option 1 by_ Fac O Y = VLOOKUP($ A7, Data!$ A$ 6:$ AL$ 889,35,0)

Sample Weighted Incremental Moderate Impacts: M2 Sample weighted incremental moderate impacts in option 2 by_ Fac P Y = VLOOKUP($ A7, Data!$ A$ 6:$ AL$ 889,36,0)

Sample Weighted Incremental Moderate Impacts: M3 Sample weighted incremental moderate impacts in option 3 by_ Fac Q Y = VLOOKUP($ A7, Data!$ A$ 6:$ AL$ 889,37,0)

Sample Weighted Incremental Moderate Impacts: M4 Sample weighted incremental moderate impacts in option 4 by_ Fac R Y = VLOOKUP($ A7, Data!$ A$ 6:$ AL$ 889,38,0)

Pvt v Govt: PVT Is this site owned by a private firm or part of a municipality? 1= private; 0= government by_ Fac S N 0 Regulatory Status: Reg1 Regulatory Status under Option 1: Excl = subcategory exclusion; Exmpt = below cutoffs in baseline; Base Close = baseline closure; Reg = subject to regulatory requirements and not a closure or moderate impact; Reg Close = postcompliance closure; Mod = postcompliance moderate impact by_ Fac T N = VLOOKUP( A7, Data!$ A$ 6:$ BZ$ 889,74, 0)

Regulatory Status: Reg2 Regulatory Status under Option 2: Excl = subcategory exclusion; Exmpt = below cutoffs in baseline; Base Close = baseline closure; Reg = subject to regulatory requirements and not a closure or moderate impact; Reg Close = postcompliance closure; Mod = postcompliance moderate impact by_ Fac U N = VLOOKUP( A7, Data!$ A$ 6:$ BZ$ 889,75, 0)

Regulatory Status: Reg3 Regulatory Status under Option 3: Excl = subcategory exclusion; Exmpt = below cutoffs in baseline; Base Close = baseline closure; Reg = subject to regulatory requirements and not a closure or moderate impact; Reg Close = postcompliance closure; Mod = postcompliance moderate impact by_ Fac V N = VLOOKUP( A7, Data!$ A$ 6:$ BZ$ 889,76, 0)

Regulatory Status: Reg4 Regulatory Status under Option 4: Excl = subcategory exclusion; Exmpt = below cutoffs in baseline; Base Close = baseline closure; Reg = subject to regulatory requirements and not a closure or moderate impact; Reg Close = postcompliance closure; Mod = postcompliance moderate impact by_ Fac W N = VLOOKUP( A7, Data!$ A$ 6:$ BZ$ 889,77, 0)

After Tax Compliance Cost as % of Post Compliance Revenue: CPR1 Annualized After Tax Compliance Cost as a percent of Post Compliance Revenue in Option 1 by_ Fac X N = VLOOKUP($ A7, Data!$ A$ 7:$ AP$ 889, 39,0) = VLOOKUP($ A7, Data!$ A$ 6:$ AL$ 889,35,0)

= VLOOKUP($ A7, Data!$ A$ 6:$ AL$ 889,36,0)

= VLOOKUP($ A7, Data!$ A$ 6:$ AL$ 889,37,0)

= VLOOKUP($ A7, Data!$ A$ 6:$ AL$ 889,38,0)

1 = VLOOKUP( A7, Data!$ A$ 6:$ BZ$ 889,74,0)

= VLOOKUP( A7, Data!$ A$ 6:$ BZ$ 889,75,0)

= VLOOKUP( A7, Data!$ A$ 6:$ BZ$ 889,76,0)

= VLOOKUP( A7, Data!$ A$ 6:$ BZ$ 889,77,0)

= VLOOKUP($ A7, Data!$ A$ 7:$ AP$ 889, 39,0)

February 14, 2003 7 of 187 Summary_ Final numeric. xls  Var Desc Record for the Final Metal Product and Machinery Rule 1 2 34 A B C D E F G H I VARIABLE DESCRIPTIONS FOR SUMMARY_ FINAL. XLS FINAL MP& M RULE FORMULA Long, Short, and Phase 1 Surveys Iron and Steel Surveys Railroad Surveys Municipality Surveys CBI VARIABLE DESCRIPTION WORKSHEET COLUMN 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 After Tax Compliance Cost as % of Post Compliance Revenue: CPR2 Annualized After Tax Compliance Cost as a percent of Post Compliance Revenue in Option 2 by_ Fac Y N = VLOOKUP($ A7, Data!$ A$ 7:$ AP$ 889, 40,0)

After Tax Compliance Cost as % of Post Compliance Revenue: CPR3 Annualized After Tax Compliance Cost as a percent of Post Compliance Revenue in Option 3 by_ Fac Z N = VLOOKUP($ A7, Data!$ A$ 7:$ AP$ 889, 41,0)

After Tax Compliance Cost as % of Post Compliance Revenue: CPR4 Annualized After Tax Compliance Cost as a percent of Post Compliance Revenue in Option 4 by_ Fac AA N = VLOOKUP($ A7, Data!$ A$ 7:$ AP$ 889, 42,0)

Range of ACC as % of PCR: SPB1 Range of Annualized After Tax Compliance Cost as a percent of Post Compliance Revenue in Option 1: 2 is greater than 3%; 1 is between 1 and 3%; 0 is less than 1% by_ Fac AB N = IF( X7>= 0.03,2, IF( X7>= 0.01,1, IF( X7> 0, 0,  1)))

Range of ACC as % of PCR: SPB2 Range of Annualized After Tax Compliance Cost as a percent of Post Compliance Revenue in Option 2: 2 is greater than 3%; 1 is between 1 and 3%; 0 is less than 1% by_ Fac AC N = IF( Y7>= 0.03,2, IF( Y7>= 0.01,1, IF( Y7> 0, 0,  1)))

Range of ACC as % of PCR: SPB3 Range of Annualized After Tax Compliance Cost as a percent of Post Compliance Revenue in Option 3: 2 is greater than 3%; 1 is between 1 and 3%; 0 is less than 1% by_ Fac AD N = IF( Z7>= 0.03,2, IF( Z7>= 0.01,1, IF( Z7> 0, 0,  1)))

Range of ACC as % of PCR: SPB4 Range of Annualized After Tax Compliance Cost as a percent of Post Compliance Revenue in Option 4: 2 is greater than 3%; 1 is between 1 and 3%; 0 is less than 1% by_ Fac AE N = IF( AA7>= 0.03,2, IF( AA7>= 0.01,1, IF( AA7> 0, 0,  1)))

Universe of Facilities Subject to Reg. Requirements: IsReg1 Is this facility subject to regulatory requirements in option 1? 0= no; 1= yes by_ Fac AF N = IF( T7=" reg", 1, IF( T7=" mod", 1, IF( T7=" reg close", 1, 0)))

Universe of Facilities Subject to Reg. Requirements: IsReg2 Is this facility subject to regulatory requirements in option 2? 0= no; 1= yes by_ Fac AG N = IF( U7=" reg", 1, IF( U7=" mod", 1, IF( U7=" reg close", 1, 0)))

Universe of Facilities Subject to Reg. Requirements: IsReg3 Is this facility subject to regulatory requirements in option 3? 0= no; 1= yes by_ Fac AH N = IF( V7=" reg", 1, IF( V7=" mod", 1, IF( V7=" reg close", 1, 0)))

Universe of Facilities Subject to Reg. Requirements: IsReg4 Is this facility subject to regulatory requirements in option 4? 0= no; 1= yes by_ Fac AI N = IF( W7=" reg", 1, IF( W7=" mod", 1, IF( W7=" reg close", 1, 0)))

Compliance Costs Sample Weighted Option 1 After Tax Compliance Cost in 2001$ by_ Fac AJ Y = VLOOKUP( A7, Data!$ A$ 7:$ CB$ 889, 21, 0) SiteID Survey ID Reg Facs B N Option 1 Is this facility subject to regulatory requirements in option 1? 0= no; 1= yes Reg Facs C N Option 2 Is this facility subject to regulatory requirements in option 2? 0= no; 1= yes Reg Facs D N = IF( X7>= 0.03,2, IF( X7>= 0.01,1, IF( X7> 0, 0,  1)))

= IF( Y7>= 0.03,2, IF( Y7>= 0.01,1, IF( Y7> 0, 0,  1)))

= IF( Z7>= 0.03,2, IF( Z7>= 0.01,1, IF( Z7> 0, 0,  1))) = VLOOKUP($ A7, Data!$ A$ 7:$ AP$ 889, 40,0)

= VLOOKUP($ A7, Data!$ A$ 7:$ AP$ 889, 41,0)

= IF( W7=" reg", 1, IF( W7=" mod", 1, IF( W7=" reg close", 1, 0)))

= VLOOKUP( A7, Data!$ A$ 7:$ CB$ 889, 21, 0) = IF( AA7>= 0.03,2, IF( AA7>= 0.01,1, IF( AA7> 0, 0,  1)))

= IF( T7=" reg", 1, IF( T7=" mod", 1, IF( T7=" reg close", 1, 0)))

= IF( U7=" reg", 1, IF( U7=" mod", 1, IF( U7=" reg close", 1, 0)))

= IF( V7=" reg", 1, IF( V7=" mod", 1, IF( V7=" reg close", 1, 0))) = VLOOKUP($ A7, Data!$ A$ 7:$ AP$ 889, 42,0)

February 14, 2003 8 of 187 Summary_ Final numeric. xls  Var Desc Record for the Final Metal Product and Machinery Rule 1 2 34 A B C D E F G H I VARIABLE DESCRIPTIONS FOR SUMMARY_ FINAL. XLS FINAL MP& M RULE FORMULA Long, Short, and Phase 1 Surveys Iron and Steel Surveys Railroad Surveys Municipality Surveys CBI VARIABLE DESCRIPTION WORKSHEET COLUMN 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 Option 3 Is this facility subject to regulatory requirements in option 3? 0= no; 1= yes Reg Facs E N Option 4 Is this facility subject to regulatory requirements in option 4? 0= no; 1= yes Reg Facs F N SiteID Survey ID Rmvls B N Weight Basic Option sample weighted removals Rmvls C Y Before Sample Weighting: Option 1 Option 1 sample facility removals Rmvls D Y Before Sample Weighting: Option 2 Option 2 sample facility removals Rmvls E Y Before Sample Weighting: Option 3 Option 3 sample facility removals Rmvls F Y Before Sample Weighting: Option 4 Option 4 sample facility removals Rmvls G Y Sample Weighted: Option 1 Option 1 sample weighted removals Rmvls H Y Sample Weighted: Option 2 Option 2 sample weighted removals Rmvls I Y Sample Weighted: Option 3 Option 3 sample weighted removals Rmvls J Y Sample Weighted: Option 4 Option 4 sample weighted removals Rmvls K Y crit* Criteria number Crit A N SID Survey ID Crit B N In Used to filter data Crit C N Weight Sample Weight Crit D N Sector Sector Crit E N Dir Discharge type: D= Direct; I= Indirect Crit F N Flow Flow Range: 0: <= 1 million gallons per year ( mgy); 1: 1 2 mgy; 2: 2 3 mgy; 3: 3 4 mgy; 4: 4 5 mgy; 5: 5 6.25 mgy; 6: over 6.25 mgy Crit G N Bus Is the site owned by a small entity? 0= No; 1= Yes; 2= Unclassified Crit H N FTE Number of employees Crit I N Revenue Site revenue Crit J N Base Is this site projected to be open in the baseline? 0= no; 1= yes Crit K N 1 Is this site projected to be open in the baseline but close under option 1? 0= no; 1= yes Crit L N 2 Is this site projected to be open in the baseline but close under option 2? 0= no; 1= yes Crit M N 3 Is this site projected to be open in the baseline but close under option 3? 0= no; 1= yes Crit N N 4 Is this site projected to be open in the baseline but close under option 4? 0= no; 1= yes Crit O N Pvt Is this site owned by a private firm or part of a municipality? 1= private; 0= government Crit P N Subcat Subcategory Crit Q N Reg1 Is this facility subject to regulatory requirements in option 1? 0= no; 1= yes Crit R N = K11/$ C11 = VLOOKUP( A11, Data!$ A$ 7:$ E$ 889,5,0)

= H11/$ C11 = I11/$ C11 = J11/$ C11 February 14, 2003 9 of 187 Summary_ Final numeric. xls  Var Desc Record for the Final Metal Product and Machinery Rule 1 2 34 A B C D E F G H I VARIABLE DESCRIPTIONS FOR SUMMARY_ FINAL. XLS FINAL MP& M RULE FORMULA Long, Short, and Phase 1 Surveys Iron and Steel Surveys Railroad Surveys Municipality Surveys CBI VARIABLE DESCRIPTION WORKSHEET COLUMN 153 154 155 Reg2 Is this facility subject to regulatory requirements in option 2? 0= no; 1= yes Crit S N Reg3 Is this facility subject to regulatory requirements in option 3? 0= no; 1= yes Crit T N Reg4 Is this facility subject to regulatory requirements in option 4? 0= no; 1= yes Crit U N February 14, 2003 10 of 187 Summary_ Final numeric. xls  Var Desc Record for the Final Metal Product and Machinery Rule 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 A B C D E F G Constants and Other Numeric Values PPI96 127.3 PPI for industrial commodities, 1996; http:// www. bls. gov/ ppi/ PPI97 127.7 PPI for industrial commodities, 1997; http:// www. bls. gov/ ppi/ PPI98 124.8 PPI for industrial commodities, 1998; http:// www. bls. gov/ ppi/ PPI99 126.5 PPI for industrial commodities, 1999; http:// www. bls. gov/ ppi/ PPI00 134.8 PPI for industrial commodities, 2000; http:// www. bls. gov/ ppi/ PPI01 135.7 PPI for industrial commodities, 2001; http:// www. bls. gov/ ppi/

CCI81 3535 Construction Cost Index, 1981  Annual Average ( http:// enr. construction. com/ cost/ costcci. asp) CCI96 5620 Construction Cost Index, 1996  Annual Average ( http:// enr. construction. com/ cost/ costcci. asp) CCI97 5825 Construction Cost Index, 1997  Annual Average ( http:// enr. construction. com/ cost/ costcci. asp) CCI98 5920 Construction Cost Index, 1998  Annual Average ( http:// enr. construction. com/ cost/ costcci. asp) CCI99 6060 Construction Cost Index, 1999  Annual Average ( http:// enr. construction. com/ cost/ costcci. asp) CCI00 6221 Construction Cost Index, 2000  Annual Average ( http:// enr. construction. com/ cost/ costcci. asp) CCI01 6342 Construction Cost Index, 2001  Annual Average ( http:// enr. construction. com/ cost/ costcci. asp)

Defl 1.128 Cost adjustment from 1996$ to 2001$ I& S_ Defl 1.089 Cost adjustment from 1997$ to 2001$ DeflCE 0.5574 Cost adjustment from 2001$ to 1981$