{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["236-264 E-7","FORMA E-7"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":4,"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":"236-264 E-7","index":0,"n_rows":263,"n_cols":9,"rows_kept":263,"cut":false,"hidden":true,"merged":[[2,5,5,8],[6,1,6,3],[6,5,10,5],[6,6,7,7],[6,8,10,8],[7,1,7,3],[8,1,10,1],[8,3,10,3],[8,6,10,6],[8,7,10,7]]}
[null,null,null,null,null,null,null,null,"Forma E-7"]
[null,null,null,"SECRETARIA DE COMUNICACIONES Y TRANSPORTES","LICITACIÓN NÚM:       ",null,"LO-009000999-YYY-2015"]
[null,null,null,"DIRECCION GENERAL DE CARRETERAS","TRABAJOS:","Modernización y Ampliación de la carretera Estación Don-Nogales, tramo: Magdalena de Kino-Nogales del km 236+000 al km 264+000 ambos cuerpos \"A y B\", en el Estado de Sonora."]
[null,null,null,"CENTRO SCT SONORA"]
[]
[]
[null,"O    B     R     A ",null,null,null,"CANTIDAD DE OBRA","PRECIO UNITARIO",null,"IMPORTE $"]
[null,"C   O   N   C   E   P   T   O"]
[null,"No.","ESPECIFICACIÓN","DESCRIPCIÓN","UNIDAD",null,"CON LETRA","CON NUMERO"]
[null,null,"GENERAL O"]
[null,null,"COMPLEMENTARIA"]
[null,null,"","TERRACERIAS N.CTR.CAR.1.01"]
[null,null,null,"DESMONTE"]
[null,1,"N.CTR.CAR.1.01.001/11","Desmonte por unidad de obra terminada P.U.O.T. (inciso 001.I)","ha",27]
[null,null,null,"CORTES"]
[null,{"$f":"IF(E16=\"\",\"\",COUNTA($E$14:E16))","v":2},"N.CTR.CAR.1.01.002/11","Despalmes, por unidad de obra terminada (inciso 002.I) :De cortes","m3",10281]
[null,{"$f":"IF(E17=\"\",\"\",COUNTA($E$14:E17))","v":3},"N.CTR.CAR.1.01.002/11","Despalmes, por unidad de obra terminada (inciso 002.I) :Para desplante de terraplen","m3",42046]
[null,{"$f":"IF(E18=\"\",\"\",COUNTA($E$14:E18))","v":""},null,"Excavaciones, por unidad de obra terminada (inciso 003.J):"]
[null,{"$f":"IF(E19=\"\",\"\",COUNTA($E$14:E19))","v":""},null,"En cortes y adicionales abajo de la subrasante:"]
[null,{"$f":"IF(E20=\"\",\"\",COUNTA($E$14:E20))","v":4},"N.CTR.CAR.1.01.003/11","Cuando el material se utilice para la formación de terraplenes.","m3",22299]
[null,{"$f":"IF(E21=\"\",\"\",COUNTA($E$14:E21))","v":5},"N.CTR.CAR.1.01.003/11","Cuando el material se desperdicie.","m3",56690]
[null,{"$f":"IF(E22=\"\",\"\",COUNTA($E$14:E22))","v":""},null,"En ampliación de cortes:"]
[null,{"$f":"IF(E23=\"\",\"\",COUNTA($E$14:E23))","v":6},"N.CTR.CAR.1.01.003/11","Cuando el material se utiliza para el arrope de taludes, P.U.O.T. (Inciso 003.J) (EP.01)","m3",34572]
[null,{"$f":"IF(E24=\"\",\"\",COUNTA($E$14:E24))","v":""},null,"Excavacion en cajas, P.U.O.T., en zonas inestables para desplante de terraplenes"]
[null,{"$f":"IF(E25=\"\",\"\",COUNTA($E$14:E25))","v":7},"N.CTR.CAR.1.01.003/11","Cuando el material se utilice para arrope de taludes.","m3",12713]
[null,{"$f":"IF(E26=\"\",\"\",COUNTA($E$14:E26))","v":""},null,"En  escalones de liga, Por Unidad de Obra Terminada (inciso 004.I)"]
[null,{"$f":"IF(E27=\"\",\"\",COUNTA($E$14:E27))","v":8},"N.CTR.CAR.1.01.004/11","Cuando el material se utilice para la formación de terraplenes, incluye acarreos. (E.P. 02)","m3",11057]
[null,{"$f":"IF(E28=\"\",\"\",COUNTA($E$14:E28))","v":""},null,"TERRAPLENES"]
[null,{"$f":"IF(E29=\"\",\"\",COUNTA($E$14:E29))","v":""},null,"Recompactación :"]
[null,{"$f":"IF(E30=\"\",\"\",COUNTA($E$14:E30))","v":""},null,"Escarificacion, acamellonado, tendido y compactado (inciso 009.J)"]
[null,{"$f":"IF(E31=\"\",\"\",COUNTA($E$14:E31))","v":9},"N.CTR.CAR.1.01.009/11","Para cien por ciento (100%) , para subrasante","m3",27263]
[null,{"$f":"IF(E32=\"\",\"\",COUNTA($E$14:E32))","v":""},null,"De la superficie descubierta al escarificar y acamellonar por alas la capa superior de las terracerias"]
[null,{"$f":"IF(E33=\"\",\"\",COUNTA($E$14:E33))","v":""},null,"subyacente o subrasante existente P.U.O.T (inciso 009.J)"]
[null,{"$f":"IF(E34=\"\",\"\",COUNTA($E$14:E34))","v":10},"N.CTR.CAR.1.01.009/11","Para noventa y cinco porciento (95%)","m3",2509]
[null,{"$f":"IF(E35=\"\",\"\",COUNTA($E$14:E35))","v":""},null,"Formación y compactación, por unidad de obra terminada (inciso 009.J) :"]
[null,{"$f":"IF(E36=\"\",\"\",COUNTA($E$14:E36))","v":""},null,"De terraplenes adicionados con sus cuñas de sobreancho :"]
[null,{"$f":"IF(E37=\"\",\"\",COUNTA($E$14:E37))","v":11},"N.CTR.CAR.1.01.009/11","Para noventa por ciento (90%) (EP-03)","m3",97345]
[null,{"$f":"IF(E38=\"\",\"\",COUNTA($E$14:E38))","v":12},"N.CTR.CAR.1.01.009/11","Para noventa y cinco por ciento (95%). (EP-03)","m3",125669]
[null,{"$f":"IF(E39=\"\",\"\",COUNTA($E$14:E39))","v":13},"N.CTR.CAR.1.01.009/11","Para cien por ciento (100%) en capa subrasante. (EP-04)","m3",163174]
[null,{"$f":"IF(E40=\"\",\"\",COUNTA($E$14:E40))","v":14},"N.CTR.CAR.1.01.009/11","Del relleno de las cajas en cortes, compactados al 95%","m3",8966]
[null,{"$f":"IF(E41=\"\",\"\",COUNTA($E$14:E41))","v":""},null,"Arrope de taludes de los terraplenes con el material obtenido de despalme y de Excavaciones"]
[null,{"$f":"IF(E42=\"\",\"\",COUNTA($E$14:E42))","v":15},"N.CTR.CAR.1.01.012/00","de cajas para desplante de terraplenes, por unidad de obra terminada (EP-05).","m3",34572]
[null,{"$f":"IF(E43=\"\",\"\",COUNTA($E$14:E43))","v":""}]
[null,{"$f":"IF(E44=\"\",\"\",COUNTA($E$14:E44))","v":""},null,"DRENAJE Y SUBDRENAJE    N.CTR.CAR.1.03."]
[null,{"$f":"IF(E45=\"\",\"\",COUNTA($E$14:E45))","v":""},null,"CANALES"]
[null,{"$f":"IF(E46=\"\",\"\",COUNTA($E$14:E46))","v":""},null,"Excavación para canales, por unidad de obra terminada (inciso 005.J) "]
[null,{"$f":"IF(E47=\"\",\"\",COUNTA($E$14:E47))","v":""},null,"Cualesquiera que sea su clasificacion y profundidad."]
[null,{"$f":"IF(E48=\"\",\"\",COUNTA($E$14:E48))","v":16},"N.CTR.CAR.1.01.005/11","De entrada y salida a obras de drenaje.","m3",707.4]
[null,{"$f":"IF(E49=\"\",\"\",COUNTA($E$14:E49))","v":""},null,"EXCAVACIÓN PARA ESTRUCTURAS"]
[null,{"$f":"IF(E50=\"\",\"\",COUNTA($E$14:E50))","v":""},null,"Excavado, por unidad de obra terminada,  "]
[null,{"$f":"IF(E51=\"\",\"\",COUNTA($E$14:E51))","v":17},"N.CTR.CAR.1.01.007/11","Cualesquiera que sea su clasificación y profundidad  (inciso 007.J)","m3",6952]
[null,{"$f":"IF(E52=\"\",\"\",COUNTA($E$14:E52))","v":""},null,"Extraccion de azolves en obras de drenaje,"]
[null,{"$f":"IF(E53=\"\",\"\",COUNTA($E$14:E53))","v":18},"N.CTR.CAR.1.01.005/11","Culesquiera que sean sus dimensiones y longitud P.U.O.T. (EP-06).(009.J)","m3",229.5]
[null,{"$f":"IF(E54=\"\",\"\",COUNTA($E$14:E54))","v":""},null,"RELLENOS"]
[null,{"$f":"IF(E55=\"\",\"\",COUNTA($E$14:E55))","v":""},null,"Rellenos al 95% (Inciso 011.J):"]
[null,{"$f":"IF(E56=\"\",\"\",COUNTA($E$14:E56))","v":19},"N.CTR.CAR.1.01.011/11","Para la protección de las obras de drenaje, por unidad de obra terminada ","m3",2917]
[null,{"$f":"IF(E57=\"\",\"\",COUNTA($E$14:E57))","v":""},null,"ZAMPEADOS"]
[null,{"$f":"IF(E58=\"\",\"\",COUNTA($E$14:E58))","v":""},null,"Zampeados a cualquier altura, por unidad de obra terminada. (inciso 002.J):"]
[null,{"$f":"IF(E59=\"\",\"\",COUNTA($E$14:E59))","v":20},"N.CTR.CAR.1.02.002/00","De concreto hidraulico simple de f´c= 150 kg/cm². ","m3",10.4]
[null,{"$f":"IF(E60=\"\",\"\",COUNTA($E$14:E60))","v":21},"N.CTR.CAR.1.02.002/00","De concreto hidraulico simple de f´c= 100 kg/cm². ","m3"]
[null,{"$f":"IF(E61=\"\",\"\",COUNTA($E$14:E61))","v":""},null,"CONCRETO HIDRÁULICO."]
[null,{"$f":"IF(E62=\"\",\"\",COUNTA($E$14:E62))","v":""},null,"Concreto hidráulico Simple, colado en seco por unidad de obra terminada. (inciso 003.J):"]
[null,{"$f":"IF(E63=\"\",\"\",COUNTA($E$14:E63))","v":22},"N.CTR.CAR.1.02.003/04","De f'c= 100 kg/cm²","m3",342.8]
[null,{"$f":"IF(E64=\"\",\"\",COUNTA($E$14:E64))","v":23},"N.CTR.CAR.1.02.003/04","De f'c= 150 kg/cm²","m3",2405.1]
[null,{"$f":"IF(E65=\"\",\"\",COUNTA($E$14:E65))","v":24},"N.CTR.CAR.1.02.003/04","De f'c= 200 kg/cm²","m3",1932.6]
[null,{"$f":"IF(E66=\"\",\"\",COUNTA($E$14:E66))","v":""},null,"Bordillo de concreto hidraulico (inciso 007.J) colados en el lugar:"]
[null,{"$f":"IF(E67=\"\",\"\",COUNTA($E$14:E67))","v":""},null,"de f´c = 150 kg/cm2, de 156 cm2 de sección ( bordillos de 16 cm base mayor"]
[null,{"$f":"IF(E68=\"\",\"\",COUNTA($E$14:E68))","v":25},"N.CTR.CAR.1.03.007/00","10 cm base menor y 12 cm de altura), con agregado de tamaño maximo de 19 mm (3/4\")P.U.O.T.(EP-07)","m",609]
[null,{"$f":"IF(E69=\"\",\"\",COUNTA($E$14:E69))","v":""},null,"Lavaderos  (inciso 006.J) de concreto hidraulico simple de f´c= 150 kg/cm2"]
[null,{"$f":"IF(E70=\"\",\"\",COUNTA($E$14:E70))","v":26},"N.CTR.CAR.1.03.006/00","con agregado de tamaño maximo de 38 mm ( 1 1/2\"), por unidad de obra terminada.(EP-08)","m3",66]
[null,{"$f":"IF(E71=\"\",\"\",COUNTA($E$14:E71))","v":""},null,"ACERO PARA CONCRETO  HIDRAULICO"]
[null,{"$f":"IF(E72=\"\",\"\",COUNTA($E$14:E72))","v":""},null,"Acero de refuerzo, por unidad de obra terminada ( inciso 004.J):"]
[null,{"$f":"IF(E73=\"\",\"\",COUNTA($E$14:E73))","v":27},"N.CTR.CAR.1.02.004/02","Varillas de limite elastico igual o mayor de 4,200 kg/cm²","kg",126416]
[null,{"$f":"IF(E74=\"\",\"\",COUNTA($E$14:E74))","v":""},null,"DEMOLICIONES"]
[null,{"$f":"IF(E75=\"\",\"\",COUNTA($E$14:E75))","v":28},"N.CTR.CAR.1.02.013/00","Demoliciones de mamposterias, por Unidad de obra terminada ( inciso 013.J) (EP-09)","m3",996]
[null,{"$f":"IF(E76=\"\",\"\",COUNTA($E$14:E76))","v":29},"N.CTR.CAR.1.02.013/00","Demoliciones de concreto hidraulico simple o reforzado, por Unidad de obra terminada ( inciso 013.J)(EP-10)","m3",340.5]
[null,{"$f":"IF(E77=\"\",\"\",COUNTA($E$14:E77))","v":""},null,"TRABAJOS DIVERSOS"]
[null,{"$f":"IF(E78=\"\",\"\",COUNTA($E$14:E78))","v":""},null,"Revestimiento de cunetas , por Unidad de obra terminada (inciso 003.J)"]
[null,{"$f":"IF(E79=\"\",\"\",COUNTA($E$14:E79))","v":30},"N.CTR.CAR.1.03.003/00","Con concreto hidráulico simple de f'c=150 kg/cm2 con agregado de tamaño máximo de 38 mm (1 1/2\") (EP-11)","m3",982.27]
[null,{"$f":"IF(E80=\"\",\"\",COUNTA($E$14:E80))","v":31},"N.CTR.CAR.1.07.015/00","Cerco con poste de concreto y 4 (cuatro) hilos de alambre de puas calibre No.12 P.U.O.T. (EP-12), P.U.O.T","ml",29220]
[null,{"$f":"IF(E81=\"\",\"\",COUNTA($E$14:E81))","v":""},null,"Defensa metalica de tres crestas tipo AASHTO M-180,"]
[null,{"$f":"IF(E82=\"\",\"\",COUNTA($E$14:E82))","v":32},"N.CTR.CAR.1.07.009/00","incluyendo sus accesorios, por unidad de obra terminada P.U.O.T (EP-13)","ml",1724]
[null,{"$f":"IF(E83=\"\",\"\",COUNTA($E$14:E83))","v":33},"N.CTR.CAR.1.02.013/00","Desmantelamiento de defensa metalica de dos crestas,  P.U.O.T (E.P.14)","ml",1250]
[null,{"$f":"IF(E84=\"\",\"\",COUNTA($E$14:E84))","v":34},"N.CTR.CAR.1.02.013/00","Desmantelamiento y Rehubicacion de defensa metalica de tres crestas,  P.U.O.T (E.P.14)","ml",2400]
[null,{"$f":"IF(E85=\"\",\"\",COUNTA($E$14:E85))","v":35},"N.CTR.CAR.1.07.009/00","Terminal de Impacto para barrera, P.U.O.T","pza",9]
[null,{"$f":"IF(E86=\"\",\"\",COUNTA($E$14:E86))","v":36},"N.CTR.CAR.1.02.013/00","Desmantelamiento de cercado de derecho de via, P.U.O.T (E.P.15)","ml",32020]
[null,{"$f":"IF(E87=\"\",\"\",COUNTA($E$14:E87))","v":37},"N.CTR.CAR.1.02.013/00","Desmantelamiento de defensa metalica de dos crestas,  P.U.O.T (E.P.14)","ml",0]
[null,{"$f":"IF(E88=\"\",\"\",COUNTA($E$14:E88))","v":38},"N.CTR.CAR.1.02.013/00","Desmantelamiento y Rehubicacion de defensa metalica de tres crestas,  P.U.O.T (E.P.14)","ml",0]
[null,{"$f":"IF(E89=\"\",\"\",COUNTA($E$14:E89))","v":39},"N.CTR.CAR.1.02.010/00","Concreto hidraulico de f'c = 250 kg/cm² en Banquetas, P.U.O.T. (E.P.16)","m3",378]
[null,{"$f":"IF(E90=\"\",\"\",COUNTA($E$14:E90))","v":40},"N.CTR.CAR.1.02.010/00","Concreto hidraulico de f'c = 250 kg/cm² en Guarniciones, P.U.O.T. (E.P.17)","m3",378]
[null,{"$f":"IF(E91=\"\",\"\",COUNTA($E$14:E91))","v":41},"N.CTR.CAR.1.07.010/00","Barrera Tipo New Jersey, P.U.O.T","pza",867]
[null,{"$f":"IF(E92=\"\",\"\",COUNTA($E$14:E92))","v":42},null,"Suministro y colocacion de caseta de espera en paradero de autobuses, P.U.O.T. (E.P. 18)","pza",2]
[null,{"$f":"IF(E93=\"\",\"\",COUNTA($E$14:E93))","v":""},null,"PAVIMENTOS N.CTR.CAR.1.04"]
[null,{"$f":"IF(E94=\"\",\"\",COUNTA($E$14:E94))","v":""},null,"Bases, Por Unidad de Obra Terminada "]
[null,{"$f":"IF(E95=\"\",\"\",COUNTA($E$14:E95))","v":""},null,"Base modificada con cemento Portland con espesor indicado en el  proyecto, con resistencia a la compresion simple"]
[null,{"$f":"IF(E96=\"\",\"\",COUNTA($E$14:E96))","v":43},"N.CTR.CAR.1.04.002/11","(f´c) de 25 kg/cm2, obtenida a los 28 dias de edad, compactada al 100%, P.U.O.T. (E.P. 19) (inciso 003.J)","m3",132693]
[null,{"$f":"IF(E97=\"\",\"\",COUNTA($E$14:E97))","v":""},null,"Cemento Portland  Compuesto Puzolanico (CPC o CPP) para modificar base (nueva), en una proporcion aproximada "]
[null,{"$f":"IF(E98=\"\",\"\",COUNTA($E$14:E98))","v":44},"N.CMT.2.02.001/02","de 6% con respecto al PVSM del material petreo. P.U.O.T. (E.P. 20)","kg",17515476]
[null,{"$f":"IF(E99=\"\",\"\",COUNTA($E$14:E99))","v":""},null,"MATERIALES ASFALTICOS"]
[null,{"$f":"IF(E100=\"\",\"\",COUNTA($E$14:E100))","v":""},null,"Materiales asfálticos, por unidad de obra terminada:"]
[null,{"$f":"IF(E101=\"\",\"\",COUNTA($E$14:E101))","v":""},null,"Emulsiones asfálticas,Empleadas en riegos:"]
[null,{"$f":"IF(E102=\"\",\"\",COUNTA($E$14:E102))","v":45},"N.CTR.CAR.1.01.012/00","Emulsión asfaltica ECI-60 en riego de impregnación en la base P.U.O.T. (inciso 004.J)","lt",1075041]
[null,{"$f":"IF(E103=\"\",\"\",COUNTA($E$14:E103))","v":""},null,"Remate de losas de pavimento de concreto hidraulico con material producto de los despalmes y desmontes"]
[null,{"$f":"IF(E104=\"\",\"\",COUNTA($E$14:E104))","v":46},"N.CTR.CAR.1.04.003/14","compactado al 90% P.U.O.T. (E.P. 21)","m3",570]
[null,{"$f":"IF(E105=\"\",\"\",COUNTA($E$14:E105))","v":""},null,"CARPETAS DE CONCRETO HIDRAULICO"]
[null,{"$f":"IF(E106=\"\",\"\",COUNTA($E$14:E106))","v":""},null,"Losa de concreto hidraulico con modulo de ruptura a la flexion de 48 kg/cm2, obtenido a los 28 dias de edad, P.U.O.T. "]
[null,{"$f":"IF(E107=\"\",\"\",COUNTA($E$14:E107))","v":47},"N.CTR.CAR.1.04.009/06","28 dias de edad, P.U.O.T.  (inciso 009.J) y (E.P. 22)","m3",192744]
[null,{"$f":"IF(E108=\"\",\"\",COUNTA($E$14:E108))","v":""},null,"SEÑALAMIENTO N.CTR.CAR.1.07"]
[null,{"$f":"IF(E109=\"\",\"\",COUNTA($E$14:E109))","v":""},null,"Recubrimiento con pintura termoplástica con microsesferas de vidrio"]
[null,{"$f":"IF(E110=\"\",\"\",COUNTA($E$14:E110))","v":""},null,"Recubrimiento de superficies, por unidad de obra terminada (inciso 001.J y EP-23).(N.PRY.CAR.10.01.002/13)"]
[null,{"$f":"IF(E111=\"\",\"\",COUNTA($E$14:E111))","v":""},null,"M-1 Raya separadora de sentidos de circulación"]
[null,{"$f":"IF(E112=\"\",\"\",COUNTA($E$14:E112))","v":48},"N.CTR.CAR.1.07.001/00","M-1.6  Raya central continua doble para separar los dos sentidos de circulacion","ml",24000]
[null,{"$f":"IF(E113=\"\",\"\",COUNTA($E$14:E113))","v":""},null,"M-2, Rayas separadoras de carriles."]
[null,{"$f":"IF(E114=\"\",\"\",COUNTA($E$14:E114))","v":49},"N.CTR.CAR.1.07.001/00","M-2.3 Raya discontinua sencilla color blanco reflejante de 15 cm. de ancho.  (longitud efectiva)","ml",4000]
[null,{"$f":"IF(E115=\"\",\"\",COUNTA($E$14:E115))","v":""},null,"M-3, Rayas en la orilla de la calzada, "]
[null,{"$f":"IF(E116=\"\",\"\",COUNTA($E$14:E116))","v":50},"N.CTR.CAR.1.07.001/00","M-3.1 Raya en la orilla derecha continua color blanco reflejante de 15 cm de ancho. (longitud efectiva)","ml",4000]
[null,{"$f":"IF(E117=\"\",\"\",COUNTA($E$14:E117))","v":51},"N.CTR.CAR.1.07.001/00","M-3.2 Raya en la orilla derecha discontinua, color blanco de 15 cm de ancho. (longitud efectiva)","ml",26000]
[null,{"$f":"IF(E118=\"\",\"\",COUNTA($E$14:E118))","v":52},"N.CTR.CAR.1.07.001/00","M-3.3 Raya en la orilla izquierda continua color amarillo reflejante de 15 cm de ancho. (longitud efectiva)","ml",10000]
[null,{"$f":"IF(E119=\"\",\"\",COUNTA($E$14:E119))","v":""},null,"M-4 Raya Separadora de carriles"]
[null,{"$f":"IF(E120=\"\",\"\",COUNTA($E$14:E120))","v":53},"N.CTR.CAR.1.07.001/00","M-4 Raya Separadora de carriles discontinua sencilla.  (longitud efectiva)","ml",5880]
[null,{"$f":"IF(E121=\"\",\"\",COUNTA($E$14:E121))","v":""},null,"Señalamiento vertical en carreteras P.U.O.T. (EP-24) "]
[null,{"$f":"IF(E122=\"\",\"\",COUNTA($E$14:E122))","v":""},null,"SII, Señales informativas de identificación"]
[null,{"$f":"IF(E123=\"\",\"\",COUNTA($E$14:E123))","v":54},"N.CTR.CAR.1.07.005/00","SII-14, Kilometraje con ruta. De 30 x 120 cm.","pza",12]
[null,{"$f":"IF(E124=\"\",\"\",COUNTA($E$14:E124))","v":55},"N.CTR.CAR.1.07.005/00","SII-15, Kilometraje sin ruta. De 30 x 76 cm.","pza",46]
[null,{"$f":"IF(E125=\"\",\"\",COUNTA($E$14:E125))","v":""},null,"SR, Señales restrictivas"]
[null,{"$f":"IF(E126=\"\",\"\",COUNTA($E$14:E126))","v":56},"N.CTR.CAR.1.07.005/00","SR-09, De Velocidad: de 117 x 117 cm con tablero adicional de 35x86.","pza",31]
[null,{"$f":"IF(E127=\"\",\"\",COUNTA($E$14:E127))","v":57},"N.CTR.CAR.1.07.005/00","SR-12, Señal solo Vuelta a la izquierda 117 x 117 cm.","pza",10]
[null,{"$f":"IF(E128=\"\",\"\",COUNTA($E$14:E128))","v":58},"N.CTR.CAR.1.07.005/00","SR-13, Conserve su derecha: de 117 x 117 cm.","pza",9]
[null,{"$f":"IF(E129=\"\",\"\",COUNTA($E$14:E129))","v":59},"N.CTR.CAR.1.07.005/00","SR-25, Retorno: de 117 x 117 cm.","pza",10]
[null,{"$f":"IF(E130=\"\",\"\",COUNTA($E$14:E130))","v":60},"N.CTR.CAR.1.07.005/00","SR-34, Cinturon de seguridad: De 117 x 117 cm.","pza",8]
[null,{"$f":"IF(E131=\"\",\"\",COUNTA($E$14:E131))","v":""},null,"SP, Señales preventivas"]
[null,{"$f":"IF(E132=\"\",\"\",COUNTA($E$14:E132))","v":61},"N.CTR.CAR.1.07.005/00","SP - 6  Señal Preventiva de curva de 117 x 117","pza",16]
[null,{"$f":"IF(E133=\"\",\"\",COUNTA($E$14:E133))","v":62},"N.CTR.CAR.1.07.005/00","SP - 8  Señal Preventiva de curva inversa 117 x 117","pza",4]
[null,{"$f":"IF(E134=\"\",\"\",COUNTA($E$14:E134))","v":63},"N.CTR.CAR.1.07.005/00","SP - 11  Señal Preventiva Interseccion a nivel de 117 x 117","pza",4]
[null,{"$f":"IF(E135=\"\",\"\",COUNTA($E$14:E135))","v":64},"N.CTR.CAR.1.07.005/00","SP - 12  Señal Preventiva de entronque en \"T\" de 117 x 117","pza",16]
[null,{"$f":"IF(E136=\"\",\"\",COUNTA($E$14:E136))","v":65},"N.CTR.CAR.1.07.005/00","SP - 17  Señal Incorporacion de Transito 117 x 117","pza",2]
[null,{"$f":"IF(E137=\"\",\"\",COUNTA($E$14:E137))","v":66},"N.CTR.CAR.1.07.005/00","SP - 19  Señal de Salida de 117 x 117","pza",2]
[null,{"$f":"IF(E138=\"\",\"\",COUNTA($E$14:E138))","v":67},"N.CTR.CAR.1.07.005/00","SP - 32  Señal Preventiva de Peatones de 117 x 117","pza",14]
[null,{"$f":"IF(E139=\"\",\"\",COUNTA($E$14:E139))","v":68},"N.CTR.CAR.1.07.005/00","SP - 41  Señal Preventiva de Tope de 117 x 117","pza",12]
[null,{"$f":"IF(E140=\"\",\"\",COUNTA($E$14:E140))","v":""}]
[null,{"$f":"IF(E141=\"\",\"\",COUNTA($E$14:E141))","v":""},null,"SID, Señales de informacion de destino"]
[null,{"$f":"IF(E142=\"\",\"\",COUNTA($E$14:E142))","v":69},"N.CTR.CAR.1.07.005/00","SID-08, Acceso a poblado: De 56 x 300 cm.","pza",11]
[null,{"$f":"IF(E143=\"\",\"\",COUNTA($E$14:E143))","v":70},"N.CTR.CAR.1.07.005/00","SID-09, Señal de entronque: De 56 x 300 cm.","pza",1]
[null,{"$f":"IF(E144=\"\",\"\",COUNTA($E$14:E144))","v":71},"N.CTR.CAR.1.07.005/00","SID-11, Confirmativa de dos tableros: De 56 x 300 cm.","pza"]
[null,{"$f":"IF(E145=\"\",\"\",COUNTA($E$14:E145))","v":72},"N.CTR.CAR.1.07.005/00","SID-11, Confirmativa de un tableros: De 56 x 300 cm.","pza",23]
[null,{"$f":"IF(E146=\"\",\"\",COUNTA($E$14:E146))","v":73},"N.CTR.CAR.1.07.006/00","SID-13, tipo bandera: De 122 x 366 cm.","pza",3]
[null,{"$f":"IF(E147=\"\",\"\",COUNTA($E$14:E147))","v":""},null,"SIR, Señales de recomendación (No circular por acotamiento, No Maneje Cansado, etc.)"]
[null,{"$f":"IF(E148=\"\",\"\",COUNTA($E$14:E148))","v":74},"N.CTR.CAR.1.07.005/00","SIR- de 86 x 300 cm","pza",14]
[null,{"$f":"IF(E149=\"\",\"\",COUNTA($E$14:E149))","v":""},null,"SIS - Señal informativa de servicios (mecanico, restaurant, gasolineras, hotel, cruz roja, etc)"]
[null,{"$f":"IF(E150=\"\",\"\",COUNTA($E$14:E150))","v":75},"N.CTR.CAR.1.07.005/00","SIS-19, Parada de autobus 117 x 117 con tablero adicional 35 x 117","pza",4]
[null,{"$f":"IF(E151=\"\",\"\",COUNTA($E$14:E151))","v":76},null,"SIS-19, Parada de autobus de 117 x 117","pza",42]
[null,{"$f":"IF(E152=\"\",\"\",COUNTA($E$14:E152))","v":77},null,"SIS-Conjunto 2 modulos,4 servicios de 71 x 71, con tablero adicional 35 x 117","pza",2]
[null,{"$f":"IF(E153=\"\",\"\",COUNTA($E$14:E153))","v":""},null,"OD-5, Indicador de obstáculo."]
[null,{"$f":"IF(E154=\"\",\"\",COUNTA($E$14:E154))","v":78},"N.CTR.CAR.1.07.005/00","OD-5, Indicador de obstáculo tipo bifurcación 61 x 122 cm","pza",3]
[null,{"$f":"IF(E155=\"\",\"\",COUNTA($E$14:E155))","v":""},null,"OD-6 Indicadores de alineamiento (EP-25)."]
[null,{"$f":"IF(E156=\"\",\"\",COUNTA($E$14:E156))","v":""},"N.CTR.CAR.1.07.005/00","OD-6, Indicadores de alineamiento:"]
[null,{"$f":"IF(E157=\"\",\"\",COUNTA($E$14:E157))","v":79},"N.CTR.CAR.1.07.005/00","Indicadores de alineamiento de lamina P.U.O.T.","pza",3620]
[null,{"$f":"IF(E158=\"\",\"\",COUNTA($E$14:E158))","v":""},"N.CTR.CAR","OD-7, Vialetas (EP-26)."]
[null,{"$f":"IF(E159=\"\",\"\",COUNTA($E$14:E159))","v":""},"N.CTR.CAR.1.07.004/02","En la orilla izquierda de la calzada color amarillo (DH-1.6b) con reflejante en dos cara"]
[null,{"$f":"IF(E160=\"\",\"\",COUNTA($E$14:E160))","v":80},null,"por unidad de obra terminada : De 100 x 100 mm.  ","pza",2948]
[null,{"$f":"IF(E161=\"\",\"\",COUNTA($E$14:E161))","v":""},"N.CTR.CAR.1.07.004/02","Al centro de la calzada color blanco (DH-1.9) con reflejante en una cara,"]
[null,{"$f":"IF(E162=\"\",\"\",COUNTA($E$14:E162))","v":81},null,"por unidad de obra terminada : De 100 x 100 mm.  ","pza",7104]
[null,{"$f":"IF(E163=\"\",\"\",COUNTA($E$14:E163))","v":""},"N.CTR.CAR.1.07.004/02","En la orilla de la calzada derecha color blanco (DH-1.12),  con reflejante en dos caras"]
[null,{"$f":"IF(E164=\"\",\"\",COUNTA($E$14:E164))","v":82},null,"por unidad de obra terminada : De 100 x 100 mm.  ","pza",5896]
[null,{"$f":"IF(E165=\"\",\"\",COUNTA($E$14:E165))","v":""},"N.CTR.CAR.1.07.004/02","En la orilla derecha de la calzada color blanco (DH-1.13) con reflejante en una cara,"]
[null,{"$f":"IF(E166=\"\",\"\",COUNTA($E$14:E166))","v":83},null,"por unidad de obra terminada : De 100 x 100 mm.  ","pza",1340]
[null,{"$f":"IF(E167=\"\",\"\",COUNTA($E$14:E167))","v":""},"N.CTR.CAR.1.07.004/02","En la orilla izquierda de la calzada color amarillo (DH-1.14) con reflejante en una cara"]
[null,{"$f":"IF(E168=\"\",\"\",COUNTA($E$14:E168))","v":84},null,"por unidad de obra terminada : De 100 x 100 mm.  ","pza",1340]
[null,{"$f":"IF(E169=\"\",\"\",COUNTA($E$14:E169))","v":85},"N.CTR.CAR.1.07.003/00","OD-15  Señal de Reductor de velocidad (Topes)","pza",3]
[null,{"$f":"IF(E170=\"\",\"\",COUNTA($E$14:E170))","v":86},"N.CTR.CAR.1.02.013/00","Desmantelamiento de señales verticales bajas existentes, por unidad de obra terminada (E.P  27)","pza",208]
[null,{"$f":"IF(E171=\"\",\"\",COUNTA($E$14:E171))","v":87},"N.CTR.CAR.1.02.013/00","Desmantelamiento de señales verticales elevadas existentes, por unidad de obra terminada (E.P  28)","pza",7]
[null,{"$f":"IF(E172=\"\",\"\",COUNTA($E$14:E172))","v":""},null,"ESTRUCTURAS  N.CTR.CAR.1.02"]
[null,{"$f":"IF(E173=\"\",\"\",COUNTA($E$14:E173))","v":""},null,"INFRAESTRUCTURA"]
[null,{"$f":"IF(E174=\"\",\"\",COUNTA($E$14:E174))","v":""},null,"SUBESTRUCTURA"]
[null,{"$f":"IF(E175=\"\",\"\",COUNTA($E$14:E175))","v":""},null,"PILOTES COLADOS EN EL LUGAR (E.P. 29)"]
[null,{"$f":"IF(E176=\"\",\"\",COUNTA($E$14:E176))","v":""},null,"Concreto de f'c = 250 kg/cm²  en pilotes colados en el lugar de 1.20 m. de diametro  dentro de "]
[null,{"$f":"IF(E177=\"\",\"\",COUNTA($E$14:E177))","v":88},"N.CTR.CAR.1.06.003/01","una perforacion previa en cualquier tipo de materia l, P.U.O.T. (inciso 003.J)","m3",863]
[null,{"$f":"IF(E178=\"\",\"\",COUNTA($E$14:E178))","v":89},"N.CTR.CAR.1.02.003/04","Plantilla de concreto  f'c = 100 kg/cm2 P.U.O.T.","m3",14]
[null,{"$f":"IF(E179=\"\",\"\",COUNTA($E$14:E179))","v":""},null,"EXCAVACION PARA ESTRUCTURAS"]
[null,{"$f":"IF(E180=\"\",\"\",COUNTA($E$14:E180))","v":90},"N.CTR.CAR.1.01.007/11","Excavaciones para estructuras P.U.O.T.(inciso 007.J)","m3",383]
[null,{"$f":"IF(E181=\"\",\"\",COUNTA($E$14:E181))","v":""},null,"CONCRETO HIDRAULICO"]
[null,{"$f":"IF(E182=\"\",\"\",COUNTA($E$14:E182))","v":""},null,"Concreto hidraulico de  f'c=250 kg/cm²  (Inciso 003.J) colado en seco:"]
[null,{"$f":"IF(E183=\"\",\"\",COUNTA($E$14:E183))","v":91},"N.CTR.CAR.1.02.003/04","Cabezales, Diafragmas, Pantallas, Bancos y Topes, P.U.O.T","m3",1298]
[null,{"$f":"IF(E184=\"\",\"\",COUNTA($E$14:E184))","v":92},"N.CTR.CAR.1.02.003/04","Coronas, bancos de estribos, muro, pantalla, topes, P.U.O.T","m3",530]
[null,{"$f":"IF(E185=\"\",\"\",COUNTA($E$14:E185))","v":93},"N.CTR.CAR.1.02.003/04","Zapatas P.U.O.T.","m3",28]
[null,{"$f":"IF(E186=\"\",\"\",COUNTA($E$14:E186))","v":94},"N.CTR.CAR.1.02.003/04","Pilas y/o Columnas P.U.O.T  (E.P. 30)","m3",126]
[null,{"$f":"IF(E187=\"\",\"\",COUNTA($E$14:E187))","v":95},"N.CTR.CAR.1.02.003/04","Cuerpo y aleros de estribos P.U.O.T. (E.P. 30)","m3",54]
[null,{"$f":"IF(E188=\"\",\"\",COUNTA($E$14:E188))","v":96},"N.CTR.CAR.1.02.003/04","Ciclopeo de f´c= 150 kg/cm2 en estribos y aleros, P.U.O.T (E.P. 30)","m3",50]
[null,{"$f":"IF(E189=\"\",\"\",COUNTA($E$14:E189))","v":""},null,"ACERO PARA CONCRETO HIDRAULICO"]
[null,{"$f":"IF(E190=\"\",\"\",COUNTA($E$14:E190))","v":""},null,"Acero de refuerzo, P.U.O.T. en Subestructura (Inciso 004.J)"]
[null,{"$f":"IF(E191=\"\",\"\",COUNTA($E$14:E191))","v":97},"N.CTR.CAR.1.02.004/02","Varillas de limite elastico igual o mayor de 4200 Kg/cm²","Kg",192362]
[null,{"$f":"IF(E192=\"\",\"\",COUNTA($E$14:E192))","v":98},"N.CMT.2.08/15","Apoyos integrales de neopreno, P.U.O.T. (E.P. 31)","dm3",58]
[null,{"$f":"IF(E193=\"\",\"\",COUNTA($E$14:E193))","v":""},null,"SUPERESTRUCTURA"]
[null,{"$f":"IF(E194=\"\",\"\",COUNTA($E$14:E194))","v":""},null,"ESTRUCTURAS DE CONCRETO PRESFORZADO  N.CTR.CAR.1.02.007/01"]
[null,{"$f":"IF(E195=\"\",\"\",COUNTA($E$14:E195))","v":99},"N.CTR.CAR.1.02.007/01","Trabes y tabletas de concreto hidraulico presforzadas de f'c=350 kg/cm²,según proyecto P.U.O.T. (E.P. 32)","m3",1833]
[null,{"$f":"IF(E196=\"\",\"\",COUNTA($E$14:E196))","v":100},"N.CTR.CAR.1.02.007/01","Montaje de elementos estructurales presforzados trabes tipo aashto P.U.O.T.(Inciso 007.J y E.P. 33)","pza",28]
[null,{"$f":"IF(E197=\"\",\"\",COUNTA($E$14:E197))","v":101},"N.CTR.CAR.1.02.007/01","Montaje de elementos estructurales presforzados trabes tipo tabletas P.U.O.T.(Inciso 007.J y E.P. 33)","pza",336]
[null,{"$f":"IF(E198=\"\",\"\",COUNTA($E$14:E198))","v":""},null,"CONCRETO HIDRAULICO"]
[null,{"$f":"IF(E199=\"\",\"\",COUNTA($E$14:E199))","v":102},"N.CTR.CAR.1.02.003/04","Concreto hidraulico de f'c = 250 kg/cm² en losas y diafragmas P.U.O.T.(inciso 003.J)","m3",659]
[null,{"$f":"IF(E200=\"\",\"\",COUNTA($E$14:E200))","v":103},"N.CMT.2.08/15","Apoyos integrales de neopreno ASTM D2240, Dureza SHORE 60 P.U.O.T.(E.P. 31)","dm3",1084]
[null,{"$f":"IF(E201=\"\",\"\",COUNTA($E$14:E201))","v":""},null,"Drenes de plástico DURAFLEX \"D\" o similar, por unidad de obra terminada (E.P. 34):"]
[null,{"$f":"IF(E202=\"\",\"\",COUNTA($E$14:E202))","v":104},"N.CMT.3.04.003/05","De 76 milímetros de diámetro","pza",100]
[null,{"$f":"IF(E203=\"\",\"\",COUNTA($E$14:E203))","v":""},null,"ACERO PARA CONCRETO HIDRAULICO"]
[null,{"$f":"IF(E204=\"\",\"\",COUNTA($E$14:E204))","v":105},"N.CTR.CAR.1.02.004/02","Acero de refuerzo, P.U.O.T. (Inciso 004.J)","Kg",52276]
[null,{"$f":"IF(E205=\"\",\"\",COUNTA($E$14:E205))","v":106},"N.CTR.CAR.1.04.009/06","Carpeta de concreto hidraulico en superficie de rodamiento (inciso 009.J) (E.P. 35)","m3",145]
[null,{"$f":"IF(E206=\"\",\"\",COUNTA($E$14:E206))","v":107},"N.CTR.CAR.1.02.005/01","Varilla C para tensores con rosca en sus extremos, incluye accesorios, P.U.O.T. (E.P. 36)","Kg",500]
[null,{"$f":"IF(E207=\"\",\"\",COUNTA($E$14:E207))","v":""},null,"Juntas de dilatacion, P.U.O.T.(inciso 004.J)"]
[null,{"$f":"IF(E208=\"\",\"\",COUNTA($E$14:E208))","v":108},"N.CTR.CAR.1.02.004/02","Acero de Refuerzo, P.U.O.T.(Inciso 004.J)","kg",5407]
[null,{"$f":"IF(E209=\"\",\"\",COUNTA($E$14:E209))","v":109},"N.CTR.CAR.1.02.008/01","Acero Estructural A-36, P.U.O.T. en junta de dilatacion de losa.","kg",9862]
[null,{"$f":"IF(E210=\"\",\"\",COUNTA($E$14:E210))","v":110},null,"Sikaflex 1-A o material similar de 2 cm de espesor P.U.O.T. (E.P. 37)","dm2",50]
[null,{"$f":"IF(E211=\"\",\"\",COUNTA($E$14:E211))","v":111},null,"Sikaflex 1-A o material similar de 4 cm de espesor P.U.O.T. (E.P. 37)","dm2",2308]
[null,{"$f":"IF(E212=\"\",\"\",COUNTA($E$14:E212))","v":112},null,"Cartón asfaltado, de 2 cm de espesor P.U.O.T. (inciso 026-H.11) (E.P. 38)","m2",41]
[null,{"$f":"IF(E213=\"\",\"\",COUNTA($E$14:E213))","v":113},null,"Cartón asfaltado, de 4 cm de espesor P.U.O.T. (inciso 026-H.11) (E.P. 38)","m2",350]
[null,{"$f":"IF(E214=\"\",\"\",COUNTA($E$14:E214))","v":""},null,"CONCRETO f'c = 250 kg/cm²  EN: (Inciso 003.J)"]
[null,{"$f":"IF(E215=\"\",\"\",COUNTA($E$14:E215))","v":114},"N.CTR.CAR.1.02.003/04","En Remate de parapeto, vigas y pilastras, P.U.O.T.","m3",32]
[null,{"$f":"IF(E216=\"\",\"\",COUNTA($E$14:E216))","v":115},"N.CTR.CAR.1.02.003/04","En guarniciones P.U.O.T.","m3",114]
[null,{"$f":"IF(E217=\"\",\"\",COUNTA($E$14:E217))","v":""},null,"ACERO PARA CONCRETO HIDRAULICO"]
[null,{"$f":"IF(E218=\"\",\"\",COUNTA($E$14:E218))","v":116},"N.CTR.CAR.1.02.004/02","Acero de refuerzo , P.U.O.T .(Inciso 004.J)","Kg",32333]
[null,{"$f":"IF(E219=\"\",\"\",COUNTA($E$14:E219))","v":""},null,"ESTRUCTURAS DE ACERO"]
[null,{"$f":"IF(E220=\"\",\"\",COUNTA($E$14:E220))","v":117},"N.CTR.CAR.1.02.009/00","Parapetos de acero estructural A-36, P.U.O.T. (E.P. 39) según proyecto","ml",901]
[null,{"$f":"IF(E221=\"\",\"\",COUNTA($E$14:E221))","v":""},null,"CONOS DE DERRAME"]
[null,{"$f":"IF(E222=\"\",\"\",COUNTA($E$14:E222))","v":118},"N.CTR.CAR.1.06.003/01","Concreto hidraulico f'c = 150 kg/cm²  ,P.U.O.T. (inciso 003.J)","m3",388]
[null,{"$f":"IF(E223=\"\",\"\",COUNTA($E$14:E223))","v":119},null,"Malla electrosoldada de 6x6-3/3 P.U.O.T.","m2",3880]
[null,{"$f":"IF(E224=\"\",\"\",COUNTA($E$14:E224))","v":120},null,"Cartón asfaltado, de 2 cm de espesor P.U.O.T. (inciso 026-H.11) (E.P. 40)","m2",21]
[null,{"$f":"IF(E225=\"\",\"\",COUNTA($E$14:E225))","v":""},null,"LOSAS DE ACCESO"]
[null,{"$f":"IF(E226=\"\",\"\",COUNTA($E$14:E226))","v":121},"N.CTR.CAR.1.02.003/04","Concreto hidraulico f'c = 250 kg/cm²  ,P.U.O.T. (inciso 003.J)","m3",903]
[null,{"$f":"IF(E227=\"\",\"\",COUNTA($E$14:E227))","v":122},"N.CTR.CAR.1.02.004/02","Acero de refuerzo LE>= 4000 kg/cm2 P.U.O.T. (inciso 004.J)","kg",99164]
[null,{"$f":"IF(E228=\"\",\"\",COUNTA($E$14:E228))","v":123},null,"Cartón asfaltado, de 2 cm de espesor P.U.O.T. (inciso 026-H.11) (E.P. 40)","m2",288]
[null,{"$f":"IF(E229=\"\",\"\",COUNTA($E$14:E229))","v":""},null,"ACCESOS"]
[null,{"$f":"IF(E230=\"\",\"\",COUNTA($E$14:E230))","v":""},null,"TERRAPLENES DE ACCESO"]
[null,{"$f":"IF(E231=\"\",\"\",COUNTA($E$14:E231))","v":""},null,"Formacion y compactacion. P.U.O.T. (inciso 009.J)"]
[null,{"$f":"IF(E232=\"\",\"\",COUNTA($E$14:E232))","v":124},"N.CTR.CAR.1.01.009/11","Terraplenes de acceso compactados al 95%, (E.P. 41)","m3",120713]
[null,{"$f":"IF(E233=\"\",\"\",COUNTA($E$14:E233))","v":125},"N.CTR.CAR.1.01.009/11","de subrasante, al cien por ciento (100%) en terraplenes de acceso (E.P. 42)","m3",456]
[null,{"$f":"IF(E234=\"\",\"\",COUNTA($E$14:E234))","v":""},null,"CANALES"]
[null,{"$f":"IF(E235=\"\",\"\",COUNTA($E$14:E235))","v":""},null,"Excavación para canales, por unidad de obra terminada (inciso 005.J) "]
[null,{"$f":"IF(E236=\"\",\"\",COUNTA($E$14:E236))","v":""},null,"Cualesquiera que sea su clasificacion y profundidad."]
[null,{"$f":"IF(E237=\"\",\"\",COUNTA($E$14:E237))","v":126},"N.CTR.CAR.1.01.005/11","canales de entrada y salida P.U.O.T.","m3",3371]
[null,{"$f":"IF(E238=\"\",\"\",COUNTA($E$14:E238))","v":127},"N.CTR.CAR.1.02.013/00","Remocion de terraplenes y pavimentos en accesos P.U.O.T. (E.P. 43)","m3",72427]
[null,{"$f":"IF(E239=\"\",\"\",COUNTA($E$14:E239))","v":128},null,"Extraccion de azolves en estructuras","m3",29222]
[null,{"$f":"IF(E240=\"\",\"\",COUNTA($E$14:E240))","v":""},null,"Sub bases o bases, P.U.O.T. (074-H.041)"]
[null,{"$f":"IF(E241=\"\",\"\",COUNTA($E$14:E241))","v":129},"N.CTR.CAR.1.04.002/11","Subbase compactada al 100%, del banco que elija el contratista (incluye acarreos) (E.P.44)","m3",8455]
[null,{"$f":"IF(E242=\"\",\"\",COUNTA($E$14:E242))","v":130},"N.CTR.CAR.1.04.002/11","Base compactada al 100%, del banco que elija el contratista (incluye acarreos) (E.P.45)","m3",8455]
[null,{"$f":"IF(E243=\"\",\"\",COUNTA($E$14:E243))","v":""},null,"CONCRETO  f'c = 250 kg/cm²   (inciso 003.J) P.U.O.T.  COLADO EN SECO:"]
[null,{"$f":"IF(E244=\"\",\"\",COUNTA($E$14:E244))","v":131},"N.CTR.CAR.1.02.010/00","En guarniciones de acceso (E.P. 17)","m3",324]
[null,{"$f":"IF(E245=\"\",\"\",COUNTA($E$14:E245))","v":132},"N.CTR.CAR.1.02.004/02","Acero de refuerzo de L.E ≥ 4000 Kg/cm², P.U.O.T.","Kg",72893]
[null,{"$f":"IF(E246=\"\",\"\",COUNTA($E$14:E246))","v":""},null,"Defensa metalica de lámina galvanizada tipo AASHTO, incluyendo sus accesorios"]
[null,{"$f":"IF(E247=\"\",\"\",COUNTA($E$14:E247))","v":133},"N.CTR.CAR.1.07.009/00","de tres cretas, P.U.O.T. (E.P.13)","ml",2880]
[null,{"$f":"IF(E248=\"\",\"\",COUNTA($E$14:E248))","v":""},null,"TRABAJOS DIVERSOS"]
[null,{"$f":"IF(E249=\"\",\"\",COUNTA($E$14:E249))","v":""},null,"Lavaderos (E.P. 08):"]
[null,{"$f":"IF(E250=\"\",\"\",COUNTA($E$14:E250))","v":""},null,"de concreto hidraulico, P.U.O.T. (inciso 006.J) de f'c = 150 kg/cm²  t.m.a. 19 mm"]
[null,{"$f":"IF(E251=\"\",\"\",COUNTA($E$14:E251))","v":134},"N.CTR.CAR.1.03.006/00","(3/4\") reforzado con malla electro soldada No. 6-6 de 10 x 10 cm","m3",47]
[null,{"$f":"IF(E252=\"\",\"\",COUNTA($E$14:E252))","v":""},null,"DEMOLICIONES"]
[null,{"$f":"IF(E253=\"\",\"\",COUNTA($E$14:E253))","v":""},null,"Demoliciones, por unidad de obra terminada (inciso 013.J)"]
[null,{"$f":"IF(E254=\"\",\"\",COUNTA($E$14:E254))","v":135},"N.CTR.CAR.1.02.013/00","De mamposteria de tercera clase con mortero de cemento","m3",1618]
[null,{"$f":"IF(E255=\"\",\"\",COUNTA($E$14:E255))","v":136},"N.CTR.CAR.1.02.013/00","De concreto hidraulico reforzado","m3",2002]
[null,{"$f":"IF(E256=\"\",\"\",COUNTA($E$14:E256))","v":137},"N.CTR.CAR.1.02.013/00","Demoliciones de zampeados de mamposteria con mortero de cemento","m3",74]
[null,{"$f":"IF(E257=\"\",\"\",COUNTA($E$14:E257))","v":""},null,"SEÑALAMIENTO VERTICAL (E.P. 24)"]
[null,{"$f":"IF(E258=\"\",\"\",COUNTA($E$14:E258))","v":138},"N.CTR.CAR.1.07.006/00","Señal SIG 8 \"PUENTE \" \" DE 40 X 239 CM. P.U.O.T.","pza",22]
[]
[]
[null,"ESTA RELACION COMPRENDE  138 CONCEPTOS"]
[]
[null,"NOMBRE Y CARGO DEL SIGNATARIO"]

{"sheet":"FORMA E-7","index":1,"n_rows":281,"n_cols":8,"rows_kept":281,"cut":false,"hidden":false,"merged":[[2,4,5,7],[6,0,6,2],[6,4,10,4],[6,5,7,6],[6,7,10,7],[7,0,7,2],[8,0,10,0],[8,2,10,2],[8,5,10,5],[8,6,10,6]]}
[null,null,null,null,null,null,null,"Forma E-7"]
[null,null,"SECRETARIA DE COMUNICACIONES Y TRANSPORTES","LICITACIÓN NÚM:       ",null,"LO-009000999-E241-2016"]
[null,null,"DIRECCION GENERAL DE CARRETERAS","TRABAJOS:","“MODERNIZACIÓN Y AMPLIACIÓN DE LA CARRETERA ESTACIÓN DON – NOGALES, TRAMO: MAGDALENA DE KINO – NOGALES DEL KM 236+000 AL KM 264+000 AMBOS CUERPOS “A Y B”, EN EL ESTADO DE SONORA”.."]
[null,null,"CENTRO SCT SONORA"]
[]
[]
["O    B     R     A ",null,null,null,"CANTIDAD DE OBRA","PRECIO UNITARIO",null,"IMPORTE $"]
["C   O   N   C   E   P   T   O"]
["No.","ESPECIFICACIÓN","DESCRIPCIÓN","UNIDAD",null,"CON LETRA","CON NUMERO"]
[null,"GENERAL O"]
[null,"COMPLEMENTARIA"]
[null,"","TERRACERIAS N.CTR.CAR.1.01"]
[null,null,"DESMONTE"]
[1,"N.CTR.CAR.1.01.001/11","Desmonte por unidad de obra terminada P.U.O.T. (inciso 001.I)","ha",27]
[null,null,"CORTES"]
[{"$f":"IF(D16=\"\",\"\",COUNTA($D$14:D16))","v":2},"N.CTR.CAR.1.01.002/11","Despalmes, por unidad de obra terminada (inciso 002.I) :De cortes","m3",10281]
[{"$f":"IF(D17=\"\",\"\",COUNTA($D$14:D17))","v":3},"N.CTR.CAR.1.01.002/11","Despalmes, por unidad de obra terminada (inciso 002.I) :Para desplante de terraplen","m3",42046]
[{"$f":"IF(D18=\"\",\"\",COUNTA($D$14:D18))","v":""},null,"Excavaciones, por unidad de obra terminada (inciso 003.J):"]
[{"$f":"IF(D19=\"\",\"\",COUNTA($D$14:D19))","v":""},null,"En cortes y adicionales abajo de la subrasante:"]
[{"$f":"IF(D20=\"\",\"\",COUNTA($D$14:D20))","v":4},"N.CTR.CAR.1.01.003/11","Cuando el material se utilice para la formación de terraplenes.","m3",22299]
[{"$f":"IF(D21=\"\",\"\",COUNTA($D$14:D21))","v":5},"N.CTR.CAR.1.01.003/11","Cuando el material se desperdicie.","m3",56690]
[{"$f":"IF(D22=\"\",\"\",COUNTA($D$14:D22))","v":""},null,"En ampliación de cortes:"]
[{"$f":"IF(D23=\"\",\"\",COUNTA($D$14:D23))","v":6},"N.CTR.CAR.1.01.003/11","Cuando el material se utiliza para el arrope de taludes, P.U.O.T. (Inciso 003.J) (EP.01)","m3",34572]
[{"$f":"IF(D24=\"\",\"\",COUNTA($D$14:D24))","v":""},null,"Excavacion en cajas, P.U.O.T., en zonas inestables para desplante de terraplenes"]
[{"$f":"IF(D25=\"\",\"\",COUNTA($D$14:D25))","v":7},"N.CTR.CAR.1.01.003/11","Cuando el material se utilice para arrope de taludes.","m3",12713]
[{"$f":"IF(D26=\"\",\"\",COUNTA($D$14:D26))","v":""},null,"En  escalones de liga, Por Unidad de Obra Terminada (inciso 004.I)"]
[{"$f":"IF(D27=\"\",\"\",COUNTA($D$14:D27))","v":8},"N.CTR.CAR.1.01.004/11","Cuando el material se utilice para la formación de terraplenes, incluye acarreos. (E.P. 02)","m3",11057]
[{"$f":"IF(D28=\"\",\"\",COUNTA($D$14:D28))","v":""},null,"TERRAPLENES"]
[{"$f":"IF(D29=\"\",\"\",COUNTA($D$14:D29))","v":""},null,"Recompactación :"]
[{"$f":"IF(D30=\"\",\"\",COUNTA($D$14:D30))","v":""},null,"Escarificacion, acamellonado, tendido y compactado (inciso 009.J)"]
[{"$f":"IF(D31=\"\",\"\",COUNTA($D$14:D31))","v":9},"N.CTR.CAR.1.01.009/11","Para cien por ciento (100%) , para subrasante","m3",27263]
[{"$f":"IF(D32=\"\",\"\",COUNTA($D$14:D32))","v":10},"N.CTR.CAR.1.01.009/11","Para noventa y cinco porciento (95%)","m3",2509]
[{"$f":"IF(D33=\"\",\"\",COUNTA($D$14:D33))","v":""},null,"De la superficie descubierta al escarificar y acamellonar por alas la capa superior de las terracerias"]
[{"$f":"IF(D34=\"\",\"\",COUNTA($D$14:D34))","v":""},null,"subyacente o subrasante existente P.U.O.T (inciso 009.J)"]
[{"$f":"IF(D35=\"\",\"\",COUNTA($D$14:D35))","v":11},"N.CTR.CAR.1.01.009/11","Para cien porciento (100%)","m3",7796]
[{"$f":"IF(D36=\"\",\"\",COUNTA($D$14:D36))","v":12},"N.CTR.CAR.1.01.009/11","Para noventa y cinco porciento (95%)","m3",2509]
[{"$f":"IF(D37=\"\",\"\",COUNTA($D$14:D37))","v":""},null,"Formación y compactación, por unidad de obra terminada (inciso 009.J) :"]
[{"$f":"IF(D38=\"\",\"\",COUNTA($D$14:D38))","v":""},null,"De terraplenes adicionados con sus cuñas de sobreancho :"]
[{"$f":"IF(D39=\"\",\"\",COUNTA($D$14:D39))","v":13},"N.CTR.CAR.1.01.009/11","Para noventa por ciento (90%) (EP-03)","m3",97345]
[{"$f":"IF(D40=\"\",\"\",COUNTA($D$14:D40))","v":14},"N.CTR.CAR.1.01.009/11","Para noventa y cinco por ciento (95%). (EP-03)","m3",125669]
[{"$f":"IF(D41=\"\",\"\",COUNTA($D$14:D41))","v":15},"N.CTR.CAR.1.01.009/11","Para cien por ciento (100%) en capa subrasante. (EP-04)","m3",163174]
[{"$f":"IF(D42=\"\",\"\",COUNTA($D$14:D42))","v":16},"N.CTR.CAR.1.01.009/11","Del relleno de las cajas en cortes, compactados al 95%","m3",8966]
[{"$f":"IF(D43=\"\",\"\",COUNTA($D$14:D43))","v":17},"N.CTR.CAR.1.01.009/11","Del relleno de las cajas en cortes, compactados al 100%","m3",10620]
[{"$f":"IF(D44=\"\",\"\",COUNTA($D$14:D44))","v":""},null,"Arrope de taludes de los terraplenes con el material obtenido de despalme y de Excavaciones"]
[{"$f":"IF(D45=\"\",\"\",COUNTA($D$14:D45))","v":18},"N.CTR.CAR.1.01.012/00","de cajas para desplante de terraplenes, por unidad de obra terminada (EP-05).","m3",34572]
[{"$f":"IF(D46=\"\",\"\",COUNTA($D$14:D46))","v":""}]
[{"$f":"IF(D47=\"\",\"\",COUNTA($D$14:D47))","v":""},null,"DRENAJE Y SUBDRENAJE    N.CTR.CAR.1.03."]
[{"$f":"IF(D48=\"\",\"\",COUNTA($D$14:D48))","v":""},null,"CANALES"]
[{"$f":"IF(D49=\"\",\"\",COUNTA($D$14:D49))","v":""},null,"Excavación para canales, por unidad de obra terminada (inciso 005.J) "]
[{"$f":"IF(D50=\"\",\"\",COUNTA($D$14:D50))","v":""},null,"Cualesquiera que sea su clasificacion y profundidad."]
[{"$f":"IF(D51=\"\",\"\",COUNTA($D$14:D51))","v":19},"N.CTR.CAR.1.01.005/11","De entrada y salida a obras de drenaje.","m3",707.4]
[{"$f":"IF(D52=\"\",\"\",COUNTA($D$14:D52))","v":""},null,"EXCAVACIÓN PARA ESTRUCTURAS"]
[{"$f":"IF(D53=\"\",\"\",COUNTA($D$14:D53))","v":""},null,"Excavado, por unidad de obra terminada,  "]
[{"$f":"IF(D54=\"\",\"\",COUNTA($D$14:D54))","v":20},"N.CTR.CAR.1.01.007/11","Cualesquiera que sea su clasificación y profundidad  (inciso 007.J)","m3",12394]
[{"$f":"IF(D55=\"\",\"\",COUNTA($D$14:D55))","v":""},null,"Extraccion de azolves en obras de drenaje,"]
[{"$f":"IF(D56=\"\",\"\",COUNTA($D$14:D56))","v":21},"N.CTR.CAR.1.01.005/11","Culesquiera que sean sus dimensiones y longitud P.U.O.T. (EP-06).(009.J)","m3",229.5]
[{"$f":"IF(D57=\"\",\"\",COUNTA($D$14:D57))","v":""},null,"RELLENOS"]
[{"$f":"IF(D58=\"\",\"\",COUNTA($D$14:D58))","v":""},null,"Rellenos al 95% (Inciso 011.J):"]
[{"$f":"IF(D59=\"\",\"\",COUNTA($D$14:D59))","v":22},"N.CTR.CAR.1.01.011/11","Para la protección de las obras de drenaje, por unidad de obra terminada ","m3",5101]
[{"$f":"IF(D60=\"\",\"\",COUNTA($D$14:D60))","v":""},null,"ZAMPEADOS"]
[{"$f":"IF(D61=\"\",\"\",COUNTA($D$14:D61))","v":""},null,"Zampeados a cualquier altura, por unidad de obra terminada. (inciso 002.J):"]
[{"$f":"IF(D62=\"\",\"\",COUNTA($D$14:D62))","v":23},"N.CTR.CAR.1.02.002/00","De concreto hidraulico simple de f´c= 150 kg/cm². ","m3",776.8]
[{"$f":"IF(D63=\"\",\"\",COUNTA($D$14:D63))","v":24},"N.CTR.CAR.1.02.002/00","Plantilla granular para colocación de tubos de concreto P.U.O.T. (EP-07)","m3",757]
[{"$f":"IF(D64=\"\",\"\",COUNTA($D$14:D64))","v":""},null,"CONCRETO HIDRÁULICO."]
[{"$f":"IF(D65=\"\",\"\",COUNTA($D$14:D65))","v":""},null,"Concreto hidráulico Simple, colado en seco por unidad de obra terminada. (inciso 003.J):"]
[null,null,null,null,null,null,"SUMA:",{"$f":"SUM(H14:H64)","v":0}]
[null,null,null,null,null,null,"ACUMULADO:",{"$f":"H66","v":0}]
[{"$f":"IF(D68=\"\",\"\",COUNTA($D$14:D68))","v":25},"N.CTR.CAR.1.02.003/04","De f'c= 100 kg/cm²","m3",430.4]
[{"$f":"IF(D69=\"\",\"\",COUNTA($D$14:D69))","v":26},"N.CTR.CAR.1.02.003/04","De f'c= 150 kg/cm²","m3",3532]
[{"$f":"IF(D70=\"\",\"\",COUNTA($D$14:D70))","v":27},"N.CTR.CAR.1.02.003/04","De f'c= 200 kg/cm²","m3",1722.7]
[{"$f":"IF(D71=\"\",\"\",COUNTA($D$14:D71))","v":""},null,"Bordillo de concreto hidraulico (inciso 007.J) colados en el lugar:"]
[{"$f":"IF(D72=\"\",\"\",COUNTA($D$14:D72))","v":""},null,"de f´c = 150 kg/cm2, de 156 cm2 de sección ( bordillos de 16 cm base mayor"]
[{"$f":"IF(D73=\"\",\"\",COUNTA($D$14:D73))","v":28},"N.CTR.CAR.1.03.007/00","10 cm base menor y 12 cm de altura), con agregado de tamaño maximo de 19 mm (3/4\")P.U.O.T.(EP-08)","m",609]
[{"$f":"IF(D74=\"\",\"\",COUNTA($D$14:D74))","v":""},null,"Lavaderos  (inciso 006.J) de concreto hidraulico simple de f´c= 150 kg/cm2"]
[{"$f":"IF(D75=\"\",\"\",COUNTA($D$14:D75))","v":29},"N.CTR.CAR.1.03.006/00","con agregado de tamaño maximo de 38 mm ( 1 1/2\"), por unidad de obra terminada.(EP-09)","m3",6]
[{"$f":"IF(D76=\"\",\"\",COUNTA($D$14:D76))","v":""},null,"ACERO PARA CONCRETO  HIDRAULICO"]
[{"$f":"IF(D77=\"\",\"\",COUNTA($D$14:D77))","v":""},null,"Acero de refuerzo, por unidad de obra terminada ( inciso 004.J):"]
[{"$f":"IF(D78=\"\",\"\",COUNTA($D$14:D78))","v":30},"N.CTR.CAR.1.02.004/02","Varillas de limite elastico igual o mayor de 4,200 kg/cm²","kg",229696]
[null,null,"Malla electrosoldada de 6x6-10/10 P.U.O.T.","m2",2504]
[null,null,"Tuberia de concreto, P.U.O.T. (inciso 004.J)"]
[null,null,"Reforzado de 280 kg/cm2, P.U.O.T."]
[null,"N.CTR.CAR.1.03.002/00","De 120 cm.","m",38]
[{"$f":"IF(D83=\"\",\"\",COUNTA($D$14:D83))","v":""},null,"DEMOLICIONES"]
[{"$f":"IF(D84=\"\",\"\",COUNTA($D$14:D84))","v":33},"N.CTR.CAR.1.02.013/00","Demoliciones de mamposterias, por Unidad de obra terminada ( inciso 013.J) (EP-10)","m3",1669]
[{"$f":"IF(D85=\"\",\"\",COUNTA($D$14:D85))","v":34},"N.CTR.CAR.1.02.013/00","Demoliciones de concreto hidraulico simple o reforzado, por Unidad de obra terminada ( inciso 013.J)(EP-11)","m3",531.82000000000005]
[{"$f":"IF(D86=\"\",\"\",COUNTA($D$14:D86))","v":""},null,"TRABAJOS DIVERSOS"]
[{"$f":"IF(D87=\"\",\"\",COUNTA($D$14:D87))","v":""},null,"Revestimiento de cunetas , por Unidad de obra terminada (inciso 003.J)"]
[{"$f":"IF(D88=\"\",\"\",COUNTA($D$14:D88))","v":35},"N.CTR.CAR.1.03.003/00","Con concreto hidráulico simple de f'c=150 kg/cm2 con agregado de tamaño máximo de 38 mm (1 1/2\") (EP-12)","m3",551]
[{"$f":"IF(D89=\"\",\"\",COUNTA($D$14:D89))","v":36},"N.CTR.CAR.1.07.015/00","Cerco con poste de concreto y 4 (cuatro) hilos de alambre de puas calibre No.12 P.U.O.T. (EP-13), P.U.O.T","ml",53900]
[{"$f":"IF(D90=\"\",\"\",COUNTA($D$14:D90))","v":""},null,"Defensa metalica de tres crestas tipo AASHTO M-180,"]
[{"$f":"IF(D91=\"\",\"\",COUNTA($D$14:D91))","v":37},"N.CTR.CAR.1.07.009/00","incluyendo sus accesorios, por unidad de obra terminada P.U.O.T (EP-14)","ml",5880]
[{"$f":"IF(D92=\"\",\"\",COUNTA($D$14:D92))","v":38},"N.CTR.CAR.1.02.013/00","Desmantelamiento de defensa metalica de dos crestas,  P.U.O.T (E.P.15)","ml",1250]
[{"$f":"IF(D93=\"\",\"\",COUNTA($D$14:D93))","v":39},"N.CTR.CAR.1.02.013/00","Desmantelamiento y Rehubicacion de defensa metalica de tres crestas,  P.U.O.T (E.P.15)","ml",2400]
[{"$f":"IF(D94=\"\",\"\",COUNTA($D$14:D94))","v":40},"N.CTR.CAR.1.07.009/00","Terminal de Impacto para barrera, P.U.O.T","pza",40]
[{"$f":"IF(D95=\"\",\"\",COUNTA($D$14:D95))","v":41},"N.CTR.CAR.1.02.013/00","Desmantelamiento de cercado de derecho de via, P.U.O.T (E.P.16)","ml",53900]
[{"$f":"IF(D96=\"\",\"\",COUNTA($D$14:D96))","v":42},"N.CTR.CAR.1.02.013/00","Desmantelamiento de defensa metalica de dos crestas,  P.U.O.T (E.P.14)","ml",0]
[{"$f":"IF(D97=\"\",\"\",COUNTA($D$14:D97))","v":43},"N.CTR.CAR.1.02.013/00","Desmantelamiento y Rehubicacion de defensa metalica de tres crestas,  P.U.O.T (E.P.14)","ml",0]
[{"$f":"IF(D98=\"\",\"\",COUNTA($D$14:D98))","v":44},"N.CTR.CAR.1.02.010/00","Concreto hidraulico de f'c = 250 kg/cm² en Banquetas, P.U.O.T. (E.P.17)","m3",135]
[{"$f":"IF(D99=\"\",\"\",COUNTA($D$14:D99))","v":45},"N.CTR.CAR.1.02.010/00","Concreto hidraulico de f'c = 250 kg/cm² en Guarniciones, P.U.O.T. (E.P.18)","m3",135]
[null,null,"Lavaderos  (inciso 006.J) de concreto hidraulico simple de f´c= 150 kg/cm2"]
[null,"N.CTR.CAR.1.03.006/00","con agregado de tamaño maximo de 38 mm ( 1 1/2\"), P.O.U.T.(EP-09)","m3",66]
[{"$f":"IF(D102=\"\",\"\",COUNTA($D$14:D102))","v":47},"N.CTR.CAR.1.07.010/00","Barrera Tipo New Jersey, P.U.O.T","pza",289]
[{"$f":"IF(D103=\"\",\"\",COUNTA($D$14:D103))","v":48},null,"Suministro y colocacion de caseta de espera en paradero de autobuses, P.U.O.T. (E.P. 19)","pza",11]
[{"$f":"IF(D104=\"\",\"\",COUNTA($D$14:D104))","v":""},null,"PAVIMENTOS N.CTR.CAR.1.04",null,"."]
[{"$f":"IF(D105=\"\",\"\",COUNTA($D$14:D105))","v":""},null,"Bases, Por Unidad de Obra Terminada "]
[{"$f":"IF(D106=\"\",\"\",COUNTA($D$14:D106))","v":""},null,"Base modificada con cemento Portland con espesor indicado en el  proyecto, con resistencia a la compresion simple"]
[{"$f":"IF(D107=\"\",\"\",COUNTA($D$14:D107))","v":49},"N.CTR.CAR.1.04.002/11","(f´c) de 25 kg/cm2, obtenida a los 28 dias de edad, compactada al 100%, P.U.O.T. (E.P. 20) (inciso 003.J)","m3",132693]
[{"$f":"IF(D108=\"\",\"\",COUNTA($D$14:D108))","v":""},null,"Cemento Portland  Compuesto Puzolanico (CPC o CPP) para modificar base (nueva), en una proporcion aproximada "]
[{"$f":"IF(D109=\"\",\"\",COUNTA($D$14:D109))","v":50},"N.CMT.2.02.001/02","de 6% con respecto al PVSM del material petreo. P.U.O.T. (E.P. 21)","kg",17515476]
[{"$f":"IF(D110=\"\",\"\",COUNTA($D$14:D110))","v":""},null,"MATERIALES ASFALTICOS"]
[{"$f":"IF(D111=\"\",\"\",COUNTA($D$14:D111))","v":""},null,"Materiales asfálticos, por unidad de obra terminada:"]
[{"$f":"IF(D112=\"\",\"\",COUNTA($D$14:D112))","v":""},null,"Emulsiones asfálticas,Empleadas en riegos:"]
[{"$f":"IF(D113=\"\",\"\",COUNTA($D$14:D113))","v":51},"N.CTR.CAR.1.01.012/00","Emulsión asfaltica ECI-60 en riego de impregnación en la base P.U.O.T. (inciso 004.J)","lt",1075041]
[null,"N.CTR.CAR.1.04.004/00","Barrido sobre la superficie  de la base por tratrar P.U.O.T. (inciso 004.J).","ha",70]
[{"$f":"IF(D115=\"\",\"\",COUNTA($D$14:D115))","v":""},null,"Remate de losas de pavimento de concreto hidraulico con material producto de los despalmes y "]
[{"$f":"IF(D116=\"\",\"\",COUNTA($D$14:D116))","v":53},"N.CTR.CAR.1.04.003/14","desmontes compactado al 90% P.U.O.T. (E.P. 22)","m3",5070]
[null,null,null,null,null,null,"SUMA:",{"$f":"SUM(H68:H116)","v":0}]
[null,null,null,null,null,null,"ACUMULADO:",{"$f":"H117+H67","v":0}]
[{"$f":"IF(D119=\"\",\"\",COUNTA($D$14:D119))","v":""},null,"CARPETAS DE CONCRETO HIDRAULICO"]
[{"$f":"IF(D120=\"\",\"\",COUNTA($D$14:D120))","v":""},null,"Losa de concreto hidraulico con modulo de ruptura a la flexion de 48 kg/cm2, obtenido a los 28 dias de edad, "]
[{"$f":"IF(D121=\"\",\"\",COUNTA($D$14:D121))","v":54},"N.CTR.CAR.1.04.009/06"," P.U.O.T.  (inciso 009.J) y (E.P. 23)","m3",192744]
[{"$f":"IF(D122=\"\",\"\",COUNTA($D$14:D122))","v":""},null,"SEÑALAMIENTO N.CTR.CAR.1.07"]
[{"$f":"IF(D123=\"\",\"\",COUNTA($D$14:D123))","v":""},null,"Recubrimiento con pintura termoplástica con microsesferas de vidrio"]
[{"$f":"IF(D124=\"\",\"\",COUNTA($D$14:D124))","v":""},null,"Recubrimiento de superficies, por unidad de obra terminada (inciso 001.J y EP-24).(N.PRY.CAR.10.01.002/13)"]
[{"$f":"IF(D125=\"\",\"\",COUNTA($D$14:D125))","v":""},null,"M-1 Raya separadora de sentidos de circulación"]
[{"$f":"IF(D126=\"\",\"\",COUNTA($D$14:D126))","v":55},"N.CTR.CAR.1.07.001/00","M-1.6  Raya central continua doble para separar los dos sentidos de circulacion","ml",24000]
[{"$f":"IF(D127=\"\",\"\",COUNTA($D$14:D127))","v":""},null,"M-2, Rayas separadoras de carriles."]
[{"$f":"IF(D128=\"\",\"\",COUNTA($D$14:D128))","v":56},"N.CTR.CAR.1.07.001/00","M-2.3 Raya discontinua sencilla color blanco reflejante de 15 cm. de ancho.  (longitud efectiva)","ml",4000]
[{"$f":"IF(D129=\"\",\"\",COUNTA($D$14:D129))","v":""},null,"M-3, Rayas en la orilla de la calzada, "]
[{"$f":"IF(D130=\"\",\"\",COUNTA($D$14:D130))","v":57},"N.CTR.CAR.1.07.001/00","M-3.1 Raya en la orilla derecha continua color blanco reflejante de 15 cm de ancho. (longitud efectiva)","ml",4000]
[{"$f":"IF(D131=\"\",\"\",COUNTA($D$14:D131))","v":58},"N.CTR.CAR.1.07.001/00","M-3.2 Raya en la orilla derecha discontinua, color blanco de 15 cm de ancho. (longitud efectiva)","ml",26000]
[{"$f":"IF(D132=\"\",\"\",COUNTA($D$14:D132))","v":59},"N.CTR.CAR.1.07.001/00","M-3.3 Raya en la orilla izquierda continua color amarillo reflejante de 15 cm de ancho. (longitud efectiva)","ml",10000]
[{"$f":"IF(D133=\"\",\"\",COUNTA($D$14:D133))","v":""},null,"M-4 Raya Separadora de carriles"]
[{"$f":"IF(D134=\"\",\"\",COUNTA($D$14:D134))","v":60},"N.CTR.CAR.1.07.001/00","M-4 Raya Separadora de carriles discontinua sencilla.  (longitud efectiva)","ml",5880]
[{"$f":"IF(D135=\"\",\"\",COUNTA($D$14:D135))","v":""},null,"Señalamiento vertical en carreteras P.U.O.T. (EP-25) "]
[{"$f":"IF(D136=\"\",\"\",COUNTA($D$14:D136))","v":""},null,"SII, Señales informativas de identificación"]
[{"$f":"IF(D137=\"\",\"\",COUNTA($D$14:D137))","v":61},"N.CTR.CAR.1.07.005/00","SII-14, Kilometraje con ruta. De 30 x 120 cm.","pza",12]
[{"$f":"IF(D138=\"\",\"\",COUNTA($D$14:D138))","v":62},"N.CTR.CAR.1.07.005/00","SII-15, Kilometraje sin ruta. De 30 x 76 cm.","pza",46]
[{"$f":"IF(D139=\"\",\"\",COUNTA($D$14:D139))","v":""},null,"SR, Señales restrictivas"]
[{"$f":"IF(D140=\"\",\"\",COUNTA($D$14:D140))","v":63},"N.CTR.CAR.1.07.005/00","SR-09, De Velocidad: de 117 x 117 cm con tablero adicional de 35x86.","pza",31]
[{"$f":"IF(D141=\"\",\"\",COUNTA($D$14:D141))","v":64},"N.CTR.CAR.1.07.005/00","SR-12, Señal solo Vuelta a la izquierda 117 x 117 cm.","pza",10]
[{"$f":"IF(D142=\"\",\"\",COUNTA($D$14:D142))","v":65},"N.CTR.CAR.1.07.005/00","SR-13, Conserve su derecha: de 117 x 117 cm.","pza",9]
[{"$f":"IF(D143=\"\",\"\",COUNTA($D$14:D143))","v":66},"N.CTR.CAR.1.07.005/00","SR-25, Retorno: de 117 x 117 cm.","pza",10]
[{"$f":"IF(D144=\"\",\"\",COUNTA($D$14:D144))","v":67},"N.CTR.CAR.1.07.005/00","SR-34, Cinturon de seguridad: De 117 x 117 cm.","pza",8]
[{"$f":"IF(D145=\"\",\"\",COUNTA($D$14:D145))","v":""},null,"SP, Señales preventivas"]
[{"$f":"IF(D146=\"\",\"\",COUNTA($D$14:D146))","v":68},"N.CTR.CAR.1.07.005/00","SP - 6  Señal Preventiva de curva de 117 x 117","pza",16]
[{"$f":"IF(D147=\"\",\"\",COUNTA($D$14:D147))","v":69},"N.CTR.CAR.1.07.005/00","SP - 8  Señal Preventiva de curva inversa 117 x 117","pza",4]
[{"$f":"IF(D148=\"\",\"\",COUNTA($D$14:D148))","v":70},"N.CTR.CAR.1.07.005/00","SP - 11  Señal Preventiva Interseccion a nivel de 117 x 117","pza",4]
[{"$f":"IF(D149=\"\",\"\",COUNTA($D$14:D149))","v":71},"N.CTR.CAR.1.07.005/00","SP - 12  Señal Preventiva de entronque en \"T\" de 117 x 117","pza",16]
[{"$f":"IF(D150=\"\",\"\",COUNTA($D$14:D150))","v":72},"N.CTR.CAR.1.07.005/00","SP - 17  Señal Incorporacion de Transito 117 x 117","pza",2]
[{"$f":"IF(D151=\"\",\"\",COUNTA($D$14:D151))","v":73},"N.CTR.CAR.1.07.005/00","SP - 19  Señal de Salida de 117 x 117","pza",2]
[{"$f":"IF(D152=\"\",\"\",COUNTA($D$14:D152))","v":74},"N.CTR.CAR.1.07.005/00","SP - 32  Señal Preventiva de Peatones de 117 x 117","pza",14]
[{"$f":"IF(D153=\"\",\"\",COUNTA($D$14:D153))","v":75},"N.CTR.CAR.1.07.005/00","SP - 41  Señal Preventiva de Tope de 117 x 117","pza",12]
[{"$f":"IF(D154=\"\",\"\",COUNTA($D$14:D154))","v":""},null,"SID, Señales de informacion de destino"]
[{"$f":"IF(D155=\"\",\"\",COUNTA($D$14:D155))","v":76},"N.CTR.CAR.1.07.005/00","SID-08, Acceso a poblado: De 56 x 300 cm.","pza",11]
[{"$f":"IF(D156=\"\",\"\",COUNTA($D$14:D156))","v":77},"N.CTR.CAR.1.07.005/00","SID-09, Señal de entronque: De 56 x 300 cm.","pza",1]
[{"$f":"IF(D157=\"\",\"\",COUNTA($D$14:D157))","v":78},"N.CTR.CAR.1.07.005/00","SID-11, Confirmativa de un tableros: De 56 x 300 cm.","pza",23]
[{"$f":"IF(D158=\"\",\"\",COUNTA($D$14:D158))","v":79},"N.CTR.CAR.1.07.006/00","SID-13, tipo bandera: De 122 x 366 cm.","pza",3]
[{"$f":"IF(D159=\"\",\"\",COUNTA($D$14:D159))","v":""},null,"SIR, Señales de recomendación (No circular por acotamiento, No Maneje Cansado, etc.)"]
[{"$f":"IF(D160=\"\",\"\",COUNTA($D$14:D160))","v":80},"N.CTR.CAR.1.07.005/00","SIR- de 86 x 300 cm","pza",14]
[{"$f":"IF(D161=\"\",\"\",COUNTA($D$14:D161))","v":""},null,"SIS - Señal informativa de servicios (mecanico, restaurant, gasolineras, hotel, cruz roja, etc)"]
[{"$f":"IF(D162=\"\",\"\",COUNTA($D$14:D162))","v":81},"N.CTR.CAR.1.07.005/00","SIS-19, Parada de autobus 117 x 117 con tablero adicional 35 x 117","pza",4]
[{"$f":"IF(D163=\"\",\"\",COUNTA($D$14:D163))","v":82},null,"SIS-19, Parada de autobus de 117 x 117","pza",42]
[{"$f":"IF(D164=\"\",\"\",COUNTA($D$14:D164))","v":83},null,"SIS-Conjunto 2 modulos,4 servicios de 71 x 71, con tablero adicional 35 x 117","pza",2]
[{"$f":"IF(D165=\"\",\"\",COUNTA($D$14:D165))","v":""},null,"OD-5, Indicador de obstáculo."]
[{"$f":"IF(D166=\"\",\"\",COUNTA($D$14:D166))","v":84},"N.CTR.CAR.1.07.005/00","OD-5, Indicador de obstáculo tipo bifurcación 61 x 122 cm","pza",3]
[{"$f":"IF(D167=\"\",\"\",COUNTA($D$14:D167))","v":""},null,"OD-6 Indicadores de alineamiento (EP-26)."]
[{"$f":"IF(D168=\"\",\"\",COUNTA($D$14:D168))","v":""},"N.CTR.CAR.1.07.005/00","OD-6, Indicadores de alineamiento:"]
[{"$f":"IF(D169=\"\",\"\",COUNTA($D$14:D169))","v":85},"N.CTR.CAR.1.07.005/00","Indicadores de alineamiento de lamina P.U.O.T.","pza",3620]
[{"$f":"IF(D170=\"\",\"\",COUNTA($D$14:D170))","v":""},"N.CTR.CAR","OD-7, Vialetas (EP-27)."]
[{"$f":"IF(D171=\"\",\"\",COUNTA($D$14:D171))","v":""},"N.CTR.CAR.1.07.004/02","En la orilla izquierda de la calzada color amarillo (DH-1.6b) con reflejante en dos cara"]
[null,null,null,null,null,null,"SUMA:",{"$f":"SUM(H119:H171)","v":0}]
[null,null,null,null,null,null,"ACUMULADO:",{"$f":"H172+H118","v":0}]
[{"$f":"IF(D174=\"\",\"\",COUNTA($D$14:D174))","v":86},null,"por unidad de obra terminada : De 100 x 100 mm.  ","pza",2948]
[{"$f":"IF(D175=\"\",\"\",COUNTA($D$14:D175))","v":""},"N.CTR.CAR.1.07.004/02","Al centro de la calzada color blanco (DH-1.9) con reflejante en una cara,"]
[{"$f":"IF(D176=\"\",\"\",COUNTA($D$14:D176))","v":87},null,"por unidad de obra terminada : De 100 x 100 mm.  ","pza",7104]
[{"$f":"IF(D177=\"\",\"\",COUNTA($D$14:D177))","v":""},"N.CTR.CAR.1.07.004/02","En la orilla de la calzada derecha color blanco (DH-1.12),  con reflejante en dos caras"]
[{"$f":"IF(D178=\"\",\"\",COUNTA($D$14:D178))","v":88},null,"por unidad de obra terminada : De 100 x 100 mm.  ","pza",5896]
[{"$f":"IF(D179=\"\",\"\",COUNTA($D$14:D179))","v":""},"N.CTR.CAR.1.07.004/02","En la orilla derecha de la calzada color blanco (DH-1.13) con reflejante en una cara,"]
[{"$f":"IF(D180=\"\",\"\",COUNTA($D$14:D180))","v":89},null,"por unidad de obra terminada : De 100 x 100 mm.  ","pza",1340]
[{"$f":"IF(D181=\"\",\"\",COUNTA($D$14:D181))","v":""},"N.CTR.CAR.1.07.004/02","En la orilla izquierda de la calzada color amarillo (DH-1.14) con reflejante en una cara"]
[{"$f":"IF(D182=\"\",\"\",COUNTA($D$14:D182))","v":90},null,"por unidad de obra terminada : De 100 x 100 mm.  ","pza",1340]
[{"$f":"IF(D183=\"\",\"\",COUNTA($D$14:D183))","v":91},"N.CTR.CAR.1.07.003/00","OD-15  Señal de Reductor de velocidad (Topes)","pza",3]
[{"$f":"IF(D184=\"\",\"\",COUNTA($D$14:D184))","v":92},"N.CTR.CAR.1.02.013/00","Desmantelamiento de señales verticales bajas existentes, por unidad de obra terminada (E.P  28)","pza",208]
[{"$f":"IF(D185=\"\",\"\",COUNTA($D$14:D185))","v":93},"N.CTR.CAR.1.02.013/00","Desmantelamiento de señales verticales elevadas existentes, por unidad de obra terminada (E.P  29)","pza",7]
[{"$f":"IF(D186=\"\",\"\",COUNTA($D$14:D186))","v":""},null,"ESTRUCTURAS  N.CTR.CAR.1.02"]
[{"$f":"IF(D187=\"\",\"\",COUNTA($D$14:D187))","v":""},null,"INFRAESTRUCTURA"]
[{"$f":"IF(D188=\"\",\"\",COUNTA($D$14:D188))","v":""},null,"SUBESTRUCTURA"]
[{"$f":"IF(D189=\"\",\"\",COUNTA($D$14:D189))","v":""},null,"PILOTES COLADOS EN EL LUGAR (E.P. 30)"]
[{"$f":"IF(D190=\"\",\"\",COUNTA($D$14:D190))","v":""},null,"Concreto de f'c = 250 kg/cm²  en pilotes colados en el lugar de 1.20 m. de diametro  dentro de "]
[{"$f":"IF(D191=\"\",\"\",COUNTA($D$14:D191))","v":94},"N.CTR.CAR.1.06.003/01","una perforacion previa en cualquier tipo de materia l, P.U.O.T. (inciso 003.J)","m3",863]
[{"$f":"IF(D192=\"\",\"\",COUNTA($D$14:D192))","v":95},"N.CTR.CAR.1.02.003/04","Plantilla de concreto  f'c = 100 kg/cm2 P.U.O.T.","m3",14]
[{"$f":"IF(D193=\"\",\"\",COUNTA($D$14:D193))","v":""},null,"EXCAVACION PARA ESTRUCTURAS"]
[{"$f":"IF(D194=\"\",\"\",COUNTA($D$14:D194))","v":96},"N.CTR.CAR.1.01.007/11","Excavaciones para estructuras P.U.O.T.(inciso 007.J)","m3",383]
[{"$f":"IF(D195=\"\",\"\",COUNTA($D$14:D195))","v":""},null,"CONCRETO HIDRAULICO"]
[{"$f":"IF(D196=\"\",\"\",COUNTA($D$14:D196))","v":""},null,"Concreto hidraulico de  f'c=250 kg/cm²  (Inciso 003.J) colado en seco:"]
[{"$f":"IF(D197=\"\",\"\",COUNTA($D$14:D197))","v":97},"N.CTR.CAR.1.02.003/04","Cabezales, Diafragmas, Pantallas, Bancos y Topes, P.U.O.T","m3",1298]
[{"$f":"IF(D198=\"\",\"\",COUNTA($D$14:D198))","v":98},"N.CTR.CAR.1.02.003/04","Coronas, bancos de estribos, muro, pantalla, topes, P.U.O.T","m3",530]
[{"$f":"IF(D199=\"\",\"\",COUNTA($D$14:D199))","v":99},"N.CTR.CAR.1.02.003/04","Zapatas P.U.O.T.","m3",28]
[{"$f":"IF(D200=\"\",\"\",COUNTA($D$14:D200))","v":100},"N.CTR.CAR.1.02.003/04","Pilas y/o Columnas P.U.O.T  (E.P. 31)","m3",126]
[{"$f":"IF(D201=\"\",\"\",COUNTA($D$14:D201))","v":101},"N.CTR.CAR.1.02.003/04","Cuerpo y aleros de estribos P.U.O.T. (E.P. 31)","m3",54]
[{"$f":"IF(D202=\"\",\"\",COUNTA($D$14:D202))","v":102},"N.CTR.CAR.1.02.003/04","Ciclopeo de f´c= 150 kg/cm2 en estribos y aleros, P.U.O.T (E.P. 31)","m3",50]
[{"$f":"IF(D203=\"\",\"\",COUNTA($D$14:D203))","v":""},null,"ACERO PARA CONCRETO HIDRAULICO"]
[{"$f":"IF(D204=\"\",\"\",COUNTA($D$14:D204))","v":""},null,"Acero de refuerzo, P.U.O.T. en Subestructura (Inciso 004.J)"]
[{"$f":"IF(D205=\"\",\"\",COUNTA($D$14:D205))","v":103},"N.CTR.CAR.1.02.004/02","Varillas de limite elastico igual o mayor de 4200 Kg/cm²","Kg",192362]
[null,null,"Conector extrusionado para varilla 8c Mexpresa","pza",160]
[{"$f":"IF(D207=\"\",\"\",COUNTA($D$14:D207))","v":105},"N.CMT.2.08/15","Apoyos integrales de neopreno, P.U.O.T. (E.P. 32)","dm3",58]
[{"$f":"IF(D208=\"\",\"\",COUNTA($D$14:D208))","v":""},null,"SUPERESTRUCTURA"]
[{"$f":"IF(D209=\"\",\"\",COUNTA($D$14:D209))","v":""},null,"ESTRUCTURAS DE CONCRETO PRESFORZADO  N.CTR.CAR.1.02.007/01"]
[{"$f":"IF(D210=\"\",\"\",COUNTA($D$14:D210))","v":106},"N.CTR.CAR.1.02.007/01","Trabes y tabletas de concreto hidraulico presforzadas de f'c=350 kg/cm²,según proyecto P.U.O.T. (E.P. 33)","m3",1833]
[{"$f":"IF(D211=\"\",\"\",COUNTA($D$14:D211))","v":107},"N.CTR.CAR.1.02.007/01","Montaje de elementos estructurales presforzados trabes tipo aashto P.U.O.T.(Inciso 007.J y E.P. 34)","pza",28]
[{"$f":"IF(D212=\"\",\"\",COUNTA($D$14:D212))","v":108},"N.CTR.CAR.1.02.007/01","Montaje de elementos estructurales presforzados trabes tipo tabletas P.U.O.T.(Inciso 007.J y E.P. 34)","pza",336]
[{"$f":"IF(D213=\"\",\"\",COUNTA($D$14:D213))","v":""},null,"CONCRETO HIDRAULICO"]
[{"$f":"IF(D214=\"\",\"\",COUNTA($D$14:D214))","v":109},"N.CTR.CAR.1.02.003/04","Concreto hidraulico de f'c = 250 kg/cm² en losas y diafragmas P.U.O.T.(inciso 003.J)","m3",659]
[{"$f":"IF(D215=\"\",\"\",COUNTA($D$14:D215))","v":110},"N.CMT.2.08/15","Apoyos integrales de neopreno ASTM D2240, Dureza SHORE 60 P.U.O.T.(E.P. 32)","dm3",1084]
[{"$f":"IF(D216=\"\",\"\",COUNTA($D$14:D216))","v":""},null,"Drenes de plástico DURAFLEX \"D\" o similar, por unidad de obra terminada (E.P. 35):"]
[{"$f":"IF(D217=\"\",\"\",COUNTA($D$14:D217))","v":111},"N.CMT.3.04.003/05","De 76 milímetros de diámetro","pza",100]
[{"$f":"IF(D218=\"\",\"\",COUNTA($D$14:D218))","v":""},null,"ACERO PARA CONCRETO HIDRAULICO"]
[{"$f":"IF(D219=\"\",\"\",COUNTA($D$14:D219))","v":112},"N.CTR.CAR.1.02.004/02","Acero de refuerzo, P.U.O.T. (Inciso 004.J)","Kg",52276]
[{"$f":"IF(D220=\"\",\"\",COUNTA($D$14:D220))","v":113},"N.CTR.CAR.1.04.009/06","Carpeta de concreto hidraulico en superficie de rodamiento (inciso 009.J) (E.P. 36)","m3",145]
[{"$f":"IF(D221=\"\",\"\",COUNTA($D$14:D221))","v":114},"N.CTR.CAR.1.02.005/01","Varilla C para tensores con rosca en sus extremos, incluye accesorios, P.U.O.T. (E.P. 37)","Kg",500]
[{"$f":"IF(D222=\"\",\"\",COUNTA($D$14:D222))","v":""},null,"Juntas de dilatacion, P.U.O.T.(inciso 004.J)"]
[{"$f":"IF(D223=\"\",\"\",COUNTA($D$14:D223))","v":115},"N.CTR.CAR.1.02.004/02","Acero de Refuerzo, P.U.O.T.(Inciso 004.J)","kg",5407]
[{"$f":"IF(D224=\"\",\"\",COUNTA($D$14:D224))","v":116},"N.CTR.CAR.1.02.008/01","Acero Estructural A-36, P.U.O.T. en junta de dilatacion de losa.","kg",9862]
[{"$f":"IF(D225=\"\",\"\",COUNTA($D$14:D225))","v":117},null,"Sikaflex 1-A o material similar de 2 cm de espesor P.U.O.T. (E.P. 38)","dm2",50]
[null,null,null,null,null,null,"SUMA:",{"$f":"SUM(H174:H225)","v":0}]
[null,null,null,null,null,null,"ACUMULADO:",{"$f":"H226+H173","v":0}]
[]
[{"$f":"IF(D229=\"\",\"\",COUNTA($D$14:D229))","v":118},null,"Sikaflex 1-A o material similar de 4 cm de espesor P.U.O.T. (E.P. 38)","dm2",2308]
[{"$f":"IF(D230=\"\",\"\",COUNTA($D$14:D230))","v":119},null,"Cartón asfaltado, de 2 cm de espesor P.U.O.T. (inciso 026-H.11) (E.P. 39)","m2",41]
[{"$f":"IF(D231=\"\",\"\",COUNTA($D$14:D231))","v":120},null,"Cartón asfaltado, de 4 cm de espesor P.U.O.T. (inciso 026-H.11) (E.P. 39)","m2",350]
[{"$f":"IF(D232=\"\",\"\",COUNTA($D$14:D232))","v":""},null,"CONCRETO f'c = 250 kg/cm²  EN: (Inciso 003.J)"]
[{"$f":"IF(D233=\"\",\"\",COUNTA($D$14:D233))","v":121},"N.CTR.CAR.1.02.003/04","En Remate de parapeto, vigas y pilastras, P.U.O.T.","m3",32]
[{"$f":"IF(D234=\"\",\"\",COUNTA($D$14:D234))","v":122},"N.CTR.CAR.1.02.003/04","En guarniciones P.U.O.T.","m3",114]
[{"$f":"IF(D235=\"\",\"\",COUNTA($D$14:D235))","v":""},null,"ACERO PARA CONCRETO HIDRAULICO"]
[{"$f":"IF(D236=\"\",\"\",COUNTA($D$14:D236))","v":123},"N.CTR.CAR.1.02.004/02","Acero de refuerzo , P.U.O.T .(Inciso 004.J)","Kg",32333]
[{"$f":"IF(D237=\"\",\"\",COUNTA($D$14:D237))","v":""},null,"ESTRUCTURAS DE ACERO"]
[{"$f":"IF(D238=\"\",\"\",COUNTA($D$14:D238))","v":124},"N.CTR.CAR.1.02.009/00","Parapetos de acero estructural A-36, P.U.O.T. (E.P. 40+D206) según proyecto","ml",901]
[{"$f":"IF(D239=\"\",\"\",COUNTA($D$14:D239))","v":""},null,"CONOS DE DERRAME"]
[{"$f":"IF(D240=\"\",\"\",COUNTA($D$14:D240))","v":125},"N.CTR.CAR.1.06.003/01","Concreto hidraulico f'c = 150 kg/cm²  ,P.U.O.T. (inciso 003.J)","m3",388]
[{"$f":"IF(D241=\"\",\"\",COUNTA($D$14:D241))","v":126},null,"Malla electrosoldada de 6x6-3/3 P.U.O.T.","m2",3880]
[{"$f":"IF(D242=\"\",\"\",COUNTA($D$14:D242))","v":127},null,"Cartón asfaltado, de 2 cm de espesor P.U.O.T. (inciso 026-H.11) (E.P. 40)","m2",21]
[{"$f":"IF(D243=\"\",\"\",COUNTA($D$14:D243))","v":""},null,"LOSAS DE ACCESO"]
[{"$f":"IF(D244=\"\",\"\",COUNTA($D$14:D244))","v":128},"N.CTR.CAR.1.02.003/04","Concreto hidraulico f'c = 250 kg/cm²  ,P.U.O.T. (inciso 003.J)","m3",903]
[{"$f":"IF(D245=\"\",\"\",COUNTA($D$14:D245))","v":129},"N.CTR.CAR.1.02.004/02","Acero de refuerzo LE>= 4000 kg/cm2 P.U.O.T. (inciso 004.J)","kg",99164]
[{"$f":"IF(D246=\"\",\"\",COUNTA($D$14:D246))","v":130},null,"Cartón asfaltado, de 2 cm de espesor P.U.O.T. (inciso 026-H.11) (E.P. 41)","m2",288]
[{"$f":"IF(D247=\"\",\"\",COUNTA($D$14:D247))","v":""},null,"ACCESOS"]
[{"$f":"IF(D248=\"\",\"\",COUNTA($D$14:D248))","v":""},null,"TERRAPLENES DE ACCESO"]
[{"$f":"IF(D249=\"\",\"\",COUNTA($D$14:D249))","v":""},null,"Formacion y compactacion. P.U.O.T. (inciso 009.J)"]
[{"$f":"IF(D250=\"\",\"\",COUNTA($D$14:D250))","v":131},"N.CTR.CAR.1.01.009/11","Terraplenes de acceso compactados al 95%, (E.P. 42)","m3",120713]
[{"$f":"IF(D251=\"\",\"\",COUNTA($D$14:D251))","v":132},"N.CTR.CAR.1.01.009/11","de subrasante, al cien por ciento (100%) en terraplenes de acceso (E.P. 43)","m3",456]
[{"$f":"IF(D252=\"\",\"\",COUNTA($D$14:D252))","v":""},null,"CANALES"]
[{"$f":"IF(D253=\"\",\"\",COUNTA($D$14:D253))","v":""},null,"Excavación para canales, por unidad de obra terminada (inciso 005.J) "]
[{"$f":"IF(D254=\"\",\"\",COUNTA($D$14:D254))","v":""},null,"Cualesquiera que sea su clasificacion y profundidad."]
[{"$f":"IF(D255=\"\",\"\",COUNTA($D$14:D255))","v":133},"N.CTR.CAR.1.01.005/11","canales de entrada y salida P.U.O.T.","m3",3371]
[{"$f":"IF(D256=\"\",\"\",COUNTA($D$14:D256))","v":134},"N.CTR.CAR.1.02.013/00","Remocion de terraplenes y pavimentos en accesos P.U.O.T. (E.P. 44)","m3",72427]
[{"$f":"IF(D257=\"\",\"\",COUNTA($D$14:D257))","v":135},null,"Extraccion de azolves en estructuras","m3",29222]
[{"$f":"IF(D258=\"\",\"\",COUNTA($D$14:D258))","v":""},null,"Sub bases o bases, P.U.O.T. (074-H.041)"]
[{"$f":"IF(D259=\"\",\"\",COUNTA($D$14:D259))","v":136},"N.CTR.CAR.1.04.002/11","Subbase compactada al 100%, del banco que elija el contratista (incluye acarreos) (E.P.45)","m3",8455]
[{"$f":"IF(D260=\"\",\"\",COUNTA($D$14:D260))","v":137},"N.CTR.CAR.1.04.002/11","Base compactada al 100%, del banco que elija el contratista (incluye acarreos) (E.P.46)","m3",8455]
[{"$f":"IF(D261=\"\",\"\",COUNTA($D$14:D261))","v":""},null,"CONCRETO  f'c = 250 kg/cm²   (inciso 003.J) P.U.O.T.  COLADO EN SECO:"]
[{"$f":"IF(D262=\"\",\"\",COUNTA($D$14:D262))","v":138},"N.CTR.CAR.1.02.010/00","En guarniciones de acceso (E.P. 18)","m3",324]
[{"$f":"IF(D263=\"\",\"\",COUNTA($D$14:D263))","v":139},"N.CTR.CAR.1.02.004/02","Acero de refuerzo de L.E ≥ 4000 Kg/cm², P.U.O.T.","Kg",72893]
[{"$f":"IF(D264=\"\",\"\",COUNTA($D$14:D264))","v":""},null,"Defensa metalica de lámina galvanizada tipo AASHTO, incluyendo sus accesorios"]
[{"$f":"IF(D265=\"\",\"\",COUNTA($D$14:D265))","v":140},"N.CTR.CAR.1.07.009/00","de tres cretas, P.U.O.T. (E.P.14)","ml",3520]
[{"$f":"IF(D266=\"\",\"\",COUNTA($D$14:D266))","v":""},null,"TRABAJOS DIVERSOS"]
[{"$f":"IF(D267=\"\",\"\",COUNTA($D$14:D267))","v":""},null,"Lavaderos (E.P. 09):"]
[{"$f":"IF(D268=\"\",\"\",COUNTA($D$14:D268))","v":""},null,"de concreto hidraulico, P.U.O.T. (inciso 006.J) de f'c = 150 kg/cm²  t.m.a. 19 mm"]
[{"$f":"IF(D269=\"\",\"\",COUNTA($D$14:D269))","v":141},"N.CTR.CAR.1.03.006/00","(3/4\") reforzado con malla electro soldada No. 6-6 de 10 x 10 cm","m3",47]
[{"$f":"IF(D270=\"\",\"\",COUNTA($D$14:D270))","v":""},null,"DEMOLICIONES"]
[{"$f":"IF(D271=\"\",\"\",COUNTA($D$14:D271))","v":""},null,"Demoliciones, por unidad de obra terminada (inciso 013.J)"]
[{"$f":"IF(D272=\"\",\"\",COUNTA($D$14:D272))","v":142},"N.CTR.CAR.1.02.013/00","De mamposteria de tercera clase con mortero de cemento","m3",1618]
[{"$f":"IF(D273=\"\",\"\",COUNTA($D$14:D273))","v":143},"N.CTR.CAR.1.02.013/00","De concreto hidraulico reforzado","m3",2002]
[{"$f":"IF(D274=\"\",\"\",COUNTA($D$14:D274))","v":144},"N.CTR.CAR.1.02.013/00","Demoliciones de zampeados de mamposteria con mortero de cemento","m3",74]
[{"$f":"IF(D275=\"\",\"\",COUNTA($D$14:D275))","v":""},null,"SEÑALAMIENTO VERTICAL (E.P. 25)"]
[{"$f":"IF(D276=\"\",\"\",COUNTA($D$14:D276))","v":145},"N.CTR.CAR.1.07.006/00","Señal SIG 8 \"PUENTE \" \" DE 40 X 239 CM. P.U.O.T.","pza",22]
[null,null,null,null,null,null,"TOTAL :",{"$f":"SUM(H228:H276)","v":0}]
[null,null,null,null,null,null,"ACUMULADO",{"$f":"H277+H227","v":0}]
[{"$f":"\"ESTA RELACION COMPRENDE \"&A276&\" CONCEPTOS\"","v":"ESTA RELACION COMPRENDE 145 CONCEPTOS"},null,null,null,null,null,"I.V.A. (16%):",{"$f":"H278*0.16","v":0}]
[null,null,null,null,null,null,"TOTAL :",{"$f":"H279+H278","v":0}]
["NOMBRE Y CARGO DEL SIGNATARIO"]