{"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,"K.U.R Hidrodrini 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,2,1.8]
[]
["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",50,50,30,30,30]
["1.2.3.2","Household (base year price levels)","EUR/con","N/A","N/A",29.372026082359163,28.842194960926932,28.37514015399222]
["1.2.3.3","Non-household (nominal prices)","EUR/con",50,50,42,42,42]
["1.2.3.4","Non-household (base year price levels)","EUR/con","N/A","N/A",41.120836515302827,40.379072945297708,39.725196215589108]
[]
["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.19,"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.20719883927903907,"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,2,2]
[]
["1.3.2","Connection fees (average)"]
["1.3.2.1","Household (nominal prices)","EUR/con",50,50,20,20,20]
["1.3.2.2","Household (base year price levels)","EUR/con","N/A","N/A",19.581350721572775,19.228129973951287,18.916760102661481]
["1.3.2.3","Non-household (nominal prices)","EUR/con",50,50,28,28,28]
["1.3.2.4","Non-household (base year price levels)","EUR/con","N/A","N/A",27.413891010201883,26.919381963531801,26.483464143726071]
[]
["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",0.05,"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",5.6444790937785407E-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.5,0.57999999999999996,0.63,0.65,0.67]
["1.4.1.2","Commercial","% of billing",0.72,0.75,0.82,0.85,0.89]
["1.4.1.3","Institutions","% of billing",0.78,0.82,0.98,0.92,0.95]
[]
["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,"K.U.R Hidrodrini 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.18,0.19,"N/A","N/A","N/A"]
["2.2.1.2","Non-household","EUR/m3",0.42,0.43,"N/A","N/A","N/A"]
[]
["2.2.2","Wastewater"]
["2.2.2.1","Household","EUR/m3",0.05,0.05,"N/A","N/A","N/A"]
["2.2.2.2","Non-household","EUR/m3",0.05,0.08,"N/A","N/A","N/A"]
[]
[2.2999999999999998,"Tariff schedule (base year price levels)"]
[]
["2.3.1","Water "]
["2.3.1.1","Household","EUR/m3","N/A","N/A",0.20719883927903907,0.22717569027165491,0.24907858765029192]
["2.3.1.2","Non-household","EUR/m3","N/A","N/A",0.41439767855807813,0.45435138054330981,0.44834145777052548]
[]
["2.3.2","Wastewater (volume of water consumed)"]
["2.3.2.1","Household","EUR/m3","N/A","N/A",5.6444790937785407E-2,6.3718068829901831E-2,7.1928555814603209E-2]
["2.3.2.2","Non-household","EUR/m3","N/A","N/A",0.11288958187557081,0.12743613765980366,0.14385711162920642]
[]
[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.18,0.19,0.22,0.24,0.27]
["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.42,0.43,0.43,0.49,0.49]
["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.42,0.43,0.43,0.49,0.49]
[]
["2.4.2","Wastewater (volume of water consumed)"]
["2.4.2.1","Household","EUR/m3",0.05,0.05,0.06,7.0000000000000007E-2,0.08]
["2.4.2.2","Commercial","EUR/m3",0.05,0.08,0.12,0.13,0.15]
["2.4.2.3","Institutional","EUR/m3",0.05,0.08,0.12,0.13,0.15]
[]
[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,"K.U.R Hidrodrini 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","Households in service area"]
["11.1.1.1","Households in service area at start of year","No",29875,29875,29975,30075,30175]
["11.1.1.2","Households in service area at end of year","No",29875,29975,30075,30175,30275]
["11.1.1.3","Average number of households in service area over the year","No",29875,29925,30025,30125,30225]
[]
["11.1.2","Households served with water supply"]
["11.1.2.1","Metered households with water supply service at start of year","No",22433,25233,26448,27648,29048]
["11.1.2.2","Metered households with water supply service at end of year","No",25233,26448,27648,29048,30448]
["11.1.2.3","Un-metered households with water supply service at start of year","No",1505,1615,1300,1000,500]
["11.1.2.4","Un-metered households with water supply service at end of year","No",1615,1300,1000,500,0]
["11.1.2.5","Total households with water supply at start of year","No",23938,26848,27748,28648,29548]
["11.1.2.6","Total households with water supply at end of year","No",26848,27748,28648,29548,30448]
["11.1.2.7","Average metered households served in year","No",23833,25840.5,27048,28348,29748]
["11.1.2.8","Average un-metered households served in year","No",1560,1457.5,1150,750,250]
["11.1.2.9","Average total households served in year","No",25393,27298,28198,29098,29998]
["11.1.2.10","New household connections in year","No",2910,900,900,900,900]
["11.1.2.11","Service coverage","%",0.84997489539748949,0.9122138680033417,0.93915070774354703,0.96590871369294606,0.99248966087675761]
[]
["11.1.3","Household water consumption"]
["11.1.3.1","Average annual metered water billed per metered household","m3/household/year",246,246,246,246,246]
["11.1.3.2","Average annual un-metered water billed per un-metered household","m3/household/year",325,189,378,378,378]
["11.1.3.3","Total household metered water billed","m3/year",5862918,6356763,6653808,6973608,7318008]
["11.1.3.4","Total household un-metered water billed","m3/year",507000,275467.5,434700,283500,94500]
["11.1.3.5","Total household water billed","m3/year",6369918,6632230.5,7088508,7257108,7412508]
[]
[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",3230,3405,3457,3552,3682]
["11.2.1.2","Metered commercial with water supply service at end of year","No",3405,3457,3552,3682,3712]
["11.2.1.3","Un-metered commercial with water supply service at start of year","No",195,177,160,100,0]
["11.2.1.4","Un-metered commercial with water supply service at end of year","No",177,160,100,0,0]
["11.2.1.5","Total commercial with water supply at start of year","No",3425,3582,3617,3652,3682]
["11.2.1.6","Total commercial with water supply at end of year","No",3582,3617,3652,3682,3712]
["11.2.1.7","Average metered commercial served in year","No",3317.5,3431,3504.5,3617,3697]
["11.2.1.8","Average un-metered commercial served in year","No",186,168.5,130,50,0]
["11.2.1.9","Average total commercial served in year","No",3503.5,3599.5,3634.5,3667,3697]
["11.2.1.10","New commercial connections in year","No",157,35,35,30,30]
[]
["11.2.2","Non-household (commercial) water consumption"]
["11.2.2.1","Total commercial metered water billed","m3/year",769736,795992,813044,839144,857704]
["11.2.2.2","Total commercial un-metered water billed","m3/year",27826,37912.5,58500,22500,0]
["11.2.2.3","Total commercial water billed","m3/year",797562,833904.5,871544,861644,857704]
[]
[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",240,259,289,292,295]
["11.3.1.2","Metered institutional with water supply service at end of year","No",259,289,292,295,298]
["11.3.1.3","Un-metered institutional with water supply service at start of year","No",28,27,0,0,0]
["11.3.1.4","Un-metered institutional with water supply service at end of year","No",27,0,0,0,0]
["11.3.1.5","Total institutional with water supply at start of year","No",268,286,289,292,295]
["11.3.1.6","Total institutional with water supply at end of year","No",286,289,292,295,298]
["11.3.1.7","Average metered institutional served in year","No",249.5,274,290.5,293.5,296.5]
["11.3.1.8","Average un-metered institutional served in year","No",27.5,13.5,0,0,0]
["11.3.1.9","Average total institutional served in year","No",277,287.5,290.5,293.5,296.5]
["11.3.1.10","New institutional connections in year","No",18,3,3,3,3]
[]
["11.3.2","Non-household (institutional) water consumption"]
["11.3.2.1","Total institutional metered water billed","m3/year",885240,972152,1030694,1041338,1051982]
["11.3.2.2","Total institutional un-metered water billed","m3/year",25141,71847,0,0,0]
["11.3.2.3","Total institutional water billed","m3/year",910381,1043999,1030694,1041338,1051982]
[]
[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",3567,3705,3795,3910.5,3993.5]
["11.4.1.2","Average un-metered non-household served in year","No",213.5,182,130,50,0]
["11.4.1.3","Average total non-household served in year","No",3780.5,3887,3925,3960.5,3993.5]
[]
["11.4.2","Non-household water consumption"]
["11.4.2.3","Total non-household metered water billed","m3/year",1654976,1768144,1843738,1880482,1909686]
["11.4.2.4","Total non-household un-metered water billed","m3/year",52967,109759.5,58500,22500,0]
["11.4.2.5","Total non-household water billed","m3/year",1707943,1877903.5,1902238,1902982,1909686]
[]
[11.5,"Household and non-household"]
[]
["11.5.1","Total served"]
["11.5.1.1","Total metered connections","No",27400,29545.5,30843,32258.5,33741.5]
["11.5.1.2","Total un-metered connections","No",1773.5,1639.5,1280,800,250]
["11.5.1.3","Total connections","no",29173.5,31185,32123,33058.5,33991.5]
[]
["11.5.2","Total sales"]
["11.5.2.1","Total metered water billed","m3/year",7517894,8124907,8497546,8854090,9227694]
["11.5.2.2","Total un-metered water billed","m3/year",559967,385227,493200,306000,94500]
["11.5.2.3","Total water billed","m3/year",8077861,8510134,8990746,9160090,9322194]
[]
["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",22131.126027397262,23315.435616438357,24632.180821917809,25096.136986301372,25540.257534246575]

{"sheet":"12 - W production & NRW","index":3,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,"K.U.R Hidrodrini 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",10382569,9786802,9761602,9736402,9711202]
["12.1.1.2","Estimated volume of leakages","m3/year",10382569,9786802,9786802,9786802,9424802]
["12.1.1.3","Total NRW in year","m3/year",20765138,19573604,19548404,19523204,19136004]
["12.1.1.4","NRW per connection per day","l/con/day)",1950.084461620851,1719.6188016279339,1667.2562099703237,1617.9872086448659,1542.3681867283904]
["12.1.1.5","NRW as percentage of production","%",0.71993685538733332,0.696972888723004,0.68496798257831781,0.68064720878989704,0.67242500737397359]
[]
[12.2,"Production requirement"]
[]
["12.2.1","Production requirement"]
["12.2.1.1","Water sales","m3/year",8077861,8510134,8990746,9160090,9322194]
["12.2.1.2","Total NRW","m3/year",20765138,19573604,19548404,19523204,19136004]
["12.2.1.3","Total average production requirement","m3/year",28842999,28083738,28539150,28683294,28458198]
["12.2.1.4","Peak production requirement","m3/day",79021.915068493152,76941.747945205483,78189.452054794529,78584.367123287666,77967.665753424662]
[]
[12.3,"Production capacity"]
[]
["12.3.1","Production capacity"]
["12.3.1.1","Average annual production capacity","m3/year",28854937,29300000,29000200,29000150,29000100]
["12.3.1.2","Maximum production capacity","m3/day",80000,80000,80000,80000,80000]
["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",80000,80000,80000,80000,80000]
["12.3.1.5","Is production capacity sufficient for average conditions","yes/no (P=Yes, J=No)","P","P","P","P","P"]
["12.3.1.6","Is production capacity sufficient for peak conditions","yes/no (P=Yes, J=No)","P","P","P","P","P"]
["12.3.1.7","Is production capacity sufficient (adjust production requirement to suit)","yes/no (P=Yes, J=No)","P","P","P","P","P"]
[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,"K.U.R Hidrodrini 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",10845,11335,11415,12345,12815]
["13.1.1.2","Metered households with wastewater service at end of year","No",11335,11415,12345,12815,13265]
["13.1.1.3","Un-metered households with wastewater service at start of year","No",250,100,50,20,0]
["13.1.1.4","Un-metered households with wastewater service at end of year","No",100,50,20,0,0]
["13.1.1.5","Total households with wastewater service at start of year","No",11095,11435,11465,12365,12815]
["13.1.1.6","Total households with wastewater service at end of year","No",11435,11465,12365,12815,13265]
["13.1.1.7","Average metered households served with wastewater service in year","No",11090,11375,11880,12580,13040]
["13.1.1.8","Average un-metered households served with wastewater service in year","No",175,75,35,10,0]
["13.1.1.9","Average total households served in year","No",11265,11450,11915,12590,13040]
["13.1.1.10","New household connections in year","No",340,30,900,450,450]
["13.1.1.11","Service coverage with wastewater connections","%",0.37707112970711298,0.38262322472848787,0.39683597002497917,0.41792531120331949,0.43143093465674109]
[]
["13.1.2","Household sales from those with wastewater service"]
["13.1.2.1","Metered water billed with wastewater connections","m3/year",2728140,2798250,2922480,3094680,3207840]
["13.1.2.2","Un-metered water billed with wastewater connections","m3/year",56875,14175,13230,3780.0000000000005,0]
["13.1.2.3","Total household water billed with wastewater connections","m3/year",2785015,2812425,2935710,3098460,3207840]
[]
["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,900,900]
["13.1.3.2","Total households with wastewater collection and treatment service at end of year","No",0,0,900,900,900]
["13.1.3.3","Average households served with wastewater collection and treatment service in year","No",0,0,450,900,900]
["13.1.3.4","Service coverage with wastewater collection and treatment","%",0,0,1.498751040799334E-2,2.9875518672199172E-2,2.9776674937965261E-2]
[]
[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",3157,3333,3368,3403,3433]
["13.2.1.2","Metered commercial with wastewater service at end of year","No",3333,3368,3403,3433,3463]
["13.2.1.3","Un-metered commercial with wastewater service at start of year","No",0,0,0,0,0]
["13.2.1.4","un-metered commercial with wastewater service at end of year","No",0,0,0,0,0]
["13.2.1.5","Total commercial with wastewater service at start of year","No",3157,3333,3368,3403,3433]
["13.2.1.6","Total commercial with wastewater service at end of year","No",3333,3368,3403,3433,3463]
["13.2.1.7","Average metered commercial served with wastewater service in year","No",3245,3350.5,3385.5,3418,3448]
["13.2.1.8","Average un-metered commercial served with wastewater service in year","No",0,0,0,0,0]
["13.2.1.9","Average total commercial served in year","No",3245,3350.5,3385.5,3418,3448]
["13.2.1.10","New commercial connections in year","No",176,35,35,30,30]
[]
["13.2.2","Commercial water sales from those with wastewater services"]
["13.2.2.1","Metered water billed with wastewater connections","m3/year",752914.3391107762,777316,785436,792976,799936]
["13.2.2.2","Un-metered water billed with wastewater connections","m3/year",0,0,0,0,0]
["13.2.2.3","Total commercial water billed with wastewater connections","m3/year",752914.3391107762,777316,785436,792976,799936]
[]
["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,20,20]
["13.2.3.2","Total commercial with wastewater treatment service at end of year","No",0,0,20,20,20]
["13.2.3.3","Average commercial served with wastewater treatment service in year","No",0,0,10,20,20]
[]
[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",163,163,166,169,172]
["13.3.1.2","Metered institutional with wastewater service at end of year","No",163,166,169,172,175]
["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",163,163,166,169,172]
["13.3.1.6","Total institutional with wastewater service at end of year","No",163,166,169,172,175]
["13.3.1.7","Average metered institutional served with wastewater service in year","No",163,164.5,167.5,170.5,173.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",163,164.5,167.5,170.5,173.5]
["13.3.1.10","New institutional connections in year","No",0,3,3,3,3]
[]
["13.3.2","Institutional water sales from those with wastewater service"]
["13.3.2.1","Metered water billed with wastewater connections","m3/year",578333.14629258518,583646,594290,604934,615578]
["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",578333.14629258518,583646,594290,604934,615578]
[]
["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,5,5]
["13.3.3.2","Total institutional with wastewater treatment service at end of year","No",0,0,5,5,5]
["13.3.3.3","Average institutional served with wastewater treatment service in year","No",0,0,2.5,5,5]
[]
[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",3408,3515,3553,3588.5,3621.5]
["13.4.1.2","Average un-metered non-household with wastewater connections","No",0,0,0,0,0]
["13.4.1.3","Average total non-household with wastewater connections","No",3408,3515,3553,3588.5,3621.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",1331247.4854033613,1360962,1379726,1397910,1415514]
["13.4.2.2","Total non-household un-metered water billed from those with wastewater service","m3/year",0,0,0,0,0]
["13.4.2.3","Total non-household water billed from those with wastewater service","m3/year",163,163,168.5,174,177]
[]
["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,12.5,25,25]
[]
[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",14498,14890,15433,16168.5,16661.5]
["13.5.1.2","Total un-metered connections with wastewater collection services","No",175,75,35,10,0]
["13.5.1.3","Total connections","no",14673,14965,15468,16178.5,16661.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",4059387.4854033613,4159212,4302206,4492590,4623354]
["13.5.2.2","Total un-metered water billed from those with wastewater service","m3/year",56875,14175,13230,3780.0000000000005,0]
["13.5.2.3","Total water billed from those with wastewater service","m3/year",4116262.4854033613,4173387,4315436,4496370,4623354]
[]
["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,462.5,925,925]

{"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,"K.U.R Hidrodrini 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",0,30000,30000,30000,30000]
["21.1.1.2","Energy costs","EUR/year",6789,7332,9800,9800,9800]
["21.1.1.3","Fuel costs","EUR/year",2354,4320,4800,4800,4800]
["21.1.1.4","Staff costs","EUR/year",86315,85868,95000,95000,95000]
["21.1.1.5","Materials and consumables","EUR/year",8658,14400,15000,15000,15000]
["21.1.1.6","Contracted services","EUR/year",9000,9000,9000,9000,9000]
["21.1.1.7","Maintenance and repair","EUR/year",11532,2088,2250,2250,2250]
["21.1.1.8","Other direct costs","EUR/year",2665,2352,2520,2520,2520]
["21.1.1.9","Total water resources and treatment costs","EUR/year",127313,155360,168370,168370,168370]
[]
["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",315682,340938,340938,340938,340938]
["21.1.2.3","Fuel costs","EUR/year",35306,32400,36000,36000,36000]
["21.1.2.4","Staff costs","EUR/year",604202,601078,519407,519407,519407]
["21.1.2.5","Materials and consumables","EUR/year",0,0,40500,40500,40500]
["21.1.2.6","Contracted services","EUR/year",0,0,0,0,0]
["21.1.2.7","Maintenance and repair","EUR/year",103488,76500,76500,76500,76500]
["21.1.2.8","Other direct costs","EUR/year",41754,91737,91737,91737,91737]
["21.1.2.9","Total water distribution costs","EUR/year",1100432,1142653,1105082,1105082,1105082]
[]
[21.2,"Indirect costs"]
[]
["21.2.1","Business activities"]
["21.2.1.1","Energy costs","EUR/year",16123.4,17413.272000000001,17413.272000000001,17413.272000000001,17413.272000000001]
["21.2.1.2","Fuel costs","EUR/year",11528.25,12450.51,12450.51,12450.51,12450.51]
["21.2.1.3","Staff costs","EUR/year",163997.54999999999,177117.35399999999,184202.04816000001,184202.04816000001,184202.04816000001]
["21.2.1.4","Materials and consumables","EUR/year",9500,10260,10260,10260,10260]
["21.2.1.5","Contracted services","EUR/year",0,0,0,0,0]
["21.2.1.6","Maintenance and repair","EUR/year",190,205.20000000000002,205.20000000000002,205.20000000000002,205.20000000000002]
["21.2.1.7","Other indirect costs","EUR/year",39105.799999999996,42234.263999999996,42234.263999999996,42234.263999999996,42234.263999999996]
["21.2.1.8","Total business activities costs","EUR/year",240444.99999999997,259680.6,266765.29416000005,266765.29416000005,266765.29416000005]
[]
["21.2.2","Total operating costs excl bad debts"]
["21.2.2.1","Total","EUR/year",1468190,1557693.6,1540217.29416,1540217.29416,1540217.29416]

{"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,"K.U.R Hidrodrini 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",2028,10260,10260,10260,10260]
["22.1.1.4","Staff costs","EUR/year",45429,42934,29344,29344,29344]
["22.1.1.5","Materials and consumables","EUR/year",0,4560,4742.4000000000005,4742.4000000000005,4742.4000000000005]
["22.1.1.6","Contracted services","EUR/year",0,950,950,950,950]
["22.1.1.7","Maintenance and repair","EUR/year",6069,4180,4180,4180,4180]
["22.1.1.8","Other direct costs","EUR/year",856,12415,12415,12415,12415]
["22.1.1.9","Total wastewater collection costs ","EUR/year",54382,75299,61891.4,61891.4,61891.4]
[]
["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,3000,3000,3000]
["22.1.2.3","Fuel costs","EUR/year",0,0,500,500,500]
["22.1.2.4","Staff costs","EUR/year",0,0,0,0,0]
["22.1.2.5","Materials and consumables","EUR/year",0,0,500,500,500]
["22.1.2.6","Contracted services","EUR/year",0,0,0,0,0]
["22.1.2.7","Maintenance and repair","EUR/year",0,0,200,200,200]
["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,4200,4200,4200]
[]
["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",848.60000000000036,916.4880000000004,916.4880000000004,916.4880000000004,916.4880000000004]
["22.2.1.2","Fuel costs","EUR/year",606.75,655.29000000000008,655.29000000000008,655.29000000000008,655.29000000000008]
["22.2.1.3","Staff costs","EUR/year",8631.4500000000116,9321.9660000000131,13367.84464000001,13367.84464000001,13367.84464000001]
["22.2.1.4","Materials and consumables","EUR/year",500,540,540,540,540]
["22.2.1.5","Contracted services","EUR/year",0,0,0,0,0]
["22.2.1.6","Maintenance and repair","EUR/year",10,10.8,10.8,10.8,10.8]
["22.2.1.7","Other indirect costs","EUR/year",2058.2000000000044,2222.8560000000048,2222.8560000000048,2222.8560000000048,2222.8560000000048]
["22.2.1.8","Total business activities costs","EUR/year",12655.000000000016,13667.400000000018,17713.278640000015,17713.278640000015,17713.278640000015]
[]
["22.2.2","Total operating costs excl bad debts"]
["22.2.2.1","Total","EUR/year",67037.000000000015,88966.400000000023,83804.678640000013,83804.678640000013,83804.678640000013]

{"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,"K.U.R Hidrodrini 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,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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","Projekti nga B.Gjermane KS 02-02-K6-02-01-SW-INT-STP LOT 2 ( Rehabilitimi i tubacioneve te ujit ne qender)","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,321983,null,321983,321983,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.2","Rehabilitimi i rrjetit Gjemajl Kada - Peje","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,150000,null,150000,200000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.3","Rehabilitim i gypave te ujit per fshatin Krusheve","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,85000,null,null,null,85000,85000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.4","Rehabilitimi i gypave te ujit ne lagjen Agim Ramadani - Junik","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,45000,115000,null,160000,160000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.5","Rehabilitimi I gypave te ujit ne Kapeshnice - Peje","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,40000,null,40000,40000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.6","Furnizimi me uji 16 fshatra - Peje","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,150000,null,null,150000,150000,null,null,0,null,null,300000,null,300000,300000,null,null,0,null,null,null,null,0,0]
["31.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]
["31.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]
["31.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]
["31.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]
["31.2.1.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]
["31.2.1.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]
["31.2.1.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]
["31.2.1.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]
["31.2.1.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]
["31.2.1.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]
["31.2.1.17",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.18",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.19",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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.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,212762.35536439036,null,212762.35536439036,null,null,null,null,0,212762.35536439036,212762.35536439036,null,212762.35536439036,null,null,null,null,0,212762.35536439036,212762.35536439036,null,212762.35536439036,null,null,null,null,0,212762.35536439036]
["31.2.1.21","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,321983,0,321983,321983,262762.35536439036,0,262762.35536439036,85000,195000,305000,0,585000,847762.35536439042,212762.35536439036,0,212762.35536439036,0,0,300000,0,300000,512762.35536439036,212762.35536439036,0,212762.35536439036,0,0,0,0,0,212762.35536439036]
[]
[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,0,0,0,0,0,321983,0,321983,321983,262762.35536439036,0,262762.35536439036,85000,195000,305000,0,585000,847762.35536439042,212762.35536439036,0,212762.35536439036,0,0,300000,0,300000,512762.35536439036,212762.35536439036,0,212762.35536439036,0,0,0,0,0,212762.35536439036]
["31.3.1.3","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,321983,0,321983,321983,262762.35536439036,0,262762.35536439036,85000,195000,305000,0,585000,847762.35536439042,212762.35536439036,0,212762.35536439036,0,0,300000,0,300000,512762.35536439036,212762.35536439036,0,212762.35536439036,0,0,0,0,0,212762.35536439036]

{"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,"K.U.R Hidrodrini 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",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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.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,0,0,0,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.1.2","Supply demand balance, expenditure and sources of finance"]
["32.1.2.1","Sic eshte siguruar nga ZRRUM","EUR/year",3095,null,3095,null,null,62709,null,62709,65804,null,null,0,null,null,null,null,0,0,null,null,0,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",3095,0,3095,0,0,62709,0,62709,65804,0,0,0,0,0,0,0,0,0,0,0,0,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","Furnizimi me uje Projekti Lubozhd dhe Prigod","EUR/year",null,null,0,null,null,null,null,0,0,1168.45,null,1168.45,null,null,104,null,104,1272.45,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.1.2","Instalimi i fitingjeve me ujmatesin zonal afer stacionit te pompave ne Peje, DN 700","EUR/year",null,null,0,null,null,null,null,0,0,5710,null,5710,null,null,28214,null,28214,33924,null,null,0,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","Vendosja e gypit , furnizimi i tre lagjeve","EUR/year",null,null,0,null,null,null,null,0,0,1833,null,1833,null,null,42,null,42,1875,null,null,0,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","Gypi Furnizues per Vitomeric","EUR/year",null,null,0,null,null,null,null,0,0,65,null,65,104000,null,null,null,104000,104065,null,null,0,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","Projekti nga B.Gjermane KS 02-02-K6-02-01-SW-INT-STP LOT 2 (Ndertimi I rezervuarve te rinje V=3000m3)","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,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","Projekti i ri I SWIS 11/WS-PE/06.0 (Zgjerimi i rrjetit te ujesjellsit per fshatrat : Llabjan , Ramun , Lutoglav)","EUR/year",null,null,0,null,null,null,null,0,0,409,null,409,null,220000,30000,null,250000,250409,null,null,0,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,9185.4500000000007,0,9185.4500000000007,104000,220000,158360,0,482360,491545.45,0,0,0,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.2.2","Supply demand balance, expenditure and sources of finance"]
["32.2.2.1","Sic eshte siguruar nga ZRRUM","EUR/year",58809,null,58809,null,null,1191469,null,1191469,1250278,null,null,0,null,null,null,null,0,0,null,null,0,null,null,200000,null,200000,200000,300000,null,300000,null,null,200000,null,200000,500000,300000,null,300000,null,null,200000,null,200000,500000]
["32.2.2.2","Rrjeti i ri per lagjen Zatra (Vetanake dhe USAID)","EUR/year",null,null,0,null,null,null,null,0,0,10000,null,10000,null,null,230000,null,230000,240000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.3","Rrjeti i ri per lagjen Sahat-kulla (USAID)","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,320000,null,320000,320000,null,null,0,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","Furnizimi me uje te 16 fshatrave - Peje","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,150000,null,null,150000,150000,null,null,0,null,null,300000,null,300000,300000,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",58809,0,58809,0,0,1191469,0,1191469,1250278,10000,0,10000,0,0,550000,0,550000,560000,0,0,0,0,150000,200000,0,350000,350000,300000,0,300000,0,0,500000,0,500000,800000,300000,0,300000,0,0,200000,0,200000,500000]
[]
[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,0,0,0,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.2","Water resources and treatment  - supply demand balance","EUR/year",3095,0,3095,0,0,62709,0,62709,65804,0,0,0,0,0,0,0,0,0,0,0,0,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",3095,0,3095,0,0,62709,0,62709,65804,0,0,0,0,0,0,0,0,0,0,0,0,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.4","Water distribution - level of service","EUR/year",0,0,0,0,0,0,0,0,0,9185.4500000000007,0,9185.4500000000007,104000,220000,158360,0,482360,491545.45,0,0,0,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.5","Water Distribution  - supply demand balance","EUR/year",58809,0,58809,0,0,1191469,0,1191469,1250278,10000,0,10000,0,0,550000,0,550000,560000,0,0,0,0,150000,200000,0,350000,350000,300000,0,300000,0,0,500000,0,500000,800000,300000,0,300000,0,0,200000,0,200000,500000]
["32.3.1.6","Total water distribution","EUR/year",58809,0,58809,0,0,1191469,0,1191469,1250278,19185.45,0,19185.45,104000,220000,708360,0,1032360,1051545.45,0,0,0,0,150000,200000,0,350000,350000,300000,0,300000,0,0,500000,0,500000,800000,300000,0,300000,0,0,200000,0,200000,500000]
["32.3.1.7","Totals","EUR/year",61904,0,61904,0,0,1254178,0,1254178,1316082,19185.45,0,19185.45,104000,220000,708360,0,1032360,1051545.45,0,0,0,0,150000,200000,0,350000,350000,300000,0,300000,0,0,500000,0,500000,800000,300000,0,300000,0,0,200000,0,200000,500000]

{"sheet":"33 - W non-inf cap maint","index":9,"n_rows":43,"n_cols":48,"rows_kept":43,"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,"K.U.R Hidrodrini 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",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0]
["33.1.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.1.1.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]
["33.1.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.1.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.1.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.1.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.1.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.1.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.1.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.1.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[33.200000000000003,"Water Distribution"]
["33.2.1","Non-infrastructure capital maintenance expenditure and sources of finance"]
["33.2.1.1","Rehabilitimi dhe montimi i kapakeve te pusetave","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,5000,null,5000,null,null,null,null,0,5000,5000,null,5000,null,null,null,null,0,5000,5000,null,5000,null,null,null,null,0,5000]
["33.2.1.2","Riparimi i rrethojave te burimet-caktimi i zonave te mbrojtura","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,5000,null,5000,null,null,null,null,0,5000,5000,null,5000,null,null,null,null,0,5000,5000,null,5000,null,null,null,null,0,5000]
["33.2.1.3","Rehabilitimi dhe optimalizimi i sistemit te pompave ","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,7000,null,7000,null,null,null,null,0,7000,5000,null,5000,null,null,null,null,0,5000,5000,null,5000,null,null,null,null,0,5000]
["33.2.1.4","Ndrrimi i pompave kryesore ne rrjet - Peje","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,90000,null,90000,90000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.2.1.5","Rehabilitimi i lidhjeve shtepiake ne pilot zona","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,45000,null,45000,null,null,null,null,0,45000,45000,null,45000,null,null,null,null,0,45000,45000,null,45000,null,null,null,null,0,45000]
["33.2.1.6","Organizimi dhe aktivizimi i laboratorit","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,5000,null,5000,null,null,null,null,0,5000,5000,null,5000,null,null,null,null,0,5000,5000,null,5000,null,null,null,null,0,5000]
["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.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,67000,0,67000,0,0,90000,0,90000,157000,65000,0,65000,0,0,0,0,0,65000,65000,0,65000,0,0,0,0,0,65000]
[]
[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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["33.3.1.2","Water Distribution","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,67000,0,67000,0,0,90000,0,90000,157000,65000,0,65000,0,0,0,0,0,65000,65000,0,65000,0,0,0,0,0,65000]
["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,67000,0,67000,0,0,90000,0,90000,157000,65000,0,65000,0,0,0,0,0,65000,65000,0,65000,0,0,0,0,0,65000]

{"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,"K.U.R Hidrodrini 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","Ndertimi i impijantit per trajtimin e ujit -Kline","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,200000,200000,600000,null,1000000,1000000,null,null,0,500000,100000,100000,null,700000,700000,null,null,0,null,null,null,null,0,0]
["34.1.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,200000,200000,600000,0,1000000,1000000,0,0,0,500000,100000,100000,0,700000,700000,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","Permiresimi me uje ne Zatra (01)","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.2","Paisjet per analiza te ujit (stacioni I klorinimit)","EUR/year",null,null,0,null,null,null,null,0,0,4238.1499999999996,null,4238.1499999999996,null,null,null,null,0,4238.1499999999996,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.3","Pompat shtytse","EUR/year",null,null,0,null,null,null,null,0,0,6033,null,6033,null,null,null,null,0,6033,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,10271.15,0,10271.15,0,0,0,0,0,10271.15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["34.1.3","Supply demand balance, expenditure and sources of finance"]
["34.1.3.1","Sic eshte siguruar nga ZRRUM","EUR/year",15401,null,15401,null,null,44335,null,44335,59736,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.3.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.3.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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",15401,0,15401,0,0,44335,0,44335,59736,0,0,0,0,0,0,0,0,0,0,0,0,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","Instalimi I ujmatsave shtepiak","EUR/year",null,null,0,null,null,null,null,0,0,28200,null,28200,null,null,10800,null,10800,39000,30000,null,30000,null,null,15000,null,15000,45000,30000,null,30000,null,null,10000,null,10000,40000,30000,null,30000,null,null,10000,null,10000,40000]
["34.2.1.2","Projekti nga B.Gjermane KS 02-02-K6-02-01-SW-INT-STP LOT 2( Ndertimi I rezervuarve te rinje V=3000m3)","EUR/year",null,null,0,null,null,null,null,0,0,0,null,0,null,null,1000000,null,1000000,1000000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.3","Stacioni I ri I pompimit nga Banka Gjermane","EUR/year",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,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.4","Blerje kompjuterash -IT","EUR/year",null,null,0,null,null,null,null,0,0,2000,null,2000,null,null,null,null,0,2000,5000,null,5000,null,null,null,null,0,5000,5000,null,5000,null,null,null,null,0,5000,5000,null,5000,null,null,null,null,0,5000]
["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,30200,0,30200,0,0,1510800,0,1510800,1541000,35000,0,35000,0,0,15000,0,15000,50000,35000,0,35000,0,0,10000,0,10000,45000,35000,0,35000,0,0,10000,0,10000,45000]
[]
["34.2.2","Supply demand balance, expenditure and sources of finance"]
["34.2.2.1","Sic eshte siguruar nga ZRRUM","EUR/year",1812,null,1812,null,null,5216,null,5216,7028,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.2.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.2.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.2.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.2.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.2.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.2.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.2.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.2.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.2.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.2.11","Totals","EUR/year",1812,0,1812,0,0,5216,0,5216,7028,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[34.299999999999997,"Total water supply non-infrastructure enhancement"]
["34.3.1","Infrastructure enhancement expenditure and sources of finance"]
["34.3.1.1","Water resources and treatment - quality improvments","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,200000,200000,600000,0,1000000,1000000,0,0,0,500000,100000,100000,0,700000,700000,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,10271.15,0,10271.15,0,0,0,0,0,10271.15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["34.3.1.3","Water resources and treatment  - supply demand balance","EUR/year",15401,0,15401,0,0,44335,0,44335,59736,0,0,0,0,0,0,0,0,0,0,0,0,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",15401,0,15401,0,0,44335,0,44335,59736,10271.15,0,10271.15,0,0,0,0,0,10271.15,0,0,0,200000,200000,600000,0,1000000,1000000,0,0,0,500000,100000,100000,0,700000,700000,0,0,0,0,0,0,0,0,0]
["34.3.1.5","Water distribution - level of service","EUR/year",0,0,0,0,0,0,0,0,0,30200,0,30200,0,0,1510800,0,1510800,1541000,35000,0,35000,0,0,15000,0,15000,50000,35000,0,35000,0,0,10000,0,10000,45000,35000,0,35000,0,0,10000,0,10000,45000]
["34.3.1.6","Water distribution  - supply demand balance","EUR/year",1812,0,1812,0,0,5216,0,5216,7028,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["34.3.1.7","Total Water distribution ","EUR/year",1812,0,1812,0,0,5216,0,5216,7028,30200,0,30200,0,0,1510800,0,1510800,1541000,35000,0,35000,0,0,15000,0,15000,50000,35000,0,35000,0,0,10000,0,10000,45000,35000,0,35000,0,0,10000,0,10000,45000]
["34.3.1.8","Totals","EUR/year",17213,0,17213,0,0,49551,0,49551,66764,40471.15,0,40471.15,0,0,1510800,0,1510800,1551271.15,35000,0,35000,200000,200000,615000,0,1015000,1050000,35000,0,35000,500000,100000,110000,0,710000,745000,35000,0,35000,0,0,10000,0,10000,45000]

{"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,"K.U.R Hidrodrini 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","EUR/year",906,null,906,null,null,2608,null,2608,3514,null,null,0,null,null,null,null,0,0,null,null,0,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","Lyrja e objekteve te Kompanise","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,2850,null,2850,null,null,null,null,0,2850,2850,null,2850,null,null,null,null,0,2850,2850,null,2850,null,null,null,null,0,2850]
["35.1.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["35.1.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["35.1.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["35.1.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["35.1.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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.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]
["35.1.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["35.1.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["35.1.1.11","Totals","EUR/year",906,0,906,0,0,2608,0,2608,3514,0,0,0,0,0,0,0,0,0,2850,0,2850,0,0,0,0,0,2850,2850,0,2850,0,0,0,0,0,2850,2850,0,2850,0,0,0,0,0,2850]

{"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,"K.U.R Hidrodrini 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","Rehabilitimi i rrjetit te kanalizimit -Peje","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,80000,null,80000,null,null,2000000,null,2000000,2080000,150000,null,150000,null,null,2000000,null,2000000,2150000]
["41.1.1.2","Rehabilitimi i rrjetit te kanalizimit -Istog","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,200000,null,null,200000,200000,40000,null,40000,null,null,null,null,0,40000,70000,null,70000,null,null,null,null,0,70000]
["41.1.1.3","Rehabilitimi i rrjetit te kanalizimit -Kline","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,25000,null,25000,null,null,null,null,0,25000,30000,null,30000,null,null,null,null,0,30000,35000,null,35000,null,null,null,null,0,35000]
["41.1.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,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,null,null,0,null,null,null,null,0,0,0,null,0,null,null,null,null,0,0,0,null,0,null,null,null,null,0,0]
["41.1.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,25000,0,25000,0,200000,0,0,200000,225000,150000,0,150000,0,0,2000000,0,2000000,2150000,255000,0,255000,0,0,2000000,0,2000000,2255000]
[]
[41.2,"Wastewater treatment"]
["41.2.1","Infrastructure renewals expenditure and sources of finance"]
["41.2.1.1","Impijanti I ujerave te zeza Junik","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,350000,null,350000,350000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.2.1.2","Impijanti I ujerave te zeza Peje","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,6000000,null,6000000,6000000]
["41.2.1.3","Impijanti I ujerave te zeza Istog","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,250000,300000,null,550000,550000,null,null,0,null,150000,2800000,null,2950000,2950000]
["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,350000,0,350000,350000,0,0,0,0,250000,300000,0,550000,550000,0,0,0,0,150000,8800000,0,8950000,8950000]
[]
[41.3,"Sludge treatment and disposal"]
["41.3.1","Infrastructure renewals expenditure and sources of finance"]
["41.3.1.1","Impijanti I ujerave te zeza Junik","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,235000,null,235000,235000,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,235000,0,235000,235000,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,0,0,0,0,25000,0,25000,0,200000,0,0,200000,225000,150000,0,150000,0,0,2000000,0,2000000,2150000,255000,0,255000,0,0,2000000,0,2000000,2255000]
["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,350000,0,350000,350000,0,0,0,0,250000,300000,0,550000,550000,0,0,0,0,150000,8800000,0,8950000,8950000]
["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,235000,0,235000,235000,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,0,0,0,0,25000,0,25000,0,200000,585000,0,785000,810000,150000,0,150000,0,250000,2300000,0,2550000,2700000,255000,0,255000,0,150000,10800000,0,10950000,11205000]

{"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,"K.U.R Hidrodrini 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","Sic eshte siguruar nga ZRRUM","EUR/year",1591,null,1591,null,null,null,null,0,1591,null,null,0,null,null,null,null,0,0,null,null,0,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",1591,0,1591,0,0,0,0,0,1591,0,0,0,0,0,0,0,0,0,0,0,0,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",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["42.2.2","Level of service improvement (including backlog infrastructure renewals), expenditure and sources of finance"]
["42.2.2.1","Rrjeti i kanalizimit - Junik","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,715000,null,715000,715000,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,715000,0,715000,715000,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",1591,0,1591,0,0,0,0,0,1591,0,0,0,0,0,0,0,0,0,0,0,0,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",1591,0,1591,0,0,0,0,0,1591,0,0,0,0,0,0,0,0,0,0,0,0,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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.5","Wastewater treatment - level of service improvement","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,715000,0,715000,715000,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,715000,0,715000,715000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.8","Sludge treatment and disposal - quality improvement","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.9","Sludge treatment and disposal - level of service improvement","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.10","Sludge treatment and disposal - supply demand balance","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.11","Total sludge treatment and disposal ","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.12","Totals","EUR/year",1591,0,1591,0,0,0,0,0,1591,0,0,0,0,0,0,0,0,0,0,0,0,0,0,715000,0,715000,715000,0,0,0,0,0,0,0,0,0,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,"K.U.R Hidrodrini 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,"K.U.R Hidrodrini 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","EUR/year",65,null,65,null,null,null,null,0,65,null,null,0,null,null,null,null,0,0,null,null,0,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",65,0,65,0,0,0,0,0,65,0,0,0,0,0,0,0,0,0,0,0,0,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","Impianti i trajtimit te ujerave te zeza","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,700000,null,700000,700000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["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,700000,0,700000,700000,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",65,0,65,0,0,0,0,0,65,0,0,0,0,0,0,0,0,0,0,0,0,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",65,0,65,0,0,0,0,0,65,0,0,0,0,0,0,0,0,0,0,0,0,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,700000,0,700000,700000,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,700000,0,700000,700000,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",65,0,65,0,0,0,0,0,65,0,0,0,0,0,0,0,0,0,0,0,0,0,0,700000,0,700000,700000,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,"K.U.R Hidrodrini 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","EUR/year",7,null,7,null,null,0,null,0,7,null,null,0,null,null,null,null,0,0,null,null,0,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","Lyrja e objekteve te Kompanise","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,150,null,150,null,null,null,null,0,150,150,null,150,null,null,null,null,0,150,150,null,150,null,null,null,null,0,150]
["45.1.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["45.1.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["45.1.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["45.1.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["45.1.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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.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]
["45.1.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["45.1.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["45.1.1.11","Totals","EUR/year",7,0,7,0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,150,0,150,0,0,0,0,0,150,150,0,150,0,0,0,0,0,150,150,0,150,0,0,0,0,0,150]

{"sheet":"51- W RAB","index":17,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[null,"K.U.R Hidrodrini 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",222675,233483.44576116683,252514.68142515954,257913.44531402944,262651.31530444813]
["51.1.1.2","Indexation adjustment","EUR",7713.4457611668286,19031.235663992709,5398.7638888699112,4737.8699904187206,4323.2406499112158]
["51.1.1.3","Opening RAB at current year price levels","EUR",230388.44576116683,252514.68142515954,257913.44531402944,262651.31530444813,266974.55595435936]
["51.1.1.4","Additions (net of disposals and grants)","EUR",3095,0,0,0,0]
["51.1.1.5","Closing RAB at current year price levels","EUR",233483.44576116683,252514.68142515954,257913.44531402944,262651.31530444813,266974.55595435936]
[]
["51.1.2","Non-infrastructure"]
["51.1.2.1","Opening RAB at prior year price levels","EUR",1033395,1053824.3780830838,1117282.5480509032,1108565.1903874248,1096674.4034224176]
["51.1.2.2","Indexation adjustment","EUR",35796.727438468595,85897.225057552161,23887.500877328312,20364.342547416993,18051.260680332991]
["51.1.2.3","Opening RAB at current year price levels","EUR",1069191.7274384685,1139721.6031406359,1141170.0489282315,1128929.5329348417,1114725.6641027506]
["51.1.2.4","Additions (net of disposals and grants)","EUR",15401,10271.15,0,0,0]
["51.1.2.5","Depreciation","EUR",-30768.349355384813,-32710.205089732452,-32604.858540806614,-32255.12951242405,-31849.304688650016]
["51.1.2.6","Closing RAB at current year price levels","EUR",1053824.3780830838,1117282.5480509032,1108565.1903874248,1096674.4034224176,1082876.3594141006]
["51.1.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-31922.358515740092,-31010.291129576082,-30124.282811588193]
[]
[51.2,"Water distribution"]
[]
["51.2.1","Infrastructure"]
["51.2.1.1","Opening RAB at prior year price levels","EUR",4230820,4436184.2962625343,4816963.1282508941,4919949.799932898,5322372.1029376648]
["51.2.1.2","Indexation adjustment","EUR",146555.29626253436,361593.38198835915,102986.67168200412,90379.477824767338,87606.244814353951]
["51.2.1.3","Opening RAB at current year price levels","EUR",4377375.2962625343,4797777.678250894,4919949.799932898,5010329.2777576651,5409978.3477520188]
["51.2.1.4","Additions (net of disposals and grants)","EUR",58809,19185.45,0,312042.82518000004,317179.05008246278]
["51.2.1.5","Closing RAB at current year price levels","EUR",4436184.2962625343,4816963.1282508941,4919949.799932898,5322372.1029376648,5727157.3978344817]
[]
["51.2.2","Non-infrastructure"]
["51.2.2.1","Opening RAB at prior year price levels","EUR",121576,123979.57280895951,160022.71499465729,261466.6354800647,361190.42648800969]
["51.2.2.2","Indexation adjustment","EUR",4211.3837739289029,10105.57497965829,3421.2856465857726,4803.142093768789,5945.1944199926393]
["51.2.2.3","Opening RAB at current year price levels","EUR",125787.3837739289,134085.14778861779,163444.00064124307,266269.77757383347,367135.62090800231]
["51.2.2.4","Additions (net of disposals and grants)","EUR",1812,30200,104180.76,104014.27506,105726.3500274876]
["51.2.2.5","Depreciation","EUR",-3619.810964969397,-4262.4327939605082,-6158.1251611783728,-9093.6261458238132,-11999.965597764174]
["51.2.2.6","Closing RAB at current year price levels","EUR",123979.57280895951,160022.71499465729,261466.6354800647,361190.42648800969,460862.00533772574]
["51.2.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-6029.2204284187792,-8742.6712733210989,-11350.023522654783]
[]
[51.3,"Business activities"]
[]
["51.3.2","Non-infrastructure"]
["51.3.2.1","Opening RAB at prior year price levels","EUR",60788,61989.786404479753,65127.071783042928,67488.280004113971,69686.439600502563]
["51.3.2.2","Indexation adjustment","EUR",2105.6918869644514,5052.7874898291448,1392.4167947214578,1239.7597036755737,1147.038795824272]
["51.3.2.3","Opening RAB at current year price levels","EUR",62893.691886964451,67042.573894308895,66519.488577764379,68728.039707789547,70833.478396326842]
["51.3.2.4","Additions (net of disposals and grants)","EUR",906,0,2910.933,2964.4068392100003,3013.2009757833966]
["51.3.2.5","Depreciation","EUR",-1809.9054824846985,-1915.5021112659683,-1942.1415736504109,-2006.006946496987,-2066.8593966919584]
["51.3.2.6","Closing RAB at current year price levels","EUR",61989.786404479753,65127.071783042928,67488.280004113971,69686.439600502563,71779.819975418286]
["51.3.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-1901.487765229798,-1928.5881147946607,-1954.9141686576709]
[]
[51.4,"Summary"]
["51.4.1","Totals"]
["51.4.1.1","Opening RAB at prior year price levels","EUR",5669254,5909461.4793202234,6411910.1445046561,6615383.3511185311,7112574.6877530422]
["51.4.1.2","Indexation adjustment","EUR",196382.54512306317,481680.20517939143,137086.63888950957,121524.59216004742,117072.97936041508]
["51.4.1.3","Opening RAB at current year price levels","EUR",5865636.5451230621,6391141.6844996158,6548996.7833941672,6736907.9432785772,7229647.6671134587]
["51.4.1.4","Additions (net of disposals and grants)","EUR",80023,59656.6,107091.693,419021.50707921007,425918.6010857338]
["51.4.1.5","Depreciation","EUR",-36198.065802838908,-38888.139994958925,-40705.125275635401,-43354.76260474485,-45916.129683106148]
["51.4.1.6","Closing RAB at current year price levels","EUR",5909461.4793202234,6411910.1445046561,6615383.3511185311,7112574.6877530422,7609650.1385160852]
["51.4.1.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-39853.066709388666,-41681.550517691845,-43429.220502900644]

{"sheet":"52 - Water income","index":18,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[null,"K.U.R Hidrodrini 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",304716,327576,338376,349176,359976]
["52.1.1.2","Volume charges","EUR",1146585.24,1260123.7949999999,1559471.76,1741705.92,2001377.1600000001]
["52.1.1.3","Total household water tariff income","EUR",1451301.24,1587699.7949999999,1897847.76,2090881.92,2361353.16]
[]
["52.1.2","Commercial"]
["52.1.2.1","Fixed monthly charges","EUR",126126,129582,130842,132012,133092]
["52.1.2.2","Volume charges","EUR",334976.03999999998,358578.935,374763.92,422205.56,420274.96]
["52.1.2.3","Total commercial water tariff income","EUR",461102.04,488160.935,505605.92,554217.56000000006,553366.96]
[]
["52.1.3","Institutional"]
["52.1.3.1","Fixed monthly charges","EUR",9972,10350,10458,10566,10674]
["52.1.3.2","Volume charges","EUR",382360.01999999996,448919.57,443198.42,510255.62,515471.18]
["52.1.3.3","Total institutional water tariff income","EUR",392332.01999999996,459269.57,453656.42,520821.62,526145.17999999993]
[]
["52.1.4","Total water tariff income"]
["52.1.4.1","Household","EUR",1451301.24,1587699.7949999999,1897847.76,2090881.92,2361353.16]
["52.1.4.2","Commercial","EUR",461102.04,488160.935,505605.92,554217.56000000006,553366.96]
["52.1.4.3","Institutional","EUR",392332.01999999996,459269.57,453656.42,520821.62,526145.17999999993]
["52.1.4.3","Total water tariff income","EUR",2304735.2999999998,2535130.2999999998,2857110.1,3165921.1,3440865.3]
[]
[52.2,"Connection fees"]
[]
["52.2.1","Connection fees"]
["52.2.1.1","Household","EUR",145500,45000,27000,27000,27000]
["52.2.1.2","Commercial","EUR",7850,1750,1470,1260,1260]
["52.2.1.3","Institutional","EUR",54,9,9,9,9]
["52.2.1.4","Total connection fee income","EUR",153404,46759,28479,28269,28269]
[]
[52.3,"Total income from customers"]
[]
["52.3.1","Total income from customers"]
["52.3.1.1","Tariff income","EUR",2304735.2999999998,2535130.2999999998,2857110.1,3165921.1,3440865.3]
["52.3.1.2","Connection fees","EUR",153404,46759,28479,28269,28269]
["52.3.1.3","Total income from customers","EUR",2458139.2999999998,2581889.2999999998,2885589.1,3194190.1,3469134.3]
[]
[52.4,"Cash collection"]
[]
["52.4.1","Cash collection by category (excluding connection fees), excluding VAT"]
["52.4.1.1","Household","EUR",725650.62,920865.88109999988,1195644.0888,1359073.2479999999,1582106.6172000002]
["52.4.1.2","Commercial","EUR",331993.46879999997,366120.70124999998,414596.85439999995,471084.92600000004,492496.5944]
["52.4.1.3","Institutional","EUR",306018.97560000001,376601.04739999998,444583.2916,479155.89040000003,499837.92099999991]
["52.4.1.4","Total cash collection","EUR",1363663.0644,1663587.6297499998,2054824.2348000002,2309314.0644,2574441.1326000001]
[]
[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",681667,725650.62,666833.91390000004,702203.67119999998,731808.67200000002]
["52.4.1.2","Commercial","EUR",0,129108.57120000001,122040.23375000001,91009.065600000031,83132.63400000002]
["52.4.1.3","Institutional","EUR",0,86313.044399999955,82668.522600000026,9073.1283999999869,41665.729599999962]
["52.4.1.4","Total provision for write-off","EUR",681667,941072.23560000001,871542.67025000008,802285.86520000012,856607.03560000006]
[]
["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,"K.U.R Hidrodrini 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",1097777,1137394.9152233363,1230103.9747631904,1256403.5977436274,1279483.7318341779]
["61.1.1.2","Indexation adjustment","EUR",38026.915223336422,92709.059539854148,26299.622980437009,23080.134090550437,21060.302225990567]
["61.1.1.3","Opening RAB at current year price levels","EUR",1135803.9152233363,1230103.9747631904,1256403.5977436274,1279483.7318341779,1300544.0340601683]
["61.1.1.4","Additions (net of disposals and grants)","EUR",1591,0,0,0,0]
["61.1.1.5","Closing RAB at current year price levels","EUR",1137394.9152233363,1230103.9747631904,1256403.5977436274,1279483.7318341779,1300544.0340601683]
[]
["61.1.2","Non-infrastrucutre"]
["61.1.2.1","Opening RAB at prior year price levels","EUR",60920,61293.47108998568,64395.516149429546,63893.083933712798,63207.748460272953]
["61.1.2.2","Indexation adjustment","EUR",2110.2643573381979,4996.0308285447327,1376.7761352748037,1173.7159518623041,1040.3995396560927]
["61.1.2.3","Opening RAB at current year price levels","EUR",63030.264357338201,66289.501918530412,65772.292284704352,65066.799885575099,64248.147999929046]
["61.1.2.4","Additions (net of disposals and grants)","EUR",65,0,0,0,0]
["61.1.2.5","Depreciation","EUR",-1801.7932673525199,-1893.985769100869,-1879.2083509915528,-1859.0514253021456,-1835.6613714265441]
["61.1.2.6","Closing RAB at current year price levels","EUR",61293.47108998568,64395.516149429546,63893.083933712798,63207.748460272953,62412.486628502505]
["61.1.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-1839.8718899837013,-1787.3041216984525,-1736.2382896499253]
[]
[61.2,"Wastewater treatment"]
[]
["61.2.1","Infrastructure"]
["61.2.1.1","Opening RAB at prior year price levels","EUR",0,0,0,0,0]
["61.2.1.2","Indexation adjustment","EUR",0,0,0,0,0]
["61.2.1.3","Opening RAB at current year price levels","EUR",0,0,0,0,0]
["61.2.1.4","Additions (net of disposals and grants)","EUR",0,0,0,0,0]
["61.2.1.5","Closing RAB at current year price levels","EUR",0,0,0,0,0]
[]
["61.2.2","Non-infrastrucutre"]
["61.2.2.1","Opening RAB at prior year price levels","EUR",0,0,0,0,0]
["61.2.2.2","Indexation adjustment","EUR",0,0,0,0,0]
["61.2.2.3","Opening RAB at current year price levels","EUR",0,0,0,0,0]
["61.2.2.4","Additions (net of disposals and grants)","EUR",0,0,0,0,0]
["61.2.2.5","Depreciation","EUR",0,0,0,0,0]
["61.2.2.6","Closing RAB at current year price levels","EUR",0,0,0,0,0]
["61.2.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",0,0,0]
[]
[61.3,"Sludge treatment and disposal"]
[]
["61.3.1","Infrastructure"]
["61.3.1.1","Opening RAB at prior year price levels","EUR",0,0,0,0,0]
["61.3.1.2","Indexation adjustment","EUR",0,0,0,0,0]
["61.3.1.3","Opening RAB at current year price levels","EUR",0,0,0,0,0]
["61.3.1.4","Additions (net of disposals and grants)","EUR",0,0,0,0,0]
["61.3.1.5","Closing RAB at current year price levels","EUR",0,0,0,0,0]
[]
["61.3.2","Non-infrastrucutre"]
["61.3.2.1","Opening RAB at prior year price levels","EUR",0,0,0,0,0]
["61.3.2.2","Indexation adjustment","EUR",0,0,0,0,0]
["61.3.2.3","Opening RAB at current year price levels","EUR",0,0,0,0,0]
["61.3.2.4","Additions (net of disposals and grants)","EUR",0,0,0,0,0]
["61.3.2.5","Depreciation","EUR",0,0,0,0,0]
["61.3.2.6","Closing RAB at current year price levels","EUR",0,0,0,0,0]
["61.3.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",0,0,0]
[]
[61.4,"Business activities"]
[]
["61.4.2","Non-infrastrucutre"]
["61.4.2.1","Opening RAB at prior year price levels","EUR",6769,6810.2783044667276,7154.9445436619872,7250.1379506338953,7326.1634347746958]
["61.4.2.2","Indexation adjustment","EUR",234.47766636280795,555.10578459708302,152.97271434349329,133.18503415314467,120.58865013639148]
["61.4.2.3","Opening RAB at current year price levels","EUR",7003.4776663628081,7365.3840890638103,7307.9172580054801,7383.3229847870398,7446.752084911087]
["61.4.2.4","Additions (net of disposals and grants)","EUR",7,0,153.20699999999999,156.02141259000001,158.58952504123141]
["61.4.2.5","Depreciation","EUR",-200.19936189608023,-210.43954540182315,-210.98630737158516,-213.18096260234398,-215.02990992662009]
["61.4.2.6","Closing RAB at current year price levels","EUR",6810.2783044667276,7154.9445436619872,7250.1379506338953,7326.1634347746958,7390.311700025698]
["61.4.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-206.5698441046282,-204.95356284449593,-203.38346104893893]
[]
[61.5,"Summary"]
["61.5.1","Totals"]
["61.5.1.1","Opening RAB at prior year price levels","EUR",1165466,1205498.6646177887,1301654.435456282,1327546.8196279739,1350017.6437292255]
["61.5.1.2","Indexation adjustment","EUR",40371.65724703743,98260.196152995966,27829.371830055305,24387.035076565888,22221.290415783053]
["61.5.1.3","Opening RAB at current year price levels","EUR",1205837.6572470374,1303758.8607707846,1329483.8072863373,1351933.85470454,1372238.9341450084]
["61.5.1.4","Additions (net of disposals and grants)","EUR",1663,0,153.20699999999999,156.02141259000001,158.58952504123141]
["61.5.1.5","Depreciation","EUR",-2001.9926292486002,-2104.4253145026923,-2090.1946583631379,-2072.2323879044898,-2050.691281353164]
["61.5.1.6","Closing RAB at current year price levels","EUR",1205498.6646177887,1301654.435456282,1327546.8196279739,1350017.6437292255,1370346.8323886967]
["61.5.1.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-2046.4417340883294,-1992.2576845429485,-1939.6217506988642]

{"sheet":"62 - WW income","index":20,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,"K.U.R Hidrodrini 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",139250.75,140621.25,176142.6,216892.2,256627.20000000001]
["62.1.1.2","Commercial","EUR",37645.71695553881,62185.279999999999,94252.319999999992,103086.88,119990.39999999999]
["62.1.1.3","Institutional","EUR",28916.657314629261,46691.68,71314.8,78641.42,92336.7]
["62.1.1.4","Total water tariff income","EUR",205813.12427016807,249498.21,341709.72,398620.5,468954.3]
[]
[62.2,"Connection fees"]
[]
["62.2.1","Connection fees"]
["62.2.1.1","Household","EUR",17000,1500,18000,9000,9000]
["62.2.1.2","Commercial","EUR",8800,1750,980,840,840]
["62.2.1.3","Institutional","EUR",0,150,84,84,84]
["62.2.1.4","Total connection fee income","EUR",25800,3400,19064,9924,9924]
[]
[62.3,"Total income from customers"]
[]
["62.3.1","Total income from customers"]
["62.3.1.1","Tariff income","EUR",205813.12427016807,249498.21,341709.72,398620.5,468954.3]
["62.3.1.2","Connection fees","EUR",25800,3400,19064,9924,9924]
["62.3.1.3","Total income from customers","EUR",231613.12427016807,252898.21,360773.72,408544.5,478878.3]
[]
[62.4,"Cash collection"]
[]
["62.4.1","Cash collection by category (excluding connection fees), excluding VAT"]
["62.4.1.1","Household","EUR",69625.375,81560.324999999997,110969.838,140979.93000000002,171940.22400000002]
["62.4.1.2","Commercial","EUR",27104.916207987942,46638.96,77286.902399999992,87623.847999999998,106791.45599999999]
["62.4.1.3","Institutional","EUR",22554.992705410823,38287.177599999995,69888.504000000001,72350.106400000004,87719.864999999991]
["62.4.1.4","Total cash collection","EUR",119285.28391339877,166486.4626,258145.24440000003,300953.88440000004,366451.54499999998]
[]
[62.5,"Provisions for write off (offset by 12 months)"]
[]
["62.5.1","Write-off provisions (excluding VAT)"]
["62.5.1.1","Household","EUR",239504,69625.375,59060.925000000003,65172.762000000002,75912.26999999999]
["62.5.1.2","Commercial","EUR",0,10540.800747550868,15546.32,16965.417600000001,15463.032000000007]
["62.5.1.3","Institutional","EUR",0,6361.6646092184383,8404.5024000000049,1426.2960000000021,6291.313599999994]
["62.5.1.4","Total provision for write-off","EUR",239504,86527.840356769302,83011.747399999993,83564.475600000005,97666.61559999999]
[]
["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,"K.U.R Hidrodrini 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,2304735.2999999998,null,null,null,205813.12427016807,2510548.4242701679]
[]
[81.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["81.2.1.1","Service charges","EUR",0,0,0,0,0,0,0,0]
["81.2.1.2","Energy costs","EUR",6789,315682,322471,0,0,0,0,322471]
["81.2.1.3","Fuel costs","EUR",2354,35306,37660,2028,0,0,2028,39688]
["81.2.1.4","Staff costs","EUR",86315,604202,690517,45429,0,0,45429,735946]
["81.2.1.5","Materials and consumables","EUR",8658,0,8658,0,0,0,0,8658]
["81.2.1.6","Contracted services","EUR",9000,0,9000,0,0,0,0,9000]
["81.2.1.7","Maintenance and repair","EUR",11532,103488,115020,6069,0,0,6069,121089]
["81.2.1.8","Other direct costs","EUR",2665,41754,44419,856,0,0,856,45275]
["81.2.1.9","Total Direct costs","EUR",127313,1100432,1227745,54382,0,0,54382,1282127]
[]
[81.3,"Indirect costs"]
[]
["81.3.1.","Business activities"]
["81.3.1.1","Energy costs","EUR",null,null,16123.4,null,null,null,848.60000000000036,16972]
["81.3.1.2","Fuel costs","EUR",null,null,11528.25,null,null,null,606.75,12135]
["81.3.1.3","Staff costs","EUR",null,null,163997.54999999999,null,null,null,8631.4500000000116,172629]
["81.3.1.4","Materials and consumables","EUR",null,null,9500,null,null,null,500,10000]
["81.3.1.5","Contracted services","EUR",null,null,0,null,null,null,0,0]
["81.3.1.6","Maintenance and repair","EUR",null,null,190,null,null,null,10,200]
["81.3.1.7","Other indirect costs","EUR",null,null,39105.799999999996,null,null,null,2058.2000000000044,41164]
["81.3.1.8","Total Busiiness activities costs","EUR",null,null,240444.99999999997,null,null,null,12655.000000000016,253100]
[]
["81.3.2.","Other indirect costs"]
["81.3.2.1","Bad debts","EUR",null,null,681667,null,null,null,239504,921171]
["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,681667,null,null,null,239504,921171]
["81.3.2.4","Total all indirect costs","EUR",null,null,922112,null,null,null,252159.00000000003,1174271]
["81.3.2.5","Total direct and indirect costs","EUR",null,null,2149857,null,null,null,306541,2456398]
[]
[81.400000000000006,"Net Income before cap maintenance"]
[]
["81.4.1","Net income"]
["81.4.1.1.","Net income before capital maintenance","EUR",null,null,154878.29999999981,null,null,null,-100727.87572983193,54150.424270167947]
[]
[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",30768.349355384813,3619.810964969397,34388.160320354211,1801.7932673525199,0,0,1801.7932673525199,36189.953587706732]
["81.5.1.3","Depreciation (business activities)","EUR",null,null,1809.9054824846985,null,null,null,2001.9926292486002,3811.8981117332987]
["81.5.1.4","Total capital maintenance","EUR",30768.349355384813,3619.810964969397,36198.065802838908,1801.7932673525199,0,0,3803.7858966011199,40001.851699440027]
[]
[81.599999999999994,"Net Income"]
[]
["81.6.1","Net income"]
["81.6.1.1","Net income before taxes and dividends","EUR",null,null,118680.2341971609,null,null,null,-104531.66162643305,14148.57257072792]

{"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,"K.U.R Hidrodrini 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,2535130.2999999998,null,null,null,249498.21,2784628.51]
[]
[82.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["82.2.1.1","Service charges","EUR",30000,0,30000,0,0,0,0,30000]
["82.2.1.2","Energy costs","EUR",7332,340938,348270,0,0,0,0,348270]
["82.2.1.3","Fuel costs","EUR",4320,32400,36720,10260,0,0,10260,46980]
["82.2.1.4","Staff costs","EUR",85868,601078,686946,42934,0,0,42934,729880]
["82.2.1.5","Materials and consumables","EUR",14400,0,14400,4560,0,0,4560,18960]
["82.2.1.6","Contracted services","EUR",9000,0,9000,950,0,0,950,9950]
["82.2.1.7","Maintenance and repair","EUR",2088,76500,78588,4180,0,0,4180,82768]
["82.2.1.8","Other direct costs","EUR",2352,91737,94089,12415,0,0,12415,106504]
["82.2.1.9","Total Direct costs","EUR",155360,1142653,1298013,75299,0,0,75299,1373312]
[]
[82.3,"Indirect costs"]
[]
["82.3.1.","Business activities"]
["82.3.1.1","Energy costs","EUR",null,null,17413.272000000001,null,null,null,916.4880000000004,18329.760000000002]
["82.3.1.2","Fuel costs","EUR",null,null,12450.51,null,null,null,655.29000000000008,13105.800000000001]
["82.3.1.3","Staff costs","EUR",null,null,177117.35399999999,null,null,null,9321.9660000000131,186439.32]
["82.3.1.4","Materials and consumables","EUR",null,null,10260,null,null,null,540,10800]
["82.3.1.5","Contracted services","EUR",null,null,0,null,null,null,0,0]
["82.3.1.6","Maintenance and repair","EUR",null,null,205.20000000000002,null,null,null,10.8,216.00000000000003]
["82.3.1.7","Other indirect costs","EUR",null,null,42234.263999999996,null,null,null,2222.8560000000048,44457.120000000003]
["82.3.1.8","Total Busiiness activities costs","EUR",null,null,259680.6,null,null,null,13667.400000000018,273348]
[]
["82.3.2.","Other indirect costs"]
["82.3.2.1","Bad debts","EUR",null,null,941072.23560000001,null,null,null,86527.840356769302,1027600.0759567693]
["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,941072.23560000001,null,null,null,86527.840356769302,1027600.0759567693]
["82.3.2.4","Total all indirect costs","EUR",null,null,1200752.8356000001,null,null,null,100195.24035676933,1300948.0759567695]
["82.3.2.5","Total direct and indirect costs","EUR",null,null,2498765.8355999999,null,null,null,175494.24035676933,2674260.0759567693]
[]
[82.4,"Net Income before cap maintenance"]
[]
["82.4.1","Net income"]
["82.4.1.1.","Net income before capital maintenance","EUR",null,null,36364.464399999939,null,null,null,74003.969643230666,110368.43404323049]
[]
[82.5,"Capital maintenance"]
[]
["82.5.1","Capital maintenance"]
["82.5.1.1","Infrastructure renewals","EUR",0,0,0,0,0,0,0,0]
["82.5.1.2","Depreciation (service activities)","EUR",32710.205089732452,4262.4327939605082,36972.637883692958,1893.985769100869,0,0,1893.985769100869,38866.623652793824]
["82.5.1.3","Depreciation (business activities)","EUR",null,null,1915.5021112659683,null,null,null,2104.4253145026923,4019.9274257686607]
["82.5.1.4","Total capital maintenance","EUR",32710.205089732452,4262.4327939605082,38888.139994958925,1893.985769100869,0,0,3998.4110836035616,42886.551078562487]
[]
[82.6,"Net Income"]
[]
["82.6.1","Net income"]
["82.6.1.1","Net income before taxes and dividends","EUR",null,null,-2523.675594958986,null,null,null,70005.558559627098,67481.88296466801]

{"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,"K.U.R Hidrodrini 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,2857110.1,null,null,null,341709.72,3198819.8200000003]
[]
[83.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["83.2.1.1","Service charges","EUR",30641.399999999998,0,30641.399999999998,0,0,0,0,30641.399999999998]
["83.2.1.2","Energy costs","EUR",10009.523999999999,348227.25443999999,358236.77843999997,0,3064.14,0,3064.14,361300.91843999998]
["83.2.1.3","Fuel costs","EUR",4902.6239999999998,36769.68,41672.304000000004,10479.3588,510.69,0,10990.0488,52662.352800000008]
["83.2.1.4","Staff costs","EUR",97031.099999999991,530511.92165999999,627543.02165999997,29971.37472,0,0,29971.37472,657514.39637999993]
["83.2.1.5","Materials and consumables","EUR",15320.699999999999,41365.89,56686.59,4843.792512,510.69,0,5354.4825119999996,62041.072511999999]
["83.2.1.6","Contracted services","EUR",9192.42,0,9192.42,970.31099999999992,0,0,970.31099999999992,10162.731]
["83.2.1.7","Maintenance and repair","EUR",2298.105,78135.569999999992,80433.674999999988,4269.3683999999994,204.27599999999998,0,4473.6443999999992,84907.319399999993]
["83.2.1.8","Other direct costs","EUR",2573.8775999999998,93698.337059999991,96272.214659999998,12680.432699999999,0,0,12680.432699999999,108952.64736]
["83.2.1.9","Total Direct costs","EUR",171969.75060000003,1128708.65316,1300678.4037600001,63214.638132,4289.7960000000003,0,67504.434131999995,1368182.8378920001]
[]
[83.3,"Indirect costs"]
[]
["83.3.1.","Business activities"]
["83.3.1.1","Energy costs","EUR",null,null,17785.56775536,null,null,null,936.08251344000041,18721.6502688]
["83.3.1.2","Fuel costs","EUR",null,null,12716.7019038,null,null,null,669.30010020000009,13386.002004]
["83.3.1.3","Staff costs","EUR",null,null,188140.28794966079,null,null,null,13653.64915840321,201793.93710806401]
["83.3.1.4","Materials and consumables","EUR",null,null,10479.3588,null,null,null,551.54520000000002,11030.904]
["83.3.1.5","Contracted services","EUR",null,null,0,null,null,null,0,0]
["83.3.1.6","Maintenance and repair","EUR",null,null,209.587176,null,null,null,11.030904,220.61807999999999]
["83.3.1.7","Other indirect costs","EUR",null,null,43137.232564319995,null,null,null,2270.3806612800049,45407.613225599998]
["83.3.1.8","Total Busiiness activities costs","EUR",null,null,272468.73614914075,null,null,null,18091.988537323214,290560.72468646395]
[]
["83.3.2.","Other indirect costs"]
["83.3.2.1","Bad debts","EUR",null,null,871542.67025000008,null,null,null,83011.747399999993,954554.41765000008]
["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,871542.67025000008,null,null,null,83011.747399999993,954554.41765000008]
["83.3.2.4","Total all indirect costs","EUR",null,null,1144011.4063991408,null,null,null,101103.7359373232,1245115.142336464]
["83.3.2.5","Total direct and indirect costs","EUR",null,null,2444689.8101591412,null,null,null,168608.17006932321,2613297.9802284641]
[]
[83.4,"Net Income before cap maintenance"]
[]
["83.4.1","Net income"]
["83.4.1.1.","Net income before capital maintenance","EUR",null,null,412420.2898408589,null,null,null,173101.54993067676,585521.83977153618]
[]
[83.5,"Capital maintenance"]
[]
["83.5.1","Capital maintenance"]
["83.5.1.1","Infrastructure renewals","EUR",0,268380.21452208102,268380.21452208102,25534.5,0,0,25534.5,293914.71452208102]
["83.5.1.2","Depreciation (service activities)","EUR",32604.858540806614,6158.1251611783728,38762.983701984987,1879.2083509915528,0,0,1879.2083509915528,40642.192052976541]
["83.5.1.3","Depreciation (business activities)","EUR",null,null,1942.1415736504109,null,null,null,2090.1946583631379,4032.3362320135489]
["83.5.1.4","Total capital maintenance","EUR",32604.858540806614,274538.33968325937,309085.33979771641,27413.708350991554,0,0,29503.90300935469,338589.24280707107]
[]
[83.6,"Net Income"]
[]
["83.6.1","Net income"]
["83.6.1.1","Net income before taxes and dividends","EUR",null,null,103334.95004314248,null,null,null,143597.64692132207,246932.5969644651]

{"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,"K.U.R Hidrodrini 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,3165921.1,null,null,null,398620.5,3564541.6]
[]
[84.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["84.2.1.1","Service charges","EUR",31204.282518,0,31204.282518,0,0,0,0,31204.282518]
["84.2.1.2","Energy costs","EUR",10193.39895588,354624.1891040628,364817.58805994282,0,3120.4282518,0,3120.4282518,367938.01631174283]
["84.2.1.3","Fuel costs","EUR",4992.6852028800004,37445.1390216,42437.824224479999,10671.864621156001,520.0713753,0,11191.935996456001,53629.760220935997]
["84.2.1.4","Staff costs","EUR",98813.561307000011,540257.42566089425,639070.98696789425,30521.948873606401,0,0,30521.948873606401,669592.93584150064]
["84.2.1.5","Materials and consumables","EUR",15602.141259,42125.781399300002,57727.922658299998,4932.7729804454411,520.0713753,0,5452.8443557454411,63180.767014045443]
["84.2.1.6","Contracted services","EUR",9361.2847554,0,9361.2847554,988.13561307000009,0,0,988.13561307000009,10349.420368470001]
["84.2.1.7","Maintenance and repair","EUR",2340.32118885,79570.920420900002,81911.241609749995,4347.7966975079999,208.02855012000001,0,4555.8252476279995,86467.066857377999]
["84.2.1.8","Other direct costs","EUR",2621.1597315120002,95419.575511792209,98040.735243304211,12913.372248699001,0,0,12913.372248699001,110954.10749200321]
["84.2.1.9","Total Direct costs","EUR",175128.83491852201,1149443.0311185494,1324571.8660370714,64375.891034484848,4368.5995525199996,0,68744.490587004853,1393316.3566240764]
[]
[84.3,"Indirect costs"]
[]
["84.3.1.","Business activities"]
["84.3.1.1","Energy costs","EUR",null,null,18112.288635025965,null,null,null,953.27834921189321,19065.566984237859]
["84.3.1.2","Fuel costs","EUR",null,null,12950.307717772806,null,null,null,681.59514304067409,13631.902860813481]
["84.3.1.3","Staff costs","EUR",null,null,191596.4250392961,null,null,null,13904.466693443079,205500.89173273917]
["84.3.1.4","Materials and consumables","EUR",null,null,10671.864621156001,null,null,null,561.67708532400002,11233.54170648]
["84.3.1.5","Contracted services","EUR",null,null,0,null,null,null,0,0]
["84.3.1.6","Maintenance and repair","EUR",null,null,213.43729242312003,null,null,null,11.23354170648,224.67083412960002]
["84.3.1.7","Other indirect costs","EUR",null,null,43929.663526526558,null,null,null,2312.0875540277189,46241.751080554277]
["84.3.1.8","Total Busiiness activities costs","EUR",null,null,277473.98683220055,null,null,null,18424.338366753844,295898.32519895438]
[]
["84.3.2.","Other indirect costs"]
["84.3.2.1","Bad debts","EUR",null,null,802285.86520000012,null,null,null,83564.475600000005,885850.34080000012]
["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,802285.86520000012,null,null,null,83564.475600000005,885850.34080000012]
["84.3.2.4","Total all indirect costs","EUR",null,null,1079759.8520322007,null,null,null,101988.81396675385,1181748.6659989546]
["84.3.2.5","Total direct and indirect costs","EUR",null,null,2404331.7180692721,null,null,null,170733.3045537587,2575065.0226230309]
[]
[84.4,"Net Income before cap maintenance"]
[]
["84.4.1","Net income"]
["84.4.1.1.","Net income before capital maintenance","EUR",null,null,761589.38193072798,null,null,null,227887.1954462413,989476.57737696916]
[]
[84.5,"Capital maintenance"]
[]
["84.5.1","Capital maintenance"]
["84.5.1.1","Infrastructure renewals","EUR",0,221303.22153285166,221303.22153285166,156021.41259000002,0,0,156021.41259000002,377324.63412285165]
["84.5.1.2","Depreciation (service activities)","EUR",32255.12951242405,9093.6261458238132,41348.755658247865,1859.0514253021456,0,0,1859.0514253021456,43207.807083550011]
["84.5.1.3","Depreciation (business activities)","EUR",null,null,2006.006946496987,null,null,null,2072.2323879044898,4078.2393344014768]
["84.5.1.4","Total capital maintenance","EUR",32255.12951242405,230396.84767867546,264657.98413759656,157880.46401530216,0,0,159952.69640320665,424610.68054080324]
[]
[84.6,"Net Income"]
[]
["84.6.1","Net income"]
["84.6.1.1","Net income before taxes and dividends","EUR",null,null,496931.39779313141,null,null,null,67934.499043034652,564865.89683616592]

{"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,"K.U.R Hidrodrini 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,3440865.3,null,null,null,468954.3,3909819.5999999996]
[]
[85.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["85.2.1.1","Service charges","EUR",31717.905008246282,0,31717.905008246282,0,0,0,0,31717.905008246282]
["85.2.1.2","Energy costs","EUR",10361.182302693785,360461.30325671571,370822.48555940948,0,3171.790500824628,0,3171.790500824628,373994.27606023411]
["85.2.1.3","Fuel costs","EUR",5074.8648013194052,38061.48600989554,43136.350811214943,10847.523512820228,528.63175013743796,0,11376.155262957665,54512.506074172605]
["85.2.1.4","Staff costs","EUR",100440.03252611322,549150.06288727256,649590.09541338577,31024.340152065961,0,0,31024.340152065961,680614.43556545174]
["85.2.1.5","Materials and consumables","EUR",15858.952504123141,42819.171761132478,58678.124265255618,5013.9664237035731,528.63175013743796,0,5542.598173841011,64220.722439096629]
["85.2.1.6","Contracted services","EUR",9515.3715024738849,0,9515.3715024738849,1004.4003252611323,0,0,1004.4003252611323,10519.771827735018]
["85.2.1.7","Maintenance and repair","EUR",2378.8428756184712,80880.657771028011,83259.500646646484,4419.3614311489819,211.4527000549752,0,4630.814131203957,87890.314777850435]
["85.2.1.8","Other direct costs","EUR",2664.3040206926876,96990.181724716298,99654.48574540898,13125.926355912587,0,0,13125.926355912587,112780.41210132156]
["85.2.1.9","Total Direct costs","EUR",178011.45554128088,1168362.8634107604,1346374.3189520412,65435.518200912455,4440.5067011544788,0,69876.024902066929,1416250.3438541081]
[]
[85.3,"Indirect costs"]
[]
["85.3.1.","Business activities"]
["85.3.1.1","Energy costs","EUR",null,null,18410.416905958493,null,null,null,936.08251344000041,19346.499419398493]
["85.3.1.2","Fuel costs","EUR",null,null,13163.469782807348,null,null,null,669.30010020000009,13832.769883007348]
["85.3.1.3","Staff costs","EUR",null,null,194750.10219544289,null,null,null,13653.64915840321,208403.75135384611]
["85.3.1.4","Materials and consumables","EUR",null,null,10847.523512820228,null,null,null,551.54520000000002,11399.068712820228]
["85.3.1.5","Contracted services","EUR",null,null,0,null,null,null,0,0]
["85.3.1.6","Maintenance and repair","EUR",null,null,216.95047025640457,null,null,null,11.030904,227.98137425640456]
["85.3.1.7","Other indirect costs","EUR",null,null,44652.745788173183,null,null,null,2270.3806612800049,46923.126449453186]
["85.3.1.8","Total Busiiness activities costs","EUR",null,null,282041.20865545853,null,null,null,18091.988537323214,300133.19719278172]
[]
["85.3.2.","Other indirect costs"]
["85.3.2.1","Bad debts","EUR",null,null,856607.03560000006,null,null,null,97666.61559999999,954273.65120000008]
["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,856607.03560000006,null,null,null,97666.61559999999,954273.65120000008]
["85.3.2.4","Total all indirect costs","EUR",null,null,1138648.2442554585,null,null,null,115758.6041373232,1254406.8483927816]
["85.3.2.5","Total direct and indirect costs","EUR",null,null,2485022.5632074997,null,null,null,185634.62903939013,2670657.1922468897]
[]
[85.4,"Net Income before cap maintenance"]
[]
["85.4.1","Net income"]
["85.4.1.1.","Net income before capital maintenance","EUR",null,null,955842.73679250013,null,null,null,283319.67096060986,1239162.4077531099]
[]
[85.5,"Capital maintenance"]
[]
["85.5.1","Capital maintenance"]
["85.5.1.1","Infrastructure renewals","EUR",0,224945.8725592824,224945.8725592824,269602.19257009338,0,0,269602.19257009338,494548.06512937578]
["85.5.1.2","Depreciation (service activities)","EUR",31849.304688650016,11999.965597764174,43849.27028641419,1835.6613714265441,0,0,1835.6613714265441,45684.931657840731]
["85.5.1.3","Depreciation (business activities)","EUR",null,null,2066.8593966919584,null,null,null,2050.691281353164,4117.5506780451224]
["85.5.1.4","Total capital maintenance","EUR",31849.304688650016,236945.83815704659,270862.00224238855,271437.85394151992,0,0,273488.5452228731,544350.54746526165]
[]
[85.6,"Net Income"]
[]
["85.6.1","Net income"]
["85.6.1.1","Net income before taxes and dividends","EUR",null,null,684980.73455011158,null,null,null,9831.1257377367583,694811.86028784828]