{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Main Page","Decision Making","Input sheet","Budget Summary","Norms and Assumptions","Dropdown"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":"Main Page","index":0,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,2,27,5],[0,1,0,5],[6,1,6,5],[21,2,21,5],[25,2,25,5],[17,2,17,5],[19,2,19,5],[20,2,20,5],[26,2,26,5],[18,2,18,5],[22,3,22,5],[21,1,24,1]]}
[null,"Tool for gap assessment of\nequipments and vehicles for \nSolid Waste Management in Urban Local Bodies"]
[]
[]
[]
[]
[]
[null,"Objectives of this tool are to:\n1. Carry out  a gap assessment of the equipments and vehicles required for Solid waste management\n2. Estimate the number of vehicles and equipments to be procured for ensuring 100% coverage of waste management services in the ULB\n\nLimitation of this tool:\n1. It does not calculate construction cost for any infrastructure establishment like treatment plant, transfer station etc."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sr.No.","NOTES"]
[null,1,"Please fill the sheets in the following order-"]
[null,"i)","Decision Making"]
[null,"ii)","Input Sheet"]
[null,2,"The cells which are white in color are the cells which need to be filled by the city. Different cell colors indicate different meaning which is mentioned below:"]
[null,null,"Light Orange","Value generated automatically"]
[null,null,"Blue","Questions"]
[null,null,"White","Data to be filled"]
[null,3,"Some of the tables have been accompanied with notes on the side. Please go through the notes before filling in the details."]
[null,4,"In case the ULB does not have vehicles and equipment listed in existing situation section in the Input Sheet, insert zero (0), do not leave the cell blank."]
[null,5,"Placement of community bins is to be decided by the ULB"]

{"sheet":"Decision Making","index":1,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,1,0,3],[3,4,3,10]]}
[null,"As this excel workbook is a tool to find out requirements of vehicles and equipment for SWM, before moving ahead, some decisions have to be taken for accurate estimation, which are mentioned below:"]
[]
[null,1,"Proposed average number of trips per day of each vehicle used for Door to Door waste collection (Considering distance of waste disposal site from the ULB)",3]
[null,2,"Proposed average number of trips of each vehicle per day for collecting waste from bulk generators",2,"Bulk generators means waste generated from vegetable, meat, fruit & flower markets and kitchen of hotels and restaurants. It is recommended that if the ULB has composting plant then the waste generated from bulk generators should be collected separately and should be disposed directly to the plant."]
[null,3,"Beat length of road for street sweeping in meters",600]

{"sheet":"Input sheet","index":2,"n_rows":336,"n_cols":10,"rows_kept":336,"cut":false,"hidden":false,"merged":[[32,3,32,4],[55,1,55,2],[56,1,56,2],[57,1,57,2],[59,1,59,4],[51,0,51,2],[40,3,40,4],[46,1,46,4],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[52,1,52,4],[53,1,53,2],[58,1,58,2],[54,1,54,2],[36,3,37,4],[60,1,60,2],[117,8,117,9],[66,1,66,4],[67,1,67,2],[87,4,89,5],[91,1,91,3],[44,0,44,4],[128,5,129,5],[53,5,65,6],[77,0,77,1],[85,0,85,1],[115,8,116,9],[61,1,61,2],[128,7,129,7],[101,6,103,6],[101,7,103,7],[71,0,71,3],[115,1,116,1],[128,6,129,6],[111,0,111,7],[68,1,68,2],[63,1,63,2],[69,1,69,2],[70,1,70,2],[10,0,10,2],[15,0,15,2],[128,3,128,4],[112,0,113,0],[92,1,92,2],[98,1,98,2],[99,1,99,2],[97,0,97,2],[93,0,93,2],[87,1,87,2],[94,1,94,2],[95,1,95,2],[102,2,103,2],[112,1,113,1],[62,1,62,2],[96,1,96,2],[74,0,74,3],[73,1,73,3],[88,1,88,2],[89,1,89,2],[101,3,102,4],[104,0,104,7],[101,5,103,5],[64,1,64,2],[72,1,72,3],[69,5,69,7],[70,5,70,7],[65,0,65,3],[68,5,68,6],[128,1,129,2],[118,0,118,7],[115,0,116,0],[128,0,129,0],[76,1,76,2],[260,2,261,2],[253,0,253,2],[265,0,265,2],[276,0,276,2],[104,8,104,9],[101,8,103,9],[102,1,103,1],[101,1,101,2],[101,0,103,0],[131,1,131,2],[130,1,130,2],[153,7,154,7],[151,1,151,2],[147,1,147,2],[149,1,149,2],[157,1,157,2],[158,1,158,2],[155,1,155,2],[142,1,142,2],[144,3,145,3],[156,1,156,2],[146,1,146,2],[134,0,135,0],[171,1,171,3],[334,1,334,2],[281,1,281,2],[290,0,290,2],[258,1,258,5],[219,1,219,2],[252,1,252,2],[335,1,335,2],[270,1,270,3],[244,0,245,0],[244,1,245,1],[284,1,284,2],[282,1,282,2],[283,1,283,2],[271,1,271,2],[273,1,273,2],[332,1,332,2],[333,1,333,2],[295,1,295,4],[272,1,272,2],[262,0,262,2],[264,1,264,2],[275,1,275,2],[286,1,286,2],[289,1,289,2],[167,1,167,2],[183,4,183,8],[153,0,154,0],[144,0,145,0],[165,1,165,2],[173,1,173,2],[160,1,160,2],[161,1,161,2],[162,1,162,2],[164,1,164,2],[172,1,172,2],[148,1,148,2],[153,1,153,2],[154,1,154,2],[144,1,145,2],[169,1,169,2],[159,1,159,2],[144,4,145,4],[183,1,183,3],[166,1,166,2],[132,1,132,2],[136,1,136,2],[137,1,137,2],[138,1,138,2],[134,3,135,3],[141,1,141,2],[153,3,153,6],[134,4,135,4],[140,1,140,2],[134,1,135,2],[150,1,150,2],[139,1,139,2],[244,5,245,5],[203,1,203,3],[244,2,245,2],[244,4,245,4],[241,1,241,2],[244,3,245,3],[242,1,242,2],[243,1,243,2],[206,1,206,3],[204,1,204,3],[239,1,239,2],[238,1,238,3],[227,3,230,4],[225,1,225,2],[211,1,211,2],[210,1,210,3],[208,1,208,3],[196,1,196,3],[240,1,240,2],[198,1,198,3],[199,1,199,3],[200,1,200,3],[202,1,202,3],[220,0,220,2],[130,8,130,10],[176,0,176,8],[185,9,185,10],[191,1,191,3],[187,1,187,3],[194,1,194,3],[195,1,195,3],[189,1,189,3],[184,3,185,3],[183,9,184,10],[184,4,184,8],[184,1,185,1],[184,2,185,2],[168,1,168,2],[178,0,178,2],[182,0,182,8],[184,0,185,0]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["A. CITY PROFILE"]
[]
[]
[]
[]
["General Information"]
[1,"Name of the ULB"]
[2,"Name of the head of the ULB"]
[3,"Area of the ULB in sq.km."]
[4,"Inhabited Area (sq.km.)"]
[5,"Number of Election Wards"]
[6,"Total Population of the ULB (Census 2001)"]
[7,"Total Population of the ULB (Census 2011)"]
[8,"Total Number of Households (Census 2011)"]
[9,"Household Size (Census 2011)",{"$f":"IFERROR(C23/C24, 0)","v":0}]
[10,"Decadal Growth Rate of City Population (1981-1991)"]
[11,"Decadal Growth Rate of City Population (1991-2001)"]
[12,"Decadal Growth Rate of City Population (2001-2011)",{"$f":"IFERROR((C23-C22)/C22,0)","v":0}]
[13,"Yearly Growth Rate of  City Population",{"$f":"IFERROR(C28/10,0)","v":0}]
[14,"Total Population of the ULB (Current year)\n(As per latest survey conducted after census 2011 or based on the populaion projection)"]
[15,"Total Number of Households (Current Year)"]
[16,"Households in peri-urban areas"]
[17,"Number of Slum Settlements/Pockets\n(As per latest slum survey conducted after census 2011, SFCPoA etc.)",null,"Mention all slums as per list with ULB, use any latest surveys done under affordable housing mission/PMAY"]
[18,"Number of Slum Households\n(As per latest slum survey conducted after census 2011, SFCPoA etc.)"]
[19,"Slum Population\n(As per latest slum survey conducted after census 2011, SFCPoA etc.)"]
[20,"Total Number of Properties (Current Year)",{"$f":"C37+C38","v":0}]
[20.100000000000001,"Number of Residential Properties (Current Year)",null,"Number of residential and non-residential poperties registered with the ULB can be taken from property tax software"]
[20.2,"Number of Non-Residential (Commercial) Properties (2017)"]
[21,"Approx. area covered under Urban Village (Gamtal) in sq.km. (old city area where road width is less than 3m)"]
[22,"Approx. Number of Households in Urban Village (Gamtal)"]
[23,"Total Length of Road in kms (Both Kutcha and Pucca)",null,"Include the length of highways in case present in city limits"]
[23.1,"Total Length of Roads with Divider in kms"]
[23.2,"Approx. Length of Roads less than 3m width (kms)"]
[]
["B. Existing Scenario of Solid Waste"]
[]
["S.No.","WASTE GENERATION"]
[1,"Residential Generators",null,"Number","Estimated waste Generation (TPD)"]
[1.1000000000000001,"Households in Slum areas",null,{"$f":"'Input sheet'!C34","v":0}]
[1.2,"Households in Urban Village (Gamtal)",null,{"$f":"'Input sheet'!C40","v":0}]
[1.3,"Households in the Areas Other than slums and Urban Village (Gamtal)",null,{"$f":"'Input sheet'!C31-'Input sheet'!D49-'Input sheet'!D50","v":0}]
["Total Waste generated from Residential Generators",null,null,{"$f":"SUM(D49:D51)","v":0},{"$f":"SUM(E49:E51)","v":0}]
[2,"Bulk waste Generators"]
[2.1,"Kitchens of Hotels, Restaurants, mess and canteen of hostels",null,{"$f":"SUM(D55:D58)","v":0},{"$f":"SUM(E55:E58)","v":0},"Estimate the number of hotels (which has boarding and lodging Facilities) and Restaurants in the ULB and then estimate the approximate quantity of waste generated from these properties.\n\nNumber of hotels can be taken from license registered with the ULB (or may be it called trade license data)\n\nThis is only applicable to small bulk generators as it is assumed that large bulk generators will manage their waste in a decentralized manner"]
["2.1.1","Hotels"]
["2.1.2","Restaurants"]
["2.1.3","Mess/ Canteen of Hostels and Institutes"]
["2.1.4","Marriage Halls/ Party plots"]
[2.2000000000000002,"Religious Places (Temple, Gurudwara, Mosque etc.)"]
[2.2999999999999998,"Markets:"]
["2.3.1","   Vegetable"]
["2.3.2","   Flower and fruit"]
["2.3.3","   Meat and Fish"]
["2.3.4","   APMC Market"]
[2.4,"Waste from slaughter house"]
["Total Waste generated from Bulk Generators",null,null,null,{"$f":"E54+E59+SUM(E61:E64)+E65","v":0}]
[3,"Non Residential (Commercial) Generators"]
[3.1,"Malls and Shopping Complexes"]
[3.2,"Other Commercial Areas",null,null,null,"This includes shops, banks etc."]
[3.3,"Institutions",null,null,null,"This Includes educational institutions like schools, colleges, social institutions like trust buildings, town halls etc."]
[3.4,"Non-Hazardous Industrial Waste",null,null,null,"non-hazardous industrial waste generated within the jurisdiction of the ULB"]
["Total Waste generated from Non-Residential (Commercial) Generators",null,null,null,{"$f":"SUM(E68:E71)","v":0}]
[4,"Waste from Street Sweeping "]
[5,"Construction and Demolition Debris Waste (C&D waste)"]
["Total Waste Generation in the ULB",null,null,null,{"$f":"E52+E66+E72+E74+E73","v":0}]
[]
[6,"Characterisation of waste"]
["Constituents of waste",null,"% of waste"]
[6.1,"Paper and cardboard"]
[6.2,"Rubber, leather and Synthetics"]
[6.3,"Glass"]
[6.4,"Metal"]
[6.5,"Compostable matter"]
[6.6,"Plastic"]
[6.7,"Inert"]
["Total",null,{"$f":"IF(SUM(C79:C85)=1,SUM(C79:C85), \"Total must be 100%\")","v":"Total must be 100%"}]
[]
[7,"Total number of Dead Animals lifted in a month (Carcass Waste)",null,"Number","Estimate the Average Number of dead animals lifted by the ULB in a month"]
[7.1,"Small Animals (Cat, Dog, Goat, Pig, etc.)"]
[7.2,"Big Animals (Cow, Buffalo, Camel, etc.)"]
[]
[8,"Segregation of Waste"]
[8.1,"Does the ULB have an estimate of segregated dry and wet waste collected from residential and commercial areas?"]
["If yes, then-",null,null,"waste collected in TPD"]
["7.1.1","Wet Waste (TPD)"]
["7.1.2","Dry Waste (TPD)"]
[8.1999999999999993,"Does the ULB have an estimate of segregated Dry and Wet Waste Collected from bulk waste generators?"]
["If yes, then-",null,null,"waste collected in TPD"]
["7.2.1","Wet Waste (TPD)"]
["7.2.2","Dry Waste (TPD)"]
[]
[9,"Details of Existing Equipments and Vehicles for MSW Collection and Transportation in your City",null,"Ownership of equipments which are functional\n(Consider the vehicles procured after year 2013-14 only)",null,"Total Number of functional equipments","No. of functional equipments in use\nwhich are procured after year 2013-14 only","No. of functional equipments currently not in use or kept as Standby","Equipments which are procured before 2013 should not be considered"]
[null,"Name of Equipment/Vehicle","Capacity"]
[null,null,null,"ULB","Private Agency"]
["   Primary Collection",null,null,null,null,null,null,null,"Insert Zero (0) if the ULB doesn't have equipments or vehicles listed here"]
[9.1,"Hand Cart with 6 Bins for only D2D collection (Capacity in Kgs)",null,null,null,{"$f":"D106+E106","v":0},null,{"$f":"F106-G106","v":0}]
[9.1999999999999993,"Tricycle with bins (Capacity in Kgs)",null,null,null,0,null,0]
[9.3000000000000007,"3-wheeler auto with tipping hopper\n(Capacity in MT)",null,null,null,0,null,0]
[9.4,"Mini tipper (4 wheel Mini Truck Container Mounted)\n(Capacity in MT)",null,null,null,0,null,0]
[9.5,"Mini tipper (Closed Body to collect hotel and restaurant kitchen waste) (Capacity in MT)",null,null,null,0,null,0]
[9.6,"Tractor with Trolley (Capacity in MT)",null,null,null,0,null,0]
["   Secondary Collection"]
[9.6999999999999993,"Community Bins (Containers - Green and Black)","3 cu.m.",null,null,{"$f":"SUM(D113:E113)","v":0},null,{"$f":"F113-G113","v":0}]
[null,null,"4.5 cu.m.",null,null,{"$f":"SUM(D114:E114)","v":0},null,0]
[9.8000000000000007,"Hand Cart with 6 Bins for only Street Sweeping (Capacity in Kgs)",null,null,null,{"$f":"D115+E115","v":0},null,0]
[9.9,"Galvanized Trolley (Capacity in Litre)",null,null,null,{"$f":"D116+E116","v":0},null,0,"Refuse compactor is required for emptying waste from Galvanized Trolley"]
[null,null,null,null,null,{"$f":"D117+E117","v":0},null,0]
[9.1,"Litter bins in the commercial/market areas (Capacity in litre)",null,null,null,{"$f":"D118+E118","v":0},null,0,"Litter bins provided at important streets, markets, public areas, tourist spots, bus and railway station, commercial complexes etc. at a distance ranging from 25m to 250m depending on local condition"]
["   Transportation"]
[9.11,"Open Body Trucks with crane arm for C&D waste collection (Capacity in MT)",null,null,null,{"$f":"D120+E120","v":0},null,{"$f":"F120-G120","v":0}]
[9.1199999999999992,"Automated Dead Animals Lifting Vehicle",null,null,null,0,null,0]
[9.1300000000000008,"Refuse Compactors (Capacity in MT)",null,null,null,0,null,0]
[9.14,"Front End Loader (JCB)",null,null,null,0,null,0]
[9.15,"Single community bin lifter",null,null,null,0,null,0]
[9.16,"Twin community bin lifter",null,null,null,0,null,0]
[9.17,"Tempo Truck",null,null,null,0,null,0]
[9.18,"Mini Compactor (Capacity in MT)",null,null,null,0,null,0]
[]
[10,"Details of Other Vehicle",null,"Number of Equipments Owned By\n(Consider the vehicles procured after year 2013-14)",null,"Total Number of equipments","No. of equipments in use\nwhich are procured after year 2013-14","No. functional equipments currently not in use\n(Stand By)"]
[null,null,null,"ULB","Private Agency"]
[10.1,"Skid Steer Machine",null,null,null,{"$f":"SUM(D131:E131)","v":0},null,{"$f":"F131-G131","v":0},"It is a multi purpose vehicle which can be used to clean the streets, as a rollar, as an augar for digging soil"]
[10.199999999999999,"Small Excavator",null,null,null,{"$f":"SUM(D132:E132)","v":0},null,{"$f":"F132-G132","v":0}]
[10.3,"Litter Picker (capacity around 2 Tonne)",null,null,null,{"$f":"SUM(D133:E133)","v":0},null,{"$f":"F133-G133","v":0}]
[]
[11,"Street Sweeping Equipment/Kit",null,"Number","No. of Equipments  in Use"]
[]
[11.1,"Long handle broom"]
[11.2,"Metal Tray (Dust Pan)"]
[11.3,"Metal Plate"]
[11.4,"Ghamela"]
[11.5,"Spades"]
[11.6,"Tractor/Truck Mounted Road Sweeper Vacuum Machine"]
[11.7,"Tractor/Truck Mounted Road Broomer Machine"]
[]
[12,"Health Safety Gears for Sanitation Workers",null,"Number","No. of Safety gears in Use"]
[]
[12.1,"Uniform (Pair)"]
[12.2,"Gloves"]
[12.3,"Gum Boots"]
[12.4,"Safety Mask"]
[12.5,"Safety Jacket"]
[12.6,"Rain Coat"]
[]
[13,"Details of Human Resource for operation of SWM Equipments",null,"Total number of working staff",null,null,null,"Total Number of sanctioned staff"]
[null,"Human Resource",null,"Permanent","Contract\n(Fixed payment)","Daily labour","Total Number"]
[13.1,"Chief Sanitary Inspector (CSI)",null,null,null,null,{"$f":"SUM(D156:F156)","v":0}]
[13.2,"Public Health Supervisor (PHS)",null,null,null,null,0]
[13.3,"Sanitary Inspector (SI)",null,null,null,null,0]
[13.4,"Sanitary Sub Inspector (SSI)",null,null,null,null,0]
[13.5,"Safai Karmachari (Sanitation Workers)",null,null,null,null,0]
[13.6,"No. of Safai Karmachari Deployed for Street Sweeping",null,null,null,null,0]
[13.7,"Labour",null,null,null,null,0]
[13.8,"Driver",null,null,null,null,0]
[]
[14,"Details of solid waste disposal site",null,"Number"]
[14.1,"Solid waste disposed at"]
[14.2,{"$f":"IF(D166=\"Select option\", \"Area\", Dropdown!$B$11&'Input sheet'!$D$166&Dropdown!$C$11)","v":"Area of the  (in Acre)"}]
[14.3,{"$f":"IF(D166=\"Select option\", \"Capacity\", Dropdown!$B$12&'Input sheet'!$D$166&Dropdown!$C$12)","v":"Capacity of the  (in MT)"}]
[14.4,{"$f":"IF(D166=\"Select option\", \"Approx. distance\", Dropdown!$B$13&'Input sheet'!$D$166&Dropdown!$C$13)","v":"Approx. distance of the  (in km)"}]
[14.5,{"$f":"IF(D166=\"Select option\", \"operated and maintained by\", D166&Dropdown!B15)","v":" operated and maintained by"}]
[]
[15,"Details about Transfer Station"]
[15.1,"Does the ULB have transfer station?"]
[15.2,"If yes, number of transfer station in the ULB"]
[]
[]
["C. Gap Analysis"]
[]
["Requirement of dustbins for Waste Segregation at Source"]
["S.No.","Total number of properties in the ULB","Requirement of dustbins in year 2017-18"]
[1,{"$f":"'Input sheet'!C36","v":0},{"$f":"B181*2","v":0}]
[]
["Requirement of vehicles/equipment for Residential Waste Generators"]
["S.No.","Waste generation from residential areas",null,null,"Proposed Primary Collection From Residential Areas",null,null,null,null,"Door to door collection should be done in the morning"]
[1,"Waste Generators","Number of HHs","Estimated waste Generation (TPD)","% of HH breakup for Preferred Vehicle for Primary Collection"]
[null,null,null,null,"Hand Cart with 6 Bins","Tricycle with bins","3-wheeler auto with tipping hopper","Mini Tipper (4 wheel Mini Truck Container Mounted)","Tractor with trolley","Fill proposed % break up of HHs to be covered by preferred vehicles for collection. For eg. Suppose there are 1000 HHs in slum areas and you want to cover 20% HHs by Hand Carts then put 20% in the cell. Total should be 100%"]
[1.1000000000000001,"Households in Slum areas",{"$f":"'Input sheet'!D49","v":0},{"$f":"'Input sheet'!E49","v":0},null,null,null,null,null,{"$f":"IF(SUM(E187:I187)=100%,\" \",\"Total must be 100%\")","v":"Total must be 100%"}]
["1.1.1","No. of Trips Required for each vehicle",null,null,{"$f":"IF(E187=0,0,'Decision Making'!$D$3)","v":0},{"$f":"IF(F187=0,0,'Decision Making'!$D$3)","v":0},{"$f":"IF(G187=0,0,'Decision Making'!$D$3)","v":0},{"$f":"IF(H187=0,0,'Decision Making'!$D$3)","v":0},{"$f":"IF(I187=0,0,'Decision Making'!$D$3)","v":0}]
[1.2,"Households in Urban Village (Gamtal)",{"$f":"'Input sheet'!D50","v":0},{"$f":"'Input sheet'!E50","v":0},null,null,null,null,null,{"$f":"IF(D189=0,\"\",IF(SUM(E189:I189)=100%,\" \",\"Total must be 100%\"))","v":""}]
["1.2.1","No. of Trips Required for each vehicle",null,null,{"$f":"IF(E189=0,0,'Decision Making'!$D$3)","v":0},{"$f":"IF(F189=0,0,'Decision Making'!$D$3)","v":0},{"$f":"IF(G189=0,0,'Decision Making'!$D$3)","v":0},{"$f":"IF(H189=0,0,'Decision Making'!$D$3)","v":0},{"$f":"IF(I189=0,0,'Decision Making'!$D$3)","v":0}]
[1.3,"Households in the Areas Other than slums and Urban Village (Gamtal)",{"$f":"'Input sheet'!D51","v":0},{"$f":"'Input sheet'!E51","v":0},null,null,null,null,null,{"$f":"IF(SUM(E191:I191)=100%,\" \",\"Total must be 100%\")","v":"Total must be 100%"}]
["1.3.1","No. of Trips Required for each vehicle",null,null,{"$f":"IF(E191=0,0,'Decision Making'!$D$3)","v":0},{"$f":"IF(F191=0,0,'Decision Making'!$D$3)","v":0},{"$f":"IF(G191=0,0,'Decision Making'!$D$3)","v":0},{"$f":"IF(H191=0,0,'Decision Making'!$D$3)","v":0},{"$f":"IF(I191=0,0,'Decision Making'!$D$3)","v":0}]
[1.4,"Total Waste generated from Residential Generators",{"$f":"SUM(C187+C189+C191)","v":0},{"$f":"SUM(D187+D189+D191)","v":0}]
[]
[null,"Total number of HHs to be served by respective vehicles",null,null,{"$f":"$C$187*E187","v":0},{"$f":"$C$187*F187","v":0},{"$f":"$C$187*G187","v":0},{"$f":"$C$187*H187","v":0},{"$f":"$C$187*I187","v":0}]
[null,"No. of Vehiles Required (single Trip)",null,null,{"$f":"E195/'Norms and Assumptions'!B2","v":0},{"$f":"F195/'Norms and Assumptions'!B3","v":0},{"$f":"G195/'Norms and Assumptions'!B4","v":0},{"$f":"H195/'Norms and Assumptions'!B5","v":0},{"$f":"I195/'Norms and Assumptions'!B8","v":0}]
[null,"Total number of vehicles required to cover HHs in Slum Areas",null,null,{"$f":"IF(E188=0,0,(E196/E188))","v":0},{"$f":"IF(F188=0,0,(F196/F188))","v":0},{"$f":"IF(G188=0,0,(G196/G188))","v":0},{"$f":"IF(H188=0,0,(H196/H188))","v":0},{"$f":"IF(I188=0,0,(I196/I188))","v":0}]
[]
[null,"Total number of HHs to be served by respective vehicles",null,null,{"$f":"$C$189*E189","v":0},{"$f":"$C$189*F189","v":0},{"$f":"$C$189*G189","v":0},{"$f":"$C$189*H189","v":0},{"$f":"$C$189*I189","v":0}]
[null,"No. of Vehiles Required (single Trip)",null,null,{"$f":"E199/'Norms and Assumptions'!B2","v":0},{"$f":"F199/'Norms and Assumptions'!B3","v":0},{"$f":"G199/'Norms and Assumptions'!B4","v":0},{"$f":"H199/'Norms and Assumptions'!B5","v":0},{"$f":"I199/'Norms and Assumptions'!B8","v":0}]
[null,"Total number of vehicles required to cover HHs in Urban Village (Gamtal)",null,null,{"$f":"IF(E190=0, 0, (E200/E190))","v":0},{"$f":"IF(F190=0, 0, (F200/F190))","v":0},{"$f":"IF(G190=0, 0, (G200/G190))","v":0},{"$f":"IF(H190=0, 0, (H200/H190))","v":0},{"$f":"IF(I190=0, 0, (I200/I190))","v":0}]
[]
[null,"Total number of HHs to be served by respective vehicles",null,null,{"$f":"$C$191*E191","v":0},{"$f":"$C$191*F191","v":0},{"$f":"$C$191*G191","v":0},{"$f":"$C$191*H191","v":0},{"$f":"$C$191*I191","v":0}]
[null,"No. of Vehiles Required (single Trip)",null,null,{"$f":"E203/'Norms and Assumptions'!B2","v":0},{"$f":"F203/'Norms and Assumptions'!B3","v":0},{"$f":"G203/'Norms and Assumptions'!B4","v":0},{"$f":"H203/'Norms and Assumptions'!B5","v":0},{"$f":"I203/'Norms and Assumptions'!B8","v":0}]
[null,"Total number of vehicles required to cover HHs in Slum Areas",null,null,{"$f":"IF(E192=0,0,(E204/E192))","v":0},{"$f":"IF(F192=0,0,(F204/F192))","v":0},{"$f":"IF(G192=0,0,(G204/G192))","v":0},{"$f":"IF(H192=0,0,(H204/H192))","v":0},{"$f":"IF(I192=0,0,(I204/I192))","v":0}]
[]
[null,"Total Number of Vehicles Required",null,null,{"$f":"ROUND((E197+E201+E205),0)","v":0},{"$f":"ROUND((F197+F201+F205),0)","v":0},{"$f":"ROUND((G197+G201+G205),0)","v":0},{"$f":"ROUND((H197+H201+H205),0)","v":0},{"$f":"ROUND((I197+I201+I205),0)","v":0}]
[]
[1.5,"Total number of vehicles required to collect the waste generated from Residential Generators",null,null,{"$f":"E207","v":0},{"$f":"F207","v":0},{"$f":"G207","v":0},{"$f":"H207","v":0},{"$f":"I207","v":0}]
[]
[2,"Requirement of vehicles for Commercial Waste Generators"]
[2.1,"Total waste generated from commercial areas (in MT)",null,{"$f":"'Input sheet'!E72","v":0}]
["2a","Type of Vehicle","Hand Cart with 6 Bins","Tricycle with bins","3-wheeler auto with tipping hopper","Mini Tipper (4 wheel Mini Truck Container Mounted)","Tractor with trolley","Mini Compactors"]
["2a.1","% of waste to be collected by preferred vehicle for primary collection",null,null,null,null,null,null,{"$f":"IF(SUM(C214:H214)=100%,\" \",\"Total must be 100%\")","v":"Total must be 100%"}]
["2a.2","No. of Trips Required for each vehicle",{"$f":"IF(C214=0,0,'Decision Making'!$D$3)","v":0},{"$f":"IF(D214=0,0,'Decision Making'!$D$3)","v":0},{"$f":"IF(E214=0,0,'Decision Making'!$D$3)","v":0},{"$f":"IF(F214=0,0,'Decision Making'!$D$3)","v":0},{"$f":"IF(G214=0,0,'Decision Making'!$D$3)","v":0},{"$f":"IF(H214=0,0,'Decision Making'!$D$3)","v":0}]
["2a.3","Waste collected by respective vehicles",{"$f":"$D$212*C214","v":0},0,0,0,0,0]
["2a.4","No. of Vehiles Required (single Trip)",{"$f":"ROUNDUP((C216/'Norms and Assumptions'!E2),0)","v":0},{"$f":"ROUNDUP((D216/'Norms and Assumptions'!E3),0)","v":0},{"$f":"ROUNDUP((E216/'Norms and Assumptions'!E4),0)","v":0},{"$f":"ROUNDUP((F216/'Norms and Assumptions'!E5),0)","v":0},{"$f":"ROUNDUP((G216/'Norms and Assumptions'!E8),0)","v":0},{"$f":"ROUNDUP((H216/'Norms and Assumptions'!E13),0)","v":0}]
["2a.3","Total number of vehicles required to collect waste from commecrial areas",{"$f":"ROUNDUP(IF(C214=0,0,(C217/C215)),0)","v":0},0,0,0,0,0]
[]
["2b","Proposed mode of vehicle procurement for D2D collection from Residential and Commercial Areas"]
["Insert the percentage of vehicles to be procured by"]
["2b.1","Private Agency "]
["2b.2","ULB"]
["2b.3","Total ",{"$f":"IF(SUM(C222:C223)=100%,SUM(C222:C223),\"Total must be to 100%\")","v":"Total must be to 100%"}]
[]
[3,"Details of Secondary waste collection and transportation to dump/landfill/treatment site"]
["Sr. No.","Bins / Vehicles","Additional requirement of bins and vehicles to be procured"]
[3.1,"Community Bins with capacity of 3 cu.mt.",null,"First list out the locations where community bins are required to be placed and which capacity of bin is needed for the location. While inserting number of bins, do not consider the number of existing bins that ULB has. Only enter the additional number of bins that are required."]
[3.2,"Community Bins with capacity of 4.5 cu.mt."]
[3.3,"Galvanized Trolley with capacity of 660 L"]
[3.4,"Galvanized Trolley with capacity of 1100 L"]
[3.5,"Single community bin lifter",{"$f":"ROUND(IF(AND('Input sheet'!F124=0,'Input sheet'!F125>0),0, IF(AND('Input sheet'!F124>0,'Input sheet'!F125=0), ('Input sheet'!G113+'Input sheet'!G114+'Input sheet'!C228+'Input sheet'!C229)/'Norms and Assumptions'!B92,IF(AND('Input sheet'!F124>0,'Input sheet'!F125>0), (('Input sheet'!G113+'Input sheet'!G114+'Input sheet'!C228+'Input sheet'!C229)*0.5)/'Norms and Assumptions'!B92))),0)","v":0}]
[3.6,"Twin community bin lifter",{"$f":"ROUND(IF(AND('Input sheet'!F124>0,'Input sheet'!F125=0),0, IF(AND('Input sheet'!F124=0,'Input sheet'!F125>0), ('Input sheet'!G113+'Input sheet'!G114+'Input sheet'!C228+'Input sheet'!C229)/'Norms and Assumptions'!B93,IF(AND('Input sheet'!F124>0,'Input sheet'!F125>0), (('Input sheet'!G113+'Input sheet'!G114+'Input sheet'!C228+'Input sheet'!C229)*0.5)/'Norms and Assumptions'!B93))),0)","v":0}]
[3.7,"Mini Compactor"]
[3.8,"Refuse Compactor",{"$f":"ROUNDUP((((C230+'Input sheet'!F116)*'Norms and Assumptions'!E9)+(('Input sheet'!C231+'Input sheet'!F117)*'Norms and Assumptions'!E10))/('Norms and Assumptions'!E14*'Norms and Assumptions'!B96),0)","v":0}]
[3.9,"Front End Loader (JCB)",{"$f":"IF('Input sheet'!D170=Dropdown!D3,0,IF('Input sheet'!C30=\"\",0,IF('Input sheet'!C30<=1000000,1,\"\")))","v":0}]
[3.1,"Litter bins in the the commercial/market areas"]
[]
[4,"Requirement of vehicles/equipment for Street Sweeping"]
[4.0999999999999996,"Number of safai karmachari required for street sweeping (As per beat length)",null,{"$f":"IF('Input sheet'!C42=\"\",\"Please enter total length of roads with divider in City Profile Section in cell C42\",ROUNDUP((((('Input sheet'!C41-'Input sheet'!C42)*1000)/'Decision Making'!D5)+(('Input sheet'!C42*2*1000)/'Decision Making'!D5)),0))","v":"Please enter total length of roads with divider in City Profile Section in cell C42"}]
[4.2,"Requirement of Hand Cart for Street Sweeping",null,{"$f":"IF(D240=\"Please enter total length of roads with divider in City Profile Section in cell C42\",0,ROUNDUP(D240,0))","v":0}]
[4.3,"Requirement of Hand Cart for Street Sweeping with Additional 10% stock",null,{"$f":"IFERROR(ROUNDUP((D241*1.1),0),0)","v":0}]
[4.4000000000000004,"Tractor Mounted Road Sweeper Vacuum Machine"]
[4.5,"Tractor Mounted Road Broomer Machine"]
["4a","Street Sweeping Vehicle and Equipments/Kit","Number of Equipments Required","Total Requirement of Equipments (Including 10% Extra Stock)","Existing number of euipment","Net requirement of equipment"]
[]
["4a.1","Long handle broom",{"$f":"IFERROR(IF('Input sheet'!$G$161>'Input sheet'!$D$240,'Input sheet'!$G$161*'Norms and Assumptions'!B30,'Input sheet'!$D$240*'Norms and Assumptions'!B30),0)","v":0},{"$f":"ROUNDUP((C247*1.1),0)","v":0},{"$f":"'Input sheet'!D137","v":0},{"$f":"IFERROR(IF((D247-E247)<0,0,(D247-E247)),0)","v":0}]
["4a.2","Metal Tray (Dust Pan)",{"$f":"IFERROR(IF('Input sheet'!$G$161>'Input sheet'!$D$240,'Input sheet'!$G$161*'Norms and Assumptions'!B31,'Input sheet'!$D$240*'Norms and Assumptions'!B31),0)","v":0},{"$f":"ROUNDUP((C248*1.1),0)","v":0},{"$f":"'Input sheet'!D138","v":0},{"$f":"IFERROR(IF((D248-E248)<0,0,(D248-E248)),0)","v":0}]
["4a.3","Metal Plate",{"$f":"IFERROR(IF('Input sheet'!$G$161>'Input sheet'!$D$240,'Input sheet'!$G$161*'Norms and Assumptions'!B32,'Input sheet'!$D$240*'Norms and Assumptions'!B32),0)","v":0},{"$f":"ROUNDUP((C249*1.1),0)","v":0},{"$f":"'Input sheet'!D139","v":0},{"$f":"IFERROR(IF((D249-E249)<0,0,(D249-E249)),0)","v":0}]
["4a.4","Ghamela",{"$f":"IFERROR(IF('Input sheet'!$G$161>'Input sheet'!$D$240,'Input sheet'!$G$161*'Norms and Assumptions'!B33,'Input sheet'!$D$240*'Norms and Assumptions'!B33),0)","v":0},{"$f":"ROUNDUP((C250*1.1),0)","v":0},{"$f":"'Input sheet'!D140","v":0},{"$f":"IFERROR(IF((D250-E250)<0,0,(D250-E250)),0)","v":0}]
["4a.5","Spades",{"$f":"IFERROR(IF('Input sheet'!$G$161>'Input sheet'!$D$240,'Input sheet'!$G$161*'Norms and Assumptions'!B34,'Input sheet'!$D$240*'Norms and Assumptions'!B34),0)","v":0},{"$f":"ROUNDUP((C251*1.1),0)","v":0},{"$f":"'Input sheet'!D141","v":0},{"$f":"IFERROR(IF((D251-E251)<0,0,(D251-E251)),0)","v":0}]
[]
["4b","Proposed mode of vehicle procurement for Secondary waste collection"]
["Insert the percentage of vehicles to be procured by"]
["4b.1","Private Agency "]
["4b.2","ULB"]
["4b.3","Total ",{"$f":"IF(SUM(C255:C256)=100%,SUM(C255:C256),\"Total must be to 100%\")","v":"Total must be to 100%"}]
[]
[5,"Requirement of vehicles/equipment for Bulk Waste Generators"]
["Sr. No.","Type of Vehicle","Total Waste generated by the Bulk Generators (TPD)","% of waste to be carried by type of vehicle","No. Trips Required","No. of vehicles Required"]
[5.0999999999999996,"Mini Tipper (Closed Body vehicle for Hotel and Kitchen waste collection)",{"$f":"E66","v":0},null,{"$f":"IF(D261=0,0,'Decision Making'!$D$4)","v":0},{"$f":"ROUNDUP((IF(D261=0,0,((C261*D261)/(E261*'Norms and Assumptions'!E6)))),0)","v":0}]
[5.2,"Tempo Truck",null,null,{"$f":"IF(D262=0,0,'Decision Making'!$D$4)","v":0},{"$f":"IF(D262=0,0,ROUNDUP((C261*D262)/(E262*'Norms and Assumptions'!E7),0))","v":0}]
["Total",null,null,{"$f":"IF(SUM(D261:D262)=100%,SUM(D261:D262),\"Total must be 100%\")","v":"Total must be 100%"}]
[]
["5a","Proposed mode of vehicle procurement for waste collection from Bulk Generators"]
["Insert the percentage of vehicles to be procured by"]
["5a.1","Private Agency "]
["5a.2","ULB"]
["5a.3","Total ",{"$f":"IF(SUM(C267:C268)=100%,SUM(C267:C268),\"Total must be to 100%\")","v":"Total must be to 100%"}]
[]
[6,"Requirement of vehicles/equipment for C&D Waste"]
[6.1,"Quantity of C&D waste generated in the ULB (in MT)",null,{"$f":"'Input sheet'!E74","v":0}]
[6.2,"Number of trips required"]
[6.3,"Requirement of open body truck with crane arm",null,{"$f":"IF(D272=0,0,IF(D273=\"\",\"Please insert number of trips required\",ROUNDUP((D272/'Norms and Assumptions'!E12)/D273,0)))","v":0}]
[]
["6a","Proposed mode of vehicle procurement for C&D waste collection"]
["Insert the percentage of vehicles to be procured by"]
["6a.1","Private Agency "]
["6a.2","ULB"]
["6a.3","Total ",{"$f":"IF(SUM(C278:C279)=100%,SUM(C278:C279),\"Total must be to 100%\")","v":"Total must be to 100%"}]
[]
[7,"Requirement of Other Vehicle",null,"Total number of vehicle Required"]
[7.1,"Skid Steer Machine"]
[7.2,"Small Excavator"]
[7.3,"Litter Picker (capacity around 2 Tonne)"]
[]
[8,"Requirement of vehicles for Carcass Waste"]
[8.1,"Automated dead animal lifting vehicle",{"$f":"IF(C19=0,\"\",IF('Input sheet'!C19>300,'Norms and Assumptions'!B88,IF('Input sheet'!C19>100,'Norms and Assumptions'!B87,IF('Input sheet'!C19>50,'Norms and Assumptions'!B86,IF('Input sheet'!C19<50,'Norms and Assumptions'!B85)))))","v":""}]
[]
["8a","Proposed mode of vehicle procurement for Carcass waste collection"]
["Insert the percentage of vehicles to be procured by"]
["8a.1","Private Agency "]
["8a.2","ULB"]
["8a.3","Total ",{"$f":"IF(SUM(C292:C293)=100%,SUM(C292:C293),\"Total must be to 100%\")","v":"Total must be to 100%"}]
[]
[9,"Summary of vehicles/equipment required for solid waste collection"]
["S. No.","Vehicle/Equipment","Requirement of vehicles/equipment for waste collection","Existing number of vehicles/equipment","Additional number of vehicles/equipment to be procured"]
[9.1,"Hand Cart with 6 Bins for only D2D collection from Residential and Commercial areas",{"$f":"E209+C218","v":0},{"$f":"'Input sheet'!F106","v":0},{"$f":"IFERROR(IF((C298-D298)<0,0,(C298-D298)),0)","v":0}]
[9.1999999999999993,"Hand Cart with 6 Bins for only street sweeping",{"$f":"D242","v":0},{"$f":"F115","v":0},0]
[9.3000000000000007,"Tricycle with bins",{"$f":"F209+D218","v":0},{"$f":"'Input sheet'!F107","v":0},0]
[9.4,"3-wheeler auto with tipping hopper",{"$f":"G209+E218","v":0},{"$f":"'Input sheet'!F108","v":0},0]
[9.5,"Mini tipper (4 wheel Mini Truck Container Mounted)",{"$f":"H209+F218","v":0},{"$f":"'Input sheet'!F109","v":0},0]
[9.6,"Mini tipper (Closed Body to collect hotel and restaurant kitchen waste)",{"$f":"F261","v":0},{"$f":"'Input sheet'!F110","v":0},0]
[9.6999999999999993,"Tractor with trolley",{"$f":"I209+G218","v":0},{"$f":"'Input sheet'!F111","v":0},0]
[9.8000000000000007,"Tempo Truck",{"$f":"F262","v":0},{"$f":"'Input sheet'!F126","v":0},{"$f":"IFERROR(IF((C305-D305)<0,0,(C305-D305)),0)","v":0}]
[9.9,"Open Body Truck with crane arm for C&D waste",{"$f":"D274","v":0},{"$f":"'Input sheet'!F120","v":0},0]
[9.1,"Mini Compactor for D2D collection in commercial areas",{"$f":"H218","v":0},{"$f":"'Input sheet'!F127","v":0},0]
[9.11,"Refuse Compactor",{"$f":"C235","v":0},{"$f":"'Input sheet'!F122","v":0},0]
[9.1199999999999992,"Single community bin lifter",{"$f":"C232","v":0},{"$f":"'Input sheet'!F124","v":0},0]
[9.1300000000000008,"Twin community bin lifter",{"$f":"C233","v":0},{"$f":"'Input sheet'!F125","v":0},0]
[9.14,"Automated dead animal lifting vehicle",{"$f":"IF(C288=\"\", 0, C288)","v":0},{"$f":"'Input sheet'!F121","v":0},0]
[9.15,"Front End Loader (JCB)",{"$f":"IF(C236=\"\",0,C236)","v":0},{"$f":"'Input sheet'!F123","v":0},0]
[9.16,"Mini Compactor for secondary waste collection",{"$f":"C234","v":0},null,{"$f":"C234","v":0}]
[9.17,"Tractor Mounted Road Sweeper Vacuum Machine",{"$f":"D243","v":0},null,{"$f":"C314","v":0}]
[9.18,"Tractor Mounted Road Broomer Machine",{"$f":"D244","v":0},null,0]
[9.19,"Skid Steer Machine",{"$f":"D283","v":0},null,0]
[9.1999999999999993,"Small Excavator",{"$f":"D284","v":0},null,0]
[9.2100000000000009,"Litter Picker (capacity around 2 Tonne)",{"$f":"D285","v":0},null,0]
[9.2200000000000006,"Community Bins with capacity of 3 cu.mt.",{"$f":"C228","v":0},null,0]
[9.23,"Community Bins with capacity of 4.5 cu.mt.",{"$f":"C229","v":0},null,0]
[9.24,"Galvanized Trolley with capacity of 660 L",{"$f":"C230","v":0},null,0]
[9.25,"Galvanized Trolley with capacity of 1100 L",{"$f":"C231","v":0},null,0]
[9.26,"Litter bins in the the commercial/market areas (Capacity in litre)",{"$f":"C237","v":0},null,0]
[]
[10,"Health Safety Gears for Sanitation Workers","Number of Safety Gears Required","Total Requirement of safety gears (Including 10% Extra Stock)","Existing number of safety gears","Net Requirement of safety gears"]
[10.1,"Uniform",{"$f":"'Input sheet'!$G$160*'Norms and Assumptions'!B35","v":0},{"$f":"ROUNDUP(C326*1.1,0)","v":0},{"$f":"'Input sheet'!D147","v":0},{"$f":"IFERROR(IF((D326-E326)<0,0,(D326-E326)),0)","v":0}]
[10.199999999999999,"Gloves",{"$f":"'Input sheet'!$G$160*'Norms and Assumptions'!B36","v":0},0,{"$f":"'Input sheet'!D148","v":0},0]
[10.3,"Gum Boots",{"$f":"'Input sheet'!$G$160*'Norms and Assumptions'!B37","v":0},0,{"$f":"'Input sheet'!D149","v":0},0]
[10.4,"Safety Mask",{"$f":"'Input sheet'!$G$160*'Norms and Assumptions'!B38","v":0},0,{"$f":"'Input sheet'!D150","v":0},0]
[10.5,"Safety Jacket",{"$f":"'Input sheet'!$G$160*'Norms and Assumptions'!B39","v":0},0,{"$f":"'Input sheet'!D151","v":0},0]
[10.6,"Rain Coat",{"$f":"'Input sheet'!$G$160*'Norms and Assumptions'!B40","v":0},0,{"$f":"'Input sheet'!D152","v":0},0]
[]
[11,"Details of total net requirement of vehicles and equipments",null,"Number"]
[11.1,"Total no. of vehicles required to collect and transport the waste",null,{"$f":"SUM(E298:E318)","v":0}]
[11.2,"Total no. of equipments required for secondary collection of waste",null,{"$f":"SUM(E319:E322)","v":0}]
[11.3,"Total no. of health safety gears required for the sanitation workers",null,{"$f":"SUM(F326:F331)","v":0}]

{"sheet":"Budget Summary","index":3,"n_rows":178,"n_cols":6,"rows_kept":178,"cut":false,"hidden":false,"merged":[[177,0,177,1],[175,0,175,1],[127,0,127,4],[152,0,152,4],[126,0,126,4],[150,0,150,1],[148,0,148,1],[82,0,82,1],[84,1,84,5],[0,0,0,5],[53,0,53,1],[45,1,45,5],[57,1,57,5],[72,0,72,1],[44,0,44,5],[73,0,73,1],[74,0,74,1],[54,0,54,1],[55,0,55,1],[81,0,81,1],[80,0,80,1],[76,1,76,5],[123,0,123,1],[109,0,109,1],[118,0,118,1],[87,0,87,1],[88,0,88,1],[90,1,90,5],[96,1,96,5],[101,0,101,1],[93,0,93,1],[94,0,94,1]]}
["Summary of Budget"]
[]
[]
[]
[]
[]
[]
[null,"Demographic Profile of the ULB","Details"]
[null,{"$f":"'Input sheet'!B17","v":"Name of the ULB"},{"$f":"IF('Input sheet'!C17=\"\",\"\",'Input sheet'!C17)","v":""}]
[null,{"$f":"'Input sheet'!B19","v":"Area of the ULB in sq.km."},{"$f":"IF('Input sheet'!C19=\"\",\"\",'Input sheet'!C19)","v":""}]
[null,{"$f":"'Input sheet'!B21","v":"Number of Election Wards"},{"$f":"IF('Input sheet'!C21=\"\",\"\",'Input sheet'!C21)","v":""}]
[null,{"$f":"'Input sheet'!B30","v":"Total Population of the ULB (Current year)\n(As per latest survey conducted after census 2011 or based on the populaion projection)"},{"$f":"IF('Input sheet'!C30=\"\",\"\",'Input sheet'!C30)","v":""}]
[null,{"$f":"'Input sheet'!B31","v":"Total Number of Households (Current Year)"},{"$f":"IF('Input sheet'!C31=\"\",\"\",'Input sheet'!C31)","v":""}]
[null,{"$f":"'Input sheet'!B33","v":"Number of Slum Settlements/Pockets\n(As per latest slum survey conducted after census 2011, SFCPoA etc.)"},{"$f":"IF('Input sheet'!C33=\"\",\"\",'Input sheet'!C33)","v":""}]
[null,{"$f":"'Input sheet'!B35","v":"Slum Population\n(As per latest slum survey conducted after census 2011, SFCPoA etc.)"},{"$f":"IF('Input sheet'!C35=\"\",\"\",'Input sheet'!C35)","v":""}]
[null,{"$f":"'Input sheet'!B34","v":"Number of Slum Households\n(As per latest slum survey conducted after census 2011, SFCPoA etc.)"},{"$f":"IF('Input sheet'!C34=\"\",\"\",'Input sheet'!C34)","v":""}]
[null,"Total Watse Generation in TPD (Current year)",{"$f":"IF('Input sheet'!E75=\"\",\"\",'Input sheet'!E75)","v":0}]
[]
[null,"Total Capital Cost","Cost in Rs."]
[null,"2017-18",{"$f":"D54+D73+D81+D87+D93+D102+D110+D119+D122","v":0}]
[null,"2018-19",{"$f":"E54+E73+E81+E87+E93+E102+E110+E119","v":0}]
[null,"2019-20",{"$f":"F54+F73+F81+F87+F93+F102+F110+F119","v":0}]
[null,"Total",{"$f":"SUM(C20:C22)","v":0}]
[]
[null,"Total Operation and Maintenance Cost","Cost in Rs."]
[null,"2017-18",{"$f":"C149+C176","v":0}]
[null,"2018-19",{"$f":"D149+D176","v":0}]
[null,"2019-20",{"$f":"E149+E176","v":0}]
[null,"Total",{"$f":"SUM(C26:C28)","v":0}]
[]
[null,"Break-up of Capex based on percentage of vehicles that ULB wants to be procured by the Private Agency","ULB Share","Private Agency Share"]
[null,"D2D collection from residential and commercial areas",{"$f":"D56","v":0},{"$f":"D55","v":0}]
[null,"Secondary waste collection",{"$f":"D75","v":0},{"$f":"D74","v":0}]
[null,"Waste collection from bulk generators",{"$f":"D83","v":0},{"$f":"D82","v":0}]
[null,"C&D waste collection",{"$f":"D89","v":0},{"$f":"D88","v":0}]
[null,"Carcass waste collection",{"$f":"D95","v":0},{"$f":"D94","v":0}]
[null,"Procurement of other vehicles",{"$f":"SUM(D102:F102)","v":0},"-"]
[null,"Equipments of street sweeping",{"$f":"SUM(D110:F110)","v":0},"-"]
[null,"Health safety gears",{"$f":"SUM(D119:F119)","v":0},"-"]
[null,"Household dustbins for source segregation",{"$f":"D122","v":0},"-"]
[null,"Total Cost",{"$f":"SUM(C32:C40)","v":0},{"$f":"SUM(D32:D40)","v":0}]
[]
[null,"Total amount required for procurement of Vehicles/Equipments and its O&M",{"$f":"C23+C29","v":0}]
[]
["Details of CAPEX for Procurement of Equipments and Vehicles"]
[1,"Requirement of vehicles for D2D collection from Residential and Commercial Areas"]
["Sr. No.","Name of Equipment","Net Requirement of Equipments for 2017-18","Capex for Year 2017-18\n(Amount in Rs.)","Capex for Year 2018-19\n(Amount in Rs.)","Capex for Year 2019-20\n(Amount in Rs.)"]
[1.1000000000000001,{"$f":"'Input sheet'!B298","v":"Hand Cart with 6 Bins for only D2D collection from Residential and Commercial areas"},{"$f":"'Input sheet'!E298","v":0},{"$f":"IF(C48=0,0,(C48*'Norms and Assumptions'!$M$2))","v":0},0,0]
[1.2,{"$f":"'Input sheet'!B300","v":"Tricycle with bins"},{"$f":"'Input sheet'!E300","v":0},{"$f":"IF(C49=0,0,(C49*'Norms and Assumptions'!M3))","v":0},0,0]
[1.3,{"$f":"'Input sheet'!B301","v":"3-wheeler auto with tipping hopper"},{"$f":"'Input sheet'!E301","v":0},{"$f":"IF(C50=0,0,(C50*'Norms and Assumptions'!M4))","v":0},0,0]
[1.4,{"$f":"'Input sheet'!B302","v":"Mini tipper (4 wheel Mini Truck Container Mounted)"},{"$f":"'Input sheet'!E302","v":0},{"$f":"IF(C51=0,0,(C51*'Norms and Assumptions'!M5))","v":0},0,0]
[1.5,{"$f":"'Input sheet'!B304","v":"Tractor with trolley"},{"$f":"'Input sheet'!E304","v":0},{"$f":"IF(C52=0,0,(C52*'Norms and Assumptions'!M7))","v":0},0,0]
[1.6,"Mini Compactor",{"$f":"'Input sheet'!E307","v":0},{"$f":"IF(C53=0,0,(C53*'Norms and Assumptions'!M10))","v":0},0,0]
["Total",null,{"$f":"SUM(C48:C53)","v":0},{"$f":"SUM(D48:D53)","v":0},{"$f":"SUM(E48:E53)","v":0},0]
["Private Agency Share",null,{"$f":"'Input sheet'!C222","v":0},{"$f":"SUM($D$54:$F$54)*C55","v":0}]
["ULB Share",null,{"$f":"'Input sheet'!C223","v":0},{"$f":"SUM(D54:F54)-D55","v":0}]
[]
[2,"Requirement of vehicles/equipments for secondary waste collection"]
["Sr. No.","Name of Equipment","Net Requirement of Equipment for 2017-18","Capex for Year 2017-18\n(Amount in Rs.)","Capex for Year 2018-19\n(Amount in Rs.)","Capex for Year 2019-20\n(Amount in Rs.)"]
[2.1,{"$f":"'Input sheet'!B299","v":"Hand Cart with 6 Bins for only street sweeping"},{"$f":"'Input sheet'!E299","v":0},{"$f":"IF(C60=0,0,(C60*'Norms and Assumptions'!$M$2))","v":0},0,0]
[2.2000000000000002,{"$f":"'Input sheet'!B309","v":"Single community bin lifter"},{"$f":"'Input sheet'!E309","v":0},{"$f":"IF(C61=0,0,(C61*'Norms and Assumptions'!M14))","v":0},0,0]
[2.2999999999999998,{"$f":"'Input sheet'!B310","v":"Twin community bin lifter"},{"$f":"'Input sheet'!E310","v":0},{"$f":"IF(C62=0,0,(C62*'Norms and Assumptions'!M15))","v":0},0,0]
[2.4,{"$f":"'Input sheet'!B313","v":"Mini Compactor for secondary waste collection"},{"$f":"'Input sheet'!E313","v":0},{"$f":"IF(C63=0,0,(C63*'Norms and Assumptions'!M10))","v":0},0,0]
[2.5,{"$f":"'Input sheet'!B308","v":"Refuse Compactor"},{"$f":"'Input sheet'!E308","v":0},{"$f":"IF(C64=0,0,(C64*'Norms and Assumptions'!M11))","v":0},0,0]
[2.6,{"$f":"'Input sheet'!B312","v":"Front End Loader (JCB)"},{"$f":"'Input sheet'!E312","v":0},{"$f":"IF(C65=0,0,(C65*'Norms and Assumptions'!M13))","v":0},0,0]
[2.7,{"$f":"'Input sheet'!B314","v":"Tractor Mounted Road Sweeper Vacuum Machine"},{"$f":"'Input sheet'!E314","v":0},{"$f":"IF(C66=0,0,(C66*'Norms and Assumptions'!M16))","v":0},0,0]
[2.8,{"$f":"'Input sheet'!B315","v":"Tractor Mounted Road Broomer Machine"},{"$f":"'Input sheet'!E315","v":0},{"$f":"IF(C67=0,0,(C67*'Norms and Assumptions'!M17))","v":0},0,0]
[2.9,{"$f":"'Input sheet'!B319","v":"Community Bins with capacity of 3 cu.mt."},{"$f":"'Input sheet'!E319","v":0},{"$f":"IF(C68=0,0,(C68*'Norms and Assumptions'!M21))","v":0},{"$f":"($C$68+'Input sheet'!$F$113)*'Norms and Assumptions'!$M$21","v":0},{"$f":"($C$68+'Input sheet'!$F$113)*'Norms and Assumptions'!$M$21","v":0}]
[2.1,{"$f":"'Input sheet'!B320","v":"Community Bins with capacity of 4.5 cu.mt."},{"$f":"'Input sheet'!E320","v":0},{"$f":"IF(C69=0,0,(C69*'Norms and Assumptions'!M22))","v":0},{"$f":"($C$69+'Input sheet'!$F$114)*'Norms and Assumptions'!$M$22","v":0},{"$f":"($C$69+'Input sheet'!$F$114)*'Norms and Assumptions'!$M$22","v":0}]
[2.11,{"$f":"'Input sheet'!B321","v":"Galvanized Trolley with capacity of 660 L"},{"$f":"'Input sheet'!E321","v":0},{"$f":"IF(C70=0,0,(C70*'Norms and Assumptions'!M23))","v":0},0,0]
[2.12,{"$f":"'Input sheet'!B322","v":"Galvanized Trolley with capacity of 1100 L"},{"$f":"'Input sheet'!E322","v":0},{"$f":"IF(C71=0,0,(C71*'Norms and Assumptions'!M24))","v":0},0,0]
[2.13,{"$f":"'Input sheet'!B323","v":"Litter bins in the the commercial/market areas (Capacity in litre)"},{"$f":"'Input sheet'!E323","v":0},{"$f":"IF(C72=0,0,(C72*'Norms and Assumptions'!M25))","v":0},{"$f":"($C$72+'Input sheet'!$F$118)*'Norms and Assumptions'!$M$25","v":0},{"$f":"($C$72+'Input sheet'!$F$118)*'Norms and Assumptions'!$M$25","v":0}]
["Total",null,{"$f":"SUM(C60:C72)","v":0},{"$f":"SUM(D60:D72)","v":0},{"$f":"SUM(E60:E72)","v":0},{"$f":"SUM(F60:F72)","v":0}]
["Private Agency Share",null,{"$f":"'Input sheet'!C255","v":0},{"$f":"SUM(D60:D67)*C74","v":0}]
["ULB Share",null,{"$f":"'Input sheet'!C256","v":0},{"$f":"SUM(D73:F73)-D74","v":0}]
[]
[3,"Requirement of vehicles/equipments for waste collection from Bulk Generators"]
["Sr. No.","Name of Equipment","Net Requirement of Equipments","Capex for Year 2017-18\n(Amount in Rs.)","Capex for Year 2018-19\n(Amount in Rs.)","Capex for Year 2019-20\n(Amount in Rs.)"]
[3.1,{"$f":"'Input sheet'!B303","v":"Mini tipper (Closed Body to collect hotel and restaurant kitchen waste)"},{"$f":"'Input sheet'!E303","v":0},{"$f":"IF(C79=0,0,(C79*'Norms and Assumptions'!M6))","v":0},0,0]
[3.2,{"$f":"'Input sheet'!B305","v":"Tempo Truck"},{"$f":"'Input sheet'!E305","v":0},{"$f":"IF(C80=0,0,(C80*'Norms and Assumptions'!M8))","v":0},0,0]
["Total",null,{"$f":"SUM(C79:C80)","v":0},{"$f":"SUM(D79:D80)","v":0},{"$f":"SUM(E79:E80)","v":0},{"$f":"SUM(F79:F80)","v":0}]
["Private Agency Share",null,{"$f":"'Input sheet'!C267","v":0},{"$f":"SUM(D81:F81)*C82","v":0}]
["ULB Share",null,{"$f":"'Input sheet'!C268","v":0},{"$f":"SUM(D81:F81)-D82","v":0}]
[]
[4,"Requirement of vehicles/equipments for C&D waste collection"]
["Sr. No.","Name of Equipment","Net Requirement of Equipments","Capex for Year 2017-18\n(Amount in Rs.)","Capex for Year 2018-19\n(Amount in Rs.)","Capex for Year 2019-20\n(Amount in Rs.)"]
[4.0999999999999996,{"$f":"'Input sheet'!B306","v":"Open Body Truck with crane arm for C&D waste"},{"$f":"'Input sheet'!E306","v":0},{"$f":"IF(C87=0,0,(C87*'Norms and Assumptions'!M9))","v":0},0,0]
["Private Agency Share",null,{"$f":"'Input sheet'!C278","v":0},{"$f":"SUM(D87:F87)*C88","v":0}]
["ULB Share",null,{"$f":"'Input sheet'!C279","v":0},{"$f":"SUM(D87:F87)-D88","v":0}]
[]
[5,"Requirement of vehicles/equipments for Carcass waste collection"]
["Sr. No.","Name of Equipment","Net Requirement of Equipments","Capex for Year 2017-18\n(Amount in Rs.)","Capex for Year 2018-19\n(Amount in Rs.)","Capex for Year 2019-20\n(Amount in Rs.)"]
[5.0999999999999996,{"$f":"'Input sheet'!B311","v":"Automated dead animal lifting vehicle"},{"$f":"'Input sheet'!E311","v":0},{"$f":"IF(C93=0,0,(C93*'Norms and Assumptions'!M12))","v":0},0,0]
["Private Agency Share",null,{"$f":"'Input sheet'!C292","v":0},{"$f":"SUM(D93:F93)*C94","v":0}]
["ULB Share",null,{"$f":"'Input sheet'!C293","v":0},{"$f":"SUM(D93:F93)-D94","v":0}]
[]
[6,"Requirement of other vehicles/equipments"]
["Sr. No.","Name of Equipment","Net Requirement of Equipments","Capex for Year 2017-18\n(Amount in Rs.)","Capex for Year 2018-19\n(Amount in Rs.)","Capex for Year 2019-20\n(Amount in Rs.)"]
[6.1,{"$f":"'Input sheet'!B316","v":"Skid Steer Machine"},{"$f":"'Input sheet'!E316","v":0},{"$f":"IF(C99=0,0,(C99*'Norms and Assumptions'!M18))","v":0},0,0]
[6.2,{"$f":"'Input sheet'!B317","v":"Small Excavator"},{"$f":"'Input sheet'!E317","v":0},{"$f":"IF(C100=0,0,(C100*'Norms and Assumptions'!M19))","v":0},0,0]
[6.3,{"$f":"'Input sheet'!B318","v":"Litter Picker (capacity around 2 Tonne)"},{"$f":"'Input sheet'!E318","v":0},{"$f":"IF(C101=0,0,(C101*'Norms and Assumptions'!M20))","v":0},0,0]
["Total",null,{"$f":"SUM(C99:C101)","v":0},{"$f":"SUM(D99:D101)","v":0},{"$f":"SUM(E99:E101)","v":0},0]
[]
[7,"Equipment for Street Sweeping ","Net Requirement of Equipments","Capex for Year 2017-18\n(Amount in Rs.)","Capex for Year 2018-19\n(Amount in Rs.)","Capex for Year 2019-20\n(Amount in Rs.)"]
[7.1,"Long handle broom",{"$f":"'Input sheet'!F247","v":0},{"$f":"IF(C105=0,0,C105*'Norms and Assumptions'!$M$29)","v":0},{"$f":"IF('Input sheet'!D247=0,0,'Input sheet'!D247*'Norms and Assumptions'!M29)","v":0},{"$f":"IF('Input sheet'!$D$247=0,0,'Input sheet'!$D$247*'Norms and Assumptions'!$M$29)","v":0}]
[7.2,"Metal Tray (Dust Pan)",{"$f":"'Input sheet'!F248","v":0},{"$f":"IF(C106=0,0,C106*'Norms and Assumptions'!$M$30)","v":0},{"$f":"IF('Input sheet'!$D$248=0,0,'Input sheet'!$D$248*'Norms and Assumptions'!$M$30)","v":0},{"$f":"IF('Input sheet'!$D$248=0,0,'Input sheet'!$D$248*'Norms and Assumptions'!$M$30)","v":0}]
[7.3,"Metal Plate",{"$f":"'Input sheet'!F249","v":0},{"$f":"IF(C107=0,0,C107*'Norms and Assumptions'!$M$31)","v":0},{"$f":"IF('Input sheet'!$D$249=0,0,'Input sheet'!$D$249*'Norms and Assumptions'!$M$31)","v":0},{"$f":"IF('Input sheet'!$D$249=0,0,'Input sheet'!$D$249*'Norms and Assumptions'!$M$31)","v":0}]
[7.4,"Ghamela",{"$f":"'Input sheet'!F250","v":0},{"$f":"IF(C108=0,0,C108*'Norms and Assumptions'!$M$32)","v":0},{"$f":"IF('Input sheet'!$D$250=0,0,'Input sheet'!$D$250*'Norms and Assumptions'!$M$32)","v":0},{"$f":"IF('Input sheet'!$D$250=0,0,'Input sheet'!$D$250*'Norms and Assumptions'!$M$32)","v":0}]
[7.5,"Spades",{"$f":"'Input sheet'!F251","v":0},{"$f":"IF(C109=0,0,C109*'Norms and Assumptions'!$M$33)","v":0},{"$f":"IF('Input sheet'!$D$251=0,0,'Input sheet'!$D$251*'Norms and Assumptions'!$M$33)","v":0},{"$f":"IF('Input sheet'!$D$251=0,0,'Input sheet'!$D$251*'Norms and Assumptions'!$M$33)","v":0}]
["Total",null,{"$f":"SUM(C105:C109)","v":0},{"$f":"SUM(D105:D109)","v":0},0,0]
[]
[8,"Health Safety Gears for Sanitation Workers","Net Requirement of Equipments","Capex for Year 2017-18\n(Amount in Rs.)","Capex for Year 2018-19\n(Amount in Rs.)","Capex for Year 2019-20\n(Amount in Rs.)"]
[8.1,"Uniform",{"$f":"'Input sheet'!F326","v":0},{"$f":"IF(C113=0,0,C113*'Norms and Assumptions'!M37)","v":0},{"$f":"IF('Input sheet'!$D$326=0,0,'Input sheet'!$D$326*'Norms and Assumptions'!$M$37)","v":0},{"$f":"IF('Input sheet'!$D$326=0,0,'Input sheet'!$D$326*'Norms and Assumptions'!$M$37)","v":0}]
[8.1999999999999993,"Gloves",{"$f":"'Input sheet'!F327","v":0},{"$f":"IF(C114=0,0,C114*'Norms and Assumptions'!M38)","v":0},{"$f":"IF('Input sheet'!$D$327=0,0,'Input sheet'!$D$327*'Norms and Assumptions'!$M$38)","v":0},{"$f":"IF('Input sheet'!$D$327=0,0,'Input sheet'!$D$327*'Norms and Assumptions'!$M$38)","v":0}]
[8.3000000000000007,"Gum Boots",{"$f":"'Input sheet'!F328","v":0},{"$f":"IF(C115=0,0,C115*'Norms and Assumptions'!M39)","v":0},{"$f":"IF('Input sheet'!$D$328=0,0,'Input sheet'!$D$328*'Norms and Assumptions'!$M$39)","v":0},{"$f":"IF('Input sheet'!$D$328=0,0,'Input sheet'!$D$328*'Norms and Assumptions'!$M$39)","v":0}]
[8.4,"Safety Mask",{"$f":"'Input sheet'!F329","v":0},{"$f":"IF(C116=0,0,C116*'Norms and Assumptions'!M40)","v":0},{"$f":"IF('Input sheet'!$D$329=0,0,'Input sheet'!$D$329*'Norms and Assumptions'!$M$40)","v":0},{"$f":"IF('Input sheet'!$D$329=0,0,'Input sheet'!$D$329*'Norms and Assumptions'!$M$40)","v":0}]
[8.5,"Safety Jacket",{"$f":"'Input sheet'!F330","v":0},{"$f":"IF(C117=0,0,C117*'Norms and Assumptions'!M41)","v":0},{"$f":"IF('Input sheet'!$D$330=0,0,'Input sheet'!$D$330*'Norms and Assumptions'!$M$41)","v":0},{"$f":"IF('Input sheet'!$D$330=0,0,'Input sheet'!$D$330*'Norms and Assumptions'!$M$41)","v":0}]
[8.6,"Rain Coat",{"$f":"'Input sheet'!F331","v":0},{"$f":"IF(C118=0,0,C118*'Norms and Assumptions'!M42)","v":0},{"$f":"IF('Input sheet'!$D$331=0,0,'Input sheet'!$D$331*'Norms and Assumptions'!$M$42)","v":0},{"$f":"IF('Input sheet'!$D$331=0,0,'Input sheet'!$D$331*'Norms and Assumptions'!$M$42)","v":0}]
["Total",null,{"$f":"SUM(C113:C118)","v":0},{"$f":"SUM(D113:D118)","v":0},0,0]
[]
[9,"Requirement of Household Bins for Source Segregation","No. of Bins Required","Total Cost\n(Amount in Rs.)"]
[9.1,"Total number of household bins required for segregation at source",{"$f":"'Input sheet'!C181","v":0},{"$f":"IFERROR(C122*'Norms and Assumptions'!M44,0)","v":0}]
[]
["Total capex for year 2017-20",null,{"$f":"SUM(C41:D41)","v":0}]
[]
[]
["Details of Operation and Maintenance (O&M) Cost for Equipments and Vehicles"]
["Operation cost (Salary of driver and helper + Fuel cost)"]
[1,"Name of Equipment","Opex for Year 2017-18\n(Amount in Rs.)","Opex for Year 2018-19\n(Amount in Rs.)","Opex for Year 2019-20\n(Amount in Rs.)"]
[1.1000000000000001,"Hand Cart with 6 Bins",{"$f":"('Input sheet'!G106+'Input sheet'!G115)*'Norms and Assumptions'!O2*'Norms and Assumptions'!$B$99","v":0},{"$f":"('Input sheet'!$G$106+'Input sheet'!$G$115+$C$48+$C$60)*'Norms and Assumptions'!$O$2*'Norms and Assumptions'!$B$99","v":0},{"$f":"D130","v":0}]
[1.2,{"$f":"B49","v":"Tricycle with bins"},{"$f":"('Input sheet'!G107*'Norms and Assumptions'!O3)*'Norms and Assumptions'!$B$99","v":0},{"$f":"('Input sheet'!$G$107+$C$49)*'Norms and Assumptions'!$O$3*'Norms and Assumptions'!$B$99","v":0},{"$f":"D131","v":0}]
[1.3,{"$f":"B50","v":"3-wheeler auto with tipping hopper"},{"$f":"('Input sheet'!$G$108*'Norms and Assumptions'!$O$4*'Norms and Assumptions'!$B$99)+('Input sheet'!$G$108*'Norms and Assumptions'!$P$4*'Norms and Assumptions'!$B$100)+('Input sheet'!$G$108*'Norms and Assumptions'!$B$104)","v":0},{"$f":"(('Input sheet'!$G$108+$C$50)*'Norms and Assumptions'!$O$4*'Norms and Assumptions'!$B$99)+(('Input sheet'!$G$108+$C$50)*'Norms and Assumptions'!$P$4*'Norms and Assumptions'!$B$100)+(('Input sheet'!$G$108+$C$50)*'Norms and Assumptions'!$B$104)","v":0},0]
[1.4,{"$f":"B51","v":"Mini tipper (4 wheel Mini Truck Container Mounted)"},{"$f":"('Input sheet'!G109*'Norms and Assumptions'!O5*'Norms and Assumptions'!$B$99)+('Input sheet'!G109*'Norms and Assumptions'!P5*'Norms and Assumptions'!$B$100)+('Input sheet'!G109*'Norms and Assumptions'!$B$104)","v":0},{"$f":"(('Input sheet'!G109+C51)*'Norms and Assumptions'!O5*'Norms and Assumptions'!$B$99)+(('Input sheet'!G109+C51)*'Norms and Assumptions'!P5*'Norms and Assumptions'!$B$100)+(('Input sheet'!G109+C51)*'Norms and Assumptions'!$B$104)","v":0},0]
[1.5,{"$f":"B79","v":"Mini tipper (Closed Body to collect hotel and restaurant kitchen waste)"},{"$f":"('Input sheet'!G110*'Norms and Assumptions'!O6*'Norms and Assumptions'!$B$99)+('Input sheet'!G110*'Norms and Assumptions'!P6*'Norms and Assumptions'!$B$100)+('Input sheet'!G110*'Norms and Assumptions'!$B$104)","v":0},{"$f":"(('Input sheet'!G110+C79)*'Norms and Assumptions'!O6*'Norms and Assumptions'!$B$99)+(('Input sheet'!G110+C79)*'Norms and Assumptions'!P6*'Norms and Assumptions'!$B$100)+(('Input sheet'!G110+C79)*'Norms and Assumptions'!$B$104)","v":0},0]
[1.6,{"$f":"B52","v":"Tractor with trolley"},{"$f":"('Input sheet'!G111*'Norms and Assumptions'!O7*'Norms and Assumptions'!$B$99)+('Input sheet'!G111*'Norms and Assumptions'!P7*'Norms and Assumptions'!$B$100)+('Input sheet'!G111*'Norms and Assumptions'!$B$104)","v":0},{"$f":"(('Input sheet'!G111+C52)*'Norms and Assumptions'!O7*'Norms and Assumptions'!$B$99)+(('Input sheet'!G111+C52)*'Norms and Assumptions'!P7*'Norms and Assumptions'!$B$100)+(('Input sheet'!G111+C52)*'Norms and Assumptions'!$B$104)","v":0},0]
[1.7,{"$f":"B80","v":"Tempo Truck"},{"$f":"('Input sheet'!G126*'Norms and Assumptions'!O8*'Norms and Assumptions'!$B$99)+('Input sheet'!G126*'Norms and Assumptions'!P8*'Norms and Assumptions'!$B$100)+('Input sheet'!G126*'Norms and Assumptions'!$B$104)","v":0},{"$f":"(('Input sheet'!G126+C80)*'Norms and Assumptions'!O8*'Norms and Assumptions'!$B$99)+(('Input sheet'!G126+C80)*'Norms and Assumptions'!P8*'Norms and Assumptions'!$B$100)+(('Input sheet'!G126+C80)*'Norms and Assumptions'!$B$104)","v":0},{"$f":"D136","v":0}]
[1.8,{"$f":"B87","v":"Open Body Truck with crane arm for C&D waste"},{"$f":"('Input sheet'!G120*'Norms and Assumptions'!O9*'Norms and Assumptions'!$B$99)+('Input sheet'!G120*'Norms and Assumptions'!P9*'Norms and Assumptions'!$B$100)+('Input sheet'!G120*'Norms and Assumptions'!$B$104)","v":0},{"$f":"(('Input sheet'!G120+C87)*'Norms and Assumptions'!O9*'Norms and Assumptions'!$B$99)+(('Input sheet'!G120+C87)*'Norms and Assumptions'!P9*'Norms and Assumptions'!$B$100)+(('Input sheet'!G120+C87)*'Norms and Assumptions'!$B$104)","v":0},0]
[1.9,{"$f":"B63","v":"Mini Compactor for secondary waste collection"},{"$f":"('Input sheet'!G127*'Norms and Assumptions'!O10*'Norms and Assumptions'!$B$99)+('Input sheet'!G127*'Norms and Assumptions'!P10*'Norms and Assumptions'!$B$100)+('Input sheet'!G127*'Norms and Assumptions'!$B$104)","v":0},{"$f":"(('Input sheet'!G127+C63)*'Norms and Assumptions'!O10*'Norms and Assumptions'!$B$99)+(('Input sheet'!G127+C63)*'Norms and Assumptions'!P10*'Norms and Assumptions'!$B$100)+(('Input sheet'!G127+C63)*'Norms and Assumptions'!$B$104)","v":0},0]
[1.1000000000000001,{"$f":"B64","v":"Refuse Compactor"},{"$f":"('Input sheet'!G122*'Norms and Assumptions'!O11*'Norms and Assumptions'!$B$99)+('Input sheet'!G122*'Norms and Assumptions'!P11*'Norms and Assumptions'!$B$100)+('Input sheet'!G122*'Norms and Assumptions'!$B$104)","v":0},{"$f":"(('Input sheet'!G122+C64)*'Norms and Assumptions'!O11*'Norms and Assumptions'!$B$99)+(('Input sheet'!G122+C64)*'Norms and Assumptions'!P11*'Norms and Assumptions'!$B$100)+(('Input sheet'!G122+C64)*'Norms and Assumptions'!$B$104)","v":0},0]
[1.1100000000000001,{"$f":"B93","v":"Automated dead animal lifting vehicle"},{"$f":"('Input sheet'!G121*'Norms and Assumptions'!O12*'Norms and Assumptions'!$B$99)+('Input sheet'!G121*'Norms and Assumptions'!P12*'Norms and Assumptions'!$B$100)+('Input sheet'!G121*'Norms and Assumptions'!$B$104)","v":0},{"$f":"(('Input sheet'!G121+C93)*'Norms and Assumptions'!O12*'Norms and Assumptions'!$B$99)+(('Input sheet'!G121+C93)*'Norms and Assumptions'!P12*'Norms and Assumptions'!$B$100)+(('Input sheet'!G121+C93)*'Norms and Assumptions'!$B$104)","v":0},0]
[1.1200000000000001,{"$f":"B65","v":"Front End Loader (JCB)"},{"$f":"('Input sheet'!G123*'Norms and Assumptions'!O13*'Norms and Assumptions'!$B$99)+('Input sheet'!G123*'Norms and Assumptions'!P13*'Norms and Assumptions'!$B$100)+('Input sheet'!G123*'Norms and Assumptions'!$B$104)","v":0},{"$f":"(('Input sheet'!G123+C65)*'Norms and Assumptions'!O13*'Norms and Assumptions'!$B$99)+(('Input sheet'!G123+C65)*'Norms and Assumptions'!P13*'Norms and Assumptions'!$B$100)+(('Input sheet'!G123+C65)*'Norms and Assumptions'!$B$104)","v":0},0]
[1.1299999999999999,{"$f":"B61","v":"Single community bin lifter"},{"$f":"('Input sheet'!G124*'Norms and Assumptions'!O14*'Norms and Assumptions'!$B$99)+('Input sheet'!G124*'Norms and Assumptions'!P14*'Norms and Assumptions'!$B$100)+('Input sheet'!G124*'Norms and Assumptions'!$B$104)","v":0},{"$f":"(('Input sheet'!G124+C61)*'Norms and Assumptions'!O14*'Norms and Assumptions'!$B$99)+(('Input sheet'!G124+C61)*'Norms and Assumptions'!P14*'Norms and Assumptions'!$B$100)+(('Input sheet'!G124+C61)*'Norms and Assumptions'!$B$104)","v":0},0]
[1.1399999999999999,{"$f":"B62","v":"Twin community bin lifter"},{"$f":"('Input sheet'!G125*'Norms and Assumptions'!O15*'Norms and Assumptions'!$B$99)+('Input sheet'!G125*'Norms and Assumptions'!P15*'Norms and Assumptions'!$B$100)+('Input sheet'!G125*'Norms and Assumptions'!$B$104)","v":0},{"$f":"(('Input sheet'!G125+C62)*'Norms and Assumptions'!O15*'Norms and Assumptions'!$B$99)+(('Input sheet'!G125+C62)*'Norms and Assumptions'!P15*'Norms and Assumptions'!$B$100)+(('Input sheet'!G125+C62)*'Norms and Assumptions'!$B$104)","v":0},0]
[1.1499999999999999,{"$f":"B66","v":"Tractor Mounted Road Sweeper Vacuum Machine"},{"$f":"('Input sheet'!D142*'Norms and Assumptions'!O16*'Norms and Assumptions'!$B$99)+('Input sheet'!D142*'Norms and Assumptions'!P16*'Norms and Assumptions'!$B$100)+('Input sheet'!D142*'Norms and Assumptions'!$B$104)","v":0},{"$f":"(('Input sheet'!D142+C66)*'Norms and Assumptions'!O16*'Norms and Assumptions'!$B$99)+(('Input sheet'!D142+C66)*'Norms and Assumptions'!P16*'Norms and Assumptions'!$B$100)+(('Input sheet'!D142+C66)*'Norms and Assumptions'!$B$104)","v":0},0]
[1.1599999999999999,{"$f":"B67","v":"Tractor Mounted Road Broomer Machine"},{"$f":"('Input sheet'!D143*'Norms and Assumptions'!O17*'Norms and Assumptions'!$B$99)+('Input sheet'!D143*'Norms and Assumptions'!P17*'Norms and Assumptions'!$B$100)+('Input sheet'!D143*'Norms and Assumptions'!$B$104)","v":0},{"$f":"(('Input sheet'!D143+C67)*'Norms and Assumptions'!O17*'Norms and Assumptions'!$B$99)+(('Input sheet'!D143+C67)*'Norms and Assumptions'!P17*'Norms and Assumptions'!$B$100)+(('Input sheet'!D143+C67)*'Norms and Assumptions'!$B$104)","v":0},0]
[1.17,{"$f":"B99","v":"Skid Steer Machine"},{"$f":"('Input sheet'!G131*'Norms and Assumptions'!O18*'Norms and Assumptions'!$B$99)+('Input sheet'!G131*'Norms and Assumptions'!P18*'Norms and Assumptions'!$B$100)+('Input sheet'!G131*'Norms and Assumptions'!$B$104)","v":0},{"$f":"(('Input sheet'!G131+C99)*'Norms and Assumptions'!O18*'Norms and Assumptions'!$B$99)+(('Input sheet'!G131+C99)*'Norms and Assumptions'!P18*'Norms and Assumptions'!$B$100)+(('Input sheet'!G131+C99)*'Norms and Assumptions'!$B$104)","v":0},0]
[1.18,{"$f":"B100","v":"Small Excavator"},{"$f":"('Input sheet'!G132*'Norms and Assumptions'!O19*'Norms and Assumptions'!$B$99)+('Input sheet'!G132*'Norms and Assumptions'!P19*'Norms and Assumptions'!$B$100)+('Input sheet'!G132*'Norms and Assumptions'!$B$104)","v":0},{"$f":"(('Input sheet'!G132+C100)*'Norms and Assumptions'!O19*'Norms and Assumptions'!$B$99)+(('Input sheet'!G132+C100)*'Norms and Assumptions'!P19*'Norms and Assumptions'!$B$100)+(('Input sheet'!G132+C100)*'Norms and Assumptions'!$B$104)","v":0},0]
[1.19,{"$f":"B101","v":"Litter Picker (capacity around 2 Tonne)"},{"$f":"('Input sheet'!G133*'Norms and Assumptions'!O20*'Norms and Assumptions'!$B$99)+('Input sheet'!G133*'Norms and Assumptions'!P20*'Norms and Assumptions'!$B$100)","v":0},{"$f":"(('Input sheet'!G133+C101)*'Norms and Assumptions'!O20*'Norms and Assumptions'!$B$99)+(('Input sheet'!G133+C101)*'Norms and Assumptions'!P20*'Norms and Assumptions'!$B$100)","v":0},0]
["Total operation cost",null,{"$f":"SUM(C130:C148)","v":0},{"$f":"SUM(D130:D148)","v":0},{"$f":"SUM(E130:E148)","v":0}]
[]
["Total operation cost for year 2017-20",null,{"$f":"C149+D149+E149","v":0}]
[]
["Maintenance cost"]
[1,"Name of Equipment","Opex for Year 2017-18\n(Amount in Rs.)","Opex for Year 2018-19\n(Amount in Rs.)","Opex for Year 2019-20\n(Amount in Rs.)"]
[{"$f":"A130","v":1.1000000000000001},{"$f":"B130","v":"Hand Cart with 6 Bins"},{"$f":"'Input sheet'!G106*'Norms and Assumptions'!M2*'Norms and Assumptions'!N2","v":0},{"$f":"('Input sheet'!G106+C48)*'Norms and Assumptions'!M2*'Norms and Assumptions'!N2","v":0},{"$f":"('Input sheet'!G106+C48)*'Norms and Assumptions'!M2*'Norms and Assumptions'!N2","v":0}]
[{"$f":"A131","v":1.2},{"$f":"B49","v":"Tricycle with bins"},{"$f":"'Input sheet'!G107*'Norms and Assumptions'!M3*'Norms and Assumptions'!N3","v":0},{"$f":"('Input sheet'!G107+C49)*'Norms and Assumptions'!M3*'Norms and Assumptions'!N3","v":0},{"$f":"('Input sheet'!G107+C49)*'Norms and Assumptions'!M3*'Norms and Assumptions'!N3","v":0}]
[1.3,{"$f":"B50","v":"3-wheeler auto with tipping hopper"},{"$f":"'Input sheet'!G108*'Norms and Assumptions'!M4*'Norms and Assumptions'!N4","v":0},{"$f":"('Input sheet'!G108+C50)*'Norms and Assumptions'!M4*'Norms and Assumptions'!N4","v":0},{"$f":"('Input sheet'!G108+C50)*'Norms and Assumptions'!M4*'Norms and Assumptions'!N4","v":0}]
[1.4,{"$f":"B51","v":"Mini tipper (4 wheel Mini Truck Container Mounted)"},{"$f":"'Input sheet'!G109*'Norms and Assumptions'!M5*'Norms and Assumptions'!N5","v":0},{"$f":"('Input sheet'!G109+C51)*'Norms and Assumptions'!M5*'Norms and Assumptions'!N5","v":0},{"$f":"('Input sheet'!G109+C51)*'Norms and Assumptions'!M5*'Norms and Assumptions'!N5","v":0}]
[1.5,{"$f":"B79","v":"Mini tipper (Closed Body to collect hotel and restaurant kitchen waste)"},{"$f":"'Input sheet'!G110*'Norms and Assumptions'!M6*'Norms and Assumptions'!N6","v":0},{"$f":"('Input sheet'!G110+C79)*'Norms and Assumptions'!M6*'Norms and Assumptions'!N6","v":0},{"$f":"('Input sheet'!G110+C79)*'Norms and Assumptions'!M6*'Norms and Assumptions'!N6","v":0}]
[1.6,{"$f":"B52","v":"Tractor with trolley"},{"$f":"'Input sheet'!G111*'Norms and Assumptions'!M7*'Norms and Assumptions'!N7","v":0},{"$f":"('Input sheet'!G111+C52)*'Norms and Assumptions'!M7*'Norms and Assumptions'!N7","v":0},{"$f":"('Input sheet'!G111+C52)*'Norms and Assumptions'!M7*'Norms and Assumptions'!N7","v":0}]
[1.7,{"$f":"B80","v":"Tempo Truck"},{"$f":"'Input sheet'!G126*'Norms and Assumptions'!M8*'Norms and Assumptions'!N8","v":0},{"$f":"('Input sheet'!G126+C80)*'Norms and Assumptions'!M8*'Norms and Assumptions'!N8","v":0},{"$f":"('Input sheet'!G126+C80)*'Norms and Assumptions'!M8*'Norms and Assumptions'!N8","v":0}]
[1.8,{"$f":"B87","v":"Open Body Truck with crane arm for C&D waste"},{"$f":"'Input sheet'!G120*'Norms and Assumptions'!M9*'Norms and Assumptions'!N9","v":0},{"$f":"('Input sheet'!G120+C87)*'Norms and Assumptions'!M9*'Norms and Assumptions'!N9","v":0},{"$f":"('Input sheet'!G120+C87)*'Norms and Assumptions'!M9*'Norms and Assumptions'!N9","v":0}]
[1.9,{"$f":"B63","v":"Mini Compactor for secondary waste collection"},{"$f":"'Input sheet'!G127*'Norms and Assumptions'!M10*'Norms and Assumptions'!N10","v":0},{"$f":"('Input sheet'!G127+C63)*'Norms and Assumptions'!M10*'Norms and Assumptions'!N10","v":0},{"$f":"('Input sheet'!G127+C63)*'Norms and Assumptions'!M10*'Norms and Assumptions'!N10","v":0}]
[1.1000000000000001,{"$f":"B64","v":"Refuse Compactor"},{"$f":"'Input sheet'!G122*'Norms and Assumptions'!M11*'Norms and Assumptions'!N11","v":0},{"$f":"('Input sheet'!G122+C64)*'Norms and Assumptions'!M11*'Norms and Assumptions'!N11","v":0},{"$f":"('Input sheet'!G122+C64)*'Norms and Assumptions'!M11*'Norms and Assumptions'!N11","v":0}]
[1.1100000000000001,{"$f":"B93","v":"Automated dead animal lifting vehicle"},{"$f":"'Input sheet'!G121*'Norms and Assumptions'!M12*'Norms and Assumptions'!N12","v":0},{"$f":"('Input sheet'!G121+C93)*'Norms and Assumptions'!M12*'Norms and Assumptions'!N12","v":0},{"$f":"('Input sheet'!G121+C93)*'Norms and Assumptions'!M12*'Norms and Assumptions'!N12","v":0}]
[1.1200000000000001,{"$f":"B65","v":"Front End Loader (JCB)"},{"$f":"'Input sheet'!G123*'Norms and Assumptions'!M13*'Norms and Assumptions'!N13","v":0},{"$f":"('Input sheet'!G123+C65)*'Norms and Assumptions'!M13*'Norms and Assumptions'!N13","v":0},{"$f":"('Input sheet'!G123+C65)*'Norms and Assumptions'!M13*'Norms and Assumptions'!N13","v":0}]
[1.1299999999999999,{"$f":"B61","v":"Single community bin lifter"},{"$f":"'Input sheet'!G124*'Norms and Assumptions'!M14*'Norms and Assumptions'!N14","v":0},{"$f":"('Input sheet'!G124+C61)*'Norms and Assumptions'!M14*'Norms and Assumptions'!N14","v":0},{"$f":"('Input sheet'!G124+C61)*'Norms and Assumptions'!M14*'Norms and Assumptions'!N14","v":0}]
[1.1399999999999999,{"$f":"B62","v":"Twin community bin lifter"},{"$f":"'Input sheet'!G125*'Norms and Assumptions'!M15*'Norms and Assumptions'!N15","v":0},{"$f":"('Input sheet'!G125+C62)*'Norms and Assumptions'!M15*'Norms and Assumptions'!N15","v":0},{"$f":"('Input sheet'!G125+C62)*'Norms and Assumptions'!M15*'Norms and Assumptions'!N15","v":0}]
[1.1499999999999999,{"$f":"B66","v":"Tractor Mounted Road Sweeper Vacuum Machine"},{"$f":"'Input sheet'!D142*'Norms and Assumptions'!M16*'Norms and Assumptions'!N16","v":0},{"$f":"('Input sheet'!D142+C66)*'Norms and Assumptions'!M16*'Norms and Assumptions'!N16","v":0},{"$f":"('Input sheet'!D142+C66)*'Norms and Assumptions'!M16*'Norms and Assumptions'!N16","v":0}]
[1.1599999999999999,{"$f":"B67","v":"Tractor Mounted Road Broomer Machine"},{"$f":"'Input sheet'!D143*'Norms and Assumptions'!M17*'Norms and Assumptions'!N17","v":0},{"$f":"('Input sheet'!D143+C67)*'Norms and Assumptions'!M17*'Norms and Assumptions'!N17","v":0},{"$f":"('Input sheet'!D143+C67)*'Norms and Assumptions'!M17*'Norms and Assumptions'!N17","v":0}]
[1.17,{"$f":"B99","v":"Skid Steer Machine"},{"$f":"'Input sheet'!G131*'Norms and Assumptions'!M18*'Norms and Assumptions'!N18","v":0},{"$f":"('Input sheet'!G131+C99)*'Norms and Assumptions'!M18*'Norms and Assumptions'!N18","v":0},{"$f":"('Input sheet'!G131+C99)*'Norms and Assumptions'!M18*'Norms and Assumptions'!N18","v":0}]
[1.18,{"$f":"B100","v":"Small Excavator"},{"$f":"'Input sheet'!G132*'Norms and Assumptions'!M19*'Norms and Assumptions'!N19","v":0},{"$f":"('Input sheet'!G132+C100)*'Norms and Assumptions'!M19*'Norms and Assumptions'!N19","v":0},{"$f":"('Input sheet'!G132+C100)*'Norms and Assumptions'!M19*'Norms and Assumptions'!N19","v":0}]
[1.19,{"$f":"B101","v":"Litter Picker (capacity around 2 Tonne)"},{"$f":"'Input sheet'!G133*'Norms and Assumptions'!M20*'Norms and Assumptions'!N20","v":0},{"$f":"('Input sheet'!G133+C101)*'Norms and Assumptions'!M20*'Norms and Assumptions'!N20","v":0},{"$f":"('Input sheet'!G133+C101)*'Norms and Assumptions'!M20*'Norms and Assumptions'!N20","v":0}]
[1.2,{"$f":"B70","v":"Galvanized Trolley with capacity of 660 L"},{"$f":"'Input sheet'!G116*'Norms and Assumptions'!M23*'Norms and Assumptions'!N23","v":0},{"$f":"('Input sheet'!G116+C68)*'Norms and Assumptions'!M23*'Norms and Assumptions'!N23","v":0},{"$f":"('Input sheet'!G116+C68)*'Norms and Assumptions'!M23*'Norms and Assumptions'!N23","v":0}]
[1.21,{"$f":"B71","v":"Galvanized Trolley with capacity of 1100 L"},{"$f":"'Input sheet'!G117*'Norms and Assumptions'!M24*'Norms and Assumptions'!N24","v":0},{"$f":"('Input sheet'!G117+C69)*'Norms and Assumptions'!M24*'Norms and Assumptions'!N24","v":0},{"$f":"('Input sheet'!G117+C69)*'Norms and Assumptions'!M24*'Norms and Assumptions'!N24","v":0}]
["Total maintenance cost",null,{"$f":"SUM(C155:C175)","v":0},{"$f":"SUM(D155:D175)","v":0},{"$f":"SUM(E155:E175)","v":0}]
[]
["Total maintenance cost for year 2017-20",null,{"$f":"C176+D176+E176","v":0}]

{"sheet":"Norms and Assumptions","index":4,"n_rows":104,"n_cols":16,"rows_kept":104,"cut":false,"hidden":true,"merged":[[97,0,97,1],[94,0,94,1],[90,0,90,1],[0,1,0,2],[19,0,19,1],[82,0,82,1],[89,0,89,1]]}
["Type of equipments/vehicles","Norms",null,"Capacity in KG","Capacity in MT","Source","Average life of equipment in years",null,null,null,null,"Name of Equipment","Unit Rate\n(Amount in Rs.)","Maintenance","Driver","Helper"]
["Hand Cart with 6 Bins",{"$f":"ROUNDUP(D2/$B$18,-1)","v":30},"HHs",60,{"$f":"D2/1000","v":0.06},"Table 2.3, SBM MSWM maual part 2",3,null,{"$f":"D2/B18","v":26.666666666666668},null,null,{"$f":"'Budget Summary'!B130","v":"Hand Cart with 6 Bins"},6800,0.1,1,0]
["Tricycle with bins",{"$f":"ROUNDUP(D3/$B$18,-1)","v":40},"HHs",80,{"$f":"D3/1000","v":0.08},"Table 2.3, SBM MSWM maual part 2",3,null,{"$f":"D3/B18","v":35.555555555555557},null,null,{"$f":"'Budget Summary'!B49","v":"Tricycle with bins"},25000,0.1,1,0]
["3-wheeler auto with tipping hopper",160,"HHs",350,0.35,"KUIDFC",5,null,{"$f":"D4/$B$18","v":155.55555555555554},null,null,{"$f":"'Budget Summary'!B50","v":"3-wheeler auto with tipping hopper"},325000,0.15,1,1]
["Mini Tipper (4 wheel Mini Truck Container Mounted)",450,"HHs",1000,1,"As per ULBs of Gujarat",5,null,{"$f":"D5/$B$18","v":444.44444444444446},null,null,{"$f":"'Budget Summary'!B51","v":"Mini tipper (4 wheel Mini Truck Container Mounted)"},800000,0.2,1,1]
["Mini Tipper (Closed Body to collect hotel and restaurant kitchen waste)",null,null,1500,1.5,null,5,null,null,null,null,{"$f":"'Budget Summary'!B79","v":"Mini tipper (Closed Body to collect hotel and restaurant kitchen waste)"},1400000,0.2,1,1]
["Tempo Truck",null,null,4000,4,null,null,null,null,null,null,{"$f":"'Budget Summary'!B52","v":"Tractor with trolley"},{"$f":"450000+165000","v":615000},0.1,1,2]
["Trolley (Trailor)",450,"HHs",1000,1,"As per ULBs of Gujarat","3-5",null,{"$f":"D8/$B$18","v":444.44444444444446},null,null,{"$f":"'Budget Summary'!B80","v":"Tempo Truck"},1200000,0.2,1,2]
["Galvanized Trolley 660 L",null,null,300,0.3,null,null,null,null,null,null,{"$f":"'Budget Summary'!B87","v":"Open Body Truck with crane arm for C&D waste"},3400000,0.2,1,1]
["Galvanized Trolley 1100 L",null,null,500,0.5,null,null,null,null,null,null,{"$f":"'Budget Summary'!B63","v":"Mini Compactor for secondary waste collection"},1650000,0.2,1,2]
["Community Bins (Containers - Green and Black)",null,null,null,0,null,null,null,null,null,null,{"$f":"'Budget Summary'!B64","v":"Refuse Compactor"},2800000,0.2,1,2]
["Open Body Truck with Crane Arm",null,null,5000,5,null,null,null,null,null,null,{"$f":"'Budget Summary'!B93","v":"Automated dead animal lifting vehicle"},3000000,0.2,1,2]
["Mini Compactors",null,null,5000,5,null,null,null,null,null,null,{"$f":"'Budget Summary'!B65","v":"Front End Loader (JCB)"},2400000,0.2,1,1]
["Refuse Compactors",null,null,10000,10,null,null,null,null,null,null,{"$f":"'Budget Summary'!B61","v":"Single community bin lifter"},400000,0.2,1,1]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget Summary'!B62","v":"Twin community bin lifter"},700000,0.2,1,1]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget Summary'!B66","v":"Tractor Mounted Road Sweeper Vacuum Machine"},3100000,0.2,1,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget Summary'!B67","v":"Tractor Mounted Road Broomer Machine"},600000,0.2,1,0]
["Total Waste Generation from 1 HH having 5 members (Kgs)",{"$f":"0.45*5","v":2.25},"It is assumed that per capita waste is 450 grams",null,null,null,null,null,null,null,null,{"$f":"'Budget Summary'!B99","v":"Skid Steer Machine"},2200000,0.2,1,1]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget Summary'!B100","v":"Small Excavator"},2000000,0.2,1,0]
["Norms for waste generation (as per CPHEEO manual)",null,null,null,null,null,null,null,null,null,null,{"$f":"'Budget Summary'!B101","v":"Litter Picker (capacity around 2 Tonne)"},1000000,0.2,1,0]
["Population Range of ULB","Average Waste (grams/capita/day)",null,null,null,null,null,null,null,null,null,{"$f":"'Budget Summary'!B68","v":"Community Bins with capacity of 3 cu.mt."},40000,"-",0,0]
["Population range upto 1 lakh",210,null,null,null,null,null,null,null,null,null,{"$f":"'Budget Summary'!B69","v":"Community Bins with capacity of 4.5 cu.mt."},50000,"-",0,0]
["Population range 1 to 5 lakh",210,null,null,null,null,null,null,null,null,null,{"$f":"'Budget Summary'!B70","v":"Galvanized Trolley with capacity of 660 L"},27000,0.1,0,0]
["Population range 5 to 10 lakh",250,null,null,null,null,null,null,null,null,null,{"$f":"'Budget Summary'!B71","v":"Galvanized Trolley with capacity of 1100 L"},40000,0.1,0,0]
["Population range 10 to 20 lakh",270,null,null,null,null,null,null,null,null,null,"Litter bins in the commercial/market areas (Capacity in litre)",1200,"-",0,0]
[null,null,null,null,null,null,null,null,null,null,null,"Animal incinerator",3000000]
["Assumptions"]
["It is assumed that all equipments, vehicles and rolling stocks are procured by the ULB",null,null,null,null,null,null,null,null,null,null,"Equipment for street sweepers","Unit Rate\n(Amount in Rs.)"]
["Particulars","Requirement per year","Frequency per year",null,null,null,null,null,null,null,null,"Long handle broom",80]
["Long handle broom",4,"once in 3 months",null,null,null,null,null,null,null,null,"Metal Tray (Dust Pan)",50]
["Metal Tray (Dust Pan)",2,"once in 6 months",null,null,null,null,null,null,null,null,"Metal Plate",50]
["Metal Plate",2,"once in 6 months",null,null,null,null,null,null,null,null,"Ghamela (Tagaru)",100]
["Ghamela (Tagaru)",1,"once in a year",null,null,null,null,null,null,null,null,"Spades (Paavdo)",130]
["Spades (Paavdo)",1,"once in a year"]
["Uniform (Pair)",2,"once in 6 months",{"$f":"B35*M37","v":2000}]
["Gloves",4,"once in 3 months",200,null,null,null,null,null,null,null,"Health Safety Gears for Sanitation Workers","Unit Rate\n(Amount in Rs.)"]
["Gum Boots",1,"once in a year",230,null,null,null,null,null,null,null,"Uniform",1000]
["Safety Mask",4,"once in 3 months",80,null,null,null,null,null,null,null,"Gloves",50]
["Safety Jacket",1,"once in a year",100,null,null,null,null,null,null,null,"Gum Boots",230]
["Rain Coat",1,"once in a year",500,null,null,null,null,null,null,null,"Safety Mask",20]
[null,null,null,{"$f":"SUM(D35:D40)","v":3110},"Total cost of kit per person per year",null,null,null,null,null,null,"Safety Jacket",100]
[null,null,null,null,null,null,null,null,null,null,null,"Rain Coat",500]
["Year","Per capita waste generation"]
[1996,0.21,null,null,null,null,null,null,null,null,null,"Unit rate of Household Bins (10 ltr)",125]
[1997,{"$f":"B44+(B44*1.33%)","v":0.21279299999999998}]
[1998,{"$f":"B45+(B45*1.33%)","v":0.21562314689999998}]
[1999,0.21849093475376999]
[2000,0.22139686418599513]
[2001,0.22434144247966886]
[2002,0.22732518366464846]
[2003,0.23034860860738829]
[2004,0.23341224510186656]
[2005,0.23651662796172138]
[2006,0.23966229911361228]
[2007,0.24284980769182332]
[2008,0.24607971013412458]
[2009,0.24935257027890845]
[2010,0.25266895946361795]
[2011,0.25602945662448406]
[2012,0.25943464839758973]
[2013,0.26288512922127766]
[2014,0.26638150143992068]
[2015,0.2699243754090716]
[2016,0.27351436960201225]
[2017,0.277152110717719]
[2018,0.28083823379026468]
[2019,0.28457338229967521]
[2020,0.2883582082842609]
[2021,0.29219337245444155]
["Source: SWM Master Plan, P-44"]
[]
[]
["Waste generated at source","Assumed percentage"]
["Residential",0.4]
["Commercial and  Institutional Establishments",0.2]
["Hotel and Restaurants Kitchen waste",2.5000000000000001E-2]
["Special Markets like Vegetable, Flower etc.",2.5000000000000001E-2]
["C&D Waste",0.1]
["Street Sweeping",0.25]
["Source: AMC SWM Master plan 2031"]
[]
[]
["Automated dead animal lifting vehicle"]
["Area","No. of vehicles"]
["City area less than 50 sq.km.",1]
["City area in between 51 to 100 sq.km.",2]
["City area in between 101 to 300 sq.km.",3]
["City area above 300 sq.km.",4]
[]
["Community bin lifter"]
["It is assumed that a community bin lifter can do max. 4 trips a day. Number of trips may vary based on the distance between bins placed and waste disposal site. If the ULB has both single and twin community bin lifter machies then 50% of total number of community bins will be lifted by both lifter machines each."]
["Number of container bins can be lifted a day (single lifter)",4]
["Number of container bins can be lifted a day (twin lifter)",8]
[]
["Refuse compactor"]
["Number of trips per day",2]
[]
["Assumption for O&M"]
["Salary of a driver p.a.",{"$f":"12000*12","v":144000}]
["Salary of a helper p.a.",{"$f":"8000*12","v":96000}]
["Travel/vehicle/day in km",100]
["Fuel cost per km",15]
["Total fuel cost per vehicle per day",{"$f":"B101*B102","v":1500}]
["Total fuel cost per vehicle per annum",{"$f":"B103*365","v":547500}]

{"sheet":"Dropdown","index":5,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[null,"Select option",null,"Select option"]
[null,"Yes",null,"ULB itself"]
[null,"No",null,"Private Agency"]
[null,"NA"]
[null,"Partially"]
[null,"Select option"]
[null,"Open Dump site"]
[null,"Scientific Landfill site"]
[null,"Processing / treatment site"]
[]
[null,"Area of the "," (in Acre)"]
[null,"Capacity of the "," (in MT)"]
[null,"Approx. distance of the "," (in km)"]
[]
[null," operated and maintained by"]