How to do

Shared by: club56
-
Stats
views:
38
posted:
11/14/2008
language:
English
pages:
11
Document Sample
scope of work template
							How to do



         1
         2
         3
         4
         5


Reference to the calculation in the sheets "Calculation details" and "Constants":
         1


         2
How to do
           This tool can calculate effect factors from individually supplied data

           Enter data for your first substance in the sheet "Input" in the cells B2 to B21. You can enter data for additional
           substances in the collumns C to K. You can enter data for up to 10 substances. The present data are for
           demonstration purposes and can be over written.
           Notice the number (1 to 10) in the first row of the substance you want to calculate.
           Go to the sheet "Results" and write this number in the cell A1. The results are presented in columns B to E
           You can check the calculations in the sheet "Calculation details"
           The results are presented in the sheet "Results"
           Constants applied by the calculation are shown in the sheet "Constants"

Reference to the calculation in the sheets "Calculation details" and "Constants":
           Wenzel, H., Hauschild, M. and Alting, L. (1997) Environmental Assessment of Products. Volume 1: Methodology, tools and case studies in
           product development . Chapmann & Hall
           Hauschild, M and Wenzel, H. (1998) Environmental Assessment of Products. Volume 2: Scientific background. Chapmann & Hall
                    A                    B                       C                 D             E      F        G                H           I
 1 No                                    1                       2                  3            4      5        6                7           8
 2 CAS No                     104-76-7                75-56-9                5329-14-6       75-07-0                        64-19-7
 3 Name                       2-Ethyl hexanol         1,2-Propylene oxide    Sulphamic acidAcetaldehyde                     Acetic acid
   Human Toxicity Oral
 4 [mg/kg body]                                1,628                   1,100           3160       4800                               306
   Human Toxicity by Air
 5 [mg/m3 air]                                                        11,000                       273                                0.1
   Ecotoxicity data acute
 6 [mg/m3 water]                               7,500                 100,000          14200                                        10000
   Ecotoxicity data chronic
 7 [mg/m3 water]                               7,500                 100,000          14200                                        10000
 8
 9 AFhuman oral                               10,000                 100,000         100000      10000                              1000
10 AFhuman air                                                       100,000                      1000                                 1
11 AFecotox acute                                 10                      10            100                                            2
12 AFecotox chronic                              100                     100           1000                                           20
13
14 Kd (NOT USED)
   AHL, Half life air OH
   reaction (days) 12 hrs
15 day, 1,5E6 OH/cm3                            0.81                   17.87            76.4       0.63                              17.2
   H, Henry's law konstant
16 (atm*m3/mole, 25 0C)                     4.66E-05                1.23E-04       1.00E-99 6.00E-05                            2.90E-07
   Log Kow, Kow is the
   octanol water partitioning
17 coefficient                                  2.73                    0.03           -4.34      -0.34   -1.6       1.15           -0.17
18
19 BIO, Biodegradbility                           0.2                      1             0.2        0.2                               0.2
   Koc Coefficient of
   adsorption for
   substances in soil
   expressed for organic
20 fraction of soil                               26                   2.324            6.12        1.5   193        25.5                 1
   BCF, Bio Concentration
21 Factor                                         62                   3.162                            3.162    1.533
22 pKa (optional)
23
     J   K    L
1    9   10
2
3

4

5

6

 7
 8
 9
10
11
12
13
14


15

16


17
18
19




20

21
22
23
  7  64-19-7
     Acetic acid
Human Toxicity
     EF(hta) by emission to air                    m3 air/g     1.00E+04
     EF(htw) by emission to air                    m3 water/g   3.28E-06
     EF(hts) by emission to air                    m3 soil/g    1.47E-03

      EF(hta) by emission to water                 m3 air/g     0.00E+00
      EF(htw) by emission to water                 m3 water/g   1.64E-05
      EF(hts) by emission to water                 m3 soil/g    0.00E+00

      EF(hta) by emission to soil                  m3 air/g     0.00E+00
      EF(htw) by emission to soil                  m3 water/g   0.00E+00
      EF(hts) by emission to soil                  m3 soil/g    1.84E-03
Ecotoxicity
      EF(etwc) by emission to air                  m3 water/g   8.00E-02
      EF(etsc) by emission to air                  m3 soil/g    7.36E-01

      EF(etwc) by emission to water                m3 water/g   4.00E-01
      EF(etwa) by emission to water                m3 water/g   2.00E-01
      EF(etsc) by emission to water                m3 soil/g    0.00E+00

      EF(etwc) by emission to soil                 m3 water/g   0.00E+00
      EF(etsc) by emission to soil                 m3 soil/g    9.20E-01

Write the number of the substance in the cell A1
     A                   B                  C                                D                         E                   F
1    Parameters for calculating effect factors for toxixcity
2        Symbol              Parameter                           Unit                                  7            Ref.
3        CAS No              CAS Number                                       -          64-19-7
4        Name                Substance Name                                   -          Acetic acid

                             Human Tox oral, Lowest
                             relevant and reliable human
5        HTo                 toxicity data found, oral admin.      mg / kg body weight                       306
                             Lowest relevant and reliable
                             human toxicity data found,
6        HTa                 inhalation admin.                             mg/m3                                0
7        ETa                 Data for ecotoxicity acute                 mg / m3 water                      10,000
8        ETc                 Data for ecotoxicity chronic               mg / m3 water                      10,000
                             Assessment factor for oral
9        AFho                exposure, human                                  -                             1,000 [2], p 390
                             Assessment factor for
10       AFha                exposure by air, human                           -                                 1 [2], p 390
                             Assessment factor for
11       AFeta               ecotoxicity acute                                -                                 2 [2], p 256
                             Assessment factor for
12       AFetc               ecotoxicity chronic                              -                                20 [2], p 253
                             Assessmenmt factor for effect
                             on aerobic heterothrophic
13       AFaerob bact        bacteria                                         -                                 0 [2], p 264

14       Kd                  Coefficient of adsorption in soil                -                 2.00E-02            [2], p 374
                             That part of the emission
                             which contribute to toxicity via
15       fw (via air)        surface water                                    -                    0.2              [1], p 285
                             That part of the emission
                             which contribute to toxicity via
16       fs (via air)        soil                                             -                    0.8              [1], p 285
                             That part of the emission
                             which contribute to toxicity via
17       fw (via water)      surface water                                    -                        1            [1], p 286
                             That part of the emission
                             which contribute to toxicity via
18       fa (via water)      air                                              -                        0            [1], p 286
                             That part of the emission
                             which contribute to toxicity via
19       fs (via water)      soil                                             -                        0            [1], p 286
                             That part of the emission
                             which contribute to toxicity via
20       fw (via soil)       surface water                                    -                        0            [1], p 287
                             That part of the emission
                             which contribute to toxicity via
21       fa (via soil)       air                                              -                        0            [1], p 287
                             That part of the emission
                             which contribute to toxicity via
22       fs (via soil)       soil                                             -                        1            [1], p 287
                             That part of the emission
                             which contribute to acute
23       fwa (via air)       ecotoxicity in water                             -                        0            [1], p 265
                             That part of the emission
                             which contribute to chronic
24       fwc (via air)       ecotoxicity in water                             -                    0.2              [1], p 265
     A                   B                   C                        D                    E                F
2        Symbol              Parameter                         Unit                        7         Ref.
                             That part of the emission
                             which contribute to chronic
25       fsc (via air)       ecotoxicity in soil                       -                   0.8       [1], p 265
                             That part of the emission
                             which contribute to acute
26       fwa (via water)     ecotoxicity in water                      -                   1         [1], p 266
                             That part of the emission
                             which contribute to chronic
27       fwc (via water)     ecotoxicity in water                      -                   1         [1], p 266
                             That part of the emission
                             which contribute to chronic
28       fsc (via water)     ecotoxicity in soil                       -                   0         [1], p 266
                             That part of the emission
                             which contribute to acute
29       fwa (via soil)      ecotoxicity in water                      -                   0         [1], p 267
                             That part of the emission
                             which contribute to chronic
30       fwc (via soil)      ecotoxicity in water                      -                   0         [1], p 267
                             That part of the emission
                             which contribute to chronic
31       fsc (via soil)      ecotoxicity in soil                       -                   1         [1], p 267
                             Biotransfer factor from soil
32       Bb                  and food to meat in cattle                                1.69824E-08   [2], p 381
                             Biotransfer factor from soil
33       Bm                  and food to milk in cattle                                5.37032E-09   [2], p 383
                             Transfer factor from soil,
34       Ts,p                plants                                    -                4.54E-01     [2], p 367

35       Ts,b                Transfer factor from soil, beef                            1.37E-07     [2], p 381

36       Ts,m                Transfer factor from soil, milk                            4.34E-08     [2], p 383
37       Is*Ts               Total from soil                                            4.22E-03            -
38       SCF                 Stem Concentration Factor                 -                1.30E-01     [2], p 374
                             Transfer factor from water (=
39       Tw                  BCF)                                      -               0.067608298   [1], p289
40       HRD                 Human Reference Dose          mg / kg body weight / day    3.06E-01     [1], p 295
                             Human Reference
                             Concentration (HRC kan
                             beregnes fra HRD se side 390
41       HRC                 i Sci Back..)                         mg/m3 air            1.00E-01     [1], p 294
                             The highest concentration
                             assessed not produce acute
                             ecotoxic effects in the water
42       PNECwa              compartment                         g / m3 water           5.00E+00     [1], p 271
                             The highest concentration
                             assessed not produce chronic
                             ecotoxic effects in the water
43       PNECwc              compartment                         g / m3 water           5.00E-01     [1], p 269
                             The highest concentration
                             assessed not produce chronic
                             ecotoxic effects in the soil
44       PNECsc              compartment                         g / m3 water           2.18E-01     [1], p 272
                             Human Toxicity Factor for
45       HTFa                exposure via air                       m3 air/g            1.00E+04     [1], p 294
                             Human Toxicity Factor for
46       HTFw                exposure via surface water      kg body weight / mg        3.27E+00     [1], p 294
     A            B                         C                                 D         E                      F
2        Symbol             Parameter                        Unit                       7               Ref.
                            Human Toxicity Factor for
47       HTFs               exposure via soil                  kg body weight / mg   3.27E+00           [1], p 294
                            Ecotoxicity Factor for acute
                                                                      3
48       ETFwa              effects in water                        m water/g        2.00E-01           [1], p 268
                            Ecotoxicity Factor for chronic
49       ETFwc              effects in water                        m3 water/g       2.00E+00           [1], p 268
                            Ecotoxicity Factor for chronic
                                                                          3
50       ETFsc              effects in soil                          m soil/g        4.60E+00           [1], p 268
51
52 Human Toxicity
    EF(hta) by emission
53  to air                                                           m3 air/g        1.00E+04           [1], p 296
    EF(htw) by emission
                                                                      3
54  to air                                                          m water/g        3.28E-06           [1], p 296
    EF(hts) by emission
                                                                          3
55  to air                                                           m soil/g        1.47E-03           [1], p 296
56
    EF(hta) by emission
57  to water                                                         m3 air/g        0.00E+00           [1], p 296
    EF(htw) by emission
                                                                      3
58  to water                                                        m water/g        1.64E-05           [1], p 296
    EF(hts) by emission
                                                                          3
59  to water                                                         m soil/g        0.00E+00           [1], p 296
60
    EF(hta) by emission
61  to soil                                                          m3 air/g        0.00E+00           [1], p 296
    EF(htw) by emission
                                                                      3
62  to soil                                                         m water/g        0.00E+00           [1], p 296
    EF(hts) by emission
                                                                          3
63  to soil                                                          m soil/g        1.84E-03           [1], p 296
64 Ecotoxicity
    EF(etwc) by emission
65  to air                                                          m3 water/g       8.00E-02           [1], p 275
    EF(etsc) by emission
                                                                          3
66  to air                                                           m soil/g        7.36E-01           [1], p 275
67
    EF(etwc) by emission
68  to water                                                        m3 water/g       4.00E-01           [1], p 275
    EF(etwa) by
69  emission to water                                               m3 water/g       2.00E-01           [1], p 275
    EF(etsc) by emission
70  to water                                                         m3 soil/g       0.00E+00           [1], p 275
71
    EF(etwc) by emission
72  to soil                                                         m3 water/g       0.00E+00           [1], p 275
    EF(etsc) by emission
73  to soil                                                          m3 soil/g       9.20E-01           [1], p 275
74
75
76
77  AHL                  Atmospheric half life                         days                     17.2
78  H                    Henry's Law Constant                       atm*m3/mol              2.90E-07
                         Kow is the octanol water
                         partitioning coefficient (KOW =
79  Log Kow              POW)                                                 -                 -0.17
80       BIO not relevant BIO degradeability                                                       0
81       BIO              BIO degradeability factor                           -                  0.2
     A            B                 C                            D            E                    F
2        Symbol       Parameter                       Unit                    7             Ref.

                      Coefficient of adsorption for
                      substances in soil expressed
82       Koc          for organic fraction of soil                                     1

                      Bio Concentration Factor (Kan
                      beregnes udfra Log Kow Se
83       BCF          side 369 Sci Back..)               kg water / kg fish   0.067608298
84       pKa          Acid constant
            A                                       B                                                   C                       D          E
1 Constants applied in the calculations
2 Symbol            Parameter                                                          Unit                                 Value     Ref
3           a       Ratio of distribution between water and soil                                         -                     0.2    [1], p 284
4      fa (via air) That part of the emission which contribute to toxicity via air                       -                      1     [1], p 285
                    That part of the emission which contribute to acute ecotoxicity in
5 fwa (via soil)    water                                                                                -                      0     [1], p 267
                    That part of the emission which contribute to acute ecotoxicity in
6 fwa (via air)     water                                                                                -                      0     [1], p 265
7            Ia      Intake factor for air                                                               -                      1     [2], p 367
8           Ta       Transfer factor from air                                                            -                      1     [2], p 367
9          Ts,d      Transfer factor from soil, direct                                                   -                      1     [2], p 367
10          Iw       Intake factor for water                                              kg fish / kg body weight / day     3.71E-04 [2], p 367

11          Is,p     Intake factor for soil via plants                                    kg plant / kg body weight / day    9.30E-03 [2], p 367

12          Is,d     Intake factor for soil, direct                                       kg soil / kg body weight / day     2.86E-06 [2], p 367

13          Is,b     Intake factor for soil, via beef                                     kg beef / kg body weight / day     1.53E-03 [2], p 367

14         Is,m      Intake factor for soil, via milk                                     kg milk / kg body weight / day     1.32E-02 [2], p 367

15          foc      Relative content of organic carbon (g/g)                                         kg/kg                   0.02    [2], p 374
              *
16          d        Density of soil                                                                   kg/l                    1.5    [2], p 373
17          fw*      Water content of soil                                                              l/l                    0.4    [2], p 373
18          CF       Factor to convert from g to mg (or m3 to liter)                                  mg/g                    1000    -
19          Wh       Bodyweight of an average person                                                   kg                      70     [2], p 391
20          Vh       Volume inhaled daily                                                               m3                     20     [2], p 391
                     That part of the emission which contribute to acute ecotoxicity in
21 fwa (via water)   water                                                                               -                      1     [1], p 267
22         AFp       Default assessment factor for calculating ETFp                                      -                      5

23          BIs      Daily ingestion of soil for cattle                                                 kg                    0.41    [2], p 381
     A                                        B   C     D         E
24   BIp   Daily ingestion of plants for cattle   kg   16.9   [2], p 381

						
Related docs
Other docs by club56