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

Record
for
the
Final
Metal
Product
and
Machinery
Rule
123456789
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
A
B
C
D
E
F
VARIABLE
DESCRIPTIONS
FOR
IMPORT_
FINAL.
XLS
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
Sector
Sector
Number
PPIs
A
N
Abbr
Sector
Abbreviation
PPIs
B
N
1987
Sector­
Specific
PPI
values
in
1987
PPIs
C
N
1988
Sector­
Specific
PPI
values
in
1988
PPIs
D
N
1989
Sector­
Specific
PPI
values
in
1989
PPIs
E
N
1990
Sector­
Specific
PPI
values
in
1990
PPIs
F
N
1991
Sector­
Specific
PPI
values
in
1991
PPIs
G
N
1992
Sector­
Specific
PPI
values
in
1992
PPIs
H
N
1993
Sector­
Specific
PPI
values
in
1993
PPIs
I
N
1994
Sector­
Specific
PPI
values
in
1994
PPIs
J
N
1995
Sector­
Specific
PPI
values
in
1995
PPIs
K
N
1996
Sector­
Specific
PPI
values
in
1996
PPIs
L
N
SID
Survey
ID
Import
A
N
REVENU94
FY
1994
Total
Revenues
Import
B
Y
REVENU95
FY
1995
Total
Revenues
Import
C
Y
REVENU96
FY
1996
Total
Revenues
Import
D
Y
TOTAL94
FY
1994
Total
Costs
and
Expenses
Import
E
Y
TOTAL95
FY
1995
Total
Costs
and
Expenses
Import
F
Y
TOTAL96
FY
1996
Total
Costs
and
Expenses
Import
G
Y
INTRST94
FY
1994
Interest
Import
H
Y
INTRST95
FY
1995
Interest
Import
I
Y
INTRST96
FY
1996
Interest
Import
J
Y
TAXES94
FY
1994
Income
Taxes
Import
K
Y
TAXES95
FY
1995
Income
Taxes
Import
L
Y
TAXES96
FY
1996
Income
Taxes
Import
M
Y
LIQUIDAT
Liquidation
Value
Import
N
Y
INT_
RATE
Interest
Rate
Import
O
Y
CURLIA94
FY
1994
Current
Liabilities
Import
P
Y
CURLIA95
FY
1995
Current
Liabilities
Import
Q
Y
CURLIA96
FY
1996
Current
Liabilities
Import
R
Y
NONLIA94
FY
1994
Non­
Current
Liabilities
Import
S
Y
NONLIA95
FY
1995
Non­
Current
Liabilities
Import
T
Y
NONLIA96
FY
1996
Non­
Current
Liabilities
Import
U
Y
TOTASS94
FY
1994
Total
Assets
Import
V
Y
TOTASS95
FY
1995
Total
Assets
Import
W
Y
TOTASS96
FY
1996
Total
Assets
Import
X
Y
DEPREC94
FY
1994
Depreciation
Import
Y
Y
DEPREC95
FY
1995
Depreciation
Import
Z
Y
DEPREC96
FY
1996
Depreciation
Import
AA
Y
REV94_
P
FY
1994
Parent
Firm
Total
Revenue
Import
AB
Y
REV95_
P
FY
1995
Parent
Firm
Total
Revenue
Import
AC
Y
REV96_
P
FY
1996
Parent
Firm
Total
Revenue
Import
AD
Y
REV94_
U
FY
1994
Closest
Business
Unit
Total
Revenue
Import
AE
Y
REV95_
U
FY
1995
Closest
Business
Unit
Total
Revenue
Import
AF
Y
REV96_
U
FY
1996
Closest
Business
Unit
Total
Revenue
Import
AG
Y
COST94_
U
FY
1994
Closest
Business
Unit
Production
Cost
Import
AH
Y
COST95_
U
FY
1995
Closest
Business
Unit
Production
Cost
Import
AI
Y
COST96_
U
FY
1996
Closest
Business
Unit
Production
Cost
Import
AJ
Y
EMPL94_
U
FY
1994
Closest
Business
Unit
Production
Workers
Import
AK
Y
EMPL95_
U
FY
1995
Closest
Business
Unit
Production
Workers
Import
AL
Y
EMPL96_
U
FY
1996
Closest
Business
Unit
Production
Workers
Import
AM
Y
REV94_
S
FY
1994
Site
Total
Revenue
Import
AN
Y
REV95_
S
FY
1995
Site
Total
Revenue
Import
AO
Y
REV96_
S
FY
1996
Site
Total
Revenue
Import
AP
Y
COST94_
S
FY
1994
Site
Production
Cost
Import
AQ
Y
COST95_
S
FY
1995
Site
Production
Cost
Import
AR
Y
COST96_
S
FY
1996
Site
Production
Cost
Import
AS
Y
February
14,
2003
Page
1
of
64
IMPORT_
Final.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
A
B
C
D
E
F
VARIABLE
DESCRIPTIONS
FOR
IMPORT_
FINAL.
XLS
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
EMPL94_
S
FY
1994
Site
Production
Workers
Import
AT
Y
EMPL95_
S
FY
1995
Site
Production
Workers
Import
AU
Y
EMPL96_
S
FY
1996
Site
Production
Workers
Import
AV
Y
UNITDATA
Unit
Data
Provided?
1=
yes,
0=
no
Import
AW
Y
REVREP6
Unit/
Site
Data
for
Question
6;
1=
unit,
2=
site
Import
AX
Y
REVREP7
Unit/
Site
Data
for
Question
7;
1=
unit,
2=
site
Import
AY
Y
INVEN94
FY
1994
Inventories
Import
AZ
Y
INVEN95
FY
1995
Inventories
Import
BA
Y
INVEN96
FY
1996
Inventories
Import
BB
Y
CURASS94
FY
1994
Other
Current
Assets
Import
BC
Y
CURASS95
FY
1995
Other
Current
Assets
Import
BD
Y
CURASS96
FY
1996
Other
Current
Assets
Import
BE
Y
EQUITY94
FY
1994
Owner
Equity
Import
BF
Y
EQUITY95
FY
1995
Owner
Equity
Import
BG
Y
EQUITY96
FY
1996
Owner
Equity
Import
BH
Y
NONASS94
FY
1994
Noncurrent
Assets
Import
BI
Y
NONASS95
FY
1995
Noncurrent
Assets
Import
BJ
Y
NONASS96
FY
1996
Noncurrent
Assets
Import
BK
Y
SID
Survey
ID
96values
A
N
=
Import!
A6
SECTOR
Sector
Abbreviation
96values
B
Y
=
VLOOKUP(
A5,[
facdata_
Noda.
xls]
FacData!$
A$
5:$
J$
940,3,0)
REVENU94
FY
1994
Total
Revenues,
1996$
96values
C
Y
=
Import!
B6*
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
9,0)
REVENU95
FY
1995
Total
Revenues,
1996$
96values
D
Y
=
Import!
C6*
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
10,0)
REVENU96
FY
1996
Total
Revenues,
1996$
96values
E
Y
=
Import!
D6
TOTAL94
FY
1994
Total
Costs
and
Expenses,
1996$
96values
F
Y
=
Import!
E6*
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
9,0)
TOTAL95
FY
1995
Total
Costs
and
Expenses,
1996$
96values
G
Y
=
Import!
F6*
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
10,0)
TOTAL96
FY
1996
Total
Costs
and
Expenses,
1996$
96values
H
Y
=
Import!
G6
INTRST94
FY
1994
Interest,
1996$
96values
I
Y
=
Import!
H6*
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
9,0)
INTRST95
FY
1995
Interest,
1996$
96values
J
Y
=
Import!
I6*
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
10,0)
INTRST96
FY
1996
Interest,
1996$
96values
K
Y
=
Import!
J6
TAXES94
FY
1994
Income
Taxes,
1996$
96values
L
Y
=
Import!
K6*
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
9,0)
TAXES95
FY
1995
Income
Taxes,
1996$
96values
M
Y
=
Import!
L6*
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
10,0)
TAXES96
FY
1996
Income
Taxes,
1996$
96values
N
Y
=
Import!
M6
CURLIA94
FY
1994
Current
Liabilities,
1996$
96values
O
Y
=
Import!
P6*
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
9,0)
CURLIA95
FY
1995
Current
Liabilities,
1996$
96values
P
Y
=
Import!
Q6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
10,0))
CURLIA96
FY
1996
Current
Liabilities,
1996$
96values
Q
Y
=
Import!
R6
NONLIA94
FY
1994
Non­
Current
Liabilities,
1996$
96values
R
Y
=
Import!
S6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
9,0))
NONLIA95
FY
1995
Non­
Current
Liabilities,
1996$
96values
S
Y
=
Import!
T6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
10,0))
NONLIA96
FY
1996
Non­
Current
Liabilities,
1996$
96values
T
Y
=
Import!
U6
TOTASS94
FY
1994
Total
Assets,
1996$
96values
U
Y
=
Import!
V6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
9,0))
TOTASS95
FY
1995
Total
Assets,
1996$
96values
V
Y
=
Import!
W6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
10,0))
TOTASS96
FY
1996
Total
Assets,
1996$
96values
W
Y
=
Import!
X6
DEPREC94
FY
1994
Depreciation,
1996$
96values
X
Y
=
Import!
Y6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
9,0))
DEPREC95
FY
1995
Depreciation,
1996$
96values
Y
Y
=
Import!
Z6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
10,0))
DEPREC96
FY
1996
Depreciation,
1996$
96values
Z
Y
=
Import!
AA6
REV94_
P
FY
1994
Parent
Firm
Total
Revenue,
1996$
96values
AA
Y
=
Import!
AB6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
9,0))
REV95_
P
FY
1995
Parent
Firm
Total
Revenue,
1996$
96values
AB
Y
=
Import!
AC6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
10,0))
REV96_
P
FY
1996
Parent
Firm
Total
Revenue,
1996$
96values
AC
Y
=
Import!
AD6
REV94_
U
FY
1994
Closest
Business
Unit
Total
Revenue,
1996$
96values
AD
Y
=
Import!
AE6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
9,0))
REV95_
U
FY
1995
Closest
Business
Unit
Total
Revenue,
1996$
96values
AE
Y
=
Import!
AF6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
10,0))
REV96_
U
FY
1996
Closest
Business
Unit
Total
Revenue,
1996$
96values
AF
Y
=
Import!
AG6
COST94_
U
FY
1994
Closest
Business
Unit
Production
Cost,
1996$
96values
AG
Y
=
Import!
AH6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
9,0))
COST95_
U
FY
1995
Closest
Business
Unit
Production
Cost,
1996$
96values
AH
Y
=
Import!
AI6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
10,0))
COST96_
U
FY
1996
Closest
Business
Unit
Production
Cost,
1996$
96values
AI
Y
=
Import!
AJ6
EMPL94_
U
FY
1994
Closest
Business
Unit
Production
Workers
96values
AJ
Y
=
Import!
AK6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
9,0))
EMPL95_
U
FY
1995
Closest
Business
Unit
Production
Workers
96values
AK
Y
=
Import!
AL6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
10,0))
EMPL96_
U
FY
1996
Closest
Business
Unit
Production
Workers
96values
AL
Y
=
Import!
AM6
REV94_
S
FY
1994
Site
Total
Revenue,
1996$
96values
AM
Y
=
Import!
AN6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
9,0))

February
14,
2003
Page
2
of
64
IMPORT_
Final.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
A
B
C
D
E
F
VARIABLE
DESCRIPTIONS
FOR
IMPORT_
FINAL.
XLS
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
REV95_
S
FY
1995
Site
Total
Revenue,
1996$
96values
AN
Y
=
Import!
AO6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
10,0))
REV96_
S
FY
1996
Site
Total
Revenue,
1996$
96values
AO
Y
=
Import!
AP6
COST94_
S
FY
1994
Site
Production
Cost,
1996$
96values
AP
Y
=
Import!
AQ6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
9,0))
COST95_
S
FY
1995
Site
Production
Cost,
1996$
96values
AQ
Y
=
Import!
AR6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
10,0))
COST96_
S
FY
1996
Site
Production
Cost,
1996$
96values
AR
Y
=
Import!
AS6
EMPL94_
S
FY
1994
Site
Production
Workers
96values
AS
Y
=
Import!
AT6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
9,0))
EMPL95_
S
FY
1995
Site
Production
Workers
96values
AT
Y
=
Import!
AU6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
10,0))
EMPL96_
S
FY
1996
Site
Production
Workers
96values
AU
Y
=
Import!
AV6
INVEN94
FY
1994
Inventories,
1996$
96values
AV
Y
=
Import!
AZ6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
9,0))
INVEN95
FY
1995
Inventories,
1996$
96values
AW
Y
=
Import!
BA6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
10,0))
INVEN96
FY
1996
Inventories,
1996$
96values
AX
Y
=
Import!
BB6
CURASS94
FY
1994
Other
Current
Assets,
1996$
96values
AY
Y
=
Import!
BC6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
9,0))
CURASS95
FY
1995
Other
Current
Assets,
1996$
96values
AZ
Y
=
Import!
BD6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
10,0))
CURASS96
FY
1996
Other
Current
Assets,
1996$
96values
BA
Y
=
Import!
BE6
EQUITY94
FY
1994
Owner
Equity,
1996$
96values
BB
Y
=
Import!
BF6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
9,0))
EQUITY95
FY
1995
Owner
Equity,
1996$
96values
BC
Y
=
Import!
BG6*(
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
10,0))
EQUITY96
FY
1996
Owner
Equity,
1996$
96values
BD
Y
=
Import!
BH6
NONASS94
FY
1994
Noncurrent
Assets,
1996$
96values
BE
Y
=
Import!
BI6*
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
9,0)
NONASS95
FY
1995
Noncurrent
Assets,
1996$
96values
BF
Y
=
Import!
BJ6*
VLOOKUP($
B5,
PPIs,
11,0)/
VLOOKUP($
B5,
PPIs,
10,0)
NONASS96
FY
1996
Noncurrent
Assets,
1996$
96values
BG
Y
=
Import!
BK6
SID
Survey
Ids
Calculations
A
N
=
Import!
A6
Income
Statement
Years
Number
of
years
with
income
statement
data
Calculations
B
N
=
MAX(
COUNTIF(
G5:
I5,">
0"),
COUNTIF(
C5:
E5,">
0"))
REVENU94
FY
1994
Total
Revenues,
1996$
Calculations
C
Y
='
96values'!
B5
REVENU95
FY
1995
Total
Revenues,
1996$
Calculations
D
Y
='
96values'!
C5
REVENU96
FY
1996
Total
Revenues,
1996$
Calculations
E
Y
='
96values'!
D5
Avg.
Revenue
Average
Revenue,
1996$
Calculations
F
Y
=(
SUM(
C5:
E5))/$
B5
TOTAL94
FY
1994
Total
Costs
and
Expenses,
1996$
Calculations
G
Y
='
96values'!
E5
TOTAL95
FY
1995
Total
Costs
and
Expenses,
1996$
Calculations
H
Y
='
96values'!
F5
TOTAL96
FY
1996
Total
Costs
and
Expenses,
1996$
Calculations
I
Y
='
96values'!
G5
Avg.
Total
Cost
Total
Costs,
1996$
Calculations
J
Y
=(
SUM(
G5:
I5))/$
B5
INTRST94
FY
1994
Interest,
1996$
Calculations
K
Y
='
96values'!
H5
INTRST95
FY
1995
Interest,
1996$
Calculations
L
Y
='
96values'!
I5
INTRST96
FY
1996
Interest,
1996$
Calculations
M
Y
='
96values'!
J5
Avg
Interest
Interest,
1996$
Calculations
N
Y
=(
SUM(
K5:
M5))/$
B5
TAXES94
FY
1994
Income
Taxes,
1996$
Calculations
O
Y
='
96values'!
K5
TAXES95
FY
1995
Income
Taxes,
1996$
Calculations
P
Y
='
96values'!
L5
TAXES96
FY
1996
Income
Taxes,
1996$
Calculations
Q
Y
='
96values'!
M5
Average
Taxes
Taxes,
1996$
Calculations
R
Y
=(
SUM(
O5:
Q5))/$
B5
Balance
Sheet
Years
Number
of
years
with
balance
sheet
data
Calculations
S
N
=
COUNTIF(
AC5:
AE5,">
0")
CURLIA94
FY
1994
Current
Liabilities,
1996$
Calculations
T
Y
='
96values'!
N5
CURLIA95
FY
1995
Current
Liabilities,
1996$
Calculations
U
Y
='
96values'!
O5
CURLIA96
FY
1996
Current
Liabilities,
1996$
Calculations
V
Y
='
96values'!
P5
Avg.
Curr.
Lia.
Current
Liabilities,
1996$
Calculations
W
Y
=(
SUM(
T5:
V5))/$
S5
NONLIA94
FY
1994
Non­
Current
Liabilities,
1996$
Calculations
X
Y
='
96values'!
Q5
NONLIA95
FY
1995
Non­
Current
Liabilities,
1996$
Calculations
Y
Y
='
96values'!
R5
NONLIA96
FY
1996
Non­
Current
Liabilities,
1996$
Calculations
Z
Y
='
96values'!
S5
Avg.
Noncurr.
Lia.
Non­
Current
Liabilities,
1996$
Calculations
AA
Y
=(
SUM(
X5:
Z5))/$
S5
Avg.
Debt
Current
+
Non­
Current
Liabilities
Calculations
AB
Y
=
W5+
AA5
TOTASS94
FY
1994
Total
Assets,
1996$
Calculations
AC
Y
='
96values'!
T5
TOTASS95
FY
1995
Total
Assets,
1996$
Calculations
AD
Y
='
96values'!
U5
TOTASS96
FY
1996
Total
Assets,
1996$
Calculations
AE
Y
='
96values'!
V5
Avg.
Assets
Total
Assets,
1996$
Calculations
AF
Y
=(
SUM(
AC5:
AE5))/$
S5
DEPREC94
FY
1994
Depreciation,
1996$
Calculations
AG
Y
='
96values'!
W5
DEPREC95
FY
1995
Depreciation,
1996$
Calculations
AH
Y
='
96values'!
X5
DEPREC96
FY
1996
Depreciation,
1996$
Calculations
AI
Y
='
96values'!
Y5
Avg.
Deprec
Depreciation
Expense,
1996$
Calculations
AJ
Y
=(
SUM(
AG5:
AI5))/$
B5
REV94_
P
FY
1994
Parent
Firm
Total
Revenue,
1996$
Calculations
AK
Y
='
96values'!
Z5
February
14,
2003
Page
3
of
64
IMPORT_
Final.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
A
B
C
D
E
F
VARIABLE
DESCRIPTIONS
FOR
IMPORT_
FINAL.
XLS
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
REV95_
P
FY
1995
Parent
Firm
Total
Revenue,
1996$
Calculations
AL
Y
='
96values'!
AA5
REV96_
P
FY
1996
Parent
Firm
Total
Revenue,
1996$
Calculations
AM
Y
='
96values'!
AB5
Avg.
Firm
Rev.
Firm
Revenue,
1996$
Calculations
AN
Y
=(
SUM(
AK5:
AM5))/$
B5
REV94_
U
FY
1994
Closest
Business
Unit
Total
Revenue,
1996$
Calculations
AO
Y
='
96values'!
AC5
REV95_
U
FY
1995
Closest
Business
Unit
Total
Revenue,
1996$
Calculations
AP
Y
='
96values'!
AD5
REV96_
U
FY
1996
Closest
Business
Unit
Total
Revenue,
1996$
Calculations
AQ
Y
='
96values'!
AE5
REVBOTH94
Both
unit
and
site
revenues?
1=
yes,
0=
no
Calculations
AR
Y
=
IF(
AND(
AO5>
0,
BJ5>
0),
1,0)
REVBOTH95
Both
unit
and
site
revenues?
1=
yes,
0=
no
Calculations
AS
Y
=
IF(
AND(
AP5>
0,
BK5>
0),
1,0)
REVBOTH96
Both
unit
and
site
revenues?
1=
yes,
0=
no
Calculations
AT
Y
=
IF(
AND(
AQ5>
0,
BL5>
0),
1,0)
Average
Unit
Revenues
Unit
Revenues,
1996$
Calculations
AU
Y
=
IF(
ISERR(
SUMPRODUCT(
AO5:
AQ5,
AR5:
AT5)/
SUM(
AR5:
AT5)),
0,
SUMPR
ODUCT(
AO5:
AQ5,
AR5:
AT5)/
SUM(
AR5:
AT5))
COST94_
U
FY
1994
Closest
Business
Unit
Production
Cost,
1996$
Calculations
AV
Y
='
96values'!
AF5
COST95_
U
FY
1995
Closest
Business
Unit
Production
Cost,
1996$
Calculations
AW
Y
='
96values'!
AG5
COST96_
U
FY
1996
Closest
Business
Unit
Production
Cost,
1996$
Calculations
AX
Y
='
96values'!
AH5
COSTBOTH94
Both
unit
and
site
costs?
1=
yes,
0=
no
Calculations
AY
Y
=
IF(
AND(
AV5>
0,
BN5>
0),
1,0)
COSTBOTH95
Both
unit
and
site
costs?
1=
yes,
0=
no
Calculations
AZ
Y
=
IF(
AND(
AW5>
0,
BO5>
0),
1,0)
COSTBOTH96
Both
unit
and
site
costs?
1=
yes,
0=
no
Calculations
BA
Y
=
IF(
AND(
AX5>
0,
BP5>
0),
1,0)
Average
Unit
Costs
Unit
Costs,
1996$
Calculations
BB
Y
=
IF(
ISERR(
SUMPRODUCT(
AV5:
AX5,
AY5:
BA5)/
SUM(
AY5:
BA5)),
0,
SUMPRO
DUCT(
AV5:
AX5,
AY5:
BA5)/
SUM(
AY5:
BA5))
EMPL94_
U
FY
1994
Closest
Business
Unit
Production
Workers
Calculations
BC
Y
='
96values'!
AI5
EMPL95_
U
FY
1995
Closest
Business
Unit
Production
Workers
Calculations
BD
Y
='
96values'!
AJ5
EMPL96_
U
FY
1996
Closest
Business
Unit
Production
Workers
Calculations
BE
Y
='
96values'!
AK5
EMPBOTH94
Both
unit
and
site
employment?
1=
yes,
0=
no
Calculations
BF
Y
=
IF(
AND(
BC5>
0,
BR5>
0),
1,0)
EMPBOTH95
Both
unit
and
site
employment?
1=
yes,
0=
no
Calculations
BG
Y
=
IF(
AND(
BD5>
0,
BS5>
0),
1,0)
EMPBOTH96
Both
unit
and
site
employment?
1=
yes,
0=
no
Calculations
BH
Y
=
IF(
AND(
BE5>
0,
BT5>
0),
1,0)
Average
Unit
Employment
Unit
Employment
Calculations
BI
Y
=
IF(
ISERR(
SUMPRODUCT(
BC5:
BE5,
BF5:
BH5)/
SUM(
BF5:
BH5)),
0,
SUMPRO
DUCT(
BC5:
BE5,
BF5:
BH5)/
SUM(
BF5:
BH5))
REV94_
S
FY
1994
Site
Total
Revenue,
1996$
Calculations
BJ
Y
='
96values'!
AL5
REV95_
S
FY
1995
Site
Total
Revenue,
1996$
Calculations
BK
Y
='
96values'!
AM5
REV96_
S
FY
1996
Site
Total
Revenue,
1996$
Calculations
BL
Y
='
96values'!
AN5
Average
Site
Revenues
Site
Revenues,
1996$
Calculations
BM
Y
=
IF(
ISERR(
SUMPRODUCT(
AR5:
AT5,
BJ5:
BL5)/
SUM(
AR5:
AT5)),
0,
SUMPRO
DUCT(
AR5:
AT5,
BJ5:
BL5)/
SUM(
AR5:
AT5))
COST94_
S
FY
1994
Site
Production
Cost,
1996$
Calculations
BN
Y
='
96values'!
AO5
COST95_
S
FY
1995
Site
Production
Cost,
1996$
Calculations
BO
Y
='
96values'!
AP5
COST96_
S
FY
1996
Site
Production
Cost,
1996$
Calculations
BP
Y
='
96values'!
AQ5
Average
Site
Costs
Site
Costs,
1996$
Calculations
BQ
Y
=
IF(
ISERR(
SUMPRODUCT(
AY5:
BA5,
BN5:
BP5)/
SUM(
AY5:
BA5)),
0,
SUMPRO
DUCT(
AY5:
BA5,
BN5:
BP5)/
SUM(
AY5:
BA5))
EMPL94_
S
FY
1994
Site
Production
Workers
Calculations
BR
Y
='
96values'!
AR5
EMPL95_
S
FY
1995
Site
Production
Workers
Calculations
BS
Y
='
96values'!
AS5
EMPL96_
S
FY
1996
Site
Production
Workers
Calculations
BT
Y
='
96values'!
AT5
Average
Site
Employment
Site
Employment
Calculations
BU
Y
=
IF(
ISERR(
SUMPRODUCT(
BF5:
BH5,
BR5:
BT5)/
SUM(
BF5:
BH5)),
0,
SUMPRO
DUCT(
BF5:
BH5,
BR5:
BT5)/
SUM(
BF5:
BH5))
INVEN94
FY
1994
Inventories,
1996$
Calculations
BV
Y
='
96values'!
AU5
INVEN95
FY
1995
Inventories,
1996$
Calculations
BW
Y
='
96values'!
AV5
INVEN96
FY
1996
Inventories,
1996$
Calculations
BX
Y
='
96values'!
AW5
Average
Inventories
Inventories,
1996$
Calculations
BY
Y
=(
SUM(
BV5:
BX5))/$
S5
CURASS94
FY
1994
Other
Current
Assets,
1996$
Calculations
BZ
Y
='
96values'!
AX5
CURASS95
FY
1995
Other
Current
Assets,
1996$
Calculations
CA
Y
='
96values'!
AY5
CURASS96
FY
1996
Other
Current
Assets,
1996$
Calculations
CB
Y
='
96values'!
AZ5
Average
Other
Current
Assets
Other
Current
Assets,
1996$
Calculations
CC
Y
=(
SUM(
BZ5:
CB5))/$
S5
EQUITY94
FY
1994
Owner
Equity,
1996$
Calculations
CD
Y
='
96values'!
BA5
EQUITY95
FY
1995
Owner
Equity,
1996$
Calculations
CE
Y
='
96values'!
BB5
EQUITY96
FY
1996
Owner
Equity,
1996$
Calculations
CF
Y
='
96values'!
BC5
Average
Equity
Equity,
1996$
Calculations
CG
Y
=(
SUM(
CD5:
CF5))/$
S5
NONASS94
FY
1994
Noncurrent
Assets,
1996$
Calculations
CH
Y
='
96values'!
BE5
NONASS95
FY
1995
Noncurrent
Assets,
1996$
Calculations
CI
Y
='
96values'!
BF5
NONASS96
FY
1996
Noncurrent
Assets,
1996$
Calculations
CJ
Y
='
96values'!
BG5
February
14,
2003
Page
4
of
64
IMPORT_
Final.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
A
B
C
D
E
F
VARIABLE
DESCRIPTIONS
FOR
IMPORT_
FINAL.
XLS
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
Average
Non­
Current
Assets
Noncurrent
Assets,
1996$
Calculations
CK
Y
=(
SUM(
CH5:
CJ5))/$
S5
SID
Site
ID
RawData
A
N
=
Import!
A6
REV_
AVG
Average
Revenue,
1996$
RawData
B
Y
=
IF(
ISERR(
Calculations!
F5),
0,
Calculations!
F5)
COST_
TOT
Total
Costs,
1996$
RawData
C
Y
=
IF(
ISERR(
Calculations!
J5),
0,
Calculations!
J5)
COST_
INT
Interest,
1996$
RawData
D
Y
=
IF(
ISERR(
Calculations!
N5),
0,
Calculations!
N5)
COST_
TAX
Taxes,
1996$
RawData
E
Y
=
IF(
ISERR(
Calculations!
R5),
0,
Calculations!
R5)
LV_
NET
Net
Liquidation
Value,
1996$
RawData
F
Y
=
Import!
N6
INT
Interest
Rate,
Site,
1996$
RawData
G
Y
=
Import!
O6
DEBT
Total
Debt,
1996$
RawData
H
Y
=
IF(
ISERR(
Calculations!
AB5),
0,
Calculations!
AB5)
ASSETS
Total
Assets,
1996$
RawData
I
Y
=
IF(
ISERR(
Calculations!
AF5),
0,
Calculations!
AF5)
DEPR
Depreciation
Expense,
1996$
RawData
J
Y
=
IF(
ISERR(
Calculations!
AJ5),
0,
Calculations!
AJ5)
FIRM_
REV
Firm
Revenue,
1996$
RawData
K
Y
=
IF(
ISERR(
Calculations!
AN5),
0,
Calculations!
AN5)
CURR_
LIA
Current
Liabilities,
1996$
RawData
L
Y
=
IF(
ISERR(
Calculations!
W5),
0,
Calculations!
W5)
NON_
LIA
Non­
Current
Liabilities,
1996$
RawData
M
Y
=
IF(
ISERR(
Calculations!
AA5),
0,
Calculations!
AA5)
UNIT_
REV
Unit
Revenues,
1996$
RawData
N
Y
=
Calculations!
AU5
UNIT_
COST
Unit
Costs,
1996$
RawData
O
Y
=
Calculations!
BB5
UNIT_
EMP
Unit
Employment
RawData
P
Y
=
Calculations!
BI5
SITE_
REV
Site
Revenues,
1996$
RawData
Q
Y
=
Calculations!
BM5
SITE_
COST
Site
Costs,
1996$
RawData
R
Y
=
Calculations!
BQ5
SITE_
EMP
Site
Employment
RawData
S
Y
=
Calculations!
BU5
UNITDATA
Unit
Data
Provided?
1=
yes,
0=
no
RawData
T
Y
=
Import!
AW6
REVREP6
Unit/
Site
Data
for
Question
6;
1=
unit,
2=
site
RawData
U
Y
=
Import!
AX6
REVREP7
Unit/
Site
Data
for
Question
7;
1=
unit,
2=
site
RawData
V
Y
=
Import!
AY6
INVENT
Inventories,
1996$
RawData
W
Y
=
Calculations!
BY5
OTHCURRASS
Other
Current
Assets,
1996$
RawData
X
Y
=
Calculations!
CC5
EQUITY
Equity,
1996$
RawData
Y
Y
=
Calculations!
CG5
NONASS
Noncurrent
Assets,
1996$
RawData
Z
Y
=
Calculations!
CK5
SID
Site
ID
Manual
Changes
A
N
REV_
AVG
Average
Revenue
Manual
Changes
B
Y
COST_
TOT
Total
Costs
Manual
Changes
C
Y
COST_
INT
Interest
Manual
Changes
D
Y
COST_
TAX
Taxes
Manual
Changes
E
Y
LV_
NET
Net
LV
Manual
Changes
F
Y
INT
Interest
Rate,
Site
Manual
Changes
G
Y
DEBT
Total
Debt
Manual
Changes
H
Y
ASSETS
Total
Assets
Manual
Changes
I
Y
DEPR
Depreciation
Expense
Manual
Changes
J
Y
FIRM_
REV
Firm
Revenue
Manual
Changes
K
Y
CURR_
LIA
Current
Liabilities
Manual
Changes
L
Y
NON_
LIA
Non­
Current
Liabilities
Manual
Changes
M
Y
UNIT_
REV
Unit
Revenues
Manual
Changes
N
Y
UNIT_
COST
Unit
Costs
Manual
Changes
O
Y
UNIT_
EMP
Unit
Employment
Manual
Changes
P
Y
SITE_
REV
Site
Revenues
Manual
Changes
Q
Y
SITE_
COST
Site
Costs
Manual
Changes
R
Y
SITE_
EMP
Site
Employment
Manual
Changes
S
Y
UNITDATA
Unit
Data
Provided
Manual
Changes
T
Y
REVREP6
Unit/
Site
Data
for
Question
6
Manual
Changes
U
Y
REVREP7
Unit/
Site
Data
for
Question
7
Manual
Changes
V
Y
SID
Site
ID
Final
Data
A
N
REV_
AVG
Average
Revenue
Final
Data
B
Y
=
IF(
RawData!
B2=
0,'
Manual
Changes'!
B3,
RawData!
B2)
COST_
TOT
Total
Costs
Final
Data
C
Y
=
IF(
RawData!
C2=
0,'
Manual
Changes'!
C3,
RawData!
C2)
COST_
INT
Interest
Final
Data
D
Y
=
IF(
RawData!
D2=
0,'
Manual
Changes'!
D3,
RawData!
D2)
COST_
TAX
Taxes
Final
Data
E
Y
=
IF(
RawData!
E2=
0,'
Manual
Changes'!
E3,
RawData!
E2)
LV_
NET
Net
LV
Final
Data
F
Y
=
IF(
RawData!
F2=
0,'
Manual
Changes'!
F3,
RawData!
F2)
INT
Interest
Rate,
Site
Final
Data
G
Y
=
IF(
RawData!
G2=
0,'
Manual
Changes'!
G3,
RawData!
G2)
DEBT
Total
Debt
Final
Data
H
Y
=
IF(
RawData!
H2=
0,'
Manual
Changes'!
H3,
RawData!
H2)

February
14,
2003
Page
5
of
64
IMPORT_
Final.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
A
B
C
D
E
F
VARIABLE
DESCRIPTIONS
FOR
IMPORT_
FINAL.
XLS
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
282
283
284
285
286
287
288
289
290
291
292
293
294
295
ASSETS
Total
Assets
Final
Data
I
Y
=
IF(
RawData!
I2=
0,'
Manual
Changes'!
I3,
RawData!
I2)
DEPR
Depreciation
Expense
Final
Data
J
Y
=
IF(
RawData!
J2=
0,'
Manual
Changes'!
J3,
RawData!
J2)
FIRM_
REV
Firm
Revenue
Final
Data
K
Y
=
IF(
RawData!
K2=
0,'
Manual
Changes'!
K3,
RawData!
K2)
CURR_
LIA
Current
Liabilities
Final
Data
L
Y
=
IF(
RawData!
L2=
0,'
Manual
Changes'!
L3,
RawData!
L2)
NON_
LIA
Non­
Current
Liabilities
Final
Data
M
Y
=
IF(
RawData!
M2=
0,'
Manual
Changes'!
M3,
RawData!
M2)
UNIT_
REV
Unit
Revenues
Final
Data
N
Y
=
IF(
RawData!
N2=
0,'
Manual
Changes'!
N3,
RawData!
N2)
UNIT_
COST
Unit
Costs
Final
Data
O
Y
=
IF(
RawData!
O2=
0,'
Manual
Changes'!
O3,
RawData!
O2)
UNIT_
EMP
Unit
Employment
Final
Data
P
Y
=
IF(
RawData!
P2=
0,'
Manual
Changes'!
P3,
RawData!
P2)
SITE_
REV
Site
Revenues
Final
Data
Q
Y
=
IF(
RawData!
Q2=
0,'
Manual
Changes'!
Q3,
RawData!
Q2)
SITE_
COST
Site
Costs
Final
Data
R
Y
=
IF(
RawData!
R2=
0,'
Manual
Changes'!
R3,
RawData!
R2)
SITE_
EMP
Site
Employment
Final
Data
S
Y
=
IF(
RawData!
S2=
0,'
Manual
Changes'!
S3,
RawData!
S2)
UNITDATA
Unit
Data
Provided
Final
Data
T
Y
=
IF(
RawData!
T2=
0,'
Manual
Changes'!
T3,
RawData!
T2)
REVREP6
Unit/
Site
Data
for
Question
6
Final
Data
U
Y
=
IF(
RawData!
U2=
0,'
Manual
Changes'!
U3,
RawData!
U2)
REVREP7
Unit/
Site
Data
for
Question
7
Final
Data
V
Y
=
IF(
RawData!
V2=
0,'
Manual
Changes'!
V3,
RawData!
V2)

February
14,
2003
Page
6
of
64
IMPORT_
Final.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
123
456789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
A
B
C
D
E
F
G
H
I
J
K
L
Sector­
Specific
PPI
Values
Comes
from
"
PPI­
crosstab
updated"
query
in
PPI.
mdb
Sector
Abbr
1987
1988
1989
1990
1991
1992
1993
1994
1995
1996
1
HW
107.52
113.25
118.59
121.50
123.42
124.28
125.72
128.46
133.02
135.23
2
AI
101.23
103.89
109.93
115.25
119.82
124.27
127.89
131.69
134.84
138.03
3
EE
105.64
106.68
108.54
110.08
111.25
112.46
114.42
114.87
114.91
114.88
4
SI
108.74
112.57
117.92
122.44
125.85
128.04
130.53
132.78
136.31
139.29
5
OR
102.36
104.98
107.84
108.99
113.00
117.32
121.34
123.07
125.21
125.76
6
AS
101.23
103.89
109.93
115.25
119.82
124.27
127.89
131.69
134.84
138.03
7
MI
113.96
116.85
122.41
126.57
129.65
133.22
136.47
139.22
143.12
146.99
8
IN
99.40
102.48
106.70
110.53
114.06
117.37
120.88
123.07
125.00
126.35
9
PM
106.63
110.17
113.15
116.78
118.87
120.07
121.71
123.03
124.60
126.26
10
SB
110.02
113.28
117.74
120.94
122.25
126.34
131.43
135.01
137.60
141.09
11
HE
112.82
116.96
121.21
123.78
124.89
125.76
127.40
129.79
132.86
136.80
12
RR
101.90
103.70
110.00
114.20
117.30
118.70
119.80
122.60
127.60
129.60
13
MV
109.66
110.99
114.07
116.24
119.89
122.34
124.83
127.84
128.84
129.70
14
BT
115.41
118.64
123.89
125.48
128.10
131.14
133.38
137.58
146.89
149.12
15
OF
118.37
113.36
106.16
99.86
95.48
86.09
79.19
72.54
66.30
62.03
16
PC
97.13
97.22
98.55
99.59
99.40
99.40
97.10
95.00
95.10
95.90
17
JS
106.71
110.63
115.70
117.51
118.67
119.45
121.31
122.04
124.30
125.50
18
OM
103.73
106.55
111.00
113.95
115.04
116.45
117.72
118.80
121.65
123.35
19
IS
99.59
110.04
113.05
111.57
110.38
109.59
112.33
117.71
123.77
121.68
UNK
106.42
109.27
112.97
115.29
117.22
118.77
120.60
122.46
125.09
126.61
February
14,
2003
Page
7
of
64
IMPORT_
Final.
xls
­
PPIs
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3456789
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
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
RAW
SURVEY
DATA
Data
Imported
from
Access
Table
"
Import"
in
"
ShrtLong"

SID
REVENU94
REVENU95
REVENU96
TOTAL94
TOTAL95
TOTAL96
INTRST94
INTRST95
INTRST96
TAXES94
TAXES95
TAXES96
LIQUIDAT
INT_
RATE
CURLIA94
CURLIA95
CURLIA96
1
2
5
6
8
9
21
22
26
27
29
36
37
41
44
45
47
49
50
51
53
61
62
64
67
71
74
75
79
81
87
89
90
91
92
95
97
99
103
106
108
110
111
113
116
121
122
126
127
128
131
137
140
146
Note:
All
data
except
site
identification
not
shown
to
protect
confidential
business
information.
Sample
page
provided
to
show
structure
of
worksheet.
February
14,
2003
Page
8
of
64
IMPORT_
Final.
xls
­
Import
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3456789
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
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
AG
AH
AI
NONLIA94
NONLIA95
NONLIA96
TOTASS94
TOTASS95
TOTASS96
DEPREC94
DEPREC95
DEPREC96
REV94_
P
REV95_
P
REV96_
P
REV94_
U
REV95_
U
REV96_
U
COST94_
U
COST95_
U
Note:
All
data
except
site
identification
not
shown
to
protect
confidential
business
information.
Sample
page
provided
to
show
structure
of
worksheet.
February
14,
2003
Page
9
of
64
IMPORT_
Final.
xls
­
Import
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3456789
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
AJ
AK
AL
AM
AN
AO
AP
AQ
AR
AS
AT
AU
AV
AW
AX
AY
AZ
COST96_
U
EMPL94_
U
EMPL95_
U
EMPL96_
U
REV94_
S
REV95_
S
REV96_
S
COST94_
S
COST95_
S
COST96_
S
EMPL94_
S
EMPL95_
S
EMPL96_
S
UNITDATA
REVREP6
REVREP7
INVEN94
Note:
All
data
except
site
identification
not
shown
to
protect
confidential
business
information.
Sample
page
provided
to
show
structure
of
worksheet.
February
14,
2003
Page
10
of
64
IMPORT_
Final.
xls
­
Import
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3456789
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
BA
BB
BC
BD
BE
BF
BG
BH
BI
BJ
BK
INVEN95
INVEN96
CURASS94
CURASS95
CURASS96
EQUITY94
EQUITY95
EQUITY96
NONASS94
NONASS95
NONASS96
Note:
All
data
except
site
identification
not
shown
to
protect
confidential
business
information.
Sample
page
provided
to
show
structure
of
worksheet.
February
14,
2003
Page
11
of
64
IMPORT_
Final.
xls
­
Import
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
3
456789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
Updates
all
values
to
1996
using
the
PPI
SID
SECTOR
REVENU94
REVENU95
REVENU96
TOTAL94
TOTAL95
TOTAL96
INTRST94
INTRST95
INTRST96
TAXES94
TAXES95
TAXES96
CURLIA94
1
2
5
6
8
9
21
22
26
27
29
36
37
41
44
45
47
49
50
51
53
61
62
64
67
71
74
75
79
81
87
89
90
91
92
95
97
99
103
106
108
110
111
113
116
121
122
126
127
128
131
137
140
146
Note:
All
data
except
site
identification
not
shown
to
protect
confidential
business
information.
Sample
page
provided
to
show
structure
of
worksheet.
February
14,
2003
Page
12
of
64
IMPORT_
Final.
xls
­
96values
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
3
456789
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
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
CURLIA95
CURLIA96
NONLIA94
NONLIA95
NONLIA96
TOTASS94
TOTASS95
TOTASS96
DEPREC94
DEPREC95
DEPREC96
REV94_
P
REV95_
P
REV96_
P
Note:
All
data
except
site
identification
not
shown
to
protect
confidential
business
information.
Sample
page
provided
to
show
structure
of
worksheet.
February
14,
2003
Page
13
of
64
IMPORT_
Final.
xls
­
96values
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
3
456789
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
AD
AE
AF
AG
AH
AI
AJ
AK
AL
AM
AN
AO
AP
AQ
REV94_
U
REV95_
U
REV96_
U
COST94_
U
COST95_
U
COST96_
U
EMPL94_
U
EMPL95_
U
EMPL96_
U
REV94_
S
REV95_
S
REV96_
S
COST94_
S
COST95_
S
Note:
All
data
except
site
identification
not
shown
to
protect
confidential
business
information.
Sample
page
provided
to
show
structure
of
worksheet.
February
14,
2003
Page
14
of
64
IMPORT_
Final.
xls
­
96values
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
3
456789
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
AR
AS
AT
AU
AV
AW
AX
AY
AZ
BA
BB
BC
BD
BE
COST96_
S
EMPL94_
S
EMPL95_
S
EMPL96_
S
INVEN94
INVEN95
INVEN96
CURASS94
CURASS95
CURASS96
EQUITY94
EQUITY95
EQUITY96
NONASS94
Note:
All
data
except
site
identification
not
shown
to
protect
confidential
business
information.
Sample
page
provided
to
show
structure
of
worksheet.
February
14,
2003
Page
15
of
64
IMPORT_
Final.
xls
­
96values
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
3
456789
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
BF
BG
NONASS95
NONASS96
Note:
All
data
except
site
identification
not
shown
to
protect
confidential
business
information.
Sample
page
provided
to
show
structure
of
worksheet.
February
14,
2003
Page
16
of
64
IMPORT_
Final.
xls
­
96values
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
3
456789
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
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
Calculates
Averages
SID
Income
Statement
Years
REVENU94
REVENU95
REVENU96
Avg.
Revenue
TOTAL94
TOTAL95
TOTAL96
Avg.
Total
Cost
INTRST94
INTRST95
INTRST96
Avg
Interest
TAXES94
1
3
2
3
5
3
6
3
8
3
9
3
21
3
22
3
26
2
27
1
29
2
36
3
37
3
41
3
44
3
45
3
47
1
49
1
50
3
51
3
53
3
61
3
62
1
64
3
67
3
71
3
74
3
75
3
79
3
81
3
87
1
89
3
90
3
91
3
92
3
95
3
97
3
99
3
103
3
106
3
108
3
110
3
111
3
113
3
116
3
121
3
122
3
126
3
127
2
128
3
131
3
137
1
February
14,
2003
Page
17
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
3
456789
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
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
TAXES95
TAXES96
Average
Taxes
Balance
Sheet
Years
CURLIA94
CURLIA95
CURLIA96
Avg.
Curr.
Lia.
NONLIA94
NONLIA95
NONLIA96
Avg.
Noncurr.
Lia.
Avg.
Debt
TOTASS94
3
3
0
3
3
3
3
3
2
1
2
3
3
3
3
3
0
1
3
3
3
3
1
3
3
3
3
3
3
3
1
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
2
3
3
1
February
14,
2003
Page
18
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
3
456789
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
AD
AE
AF
AG
AH
AI
AJ
AK
AL
AM
AN
AO
AP
AQ
TOTASS95
TOTASS96
Avg.
Assets
DEPREC94
DEPREC95
DEPREC96
Avg.
Deprec
REV94_
P
REV95_
P
REV96_
P
Avg.
Firm
Rev.
REV94_
U
REV95_
U
REV96_
U
February
14,
2003
Page
19
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
3
456789
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
AR
AS
AT
AU
AV
AW
AX
AY
AZ
BA
BB
REVBOTH94
REVBOTH95
REVBOTH96
Average
Unit
Revenues
COST94_
U
COST95_
U
COST96_
U
COSTBOTH94
COSTBOTH95
COSTBOTH96
Average
Unit
Costs
February
14,
2003
Page
20
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
3
456789
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
BC
BD
BE
BF
BG
BH
BI
BJ
BK
BL
BM
BN
EMPL94_
U
EMPL95_
U
EMPL96_
U
EMPBOTH94
EMPBOTH95
EMPBOTH96
Average
Unit
Employment
REV94_
S
REV95_
S
REV96_
S
Average
Site
Revenues
COST94_
S
February
14,
2003
Page
21
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
3
456789
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
BO
BP
BQ
BR
BS
BT
BU
BV
BW
BX
BY
BZ
CA
CB
COST95_
S
COST96_
S
Average
Site
Costs
EMPL94_
S
EMPL95_
S
EMPL96_
S
Average
Site
Employment
INVEN94
INVEN95
INVEN96
Average
Inventories
CURASS94
CURASS95
CURASS96
February
14,
2003
Page
22
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
3
456789
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
CC
CD
CE
CF
CG
CH
CI
CJ
CK
Average
Other
Current
Assets
EQUITY94
EQUITY95
EQUITY96
Average
Equity
NONASS94
NONASS95
NONASS96
Average
Non­
Current
Assets
February
14,
2003
Page
23
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
SID
Income
Statement
Years
REVENU94
REVENU95
REVENU96
Avg.
Revenue
TOTAL94
TOTAL95
TOTAL96
Avg.
Total
Cost
INTRST94
INTRST95
INTRST96
Avg
Interest
TAXES94
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
140
3
146
1
150
3
151
3
153
3
156
3
157
3
161
3
173
3
176
3
182
3
186
0
189
3
192
3
195
3
196
3
201
3
203
3
204
3
207
3
211
3
215
3
222
3
224
0
225
3
228
3
231
3
234
2
237
3
240
3
241
3
242
3
243
3
246
3
250
3
253
3
255
3
257
3
259
3
263
3
269
3
270
3
271
3
286
3
290
3
291
3
295
3
298
3
299
3
300
2
307
3
308
3
310
3
312
2
316
3
324
3
February
14,
2003
Page
24
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
TAXES95
TAXES96
Average
Taxes
Balance
Sheet
Years
CURLIA94
CURLIA95
CURLIA96
Avg.
Curr.
Lia.
NONLIA94
NONLIA95
NONLIA96
Avg.
Noncurr.
Lia.
Avg.
Debt
TOTASS94
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
3
1
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
0
3
3
3
2
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
2
3
3
3
2
3
3
February
14,
2003
Page
25
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
AD
AE
AF
AG
AH
AI
AJ
AK
AL
AM
AN
AO
AP
AQ
TOTASS95
TOTASS96
Avg.
Assets
DEPREC94
DEPREC95
DEPREC96
Avg.
Deprec
REV94_
P
REV95_
P
REV96_
P
Avg.
Firm
Rev.
REV94_
U
REV95_
U
REV96_
U
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
February
14,
2003
Page
26
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
AR
AS
AT
AU
AV
AW
AX
AY
AZ
BA
BB
REVBOTH94
REVBOTH95
REVBOTH96
Average
Unit
Revenues
COST94_
U
COST95_
U
COST96_
U
COSTBOTH94
COSTBOTH95
COSTBOTH96
Average
Unit
Costs
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
February
14,
2003
Page
27
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
BC
BD
BE
BF
BG
BH
BI
BJ
BK
BL
BM
BN
EMPL94_
U
EMPL95_
U
EMPL96_
U
EMPBOTH94
EMPBOTH95
EMPBOTH96
Average
Unit
Employment
REV94_
S
REV95_
S
REV96_
S
Average
Site
Revenues
COST94_
S
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
February
14,
2003
Page
28
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
BO
BP
BQ
BR
BS
BT
BU
BV
BW
BX
BY
BZ
CA
CB
COST95_
S
COST96_
S
Average
Site
Costs
EMPL94_
S
EMPL95_
S
EMPL96_
S
Average
Site
Employment
INVEN94
INVEN95
INVEN96
Average
Inventories
CURASS94
CURASS95
CURASS96
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
February
14,
2003
Page
29
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
CC
CD
CE
CF
CG
CH
CI
CJ
CK
Average
Other
Current
Assets
EQUITY94
EQUITY95
EQUITY96
Average
Equity
NONASS94
NONASS95
NONASS96
Average
Non­
Current
Assets
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
February
14,
2003
Page
30
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
SID
Income
Statement
Years
REVENU94
REVENU95
REVENU96
Avg.
Revenue
TOTAL94
TOTAL95
TOTAL96
Avg.
Total
Cost
INTRST94
INTRST95
INTRST96
Avg
Interest
TAXES94
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
327
3
328
3
329
3
330
3
334
3
339
3
342
3
349
3
350
3
355
3
357
3
371
3
372
3
374
3
383
3
392
3
393
3
400
3
401
3
402
3
406
3
407
3
411
3
412
3
417
3
419
3
420
3
421
3
423
3
430
3
433
3
434
3
435
3
438
3
439
3
443
3
445
3
448
3
449
3
450
3
453
3
455
3
460
3
463
3
471
3
476
3
477
3
482
3
487
3
494
3
495
3
497
3
498
3
501
3
503
3
505
3
February
14,
2003
Page
31
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
TAXES95
TAXES96
Average
Taxes
Balance
Sheet
Years
CURLIA94
CURLIA95
CURLIA96
Avg.
Curr.
Lia.
NONLIA94
NONLIA95
NONLIA96
Avg.
Noncurr.
Lia.
Avg.
Debt
TOTASS94
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
3
3
3
3
3
3
3
3
3
3
3
3
3
2
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
2
3
3
3
0
3
3
3
2
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
February
14,
2003
Page
32
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
AD
AE
AF
AG
AH
AI
AJ
AK
AL
AM
AN
AO
AP
AQ
TOTASS95
TOTASS96
Avg.
Assets
DEPREC94
DEPREC95
DEPREC96
Avg.
Deprec
REV94_
P
REV95_
P
REV96_
P
Avg.
Firm
Rev.
REV94_
U
REV95_
U
REV96_
U
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
February
14,
2003
Page
33
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
AR
AS
AT
AU
AV
AW
AX
AY
AZ
BA
BB
REVBOTH94
REVBOTH95
REVBOTH96
Average
Unit
Revenues
COST94_
U
COST95_
U
COST96_
U
COSTBOTH94
COSTBOTH95
COSTBOTH96
Average
Unit
Costs
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
February
14,
2003
Page
34
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
BC
BD
BE
BF
BG
BH
BI
BJ
BK
BL
BM
BN
EMPL94_
U
EMPL95_
U
EMPL96_
U
EMPBOTH94
EMPBOTH95
EMPBOTH96
Average
Unit
Employment
REV94_
S
REV95_
S
REV96_
S
Average
Site
Revenues
COST94_
S
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
February
14,
2003
Page
35
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
BO
BP
BQ
BR
BS
BT
BU
BV
BW
BX
BY
BZ
CA
CB
COST95_
S
COST96_
S
Average
Site
Costs
EMPL94_
S
EMPL95_
S
EMPL96_
S
Average
Site
Employment
INVEN94
INVEN95
INVEN96
Average
Inventories
CURASS94
CURASS95
CURASS96
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
February
14,
2003
Page
36
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
CC
CD
CE
CF
CG
CH
CI
CJ
CK
Average
Other
Current
Assets
EQUITY94
EQUITY95
EQUITY96
Average
Equity
NONASS94
NONASS95
NONASS96
Average
Non­
Current
Assets
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
February
14,
2003
Page
37
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
SID
Income
Statement
Years
REVENU94
REVENU95
REVENU96
Avg.
Revenue
TOTAL94
TOTAL95
TOTAL96
Avg.
Total
Cost
INTRST94
INTRST95
INTRST96
Avg
Interest
TAXES94
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
506
3
507
3
516
3
517
3
519
3
525
3
527
3
528
2
533
3
543
3
547
3
549
3
550
3
552
3
556
3
560
3
563
3
564
3
575
3
577
3
580
3
584
3
587
3
591
3
594
3
598
3
599
3
600
3
606
3
607
3
610
0
619
3
625
3
626
3
628
3
636
3
637
1
639
3
640
3
641
3
643
0
645
3
649
3
650
3
651
3
658
3
660
3
666
1
667
3
668
3
670
3
671
3
674
3
678
2
680
3
682
3
February
14,
2003
Page
38
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
TAXES95
TAXES96
Average
Taxes
Balance
Sheet
Years
CURLIA94
CURLIA95
CURLIA96
Avg.
Curr.
Lia.
NONLIA94
NONLIA95
NONLIA96
Avg.
Noncurr.
Lia.
Avg.
Debt
TOTASS94
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
3
3
3
3
3
3
3
2
3
2
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
1
3
0
3
0
3
3
3
3
3
3
1
3
3
3
3
3
2
3
3
February
14,
2003
Page
39
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
AD
AE
AF
AG
AH
AI
AJ
AK
AL
AM
AN
AO
AP
AQ
TOTASS95
TOTASS96
Avg.
Assets
DEPREC94
DEPREC95
DEPREC96
Avg.
Deprec
REV94_
P
REV95_
P
REV96_
P
Avg.
Firm
Rev.
REV94_
U
REV95_
U
REV96_
U
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
February
14,
2003
Page
40
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
AR
AS
AT
AU
AV
AW
AX
AY
AZ
BA
BB
REVBOTH94
REVBOTH95
REVBOTH96
Average
Unit
Revenues
COST94_
U
COST95_
U
COST96_
U
COSTBOTH94
COSTBOTH95
COSTBOTH96
Average
Unit
Costs
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
February
14,
2003
Page
41
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
BC
BD
BE
BF
BG
BH
BI
BJ
BK
BL
BM
BN
EMPL94_
U
EMPL95_
U
EMPL96_
U
EMPBOTH94
EMPBOTH95
EMPBOTH96
Average
Unit
Employment
REV94_
S
REV95_
S
REV96_
S
Average
Site
Revenues
COST94_
S
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
February
14,
2003
Page
42
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
BO
BP
BQ
BR
BS
BT
BU
BV
BW
BX
BY
BZ
CA
CB
COST95_
S
COST96_
S
Average
Site
Costs
EMPL94_
S
EMPL95_
S
EMPL96_
S
Average
Site
Employment
INVEN94
INVEN95
INVEN96
Average
Inventories
CURASS94
CURASS95
CURASS96
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
February
14,
2003
Page
43
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
CC
CD
CE
CF
CG
CH
CI
CJ
CK
Average
Other
Current
Assets
EQUITY94
EQUITY95
EQUITY96
Average
Equity
NONASS94
NONASS95
NONASS96
Average
Non­
Current
Assets
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
February
14,
2003
Page
44
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
SID
Income
Statement
Years
REVENU94
REVENU95
REVENU96
Avg.
Revenue
TOTAL94
TOTAL95
TOTAL96
Avg.
Total
Cost
INTRST94
INTRST95
INTRST96
Avg
Interest
TAXES94
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
685
3
694
3
698
2
699
1
701
3
702
3
703
3
709
3
712
3
713
3
715
3
716
3
719
3
721
3
722
3
723
3
724
3
725
2
728
3
729
3
733
3
734
3
735
3
737
3
738
1
745
3
748
2
755
3
757
3
759
3
762
3
765
3
766
3
768
3
772
3
773
1
778
3
779
3
782
3
784
3
786
3
788
3
791
3
792
3
793
3
795
3
802
3
804
0
805
3
806
3
811
3
817
3
818
3
819
3
820
3
822
1
February
14,
2003
Page
45
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
TAXES95
TAXES96
Average
Taxes
Balance
Sheet
Years
CURLIA94
CURLIA95
CURLIA96
Avg.
Curr.
Lia.
NONLIA94
NONLIA95
NONLIA96
Avg.
Noncurr.
Lia.
Avg.
Debt
TOTASS94
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
3
3
2
1
3
3
3
3
3
3
3
3
3
3
3
3
3
2
3
0
3
3
3
1
1
3
2
3
3
0
3
3
3
3
3
1
3
3
3
3
3
3
3
3
3
3
2
0
3
3
3
3
3
1
3
1
February
14,
2003
Page
46
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
AD
AE
AF
AG
AH
AI
AJ
AK
AL
AM
AN
AO
AP
AQ
TOTASS95
TOTASS96
Avg.
Assets
DEPREC94
DEPREC95
DEPREC96
Avg.
Deprec
REV94_
P
REV95_
P
REV96_
P
Avg.
Firm
Rev.
REV94_
U
REV95_
U
REV96_
U
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
February
14,
2003
Page
47
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
AR
AS
AT
AU
AV
AW
AX
AY
AZ
BA
BB
REVBOTH94
REVBOTH95
REVBOTH96
Average
Unit
Revenues
COST94_
U
COST95_
U
COST96_
U
COSTBOTH94
COSTBOTH95
COSTBOTH96
Average
Unit
Costs
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
February
14,
2003
Page
48
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
BC
BD
BE
BF
BG
BH
BI
BJ
BK
BL
BM
BN
EMPL94_
U
EMPL95_
U
EMPL96_
U
EMPBOTH94
EMPBOTH95
EMPBOTH96
Average
Unit
Employment
REV94_
S
REV95_
S
REV96_
S
Average
Site
Revenues
COST94_
S
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
February
14,
2003
Page
49
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
BO
BP
BQ
BR
BS
BT
BU
BV
BW
BX
BY
BZ
CA
CB
COST95_
S
COST96_
S
Average
Site
Costs
EMPL94_
S
EMPL95_
S
EMPL96_
S
Average
Site
Employment
INVEN94
INVEN95
INVEN96
Average
Inventories
CURASS94
CURASS95
CURASS96
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
February
14,
2003
Page
50
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
CC
CD
CE
CF
CG
CH
CI
CJ
CK
Average
Other
Current
Assets
EQUITY94
EQUITY95
EQUITY96
Average
Equity
NONASS94
NONASS95
NONASS96
Average
Non­
Current
Assets
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
February
14,
2003
Page
51
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
SID
Income
Statement
Years
REVENU94
REVENU95
REVENU96
Avg.
Revenue
TOTAL94
TOTAL95
TOTAL96
Avg.
Total
Cost
INTRST94
INTRST95
INTRST96
Avg
Interest
TAXES94
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
825
3
830
3
834
3
839
1
841
3
843
3
844
3
846
3
848
3
849
3
862
3
863
3
866
3
869
3
879
3
884
3
887
2
888
1
891
3
894
3
918
3
921
3
922
3
926
3
927
3
930
3
934
3
948
3
February
14,
2003
Page
52
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
TAXES95
TAXES96
Average
Taxes
Balance
Sheet
Years
CURLIA94
CURLIA95
CURLIA96
Avg.
Curr.
Lia.
NONLIA94
NONLIA95
NONLIA96
Avg.
Noncurr.
Lia.
Avg.
Debt
TOTASS94
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
3
3
3
1
3
3
3
3
3
3
3
3
3
3
3
3
2
1
3
3
3
3
3
3
3
3
3
0
February
14,
2003
Page
53
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
AD
AE
AF
AG
AH
AI
AJ
AK
AL
AM
AN
AO
AP
AQ
TOTASS95
TOTASS96
Avg.
Assets
DEPREC94
DEPREC95
DEPREC96
Avg.
Deprec
REV94_
P
REV95_
P
REV96_
P
Avg.
Firm
Rev.
REV94_
U
REV95_
U
REV96_
U
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
February
14,
2003
Page
54
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
AR
AS
AT
AU
AV
AW
AX
AY
AZ
BA
BB
REVBOTH94
REVBOTH95
REVBOTH96
Average
Unit
Revenues
COST94_
U
COST95_
U
COST96_
U
COSTBOTH94
COSTBOTH95
COSTBOTH96
Average
Unit
Costs
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
February
14,
2003
Page
55
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
BC
BD
BE
BF
BG
BH
BI
BJ
BK
BL
BM
BN
EMPL94_
U
EMPL95_
U
EMPL96_
U
EMPBOTH94
EMPBOTH95
EMPBOTH96
Average
Unit
Employment
REV94_
S
REV95_
S
REV96_
S
Average
Site
Revenues
COST94_
S
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
February
14,
2003
Page
56
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
BO
BP
BQ
BR
BS
BT
BU
BV
BW
BX
BY
BZ
CA
CB
COST95_
S
COST96_
S
Average
Site
Costs
EMPL94_
S
EMPL95_
S
EMPL96_
S
Average
Site
Employment
INVEN94
INVEN95
INVEN96
Average
Inventories
CURASS94
CURASS95
CURASS96
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
February
14,
2003
Page
57
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
4
CC
CD
CE
CF
CG
CH
CI
CJ
CK
Average
Other
Current
Assets
EQUITY94
EQUITY95
EQUITY96
Average
Equity
NONASS94
NONASS95
NONASS96
Average
Non­
Current
Assets
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
February
14,
2003
Page
58
of
64
IMPORT_
Final.
xls
­
Calculations
Record
for
the
Final
Metal
Product
and
Machinery
Rule
123456789
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
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
SID
REV_
AVG
COST_
TOT
COST_
INT
COST_
TAX
LV_
NET
INT
DEBT
ASSETS
DEPR
FIRM_
REV
CURR_
LIA
NON_
LIA
UNIT_
REV
UNIT_
COST
UNIT_
EMP
SITE_
REV
SITE_
COST
SITE_
EMP
1
2
5
6
8
9
21
22
26
27
29
36
37
41
44
45
47
49
50
51
53
61
62
64
67
71
74
75
79
81
87
89
90
91
92
95
97
99
103
106
108
110
111
113
116
121
122
126
127
128
131
137
140
146
150
151
153
156
Note:
All
data
except
site
identification
not
shown
to
protect
confidential
business
information.
Sample
page
provided
to
show
structure
of
worksheet.
February
14,
2003
Page
59
of
64
IMPORT_
Final.
xls
­
RawData
Record
for
the
Final
Metal
Product
and
Machinery
Rule
123456789
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
T
U
V
W
X
Y
Z
UNITDATA
REVREP6
REVREP7
INVENT
OTHCURRASS
EQUITY
NONASS
Note:
All
data
except
site
identification
not
shown
to
protect
confidential
business
information.
Sample
page
provided
to
show
structure
of
worksheet.
February
14,
2003
Page
60
of
64
IMPORT_
Final.
xls
­
RawData
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3456789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Site
ID
Average
Revenue
Total
Costs
Interest
Taxes
Net
LV
Interest
Rate,
Site
Total
Debt
Total
Assets
Depreciation
Expense
Firm
Revenue
Current
Liabilities
Non­
Current
Liabilities
Unit
Revenues
Unit
Costs
Unit
Employment
SID
REV_
AVG
COST_
TOT
COST_
INT
COST_
TAX
LV_
NET
INT
DEBT
ASSETS
DEPR
FIRM_
REV
CURR_
LIA
NON_
LIA
UNIT_
REV
UNIT_
COST
UNIT_
EMP
1
2
3
5
6
7
8
9
10
11
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
49
50
51
52
53
55
57
58
59
60
61
62
64
65
67
68
69
Note:
All
data
except
site
identification
not
shown
to
protect
confidential
business
information.
Sample
page
provided
to
show
structure
of
worksheet.
February
14,
2003
Page
61
of
64
IMPORT_
Final.
xls
­
Manual
Changes
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3456789
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
Q
R
S
T
U
V
Site
Revenues
Site
Costs
Site
Employment
Unit
Data
Provided
Unit/
Site
Data
for
Question
6
Unit/
Site
Data
for
Question
7
SITE_
REV
SITE_
COST
SITE_
EMP
UNITDATA
REVREP6
REVREP7
Note:
All
data
except
site
identification
not
shown
to
protect
confidential
business
information.
Sample
page
provided
to
show
structure
of
worksheet.
February
14,
2003
Page
62
of
64
IMPORT_
Final.
xls
­
Manual
Changes
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
3456789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
A
B
C
D
E
F
G
H
I
J
K
L
M
Site
ID
Average
Revenue
Total
Costs
Interest
Taxes
Net
LV
Interest
Rate,
Site
Total
Debt
Total
Assets
Depreciation
Expense
Firm
Revenue
Current
Liabilities
Non­
Current
Liabilities
SID
REV_
AVG
COST_
TOT
COST_
INT
COST_
TAX
LV_
NET
INT
DEBT
ASSETS
DEPR
FIRM_
REV
CURR_
LIA
NON_
LIA
1
2
5
6
8
9
21
22
26
27
29
36
37
41
44
45
47
49
50
51
53
61
62
64
67
71
74
75
79
81
87
89
90
91
92
95
97
99
103
106
108
110
111
113
116
121
122
126
127
128
131
137
140
146
150
151
Note:
All
data
except
site
identification
not
shown
to
protect
confidential
business
information.
Sample
page
provided
to
show
structure
of
worksheet.
February
14,
2003
Page
63
of
64
IMPORT_
Final.
xls
­
Final
Data
Record
for
the
Final
Metal
Product
and
Machinery
Rule
12
3456789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
N
O
P
Q
R
S
T
U
V
Unit
Revenues
Unit
Costs
Unit
Employment
Site
Revenues
Site
Costs
Site
Employment
Unit
Data
Provided
Unit/
Site
Data
for
Question
6
Unit/
Site
Data
for
Question
7
UNIT_
REV
UNIT_
COST
UNIT_
EMP
SITE_
REV
SITE_
COST
SITE_
EMP
UNITDATA
REVREP6
REVREP7
Note:
All
data
except
site
identification
not
shown
to
protect
confidential
business
information.
Sample
page
provided
to
show
structure
of
worksheet.
February
14,
2003
Page
64
of
64
IMPORT_
Final.
xls
­
Final
Data