{"text_format":"1","workbook":"xlsx","n_sheets":26,"sheets":["1 - Assumptions","2 - Tariffs control sheet","11 - W sales vol","12 - W production & NRW","21 - W opex","13 - WW sales vol","22 - WW opex","31- W inf renewals","32 - W inf enhancement","33 - W non-inf cap maint","34 - W non-inf enhancement","35 - W business activities","41 - WW inf renewals","42- WW inf enhancement","43 - WW non-inf cap maint","44 - WW non-inf enhancement","45 - WW business activities","51- W RAB","52 - Water income","61 - WW RAB","62 - WW income","81- 2010 Inc-Exp ","82 - 2011 Inc-Exp","83 - 2012 Inc-Exp","84 - 2013 Inc-Exp","85 - 2014 Inc-Exp"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1 - Assumptions","index":0,"n_rows":69,"n_cols":9,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[1,"Assumptions"]
[null,null,null,"Historical","Base year","Year 1","Year 2","Year 3"]
[null,null,null,"(Actual)","(budget forecast)","(Projected)","(Projected)","(Projected)"]
[null,null,"Unit",2010,2011,2012,2013,2014,"Remarks/Shënim"]
[1.1000000000000001,"Inflation indices and expecations"]
[]
["1.1.1","Inflation index"]
["1.1.1.1","Average of preceding year","Index",109.7,"N/A","N/A","N/A","N/A"]
["1.1.1.2","Average of current year","Index",113.5,"N/A","N/A","N/A","N/A"]
["1.1.1.3","Inflation rate","%",3.4639927073837784E-2,8.1509999999999999E-2,2.1000000000000001E-2,1.7999999999999999E-2,1.6E-2]
["1.1.1.4","Adjustment factor to convert 2011 price level expenditure to nominal price levels","Factor","N/A","N/A",1.0209999999999999,1.0393779999999999,1.056008048]
["1.1.1.5","Inflation to end year","%","N/A",4.7E-2,0.02,1.7000000000000001E-2,1.6E-2]
["1.1.1.6","Tariff adjustment factor to convert tariffs from 2011 price levels","Factor","N/A","N/A",1.0469999999999999,1.0679399999999999,1.0860949799999997]
[]
[1.2,"Water tariff assumptions"]
[]
["1.2.1","Cross-subsidy policy"]
["1.1.1.1","Ratio commercial / institutional tariff to domestic","Ratio","N/A","N/A",1.95,1.95,1.9]
[]
["1.2.2","Fixed monthly charges"]
["1.2.2.1","Household (nominal prices)","EUR/con/month",1,1,1,1,1]
["1.2.2.2","Household (base year price levels)","EUR/con/month","N/A","N/A",0.97943192948090119,0.9621138796472507,0.94696247996776628]
["1.2.2.3","Commercial (nominal prices)","EUR/con/month",3,3,3,3,3]
["1.2.2.4","Commercial (base year price levels)","EUR/con/month","N/A","N/A",2.9382957884427037,2.8863416389417518,2.8408874399032986]
["1.2.2.5","Institutional (nominal prices)","EUR/con/month",3,3,3,3,3]
["1.2.2.6","Institutional (base year price levels)","EUR/con/month","N/A","N/A",2.9382957884427037,2.8863416389417518,2.8408874399032986]
[]
["1.2.3","Connection fees (average)"]
["1.2.3.1","Household (nominal prices)","EUR/con",30,30,36,36,36]
["1.2.3.2","Household (base year price levels)","EUR/con","N/A","N/A",35.259549461312439,34.636099667301025,34.090649278839585]
["1.2.3.3","Non-household (nominal prices)","EUR/con",90,90,90,90,90]
["1.2.3.4","Non-household (base year price levels)","EUR/con","N/A","N/A",88.1488736532811,86.590249168252555,85.226623197098959]
[]
["1.2.4","Water tariff smoothing options"]
["1.2.4.1","Tariff option 1 - Unsmoothed","EUR/m3","N/A","N/A","N/A","N/A","N/A"]
["1.2.4.2","Tariff option 2 - Year 1 average tariff (at base year price levels)","EUR/m3","N/A","N/A",0.35,"N/A","N/A"]
["1.2.4.3","Tariff option 3 - Year 1 household tariff (at base year price levels)","EUR/m3","N/A","N/A",0.30014732979334374,"N/A","N/A"]
["1.2.4.4","Tariff option 4 - Uniform household tariff  (at base year price levels)","EUR/m3","N/A","N/A","N/A","N/A","N/A"]
[]
[1.3,"Wastewater tariff assumptions"]
[]
["1.3.1","Cross-subsidy policy"]
["1.1.1.1","Ratio commercial / institutional tariff to domestic","Ratio","N/A","N/A",1.9,1.8,1.8]
[]
["1.3.2","Connection fees (average)"]
["1.3.2.1","Household (nominal prices)","EUR/con",20,20,24,24,24]
["1.3.2.2","Household (base year price levels)","EUR/con","N/A","N/A",23.506366307541629,23.090733111534014,22.727099519226389]
["1.3.2.3","Non-household (nominal prices)","EUR/con",60,60,60,60,60]
["1.3.2.4","Non-household (base year price levels)","EUR/con","N/A","N/A",58.765915768854072,57.726832778835039,56.817748798065978]
[]
["1.3.3","Wastewater tariff smoothing options"]
["1.3.3.1","Tariff option 1 - Unsmoothed","EUR/m3","N/A","N/A","N/A","N/A","N/A"]
["1.3.3.2","Tariff option 2 - Year 1 average tariff (at base year price levels)","EUR/m3","N/A","N/A",7.0000000000000007E-2,"N/A","N/A"]
["1.3.3.3","Tariff option 3 - Year 1 household tariff (at base year price levels)","EUR/m3","N/A","N/A",4.4297875576081183E-2,"N/A","N/A"]
["1.3.3.4","Tariff option 4 - Uniform household tariff  (at base year price levels)","EUR/m3","N/A","N/A","N/A","N/A","N/A"]
[]
[1.4,"Business performance"]
[]
["1.4.1","Revenue collection performance projections"]
["1.4.1.1","Household","% of billing",0.56999999999999995,0.59,0.64,0.66,0.68]
["1.4.1.2","Commercial","% of billing",0.61,0.72,0.79,0.83,0.87]
["1.4.1.3","Institutions","% of billing",0.72,0.86,0.91,0.94,0.97]
[]
["1.4.2","Profitability"]
["1.4.2.1","Expected real rate of return on RAB","% (real)","N/A","N/A",5.2999999999999999E-2,"N/A","N/A"]

{"sheet":"2 - Tariffs control sheet","index":1,"n_rows":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[2,"Control sheet"]
[null,null,null,"Historical","Base year","Year 1","Year 2","Year 3"]
[null,null,null,"(Actual)","(budget forecast)","(Projected)","(Projected)","(Projected)"]
[null,null,"Unit",2010,2011,2012,2013,2014,"Remarks/Shënim"]
[2.1,"Tariffs options"]
[]
[null,"Option 1 - unsmoothed"]
[null,"Option 2 - set average year 1 tariff and allow for annual increases"]
[null,"Option 3 - set household year 1 tariff and allow for annual increases"]
[null,"Option 4 - uniform household tariff"]
[]
["2.1.1","Selection of tariff options"]
["2.1.1.1","Water supply tariff option",null,"N/A","N/A",3,"N/A","N/A"]
["2.1.1.2","Wastewater services tariff option",null,"N/A","N/A",3,"N/A","N/A"]
[]
[2.2000000000000002,"Current tariffs (actuals)"]
[]
["2.2.1","Water"]
["2.2.1.1","Household","EUR/m3",0.24,0.27,"N/A","N/A","N/A"]
["2.2.1.2","Non-household","EUR/m3",0.51,0.56999999999999995,"N/A","N/A","N/A"]
[]
["2.2.2","Wastewater"]
["2.2.2.1","Household","EUR/m3",0.04,0.04,"N/A","N/A","N/A"]
["2.2.2.2","Non-household","EUR/m3",0.08,0.08,"N/A","N/A","N/A"]
[]
[2.2999999999999998,"Tariff schedule (base year price levels)"]
[]
["2.3.1","Water "]
["2.3.1.1","Household","EUR/m3","N/A","N/A",0.30014732979334374,0.33450770619964165,0.37280160241301352]
["2.3.1.2","Non-household","EUR/m3","N/A","N/A",0.58528729309702032,0.65229002708930117,0.70832304458472561]
[]
["2.3.2","Wastewater (volume of water consumed)"]
["2.3.2.1","Household","EUR/m3","N/A","N/A",4.4297875576081183E-2,4.907625099752496E-2,5.4370065847413628E-2]
["2.3.2.2","Non-household","EUR/m3","N/A","N/A",8.4165963594554249E-2,8.8337251795544927E-2,9.7866118525344534E-2]
[]
[2.4,"Tariff schedule nominal price levels (assumed inflation) (rounded)"]
[]
["2.4.1","Water "]
["2.4.1.1","Household - fixed monthly charge","EUR/Con/month",1,1,1,1,1]
["2.4.1.2","Household - volume","EUR/m3",0.24,0.27,0.31,0.36,0.4]
["2.4.1.3","Commercial - fixed monthly charge","EUR/Con/month",3,3,3,3,3]
["2.4.1.4","Commercial - volume","EUR/m3",0.51,0.56999999999999995,0.61,0.7,0.77]
["2.4.1.5","Institutional- fixed monthly charge","EUR/Con/month",3,3,3,3,3]
["2.4.1.6","Institutional - volume","EUR/m3",0.51,0.56999999999999995,0.61,0.7,0.77]
[]
["2.4.2","Wastewater (volume of water consumed)"]
["2.4.2.1","Household","EUR/m3",0.04,0.04,0.05,0.05,0.06]
["2.4.2.2","Commercial","EUR/m3",0.08,0.08,0.09,0.09,0.1]
["2.4.2.3","Institutional","EUR/m3",0.08,0.08,0.09,0.09,0.1]
[]
[2.5,"VAT and bad debts"]
[]
["2.5.1","Recovery of VAT on unpaid bills"]
["2.5.1.1","Include in tariff for cost of VAT on unpaid bills (Y or N)","Y' or 'N' (insert 'P' for yes and 'J' for no)","N/A","N/A","J","J","J"]
[]
["2.5.2","VAT rate"]
["2.5.2.1","VAT rate","%","N/A","N/A",0.16,0.16,0.16]

{"sheet":"11 - W sales vol","index":2,"n_rows":100,"n_cols":9,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[11,"Water sales"]
[null,null,null,"Historical","Base year","Year 1","Year 2","Year 3"]
[null,null,null,"(Actual)","(budget forecast)","(Projected)","(Projected)","(Projected)"]
[null,null,"Unit",2010,2011,2012,2013,2014,"Remarks/Shënim"]
[11.1,"Households"]
[]
["11.1.1","Household properties in service area"]
["11.1.1.1","Household properties in service area at start of year","No",51571,51571,51871,52171,52471]
["11.1.1.2","Household properties in service area at end of year","No",51571,51871,52171,52471,52771]
["11.1.1.3","Average number of household properties in service area over the year","No",51571,51721,52021,52321,52621]
[]
["11.1.2","Households served with water supply"]
["11.1.2.1","Metered households with water supply service at start of year","No",20263,22700,24939,27300,28570]
["11.1.2.2","Metered households with water supply service at end of year","No",22700,24939,27300,28570,29850]
["11.1.2.3","Un-metered households with water supply service at start of year","No",3552,2365,2850,1500,1100]
["11.1.2.4","Un-metered households with water supply service at end of year","No",2365,2850,1500,1100,450]
["11.1.2.5","Total households with water supply at start of year","No",23815,25065,27789,28800,29670]
["11.1.2.6","Total households with water supply at end of year","No",25065,27789,28800,29670,30300]
["11.1.2.7","Average metered households served in year","No",21481.5,23819.5,26119.5,27935,29210]
["11.1.2.8","Average un-metered households served in year","No",2958.5,2607.5,2175,1300,775]
["11.1.2.9","Average total households served in year","No",24440,26427,28294.5,29235,29985]
["11.1.2.10","New household connections in year","No",1250,2724,1011,870,630]
["11.1.2.11","Service coverage","%",0.47390975548273256,0.51095299781520076,0.54390534591799466,0.55876225607308727,0.56982953573668305]
[]
["11.1.3","Household water consumption"]
["11.1.3.1","Average annual metered water billed per metered household","m3/household/year",195,195,195,195,195]
["11.1.3.2","Average annual un-metered water billed per un-metered household","m3/household/year",248,209.625,292.5,292.5,292.5]
["11.1.3.3","Total household metered water billed","m3/year",4188892.5,4644802.5,5093302.5,5447325,5695950]
["11.1.3.4","Total household un-metered water billed","m3/year",733708,546597.1875,636187.5,380250,226687.5]
["11.1.3.5","Total household water billed","m3/year",4922600.5,5191399.6875,5729490,5827575,5922637.5]
[]
[11.2,"Non-household (commercial)"]
[]
["11.2.1","Non-household (commercial) served with water supply"]
["11.2.1.1","Metered commercial with water supply service at start of year","No",2900,3193,3935,4110,4245]
["11.2.1.2","Metered commercial with water supply service at end of year","No",3193,3935,4110,4245,4300]
["11.2.1.3","Un-metered commercial with water supply service at start of year","No",830,705,304,200,100]
["11.2.1.4","Un-metered commercial with water supply service at end of year","No",705,304,200,100,55]
["11.2.1.5","Total commercial with water supply at start of year","No",3730,3898,4239,4310,4345]
["11.2.1.6","Total commercial with water supply at end of year","No",3898,4239,4310,4345,4355]
["11.2.1.7","Average metered commercial served in year","No",3046.5,3564,4022.5,4177.5,4272.5]
["11.2.1.8","Average un-metered commercial served in year","No",767.5,504.5,252,150,77.5]
["11.2.1.9","Average total commercial served in year","No",3814,4068.5,4274.5,4327.5,4350]
["11.2.1.10","New commercial connections in year","No",168,341,71,35,10]
[]
["11.2.2","Non-household (commercial) water consumption"]
["11.2.2.1","Total commercial metered water billed","m3/year",548298,641520,724050,751950,769050]
["11.2.2.2","Total commercial un-metered water billed","m3/year",73336,136215,136080,81000,41850]
["11.2.2.3","Total commercial water billed","m3/year",621634,777735,860130,832950,810900]
[]
[11.3,"Non-household (institutional)"]
[]
["11.3.1","Non-household (institutional) served with water supply"]
["11.3.1.1","Metered institutional with water supply service at start of year","No",497,498,515,572,582]
["11.3.1.2","Metered institutional with water supply service at end of year","No",498,515,572,582,590]
["11.3.1.3","Un-metered institutional with water supply service at start of year","No",45,57,48,0,0]
["11.3.1.4","Un-metered institutional with water supply service at end of year","No",57,48,0,0,0]
["11.3.1.5","Total institutional with water supply at start of year","No",542,555,563,572,582]
["11.3.1.6","Total institutional with water supply at end of year","No",555,563,572,582,590]
["11.3.1.7","Average metered institutional served in year","No",497.5,506.5,543.5,577,586]
["11.3.1.8","Average un-metered institutional served in year","No",51,52.5,24,0,0]
["11.3.1.9","Average total institutional served in year","No",548.5,559,567.5,577,586]
["11.3.1.10","New institutional connections in year","No",13,8,9,10,8]
[]
["11.3.2","Non-household (institutional) water consumption"]
["11.3.2.1","Total institutional metered water billed","m3/year",1020284,1038741.3430000001,1114621.757,1183324.294,1201781.692]
["11.3.2.2","Total institutional un-metered water billed","m3/year",84331,161502.23249999998,147659.18400000001,0,0]
["11.3.2.3","Total institutional water billed","m3/year",1104615,1200243.5755,1262280.9410000001,1183324.294,1201781.692]
[]
[11.4,"Non-household (total)"]
[]
["11.4.1","Non-household served with water supply"]
["11.4.1.1","Average metered non-household served in year","No",3544,4070.5,4566,4754.5,4858.5]
["11.4.1.2","Average un-metered non-household served in year","No",818.5,557,276,150,77.5]
["11.4.1.3","Average total non-household served in year","No",4362.5,4627.5,4842,4904.5,4936]
[]
["11.4.2","Non-household water consumption"]
["11.4.2.3","Total non-household metered water billed","m3/year",1568582,1680261.3430000001,1838671.757,1935274.294,1970831.692]
["11.4.2.4","Total non-household un-metered water billed","m3/year",157667,297717.23249999998,283739.18400000001,81000,41850]
["11.4.2.5","Total non-household water billed","m3/year",1726249,1977978.5755,2122410.9410000001,2016274.294,2012681.692]
[]
[11.5,"Household and non-household"]
[]
["11.5.1","Total served"]
["11.5.1.1","Total metered connections","No",25025.5,27890,30685.5,32689.5,34068.5]
["11.5.1.2","Total un-metered connections","No",3777,3164.5,2451,1450,852.5]
["11.5.1.3","Total connections","no",28802.5,31054.5,33136.5,34139.5,34921]
[]
["11.5.2","Total sales"]
["11.5.2.1","Total metered water billed","m3/year",5757474.5,6325063.8430000003,6931974.2570000002,7382599.2939999998,7666781.6919999998]
["11.5.2.2","Total un-metered water billed","m3/year",891375,844314.41999999993,919926.68400000001,461250,268537.5]
["11.5.2.3","Total water billed","m3/year",6648849.5,7169378.2630000003,7851900.9410000006,7843849.2939999998,7935319.1919999998]
[]
["11.5.3","Seasonal peak demand"]
["11.5.3.1","Seasonal peak factor (peak month sales / average monthly sales)","Factor",1,1,1,1,1]
["11.5.3.2","Peak daily sales","m3/day",18216.02602739726,19642.132227397262,21512.05737260274,21489.998065753425,21740.600526027396]

{"sheet":"12 - W production & NRW","index":3,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[12,"Water production and NRW"]
[null,null,null,"Historical","Base year","Year 1","Year 2","Year 3"]
[null,null,null,"(Actual)","(budget forecast)","(Projected)","(Projected)","(Projected)"]
[null,null,"Unit",2010,2011,2012,2013,2014,"Remarks/Shënim"]
[12.1,"NRW"]
[]
["12.1.1","NRW absolute volumes"]
["12.1.1.1","Estimated volume of commercial losses (illegal connections , meter under-reads etc)","m3/year",4689398,6706859,6663819,6620779,6577739]
["12.1.1.2","Estimated volume of leakages","m3/year",4689398,6706859,6322859,5902859,5902859]
["12.1.1.3","Total NRW in year","m3/year",9378796,13413718,12986678,12523638,12480598]
["12.1.1.4","NRW per connection per day","l/con/day)",892.12156954602244,1183.4005483510318,1073.7386183220135,1005.0333773576463,979.16494882970676]
["12.1.1.5","NRW as percentage of production","%",0.58516367859521223,0.65168611313898317,0.62320362807699192,0.61488380079605121,0.61131703673301219]
[]
[12.2,"Production requirement"]
[]
["12.2.1","Production requirement"]
["12.2.1.1","Water sales","m3/year",6648849.5,7169378.2630000003,7851900.9410000006,7843849.2939999998,7935319.1919999998]
["12.2.1.2","Total NRW","m3/year",9378796,13413718,12986678,12523638,12480598]
["12.2.1.3","Total average production requirement","m3/year",16027645.5,20583096.263,20838578.941,20367487.294,20415917.192000002]
["12.2.1.4","Peak production requirement","m3/day",43911.357534246577,56392.044556164386,57091.997098630134,55801.335052054797,55934.019704109589]
[]
[12.3,"Production capacity"]
[]
["12.3.1","Production capacity"]
["12.3.1.1","Average annual production capacity","m3/year",16122541,20662718,21500000,21800000,22000000]
["12.3.1.2","Maximum production capacity","m3/day",44171,56610,58904,59726,60274]
["12.3.1.3","Seasonal minimum production capacity factor","factor",1,0.9,0.9,0.9,0.9]
["12.3.1.4","Seasonal minimum production capacity","m3/day",44171,50949,53013.599999999999,53753.4,54246.6]
["12.3.1.5","Is production capacity sufficient for average conditions","yes/no (P=Yes, J=No)","P","P","P","P","P"]
["12.3.1.6","Is production capacity sufficient for peak conditions","yes/no (P=Yes, J=No)","P","J","J","J","J"]
["12.3.1.7","Is production capacity sufficient (adjust production requirement to suit)","yes/no (P=Yes, J=No)","P","0","0","0","0"]
[null,"Note: if production capacity insufficient to meet production requirement adjust sales and/or NRW to ensure capacity exceeds requirements."]

{"sheet":"21 - W opex","index":4,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[6,3,6,4],[6,5,6,7]]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[21,"Water supply service operating costs"]
[null,"Note: Report 2010 and 2011 costs as actuals / budget but 2012 to 2014 at base year (mid-2011) price levels"]
[null,null,null,"Actuals",null,"At 2011 price levels"]
[null,null,null,"Historical","Base year","Year 1","Year 2","Year 3"]
[null,null,null,"(Actual)","(budget forecast)","(Projected)","(Projected)","(Projected)"]
[null,null,"Unit",2010,2011,2012,2013,2014,"Remarks/Shënim"]
[21.1,"Direct costs"]
[]
["21.1.1","Water resources and treatment"]
["21.1.1.1","Service charges","EUR/year",14839,33000,33000,33000,33000]
["21.1.1.2","Energy costs","EUR/year",535211,634596,728000,715000,745000]
["21.1.1.3","Fuel costs","EUR/year",21562,25117,28910,30870,31801]
["21.1.1.4","Staff costs","EUR/year",393688,410751,354714,377341,451100]
["21.1.1.5","Materials and consumables","EUR/year",21812,17138,17138,17138,17138]
["21.1.1.6","Contracted services","EUR/year",27000,7800,7800,7800,7800]
["21.1.1.7","Maintenance and repair","EUR/year",11520,8995,9000,9000,9000]
["21.1.1.8","Other direct costs","EUR/year",31304,35547,35547,35547,35547," "]
["21.1.1.9","Total water resources and treatment costs","EUR/year",1056936,1172944,1214109,1225696,1330386]
[]
["21.1.2","Water Distribution"]
["21.1.2.1","Service charges","EUR/year"]
["21.1.2.2","Energy costs","EUR/year",10418,12335,14000,14870,15300]
["21.1.2.3","Fuel costs","EUR/year",11202,15378,17700,18000,19500]
["21.1.2.4","Staff costs","EUR/year",421951,440240,383955,408207,463671]
["21.1.2.5","Materials and consumables","EUR/year",12719,33870,33870,33870,33870]
["21.1.2.6","Contracted services","EUR/year"]
["21.1.2.7","Maintenance and repair","EUR/year",70312,47327,50000,55000,55000]
["21.1.2.8","Other direct costs","EUR/year",41863,50781,50781,50781,50781]
["21.1.2.9","Total water distribution costs","EUR/year",568465,599931,550306,580728,638122]
[]
[21.2,"Indirect costs"]
[]
["21.2.1","Business activities"]
["21.2.1.1","Energy costs","EUR/year",5000,5000,5000,5000,5000]
["21.2.1.2","Fuel costs","EUR/year",9148.59,10657.35,10657.35,10657.35,10657.35]
["21.2.1.3","Staff costs","EUR/year",268458.3,280094.76,280094.76,280094.76,280094.76]
["21.2.1.4","Materials and consumables","EUR/year",34569.81,92054.16,92054.16,92054.16,92054.16]
["21.2.1.5","Contracted services","EUR/year",0,0,0,0,0]
["21.2.1.6","Maintenance and repair","EUR/year",42123.51,28352.61,28352.61,28352.61,28352.61]
["21.2.1.7","Other indirect costs","EUR/year",86443.83,101395.8,101395.8,101395.8,101395.8]
["21.2.1.8","Total business activities costs","EUR/year",445744.04000000004,517554.68,517554.68,517554.68,517554.68]
[]
["21.2.2","Total operating costs excl bad debts"]
["21.2.2.1","Total","EUR/year",2071145.04,2290429.6800000002,2281969.6800000002,2323978.6800000002,2486062.6800000002]

{"sheet":"13 - WW sales vol","index":5,"n_rows":111,"n_cols":9,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[13,"Wastewater sales"]
[null,null,null,"Historical","Base year","Year 1","Year 2","Year 3"]
[null,null,null,"(Actual)","(budget forecast)","(Projected)","(Projected)","(Projected)"]
[null,null,"Unit",2010,2011,2012,2013,2014,"Remarks/Shënim"]
[13.1,"Households"]
[]
["13.1.1","Households served with wastewater collection service "]
["13.1.1.1","Metered households with wastewater service at start of year","No",15179,18867,20691,23516,26550]
["13.1.1.2","Metered households with wastewater service at end of year","No",18867,20691,23516,26550,29500]
["13.1.1.3","Un-metered households with wastewater service at start of year","No",2664,1640,2850,1500,1100]
["13.1.1.4","Un-metered households with wastewater service at end of year","No",1640,2850,1500,1100,450]
["13.1.1.5","Total households with wastewater service at start of year","No",17843,20507,23541,25016,27650]
["13.1.1.6","Total households with wastewater service at end of year","No",20507,23541,25016,27650,29950]
["13.1.1.7","Average metered households served with wastewater service in year","No",17023,19779,22103.5,25033,28025]
["13.1.1.8","Average un-metered households served with wastewater service in year","No",2152,2245,2175,1300,775]
["13.1.1.9","Average total households served in year","No",19175,22024,24278.5,26333,28800]
["13.1.1.10","New household connections in year","No",2664,3034,1475,2634,2300]
["13.1.1.11","Service coverage with wastewater connections","%",0.37181749432820771,0.42582316660544073,0.46670575344572385,0.50329695533342256,0.54731000931187168]
[]
["13.1.2","Household sales from those with wastewater service"]
["13.1.2.1","Metered water billed with wastewater connections","m3/year",3319485,3856905,4310182.5,4881435,5464875]
["13.1.2.2","Un-metered water billed with wastewater connections","m3/year",533696,470608.125,636187.5,380250,226687.5]
["13.1.2.3","Total household water billed with wastewater connections","m3/year",3853181,4327513.125,4946370,5261685,5691562.5]
[]
["13.1.3","Households served with wastewater collection and treatment service "]
["13.1.3.1","Total households with wastewater collection and treatment service at start of year","No",0,0,0,0,0]
["13.1.3.2","Total households with wastewater collection and treatment service at end of year","No",0,0,0,0,0]
["13.1.3.3","Average households served with wastewater collection and treatment service in year","No",0,0,0,0,0]
["13.1.3.4","Service coverage with wastewater collection and treatment","%",0,0,0,0,0]
[]
[13.2,"Non-household (commercial)"]
[]
["13.2.1","Commercial served with wastewater collection service "]
["13.2.1.1","Metered commercial with wastewater service at start of year","No",2900,3193,3935,4110,4245]
["13.2.1.2","Metered commercial with wastewater service at end of year","No",3193,3935,4110,4245,4300]
["13.2.1.3","Un-metered commercial with wastewater service at start of year","No",830,705,304,200,100]
["13.2.1.4","un-metered commercial with wastewater service at end of year","No",705,304,200,100,55]
["13.2.1.5","Total commercial with wastewater service at start of year","No",3730,3898,4239,4310,4345]
["13.2.1.6","Total commercial with wastewater service at end of year","No",3898,4239,4310,4345,4355]
["13.2.1.7","Average metered commercial served with wastewater service in year","No",3046.5,3564,4022.5,4177.5,4272.5]
["13.2.1.8","Average un-metered commercial served with wastewater service in year","No",767.5,504.5,252,150,77.5]
["13.2.1.9","Average total commercial served in year","No",3814,4068.5,4274.5,4327.5,4350]
["13.2.1.10","New commercial connections in year","No",168,341,71,35,10]
[]
["13.2.2","Commercial water sales from those with wastewater services"]
["13.2.2.1","Metered water billed with wastewater connections","m3/year",548298,641520,724050,751950,769050]
["13.2.2.2","Un-metered water billed with wastewater connections","m3/year",73336,136215,136080,81000,41850]
["13.2.2.3","Total commercial water billed with wastewater connections","m3/year",621634,777735,860130,832950,810900]
[]
["13.2.3","Commercial served with wastewater collection and treatment service "]
["13.2.3.1","Total commercial with wastewater treatment service at start of year","No",0,0,0,0,0]
["13.2.3.2","Total commercial with wastewater treatment service at end of year","No",0,0,0,0,0]
["13.2.3.3","Average commercial served with wastewater treatment service in year","No",0,0,0,0,0]
[]
[13.3,"Non-household (institutional)"]
[]
["13.3.1","Institutional served with wastewater collection service "]
["13.3.1.1","Metered institutional with wastewater service at start of year","No",497,498,505,562,572]
["13.3.1.2","Metered institutional with wastewater service at end of year","No",498,505,562,572,580]
["13.3.1.3","Un-metered institutional with wastewater service at start of year","No",45,47,48,0,0]
["13.3.1.4","un-metered institutional with wastewater service at end of year","No",47,48,0,0,0]
["13.3.1.5","Total institutional with wastewater service at start of year","No",542,545,553,562,572]
["13.3.1.6","Total institutional with wastewater service at end of year","No",545,553,562,572,580]
["13.3.1.7","Average metered institutional served with wastewater service in year","No",497.5,501.5,533.5,567,576]
["13.3.1.8","Average un-metered institutional served with wastewater service in year","No",46,47.5,24,0,0]
["13.3.1.9","Average total institutional served in year","No",543.5,549,557.5,567,576]
["13.3.1.10","New institutional connections in year","No",3,8,9,10,8]
[]
["13.3.2","Institutional water sales from those with wastewater service"]
["13.3.2.1","Metered water billed with wastewater connections","m3/year",1020284,1028487.2330000001,1094113.537,1162816.074,1181273.4720000001]
["13.3.2.2","Un-metered water billed with wastewater connections","m3/year",76063.254901960783,146121.06749999998,147659.18400000001,0,0]
["13.3.2.3","Total institutional water billed with wastewater connections","m3/year",1096347.2549019607,1174608.3005000001,1241772.7209999999,1162816.074,1181273.4720000001]
[]
["13.3.3","Institutional served with wastewater collection and treatment service "]
["13.3.3.1","Total institutional with wastewater treatment service at start of year","No",0,0,0,0,0]
["13.3.3.2","Total institutional with wastewater treatment service at end of year","No",0,0,0,0,0]
["13.3.3.3","Average institutional served with wastewater treatment service in year","No",0,0,0,0,0]
[]
[13.4,"Non-household (total)"]
[]
["13.4.1","Non-household served with wastewater collection service"]
["13.4.1.1","Average metered non-household with wastewater connections","No",3544,4065.5,4556,4744.5,4848.5]
["13.4.1.2","Average un-metered non-household with wastewater connections","No",813.5,552,276,150,77.5]
["13.4.1.3","Average total non-household with wastewater connections","No",4357.5,4617.5,4832,4894.5,4926]
[]
["13.4.2","Non-household water sales from those with wastewater service"]
["13.4.2.1","Total non-household metered water billed from those with wastewater service","m3/year",1568582,1670007.233,1818163.537,1914766.074,1950323.4720000001]
["13.4.2.2","Total non-household un-metered water billed from those with wastewater service","m3/year",149399.25490196078,282336.0675,283739.18400000001,81000,41850]
["13.4.2.3","Total non-household water billed from those with wastewater service","m3/year",497,498,505,562,572]
[]
["13.4.3","Non-household served with wastewater collection and treatment service "]
["13.4.3.3","Average non-household with wastewater treatment service in year","No",0,0,0,0,0]
[]
[13.5,"Household and non-household"]
[]
["13.5.1","Total served with wastewater collection service"]
["13.5.1.1","Total metered connections with wastewater collection services","No",20567,23844.5,26659.5,29777.5,32873.5]
["13.5.1.2","Total un-metered connections with wastewater collection services","No",2965.5,2797,2451,1450,852.5]
["13.5.1.3","Total connections","no",23532.5,26641.5,29110.5,31227.5,33726]
[]
["13.5.2","Total sales from those with wastewater service"]
["13.5.2.1","Total metered water billed from those with wastewater service","m3/year",4888067,5526912.233,6128346.0370000005,6796201.074,7415198.4720000001]
["13.5.2.2","Total un-metered water billed from those with wastewater service","m3/year",683095.25490196072,752944.1925,919926.68400000001,461250,268537.5]
["13.5.2.3","Total water billed from those with wastewater service","m3/year",5571162.2549019605,6279856.4254999999,7048272.7210000008,7257451.074,7683735.9720000001]
[]
["13.5.3","Total served with wastewater collection and treatment service "]
["13.5.3.3","Average total with wastewater collection and treatment service in year","No",0,0,0,0,0]

{"sheet":"22 - WW opex","index":6,"n_rows":59,"n_cols":9,"rows_kept":59,"cut":false,"hidden":false,"merged":[[6,3,6,4],[6,5,6,7]]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[22,"Wastewater services operating costs"]
[null,"Note: Report 2010 and 2011 costs as actuals / budget but 2012 to 2014 at base year (mid-2011) price levels"]
[null,null,null,"Actuals",null,"At 2011 price levels"]
[null,null,null,"Historical","Base year","Year 1","Year 2","Year 3"]
[null,null,null,"(Actual)","(budget forecast)","(Projected)","(Projected)","(Projected)"]
[null,null,"Unit",2010,2011,2012,2013,2014,"Remarks/Shënim"]
[22.1,"Direct costs"]
[]
["22.1.1","Wastewater collection"]
["22.1.1.1","Service charges","EUR/year"]
["22.1.1.2","Energy costs","EUR/year",606,718,830,880,910]
["22.1.1.3","Fuel costs","EUR/year",5439,6336,7100,7530,7730]
["22.1.1.4","Staff costs","EUR/year",9220,96186,81944,87242,92806]
["22.1.1.5","Materials and consumables","EUR/year"]
["22.1.1.6","Contracted services","EUR/year"]
["22.1.1.7","Maintenance and repair","EUR/year",1280,1070,1070,1070,1070]
["22.1.1.8","Other direct costs","EUR/year"]
["22.1.1.9","Total wastewater collection costs ","EUR/year",16545,104310,90944,96722,102516]
[]
["22.1.2","Wastewater treatment"]
["22.1.2.1","Service charges","EUR/year",0,0,0,0,0]
["22.1.2.2","Energy costs","EUR/year",0,0,0,0,0]
["22.1.2.3","Fuel costs","EUR/year",0,0,0,0,0]
["22.1.2.4","Staff costs","EUR/year",0,0,0,0,0]
["22.1.2.5","Materials and consumables","EUR/year",0,0,0,0,0]
["22.1.2.6","Contracted services","EUR/year",0,0,0,0,0]
["22.1.2.7","Maintenance and repair","EUR/year",0,0,0,0,0]
["22.1.2.8","Other direct costs","EUR/year",0,0,0,0,0]
["22.1.2.9","Total Wastewater treatment costs","EUR/year",0,0,0,0,0]
[]
["22.1.3","Sludge treatment and disposal"]
["22.1.3.1","Service charges","EUR/year",0,0,0,0,0]
["22.1.3.2","Energy costs","EUR/year",0,0,0,0,0]
["22.1.3.3","Fuel costs","EUR/year",0,0,0,0,0]
["22.1.3.4","Staff costs","EUR/year",0,0,0,0,0]
["22.1.3.5","Materials and consumables","EUR/year",0,0,0,0,0]
["22.1.3.6","Contracted services","EUR/year",0,0,0,0,0]
["22.1.3.7","Maintenance and repair","EUR/year",0,0,0,0,0]
["22.1.3.8","Other direct costs","EUR/year",0,0,0,0,0]
["22.1.3.9","Total sludge treatment costs","EUR/year",0,0,0,0,0]
[]
[22.2,"Indirect costs"]
[]
["22.2.1","Business activities"]
["22.2.1.1","Energy costs","EUR/year",0,0,0,0,0]
["22.2.1.2","Fuel costs","EUR/year",92.41,107.65,107.65,107.65,107.65]
["22.2.1.3","Staff costs","EUR/year",2711.7000000000003,2829.2400000000002,32142.239999999998,32142.239999999998,32142.239999999998]
["22.2.1.4","Materials and consumables","EUR/year",349.19,929.84,929.84,929.84,929.84]
["22.2.1.5","Contracted services","EUR/year",0,0,0,0,0]
["22.2.1.6","Maintenance and repair","EUR/year",425.49,286.39,286.39,286.39,286.39]
["22.2.1.7","Other indirect costs","EUR/year",873.17000000000007,1024.2,1024.2,1024.2,1024.2]
["22.2.1.8","Total business activities costs","EUR/year",4451.96,5177.3200000000006,34490.319999999992,34490.319999999992,34490.319999999992]
[]
["22.2.2","Total operating costs excl bad debts"]
["22.2.2.1","Total","EUR/year",20996.959999999999,109487.32,125434.31999999999,131212.32,137006.32]

{"sheet":"31- W inf renewals","index":7,"n_rows":54,"n_cols":48,"rows_kept":54,"cut":false,"hidden":false,"merged":[[9,21,9,23],[9,15,9,20],[9,12,9,14],[9,6,9,11],[9,3,9,5],[9,42,9,47],[9,39,9,41],[9,33,9,38],[9,30,9,32],[9,24,9,29],[6,12,6,20],[7,12,7,20],[8,12,8,20],[6,3,6,11],[7,3,7,11],[8,3,8,11],[6,21,6,29],[7,21,7,29],[8,21,8,29],[6,39,6,47],[8,39,8,47],[7,39,7,47],[6,30,6,38],[8,30,8,38],[7,30,7,38]]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[31,"Water supply infrastructure renewals"]
[null,"Note: Report 2010 and 2011 costs as actuals / budget but 2012 to 2014 at base year (mid-2011) price levels"]
[null,null,null,"Historical",null,null,null,null,null,null,null,null,"Base year",null,null,null,null,null,null,null,null,"Year 1",null,null,null,null,null,null,null,null,"Year 2",null,null,null,null,null,null,null,null,"Year 3"]
[null,null,null,"(Actual)",null,null,null,null,null,null,null,null,"(budget forecast)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)"]
[null,null,null,2010,null,null,null,null,null,null,null,null,2011,null,null,null,null,null,null,null,null,2012,null,null,null,null,null,null,null,null,2013,null,null,null,null,null,null,null,null,2014]
[null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed"]
[null,null,"Unit","RWC cash reserve","Loans to RWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed"]
[31.1,"Water resources and treatment"]
["31.1.1","Infrastructure renewals expenditure and sources of finance"]
["31.1.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.2","14 Drenazhimi dhe rrjeti i ujesjellesit ne Savrove-Suhareke","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,461092,null,461092,461092,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,461092,0,461092,461092,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[31.2,"Water distribution"]
["31.2.1","Infrastructure renewals expenditure and sources of finance"]
["31.2.1.1","1 Rehabilitimi i rrjetit te ujesjellesit ne Kurille-Prizren","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,36676,null,36676,36676,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.2","2 Rehabilitimi i rrjetit ne Fsh. Atmaxhe-Prizren","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,206480,null,206480,206480,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.3","3 Rehabilitimi i rrjetit ne rrugen Emin Kuk, Prizren","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,49948,null,49948,49948,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.4","4 Rehabilitimi i rrjetit ne rrugen \"Hysen Rexhepi\", Prizren","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,47415,null,47415,47415,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.5","5 Rehabilitimi i rrjetit ne rrugen \"Leka I Madh\", Prizren","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,29179,null,29179,29179,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.6","6 Rehabilitimi i rrjetit ne rrugen \"Sahat Kulla\", Prizren","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,84902,null,84902,84902,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.7","7 Rehabilitimi i rrjetit ne fshatin Tupec, Prizren","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,183177,null,183177,183177,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.8","8 Rehabilitimi i rrjetit ne fshatin Vlashne, Prizren","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,288038,null,288038,288038,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.9","111.Nderrimi i gypit transportues prej lokacionit Pusi i Atit deri tek rezervari \nne Shirokë","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,500000,500000,null,1000000,1000000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.10","114 Rehabilitimi i rrjetit te ujesjellesit ne rrugen\"Nena Tereze dhe Janina\" ","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,472000,null,472000,472000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.11","14 Drenazhimi dhe rrjeti i ujesjellesit ne Savrove-Suareke","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,127978.8,null,127978.8,127978.8,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.12","16 Rehabilitimi i rrjetit te ujesjellesit ne Rr. Emin Duraku dhe Bujar Godeni dhe Aziz Ismail-Prizren","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,206390.6,null,206390.6,206390.6,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.13","114 Rehabilitimi i rrjetit te ujesjellesit ne rruget: Fetah Gega dhe Kadri Nesho - Prizren","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,110000,null,null,null,110000,110000]
["31.2.1.14","58 Ndrrimi i gypit O125-Dragash","EUR/year",null,null,0,null,null,null,null,0,0,288,null,288,null,null,null,null,0,288,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.15","70 Rehabilitimi i rrjetit te ujesjellesit ne rrugen\"Muhaxheret\" \"Kadri Nesho\", \"Dy Korriku\" dhe \"Hasan Prishtina\"-Prizren","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,171900,null,171900,null,null,null,null,0,171900,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.16","73 Rehabilitimi i rrjetit te ujesjellesit-Suhareke","EUR/year",null,null,0,null,null,null,null,0,0,25000,null,25000,null,null,87333,null,87333,112333,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.17",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.18","78 Rehabilitimi i disa rrugeve ne qytetin e Prizrenit","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.19","107 Hulumtimi i humbjeve teknike dhe komerciale dhe rehabilitimi i rrjetit te ujesjellesit regjional","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,100000,null,100000,null,null,null,null,0,100000]
["31.2.1.20","Adjustment to min level of infrastructure renewals or tariff headroom min of 4%","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,0,null,0,null,null,null,null,0,0,0,null,0,null,null,null,null,0,0]
["31.2.1.21","Totals","EUR/year",0,0,0,0,0,0,0,0,0,25288,0,25288,0,0,1347517.4000000001,0,1347517.4000000001,1372805.4000000001,171900,0,171900,0,500000,972000,0,1472000,1643900,0,0,0,0,0,0,0,0,0,100000,0,100000,110000,0,0,0,110000,210000]
[]
[31.3,"Total water supply infrastructure renewals"]
["31.3.1","Infrastructure renewals expenditure and sources of finance"]
["31.3.1.1","Water resources and treatment","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,461092,0,461092,461092,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["31.3.1.2","Water distribution","EUR/year",0,0,0,0,0,0,0,0,0,25288,0,25288,0,0,1347517.4000000001,0,1347517.4000000001,1372805.4000000001,171900,0,171900,0,500000,972000,0,1472000,1643900,0,0,0,0,0,0,0,0,0,100000,0,100000,110000,0,0,0,110000,210000]
["31.3.1.3","Totals","EUR/year",0,0,0,0,0,0,0,0,0,25288,0,25288,0,0,1808609.4000000001,0,1808609.4000000001,1833897.4000000001,171900,0,171900,0,500000,972000,0,1472000,1643900,0,0,0,0,0,0,0,0,0,100000,0,100000,110000,0,0,0,110000,210000]

{"sheet":"32 - W inf enhancement","index":8,"n_rows":84,"n_cols":48,"rows_kept":84,"cut":false,"hidden":false,"merged":[[6,30,6,38],[6,39,6,47],[9,30,9,32],[9,33,9,38],[9,39,9,41],[9,42,9,47],[7,30,7,38],[7,39,7,47],[8,30,8,38],[8,39,8,47],[9,12,9,14],[9,15,9,20],[9,21,9,23],[9,24,9,29],[6,3,6,11],[6,12,6,20],[6,21,6,29],[7,3,7,11],[7,12,7,20],[7,21,7,29],[8,3,8,11],[8,12,8,20],[8,21,8,29],[9,3,9,5],[9,6,9,11]]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[32,"Water supply infrastructure enhancement"]
[null,"Note: Report 2010 and 2011 costs as actuals / budget but 2012 to 2014 at base year (mid-2011) price levels"]
[null,null,null,"Historical",null,null,null,null,null,null,null,null,"Base year",null,null,null,null,null,null,null,null,"Year 1",null,null,null,null,null,null,null,null,"Year 2",null,null,null,null,null,null,null,null,"Year 3"]
[null,null,null,"(Actual)",null,null,null,null,null,null,null,null,"(budget forecast)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)"]
[null,null,null,2010,null,null,null,null,null,null,null,null,2011,null,null,null,null,null,null,null,null,2012,null,null,null,null,null,null,null,null,2013,null,null,null,null,null,null,null,null,2014]
[null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed"]
[null,null,"Unit","RWC cash reserve","Loans to RWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed"]
[32.1,"Water resources and treatment"]
["32.1.1","Level of service improvement (including backlog infrastructure renewals), expenditure and sources of finance"]
["32.1.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.1.2","76 Shfrytezimi Burimit  \"Guri i Zi\" -Prizren","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,10000,null,10000,null,null,null,null,0,10000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10000,0,10000,0,0,0,0,0,10000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["32.1.2","Supply demand balance, expenditure and sources of finance"]
["32.1.2.1","60 Kaptimi i burimeve ne fshatin Skorrobisht","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,75000,null,null,null,75000,75000,null,null,0,null,null,null,null,0,0,null,null,0,54831.5,54831.5,54831.5,null,164494.5,164494.5,null,null,0,null,null,null,null,0,0]
["32.1.2.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.2.3","Siç është siguruar nga ZRRUM ","EUR/year",0,null,0,null,null,4044,null,4044,4044,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.2.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.2.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.2.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.2.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.2.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.2.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.2.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.2.11","Totals","EUR/year",0,0,0,0,0,4044,0,4044,4044,0,0,0,75000,0,0,0,75000,75000,0,0,0,0,0,0,0,0,0,0,0,0,54831.5,54831.5,54831.5,0,164494.5,164494.5,0,0,0,0,0,0,0,0,0]
[]
[32.200000000000003,"Water Distribution"]
["32.2.1","Level of service improvement (including backlog infrastructure renewals), expenditure and sources of finance"]
["32.2.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.1.6","15 Pusi nr.4 te \"Pusi iAtit\" suhareke","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,21000,null,21000,21000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.1.8","101 Rehabilitimi i  rrjetit të ujësjellësit PE100 Ø 90mm/10bar,Rr.”Kadri Nesho” L=470m, PE100 Ø 110mm/10bar dhe Rr.”Rrasat e Koshares” L=590, dhe Rr.”EditDurham” L=450m,\nPE100 Ø 225 mm/10bar\n\n","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,31500,null,31500,null,null,null,null,0,31500,50000,null,50000,70000,null,null,null,70000,120000,103500,null,103500,null,null,null,null,0,103500]
["32.2.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,21000,0,21000,21000,31500,0,31500,0,0,0,0,0,31500,50000,0,50000,70000,0,0,0,70000,120000,103500,0,103500,0,0,0,0,0,103500]
[]
["32.2.2","Supply demand balance, expenditure and sources of finance"]
["32.2.2.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.3","54 Injektimi i kaptazhes se V-te ne gypin furnizues O400","EUR/year",null,null,0,null,null,null,null,0,0,33303,null,33303,null,null,null,null,0,33303,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.4","57 Ndertimi i rrjetit te ujesjellesit-Malisheve","EUR/year",null,null,0,null,null,null,null,0,0,3644,null,3644,null,null,null,null,0,3644,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.5","75 Zgjerimi i rrjetit te ujesjellesit","EUR/year",null,null,0,null,null,null,null,0,0,20000,null,20000,null,null,null,null,0,20000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.6","76 Shfrytezimi Burimit   \"Guri I ZI\" -Prizren","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,858133,858133,null,null,1716266,1716266,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.8","Siç ësbtë siguruar nga ZRRUM ","EUR/year",0,null,0,null,null,76845,null,76845,76845,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.11",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.12",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.13",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.14",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.15",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.16",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.17",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.18",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.19",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.20",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.21","Totals","EUR/year",0,0,0,0,0,76845,0,76845,76845,56947,0,56947,0,0,0,0,0,56947,0,0,0,858133,858133,0,0,1716266,1716266,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[32.299999999999997,"Total water supply infrastructure enhancement"]
["32.3.1","Infrastructure enhancement expenditure and sources of finance"]
["32.3.1.1","Water resources and treatment - level of service","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10000,0,10000,0,0,0,0,0,10000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["32.3.1.2","Water resources and treatment  - supply demand balance","EUR/year",0,0,0,0,0,4044,0,4044,4044,0,0,0,75000,0,0,0,75000,75000,0,0,0,0,0,0,0,0,0,0,0,0,54831.5,54831.5,54831.5,0,164494.5,164494.5,0,0,0,0,0,0,0,0,0]
["32.3.1.3","Total water resources and treatment ","EUR/year",0,0,0,0,0,4044,0,4044,4044,0,0,0,75000,0,0,0,75000,75000,10000,0,10000,0,0,0,0,0,10000,0,0,0,54831.5,54831.5,54831.5,0,164494.5,164494.5,0,0,0,0,0,0,0,0,0]
["32.3.1.4","Water distribution - level of service","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,21000,0,21000,21000,31500,0,31500,0,0,0,0,0,31500,50000,0,50000,70000,0,0,0,70000,120000,103500,0,103500,0,0,0,0,0,103500]
["32.3.1.5","Water Distribution  - supply demand balance","EUR/year",0,0,0,0,0,76845,0,76845,76845,56947,0,56947,0,0,0,0,0,56947,0,0,0,858133,858133,0,0,1716266,1716266,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["32.3.1.6","Total water distribution","EUR/year",0,0,0,0,0,76845,0,76845,76845,56947,0,56947,0,0,21000,0,21000,77947,31500,0,31500,858133,858133,0,0,1716266,1747766,50000,0,50000,70000,0,0,0,70000,120000,103500,0,103500,0,0,0,0,0,103500]
["32.3.1.7","Totals","EUR/year",0,0,0,0,0,80889,0,80889,80889,56947,0,56947,75000,0,21000,0,96000,152947,41500,0,41500,858133,858133,0,0,1716266,1757766,50000,0,50000,124831.5,54831.5,54831.5,0,234494.5,284494.5,103500,0,103500,0,0,0,0,0,103500]

{"sheet":"33 - W non-inf cap maint","index":9,"n_rows":44,"n_cols":48,"rows_kept":44,"cut":false,"hidden":false,"merged":[[8,30,8,38],[9,3,9,5],[9,6,9,11],[9,12,9,14],[9,15,9,20],[9,21,9,23],[9,24,9,29],[9,30,9,32],[9,33,9,38],[9,39,9,41],[9,42,9,47],[6,3,6,11],[6,12,6,20],[6,21,6,29],[6,30,6,38],[6,39,6,47],[8,39,8,47],[7,3,7,11],[7,12,7,20],[7,21,7,29],[7,30,7,38],[7,39,7,47],[8,3,8,11],[8,12,8,20],[8,21,8,29]]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[33,"Water supply non-infrastructure capital maintenance"]
[null,"Note: Report 2010 and 2011 costs as actuals / budget but 2012 to 2014 at base year (mid-2011) price levels"]
[null,null,null,"Historical",null,null,null,null,null,null,null,null,"Base year",null,null,null,null,null,null,null,null,"Year 1",null,null,null,null,null,null,null,null,"Year 2",null,null,null,null,null,null,null,null,"Year 3"]
[null,null,null,"(Actual)",null,null,null,null,null,null,null,null,"(budget forecast)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)"]
[null,null,null,2010,null,null,null,null,null,null,null,null,2011,null,null,null,null,null,null,null,null,2012,null,null,null,null,null,null,null,null,2013,null,null,null,null,null,null,null,null,2014]
[null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed"]
[null,null,"Unit","RWC cash reserve","Loans to RWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed"]
[33.1,"Water resources and treatment"]
["33.1.1","Non-infrastructure capital maintenance expenditure and sources of finance"]
["33.1.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0]
["33.1.1.2","10 Rehabilitimi i Stacionit te filtrimit dhe paisjet laboratorike","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,218762.2,null,218762.2,218762.2,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.1.1.3","59 Rehabilitimi i objektit te laboratorit-Prizren","EUR/year",null,null,0,null,null,null,null,0,0,4500,null,4500,null,null,null,null,0,4500,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.1.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.1.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.1.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.1.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.1.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.1.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.1.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.1.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,4500,0,4500,0,0,0,0,0,4500,0,0,0,0,0,218762.2,0,218762.2,218762.2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[33.200000000000003,"Water Distribution"]
["33.2.1","Non-infrastructure capital maintenance expenditure and sources of finance"]
["33.2.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.2.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.2.1.3","12 Rehabilitimi gjeneral i bunarit I dhe  II","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,648221.19999999995,null,648221.19999999995,648221.19999999995,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.2.1.4","11 Rehabilitimi i hapsires se rezervarit ne Malisheve","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,57324.41,null,57324.41,57324.41,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.2.1.5","56 Nderrimi motorrave te pompave-Malisheve","EUR/year",null,null,0,null,null,null,null,0,0,3000,null,3000,null,null,null,null,0,3000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.2.1.6","61 Ndrrimi i ujematesve ne rrugen \"Remzi Ademi\"-Prizren","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,25000,null,null,null,25000,25000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.2.1.7","103 Ndrrimi i ujematesve neper fshatra ","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,50000,null,50000,null,null,null,null,0,50000,50000,null,50000,null,null,null,null,0,50000,50000,null,50000,null,null,null,null,0,50000]
["33.2.1.8","116 Instalimi i Ujematesve Zonal ne nivel regjional","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,173996.6,null,173996.6,173996.6,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.2.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.2.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.2.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,3000,0,3000,25000,0,705545.61,0,730545.61,733545.61,50000,0,50000,0,0,173996.6,0,173996.6,223996.6,50000,0,50000,0,0,0,0,0,50000,50000,0,50000,0,0,0,0,0,50000]
[]
[33.299999999999997,"Total water supply non-infrastructure capital maintenance"]
["33.3.1","Non-infrastructure capital maintenance expenditure and sources of finance"]
["33.3.1.1","Water resources and treatment","EUR/year",0,0,0,0,0,0,0,0,0,4500,0,4500,0,0,0,0,0,4500,0,0,0,0,0,218762.2,0,218762.2,218762.2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["33.3.1.2","Water Distribution","EUR/year",0,0,0,0,0,0,0,0,0,3000,0,3000,25000,0,705545.61,0,730545.61,733545.61,50000,0,50000,0,0,173996.6,0,173996.6,223996.6,50000,0,50000,0,0,0,0,0,50000,50000,0,50000,0,0,0,0,0,50000]
["33.3.1.3","Totals","EUR/year",0,0,0,0,0,0,0,0,0,7500,0,7500,25000,0,705545.61,0,730545.61,738045.61,50000,0,50000,0,0,392758.80000000005,0,392758.80000000005,442758.80000000005,50000,0,50000,0,0,0,0,0,50000,50000,0,50000,0,0,0,0,0,50000]

{"sheet":"34 - W non-inf enhancement","index":10,"n_rows":88,"n_cols":48,"rows_kept":88,"cut":false,"hidden":false,"merged":[[6,30,6,38],[6,39,6,47],[9,3,9,5],[9,6,9,11],[9,12,9,14],[9,15,9,20],[8,3,8,11],[8,12,8,20],[6,3,6,11],[6,12,6,20],[6,21,6,29],[9,42,9,47],[9,21,9,23],[9,24,9,29],[9,30,9,32],[9,33,9,38],[9,39,9,41],[7,3,7,11],[7,12,7,20],[7,21,7,29],[7,30,7,38],[7,39,7,47],[8,21,8,29],[8,30,8,38],[8,39,8,47]]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[34,"Water supply non-infrastructure enhancement"]
[null,"Note: Report 2010 and 2011 costs as actuals / budget but 2012 to 2014 at base year (mid-2011) price levels"]
[null,null,null,"Historical",null,null,null,null,null,null,null,null,"Base year",null,null,null,null,null,null,null,null,"Year 1",null,null,null,null,null,null,null,null,"Year 2",null,null,null,null,null,null,null,null,"Year 3"]
[null,null,null,"(Actual)",null,null,null,null,null,null,null,null,"(budget forecast)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)"]
[null,null,null,2010,null,null,null,null,null,null,null,null,2011,null,null,null,null,null,null,null,null,2012,null,null,null,null,null,null,null,null,2013,null,null,null,null,null,null,null,null,2014]
[null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed"]
[null,null,"Unit","RWC cash reserve","Loans to RWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed"]
[34.1,"Water resources and treatment"]
["34.1.1","Quality improvement, expenditure and sources of finance"]
["34.1.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["34.1.2","Level of service improvement (including backlog infrastructure renewals), expenditure and sources of finance"]
["34.1.2.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["34.1.3","Supply demand balance, expenditure and sources of finance"]
["34.1.3.1","15 Pusi nr.4 te \"Pusi i Atit\" suhareke","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,49000,null,49000,49000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.3.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.3.3","104 Shpimi i pusit per lagjen Arbana kah Autostrada e Re","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,30000,null,30000,null,30000,null,null,30000,60000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.3.4","105 Kaptimet tek lokaconi “40 Burimet”, kaptimi i burimit tek “kaptazha e IV”, kaptimi i burimit tek “Hidrocentrali” me rreth 40l/s","EUR/year",null,null,0,null,null,null,null,0,0,30000,null,30000,null,null,null,null,0,30000,30000,null,30000,null,null,40000,null,40000,70000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.3.5","106 Hulumtimi i burimeve te reja per uje te pijes per Prizren dhe Fshatra","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,30000,null,30000,null,null,null,null,0,30000,null,null,0,30000,null,null,null,30000,30000,30000,null,30000,null,null,null,null,0,30000]
["34.1.3.6","Siç ësbtë siguruar nga ZRRUM ","EUR/year",35942,null,35942,null,null,38922,null,38922,74864,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.3.7","113 Sigurimi i burimeve te reja per fshatin Gjonaj, KK Prizren","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,120000,null,null,null,120000,120000,null,null,0,null,null,null,null,0,0]
["34.1.3.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.3.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.3.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.3.11","Totals","EUR/year",35942,0,35942,0,0,38922,0,38922,74864,30000,0,30000,0,0,49000,0,49000,79000,90000,0,90000,0,30000,40000,0,70000,160000,0,0,0,150000,0,0,0,150000,150000,30000,0,30000,0,0,0,0,0,30000]
[]
[34.200000000000003,"Water distribution"]
["34.2.1","Level of service improvement (including backlog infrastructure renewals), expenditure and sources of finance"]
["34.2.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["34.2.2","Supply demand balance, expenditure and sources of finance"]
["34.2.2.1","Siç ësbtë siguruar nga ZRRUM ","EUR/year",4228,null,4228,null,null,4579,null,4579,8807,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.2.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.2.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.2.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.2.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.2.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.2.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.2.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.2.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.2.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.2.11","Totals","EUR/year",4228,0,4228,0,0,4579,0,4579,8807,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[34.299999999999997,"Total water supply non-infrastructure enhancement"]
["34.3.1","Infrastructure enhancement expenditure and sources of finance"]
["34.3.1.1","Water resources and treatment - quality improvments","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["34.3.1.2","Water resources and treatment - level of service improvements","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["34.3.1.3","Water resources and treatment  - supply demand balance","EUR/year",35942,0,35942,0,0,38922,0,38922,74864,30000,0,30000,0,0,49000,0,49000,79000,90000,0,90000,0,30000,40000,0,70000,160000,0,0,0,150000,0,0,0,150000,150000,30000,0,30000,0,0,0,0,0,30000]
["34.3.1.4","Total Water resources and treatment ","EUR/year",35942,0,35942,0,0,38922,0,38922,74864,30000,0,30000,0,0,49000,0,49000,79000,90000,0,90000,0,30000,40000,0,70000,160000,0,0,0,150000,0,0,0,150000,150000,30000,0,30000,0,0,0,0,0,30000]
["34.3.1.5","Water distribution - level of service","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["34.3.1.6","Water distribution  - supply demand balance","EUR/year",4228,0,4228,0,0,4579,0,4579,8807,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["34.3.1.7","Total Water distribution ","EUR/year",4228,0,4228,0,0,4579,0,4579,8807,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["34.3.1.8","Totals","EUR/year",40170,0,40170,0,0,43501,0,43501,83671,30000,0,30000,0,0,49000,0,49000,79000,90000,0,90000,0,30000,40000,0,70000,160000,0,0,0,150000,0,0,0,150000,150000,30000,0,30000,0,0,0,0,0,30000]

{"sheet":"35 - W business activities","index":11,"n_rows":24,"n_cols":48,"rows_kept":24,"cut":false,"hidden":false,"merged":[[7,3,7,11],[7,12,7,20],[7,21,7,29],[7,30,7,38],[7,39,7,47],[9,24,9,29],[9,30,9,32],[9,33,9,38],[9,39,9,41],[9,42,9,47],[9,3,9,5],[9,6,9,11],[9,12,9,14],[9,15,9,20],[9,21,9,23],[8,3,8,11],[8,12,8,20],[8,21,8,29],[8,30,8,38],[8,39,8,47],[6,3,6,11],[6,12,6,20],[6,21,6,29],[6,30,6,38],[6,39,6,47]]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[35,"Water supply business activities investment"]
[null,"Note: Report 2010 and 2011 costs as actuals / budget but 2012 to 2014 at base year (mid-2011) price levels"]
[null,null,null,"Historical",null,null,null,null,null,null,null,null,"Base year",null,null,null,null,null,null,null,null,"Year 1",null,null,null,null,null,null,null,null,"Year 2",null,null,null,null,null,null,null,null,"Year 3"]
[null,null,null,"(Actual)",null,null,null,null,null,null,null,null,"(budget forecast)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)"]
[null,null,null,2010,null,null,null,null,null,null,null,null,2011,null,null,null,null,null,null,null,null,2012,null,null,null,null,null,null,null,null,2013,null,null,null,null,null,null,null,null,2014]
[null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed"]
[null,null,"Unit","RWC cash reserve","Loans to RWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed"]
[35.1,"Water business activities"]
["35.1.1","Investment"]
["35.1.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["35.1.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["35.1.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["35.1.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["35.1.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["35.1.1.6","Siç ësbtë siguruar nga ZRRUM ","EUR/year",2114,null,2114,null,null,2290,null,2290,4404,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["35.1.1.7","112.Ndertimi i objekteve per administrate ne njesite e \nSuharekes dhe Malisheves ","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,118800,null,null,null,118800,118800,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["35.1.1.8","115 Programi MIS-Sistemi informativ Menaxherial","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,289080,null,289080,289080,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["35.1.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["35.1.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["35.1.1.11","Totals","EUR/year",2114,0,2114,0,0,2290,0,2290,4404,0,0,0,0,0,0,0,0,0,0,0,0,118800,0,289080,0,407880,407880,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"41 - WW inf renewals","index":12,"n_rows":59,"n_cols":48,"rows_kept":59,"cut":false,"hidden":false,"merged":[[9,30,9,32],[9,33,9,38],[9,39,9,41],[9,42,9,47],[9,3,9,5],[9,6,9,11],[9,12,9,14],[9,15,9,20],[9,21,9,23],[9,24,9,29],[8,39,8,47],[6,3,6,11],[6,12,6,20],[6,21,6,29],[6,30,6,38],[6,39,6,47],[7,3,7,11],[7,12,7,20],[7,21,7,29],[7,30,7,38],[7,39,7,47],[8,3,8,11],[8,12,8,20],[8,21,8,29],[8,30,8,38]]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[41,"Wastewater services infrastructure renewals"]
[null,"Note: Report 2010 and 2011 costs as actuals / budget but 2012 to 2014 at base year (mid-2011) price levels"]
[null,null,null,"Historical",null,null,null,null,null,null,null,null,"Base year",null,null,null,null,null,null,null,null,"Year 1",null,null,null,null,null,null,null,null,"Year 2",null,null,null,null,null,null,null,null,"Year 3"]
[null,null,null,"(Actual)",null,null,null,null,null,null,null,null,"(budget forecast)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)"]
[null,null,null,2010,null,null,null,null,null,null,null,null,2011,null,null,null,null,null,null,null,null,2012,null,null,null,null,null,null,null,null,2013,null,null,null,null,null,null,null,null,2014]
[null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed"]
[null,null,"Unit","RWC cash reserve","Loans to RWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed"]
[41.1,"Wastewater collection"]
["41.1.1","Infrastructure renewals expenditure and sources of finance"]
["41.1.1.1","89 Rehabilitimi i rrjetit te kanalizimit ne Dragash","EUR/year",null,null,0,null,null,null,null,0,0,12000,null,12000,null,null,null,null,0,12000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.1.1.2","90 Rehabilitimi i rrjetit te kanalizimit ne Prizren","EUR/year",null,null,0,null,null,null,null,0,0,41000,null,41000,null,null,null,null,0,41000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.1.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.1.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,700000,null,700000,700000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.1.1.5","110 Rehabilitimi i rrjetit te vjeter te qytetit te Prizrenit","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,100000,null,100000,100000,null,null,null,100000,200000,100000,null,100000,null,null,null,null,0,100000,null,null,0,null,null,null,null,0,0]
["41.1.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.1.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.1.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.1.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.1.1.10","Adjustment to min level of infrastructure renewals or tariff headroom min of 10%","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,17923.340096550695,null,17923.340096550695,null,null,null,null,0,17923.340096550695,17923.340096550695,null,17923.340096550695,null,null,null,null,0,17923.340096550695,17923.340096550695,null,17923.340096550695,null,null,null,null,0,17923.340096550695]
["41.1.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,53000,0,53000,0,0,0,0,0,53000,117923.3400965507,0,117923.3400965507,100000,0,700000,0,800000,917923.34009655064,117923.3400965507,0,117923.3400965507,0,0,0,0,0,117923.3400965507,17923.340096550695,0,17923.340096550695,0,0,0,0,0,17923.340096550695]
[]
[41.2,"Wastewater treatment"]
["41.2.1","Infrastructure renewals expenditure and sources of finance"]
["41.2.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.2.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.2.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.2.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.2.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.2.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.2.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.2.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.2.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.2.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.2.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[41.3,"Sludge treatment and disposal"]
["41.3.1","Infrastructure renewals expenditure and sources of finance"]
["41.3.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.3.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.3.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.3.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.3.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.3.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.3.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.3.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.3.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.3.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.3.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[41.4,"Total wastewater services infrastructure renewals"]
["41.4.1","Infrastructure renewals expenditure and sources of finance"]
["41.4.1.1","Wastewater collection","EUR/year",0,0,0,0,0,0,0,0,0,53000,0,53000,0,0,0,0,0,53000,117923.3400965507,0,117923.3400965507,100000,0,700000,0,800000,917923.34009655064,117923.3400965507,0,117923.3400965507,0,0,0,0,0,117923.3400965507,17923.340096550695,0,17923.340096550695,0,0,0,0,0,17923.340096550695]
["41.4.1.2","Wastewater treatment","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["41.4.1.3","Sludge treatment and disposal","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["41.4.1.4","Totals","EUR/year",0,0,0,0,0,0,0,0,0,53000,0,53000,0,0,0,0,0,53000,117923.3400965507,0,117923.3400965507,100000,0,700000,0,800000,917923.34009655064,117923.3400965507,0,117923.3400965507,0,0,0,0,0,117923.3400965507,17923.340096550695,0,17923.340096550695,0,0,0,0,0,17923.340096550695]

{"sheet":"42- WW inf enhancement","index":13,"n_rows":132,"n_cols":48,"rows_kept":132,"cut":false,"hidden":false,"merged":[[9,33,9,38],[9,39,9,41],[9,42,9,47],[8,3,8,11],[8,12,8,20],[8,21,8,29],[9,3,9,5],[9,6,9,11],[9,12,9,14],[9,15,9,20],[8,30,8,38],[8,39,8,47],[9,21,9,23],[9,24,9,29],[9,30,9,32],[7,3,7,11],[7,12,7,20],[7,21,7,29],[7,30,7,38],[7,39,7,47],[6,3,6,11],[6,12,6,20],[6,21,6,29],[6,30,6,38],[6,39,6,47]]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[42,"Wastewater services infrastructure enhancement"]
[null,"Note: Report 2010 and 2011 costs as actuals / budget but 2012 to 2014 at base year (mid-2011) price levels"]
[null,null,null,"Historical",null,null,null,null,null,null,null,null,"Base year",null,null,null,null,null,null,null,null,"Year 1",null,null,null,null,null,null,null,null,"Year 2",null,null,null,null,null,null,null,null,"Year 3"]
[null,null,null,"(Actual)",null,null,null,null,null,null,null,null,"(budget forecast)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)"]
[null,null,null,2010,null,null,null,null,null,null,null,null,2011,null,null,null,null,null,null,null,null,2012,null,null,null,null,null,null,null,null,2013,null,null,null,null,null,null,null,null,2014]
[null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed"]
[null,null,"Unit","RWC cash reserve","Loans to RWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed"]
[42.1,"Wastewater Collection"]
["42.1.1","Level of service improvement (including backlog infrastructure renewals), expenditure and sources of finance"]
["42.1.1.1","91 Kolektori per largimin e ujrave te zeza nga Lumbardhi ana e majte","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,342000,null,342000,342000,null,null,0,null,null,182000,null,182000,182000]
["42.1.1.2","92 Kolektori per largimin e ujrave te zeza nga Lumbardhi ana e djathte","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,550000,null,550000,550000,null,null,0,null,null,358000,null,358000,358000]
["42.1.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.1.10",null,"EUR/year"]
["42.1.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,892000,0,892000,892000,0,0,0,0,0,540000,0,540000,540000]
[]
["42.1.2","Supply demand balance, expenditure and sources of finance"]
["42.1.2.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.2.2","78 Zgjerimi i rrjetit te kanalizimit ne Malisheve","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,35000,null,35000,null,26000,null,null,26000,61000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.2.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.2.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.2.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.2.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.2.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.2.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.2.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.2.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.2.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,35000,0,35000,0,26000,0,0,26000,61000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[42.2,"Wastewater treatment"]
["42.2.1","Quality impriovement, expenditure and sources of finance"]
["42.2.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["42.2.2","Level of service improvement (including backlog infrastructure renewals), expenditure and sources of finance"]
["42.2.2.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.2.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.2.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.2.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.2.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.2.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.2.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.2.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.2.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.2.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.2.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["42.2.3","Supply demand balance, expenditure and sources of finance"]
["42.2.3.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.3.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.3.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.3.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.3.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.3.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.3.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.3.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.3.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.3.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.3.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[42.3,"Sludge treatment and disposal"]
["42.3.1","Quality impriovement, expenditure and sources of finance"]
["42.3.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["42.3.2","Level of service improvement (including backlog infrastructure renewals), expenditure and sources of finance"]
["42.3.2.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.2.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.2.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.2.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.2.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.2.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.2.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.2.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.2.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.2.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.2.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["42.3.3","Supply demand balance, expenditure and sources of finance"]
["42.3.3.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.3.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.3.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.3.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.3.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.3.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.3.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.3.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.3.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.3.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.3.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[42.4,"Total wastewater infrastructure enhancement"]
["42.4.1","Infrastructure enhancement expenditure and sources of finance"]
["42.4.1.1","Wastewater Collection - level of service improvement","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,892000,0,892000,892000,0,0,0,0,0,540000,0,540000,540000]
["42.4.1.2","Wastewater Collection - supply demand balance","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,35000,0,35000,0,26000,0,0,26000,61000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.3","Total Wastewater Collection","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,35000,0,35000,0,26000,0,0,26000,61000,0,0,0,0,0,892000,0,892000,892000,0,0,0,0,0,540000,0,540000,540000]
["42.4.1.4","Wastewater treatment - quality improvement","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.5","Wastewater treatment - level of service improvement","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.6","Wastewater treatment -  supply demand balance","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.7","Total Wastewater treatment","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.8","Sludge treatment and disposal - quality improvement","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.9","Sludge treatment and disposal - level of service improvement","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.10","Sludge treatment and disposal - supply demand balance","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.11","Total sludge treatment and disposal ","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.12","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,35000,0,35000,0,26000,0,0,26000,61000,0,0,0,0,0,892000,0,892000,892000,0,0,0,0,0,540000,0,540000,540000]

{"sheet":"43 - WW non-inf cap maint","index":14,"n_rows":59,"n_cols":48,"rows_kept":59,"cut":false,"hidden":false,"merged":[[7,3,7,11],[7,12,7,20],[7,21,7,29],[7,30,7,38],[7,39,7,47],[9,3,9,5],[9,6,9,11],[9,12,9,14],[9,15,9,20],[9,21,9,23],[9,24,9,29],[9,30,9,32],[9,33,9,38],[9,39,9,41],[9,42,9,47],[6,3,6,11],[6,12,6,20],[6,21,6,29],[6,30,6,38],[6,39,6,47],[8,3,8,11],[8,12,8,20],[8,21,8,29],[8,30,8,38],[8,39,8,47]]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[43,"Wastewater services non-infrastructure capital maintenance"]
[null,"Note: Report 2010 and 2011 costs as actuals / budget but 2012 to 2014 at base year (mid-2011) price levels"]
[null,null,null,"Historical",null,null,null,null,null,null,null,null,"Base year",null,null,null,null,null,null,null,null,"Year 1",null,null,null,null,null,null,null,null,"Year 2",null,null,null,null,null,null,null,null,"Year 3"]
[null,null,null,"(Actual)",null,null,null,null,null,null,null,null,"(budget forecast)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)"]
[null,null,null,2010,null,null,null,null,null,null,null,null,2011,null,null,null,null,null,null,null,null,2012,null,null,null,null,null,null,null,null,2013,null,null,null,null,null,null,null,null,2014]
[null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed"]
[null,null,"Unit","RWC cash reserve","Loans to RWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed"]
[43.1,"Wastewater collection"]
["43.1.1","Non-infrastructure capital maintenance expenditure and sources of finance"]
["43.1.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.1.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.1.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.1.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.1.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.1.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.1.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.1.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.1.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.1.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.1.1.21","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[43.2,"Wastewater treatment"]
["43.2.1","Non-infrastructure capital maintenance expenditure and sources of finance"]
["43.2.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.2.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.2.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.2.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.2.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.2.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.2.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.2.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.2.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.2.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.2.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[43.3,"Sludge treatment and disposal"]
["43.3.1","Non-infrastructure capital maintenance expenditure and sources of finance"]
["43.3.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.3.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.3.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.3.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.3.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.3.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.3.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.3.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.3.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.3.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["43.3.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[43.4,"Total wastewater services non-infrastructure capital maintenance"]
["43.4.1","Non-infrastructure capital maintenance expenditure and sources of finance"]
["43.4.1.1","Wastewater collection","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["43.4.1.2","Wastewater treatment","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["43.4.1.3","Sludge treatment and disposal","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["43.4.1.4","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"44 - WW non-inf enhancement","index":15,"n_rows":132,"n_cols":48,"rows_kept":132,"cut":false,"hidden":false,"merged":[[7,3,7,11],[7,12,7,20],[7,21,7,29],[7,30,7,38],[7,39,7,47],[8,3,8,11],[8,12,8,20],[8,21,8,29],[8,30,8,38],[8,39,8,47],[9,3,9,5],[9,6,9,11],[9,12,9,14],[9,15,9,20],[9,21,9,23],[9,24,9,29],[9,30,9,32],[9,33,9,38],[9,39,9,41],[9,42,9,47],[6,3,6,11],[6,12,6,20],[6,21,6,29],[6,30,6,38],[6,39,6,47]]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[44,"Wastewater services non-infrastructure enhancement"]
[null,"Note: Report 2010 and 2011 costs as actuals / budget but 2012 to 2014 at base year (mid-2011) price levels"]
[null,null,null,"Historical",null,null,null,null,null,null,null,null,"Base year",null,null,null,null,null,null,null,null,"Year 1",null,null,null,null,null,null,null,null,"Year 2",null,null,null,null,null,null,null,null,"Year 3"]
[null,null,null,"(Actual)",null,null,null,null,null,null,null,null,"(budget forecast)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)"]
[null,null,null,2010,null,null,null,null,null,null,null,null,2011,null,null,null,null,null,null,null,null,2012,null,null,null,null,null,null,null,null,2013,null,null,null,null,null,null,null,null,2014]
[null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed"]
[null,null,"Unit","RWC cash reserve","Loans to RWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed"]
[44.1,"Wastewater Collection"]
["44.1.1","Level of service improvement (including backlog infrastructure renewals), expenditure and sources of finance"]
["44.1.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.1.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.1.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.1.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.1.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.1.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.1.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.1.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.1.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.1.1.10",null,"EUR/year"]
["44.1.2.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["44.1.2","Supply demand balance, expenditure and sources of finance"]
["44.1.3.1","Sic eshte siguruar nga ZRRUM","EUR/year",3941,null,3941,null,null,6158,null,6158,10099,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.1.3.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.1.3.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.1.3.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.1.3.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.1.3.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.1.3.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.1.3.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.1.3.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.1.3.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.1.3.11","Totals","EUR/year",3941,0,3941,0,0,6158,0,6158,10099,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[44.2,"Wastewater treatment"]
["44.2.1","Quality impriovement, expenditure and sources of finance"]
["44.2.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["44.2.2","Level of service improvement (including backlog infrastructure renewals), expenditure and sources of finance"]
["44.2.2.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.2.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.2.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.2.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.2.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.2.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.2.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.2.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.2.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.2.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.2.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["44.2.3","Supply demand balance, expenditure and sources of finance"]
["44.2.3.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.3.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.3.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.3.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.3.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.3.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.3.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.3.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.3.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.3.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.3.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[44.3,"Sludge treatment and disposal"]
["44.3.1","Quality impriovement, expenditure and sources of finance"]
["44.3.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["44.3.2","Level of service improvement (including backlog infrastructure renewals), expenditure and sources of finance"]
["44.3.2.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.2.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.2.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.2.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.2.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.2.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.2.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.2.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.2.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.2.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.2.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["44.3.3","Supply demand balance, expenditure and sources of finance"]
["44.3.3.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.3.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.3.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.3.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.3.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.3.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.3.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.3.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.3.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.3.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.3.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[44.4,"Total wastewater non-infrastructure enhancement"]
["44.4.1","Non-infrastructure enhancement expenditure and sources of finance"]
["44.4.1.1","Wastewater Collection - level of service improvement","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["44.4.1.2","Wastewater Collection - supply demand balance","EUR/year",3941,0,3941,0,0,6158,0,6158,10099,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["44.4.1.3","Total wastewater collection","EUR/year",3941,0,3941,0,0,6158,0,6158,10099,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["44.4.1.4","Wastewater treatment - quality improvement","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["44.4.1.5","Wastewater treatment - level of service improvement","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["44.4.1.6","Wastewater treatment -  supply demand balance","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["44.4.1.7","Total wastewater treatment ","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["44.4.1.8","Sludge treatment and disposal - quality improvement","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["44.4.1.9","Sludge treatment and disposal - level of service improvement","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["44.4.1.10","Sludge treatment and disposal - supply demand balance","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["44.4.1.11","Total sludge treatment and disposal ","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["44.4.1.12","Totals","EUR/year",3941,0,3941,0,0,6158,0,6158,10099,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"45 - WW business activities","index":16,"n_rows":24,"n_cols":48,"rows_kept":24,"cut":false,"hidden":false,"merged":[[7,3,7,11],[7,12,7,20],[7,21,7,29],[7,30,7,38],[7,39,7,47],[9,3,9,5],[9,6,9,11],[9,12,9,14],[9,15,9,20],[9,21,9,23],[9,24,9,29],[9,30,9,32],[9,33,9,38],[9,39,9,41],[9,42,9,47],[8,3,8,11],[8,12,8,20],[8,21,8,29],[8,30,8,38],[8,39,8,47],[6,3,6,11],[6,12,6,20],[6,21,6,29],[6,30,6,38],[6,39,6,47]]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[45,"Wastewater services business activities investment"]
[null,"Note: Report 2010 and 2011 costs as actuals / budget but 2012 to 2014 at base year (mid-2011) price levels"]
[null,null,null,"Historical",null,null,null,null,null,null,null,null,"Base year",null,null,null,null,null,null,null,null,"Year 1",null,null,null,null,null,null,null,null,"Year 2",null,null,null,null,null,null,null,null,"Year 3"]
[null,null,null,"(Actual)",null,null,null,null,null,null,null,null,"(budget forecast)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)"]
[null,null,null,2010,null,null,null,null,null,null,null,null,2011,null,null,null,null,null,null,null,null,2012,null,null,null,null,null,null,null,null,2013,null,null,null,null,null,null,null,null,2014]
[null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed"]
[null,null,"Unit","RWC cash reserve","Loans to RWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed"]
[45.1,"Wastewater business activities"]
["45.1.1","Investment"]
["45.1.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["45.1.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["45.1.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["45.1.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["45.1.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["45.1.1.6","Sic eshte siguruar nga ZRRUM","EUR/year",438,null,438,null,null,684,null,684,1122,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["45.1.1.7","112.Ndertimi i objekteve per administrate ne njesite e SU dhe MA","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,1200,null,null,null,1200,1200,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["45.1.1.8","115 Programi MIS-Sistemi informativ Menaxherial","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,2920,null,2920,2920,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["45.1.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["45.1.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["45.1.1.11","Totals","EUR/year",438,0,438,0,0,684,0,684,1122,0,0,0,0,0,0,0,0,0,0,0,0,1200,0,2920,0,4120,4120,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"51- W RAB","index":17,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[51,"Water Regulatory Asset Base (RAB)"]
[null,null,null,"Historical","Base year","Year 1","Year 2","Year 3"]
[null,null,null,"(Actual)","(budget forecast)","(Projected)","(Projected)","(Projected)"]
[null,null,"Unit",2010,2011,2012,2013,2014,"Remarks/Shënime"]
[51.1,"Water resources and treatment"]
[]
["51.1.1","Infrastructure"]
["51.1.1.1","Opening RAB at prior year price levels","EUR",200934,207894.33910665452,224839.80668723793,239771.44262766992,244087.32859496798]
["51.1.1.2","Indexation adjustment","EUR",6960.3391066545209,16945.467580583409,4721.6359404319965,4315.8859672980579,3905.397257519488]
["51.1.1.3","Opening RAB at current year price levels","EUR",207894.33910665452,224839.80668723793,229561.44262766992,244087.32859496798,247992.72585248746]
["51.1.1.4","Additions (net of disposals and grants)","EUR",0,0,10209.999999999998,0,0]
["51.1.1.5","Closing RAB at current year price levels","EUR",207894.33910665452,224839.80668723793,239771.44262766992,244087.32859496798,247992.72585248746]
[]
["51.1.2","Non-infrastructure"]
["51.1.2.1","Opening RAB at prior year price levels","EUR",1302761,1344805.9875765073,1446873.3772346152,1525627.6404949266,1508714.9683660113]
["51.1.2.2","Indexation adjustment","EUR",45127.546034639985,109615.13604736111,30384.34092192692,27461.297528908675,24139.439493856182]
["51.1.2.3","Opening RAB at current year price levels","EUR",1347888.5460346399,1454421.1236238685,1477257.7181565422,1553088.9380238352,1532854.4078598674]
["51.1.2.4","Additions (net of disposals and grants)","EUR",35942,34500,91889.999999999985,0,31680.241440000002]
["51.1.2.5","Depreciation","EUR",-39024.558458132567,-42047.746389253385,-43520.077661615491,-44373.969657823865,-44248.415102281928]
["51.1.2.6","Closing RAB at current year price levels","EUR",1344805.9875765073,1446873.3772346152,1525627.6404949266,1508714.9683660113,1520286.2341975856]
["51.1.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-42624.953635274724,-42692.812102838303,-41901.58889990006]
[]
[51.2,"Water distribution"]
[]
["51.2.1","Infrastructure"]
["51.2.1.1","Opening RAB at prior year price levels","EUR",3817738,3949984.1659070193,4328894.3752701003,4451962.6571507724,4584066.8849794865]
["51.2.1.2","Indexation adjustment","EUR",132246.16590701931,321963.20936308114,90906.781880672119,80135.327828713896,73345.070159671784]
["51.2.1.3","Opening RAB at current year price levels","EUR",3949984.1659070193,4271947.3752701003,4419801.1571507724,4532097.9849794861,4657411.9551391583]
["51.2.1.4","Additions (net of disposals and grants)","EUR",0,56947,32161.499999999996,51968.899999999994,109296.832968]
["51.2.1.5","Closing RAB at current year price levels","EUR",3949984.1659070193,4328894.3752701003,4451962.6571507724,4584066.8849794865,4766708.7881071586]
[]
["51.2.2","Non-infrastructure"]
["51.2.2.1","Opening RAB at prior year price levels","EUR",153266,158212.0052611017,169176.21250107884,218114.51545035574,266923.0473933632]
["51.2.2.2","Indexation adjustment","EUR",5309.1230628988214,12895.860548832399,3552.7004625226559,3926.0612781064033,4270.7687582938115]
["51.2.2.3","Opening RAB at current year price levels","EUR",158575.12306289881,171107.8658099341,172728.9129636015,222040.57672846215,271193.81615165703]
["51.2.2.4","Additions (net of disposals and grants)","EUR",4228,3000,51049.999999999993,51968.899999999994,52800.402399999999]
["51.2.2.5","Depreciation","EUR",-4591.1178017971088,-4931.6533088552605,-5664.3975132457563,-7086.4293350989192,-8502.6862100473445]
["51.2.2.6","Closing RAB at current year price levels","EUR",158212.0052611017,169176.21250107884,218114.51545035574,266923.0473933632,315491.53234160971]
["51.2.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-5547.8917857451097,-6817.9520204381079,-8051.7248198541611]
[]
[51.3,"Business activities"]
[]
["51.3.2","Non-infrastructure"]
["51.3.2.1","Opening RAB at prior year price levels","EUR",76633,79106.002630550851,83109.534821967987,82430.411194565619,81516.61120760873]
["51.3.2.2","Indexation adjustment","EUR",2654.5615314494107,6447.9302744161996,1745.3002312613278,1483.747401502181,1304.2657793217397]
["51.3.2.3","Opening RAB at current year price levels","EUR",79287.561531449406,85553.932904967049,84854.835053229312,83914.158596067806,82820.876986930467]
["51.3.2.4","Additions (net of disposals and grants)","EUR",2114,0,0,0,0]
["51.3.2.5","Depreciation","EUR",-2295.5589008985544,-2444.3980829990587,-2424.4238586636948,-2397.5473884590801,-2366.3107710551562]
["51.3.2.6","Closing RAB at current year price levels","EUR",79106.002630550851,83109.534821967987,82430.411194565619,81516.61120760873,80454.566215875311]
["51.3.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-2374.5581377705143,-2306.7136195484995,-2240.8075161328279]
[]
[51.4,"Summary"]
["51.4.1","Totals"]
["51.4.1.1","Opening RAB at prior year price levels","EUR",5551332,5740002.5004818337,6252893.3065149998,6517906.6669182908,6685308.8405414382]
["51.4.1.2","Indexation adjustment","EUR",192297.73564266204,467867.60381427431,131310.75943681502,117322.32000452922,106964.941448663]
["51.4.1.3","Opening RAB at current year price levels","EUR",5743629.7356426623,6207870.1042961078,6384204.0659518158,6635228.9869228192,6792273.7819901006]
["51.4.1.4","Additions (net of disposals and grants)","EUR",42284,94447,185311.49999999997,103937.79999999999,193777.47680800001]
["51.4.1.5","Depreciation","EUR",-45911.235160828233,-49423.797781107707,-51608.89903352494,-53857.946381381866,-55117.412083384428]
["51.4.1.6","Closing RAB at current year price levels","EUR",5740002.5004818337,6252893.3065149998,6517906.6669182908,6685308.8405414382,6930933.8467147164]
["51.4.1.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-50547.403558790349,-51817.477742824914,-52194.121235887054]

{"sheet":"52 - Water income","index":18,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[52,"Water income (nominal price levels)"]
[null,null,null,"Historical","Base year","Year 1","Year 2","Year 3"]
[null,null,null,"(Actual)","(budget forecast)","(Projected)","(Projected)","(Projected)"]
[null,null,"Unit",2010,2011,2012,2013,2014,"Remarks/Shënime"]
[52.1,"Tariff income"]
[]
["52.1.1","Households"]
["52.1.1.1","Fixed monthly charges","EUR",293280,317124,339534,350820,359820]
["52.1.1.2","Volume charges","EUR",1181424.1199999999,1401677.9156250001,1776141.9,2097927,2369055]
["52.1.1.3","Total household water tariff income","EUR",1474704.1199999999,1718801.9156250001,2115675.9,2448747,2728875]
[]
["52.1.2","Commercial"]
["52.1.2.1","Fixed monthly charges","EUR",137304,146466,153882,155790,156600]
["52.1.2.2","Volume charges","EUR",317033.34000000003,443308.94999999995,524679.30000000005,583065,624393]
["52.1.2.3","Total commercial water tariff income","EUR",454337.34,589774.94999999995,678561.3,738855,780993]
[]
["52.1.3","Institutional"]
["52.1.3.1","Fixed monthly charges","EUR",19746,20124,20430,20772,21096]
["52.1.3.2","Volume charges","EUR",563353.65,684138.83803499991,769991.37401000003,828327.00579999993,925371.90284]
["52.1.3.3","Total institutional water tariff income","EUR",583099.65,704262.83803499991,790421.37401000003,849099.00579999993,946467.90284]
[]
["52.1.4","Total water tariff income"]
["52.1.4.1","Household","EUR",1474704.1199999999,1718801.9156250001,2115675.9,2448747,2728875]
["52.1.4.2","Commercial","EUR",454337.34,589774.94999999995,678561.3,738855,780993]
["52.1.4.3","Institutional","EUR",583099.65,704262.83803499991,790421.37401000003,849099.00579999993,946467.90284]
["52.1.4.3","Total water tariff income","EUR",2512141.11,3012839.7036600001,3584658.5740100001,4036701.0057999999,4456335.9028399996]
[]
[52.2,"Connection fees"]
[]
["52.2.1","Connection fees"]
["52.2.1.1","Household","EUR",37500,81720,36396,31320,22680]
["52.2.1.2","Commercial","EUR",15120,30690,6390,3150,900]
["52.2.1.3","Institutional","EUR",39,24,27,30,24]
["52.2.1.4","Total connection fee income","EUR",52659,112434,42813,34500,23604]
[]
[52.3,"Total income from customers"]
[]
["52.3.1","Total income from customers"]
["52.3.1.1","Tariff income","EUR",2512141.11,3012839.7036600001,3584658.5740100001,4036701.0057999999,4456335.9028399996]
["52.3.1.2","Connection fees","EUR",52659,112434,42813,34500,23604]
["52.3.1.3","Total income from customers","EUR",2564800.11,3125273.7036600001,3627471.5740100001,4071201.0057999999,4479939.9028399996]
[]
[52.4,"Cash collection"]
[]
["52.4.1","Cash collection by category (excluding connection fees), excluding VAT"]
["52.4.1.1","Household","EUR",840581.3483999999,1014093.13021875,1354032.5759999999,1616173.02,1855635.0000000002]
["52.4.1.2","Commercial","EUR",277145.77740000002,424637.96399999998,536063.42700000003,613249.65,679463.91]
["52.4.1.3","Institutional","EUR",419831.74800000002,605666.04071009986,719283.45034910005,798153.06545199989,918073.86575479992]
["52.4.1.4","Total cash collection","EUR",1537558.8738000002,2044397.13492885,2609379.4533491,3027575.7354520001,3453172.7757548001]
[]
[52.5,"Provisions for debts write off (offset by 12 months)"]
[]
["52.4.1","Write-off provisions (excluding VAT)"]
["52.4.1.1","Household","EUR",787868,634122.77159999998,704708.78540625016,761643.32400000002,832573.98]
["52.4.1.2","Commercial","EUR",0,177191.5626,165136.98599999998,142497.87300000002,125605.34999999998]
["52.4.1.3","Institutional","EUR",0,163267.902,98596.79732490005,71137.923660899978,50945.940348000033]
["52.4.1.4","Total provision for write-off","EUR",787868,974582.23619999993,968442.56873115012,975279.12066090002,1009125.270348]
[]
["52.4.2","VAT paid on bad debts"]
["52.4.2.1","VAT paid on bad debts","EUR",0,0,0,0,0]

{"sheet":"61 - WW RAB","index":19,"n_rows":82,"n_cols":9,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[61,"Wastewater Regulatory Asset Base (RAB)"]
[null,null,null,"Historical","Base year","Year 1","Year 2","Year 3"]
[null,null,null,"(Actual)","(budget forecast)","(Projected)","(Projected)","(Projected)"]
[null,null,"Unit",2010,2011,2012,2013,2014,"Remarks/Shënime"]
[61.1,"Wastewater collection"]
[]
["61.1.1","Infrastructure"]
["61.1.1.1","Opening RAB at prior year price levels","EUR",2021353,2091372.5205104833,2261840.2946572928,2345073.940845096,2387285.2717803079]
["61.1.1.2","Indexation adjustment","EUR",70019.520510483228,170467.7741468095,47498.646187803148,42211.330935211729,38196.564348484928]
["61.1.1.3","Opening RAB at current year price levels","EUR",2091372.5205104833,2261840.2946572928,2309338.940845096,2387285.2717803079,2425481.8361287927]
["61.1.1.4","Additions (net of disposals and grants)","EUR",0,0,35735,0,0]
["61.1.1.5","Closing RAB at current year price levels","EUR",2091372.5205104833,2261840.2946572928,2345073.940845096,2387285.2717803079,2425481.8361287927]
[]
["61.1.2","Non-infrastrucutre"]
["61.1.2.1","Opening RAB at prior year price levels","EUR",38629,42709.888435994275,44871.423686914677,44504.760053358747,44011.392999052943]
["61.1.2.2","Indexation adjustment","EUR",1338.1057429352797,3481.2830064178934,942.29989742520831,801.08568096045735,704.18228798484711]
["61.1.2.3","Opening RAB at current year price levels","EUR",39967.10574293528,46191.171442412167,45813.723584339888,45305.845734319206,44715.575287037791]
["61.1.2.4","Additions (net of disposals and grants)","EUR",3941,0,0,0,0]
["61.1.2.5","Depreciation","EUR",-1198.217306941008,-1319.7477554974905,-1308.9635309811397,-1294.4527352662631,-1277.587865343937]
["61.1.2.6","Closing RAB at current year price levels","EUR",42709.888435994275,44871.423686914677,44504.760053358747,44011.392999052943,43437.987421693855]
["61.1.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-1282.040676768991,-1245.4109431470199,-1209.8277733428192]
[]
[61.2,"Wastewater treatment"]
[]
["61.2.1","Infrastructure"]
["61.2.1.1","Opening RAB at prior year price levels","EUR",0,0,0,0,0]
["61.2.1.2","Indexation adjustment","EUR",0,0,0,0,0]
["61.2.1.3","Opening RAB at current year price levels","EUR",0,0,0,0,0]
["61.2.1.4","Additions (net of disposals and grants)","EUR",0,0,0,0,0]
["61.2.1.5","Closing RAB at current year price levels","EUR",0,0,0,0,0]
[]
["61.2.2","Non-infrastrucutre"]
["61.2.2.1","Opening RAB at prior year price levels","EUR",0,0,0,0,0]
["61.2.2.2","Indexation adjustment","EUR",0,0,0,0,0]
["61.2.2.3","Opening RAB at current year price levels","EUR",0,0,0,0,0]
["61.2.2.4","Additions (net of disposals and grants)","EUR",0,0,0,0,0]
["61.2.2.5","Depreciation","EUR",0,0,0,0,0]
["61.2.2.6","Closing RAB at current year price levels","EUR",0,0,0,0,0]
["61.2.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",0,0,0]
[]
[61.3,"Sludge treatment and disposal"]
[]
["61.3.1","Infrastructure"]
["61.3.1.1","Opening RAB at prior year price levels","EUR",0,0,0,0,0]
["61.3.1.2","Indexation adjustment","EUR",0,0,0,0,0]
["61.3.1.3","Opening RAB at current year price levels","EUR",0,0,0,0,0]
["61.3.1.4","Additions (net of disposals and grants)","EUR",0,0,0,0,0]
["61.3.1.5","Closing RAB at current year price levels","EUR",0,0,0,0,0]
[]
["61.3.2","Non-infrastrucutre"]
["61.3.2.1","Opening RAB at prior year price levels","EUR",0,0,0,0,0]
["61.3.2.2","Indexation adjustment","EUR",0,0,0,0,0]
["61.3.2.3","Opening RAB at current year price levels","EUR",0,0,0,0,0]
["61.3.2.4","Additions (net of disposals and grants)","EUR",0,0,0,0,0]
["61.3.2.5","Depreciation","EUR",0,0,0,0,0]
["61.3.2.6","Closing RAB at current year price levels","EUR",0,0,0,0,0]
["61.3.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",0,0,0]
[]
[61.4,"Business activities"]
[]
["61.4.2","Non-infrastrucutre"]
["61.4.2.1","Opening RAB at prior year price levels","EUR",4292,4745.5410079437424,4985.7114824869159,4944.9710972300227,4890.1525604950157]
["61.4.2.2","Indexation adjustment","EUR",148.67456700091176,386.80904755749447,104.69994113222523,89.0094797501404,78.242440967920245]
["61.4.2.3","Opening RAB at current year price levels","EUR",4440.6745670009113,5132.350055501237,5090.4114236191408,5033.9805769801633,4968.3950014629363]
["61.4.2.4","Additions (net of disposals and grants)","EUR",438,0,0,0,0]
["61.4.2.5","Depreciation","EUR",-133.1335590571689,-146.63857301432105,-145.4403263891183,-143.82801648514751,-141.95414289894103]
["61.4.2.6","Closing RAB at current year price levels","EUR",4745.5410079437424,4985.7114824869159,4944.9710972300227,4890.1525604950157,4826.4408585639949]
["61.4.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-142.44889949962615,-138.37893094249401,-134.42524720127989]
[]
[61.5,"Summary"]
["61.5.1","Totals"]
["61.5.1.1","Opening RAB at prior year price levels","EUR",2064274,2138827.9499544217,2311697.4298266941,2394523.671995685,2436186.8173398557]
["61.5.1.2","Indexation adjustment","EUR",71506.300820419419,174335.86620078489,48545.646026360584,43101.426095922325,38978.989077437698]
["61.5.1.3","Opening RAB at current year price levels","EUR",2135780.3008204196,2313163.8161552064,2360243.0758530553,2437625.0980916074,2475165.8064172938]
["61.5.1.4","Additions (net of disposals and grants)","EUR",4379,0,35735,0,0]
["61.5.1.5","Depreciation","EUR",-1331.3508659981769,-1466.3863285118116,-1454.403857370258,-1438.2807517514107,-1419.542008242878]
["61.5.1.6","Closing RAB at current year price levels","EUR",2138827.9499544217,2311697.4298266941,2394523.671995685,2436186.8173398557,2473746.2644090503]
["61.5.1.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-1424.4895762686172,-1383.7898740895139,-1344.2530205440992]

{"sheet":"62 - WW income","index":20,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[62,"Wastewater income (nominal price levels)"]
[null,null,null,"Historical","Base year","Year 1","Year 2","Year 3"]
[null,null,null,"(Actual)","(budget forecast)","(Projected)","(Projected)","(Projected)"]
[null,null,"Unit",2010,2011,2012,2013,2014,"Remarks/Shënime"]
[62.1,"Wastewater tariff income"]
[]
["62.1.1","Wastewater tariff income"]
["62.1.1.1","Household","EUR",154127.24,173100.52499999999,247318.5,263084.25,341493.75]
["62.1.1.2","Commercial","EUR",49730.720000000001,62218.8,77411.7,74965.5,81090]
["62.1.1.3","Institutional","EUR",87707.780392156856,93968.664040000018,111759.54488999999,104653.44666,118127.34720000002]
["62.1.1.4","Total water tariff income","EUR",291565.74039215688,329287.98904000001,436489.74488999997,442703.19666000002,540711.09719999996]
[]
[62.2,"Connection fees"]
[]
["62.2.1","Connection fees"]
["62.2.1.1","Household","EUR",53280,60680,35400,63216,55200]
["62.2.1.2","Commercial","EUR",10080,20460,4260,2100,600]
["62.2.1.3","Institutional","EUR",180,480,540,600,480]
["62.2.1.4","Total connection fee income","EUR",63540,81620,40200,65916,56280]
[]
[62.3,"Total income from customers"]
[]
["62.3.1","Total income from customers"]
["62.3.1.1","Tariff income","EUR",291565.74039215688,329287.98904000001,436489.74488999997,442703.19666000002,540711.09719999996]
["62.3.1.2","Connection fees","EUR",63540,81620,40200,65916,56280]
["62.3.1.3","Total income from customers","EUR",355105.74039215688,410907.98904000001,476689.74488999997,508619.19666000002,596991.09719999996]
[]
[62.4,"Cash collection"]
[]
["62.4.1","Cash collection by category (excluding connection fees), excluding VAT"]
["62.4.1.1","Household","EUR",87852.526799999992,102129.30974999999,158283.84,173635.60500000001,232215.75000000003]
["62.4.1.2","Commercial","EUR",30335.7392,44797.536,61155.243000000002,62221.364999999998,70548.3]
["62.4.1.3","Institutional","EUR",63149.60188235293,80813.05107440002,101701.18584989999,98374.23986039999,114583.52678400002]
["62.4.1.4","Total cash collection","EUR",181337.8678823529,227739.8968244,321140.26884989999,334231.20986040001,417347.57678400003]
[]
[62.5,"Provisions for write off (offset by 12 months)"]
[]
["62.5.1","Write-off provisions (excluding VAT)"]
["62.5.1.1","Household","EUR",276819,66274.713199999998,70971.215250000008,89034.66,89448.64499999999]
["62.5.1.2","Commercial","EUR",0,19394.980800000001,17421.264000000003,16256.456999999995,12744.135000000002]
["62.5.1.3","Institutional","EUR",0,24558.178509803925,13155.612965599998,10058.359040099996,6279.2067996000114]
["62.5.1.4","Total provision for write-off","EUR",276819,110227.87250980393,101548.0922156,115349.47604009999,108471.98679960001]
[]
["62.5.2","VAT paid on bad debts"]
["62.5.2.1","VAT paid on bad debts","EUR",0,0,0,0,0]

{"sheet":"81- 2010 Inc-Exp ","index":21,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[6,3,6,5],[6,6,6,9]]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[81,"Income - Expenditure analysis"]
[null,"2010 - Historical"]
[null,null,null,"Water supply",null,null,"Wastewater"]
[null,null,"Unit","Resrouces and treatment","Distribution","Water supply total","Wastewater collection","Wastewater treatment","Sludge treatment and disposal","Total wastewater","Total RWC exc non-core"]
[81.099999999999994,"Income"]
[]
["81.1.1","Income"]
["81.1.1.1","Sales excluding connection fees","EUR",null,null,2512141.11,null,null,null,291565.74039215688,2803706.8503921567]
[]
[81.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["81.2.1.1","Service charges","EUR",14839,0,14839,0,0,0,0,14839]
["81.2.1.2","Energy costs","EUR",535211,10418,545629,606,0,0,606,546235]
["81.2.1.3","Fuel costs","EUR",21562,11202,32764,5439,0,0,5439,38203]
["81.2.1.4","Staff costs","EUR",393688,421951,815639,9220,0,0,9220,824859]
["81.2.1.5","Materials and consumables","EUR",21812,12719,34531,0,0,0,0,34531]
["81.2.1.6","Contracted services","EUR",27000,0,27000,0,0,0,0,27000]
["81.2.1.7","Maintenance and repair","EUR",11520,70312,81832,1280,0,0,1280,83112]
["81.2.1.8","Other direct costs","EUR",31304,41863,73167,0,0,0,0,73167]
["81.2.1.9","Total Direct costs","EUR",1056936,568465,1625401,16545,0,0,16545,1641946]
[]
[81.3,"Indirect costs"]
[]
["81.3.1.","Business activities"]
["81.3.1.1","Energy costs","EUR",null,null,5000,null,null,null,0,5000]
["81.3.1.2","Fuel costs","EUR",null,null,9148.59,null,null,null,92.41,9241]
["81.3.1.3","Staff costs","EUR",null,null,268458.3,null,null,null,2711.7000000000003,271170]
["81.3.1.4","Materials and consumables","EUR",null,null,34569.81,null,null,null,349.19,34919]
["81.3.1.5","Contracted services","EUR",null,null,0,null,null,null,0,0]
["81.3.1.6","Maintenance and repair","EUR",null,null,42123.51,null,null,null,425.49,42549]
["81.3.1.7","Other indirect costs","EUR",null,null,86443.83,null,null,null,873.17000000000007,87317]
["81.3.1.8","Total Busiiness activities costs","EUR",null,null,445744.04000000004,null,null,null,4451.96,450196.00000000006]
[]
["81.3.2.","Other indirect costs"]
["81.3.2.1","Bad debts","EUR",null,null,787868,null,null,null,276819,1064687]
["81.3.2.2","VAT on bad debts","EUR",null,null,0,null,null,null,0,0]
["81.3.2.3","Total other indirect costs","EUR",null,null,787868,null,null,null,276819,1064687]
["81.3.2.4","Total all indirect costs","EUR",null,null,1233612.04,null,null,null,281270.96000000002,1514883]
["81.3.2.5","Total direct and indirect costs","EUR",null,null,2859013.04,null,null,null,297815.96000000002,3156829]
[]
[81.400000000000006,"Net Income before cap maintenance"]
[]
["81.4.1","Net income"]
["81.4.1.1.","Net income before capital maintenance","EUR",null,null,-346871.93000000017,null,null,null,-6250.2196078431443,-353122.14960784325]
[]
[81.5,"Capital maintenance"]
[]
["81.5.1","Capital maintenance"]
["81.5.1.1","Infrastructure renewals","EUR",0,0,0,0,0,0,0,0]
["81.5.1.2","Depreciation (service activities)","EUR",39024.558458132567,4591.1178017971088,43615.676259929678,1198.217306941008,0,0,1198.217306941008,44813.893566870684]
["81.5.1.3","Depreciation (business activities)","EUR",null,null,2295.5589008985544,null,null,null,1331.3508659981769,3626.9097668967315]
["81.5.1.4","Total capital maintenance","EUR",39024.558458132567,4591.1178017971088,45911.235160828233,1198.217306941008,0,0,2529.5681729391849,48440.803333767421]
[]
[81.599999999999994,"Net Income"]
[]
["81.6.1","Net income"]
["81.6.1.1","Net income before taxes and dividends","EUR",null,null,-392783.16516082839,null,null,null,-8779.7877807823297,-401562.95294161065]

{"sheet":"82 - 2011 Inc-Exp","index":22,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[6,3,6,5],[6,6,6,9]]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[82,"Income - Expenditure analysis"]
[null,"2011 - Base"]
[null,null,null,"Water supply",null,null,"Wastewater"]
[null,null,"Unit","Resrouces and treatment","Distribution","Water supply total","Wastewater Collection","Wastewater treatment","Sludge treatment and disposal","Total wastewater","Total RWC exc non-core"]
[82.1,"Income"]
[]
["82.1.1","Income"]
["82.1.1.1","Sales excluding connection fees","EUR",null,null,3012839.7036600001,null,null,null,329287.98904000001,3342127.6927]
[]
[82.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["82.2.1.1","Service charges","EUR",33000,0,33000,0,0,0,0,33000]
["82.2.1.2","Energy costs","EUR",634596,12335,646931,718,0,0,718,647649]
["82.2.1.3","Fuel costs","EUR",25117,15378,40495,6336,0,0,6336,46831]
["82.2.1.4","Staff costs","EUR",410751,440240,850991,96186,0,0,96186,947177]
["82.2.1.5","Materials and consumables","EUR",17138,33870,51008,0,0,0,0,51008]
["82.2.1.6","Contracted services","EUR",7800,0,7800,0,0,0,0,7800]
["82.2.1.7","Maintenance and repair","EUR",8995,47327,56322,1070,0,0,1070,57392]
["82.2.1.8","Other direct costs","EUR",35547,50781,86328,0,0,0,0,86328]
["82.2.1.9","Total Direct costs","EUR",1172944,599931,1772875,104310,0,0,104310,1877185]
[]
[82.3,"Indirect costs"]
[]
["82.3.1.","Business activities"]
["82.3.1.1","Energy costs","EUR",null,null,5000,null,null,null,0,5000]
["82.3.1.2","Fuel costs","EUR",null,null,10657.35,null,null,null,107.65,10765]
["82.3.1.3","Staff costs","EUR",null,null,280094.76,null,null,null,2829.2400000000002,282924]
["82.3.1.4","Materials and consumables","EUR",null,null,92054.16,null,null,null,929.84,92984]
["82.3.1.5","Contracted services","EUR",null,null,0,null,null,null,0,0]
["82.3.1.6","Maintenance and repair","EUR",null,null,28352.61,null,null,null,286.39,28639]
["82.3.1.7","Other indirect costs","EUR",null,null,101395.8,null,null,null,1024.2,102420]
["82.3.1.8","Total Busiiness activities costs","EUR",null,null,517554.68,null,null,null,5177.3200000000006,522732]
[]
["82.3.2.","Other indirect costs"]
["82.3.2.1","Bad debts","EUR",null,null,974582.23619999993,null,null,null,110227.87250980393,1084810.1087098038]
["82.3.2.2","VAT on bad debts","EUR",null,null,0,null,null,null,0,0]
["82.3.2.3","Total other indirect costs","EUR",null,null,974582.23619999993,null,null,null,110227.87250980393,1084810.1087098038]
["82.3.2.4","Total all indirect costs","EUR",null,null,1492136.9161999999,null,null,null,115405.19250980394,1607542.1087098038]
["82.3.2.5","Total direct and indirect costs","EUR",null,null,3265011.9161999999,null,null,null,219715.19250980392,3484727.1087098038]
[]
[82.4,"Net Income before cap maintenance"]
[]
["82.4.1","Net income"]
["82.4.1.1.","Net income before capital maintenance","EUR",null,null,-252172.21253999975,null,null,null,109572.79653019609,-142599.41600980377]
[]
[82.5,"Capital maintenance"]
[]
["82.5.1","Capital maintenance"]
["82.5.1.1","Infrastructure renewals","EUR",0,25288,25288,53000,0,0,53000,78288]
["82.5.1.2","Depreciation (service activities)","EUR",42047.746389253385,4931.6533088552605,46979.399698108646,1319.7477554974905,0,0,1319.7477554974905,48299.147453606136]
["82.5.1.3","Depreciation (business activities)","EUR",null,null,2444.3980829990587,null,null,null,1466.3863285118116,3910.7844115108701]
["82.5.1.4","Total capital maintenance","EUR",42047.746389253385,30219.653308855261,74711.7977811077,54319.74775549749,0,0,55786.134084009303,130497.931865117]
[]
[82.6,"Net Income"]
[]
["82.6.1","Net income"]
["82.6.1.1","Net income before taxes and dividends","EUR",null,null,-326884.01032110746,null,null,null,53786.66244618679,-273097.34787492076]

{"sheet":"83 - 2012 Inc-Exp","index":23,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[6,3,6,5],[6,6,6,9]]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[83,"Income - Expenditure analysis"]
[null,"2012 - Tariff review year 1"]
[null,null,null,"Water supply",null,null,"Wastewater"]
[null,null,"Unit","Resrouces and treatment","Distribution","Water supply total","Wastewater Collection","Wastewater treatment","Sludge treatment and disposal","Total wastewater","Total RWC exc non-core"]
[83.1,"Income"]
[]
["83.1.1","Income"]
["83.1.1.1","Sales excluding connection fees","EUR",null,null,3584658.5740100001,null,null,null,436489.74488999997,4021148.3189000003]
[]
[83.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["83.2.1.1","Service charges","EUR",33693,0,33693,0,0,0,0,33693]
["83.2.1.2","Energy costs","EUR",743287.99999999988,14293.999999999998,757581.99999999988,847.43,0,0,847.43,758429.42999999993]
["83.2.1.3","Fuel costs","EUR",29517.109999999997,18071.699999999997,47588.81,7249.0999999999995,0,0,7249.0999999999995,54837.909999999996]
["83.2.1.4","Staff costs","EUR",362162.99399999995,392018.05499999999,754181.04899999988,83664.823999999993,0,0,83664.823999999993,837845.87299999991]
["83.2.1.5","Materials and consumables","EUR",17497.897999999997,34581.269999999997,52079.167999999991,0,0,0,0,52079.167999999991]
["83.2.1.6","Contracted services","EUR",7963.7999999999993,0,7963.7999999999993,0,0,0,0,7963.7999999999993]
["83.2.1.7","Maintenance and repair","EUR",9189,51049.999999999993,60238.999999999993,1092.4699999999998,0,0,1092.4699999999998,61331.469999999994]
["83.2.1.8","Other direct costs","EUR",36293.486999999994,51847.400999999998,88140.887999999992,0,0,0,0,88140.887999999992]
["83.2.1.9","Total Direct costs","EUR",1239605.2889999999,561862.42599999998,1801467.7149999999,92853.823999999993,0,0,92853.823999999993,1894321.5389999999]
[]
[83.3,"Indirect costs"]
[]
["83.3.1.","Business activities"]
["83.3.1.1","Energy costs","EUR",null,null,5104.9999999999991,null,null,null,0,5104.9999999999991]
["83.3.1.2","Fuel costs","EUR",null,null,10881.154349999999,null,null,null,109.91064999999999,10991.064999999999]
["83.3.1.3","Staff costs","EUR",null,null,285976.74995999999,null,null,null,32817.227039999998,318793.97699999996]
["83.3.1.4","Materials and consumables","EUR",null,null,93987.297359999997,null,null,null,949.36663999999996,94936.66399999999]
["83.3.1.5","Contracted services","EUR",null,null,0,null,null,null,0,0]
["83.3.1.6","Maintenance and repair","EUR",null,null,28948.014809999997,null,null,null,292.40418999999997,29240.418999999998]
["83.3.1.7","Other indirect costs","EUR",null,null,103525.1118,null,null,null,1045.7082,104570.81999999999]
["83.3.1.8","Total Busiiness activities costs","EUR",null,null,528423.32828000002,null,null,null,35214.616719999998,563637.94500000007]
[]
["83.3.2.","Other indirect costs"]
["83.3.2.1","Bad debts","EUR",null,null,968442.56873115012,null,null,null,101548.0922156,1069990.6609467501]
["83.3.2.2","VAT on bad debts","EUR",null,null,0,null,null,null,0,0]
["83.3.2.3","Total other indirect costs","EUR",null,null,968442.56873115012,null,null,null,101548.0922156,1069990.6609467501]
["83.3.2.4","Total all indirect costs","EUR",null,null,1496865.8970111501,null,null,null,136762.70893560001,1633628.6059467501]
["83.3.2.5","Total direct and indirect costs","EUR",null,null,3298333.61201115,null,null,null,229616.5329356,3527950.1449467503]
[]
[83.4,"Net Income before cap maintenance"]
[]
["83.4.1","Net income"]
["83.4.1.1.","Net income before capital maintenance","EUR",null,null,286324.96199885011,null,null,null,206873.21195439997,493198.17395325005]
[]
[83.5,"Capital maintenance"]
[]
["83.5.1","Capital maintenance"]
["83.5.1.1","Infrastructure renewals","EUR",0,175509.9,175509.9,120399.73023857825,0,0,120399.73023857825,295909.63023857825]
["83.5.1.2","Depreciation (service activities)","EUR",43520.077661615491,5664.3975132457563,49184.475174861247,1308.9635309811397,0,0,1308.9635309811397,50493.438705842389]
["83.5.1.3","Depreciation (business activities)","EUR",null,null,2424.4238586636948,null,null,null,1454.403857370258,3878.827716033953]
["83.5.1.4","Total capital maintenance","EUR",43520.077661615491,181174.29751324575,227118.79903352493,121708.6937695594,0,0,123163.09762692965,350281.89666045457]
[]
[83.6,"Net Income"]
[]
["83.6.1","Net income"]
["83.6.1.1","Net income before taxes and dividends","EUR",null,null,59206.162965325173,null,null,null,83710.114327470321,142916.27729279548]

{"sheet":"84 - 2013 Inc-Exp","index":24,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[6,3,6,5],[6,6,6,9]]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[84,"Income - Expenditure analysis"]
[null,"2013 - Tariff review year 2"]
[null,null,null,"Water supply",null,null,"Wastewater"]
[null,null,"Unit","Resrouces and treatment","Distribution","Water supply total","Wastewater Collection","Wastewater treatment","Sludge treatment and disposal","Total wastewater","Total RWC exc non-core"]
[84.1,"Income"]
[]
["84.1.1","Income"]
["84.1.1.1","Sales excluding connection fees","EUR",null,null,4036701.0057999999,null,null,null,442703.19666000002,4479404.2024600003]
[]
[84.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["84.2.1.1","Service charges","EUR",34299.473999999995,0,34299.473999999995,0,0,0,0,34299.473999999995]
["84.2.1.2","Energy costs","EUR",743155.2699999999,15455.550859999999,758610.82085999986,914.65263999999991,0,0,914.65263999999991,759525.47349999985]
["84.2.1.3","Fuel costs","EUR",32085.598859999998,18708.804,50794.402860000002,7826.5163399999992,0,0,7826.5163399999992,58620.919200000004]
["84.2.1.4","Staff costs","EUR",392199.93389799999,424281.37524599995,816481.30914399994,90677.415475999995,0,0,90677.415475999995,907158.72461999999]
["84.2.1.5","Materials and consumables","EUR",17812.860163999998,35203.732859999996,53016.593023999994,0,0,0,0,53016.593023999994]
["84.2.1.6","Contracted services","EUR",8107.1483999999991,0,8107.1483999999991,0,0,0,0,8107.1483999999991]
["84.2.1.7","Maintenance and repair","EUR",9354.402,57165.789999999994,66520.191999999995,1112.13446,0,0,1112.13446,67632.326459999997]
["84.2.1.8","Other direct costs","EUR",36946.769765999998,52780.654217999996,89727.423983999994,0,0,0,0,89727.423983999994]
["84.2.1.9","Total Direct costs","EUR",1273961.4570880001,603595.90718400001,1877557.3642720003,100530.718916,0,0,100530.718916,1978088.0831880004]
[]
[84.3,"Indirect costs"]
[]
["84.3.1.","Business activities"]
["84.3.1.1","Energy costs","EUR",null,null,5196.8899999999994,null,null,null,0,5196.8899999999994]
["84.3.1.2","Fuel costs","EUR",null,null,11077.0151283,null,null,null,111.88904169999999,11188.90417]
["84.3.1.3","Staff costs","EUR",null,null,291124.33145927999,null,null,null,33407.937126719997,324532.26858599996]
["84.3.1.4","Materials and consumables","EUR",null,null,95679.068712480002,null,null,null,966.45523951999996,96645.523952000003]
["84.3.1.5","Contracted services","EUR",null,null,0,null,null,null,0,0]
["84.3.1.6","Maintenance and repair","EUR",null,null,29469.079076579997,null,null,null,297.66746541999998,29766.746541999997]
["84.3.1.7","Other indirect costs","EUR",null,null,105388.5638124,null,null,null,1064.5309476,106453.09475999999]
["84.3.1.8","Total Busiiness activities costs","EUR",null,null,537934.94818904006,null,null,null,35848.479820959998,573783.42801000003]
[]
["84.3.2.","Other indirect costs"]
["84.3.2.1","Bad debts","EUR",null,null,975279.12066090002,null,null,null,115349.47604009999,1090628.5967010001]
["84.3.2.2","VAT on bad debts","EUR",null,null,0,null,null,null,0,0]
["84.3.2.3","Total other indirect costs","EUR",null,null,975279.12066090002,null,null,null,115349.47604009999,1090628.5967010001]
["84.3.2.4","Total all indirect costs","EUR",null,null,1513214.0688499401,null,null,null,151197.95586106001,1664412.024711]
["84.3.2.5","Total direct and indirect costs","EUR",null,null,3390771.4331219401,null,null,null,251728.67477705999,3642500.1078990004]
[]
[84.4,"Net Income before cap maintenance"]
[]
["84.4.1","Net income"]
["84.4.1.1.","Net income before capital maintenance","EUR",null,null,645929.57267805981,null,null,null,190974.52188294003,836904.09456099989]
[]
[84.5,"Capital maintenance"]
[]
["84.5.1","Capital maintenance"]
["84.5.1.1","Infrastructure renewals","EUR",0,0,0,122566.92538287267,0,0,122566.92538287267,122566.92538287267]
["84.5.1.2","Depreciation (service activities)","EUR",44373.969657823865,7086.4293350989192,51460.398992922783,1294.4527352662631,0,0,1294.4527352662631,52754.851728189045]
["84.5.1.3","Depreciation (business activities)","EUR",null,null,2397.5473884590801,null,null,null,1438.2807517514107,3835.8281402104908]
["84.5.1.4","Total capital maintenance","EUR",44373.969657823865,7086.4293350989192,53857.946381381866,123861.37811813893,0,0,125299.65886989035,179157.60525127221]
[]
[84.6,"Net Income"]
[]
["84.6.1","Net income"]
["84.6.1.1","Net income before taxes and dividends","EUR",null,null,592071.62629667798,null,null,null,65674.863013049675,657746.48930972768]

{"sheet":"85 - 2014 Inc-Exp","index":25,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[6,3,6,5],[6,6,6,9]]}
[null,"KRU \" Hidroregjioni Jugor \" sh.a. Prizren"]
[]
[null,"2011-12-13"]
[]
[85,"Income - Expenditure analysis"]
[null,"2014 - Tariff review year 3"]
[null,null,null,"Water supply",null,null,"Wastewater"]
[null,null,"Unit","Resrouces and treatment","Distribution","Water supply total","Wastewater Collection","Wastewater treatment","Sludge treatment and disposal","Total wastewater","Total RWC exc non-core"]
[85.1,"Income"]
[]
["85.1.1","Income"]
["85.1.1.1","Sales excluding connection fees","EUR",null,null,4456335.9028399996,null,null,null,540711.09719999996,4997047.0000399994]
[]
[85.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["85.2.1.1","Service charges","EUR",34848.265584000001,0,34848.265584000001,0,0,0,0,34848.265584000001]
["85.2.1.2","Energy costs","EUR",786725.99576000008,16156.9231344,802882.91889440012,960.96732368000005,0,0,960.96732368000005,803843.88621808006]
["85.2.1.3","Fuel costs","EUR",33582.111934448003,20592.156935999999,54174.268870448002,8162.9422110400001,0,0,8162.9422110400001,62337.211081488]
["85.2.1.4","Staff costs","EUR",476365.23045279999,489640.30762420804,966005.53807700798,98003.882902687998,0,0,98003.882902687998,1064009.4209796959]
["85.2.1.5","Materials and consumables","EUR",18097.865926623999,35766.992585760003,53864.858512384002,0,0,0,0,53864.858512384002]
["85.2.1.6","Contracted services","EUR",8236.8627744000005,0,8236.8627744000005,0,0,0,0,8236.8627744000005]
["85.2.1.7","Maintenance and repair","EUR",9504.0724320000008,58080.442640000001,67584.515072000009,1129.9286113600001,0,0,1129.9286113600001,68714.443683360005]
["85.2.1.8","Other direct costs","EUR",37537.918082256001,53625.144685488005,91163.062767744006,0,0,0,0,91163.062767744006]
["85.2.1.9","Total Direct costs","EUR",1404898.3229465282,673861.96760585601,2078760.2905523842,108257.721048768,0,0,108257.721048768,2187018.0116011524]
[]
[85.3,"Indirect costs"]
[]
["85.3.1.","Business activities"]
["85.3.1.1","Energy costs","EUR",null,null,5280.0402400000003,null,null,null,0,5280.0402400000003]
["85.3.1.2","Fuel costs","EUR",null,null,11254.247370352801,null,null,null,109.91064999999999,11364.158020352801]
["85.3.1.3","Staff costs","EUR",null,null,295782.32076262851,null,null,null,32817.227039999998,328599.54780262848]
["85.3.1.4","Materials and consumables","EUR",null,null,97209.933811879688,null,null,null,949.36663999999996,98159.300451879681]
["85.3.1.5","Contracted services","EUR",null,null,0,null,null,null,0,0]
["85.3.1.6","Maintenance and repair","EUR",null,null,29940.584341805283,null,null,null,292.40418999999997,30232.988531805284]
["85.3.1.7","Other indirect costs","EUR",null,null,107074.7808333984,null,null,null,1045.7082,108120.48903339839]
["85.3.1.8","Total Busiiness activities costs","EUR",null,null,546541.9073600648,null,null,null,35214.616719999998,581756.52408006485]
[]
["85.3.2.","Other indirect costs"]
["85.3.2.1","Bad debts","EUR",null,null,1009125.270348,null,null,null,108471.98679960001,1117597.2571475999]
["85.3.2.2","VAT on bad debts","EUR",null,null,0,null,null,null,0,0]
["85.3.2.3","Total other indirect costs","EUR",null,null,1009125.270348,null,null,null,108471.98679960001,1117597.2571475999]
["85.3.2.4","Total all indirect costs","EUR",null,null,1555667.1777080647,null,null,null,143686.6035196,1699353.7812276646]
["85.3.2.5","Total direct and indirect costs","EUR",null,null,3634427.4682604489,null,null,null,251944.324568368,3886371.7928288169]
[]
[85.4,"Net Income before cap maintenance"]
[]
["85.4.1","Net income"]
["85.4.1.1.","Net income before capital maintenance","EUR",null,null,821908.43457955075,null,null,null,288766.77263163193,1110675.2072111825]
[]
[85.5,"Capital maintenance"]
[]
["85.5.1","Capital maintenance"]
["85.5.1.1","Infrastructure renewals","EUR",0,105600.8048,105600.8048,18927.191388998632,0,0,18927.191388998632,124527.99618899863]
["85.5.1.2","Depreciation (service activities)","EUR",44248.415102281928,8502.6862100473445,52751.101312329272,1277.587865343937,0,0,1277.587865343937,54028.689177673208]
["85.5.1.3","Depreciation (business activities)","EUR",null,null,2366.3107710551562,null,null,null,1419.542008242878,3785.852779298034]
["85.5.1.4","Total capital maintenance","EUR",44248.415102281928,114103.49101004735,160718.21688338445,20204.779254342568,0,0,21624.321262585447,182342.53814596988]
[]
[85.6,"Net Income"]
[]
["85.6.1","Net income"]
["85.6.1.1","Net income before taxes and dividends","EUR",null,null,661190.21769616636,null,null,null,267142.45136904647,928332.6690652126]