Bai 1-do Thi Tai
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Bai 1-do Thi Tai as PDF for free.
More details
- Words: 1,719
- Pages: 11
A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
B
C
D
E
F
G
H
I
B¶ng 1-1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
40 40 45 42 60 64 66 85 88 104 105 84 88 88 90 88 89 90 102 130 125 120 71 55
2-Jan
42 41 43 45 66 65 62 77 88 100 110 76 81 85 82 81 88 80 105 125
40
3-Jan
4-Jan
46 43 45 44 62 67 65 74 84 92 98 87 82 82 82 82 85 85 120 120 120 95 74 51
50 45 42 42 62 72 64 82 82 100 110 110 78 78 78 78 86 89 90 110 118 110 70 60
Sè liÖu c¬ së: be ta
1.7
5-Jan
64 68 67 73 84 82 100 120 85 85 85 85 102 95 105 125 125 102 78 40
6-Jan
34 36 40 45 68 62 65 78 87 84 100 88 72 72 72 72 85 100 105 104 110 96 69 41
=AVERAGE(B8:H8) = STDEVP(B8:H8) =ROUND(I8+$E$35*J8/SQRT(COUNTA(B8:H8)),0) =K8^2 =AVERAGE(K8:K31) =MAX(K8:K31) =SUM(K8:K31)*1/J35 =SUM(L8:L31)*1/MAX(L8:L31) =J34/J35
7-Jan
36 36 42 41 67 67
97 91 87 76 76 76 76 95 102 103 100 110 90 62 45
P tb(KW) Dl chuan
41.33 40.17 42.83 43.17 64.14 66.43 64.83 78.17 85.50 94.14 102.00 93.14 80.29 80.86 80.71 80.29 90.00 91.57 104.29 116.29 118.00 102.17 70.67 47.43
Sè liÖu tÝnh Phô t¶i trung b×nh Phô t¶i cùc ®¹i Tmax Tg hao tæn max Kdkin
C«ng thøc ë c¸c « I8 J8 K8 L8 J34 J35 J36 J37 J38
L
S®m 180 §iÖn ¸p 35/ 0,4 KV
Ngµy mïa ®«ng 2001 1-Jan
K
Tr¹m: Anlac1 §Þa chØ Th«n An lac
Sè liÖu ®o vµ tÝnh t¶i tr¹m biÕn ¸p tiªu thô Gio
J
5.50 3.34 1.77 1.57 2.75 2.97 1.57 4.22 2.29 7.83 6.35 14.56 5.03 5.30 5.52 5.03 5.86 7.35 8.10 10.75 6.19 10.14 4.89 7.42
P tt
45 42 44 44 66 68 66 81 87 99 106 103 84 84 84 84 94 96 109 123 122 109 74 52
P tt2
2,025 1,764 1,936 1,936 4,356 4,624 4,356 6,561 7,569 9,801 11,236 10,609 7,056 7,056 7,056 7,056 8,836 9,216 11,881 15,129 14,884 11,881 5,476 2,704
82 kw 123 kw 16.0 h/ngµy 11.6 h/ngµy 0.67
Th«ng sè C«ng suÊt trung b×nh tõ ngµy 1 ®Õn 7 th¸ng giªn §é lÖch chuÈn Lµm trßn gi¸ trÞ Ptt ®Õn ®¬n vÞ 2 Ptt Phô t¶i trung b×nh trong ngµy Phô t¶i cùc ®¹i trong ngµy Thêi gian sö dông c«ng suÊt cùc ®¹i ngµy Thêi gian hao tæn c«ng suÊt cùc ®¹i ngµy HÖ sè ®iÒn kÝn cña ®å thÞ t¶i
M 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 õ ngµy 1 ®Õn 742th¸ng giªng 43 44 45 46 47 48 49 50
A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53
B
C
D
E
F
G
H
I
B¶ng 1-2
Ngµy mïa hÌ 2001
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
1-Jun
80 88 82 90 92 102 103 95 95 110 122 122 122 95 89 89 89 135 158 165 154 120 90 80
2-Jun
82 84 84 99 94 95 105 96 96 100 150 150 150 98 88 88 88 140 154 164 145 126 95 82
3-Jun
75 83 80 95 82 108 100 98
150 150 150 92 102 102 102 146 162 160 154 115 86 75
4-Jun
5-Jun
78 72 87 87 110 108 99 103 100 120 120 125 100 86 86 86 136 143 157 139 130 87 82
Sè liÖu c¬ sá beta
C«ng I8 J8 K8
L8 J34 J35 J36 J37
K
L
Tr¹m: Anlac1 §Þa chØ Th«n An lac
Sè liÖu ®o vµ tÝnh t¶i tr¹m biÕn ¸p tiªu thô Gio
J
1.7
6-Jun
85 76 87 85 87
72 77 71 92 93
98 103 103 82 130 130 130 102 102 102 102 132 150 152 145 120 94 85
97 110 110 84 140 140 140 92 112 112 112 150 157 159 143 128 99 72
7-Jun
76 85 70 87 92 90 105 98 98 97 124 124 124 97 95 95 95 134 142 163 142 110 85 76
P tb(KW)
78.33 81.57 78.00 90.71 89.57 101.00 102.29 99.86 100.83 95.50 133.71 133.71 134.43 96.57 96.29 96.29 96.29 139.00 152.29 160.00 146.00 121.29 90.86 78.86
Sè liÖu tÝnh Phô t¶i trung b×nh Phô t¶i cùc ®¹i Tmax Tg hao tæn max Kdkin
S®m §iÖn ¸p Dl chuan
4.42 4.24 6.39 4.62 4.03 7.59 3.77 4.76 5.15 9.73 11.97 11.97 11.26 3.54 8.79 8.79 8.79 6.21 7.07 4.21 5.40 6.69 4.88 4.29
180 35/ 0,4 KV P tt
81 84 82 94 92 107 105 103 104 102 141 141 142 99 102 102 102 143 157 163 149 126 94 82
P tt2
6,561 7,056 6,724 8,836 8,464 11,449 11,025 10,609 10,816 10,404 19,881 19,881 20,164 9,801 10,404 10,404 10,404 20,449 24,649 26,569 22,201 15,876 8,836 6,724
112 163 16.5 12.0 0.69
thøc ë c¸c « Gi¶i thÝch =AVERAGE(B8:H8) TÝnh c«ng suÊt trung b×nh (k× väng to¸n) = STDEVP(B8:H8) TÝnh ®é lÖch chuÈn (delta) =ROUND((I8+$E$35*J8/SQRT(COUNTA(B8:H8)),0) TÝnh Ptt = Ptt + beta*delta/n1/2 ROUND(sè cÇn lµm trßn, i): hµm sè lµm trßn, i d¬ng: sè ch÷ sè thËp ph©n, i ©m: sè ch÷ sè kh«ng, i=0: lµm trßn tíi ®¬n vÞ. VD: ROUND(15234,3) = 150 SQRT: hµm c¨n bËc hai. VD: SQRT(4)=2 COUNTA: hµm dÕm sè « cã nghÜa (n). VD: COUNTA(B8:H8) = 6 =K8^2 =AVERAGE(K8:K31) =MAX(K8:K31) =SUM(K8:K31)*1/J35 =SUM(L8:L31)*1/MAX(L8:L31)
TÝnh b×nh ph¬ng c«ng suÊt trung b×nh TÝnh c«ng suÊt trung b×nh c¸c giê trong ngµy T×m c«ng suÊt cùc ®¹i T×m thêi gian sö dông c«ng suÊt cùc ®¹i TÝnh thêi gian hao tæn c«ng suÊt cùc ®¹i
A 54 J38
B C =J34/J35
D
E
F
G
H I J TÝnh hÖ sè ®iÒn kÝn
K
L
M 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 TÝnh c«ng suÊt trung b×nh (k× väng 41 to¸n) 42 43 m trßn, i): hµm sè lµm trßn, i d¬ng: sè ch÷ sè thËp ph©n, 44 ÷ sè kh«ng, i=0: lµm trßn tíi ®¬n vÞ. VD: ROUND(15234,3) = 15000 45 46 47 48 49 TÝnh c«ng suÊt trung b×nh c¸c giê trong 50 ngµy 51 52 TÝnh thêi gian hao tæn c«ng suÊt cùc 53 ®¹i
M 54
®å thÞ t¶i ngµy mïa ®«ng 140
120
100
80 KW 60
40
20
0 0
1
2
3
4
5
6
7
8
9
10
11
12 h
13
14
15
16
17
18
19
20
21
22
23
24
®å thÞ t¶i ngµy mïa hÌ 180
160
140
120
100 KW 80
60
40
20
0 0
1
2
3
4
5
6
7
8
9
10
11
12 h
13
14
15
16
17
18
19
20
21
22
23
24
22
23
24
A 1
B
C
D
E
F
G
H
I
J
B¶ng 1-3: Sö lý sè liÖu ®Ó vÏ ®å thÞ t¶i
2 Pt¶i ngµy mïa ®«ngPt¶i ngµy mïa hÌ t Ptt t Ptt 3 4 0 45 0 81 1 45 1 81 5 1 42 1 84 6 2 42 2 84 7 2 44 2 82 8 3 44 3 82 9 3 44 3 94 10 4 44 4 94 11 4 66 4 92 12 5 66 5 92 13 5 68 5 107 14 15 6 68 6 107 6 66 6 105 16 7 66 7 105 17 7 81 7 103 18 8 81 8 103 19 8 87 8 104 20 9 87 9 104 21 9 99 9 102 22 10 99 10 102 23 10 106 10 141 24 11 106 11 141 25 26 11 103 11 141 12 103 12 141 27 12 84 12 142 28 13 84 13 142 29 13 84 13 99 30 14 84 14 99 31 14 84 14 102 32 15 84 15 102 33 15 84 15 102 34 16 84 16 102 35 16 94 16 102 36 37 17 94 17 102 17 96 17 143 38 18 96 18 143 39 40 18 109 18 157 19 109 19 157 41 19 123 19 163 42 20 123 20 163 43 20 122 20 149 44 21 122 21 149 45 21 109 21 126 46 22 109 22 126 47 48 22 74 22 94 23 74 23 94 49 23 52 23 82 50 51 24 52 24 82
C«ng thøc: « B4: =B5 « B5: =VLOOKUP(A5,TaiNgayMuaDong!$A$8:$K$31,11,FALSE) « B6: =VLOOKUP(A7,TaiNgayMuaDong!$A$8:$K$31,11,FALSE) «E4: =E5 « E5: =VLOOKUP(D5,TaiNgayMuaHe!$A$8:$K$31,11,FALSE) « E6: =VLOOKUP(D7,TaiNgayMuaHe!$A$8:$K$31,11,FALSE) Copy: + B«i dÊu hai « B5 vµ B6 + Copy + Past xuèng c¸c « tõ B7 ®Õn B51 Lµm t¬ng tù víi d·y phô t¶i mïa hÌ tõ E7 ®Õn E51
K 1
2 3 4 5 $A$8:$K$31,11,FALSE) 6 7 $A$8:$K$31,11,FALSE) 8 9 10 11 12 A$8:$K$31,11,FALSE) 13 14 A$8:$K$31,11,FALSE) 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
B
C
D
E
F
G
H
I
B¶ng 1-1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
40 40 45 42 60 64 66 85 88 104 105 84 88 88 90 88 89 90 102 130 125 120 71 55
2-Jan
42 41 43 45 66 65 62 77 88 100 110 76 81 85 82 81 88 80 105 125
40
3-Jan
4-Jan
46 43 45 44 62 67 65 74 84 92 98 87 82 82 82 82 85 85 120 120 120 95 74 51
50 45 42 42 62 72 64 82 82 100 110 110 78 78 78 78 86 89 90 110 118 110 70 60
Sè liÖu c¬ së: be ta
1.7
5-Jan
64 68 67 73 84 82 100 120 85 85 85 85 102 95 105 125 125 102 78 40
6-Jan
34 36 40 45 68 62 65 78 87 84 100 88 72 72 72 72 85 100 105 104 110 96 69 41
=AVERAGE(B8:H8) = STDEVP(B8:H8) =ROUND(I8+$E$35*J8/SQRT(COUNTA(B8:H8)),0) =K8^2 =AVERAGE(K8:K31) =MAX(K8:K31) =SUM(K8:K31)*1/J35 =SUM(L8:L31)*1/MAX(L8:L31) =J34/J35
7-Jan
36 36 42 41 67 67
97 91 87 76 76 76 76 95 102 103 100 110 90 62 45
P tb(KW) Dl chuan
41.33 40.17 42.83 43.17 64.14 66.43 64.83 78.17 85.50 94.14 102.00 93.14 80.29 80.86 80.71 80.29 90.00 91.57 104.29 116.29 118.00 102.17 70.67 47.43
Sè liÖu tÝnh Phô t¶i trung b×nh Phô t¶i cùc ®¹i Tmax Tg hao tæn max Kdkin
C«ng thøc ë c¸c « I8 J8 K8 L8 J34 J35 J36 J37 J38
L
S®m 180 §iÖn ¸p 35/ 0,4 KV
Ngµy mïa ®«ng 2001 1-Jan
K
Tr¹m: Anlac1 §Þa chØ Th«n An lac
Sè liÖu ®o vµ tÝnh t¶i tr¹m biÕn ¸p tiªu thô Gio
J
5.50 3.34 1.77 1.57 2.75 2.97 1.57 4.22 2.29 7.83 6.35 14.56 5.03 5.30 5.52 5.03 5.86 7.35 8.10 10.75 6.19 10.14 4.89 7.42
P tt
45 42 44 44 66 68 66 81 87 99 106 103 84 84 84 84 94 96 109 123 122 109 74 52
P tt2
2,025 1,764 1,936 1,936 4,356 4,624 4,356 6,561 7,569 9,801 11,236 10,609 7,056 7,056 7,056 7,056 8,836 9,216 11,881 15,129 14,884 11,881 5,476 2,704
82 kw 123 kw 16.0 h/ngµy 11.6 h/ngµy 0.67
Th«ng sè C«ng suÊt trung b×nh tõ ngµy 1 ®Õn 7 th¸ng giªn §é lÖch chuÈn Lµm trßn gi¸ trÞ Ptt ®Õn ®¬n vÞ 2 Ptt Phô t¶i trung b×nh trong ngµy Phô t¶i cùc ®¹i trong ngµy Thêi gian sö dông c«ng suÊt cùc ®¹i ngµy Thêi gian hao tæn c«ng suÊt cùc ®¹i ngµy HÖ sè ®iÒn kÝn cña ®å thÞ t¶i
M 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 õ ngµy 1 ®Õn 742th¸ng giªng 43 44 45 46 47 48 49 50
A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53
B
C
D
E
F
G
H
I
B¶ng 1-2
Ngµy mïa hÌ 2001
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
1-Jun
80 88 82 90 92 102 103 95 95 110 122 122 122 95 89 89 89 135 158 165 154 120 90 80
2-Jun
82 84 84 99 94 95 105 96 96 100 150 150 150 98 88 88 88 140 154 164 145 126 95 82
3-Jun
75 83 80 95 82 108 100 98
150 150 150 92 102 102 102 146 162 160 154 115 86 75
4-Jun
5-Jun
78 72 87 87 110 108 99 103 100 120 120 125 100 86 86 86 136 143 157 139 130 87 82
Sè liÖu c¬ sá beta
C«ng I8 J8 K8
L8 J34 J35 J36 J37
K
L
Tr¹m: Anlac1 §Þa chØ Th«n An lac
Sè liÖu ®o vµ tÝnh t¶i tr¹m biÕn ¸p tiªu thô Gio
J
1.7
6-Jun
85 76 87 85 87
72 77 71 92 93
98 103 103 82 130 130 130 102 102 102 102 132 150 152 145 120 94 85
97 110 110 84 140 140 140 92 112 112 112 150 157 159 143 128 99 72
7-Jun
76 85 70 87 92 90 105 98 98 97 124 124 124 97 95 95 95 134 142 163 142 110 85 76
P tb(KW)
78.33 81.57 78.00 90.71 89.57 101.00 102.29 99.86 100.83 95.50 133.71 133.71 134.43 96.57 96.29 96.29 96.29 139.00 152.29 160.00 146.00 121.29 90.86 78.86
Sè liÖu tÝnh Phô t¶i trung b×nh Phô t¶i cùc ®¹i Tmax Tg hao tæn max Kdkin
S®m §iÖn ¸p Dl chuan
4.42 4.24 6.39 4.62 4.03 7.59 3.77 4.76 5.15 9.73 11.97 11.97 11.26 3.54 8.79 8.79 8.79 6.21 7.07 4.21 5.40 6.69 4.88 4.29
180 35/ 0,4 KV P tt
81 84 82 94 92 107 105 103 104 102 141 141 142 99 102 102 102 143 157 163 149 126 94 82
P tt2
6,561 7,056 6,724 8,836 8,464 11,449 11,025 10,609 10,816 10,404 19,881 19,881 20,164 9,801 10,404 10,404 10,404 20,449 24,649 26,569 22,201 15,876 8,836 6,724
112 163 16.5 12.0 0.69
thøc ë c¸c « Gi¶i thÝch =AVERAGE(B8:H8) TÝnh c«ng suÊt trung b×nh (k× väng to¸n) = STDEVP(B8:H8) TÝnh ®é lÖch chuÈn (delta) =ROUND((I8+$E$35*J8/SQRT(COUNTA(B8:H8)),0) TÝnh Ptt = Ptt + beta*delta/n1/2 ROUND(sè cÇn lµm trßn, i): hµm sè lµm trßn, i d¬ng: sè ch÷ sè thËp ph©n, i ©m: sè ch÷ sè kh«ng, i=0: lµm trßn tíi ®¬n vÞ. VD: ROUND(15234,3) = 150 SQRT: hµm c¨n bËc hai. VD: SQRT(4)=2 COUNTA: hµm dÕm sè « cã nghÜa (n). VD: COUNTA(B8:H8) = 6 =K8^2 =AVERAGE(K8:K31) =MAX(K8:K31) =SUM(K8:K31)*1/J35 =SUM(L8:L31)*1/MAX(L8:L31)
TÝnh b×nh ph¬ng c«ng suÊt trung b×nh TÝnh c«ng suÊt trung b×nh c¸c giê trong ngµy T×m c«ng suÊt cùc ®¹i T×m thêi gian sö dông c«ng suÊt cùc ®¹i TÝnh thêi gian hao tæn c«ng suÊt cùc ®¹i
A 54 J38
B C =J34/J35
D
E
F
G
H I J TÝnh hÖ sè ®iÒn kÝn
K
L
M 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 TÝnh c«ng suÊt trung b×nh (k× väng 41 to¸n) 42 43 m trßn, i): hµm sè lµm trßn, i d¬ng: sè ch÷ sè thËp ph©n, 44 ÷ sè kh«ng, i=0: lµm trßn tíi ®¬n vÞ. VD: ROUND(15234,3) = 15000 45 46 47 48 49 TÝnh c«ng suÊt trung b×nh c¸c giê trong 50 ngµy 51 52 TÝnh thêi gian hao tæn c«ng suÊt cùc 53 ®¹i
M 54
®å thÞ t¶i ngµy mïa ®«ng 140
120
100
80 KW 60
40
20
0 0
1
2
3
4
5
6
7
8
9
10
11
12 h
13
14
15
16
17
18
19
20
21
22
23
24
®å thÞ t¶i ngµy mïa hÌ 180
160
140
120
100 KW 80
60
40
20
0 0
1
2
3
4
5
6
7
8
9
10
11
12 h
13
14
15
16
17
18
19
20
21
22
23
24
22
23
24
A 1
B
C
D
E
F
G
H
I
J
B¶ng 1-3: Sö lý sè liÖu ®Ó vÏ ®å thÞ t¶i
2 Pt¶i ngµy mïa ®«ngPt¶i ngµy mïa hÌ t Ptt t Ptt 3 4 0 45 0 81 1 45 1 81 5 1 42 1 84 6 2 42 2 84 7 2 44 2 82 8 3 44 3 82 9 3 44 3 94 10 4 44 4 94 11 4 66 4 92 12 5 66 5 92 13 5 68 5 107 14 15 6 68 6 107 6 66 6 105 16 7 66 7 105 17 7 81 7 103 18 8 81 8 103 19 8 87 8 104 20 9 87 9 104 21 9 99 9 102 22 10 99 10 102 23 10 106 10 141 24 11 106 11 141 25 26 11 103 11 141 12 103 12 141 27 12 84 12 142 28 13 84 13 142 29 13 84 13 99 30 14 84 14 99 31 14 84 14 102 32 15 84 15 102 33 15 84 15 102 34 16 84 16 102 35 16 94 16 102 36 37 17 94 17 102 17 96 17 143 38 18 96 18 143 39 40 18 109 18 157 19 109 19 157 41 19 123 19 163 42 20 123 20 163 43 20 122 20 149 44 21 122 21 149 45 21 109 21 126 46 22 109 22 126 47 48 22 74 22 94 23 74 23 94 49 23 52 23 82 50 51 24 52 24 82
C«ng thøc: « B4: =B5 « B5: =VLOOKUP(A5,TaiNgayMuaDong!$A$8:$K$31,11,FALSE) « B6: =VLOOKUP(A7,TaiNgayMuaDong!$A$8:$K$31,11,FALSE) «E4: =E5 « E5: =VLOOKUP(D5,TaiNgayMuaHe!$A$8:$K$31,11,FALSE) « E6: =VLOOKUP(D7,TaiNgayMuaHe!$A$8:$K$31,11,FALSE) Copy: + B«i dÊu hai « B5 vµ B6 + Copy + Past xuèng c¸c « tõ B7 ®Õn B51 Lµm t¬ng tù víi d·y phô t¶i mïa hÌ tõ E7 ®Õn E51
K 1
2 3 4 5 $A$8:$K$31,11,FALSE) 6 7 $A$8:$K$31,11,FALSE) 8 9 10 11 12 A$8:$K$31,11,FALSE) 13 14 A$8:$K$31,11,FALSE) 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
Related Documents
Bai 1-do Thi Tai
June 2020 9
Bai Tap Tai Chinh
November 2019 15
Bai Thi Tin Hoc
April 2020 16
Da Tai Nguyen Thi Tham
May 2020 8
Alg 1do Medio
December 2019 4