{"text_format":"1","workbook":"xlsx","n_sheets":27,"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","71 - W op subs","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.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[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.2000000000000002,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,30,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",150,90,90,90,90]
["1.2.3.4","Non-household (base year price levels)","EUR/con","N/A","N/A",88.116078247077482,86.526584882780796,85.12542046197666]
[]
["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.4,"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.31757155220730654,"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.5,2.5,2.5]
[]
["1.3.2","Connection fees (average)"]
["1.3.2.1","Household (nominal prices)","EUR/con",0,20,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",0,60,60,60,60]
["1.3.2.4","Non-household (base year price levels)","EUR/con","N/A","N/A",58.744052164718326,57.684389921853864,56.75028030798444]
[]
["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.2,"N/A","N/A"]
["1.3.3.3","Tariff option 3 - Year 1 household tariff (at base year price levels)","EUR/m3","N/A","N/A",7.7823040235630095E-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.44,0.45,0.49,0.51,0.53]
["1.4.1.2","Commercial","% of billing",0.8,0.85,0.89,0.91,0.92]
["1.4.1.3","Institutions","% of billing",0.9,0.95,0.97,0.99,1]
[]
["1.4.2","Profitability"]
["1.4.2.1","Expected real rate of return on RAB","% (real)","N/A","N/A",5.2999999999999999E-2,"N/A","N/A"]

{"sheet":"2 - Tariffs control sheet","index":1,"n_rows":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[null,"K.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[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.28000000000000003,0.28999999999999998,"N/A","N/A","N/A"]
["2.2.1.2","Non-household","EUR/m3",0.72,0.73,"N/A","N/A","N/A"]
[]
["2.2.2","Wastewater"]
["2.2.2.1","Household","EUR/m3",0.05,0.06,"N/A","N/A","N/A"]
["2.2.2.2","Non-household","EUR/m3",0.13,0.15,"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.31757155220730654,0.34923621616994216,0.38405812434068659]
["2.3.1.2","Non-household","EUR/m3","N/A","N/A",0.69865741485607447,0.69847243233988432,0.69130462381323587]
[]
["2.3.2","Wastewater (volume of water consumed)"]
["2.3.2.1","Household","EUR/m3","N/A","N/A",7.7823040235630095E-2,0.10206939967099837,0.1338698965968719]
["2.3.2.2","Non-household","EUR/m3","N/A","N/A",0.19455760058907523,0.25517349917749593,0.33467474149217974]
[]
[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.28000000000000003,0.28999999999999998,0.33,0.37,0.42]
["2.4.1.3","Commercial - fixed monthly charge","EUR/Con/month",3,3,3,3,3]
["2.4.1.4","Commercial - volume","EUR/m3",0.72,0.73,0.73,0.75,0.75]
["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.72,0.73,0.73,0.75,0.75]
[]
["2.4.2","Wastewater (volume of water consumed)"]
["2.4.2.1","Household","EUR/m3",0.05,0.06,0.08,0.11,0.15]
["2.4.2.2","Commercial","EUR/m3",0.13,0.15,0.2,0.27,0.35]
["2.4.2.3","Institutional","EUR/m3",0.13,0.15,0.2,0.27,0.35]
[]
[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.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[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",32500,32500,32900,33300,33700]
["11.1.1.2","Households in service area at end of year","No",32500,32900,33300,33700,34100]
["11.1.1.3","Average number of households in service area over the year","No",32500,32700,33100,33500,33900]
[]
["11.1.2","Households served with water supply"]
["11.1.2.1","Metered households with water supply service at start of year","No",10086,10875,12320,17120,20920]
["11.1.2.2","Metered households with water supply service at end of year","No",10875,12320,17120,20920,23570]
["11.1.2.3","Un-metered households with water supply service at start of year","No",8473,8445,8000,4000,1000]
["11.1.2.4","Un-metered households with water supply service at end of year","No",8445,8000,4000,1000,500]
["11.1.2.5","Total households with water supply at start of year","No",18559,19320,20320,21120,21920]
["11.1.2.6","Total households with water supply at end of year","No",19320,20320,21120,21920,24070]
["11.1.2.7","Average metered households served in year","No",10480.5,11597.5,14720,19020,22245]
["11.1.2.8","Average un-metered households served in year","No",8459,8222.5,6000,2500,750]
["11.1.2.9","Average total households served in year","No",18939.5,19820,20720,21520,22995]
["11.1.2.10","New household connections in year","No",761,1000,800,800,2150]
["11.1.2.11","Service coverage","%",0.58275384615384618,0.60611620795107035,0.62598187311178244,0.64238805970149249,0.67831858407079648]
[]
["11.1.3","Household water consumption"]
["11.1.3.1","Average annual metered water billed per metered household","m3/household/year",192,192,192,192,192]
["11.1.3.2","Average annual un-metered water billed per un-metered household","m3/household/year",285,240,288,288,288]
["11.1.3.3","Total household metered water billed","m3/year",2012256,2226720,2826240,3651840,4271040]
["11.1.3.4","Total household un-metered water billed","m3/year",2410815,1973400,1728000,720000,216000]
["11.1.3.5","Total household water billed","m3/year",4423071,4200120,4554240,4371840,4487040]
[]
[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",1220,1324,1645,1995,2095]
["11.2.1.2","Metered commercial with water supply service at end of year","No",1324,1645,1995,2095,2195]
["11.2.1.3","Un-metered commercial with water supply service at start of year","No",465,471,250,0,0]
["11.2.1.4","Un-metered commercial with water supply service at end of year","No",471,250,0,0,0]
["11.2.1.5","Total commercial with water supply at start of year","No",1685,1795,1895,1995,2095]
["11.2.1.6","Total commercial with water supply at end of year","No",1795,1895,1995,2095,2195]
["11.2.1.7","Average metered commercial served in year","No",1272,1484.5,1820,2045,2145]
["11.2.1.8","Average un-metered commercial served in year","No",468,360.5,125,0,0]
["11.2.1.9","Average total commercial served in year","No",1740,1845,1945,2045,2145]
["11.2.1.10","New commercial connections in year","No",110,100,100,100,100]
[]
["11.2.2","Non-household (commercial) water consumption"]
["11.2.2.1","Total commercial metered water billed","m3/year",109392,127667,156520,175870,184470]
["11.2.2.2","Total commercial un-metered water billed","m3/year",40248,46504.5,32250,0,0]
["11.2.2.3","Total commercial water billed","m3/year",149640,174171.5,188770,175870,184470]
[]
[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",275,281,378,398,403]
["11.3.1.2","Metered institutional with water supply service at end of year","No",281,378,398,403,408]
["11.3.1.3","Un-metered institutional with water supply service at start of year","No",29,30,15,0,0]
["11.3.1.4","Un-metered institutional with water supply service at end of year","No",30,15,0,0,0]
["11.3.1.5","Total institutional with water supply at start of year","No",304,311,393,398,403]
["11.3.1.6","Total institutional with water supply at end of year","No",311,393,398,403,408]
["11.3.1.7","Average metered institutional served in year","No",278,329.5,388,400.5,405.5]
["11.3.1.8","Average un-metered institutional served in year","No",29.5,22.5,7.5,0,0]
["11.3.1.9","Average total institutional served in year","No",307.5,352,395.5,400.5,405.5]
["11.3.1.10","New institutional connections in year","No",7,82,5,5,5]
[]
["11.3.2","Non-household (institutional) water consumption"]
["11.3.2.1","Total institutional metered water billed","m3/year",448882.43,532038.70750000002,626497.78,646681.34250000003,654754.76749999996]
["11.3.2.2","Total institutional un-metered water billed","m3/year",7434,54495.618749999994,36330.412499999999,0,0]
["11.3.2.3","Total institutional water billed","m3/year",456316.43,586534.32625000004,662828.1925,646681.34250000003,654754.76749999996]
[]
[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",1550,1814,2208,2445.5,2550.5]
["11.4.1.2","Average un-metered non-household served in year","No",497.5,383,132.5,0,0]
["11.4.1.3","Average total non-household served in year","No",2047.5,2197,2340.5,2445.5,2550.5]
[]
["11.4.2","Non-household water consumption"]
["11.4.2.3","Total non-household metered water billed","m3/year",558274.42999999993,659705.70750000002,783017.78,822551.34250000003,839224.76749999996]
["11.4.2.4","Total non-household un-metered water billed","m3/year",47682,101000.11874999999,68580.412500000006,0,0]
["11.4.2.5","Total non-household water billed","m3/year",605956.42999999993,760705.82625000004,851598.1925,822551.34250000003,839224.76749999996]
[]
[11.5,"Household and non-household"]
[]
["11.5.1","Total served"]
["11.5.1.1","Total metered connections","No",12030.5,13411.5,16928,21465.5,24795.5]
["11.5.1.2","Total un-metered connections","No",8956.5,8605.5,6132.5,2500,750]
["11.5.1.3","Total connections","no",20987,22017,23060.5,23965.5,25545.5]
[]
["11.5.2","Total sales"]
["11.5.2.1","Total metered water billed","m3/year",2570530.4299999997,2886425.7075,3609257.7800000003,4474391.3425000003,5110264.7675000001]
["11.5.2.2","Total un-metered water billed","m3/year",2458497,2074400.1187499999,1796580.4125000001,720000,216000]
["11.5.2.3","Total water billed","m3/year",5029027.43,4960825.8262499999,5405838.1925000008,5194391.3425000003,5326264.7675000001]
[]
["11.5.3","Seasonal peak demand"]
["11.5.3.1","Seasonal peak factor (peak month sales / average monthly sales)","Factor",1.2,1.2,1.2,1.2,1.2]
["11.5.3.2","Peak daily sales","m3/day",16533.788810958904,16309.564360273971,17772.618715068496,17077.450989041095,17511.007454794519]

{"sheet":"12 - W production & NRW","index":3,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,"K.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[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",8470550,8470550,12240550,16010550,19780550,"Ketu eshte perfshire uji i paturuar per pjesen verior vetem per nevoja te llogaritjes se kerkesave per faturim"]
["12.1.1.2","Estimated volume of leakages","m3/year",4670550,4670550,4670550,4670550,4640550]
["12.1.1.3","Total NRW in year","m3/year",13141100,13141100,16911100,20681100,24421100]
["12.1.1.4","NRW per connection per day","l/con/day)",1715.4911944837345,1635.2370304142316,2009.1403404920884,2364.2547806307184,2619.1353971412277]
["12.1.1.5","NRW as percentage of production","%",0.72322552775844784,0.72595038374004395,0.75776971975856755,0.79925438811017624,0.82095003005714573]
[]
[12.2,"Production requirement"]
[]
["12.2.1","Production requirement"]
["12.2.1.1","Water sales","m3/year",5029027.43,4960825.8262499999,5405838.1925000008,5194391.3425000003,5326264.7675000001]
["12.2.1.2","Total NRW","m3/year",13141100,13141100,16911100,20681100,24421100]
["12.2.1.3","Total average production requirement","m3/year",18170127.43,18101925.826250002,22316938.192500003,25875491.342500001,29747364.767499998]
["12.2.1.4","Peak production requirement","m3/day",52536.802509589041,52312.57805890411,64104.399536986311,73737.998934246571,84418.130742465757]
[]
[12.3,"Production capacity"]
[]
["12.3.1","Production capacity"]
["12.3.1.1","Average annual production capacity","m3/year",17667162,17800000,17960000,18640000,19540000]
["12.3.1.2","Maximum production capacity","m3/day",44928,44928,44928,86400,116640]
["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",44928,44928,44928,86400,116640]
["12.3.1.5","Is production capacity sufficient for average conditions","yes/no (P=Yes, J=No)","J","J","J","J","J"]
["12.3.1.6","Is production capacity sufficient for peak conditions","yes/no (P=Yes, J=No)","J","J","J","P","P"]
["12.3.1.7","Is production capacity sufficient (adjust production requirement to suit)","yes/no (P=Yes, J=No)","J","J","J","0","0"]
[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.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[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",7180,7750,11150,13950,16250]
["13.1.1.2","Metered households with wastewater service at end of year","No",7750,11150,13950,16250,17250]
["13.1.1.3","Un-metered households with wastewater service at start of year","No",6650,6400,4000,2000,500]
["13.1.1.4","Un-metered households with wastewater service at end of year","No",6400,4000,2000,500,0]
["13.1.1.5","Total households with wastewater service at start of year","No",13830,14150,15150,15950,16750]
["13.1.1.6","Total households with wastewater service at end of year","No",14150,15150,15950,16750,17250]
["13.1.1.7","Average metered households served with wastewater service in year","No",7465,9450,12550,15100,16750]
["13.1.1.8","Average un-metered households served with wastewater service in year","No",6525,5200,3000,1250,250]
["13.1.1.9","Average total households served in year","No",13990,14650,15550,16350,17000]
["13.1.1.10","New household connections in year","No",320,1000,800,800,500]
["13.1.1.11","Service coverage with wastewater connections","%",0.43046153846153845,0.44801223241590216,0.46978851963746221,0.4880597014925373,0.50147492625368728]
[]
["13.1.2","Household sales from those with wastewater service"]
["13.1.2.1","Metered water billed with wastewater connections","m3/year",1433280,1814400,2409600,2899200,3216000]
["13.1.2.2","Un-metered water billed with wastewater connections","m3/year",1859625,1248000,864000,360000,72000]
["13.1.2.3","Total household water billed with wastewater connections","m3/year",3292905,3062400,3273600,3259200,3288000]
[]
["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,800,800]
["13.1.3.2","Total households with wastewater collection and treatment service at end of year","No",0,0,800,800,800]
["13.1.3.3","Average households served with wastewater collection and treatment service in year","No",0,0,400,800,800]
["13.1.3.4","Service coverage with wastewater collection and treatment","%",0,0,1.2084592145015106E-2,2.3880597014925373E-2,2.359882005899705E-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",1220,1324,1645,1995,2095]
["13.2.1.2","Metered commercial with wastewater service at end of year","No",1324,1645,1995,2095,2195]
["13.2.1.3","Un-metered commercial with wastewater service at start of year","No",465,471,250,0,0]
["13.2.1.4","un-metered commercial with wastewater service at end of year","No",471,250,0,0,0]
["13.2.1.5","Total commercial with wastewater service at start of year","No",1685,1795,1895,1995,2095]
["13.2.1.6","Total commercial with wastewater service at end of year","No",1795,1895,1995,2095,2195]
["13.2.1.7","Average metered commercial served with wastewater service in year","No",1272,1484.5,1820,2045,2145]
["13.2.1.8","Average un-metered commercial served with wastewater service in year","No",468,360.5,125,0,0]
["13.2.1.9","Average total commercial served in year","No",1740,1845,1945,2045,2145]
["13.2.1.10","New commercial connections in year","No",110,100,100,100,100]
[]
["13.2.2","Commercial water sales from those with wastewater services"]
["13.2.2.1","Metered water billed with wastewater connections","m3/year",109392,127667,156520,175870,184470]
["13.2.2.2","Un-metered water billed with wastewater connections","m3/year",40248,46504.5,32250,0,0]
["13.2.2.3","Total commercial water billed with wastewater connections","m3/year",149640,174171.5,188770,175870,184470]
[]
["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,160,165]
["13.2.3.2","Total commercial with wastewater treatment service at end of year","No",0,0,160,165,170]
["13.2.3.3","Average commercial served with wastewater treatment service in year","No",0,0,80,162.5,167.5]
[]
[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",275,281,373,398,403]
["13.3.1.2","Metered institutional with wastewater service at end of year","No",281,373,398,403,408]
["13.3.1.3","Un-metered institutional with wastewater service at start of year","No",29,30,15,0,0]
["13.3.1.4","un-metered institutional with wastewater service at end of year","No",30,15,0,0,0]
["13.3.1.5","Total institutional with wastewater service at start of year","No",304,311,388,398,403]
["13.3.1.6","Total institutional with wastewater service at end of year","No",311,388,398,403,408]
["13.3.1.7","Average metered institutional served with wastewater service in year","No",278,327,385.5,400.5,405.5]
["13.3.1.8","Average un-metered institutional served with wastewater service in year","No",29.5,22.5,7.5,0,0]
["13.3.1.9","Average total institutional served in year","No",307.5,349.5,393,400.5,405.5]
["13.3.1.10","New institutional connections in year","No",7,77,10,5,5]
[]
["13.3.2","Institutional water sales from those with wastewater service"]
["13.3.2.1","Metered water billed with wastewater connections","m3/year",448882.43,528001.995,622461.0675,646681.34250000003,654754.76749999996]
["13.3.2.2","Un-metered water billed with wastewater connections","m3/year",7434,54495.618749999994,36330.412499999999,0,0]
["13.3.2.3","Total institutional water billed with wastewater connections","m3/year",456316.43,582497.61375000002,658791.48,646681.34250000003,654754.76749999996]
[]
["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,24,25]
["13.3.3.2","Total institutional with wastewater treatment service at end of year","No",0,0,24,25,26]
["13.3.3.3","Average institutional served with wastewater treatment service in year","No",0,0,12,24.5,25.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",1550,1811.5,2205.5,2445.5,2550.5]
["13.4.1.2","Average un-metered non-household with wastewater connections","No",497.5,383,132.5,0,0]
["13.4.1.3","Average total non-household with wastewater connections","No",2047.5,2194.5,2338,2445.5,2550.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",558274.42999999993,655668.995,778981.0675,822551.34250000003,839224.76749999996]
["13.4.2.2","Total non-household un-metered water billed from those with wastewater service","m3/year",47682,101000.11874999999,68580.412500000006,0,0]
["13.4.2.3","Total non-household water billed from those with wastewater service","m3/year",275,281,385,422.5,428.5]
[]
["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,92,187,193]
[]
[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",9015,11261.5,14755.5,17545.5,19300.5]
["13.5.1.2","Total un-metered connections with wastewater collection services","No",7022.5,5583,3132.5,1250,250]
["13.5.1.3","Total connections","no",16037.5,16844.5,17888,18795.5,19550.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",1991554.43,2470068.9950000001,3188581.0674999999,3721751.3425000003,4055224.7675000001]
["13.5.2.2","Total un-metered water billed from those with wastewater service","m3/year",1907307,1349000.1187499999,932580.41249999998,360000,72000]
["13.5.2.3","Total water billed from those with wastewater service","m3/year",3898861.4299999997,3819069.11375,4121161.48,4081751.3425000003,4127224.7675000001]
[]
["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,492,987,993]

{"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.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[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",241250,241250,290127,290127,290127]
["21.1.1.2","Energy costs","EUR/year",243966.79,246894,246894,246894,360000]
["21.1.1.3","Fuel costs","EUR/year",2286,2355,2355,2355,3648]
["21.1.1.4","Staff costs","EUR/year",178096,187008,150633,150633,150633]
["21.1.1.5","Materials and consumables","EUR/year",1587.45,1637,1637,1637,1877]
["21.1.1.6","Contracted services","EUR/year",11175,11287,11287,11287,11287]
["21.1.1.7","Maintenance and repair","EUR/year",2392.94,2513,2513,2513,3000]
["21.1.1.8","Other direct costs","EUR/year",67556.639999999999,68233,68233,68233,68233]
["21.1.1.9","Total water resources and treatment costs","EUR/year",748310.82,761177,773679,773679,888805]
[]
["21.1.2","Water Distribution"]
["21.1.2.1","Service charges","EUR/year"]
["21.1.2.2","Energy costs","EUR/year",75249,75249,75249,75249,81969]
["21.1.2.3","Fuel costs","EUR/year",27653,28207,28207,28207,31730]
["21.1.2.4","Staff costs","EUR/year",255393,268163,268163,268163,310430]
["21.1.2.5","Materials and consumables","EUR/year",12101.44,12225,12225,12225,13480," "]
["21.1.2.6","Contracted services","EUR/year",65113,5400,5400,5400,5400]
["21.1.2.7","Maintenance and repair","EUR/year",4900.38,4998,4998,5410,5840]
["21.1.2.8","Other direct costs","EUR/year",19827,15150,15150,15150,15150]
["21.1.2.9","Total water distribution costs","EUR/year",460236.82,409392,409392,409804,463999]
[]
[21.2,"Indirect costs"]
[]
["21.2.1","Business activities"]
["21.2.1.1","Energy costs","EUR/year",13963.7,14522.248000000001,14522.248000000001,14522.248000000001,14522.248000000001]
["21.2.1.2","Fuel costs","EUR/year",6673.06,6939.9824000000008,6939.9824000000008,6939.9824000000008,6939.9824000000008]
["21.2.1.3","Staff costs","EUR/year",474242.22,493211.90879999998,389631.90879999998,389631.90879999998,389631.90879999998]
["21.2.1.4","Materials and consumables","EUR/year",3722.4,3871.2960000000003,3871.2960000000003,3871.2960000000003,3871.2960000000003]
["21.2.1.5","Contracted services","EUR/year",27084.22,28167.588800000001,28167.588800000001,28167.588800000001,28167.588800000001]
["21.2.1.6","Maintenance and repair","EUR/year",1628.08,1693.2031999999999,1693.2031999999999,1693.2031999999999,1693.2031999999999]
["21.2.1.7","Other indirect costs","EUR/year",9784.4599999999991,10175.838400000001,10175.838400000001,10175.838400000001,10175.838400000001]
["21.2.1.8","Total business activities costs","EUR/year",537098.1399999999,558582.06559999997,455002.06559999997,455002.06559999997,455002.06559999997]
[]
["21.2.2","Total operating costs excl bad debts"]
["21.2.2.1","Total","EUR/year",1745645.7799999998,1729151.0655999999,1638073.0655999999,1638485.0655999999,1807806.0655999999]

{"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.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[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",6264,6390,6390,6390,6390]
["22.1.1.4","Staff costs","EUR/year",47013,49364,47440,47440,47440]
["22.1.1.5","Materials and consumables","EUR/year",539.53,567,567,567,567]
["22.1.1.6","Contracted services","EUR/year",13168.98,6584.5,0,0,0]
["22.1.1.7","Maintenance and repair","EUR/year",517.82000000000005,1000,1500,2000,2500]
["22.1.1.8","Other direct costs","EUR/year",1579.72,1612,1612,1612,1612]
["22.1.1.9","Total wastewater collection costs ","EUR/year",69083.05,65517.5,57509,58009,58509]
[]
["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,36000,36000,36000]
["22.1.2.3","Fuel costs","EUR/year",0,800,2000,2000,2000]
["22.1.2.4","Staff costs","EUR/year",0,12500,36000,36000,36000]
["22.1.2.5","Materials and consumables","EUR/year",0,500,1500,1500,1500]
["22.1.2.6","Contracted services","EUR/year",0,0,0,0,0]
["22.1.2.7","Maintenance and repair","EUR/year",0,0,2000,2000,2000]
["22.1.2.8","Other direct costs","EUR/year",0,0,7000,7000,7000]
["22.1.2.9","Total Wastewater treatment costs","EUR/year",0,13800,84500,84500,84500]
[]
["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",891.3,926.952,926.952,926.952,926.952]
["22.2.1.2","Fuel costs","EUR/year",425.94,442.9776,442.9776,442.9776,442.9776]
["22.2.1.3","Staff costs","EUR/year",30270.78,31481.611199999999,16446.611199999999,16446.611199999999,16446.611199999999]
["22.2.1.4","Materials and consumables","EUR/year",237.6,247.10400000000001,247.10400000000001,247.10400000000001,247.10400000000001]
["22.2.1.5","Contracted services","EUR/year",1728.78,1797.9312,1797.9312,1797.9312,1797.9312]
["22.2.1.6","Maintenance and repair","EUR/year",103.92,108.07680000000001,108.07680000000001,108.07680000000001,108.07680000000001]
["22.2.1.7","Other indirect costs","EUR/year",624.54,649.52160000000003,649.52160000000003,649.52160000000003,649.52160000000003]
["22.2.1.8","Total business activities costs","EUR/year",34282.86,35654.174400000004,20619.174399999996,20619.174399999996,20619.174399999996]
[]
["22.2.2","Total operating costs excl bad debts"]
["22.2.2.1","Total","EUR/year",103365.91,114971.6744,162628.17439999999,163128.17439999999,163628.17439999999]

{"sheet":"31- W inf renewals","index":7,"n_rows":54,"n_cols":48,"rows_kept":54,"cut":false,"hidden":false,"merged":[[6,3,6,11],[7,3,7,11],[8,3,8,11],[6,21,6,29],[7,21,7,29],[8,21,8,29],[9,42,9,47],[9,39,9,41],[9,33,9,38],[9,30,9,32],[6,12,6,20],[7,12,7,20],[8,12,8,20],[6,39,6,47],[8,39,8,47],[7,39,7,47],[6,30,6,38],[8,30,8,38],[7,30,7,38],[9,6,9,11],[9,3,9,5],[9,24,9,29],[9,21,9,23],[9,15,9,20],[9,12,9,14]]}
[null,"K.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[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,1,null,1,null,null,null,null,0,1,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,1,0,1,0,0,0,0,0,1,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","Nderrimi i gypit ne rrugen Ukshin Kovacica","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,750000,null,750000,750000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.2","Nderrimi i gypit ne fshatin Reke","EUR/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]
["31.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]
["31.2.1.4","Nderrimi i rrjetit në rrugën Sami Gashi","EUR/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]
["31.2.1.5","Nderrimi i gypit Ternavcë -Klinë dhe Klinë -Skenderaj","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,338858,null,null,null,338858,338858,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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,null,null,0,null,null,null,null,0,0,0,null,0,null,null,null,null,0,0,0,null,0,null,null,null,null,0,0]
["31.2.1.21","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,338858,0,0,0,338858,338858,0,0,0,0,0,1800000,0,1800000,1800000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[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,1,0,1,0,0,0,0,0,1,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,338858,0,0,0,338858,338858,0,0,0,0,0,1800000,0,1800000,1800000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["31.3.1.3","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,338858,0,0,0,338858,338858,1,0,1,0,0,1800000,0,1800000,1800001,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"32 - W inf enhancement","index":8,"n_rows":84,"n_cols":48,"rows_kept":84,"cut":false,"hidden":false,"merged":[[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],[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],[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]]}
[null,"K.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[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","Ndertimi i fabrikes se re per trajtimin e ujit e pijeshem ne Shipol te Mitrovices","EUR/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]
["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,700000,0,700000,700000,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 raportuar nga ZRRUM","EUR/year",82,null,82,null,null,null,null,0,82,null,null,0,null,null,null,null,0,0,null,null,0,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",82,0,82,0,0,0,0,0,82,0,0,0,0,0,0,0,0,0,0,0,0,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","Rrjeti i ri prej Fabrikes -Pantinë ","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,95000,null,null,null,95000,95000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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,0,0,0,0,0,0,0,0,0,0,0,0,95000,0,0,0,95000,95000,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 raportuar nga ZRRUM","EUR/year",1565,null,1565,null,null,null,null,0,1565,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.11",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.12",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.13",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.14",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.15",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.16",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.17",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.18",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.19",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.20",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.2.21","Totals","EUR/year",1565,0,1565,0,0,0,0,0,1565,0,0,0,0,0,0,0,0,0,0,0,0,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.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,700000,0,700000,700000,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",82,0,82,0,0,0,0,0,82,0,0,0,0,0,0,0,0,0,0,0,0,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",82,0,82,0,0,0,0,0,82,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]
["32.3.1.4","Water distribution - level of service","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,95000,0,0,0,95000,95000,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",1565,0,1565,0,0,0,0,0,1565,0,0,0,0,0,0,0,0,0,0,0,0,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.6","Total water distribution","EUR/year",1565,0,1565,0,0,0,0,0,1565,0,0,0,0,0,0,0,0,0,0,0,0,95000,0,0,0,95000,95000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["32.3.1.7","Totals","EUR/year",1647,0,1647,0,0,0,0,0,1647,0,0,0,0,0,0,0,0,0,0,0,0,95000,0,700000,0,795000,795000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"33 - W non-inf cap maint","index":9,"n_rows":44,"n_cols":48,"rows_kept":44,"cut":false,"hidden":false,"merged":[[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],[9,3,9,5],[9,6,9,11],[9,12,9,14],[9,15,9,20],[8,30,8,38],[9,21,9,23],[9,24,9,29],[9,30,9,32],[9,33,9,38]]}
[null,"K.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[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","Stacioni i pompimit","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,105690,null,null,null,105690,105690,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.2.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.2.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.2.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.2.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.2.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.2.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.2.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.2.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.2.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["33.2.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,105690,0,0,0,105690,105690,0,0,0,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.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,105690,0,0,0,105690,105690,0,0,0,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.3","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,105690,0,0,0,105690,105690,0,0,0,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":"34 - W non-inf enhancement","index":10,"n_rows":88,"n_cols":48,"rows_kept":88,"cut":false,"hidden":false,"merged":[[6,3,6,11],[6,12,6,20],[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],[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,21,6,29],[9,42,9,47],[9,21,9,23],[9,24,9,29],[9,30,9,32],[9,33,9,38],[6,30,6,38],[6,39,6,47],[8,39,8,47]]}
[null,"K.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[null,"2011-12-13"]
[]
[34,"Water supply non-infrastructure enhancement"]
[null,"Note: Report 2010 and 2011 costs as actuals / budget but 2012 to 2014 at base year (mid-2011) price levels"]
[null,null,null,"Historical",null,null,null,null,null,null,null,null,"Base year",null,null,null,null,null,null,null,null,"Year 1",null,null,null,null,null,null,null,null,"Year 2",null,null,null,null,null,null,null,null,"Year 3"]
[null,null,null,"(Actual)",null,null,null,null,null,null,null,null,"(budget forecast)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)"]
[null,null,null,2010,null,null,null,null,null,null,null,null,2011,null,null,null,null,null,null,null,null,2012,null,null,null,null,null,null,null,null,2013,null,null,null,null,null,null,null,null,2014]
[null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed"]
[null,null,"Unit","RWC cash reserve","Loans to RWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed"]
[34.1,"Water resources and treatment"]
["34.1.1","Quality improvement, expenditure and sources of finance"]
["34.1.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["34.1.2","Level of service improvement (including backlog infrastructure renewals), expenditure and sources of finance"]
["34.1.2.1","Ndertimi i fabrikes se re per trajtimin e ujit e pijeshem ne Shipol te Mitrovices","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,8300000,null,8300000,8300000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.2","Ndertimi i fabrikes se re per trajtimin e ujit e pijeshem ne Vushtrri","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,9000000,null,9000000,9000000,null,null,0,null,null,null,null,0,0]
["34.1.2.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,8300000,0,8300000,8300000,0,0,0,0,0,9000000,0,9000000,9000000,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 raportuar nga ZRRUM","EUR/year",8012,null,8012,null,null,null,null,0,8012,null,null,0,null,null,null,null,0,0,null,null,0,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",8012,0,8012,0,0,0,0,0,8012,0,0,0,0,0,0,0,0,0,0,0,0,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","Stacioni i pompimit","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,70460,null,null,null,70460,70460,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.2","Hartimi i projekteve dhe dizajneve","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,6364,null,null,null,6364,6364,null,null,0,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","Vendosja e Ujëmatësave","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,340000,null,null,null,340000,340000,null,null,0,null,null,null,null,0,0]
["34.2.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,76824,0,0,0,76824,76824,0,0,0,0,0,0,0,0,0,0,0,0,340000,0,0,0,340000,340000,0,0,0,0,0,0,0,0,0]
[]
["34.2.2","Supply demand balance, expenditure and sources of finance"]
["34.2.2.1","Sic eshte raportuar nga ZRRUM","EUR/year",943,null,943,null,null,null,null,0,943,null,null,0,null,null,null,null,0,0,null,null,0,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",943,0,943,0,0,0,0,0,943,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[34.299999999999997,"Total water supply non-infrastructure enhancement"]
["34.3.1","Infrastructure enhancement expenditure and sources of finance"]
["34.3.1.1","Water resources and treatment - quality improvments","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["34.3.1.2","Water resources and treatment - level of service improvements","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,8300000,0,8300000,8300000,0,0,0,0,0,9000000,0,9000000,9000000,0,0,0,0,0,0,0,0,0]
["34.3.1.3","Water resources and treatment  - supply demand balance","EUR/year",8012,0,8012,0,0,0,0,0,8012,0,0,0,0,0,0,0,0,0,0,0,0,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",8012,0,8012,0,0,0,0,0,8012,0,0,0,0,0,0,0,0,0,0,0,0,0,0,8300000,0,8300000,8300000,0,0,0,0,0,9000000,0,9000000,9000000,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,0,0,0,76824,0,0,0,76824,76824,0,0,0,0,0,0,0,0,0,0,0,0,340000,0,0,0,340000,340000,0,0,0,0,0,0,0,0,0]
["34.3.1.6","Water distribution  - supply demand balance","EUR/year",943,0,943,0,0,0,0,0,943,0,0,0,0,0,0,0,0,0,0,0,0,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",943,0,943,0,0,0,0,0,943,0,0,0,76824,0,0,0,76824,76824,0,0,0,0,0,0,0,0,0,0,0,0,340000,0,0,0,340000,340000,0,0,0,0,0,0,0,0,0]
["34.3.1.8","Totals","EUR/year",8955,0,8955,0,0,0,0,0,8955,0,0,0,76824,0,0,0,76824,76824,0,0,0,0,0,8300000,0,8300000,8300000,0,0,0,340000,0,9000000,0,9340000,9340000,0,0,0,0,0,0,0,0,0]

{"sheet":"35 - W business activities","index":11,"n_rows":24,"n_cols":48,"rows_kept":24,"cut":false,"hidden":false,"merged":[[6,3,6,11],[6,12,6,20],[6,21,6,29],[6,30,6,38],[9,15,9,20],[8,3,8,11],[8,12,8,20],[8,21,8,29],[8,30,8,38],[8,39,8,47],[6,39,6,47],[9,39,9,41],[9,42,9,47],[7,3,7,11],[7,12,7,20],[7,21,7,29],[7,30,7,38],[7,39,7,47],[9,21,9,23],[9,24,9,29],[9,30,9,32],[9,33,9,38],[9,3,9,5],[9,6,9,11],[9,12,9,14]]}
[null,"K.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[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 raportuar nga ZRRUM","EUR/year",471,null,471,null,null,null,null,0,471,null,null,0,null,null,null,null,0,0,null,null,0,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","Renovimi i zyreve në Skenderaj","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,3741.2,null,null,null,3741.2,3741.2,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["35.1.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["35.1.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["35.1.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["35.1.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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",471,0,471,0,0,0,0,0,471,0,0,0,3741.2,0,0,0,3741.2,3741.2,0,0,0,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":"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,42,9,47],[6,21,6,29],[6,30,6,38],[9,39,9,41],[7,39,7,47],[9,21,9,23],[9,24,9,29],[9,3,9,5],[9,6,9,11],[9,12,9,14],[6,39,6,47],[7,21,7,29],[9,15,9,20],[7,3,7,11],[7,12,7,20],[6,3,6,11],[6,12,6,20],[8,3,8,11],[8,12,8,20],[8,21,8,29],[8,30,8,38],[8,39,8,47],[7,30,7,38]]}
[null,"K.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[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",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.1.1.2","Rruga e clirimit deri te Mahalla e Romëve","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,82000,null,null,null,82000,82000]
["41.1.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.1.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,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,136100.28083533567,null,136100.28083533567,null,null,null,null,0,136100.28083533567,136100.28083533567,null,136100.28083533567,null,null,null,null,0,136100.28083533567,136100.28083533567,null,136100.28083533567,null,null,null,null,0,136100.28083533567]
["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,136100.28083533567,0,136100.28083533567,0,0,0,0,0,136100.28083533567,136100.28083533567,0,136100.28083533567,0,0,0,0,0,136100.28083533567,136100.28083533567,0,136100.28083533567,82000,0,0,0,82000,218100.28083533567]
[]
[41.2,"Wastewater treatment"]
["41.2.1","Infrastructure renewals expenditure and sources of finance"]
["41.2.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.2.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.2.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.2.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.2.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.2.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.2.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.2.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.2.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.2.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.2.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[41.3,"Sludge treatment and disposal"]
["41.3.1","Infrastructure renewals expenditure and sources of finance"]
["41.3.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.3.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.3.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.3.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.3.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.3.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.3.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.3.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.3.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.3.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["41.3.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[41.4,"Total wastewater services infrastructure renewals"]
["41.4.1","Infrastructure renewals expenditure and sources of finance"]
["41.4.1.1","Wastewater collection","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,136100.28083533567,0,136100.28083533567,0,0,0,0,0,136100.28083533567,136100.28083533567,0,136100.28083533567,0,0,0,0,0,136100.28083533567,136100.28083533567,0,136100.28083533567,82000,0,0,0,82000,218100.28083533567]
["41.4.1.2","Wastewater treatment","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["41.4.1.3","Sludge treatment and disposal","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["41.4.1.4","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,136100.28083533567,0,136100.28083533567,0,0,0,0,0,136100.28083533567,136100.28083533567,0,136100.28083533567,0,0,0,0,0,136100.28083533567,136100.28083533567,0,136100.28083533567,82000,0,0,0,82000,218100.28083533567]

{"sheet":"42- WW inf enhancement","index":13,"n_rows":132,"n_cols":48,"rows_kept":132,"cut":false,"hidden":false,"merged":[[6,39,6,47],[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],[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],[9,33,9,38],[9,39,9,41],[9,42,9,47]]}
[null,"K.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[null,"2011-12-13"]
[]
[42,"Wastewater services infrastructure enhancement"]
[null,"Note: Report 2010 and 2011 costs as actuals / budget but 2012 to 2014 at base year (mid-2011) price levels"]
[null,null,null,"Historical",null,null,null,null,null,null,null,null,"Base year",null,null,null,null,null,null,null,null,"Year 1",null,null,null,null,null,null,null,null,"Year 2",null,null,null,null,null,null,null,null,"Year 3"]
[null,null,null,"(Actual)",null,null,null,null,null,null,null,null,"(budget forecast)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)"]
[null,null,null,2010,null,null,null,null,null,null,null,null,2011,null,null,null,null,null,null,null,null,2012,null,null,null,null,null,null,null,null,2013,null,null,null,null,null,null,null,null,2014]
[null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed"]
[null,null,"Unit","RWC cash reserve","Loans to RWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed"]
[42.1,"Wastewater Collection"]
["42.1.1","Level of service improvement (including backlog infrastructure renewals), expenditure and sources of finance"]
["42.1.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.1.10",null,"EUR/year"]
["42.1.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["42.1.2","Supply demand balance, expenditure and sources of finance"]
["42.1.2.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.2.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.2.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.2.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.2.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.2.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.2.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.2.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.2.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.2.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.1.2.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[42.2,"Wastewater treatment"]
["42.2.1","Quality impriovement, expenditure and sources of finance"]
["42.2.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["42.2.2","Level of service improvement (including backlog infrastructure renewals), expenditure and sources of finance"]
["42.2.2.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.2.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.2.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.2.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.2.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.2.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.2.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.2.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.2.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.2.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.2.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["42.2.3","Supply demand balance, expenditure and sources of finance"]
["42.2.3.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.3.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.3.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.3.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.3.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.3.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.3.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.3.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.3.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.3.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.2.3.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[42.3,"Sludge treatment and disposal"]
["42.3.1","Quality impriovement, expenditure and sources of finance"]
["42.3.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["42.3.2","Level of service improvement (including backlog infrastructure renewals), expenditure and sources of finance"]
["42.3.2.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.2.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.2.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.2.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.2.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.2.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.2.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.2.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.2.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.2.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.2.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["42.3.3","Supply demand balance, expenditure and sources of finance"]
["42.3.3.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.3.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.3.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.3.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.3.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.3.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.3.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.3.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.3.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.3.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["42.3.3.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[42.4,"Total wastewater infrastructure enhancement"]
["42.4.1","Infrastructure enhancement expenditure and sources of finance"]
["42.4.1.1","Wastewater Collection - level of service improvement","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.2","Wastewater Collection - supply demand balance","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.3","Total Wastewater Collection","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.4","Wastewater treatment - quality improvement","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.5","Wastewater treatment - level of service improvement","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.6","Wastewater treatment -  supply demand balance","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.7","Total Wastewater treatment","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.8","Sludge treatment and disposal - quality improvement","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.9","Sludge treatment and disposal - level of service improvement","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.10","Sludge treatment and disposal - supply demand balance","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.11","Total sludge treatment and disposal ","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["42.4.1.12","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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":"43 - WW non-inf cap maint","index":14,"n_rows":59,"n_cols":48,"rows_kept":59,"cut":false,"hidden":false,"merged":[[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],[9,30,9,32],[9,33,9,38],[9,39,9,41],[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,39,7,47],[7,30,7,38],[8,3,8,11],[8,12,8,20],[8,21,8,29],[8,30,8,38]]}
[null,"K.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[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","Ndertimi i garazhave në Skenderaj","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,9859,null,null,null,9859,9859,null,null,0,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,9859,0,0,0,9859,9859,0,0,0,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,9859,0,0,0,9859,9859,0,0,0,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,9859,0,0,0,9859,9859,0,0,0,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":[[6,3,6,11],[6,12,6,20],[6,21,6,29],[6,30,6,38],[7,3,7,11],[7,12,7,20],[7,21,7,29],[7,30,7,38],[7,39,7,47],[6,39,6,47],[9,24,9,29],[9,30,9,32],[9,33,9,38],[9,39,9,41],[9,42,9,47],[8,30,8,38],[8,39,8,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],[9,21,9,23]]}
[null,"K.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[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 raportuar nga ZRRUM","EUR/year",1102,null,1102,null,null,null,null,0,1102,null,null,0,null,null,null,null,0,0,null,null,0,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",1102,0,1102,0,0,0,0,0,1102,0,0,0,0,0,0,0,0,0,0,0,0,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","Sic eshte raportuar nga ZRRUM","EUR/year",882,null,882,null,null,null,null,0,882,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.3.2","Fabrika e 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,3500000,null,3500000,3500000,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",882,0,882,0,0,0,0,0,882,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3500000,0,3500000,3500000,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",1102,0,1102,0,0,0,0,0,1102,0,0,0,0,0,0,0,0,0,0,0,0,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",1102,0,1102,0,0,0,0,0,1102,0,0,0,0,0,0,0,0,0,0,0,0,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",882,0,882,0,0,0,0,0,882,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3500000,0,3500000,3500000,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",882,0,882,0,0,0,0,0,882,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3500000,0,3500000,3500000,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",1984,0,1984,0,0,0,0,0,1984,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3500000,0,3500000,3500000,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":[[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],[9,30,9,32],[9,33,9,38],[9,39,9,41],[6,39,6,47],[8,3,8,11],[8,12,8,20],[8,21,8,29],[8,30,8,38],[8,39,8,47],[7,3,7,11],[7,12,7,20],[7,21,7,29],[7,39,7,47],[7,30,7,38],[6,3,6,11],[6,12,6,20],[6,21,6,29],[6,30,6,38]]}
[null,"K.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[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 raportuar nga ZRRUM","EUR/year",220,null,220,null,null,null,null,0,220,null,null,0,null,null,null,null,0,0,null,null,0,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","Renovimi i zyreve në Skenderaj","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,238.79999999999998,null,null,null,238.79999999999998,238.79999999999998,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["45.1.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["45.1.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["45.1.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["45.1.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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",220,0,220,0,0,0,0,0,220,0,0,0,238.79999999999998,0,0,0,238.79999999999998,238.79999999999998,0,0,0,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":"51- W RAB","index":17,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[null,"K.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[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",172121,178165.25888787603,192687.50913982681,196807.16808523631,200422.51576296211]
["51.1.1.2","Indexation adjustment","EUR",5962.2588878760334,14522.250251950774,4119.6589454094974,3615.3476777257911,3298.9546094583561]
["51.1.1.3","Opening RAB at current year price levels","EUR",178083.25888787603,192687.50913982681,196807.16808523631,200422.51576296211,203721.47037242047]
["51.1.1.4","Additions (net of disposals and grants)","EUR",82,0,0,0,0]
["51.1.1.5","Closing RAB at current year price levels","EUR",178165.25888787603,192687.50913982681,196807.16808523631,200422.51576296211,203721.47037242047]
[]
["51.1.2","Non-infrastructure"]
["51.1.2.1","Opening RAB at prior year price levels","EUR",596896,607825.05008464644,638586.90220513032,633604.46474072523,626808.24222206918]
["51.1.2.2","Indexation adjustment","EUR",20676.433910665477,49543.819832399531,13652.987969145686,11639.314017287123,10317.263666975257]
["51.1.2.3","Opening RAB at current year price levels","EUR",617572.43391066545,657368.86991704593,652239.89017427596,645243.77875801234,637125.50588904449]
["51.1.2.4","Additions (net of disposals and grants)","EUR",8012,0,0,0,0]
["51.1.2.5","Depreciation","EUR",-17759.383826019013,-18781.967711915597,-18635.425433550743,-18435.536535943211,-18203.585882544128]
["51.1.2.6","Closing RAB at current year price levels","EUR",607825.05008464644,638586.90220513032,633604.46474072523,626808.24222206918,618921.92000650032]
["51.1.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-18245.340063003725,-17724.044632632187,-17217.643357414127]
[]
[51.2,"Water distribution"]
[]
["51.2.1","Infrastructure"]
["51.2.1.1","Opening RAB at prior year price levels","EUR",3270295,3385142.7803099365,3661065.7683329992,3739339.3544599586,3808031.0184013881]
["51.2.1.2","Indexation adjustment","EUR",113282.78030993634,275922.98802306294,78273.586126959519,68691.663941429448,62680.190562886841]
["51.2.1.3","Opening RAB at current year price levels","EUR",3383577.7803099365,3661065.7683329992,3739339.3544599586,3808031.0184013881,3870711.2089642747]
["51.2.1.4","Additions (net of disposals and grants)","EUR",1565,0,0,0,0]
["51.2.1.5","Closing RAB at current year price levels","EUR",3385142.7803099365,3661065.7683329992,3739339.3544599586,3808031.0184013881,3870711.2089642747]
[]
["51.2.2","Non-infrastructure"]
["51.2.2.1","Opening RAB at prior year price levels","EUR",70223,71509.176181794508,75128.235157161937,74542.063201255718,73742.503733626712]
["51.2.2.2","Indexation adjustment","EUR",2432.5195989061108,5828.7129505780704,1606.2416676601222,1369.3377010070676,1213.8016114554955]
["51.2.2.3","Opening RAB at current year price levels","EUR",72655.519598906118,77337.889132372584,76734.476824822064,75911.400902262787,74956.305345082204]
["51.2.2.4","Additions (net of disposals and grants)","EUR",943,0,0,0,0]
["51.2.2.5","Depreciation","EUR",-2089.3434171116032,-2209.6539752106451,-2192.4136235663445,-2168.8971686360796,-2141.608724145206]
["51.2.2.6","Closing RAB at current year price levels","EUR",71509.176181794508,75128.235157161937,74542.063201255718,73742.503733626712,72814.696620937]
["51.2.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-2146.5210044903411,-2085.1918329334744,-2025.6149234210895]
[]
[51.3,"Business activities"]
[]
["51.3.2","Non-infrastructure"]
["51.3.2.1","Opening RAB at prior year price levels","EUR",35112,35754.597773147543,37564.127750847176,37271.041693527142,36871.26185145331]
["51.3.2.2","Indexation adjustment","EUR",1216.2771194165923,2914.3572644892561,803.12105131311262,684.66903591009361,606.90097007492147]
["51.3.2.3","Opening RAB at current year price levels","EUR",36328.277119416591,38668.955037636799,38367.248802160291,37955.710729437233,37478.162821528233]
["51.3.2.4","Additions (net of disposals and grants)","EUR",471,0,0,0,0]
["51.3.2.5","Depreciation","EUR",-1044.6793462690455,-1104.8272867896228,-1096.2071086331512,-1084.448877983921,-1070.8046520436637]
["51.3.2.6","Closing RAB at current year price levels","EUR",35754.597773147543,37564.127750847176,37271.041693527142,36871.26185145331,36407.358169484571]
["51.3.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-1073.2607928813479,-1042.5961987990236,-1012.8077359761944]
[]
[51.4,"Summary"]
["51.4.1","Totals"]
["51.4.1.1","Opening RAB at prior year price levels","EUR",4144647,4278396.8632374015,4605032.5425859652,4681564.0921807038,4745875.5419714991]
["51.4.1.2","Indexation adjustment","EUR",143570.26982680053,348732.1283224806,98455.595760487937,86000.332373359517,78117.111420850866]
["51.4.1.3","Opening RAB at current year price levels","EUR",4288217.2698268006,4627128.9915598817,4703488.1383464532,4767564.4245540621,4823992.6533923512]
["51.4.1.4","Additions (net of disposals and grants)","EUR",11073,0,0,0,0]
["51.4.1.5","Depreciation","EUR",-20893.406589399659,-22096.448973915863,-21924.046165750242,-21688.882582563208,-21415.999258732998]
["51.4.1.6","Closing RAB at current year price levels","EUR",4278396.8632374015,4605032.5425859652,4681564.0921807038,4745875.5419714991,4802576.6541336179]
["51.4.1.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-21465.121860375413,-20851.832664364683,-20256.066016811412]

{"sheet":"52 - Water income","index":18,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[null,"K.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[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",227274,237840,248640,258240,275940]
["52.1.1.2","Volume charges","EUR",1238459.8800000001,1218034.7999999998,1502899.2000000002,1617580.8,1884556.8]
["52.1.1.3","Total household water tariff income","EUR",1465733.8800000001,1455874.7999999998,1751539.2000000002,1875820.8,2160496.7999999998]
[]
["52.1.2","Commercial"]
["52.1.2.1","Fixed monthly charges","EUR",62640,66420,70020,73620,77220]
["52.1.2.2","Volume charges","EUR",107740.8,127145.19499999999,137802.1,131902.5,138352.5]
["52.1.2.3","Total commercial water tariff income","EUR",170380.79999999999,193565.19500000001,207822.1,205522.5,215572.5]
[]
["52.1.3","Institutional"]
["52.1.3.1","Fixed monthly charges","EUR",11070,12672,14238,14418,14598]
["52.1.3.2","Volume charges","EUR",328547.8296,428170.05816250003,483864.580525,485011.00687500002,491066.07562499994]
["52.1.3.3","Total institutional water tariff income","EUR",339617.8296,440842.05816250003,498102.580525,499429.00687500002,505664.07562499994]
[]
["52.1.4","Total water tariff income"]
["52.1.4.1","Household","EUR",1465733.8800000001,1455874.7999999998,1751539.2000000002,1875820.8,2160496.7999999998]
["52.1.4.2","Commercial","EUR",170380.79999999999,193565.19500000001,207822.1,205522.5,215572.5]
["52.1.4.3","Institutional","EUR",339617.8296,440842.05816250003,498102.580525,499429.00687500002,505664.07562499994]
["52.1.4.3","Total water tariff income","EUR",1975732.5096000002,2090282.0531624998,2457463.8805250004,2580772.3068750002,2881733.3756249999]
[]
[52.2,"Connection fees"]
[]
["52.2.1","Connection fees"]
["52.2.1.1","Household","EUR",38050,30000,24000,24000,64500]
["52.2.1.2","Commercial","EUR",16500,9000,9000,9000,9000]
["52.2.1.3","Institutional","EUR",21,246,450,450,450]
["52.2.1.4","Total connection fee income","EUR",54571,39246,33450,33450,73950]
[]
[52.3,"Total income from customers"]
[]
["52.3.1","Total income from customers"]
["52.3.1.1","Tariff income","EUR",1975732.5096000002,2090282.0531624998,2457463.8805250004,2580772.3068750002,2881733.3756249999]
["52.3.1.2","Connection fees","EUR",54571,39246,33450,33450,73950]
["52.3.1.3","Total income from customers","EUR",2030303.5096000002,2129528.0531624998,2490913.8805250004,2614222.3068750002,2955683.3756249999]
[]
[52.4,"Cash collection"]
[]
["52.4.1","Cash collection by category (excluding connection fees), excluding VAT"]
["52.4.1.1","Household","EUR",644922.90720000002,655143.65999999992,858254.2080000001,956668.60800000001,1145063.304]
["52.4.1.2","Commercial","EUR",136304.63999999998,164530.41575000001,184961.66899999999,187025.47500000001,198326.7]
["52.4.1.3","Institutional","EUR",305656.04664000002,418799.955254375,483159.50310924998,494434.71680625004,505664.07562499994]
["52.4.1.4","Total cash collection","EUR",1086883.59384,1238474.0310043748,1526375.3801092501,1638128.7998062503,1849054.0796249998]
[]
[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",771288,820810.97280000011,800731.1399999999,893284.99200000009,919152.19200000004]
["52.4.1.2","Commercial","EUR",0,34076.160000000003,29034.779249999992,22860.431000000011,18497.024999999994]
["52.4.1.3","Institutional","EUR",0,33961.782959999982,22042.102908125031,14943.077415750013,4994.2900687499787]
["52.4.1.4","Total provision for write-off","EUR",771288,888848.91576000012,851808.02215812495,931088.50041575008,942643.50706874998]
[]
["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.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[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",1457831,1508330.15952598,1631274.1508289427,1666150.7921736655,1696757.9822258956]
["61.1.1.2","Indexation adjustment","EUR",50499.159525980009,122943.99130296263,34876.641344722797,30607.190052230235,27928.63638743824]
["61.1.1.3","Opening RAB at current year price levels","EUR",1508330.15952598,1631274.1508289427,1666150.7921736655,1696757.9822258956,1724686.6186133339]
["61.1.1.4","Additions (net of disposals and grants)","EUR",0,0,0,0,0]
["61.1.1.5","Closing RAB at current year price levels","EUR",1508330.15952598,1631274.1508289427,1666150.7921736655,1696757.9822258956,1724686.6186133339]
[]
["61.1.2","Non-infrastrucutre"]
["61.1.2.1","Opening RAB at prior year price levels","EUR",1945,3041.1353822112255,3195.0463750091121,3170.1177103208984,3136.1141220120794]
["61.1.2.2","Indexation adjustment","EUR",67.374658158614494,247.882945004037,68.310091497694813,58.235062338594908,51.620438448318822]
["61.1.2.3","Opening RAB at current year price levels","EUR",2012.3746581586145,3289.0183272152626,3263.356466506807,3228.3527726594934,3187.7345604603984]
["61.1.2.4","Additions (net of disposals and grants)","EUR",1102,0,0,0,0]
["61.1.2.5","Depreciation","EUR",-73.23927594738899,-93.971952206150362,-93.23875618590877,-92.238650647414104,-91.07813029886853]
["61.1.2.6","Closing RAB at current year price levels","EUR",3041.1353822112255,3195.0463750091121,3170.1177103208984,3136.1141220120794,3096.6564301615299]
["61.1.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-91.287039285974643,-88.678838163518222,-86.145157073131998]
[]
[61.2,"Wastewater treatment"]
[]
["61.2.1","Infrastructure"]
["61.2.1.1","Opening RAB at prior year price levels","EUR",76728,79385.852324521431,85856.593147493171,87692.207108986579,89303.11295357866]
["61.2.1.2","Indexation adjustment","EUR",2657.8523245214255,6470.7408229717421,1835.6139614934041,1610.9058445920834,1469.9292392159045]
["61.2.1.3","Opening RAB at current year price levels","EUR",79385.852324521431,85856.593147493171,87692.207108986579,89303.11295357866,90773.042192794572]
["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",79385.852324521431,85856.593147493171,87692.207108986579,89303.11295357866,90773.042192794572]
[]
["61.2.2","Non-infrastrucutre"]
["61.2.2.1","Opening RAB at prior year price levels","EUR",1556,2433.3025914832665,2556.451340408923,2536.505176636384,2509.2978973960176]
["61.2.2.2","Indexation adjustment","EUR",53.899726526891591,198.33849423180104,54.656929657942776,46.595600094810379,41.303043391138445]
["61.2.2.3","Opening RAB at current year price levels","EUR",1609.8997265268915,2631.6410857150677,2611.1082700668658,2583.1007767311944,2550.6009407871561]
["61.2.2.4","Additions (net of disposals and grants)","EUR",882,0,0,0,0]
["61.2.2.5","Depreciation","EUR",-58.597135043625471,-75.189745306144786,-74.603093430481877,-73.802879335176982,-72.874312593918745]
["61.2.2.6","Closing RAB at current year price levels","EUR",2433.3025914832665,2556.451340408923,2536.505176636384,2509.2978973960176,2477.7266281932375]
["61.2.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-73.041466868826376,-70.954567815431332,-68.927294449276161]
[]
[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",389,607.83279072795938,638.59503460018982,633.61253368451503,626.81622461606253]
["61.4.2.2","Indexation adjustment","EUR",13.474931631722898,49.544450772235969,13.653161839752059,11.639462243784541,10.317395057180388]
["61.4.2.3","Opening RAB at current year price levels","EUR",402.47493163172288,657.3772415001954,652.24819643994192,645.25199592829961,637.13361967324295]
["61.4.2.4","Additions (net of disposals and grants)","EUR",220,0,0,0,0]
["61.4.2.5","Depreciation","EUR",-14.64214090376351,-18.782206900005583,-18.63566275542691,-18.435771312237133,-18.203817704949799]
["61.4.2.6","Closing RAB at current year price levels","EUR",607.83279072795938,638.59503460018982,633.61253368451503,626.81622461606253,618.92980196829319]
["61.4.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-18.245572417148281,-17.724270348086904,-17.217862623855851]
[]
[61.5,"Summary"]
["61.5.1","Totals"]
["61.5.1.1","Opening RAB at prior year price levels","EUR",1538449,1593798.282614924,1723520.8367264541,1760183.234703294,1792333.3234234983]
["61.5.1.2","Indexation adjustment","EUR",53291.761166818666,129910.49801594246,36848.87548921159,32334.566021499504,29501.806503550779]
["61.5.1.3","Opening RAB at current year price levels","EUR",1591740.7611668184,1723708.7806308663,1760369.7122156657,1792517.8007247932,1821835.1299270494]
["61.5.1.4","Additions (net of disposals and grants)","EUR",2204,0,0,0,0]
["61.5.1.5","Depreciation","EUR",-146.47855189477798,-187.94390441230072,-186.47751237181757,-184.47730129482824,-182.15626059773706]
["61.5.1.6","Closing RAB at current year price levels","EUR",1593798.282614924,1723520.8367264541,1760183.234703294,1792333.3234234983,1821652.9736664516]
["61.5.1.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-182.57407857194929,-177.35767632703647,-172.290314146264]

{"sheet":"62 - WW income","index":20,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,"K.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[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",164645.25,183744,261888,358512,493200]
["62.1.1.2","Commercial","EUR",19453.2,26125.724999999999,37754,47484.9,64564.499999999993]
["62.1.1.3","Institutional","EUR",59321.135900000001,87374.642062500003,131758.296,174603.96247500001,229164.16862499996]
["62.1.1.4","Total water tariff income","EUR",243419.58590000001,297244.36706249998,431400.29599999997,580600.86247500009,786928.66862499993]
[]
[62.2,"Connection fees"]
[]
["62.2.1","Connection fees"]
["62.2.1.1","Household","EUR",0,20000,16000,16000,10000]
["62.2.1.2","Commercial","EUR",0,6000,6000,6000,6000]
["62.2.1.3","Institutional","EUR",0,4620,600,300,300]
["62.2.1.4","Total connection fee income","EUR",0,30620,22600,22300,16300]
[]
[62.3,"Total income from customers"]
[]
["62.3.1","Total income from customers"]
["62.3.1.1","Tariff income","EUR",243419.58590000001,297244.36706249998,431400.29599999997,580600.86247500009,786928.66862499993]
["62.3.1.2","Connection fees","EUR",0,30620,22600,22300,16300]
["62.3.1.3","Total income from customers","EUR",243419.58590000001,327864.36706249998,454000.29599999997,602900.86247500009,803228.66862499993]
[]
[62.4,"Cash collection"]
[]
["62.4.1","Cash collection by category (excluding connection fees), excluding VAT"]
["62.4.1.1","Household","EUR",72443.91,82684.800000000003,128325.12,182841.12,261396]
["62.4.1.2","Commercial","EUR",15562.560000000001,22206.866249999999,33601.06,43211.259000000005,59399.34]
["62.4.1.3","Institutional","EUR",53389.02231,83005.909959375,127805.54712,172857.92285025,229164.16862499996]
["62.4.1.4","Total cash collection","EUR",141395.49231,187897.57620937499,289731.72712,398910.30185024999,549959.5086249999]
[]
[62.5,"Provisions for write off (offset by 12 months)"]
[]
["62.5.1","Write-off provisions (excluding VAT)"]
["62.5.1.1","Household","EUR",257096,92201.34,101059.2,133562.88,175670.88]
["62.5.1.2","Commercial","EUR",0,3890.6399999999994,3918.8587499999994,4152.9400000000023,4273.640999999996]
["62.5.1.3","Institutional","EUR",0,5932.1135900000008,4368.7321031250031,3952.7488799999992,1746.039624750003]
["62.5.1.4","Total provision for write-off","EUR",257096,102024.09359,109346.790853125,141668.56888000001,181690.56062475001]
[]
["62.5.2","VAT paid on bad debts"]
["62.5.2.1","VAT paid on bad debts","EUR",0,0,0,0,0]

{"sheet":"71 - W op subs","index":21,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[6,3,6,4],[6,5,6,7]]}
[null,"K.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[null,"2011-12-13"]
[]
[71,"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"]
["71.1.1","Subsidies"]
["71.1.1.1","Government subvention","EUR/year",384053,252000,385000,385000,385000]
["71.1.1.2",null,"EUR/year"]
["71.1.1.3",null,"EUR/year"]
["71.1.1.4",null,"EUR/year"]
["71.1.1.5",null,"EUR/year"]
["71.1.1.6",null,"EUR/year"]
["71.1.1.7",null,"EUR/year"]
["71.1.1.8",null,"EUR/year"]
["71.1.1.9",null,"EUR/year"]
["71.1.1.10",null,"EUR/year"]
["71.1.1.11","Total operating subsidies","EUR/year",384053,252000,385000,385000,385000]

{"sheet":"81- 2010 Inc-Exp ","index":22,"n_rows":64,"n_cols":11,"rows_kept":64,"cut":false,"hidden":false,"merged":[[6,3,6,5],[6,6,6,9]]}
[null,"K.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[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,1975732.5096000002,null,null,null,243419.58590000001,2219152.0955000003]
["81.1.1.2","Total operating subsidies","EUR",null,null,384053,null,null,null,null,384053]
["81.1.1.3","Total income excluding connection fees","EUR",null,null,2359785.5096000005,null,null,null,243419.58590000001,2603205.0955000003]
[]
[81.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["81.2.1.1","Service charges","EUR",241250,0,241250,0,0,0,0,241250]
["81.2.1.2","Energy costs","EUR",243966.79,75249,319215.79000000004,0,0,0,0,319215.79000000004]
["81.2.1.3","Fuel costs","EUR",2286,27653,29939,6264,0,0,6264,36203]
["81.2.1.4","Staff costs","EUR",178096,255393,433489,47013,0,0,47013,480502]
["81.2.1.5","Materials and consumables","EUR",1587.45,12101.44,13688.890000000001,539.53,0,0,539.53,14228.420000000002]
["81.2.1.6","Contracted services","EUR",11175,65113,76288,13168.98,0,0,13168.98,89456.98]
["81.2.1.7","Maintenance and repair","EUR",2392.94,4900.38,7293.32,517.82000000000005,0,0,517.82000000000005,7811.1399999999994]
["81.2.1.8","Other direct costs","EUR",67556.639999999999,19827,87383.64,1579.72,0,0,1579.72,88963.36]
["81.2.1.9","Total Direct costs","EUR",748310.82,460236.82,1208547.6399999999,69083.05,0,0,69083.05,1277630.69]
[]
[81.3,"Indirect costs"]
[]
["81.3.1.","Business activities"]
["81.3.1.1","Energy costs","EUR",null,null,13963.7,null,null,null,891.3,14855]
["81.3.1.2","Fuel costs","EUR",null,null,6673.06,null,null,null,425.94,7099]
["81.3.1.3","Staff costs","EUR",null,null,474242.22,null,null,null,30270.78,504513]
["81.3.1.4","Materials and consumables","EUR",null,null,3722.4,null,null,null,237.6,3960]
["81.3.1.5","Contracted services","EUR",null,null,27084.22,null,null,null,1728.78,28813]
["81.3.1.6","Maintenance and repair","EUR",null,null,1628.08,null,null,null,103.92,1732]
["81.3.1.7","Other indirect costs","EUR",null,null,9784.4599999999991,null,null,null,624.54,10409]
["81.3.1.8","Total Busiiness activities costs","EUR",null,null,537098.1399999999,null,null,null,34282.86,571380.99999999988]
[]
["81.3.2.","Other indirect costs"]
["81.3.2.1","Bad debts","EUR",null,null,771288,null,null,null,257096,1028384]
["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,771288,null,null,null,257096,1028384]
["81.3.2.4","Total all indirect costs","EUR",null,null,1308386.1399999999,null,null,null,291378.86,1599765]
["81.3.2.5","Total direct and indirect costs","EUR",null,null,2516933.7799999998,null,null,null,360461.91,2877395.69]
[]
[81.400000000000006,"Net Income before cap maintenance"]
[]
["81.4.1","Net income"]
["81.4.1.1.","Net income before capital maintenance","EUR",null,null,-157148.27039999934,null,null,null,-117042.32409999997,-274190.59449999966]
[]
[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",17759.383826019013,2089.3434171116032,19848.727243130616,73.23927594738899,58.597135043625471,0,131.83641099101447,19980.56365412163]
["81.5.1.3","Depreciation (business activities)","EUR",null,null,1044.6793462690455,null,null,null,146.47855189477798,1191.1578981638236]
["81.5.1.4","Total capital maintenance","EUR",17759.383826019013,2089.3434171116032,20893.406589399659,73.23927594738899,58.597135043625471,0,278.31496288579245,21171.721552285453]
[]
[81.599999999999994,"Net Income"]
[]
["81.6.1","Net income"]
["81.6.1.1","Net income before taxes and dividends","EUR",null,null,-178041.67698939901,null,null,null,-117320.63906288576,-295362.31605228514]

{"sheet":"82 - 2011 Inc-Exp","index":23,"n_rows":64,"n_cols":11,"rows_kept":64,"cut":false,"hidden":false,"merged":[[6,3,6,5],[6,6,6,9]]}
[null,"K.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[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,2090282.0531624998,null,null,null,297244.36706249998,2387526.420225]
["82.1.1.2","Total operating subsidies","EUR",null,null,252000,null,null,null,null,252000]
["82.1.1.3","Total income excluding connection fees","EUR",null,null,2342282.0531624998,null,null,null,297244.36706249998,2639526.420225]
[]
[82.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["82.2.1.1","Service charges","EUR",241250,0,241250,0,0,0,0,241250]
["82.2.1.2","Energy costs","EUR",246894,75249,322143,0,0,0,0,322143]
["82.2.1.3","Fuel costs","EUR",2355,28207,30562,6390,800,0,7190,37752]
["82.2.1.4","Staff costs","EUR",187008,268163,455171,49364,12500,0,61864,517035]
["82.2.1.5","Materials and consumables","EUR",1637,12225,13862,567,500,0,1067,14929]
["82.2.1.6","Contracted services","EUR",11287,5400,16687,6584.5,0,0,6584.5,23271.5]
["82.2.1.7","Maintenance and repair","EUR",2513,4998,7511,1000,0,0,1000,8511]
["82.2.1.8","Other direct costs","EUR",68233,15150,83383,1612,0,0,1612,84995]
["82.2.1.9","Total Direct costs","EUR",761177,409392,1170569,65517.5,13800,0,79317.5,1249886.5]
[]
[82.3,"Indirect costs"]
[]
["82.3.1.","Business activities"]
["82.3.1.1","Energy costs","EUR",null,null,14522.248000000001,null,null,null,926.952,15449.2]
["82.3.1.2","Fuel costs","EUR",null,null,6939.9824000000008,null,null,null,442.9776,7382.9600000000009]
["82.3.1.3","Staff costs","EUR",null,null,493211.90879999998,null,null,null,31481.611199999999,524693.52]
["82.3.1.4","Materials and consumables","EUR",null,null,3871.2960000000003,null,null,null,247.10400000000001,4118.4000000000005]
["82.3.1.5","Contracted services","EUR",null,null,28167.588800000001,null,null,null,1797.9312,29965.52]
["82.3.1.6","Maintenance and repair","EUR",null,null,1693.2031999999999,null,null,null,108.07680000000001,1801.28]
["82.3.1.7","Other indirect costs","EUR",null,null,10175.838400000001,null,null,null,649.52160000000003,10825.36]
["82.3.1.8","Total Busiiness activities costs","EUR",null,null,558582.06559999997,null,null,null,35654.174400000004,594236.24]
[]
["82.3.2.","Other indirect costs"]
["82.3.2.1","Bad debts","EUR",null,null,888848.91576000012,null,null,null,102024.09359,990873.00935000018]
["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,888848.91576000012,null,null,null,102024.09359,990873.00935000018]
["82.3.2.4","Total all indirect costs","EUR",null,null,1447430.9813600001,null,null,null,137678.26799000002,1585109.2493500002]
["82.3.2.5","Total direct and indirect costs","EUR",null,null,2617999.9813600001,null,null,null,216995.76799000002,2834995.7493500002]
[]
[82.4,"Net Income before cap maintenance"]
[]
["82.4.1","Net income"]
["82.4.1.1.","Net income before capital maintenance","EUR",null,null,-275717.9281975003,null,null,null,80248.599072499957,-195469.32912500016]
[]
[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",18781.967711915597,2209.6539752106451,20991.62168712624,93.971952206150362,75.189745306144786,0,169.16169751229515,21160.783384638537]
["82.5.1.3","Depreciation (business activities)","EUR",null,null,1104.8272867896228,null,null,null,187.94390441230072,1292.7711912019236]
["82.5.1.4","Total capital maintenance","EUR",18781.967711915597,2209.6539752106451,22096.448973915863,93.971952206150362,75.189745306144786,0,357.10560192459587,22453.554575840459]
[]
[82.6,"Net Income"]
[]
["82.6.1","Net income"]
["82.6.1.1","Net income before taxes and dividends","EUR",null,null,-297814.37717141618,null,null,null,79891.493470575355,-217922.88370084061]

{"sheet":"83 - 2012 Inc-Exp","index":24,"n_rows":64,"n_cols":11,"rows_kept":64,"cut":false,"hidden":false,"merged":[[6,3,6,5],[6,6,6,9]]}
[null,"K.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[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,2457463.8805250004,null,null,null,431400.29599999997,2888864.1765250005]
["83.1.1.2","Total operating subsidies","EUR",null,null,393231.3,null,null,null,null,393231.3]
["83.1.1.3","Total income excluding connection fees","EUR",null,null,2850695.1805250002,null,null,null,431400.29599999997,3282095.4765250003]
[]
[83.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["83.2.1.1","Service charges","EUR",296329.91525999998,0,296329.91525999998,0,0,0,0,296329.91525999998]
["83.2.1.2","Energy costs","EUR",252172.59371999998,76857.823619999996,329030.41733999999,0,36769.68,0,36769.68,365800.09733999998]
["83.2.1.3","Fuel costs","EUR",2405.3498999999997,28810.06566,31215.415560000001,6526.6181999999999,2042.76,0,8569.3781999999992,39784.79376]
["83.2.1.4","Staff costs","EUR",153853.53354,273896.32493999996,427749.85847999994,48454.267199999995,36769.68,0,85223.947199999995,512973.80567999993]
["83.2.1.5","Materials and consumables","EUR",1671.9990599999999,12486.370499999999,14158.369559999999,579.12245999999993,1532.07,0,2111.1924599999998,16269.562019999999]
["83.2.1.6","Contracted services","EUR",11528.316059999999,5515.4519999999993,17043.768059999999,0,0,0,0,17043.768059999999]
["83.2.1.7","Maintenance and repair","EUR",2566.7279399999998,5104.8572399999994,7671.5851799999991,1532.07,2042.76,0,3574.83,11246.41518]
["83.2.1.8","Other direct costs","EUR",69691.82153999999,15473.906999999999,85165.728539999982,1646.4645599999999,7149.66,0,8796.1245600000002,93961.853099999978]
["83.2.1.9","Total Direct costs","EUR",790220.2570199999,418144.80095999996,1208365.0579799998,58738.542419999991,86306.61,0,145045.15242,1353410.2103999997]
[]
[83.3,"Indirect costs"]
[]
["83.3.1.","Business activities"]
["83.3.1.1","Energy costs","EUR",null,null,14832.733662240002,null,null,null,946.77023376,15779.503896000002]
["83.3.1.2","Fuel costs","EUR",null,null,7088.3592237120001,null,null,null,452.44846108799999,7540.8076848000001]
["83.3.1.3","Staff costs","EUR",null,null,397962.23901014397,null,null,null,16798.239747455998,414760.47875759995]
["83.3.1.4","Materials and consumables","EUR",null,null,3954.0643084799999,null,null,null,252.38708352,4206.4513919999999]
["83.3.1.5","Contracted services","EUR",null,null,28769.811848543999,null,null,null,1836.3709690559999,30606.182817599998]
["83.3.1.6","Maintenance and repair","EUR",null,null,1729.4038844159998,null,null,null,110.387481984,1839.7913663999998]
["83.3.1.7","Other indirect costs","EUR",null,null,10393.397824992,null,null,null,663.40837180799997,11056.8061968]
["83.3.1.8","Total Busiiness activities costs","EUR",null,null,464730.00976252794,null,null,null,21060.012348671997,485790.02211119991]
[]
["83.3.2.","Other indirect costs"]
["83.3.2.1","Bad debts","EUR",null,null,851808.02215812495,null,null,null,109346.790853125,961154.81301124999]
["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,851808.02215812495,null,null,null,109346.790853125,961154.81301124999]
["83.3.2.4","Total all indirect costs","EUR",null,null,1316538.0319206528,null,null,null,130406.803201797,1446944.8351224498]
["83.3.2.5","Total direct and indirect costs","EUR",null,null,2524903.0899006529,null,null,null,275451.95562179701,2800355.0455224495]
[]
[83.4,"Net Income before cap maintenance"]
[]
["83.4.1","Net income"]
["83.4.1.1.","Net income before capital maintenance","EUR",null,null,325792.09062434733,null,null,null,155948.34037820296,481740.43100255076]
[]
[83.5,"Capital maintenance"]
[]
["83.5.1","Capital maintenance"]
["83.5.1.1","Infrastructure renewals","EUR",1.02138,0,1.02138,139010.10483959515,0,0,139010.10483959515,139011.12621959514]
["83.5.1.2","Depreciation (service activities)","EUR",18635.425433550743,2192.4136235663445,20827.839057117089,93.23875618590877,74.603093430481877,0,167.84184961639065,20995.68090673348]
["83.5.1.3","Depreciation (business activities)","EUR",null,null,1096.2071086331512,null,null,null,186.47751237181757,1282.6846210049687]
["83.5.1.4","Total capital maintenance","EUR",18636.446813550741,2192.4136235663445,21925.06754575024,139103.34359578107,74.603093430481877,0,139364.42420158334,161289.49174733358]
[]
[83.6,"Net Income"]
[]
["83.6.1","Net income"]
["83.6.1.1","Net income before taxes and dividends","EUR",null,null,303867.02307859709,null,null,null,16583.916176619619,320450.93925521721]

{"sheet":"84 - 2013 Inc-Exp","index":25,"n_rows":64,"n_cols":11,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[null,"K.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[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,2580772.3068750002,null,null,null,580600.86247500009,3161373.1693500001]
["84.1.1.2","Total operating subsidies","EUR",null,null,400454.958981,null,null,null,null,400454.958981]
["84.1.1.3","Total income excluding connection fees","EUR",null,null,2981227.2658560001,null,null,null,580600.86247500009,3561828.128331]
[]
[84.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["84.2.1.1","Service charges","EUR",301773.49580332619,0,301773.49580332619,0,0,0,0,301773.49580332619]
["84.2.1.2","Energy costs","EUR",256805.00426663642,78269.701839899397,335074.7061065358,0,37445.1390216,0,37445.1390216,372519.84512813581]
["84.2.1.3","Fuel costs","EUR",2449.5361776630002,29339.3065661742,31788.842743837202,6646.5121763340003,2080.2855012,0,8726.7976775339994,40515.640421371201]
["84.2.1.4","Staff costs","EUR",156679.82295112981,278927.80042914784,435607.62338027766,49344.372088464006,37445.1390216,0,86789.511110064006,522397.13449034165]
["84.2.1.5","Materials and consumables","EUR",1702.7136827322001,12715.745126085001,14418.458808817202,589.7609395902,1560.2141259,0,2149.9750654902,16568.433874307404]
["84.2.1.6","Contracted services","EUR",11740.091226022201,5616.7708532400002,17356.862079262202,0,0,0,0,17356.862079262202]
["84.2.1.7","Maintenance and repair","EUR",2613.8787322578,5627.1722807460001,8241.0510130038001,2080.2855012,2080.2855012,0,4160.5710024,12401.6220154038]
["84.2.1.8","Other direct costs","EUR",70972.060301689809,15758.16267159,86730.222973279815,1676.7101139672002,7280.9992542,0,8957.7093681671995,95687.932341447013]
["84.2.1.9","Total Direct costs","EUR",804736.60314145731,426254.65976688243,1230991.2629083397,60337.640819555403,87892.062425700016,0,148229.70324525543,1379220.9661535951]
[]
[84.3,"Indirect costs"]
[]
["84.3.1.","Business activities"]
["84.3.1.1","Energy costs","EUR",null,null,15105.210979615351,null,null,null,964.16240295417128,16069.373382569522]
["84.3.1.2","Fuel costs","EUR",null,null,7218.5723826515905,null,null,null,460.75993931818658,7679.3323219697768]
["84.3.1.3","Staff costs","EUR",null,null,405272.80534076033,null,null,null,17106.823411616766,422379.62875237712]
["84.3.1.4","Materials and consumables","EUR",null,null,4026.7004698267783,null,null,null,257.02343424426243,4283.723904071041]
["84.3.1.5","Contracted services","EUR",null,null,29298.313292201758,null,null,null,1870.1051037575587,31168.418395959317]
["84.3.1.6","Maintenance and repair","EUR",null,null,1761.173033772722,null,null,null,112.41530002804609,1873.5883338007679]
["84.3.1.7","Other indirect costs","EUR",null,null,10584.324543037104,null,null,null,675.59518359811307,11259.919726635217]
["84.3.1.8","Total Busiiness activities costs","EUR",null,null,473267.10004186566,null,null,null,21446.884775517108,494713.98481738276]
[]
["84.3.2.","Other indirect costs"]
["84.3.2.1","Bad debts","EUR",null,null,931088.50041575008,null,null,null,141668.56888000001,1072757.06929575]
["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,931088.50041575008,null,null,null,141668.56888000001,1072757.06929575]
["84.3.2.4","Total all indirect costs","EUR",null,null,1404355.6004576157,null,null,null,163115.45365551711,1567471.0541131329]
["84.3.2.5","Total direct and indirect costs","EUR",null,null,2635346.8633659557,null,null,null,311345.15690077253,2946692.020266728]
[]
[84.4,"Net Income before cap maintenance"]
[]
["84.4.1","Net income"]
["84.4.1.1.","Net income before capital maintenance","EUR",null,null,345880.40249004448,null,null,null,269255.70557422756,615136.10806427198]
[]
[84.5,"Capital maintenance"]
[]
["84.5.1","Capital maintenance"]
["84.5.1.1","Infrastructure renewals","EUR",0,0,0,141563.72046549851,0,0,141563.72046549851,141563.72046549851]
["84.5.1.2","Depreciation (service activities)","EUR",18435.536535943211,2168.8971686360796,20604.433704579289,92.238650647414104,73.802879335176982,0,166.0415299825911,20770.47523456188]
["84.5.1.3","Depreciation (business activities)","EUR",null,null,1084.448877983921,null,null,null,184.47730129482824,1268.9261792787493]
["84.5.1.4","Total capital maintenance","EUR",18435.536535943211,2168.8971686360796,21688.882582563208,141655.95911614594,73.802879335176982,0,141914.23929677592,163603.12187933913]
[]
[84.6,"Net Income"]
[]
["84.6.1","Net income"]
["84.6.1.1","Net income before taxes and dividends","EUR",null,null,324191.51990748127,null,null,null,127341.46627745163,451532.98618493287]

{"sheet":"85 - 2014 Inc-Exp","index":26,"n_rows":64,"n_cols":11,"rows_kept":64,"cut":false,"hidden":false,"merged":[[6,3,6,5],[6,6,6,9]]}
[null,"K.R.U.\"MITROVICA\"-SH.A. MITROVICE"]
[]
[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,2881733.3756249999,null,null,null,786928.66862499993,3668662.0442499998]
["85.1.1.2","Total operating subsidies","EUR",null,null,407046.4476058273,null,null,null,null,407046.4476058273]
["85.1.1.3","Total income excluding connection fees","EUR",null,null,3288779.8232308272,null,null,null,786928.66862499993,4075708.4918558272]
[]
[85.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["85.2.1.1","Service charges","EUR",306740.68754424894,0,306740.68754424894,0,0,0,0,306740.68754424894]
["85.2.1.2","Energy costs","EUR",380614.8600989554,86662.831854031319,467277.6919529867,0,38061.48600989554,0,38061.48600989554,505339.17796288221]
["85.2.1.3","Fuel costs","EUR",3856.8972490027477,33546.970863721814,37403.868112724558,6755.9137667564582,2114.5270005497518,0,8870.4407673062105,46274.308880030767]
["85.2.1.4","Staff costs","EUR",159258.77283690541,328206.30839032977,487465.08122723515,50156.580453040122,38061.48600989554,0,88218.066462935662,575683.14769017079]
["85.2.1.5","Materials and consumables","EUR",1984.4835900159424,14251.911983705329,16236.395573721271,599.46840465585467,1585.895250412314,0,2185.3636550681686,18421.75922878944]
["85.2.1.6","Contracted services","EUR",11933.333127602526,5709.2229014843306,17642.556029086856,0,0,0,0,17642.556029086856]
["85.2.1.7","Maintenance and repair","EUR",3171.790500824628,6174.4188416052757,9346.2093424299037,2643.1587506871901,2114.5270005497518,0,4757.6857512369425,14103.895093666846]
["85.2.1.8","Other direct costs","EUR",72140.260414255623,16017.542029164371,88157.802443419991,1704.3087624431002,7400.8445019241326,0,9105.1532643672326,97262.955707787216]
["85.2.1.9","Total Direct costs","EUR",939701.0853618111,490569.20686404227,1430270.2922258533,61859.43013758272,89338.765773227031,0,151198.19591080974,1581468.4881366631]
[]
[85.3,"Indirect costs"]
[]
["85.3.1.","Business activities"]
["85.3.1.1","Energy costs","EUR",null,null,15353.842752339819,null,null,null,946.77023376,16300.612986099819]
["85.3.1.2","Fuel costs","EUR",null,null,7337.3900840700353,null,null,null,452.44846108799999,7789.8385451580352]
["85.3.1.3","Staff costs","EUR",null,null,411943.59571666922,null,null,null,16798.239747455998,428741.83546412521]
["85.3.1.4","Materials and consumables","EUR",null,null,4092.9799595601266,null,null,null,252.38708352,4345.3670430801267]
["85.3.1.5","Contracted services","EUR",null,null,29780.563528991395,null,null,null,1836.3709690559999,31616.934498047394]
["85.3.1.6","Maintenance and repair","EUR",null,null,1790.161941908621,null,null,null,110.387481984,1900.549423892621]
["85.3.1.7","Other indirect costs","EUR",null,null,10758.542525015495,null,null,null,663.40837180799997,11421.950896823495]
["85.3.1.8","Total Busiiness activities costs","EUR",null,null,481057.0765085548,null,null,null,21060.012348671997,502117.08885722677]
[]
["85.3.2.","Other indirect costs"]
["85.3.2.1","Bad debts","EUR",null,null,942643.50706874998,null,null,null,181690.56062475001,1124334.0676935001]
["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,942643.50706874998,null,null,null,181690.56062475001,1124334.0676935001]
["85.3.2.4","Total all indirect costs","EUR",null,null,1423700.5835773048,null,null,null,202750.57297342201,1626451.1565507269]
["85.3.2.5","Total direct and indirect costs","EUR",null,null,2853970.8758031582,null,null,null,353948.76888423174,3207919.64468739]
[]
[85.4,"Net Income before cap maintenance"]
[]
["85.4.1","Net income"]
["85.4.1.1.","Net income before capital maintenance","EUR",null,null,434808.94742766907,null,null,null,432979.89974076819,867788.84716843721]
[]
[85.5,"Capital maintenance"]
[]
["85.5.1","Capital maintenance"]
["85.5.1.1","Infrastructure renewals","EUR",0,0,0,143893.85930436061,0,0,143893.85930436061,143893.85930436061]
["85.5.1.2","Depreciation (service activities)","EUR",18203.585882544128,2141.608724145206,20345.194606689336,91.07813029886853,72.874312593918745,0,163.95244289278727,20509.147049582123]
["85.5.1.3","Depreciation (business activities)","EUR",null,null,1070.8046520436637,null,null,null,182.15626059773706,1252.9609126414007]
["85.5.1.4","Total capital maintenance","EUR",18203.585882544128,2141.608724145206,21415.999258732998,143984.93743465949,72.874312593918745,0,144239.96800785113,165655.96726658414]
[]
[85.6,"Net Income"]
[]
["85.6.1","Net income"]
["85.6.1.1","Net income before taxes and dividends","EUR",null,null,413392.94816893607,null,null,null,288739.93173291709,702132.87990185304]