Sheet1 TINGKAT PERTUMBUHAN PENDUDUK METODE ARITMATIK DAN GEOMETRIK
Data Jumlah Penduduk Wilayah PerencanaanRasio Pertambahan Penduduk PertahunWilayahJumlah Penduduk ( Jiwa )JumlahRata - Ratar1r2r3r4r rata - rataPertumbuhan ( jiwa ) ( Ka )20082009201020112012Penduduk totKota Kecamatan ( A )419442994446449145972202744052.50%3.42%1.01%2.36%2.32%101Desa 1 ( B )16231716176918191892881917645.73%3.09%2.83%4.01%3.91%67Desa 2 ( C )18201847186119231955940618811.48%0.76%3.33%1.66%1.81%34Desa 3 ( D )210322412254233223981132822666.56%0.58%3.46%2.83%3.36%74
Ka = (P awl - P akhr) / (T awl - T akhr)r = ( P2 - P1 )/P1 x 100%METODE ARITMATIKPERTAMBAHAN PENDUDUK tahun ke -nPn = Po + Ka ( Tn - To )Yi-Ymean(Yi-Ymean)^2Standar Deviasi (S)WilayahPoKar200820092010201120122008200920102011201220082009201020112012JumlahKota Kecamatan ( A )41941012.32%Yi41944295439644964597-211-111-1091192446901224398825436711101996142.83Desa 1 ( B )1623673.91%16231690175818251892-141-74-661128198255410403715164354542495.31Desa 2 ( C )1820341.81%18201854188819211955-61-2764074374575440160454461158948.14Desa 3 ( D )2103743.36%21032177225123242398-163-89-155913226439789422834401753055531105.39
METODE GEOMETRIKS = (( Yi - Yrata-rata )2 / nPERTAMBAHAN PENDUDUK tahun ke -nPn = Po ( 1 + r ) nYi-Ymean(Yi-Ymean)^2Standar Deviasi (S)WilayahPoKar200820092010201120122008200920102011201220082009201020112012JumlahKota Kecamatan ( A )41941012.32%Yi41944291439144934598-211-114-14881924469012982202771536960102549143.21Desa 1 ( B )1623673.91%16231687175318211892-141-77-11571291982559701263290165514576295.67Desa 2 ( C )1820341.81%18201853188619211955-61-2853974374579928155154961161948.21Desa 3 ( D )2103743.36%21032174224723222400-163-92-195613426439846036031881807556522106.32
S = (( Yi - Yrata-rata )2 / nMETODE LAST SQUAREY = A + B x
Wilayah Kota Kecamatan (A)Wilayah Kota Desa 1 (B)Wilayah Kota Desa 2 (C)Wilayah Kota Desa 3 (D)
No.TPT^2P x TNo.TPT^2P x TNo.TPT^2P x TNo.TPT^2P x T2008141941419420081162311623200811820118202008121031210320092429948598200921716434322009218474369420092224144482201034446913338201031769953072010318619558320103225496762201144491161796420114181916727620114192316769220114233216932820125459725229852012518922594602012519552597752012523982511990Jumlah15220275567079Jumlah1588195527098Jumlah1594065528564Jumlah15113285534665Rata - Rata34405.4Rata - Rata31763.8Rata - Rata31881.2Rata - Rata32265.6
NilaiB99.8NilaiB64.1NilaiB34.6NilaiB68.1A4106A1571.5A1777.4A2061.3PERTAMBAHAN PENDUDUK tahun ke -nY = A + B xYi-Ymean(Yi-Ymean)^2Standar Deviasi (S)Wilayah200820092010201120122008200920102011201220082009201020112012JumlahKota Kecamatan ( A )41064206430644054505-299-200-10001008964039840996009960149401172.86Desa 1 ( B )15721636170017641828-192-128-64064369791643541090410961632111.02Desa 2 ( C )17771812184718811916-104-69-350351077447891197011971795759.93Desa 3 ( D )20612129219822662334-204-136-68068417381855046380463869564117.95PERBANDINGAN STANDAR DEVIASIWilayahAritmatikaGeometrikLast SquareKota Kecamatan ( A )142.83143.21172.86Desa 1 ( B )95.3195.67111.02Desa 2 ( C )48.1448.2159.93Desa 3 ( D )105.39106.32117.95
METODE ARITMATIKPERTAMBAHAN PENDUDUK tahun ke -nPn = Po + Ka ( Tn - To )WilayahPoKar200820092010201120122023Kota Kecamatan ( A )40201393.30%Yi402041594298443745766105Desa 1 ( B )1670563.17%167017261781183718922503Desa 2 ( C )1808432.29%180818511894193619792449Desa 3 ( D )2165542.41%216522192273232723812975
PROYEKSI KEBUTUHAN AIR MINUM DI WILAYAH PERENCANAANWilayahJumlah PendudukKebutuhan Air Domestik (l/o/h)Jumlah Kebutuhan Air Minum Wilayah (l/o/h)Kebutuhan Non domestik (15%)KebocoranKebutuhan Air Rata - RataKebutuhan Air Hari Maksimum
Kota Kecamatan ( A )6105120732,600109,890168,4981,010,9881,213,186Desa 1 ( B )2503120300,30045,04569,069414,414497,297Desa 2 ( C )2449120293,91044,08767,599405,596486,715Desa 3 ( D )2975120357,00053,55082,110492,660591,192LAMPIRANNo.UraianSatuanTAHUN2012201320142015201620172018201920202021202220232024202520262027AKependudukan50%60%75%90%NoWilayahJumlah Penduduk Tahun 2008 (Po)Jumlah Penduduk Tahun Proyeksi (Pn)NoWilayahJumlah Penduduk Tahun 2008 (Po)Jumlah Penduduk Tahun Proyeksi (Pn)1Jumlah Penduduk2009201020112012201320142015201620172018201920202021202220232024202520262027-Kota KecamatanJiwa4,5974,6984,7994,8995,0005,1015,2025,3025,4035,5045,6055,7055,8065,9076,0086,108-PedesaanJiwa6,2456,4206,5956,7696,9447,1197,2947,4687,6437,8187,9938,1678,3428,5178,6928,866Kota KecamatanKota Kecamatan2Tingkat pelayanan50%60%60%60%60%60%75%75%75%75%75%90%90%90%90%90%1Kota Kecamatan ( A )419442994446449145974697.754798.54899.2550005100.751Kota Kecamatan ( A )41945201.55302.2554035503.755604.55705.2558065906.756007.56108.253Jumlah Penduduk terlayani tahun ke-nJumlah429944464491459746984799489950005101Jumlah5202530254035504560557055806590760086108-Kota KecamatanJiwa2,2992,8192,8792,9403,0003,0603,9013,9774,0524,1284,2035,1355,2255,3165,4075,497PedesaanPedesaan-PedesaanJiwa3,1233,8523,9574,0624,1664,2715,4705,6015,7325,8635,9947,3517,5087,6657,8227,9802Desa 1 ( B )16231716176918191892195920272094216122282Desa 1 ( B )16232296236324302497256526322699276628342901BKebutuhan Domestik3Desa 2 ( C )18201847186119231955198920232056209021243Desa 2 ( C )182021582191222522592293232623602394242824611Tingkat Konsumsi Pelayanan Domestik4Desa 3 ( D )21032241225423322398247225462619269327674Desa 3 ( D )21032841291429883062313632093283335734313504-Kota Kecamatanlt / org / hr110110110110110110110110110110110110110110110110Jumlah580458846074624564206595676969447119Jumlah7294746876437818799381678342851786928866-Pedesaanlt / org / hr80808080808080808080808080808080Jumlah Total101031033010565108421111811393116691194412220Jumlah Total124951277113046133221359713873141481442414699149752Jumlah Kebutuhan Air-Kota Kecamatanlt / hr252,835310,052316,701323,351330,000336,650429,124437,436445,748454,059462,371564,820574,794584,768594,743604,717-Pedesaanlt / hr249,800308,148316,536324,924333,312341,700437,610448,095458,580469,065479,550588,042600,624613,206625,788638,370NoWilayahJumlah Penduduk Tahun 2008 (Po)Jumlah Penduduk Tahun Proyeksi (Pn)3Total Kebutuhan Air Domestiklt / hr502,635618,200633,237648,275663,312678,350866,734885,531904,328923,124941,9211,152,8621,175,4181,197,9741,220,5311,243,0872009201020112012201320142015201620172018201920202021202220232024202520262027CKebutuhan Non DomestikKota KecamatanProsentase Kebutuhan Non Domestik20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%1Kota Kecamatan ( A )419442994446449145974697.754798.54899.2550005100.755201.55302.2554035503.755604.55705.2558065906.756007.56108.25Total Kebutuhan Air Non Domestiklt / hr100,527123,640126,647129,655132,662135,670173,347177,106180,866184,625188,384230,572235,084239,595244,106248,617Jumlah4299444644914597469847994899500051015202530254035504560557055806590760086108DTotal Kebutuhan Air Dom + Non Domlt / hr603,162741,839759,884777,929795,974814,0191,040,0811,062,6371,085,1931,107,7491,130,3061,383,4341,410,5021,437,5691,464,6371,491,704Pedesaanlt/ dtk6.9818.5868.7959.0049.2139.42212.03812.29912.56012.82113.08216.01216.32516.63916.95217.2652Desa 1 ( B )16231716176918191892195920272094216122282296236324302497256526322699276628342901EKehilangan Air3Desa 2 ( C )18201847186119231955198920232056209021242158219122252259229323262360239424282461Tingkat Kebocoran20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%4Desa 3 ( D )21032241225423322398247225462619269327672841291429883062313632093283335734313504Jumlah Kebocoranlt/ dtk1.3961.7171.7591.8011.8431.8842.4082.4602.5122.5642.6163.2023.2653.3283.3903.453Jumlah5804588460746245642065956769694471197294746876437818799381678342851786928866FKebutuhan Air Rata - ratalt/ dtk8.37710.30310.55410.80511.05511.30614.44614.75915.07215.38515.69919.21419.59019.96620.34220.718Jumlah Total10103103301056510842111181139311669119441222012495127711304613322135971387314148144241469914975GKebutuhan Hari MaksimumFaktor Hari Maksimum1.21.21.21.21.21.21.21.21.21.21.21.21.21.21.21.2Kebutuhan Air pada Hari Maksimumlt/ dtk10.05312.36412.66512.96513.26613.56717.33517.71118.08718.46218.83823.05723.50823.95924.41124.862HKebutuhan Jam puncakFaktor Jam puncak2222222222222222Kebutuhan Air Jam Puncaklt/ dtk20.10524.72825.32925.93126.53227.13434.66935.42136.17336.92537.67746.11447.01747.91948.82149.723IVolume Reservoirlt/ hari2.0112.4732.5332.5932.6532.7133.4673.5423.6173.6923.7684.6114.7024.7924.8824.972m3173.711213.650218.847224.044229.241234.438299.543306.039312.536319.032325.528398.429406.224414.020421.815429.611
Sheet2notpt2pt114020140202242554851033438791316144446816178725545762522880jumlah15217065566443rata234341.2b132.5a3943.7
Sheet3Data Jumlah Penduduk Wilayah PerencanaanWilayahJumlah PendudukPn - PoKaPo (2008)Pn (2012)Wilayahr1r2r3r4r rata - rataKota Kecamatan ( A )41154515400100Kota Kecamatan ( A )2.26%3.64%2.09%1.42%2.35%Desa 1 ( B )1620186024060Desa 1 ( B )5.43%3.16%4.48%1.03%3.53%Desa 2 ( C )1820196214235.5Desa 2 ( C )0.82%1.25%3.07%2.45%1.90%Desa 3 ( D )2108235825062.5Desa 3 ( D )4.74%2.36%3.32%0.99%2.85%
WilayahJumlah Penduduk ( Jiwa )Jumlah Penduduk Total (jiwa)Rata - Rata20082009201020112012Kota Kecamatan ( A )41154208436144524515216514330WilayahPoKaDesa 1 ( B )1620170817621841186087911758Kota Kecamatan ( A )41151004330Desa 2 ( C )1820183518581915196293901878Desa 1 ( B )1620601758Desa 3 ( D )21082208226023352358112692254Desa 2 ( C )1820361878Desa 3 ( D )2108632254
WilayahPoKaJumlah Penduduk pada Tahun Rencana20082009201020112012Kota Kecamatan ( A )411510041154212431144124516Desa 1 ( B )16206016201677173617981861Desa 2 ( C )18203618201855189019261962Desa 3 ( D )21086321082168223022932359
Wilayah20082009201020112012Kota Kecamatan ( A )4330-215.2-115.2-15.284.8184.8Desa 1 ( B )1758-138.2-78.2-18.241.8101.8Desa 2 ( C )1878-58-22.51348.584Desa 3 ( D )2254-145.8-83.3-20.841.7104.2
WilayahJumlah20082009201020112012Wilayah(Yi Ymean)0,5JumlahStandar Deviasi (S)Kota Kecamatan ( A )-215.2-115.2-15.284.8184.8184.820082009201020112012Desa 1 ( B )-138.2-78.2-18.241.8101.8101.8Kota Kecamatan ( A )4631113271231719134151184.892.40Desa 2 ( C )-58-22.51348.58484Desa 1 ( B )190996115331174710363101.850.90Desa 3 ( D )-145.8-83.3-20.841.7104.2104.2Desa 2 ( C )3364506169235270568442.00Desa 3 ( D )212586939433173910858104.252.10
WilayahJumlah Penduduk ( Jiwa)20082009201020112012Kota Kecamatan ( A )3943.74076.24208.74341.24473.7WilayahStandar DeviasiDesa 1 ( B )1617.616711724.41777.81831.2AritmatikaGeometrikLast SquareDesa 2 ( C )1763.61806.818501893.21936.4Kota Kecamatan ( A )142.24142.67223.33Desa 3 ( D )2117.92171.82225.72279.62333.5Desa 1 ( B )86.7887.4782.74Desa 2 ( C )51.8651.8467.20Desa 3 ( D )90.8091.4181.24
Sheet4
