{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["RESUMEN","ANUAL","Hoja3"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"RESUMEN","index":0,"n_rows":34,"n_cols":5,"rows_kept":34,"flags":["formulas_cached_only"]}
[null,"ANEJO 10 SECTOR II"]
[]
["RESUMEN PRESUPUESTOS PLIEGO SECTOR I"]
["BASE IMPONIBLE"]
["AÑO","Nº MESES","CONSERVACIÓN Y VALORACIÓN OBRA","LIMPIEZA","B. I.  TOTAL"]
[2012,0.5,{"v":69912.87152791668,"d":"69,912.87 €"},{"v":6099.570833333334,"d":"6,099.57 €"},{"v":76012.44236125001,"d":"76,012.44 €"}]
[2013,12,{"v":1677908.9166700002,"d":"1,677,908.92 €"},{"v":146389.7,"d":"146,389.70 €"},{"v":1824298.6166700001,"d":"1,824,298.62 €"}]
[2014,12,{"v":1677908.9166700002,"d":"1,677,908.92 €"},{"v":146389.7,"d":"146,389.70 €"},{"v":1824298.6166700001,"d":"1,824,298.62 €"}]
[2015,12,{"v":1677908.9166700002,"d":"1,677,908.92 €"},{"v":146389.7,"d":"146,389.70 €"},{"v":1824298.6166700001,"d":"1,824,298.62 €"}]
[2016,11.5,{"v":1607996.0451420834,"d":"1,607,996.05 €"},{"v":140290.12916666668,"d":"140,290.13 €"},{"v":1748286.17430875,"d":"1,748,286.17 €"}]
["Prórrogas",24,{"v":3355817.8333400004,"d":"3,355,817.83 €"},{"v":292779.4,"d":"292,779.40 €"},{"v":3648597.2333400003,"d":"3,648,597.23 €"}]
[null,"TOTAL",{"v":10067453.50002,"d":"10,067,453.50 €"},{"v":878338.2000000001,"d":"878,338.20 €"},{"v":10945791.70002,"d":"10,945,791.70 €"}]
["DESGLOSE DE IVA"]
["AÑO","Nº MESES","CONSERVACIÓN Y VALORACIÓN OBRA","LIMPIEZA","IVA TOTAL"]
[2012,0.5,{"v":14681.7030208625,"d":"14,681.70 €"},{"v":609.9570833333333,"d":"609.96 €"},{"v":15291.660104195833,"d":"15,291.66 €"}]
[2013,12,{"v":352360.8725007,"d":"352,360.87 €"},{"v":14638.970000000001,"d":"14,638.97 €"},{"v":366999.84250070003,"d":"366,999.84 €"}]
[2014,12,{"v":352360.8725007,"d":"352,360.87 €"},{"v":14638.970000000001,"d":"14,638.97 €"},{"v":366999.84250070003,"d":"366,999.84 €"}]
[2015,12,{"v":352360.8725007,"d":"352,360.87 €"},{"v":14638.970000000001,"d":"14,638.97 €"},{"v":366999.84250070003,"d":"366,999.84 €"}]
[2016,11.5,{"v":352360.8725007,"d":"352,360.87 €"},{"v":14638.970000000001,"d":"14,638.97 €"},{"v":366999.84250070003,"d":"366,999.84 €"}]
["Prórrogas",24,{"v":704721.7450014,"d":"704,721.75 €"},{"v":29277.940000000002,"d":"29,277.94 €"},{"v":733999.6850014001,"d":"733,999.69 €"}]
[null,null,{"v":2128846.9380250624,"d":"2,128,846.94 €"},{"v":88443.77708333333,"d":"88,443.78 €"},{"v":2217290.715108396,"d":"2,217,290.72 €"}]
["IMPORTE TOTAL DE LICITACIÓN"]
["AÑO","Nº MESES","BASE IMPONIBLE","IVA TOTAL","IMPORTE ANUAL TOTAL"]
[2012,0.5,{"v":76012.44236125001,"d":"76,012.44 €"},{"v":15291.660104195833,"d":"15,291.66 €"},{"v":91304.10246544585,"d":"91,304.10 €"}]
[2013,12,{"v":1824298.6166700001,"d":"1,824,298.62 €"},{"v":366999.84250070003,"d":"366,999.84 €"},{"v":2191298.4591707,"d":"2,191,298.46 €"}]
[2014,12,{"v":1824298.6166700001,"d":"1,824,298.62 €"},{"v":366999.84250070003,"d":"366,999.84 €"},{"v":2191298.4591707,"d":"2,191,298.46 €"}]
[2015,12,{"v":1824298.6166700001,"d":"1,824,298.62 €"},{"v":366999.84250070003,"d":"366,999.84 €"},{"v":2191298.4591707,"d":"2,191,298.46 €"}]
[2016,11.5,{"v":1748286.17430875,"d":"1,748,286.17 €"},{"v":366999.84250070003,"d":"366,999.84 €"},{"v":2115286.01680945,"d":"2,115,286.02 €"}]
["Prórrogas",24,{"v":3648597.2333400003,"d":"3,648,597.23 €"},{"v":733999.6850014001,"d":"733,999.69 €"},{"v":4382596.9183414,"d":"4,382,596.92 €"}]
[null,"TOTAL",{"v":10945791.70002,"d":"10,945,791.70 €"},{"v":2217290.715108396,"d":"2,217,290.72 €"},{"v":13163082.415128395,"d":"13,163,082.42 €"}]
["DISTRIBUCION POR CAPÍTULOS"]
[null,"CAPITULO","BASE IMPONIBLE","IVA TOTAL","TOTAL"]
[null,"VI",{"v":10067453.50002,"d":"10,067,453.50 €"},{"v":2128846.9380250624,"d":"2,128,846.94 €"},{"v":12196300.438045062,"d":"12,196,300.44 €"}]
[null,"II",{"v":878338.2000000001,"d":"878,338.20 €"},{"v":88443.77708333333,"d":"88,443.78 €"},{"v":966781.9770833334,"d":"966,781.98 €"}]

{"sheet":"ANUAL","index":1,"n_rows":69,"n_cols":6,"rows_kept":69,"flags":["formulas_cached_only"]}
[null,"SECTOR II","PRESUPUESTO DESGLOSADO ANUAL (en €)"]
["Apdo","Concepto","Precio €/Ud.","%","Uds","Coste"]
[1,"CONSERVACIÓN DE ELEMENTOS VEGETALES"]
["1.1","Conservación m2/año de césped, incluida resiembra del 7% anual.  Anexo A",{"v":1.3,"d":"1.30"},{"v":1,"d":"100%"},{"v":690003,"d":"690,003"},{"v":897003.9,"d":"897,003.90 €"}]
["1.2","Conservación de pradera incluida resiembra  Anexo B",0.75,{"v":1,"d":"100%"},0,{"v":0,"d":"0.00 €"}]
["1.3","Conservación m2/año de arboleda, zona de arbustos o mixta incluidos el riego,  poda y apeos precisos así como la bina y otros cuidados culturales.",{"v":0.30000000000000004,"d":"0.30"},{"v":1,"d":"100%"},{"v":108554,"d":"108,554"},{"v":32566.200000000004,"d":"32,566.20 €"}]
["1.4","Recebado y reparación de caminos enarenados incluyendo las reparaciones necesarias.",{"v":1.5,"d":"1.50"},{"v":0.02,"d":"2%"},{"v":148995,"d":"148,995"},{"v":4469.85,"d":"4,469.85 €"}]
["1.5","Conservación m2/año arbolado y arbustos en Parques y otras zonas con césped incluida poda  y los apeos precisos.",{"v":0.2,"d":"0.20"},{"v":1,"d":"100%"},{"v":839861,"d":"839,861"},{"v":167972.2,"d":"167,972.20 €"}]
["1.6","Ud. de conservación arbolado lineal con alcorque en calles y plazas duras,  incluido el riego y mantenimiento del alcorque.",{"v":4,"d":"4.00"},{"v":1,"d":"100%"},{"v":7081,"d":"7,081"},{"v":28324,"d":"28,324.00 €"}]
["1.7","Ud. de conservación arbolado lineal no en alcorque en calles y plazas  incluido el riego.",{"v":3,"d":"3.00"},{"v":1,"d":"100%"},{"v":8521,"d":"8,521"},{"v":25563,"d":"25,563.00 €"}]
["1.8","Control de sanidad vegetal  y de seguridad del arbolado",{"v":9500,"d":"9,500.00"},{"v":1,"d":"100%"},1,{"v":9500,"d":"9,500.00 €"}]
["1.9","Tratamiento fitosanitario en árboles y arbustos, incluido producto",{"v":4000,"d":"4,000.00"},{"v":1,"d":"100%"},1,{"v":4000,"d":"4,000.00 €"}]
["1.10","Recortes de seto, con retirada de sobrantes a contenedor",{"v":1.9,"d":"1.90"},{"v":2,"d":"200%"},{"v":13843,"d":"13,843"},{"v":52603.399999999994,"d":"52,603.40 €"}]
["1.11","Poda de formación, o aquella necesaria de árboles pequeños en calles y plazas, incluida la tala de árboles muertos y retirada de restos a vertedero.",{"v":22,"d":"22.00"},{"v":0.35,"d":"35%"},{"v":6002,"d":"6,002"},{"v":46215.4,"d":"46,215.40 €"}]
["1.12","Poda de limpieza, o aquella necesaria, de árboles adultos en calles y plazas, incluida la tala de árboles muertos y retirada restos a vertedero.",{"v":60,"d":"60.00"},{"v":0.15,"d":"15%"},{"v":9096,"d":"9,096"},{"v":81864,"d":"81,864.00 €"}]
["1.13","Poda árboles muy grandes en calles y plazas, incluida la tala de árboles muertos y retirada de restos a vertedero.",{"v":180,"d":"180.00"},{"v":0.08,"d":"8%"},504,{"v":7257.6,"d":"7,257.60 €"}]
["2","RIEGO"]
["2.1","Control y mantenimiento del sistema de riego informatizado.",{"v":5000,"d":"5,000.00"},{"v":1,"d":"100%"},1,{"v":5000,"d":"5,000.00 €"}]
["2.2","Conservación, reparación y reposición de cualquier avería en sistema de riego y red de drenaje, incluidos los aspersores rotos por  actos vandálicos.",{"v":30000,"d":"30,000.00"},{"v":1,"d":"100%"},1,{"v":30000,"d":"30,000.00 €"}]
["3","PLANTACION"]
["3.1","Plantación de flor y cuidado de la misma",{"v":1,"d":"1.00"},{"v":3,"d":"300%"},880,{"v":2640,"d":"2,640.00 €"}]
["3.2","Plantación arbolado lineal en alcorque, apertura de hoyo, abonado, reposición de tierra, revisión de riego y riego durante dos años en su caso.",{"v":210,"d":"210.00"},{"v":1,"d":"100%"},100,{"v":21000,"d":"21,000.00 €"}]
["3.3","Plantación arbolado no  en alcorque, apertura de hoyo, abonado, reposición de tierra, revisión de riego y riego durante dos años en su caso.",{"v":170,"d":"170.00"},{"v":1,"d":"100%"},50,{"v":8500,"d":"8,500.00 €"}]
["3.4","Plantación de arbustos y otros",{"v":50,"d":"50.00"},{"v":1,"d":"100%"},100,{"v":5000,"d":"5,000.00 €"}]
[]
[]
["4","CONSERVACIÓN MOBILIARIO"]
["4.1","Conservación, reparación y pintado  de cualquier tipo de banco, o mesa",{"v":20,"d":"20.00"},{"v":1,"d":"100%"},{"v":2187,"d":"2,187"},{"v":43740,"d":"43,740.00 €"}]
["4.2","Mantenimiento y pintado de juego infantil grande",{"v":200,"d":"200.00"},{"v":1,"d":"100%"},35,{"v":7000,"d":"7,000.00 €"}]
["4.3","Mantenimiento y pintado  de juego infantil mediano",{"v":160,"d":"160.00"},{"v":1,"d":"100%"},40,{"v":6400,"d":"6,400.00 €"}]
["4.4","Mantenimiento y pintado  de juego infantil pequeño",{"v":90,"d":"90.00"},{"v":1,"d":"100%"},107,{"v":9630,"d":"9,630.00 €"}]
["4.5","Mantenimiento y pintado  de juegos para mayores",{"v":50,"d":"50.00"},{"v":1,"d":"100%"},50,{"v":2500,"d":"2,500.00 €"}]
["4.6","Mantenimiento y pintado de juegos deportivos",{"v":60,"d":"60.00"},{"v":1,"d":"100%"},13,{"v":780,"d":"780.00 €"}]
["4.7","Mantenimiento y pintado de cualquier tipo de papelera",{"v":9,"d":"9.00"},{"v":1,"d":"100%"},321,{"v":2889,"d":"2,889.00 €"}]
["4.8","Mantenimiento y pintado  de cualquier tipo de bidones",{"v":10,"d":"10.00"},{"v":1,"d":"100%"},84,{"v":840,"d":"840.00 €"}]
["4.9","Pintado de valla metálica o madera",{"v":16,"d":"16.00"},{"v":0.25,"d":"25%"},{"v":1597,"d":"1,597"},{"v":6388,"d":"6,388.00 €"}]
["4.10","Mantenimiento y pintado fuente de beber de cualquier tipo, incluso limpieza desagües, reposición de grifos,...",{"v":240,"d":"240.00"},{"v":1,"d":"100%"},52,{"v":12480,"d":"12,480.00 €"}]
[{"$nulls":4},"Parcial 1-4",{"v":1522126.55,"d":"1,522,126.55 €"}]
["5","LIMPIEZA"]
["5.1","m2 limpieza diaria de papeles y otros, con transporte a container y eliminación de basuras. Anexo 1   y zonas juegos infantiles",{"v":0.30000000000000004,"d":"0.30"},{"v":1,"d":"100%"},{"v":34534,"d":"34,534"},{"v":10360.2,"d":"10,360.20 €"}]
["5.2","m2 limpieza 2 días semana de papeles y otros y de papeleras, con transporte a container y eliminación de basuras.",{"v":0.1,"d":"0.10"},{"v":1,"d":"100%"},{"v":832545,"d":"832,545"},{"v":83254.5,"d":"83,254.50 €"}]
["5.3","Limpieza  de guarderías caninas en diferentes parques de la ciudad cada mes (€/Ud/año)",{"v":470,"d":"470.00"},{"v":1,"d":"100%"},3,{"v":1410,"d":"1,410.00 €"}]
["5.4","Limpieza de esculturas, incluida la eliminación de grafitos, 1 vez al año.",{"v":175,"d":"175.00"},{"v":1,"d":"100%"},3,{"v":525,"d":"525.00 €"}]
["5.5","Ud. limpieza especial por actos festivos incluso salida a vertedero (anual).",{"v":2000,"d":"2,000.00"},{"v":1,"d":"100%"},1,{"v":2000,"d":"2,000.00 €"}]
["5.6","Limpieza dominical de los restos producidos por el botellón",{"v":220,"d":"220.00"},{"v":1,"d":"100%"},52,{"v":11440,"d":"11,440.00 €"}]
["5.7","Tm de vertido de papeles y otros con transporte a container y eliminación basuras",{"v":34,"d":"34.00"},{"v":1,"d":"100%"},{"v":1100,"d":"1,100"},{"v":37400,"d":"37,400.00 €"}]
[{"$nulls":4},"Parcial 5",{"v":146389.7,"d":"146,389.70 €"}]
["6","TRABAJOS POR VALORACIÓN"]
["6.1","Material para arreglos motivados por actos vandálicos (menos aspersores).",{"v":1522126.55,"d":"1,522,126.55"},{"v":0.02,"d":"2%"},1,{"v":30442.531000000003,"d":"30,442.53 €"}]
["6.2","Actuaciones extraordinarias de conservación de zonas verdes, infraestructuras y mobiliario.",{"v":1522126.55,"d":"1,522,126.55"},{"v":0.06,"d":"6.0%"},1,{"v":91327.593,"d":"91,327.59 €"}]
["6.3","Protección árboles singulares",{"v":10000,"d":"10,000.00"},{"v":1,"d":"100%"},1,{"v":10000,"d":"10,000.00 €"}]
["6.4","Sensibilización y participación",{"v":4000,"d":"4,000.00"},{"v":1,"d":"100%"},1,{"v":4000,"d":"4,000.00 €"}]
[{"$nulls":4},"Parcial 6",{"v":135770.124,"d":"135,770.12 €"}]
[null,"Gastos Generales Trabajos por Valoración 6.2 a 6.4",{"v":105327.593,"d":"105,327.59"},{"v":0.13,"d":"13%"},null,{"v":13692.587089999999,"d":"13,692.59 €"}]
[null,"Beneficio Industrial Trabajos  por Valoración  6.2 a 6.4",{"v":105327.593,"d":"105,327.59"},{"v":0.06,"d":"6%"},null,{"v":6319.65558,"d":"6,319.66 €"}]
[{"$nulls":4},"Parcial 6",{"v":20012.24267,"d":"20,012.24 €"}]
[{"$nulls":4},"Total 6",{"v":155782.36667000002,"d":"155,782.37 €"}]
["RESUMEN"]
[null,"Conservación (1,2,3 y 4)",{"$nulls":3},{"v":1522126.55,"d":"1,522,126.55 €"}]
[null,"Trabajos por valoración  (6)",{"$nulls":3},{"v":155782.36667000002,"d":"155,782.37 €"}]
[null,"IVA (1,2,3,4 y 6)",{"v":1677908.9166700002,"d":"1,677,908.92"},{"v":0.21,"d":"21%"},null,{"v":352360.8725007,"d":"352,360.87 €"}]
[null,"Capitulo VI",{"$nulls":3},{"v":2030269.7891707001,"d":"2,030,269.79 €"}]
[null,"Limpieza (5)",{"$nulls":3},{"v":146389.7,"d":"146,389.70 €"}]
[null,"IVA (5)",{"v":146389.7,"d":"146,389.70"},{"v":0.1,"d":"10%"},null,{"v":14638.970000000001,"d":"14,638.97 €"}]
[null,"Capitulo II",{"$nulls":3},{"v":161028.67,"d":"161,028.67 €"}]
[null,"TOTAL",{"$nulls":3},{"v":2191298.4591707,"d":"2,191,298.46 €"}]
[]
[]
[{"$nulls":5},{"v":2071613.47,"d":"2,071,613.47"}]

{"sheet":"Hoja3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}