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

OVERVIEW
OF
SPREADSHEETS
AND
ACCESS
DATABASES
USED
FOR
THE
FINAL
ECONOMIC
IMPACT
ANALYSES
DCN
CBI?
Section
Title/
Subject
Contractor
Description
Source
Links
37053
Y
25.3.1
CompCost._
Final.
xls
Abt
Calculates
annualized
compliance
costs
and
converts
them
to
2001
dollars.
Compliance
Cost
Files
None
37054
Y
25.3.1
MPCT_
Final.
xls
Abt
Calculates
financial
impacts
and
estimates
closures
and
output
lost
at
each
MP&
M
Phase
I
and
Phase
II
facility.
Survey
Data
and
Compliance
Cost
Files
$
CompCost_
Final.
xls
$
FacData_
Final.
xls
$
Import_
Final.
xls
$
Import_
P1.
xls
37055
Y
25.3.1
Summary_
Final.
xls
Abt
Pulls
together
data
from
various
spreadsheets
to
calculate
impacts,
costs,

and
cost­
effectiveness
for
each
facility
in
the
analysis.
$
FacData_
Final.
xls
$
MPCT_
Final.
xls
$
I&
S_
MPCT_
Final.
xls
$
RailMPCT_
Final.
xls
$
MuniMPCT_
Final.
xls
$
Removals.
mdb
37056
Y
25.3.1
Import_
Final.
xls
Abt
Updates
Phase
II
survey
data
from
1994
and
1995
values
to
1996
dollars
using
sector­
specific
producer
price
indices
and
then
averages
data
across
all
three
years
to
create
an
average
value
in
1996
dollars.
Phase
II
survey
data
PPI.
mdb
None
37057
Y
25.3.1
FacData_
Final.
xls
Abt
Pulls
together
discharge
status,
weights,
firm
size,
sector,
and
subcategory
from
various
sources.
Compliance
Cost
Files
$
Small._
Final.
xls
$
MuniMPCT_
Final.
xls
$
RailMPCT_
Final.
xls
37058
Y
25.3.1
RailMPCT_
Final.
xls
Abt
Calculates
financial
impacts
and
output
lost
at
each
MP&
M
Railroad
Operating
Unit.
Survey
data
and
compliance
costs.
Survey
Data
and
Compliance
Cost
Files
$
CompCost_
Final.
xls
$
FacData_
Final.
xls
37059
Y
25.3.1
I&
S_
MPCT_
Final.
xls
Abt
Calculates
financial
impacts
and
estimates
closures
and
output
lost
at
each
MP&
M
Iron
and
Steel
facility.
Survey
Data
and
Compliance
Cost
Files
$
CompCost_
Final.
xls
$
FacData_
Final.
xls
37060
Y
25.3.1
RevbySct_
Final.
xls
Abt
Determines
sector
accounting
for
largest
revenues
for
each
facility.
Phase
1,
Phase
2,
and
Municipality
survey
data
$
FacData_
Final.
xls
37061
Y
25.3.1
RMA_
DATA.
xls
Abt
Derives
sector
specific
moderate
impact
thresholds.
Data
by
SIC
with
Estimates
97.
xls
Risk
Management
Association,
Annual
Statement
Studies
$
SIC_
Key.
xls
37062
Y
25.3.1
CompCost._
July.
xls
Abt
Calculates
annualized
compliance
costs
and
converts
them
to
2001
dollars
based
on
the
July,
2002
analysis.
Compliance
Cost
Files
None
37063
Y
25.3.1
MPCT_
July.
xls
Abt
Calculates
financial
impacts
and
estimates
closures
and
output
lost
at
each
MP&
M
Phase
I
and
Phase
II
facility
based
on
the
July,
2002
analysis.
Survey
Data
and
Compliance
Cost
Files
$
CompCost_
July.
xls
$
FacData_
July.
xls
37064
Y
25.3.1
Summary_
July.
xls
Abt
Pulls
together
data
from
various
spreadsheets
to
calculate
impacts,
costs,

and
cost­
effectiveness
for
each
facility
in
the
analysis
based
on
the
July,

2002
analysis.
Compliance
Cost
and
Loadings
Files
$
FacData_
July.
xls
$
MPCT_
July.
xls
$
I&
S_
MPCT_
July.
xls
$
RailMPCT_
Julyl.
xls
$
MuniMPCT_
July.
xls
37065
Y
25.3.1
FacData_
July.
xls
Abt
Pulls
together
discharge
status,
weights,
firm
size,
sector,
and
subcategory
from
various
sources
based
on
the
July,
2002
analysis.
Compliance
Cost
Files
$
RailMPCT_
July.
xls
37066
Y
25.3.1
RailMPCT_
July.
xls
Abt
Calculates
financial
impacts
and
output
lost
at
each
MP&
M
Railroad
Operating
Unit.
Survey
data
and
compliance
costs
based
on
the
July,
2002
analysis.
Survey
Data
and
Compliance
Cost
Files
$
CompCost_
July.
xls
$
FacData_
July.
xls
37067
Y
25.3.1
I&
S_
MPCT_
July.
xls
Abt
Calculates
financial
impacts
and
estimates
closures
and
output
lost
at
each
MP&
M
Iron
and
Steel
facility
based
on
the
July,
2002
analysis.
Survey
Data
and
Compliance
Cost
Files
$
CompCost_
July.
xls
$
FacData_
July.
xls
37068
Y
25.3.1
RevbySct_
July.
xls
Abt
Determines
sector
accounting
for
largest
revenues
for
each
facility.
Phase
1,
Phase
2,
and
Municipality
survey
data
$
FacData_
July.
xls
37071
Y
25.3.2
Summary_
Zero.
xls
Abt
Pulls
together
data
from
various
spreadsheets
to
calculate
impacts,
costs,
and
cost­
effectiveness
for
each
facility
in
the
analysis
using
a
zero
cost
passthrough
assumption.
Compliance
Cost
and
Loading
Files
$
MPCT_
Zero.
xls
37072
Y
25.3.2
MPCT_
Zero.
xls
Abt
Calculates
financial
impacts
and
estimates
closures
and
output
lost
at
each
MP&
M
Phase
I
and
Phase
II
facility
using
a
zero
cost
pass­
through
assumption.
Survey
Data
and
Compliance
Cost
Files
37075
Y
25.3.3
New
Source(
doubled).
xls
Abt
Calculates
financial
impacts
on
new
sources
assuming
a
two­
stage
precipitation.
Survey
Data
and
Compliance
Cost
Files
for
New
Sources
37076
Y
25.3.3
New
Source(
GMto433).
xls
Abt
Calculates
financial
impacts
on
new
general
metals
facilities
assuming
they
would
be
required
to
meet
the
current
Metal
Finishing
regulations
(
40
CFR
part
433).
Survey
Data
and
Compliance
Cost
Files
for
New
Sources
37077
Y
25.3.3
New
Source.
xls
Abt
Calculates
financial
impacts
on
new
sources.
Survey
Data
and
Compliance
Cost
Files
for
New
Sources
37080
Y
25.3.4
MuniMPCT_
Final.
xls
Abt
Calculates
financial
impacts
and
output
lost
at
each
MP&
M
Municipal
facility.
Municipality
survey
data
$
Mun_
Wgt1.
xls
$
Summary_
Final.
xls
$
CompCost_
Final.
xls
37086
Y
25.3.6
FT_
MPCT_
Final.
xls
Abt
Calculates
foreign
trade
impacts
from
output
lost
on
the
MP&
M
industry
and
the
U.
S.
Census
trade
data
$
Summary_
Final.
xls
$
SIC_
Key.
xls
37092
Y
25.3.7
Small_
Final.
xls
Abt
Determines
entity
size
using
detailed
data
from
MP&
M
Phase
II
long
and
short
surveys,
Phase
I
surveys
and
the
Iron
and
Steel
surveys.
SBA_
MPM.
xls
None
37096
Y
25.3.8
Firm_
Final.
xls
Abt
Calculates
financial
impacts
on
each
firm
that
owns
a
MP&
M
facility
in
the
analysis.
SBA_
MPM.
xls
$
Summary_
Final.
xls
$
MPCT_
Final.
xls
$
I&
S_
MPCT_
Final.
xls
$
RailMPCT_
Final.
xls