Mapping Potential Local Water Company in Indonesia in 2018 To Receive Program Loan
Sarah Budiyani
2022-04-18
Introduction
An Indonesian National Development Bank is planning to roll out a new financing product called “program loan” to municipalities in Indonesia. It is essentially a result-based financing where the disbursement of fund is linked to the achievement of a set of pre-agreed indicators for the proposed municipality program(s). These indicators are called disbursement-linked indicators (DLIs) .
One of the sectors that the Bank is looking at is the water sector which is being implemented by the local water company (PDAM). Before rolling out the product, the Bank is mapping potential PDAMs that can be targeted for program loan and looking at the performance areas that the program could aim, among other things.
The analysis will be using the database extracted from the Performance Report of PDAMs in 2018 issued by the Directorate General of Public Works of the Ministry of Public Works and Public Housing of Indonesia.
Setting up PDAMs 2018 Data For Further Analysis
First, we need to set up the working directory:
getwd()## [1] "D:/R Programming/LBB"setwd("D:/R Programming/LBB")Second, we need to call the data for further checking:
#Data Input and Checking Data
PDAM_2018 <- read.csv("datainput/Kinerja PDAM 2018-lat.csv")
head(PDAM_2018)## No Kabupaten...Kota Propinsi Nilai.Tahun.Buku.2018
## 1 1 Kabupaten Simeulue Aceh 1.330
## 2 2 Kabupaten Aceh Singkil Aceh 2.035
## 3 3 Kabupaten Aceh Selatan Aceh 2.080
## 4 4 Kabupaten Aceh Tenggara Aceh 2.110
## 5 5 Kabupaten Aceh Timur Aceh 2.260
## 6 6 Kabupaten Aceh Tengah Aceh 2.855
## Kinerja.Tahun.Buku.2018 Jumlah.Pelanggan ROE Ratio.Operasi
## 1 SAKIT 2788 -0.113939322 1.722287
## 2 SAKIT 3905 -0.047379928 2.252499
## 3 SAKIT 7343 -0.006938939 1.022541
## 4 SAKIT 4089 -0.239618966 2.910039
## 5 KURANG SEHAT 12157 -0.053298939 1.171241
## 6 SEHAT 7377 -0.092117331 1.205339
## Cash.Ratio Efektivitas.Penagihan Solvabilitas Cakupan.Pelayanan.Teknis
## 1 0.38975581 0.6075158 91.55113208 0.1864142
## 2 1.10682521 0.7804852 107.7524074 0.3661771
## 3 0.241202074 0.9910852 28.92427042 0.1842458
## 4 0.173377431 0.5474828 59.94796087 0.1134764
## 5 0.331407912 1.0000000 28.69955229 0.1503599
## 6 0.355736632 0.9533209 340.4137651 0.2040601
## Pertumbuhan.Pelanggan....Tahun. Tingkat.Penyelesaian.Aduan
## 1 -0.23929059 NA
## 2 -0.02154848 0.9687500
## 3 0.49734910 0.8450000
## 4 -0.07634967 1.0000000
## 5 0.06743349 0.8588692
## 6 0.02103806 1.0000000
## Kualitas.Air.Pelanggan Konsumsi.Air.Domestik Efisiensi.Produksi
## 1 NA 11.109013 0.2604167
## 2 NA 17.252500 0.5307018
## 3 0 4.583119 0.2991328
## 4 NA 25.132773 0.9678899
## 5 0 14.390150 0.6275594
## 6 0 13.467067 0.2716223
## Tingkat.Kehilangan.Air Jam.Operasi.Pelayanan
## 1 0.4092435 6.906849
## 2 0.3873856 16.000000
## 3 0.5660268 13.958329
## 4 0.7384279 22.000000
## 5 0.2896564 16.517808
## 6 0.1986567 22.038356
## Tekanan.Air.pada.Sambungan.Pelanggan
## 1 NA
## 2 NA
## 3 0.0000000
## 4 NA
## 5 0.0000000
## 6 0.9360174
## Penggantian.Kalibrasi.Meter.Air.Pelanggan Rasio.Pegawai Ratio.Diklat.Pegawai
## 1 NA 8.608321 NA
## 2 0.04046095 9.731114 NA
## 3 0.01048618 4.357892 0.2500000
## 4 NA 11.249694 NA
## 5 0.04219791 6.416057 0.1025641
## 6 0.05422258 7.184492 0.8490566
## Ratio.Biaya.Diklat Tarif.rata.rata..Rp.m3. HPP.NRW.Rill...Rp.m3.
## 1 NA 3472.364 6345.054
## 2 NA 2146.404 4272.463
## 3 0.047982238 3594.411 3088.655
## 4 NA 1822.417 4387.614
## 5 0.002912905 4003.767 4984.788
## 6 0.011609973 4845.994 6002.742
## Selisih.Tarif..Rp.m3. FCR.Non.FCR
## 1 -2872.6904 Non FCR
## 2 -2126.0591 Non FCR
## 3 505.7566 FCR
## 4 -2565.1977 Non FCR
## 5 -981.0206 Non FCR
## 6 -1156.7481 Non FCRstr(PDAM_2018)## 'data.frame': 380 obs. of 28 variables:
## $ No : int 1 2 3 4 5 6 7 8 9 10 ...
## $ Kabupaten...Kota : chr "Kabupaten Simeulue" "Kabupaten Aceh Singkil" "Kabupaten Aceh Selatan" "Kabupaten Aceh Tenggara" ...
## $ Propinsi : chr "Aceh" "Aceh" "Aceh" "Aceh" ...
## $ Nilai.Tahun.Buku.2018 : num 1.33 2.04 2.08 2.11 2.26 ...
## $ Kinerja.Tahun.Buku.2018 : chr "SAKIT" "SAKIT" "SAKIT" "SAKIT" ...
## $ Jumlah.Pelanggan : int 2788 3905 7343 4089 12157 7377 5152 30048 6852 20950 ...
## $ ROE : num -0.11394 -0.04738 -0.00694 -0.23962 -0.0533 ...
## $ Ratio.Operasi : num 1.72 2.25 1.02 2.91 1.17 ...
## $ Cash.Ratio : chr "0.38975581" "1.10682521" "0.241202074" "0.173377431" ...
## $ Efektivitas.Penagihan : num 0.608 0.78 0.991 0.547 1 ...
## $ Solvabilitas : chr "91.55113208" "107.7524074" "28.92427042" "59.94796087" ...
## $ Cakupan.Pelayanan.Teknis : num 0.186 0.366 0.184 0.113 0.15 ...
## $ Pertumbuhan.Pelanggan....Tahun. : num -0.2393 -0.0215 0.4973 -0.0763 0.0674 ...
## $ Tingkat.Penyelesaian.Aduan : num NA 0.969 0.845 1 0.859 ...
## $ Kualitas.Air.Pelanggan : num NA NA 0 NA 0 0 NA 0 0 0 ...
## $ Konsumsi.Air.Domestik : num 11.11 17.25 4.58 25.13 14.39 ...
## $ Efisiensi.Produksi : num 0.26 0.531 0.299 0.968 0.628 ...
## $ Tingkat.Kehilangan.Air : num 0.409 0.387 0.566 0.738 0.29 ...
## $ Jam.Operasi.Pelayanan : num 6.91 16 13.96 22 16.52 ...
## $ Tekanan.Air.pada.Sambungan.Pelanggan : num NA NA 0 NA 0 ...
## $ Penggantian.Kalibrasi.Meter.Air.Pelanggan: num NA 0.0405 0.0105 NA 0.0422 ...
## $ Rasio.Pegawai : num 8.61 9.73 4.36 11.25 6.42 ...
## $ Ratio.Diklat.Pegawai : num NA NA 0.25 NA 0.103 ...
## $ Ratio.Biaya.Diklat : num NA NA 0.04798 NA 0.00291 ...
## $ Tarif.rata.rata..Rp.m3. : num 3472 2146 3594 1822 4004 ...
## $ HPP.NRW.Rill...Rp.m3. : num 6345 4272 3089 4388 4985 ...
## $ Selisih.Tarif..Rp.m3. : num -2873 -2126 506 -2565 -981 ...
## $ FCR.Non.FCR : chr "Non FCR" "Non FCR" "FCR" "Non FCR" ...As there are some data that are labeled as character instead of numeric, particularly for Cash Ratio and Solvability, and there are also data that would require to be changed to factor. Thus, we need to perform implicit coercion.
#implicit coercion
PDAM_2018$Cash.Ratio <- as.numeric(PDAM_2018$Cash.Ratio)## Warning: NAs introduced by coercionPDAM_2018$Solvabilitas <- as.numeric(PDAM_2018$Solvabilitas)## Warning: NAs introduced by coercionPDAM_2018$Propinsi <- as.factor(PDAM_2018$Propinsi)
PDAM_2018$Kinerja.Tahun.Buku.2018 <- as.factor(PDAM_2018$Kinerja.Tahun.Buku.2018)
PDAM_2018$FCR.Non.FCR <- as.factor(PDAM_2018$FCR.Non.FCR)Let’s check again for the data
#data structure checking
str(PDAM_2018)## 'data.frame': 380 obs. of 28 variables:
## $ No : int 1 2 3 4 5 6 7 8 9 10 ...
## $ Kabupaten...Kota : chr "Kabupaten Simeulue" "Kabupaten Aceh Singkil" "Kabupaten Aceh Selatan" "Kabupaten Aceh Tenggara" ...
## $ Propinsi : Factor w/ 34 levels "Aceh","Bali",..: 1 1 1 1 1 1 1 1 1 1 ...
## $ Nilai.Tahun.Buku.2018 : num 1.33 2.04 2.08 2.11 2.26 ...
## $ Kinerja.Tahun.Buku.2018 : Factor w/ 3 levels "KURANG SEHAT",..: 2 2 2 2 1 3 2 3 1 3 ...
## $ Jumlah.Pelanggan : int 2788 3905 7343 4089 12157 7377 5152 30048 6852 20950 ...
## $ ROE : num -0.11394 -0.04738 -0.00694 -0.23962 -0.0533 ...
## $ Ratio.Operasi : num 1.72 2.25 1.02 2.91 1.17 ...
## $ Cash.Ratio : num 0.39 1.107 0.241 0.173 0.331 ...
## $ Efektivitas.Penagihan : num 0.608 0.78 0.991 0.547 1 ...
## $ Solvabilitas : num 91.6 107.8 28.9 59.9 28.7 ...
## $ Cakupan.Pelayanan.Teknis : num 0.186 0.366 0.184 0.113 0.15 ...
## $ Pertumbuhan.Pelanggan....Tahun. : num -0.2393 -0.0215 0.4973 -0.0763 0.0674 ...
## $ Tingkat.Penyelesaian.Aduan : num NA 0.969 0.845 1 0.859 ...
## $ Kualitas.Air.Pelanggan : num NA NA 0 NA 0 0 NA 0 0 0 ...
## $ Konsumsi.Air.Domestik : num 11.11 17.25 4.58 25.13 14.39 ...
## $ Efisiensi.Produksi : num 0.26 0.531 0.299 0.968 0.628 ...
## $ Tingkat.Kehilangan.Air : num 0.409 0.387 0.566 0.738 0.29 ...
## $ Jam.Operasi.Pelayanan : num 6.91 16 13.96 22 16.52 ...
## $ Tekanan.Air.pada.Sambungan.Pelanggan : num NA NA 0 NA 0 ...
## $ Penggantian.Kalibrasi.Meter.Air.Pelanggan: num NA 0.0405 0.0105 NA 0.0422 ...
## $ Rasio.Pegawai : num 8.61 9.73 4.36 11.25 6.42 ...
## $ Ratio.Diklat.Pegawai : num NA NA 0.25 NA 0.103 ...
## $ Ratio.Biaya.Diklat : num NA NA 0.04798 NA 0.00291 ...
## $ Tarif.rata.rata..Rp.m3. : num 3472 2146 3594 1822 4004 ...
## $ HPP.NRW.Rill...Rp.m3. : num 6345 4272 3089 4388 4985 ...
## $ Selisih.Tarif..Rp.m3. : num -2873 -2126 506 -2565 -981 ...
## $ FCR.Non.FCR : Factor w/ 2 levels "FCR","Non FCR": 2 2 1 2 2 2 2 1 2 2 ...Next, we need to see whether there is any missing data.
#check missing values
anyNA(PDAM_2018)## [1] TRUEcolSums(is.na(PDAM_2018))## No
## 0
## Kabupaten...Kota
## 0
## Propinsi
## 0
## Nilai.Tahun.Buku.2018
## 0
## Kinerja.Tahun.Buku.2018
## 0
## Jumlah.Pelanggan
## 0
## ROE
## 2
## Ratio.Operasi
## 2
## Cash.Ratio
## 15
## Efektivitas.Penagihan
## 2
## Solvabilitas
## 13
## Cakupan.Pelayanan.Teknis
## 0
## Pertumbuhan.Pelanggan....Tahun.
## 0
## Tingkat.Penyelesaian.Aduan
## 8
## Kualitas.Air.Pelanggan
## 31
## Konsumsi.Air.Domestik
## 0
## Efisiensi.Produksi
## 0
## Tingkat.Kehilangan.Air
## 0
## Jam.Operasi.Pelayanan
## 1
## Tekanan.Air.pada.Sambungan.Pelanggan
## 23
## Penggantian.Kalibrasi.Meter.Air.Pelanggan
## 16
## Rasio.Pegawai
## 0
## Ratio.Diklat.Pegawai
## 40
## Ratio.Biaya.Diklat
## 39
## Tarif.rata.rata..Rp.m3.
## 0
## HPP.NRW.Rill...Rp.m3.
## 0
## Selisih.Tarif..Rp.m3.
## 0
## FCR.Non.FCR
## 0From the above info, apparently there are missing data. These missing data will be the first entry point for data filtering: remove rows with NA to make sure that the PDAMs that we’re looking at have the needed information for further analysis.
#data cleansing
PDAM_2018_new <- PDAM_2018[rowSums(is.na(PDAM_2018)) == 0, ]
PDAM_2018_new## No Kabupaten...Kota Propinsi
## 3 3 Kabupaten Aceh Selatan Aceh
## 5 5 Kabupaten Aceh Timur Aceh
## 6 6 Kabupaten Aceh Tengah Aceh
## 8 8 Kabupaten Aceh Besar Aceh
## 9 9 Kabupaten Pidie Aceh
## 11 11 Kabupaten Aceh Utara Aceh
## 12 12 Kabupaten Gayo Lues Aceh
## 13 13 Kabupaten Aceh Tamiang Aceh
## 14 14 Kabupaten Bener Meriah Aceh
## 16 16 Kota Banda Aceh Aceh
## 17 17 Kota Sabang Aceh
## 18 18 Kota Langsa Aceh
## 19 19 Kota Lhokseumawe Aceh
## 22 22 Kabupaten Tapanuli Tengah Sumatera Utara
## 23 23 Kabupaten Tapanuli Utara Sumatera Utara
## 24 24 Kabupaten Labuhan Batu Sumatera Utara
## 25 25 Kabupaten Asahan Sumatera Utara
## 26 26 Kabupaten Simalungun Sumatera Utara
## 27 27 Kabupaten Dairi Sumatera Utara
## 29 29 Kabupaten Deli Serdang Sumatera Utara
## 31 31 Kota Sibolga Sumatera Utara
## 32 32 Kota Tanjung Balai Sumatera Utara
## 33 33 Kota Pematang Siantar Sumatera Utara
## 34 34 Kota Tebing Tinggi Sumatera Utara
## 35 35 Kota Medan Sumatera Utara
## 36 36 Kota Binjai Sumatera Utara
## 38 38 Kabupaten Pesisir Selatan Sumatera Barat
## 39 39 Kabupaten Solok Sumatera Barat
## 40 40 Kabupaten Sijunjung Sumatera Barat
## 41 41 Kabupaten Tanah Datar Sumatera Barat
## 42 42 Kabupaten Padang Pariaman Sumatera Barat
## 43 43 Kabupaten Agam Sumatera Barat
## 44 44 Kabupaten Lima Puluh Kota Sumatera Barat
## 45 45 Kabupaten Pasaman Sumatera Barat
## 46 46 Kabupaten Solok Selatan Sumatera Barat
## 47 47 Kabupaten Pasaman Barat Sumatera Barat
## 48 48 Kota Padang Sumatera Barat
## 49 49 Kota Solok Sumatera Barat
## 50 50 Kota Sawahlunto Sumatera Barat
## 51 51 Kota Padang Panjang Sumatera Barat
## 52 52 Kota Bukit Tinggi Sumatera Barat
## 53 53 Kota Payakumbuh Sumatera Barat
## 54 54 Kabupaten Indragiri Hulu Riau
## 56 56 Kabupaten Kampar Riau
## 57 57 Kabupaten Bengkalis Riau
## 58 58 Kota Pekanbaru Riau
## 59 59 Kota Dumai Riau
## 60 60 Kabupaten Karimun Kepulauan Riau
## 61 61 Kabupaten Natuna Kepulauan Riau
## 62 62 Kabupaten Lingga Kepulauan Riau
## 63 63 Kota Tanjung Pinang Kepulauan Riau
## 64 64 Kabupaten Bengkulu Selatan Bengkulu
## 65 65 Kabupaten Rejang Lebong Bengkulu
## 66 66 Kabupaten Bengkulu Utara Bengkulu
## 70 70 Kota Bengkulu Bengkulu
## 72 72 Kabupaten Merangin Jambi
## 73 73 Kabupaten Sarolangun Jambi
## 74 74 Kabupaten Batanghari Jambi
## 75 75 Kabupaten Muaro Jambi Jambi
## 76 76 Kabupaten Tanjung Jabung Barat Jambi
## 77 77 Kabupaten Tebo Jambi
## 78 78 Kabupaten Bungo Jambi
## 79 79 Kota Jambi Jambi
## 80 80 Kabupaten Ogan Komering Ulu Sumatera Selatan
## 81 81 Kabupaten Ogan Komering Ilir Sumatera Selatan
## 82 82 Kabupaten Muara Enim Sumatera Selatan
## 85 85 Kabupaten Banyuasin Sumatera Selatan
## 86 86 Kabupaten Ogan Komering Ulu Selatan Sumatera Selatan
## 88 88 Kabupaten Ogan Ilir Sumatera Selatan
## 89 89 Kota Palembang Sumatera Selatan
## 90 90 Kota Prabumulih Sumatera Selatan
## 93 93 Kabupaten Belitung Bangka Belitung
## 94 94 Kabupaten Bangka Barat Bangka Belitung
## 95 95 Kabupaten Bangka Tengah Bangka Belitung
## 96 96 Kabupaten Belitung Timur Bangka Belitung
## 97 97 Kota Pangkal Pinang Bangka Belitung
## 98 98 Kabupaten Lampung Barat Lampung
## 100 100 Kabupaten Lampung Selatan Lampung
## 103 103 Kabupaten Pesawaran Lampung
## 105 105 Kota Bandar Lampung Lampung
## 106 106 DKI Jakarta DKI Jakarta
## 107 107 Kabupaten Pandeglang Banten
## 108 108 Kabupaten Lebak Banten
## 109 109 Kabupaten Tangerang Banten
## 110 110 Kabupaten Serang Banten
## 111 111 Kota Tangerang Banten
## 112 112 Kota Cilegon Banten
## 113 113 Kabupaten Bogor Jawa Barat
## 114 114 Kabupaten Sukabumi Jawa Barat
## 115 115 Kabupaten Cianjur Jawa Barat
## 116 116 Kabupaten Bandung Jawa Barat
## 117 117 Kabupaten Garut Jawa Barat
## 118 118 Kabupaten Tasikmalaya Jawa Barat
## 119 119 Kabupaten Ciamis Jawa Barat
## 120 120 Kabupaten Kuningan Jawa Barat
## 121 121 Kabupaten Cirebon Jawa Barat
## 122 122 Kabupaten Majalengka Jawa Barat
## 123 123 Kabupaten Sumedang Jawa Barat
## 124 124 Kabupaten Indramayu Jawa Barat
## 125 125 Kabupaten Subang Jawa Barat
## 126 126 Kabupaten Purwakarta Jawa Barat
## 127 127 Kabupaten Karawang Jawa Barat
## 128 128 Kabupaten Bekasi Jawa Barat
## 129 129 Kota Bogor Jawa Barat
## 130 130 Kota Sukabumi Jawa Barat
## 131 131 Kota Bandung Jawa Barat
## 132 132 Kota Cirebon Jawa Barat
## 133 133 Kota Bekasi Jawa Barat
## 134 134 Kota Depok Jawa Barat
## 135 135 Kota Banjar Jawa Barat
## 136 136 Kabupaten Cilacap Jawa Tengah
## 137 137 Kabupaten Banyumas Jawa Tengah
## 138 138 Kabupaten Purbalingga Jawa Tengah
## 139 139 Kabupaten Banjarnegara Jawa Tengah
## 140 140 Kabupaten Kebumen Jawa Tengah
## 141 141 Kabupaten Purworejo Jawa Tengah
## 142 142 Kabupaten Wonosobo Jawa Tengah
## 143 143 Kabupaten Magelang Jawa Tengah
## 144 144 Kabupaten Boyolali Jawa Tengah
## 145 145 Kabupaten Klaten Jawa Tengah
## 146 146 Kabupaten Sukoharjo Jawa Tengah
## 147 147 Kabupaten Wonogiri Jawa Tengah
## 148 148 Kabupaten Karanganyar Jawa Tengah
## 149 149 Kabupaten Sragen Jawa Tengah
## 150 150 Kabupaten Grobogan Jawa Tengah
## 151 151 Kabupaten Blora Jawa Tengah
## 152 152 Kabupaten Rembang Jawa Tengah
## 153 153 Kabupaten Pati Jawa Tengah
## 154 154 Kabupaten Kudus Jawa Tengah
## 155 155 Kabupaten Jepara Jawa Tengah
## 156 156 Kabupaten Demak Jawa Tengah
## 157 157 Kabupaten Semarang Jawa Tengah
## 158 158 Kabupaten Temanggung Jawa Tengah
## 159 159 Kabupaten Kendal Jawa Tengah
## 160 160 Kabupaten Batang Jawa Tengah
## 161 161 Kabupaten Pekalongan Jawa Tengah
## 162 162 Kabupaten Pemalang Jawa Tengah
## 163 163 Kabupaten Tegal Jawa Tengah
## 164 164 Kabupaten Brebes Jawa Tengah
## 165 165 Kota Magelang Jawa Tengah
## 166 166 Kota Surakarta Jawa Tengah
## 167 167 Kota Salatiga Jawa Tengah
## 168 168 Kota Semarang Jawa Tengah
## 169 169 Kota Pekalongan Jawa Tengah
## 170 170 Kota Tegal Jawa Tengah
## 171 171 Kabupaten Kulon Progo D. I. Yogyakarta
## 172 172 Kabupaten Bantul D. I. Yogyakarta
## 173 173 Kabupaten Gunung Kidul D. I. Yogyakarta
## 174 174 Kabupaten Sleman D. I. Yogyakarta
## 175 175 Kota Yogyakarta D. I. Yogyakarta
## 176 176 Kabupaten Pacitan Jawa Timur
## 177 177 Kabupaten Ponorogo Jawa Timur
## 178 178 Kabupaten Trenggalek Jawa Timur
## 179 179 Kabupaten Tulungagung Jawa Timur
## 180 180 Kabupaten Blitar Jawa Timur
## 181 181 Kabupaten Kediri Jawa Timur
## 182 182 Kabupaten Malang Jawa Timur
## 183 183 Kabupaten Lumajang Jawa Timur
## 184 184 Kabupaten Jember Jawa Timur
## 185 185 Kabupaten Banyuwangi Jawa Timur
## 186 186 Kabupaten Bondowoso Jawa Timur
## 187 187 Kabupaten Situbondo Jawa Timur
## 188 188 Kabupaten Probolinggo Jawa Timur
## 189 189 Kabupaten Pasuruan Jawa Timur
## 190 190 Kabupaten Sidoarjo Jawa Timur
## 191 191 Kabupaten Mojokerto Jawa Timur
## 192 192 Kabupaten Jombang Jawa Timur
## 193 193 Kabupaten Nganjuk Jawa Timur
## 194 194 Kabupaten Madiun Jawa Timur
## 195 195 Kabupaten Magetan Jawa Timur
## 196 196 Kabupaten Ngawi Jawa Timur
## 197 197 Kabupaten Bojonegoro Jawa Timur
## 198 198 Kabupaten Tuban Jawa Timur
## 199 199 Kabupaten Lamongan Jawa Timur
## 200 200 Kabupaten Gresik Jawa Timur
## 201 201 Kabupaten Bangkalan Jawa Timur
## 202 202 Kabupaten Sampang Jawa Timur
## 203 203 Kabupaten Pamekasan Jawa Timur
## 204 204 Kabupaten Sumenep Jawa Timur
## 205 205 Kota Kediri Jawa Timur
## 206 206 Kota Blitar Jawa Timur
## 207 207 Kota Malang Jawa Timur
## 208 208 Kota Probolinggo Jawa Timur
## 209 209 Kota Pasuruan Jawa Timur
## 210 210 Kota Mojokerto Jawa Timur
## 211 211 Kota Madiun Jawa Timur
## 212 212 Kota Surabaya Jawa Timur
## 213 213 Kota Batu Jawa Timur
## 214 214 Kabupaten Jembrana Bali
## 215 215 Kabupaten Tabanan Bali
## 216 216 Kabupaten Badung Bali
## 217 217 Kabupaten Gianyar Bali
## 218 218 Kabupaten Klungkung Bali
## 219 219 Kabupaten Bangli Bali
## 220 220 Kabupaten Karangasem Bali
## 221 221 Kabupaten Buleleng Bali
## 222 222 Kota Denpasar Bali
## 223 223 Kota Mataram Nusa Tenggara Barat
## 224 224 Kabupaten Lombok Tengah Nusa Tenggara Barat
## 225 225 Kabupaten Lombok Timur Nusa Tenggara Barat
## 226 226 Kabupaten Sumbawa Nusa Tenggara Barat
## 228 228 Kabupaten Sumbawa Barat Nusa Tenggara Barat
## 229 229 Kabupaten Dompu Nusa Tenggara Barat
## 231 231 Kabupaten Sumba Timur Nusa Tenggara Timur
## 232 232 Kabupaten Kupang Nusa Tenggara Timur
## 234 234 Kabupaten Timor Tengah Utara Nusa Tenggara Timur
## 235 235 Kabupaten Belu Nusa Tenggara Timur
## 237 237 Kabupaten Lembata Nusa Tenggara Timur
## 238 238 Kabupaten Flores Timur Nusa Tenggara Timur
## 239 239 Kabupaten Sikka Nusa Tenggara Timur
## 240 240 Kabupaten Ende Nusa Tenggara Timur
## 241 241 Kabupaten Ngada Nusa Tenggara Timur
## 242 242 Kabupaten Manggarai Nusa Tenggara Timur
## 244 244 Kabupaten Manggarai Barat Nusa Tenggara Timur
## 245 245 Kota Kupang Nusa Tenggara Timur
## 246 246 Kabupaten Sambas Kalimantan Barat
## 247 247 Kabupaten Bengkayang Kalimantan Barat
## 248 248 Kabupaten Landak Kalimantan Barat
## 250 250 Kabupaten Sanggau Kalimantan Barat
## 251 251 Kabupaten Ketapang Kalimantan Barat
## 252 252 Kabupaten Sintang Kalimantan Barat
## 253 253 Kabupaten Kapuas Hulu Kalimantan Barat
## 254 254 Kabupaten Sekadau Kalimantan Barat
## 255 255 Kabupaten Melawi Kalimantan Barat
## 256 256 Kabupaten Kubu Raya Kalimantan Barat
## 257 257 Kota Pontianak Kalimantan Barat
## 258 258 Kota Singkawang Kalimantan Barat
## 259 259 Kabupaten Kotawaringin Barat Kalimantan Tengah
## 260 260 Kabupaten Kotawaringin Timur Kalimantan Tengah
## 261 261 Kabupaten Kapuas Kalimantan Tengah
## 262 262 Kabupaten Barito Selatan Kalimantan Tengah
## 263 263 Kabupaten Barito Utara Kalimantan Tengah
## 264 264 Kabupaten Sukamara Kalimantan Tengah
## 265 265 Kabupaten Lamandau Kalimantan Tengah
## 267 267 Kabupaten Katingan Kalimantan Tengah
## 268 268 Kabupaten Pulang Pisau Kalimantan Tengah
## 269 269 Kabupaten Gunung Mas Kalimantan Tengah
## 271 271 Kabupaten Murung Raya Kalimantan Tengah
## 272 272 Kota Palangkaraya Kalimantan Tengah
## 273 273 Kabupaten Tanah Laut Kalimantan Selatan
## 274 274 Kabupaten Kotabaru Kalimantan Selatan
## 275 275 Kabupaten Banjar Kalimantan Selatan
## 277 277 Kabupaten Tapin Kalimantan Selatan
## 278 278 Kabupaten Hulu Sungai Selatan Kalimantan Selatan
## 279 279 Kabupaten Hulu Sungai Tengah Kalimantan Selatan
## 280 280 Kabupaten Hulu Sungai Utara Kalimantan Selatan
## 281 281 Kabupaten Tabalong Kalimantan Selatan
## 282 282 Kabupaten Tanah Bumbu Kalimantan Selatan
## 283 283 Kabupaten Balangan Kalimantan Selatan
## 284 284 Kota Banjarmasin Kalimantan Selatan
## 285 285 Kabupaten Paser Kalimantan Timur
## 286 286 Kabupaten Kutai Barat Kalimantan Timur
## 287 287 Kabupaten Kutai Kartanegara Kalimantan Timur
## 288 288 Kabupaten Kutai Timur Kalimantan Timur
## 289 289 Kabupaten Berau Kalimantan Timur
## 290 290 Kabupaten Penajam Paser Utara Kalimantan Timur
## 291 291 Kota Samarinda Kalimantan Timur
## 292 292 Kota Balikpapan Kalimantan Timur
## 294 294 Kabupaten Malinau Kalimantan Utara
## 295 295 Kabupaten Bulungan Kalimantan Utara
## 296 296 Kabupaten Nunukan Kalimantan Utara
## 297 297 Kota Tarakan Kalimantan Utara
## 298 298 Kabupaten Bolaang Mongondow Sulawesi Utara
## 299 299 Kabupaten Minahasa Sulawesi Utara
## 300 300 Kabupaten Kepulauan Sangihe Sulawesi Utara
## 303 303 Kabupaten Minahasa Utara Sulawesi Utara
## 304 304 Kabupaten Kepulauan Siau Tagulandang Biaro Sulawesi Utara
## 305 305 Kota Bitung Sulawesi Utara
## 306 306 Kota Tomohon Sulawesi Utara
## 307 307 Kabupaten Minahasa Tenggara Sulawesi Utara
## 309 309 Kabupaten Boalemo Gorontalo
## 310 310 Kabupaten Gorontalo Gorontalo
## 311 311 Kabupaten Pohuwato Gorontalo
## 312 312 Kabupaten Bone Bolango Gorontalo
## 313 313 Kota Gorontalo Gorontalo
## 315 315 Kabupaten Banggai Kepulauan Sulawesi Tengah
## 317 317 Kabupaten Poso Sulawesi Tengah
## 318 318 Kabupaten Donggala Sulawesi Tengah
## 319 319 Kabupaten Tolitoli Sulawesi Tengah
## 320 320 Kabupaten Buol Sulawesi Tengah
## 321 321 Kabupaten Tojo Una-Una Sulawesi Tengah
## 322 322 Kota Palu Sulawesi Tengah
## 323 323 Kabupaten Banggai laut Sulawesi Tengah
## 326 326 Kabupaten Bantaeng Sulawesi Selatan
## 327 327 Kabupaten Takalar Sulawesi Selatan
## 328 328 Kabupaten Gowa Sulawesi Selatan
## 329 329 Kabupaten Sinjai Sulawesi Selatan
## 330 330 Kabupaten Maros Sulawesi Selatan
## 331 331 Kabupaten Pangkajene Kepulauan Sulawesi Selatan
## 332 332 Kabupaten Barru Sulawesi Selatan
## 333 333 Kabupaten Bone Sulawesi Selatan
## 334 334 Kabupaten Soppeng Sulawesi Selatan
## 335 335 Kabupaten Wajo Sulawesi Selatan
## 336 336 Kabupaten Sidenreng Rappang Sulawesi Selatan
## 337 337 Kabupaten Enrekang Sulawesi Selatan
## 339 339 Kabupaten Tana Toraja Sulawesi Selatan
## 340 340 Kabupaten Luwu Utara Sulawesi Selatan
## 341 341 Kabupaten Luwu Timur Sulawesi Selatan
## 342 342 Kabupaten Toraja Utara Sulawesi Selatan
## 343 343 Kota Makassar Sulawesi Selatan
## 344 344 Kota Pare-Pare Sulawesi Selatan
## 345 345 Kota Palopo Sulawesi Selatan
## 346 346 Kabupaten Buton Sulawesi Tenggara
## 347 347 Kabupaten Muna Sulawesi Tenggara
## 349 349 Kabupaten Kolaka Sulawesi Tenggara
## 351 351 Kabupaten Wakatobi Sulawesi Tenggara
## 352 352 Kabupaten Kolaka Utara Sulawesi Tenggara
## 353 353 Kabupaten Kolaka Timur Sulawesi Tenggara
## 354 354 Kota Kendari Sulawesi Tenggara
## 356 356 Kabupaten Buton Selatan Sulawesi Tenggara
## 358 358 Kabupaten Polewali Mandar Sulawesi Barat
## 359 359 Kabupaten Mamasa Sulawesi Barat
## 360 360 Kabupaten Mamuju Sulawesi Barat
## 362 362 Kabupaten Maluku Tenggara Maluku
## 363 363 Kabupaten Maluku Tengah Maluku
## 366 366 Kota Ambon Maluku
## 369 369 Kabupaten Halmahera Barat Maluku Utara
## 371 371 Kabupaten Halmahera Utara Maluku Utara
## 372 372 Kabupaten Kepulauan Morotai Maluku Utara
## 373 373 Kota Ternate Maluku Utara
## 374 374 Kota Tidore Kepulauan Maluku Utara
## 375 375 Kabupaten Sula Maluku Utara
## 376 376 Kabupaten Fak-Fak Papua Barat
## 377 377 Kabupaten Manokwari Papua Barat
## 378 378 Kabupaten Jayapura Papua
## 380 380 Kabupaten Kepulauan Yapen Papua
## Nilai.Tahun.Buku.2018 Kinerja.Tahun.Buku.2018 Jumlah.Pelanggan ROE
## 3 2.080 SAKIT 7343 -0.006938939
## 5 2.260 KURANG SEHAT 12157 -0.053298939
## 6 2.855 SEHAT 7377 -0.092117331
## 8 3.250 SEHAT 30048 0.066250440
## 9 2.730 KURANG SEHAT 6852 -0.089509611
## 11 2.265 KURANG SEHAT 27110 -0.069770418
## 12 1.830 SAKIT 4478 -0.010564719
## 13 2.720 KURANG SEHAT 16619 0.011886521
## 14 2.120 SAKIT 5145 -0.037759603
## 16 3.090 SEHAT 47788 0.052093104
## 17 2.680 KURANG SEHAT 6487 -0.018437860
## 18 2.530 KURANG SEHAT 14172 -0.084463470
## 19 1.965 SAKIT 1851 -0.551415741
## 22 2.235 KURANG SEHAT 4264 -0.019548354
## 23 2.540 KURANG SEHAT 9936 -0.098735046
## 24 2.450 KURANG SEHAT 7020 -0.014761447
## 25 2.400 KURANG SEHAT 18512 -0.056247245
## 26 2.695 KURANG SEHAT 35404 0.004376188
## 27 2.860 SEHAT 16755 0.012116895
## 29 2.640 KURANG SEHAT 22812 -0.058980200
## 31 3.940 SEHAT 14850 0.038103515
## 32 2.310 KURANG SEHAT 22137 -0.515870270
## 33 3.180 SEHAT 66644 0.003116765
## 34 2.610 KURANG SEHAT 10565 -0.051694873
## 35 3.275 SEHAT 487255 0.091488784
## 36 2.370 KURANG SEHAT 12142 -0.148991672
## 38 2.345 KURANG SEHAT 22873 -0.038585788
## 39 2.270 KURANG SEHAT 15385 -0.011700541
## 40 2.875 SEHAT 10633 -0.034450943
## 41 2.955 SEHAT 18110 0.007254153
## 42 2.370 KURANG SEHAT 23008 -0.067973324
## 43 2.830 SEHAT 12778 -0.016137934
## 44 2.870 SEHAT 8661 -0.073728295
## 45 2.940 SEHAT 17821 -0.107078228
## 46 2.275 KURANG SEHAT 11620 -0.197732940
## 47 2.710 KURANG SEHAT 10299 -0.036863280
## 48 3.555 SEHAT 99364 0.132357151
## 49 2.915 SEHAT 14891 -0.055927182
## 50 2.550 KURANG SEHAT 7679 -0.074103626
## 51 3.170 SEHAT 7934 -0.030959965
## 52 3.000 SEHAT 9916 0.082107776
## 53 3.405 SEHAT 29641 0.035714512
## 54 2.555 KURANG SEHAT 13166 -0.111147951
## 56 3.115 SEHAT 8979 0.039064736
## 57 3.165 SEHAT 13268 0.072834901
## 58 2.150 SAKIT 12874 -0.054881394
## 59 1.855 SAKIT 893 -0.150236836
## 60 2.810 SEHAT 7637 0.472348793
## 61 2.575 KURANG SEHAT 5943 -0.057422672
## 62 3.200 SEHAT 5637 0.032198404
## 63 3.040 SEHAT 20196 0.026245447
## 64 2.290 KURANG SEHAT 4487 -0.050329499
## 65 2.945 SEHAT 13058 -0.076094542
## 66 3.240 SEHAT 13715 -0.036490308
## 70 3.105 SEHAT 35031 0.000318341
## 72 2.850 SEHAT 13049 -0.080558575
## 73 3.270 SEHAT 10745 -0.029748363
## 74 3.045 SEHAT 14256 0.022359244
## 75 2.435 KURANG SEHAT 12322 -0.008297732
## 76 2.430 KURANG SEHAT 8114 -0.109184418
## 77 3.165 SEHAT 9751 0.007725110
## 78 2.835 SEHAT 10463 0.013727282
## 79 2.870 SEHAT 78259 0.069974460
## 80 2.335 KURANG SEHAT 14112 -0.034273495
## 81 2.725 KURANG SEHAT 8096 -0.008437643
## 82 2.650 KURANG SEHAT 38622 -0.064191225
## 85 2.150 SAKIT 30007 -0.004458588
## 86 2.665 KURANG SEHAT 8552 -0.226712111
## 88 2.450 KURANG SEHAT 10488 -0.101425750
## 89 3.810 SEHAT 281462 0.176066337
## 90 2.035 SAKIT 10284 -0.045848624
## 93 1.450 SAKIT 2415 -0.082112524
## 94 3.280 SEHAT 4219 -0.014211227
## 95 2.250 KURANG SEHAT 1091 -0.197244733
## 96 2.270 KURANG SEHAT 3341 -0.023664888
## 97 2.600 KURANG SEHAT 5005 0.036935932
## 98 2.975 SEHAT 13085 0.040466695
## 100 2.635 KURANG SEHAT 6922 -0.003420308
## 103 3.105 SEHAT 6900 0.016740933
## 105 2.870 SEHAT 42193 0.006767862
## 106 3.205 SEHAT 863166 -0.645027484
## 107 3.350 SEHAT 20197 0.041078385
## 108 3.065 SEHAT 37801 0.001766872
## 109 4.265 SEHAT 145738 0.115043923
## 110 2.905 SEHAT 30786 0.010322860
## 111 3.560 SEHAT 47560 0.008859695
## 112 3.790 SEHAT 16795 0.099665238
## 113 4.190 SEHAT 144411 0.120514790
## 114 3.485 SEHAT 45030 0.008974903
## 115 3.365 SEHAT 46113 0.005221448
## 116 4.070 SEHAT 97329 0.057540179
## 117 2.455 KURANG SEHAT 50464 -0.126054074
## 118 3.450 SEHAT 43659 0.165656032
## 119 3.250 SEHAT 29614 0.000894000
## 120 3.650 SEHAT 48845 0.045125952
## 121 2.950 SEHAT 37813 0.020220645
## 122 3.415 SEHAT 24216 0.105470938
## 123 3.265 SEHAT 34004 0.013143803
## 124 3.475 SEHAT 115402 0.015771247
## 125 3.395 SEHAT 45543 0.020612640
## 126 2.875 SEHAT 27575 0.017063072
## 127 3.440 SEHAT 77003 0.024683161
## 128 3.190 SEHAT 231716 0.062755304
## 129 4.175 SEHAT 159290 0.092194242
## 130 2.935 SEHAT 21579 0.021520385
## 131 3.595 SEHAT 174908 0.066904206
## 132 3.450 SEHAT 58774 0.131172636
## 133 3.395 SEHAT 30824 0.014859669
## 134 3.990 SEHAT 60361 0.065555638
## 135 2.335 KURANG SEHAT 10090 -0.059326929
## 136 3.625 SEHAT 80833 0.081949428
## 137 3.470 SEHAT 78526 0.044375953
## 138 3.295 SEHAT 48646 0.058828515
## 139 2.415 KURANG SEHAT 8802 -0.436900039
## 140 3.825 SEHAT 29033 0.075218228
## 141 3.500 SEHAT 22651 0.134002378
## 142 3.475 SEHAT 91208 0.055617914
## 143 3.405 SEHAT 58539 0.098091901
## 144 3.060 SEHAT 47979 0.023756919
## 145 3.950 SEHAT 43062 0.082826186
## 146 3.510 SEHAT 30694 0.048612011
## 147 3.110 SEHAT 36873 0.023089566
## 148 3.605 SEHAT 58398 0.069777088
## 149 3.675 SEHAT 63203 0.051674433
## 150 2.925 SEHAT 30719 -0.023061450
## 151 3.175 SEHAT 17294 0.001070947
## 152 3.215 SEHAT 20426 0.035523953
## 153 3.170 SEHAT 31551 0.089128769
## 154 3.430 SEHAT 44171 0.041223522
## 155 3.190 SEHAT 46701 0.024146669
## 156 3.090 SEHAT 49843 0.063130612
## 157 3.655 SEHAT 48051 0.036365050
## 158 3.940 SEHAT 41287 0.049274796
## 159 3.510 SEHAT 78593 0.083658885
## 160 4.015 SEHAT 46189 0.149544421
## 161 3.230 SEHAT 15804 0.079637403
## 162 3.095 SEHAT 52823 0.052478436
## 163 3.775 SEHAT 42840 0.062045817
## 164 3.470 SEHAT 34468 0.053586733
## 165 3.740 SEHAT 31381 0.099140009
## 166 2.900 SEHAT 58871 0.039620908
## 167 3.885 SEHAT 31002 0.103278506
## 168 3.375 SEHAT 172334 0.057026442
## 169 3.140 SEHAT 27257 0.054177257
## 170 3.005 SEHAT 28101 0.111829729
## 171 3.465 SEHAT 26719 0.037377219
## 172 3.530 SEHAT 31058 0.023784151
## 173 3.105 SEHAT 47365 0.022585059
## 174 3.100 SEHAT 34512 0.028944008
## 175 3.340 SEHAT 32247 0.025800487
## 176 2.800 KURANG SEHAT 20820 0.003357249
## 177 3.180 SEHAT 20734 0.040625654
## 178 2.970 SEHAT 13703 -0.080663054
## 179 3.170 SEHAT 23601 0.014428520
## 180 2.870 SEHAT 14194 0.027948796
## 181 3.195 SEHAT 14907 0.016169250
## 182 3.890 SEHAT 119797 0.068007853
## 183 3.450 SEHAT 31457 0.059483692
## 184 4.070 SEHAT 36446 0.033561237
## 185 3.990 SEHAT 55878 0.211601151
## 186 3.575 SEHAT 18733 0.005777322
## 187 3.355 SEHAT 27916 0.057245993
## 188 3.025 SEHAT 20514 -0.063534353
## 189 2.925 SEHAT 24830 0.106398355
## 190 3.320 SEHAT 136682 0.091326994
## 191 3.615 SEHAT 27012 0.149328016
## 192 3.050 SEHAT 20009 0.009276720
## 193 3.265 SEHAT 22672 0.005775596
## 194 3.890 SEHAT 40194 0.055774212
## 195 3.485 SEHAT 70362 0.052272775
## 196 2.295 KURANG SEHAT 37010 0.018194275
## 197 3.795 SEHAT 37054 0.076997811
## 198 3.685 SEHAT 39910 0.031745514
## 199 3.295 SEHAT 21328 0.056243760
## 200 3.275 SEHAT 95432 0.115227445
## 201 2.845 SEHAT 21839 0.007819122
## 202 2.940 SEHAT 10800 0.064158339
## 203 2.630 KURANG SEHAT 12980 0.013743273
## 204 3.015 SEHAT 12949 0.886765526
## 205 2.940 SEHAT 14235 0.030015020
## 206 2.365 KURANG SEHAT 6264 -0.133957360
## 207 3.920 SEHAT 162369 0.154036586
## 208 3.030 SEHAT 19303 0.036851485
## 209 3.545 SEHAT 20600 0.017914376
## 210 2.420 KURANG SEHAT 5186 -0.148843644
## 211 3.865 SEHAT 39231 0.211842141
## 212 4.125 SEHAT 562381 0.197037864
## 213 3.040 SEHAT 13473 0.137949270
## 214 3.395 SEHAT 24046 -0.041280686
## 215 3.570 SEHAT 57096 0.031864761
## 216 3.695 SEHAT 71670 0.188915078
## 217 3.560 SEHAT 58767 0.038507367
## 218 3.330 SEHAT 32754 -0.017278809
## 219 3.065 SEHAT 17577 0.011436123
## 220 3.140 SEHAT 35862 0.031192659
## 221 4.140 SEHAT 51935 0.151598375
## 222 3.845 SEHAT 85136 0.085033323
## 223 3.845 SEHAT 135326 0.066285151
## 224 2.865 SEHAT 51234 0.000105321
## 225 2.990 SEHAT 23406 0.017579891
## 226 3.105 SEHAT 20819 0.040121430
## 228 2.570 KURANG SEHAT 12622 -0.133406778
## 229 2.195 SAKIT 8285 0.032726510
## 231 3.370 SEHAT 9297 0.053132403
## 232 3.165 SEHAT 23805 0.139683656
## 234 2.970 SEHAT 3478 -0.116494102
## 235 2.285 KURANG SEHAT 2905 0.105222946
## 237 2.910 SEHAT 4343 -0.030817837
## 238 3.020 SEHAT 7007 0.236204914
## 239 2.840 SEHAT 15242 -0.030925224
## 240 2.480 KURANG SEHAT 11344 -0.313477139
## 241 2.350 KURANG SEHAT 9349 0.002379930
## 242 3.445 SEHAT 21217 0.016512688
## 244 2.410 KURANG SEHAT 6054 -0.064548356
## 245 2.860 SEHAT 10124 0.001638770
## 246 2.200 KURANG SEHAT 7573 0.023640763
## 247 2.830 SEHAT 7201 -0.026256844
## 248 1.770 SAKIT 5322 -0.059325335
## 250 2.295 KURANG SEHAT 13587 -0.047638219
## 251 2.765 KURANG SEHAT 10083 0.006373909
## 252 2.610 KURANG SEHAT 6768 -0.057331076
## 253 2.555 KURANG SEHAT 13089 -0.097856950
## 254 3.490 SEHAT 6599 -0.002267657
## 255 2.935 SEHAT 6912 -0.087414341
## 256 2.680 KURANG SEHAT 16734 0.033600236
## 257 3.880 SEHAT 119459 0.096157980
## 258 2.830 SEHAT 16408 0.017871878
## 259 3.570 SEHAT 21522 -0.061117327
## 260 2.795 KURANG SEHAT 27941 -0.019040026
## 261 2.665 KURANG SEHAT 23709 -0.236695329
## 262 2.680 KURANG SEHAT 11786 0.029711664
## 263 3.030 SEHAT 14060 -0.071456293
## 264 2.535 KURANG SEHAT 1717 -0.369811797
## 265 3.270 SEHAT 3673 -0.060454509
## 267 3.100 SEHAT 5007 0.112511550
## 268 2.260 KURANG SEHAT 4149 -0.140877659
## 269 2.370 KURANG SEHAT 5465 -0.146722916
## 271 1.940 SAKIT 3105 -0.022377860
## 272 2.450 KURANG SEHAT 14783 -0.212645699
## 273 2.795 KURANG SEHAT 5147 -0.138662164
## 274 2.790 KURANG SEHAT 18071 -0.119652068
## 275 3.435 SEHAT 84403 0.011338486
## 277 2.930 SEHAT 16818 -0.080134475
## 278 3.045 SEHAT 17109 0.019459921
## 279 3.125 SEHAT 16423 -0.022281351
## 280 3.115 SEHAT 26149 -0.001137318
## 281 3.280 SEHAT 20959 -0.050918665
## 282 3.025 SEHAT 22838 -0.144649963
## 283 3.360 SEHAT 19589 -0.094343215
## 284 3.660 SEHAT 174772 0.040060327
## 285 3.560 SEHAT 22185 0.012132320
## 286 2.265 KURANG SEHAT 10849 -0.242670323
## 287 3.175 SEHAT 77070 0.023370538
## 288 3.655 SEHAT 24897 0.152458948
## 289 3.980 SEHAT 19382 0.089292951
## 290 3.225 SEHAT 7806 -0.275655119
## 291 3.620 SEHAT 156278 0.071292060
## 292 3.715 SEHAT 100504 0.044564396
## 294 3.780 SEHAT 9854 0.033570757
## 295 3.615 SEHAT 11429 0.028561320
## 296 3.670 SEHAT 11596 0.054957193
## 297 3.265 SEHAT 26175 -0.058383210
## 298 2.850 SEHAT 13297 0.057254500
## 299 1.485 SAKIT 10829 -0.212050004
## 300 2.755 KURANG SEHAT 11433 0.001963029
## 303 2.825 SEHAT 5822 0.146304789
## 304 2.245 KURANG SEHAT 2210 -0.005321947
## 305 3.045 SEHAT 17948 0.028776564
## 306 2.500 KURANG SEHAT 5740 -0.084302257
## 307 1.690 SAKIT 2301 -0.004439652
## 309 2.340 KURANG SEHAT 8526 -0.074305952
## 310 2.750 KURANG SEHAT 13394 -0.044818115
## 311 2.455 KURANG SEHAT 13421 -0.099642476
## 312 2.830 SEHAT 10990 -0.117028139
## 313 3.240 SEHAT 22282 0.020689244
## 315 2.480 KURANG SEHAT 8088 -0.080575044
## 317 2.510 KURANG SEHAT 10174 -0.055989780
## 318 2.670 KURANG SEHAT 26268 -0.138189569
## 319 2.680 KURANG SEHAT 15846 -0.029503550
## 320 3.095 SEHAT 4876 0.020259293
## 321 2.265 KURANG SEHAT 11434 -0.246426763
## 322 2.640 KURANG SEHAT 7133 -0.141255993
## 323 2.370 KURANG SEHAT 3941 -0.100196322
## 326 2.700 KURANG SEHAT 14996 -0.023043443
## 327 2.720 KURANG SEHAT 16326 -0.074483304
## 328 2.875 SEHAT 32958 0.001971794
## 329 3.135 SEHAT 12188 -0.024223591
## 330 3.040 SEHAT 17267 0.017483540
## 331 2.305 KURANG SEHAT 9366 0.044845979
## 332 2.235 KURANG SEHAT 9000 -0.049460411
## 333 1.995 SAKIT 14743 -0.173929504
## 334 2.450 KURANG SEHAT 10203 -0.077404280
## 335 2.710 KURANG SEHAT 15306 -0.170938008
## 336 2.470 KURANG SEHAT 7643 -0.062828723
## 337 3.050 SEHAT 9796 -0.098560108
## 339 1.975 SAKIT 5220 0.108302169
## 340 2.900 SEHAT 6313 0.095854459
## 341 2.945 SEHAT 7037 -0.029449112
## 342 2.150 SAKIT 8802 -0.004137954
## 343 3.485 SEHAT 172033 0.114477474
## 344 2.915 SEHAT 20188 -0.054214919
## 345 3.060 SEHAT 30969 -0.002226299
## 346 2.300 KURANG SEHAT 18186 -0.148363053
## 347 2.325 KURANG SEHAT 4683 0.038099680
## 349 1.365 SAKIT 5967 -0.022213209
## 351 2.405 KURANG SEHAT 6981 -0.067719944
## 352 2.625 KURANG SEHAT 11133 -0.250164135
## 353 1.800 SAKIT 1956 -0.035236717
## 354 1.925 SAKIT 15885 0.015645463
## 356 2.835 SEHAT 3347 -0.127468030
## 358 3.500 SEHAT 17006 0.025820544
## 359 1.585 SAKIT 3620 -0.104527744
## 360 3.945 SEHAT 15040 0.009818469
## 362 2.335 KURANG SEHAT 7391 0.001880368
## 363 2.995 SEHAT 9767 -0.109445323
## 366 2.000 SAKIT 11939 -0.076456489
## 369 2.500 KURANG SEHAT 7093 -0.032412360
## 371 2.535 KURANG SEHAT 16013 -0.101950803
## 372 1.940 SAKIT 4147 -0.107922984
## 373 2.875 SEHAT 29438 0.021629625
## 374 2.320 KURANG SEHAT 5231 -0.317930789
## 375 2.365 KURANG SEHAT 3434 -0.036725832
## 376 2.840 SEHAT 5489 0.136534691
## 377 2.865 SEHAT 5704 0.016147796
## 378 2.875 SEHAT 33478 -0.004814174
## 380 3.205 SEHAT 3979 0.029678049
## Ratio.Operasi Cash.Ratio Efektivitas.Penagihan Solvabilitas
## 3 1.0225409 2.412021e-01 0.9910852 28.924270
## 5 1.1712410 3.314079e-01 1.0000000 28.699552
## 6 1.2053392 3.557366e-01 0.9533209 340.413765
## 8 0.8059718 5.977525e+01 0.8569139 228.543626
## 9 1.5528555 7.648079e+00 0.9951987 1984.535070
## 11 1.2319833 6.070135e-02 0.9700956 9.827996
## 12 1.2047469 1.216277e-01 0.5899656 58.217308
## 13 0.9708723 1.519857e+00 0.9385227 10.559864
## 14 1.4182148 2.030869e+01 0.8268867 77.325051
## 16 0.9177426 7.311360e+01 0.8668697 736.491953
## 17 1.5191693 6.060884e-01 0.7642427 20.505716
## 18 1.1497879 2.574890e-01 1.0000000 4.185316
## 19 3.7138445 3.702422e-02 0.9854035 4.188483
## 22 1.1773858 1.230255e-01 0.8533382 341.785483
## 23 1.2512835 5.736644e+00 0.9157895 75.685404
## 24 1.0479518 2.278785e-02 0.9586523 8.945224
## 25 1.1849298 1.588521e-01 0.9304225 6.263469
## 26 0.9907003 1.857935e+00 0.8853630 22.566344
## 27 0.9799280 2.031852e-01 0.7319789 31.404060
## 29 1.2264820 2.957847e-01 0.9562358 15.842347
## 31 0.9263934 5.463399e+01 0.9462596 71.116952
## 32 1.4915470 1.976792e-01 0.9929857 3.555454
## 33 0.9902194 3.205747e-01 0.8610944 8.892850
## 34 1.1659099 9.375760e-01 0.7720000 26.551182
## 35 0.8777442 3.944063e+00 0.8500000 13.196379
## 36 1.1510249 8.787431e-01 0.7684599 5.832156
## 38 1.1866619 4.812702e-01 0.8184212 18.361729
## 39 1.0309636 6.268353e-01 0.8375849 65.209627
## 40 1.0822922 8.047725e+00 0.9526561 62.939578
## 41 0.9895735 1.761034e+00 0.9289215 13.812227
## 42 1.1364077 1.330069e+00 0.6326726 12.694640
## 43 1.0208457 3.308090e+02 0.9821502 68.644839
## 44 1.4370787 3.509673e+00 0.9497221 36.158627
## 45 1.5410666 8.289503e+00 0.6663420 20.493482
## 46 1.7601708 2.758142e-02 0.4621384 18.238132
## 47 1.3747842 3.179851e+01 0.5390494 634.795949
## 48 0.8686110 7.833881e-01 0.9699146 3.267110
## 49 1.2703270 8.928291e-01 0.9067915 55.650001
## 50 1.0955361 1.201958e+00 0.9851939 19.970096
## 51 1.0789726 6.104741e+00 0.9835141 5.844836
## 52 0.8304824 2.584635e+00 0.9778429 4.655239
## 53 0.9249761 1.330328e+00 0.9996179 18.591127
## 54 1.4146127 3.666427e+00 0.8726565 74.918884
## 56 0.9731492 1.462021e+00 0.9339231 12.321441
## 57 1.6953865 2.120037e+00 0.9274239 11.840939
## 58 1.2356672 3.300887e-02 0.7601607 13.501213
## 59 2.9918053 1.176998e-03 1.0000000 14.861836
## 60 0.8038527 1.038545e+00 0.9066433 5.315997
## 61 1.1291258 1.205265e-01 0.9609648 8.445956
## 62 0.9735420 3.551152e+00 0.9626622 2.076639
## 63 0.9799509 4.886199e+00 0.8739062 8.856980
## 64 1.1125987 5.774802e-01 0.7785589 27.617305
## 65 1.8224625 1.519489e+01 0.9300766 21.729200
## 66 1.1378538 4.305600e+01 0.9549380 26.151702
## 70 0.9150214 2.066503e+00 0.8366115 32.667220
## 72 1.1597918 3.822200e-01 0.9448073 7.886074
## 73 1.4549407 9.430549e+00 0.9301171 91.845160
## 74 1.1046732 2.620674e+01 0.8665114 25.875352
## 75 1.0984054 1.983387e-01 0.4208706 22.205547
## 76 3.3979950 1.079153e+00 0.9164537 13.694595
## 77 1.1314738 1.767596e+00 0.9289123 63.041182
## 78 1.1950203 6.915639e-01 0.8497374 20.983489
## 79 0.8447730 6.550387e-01 0.7658105 7.021034
## 80 1.0603181 1.421100e+01 0.8647753 1094.157601
## 81 1.4361779 1.621767e-01 0.7636815 21.323501
## 82 1.5501511 1.800139e+00 0.7195644 333.801011
## 85 1.0250849 9.018169e+01 0.5205225 2293.650089
## 86 1.9038941 1.022548e-01 0.7386674 27.767100
## 88 1.6385435 4.675220e+00 0.7882200 1771.784402
## 89 0.6659155 7.898959e+00 0.9770623 28.216732
## 90 1.4266396 2.006581e-01 0.6606587 153.459003
## 93 2.1154106 3.971671e-02 0.7927076 53.468517
## 94 1.0060593 7.220713e+01 0.9944587 20.183161
## 95 1.7925321 1.375997e+00 0.9520440 50.480097
## 96 1.0568522 2.107762e+00 0.9713400 25.920130
## 97 0.7375201 1.644743e-01 0.8679783 35.387532
## 98 0.9422336 2.534468e+01 0.8404799 104.536432
## 100 1.0147433 4.256103e+01 0.9364267 183.848714
## 103 0.9753007 1.166932e+01 0.7863702 84.991337
## 105 1.0138562 1.934789e+01 0.9585571 85.483228
## 106 0.9384160 4.899676e-01 0.9727787 0.827553
## 107 0.9358539 1.347333e+01 0.9826466 102.821149
## 108 0.9929513 1.124475e+00 0.8133126 22.811106
## 109 0.8243077 9.899177e+00 0.9517051 15.355204
## 110 0.9583671 2.891507e-01 0.7609695 6.955516
## 111 0.9990514 3.315865e+00 0.8870359 8.987620
## 112 0.7794465 5.747958e+00 0.9740600 12.173391
## 113 0.7450648 1.138842e+00 0.9678251 8.056073
## 114 0.9751678 9.393879e-01 0.9510234 10.097937
## 115 1.0924282 3.478585e-01 0.9372504 24.956795
## 116 0.8779493 4.371359e+00 0.9707017 8.374213
## 117 1.4386180 2.067816e-01 0.7844499 9.811157
## 118 0.9126564 1.143616e+00 0.9476628 2.416411
## 119 0.9970851 4.804417e-01 0.9845989 13.249551
## 120 0.9427353 6.167774e+00 0.9736388 10.046784
## 121 0.9811708 9.476351e-02 0.9614083 4.226409
## 122 0.8991999 1.579190e+00 0.8363882 6.277083
## 123 0.9804416 1.892328e-01 0.9905605 27.580003
## 124 0.9751451 6.008968e-01 0.9942584 7.352781
## 125 0.9592329 1.613093e+00 1.0086082 12.411721
## 126 0.9743448 6.430954e-01 0.9107156 3.269973
## 127 0.9360613 9.018894e-01 0.9055870 6.887345
## 128 0.8993899 3.060376e-01 0.9801446 7.404901
## 129 0.8268100 2.274001e+00 0.8677282 3.562163
## 130 0.9440685 3.523670e+00 0.8022285 22.046176
## 131 0.8524551 3.564959e+00 0.9021152 8.442197
## 132 0.9081734 2.231655e-01 0.9981560 2.088302
## 133 0.9672392 7.218152e+00 0.9595083 29.342123
## 134 0.8038524 1.773446e+01 0.9811986 27.804203
## 135 1.2272291 1.793139e-01 0.8505811 13.871830
## 136 0.7956674 9.963855e+00 0.9064142 7.949442
## 137 0.8865174 6.418011e-01 0.9996581 6.587631
## 138 0.8520221 4.398450e+00 0.9990036 12.374532
## 139 1.3959276 1.093532e+00 0.7409332 8.445688
## 140 0.8720093 1.166563e+01 0.9931280 37.638916
## 141 0.8590208 1.265687e+00 0.9184473 2.818901
## 142 0.9252777 4.988753e+01 0.9956385 19.617057
## 143 0.8181855 5.055896e+00 0.9693164 12.935007
## 144 0.8984961 2.076129e+00 0.9851132 16.131195
## 145 0.8663169 1.779441e+00 0.9628218 6.883176
## 146 0.8047282 2.605243e+00 0.9417694 81.767773
## 147 0.9714928 9.629516e+00 0.9883941 54.833223
## 148 0.8764088 9.081033e-01 0.9850673 19.155249
## 149 0.9071953 1.640589e+01 0.9117520 52.051722
## 150 1.0668656 1.214493e-01 0.9973796 15.731586
## 151 1.0004802 1.597415e+00 0.9060000 22.972617
## 152 0.9380422 5.434476e+00 1.0000000 9.794565
## 153 0.8745077 5.294009e-01 0.9951108 6.292782
## 154 0.8893368 4.423073e+00 0.9739885 17.966185
## 155 0.9097152 2.164909e+00 0.8898091 12.807271
## 156 0.8865482 1.976401e+00 0.9679128 12.303867
## 157 0.9338513 3.376456e+00 0.9004836 30.352506
## 158 0.8336039 6.498324e+00 0.9791361 54.999248
## 159 0.9134272 2.173731e-01 0.9915287 4.514368
## 160 0.7945275 7.431075e+00 0.9754746 5.217311
## 161 0.8434225 1.836940e+00 0.9110795 10.537583
## 162 0.8183828 3.470936e+00 0.9597721 8.180643
## 163 0.8449776 3.353300e+01 0.9278890 49.894594
## 164 0.9088394 1.105281e+00 0.9597055 7.637771
## 165 0.8827267 2.033025e+00 0.9654646 15.495488
## 166 0.9446972 6.993466e-01 0.9445528 4.157357
## 167 0.8743198 1.362906e+00 0.9332996 8.658864
## 168 0.9509513 1.987360e+00 0.9564316 5.761927
## 169 0.9490860 5.389842e+00 0.9395688 9.875624
## 170 0.8511005 1.473281e+01 0.9593653 8.526239
## 171 0.9181410 1.656788e+00 0.9926470 8.900791
## 172 0.9705289 6.381885e-01 0.9742168 10.971435
## 173 0.9775558 4.822181e-01 0.9591280 4.364572
## 174 0.9536628 7.172775e-01 1.0072249 10.215626
## 175 0.9744360 6.458849e+00 0.9079844 6.678859
## 176 0.9975504 6.633395e+00 0.9973082 33.510037
## 177 0.9007258 1.179737e+01 0.9004770 20.148731
## 178 1.4476112 1.540319e+01 0.9731498 43.601420
## 179 0.9462037 9.420552e+00 0.9783864 51.645763
## 180 0.9258792 1.291358e+00 0.9677405 12.368122
## 181 0.9650716 5.616442e+00 0.9782159 42.094300
## 182 0.8291299 2.394338e+00 1.0000000 10.228929
## 183 0.8268938 6.897354e+00 0.9928551 15.779581
## 184 0.9449719 1.537030e+00 0.8669877 6.420107
## 185 0.6480013 3.853368e+00 0.9882497 17.936389
## 186 1.0818570 3.091827e+00 0.9015797 20.898588
## 187 0.8705392 5.432521e+00 0.9942801 9.298354
## 188 1.3413664 1.172486e+00 0.9148954 66.486216
## 189 0.7718250 4.106341e+01 0.8209703 27.303566
## 190 0.8557939 2.724468e+00 0.9563134 6.961670
## 191 0.7734898 4.059066e+00 0.9426833 7.132042
## 192 0.9969779 4.679262e+01 0.9952700 16.590153
## 193 0.9965828 1.663832e+01 0.9349447 2.921117
## 194 0.8223958 9.118277e-01 0.9889553 14.111438
## 195 0.8607560 6.057002e+00 0.9779219 11.639263
## 196 0.9725336 2.767308e-01 0.9469439 5.512105
## 197 0.8411928 6.427342e+00 0.9389708 6.151012
## 198 0.8927750 3.244477e+01 0.9805062 19.232403
## 199 0.8482128 5.997608e+00 0.9531899 37.590473
## 200 0.8876174 1.012856e+00 0.9322811 4.127221
## 201 1.0297706 4.006574e+00 0.8405025 27.833229
## 202 0.9276929 1.360035e+00 0.8497325 10.170875
## 203 0.9475974 6.120703e-01 0.8361289 17.045177
## 204 0.8976162 1.435068e+00 0.8993439 5.712376
## 205 0.9456018 1.155153e+01 0.9813781 33.143735
## 206 1.3837045 1.334074e+00 0.8797056 6.929345
## 207 0.7696133 2.588867e+00 0.9464665 6.016047
## 208 0.9464656 1.172830e+00 0.9688974 7.490000
## 209 0.9561400 4.769745e+00 0.9404166 17.886485
## 210 1.4545742 1.648877e+00 0.9601591 8.937636
## 211 0.6864652 1.678474e+01 0.8677025 7.025892
## 212 0.6536268 4.738698e+00 0.9752341 9.964729
## 213 0.8184168 4.733980e+00 0.9677075 8.906310
## 214 1.0601580 1.578871e+00 0.9724763 62.558940
## 215 0.9477744 1.878265e-01 0.9883417 17.508307
## 216 0.8827050 7.477645e-01 0.8875250 7.946695
## 217 0.9298162 2.788787e+00 0.9835120 16.232227
## 218 1.0346367 1.405872e+00 0.8762604 23.451519
## 219 0.9970344 2.034896e+00 0.9791923 5.720467
## 220 0.9234750 1.730639e+01 0.9404681 22.868735
## 221 0.7960529 3.273390e+00 0.9384723 11.114666
## 222 0.8794056 2.064487e+00 0.9799640 5.996208
## 223 0.7262910 1.656691e+00 0.9480633 10.062304
## 224 0.9973112 1.663686e+00 0.8599914 39.662885
## 225 0.9418561 4.122172e+00 0.9287842 86.533998
## 226 0.9673342 2.516117e+00 0.9711886 60.643942
## 228 1.4005459 2.415130e+00 0.8326762 67.785079
## 229 0.8545574 2.866273e-01 0.5737462 74.210577
## 231 0.9198443 1.528339e+02 0.8587621 82.697952
## 232 0.8489202 2.180703e+00 0.9080619 7.215025
## 234 1.3556095 1.868142e+00 0.9145541 72.757383
## 235 0.9267112 6.013509e-02 0.9216832 1.755595
## 237 1.1085250 2.771764e+00 0.9566358 45.965927
## 238 0.9191335 2.198927e-01 0.9080600 1.395523
## 239 1.0885958 1.303917e+01 0.9302247 22.991845
## 240 1.2068597 7.275921e+00 0.8844384 10.035536
## 241 0.9895814 2.560034e+01 0.7240920 899.608311
## 242 0.9766943 1.310109e+01 0.9720550 12.092842
## 244 1.4576410 5.256138e+01 0.5463969 639.742412
## 245 1.0128446 2.274863e+01 0.8401300 126.434125
## 246 0.9695586 3.015884e-01 0.9009193 5.580424
## 247 1.0664424 1.283467e+01 0.7032441 105.836520
## 248 1.2841420 2.263617e-02 0.4768271 42.870506
## 250 1.4223122 1.238331e+01 0.8618498 2371.041457
## 251 0.9954598 4.639560e-01 0.9907511 7.068427
## 252 1.2525207 3.247363e+01 0.9538376 880.487474
## 253 1.3152591 3.356839e+01 0.8935547 710.930224
## 254 1.0525177 1.144127e+01 0.9205856 231.381268
## 255 1.4180710 3.167035e+00 0.9405000 96.187581
## 256 0.9571793 3.381571e-01 0.8544088 12.627819
## 257 0.8148895 1.653549e+00 0.9430747 4.904024
## 258 0.9503578 2.610054e+00 0.8636769 28.240987
## 259 1.1672867 7.510021e+00 0.9782240 58.530130
## 260 1.0814359 3.598720e+00 0.9935406 21.176789
## 261 1.8031824 1.555144e-01 0.8616162 32.717653
## 262 1.1111960 2.881591e+03 0.9708847 39702.531520
## 263 1.2308916 3.007528e+00 0.9721988 81.065637
## 264 3.4874675 4.304698e-01 0.8422276 10.553335
## 265 1.1073925 3.915275e+01 0.9620105 379.744906
## 267 1.3858145 1.093267e+00 0.9655985 39.538267
## 268 1.2672961 5.639943e-01 0.8346929 30.004292
## 269 1.8137725 2.046685e-01 0.8305140 74.760979
## 271 1.4865173 6.105390e-01 0.8494884 7.175040
## 272 1.2285578 1.632636e+00 0.5323646 23.840491
## 273 1.2192947 1.366894e+01 0.8667133 4.328356
## 274 1.3762267 2.633257e-01 0.9928364 24.727788
## 275 1.0077462 1.031399e+01 0.9495744 13.235499
## 277 1.4708298 4.098408e+03 0.9440430 54.820280
## 278 1.0949938 6.514298e+00 0.9905726 22.698268
## 279 1.1478402 2.969976e+03 0.9300000 10885.620040
## 280 1.0160449 1.840080e+02 0.9782751 12.754162
## 281 1.3442303 1.711923e+01 0.9691608 29.027588
## 282 1.2116762 7.816245e+01 0.9707817 13.048923
## 283 1.5433545 1.408695e+04 0.9323457 71.039467
## 284 0.9212251 3.328910e-01 0.9875000 2.992882
## 285 1.0133915 1.648555e+01 0.9976687 52.145362
## 286 1.9109679 3.387348e-01 1.0125532 19.799123
## 287 0.9170263 6.055041e+00 0.9996577 42.780206
## 288 0.9158922 1.345365e-01 0.8007034 2.642272
## 289 0.8638864 6.799268e+00 0.9432327 19.327226
## 290 1.3238709 7.010914e+01 0.9568996 1241.702416
## 291 0.8446437 5.852361e-01 0.9747855 3.415383
## 292 0.9183333 2.540533e+00 0.9893147 9.591051
## 294 1.0688891 1.020094e+01 0.9451974 7.023384
## 295 0.9723093 2.538477e+01 0.9849376 54.058070
## 296 0.9558665 3.732780e+00 0.9569942 16.925758
## 297 1.0750463 1.935132e+01 0.9333591 8.482838
## 298 0.8668609 2.599565e+00 0.7219520 28.119967
## 299 1.2124851 6.039442e-03 0.6347213 1.545996
## 300 0.9827737 3.580275e-02 0.9229589 8.910854
## 303 0.9052728 4.758463e-02 0.8420481 2.868533
## 304 1.0219015 2.446400e-02 0.8774747 16.777127
## 305 0.9173166 8.192016e-01 0.7444606 37.322623
## 306 1.1882335 6.390300e-02 0.9722820 33.075871
## 307 1.2686796 3.124635e-03 0.6938013 135.040940
## 309 1.7462560 7.815212e-01 0.8779644 82.790926
## 310 1.1533231 1.145643e+00 0.7994847 49.022662
## 311 1.4680278 6.773577e-01 0.8860474 71.208701
## 312 2.7315452 2.885014e-02 0.7489518 47.035865
## 313 0.9559206 3.335480e+00 0.8299385 29.629074
## 315 1.2688017 2.855949e-01 0.8053081 17.200795
## 317 1.1446621 3.682178e+00 0.9070399 10.056836
## 318 1.2237767 2.785563e+00 0.9142344 6.494293
## 319 1.0783277 8.313788e+01 0.7056533 18.384222
## 320 0.9028811 1.707310e+00 0.4602895 47.234376
## 321 2.1087509 3.904086e+00 0.8595581 393.274413
## 322 1.7869939 1.894574e+01 0.2887783 41.124187
## 323 1.4821602 4.929532e+00 0.9232198 62.080995
## 326 1.0197412 2.069797e+00 0.8439050 15.684869
## 327 1.2133775 7.131630e+01 0.8208716 568.097357
## 328 0.9952103 3.076188e+01 0.8267195 251.374548
## 329 1.0996440 1.601193e+01 0.9412057 13.771679
## 330 0.9823460 6.851812e-01 0.9046823 5.555065
## 331 0.9727641 7.886453e+00 0.6016413 14.603921
## 332 1.2873920 4.944047e+00 0.8405938 214.993539
## 333 1.0871419 1.457559e+00 0.8765711 1.726754
## 334 1.7519620 1.338883e+00 0.8656898 67.603641
## 335 1.2410646 1.545543e+00 0.9730848 22.325857
## 336 1.1919484 2.367561e-01 0.9544325 30.693026
## 337 1.7890760 2.389744e+01 0.9736207 574.178638
## 339 0.8539965 1.549540e+02 0.5653178 437.473570
## 340 0.8418333 8.500500e+00 0.8832939 44.200735
## 341 1.2530884 1.825127e+00 0.7779968 257.326276
## 342 1.0068131 3.021964e-01 0.8628937 19.721727
## 343 0.8593939 1.643171e+00 0.9761405 6.541628
## 344 1.1188731 9.426987e+00 0.9962154 6.982657
## 345 0.9762535 9.122897e-01 0.9880021 6.418520
## 346 1.3020741 1.440705e+00 0.8599101 63.983119
## 347 0.9734443 4.723444e-01 0.9107273 5.959352
## 349 1.1547688 -3.648727e-02 0.9490212 6.021127
## 351 1.9741131 7.775680e+00 0.8264504 112.662354
## 352 1.9713339 2.289769e-01 0.9080200 132.917482
## 353 1.3988168 1.694900e-02 0.5448894 7.708390
## 354 0.9904789 2.180800e-01 0.7476888 10.328141
## 356 8.2713068 8.740906e-01 0.8928056 60.533040
## 358 0.9358219 4.077992e+01 0.7776235 148.202461
## 359 1.7673488 5.023545e-01 0.6341903 36.370298
## 360 0.9790440 1.408644e+01 0.9873209 24.141403
## 362 1.0169983 2.589782e+01 0.8476602 293.921854
## 363 1.8493099 1.791827e+00 0.8722932 208.591181
## 366 1.1878566 4.787379e-01 0.7068941 5.495599
## 369 1.0464068 1.691461e-01 0.9758424 26.576932
## 371 1.2871118 2.209946e-01 0.8008428 19.288100
## 372 1.8459007 7.632991e-01 0.3307150 391.068344
## 373 0.9699855 1.986853e+00 0.9456866 12.879148
## 374 1.7756091 9.304783e-02 0.9347239 13.412605
## 375 1.3256757 4.769329e-01 0.7146450 29.131897
## 376 0.8241327 9.687148e+00 0.6719147 10.821378
## 377 0.9632347 4.408610e+02 0.7492773 6075.117260
## 378 0.9809706 5.040095e-01 0.8556731 6.460737
## 380 0.9484370 1.238679e+02 0.9893527 44.463978
## Cakupan.Pelayanan.Teknis Pertumbuhan.Pelanggan....Tahun.
## 3 0.18424581 0.497349103
## 5 0.15035992 0.067433488
## 6 0.20406006 0.021038062
## 8 0.29786520 0.108373294
## 9 0.07798726 0.111796203
## 11 0.18085859 0.070272404
## 12 0.24611189 0.358204428
## 13 0.22817648 0.071156945
## 14 0.17737492 -0.044390788
## 16 0.59035139 0.050285714
## 17 0.66666667 0.044605475
## 18 0.35713466 0.080512351
## 19 0.20959137 0.003796095
## 22 0.13236755 0.069744104
## 23 0.15061006 0.035755238
## 24 0.15147627 0.047292257
## 25 0.20668427 0.100659968
## 26 0.20543599 0.080048810
## 27 0.60105340 0.090181534
## 29 0.05739044 0.086699695
## 31 0.85491765 0.048951049
## 32 0.52019721 0.039442175
## 33 0.88712255 0.020925886
## 34 0.23773996 -0.025099197
## 35 0.50322837 -0.006007752
## 36 0.26825217 -0.004835669
## 38 0.23246213 0.071334895
## 39 0.37306401 0.023006849
## 40 0.30879935 0.083341824
## 41 0.45437368 0.023684359
## 42 0.40381237 0.192371476
## 43 0.27732373 0.030650105
## 44 0.10978910 0.217972156
## 45 0.59013109 0.048787665
## 46 0.34546887 0.102362205
## 47 0.16911760 0.135251323
## 48 0.61480824 0.067615047
## 49 0.82769671 0.019512529
## 50 0.63169165 -0.012601260
## 51 0.67788172 0.072307069
## 52 0.32800270 0.017965301
## 53 0.84105548 0.103783421
## 54 0.30942466 0.073373553
## 56 0.12379518 0.073272771
## 57 0.37175958 -0.010662889
## 58 0.08429062 0.049482351
## 59 0.22174371 -0.107000000
## 60 0.13185957 0.085417851
## 61 0.66887093 0.037897311
## 62 0.71020007 0.066603595
## 63 0.28506961 0.036596007
## 64 0.18434767 0.049836219
## 65 0.34684226 0.095837529
## 66 0.43804286 0.107209171
## 70 0.67279542 0.044018597
## 72 0.47530068 0.055744337
## 73 0.29030145 0.141506427
## 74 0.53170619 0.258474576
## 75 0.30548583 0.092279053
## 76 0.16152600 0.224015689
## 77 0.29278545 0.260796483
## 78 0.31298422 -0.001526863
## 79 0.65422733 0.072555335
## 80 0.15719648 0.034452426
## 81 0.10090538 0.210345343
## 82 0.36899728 0.041024259
## 85 0.20805933 0.083911284
## 86 0.14440519 0.151164356
## 88 0.11830228 0.091703966
## 89 0.72549466 0.028810586
## 90 0.26504984 -0.042368936
## 93 0.10962131 0.016842105
## 94 0.19738645 0.123269436
## 95 0.06553326 0.094282849
## 96 0.21996875 -0.002984184
## 97 0.11290255 0.250624688
## 98 0.75901730 0.053203477
## 100 0.65543040 0.046093396
## 103 0.34628419 0.120857700
## 105 0.35700009 -0.006522251
## 106 0.28048359 0.013737435
## 107 0.11051287 0.047997094
## 108 0.37108527 0.205773525
## 109 0.48481500 0.033214465
## 110 0.12250287 -0.022480472
## 111 0.12770611 0.247115586
## 112 0.34552955 0.036920417
## 113 0.29425054 0.077091180
## 114 0.20748488 0.131463893
## 115 0.60048227 0.010651588
## 116 0.24703857 0.065241660
## 117 0.33868844 -0.004870738
## 118 0.27046651 0.042976589
## 119 0.33772020 0.092848181
## 120 0.39045917 0.084071287
## 121 0.12826680 0.052671139
## 122 0.39689090 0.052549224
## 123 0.44842176 0.077542225
## 124 0.61394938 0.083332551
## 125 0.34353227 0.040412117
## 126 0.67162775 0.046926611
## 127 0.42749639 0.069798136
## 128 0.37333214 0.052317027
## 129 0.90222022 0.033464822
## 130 0.23392975 0.005826419
## 131 0.66604396 0.074980947
## 132 0.79918915 -0.000765059
## 133 0.29021351 0.050472004
## 134 0.15989437 0.054635357
## 135 0.19124611 0.049074652
## 136 0.27758715 0.051609294
## 137 0.25810260 0.115711403
## 138 0.28756361 0.047502153
## 139 0.14037419 0.036260890
## 140 0.21392743 0.135787497
## 141 0.37700685 0.070918633
## 142 0.61019982 0.041234760
## 143 0.30969029 0.038293721
## 144 0.32691069 0.039609109
## 145 0.40992534 0.060901700
## 146 0.16180834 0.118341471
## 147 0.19630308 0.047855864
## 148 0.23721140 0.089758901
## 149 0.23745479 0.039317898
## 150 0.23391957 0.007609801
## 151 0.23156132 0.063330054
## 152 0.44678964 0.049316757
## 153 0.29159454 0.079404721
## 154 0.26998374 0.051114866
## 155 0.15909325 0.132859499
## 156 0.40288124 0.065932421
## 157 0.30312519 0.064676948
## 158 0.22733966 0.057908627
## 159 0.28000381 0.076129969
## 160 0.42425755 0.037512073
## 161 0.16139239 0.065462145
## 162 0.30600174 0.027664831
## 163 0.29808764 0.054678845
## 164 0.09033590 0.165995738
## 165 0.92691663 0.039174780
## 166 0.35560474 -0.009356017
## 167 0.55485855 0.035609300
## 168 0.40584693 0.014099260
## 169 0.35136317 0.035482278
## 170 0.36987996 0.207087629
## 171 0.49836259 0.134661118
## 172 0.21718207 0.080766955
## 173 0.59142735 0.041767475
## 174 0.14511599 0.068251463
## 175 0.26847295 -0.006470099
## 176 0.15129058 0.018541167
## 177 0.16492971 0.059587081
## 178 0.07402677 0.110994000
## 179 0.19897206 -0.048576957
## 180 0.17811420 0.023507355
## 181 0.23590419 0.036215765
## 182 0.32357334 0.062161970
## 183 0.20235914 0.060622408
## 184 0.23506710 0.061173388
## 185 0.30642088 0.083284867
## 186 0.28424891 0.023605267
## 187 0.31402125 0.056343891
## 188 0.20905180 -0.003642722
## 189 0.22636304 0.003029691
## 190 0.28115162 0.013232318
## 191 0.09146767 0.097736416
## 192 0.17895948 0.030966612
## 193 0.18892096 0.097705045
## 194 0.63814580 0.082783330
## 195 0.54904636 0.026717836
## 196 0.25761502 0.051211407
## 197 0.13718538 0.081047964
## 198 0.31315089 0.073282237
## 199 0.31594719 0.105650596
## 200 0.36836878 0.042790332
## 201 0.11928877 0.045979214
## 202 0.13241277 -0.037347357
## 203 0.14800204 0.036741214
## 204 0.21781754 0.019766892
## 205 0.21373969 0.031073446
## 206 0.20382060 -0.011363636
## 207 0.72356423 0.039387771
## 208 0.40366314 0.032356402
## 209 0.55824433 0.026151930
## 210 0.11248666 0.048524060
## 211 0.67318408 0.026559556
## 212 0.98970616 0.012233974
## 213 0.39248315 0.048727329
## 214 0.76746362 0.020022058
## 215 0.59607879 0.019407595
## 216 0.39964864 0.013619585
## 217 0.53562446 0.025315793
## 218 0.73996124 0.089330850
## 219 0.62772976 0.038277512
## 220 0.39874918 0.044990967
## 221 0.57340636 0.059206233
## 222 0.29146465 0.019959267
## 223 0.63927712 0.066180294
## 224 0.26155305 -0.006939060
## 225 0.19048156 0.046405579
## 226 0.25240235 0.054981251
## 228 0.56741861 0.064698439
## 229 0.22595264 0.003634161
## 231 0.31863396 0.031510041
## 232 0.16933002 -0.039578794
## 234 0.12713427 -0.123487903
## 235 0.10731495 -0.022214743
## 237 0.52977430 0.006255792
## 238 0.36996239 0.031654888
## 239 0.33581212 0.080916247
## 240 0.21623358 -0.001408451
## 241 0.44084659 0.076701601
## 242 0.43003863 0.150783750
## 244 0.18818835 0.058576674
## 245 0.12283244 -0.006866784
## 246 0.16901605 0.197880418
## 247 0.38316758 0.085632444
## 248 0.11535779 0.855001743
## 250 0.17340827 0.215621365
## 251 0.14013289 0.146577212
## 252 0.12195668 0.054205607
## 253 0.26828208 0.130994556
## 254 0.16631250 0.104065585
## 255 0.24278125 0.126466754
## 256 0.14415617 0.082826453
## 257 0.77202955 0.072294780
## 258 0.37058171 0.273814145
## 259 0.40340454 0.104371921
## 260 0.44703617 0.037541775
## 261 0.55060155 0.079989068
## 262 0.66511480 0.072331908
## 263 0.36104613 0.027027027
## 264 0.21013483 0.388035570
## 265 0.41279449 0.154305468
## 267 0.37381509 0.060580386
## 268 0.31668974 0.254611430
## 269 0.62077721 0.175521618
## 271 0.36870356 -0.226457399
## 272 0.20583282 -0.129592558
## 273 0.10207717 0.287715787
## 274 0.50639888 0.133973394
## 275 0.54646472 0.095275172
## 277 0.51501737 0.029379361
## 278 0.50076773 0.012007571
## 279 0.35629784 0.035628705
## 280 0.68351850 0.084255919
## 281 0.62810245 0.089062094
## 282 0.28605342 0.178613821
## 283 0.84266862 0.051193990
## 284 0.99980630 0.015295778
## 285 0.65343691 0.088567223
## 286 0.37584191 0.084466214
## 287 0.46373603 0.061307114
## 288 0.34712730 0.070286304
## 289 0.61346826 0.115896137
## 290 0.39068091 0.225239366
## 291 0.70509276 0.046058488
## 292 0.47713933 0.024390741
## 294 0.88195891 0.178708134
## 295 0.61485013 0.168131643
## 296 0.33743948 0.214113705
## 297 0.44006780 0.084614428
## 298 0.21050926 0.006052811
## 299 0.21426150 0.010544979
## 300 0.40512119 0.088753452
## 303 0.57001056 0.034838251
## 304 0.25474704 0.026951673
## 305 0.53471378 0.151324652
## 306 0.58688411 0.015749425
## 307 0.23188558 -0.172897196
## 309 0.29635321 -0.020675396
## 310 0.16677720 0.174603175
## 311 0.53593381 0.123002259
## 312 0.41381537 0.517746168
## 313 0.62306087 0.008691716
## 315 0.75828441 0.162904385
## 317 0.26996328 -0.054724519
## 318 0.22563822 -0.011552211
## 319 0.42401920 -0.000252366
## 320 0.24955329 0.462068966
## 321 0.52170574 -0.049305729
## 322 0.18358045 0.184883721
## 323 0.18988077 0.031135531
## 326 0.45431162 0.124306493
## 327 0.27861685 0.043328221
## 328 0.36181347 0.112844408
## 329 0.66648243 0.167768516
## 330 0.39782839 0.095413310
## 331 0.25807834 0.028778559
## 332 0.28039480 0.039501040
## 333 0.23178584 0.010140459
## 334 0.34527881 0.081169863
## 335 0.63758225 0.122964050
## 336 0.21470005 -0.047363829
## 337 0.23636857 0.083029298
## 339 0.15736068 0.008305969
## 340 0.26449640 0.372391304
## 341 0.19867954 0.446751645
## 342 0.35652985 0.034312573
## 343 0.62007593 0.015465165
## 344 0.71533811 0.045739446
## 345 0.70003052 0.038496362
## 346 0.48285509 0.033530348
## 347 0.27255209 0.029457024
## 349 0.13470436 -0.023404255
## 351 0.29735484 0.238424694
## 352 0.36820565 0.150697674
## 353 0.09705120 0.044871795
## 354 0.23106373 -0.016286847
## 356 0.80090990 0.195784209
## 358 0.34011178 0.069156293
## 359 0.22390183 0.036655212
## 360 0.51442938 0.106940458
## 362 0.70883303 0.012604466
## 363 0.45251852 -0.049070198
## 366 0.16597884 0.019294801
## 369 0.45360558 0.103968872
## 371 0.52633924 0.193219076
## 372 0.24064223 0.422641509
## 373 0.75405389 0.032731100
## 374 0.42884821 -0.031475653
## 375 0.65374358 0.000000000
## 376 0.50674733 0.026941066
## 377 0.21041997 0.030160737
## 378 0.63548373 0.047595206
## 380 0.57461345 0.056839309
## Tingkat.Penyelesaian.Aduan Kualitas.Air.Pelanggan Konsumsi.Air.Domestik
## 3 0.8450000 0.000000000 4.583119
## 5 0.8588692 0.000000000 14.390150
## 6 1.0000000 0.000000000 13.467067
## 8 1.0000000 0.000000000 17.155621
## 9 0.9875519 0.000000000 11.942485
## 11 0.9674267 0.026666667 13.941163
## 12 0.9810875 0.000000000 12.950660
## 13 0.9700665 0.000000000 14.776773
## 14 1.0000000 0.000000000 10.595746
## 16 0.9995481 0.144444444 19.436659
## 17 1.0000000 0.000000000 20.257248
## 18 1.0000000 0.000000000 14.904017
## 19 1.0000000 0.000000000 9.658561
## 22 1.0000000 0.000000000 22.115206
## 23 0.9380316 0.000000000 14.163756
## 24 1.0000000 0.000000000 22.041087
## 25 1.0000000 0.000000000 16.371193
## 26 1.0000000 0.000000000 12.673796
## 27 1.0000000 0.000000000 16.182144
## 29 0.9153439 0.000000000 17.799313
## 31 1.0000000 1.000000000 29.402982
## 32 1.0000000 0.000000000 24.064852
## 33 1.0000000 0.000000000 16.257580
## 34 1.0000000 0.000000000 17.185051
## 35 0.9970655 0.000000000 22.557319
## 36 1.0000000 0.000000000 16.856178
## 38 1.0000000 0.000000000 13.828518
## 39 1.0000000 0.000000000 14.867194
## 40 0.7360890 0.000000000 15.353039
## 41 0.8779726 0.034883721 14.739388
## 42 0.6574307 0.000000000 9.849560
## 43 0.9955899 0.026819923 16.164425
## 44 1.0000000 0.056179775 14.533579
## 45 0.9940254 0.648148148 15.656617
## 46 0.8556701 0.000000000 13.601644
## 47 0.9888889 0.413385827 14.578994
## 48 1.0000000 0.179824561 21.389179
## 49 0.9223549 0.019292605 23.216867
## 50 1.0000000 0.116883117 16.994229
## 51 1.0000000 0.190751445 24.864860
## 52 1.0000000 0.434482759 22.357619
## 53 0.9690806 0.000000000 16.396152
## 54 1.0000000 0.911764706 18.290637
## 56 1.0000000 0.877192982 15.047590
## 57 1.0000000 0.885714286 16.065602
## 58 1.0000000 1.000000000 13.353498
## 59 1.0000000 0.888888889 2.990327
## 60 0.9323843 0.190909091 15.865890
## 61 1.0000000 0.600000000 19.934716
## 62 1.0000000 0.230769231 21.526673
## 63 0.9273950 0.637500000 16.597852
## 64 0.9741935 0.714285714 10.841515
## 65 0.8679245 0.315789474 16.572240
## 66 1.0000000 0.421052632 16.957814
## 70 0.9255237 0.501385042 15.744121
## 72 1.0000000 1.000000000 12.049754
## 73 1.0000000 1.000000000 11.073488
## 74 1.0000000 1.000000000 10.711675
## 75 0.9323467 0.827450980 13.653688
## 76 1.0000000 0.000000000 12.569548
## 77 0.9158416 1.000000000 12.243802
## 78 1.0000000 1.000000000 15.870737
## 79 0.9979319 1.000000000 16.808312
## 80 1.0000000 0.914285714 25.108503
## 81 1.0000000 1.000000000 14.554690
## 82 1.0000000 0.818423384 15.781373
## 85 1.0000000 0.895833333 11.921284
## 86 1.0000000 1.000000000 16.234441
## 88 1.0000000 0.000000000 12.097986
## 89 0.9768683 0.992874109 26.746309
## 90 0.7660714 0.949044586 11.182580
## 93 1.0000000 0.000000000 8.774318
## 94 1.0000000 0.000000000 15.426020
## 95 1.0000000 0.000000000 17.429358
## 96 1.0000000 0.000000000 16.517873
## 97 1.0000000 0.000000000 14.011205
## 98 0.9500000 0.000000000 17.070416
## 100 1.0000000 0.227272727 13.889414
## 103 1.0000000 0.405172414 12.859804
## 105 1.0000000 0.204545455 15.558549
## 106 0.9920114 0.999908467 26.033663
## 107 1.0000000 1.000000000 18.744403
## 108 1.0000000 0.912011864 8.824155
## 109 0.8207715 1.000000000 20.200198
## 110 1.0000000 1.000000000 19.137967
## 111 0.7458595 0.809815951 17.732652
## 112 0.9001070 0.791666667 21.989927
## 113 1.0000000 1.000000000 15.710083
## 114 0.9469228 0.956896552 12.392569
## 115 1.0000000 0.917591125 13.220173
## 116 1.0000000 1.000000000 16.095680
## 117 1.0000000 0.376262626 12.754444
## 118 1.0000000 3.106837607 12.576121
## 119 1.0000000 0.675564682 1.132658
## 120 1.0000000 0.888077859 13.736346
## 121 1.0000000 0.760677467 12.582064
## 122 1.0000000 0.932432432 17.431010
## 123 1.0000000 0.699494949 11.234604
## 124 1.0000000 0.998538012 15.678374
## 125 1.0000000 0.930555556 12.936092
## 126 1.0000000 0.520689655 13.232147
## 127 0.9201118 0.823880597 17.702153
## 128 1.0000000 0.743518884 16.216167
## 129 0.8934089 0.978400467 18.158675
## 130 1.0000000 0.607721046 11.617438
## 131 1.0000000 0.644155844 15.318105
## 132 0.8719797 0.973529412 1.658430
## 133 0.9327010 0.603960396 16.466699
## 134 1.0000000 1.408163265 16.965284
## 135 1.0000000 1.000000000 13.937071
## 136 1.0000000 0.533980583 13.313009
## 137 0.8375228 0.700132100 15.597724
## 138 1.0000000 1.000000000 17.961423
## 139 1.0000000 0.000000000 12.977229
## 140 1.0000000 0.888888889 14.520500
## 141 1.0000000 0.000000000 16.259667
## 142 1.0000000 0.885456885 12.883910
## 143 1.0000000 0.111111111 19.170729
## 144 0.9873659 0.985714286 12.783980
## 145 1.0000000 1.000000000 15.715775
## 146 1.0000000 0.945054945 14.652852
## 147 0.9912568 0.432520325 14.721458
## 148 1.0000000 0.914861837 16.538225
## 149 1.0000000 0.936488169 16.163006
## 150 0.9992138 0.947945205 11.513433
## 151 1.0000000 0.682978723 12.192736
## 152 1.0000000 0.414035088 15.473813
## 153 1.0000000 0.998835178 14.478055
## 154 1.0000000 0.512152778 14.511310
## 155 1.0000000 0.486725664 15.149612
## 156 0.9748996 0.271961492 14.323842
## 157 1.0000000 0.867105657 15.269794
## 158 0.9892719 0.974550898 19.968472
## 159 1.0000000 1.000000000 13.168024
## 160 1.0000000 1.000000000 16.443296
## 161 1.0000000 0.795180723 16.618933
## 162 1.0000000 0.324626866 13.965939
## 163 1.0000000 0.848056537 13.365704
## 164 1.0000000 1.000000000 14.110102
## 165 0.9980434 0.000000000 17.849078
## 166 0.9271176 0.776547559 17.777528
## 167 1.0000000 0.685785536 17.856095
## 168 0.4778793 0.881411572 21.803641
## 169 0.9996307 0.935631019 15.405231
## 170 0.8320493 0.320454545 10.384836
## 171 1.0000000 0.000000000 14.200155
## 172 1.0000000 1.000000000 13.418843
## 173 1.0000000 0.578947368 14.753988
## 174 1.0000000 0.550000000 14.017123
## 175 1.0000000 0.857142857 16.446804
## 176 0.9862682 0.232142857 12.862680
## 177 1.0000000 0.273913043 13.303317
## 178 1.0000000 0.000000000 14.357528
## 179 1.0000000 0.484567901 13.609916
## 180 1.0000000 0.000000000 16.798119
## 181 1.0000000 0.696969697 14.287542
## 182 1.0000000 0.951330798 15.620286
## 183 0.9953344 0.782258065 16.585541
## 184 1.0000000 0.896551724 15.348034
## 185 1.0000000 0.525531915 18.120466
## 186 1.0000000 0.466458658 11.495555
## 187 0.9718121 0.210526316 19.559565
## 188 1.0000000 0.657407407 12.948392
## 189 0.9935118 0.087649402 14.254527
## 190 1.0000000 0.187928669 16.740800
## 191 1.0000000 0.769607843 11.515850
## 192 1.0000000 0.408163265 14.727326
## 193 1.0000000 0.289215686 14.615657
## 194 1.0000000 0.287072243 16.452506
## 195 1.0000000 1.000000000 15.223031
## 196 1.0000000 0.159793814 16.694201
## 197 1.0000000 0.845360825 17.792896
## 198 1.0000000 0.491048593 18.222030
## 199 1.0000000 0.019261637 16.917302
## 200 0.9869062 0.059575638 19.271804
## 201 0.9991837 0.013888889 17.715778
## 202 1.0000000 0.101851852 20.868638
## 203 1.0000000 0.875000000 16.226403
## 204 1.0000000 0.346050696 16.808816
## 205 0.9084733 0.000000000 14.537722
## 206 1.0000000 0.019748654 11.528550
## 207 0.9286675 0.867579909 15.840678
## 208 1.0000000 0.012987013 17.743898
## 209 0.9626973 0.737903226 17.254513
## 210 0.7891949 0.000000000 14.261080
## 211 1.0000000 1.000000000 19.857521
## 212 0.9577216 2.641546367 29.449111
## 213 1.0000000 0.093615855 20.143161
## 214 1.0000000 0.948333333 15.253314
## 215 0.9968819 1.000000000 16.702390
## 216 0.9917094 1.000000000 21.692668
## 217 1.0000000 0.942386831 16.798735
## 218 0.9349022 0.884848485 15.982176
## 219 1.0000000 0.742857143 14.287815
## 220 1.0000000 0.000000000 15.291215
## 221 1.0000000 1.000000000 16.747184
## 222 0.9993203 1.000000000 22.173806
## 223 0.9991590 0.983024691 16.429565
## 224 0.9765758 0.171021378 18.482189
## 225 0.6208083 0.410909091 18.110386
## 226 1.0000000 0.000000000 16.952752
## 228 1.0000000 0.326732673 12.296337
## 229 0.9946996 0.000000000 15.636447
## 231 1.0000000 1.000000000 28.383954
## 232 1.0000000 0.727272727 15.500176
## 234 1.0000000 1.000000000 16.029681
## 235 0.9724026 1.000000000 8.702656
## 237 1.0000000 1.000000000 13.822064
## 238 1.0000000 1.000000000 15.498371
## 239 0.9217590 1.000000000 12.633376
## 240 0.9543611 0.000000000 14.983945
## 241 1.0000000 0.000000000 13.062279
## 242 1.0000000 1.000000000 16.904220
## 244 1.0000000 0.750000000 17.797376
## 245 0.8116232 1.000000000 9.965158
## 246 1.0000000 0.000000000 12.919787
## 247 1.0000000 0.000000000 16.778739
## 248 1.0000000 0.000000000 14.732980
## 250 1.0000000 0.000000000 15.266751
## 251 0.8651079 0.000000000 17.992854
## 252 1.0000000 0.166666667 17.093622
## 253 1.0000000 0.000000000 18.998171
## 254 0.8646617 0.000000000 21.794173
## 255 1.0000000 0.250000000 16.021209
## 256 1.0000000 0.000000000 12.080829
## 257 0.9839504 0.257270694 22.808159
## 258 1.0000000 0.000000000 14.226708
## 259 0.9977894 1.000000000 17.367128
## 260 0.7899824 0.423076923 20.554546
## 261 1.0000000 0.576923077 14.337085
## 262 1.0000000 0.307692308 16.673205
## 263 1.0000000 0.562500000 18.347158
## 264 1.0000000 0.461538462 16.221313
## 265 1.0000000 0.730769231 20.606051
## 267 1.0000000 0.307692308 15.909838
## 268 0.9714286 0.192307692 14.912821
## 269 1.0000000 0.000000000 12.535251
## 271 1.0000000 0.653846154 12.719991
## 272 0.4218213 0.730769231 15.617151
## 273 0.5981703 0.750000000 14.720259
## 274 1.0000000 0.206896552 18.648726
## 275 1.0000000 0.972879621 10.184369
## 277 0.9809942 0.000000000 17.896147
## 278 0.9611345 0.000000000 15.187129
## 279 1.0000000 0.605769231 14.410058
## 280 1.0000000 0.809523810 15.925332
## 281 1.0000000 0.707364341 16.195997
## 282 1.0000000 0.000000000 21.291335
## 283 1.0000000 1.000000000 14.164799
## 284 1.0364497 1.000000000 15.660950
## 285 0.9462025 0.892326733 21.332648
## 286 1.0000000 0.000000000 18.389710
## 287 0.9850589 0.670299728 24.788101
## 288 0.9977864 0.947619048 23.566034
## 289 0.9581395 0.838768116 37.762611
## 290 1.0042735 0.900000000 16.632972
## 291 1.0000000 0.915485853 23.974721
## 292 0.9981927 0.992911153 17.927370
## 294 1.0000000 0.027777778 25.282309
## 295 1.0000000 0.729166667 25.099228
## 296 1.0000000 0.083333333 20.646164
## 297 1.0000000 0.841954023 22.799115
## 298 1.0000000 1.000000000 13.518533
## 299 1.0000000 0.000000000 12.078223
## 300 1.0000000 0.000000000 15.524782
## 303 0.9470199 1.000000000 13.150503
## 304 1.0000000 0.000000000 13.492121
## 305 0.9218808 0.953125000 13.731435
## 306 1.0000000 1.000000000 15.204244
## 307 1.0000000 0.000000000 7.224830
## 309 1.0000000 0.091743119 14.049777
## 310 0.8152310 0.759433962 12.422381
## 311 0.9992343 0.021978022 11.303653
## 312 1.0000000 0.114942529 6.530935
## 313 1.0000000 0.291666667 20.534873
## 315 1.0000000 0.000000000 8.450536
## 317 1.0000000 0.000000000 14.960444
## 318 1.0000000 0.791208791 13.007816
## 319 0.9837278 0.000000000 11.240322
## 320 0.9884393 0.500000000 12.657863
## 321 1.0000000 0.000000000 14.702814
## 322 0.9125683 0.500000000 6.155544
## 323 1.0000000 0.000000000 16.432814
## 326 1.0000000 0.021052632 16.103498
## 327 1.0000000 0.039387309 17.026605
## 328 1.0000000 0.011764706 15.727092
## 329 0.9982773 0.015306122 11.505232
## 330 0.9849624 0.049212598 17.465957
## 331 1.0000000 0.000000000 12.432489
## 332 0.9945474 0.003968254 10.010640
## 333 0.9860627 0.022088353 13.761583
## 334 1.0000000 0.000000000 9.081797
## 335 0.9434978 0.006833713 13.138339
## 336 1.0000000 0.092920354 20.718370
## 337 1.0000000 0.018264840 17.153493
## 339 1.0000000 0.020547945 15.527212
## 340 1.0000000 0.045197740 20.419420
## 341 0.8916256 0.050193050 21.610603
## 342 1.0000000 0.035947712 16.235021
## 343 0.9401358 1.000000000 19.395826
## 344 0.8769350 0.246406571 16.986976
## 345 0.9710775 0.478260870 20.932378
## 346 1.0000000 0.200000000 9.514808
## 347 1.0000000 0.000000000 13.243467
## 349 0.3225806 0.000000000 13.790237
## 351 1.0000000 0.000000000 5.294401
## 352 1.0000000 0.642857143 11.459902
## 353 1.0000000 0.000000000 13.655725
## 354 0.9464802 0.393805310 11.384083
## 356 1.0000000 0.666666667 2.627726
## 358 1.0000000 1.000000000 12.796026
## 359 1.0000000 0.000000000 7.767174
## 360 1.0000000 1.000000000 18.562687
## 362 0.8579235 1.000000000 10.983160
## 363 0.9488491 1.000000000 9.985647
## 366 0.9209536 0.934210526 10.760421
## 369 0.7291667 0.000000000 14.437157
## 371 1.0000000 0.000000000 9.951566
## 372 1.0000000 0.000000000 7.556926
## 373 0.6425249 0.000000000 24.652166
## 374 1.0000000 0.000000000 9.468166
## 375 1.0000000 0.000000000 11.316244
## 376 1.0000000 0.009722222 19.578254
## 377 1.0000000 0.000000000 11.242758
## 378 1.0000000 0.924042687 24.586205
## 380 0.9950249 0.000000000 34.292291
## Efisiensi.Produksi Tingkat.Kehilangan.Air Jam.Operasi.Pelayanan
## 3 0.2991328 0.56602679 13.958329
## 5 0.6275594 0.28965639 16.517808
## 6 0.2716223 0.19865674 22.038356
## 8 0.8764230 0.26113252 22.000000
## 9 0.3998631 0.38976636 23.000000
## 11 0.5320741 0.49779892 22.293151
## 12 0.8943662 0.78085113 14.666658
## 13 0.4928092 0.36016697 20.000000
## 14 0.9584747 0.78281001 12.000000
## 16 0.9946608 0.37431631 23.910000
## 17 0.4827711 0.29270732 11.854110
## 18 0.9218633 0.48380929 24.000000
## 19 0.1175419 0.10634574 8.000000
## 22 0.4864332 0.28260340 24.000000
## 23 1.0000000 0.47583596 23.041096
## 24 0.3091836 0.26931296 24.000000
## 25 0.6523337 0.36714337 18.000000
## 26 0.5391136 0.41291090 19.520548
## 27 0.6580579 0.23415826 22.500000
## 29 0.7346643 0.28457956 15.816438
## 31 0.9367953 0.28860912 20.000000
## 32 0.9221877 0.37138629 21.008219
## 33 0.6287433 0.29767763 21.000000
## 34 0.6131714 0.28586438 24.000000
## 35 0.9168255 0.27425419 23.204384
## 36 0.5636209 0.30485776 24.000000
## 38 0.6373234 0.31162062 21.367260
## 39 0.4388418 0.31329262 20.502000
## 40 0.4094982 0.28777069 20.939397
## 41 0.5965544 0.28177048 22.875260
## 42 0.3307363 0.36939650 16.884658
## 43 0.5037098 0.25061773 22.443836
## 44 0.6928873 0.44904146 22.742466
## 45 0.6131494 0.25030907 22.928767
## 46 0.7166985 0.61699601 23.868329
## 47 0.3509705 0.24459001 23.934247
## 48 0.9473940 0.29705762 22.630137
## 49 0.7704415 0.35623680 23.064110
## 50 0.5109878 0.38840356 15.514685
## 51 0.5562871 0.33018773 23.470630
## 52 0.8697526 0.40946359 19.318630
## 53 0.8941023 0.24667059 24.000000
## 54 0.5248533 0.42761512 19.217682
## 56 0.2675719 0.17003490 14.876712
## 57 0.3892614 0.19579260 21.744881
## 58 0.3255046 0.62803404 23.000000
## 59 0.1015755 0.70444680 5.260918
## 60 0.6880419 0.30220023 16.290411
## 61 0.4202899 0.47566318 20.501370
## 62 0.8515432 0.34655437 22.893151
## 63 0.7722377 0.39981471 16.057534
## 64 0.3442098 0.42961643 15.444740
## 65 0.2966011 0.39299985 21.668493
## 66 0.5974452 0.27492258 22.643699
## 70 0.9608835 0.52476501 21.000000
## 72 0.3516835 0.32439676 12.589863
## 73 0.2738285 0.23161664 14.784274
## 74 0.4357517 0.23233573 14.049315
## 75 0.3748816 0.32103253 18.195096
## 76 0.2858208 0.27226416 14.149068
## 77 0.2879002 0.15565280 12.425096
## 78 0.5389542 0.40899686 19.554247
## 79 0.5156890 0.43175410 20.898630
## 80 0.5602176 0.36810120 13.642466
## 81 0.2331483 0.18513080 7.000000
## 82 0.4385693 0.30453061 7.860274
## 85 0.5382503 0.43184665 11.972110
## 86 0.4137342 0.40595781 24.000000
## 88 0.3033711 0.31193690 10.249315
## 89 0.9181043 0.18384712 13.265753
## 90 0.2459377 0.18372594 6.336110
## 93 0.2122566 0.49586911 6.163644
## 94 0.2834465 0.21733081 17.670000
## 95 0.1113960 0.04431528 7.559452
## 96 0.5106050 0.31626515 16.232877
## 97 0.2228605 0.54482785 21.660274
## 98 0.5234485 0.21332742 22.912329
## 100 0.3107841 0.26098505 15.413699
## 103 0.4352266 0.20909465 19.791781
## 105 0.7911571 0.44460560 16.200000
## 106 0.9760301 0.43403771 24.000000
## 107 0.8811443 0.21649220 16.570548
## 108 0.4384963 0.30517468 20.038356
## 109 0.9879327 0.13904659 22.364384
## 110 0.2954597 0.23284137 21.665753
## 111 0.8788213 0.28792694 24.000000
## 112 0.8755187 0.25749769 22.972603
## 113 0.8005838 0.28358459 24.000000
## 114 0.5972057 0.23011924 23.638000
## 115 0.5358993 0.26480000 23.139726
## 116 0.9099536 0.27256899 23.539726
## 117 0.5756584 0.29260247 24.000000
## 118 0.9178485 0.42972303 23.411753
## 119 0.4449562 0.34015749 20.152630
## 120 0.6752192 0.27307260 24.000000
## 121 0.7782606 0.28281023 22.780000
## 122 0.5813200 0.20617546 22.160000
## 123 0.2986383 0.27112343 22.516658
## 124 0.7732048 0.22898931 23.668575
## 125 0.6602809 0.22562972 19.790000
## 126 0.5600884 0.32226096 22.830000
## 127 0.7203361 0.24524471 19.882192
## 128 0.7712507 0.27048649 24.000000
## 129 0.9892805 0.31652229 23.700000
## 130 0.4206388 0.44400909 22.145205
## 131 0.9116309 0.49494635 18.673973
## 132 0.9158207 0.27532995 18.739726
## 133 0.7759052 0.05897583 24.000000
## 134 0.7042335 0.29295744 24.000000
## 135 0.7745521 0.44401367 24.000000
## 136 0.7917377 0.22443319 22.240000
## 137 0.7284963 0.36391863 22.863014
## 138 0.8070081 0.25180962 24.000000
## 139 0.4168493 0.33269754 22.290411
## 140 0.4841283 0.30554200 21.560000
## 141 0.6788652 0.26947853 23.756164
## 142 0.4949122 0.26043773 23.813699
## 143 0.7192117 0.28670317 22.630000
## 144 0.5517365 0.26532611 19.285699
## 145 0.7446868 0.22287264 23.910000
## 146 0.6427384 0.29887375 24.000000
## 147 0.5612831 0.22289681 21.000000
## 148 0.9027685 0.29793399 22.319096
## 149 0.6463617 0.32199153 23.920000
## 150 0.5375877 0.30490161 18.189041
## 151 0.6124074 0.32303142 19.445644
## 152 0.7315378 0.29002351 19.800000
## 153 0.7077047 0.23037052 20.952740
## 154 0.6732139 0.21085365 23.723342
## 155 0.5904296 0.18792736 17.800000
## 156 0.8536428 0.34775025 22.400000
## 157 0.7953046 0.26774616 22.650000
## 158 0.8165959 0.17999178 23.409973
## 159 0.8143386 0.26711325 22.224658
## 160 0.8641657 0.19244584 24.000000
## 161 0.9326736 0.40652873 21.000000
## 162 0.4997380 0.22475726 23.000000
## 163 0.8046975 0.24318140 21.975342
## 164 0.6309835 0.28843716 21.860000
## 165 0.8191838 0.34812267 21.380000
## 166 0.8144368 0.43217674 20.339726
## 167 0.8081745 0.20599051 21.068493
## 168 0.8742203 0.38730575 19.986301
## 169 0.6603147 0.31746441 21.693151
## 170 0.4515623 0.46747475 21.000000
## 171 0.5305837 0.23294423 23.540000
## 172 0.7558223 0.25765455 24.000000
## 173 0.7084790 0.23894175 15.820000
## 174 0.5751005 0.25847336 23.190000
## 175 0.8011732 0.31327577 23.960000
## 176 0.5667899 0.23750660 13.893151
## 177 0.4972658 0.27355232 22.000000
## 178 0.2687092 0.27629084 23.400000
## 179 0.6275257 0.23503800 22.000000
## 180 0.3848909 0.37179550 18.000000
## 181 0.5300067 0.29062083 22.580822
## 182 0.8967267 0.20630742 21.630000
## 183 0.7380825 0.27559929 23.800000
## 184 0.9199851 0.23044146 23.671233
## 185 0.8264151 0.25232185 24.000000
## 186 0.7271057 0.17739037 23.173918
## 187 0.6107217 0.23443702 22.081479
## 188 0.2863087 0.27730220 20.477726
## 189 0.5023388 0.24545990 20.033288
## 190 0.9363835 0.25864662 24.000000
## 191 0.6640677 0.19934729 23.016438
## 192 0.4743109 0.35960914 23.000000
## 193 0.5196108 0.20391778 23.070000
## 194 0.5786977 0.18964005 24.000000
## 195 0.8686275 0.33466562 24.000000
## 196 0.5309415 0.42490157 24.000000
## 197 0.7374028 0.24899940 22.572603
## 198 0.8324649 0.21626316 24.000000
## 199 0.5456370 0.19744587 22.910000
## 200 0.7983136 0.20979305 24.000000
## 201 0.5444862 0.36535170 20.374932
## 202 0.5432643 0.25737390 16.643671
## 203 0.5286123 0.27824609 14.652000
## 204 0.3771909 0.34103786 20.317863
## 205 0.5698638 0.29318232 21.000000
## 206 0.5036378 0.58238953 19.736658
## 207 0.8762989 0.24169903 24.000000
## 208 0.7123971 0.44069335 24.000000
## 209 0.8044063 0.26177609 21.000000
## 210 0.7255137 0.47041239 20.000000
## 211 0.3764790 0.15414955 24.000000
## 212 1.0000000 0.31217575 23.849315
## 213 0.7220077 0.35576521 24.000000
## 214 0.7532414 0.25886003 18.147068
## 215 0.7304306 0.20085912 23.841096
## 216 0.9049863 0.38379640 22.640000
## 217 0.8516411 0.39867246 23.569863
## 218 0.5984124 0.21281859 22.695890
## 219 0.7112424 0.50433974 18.325397
## 220 0.8448253 0.21386823 17.148932
## 221 0.7114804 0.19265232 22.706904
## 222 0.9249068 0.39008577 21.900000
## 223 0.8336438 0.36021992 24.000000
## 224 0.5773613 0.23931230 21.465096
## 225 0.8234494 0.38373859 20.650000
## 226 0.7527916 0.10495866 20.330000
## 228 0.4274256 0.21423262 14.640000
## 229 0.7279708 0.59738964 16.491260
## 231 0.6036959 0.30704624 22.000000
## 232 0.4405255 0.23670480 19.000000
## 234 0.5372893 0.24994197 12.871233
## 235 0.2205238 0.31692661 3.521589
## 237 0.5618262 0.25817984 18.000000
## 238 0.3149726 0.22297702 13.000000
## 239 0.4506920 0.33558526 13.000000
## 240 0.8449834 0.34729178 3.000000
## 241 0.3941267 0.20423706 8.664877
## 242 0.5520632 0.20882228 21.892877
## 244 0.7783105 0.31012943 17.950685
## 245 0.2624588 0.23993937 8.414575
## 246 0.2965985 0.46480966 20.086932
## 247 0.6000000 0.26308014 23.698630
## 248 0.4239130 0.35298537 11.390000
## 250 0.3789575 0.42577709 16.920548
## 251 0.8138534 0.34456869 18.392192
## 252 0.2727908 0.32143049 13.421808
## 253 0.8139378 0.39436599 17.590932
## 254 0.7557156 0.27689972 23.030137
## 255 0.2825823 0.22103925 18.000000
## 256 0.6149788 0.34743368 22.047945
## 257 0.9214049 0.28253020 23.545205
## 258 0.3942099 0.36815140 20.684932
## 259 0.8319461 0.17982126 22.806192
## 260 0.5478358 0.28569279 21.839671
## 261 0.4462231 0.20646148 18.117041
## 262 0.5286550 0.26346920 18.120027
## 263 0.7500000 0.19836645 22.000000
## 264 0.4518781 0.28078601 20.676712
## 265 0.4800031 0.04583518 21.208219
## 267 0.3765066 0.21858770 20.501370
## 268 0.5798343 0.40163838 20.411753
## 269 0.4021419 0.32484938 12.239425
## 271 0.3813976 0.62049248 17.405479
## 272 0.5585141 0.33973129 23.520000
## 273 0.2804926 0.25573891 17.990000
## 274 0.5887281 0.34117550 21.013699
## 275 0.8500247 0.38201583 21.118493
## 277 0.3123869 0.26944900 16.800000
## 278 0.5572243 0.21543909 21.649315
## 279 0.6603012 0.31750003 21.121836
## 280 0.7794892 0.40670360 21.619178
## 281 0.4402784 0.27319024 20.219945
## 282 0.6587964 0.21112426 21.680000
## 283 0.3174998 0.31609677 18.000000
## 284 0.7405790 0.29717830 23.893397
## 285 0.8842516 0.33230536 19.262411
## 286 0.3877536 0.32687986 18.670932
## 287 0.7752423 0.30148852 23.440877
## 288 0.6529801 0.24552642 16.340329
## 289 0.8970532 0.15334186 21.775342
## 290 0.6119398 0.33480445 18.412055
## 291 0.9627993 0.38440485 22.962137
## 292 0.8958685 0.35223757 22.000000
## 294 0.6358152 0.19031893 24.000000
## 295 0.6230014 0.19770141 21.243534
## 296 0.5280797 0.22393280 21.000000
## 297 0.4540349 0.36705006 20.400000
## 298 0.5315103 0.46811527 21.115068
## 299 0.1680101 0.54314890 12.264603
## 300 0.7235444 0.51828729 21.928767
## 303 0.4632506 0.66168562 21.000000
## 304 0.4560606 0.28315414 16.109589
## 305 0.6014593 0.49063597 17.509589
## 306 0.6952924 0.45555465 19.649315
## 307 0.4083916 0.87863048 12.000000
## 309 0.6062834 0.42583258 22.257726
## 310 0.5306633 0.34857387 23.868493
## 311 0.4350161 0.29002984 19.900000
## 312 0.2132527 0.28880366 19.087452
## 313 0.8917619 0.24798364 22.073068
## 315 0.2419475 0.24396235 19.020000
## 317 0.5041212 0.30511093 23.012795
## 318 0.6172685 0.43933052 21.190000
## 319 0.5000000 0.18445078 24.000000
## 320 0.3550562 0.23748554 24.000000
## 321 0.5434962 0.46728657 19.440986
## 322 0.5017459 0.23634012 21.000000
## 323 0.2613146 0.27575390 18.920000
## 326 0.6780303 0.19799293 20.000000
## 327 0.8568742 0.25128549 23.621918
## 328 0.7754171 0.30687709 17.833342
## 329 0.7161458 0.22871408 21.400000
## 330 0.8411838 0.38365701 22.219178
## 331 0.2212768 0.23013898 16.366110
## 332 0.3492162 0.44178154 15.572603
## 333 0.4595177 0.28294183 17.509589
## 334 0.2318182 0.41295500 18.000000
## 335 0.5204754 0.32270044 18.000000
## 336 0.6230769 0.27336870 24.000000
## 337 0.3799999 0.22348403 22.500000
## 339 0.3119013 0.31477396 11.000000
## 340 0.5330814 0.33298411 23.250000
## 341 0.3114730 0.39118043 19.000000
## 342 0.4310831 0.31130713 18.897342
## 343 0.9245915 0.46742219 24.000000
## 344 0.4482255 0.36997718 19.770000
## 345 0.8854687 0.37514055 21.471233
## 346 0.5105295 0.51899376 14.226000
## 347 0.1045444 0.16588220 6.204384
## 349 0.2682423 0.53481337 10.000000
## 351 0.1502388 0.31482627 3.772192
## 352 0.6080791 0.35814924 19.296301
## 353 0.8528807 0.85009658 21.810959
## 354 0.5240724 0.56979056 12.580000
## 356 0.1068419 0.47494651 20.000000
## 358 0.4989265 0.19791502 23.693288
## 359 0.3076455 0.63480216 14.809342
## 360 0.6283092 0.12546793 21.773014
## 362 0.2181744 0.42885373 4.821918
## 363 0.3111221 0.22143618 17.416438
## 366 0.6514959 0.71165794 13.901370
## 369 0.4950088 0.18975663 17.646575
## 371 0.2060704 0.20876961 19.172411
## 372 0.4621800 0.69813101 15.419178
## 373 0.9254085 0.39399719 21.589041
## 374 0.5211549 0.28083482 18.579068
## 375 0.3995726 0.50973779 21.140000
## 376 0.7391304 0.42752304 2.980822
## 377 0.8664384 0.34076768 23.150000
## 378 0.8254640 0.43241213 12.894685
## 380 1.0000000 0.30556748 23.054795
## Tekanan.Air.pada.Sambungan.Pelanggan
## 3 0.000000000
## 5 0.000000000
## 6 0.936017351
## 8 0.370141108
## 9 0.134559253
## 11 0.675765400
## 12 0.000000000
## 13 0.496058728
## 14 0.000000000
## 16 0.214258810
## 17 0.422537382
## 18 0.000000000
## 19 0.690977850
## 22 0.000000000
## 23 0.040358293
## 24 0.894301994
## 25 0.194684529
## 26 0.828606937
## 27 0.919844822
## 29 0.418288620
## 31 0.572592593
## 32 0.000000000
## 33 0.716493608
## 34 0.900047326
## 35 0.091430565
## 36 0.712567946
## 38 0.000000000
## 39 0.000000000
## 40 0.992100066
## 41 0.646935395
## 42 0.327842490
## 43 0.999608702
## 44 0.913635839
## 45 0.647831210
## 46 0.008864028
## 47 0.120302942
## 48 0.124069079
## 49 0.006984084
## 50 0.898424274
## 51 0.865137383
## 52 0.000000000
## 53 0.196383388
## 54 0.000000000
## 56 1.000000000
## 57 0.313234851
## 58 0.328879913
## 59 0.178051512
## 60 0.000000000
## 61 0.770654552
## 62 0.000000000
## 63 0.487967914
## 64 0.719411634
## 65 0.565323939
## 66 0.904702880
## 70 0.743512889
## 72 0.709173117
## 73 0.520614239
## 74 0.294262065
## 75 0.711978575
## 76 0.000000000
## 77 0.838580658
## 78 0.811144031
## 79 0.214684573
## 80 0.423256803
## 81 0.792490119
## 82 0.803764694
## 85 0.000000000
## 86 1.000000000
## 88 0.823417239
## 89 0.685072941
## 90 0.000000000
## 93 0.281159420
## 94 1.000000000
## 95 0.000000000
## 96 0.000000000
## 97 0.963036963
## 98 0.468857470
## 100 0.848743138
## 103 0.808695652
## 105 0.832175953
## 106 0.467360855
## 107 0.681635887
## 108 0.679161927
## 109 0.676028215
## 110 0.527869811
## 111 0.899474348
## 112 0.986364990
## 113 0.813075181
## 114 0.974883411
## 115 0.800208184
## 116 0.985102076
## 117 0.646341947
## 118 0.405231453
## 119 0.938610117
## 120 0.922448562
## 121 0.752756988
## 122 0.944334324
## 123 0.952799671
## 124 0.316528310
## 125 0.627604681
## 126 0.735956482
## 127 0.610625560
## 128 1.000000000
## 129 0.832249357
## 130 0.819407758
## 131 0.232070574
## 132 0.501905605
## 133 0.677361796
## 134 0.969831514
## 135 0.067988107
## 136 0.962898816
## 137 0.848788936
## 138 0.056037495
## 139 0.751988185
## 140 0.848586092
## 141 0.798419496
## 142 0.983652750
## 143 0.550077726
## 144 0.468434107
## 145 0.874692304
## 146 0.376620838
## 147 0.954329726
## 148 0.630072948
## 149 0.874183188
## 150 0.620137374
## 151 0.780039320
## 152 0.465142465
## 153 0.104751038
## 154 0.978719069
## 155 0.643433759
## 156 0.000000000
## 157 0.976878733
## 158 0.899556761
## 159 0.851195399
## 160 0.660893286
## 161 0.166666667
## 162 0.511443879
## 163 0.990312792
## 164 0.338284786
## 165 0.416525923
## 166 0.219513852
## 167 0.204438423
## 168 0.657386238
## 169 0.019114356
## 170 0.383402726
## 171 0.904524870
## 172 0.810000644
## 173 0.929293782
## 174 0.957579972
## 175 0.222439297
## 176 0.642795389
## 177 0.700009646
## 178 0.988542655
## 179 0.961696538
## 180 0.850007045
## 181 0.935131146
## 182 0.855998063
## 183 0.756334043
## 184 0.834165615
## 185 0.995794409
## 186 0.997277532
## 187 0.718978364
## 188 0.819830360
## 189 0.672291583
## 190 0.498500168
## 191 0.875573819
## 192 0.747613574
## 193 0.800061750
## 194 0.928297756
## 195 1.000000000
## 196 0.345041881
## 197 0.779834836
## 198 0.875494863
## 199 0.667807577
## 200 0.476339173
## 201 0.511836623
## 202 0.943703704
## 203 0.838983051
## 204 0.987952738
## 205 0.982226906
## 206 0.917305236
## 207 0.945223534
## 208 0.685178470
## 209 0.126650485
## 210 0.367142306
## 211 0.718997731
## 212 0.198395750
## 213 0.141393899
## 214 0.888838060
## 215 0.724551632
## 216 0.926845263
## 217 0.751101809
## 218 0.721316480
## 219 0.942879900
## 220 0.602225197
## 221 0.981842688
## 222 0.990403590
## 223 0.828961175
## 224 0.246594059
## 225 0.615825002
## 226 0.858974975
## 228 0.265964190
## 229 0.555220278
## 231 0.268903948
## 232 0.254316320
## 234 0.500575043
## 235 0.099827883
## 237 0.000000000
## 238 0.299129442
## 239 0.168941084
## 240 0.682210860
## 241 0.148251150
## 242 0.226469341
## 244 0.211100099
## 245 0.423350454
## 246 0.000000000
## 247 0.987223997
## 248 0.000000000
## 250 0.000000000
## 251 0.000000000
## 252 0.625591017
## 253 0.000000000
## 254 0.934838612
## 255 0.202546296
## 256 0.509561372
## 257 0.628801513
## 258 0.485129205
## 259 0.496654586
## 260 0.002720017
## 261 0.209034544
## 262 0.000254539
## 263 0.405405405
## 264 0.000000000
## 265 0.277702151
## 267 0.325544238
## 268 0.000000000
## 269 0.822506862
## 271 0.353301127
## 272 0.183724548
## 273 0.775208860
## 274 0.233080626
## 275 0.397272609
## 277 0.859257938
## 278 0.534163306
## 279 0.602813128
## 280 0.253546981
## 281 0.501312086
## 282 0.000000000
## 283 2.042881209
## 284 0.174324262
## 285 0.674599955
## 286 0.613973638
## 287 0.000000000
## 288 0.859782303
## 289 0.034774533
## 290 0.533692032
## 291 0.981136180
## 292 0.908521054
## 294 0.903896895
## 295 0.544229591
## 296 0.706622973
## 297 0.908309456
## 298 1.000000000
## 299 0.203896943
## 300 1.000000000
## 303 0.950000000
## 304 0.904524887
## 305 0.846612436
## 306 0.935365854
## 307 1.000000000
## 309 0.781491907
## 310 0.016649246
## 311 0.000074500
## 312 0.793448590
## 313 0.610180863
## 315 0.000000000
## 317 0.548948300
## 318 0.358458961
## 319 0.814653540
## 320 0.320549631
## 321 0.002361378
## 322 0.000000000
## 323 0.000000000
## 326 0.066617765
## 327 0.000000000
## 328 0.609411979
## 329 0.282819166
## 330 0.458620490
## 331 0.000000000
## 332 0.766111111
## 333 0.037509326
## 334 0.739488386
## 335 0.000196002
## 336 0.080073270
## 337 0.816455696
## 339 0.077586207
## 340 0.000000000
## 341 0.961062953
## 342 0.000000000
## 343 0.499944778
## 344 0.850009907
## 345 0.644192580
## 346 0.000000000
## 347 0.612000854
## 349 0.000000000
## 351 0.000000000
## 352 0.983472559
## 353 0.000000000
## 354 0.894365754
## 356 1.000000000
## 358 0.397153946
## 359 0.000000000
## 360 0.815226064
## 362 0.138005683
## 363 0.975120303
## 366 0.257307982
## 369 0.000000000
## 371 0.360332230
## 372 0.000000000
## 373 0.000000000
## 374 1.000000000
## 375 0.000000000
## 376 0.600109310
## 377 0.476858345
## 378 0.434643647
## 380 0.000000000
## Penggantian.Kalibrasi.Meter.Air.Pelanggan Rasio.Pegawai
## 3 0.010486177 4.357892
## 5 0.042197911 6.416057
## 6 0.054222584 7.184492
## 8 0.010949148 3.627529
## 9 0.014302393 6.275540
## 11 0.029066765 8.373294
## 12 0.017418490 12.058955
## 13 0.042481497 6.077381
## 14 0.016326531 9.912536
## 16 0.054427890 4.310706
## 17 0.166486820 9.403422
## 18 0.042266441 7.267852
## 19 0.016747704 21.069692
## 22 0.001172608 18.527204
## 23 0.017310789 6.441224
## 24 0.048860399 12.250712
## 25 0.014098963 7.886776
## 26 0.031437126 7.004858
## 27 0.022381379 9.489705
## 29 0.028186919 7.013852
## 31 0.156094276 7.542088
## 32 0.003613859 12.061255
## 33 0.040633815 5.626913
## 34 0.019876952 7.288216
## 35 0.012359032 3.591549
## 36 0.071487399 11.612584
## 38 0.008000700 5.508678
## 39 0.010334742 6.239844
## 40 0.017774852 6.959466
## 41 0.042186637 4.307013
## 42 0.013603964 5.867524
## 43 0.017764908 5.634685
## 44 0.010045029 4.733864
## 45 0.017002413 5.274676
## 46 0.051635112 5.765921
## 47 0.000000000 5.437421
## 48 0.115091985 2.556258
## 49 0.039419784 5.170909
## 50 0.015627035 5.729913
## 51 0.038442148 4.663474
## 52 0.081887858 6.050827
## 53 0.021962822 2.462805
## 54 0.007595321 8.506760
## 56 0.023387905 10.802985
## 57 0.075972264 9.571902
## 58 0.009709492 8.777381
## 59 0.063829787 36.954087
## 60 0.014665445 8.249313
## 61 0.065286892 8.918055
## 62 0.019159127 4.434983
## 63 0.107199445 7.080610
## 64 0.011811901 8.468910
## 65 0.018839026 6.586001
## 66 0.026394459 8.166241
## 70 0.020125032 6.251606
## 72 0.070043682 6.973714
## 73 0.102838530 7.259190
## 74 0.043700898 5.892256
## 75 0.003976627 11.686415
## 76 0.000985950 7.517870
## 77 0.008101733 6.768537
## 78 0.034693683 6.690242
## 79 0.025913952 4.395661
## 80 0.000000000 14.030612
## 81 0.158596838 7.534585
## 82 0.032831029 7.793486
## 85 0.009997667 8.164762
## 86 0.175397568 17.773620
## 88 0.154748284 9.916095
## 89 0.065248595 2.185020
## 90 0.006903928 6.417736
## 93 0.004140787 12.008282
## 94 0.225882911 8.058782
## 95 0.033913841 13.748854
## 96 0.000000000 8.380724
## 97 0.035564436 9.190809
## 98 0.000000000 5.961024
## 100 0.027882115 12.713089
## 103 0.032898551 5.797101
## 105 0.136065224 6.825777
## 106 0.078684749 2.875461
## 107 0.025746398 4.258058
## 108 0.006190312 4.814687
## 109 0.237926965 2.785821
## 110 0.006951212 5.846813
## 111 0.010029437 4.857023
## 112 0.017505210 3.512950
## 113 0.250991960 4.459494
## 114 0.002909172 3.997335
## 115 0.201678485 8.696029
## 116 0.153284222 3.441934
## 117 0.047954978 8.124604
## 118 0.075242218 6.390435
## 119 0.200310664 5.808064
## 120 0.050015355 3.848910
## 121 0.017665882 8.330468
## 122 0.011562603 6.524612
## 123 0.236766263 17.086225
## 124 0.036585155 4.185369
## 125 0.005643019 4.567112
## 126 0.011314597 8.159565
## 127 0.016388972 4.934873
## 128 0.018824768 3.422293
## 129 0.062018959 2.636700
## 130 0.129987488 7.182909
## 131 0.205119263 5.088389
## 132 0.052063838 3.402865
## 133 0.093952764 7.169738
## 134 0.238746873 4.439953
## 135 0.026560951 9.316155
## 136 0.025138248 2.758774
## 137 0.007169600 3.196394
## 138 0.024668010 3.494635
## 139 0.022722109 7.725517
## 140 0.156649330 3.547687
## 141 0.105116772 5.165335
## 142 0.027716867 3.091834
## 143 0.137446830 2.835716
## 144 0.017424290 4.293545
## 145 0.037782732 4.180020
## 146 0.054896722 3.811820
## 147 0.008217395 7.674993
## 148 0.020600021 5.034419
## 149 0.235890701 3.908042
## 150 0.252514730 10.351899
## 151 0.039782584 7.401411
## 152 0.027905610 4.944678
## 153 0.066463820 5.673354
## 154 0.057322678 3.078943
## 155 0.016081026 2.890730
## 156 0.002267119 3.872159
## 157 0.021352313 3.308984
## 158 0.231961634 2.543173
## 159 0.021172369 3.219116
## 160 0.111368508 3.961982
## 161 0.016388256 4.998734
## 162 0.005887587 2.726085
## 163 0.069887955 3.478058
## 164 0.025269815 4.816061
## 165 0.127178866 5.226092
## 166 0.064802704 5.758353
## 167 0.209954197 4.451326
## 168 0.077407824 2.651827
## 169 0.060131342 3.632095
## 170 0.017045657 4.554998
## 171 0.021782252 4.603466
## 172 0.016710670 3.831541
## 173 0.043639818 3.694711
## 174 0.018631201 6.548447
## 175 0.058362018 7.628617
## 176 0.015321806 4.803074
## 177 0.071283882 4.871226
## 178 0.001313581 5.838138
## 179 0.013940087 6.567518
## 180 0.037339721 7.538397
## 181 0.040316630 6.976588
## 182 0.019858594 4.140337
## 183 0.018787551 5.531360
## 184 0.255967733 3.923613
## 185 0.094760013 2.183328
## 186 0.233705226 6.726098
## 187 0.019092993 3.259779
## 188 0.133031101 9.505703
## 189 0.039629480 4.470399
## 190 0.044973003 3.972725
## 191 0.028061602 4.479491
## 192 0.087310710 3.548403
## 193 0.100741002 4.895907
## 194 0.200278649 3.308952
## 195 0.045322759 2.842443
## 196 0.000081100 8.186976
## 197 0.051870243 3.481406
## 198 0.021373089 2.781258
## 199 0.018614029 7.079895
## 200 0.031823707 3.070249
## 201 0.227895050 7.830029
## 202 0.178240741 10.462963
## 203 0.002388290 10.015408
## 204 0.045022782 5.096919
## 205 0.076712329 7.235687
## 206 0.004629630 7.822478
## 207 0.036971343 2.155584
## 208 0.027974926 4.248044
## 209 0.285679612 5.000000
## 210 0.009641342 7.134593
## 211 0.186638118 3.237236
## 212 0.067500502 1.931075
## 213 0.014844504 5.937802
## 214 0.056267155 6.945022
## 215 0.255044136 6.410256
## 216 0.062299428 4.702107
## 217 0.100209301 3.828679
## 218 0.022989559 4.121634
## 219 0.024350003 5.859931
## 220 0.030701021 4.573086
## 221 0.118532781 4.563397
## 222 0.085545480 3.476790
## 223 0.097616127 1.950845
## 224 0.094917438 6.011633
## 225 0.021362044 5.767752
## 226 0.012536625 8.405783
## 228 0.021549675 7.843448
## 229 0.013518407 7.483404
## 231 0.081639238 5.915887
## 232 0.052005881 9.535812
## 234 0.335537665 9.775733
## 235 0.013080895 14.113597
## 237 0.016808658 7.828690
## 238 0.103753389 8.277437
## 239 0.083519223 6.232778
## 240 0.006787729 5.818054
## 241 0.013584341 7.701358
## 242 0.027996418 6.174294
## 244 0.007763462 11.562603
## 245 0.052548400 5.630186
## 246 0.024296844 9.639509
## 247 0.031106791 7.498958
## 248 0.000187899 5.449079
## 250 0.027747111 4.710385
## 251 0.014578994 7.041555
## 252 0.099734043 9.604019
## 253 0.042172817 8.327603
## 254 0.035156842 5.303834
## 255 0.067129630 9.548611
## 256 0.008067408 5.916099
## 257 0.151767552 2.494580
## 258 0.054607509 5.302292
## 259 0.037171267 3.624198
## 260 0.022798039 4.867399
## 261 0.069425113 6.706314
## 262 0.001696929 10.351264
## 263 0.017069701 8.819346
## 264 0.000000000 9.318579
## 265 0.005989654 6.261911
## 267 0.000000000 6.990214
## 268 0.050855628 7.712702
## 269 0.018298262 9.332113
## 271 0.012882448 14.492754
## 272 0.064668876 6.020429
## 273 0.013600155 8.937245
## 274 0.032593658 5.423054
## 275 0.059891236 2.701326
## 277 0.101082174 5.529790
## 278 0.129054883 4.617453
## 279 0.056140778 4.688547
## 280 0.036406746 4.244904
## 281 0.059019991 5.343766
## 282 0.090069183 5.298187
## 283 0.022206340 4.032876
## 284 0.198590163 2.076992
## 285 0.032319135 2.839757
## 286 0.011890497 15.577473
## 287 0.010107694 5.151161
## 288 0.101056352 7.832269
## 289 0.032813951 5.262615
## 290 0.051242634 6.149116
## 291 0.039909648 5.042296
## 292 0.265989413 3.950092
## 294 0.109498681 4.262229
## 295 0.021349199 6.387260
## 296 0.257847534 6.209038
## 297 0.067621777 4.966571
## 298 0.061893660 9.626231
## 299 0.122633669 18.745960
## 300 0.055103647 17.755620
## 303 0.007729303 20.096187
## 304 0.000000000 11.312217
## 305 0.129875195 7.521729
## 306 0.039372822 14.634146
## 307 0.043459365 14.776184
## 309 0.018179686 9.734928
## 310 0.017470509 9.556518
## 311 0.032486402 9.537292
## 312 0.091628753 7.279345
## 313 0.008168028 7.853873
## 315 0.000000000 7.542038
## 317 0.010811873 8.452919
## 318 0.014694686 5.900716
## 319 0.007131137 3.912659
## 320 0.001640689 4.922067
## 321 0.000000000 7.871261
## 322 0.013458573 7.430254
## 323 0.000000000 8.119767
## 326 0.005601494 8.268872
## 327 0.018375597 6.615215
## 328 0.024060926 6.766187
## 329 0.006563833 6.727929
## 330 0.031968495 7.702554
## 331 0.019752296 8.221226
## 332 0.026333333 7.222222
## 333 0.007664654 18.381605
## 334 0.017445849 8.036852
## 335 0.010714752 6.141382
## 336 0.008766191 7.850321
## 337 0.015312372 6.533279
## 339 0.025287356 12.260536
## 340 0.006177728 8.078568
## 341 0.322438539 7.673725
## 342 0.062713020 11.701886
## 343 0.049013852 4.789779
## 344 0.036506836 5.399247
## 345 0.081307114 8.524654
## 346 0.005718685 7.918179
## 347 0.032671365 10.249840
## 349 0.008044243 18.267136
## 351 0.078212291 7.592036
## 352 0.009790712 12.395581
## 353 0.022494888 16.359918
## 354 0.114699402 23.103557
## 356 0.011054676 17.926501
## 358 0.234740680 4.939433
## 359 0.025414365 11.878453
## 360 0.166356383 7.513298
## 362 0.013259370 7.982682
## 363 0.002047712 9.624245
## 366 0.009883575 6.700729
## 369 0.057098548 6.485267
## 371 0.014675576 5.682883
## 372 0.000000000 7.475283
## 373 0.035973911 7.065697
## 374 0.014528771 10.131906
## 375 0.516889924 6.406523
## 376 0.059938058 7.469484
## 377 0.052594670 4.382889
## 378 0.003405221 5.914332
## 380 0.060316662 6.785625
## Ratio.Diklat.Pegawai Ratio.Biaya.Diklat Tarif.rata.rata..Rp.m3.
## 3 0.25000000 0.047982238 3594.411
## 5 0.10256410 0.002912905 4003.767
## 6 0.84905660 0.011609973 4845.994
## 8 0.11009174 0.030310514 4206.678
## 9 0.90697674 0.044729926 5112.668
## 11 0.19823789 0.000304636 4988.436
## 12 0.12962963 0.018085778 1697.817
## 13 0.50495049 0.006703414 4233.298
## 14 0.09803922 0.007646886 2719.651
## 16 0.20873786 0.006943426 4760.771
## 17 0.98360656 0.102259660 3226.177
## 18 0.47572815 0.007159751 4116.285
## 19 0.07692308 0.010696155 5338.081
## 22 0.26582279 0.059657477 1413.568
## 23 0.07812500 0.017484939 3083.917
## 24 0.15116279 0.002808362 4971.279
## 25 0.02054795 0.002104641 4670.849
## 26 0.05241936 0.009472448 3789.245
## 27 0.29559748 0.004649982 2874.626
## 29 1.00000000 0.009542039 3530.956
## 31 0.14285714 0.007008808 2508.692
## 32 0.07116105 0.006212549 3154.799
## 33 0.90933333 0.008323337 4085.220
## 34 0.15584416 0.001164083 4378.783
## 35 0.90800000 0.013020210 4576.917
## 36 0.26950355 0.006117069 3885.602
## 38 0.01587302 0.001837454 2877.855
## 39 0.72916667 0.005502731 2575.693
## 40 0.17567568 0.013679290 3959.015
## 41 0.43589744 0.013640196 3743.077
## 42 0.57777778 0.008382655 4332.626
## 43 0.05555556 0.004592665 3750.225
## 44 0.31707317 0.043912752 2087.537
## 45 0.02127660 0.003702466 3172.567
## 46 0.07462687 0.005260967 2391.435
## 47 0.33928571 0.018750918 3750.122
## 48 0.64566929 0.039471172 4463.947
## 49 0.03896104 0.001820922 2412.557
## 50 0.04545454 0.001924727 3912.332
## 51 0.86486487 0.012941301 2958.108
## 52 0.21666667 0.021092846 3324.505
## 53 0.15068493 0.032877696 3638.558
## 54 0.07142857 0.019936650 4046.451
## 56 0.43298969 0.004430196 5771.856
## 57 0.12598425 0.015585725 5335.120
## 58 0.14159292 0.013599101 7636.561
## 59 0.09090909 0.005986554 9726.334
## 60 0.36507936 0.001733331 4835.766
## 61 0.03773585 0.008386502 3023.235
## 62 0.12000000 0.011279040 1826.652
## 63 1.00000000 0.000019000 6368.758
## 64 0.73684211 0.053230330 4154.328
## 65 0.93023256 0.008038220 2393.746
## 66 0.28571429 0.030182819 4297.166
## 70 0.20091324 0.018451216 6556.421
## 72 0.93406593 0.034792817 5627.325
## 73 0.66666667 0.049770847 4956.590
## 74 0.48809524 0.006786494 4921.063
## 75 0.09722222 0.003461643 6674.546
## 76 0.03278689 0.008781573 3142.379
## 77 0.15151515 0.013153640 4703.136
## 78 0.61428571 0.026143942 3470.122
## 79 0.56686046 0.007574431 5421.624
## 80 0.05555556 0.005035321 4983.302
## 81 0.04918033 0.001567910 2936.234
## 82 0.10963455 0.059955004 5297.915
## 85 0.08571429 0.012116340 5349.643
## 86 0.78947368 0.014459766 4438.439
## 88 0.07692308 0.005259007 3325.907
## 89 0.30569106 0.018665609 3956.318
## 90 0.13636364 0.006752802 8396.028
## 93 0.24137931 0.007940857 6283.401
## 94 0.85294118 0.040771277 7227.262
## 95 0.33333333 0.021875245 3857.694
## 96 0.17857143 0.009072400 4095.281
## 97 0.56521739 0.015411663 9495.980
## 98 0.03846154 0.001622435 1697.913
## 100 0.45454545 0.002019841 7259.613
## 103 0.20000000 0.010410531 5081.957
## 105 0.45138889 0.008820438 5271.316
## 106 1.00000000 0.025391888 8230.638
## 107 0.13953488 0.024941513 4014.983
## 108 0.14285714 0.012193135 6263.989
## 109 0.81280788 0.013149117 3566.309
## 110 0.82777778 0.019438193 5202.619
## 111 0.21212121 0.007450267 6419.293
## 112 0.89830508 0.030442195 5367.114
## 113 0.91459627 0.021270079 8486.747
## 114 0.51666667 0.004871917 8573.811
## 115 0.83541147 0.001786376 6206.919
## 116 0.86268657 0.025841371 5343.235
## 117 0.60487805 0.009457739 3647.947
## 118 0.31541219 0.007490120 7180.422
## 119 0.29651163 0.011671762 4815.059
## 120 0.75531915 0.004523372 4237.558
## 121 0.20634921 0.010517779 7376.102
## 122 0.15822785 0.003416595 3619.435
## 123 0.83820998 0.050010818 7483.399
## 124 0.57142857 0.017115712 5153.876
## 125 0.86538461 0.009798809 5224.235
## 126 0.07111111 0.002295648 6022.818
## 127 0.34736842 0.002686850 4506.779
## 128 0.18915511 0.003001911 8236.040
## 129 0.80952381 0.040895547 5834.720
## 130 0.38064516 0.026354486 6283.120
## 131 0.77528090 0.015686563 6122.856
## 132 0.40500000 0.009263571 4017.605
## 133 0.26696833 0.010305115 5933.013
## 134 0.93283582 0.051699608 8720.199
## 135 0.02127660 0.000549569 5088.789
## 136 1.00000000 0.017256318 6619.327
## 137 0.63745020 0.037826165 3803.422
## 138 0.19411765 0.008704842 2666.603
## 139 0.38235294 0.004005110 4945.349
## 140 1.00000000 0.042803368 4190.842
## 141 0.93162393 0.023595282 4280.360
## 142 0.52127660 0.007323482 3626.750
## 143 0.81927711 0.016716364 2272.427
## 144 0.56796117 0.007161842 5751.251
## 145 1.00000000 0.068937008 3962.489
## 146 0.46153846 0.032279016 5543.760
## 147 0.15901060 0.006939910 5312.756
## 148 0.06122449 0.014641589 3326.016
## 149 0.78947368 0.007910733 4815.014
## 150 0.84276730 0.015331953 4925.698
## 151 0.92187500 0.008797996 5333.735
## 152 0.32673267 0.015307023 4044.060
## 153 0.08379888 0.003691539 5440.342
## 154 0.44852941 0.006505599 5517.185
## 155 1.00000000 0.018360748 3080.179
## 156 0.39378238 0.012052080 4175.600
## 157 0.44654088 0.032508323 4089.514
## 158 0.05714286 0.006850573 1707.652
## 159 0.37549407 0.051119891 5369.137
## 160 0.98907104 0.012794068 4786.448
## 161 0.22784810 0.010187294 4287.686
## 162 0.40277778 0.024020485 4340.176
## 163 0.40939597 0.014187578 5951.633
## 164 1.00000000 0.027419429 5308.248
## 165 1.00000000 0.025582213 3641.644
## 166 0.11209439 0.010612887 4906.580
## 167 1.00000000 0.020228168 4660.269
## 168 0.26695842 0.004681152 3869.790
## 169 0.35353535 0.009011666 4411.861
## 170 0.42968750 0.007918767 6800.794
## 171 0.91056911 0.039882291 3951.048
## 172 0.88235294 0.009978916 5889.630
## 173 0.95428571 0.015308912 5353.007
## 174 0.38938053 0.065678181 5294.382
## 175 1.00000000 0.005106479 5680.910
## 176 0.78000000 0.012563165 4632.888
## 177 1.00000000 0.015652904 3443.212
## 178 0.30000000 0.015611993 3272.268
## 179 0.34838710 0.021693924 3611.575
## 180 0.84112149 0.026469549 4538.348
## 181 0.50961539 0.021803437 3384.095
## 182 0.87096774 0.016411302 2980.712
## 183 0.10344828 0.013491321 2976.971
## 184 0.65034965 0.007364762 4375.181
## 185 1.00000000 0.030083275 3294.524
## 186 0.69841270 0.013576632 5562.962
## 187 0.90109890 0.005360174 2605.743
## 188 0.27179487 0.001236354 4497.747
## 189 0.10810811 0.009975454 4577.817
## 190 0.66850829 0.000000000 6876.817
## 191 0.38842975 0.009031099 5472.045
## 192 2.21126761 0.035821761 3935.022
## 193 0.12612613 0.010217087 3074.163
## 194 1.00000000 0.057146433 3498.286
## 195 0.18000000 0.023601505 3154.699
## 196 0.09900990 0.003797369 2665.803
## 197 0.48062015 0.014797772 3735.308
## 198 0.93693694 0.018915839 3666.031
## 199 0.31788079 0.004644619 5155.994
## 200 0.27303754 0.008287380 5584.909
## 201 0.80116959 0.023937209 3974.489
## 202 0.66371681 0.025980256 4262.541
## 203 0.23846154 0.007074766 5945.397
## 204 0.37878788 0.018566791 4028.966
## 205 0.14563107 0.008657159 3976.094
## 206 0.06122449 0.004483497 3006.284
## 207 0.40571429 0.005576969 5768.289
## 208 0.60975610 0.003834504 3459.486
## 209 0.59223301 0.026271138 4222.569
## 210 0.51351351 0.007695026 3484.981
## 211 1.00000000 0.014251802 3667.475
## 212 0.89226519 0.035743267 2976.478
## 213 0.27500000 0.011465932 2590.481
## 214 0.37125748 0.024089303 4555.240
## 215 0.36885246 0.018311154 4620.998
## 216 0.85163205 0.033720297 8674.594
## 217 0.48888889 0.018337808 5254.796
## 218 0.08148148 0.009096380 3332.822
## 219 0.18446602 0.011567437 6226.592
## 220 0.28048780 0.016562931 3675.937
## 221 1.00000000 0.064725237 4658.608
## 222 0.99324324 0.065648494 5348.277
## 223 0.81060606 0.023451609 3632.511
## 224 0.17532468 0.026553926 2336.937
## 225 0.03703704 0.009265249 2771.943
## 226 0.03428571 0.005244528 2856.640
## 228 0.31313131 0.013933089 3142.771
## 229 0.03225807 0.007071895 3416.708
## 231 0.85454546 0.014889644 3261.750
## 232 0.28634361 0.002772676 7777.450
## 234 0.08823529 0.021757797 3543.252
## 235 0.82926829 0.013621038 6557.270
## 237 0.67647059 0.019404077 3022.372
## 238 0.84482759 0.034573165 5009.676
## 239 0.64210526 0.010751546 4851.387
## 240 0.04545454 0.002758774 4239.326
## 241 0.25000000 0.024850679 5440.938
## 242 0.54198473 0.009638126 3277.399
## 244 0.14285714 0.024236337 3467.905
## 245 1.00000000 0.028987387 7652.911
## 246 0.12328767 0.016924870 6641.475
## 247 0.16666667 0.015293726 3545.640
## 248 0.06896552 0.007299742 1898.520
## 250 0.04687500 0.009276694 3805.477
## 251 0.36619718 0.007787629 4081.121
## 252 0.56923077 0.061165805 7987.998
## 253 0.01834862 0.001670273 3580.118
## 254 1.00000000 0.114885917 4190.996
## 255 0.24242424 0.022395119 5712.397
## 256 0.37373737 0.015043278 6356.459
## 257 0.23489933 0.012952336 4673.255
## 258 0.40229885 0.019810474 6914.934
## 259 0.16666667 0.041973180 4150.525
## 260 0.02205882 0.002612968 4371.185
## 261 0.15094340 0.007161995 4939.794
## 262 0.10655738 0.009523460 3988.872
## 263 0.24193548 0.002982900 5786.045
## 264 0.31250000 0.010997296 2909.172
## 265 0.39130435 0.010358815 3925.732
## 267 0.37142857 0.030576674 4074.874
## 268 0.15625000 0.043736539 5354.289
## 269 0.15686274 0.023323227 6614.042
## 271 0.04444444 0.004805643 3770.424
## 272 0.06741573 0.014326738 7359.302
## 273 0.21739130 0.010939636 3951.314
## 274 0.42857143 0.036370861 3821.776
## 275 0.85526316 0.018265599 8336.417
## 277 0.48387097 0.014368494 4336.192
## 278 0.36708861 0.004540019 4521.923
## 279 0.62337662 0.015182363 4295.956
## 280 0.16216216 0.007011105 5054.383
## 281 0.42857143 0.025607678 4656.539
## 282 0.08264463 0.010544942 4439.247
## 283 0.56962025 0.014573697 4554.893
## 284 0.82093664 0.024634001 8437.450
## 285 0.55555556 0.018658226 6053.996
## 286 0.00591716 0.004197602 7612.268
## 287 0.04030227 0.005257640 4526.970
## 288 1.60512820 0.111622420 7844.519
## 289 0.78431372 0.031569182 4726.720
## 290 0.29166667 0.018922530 3850.862
## 291 0.39974619 0.011431264 6539.395
## 292 0.20151134 0.005636163 9797.340
## 294 0.52380952 0.026888128 4021.769
## 295 0.35616438 0.011146974 5599.760
## 296 0.62500000 0.028709311 5702.124
## 297 0.23846154 0.011343862 5204.993
## 298 0.25781250 0.005322747 6845.349
## 299 0.01970443 0.003182889 5657.886
## 300 0.64532020 0.002709162 4621.142
## 303 0.88034188 0.066430116 9153.445
## 304 0.20000000 0.015934469 4757.439
## 305 0.59259259 0.041111219 8221.973
## 306 0.23809524 0.005901048 6081.788
## 307 0.44117647 0.000000000 3588.331
## 309 0.10843374 0.004320968 3411.070
## 310 0.78906250 0.049396229 5005.843
## 311 0.18750000 0.020390315 4126.561
## 312 0.90000000 0.124355322 5842.513
## 313 0.14857143 0.038356532 4436.690
## 315 0.03278689 0.005081114 2960.618
## 317 0.05813953 0.002795310 3410.098
## 318 0.07096774 0.000133585 3525.119
## 319 0.04838710 0.006579036 4307.759
## 320 0.25000000 0.106681276 2084.316
## 321 0.25555556 0.006440155 2353.569
## 322 0.13207547 0.026037911 4278.902
## 323 0.12500000 0.013116102 2003.322
## 326 0.04032258 0.002845941 3115.368
## 327 0.16666667 0.015137783 3445.828
## 328 0.07623318 0.005377698 4501.133
## 329 0.32926829 0.006344647 4355.329
## 330 0.43609023 0.037840879 4405.712
## 331 0.02597403 0.017257919 4790.596
## 332 0.58461538 0.006026483 5072.836
## 333 0.04428044 0.019292913 5868.563
## 334 0.17073171 0.022560025 4085.942
## 335 0.26595745 0.008016571 3696.982
## 336 0.13333333 0.004707677 2865.021
## 337 0.18750000 0.017922873 3136.503
## 339 0.07812500 0.005180616 4825.318
## 340 0.15686274 0.017769024 2530.524
## 341 0.20370370 0.021550935 1877.201
## 342 0.26213592 0.033293989 6375.914
## 343 0.25849515 0.008770337 6422.533
## 344 0.52293578 0.004513180 4858.666
## 345 0.02651515 0.002159659 4637.331
## 346 0.90277778 0.018057048 8681.989
## 347 0.08333333 0.019602723 5432.515
## 349 0.02752294 0.005666789 6616.860
## 351 0.66037736 0.010970533 4938.714
## 352 0.01449275 0.003543822 4054.276
## 353 0.03125000 0.001735131 4559.612
## 354 0.15258856 0.018139307 11847.371
## 356 1.00000000 0.011366653 6858.635
## 358 0.89285714 0.063330813 3692.020
## 359 0.18604651 0.032001508 4381.886
## 360 0.61946903 0.016894668 4185.956
## 362 0.08474576 0.013386212 5246.043
## 363 0.44680851 0.000005400 4485.713
## 366 0.05000000 0.000007320 7000.817
## 369 0.13043478 0.013658732 3333.174
## 371 0.10989011 0.026351334 4221.526
## 372 0.12903226 0.014738046 4285.337
## 373 0.04807692 0.010082127 4511.276
## 374 0.13207547 0.010258618 5804.258
## 375 0.22727273 0.025197212 3244.315
## 376 0.80487805 0.055597970 6302.726
## 377 0.40000000 0.038019726 4056.120
## 378 0.45454545 0.015670650 4031.884
## 380 0.03703704 0.006924961 2407.827
## HPP.NRW.Rill...Rp.m3. Selisih.Tarif..Rp.m3. FCR.Non.FCR
## 3 3088.655 5.057566e+02 FCR
## 5 4984.788 -9.810206e+02 Non FCR
## 6 6002.742 -1.156748e+03 Non FCR
## 8 3347.830 8.588478e+02 FCR
## 9 7724.870 -2.612203e+03 Non FCR
## 11 6375.166 -1.386730e+03 Non FCR
## 12 2527.668 -8.298507e+02 Non FCR
## 13 4493.642 -2.603442e+02 Non FCR
## 14 4077.130 -1.357478e+03 Non FCR
## 16 4571.658 1.891121e+02 FCR
## 17 3796.960 -5.707827e+02 Non FCR
## 18 4818.393 -7.021080e+02 Non FCR
## 19 16951.187 -1.161311e+04 Non FCR
## 22 2593.215 -1.179647e+03 Non FCR
## 23 4178.483 -1.094566e+03 Non FCR
## 24 5283.810 -3.125313e+02 Non FCR
## 25 5596.438 -9.255882e+02 Non FCR
## 26 5107.408 -1.318163e+03 Non FCR
## 27 3103.671 -2.290442e+02 Non FCR
## 29 2930.066 6.008903e+02 FCR
## 31 2449.832 5.886019e+01 FCR
## 32 4926.517 -1.771718e+03 Non FCR
## 33 4330.199 -2.449794e+02 Non FCR
## 34 4907.455 -5.286725e+02 Non FCR
## 35 4037.202 5.397149e+02 FCR
## 36 4509.308 -6.237054e+02 Non FCR
## 38 3306.501 -4.286457e+02 Non FCR
## 39 2868.874 -2.931811e+02 Non FCR
## 40 4046.244 -8.722851e+01 Non FCR
## 41 3285.564 4.575139e+02 FCR
## 42 3604.278 7.283483e+02 FCR
## 43 4122.088 -3.718629e+02 Non FCR
## 44 3342.686 -1.255150e+03 Non FCR
## 45 4958.028 -1.785461e+03 Non FCR
## 46 4374.910 -1.983475e+03 Non FCR
## 47 5428.297 -1.678175e+03 Non FCR
## 48 4146.929 3.170178e+02 FCR
## 49 3311.451 -8.988939e+02 Non FCR
## 50 4217.432 -3.050999e+02 Non FCR
## 51 3525.985 -5.678771e+02 Non FCR
## 52 2905.839 4.186655e+02 FCR
## 53 3688.521 -4.996326e+01 Non FCR
## 54 5955.576 -1.909125e+03 Non FCR
## 56 5128.862 6.429936e+02 FCR
## 57 9062.581 -3.727461e+03 Non FCR
## 58 8940.097 -1.303536e+03 Non FCR
## 59 116149.263 -1.064229e+05 Non FCR
## 60 4447.909 3.878574e+02 FCR
## 61 3703.794 -6.805590e+02 Non FCR
## 62 2185.186 -3.585337e+02 Non FCR
## 63 5979.436 3.893219e+02 FCR
## 64 3341.248 8.130795e+02 FCR
## 65 5705.832 -3.312086e+03 Non FCR
## 66 5333.254 -1.036088e+03 Non FCR
## 70 5323.276 1.233145e+03 FCR
## 72 6169.445 -5.421193e+02 Non FCR
## 73 7250.051 -2.293462e+03 Non FCR
## 74 5617.260 -6.961973e+02 Non FCR
## 75 7387.647 -7.131013e+02 Non FCR
## 76 10973.041 -7.830661e+03 Non FCR
## 77 5377.451 -6.743148e+02 Non FCR
## 78 4161.289 -6.911670e+02 Non FCR
## 79 5297.743 1.238816e+02 FCR
## 80 5534.100 -5.507981e+02 Non FCR
## 81 4028.052 -1.091818e+03 Non FCR
## 82 7976.439 -2.678524e+03 Non FCR
## 85 5441.776 -9.213228e+01 Non FCR
## 86 6548.709 -2.110270e+03 Non FCR
## 88 7933.068 -4.607161e+03 Non FCR
## 89 2755.823 1.200495e+03 FCR
## 90 11169.845 -2.773817e+03 Non FCR
## 93 10375.674 -4.092273e+03 Non FCR
## 94 7642.558 -4.152957e+02 Non FCR
## 95 7796.260 -3.938566e+03 Non FCR
## 96 3950.861 1.444192e+02 FCR
## 97 6267.111 3.228870e+03 FCR
## 98 1802.454 -1.045413e+02 Non FCR
## 100 6870.401 3.892120e+02 FCR
## 103 5110.243 -2.828603e+01 Non FCR
## 105 5062.677 2.086399e+02 FCR
## 106 7727.276 5.033613e+02 FCR
## 107 3952.909 6.207441e+01 FCR
## 108 5827.081 4.369076e+02 FCR
## 109 3052.524 5.137854e+02 FCR
## 110 5826.326 -6.237067e+02 Non FCR
## 111 7123.269 -7.039765e+02 Non FCR
## 112 6000.489 -6.333756e+02 Non FCR
## 113 6552.564 1.934183e+03 FCR
## 114 6925.826 1.647985e+03 FCR
## 115 6429.602 -2.226833e+02 Non FCR
## 116 5143.217 2.000177e+02 FCR
## 117 5139.192 -1.491245e+03 Non FCR
## 118 6832.011 3.484107e+02 FCR
## 119 5175.404 -3.603446e+02 Non FCR
## 120 4082.338 1.552197e+02 FCR
## 121 5268.894 2.107208e+03 FCR
## 122 3455.657 1.637775e+02 FCR
## 123 7765.329 -2.819304e+02 Non FCR
## 124 5347.755 -1.938782e+02 Non FCR
## 125 4907.367 3.168680e+02 FCR
## 126 5714.063 3.087551e+02 FCR
## 127 4412.362 9.441704e+01 FCR
## 128 6481.028 1.755012e+03 FCR
## 129 4404.719 1.430001e+03 FCR
## 130 6296.374 -1.325390e+01 Non FCR
## 131 5950.678 1.721787e+02 FCR
## 132 3245.480 7.721249e+02 FCR
## 133 5757.295 1.757181e+02 FCR
## 134 7365.692 1.354508e+03 FCR
## 135 5710.226 -6.214367e+02 Non FCR
## 136 5494.631 1.124696e+03 FCR
## 137 3369.245 4.341763e+02 FCR
## 138 2543.275 1.233279e+02 FCR
## 139 6971.385 -2.026037e+03 Non FCR
## 140 4408.371 -2.175288e+02 Non FCR
## 141 4216.994 6.336557e+01 FCR
## 142 3701.638 -7.488834e+01 Non FCR
## 143 2148.379 1.240482e+02 FCR
## 144 5668.251 8.300053e+01 FCR
## 145 3359.692 6.027968e+02 FCR
## 146 4937.522 6.062377e+02 FCR
## 147 5282.235 3.052142e+01 FCR
## 148 3254.189 7.182712e+01 FCR
## 149 4666.459 1.485543e+02 FCR
## 150 4970.788 -4.509007e+01 Non FCR
## 151 5404.738 -7.100269e+01 Non FCR
## 152 4413.049 -3.689882e+02 Non FCR
## 153 5430.887 9.454408e+00 FCR
## 154 5251.118 2.660673e+02 FCR
## 155 2912.396 1.677838e+02 FCR
## 156 4127.128 4.847117e+01 FCR
## 157 4441.056 -3.515419e+02 Non FCR
## 158 2026.256 -3.186038e+02 Non FCR
## 159 5585.768 -2.166310e+02 Non FCR
## 160 3902.231 8.842169e+02 FCR
## 161 3960.058 3.276280e+02 FCR
## 162 3794.485 5.456914e+02 FCR
## 163 5812.743 1.388894e+02 FCR
## 164 4550.295 7.579533e+02 FCR
## 165 3339.324 3.023203e+02 FCR
## 166 4529.518 3.770622e+02 FCR
## 167 4574.934 8.533534e+01 FCR
## 168 3645.922 2.238676e+02 FCR
## 169 4465.072 -5.321026e+01 Non FCR
## 170 6454.833 3.459612e+02 FCR
## 171 3838.519 1.125296e+02 FCR
## 172 4924.886 9.647443e+02 FCR
## 173 5119.334 2.336738e+02 FCR
## 174 4893.718 4.006645e+02 FCR
## 175 3764.087 1.916823e+03 FCR
## 176 4015.017 6.178706e+02 FCR
## 177 3228.036 2.151764e+02 FCR
## 178 5011.735 -1.739467e+03 Non FCR
## 179 3461.792 1.497825e+02 FCR
## 180 4494.360 4.398837e+01 FCR
## 181 3442.808 -5.871266e+01 Non FCR
## 182 1982.218 9.984936e+02 FCR
## 183 2634.165 3.428053e+02 FCR
## 184 4442.739 -6.755732e+01 Non FCR
## 185 2452.959 8.415648e+02 FCR
## 186 6379.496 -8.165341e+02 Non FCR
## 187 2543.888 6.185441e+01 FCR
## 188 6365.374 -1.867627e+03 Non FCR
## 189 3715.105 8.627118e+02 FCR
## 190 5946.464 9.303532e+02 FCR
## 191 4736.748 7.352966e+02 FCR
## 192 3864.261 7.076137e+01 FCR
## 193 3361.363 -2.871999e+02 Non FCR
## 194 3099.110 3.991765e+02 FCR
## 195 2569.722 5.849773e+02 FCR
## 196 2475.708 1.900945e+02 FCR
## 197 3542.248 1.930604e+02 FCR
## 198 3680.065 -1.403399e+01 Non FCR
## 199 4690.906 4.650882e+02 FCR
## 200 5262.835 3.220741e+02 FCR
## 201 4314.184 -3.396951e+02 Non FCR
## 202 3395.552 8.669884e+02 FCR
## 203 5838.005 1.073920e+02 FCR
## 204 3926.762 1.022039e+02 FCR
## 205 3593.267 3.828272e+02 FCR
## 206 4560.960 -1.554676e+03 Non FCR
## 207 4018.420 1.749868e+03 FCR
## 208 3466.654 -7.167122e+00 Non FCR
## 209 4390.571 -1.680016e+02 Non FCR
## 210 3882.874 -3.978931e+02 Non FCR
## 211 2687.702 9.797729e+02 FCR
## 212 2149.813 8.266645e+02 FCR
## 213 2789.775 -1.992941e+02 Non FCR
## 214 5170.977 -6.157371e+02 Non FCR
## 215 4495.394 1.256041e+02 FCR
## 216 8081.645 5.929489e+02 FCR
## 217 5068.505 1.862917e+02 FCR
## 218 4037.469 -7.046471e+02 Non FCR
## 219 6638.752 -4.121601e+02 Non FCR
## 220 3676.518 -5.811096e-01 Non FCR
## 221 3840.433 8.181758e+02 FCR
## 222 5079.758 2.685187e+02 FCR
## 223 3139.382 4.931293e+02 FCR
## 224 2519.216 -1.822789e+02 Non FCR
## 225 2813.028 -4.108437e+01 Non FCR
## 226 2719.166 1.374731e+02 FCR
## 228 4537.677 -1.394906e+03 Non FCR
## 229 2958.804 4.579043e+02 FCR
## 231 3136.427 1.253229e+02 FCR
## 232 6947.550 8.299000e+02 FCR
## 234 4715.730 -1.172478e+03 Non FCR
## 235 6509.593 4.767714e+01 FCR
## 237 3414.968 -3.925953e+02 Non FCR
## 238 5294.363 -2.846863e+02 Non FCR
## 239 5613.291 -7.619036e+02 Non FCR
## 240 5172.818 -9.334924e+02 Non FCR
## 241 5773.250 -3.323120e+02 Non FCR
## 242 3546.514 -2.691157e+02 Non FCR
## 244 6572.055 -3.104150e+03 Non FCR
## 245 7259.130 3.937812e+02 FCR
## 246 6823.088 -1.816127e+02 Non FCR
## 247 4123.018 -5.773777e+02 Non FCR
## 248 2956.633 -1.058113e+03 Non FCR
## 250 5402.484 -1.597008e+03 Non FCR
## 251 4573.946 -4.928251e+02 Non FCR
## 252 9223.689 -1.235692e+03 Non FCR
## 253 4575.036 -9.949173e+02 Non FCR
## 254 4843.440 -6.524432e+02 Non FCR
## 255 9280.932 -3.568535e+03 Non FCR
## 256 6833.920 -4.774605e+02 Non FCR
## 257 3938.828 7.344264e+02 FCR
## 258 7182.214 -2.672797e+02 Non FCR
## 259 4716.744 -5.662199e+02 Non FCR
## 260 5052.767 -6.815812e+02 Non FCR
## 261 9256.574 -4.316780e+03 Non FCR
## 262 4499.363 -5.104905e+02 Non FCR
## 263 7177.360 -1.391315e+03 Non FCR
## 264 9924.230 -7.015058e+03 Non FCR
## 265 5585.805 -1.660073e+03 Non FCR
## 267 5429.434 -1.354560e+03 Non FCR
## 268 6987.514 -1.633225e+03 Non FCR
## 269 12730.821 -6.116779e+03 Non FCR
## 271 5530.963 -1.760538e+03 Non FCR
## 272 9059.632 -1.700330e+03 Non FCR
## 273 4574.500 -6.231869e+02 Non FCR
## 274 5424.502 -1.602726e+03 Non FCR
## 275 10283.599 -1.947183e+03 Non FCR
## 277 6808.639 -2.472447e+03 Non FCR
## 278 4503.325 1.859785e+01 FCR
## 279 5259.035 -9.630787e+02 Non FCR
## 280 5312.808 -2.584246e+02 Non FCR
## 281 6886.615 -2.230077e+03 Non FCR
## 282 5576.080 -1.136834e+03 Non FCR
## 283 7954.790 -3.399898e+03 Non FCR
## 284 8059.152 3.782982e+02 FCR
## 285 6360.799 -3.068030e+02 Non FCR
## 286 13341.418 -5.729149e+03 Non FCR
## 287 4335.131 1.918394e+02 FCR
## 288 7969.598 -1.250791e+02 Non FCR
## 289 4140.190 5.865305e+02 FCR
## 290 5662.911 -1.812048e+03 Non FCR
## 291 5861.423 6.779716e+02 FCR
## 292 9076.026 7.213135e+02 FCR
## 294 4998.157 -9.763879e+02 Non FCR
## 295 5557.487 4.227273e+01 FCR
## 296 6016.833 -3.147090e+02 Non FCR
## 297 5856.080 -6.510874e+02 Non FCR
## 298 6156.545 6.888044e+02 FCR
## 299 6715.484 -1.057598e+03 Non FCR
## 300 4128.489 4.926530e+02 FCR
## 303 8326.731 8.267139e+02 FCR
## 304 5235.277 -4.778382e+02 Non FCR
## 305 8044.810 1.771633e+02 FCR
## 306 7746.796 -1.665008e+03 Non FCR
## 307 2834.013 7.543177e+02 FCR
## 309 5643.421 -2.232350e+03 Non FCR
## 310 5360.020 -3.541775e+02 Non FCR
## 311 7033.769 -2.907208e+03 Non FCR
## 312 14772.374 -8.929862e+03 Non FCR
## 313 4351.634 8.505617e+01 FCR
## 315 3900.656 -9.400379e+02 Non FCR
## 317 3626.124 -2.160260e+02 Non FCR
## 318 4278.070 -7.529507e+02 Non FCR
## 319 4091.708 2.160517e+02 FCR
## 320 1956.267 1.280493e+02 FCR
## 321 4322.986 -1.969417e+03 Non FCR
## 322 8613.815 -4.334912e+03 Non FCR
## 323 3082.842 -1.079520e+03 Non FCR
## 326 2820.008 2.953595e+02 FCR
## 327 4648.971 -1.203142e+03 Non FCR
## 328 3776.510 7.246229e+02 FCR
## 329 4095.844 2.594845e+02 FCR
## 330 4673.952 -2.682400e+02 Non FCR
## 331 4990.081 -1.994847e+02 Non FCR
## 332 6902.394 -1.829558e+03 Non FCR
## 333 6537.204 -6.686405e+02 Non FCR
## 334 7383.622 -3.297679e+03 Non FCR
## 335 4689.845 -9.928625e+02 Non FCR
## 336 3343.677 -4.786554e+02 Non FCR
## 337 5842.571 -2.706067e+03 Non FCR
## 339 4404.976 4.203420e+02 FCR
## 340 2566.564 -3.603972e+01 Non FCR
## 341 2735.213 -8.580116e+02 Non FCR
## 342 6437.167 -6.125346e+01 Non FCR
## 343 5695.085 7.274485e+02 FCR
## 344 6063.291 -1.204625e+03 Non FCR
## 345 4921.412 -2.840811e+02 Non FCR
## 346 12178.280 -3.496291e+03 Non FCR
## 347 5708.596 -2.760814e+02 Non FCR
## 349 7118.147 -5.012867e+02 Non FCR
## 351 10545.997 -5.607283e+03 Non FCR
## 352 7606.272 -3.551996e+03 Non FCR
## 353 6569.138 -2.009527e+03 Non FCR
## 354 7680.864 4.166507e+03 FCR
## 356 66189.190 -5.933056e+04 Non FCR
## 358 3762.435 -7.041448e+01 Non FCR
## 359 9192.812 -4.810926e+03 Non FCR
## 360 4071.638 1.143176e+02 FCR
## 362 6261.205 -1.015162e+03 Non FCR
## 363 8675.677 -4.189965e+03 Non FCR
## 366 8955.160 -1.954343e+03 Non FCR
## 369 3977.070 -6.438967e+02 Non FCR
## 371 5949.923 -1.728397e+03 Non FCR
## 372 10092.500 -5.807163e+03 Non FCR
## 373 4771.846 -2.605702e+02 Non FCR
## 374 10606.120 -4.801862e+03 Non FCR
## 375 4546.696 -1.302381e+03 Non FCR
## 376 5351.629 9.510964e+02 FCR
## 377 4576.604 -5.204847e+02 Non FCR
## 378 3714.329 3.175551e+02 FCR
## 380 2705.821 -2.979947e+02 Non FCRanyNA(PDAM_2018_new)## [1] FALSEcolSums(is.na(PDAM_2018_new))## No
## 0
## Kabupaten...Kota
## 0
## Propinsi
## 0
## Nilai.Tahun.Buku.2018
## 0
## Kinerja.Tahun.Buku.2018
## 0
## Jumlah.Pelanggan
## 0
## ROE
## 0
## Ratio.Operasi
## 0
## Cash.Ratio
## 0
## Efektivitas.Penagihan
## 0
## Solvabilitas
## 0
## Cakupan.Pelayanan.Teknis
## 0
## Pertumbuhan.Pelanggan....Tahun.
## 0
## Tingkat.Penyelesaian.Aduan
## 0
## Kualitas.Air.Pelanggan
## 0
## Konsumsi.Air.Domestik
## 0
## Efisiensi.Produksi
## 0
## Tingkat.Kehilangan.Air
## 0
## Jam.Operasi.Pelayanan
## 0
## Tekanan.Air.pada.Sambungan.Pelanggan
## 0
## Penggantian.Kalibrasi.Meter.Air.Pelanggan
## 0
## Rasio.Pegawai
## 0
## Ratio.Diklat.Pegawai
## 0
## Ratio.Biaya.Diklat
## 0
## Tarif.rata.rata..Rp.m3.
## 0
## HPP.NRW.Rill...Rp.m3.
## 0
## Selisih.Tarif..Rp.m3.
## 0
## FCR.Non.FCR
## 0From the data cleansing that we’ve just performed, out of 380 PDAMs, only 326 PDAMs are eligible for further analysis. Of the 326 PDAMs, we will create a new column to categorize them into four regions based on the classification done by the Directorate General of Public Works of the Ministry of Public Works and Public Housing of Indonesia. These four categories are Wilayah 1 (Sumatera island), Wilayah 2 (Java island), Wilayah 3 (Kalimantan, Sulawesi, and Maluku islands), and Wilayah 4 (Bali, Nusa Tenggara, and Papua islands).
#Summary of the new dataset
# Creating New Variable For Region
levels(PDAM_2018_new$Propinsi)## [1] "Aceh" "Bali" "Bangka Belitung"
## [4] "Banten" "Bengkulu" "D. I. Yogyakarta"
## [7] "DKI Jakarta" "Gorontalo" "Jambi"
## [10] "Jawa Barat" "Jawa Tengah" "Jawa Timur"
## [13] "Kalimantan Barat" "Kalimantan Selatan" "Kalimantan Tengah"
## [16] "Kalimantan Timur" "Kalimantan Utara" "Kepulauan Riau"
## [19] "Lampung" "Maluku" "Maluku Utara"
## [22] "Nusa Tenggara Barat" "Nusa Tenggara Timur" "Papua"
## [25] "Papua Barat" "Riau" "Sulawesi Barat"
## [28] "Sulawesi Selatan" "Sulawesi Tengah" "Sulawesi Tenggara"
## [31] "Sulawesi Utara" "Sumatera Barat" "Sumatera Selatan"
## [34] "Sumatera Utara"PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Aceh"]<-"Wilayah_1"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Sumatera Utara"]<-"Wilayah_1"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Sumatera Barat"]<-"Wilayah_1"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Riau"]<-"Wilayah_1"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Kepulauan Riau"]<-"Wilayah_1"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Jambi"]<-"Wilayah_1"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Sumatera Selatan"]<-"Wilayah_1"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Bangka Belitung"]<-"Wilayah_1"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Bengkulu"]<-"Wilayah_1"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Lampung"]<-"Wilayah_1"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Banten"]<-"Wilayah_2"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="DKI Jakarta"]<-"Wilayah_2"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Jawa Barat"]<-"Wilayah_2"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Jawa Tengah"]<-"Wilayah_2"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="D. I. Yogyakarta"]<-"Wilayah_2"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Jawa Timur"]<-"Wilayah_2"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Kalimantan Barat"]<-"Wilayah_3"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Kalimantan Tengah"]<-"Wilayah_3"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Kalimantan Selatan"]<-"Wilayah_3"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Kalimantan Timur"]<-"Wilayah_3"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Kalimantan Utara"]<-"Wilayah_3"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Sulawesi Utara"]<-"Wilayah_3"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Sulawesi Barat"]<-"Wilayah_3"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Sulawesi Tengah"]<-"Wilayah_3"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Sulawesi Tenggara"]<-"Wilayah_3"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Sulawesi Selatan"]<-"Wilayah_3"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Gorontalo"]<-"Wilayah_3"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Bali"]<-"Wilayah_4"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Nusa Tenggara Barat"]<-"Wilayah_4"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Nusa Tenggara Timur"]<-"Wilayah_4"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Maluku"]<-"Wilayah_4"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Maluku Utara"]<-"Wilayah_4"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Papua Barat"]<-"Wilayah_4"
PDAM_2018_new$Wilayah[PDAM_2018_new$Propinsi=="Papua"]<-"Wilayah_4"
PDAM_2018_new$Wilayah <- as.factor(PDAM_2018_new$Wilayah)
levels(PDAM_2018_new$Wilayah)## [1] "Wilayah_1" "Wilayah_2" "Wilayah_3" "Wilayah_4"str(PDAM_2018_new)## 'data.frame': 326 obs. of 29 variables:
## $ No : int 3 5 6 8 9 11 12 13 14 16 ...
## $ Kabupaten...Kota : chr "Kabupaten Aceh Selatan" "Kabupaten Aceh Timur" "Kabupaten Aceh Tengah" "Kabupaten Aceh Besar" ...
## $ Propinsi : Factor w/ 34 levels "Aceh","Bali",..: 1 1 1 1 1 1 1 1 1 1 ...
## $ Nilai.Tahun.Buku.2018 : num 2.08 2.26 2.85 3.25 2.73 ...
## $ Kinerja.Tahun.Buku.2018 : Factor w/ 3 levels "KURANG SEHAT",..: 2 1 3 3 1 1 2 1 2 3 ...
## $ Jumlah.Pelanggan : int 7343 12157 7377 30048 6852 27110 4478 16619 5145 47788 ...
## $ ROE : num -0.00694 -0.0533 -0.09212 0.06625 -0.08951 ...
## $ Ratio.Operasi : num 1.023 1.171 1.205 0.806 1.553 ...
## $ Cash.Ratio : num 0.241 0.331 0.356 59.775 7.648 ...
## $ Efektivitas.Penagihan : num 0.991 1 0.953 0.857 0.995 ...
## $ Solvabilitas : num 28.9 28.7 340.4 228.5 1984.5 ...
## $ Cakupan.Pelayanan.Teknis : num 0.184 0.15 0.204 0.298 0.078 ...
## $ Pertumbuhan.Pelanggan....Tahun. : num 0.4973 0.0674 0.021 0.1084 0.1118 ...
## $ Tingkat.Penyelesaian.Aduan : num 0.845 0.859 1 1 0.988 ...
## $ Kualitas.Air.Pelanggan : num 0 0 0 0 0 ...
## $ Konsumsi.Air.Domestik : num 4.58 14.39 13.47 17.16 11.94 ...
## $ Efisiensi.Produksi : num 0.299 0.628 0.272 0.876 0.4 ...
## $ Tingkat.Kehilangan.Air : num 0.566 0.29 0.199 0.261 0.39 ...
## $ Jam.Operasi.Pelayanan : num 14 16.5 22 22 23 ...
## $ Tekanan.Air.pada.Sambungan.Pelanggan : num 0 0 0.936 0.37 0.135 ...
## $ Penggantian.Kalibrasi.Meter.Air.Pelanggan: num 0.0105 0.0422 0.0542 0.0109 0.0143 ...
## $ Rasio.Pegawai : num 4.36 6.42 7.18 3.63 6.28 ...
## $ Ratio.Diklat.Pegawai : num 0.25 0.103 0.849 0.11 0.907 ...
## $ Ratio.Biaya.Diklat : num 0.04798 0.00291 0.01161 0.03031 0.04473 ...
## $ Tarif.rata.rata..Rp.m3. : num 3594 4004 4846 4207 5113 ...
## $ HPP.NRW.Rill...Rp.m3. : num 3089 4985 6003 3348 7725 ...
## $ Selisih.Tarif..Rp.m3. : num 506 -981 -1157 859 -2612 ...
## $ FCR.Non.FCR : Factor w/ 2 levels "FCR","Non FCR": 1 2 2 1 2 2 2 2 2 1 ...
## $ Wilayah : Factor w/ 4 levels "Wilayah_1","Wilayah_2",..: 1 1 1 1 1 1 1 1 1 1 ...nrow(PDAM_2018_new)## [1] 326summary(PDAM_2018_new)## No Kabupaten...Kota Propinsi
## Min. : 3.0 Length:326 Jawa Timur : 38
## 1st Qu.:107.2 Class :character Jawa Tengah : 35
## Median :188.5 Mode :character Jawa Barat : 23
## Mean :190.2 Sulawesi Selatan: 19
## 3rd Qu.:278.8 Sumatera Barat : 16
## Max. :380.0 Aceh : 13
## (Other) :182
## Nilai.Tahun.Buku.2018 Kinerja.Tahun.Buku.2018 Jumlah.Pelanggan
## Min. :1.365 KURANG SEHAT: 93 Min. : 893
## 1st Qu.:2.555 SAKIT : 23 1st Qu.: 9353
## Median :2.973 SEHAT :210 Median : 16807
## Mean :2.968 Mean : 35262
## 3rd Qu.:3.369 3rd Qu.: 34352
## Max. :4.265 Max. :863166
##
## ROE Ratio.Operasi Cash.Ratio Efektivitas.Penagihan
## Min. :-0.645027 Min. :0.6480 Min. : -0.036 Min. :0.2888
## 1st Qu.:-0.057400 1st Qu.:0.9171 1st Qu.: 0.602 1st Qu.:0.8501
## Median : 0.008917 Median :0.9953 Median : 2.010 Median :0.9314
## Mean :-0.006643 Mean :1.1448 Mean : 85.327 Mean :0.8901
## 3rd Qu.: 0.047740 3rd Qu.:1.2178 3rd Qu.: 7.859 3rd Qu.:0.9724
## Max. : 0.886765 Max. :8.2713 Max. :14086.953 Max. :1.0126
##
## Solvabilitas Cakupan.Pelayanan.Teknis Pertumbuhan.Pelanggan....Tahun.
## Min. : 0.83 Min. :0.05739 Min. :-0.22646
## 1st Qu.: 8.49 1st Qu.:0.20973 1st Qu.: 0.02677
## Median : 18.87 Median :0.31359 Median : 0.05196
## Mean : 261.88 Mean :0.36618 Mean : 0.07342
## 3rd Qu.: 51.35 3rd Qu.:0.50561 3rd Qu.: 0.09214
## Max. :39702.53 Max. :0.99981 Max. : 0.85500
##
## Tingkat.Penyelesaian.Aduan Kualitas.Air.Pelanggan Konsumsi.Air.Domestik
## Min. :0.3226 Min. :0.0000 Min. : 1.133
## 1st Qu.:0.9870 1st Qu.:0.0000 1st Qu.:13.181
## Median :1.0000 Median :0.4278 Median :15.499
## Mean :0.9699 Mean :0.4744 Mean :15.670
## 3rd Qu.:1.0000 3rd Qu.:0.9088 3rd Qu.:17.457
## Max. :1.0364 Max. :3.1068 Max. :37.763
##
## Efisiensi.Produksi Tingkat.Kehilangan.Air Jam.Operasi.Pelayanan
## Min. :0.1016 Min. :0.04432 Min. : 2.981
## 1st Qu.:0.4385 1st Qu.:0.23787 1st Qu.:18.000
## Median :0.5850 Median :0.29283 Median :21.092
## Mean :0.5957 Mean :0.32148 Mean :19.727
## 3rd Qu.:0.7758 3rd Qu.:0.38030 3rd Qu.:23.000
## Max. :1.0000 Max. :0.87863 Max. :24.000
##
## Tekanan.Air.pada.Sambungan.Pelanggan Penggantian.Kalibrasi.Meter.Air.Pelanggan
## Min. :0.0000 Min. :0.00000
## 1st Qu.:0.2029 1st Qu.:0.01436
## Median :0.6104 Median :0.03090
## Mean :0.5327 Mean :0.05734
## 3rd Qu.:0.8488 3rd Qu.:0.06759
## Max. :2.0429 Max. :0.51689
##
## Rasio.Pegawai Ratio.Diklat.Pegawai Ratio.Biaya.Diklat
## Min. : 1.931 Min. :0.005917 Min. :0.000000
## 1st Qu.: 4.569 1st Qu.:0.132390 1st Qu.:0.006716
## Median : 6.389 Median :0.316243 Median :0.012868
## Mean : 7.014 Mean :0.414022 Mean :0.017955
## 3rd Qu.: 8.151 3rd Qu.:0.657870 3rd Qu.:0.023132
## Max. :36.954 Max. :2.211268 Max. :0.124355
##
## Tarif.rata.rata..Rp.m3. HPP.NRW.Rill...Rp.m3. Selisih.Tarif..Rp.m3.
## Min. : 1414 Min. : 1802 Min. :-106422.9
## 1st Qu.: 3621 1st Qu.: 3869 1st Qu.: -1030.9
## Median : 4409 Median : 4932 Median : -225.9
## Mean : 4690 Mean : 5785 Mean : -1095.1
## 3rd Qu.: 5438 3rd Qu.: 6238 3rd Qu.: 267.9
## Max. :11847 Max. :116149 Max. : 4166.5
##
## FCR.Non.FCR Wilayah
## FCR :133 Wilayah_1: 80
## Non FCR:193 Wilayah_2:108
## Wilayah_3: 98
## Wilayah_4: 40
##
##
## graphics::pie(xtabs(~Wilayah,PDAM_2018_new))
Based on the above information we can summarize the following information:
a. The Province that has the most PDAMs goes to Jawa Timur or East Java with 38 PDAMs, followed by Jawa Tengah or Central Java with 35 PDAMs and Jawa Barat or West Java with 23 PDAMs. This explains out of four Regions or Wilayahs, the Wilayah that has the most PDAMs is Wilayah 2 which covers the Java island only with 108 PDAMs available. Meanwhile, the only Wilayah that has the least PDAMs is Wilayah 4 which covers the Eastern part of Indonesia (Bali, Nusa Tenggara, and Papua islands) with only 40 PDAMs available in that Region compared to the other Wilayahs that has over 80 PDAMs. This shows that there is a huge gap that needs to be filled in the Eastern Part of Indonesia, especially when it comes to access to drinkable water.
c. Majority PDAMs are categorized as SEHAT or HEALTHY with a total number of 210, 93 are KURANG SEHAT or LESS HEALTHY and the rest 23 are categorized as SAKIT or SICK PDAMs.
c. Although majority of PDAMS are categorized as SEHAT or HEALTHY, there are more PDAMs that have yet to achieve full cost recovery (Non-FCR) with a total number of 193, compared to PDAMs that have achieved FCR (only 133). This warrants for further checking on which indicators that mostly correlate with the overall performance of the PDAMs.
Identifying Performance Indicators of PDAMs Worth Checking
# load library:
library(GGally)## Loading required package: ggplot2## Registered S3 method overwritten by 'GGally':
## method from
## +.gg ggplot2# visualisation:
ggcorr(PDAM_2018_new, label = T)## Warning in ggcorr(PDAM_2018_new, label = T): data in column(s)
## 'Kabupaten...Kota', 'Propinsi', 'Kinerja.Tahun.Buku.2018', 'FCR.Non.FCR',
## 'Wilayah' are not numeric and were ignored
Based on the “hot spot” data above, the indicators that correlate the most with the performance rating of PDAMs are as follows:
a. Total customers
b. Return on Equity (ROE)
c. Cash Ratio
d. Solvency Rate
e. Resolution Rate
f. Customer Water Quality
g. Domestic Water Consumption
h. Non-revenue water
i. Operational service hours
j. Water pressure at customer connection
k. Employee over customer ratio
Of the 11 indicators that have high correlation with the PDAMs’ performance rating, there are at least four indicators that are very important for the Bank to look out for the piloting phase of the program loan, namely:
a. ROE is a good indicator that shows the profitability level of the PDAM for investors, like the Bank. The higher the ROE, means the company has potentials to generate more profits, which could be used as a source of repayment for the loan;
b. Cash ratio is a good measurement of the PDAM’s liquidity, which means that the company has the ability to repay its short-term debt with cash or near-cash resources;
c. Solvency ratio shows how well a company’s cash flow can cover its long-term debt. This indicator can be used to determine the likelihood whether the company will default or not; and
d. Non-revenue water (NRW) is water that has been produced but lost before it reaches the customer. A high NRW indicates poor administrative management, poor customer billing system, and/or due to technical damage of the piping network. Hence, we should aim for high NRW for the potential PDAMs for the Municipal program loan. The program loan can aim for decreasing the NRW rate as a start. Additionally, NRW reduction is part of the priority program of Indonesia National Medium-Term Development Plan.
knitr::include_graphics("datainput/NRW image.jpg")
Mapping Potential Municipalities in Each Wilayah
Next, we need to identify max. 2 Municipalities in each Wilayah that are considered healthy, but still have some room for improvements for the piloting phase of the program loan. Aside from the above indicators, we will also consider FCR as an indication that the PDAM is financially healthy as they no longer need to subsidize the cost for the consumers.
#Subsetting Healthy Wilayah 1 PDAMs
Wilayah_1_SEHAT <- PDAM_2018_new[PDAM_2018_new$Wilayah == "Wilayah_1" & PDAM_2018_new$Kinerja.Tahun.Buku.2018 == "SEHAT" & PDAM_2018_new$FCR.Non.FCR == "FCR",c("Kabupaten...Kota","Propinsi","Kinerja.Tahun.Buku.2018","Jumlah.Pelanggan","ROE","Cash.Ratio","Solvabilitas","Tingkat.Kehilangan.Air","FCR.Non.FCR")]
summary(Wilayah_1_SEHAT)## Kabupaten...Kota Propinsi Kinerja.Tahun.Buku.2018 Jumlah.Pelanggan
## Length:14 Sumatera Barat:3 KURANG SEHAT: 0 Min. : 7637
## Class :character Aceh :2 SAKIT : 0 1st Qu.: 15665
## Mode :character Kepulauan Riau:2 SEHAT :14 Median : 32540
## Sumatera Utara:2 Mean : 84363
## Bengkulu :1 3rd Qu.: 70641
## Jambi :1 Max. :487255
## (Other) :3
## ROE Cash.Ratio Solvabilitas Tingkat.Kehilangan.Air
## Min. :0.0003183 Min. : 0.655 Min. : 3.267 Min. :0.1700
## 1st Qu.:0.0292100 1st Qu.: 1.537 1st Qu.: 7.480 1st Qu.:0.2761
## Median :0.0591718 Median : 3.264 Median : 13.504 Median :0.2996
## Mean :0.0900315 Mean :16.711 Mean : 89.355 Mean :0.3317
## 3rd Qu.:0.0891435 3rd Qu.:16.486 3rd Qu.: 61.505 3rd Qu.:0.4071
## Max. :0.4723488 Max. :73.114 Max. :736.492 Max. :0.5248
##
## FCR.Non.FCR
## FCR :14
## Non FCR: 0
##
##
##
##
## #Finding out the Healthy Wilayah 1 PDAMs that has the highest NRW (above the 3rd quartile)
Wilayah_1_SEHAT[Wilayah_1_SEHAT$Tingkat.Kehilangan.Air > 0.4071,]## Kabupaten...Kota Propinsi Kinerja.Tahun.Buku.2018 Jumlah.Pelanggan
## 52 Kota Bukit Tinggi Sumatera Barat SEHAT 9916
## 70 Kota Bengkulu Bengkulu SEHAT 35031
## 79 Kota Jambi Jambi SEHAT 78259
## 105 Kota Bandar Lampung Lampung SEHAT 42193
## ROE Cash.Ratio Solvabilitas Tingkat.Kehilangan.Air FCR.Non.FCR
## 52 0.082107776 2.5846346 4.655239 0.4094636 FCR
## 70 0.000318341 2.0665028 32.667220 0.5247650 FCR
## 79 0.069974460 0.6550387 7.021034 0.4317541 FCR
## 105 0.006767862 19.3478938 85.483228 0.4446056 FCRFrom the table above, it can be inferred that there are four Municipalities that have the highest NRW rate (sorted from the highest to the lowest NRW), namely:
Kota Bengkulu
Kota Bandar Lampung
Kota Jambi
Kota Bukit Tinggi
From the four Municipalities, Kota Bengkulu and Kota Bandar Lampung seemed like a good fit for potential Municipalities to obtain Program Loan from the Bank as they have high numbers of Cash Ratio and Solvency Rate compared to the other two. This means that the two PDAMs will have no problem in repaying the debt as they are liquid and have good cash flow. However, it should be noted that in terms of ROE, they are lower than the other two Municipalities which indicate that the two PDAMs are still struggling in increasing their profit base, which make sense since the NRW rate is very high.
#Subsetting Healthy Wilayah 2 PDAMs
Wilayah_2_SEHAT <- PDAM_2018_new[PDAM_2018_new$Wilayah == "Wilayah_2" & PDAM_2018_new$Kinerja.Tahun.Buku.2018 == "SEHAT" & PDAM_2018_new$FCR.Non.FCR == "FCR",c("Kabupaten...Kota","Propinsi","Kinerja.Tahun.Buku.2018","Jumlah.Pelanggan","ROE","Cash.Ratio","Solvabilitas","Tingkat.Kehilangan.Air","FCR.Non.FCR")]
summary(Wilayah_2_SEHAT)## Kabupaten...Kota Propinsi Kinerja.Tahun.Buku.2018
## Length:72 Jawa Tengah :25 KURANG SEHAT: 0
## Class :character Jawa Timur :22 SAKIT : 0
## Mode :character Jawa Barat :16 SEHAT :72
## D. I. Yogyakarta: 5
## Banten : 3
## DKI Jakarta : 1
## (Other) : 0
## Jumlah.Pelanggan ROE Cash.Ratio Solvabilitas
## Min. : 10800 Min. :-0.64503 Min. : 0.09476 Min. : 0.8276
## 1st Qu.: 30046 1st Qu.: 0.02975 1st Qu.: 1.13525 1st Qu.: 6.6560
## Median : 43361 Median : 0.05818 Median : 2.33417 Median : 10.0058
## Mean : 74584 Mean : 0.07152 Mean : 5.71476 Mean : 15.5781
## 3rd Qu.: 61072 3rd Qu.: 0.09835 3rd Qu.: 6.43522 3rd Qu.: 15.8675
## Max. :863166 Max. : 0.88677 Max. :46.79262 Max. :102.8212
##
## Tingkat.Kehilangan.Air FCR.Non.FCR
## Min. :0.05898 FCR :72
## 1st Qu.:0.22541 Non FCR: 0
## Median :0.26199
## Mean :0.27456
## 3rd Qu.:0.31245
## Max. :0.49495
## #Finding out the Healthy Wilayah 2 PDAMs that has the highest NRW (above the 3rd quartile)
Wilayah_2_SEHAT[Wilayah_2_SEHAT$Tingkat.Kehilangan.Air > 0.31245,]## Kabupaten...Kota Propinsi Kinerja.Tahun.Buku.2018
## 106 DKI Jakarta DKI Jakarta SEHAT
## 118 Kabupaten Tasikmalaya Jawa Barat SEHAT
## 126 Kabupaten Purwakarta Jawa Barat SEHAT
## 129 Kota Bogor Jawa Barat SEHAT
## 131 Kota Bandung Jawa Barat SEHAT
## 137 Kabupaten Banyumas Jawa Tengah SEHAT
## 149 Kabupaten Sragen Jawa Tengah SEHAT
## 156 Kabupaten Demak Jawa Tengah SEHAT
## 161 Kabupaten Pekalongan Jawa Tengah SEHAT
## 165 Kota Magelang Jawa Tengah SEHAT
## 166 Kota Surakarta Jawa Tengah SEHAT
## 168 Kota Semarang Jawa Tengah SEHAT
## 170 Kota Tegal Jawa Tengah SEHAT
## 175 Kota Yogyakarta D. I. Yogyakarta SEHAT
## 180 Kabupaten Blitar Jawa Timur SEHAT
## 192 Kabupaten Jombang Jawa Timur SEHAT
## 195 Kabupaten Magetan Jawa Timur SEHAT
## 204 Kabupaten Sumenep Jawa Timur SEHAT
## Jumlah.Pelanggan ROE Cash.Ratio Solvabilitas Tingkat.Kehilangan.Air
## 106 863166 -0.64502748 0.4899676 0.827553 0.4340377
## 118 43659 0.16565603 1.1436161 2.416411 0.4297230
## 126 27575 0.01706307 0.6430954 3.269973 0.3222610
## 129 159290 0.09219424 2.2740011 3.562163 0.3165223
## 131 174908 0.06690421 3.5649594 8.442197 0.4949463
## 137 78526 0.04437595 0.6418011 6.587631 0.3639186
## 149 63203 0.05167443 16.4058926 52.051722 0.3219915
## 156 49843 0.06313061 1.9764013 12.303867 0.3477503
## 161 15804 0.07963740 1.8369398 10.537583 0.4065287
## 165 31381 0.09914001 2.0330255 15.495488 0.3481227
## 166 58871 0.03962091 0.6993466 4.157357 0.4321767
## 168 172334 0.05702644 1.9873596 5.761927 0.3873058
## 170 28101 0.11182973 14.7328078 8.526239 0.4674747
## 175 32247 0.02580049 6.4588486 6.678859 0.3132758
## 180 14194 0.02794880 1.2913575 12.368122 0.3717955
## 192 20009 0.00927672 46.7926179 16.590153 0.3596091
## 195 70362 0.05227278 6.0570018 11.639263 0.3346656
## 204 12949 0.88676553 1.4350680 5.712376 0.3410379
## FCR.Non.FCR
## 106 FCR
## 118 FCR
## 126 FCR
## 129 FCR
## 131 FCR
## 137 FCR
## 149 FCR
## 156 FCR
## 161 FCR
## 165 FCR
## 166 FCR
## 168 FCR
## 170 FCR
## 175 FCR
## 180 FCR
## 192 FCR
## 195 FCR
## 204 FCRFrom the table above, it can be inferred that there are 18 Municipalities that have the highest NRW rate. Of the 18 Municipalities, 2 Municipalities have the highest Cash Ratio and Solvency Rate, namely Kabupaten Jombang and Kabupaten Sragen. Although they are not the Municipalities with the highest NRW rate like Kota Bandung and Kota Tegal, but at the initial phase of the Program Loan, the Bank should focus on the PDAMs that can help the Municipalities that may be able to repay the loan.
#Subsetting Healthy Wilayah 3 PDAMs
Wilayah_3_SEHAT <- PDAM_2018_new[PDAM_2018_new$Wilayah == "Wilayah_3" & PDAM_2018_new$Kinerja.Tahun.Buku.2018 == "SEHAT" & PDAM_2018_new$FCR.Non.FCR == "FCR",c("Kabupaten...Kota","Propinsi","Kinerja.Tahun.Buku.2018","Jumlah.Pelanggan","ROE","Cash.Ratio","Solvabilitas","Tingkat.Kehilangan.Air","FCR.Non.FCR")]
summary(Wilayah_3_SEHAT)## Kabupaten...Kota Propinsi Kinerja.Tahun.Buku.2018
## Length:17 Kalimantan Timur :4 KURANG SEHAT: 0
## Class :character Sulawesi Selatan :3 SAKIT : 0
## Mode :character Sulawesi Utara :3 SEHAT :17
## Kalimantan Selatan:2
## Gorontalo :1
## Kalimantan Barat :1
## (Other) :3
## Jumlah.Pelanggan ROE Cash.Ratio Solvabilitas
## Min. : 4876 Min. :-0.02422 Min. : 0.04759 Min. : 2.869
## 1st Qu.: 13297 1st Qu.: 0.02026 1st Qu.: 1.64317 1st Qu.: 6.542
## Median : 19382 Median : 0.02878 Median : 2.59957 Median : 22.698
## Mean : 57203 Mean : 0.04636 Mean : 7.11048 Mean : 35.339
## 3rd Qu.:100504 3rd Qu.: 0.07129 3rd Qu.: 6.79927 3rd Qu.: 37.323
## Max. :174772 Max. : 0.14630 Max. :30.76188 Max. :251.375
##
## Tingkat.Kehilangan.Air FCR.Non.FCR
## Min. :0.1255 FCR :17
## 1st Qu.:0.2287 Non FCR: 0
## Median :0.2972
## Mean :0.3187
## 3rd Qu.:0.3844
## Max. :0.6617
## #Finding out the Healthy Wilayah 3 PDAMs that has the highest NRW (above the 3rd quartile)
Wilayah_3_SEHAT[Wilayah_3_SEHAT$Tingkat.Kehilangan.Air > 0.3844,]## Kabupaten...Kota Propinsi Kinerja.Tahun.Buku.2018
## 291 Kota Samarinda Kalimantan Timur SEHAT
## 298 Kabupaten Bolaang Mongondow Sulawesi Utara SEHAT
## 303 Kabupaten Minahasa Utara Sulawesi Utara SEHAT
## 305 Kota Bitung Sulawesi Utara SEHAT
## 343 Kota Makassar Sulawesi Selatan SEHAT
## Jumlah.Pelanggan ROE Cash.Ratio Solvabilitas Tingkat.Kehilangan.Air
## 291 156278 0.07129206 0.58523611 3.415383 0.3844049
## 298 13297 0.05725450 2.59956528 28.119967 0.4681153
## 303 5822 0.14630479 0.04758463 2.868533 0.6616856
## 305 17948 0.02877656 0.81920159 37.322623 0.4906360
## 343 172033 0.11447747 1.64317063 6.541628 0.4674222
## FCR.Non.FCR
## 291 FCR
## 298 FCR
## 303 FCR
## 305 FCR
## 343 FCRFor Wilayah 3, there are 5 Municipalities that have the highest NRW with majority located in North Sulawesi or Sulawesi Utara. For the sake of operational efficiency, the Bank can cooperate with the Province of North Sulawesi to do a province-level NRW Reduction program to help the PDAMs in the three Municipalities, namely: Kabupaten Bolaang Mongondow, Kabupaten Minahasa Utara, and Kota Bitung.
#Subsetting Healthy Wilayah 4 PDAMs
Wilayah_4_SEHAT <- PDAM_2018_new[PDAM_2018_new$Wilayah == "Wilayah_4" & PDAM_2018_new$Kinerja.Tahun.Buku.2018 == "SEHAT" & PDAM_2018_new$FCR.Non.FCR == "FCR",c("Kabupaten...Kota","Propinsi","Kinerja.Tahun.Buku.2018","Jumlah.Pelanggan","ROE","Cash.Ratio","Solvabilitas","Tingkat.Kehilangan.Air","FCR.Non.FCR")]
summary(Wilayah_4_SEHAT)## Kabupaten...Kota Propinsi Kinerja.Tahun.Buku.2018
## Length:12 Bali :5 KURANG SEHAT: 0
## Class :character Nusa Tenggara Timur:3 SAKIT : 0
## Mode :character Nusa Tenggara Barat:2 SEHAT :12
## Papua :1
## Papua Barat :1
## Aceh :0
## (Other) :0
## Jumlah.Pelanggan ROE Cash.Ratio Solvabilitas
## Min. : 5489 Min. :-0.004814 Min. : 0.1878 Min. : 5.996
## 1st Qu.: 18145 1st Qu.: 0.036847 1st Qu.: 1.4295 1st Qu.: 7.764
## Median : 42707 Median : 0.059709 Median : 2.3484 Median : 10.968
## Mean : 46912 Mean : 0.077375 Mean : 16.7658 Mean : 30.261
## 3rd Qu.: 61993 3rd Qu.: 0.137322 3rd Qu.: 4.8768 3rd Qu.: 28.292
## Max. :135326 Max. : 0.188915 Max. :152.8339 Max. :126.434
##
## Tingkat.Kehilangan.Air FCR.Non.FCR
## Min. :0.1050 FCR :12
## 1st Qu.:0.2277 Non FCR: 0
## Median :0.3336
## Mean :0.3062
## 3rd Qu.:0.3922
## Max. :0.4324
## #Finding out the Healthy Wilayah 4 PDAMs that has the highest NRW (above the 3rd quartile)
Wilayah_4_SEHAT[Wilayah_3_SEHAT$Tingkat.Kehilangan.Air > 0.3922,]## Kabupaten...Kota Propinsi Kinerja.Tahun.Buku.2018
## 232 Kabupaten Kupang Nusa Tenggara Timur SEHAT
## 245 Kota Kupang Nusa Tenggara Timur SEHAT
## 376 Kabupaten Fak-Fak Papua Barat SEHAT
## NA <NA> <NA> <NA>
## Jumlah.Pelanggan ROE Cash.Ratio Solvabilitas Tingkat.Kehilangan.Air
## 232 23805 0.13968366 2.180703 7.215025 0.2367048
## 245 10124 0.00163877 22.748629 126.434125 0.2399394
## 376 5489 0.13653469 9.687148 10.821378 0.4275230
## NA NA NA NA NA NA
## FCR.Non.FCR
## 232 FCR
## 245 FCR
## 376 FCR
## NA <NA>For Wilayah 4, the Bank can aim for providing program loan to Kabupaten Fak-Fak of West Papua Province as it has the most NRW rate of the three Municipalities. Speaking of ROE, cash ratio, and solvency rate, PDAM in Kabupaten Fak-Fak fare pretty well, especially when compared to PDAM in Kabupaten Kupang. However, the number of customers is significantly lower compared to the other two PDAMs. Hence, aside from decreasing NRW rate, the Bank could also aim at investing in a program to improve customer registration.
Conclusion
Based on the mapping that we did, the following are the potential Municipalities that the Bank can aim for the initial phase of Program Loan, namely:
| Wilayah 1 | Wilayah 2 | Wilayah 3 (Provinsi Sulawesi Utara) | Wilayah 4 |
|---|---|---|---|
| Kota Bengkulu | Kabupaten Jombang | Kabupaten Bolaang Mongondow | Kabupaten Fak-Fak |
| Kota Bandar Lampung | Kabupaten Sragen | Kabupaten Minahasa Utara | |
| Kota Bitung |
The following are the potential measures for NRW Reduction that can be implemented in these Municipalities through the Bank’s Program Loan, namely, but not limited to:
improving customer registration;
undertaking surveys of illegal connections;
improving meter management;
improving customer relations and complaints register;
improving leak repair register and response times; and
providing staff incentives for NRW reduction.