{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Etapa 2 sector 1_ Rubrado"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Etapa 2 sector 1_ Rubrado","index":0,"n_rows":467,"n_cols":9,"rows_kept":467,"cut":false,"hidden":false,"merged":[[172,2,172,8],[416,1,416,8],[418,2,418,8],[440,1,440,8],[7,2,7,8],[12,2,12,8],[34,2,34,8],[86,2,86,8],[138,2,138,8],[148,2,148,8],[5,1,5,8],[0,1,0,8],[1,1,1,8],[2,1,2,8],[3,1,3,8],[4,1,4,8]]}
[null,"Programa de Mejoramiento de Barrios -  Prestamo BID Nº3097/OC-UR"]
[null,"PRESUPUESTO POR RUBROS ASENTAMIENTO \"COTRAVI\" "]
[null,"ETAPA 2- SECTOR 1"]
[]
[null,"Financiación PMB/MVOT"]
[null,"INVERSIÓN DIRECTA "]
[null,"Item","Rubro","UNIDAD ","METRAJE TOTAL","UNITARIO ","SUBTOTAL ","UNIT. LLSS ","SUBT. LLSS "]
[null,1,"IMPLANTACION GENERAL DE OBRA"]
[null,1.0009999999999999,"Movilización e implantación","global",1,null,{"$f":"+F9*E9","v":0},null,{"$f":"+H9*E9","v":0}]
[{"$nulls":8},{"$f":"+H10*E10","v":0}]
[null,null,"SUBTOTAL",null,null,null,{"$f":"SUM(G9:G10)","v":0},null,{"$f":"+I9+I10","v":0}]
[null,"Item","Rubro","UNIDAD ","METRAJE TOTAL","UNITARIO ","SUBTOTAL ","UNIT. LLSS ","SUBT. LLSS "]
[null,2,"RED VIAL"]
[null,null,"RUBROS GLOBALES"]
[null,{"$f":"+B13+0.001","v":2.0009999999999999},"Movilización","gl",1,null,{"$f":"+E15*F15","v":0},null,{"$f":"+H15*E15","v":0}]
[null,{"$f":"B15+0.001","v":2.0019999999999998},"Recuperación Ambiental","gl",1,null,{"$f":"+E16*F16","v":0},null,{"$f":"+H16*E16","v":0}]
[null,2.0029999999999997,"Señalización de Obra","gl",1,null,0,null,{"$f":"+H17*E17","v":0}]
[null,2.0039999999999996,"Desvíos de Tránsito","gl",1,null,0,null,0]
[null,2.0049999999999994,"Ayuda para adecuación de servicios públicos","gl",1,null,0,null,0]
[null,null,"MOVIMIENTO DE SUELOS"]
[null,{"$f":"+B19+0.001","v":2.0059999999999993},"Excavación No Clasificada","m³",2788.852897664975,null,0,null,0]
[null,{"$f":"B21+0.001","v":2.0069999999999992},"Excavación No Clasificada A Depósito","m³",13715.671263271883,null,0,null,0]
[null,2.0079999999999991,"Excavación No Clasificada De Préstamo","m³",3273.9800761908114,null,0,null,0]
[null,2.008999999999999,"Sobretransporte de Suelos (Distancia Libre = 400 metros )","m³.Km",38285.00360379737,null,0,null,0]
[null,null,"PAVIMENTOS "]
[null,2.0099999999999998,"Cemento Portland para Base Estabilizada con Cemento (Con Transporte)","Ton",46.899412528407652,null,0,null,0]
[null,{"$f":"B26+0.001","v":2.0109999999999997},"Base Granular con CBR > 60 % (Con Transporte)","m³",3040.620685969056,null,0,null,0]
[null,2.0119999999999996,"Base Granular Con CBR > 80 % (Con Transporte)","m³",2831.5361259899619,null,0,null,0]
[null,2.0129999999999995,"Material de Base Estabilizado con Cemento Portland con Transporte","m³",468.99412528407657,null,0,null,0]
[null,2.0139999999999993,"Cordón Cuneta de Hormigón Simple","M",1425.3707566163757,null,0,null,0]
[null,2.0149999999999992,"Demolición y Retiro de Pavimentos","M2",295.24724737368996,null,0,null,0]
[null,2.0159999999999991,"Hormigón para veredas","m³",307.67974527750869,null,{"$f":"+E32*F32","v":0},null,{"$f":"+H32*E32","v":0}]
[null,null,"SUBTOTAL",null,null,null,{"$f":"SUM(G14:G32)","v":0},null,{"$f":"SUM(I14:I32)","v":0}]
[null,"Item","Rubro","UNIDAD ",null,"UNITARIO ","SUBTOTAL ","UNIT. LLSS ","SUBT. LLSS "]
[null,3,"RED DE DESAGÜES PLUVIALES"]
[null,null,"SUMINISTRO E INSTALACIÓN DE TUBERIA (INCLUYE TAPADO Y APISONADO)"]
[null,{"$f":"+B35+0.001","v":3.0009999999999999},"Suminstro e instalación de  tubería d = 400 mm ( entre 0 y 2 m )  PVC","m",136.19999999999999,null,{"$f":"+F37*E37","v":0},null,{"$f":"+H37*E37","v":0}]
[null,{"$f":"B37+0.001","v":3.0019999999999998},"Suminstro e instalación de  tubería d = 600 mm ( entre 0 y 2 m )  ","m",107.2,null,{"$f":"+F38*E38","v":0},null,{"$f":"+H38*E38","v":0}]
[null,{"$f":"B38+0.001","v":3.0029999999999997},"Protección de tuberías  (con losa de hormigón) d=600 mm","m",10,null,0,null,0]
[null,null,"REGISTROS Y POZOS DE VISITA"]
[null,{"$f":"+B39+0.001","v":3.0039999999999996},"Construcción de registros entre 0 y 2 m para diámetro < 800 mm","un",6,null,0,null,0]
[null,null,"ESTRUCTURAS DE CAPTACIÓN Y DESCARGA"]
[null,{"$f":"+B41+0.001","v":3.0049999999999994},"Boca de tormenta tipo 1 (incluye conexión)","un",3,null,0,null,0]
[null,{"$f":"B43+0.001","v":3.0059999999999993},"Boca de tormenta tipo 2 (incluye conexión)","un",3,null,0,null,0]
[null,{"$f":"B44+0.001","v":3.0069999999999992},"Construcción de toma de cuneta  (incluye conexión)","un",9,null,0,null,0]
[null,{"$f":"B45+0.001","v":3.0079999999999991},"Cabezal de descarga tipo (para  Ø400 mm)","un",1,null,0,null,0]
[null,{"$f":"B46+0.001","v":3.008999999999999},"Cabezal de descarga tipo (para  Ø600 mm)","un",1,null,0,null,0]
[null,null,"ENTRADAS VEHICULARES"]
[null,{"$f":"+B47+0.001","v":3.0099999999999989},"Entradas vehiculares en cunetas tipo A","un",114,null,0,null,0]
[null,{"$f":"+B49+0.001","v":3.0109999999999988},"Entradas vehiculares en cunetas tipo B","un",25,null,0,null,0]
[null,{"$f":"B50+0.001","v":3.0119999999999987},"Entradas peatonales","un",1,null,0,null,0]
[]
[null,null,"SOLUCIONES PARTICULARES PREDIOS BAJOS"]
[null,{"$f":"B51+0.001","v":3.0129999999999986},"Bocas de desagüe y cámaras de inspección","gl",1,null,0,null,0]
[null,{"$f":"B54+0.001","v":3.0139999999999985},"Tubería PVC 160mm","m",18,null,0,null,0]
[null,3.0149999999999983,"Media caña PVC 200 mm","m",147,null,0,null,0]
[null,3.0159999999999982,"Cabezal de descarga en cuneta","gl",10,null,0,null,0]
[null,3.0169999999999981,"Tubería PVC 200 mm","m",40,null,0,null,0]
[null,3.017999999999998,"Canal de bloque armado (ancho 0.35 m)","m",98,null,0,null,0]
[null,null,"ALCANTARILLAS HORMIGON SIMPLE "]
[null,{"$f":"+B59+0.001","v":3.0189999999999979},"Caño de hormigón simple de 40 cm de diámetro (sin cabezales)","m",164,null,0,null,0]
[null,{"$f":"B61+0.001","v":3.0199999999999978},"Cabezal de alcantarilla 1x∅400 mm","un",29,null,0,null,0]
[null,null,"ALCANTARILLAS HORMIGON ARMADO "]
[null,{"$f":"+B62+0.001","v":3.0209999999999977},"Alcantarillas de caños de hormigón armado de 50 cm (sin cabezales)","m",63,null,0,null,0]
[null,{"$f":"B64+0.001","v":3.0219999999999976},"Alcantarillas de caños de hormigón armado de 60 cm (sin cabezales)","m",34,null,0,null,0]
[null,{"$f":"B65+0.001","v":3.0229999999999975},"Alcantarillas de caños de hormigón armado de 100 cm (sin cabezales)","m",35,null,0,null,0]
[null,{"$f":"B66+0.001","v":3.0239999999999974},"Cabezal de alcantarilla 2x∅50 cm","un",4,null,0,null,0]
[null,{"$f":"B67+0.001","v":3.0249999999999972},"Cabezal de alcantarilla 2x∅60 cm","un",2,null,0,null,0]
[null,{"$f":"B68+0.001","v":3.0259999999999971},"Cabezal de alcantarilla 3x∅1000 mm","un",2,null,0,null,0]
[null,3.026999999999997,"Cámara en alcantarillas compuestas","un",11,null,0,null,0]
[]
[null,null,"CUNETAS, DRENES Y TERRAPLENES"]
[null,{"$f":"B70+0.001","v":3.0279999999999969},"Revestimiento de taludes mediante siembra de pasto","há",0.43,null,0,null,0]
[null,{"$f":"B73+0.001","v":3.0289999999999968},"Revestimiento de hormión en cunetas especiales","m3",94.129169648683003,null,0,null,0]
[null,{"$f":"B74+0.001","v":3.0299999999999967},"Badenes","m",74,null,0,null,0]
[null,null,"SOBRECOSTOS"]
[null,{"$f":"+B75+0.001","v":3.0309999999999966},"Abatimiento de napa para colectores entre 0 y 2 m","m",195,null,0,null,0]
[]
[null,null,"CONFORMACIÓN DE CANAL A CIELO ABIERTO"]
[null,{"$f":"B77+0.001","v":3.0319999999999965},"Excavación no clasificada","m3",311.6155,null,0,null,0]
[null,{"$f":"B80+0.001","v":3.0329999999999964},"Excavación no clasificada a depósito","m3",939.72449999999992,null,0,null,0]
[null,3.0339999999999963,"Revestimiento de taludes y fondo en suelo pasto","há",0.28367399999999998,null,0,null,0]
[null,3.0349999999999961,"Protección de hormigón armado en la descarga de alcantarilla ∅400 mm","un",2,null,0,null,0]
[null,3.035999999999996,"Protección de hormigón armado en la descarga de alcantarilla ∅600 mm","un",2,null,0,null,0]
[null,null,"SUBTOTAL",null,null,null,{"$f":"SUM(G36:G84)","v":0},null,{"$f":"SUM(I36:I84)","v":0}]
[null,"Item","Rubro","UNIDAD ",null,"UNITARIO ","SUBTOTAL ","UNIT. LLSS ","SUBT. LLSS "]
[null,4,"RED DE SANEAMIENTO"]
[null,null,"SUMINISTRO E INSTALACIÓN DE TUBERIA DE PVC (INCLUYE PRUEBAS HIDRAULICAS, TAPADO Y APISONADO)"]
[null,{"$f":"+B87+0.001","v":4.0010000000000003},"Suministro e instalación de tubería d = 200 mm (entre 0 y 2 m)","m",1479.2764112458999,null,{"$f":"+F89*E89","v":0},null,{"$f":"+H89*E89","v":0}]
[null,{"$f":"+B89+0.001","v":4.0020000000000007},"Suministro e instalación de tubería d = 200 mm (entre 2 y 3 m)","m",348.089588754099,null,{"$f":"+F90*E90","v":0},null,{"$f":"+H90*E90","v":0}]
[null,{"$f":"B90+0.001","v":4.003000000000001},"Suministro e instalación de tubería d = 250 mm (entre 2 y 3 m)","m",58,null,0,null,0]
[null,4.0040000000000013,"Suministro e instalación de tubería d = 250 mm (entre 3 y 4 m)","m",2.2735023474180842]
[null,{"$f":"+B91+0.001","v":4.0040000000000013},"Suministro e instalación de tubería d = 315 mm (entre 0 y 2 m)","m",490,null,0,null,0]
[null,{"$f":"+B93+0.001","v":4.0050000000000017},"Suministro e instalación de tubería d = 315mm (entre 2 y 3 m)","m",100,null,0,null,0]
[null,4.006000000000002,"Suministro e instalación de tubería d = 400mm (entre 0 y 2 m) ","m",144.38702486002879,null,0,null,0]
[null,4.0070000000000023,"Suministro e instalación de tubería d = 400mm (entre 2 y 3 m) ","m",106.22262616867133,null,0,null,0]
[null,4.0080000000000027,"Suministro e instalación de tubería d = 400mm (entre 3 y 4 m) ","m",56.248348971299897,null,0,null,0]
[null,{"$f":"+B97+0.001","v":4.009000000000003},"Anulación de colector provisorio d =200mm (entre 0 y 2 m) y adaptación de conexiones","m",26,null,0,null,0]
[null,null,"REGISTROS Y PROTECCIONES"]
[null,{"$f":"+B98+0.001","v":4.0100000000000033},"Construcción de registros de primera categoría entre 0 y 2 m","un",15,null,0,null,0]
[null,{"$f":"+B100+0.001","v":4.0110000000000037},"Construcción de registros de primera categoría entre 2 y 3 m","un",7,null,0,null,0]
[null,4.012000000000004,"Construcción de registros de segunda categoría entre 2 y 3 m","un",5,null,0,null,0]
[null,4.0130000000000043,"Construcción de registros de segunda categoría entre 3 y 4 m","un",2,null,0,null,0]
[null,4.0140000000000047,"Construcción de cámara terminal ","un",1,null,0,null,0]
[null,4.015000000000005,"Construcción de terminal de colector","un",13,null,0,null,0]
[null,4.0160000000000053,"Cámara de aliviadero con retención tipo pico de pato 400mm ","gl",1,null,0,null,0]
[null,4.0170000000000057,"Cabezal de descarga aliviadero","m",1,null,0,null,0]
[null,4.018000000000006,"Cámara para caudalímetro","un",1,null,0,null,0]
[null,null,"CONEXIONES INDIVIDUALES"]
[null,{"$f":"+B108+0.001","v":4.0190000000000063},"Construcción de conexiones domiciliarias","un",169,null,0,null,0]
[null,{"$f":"+B110+0.001","v":4.0200000000000067},"Construcción de cámara N° 1","un",126,null,0,null,0]
[null,{"$f":"+B111+0.001","v":4.021000000000007},"Suministro e instalación de válvulas de retención","un",4,null,0,null,0]
[null,{"$f":"+B112+0.001","v":4.0220000000000073},"Cegado de pozos negros","un",126,null,0,null,0]
[null,null,"ESTRUCTURAS DE PLANTA DE BOMBEO"]
[null,{"$f":"+B113+0.001","v":4.0230000000000077},"Excavación para Pozo de Bombeo y Cámara de Válvulas en terreno blando y napa freática alta","m3",482,null,0,null,0]
[null,{"$f":"+B115+0.001","v":4.024000000000008},"Relleno y nivelación del terreno","m3",890,null,0,null,0]
[null,{"$f":"+B116+0.001","v":4.0250000000000083},"Hormigón Pozo de Bombeo y fosa séptica","m3",80,null,0,null,0]
[null,null,"EQUIPOS, REJAS, BARANDAS, ETC"]
[null,{"$f":"+B117+0.001","v":4.0260000000000087},"Suministro de equipos de bombeo,con repuestos y guías de izado","un",3,null,0,null,0]
[null,{"$f":"+B119+0.001","v":4.027000000000009},"Suministro de tanque hidroneumático 1.5 m3","un",1,null,0,null,0]
[null,{"$f":"+B120+0.001","v":4.0280000000000094},"Suministro de válvulas otras","gl",1,null,0,null,0]
[null,{"$f":"+B121+0.001","v":4.0290000000000097},"Suministro de tableros","gl",1,null,0,null,0]
[null,{"$f":"+B122+0.001","v":4.03000000000001},"Suministro de caudalímetro","un",1,null,0,null,0]
[null,null,"ACONDICINAMIENTO DEL PREDIO DE LA PLANTA DE TRATAMIENTO Y BOMBEO"]
[null,{"$f":"+B123+0.001","v":4.0310000000000104},"Pavimento","m2",100,null,0,null,0]
[null,{"$f":"+B125+0.001","v":4.0320000000000107},"Suministro y colocación de muro perimetral prefabricado","gl",1,null,0,null,0]
[null,null,"LÍNEA DE IMPULSIÓN"]
[null,{"$f":"+B126+0.001","v":4.033000000000011},"Suminstro e instalación de tuberías d = 250 mm  PEAD","m",720,null,0,null,0]
[null,{"$f":"+B128+0.001","v":4.0340000000000114},"Construcción de cámara para válvulas de aire (incluye piezas especiales y válvula)","gl",1,null,0,null,0]
[null,{"$f":"+B129+0.001","v":4.0350000000000117},"Construcción de cámara para válvulas de desagüe  (incluye piezas especiales y válvula)","gl",1,null,0,null,0]
[null,null,"REPOSICIÓN PROVISORIA DE PAVIMENTO"]
[null,{"$f":"+B130+0.001","v":4.036000000000012},"Reposición provisoria de pavimento","m2",12762.178,null,0,null,0]
[null,null,"SOBREPRECIOS POR ABATIMIENTO DE NAPA"]
[null,{"$f":"+B132+0.001","v":4.0370000000000124},"Abatimiento de napa para colectores entre 0 y 2 m","m",1040.3173347664699,null,0,null,0]
[null,{"$f":"+B134+0.001","v":4.0380000000000127},"Abatimiento de napa para colectores entre 2 y 3 m","m",344.29640309883007,null,0,null,0]
[null,{"$f":"+B135+0.001","v":4.039000000000013},"Abatimiento de napa para colectores entre 2 y 4 m","m",603.02563699041696,null,0,null,0]
[null,null,"SUBTOTAL",null,null,null,{"$f":"SUM(G88:G136)","v":0},null,{"$f":"SUM(I88:I136)","v":0}]
[null,"Item","Rubro","UNIDAD ",null,"UNITARIO ","SUBTOTAL ","UNIT. LLSS ","SUBT. LLSS "]
[null,5,"RED DE AGUA POTABLE"]
[null,null,"SUMINISTRO E INSTALACIÓN  DE TUBERIAS Y PIEZAS"]
[null,{"$f":"+B139+0.001","v":5.0010000000000003},"Suministro e instalación de tubería de alta presión d = 63 mm  PEAD (incluye suministro e instalación de piezas especiales)","m",1430,null,{"$f":"+F141*E141","v":0},null,{"$f":"+H141*E141","v":0}]
[null,{"$f":"+B141+0.001","v":5.0020000000000007},"Suministro de llaves de paso DN 63 mm e instalación en cámaras","un",8,null,{"$f":"+F142*E142","v":0},null,{"$f":"+H142*E142","v":0}]
[null,{"$f":"+B142+0.001","v":5.003000000000001},"Suministro de hidrantes e instalación en cámaras","un",null,null,0,null,0]
[null,5.0040000000000013,"Desinfección","m",1230,null,0,null,0]
[null,null,"CONEXIONES"]
[null,{"$f":"+B144+0.001","v":5.0050000000000017},"Conexiones domiciliarias (con medidor y nicho)","un",74,null,0,null,0]
[null,null,"SUBTOTAL",null,null,null,{"$f":"SUM(G141:G146)","v":0},null,{"$f":"SUM(I141:I146)","v":0}]
[null,"Item","Rubro","UNIDAD ",null,"UNITARIO ","SUBTOTAL ","UNIT. LLSS ","SUBT. LLSS "]
[null,7," RED DE ALUMBRADO PUBLICO"]
[null,null,"SUMINISTRO DE COLUMNAS"]
[null,{"$f":"+B149+0.001","v":7.0010000000000003},"Suministro de poste de madera tratada de 7.5 m homologado por UTE","un",5,null,{"$f":"+F151*E151","v":0},null,{"$f":"+H151*E151","v":0}]
[null,{"$f":"+B151+0.001","v":7.0020000000000007},"Suministro de columna de hormigón de 7.5 m / 150 kgf homologada por UTE","un",40,null,{"$f":"+F152*E152","v":0},null,{"$f":"+H152*E152","v":0}]
[null,null,"SUMINISTRO DE CABLES"]
[null,{"$f":"+B152+0.001","v":7.003000000000001},"Suministro de conductor pre-ensamblado 3x16 mm2 Al + 54,6 tipo RZ-0.6-1KV  ","m",1900,null,0,null,0]
[null,{"$f":"+B154+0.001","v":7.0040000000000013},"Suministro de conductor 2x1,5 Cu/PVC","m",96,null,0,null,0]
[null,null,"TENDIDO DE CABLES (AÉREO)"]
[null,{"$f":"+B155+0.001","v":7.0050000000000017},"Accesorios de amarre y suspensión y derivaciones","ud",48,null,0,null,0]
[null,null,"MONTAJE"]
[null,{"$f":"+B157+0.001","v":7.006000000000002},"Mano de obra desmontaje y retiro de columnas","ud",39,null,0,null,0]
[null,{"$f":"+B159+0.001","v":7.0070000000000023},"Instalación de postes y columnas","ud",44,null,0,null,0]
[null,{"$f":"+B160+0.001","v":7.0080000000000027},"Tendido de líneas","m",1189,null,0,null,0]
[null,{"$f":"+B161+0.001","v":7.009000000000003},"Materiales montaje, tendido","ud",66,null,0,null,0]
[null,{"$f":"+B162+0.001","v":7.0100000000000033},"Disponibilidad de equipos","días",60,null,0,null,0]
[null,null,"SUMINISTRO DE LUMINARIAS (incluye brazos) "]
[null,{"$f":"+B163+0.001","v":7.0110000000000037},"Suministro de protecciones para luminarias - caja estanca + interruptor","un",84,null,0,null,0]
[null,{"$f":"+B165+0.001","v":7.012000000000004},"Suministro de Luminarias LED viales de  50 W","un",84,null,0,null,0]
[null,{"$f":"+B166+0.001","v":7.0130000000000043},"Suministro Reflector LED 240 W","un",20,null,0,null,0]
[null,{"$f":"+B167+0.001","v":7.0140000000000047},"Suministro Farola LED 20 W","un",16,null,0,null,0]
[null,null,"TABLERO DE ILUMINACIÓN"]
[null,{"$f":"+B168+0.001","v":7.015000000000005},"Tablero de iluminación","un",1,null,0,null,0]
[]
[null,null,"SUBTOTAL",null,null,null,{"$f":"SUM(G150:G171)","v":0},null,{"$f":"SUM(I150:I171)","v":0}]
[null,8,"ELÉCTRICA POZO DE BOMBEO"]
[null,null,"MEDIDORES DE UTE"]
[null,{"$f":"+B173+0.001","v":8.0009999999999994},"Trámite de nuevo servicio UTE y suministro y montaje de caja para medidores","gl",1,null,{"$f":"+F175*E175","v":0},null,{"$f":"+H175*E175","v":0}]
[null,{"$f":"+B175+0.001","v":8.0019999999999989},"SUMINISTRO Y MONTAJE DE TABLERO DE POTENCIA "]
[null,{"$f":"+B176+0.001","v":8.0029999999999983},"Centro de Distribución de Potencia CDP","u",1,null,{"$f":"+F177*E177","v":0},null,{"$f":"+H177*E177","v":0}]
[null,8.0039999999999978,"Tablero de CCTV TCCTV","u",1,null,0,null,0]
[null,8.0049999999999972,"Tablero de control de acceso TCA","u",1,null,0,null,0]
[null,8.0059999999999967,"Tablero de alarma de intrusos  TAI","u",1,null,0,null,0]
[null,8.0069999999999961,"Suministro, tendido y conexionado de cables  de potencia"]
[null,8.0079999999999956,"Cable de 3x35+25T  alimentación UTE","m",10,null,0,null,0]
[null,8.008999999999995,"Cable de 3x35+25T BLINDADO - alimentación Bombas","m",50,null,0,null,0]
[null,8.0099999999999945,"Cable de 2x2,5","m",20,null,0,null,0]
[null,8.0109999999999939,"Cable de 2x1,5","m",100,null,0,null,0]
[null,8.0119999999999933,"Suministro y montaje de canalizaciones  aparentes de potencia y control (escalerillas, ductos, caños, etc.)",null,0,null,0,null,0]
[null,8.0129999999999928,"Caño de acero galvanizado de 1 1/2”. Incluye soportes, codos, etc.","m",20,null,0,null,0]
[null,8.0139999999999922,"Suministro y montaje de canalizaciones subterráneas de potencia y control"]
[null,8.0149999999999917,"Caño de PVC 110 mm","m",30,null,0,null,0]
[null,8.0159999999999911,"Cámaras de 0,60x0,60 m","u",2,null,0,null,0]
[null,8.0169999999999906,"Cámaras de 0,40x0,40 m","u",3,null,0,null,0]
[null,8.01799999999999,"Cámaras de 0,20x0,20 m","u",1,null,0,null,0]
[null,8.0189999999999895,"Suministro, tendido y conexionado de cables de control, y botoneras locales",null,0,null,0,null,0]
[null,8.0199999999999889,"Cables de control de 5x1,5 mm2","m",30,null,0,null,0]
[null,8.0209999999999884,"PAT y protección contradescargas atmosféricas",null,0,null,0,null,0]
[null,8.0219999999999878,"Columna, toma de tierra, captor, barras de tierra , soldadura, conductor de bajada","gl",1,null,0,null,0]
[null,8.0229999999999873,"Instalación de iluminación y servicios"]
[null,8.0239999999999867,"Luminaria vial LED 50 W IP65 + brazo","u",1,null,0,null,0]
[null,8.0249999999999861,"Tomacorrientes tipo schuko","u",1,null,0,null,0]
[null,8.0259999999999856,"Tomacorrientes tipo 3 en línea","u",1,null,0,null,0]
[null,8.026999999999985,"Tomacorrientes trifásico tipo industrial 16 A","u",1,null,0,null,0]
[null,8.0279999999999845,"Generales de Eléctrica"]
[null,8.0289999999999839,"Montaje","gl",1,null,0,null,0]
[null,8.0299999999999834,"Pruebas y puesta en servicio","gl",1,null,0,null,0]
[null,8.0309999999999828,"Proyecto constructivo y planos según obra","gl",1,null,0,null,0]
[null,null,"CONTROL E INSTRUMENTACION"]
[null,{"$f":"+B205+0.001","v":8.0319999999999823},"Suministro, montaje y conexionado de Tableros de Control   (incluye UCL)","u",1,null,0,null,0]
[null,8.0329999999999817,"Suministro y montaje de UPS de 4 kVA para Tablero de Control ","u",1,null,0,null,0]
[null,8.0339999999999812,"Programación de UCL/PLC","u",1,null,0,null,0]
[null,8.0349999999999806,"Suministro, montaje y conexionado de instrumentos"]
[null,8.03599999999998,"Interruptor de nivel tipo boya","u",3,null,0,null,0]
[null,8.0369999999999795,"Interruptor de nivel tipo ultrasonido","u",2,null,0,null,0]
[null,8.0379999999999789,"Transmisor e indicador de caudal","u",1,null,0,null,0]
[null,8.0389999999999784,"Transmisor de presión","u",1,null,0,null,0]
[null,8.0399999999999778,"Transmisor de presión diferencial","u",1,null,0,null,0]
[null,8.0409999999999773,"Suministro y montaje CCTV, control de acceso, alarma de intrusos y alarma de incendio",null,0,null,0,null,0]
[null,8.0419999999999767,"Cámara de video vigilancia con infrarrojo IP65 apto para exterior y resistentes a H2S","u",2,null,0,null,0]
[null,8.0429999999999762,"Barreras ópticas, tx  y rx","u",4,null,0,null,0]
[null,8.0439999999999756,"Cerradura eléctrica, lector RFID","u",1,null,0,null,0]
[]
[null,null,"SUBTOTAL",null,null,null,{"$f":"SUM(G174:G220)","v":0},null,{"$f":"SUM(I174:I220)","v":0}]
[]
[null,10,"ACONDICIONAMIENTO PREDIOS PARA VIVIENDAS"]
[null,{"$f":"+B223+0.001","v":10.000999999999999},"Demolición viviendas a realojar con retiro de escombros","un",30,null,{"$f":"+F224*E224","v":0},null,{"$f":"+H224*E224","v":0}]
[null,{"$f":"+B224+0.001","v":10.001999999999999},"Realojos transitorios - Costo mensual para un total de 20 viviendas (15 viv de 2dorm, 3 viv 3dorm, 2 viv 4dorm)","mensual /viv.",380,null,0,null,0]
[null,null,"SUBTOTAL ",null,null,null,{"$f":"SUM(G224:G225)","v":0},null,{"$f":"SUM(I224:I225)","v":0}]
[]
[null,11,"CANASTA DE MATERIALES PARA SERVICIOS HIGIÉNICOS"]
[null,"Item","Rubro","UNIDAD ",null,"UNITARIO ","SUBTOTAL"]
[null,{"$f":"+B228+0.001","v":11.000999999999999},"Cemento portland 25 kilos","bolsa 25kg",21,null,{"$f":"+F230*E230","v":0}]
[null,{"$f":"+B230+0.001","v":11.001999999999999},"Arena gruesa","m3",2,null,{"$f":"+F231*E231","v":0}]
[null,{"$f":"+B231+0.001","v":11.002999999999998},"Arena fina","m3",4,null,0]
[null,11.003999999999998,"Pedregullo","m3",1,null,0]
[null,11.004999999999997,"Mezcla gruesa","m3",0.5,null,0]
[null,11.005999999999997,"Hidrófugo","lt",12,null,0]
[null,11.006999999999996,"Madera encofrado","un",12,null,0]
[null,11.007999999999996,"Hierros Ø 6 L = 6m","un",20,null,0]
[null,11.008999999999995,"Hierros Ø 8 L = 6m","un",8,null,0]
[null,11.009999999999994,"Hierros Ø 10 L = 6m","un",4,null,0]
[null,11.010999999999994,"Alambre","kg",5,null,0]
[null,11.011999999999993,"Clavos 2,5\"","kg",2,null,0]
[null,11.012999999999993,"Clavos 1,5\"","kg",3,null,0]
[null,11.013999999999992,"Bloques de hormigón vibrado 12 x 19 x 39","u",220,null,0]
[null,11.014999999999992,"Bloque U de hormigón vibrado 12 x 19 x 39","u",35,null,0]
[null,11.015999999999991,"Bindafix"," 25kg",4,null,0]
[null,11.016999999999991,"Pastina","kg",10,null,0]
[null,11.01799999999999,"Baldosas paredes","m2",12,null,0]
[null,11.018999999999989,"Baldosa cerámica piso","m2",3.5,null,0]
[null,11.019999999999989,"Caño Pvc 110","ml",1.5,null,0]
[null,11.020999999999988,"Caño Pvc 63","ml",0.5,null,0]
[null,11.021999999999988,"Caño Pvc 40","ml",3,null,0]
[null,11.022999999999987,"Caja rejilla ducha en pvc","u",1,null,0]
[null,11.023999999999987,"Caja sifonada grande pvc; abierta, salida 63","u",1,null,0]
[null,11.024999999999986,"Reducción Ø 50-40 mm","u",1,null,0]
[null,11.025999999999986,"Codos ǿ 40 mm","u",6,null,0]
[null,11.026999999999985,"Codos ǿ 110 mm, pvc salida inodoro","u",1,null,0]
[null,{"$f":"+B256+0.001","v":11.027999999999984},"Codos ǿ 110 mm, pvc","u",1,null,0]
[null,11.028999999999984,"Ramal y  ǿ 110 a 63 mm","u",1,null,0]
[null,11.029999999999983,"Pegamento para pvc","u",1,null,0]
[null,11.030999999999983,"Sombrerete ǿ 110 ","u",1,null,0]
[null,{"$f":"+B260+0.001","v":11.031999999999982},"Caño termofusión aprobado Pn 20 L 4mts","u",5,null,0]
[null,11.032999999999982,"Codo recto termofusión 20mm","u",12,null,0]
[null,11.033999999999981,"Codo con inserto macho termofusión 20mm","u",6,null,0]
[null,11.034999999999981,"Codo con inserto hembra termofusión 20mm","u",1,null,0]
[null,11.03599999999998,"T termofusión 20mm","u",6,null,0]
[null,11.036999999999979,"T con inserto termofusión 20mm","u",1,null,0]
[null,11.037999999999979,"Cupla termofusión 20mm","u",4,null,0]
[null,11.038999999999978,"Cupla con inserto termofusión 20mm","u",1,null,0]
[null,11.039999999999978,"Llave De Paso Embutir Termofusión Homologada 20 Mm","u",1,null,{"$f":"+F269*E269","v":0}]
[null,11.040999999999977,"Desvío termofusión 20mm HH","u",3,null,0]
[null,11.041999999999977,"Puente Unión / Codo Doble Termofusión 20 Mm - Largo 15 Cm","u",1,null,0]
[null,11.042999999999976,"Puente Unión / Codo Doble Termofusión 20 Mm - Largo 20 Cm","u",1,null,0]
[null,11.043999999999976,"Teflón","u",1,null,0]
[null,11.044999999999975,"Espiga Macho Rebose de 1/2\" Plastiducto a 20mm","u",1,null,0]
[null,11.045999999999975,"Camara de inspeccion  base prefabricada","u",1,null,0]
[null,11.046999999999974,"Marco de hormigón con tapa y contratapa 60 x 60 cm","u",1,null,0]
[null,11.047999999999973,"Ladrillode campo","u",90,null,0]
[null,11.048999999999973,"Inodoro común","u",1,null,0]
[null,11.049999999999972,"Lavatorio con pie","u",1,null,0]
[null,11.050999999999972,"Accesorios: 1 percha, 1 portarrollos, 1 jabonera con agarradera","gl",1,null,0]
[null,11.051999999999971,"Cisterna exterior en pvc con caño bajada","u",1,null,0]
[null,11.052999999999971,"Juego de grifería (lavatorio y ducha)","u",1,null,0]
[null,11.05399999999997,"Válvula esférica Ø 13","u",1,null,0]
[null,11.05499999999997,"Sifon para lavatorio","u",1,null,0]
[null,11.055999999999969,"Colilla HH de 0,4","u",5,null,0]
[null,11.056999999999968,"Puerta 0,75 x 2,05 m interior de madera tipo bastidor","u",1,null,0]
[null,11.057999999999968,"Ventana aluminio 0,40 x 0,60 m corrediza","u",1,null,0]
[null,11.058999999999967,"Pintura pared","lt",4,null,0]
[null,11.059999999999967,"Pintura aberturas  esmalte","lt",1,null,0]
[null,11.060999999999966,"Puintura exterior impermeabilizante","lt",20,null,0]
[null,11.061999999999966,"Panel poliuretano alma 2cms (40kg/m³) L=3,0m x 1,08m. Accesorios: Babeta 3,0m Frontalín 6m","u",3,null,0]
[null,11.062999999999965,"Tirante pino CCA 4x3\" L = 3,30m cepillado","u",2,null,0]
[null,11.063999999999965,"Tirante pino CCA 4x3\" L = 4,50m cepillado","u",2,null,0]
[null,11.064999999999964,"Tirante pino CCA 6x3\" L = 3,30m cepillado","u",2,null,0]
[null,{"$f":"+B294+0.001","v":11.065999999999963},"Tirante pino CCA 6x3\" L = 4,50m cepillado","u",2,null,{"$f":"+F295*E295","v":0}]
[null,11.066999999999963,"Caño tubular rectangular 40x80x2,8mm x 6m","u",1,null,0]
[null,11.067999999999962,"Tirantillos de madera 2\"x1\"","ml",15,null,0]
[null,11.068999999999962,"Cajas de pvc eléctrica","u",3,null,0]
[null,11.069999999999961,"Caño corrugado","ml",10,null,0]
[null,11.070999999999961,"Cable 1 x 1 + tierra","ml",20,null,0]
[null,11.07199999999996,"Interruptor mono c/plaqueta","u",1,null,0]
[null,11.07299999999996,"Tomacorriente c/interruptor mono","u",1,null,0]
[null,11.073999999999959,"Tomacorriente con plaqueta","u",1,null,0]
[null,11.074999999999958,"Caja brazo + portalamparas.","u",1,null,0]
[null,11.075999999999958,"Llave térmica","u",1,null,0]
[null,null,"SUBTOTAL",null,null,null,{"$f":"SUM(G230:G291)","v":0}]
[null,null,"SUBTOTAL CANASTAS SSHH",null,28,null,{"$f":"+E307*G306","v":0}]
[]
[null,12,"CANASTA DE MATERIALES PARA CONEXIÓN CÁMARA 1"]
[null,"Item","Rubro","UNIDAD ",null,"UNITARIO ","SUBTOTAL"]
[null,{"$f":"B309+0.001","v":12.000999999999999},"Caño PVC 110","m",9,null,{"$f":"+F311*E311","v":0}]
[null,{"$f":"+B311+0.001","v":12.001999999999999},"Interceptor de grasa habilitado","u",1,null,{"$f":"+F312*E312","v":0}]
[null,{"$f":"+B312+0.001","v":12.002999999999998},"Caja sifonada PVC abierta","u",1,null,0]
[null,12.003999999999998,"Ramal Y 110/110","u",2,null,0]
[null,12.004999999999997,"Codo 110 recto","u",1,null,0]
[null,12.005999999999997,"Abrazadera para caño 110mm","u",1,null,0]
[null,12.006999999999996,"Caño PVC 63","u",1,null,0]
[null,12.007999999999996,"Caño PVC 50","u",1,null,0]
[null,12.008999999999995,"Caño PVC 40","u",1,null,0]
[null,12.009999999999994,"Codo 40 recto","u",1,null,0]
[null,12.010999999999994,"codo 50 recto","u",1,null,0]
[null,12.011999999999993,"Codo 50 45°","u",1,null,0]
[null,12.012999999999993,"Codo 40 45º","u",1,null,0]
[null,12.013999999999992,"Te pvc 50","u",1,null,0]
[null,12.014999999999992,"Sombrerete pvc 100mm","u",1,null,0]
[null,12.015999999999991,"Fondo Cámara Prefabricada 60 x 60 cm","u",1,null,0]
[null,12.016999999999991,"Marco de hormigón con tapa y contratapa 60 x 60 cm","u",1,null,0]
[null,12.01799999999999,"Cubo 60x60 prefabricada","u",1,null,0]
[null,12.018999999999989,"Ladrillos cámara","u",50,null,0]
[null,12.019999999999989,"Pileta de patio de hormigón con tapa 20 x 20 cm","u",1,null,0]
[null,12.020999999999988,"BDT ","u",1,null,0]
[null,12.021999999999988,"Pegamento para PVC (lata)","u",1,null,0]
[null,12.022999999999987,"Cemento portland","bolsas",3,null,0]
[null,12.023999999999987,"Sikaflex","u",1,null,0]
[null,12.024999999999986,"Espuma de Poliuretano","u",1,null,0]
[null,12.025999999999986,"Teflón","u",1,null,0]
[null,12.026999999999985,"Arena terciada ","m3",1,null,0]
[null,12.027999999999984,"Arena gruesa","m3",1,null,0]
[null,12.028999999999984,"Balasto","m3",1,null,{"$f":"+F339*E339","v":0}]
[null,12.029999999999983,"Cámara prefabricada PVC 60x60cm x 1,0m","u",1,null,0]
[null,12.030999999999983,"Cámara prefabricada PVC 60x60 x 40cm ","u",1,null,0]
[{"$nulls":6},{"$f":"+SUM(G311:G339)","v":0}]
[null,null,"SUBTOTAL CANASTAS CONEXIÓN CÁMARA 1",null,98,null,{"$f":"+G342*E343","v":0}]
[]
[null,13,"CANASTA DE MATERIALES PARA MEJORA DE VIVIENDAS \n- MÓDULO AMPLIACIÓN-"]
[null,"Item","Rubro","UNIDAD ",null,"UNITARIO ","SUBTOTAL"]
[null,{"$f":"+B345+0.001","v":13.000999999999999},"Balasto","m3",9.5]
[null,13002,"Arena gruesa","m3",9]
[null,13003,"Portland","bolsas",5]
[null,13004,"Pedregullo","m3",5]
[null,13005,"Alambres","kg",9]
[null,13006,"Clavos 1,5\"","kg",9]
[null,13007,"malla electrosoldada","m2",12]
[null,13008,"hierro Ø 6 =6ml","uni",30]
[null,13009,"hierro Ø 8 =6ml","uni",45]
[null,13010,"viga metalica de 10","ml",7]
[null,13011,"viga metalica de 15","ml",5]
[null,13012,"mezcla","m3",1.5]
[null,13013,"Bloques de hormigón vibrado 12 x 19 x 39","unid",715]
[null,13014,"Hidrófugo","lts",29]
[null,13015,"Chapa tipo sinusoidal (0,7m ancho útil cal 24)","unid.",6]
[null,13017,"aberturas de aluminio A1","unid.",1]
[null,13018,"puertas interiores C2","unid.",1]
[null,13019,"Cajas de pvc eléctrica","u",5]
[null,13020,"Caño corrugado 25mm","ml",10]
[null,13021,"Cable 1 x 1 + tierra","ml",20]
[null,13022,"Interruptor mono c/plaqueta","u",1]
[null,13023,"Tomacorriente c/interruptor mono","u",2]
[null,13024,"Tomacorriente con plaqueta","u",1]
[null,13025,"Caja brazo + portalamparas.","u",1]
[null,13026,"Llave térmica","u",2]
[null,13027,"Protector maderas interior 1lt","u",1]
[null,null,"SUBTOTAL ",null,null,null,{"$f":"SUM(G347:G372)","v":0}]
[null,null,"SUBTOTAL CANASTAS PARA MEJORA DE VIVIENDAS",null,7,null,{"$f":"+G373*E374","v":0}]
[]
[null,14,"CANASTA DE MATERIALES PARA MEJORA DE VIVIENDAS \n-CONSOLIDACIÓN-"]
[null,"Item","Rubro","UNIDAD ",null,"UNITARIO ","SUBTOTAL"]
[null,{"$f":"+B376+0.001","v":14.000999999999999},"Arena gruesa","m3",19]
[null,{"$f":"+B378+0.001","v":14.001999999999999},"Portland","sacos",8]
[null,{"$f":"+B379+0.001","v":14.002999999999998},"Pedregullo","m3",3]
[null,14.003999999999998,"Alambre","kg",5]
[null,14.004999999999997,"Clavos 1,5\"","kg",5]
[null,14.005999999999997,"hierro Ø 10 =6ml","uni",82]
[null,14.006999999999996,"malla electrosoldada","m2",230]
[null,14.007999999999996,"hierro Ø 6 =6ml","uni ",9]
[null,14.008999999999995,"Baldosa cerámica piso","m2",11]
[null,14.009999999999994,"binda","kg",45]
[null,14.010999999999994,"pastina","kg",3]
[null,14.011999999999993,"Hidrófugo","lts",114]
[null,14.012999999999993,"Chapa tipo sinusoidal (0,7m ancho útil cal 24)","u",6]
[null,14.013999999999992,"Cielorraso poliestireno expandido","m2",156.13399999999999]
[null,14.014999999999992,"Puerta de Hierro H1","u",4]
[null,14.015999999999991,"Puertas de Madera C1","u",2.5]
[null,14.016999999999991,"Aberturas de Aluminio A2","u",10]
[null,14.01799999999999,"Esmalte convertido 3 en 1 1lt","u",1]
[null,14.018999999999989,"Mesada Pileta y Cocina  (incluye inst. sanitaria pvc 50mm y grifería)","gl",1.5]
[null,null,"SUBTOTAL ",null,null,null,{"$f":"SUM(G378:G396)","v":0}]
[null,null,"SUBTOTAL CANASTAS PARA MEJORA DE VIVIENDAS",null,1,null,{"$f":"G397*E398","v":0}]
[]
[null,15,"COSTOS INDIRECTOS"]
[null,"Item","Rubro","UNIDAD ",null,"UNITARIO ","SUBTOTAL"]
[null,{"$f":"+B400+0.001","v":15.000999999999999},"Jefatura de Obra ","gl",1,null,{"$f":"+F402*E402","v":0}]
[null,{"$f":"+B402+0.001","v":15.001999999999999},"Ingeniero Agrimensor o Topógrafo ","gl",1,null,0]
[null,15.002999999999998,"Capataz general de obra ","gl",1,null,0,null,{"$f":"+H404*E404","v":0}]
[null,15.003999999999998,"Replanteo general de obra ","gl",1,null,0,null,0]
[null,15.004999999999997,"Carga y descarga de materiales ","gl",1,null,0,null,0]
[null,15.005999999999997,"Fletes ","gl",1,null,0,null,0]
[null,15.006999999999996,"Seguridad de obra","gl",1,null,0,null,0]
[null,15.007999999999996,"Consumos agua potable y energía eléctrica","gl",1,null,0,null,{"$f":"+H409*E409","v":0}]
[null,15.008999999999995,"Planos conforme a obra ","gl",1,null,0,null,{"$f":"+H410*E410","v":0}]
[null,null,"SUBTOTAL ",null,null,null,{"$f":"SUM(G402:G410)","v":0},null,{"$f":"SUM(I402:I410)","v":0}]
[null,null,"SUBTOTAL COSTOS INDIRECTOS",null,null,null,{"$f":"+G411","v":0},null,{"$f":"+I411","v":0}]
[]
[null,null,"TOTAL INVERSIÓN DIRECTA"]
[]
[]
[null,"INVERSIÓN COMPLEMENTARIA"]
[]
[null,16,"RED VIAL"]
[null,null,"RUBROS GLOBALES"]
[null,{"$f":"+B419+0.001","v":16.001000000000001},"Movilización","gl",1,null,{"$f":"+E421*F421","v":0},null,{"$f":"+H421*E421","v":0}]
[null,{"$f":"+B421+0.001","v":16.002000000000002},"Recuperación Ambiental","gl",1,null,{"$f":"+E422*F422","v":0},null,{"$f":"+H422*E422","v":0}]
[null,{"$f":"+B422+0.001","v":16.003000000000004},"Señalización de Obra","gl",1,null,0,null,{"$f":"+H423*E423","v":0}]
[null,16.004000000000005,"Desvíos de Tránsito","gl",1,null,0,null,{"$f":"+H424*E424","v":0}]
[null,16.005000000000006,"Ayuda para adecuación de servicios públicos","gl",1,null,0,null,0]
[null,null,"MOVIMIENTO DE SUELOS",null,null,null,0,null,0]
[null,{"$f":"+B425+0.001","v":16.006000000000007},"Excavación No Clasificada","m³",1759.8841523350247,null,0,null,0]
[null,{"$f":"+B427+0.001","v":16.007000000000009},"Excavación No Clasificada A Depósito","m³",8655.1687667281167,null,0,null,0]
[null,16.00800000000001,"Excavación No Clasificada De Préstamo","m³",2066.0199238091886,null,0,null,0]
[null,16.009000000000011,"Sobretransporte de Suelos (Distancia Libre = 400 metros )","m³.Km",24159.456804202629,null,0,null,0]
[null,null,"PAVIMENTOS "]
[null,{"$f":"+B430+0.001","v":16.010000000000012},"Cemento Portland para Base Estabilizada con Cemento (Con Transporte)","Ton",29.595513241904442,null,0,null,0]
[null,{"$f":"+B432+0.001","v":16.011000000000013},"Base Granular con CBR > 60 % (Con Transporte)","m³",1918.7602770226235,null,0,null,0]
[null,16.012000000000015,"Base Granular Con CBR > 80 % (Con Transporte)","m³",1786.8190749917685,null,0,null,0]
[null,16.013000000000016,"Material de Base Estabilizado con Cemento Portland con Transporte","m³",295.95513241904445,null,0,null,0]
[null,16.014000000000017,"Cordón Cuneta de Hormigón Simple","M",899.46924338362442,null,0,null,0]
[null,16.015000000000018,"Demolición y Retiro de Pavimentos","M2",186.31350262631005,null,0,null,0]
[null,16.01600000000002,"Hormigón para veredas","m³",194.15893472249135,null,{"$f":"+E438*F438","v":0},null,{"$f":"+H438*E438","v":0}]
[null,null,"SUBTOTAL OBRA COMPLEMENTARIA_ RED VIAL",null,null,null,{"$f":"SUM(G420:G438)","v":0},null,{"$f":"SUM(I420:I438)","v":0}]
[]
[null,"INVERSION TOTAL - ETAPA 2"]
[null,"Item","Rubro",null,null,null,"SUBTOTAL ",null,"SUBT. LLSS "]
[]
[null,{"$f":"B8","v":1},"IMPLANTACIÓN",null,null,null,{"$f":"G11","v":0},null,{"$f":"I11","v":0}]
[null,{"$f":"B13","v":2},"RED VIAL",null,null,null,{"$f":"G33","v":0},null,{"$f":"I33","v":0}]
[null,{"$f":"B35","v":3},"RED DE DESAGÜES PLUVIALES",null,null,null,{"$f":"G85","v":0},null,{"$f":"I85","v":0}]
[null,{"$f":"B87","v":4},"RED DE SANEAMIENTO",null,null,null,{"$f":"G137","v":0},null,{"$f":"I137","v":0}]
[null,{"$f":"+B139","v":5},"RED DE AGUA POTABLE",null,null,null,{"$f":"+G147","v":0},null,{"$f":"+I147","v":0}]
[null,{"$f":"B149","v":7},"RED DE ALUMBRADO PÚBLICO",null,null,null,{"$f":"G172","v":0},null,{"$f":"I172","v":0}]
[null,{"$f":"+B173","v":8},"ELÉCTRICA POZO DE BOMBEO",null,null,null,{"$f":"+G221","v":0},null,{"$f":"+I221","v":0}]
[null,{"$f":"+B223","v":10},{"$f":"+C223","v":"ACONDICIONAMIENTO PREDIOS PARA VIVIENDAS"},null,null,null,{"$f":"+G226","v":0},null,{"$f":"+I226","v":0}]
[null,{"$f":"+B228","v":11},{"$f":"C228","v":"CANASTA DE MATERIALES PARA SERVICIOS HIGIÉNICOS"},null,null,null,{"$f":"G307","v":0},null,{"$f":"I307","v":0}]
[null,{"$f":"+B309","v":12},{"$f":"C309","v":"CANASTA DE MATERIALES PARA CONEXIÓN CÁMARA 1"},null,null,null,{"$f":"G343","v":0},null,{"$f":"I343","v":0}]
[null,{"$f":"+B345","v":13},"CANASTA DE MATERIALES PARA MEJORA DE VIVIENDA\n - MÓDULO AMPLIACIÓN-",null,null,null,{"$f":"+G374","v":0}]
[null,{"$f":"+B376","v":14},"CANASTA DE MATERIALES PARA MEJORA DE VIVIENDA\n- CONSOLIDACIÓN-",null,null,null,{"$f":"+G398","v":0}]
[null,{"$f":"+B400","v":15},{"$f":"+C400","v":"COSTOS INDIRECTOS"},null,null,null,{"$f":"+G412","v":0},null,{"$f":"+I412","v":0}]
[null,{"$f":"+B419","v":16},"INVERSIÓN COMPLEMENTARIA",null,null,null,{"$f":"+G439","v":0},null,{"$f":"+I439","v":0}]
[]
[]
[null,null,"SUBTOTAL INVERSION DIRECTA",null,null,null,{"$f":"SUM(G444:G456)","v":0},null,{"$f":"SUM(I444:I456)","v":0}]
[null,null,"SUBTOTAL INVERSION COMPLEMENTARIA",null,null,null,{"$f":"+G457","v":0},null,{"$f":"+I457","v":0}]
[]
[null,null,"SUB TOTAL INVERSIÓN DIRECTA + COMPLEMENTARIA",null,null,null,{"$f":"+G460+G461","v":0},null,{"$f":"+I460+I461","v":0}]
[null,null,"IVA",null,null,null,{"$f":"+G463*0.22","v":0}]
[null,null,"LEYES SOCIALES",null,null,null,{"$f":"+I463","v":0}]
[]
[null,null,"TOTAL INVERSIÓN",null,null,null,{"$f":"+G463+G464+G465","v":0}]