Loading documents preview...
379464.xls
LETHALITY RATE "3D GRAPHIC TREND"
For LR trend calculation purposes you can insert the values o Reference Temperature for LR calculation ( R ) : °C Temperature ( T ) range of LR calculation : °C Low limit (the scale fraction of the 3D trend is = Range / 30) High limit Temperature Coefficient ( z ) range of LR calculation Low limit (the scale fraction of the 3D trend is = Range / 21) High limit "LETHALITY RATES" CALCULATION: LR = 10^(( T - R ) / z ) T ( °C ) 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
LETHALITY RATES (LR) with z = 1 2 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.01 0 0 0.02 0 0.01 0.04 0 0.03 0.09 0.01 0.09 0.2 0.08 0.28 0.43 0.78 0.88 0.92 7.76 2.79 1.98 77.62 8.81 4.27 776.25 27.86 9.19 7762.47 88.1 19.8 77624.71 278.61 42.66 776247.12 881.05 91.9 Pagina 1
4 0 0 0 0 0 0 0 0.01 0.01 0.02 0.03 0.05 0.09 0.17 0.3 0.53 0.94 1.67 2.97 5.28 9.39 16.69 29.68
128 129 130 131 132 133 134 135
379464.xls 7762471.17 2786.12 ### 8810.49 ### 27861.21 ### 88104.89 ### 278612.12 ### 881048.87 ### 2786121.17 ### 8810488.73
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
198 426.58 919.04 1980.01 4265.8 9190.38 19800.07 42657.95
52.78 93.86 166.92 296.82 527.84 938.64 1669.17 2968.25
You can edit this 3D Graphic (double click) :
Trend of LR value related to "z" a
10 9
8 7
LETHALITY RATE
6 5 4 3 2 1 0 105 107 109 111 113 115 117 119 121
Pagina 2
123
125
127
TEMPERATURE
129
115 117 119 121
123
125
127
129
379464.xls TEMPERATURE
You cannot edit this 3D Graphic:
Trend of LR value related to "z" an
10 9
8 7
LETHALITY RATE
6 5 4 3 2 1 0 105 107 109 111 113 115 117 119 121
123
125
127
TEMPERATURE
Pagina 3
129
379464.xls
Written by: M. Ruggeri Issued by: RES Issue date: February 26th,199 INTRODUCTION: This file is a support in analyzing and calculating the "LR" (Lethality rate) trend for different tempe can be calculated in relation to different "R" values (calculation reference temperature) and simult "z" values (temperature coefficient). Furthermore you can show and modifiy one of the two 3D Tre sentations of the "LR") using EXCEL's options (e.g. you can rotate the 3D view). Note: You can modify only the shaded cells or fields
the values of:
ð ð ð ð ð
121.11 105 135 0 21
5 0 0 0 0 0 0.01 0.01 0.02 0.02 0.04 0.06 0.1 0.15 0.24 0.38 0.6 0.95 1.51 2.39 3.78 6 9.51 15.07
6 0 0 0 0.01 0.01 0.01 0.02 0.03 0.04 0.07 0.1 0.14 0.21 0.3 0.44 0.65 0.96 1.41 2.07 3.03 4.45 6.53 9.59
Symbol: T = R = z = LR =
7 0 0.01 0.01 0.01 0.02 0.03 0.04 0.05 0.07 0.1 0.13 0.19 0.26 0.36 0.5 0.69 0.96 1.34 1.86 2.59 3.6 5 6.94
8 0.01 0.01 0.02 0.02 0.03 0.04 0.05 0.07 0.1 0.13 0.17 0.23 0.31 0.41 0.54 0.73 0.97 1.29 1.72 2.3 3.06 4.09 5.45 Pagina 4
List of the used symbols: Description: Temperature value Reference Temperature for LR calculation Temperature Coefficient of Decimal Decay Letality Rate (Lethality Factor)
9 0.02 0.02 0.03 0.03 0.05 0.06 0.08 0.1 0.13 0.16 0.21 0.27 0.35 0.45 0.58 0.75 0.97 1.26 1.62 2.09 2.71 3.49 4.51
10 0.02 0.03 0.04 0.05 0.06 0.08 0.1 0.12 0.15 0.19 0.24 0.31 0.39 0.49 0.62 0.77 0.97 1.23 1.55 1.95 2.45 3.08 3.88
11 0.03 0.04 0.05 0.06 0.08 0.1 0.12 0.15 0.18 0.23 0.28 0.34 0.42 0.52 0.64 0.79 0.98 1.2 1.49 1.83 2.26 2.78 3.43
23.88 37.84 59.98 95.06 150.66 238.78 378.44 599.79
14.07 20.65 30.32 44.5 65.31 95.87 140.71 206.54
379464.xls 7.27 9.69 12.92 17.23 22.97 30.64 40.86 54.48
9.64 13.4 18.62 25.87 35.95 49.95 69.41 96.45
ed to "z" and "T" values
20
125
127
RATURE
129
131
133
135
0
2
4
6
8
10
13
16
z VALUE
Pagina 5
5.83 7.53 9.72 12.56 16.22 20.95 27.05 34.94
4.89 6.15 7.74 9.75 12.27 15.45 19.45 24.49
4.23 5.22 6.43 7.93 9.77 12.05 14.85 18.31
125
127
129
131
133
135
0
2
4
6
8
379464.xls z VALUE
RATURE
ed to "z" and "T" values
125
20
127
RATURE
129
131
133
135
0
2
4
6
8
10
13
16
z VALUE
Pagina 6
379464.xls
ruary 26th,1996
F.R.UT.00001.A.1.E.02.96
fferent temperature values. The latter e) and simultaneously for diferent he two 3D Trends (graphic rappre_
:
calculation mal Decay
12 0.05 0.06 0.07 0.08 0.1 0.12 0.14 0.17 0.21 0.26 0.31 0.38 0.45 0.55 0.67 0.81 0.98 1.19 1.44 1.74 2.11 2.56 3.1
13 0.06 0.07 0.08 0.1 0.12 0.14 0.17 0.2 0.24 0.28 0.34 0.4 0.48 0.58 0.69 0.82 0.98 1.17 1.4 1.67 1.99 2.38 2.84
14 0.07 0.08 0.1 0.12 0.14 0.16 0.19 0.22 0.26 0.31 0.37 0.43 0.51 0.6 0.71 0.83 0.98 1.16 1.36 1.61 1.9 2.24 2.63
15 0.08 0.1 0.11 0.13 0.16 0.18 0.21 0.25 0.29 0.34 0.39 0.46 0.53 0.62 0.72 0.84 0.98 1.15 1.34 1.56 1.82 2.12 2.47 Pagina 7
16 0.1 0.11 0.13 0.15 0.18 0.2 0.23 0.27 0.31 0.36 0.42 0.48 0.55 0.64 0.74 0.85 0.98 1.14 1.31 1.52 1.75 2.02 2.33
17 0.11 0.13 0.15 0.17 0.19 0.22 0.25 0.29 0.33 0.38 0.44 0.5 0.57 0.66 0.75 0.86 0.99 1.13 1.29 1.48 1.69 1.94 2.22
18 0.13 0.14 0.16 0.19 0.21 0.24 0.27 0.31 0.35 0.4 0.46 0.52 0.59 0.67 0.76 0.87 0.99 1.12 1.27 1.45 1.64 1.87 2.12
3.75 4.54 5.51 6.67 8.08 9.79 11.86 14.37
3.39 4.05 4.83 5.76 6.88 8.22 9.81 11.71
3.11 3.66 4.32 5.09 6 7.07 8.33 9.82
379464.xls 2.88 3.36 3.91 4.56 5.32 6.2 7.23 8.43
Pagina 8
2.7 3.11 3.59 4.15 4.79 5.54 6.39 7.38
2.54 2.91 3.33 3.82 4.37 5.01 5.73 6.56
2.41 2.74 3.12 3.54 4.03 4.58 5.2 5.91
379464.xls
Pagina 9
379464.xls
19 0.14 0.16 0.18 0.2 0.23 0.26 0.29 0.33 0.37 0.42 0.48 0.54 0.61 0.69 0.77 0.87 0.99 1.11 1.26 1.42 1.6 1.81 2.04
20 0.16 0.18 0.2 0.22 0.25 0.28 0.31 0.35 0.39 0.44 0.49 0.56 0.62 0.7 0.78 0.88 0.99 1.11 1.24 1.39 1.56 1.76 1.97
Pagina 10
379464.xls 2.3 2.21 2.6 2.48 2.94 2.78 3.32 3.12 3.74 3.5 4.22 3.93 4.77 4.41 5.38 4.95
Pagina 11
379464.xls
Pagina 12