{"text_format":"1","workbook":"xlsx","n_sheets":26,"sheets":["1 - Assumptions","2 - Tariffs control sheet","11 - W sales vol","12 - W production & NRW","13 - WW sales vol","21 - W opex","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,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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.138E-2,1.8370000000000001E-2,1.6459999999999999E-2]
["1.1.1.4","Adjustment factor to convert 2011 price level expenditure to nominal price levels","Factor","N/A","N/A",1.02138,1.0401427506000001,1.057263500274876]
["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",2.35,2.2999999999999998,2.25]
[]
["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.97906753607863872,0.96140649869756445,0.94583800513307403]
["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.9372026082359164,2.884219496092693,2.837514015399222]
["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.9372026082359164,2.884219496092693,2.837514015399222]
[]
["1.2.3","Connection fees (average)"]
["1.2.3.1","Household (nominal prices)","EUR/con",90,90,90,90,90]
["1.2.3.2","Household (base year price levels)","EUR/con","N/A","N/A",88.116078247077482,86.526584882780796,85.12542046197666]
["1.2.3.3","Non-household (nominal prices)","EUR/con",476,476,476,476,476]
["1.2.3.4","Non-household (base year price levels)","EUR/con","N/A","N/A",466.03614717343203,457.62949338004063,450.21889044334324]
[]
["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.55000000000000004,"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.35456023529411762,"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",2.35,2.2999999999999998,2.25]
[]
["1.3.2","Connection fees (average)"]
["1.3.2.1","Household (nominal prices)","EUR/con",60,60,60,60,60]
["1.3.2.2","Household (base year price levels)","EUR/con","N/A","N/A",58.744052164718326,57.684389921853864,56.75028030798444]
["1.3.2.3","Non-household (nominal prices)","EUR/con",316,316,316,316,316]
["1.3.2.4","Non-household (base year price levels)","EUR/con","N/A","N/A",309.38534140084982,303.80445358843036,298.88480962205136]
[]
["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",6.5000000000000002E-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.4635999999999967E-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.55330275188553979,0.57999999999999996,0.63,0.65,0.67]
["1.4.1.2","Commercial","% of billing",0.88976487843395002,0.9,0.93,0.94,0.96]
["1.4.1.3","Institutions","% of billing",0.96818363508160965,0.98,0.99,1,1]
[]
["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,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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.32,0.34,"N/A","N/A","N/A"]
["2.2.1.2","Non-household","EUR/m3",0.76,0.81,"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.09,0.1,"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.35456023529411762,0.37025922162250824,0.38665331740538844]
["2.3.1.2","Non-household","EUR/m3","N/A","N/A",0.83321655294117647,0.85159620973176886,0.86996996416212402]
[]
["2.3.2","Wastewater (volume of water consumed)"]
["2.3.2.1","Household","EUR/m3","N/A","N/A",4.4635999999999967E-2,4.9589459589784987E-2,5.5092627081434718E-2]
["2.3.2.2","Non-household","EUR/m3","N/A","N/A",0.10489459999999992,0.11405575705650546,0.12395841093322811]
[]
[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.32,0.34,0.37,0.4,0.42]
["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.76,0.81,0.87,0.91,0.94]
["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.76,0.81,0.87,0.91,0.94]
[]
["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.09,0.1,0.11,0.12,0.13]
["2.4.2.3","Institutional","EUR/m3",0.09,0.1,0.11,0.12,0.13]
[]
[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,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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",88888,92443.520000000004,96141.260800000004,99986.911231999999,103986.38768128]
["11.1.1.2","Household properties in service area at end of year","No",92443.520000000004,96141.260800000004,99986.911231999999,103986.38768128,108145.8431885312]
["11.1.1.3","Average number of household properties in service area over the year","No",90665.760000000009,94292.390400000004,98064.086016000001,101986.64945664001,106066.1154349056]
[]
["11.1.2","Households served with water supply"]
["11.1.2.1","Metered households with water supply service at start of year","No",62782,74162,84900,90700,96400]
["11.1.2.2","Metered households with water supply service at end of year","No",74162,84900,90700,96400,102475]
["11.1.2.3","Un-metered households with water supply service at start of year","No",5005,5419,4100,2800,1600]
["11.1.2.4","Un-metered households with water supply service at end of year","No",5419,4100,2800,1600,25]
["11.1.2.5","Total households with water supply at start of year","No",67787,79581,89000,93500,98000]
["11.1.2.6","Total households with water supply at end of year","No",79581,89000,93500,98000,102500]
["11.1.2.7","Average metered households served in year","No",68472,79531,87800,93550,99437.5]
["11.1.2.8","Average un-metered households served in year","No",5212,4759.5,3450,2200,812.5]
["11.1.2.9","Average total households served in year","No",73684,84290.5,91250,95750,100250]
["11.1.2.10","New household connections in year","No",11794,9419,4500,4500,4500]
["11.1.2.11","Service coverage","%",0.81269930346362274,0.89392685499253177,0.9305139496748257,0.93884837388160747,0.9451651886084671]
[]
["11.1.3","Household water consumption"]
["11.1.3.1","Average annual metered water billed per metered household","m3/household/year",205,205,205,205,205]
["11.1.3.2","Average annual un-metered water billed per un-metered household","m3/household/year",362.20056,256.25,307.5,307.5,307.5]
["11.1.3.3","Total household metered water billed","m3/year",14036760,16303855,17999000,19177750,20384687.5]
["11.1.3.4","Total household un-metered water billed","m3/year",1887789.3187199999,1219621.875,1060875,676500,249843.75]
["11.1.3.5","Total household water billed","m3/year",15924549.31872,17523476.875,19059875,19854250,20634531.25]
[]
[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",8203,8430,8803,9017,9237]
["11.2.1.2","Metered commercial with water supply service at end of year","No",8430,8803,9017,9237,9447]
["11.2.1.3","Un-metered commercial with water supply service at start of year","No",113,107,14,0,0]
["11.2.1.4","Un-metered commercial with water supply service at end of year","No",107,14,0,0,0]
["11.2.1.5","Total commercial with water supply at start of year","No",8316,8537,8817,9017,9237]
["11.2.1.6","Total commercial with water supply at end of year","No",8537,8817,9017,9237,9447]
["11.2.1.7","Average metered commercial served in year","No",8316.5,8616.5,8910,9127,9342]
["11.2.1.8","Average un-metered commercial served in year","No",110,60.5,7,0,0]
["11.2.1.9","Average total commercial served in year","No",8426.5,8677,8917,9127,9342]
["11.2.1.10","New commercial connections in year","No",221,280,200,220,210]
[]
["11.2.2","Non-household (commercial) water consumption"]
["11.2.2.1","Total commercial metered water billed","m3/year",3002979,3111418.1500000004,3217401,3295759.7,3373396.2]
["11.2.2.2","Total commercial un-metered water billed","m3/year",68783,38231.462500000009,7583.1,0,0]
["11.2.2.3","Total commercial water billed","m3/year",3071762,3149649.6125000003,3224984.1,3295759.7,3373396.2]
[]
[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",517,528,533,538,543]
["11.3.1.2","Metered institutional with water supply service at end of year","No",528,533,538,543,548]
["11.3.1.3","Un-metered institutional with water supply service at start of year","No",0,0,0,0,0]
["11.3.1.4","Un-metered institutional with water supply service at end of year","No",0,0,0,0,0]
["11.3.1.5","Total institutional with water supply at start of year","No",517,528,533,538,543]
["11.3.1.6","Total institutional with water supply at end of year","No",528,533,538,543,548]
["11.3.1.7","Average metered institutional served in year","No",522.5,530.5,535.5,540.5,545.5]
["11.3.1.8","Average un-metered institutional served in year","No",0,0,0,0,0]
["11.3.1.9","Average total institutional served in year","No",522.5,530.5,535.5,540.5,545.5]
["11.3.1.10","New institutional connections in year","No",11,5,5,5,5]
[]
["11.3.2","Non-household (institutional) water consumption"]
["11.3.2.1","Total institutional metered water billed","m3/year",1702329,1728369,1744659,1760949,1777239]
["11.3.2.2","Total institutional un-metered water billed","m3/year",0,0,0,0,0]
["11.3.2.3","Total institutional water billed","m3/year",1702329,1728369,1744659,1760949,1777239]
[]
[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",8839,9147,9445.5,9667.5,9887.5]
["11.4.1.2","Average un-metered non-household served in year","No",110,60.5,7,0,0]
["11.4.1.3","Average total non-household served in year","No",8949,9207.5,9452.5,9667.5,9887.5]
[]
["11.4.2","Non-household water consumption"]
["11.4.2.3","Total non-household metered water billed","m3/year",4705308,4839787.1500000004,4962060,5056708.7,5150635.2]
["11.4.2.4","Total non-household un-metered water billed","m3/year",68783,38231.462500000009,7583.1,0,0]
["11.4.2.5","Total non-household water billed","m3/year",4774091,4878018.6125000007,4969643.0999999996,5056708.7,5150635.2]
[]
[11.5,"Household and non-household"]
[]
["11.5.1","Total served"]
["11.5.1.1","Total metered connections","No",77311,88678,97245.5,103217.5,109325]
["11.5.1.2","Total un-metered connections","No",5322,4820,3457,2200,812.5]
["11.5.1.3","Total connections","no",82633,93498,100702.5,105417.5,110137.5]
[]
["11.5.2","Total sales"]
["11.5.2.1","Total metered water billed","m3/year",18742068,21143642.149999999,22961060,24234458.699999999,25535322.699999999]
["11.5.2.2","Total un-metered water billed","m3/year",1956572.3187199999,1257853.3374999999,1068458.1000000001,676500,249843.75]
["11.5.2.3","Total water billed","m3/year",20698640.318719998,22401495.487499997,24029518.100000001,24910958.699999999,25785166.449999999]
[]
["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",56708.603612931503,61373.960239726017,65834.296164383559,68249.201917808212,70644.291643835619]

{"sheet":"12 - W production & NRW","index":3,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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",12446941.5,12108855,12006855,11904855,11802855]
["12.1.1.2","Estimated volume of leakages","m3/year",12446941.5,12108855,12108855,11300855,10492855]
["12.1.1.3","Total NRW in year","m3/year",24893883,24217710,24115710,23205710,22295710]
["12.1.1.4","NRW per connection per day","l/con/day)",825.36540096671058,709.63967583219858,656.09531398092781,603.09993759321628,554.61706490796837]
["12.1.1.5","NRW as percentage of production","%",0.54600801157629131,0.51947925209693868,0.50089512401749325,0.48228006275089447,0.46371263683567893]
[]
[12.2,"Production requirement"]
[]
["12.2.1","Production requirement"]
["12.2.1.1","Water sales","m3/year",20698640.318719998,22401495.487499997,24029518.100000001,24910958.699999999,25785166.449999999]
["12.2.1.2","Total NRW","m3/year",24893883,24217710,24115710,23205710,22295710]
["12.2.1.3","Total average production requirement","m3/year",45592523.318719998,46619205.487499997,48145228.100000001,48116668.700000003,48080876.450000003]
["12.2.1.4","Peak production requirement","m3/day",124911.02279101369,127723.85065068492,131904.73452054794,131826.4895890411,131728.428630137]
[]
[12.3,"Production capacity"]
[]
["12.3.1","Production capacity"]
["12.3.1.1","Average annual production capacity","m3/year",45804238,44465000,44465000,44465000,44465000]
["12.3.1.2","Maximum production capacity","m3/day",125491.06301369863,121821.91780821918,121821.91780821918,121821.91780821918,121821.91780821918]
["12.3.1.3","Seasonal minimum production capacity factor","factor",1,1,1,1,1]
["12.3.1.4","Seasonal minimum production capacity","m3/day",125491.06301369863,121821.91780821918,121821.91780821918,121821.91780821918,121821.91780821918]
["12.3.1.5","Is production capacity sufficient for average conditions","yes/no (P=Yes, J=No)","P","J","J","J","J"]
["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","J","J","J","J"]
[null,"Note: if production capacity insufficient to meet production requirement adjust sales and/or NRW to ensure capacity exceeds requirements."]

{"sheet":"13 - WW sales vol","index":4,"n_rows":111,"n_cols":9,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
[null,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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",46797,56380,65799,71709,76999]
["13.1.1.2","Metered households with wastewater service at end of year","No",56380,65799,71709,76999,82435]
["13.1.1.3","Un-metered households with wastewater service at start of year","No",3731,4006,3150,1740,950]
["13.1.1.4","Un-metered households with wastewater service at end of year","No",4006,3150,1740,950,14]
["13.1.1.5","Total households with wastewater service at start of year","No",50528,60386,68949,73449,77949]
["13.1.1.6","Total households with wastewater service at end of year","No",60386,68949,73449,77949,82449]
["13.1.1.7","Average metered households served with wastewater service in year","No",51588.5,61089.5,68754,74354,79717]
["13.1.1.8","Average un-metered households served with wastewater service in year","No",3868.5,3578,2445,1345,482]
["13.1.1.9","Average total households served in year","No",55457,64667.5,71199,75699,80199]
["13.1.1.10","New household connections in year","No",9858,8563,4500,4500,4500]
["13.1.1.11","Service coverage with wastewater connections","%",0.61166420487734285,0.68581886327913055,0.72604561866189488,0.74224420944609715,0.75612272280509185]
[]
["13.1.2","Household sales from those with wastewater service"]
["13.1.2.1","Metered water billed with wastewater connections","m3/year",10575642.5,12523347.5,14094570,15242570,16341985]
["13.1.2.2","Un-metered water billed with wastewater connections","m3/year",1401172.8663599999,916862.5,751837.5,413587.5,148215]
["13.1.2.3","Total household water billed with wastewater connections","m3/year",11976815.366359999,13440210,14846407.5,15656157.5,16490200]
[]
["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",7458,8035,8326,8526,8746]
["13.2.1.2","Metered commercial with wastewater service at end of year","No",8035,8326,8526,8746,8956]
["13.2.1.3","Un-metered commercial with wastewater service at start of year","No",14,11,0,0,0]
["13.2.1.4","un-metered commercial with wastewater service at end of year","No",11,0,0,0,0]
["13.2.1.5","Total commercial with wastewater service at start of year","No",7472,8046,8326,8526,8746]
["13.2.1.6","Total commercial with wastewater service at end of year","No",8046,8326,8526,8746,8956]
["13.2.1.7","Average metered commercial served with wastewater service in year","No",7746.5,8180.5,8426,8636,8851]
["13.2.1.8","Average un-metered commercial served with wastewater service in year","No",12.5,5.5,0,0,0]
["13.2.1.9","Average total commercial served in year","No",7759,8186,8426,8636,8851]
["13.2.1.10","New commercial connections in year","No",574,280,200,220,210]
[]
["13.2.2","Commercial water sales from those with wastewater services"]
["13.2.2.1","Metered water billed with wastewater connections","m3/year",2797159.4809715627,2953978.5500000003,3042628.6,3118459.6,3196096.1]
["13.2.2.2","Un-metered water billed with wastewater connections","m3/year",7816.25,3475.587500000001,0,0,0]
["13.2.2.3","Total commercial water billed with wastewater connections","m3/year",2804975.7309715627,2957454.1375000002,3042628.6,3118459.6,3196096.1]
[]
["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",488,490,495,500,505]
["13.3.1.2","Metered institutional with wastewater service at end of year","No",490,495,500,505,510]
["13.3.1.3","Un-metered institutional with wastewater service at start of year","No",0,0,0,0,0]
["13.3.1.4","un-metered institutional with wastewater service at end of year","No",0,0,0,0,0]
["13.3.1.5","Total institutional with wastewater service at start of year","No",488,490,495,500,505]
["13.3.1.6","Total institutional with wastewater service at end of year","No",490,495,500,505,510]
["13.3.1.7","Average metered institutional served with wastewater service in year","No",489,492.5,497.5,502.5,507.5]
["13.3.1.8","Average un-metered institutional served with wastewater service in year","No",0,0,0,0,0]
["13.3.1.9","Average total institutional served in year","No",489,492.5,497.5,502.5,507.5]
["13.3.1.10","New institutional connections in year","No",2,5,5,5,5]
[]
["13.3.2","Institutional water sales from those with wastewater service"]
["13.3.2.1","Metered water billed with wastewater connections","m3/year",1593184.4612440192,1604565,1620855,1637145,1653435]
["13.3.2.2","Un-metered water billed with wastewater connections","m3/year",0,0,0,0,0]
["13.3.2.3","Total institutional water billed with wastewater connections","m3/year",1593184.4612440192,1604565,1620855,1637145,1653435]
[]
["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",8235.5,8673,8923.5,9138.5,9358.5]
["13.4.1.2","Average un-metered non-household with wastewater connections","No",12.5,5.5,0,0,0]
["13.4.1.3","Average total non-household with wastewater connections","No",8248,8678.5,8923.5,9138.5,9358.5]
[]
["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",4390343.9422155824,4558543.5500000007,4663483.5999999996,4755604.5999999996,4849531.0999999996]
["13.4.2.2","Total non-household un-metered water billed from those with wastewater service","m3/year",7816.25,3475.587500000001,0,0,0]
["13.4.2.3","Total non-household water billed from those with wastewater service","m3/year",488,490,495,500,505]
[]
["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",59824,69762.5,77677.5,83492.5,89075.5]
["13.5.1.2","Total un-metered connections with wastewater collection services","No",3881,3583.5,2445,1345,482]
["13.5.1.3","Total connections","no",63705,73346,80122.5,84837.5,89557.5]
[]
["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",14965986.442215582,17081891.050000001,18758053.600000001,19998174.600000001,21191516.100000001]
["13.5.2.2","Total un-metered water billed from those with wastewater service","m3/year",1408989.1163599999,920338.08750000002,751837.5,413587.5,148215]
["13.5.2.3","Total water billed from those with wastewater service","m3/year",16374975.558575582,18002229.137499999,19509891.100000001,20411762.100000001,21339731.100000001]
[]
["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":"21 - W opex","index":5,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[6,3,6,4],[6,5,6,7]]}
[null,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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",73099.026377806833,81714.959999999992,81714.959999999992,81714.959999999992,81714.959999999992]
["21.1.1.2","Energy costs","EUR/year",1187334.75,1165692.28,1165692.28,1165692.28,1165692.28]
["21.1.1.3","Fuel costs","EUR/year",143.15,150,150,150,150]
["21.1.1.4","Staff costs","EUR/year",473356.48,530558.38,407212.38,407212.38,407212.38]
["21.1.1.5","Materials and consumables","EUR/year",279313.02,226429.7,226429.7,226429.7,226429.7]
["21.1.1.6","Contracted services","EUR/year",148816.95999999999,80925.179999999993,80925.179999999993,80925.179999999993,80925.179999999993]
["21.1.1.7","Maintenance and repair","EUR/year",26447.74,30100,30100,30100,30100]
["21.1.1.8","Other direct costs","EUR/year",13397.08,13000,13000,13000,13000]
["21.1.1.9","Total water resources and treatment costs","EUR/year",2201908.2063778071,2128570.5,2005224.5,2005224.5,2005224.5]
[]
["21.1.2","Water Distribution"]
["21.1.2.1","Service charges","EUR/year",0,0,0,0,0]
["21.1.2.2","Energy costs","EUR/year",248850.2,235105.44,235105.44,235105.44,235105.44]
["21.1.2.3","Fuel costs","EUR/year",81282.599999999991,81872.039999999994,81872.039999999994,81872.039999999994,81872.039999999994]
["21.1.2.4","Staff costs","EUR/year",729629.7,785893,711790,711790,711790]
["21.1.2.5","Materials and consumables","EUR/year",208747.08000000005,210000,210000,210000,210000]
["21.1.2.6","Contracted services","EUR/year",65876.69,70925.179999999993,70925.179999999993,70925.179999999993,70925.179999999993]
["21.1.2.7","Maintenance and repair","EUR/year",46528.51,60000,60000,60000,60000]
["21.1.2.8","Other direct costs","EUR/year",14029.75,15000,15000,15000,15000]
["21.1.2.9","Total water distribution costs","EUR/year",1394944.53,1458795.66,1384692.66,1384692.66,1384692.66]
[]
[21.2,"Indirect costs"]
[]
["21.2.1","Business activities"]
["21.2.1.1","Energy costs","EUR/year",421252.45861441933,420103.45293956873,420000,420000,420000]
["21.2.1.2","Fuel costs","EUR/year",11114.63772919087,11490.012139628872,11500,11500,11500]
["21.2.1.3","Staff costs","EUR/year",2049005.785734585,2066613.1121544829,1074343.5050025601,1074343.5050025601,1074343.5050025601]
["21.2.1.4","Materials and consumables","EUR/year",149117.86590301059,149980.88662207729,150000,150000,150000]
["21.2.1.5","Contracted services","EUR/year",245845.62109703373,245069.68282426172,245000,245000,245000]
["21.2.1.6","Maintenance and repair","EUR/year",29707.402915185281,30480.337613609674,30500,30500,30500]
["21.2.1.7","Other indirect costs","EUR/year",49869.245815547343,51461.664657030931,51500,51500,51500]
["21.2.1.8","Total business activities costs","EUR/year",2955913.0178089719,2975199.1489506601,1982843.5050025601,1982843.5050025601,1982843.5050025601]
[]
["21.2.2","Total operating costs excl bad debts"]
["21.2.2.1","Total","EUR/year",6552765.7541867793,6562565.3089506608,5372760.6650025602,5372760.6650025602,5372760.6650025602]

{"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,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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",0,0,0,0,0]
["22.1.1.2","Energy costs","EUR/year",0,0,0,0,0]
["22.1.1.3","Fuel costs","EUR/year",0,0,0,0,0]
["22.1.1.4","Staff costs","EUR/year",85874.05,103873.29999999999,87132.3,87132.3,87132.3]
["22.1.1.5","Materials and consumables","EUR/year",7157.29,7500,7500,7500,7500]
["22.1.1.6","Contracted services","EUR/year",54.2,55,55,55,55]
["22.1.1.7","Maintenance and repair","EUR/year",10000,10000,10000,10000,10000]
["22.1.1.8","Other direct costs","EUR/year",2181,2500,2500,2500,2500]
["22.1.1.9","Total wastewater collection costs ","EUR/year",105266.54,123928.29999999999,107187.3,107187.3,107187.3]
[]
["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",13028.426555085134,12992.890297100063,12992.890297100063,12992.890297100063,12992.890297100063]
["22.2.1.2","Fuel costs","EUR/year",343.75168234610942,355.36120019470741,355.36120019470741,355.36120019470741,355.36120019470741]
["22.2.1.3","Staff costs","EUR/year",63371.312960863455,63915.869448076788,62608.869448076803,62608.869448076803,62608.869448076803]
["22.2.1.4","Materials and consumables","EUR/year",4611.892759886925,4638.5841223322868,4638.5841223322868,4638.5841223322868,4638.5841223322868]
["22.2.1.5","Contracted services","EUR/year",7603.4728174340325,7579.4747265235583,7579.4747265235583,7579.4747265235583,7579.4747265235583]
["22.2.1.6","Maintenance and repair","EUR/year",918.78565717067875,942.69085402916517,942.69085402916517,942.69085402916517,942.69085402916517]
["22.2.1.7","Other indirect costs","EUR/year",1542.3478087282683,1591.5978759906475,1591.5978759906475,1591.5978759906475,1591.5978759906475]
["22.2.1.8","Total business activities costs","EUR/year",91419.990241514592,92016.468524247219,90709.468524247233,90709.468524247233,90709.468524247233]
[]
["22.2.2","Total operating costs excl bad debts"]
["22.2.2.1","Total","EUR/year",196686.53024151459,215944.76852424722,197896.76852424722,197896.76852424722,197896.76852424722]

{"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,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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,".",0,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,0,0,0,0,0,0,0,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","5.1 Nderrimi i rrjetit te ujit ne lagjen Tophane ","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,100000,null,100000,100000,null,null,0,null,null,856053,null,856053,856053,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.2","5.2 Nderrimi i rrjetit te ujit ne lagjen Dodona 8.6km","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,46000,46000,null,null,138000,null,138000,184000,null,110000,110000,null,null,330000,null,330000,440000,null,119000,119000,null,null,358000,null,358000,477000]
["31.2.1.3","5.3 Nderrimi i rrjetit te ujit ne lagjen Bregu i diellit 7.8km","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,42000,42000,null,null,125000,null,125000,167000,null,100000,100000,null,null,300000,null,300000,400000,null,108000,108000,null,null,325000,null,325000,433000]
["31.2.1.4","5.4 Nderrimi i rrjetit te ujit ne lagjen e Muhaxherve 3.5km","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,21000,21000,null,null,63000,null,63000,84000,null,50000,50000,null,null,150000,null,150000,200000,null,54000,54000,null,null,163000,null,163000,217000]
["31.2.1.5","5.5 Nderrimi i rrjetit te ujit ne lagjen Kalabri 10.7km ","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,50000,50000,null,null,150000,null,150000,200000,null,120000,120000,null,null,360000,null,360000,480000,null,130000,130000,null,null,390000,null,390000,520000]
["31.2.1.6","5.6 Nderrimi i rrjetit te ujit ne lagjen e Medrezes 5.1 km","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,29000,29000,null,null,88000,null,88000,117000,null,70000,70000,null,null,210000,null,210000,280000,null,76000,76000,null,null,228000,null,228000,304000]
["31.2.1.7","5.7 Nderrimi i rrjetit te ujit ne Fushe Kosove 10.9 km dhe 7 km","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,0,null,0,0,null,244000,244000,null,null,732000,null,732000,976000,null,244000,244000,null,null,732000,null,732000,976000]
["31.2.1.8","5.8 Nderrimi i rrjetit te ujit ne Obiliq","EUR/year",null,null,0,null,null,null,null,0,0,40000,null,40000,null,null,null,null,0,40000,50000,null,50000,null,null,null,null,0,50000,80000,null,80000,null,null,null,null,0,80000,100000,null,100000,null,null,null,null,0,100000]
["31.2.1.9","5.9 Nderrimi i rrjetit te ujit ne Podujeve","EUR/year",null,null,0,null,null,null,null,0,0,40000,null,40000,null,null,null,null,0,40000,50000,null,50000,null,null,null,null,0,50000,80000,null,80000,null,null,null,null,0,80000,200000,null,200000,null,null,null,null,0,200000]
["31.2.1.10","5.10 Nderrimi i rrjetit te ujit ne Drenas","EUR/year",null,null,0,null,null,null,null,0,0,40000,null,40000,null,null,null,null,0,40000,50000,null,50000,null,null,null,null,0,50000,80000,null,80000,null,null,null,null,0,80000,100000,null,100000,null,null,null,null,0,100000]
["31.2.1.11","5.11 Nderrimi i rrjetit te ujit ne Lipjan","EUR/year",null,null,0,null,null,null,null,0,0,40000,null,40000,null,null,null,null,0,40000,50000,null,50000,null,null,null,null,0,50000,80000,null,80000,null,null,null,null,0,80000,150000,null,150000,null,null,null,null,0,150000]
["31.2.1.12","5.12 Nderrimi i rrjetit te ujit ne sistemin e puseve Kroni","EUR/year",null,null,0,null,null,null,null,0,0,30000,null,30000,null,null,null,null,0,30000,null,null,0,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","5.13 Rehabilitimi i sistemit te ujit ne fshatin Caraleve","EUR/year",null,null,0,null,null,null,null,0,0,30000,null,30000,null,null,null,null,0,30000,null,null,0,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.14","5.14 Nderrimi, ndertimi i rrjetit te ujit ne zonen e sherbimit per permiresimin e furnizimit dhe zvoglemin e humbjeve ne zonat rurale","EUR/year",null,null,0,null,null,null,null,0,0,50000,null,50000,null,null,null,null,0,50000,80000,null,80000,null,null,null,null,0,80000,100000,null,100000,null,null,null,null,0,100000,150000,null,150000,null,null,null,null,0,150000]
["31.2.1.15","Nderrimi i gypit AC ne dalje te rezervoarit Mirdita II;  4.2 Ndrrimi i gypit Arbëri -Park DN 700,600,500 mm, L-2000m; Nderrimi i gypit kryesor ne Badovc ne SP; 4.4 Nderrimi i gypit Kodra. DN 400,L=12000 m","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,1546381,null,1546381,1546381,null,62000,62000,null,null,372687,null,372687,434687,null,88000,88000,null,null,263000,null,263000,351000,null,null,0,null,null,null,null,0,0]
["31.2.1.16","4.5 Nderrimi i gypit kryesor ne Lipjan DN 350 mm L=1000; 4.7 Nderrimi i gypave primar ne tere zonen e sherbimit ku mund te paraqiten rrjedhje te medha apo pasiguri e operimit L=1000m; Nderrimi i gypit te celikut nga Shkabaj deri ne Kastriot; Materiali","EUR/year",null,null,0,null,null,null,null,0,0,60000,null,60000,null,null,null,null,0,60000,130000,138000,268000,null,null,263000,null,263000,531000,200000,88000,288000,null,null,263000,null,263000,551000,200000,null,200000,null,null,null,null,0,200000]
["31.2.1.17","Planifikimi, dizajni, mbikqyrja dhe analizimi/mbledhja e te dhenave","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,350000,350000,null,null,150000,null,150000,500000,null,350000,350000,null,null,150000,null,150000,500000,null,700000,700000,null,null,300000,null,300000,1000000]
["31.2.1.18","Kostoja e puneve te paparapara","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,570000,570000,null,null,570000,null,570000,1140000,null,336000,336000,null,null,336000,null,336000,672000,null,144000,144000,null,null,145000,null,145000,289000]
["31.2.1.19","Pergatitja e te dhenave dhe modelimi hidraulik","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,500000,null,500000,500000,null,null,0,null,null,null,null,0,0]
["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,1022267.3151549293,null,1022267.3151549293,null,null,null,null,0,1022267.3151549293,1022267.3151549293,null,1022267.3151549293,null,null,null,null,0,1022267.3151549293,1022267.3151549293,null,1022267.3151549293,null,null,null,null,0,1022267.3151549293]
["31.2.1.21","Totals","EUR/year",0,0,0,0,0,0,0,0,0,330000,0,330000,0,0,1646381,0,1646381,1976381,1432267.3151549292,1308000,2740267.3151549292,0,0,2775740,0,2775740,5516007.3151549296,1642267.3151549292,1556000,3198267.3151549292,0,0,3594000,0,3594000,6792267.3151549296,1922267.3151549292,1575000,3497267.3151549292,0,0,2641000,0,2641000,6138267.3151549296]
[]
[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,0,0,0,0,0,0,0,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,330000,0,330000,0,0,1646381,0,1646381,1976381,1432267.3151549292,1308000,2740267.3151549292,0,0,2775740,0,2775740,5516007.3151549296,1642267.3151549292,1556000,3198267.3151549292,0,0,3594000,0,3594000,6792267.3151549296,1922267.3151549292,1575000,3497267.3151549292,0,0,2641000,0,2641000,6138267.3151549296]
["31.3.1.3","Totals","EUR/year",0,0,0,0,0,0,0,0,0,330000,0,330000,0,0,1646381,0,1646381,1976381,1432267.3151549292,1308000,2740267.3151549292,0,0,2775740,0,2775740,5516007.3151549296,1642267.3151549292,1556000,3198267.3151549292,0,0,3594000,0,3594000,6792267.3151549296,1922267.3151549292,1575000,3497267.3151549292,0,0,2641000,0,2641000,6138267.3151549296]

{"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,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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","5.15 Ndertimi i rrjetit te ujit per fshatra nga fabrika e ujit ne albanik deri ne hyrje  te Prishtines ","EUR/year",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,120000,null,120000,null,null,null,null,0,120000,200000,null,200000,null,null,null,null,0,200000]
["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,100000,0,100000,0,0,0,0,0,100000,120000,0,120000,0,0,0,0,0,120000,200000,0,200000,0,0,0,0,0,200000]
[]
["32.1.2","Supply demand balance, expenditure and sources of finance"]
["32.1.2.1","Sic eshte siguruar nga ZRRUM, ne Letren e dates 20/06/2011","EUR/year",4491,null,4491,null,null,5974,null,5974,10465,null,null,0,null,null,null,null,0,0,null,null,0,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.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",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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",4491,0,4491,0,0,5974,0,5974,10465,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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","5.18 Ndertimi i pusetave te reja","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,100000,null,100000,130000,30000,null,30000,null,null,100000,null,100000,130000,30000,null,30000,null,null,null,null,0,30000]
["32.2.1.2","4.6 Vazhdim i gypit Albanik-Podujev DN 400 mm","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,200000,null,null,null,200000,200000,null,null,0,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",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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.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,30000,0,30000,200000,0,0,0,200000,230000,30000,0,30000,0,0,100000,0,100000,130000,30000,0,30000,0,0,100000,0,100000,130000,30000,0,30000,0,0,0,0,0,30000]
[]
["32.2.2","Supply demand balance, expenditure and sources of finance"]
["32.2.2.1","Sic eshte siguruar nga ZRRUM, ne Letren e dates 20/06/2011","EUR/year",85328,null,85328,null,null,113504,null,113504,198832,null,null,0,null,null,null,null,0,0,null,null,0,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","New pipe Miridite III - Sofali","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,300000,null,300000,null,null,null,null,0,300000,300000,null,300000,null,null,null,null,0,300000,null,null,0,null,null,null,null,0,0]
["32.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]
["32.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]
["32.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]
["32.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]
["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",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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",85328,0,85328,0,0,113504,0,113504,198832,0,0,0,0,0,0,0,0,0,300000,0,300000,0,0,0,0,0,300000,300000,0,300000,0,0,0,0,0,300000,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,100000,0,100000,0,0,0,0,0,100000,120000,0,120000,0,0,0,0,0,120000,200000,0,200000,0,0,0,0,0,200000]
["32.3.1.2","Water resources and treatment  - supply demand balance","EUR/year",4491,0,4491,0,0,5974,0,5974,10465,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["32.3.1.3","Total water resources and treatment ","EUR/year",4491,0,4491,0,0,5974,0,5974,10465,0,0,0,0,0,0,0,0,0,100000,0,100000,0,0,0,0,0,100000,120000,0,120000,0,0,0,0,0,120000,200000,0,200000,0,0,0,0,0,200000]
["32.3.1.4","Water distribution - level of service","EUR/year",0,0,0,0,0,0,0,0,0,30000,0,30000,200000,0,0,0,200000,230000,30000,0,30000,0,0,100000,0,100000,130000,30000,0,30000,0,0,100000,0,100000,130000,30000,0,30000,0,0,0,0,0,30000]
["32.3.1.5","Water Distribution  - supply demand balance","EUR/year",85328,0,85328,0,0,113504,0,113504,198832,0,0,0,0,0,0,0,0,0,300000,0,300000,0,0,0,0,0,300000,300000,0,300000,0,0,0,0,0,300000,0,0,0,0,0,0,0,0,0]
["32.3.1.6","Total water distribution","EUR/year",85328,0,85328,0,0,113504,0,113504,198832,30000,0,30000,200000,0,0,0,200000,230000,330000,0,330000,0,0,100000,0,100000,430000,330000,0,330000,0,0,100000,0,100000,430000,30000,0,30000,0,0,0,0,0,30000]
["32.3.1.7","Totals","EUR/year",89819,0,89819,0,0,119478,0,119478,209297,30000,0,30000,200000,0,0,0,200000,230000,430000,0,430000,0,0,100000,0,100000,530000,450000,0,450000,0,0,100000,0,100000,550000,230000,0,230000,0,0,0,0,0,230000]

{"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,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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","2.7 Rehabilitimi i fabrikes se ujit ne Badovc faza II","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,240000,240000,null,null,360000,null,360000,600000,null,null,0,null,null,null,null,0,0,null,null,0]
["33.1.1.2","2.8 Rehabilitimi rezervuarit dhe stacionit te pompave ne Lipjan","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,30000,null,30000,null,null,null,null,0,30000,30000,null,30000,null,null,null,null,0,30000]
["33.1.1.3","2.8 Rehabilitimi rezervuarit dhe stacionit te pompave ne Obiliq","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,30000,null,30000,null,null,null,null,0,30000,30000,null,30000,null,null,null,null,0,30000]
["33.1.1.4","2.9 Rehabilitimi rezervuarit dhe stacionit te pompave ne Podijev","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,30000,null,30000,null,null,null,null,0,30000,30000,null,30000,null,null,null,null,0,30000]
["33.1.1.5","2.10 Rehabilitimi rezervuarit dhe stacionit te pompave ne Shtime","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,30000,null,30000,null,null,null,null,0,30000,30000,null,30000,null,null,null,null,0,30000]
["33.1.1.6","2.11 Rehabilitimi rezervuarit dhe stacionit te pompave ne Drenas","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,30000,null,30000,null,null,null,null,0,30000,30000,null,30000,null,null,null,null,0,30000]
["33.1.1.7","2.12 Rehabilitimi i galerive te gypave ne rezervuaret dhe objektet prodhuese Batllav, Badovc, Kroni; 3.1 Rehabilitimi i 12 filtrave/nderrimi i reres ne Albanik","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,240000,null,240000,null,null,null,null,0,240000,30000,null,30000,null,null,null,null,0,30000,50000,null,50000,null,null,null,null,0,50000]
["33.1.1.8","2.13 Kontrolli dhe atestimi i paisjeve elektromakinerike; 3.3 Rehabilitimi i Sistemeve elektrike dhe mekanike te fabrikes se ujit ne Albanik dhe Badovc, Kroni","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,90000,null,90000,null,null,null,null,0,90000,130000,null,130000,null,null,null,null,0,130000,180000,null,180000,null,null,null,null,0,180000]
["33.1.1.9","2.16 Rehabilitimi dhe izolimi i te gjitha rezervuareve egzistues","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,80000,null,80000,null,null,null,null,0,80000,100000,null,100000,null,null,null,null,0,100000]
["33.1.1.10","5.2 Riparimi dhe automatizimi i paisjeve dozuese per kimikate qe perdoren si kuagulant ne fabrikat e trajtimit te ujit Batllav, Badovc, Bivolak; 5.1 Riparimi dhe vendosja e klorinatorve te gazët dhe te lënget ne te gjitha pikat dozuese si dhe analizatorve dhe detektorve per prezencen e klorit","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,60000,null,60000,null,null,null,null,0,60000,80000,null,80000,null,null,null,null,0,80000,100000,null,100000,null,null,null,null,0,100000]
["33.1.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,470000,240000,710000,0,0,360000,0,360000,1070000,470000,0,470000,0,0,0,0,0,470000,580000,0,580000,0,0,0,0,0,580000]
[]
[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","1.3 Riparimi i pompave egzistuese dhe motoreve ne te gjitha SP te zones se sherbimit","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,50000,null,50000,null,null,null,null,0,50000,70000,null,70000,null,null,null,null,0,70000]
["33.2.1.4","2.5 Cvendosja dhe rehabilitimi i panelit per komandimin ne SP Shtime","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,15000,null,15000,null,null,null,null,0,15000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.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]
["33.2.1.6","3.2 Nderrim-mirmbajtja e valvulave te sistemeve ne objekte prodhuese dhe stacione pompave","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,20000,null,20000,null,null,null,null,0,20000,20000,null,20000,null,null,null,null,0,20000,null,null,0,null,null,null,null,0,0]
["33.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]
["33.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]
["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,0,0,0,0,0,0,0,0,0,65000,0,65000,0,0,0,0,0,65000,70000,0,70000,0,0,0,0,0,70000,70000,0,70000,0,0,0,0,0,70000]
[]
[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,0,0,0,0,0,0,0,0,0,470000,240000,710000,0,0,360000,0,360000,1070000,470000,0,470000,0,0,0,0,0,470000,580000,0,580000,0,0,0,0,0,580000]
["33.3.1.2","Water Distribution","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,65000,0,65000,0,0,0,0,0,65000,70000,0,70000,0,0,0,0,0,70000,70000,0,70000,0,0,0,0,0,70000]
["33.3.1.3","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,535000,240000,775000,0,0,360000,0,360000,1135000,540000,0,540000,0,0,0,0,0,540000,650000,0,650000,0,0,0,0,0,650000]

{"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,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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","2.1 Ndertimi i rezervuarit ne Badovc dhe riparimi i filtrave V=3000 (m3) Faza I","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,100000,null,100000,100000,null,null,0,null,null,661152,null,661152,661152,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.2","2.3 Ndertimi i rezervuarit ne sistemin e rrafshit Shtime V=300 (m3)","EUR/year",null,null,0,null,null,null,null,0,0,60000,null,60000,null,null,null,null,0,60000,null,null,0,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","2.5 Ndertimi i rezervuarit Carraleve, Shtime V=150(m3)","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,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,60000,0,60000,0,0,100000,0,100000,160000,30000,0,30000,0,0,661152,0,661152,691152,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","1.1 Furnizimi me pompa rezerve, hidropresa","EUR/year",null,null,0,null,null,null,null,0,0,20000,null,20000,null,null,null,null,0,20000,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]
["34.1.2.2","4.1 Rrethimi fizik i burimeve te ujit (liqeneve akumuluese te Badovcit dhe Batllava)","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,125000,125000,null,null,375000,null,375000,500000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.3","1.3 Ndertimi i objektit per magazinimin e klorit bashk me konetnjer dhe boca per klorin e gazet","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,60000,null,60000,null,null,null,null,0,60000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.4","2.1 Konstruktimi dhe ndertimi i nje pjese te nje Largperquesi 35KV nga kryqezimi i rruges Batllave me Largperquesin Batllave deri ne Stacionin e pompimit Batllave","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,180000,null,180000,null,null,null,null,0,180000]
["34.1.2.5","3.2 Ndertimi i hidrostacionit ne Kodren e Trimave per furnizimin e konsumatoreve ne kuotat e larta Q=70(l/s),H=75(m)","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,84000,null,84000,84000,null,null,0,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","4.3 Krijimi i zonave mbrojtese te burimeve, largimi i ndotesve potencial-pastrimi i lumenjeve ne hyrje te burimeve ne Batllave","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,400000,400000,null,null,400000,null,400000,800000,null,400000,400000,null,null,400000,null,400000,800000,null,null,0,null,null,null,null,0,0]
["34.1.2.7","2.4 Furnizimi alternativ i objektit nga Mazgiti per Besi","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,200000,null,200000,null,null,null,null,0,200000,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","6.3 Vendosja e ujematesve zonal","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,73000,null,73000,null,null,31000,null,31000,104000,102000,null,102000,null,null,44000,null,44000,146000,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,20000,0,20000,0,0,84000,0,84000,104000,153000,525000,678000,0,0,806000,0,806000,1484000,302000,400000,702000,0,0,444000,0,444000,1146000,180000,0,180000,0,0,0,0,0,180000]
[]
["34.1.3","Supply demand balance, expenditure and sources of finance"]
["34.1.3.1","Sic eshte siguruar nga ZRRUM, ne Letren e dates 20/06/2011","EUR/year",384969,null,384969,null,null,114877,null,114877,499846,null,null,0,null,null,null,null,0,0,null,null,0,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","Planifikimi, dizajni, mbikqyrja dhe analizimi/ mbledhja e te dhenave","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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","Kostoja e puneve te paparapara","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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.4","Pergatitja e te dhenave dhe modelimi hidraulik","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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.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.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]
["34.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]
["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",384969,0,384969,0,0,114877,0,114877,499846,0,0,0,0,0,0,0,0,0,0,0,0,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.200000000000003,"Water distribution"]
["34.2.1","Level of service improvement (including backlog infrastructure renewals), expenditure and sources of finance"]
["34.2.1.1","6.1 Ndertimi i kycjeve te reja dhe ujematesit e ri","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,330000,null,330000,330000,null,null,0,null,null,850000,null,850000,850000,null,null,0,null,null,845356,null,845356,845356,null,null,0,null,null,null,null,0,0]
["34.2.1.2","Punetoria e kalibrimit te ujematesve","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,400000,null,400000,null,null,220000,null,220000,620000,null,null,0,null,null,null,null,0,0]
["34.2.1.3","1.2 Ndertimi i SP te tipit Hidroprese ne Lipjan Q=60l/s","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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","2.6 Kompletimi i pikave matese te energjise elektrike per te gjitha pikat matese te sistemit","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,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,330000,0,330000,330000,50000,0,50000,0,0,850000,0,850000,900000,400000,0,400000,0,0,1065356,0,1065356,1465356,0,0,0,0,0,0,0,0,0]
[]
["34.2.2","Supply demand balance, expenditure and sources of finance"]
["34.2.2.1","Sic eshte siguruar nga ZRRUM, ne Letren e dates 20/06/2011","EUR/year",45290,null,45290,null,null,13515,null,13515,58805,null,null,0,null,null,null,null,0,0,null,null,0,null,null,100000,null,100000,100000,null,null,0,null,null,400000,null,400000,400000,100000,null,100000,null,null,null,null,0,100000]
["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",45290,0,45290,0,0,13515,0,13515,58805,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100000,0,100000,100000,0,0,0,0,0,400000,0,400000,400000,100000,0,100000,0,0,0,0,0,100000]
[]
[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,60000,0,60000,0,0,100000,0,100000,160000,30000,0,30000,0,0,661152,0,661152,691152,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,20000,0,20000,0,0,84000,0,84000,104000,153000,525000,678000,0,0,806000,0,806000,1484000,302000,400000,702000,0,0,444000,0,444000,1146000,180000,0,180000,0,0,0,0,0,180000]
["34.3.1.3","Water resources and treatment  - supply demand balance","EUR/year",384969,0,384969,0,0,114877,0,114877,499846,0,0,0,0,0,0,0,0,0,0,0,0,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.4","Total Water resources and treatment ","EUR/year",384969,0,384969,0,0,114877,0,114877,499846,80000,0,80000,0,0,184000,0,184000,264000,183000,525000,708000,0,0,1467152,0,1467152,2175152,302000,400000,702000,0,0,444000,0,444000,1146000,180000,0,180000,0,0,0,0,0,180000]
["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,330000,0,330000,330000,50000,0,50000,0,0,850000,0,850000,900000,400000,0,400000,0,0,1065356,0,1065356,1465356,0,0,0,0,0,0,0,0,0]
["34.3.1.6","Water distribution  - supply demand balance","EUR/year",45290,0,45290,0,0,13515,0,13515,58805,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100000,0,100000,100000,0,0,0,0,0,400000,0,400000,400000,100000,0,100000,0,0,0,0,0,100000]
["34.3.1.7","Total Water distribution ","EUR/year",45290,0,45290,0,0,13515,0,13515,58805,0,0,0,0,0,330000,0,330000,330000,50000,0,50000,0,0,950000,0,950000,1000000,400000,0,400000,0,0,1465356,0,1465356,1865356,100000,0,100000,0,0,0,0,0,100000]
["34.3.1.8","Totals","EUR/year",430259,0,430259,0,0,128392,0,128392,558651,80000,0,80000,0,0,514000,0,514000,594000,233000,525000,758000,0,0,2417152,0,2417152,3175152,702000,400000,1102000,0,0,1909356,0,1909356,3011356,280000,0,280000,0,0,0,0,0,280000]

{"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,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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","Sic eshte siguruar nga ZRRUM, ne Letren e dates 20/06/2011","EUR/year",22645,null,22645,null,null,6757,null,6757,29402,null,null,0,null,null,null,null,0,0,null,null,0,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","1.1 Programe te licencuara","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,21534,null,21534,null,null,null,null,0,21534,21534,null,21534,null,null,null,null,0,21534,21534,null,21534,null,null,null,null,0,21534]
["35.1.1.3","1.2 Harta Orto Foto dhe avancime te GIS-IT, leximi i ujmatesve dhe hartimi i projekteve dhe paisjeve gjeodozike","EUR/year",null,null,0,null,null,null,null,0,0,35890,null,35890,null,null,null,null,0,35890,57424,null,57424,null,null,null,null,0,57424,71780,null,71780,null,null,null,null,0,71780,null,null,0,null,null,null,null,0,0]
["35.1.1.4","1.6 Paisje Hardwerike dhe avancimi i sofwerit te Pronetit","EUR/year",null,null,0,null,null,null,null,0,0,7178,null,7178,null,null,null,null,0,7178,7178,null,7178,null,null,null,null,0,7178,14356,null,14356,null,null,null,null,0,14356,7178,null,7178,null,null,null,null,0,7178]
["35.1.1.5","1.8 Trajnime - ngritje e kapaciteteve njerzore","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,21534,null,21534,null,null,null,null,0,21534,null,null,0,null,null,null,null,0,0,50246,null,50246,null,null,null,null,0,50246]
["35.1.1.6","1.9 Fushata vetedijesimi","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,38800,null,38800,null,null,null,null,0,38800,58200,null,58200,null,null,null,null,0,58200,0,null,0,null,null,null,null,0,0]
["35.1.1.7","1 Ndertimi i zyreve administrative, depove, puntorive, zyrave per konsumatore","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,344544,null,344544,null,null,null,null,0,344544,279942,null,279942,null,null,null,null,0,279942,380434,null,380434,null,null,null,null,0,380434]
["35.1.1.8","1.4 Rehabilitimi fizik i objekteve (lyerja, izolimi, ndertimi i ndonje pjese) te gjitha objekteve te kompanise","EUR/year",null,null,0,null,null,null,null,0,0,35890,null,35890,null,null,null,null,0,35890,50246,null,50246,null,null,null,null,0,50246,null,null,0,null,null,null,null,0,0,57424,null,57424,null,null,null,null,0,57424]
["35.1.1.9","1.5 Zgjerimi i kapacitetit te ngrohjes qendrore","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,145500,null,145500,null,null,null,null,0,145500,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["35.1.1.10","1.6 Makina punuese dhe automjete per nevoja te kompanise","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,242500,null,242500,null,null,null,null,0,242500,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",22645,0,22645,0,0,6757,0,6757,29402,78958,0,78958,0,0,0,0,0,78958,929260,0,929260,0,0,0,0,0,929260,445812,0,445812,0,0,0,0,0,445812,516816,0,516816,0,0,0,0,0,516816]

{"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,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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","1.1 Nderrimi i rrjetit te ujerave te zeza ne lagjen Dodona","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,1133000,null,1133000,1133000,null,null,0,null,null,467000,null,467000,467000,null,null,0,null,null,null,null,0,0]
["41.1.1.2","1.2 Inspektimi i rrjetit te kanalizimit dhe drenazhimit 200 km","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,378000,378000,null,null,null,null,0,378000,null,22000,22000,null,null,null,null,0,22000,null,null,0,null,null,null,null,0,0]
["41.1.1.3","1.3 Pastrimi i kolektorve Prishtina dhe Vellusha","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,270000,null,270000,270000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.1.1.4","1.4 Inspektim i kolektorve te medhenj","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,54500,null,54500,54500,null,null,0,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.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.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,333706.27432910167,null,333706.27432910167,null,null,null,null,0,333706.27432910167,333706.27432910167,null,333706.27432910167,null,null,null,null,0,333706.27432910167,333706.27432910167,null,333706.27432910167,null,null,null,null,0,333706.27432910167]
["41.1.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,54500,0,54500,54500,333706.27432910167,378000,711706.27432910167,0,0,1403000,0,1403000,2114706.2743291017,333706.27432910167,22000,355706.27432910167,0,0,467000,0,467000,822706.27432910167,333706.27432910167,0,333706.27432910167,0,0,0,0,0,333706.27432910167]
[]
[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,"kredite",null,0,null,null,null,null,0,0,null,null,0,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,"kredite",null,0,null,null,null,null,0,0,null,null,0,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,0,0,0,0,0,54500,0,54500,54500,333706.27432910167,378000,711706.27432910167,0,0,1403000,0,1403000,2114706.2743291017,333706.27432910167,22000,355706.27432910167,0,0,467000,0,467000,822706.27432910167,333706.27432910167,0,333706.27432910167,0,0,0,0,0,333706.27432910167]
["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,0,0,0,0,0,54500,0,54500,54500,333706.27432910167,378000,711706.27432910167,0,0,1403000,0,1403000,2114706.2743291017,333706.27432910167,22000,355706.27432910167,0,0,467000,0,467000,822706.27432910167,333706.27432910167,0,333706.27432910167,0,0,0,0,0,333706.27432910167]

{"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,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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.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.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,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["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",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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.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,0,0,0,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,"Wastewater treatment"]
["42.2.1","Quality impriovement, expenditure and sources of finance"]
["42.2.1.1","3.1 Hartimi i studimit te fisibilitetit","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,0,null,0,null,null,400000,null,400000,400000,null,null,0,null,null,null,null,0,0,0,null,0,null,null,null,null,0,0]
["42.2.1.2","3.3 Pergaditja e projektit per Sistemin e trajtimit te ujrave te zeza per Drenasin dhe Shtime","EUR/year",null,null,0,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,50000,null,null,null,50000,150000,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,400000,0,400000,400000,100000,0,100000,50000,0,0,0,50000,150000,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,0,0,0,0,0,0,0,0,0,0,0,0,0]
["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,0,0,0,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.3","Total 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]
["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,400000,0,400000,400000,100000,0,100000,50000,0,0,0,50000,150000,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,400000,0,400000,400000,100000,0,100000,50000,0,0,0,50000,150000,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,0,0,0,0,0,400000,0,400000,400000,100000,0,100000,50000,0,0,0,50000,150000,0,0,0,0,0,0,0,0,0]

{"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,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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, ne Letren e dates 20/06/2011","EUR/year",10027,null,10027,null,null,2992,null,2992,13019,null,null,0,null,null,null,null,0,0,null,null,0,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",10027,0,10027,0,0,2992,0,2992,13019,0,0,0,0,0,0,0,0,0,0,0,0,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",10027,0,10027,0,0,2992,0,2992,13019,0,0,0,0,0,0,0,0,0,0,0,0,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",10027,0,10027,0,0,2992,0,2992,13019,0,0,0,0,0,0,0,0,0,0,0,0,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",10027,0,10027,0,0,2992,0,2992,13019,0,0,0,0,0,0,0,0,0,0,0,0,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,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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","Sic eshte siguruar nga ZRRUM, ne Letren e dates 20/06/2011","EUR/year",1114,null,1114,null,null,332,null,332,1446,null,null,0,null,null,null,null,0,0,null,null,0,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","1.1 Programe te licencuara","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,666,null,666,null,null,null,null,0,666,666,null,666,null,null,null,null,0,666,666,null,666,null,null,null,null,0,666]
["45.1.1.3","1.2 Harta Orto Foto dhe avancime te GIS-IT,leximi i ujmatesve dhe hartimi i projekteve dhe paisjeve gjeodozike","EUR/year",null,null,0,null,null,null,null,0,0,1110,null,1110,null,null,null,null,0,1110,1776,null,1776,null,null,null,null,0,1776,2220,null,2220,null,null,null,null,0,2220,null,null,0,null,null,null,null,0,0]
["45.1.1.4","1.6 Paisje Hardwerike dhe avancimi i sofwerit te Pronetit","EUR/year",null,null,0,null,null,null,null,0,0,222,null,222,null,null,null,null,0,222,222,null,222,null,null,null,null,0,222,444,null,444,null,null,null,null,0,444,222,null,222,null,null,null,null,0,222]
["45.1.1.5","1.8 Trajnime - ngritje e kapaciteteve njerzore","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,666,null,666,null,null,null,null,0,666,null,null,0,null,null,null,null,0,0,1554,null,1554,null,null,null,null,0,1554]
["45.1.1.6","1.9 Fushata vetedijesimi","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,1200,null,1200,null,null,null,null,0,1200,1800,null,1800,null,null,null,null,0,1800,null,null,0,null,null,null,null,0,0]
["45.1.1.7","1 Ndertimi i zyreve administrative, depove, puntorive, zyrave per konsumatore","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,10656,null,10656,null,null,null,null,0,10656,8658,null,8658,null,null,null,null,0,8658,11766,null,11766,null,null,null,null,0,11766]
["45.1.1.8","1.4 Rehabilitimi fizik i objekteve (lyerja, izolimi, ndertimi i ndonje pjese) te gjitha objekteve te kompanise","EUR/year",null,null,0,null,null,null,null,0,0,1110,null,1110,null,null,null,null,0,1110,1554,null,1554,null,null,null,null,0,1554,null,null,0,null,null,null,null,0,0,1776,null,1776,null,null,null,null,0,1776]
["45.1.1.9","1.5 Zgjerimi i kapacitetit te ngrohjes qendrore","EUR/year",null,null,0,null,null,null,null,0,0,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]
["45.1.1.10","1.6 Makina punuese dhe automjete per nevoja te kompanise","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,7500,null,7500,null,null,null,null,0,7500,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",1114,0,1114,0,0,332,0,332,1446,2442,0,2442,0,0,0,0,0,2442,28740,0,28740,0,0,0,0,0,28740,13788,0,13788,0,0,0,0,0,13788,15984,0,15984,0,0,0,0,0,15984]

{"sheet":"51- W RAB","index":17,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[null,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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",571474,595760.81768459443,644321.28193406574,760234.87094181601,899017.5155930171]
["51.1.1.2","Indexation adjustment","EUR",19795.817684594374,48560.46424947129,13775.589007750325,13965.514579201161,14797.82830666106]
["51.1.1.3","Opening RAB at current year price levels","EUR",591269.81768459443,644321.28193406574,658096.87094181601,774200.38552101713,913815.34389967821]
["51.1.1.4","Additions (net of disposals and grants)","EUR",4491,0,102138,124817.130072,211452.7000549752]
["51.1.1.5","Closing RAB at current year price levels","EUR",595760.81768459443,644321.28193406574,760234.87094181601,899017.5155930171,1125268.0439546534]
[]
["51.1.2","Non-infrastructure"]
["51.1.2.1","Opening RAB at prior year price levels","EUR",4664287,5067445.3597734086,5402764.4644471519,6788237.1518771164,7917056.9229114791]
["51.1.2.2","Indexation adjustment","EUR",161570.56153144961,413047.47127513052,115511.10424988011,124699.91647998264,130314.75695112294]
["51.1.2.3","Opening RAB at current year price levels","EUR",4825857.5615314497,5480492.8310485389,5518275.5686970316,6912937.0683570988,8047371.6798626017]
["51.1.2.4","Additions (net of disposals and grants)","EUR",384969,80000,1448316.8399999999,1219047.3037032001,803520.26020890579]
["51.1.2.5","Depreciation","EUR",-143381.20175804142,-157728.36660138681,-178355.2568199152,-214927.44914881996,-241403.7659990587]
["51.1.2.6","Closing RAB at current year price levels","EUR",5067445.3597734086,5402764.4644471519,6788237.1518771164,7917056.9229114791,8609488.17407245]
["51.1.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-174621.8418413472,-206632.64636016582,-228328.85646416107]
[]
[51.2,"Water distribution"]
[]
["51.2.1","Infrastructure"]
["51.2.1.1","Opening RAB at prior year price levels","EUR",10858003,11319451.432087513,12272099.918316966,12871532.814570583,13451229.980072245]
["51.2.1.2","Indexation adjustment","EUR",376120.43208751187,922648.48622945312,262377.4962536167,236450.05780366162,221407.24547198912]
["51.2.1.3","Opening RAB at current year price levels","EUR",11234123.432087513,12242099.918316966,12534477.414570583,13107982.872374246,13672637.225544235]
["51.2.1.4","Additions (net of disposals and grants)","EUR",85328,30000,337055.39999999997,343247.10769800004,31717.905008246282]
["51.2.1.5","Closing RAB at current year price levels","EUR",11319451.432087513,12272099.918316966,12871532.814570583,13451229.980072245,13704355.130552482]
[]
["51.2.2","Non-infrastructure"]
["51.2.2.1","Opening RAB at prior year price levels","EUR",548740,596169.93319442635,626341.9231791296,737235.74311107933,1211211.2190625148]
["51.2.2.2","Indexation adjustment","EUR",19008.313582497747,48593.81125467769,13391.190317569792,13543.020600950527,19936.536665768992]
["51.2.2.3","Opening RAB at current year price levels","EUR",567748.31358249777,644763.74444910407,639733.11349669937,750778.7637120299,1231147.7557282839]
["51.2.2.4","Additions (net of disposals and grants)","EUR",45290,0,117458.7,488867.09278200002,179734.79504672892]
["51.2.2.5","Depreciation","EUR",-16868.380388071364,-18421.821269974404,-19956.07038561998,-28434.637431515141,-37743.290092904237]
["51.2.2.6","Closing RAB at current year price levels","EUR",596169.93319442635,626341.9231791296,737235.74311107933,1211211.2190625148,1373139.2606821088]
["51.2.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-19538.340662260845,-27337.245214767678,-35699.038208631457]
[]
[51.3,"Business activities"]
[]
["51.3.2","Non-infrastructure"]
["51.3.2.1","Opening RAB at prior year price levels","EUR",274370,298084.96659721318,391000.99016099342,1323518.9021097601,1766406.1784346676]
["51.3.2.2","Indexation adjustment","EUR",9504.1567912488736,24296.905627338845,8359.6011696420392,24313.042231756295,29075.045697034628]
["51.3.2.3","Opening RAB at current year price levels","EUR",283874.15679124888,322381.87222455203,399360.59133063548,1347831.9443415164,1795481.2241317022]
["51.3.2.4","Additions (net of disposals and grants)","EUR",22645,78958,949127.5787999999,463708.11993048724,546410.69315806031]
["51.3.2.5","Depreciation","EUR",-8434.190194035682,-10338.882063558631,-24969.268020875297,-45133.885837335998,-59105.330591735212]
["51.3.2.6","Closing RAB at current year price levels","EUR",298084.96659721318,391000.99016099342,1323518.9021097601,1766406.1784346676,2282786.5866980273]
["51.3.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-24446.599718885525,-43392.011155488792,-55904.067979617685]
[]
[51.4,"Summary"]
["51.4.1","Totals"]
["51.4.1.1","Opening RAB at prior year price levels","EUR",16916874,17876912.509337153,19336528.578038309,22480759.482610352,25244921.816073921]
["51.4.1.2","Indexation adjustment","EUR",585999.28167730244,1457147.1386360715,413414.98099845898,412971.55169555225,415531.41309257678]
["51.4.1.3","Opening RAB at current year price levels","EUR",17502873.281677302,19334059.647973225,19749943.559036765,22893731.034305912,25660453.2291665]
["51.4.1.4","Additions (net of disposals and grants)","EUR",542723,188958,2954096.5187999997,2639686.7541856873,1772836.3534769164]
["51.4.1.5","Depreciation","EUR",-168683.77234014845,-186489.06993491983,-223280.59522641046,-288495.97241767112,-338252.38668369816]
["51.4.1.6","Closing RAB at current year price levels","EUR",17876912.509337153,19336528.578038309,22480759.482610352,25244921.816073921,27095037.195959724]
["51.4.1.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-218606.78222249358,-277361.90273042227,-319931.96265241021]

{"sheet":"52 - Water income","index":18,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[null,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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",884208,1011486,1095000,1149000,1203000]
["52.1.1.2","Volume charges","EUR",5095855.7819904005,5957982.1375000002,7052153.75,7941700,8666503.125]
["52.1.1.3","Total household water tariff income","EUR",5980063.7819904005,6969468.1375000002,8147153.75,9090700,9869503.125]
[]
["52.1.2","Commercial"]
["52.1.2.1","Fixed monthly charges","EUR",303354,312372,321012,328572,336312]
["52.1.2.2","Volume charges","EUR",2334539.12,2551216.1861250005,2805736.1669999999,2999141.327,3170992.4279999998]
["52.1.2.3","Total commercial water tariff income","EUR",2637893.12,2863588.1861250005,3126748.1669999999,3327713.327,3507304.4279999998]
[]
["52.1.3","Institutional"]
["52.1.3.1","Fixed monthly charges","EUR",18810,19098,19278,19458,19638]
["52.1.3.2","Volume charges","EUR",1293770.04,1399978.8900000001,1517853.33,1602463.59,1670604.66]
["52.1.3.3","Total institutional water tariff income","EUR",1312580.04,1419076.8900000001,1537131.33,1621921.59,1690242.66]
[]
["52.1.4","Total water tariff income"]
["52.1.4.1","Household","EUR",5980063.7819904005,6969468.1375000002,8147153.75,9090700,9869503.125]
["52.1.4.2","Commercial","EUR",2637893.12,2863588.1861250005,3126748.1669999999,3327713.327,3507304.4279999998]
["52.1.4.3","Institutional","EUR",1312580.04,1419076.8900000001,1537131.33,1621921.59,1690242.66]
["52.1.4.3","Total water tariff income","EUR",9930536.9419904016,11252133.213625001,12811033.247,14040334.916999999,15067050.213]
[]
[52.2,"Connection fees"]
[]
["52.2.1","Connection fees"]
["52.2.1.1","Household","EUR",1061460,847710,405000,405000,405000]
["52.2.1.2","Commercial","EUR",105196,133280,95200,104720,99960]
["52.2.1.3","Institutional","EUR",33,15,15,15,15]
["52.2.1.4","Total connection fee income","EUR",1166689,981005,500215,509735,504975]
[]
[52.3,"Total income from customers"]
[]
["52.3.1","Total income from customers"]
["52.3.1.1","Tariff income","EUR",9930536.9419904016,11252133.213625001,12811033.247,14040334.916999999,15067050.213]
["52.3.1.2","Connection fees","EUR",1166689,981005,500215,509735,504975]
["52.3.1.3","Total income from customers","EUR",11097225.941990402,12233138.213625001,13311248.247,14550069.916999999,15572025.213]
[]
[52.4,"Cash collection"]
[]
["52.4.1","Cash collection by category (excluding connection fees), excluding VAT"]
["52.4.1.1","Household","EUR",3308785.7470263373,4042291.51975,5132706.8624999998,5908955,6612567.09375]
["52.4.1.2","Commercial","EUR",2347104.6512385532,2577229.3675125004,2907875.79531,3128050.5273799999,3367012.2508799997]
["52.4.1.3","Institutional","EUR",1270818.5144627646,1390695.3522000001,1521760.0167,1621921.59,1690242.66]
["52.4.1.4","Total cash collection","EUR",6926708.9127276549,8010216.2394625004,9562342.6745100003,10658927.117380001,11669822.004629999]
[]
[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",2864517,2671278.0349640632,2927176.6177500002,3014446.8875000002,3181745]
["52.4.1.2","Commercial","EUR",0,290788.46876144689,286358.81861250009,218872.37168999994,199662.79962000018]
["52.4.1.3","Institutional","EUR",0,41761.52553723543,28381.537800000049,15371.313300000038,0]
["52.4.1.4","Total provision for write-off","EUR",2864517,3003828.0292627458,3241916.9741625004,3248690.5724900002,3381407.7996200002]
[]
["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,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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",6040838,6250092.1877848683,6759537.2020112127,6904056.1073902128,7030883.6180829713]
["61.1.1.2","Indexation adjustment","EUR",209254.18778486809,509445.01422634459,144518.90537899971,126827.51069275821,115728.34435364571]
["61.1.1.3","Opening RAB at current year price levels","EUR",6250092.1877848683,6759537.2020112127,6904056.1073902128,7030883.6180829713,7146611.9624366174]
["61.1.1.4","Additions (net of disposals and grants)","EUR",0,0,0,0,0]
["61.1.1.5","Closing RAB at current year price levels","EUR",6250092.1877848683,6759537.2020112127,6904056.1073902128,7030883.6180829713,7146611.9624366174]
[]
["61.1.2","Non-infrastrucutre"]
["61.1.2.1","Opening RAB at prior year price levels","EUR",157231,167913.29979163955,176411.34391886592,175034.93221036979,173157.45751750073]
["61.1.2.2","Indexation adjustment","EUR",5446.4703737465888,13686.61306601654,3771.6745329853534,3215.3917047044933,2850.1717507380617]
["61.1.2.3","Opening RAB at current year price levels","EUR",162677.47037374659,181599.91285765611,180183.01845185127,178250.32391507429,176007.62926823879]
["61.1.2.4","Additions (net of disposals and grants)","EUR",10027,0,0,0,0]
["61.1.2.5","Depreciation","EUR",-4791.1705821070454,-5188.5689387901748,-5148.0862414814646,-5092.8663975735508,-5028.789407663965]
["61.1.2.6","Closing RAB at current year price levels","EUR",167913.29979163955,176411.34391886592,175034.93221036979,173157.45751750073,170978.83986057481]
["61.1.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-5040.3241119675977,-4896.3148516256651,-4756.4201415792177]
[]
[61.2,"Wastewater treatment"]
[]
["61.2.1","Infrastructure"]
["61.2.1.1","Opening RAB at prior year price levels","EUR",0,0,0,0,104014.27506]
["61.2.1.2","Indexation adjustment","EUR",0,0,0,0,1712.0749674875999]
["61.2.1.3","Opening RAB at current year price levels","EUR",0,0,0,0,105726.3500274876]
["61.2.1.4","Additions (net of disposals and grants)","EUR",0,0,0,104014.27506,0]
["61.2.1.5","Closing RAB at current year price levels","EUR",0,0,0,104014.27506,105726.3500274876]
[]
["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",17470,18656.812110951949,22008.142327083766,50771.540266892902,64363.560061604745]
["61.4.2.2","Indexation adjustment","EUR",605.15952597994612,1520.7167551636933,470.53408295305093,932.67319470282268,1059.4241986140141]
["61.4.2.3","Opening RAB at current year price levels","EUR",18075.159525979947,20177.528866115641,22478.676410036816,51704.213461595726,65422.984260218756]
["61.4.2.4","Additions (net of disposals and grants)","EUR",1114,2442,29354.461199999998,14341.488245272802,16899.299788393619]
["61.4.2.5","Depreciation","EUR",-532.34741502799852,-611.38653903187537,-1061.597343143909,-1682.141645263775,-2110.6466901261592]
["61.4.2.6","Closing RAB at current year price levels","EUR",18656.812110951949,22008.142327083766,50771.540266892902,64363.560061604745,80211.637358486216]
["61.4.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-1039.3754950595362,-1617.2219094864063,-1996.3298549296519]
[]
[61.5,"Summary"]
["61.5.1","Totals"]
["61.5.1.1","Opening RAB at prior year price levels","EUR",6215539,6436662.2996874601,6957956.6882571625,7129862.5798674757,7372418.9107220769]
["61.5.1.2","Indexation adjustment","EUR",215305.81768459463,524652.34404752485,148761.11399493812,130975.57559216552,121350.01527048538]
["61.5.1.3","Opening RAB at current year price levels","EUR",6430844.8176845955,6961314.643734985,7106717.8022521008,7260838.1554596415,7493768.9259925634]
["61.5.1.4","Additions (net of disposals and grants)","EUR",11141,2442,29354.461199999998,118355.76330527281,16899.299788393619]
["61.5.1.5","Depreciation","EUR",-5323.5179971350444,-5799.9554778220499,-6209.6835846253734,-6775.0080428373258,-7139.4360977901242]
["61.5.1.6","Closing RAB at current year price levels","EUR",6436662.2996874601,6957956.6882571625,7129862.5798674757,7372418.9107220769,7503528.789683166]
["61.5.1.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-6079.6996070271343,-6513.536761112071,-6752.74999650887]

{"sheet":"62 - WW income","index":20,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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",479072.61465439998,537608.4,742320.375,782807.875,989412]
["62.1.1.2","Commercial","EUR",252447.81578744063,295745.41375000001,334689.14600000001,374215.152,415492.49300000002]
["62.1.1.3","Institutional","EUR",143386.60151196172,160456.5,178294.05,196457.4,214946.55000000002]
["62.1.1.4","Total water tariff income","EUR",874907.03195380233,993810.31374999997,1255303.571,1353480.4269999999,1619851.0430000001]
[]
[62.2,"Connection fees"]
[]
["62.2.1","Connection fees"]
["62.2.1.1","Household","EUR",591480,513780,270000,270000,270000]
["62.2.1.2","Commercial","EUR",181384,88480,63200,69520,66360]
["62.2.1.3","Institutional","EUR",632,1580,1580,1580,1580]
["62.2.1.4","Total connection fee income","EUR",773496,603840,334780,341100,337940]
[]
[62.3,"Total income from customers"]
[]
["62.3.1","Total income from customers"]
["62.3.1.1","Tariff income","EUR",874907.03195380233,993810.31374999997,1255303.571,1353480.4269999999,1619851.0430000001]
["62.3.1.2","Connection fees","EUR",773496,603840,334780,341100,337940]
["62.3.1.3","Total income from customers","EUR",1648403.0319538023,1597650.31375,1590083.571,1694580.4269999999,1957791.0430000001]
[]
[62.4,"Cash collection"]
[]
["62.4.1","Cash collection by category (excluding connection fees), excluding VAT"]
["62.4.1.1","Household","EUR",265072.19604128029,311812.87199999997,467661.83624999999,508825.11875000002,662906.04]
["62.4.1.2","Commercial","EUR",224619.20012502832,266170.87237500004,311260.90578000003,351762.24287999998,398872.79327999998]
["62.4.1.3","Institutional","EUR",138824.56107384933,157247.37,176511.10949999999,196457.4,214946.55000000002]
["62.4.1.4","Total cash collection","EUR",628515.95724015799,735231.114375,955433.8515300001,1057044.7616299998,1276725.38328]
[]
[62.5,"Provisions for write off (offset by 12 months)"]
[]
["62.5.1","Write-off provisions (excluding VAT)"]
["62.5.1.1","Household","EUR",628797,214000.41861311969,225795.52800000005,274658.53875000001,273982.75624999998]
["62.5.1.2","Commercial","EUR",0,27828.61566241231,29574.541374999972,23428.240219999978,22452.909120000026]
["62.5.1.3","Institutional","EUR",0,4562.0404381123953,3209.1300000000047,1782.940499999997,0]
["62.5.1.4","Total provision for write-off","EUR",628797,246391.0747136444,258579.19937500003,299869.71947000001,296435.66537]
[]
["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,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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,9930536.9419904016,null,null,null,874907.03195380233,10805443.973944204]
[]
[81.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["81.2.1.1","Service charges","EUR",73099.026377806833,0,73099.026377806833,0,0,0,0,73099.026377806833]
["81.2.1.2","Energy costs","EUR",1187334.75,248850.2,1436184.95,0,0,0,0,1436184.95]
["81.2.1.3","Fuel costs","EUR",143.15,81282.599999999991,81425.749999999985,0,0,0,0,81425.749999999985]
["81.2.1.4","Staff costs","EUR",473356.48,729629.7,1202986.18,85874.05,0,0,85874.05,1288860.23]
["81.2.1.5","Materials and consumables","EUR",279313.02,208747.08000000005,488060.10000000009,7157.29,0,0,7157.29,495217.39000000007]
["81.2.1.6","Contracted services","EUR",148816.95999999999,65876.69,214693.65,54.2,0,0,54.2,214747.85]
["81.2.1.7","Maintenance and repair","EUR",26447.74,46528.51,72976.25,10000,0,0,10000,82976.25]
["81.2.1.8","Other direct costs","EUR",13397.08,14029.75,27426.83,2181,0,0,2181,29607.83]
["81.2.1.9","Total Direct costs","EUR",2201908.2063778071,1394944.53,3596852.7363778073,105266.54,0,0,105266.54,3702119.2763778074]
[]
[81.3,"Indirect costs"]
[]
["81.3.1.","Business activities"]
["81.3.1.1","Energy costs","EUR",null,null,421252.45861441933,null,null,null,13028.426555085134,434280.88516950444]
["81.3.1.2","Fuel costs","EUR",null,null,11114.63772919087,null,null,null,343.75168234610942,11458.38941153698]
["81.3.1.3","Staff costs","EUR",null,null,2049005.785734585,null,null,null,63371.312960863455,2112377.0986954486]
["81.3.1.4","Materials and consumables","EUR",null,null,149117.86590301059,null,null,null,4611.892759886925,153729.75866289751]
["81.3.1.5","Contracted services","EUR",null,null,245845.62109703373,null,null,null,7603.4728174340325,253449.09391446775]
["81.3.1.6","Maintenance and repair","EUR",null,null,29707.402915185281,null,null,null,918.78565717067875,30626.188572355961]
["81.3.1.7","Other indirect costs","EUR",null,null,49869.245815547343,null,null,null,1542.3478087282683,51411.593624275614]
["81.3.1.8","Total Busiiness activities costs","EUR",null,null,2955913.0178089719,null,null,null,91419.990241514592,3047333.0080504864]
[]
["81.3.2.","Other indirect costs"]
["81.3.2.1","Bad debts","EUR",null,null,2864517,null,null,null,628797,3493314]
["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,2864517,null,null,null,628797,3493314]
["81.3.2.4","Total all indirect costs","EUR",null,null,5820430.0178089719,null,null,null,720216.99024151464,6540647.0080504864]
["81.3.2.5","Total direct and indirect costs","EUR",null,null,9417282.7541867793,null,null,null,825483.53024151467,10242766.284428295]
[]
[81.400000000000006,"Net Income before cap maintenance"]
[]
["81.4.1","Net income"]
["81.4.1.1.","Net income before capital maintenance","EUR",null,null,513254.18780362234,null,null,null,49423.50171228766,562677.68951590918]
[]
[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",143381.20175804142,16868.380388071364,160249.58214611278,4791.1705821070454,0,0,4791.1705821070454,165040.75272821981]
["81.5.1.3","Depreciation (business activities)","EUR",null,null,8434.190194035682,null,null,null,5323.5179971350444,13757.708191170726]
["81.5.1.4","Total capital maintenance","EUR",143381.20175804142,16868.380388071364,168683.77234014845,4791.1705821070454,0,0,10114.688579242091,178798.46091939055]
[]
[81.599999999999994,"Net Income"]
[]
["81.6.1","Net income"]
["81.6.1.1","Net income before taxes and dividends","EUR",null,null,344570.41546347388,null,null,null,39308.813133045565,383879.22859651863]

{"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,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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,11252133.213625001,null,null,null,993810.31374999997,12245943.527375001]
[]
[82.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["82.2.1.1","Service charges","EUR",81714.959999999992,0,81714.959999999992,0,0,0,0,81714.959999999992]
["82.2.1.2","Energy costs","EUR",1165692.28,235105.44,1400797.72,0,0,0,0,1400797.72]
["82.2.1.3","Fuel costs","EUR",150,81872.039999999994,82022.039999999994,0,0,0,0,82022.039999999994]
["82.2.1.4","Staff costs","EUR",530558.38,785893,1316451.3799999999,103873.29999999999,0,0,103873.29999999999,1420324.68]
["82.2.1.5","Materials and consumables","EUR",226429.7,210000,436429.7,7500,0,0,7500,443929.7]
["82.2.1.6","Contracted services","EUR",80925.179999999993,70925.179999999993,151850.35999999999,55,0,0,55,151905.35999999999]
["82.2.1.7","Maintenance and repair","EUR",30100,60000,90100,10000,0,0,10000,100100]
["82.2.1.8","Other direct costs","EUR",13000,15000,28000,2500,0,0,2500,30500]
["82.2.1.9","Total Direct costs","EUR",2128570.5,1458795.66,3587366.16,123928.29999999999,0,0,123928.29999999999,3711294.46]
[]
[82.3,"Indirect costs"]
[]
["82.3.1.","Business activities"]
["82.3.1.1","Energy costs","EUR",null,null,420103.45293956873,null,null,null,12992.890297100063,433096.34323666879]
["82.3.1.2","Fuel costs","EUR",null,null,11490.012139628872,null,null,null,355.36120019470741,11845.37333982358]
["82.3.1.3","Staff costs","EUR",null,null,2066613.1121544829,null,null,null,63915.869448076788,2130528.9816025598]
["82.3.1.4","Materials and consumables","EUR",null,null,149980.88662207729,null,null,null,4638.5841223322868,154619.47074440957]
["82.3.1.5","Contracted services","EUR",null,null,245069.68282426172,null,null,null,7579.4747265235583,252649.15755078528]
["82.3.1.6","Maintenance and repair","EUR",null,null,30480.337613609674,null,null,null,942.69085402916517,31423.02846763884]
["82.3.1.7","Other indirect costs","EUR",null,null,51461.664657030931,null,null,null,1591.5978759906475,53053.262533021581]
["82.3.1.8","Total Busiiness activities costs","EUR",null,null,2975199.1489506601,null,null,null,92016.468524247219,3067215.6174749075]
[]
["82.3.2.","Other indirect costs"]
["82.3.2.1","Bad debts","EUR",null,null,3003828.0292627458,null,null,null,246391.0747136444,3250219.1039763903]
["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,3003828.0292627458,null,null,null,246391.0747136444,3250219.1039763903]
["82.3.2.4","Total all indirect costs","EUR",null,null,5979027.1782134064,null,null,null,338407.54323789163,6317434.7214512983]
["82.3.2.5","Total direct and indirect costs","EUR",null,null,9566393.3382134065,null,null,null,462335.84323789162,10028729.181451298]
[]
[82.4,"Net Income before cap maintenance"]
[]
["82.4.1","Net income"]
["82.4.1.1.","Net income before capital maintenance","EUR",null,null,1685739.8754115943,null,null,null,531474.47051210841,2217214.3459237032]
[]
[82.5,"Capital maintenance"]
[]
["82.5.1","Capital maintenance"]
["82.5.1.1","Infrastructure renewals","EUR",0,330000,330000,0,0,0,0,330000]
["82.5.1.2","Depreciation (service activities)","EUR",157728.36660138681,18421.821269974404,176150.18787136121,5188.5689387901748,0,0,5188.5689387901748,181338.75681015139]
["82.5.1.3","Depreciation (business activities)","EUR",null,null,10338.882063558631,null,null,null,5799.9554778220499,16138.837541380681]
["82.5.1.4","Total capital maintenance","EUR",157728.36660138681,348421.8212699744,516489.06993491983,5188.5689387901748,0,0,10988.524416612225,527477.59435153205]
[]
[82.6,"Net Income"]
[]
["82.6.1","Net income"]
["82.6.1.1","Net income before taxes and dividends","EUR",null,null,1169250.8054766743,null,null,null,520485.94609549618,1689736.7515721712]

{"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,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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,12811033.247,null,null,null,1255303.571,14066336.818]
[]
[83.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["83.2.1.1","Service charges","EUR",83462.025844799995,0,83462.025844799995,0,0,0,0,83462.025844799995]
["83.2.1.2","Energy costs","EUR",1190614.7809464,240131.99430719999,1430746.7752536,0,0,0,0,1430746.7752536]
["83.2.1.3","Fuel costs","EUR",153.20699999999999,83622.464215199987,83775.671215199982,0,0,0,0,83775.671215199982]
["83.2.1.4","Staff costs","EUR",415918.58068439999,727008.07019999996,1142926.6508843999,88995.188574,0,0,88995.188574,1231921.8394583999]
["83.2.1.5","Materials and consumables","EUR",231270.766986,214489.8,445760.56698599999,7660.3499999999995,0,0,7660.3499999999995,453420.91698599997]
["83.2.1.6","Contracted services","EUR",82655.36034839999,72441.560348399988,155096.92069679999,56.175899999999999,0,0,56.175899999999999,155153.09659679999]
["83.2.1.7","Maintenance and repair","EUR",30743.537999999997,61282.799999999996,92026.337999999989,10213.799999999999,0,0,10213.799999999999,102240.13799999999]
["83.2.1.8","Other direct costs","EUR",13277.939999999999,15320.699999999999,28598.639999999999,2553.4499999999998,0,0,2553.4499999999998,31152.09]
["83.2.1.9","Total Direct costs","EUR",2048096.1998099997,1414297.3890707998,3462393.5888807997,109478.96447400001,0,0,109478.96447400001,3571872.5533547997]
[]
[83.3,"Indirect costs"]
[]
["83.3.1.","Business activities"]
["83.3.1.1","Energy costs","EUR",null,null,428979.6,null,null,null,13270.678291652061,442250.27829165204]
["83.3.1.2","Fuel costs","EUR",null,null,11745.869999999999,null,null,null,362.95882265487023,12108.828822654868]
["83.3.1.3","Staff costs","EUR",null,null,1097312.9691395147,null,null,null,63947.447076876684,1161260.4162163914]
["83.3.1.4","Materials and consumables","EUR",null,null,153207,null,null,null,4737.7570508677509,157944.75705086775]
["83.3.1.5","Contracted services","EUR",null,null,250238.09999999998,null,null,null,7741.5238961766318,257979.62389617661]
["83.3.1.6","Maintenance and repair","EUR",null,null,31152.09,null,null,null,962.84558448830865,32114.93558448831]
["83.3.1.7","Other indirect costs","EUR",null,null,52601.07,null,null,null,1625.6262385793275,54226.69623857933]
["83.3.1.8","Total Busiiness activities costs","EUR",null,null,2025236.6991395149,null,null,null,92648.83696129563,2117885.5361008104]
[]
["83.3.2.","Other indirect costs"]
["83.3.2.1","Bad debts","EUR",null,null,3241916.9741625004,null,null,null,258579.19937500003,3500496.1735375002]
["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,3241916.9741625004,null,null,null,258579.19937500003,3500496.1735375002]
["83.3.2.4","Total all indirect costs","EUR",null,null,5267153.6733020153,null,null,null,351228.03633629566,5618381.7096383106]
["83.3.2.5","Total direct and indirect costs","EUR",null,null,8729547.262182815,null,null,null,460707.00081029569,9190254.2629931103]
[]
[83.4,"Net Income before cap maintenance"]
[]
["83.4.1","Net income"]
["83.4.1.1.","Net income before capital maintenance","EUR",null,null,4081485.9848171845,null,null,null,794596.5701897043,4876082.5550068896]
[]
[83.5,"Capital maintenance"]
[]
["83.5.1","Capital maintenance"]
["83.5.1.1","Infrastructure renewals","EUR",0,2798854.2303529414,2798854.2303529414,726922.55447425786,0,0,726922.55447425786,3525776.7848271993]
["83.5.1.2","Depreciation (service activities)","EUR",178355.2568199152,19956.07038561998,198311.32720553517,5148.0862414814646,0,0,5148.0862414814646,203459.41344701665]
["83.5.1.3","Depreciation (business activities)","EUR",null,null,24969.268020875297,null,null,null,6209.6835846253734,31178.951605500672]
["83.5.1.4","Total capital maintenance","EUR",178355.2568199152,2818810.3007385614,3022134.8255793517,732070.64071573934,0,0,738280.32430036471,3760415.1498797163]
[]
[83.6,"Net Income"]
[]
["83.6.1","Net income"]
["83.6.1.1","Net income before taxes and dividends","EUR",null,null,1059351.1592378328,null,null,null,56316.245889339596,1115667.4051271733]

{"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,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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,14040334.916999999,null,null,null,1353480.4269999999,15393815.343999999]
[]
[84.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["84.2.1.1","Service charges","EUR",84995.223259568971,0,84995.223259568971,0,0,0,0,84995.223259568971]
["84.2.1.2","Energy costs","EUR",1212486.3744723855,244543.21904262327,1457029.5935150087,0,0,0,0,1457029.5935150087]
["84.2.1.3","Fuel costs","EUR",156.02141259000001,85158.608882833229,85314.630295423223,0,0,0,0,85314.630295423223]
["84.2.1.4","Staff costs","EUR",423559.00501157244,740363.20844957407,1163922.2134611465,90630.030188104385,0,0,90630.030188104385,1254552.2436492508]
["84.2.1.5","Materials and consumables","EUR",235519.21097553286,218429.97762600001,453949.18860153283,7801.0706295,0,0,7801.0706295,461750.25923103286]
["84.2.1.6","Contracted services","EUR",84173.739318000109,73772.311812000102,157946.05113000021,57.207851283000004,0,0,57.207851283000004,158003.2589812832]
["84.2.1.7","Maintenance and repair","EUR",31308.296793060003,62408.565036,93716.861829059999,10401.427506,0,0,10401.427506,104118.28933505999]
["84.2.1.8","Other direct costs","EUR",13521.8557578,15602.141259,29123.9970168,2600.3568765,0,0,2600.3568765,31724.353893300002]
["84.2.1.9","Total Direct costs","EUR",2085719.7270005099,1440278.0321080307,3525997.7591085406,111490.09305138739,0,0,111490.09305138739,3637487.8521599281]
[]
[84.3,"Indirect costs"]
[]
["84.3.1.","Business activities"]
["84.3.1.1","Energy costs","EUR",null,null,436859.95525200001,null,null,null,13514.460651869711,450374.41590386973]
["84.3.1.2","Fuel costs","EUR",null,null,11961.6416319,null,null,null,369.62637622704023,12331.268008127041]
["84.3.1.3","Staff costs","EUR",null,null,1117470.6083826078,null,null,null,65122.161679678909,1182592.7700622866]
["84.3.1.4","Materials and consumables","EUR",null,null,156021.41259000002,null,null,null,4824.7896478921921,160846.20223789223]
["84.3.1.5","Contracted services","EUR",null,null,254834.97389700002,null,null,null,7883.7356901493968,262718.70958714944]
["84.3.1.6","Maintenance and repair","EUR",null,null,31724.353893300002,null,null,null,980.53305787535896,32704.886951175362]
["84.3.1.7","Other indirect costs","EUR",null,null,53567.351655900005,null,null,null,1655.4889925820298,55222.840648482037]
["84.3.1.8","Total Busiiness activities costs","EUR",null,null,2062440.297302708,null,null,null,94350.796096274644,2156791.0933989827]
[]
["84.3.2.","Other indirect costs"]
["84.3.2.1","Bad debts","EUR",null,null,3248690.5724900002,null,null,null,299869.71947000001,3548560.2919600001]
["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,3248690.5724900002,null,null,null,299869.71947000001,3548560.2919600001]
["84.3.2.4","Total all indirect costs","EUR",null,null,5311130.8697927082,null,null,null,394220.51556627464,5705351.3853589827]
["84.3.2.5","Total direct and indirect costs","EUR",null,null,8837128.6289012488,null,null,null,505710.60861766204,9342839.2375189103]
[]
[84.4,"Net Income before cap maintenance"]
[]
["84.4.1","Net income"]
["84.4.1.1.","Net income before capital maintenance","EUR",null,null,5203206.2880987506,null,null,null,847769.81838233792,6050976.1064810883]
[]
[84.5,"Capital maintenance"]
[]
["84.5.1","Capital maintenance"]
["84.5.1.1","Infrastructure renewals","EUR",0,3326654.5623393254,3326654.5623393254,369985.30258635001,0,0,369985.30258635001,3696639.8649256756]
["84.5.1.2","Depreciation (service activities)","EUR",214927.44914881996,28434.637431515141,243362.0865803351,5092.8663975735508,0,0,5092.8663975735508,248454.95297790866]
["84.5.1.3","Depreciation (business activities)","EUR",null,null,45133.885837335998,null,null,null,6775.0080428373258,51908.893880173324]
["84.5.1.4","Total capital maintenance","EUR",214927.44914881996,3355089.1997708404,3615150.5347569967,375078.16898392356,0,0,381853.17702676088,3997003.7117837574]
[]
[84.6,"Net Income"]
[]
["84.6.1","Net income"]
["84.6.1.1","Net income before taxes and dividends","EUR",null,null,1588055.753341754,null,null,null,465916.64135557704,2053972.3946973309]

{"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,"Emri i KRU \"Prishtina\"sh.a"]
[]
[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,15067050.213,null,null,null,1619851.0430000001,16686901.255999999]
[]
[85.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["85.2.1.1","Service charges","EUR",86394.24463442147,0,86394.24463442147,0,0,0,0,86394.24463442147]
["85.2.1.2","Energy costs","EUR",1232443.9001962009,248568.40042806487,1481012.3006242658,0,0,0,0,1481012.3006242658]
["85.2.1.3","Fuel costs","EUR",158.58952504123141,86560.31958504465,86718.909110085879,0,0,0,0,86718.909110085879]
["85.2.1.4","Staff costs","EUR",430530.78623406292,752549.58686065406,1183080.373094717,92121.800485000582,0,0,92121.800485000582,1275202.1735797175]
["85.2.1.5","Materials and consumables","EUR",239395.8571881901,222025.33505772398,461421.19224591408,7929.4762520615704,0,0,7929.4762520615704,469350.66849797562]
["85.2.1.6","Contracted services","EUR",85559.239067174378,74986.604064425628,160545.84313160001,58.149492515118183,0,0,58.149492515118183,160603.99262411511]
["85.2.1.7","Maintenance and repair","EUR",31823.631358273768,63435.810016492564,95259.441374766335,10572.635002748761,0,0,10572.635002748761,105832.0763775151]
["85.2.1.8","Other direct costs","EUR",13744.425503573388,15858.952504123141,29603.378007696527,2643.1587506871901,0,0,2643.1587506871901,32246.536758383718]
["85.2.1.9","Total Direct costs","EUR",2120050.673706938,1463985.0085165289,3584035.6822234672,113325.21998301323,0,0,113325.21998301323,3697360.9022064805]
[]
[85.3,"Indirect costs"]
[]
["85.3.1.","Business activities"]
["85.3.1.1","Energy costs","EUR",null,null,444050.67011544795,null,null,null,13270.678291652061,457321.34840710001]
["85.3.1.2","Fuel costs","EUR",null,null,12158.530253161074,null,null,null,362.95882265487023,12521.489075815944]
["85.3.1.3","Staff costs","EUR",null,null,1135864.1745965856,null,null,null,63947.447076876684,1199811.6216734622]
["85.3.1.4","Materials and consumables","EUR",null,null,158589.52504123139,null,null,null,4737.7570508677509,163327.28209209914]
["85.3.1.5","Contracted services","EUR",null,null,259029.55756734463,null,null,null,7741.5238961766318,266771.08146352129]
["85.3.1.6","Maintenance and repair","EUR",null,null,32246.536758383718,null,null,null,962.84558448830865,33209.382342872028]
["85.3.1.7","Other indirect costs","EUR",null,null,54449.070264156115,null,null,null,1625.6262385793275,56074.696502735445]
["85.3.1.8","Total Busiiness activities costs","EUR",null,null,2096388.0645963105,null,null,null,92648.83696129563,2189036.9015576062]
[]
["85.3.2.","Other indirect costs"]
["85.3.2.1","Bad debts","EUR",null,null,3381407.7996200002,null,null,null,296435.66537,3677843.4649900002]
["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,3381407.7996200002,null,null,null,296435.66537,3677843.4649900002]
["85.3.2.4","Total all indirect costs","EUR",null,null,5477795.8642163109,null,null,null,389084.50233129563,5866880.3665476069]
["85.3.2.5","Total direct and indirect costs","EUR",null,null,9061831.5464397781,null,null,null,502409.72231430886,9564241.2687540874]
[]
[85.4,"Net Income before cap maintenance"]
[]
["85.4.1","Net income"]
["85.4.1.1.","Net income before capital maintenance","EUR",null,null,6005218.6665602215,null,null,null,1117441.3206856912,7122659.9872459117]
[]
[85.5,"Capital maintenance"]
[]
["85.5.1","Capital maintenance"]
["85.5.1.1","Infrastructure renewals","EUR",0,3697533.0830176184,3697533.0830176184,352815.46366087405,0,0,352815.46366087405,4050348.5466784923]
["85.5.1.2","Depreciation (service activities)","EUR",241403.7659990587,37743.290092904237,279147.05609196296,5028.789407663965,0,0,5028.789407663965,284175.84549962694]
["85.5.1.3","Depreciation (business activities)","EUR",null,null,59105.330591735212,null,null,null,7139.4360977901242,66244.766689525335]
["85.5.1.4","Total capital maintenance","EUR",241403.7659990587,3735276.3731105225,4035785.4697013167,357844.25306853803,0,0,364983.68916632817,4400769.1588676451]
[]
[85.6,"Net Income"]
[]
["85.6.1","Net income"]
["85.6.1.1","Net income before taxes and dividends","EUR",null,null,1969433.1968589048,null,null,null,752457.63151936303,2721890.8283782667]