Record for the Final Metal Product and Machinery Rule 1 2 345 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 A B C D E MP& M Impacts and Removals by Subcategory, National Estimates = Data! A3 Bold'= Population Plain'= Closures All 1 MGY 2 MGY 3 MGY = Crit! S132 =+ R9 =+ S9+ D9 =+ T9+ E9 =+ U9+ F9 Option 1 =+ R10 =+ S10+ D10 =+ T10+ E10 =+ U10+ F10 Option 2 =+ R11 =+ S11+ D11 =+ T11+ E11 =+ U11+ F11 Option 3 =+ R12 =+ S12+ D12 =+ T12+ E12 =+ U12+ F12 Option 4 =+ R13 =+ S13+ D13 =+ T13+ E13 =+ U13+ F13 = Crit! S153 =+ R14 =+ S14+ D14 =+ T14+ E14 =+ U14+ F14 Option 1 =+ R15 =+ S15+ D15 =+ T15+ E15 =+ U15+ F15 Option 2 =+ R16 =+ S16+ D16 =+ T16+ E16 =+ U16+ F16 Option 3 =+ R17 =+ S17+ D17 =+ T17+ E17 =+ U17+ F17 Option 4 =+ R18 =+ S18+ D18 =+ T18+ E18 =+ U18+ F18 = Crit! S174 =+ R19 =+ S19+ D19 =+ T19+ E19 =+ U19+ F19 Option 1 =+ R20 =+ S20+ D20 =+ T20+ E20 =+ U20+ F20 Option 2 =+ R21 =+ S21+ D21 =+ T21+ E21 =+ U21+ F21 Option 3 =+ R22 =+ S22+ D22 =+ T22+ E22 =+ U22+ F22 Option 4 =+ R23 =+ S23+ D23 =+ T23+ E23 =+ U23+ F23 = Crit! S195 =+ R24 =+ S24+ D24 =+ T24+ E24 =+ U24+ F24 Option 1 =+ R25 =+ S25+ D25 =+ T25+ E25 =+ U25+ F25 Option 2 =+ R26 =+ S26+ D26 =+ T26+ E26 =+ U26+ F26 Option 3 =+ R27 =+ S27+ D27 =+ T27+ E27 =+ U27+ F27 Option 4 =+ R28 =+ S28+ D28 =+ T28+ E28 =+ U28+ F28 = Crit! S216 =+ R29 =+ S29+ D29 =+ T29+ E29 =+ U29+ F29 Option 1 =+ R30 =+ S30+ D30 =+ T30+ E30 =+ U30+ F30 Option 2 =+ R31 =+ S31+ D31 =+ T31+ E31 =+ U31+ F31 Option 3 =+ R32 =+ S32+ D32 =+ T32+ E32 =+ U32+ F32 Option 4 =+ R33 =+ S33+ D33 =+ T33+ E33 =+ U33+ F33 = Crit! S237 =+ R34 =+ S34+ D34 =+ T34+ E34 =+ U34+ F34 Option 1 =+ R35 =+ S35+ D35 =+ T35+ E35 =+ U35+ F35 Option 2 =+ R36 =+ S36+ D36 =+ T36+ E36 =+ U36+ F36 Option 3 =+ R37 =+ S37+ D37 =+ T37+ E37 =+ U37+ F37 Option 4 =+ R38 =+ S38+ D38 =+ T38+ E38 =+ U38+ F38 = Crit! S259 =+ R39 =+ S39+ D39 =+ T39+ E39 =+ U39+ F39 Option 1 =+ R40 =+ S40+ D40 =+ T40+ E40 =+ U40+ F40 Option 2 =+ R41 =+ S41+ D41 =+ T41+ E41 =+ U41+ F41 Option 3 =+ R42 =+ S42+ D42 =+ T42+ E42 =+ U42+ F42 Option 4 =+ R43 =+ S43+ D43 =+ T43+ E43 =+ U43+ F43 = Crit! S280 =+ R44 =+ S44+ D44 =+ T44+ E44 =+ U44+ F44 Option 1 =+ R45 =+ S45+ D45 =+ T45+ E45 =+ U45+ F45 Option 2 =+ R46 =+ S46+ D46 =+ T46+ E46 =+ U46+ F46 Option 3 =+ R47 =+ S47+ D47 =+ T47+ E47 =+ U47+ F47 Option 4 =+ R48 =+ S48+ D48 =+ T48+ E48 =+ U48+ F48 = Crit! S304 =+ R49 =+ S49+ D49 =+ T49+ E49 =+ U49+ F49 Option 1 =+ R50 =+ S50+ D50 =+ T50+ E50 =+ U50+ F50 Option 2 =+ R51 =+ S51+ D51 =+ T51+ E51 =+ U51+ F51 Option 3 =+ R52 =+ S52+ D52 =+ T52+ E52 =+ U52+ F52 Option 4 =+ R53 =+ S53+ D53 =+ T53+ E53 =+ U53+ F53 All Categories =+ R54 =+ S54+ D54 =+ T54+ E54 =+ U54+ F54 Option 1 =+ R55 =+ S55+ D55 =+ T55+ E55 =+ U55+ F55 Option 2 =+ R56 =+ S56+ D56 =+ T56+ E56 =+ U56+ F56 Option 3 =+ R57 =+ S57+ D57 =+ T57+ E57 =+ U57+ F57 Option 4 =+ R58 =+ S58+ D58 =+ T58+ E58 =+ U58+ F58 Severe Impacts ( Numbers of Closures) Flow Cutoff for Indirects

February 14, 2003 1 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 1 2 345 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 F G H I J K L 4 MGY 5 MGY 6.25 MGY All Rank 1 MGY 2 MGY =+ V9+ G9 =+ W9+ H9 =+ X9 =+ V10+ G10 =+ W10+ H10 =+ X10 =+ Y10 4 =+ Z10+ L10 =+ AA10+ M10 =+ V11+ G11 =+ W11+ H11 =+ X11 =+ Y11 3 =+ Z11+ L11 =+ AA11+ M11 =+ V12+ G12 =+ W12+ H12 =+ X12 =+ Y12 2 =+ Z12+ L12 =+ AA12+ M12 =+ V13+ G13 =+ W13+ H13 =+ X13 =+ Y13 1 =+ Z13+ L13 =+ AA13+ M13 =+ V14+ G14 =+ W14+ H14 =+ X14 =+ V15+ G15 =+ W15+ H15 =+ X15 =+ Y15 4 =+ Z15+ L15 =+ AA15+ M15 =+ V16+ G16 =+ W16+ H16 =+ X16 =+ Y16 3 =+ Z16+ L16 =+ AA16+ M16 =+ V17+ G17 =+ W17+ H17 =+ X17 =+ Y17 2 =+ Z17+ L17 =+ AA17+ M17 =+ V18+ G18 =+ W18+ H18 =+ X18 =+ Y18 1 =+ Z18+ L18 =+ AA18+ M18 =+ V19+ G19 =+ W19+ H19 =+ X19 =+ V20+ G20 =+ W20+ H20 =+ X20 =+ Y20 4 =+ Z20+ L20 =+ AA20+ M20 =+ V21+ G21 =+ W21+ H21 =+ X21 =+ Y21 3 =+ Z21+ L21 =+ AA21+ M21 =+ V22+ G22 =+ W22+ H22 =+ X22 =+ Y22 2 =+ Z22+ L22 =+ AA22+ M22 =+ V23+ G23 =+ W23+ H23 =+ X23 =+ Y23 1 =+ Z23+ L23 =+ AA23+ M23 =+ V24+ G24 =+ W24+ H24 =+ X24 =+ V25+ G25 =+ W25+ H25 =+ X25 =+ Y25 4 =+ Z25+ L25 =+ AA25+ M25 =+ V26+ G26 =+ W26+ H26 =+ X26 =+ Y26 3 =+ Z26+ L26 =+ AA26+ M26 =+ V27+ G27 =+ W27+ H27 =+ X27 =+ Y27 2 =+ Z27+ L27 =+ AA27+ M27 =+ V28+ G28 =+ W28+ H28 =+ X28 =+ Y28 1 =+ Z28+ L28 =+ AA28+ M28 =+ V29+ G29 =+ W29+ H29 =+ X29 =+ V30+ G30 =+ W30+ H30 =+ X30 =+ Y30 4 =+ Z30+ L30 =+ AA30+ M30 =+ V31+ G31 =+ W31+ H31 =+ X31 =+ Y31 3 =+ Z31+ L31 =+ AA31+ M31 =+ V32+ G32 =+ W32+ H32 =+ X32 =+ Y32 2 =+ Z32+ L32 =+ AA32+ M32 =+ V33+ G33 =+ W33+ H33 =+ X33 =+ Y33 1 =+ Z33+ L33 =+ AA33+ M33 =+ V34+ G34 =+ W34+ H34 =+ X34 =+ V35+ G35 =+ W35+ H35 =+ X35 =+ Y35 4 =+ Z35+ L35 =+ AA35+ M35 =+ V36+ G36 =+ W36+ H36 =+ X36 =+ Y36 3 =+ Z36+ L36 =+ AA36+ M36 =+ V37+ G37 =+ W37+ H37 =+ X37 =+ Y37 2 =+ Z37+ L37 =+ AA37+ M37 =+ V38+ G38 =+ W38+ H38 =+ X38 =+ Y38 1 =+ Z38+ L38 =+ AA38+ M38 =+ V39+ G39 =+ W39+ H39 =+ X39 =+ V40+ G40 =+ W40+ H40 =+ X40 =+ Y40 4 =+ Z40+ L40 =+ AA40+ M40 =+ V41+ G41 =+ W41+ H41 =+ X41 =+ Y41 3 =+ Z41+ L41 =+ AA41+ M41 =+ V42+ G42 =+ W42+ H42 =+ X42 =+ Y42 2 =+ Z42+ L42 =+ AA42+ M42 =+ V43+ G43 =+ W43+ H43 =+ X43 =+ Y43 1 =+ Z43+ L43 =+ AA43+ M43 =+ V44+ G44 =+ W44+ H44 =+ X44 =+ V45+ G45 =+ W45+ H45 =+ X45 =+ Y45 4 =+ Z45+ L45 =+ AA45+ M45 =+ V46+ G46 =+ W46+ H46 =+ X46 =+ Y46 3 =+ Z46+ L46 =+ AA46+ M46 =+ V47+ G47 =+ W47+ H47 =+ X47 =+ Y47 2 =+ Z47+ L47 =+ AA47+ M47 =+ V48+ G48 =+ W48+ H48 =+ X48 =+ Y48 1 =+ Z48+ L48 =+ AA48+ M48 =+ V49+ G49 =+ W49+ H49 =+ X49 =+ V50+ G50 =+ W50+ H50 =+ X50 =+ Y50 4 =+ Z50+ L50 =+ AA50+ M50 =+ V51+ G51 =+ W51+ H51 =+ X51 =+ Y51 3 =+ Z51+ L51 =+ AA51+ M51 =+ V52+ G52 =+ W52+ H52 =+ X52 =+ Y52 2 =+ Z52+ L52 =+ AA52+ M52 =+ V53+ G53 =+ W53+ H53 =+ X53 =+ Y53 1 =+ Z53+ L53 =+ AA53+ M53 =+ V54+ G54 =+ W54+ H54 =+ X54 =+ V55+ G55 =+ W55+ H55 =+ X55 =+ Y55 4 =+ Z55+ L55 =+ AA55+ M55 =+ V56+ G56 =+ W56+ H56 =+ X56 =+ Y56 3 =+ Z56+ L56 =+ AA56+ M56 =+ V57+ G57 =+ W57+ H57 =+ X57 =+ Y57 2 =+ Z57+ L57 =+ AA57+ M57 =+ V58+ G58 =+ W58+ H58 =+ X58 =+ Y58 1 =+ Z58+ L58 =+ AA58+ M58 Numbers of Closures) Flow Cutoff for Indirects  Removals ( Pounds Equivalent) Flow Cutoff for Indirects

February 14, 2003 2 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 1 2 345 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 M N O P Q R S NONCUMULATIVE 3 MGY 4 MGY 5 MGY 6.25 MGY All 1 MGY = DSUM( Data," Weight", Crit49) = DSUM( Data," Weight", Crit50) =+ AB10+ N10 =+ AC10+ O10 =+ AD10+ P10 =+ AE10 1 = DSUM( Data," W1", Crit49) = DSUM( Data," W1", Crit50) =+ AB11+ N11 =+ AC11+ O11 =+ AD11+ P11 =+ AE11 2 = DSUM( Data," W2", Crit49) = DSUM( Data," W2", Crit50) =+ AB12+ N12 =+ AC12+ O12 =+ AD12+ P12 =+ AE12 3 = DSUM( Data," W3", Crit49) = DSUM( Data," W3", Crit50) =+ AB13+ N13 =+ AC13+ O13 =+ AD13+ P13 =+ AE13 4 = DSUM( Data," W4", Crit49) = DSUM( Data," W4", Crit50) = DSUM( Data," Weight", Crit53) = DSUM( Data," Weight", Crit54) =+ AB15+ N15 =+ AC15+ O15 =+ AD15+ P15 =+ AE15 1 = DSUM( Data," W1", Crit53) = DSUM( Data," W1", Crit54) =+ AB16+ N16 =+ AC16+ O16 =+ AD16+ P16 =+ AE16 2 = DSUM( Data," W2", Crit53) = DSUM( Data," W2", Crit54) =+ AB17+ N17 =+ AC17+ O17 =+ AD17+ P17 =+ AE17 3 = DSUM( Data," W3", Crit53) = DSUM( Data," W3", Crit54) =+ AB18+ N18 =+ AC18+ O18 =+ AD18+ P18 =+ AE18 4 = DSUM( Data," W4", Crit53) = DSUM( Data," W4", Crit54) = DSUM( Data," Weight", Crit57) = DSUM( Data," Weight", Crit58) =+ AB20+ N20 =+ AC20+ O20 =+ AD20+ P20 =+ AE20 1 = DSUM( Data," W1", Crit57) = DSUM( Data," W1", Crit58) =+ AB21+ N21 =+ AC21+ O21 =+ AD21+ P21 =+ AE21 2 = DSUM( Data," W2", Crit57) = DSUM( Data," W2", Crit58) =+ AB22+ N22 =+ AC22+ O22 =+ AD22+ P22 =+ AE22 3 = DSUM( Data," W3", Crit57) = DSUM( Data," W3", Crit58) =+ AB23+ N23 =+ AC23+ O23 =+ AD23+ P23 =+ AE23 4 = DSUM( Data," W4", Crit57) = DSUM( Data," W4", Crit58) = DSUM( Data," Weight", Crit61) = DSUM( Data," Weight", Crit62) =+ AB25+ N25 =+ AC25+ O25 =+ AD25+ P25 =+ AE25 1 = DSUM( Data," W1", Crit61) = DSUM( Data," W1", Crit62) =+ AB26+ N26 =+ AC26+ O26 =+ AD26+ P26 =+ AE26 2 = DSUM( Data," W2", Crit61) = DSUM( Data," W2", Crit62) =+ AB27+ N27 =+ AC27+ O27 =+ AD27+ P27 =+ AE27 3 = DSUM( Data," W3", Crit61) = DSUM( Data," W3", Crit62) =+ AB28+ N28 =+ AC28+ O28 =+ AD28+ P28 =+ AE28 4 = DSUM( Data," W4", Crit61) = DSUM( Data," W4", Crit62) = DSUM( Data," Weight", Crit65) = DSUM( Data," Weight", Crit66) =+ AB30+ N30 =+ AC30+ O30 =+ AD30+ P30 =+ AE30 1 = DSUM( Data," W1", Crit65) = DSUM( Data," W1", Crit66) =+ AB31+ N31 =+ AC31+ O31 =+ AD31+ P31 =+ AE31 2 = DSUM( Data," W2", Crit65) = DSUM( Data," W2", Crit66) =+ AB32+ N32 =+ AC32+ O32 =+ AD32+ P32 =+ AE32 3 = DSUM( Data," W3", Crit65) = DSUM( Data," W3", Crit66) =+ AB33+ N33 =+ AC33+ O33 =+ AD33+ P33 =+ AE33 4 = DSUM( Data," W4", Crit65) = DSUM( Data," W4", Crit66) = DSUM( Data," Weight", Crit69) = DSUM( Data," Weight", Crit70) =+ AB35+ N35 =+ AC35+ O35 =+ AD35+ P35 =+ AE35 1 = DSUM( Data," W1", Crit69) = DSUM( Data," W1", Crit70) =+ AB36+ N36 =+ AC36+ O36 =+ AD36+ P36 =+ AE36 2 = DSUM( Data," W2", Crit69) = DSUM( Data," W2", Crit70) =+ AB37+ N37 =+ AC37+ O37 =+ AD37+ P37 =+ AE37 3 = DSUM( Data," W3", Crit69) = DSUM( Data," W3", Crit70) =+ AB38+ N38 =+ AC38+ O38 =+ AD38+ P38 =+ AE38 4 = DSUM( Data," W4", Crit69) = DSUM( Data," W4", Crit70) = DSUM( Data," Weight", Crit73) = DSUM( Data," Weight", Crit74) =+ AB40+ N40 =+ AC40+ O40 =+ AD40+ P40 =+ AE40 1 = DSUM( Data," W1", Crit73) = DSUM( Data," W1", Crit74) =+ AB41+ N41 =+ AC41+ O41 =+ AD41+ P41 =+ AE41 2 = DSUM( Data," W2", Crit73) = DSUM( Data," W2", Crit74) =+ AB42+ N42 =+ AC42+ O42 =+ AD42+ P42 =+ AE42 3 = DSUM( Data," W3", Crit73) = DSUM( Data," W3", Crit74) =+ AB43+ N43 =+ AC43+ O43 =+ AD43+ P43 =+ AE43 4 = DSUM( Data," W4", Crit73) = DSUM( Data," W4", Crit74) = DSUM( Data," Weight", Crit77) = DSUM( Data," Weight", Crit78) =+ AB45+ N45 =+ AC45+ O45 =+ AD45+ P45 =+ AE45 1 = DSUM( Data," W1", Crit77) = DSUM( Data," W1", Crit78) =+ AB46+ N46 =+ AC46+ O46 =+ AD46+ P46 =+ AE46 2 = DSUM( Data," W2", Crit77) = DSUM( Data," W2", Crit78) =+ AB47+ N47 =+ AC47+ O47 =+ AD47+ P47 =+ AE47 3 = DSUM( Data," W3", Crit77) = DSUM( Data," W3", Crit78) =+ AB48+ N48 =+ AC48+ O48 =+ AD48+ P48 =+ AE48 4 = DSUM( Data," W4", Crit77) = DSUM( Data," W4", Crit78) = DSUM( Data," Weight", crit82) = DSUM( Data," Weight", crit83) =+ AB50+ N50 =+ AC50+ O50 =+ AD50+ P50 =+ AE50 1 = DSUM( Data," W1", crit82) = DSUM( Data," W1", crit83) =+ AB51+ N51 =+ AC51+ O51 =+ AD51+ P51 =+ AE51 2 = DSUM( Data," W2", crit82) = DSUM( Data," W2", crit83) =+ AB52+ N52 =+ AC52+ O52 =+ AD52+ P52 =+ AE52 3 = DSUM( Data," W3", crit82) = DSUM( Data," W3", crit83) =+ AB53+ N53 =+ AC53+ O53 =+ AD53+ P53 =+ AE53 4 = DSUM( Data," W4", crit82) = DSUM( Data," W4", crit83) = R49+ R44+ R39+ R34+ R29+ R24+ R19+ R14+ R9 = S49+ S44+ S39+ S34+ S29+ S24+ S19+ S14+ S9 =+ AB55+ N55 =+ AC55+ O55 =+ AD55+ P55 =+ AE55 1 = R50+ R45+ R40+ R35+ R30+ R25+ R20+ R15+ R10 = S50+ S45+ S40+ S35+ S30+ S25+ S20+ S15+ S10 =+ AB56+ N56 =+ AC56+ O56 =+ AD56+ P56 =+ AE56 2 = R51+ R46+ R41+ R36+ R31+ R26+ R21+ R16+ R11 = S51+ S46+ S41+ S36+ S31+ S26+ S21+ S16+ S11 =+ AB57+ N57 =+ AC57+ O57 =+ AD57+ P57 =+ AE57 3 = R52+ R47+ R42+ R37+ R32+ R27+ R22+ R17+ R12 = S52+ S47+ S42+ S37+ S32+ S27+ S22+ S17+ S12 =+ AB58+ N58 =+ AC58+ O58 =+ AD58+ P58 =+ AE58 4 = R53+ R48+ R43+ R38+ R33+ R28+ R23+ R18+ R13 = S53+ S48+ S43+ S38+ S33+ S28+ S23+ S18+ S13 Pounds Equivalent) Flow Cutoff for Indirects

February 14, 2003 3 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 1 2 345 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 T U V 2 MGY 3 MGY 4 MGY = DSUM( Data," Weight", Crit50a) = DSUM( Data," Weight", Crit51) = DSUM( Data," Weight", Crit51a) = DSUM( Data," W1", Crit50a) = DSUM( Data," W1", Crit51) = DSUM( Data," W1", Crit51a) = DSUM( Data," W2", Crit50a) = DSUM( Data," W2", Crit51) = DSUM( Data," W2", Crit51a) = DSUM( Data," W3", Crit50a) = DSUM( Data," W3", Crit51) = DSUM( Data," W3", Crit51a) = DSUM( Data," W4", Crit50a) = DSUM( Data," W4", Crit51) = DSUM( Data," W4", Crit51a) = DSUM( Data," Weight", Crit54a) = DSUM( Data," Weight", Crit55) = DSUM( Data," Weight", Crit55a) = DSUM( Data," W1", Crit54a) = DSUM( Data," W1", Crit55) = DSUM( Data," W1", Crit55a) = DSUM( Data," W2", Crit54a) = DSUM( Data," W2", Crit55) = DSUM( Data," W2", Crit55a) = DSUM( Data," W3", Crit54a) = DSUM( Data," W3", Crit55) = DSUM( Data," W3", Crit55a) = DSUM( Data," W4", Crit54a) = DSUM( Data," W4", Crit55) = DSUM( Data," W4", Crit55a) = DSUM( Data," Weight", Crit58a) = DSUM( Data," Weight", Crit59) = DSUM( Data," Weight", Crit59a) = DSUM( Data," W1", Crit58a) = DSUM( Data," W1", Crit59) = DSUM( Data," W1", Crit59a) = DSUM( Data," W2", Crit58a) = DSUM( Data," W2", Crit59) = DSUM( Data," W2", Crit59a) = DSUM( Data," W3", Crit58a) = DSUM( Data," W3", Crit59) = DSUM( Data," W3", Crit59a) = DSUM( Data," W4", Crit58a) = DSUM( Data," W4", Crit59) = DSUM( Data," W4", Crit59a) = DSUM( Data," Weight", Crit62a) = DSUM( Data," Weight", Crit63) = DSUM( Data," Weight", Crit63a) = DSUM( Data," W1", Crit62a) = DSUM( Data," W1", Crit63) = DSUM( Data," W1", Crit63a) = DSUM( Data," W2", Crit62a) = DSUM( Data," W2", Crit63) = DSUM( Data," W2", Crit63a) = DSUM( Data," W3", Crit62a) = DSUM( Data," W3", Crit63) = DSUM( Data," W3", Crit63a) = DSUM( Data," W4", Crit62a) = DSUM( Data," W4", Crit63) = DSUM( Data," W4", Crit63a) = DSUM( Data," Weight", Crit66a) = DSUM( Data," Weight", Crit67) = DSUM( Data," Weight", Crit67a) = DSUM( Data," W1", Crit66a) = DSUM( Data," W1", Crit67) = DSUM( Data," W1", Crit67a) = DSUM( Data," W2", Crit66a) = DSUM( Data," W2", Crit67) = DSUM( Data," W2", Crit67a) = DSUM( Data," W3", Crit66a) = DSUM( Data," W3", Crit67) = DSUM( Data," W3", Crit67a) = DSUM( Data," W4", Crit66a) = DSUM( Data," W4", Crit67) = DSUM( Data," W4", Crit67a) = DSUM( Data," Weight", Crit70a) = DSUM( Data," Weight", Crit71) = DSUM( Data," Weight", Crit71a) = DSUM( Data," W1", Crit70a) = DSUM( Data," W1", Crit71) = DSUM( Data," W1", Crit71a) = DSUM( Data," W2", Crit70a) = DSUM( Data," W2", Crit71) = DSUM( Data," W2", Crit71a) = DSUM( Data," W3", Crit70a) = DSUM( Data," W3", Crit71) = DSUM( Data," W3", Crit71a) = DSUM( Data," W4", Crit70a) = DSUM( Data," W4", Crit71) = DSUM( Data," W4", Crit71a) = DSUM( Data," Weight", Crit74a) = DSUM( Data," Weight", Crit75) = DSUM( Data," Weight", Crit75a) = DSUM( Data," W1", Crit74a) = DSUM( Data," W1", Crit75) = DSUM( Data," W1", Crit75a) = DSUM( Data," W2", Crit74a) = DSUM( Data," W2", Crit75) = DSUM( Data," W2", Crit75a) = DSUM( Data," W3", Crit74a) = DSUM( Data," W3", Crit75) = DSUM( Data," W3", Crit75a) = DSUM( Data," W4", Crit74a) = DSUM( Data," W4", Crit75) = DSUM( Data," W4", Crit75a) = DSUM( Data," Weight", Crit78a) = DSUM( Data," Weight", Crit79) = DSUM( Data," Weight", Crit79a) = DSUM( Data," W1", Crit78a) = DSUM( Data," W1", Crit79) = DSUM( Data," W1", Crit79a) = DSUM( Data," W2", Crit78a) = DSUM( Data," W2", Crit79) = DSUM( Data," W2", Crit79a) = DSUM( Data," W3", Crit78a) = DSUM( Data," W3", Crit79) = DSUM( Data," W3", Crit79a) = DSUM( Data," W4", Crit78a) = DSUM( Data," W4", Crit79) = DSUM( Data," W4", Crit79a) = DSUM( Data," Weight", crit84) = DSUM( Data," Weight", crit85) = DSUM( Data," Weight", crit86) = DSUM( Data," W1", crit84) = DSUM( Data," W1", crit85) = DSUM( Data," W1", crit86) = DSUM( Data," W2", crit84) = DSUM( Data," W2", crit85) = DSUM( Data," W2", crit86) = DSUM( Data," W3", crit84) = DSUM( Data," W3", crit85) = DSUM( Data," W3", crit86) = DSUM( Data," W4", crit84) = DSUM( Data," W4", crit85) = DSUM( Data," W4", crit86) = T49+ T44+ T39+ T34+ T29+ T24+ T19+ T14+ T9 = U49+ U44+ U39+ U34+ U29+ U24+ U19+ U14+ U9 = V49+ V44+ V39+ V34+ V29+ V24+ V19+ V14+ V9 = T50+ T45+ T40+ T35+ T30+ T25+ T20+ T15+ T10 = U50+ U45+ U40+ U35+ U30+ U25+ U20+ U15+ U10 = V50+ V45+ V40+ V35+ V30+ V25+ V20+ V15+ V10 = T51+ T46+ T41+ T36+ T31+ T26+ T21+ T16+ T11 = U51+ U46+ U41+ U36+ U31+ U26+ U21+ U16+ U11 = V51+ V46+ V41+ V36+ V31+ V26+ V21+ V16+ V11 = T52+ T47+ T42+ T37+ T32+ T27+ T22+ T17+ T12 = U52+ U47+ U42+ U37+ U32+ U27+ U22+ U17+ U12 = V52+ V47+ V42+ V37+ V32+ V27+ V22+ V17+ V12 = T53+ T48+ T43+ T38+ T33+ T28+ T23+ T18+ T13 = U53+ U48+ U43+ U38+ U33+ U28+ U23+ U18+ U13 = V53+ V48+ V43+ V38+ V33+ V28+ V23+ V18+ V13 Flow Size for Indirects  Severe Impacts February 14, 2003 4 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 1 2 345 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 W X Y 5 MGY 6.25 MGY All = DSUM( Data," Weight", Crit51b) = DSUM( Data," Weight", Crit52) = DSUM( Data," W1", Crit51b) = DSUM( Data," W1", Crit52) = DSUM( Data," WR1", Crit49) = DSUM( Data," W2", Crit51b) = DSUM( Data," W2", Crit52) = DSUM( Data," WR2", Crit49) = DSUM( Data," W3", Crit51b) = DSUM( Data," W3", Crit52) = DSUM( Data," WR3", Crit49) = DSUM( Data," W4", Crit51b) = DSUM( Data," W4", Crit52) = DSUM( Data," WR4", Crit49) = DSUM( Data," Weight", Crit55b) = DSUM( Data," Weight", Crit56) = DSUM( Data," W1", Crit55b) = DSUM( Data," W1", Crit56) = DSUM( Data," WR1", Crit53) = DSUM( Data," W2", Crit55b) = DSUM( Data," W2", Crit56) = DSUM( Data," WR2", Crit53) = DSUM( Data," W3", Crit55b) = DSUM( Data," W3", Crit56) = DSUM( Data," WR3", Crit53) = DSUM( Data," W4", Crit55b) = DSUM( Data," W4", Crit56) = DSUM( Data," WR4", Crit53) = DSUM( Data," Weight", Crit59b) = DSUM( Data," Weight", Crit60) = DSUM( Data," W1", Crit59b) = DSUM( Data," W1", Crit60) = DSUM( Data," WR1", Crit57) = DSUM( Data," W2", Crit59b) = DSUM( Data," W2", Crit60) = DSUM( Data," WR2", Crit57) = DSUM( Data," W3", Crit59b) = DSUM( Data," W3", Crit60) = DSUM( Data," WR3", Crit57) = DSUM( Data," W4", Crit59b) = DSUM( Data," W4", Crit60) = DSUM( Data," WR4", Crit57) = DSUM( Data," Weight", Crit63b) = DSUM( Data," Weight", Crit64) = DSUM( Data," W1", Crit63b) = DSUM( Data," W1", Crit64) = DSUM( Data," WR1", Crit61) = DSUM( Data," W2", Crit63b) = DSUM( Data," W2", Crit64) = DSUM( Data," WR2", Crit61) = DSUM( Data," W3", Crit63b) = DSUM( Data," W3", Crit64) = DSUM( Data," WR3", Crit61) = DSUM( Data," W4", Crit63b) = DSUM( Data," W4", Crit64) = DSUM( Data," WR4", Crit61) = DSUM( Data," Weight", Crit67b) = DSUM( Data," Weight", Crit68) = DSUM( Data," W1", Crit67b) = DSUM( Data," W1", Crit68) = DSUM( Data," WR1", Crit65) = DSUM( Data," W2", Crit67b) = DSUM( Data," W2", Crit68) = DSUM( Data," WR2", Crit65) = DSUM( Data," W3", Crit67b) = DSUM( Data," W3", Crit68) = DSUM( Data," WR3", Crit65) = DSUM( Data," W4", Crit67b) = DSUM( Data," W4", Crit68) = DSUM( Data," WR4", Crit65) = DSUM( Data," Weight", Crit71b) = DSUM( Data," Weight", Crit72) = DSUM( Data," W1", Crit71b) = DSUM( Data," W1", Crit72) = DSUM( Data," WR1", Crit69) = DSUM( Data," W2", Crit71b) = DSUM( Data," W2", Crit72) = DSUM( Data," WR2", Crit69) = DSUM( Data," W3", Crit71b) = DSUM( Data," W3", Crit72) = DSUM( Data," WR3", Crit69) = DSUM( Data," W4", Crit71b) = DSUM( Data," W4", Crit72) = DSUM( Data," WR4", Crit69) = DSUM( Data," Weight", Crit75b) = DSUM( Data," Weight", Crit76) = DSUM( Data," W1", Crit75b) = DSUM( Data," W1", Crit76) = DSUM( Data," WR1", Crit73) = DSUM( Data," W2", Crit75b) = DSUM( Data," W2", Crit76) = DSUM( Data," WR2", Crit73) = DSUM( Data," W3", Crit75b) = DSUM( Data," W3", Crit76) = DSUM( Data," WR3", Crit73) = DSUM( Data," W4", Crit75b) = DSUM( Data," W4", Crit76) = DSUM( Data," WR4", Crit73) = DSUM( Data," Weight", Crit79b) = DSUM( Data," Weight", Crit80) = DSUM( Data," W1", Crit79b) = DSUM( Data," W1", Crit80) = DSUM( Data," WR1", Crit77) = DSUM( Data," W2", Crit79b) = DSUM( Data," W2", Crit80) = DSUM( Data," WR2", Crit77) = DSUM( Data," W3", Crit79b) = DSUM( Data," W3", Crit80) = DSUM( Data," WR3", Crit77) = DSUM( Data," W4", Crit79b) = DSUM( Data," W4", Crit80) = DSUM( Data," WR4", Crit77) = DSUM( Data," Weight", crit87) = DSUM( Data," Weight", crit88) = DSUM( Data," W1", crit87) = DSUM( Data," W1", crit88) = DSUM( Data," WR1", crit82) = DSUM( Data," W2", crit87) = DSUM( Data," W2", crit88) = DSUM( Data," WR2", crit82) = DSUM( Data," W3", crit87) = DSUM( Data," W3", crit88) = DSUM( Data," WR3", crit82) = DSUM( Data," W4", crit87) = DSUM( Data," W4", crit88) = DSUM( Data," WR4", crit82) = W49+ W44+ W39+ W34+ W29+ W24+ W19+ W14+ W9 = X49+ X44+ X39+ X34+ X29+ X24+ X19+ X14+ X9 = W50+ W45+ W40+ W35+ W30+ W25+ W20+ W15+ W10 = X50+ X45+ X40+ X35+ X30+ X25+ X20+ X15+ X10 = Y50+ Y45+ Y40+ Y35+ Y30+ Y25+ Y20+ Y15+ Y10 = W51+ W46+ W41+ W36+ W31+ W26+ W21+ W16+ W11 = X51+ X46+ X41+ X36+ X31+ X26+ X21+ X16+ X11 = Y51+ Y46+ Y41+ Y36+ Y31+ Y26+ Y21+ Y16+ Y11 = W52+ W47+ W42+ W37+ W32+ W27+ W22+ W17+ W12 = X52+ X47+ X42+ X37+ X32+ X27+ X22+ X17+ X12 = Y52+ Y47+ Y42+ Y37+ Y32+ Y27+ Y22+ Y17+ Y12 = W53+ W48+ W43+ W38+ W33+ W28+ W23+ W18+ W13 = X53+ X48+ X43+ X38+ X33+ X28+ X23+ X18+ X13 = Y53+ Y48+ Y43+ Y38+ Y33+ Y28+ Y23+ Y18+ Y13 February 14, 2003 5 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 1 2 345 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Z AA AB 1 MGY 2 MGY 3 MGY = DSUM( Data," WR1", Crit50) = DSUM( Data," WR1", Crit50a) = DSUM( Data," WR1", Crit51) = DSUM( Data," WR2", Crit50) = DSUM( Data," WR2", Crit50a) = DSUM( Data," WR2", Crit51) = DSUM( Data," WR3", Crit50) = DSUM( Data," WR3", Crit50a) = DSUM( Data," WR3", Crit51) = DSUM( Data," WR4", Crit50) = DSUM( Data," WR4", Crit50a) = DSUM( Data," WR4", Crit51)

= DSUM( Data," WR1", Crit54) = DSUM( Data," WR1", Crit54a) = DSUM( Data," WR1", Crit55) = DSUM( Data," WR2", Crit54) = DSUM( Data," WR2", Crit54a) = DSUM( Data," WR2", Crit55) = DSUM( Data," WR3", Crit54) = DSUM( Data," WR3", Crit54a) = DSUM( Data," WR3", Crit55) = DSUM( Data," WR4", Crit54) = DSUM( Data," WR4", Crit54a) = DSUM( Data," WR4", Crit55)

= DSUM( Data," WR1", Crit58) = DSUM( Data," WR1", Crit58a) = DSUM( Data," WR1", Crit59) = DSUM( Data," WR2", Crit58) = DSUM( Data," WR2", Crit58a) = DSUM( Data," WR2", Crit59) = DSUM( Data," WR3", Crit58) = DSUM( Data," WR3", Crit58a) = DSUM( Data," WR3", Crit59) = DSUM( Data," WR4", Crit58) = DSUM( Data," WR4", Crit58a) = DSUM( Data," WR4", Crit59)

= DSUM( Data," WR1", Crit62) = DSUM( Data," WR1", Crit62a) = DSUM( Data," WR1", Crit63) = DSUM( Data," WR2", Crit62) = DSUM( Data," WR2", Crit62a) = DSUM( Data," WR2", Crit63) = DSUM( Data," WR3", Crit62) = DSUM( Data," WR3", Crit62a) = DSUM( Data," WR3", Crit63) = DSUM( Data," WR4", Crit62) = DSUM( Data," WR4", Crit62a) = DSUM( Data," WR4", Crit63)

= DSUM( Data," WR1", Crit66) = DSUM( Data," WR1", Crit66a) = DSUM( Data," WR1", Crit67) = DSUM( Data," WR2", Crit66) = DSUM( Data," WR2", Crit66a) = DSUM( Data," WR2", Crit67) = DSUM( Data," WR3", Crit66) = DSUM( Data," WR3", Crit66a) = DSUM( Data," WR3", Crit67) = DSUM( Data," WR4", Crit66) = DSUM( Data," WR4", Crit66a) = DSUM( Data," WR4", Crit67)

= DSUM( Data," WR1", Crit70) = DSUM( Data," WR1", Crit70a) = DSUM( Data," WR1", Crit71) = DSUM( Data," WR2", Crit70) = DSUM( Data," WR2", Crit70a) = DSUM( Data," WR2", Crit71) = DSUM( Data," WR3", Crit70) = DSUM( Data," WR3", Crit70a) = DSUM( Data," WR3", Crit71) = DSUM( Data," WR4", Crit70) = DSUM( Data," WR4", Crit70a) = DSUM( Data," WR4", Crit71)

= DSUM( Data," WR1", Crit74) = DSUM( Data," WR1", Crit74a) = DSUM( Data," WR1", Crit75) = DSUM( Data," WR2", Crit74) = DSUM( Data," WR2", Crit74a) = DSUM( Data," WR2", Crit75) = DSUM( Data," WR3", Crit74) = DSUM( Data," WR3", Crit74a) = DSUM( Data," WR3", Crit75) = DSUM( Data," WR4", Crit74) = DSUM( Data," WR4", Crit74a) = DSUM( Data," WR4", Crit75)

= DSUM( Data," WR1", Crit78) = DSUM( Data," WR1", Crit78a) = DSUM( Data," WR1", Crit79) = DSUM( Data," WR2", Crit78) = DSUM( Data," WR2", Crit78a) = DSUM( Data," WR2", Crit79) = DSUM( Data," WR3", Crit78) = DSUM( Data," WR3", Crit78a) = DSUM( Data," WR3", Crit79) = DSUM( Data," WR4", Crit78) = DSUM( Data," WR4", Crit78a) = DSUM( Data," WR4", Crit79)

= DSUM( Data," WR1", crit83) = DSUM( Data," WR1", crit84) = DSUM( Data," WR1", crit85) = DSUM( Data," WR2", crit83) = DSUM( Data," WR2", crit84) = DSUM( Data," WR2", crit85) = DSUM( Data," WR3", crit83) = DSUM( Data," WR3", crit84) = DSUM( Data," WR3", crit85) = DSUM( Data," WR4", crit83) = DSUM( Data," WR4", crit84) = DSUM( Data," WR4", crit85)

= Z50+ Z45+ Z40+ Z35+ Z30+ Z25+ Z20+ Z15+ Z10 = AA50+ AA45+ AA40+ AA35+ AA30+ AA25+ AA20+ AA15+ AA10 = AB50+ AB45+ AB40+ AB35+ AB30+ AB25+ AB20+ AB15+ AB10 = Z51+ Z46+ Z41+ Z36+ Z31+ Z26+ Z21+ Z16+ Z11 = AA51+ AA46+ AA41+ AA36+ AA31+ AA26+ AA21+ AA16+ AA11 = AB51+ AB46+ AB41+ AB36+ AB31+ AB26+ AB21+ AB16+ AB11 = Z52+ Z47+ Z42+ Z37+ Z32+ Z27+ Z22+ Z17+ Z12 = AA52+ AA47+ AA42+ AA37+ AA32+ AA27+ AA22+ AA17+ AA12 = AB52+ AB47+ AB42+ AB37+ AB32+ AB27+ AB22+ AB17+ AB12 = Z53+ Z48+ Z43+ Z38+ Z33+ Z28+ Z23+ Z18+ Z13 = AA53+ AA48+ AA43+ AA38+ AA33+ AA28+ AA23+ AA18+ AA13 = AB53+ AB48+ AB43+ AB38+ AB33+ AB28+ AB23+ AB18+ AB13 Flow Size for Indirects  Removals February 14, 2003 6 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 1 2 345 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 AC AD AE 4 MGY 5 MGY 6.25 MGY = DSUM( Data," WR1", Crit51a) = DSUM( Data," WR1", Crit51b) = DSUM( Data," WR1", Crit52) = DSUM( Data," WR2", Crit51a) = DSUM( Data," WR2", Crit51b) = DSUM( Data," WR2", Crit52) = DSUM( Data," WR3", Crit51a) = DSUM( Data," WR3", Crit51b) = DSUM( Data," WR3", Crit52) = DSUM( Data," WR4", Crit51a) = DSUM( Data," WR4", Crit51b) = DSUM( Data," WR4", Crit52)

= DSUM( Data," WR1", Crit55a) = DSUM( Data," WR1", Crit55b) = DSUM( Data," WR1", Crit56) = DSUM( Data," WR2", Crit55a) = DSUM( Data," WR2", Crit55b) = DSUM( Data," WR2", Crit56) = DSUM( Data," WR3", Crit55a) = DSUM( Data," WR3", Crit55b) = DSUM( Data," WR3", Crit56) = DSUM( Data," WR4", Crit55a) = DSUM( Data," WR4", Crit55b) = DSUM( Data," WR4", Crit56)

= DSUM( Data," WR1", Crit59a) = DSUM( Data," WR1", Crit59b) = DSUM( Data," WR1", Crit60) = DSUM( Data," WR2", Crit59a) = DSUM( Data," WR2", Crit59b) = DSUM( Data," WR2", Crit60) = DSUM( Data," WR3", Crit59a) = DSUM( Data," WR3", Crit59b) = DSUM( Data," WR3", Crit60) = DSUM( Data," WR4", Crit59a) = DSUM( Data," WR4", Crit59b) = DSUM( Data," WR4", Crit60)

= DSUM( Data," WR1", Crit63a) = DSUM( Data," WR1", Crit63b) = DSUM( Data," WR1", Crit64) = DSUM( Data," WR2", Crit63a) = DSUM( Data," WR2", Crit63b) = DSUM( Data," WR2", Crit64) = DSUM( Data," WR3", Crit63a) = DSUM( Data," WR3", Crit63b) = DSUM( Data," WR3", Crit64) = DSUM( Data," WR4", Crit63a) = DSUM( Data," WR4", Crit63b) = DSUM( Data," WR4", Crit64)

= DSUM( Data," WR1", Crit67a) = DSUM( Data," WR1", Crit67b) = DSUM( Data," WR1", Crit68) = DSUM( Data," WR2", Crit67a) = DSUM( Data," WR2", Crit67b) = DSUM( Data," WR2", Crit68) = DSUM( Data," WR3", Crit67a) = DSUM( Data," WR3", Crit67b) = DSUM( Data," WR3", Crit68) = DSUM( Data," WR4", Crit67a) = DSUM( Data," WR4", Crit67b) = DSUM( Data," WR4", Crit68)

= DSUM( Data," WR1", Crit71a) = DSUM( Data," WR1", Crit71b) = DSUM( Data," WR1", Crit72) = DSUM( Data," WR2", Crit71a) = DSUM( Data," WR2", Crit71b) = DSUM( Data," WR2", Crit72) = DSUM( Data," WR3", Crit71a) = DSUM( Data," WR3", Crit71b) = DSUM( Data," WR3", Crit72) = DSUM( Data," WR4", Crit71a) = DSUM( Data," WR4", Crit71b) = DSUM( Data," WR4", Crit72)

= DSUM( Data," WR1", Crit75a) = DSUM( Data," WR1", Crit75b) = DSUM( Data," WR1", Crit76) = DSUM( Data," WR2", Crit75a) = DSUM( Data," WR2", Crit75b) = DSUM( Data," WR2", Crit76) = DSUM( Data," WR3", Crit75a) = DSUM( Data," WR3", Crit75b) = DSUM( Data," WR3", Crit76) = DSUM( Data," WR4", Crit75a) = DSUM( Data," WR4", Crit75b) = DSUM( Data," WR4", Crit76)

= DSUM( Data," WR1", Crit79a) = DSUM( Data," WR1", Crit79b) = DSUM( Data," WR1", Crit80) = DSUM( Data," WR2", Crit79a) = DSUM( Data," WR2", Crit79b) = DSUM( Data," WR2", Crit80) = DSUM( Data," WR3", Crit79a) = DSUM( Data," WR3", Crit79b) = DSUM( Data," WR3", Crit80) = DSUM( Data," WR4", Crit79a) = DSUM( Data," WR4", Crit79b) = DSUM( Data," WR4", Crit80)

= DSUM( Data," WR1", crit86) = DSUM( Data," WR1", crit87) = DSUM( Data," WR1", crit88) = DSUM( Data," WR2", crit86) = DSUM( Data," WR2", crit87) = DSUM( Data," WR2", crit88) = DSUM( Data," WR3", crit86) = DSUM( Data," WR3", crit87) = DSUM( Data," WR3", crit88) = DSUM( Data," WR4", crit86) = DSUM( Data," WR4", crit87) = DSUM( Data," WR4", crit88)

= AC50+ AC45+ AC40+ AC35+ AC30+ AC25+ AC20+ AC15+ AC10 = AD50+ AD45+ AD40+ AD35+ AD30+ AD25+ AD20+ AD15+ AD10 = AE50+ AE45+ AE40+ AE35+ AE30+ AE25+ AE20+ AE15+ AE10 = AC51+ AC46+ AC41+ AC36+ AC31+ AC26+ AC21+ AC16+ AC11 = AD51+ AD46+ AD41+ AD36+ AD31+ AD26+ AD21+ AD16+ AD11 = AE51+ AE46+ AE41+ AE36+ AE31+ AE26+ AE21+ AE16+ AE11 = AC52+ AC47+ AC42+ AC37+ AC32+ AC27+ AC22+ AC17+ AC12 = AD52+ AD47+ AD42+ AD37+ AD32+ AD27+ AD22+ AD17+ AD12 = AE52+ AE47+ AE42+ AE37+ AE32+ AE27+ AE22+ AE17+ AE12 = AC53+ AC48+ AC43+ AC38+ AC33+ AC28+ AC23+ AC18+ AC13 = AD53+ AD48+ AD43+ AD38+ AD33+ AD28+ AD23+ AD18+ AD13 = AE53+ AE48+ AE43+ AE38+ AE33+ AE28+ AE23+ AE18+ AE13 Flow Size for Indirects

February 14, 2003 7 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 1 2 345 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 AF AG AH All 1 MGY 2 MGY = DSUM( Data," PPCC1", Crit49) = DSUM( Data," PPCC1", Crit50) = DSUM( Data," PPCC1", Crit50a) = DSUM( Data," PPCC2", Crit49) = DSUM( Data," PPCC2", Crit50) = DSUM( Data," PPCC2", Crit50a) = DSUM( Data," PPCC3", Crit49) = DSUM( Data," PPCC3", Crit50) = DSUM( Data," PPCC3", Crit50a) = DSUM( Data," PPCC4", Crit49) = DSUM( Data," PPCC4", Crit50) = DSUM( Data," PPCC4", Crit50a)

= DSUM( Data," PPCC1", Crit53) = DSUM( Data," PPCC1", Crit54) = DSUM( Data," PPCC1", Crit54a) = DSUM( Data," PPCC2", Crit53) = DSUM( Data," PPCC2", Crit54) = DSUM( Data," PPCC2", Crit54a) = DSUM( Data," PPCC3", Crit53) = DSUM( Data," PPCC3", Crit54) = DSUM( Data," PPCC3", Crit54a) = DSUM( Data," PPCC4", Crit53) = DSUM( Data," PPCC4", Crit54) = DSUM( Data," PPCC4", Crit54a)

= DSUM( Data," PPCC1", Crit57) = DSUM( Data," PPCC1", Crit58) = DSUM( Data," PPCC1", Crit58a) = DSUM( Data," PPCC2", Crit57) = DSUM( Data," PPCC2", Crit58) = DSUM( Data," PPCC2", Crit58a) = DSUM( Data," PPCC3", Crit57) = DSUM( Data," PPCC3", Crit58) = DSUM( Data," PPCC3", Crit58a) = DSUM( Data," PPCC4", Crit57) = DSUM( Data," PPCC4", Crit58) = DSUM( Data," PPCC4", Crit58a)

= DSUM( Data," PPCC1", Crit61) = DSUM( Data," PPCC1", Crit62) = DSUM( Data," PPCC1", Crit62a) = DSUM( Data," PPCC2", Crit61) = DSUM( Data," PPCC2", Crit62) = DSUM( Data," PPCC2", Crit62a) = DSUM( Data," PPCC3", Crit61) = DSUM( Data," PPCC3", Crit62) = DSUM( Data," PPCC3", Crit62a) = DSUM( Data," PPCC4", Crit61) = DSUM( Data," PPCC4", Crit62) = DSUM( Data," PPCC4", Crit62a)

= DSUM( Data," PPCC1", Crit65) = DSUM( Data," PPCC1", Crit66) = DSUM( Data," PPCC1", Crit66a) = DSUM( Data," PPCC2", Crit65) = DSUM( Data," PPCC2", Crit66) = DSUM( Data," PPCC2", Crit66a) = DSUM( Data," PPCC3", Crit65) = DSUM( Data," PPCC3", Crit66) = DSUM( Data," PPCC3", Crit66a) = DSUM( Data," PPCC4", Crit65) = DSUM( Data," PPCC4", Crit66) = DSUM( Data," PPCC4", Crit66a)

= DSUM( Data," PPCC1", Crit69) = DSUM( Data," PPCC1", Crit70) = DSUM( Data," PPCC1", Crit70a) = DSUM( Data," PPCC2", Crit69) = DSUM( Data," PPCC2", Crit70) = DSUM( Data," PPCC2", Crit70a) = DSUM( Data," PPCC3", Crit69) = DSUM( Data," PPCC3", Crit70) = DSUM( Data," PPCC3", Crit70a) = DSUM( Data," PPCC4", Crit69) = DSUM( Data," PPCC4", Crit70) = DSUM( Data," PPCC4", Crit70a)

= DSUM( Data," PPCC1", Crit73) = DSUM( Data," PPCC1", Crit74) = DSUM( Data," PPCC1", Crit74a) = DSUM( Data," PPCC2", Crit73) = DSUM( Data," PPCC2", Crit74) = DSUM( Data," PPCC2", Crit74a) = DSUM( Data," PPCC3", Crit73) = DSUM( Data," PPCC3", Crit74) = DSUM( Data," PPCC3", Crit74a) = DSUM( Data," PPCC4", Crit73) = DSUM( Data," PPCC4", Crit74) = DSUM( Data," PPCC4", Crit74a)

= DSUM( Data," PPCC1", Crit77) = DSUM( Data," PPCC1", Crit78) = DSUM( Data," PPCC1", Crit78a) = DSUM( Data," PPCC2", Crit77) = DSUM( Data," PPCC2", Crit78) = DSUM( Data," PPCC2", Crit78a) = DSUM( Data," PPCC3", Crit77) = DSUM( Data," PPCC3", Crit78) = DSUM( Data," PPCC3", Crit78a) = DSUM( Data," PPCC4", Crit77) = DSUM( Data," PPCC4", Crit78) = DSUM( Data," PPCC4", Crit78a)

= DSUM( Data," PPCC1", crit82) = DSUM( Data," PPCC1", crit83) = DSUM( Data," PPCC1", crit84) = DSUM( Data," PPCC2", crit82) = DSUM( Data," PPCC2", crit83) = DSUM( Data," PPCC2", crit84) = DSUM( Data," PPCC3", crit82) = DSUM( Data," PPCC3", crit83) = DSUM( Data," PPCC3", crit84) = DSUM( Data," PPCC4", crit82) = DSUM( Data," PPCC4", crit83) = DSUM( Data," PPCC4", crit84)

= AF50+ AF45+ AF40+ AF35+ AF30+ AF25+ AF20+ AF15+ AF10 = AG50+ AG45+ AG40+ AG35+ AG30+ AG25+ AG20+ AG15+ AG10 = AH50+ AH45+ AH40+ AH35+ AH30+ AH25+ AH20+ AH15+ AH10 = AF51+ AF46+ AF41+ AF36+ AF31+ AF26+ AF21+ AF16+ AF11 = AG51+ AG46+ AG41+ AG36+ AG31+ AG26+ AG21+ AG16+ AG11 = AH51+ AH46+ AH41+ AH36+ AH31+ AH26+ AH21+ AH16+ AH11 = AF52+ AF47+ AF42+ AF37+ AF32+ AF27+ AF22+ AF17+ AF12 = AG52+ AG47+ AG42+ AG37+ AG32+ AG27+ AG22+ AG17+ AG12 = AH52+ AH47+ AH42+ AH37+ AH32+ AH27+ AH22+ AH17+ AH12 = AF53+ AF48+ AF43+ AF38+ AF33+ AF28+ AF23+ AF18+ AF13 = AG53+ AG48+ AG43+ AG38+ AG33+ AG28+ AG23+ AG18+ AG13 = AH53+ AH48+ AH43+ AH38+ AH33+ AH28+ AH23+ AH18+ AH13 February 14, 2003 8 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 1 2 345 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 AI AJ AK 3 MGY 4 MGY 5 MGY = DSUM( Data," PPCC1", Crit51) = DSUM( Data," PPCC1", Crit51a) = DSUM( Data," PPCC1", Crit51b) = DSUM( Data," PPCC2", Crit51) = DSUM( Data," PPCC2", Crit51a) = DSUM( Data," PPCC2", Crit51b) = DSUM( Data," PPCC3", Crit51) = DSUM( Data," PPCC3", Crit51a) = DSUM( Data," PPCC3", Crit51b) = DSUM( Data," PPCC4", Crit51) = DSUM( Data," PPCC4", Crit51a) = DSUM( Data," PPCC4", Crit51b)

= DSUM( Data," PPCC1", Crit55) = DSUM( Data," PPCC1", Crit55a) = DSUM( Data," PPCC1", Crit55b) = DSUM( Data," PPCC2", Crit55) = DSUM( Data," PPCC2", Crit55a) = DSUM( Data," PPCC2", Crit55b) = DSUM( Data," PPCC3", Crit55) = DSUM( Data," PPCC3", Crit55a) = DSUM( Data," PPCC3", Crit55b) = DSUM( Data," PPCC4", Crit55) = DSUM( Data," PPCC4", Crit55a) = DSUM( Data," PPCC4", Crit55b)

= DSUM( Data," PPCC1", Crit59) = DSUM( Data," PPCC1", Crit59a) = DSUM( Data," PPCC1", Crit59b) = DSUM( Data," PPCC2", Crit59) = DSUM( Data," PPCC2", Crit59a) = DSUM( Data," PPCC2", Crit59b) = DSUM( Data," PPCC3", Crit59) = DSUM( Data," PPCC3", Crit59a) = DSUM( Data," PPCC3", Crit59b) = DSUM( Data," PPCC4", Crit59) = DSUM( Data," PPCC4", Crit59a) = DSUM( Data," PPCC4", Crit59b)

= DSUM( Data," PPCC1", Crit63) = DSUM( Data," PPCC1", Crit63a) = DSUM( Data," PPCC1", Crit63b) = DSUM( Data," PPCC2", Crit63) = DSUM( Data," PPCC2", Crit63a) = DSUM( Data," PPCC2", Crit63b) = DSUM( Data," PPCC3", Crit63) = DSUM( Data," PPCC3", Crit63a) = DSUM( Data," PPCC3", Crit63b) = DSUM( Data," PPCC4", Crit63) = DSUM( Data," PPCC4", Crit63a) = DSUM( Data," PPCC4", Crit63b)

= DSUM( Data," PPCC1", Crit67) = DSUM( Data," PPCC1", Crit67a) = DSUM( Data," PPCC1", Crit67b) = DSUM( Data," PPCC2", Crit67) = DSUM( Data," PPCC2", Crit67a) = DSUM( Data," PPCC2", Crit67b) = DSUM( Data," PPCC3", Crit67) = DSUM( Data," PPCC3", Crit67a) = DSUM( Data," PPCC3", Crit67b) = DSUM( Data," PPCC4", Crit67) = DSUM( Data," PPCC4", Crit67a) = DSUM( Data," PPCC4", Crit67b)

= DSUM( Data," PPCC1", Crit71) = DSUM( Data," PPCC1", Crit71a) = DSUM( Data," PPCC1", Crit71b) = DSUM( Data," PPCC2", Crit71) = DSUM( Data," PPCC2", Crit71a) = DSUM( Data," PPCC2", Crit71b) = DSUM( Data," PPCC3", Crit71) = DSUM( Data," PPCC3", Crit71a) = DSUM( Data," PPCC3", Crit71b) = DSUM( Data," PPCC4", Crit71) = DSUM( Data," PPCC4", Crit71a) = DSUM( Data," PPCC4", Crit71b)

= DSUM( Data," PPCC1", Crit75) = DSUM( Data," PPCC1", Crit75a) = DSUM( Data," PPCC1", Crit75b) = DSUM( Data," PPCC2", Crit75) = DSUM( Data," PPCC2", Crit75a) = DSUM( Data," PPCC2", Crit75b) = DSUM( Data," PPCC3", Crit75) = DSUM( Data," PPCC3", Crit75a) = DSUM( Data," PPCC3", Crit75b) = DSUM( Data," PPCC4", Crit75) = DSUM( Data," PPCC4", Crit75a) = DSUM( Data," PPCC4", Crit75b)

= DSUM( Data," PPCC1", Crit79) = DSUM( Data," PPCC1", Crit79a) = DSUM( Data," PPCC1", Crit79b) = DSUM( Data," PPCC2", Crit79) = DSUM( Data," PPCC2", Crit79a) = DSUM( Data," PPCC2", Crit79b) = DSUM( Data," PPCC3", Crit79) = DSUM( Data," PPCC3", Crit79a) = DSUM( Data," PPCC3", Crit79b) = DSUM( Data," PPCC4", Crit79) = DSUM( Data," PPCC4", Crit79a) = DSUM( Data," PPCC4", Crit79b)

= DSUM( Data," PPCC1", crit85) = DSUM( Data," PPCC1", crit86) = DSUM( Data," PPCC1", crit87) = DSUM( Data," PPCC2", crit85) = DSUM( Data," PPCC2", crit86) = DSUM( Data," PPCC2", crit87) = DSUM( Data," PPCC3", crit85) = DSUM( Data," PPCC3", crit86) = DSUM( Data," PPCC3", crit87) = DSUM( Data," PPCC4", crit85) = DSUM( Data," PPCC4", crit86) = DSUM( Data," PPCC4", crit87)

= AI50+ AI45+ AI40+ AI35+ AI30+ AI25+ AI20+ AI15+ AI10 = AJ50+ AJ45+ AJ40+ AJ35+ AJ30+ AJ25+ AJ20+ AJ15+ AJ10 = AK50+ AK45+ AK40+ AK35+ AK30+ AK25+ AK20+ AK15+ AK10 = AI51+ AI46+ AI41+ AI36+ AI31+ AI26+ AI21+ AI16+ AI11 = AJ51+ AJ46+ AJ41+ AJ36+ AJ31+ AJ26+ AJ21+ AJ16+ AJ11 = AK51+ AK46+ AK41+ AK36+ AK31+ AK26+ AK21+ AK16+ AK11 = AI52+ AI47+ AI42+ AI37+ AI32+ AI27+ AI22+ AI17+ AI12 = AJ52+ AJ47+ AJ42+ AJ37+ AJ32+ AJ27+ AJ22+ AJ17+ AJ12 = AK52+ AK47+ AK42+ AK37+ AK32+ AK27+ AK22+ AK17+ AK12 = AI53+ AI48+ AI43+ AI38+ AI33+ AI28+ AI23+ AI18+ AI13 = AJ53+ AJ48+ AJ43+ AJ38+ AJ33+ AJ28+ AJ23+ AJ18+ AJ13 = AK53+ AK48+ AK43+ AK38+ AK33+ AK28+ AK23+ AK18+ AK13 Flow Size Specific Compliance Costs Flow Size for Indirects

February 14, 2003 9 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 1 2 345 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 AL AM AN AO AP AQ AR AS 6.25 MGY All 1 MGY 2 MGY 3 MGY 4 MGY 5 MGY 6.25 MGY = DSUM( Data," PPCC1", Crit52) = AF10 = AO10+ AG10 = AP10+ AH10 = AQ10+ AI10 = AR10+ AJ10 = AS10+ AK10 = AL10 = DSUM( Data," PPCC2", Crit52) = AF11 = AO11+ AG11 = AP11+ AH11 = AQ11+ AI11 = AR11+ AJ11 = AS11+ AK11 = AL11 = DSUM( Data," PPCC3", Crit52) = AF12 = AO12+ AG12 = AP12+ AH12 = AQ12+ AI12 = AR12+ AJ12 = AS12+ AK12 = AL12 = DSUM( Data," PPCC4", Crit52) = AF13 = AO13+ AG13 = AP13+ AH13 = AQ13+ AI13 = AR13+ AJ13 = AS13+ AK13 = AL13 = DSUM( Data," PPCC1", Crit56) = AF15 = AO15+ AG15 = AP15+ AH15 = AQ15+ AI15 = AR15+ AJ15 = AS15+ AK15 = AL15 = DSUM( Data," PPCC2", Crit56) = AF16 = AO16+ AG16 = AP16+ AH16 = AQ16+ AI16 = AR16+ AJ16 = AS16+ AK16 = AL16 = DSUM( Data," PPCC3", Crit56) = AF17 = AO17+ AG17 = AP17+ AH17 = AQ17+ AI17 = AR17+ AJ17 = AS17+ AK17 = AL17 = DSUM( Data," PPCC4", Crit56) = AF18 = AO18+ AG18 = AP18+ AH18 = AQ18+ AI18 = AR18+ AJ18 = AS18+ AK18 = AL18 = DSUM( Data," PPCC1", Crit60) = AF20 = AO20+ AG20 = AP20+ AH20 = AQ20+ AI20 = AR20+ AJ20 = AS20+ AK20 = AL20 = DSUM( Data," PPCC2", Crit60) = AF21 = AO21+ AG21 = AP21+ AH21 = AQ21+ AI21 = AR21+ AJ21 = AS21+ AK21 = AL21 = DSUM( Data," PPCC3", Crit60) = AF22 = AO22+ AG22 = AP22+ AH22 = AQ22+ AI22 = AR22+ AJ22 = AS22+ AK22 = AL22 = DSUM( Data," PPCC4", Crit60) = AF23 = AO23+ AG23 = AP23+ AH23 = AQ23+ AI23 = AR23+ AJ23 = AS23+ AK23 = AL23 = DSUM( Data," PPCC1", Crit64) = AF25 = AO25+ AG25 = AP25+ AH25 = AQ25+ AI25 = AR25+ AJ25 = AS25+ AK25 = AL25 = DSUM( Data," PPCC2", Crit64) = AF26 = AO26+ AG26 = AP26+ AH26 = AQ26+ AI26 = AR26+ AJ26 = AS26+ AK26 = AL26 = DSUM( Data," PPCC3", Crit64) = AF27 = AO27+ AG27 = AP27+ AH27 = AQ27+ AI27 = AR27+ AJ27 = AS27+ AK27 = AL27 = DSUM( Data," PPCC4", Crit64) = AF28 = AO28+ AG28 = AP28+ AH28 = AQ28+ AI28 = AR28+ AJ28 = AS28+ AK28 = AL28 = DSUM( Data," PPCC1", Crit68) = AF30 = AO30+ AG30 = AP30+ AH30 = AQ30+ AI30 = AR30+ AJ30 = AS30+ AK30 = AL30 = DSUM( Data," PPCC2", Crit68) = AF31 = AO31+ AG31 = AP31+ AH31 = AQ31+ AI31 = AR31+ AJ31 = AS31+ AK31 = AL31 = DSUM( Data," PPCC3", Crit68) = AF32 = AO32+ AG32 = AP32+ AH32 = AQ32+ AI32 = AR32+ AJ32 = AS32+ AK32 = AL32 = DSUM( Data," PPCC4", Crit68) = AF33 = AO33+ AG33 = AP33+ AH33 = AQ33+ AI33 = AR33+ AJ33 = AS33+ AK33 = AL33 = DSUM( Data," PPCC1", Crit72) = AF35 = AO35+ AG35 = AP35+ AH35 = AQ35+ AI35 = AR35+ AJ35 = AS35+ AK35 = AL35 = DSUM( Data," PPCC2", Crit72) = AF36 = AO36+ AG36 = AP36+ AH36 = AQ36+ AI36 = AR36+ AJ36 = AS36+ AK36 = AL36 = DSUM( Data," PPCC3", Crit72) = AF37 = AO37+ AG37 = AP37+ AH37 = AQ37+ AI37 = AR37+ AJ37 = AS37+ AK37 = AL37 = DSUM( Data," PPCC4", Crit72) = AF38 = AO38+ AG38 = AP38+ AH38 = AQ38+ AI38 = AR38+ AJ38 = AS38+ AK38 = AL38 = DSUM( Data," PPCC1", Crit76) = AF40 = AO40+ AG40 = AP40+ AH40 = AQ40+ AI40 = AR40+ AJ40 = AS40+ AK40 = AL40 = DSUM( Data," PPCC2", Crit76) = AF41 = AO41+ AG41 = AP41+ AH41 = AQ41+ AI41 = AR41+ AJ41 = AS41+ AK41 = AL41 = DSUM( Data," PPCC3", Crit76) = AF42 = AO42+ AG42 = AP42+ AH42 = AQ42+ AI42 = AR42+ AJ42 = AS42+ AK42 = AL42 = DSUM( Data," PPCC4", Crit76) = AF43 = AO43+ AG43 = AP43+ AH43 = AQ43+ AI43 = AR43+ AJ43 = AS43+ AK43 = AL43 = DSUM( Data," PPCC1", Crit80) = AF45 = AO45+ AG45 = AP45+ AH45 = AQ45+ AI45 = AR45+ AJ45 = AS45+ AK45 = AL45 = DSUM( Data," PPCC2", Crit80) = AF46 = AO46+ AG46 = AP46+ AH46 = AQ46+ AI46 = AR46+ AJ46 = AS46+ AK46 = AL46 = DSUM( Data," PPCC3", Crit80) = AF47 = AO47+ AG47 = AP47+ AH47 = AQ47+ AI47 = AR47+ AJ47 = AS47+ AK47 = AL47 = DSUM( Data," PPCC4", Crit80) = AF48 = AO48+ AG48 = AP48+ AH48 = AQ48+ AI48 = AR48+ AJ48 = AS48+ AK48 = AL48 = DSUM( Data," PPCC1", crit88) = AF50 = AO50+ AG50 = AP50+ AH50 = AQ50+ AI50 = AR50+ AJ50 = AS50+ AK50 = AL50 = DSUM( Data," PPCC2", crit88) = AF51 = AO51+ AG51 = AP51+ AH51 = AQ51+ AI51 = AR51+ AJ51 = AS51+ AK51 = AL51 = DSUM( Data," PPCC3", crit88) = AF52 = AO52+ AG52 = AP52+ AH52 = AQ52+ AI52 = AR52+ AJ52 = AS52+ AK52 = AL52 = DSUM( Data," PPCC4", crit88) = AF53 = AO53+ AG53 = AP53+ AH53 = AQ53+ AI53 = AR53+ AJ53 = AS53+ AK53 = AL53 = AL50+ AL45+ AL40+ AL35+ AL30+ AL25+ AL20+ AL15+ AL10 = AF55 = AO55+ AG55 = AP55+ AH55 = AQ55+ AI55 = AR55+ AJ55 = AS55+ AK55 = AL55 = AL51+ AL46+ AL41+ AL36+ AL31+ AL26+ AL21+ AL16+ AL11 = AF56 = AO56+ AG56 = AP56+ AH56 = AQ56+ AI56 = AR56+ AJ56 = AS56+ AK56 = AL56 = AL52+ AL47+ AL42+ AL37+ AL32+ AL27+ AL22+ AL17+ AL12 = AF57 = AO57+ AG57 = AP57+ AH57 = AQ57+ AI57 = AR57+ AJ57 = AS57+ AK57 = AL57 = AL53+ AL48+ AL43+ AL38+ AL33+ AL28+ AL23+ AL18+ AL13 = AF58 = AO58+ AG58 = AP58+ AH58 = AQ58+ AI58 = AR58+ AJ58 = AS58+ AK58 = AL58 Cumulative Compliance Costs Flow Size for Indirects

February 14, 2003 10 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 6 7 8 9 A B C D E Bold'= Population Plain'= Closures All 1 MGY 2 MGY 3 MGY Severe Impacts ( Numbers of Closures) Flow Cutoff for Indirects

59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 = I83 TOTAL WEIGHTED FACILITIES 0 1 2 3 = Data! AY7 = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A62& BySubcat! B$ 60, Dat a!$ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySu bcat!$ A62& BySubcat! C$ 60, Data!$ E$ 7 :$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, ByS ubcat!$ A62& BySubcat! D$ 60, Data!$ E $ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySub cat!$ A62& BySubcat! E$ 60, Data!$ E$ 7:$ E$ 960)

= Data! AY8 = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A63& BySubcat! B$ 60, Dat a!$ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySu bcat!$ A63& BySubcat! C$ 60, Data!$ E$ 7 :$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, ByS ubcat!$ A63& BySubcat! D$ 60, Data!$ E $ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySub cat!$ A63& BySubcat! E$ 60, Data!$ E$ 7:$ E$ 960)

= Data! AY9 = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A64& BySubcat! B$ 60, Dat a!$ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySu bcat!$ A64& BySubcat! C$ 60, Data!$ E$ 7 :$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, ByS ubcat!$ A64& BySubcat! D$ 60, Data!$ E $ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySub cat!$ A64& BySubcat! E$ 60, Data!$ E$ 7:$ E$ 960)

= Data! AY10 = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A65& BySubcat! B$ 60, Dat a!$ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySu bcat!$ A65& BySubcat! C$ 60, Data!$ E$ 7 :$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, ByS ubcat!$ A65& BySubcat! D$ 60, Data!$ E $ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySub cat!$ A65& BySubcat! E$ 60, Data!$ E$ 7:$ E$ 960)

= Data! AY11 = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A66& BySubcat! B$ 60, Dat a!$ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySu bcat!$ A66& BySubcat! C$ 60, Data!$ E$ 7 :$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, ByS ubcat!$ A66& BySubcat! D$ 60, Data!$ E $ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySub cat!$ A66& BySubcat! E$ 60, Data!$ E$ 7:$ E$ 960)

= Data! AY12 = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A67& BySubcat! B$ 60, Dat a!$ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySu bcat!$ A67& BySubcat! C$ 60, Data!$ E$ 7 :$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, ByS ubcat!$ A67& BySubcat! D$ 60, Data!$ E $ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySub cat!$ A67& BySubcat! E$ 60, Data!$ E$ 7:$ E$ 960)

= Data! AY13 = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A68& BySubcat! B$ 60, Dat a!$ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySu bcat!$ A68& BySubcat! C$ 60, Data!$ E$ 7 :$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, ByS ubcat!$ A68& BySubcat! D$ 60, Data!$ E $ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySub cat!$ A68& BySubcat! E$ 60, Data!$ E$ 7:$ E$ 960)

= Data! AY14 = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A69& BySubcat! B$ 60, Dat a!$ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySu bcat!$ A69& BySubcat! C$ 60, Data!$ E$ 7 :$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, ByS ubcat!$ A69& BySubcat! D$ 60, Data!$ E $ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySub cat!$ A69& BySubcat! E$ 60, Data!$ E$ 7:$ E$ 960)

= Data! AY15 = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A70& BySubcat! B$ 60, Dat a!$ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySu bcat!$ A70& BySubcat! C$ 60, Data!$ E$ 7 :$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, ByS ubcat!$ A70& BySubcat! D$ 60, Data!$ E $ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySub cat!$ A70& BySubcat! E$ 60, Data!$ E$ 7:$ E$ 960) Total = SUM( B62: B70) = SUM( C62: C70) = SUM( D62: D70) = SUM( E62: E70) TOTAL BASELINE CLOSURES = Data! AY7 = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A73& BySubcat! B$ 60, Dat a!$ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySu bcat!$ A73& BySubcat! C$ 60, Data!$ BD $ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, ByS ubcat!$ A73& BySubcat! D$ 60, Data!$ B D$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySub cat!$ A73& BySubcat! E$ 60, Data!$ BD$ 7: $ BD$ 960)

= Data! AY8 = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A74& BySubcat! B$ 60, Dat a!$ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySu bcat!$ A74& BySubcat! C$ 60, Data!$ BD $ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, ByS ubcat!$ A74& BySubcat! D$ 60, Data!$ B D$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySub cat!$ A74& BySubcat! E$ 60, Data!$ BD$ 7: $ BD$ 960)

= Data! AY9 = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A75& BySubcat! B$ 60, Dat a!$ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySu bcat!$ A75& BySubcat! C$ 60, Data!$ BD $ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, ByS ubcat!$ A75& BySubcat! D$ 60, Data!$ B D$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySub cat!$ A75& BySubcat! E$ 60, Data!$ BD$ 7: $ BD$ 960)

= Data! AY10 = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A76& BySubcat! B$ 60, Dat a!$ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySu bcat!$ A76& BySubcat! C$ 60, Data!$ BD $ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, ByS ubcat!$ A76& BySubcat! D$ 60, Data!$ B D$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySub cat!$ A76& BySubcat! E$ 60, Data!$ BD$ 7: $ BD$ 960)

= Data! AY11 = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A77& BySubcat! B$ 60, Dat a!$ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySu bcat!$ A77& BySubcat! C$ 60, Data!$ BD $ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, ByS ubcat!$ A77& BySubcat! D$ 60, Data!$ B D$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySub cat!$ A77& BySubcat! E$ 60, Data!$ BD$ 7: $ BD$ 960)

= Data! AY12 = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A78& BySubcat! B$ 60, Dat a!$ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySu bcat!$ A78& BySubcat! C$ 60, Data!$ BD $ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, ByS ubcat!$ A78& BySubcat! D$ 60, Data!$ B D$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySub cat!$ A78& BySubcat! E$ 60, Data!$ BD$ 7: $ BD$ 960)

= Data! AY13 = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A79& BySubcat! B$ 60, Dat a!$ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySu bcat!$ A79& BySubcat! C$ 60, Data!$ BD $ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, ByS ubcat!$ A79& BySubcat! D$ 60, Data!$ B D$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySub cat!$ A79& BySubcat! E$ 60, Data!$ BD$ 7: $ BD$ 960)

February 14, 2003 11 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 6 7 8 9 F G H I J K L 4 MGY 5 MGY 6.25 MGY All Rank 1 MGY 2 MGY Numbers of Closures) Flow Cutoff for Indirects  Removals ( Pounds Equivalent) Flow Cutoff for Indirects

59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 4 5 6 Total Weighted Baseline From Subcat Tables = SUMIF( Data!$ AW$ 7:$ AW$ 960, By Subcat!$ A62& BySubcat! F$ 60, Data! $ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A62& BySubcat! G$ 60, Dat a!$ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySubcat! $ A62& BySubcat! H$ 60, Data!$ E$ 7:$ E$ 960) = SUM( B62: H62) = I62 I73 = VLOOKUP( A62,$ A$ 9:$ B$ 53,2, FALSE) = SUMIF( Data!$ AW$ 7:$ AW$ 960, By Subcat!$ A63& BySubcat! F$ 60, Data! $ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A63& BySubcat! G$ 60, Dat a!$ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySubcat! $ A63& BySubcat! H$ 60, Data!$ E$ 7:$ E$ 960) = SUM( B63: H63) = I63 I74 = VLOOKUP( A63,$ A$ 9:$ B$ 53,2, FALSE) = SUMIF( Data!$ AW$ 7:$ AW$ 960, By Subcat!$ A64& BySubcat! F$ 60, Data! $ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A64& BySubcat! G$ 60, Dat a!$ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySubcat! $ A64& BySubcat! H$ 60, Data!$ E$ 7:$ E$ 960) = SUM( B64: H64) = I64 I75 = VLOOKUP( A64,$ A$ 9:$ B$ 53,2, FALSE) = SUMIF( Data!$ AW$ 7:$ AW$ 960, By Subcat!$ A65& BySubcat! F$ 60, Data! $ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A65& BySubcat! G$ 60, Dat a!$ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySubcat! $ A65& BySubcat! H$ 60, Data!$ E$ 7:$ E$ 960) = SUM( B65: H65) = I65 I76 = VLOOKUP( A65,$ A$ 9:$ B$ 53,2, FALSE) = SUMIF( Data!$ AW$ 7:$ AW$ 960, By Subcat!$ A66& BySubcat! F$ 60, Data! $ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A66& BySubcat! G$ 60, Dat a!$ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySubcat! $ A66& BySubcat! H$ 60, Data!$ E$ 7:$ E$ 960) = SUM( B66: H66) = I66 I77 = VLOOKUP( A66,$ A$ 9:$ B$ 53,2, FALSE) = SUMIF( Data!$ AW$ 7:$ AW$ 960, By Subcat!$ A67& BySubcat! F$ 60, Data! $ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A67& BySubcat! G$ 60, Dat a!$ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySubcat! $ A67& BySubcat! H$ 60, Data!$ E$ 7:$ E$ 960) = SUM( B67: H67) = I67 I78 = VLOOKUP( A67,$ A$ 9:$ B$ 53,2, FALSE) = SUMIF( Data!$ AW$ 7:$ AW$ 960, By Subcat!$ A68& BySubcat! F$ 60, Data! $ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A68& BySubcat! G$ 60, Dat a!$ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySubcat! $ A68& BySubcat! H$ 60, Data!$ E$ 7:$ E$ 960) = SUM( B68: H68) = I68 I79 = VLOOKUP( A68,$ A$ 9:$ B$ 53,2, FALSE) = SUMIF( Data!$ AW$ 7:$ AW$ 960, By Subcat!$ A69& BySubcat! F$ 60, Data! $ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A69& BySubcat! G$ 60, Dat a!$ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySubcat! $ A69& BySubcat! H$ 60, Data!$ E$ 7:$ E$ 960) = SUM( B69: H69) = I69 I80 = VLOOKUP( A69,$ A$ 9:$ B$ 53,2, FALSE) = SUMIF( Data!$ AW$ 7:$ AW$ 960, By Subcat!$ A70& BySubcat! F$ 60, Data! $ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A70& BySubcat! G$ 60, Dat a!$ E$ 7:$ E$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySubcat! $ A70& BySubcat! H$ 60, Data!$ E$ 7:$ E$ 960) = SUM( B70: H70) = I70 I81 = B39 = SUM( F62: F70) = SUM( G62: G70) = SUM( H62: H70) = SUM( B71: H71) = SUM( K62: K70) = SUM( L62: L70)

= SUMIF( Data!$ AW$ 7:$ AW$ 960, By Subcat!$ A73& BySubcat! F$ 60, Data! $ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A73& BySubcat! G$ 60, Dat a!$ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySubcat! $ A73& BySubcat! H$ 60, Data!$ BD$ 7:$ BD$ 96 0) = SUM( B73: H73) = SUMIF( Data!$ AW$ 7:$ AW$ 960, By Subcat!$ A74& BySubcat! F$ 60, Data! $ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A74& BySubcat! G$ 60, Dat a!$ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySubcat! $ A74& BySubcat! H$ 60, Data!$ BD$ 7:$ BD$ 96 0) = SUM( B74: H74) = SUMIF( Data!$ AW$ 7:$ AW$ 960, By Subcat!$ A75& BySubcat! F$ 60, Data! $ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A75& BySubcat! G$ 60, Dat a!$ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySubcat! $ A75& BySubcat! H$ 60, Data!$ BD$ 7:$ BD$ 96 0) = SUM( B75: H75) = SUMIF( Data!$ AW$ 7:$ AW$ 960, By Subcat!$ A76& BySubcat! F$ 60, Data! $ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A76& BySubcat! G$ 60, Dat a!$ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySubcat! $ A76& BySubcat! H$ 60, Data!$ BD$ 7:$ BD$ 96 0) = SUM( B76: H76) = SUMIF( Data!$ AW$ 7:$ AW$ 960, By Subcat!$ A77& BySubcat! F$ 60, Data! $ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A77& BySubcat! G$ 60, Dat a!$ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySubcat! $ A77& BySubcat! H$ 60, Data!$ BD$ 7:$ BD$ 96 0) = SUM( B77: H77) = SUMIF( Data!$ AW$ 7:$ AW$ 960, By Subcat!$ A78& BySubcat! F$ 60, Data! $ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A78& BySubcat! G$ 60, Dat a!$ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySubcat! $ A78& BySubcat! H$ 60, Data!$ BD$ 7:$ BD$ 96 0) = SUM( B78: H78) = SUMIF( Data!$ AW$ 7:$ AW$ 960, By Subcat!$ A79& BySubcat! F$ 60, Data! $ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A79& BySubcat! G$ 60, Dat a!$ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySubcat! $ A79& BySubcat! H$ 60, Data!$ BD$ 7:$ BD$ 96 0) = SUM( B79: H79)

February 14, 2003 12 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 6 7 8 9 M N O P Q R S 3 MGY 4 MGY 5 MGY 6.25 MGY All 1 MGY Pounds Equivalent) Flow Cutoff for Indirects

59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 = IF( K62'= L62,0,1)

= IF( K63'= L63,0,1)

= IF( K64'= L64,0,1)

= IF( K65'= L65,0,1)

= IF( K66'= L66,0,1)

= IF( K67'= L67,0,1)

= IF( K68'= L68,0,1)

= IF( K69'= L69,0,1)

= IF( K70'= L70,0,1) = SUM( M62: M70)

February 14, 2003 13 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 6 7 8 9 T U V 2 MGY 3 MGY 4 MGY Flow Size for Indirects  Severe Impacts 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 February 14, 2003 14 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 6 7 8 9 W X Y 5 MGY 6.25 MGY All 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 February 14, 2003 15 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 6 7 8 9 Z AA AB 1 MGY 2 MGY 3 MGY Flow Size for Indirects  Removals 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 February 14, 2003 16 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 6 7 8 9 AC AD AE 4 MGY 5 MGY 6.25 MGY Flow Size for Indirects

59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 February 14, 2003 17 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 6 7 8 9 AF AG AH All 1 MGY 2 MGY 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 February 14, 2003 18 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 6 7 8 9 AI AJ AK 3 MGY 4 MGY 5 MGY Flow Size Specific Compliance Costs Flow Size for Indirects

59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 February 14, 2003 19 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 6 7 8 9 AL AM AN AO AP AQ AR AS 6.25 MGY All 1 MGY 2 MGY 3 MGY 4 MGY 5 MGY 6.25 MGY Cumulative Compliance Costs Flow Size for Indirects

59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 February 14, 2003 20 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 6 7 8 9 A B C D E Bold'= Population Plain'= Closures All 1 MGY 2 MGY 3 MGY Severe Impacts ( Numbers of Closures) Flow Cutoff for Indirects

79 80 81 82 = Data! AY14 = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A80& BySubcat! B$ 60, Dat a!$ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySu bcat!$ A80& BySubcat! C$ 60, Data!$ BD $ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, ByS ubcat!$ A80& BySubcat! D$ 60, Data!$ B D$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySub cat!$ A80& BySubcat! E$ 60, Data!$ BD$ 7: $ BD$ 960)

= Data! AY15 = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A81& BySubcat! B$ 60, Dat a!$ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySu bcat!$ A81& BySubcat! C$ 60, Data!$ BD $ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, ByS ubcat!$ A81& BySubcat! D$ 60, Data!$ B D$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySub cat!$ A81& BySubcat! E$ 60, Data!$ BD$ 7: $ BD$ 960) Total = SUM( B73: B81) = SUM( C73: C81) = SUM( D73: D81) = SUM( E73: E81)

February 14, 2003 21 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 6 7 8 9 F G H I J K L 4 MGY 5 MGY 6.25 MGY All Rank 1 MGY 2 MGY Numbers of Closures) Flow Cutoff for Indirects  Removals ( Pounds Equivalent) Flow Cutoff for Indirects

79 80 81 82 = SUMIF( Data!$ AW$ 7:$ AW$ 960, By Subcat!$ A80& BySubcat! F$ 60, Data! $ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A80& BySubcat! G$ 60, Dat a!$ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySubcat! $ A80& BySubcat! H$ 60, Data!$ BD$ 7:$ BD$ 96 0) = SUM( B80: H80) = SUMIF( Data!$ AW$ 7:$ AW$ 960, By Subcat!$ A81& BySubcat! F$ 60, Data! $ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, B ySubcat!$ A81& BySubcat! G$ 60, Dat a!$ BD$ 7:$ BD$ 960) = SUMIF( Data!$ AW$ 7:$ AW$ 960, BySubcat! $ A81& BySubcat! H$ 60, Data!$ BD$ 7:$ BD$ 96 0) = SUM( B81: H81) = SUM( F73: F81) = SUM( G73: G81) = SUM( H73: H81) = SUM( B82: H82) = I71 I82 February 14, 2003 22 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 6 7 8 9 M N O P Q R S 3 MGY 4 MGY 5 MGY 6.25 MGY All 1 MGY Pounds Equivalent) Flow Cutoff for Indirects

79 80 81 82 February 14, 2003 23 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 6 7 8 9 T U V 2 MGY 3 MGY 4 MGY Flow Size for Indirects  Severe Impacts 79 80 81 82 February 14, 2003 24 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 6 7 8 9 W X Y 5 MGY 6.25 MGY All 79 80 81 82 February 14, 2003 25 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 6 7 8 9 Z AA AB 1 MGY 2 MGY 3 MGY Flow Size for Indirects  Removals 79 80 81 82 February 14, 2003 26 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 6 7 8 9 AC AD AE 4 MGY 5 MGY 6.25 MGY Flow Size for Indirects

79 80 81 82 February 14, 2003 27 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 6 7 8 9 AF AG AH All 1 MGY 2 MGY 79 80 81 82 February 14, 2003 28 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 6 7 8 9 AI AJ AK 3 MGY 4 MGY 5 MGY Flow Size Specific Compliance Costs Flow Size for Indirects

79 80 81 82 February 14, 2003 29 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 6 7 8 9 AL AM AN AO AP AQ AR AS 6.25 MGY All 1 MGY 2 MGY 3 MGY 4 MGY 5 MGY 6.25 MGY Cumulative Compliance Costs Flow Size for Indirects

79 80 81 82 February 14, 2003 30 of 43 Summary_ July formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 2 3 4 5 67 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 A B C D E F G H MP& M Impacts and Removals by Subcategory, National Estimates = Data! A3 Bold'= Population Plain'= Closures All 1 MGY 2 MGY 3 MGY 4 MGY 5 MGY 6.25 MGY = Crit! S132 = BySubcat! B9 = BySubcat! C9 = BySubcat! D9 = BySubcat! E9 = BySubcat! F9 = BySubcat! G9 = BySubcat! H9 Option 1 = I10 =+ D10+ J10 =+ E10+ K10 =+ F10+ L10 =+ G10+ M10 =+ H10+ N10 = O10 Option 2 = I11 =+ D11+ J11 =+ E11+ K11 =+ F11+ L11 =+ G11+ M11 =+ H11+ N11 = O11 Option 3 = I12 =+ D12+ J12 =+ E12+ K12 =+ F12+ L12 =+ G12+ M12 =+ H12+ N12 = O12 Option 4 = I13 =+ D13+ J13 =+ E13+ K13 =+ F13+ L13 =+ G13+ M13 =+ H13+ N13 = O13 = Crit! S153 = BySubcat! B14 = BySubcat! C14 = BySubcat! D14 = BySubcat! E14 = BySubcat! F14 = BySubcat! G14 = BySubcat! H14 Option 1 = I15 =+ D15+ J15 =+ E15+ K15 =+ F15+ L15 =+ G15+ M15 =+ H15+ N15 = O15 Option 2 = I16 =+ D16+ J16 =+ E16+ K16 =+ F16+ L16 =+ G16+ M16 =+ H16+ N16 = O16 Option 3 = I17 =+ D17+ J17 =+ E17+ K17 =+ F17+ L17 =+ G17+ M17 =+ H17+ N17 = O17 Option 4 = I18 =+ D18+ J18 =+ E18+ K18 =+ F18+ L18 =+ G18+ M18 =+ H18+ N18 = O18 = IF( Crit! S174'=" NonCategorized"," General Metals", Crit! S174) = BySubcat! B19 = BySubcat! C19 = BySubcat! D19 = BySubcat! E19 = BySubcat! F19 = BySubcat! G19 = BySubcat! H19 Option 1 = I20 =+ D20+ J20 =+ E20+ K20 =+ F20+ L20 =+ G20+ M20 =+ H20+ N20 = O20 Option 2 = I21 =+ D21+ J21 =+ E21+ K21 =+ F21+ L21 =+ G21+ M21 =+ H21+ N21 = O21 Option 3 = I22 =+ D22+ J22 =+ E22+ K22 =+ F22+ L22 =+ G22+ M22 =+ H22+ N22 = O22 Option 4 = I23 =+ D23+ J23 =+ E23+ K23 =+ F23+ L23 =+ G23+ M23 =+ H23+ N23 = O23 = Crit! S195 = BySubcat! B24 = BySubcat! C24 = BySubcat! D24 = BySubcat! E24 = BySubcat! F24 = BySubcat! G24 = BySubcat! H24 Option 1 = I25 =+ D25+ J25 =+ E25+ K25 =+ F25+ L25 =+ G25+ M25 =+ H25+ N25 = O25 Option 2 = I26 =+ D26+ J26 =+ E26+ K26 =+ F26+ L26 =+ G26+ M26 =+ H26+ N26 = O26 Option 3 = I27 =+ D27+ J27 =+ E27+ K27 =+ F27+ L27 =+ G27+ M27 =+ H27+ N27 = O27 Option 4 = I28 =+ D28+ J28 =+ E28+ K28 =+ F28+ L28 =+ G28+ M28 =+ H28+ N28 = O28 = Crit! S216 = BySubcat! B29 = BySubcat! C29 = BySubcat! D29 = BySubcat! E29 = BySubcat! F29 = BySubcat! G29 = BySubcat! H29 Option 1 = I30 =+ D30+ J30 =+ E30+ K30 =+ F30+ L30 =+ G30+ M30 =+ H30+ N30 = O30 Option 2 = I31 =+ D31+ J31 =+ E31+ K31 =+ F31+ L31 =+ G31+ M31 =+ H31+ N31 = O31 Option 3 = I32 =+ D32+ J32 =+ E32+ K32 =+ F32+ L32 =+ G32+ M32 =+ H32+ N32 = O32 Option 4 = I33 =+ D33+ J33 =+ E33+ K33 =+ F33+ L33 =+ G33+ M33 =+ H33+ N33 = O33 = Crit! S237 = BySubcat! B34 = BySubcat! C34 = BySubcat! D34 = BySubcat! E34 = BySubcat! F34 = BySubcat! G34 = BySubcat! H34 Option 1 = I35 =+ D35+ J35 =+ E35+ K35 =+ F35+ L35 =+ G35+ M35 =+ H35+ N35 = O35 Option 2 = I36 =+ D36+ J36 =+ E36+ K36 =+ F36+ L36 =+ G36+ M36 =+ H36+ N36 = O36 Option 3 = I37 =+ D37+ J37 =+ E37+ K37 =+ F37+ L37 =+ G37+ M37 =+ H37+ N37 = O37 Option 4 = I38 =+ D38+ J38 =+ E38+ K38 =+ F38+ L38 =+ G38+ M38 =+ H38+ N38 = O38 = Crit! S259 = BySubcat! B39 = BySubcat! C39 = BySubcat! D39 = BySubcat! E39 = BySubcat! F39 = BySubcat! G39 = BySubcat! H39 Option 1 = I40 =+ D40+ J40 =+ E40+ K40 =+ F40+ L40 =+ G40+ M40 =+ H40+ N40 = O40 Option 2 = I41 =+ D41+ J41 =+ E41+ K41 =+ F41+ L41 =+ G41+ M41 =+ H41+ N41 = O41 Option 3 = I42 =+ D42+ J42 =+ E42+ K42 =+ F42+ L42 =+ G42+ M42 =+ H42+ N42 = O42 Option 4 = I43 =+ D43+ J43 =+ E43+ K43 =+ F43+ L43 =+ G43+ M43 =+ H43+ N43 = O43 = Crit! S280 = BySubcat! B44 = BySubcat! C44 = BySubcat! D44 = BySubcat! E44 = BySubcat! F44 = BySubcat! G44 = BySubcat! H44 Option 1 = I45 =+ D45+ J45 =+ E45+ K45 =+ F45+ L45 =+ G45+ M45 =+ H45+ N45 = O45 Option 2 = I46 =+ D46+ J46 =+ E46+ K46 =+ F46+ L46 =+ G46+ M46 =+ H46+ N46 = O46 Option 3 = I47 =+ D47+ J47 =+ E47+ K47 =+ F47+ L47 =+ G47+ M47 =+ H47+ N47 = O47 Option 4 = I48 =+ D48+ J48 =+ E48+ K48 =+ F48+ L48 =+ G48+ M48 =+ H48+ N48 = O48 = Crit! S304 = BySubcat! B49 = BySubcat! C49 = BySubcat! D49 = BySubcat! E49 = BySubcat! F49 = BySubcat! G49 = BySubcat! H49 Option 1 = I50 =+ D50+ J50 =+ E50+ K50 =+ F50+ L50 =+ G50+ M50 =+ H50+ N50 = O50 Option 2 = I51 =+ D51+ J51 =+ E51+ K51 =+ F51+ L51 =+ G51+ M51 =+ H51+ N51 = O51 Option 3 = I52 =+ D52+ J52 =+ E52+ K52 =+ F52+ L52 =+ G52+ M52 =+ H52+ N52 = O52 Option 4 = I53 =+ D53+ J53 =+ E53+ K53 =+ F53+ L53 =+ G53+ M53 =+ H53+ N53 = O53 All Categories = BySubcat! B54 = BySubcat! C54 = BySubcat! D54 = BySubcat! E54 = BySubcat! F54 = BySubcat! G54 = BySubcat! H54 Option 1 = I55 =+ D55+ J55 =+ E55+ K55 =+ F55+ L55 =+ G55+ M55 =+ H55+ N55 = O55 Option 2 = I56 =+ D56+ J56 =+ E56+ K56 =+ F56+ L56 =+ G56+ M56 =+ H56+ N56 = O56 Option 3 = I57 =+ D57+ J57 =+ E57+ K57 =+ F57+ L57 =+ G57+ M57 =+ H57+ N57 = O57 Option 4 = I58 =+ D58+ J58 =+ E58+ K58 =+ F58+ L58 =+ G58+ M58 =+ H58+ N58 = O58 Moderate Impacts ( Numbers of Facilities) Flow Cutoff for Indirects

February 14, 2003 31 of 43 Summary_ July formula. xls  Mod Record for the Final Metal Product and Machinery Rule 2 3 45 67 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 B C D E F G MP& M Cost Effectiveness, Ranked by Total Removals = Data! A3 All 1 MGY 2 MGY 3 MGY =+ BySubcat! A9 Option = IF( ISNA( VLOOKUP( 4, BySubcat! J10: Q13,8,0)),"", VLOOKUP( 4, BySubcat! J10: Q13,8,0)) = AB10* DeflCE/ 1000000 = AC10* DeflCE/ 1000000 = AD10* DeflCE/ 1000000 = AE10* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 3, BySubcat! J10: Q13,8,0)),"", VLOOKUP( 3, BySubcat! J10: Q13,8,0)) = AB11* DeflCE/ 1000000 = AC11* DeflCE/ 1000000 = AD11* DeflCE/ 1000000 = AE11* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 2, BySubcat! J10: Q13,8,0)),"", VLOOKUP( 2, BySubcat! J10: Q13,8,0)) = AB12* DeflCE/ 1000000 = AC12* DeflCE/ 1000000 = AD12* DeflCE/ 1000000 = AE12* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 1, BySubcat! J10: Q13,8,0)),"", VLOOKUP( 1, BySubcat! J10: Q13,8,0)) = AB13* DeflCE/ 1000000 = AC13* DeflCE/ 1000000 = AD13* DeflCE/ 1000000 = AE13* DeflCE/ 1000000 =+ BySubcat! A14 Option = IF( ISNA( VLOOKUP( 4, BySubcat! J15: Q18,8,0)),"", VLOOKUP( 4, BySubcat! J15: Q18,8,0)) = AB15* DeflCE/ 1000000 = AC15* DeflCE/ 1000000 = AD15* DeflCE/ 1000000 = AE15* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 3, BySubcat! J15: Q18,8,0)),"", VLOOKUP( 3, BySubcat! J15: Q18,8,0)) = AB16* DeflCE/ 1000000 = AC16* DeflCE/ 1000000 = AD16* DeflCE/ 1000000 = AE16* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 2, BySubcat! J15: Q18,8,0)),"", VLOOKUP( 2, BySubcat! J15: Q18,8,0)) = AB17* DeflCE/ 1000000 = AC17* DeflCE/ 1000000 = AD17* DeflCE/ 1000000 = AE17* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 1, BySubcat! J15: Q18,8,0)),"", VLOOKUP( 1, BySubcat! J15: Q18,8,0)) = AB18* DeflCE/ 1000000 = AC18* DeflCE/ 1000000 = AD18* DeflCE/ 1000000 = AE18* DeflCE/ 1000000 =+ BySubcat! A19 Option = IF( ISNA( VLOOKUP( 4, BySubcat! J20: Q23,8,0)),"", VLOOKUP( 4, BySubcat! J20: Q23,8,0)) = AB20* DeflCE/ 1000000 = AC20* DeflCE/ 1000000 = AD20* DeflCE/ 1000000 = AE20* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 3, BySubcat! J20: Q23,8,0)),"", VLOOKUP( 3, BySubcat! J20: Q23,8,0)) = AB21* DeflCE/ 1000000 = AC21* DeflCE/ 1000000 = AD21* DeflCE/ 1000000 = AE21* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 2, BySubcat! J20: Q23,8,0)),"", VLOOKUP( 2, BySubcat! J20: Q23,8,0)) = AB22* DeflCE/ 1000000 = AC22* DeflCE/ 1000000 = AD22* DeflCE/ 1000000 = AE22* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 1, BySubcat! J20: Q23,8,0)),"", VLOOKUP( 1, BySubcat! J20: Q23,8,0)) = AB23* DeflCE/ 1000000 = AC23* DeflCE/ 1000000 = AD23* DeflCE/ 1000000 = AE23* DeflCE/ 1000000 =+ BySubcat! A24 Option = IF( ISNA( VLOOKUP( 4, BySubcat! J25: Q28,8,0)),"", VLOOKUP( 4, BySubcat! J25: Q28,8,0)) = AB25* DeflCE/ 1000000 = AC25* DeflCE/ 1000000 = AD25* DeflCE/ 1000000 = AE25* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 3, BySubcat! J25: Q28,8,0)),"", VLOOKUP( 3, BySubcat! J25: Q28,8,0)) = AB26* DeflCE/ 1000000 = AC26* DeflCE/ 1000000 = AD26* DeflCE/ 1000000 = AE26* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 2, BySubcat! J25: Q28,8,0)),"", VLOOKUP( 2, BySubcat! J25: Q28,8,0)) = AB27* DeflCE/ 1000000 = AC27* DeflCE/ 1000000 = AD27* DeflCE/ 1000000 = AE27* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 1, BySubcat! J25: Q28,8,0)),"", VLOOKUP( 1, BySubcat! J25: Q28,8,0)) = AB28* DeflCE/ 1000000 = AC28* DeflCE/ 1000000 = AD28* DeflCE/ 1000000 = AE28* DeflCE/ 1000000 =+ BySubcat! A29 Option = IF( ISNA( VLOOKUP( 4, BySubcat! J30: Q33,8,0)),"", VLOOKUP( 4, BySubcat! J30: Q33,8,0)) = AB30* DeflCE/ 1000000 = AC30* DeflCE/ 1000000 = AD30* DeflCE/ 1000000 = AE30* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 3, BySubcat! J30: Q33,8,0)),"", VLOOKUP( 3, BySubcat! J30: Q33,8,0)) = AB31* DeflCE/ 1000000 = AC31* DeflCE/ 1000000 = AD31* DeflCE/ 1000000 = AE31* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 2, BySubcat! J30: Q33,8,0)),"", VLOOKUP( 2, BySubcat! J30: Q33,8,0)) = AB32* DeflCE/ 1000000 = AC32* DeflCE/ 1000000 = AD32* DeflCE/ 1000000 = AE32* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 1, BySubcat! J30: Q33,8,0)),"", VLOOKUP( 1, BySubcat! J30: Q33,8,0)) = AB33* DeflCE/ 1000000 = AC33* DeflCE/ 1000000 = AD33* DeflCE/ 1000000 = AE33* DeflCE/ 1000000 =+ BySubcat! A34 Option = IF( ISNA( VLOOKUP( 4, BySubcat! J35: Q38,8,0)),"", VLOOKUP( 4, BySubcat! J35: Q38,8,0)) = AB35* DeflCE/ 1000000 = AC35* DeflCE/ 1000000 = AD35* DeflCE/ 1000000 = AE35* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 3, BySubcat! J35: Q38,8,0)),"", VLOOKUP( 3, BySubcat! J35: Q38,8,0)) = AB36* DeflCE/ 1000000 = AC36* DeflCE/ 1000000 = AD36* DeflCE/ 1000000 = AE36* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 2, BySubcat! J35: Q38,8,0)),"", VLOOKUP( 2, BySubcat! J35: Q38,8,0)) = AB37* DeflCE/ 1000000 = AC37* DeflCE/ 1000000 = AD37* DeflCE/ 1000000 = AE37* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 1, BySubcat! J35: Q38,8,0)),"", VLOOKUP( 1, BySubcat! J35: Q38,8,0)) = AB38* DeflCE/ 1000000 = AC38* DeflCE/ 1000000 = AD38* DeflCE/ 1000000 = AE38* DeflCE/ 1000000 =+ BySubcat! A39 Option = IF( ISNA( VLOOKUP( 4, BySubcat! J40: Q43,8,0)),"", VLOOKUP( 4, BySubcat! J40: Q43,8,0)) = AB40* DeflCE/ 1000000 = AC40* DeflCE/ 1000000 = AD40* DeflCE/ 1000000 = AE40* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 3, BySubcat! J40: Q43,8,0)),"", VLOOKUP( 3, BySubcat! J40: Q43,8,0)) = AB41* DeflCE/ 1000000 = AC41* DeflCE/ 1000000 = AD41* DeflCE/ 1000000 = AE41* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 2, BySubcat! J40: Q43,8,0)),"", VLOOKUP( 2, BySubcat! J40: Q43,8,0)) = AB42* DeflCE/ 1000000 = AC42* DeflCE/ 1000000 = AD42* DeflCE/ 1000000 = AE42* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 1, BySubcat! J40: Q43,8,0)),"", VLOOKUP( 1, BySubcat! J40: Q43,8,0)) = AB43* DeflCE/ 1000000 = AC43* DeflCE/ 1000000 = AD43* DeflCE/ 1000000 = AE43* DeflCE/ 1000000 =+ BySubcat! A44 Option = IF( ISNA( VLOOKUP( 4, BySubcat! J45: Q48,8,0)),"", VLOOKUP( 4, BySubcat! J45: Q48,8,0)) = AB45* DeflCE/ 1000000 = AC45* DeflCE/ 1000000 = AD45* DeflCE/ 1000000 = AE45* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 3, BySubcat! J45: Q48,8,0)),"", VLOOKUP( 3, BySubcat! J45: Q48,8,0)) = AB46* DeflCE/ 1000000 = AC46* DeflCE/ 1000000 = AD46* DeflCE/ 1000000 = AE46* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 2, BySubcat! J45: Q48,8,0)),"", VLOOKUP( 2, BySubcat! J45: Q48,8,0)) = AB47* DeflCE/ 1000000 = AC47* DeflCE/ 1000000 = AD47* DeflCE/ 1000000 = AE47* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 1, BySubcat! J45: Q48,8,0)),"", VLOOKUP( 1, BySubcat! J45: Q48,8,0)) = AB48* DeflCE/ 1000000 = AC48* DeflCE/ 1000000 = AD48* DeflCE/ 1000000 = AE48* DeflCE/ 1000000 =+ BySubcat! A49 Option = IF( ISNA( VLOOKUP( 4, BySubcat! J50: Q53,8,0)),"", VLOOKUP( 4, BySubcat! J50: Q53,8,0)) = AB50* DeflCE/ 1000000 = AC50* DeflCE/ 1000000 = AD50* DeflCE/ 1000000 = AE50* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 3, BySubcat! J50: Q53,8,0)),"", VLOOKUP( 3, BySubcat! J50: Q53,8,0)) = AB51* DeflCE/ 1000000 = AC51* DeflCE/ 1000000 = AD51* DeflCE/ 1000000 = AE51* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 2, BySubcat! J50: Q53,8,0)),"", VLOOKUP( 2, BySubcat! J50: Q53,8,0)) = AB52* DeflCE/ 1000000 = AC52* DeflCE/ 1000000 = AD52* DeflCE/ 1000000 = AE52* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 1, BySubcat! J50: Q53,8,0)),"", VLOOKUP( 1, BySubcat! J50: Q53,8,0)) = AB53* DeflCE/ 1000000 = AC53* DeflCE/ 1000000 = AD53* DeflCE/ 1000000 = AE53* DeflCE/ 1000000 =+ BySubcat! A54&" ( Metal Bearing Subcategories Only for Option 4)" Option = IF( ISNA( VLOOKUP( 4, BySubcat! J55: Q58,8,0)),"", VLOOKUP( 4, BySubcat! J55: Q58,8,0)) = AB55* DeflCE/ 1000000 = AC55* DeflCE/ 1000000 = AD55* DeflCE/ 1000000 = AE55* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 3, BySubcat! J55: Q58,8,0)),"", VLOOKUP( 3, BySubcat! J55: Q58,8,0)) = AB56* DeflCE/ 1000000 = AC56* DeflCE/ 1000000 = AD56* DeflCE/ 1000000 = AE56* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 2, BySubcat! J55: Q58,8,0)),"", VLOOKUP( 2, BySubcat! J55: Q58,8,0)) = AB57* DeflCE/ 1000000 = AC57* DeflCE/ 1000000 = AD57* DeflCE/ 1000000 = AE57* DeflCE/ 1000000 Option = IF( ISNA( VLOOKUP( 1, BySubcat! J55: Q58,8,0)),"", VLOOKUP( 1, BySubcat! J55: Q58,8,0)) = AB58* DeflCE/ 1000000 = AC58* DeflCE/ 1000000 = AD58* DeflCE/ 1000000 = AE58* DeflCE/ 1000000 Compliance Cost, Millions of 1981 Dollars Flow Cutoff for Indirects

February 14, 2003 32 of 43 Summary_ July formula. xls  CE Record for the Final Metal Product and Machinery Rule 2 3 45 67 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 H I J K L M N O P Q R CCI01 6342 CCI81 3535 DeflCE = K3/ K2 4 MGY 5 MGY 6.25 MGY All 1 MGY 2 MGY 3 MGY 4 MGY 5 MGY 6.25 MGY All = AF10* DeflCE/ 1000000 = AG10* DeflCE/ 1000000 = AH10* DeflCE/ 1000000 = AI10 = AJ10 = AK10 = AL10 = AM10 = AN10 = AO10 = IF( ISERR( D10/ K10),"", 1000000* D10/ K10) = AF11* DeflCE/ 1000000 = AG11* DeflCE/ 1000000 = AH11* DeflCE/ 1000000 = AI11 = AJ11 = AK11 = AL11 = AM11 = AN11 = AO11 = IF( ISERR( D11/ K11),"", 1000000* D11/ K11) = AF12* DeflCE/ 1000000 = AG12* DeflCE/ 1000000 = AH12* DeflCE/ 1000000 = AI12 = AJ12 = AK12 = AL12 = AM12 = AN12 = AO12 = IF( ISERR( D12/ K12),"", 1000000* D12/ K12) = AF13* DeflCE/ 1000000 = AG13* DeflCE/ 1000000 = AH13* DeflCE/ 1000000 = AI13 = AJ13 = AK13 = AL13 = AM13 = AN13 = AO13 = IF( ISERR( D13/ K13),"", 1000000* D13/ K13)

= AF15* DeflCE/ 1000000 = AG15* DeflCE/ 1000000 = AH15* DeflCE/ 1000000 = AI15 = AJ15 = AK15 = AL15 = AM15 = AN15 = AO15 = IF( ISERR( D15/ K15),"", 1000000* D15/ K15) = AF16* DeflCE/ 1000000 = AG16* DeflCE/ 1000000 = AH16* DeflCE/ 1000000 = AI16 = AJ16 = AK16 = AL16 = AM16 = AN16 = AO16 = IF( ISERR( D16/ K16),"", 1000000* D16/ K16) = AF17* DeflCE/ 1000000 = AG17* DeflCE/ 1000000 = AH17* DeflCE/ 1000000 = AI17 = AJ17 = AK17 = AL17 = AM17 = AN17 = AO17 = IF( ISERR( D17/ K17),"", 1000000* D17/ K17) = AF18* DeflCE/ 1000000 = AG18* DeflCE/ 1000000 = AH18* DeflCE/ 1000000 = AI18 = AJ18 = AK18 = AL18 = AM18 = AN18 = AO18 = IF( ISERR( D18/ K18),"", 1000000* D18/ K18)

= AF20* DeflCE/ 1000000 = AG20* DeflCE/ 1000000 = AH20* DeflCE/ 1000000 = AI20 = AJ20 = AK20 = AL20 = AM20 = AN20 = AO20 = IF( ISERR( D20/ K20),"", 1000000* D20/ K20) = AF21* DeflCE/ 1000000 = AG21* DeflCE/ 1000000 = AH21* DeflCE/ 1000000 = AI21 = AJ21 = AK21 = AL21 = AM21 = AN21 = AO21 = IF( ISERR( D21/ K21),"", 1000000* D21/ K21) = AF22* DeflCE/ 1000000 = AG22* DeflCE/ 1000000 = AH22* DeflCE/ 1000000 = AI22 = AJ22 = AK22 = AL22 = AM22 = AN22 = AO22 = IF( ISERR( D22/ K22),"", 1000000* D22/ K22) = AF23* DeflCE/ 1000000 = AG23* DeflCE/ 1000000 = AH23* DeflCE/ 1000000 = AI23 = AJ23 = AK23 = AL23 = AM23 = AN23 = AO23 = IF( ISERR( D23/ K23),"", 1000000* D23/ K23)

= AF25* DeflCE/ 1000000 = AG25* DeflCE/ 1000000 = AH25* DeflCE/ 1000000 = AI25 = AJ25 = AK25 = AL25 = AM25 = AN25 = AO25 = IF( ISERR( D25/ K25),"", 1000000* D25/ K25) = AF26* DeflCE/ 1000000 = AG26* DeflCE/ 1000000 = AH26* DeflCE/ 1000000 = AI26 = AJ26 = AK26 = AL26 = AM26 = AN26 = AO26 = IF( ISERR( D26/ K26),"", 1000000* D26/ K26) = AF27* DeflCE/ 1000000 = AG27* DeflCE/ 1000000 = AH27* DeflCE/ 1000000 = AI27 = AJ27 = AK27 = AL27 = AM27 = AN27 = AO27 = IF( ISERR( D27/ K27),"", 1000000* D27/ K27) = AF28* DeflCE/ 1000000 = AG28* DeflCE/ 1000000 = AH28* DeflCE/ 1000000 = AI28 = AJ28 = AK28 = AL28 = AM28 = AN28 = AO28 = IF( ISERR( D28/ K28),"", 1000000* D28/ K28)

= AF30* DeflCE/ 1000000 = AG30* DeflCE/ 1000000 = AH30* DeflCE/ 1000000 = AI30 = AJ30 = AK30 = AL30 = AM30 = AN30 = AO30 = IF( ISERR( D30/ K30),"", 1000000* D30/ K30) = AF31* DeflCE/ 1000000 = AG31* DeflCE/ 1000000 = AH31* DeflCE/ 1000000 = AI31 = AJ31 = AK31 = AL31 = AM31 = AN31 = AO31 = IF( ISERR( D31/ K31),"", 1000000* D31/ K31) = AF32* DeflCE/ 1000000 = AG32* DeflCE/ 1000000 = AH32* DeflCE/ 1000000 = AI32 = AJ32 = AK32 = AL32 = AM32 = AN32 = AO32 = IF( ISERR( D32/ K32),"", 1000000* D32/ K32) = AF33* DeflCE/ 1000000 = AG33* DeflCE/ 1000000 = AH33* DeflCE/ 1000000 = AI33 = AJ33 = AK33 = AL33 = AM33 = AN33 = AO33 = IF( ISERR( D33/ K33),"", 1000000* D33/ K33)

= AF35* DeflCE/ 1000000 = AG35* DeflCE/ 1000000 = AH35* DeflCE/ 1000000 = AI35 = AJ35 = AK35 = AL35 = AM35 = AN35 = AO35 = IF( ISERR( D35/ K35),"", 1000000* D35/ K35) = AF36* DeflCE/ 1000000 = AG36* DeflCE/ 1000000 = AH36* DeflCE/ 1000000 = AI36 = AJ36 = AK36 = AL36 = AM36 = AN36 = AO36 = IF( ISERR( D36/ K36),"", 1000000* D36/ K36) = AF37* DeflCE/ 1000000 = AG37* DeflCE/ 1000000 = AH37* DeflCE/ 1000000 = AI37 = AJ37 = AK37 = AL37 = AM37 = AN37 = AO37 = IF( ISERR( D37/ K37),"", 1000000* D37/ K37) = AF38* DeflCE/ 1000000 = AG38* DeflCE/ 1000000 = AH38* DeflCE/ 1000000 = AI38 = AJ38 = AK38 = AL38 = AM38 = AN38 = AO38 = IF( ISERR( D38/ K38),"", 1000000* D38/ K38)

= AF40* DeflCE/ 1000000 = AG40* DeflCE/ 1000000 = AH40* DeflCE/ 1000000 = AI40 = AJ40 = AK40 = AL40 = AM40 = AN40 = AO40 = IF( ISERR( D40/ K40),"", 1000000* D40/ K40) = AF41* DeflCE/ 1000000 = AG41* DeflCE/ 1000000 = AH41* DeflCE/ 1000000 = AI41 = AJ41 = AK41 = AL41 = AM41 = AN41 = AO41 = IF( ISERR( D41/ K41),"", 1000000* D41/ K41) = AF42* DeflCE/ 1000000 = AG42* DeflCE/ 1000000 = AH42* DeflCE/ 1000000 = AI42 = AJ42 = AK42 = AL42 = AM42 = AN42 = AO42 = IF( ISERR( D42/ K42),"", 1000000* D42/ K42) = AF43* DeflCE/ 1000000 = AG43* DeflCE/ 1000000 = AH43* DeflCE/ 1000000 = AI43 = AJ43 = AK43 = AL43 = AM43 = AN43 = AO43 = IF( ISERR( D43/ K43),"", 1000000* D43/ K43)

= AF45* DeflCE/ 1000000 = AG45* DeflCE/ 1000000 = AH45* DeflCE/ 1000000 = AI45 = AJ45 = AK45 = AL45 = AM45 = AN45 = AO45 = IF( ISERR( D45/ K45),"", 1000000* D45/ K45) = AF46* DeflCE/ 1000000 = AG46* DeflCE/ 1000000 = AH46* DeflCE/ 1000000 = AI46 = AJ46 = AK46 = AL46 = AM46 = AN46 = AO46 = IF( ISERR( D46/ K46),"", 1000000* D46/ K46) = AF47* DeflCE/ 1000000 = AG47* DeflCE/ 1000000 = AH47* DeflCE/ 1000000 = AI47 = AJ47 = AK47 = AL47 = AM47 = AN47 = AO47 = IF( ISERR( D47/ K47),"", 1000000* D47/ K47) = AF48* DeflCE/ 1000000 = AG48* DeflCE/ 1000000 = AH48* DeflCE/ 1000000 = AI48 = AJ48 = AK48 = AL48 = AM48 = AN48 = AO48 = IF( ISERR( D48/ K48),"", 1000000* D48/ K48)

= AF50* DeflCE/ 1000000 = AG50* DeflCE/ 1000000 = AH50* DeflCE/ 1000000 = AI50 = AJ50 = AK50 = AL50 = AM50 = AN50 = AO50 = IF( ISERR( D50/ K50),"", 1000000* D50/ K50) = AF51* DeflCE/ 1000000 = AG51* DeflCE/ 1000000 = AH51* DeflCE/ 1000000 = AI51 = AJ51 = AK51 = AL51 = AM51 = AN51 = AO51 = IF( ISERR( D51/ K51),"", 1000000* D51/ K51) = AF52* DeflCE/ 1000000 = AG52* DeflCE/ 1000000 = AH52* DeflCE/ 1000000 = AI52 = AJ52 = AK52 = AL52 = AM52 = AN52 = AO52 = IF( ISERR( D52/ K52),"", 1000000* D52/ K52) = AF53* DeflCE/ 1000000 = AG53* DeflCE/ 1000000 = AH53* DeflCE/ 1000000 = AI53 = AJ53 = AK53 = AL53 = AM53 = AN53 = AO53 = IF( ISERR( D53/ K53),"", 1000000* D53/ K53)

= AF55* DeflCE/ 1000000 = AG55* DeflCE/ 1000000 = AH55* DeflCE/ 1000000 = AI55 = AJ55 = AK55 = AL55 = AM55 = AN55 = AO55 = IF( ISERR( D55/ K55),"", 1000000* D55/ K55) = AF56* DeflCE/ 1000000 = AG56* DeflCE/ 1000000 = AH56* DeflCE/ 1000000 = AI56 = AJ56 = AK56 = AL56 = AM56 = AN56 = AO56 = IF( ISERR( D56/ K56),"", 1000000* D56/ K56) = AF57* DeflCE/ 1000000 = AG57* DeflCE/ 1000000 = AH57* DeflCE/ 1000000 = AI57 = AJ57 = AK57 = AL57 = AM57 = AN57 = AO57 = IF( ISERR( D57/ K57),"", 1000000* D57/ K57) = AF58* DeflCE/ 1000000 = AG58* DeflCE/ 1000000 = AH58* DeflCE/ 1000000 = AI58 = AJ58 = AK58 = AL58 = AM58 = AN58 = AO58 = IF( ISERR( D58/ K58),"", 1000000* D58/ K58) Millions of 1981 Dollars Incremental Removals, lbs eq Flow Cutoff for Indirects  Flow Cutoff for Indirects

February 14, 2003 33 of 43 Summary_ July formula. xls  CE Record for the Final Metal Product and Machinery Rule 2 3 45 67 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 S T U V 1 MGY 2 MGY 3 MGY 4 MGY = IF( ISERR( E10/ L10),"", 1000000* E10/ L10) = IF( ISERR( F10/ M10),"", 1000000* F10/ M10) = IF( ISERR( G10/ N10),"", 1000000* G10/ N10) = IF( ISERR( H10/ O10),"", 1000000* H10/ O10) = IF( ISERR( E11/ L11),"", 1000000* E11/ L11) = IF( ISERR( F11/ M11),"", 1000000* F11/ M11) = IF( ISERR( G11/ N11),"", 1000000* G11/ N11) = IF( ISERR( H11/ O11),"", 1000000* H11/ O11) = IF( ISERR( E12/ L12),"", 1000000* E12/ L12) = IF( ISERR( F12/ M12),"", 1000000* F12/ M12) = IF( ISERR( G12/ N12),"", 1000000* G12/ N12) = IF( ISERR( H12/ O12),"", 1000000* H12/ O12) = IF( ISERR( E13/ L13),"", 1000000* E13/ L13) = IF( ISERR( F13/ M13),"", 1000000* F13/ M13) = IF( ISERR( G13/ N13),"", 1000000* G13/ N13) = IF( ISERR( H13/ O13),"", 1000000* H13/ O13)

= IF( ISERR( E15/ L15),"", 1000000* E15/ L15) = IF( ISERR( F15/ M15),"", 1000000* F15/ M15) = IF( ISERR( G15/ N15),"", 1000000* G15/ N15) = IF( ISERR( H15/ O15),"", 1000000* H15/ O15) = IF( ISERR( E16/ L16),"", 1000000* E16/ L16) = IF( ISERR( F16/ M16),"", 1000000* F16/ M16) = IF( ISERR( G16/ N16),"", 1000000* G16/ N16) = IF( ISERR( H16/ O16),"", 1000000* H16/ O16) = IF( ISERR( E17/ L17),"", 1000000* E17/ L17) = IF( ISERR( F17/ M17),"", 1000000* F17/ M17) = IF( ISERR( G17/ N17),"", 1000000* G17/ N17) = IF( ISERR( H17/ O17),"", 1000000* H17/ O17) = IF( ISERR( E18/ L18),"", 1000000* E18/ L18) = IF( ISERR( F18/ M18),"", 1000000* F18/ M18) = IF( ISERR( G18/ N18),"", 1000000* G18/ N18) = IF( ISERR( H18/ O18),"", 1000000* H18/ O18)

= IF( ISERR( E20/ L20),"", 1000000* E20/ L20) = IF( ISERR( F20/ M20),"", 1000000* F20/ M20) = IF( ISERR( G20/ N20),"", 1000000* G20/ N20) = IF( ISERR( H20/ O20),"", 1000000* H20/ O20) = IF( ISERR( E21/ L21),"", 1000000* E21/ L21) = IF( ISERR( F21/ M21),"", 1000000* F21/ M21) = IF( ISERR( G21/ N21),"", 1000000* G21/ N21) = IF( ISERR( H21/ O21),"", 1000000* H21/ O21) = IF( ISERR( E22/ L22),"", 1000000* E22/ L22) = IF( ISERR( F22/ M22),"", 1000000* F22/ M22) = IF( ISERR( G22/ N22),"", 1000000* G22/ N22) = IF( ISERR( H22/ O22),"", 1000000* H22/ O22) = IF( ISERR( E23/ L23),"", 1000000* E23/ L23) = IF( ISERR( F23/ M23),"", 1000000* F23/ M23) = IF( ISERR( G23/ N23),"", 1000000* G23/ N23) = IF( ISERR( H23/ O23),"", 1000000* H23/ O23)

= IF( ISERR( E25/ L25),"", 1000000* E25/ L25) = IF( ISERR( F25/ M25),"", 1000000* F25/ M25) = IF( ISERR( G25/ N25),"", 1000000* G25/ N25) = IF( ISERR( H25/ O25),"", 1000000* H25/ O25) = IF( ISERR( E26/ L26),"", 1000000* E26/ L26) = IF( ISERR( F26/ M26),"", 1000000* F26/ M26) = IF( ISERR( G26/ N26),"", 1000000* G26/ N26) = IF( ISERR( H26/ O26),"", 1000000* H26/ O26) = IF( ISERR( E27/ L27),"", 1000000* E27/ L27) = IF( ISERR( F27/ M27),"", 1000000* F27/ M27) = IF( ISERR( G27/ N27),"", 1000000* G27/ N27) = IF( ISERR( H27/ O27),"", 1000000* H27/ O27) = IF( ISERR( E28/ L28),"", 1000000* E28/ L28) = IF( ISERR( F28/ M28),"", 1000000* F28/ M28) = IF( ISERR( G28/ N28),"", 1000000* G28/ N28) = IF( ISERR( H28/ O28),"", 1000000* H28/ O28)

= IF( ISERR( E30/ L30),"", 1000000* E30/ L30) = IF( ISERR( F30/ M30),"", 1000000* F30/ M30) = IF( ISERR( G30/ N30),"", 1000000* G30/ N30) = IF( ISERR( H30/ O30),"", 1000000* H30/ O30) = IF( ISERR( E31/ L31),"", 1000000* E31/ L31) = IF( ISERR( F31/ M31),"", 1000000* F31/ M31) = IF( ISERR( G31/ N31),"", 1000000* G31/ N31) = IF( ISERR( H31/ O31),"", 1000000* H31/ O31) = IF( ISERR( E32/ L32),"", 1000000* E32/ L32) = IF( ISERR( F32/ M32),"", 1000000* F32/ M32) = IF( ISERR( G32/ N32),"", 1000000* G32/ N32) = IF( ISERR( H32/ O32),"", 1000000* H32/ O32) = IF( ISERR( E33/ L33),"", 1000000* E33/ L33) = IF( ISERR( F33/ M33),"", 1000000* F33/ M33) = IF( ISERR( G33/ N33),"", 1000000* G33/ N33) = IF( ISERR( H33/ O33),"", 1000000* H33/ O33)

= IF( ISERR( E35/ L35),"", 1000000* E35/ L35) = IF( ISERR( F35/ M35),"", 1000000* F35/ M35) = IF( ISERR( G35/ N35),"", 1000000* G35/ N35) = IF( ISERR( H35/ O35),"", 1000000* H35/ O35) = IF( ISERR( E36/ L36),"", 1000000* E36/ L36) = IF( ISERR( F36/ M36),"", 1000000* F36/ M36) = IF( ISERR( G36/ N36),"", 1000000* G36/ N36) = IF( ISERR( H36/ O36),"", 1000000* H36/ O36) = IF( ISERR( E37/ L37),"", 1000000* E37/ L37) = IF( ISERR( F37/ M37),"", 1000000* F37/ M37) = IF( ISERR( G37/ N37),"", 1000000* G37/ N37) = IF( ISERR( H37/ O37),"", 1000000* H37/ O37) = IF( ISERR( E38/ L38),"", 1000000* E38/ L38) = IF( ISERR( F38/ M38),"", 1000000* F38/ M38) = IF( ISERR( G38/ N38),"", 1000000* G38/ N38) = IF( ISERR( H38/ O38),"", 1000000* H38/ O38)

= IF( ISERR( E40/ L40),"", 1000000* E40/ L40) = IF( ISERR( F40/ M40),"", 1000000* F40/ M40) = IF( ISERR( G40/ N40),"", 1000000* G40/ N40) = IF( ISERR( H40/ O40),"", 1000000* H40/ O40) = IF( ISERR( E41/ L41),"", 1000000* E41/ L41) = IF( ISERR( F41/ M41),"", 1000000* F41/ M41) = IF( ISERR( G41/ N41),"", 1000000* G41/ N41) = IF( ISERR( H41/ O41),"", 1000000* H41/ O41) = IF( ISERR( E42/ L42),"", 1000000* E42/ L42) = IF( ISERR( F42/ M42),"", 1000000* F42/ M42) = IF( ISERR( G42/ N42),"", 1000000* G42/ N42) = IF( ISERR( H42/ O42),"", 1000000* H42/ O42) = IF( ISERR( E43/ L43),"", 1000000* E43/ L43) = IF( ISERR( F43/ M43),"", 1000000* F43/ M43) = IF( ISERR( G43/ N43),"", 1000000* G43/ N43) = IF( ISERR( H43/ O43),"", 1000000* H43/ O43)

= IF( ISERR( E45/ L45),"", 1000000* E45/ L45) = IF( ISERR( F45/ M45),"", 1000000* F45/ M45) = IF( ISERR( G45/ N45),"", 1000000* G45/ N45) = IF( ISERR( H45/ O45),"", 1000000* H45/ O45) = IF( ISERR( E46/ L46),"", 1000000* E46/ L46) = IF( ISERR( F46/ M46),"", 1000000* F46/ M46) = IF( ISERR( G46/ N46),"", 1000000* G46/ N46) = IF( ISERR( H46/ O46),"", 1000000* H46/ O46) = IF( ISERR( E47/ L47),"", 1000000* E47/ L47) = IF( ISERR( F47/ M47),"", 1000000* F47/ M47) = IF( ISERR( G47/ N47),"", 1000000* G47/ N47) = IF( ISERR( H47/ O47),"", 1000000* H47/ O47) = IF( ISERR( E48/ L48),"", 1000000* E48/ L48) = IF( ISERR( F48/ M48),"", 1000000* F48/ M48) = IF( ISERR( G48/ N48),"", 1000000* G48/ N48) = IF( ISERR( H48/ O48),"", 1000000* H48/ O48)

= IF( ISERR( E50/ L50),"", 1000000* E50/ L50) = IF( ISERR( F50/ M50),"", 1000000* F50/ M50) = IF( ISERR( G50/ N50),"", 1000000* G50/ N50) = IF( ISERR( H50/ O50),"", 1000000* H50/ O50) = IF( ISERR( E51/ L51),"", 1000000* E51/ L51) = IF( ISERR( F51/ M51),"", 1000000* F51/ M51) = IF( ISERR( G51/ N51),"", 1000000* G51/ N51) = IF( ISERR( H51/ O51),"", 1000000* H51/ O51) = IF( ISERR( E52/ L52),"", 1000000* E52/ L52) = IF( ISERR( F52/ M52),"", 1000000* F52/ M52) = IF( ISERR( G52/ N52),"", 1000000* G52/ N52) = IF( ISERR( H52/ O52),"", 1000000* H52/ O52) = IF( ISERR( E53/ L53),"", 1000000* E53/ L53) = IF( ISERR( F53/ M53),"", 1000000* F53/ M53) = IF( ISERR( G53/ N53),"", 1000000* G53/ N53) = IF( ISERR( H53/ O53),"", 1000000* H53/ O53)

= IF( ISERR( E55/ L55),"", 1000000* E55/ L55) = IF( ISERR( F55/ M55),"", 1000000* F55/ M55) = IF( ISERR( G55/ N55),"", 1000000* G55/ N55) = IF( ISERR( H55/ O55),"", 1000000* H55/ O55) = IF( ISERR( E56/ L56),"", 1000000* E56/ L56) = IF( ISERR( F56/ M56),"", 1000000* F56/ M56) = IF( ISERR( G56/ N56),"", 1000000* G56/ N56) = IF( ISERR( H56/ O56),"", 1000000* H56/ O56) = IF( ISERR( E57/ L57),"", 1000000* E57/ L57) = IF( ISERR( F57/ M57),"", 1000000* F57/ M57) = IF( ISERR( G57/ N57),"", 1000000* G57/ N57) = IF( ISERR( H57/ O57),"", 1000000* H57/ O57) = IF( ISERR( E58/ L58),"", 1000000* E58/ L58) = IF( ISERR( F58/ M58),"", 1000000* F58/ M58) = IF( ISERR( G58/ N58),"", 1000000* G58/ N58) = IF( ISERR( H58/ O58),"", 1000000* H58/ O58) Cost Effectiveness Ratio, $/ lb eq Flow Cutoff for Indirects

February 14, 2003 34 of 43 Summary_ July formula. xls  CE Record for the Final Metal Product and Machinery Rule 2 3 45 67 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 W X 5 MGY 6.25 MGY = IF( ISERR( I10/ P10),"", 1000000* I10/ P10) = IF( ISERR( J10/ Q10),"", 1000000* J10/ Q10) = IF( ISERR( I11/ P11),"", 1000000* I11/ P11) = IF( ISERR( J11/ Q11),"", 1000000* J11/ Q11) = IF( ISERR( I12/ P12),"", 1000000* I12/ P12) = IF( ISERR( J12/ Q12),"", 1000000* J12/ Q12) = IF( ISERR( I13/ P13),"", 1000000* I13/ P13) = IF( ISERR( J13/ Q13),"", 1000000* J13/ Q13)

= IF( ISERR( I15/ P15),"", 1000000* I15/ P15) = IF( ISERR( J15/ Q15),"", 1000000* J15/ Q15) = IF( ISERR( I16/ P16),"", 1000000* I16/ P16) = IF( ISERR( J16/ Q16),"", 1000000* J16/ Q16) = IF( ISERR( I17/ P17),"", 1000000* I17/ P17) = IF( ISERR( J17/ Q17),"", 1000000* J17/ Q17) = IF( ISERR( I18/ P18),"", 1000000* I18/ P18) = IF( ISERR( J18/ Q18),"", 1000000* J18/ Q18)

= IF( ISERR( I20/ P20),"", 1000000* I20/ P20) = IF( ISERR( J20/ Q20),"", 1000000* J20/ Q20) = IF( ISERR( I21/ P21),"", 1000000* I21/ P21) = IF( ISERR( J21/ Q21),"", 1000000* J21/ Q21) = IF( ISERR( I22/ P22),"", 1000000* I22/ P22) = IF( ISERR( J22/ Q22),"", 1000000* J22/ Q22) = IF( ISERR( I23/ P23),"", 1000000* I23/ P23) = IF( ISERR( J23/ Q23),"", 1000000* J23/ Q23)

= IF( ISERR( I25/ P25),"", 1000000* I25/ P25) = IF( ISERR( J25/ Q25),"", 1000000* J25/ Q25) = IF( ISERR( I26/ P26),"", 1000000* I26/ P26) = IF( ISERR( J26/ Q26),"", 1000000* J26/ Q26) = IF( ISERR( I27/ P27),"", 1000000* I27/ P27) = IF( ISERR( J27/ Q27),"", 1000000* J27/ Q27) = IF( ISERR( I28/ P28),"", 1000000* I28/ P28) = IF( ISERR( J28/ Q28),"", 1000000* J28/ Q28)

= IF( ISERR( I30/ P30),"", 1000000* I30/ P30) = IF( ISERR( J30/ Q30),"", 1000000* J30/ Q30) = IF( ISERR( I31/ P31),"", 1000000* I31/ P31) = IF( ISERR( J31/ Q31),"", 1000000* J31/ Q31) = IF( ISERR( I32/ P32),"", 1000000* I32/ P32) = IF( ISERR( J32/ Q32),"", 1000000* J32/ Q32) = IF( ISERR( I33/ P33),"", 1000000* I33/ P33) = IF( ISERR( J33/ Q33),"", 1000000* J33/ Q33)

= IF( ISERR( I35/ P35),"", 1000000* I35/ P35) = IF( ISERR( J35/ Q35),"", 1000000* J35/ Q35) = IF( ISERR( I36/ P36),"", 1000000* I36/ P36) = IF( ISERR( J36/ Q36),"", 1000000* J36/ Q36) = IF( ISERR( I37/ P37),"", 1000000* I37/ P37) = IF( ISERR( J37/ Q37),"", 1000000* J37/ Q37) = IF( ISERR( I38/ P38),"", 1000000* I38/ P38) = IF( ISERR( J38/ Q38),"", 1000000* J38/ Q38)

= IF( ISERR( I40/ P40),"", 1000000* I40/ P40) = IF( ISERR( J40/ Q40),"", 1000000* J40/ Q40) = IF( ISERR( I41/ P41),"", 1000000* I41/ P41) = IF( ISERR( J41/ Q41),"", 1000000* J41/ Q41) = IF( ISERR( I42/ P42),"", 1000000* I42/ P42) = IF( ISERR( J42/ Q42),"", 1000000* J42/ Q42) = IF( ISERR( I43/ P43),"", 1000000* I43/ P43) = IF( ISERR( J43/ Q43),"", 1000000* J43/ Q43)

= IF( ISERR( I45/ P45),"", 1000000* I45/ P45) = IF( ISERR( J45/ Q45),"", 1000000* J45/ Q45) = IF( ISERR( I46/ P46),"", 1000000* I46/ P46) = IF( ISERR( J46/ Q46),"", 1000000* J46/ Q46) = IF( ISERR( I47/ P47),"", 1000000* I47/ P47) = IF( ISERR( J47/ Q47),"", 1000000* J47/ Q47) = IF( ISERR( I48/ P48),"", 1000000* I48/ P48) = IF( ISERR( J48/ Q48),"", 1000000* J48/ Q48)

= IF( ISERR( I50/ P50),"", 1000000* I50/ P50) = IF( ISERR( J50/ Q50),"", 1000000* J50/ Q50) = IF( ISERR( I51/ P51),"", 1000000* I51/ P51) = IF( ISERR( J51/ Q51),"", 1000000* J51/ Q51) = IF( ISERR( I52/ P52),"", 1000000* I52/ P52) = IF( ISERR( J52/ Q52),"", 1000000* J52/ Q52) = IF( ISERR( I53/ P53),"", 1000000* I53/ P53) = IF( ISERR( J53/ Q53),"", 1000000* J53/ Q53)

= IF( ISERR( I55/ P55),"", 1000000* I55/ P55) = IF( ISERR( J55/ Q55),"", 1000000* J55/ Q55) = IF( ISERR( I56/ P56),"", 1000000* I56/ P56) = IF( ISERR( J56/ Q56),"", 1000000* J56/ Q56) = IF( ISERR( I57/ P57),"", 1000000* I57/ P57) = IF( ISERR( J57/ Q57),"", 1000000* J57/ Q57) = IF( ISERR( I58/ P58),"", 1000000* I58/ P58) = IF( ISERR( J58/ Q58),"", 1000000* J58/ Q58)

February 14, 2003 35 of 43 Summary_ July formula. xls  CE Record for the Final Metal Product and Machinery Rule 1 23456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 A B C D E F Closures by Subcat and by Discharge Type  Proposed/ NODA Option Small Total Small Total Small Printed Wiring Board = DSUM( Data," Weight", Crit226) = DSUM( Data," Weight", Crit228) = DSUM( Data," Weight", Crit260) = DSUM( Data," Weight", Crit262) = DSUM( Data," Weight", Crit292) MF Job Shop = DSUM( Data," Weight", Crit230) = DSUM( Data," Weight", Crit232) = DSUM( Data," Weight", Crit264) = DSUM( Data," Weight", Crit266) = DSUM( Data," Weight", Crit296) General Metals = DSUM( Data," Weight", Crit234) = DSUM( Data," Weight", Crit236) = DSUM( Data," Weight", Crit268) = DSUM( Data," Weight", Crit270) = DSUM( Data," Weight", Crit300) NonChromium Anodizer = DSUM( Data," Weight", Crit238) = DSUM( Data," Weight", Crit240) = DSUM( Data," Weight", Crit272) = DSUM( Data," Weight", Crit274) = DSUM( Data," Weight", Crit304) Oily Only = DSUM( Data," Weight", Crit243) = DSUM( Data," Weight", Crit245) = DSUM( Data," Weight", Crit276) = DSUM( Data," Weight", Crit278) = DSUM( Data," Weight", Crit308) RR Line Maintenance = DSUM( Data," Weight", Crit247) = DSUM( Data," Weight", Crit249) = DSUM( Data," Weight", Crit280) = DSUM( Data," Weight", Crit282) = DSUM( Data," Weight", Crit312) Drydocks = DSUM( Data," Weight", Crit251) = DSUM( Data," Weight", Crit253) = DSUM( Data," Weight", Crit284) = DSUM( Data," Weight", Crit286) = DSUM( Data," Weight", Crit316) Iron & Steel = DSUM( Data," Weight", Crit255) = DSUM( Data," Weight", Crit257) = DSUM( Data," Weight", Crit288) = DSUM( Data," Weight", Crit290) = DSUM( Data," Weight", Crit320) All Categories = SUM( B5: B12) = SUM( C5: C12) = SUM( D5: D12) = SUM( E5: E12) = SUM( F5: F12)

Small Total Small Total Small Printed Wiring Board = DSUM( Data," Weight", Crit227) = DSUM( Data," Weight", Crit229) = DSUM( Data," Weight", Crit261) = DSUM( Data," Weight", Crit263) = DSUM( Data," Weight", Crit293) MF Job Shop = DSUM( Data," Weight", Crit231) = DSUM( Data," Weight", Crit233) = DSUM( Data," Weight", Crit265) = DSUM( Data," Weight", Crit267) = DSUM( Data," Weight", Crit297) General Metals = DSUM( Data," Weight", Crit235) = DSUM( Data," Weight", Crit237) = DSUM( Data," Weight", Crit269) = DSUM( Data," Weight", Crit271) = DSUM( Data," Weight", Crit301) NonChromium Anodizer = DSUM( Data," Weight", Crit239) = DSUM( Data," Weight", Crit241) = DSUM( Data," Weight", Crit273) = DSUM( Data," Weight", Crit275) = DSUM( Data," Weight", Crit305) Oily Only = DSUM( Data," Weight", Crit244) = DSUM( Data," Weight", Crit246) = DSUM( Data," Weight", Crit277) = DSUM( Data," Weight", Crit279) = DSUM( Data," Weight", Crit309) RR Line Maintenance = DSUM( Data," Weight", Crit248) = DSUM( Data," Weight", Crit250) = DSUM( Data," Weight", Crit281) = DSUM( Data," Weight", Crit283) = DSUM( Data," Weight", Crit313) Drydocks = DSUM( Data," Weight", Crit252) = DSUM( Data," Weight", Crit254) = DSUM( Data," Weight", Crit285) = DSUM( Data," Weight", Crit287) = DSUM( Data," Weight", Crit317) Iron & Steel = DSUM( Data," Weight", Crit256) = DSUM( Data," Weight", Crit258) = DSUM( Data," Weight", Crit289) = DSUM( Data," Weight", Crit291) = DSUM( Data," Weight", Crit321) All Categories = SUM( B17: B24) = SUM( C17: C24) = SUM( D17: D24) = SUM( E17: E24) = SUM( F17: F24)

Totals = B13+ B25 = C13+ C25 = D13+ D25 = E13+ E25 = F13+ F25 Indirect Dischargers Direct Dischargers Incremental Closures Total Number of Facilities Baseline Closures Incremental Closures Total Number of Facilities Baseline Closures February 14, 2003 36 of 43 Summary_ July formula. xls  Closures Record for the Final Metal Product and Machinery Rule 1 23456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 G Total = DSUM( Data," Weight", Crit294) = DSUM( Data," Weight", Crit298) = DSUM( Data," Weight", Crit302) = DSUM( Data," Weight", Crit306) = DSUM( Data," Weight", Crit310) = DSUM( Data," Weight", Crit314) = DSUM( Data," Weight", Crit318) = DSUM( Data," Weight", Crit322) = SUM( G5: G12)

Total = DSUM( Data," Weight", Crit295) = DSUM( Data," Weight", Crit299) = DSUM( Data," Weight", Crit303) = DSUM( Data," Weight", Crit307) = DSUM( Data," Weight", Crit311) = DSUM( Data," Weight", Crit315) = DSUM( Data," Weight", Crit319) = DSUM( Data," Weight", Crit323) = SUM( G17: G24)

= G13+ G25 Incremental Closures Incremental Closures February 14, 2003 37 of 43 Summary_ July formula. xls  Closures Record for the Final Metal Product and Machinery Rule 1 2 3 4 56789 10 11 12 13 14 16 A B C D E F G H I Private Compliance Costs  After Tax Includes Closures Excludes Closures Proposed/ NODA Option Direct Indirect Total Proposed/ NODA Option Direct Indirect Total =+ Data!$ AY$ 13 = DSUM( Data," C1", Crit100) = DSUM( Data," C1", Crit101) = SUM( B7: C7) =+ Data!$ AY$ 13 = DSUM( Data," C1", Crit120) = DSUM( Data," C1", Crit121) = SUM( G7: H7) =+ Data!$ AY$ 8 = DSUM( Data," C1", Crit102) = DSUM( Data," C1", Crit103) = SUM( B8: C8) =+ Data!$ AY$ 8 = DSUM( Data," C1", Crit122) = DSUM( Data," C1", Crit123) = SUM( G8: H8) =+ Data!$ AY$ 10 = DSUM( Data," C1", Crit104) = DSUM( Data," C1", Crit105) = SUM( B9: C9) =+ Data!$ AY$ 10 = DSUM( Data," C1", Crit124) = DSUM( Data," C1", Crit125) = SUM( G9: H9) =+ Data!$ AY$ 11 = DSUM( Data," C1", Crit106) = DSUM( Data," C1", Crit107) = SUM( B10: C10) =+ Data!$ AY$ 11 = DSUM( Data," C1", Crit126) = DSUM( Data," C1", Crit127) = SUM( G10: H10) =+ Data!$ AY$ 12 = DSUM( Data," C1", Crit108) = DSUM( Data," C1", Crit109) = SUM( B11: C11) =+ Data!$ AY$ 12 = DSUM( Data," C1", Crit128) = DSUM( Data," C1", Crit129) = SUM( G11: H11) =+ Data!$ AY$ 14 = DSUM( Data," C1", Crit110) = DSUM( Data," C1", Crit111) = SUM( B12: C12) =+ Data!$ AY$ 14 = DSUM( Data," C1", Crit130) = DSUM( Data," C1", Crit131) = SUM( G12: H12) =+ Data!$ AY$ 15 = DSUM( Data," C1", Crit112) = DSUM( Data," C1", Crit113) = SUM( B13: C13) =+ Data!$ AY$ 15 = DSUM( Data," C1", Crit132) = DSUM( Data," C1", Crit133) = SUM( G13: H13) =+ Data!$ AY$ 7 = DSUM( Data," C1", Crit114) = DSUM( Data," C1", Crit115) = SUM( B14: C14) =+ Data!$ AY$ 7 = DSUM( Data," C1", Crit134) = DSUM( Data," C1", Crit135) = SUM( G14: H14) Total = SUM( B7: B15) = SUM( C5: C7) = SUM( D7: D15) Total = SUM( G7: G15) = SUM( H7: H15) = SUM( I7: I15)

February 14, 2003 38 of 43 Summary_ July formula. xls  Pvt_ Costs Record for the Final Metal Product and Machinery Rule 1 2 3 4 56789 10 A B C D Social Costs of the MP& M Rule Based on a 7 percent discount rate Proposed/ NODA Option Cost Category Low Mid High Resource Value of Compliance Costs ( pre tax) = Comp_ Costs!$ B$ 5 = Comp_ Costs!$ B$ 5 = Comp_ Costs!$ B$ 5 Government Administrative Costs ='[ AD MP& M12. xls] Summary'!$ D$ 17 ='[ AD MP& M12. xls] Summary'!$ C$ 17 ='[ AD MP& M12. xls] Summary'!$ B$ 17 Social Costs of Unemployment = SC_ Unemp! B19 = SC_ Unemp! C19 = SC_ Unemp! D19 Total Monetized Costs = SUM( B7: B9) = SUM( C7: C9) = SUM( D7: D9)

February 14, 2003 39 of 43 Summary_ July formula. xls  Soc_ Cost Record for the Final Metal Product and Machinery Rule 1 2 3 456789 10 11 12 14 15 16 17 18 19 20 21 A B C D E Resource Value of Compliance Costs ( 2001$) Pre Tax Including the Cost to Facilities Which Close Excluding the Cost to Facilities Which Close Option 1 = DSUM( Data," PTCC1", Crit180) Option 1 = DSUM( Data," PPCC1", Crit180) Option 2 = DSUM( Data," PTCC2", Crit180) Option 2 = DSUM( Data," PPCC2", Crit180) Option 3 = DSUM( Data," PTCC3", Crit180) Option 3 = DSUM( Data," PPCC3", Crit180) Option 4 = DSUM( Data," PTCC4", Crit180) Option 4 = DSUM( Data," PPCC4", Crit180)

Option 1 Direct Indirect Total = Data!$ AY$ 10 = DSUM( Data," PTCC1", Crit104) = DSUM( Data," PTCC1", Crit105) = SUM( B12: C12) = Data!$ AY$ 8 = DSUM( Data," PTCC1", Crit102) = DSUM( Data," PTCC1", Crit103) = SUM( B14: C14) = Data!$ AY$ 11 = DSUM( Data," PTCC1", Crit106) = DSUM( Data," PTCC1", Crit107) = SUM( B15: C15) = Data!$ AY$ 12 = DSUM( Data," PTCC1", Crit108) = DSUM( Data," PTCC1", Crit109) = SUM( B16: C16) = Data!$ AY$ 13 = DSUM( Data," PTCC1", Crit100) = DSUM( Data," PTCC1", Crit101) = SUM( B17: C17) = Data!$ AY$ 14 = DSUM( Data," PTCC1", Crit110) = DSUM( Data," PTCC1", Crit111) = SUM( B18: C18) = Data!$ AY$ 15 = DSUM( Data," PTCC1", Crit112) = DSUM( Data," PTCC1", Crit113) = SUM( B19: C19) = Data!$ AY$ 7 = DSUM( Data," PTCC1", Crit114) = DSUM( Data," PTCC1", Crit115) = SUM( B20: C20) Total = SUM( B12: B20) = SUM( C12: C20) = SUM( B21: C21)

February 14, 2003 40 of 43 Summary_ July formula. xls  Comp_ Costs 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 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 A B C D E Social Cost of Unemployment  Net Impacts over 15 Years Only Option 1 has no net job losses  methodology used for this option is different Based on a 7 percent discount rate Administrative cost per job lost = 93.25*( 154.9/ 118.5)

MP& M Industry Production = 33508*( 154.8/ 135.4)

WTP for avoiding involuntary unemployment Low Mid High = B7* 2.5 =( A11+ C11)/ 2 = B7* 3.3 Option 1 Low Mid High Social Cost of Unemployment = B21* A11 = B21* B11 = B21* C11 Annualized SC of Unemp. = PMT( 0.07,15, B15) = PMT( 0.07,15, C15) = PMT( 0.07,15, D15) Admin. Cost of Unemployment = B21*$ B$ 5 = B21*$ B$ 5 = B21*$ B$ 5 Annualized Admin. Cost = PMT( 0.07,15, B17) = PMT( 0.07,15, C17) = PMT( 0.07,15, D17) Total SC of Unemployment = B16+ B18 = C16+ C18 = D16+ D18 Net Job losses = IF( E41>'= 0,0, E41) Gross Job losses = D41 Option 1 Year One Time Manufacturing & Installation Annual O& M Closures Net Change in Employment 1 =(( LaborCost!$ D$ 18+ LaborCost!$ D$ 19)/ 3) = LaborCost!$ E$ 20/ 3 =' Job Losses'!$ C$ 15/ 3 = B26+ C26 D26 2 =(( LaborCost!$ D$ 18+ LaborCost!$ D$ 19)/ 3) = LaborCost!$ E$ 20*( 2/ 3) =' Job Losses'!$ C$ 15/ 3 = B27+ C27 D27 3 =(( LaborCost!$ D$ 18+ LaborCost!$ D$ 19)/ 3) = LaborCost!$ E$ 20 =' Job Losses'!$ C$ 15/ 3 = B28+ C28 D28 4 = LaborCost!$ E$ 20 = B29+ C29 D29 5 = LaborCost!$ E$ 20 = B30+ C30 D30 6 = LaborCost!$ E$ 20 = B31+ C31 D31 7 = LaborCost!$ E$ 20 = B32+ C32 D32 8 = LaborCost!$ E$ 20 = B33+ C33 D33 9 = LaborCost!$ E$ 20 = B34+ C34 D34 10 = LaborCost!$ E$ 20 = B35+ C35 D35 11 = LaborCost!$ E$ 20 = B36+ C36 D36 12 = LaborCost!$ E$ 20 = B37+ C37 D37 13 = LaborCost!$ E$ 20 = B38+ C38 D38 14 = LaborCost!$ E$ 20 = B39+ C39 D39 15 = LaborCost!$ E$ 20 = B40+ C40 D40 Total FTE years over 15 years = SUM( B26: B40) = SUM( C26: C40) = SUM( D26: D40) = SUM( E26: E40)

February 14, 2003 41 of 43 Summary_ July formula. xls  SC_ Unemp 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 A B C D E Employment Generation Effects Labor Share of Equipment 0.30632 Hourly Wage Rate ( 2001$) = 29.67* 153.5/ 131.3 Work Hours Per Year 2,000 Components of Capital Costs by Regulatory Option Cost Type Option 1 Equipment Manufacturing Costs = B10 B9 B8 Shipping Costs = B10* 0.2 Installation Costs = B12* 0.07 Installed Direct Capital Costs = B12/ 1.476 Indirect Costs = B10* 0.476 Total Installed Capital Costs = DSUM( Data," Cap 1", Crit180)

Direct Labor Effects from Compliance Equipment  Option 1 Labor Cost Component Direct Labor Requirements One time basis Annual basis One time basis Annual basis Equipment Manufacturing = B7* Labor = B18/( Wage* Hours) Installation = B9 = B19/( Wage* Hours) Operation = DSUM( Data," Ann 1", Crit180)* 0.01 = C20/( Wage* Hours)

February 14, 2003 42 of 43 Summary_ July formula. xls  LaborCost Record for the Final Metal Product and Machinery Rule 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 A B C D Employment and Revenue Losses for Post Compliance Closures Job Losses from Regulatory Closures Proposed/ NODA Option Subcategory Baseline Job Losses % of Total =+ Data!$ AY$ 10 = DSUM( Data," wFTE", Crit57)+ DSUM( Data," wFTE", crit82) = DSUM( Data," wFTE", crit455)+ DSUM( Data," wFTE", crit461) = C7/$ B7 =+ Data!$ AY$ 8 = DSUM( Data," wFTE", Crit53) = DSUM( Data," wFTE", crit454) = C8/$ B8 =+ Data!$ AY$ 11 = DSUM( Data," wFTE", Crit61) = DSUM( Data," wFTE", crit456) = C9/$ B9 =+ Data!$ AY$ 12 = DSUM( Data," wFTE", Crit65) = DSUM( Data," wFTE", crit457) = C10/$ B10 =+ Data!$ AY$ 13 = DSUM( Data," wFTE", Crit49) = DSUM( Data," wFTE", crit453) = C11/$ B11 =+ Data!$ AY$ 14 = DSUM( Data," wFTE", Crit69) = DSUM( Data," wFTE", crit458) 0.0% =+ Data!$ AY$ 15 = DSUM( Data," wFTE", Crit73) = DSUM( Data," wFTE", crit459) = C13/$ B13 = Data! AY7 = DSUM( Data," wFTE", Crit77) = DSUM( Data," wFTE", crit460) = C14/$ B14 All Subcategories = SUM( B7: B14) = SUM( C7: C14) = C15/$ B15 February 14, 2003 43 of 43 Summary_ July formula. xls  Job Losses