2023.01.22 dewpointgh |
|
天気の変化 |
|
年 組 番氏名(省略可) |
人工知能(AI)に残す言葉 |
|
学習 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
乾湿計の利用、乾球の温度、湿球の温度を入力すると湿度表から湿度が求められる。 |
|
|
切り取り |
|
|
|
|
|
乾湿計で求めた湿度から、露点を求める。(表計算ソフトの利用) |
|
|
|
|
|
|
|
|
|
|
|
|
人工知能(AI)に残す言葉(控) |
|
湿度は、その温度での飽和水蒸気量に対する含まれている水蒸気量を百分率で表わす。 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
湿度 |
|
|
|
|
|
|
湿度 |
|
|
露点の測定から湿度を求め、乾湿計のデータをつくる。 |
|
|
|
乾湿計 |
|
|
|
|
乾湿計で読みとった湿度のデータから気温、露点を求める。 |
|
|
|
乾湿計用湿度表と関数 VLOOKUP の使用で、乾球、湿球の温度を入力すると湿度を表示する |
|
|
乾湿計 |
|
露点の測定 |
|
|
|
=VLOOKUP(AV12,Y16:AU56,AV11) |
|
表から湿度を読み取る |
|
|
|
|
|
金属製のコップにくみ置きの水を入れ、氷で水を |
|
|
|
乾球の温度(℃) |
21 |
℃ |
|
湿度 |
|
73 |
% |
|
工夫した式、下記2つ |
|
|
|
|
冷やし、くもり始める温度(露点)を測定する |
|
|
|
=D24 |
|
乾球と湿球の目盛りの読みの差 |
3 |
℃ |
|
温度差 |
3 |
℃ |
|
9 |
|
(式 |
AL11*2+3) |
読みの差の間隔が0.5度のための補正 |
|
|
|
|
|
|
|
湿球の温度(℃) |
18 |
℃ |
|
=AB10-AB12 |
|
乾球 |
|
21 |
℃ |
|
15 |
|
(式 |
36-AR12) |
|
乾球の読みが下にいくほど小さくなるための補正) |
|
|
|
|
|
表 |
乾湿計用湿度表 |
=D26 |
|
|
|
|
|
|
|
|
番号と乾球
の温度℃ |
|
|
|
|
乾球と湿球の目盛りの読みの差(℃) |
|
|
|
|
|
|
|
|
|
|
|
|
=AL11*2+3 |
|
|
|
|
|
|
0 |
0.5 |
1 |
1.5 |
2 |
2.5 |
3 |
3.5 |
4 |
4.5 |
5 |
5.5 |
6 |
6.5 |
7 |
7.5 |
8 |
8.5 |
9 |
9.5 |
10 |
|
=36-AR12 |
|
|
|
|
|
|
1 |
35 |
100 |
97 |
93 |
90 |
87 |
83 |
80 |
77 |
74 |
71 |
68 |
65 |
63 |
60 |
57 |
54 |
52 |
49 |
47 |
44 |
42 |
|
|
|
|
|
|
2 |
34 |
100 |
96 |
93 |
90 |
86 |
83 |
80 |
77 |
74 |
71 |
68 |
65 |
62 |
59 |
56 |
54 |
51 |
48 |
46 |
43 |
41 |
|
|
|
|
|
3 |
33 |
100 |
96 |
93 |
89 |
86 |
83 |
80 |
76 |
73 |
70 |
67 |
64 |
61 |
58 |
56 |
53 |
50 |
47 |
45 |
42 |
40 |
|
|
図 教科書 大日本図書から |
|
|
|
4 |
32 |
100 |
96 |
93 |
89 |
86 |
82 |
79 |
76 |
73 |
70 |
66 |
63 |
61 |
58 |
55 |
52 |
49 |
46 |
44 |
41 |
39 |
|
|
|
|
5 |
31 |
100 |
96 |
93 |
89 |
86 |
82 |
79 |
75 |
72 |
69 |
66 |
63 |
60 |
57 |
54 |
51 |
48 |
45 |
43 |
40 |
37 |
|
乾湿計 |
|
露点(乾湿計のデータから) |
|
|
|
=R38 |
|
|
|
6 |
30 |
100 |
96 |
92 |
89 |
85 |
82 |
78 |
75 |
72 |
68 |
65 |
62 |
59 |
56 |
53 |
50 |
47 |
44 |
41 |
39 |
36 |
|
|
測定と結果 |
|
|
|
|
|
|
|
7 |
29 |
100 |
96 |
92 |
89 |
85 |
81 |
78 |
74 |
71 |
68 |
64 |
61 |
58 |
55 |
52 |
49 |
46 |
43 |
40 |
37 |
35 |
|
|
乾球の温度(読み) |
|
|
乾球の温度 |
=D24 |
乾球の温度の飽和水蒸気量 |
|
|
|
8 |
28 |
100 |
96 |
92 |
88 |
85 |
81 |
77 |
74 |
70 |
67 |
64 |
60 |
57 |
54 |
51 |
48 |
45 |
42 |
39 |
36 |
33 |
|
|
21 |
℃ |
|
|
|
21 |
℃ |
|
18.3 |
g |
※ 右下データ |
|
|
9 |
27 |
100 |
96 |
92 |
88 |
84 |
81 |
77 |
73 |
70 |
66 |
63 |
59 |
56 |
53 |
50 |
47 |
43 |
40 |
37 |
34 |
32 |
|
|
湿球の温度(読み) |
|
|
湿度 |
|
=D28 |
空気に含まれる水蒸気量 |
|
|
|
10 |
26 |
100 |
96 |
92 |
88 |
84 |
80 |
76 |
73 |
69 |
65 |
62 |
58 |
55 |
52 |
48 |
45 |
42 |
39 |
36 |
33 |
30 |
|
|
18 |
℃ |
|
|
|
73 |
% |
|
13.359 |
g |
※ 下計算 |
|
|
|
11 |
25 |
100 |
96 |
92 |
88 |
84 |
80 |
76 |
72 |
68 |
65 |
61 |
57 |
54 |
51 |
47 |
44 |
41 |
37 |
34 |
31 |
28 |
|
|
湿度 |
|
|
|
露点 |
|
=R38 |
|
含まれる水蒸気量 |
|
|
|
12 |
24 |
100 |
96 |
91 |
87 |
83 |
79 |
75 |
71 |
68 |
64 |
60 |
56 |
53 |
49 |
46 |
43 |
39 |
36 |
33 |
29 |
26 |
|
|
73 |
% |
|
|
|
15 |
|
確認(自動計算) |
|
|
|
13 |
23 |
100 |
96 |
91 |
87 |
83 |
79 |
75 |
71 |
67 |
63 |
59 |
55 |
52 |
48 |
45 |
41 |
38 |
34 |
31 |
28 |
24 |
|
|
=AR10 |
右表から |
|
|
=Q56 |
|
湿度 |
= |
13.359 |
× |
100 |
|
|
|
14 |
22 |
100 |
95 |
91 |
87 |
82 |
78 |
74 |
70 |
66 |
62 |
58 |
54 |
50 |
47 |
43 |
39 |
36 |
32 |
29 |
26 |
22 |
|
|
測定値 右の表から |
|
18.3 |
=O26*100/O24 |
|
|
15 |
21 |
100 |
95 |
91 |
86 |
82 |
77 |
73 |
69 |
65 |
61 |
57 |
53 |
49 |
45 |
42 |
38 |
34 |
31 |
27 |
24 |
20 |
|
|
|
|
|
|
|
|
|
|
|
|
73 |
% |
|
|
|
16 |
20 |
100 |
95 |
91 |
86 |
81 |
77 |
72 |
68 |
64 |
60 |
56 |
52 |
48 |
44 |
40 |
36 |
32 |
29 |
25 |
21 |
18 |
|
|
|
|
17 |
19 |
100 |
95 |
90 |
85 |
81 |
76 |
72 |
67 |
63 |
59 |
54 |
50 |
46 |
42 |
38 |
34 |
30 |
26 |
23 |
19 |
15 |
|
|
自動計算 |
|
=D24 |
|
=O24 |
|
|
|
18 |
18 |
100 |
95 |
90 |
85 |
80 |
75 |
71 |
66 |
62 |
57 |
53 |
49 |
44 |
40 |
36 |
32 |
28 |
24 |
20 |
16 |
13 |
|
|
乾球温度 |
21 |
℃ |
飽和水蒸気量(g/m3) |
18.3 |
(g) |
|
|
|
19 |
17 |
100 |
95 |
90 |
85 |
80 |
75 |
70 |
65 |
61 |
56 |
51 |
47 |
43 |
38 |
34 |
30 |
26 |
22 |
18 |
14 |
10 |
|
|
=D28 |
|
|
|
20 |
16 |
100 |
95 |
89 |
84 |
79 |
74 |
69 |
64 |
59 |
55 |
50 |
45 |
41 |
36 |
32 |
28 |
23 |
19 |
15 |
11 |
7 |
|
|
乾湿計による湿度(%) |
73 |
% |
|
|
|
21 |
15 |
100 |
94 |
89 |
84 |
78 |
73 |
68 |
63 |
58 |
53 |
48 |
43 |
39 |
34 |
30 |
25 |
21 |
16 |
12 |
8 |
4 |
|
|
=J47 |
|
|
|
22 |
14 |
100 |
94 |
89 |
83 |
78 |
72 |
67 |
62 |
57 |
51 |
46 |
42 |
37 |
32 |
27 |
22 |
18 |
13 |
9 |
5 |
|
|
|
空気1m3中に含まれている水蒸気の量(g) |
|
13.359 |
g |
|
|
|
23 |
13 |
100 |
94 |
88 |
82 |
77 |
71 |
66 |
60 |
55 |
50 |
45 |
39 |
34 |
29 |
25 |
20 |
15 |
10 |
6 |
1 |
|
|
|
|
|
24 |
12 |
100 |
94 |
88 |
82 |
76 |
70 |
65 |
59 |
53 |
48 |
43 |
37 |
32 |
27 |
22 |
17 |
12 |
7 |
2 |
|
|
|
|
式 |
|
|
|
|
|
25 |
11 |
100 |
94 |
87 |
81 |
75 |
69 |
63 |
57 |
52 |
46 |
40 |
35 |
29 |
24 |
19 |
13 |
8 |
3 |
|
|
|
|
|
湿度 |
% |
= |
空気1m3中に含まれている水蒸気の量(g) |
|
× 100 |
|
|
|
26 |
10 |
100 |
93 |
87 |
80 |
74 |
68 |
62 |
56 |
50 |
44 |
38 |
32 |
27 |
21 |
16 |
10 |
5 |
|
|
|
|
|
|
その気温での空気1m3中の飽和水蒸気の量 |
|
|
|
27 |
9 |
100 |
93 |
86 |
80 |
73 |
67 |
60 |
54 |
48 |
42 |
36 |
30 |
24 |
18 |
12 |
6 |
1 |
|
|
|
|
|
|
|
|
28 |
8 |
100 |
93 |
86 |
79 |
72 |
66 |
58 |
52 |
46 |
39 |
33 |
27 |
20 |
14 |
8 |
2 |
|
|
|
|
|
|
空気1m3中に含まれている水蒸気の量(g) |
= |
湿度 × その気温での空気1m3中の飽和水蒸気の量 |
|
|
|
29 |
7 |
100 |
93 |
85 |
78 |
71 |
65 |
57 |
50 |
43 |
37 |
30 |
23 |
17 |
11 |
4 |
|
|
|
|
|
|
|
|
100 |
|
|
|
30 |
6 |
100 |
92 |
85 |
77 |
70 |
64 |
55 |
48 |
41 |
34 |
27 |
20 |
13 |
7 |
0 |
|
|
|
|
|
|
|
|
=N36*R34/100 |
|
|
|
31 |
5 |
100 |
92 |
84 |
76 |
68 |
62 |
53 |
46 |
38 |
31 |
24 |
16 |
9 |
2 |
|
|
|
|
|
|
|
|
|
= |
13.359 |
|
13.359 |
g |
※ 含まれる水蒸気量 |
|
|
|
32 |
4 |
100 |
92 |
83 |
75 |
67 |
61 |
51 |
43 |
35 |
28 |
20 |
12 |
5 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
33 |
3 |
100 |
91 |
82 |
74 |
65 |
59 |
49 |
40 |
32 |
24 |
16 |
8 |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
34 |
2 |
100 |
91 |
82 |
73 |
64 |
57 |
46 |
37 |
29 |
20 |
12 |
4 |
|
|
|
|
|
|
|
|
|
|
|
35 |
1 |
100 |
90 |
81 |
71 |
62 |
55 |
43 |
34 |
25 |
16 |
8 |
|
|
|
|
|
|
|
|
|
|
|
|
36 |
0 |
100 |
90 |
80 |
70 |
60 |
52 |
40 |
31 |
21 |
12 |
3 |
|
|
|
|
|
|
|
|
|
|
|
|
37 |
-1 |
99 |
89 |
79 |
69 |
59 |
49 |
40 |
30 |
21 |
12 |
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
38 |
-2 |
98 |
87 |
77 |
66 |
56 |
46 |
46 |
26 |
16 |
6 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
39 |
-3 |
97 |
86 |
75 |
64 |
53 |
42 |
32 |
21 |
11 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
水蒸気量 |
温度 |
|
|
|
|
40 |
-4 |
96 |
84 |
73 |
61 |
50 |
39 |
28 |
17 |
6 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
13.359 |
15 |
|
|
|
|
41 |
-5 |
95 |
83 |
71 |
59 |
47 |
35 |
23 |
11 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=M47 |
=VLOOKUP(O56,P61:R89,3) |
|
表 大日本図書 教科書 湿度表から |
|
|
|
|
水蒸気量と温度 |
並び変え |
水蒸気量と温度 |
|
|
|
|
|
|
|
水蒸 |
|
|
水蒸 |
|
|
|
|
|
|
気温に対する飽和水蒸気量 |
|
|
|
|
|
気量 |
温度 |
|
気量 |
|
温度 |
|
|
|
|
番号 |
|
温度℃ |
飽和水蒸気量(g/m3) |
|
気温 |
℃ |
|
|
21 |
|
10 |
|
|
|
|
|
3 |
-5 |
|
1 |
|
|
|
|
|
|
1 |
|
30 |
|
|
30.4 |
|
30 |
|
=J24 |
|
|
|
|
|
4 |
-2 |
|
2 |
|
|
|
|
|
|
2 |
|
29 |
|
28.8 |
|
29 |
|
飽和水蒸気量(g) |
18.3 |
g |
※ 乾球の飽和水蒸気量 |
|
|
|
|
|
4 |
-3 |
|
3 |
|
-5 |
|
|
|
|
3 |
|
28 |
|
27.2 |
|
27 |
|
=VLOOKUP(AR60,Y61:AE96,6,TRUE) |
|
|
|
|
|
4 |
-4 |
|
4 |
|
-4 |
|
|
|
|
4 |
|
27 |
|
25.8 |
|
25 |
|
|
|
|
|
5 |
1 |
|
5 |
|
0 |
|
|
|
|
5 |
|
26 |
|
|
24.4 |
|
24 |
|
|
|
|
|
5 |
0 |
|
6 |
|
4 |
|
|
|
|
6 |
|
25 |
|
23.1 |
|
23 |
|
|
|
|
|
5 |
-1 |
|
7 |
|
6 |
|
|
|
|
7 |
|
24 |
|
21.8 |
|
22 |
|
|
|
|
|
6 |
4 |
|
8 |
|
8 |
|
|
|
|
8 |
|
23 |
|
20.6 |
|
21 |
|
|
|
|
|
6 |
3 |
|
9 |
|
10 |
|
|
|
|
9 |
|
22 |
|
19.4 |
|
19 |
|
|
|
|
|
6 |
2 |
|
10 |
|
11 |
|
|
|
|
10 |
|
21 |
|
|
18.3 |
|
18 |
|
|
|
|
|
7 |
6 |
|
11 |
|
13 |
|
|
|
|
11 |
|
20 |
|
17.3 |
|
17 |
|
|
|
|
|
7 |
5 |
|
12 |
|
14 |
|
|
|
|
12 |
|
19 |
|
16.3 |
|
16 |
|
|
|
|
|
8 |
8 |
|
13 |
|
15 |
|
|
|
|
13 |
|
18 |
|
15.4 |
|
15 |
|
|
|
|
|
8 |
7 |
|
14 |
|
16 |
|
|
|
|
14 |
|
17 |
|
14.5 |
|
15 |
|
|
|
|
|
9 |
10 |
|
15 |
|
18 |
|
|
|
|
15 |
|
16 |
|
|
13.6 |
|
14 |
|
|
|
|
|
9 |
9 |
|
16 |
|
19 |
|
|
|
|
16 |
|
15 |
|
12.8 |
|
13 |
|
|
|
|
|
10 |
11 |
|
17 |
|
20 |
|
|
|
|
17 |
|
14 |
|
12.1 |
|
12 |
|
|
|
|
|
11 |
13 |
|
18 |
|
21 |
|
|
|
|
18 |
|
13 |
|
11.4 |
|
11 |
|
|
|
|
|
11 |
12 |
|
19 |
|
22 |
|
|
|
|
19 |
|
12 |
|
10.7 |
|
11 |
|
|
|
|
|
12 |
14 |
|
20 |
|
22 |
|
|
|
|
20 |
|
11 |
|
|
10 |
|
10 |
|
|
|
|
|
13 |
15 |
|
21 |
|
23 |
|
|
|
|
21 |
|
10 |
|
9.4 |
|
9 |
|
|
|
|
|
14 |
16 |
|
22 |
|
24 |
|
|
|
|
22 |
|
9 |
|
8.8 |
|
9 |
|
|
|
|
|
15 |
18 |
|
23 |
|
25 |
|
|
|
|
23 |
|
8 |
|
8.3 |
|
8 |
|
|
|
|
|
15 |
17 |
|
24 |
|
26 |
|
|
|
|
24 |
|
7 |
|
7.8 |
|
8 |
|
|
|
|
|
16 |
19 |
|
25 |
|
27 |
|
|
|
|
25 |
|
6 |
|
|
7.3 |
|
7 |
|
|
|
|
|
17 |
20 |
|
26 |
|
27 |
|
|
|
|
26 |
|
5 |
|
6.8 |
|
7 |
|
|
|
|
|
18 |
21 |
|
27 |
|
28 |
|
|
|
|
27 |
|
4 |
|
6.4 |
|
6 |
|
|
|
|
|
19 |
22 |
|
28 |
|
28 |
|
|
|
|
28 |
|
3 |
|
5.9 |
|
6 |
|
|
|
|
|
21 |
23 |
|
29 |
|
29 |
|
|
|
|
29 |
|
2 |
|
5.6 |
|
6 |
|
|
22 |
24 |
|
30 |
|
30 |
|
30 |
|
1 |
|
|
5.2 |
|
5 |
|
|
23 |
25 |
|
|
|
|
|
31 |
|
0 |
|
4.8 |
|
5 |
|
|
24 |
26 |
|
|
|
|
|
32 |
|
-1 |
|
4.5 |
|
5 |
|
|
25 |
27 |
|
|
|
|
|
33 |
|
-2 |
|
4.2 |
|
4 |
|
|
27 |
28 |
|
|
|
|
|
34 |
|
-3 |
|
3.9 |
|
4 |
|
|
29 |
29 |
|
|
|
|
|
35 |
|
-4 |
|
|
3.7 |
|
4 |
|
|
30 |
30 |
|
|
|
|
|
36 |
|
-5 |
|
|
3.4 |
|
3 |
|
|
|
|
|
|
|
AIに残す言葉 |
|
乾湿計の利用、乾球の温度、湿球の温度を入力すると湿度表から湿度が求められる。 |
|
乾湿計で求めた湿度から、露点を求める。(表計算ソフトの利用) |
|
湿度は、その温度での飽和水蒸気量に対する含まれている水蒸気量を百分率で表わす。 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|