{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["HOME","1. SUMMARY OF INDICATORS","2. TOTAL WASTE COLLECTED ","3. TOTAL WASTE GENERATED","4. WASTE MORPHOLOGY","5. LANDFILL DEPOSITING","6. WASTE RECOVERY ","7. C&T COST COVERAGE","8. INVESTMENT FINANCING","9. SW NARRATIVE INFO"],"not_rendered":{"charts":9,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":6,"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":"HOME","index":0,"n_rows":49,"n_cols":7,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,2,10],[14,6,14,9],[17,6,17,9],[7,5,14,5],[7,6,7,9],[8,6,8,9],[9,6,9,9],[10,6,10,9],[11,6,11,9],[12,6,12,9],[13,6,13,9]]}
["Important Notice: In order for SWIS to work properly it is necessary to enable Macros before you start entering data\nImportant Notice: When saving file use option Excel Macro-Enabled Workbook"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"DATA ENTRY","2. TOTAL WASTE COLLECTED"]
[null,null,null,null,null,null,"3. TOTAL WASTE GENERATED"]
[null,null,null,null,null,null,"4. WASTE MORPHOLOGY"]
[null,null,null,null,null,null,"5. LANDFILL DEPOSITING"]
[null,null,null,null,null,null,"6. WASTE RECOVERY"]
[null,null,null,null,null,null,"7. C&T COST COVERAGE"]
[null,null,null,null,null,null,"8. INVESTMENT FINANCING"]
[null,null,null,null,null,null,"9. SW NARRATIVE INFO"]
[]
[]
[null,null,null,null,null,"RESULT","1. SUMMARY OF INDICATORS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Milisav Aleksic, freelance consultant, Belgrade, Serbia, milisav.aleksic@gmai.com "]

{"sheet":"1. SUMMARY OF INDICATORS","index":1,"n_rows":63,"n_cols":6,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[null,"Data for year",{"$f":"'2. TOTAL WASTE COLLECTED '!E1","v":0}]
[null,{"$f":"'2. TOTAL WASTE COLLECTED '!B2:F2","v":0}]
[null,"Area in km2",{"$f":"IFERROR('2. TOTAL WASTE COLLECTED '!C3,\"\")","v":0}]
[null,"Total Population ",{"$f":"IFERROR('2. TOTAL WASTE COLLECTED '!C4,\"\")","v":0}]
[null,"Total households",{"$f":"IFERROR('2. TOTAL WASTE COLLECTED '!C5,\"\")","v":0}]
[null,"SUMMARY OF MUNICIPAL WASTE MANAGEMENT INDICATORS",null,"Indicator Range","from","to"]
["I","MUNICIPAL WASTE COLLECTION AND TRANSPORT"]
[1,{"$f":"'7. C&T COST COVERAGE'!G5","v":"Total households served"},{"$f":"IFERROR('7. C&T COST COVERAGE'!I5,\"\")","v":""},"> 70%",0.7,1]
[2,"Service coverage urban areas",{"$f":"IFERROR('7. C&T COST COVERAGE'!I6,\"\")","v":""},"> 90%",0.9,1]
[3,"Service coverage rural areas",{"$f":"IFERROR('7. C&T COST COVERAGE'!I7,\"\")","v":""},"> 60%",0.6,1]
[4,"AVERAGE waste collected household/kg/day",{"$f":"IFERROR('2. TOTAL WASTE COLLECTED '!J10,\"\")","v":""},"1,05 - 3,6kg",1.0499999999999998,3.5999999999999996]
[5,{"$f":"'3. TOTAL WASTE GENERATED'!B6","v":"Average waste generation per capita/kg/day"},{"$f":"IFERROR('3. TOTAL WASTE GENERATED'!C6,\"\")","v":""},"0,35 - 1,2kg",0.35,1.2]
[6,{"$f":"'7. C&T COST COVERAGE'!B22","v":"Quantity of waste collected annually per SWM employee/tons"},{"$f":"IFERROR('7. C&T COST COVERAGE'!C22,\"\")","v":""},"> 650 ton/Empl.",650,1600]
[7,{"$f":"'7. C&T COST COVERAGE'!B23","v":"Population served per SWM Employee"},{"$f":"IFERROR('7. C&T COST COVERAGE'!C23,\"\")","v":""},"> 1300 PE / Empl.",1300,7000]
[8,{"$f":"'7. C&T COST COVERAGE'!B24","v":"Employees in SWM per 1000 population served "},{"$f":"IFERROR('7. C&T COST COVERAGE'!C24:D24,\"\")","v":""},"1 - 2 Empl/1000 PE",1,2]
[9,{"$f":"'7. C&T COST COVERAGE'!B21","v":"Employment ratio administrative to operative employees 1:"},{"$f":"IFERROR('7. C&T COST COVERAGE'!C21:D21,\"\")","v":""},null,14,25]
[10,{"$f":"'9. SW NARRATIVE INFO'!C55","v":"SUM Collection Volume provided in m3"},{"$f":"'9. SW NARRATIVE INFO'!H55","v":0},null,{"$f":"C18","v":""},{"$f":"C19","v":""}]
[11,"Service Volume required in m³ under current collection rate",{"$f":"IFERROR(('2. TOTAL WASTE COLLECTED '!C10*'2. TOTAL WASTE COLLECTED '!J10)/'2. TOTAL WASTE COLLECTED '!G10/1000,\"\")","v":""}]
[12,"Service Volume required in m³ under 100% collection rate",{"$f":"IFERROR(('2. TOTAL WASTE COLLECTED '!C5*'2. TOTAL WASTE COLLECTED '!J10)/'2. TOTAL WASTE COLLECTED '!G10/1000,\"\")","v":""}]
[13,"Ratio between provision and requirement under current collection rate",{"$f":"IFERROR(C18/C17,\"\")","v":""},{"$f":"1:1","v":0},1,1]
[14,"Ratio between provision and requirement under 100% collection rate",{"$f":"IFERROR(C19/C17,\"\")","v":""},null,1,1]
["II","MUNICIPAL WASTE QUANTITIES"]
[15,{"$f":"'3. TOTAL WASTE GENERATED'!L9","v":"Estimated total waste generated in tonnes/year "},{"$f":"IFERROR('3. TOTAL WASTE GENERATED'!L21,\"\")","v":0}]
[16,{"$f":"'2. TOTAL WASTE COLLECTED '!H9","v":"Quantity of waste collected annually in tonnes"},{"$f":"'2. TOTAL WASTE COLLECTED '!H21","v":0}]
[17,"Ratio between waste collected in Urban and Rural areas",{"$f":"IFERROR('7. C&T COST COVERAGE'!H6/'7. C&T COST COVERAGE'!H7,\"\")","v":""}]
[18,{"$f":"'3. TOTAL WASTE GENERATED'!M9","v":"Estimated uncontrolled waste disposal in tonnes/year"},{"$f":"IFERROR('3. TOTAL WASTE GENERATED'!M21,\"\")","v":0}]
[19,"Uncontrolled waste disposal in % of total generated ",{"$f":"IFERROR('3. TOTAL WASTE GENERATED'!N21,\"\")","v":""}]
[20,"Uncontrolled waste disposal in % of total collected",{"$f":"'3. TOTAL WASTE GENERATED'!O21","v":0}]
["III","MUNICIPAL WASTE DISPOSAL ON LANDFILL WITHOUT SEPARATION"]
[21,"Municipal waste disposed without separation on traditional landfill in %",{"$f":"IFERROR('5. LANDFILL DEPOSITING'!F24,\"\")","v":""},null,0,0]
[22,"Municipal waste disposed without separation on controlled landfill in %",{"$f":"IFERROR('5. LANDFILL DEPOSITING'!H24,\"\")","v":""},null,1,1]
[23,"Municipal waste incinerated without separation  %",{"$f":"IFERROR('5. LANDFILL DEPOSITING'!J24,\"\")","v":""},null,0,1]
["IV","MUNICIPAL WASTE DISPOSAL AFTER SEPARATION"]
[24,"Disposed on landfill after separation in % of collected",{"$f":"IFERROR('6. WASTE RECOVERY '!M24,\"\")","v":""},"65% - 35%",0.65,0.35]
[25,"Average household waste disposed per capita/ kg/day",{"$f":"IFERROR(C12*C34,\"\")","v":""},"0,23 - 0,42kg/PE*day",{"$f":"E11*E34","v":0.68249999999999988},{"$f":"F11*F34","v":1.2599999999999998}]
[26,"Separated in % of total collected",{"$f":"IFERROR('6. WASTE RECOVERY '!F24+'6. WASTE RECOVERY '!H24,\"\")","v":""},"35% - 65%",{"$f":"100%-E34","v":0.35},{"$f":"100%-F34","v":0.65}]
[27,"Average household waste separated per capita/ kg/day",{"$f":"IFERROR(C12*C36,\"\")","v":""},"0,12 - 0,78kg/PE*day",{"$f":"E36*E11","v":0.36749999999999994},{"$f":"F36*F11","v":2.34}]
["V","MUNICIPAL WASTE RECOVERY AFTER SEPARATION"]
[28,"% out of total separated waste recycled and marketed including stocks",{"$f":"IFERROR('6. WASTE RECOVERY '!R24,\"\")","v":""},"0% - 80%",0,0.8]
[29,"% out of total separated waste incinerated with energy recovery",{"$f":"IFERROR('6. WASTE RECOVERY '!T24,\"\")","v":""},"0% - 40%",0,0.4]
[30,"% out of total separated waste composted",{"$f":"IFERROR('6. WASTE RECOVERY '!V24,\"\")","v":""},"0% - 65%",0,0.65]
["VI","LANDFILL USAGE CAPACITY"]
[31,{"$f":"'6. WASTE RECOVERY '!B30","v":"Present landfill capacity used to date"},{"$f":"'6. WASTE RECOVERY '!D30","v":0},"0 - 100%",0,1]
[32,{"$f":"'6. WASTE RECOVERY '!B33","v":"Landfill lifetime - years left at present depositing rate without separation or incineration"},{"$f":"IFERROR('6. WASTE RECOVERY '!D33,\"\")","v":""},"5 - 10 years",5,10]
[33,{"$f":"'6. WASTE RECOVERY '!B32","v":"Landfill lifetime - years left after separation, recycling and recovery"},{"$f":"IFERROR('6. WASTE RECOVERY '!D32,\"\")","v":""},"> 30 years",5,30]
[34,{"$f":"'6. WASTE RECOVERY '!B27","v":"Average waste disposed in tonnes per day before separation"},{"$f":"IFERROR('6. WASTE RECOVERY '!D27,\"\")","v":""}]
[35,{"$f":"'6. WASTE RECOVERY '!B28","v":"Average waste disposed in tonnes per day after separation"},{"$f":"IFERROR('6. WASTE RECOVERY '!D28,\"\")","v":""}]
["VII","CURRENT COST, PLANNED INVESTMENTS AND ESTIMATED COST IN EURO"]
[null,"Per Euro/ton"]
[36,{"$f":"'7. C&T COST COVERAGE'!B25","v":"Current Waste Collection and Transport Cost Euro/ton"},{"$f":"IFERROR('7. C&T COST COVERAGE'!C25,\"\")","v":""},null,10,45]
[37,{"$f":"'8. INVESTMENT FINANCING'!B68","v":"Estimated increase in collection and transport cost per tonne in Euro"},{"$f":"IFERROR('8. INVESTMENT FINANCING'!C68,\"\")","v":""}]
[38,{"$f":"'8. INVESTMENT FINANCING'!B67","v":"Estimated cost of collection and transport including increase for investments in equipment in Euro/tonne"},{"$f":"IFERROR('8. INVESTMENT FINANCING'!C67,\"\")","v":""}]
[39,{"$f":"'8. INVESTMENT FINANCING'!E67","v":"Estimated increase in expenditures for investment in recycling, recovery and landfilling of collected quantities in Euro/ton"},{"$f":"IFERROR('8. INVESTMENT FINANCING'!F67,\"\")","v":""}]
[40,{"$f":"'8. INVESTMENT FINANCING'!E68","v":"Estimated total cost of SWM (collection, transport, treatment and landfilling) with increase for investments in Euro/tonne "},{"$f":"IFERROR('8. INVESTMENT FINANCING'!F68,\"\")","v":""},null,60,120]
[null,"Per Household"]
[41,"Current Collection and Transport Cost Household/Year in Euro",{"$f":"IFERROR('2. TOTAL WASTE COLLECTED '!J10*365/1000*C50,\"\")","v":""}]
[42,"Estimated increase in collection and transport cost per Household/Year in Euro",{"$f":"IFERROR(C58-C56,\"\")","v":""}]
[43,"Estimated Collection and Transport Cost Household/Year in Euro",{"$f":"IFERROR('2. TOTAL WASTE COLLECTED '!J10*365/1000*'8. INVESTMENT FINANCING'!C67,\"\")","v":""}]
[44,"Estimated increase in expenditures for investment in recycling, recovery and landfilling of collected quantities Household/Year in Euro",{"$f":"IFERROR('2. TOTAL WASTE COLLECTED '!J10*365/1000*'8. INVESTMENT FINANCING'!F67,\"\")","v":""}]
[45,"Estimated Total Cost of SWM (Collection, Transport, Treatment and Landfilling) with increase for investments Household/Year in Euro",{"$f":"IFERROR('2. TOTAL WASTE COLLECTED '!J10*365/1000*C54,\"\")","v":""}]
[]
[]
[null,"HOME"]

{"sheet":"2. TOTAL WASTE COLLECTED ","index":2,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,4,0,5],[1,1,1,5],[0,2,0,3],[21,1,23,2],[21,3,40,9],[6,2,6,9]]}
[null,"MUNICIPALITY","Data Period - YEAR"]
[]
[null,"Area in km2"]
[null,"Total Population "]
[null,"Total households"]
[null,"Average members per household",{"$f":"C4/C5","v":{"$error":"#DIV/0!"}}]
[null,null,"TOTAL MUNICIPAL WASTE COLLECTED FROM SERVICED WASTE GENERATORS"]
[null,null,1,2,2.1,3,4,5,null,6]
[null,"WASTE ORIGIN BY TYPE ","Total number of serviced waste generators ","Quantity of waste collected annually in selected units (column 2.1)","Select Unit of Measurement","Quantities collected as % of total","Average waste density conversion factor (t/m3)","Quantity of waste collected annually in tonnes",null,"AVERAGE waste collected type/ kg/day"]
[1,"Mixed household waste",null,null,null,{"$f":"I10/$H$21","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(C10=0,D10=0,IF(D10=0,C10=0,D10*G10))","v":true},{"$f":"IFERROR(VALUE(H10),0)","v":0},{"$f":"((H10/C10)/365)*1000","v":{"$error":"#DIV/0!"}}]
[2,"Municipal waste from public areas",null,null,null,{"$f":"I11/$H$21","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(C11=0,D11=0,IF(D11=0,C11=0,D11*G11))","v":true},{"$f":"IFERROR(VALUE(H11),0)","v":0},{"$f":"((H11/C11)/365)*1000","v":{"$error":"#DIV/0!"}}]
[3,"Bulk Municipal waste",null,null,null,{"$error":"#DIV/0!"},null,true,{"$f":"IFERROR(VALUE(H12),0)","v":0},{"$error":"#DIV/0!"}]
[4,"Commercial entities",null,null,null,{"$error":"#DIV/0!"},null,true,0,{"$error":"#DIV/0!"}]
[5,"Institutions  (Municipal and other)",null,null,null,{"$error":"#DIV/0!"},null,true,0,{"$error":"#DIV/0!"}]
[6,"Industrial non hazardous waste",null,null,null,{"$error":"#DIV/0!"},null,true,0,{"$error":"#DIV/0!"}]
[7,"Construction waste",null,null,null,{"$error":"#DIV/0!"},null,true,0,{"$error":"#DIV/0!"}]
[8,"Agricultural organic waste",null,null,null,{"$error":"#DIV/0!"},null,true,0,{"$error":"#DIV/0!"}]
[9,"Add additional type of generator if existing",null,null,null,{"$error":"#DIV/0!"},null,true,0,{"$error":"#DIV/0!"}]
[10,"Add additional type of generator if existing",null,null,null,{"$error":"#DIV/0!"},null,true,0,{"$error":"#DIV/0!"}]
[11,"Add additional type of generator if existing",null,null,null,{"$error":"#DIV/0!"},null,true,0,{"$error":"#DIV/0!"}]
[null,"TOTAL",null,null,null,{"$f":"SUM(F10:F20)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(H10:H20)","v":0}]
[null,"HOME",null,"Notes:"]

{"sheet":"3. TOTAL WASTE GENERATED","index":3,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,1,24,2],[22,3,42,14],[0,4,0,5],[0,7,0,8],[1,1,1,8],[0,2,0,3],[6,2,6,14]]}
[null,{"$f":"'2. TOTAL WASTE COLLECTED '!B1","v":"MUNICIPALITY"},{"$f":"'2. TOTAL WASTE COLLECTED '!C1","v":"Data Period - YEAR"},null,{"$f":"'2. TOTAL WASTE COLLECTED '!E1:F1","v":0},null,null,{"$f":"'2. TOTAL WASTE COLLECTED '!E1","v":0}]
[null,{"$f":"'2. TOTAL WASTE COLLECTED '!B2","v":0}]
[null,"Total Population ",{"$f":"'2. TOTAL WASTE COLLECTED '!C4","v":0}]
[null,"Total households",{"$f":"'2. TOTAL WASTE COLLECTED '!C5","v":0}]
[null,"Average members per household",{"$f":"C3/C4","v":{"$error":"#DIV/0!"}}]
[null,"Average waste generation per capita/kg/day",{"$f":"(L21/C3/365*1000)","v":{"$error":"#DIV/0!"}}]
[null,null,"TOTAL MUNCIPIAL WASTE GENERATED FROM ALL WASTE PRODUCING SOURCES"]
[null,null,1,2,null,null,2,3,4,5,6,7,8,9]
[null,"WASTE ORIGIN BY TYPE","Total number of serviced waste generators","Total number of existing waste generators including serviced","Quantity of waste collected annually in m3","% of Total Collected","Average waste density conversion factor","Difference between existing and serviced number of waste generators","Quantity of waste collected annually in tonnes","Estimated service coverage in % of quantities","Estimated average total waste generated (not collected) in tonnes","Estimated total waste generated in tonnes/year ","Estimated uncontrolled waste disposal in tonnes/year","Estimated uncontrolled waste disposal in % of waste generated"]
[1,{"$f":"'2. TOTAL WASTE COLLECTED '!B10","v":"Mixed household waste"},{"$f":"'2. TOTAL WASTE COLLECTED '!C10","v":0},null,{"$f":"IF('2. TOTAL WASTE COLLECTED '!H10=FALSE,'2. TOTAL WASTE COLLECTED '!D10=0,'2. TOTAL WASTE COLLECTED '!D10)","v":0},{"$f":"E10/$E$21","v":{"$error":"#DIV/0!"}},{"$f":"'2. TOTAL WASTE COLLECTED '!G10","v":0},{"$f":"D10-C10","v":0},{"$f":"E10*G10","v":0},{"$f":"C10/D10","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR((I10*(1-J10))/J10,0)","v":0},{"$f":"IFERROR(IF(J10=0,K10,I10/J10),0)","v":0},{"$f":"L10-I10","v":0},{"$f":"M10/L10","v":{"$error":"#DIV/0!"}}]
[2,{"$f":"'2. TOTAL WASTE COLLECTED '!B11","v":"Municipal waste from public areas"},{"$f":"'2. TOTAL WASTE COLLECTED '!C11","v":0},null,{"$f":"IF('2. TOTAL WASTE COLLECTED '!H11=FALSE,'2. TOTAL WASTE COLLECTED '!D11=0,'2. TOTAL WASTE COLLECTED '!D11)","v":0},{"$error":"#DIV/0!"},{"$f":"'2. TOTAL WASTE COLLECTED '!G11","v":0},{"$f":"D11-C11","v":0},0,{"$f":"C11/D11","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR((I11*(1-J11))/J11,0)","v":0},{"$f":"IFERROR(IF(J11=0,K11,I11/J11),0)","v":0},{"$f":"L11-I11","v":0},{"$error":"#DIV/0!"}]
[3,{"$f":"'2. TOTAL WASTE COLLECTED '!B12","v":"Bulk Municipal waste"},{"$f":"'2. TOTAL WASTE COLLECTED '!C12","v":0},null,{"$f":"IF('2. TOTAL WASTE COLLECTED '!H12=FALSE,'2. TOTAL WASTE COLLECTED '!D12=0,'2. TOTAL WASTE COLLECTED '!D12)","v":0},{"$error":"#DIV/0!"},{"$f":"'2. TOTAL WASTE COLLECTED '!G12","v":0},0,{"$f":"E12*G12","v":0},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[4,{"$f":"'2. TOTAL WASTE COLLECTED '!B13","v":"Commercial entities"},{"$f":"'2. TOTAL WASTE COLLECTED '!C13","v":0},null,{"$f":"IF('2. TOTAL WASTE COLLECTED '!H13=FALSE,'2. TOTAL WASTE COLLECTED '!D13=0,'2. TOTAL WASTE COLLECTED '!D13)","v":0},{"$error":"#DIV/0!"},{"$f":"'2. TOTAL WASTE COLLECTED '!G13","v":0},0,0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[5,{"$f":"'2. TOTAL WASTE COLLECTED '!B14","v":"Institutions  (Municipal and other)"},{"$f":"'2. TOTAL WASTE COLLECTED '!C14","v":0},null,{"$f":"IF('2. TOTAL WASTE COLLECTED '!H14=FALSE,'2. TOTAL WASTE COLLECTED '!D14=0,'2. TOTAL WASTE COLLECTED '!D14)","v":0},{"$error":"#DIV/0!"},{"$f":"'2. TOTAL WASTE COLLECTED '!G14","v":0},0,0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[6,{"$f":"'2. TOTAL WASTE COLLECTED '!B15","v":"Industrial non hazardous waste"},{"$f":"'2. TOTAL WASTE COLLECTED '!C15","v":0},null,{"$f":"IF('2. TOTAL WASTE COLLECTED '!H15=FALSE,'2. TOTAL WASTE COLLECTED '!D15=0,'2. TOTAL WASTE COLLECTED '!D15)","v":0},{"$error":"#DIV/0!"},{"$f":"'2. TOTAL WASTE COLLECTED '!G15","v":0},0,0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[7,{"$f":"'2. TOTAL WASTE COLLECTED '!B16","v":"Construction waste"},{"$f":"'2. TOTAL WASTE COLLECTED '!C16","v":0},null,{"$f":"IF('2. TOTAL WASTE COLLECTED '!H16=FALSE,'2. TOTAL WASTE COLLECTED '!D16=0,'2. TOTAL WASTE COLLECTED '!D16)","v":0},{"$error":"#DIV/0!"},{"$f":"'2. TOTAL WASTE COLLECTED '!G16","v":0},0,0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[8,{"$f":"'2. TOTAL WASTE COLLECTED '!B17","v":"Agricultural organic waste"},{"$f":"'2. TOTAL WASTE COLLECTED '!C17","v":0},null,{"$f":"IF('2. TOTAL WASTE COLLECTED '!H17=FALSE,'2. TOTAL WASTE COLLECTED '!D17=0,'2. TOTAL WASTE COLLECTED '!D17)","v":0},{"$error":"#DIV/0!"},{"$f":"'2. TOTAL WASTE COLLECTED '!G17","v":0},0,0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[9,{"$f":"'2. TOTAL WASTE COLLECTED '!B18","v":"Add additional type of generator if existing"},{"$f":"'2. TOTAL WASTE COLLECTED '!C18","v":0},null,{"$f":"IF('2. TOTAL WASTE COLLECTED '!H18=FALSE,'2. TOTAL WASTE COLLECTED '!D18=0,'2. TOTAL WASTE COLLECTED '!D18)","v":0},{"$error":"#DIV/0!"},{"$f":"'2. TOTAL WASTE COLLECTED '!G18","v":0},0,0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[10,{"$f":"'2. TOTAL WASTE COLLECTED '!B19","v":"Add additional type of generator if existing"},{"$f":"'2. TOTAL WASTE COLLECTED '!C19","v":0},null,{"$f":"IF('2. TOTAL WASTE COLLECTED '!H19=FALSE,'2. TOTAL WASTE COLLECTED '!D19=0,'2. TOTAL WASTE COLLECTED '!D19)","v":0},{"$f":"E19/$E$21","v":{"$error":"#DIV/0!"}},{"$f":"'2. TOTAL WASTE COLLECTED '!G19","v":0},{"$f":"D19-C19","v":0},{"$f":"E19*G19","v":0},{"$f":"C19/D19","v":{"$error":"#DIV/0!"}},0,0,{"$f":"L19-I19","v":0},{"$f":"M19/L19","v":{"$error":"#DIV/0!"}}]
[11,{"$f":"'2. TOTAL WASTE COLLECTED '!B20","v":"Add additional type of generator if existing"},{"$f":"'2. TOTAL WASTE COLLECTED '!C20","v":0},null,{"$f":"IF('2. TOTAL WASTE COLLECTED '!H20=FALSE,'2. TOTAL WASTE COLLECTED '!D20=0,'2. TOTAL WASTE COLLECTED '!D20)","v":0},{"$error":"#DIV/0!"},{"$f":"'2. TOTAL WASTE COLLECTED '!G20","v":0},0,0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
[null,"TOTAL",null,null,{"$f":"SUM(E10:E20)","v":0},null,null,null,{"$f":"SUM(I10:I20)","v":0},null,{"$f":"SUM(K10:K20)","v":0},{"$f":"SUM(L10:L20)","v":0},{"$f":"SUM(M10:M20)","v":0},{"$f":"M21/L21","v":{"$error":"#DIV/0!"}}]
[]
[null,"HOME",null,"Notes:  "]

{"sheet":"4. WASTE MORPHOLOGY","index":4,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11],[0,1,0,2],[23,1,25,3],[23,5,38,13]]}
[null,{"$f":"'2. TOTAL WASTE COLLECTED '!B1","v":"MUNICIPALITY"},null,{"$f":"'2. TOTAL WASTE COLLECTED '!C1","v":"Data Period - YEAR"},{"$f":"'2. TOTAL WASTE COLLECTED '!E1:F1","v":0}]
[null,{"$f":"'2. TOTAL WASTE COLLECTED '!B2","v":0}]
[]
[null,1,2,3,4,5]
[null,"MUNICIPAL MIXED WASTE STUCTURE ","Estimated average content ","Quantities of collected waste in tonnes","Quantities of generated waste in tonnes","Uncontrolled quantities in tonnes",null,null,"Estimated Average Density t/m3"]
[1,"Garden Waste",null,{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C6","v":0},{"$f":"'3. TOTAL WASTE GENERATED'!$L$21*C6","v":0},{"$f":"E6-D6","v":0},null,null,0.1]
[2,"Other Biodegradable waste",null,{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C7","v":0},{"$f":"'3. TOTAL WASTE GENERATED'!$L$21*C7","v":0},{"$f":"E7-D7","v":0},null,null,0.14399999999999999]
[3,"Paper",null,{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C8","v":0},{"$f":"'3. TOTAL WASTE GENERATED'!$L$21*C8","v":0},0,null,null,0.33300000000000002]
[4,"Glass",null,{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C9","v":0},{"$f":"'3. TOTAL WASTE GENERATED'!$L$21*C9","v":0},0,null,null,0.64]
[5,"Cardboard",null,{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C10","v":0},{"$f":"'3. TOTAL WASTE GENERATED'!$L$21*C10","v":0},0,null,null,0.57569999999999999]
[6,"Cardboard with Wax",null,{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C11","v":0},{"$f":"'3. TOTAL WASTE GENERATED'!$L$21*C11","v":0},0,null,null,0.32]
[7,"Cardboard with aluminium",null,{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C12","v":0},{"$f":"'3. TOTAL WASTE GENERATED'!$L$21*C12","v":0},0,null,null,0.1]
[8,"Metal - Packaging and Others",null,{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C13","v":0},{"$f":"'3. TOTAL WASTE GENERATED'!$L$21*C13","v":0},0]
[9,"Metal - Aluminium Cans",null,{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C14","v":0},{"$f":"'3. TOTAL WASTE GENERATED'!$L$21*C14","v":0},0,null,null,0.17599999999999999]
[10,"Plastic packaging waste",null,{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C15","v":0},{"$f":"'3. TOTAL WASTE GENERATED'!$L$21*C15","v":0},0,null,null,0.129]
[11,"Plastic bags",null,{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C16","v":0},{"$f":"'3. TOTAL WASTE GENERATED'!$L$21*C16","v":0},0,null,null,0.224]
[12,"Hard plastic",null,{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C17","v":0},{"$f":"'3. TOTAL WASTE GENERATED'!$L$21*C17","v":0},0,null,null,0.1]
[13,"Textile",null,{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C18","v":0},{"$f":"'3. TOTAL WASTE GENERATED'!$L$21*C18","v":0},0]
[14,"Leather",null,{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C19","v":0},{"$f":"'3. TOTAL WASTE GENERATED'!$L$21*C19","v":0},0]
[15,"Diapers",null,{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C20","v":0},{"$f":"'3. TOTAL WASTE GENERATED'!$L$21*C20","v":0},0]
[16,"Fine elements(<20mm)",null,{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C21","v":0},{"$f":"'3. TOTAL WASTE GENERATED'!$L$21*C21","v":0},0]
[null,"TOTAL",{"$f":"SUM(C6:C21)","v":0},{"$f":"SUM(D6:D21)","v":0},{"$f":"SUM(E6:E21)","v":0},{"$f":"SUM(F6:F21)","v":0}]
[]
[null,"HOME",null,null,null,"Notes:  "]

{"sheet":"5. LANDFILL DEPOSITING","index":5,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,1,34,2],[27,1,27,2],[26,1,26,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[0,5,0,6],[1,1,1,3],[0,1,0,3],[25,1,25,2],[24,6,24,7],[3,1,3,10],[24,1,24,2],[25,5,31,10],[31,1,31,2],[0,8,0,25],[1,8,1,16]]}
[null,{"$f":"'2. TOTAL WASTE COLLECTED '!B1","v":"MUNICIPALITY"},null,null,{"$f":"'2. TOTAL WASTE COLLECTED '!C1","v":"Data Period - YEAR"},{"$f":"'4. WASTE MORPHOLOGY'!E1","v":0},null,null,"This worksheet is filled/used ONLY if there is no separation of waste in municipality. Please refer to User Manual"]
[null,{"$f":"'2. TOTAL WASTE COLLECTED '!B2","v":0},null,null,null,null,null,null,"Is there separation of waste in the municipality?"]
[]
[null,"MUNICIPAL WASTE DEPOSITED AND LANDFILL LIFETIME WITHOUT ORGANISED SEPARATION  "]
[null,1,2,3,4,5,6,7,8,9,10]
[null,"MUNICIPAL MIXED WASTE STUCTURE ",{"$f":"'4. WASTE MORPHOLOGY'!C5","v":"Estimated average content "},"Quantities of collected waste in tonnes","Waste collected deposited on traditional landfill as % of total","Quantities of collected waste deposited on traditional landfill in tonnes"," Waste collected  deposited on controlled landfill as % of total","Quantities of collected waste deposited on controlled  landfill in tonnes","Waste collected incinerated without energy recovery as % of total","Waste collected - incinerated without energy recovery in tonnes","Total waste deposited (4+6)"]
[1,{"$f":"'4. WASTE MORPHOLOGY'!B6","v":"Garden Waste"},{"$f":"'4. WASTE MORPHOLOGY'!C6","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C7","v":0},null,{"$f":"D7*E7","v":0},null,{"$f":"D7*G7","v":0},null,{"$f":"D7*I7","v":0},{"$f":"E7+G7+I7","v":0}]
[2,{"$f":"'4. WASTE MORPHOLOGY'!B7","v":"Other Biodegradable waste"},{"$f":"'4. WASTE MORPHOLOGY'!C7","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C8","v":0},null,{"$f":"D8*E8","v":0},null,{"$f":"D8*G8","v":0},null,0,0]
[3,{"$f":"'4. WASTE MORPHOLOGY'!B8","v":"Paper"},{"$f":"'4. WASTE MORPHOLOGY'!C8","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C9","v":0},null,0,null,0,null,0,0]
[4,{"$f":"'4. WASTE MORPHOLOGY'!B9","v":"Glass"},{"$f":"'4. WASTE MORPHOLOGY'!C9","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C10","v":0},null,0,null,0,null,0,0]
[5,{"$f":"'4. WASTE MORPHOLOGY'!B10","v":"Cardboard"},{"$f":"'4. WASTE MORPHOLOGY'!C10","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C11","v":0},null,0,null,0,null,0,0]
[6,{"$f":"'4. WASTE MORPHOLOGY'!B11","v":"Cardboard with Wax"},{"$f":"'4. WASTE MORPHOLOGY'!C11","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C12","v":0},null,0,null,0,null,0,0]
[7,{"$f":"'4. WASTE MORPHOLOGY'!B12","v":"Cardboard with aluminium"},{"$f":"'4. WASTE MORPHOLOGY'!C12","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C13","v":0},null,0,null,0,null,0,0]
[8,{"$f":"'4. WASTE MORPHOLOGY'!B13","v":"Metal - Packaging and Others"},{"$f":"'4. WASTE MORPHOLOGY'!C13","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C14","v":0},null,0,null,0,null,0,0]
[9,{"$f":"'4. WASTE MORPHOLOGY'!B14","v":"Metal - Aluminium Cans"},{"$f":"'4. WASTE MORPHOLOGY'!C14","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C15","v":0},null,0,null,0,null,0,0]
[10,{"$f":"'4. WASTE MORPHOLOGY'!B15","v":"Plastic packaging waste"},{"$f":"'4. WASTE MORPHOLOGY'!C15","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C16","v":0},null,0,null,0,null,0,0]
[11,{"$f":"'4. WASTE MORPHOLOGY'!B16","v":"Plastic bags"},{"$f":"'4. WASTE MORPHOLOGY'!C16","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C17","v":0},null,0,null,0,null,0,0]
[12,{"$f":"'4. WASTE MORPHOLOGY'!B17","v":"Hard plastic"},{"$f":"'4. WASTE MORPHOLOGY'!C17","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C18","v":0},null,0,null,0,null,0,0]
[13,{"$f":"'4. WASTE MORPHOLOGY'!B18","v":"Textile"},{"$f":"'4. WASTE MORPHOLOGY'!C18","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C19","v":0},null,0,null,0,null,0,0]
[14,{"$f":"'4. WASTE MORPHOLOGY'!B19","v":"Leather"},{"$f":"'4. WASTE MORPHOLOGY'!C19","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C20","v":0},null,0,null,0,null,0,0]
[15,{"$f":"'4. WASTE MORPHOLOGY'!B20","v":"Diapers"},{"$f":"'4. WASTE MORPHOLOGY'!C20","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C21","v":0},null,0,null,0,null,0,0]
[16,{"$f":"'4. WASTE MORPHOLOGY'!B21","v":"Fine elements(<20mm)"},{"$f":"'4. WASTE MORPHOLOGY'!C21","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C22","v":0},null,0,null,0,null,0,0]
[null,"TOTAL ANNUALLY",{"$f":"'4. WASTE MORPHOLOGY'!C22","v":0},{"$f":"SUM(D7:D22)","v":0},null,{"$f":"SUM(F7:F22)","v":0},null,{"$f":"SUM(H7:H22)","v":0},null,{"$f":"SUM(J7:J22)","v":0},{"$f":"F23+H23","v":0}]
[null,"% of Total",null,null,null,{"$f":"F23/D23","v":{"$error":"#DIV/0!"}},null,{"$f":"H23/D23","v":{"$error":"#DIV/0!"}},null,{"$f":"J23/D23","v":{"$error":"#DIV/0!"}},{"$f":"F24+H24+J24","v":{"$error":"#DIV/0!"}}]
[null,"Landfill lifetime (traditional or controlled)"]
[17,"Landfill operating days per year",null,null,null," Notes:"]
[18,"Average waste deposited in t per day without incineration",null,{"$f":"D23/D26","v":{"$error":"#DIV/0!"}}]
[19,"Total projected landfill capacity in tonnes"]
[20,"Present landfill capacity used to date"]
[21,"Capacity left in tonnes",null,{"$f":"D28*(1-D29)","v":0}]
[22,"Years left at present depositing rate with incineration",null,{"$f":"D30/K23","v":{"$error":"#DIV/0!"}}]
[23,"Years left at present depositing rate without  incineration",null,{"$f":"D30/D23","v":{"$error":"#DIV/0!"}}]
[]
[null,"HOME"]

{"sheet":"6. WASTE RECOVERY ","index":6,"n_rows":42,"n_cols":25,"rows_kept":42,"cut":false,"hidden":false,"merged":[[4,0,5,1],[24,1,24,4],[1,1,1,4],[24,22,24,24],[0,1,0,3],[23,23,23,24],[4,23,5,24],[22,23,22,24],[22,0,22,1],[3,3,3,22],[23,0,23,1],[22,16,23,16],[1,8,1,16],[0,8,0,24],[41,4,61,19],[34,1,36,3],[25,16,25,24],[22,20,23,20],[22,18,23,18],[22,6,23,6],[22,8,23,8],[22,4,23,4]]}
[null,{"$f":"'2. TOTAL WASTE COLLECTED '!B1","v":"MUNICIPALITY"},null,null,{"$f":"'5. LANDFILL DEPOSITING'!E1","v":"Data Period - YEAR"},{"$f":"'5. LANDFILL DEPOSITING'!F1:G1","v":0},null,null,"This worksheet is filled/used ONLY if there is no separation of waste in municipality. Please refer to User Manual"]
[null,{"$f":"'2. TOTAL WASTE COLLECTED '!B2","v":0},null,null,null,null,null,null,"Is there separation of waste in the municipality?"]
[]
[null,null,null,"ORGANISED SEPARATION - MUNICIPAL WASTE SEPARATED AND WASTE DEPOSITED - WASTE RECOVERY, TREATMENT AND LANDFILL LIFETIME "]
["MIXED MUNICIPAL WASTE STUCTURE ",null,null,1,2,3,4,5,6,7,8,9,10,11,12,null,13,14,15,16,17,18,19]
[null,null,"Estimated Average Content ","Quantities of collected waste in tonnes","Municipal waste separated at source as % of total","Quantities of municipal waste separated at source in tonnes","Collected waste separated at depositing site as % of total","Quantities of separated waste at depositing site in tonnes","Separated as % of total collected","Quantities of Waste separated in tonnes","Structure of total waste separated","Collected waste Deposited on Landfill as % of total","Quantities of Collected waste Deposited on Landfill in tonnes","Structure of total waste deposited on landfill after separation as % of total","Total % of separated and deposited waste ",null,"Separated waste marketed for recycling or on stock as % of total separated ","Separated waste recycled and marketed in tonnes","Separated waste incinerated with or without energy recovery as % of total separated","Separated waste incinerated with or without energy recovery in tonnes","% of waste separated composted of total separated ","Separated waste composted in tonnes","Total % of separated waste "]
[1,{"$f":"'4. WASTE MORPHOLOGY'!B6","v":"Garden Waste"},{"$f":"'4. WASTE MORPHOLOGY'!C6","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C7","v":0},null,{"$f":"D7*E7","v":0},null,{"$f":"D7*G7","v":0},{"$f":"E7+G7","v":0},{"$f":"F7+H7","v":0},{"$f":"J7/J$23","v":{"$error":"#DIV/0!"}},null,{"$f":"D7*L7","v":0},{"$f":"M7/M$23","v":{"$error":"#DIV/0!"}},{"$f":"E7+G7+L7","v":0},null,null,{"$f":"(F7+H7)*Q7","v":0},null,{"$f":"(H7+F7)*S7","v":0},null,{"$f":"(F7+H7)*U7","v":0},{"$f":"Q7+S7+U7","v":0},1,{"$f":"'4. WASTE MORPHOLOGY'!B6","v":"Garden Waste"}]
[2,{"$f":"'4. WASTE MORPHOLOGY'!B7","v":"Other Biodegradable waste"},{"$f":"'4. WASTE MORPHOLOGY'!C7","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C8","v":0},null,{"$f":"D8*E8","v":0},null,{"$f":"D8*G8","v":0},{"$f":"E8+G8","v":0},{"$f":"F8+H8","v":0},{"$f":"J8/J$23","v":{"$error":"#DIV/0!"}},null,{"$f":"D8*L8","v":0},{"$f":"M8/M$23","v":{"$error":"#DIV/0!"}},0,null,null,0,null,{"$f":"(H8+F8)*S8","v":0},null,{"$f":"(F8+H8)*U8","v":0},{"$f":"Q8+S8+U8","v":0},2,{"$f":"'4. WASTE MORPHOLOGY'!B7","v":"Other Biodegradable waste"}]
[3,{"$f":"'4. WASTE MORPHOLOGY'!B8","v":"Paper"},{"$f":"'4. WASTE MORPHOLOGY'!C8","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C9","v":0},null,0,null,0,0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},0,null,null,0,null,0,null,0,0,3,{"$f":"'4. WASTE MORPHOLOGY'!B8","v":"Paper"}]
[4,{"$f":"'4. WASTE MORPHOLOGY'!B9","v":"Glass"},{"$f":"'4. WASTE MORPHOLOGY'!C9","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C10","v":0},null,0,null,0,0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},0,null,null,0,null,0,null,0,0,4,{"$f":"'4. WASTE MORPHOLOGY'!B9","v":"Glass"}]
[5,{"$f":"'4. WASTE MORPHOLOGY'!B10","v":"Cardboard"},{"$f":"'4. WASTE MORPHOLOGY'!C10","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C11","v":0},null,0,null,0,0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},0,null,null,0,null,0,null,0,0,5,{"$f":"'4. WASTE MORPHOLOGY'!B10","v":"Cardboard"}]
[6,{"$f":"'4. WASTE MORPHOLOGY'!B11","v":"Cardboard with Wax"},{"$f":"'4. WASTE MORPHOLOGY'!C11","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C12","v":0},null,0,null,0,0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},0,null,null,0,null,0,null,0,0,6,{"$f":"'4. WASTE MORPHOLOGY'!B11","v":"Cardboard with Wax"}]
[7,{"$f":"'4. WASTE MORPHOLOGY'!B12","v":"Cardboard with aluminium"},{"$f":"'4. WASTE MORPHOLOGY'!C12","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C13","v":0},null,0,null,0,0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},0,null,null,0,null,0,null,0,0,7,{"$f":"'4. WASTE MORPHOLOGY'!B12","v":"Cardboard with aluminium"}]
[8,{"$f":"'4. WASTE MORPHOLOGY'!B13","v":"Metal - Packaging and Others"},{"$f":"'4. WASTE MORPHOLOGY'!C13","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C14","v":0},null,0,null,0,0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},0,null,null,0,null,0,null,0,0,8,{"$f":"'4. WASTE MORPHOLOGY'!B13","v":"Metal - Packaging and Others"}]
[9,{"$f":"'4. WASTE MORPHOLOGY'!B14","v":"Metal - Aluminium Cans"},{"$f":"'4. WASTE MORPHOLOGY'!C14","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C15","v":0},null,0,null,0,0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},0,null,null,0,null,0,null,0,0,9,{"$f":"'4. WASTE MORPHOLOGY'!B14","v":"Metal - Aluminium Cans"}]
[10,{"$f":"'4. WASTE MORPHOLOGY'!B15","v":"Plastic packaging waste"},{"$f":"'4. WASTE MORPHOLOGY'!C15","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C16","v":0},null,0,null,0,0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},0,null,null,0,null,0,null,0,0,10,{"$f":"'4. WASTE MORPHOLOGY'!B15","v":"Plastic packaging waste"}]
[11,{"$f":"'4. WASTE MORPHOLOGY'!B16","v":"Plastic bags"},{"$f":"'4. WASTE MORPHOLOGY'!C16","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C17","v":0},null,0,null,0,0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},0,null,null,0,null,0,null,0,0,11,{"$f":"'4. WASTE MORPHOLOGY'!B16","v":"Plastic bags"}]
[12,{"$f":"'4. WASTE MORPHOLOGY'!B17","v":"Hard plastic"},{"$f":"'4. WASTE MORPHOLOGY'!C17","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C18","v":0},null,0,null,0,0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},0,null,null,0,null,0,null,0,0,12,{"$f":"'4. WASTE MORPHOLOGY'!B17","v":"Hard plastic"}]
[13,{"$f":"'4. WASTE MORPHOLOGY'!B18","v":"Textile"},{"$f":"'4. WASTE MORPHOLOGY'!C18","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C19","v":0},null,0,null,0,0,{"$f":"F19+H19","v":0},{"$f":"J19/J$23","v":{"$error":"#DIV/0!"}},null,0,{"$error":"#DIV/0!"},0,null,null,0,null,0,null,0,0,13,{"$f":"'4. WASTE MORPHOLOGY'!B18","v":"Textile"}]
[14,{"$f":"'4. WASTE MORPHOLOGY'!B19","v":"Leather"},{"$f":"'4. WASTE MORPHOLOGY'!C19","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C20","v":0},null,0,null,0,0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},0,null,null,0,null,0,null,0,0,14,{"$f":"'4. WASTE MORPHOLOGY'!B19","v":"Leather"}]
[15,{"$f":"'4. WASTE MORPHOLOGY'!B20","v":"Diapers"},{"$f":"'4. WASTE MORPHOLOGY'!C20","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C21","v":0},null,0,null,0,0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},0,null,null,0,null,0,null,0,0,15,{"$f":"'4. WASTE MORPHOLOGY'!B20","v":"Diapers"}]
[16,{"$f":"'4. WASTE MORPHOLOGY'!B21","v":"Fine elements(<20mm)"},{"$f":"'4. WASTE MORPHOLOGY'!C21","v":0},{"$f":"'2. TOTAL WASTE COLLECTED '!$H$21*C22","v":0},null,0,null,0,0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},0,null,null,0,null,0,null,0,0,16,{"$f":"'4. WASTE MORPHOLOGY'!B21","v":"Fine elements(<20mm)"}]
["TOTAL",null,{"$f":"SUM(C7:C22)","v":0},{"$f":"SUM(D7:D22)","v":0},null,{"$f":"SUM(F7:F22)","v":0},null,{"$f":"SUM(H7:H22)","v":0},null,{"$f":"SUM(J7:J22)","v":0},{"$error":"#DIV/0!"},null,{"$f":"SUM(M7:M22)","v":0},{"$f":"SUM(N7:N22)","v":{"$error":"#DIV/0!"}},{"$f":"F23+H23+M23","v":0},null,"out of total waste separated ",{"$f":"SUM(R7:R22)","v":0},"out of total waste separated ",{"$f":"SUM(T7:T22)","v":0},"out of total waste separated ",{"$f":"SUM(V7:V22)","v":0},{"$f":"R23+T23+V23","v":0},"TOTAL"]
["% of TOTAL",null,null,null,null,{"$f":"F23/D23","v":{"$error":"#DIV/0!"}},null,{"$f":"H23/D23","v":{"$error":"#DIV/0!"}},null,{"$f":"J23/D23","v":{"$error":"#DIV/0!"}},null,null,{"$f":"M23/D23","v":{"$error":"#DIV/0!"}},null,{"$f":"O23/D23","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R23/(F23+H23)","v":{"$error":"#DIV/0!"}},null,{"$f":"T23/(F23+H23)","v":{"$error":"#DIV/0!"}},null,{"$f":"V23/(F23+H23)","v":{"$error":"#DIV/0!"}},{"$f":"R24+T24+V24","v":{"$error":"#DIV/0!"}},"% of TOTAL"]
[null,{"$f":"'5. LANDFILL DEPOSITING'!B25:C25","v":"Landfill lifetime (traditional or controlled)"}]
[17,"Landfill operating days per year",null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[18,"Average waste disposed in tonnes per day before separation",null,{"$f":"D23/D26","v":{"$error":"#DIV/0!"}}]
[19,"Average waste disposed in tonnes per day after separation",null,{"$f":"M23/D26","v":{"$error":"#DIV/0!"}}]
[20,"Total projected landfill capacity in tonnes"]
[21,{"$f":"'5. LANDFILL DEPOSITING'!B29","v":"Present landfill capacity used to date"}]
[22,"Capacity left in tonnes",null,{"$f":"D29*(1-D30)","v":0}]
[23,"Landfill lifetime - years left after separation, recycling and recovery",null,{"$f":"D31/M23","v":{"$error":"#DIV/0!"}}]
[24,"Landfill lifetime - years left at present depositing rate without separation or incineration",null,{"$f":"D31/D23","v":{"$error":"#DIV/0!"}}]
[]
[null,"HOME"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Notes:  "]

{"sheet":"7. C&T COST COVERAGE","index":7,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,14,7,22],[1,8,1,11],[4,10,4,13],[26,3,37,9],[26,1,28,1],[22,2,22,3],[24,2,24,3],[0,6,0,7],[13,2,13,3],[14,2,14,3],[15,2,15,3],[12,2,12,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[4,9,6,9],[18,2,18,3],[21,2,21,3],[23,2,23,3],[16,2,16,3],[20,2,20,3],[17,2,17,3],[7,6,7,9],[7,1,7,3],[19,2,19,3]]}
[null,{"$f":"'2. TOTAL WASTE COLLECTED '!B1","v":"MUNICIPALITY"},null,{"$f":"'2. TOTAL WASTE COLLECTED '!C1","v":"Data Period - YEAR"},{"$f":"'2. TOTAL WASTE COLLECTED '!E1:F1","v":0},null,"ORGANIZED WASTE SERVICE COVERAGE",null,null,null,null,null,null,null,"This worksheet shows financial sustainability of the service and is indicative. More detailed analysis of incomes and expenditures and efficiency is necessary before tariff is changed."]
[null,{"$f":"'2. TOTAL WASTE COLLECTED '!B2","v":0},null,null,null,"a","Total households",{"$f":"SUM(H3:H4)","v":0},{"$f":"IF(H2='2. TOTAL WASTE COLLECTED '!C5,\"Matches Value in Sheet 2-Total Waste Collected\",\"Does not Match Value in Sheet 2-Total Waste Collected\")","v":"Matches Value in Sheet 2-Total Waste Collected"}]
[null,{"$f":"'2. TOTAL WASTE COLLECTED '!B3","v":"Area in km2"},{"$f":"'2. TOTAL WASTE COLLECTED '!C3","v":0},null,null,"b","Urban "]
[null,{"$f":"'2. TOTAL WASTE COLLECTED '!B4","v":"Total Population "},{"$f":"'2. TOTAL WASTE COLLECTED '!C4","v":0},null,null,"c","Rural"]
[null,{"$f":"'2. TOTAL WASTE COLLECTED '!B5","v":"Total households"},{"$f":"'2. TOTAL WASTE COLLECTED '!C5","v":0},null,null,"d","Total households served",{"$f":"SUM(H6:H7)","v":0},{"$f":"H5/H2","v":{"$error":"#DIV/0!"}},"Service coverage",{"$f":"IF(H5='2. TOTAL WASTE COLLECTED '!C10,\"Matches Value in Sheet 2-Total Waste Collected\",\"Does not Match Value in Sheet 2-Total Waste Collected\")","v":"Matches Value in Sheet 2-Total Waste Collected"}]
[null,{"$f":"'2. TOTAL WASTE COLLECTED '!B6","v":"Average members per household"},{"$f":"'2. TOTAL WASTE COLLECTED '!C6","v":{"$error":"#DIV/0!"}},null,null,"e","Urban ",null,{"$f":"H6/H3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"f","Rural",null,{"$f":"H7/H4","v":{"$error":"#DIV/0!"}}]
[null,"GENERAL AND FINANCIAL DATA ",null,null,null,null,"TARIFFS"]
[1,"Utility Company - Operator Name and Location  ",null,null,null,1,"Serviced end user","Present Tariff. Specify tariff invoicing policy per serviced user (per m2 or m3 monthly, per kg/t, or other) in Euro","Billling Units","Necessary tariff in Euro to achieve results as 100%  revenue collection","Tariff increase index"]
[2,"Main Activities and Services ",null,null,null,2,null,null,null,{"$f":"H10/$C$12","v":{"$error":"#DIV/0!"}},{"$f":"J10/H10","v":{"$error":"#DIV/0!"}}]
[3,"Share of SWM revenues in total company revenues",null,null,null,3,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[4,"% of Invoiced/Collected revenues from SWM Services",null,null,null,4,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[5,"Total Revenues from SWM in Euros annually in Euros",null,null,null,5,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[6,"Total Expenditures (Material costs, Salaries, Depreciation and other costs) related to collection and transport of waste, in Euros annually ",null,null,null,6,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[7,"Operating profit/loss annually in Euros",{"$f":"C13-C14","v":0},null,null,7,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[8,"Necessary increase in revenue to cover operating loss/or profits above operating costs (-sign)",{"$f":"C15/-C13","v":{"$error":"#DIV/0!"}},null,null,8,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[9,"Necessary decrease in expenditures to cover operating loss (-sign)/ or operating cost below revenues",{"$f":"C15/C14","v":{"$error":"#DIV/0!"}},null,null,9,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[10,"Total waste collected in tons annually",{"$f":"'2. TOTAL WASTE COLLECTED '!H21","v":0},null,null,10,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[11,"Total number of employees engaged in SWM including adminstration",null,null,null,11,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[12,"Number of workers directly operatively engaged in SWM ",null,null,null,12,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[13,"Employment ratio administrative to operative employees 1:",{"$f":"C20/(C19-C20)","v":{"$error":"#DIV/0!"}},null,null,13,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[14,"Quantity of waste collected annually per SWM employee/tons",{"$f":"C18/C19","v":{"$error":"#DIV/0!"}},null,null,14,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[15,"Population served per SWM Employee",{"$f":"(H5/C19)","v":{"$error":"#DIV/0!"}},null,null,15,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[16,"Employees in SWM per 1000 population served ",{"$f":"1000/C23","v":{"$error":"#DIV/0!"}},null,null,16,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[17,"Current Waste Collection and Transport Cost Euro/ton",{"$f":"C14/C18","v":{"$error":"#DIV/0!"}},null,null,17,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"HOME",null,"Notes: "]

{"sheet":"8. INVESTMENT FINANCING","index":8,"n_rows":72,"n_cols":10,"rows_kept":72,"cut":false,"hidden":false,"merged":[[3,1,3,9],[71,1,73,1],[64,3,66,3],[64,6,66,6],[59,1,59,5]]}
[null,{"$f":"'2. TOTAL WASTE COLLECTED '!B1","v":"MUNICIPALITY"},null,{"$f":"'2. TOTAL WASTE COLLECTED '!C1","v":"Data Period - YEAR"},{"$f":"'2. TOTAL WASTE COLLECTED '!E1:F1","v":0}]
[null,{"$f":"'2. TOTAL WASTE COLLECTED '!B2","v":0}]
[]
[null,"INVESTMENTS IN EQUIPMENT AND ASSETS "]
[]
[null,"OPERATOR - PUBLIC UTILITY COMPANY NAME ",1,2,3,4,5,6,7,8]
[null,"Type of equipment for SW Collection and Transport","Existing number of units in operation","Planned new purchase ","New unit purchase price in Euro","Necessary investment in Euro","Depreciation rate","Annual depreciation","Planned expenditures for loan services per annum","Depreciation and loan service per year"]
[1,"Containers 120 l",null,null,null,{"$f":"D8*E8","v":0},null,{"$f":"F8*G8","v":0},null,{"$f":"H8+I8","v":0}]
[2,"Containers 240 l",null,null,null,{"$f":"D9*E9","v":0},null,{"$f":"F9*G9","v":0},null,{"$f":"H9+I9","v":0}]
[3,"Container 660 l",null,null,null,{"$f":"D10*E10","v":0},null,{"$f":"F10*G10","v":0},null,{"$f":"H10+I10","v":0}]
[4,"Container 770 l",null,null,null,{"$f":"D11*E11","v":0},null,{"$f":"F11*G11","v":0},null,{"$f":"H11+I11","v":0}]
[5,"Container 1100 l",null,null,null,0,null,0,null,0]
[6,"Skip containers 3,5m3",null,null,null,0,null,0,null,0]
[7,"Skip containers 5m³",null,null,null,0,null,0,null,0]
[8,"Skip containers 7m³",null,null,null,0,null,0,null,0]
[9,"Hooklift container 2,5",null,null,null,0,null,0,null,0]
[10,"Hooklift container 5m³",null,null,null,0,null,0,null,0]
[11,"Hooklift container 10m³",null,null,null,0,null,0,null,0]
[12,"Hooklift container 25m³",null,null,null,0,null,0,null,0]
[13,"Hooklift container 35m³",null,null,null,0,null,0,null,0]
[14,null,null,null,null,0,null,0,null,0]
[15,null,null,null,null,0,null,0,null,0]
[16,"Containers Other ",null,null,null,{"$f":"D23*E23","v":0},null,{"$f":"F23*G23","v":0},null,0]
[null,"Subtotal collection equipment",{"$f":"SUM(C8:C23)","v":0},{"$f":"SUM(D8:D23)","v":0},null,{"$f":"SUM(F8:F23)","v":0},null,{"$f":"SUM(H8:H23)","v":0},{"$f":"SUM(I8:I23)","v":0},{"$f":"SUM(J8:J23)","v":0}]
[1,"Vehicles Trucks 8t",null,null,null,{"$f":"D25*E25","v":0},null,{"$f":"F25*G25","v":0},null,{"$f":"H25+I25","v":0}]
[2,"Vehicles Trucks 12t",null,null,null,{"$f":"D26*E26","v":0},null,{"$f":"F26*G26","v":0},null,{"$f":"H26+I26","v":0}]
[3,"Vehicles Rotopres",null,null,null,{"$f":"D27*E27","v":0},null,{"$f":"F27*G27","v":0},null,{"$f":"H27+I27","v":0}]
[4,"Vehicles Compactor Trucks",null,null,null,{"$f":"D28*E28","v":0},null,{"$f":"F28*G28","v":0},null,{"$f":"H28+I28","v":0}]
[5,"Tipper Truck",null,null,null,{"$f":"D29*E29","v":0},null,{"$f":"F29*G29","v":0},null,{"$f":"H29+I29","v":0}]
[6,"Flatbed Truck",null,null,null,0,null,0,null,0]
[7,"Skip truck",null,null,null,0,null,0,null,0]
[8,"Hooklift truck",null,null,null,0,null,0,null,0]
[9,"Sideloader",null,null,null,0,null,0,null,0]
[10,"Tractor and trailer",null,null,null,0,null,0,null,0]
[11,"Vehicles Other ",null,null,null,{"$f":"D35*E35","v":0},null,{"$f":"F35*G35","v":0},null,0]
[null,"Subtotal transport equipment",{"$f":"SUM(C25:C35)","v":0},{"$f":"SUM(D25:D35)","v":0},null,{"$f":"SUM(F25:F35)","v":0},null,{"$f":"SUM(H25:H35)","v":0},{"$f":"SUM(I25:I35)","v":0},{"$f":"SUM(J25:J35)","v":0}]
[null,"TOTAL COLLECTION",null,null,null,{"$f":"F24+F36","v":0},null,{"$f":"H24+H36","v":0},{"$f":"I24+I36","v":0},{"$f":"J24+J36","v":0}]
[null,"OPERATOR - PUBLIC UTILITY COMPANY NAME ","1.1","2.1","3.1","4.1","5.1","6.1","7.1","8.1"]
[null,"Waste treatment, recycling, recovery","Existing number of units in operation","Planned new purchase ","New unit purchase price in Euro","Necessary investment in Euro","Depreciation rate","Annual depreciation","Planned expenditures for Loan services per annum","Depreciation and loan service per year"]
[1,"Investigations, design, permits",null,null,null,{"$f":"D40*E40","v":0},null,{"$f":"F40*G40","v":0},null,{"$f":"H40+I40","v":0}]
[2,"Land purchase",null,null,null,{"$f":"D41*E41","v":0},null,{"$f":"F41*G41","v":0},null,{"$f":"H41+I41","v":0}]
[3,"Mechanical installations",null,null,null,0,null,0,null,0]
[4,"Mobile equipment",null,null,null,0,null,0,null,0]
[5,"Civil construction",null,null,null,0,null,0,null,0]
[6,null,null,null,null,0,null,0,null,0]
[7,"Other costs",null,null,null,0,null,0,null,{"$f":"H46+I46","v":0}]
[null,"Subtotal treatment",{"$f":"SUM(C40:C46)","v":0},null,null,{"$f":"SUM(F40:F46)","v":0},null,{"$f":"SUM(H40:H46)","v":0},{"$f":"SUM(I40:I46)","v":0},{"$f":"SUM(J40:J46)","v":0}]
[null,"OPERATOR - PUBLIC UTILITY COMPANY NAME ","1.2","2.2","3.2","4.2","5.2","6.2","7.2","8.2"]
[null,"Landfill investments","Existing number of units in operation","Planned new purchase ","New unit purchase price in Euro","Necessary investment in Euro","Depreciation rate","Annual depreciation","Planned expenditures for Loan services per annum","Depreciation and loan service per year"]
[1,"Investigations, design, permits",null,null,null,0,null,0,null,0]
[2,"Land purchase",null,null,null,0,null,0,null,0]
[3,"Mechanical installations",null,null,null,0,null,0,null,0]
[4,"Mobile equipment",null,null,null,0,null,0,null,0]
[5,"Civil construction",null,null,null,{"$f":"D54*E54","v":0},null,{"$f":"F54*G54","v":0},null,{"$f":"H54+I54","v":0}]
[6,null,null,null,null,{"$f":"D55*E55","v":0},null,{"$f":"F55*G55","v":0},null,{"$f":"H55+I55","v":0}]
[7,"Other costs",null,null,null,{"$f":"D56*E56","v":0},null,{"$f":"F56*G56","v":0},null,{"$f":"H56+I56","v":0}]
[null,"Subtotal Landfilling",{"$f":"SUM(C50:C56)","v":0},null,null,{"$f":"SUM(F50:F56)","v":0},null,{"$f":"SUM(H50:H56)","v":0},{"$f":"SUM(I50:I56)","v":0},{"$f":"SUM(J50:J56)","v":0}]
[null,"TOTAL TREATMENT&DISPOSAL",null,null,null,{"$f":"F47+F57","v":0},null,{"$f":"H47+H57","v":0},{"$f":"I47+I57","v":0},{"$f":"J47+J57","v":0}]
[null,"GRAND TOTAL INVESTMENT",null,null,null,{"$f":"SUM(F37,F58)","v":0},null,{"$f":"SUM(H37,H58)","v":0},{"$f":"SUM(I37,I58)","v":0},{"$f":"SUM(J37,J58)","v":0}]
[null,"COLLECTION, TRANSPORT, RECYCLING AND LANDFILL COST CORRECTION"]
[1,"Current annual collection and transport annual expenditures in Euro",{"$f":"'7. C&T COST COVERAGE'!C14:D14","v":0},null,"Current annual collection, transport, treatment, recovery and landfilling annual expenditures in Euro",{"$f":"C61","v":0}]
[2,"Estimated additional annual expenditure for collection equipment ",{"$f":"J37","v":0},{"$f":"C62/$C$61","v":{"$error":"#DIV/0!"}},"Estimated additional annual expenditures for all investments (capital costs)",{"$f":"J59","v":0}]
[3,"Estimated annual increase in variable costs of collection and transport in Euro",null,{"$f":"C63/$C$61","v":{"$error":"#DIV/0!"}},"Estimated annual increase in operative costs of treatment and landfill operative costs, total in Euro"]
[4,"Estimated annual increase in expenditures",{"$f":"SUM(C62:C63)","v":0},{"$f":"C64/$C$61","v":{"$error":"#DIV/0!"}},"Estimated annual increase in expenditures",{"$f":"SUM(F62:F63)","v":0},{"$f":"F64/$F$61","v":{"$error":"#DIV/0!"}}]
[5,"Total annual expenditures",{"$f":"SUM(C61:C63)","v":0},null,"Estimated total annual expenditures",{"$f":"SUM(F61:F63)","v":0}]
[6,"Current collection and transport cost per tonne in Euro/ton",{"$f":"'7. C&T COST COVERAGE'!C25:D25","v":{"$error":"#DIV/0!"}},null,{"$f":"B67","v":"Estimated cost of collection and transport including increase for investments in equipment in Euro/tonne"},{"$f":"C67","v":{"$error":"#DIV/0!"}}]
[7,"Estimated cost of collection and transport including increase for investments in equipment in Euro/tonne",{"$f":"C66*(1+D64)","v":{"$error":"#DIV/0!"}},null,"Estimated increase in expenditures for investment in recycling, recovery and landfilling of collected quantities in Euro/ton",{"$f":"F64/'2. TOTAL WASTE COLLECTED '!H21","v":{"$error":"#DIV/0!"}}]
[8,"Estimated increase in collection and transport cost per tonne in Euro",{"$f":"C67-C66","v":{"$error":"#DIV/0!"}},{"$f":"C68/C66","v":{"$error":"#DIV/0!"}},"Estimated total cost of SWM (collection, transport, treatment and landfilling) with increase for investments in Euro/tonne ",{"$f":"F67+F66","v":{"$error":"#DIV/0!"}},{"$f":"F68/$F$69","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"B66","v":"Current collection and transport cost per tonne in Euro/ton"},{"$f":"C66","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Estimated increase in expenditres for investment in collection, transport, treatment and landfilling in Euro/tonne ",{"$f":"F68-F69","v":{"$error":"#DIV/0!"}},{"$f":"F70/$F$69","v":{"$error":"#DIV/0!"}}]
[]
[null,"HOME"]

{"sheet":"9. SW NARRATIVE INFO","index":9,"n_rows":175,"n_cols":8,"rows_kept":175,"cut":false,"hidden":false,"merged":[[26,2,26,4],[24,2,24,4],[29,4,29,5],[1,1,1,4],[0,1,0,4],[22,2,22,4],[154,3,154,4],[155,3,155,4],[166,3,166,4],[167,3,167,4],[168,3,168,4],[137,3,137,4],[138,3,138,4],[144,3,144,4],[131,3,131,4],[133,3,133,4],[57,2,57,4],[60,2,60,4],[134,3,134,4],[135,3,135,4],[132,3,132,4],[130,3,130,4],[62,2,62,4],[58,2,58,4],[174,1,176,1],[139,3,139,4],[140,3,140,4],[141,3,141,4],[143,3,143,4],[142,3,142,4],[165,3,165,4],[171,3,171,4],[145,3,145,4],[146,3,146,4],[147,3,147,4],[151,3,151,4],[152,3,152,4],[169,3,169,4],[170,3,170,4],[153,3,153,4]]}
[null,"MUNICIPAL WASTE MANAGEMENT  NARRATIVE INFORMATION "]
[null,{"$f":"'2. TOTAL WASTE COLLECTED '!B2:F2","v":0}]
[1,"Information gathering level",null,"YES","NO"]
[null,null,"Municipality"]
[null,null,"City "]
[null,null,"District, Region"]
[]
[2,"Type of collection",null,"YES","NO"]
[null,null,"Traditional"]
[null,null,"Separate collection of waste fractions"]
[null,null,"Separate collection of bulky waste"]
[]
[3,"Waste recovery operations",null,"YES","NO"]
[null,null,"organized "]
[null,null,"unorganized"]
[]
[4,"Location of organized separation ",null,"YES","NO"]
[null,null,"Home"]
[null,null,"Street"]
[null,null,"Landfill"]
[null,null,"Other"]
[]
[5,"Name and address of operators collecting and transporting municipal waste"]
[]
[6,"Name of the responsible person"]
[]
[7,"Last date of entry"]
[]
[]
[8,"COLLECTION VOLUME - Local Utility Company or operator collecting and transporting municipal waste","Equipment for waste collection and transport to disposal sites","TYPE","Capacity in m³/tonnes",null,"NUMBER"]
[null,null,"Rotopress trucks "]
[null,null,"Compactor trucks"]
[null,null,"Open trucks"]
[null,null,"Tractors",null,null,null,2]
[null,null,"Others"]
[null,null,"Recycling containers"]
[null,null,"Containers 5 t"]
[null,null,"Other"]
[null,null,"Recycling containers",null,null,null,"Number","m³"]
[null,null,"Skip container 3,5m³",null,null,null,null,{"$f":"G40*E40","v":0}]
[null,null,"Skip containers 5 m³",null,null,null,null,{"$f":"G41*E41","v":0}]
[null,null,"Skip container 7 m³",null,null,null,null,0]
[null,null,"Hooklift container 2,5m³",null,null,null,null,0]
[null,null,"Hooklift container 5 m³",null,null,null,null,0]
[null,null,"Hooklift container 10 m³",null,null,null,null,0]
[null,null,"Hooklift container 25 m³",null,null,null,null,0]
[null,null,"Hooklift container 35 m³",null,null,null,null,0]
[null,null,"Containers 1.100 l",null,null,null,null,0]
[null,null,"Container 660 l",null,null,null,null,0]
[null,null,"Container 770 l",null,null,null,null,0]
[null,null,"Bins 120 l",null,null,null,null,0]
[null,null,"Bins 240 l",null,null,null,null,0]
[null,null,"Bags",null,null,null,null,0]
[null,null,"Other",null,null,null,null,0]
[null,null,"SUM Collection Volume provided in m3",null,null,null,{"$f":"SUM(G40:G54)","v":0},{"$f":"SUM(H40:H54)","v":0}]
[]
[]
[9,"Location of the landfill – municipality and name of location, geo coordinates"]
[null,"Waste depositing staring year"]
[]
[10,"Municipalities delivering waste landfill "]
[]
[11,"Name and address of landfill operator"]
[]
[12,"Landfill - depositing site information",null,"YES","NO"]
[null,null,"EU conform"]
[null,null,"Traditional disposal site"]
[null,"Landfill - depositing site ownership","Public"]
[null,null,"Private"]
[null,null," Mixed"]
[null,"Landfill - depositing site Regulatory Status ","Permitted"]
[null,null,"Unpermitted"]
[null,null,"Exempt"]
[null,null,"Proposed"]
[null,null,"Illegal"]
[null,"Landfill - depositing site – Operational Status","Planned"]
[null,null,"In construction"]
[null,null,"Active"]
[null,null,"Inactive"]
[null,null,"Rehabilitation in process"]
[null,null,"To be closed"]
[null,null,"Closed"]
[null,null,"Clean Closed"]
[null,null,"To be Determined"]
[null,"Landfill - depositing site Operator type ","Federal"]
[null,null,"State"]
[null,null,"Regional"]
[null,null,"City"]
[null,null,"Municipal"]
[null,null,"Private"]
[null,null,"District"]
[null,"Infrastructure on landfill","Access road"]
[null,null,"Internal roads"]
[null,null,"Water"]
[null,null,"Sewerage"]
[null,null,"Electricity"]
[null,null,"Gas collection"]
[null,null,"Truck weight bridge"]
[null,null,"Vehicle washing equipment"]
[null,"Mechanization at disposal sites","Bulldozers"]
[null,null,"Compactors"]
[null,null,"Other - specify "]
[null,"Environment protection equipment on landfill","Drainage"]
[null,null,"Surface water channels "]
[null,null,"Leached water collection"]
[null,null,"Water purification system"]
[null,null,"Covering and compacting"]
[null,null,"Disinfection, deracination"]
[null,null,"Other"]
[null,"Type of waste deposited and technologies of waste treatment at landfill/depositing sites","Depositing permitted types of waste without treatment"]
[null,null,"Metals "]
[null,null,"Packaging waste"]
[null,null,"Agricultural waste"]
[null,null,"Construction waste"]
[null,null,"Electronic waste"]
[null,null,"Dangerous household waste"]
[null,null,"Medical waste"]
[null,null,"Animal waste"]
[null,null,"Ash and sludge"]
[null,null,"Tires"]
[null,null,"Waste covering with inert materials "]
[null,null,"Waste separation at site"]
[null,null,"Waste recovery/processing facility"]
[null,null,"Recycling facility"]
[null,null,"Composting facility"]
[null,null,"Gasification"]
[null,null,"Incineration"]
[null,null,"Combined treatment"]
[null,null,"Other - specify "]
[]
[null,"Landfill geometry ","Length in meters"]
[null,null,"Width in meters"]
[null,null,"Area in m2"]
[null,null,"Volume in m3"]
[null,null,"Total landfill capacity in m3"]
[null,null,"Landfill capacity used up to year 2010 in m3"]
[]
[null,"Landfill location distance in meters from ","Inhabited settlements "]
[null,null,"Streams, rivers, lakes"]
[null,null,"Water supply sources "]
[null,null,"Health centre or hospitals"]
[null,null,"Food manufacturing site"]
[null,null,"Underground infrastructure"]
[null,null,"Gas or oil pipeline"]
[null,null,"Bus or train station "]
[null,null,"Airport"]
[null,null,"Inflammable materials storage"]
[null,null,"Protected areas"]
[]
[]
[null,"Operative financing for collection and transport"]
[null,null,"User charges – tariffs (specify : for households per capita, per household, kg/ton or m2 in EURO)"]
[null,null,"User charges – tariffs (specify : for industry and commerce,  kg/ton, m2 or other in EURO)"]
[null,null,"Separate for transport and collection per m3 or kg/t in EURO"]
[null,null,"Separate for depositing on landfill per m3 or kg/t in EURO"]
[null,null,"One charge for collection and depositing per m3 or kg/t in EURO"]
[]
[13,"Full cost coverage for collection and transport  to landfill/ depositing site",null,"YES","NO"]
[null,null,"Present tariff covers operative costs"]
[null,null,"Present tariff covers operative costs including depreciation "]
[null,null,"Present tariff covers full cost including investment/loan return"]
[null,"Tipping fee and other charges for waste disposal at controlled landfills","Present tariff covers operative costs"]
[null,null,"Present tariff covers operative costs including depreciation "]
[null,null,"Present tariff covers full cost including investment/loan return"]
[]
[14,"Investment financing","Environmental Fund "]
[null,"Local plan for financing new controlled landfill or waste management, absolute figures in 000 Euros or % of total investment value ","International donation "]
[null,null,"National subsidies"]
[null,null,"Municipal budget "]
[null,null,"Direct Loans"]
[null,null,"Private sector investment or participation"]
[null,null,"Total",{"$f":"SUM(D166:E171)","v":0}]
[]
[]
[null,"HOME"]