Personal tools
Home » Members » Noah Morales » Toxic_Release_Data » converting TRI excel sheets to be compatable
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
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







Built with Plone