ABCDEABACADAEAFAGAHAIAJAKALAMANAOBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJ
1
2
3
4
UNITMONITORING PENGGANTIAN METER TUA 2023 - PERIODE : OKTOBER 2023SALDO KWH METER
5
PASCA TH TERA > 25 THNLPB TH TERA > 10 THNTARGET
OKT		REALISASI OKTPERSEN
%		Prabayar
1P		Paskabayar
1P
6
Saldo
01 OKT '23		Target
OKT '23		TANGGALREALISASIPERSENSALDO
AKHIR		Saldo
01 OKT '23		Target
OKT '23		TANGGALREALISASIPERSENSALDO
AKHIR
7
232425262728293031232425262728293031
8
21100PONTIANAK KOTA 5,009 2,505 6 1 - 7 4 - 15 10 71 581 23.20% 4,428 8,322 2,774 - 2 2 3 1 - - - 1 50 1.80% 8,272 5,279 631 11.95% - - 2060
9
21101SIANTAN 9,791 4,896 2 1 - - - 6 1 2 9 284 5.80% 9,507 4,581 1,527 7 4 3 1 1 1 - 4 - 124 8.12% 4,457 6,423 408 13.92% - - 2100
10
21102SEI JAWI 1,298 649 8 6 5 - - - - 2 3 168 25.89% 1,130 1,143 381 2 2 - - - - - - - 11 2.89% 1,132 1,030 179 28.77% - - 2110
11
21110MEMPAWAH 9,894 4,947 29 135 14 198 111 68 63 122 130 1,315 26.58% 8,579 5,144 1,715 4 - 1 - - - - 6 - 37 2.16% 5,107 6,662 1,352 28.74% - - 2070
12
21120RASAU 3,534 1,767 30 65 130 43 33 - - 81 183 1,091 61.74% 2,443 1,636 545 2 - - - - - - - - 17 3.12% 1,619 2,312 1,108 64.86% - - 2090
13
21121KAKAP 1,226 613 - - - - - - - - 1 57 9.30% 1,169 320 107 - - - - - - - 2 1 3 2.81% 317 720 60 12.11% - - 2120
14
21140NGABANG 1,743 872 - 20 - 10 15 - - - 6 307 35.23% 1,436 700 233 - - - - - - - - 4 7 3.00% 693 1,105 314 38.23% - - 2080
15
UP3 PONTIANAK 32,495 16,248 75 228 149 258 163 74 79 217 403 3,803 23.41% 28,692 21,846 7,282 15 8 6 4 2 1 - 12 6 249 3.42% 21,597 23,530 4,052 26.83% - - 2010
16
21200
SINGKAWANG KOTA
 2,647 1,324 - 19 20 1 1 - - 1 2 391 29.54% 2,256 603 201 2 - - 3 2 - - - - 16 7.96% 587 1,525 407 37.50% - - 2130
17
21210PEMANGKAT 4,045 2,023 - 63 45 9 38 4 4 31 5 689 34.07% 3,356 1,297 432 - - - - 2 - - 1 - 19 4.39% 1,278 2,455 708 38.46% - - 2150
18
21220SAMBAS 2,115 1,058 36 7 2 1 7 - - 11 1 413 39.05% 1,702 1,220 407 1 - - 2 - - - 2 - 148 36.39% 1,072 1,464 561 75.45% - - 2160
19
21230BENGKAYANG 1,814 907 8 10 13 4 43 43 32 69 91 584 64.39% 1,230 1,010 337 1 1 1 - - 2 - - 1 14 4.16% 996 1,244 598 68.55% - - 2140
20
21240SEKURA 591 296 23 11 21 16 7 - - 50 - 280 94.75% 311 78 39 - - - - - - - - - 1 2.56% 77 335 281 97.32% - - 2180
21
21250SEI DURI 282 141 8 - - - - - - 1 - 12 8.51% 270 53 27 - 4 5 - 3 - - - - 13 49.06% 40 168 25 57.57% - - 2170
22
UP3 SINGKAWANG 11,494 5,747 75 110 101 31 96 47 36 163 99 2,369 41.22% 9,125 4,261 1,442 4 5 6 5 7 2 - 3 1 211 14.63% 4,050 7,189 2,580 55.85% - - 2000
23
21300SANGGAU KOTA 712 356 10 16 - 6 - - 18 9 - 83 23.31% 629 2,941 980 - - 2 4 3 1 2 1 1 143 14.59% 2,798 1,336 226 37.90% - - 2190
24
21310SINTANG 1,285 643 3 24 23 - - - - 29 34 191 29.73% 1,094 24,142 8,047 9 - - 11 22 - - 1 13 234 2.91% 23,908 8,690 425 32.64% - - 2230
25
21330PUTUSSIBAU 2,401 1,201 14 22 20 17 - 37 22 22 9 304 25.32% 2,097 5,065 1,688 2 - - 3 1 - - 1 1 50 2.96% 5,015 2,889 354 28.28% - - 2240
26
21360BALAI KARANGAN 891 446 - 4 5 6 5 - - 8 7 127 28.51% 764 1,715 572 2 - - 3 - 2 - - - 13 2.27% 1,702 1,017 140 30.78% - - 2210
27
21370SEKADAU 7 7 - - - - - - - - - - 0.00% 7 1,423 474 6 15 7 5 - 2 3 1 - 153 32.26% 1,270 481 153 32.26% - - 2200
28
21380NANGA PINOH 422 211 - - - - - - - 24 - 43 20.38% 379 4,924 1,641 4 10 11 11 4 - 2 - 17 132 8.04% 4,792 1,852 175 28.42% - - 2220
29
UP3 SANGGAU 5,718 2,863 27 66 48 29 5 37 40 92 50 748 26.13% 4,970 40,210 13,403 23 25 20 37 30 5 7 4 32 725 5.41% 39,485 16,266 1,473 31.54% - - 2020
30
21400KETAPANG KOTA 46 46 - - - 1 1 - - - - 3 6.52% 43 1,010 505 1 1 - - - - - 1 1 12 2.38% 998 551 15 8.90% - - 2250
31
21410SUKADANA 303 303 - 2 - - 1 - - - 1 49 16.17% 254 414 207 - 1 - - - - - 1 - 7 3.38% 407 510 56 19.55% - - 2280
32
21420SANDAI 104 104 - - - - 1 4 4 3 - 15 14.42% 89 319 160 1 4 - - - - - - - 32 20.06% 287 264 47 34.49% - - 2260
33
21430TUMBANG TITI 21 21 - - - - - - - - - 11 52.38% 10 156 78 - - - - - - - - - - 0.00% 156 99 11 52.38% - - 2270
34
UP3 KETAPANG 474 474 - 2 - 1 3 4 4 3 1 78 16.46% 396 1,899 950 2 6 - - - - - 2 1 51 5.37% 1,848 1,424 129 21.83% - - 2030
35
UIW KALBAR 50,181 25,331 177 406 298 319 267 162 159 475 553 6,998 27.63% 43,183 68,216 23,077 44 44 32 46 39 8 7 21 40 1,236 5.36% 66,980 48,408 8,234 32.98% - -
36
37
38
 -
<< KLO MERAH ARTINYA ADA YG SALAH
39
40
41
42
select unitap, UNITUP, jenislayanan, substr(TGLGAMET,9,2) TGL, count(idpel) REALI from dil_ap2t_202212_mask
where gamet='2023' AND SUBSTR(TGLGAMET,1,7)='2023-10'AND TGLGAMET IS NOT NULL
GROUP BY jenislayanan,unitap,unitup, substr(TGLGAMET,9,2)
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100