Document ID: EPA-HQ-OW-2002-0033-0091
Agency: epa
Document Type: Supporting & Related Material
Title: 
Posted Date: 2003-04-14T04:00Z

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

February
14,
2003
40
of
43
Summary_
July­
formula.
xls
­
Comp_
Costs
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
A
B
C
D
E
Social
Cost
of
Unemployment
­
Net
Impacts
over
15
Years
Only
Option
1
has
no
net
job
losses
­­
methodology
used
for
this
option
is
different
Based
on
a
7
percent
discount
rate
Administrative
cost
per
job
lost
=
93.25*(
154.9/
118.5)

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

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

February
14,
2003
41
of
43
Summary_
July­
formula.
xls
­
SC_
Unemp
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
A
B
C
D
E
Employment
Generation
Effects
Labor
Share
of
Equipment
0.30632
Hourly
Wage
Rate
(
2001$)
=
29.67*
153.5/
131.3
Work
Hours
Per
Year
2,000
Components
of
Capital
Costs
by
Regulatory
Option
Cost
Type
Option
1
Equipment
Manufacturing
Costs
=
B10­
B9­
B8
Shipping
Costs
=
B10*
0.2
Installation
Costs
=
B12*
0.07
Installed
Direct
Capital
Costs
=
B12/
1.476
Indirect
Costs
=
B10*
0.476
Total
Installed
Capital
Costs
=
DSUM(
Data,"
Cap­
1",
Crit180)

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

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