Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
3456789
10
11
12
13
14
15
16
17
18
19
A
B
C
D
E
F
VARIABLE
DESCRIPTIONS
FOR
FT_
MPCT.
XLS
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
Subcategory
MP&
M
subcategory
PTRA
A
N
Sum
of
Weighted
PTRA
Sum
of
weighted
PTRA
(
excluding
outliers)
PTRA
B
N
=
SUMIF(
Data!$
F$
2:$
F$
770,
$
A5,
Data!
H$
2:
H$
770)
Total
Weights
Sum
of
weights
(
excluding
outliers)
PTRA
C
N
=
SUMIF(
Data!$
F$
2:$
F$
770,
$
A5,
Data!
I$
2:
I$
770)
Avg
PTRA
Average
PTRA
(
excluding
outliers)
PTRA
D
N
=
B5/
C5
Median
PTRA
Median
PTRA
PTRA
E
N
=
D19
Subcategory
MP&
M
subcategory
PTRA
row
17
N
#
of
Unweighted
Facilities
Number
of
unweighted
facilities
PTRA
row
18
N
Median
PTRA
Median
PTRA
PTRA
row
19
N
SID
Site
ID
Data
A
Y
=
IF([
MPCT_
Final.
xls]
RawData!
B7<>"",[
MPCT_
Final.
xls]
RawDat
a!
B7,"")

Weight
Weight
Data
B
Y
=
IF(
ISNA(
VLOOKUP($
A2,
FacData,
2,
FALSE)),
0,
VLOOKUP($
A
2,
FacData,
2,
FALSE))

EBIT
Earnings
before
interest
and
taxes
Data
C
Y
=
VLOOKUP(
A2,[
MPCT_
Final.
xls]
Base!$
A$
6:$
L$
949,12,0)

Assets
Assets
Data
D
Y
=
VLOOKUP(
A2,[
MPCT_
Final.
xls]
Base!$
A$
6:$
AC$
949,29,0)

PTRA
Pre­
tax
return
on
assets
Data
E
Y
=
IF(
ISERR(
C2/
D2),"
n/
a",
C2/
D2)
Subcat
MP&
M
subcategory
Data
F
Y
=
VLOOKUP(
A2,
'[
Summary_
Final.
xls]
Data'!$
A$
7:$
F$
916,
4,
0)

Weighted
PTRA
Weighted
PTRA
Data
G
Y
=
E2*
B2
Weighted
PTRA
without
outliers
Weighted
PTRA
(
without
outliers
over
250%)
Data
H
Y
=
IF(
E2<
2.5,
G2,
"")

Weights
without
outliers
Weights
(
does
not
include
outlier
facilities
with
PTRA
>
250%)
Data
I
Y
=
IF(
E2<
2.5,
B2,
"")

February
14,
2003
Page
1
of
3
PTRA.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
23
4
56789
10
11
12
13
14
15
16
17
18
19
A
B
C
D
E
F
G
H
I
J
Subcategory
Sum
of
Weighted
PTRA
Total
Weights
Avg
PTRA
Median
PTRA
Shipbuilding
Dry
Dock
0.1
2.8
2.5%
2.5%
General
Metals
1,418.8
10,450.8
13.6%
11.4%
MF
Job
Shop
262.2
1,541.5
17.0%
9.0%
NonChromium
Anodizer
12.2
122.0
10.0%
9.0%
Oily
Wastes
15,767.9
24,245.8
65.0%
9.6%
Printed
Wiring
Boards
53.1
839.8
6.3%
12.6%
Railroad
Line
Maintenance
n/
a
n/
a
n/
a
n/
a
New
Iron
and
Steel
Forming
and
Finishing
9.1%
All
Subcategories
17,514.3
37,202.9
47.1%
10.8%

Subcategory
All
Sectors
New
Iron
and
Steel
Forming
and
Finishing
Shipbuilding
Dry
Dock
General
Metals
MF
Job
Shop
NonChromium
Anodizer
Oily
Wastes
Printed
Wiring
Boards
Railroad
Line
Maintenance
#
of
Unweighted
Facilities
689
22
1
349
51
6
191
69
0
Median
PTRA
0.11
0.09
0.02
0.11
0.09
0.09
0.10
0.13
#
NUM!
Median
PTRA
worksheet
These
values
exclude
outlier
PTRA's
above
250%.

February
14,
2003
2
of
3
PTRA.
xls
­
PTRA
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
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
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
A
B
C
D
E
F
G
H
I
SID
Weight
EBIT
Assets
PTRA
(
EBIT/
Total
Assets)
Subcat
Weighted
PTRA
Weighted
PTRA
without
outliers
Weights
without
outliers
1
2
3
5
6
7
8
9
10
12
13
14
15
16
20
21
22
24
25
26
27
28
29
31
32
33
35
36
37
38
41
42
43
44
45
46
47
48
50
51
52
53
55
57
58
59
60
61
62
64
65
67
68
69
70
71
72
73
74
75
76
78
79
81
83
84
85
86
87
88
89
90
91
92
94
95
Note:
All
data
except
site
identification
not
shown
to
protect
confidential
business
information.
Sample
page
provided
to
show
structure
of
worksheet.
February
14,
2003
3
of
3
PTRA.
xls
­
Data
