Record for the Final Metal Product and Machinery Rule 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 A B C D E F G Constants and Other Numeric Values PPI96 127.3 PPI for industrial commodities, 1996; http:// www. bls. gov/ ppi/ PPI97 127.7 PPI for industrial commodities, 1997; http:// www. bls. gov/ ppi/ PPI98 124.8 PPI for industrial commodities, 1998; http:// www. bls. gov/ ppi/ PPI99 126.5 PPI for industrial commodities, 1999; http:// www. bls. gov/ ppi/ PPI00 134.8 PPI for industrial commodities, 2000; http:// www. bls. gov/ ppi/ PPI01 135.7 PPI for industrial commodities, 2001; http:// www. bls. gov/ ppi/

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

Defl = CCI01/ CCI96 Cost adjustment from 1996$ to 2001$ I& S_ Defl = CCI01/ CCI97 Cost adjustment from 1997$ to 2001$ DeflCE = CCI81/ CCI01 Cost adjustment from 2001$ to 1981$

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

February 14, 2003 3 of 66 Summary_ Final 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 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 = DSUM( Data," W1", Crit49) = DSUM( Data," W1", Crit50) =+ AB11+ N11 =+ AC11+ O11 =+ AD11+ P11 =+ AE11 = DSUM( Data," W2", Crit49) = DSUM( Data," W2", Crit50) =+ AB12+ N12 =+ AC12+ O12 =+ AD12+ P12 =+ AE12 = DSUM( Data," W3", Crit49) = DSUM( Data," W3", Crit50) =+ AB13+ N13 =+ AC13+ O13 =+ AD13+ P13 =+ AE13 = DSUM( Data," W4", Crit49) = DSUM( Data," W4", Crit50) = DSUM( Data," Weight", Crit53) = DSUM( Data," Weight", Crit54) =+ AB15+ N15 =+ AC15+ O15 =+ AD15+ P15 =+ AE15 = DSUM( Data," W1", Crit53) = DSUM( Data," W1", Crit54) =+ AB16+ N16 =+ AC16+ O16 =+ AD16+ P16 =+ AE16 = DSUM( Data," W2", Crit53) = DSUM( Data," W2", Crit54) =+ AB17+ N17 =+ AC17+ O17 =+ AD17+ P17 =+ AE17 = DSUM( Data," W3", Crit53) = DSUM( Data," W3", Crit54) =+ AB18+ N18 =+ AC18+ O18 =+ AD18+ P18 =+ AE18 = DSUM( Data," W4", Crit53) = DSUM( Data," W4", Crit54) = DSUM( Data," Weight", Crit57) = DSUM( Data," Weight", Crit58) =+ AB20+ N20 =+ AC20+ O20 =+ AD20+ P20 =+ AE20 = DSUM( Data," W1", Crit57) = DSUM( Data," W1", Crit58) =+ AB21+ N21 =+ AC21+ O21 =+ AD21+ P21 =+ AE21 = DSUM( Data," W2", Crit57) = DSUM( Data," W2", Crit58) =+ AB22+ N22 =+ AC22+ O22 =+ AD22+ P22 =+ AE22 = DSUM( Data," W3", Crit57) = DSUM( Data," W3", Crit58) =+ AB23+ N23 =+ AC23+ O23 =+ AD23+ P23 =+ AE23 = DSUM( Data," W4", Crit57) = DSUM( Data," W4", Crit58) = DSUM( Data," Weight", Crit61) = DSUM( Data," Weight", Crit62) =+ AB25+ N25 =+ AC25+ O25 =+ AD25+ P25 =+ AE25 = DSUM( Data," W1", Crit61) = DSUM( Data," W1", Crit62) =+ AB26+ N26 =+ AC26+ O26 =+ AD26+ P26 =+ AE26 = DSUM( Data," W2", Crit61) = DSUM( Data," W2", Crit62) =+ AB27+ N27 =+ AC27+ O27 =+ AD27+ P27 =+ AE27 = DSUM( Data," W3", Crit61) = DSUM( Data," W3", Crit62) =+ AB28+ N28 =+ AC28+ O28 =+ AD28+ P28 =+ AE28 = DSUM( Data," W4", Crit61) = DSUM( Data," W4", Crit62) = DSUM( Data," Weight", Crit65) = DSUM( Data," Weight", Crit66) =+ AB30+ N30 =+ AC30+ O30 =+ AD30+ P30 =+ AE30 = DSUM( Data," W1", Crit65) = DSUM( Data," W1", Crit66) =+ AB31+ N31 =+ AC31+ O31 =+ AD31+ P31 =+ AE31 = DSUM( Data," W2", Crit65) = DSUM( Data," W2", Crit66) =+ AB32+ N32 =+ AC32+ O32 =+ AD32+ P32 =+ AE32 = DSUM( Data," W3", Crit65) = DSUM( Data," W3", Crit66) =+ AB33+ N33 =+ AC33+ O33 =+ AD33+ P33 =+ AE33 = DSUM( Data," W4", Crit65) = DSUM( Data," W4", Crit66) = DSUM( Data," Weight", Crit69) = DSUM( Data," Weight", Crit70) =+ AB35+ N35 =+ AC35+ O35 =+ AD35+ P35 =+ AE35 = DSUM( Data," W1", Crit69) = DSUM( Data," W1", Crit70) =+ AB36+ N36 =+ AC36+ O36 =+ AD36+ P36 =+ AE36 = DSUM( Data," W2", Crit69) = DSUM( Data," W2", Crit70) =+ AB37+ N37 =+ AC37+ O37 =+ AD37+ P37 =+ AE37 = DSUM( Data," W3", Crit69) = DSUM( Data," W3", Crit70) =+ AB38+ N38 =+ AC38+ O38 =+ AD38+ P38 =+ AE38 = DSUM( Data," W4", Crit69) = DSUM( Data," W4", Crit70) = DSUM( Data," Weight", Crit73) = DSUM( Data," Weight", Crit74) =+ AB40+ N40 =+ AC40+ O40 =+ AD40+ P40 =+ AE40 = DSUM( Data," W1", Crit73) = DSUM( Data," W1", Crit74) =+ AB41+ N41 =+ AC41+ O41 =+ AD41+ P41 =+ AE41 = DSUM( Data," W2", Crit73) = DSUM( Data," W2", Crit74) =+ AB42+ N42 =+ AC42+ O42 =+ AD42+ P42 =+ AE42 = DSUM( Data," W3", Crit73) = DSUM( Data," W3", Crit74) =+ AB43+ N43 =+ AC43+ O43 =+ AD43+ P43 =+ AE43 = DSUM( Data," W4", Crit73) = DSUM( Data," W4", Crit74) = DSUM( Data," Weight", Crit77) = DSUM( Data," Weight", Crit78) =+ AB45+ N45 =+ AC45+ O45 =+ AD45+ P45 =+ AE45 = DSUM( Data," W1", Crit77) = DSUM( Data," W1", Crit78) =+ AB46+ N46 =+ AC46+ O46 =+ AD46+ P46 =+ AE46 = DSUM( Data," W2", Crit77) = DSUM( Data," W2", Crit78) =+ AB47+ N47 =+ AC47+ O47 =+ AD47+ P47 =+ AE47 = DSUM( Data," W3", Crit77) = DSUM( Data," W3", Crit78) =+ AB48+ N48 =+ AC48+ O48 =+ AD48+ P48 =+ AE48 = DSUM( Data," W4", Crit77) = DSUM( Data," W4", Crit78) = DSUM( Data," Weight", crit82) = DSUM( Data," Weight", crit83) =+ AB50+ N50 =+ AC50+ O50 =+ AD50+ P50 =+ AE50 = DSUM( Data," W1", crit82) = DSUM( Data," W1", crit83) =+ AB51+ N51 =+ AC51+ O51 =+ AD51+ P51 =+ AE51 = DSUM( Data," W2", crit82) = DSUM( Data," W2", crit83) =+ AB52+ N52 =+ AC52+ O52 =+ AD52+ P52 =+ AE52 = DSUM( Data," W3", crit82) = DSUM( Data," W3", crit83) =+ AB53+ N53 =+ AC53+ O53 =+ AD53+ P53 =+ AE53 = 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 = 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 = 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 = 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 = R53+ R48+ R43+ R38+ R33+ R28+ R23+ R18+ R13 = S53+ S48+ S43+ S38+ S33+ S28+ S23+ S18+ S13 Removals ( Pounds Equivalent) Flow Cutoff for Indirects

February 14, 2003 4 of 66 Summary_ Final 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 5 of 66 Summary_ Final 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 6 of 66 Summary_ Final 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 7 of 66 Summary_ Final 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 8 of 66 Summary_ Final 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 Flow Size Specific Total Annualized February 14, 2003 9 of 66 Summary_ Final 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 Total Annualized Pre Tax Compliance Costs Flow Size for Indirects

February 14, 2003 10 of 66 Summary_ Final 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 Annualized Pre Tax Compliance Costs Flow Size for Indirects

February 14, 2003 11 of 66 Summary_ Final formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 A B C D E TOTAL WEIGHTED FACILITIES 0 1 2 3 = Data! CA7 = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A62& BySubcat! B$ 60, Data!$ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySub cat!$ A62& BySubcat! C$ 60, Data!$ E$ 7: $ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySub cat!$ A62& BySubcat! D$ 60, Data!$ E$ 7: $ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySubc at!$ A62& BySubcat! E$ 60, Data!$ E$ 7:$ E $ 889)

= Data! CA8 = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A63& BySubcat! B$ 60, Data!$ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySub cat!$ A63& BySubcat! C$ 60, Data!$ E$ 7: $ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySub cat!$ A63& BySubcat! D$ 60, Data!$ E$ 7: $ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySubc at!$ A63& BySubcat! E$ 60, Data!$ E$ 7:$ E $ 889)

= Data! CA9 = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A64& BySubcat! B$ 60, Data!$ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySub cat!$ A64& BySubcat! C$ 60, Data!$ E$ 7: $ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySub cat!$ A64& BySubcat! D$ 60, Data!$ E$ 7: $ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySubc at!$ A64& BySubcat! E$ 60, Data!$ E$ 7:$ E $ 889)

= Data! CA10 = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A65& BySubcat! B$ 60, Data!$ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySub cat!$ A65& BySubcat! C$ 60, Data!$ E$ 7: $ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySub cat!$ A65& BySubcat! D$ 60, Data!$ E$ 7: $ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySubc at!$ A65& BySubcat! E$ 60, Data!$ E$ 7:$ E $ 889)

= Data! CA11 = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A66& BySubcat! B$ 60, Data!$ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySub cat!$ A66& BySubcat! C$ 60, Data!$ E$ 7: $ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySub cat!$ A66& BySubcat! D$ 60, Data!$ E$ 7: $ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySubc at!$ A66& BySubcat! E$ 60, Data!$ E$ 7:$ E $ 889)

= Data! CA12 = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A67& BySubcat! B$ 60, Data!$ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySub cat!$ A67& BySubcat! C$ 60, Data!$ E$ 7: $ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySub cat!$ A67& BySubcat! D$ 60, Data!$ E$ 7: $ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySubc at!$ A67& BySubcat! E$ 60, Data!$ E$ 7:$ E $ 889)

= Data! CA13 = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A68& BySubcat! B$ 60, Data!$ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySub cat!$ A68& BySubcat! C$ 60, Data!$ E$ 7: $ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySub cat!$ A68& BySubcat! D$ 60, Data!$ E$ 7: $ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySubc at!$ A68& BySubcat! E$ 60, Data!$ E$ 7:$ E $ 889)

= Data! CA14 = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A69& BySubcat! B$ 60, Data!$ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySub cat!$ A69& BySubcat! C$ 60, Data!$ E$ 7: $ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySub cat!$ A69& BySubcat! D$ 60, Data!$ E$ 7: $ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySubc at!$ A69& BySubcat! E$ 60, Data!$ E$ 7:$ E $ 889)

= Data! CA15 = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A70& BySubcat! B$ 60, Data!$ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySub cat!$ A70& BySubcat! C$ 60, Data!$ E$ 7: $ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySub cat!$ A70& BySubcat! D$ 60, Data!$ E$ 7: $ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySubc at!$ A70& BySubcat! E$ 60, Data!$ E$ 7:$ E $ 889) Total = SUM( B62: B70) = SUM( C62: C70) = SUM( D62: D70) = SUM( E62: E70) TOTAL BASELINE CLOSURES = Data! CA7 = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A73& BySubcat! B$ 60, Data!$ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySub cat!$ A73& BySubcat! C$ 60, Data!$ Y$ 6: $ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySub cat!$ A73& BySubcat! D$ 60, Data!$ Y$ 6: $ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySubc at!$ A73& BySubcat! E$ 60, Data!$ Y$ 6:$ Y $ 889)

= Data! CA8 = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A74& BySubcat! B$ 60, Data!$ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySub cat!$ A74& BySubcat! C$ 60, Data!$ Y$ 6: $ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySub cat!$ A74& BySubcat! D$ 60, Data!$ Y$ 6: $ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySubc at!$ A74& BySubcat! E$ 60, Data!$ Y$ 6:$ Y $ 889)

= Data! CA9 = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A75& BySubcat! B$ 60, Data!$ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySub cat!$ A75& BySubcat! C$ 60, Data!$ Y$ 6: $ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySub cat!$ A75& BySubcat! D$ 60, Data!$ Y$ 6: $ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySubc at!$ A75& BySubcat! E$ 60, Data!$ Y$ 6:$ Y $ 889)

= Data! CA10 = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A76& BySubcat! B$ 60, Data!$ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySub cat!$ A76& BySubcat! C$ 60, Data!$ Y$ 6: $ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySub cat!$ A76& BySubcat! D$ 60, Data!$ Y$ 6: $ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySubc at!$ A76& BySubcat! E$ 60, Data!$ Y$ 6:$ Y $ 889)

= Data! CA11 = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A77& BySubcat! B$ 60, Data!$ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySub cat!$ A77& BySubcat! C$ 60, Data!$ Y$ 6: $ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySub cat!$ A77& BySubcat! D$ 60, Data!$ Y$ 6: $ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySubc at!$ A77& BySubcat! E$ 60, Data!$ Y$ 6:$ Y $ 889)

= Data! CA12 = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A78& BySubcat! B$ 60, Data!$ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySub cat!$ A78& BySubcat! C$ 60, Data!$ Y$ 6: $ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySub cat!$ A78& BySubcat! D$ 60, Data!$ Y$ 6: $ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySubc at!$ A78& BySubcat! E$ 60, Data!$ Y$ 6:$ Y $ 889)

= Data! CA13 = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A79& BySubcat! B$ 60, Data!$ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySub cat!$ A79& BySubcat! C$ 60, Data!$ Y$ 6: $ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySub cat!$ A79& BySubcat! D$ 60, Data!$ Y$ 6: $ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySubc at!$ A79& BySubcat! E$ 60, Data!$ Y$ 6:$ Y $ 889)

= Data! CA14 = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A80& BySubcat! B$ 60, Data!$ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySub cat!$ A80& BySubcat! C$ 60, Data!$ Y$ 6: $ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySub cat!$ A80& BySubcat! D$ 60, Data!$ Y$ 6: $ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySubc at!$ A80& BySubcat! E$ 60, Data!$ Y$ 6:$ Y $ 889)

= Data! CA15 = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A81& BySubcat! B$ 60, Data!$ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySub cat!$ A81& BySubcat! C$ 60, Data!$ Y$ 6: $ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySub cat!$ A81& BySubcat! D$ 60, Data!$ Y$ 6: $ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySubc at!$ A81& BySubcat! E$ 60, Data!$ Y$ 6:$ Y $ 889)

February 14, 2003 12 of 66 Summary_ Final formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 F G H I K L 4 5 6 Total Weighted Baseline From Subcat Tables = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A62& BySubcat! F$ 60, Data!$ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A62& BySubcat! G$ 60, Data! $ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySubcat!$ A62& BySubcat! H$ 60, Data!$ E$ 7:$ E$ 889) = SUM( B62: H62) = I62 I73 = VLOOKUP( A62,$ A$ 9:$ B$ 53,2, FALSE) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A63& BySubcat! F$ 60, Data!$ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A63& BySubcat! G$ 60, Data! $ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySubcat!$ A63& BySubcat! H$ 60, Data!$ E$ 7:$ E$ 889) = SUM( B63: H63) = I63 I74 = VLOOKUP( A63,$ A$ 9:$ B$ 53,2, FALSE) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A64& BySubcat! F$ 60, Data!$ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A64& BySubcat! G$ 60, Data! $ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySubcat!$ A64& BySubcat! H$ 60, Data!$ E$ 7:$ E$ 889) = SUM( B64: H64) = I64 I75 = VLOOKUP( A64,$ A$ 9:$ B$ 53,2, FALSE) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A65& BySubcat! F$ 60, Data!$ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A65& BySubcat! G$ 60, Data! $ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySubcat!$ A65& BySubcat! H$ 60, Data!$ E$ 7:$ E$ 889) = SUM( B65: H65) = I65 I76 = VLOOKUP( A65,$ A$ 9:$ B$ 53,2, FALSE) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A66& BySubcat! F$ 60, Data!$ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A66& BySubcat! G$ 60, Data! $ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySubcat!$ A66& BySubcat! H$ 60, Data!$ E$ 7:$ E$ 889) = SUM( B66: H66) = I66 I77 = VLOOKUP( A66,$ A$ 9:$ B$ 53,2, FALSE) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A67& BySubcat! F$ 60, Data!$ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A67& BySubcat! G$ 60, Data! $ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySubcat!$ A67& BySubcat! H$ 60, Data!$ E$ 7:$ E$ 889) = SUM( B67: H67) = I67 I78 = VLOOKUP( A67,$ A$ 9:$ B$ 53,2, FALSE) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A68& BySubcat! F$ 60, Data!$ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A68& BySubcat! G$ 60, Data! $ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySubcat!$ A68& BySubcat! H$ 60, Data!$ E$ 7:$ E$ 889) = SUM( B68: H68) = I68 I79 = VLOOKUP( A68,$ A$ 9:$ B$ 53,2, FALSE) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A69& BySubcat! F$ 60, Data!$ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A69& BySubcat! G$ 60, Data! $ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySubcat!$ A69& BySubcat! H$ 60, Data!$ E$ 7:$ E$ 889) = SUM( B69: H69) = I69 I80 = VLOOKUP( A69,$ A$ 9:$ B$ 53,2, FALSE) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A70& BySubcat! F$ 60, Data!$ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, ByS ubcat!$ A70& BySubcat! G$ 60, Data! $ E$ 7:$ E$ 889) = SUMIF( Data!$ BZ$ 7:$ BZ$ 889, BySubcat!$ A70& BySubcat! H$ 60, Data!$ E$ 7:$ E$ 889) = 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!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A73& BySubcat! F$ 60, Data!$ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A73& BySubcat! G$ 60, Data! $ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySubcat!$ A73& BySubcat! H$ 60, Data!$ Y$ 6:$ Y$ 889) = SUM( B73: H73) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A74& BySubcat! F$ 60, Data!$ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A74& BySubcat! G$ 60, Data! $ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySubcat!$ A74& BySubcat! H$ 60, Data!$ Y$ 6:$ Y$ 889) = SUM( B74: H74) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A75& BySubcat! F$ 60, Data!$ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A75& BySubcat! G$ 60, Data! $ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySubcat!$ A75& BySubcat! H$ 60, Data!$ Y$ 6:$ Y$ 889) = SUM( B75: H75) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A76& BySubcat! F$ 60, Data!$ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A76& BySubcat! G$ 60, Data! $ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySubcat!$ A76& BySubcat! H$ 60, Data!$ Y$ 6:$ Y$ 889) = SUM( B76: H76) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A77& BySubcat! F$ 60, Data!$ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A77& BySubcat! G$ 60, Data! $ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySubcat!$ A77& BySubcat! H$ 60, Data!$ Y$ 6:$ Y$ 889) = SUM( B77: H77) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A78& BySubcat! F$ 60, Data!$ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A78& BySubcat! G$ 60, Data! $ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySubcat!$ A78& BySubcat! H$ 60, Data!$ Y$ 6:$ Y$ 889) = SUM( B78: H78) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A79& BySubcat! F$ 60, Data!$ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A79& BySubcat! G$ 60, Data! $ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySubcat!$ A79& BySubcat! H$ 60, Data!$ Y$ 6:$ Y$ 889) = SUM( B79: H79) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A80& BySubcat! F$ 60, Data!$ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A80& BySubcat! G$ 60, Data! $ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySubcat!$ A80& BySubcat! H$ 60, Data!$ Y$ 6:$ Y$ 889) = SUM( B80: H80) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A81& BySubcat! F$ 60, Data!$ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, ByS ubcat!$ A81& BySubcat! G$ 60, Data! $ Y$ 6:$ Y$ 889) = SUMIF( Data!$ BZ$ 6:$ BZ$ 889, BySubcat!$ A81& BySubcat! H$ 60, Data!$ Y$ 6:$ Y$ 889) = SUM( B81: H81)

February 14, 2003 13 of 66 Summary_ Final formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 M N O P R S = 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 14 of 66 Summary_ Final formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 T U V February 14, 2003 15 of 66 Summary_ Final formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 W X Y February 14, 2003 16 of 66 Summary_ Final formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 Z AA AB February 14, 2003 17 of 66 Summary_ Final formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 AC AD AE February 14, 2003 18 of 66 Summary_ Final formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 AF AG AH February 14, 2003 19 of 66 Summary_ Final formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 AI AJ AK February 14, 2003 20 of 66 Summary_ Final formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 AL AM AN AO AP AQ AR AS February 14, 2003 21 of 66 Summary_ Final formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 81 A B C D E Total = SUM( B73: B81) = SUM( C73: C81) = SUM( D73: D81) = SUM( E73: E81)

February 14, 2003 22 of 66 Summary_ Final formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 81 F G H I K L = SUM( F73: F81) = SUM( G73: G81) = SUM( H73: H81) = SUM( B82: H82)

February 14, 2003 23 of 66 Summary_ Final formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 81 M N O P R S February 14, 2003 24 of 66 Summary_ Final formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 81 T U V February 14, 2003 25 of 66 Summary_ Final formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 81 W X Y February 14, 2003 26 of 66 Summary_ Final formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 81 Z AA AB February 14, 2003 27 of 66 Summary_ Final formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 81 AC AD AE February 14, 2003 28 of 66 Summary_ Final formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 81 AF AG AH February 14, 2003 29 of 66 Summary_ Final formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 81 AI AJ AK February 14, 2003 30 of 66 Summary_ Final formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 81 AL AM AN AO AP AQ AR AS February 14, 2003 31 of 66 Summary_ Final formula. xls  BySubcat Record for the Final Metal Product and Machinery Rule 1 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 I 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 All = Crit! Q188 = 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 = DSUM( Data," M1", Crit49) Option 2 = I11 =+ D11+ J11 =+ E11+ K11 =+ F11+ L11 =+ G11+ M11 =+ H11+ N11 = O11 = DSUM( Data," M2", Crit49) Option 3 = I12 =+ D12+ J12 =+ E12+ K12 =+ F12+ L12 =+ G12+ M12 =+ H12+ N12 = O12 = DSUM( Data," M3", Crit49) Option 4 = I13 =+ D13+ J13 =+ E13+ K13 =+ F13+ L13 =+ G13+ M13 =+ H13+ N13 = O13 = DSUM( Data," M4", Crit49) = Crit! Q209 = 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 = DSUM( Data," M1", Crit53) Option 2 = I16 =+ D16+ J16 =+ E16+ K16 =+ F16+ L16 =+ G16+ M16 =+ H16+ N16 = O16 = DSUM( Data," M2", Crit53) Option 3 = I17 =+ D17+ J17 =+ E17+ K17 =+ F17+ L17 =+ G17+ M17 =+ H17+ N17 = O17 = DSUM( Data," M3", Crit53) Option 4 = I18 =+ D18+ J18 =+ E18+ K18 =+ F18+ L18 =+ G18+ M18 =+ H18+ N18 = O18 = DSUM( Data," M4", Crit53) = IF( Crit! Q230'=" NonCategorized"," General Metals", Crit! Q230) = 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 = DSUM( Data," M1", Crit57) Option 2 = I21 =+ D21+ J21 =+ E21+ K21 =+ F21+ L21 =+ G21+ M21 =+ H21+ N21 = O21 = DSUM( Data," M2", Crit57) Option 3 = I22 =+ D22+ J22 =+ E22+ K22 =+ F22+ L22 =+ G22+ M22 =+ H22+ N22 = O22 = DSUM( Data," M3", Crit57) Option 4 = I23 =+ D23+ J23 =+ E23+ K23 =+ F23+ L23 =+ G23+ M23 =+ H23+ N23 = O23 = DSUM( Data," M4", Crit57) = Crit! Q251 = 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 = DSUM( Data," M1", Crit61) Option 2 = I26 =+ D26+ J26 =+ E26+ K26 =+ F26+ L26 =+ G26+ M26 =+ H26+ N26 = O26 = DSUM( Data," M2", Crit61) Option 3 = I27 =+ D27+ J27 =+ E27+ K27 =+ F27+ L27 =+ G27+ M27 =+ H27+ N27 = O27 = DSUM( Data," M3", Crit61) Option 4 = I28 =+ D28+ J28 =+ E28+ K28 =+ F28+ L28 =+ G28+ M28 =+ H28+ N28 = O28 = DSUM( Data," M4", Crit61) = Crit! Q272 = 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 = DSUM( Data," M1", Crit65) Option 2 = I31 =+ D31+ J31 =+ E31+ K31 =+ F31+ L31 =+ G31+ M31 =+ H31+ N31 = O31 = DSUM( Data," M2", Crit65) Option 3 = I32 =+ D32+ J32 =+ E32+ K32 =+ F32+ L32 =+ G32+ M32 =+ H32+ N32 = O32 = DSUM( Data," M3", Crit65) Option 4 = I33 =+ D33+ J33 =+ E33+ K33 =+ F33+ L33 =+ G33+ M33 =+ H33+ N33 = O33 = DSUM( Data," M4", Crit65) = Crit! Q293 = 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 = DSUM( Data," M1", Crit69) Option 2 = I36 =+ D36+ J36 =+ E36+ K36 =+ F36+ L36 =+ G36+ M36 =+ H36+ N36 = O36 = DSUM( Data," M2", Crit69) Option 3 = I37 =+ D37+ J37 =+ E37+ K37 =+ F37+ L37 =+ G37+ M37 =+ H37+ N37 = O37 = DSUM( Data," M3", Crit69) Option 4 = I38 =+ D38+ J38 =+ E38+ K38 =+ F38+ L38 =+ G38+ M38 =+ H38+ N38 = O38 = DSUM( Data," M4", Crit69) = Crit! Q314 = 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 = DSUM( Data," M1", Crit73) Option 2 = I41 =+ D41+ J41 =+ E41+ K41 =+ F41+ L41 =+ G41+ M41 =+ H41+ N41 = O41 = DSUM( Data," M2", Crit73) Option 3 = I42 =+ D42+ J42 =+ E42+ K42 =+ F42+ L42 =+ G42+ M42 =+ H42+ N42 = O42 = DSUM( Data," M3", Crit73) Option 4 = I43 =+ D43+ J43 =+ E43+ K43 =+ F43+ L43 =+ G43+ M43 =+ H43+ N43 = O43 = DSUM( Data," M4", Crit73) = Crit! Q335 = 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 = DSUM( Data," M1", Crit77) Option 2 = I46 =+ D46+ J46 =+ E46+ K46 =+ F46+ L46 =+ G46+ M46 =+ H46+ N46 = O46 = DSUM( Data," M2", Crit77) Option 3 = I47 =+ D47+ J47 =+ E47+ K47 =+ F47+ L47 =+ G47+ M47 =+ H47+ N47 = O47 = DSUM( Data," M3", Crit77) Option 4 = I48 =+ D48+ J48 =+ E48+ K48 =+ F48+ L48 =+ G48+ M48 =+ H48+ N48 = O48 = DSUM( Data," M4", Crit77) = Crit! Q359 = 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 = DSUM( Data," M1", crit82) Option 2 = I51 =+ D51+ J51 =+ E51+ K51 =+ F51+ L51 =+ G51+ M51 =+ H51+ N51 = O51 = DSUM( Data," M2", crit82) Option 3 = I52 =+ D52+ J52 =+ E52+ K52 =+ F52+ L52 =+ G52+ M52 =+ H52+ N52 = O52 = DSUM( Data," M3", crit82) Option 4 = I53 =+ D53+ J53 =+ E53+ K53 =+ F53+ L53 =+ G53+ M53 =+ H53+ N53 = O53 = DSUM( Data," M4", crit82) 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 = I50+ I45+ I40+ I35+ I30+ I25+ I20+ I15+ I10 Option 2 = I56 =+ D56+ J56 =+ E56+ K56 =+ F56+ L56 =+ G56+ M56 =+ H56+ N56 = O56 = I51+ I46+ I41+ I36+ I31+ I26+ I21+ I16+ I11 Option 3 = I57 =+ D57+ J57 =+ E57+ K57 =+ F57+ L57 =+ G57+ M57 =+ H57+ N57 = O57 = I52+ I47+ I42+ I37+ I32+ I27+ I22+ I17+ I12 Option 4 = I58 =+ D58+ J58 =+ E58+ K58 =+ F58+ L58 =+ G58+ M58 =+ H58+ N58 = O58 = I53+ I48+ I43+ I38+ I33+ I28+ I23+ I18+ I13 Moderate Impacts ( Numbers of Facilities) Flow Cutoff for Indirects

February 14, 2003 32 of 66 Summary_ Final formula. xls  Mod Record for the Final Metal Product and Machinery Rule 1 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 J K L M 1 MGY 2 MGY 3 MGY 4 MGY = DSUM( Data," M1", Crit50) = DSUM( Data," M1", Crit50a) = DSUM( Data," M1", Crit51) = DSUM( Data," M1", Crit51a) = DSUM( Data," M2", Crit50) = DSUM( Data," M2", Crit50a) = DSUM( Data," M2", Crit51) = DSUM( Data," M2", Crit51a) = DSUM( Data," M3", Crit50) = DSUM( Data," M3", Crit50a) = DSUM( Data," M3", Crit51) = DSUM( Data," M3", Crit51a) = DSUM( Data," M4", Crit50) = DSUM( Data," M4", Crit50a) = DSUM( Data," M4", Crit51) = DSUM( Data," M4", Crit51a)

= DSUM( Data," M1", Crit54) = DSUM( Data," M1", Crit54a) = DSUM( Data," M1", Crit55) = DSUM( Data," M1", Crit55a) = DSUM( Data," M2", Crit54) = DSUM( Data," M2", Crit54a) = DSUM( Data," M2", Crit55) = DSUM( Data," M2", Crit55a) = DSUM( Data," M3", Crit54) = DSUM( Data," M3", Crit54a) = DSUM( Data," M3", Crit55) = DSUM( Data," M3", Crit55a) = DSUM( Data," M4", Crit54) = DSUM( Data," M4", Crit54a) = DSUM( Data," M4", Crit55) = DSUM( Data," M4", Crit55a)

= DSUM( Data," M1", Crit58) = DSUM( Data," M1", Crit58a) = DSUM( Data," M1", Crit59) = DSUM( Data," M1", Crit59a) = DSUM( Data," M2", Crit58) = DSUM( Data," M2", Crit58a) = DSUM( Data," M2", Crit59) = DSUM( Data," M2", Crit59a) = DSUM( Data," M3", Crit58) = DSUM( Data," M3", Crit58a) = DSUM( Data," M3", Crit59) = DSUM( Data," M3", Crit59a) = DSUM( Data," M4", Crit58) = DSUM( Data," M4", Crit58a) = DSUM( Data," M4", Crit59) = DSUM( Data," M4", Crit59a)

= DSUM( Data," M1", Crit62) = DSUM( Data," M1", Crit62a) = DSUM( Data," M1", Crit63) = DSUM( Data," M1", Crit63a) = DSUM( Data," M2", Crit62) = DSUM( Data," M2", Crit62a) = DSUM( Data," M2", Crit63) = DSUM( Data," M2", Crit63a) = DSUM( Data," M3", Crit62) = DSUM( Data," M3", Crit62a) = DSUM( Data," M3", Crit63) = DSUM( Data," M3", Crit63a) = DSUM( Data," M4", Crit62) = DSUM( Data," M4", Crit62a) = DSUM( Data," M4", Crit63) = DSUM( Data," M4", Crit63a)

= DSUM( Data," M1", Crit66) = DSUM( Data," M1", Crit66a) = DSUM( Data," M1", Crit67) = DSUM( Data," M1", Crit67a) = DSUM( Data," M2", Crit66) = DSUM( Data," M2", Crit66a) = DSUM( Data," M2", Crit67) = DSUM( Data," M2", Crit67a) = DSUM( Data," M3", Crit66) = DSUM( Data," M3", Crit66a) = DSUM( Data," M3", Crit67) = DSUM( Data," M3", Crit67a) = DSUM( Data," M4", Crit66) = DSUM( Data," M4", Crit66a) = DSUM( Data," M4", Crit67) = DSUM( Data," M4", Crit67a)

= DSUM( Data," M1", Crit70) = DSUM( Data," M1", Crit70a) = DSUM( Data," M1", Crit71) = DSUM( Data," M1", Crit71a) = DSUM( Data," M2", Crit70) = DSUM( Data," M2", Crit70a) = DSUM( Data," M2", Crit71) = DSUM( Data," M2", Crit71a) = DSUM( Data," M3", Crit70) = DSUM( Data," M3", Crit70a) = DSUM( Data," M3", Crit71) = DSUM( Data," M3", Crit71a) = DSUM( Data," M4", Crit70) = DSUM( Data," M4", Crit70a) = DSUM( Data," M4", Crit71) = DSUM( Data," M4", Crit71a)

= DSUM( Data," M1", Crit74) = DSUM( Data," M1", Crit74a) = DSUM( Data," M1", Crit75) = DSUM( Data," M1", Crit75a) = DSUM( Data," M2", Crit74) = DSUM( Data," M2", Crit74a) = DSUM( Data," M2", Crit75) = DSUM( Data," M2", Crit75a) = DSUM( Data," M3", Crit74) = DSUM( Data," M3", Crit74a) = DSUM( Data," M3", Crit75) = DSUM( Data," M3", Crit75a) = DSUM( Data," M4", Crit74) = DSUM( Data," M4", Crit74a) = DSUM( Data," M4", Crit75) = DSUM( Data," M4", Crit75a)

= DSUM( Data," M1", Crit78) = DSUM( Data," M1", Crit78a) = DSUM( Data," M1", Crit79) = DSUM( Data," M1", Crit79a) = DSUM( Data," M2", Crit78) = DSUM( Data," M2", Crit78a) = DSUM( Data," M2", Crit79) = DSUM( Data," M2", Crit79a) = DSUM( Data," M3", Crit78) = DSUM( Data," M3", Crit78a) = DSUM( Data," M3", Crit79) = DSUM( Data," M3", Crit79a) = DSUM( Data," M4", Crit78) = DSUM( Data," M4", Crit78a) = DSUM( Data," M4", Crit79) = DSUM( Data," M4", Crit79a)

= DSUM( Data," M1", crit83) = DSUM( Data," M1", crit84) = DSUM( Data," M1", crit85) = DSUM( Data," M1", crit86) = DSUM( Data," M2", crit83) = DSUM( Data," M2", crit84) = DSUM( Data," M2", crit85) = DSUM( Data," M2", crit86) = DSUM( Data," M3", crit83) = DSUM( Data," M3", crit84) = DSUM( Data," M3", crit85) = DSUM( Data," M3", crit86) = DSUM( Data," M4", crit83) = DSUM( Data," M4", crit84) = DSUM( Data," M4", crit85) = DSUM( Data," M4", crit86)

= J50+ J45+ J40+ J35+ J30+ J25+ J20+ J15+ J10 = K50+ K45+ K40+ K35+ K30+ K25+ K20+ K15+ K10 = L50+ L45+ L40+ L35+ L30+ L25+ L20+ L15+ L10 = M50+ M45+ M40+ M35+ M30+ M25+ M20+ M15+ M10 = J51+ J46+ J41+ J36+ J31+ J26+ J21+ J16+ J11 = K51+ K46+ K41+ K36+ K31+ K26+ K21+ K16+ K11 = L51+ L46+ L41+ L36+ L31+ L26+ L21+ L16+ L11 = M51+ M46+ M41+ M36+ M31+ M26+ M21+ M16+ M11 = J52+ J47+ J42+ J37+ J32+ J27+ J22+ J17+ J12 = K52+ K47+ K42+ K37+ K32+ K27+ K22+ K17+ K12 = L52+ L47+ L42+ L37+ L32+ L27+ L22+ L17+ L12 = M52+ M47+ M42+ M37+ M32+ M27+ M22+ M17+ M12 = J53+ J48+ J43+ J38+ J33+ J28+ J23+ J18+ J13 = K53+ K48+ K43+ K38+ K33+ K28+ K23+ K18+ K13 = L53+ L48+ L43+ L38+ L33+ L28+ L23+ L18+ L13 = M53+ M48+ M43+ M38+ M33+ M28+ M23+ M18+ M13 Moderate Impacts ( Non Cumulative) Flow Size for Indirects

February 14, 2003 33 of 66 Summary_ Final formula. xls  Mod Record for the Final Metal Product and Machinery Rule 1 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 N O 5 MGY 6.25 MGY = DSUM( Data," M1", Crit51b) = DSUM( Data," M1", Crit52) = DSUM( Data," M2", Crit51b) = DSUM( Data," M2", Crit52) = DSUM( Data," M3", Crit51b) = DSUM( Data," M3", Crit52) = DSUM( Data," M4", Crit51b) = DSUM( Data," M4", Crit52)

= DSUM( Data," M1", Crit55b) = DSUM( Data," M1", Crit56) = DSUM( Data," M2", Crit55b) = DSUM( Data," M2", Crit56) = DSUM( Data," M3", Crit55b) = DSUM( Data," M3", Crit56) = DSUM( Data," M4", Crit55b) = DSUM( Data," M4", Crit56)

= DSUM( Data," M1", Crit59b) = DSUM( Data," M1", Crit60) = DSUM( Data," M2", Crit59b) = DSUM( Data," M2", Crit60) = DSUM( Data," M3", Crit59b) = DSUM( Data," M3", Crit60) = DSUM( Data," M4", Crit59b) = DSUM( Data," M4", Crit60)

= DSUM( Data," M1", Crit63b) = DSUM( Data," M1", Crit64) = DSUM( Data," M2", Crit63b) = DSUM( Data," M2", Crit64) = DSUM( Data," M3", Crit63b) = DSUM( Data," M3", Crit64) = DSUM( Data," M4", Crit63b) = DSUM( Data," M4", Crit64)

= DSUM( Data," M1", Crit67b) = DSUM( Data," M1", Crit68) = DSUM( Data," M2", Crit67b) = DSUM( Data," M2", Crit68) = DSUM( Data," M3", Crit67b) = DSUM( Data," M3", Crit68) = DSUM( Data," M4", Crit67b) = DSUM( Data," M4", Crit68)

= DSUM( Data," M1", Crit71b) = DSUM( Data," M1", Crit72) = DSUM( Data," M2", Crit71b) = DSUM( Data," M2", Crit72) = DSUM( Data," M3", Crit71b) = DSUM( Data," M3", Crit72) = DSUM( Data," M4", Crit71b) = DSUM( Data," M4", Crit72)

= DSUM( Data," M1", Crit75b) = DSUM( Data," M1", Crit76) = DSUM( Data," M2", Crit75b) = DSUM( Data," M2", Crit76) = DSUM( Data," M3", Crit75b) = DSUM( Data," M3", Crit76) = DSUM( Data," M4", Crit75b) = DSUM( Data," M4", Crit76)

= DSUM( Data," M1", Crit79b) = DSUM( Data," M1", Crit80) = DSUM( Data," M2", Crit79b) = DSUM( Data," M2", Crit80) = DSUM( Data," M3", Crit79b) = DSUM( Data," M3", Crit80) = DSUM( Data," M4", Crit79b) = DSUM( Data," M4", Crit80)

= DSUM( Data," M1", crit87) = DSUM( Data," M1", crit88) = DSUM( Data," M2", crit87) = DSUM( Data," M2", crit88) = DSUM( Data," M3", crit87) = DSUM( Data," M3", crit88) = DSUM( Data," M4", crit87) = DSUM( Data," M4", crit88)

= N50+ N45+ N40+ N35+ N30+ N25+ N20+ N15+ N10 = O50+ O45+ O40+ O35+ O30+ O25+ O20+ O15+ O10 = N51+ N46+ N41+ N36+ N31+ N26+ N21+ N16+ N11 = O51+ O46+ O41+ O36+ O31+ O26+ O21+ O16+ O11 = N52+ N47+ N42+ N37+ N32+ N27+ N22+ N17+ N12 = O52+ O47+ O42+ O37+ O32+ O27+ O22+ O17+ O12 = N53+ N48+ N43+ N38+ N33+ N28+ N23+ N18+ N13 = O53+ O48+ O43+ O38+ O33+ O28+ O23+ O18+ O13 February 14, 2003 34 of 66 Summary_ Final formula. xls  Mod Record for the Final Metal Product and Machinery Rule 1 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 A B C D E F MP& M Cost Effectiveness, Ranked by Total Removals = Data! A3 All 1 MGY 2 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 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 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 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 =+ 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 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 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 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 =+ 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 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 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 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 =+ 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 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 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 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 =+ 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 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 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 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 =+ 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 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 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 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 =+ 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 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 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 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 =+ 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 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 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 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 =+ 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 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 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 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 =+ 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 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 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 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 Pre Tax Compliance Cost, Millions of 1981 Dollars February 14, 2003 35 of 66 Summary_ Final formula. xls  CE Record for the Final Metal Product and Machinery Rule 1 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 G H I J K L M N O P Q 3 MGY 4 MGY 5 MGY 6.25 MGY All 1 MGY 2 MGY 3 MGY 4 MGY 5 MGY 6.25 MGY = AE10* DeflCE/ 1000000 = AF10* DeflCE/ 1000000 = AG10* DeflCE/ 1000000 = AH10* DeflCE/ 1000000 = AI10 = AJ10 = AK10 = AL10 = AM10 = AN10 = AO10 = AE11* DeflCE/ 1000000 = AF11* DeflCE/ 1000000 = AG11* DeflCE/ 1000000 = AH11* DeflCE/ 1000000 = AI11 = AJ11 = AK11 = AL11 = AM11 = AN11 = AO11 = AE12* DeflCE/ 1000000 = AF12* DeflCE/ 1000000 = AG12* DeflCE/ 1000000 = AH12* DeflCE/ 1000000 = AI12 = AJ12 = AK12 = AL12 = AM12 = AN12 = AO12 = AE13* DeflCE/ 1000000 = AF13* DeflCE/ 1000000 = AG13* DeflCE/ 1000000 = AH13* DeflCE/ 1000000 = AI13 = AJ13 = AK13 = AL13 = AM13 = AN13 = AO13 = AE15* DeflCE/ 1000000 = AF15* DeflCE/ 1000000 = AG15* DeflCE/ 1000000 = AH15* DeflCE/ 1000000 = AI15 = AJ15 = AK15 = AL15 = AM15 = AN15 = AO15 = AE16* DeflCE/ 1000000 = AF16* DeflCE/ 1000000 = AG16* DeflCE/ 1000000 = AH16* DeflCE/ 1000000 = AI16 = AJ16 = AK16 = AL16 = AM16 = AN16 = AO16 = AE17* DeflCE/ 1000000 = AF17* DeflCE/ 1000000 = AG17* DeflCE/ 1000000 = AH17* DeflCE/ 1000000 = AI17 = AJ17 = AK17 = AL17 = AM17 = AN17 = AO17 = AE18* DeflCE/ 1000000 = AF18* DeflCE/ 1000000 = AG18* DeflCE/ 1000000 = AH18* DeflCE/ 1000000 = AI18 = AJ18 = AK18 = AL18 = AM18 = AN18 = AO18 = AE20* DeflCE/ 1000000 = AF20* DeflCE/ 1000000 = AG20* DeflCE/ 1000000 = AH20* DeflCE/ 1000000 = AI20 = AJ20 = AK20 = AL20 = AM20 = AN20 = AO20 = AE21* DeflCE/ 1000000 = AF21* DeflCE/ 1000000 = AG21* DeflCE/ 1000000 = AH21* DeflCE/ 1000000 = AI21 = AJ21 = AK21 = AL21 = AM21 = AN21 = AO21 = AE22* DeflCE/ 1000000 = AF22* DeflCE/ 1000000 = AG22* DeflCE/ 1000000 = AH22* DeflCE/ 1000000 = AI22 = AJ22 = AK22 = AL22 = AM22 = AN22 = AO22 = AE23* DeflCE/ 1000000 = AF23* DeflCE/ 1000000 = AG23* DeflCE/ 1000000 = AH23* DeflCE/ 1000000 = AI23 = AJ23 = AK23 = AL23 = AM23 = AN23 = AO23 = AE25* DeflCE/ 1000000 = AF25* DeflCE/ 1000000 = AG25* DeflCE/ 1000000 = AH25* DeflCE/ 1000000 = AI25 = AJ25 = AK25 = AL25 = AM25 = AN25 = AO25 = AE26* DeflCE/ 1000000 = AF26* DeflCE/ 1000000 = AG26* DeflCE/ 1000000 = AH26* DeflCE/ 1000000 = AI26 = AJ26 = AK26 = AL26 = AM26 = AN26 = AO26 = AE27* DeflCE/ 1000000 = AF27* DeflCE/ 1000000 = AG27* DeflCE/ 1000000 = AH27* DeflCE/ 1000000 = AI27 = AJ27 = AK27 = AL27 = AM27 = AN27 = AO27 = AE28* DeflCE/ 1000000 = AF28* DeflCE/ 1000000 = AG28* DeflCE/ 1000000 = AH28* DeflCE/ 1000000 = AI28 = AJ28 = AK28 = AL28 = AM28 = AN28 = AO28 = AE30* DeflCE/ 1000000 = AF30* DeflCE/ 1000000 = AG30* DeflCE/ 1000000 = AH30* DeflCE/ 1000000 = AI30 = AJ30 = AK30 = AL30 = AM30 = AN30 = AO30 = AE31* DeflCE/ 1000000 = AF31* DeflCE/ 1000000 = AG31* DeflCE/ 1000000 = AH31* DeflCE/ 1000000 = AI31 = AJ31 = AK31 = AL31 = AM31 = AN31 = AO31 = AE32* DeflCE/ 1000000 = AF32* DeflCE/ 1000000 = AG32* DeflCE/ 1000000 = AH32* DeflCE/ 1000000 = AI32 = AJ32 = AK32 = AL32 = AM32 = AN32 = AO32 = AE33* DeflCE/ 1000000 = AF33* DeflCE/ 1000000 = AG33* DeflCE/ 1000000 = AH33* DeflCE/ 1000000 = AI33 = AJ33 = AK33 = AL33 = AM33 = AN33 = AO33 = AE35* DeflCE/ 1000000 = AF35* DeflCE/ 1000000 = AG35* DeflCE/ 1000000 = AH35* DeflCE/ 1000000 = AI35 = AJ35 = AK35 = AL35 = AM35 = AN35 = AO35 = AE36* DeflCE/ 1000000 = AF36* DeflCE/ 1000000 = AG36* DeflCE/ 1000000 = AH36* DeflCE/ 1000000 = AI36 = AJ36 = AK36 = AL36 = AM36 = AN36 = AO36 = AE37* DeflCE/ 1000000 = AF37* DeflCE/ 1000000 = AG37* DeflCE/ 1000000 = AH37* DeflCE/ 1000000 = AI37 = AJ37 = AK37 = AL37 = AM37 = AN37 = AO37 = AE38* DeflCE/ 1000000 = AF38* DeflCE/ 1000000 = AG38* DeflCE/ 1000000 = AH38* DeflCE/ 1000000 = AI38 = AJ38 = AK38 = AL38 = AM38 = AN38 = AO38 = AE40* DeflCE/ 1000000 = AF40* DeflCE/ 1000000 = AG40* DeflCE/ 1000000 = AH40* DeflCE/ 1000000 = AI40 = AJ40 = AK40 = AL40 = AM40 = AN40 = AO40 = AE41* DeflCE/ 1000000 = AF41* DeflCE/ 1000000 = AG41* DeflCE/ 1000000 = AH41* DeflCE/ 1000000 = AI41 = AJ41 = AK41 = AL41 = AM41 = AN41 = AO41 = AE42* DeflCE/ 1000000 = AF42* DeflCE/ 1000000 = AG42* DeflCE/ 1000000 = AH42* DeflCE/ 1000000 = AI42 = AJ42 = AK42 = AL42 = AM42 = AN42 = AO42 = AE43* DeflCE/ 1000000 = AF43* DeflCE/ 1000000 = AG43* DeflCE/ 1000000 = AH43* DeflCE/ 1000000 = AI43 = AJ43 = AK43 = AL43 = AM43 = AN43 = AO43 = AE45* DeflCE/ 1000000 = AF45* DeflCE/ 1000000 = AG45* DeflCE/ 1000000 = AH45* DeflCE/ 1000000 = AI45 = AJ45 = AK45 = AL45 = AM45 = AN45 = AO45 = AE46* DeflCE/ 1000000 = AF46* DeflCE/ 1000000 = AG46* DeflCE/ 1000000 = AH46* DeflCE/ 1000000 = AI46 = AJ46 = AK46 = AL46 = AM46 = AN46 = AO46 = AE47* DeflCE/ 1000000 = AF47* DeflCE/ 1000000 = AG47* DeflCE/ 1000000 = AH47* DeflCE/ 1000000 = AI47 = AJ47 = AK47 = AL47 = AM47 = AN47 = AO47 = AE48* DeflCE/ 1000000 = AF48* DeflCE/ 1000000 = AG48* DeflCE/ 1000000 = AH48* DeflCE/ 1000000 = AI48 = AJ48 = AK48 = AL48 = AM48 = AN48 = AO48 = AE50* DeflCE/ 1000000 = AF50* DeflCE/ 1000000 = AG50* DeflCE/ 1000000 = AH50* DeflCE/ 1000000 = AI50 = AJ50 = AK50 = AL50 = AM50 = AN50 = AO50 = AE51* DeflCE/ 1000000 = AF51* DeflCE/ 1000000 = AG51* DeflCE/ 1000000 = AH51* DeflCE/ 1000000 = AI51 = AJ51 = AK51 = AL51 = AM51 = AN51 = AO51 = AE52* DeflCE/ 1000000 = AF52* DeflCE/ 1000000 = AG52* DeflCE/ 1000000 = AH52* DeflCE/ 1000000 = AI52 = AJ52 = AK52 = AL52 = AM52 = AN52 = AO52 = AE53* DeflCE/ 1000000 = AF53* DeflCE/ 1000000 = AG53* DeflCE/ 1000000 = AH53* DeflCE/ 1000000 = AI53 = AJ53 = AK53 = AL53 = AM53 = AN53 = AO53 = AE55* DeflCE/ 1000000 = AF55* DeflCE/ 1000000 = AG55* DeflCE/ 1000000 = AH55* DeflCE/ 1000000 = AI55 = AJ55 = AK55 = AL55 = AM55 = AN55 = AO55 = AE56* DeflCE/ 1000000 = AF56* DeflCE/ 1000000 = AG56* DeflCE/ 1000000 = AH56* DeflCE/ 1000000 = AI56 = AJ56 = AK56 = AL56 = AM56 = AN56 = AO56 = AE57* DeflCE/ 1000000 = AF57* DeflCE/ 1000000 = AG57* DeflCE/ 1000000 = AH57* DeflCE/ 1000000 = AI57 = AJ57 = AK57 = AL57 = AM57 = AN57 = AO57 = AE58* DeflCE/ 1000000 = AF58* DeflCE/ 1000000 = AG58* DeflCE/ 1000000 = AH58* DeflCE/ 1000000 = AI58 = AJ58 = AK58 = AL58 = AM58 = AN58 = AO58 Pre Tax Compliance Cost, Millions of 1981 Dollars Incremental Removals, lbs eq Flow Cutoff for Indirects  Flow Cutoff for Indirects

February 14, 2003 36 of 66 Summary_ Final formula. xls  CE Record for the Final Metal Product and Machinery Rule 1 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 R S T U All 1 MGY 2 MGY 3 MGY = IF( ISERR( D10/ K10),"", 1000000* D10/ K10) = IF( ISERR( E10/ L10),"", 1000000* E10/ L10) = IF( ISERR( F10/ M10),"", 1000000* F10/ M10) = IF( ISERR( G10/ N10),"", 1000000* G10/ N10) = IF( ISERR( D11/ K11),"", 1000000* D11/ K11) = IF( ISERR( E11/ L11),"", 1000000* E11/ L11) = IF( ISERR( F11/ M11),"", 1000000* F11/ M11) = IF( ISERR( G11/ N11),"", 1000000* G11/ N11) = IF( ISERR( D12/ K12),"", 1000000* D12/ K12) = IF( ISERR( E12/ L12),"", 1000000* E12/ L12) = IF( ISERR( F12/ M12),"", 1000000* F12/ M12) = IF( ISERR( G12/ N12),"", 1000000* G12/ N12) = IF( ISERR( D13/ K13),"", 1000000* D13/ K13) = IF( ISERR( E13/ L13),"", 1000000* E13/ L13) = IF( ISERR( F13/ M13),"", 1000000* F13/ M13) = IF( ISERR( G13/ N13),"", 1000000* G13/ N13)

= IF( ISERR( D15/ K15),"", 1000000* D15/ K15) = IF( ISERR( E15/ L15),"", 1000000* E15/ L15) = IF( ISERR( F15/ M15),"", 1000000* F15/ M15) = IF( ISERR( G15/ N15),"", 1000000* G15/ N15) = IF( ISERR( D16/ K16),"", 1000000* D16/ K16) = IF( ISERR( E16/ L16),"", 1000000* E16/ L16) = IF( ISERR( F16/ M16),"", 1000000* F16/ M16) = IF( ISERR( G16/ N16),"", 1000000* G16/ N16) = IF( ISERR( D17/ K17),"", 1000000* D17/ K17) = IF( ISERR( E17/ L17),"", 1000000* E17/ L17) = IF( ISERR( F17/ M17),"", 1000000* F17/ M17) = IF( ISERR( G17/ N17),"", 1000000* G17/ N17) = IF( ISERR( D18/ K18),"", 1000000* D18/ K18) = IF( ISERR( E18/ L18),"", 1000000* E18/ L18) = IF( ISERR( F18/ M18),"", 1000000* F18/ M18) = IF( ISERR( G18/ N18),"", 1000000* G18/ N18)

= IF( ISERR( D20/ K20),"", 1000000* D20/ K20) = IF( ISERR( E20/ L20),"", 1000000* E20/ L20) = IF( ISERR( F20/ M20),"", 1000000* F20/ M20) = IF( ISERR( G20/ N20),"", 1000000* G20/ N20) = IF( ISERR( D21/ K21),"", 1000000* D21/ K21) = IF( ISERR( E21/ L21),"", 1000000* E21/ L21) = IF( ISERR( F21/ M21),"", 1000000* F21/ M21) = IF( ISERR( G21/ N21),"", 1000000* G21/ N21) = IF( ISERR( D22/ K22),"", 1000000* D22/ K22) = IF( ISERR( E22/ L22),"", 1000000* E22/ L22) = IF( ISERR( F22/ M22),"", 1000000* F22/ M22) = IF( ISERR( G22/ N22),"", 1000000* G22/ N22) = IF( ISERR( D23/ K23),"", 1000000* D23/ K23) = IF( ISERR( E23/ L23),"", 1000000* E23/ L23) = IF( ISERR( F23/ M23),"", 1000000* F23/ M23) = IF( ISERR( G23/ N23),"", 1000000* G23/ N23)

= IF( ISERR( D25/ K25),"", 1000000* D25/ K25) = IF( ISERR( E25/ L25),"", 1000000* E25/ L25) = IF( ISERR( F25/ M25),"", 1000000* F25/ M25) = IF( ISERR( G25/ N25),"", 1000000* G25/ N25) = IF( ISERR( D26/ K26),"", 1000000* D26/ K26) = IF( ISERR( E26/ L26),"", 1000000* E26/ L26) = IF( ISERR( F26/ M26),"", 1000000* F26/ M26) = IF( ISERR( G26/ N26),"", 1000000* G26/ N26) = IF( ISERR( D27/ K27),"", 1000000* D27/ K27) = IF( ISERR( E27/ L27),"", 1000000* E27/ L27) = IF( ISERR( F27/ M27),"", 1000000* F27/ M27) = IF( ISERR( G27/ N27),"", 1000000* G27/ N27) = IF( ISERR( D28/ K28),"", 1000000* D28/ K28) = IF( ISERR( E28/ L28),"", 1000000* E28/ L28) = IF( ISERR( F28/ M28),"", 1000000* F28/ M28) = IF( ISERR( G28/ N28),"", 1000000* G28/ N28)

= IF( ISERR( D30/ K30),"", 1000000* D30/ K30) = IF( ISERR( E30/ L30),"", 1000000* E30/ L30) = IF( ISERR( F30/ M30),"", 1000000* F30/ M30) = IF( ISERR( G30/ N30),"", 1000000* G30/ N30) = IF( ISERR( D31/ K31),"", 1000000* D31/ K31) = IF( ISERR( E31/ L31),"", 1000000* E31/ L31) = IF( ISERR( F31/ M31),"", 1000000* F31/ M31) = IF( ISERR( G31/ N31),"", 1000000* G31/ N31) = IF( ISERR( D32/ K32),"", 1000000* D32/ K32) = IF( ISERR( E32/ L32),"", 1000000* E32/ L32) = IF( ISERR( F32/ M32),"", 1000000* F32/ M32) = IF( ISERR( G32/ N32),"", 1000000* G32/ N32) = IF( ISERR( D33/ K33),"", 1000000* D33/ K33) = IF( ISERR( E33/ L33),"", 1000000* E33/ L33) = IF( ISERR( F33/ M33),"", 1000000* F33/ M33) = IF( ISERR( G33/ N33),"", 1000000* G33/ N33)

= IF( ISERR( D35/ K35),"", 1000000* D35/ K35) = IF( ISERR( E35/ L35),"", 1000000* E35/ L35) = IF( ISERR( F35/ M35),"", 1000000* F35/ M35) = IF( ISERR( G35/ N35),"", 1000000* G35/ N35) = IF( ISERR( D36/ K36),"", 1000000* D36/ K36) = IF( ISERR( E36/ L36),"", 1000000* E36/ L36) = IF( ISERR( F36/ M36),"", 1000000* F36/ M36) = IF( ISERR( G36/ N36),"", 1000000* G36/ N36) = IF( ISERR( D37/ K37),"", 1000000* D37/ K37) = IF( ISERR( E37/ L37),"", 1000000* E37/ L37) = IF( ISERR( F37/ M37),"", 1000000* F37/ M37) = IF( ISERR( G37/ N37),"", 1000000* G37/ N37) = IF( ISERR( D38/ K38),"", 1000000* D38/ K38) = IF( ISERR( E38/ L38),"", 1000000* E38/ L38) = IF( ISERR( F38/ M38),"", 1000000* F38/ M38) = IF( ISERR( G38/ N38),"", 1000000* G38/ N38)

= IF( ISERR( D40/ K40),"", 1000000* D40/ K40) = IF( ISERR( E40/ L40),"", 1000000* E40/ L40) = IF( ISERR( F40/ M40),"", 1000000* F40/ M40) = IF( ISERR( G40/ N40),"", 1000000* G40/ N40) = IF( ISERR( D41/ K41),"", 1000000* D41/ K41) = IF( ISERR( E41/ L41),"", 1000000* E41/ L41) = IF( ISERR( F41/ M41),"", 1000000* F41/ M41) = IF( ISERR( G41/ N41),"", 1000000* G41/ N41) = IF( ISERR( D42/ K42),"", 1000000* D42/ K42) = IF( ISERR( E42/ L42),"", 1000000* E42/ L42) = IF( ISERR( F42/ M42),"", 1000000* F42/ M42) = IF( ISERR( G42/ N42),"", 1000000* G42/ N42) = IF( ISERR( D43/ K43),"", 1000000* D43/ K43) = IF( ISERR( E43/ L43),"", 1000000* E43/ L43) = IF( ISERR( F43/ M43),"", 1000000* F43/ M43) = IF( ISERR( G43/ N43),"", 1000000* G43/ N43)

= IF( ISERR( D45/ K45),"", 1000000* D45/ K45) = IF( ISERR( E45/ L45),"", 1000000* E45/ L45) = IF( ISERR( F45/ M45),"", 1000000* F45/ M45) = IF( ISERR( G45/ N45),"", 1000000* G45/ N45) = IF( ISERR( D46/ K46),"", 1000000* D46/ K46) = IF( ISERR( E46/ L46),"", 1000000* E46/ L46) = IF( ISERR( F46/ M46),"", 1000000* F46/ M46) = IF( ISERR( G46/ N46),"", 1000000* G46/ N46) = IF( ISERR( D47/ K47),"", 1000000* D47/ K47) = IF( ISERR( E47/ L47),"", 1000000* E47/ L47) = IF( ISERR( F47/ M47),"", 1000000* F47/ M47) = IF( ISERR( G47/ N47),"", 1000000* G47/ N47) = IF( ISERR( D48/ K48),"", 1000000* D48/ K48) = IF( ISERR( E48/ L48),"", 1000000* E48/ L48) = IF( ISERR( F48/ M48),"", 1000000* F48/ M48) = IF( ISERR( G48/ N48),"", 1000000* G48/ N48)

= IF( ISERR( D50/ K50),"", 1000000* D50/ K50) = IF( ISERR( E50/ L50),"", 1000000* E50/ L50) = IF( ISERR( F50/ M50),"", 1000000* F50/ M50) = IF( ISERR( G50/ N50),"", 1000000* G50/ N50) = IF( ISERR( D51/ K51),"", 1000000* D51/ K51) = IF( ISERR( E51/ L51),"", 1000000* E51/ L51) = IF( ISERR( F51/ M51),"", 1000000* F51/ M51) = IF( ISERR( G51/ N51),"", 1000000* G51/ N51) = IF( ISERR( D52/ K52),"", 1000000* D52/ K52) = IF( ISERR( E52/ L52),"", 1000000* E52/ L52) = IF( ISERR( F52/ M52),"", 1000000* F52/ M52) = IF( ISERR( G52/ N52),"", 1000000* G52/ N52) = IF( ISERR( D53/ K53),"", 1000000* D53/ K53) = IF( ISERR( E53/ L53),"", 1000000* E53/ L53) = IF( ISERR( F53/ M53),"", 1000000* F53/ M53) = IF( ISERR( G53/ N53),"", 1000000* G53/ N53)

= IF( ISERR( D55/ K55),"", 1000000* D55/ K55) = IF( ISERR( E55/ L55),"", 1000000* E55/ L55) = IF( ISERR( F55/ M55),"", 1000000* F55/ M55) = IF( ISERR( G55/ N55),"", 1000000* G55/ N55) = IF( ISERR( D56/ K56),"", 1000000* D56/ K56) = IF( ISERR( E56/ L56),"", 1000000* E56/ L56) = IF( ISERR( F56/ M56),"", 1000000* F56/ M56) = IF( ISERR( G56/ N56),"", 1000000* G56/ N56) = IF( ISERR( D57/ K57),"", 1000000* D57/ K57) = IF( ISERR( E57/ L57),"", 1000000* E57/ L57) = IF( ISERR( F57/ M57),"", 1000000* F57/ M57) = IF( ISERR( G57/ N57),"", 1000000* G57/ N57) = IF( ISERR( D58/ K58),"", 1000000* D58/ K58) = IF( ISERR( E58/ L58),"", 1000000* E58/ L58) = IF( ISERR( F58/ M58),"", 1000000* F58/ M58) = IF( ISERR( G58/ N58),"", 1000000* G58/ N58) Cost Effectiveness Ratio, $/ lb eq Flow Cutoff for Indirects

February 14, 2003 37 of 66 Summary_ Final formula. xls  CE Record for the Final Metal Product and Machinery Rule 1 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 V W X Y Z AA 4 MGY 5 MGY 6.25 MGY 2 = IF( ISERR( H10/ O10),"", 1000000* H10/ O10) = IF( ISERR( I10/ P10),"", 1000000* I10/ P10) = IF( ISERR( J10/ Q10),"", 1000000* J10/ Q10) 3 = IF( C10'= 5,1, IF( C10'= 6,3, C10)) = IF( ISERR( H11/ O11),"", 1000000* H11/ O11) = IF( ISERR( I11/ P11),"", 1000000* I11/ P11) = IF( ISERR( J11/ Q11),"", 1000000* J11/ Q11) 4 = IF( C11'= 5,1, IF( C11'= 6,3, C11)) = IF( ISERR( H12/ O12),"", 1000000* H12/ O12) = IF( ISERR( I12/ P12),"", 1000000* I12/ P12) = IF( ISERR( J12/ Q12),"", 1000000* J12/ Q12) 5 = IF( C12'= 5,1, IF( C12'= 6,3, C12)) = IF( ISERR( H13/ O13),"", 1000000* H13/ O13) = IF( ISERR( I13/ P13),"", 1000000* I13/ P13) = IF( ISERR( J13/ Q13),"", 1000000* J13/ Q13) 6 = IF( C13'= 5,1, IF( C13'= 6,3, C13)) 7 = IF( ISERR( H15/ O15),"", 1000000* H15/ O15) = IF( ISERR( I15/ P15),"", 1000000* I15/ P15) = IF( ISERR( J15/ Q15),"", 1000000* J15/ Q15) 8 = IF( C15'= 5,1, IF( C15'= 6,3, C15)) = IF( ISERR( H16/ O16),"", 1000000* H16/ O16) = IF( ISERR( I16/ P16),"", 1000000* I16/ P16) = IF( ISERR( J16/ Q16),"", 1000000* J16/ Q16) 9 = IF( C16'= 5,1, IF( C16'= 6,3, C16)) = IF( ISERR( H17/ O17),"", 1000000* H17/ O17) = IF( ISERR( I17/ P17),"", 1000000* I17/ P17) = IF( ISERR( J17/ Q17),"", 1000000* J17/ Q17) 10 = IF( C17'= 5,1, IF( C17'= 6,3, C17)) = IF( ISERR( H18/ O18),"", 1000000* H18/ O18) = IF( ISERR( I18/ P18),"", 1000000* I18/ P18) = IF( ISERR( J18/ Q18),"", 1000000* J18/ Q18) 11 = IF( C18'= 5,1, IF( C18'= 6,3, C18)) 12 = IF( ISERR( H20/ O20),"", 1000000* H20/ O20) = IF( ISERR( I20/ P20),"", 1000000* I20/ P20) = IF( ISERR( J20/ Q20),"", 1000000* J20/ Q20) 13 = IF( C20'= 5,1, IF( C20'= 6,3, C20)) = IF( ISERR( H21/ O21),"", 1000000* H21/ O21) = IF( ISERR( I21/ P21),"", 1000000* I21/ P21) = IF( ISERR( J21/ Q21),"", 1000000* J21/ Q21) 14 = IF( C21'= 5,1, IF( C21'= 6,3, C21)) = IF( ISERR( H22/ O22),"", 1000000* H22/ O22) = IF( ISERR( I22/ P22),"", 1000000* I22/ P22) = IF( ISERR( J22/ Q22),"", 1000000* J22/ Q22) 15 = IF( C22'= 5,1, IF( C22'= 6,3, C22)) = IF( ISERR( H23/ O23),"", 1000000* H23/ O23) = IF( ISERR( I23/ P23),"", 1000000* I23/ P23) = IF( ISERR( J23/ Q23),"", 1000000* J23/ Q23) 16 = IF( C23'= 5,1, IF( C23'= 6,3, C23)) 17 = IF( ISERR( H25/ O25),"", 1000000* H25/ O25) = IF( ISERR( I25/ P25),"", 1000000* I25/ P25) = IF( ISERR( J25/ Q25),"", 1000000* J25/ Q25) 18 = IF( C25'= 5,1, IF( C25'= 6,3, C25)) = IF( ISERR( H26/ O26),"", 1000000* H26/ O26) = IF( ISERR( I26/ P26),"", 1000000* I26/ P26) = IF( ISERR( J26/ Q26),"", 1000000* J26/ Q26) 19 = IF( C26'= 5,1, IF( C26'= 6,3, C26)) = IF( ISERR( H27/ O27),"", 1000000* H27/ O27) = IF( ISERR( I27/ P27),"", 1000000* I27/ P27) = IF( ISERR( J27/ Q27),"", 1000000* J27/ Q27) 20 = IF( C27'= 5,1, IF( C27'= 6,3, C27)) = IF( ISERR( H28/ O28),"", 1000000* H28/ O28) = IF( ISERR( I28/ P28),"", 1000000* I28/ P28) = IF( ISERR( J28/ Q28),"", 1000000* J28/ Q28) 21 = IF( C28'= 5,1, IF( C28'= 6,3, C28)) 22 = IF( ISERR( H30/ O30),"", 1000000* H30/ O30) = IF( ISERR( I30/ P30),"", 1000000* I30/ P30) = IF( ISERR( J30/ Q30),"", 1000000* J30/ Q30) 23 = IF( C30'= 5,1, IF( C30'= 6,3, C30)) = IF( ISERR( H31/ O31),"", 1000000* H31/ O31) = IF( ISERR( I31/ P31),"", 1000000* I31/ P31) = IF( ISERR( J31/ Q31),"", 1000000* J31/ Q31) 24 = IF( C31'= 5,1, IF( C31'= 6,3, C31)) = IF( ISERR( H32/ O32),"", 1000000* H32/ O32) = IF( ISERR( I32/ P32),"", 1000000* I32/ P32) = IF( ISERR( J32/ Q32),"", 1000000* J32/ Q32) 25 = IF( C32'= 5,1, IF( C32'= 6,3, C32)) = IF( ISERR( H33/ O33),"", 1000000* H33/ O33) = IF( ISERR( I33/ P33),"", 1000000* I33/ P33) = IF( ISERR( J33/ Q33),"", 1000000* J33/ Q33) 26 = IF( C33'= 5,1, IF( C33'= 6,3, C33)) 27 = IF( ISERR( H35/ O35),"", 1000000* H35/ O35) = IF( ISERR( I35/ P35),"", 1000000* I35/ P35) = IF( ISERR( J35/ Q35),"", 1000000* J35/ Q35) 28 = IF( C35'= 5,1, IF( C35'= 6,3, C35)) = IF( ISERR( H36/ O36),"", 1000000* H36/ O36) = IF( ISERR( I36/ P36),"", 1000000* I36/ P36) = IF( ISERR( J36/ Q36),"", 1000000* J36/ Q36) 29 = IF( C36'= 5,1, IF( C36'= 6,3, C36)) = IF( ISERR( H37/ O37),"", 1000000* H37/ O37) = IF( ISERR( I37/ P37),"", 1000000* I37/ P37) = IF( ISERR( J37/ Q37),"", 1000000* J37/ Q37) 30 = IF( C37'= 5,1, IF( C37'= 6,3, C37)) = IF( ISERR( H38/ O38),"", 1000000* H38/ O38) = IF( ISERR( I38/ P38),"", 1000000* I38/ P38) = IF( ISERR( J38/ Q38),"", 1000000* J38/ Q38) 31 = IF( C38'= 5,1, IF( C38'= 6,3, C38)) 32 = IF( ISERR( H40/ O40),"", 1000000* H40/ O40) = IF( ISERR( I40/ P40),"", 1000000* I40/ P40) = IF( ISERR( J40/ Q40),"", 1000000* J40/ Q40) 33 = IF( C40'= 5,1, IF( C40'= 6,3, C40)) = IF( ISERR( H41/ O41),"", 1000000* H41/ O41) = IF( ISERR( I41/ P41),"", 1000000* I41/ P41) = IF( ISERR( J41/ Q41),"", 1000000* J41/ Q41) 34 = IF( C41'= 5,1, IF( C41'= 6,3, C41)) = IF( ISERR( H42/ O42),"", 1000000* H42/ O42) = IF( ISERR( I42/ P42),"", 1000000* I42/ P42) = IF( ISERR( J42/ Q42),"", 1000000* J42/ Q42) 35 = IF( C42'= 5,1, IF( C42'= 6,3, C42)) = IF( ISERR( H43/ O43),"", 1000000* H43/ O43) = IF( ISERR( I43/ P43),"", 1000000* I43/ P43) = IF( ISERR( J43/ Q43),"", 1000000* J43/ Q43) 36 = IF( C43'= 5,1, IF( C43'= 6,3, C43)) 37 = IF( ISERR( H45/ O45),"", 1000000* H45/ O45) = IF( ISERR( I45/ P45),"", 1000000* I45/ P45) = IF( ISERR( J45/ Q45),"", 1000000* J45/ Q45) 38 = IF( C45'= 5,1, IF( C45'= 6,3, C45)) = IF( ISERR( H46/ O46),"", 1000000* H46/ O46) = IF( ISERR( I46/ P46),"", 1000000* I46/ P46) = IF( ISERR( J46/ Q46),"", 1000000* J46/ Q46) 39 = IF( C46'= 5,1, IF( C46'= 6,3, C46)) = IF( ISERR( H47/ O47),"", 1000000* H47/ O47) = IF( ISERR( I47/ P47),"", 1000000* I47/ P47) = IF( ISERR( J47/ Q47),"", 1000000* J47/ Q47) 40 = IF( C47'= 5,1, IF( C47'= 6,3, C47)) = IF( ISERR( H48/ O48),"", 1000000* H48/ O48) = IF( ISERR( I48/ P48),"", 1000000* I48/ P48) = IF( ISERR( J48/ Q48),"", 1000000* J48/ Q48) 41 = IF( C48'= 5,1, IF( C48'= 6,3, C48)) 42 = IF( ISERR( H50/ O50),"", 1000000* H50/ O50) = IF( ISERR( I50/ P50),"", 1000000* I50/ P50) = IF( ISERR( J50/ Q50),"", 1000000* J50/ Q50) 43 = IF( C50'= 5,1, IF( C50'= 6,3, C50)) = IF( ISERR( H51/ O51),"", 1000000* H51/ O51) = IF( ISERR( I51/ P51),"", 1000000* I51/ P51) = IF( ISERR( J51/ Q51),"", 1000000* J51/ Q51) 44 = IF( C51'= 5,1, IF( C51'= 6,3, C51)) = IF( ISERR( H52/ O52),"", 1000000* H52/ O52) = IF( ISERR( I52/ P52),"", 1000000* I52/ P52) = IF( ISERR( J52/ Q52),"", 1000000* J52/ Q52) 45 = IF( C52'= 5,1, IF( C52'= 6,3, C52)) = IF( ISERR( H53/ O53),"", 1000000* H53/ O53) = IF( ISERR( I53/ P53),"", 1000000* I53/ P53) = IF( ISERR( J53/ Q53),"", 1000000* J53/ Q53) 46 = IF( C53'= 5,1, IF( C53'= 6,3, C53)) 47 = IF( ISERR( H55/ O55),"", 1000000* H55/ O55) = IF( ISERR( I55/ P55),"", 1000000* I55/ P55) = IF( ISERR( J55/ Q55),"", 1000000* J55/ Q55) 48 = IF( C55'= 5,1, IF( C55'= 6,3, C55)) = IF( ISERR( H56/ O56),"", 1000000* H56/ O56) = IF( ISERR( I56/ P56),"", 1000000* I56/ P56) = IF( ISERR( J56/ Q56),"", 1000000* J56/ Q56) 49 = IF( C56'= 5,1, IF( C56'= 6,3, C56)) = IF( ISERR( H57/ O57),"", 1000000* H57/ O57) = IF( ISERR( I57/ P57),"", 1000000* I57/ P57) = IF( ISERR( J57/ Q57),"", 1000000* J57/ Q57) 50 = IF( C57'= 5,1, IF( C57'= 6,3, C57)) = IF( ISERR( H58/ O58),"", 1000000* H58/ O58) = IF( ISERR( I58/ P58),"", 1000000* I58/ P58) = IF( ISERR( J58/ Q58),"", 1000000* J58/ Q58) 51 = IF( C58'= 5,1, IF( C58'= 6,3, C58)) Flow Cutoff for Indirects

February 14, 2003 38 of 66 Summary_ Final formula. xls  CE Record for the Final Metal Product and Machinery Rule 1 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 AB AC AD All 1 MGY 2 MGY = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA10,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA10,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA10,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA11,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA11,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA11,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA12,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA12,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA12,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA13,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA13,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA13,0)

= HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA15,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA15,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA15,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA16,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA16,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA16,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA17,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA17,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA17,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA18,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA18,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA18,0)

= HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA20,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA20,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA20,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA21,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA21,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA21,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA22,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA22,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA22,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA23,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA23,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA23,0)

= HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA25,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA25,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA25,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA26,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA26,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA26,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA27,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA27,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA27,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA28,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA28,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA28,0)

= HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA30,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA30,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA30,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA31,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA31,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA31,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA32,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA32,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA32,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA33,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA33,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA33,0)

= HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA35,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA35,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA35,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA36,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA36,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA36,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA37,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA37,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA37,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA38,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA38,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA38,0)

= HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA40,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA40,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA40,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA41,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA41,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA41,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA42,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA42,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA42,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA43,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA43,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA43,0)

= HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA45,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA45,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA45,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA46,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA46,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA46,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA47,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA47,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA47,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA48,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA48,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA48,0)

= HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA50,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA50,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA50,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA51,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA51,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA51,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA52,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA52,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA52,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA53,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA53,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA53,0)

= HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA55,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA55,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA55,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA56,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA56,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA56,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA57,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA57,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA57,0) = HLOOKUP( AB$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA58,0) = HLOOKUP( AC$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA58,0) = HLOOKUP( AD$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA58,0)

February 14, 2003 39 of 66 Summary_ Final formula. xls  CE Record for the Final Metal Product and Machinery Rule 1 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 AE AF AG 3 MGY 4 MGY 5 MGY = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA10,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA10,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA10,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA11,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA11,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA11,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA12,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA12,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA12,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA13,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA13,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA13,0)

= HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA15,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA15,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA15,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA16,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA16,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA16,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA17,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA17,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA17,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA18,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA18,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA18,0)

= HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA20,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA20,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA20,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA21,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA21,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA21,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA22,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA22,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA22,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA23,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA23,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA23,0)

= HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA25,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA25,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA25,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA26,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA26,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA26,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA27,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA27,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA27,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA28,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA28,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA28,0)

= HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA30,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA30,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA30,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA31,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA31,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA31,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA32,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA32,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA32,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA33,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA33,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA33,0)

= HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA35,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA35,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA35,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA36,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA36,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA36,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA37,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA37,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA37,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA38,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA38,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA38,0)

= HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA40,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA40,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA40,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA41,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA41,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA41,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA42,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA42,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA42,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA43,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA43,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA43,0)

= HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA45,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA45,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA45,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA46,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA46,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA46,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA47,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA47,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA47,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA48,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA48,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA48,0)

= HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA50,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA50,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA50,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA51,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA51,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA51,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA52,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA52,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA52,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA53,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA53,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA53,0)

= HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA55,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA55,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA55,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA56,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA56,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA56,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA57,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA57,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA57,0) = HLOOKUP( AE$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA58,0) = HLOOKUP( AF$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA58,0) = HLOOKUP( AG$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA58,0) Ordered Compliance Costs Flow Cutoff for Indirects

February 14, 2003 40 of 66 Summary_ Final formula. xls  CE Record for the Final Metal Product and Machinery Rule 1 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 AH AI AJ 6.25 MGY All 1 MGY = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA10,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y9+$ AA10,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y9+$ AA10,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA11,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y9+$ AA11,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y9+$ AA11,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA12,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y9+$ AA12,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y9+$ AA12,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y9+$ AA13,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y9+$ AA13,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y9+$ AA13,0)

= HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA15,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y14+$ AA15,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y14+$ AA15,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA16,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y14+$ AA16,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y14+$ AA16,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA17,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y14+$ AA17,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y14+$ AA17,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y14+$ AA18,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y14+$ AA18,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y14+$ AA18,0)

= HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA20,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y19+$ AA20,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y19+$ AA20,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA21,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y19+$ AA21,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y19+$ AA21,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA22,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y19+$ AA22,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y19+$ AA22,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y19+$ AA23,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y19+$ AA23,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y19+$ AA23,0)

= HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA25,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y24+$ AA25,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y24+$ AA25,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA26,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y24+$ AA26,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y24+$ AA26,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA27,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y24+$ AA27,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y24+$ AA27,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y24+$ AA28,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y24+$ AA28,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y24+$ AA28,0)

= HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA30,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y29+$ AA30,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y29+$ AA30,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA31,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y29+$ AA31,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y29+$ AA31,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA32,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y29+$ AA32,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y29+$ AA32,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y29+$ AA33,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y29+$ AA33,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y29+$ AA33,0)

= HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA35,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y34+$ AA35,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y34+$ AA35,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA36,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y34+$ AA36,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y34+$ AA36,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA37,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y34+$ AA37,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y34+$ AA37,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y34+$ AA38,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y34+$ AA38,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y34+$ AA38,0)

= HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA40,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y39+$ AA40,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y39+$ AA40,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA41,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y39+$ AA41,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y39+$ AA41,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA42,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y39+$ AA42,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y39+$ AA42,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y39+$ AA43,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y39+$ AA43,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y39+$ AA43,0)

= HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA45,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y44+$ AA45,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y44+$ AA45,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA46,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y44+$ AA46,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y44+$ AA46,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA47,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y44+$ AA47,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y44+$ AA47,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y44+$ AA48,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y44+$ AA48,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y44+$ AA48,0)

= HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA50,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y49+$ AA50,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y49+$ AA50,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA51,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y49+$ AA51,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y49+$ AA51,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA52,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y49+$ AA52,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y49+$ AA52,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y49+$ AA53,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y49+$ AA53,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y49+$ AA53,0)

= HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA55,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y54+$ AA55,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y54+$ AA55,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA56,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y54+$ AA56,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y54+$ AA56,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA57,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y54+$ AA57,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y54+$ AA57,0) = HLOOKUP( AH$ 8, BySubcat!$ AM$ 8:$ AS$ 58,$ Y54+$ AA58,0) = HLOOKUP( AI$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y54+$ AA58,0) = HLOOKUP( AJ$ 8, BySubcat!$ I$ 8:$ P$ 58,$ Y54+$ AA58,0)