Document Actions

converting TRI excel sheets to be compatable

by Noah Morales — last modified 11-05-2007 20:22

convert grams to pounds note: when copying values calculated from formulas go to paste values on tool bar

1 gram = 0.00220462262 pounds

=(O2*0.00220462262)

Combine address

First add country column (USA)

=C3&", "&D3&", "&E3& ", "&F3&", "&G3&", "&H3

Delete SIC codes column

change par_com to company

Copy and paste field names of amounts

add field on_landfll

- L_D_S_I

- Oth_Lndfls

- RCRA_SCL

- Oth_Lnd_Dsp

add field tot_onsite

- lnd_rele

- on_landfll

- undgr_Inj

- on_land_trt

- Srf_Imp

add field tot_rele

- tot_onsite

- Srf_Wtr_Dis

- Air_Emmsn

- Unkwn

Change blanks to unkwn, so no <null> values in attribute table

air_rele

wtr_rele

Stream

lnd_rele

L_D_S_I

Oth_Lndfls

RCRA_SCL

on_lnd_trt

Oth_Lnd_Dsp

undgr_Inj

Srf_Imp

unkwn