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

{"sheet":"1 - Assumptions","index":0,"n_rows":69,"n_cols":9,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[null,"KRU Radoniqi sh.a. Gjakovë"]
[]
[null,"2011-12-13"]
[]
[1,"Assumptions"]
[null,null,null,"Historical","Base year","Year 1","Year 2","Year 3"]
[null,null,null,"(Actual)","(budget forecast)","(Projected)","(Projected)","(Projected)"]
[null,null,"Unit",2010,2011,2012,2013,2014,"Remarks/Shënim"]
[1.1000000000000001,"Inflation indices and expecations"]
[]
["1.1.1","Inflation index"]
["1.1.1.1","Average of preceding year","Index",109.7,"N/A","N/A","N/A","N/A"]
["1.1.1.2","Average of current year","Index",113.5,"N/A","N/A","N/A","N/A"]
["1.1.1.3","Inflation rate","%",3.4639927073837784E-2,8.1509999999999999E-2,2.1000000000000001E-2,1.7999999999999999E-2,1.6E-2]
["1.1.1.4","Adjustment factor to convert 2011 price level expenditure to nominal price levels","Factor","N/A","N/A",1.0209999999999999,1.0393779999999999,1.056008048]
["1.1.1.5","Inflation to end year","%","N/A",4.7E-2,0.02,1.7000000000000001E-2,1.6E-2]
["1.1.1.6","Tariff adjustment factor to convert tariffs from 2011 price levels","Factor","N/A","N/A",1.0469999999999999,1.0679399999999999,1.0860949799999997]
[]
[1.2,"Water tariff assumptions"]
[]
["1.2.1","Cross-subsidy policy"]
["1.1.1.1","Ratio commercial / institutional tariff to domestic","Ratio","N/A","N/A",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.97943192948090119,0.9621138796472507,0.94696247996776628]
["1.2.2.3","Commercial (nominal prices)","EUR/con/month",3,3,3,3,3]
["1.2.2.4","Commercial (base year price levels)","EUR/con/month","N/A","N/A",2.9382957884427037,2.8863416389417518,2.8408874399032986]
["1.2.2.5","Institutional (nominal prices)","EUR/con/month",3,3,3,3,3]
["1.2.2.6","Institutional (base year price levels)","EUR/con/month","N/A","N/A",2.9382957884427037,2.8863416389417518,2.8408874399032986]
[]
["1.2.3","Connection fees (average)"]
["1.2.3.1","Household (nominal prices)","EUR/con",36,36,36,36,36]
["1.2.3.2","Household (base year price levels)","EUR/con","N/A","N/A",35.259549461312439,34.636099667301025,34.090649278839585]
["1.2.3.3","Non-household (nominal prices)","EUR/con",90,90,90,90,90]
["1.2.3.4","Non-household (base year price levels)","EUR/con","N/A","N/A",88.1488736532811,86.590249168252555,85.226623197098959]
[]
["1.2.4","Water tariff smoothing options"]
["1.2.4.1","Tariff option 1 - Unsmoothed","EUR/m3","N/A","N/A","N/A","N/A","N/A"]
["1.2.4.2","Tariff option 2 - Year 1 average tariff (at base year price levels)","EUR/m3","N/A","N/A",0.38,"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.31371590752700007,"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",24,24,24,24,24]
["1.3.2.2","Household (base year price levels)","EUR/con","N/A","N/A",23.506366307541629,23.090733111534014,22.727099519226389]
["1.3.2.3","Non-household (nominal prices)","EUR/con",60,60,60,60,60]
["1.3.2.4","Non-household (base year price levels)","EUR/con","N/A","N/A",58.765915768854072,57.726832778835039,56.817748798065978]
[]
["1.3.3","Wastewater tariff smoothing options"]
["1.3.3.1","Tariff option 1 - Unsmoothed","EUR/m3","N/A","N/A","N/A","N/A","N/A"]
["1.3.3.2","Tariff option 2 - Year 1 average tariff (at base year price levels)","EUR/m3","N/A","N/A",6.4638645024501548E-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",6.4638645024501548E-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.7,0.7,0.74,0.76,0.78]
["1.4.1.2","Commercial","% of billing",0.37,0.68,0.75,0.78,0.82]
["1.4.1.3","Institutions","% of billing",0.9,0.9,0.94,0.96,0.98]
[]
["1.4.2","Profitability"]
["1.4.2.1","Expected real rate of return on RAB","% (real)","N/A","N/A",5.2999999999999999E-2,"N/A","N/A"]

{"sheet":"2 - Tariffs control sheet","index":1,"n_rows":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[null,"KRU Radoniqi sh.a. Gjakovë"]
[]
[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.27,0.28999999999999998,"N/A","N/A","N/A"]
["2.2.1.2","Non-household","EUR/m3",0.56999999999999995,0.64,"N/A","N/A","N/A"]
[]
["2.2.2","Wastewater"]
["2.2.2.1","Household","EUR/m3",0.05,0.05,"N/A","N/A","N/A"]
["2.2.2.2","Non-household","EUR/m3",0.11,0.11,"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.31371590752700007,0.33995497745797676,0.36838867244405504]
["2.3.1.2","Non-household","EUR/m3","N/A","N/A",0.69017499655940018,0.67990995491595352,0.6630996103992991]
[]
["2.3.2","Wastewater (volume of water consumed)"]
["2.3.2.1","Household","EUR/m3","N/A","N/A",6.4638645024501548E-2,8.3918645518151105E-2,0.10894936091144353]
["2.3.2.2","Non-household","EUR/m3","N/A","N/A",0.16159661256125388,0.20979661379537776,0.27237340227860884]
[]
[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.27,0.28999999999999998,0.33,0.36,0.4]
["2.4.1.3","Commercial - fixed monthly charge","EUR/Con/month",3,3,3,3,3]
["2.4.1.4","Commercial - volume","EUR/m3",0.56999999999999995,0.64,0.72,0.73,0.72]
["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.56999999999999995,0.64,0.72,0.73,0.72]
[]
["2.4.2","Wastewater (volume of water consumed)"]
["2.4.2.1","Household","EUR/m3",0.05,0.05,7.0000000000000007E-2,0.09,0.12]
["2.4.2.2","Commercial","EUR/m3",0.11,0.11,0.16,0.22,0.28999999999999998]
["2.4.2.3","Institutional","EUR/m3",0.11,0.11,0.16,0.22,0.28999999999999998]
[]
[2.5,"VAT and bad debts"]
[]
["2.5.1","Recovery of VAT on unpaid bills"]
["2.5.1.1","Include in tariff for cost of VAT on unpaid bills (Y or N)","Y' or 'N' (insert 'P' for yes and 'J' for no)","N/A","N/A","J","J","J"]
[]
["2.5.2","VAT rate"]
["2.5.2.1","VAT rate","%","N/A","N/A",0.16,0.16,0.16]

{"sheet":"11 - W sales vol","index":2,"n_rows":100,"n_cols":9,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
[null,"KRU Radoniqi sh.a. Gjakovë"]
[]
[null,"2011-12-13"]
[]
[11,"Water sales"]
[null,null,null,"Historical","Base year","Year 1","Year 2","Year 3"]
[null,null,null,"(Actual)","(budget forecast)","(Projected)","(Projected)","(Projected)"]
[null,null,"Unit",2010,2011,2012,2013,2014,"Remarks/Shënim"]
[11.1,"Households"]
[]
["11.1.1","Household properties in service area"]
["11.1.1.1","Household properties in service area at start of year","No",27581,27581,28181,28831,29481]
["11.1.1.2","Household properties in service area at end of year","No",27581,28181,28831,29481,30131]
["11.1.1.3","Average number of household properties in service area over the year","No",27581,27881,28506,29156,29806]
[]
["11.1.2","Households served with water supply"]
["11.1.2.1","Metered households with water supply service at start of year","No",21603,22175,22925,23875,24825]
["11.1.2.2","Metered households with water supply service at end of year","No",22175,22925,23875,24825,25775]
["11.1.2.3","Un-metered households with water supply service at start of year","No",2078,2111,1961,1661,1361]
["11.1.2.4","Un-metered households with water supply service at end of year","No",2111,1961,1661,1361,1061]
["11.1.2.5","Total households with water supply at start of year","No",23681,24286,24886,25536,26186]
["11.1.2.6","Total households with water supply at end of year","No",24286,24886,25536,26186,26836]
["11.1.2.7","Average metered households served in year","No",21889,22550,23400,24350,25300]
["11.1.2.8","Average un-metered households served in year","No",2094.5,2036,1811,1511,1211]
["11.1.2.9","Average total households served in year","No",23983.5,24586,25211,25861,26511]
["11.1.2.10","New household connections in year","No",605,600,650,650,650]
["11.1.2.11","Service coverage","%",0.8695660055835539,0.88181916000143468,0.88441029958605211,0.88698724104815474,0.88945178823055759]
[]
["11.1.3","Household water consumption"]
["11.1.3.1","Average annual metered water billed per metered household","m3/household/year",200,216,216,216,216]
["11.1.3.2","Average annual un-metered water billed per un-metered household","m3/household/year",400,324,324,324,324]
["11.1.3.3","Total household metered water billed","m3/year",4377800,4870800,5054400,5259600,5464800]
["11.1.3.4","Total household un-metered water billed","m3/year",837800,659664,586764,489564,392364]
["11.1.3.5","Total household water billed","m3/year",5215600,5530464,5641164,5749164,5857164]
[]
[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",3210,3308,3313,3318,3323]
["11.2.1.2","Metered commercial with water supply service at end of year","No",3308,3313,3318,3323,3328]
["11.2.1.3","Un-metered commercial with water supply service at start of year","No",0,0,0,0,0]
["11.2.1.4","Un-metered commercial with water supply service at end of year","No",0,0,0,0,0]
["11.2.1.5","Total commercial with water supply at start of year","No",3210,3308,3313,3318,3323]
["11.2.1.6","Total commercial with water supply at end of year","No",3308,3313,3318,3323,3328]
["11.2.1.7","Average metered commercial served in year","No",3259,3310.5,3315.5,3320.5,3325.5]
["11.2.1.8","Average un-metered commercial served in year","No",0,0,0,0,0]
["11.2.1.9","Average total commercial served in year","No",3259,3310.5,3315.5,3320.5,3325.5]
["11.2.1.10","New commercial connections in year","No",98,5,5,5,5]
[]
["11.2.2","Non-household (commercial) water consumption"]
["11.2.2.1","Total commercial metered water billed","m3/year",443125,450228,450908,451588,452268]
["11.2.2.2","Total commercial un-metered water billed","m3/year",0,0,0,0,0]
["11.2.2.3","Total commercial water billed","m3/year",443125,450228,450908,451588,452268]
[]
[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",219,220,223,224,225]
["11.3.1.2","Metered institutional with water supply service at end of year","No",220,223,224,225,226]
["11.3.1.3","Un-metered institutional with water supply service at start of year","No",0,0,0,0,0]
["11.3.1.4","Un-metered institutional with water supply service at end of year","No",0,0,0,0,0]
["11.3.1.5","Total institutional with water supply at start of year","No",219,220,223,224,225]
["11.3.1.6","Total institutional with water supply at end of year","No",220,223,224,225,226]
["11.3.1.7","Average metered institutional served in year","No",219.5,221.5,223.5,224.5,225.5]
["11.3.1.8","Average un-metered institutional served in year","No",0,0,0,0,0]
["11.3.1.9","Average total institutional served in year","No",219.5,221.5,223.5,224.5,225.5]
["11.3.1.10","New institutional connections in year","No",1,3,1,1,1]
[]
["11.3.2","Non-household (institutional) water consumption"]
["11.3.2.1","Total institutional metered water billed","m3/year",343509,348103,349664,351225,352786]
["11.3.2.2","Total institutional un-metered water billed","m3/year",0,0,0,0,0]
["11.3.2.3","Total institutional water billed","m3/year",343509,348103,349664,351225,352786]
[]
[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",3478.5,3532,3539,3545,3551]
["11.4.1.2","Average un-metered non-household served in year","No",0,0,0,0,0]
["11.4.1.3","Average total non-household served in year","No",3478.5,3532,3539,3545,3551]
[]
["11.4.2","Non-household water consumption"]
["11.4.2.3","Total non-household metered water billed","m3/year",786634,798331,800572,802813,805054]
["11.4.2.4","Total non-household un-metered water billed","m3/year",0,0,0,0,0]
["11.4.2.5","Total non-household water billed","m3/year",786634,798331,800572,802813,805054]
[]
[11.5,"Household and non-household"]
[]
["11.5.1","Total served"]
["11.5.1.1","Total metered connections","No",25367.5,26082,26939,27895,28851]
["11.5.1.2","Total un-metered connections","No",2094.5,2036,1811,1511,1211]
["11.5.1.3","Total connections","no",27462,28118,28750,29406,30062]
[]
["11.5.2","Total sales"]
["11.5.2.1","Total metered water billed","m3/year",5164434,5669131,5854972,6062413,6269854]
["11.5.2.2","Total un-metered water billed","m3/year",837800,659664,586764,489564,392364]
["11.5.2.3","Total water billed","m3/year",6002234,6328795,6441736,6551977,6662218]
[]
["11.5.3","Seasonal peak demand"]
["11.5.3.1","Seasonal peak factor (peak month sales / average monthly sales)","Factor",1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001]
["11.5.3.2","Peak daily sales","m3/day",18088.924383561643,19073.080821917811,19413.450958904112,19745.684109589041,20077.917260273975]

{"sheet":"12 - W production & NRW","index":3,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,"KRU Radoniqi sh.a. Gjakovë"]
[]
[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",5701451,7099625.5,6986225.5,6872825.5,6759425.5]
["12.1.1.2","Estimated volume of leakages","m3/year",5701451,7099625.5,7091905.5,7084185.5,7076465.5]
["12.1.1.3","Total NRW in year","m3/year",11402902,14199251,14078131,13957011,13835891]
["12.1.1.4","NRW per connection per day","l/con/day)",1137.6020463644409,1383.5286127835043,1341.5729362715904,1300.3600048075177,1260.9457349787608]
["12.1.1.5","NRW as percentage of production","%",0.65514581443086684,0.69170007705555614,0.68607320895403467,0.68053143334034816,0.67498377533264164]
[]
[12.2,"Production requirement"]
[]
["12.2.1","Production requirement"]
["12.2.1.1","Water sales","m3/year",6002234,6328795,6441736,6551977,6662218]
["12.2.1.2","Total NRW","m3/year",11402902,14199251,14078131,13957011,13835891]
["12.2.1.3","Total average production requirement","m3/year",17405136,20528046,20519867,20508988,20498109]
["12.2.1.4","Peak production requirement","m3/day",49329.751780821913,57975.138356164389,57983.672876712328,57984.070410958906,57984.467945205484]
[]
[12.3,"Production capacity"]
[]
["12.3.1","Production capacity"]
["12.3.1.1","Average annual production capacity","m3/year",22075200,22075200,22075200,22075200,22075200]
["12.3.1.2","Maximum production capacity","m3/day",60480,60480,60480,60480,60480]
["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",60480,60480,60480,60480,60480]
["12.3.1.5","Is production capacity sufficient for average conditions","yes/no (P=Yes, J=No)","P","P","P","P","P"]
["12.3.1.6","Is production capacity sufficient for peak conditions","yes/no (P=Yes, J=No)","P","P","P","P","P"]
["12.3.1.7","Is production capacity sufficient (adjust production requirement to suit)","yes/no (P=Yes, J=No)","P","P","P","P","P"]
[null,"Note: if production capacity insufficient to meet production requirement adjust sales and/or NRW to ensure capacity exceeds requirements."]

{"sheet":"13 - WW sales vol","index":4,"n_rows":111,"n_cols":9,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
[null,"KRU Radoniqi sh.a. Gjakovë"]
[]
[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",11979,12159,12759,13409,14059]
["13.1.1.2","Metered households with wastewater service at end of year","No",12159,12759,13409,14059,14709]
["13.1.1.3","Un-metered households with wastewater service at start of year","No",580,630,630,630,630]
["13.1.1.4","Un-metered households with wastewater service at end of year","No",630,630,630,630,630]
["13.1.1.5","Total households with wastewater service at start of year","No",12559,12789,13389,14039,14689]
["13.1.1.6","Total households with wastewater service at end of year","No",12789,13389,14039,14689,15339]
["13.1.1.7","Average metered households served with wastewater service in year","No",12069,12459,13084,13734,14384]
["13.1.1.8","Average un-metered households served with wastewater service in year","No",605,630,630,630,630]
["13.1.1.9","Average total households served in year","No",12674,13089,13714,14364,15014]
["13.1.1.10","New household connections in year","No",230,600,650,650,650]
["13.1.1.11","Service coverage with wastewater connections","%",0.4595192342554657,0.46945948854058317,0.48109169999298396,0.49266017286321856,0.50372408239951683]
[]
["13.1.2","Household sales from those with wastewater service"]
["13.1.2.1","Metered water billed with wastewater connections","m3/year",2413800,2691144,2826143.9999999995,2966544.0000000005,3106944]
["13.1.2.2","Un-metered water billed with wastewater connections","m3/year",242000,204120,204120,204120,204119.99999999997]
["13.1.2.3","Total household water billed with wastewater connections","m3/year",2655800,2895264,3030263.9999999995,3170664.0000000005,3311064]
[]
["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",null,0,0,0,0]
["13.1.3.2","Total households with wastewater collection and treatment service at end of year","No"]
["13.1.3.3","Average households served with wastewater collection and treatment service in year","No",0,0,0,0,0]
["13.1.3.4","Service coverage with wastewater collection and treatment","%",0,0,0,0,0]
[]
[13.2,"Non-household (commercial)"]
[]
["13.2.1","Commercial served with wastewater collection service "]
["13.2.1.1","Metered commercial with wastewater service at start of year","No",2759,2823,2873,2923,2973]
["13.2.1.2","Metered commercial with wastewater service at end of year","No",2823,2873,2923,2973,3023]
["13.2.1.3","Un-metered commercial with wastewater service at start of year","No",0,0,0,0,0]
["13.2.1.4","un-metered commercial with wastewater service at end of year","No",0,0,0,0,0]
["13.2.1.5","Total commercial with wastewater service at start of year","No",2759,2823,2873,2923,2973]
["13.2.1.6","Total commercial with wastewater service at end of year","No",2823,2873,2923,2973,3023]
["13.2.1.7","Average metered commercial served with wastewater service in year","No",2791,2848,2898,2948,2998]
["13.2.1.8","Average un-metered commercial served with wastewater service in year","No",0,0,0,0,0]
["13.2.1.9","Average total commercial served in year","No",2791,2848,2898,2948,2998]
["13.2.1.10","New commercial connections in year","No",64,50,50,50,50]
[]
["13.2.2","Commercial water sales from those with wastewater services"]
["13.2.2.1","Metered water billed with wastewater connections","m3/year",379491.21663086838,387328,394128,400928,407728]
["13.2.2.2","Un-metered water billed with wastewater connections","m3/year",0,0,0,0,0]
["13.2.2.3","Total commercial water billed with wastewater connections","m3/year",379491.21663086838,387328,394128,400928,407728]
[]
["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",null,0,0,0,0]
["13.2.3.2","Total commercial with wastewater treatment service at end of year","No"]
["13.2.3.3","Average commercial served with wastewater treatment service in year","No",0,0,0,0,0]
[]
[13.3,"Non-household (institutional)"]
[]
["13.3.1","Institutional served with wastewater collection service "]
["13.3.1.1","Metered institutional with wastewater service at start of year","No",113,116,121,126,131]
["13.3.1.2","Metered institutional with wastewater service at end of year","No",116,121,126,131,136]
["13.3.1.3","Un-metered institutional with wastewater service at start of year","No",0,0,0,0,0]
["13.3.1.4","un-metered institutional with wastewater service at end of year","No",0,0,0,0,0]
["13.3.1.5","Total institutional with wastewater service at start of year","No",113,116,121,126,131]
["13.3.1.6","Total institutional with wastewater service at end of year","No",116,121,126,131,136]
["13.3.1.7","Average metered institutional served with wastewater service in year","No",114.5,118.5,123.5,128.5,133.5]
["13.3.1.8","Average un-metered institutional served with wastewater service in year","No",0,0,0,0,0]
["13.3.1.9","Average total institutional served in year","No",114.5,118.5,123.5,128.5,133.5]
["13.3.1.10","New institutional connections in year","No",3,5,5,5,5]
[]
["13.3.2","Institutional water sales from those with wastewater service"]
["13.3.2.1","Metered water billed with wastewater connections","m3/year",179188.06605922553,186231.17607223478,193214.78299776287,201035.24498886417,208855.56984478937]
["13.3.2.2","Un-metered water billed with wastewater connections","m3/year",0,0,0,0,0]
["13.3.2.3","Total institutional water billed with wastewater connections","m3/year",179188.06605922553,186231.17607223478,193214.78299776287,201035.24498886417,208855.56984478937]
[]
["13.3.3","Institutional served with wastewater collection and treatment service "]
["13.3.3.1","Total institutional with wastewater treatment service at start of year","No",0,0,0,0,0]
["13.3.3.2","Total institutional with wastewater treatment service at end of year","No",0,0,0,0,0]
["13.3.3.3","Average institutional served with wastewater treatment service in year","No",0,0,0,0,0]
[]
[13.4,"Non-household (total)"]
[]
["13.4.1","Non-household served with wastewater collection service"]
["13.4.1.1","Average metered non-household with wastewater connections","No",2905.5,2966.5,3021.5,3076.5,3131.5]
["13.4.1.2","Average un-metered non-household with wastewater connections","No",0,0,0,0,0]
["13.4.1.3","Average total non-household with wastewater connections","No",2905.5,2966.5,3021.5,3076.5,3131.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",558679.28269009385,573559.17607223475,587342.7829977629,601963.24498886417,616583.56984478934]
["13.4.2.2","Total non-household un-metered water billed from those with wastewater service","m3/year",0,0,0,0,0]
["13.4.2.3","Total non-household water billed from those with wastewater service","m3/year",113,116,121,126,131]
[]
["13.4.3","Non-household served with wastewater collection and treatment service "]
["13.4.3.3","Average non-household with wastewater treatment service in year","No",0,0,0,0,0]
[]
[13.5,"Household and non-household"]
[]
["13.5.1","Total served with wastewater collection service"]
["13.5.1.1","Total metered connections with wastewater collection services","No",14974.5,15425.5,16105.5,16810.5,17515.5]
["13.5.1.2","Total un-metered connections with wastewater collection services","No",605,630,630,630,630]
["13.5.1.3","Total connections","no",15579.5,16055.5,16735.5,17440.5,18145.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",2972479.2826900939,3264703.1760722348,3413486.7829977623,3568507.2449888648,3723527.5698447893]
["13.5.2.2","Total un-metered water billed from those with wastewater service","m3/year",242000,204120,204120,204120,204119.99999999997]
["13.5.2.3","Total water billed from those with wastewater service","m3/year",3214479.2826900939,3468823.1760722348,3617606.7829977623,3772627.2449888648,3927647.5698447893]
[]
["13.5.3","Total served with wastewater collection and treatment service "]
["13.5.3.3","Average total with wastewater collection and treatment service in year","No",0,0,0,0,0]

{"sheet":"21 - W opex","index":5,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[6,3,6,4],[6,5,6,7]]}
[null,"KRU Radoniqi sh.a. Gjakovë"]
[]
[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",20803,20803,20803,20803,20803]
["21.1.1.2","Energy costs","EUR/year",52822.81,52000,52000,52000,52000]
["21.1.1.3","Fuel costs","EUR/year",2448.16,2500,2500,2500,2500]
["21.1.1.4","Staff costs","EUR/year",138873.29,139000,139000,139000,139000]
["21.1.1.5","Materials and consumables","EUR/year",21746,20200,20200,20200,20200]
["21.1.1.6","Contracted services","EUR/year",9600,9600,9600,9600,9600]
["21.1.1.7","Maintenance and repair","EUR/year",3110,3100,3100,3100,3100]
["21.1.1.8","Other direct costs","EUR/year",22644.75,12000,12000,12000,12000]
["21.1.1.9","Total water resources and treatment costs","EUR/year",272048.01,259203,259203,259203,259203]
[]
["21.1.2","Water Distribution"]
["21.1.2.1","Service charges","EUR/year",0,0,0,0,0]
["21.1.2.2","Energy costs","EUR/year",75000,76200,86200,86200,86200]
["21.1.2.3","Fuel costs","EUR/year",25326,26000,34000,34000,34000]
["21.1.2.4","Staff costs","EUR/year",550236,551000,542858,542858,542858]
["21.1.2.5","Materials and consumables","EUR/year",40624,40236,40236,40236,40236]
["21.1.2.6","Contracted services","EUR/year",0,0,0,0,0]
["21.1.2.7","Maintenance and repair","EUR/year",12370.68,12990,13640,14320,15035]
["21.1.2.8","Other direct costs","EUR/year",16982,11000,15000,15000,15000]
["21.1.2.9","Total water distribution costs","EUR/year",720538.68,717426,731934,732614,733329]
[]
[21.2,"Indirect costs"]
[]
["21.2.1","Business activities"]
["21.2.1.1","Energy costs","EUR/year",16345.45,16230,16230,16230,16230]
["21.2.1.2","Fuel costs","EUR/year",11123.33,10000,10000,10000,10000]
["21.2.1.3","Staff costs","EUR/year",541551,543000,318356,318356,318356]
["21.2.1.4","Materials and consumables","EUR/year",2432,2185,2185,2185,2185]
["21.2.1.5","Contracted services","EUR/year",0,0,0,0,0]
["21.2.1.6","Maintenance and repair","EUR/year",0,0,0,0,0]
["21.2.1.7","Other indirect costs","EUR/year",254960,206330,206330,206330,206330]
["21.2.1.8","Total business activities costs","EUR/year",826411.78,777745,553101,553101,553101]
[]
["21.2.2","Total operating costs excl bad debts"]
["21.2.2.1","Total","EUR/year",1818998.4700000002,1754374,1544238,1544918,1545633]

{"sheet":"22 - WW opex","index":6,"n_rows":59,"n_cols":9,"rows_kept":59,"cut":false,"hidden":false,"merged":[[6,3,6,4],[6,5,6,7]]}
[null,"KRU Radoniqi sh.a. Gjakovë"]
[]
[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",950,1425,1425,1425,1425]
["22.1.1.3","Fuel costs","EUR/year",2935.88,3040,3040,3040,3040]
["22.1.1.4","Staff costs","EUR/year",81612.600000000006,82650,48309,48309,48309]
["22.1.1.5","Materials and consumables","EUR/year",0,0,0,0,0]
["22.1.1.6","Contracted services","EUR/year",0,0,0,0,0]
["22.1.1.7","Maintenance and repair","EUR/year",156,1000,1000,1000,1000]
["22.1.1.8","Other direct costs","EUR/year",7555.35,7342.55,7342.55,7342.55,7342.55]
["22.1.1.9","Total wastewater collection costs ","EUR/year",93209.830000000016,95457.55,61116.55,61116.55,61116.55]
[]
["22.1.2","Wastewater treatment"]
["22.1.2.1","Service charges","EUR/year",0,0,0,0,0]
["22.1.2.2","Energy costs","EUR/year",0,0,0,0,0]
["22.1.2.3","Fuel costs","EUR/year",0,0,0,0,0]
["22.1.2.4","Staff costs","EUR/year",0,0,0,0,0]
["22.1.2.5","Materials and consumables","EUR/year",0,0,0,0,0]
["22.1.2.6","Contracted services","EUR/year",0,0,0,0,0]
["22.1.2.7","Maintenance and repair","EUR/year",0,0,0,0,0]
["22.1.2.8","Other direct costs","EUR/year",0,0,0,0,0]
["22.1.2.9","Total Wastewater treatment costs","EUR/year",0,0,0,0,0]
[]
["22.1.3","Sludge treatment and disposal"]
["22.1.3.1","Service charges","EUR/year",0,0,0,0,0]
["22.1.3.2","Energy costs","EUR/year",0,0,0,0,0]
["22.1.3.3","Fuel costs","EUR/year",0,0,0,0,0]
["22.1.3.4","Staff costs","EUR/year",0,0,0,0,0]
["22.1.3.5","Materials and consumables","EUR/year",0,0,0,0,0]
["22.1.3.6","Contracted services","EUR/year",0,0,0,0,0]
["22.1.3.7","Maintenance and repair","EUR/year",0,0,0,0,0]
["22.1.3.8","Other direct costs","EUR/year",0,0,0,0,0]
["22.1.3.9","Total sludge treatment costs","EUR/year",0,0,0,0,0]
[]
[22.2,"Indirect costs"]
[]
["22.2.1","Business activities"]
["22.2.1.1","Energy costs","EUR/year",50,75,75,75,75]
["22.2.1.2","Fuel costs","EUR/year",154.52000000000001,160,160,160,160]
["22.2.1.3","Staff costs","EUR/year",4295.3999999999996,4350,18450,18450,18450]
["22.2.1.4","Materials and consumables","EUR/year",128,115,115,115,115]
["22.2.1.5","Contracted services","EUR/year",0,0,0,0,0]
["22.2.1.6","Maintenance and repair","EUR/year"]
["22.2.1.7","Other indirect costs","EUR/year",397.65,385,385,385,385]
["22.2.1.8","Total business activities costs","EUR/year",5025.57,5085,19185,19185,19185]
[]
["22.2.2","Total operating costs excl bad debts"]
["22.2.2.1","Total","EUR/year",98235.400000000023,100542.55,80301.55,80301.55,80301.55]

{"sheet":"31- W inf renewals","index":7,"n_rows":54,"n_cols":48,"rows_kept":54,"cut":false,"hidden":false,"merged":[[6,21,6,29],[7,21,7,29],[8,21,8,29],[6,39,6,47],[8,39,8,47],[7,39,7,47],[6,30,6,38],[8,30,8,38],[7,30,7,38],[6,12,6,20],[7,12,7,20],[8,12,8,20],[6,3,6,11],[7,3,7,11],[8,3,8,11],[9,42,9,47],[9,39,9,41],[9,33,9,38],[9,30,9,32],[9,24,9,29],[9,21,9,23],[9,15,9,20],[9,12,9,14],[9,6,9,11],[9,3,9,5]]}
[null,"KRU Radoniqi sh.a. Gjakovë"]
[]
[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","Zevendesimi i rrjetit ekzistues ne Qender te qytetit te Gjakoves","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,150000,null,null,null,150000,150000,null,null,0,150000,null,null,null,150000,150000,null,null,0,150000,null,null,null,150000,150000]
["31.1.1.2","Zevendesimi i rrjetit ekzistues ","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,10000,null,10000,null,null,null,null,0,10000,10000,null,10000,null,null,null,null,0,10000,10000,null,10000,null,null,null,null,0,10000]
["31.1.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.1.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10000,0,10000,150000,0,0,0,150000,160000,10000,0,10000,150000,0,0,0,150000,160000,10000,0,10000,150000,0,0,0,150000,160000]
[]
[31.2,"Water distribution"]
["31.2.1","Infrastructure renewals expenditure and sources of finance"]
["31.2.1.1",null,"EUR/year",0,null,0,null,null,null,0,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["31.2.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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,369432.089451615,null,369432.089451615,null,null,null,null,0,369432.089451615,369432.089451615,null,369432.089451615,null,null,null,null,0,369432.089451615,369432.089451615,null,369432.089451615,null,null,null,null,0,369432.089451615]
["31.2.1.21","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,369432.089451615,0,369432.089451615,0,0,0,0,0,369432.089451615,369432.089451615,0,369432.089451615,0,0,0,0,0,369432.089451615,369432.089451615,0,369432.089451615,0,0,0,0,0,369432.089451615]
[]
[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,10000,0,10000,150000,0,0,0,150000,160000,10000,0,10000,150000,0,0,0,150000,160000,10000,0,10000,150000,0,0,0,150000,160000]
["31.3.1.2","Water distribution","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,369432.089451615,0,369432.089451615,0,0,0,0,0,369432.089451615,369432.089451615,0,369432.089451615,0,0,0,0,0,369432.089451615,369432.089451615,0,369432.089451615,0,0,0,0,0,369432.089451615]
["31.3.1.3","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,379432.089451615,0,379432.089451615,150000,0,0,0,150000,529432.089451615,379432.089451615,0,379432.089451615,150000,0,0,0,150000,529432.089451615,379432.089451615,0,379432.089451615,150000,0,0,0,150000,529432.089451615]

{"sheet":"32 - W inf enhancement","index":8,"n_rows":84,"n_cols":48,"rows_kept":84,"cut":false,"hidden":false,"merged":[[9,12,9,14],[9,15,9,20],[9,21,9,23],[9,24,9,29],[6,3,6,11],[6,12,6,20],[6,21,6,29],[7,3,7,11],[7,12,7,20],[7,21,7,29],[8,3,8,11],[8,12,8,20],[8,21,8,29],[9,3,9,5],[9,6,9,11],[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,"KRU Radoniqi sh.a. Gjakovë"]
[]
[null,"2011-12-13"]
[]
[32,"Water supply infrastructure enhancement"]
[null,"Note: Report 2010 and 2011 costs as actuals / budget but 2012 to 2014 at base year (mid-2011) price levels"]
[null,null,null,"Historical",null,null,null,null,null,null,null,null,"Base year",null,null,null,null,null,null,null,null,"Year 1",null,null,null,null,null,null,null,null,"Year 2",null,null,null,null,null,null,null,null,"Year 3"]
[null,null,null,"(Actual)",null,null,null,null,null,null,null,null,"(budget forecast)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)",null,null,null,null,null,null,null,null,"(Projected at 2011 price levels)"]
[null,null,null,2010,null,null,null,null,null,null,null,null,2011,null,null,null,null,null,null,null,null,2012,null,null,null,null,null,null,null,null,2013,null,null,null,null,null,null,null,null,2014]
[null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed",null,null,null,null,null,"RWC financed",null,null,"Grant financed"]
[null,null,"Unit","RWC cash reserve","Loans to RWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed","RWC cash reserve","Loans to RRWCs","Total RWC finaced","Gov budget","Municipality budget","Donor grants","Community /developer contributions","Total grant financed","Total RWC and grant financed"]
[32.1,"Water resources and treatment"]
["32.1.1","Level of service improvement (including backlog infrastructure renewals), expenditure and sources of finance"]
["32.1.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.1.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["32.1.2","Supply demand balance, expenditure and sources of finance"]
["32.1.2.1","\"Siq është siguruar nga ZRRUM,në letrën e datës 20/6/2011\"","EUR/year",1246,null,1246,5165,null,null,null,5165,6411,null,null,0,null,null,null,null,0,0,null,null,0,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",1246,0,1246,5165,0,0,0,5165,6411,0,0,0,0,0,0,0,0,0,0,0,0,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",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["32.2.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["32.2.2","Supply demand balance, expenditure and sources of finance"]
["32.2.2.1","\"Siq është siguruar nga ZRRUM,në letrën e datës 20/6/2011\"","EUR/year",23682,null,23682,98144,null,null,null,98144,121826,null,null,0,null,null,null,null,0,0,null,null,0,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",23682,0,23682,98144,0,0,0,98144,121826,0,0,0,0,0,0,0,0,0,0,0,0,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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["32.3.1.2","Water resources and treatment  - supply demand balance","EUR/year",1246,0,1246,5165,0,0,0,5165,6411,0,0,0,0,0,0,0,0,0,0,0,0,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",1246,0,1246,5165,0,0,0,5165,6411,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["32.3.1.4","Water distribution - level of service","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["32.3.1.5","Water Distribution  - supply demand balance","EUR/year",23682,0,23682,98144,0,0,0,98144,121826,0,0,0,0,0,0,0,0,0,0,0,0,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",23682,0,23682,98144,0,0,0,98144,121826,0,0,0,0,0,0,0,0,0,0,0,0,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.7","Totals","EUR/year",24928,0,24928,103309,0,0,0,103309,128237,0,0,0,0,0,0,0,0,0,0,0,0,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":"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],[8,30,8,38],[9,3,9,5],[9,6,9,11],[9,12,9,14],[9,15,9,20],[9,21,9,23],[9,24,9,29],[9,30,9,32],[9,33,9,38]]}
[null,"KRU Radoniqi sh.a. Gjakovë"]
[]
[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",0,null,0,null,null,0,0,0,0,0,null,0,null,null,0,null,0,0,0,null,0,null,null,0,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",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,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,0,0,0,0,0,0,0,0,0,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,0,0,0,0,0,0,0,0,0,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,0,0,0,0,0,0,0,0,0,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":[[9,39,9,41],[7,3,7,11],[7,12,7,20],[7,21,7,29],[7,30,7,38],[7,39,7,47],[8,21,8,29],[8,30,8,38],[8,39,8,47],[6,30,6,38],[6,39,6,47],[9,3,9,5],[9,6,9,11],[9,12,9,14],[9,15,9,20],[8,3,8,11],[8,12,8,20],[6,3,6,11],[6,12,6,20],[6,21,6,29],[9,42,9,47],[9,21,9,23],[9,24,9,29],[9,30,9,32],[9,33,9,38]]}
[null,"KRU Radoniqi sh.a. Gjakovë"]
[]
[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",0,0,0,null,null,0,null,0,0,0,null,0,null,null,0,null,0,0,0,null,0,null,null,0,null,0,0,0,null,0,null,null,0,null,0,0,0,null,0,null,null,0,null,0,0]
["34.1.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["34.1.2","Level of service improvement (including backlog infrastructure renewals), expenditure and sources of finance"]
["34.1.2.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.1.2.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["34.1.3","Supply demand balance, expenditure and sources of finance"]
["34.1.3.1","\"Siq është siguruar nga ZRRUM,në letrën e datës 20/6/2011\"","EUR/year",20976,null,20976,null,null,null,null,0,20976,null,null,0,null,null,null,null,0,0,null,null,0,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",20976,0,20976,0,0,0,0,0,20976,0,0,0,0,0,0,0,0,0,0,0,0,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","Makineri dhe paisje","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,150000,null,null,null,150000,150000,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["34.2.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,150000,0,0,0,150000,150000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["34.2.2","Supply demand balance, expenditure and sources of finance"]
["34.2.2.1","\"Siq është siguruar nga ZRRUM,në letrën e datës 20/6/2011\"","EUR/year",2468,null,2468,null,null,null,null,0,2468,null,null,0,null,null,null,null,0,0,null,null,0,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",2468,0,2468,0,0,0,0,0,2468,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[34.299999999999997,"Total water supply non-infrastructure enhancement"]
["34.3.1","Infrastructure enhancement expenditure and sources of finance"]
["34.3.1.1","Water resources and treatment - quality improvments","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["34.3.1.2","Water resources and treatment - level of service improvements","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["34.3.1.3","Water resources and treatment  - supply demand balance","EUR/year",20976,0,20976,0,0,0,0,0,20976,0,0,0,0,0,0,0,0,0,0,0,0,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",20976,0,20976,0,0,0,0,0,20976,0,0,0,0,0,0,0,0,0,0,0,0,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.5","Water distribution - level of service","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,150000,0,0,0,150000,150000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["34.3.1.6","Water distribution  - supply demand balance","EUR/year",2468,0,2468,0,0,0,0,0,2468,0,0,0,0,0,0,0,0,0,0,0,0,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",2468,0,2468,0,0,0,0,0,2468,0,0,0,150000,0,0,0,150000,150000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["34.3.1.8","Totals","EUR/year",23444,0,23444,0,0,0,0,0,23444,0,0,0,150000,0,0,0,150000,150000,0,0,0,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":"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],[6,39,6,47],[8,3,8,11],[8,12,8,20],[8,21,8,29],[8,30,8,38],[8,39,8,47],[9,3,9,5],[9,6,9,11],[9,12,9,14],[9,15,9,20],[9,21,9,23],[9,24,9,29],[9,30,9,32],[9,33,9,38],[9,39,9,41],[9,42,9,47],[7,3,7,11],[7,12,7,20],[7,21,7,29],[7,30,7,38],[7,39,7,47]]}
[null,"KRU Radoniqi sh.a. Gjakovë"]
[]
[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","\"Siq është siguruar nga ZRRUM,në letrën e datës 20/6/2011\"","EUR/year",1234,null,1234,null,null,null,null,0,1234,null,null,0,null,null,null,null,0,0,null,null,0,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","Teknologji informative","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,19000,null,19000,null,null,null,null,0,19000,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",1234,0,1234,0,0,0,0,0,1234,0,0,0,0,0,0,0,0,0,19000,0,19000,0,0,0,0,0,19000,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":[[8,39,8,47],[6,3,6,11],[6,12,6,20],[6,21,6,29],[6,30,6,38],[6,39,6,47],[7,3,7,11],[7,12,7,20],[7,21,7,29],[7,30,7,38],[7,39,7,47],[8,3,8,11],[8,12,8,20],[8,21,8,29],[8,30,8,38],[9,30,9,32],[9,33,9,38],[9,39,9,41],[9,42,9,47],[9,3,9,5],[9,6,9,11],[9,12,9,14],[9,15,9,20],[9,21,9,23],[9,24,9,29]]}
[null,"KRU Radoniqi sh.a. Gjakovë"]
[]
[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","Zevendesimi i rrjetit te ujerave te zeza perfshire edhe pusetat","EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,10000,null,null,null,10000,10000,10000,null,10000,null,null,null,null,0,10000,10000,null,10000,null,null,null,null,0,10000]
["41.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]
["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,145441.48167906102,null,145441.48167906102,null,null,null,null,0,145441.48167906102]
["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,10000,0,0,0,10000,146100.28083533567,146100.28083533567,0,146100.28083533567,0,0,0,0,0,146100.28083533567,155441.48167906102,0,155441.48167906102,0,0,0,0,0,155441.48167906102]
[]
[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,10000,0,0,0,10000,146100.28083533567,146100.28083533567,0,146100.28083533567,0,0,0,0,0,146100.28083533567,155441.48167906102,0,155441.48167906102,0,0,0,0,0,155441.48167906102]
["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,10000,0,0,0,10000,146100.28083533567,146100.28083533567,0,146100.28083533567,0,0,0,0,0,146100.28083533567,155441.48167906102,0,155441.48167906102,0,0,0,0,0,155441.48167906102]

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

{"sheet":"44 - WW non-inf enhancement","index":15,"n_rows":132,"n_cols":48,"rows_kept":132,"cut":false,"hidden":false,"merged":[[6,3,6,11],[6,12,6,20],[6,21,6,29],[6,30,6,38],[6,39,6,47],[9,24,9,29],[9,30,9,32],[9,33,9,38],[9,39,9,41],[9,42,9,47],[9,3,9,5],[9,6,9,11],[9,12,9,14],[9,15,9,20],[9,21,9,23],[8,3,8,11],[8,12,8,20],[8,21,8,29],[8,30,8,38],[8,39,8,47],[7,3,7,11],[7,12,7,20],[7,21,7,29],[7,30,7,38],[7,39,7,47]]}
[null,"KRU Radoniqi sh.a. Gjakovë"]
[]
[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","\"Siq është siguruar nga ZRRUM,në letrën e datës 20/6/2011\"","EUR/year",760,null,760,null,null,null,null,0,760,null,null,0,null,null,null,null,0,0,null,null,0,null,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",760,0,760,0,0,0,0,0,760,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[44.2,"Wastewater treatment"]
["44.2.1","Quality impriovement, expenditure and sources of finance"]
["44.2.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["44.2.2","Level of service improvement (including backlog infrastructure renewals), expenditure and sources of finance"]
["44.2.2.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.2.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.2.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.2.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.2.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.2.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.2.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.2.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.2.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.2.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.2.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["44.2.3","Supply demand balance, expenditure and sources of finance"]
["44.2.3.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.3.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.3.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.3.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.3.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.3.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.3.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.3.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.3.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.3.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.2.3.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[44.3,"Sludge treatment and disposal"]
["44.3.1","Quality impriovement, expenditure and sources of finance"]
["44.3.1.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.1.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.1.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.1.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.1.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.1.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.1.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.1.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.1.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.1.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.1.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["44.3.2","Level of service improvement (including backlog infrastructure renewals), expenditure and sources of finance"]
["44.3.2.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.2.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.2.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.2.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.2.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.2.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.2.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.2.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.2.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.2.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.2.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["44.3.3","Supply demand balance, expenditure and sources of finance"]
["44.3.3.1",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.3.2",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.3.3",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.3.4",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.3.5",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.3.6",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.3.7",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.3.8",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.3.9",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.3.10",null,"EUR/year",null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,null,null,0,0]
["44.3.3.11","Totals","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[44.4,"Total wastewater non-infrastructure enhancement"]
["44.4.1","Non-infrastructure enhancement expenditure and sources of finance"]
["44.4.1.1","Wastewater Collection - level of service improvement","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["44.4.1.2","Wastewater Collection - supply demand balance","EUR/year",760,0,760,0,0,0,0,0,760,0,0,0,0,0,0,0,0,0,0,0,0,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",760,0,760,0,0,0,0,0,760,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["44.4.1.4","Wastewater treatment - quality improvement","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["44.4.1.5","Wastewater treatment - level of service improvement","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["44.4.1.6","Wastewater treatment -  supply demand balance","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["44.4.1.7","Total wastewater treatment ","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["44.4.1.8","Sludge treatment and disposal - quality improvement","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["44.4.1.9","Sludge treatment and disposal - level of service improvement","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["44.4.1.10","Sludge treatment and disposal - supply demand balance","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["44.4.1.11","Total sludge treatment and disposal ","EUR/year",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["44.4.1.12","Totals","EUR/year",760,0,760,0,0,0,0,0,760,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"45 - WW business activities","index":16,"n_rows":24,"n_cols":48,"rows_kept":24,"cut":false,"hidden":false,"merged":[[6,3,6,11],[6,12,6,20],[6,21,6,29],[6,30,6,38],[6,39,6,47],[8,3,8,11],[8,12,8,20],[8,21,8,29],[8,30,8,38],[8,39,8,47],[9,24,9,29],[9,30,9,32],[9,33,9,38],[9,39,9,41],[9,42,9,47],[9,3,9,5],[9,6,9,11],[9,12,9,14],[9,15,9,20],[9,21,9,23],[7,3,7,11],[7,12,7,20],[7,21,7,29],[7,30,7,38],[7,39,7,47]]}
[null,"KRU Radoniqi sh.a. Gjakovë"]
[]
[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","\"Siq është siguruar nga ZRRUM,në letrën e datës 20/6/2011\"","EUR/year",84,null,84,null,null,null,null,0,84,null,null,0,null,null,null,null,0,0,null,null,0,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","Teknologji informative","EUR/year",null,null,0,null,null,null,null,0,0,1000,null,1000,null,null,null,null,0,1000,null,null,0,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",84,0,84,0,0,0,0,0,84,1000,0,1000,0,0,0,0,0,1000,0,0,0,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,"KRU Radoniqi sh.a. Gjakovë"]
[]
[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",163426,170333.06472196901,184216.91282745672,188085.46799683332,191471.00642077634]
["51.1.1.2","Indexation adjustment","EUR",5661.0647219690136,13883.848105487694,3868.5551693765915,3385.5384239429995,3063.5361027324216]
["51.1.1.3","Opening RAB at current year price levels","EUR",169087.06472196901,184216.91282745672,188085.46799683332,191471.00642077634,194534.54252350875]
["51.1.1.4","Additions (net of disposals and grants)","EUR",1246,0,0,0,0]
["51.1.1.5","Closing RAB at current year price levels","EUR",170333.06472196901,184216.91282745672,188085.46799683332,191471.00642077634,194534.54252350875]
[]
["51.1.2","Non-infrastructure"]
["51.1.2.1","Opening RAB at prior year price levels","EUR",1610506,1639361.758666493,1722329.3888835304,1708255.4973057965,1689318.2649356637]
["51.1.2.2","Indexation adjustment","EUR",55787.810391978193,133624.37694890585,36168.917166554143,30748.598951504333,27029.092238970617]
["51.1.2.3","Opening RAB at current year price levels","EUR",1666293.8103919781,1772986.1356153989,1758498.3060500845,1739004.0962573008,1716347.3571746342]
["51.1.2.4","Additions (net of disposals and grants)","EUR",20976,0,0,0,0]
["51.1.2.5","Depreciation","EUR",-47908.051725485086,-50656.746731868538,-50242.80874428813,-49685.831321637168,-49038.495919275265]
["51.1.2.6","Closing RAB at current year price levels","EUR",1639361.758666493,1722329.3888835304,1708255.4973057965,1689318.2649356637,1667308.8612553589]
["51.1.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-49209.411110958019,-47803.427936359221,-46437.615709606092]
[]
[51.2,"Water distribution"]
[]
["51.2.1","Infrastructure"]
["51.2.1.1","Opening RAB at prior year price levels","EUR",3105096,3236338.2989972653,3500132.2337485324,3573635.0106572513,3637960.4408490821]
["51.2.1.2","Indexation adjustment","EUR",107560.2989972654,263793.93475126708,73502.776908719185,64325.430191830521,58207.367053585316]
["51.2.1.3","Opening RAB at current year price levels","EUR",3212656.2989972653,3500132.2337485324,3573635.0106572513,3637960.4408490821,3696167.8079026672]
["51.2.1.4","Additions (net of disposals and grants)","EUR",23682,0,0,0,0]
["51.2.1.5","Closing RAB at current year price levels","EUR",3236338.2989972653,3500132.2337485324,3573635.0106572513,3637960.4408490821,3696167.8079026672]
[]
["51.2.2","Non-infrastructure"]
["51.2.2.1","Opening RAB at prior year price levels","EUR",189471,192866.02557624693,202626.92002608205,200971.16862244037,198743.25966742588]
["51.2.2.2","Indexation adjustment","EUR",6563.2616226071186,15720.509744719888,4255.1653205477232,3617.4810352039262,3179.8921546788142]
["51.2.2.3","Opening RAB at current year price levels","EUR",196034.26162260713,208586.53532096682,206882.08534662978,204588.6496576443,201923.1518221047]
["51.2.2.4","Additions (net of disposals and grants)","EUR",2468,0,0,0,0]
["51.2.2.5","Depreciation","EUR",-5636.2360463602035,-5959.6152948847666,-5910.916724189422,-5845.3899902184085,-5769.2329092029913]
["51.2.2.6","Closing RAB at current year price levels","EUR",192866.02557624693,202626.92002608205,200971.16862244037,198743.25966742588,196153.91891290172]
["51.2.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-5789.3405721737736,-5623.9308415402375,-5463.2471032105159]
[]
[51.3,"Business activities"]
[]
["51.3.2","Non-infrastructure"]
["51.3.2.1","Opening RAB at prior year price levels","EUR",94736,96433.515327516609,101313.98798580928,119607.97939826809,118282.03951236729]
["51.3.2.2","Indexation adjustment","EUR",3281.6481312670962,7860.2958343458786,2127.5937477019947,2152.9436291688253,1892.5126321978767]
["51.3.2.3","Opening RAB at current year price levels","EUR",98017.648131267095,104293.81116186248,103441.58173351127,121760.92302743692,120174.55214456517]
["51.3.2.4","Additions (net of disposals and grants)","EUR",1234,0,19399,0,0]
["51.3.2.5","Depreciation","EUR",-2818.1328037504882,-2979.823176053214,-3232.6023352431789,-3478.8835150696264,-3433.5586327018618]
["51.3.2.6","Closing RAB at current year price levels","EUR",96433.515327516609,101313.98798580928,119607.97939826809,118282.03951236729,116740.9935118633]
["51.3.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-3166.1139424516937,-3347.0821155245026,-3251.4511979380877]
[]
[51.4,"Summary"]
["51.4.1","Totals"]
["51.4.1.1","Opening RAB at prior year price levels","EUR",5163235,5335332.6632894911,5710619.4434714103,5790555.1239805901,5835775.0113853151]
["51.4.1.2","Indexation adjustment","EUR",178854.08386508684,434882.96538472635,119923.00831289963,104229.9922316506,93372.400182165045]
["51.4.1.3","Opening RAB at current year price levels","EUR",5342089.0838650865,5770215.6286742175,5830542.4517843099,5894785.1162122404,5929147.4115674803]
["51.4.1.4","Additions (net of disposals and grants)","EUR",49606,0,19399,0,0]
["51.4.1.5","Depreciation","EUR",-56362.420575595774,-59596.185202806519,-59386.327803720735,-59010.104826925199,-58241.287461180116]
["51.4.1.6","Closing RAB at current year price levels","EUR",5335332.6632894911,5710619.4434714103,5790555.1239805901,5835775.0113853151,5870906.1241062991]
["51.4.1.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-58164.865625583487,-56774.440893423955,-55152.314010754693]

{"sheet":"52 - Water income","index":18,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[null,"KRU Radoniqi sh.a. Gjakovë"]
[]
[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",287802,295032,302532,310332,318132]
["52.1.1.2","Volume charges","EUR",1408212,1603834.5599999998,1861584.12,2069699.04,2342865.6]
["52.1.1.3","Total household water tariff income","EUR",1696014,1898866.5599999998,2164116.12,2380031.04,2660997.6]
[]
["52.1.2","Commercial"]
["52.1.2.1","Fixed monthly charges","EUR",117324,119178,119358,119538,119718]
["52.1.2.2","Volume charges","EUR",252581.24999999997,288145.91999999998,324653.76,329659.24,325632.95999999996]
["52.1.2.3","Total commercial water tariff income","EUR",369905.25,407323.92,444011.76,449197.24,445350.95999999996]
[]
["52.1.3","Institutional"]
["52.1.3.1","Fixed monthly charges","EUR",7902,7974,8046,8082,8118]
["52.1.3.2","Volume charges","EUR",195800.12999999998,222785.92000000001,251758.07999999999,256394.25,254005.91999999998]
["52.1.3.3","Total institutional water tariff income","EUR",203702.12999999998,230759.92,259804.08,264476.25,262123.91999999998]
[]
["52.1.4","Total water tariff income"]
["52.1.4.1","Household","EUR",1696014,1898866.5599999998,2164116.12,2380031.04,2660997.6]
["52.1.4.2","Commercial","EUR",369905.25,407323.92,444011.76,449197.24,445350.95999999996]
["52.1.4.3","Institutional","EUR",203702.12999999998,230759.92,259804.08,264476.25,262123.91999999998]
["52.1.4.3","Total water tariff income","EUR",2269621.38,2536950.4,2867931.96,3093704.5300000003,3368472.48]
[]
[52.2,"Connection fees"]
[]
["52.2.1","Connection fees"]
["52.2.1.1","Household","EUR",21780,21600,23400,23400,23400]
["52.2.1.2","Commercial","EUR",8820,450,450,450,450]
["52.2.1.3","Institutional","EUR",3,9,3,3,3]
["52.2.1.4","Total connection fee income","EUR",30603,22059,23853,23853,23853]
[]
[52.3,"Total income from customers"]
[]
["52.3.1","Total income from customers"]
["52.3.1.1","Tariff income","EUR",2269621.38,2536950.4,2867931.96,3093704.5300000003,3368472.48]
["52.3.1.2","Connection fees","EUR",30603,22059,23853,23853,23853]
["52.3.1.3","Total income from customers","EUR",2300224.38,2559009.4,2891784.96,3117557.5300000003,3392325.48]
[]
[52.4,"Cash collection"]
[]
["52.4.1","Cash collection by category (excluding connection fees), excluding VAT"]
["52.4.1.1","Household","EUR",1187209.7999999998,1329206.5919999997,1601445.9288000001,1808823.5904000001,2075578.1280000003]
["52.4.1.2","Commercial","EUR",136864.9425,276980.26559999998,333008.82,350373.84720000002,365187.78719999996]
["52.4.1.3","Institutional","EUR",183331.91699999999,207683.92800000001,244215.83519999997,253897.19999999998,256881.44159999999]
["52.4.1.4","Total cash collection","EUR",1507406.6594999996,1813870.7855999998,2178670.5840000003,2413094.6376000005,2697647.3568000002]
[]
[52.5,"Provisions for debts write off (offset by 12 months)"]
[]
["52.5.1","Write-off provisions (excluding VAT)"]
["52.5.1.1","Household","EUR",602444,508804.20000000019,569659.96800000011,562670.1912,571207.44959999993]
["52.5.1.2","Commercial","EUR",0,233040.3075,130343.6544,111002.94,98823.392799999972]
["52.5.1.3","Institutional","EUR",0,20370.212999999989,23075.991999999998,15588.244800000015,10579.050000000017]
["52.5.1.4","Total provision for write-off","EUR",602444,762214.72050000017,723079.61440000008,689261.37599999993,680609.89240000001]
[]
["52.5.2","VAT paid on bad debts"]
["52.5.2.1","VAT paid on bad debts","EUR",0,0,0,0,0]

{"sheet":"61 - WW RAB","index":19,"n_rows":82,"n_cols":9,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
[null,"KRU Radoniqi sh.a. Gjakovë"]
[]
[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",1065331,1102233.9881494986,1192077.0805235642,1217110.699214559,1239018.6918004211]
["61.1.1.2","Indexation adjustment","EUR",36902.988149498684,89843.092374065629,25033.618690994852,21907.992585862063,19824.299068806737]
["61.1.1.3","Opening RAB at current year price levels","EUR",1102233.9881494986,1192077.0805235642,1217110.699214559,1239018.6918004211,1258842.9908692278]
["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",1102233.9881494986,1192077.0805235642,1217110.699214559,1239018.6918004211,1258842.9908692278]
[]
["61.1.2","Non-infrastrucutre"]
["61.1.2.1","Opening RAB at prior year price levels","EUR",357306,359869.82367495768,378082.73263119766,374993.25658741134,370836.18848581379]
["61.1.2.2","Indexation adjustment","EUR",12377.053783044683,29332.9893277458,7939.7373852551518,6749.8786185734034,5933.3790157730209]
["61.1.2.3","Opening RAB at current year price levels","EUR",369683.05378304468,389202.81300270348,386022.47001645283,381743.13520598476,376769.5675015868]
["61.1.2.4","Additions (net of disposals and grants)","EUR",760,0,0,0,0]
["61.1.2.5","Depreciation","EUR",-10573.230108086991,-11120.080371505814,-11029.213429041509,-10906.946720170992,-10764.844785759624]
["61.1.2.6","Closing RAB at current year price levels","EUR",359869.82367495768,378082.73263119766,374993.25658741134,370836.18848581379,366004.72271582717]
["61.1.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-10802.363789462792,-10493.724824049568,-10193.90411479101]
[]
[61.2,"Wastewater treatment"]
[]
["61.2.1","Infrastructure"]
["61.2.1.1","Opening RAB at prior year price levels","EUR",0,0,0,0,0]
["61.2.1.2","Indexation adjustment","EUR",0,0,0,0,0]
["61.2.1.3","Opening RAB at current year price levels","EUR",0,0,0,0,0]
["61.2.1.4","Additions (net of disposals and grants)","EUR",0,0,0,0,0]
["61.2.1.5","Closing RAB at current year price levels","EUR",0,0,0,0,0]
[]
["61.2.2","Non-infrastrucutre"]
["61.2.2.1","Opening RAB at prior year price levels","EUR",0,0,0,0,0]
["61.2.2.2","Indexation adjustment","EUR",0,0,0,0,0]
["61.2.2.3","Opening RAB at current year price levels","EUR",0,0,0,0,0]
["61.2.2.4","Additions (net of disposals and grants)","EUR",0,0,0,0,0]
["61.2.2.5","Depreciation","EUR",0,0,0,0,0]
["61.2.2.6","Closing RAB at current year price levels","EUR",0,0,0,0,0]
["61.2.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",0,0,0]
[]
[61.3,"Sludge treatment and disposal"]
[]
["61.3.1","Infrastructure"]
["61.3.1.1","Opening RAB at prior year price levels","EUR",0,0,0,0,0]
["61.3.1.2","Indexation adjustment","EUR",0,0,0,0,0]
["61.3.1.3","Opening RAB at current year price levels","EUR",0,0,0,0,0]
["61.3.1.4","Additions (net of disposals and grants)","EUR",0,0,0,0,0]
["61.3.1.5","Closing RAB at current year price levels","EUR",0,0,0,0,0]
[]
["61.3.2","Non-infrastrucutre"]
["61.3.2.1","Opening RAB at prior year price levels","EUR",0,0,0,0,0]
["61.3.2.2","Indexation adjustment","EUR",0,0,0,0,0]
["61.3.2.3","Opening RAB at current year price levels","EUR",0,0,0,0,0]
["61.3.2.4","Additions (net of disposals and grants)","EUR",0,0,0,0,0]
["61.3.2.5","Depreciation","EUR",0,0,0,0,0]
["61.3.2.6","Closing RAB at current year price levels","EUR",0,0,0,0,0]
["61.3.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",0,0,0]
[]
[61.4,"Business activities"]
[]
["61.4.2","Non-infrastrucutre"]
["61.4.2.1","Opening RAB at prior year price levels","EUR",39701,39902.632894908194,41922.093744967242,41579.530350365509,41118.591556767169]
["61.4.2.2","Indexation adjustment","EUR",1375.239744758434,3252.4636072639669,880.36396864431208,748.43154630657909,657.89746490827474]
["61.4.2.3","Opening RAB at current year price levels","EUR",41076.239744758437,43155.096502172164,42802.457713611555,42327.961896672088,41776.489021675443]
["61.4.2.4","Additions (net of disposals and grants)","EUR",0,0,0,0,0]
["61.4.2.5","Depreciation","EUR",-1173.6068498502411,-1233.0027572049189,-1222.9273632460445,-1209.3703399049168,-1193.6139720478698]
["61.4.2.6","Closing RAB at current year price levels","EUR",39902.632894908194,41922.093744967242,41579.530350365509,41118.591556767169,40582.875049627575]
["61.4.2.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-1197.7741069990643,-1163.5519896562337,-1130.3076470946269]
[]
[61.5,"Summary"]
["61.5.1","Totals"]
["61.5.1.1","Opening RAB at prior year price levels","EUR",1462338,1502006.4447193644,1612081.906899729,1633683.4861523358,1650973.4718430021]
["61.5.1.2","Indexation adjustment","EUR",50655.281677301806,122428.5453090754,33853.720044894319,29406.302750742045,26415.575549488032]
["61.5.1.3","Opening RAB at current year price levels","EUR",1512993.2816773017,1624434.9900284398,1645935.6269446237,1663089.7889030781,1677389.0473924901]
["61.5.1.4","Additions (net of disposals and grants)","EUR",760,0,0,0,0]
["61.5.1.5","Depreciation","EUR",-11746.836957937232,-12353.083128710732,-12252.140792287553,-12116.317060075909,-11958.458757807493]
["61.5.1.6","Closing RAB at current year price levels","EUR",1502006.4447193644,1612081.906899729,1633683.4861523358,1650973.4718430021,1665430.5886346826]
["61.5.1.7","Current cost depreciation at base year price levels","EUR","N/A","N/A",-12000.137896461856,-11657.276813705801,-11324.211761885637]

{"sheet":"62 - WW income","index":20,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,"KRU Radoniqi sh.a. Gjakovë"]
[]
[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",132790,144763.20000000001,212118.47999999998,285359.76,397327.68]
["62.1.1.2","Commercial","EUR",41744.033829395521,42606.080000000002,63060.480000000003,88204.160000000003,118241.12]
["62.1.1.3","Institutional","EUR",19710.687266514808,20485.429367945828,30914.365279642061,44227.753897550116,60568.115254988916]
["62.1.1.4","Total water tariff income","EUR",194244.72109591032,207854.70936794585,306093.32527964201,417791.67389755015,576136.91525498894]
[]
[62.2,"Connection fees"]
[]
["62.2.1","Connection fees"]
["62.2.1.1","Household","EUR",5520,14400,15600,15600,15600]
["62.2.1.2","Commercial","EUR",3840,3000,3000,3000,3000]
["62.2.1.3","Institutional","EUR",180,300,300,300,300]
["62.2.1.4","Total connection fee income","EUR",9540,17700,18900,18900,18900]
[]
[62.3,"Total income from customers"]
[]
["62.3.1","Total income from customers"]
["62.3.1.1","Tariff income","EUR",194244.72109591032,207854.70936794585,306093.32527964201,417791.67389755015,576136.91525498894]
["62.3.1.2","Connection fees","EUR",9540,17700,18900,18900,18900]
["62.3.1.3","Total income from customers","EUR",203784.72109591032,225554.70936794585,324993.32527964201,436691.67389755015,595036.91525498894]
[]
[62.4,"Cash collection"]
[]
["62.4.1","Cash collection by category (excluding connection fees), excluding VAT"]
["62.4.1.1","Household","EUR",92953,101334.24,156967.6752,216873.41760000002,309915.59039999999]
["62.4.1.2","Commercial","EUR",15445.292516876343,28972.134400000003,47295.360000000001,68799.2448,96957.718399999983]
["62.4.1.3","Institutional","EUR",17739.618539863328,18436.886431151244,29059.503362863536,42458.643741648113,59356.752949889138]
["62.4.1.4","Total cash collection","EUR",126137.91105673967,148743.26083115124,233322.53856286351,328131.30614164815,466230.06174988917]
[]
[62.5,"Provisions for write off (offset by 12 months)"]
[]
["62.5.1","Write-off provisions (excluding VAT)"]
["62.5.1.1","Household","EUR",190246,39837,43428.960000000006,55150.804799999984,68486.342399999994]
["62.5.1.2","Commercial","EUR",0,26298.741312519178,13633.945599999999,15765.120000000003,19404.915200000003]
["62.5.1.3","Institutional","EUR",0,1971.0687266514797,2048.5429367945835,1854.8619167785255,1769.1101559020026]
["62.5.1.4","Total provision for write-off","EUR",190246,68106.810039170668,59111.448536794589,72770.786716778501,89660.367755902]
[]
["62.5.2","VAT paid on bad debts"]
["62.5.2.1","VAT paid on bad debts","EUR",0,0,0,0,0]

{"sheet":"81- 2010 Inc-Exp ","index":21,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[6,3,6,5],[6,6,6,9]]}
[null,"KRU Radoniqi sh.a. Gjakovë"]
[]
[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,2269621.38,null,null,null,194244.72109591032,2463866.1010959102]
[]
[81.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["81.2.1.1","Service charges","EUR",20803,0,20803,0,0,0,0,20803]
["81.2.1.2","Energy costs","EUR",52822.81,75000,127822.81,950,0,0,950,128772.81]
["81.2.1.3","Fuel costs","EUR",2448.16,25326,27774.16,2935.88,0,0,2935.88,30710.04]
["81.2.1.4","Staff costs","EUR",138873.29,550236,689109.29,81612.600000000006,0,0,81612.600000000006,770721.89]
["81.2.1.5","Materials and consumables","EUR",21746,40624,62370,0,0,0,0,62370]
["81.2.1.6","Contracted services","EUR",9600,0,9600,0,0,0,0,9600]
["81.2.1.7","Maintenance and repair","EUR",3110,12370.68,15480.68,156,0,0,156,15636.68]
["81.2.1.8","Other direct costs","EUR",22644.75,16982,39626.75,7555.35,0,0,7555.35,47182.1]
["81.2.1.9","Total Direct costs","EUR",272048.01,720538.68,992586.69000000006,93209.830000000016,0,0,93209.830000000016,1085796.52]
[]
[81.3,"Indirect costs"]
[]
["81.3.1.","Business activities"]
["81.3.1.1","Energy costs","EUR",null,null,16345.45,null,null,null,50,16395.45]
["81.3.1.2","Fuel costs","EUR",null,null,11123.33,null,null,null,154.52000000000001,11277.85]
["81.3.1.3","Staff costs","EUR",null,null,541551,null,null,null,4295.3999999999996,545846.4]
["81.3.1.4","Materials and consumables","EUR",null,null,2432,null,null,null,128,2560]
["81.3.1.5","Contracted services","EUR",null,null,0,null,null,null,0,0]
["81.3.1.6","Maintenance and repair","EUR",null,null,0,null,null,null,0,0]
["81.3.1.7","Other indirect costs","EUR",null,null,254960,null,null,null,397.65,255357.65]
["81.3.1.8","Total Busiiness activities costs","EUR",null,null,826411.78,null,null,null,5025.57,831437.35]
[]
["81.3.2.","Other indirect costs"]
["81.3.2.1","Bad debts","EUR",null,null,602444,null,null,null,190246,792690]
["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,602444,null,null,null,190246,792690]
["81.3.2.4","Total all indirect costs","EUR",null,null,1428855.78,null,null,null,195271.57,1624127.35]
["81.3.2.5","Total direct and indirect costs","EUR",null,null,2421442.4700000002,null,null,null,288481.40000000002,2709923.87]
[]
[81.400000000000006,"Net Income before cap maintenance"]
[]
["81.4.1","Net income"]
["81.4.1.1.","Net income before capital maintenance","EUR",null,null,-151821.09000000032,null,null,null,-94236.678904089698,-246057.76890408993]
[]
[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",47908.051725485086,5636.2360463602035,53544.287771845287,10573.230108086991,0,0,10573.230108086991,64117.517879932275]
["81.5.1.3","Depreciation (business activities)","EUR",null,null,2818.1328037504882,null,null,null,11746.836957937232,14564.96976168772]
["81.5.1.4","Total capital maintenance","EUR",47908.051725485086,5636.2360463602035,56362.420575595774,10573.230108086991,0,0,22320.067066024225,78682.487641619999]
[]
[81.599999999999994,"Net Income"]
[]
["81.6.1","Net income"]
["81.6.1.1","Net income before taxes and dividends","EUR",null,null,-208183.5105755961,null,null,null,-116556.74597011393,-324740.25654570991]

{"sheet":"82 - 2011 Inc-Exp","index":22,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[6,3,6,5],[6,6,6,9]]}
[null,"KRU Radoniqi sh.a. Gjakovë"]
[]
[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,2536950.4,null,null,null,207854.70936794585,2744805.1093679457]
[]
[82.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["82.2.1.1","Service charges","EUR",20803,0,20803,0,0,0,0,20803]
["82.2.1.2","Energy costs","EUR",52000,76200,128200,1425,0,0,1425,129625]
["82.2.1.3","Fuel costs","EUR",2500,26000,28500,3040,0,0,3040,31540]
["82.2.1.4","Staff costs","EUR",139000,551000,690000,82650,0,0,82650,772650]
["82.2.1.5","Materials and consumables","EUR",20200,40236,60436,0,0,0,0,60436]
["82.2.1.6","Contracted services","EUR",9600,0,9600,0,0,0,0,9600]
["82.2.1.7","Maintenance and repair","EUR",3100,12990,16090,1000,0,0,1000,17090]
["82.2.1.8","Other direct costs","EUR",12000,11000,23000,7342.55,0,0,7342.55,30342.55]
["82.2.1.9","Total Direct costs","EUR",259203,717426,976629,95457.55,0,0,95457.55,1072086.55]
[]
[82.3,"Indirect costs"]
[]
["82.3.1.","Business activities"]
["82.3.1.1","Energy costs","EUR",null,null,16230,null,null,null,75,16305]
["82.3.1.2","Fuel costs","EUR",null,null,10000,null,null,null,160,10160]
["82.3.1.3","Staff costs","EUR",null,null,543000,null,null,null,4350,547350]
["82.3.1.4","Materials and consumables","EUR",null,null,2185,null,null,null,115,2300]
["82.3.1.5","Contracted services","EUR",null,null,0,null,null,null,0,0]
["82.3.1.6","Maintenance and repair","EUR",null,null,0,null,null,null,0,0]
["82.3.1.7","Other indirect costs","EUR",null,null,206330,null,null,null,385,206715]
["82.3.1.8","Total Busiiness activities costs","EUR",null,null,777745,null,null,null,5085,782830]
[]
["82.3.2.","Other indirect costs"]
["82.3.2.1","Bad debts","EUR",null,null,762214.72050000017,null,null,null,68106.810039170668,830321.53053917084]
["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,762214.72050000017,null,null,null,68106.810039170668,830321.53053917084]
["82.3.2.4","Total all indirect costs","EUR",null,null,1539959.7205000003,null,null,null,73191.810039170668,1613151.5305391708]
["82.3.2.5","Total direct and indirect costs","EUR",null,null,2516588.7205000003,null,null,null,168649.36003917066,2685238.0805391707]
[]
[82.4,"Net Income before cap maintenance"]
[]
["82.4.1","Net income"]
["82.4.1.1.","Net income before capital maintenance","EUR",null,null,20361.67949999962,null,null,null,39205.349328775192,59567.028828775045]
[]
[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",50656.746731868538,5959.6152948847666,56616.362026753304,11120.080371505814,0,0,11120.080371505814,67736.442398259125]
["82.5.1.3","Depreciation (business activities)","EUR",null,null,2979.823176053214,null,null,null,12353.083128710732,15332.906304763947]
["82.5.1.4","Total capital maintenance","EUR",50656.746731868538,5959.6152948847666,59596.185202806519,11120.080371505814,0,0,23473.163500216546,83069.348703023061]
[]
[82.6,"Net Income"]
[]
["82.6.1","Net income"]
["82.6.1.1","Net income before taxes and dividends","EUR",null,null,-39234.505702806899,null,null,null,15732.185828558646,-23502.319874248016]

{"sheet":"83 - 2012 Inc-Exp","index":23,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[6,3,6,5],[6,6,6,9]]}
[null,"KRU Radoniqi sh.a. Gjakovë"]
[]
[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,2867931.96,null,null,null,306093.32527964201,3174025.2852796419]
[]
[83.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["83.2.1.1","Service charges","EUR",21239.862999999998,0,21239.862999999998,0,0,0,0,21239.862999999998]
["83.2.1.2","Energy costs","EUR",53091.999999999993,88010.2,141102.19999999998,1454.925,0,0,1454.925,142557.12499999997]
["83.2.1.3","Fuel costs","EUR",2552.4999999999995,34714,37266.5,3103.8399999999997,0,0,3103.8399999999997,40370.339999999997]
["83.2.1.4","Staff costs","EUR",141919,554258.01799999992,696177.01799999992,49323.488999999994,0,0,49323.488999999994,745500.50699999987]
["83.2.1.5","Materials and consumables","EUR",20624.199999999997,41080.955999999998,61705.155999999995,0,0,0,0,61705.155999999995]
["83.2.1.6","Contracted services","EUR",9801.5999999999985,0,9801.5999999999985,0,0,0,0,9801.5999999999985]
["83.2.1.7","Maintenance and repair","EUR",3165.1,13926.439999999999,17091.539999999997,1020.9999999999999,0,0,1020.9999999999999,18112.539999999997]
["83.2.1.8","Other direct costs","EUR",12251.999999999998,15314.999999999998,27566.999999999996,7496.7435499999992,0,0,7496.7435499999992,35063.743549999999]
["83.2.1.9","Total Direct costs","EUR",264646.26299999998,747304.61399999983,1011950.8769999999,62399.997549999993,0,0,62399.997549999993,1074350.8745499998]
[]
[83.3,"Indirect costs"]
[]
["83.3.1.","Business activities"]
["83.3.1.1","Energy costs","EUR",null,null,16570.829999999998,null,null,null,76.574999999999989,16647.404999999999]
["83.3.1.2","Fuel costs","EUR",null,null,10209.999999999998,null,null,null,163.35999999999999,10373.359999999999]
["83.3.1.3","Staff costs","EUR",null,null,325041.47599999997,null,null,null,18837.449999999997,343878.92599999998]
["83.3.1.4","Materials and consumables","EUR",null,null,2230.8849999999998,null,null,null,117.41499999999999,2348.2999999999997]
["83.3.1.5","Contracted services","EUR",null,null,0,null,null,null,0,0]
["83.3.1.6","Maintenance and repair","EUR",null,null,0,null,null,null,0,0]
["83.3.1.7","Other indirect costs","EUR",null,null,210662.93,null,null,null,393.08499999999998,211056.01499999998]
["83.3.1.8","Total Busiiness activities costs","EUR",null,null,564716.12100000004,null,null,null,19587.884999999998,584304.00600000005]
[]
["83.3.2.","Other indirect costs"]
["83.3.2.1","Bad debts","EUR",null,null,723079.61440000008,null,null,null,59111.448536794589,782191.06293679471]
["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,723079.61440000008,null,null,null,59111.448536794589,782191.06293679471]
["83.3.2.4","Total all indirect costs","EUR",null,null,1287795.7354000001,null,null,null,78699.333536794584,1366495.0689367948]
["83.3.2.5","Total direct and indirect costs","EUR",null,null,2299746.6124,null,null,null,141099.33108679458,2440845.9434867948]
[]
[83.4,"Net Income before cap maintenance"]
[]
["83.4.1","Net income"]
["83.4.1.1.","Net income before capital maintenance","EUR",null,null,568185.34759999998,null,null,null,164993.99419284743,733179.34179284703]
[]
[83.5,"Capital maintenance"]
[]
["83.5.1","Capital maintenance"]
["83.5.1.1","Infrastructure renewals","EUR",10209.999999999998,377190.16333009891,387400.16333009891,138958.3867328777,0,0,138958.3867328777,526358.55006297654]
["83.5.1.2","Depreciation (service activities)","EUR",50242.80874428813,5910.916724189422,56153.725468477554,11029.213429041509,0,0,11029.213429041509,67182.938897519067]
["83.5.1.3","Depreciation (business activities)","EUR",null,null,3232.6023352431789,null,null,null,12252.140792287553,15484.743127530732]
["83.5.1.4","Total capital maintenance","EUR",60452.80874428813,383101.08005428832,446786.49113381963,149987.6001619192,0,0,162239.74095420676,609026.23208802636]
[]
[83.6,"Net Income"]
[]
["83.6.1","Net income"]
["83.6.1.1","Net income before taxes and dividends","EUR",null,null,121398.85646618035,null,null,null,2754.2532386406674,124153.10970482067]

{"sheet":"84 - 2013 Inc-Exp","index":24,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[6,3,6,5],[6,6,6,9]]}
[null,"KRU Radoniqi sh.a. Gjakovë"]
[]
[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,3093704.5300000003,null,null,null,417791.67389755015,3511496.2038975502]
[]
[84.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["84.2.1.1","Service charges","EUR",21622.180533999999,0,21622.180533999999,0,0,0,0,21622.180533999999]
["84.2.1.2","Energy costs","EUR",54047.655999999995,89594.383599999986,143642.03959999999,1481.1136499999998,0,0,1481.1136499999998,145123.15325]
["84.2.1.3","Fuel costs","EUR",2598.4449999999997,35338.851999999999,37937.296999999999,3159.7091199999995,0,0,3159.7091199999995,41097.006119999998]
["84.2.1.4","Staff costs","EUR",144473.54199999999,564234.66232399992,708708.20432399993,50211.311801999997,0,0,50211.311801999997,758919.51612599997]
["84.2.1.5","Materials and consumables","EUR",20995.435599999997,41820.413207999998,62815.848807999995,0,0,0,0,62815.848807999995]
["84.2.1.6","Contracted services","EUR",9978.0288,0,9978.0288,0,0,0,0,9978.0288]
["84.2.1.7","Maintenance and repair","EUR",3222.0717999999997,14883.892959999999,18105.964759999999,1039.3779999999999,0,0,1039.3779999999999,19145.34276]
["84.2.1.8","Other direct costs","EUR",12472.535999999998,15590.669999999998,28063.205999999998,7631.6849338999991,0,0,7631.6849338999991,35694.890933899995]
["84.2.1.9","Total Direct costs","EUR",269409.89573400002,761462.87409199995,1030872.769826,63523.197505899989,0,0,63523.197505899989,1094395.9673319]
[]
[84.3,"Indirect costs"]
[]
["84.3.1.","Business activities"]
["84.3.1.1","Energy costs","EUR",null,null,16869.104939999997,null,null,null,77.95335,16947.058289999997]
["84.3.1.2","Fuel costs","EUR",null,null,10393.779999999999,null,null,null,166.30047999999999,10560.080479999999]
["84.3.1.3","Staff costs","EUR",null,null,330892.22256799997,null,null,null,19176.524099999999,350068.74666799995]
["84.3.1.4","Materials and consumables","EUR",null,null,2271.0409299999997,null,null,null,119.52846999999998,2390.5693999999999]
["84.3.1.5","Contracted services","EUR",null,null,0,null,null,null,0,0]
["84.3.1.6","Maintenance and repair","EUR",null,null,0,null,null,null,0,0]
["84.3.1.7","Other indirect costs","EUR",null,null,214454.86273999998,null,null,null,400.16052999999999,214855.02326999998]
["84.3.1.8","Total Busiiness activities costs","EUR",null,null,574881.01117800002,null,null,null,19940.466930000002,594821.47810800001]
[]
["84.3.2.","Other indirect costs"]
["84.3.2.1","Bad debts","EUR",null,null,689261.37599999993,null,null,null,72770.786716778501,762032.16271677846]
["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,689261.37599999993,null,null,null,72770.786716778501,762032.16271677846]
["84.3.2.4","Total all indirect costs","EUR",null,null,1264142.3871780001,null,null,null,92711.253646778496,1356853.6408247785]
["84.3.2.5","Total direct and indirect costs","EUR",null,null,2295015.1570040002,null,null,null,156234.45115267849,2451249.6081566783]
[]
[84.4,"Net Income before cap maintenance"]
[]
["84.4.1","Net income"]
["84.4.1.1.","Net income before capital maintenance","EUR",null,null,798689.37299600011,null,null,null,261557.22274487166,1060246.595740872]
[]
[84.5,"Capital maintenance"]
[]
["84.5.1","Capital maintenance"]
["84.5.1.1","Infrastructure renewals","EUR",10393.779999999999,383979.58627004066,394373.36627004063,151853.4176940695,0,0,151853.4176940695,546226.78396411007]
["84.5.1.2","Depreciation (service activities)","EUR",49685.831321637168,5845.3899902184085,55531.221311855574,10906.946720170992,0,0,10906.946720170992,66438.168032026559]
["84.5.1.3","Depreciation (business activities)","EUR",null,null,3478.8835150696264,null,null,null,12116.317060075909,15595.200575145536]
["84.5.1.4","Total capital maintenance","EUR",60079.611321637167,389824.97626025905,453383.47109696583,162760.3644142405,0,0,174876.6814743164,628260.15257128223]
[]
[84.6,"Net Income"]
[]
["84.6.1","Net income"]
["84.6.1.1","Net income before taxes and dividends","EUR",null,null,345305.90189903427,null,null,null,86680.541270555259,431986.44316958974]

{"sheet":"85 - 2014 Inc-Exp","index":25,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[6,3,6,5],[6,6,6,9]]}
[null,"KRU Radoniqi sh.a. Gjakovë"]
[]
[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,3368472.48,null,null,null,576136.91525498894,3944609.3952549892]
[]
[85.2,"Direct costs"]
[]
["$0.2.1","Direct costs"]
["85.2.1.1","Service charges","EUR",21968.135422544001,0,21968.135422544001,0,0,0,0,21968.135422544001]
["85.2.1.2","Energy costs","EUR",54912.418495999998,91027.893737599996,145940.31223360001,1504.8114684,0,0,1504.8114684,147445.12370200001]
["85.2.1.3","Fuel costs","EUR",2640.0201200000001,35904.273632000004,38544.293752000005,3210.26446592,0,0,3210.26446592,41754.558217920006]
["85.2.1.4","Staff costs","EUR",146785.11867200001,573262.41692118405,720047.53559318406,51014.692790831999,0,0,51014.692790831999,771062.22838401608]
["85.2.1.5","Materials and consumables","EUR",21331.362569600002,42489.539819327998,63820.902388928,0,0,0,0,63820.902388928]
["85.2.1.6","Contracted services","EUR",10137.677260800001,0,10137.677260800001,0,0,0,0,10137.677260800001]
["85.2.1.7","Maintenance and repair","EUR",3273.6249488000003,15877.081001680001,19150.705950480002,1056.0080480000001,0,0,1056.0080480000001,20206.713998480001]
["85.2.1.8","Other direct costs","EUR",12672.096576,15840.120720000001,28512.217296000003,7753.7918928424006,0,0,7753.7918928424006,36266.009188842407]
["85.2.1.9","Total Direct costs","EUR",273720.45406574401,774401.32583179208,1048121.7798975362,64539.568665994404,0,0,64539.568665994404,1112661.3485635305]
[]
[85.3,"Indirect costs"]
[]
["85.3.1.","Business activities"]
["85.3.1.1","Energy costs","EUR",null,null,17139.01061904,null,null,null,76.574999999999989,17215.585619040001]
["85.3.1.2","Fuel costs","EUR",null,null,10560.080480000001,null,null,null,163.35999999999999,10723.440480000001]
["85.3.1.3","Staff costs","EUR",null,null,336186.49812908802,null,null,null,18837.449999999997,355023.94812908804]
["85.3.1.4","Materials and consumables","EUR",null,null,2307.3775848800001,null,null,null,117.41499999999999,2424.79258488]
["85.3.1.5","Contracted services","EUR",null,null,0,null,null,null,0,0]
["85.3.1.6","Maintenance and repair","EUR",null,null,0,null,null,null,0,0]
["85.3.1.7","Other indirect costs","EUR",null,null,217886.14054384001,null,null,null,393.08499999999998,218279.22554384]
["85.3.1.8","Total Busiiness activities costs","EUR",null,null,584079.10735684796,null,null,null,19587.884999999998,603666.99235684797]
[]
["85.3.2.","Other indirect costs"]
["85.3.2.1","Bad debts","EUR",null,null,680609.89240000001,null,null,null,89660.367755902,770270.26015590201]
["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,680609.89240000001,null,null,null,89660.367755902,770270.26015590201]
["85.3.2.4","Total all indirect costs","EUR",null,null,1264688.999756848,null,null,null,109248.25275590199,1373937.25251275]
["85.3.2.5","Total direct and indirect costs","EUR",null,null,2312810.7796543841,null,null,null,173787.8214218964,2486598.6010762807]
[]
[85.4,"Net Income before cap maintenance"]
[]
["85.4.1","Net income"]
["85.4.1.1.","Net income before capital maintenance","EUR",null,null,1055661.7003456159,null,null,null,402349.09383309254,1458010.7941787085]
[]
[85.5,"Capital maintenance"]
[]
["85.5.1","Capital maintenance"]
["85.5.1.1","Infrastructure renewals","EUR",10560.080480000001,390123.25965036137,400683.34013036138,164147.45564613299,0,0,164147.45564613299,564830.79577649431]
["85.5.1.2","Depreciation (service activities)","EUR",49038.495919275265,5769.2329092029913,54807.728828478255,10764.844785759624,0,0,10764.844785759624,65572.573614237874]
["85.5.1.3","Depreciation (business activities)","EUR",null,null,3433.5586327018618,null,null,null,11958.458757807493,15392.017390509354]
["85.5.1.4","Total capital maintenance","EUR",59598.576399275262,395892.49255956436,458924.6275915415,174912.30043189263,0,0,186870.75918970013,645795.38678124163]
[]
[85.6,"Net Income"]
[]
["85.6.1","Net income"]
["85.6.1.1","Net income before taxes and dividends","EUR",null,null,596737.07275407435,null,null,null,215478.33464339242,812215.40739746683]