{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Acta Est. Obra","Datos","Anexa","Cont 9 art","Cont 11 art","Cont-Transcrip.Corrida","Art. 29","Reaj.","Cert. Constructor","Importe","Cálculos","Inf.Tec-","INF.TEC-POR M2","R-115U"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":25,"comments":2,"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":"Acta Est. Obra","index":0,"n_rows":66,"n_cols":7,"rows_kept":66,"cut":false,"hidden":false,"merged":[[64,4,64,5],[64,0,64,1],[0,1,0,6],[63,0,63,1],[63,4,63,5],[1,1,1,6]]}
[]
[]
[]
[]
[]
[]
["ANEXO DE LA RESOLUCION Nº 46 / 91"]
["ACTA DE ESTADO DE OBRA"]
[]
["REFERENCIA:",{"$f":"Datos!K44","v":0}]
["OBRA CALLE:",{"$f":"Datos!K45","v":0},{"$f":"Datos!K46","v":0},{"$f":"Datos!K47","v":0},null,"Partido de",{"$f":"Datos!K48","v":0}]
["PROPIETARIO:",{"$f":"Datos!K29","v":0}]
["DOMICILIO:",{"$f":"Datos!K32","v":0},null,{"$f":"Datos!K33","v":0},"Partido de",{"$f":"Datos!K35","v":0}]
["PROFESIONAL:",{"$f":"Datos!K18","v":0}]
["DOMICILIO:",{"$f":"Datos!K20","v":0},{"$f":"Datos!K21","v":0},{"$f":"Datos!K22","v":0},null,"Partido de",{"$f":"Datos!K23","v":0}]
[]
["ITEM",null,null,"% ITEM","% EJECUT.","% REAL","OBSERVAC."]
[]
["01) Preparación del terreno,repl.,excav.",null,null,1,1,{"$f":"D19*E19/100","v":0.01},"BUENO"]
["02) Mampostería cimientos y elevación",null,null,18,1,0.18,"BUENO"]
["03) Capas aisladoras",null,null,1,1,0.01,"BUENO"]
["04) Estructura de techos",null,null,14,1,0.14000000000000001,"BUENO"]
["05) Cubierta de techos",null,null,3,1,0.03,"BUENO"]
["06) Revoques gruesos / impermeables",null,null,6,1,0.06,"BUENO"]
["07) Contrapisos",null,null,1,1,0.01,"BUENO"]
["08) Inst. sanitaria"]
["     a- Cloacas",null,null,3,1,{"$f":"D27*E27/100","v":0.03},"BUENO"]
["     b- Agua fría",null,null,3,1,{"$f":"D28*E28/100","v":0.03},"BUENO"]
["     c- Agua caliente",null,null,3,1,{"$f":"D29*E29/100","v":0.03},"BUENO"]
["09) Inst. de gas",null,null,2,1,{"$f":"D30*E30/100","v":0.02},"BUENO"]
["10) Inst. eléctrica"]
["     a- Cañerías",null,null,1,1,{"$f":"D32*E32/100","v":0.01},"BUENO"]
["     b- Llaves y conductos",null,null,1,1,0.01,"BUENO"]
["11) Cielorrasos",null,null,2,1,0.02,"BUENO"]
["12) Revoques finos y/o de frentes",null,null,4,1,0.04,"BUENO"]
["13) Pisos y zócalos",null,null,8,1,0.08,"BUENO"]
["14) Revestimientos",null,null,4,1,0.04,"BUENO"]
["15) Artefactos cocina y baño",null,null,4,1,0.04,"BUENO"]
["16) Carpintería"]
["     a- Marcos",null,null,3,1,{"$f":"D40*E40/100","v":0.03},"BUENO"]
["     b- Hojas y herrajes",null,null,5,1,0.05,"BUENO"]
["17) Herrería",null,null,3,1,0.03,"BUENO"]
["18) Pintura",null,null,4,1,0.04,"BUENO"]
["19) Vidrios",null,null,1,1,0.01,"BUENO"]
["29) Cercos y veredas",null,null,3,1,0.03,"BUENO"]
["21) Detalles de terminación",null,null,2,1,0.02,"BUENO"]
[]
[null,null,null,{"$f":"D19+D20+D21+D22+D23+D24+D25+D27+D28+D29+D30+D32+D33+D34+D35+D36+D37+D38+D40+D41+D42+D43+D44+D45+D46","v":100},null,{"$f":"SUM(F19:F47)","v":1.0000000000000002},"BUENO"]
[]
["POR CONSIGUIENTE, EL TRABAJO REALIZADO EN OBRA ASCIENDE A  :",null,null,null,null,{"$f":"F48","v":1.0000000000000002}]
[]
["El Profesional declara bajo juramento que la presente acta de estado de obra ha sido cumplimentada de"]
["acuerdo con los hechos existentes realizados a la fecha y ",null,null,null,{"$f":"Datos!D71","v":"no"},"será responsable de la "]
["terminación de los trabajos faltantes."]
["El Propietario y el Profesional, autorizan al Colegio de Técnicos de la Provincia de Buenos Aires a inspec-"]
["cionar la obra a los fines de verificar los estados de obra declarados."]
["Se  firma en","3    ejemplares","el día",{"$f":"Datos!K38","v":0},null,"del mes de",{"$f":"Datos!K40","v":0}]
["del   año",{"$f":"Datos!K41","v":0},"."]
[]
[]
[]
[]
[]
["COMITENTE:",null,null,null,"PROFESIONAL:  "]
[{"$f":"Datos!K29","v":0},null,null,null,{"$f":"Datos!K18","v":0}]
[null,null,null,null,"MAT. CTPBA",{"$f":"Datos!K26","v":0}]

{"sheet":"Datos","index":1,"n_rows":166,"n_cols":55,"rows_kept":166,"cut":false,"hidden":false,"merged":[[108,1,108,2],[144,6,144,8],[108,11,108,14],[113,7,113,10],[114,3,114,4],[120,5,120,6],[115,5,115,6],[113,5,113,6],[128,10,128,16],[119,5,119,6],[118,5,118,6],[109,3,109,6],[144,1,144,5],[114,7,114,10],[122,7,122,10],[115,7,115,10],[138,1,138,6],[144,10,144,21],[136,7,136,21],[138,7,138,21],[137,7,137,9],[136,1,136,6],[135,5,135,21],[116,11,116,14],[91,11,91,14],[100,17,100,21],[101,17,101,21],[106,17,106,21],[102,14,102,21],[109,11,109,14],[109,17,109,21],[106,11,106,14],[153,10,153,21],[145,10,145,21],[121,7,121,10],[120,7,120,10],[133,19,133,21],[128,7,128,9],[121,12,121,14],[124,11,124,14],[134,1,134,9],[133,7,133,13],[134,14,134,21],[128,17,128,21],[130,15,130,18],[130,19,130,21],[129,5,129,21],[121,15,121,18],[107,17,107,21],[99,4,99,6],[97,11,97,14],[102,4,102,5],[164,17,164,21],[162,17,162,21],[161,17,161,21],[161,15,161,16],[162,15,162,16],[157,10,157,21],[121,1,121,5],[165,17,165,21],[120,18,120,21],[163,15,163,16],[117,5,117,6],[165,15,165,16],[160,10,160,16],[155,10,155,21],[163,17,163,21],[108,27,108,28],[148,1,148,5],[137,4,137,5],[134,11,134,13],[148,10,148,21],[159,10,159,21],[158,10,158,21],[156,10,156,21],[108,3,108,6],[133,14,133,18],[163,1,163,11],[119,18,119,21],[124,15,124,16],[114,17,114,21],[149,10,149,21],[164,15,164,16],[153,2,153,8],[152,6,152,8],[152,10,152,21],[125,19,125,21],[122,11,122,14],[151,10,151,21],[152,1,152,5],[147,10,147,21],[146,10,146,21],[148,6,148,8],[150,10,150,21],[142,10,142,21],[143,10,143,21],[141,10,141,21],[101,7,101,8],[119,7,119,10],[117,7,117,10],[98,4,98,6],[99,7,99,8],[106,3,106,6],[102,8,102,10],[101,4,101,6],[116,7,116,10],[118,7,118,10],[81,3,81,6],[90,3,90,6],[90,11,90,14],[86,3,86,6],[86,11,86,14],[96,17,96,21],[83,11,83,14],[100,4,100,6],[100,7,100,10],[87,3,87,6],[83,3,83,6],[91,3,91,6],[85,8,85,10],[95,3,95,6],[99,17,99,21],[99,11,99,13],[95,11,95,14],[82,3,82,6],[82,11,82,14],[85,6,85,7],[81,17,81,21],[84,17,84,21],[82,17,82,21],[81,11,81,14],[87,27,87,28],[32,10,32,21],[44,10,44,21],[45,10,45,21],[46,10,46,21],[33,10,33,21],[34,10,34,21],[36,10,36,21],[56,10,56,21],[50,23,50,24],[63,23,63,24],[68,17,68,21],[70,9,70,11],[70,14,70,15],[74,11,74,14],[72,11,72,14],[54,10,54,21],[58,13,58,17],[70,17,70,21],[59,10,59,21],[58,10,58,12],[63,10,63,11],[79,17,79,21],[79,11,79,14],[45,23,45,24],[40,10,40,21],[41,10,41,21],[43,10,43,21],[57,10,57,21],[78,11,78,14],[59,23,59,24],[30,23,30,24],[33,23,33,24],[80,3,80,6],[62,10,62,11],[69,17,69,21],[47,10,47,21],[48,10,48,21],[72,17,72,21],[76,5,76,19],[77,3,77,6],[63,1,63,9],[73,11,73,14],[77,11,77,14],[74,3,74,6],[70,4,70,5],[68,3,68,6],[73,3,73,6],[66,3,66,6],[67,3,67,6],[78,3,78,6],[71,11,71,14],[67,11,67,14],[58,18,58,21],[65,17,65,21],[79,1,79,2],[79,3,79,6],[17,10,17,21],[19,10,19,21],[18,10,18,21],[20,10,20,21],[22,10,22,21],[23,10,23,21],[24,10,24,21],[89,11,89,14],[80,11,80,14],[84,11,84,14],[85,11,85,14],[25,10,25,21],[87,17,87,21],[87,11,87,14],[38,10,38,21],[29,10,29,21],[30,10,30,21],[35,17,35,22],[37,10,37,21],[49,10,49,21],[50,10,50,21],[95,17,95,21],[91,17,91,21],[85,17,85,21],[80,17,80,21],[78,17,78,21],[83,17,83,21],[76,20,76,21],[66,11,66,14],[11,5,11,20],[71,1,71,10],[68,11,68,14],[69,3,69,6],[11,1,11,4],[12,1,12,4],[13,2,13,4],[14,2,14,4],[61,10,61,11],[69,11,69,14],[51,10,51,21],[71,17,71,21],[52,10,52,21],[21,10,21,21],[26,10,26,21],[28,10,28,21],[12,18,12,20],[13,18,13,20],[14,18,14,20],[39,10,39,21],[31,10,31,21],[15,5,15,17],[137,23,137,24],[66,17,66,21],[74,17,74,21],[68,23,68,24],[67,17,67,21],[70,23,70,24],[75,23,75,24],[79,23,79,24],[87,23,87,24],[77,17,77,21],[133,23,133,24],[119,23,119,24],[124,23,124,24],[130,23,130,24],[100,23,100,24],[104,23,104,24],[110,17,110,21],[118,18,118,21]]}
["LA UTILIZACIÓN DE ESTA PLANILLA, EXIME DE TODA RESPONSABILIDAD A JULIO A. ESTOUP Y A JUAN G. ESTOUP, POR CUALQUIER ERROR INVOLUNTARIO COMETIDO EN EL CÁLCULO"]
["DE HONORARIOS, JUBILATORIOS Y/O CUOTA DE EJERCICIO PROFESIONAL SU USO ES GRATUITO Y OPTATIVO. LOS VALORES RESULTANTES DE SU APLICACIÓN DEBERÁN SER  "]
["VERIFICADOS POR EL PROFESIONAL ACTUANTE, QUIEN SERÁ ÚNICO RESPONSABLE POR PERJUICIOS PROPIOS Y/O A TERCEROS INVOLUCRADOS."]
[null,"Hoja de cálculo para confección de contrato, planilla anexa, estado de obra, ley 12490. - ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CATEGORIZACIÓN DE VIV. UNIFAMILIARES (Marcar 1 en el recuadro correspond.)"]
[null,"Distribución Gratuita",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Con dependencia de servicio (Se interpreta como, habitad correspondiente a personal de servicio)"]
[null,"MEDICIÓN - PROYECTO Y DIRECCIÓN - DIRECCIÓN EJECUTIVA -",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dos o mas cocheras cubiertas o semicubiertas"]
[null,"DEMOLICIÓN Y REP. TÉCNICA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aire acondicionado central u otras instalaciones especiales"]
[null,"Gentileza    Agrim - M.M. de Obras Julio A. ESTOUP - ",null,null,null,null,null,null,null,null,null,null,null,null,"julio_estoup@hotmail.com",null,null,null,null,null,null,null,null,"Cuatro o mas baños o toilette"]
[null,null,null,"  Ing. Civil - M.M. de Obras Juan G. ESTOUP -",null,null,null,null,null,null,null,null,null,null,"juan_estoup@hotmail.com",null,null,null,null,null,null,null,null,"Sauna u/o piscina con espejo de agua mayor a 30,00 m²"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construcción de mas de 150,00 m² totales de superficie (Cubierta y Semicubierta)"]
[null,"LA CATEGORIZACIÓN DE VIVIENDA UNIFAMILIAR SE REALIZA DESDE ESTA PESTAÑA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ubicada en Country, B° Cerrado, Club de Campo u otras Urbanizaciones Privadas"]
[null,"Vig. desde",null,null,null,"HONORARIOS MÍNIMOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W5:W12)","v":0},null,"Mas de 3 niveles o plantas"]
[null,"2019-10-01",null,null,null,"Por cualquier tarea profesional",null,null,null,null,null,null,null,null,null,null,null,null,6500,null,null,null,null,{"$f":"IF(Y13=Y20,\"VIVIENDA UNIFAMILIAR CATEGORIA A\",IF(Y13=Y21,\"VIVIENDA UNIFAMILIAR CATEGORIA B\",IF(Y13=Y22,\"VIVIENDA UNIFAMILIAR CATEGORIA C\",IF(Y13=Y23,\"VIVIENDA UNIFAMILIAR CATEGORIA D\",\"VIVIENDA UNIFAMILIAR CATEGORIA E\"))))","v":"VIVIENDA UNIFAMILIAR CATEGORIA A"},{"$f":"IF(V12=0,Y20,IF(V12=2,Y22,IF(V12=3,Y23,IF(V12=4,Y24,IF(V12>=5,Y24,IF(W11=1,Y22,Y21))))))","v":18200}]
[null,"FC",1.3,null,null,"Medición y conf. de planos para viviendas de Categoria  A",null,null,null,null,null,null,null,null,null,null,null,null,13000,null,null,null,null,"VALOR DE OBRA SEGÚN CAAITBA y COLEGIO de TECNICOS POR m²"]
[null,"UR",26000,null,null,"Med. y conf. de planos de viv. de otras Categ. depós, galp, comercio",null,null,null,null,null,null,null,null,null,null,null,null,20800,null,null,null,null,"1. VIVIENDA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.1 De interés social"]
[1,"DATOS DEL PROFESIONAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.1.1 Prefabricadas económicas de madera",{"$f":"ROUNDUP(0.075*C15,0)","v":1950}]
[null,null,null,null,null,null,null,null,"NOMBRE Y APELLIDO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.1.2 Menores de 70 m2 (individuales)                               Art. 25º Dcto.6964/65"]
[null,null,null,null,null,null,null,null,"DNI Nº",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.2 Unifamiliares (Inclusive en viviendas aisladas afectadas a PH)"]
[null,null,null,null,null,null,null,null,"DOMICILIO CALLE y Nº",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.2.1 De Categoria A (No cumple con ningún items)",{"$f":"ROUNDUP(0.7*C15,0)","v":18200}]
[null,null,null,null,null,null,null,null,"PISO/DEP.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.2.2 De Categoria B (Cumple por lo menos con 1 items)",{"$f":"ROUNDUP(0.8*C15,0)","v":20800}]
[null,null,null,null,null,null,null,null,"LOCALIDAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.2.3 De Categoria C (Cumple por lo menos con 2 items ó en B° Cerrado)",{"$f":"ROUNDUP(1*C15,0)","v":26000}]
[null,null,null,null,null,null,null,null,"PARTIDO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.2.4 De Categoria D (Cumple por lo menos con 3 items)",{"$f":"ROUNDUP(1.2*C15,0)","v":31200}]
[null,null,null,null,null,null,null,null,"TITULO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.2.5 De Categoría E (Cumple por lo menos con 4 items)",{"$f":"ROUNDUP(1.4*C15,0)","v":36400}]
[null,null,null,null,null,null,null,null,"CUIT"]
[null,null,null,null,null,null,null,null,"MATRICULA CTPBA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.3 Multifamiliares"]
[null,null,null,null,null,null,null,null,"Nº AFILIADO A LA CAJA ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.3.1 En construcciones hasta 4 niveles o plantas",{"$f":"ROUNDUP(0.9*C15,0)","v":23400}]
[2,"DATOS DEL COMITENTE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.3.2 En construcciones de mas de 4 niveles o plantas",{"$f":"ROUNDUP(1*C15,0)","v":26000}]
[null,null,null,null,null,null,null,null,"NOMBRE Y APELLIDO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.3.3 Las ant. (Ubic. en Country, B° Cerrado, Club de Campo o en Urb. privadas                        ",{"$f":"ROUNDUP(1.1*C15,0)","v":28600},null,null,{"$f":"SUM(D67:D70,D78:D84)","v":0},{"$f":"IF((AB29>=70)*AND(L67=Y35),\"REVISAR CATEGORIA DE VIVIENDA < 70 m2\",\".\")","v":"."},{"$f":"CONCATENATE(AC29,AC30,AC31,AC32)","v":"...."}]
[null,null,null,null,null,null,null,null,"DNI Nº",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.5 Industrializadas",{"$f":"ROUNDUP(0.5*C15,0)","v":13000},null,null,{"$f":"AB29","v":0},{"$f":"IF((AB30>=70)*AND(L68=Y35),\"REVISAR CATEGORIA DE VIVIENDA < 70 m2\",\".\")","v":"."}]
[null,null,null,null,null,null,null,null,"CUIL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.6 PISCINAS (m² por espejo de agua)",null,null,null,0,{"$f":"IF((AB31>=70)*AND(L69=Y35),\"REVISAR CATEGORIA DE VIVIENDA < 70 m2\",\".\")","v":"."}]
[null,null,null,null,null,null,null,null,"DOMICILIO CALLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.6.1 Construidas en Hº Aº, revestidas, con equipo de bombeo",{"$f":"ROUNDUP(0.5*C15,0)","v":13000},null,null,0,{"$f":"IF((AB32>=70)*AND(L70=Y35),\"REVISAR CATEGORIA DE VIVIENDA < 70 m2\",\".\")","v":"."}]
[null,null,null,null,null,null,null,null,"NUMERO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.6.2 Las no comprendidas en el ítem 1.6.1",{"$f":"ROUNDUP(0.25*C15,0)","v":6500},null,null,0,{"$f":"IF((AB33>=70)*AND(I78=Y35),\"REVISAR CATEGORIA DE VIVIENDA < 70 m2\",\".\")","v":"."},{"$f":"CONCATENATE(AC33,AC34,AC35,AC36)","v":"...."}]
[null,null,null,null,null,null,null,null,"LOCALIDAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. INDUSTRIA Y ALMACENAJE ",null,null,null,0,{"$f":"IF((AB34>=70)*AND(I79=Y35),\"REVISAR CATEGORIA DE VIVIENDA < 70 m2\",\".\")","v":"."}]
[null,null,null,null,null,null,null,null,"PARTIDO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.1   Depositos e Industrias De baja complej. Estruc. De hasta 12 m de Luz, altura hasta 6 m",null,null,null,0,{"$f":"IF((AB35>=70)*AND(I83=Y35),\"REVISAR CATEGORIA DE VIVIENDA < 70 m2\",\".\")","v":"."}]
[3,"FECHA Y LUGAR DE CONTRATACIÓN",null,null,null,null,null,null,null,null,null,null," ","Fecha actual:",null,null,null,{"$f":"TODAY()","v":"2020-06-26"},null,null,null,null,null,"        con dependencias de hasta un 10% de la sup. Total",{"$f":"ROUNDUP(0.3*C15,0)","v":7800},null,null,0,{"$f":"IF((AB36>=70)*AND(I84=Y35),\"REVISAR CATEGORIA DE VIVIENDA < 70 m2\",\".\")","v":"."}]
[null,null,null,null,null,null,null,null,"CIUDAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.1.1 Depositos que superen parametros del item 2.1",{"$f":"ROUNDUP(0.45*C15,0)","v":11700}]
[null,null,null,null,null,null,null,null,"DÍA (en letras)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.2    Industrias que superen parametros del item 2.1",{"$f":"ROUNDUP(0.6*C15,0)","v":15600},null,null,"PROYECTO Y DIRECCIÓN",null,{"$f":"R73","v":0},"hasta","parcial","excedente","%","parcial","total"]
[null,null,null,null,null,null,null,null,"DÍA (en número)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.3   Alta complejidad, laboratorios industriales",{"$f":"ROUNDUP(1*C15,0)","v":26000},null,null,{"$f":"1000000*C14","v":1300000},8.5000000000000006E-2,{"$f":"AB39*AC39","v":110500.00000000001},null,null,{"$f":"IF(AD38<=AB39,AD38,0)","v":0},{"$f":"IF(AD38<=AB39,AC39,0)","v":8.5000000000000006E-2},{"$f":"AG39*AH39","v":0},{"$f":"AI39+AF39","v":0}]
[null,null,null,null,null,null,null,null,"MES (en letras)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.4   Invernáculos, locales para cría de animales",{"$f":"ROUNDUP(0.1*C15,0)","v":2600},null,null,{"$f":"5000000*C14","v":6500000},0.08,{"$f":"(AB40-AB39)*AC40+AD39","v":526500},{"$f":"IF((AD38>AB39)*AND(AD38<=AB40),AB39,0)","v":0},{"$f":"IF(AE40=AB39,AD39,0)","v":0},{"$f":"IF(AE40=AB39,AD38-AB39,0)","v":0},{"$f":"IF(AE40=AB39,AC40,0)","v":0},0,0]
[null,null,null,null,null,null,null,null,"AÑO (en letras)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.5   Tinglados y cobertizos (sup. cubierta = sup. semicubierta)",{"$f":"ROUNDUP(0.2*C15,0)","v":5200},null,null,{"$f":"10000000*C14","v":13000000},7.4999999999999997E-2,{"$f":"(AB41-AB40)*AC41+AD40","v":1014000},{"$f":"IF((AD38>AB40)*AND(AD38<=AB41),AB40,0)","v":0},{"$f":"IF(AE41=AB40,AD40,0)","v":0},{"$f":"IF(AE41=AB40,AD38-AB40,0)","v":0},{"$f":"IF(AE41=AB40,AC41,0)","v":0},0,0]
[null,null,null,null,null,null,null,null,"AÑO (en número)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.6 Almacenamientos, silos en m³ ",null,null,null,{"$f":"30000000*C14","v":39000000},7.0000000000000007E-2,{"$f":"(AB42-AB41)*AC42+AD41","v":2834000},{"$f":"IF((AD38>AB41)*AND(AD38<=AB42),AB41,0)","v":0},{"$f":"IF(AE42=AB41,AD41,0)","v":0},{"$f":"IF(AE42=AB41,AD38-AB41,0)","v":0},{"$f":"IF(AE42=AB41,AC42,0)","v":0},0,0]
[4,"DATOS DE LA OBRA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.1.1 Hormigòn Armado",{"$f":"ROUNDUP(0.1*C15,0)","v":2600},null,null,{"$f":"100000000*C14","v":130000000},6.5000000000000002E-2,{"$f":"(AB43-AB42)*AC43+AD42","v":8749000},{"$f":"IF((AD38>AB42)*AND(AD38<=AB43),AB42,0)","v":0},{"$f":"IF(AE43=AB42,AD42,0)","v":0},{"$f":"IF(AE43=AB42,AD38-AB42,0)","v":0},{"$f":"IF(AE43=AB42,AC43,0)","v":0},0,0]
[null,null,null,null,null,null,null,null,"DESTINO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.1.2 Mamposteria",{"$f":"ROUNDUP(0.08*C15,0)","v":2080},null,null,{"$f":"100000001*C14","v":130000001.3},0.06,null,{"$f":"IF(AD38>AB43,AB43,0)","v":0},{"$f":"IF(AE44=AB43,AD43,0)","v":0},{"$f":"IF(AE44=AB43,AD38-AB43,0)","v":0},{"$f":"IF(AE44=AB43,AC44,0)","v":0},0,0]
[null,null,null,null,null,null,null,null,"CALLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.1.3 Chapa",{"$f":"ROUNDUP(0.07*C15,0)","v":1820},null,null,null,null,null,{"$f":"SUM(AE39:AE44)","v":0},0,0,8.5000000000000006E-2,0,0]
[null,null,null,null,null,null,null,null,"Nº",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3. COMERCIO",null,null,null,"MEDICIÓN",null,{"$f":"R86","v":0},"hasta","parcial","excedente","%","parcial","total"]
[null,null,null,null,null,null,null,null,"LOCALIDAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.1 Minorista  hasta 50 m²",{"$f":"ROUNDUP(0.5*C15,0)","v":13000},null,null,{"$f":"200000*C14","v":260000},1.2500000000000001E-2,{"$f":"AB47*AC47","v":3250},null,null,{"$f":"IF(AD46<=AB47,AD46,0)","v":0},{"$f":"IF(AD46<=AB47,AC47,0)","v":1.2500000000000001E-2},{"$f":"AG47*AH47","v":0},{"$f":"AI47+AF47","v":0}]
[null,null,null,null,null,null,null,null,"PARTIDO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.2 Minorista o mayorista mayor de 50 m² y hasta 300 m².",{"$f":"ROUNDUP(0.7*C15,0)","v":18200},null,null,{"$f":"1000000*C14","v":1300000},0.01,{"$f":"(AB48-AB47)*AC48+AD47","v":13650},{"$f":"IF((AD46>AB47)*AND(AD46<=AB48),AB47,0)","v":0},{"$f":"IF(AE48=AB47,AD47,0)","v":0},{"$f":"IF(AE48=AB47,AD46-AE48,0)","v":0},{"$f":"IF(AE48=AB47,AC48,0)","v":0},{"$f":"AG48*AH48","v":0},{"$f":"AI48+AF48","v":0}]
[null,null,null,null,null,null,null,null,"CIRCUNSCRIPCIÓN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.3 Minorista o mayorista mayor de 300 m²",{"$f":"ROUNDUP(0.8*C15,0)","v":20800},null,null,{"$f":"2000000*C14","v":2600000},7.0000000000000001E-3,{"$f":"(AB49-AB48)*AC49+AD48","v":22750},{"$f":"IF((AD46>AB48)*AND(AD46<=AB49),AB48,0)","v":0},{"$f":"IF(AE49=AB48,AD48,0)","v":0},{"$f":"IF(AE49=AB48,AD46-AE49,0)","v":0},{"$f":"IF(AE49=AB48,AC49,0)","v":0},{"$f":"AG49*AH49","v":0},{"$f":"AI49+AF49","v":0}]
[null,null,null,null,null,null,null,null,"SECCIÓN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.4 Shopping",{"$f":"ROUNDUP(1.4*C15,0)","v":36400},null,null,{"$f":"5000000*C14","v":6500000},5.0000000000000001E-3,{"$f":"(AB50-AB49)*AC50+AD49","v":42250},{"$f":"IF((AD46>AB49)*AND(AD46<=AB50),AB49,0)","v":0},{"$f":"IF(AE50=AB49,AD49,0)","v":0},{"$f":"IF(AE50=AB49,AD46-AE50,0)","v":0},{"$f":"IF(AE50=AB49,AC50,0)","v":0},{"$f":"AG50*AH50","v":0},{"$f":"AI50+AF50","v":0}]
[null,null,null,null,null,null,null,null,"MANZANA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4. CULTURA, ESPECTÁCULOS Y ESPARCIMIENTO",null,null,null,{"$f":"5000001*C14","v":6500001.2999999998},3.0000000000000001E-3,null,{"$f":"IF(AD46>AB50,AB50,0)","v":0},{"$f":"IF(AE51=AB50,AD50,0)","v":0},{"$f":"IF(AE51=AB50,AD46-AE51,0)","v":0},{"$f":"IF(AE51=AB50,AC51,0)","v":0},{"$f":"AG51*AH51","v":0},{"$f":"AI51+AF51","v":0}]
[null,null,null,null,null,null,null,null,"PARCELA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.1 Bibliotecas públicas",{"$f":"ROUNDUP(1*C15,0)","v":26000},null,null,null,null,null,{"$f":"SUM(AE47:AE51)","v":0},0,0,1.2500000000000001E-2,0,0]
[null,null,null,null,null,null,null,null,"U.F.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.2 Salones de fiesta, locales bailables",{"$f":"ROUNDUP(1*C15,0)","v":26000},null,null,"PROYECTO Y DIRECCIÓN",null,{"$f":"SUM(R81:R85)","v":0},"hasta","parcial","excedente","%","parcial","total"]
[5,"TAREA ENCOMENDADA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.3 Cafés concert o auditorios",{"$f":"ROUNDUP(1*C15,0)","v":26000},null,null,{"$f":"1000000*C14","v":1300000},8.5000000000000006E-2,{"$f":"AB54*AC54","v":110500.00000000001},null,null,{"$f":"IF(AD53<=AB54,AD53,0)","v":0},{"$f":"IF(AD53<=AB54,AC54,0)","v":8.5000000000000006E-2},{"$f":"AG54*AH54","v":0},{"$f":"AI54+AF54","v":0}]
[null,null,null,null,null,null,null,null,"DESCRIPCIÓN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.4 Cines",{"$f":"ROUNDUP(1*C15,0)","v":26000},null,null,{"$f":"5000000*C14","v":6500000},0.08,{"$f":"(AB55-AB54)*AC55+AD54","v":526500},{"$f":"IF((AD53>AB54)*AND(AD53<=AB55),AB54,0)","v":0},{"$f":"IF(AE55=AB54,AD54,0)","v":0},{"$f":"IF(AE55=AB54,AD53-AB54,0)","v":0},{"$f":"IF(AE55=AB54,AC55,0)","v":0},0,0]
[6,"DATOS COMPLEMENTARIOS",null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,"4.5 Teatros",{"$f":"ROUNDUP(1*C15,0)","v":26000},null,null,{"$f":"10000000*C14","v":13000000},7.4999999999999997E-2,{"$f":"(AB56-AB55)*AC56+AD55","v":1014000},{"$f":"IF((AD53>AB55)*AND(AD53<=AB56),AB55,0)","v":0},{"$f":"IF(AE56=AB55,AD55,0)","v":0},{"$f":"IF(AE56=AB55,AD53-AB55,0)","v":0},{"$f":"IF(AE56=AB55,AC56,0)","v":0},0,0]
[null,null,null,null,null,null,null,null,"VIGENCIA ( meses en letras)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.6 Casinos, salas de juegos",{"$f":"ROUNDUP(1.4*C15,0)","v":36400},null,null,{"$f":"30000000*C14","v":39000000},7.0000000000000007E-2,{"$f":"(AB57-AB56)*AC57+AD56","v":2834000},{"$f":"IF((AD53>AB56)*AND(AD53<=AB57),AB56,0)","v":0},{"$f":"IF(AE57=AB56,AD56,0)","v":0},{"$f":"IF(AE57=AB56,AD53-AB56,0)","v":0},{"$f":"IF(AE57=AB56,AC57,0)","v":0},0,0]
[null,null,null,null,null,null,null,null,"VIGENCIA (meses en números)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.7 Autocines",{"$f":"ROUNDUP(0.375*C15,0)","v":9750},null,null,{"$f":"100000000*C14","v":130000000},6.5000000000000002E-2,{"$f":"(AB58-AB57)*AC58+AD57","v":8749000},{"$f":"IF((AD53>AB57)*AND(AD53<=AB58),AB57,0)","v":0},{"$f":"IF(AE58=AB57,AD57,0)","v":0},{"$f":"IF(AE58=AB57,AD53-AB57,0)","v":0},{"$f":"IF(AE58=AB57,AC58,0)","v":0},0,0]
[null,null,null,null,null,null,null,null,"CARÁCTER (Originario/Reajuste/Ampliat.)",null,null,null,null,{"$f":"IF(K59=\"reajuste\",\"Cont. Anterior en $\",\"\")","v":""},null,null,null,null,null,null,null,null,null,"4.8 Anfiteatros",{"$f":"ROUNDUP(0.875*C15,0)","v":22750},null,null,{"$f":"100000001*C14","v":130000001.3},0.06,null,{"$f":"IF(AD53>AB58,AB58,0)","v":0},{"$f":"IF(AE59=AB58,AD58,0)","v":0},{"$f":"IF(AE59=AB58,AD53-AB58,0)","v":0},{"$f":"IF(AE59=AB58,AC59,0)","v":0},0,0]
[null,null,null,null,null,null,null,null,"JURISDICCIÓN TRIBUNALES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5. EDUCACIÓN",null,null,null,null,null,null,{"$f":"SUM(AE54:AE59)","v":0},0,0,8.5000000000000006E-2,0,0]
[7,"FORMA DE CALCULO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5.1 EGB, JI, EM, EMA y T, hasta 200 m2",{"$f":"ROUNDUP(0.5*C15,0)","v":13000},null,null,null,null,null,"Ho","m2"]
[null,null,null,null,null,null,null,null,"PROYECTO   60%   50%    0%     ",null,null,null,"Resolución del CTPBA",null,null,null,null,null,null,null,null,null,null,"5.2 EGB, JI, EM, EMA y T, mayores de 200 m2",{"$f":"ROUNDUP(1*C15,0)","v":26000},null,null,null,null,{"$f":"IF((AE62<Y149)*AND(AF62<70)*AND(L78=Y20)*AND(AG62=0),\"VER HONORARIO MINIMO VIVIENDA < 70 m2\",\".\")","v":"."},{"$f":"H115","v":0},{"$f":"SUM(D78:D84)","v":0},{"$f":"SUM(D67:G70)","v":0},{"$f":"CONCATENATE(AD62,AD63)","v":".."}]
[null,null,null,null,null,null,null,null,"DIRECCIÓN    40%   30%   0%      ",null,null,null,"Resolución del CTPBA",null,null,null,null,null,null,null,null," ",null,"5.3 Escuelas, institutos, facultades (cualquier nivel)",{"$f":"ROUNDUP(1.4*C15,0)","v":36400},null,null,null,null,{"$f":"IF((AE63<Y150)*AND(AF63>=70)*AND(L78=Y24)*AND(AG63=0),\"VER HONORARIO MINIMO VIVIENDA > 70 m2\",\".\")","v":"."},{"$f":"AE62","v":0},{"$f":"AF62","v":0},0]
[null,"SUPLEMENTO 100- 80-75-60-45-40-30-20-15-0%",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K64=0%,\"Otro profesional asume la construcción\",IF(K64<=20%,\"Estudio de Proyecto (Otro  Profesional hizo el proyecto)\",IF(K64<=45%,\"Contratos Separados\",IF(K64>=75%,\"Administración\",IF(K64=60%,IF(K63=40%,\"Contratos Separados y Estudio de Proyecto\",\"Administración\"))))))","v":"Otro profesional asume la construcción"},null,null,null,null,null,null,null,null,null,null,"6. SALUD",null,null,null,null,null,{"$f":"IF((AE64<Y150)*AND(I78=AF76)*AND(AG64=0),\"VER HONORARIO MINIMO COMERCIO\",\".\")","v":"."},0,{"$f":"AF63","v":0},0]
[8,"OBRAS NUEVAS ( PROYECTO Y DIRECCIÓN )",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6.1 Dispensarios, salas de primeros auxilios",{"$f":"ROUNDUP(0.7*C15,0)","v":18200},null,null,{"$f":"IF(H115>(R115+0.001),\"HONORARIO POR MEDICION CONVENIDO\",\"HONORARIO MINIMO\")","v":"HONORARIO MINIMO"}]
[null,"VALOR DE OBRA",null,null,null,null,null,"Factor de corrección a la fecha",null,null,null,null,null,null,null,null,null,{"$f":"C14","v":1.3},null,null,null,null,null,"6.2 Consultorios, laboratorios de análisis clínicos",{"$f":"ROUNDUP(0.8*C15,0)","v":20800},null,null,{"$f":"IF(H115<(R115-0.001),\" INSUFICIENTE\",\".\")","v":"."}]
[null,"Categ. 8º",null,null,null,null,null," m² a razón de ",null,null,null,null,null,null,null,"   $/m² =",null,{"$f":"+D67*L67","v":0},null,null,null,null,null,"6.3 Clínicas sanatorios, e institutos geriátricos",{"$f":"ROUNDUP(1*C15,0)","v":26000},null,null,{"$f":"IF(H134>=T134,\".\",IF(K59=\"Reajuste\",\".\",\"MONTO DE CONTADO INSUFICIENTE\"))","v":"."}]
[null,"Categ. 8º",null,null,null,null,null," m² a razón de ",null,null,null,null,null,null,null,"   $/m² =",null,{"$f":"+D68*L68","v":0},null,null,null,null,null,"6.4 Hospitales y/o alta complejidad",{"$f":"ROUNDUP(1.4*C15,0)","v":36400},null,null,{"$f":"IF(H134>H129+0.001,\"MONTO LIQUIDADO SUPERIOR AL TOTAL\",\".\")","v":"."}]
[null,"Categ. 8º ",null,null,null,null,null," m² a razón de ",null,null,null,null,null,null,null,"   $/m² =",null,{"$f":"+D69*L69","v":0},null,null,null,null,null,"7. BANCOS Y FINANZAS"]
[null,"Categ. 8º ",null,null,null,null,null," m² a razón de ",null,null,null,null,null,null,null,"   $/m² =",null,{"$f":"+D70*L70","v":0},null,null,null,null,null,"7.1 Bancos, financieras, créditos y seguros",{"$f":"ROUNDUP(1.25*C15,0)","v":32500},null,null,"REPRESENTACIÓN TÉCNICA",null,{"$f":"R108","v":0},"hasta","parcial","excedente","%","parcial","total"]
[null,"T. Faltant.",null,"no",{"$f":"IF(D71=\"NO\",0,IF(L84=L83/2,D81+D82+D83+D84/2,D81+D82+D83+D84))","v":0},null," m² a razón calc.",null,null,{"$f":"IF(D71=\"NO\",0,R71/E71/O71)","v":0},null,null,"   $/m² ","x",{"$f":"IF(D71=\"NO\",0,100%-'Acta Est. Obra'!F48)","v":0},null,null,{"$f":"IF(D71=\"SI\",(100%-'Acta Est. Obra'!F48)*(D81*L81+D82*L82+D83*L83+D84*L84),0)","v":0},null,null,null,null,null,"8. HOTELERIA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Si","No"]
[null,"Por Computo y Presupuesto................................",null,null,null,null,null,null,null,null,null,null,null,null,null,"   $/m² =",null,{"$f":"L72","v":0},null,null,null,null,null,"8.1 Hosterías, hospedajes y pensiones",{"$f":"ROUNDUP(0.8*C15,0)","v":20800},null,null,{"$f":"1000000*C14","v":1300000},0.05,{"$f":"AB72*AC72","v":65000},null,null,{"$f":"IF(AD70<=AB72,AD70,0)","v":0},{"$f":"IF(AD70<=AB72,AC72,0)","v":0.05},{"$f":"AG72*AH72","v":0},{"$f":"AI72+AF72","v":0}]
[null,"HONORARIO PROYECTO Y DIRECCIÓN",null,null,null,null,null,null,null,null,null,{"$f":"AJ45","v":0},null,null,null,"TOTAL",null,{"$f":"SUM(R67,R68,R69,R70,R71,L72)","v":0},null,null,null,null,null,"8.2 Hoteles 2 y 3 estrellas",{"$f":"ROUNDUP(1*C15,0)","v":26000},null,null,{"$f":"5000000*C14","v":6500000},0.04,{"$f":"(AB73-AB72)*AC73+AD72","v":273000},{"$f":"IF((AD70>AB72)*AND(AD70<=AB73),AB72,0)","v":0},{"$f":"IF(AE73=AB72,AD72,0)","v":0},{"$f":"IF(AE73=AB72,AD70-AB72,0)","v":0},{"$f":"IF(AE73=AB72,AC73,0)","v":0},0,0]
[null,"hasta",null,{"$f":"AE45","v":0},null,null,null,"acumulado",null,null,null,{"$f":"AF45","v":0},null,null,null,null,null,null,null,null,null,null,null,"8.3 Albergues transitorios",{"$f":"ROUNDUP(1.2*C15,0)","v":31200},null,null,{"$f":"10000000*C14","v":13000000},0.03,468000,{"$f":"IF((AD70>AB73)*AND(AD70<=AB74),AB73,0)","v":0},0,{"$f":"IF(AE74=AB73,AD70-AB73,0)","v":0},0,0,0]
[null,"el",null,{"$f":"AH45","v":8.5000000000000006E-2},null,null,null,"s/ siguientes",null,null,null,{"$f":"AG45","v":0},null,null,null,null,"=",{"$f":"AI45","v":0},null,null,null,null,null,"8.4 Hoteles 4 y 5 estrellas",{"$f":"ROUNDUP(2*C15,0)","v":52000},null,null,{"$f":"20000000*C14","v":26000000},2.5000000000000001E-2,793000,{"$f":"IF((AD70>AB74)*AND(AD70<=AB75),AB74,0)","v":0},0,{"$f":"IF(AE75=AB74,AD70-AB74,0)","v":0},0,0,0]
[9,"OBRAS CONSTRUIDAS ( MEDICIÓN )",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9. GASTRONOMÍA",null,null,null,{"$f":"40000000*C14","v":52000000},0.02,1313000,{"$f":"IF((AD70>AB75)*AND(AD70<=AB76),AB75,0)","v":0},0,{"$f":"IF(AE76=AB75,AD70-AB75,0)","v":0},0,0,0]
[null,"VALOR DE OBRA",null,null,null,"¿ES MEDICIÓN DE VIVIENDA CATEGORIA A ÚNICAMENTE?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"si",null,null,"9.1 Parrillas, casas de comida",{"$f":"ROUNDUP(0.7*C15,0)","v":18200},null,null,{"$f":"80000000*C14","v":104000000},1.4999999999999999E-2,{"$f":"(AB77-AB76)*AC77+AD76","v":2093000},{"$f":"IF((AD70>AB76)*AND(AD70<=AB77),AB76,0)","v":0},{"$f":"IF(AE77=AB76,AD76,0)","v":0},{"$f":"IF(AE77=AB76,AD70-AB76,0)","v":0},{"$f":"IF(AE77=AB76,AC77,0)","v":0},0,0]
[null,"Con Ante",null,null,null,null,null," m² a razón de",null,null,null,null,null,null,null,"   $/m² =",null,{"$f":"+D78*L78","v":0},null,null,null,null,null,"9.2 Restaurantes, bares, confiterías, pizzerías",{"$f":"ROUNDUP(0.8*C15,0)","v":20800},null,null,{"$f":"160000000*C14","v":208000000},0.01,3133000,{"$f":"IF((AD70>AB77)*AND(AD70<=AB78),AB77,0)","v":0},0,{"$f":"IF(AE78=AB77,AD70-AB77,0)","v":0},0,{"$f":"AG78*AH78","v":0},{"$f":"AI78+AF78","v":0}]
[null,"Con Ante",null,null,null,null,null," m² a razón de",null,null,null,null,null,null,null,"   $/m² =",null,{"$f":"+D79*L79","v":0},null,null,null,null,null,"9.3 Restaurantes de categoría",{"$f":"ROUNDUP(1.2*C15,0)","v":31200},null,null,{"$f":"160000001*C14","v":208000001.30000001},5.0000000000000001E-3,null,{"$f":"IF(AD70>AB78,AB78,0)","v":0},0,{"$f":"IF(AE79=AB78,AD70-AB78,0)","v":0},0,{"$f":"AG79*AH79","v":0},{"$f":"AI79+AF79","v":0}]
[null,"Con Ante",null,null,null,null,null," m² a razón de",null,null,null,null,null,null,null,"   $/m² =",null,{"$f":"+D80*L80","v":0},null,null,null,null,null,"10. CULTO, ARQUITECTURA FUNERARIA"]
[null,"Cubierta",null,null,null,null,null," m² cub. a razón de",null,null,null,null,null,null,null,"   $/m² =",null,{"$f":"IF(D71=\"SI\",+D81*L81*'Acta Est. Obra'!F48,+D81*L81)","v":0},null,null,null,null,null,"10.1 Capillas o equivalentes en otros cultos",{"$f":"ROUNDUP(0.7*C15,0)","v":18200}]
[null,"Cubierta",null,null,null,null,null," m² cub. a razón de",null,null,null,null,null,null,null,"   $/m² =",null,{"$f":"IF(D71=\"SI\",+D82*L82*'Acta Est. Obra'!F48,+D82*L82)","v":0},null,null,null,null,null,"10.2 Iglesias o equivalentes en otros cultos",{"$f":"ROUNDUP(1*C15,0)","v":26000}]
[null,"Semi",null,null,null,null,null," m² cub. a razón de",null,null,null,null,null,null,null,"   $/m² =",null,{"$f":"IF(D71=\"SI\",+D83*L83*'Acta Est. Obra'!F48,+D83*L83)","v":0},null,null,null,null,null,"10.4 Velatorios",{"$f":"ROUNDUP(1*C15,0)","v":26000},null,null,null,null,null,{"$f":"SUM(AE72:AE79)","v":0},0,0,0.05,0,0]
[null,"Semi",null,null,null,null,null," m² cub ó semic a razón de",null,null,null,null,null,null,null,"   $/m² =",null,{"$f":"IF(D71=\"SI\",+D84*L84*'Acta Est. Obra'!F48,+D84*L84)","v":0},null,null,null,null,null,"10.5 Cementerios",null,null,null,null,null,null,"Ho","m2"]
[null,"Sin Anteced. Por Computo y Presupuesto.......",null,null,null,null,null,null,null,{"$f":"D78+D79+D80+D81+D82+D83+D84","v":0},{"$f":"IF(J85=0,0,IF(U77=\"SI\",S14,S15))","v":0},null,null,null,null,null,null,{"$f":"L85","v":0},null,null,null,null,null,"10.5.1 Parquizaciones espacios exteriores",{"$f":"ROUNDUP(0.025*C15,0)","v":650},null,null,{"$f":"IF(D78=81,Y72,0)","v":0}]
[null,"HONORARIO MEDICIÓN",null,null,null,null,{"$f":"IF(L86=K85,\"Mínimo\",\".\")","v":"Mínimo"},null,{"$f":"IF(K85=0,0,IF(U77<=70,S14,S15))","v":0},null,null,{"$f":"IF(AJ52>K85,AJ52,K85)","v":0},null,null,null,"TOTAL",null,{"$f":"SUM(R78:R85)","v":0},null,null,null,null,null,"10.5.2 Nichos (por unidad)",{"$f":"ROUNDUP(0.3*C15,0)","v":7800},null,null,{"$f":"IF(D78=82,Y73,0)","v":0}]
[null,"hasta",null,{"$f":"AE52","v":0},null,null,null,"acumulado",null,null,null,{"$f":"AF52","v":0},null,null,null,null,null,null,null,null,null,null,null,"10.5.3 Bóvedas o panteones (por m²)",{"$f":"ROUNDUP(2.4*C15,0)","v":62400},null,null,{"$f":"IF(D78=83,Y74,0)","v":0}]
[null,"el",null,{"$f":"AH52","v":1.2500000000000001E-2},null,null,null,"s/ siguientes",null,null,null,{"$f":"AG52","v":0},null,null,null,null,"=",{"$f":"AI52","v":0},null,null,null,null,null,"11. ESPACIOS URBANOS DESCUBIERTOS",null,null,null,"EJERCICIO PROFESIONAL DIRECTOR",null,"Honorario",{"$f":"H129","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"%",null,null,null,null,null,null,null,null,null,null,null,"11.1 Tratamiento y/o parquizaciones esp. exterioes (plazas y parques)",{"$f":"ROUNDUP(0.025*C15,0)","v":650},null,null,"Cuota",{"$f":"ROUND(IF(AE88<=AC92,AF92,IF(AE88<=AE93,AF93,AE88*2.5%)),2)","v":374}]
[null,"CONTRIBUCIÓN OBLIGATORIA ART. 29º  -  10% DE",null,null,null,null,null,null,null,null,null,{"$f":"AJ60","v":0},null,null,null,null,null,null,null,null,null,null,null,"11.2 Mantenimiento de plazas y parques                                               s/cómp. y pres."]
[null,"hasta",null,{"$f":"AE60","v":0},null,null,null,"acumulado",null,null,null,{"$f":"AF60","v":0},null,null,null,null,null,null,null,null,null,null,null,"11.3 Red vial"]
[null,"el",null,{"$f":"AH60","v":8.5000000000000006E-2},null,null,null,"s/ siguientes",null,null,null,{"$f":"AG60","v":0},null,null,null,null,"=",{"$f":"AI60","v":0},null,null,null,null,null,"11.3.1 Mejorada",{"$f":"ROUNDUP(0.02*C15,0)","v":520},null,null,"Hasta",6103,null,null,374]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11.3.2 Pavimento urbano (rígido)",{"$f":"ROUNDUP(0.08*C15,0)","v":2080},null,null,"de",6103.01,"a",27718,692]
[10,"DEMOLICIÓN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11.3.3 Pavimento urbano (flexible)",{"$f":"ROUNDUP(0.06*C15,0)","v":1560},null,null,"mas de ",27718.01,2.5000000000000001E-2]
[null,"VALOR DE OBRA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11.3.4 Mantenimiento red vial                                                                s/cómp. y pres."]
[null,"Categ. 8º",null,null,null,null,null," m² a razón de",null,null,null,null,null,null,null,"   $/m2 =",null,{"$f":"+D96*L96","v":0},null,null,null,null,null,"11.4 Estudios de suelo; por metro de perforación                                s/cómp. y pres."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",null,{"$f":"R96","v":0},null,null,null,null,null,"11.5 Pavimento de caminos                                                                    s/cómp. y pres."]
[null,"HONORARIO DEMOLICIÓN",null,null,null,null,null,null,null,null,null,{"$f":"R102","v":0},null,null,null,null,null,null,null,null,null,null,null,"11.6 Movimiento de tierra                                                                        s/cómp. y pres.",null,null,null,"CONSTRUCCIÓN",null,{"$f":"'Cert. Constructor'!M27","v":0},"hasta","parcial","excedente","%","parcial","total"]
[null,"TOTAL",null,null,{"$f":"R96","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11.7 Infraestructura (redes de servicios)                                              s/cómp. y pres.",null,null,null,{"$f":"1000000*C14","v":1300000},1.7000000000000001E-2,{"$f":"AB99*AC99","v":22100},null,null,{"$f":"IF(AD98<=AB99,AD98,0)","v":0},{"$f":"IF(AD98<=AB99,AC99,0)","v":1.7000000000000001E-2},{"$f":"AG99*AH99","v":0},{"$f":"AI99+AF99","v":0}]
[null,"porcentaje",null,null,8.5000000000000006E-2,null,null,8.5000000000000006E-2,null,null,null,null,null,null,null,null,null,{"$f":"I103*(K62+K63)","v":0},null,null,null,null,null,"11.8 Monumentos, decoración urbana                                                  s/cómp. y pres.",null,null,null,{"$f":"5000000*C14","v":6500000},1.6E-2,{"$f":"(AB100-AB99)*AC100+AD99","v":105300},{"$f":"IF((AD98>AB99)*AND(AD98<=AB100),AB99,0)","v":0},{"$f":"IF(AE100=AB99,AD99,0)","v":0},{"$f":"IF(AE100=AB99,AD98-AB99,0)","v":0},{"$f":"IF(AE100=AB99,AC100,0)","v":0},0,0]
[null,"deprec/por est.",null,null,0.3,null,null,"30%; 45% ó 60%",null,null,null,"Suplemento de Dirección ",null,null,null,null,null,{"$f":"IF(E103=\"SI\",K64*I103,0)","v":0},null,null,null,null,null,"12. ADMINISTRACIÓN",null,null,null,{"$f":"10000000*C14","v":13000000},1.4999999999999999E-2,{"$f":"(AB101-AB100)*AC101+AD100","v":202800},{"$f":"IF((AD98>AB100)*AND(AD98<=AB101),AB100,0)","v":0},{"$f":"IF(AE101=AB100,AD100,0)","v":0},{"$f":"IF(AE101=AB100,AD98-AB100,0)","v":0},{"$f":"IF(AE101=AB100,AC101,0)","v":0},0,0]
[null,"depreciación",null,null,0.16,null,null,0.16,null,null,null,null,null,null,null,"TOTAL",null,{"$f":"SUM(R100,R101)","v":0},null,null,null,null,null,"12.1 Edificios privados",{"$f":"ROUNDUP(1*C15,0)","v":26000},null,null,{"$f":"30000000*C14","v":39000000},1.4E-2,{"$f":"(AB102-AB101)*AC102+AD101","v":566800},{"$f":"IF((AD98>AB101)*AND(AD98<=AB102),AB101,0)","v":0},{"$f":"IF(AE102=AB101,AD101,0)","v":0},{"$f":"IF(AE102=AB101,AD98-AB101,0)","v":0},{"$f":"IF(AE102=AB101,AC102,0)","v":0},0,0]
[null,"Aplicar Supl. ",null,null,"Si",null,null,"de",{"$f":"E99*E100*E101*E102","v":0},null,null,"Dirección por",null,null,{"$f":"IF( Datos!K64=0%,\"Otro Prof. asume la Construcción\",IF(Datos!K64<=20%,\"Estudio de Proyecto\",IF(Datos!K64<=45%,\"Contratos Separados\",IF(Datos!K64>=75%,\"Direccion Ejecutiva\",IF(Datos!K64=60%,IF(Datos!K63=40%,\"Contratos Separados\",\"Direccion Ejecutiva\"))))))","v":"Otro Prof. asume la Construcción"},null,null,null,null,null,null,null,null,"12.2 Edificios públicos                                                                               s/cómp. y pres.",null,null,null,{"$f":"100000000*C14","v":130000000},1.2999999999999999E-2,{"$f":"(AB103-AB102)*AC103+AD102","v":1749800},{"$f":"IF((AD98>AB102)*AND(AD98<=AB103),AB102,0)","v":0},{"$f":"IF(AE103=AB102,AD102,0)","v":0},{"$f":"IF(AE103=AB102,AD98-AB102,0)","v":0},{"$f":"IF(AE103=AB102,AC103,0)","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Si","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12.3 Complejos penitenciarios",{"$f":"ROUNDUP(1.5*C15,0)","v":39000}]
[11,"REPRESENTACIÓN TÉCNICA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13. DEPORTES Y RECREACIÓN",null,null,null,{"$f":"100000001*C14","v":130000001.3},1.2E-2,null,{"$f":"IF(AD98>AB103,AB103,0)","v":0},{"$f":"IF(AE105=AB103,AD103,0)","v":0},{"$f":"IF(AE105=AB103,AD98-AB103,0)","v":0},{"$f":"IF(AE105=AB103,AC105,0)","v":0},0,0]
[null,"VALOR DE OBRA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13.1 Club Social",{"$f":"ROUNDUP(0.7*C15,0)","v":18200},null,null,null,null,null,{"$f":"SUM(AE99:AE105)","v":0},0,0,1.7000000000000001E-2,0,0]
[null,null,"$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D107","v":0},null,null,null,null,null,"13.2 Club Deportivo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",null,{"$f":"R107","v":0},null,null,null,null,null,"13.2.1 Sin tribuna con estructura de luces menores de 15 m.",{"$f":"ROUNDUP(0.7*C15,0)","v":18200}]
[null,"hasta",null,{"$f":"AE83","v":0},null,null,null,"acumulado",null,null,null,{"$f":"AF83","v":0},null,null,null,null,null,null,null,null,null,null,null,"13.2.2 Sin tribuna con estructura de luces mayores de 15 m.",{"$f":"ROUNDUP(1*C15,0)","v":26000},null,null,"EJERCICIO PROFESIONAL CONSTRUC",null,"Honorario",{"$f":"'Cert. Constructor'!J34","v":"ASDASD"}]
[null,"el",null,{"$f":"AH83","v":0.05},null,null,null,"s/ siguientes",null,null,null,{"$f":"AG83","v":0},null,null,null,null,"=",{"$f":"AI83","v":0},null,null,null,null,null,"13.2.3 Con tribuna con estructura de luces menores de 15 m.",{"$f":"ROUNDUP(1*C15,0)","v":26000},null,null,"Cuota",{"$f":"ROUND(IF(AE109<=AC113,AF113,IF(AE109<=AE114,AF114,AE109*2.5%)),2)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",null,{"$f":"AJ83","v":0},null,null,null,null,null,"13.2.4 Con trib. c/ estruc. de luces may. de 15 m, isostátic. o hiperestáticas",{"$f":"ROUNDUP(1*C15,0)","v":26000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13.2.5 Ídem mayores de 15 m. , especiales",{"$f":"ROUNDUP(1*C15,0)","v":26000}]
[12,"DESCOMPOSICIÓN DEL HONORARIO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13.3 Natatorios  ( PILETAS COMUNES ver 1.6)",null,null,null,"Hasta",{"$f":"AC92","v":6103},null,null,{"$f":"AF92","v":374}]
[null,"Proyecto",null,null,null,{"$f":"K62","v":0},null,{"$f":"L73*K62","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13.3.1 Descubiertos (espejo de agua)",{"$f":"ROUNDUP(0.5*C15,0)","v":13000},null,null,"de",{"$f":"AC93","v":6103.01},"a",{"$f":"AE93","v":27718},{"$f":"AF93","v":692}]
[null,"Medición ",null,{"$f":"G86","v":"Mínimo"},null,null,null,{"$f":"L86","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13.3.2 Cubiertos (adicionar a superficies cubiertas deportivas)",{"$f":"ROUNDUP(0.2*C15,0)","v":5200},null,null,"mas de ",{"$f":"AC94","v":27718.01},2.5000000000000001E-2]
[null,"Demolición Proyecto",null,null,null,{"$f":"K62","v":0},null,{"$f":"I103*F116","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13.4 Gimnasios",{"$f":"ROUNDUP(0.5*C15,0)","v":13000}]
[null,null,null,null,null,null,null,"Honorario parcial",null,null,null,{"$f":"H114+H115+H116","v":0},null,null,null,null,null,null,null,null,null,null,null,"13.5 Canchas"]
[null,"Dirección",null,null,null,{"$f":"K63","v":0},null,{"$f":"L73*K63","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13.5.1 Descubiertas sobre césped o similar",{"$f":"ROUNDUP(0.025*C15,0)","v":650}]
[null,{"$f":"IF(E103=\"NO\",\"-\",\"Dirección demolición\")","v":"Dirección demolición"},null,null,null,{"$f":"K63","v":0},null,{"$f":"I103*K63","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13.5.2 Descubiertas con tratamiento de pisos",{"$f":"ROUNDUP(0.05*C15,0)","v":1300}]
[null,"Suplem. de Dirección ",null,null,null,{"$f":"IF(K64=0,\"No se liquida\",K64)","v":"No se liquida"},null,{"$f":"L73*K64","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14. COCHERAS"]
[null,"Supl. Direcc.Demolic. ",null,null,null,{"$f":"IF(E103=\"NO\",\"No se liquida\",K64)","v":0},null,{"$f":"IF(E103=\"NO\",,I103*F121)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14.1 Planta única con cubierta liviana",{"$f":"ROUNDUP(0.3*C15,0)","v":7800}]
[null,"Informe Técnico ",null,null,null,null,null,{"$f":"M122","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14.2 Planta única con cubierta Hº Aº o estructuras especiales",{"$f":"ROUNDUP(0.4*C15,0)","v":10400}]
[null,null,null,null,null,null,null,"Honorario parcial",null,null,null,{"$f":"H118+H119+H120+H121+H122","v":0},null,null,null,null,null,null,null,null,null,null,null,"14 3 Más de una planta sin elevadores mecánicos",{"$f":"ROUNDUP(0.7*C15,0)","v":18200}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14.4  Más de una planta con elevadores mecánicos",{"$f":"ROUNDUP(1*C15,0)","v":26000}]
[null,null,null,null,null,null,null,"HONORARIO TOTAL",null,null,null,{"$f":"IF((H114+H115+H116+H118+H119+H120+H121+H122)>S13,H114+H115+H116+H118+H119+H120+H121+H122,S13)","v":6500},null,null,null,{"$f":"IF(L125=S13,\"Mínimo\",\".\")","v":"Mínimo"},null,null,null,null,null,null,null,"15. PLAYAS DE ESTACIONAMIENTO, MANIOBRAS Y EST. DE SERV."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15.1 Playas de estacionamiento y/o maniobras",{"$f":"ROUNDUP(0.08*C15,0)","v":2080}]
[13,"HONORARIOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15.2 Estaciones de servicio"]
[null,{"$f":"IF(H129<L125,\"EL HONORARIO CONVENIDO DEBE SER IGUAL O MAYOR AL HONORARIO TOTAL\",\"\")","v":"EL HONORARIO CONVENIDO DEBE SER IGUAL O MAYOR AL HONORARIO TOTAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15.2.1 Playas de expendio cubierta o semicubierta",{"$f":"ROUNDUP(0.6*C15,0)","v":15600}]
[null,"HONORARIO CONVENIDO",null,null,null,null,null,null,null,null,"HONORARIO de CONTRATO",null,null,null,null,null,null,{"$f":"IF(K59=\"Reajuste\",IF(H129-S59<0,0,H129-S59),H129)","v":0},null,null,null,null,null,"15.2.2 Playas de expendio descubierta ",{"$f":"ROUNDUP(0.2*C15,0)","v":5200}]
[null,null,null,null,"PESOS  EN  LETRAS:",{"$f":"BA130","v":"CERO CON 00/100"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15.2.3 Comercio o serv. anexos a estaciones de servicio liquidar según Item 3 COMERCIO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Importe!F3","v":"CERO CON 00/100"}]
[null,{"$f":"IF(L86=0,\".\",IF(H129>=I86,\"\",\"NO CUMPLE HONORARIO MINIMO POR MEDICIÓN\"))","v":"."},null,null,null,null,null,null,null,null,null,null,null,null," ","Honorario base(H0)",null,null,null,{"$f":"H129/R66","v":0},null,null,null,"16. TRANSPORTE"]
[14,"PAGOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16.1 Estaciones de ómnibus, ferroviarias",{"$f":"ROUNDUP(1.2*C15,0)","v":31200}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16.2 Aeropuertos",{"$f":"ROUNDUP(1.4*C15,0)","v":36400}]
[null,"Monto liquidado al contado",null,null,null,null,null,null,null,null,null,null,null,null,"Monto Contado Mínimo",null,null,null,null,{"$f":"ROUNDUP((IF(K59=\"Reajuste\",R129,IF(AJ45>0,H114+H115+H116,H129))),0)","v":0},null,null,null,"17. ESTRUCTURAS COMUNES PARA EDIFICIOS"]
[null,{"$f":"CONCATENATE(AB67,AB68)","v":".."},null,null,null,null,null,null,null,null,null,{"$f":"H134/H129","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(H134=T134,\"\",IF(K59=\"Reajuste\",\"LO LIQUID. DEBE SER IGUAL AL MÍNIMO\",\"\"))","v":""},null,null,null,null,null,null,null,null,"17.1 Sin incidencia del viento",{"$f":"ROUNDUP(0.15*C15,0)","v":3900}]
[null,null,null,null,"PESOS  EN  LETRAS:",{"$f":"BA136","v":"CERO CON 00/100"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17.2 Con incidencia del viento",{"$f":"ROUNDUP(0.2*C15,0)","v":5200},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Importe!T23","v":"CERO CON 00/100"}]
[null,"En concepto de",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17.3 Estructura por m³",{"$f":"ROUNDUP(1*C15,0)","v":26000}]
[null,"Saldo",null,null,{"$f":"H138/H129","v":{"$error":"#DIV/0!"}},null,null,{"$f":"H129-H134","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18. INSTALACIONES PARA EDIFICIOS"]
[null,"En concepto de",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18.1 HP y/CV, cada uno",{"$f":"ROUNDUP(0.36*C15,0)","v":9360}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18.2 Boca de alumbrado, gas, aire comprimiodo y de vacio",{"$f":"ROUNDUP(0.08*C15,0)","v":2080}]
[15,"BOLETAS DE APORTE PREVISIONAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18.3 Instalaciones de baja tensión(Telef-TV-alarm) por boca                                                         s/cómp. y pres.",{"$f":"ROUNDUP(0.08*C15,0)","v":2080}]
[null,"BOLETA 1",null,null,null,null,null,null,"SUC. BANCO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18.4 Las no comprendidas en incisos anteriores                                                        s/cómp. y pres.","   s/comp. y pres."]
[null,null,"FECHA DE PAGO",null,null,null,"(dd/mm/aaaa)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"    VARIOS"]
[null,null,null,null,null,null,null,null,"NUMERO DE BOLETA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modificaciones Internas                                                                            s/comp. y pres."]
[null,"MONTO APORTE TOTAL",null,null,null,null,{"$f":"ROUND(H129/10,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cambio de techos                                                                                     s/comp. y pres."]
[null,"BOLETA 2",null,null,null,null,null,null,"SUC. BANCO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mantenimiento de Edificios                                                                      s/comp. y pres."]
[null,null,"FECHA DE PAGO",null,null,null,"(dd/mm/aaaa)"]
[null,null,null,null,null,null,null,null,"NUMERO DE BOLETA"]
[null,"MONTO APORTE RESTANTE",null,null,null,null,{"$f":"ROUND(IF(K145>=G145,0,G145-K145),2)","v":0}]
[null,"BOLETA 3 -  ART. 29º",null,null,null,null,null,null,"SUC. BANCO"]
[null,null,"FECHA DE PAGO",null,null,null,"(dd/mm/aaaa)"]
[null,null,null,null,null,null,null,null,"NUMERO DE BOLETA"]
[null,"MONTO TOTAL APORTE",null,null,null,null,{"$f":"ROUND(L90*0.1,1)","v":0}]
[null,null,"IMPORTE EN LETRAS DEL TOTAL ",null,null,null,null,null,null,null,{"$f":"Importe!T3","v":"CERO CON 00/100"}]
[16,"CUOTA DE EJERCICIO PROFESIONAL",null,null,null,null,null,null,null,null,null," "]
[null,null,"FECHA DE PAGO",null,null,null,"(dd/mm/aaaa)"]
[null,null,null,null,null,null,null,null,"NUMERO DE BOLETA"]
[null,null,null,null,null,null,null,null,"SUCURSAL BANCO",null,"MINIMO 748"]
[null,null,null,null,null,null,null,null,"MONTO DEPOSITO",null,{"$f":"AC89","v":374}]
[]
[17,"RESUMEN  DE GASTOS ",null,null,null,null,null,null,null,null,"% EN RELACIÓN AL HON."]
[null,"ART. 29º",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R162/R129","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUNDUP(L90*0.1,0)","v":0}]
[null,"APORTE JUBILA TORIO CAJA",null,null,null,null,null,null,null,null,null," ",null,null,null,{"$f":"R163/R129","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(K145,K149)","v":0}]
[null,"CUOTA DE EJERCICIO PROFESIONAL (C.E.P.)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R164/R129","v":{"$error":"#DIV/0!"}},null,{"$f":"K159","v":374}]
[null,"TIMBRADO CONTRATO (1,35 %) - ARBA (1,20%)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R165/R129","v":{"$error":"#DIV/0!"}},null,{"$f":"R129*1.35%","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",null,{"$f":"R166/R129","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(R162+R163+R164+R165)","v":374}]

{"sheet":"Anexa","index":2,"n_rows":77,"n_cols":9,"rows_kept":77,"cut":false,"hidden":false,"merged":[[9,0,9,1],[8,0,8,1],[8,3,8,4],[32,1,32,2],[77,6,77,7],[75,6,75,7],[77,4,77,5],[67,5,67,6],[66,0,66,2],[39,1,39,2],[76,6,76,7],[74,4,74,5],[63,5,63,6],[70,4,70,5],[0,3,0,4],[62,2,62,3],[74,6,74,7],[2,2,2,8],[18,2,18,3],[28,2,28,3],[12,7,12,8]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,"MATRICULA PROFESIONAL Nº",{"$f":"Datos!K26","v":0}]
[]
["PLANILLA ANEXA CORRESPONDIENTE AL CONTRATO CELEBRADO EL DIA",null,null,null,null,null,{"$f":"Datos!K38","v":0},"DEL MES DE"]
[{"$f":"Datos!K40","v":0},"DEL AÑO",{"$f":"Datos!K41","v":0},null,null,null,"ENTRE:"]
[{"$f":"Datos!K29","v":0},null,"y",{"$f":"Datos!K18","v":0},null,"PARA LA OBRA:",null,{"$f":"Datos!K44","v":0}]
[{"$f":"Datos!K45","v":0},null,{"$f":"Datos!K46","v":0},"PARTIDO DE",{"$f":"Datos!K48","v":0},null,"CIRC.",{"$f":"Datos!K49","v":0}]
["SECC.",{"$f":"Datos!K50","v":0},"MANZ.",{"$f":"Datos!K51","v":0},"PARC.",{"$f":"Datos!K52","v":0},"UF",{"$f":"Datos!K53","v":0}]
["SISTEMA DE EJECUCIÓN DE LA OBRA POR",null,null,{"$f":"IF( Datos!K64=0%,\"OTRO PROFESIONAL ASUME LA CONSTRUCCION\",IF(Datos!K64<=20%,\"ESTUDIO DE PROYECTO\",IF(Datos!K64<=45%,\"CONTRATOS SEPARADOS\",IF(Datos!K64>=75%,\"ADMINISTRACION\",IF(Datos!K64=60%,IF(Datos!K63=40%,\"CONTRATOS SEPARADOS\",\"ADMINISTRACION\"))))))","v":"OTRO PROFESIONAL ASUME LA CONSTRUCCION"},null,null,{"$f":"IF(Datos!K64=45%,\"y ESTUDIO DE PROYECTO\",IF(Datos!K64=75%,\"y ESTUDIO DE PROYECTO\",IF(Datos!K64=100%,\"y ESTUDIO DE PROYECTO\",IF(Datos!K64=60%,IF(Datos!K63=40%,\"y ESTUDIO DE PROYECTO\",\".\"),\".\"))))","v":"."}]
["1) Según Título VIII, Art. 8º, Tabla XVIII - Proyecto y Dirección de Obra",null,null,null,null,"(FC)",{"$f":"Datos!C14","v":1.3},"Observaciones"]
["Categoría 8º","en _________",{"$f":"Datos!D67","v":0},"m² a razón de",{"$f":"Datos!L67","v":0},"$ / m²   =",{"$f":"Datos!R67","v":0}]
["Categoría 8º","en _________",{"$f":"Datos!D68","v":0},"m² a razón de",{"$f":"Datos!L68","v":0},"$ / m²   =",{"$f":"Datos!R68","v":0}]
["Categoría 8º","en _________",{"$f":"Datos!D69","v":0},"m² a razón de",{"$f":"Datos!L69","v":0},"$ / m²   =",{"$f":"Datos!R69","v":0}]
["Categoría 8º","en _________",{"$f":"Datos!D70","v":0},"m² a razón de",{"$f":"Datos!L70","v":0},"$ / m²   =",{"$f":"Datos!R70","v":0}]
["Trabajos Faltantes",{"$f":"IF(Datos!D71=\"no\",\"NO\",100%-'Acta Est. Obra'!F48)","v":"NO"},{"$f":"Datos!E71","v":0},{"$f":"Datos!G71","v":" m² a razón calc."},{"$f":"Datos!J71","v":0},"$ / m²   =",{"$f":"Datos!R71","v":0}]
["Categoría 8º",null,"Computo y Presupuesto",null,{"$f":"Datos!L72","v":0},null,{"$f":"E19","v":0}]
[null,null,null,null,null,"TOTAL",{"$f":"SUM(G14:G19)","v":0}]
["2) Según Título VIII, Art. 19º, Tabla XXI - Medición de Obra",null,null,null,{"$f":"IF(Datos!D71=\"SI\",\"HONORARIO CALCULADO DE ACUERDO AL % DE OBRA EJECUTADA\",\"\")","v":""}]
["Inciso a en",{"$f":"Datos!D78","v":0},"m² a razón de",{"$f":"Datos!L78","v":0},"$ / m²   =",null,{"$f":"Datos!R78","v":0},"Con Antecedentes Municip."]
["Inciso a en",{"$f":"Datos!D79","v":0},"m² a razón de",{"$f":"Datos!L79","v":0},"$ / m²   =",null,{"$f":"Datos!R79","v":0},"Con Antecedentes Municip."]
["Inciso a en",{"$f":"Datos!D80","v":0},"m² a razón de",{"$f":"Datos!L80","v":0},"$ / m²   =",null,{"$f":"Datos!R80","v":0},"Con Antecedentes Municip."]
["Inciso a en",{"$f":"Datos!D81","v":0},"m² a razón de",{"$f":"Datos!L81","v":0},{"$f":"IF(Datos!D71=\"SI\",\"$ / m²  x\",\"$ / m²   =\")","v":"$ / m²   ="},{"$f":"IF(Datos!D71=\"SI\",'Acta Est. Obra'!F48,\"\")","v":""},{"$f":"IF(Datos!D71=\"SI\",'Acta Est. Obra'!F48*Anexa!B25*Anexa!D25,B25*D25)","v":0},"Sin Antecedentes Municip."]
["Inciso a en",{"$f":"Datos!D82","v":0},"m² a razón de",{"$f":"Datos!L82","v":0},{"$f":"IF(Datos!D71=\"SI\",\"$ / m²  x\",\"$ / m²   =\")","v":"$ / m²   ="},{"$f":"IF(Datos!D71=\"SI\",'Acta Est. Obra'!F48,\"\")","v":""},{"$f":"IF(Datos!D71=\"SI\",'Acta Est. Obra'!F48*Anexa!B26*Anexa!D26,B26*D26)","v":0},"Sin Antecedentes Municip."]
["Inciso a en",{"$f":"Datos!D83","v":0},"m² a razón de",{"$f":"Datos!L83","v":0},{"$f":"IF(Datos!D71=\"SI\",\"$ / m²  x\",\"$ / m²   =\")","v":"$ / m²   ="},{"$f":"IF(Datos!D71=\"SI\",'Acta Est. Obra'!F48,\"\")","v":""},{"$f":"IF(Datos!D71=\"SI\",F27*B27*D27,B27*D27)","v":0},"Sin Antecedentes Municip."]
["Inciso a en",{"$f":"Datos!D84","v":0},"m² a razón de",{"$f":"Datos!L84","v":0},{"$f":"IF(Datos!D71=\"SI\",\"$ / m²  x\",\"$ / m²   =\")","v":"$ / m²   ="},{"$f":"IF(Datos!D71=\"SI\",'Acta Est. Obra'!F48,\"\")","v":""},{"$f":"IF(Datos!D71=\"SI\",F28*B28*D28,B28*D28)","v":0},"Sin Antecedentes Municip."]
["Inciso a",null,"Computo y Presupuesto",null,{"$f":"Datos!L85","v":0},null,{"$f":"Datos!R85","v":0},"Sin Antecedentes Municip."]
[null,null,null,null,null,"TOTAL (b2)",{"$f":"SUM(G22:G29)","v":0}]
["Determinación del Honorario por"]
[" 1) Proyecto y Dirección de Obra"]
["  TOTAL",{"$f":"Datos!R73","v":0}]
["  Hasta",null,null,{"$f":"Datos!D74","v":0},{"$f":"Datos!L74","v":0}]
[" el",{"$f":"Datos!D75","v":8.5000000000000006E-2},"s/ siguientes.",{"$f":"Datos!L75","v":0},{"$f":"Datos!R75","v":0}]
[null,null,null,"TOTAL (c1) ",{"$f":"Datos!L73","v":0}]
[]
["Determinación del Honorario por"]
["2) Medición de Obra"]
["  TOTAL",{"$f":"Datos!R86","v":0}]
["  Hasta  ____________________________",null,null,{"$f":"Datos!D87","v":0},{"$f":"Datos!L87","v":0}]
[" el",{"$f":"Datos!D88","v":1.2500000000000001E-2},"s/ siguientes.",{"$f":"Datos!L88","v":0},{"$f":"Datos!R88","v":0}]
[null,null,"TOTAL (c2)",{"$f":"Datos!G86","v":"Mínimo"},{"$f":"Datos!L86","v":0}]
[]
["Otras labores (detallar)",null,"Demolición"]
[{"$f":"Datos!D96","v":0},"m² a razón de",{"$f":"Datos!L96","v":0},"$ / m²   =",{"$f":"Datos!R97","v":0}]
[{"$f":"Datos!E100","v":8.5000000000000006E-2},{"$f":"Datos!E101","v":0.3},{"$f":"Datos!E102","v":0.16},"(c3)",{"$f":"Datos!R100","v":0}]
[null,"Dirección Ejecutiva  ",null,{"$f":"Datos!E103","v":"Si"},{"$f":"Datos!R101","v":0}]
[null,null,null,"TOTAL ",{"$f":"Datos!R102","v":0}]
[]
["Otras labores (detallar)",null," Representación Técnica"]
[]
["  TOTAL",{"$f":"Datos!D107","v":0}]
["  Hasta  ____________________________",null,null,{"$f":"Datos!D109","v":0},{"$f":"Datos!L109","v":0}]
[" el",{"$f":"Datos!D110","v":0.05},"s/ siguientes.",{"$f":"Datos!L110","v":0},{"$f":"Datos!R110","v":0}]
[null,null,null,"TOTAL (c4)",{"$f":"Datos!R111","v":0}]
[]
["Descomposición del Honorario"]
["Proyecto",{"$f":"Datos!K62","v":0},"de",{"$f":"Datos!L73","v":0},{"$f":"Datos!H114","v":0}]
[null,"Medición (c2)",null,{"$f":"Datos!G86","v":"Mínimo"},{"$f":"Datos!H115","v":0}]
[null,"Proy. Demolic.",{"$f":"Datos!F116","v":0},null,{"$f":"Datos!H116","v":0}]
["Dirección",{"$f":"Datos!K63","v":0},"de",{"$f":"Datos!L73","v":0},{"$f":"Datos!H118","v":0}]
[null,"Suplemento por ",{"$f":"IF( Datos!K64=0%,\"Otro Prof. asume la Construcción\",IF(Datos!K64<=20%,\"Estudio de Proyecto\",IF(Datos!K64<=45%,\"Contratos Separados\",IF(Datos!K64>=75%,\"Direccion Ejecutiva\",IF(Datos!K64=60%,IF(Datos!K63=40%,\"Contratos Separados\",\"Direccion Ejecutiva\"))))))","v":"Otro Prof. asume la Construcción"}]
[{"$f":"Datos!K64","v":0},"de",{"$f":"Datos!L73","v":0},null,{"$f":"Datos!H120","v":0},{"$f":"Datos!K18","v":0}]
[null,"Direcc.Demolic.",{"$f":"Datos!K63","v":0},null,{"$f":"Datos!H119","v":0},"MAT C.T.P.B.A.",{"$f":"Datos!K26","v":0}]
[null,"Suplem Demol.",{"$f":"IF( Datos!K64=0%,\"Otro Prof. asume la Construcción\",IF(Datos!K64<=20%,\"Estudio de Proyecto\",IF(Datos!K64<=45%,\"Contratos Separados\",IF(Datos!K64>=75%,\"Direccion Ejecutiva\",IF(Datos!K64=60%,IF(Datos!K63=40%,\"Contratos Separados\",\"Direccion Ejecutiva\"))))))","v":"Otro Prof. asume la Construcción"},null,{"$f":"Datos!H121","v":0}]
["Informe Técnico ",null,null,null,{"$f":"Datos!H122","v":0}]
[null,null,"TOTAL",{"$f":"Datos!P125","v":"Mínimo"},{"$f":"E59+E60+E61+E62+E64+E65+E66+E67","v":0},"Firma y sello asesor técnico"]
[null,null," Honorario convenido",null,{"$f":"Datos!H129","v":0},"(H0)",{"$f":"Datos!T131","v":0}]
["Cuota de Ejercicio Profesional para el Colegio de Técnicos de la Provincia de Buenos Aires"]
["Sucursal banco",null,"fecha","nº de boleta","monto depósito"]
[{"$f":"Datos!K158","v":"MINIMO 748"},null,{"$f":"Datos!K156","v":0},{"$f":"Datos!K157","v":0},{"$f":"Datos!K159","v":374}]
[]
["Aporte para la Caja de Previsión Social para Prof. de la Ingeniería de la Prov. de Bs As",null,null,null,null,null,"AFILIADO Nº",{"$f":"Datos!K27","v":0}]
["Sucursal banco",null,"fecha","nº de boleta","Monto depósito",null,"Porcentaje Liquidado"]
[{"$f":"Datos!K142","v":0},null,{"$f":"Datos!K143","v":0},{"$f":"Datos!K144","v":0},{"$f":"Datos!K145","v":0},null,{"$f":"Datos!K145/Datos!G145","v":{"$error":"#DIV/0!"}}]
[{"$f":"Datos!K146","v":0},null,{"$f":"Datos!K147","v":0},{"$f":"Datos!K148","v":0},{"$f":"Datos!K149","v":0},null,{"$f":"Datos!K149/Datos!G145","v":{"$error":"#DIV/0!"}}]

{"sheet":"Cont 9 art","index":3,"n_rows":67,"n_cols":28,"rows_kept":67,"cut":false,"hidden":false,"merged":[[5,23,5,25],[20,24,20,27],[9,11,9,14],[0,7,0,20],[1,7,1,20],[2,7,2,20],[15,20,15,25],[8,10,8,16],[7,21,7,23],[9,23,9,27],[3,11,3,16],[5,4,5,9],[5,12,5,16],[5,17,5,18],[6,6,6,7],[4,9,4,18],[9,9,9,10],[9,15,9,22],[9,0,9,8],[15,15,15,19],[6,0,6,4],[6,12,6,24],[7,0,7,2],[8,0,8,6],[10,7,10,12],[7,10,7,19],[11,25,11,26],[30,5,30,9],[15,13,15,14],[15,7,15,11],[10,16,10,21],[11,0,11,6],[26,0,26,11],[14,14,14,27],[25,5,25,21],[30,10,30,11],[65,16,65,23],[65,4,65,12],[20,2,20,22],[24,22,24,25],[24,2,24,21],[57,6,57,9]]}
[]
[]
[]
[]
[]
["En la ciudad de",null,null,null,{"$f":"Datos!K37","v":0},null,null,null,null,null," el día",null,{"$f":"Datos!K38","v":0},null,null,null,null,{"$f":"Datos!K39","v":0},null,null,"del mes de",null,null,{"$f":"Datos!K40","v":0},null,null,null,"del año"]
[{"$f":"Datos!K41","v":0},null,null,null,null,null,{"$f":"Datos!K42","v":0},null,",entre el señor",null,null,null,{"$f":"Datos!K29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"DNI","Nº"]
[{"$f":"Datos!K30","v":0},null,null,"con domicilio real en la calle",null,null,null,null,null,null,{"$f":"Datos!K32","v":0},null,null,null,null,null,null,null,null,null,"Nº",{"$f":"Datos!K33","v":0},null,null,null,null,null,",de la localidad de"]
[{"$f":"Datos!K34","v":0},null,null,null,null,null,null,", Partido de ",null,null,{"$f":"Datos!K35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"designado en adelante el COMITENTE, y"]
[{"$f":"Datos!K18","v":0},null,null,null,null,null,null,null,null,"DNI N°",null,{"$f":"Datos!K19","v":0},null,null,null,"con domicilio real en la calle",null,null,null,null,null,null,null,{"$f":"Datos!K20","v":0}]
[{"$f":"Datos!K21","v":0},null,",de la localidad de",null,null,null,null,{"$f":"Datos!K22","v":0},null,null,null,null,null,", Partido de ",null,null,{"$f":"Datos!K23","v":0},null,null,null,null,null,null,null,null,null,null,"con título profesional de"]
[{"$f":"Datos!K24","v":0},null,null,null,null,null,null,"Matrícula del Colegio de Técnicos de la Provincia de Buenos Aires Nº",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Datos!K26","v":0}]
["designado en adelante como el PROFESIONAL, se  conviene en celebrar el presente contrato."]
[]
[null,"Artículo 1º: El comitente encomienda al profesional",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Datos!K55","v":0}]
["de la obra sita en la calle",null,null,null,null,null,null,{"$f":"Datos!K45","v":0},null,null,null,null,"Nº",{"$f":"Datos!K46","v":0},null,"de la localidad de",null,null,null,null,{"$f":"Datos!K47","v":0},null,null,null,null,null,"Partido de"]
[{"$f":"Datos!K48","v":0},null,null,null,"Circ.",null,{"$f":"Datos!K49","v":0},null,"Secc",null,{"$f":"Datos!K50","v":0},null,"Manz",null,{"$f":"Datos!K51","v":0},null,"Parc",null,{"$f":"Datos!K52","v":0},null,"U.F.",null,{"$f":"Datos!K53","v":0}]
[]
[null,"Artículo 2º: Por las tareas detalladas en el artículo anterior, el comitente abonará al profesional los honorarios "]
["de común acuerdo convenidos, que ascienden a la suma de: "]
["Pesos",null,{"$f":"Datos!F130","v":"CERO CON 00/100"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Datos!R129","v":0}]
["conforme a las normas legales en la materia vigentes en la jurisdicción de la Pcia. de Bs. As. y el Código Civil."]
[]
[null,"Artículo 3º: El Comitente abonará al profesional los honorarios pactados en la siguiente forma:"]
["Pesos:",null,{"$f":"Datos!F136","v":"CERO CON 00/100"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Datos!K59=\"Reajuste\",Datos!R129,Datos!H134)","v":0},null,null,null,null,"en este"]
["acto, en concepto de",null,null,null,null,{"$f":"Datos!H137","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"y el saldo en concepto de"]
[{"$f":"Datos!H139","v":0},null,null,null,null,null,null,null,null,null,null,null,"lo hará conforme al avance de los trabajos."]
[]
[]
[null,"Artículo 4º: Se establece como plazo de vigencia del",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Visado Provisorio"]
["presente contrato :",null,null,null,null,{"$f":"Datos!K57","v":0},null,null,null,null,{"$f":"Datos!K58","v":0},null,null,"meses","a partir de"]
["la firma del presente, vencido el cual deberán ratificarse las condi-"]
["ciones pactadas. En caso de silencio se considerará que el profesional "]
["queda automáticamente liberado de toda responsabilidad con relación "]
["a la obra cuyos datos figuran en el presente."]
[]
[null,"Artículo 5º: Con cada percepción de honorarios , el profesional"]
["efectuará los aportes previsionales a que obliga la Ley 12490 art. 26"]
["inciso b."]
[]
[null,"Artículo 6º: La falta de pago de cualquiera de las sumas establecidas, producirá la Mora de Pleno Derecho, "]
["pudiendo el Profesional optar por cobrar un interés punitorio sobre el atraso, o dar por terminados los plazos"]
["establecidos y cobrar el saldo total de lo que adeudare, o rescindir el presente contrato quedando las sumas"]
["abonadas en concepto de indemnización."]
[]
[null,"Artículo 7º: Los gastos extraordinarios serán a exclusi-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Visado Definitivo"]
["vo costo y cargo del Comitente, como así también el pago de los"]
["Derechos de Construcción o sellados ante el Municipio respecti-"]
["vo, por las obras que se ejecutarán."]
[]
[null,"Artículo 8º: Para todos los efectos legales emergentes del"]
["presente contrato las partes constituyen domicilio legal en los"]
["arriba indicados y se someten a la jurisdicción de los Tribunales"]
["Ordinarios de",null,null,null,{"$f":"Datos!K60","v":0},null,null,null,null,null,null,null,"con renun-"]
["ciación expresa a cualquier otro fuero.-"]
[]
[null,"Artículo 9º: De conformidad y para que conste, se firman cinco (5) ejemplares del mismo tenor y a un solo "]
["efecto con carácter de:",null,null,null,null,null,{"$f":"Datos!K59","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Firma del Comitente",null,null,null,null,null,null,null,null,null,null,null,"Firma del Profesional"]
[null,null,null,null,{"$f":"Datos!K29","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Datos!K18","v":0}]
[null,null,null,null,null,null,"CUIL",null,null,{"$f":"Datos!K31","v":0},null,null,null,null,null,null,null,null,"CUIT",null,null,{"$f":"Datos!K25","v":0}]

{"sheet":"Cont 11 art","index":4,"n_rows":72,"n_cols":28,"rows_kept":72,"cut":false,"hidden":false,"merged":[[5,23,5,25],[3,17,3,22],[5,12,5,17],[3,11,3,16],[4,9,4,17],[10,7,10,12],[9,12,9,15],[10,16,10,21],[0,7,0,19],[1,7,1,19],[2,7,2,19],[5,18,5,19],[64,7,64,9],[11,0,11,5],[9,0,9,9],[15,4,15,14],[14,22,14,27],[16,10,16,11],[16,15,16,16],[61,23,61,26],[20,0,20,14],[27,0,27,9],[27,10,27,15],[21,0,21,3],[32,0,32,9],[30,19,30,23],[31,5,31,17],[24,7,24,15],[30,2,30,18],[7,0,7,2],[6,0,6,5],[7,10,7,19],[33,24,33,25],[33,19,33,23],[8,0,8,6],[14,14,14,16],[6,12,6,25],[9,23,9,27],[7,21,7,22],[8,10,8,16],[14,7,14,11],[11,23,11,25],[6,6,6,7],[13,14,13,27]]}
[]
[]
[]
[]
[]
["En la ciudad de",null,null,null,null,{"$f":"Datos!K37","v":0},null,null,null,null," el día",null,{"$f":"Datos!K38","v":0},null,null,null,null,null,{"$f":"Datos!K39","v":0},null,"del mes de",null,null,{"$f":"Datos!K40","v":0},null,null,null,"del año"]
[{"$f":"Datos!K41","v":0},null,null,null,null,null,{"$f":"Datos!K42","v":0},null,",entre el señor",null,null,null,{"$f":"Datos!K29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"DNI"]
[{"$f":"Datos!K30","v":0},null,null,"con domicilio real en la calle",null,null,null,null,null,null,{"$f":"Datos!K32","v":0},null,null,null,null,null,null,null,null,null,"Nº",{"$f":"Datos!K33","v":0},null,null,null,null,null,",de la localidad de"]
[{"$f":"Datos!K34","v":0},null,null,null,null,null,null,", Partido de ",null,null,{"$f":"Datos!K35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"designado en adelante el COMITENTE, y"]
[{"$f":"Datos!K18","v":0},null,null,null,null,null,null,null,null,null,"DNI  Nº",null,{"$f":"Datos!K19","v":0},null,null,null,"con domicilio real en la calle",null,null,null,null,null,null,{"$f":"Datos!K20","v":0}]
[{"$f":"Datos!K21","v":0},null,",de la localidad de",null,null,null,null,{"$f":"Datos!K22","v":0},null,null,null,null,null,", Partido de ",null,null,{"$f":"Datos!K23","v":0},null,null,null,null,null,null,null,null,null,null,"con título profesional de"]
[{"$f":"Datos!K24","v":0},null,null,null,null,null,"Matrícula del Colegio de Técnicos de la Provincia de Buenos Aires Nº",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Datos!K26","v":0},null,null,null,"designado"]
["en adelante como el PROFESIONAL, se  conviene en celebrar el presente contrato."]
[null,"Artículo 1º: El comitente encomienda al profesional",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Datos!K55","v":0}]
["de la obra sita en la calle",null,null,null,null,null,null,{"$f":"Datos!K45","v":0},null,null,null,null,null,"Nº",{"$f":"Datos!K46","v":0},null,null,"de la localidad de:",null,null,null,null,{"$f":"Datos!K47","v":0}]
["Partido de",null,null,null,{"$f":"Datos!K48","v":0}]
["Circ.",null,{"$f":"Datos!K49","v":0},null,"Secc",null,{"$f":"Datos!K50","v":0},null,"Manz",null,{"$f":"Datos!K51","v":0},null,null,"Parc",null,{"$f":"Datos!K52","v":0},null,"U.F.",null,{"$f":"Datos!K53","v":0}]
[null,"Artículo 2º: Por las tareas detalladas en el artículo ante-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Visado Provisorio"]
["rior, el comitente abonará al profesional los honorarios de co-"]
["mún acuerdo convenidos, que ascienden a la suma de pesos:"]
[{"$f":"Datos!F130","v":"CERO CON 00/100"}]
[{"$f":"Datos!R129","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"conforme a las normas legales en la materia"]
["vigentes en la jurisdicción de la Provincia de Buenos Aires y"]
["el Código Civil."]
[null,"Artículo 3º: El Sr.",null,null,null,null,null,{"$f":"Datos!K29","v":0}]
["como comitente, toma a su exclusivo cargo la ejecución de la"]
["obra como Empresario.",null,null,null,null,null,null,"Sistema de Ejecución de Obra por:"]
[{"$f":"Anexa!D12","v":"OTRO PROFESIONAL ASUME LA CONSTRUCCION"},null,null,null,null,null,null,null,null,null,{"$f":"Anexa!G12","v":"."}]
[null,"Artículo 4º: El Comitente abonará al profesional los ho-"]
["norarios pactados en la siguiente forma:"]
["Pesos",null,{"$f":"Datos!F136","v":"CERO CON 00/100"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Datos!K59=\"Reajuste\",Datos!R129,Datos!H134)","v":0},null,null,null,null,"en este acto, "]
["en concepto de",null,null,null,null,{"$f":"Datos!H137","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"y el saldo, en concepto de: "]
[{"$f":"Datos!H139","v":0},null,null,null,null,null,null,null,null,null,"lo hará conforme al avance de la misma."]
[null,"Artículo 5º: Se establece como plazo de vigencia del presente contrato :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Datos!K57","v":0},null,null,null,null,{"$f":"Datos!K58","v":0}]
["meses, vencido el cual deberán ratificarse las condiciones pactadas. De no hacerse lo expresado, dentro de los "]
["quince (15) días posteriores al vencimiento, el Profesional queda desvinculado de sus obligaciones "]
["profesionales sin necesidad de comunicación alguna al comitente."]
[null,"Artículo 6º: Con cada percepción de honorarios , el PROFESIONAL efectuará los aportes previsionales a "]
["que obliga la Ley 12490 art. 26 inc. b."]
[null,"Artículo 7º: La falta de pago de cualquiera de las sumas establecidas, producirá la Mora de Pleno Derecho, "]
["pudiendo el Profesional optar por cobrar un interés punitorio "]
["sobre el atraso, o dar por terminados los plazos establecidos y cobrar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Visado Definitivo"]
["el saldo total de lo que se le adeudare, o rescindir el presente"]
["contrato quedando los sumas abonadas en concepto de"]
["indemnización."]
[null,"Artículo 8º: En virtud de lo establecido en el artículo 3º"]
["del presente, el COMITENTE asume expresamente bajo su"]
["responsabilidad, los incisos que a continuación se expresan:"]
["a) La contratación de todo el personal, el pago de sus remu-"]
["    neraciones, aportes legales (obra social, previsional, sindi-"]
["    cal, etc.) indemnizaciones y cualquier otro crédito laboral,"]
["    como así también, toda responsabilidad laboral, civil y/o"]
["    penal que pudiera derivar de dicha relación, conforme lo "]
["    determinan las normativas vigentes;"]
["b) La contratación de los seguros de riesgo por accidente de trabajo, de vida y cualquier otro que exigen las normas"]
["     que rigen la actividad."]
["c) El cumplimiento de las normas sobre Seguridad e Higiene en el Trabajo y Medicina Laboral."]
["d) La compra de la totalidad de materiales que demande la construcción de la obra."]
[null,"Artículo 9º: Los gastos extraordinarios serán a exclusivo costo y cargo del Comitente, como así también el "]
["pago de los Derechos de Construcción o sellados ante el Municipio respectivo, por las obras que se ejecutarán."]
[null,"Artículo 10º:Para todos los efectos legales emergentes del presente contrato las partes constituyen domicilio"]
[" legal en los arriba indicados y se someten a la jurisdicción de los Tribunales Ordinarios de",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Datos!K60","v":0}]
["con renunciación expresa a cualquier otro fuero.-"]
[null,"Artículo 11º: De conformidad y para que conste, se firman cinco (5) ejemplares del mismo tenor y a un solo "]
["efecto con el carácter de:",null,null,null,null,null,null,{"$f":"Datos!K59","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Firma del Comitente",null,null,null,null,null,null,null,null,null,null,null,"Firma del Profesional"]
[null,null,null,null,null,{"$f":"Datos!K29","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Datos!K18","v":0}]
[null,null,null,null,null,null,"CUIL",null,{"$f":"Datos!K31","v":0},null,null,null,null,null,null,null,null,null,"CUIT",null,null,{"$f":"Datos!K25","v":0}]

{"sheet":"Cont-Transcrip.Corrida","index":5,"n_rows":30,"n_cols":1,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[{"$f":"Cálculos!A8&\" \"&Cálculos!B8&\"\"&Cálculos!C8&\" \"&Cálculos!D8&\" \"&Cálculos!E8&\" \"&Cálculos!F8&\" \"&Cálculos!G8&\" \"&Cálculos!H8&\" \"&Cálculos!I8&\" \"&Cálculos!J8&\" \"&Cálculos!A9&\" \"&Cálculos!B9&\"\"&Cálculos!C9&\" \"&Cálculos!D9&\"\"&Cálculos!E9&\" \"&Cálculos!F9&\" \"&Cálculos!G9&\" \"&Cálculos!H9&\" \"&Cálculos!I9&\" \"&Cálculos!J9&\" \"&Cálculos!A10&\" \"&Cálculos!B10&\" \"&Cálculos!C10&\"\"&Cálculos!D10&\" \"&Cálculos!E10&\"\"&Cálculos!F10&\" \"&Cálculos!G10&\"\"&Cálculos!H10&\" \"&Cálculos!I10&\"\"&Cálculos!J10&\" \"&Cálculos!A11&\" \"&Cálculos!B11&\" \"&Cálculos!C11&\" \"&Cálculos!D11&\"\"&Cálculos!E11&\" \"&Cálculos!F11&\"\"&Cálculos!G11&\" \"&Cálculos!H11&\"\"&Cálculos!I11&\" \"&Cálculos!J11&\"\"&Cálculos!A12&\" \"&Cálculos!B12&\" \"&Cálculos!C12&\" \"&Cálculos!D12&\"\"&Cálculos!E12&\" \"&Cálculos!F12&\"\"&Cálculos!G12&\" \"&Cálculos!H12&\"\"&Cálculos!I12&\" \"&Cálculos!J12&\"\"","v":"            En la ciudad de 0, el día 0 0 de 0 del año 0 0 entre el señor 0, DNI Nº 0, con domicilio real en 0 0     de la localidad de 0, Partido de  0, llamado en adelante el COMITENTE, y 0, DNI Nº 0, con domicilio real en 0 0 de la localidad de 0, Partido de 0, Con Título Profesional de 0, Matrícula del Colegio de Técnicos de la Provincia de Buenos Aires Nº 0, llamado en adelante el PROFESIONAL, se conviene en celebrar el siguiente contrato de Locación de Servicios.        "}]
[{"$f":"Cálculos!A13&\" \"&Cálculos!B13&\" \"&Cálculos!C13&\" \"&Cálculos!D13&\" \"&Cálculos!E13&\" \"&Cálculos!F13&\" \"&Cálculos!G13&\" \"&Cálculos!H13&\" \"&Cálculos!I13&\" \"&Cálculos!J13&\" \"&Cálculos!K13&\" \"&Cálculos!A14&\" \"&Cálculos!B14&\" \"&Cálculos!C14&\" \"&Cálculos!D14&\" \"&Cálculos!E14&\" \"&Cálculos!F14&\" \"&Cálculos!G14&\" \"&Cálculos!H14&\" \"&Cálculos!I14&\" \"&Cálculos!J14&\" \"&Cálculos!A15&\" \"&Cálculos!B15&\" \"&Cálculos!C15","v":"               Artículo 1º)   El COMITENTE encomienda al PROFESIONAL lo siguiente: 0 , para la obra ubicada en 0 Nº 0 , de la localidad de 0 Partido de 0 ; cuya designación catastral es Circunscripción: 0 Sección: 0 Manzana: 0 Parcela: 0 U.F.: 0 . DESTINO: 0 "}]
[{"$f":"Cálculos!A16&\" \"&Cálculos!C16&\" \"&Cálculos!B16&\"\"&Cálculos!D16","v":"               Artículo 2º)   Por las tareas detalladas en el artículo anterior el COMITENTE abonará al PROFESIONAL, los honorarios de común acuerdo convenidos, que ascienden a la suma de pesos: $ 0 CERO CON 00/100. Conforme a las normas legales, vigentes en la jurisdicción de la Provincia de Buenos Aires y el Código Civil."}]
[{"$f":"Cálculos!A17&\"  \"&Cálculos!B17&\" \"&Cálculos!C17","v":"               Artículo 3º)  El Sr.   0 , en su carácter de COMITENTE, toma a su exclusivo cargo, la ejecución de la obra como EMPRESARIO."}]
[{"$f":"Cálculos!D17&\" \"&Cálculos!E17&\" \"&Cálculos!F17","v":"SISTEMA de EJECUCIÓN de OBRA POR: OTRO PROFESIONAL ASUME LA CONSTRUCCION ."}]
[{"$f":"Cálculos!A18&\"  \"&Cálculos!B18&\" \"&Cálculos!C18&\" \"&Cálculos!D18&\"  \"&Cálculos!E18&\" \"&Cálculos!F18&\" \"&Cálculos!G18&\" \"&Cálculos!H18&\" \"&Cálculos!I18&\" \"&Cálculos!J18","v":"               Artículo 4º)  El COMITENTE abonará al PROFESIONAL los honorarios pactados en la siguiente forma: $   0 CERO CON 00/100  en este acto, en concepto de: 0 y el saldo, de $ 0 en concepto de 0"}]
[{"$f":"Cálculos!A19&\"  \"&Cálculos!B19&\" \"&Cálculos!C19&\" \"&Cálculos!D19&\"  \"&Cálculos!E19&\" \"&Cálculos!F19&\" \"&Cálculos!G19&\" \"&Cálculos!H19&\" \"&Cálculos!I19&\" \"&Cálculos!J19&\" \"&Cálculos!K19&\"\"","v":"               Artículo 5º)  Se establece el plazo de vigencia del presente contrato en:  0 meses 0  . Vencido el cual, deberán ratificarse las condiciones pactadas. De no hacerse lo expresado, dentro de los quince (15) días posteriores al vencimiento, el PROFESIONAL queda liberado de sus obligaciones, sin necesidad de comunicación alguna al COMITENTE.      "}]
[{"$f":"Cálculos!A20","v":"               Artículo 6º)  Con cada percepción de honorarios, el PROFESIONAL, efectuará los aportes previsionales que obliga el Art. 26 inc. b) de la Ley 12490."}]
[{"$f":"Cálculos!A21","v":"               Artículo 7º)   La falta de pago de cualquiera de las sumas establecidas, producirá la Mora de Pleno Derecho, pudiendo el Profesional optar por cobrar un interés punitorio sobre el atraso, o dar por terminados los plazos establecidos y cobrar el saldo total de lo que se le adeudare, o rescindir el presente contrato quedando los sumas abonadas en concepto de indemnización."}]
[{"$f":"Cálculos!A22","v":"               Artículo 8º)   En virtud de lo establecido en el artículo 3º del presente, el COMITENTE asume expresamente bajo su costa y responsabilidad, los incisos que a continuación se indican: "}]
[{"$f":"Cálculos!A23","v":"a) La contratación de todo el personal, el pago de sus remuneraciones, aportes legales (obra social, previsional, sindical, etc.) indemnizaciones y cualquier otro crédito laboral,  como así también, toda responsabilidad laboral, civil y/o penal que pudiera derivar de dicha relación, conforme lo determinan las normativas vigentes;"}]
[{"$f":"Cálculos!A24","v":"b) La contratación de los seguros de riesgo por accidente de trabajo, de vida y cualquier otro que exigen las normas  que rigen la actividad."}]
[{"$f":"Cálculos!A25","v":"c) El cumplimiento de las normas sobre Seguridad e Higiene en el Trabajo y Medicina Laboral."}]
[{"$f":"Cálculos!A27","v":"               Artículo 9º)  Los gastos extraordinarios serán a exclusivo costo y cargo del Comitente, como así también el pago de los Derechos de Construcción o sellados ante el Municipio respectivo, por las obras que se ejecutarán.  "}]
[{"$f":"Cálculos!A28&\"  \"&Cálculos!B28&\" \"&Cálculos!C28&\"\"","v":"               Artículo 10º)  Para todos los efectos legales emergentes del presente contrato las partes constituyen domicilio legal en los arriba indicados y se someten a la jurisdicción de los Tribunales Ordinarios de   0 renunciando a cualquier otro fuero o jurisdicción.-"}]
[{"$f":"Cálculos!A29&\"  \"&Cálculos!B29","v":"               Artículo 11º)  De conformidad y para que conste, se firman cinco (5) ejemplares del mismo tenor y a un solo efecto con el carácter de:   0"}]
[]
[]
[]
[]
[{"$f":"Cálculos!A30&\"                      \"&Cálculos!B30","v":"Firma del Comitente                                    Firma del Profesional"}]
[{"$f":"Cálculos!A31&\"                           \"&Cálculos!B31","v":"0                           0"}]
[{"$f":"Cálculos!A32&\" \"&Cálculos!B32&\"                                                     \"&Cálculos!C32&\" \"&Cálculos!D32","v":"CUIL 0                                                     CUIT 0"}]
[]
["VISADO"]

{"sheet":"Art. 29","index":6,"n_rows":48,"n_cols":12,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,0,1,11],[39,6,39,7],[10,4,10,5],[5,3,5,9],[3,0,3,11],[38,6,38,7],[37,0,37,5],[37,6,37,7],[14,8,14,9],[39,8,39,9],[37,8,37,9],[15,5,15,6],[16,5,16,6],[17,5,17,6],[18,5,18,6],[35,3,35,11],[47,9,47,10],[46,10,46,11],[46,8,46,9],[37,10,37,11],[38,10,38,11],[39,10,39,11],[38,8,38,9]]}
["CAJA DE PREVISION SOCIAL PARA AGRIMENSORES, ARQUITECTOS, INGENIEROS            "]
["Y TECNICOS DE LA PROVINCIA DE BUENOS AIRES       "]
[]
["CONTRIBUCIÓN OBLIGATORIA (Art 29 Ley 12490)"]
[]
[null,null,null,"* CONSTRUCCIONES CIVILES *"]
[]
["        PLANILLA ANEXA CORRESPONDIENTE AL CONTRATO CELEBRADO EL :",null,null,null,null,null,null,null,null,{"$f":"Datos!K38","v":0},null,"de"]
[{"$f":"Datos!K40","v":0},null,null,"de",{"$f":"Datos!K41","v":0}]
["Propietario ó Beneficiario:",null,null,null,{"$f":"Datos!K29","v":0},null,null,null,"Profesional:",{"$f":"Datos!K18","v":0}]
["para la obra sita en la calle:",null,null,null,{"$f":"Datos!K45","v":0},null,{"$f":"Datos!K46","v":0},null,"Localidad de:",{"$f":"Datos!K47","v":0}]
[]
["Estimación del valor de obra:",null,null,null,{"$f":"IF(Datos!D71=\"SI\",\" SEGÚN EL PORCENTAJE DE OBRA EJECUTADA SIN ANTECEDENTE MUNICIPAL\",\"\")","v":""}]
[]
["Según art.º 8º del Título VIII (Decreto 6964/65):",null,null,null,null,null,null,null,{"$f":"IF(Datos!D71=\"SI\",\"% EJECUTADO\",\"\")","v":""}]
["Tipo/categoría 8º",null,null,"superficie",{"$f":"Datos!D81","v":0},"m² a razón de $/m²",null,{"$f":"Datos!L81","v":0},{"$f":"IF(Datos!D71=\"SI\",\"X\",\"\")","v":""},{"$f":"IF(Datos!D71=\"SI\",'Acta Est. Obra'!F48,\"\")","v":""}," =   $ ",{"$f":"IF(Datos!D71=\"SI\",E16*H16*'Acta Est. Obra'!F48,E16*H16)","v":0}]
["Tipo/categoría 8º",null,null,"superficie",{"$f":"Datos!D82","v":0},"m² a razón de $/m²",null,{"$f":"Datos!L82","v":0},{"$f":"IF(Datos!D71=\"SI\",\"X\",\"\")","v":""},{"$f":"IF(Datos!D71=\"SI\",'Acta Est. Obra'!F48,\"\")","v":""}," =   $ ",{"$f":"IF(Datos!D71=\"SI\",E17*H17*'Acta Est. Obra'!F48,E17*H17)","v":0}]
["Tipo/categoría 8º",null,null,"superficie",{"$f":"Datos!D83","v":0},"m² a razón de $/m²",null,{"$f":"Datos!L83","v":0},{"$f":"IF(Datos!D71=\"SI\",\"X\",\"\")","v":""},{"$f":"IF(Datos!D71=\"SI\",'Acta Est. Obra'!F48,\"\")","v":""}," =   $ ",{"$f":"IF(Datos!D71=\"SI\",E18*H18*'Acta Est. Obra'!F48,E18*H18)","v":0}]
["Tipo/categoría 8º",null,null,"superficie",{"$f":"Datos!D84","v":0},"m² a razón de $/m²",null,{"$f":"Datos!L84","v":0},{"$f":"IF(Datos!D71=\"SI\",\"X\",\"\")","v":""},{"$f":"IF(Datos!D71=\"SI\",'Acta Est. Obra'!F48,\"\")","v":""}," =   $ ",{"$f":"IF(Datos!D71=\"SI\",E19*H19*'Acta Est. Obra'!F48,E19*H19)","v":0}]
["Tipo/categoría 8º",null,null,null,null,null,null,null,"Computo y Presupuesto",{"$f":"Datos!L85","v":0}," =   $ ",{"$f":"Datos!R85","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"TOTAL (1): $ ",{"$f":"SUM(L16:L20)","v":0}]
[]
[]
["DETERMINACIÓN DE LA CONTRIBUCIÓN:"]
[]
["Proyecto y Dirección: Categoría 8º s/ tabla XVII (Decreto 6964/65)",null,null,null,null,null,null,null,null,null,"TOTAL (1): $ ",{"$f":"L22","v":0}]
[]
[null,null,"hasta",null,"$",{"$f":"Datos!D91","v":0},null,null,null,null,"$ ",{"$f":"Datos!L91","v":0}]
[null,{"$f":"Datos!D92","v":8.5000000000000006E-2},"sobre los siguientes  ",null,"$",{"$f":"Datos!L92","v":0},null,null,null,null,"$ ",{"$f":"Datos!R92","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"TOTAL (c1): $ ",{"$f":"SUM(L29,L30)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"10 % de c1 $ ",{"$f":"ROUND(L32*10%,1)","v":0}]
[null,null,"Son Pesos:",{"$f":"Datos!K154","v":"CERO CON 00/100"}]
[]
["Contribución a cargo del Propietario ó Beneficiario",null,null,null,null,null,"fecha:",null,"Sucursal",null,"Importe"]
["Contribución Art.º 29 Ley 12490",null,null,null,"Nº de Boleta:",{"$f":"Datos!K152","v":0},{"$f":"Datos!K151","v":0},null,{"$f":"Datos!K150","v":0},null,{"$f":"Datos!K153","v":0}]
["Contribución Art.º 29 Ley 12490",null,null,null,"Nº de Boleta",null,null,null,"DASDASD",null,{"$f":"IF(K39>=L35,\".\",L35-K39)","v":"."}]
[]
[]
[]
[]
[]
[null,null,null,"FIRMA del COMITENTE",null,null,null,null,"FIRMA PROFESIONAL"]
[null,null,"CUIL",{"$f":"Datos!K31","v":0},null,null,null,null,"MAT. CTPBA N°:",null,{"$f":"Datos!K26","v":0}]
[null,null,null,null,null,null,null,null,"CUIT",{"$f":"Datos!K25","v":0}]

{"sheet":"Reaj.","index":7,"n_rows":72,"n_cols":28,"rows_kept":72,"cut":false,"hidden":false,"merged":[[64,7,64,9],[32,0,32,18],[15,4,15,14],[16,10,16,11],[16,15,16,16],[20,0,20,14],[33,24,33,25],[61,23,61,26],[30,19,30,23],[33,19,33,23],[21,0,21,3],[24,7,24,15],[30,2,30,18],[27,0,27,9],[27,10,27,15],[11,0,11,5],[11,23,11,25],[13,14,13,27],[14,7,14,11],[14,12,14,14],[14,15,14,16],[14,22,14,27],[10,7,10,12],[10,16,10,21],[6,0,6,5],[6,6,6,7],[6,12,6,25],[7,0,7,2],[7,10,7,19],[7,21,7,22],[8,0,8,6],[8,10,8,16],[9,0,9,9],[9,13,9,15],[9,23,9,27],[0,7,0,19],[1,7,1,19],[2,7,2,19],[4,9,4,17],[5,12,5,17],[5,18,5,19]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Datos!K59=\"Reajuste\",\"CONTRATO DE REAJUSTE\",\".\")","v":"."}]
["En la ciudad de",null,null,null,null,{"$f":"Datos!K37","v":0},null,null,null,null," el día",null,{"$f":"Datos!K38","v":0},null,null,null,null,null,{"$f":"Datos!K39","v":0},null,"del mes de",null,null,{"$f":"Datos!K40","v":0},null,null,null,"del año"]
[{"$f":"Datos!K41","v":0},null,null,null,null,null,{"$f":"Datos!K42","v":0},null,",entre el señor",null,null,null,{"$f":"Datos!K29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"DNI"]
[{"$f":"Datos!K30","v":0},null,null,"con domicilio real en la calle",null,null,null,null,null,null,{"$f":"Datos!K32","v":0},null,null,null,null,null,null,null,null,null,"Nº",{"$f":"Datos!K33","v":0},null,null,null,null,null,",de la localidad de"]
[{"$f":"Datos!K34","v":0},null,null,null,null,null,null,", Partido de ",null,null,{"$f":"Datos!K35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"designado en adelante el COMITENTE, y"]
[{"$f":"Datos!K18","v":0},null,null,null,null,null,null,null,null,null,"DNI  Nº",null,null,{"$f":"Datos!K19","v":0},null,null,"con domicilio real en la calle",null,null,null,null,null,null,{"$f":"Datos!K20","v":0}]
[{"$f":"Datos!K21","v":0},null,",de la localidad de",null,null,null,null,{"$f":"Datos!K22","v":0},null,null,null,null,null,", Partido de ",null,null,{"$f":"Datos!K23","v":0},null,null,null,null,null,null,null,null,null,null,"con título profesional de"]
[{"$f":"Datos!K24","v":0},null,null,null,null,null,"Matrícula del Colegio de Técnicos de la Provincia de Buenos Aires Nº",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Datos!K26","v":0},null,null,null,"designado"]
["en adelante como el PROFESIONAL, se  conviene en celebrar el presente contrato."]
[null,"Artículo 1º: El comitente encomienda al profesional",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Datos!K55","v":0}]
["de la obra sita en la calle",null,null,null,null,null,null,{"$f":"Datos!K45","v":0},null,null,null,null,"Nº",null,null,{"$f":"Datos!K46","v":0},null,"de la localidad de:",null,null,null,null,{"$f":"Datos!K47","v":0}]
["Partido de",null,null,null,{"$f":"Datos!K48","v":0}]
["Circ.",null,{"$f":"Datos!K49","v":0},null,"Secc",null,{"$f":"Datos!K50","v":0},null,"Manz",null,{"$f":"Datos!K51","v":0},null,null,"Parc",null,{"$f":"Datos!K52","v":0},null,"U.F.",null,{"$f":"Datos!K53","v":0}]
[null,"Artículo 2º: Por las tareas detalladas en el artículo ante-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Visado Provisorio"]
["rior, el comitente abonará al profesional los honorarios de "]
["REAJUSTE convenidos, que ascienden a la suma de pesos:"]
[{"$f":"Datos!F130","v":"CERO CON 00/100"}]
[{"$f":"Datos!R129","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"conforme a las normas legales en la materia"]
["vigentes en la jurisdicción de la Provincia de Buenos Aires y"]
["el Código Civil."]
[null,"Artículo 3º: El Sr.",null,null,null,null,null,{"$f":"Datos!K29","v":0}]
["como comitente, toma a su exclusivo cargo la ejecución de la"]
["obra como Empresario.",null,null,null,null,null,null,"Sistema de Ejecución de Obra por:"]
[{"$f":"Anexa!D12","v":"OTRO PROFESIONAL ASUME LA CONSTRUCCION"},null,null,null,null,null,null,null,null,null,{"$f":"Anexa!G12","v":"."}]
[null,"Artículo 4º: El Comitente abonará al profesional los ho-"]
["norarios pactados en el presente contrato de REAJUSTE al contado."]
["Pesos",null,{"$f":"Datos!F136","v":"CERO CON 00/100"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Datos!H134","v":0},null,null,null,null,"en este acto, "]
["en concepto de Reajuste de Honorarios, quedando vigentes todas las cláusulas pactadas en el Contrato "]
["Originario firmado por las partes oportunamente."]
[null,"Artículo 5º: Se establece como plazo de vigencia del presente contrato :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Datos!K57","v":0},null,null,null,null,{"$f":"Datos!K58","v":0}]
["meses, vencido el cual deberán ratificarse las condiciones pactadas. De no hacerse lo expresado, dentro de los "]
["quince (15) días posteriores al vencimiento, el Profesional queda desvinculado de sus obligaciones "]
["profesionales sin necesidad de comunicación alguna al comitente."]
[null,"Artículo 6º: Con cada percepción de honorarios , el PROFESIONAL efectuará los aportes previsionales a "]
["que obliga la Ley 12490 art. 26 inc. b."]
[null,"Artículo 7º: La falta de pago de cualquiera de las sumas establecidas, producirá la Mora de Pleno Derecho, "]
["pudiendo el Profesional optar por cobrar un interés punitorio "]
["sobre el atraso, o dar por terminados los plazos establecidos y cobrar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Visado Definitivo"]
["el saldo total de lo que se le adeudare, o rescindir el presente"]
["contrato quedando los sumas abonadas en concepto de"]
["indemnización."]
[null,"Artículo 8º: En virtud de lo establecido en el artículo 3º"]
["del presente, el COMITENTE asume expresamente bajo su"]
["responsabilidad, los incisos que a continuación se expresan:"]
["a) La contratación de todo el personal, el pago de sus remu-"]
["    neraciones, aportes legales (obra social, previsional, sindi-"]
["    cal, etc.) indemnizaciones y cualquier otro crédito laboral,"]
["    como así también, toda responsabilidad laboral, civil y/o"]
["    penal que pudiera derivar de dicha relación, conforme lo "]
["    determinan las normativas vigentes;"]
["b) La contratación de los seguros de riesgo por accidente de trabajo, de vida y cualquier otro que exijan las normas"]
["     que rigen la actividad."]
["c) El cumplimiento de las normas sobre Seguridad e Higiene en el Trabajo y Medicina Laboral."]
["d) La compra de la totalidad de materiales que demande la construcción de la obra."]
[null,"Artículo 9º: Los gastos extraordinarios serán a exclusivo costo y cargo del Comitente, como así también el "]
["pago de los Derechos de Construcción o sellados ante el Municipio respectivo, por las obras que se ejecutarán."]
[null,"Artículo 10º:Para todos los efectos legales emergentes del presente contrato las partes constituyen domicilio"]
[" legal en los arriba indicados y se someten a la jurisdicción de los Tribunales Ordinarios de",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Datos!K60","v":0}]
["con renunciación expresa a cualquier otro fuero.-"]
[null,"Artículo 11º: De conformidad y para que conste, se firman cinco (5) ejemplares del mismo tenor y a un solo "]
["efecto con el carácter de:",null,null,null,null,null,null,{"$f":"Datos!K59","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Firma del Comitente",null,null,null,null,null,null,null,null,null,null,null,"Firma del Profesional"]
[null,null,null,null,{"$f":"Datos!K29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Datos!K18","v":0}]
[null,null,null,null,null,"CUIL",null,null,{"$f":"Datos!K31","v":0},null,null,null,null,null,null,null,null,null,"CUIT",{"$f":"Datos!K25","v":0}]

{"sheet":"Cert. Constructor","index":8,"n_rows":62,"n_cols":17,"rows_kept":62,"cut":false,"hidden":false,"merged":[[29,7,29,8],[29,9,29,10],[25,5,25,6],[25,2,25,3],[22,5,22,6],[50,1,50,4],[47,1,47,4],[51,1,51,4],[21,3,21,4],[22,3,22,4],[24,12,24,13],[24,7,24,11],[34,7,34,14],[34,0,34,6],[46,9,46,10],[46,1,46,4],[25,12,25,13],[26,12,26,13],[33,9,33,10],[28,2,28,3],[28,9,28,10],[45,11,45,13],[42,12,42,14],[25,0,25,1],[30,9,30,10],[25,9,25,10],[52,13,52,14],[46,7,46,8],[47,7,47,8],[46,5,46,6],[47,5,47,6],[51,5,51,6],[50,9,50,10],[50,13,50,14],[47,9,47,10],[50,5,50,6],[50,7,50,8],[51,13,51,14],[51,9,51,10],[51,7,51,8],[6,4,6,12],[20,3,20,4],[2,3,2,14],[19,3,19,4],[19,5,19,6],[19,9,19,10],[19,12,19,13],[14,0,14,3],[14,9,14,12],[20,12,20,13],[14,14,14,15],[8,3,8,5],[8,9,8,10],[8,11,8,14],[13,7,13,12],[14,6,14,8],[8,7,8,8],[21,12,21,13],[21,5,21,6],[23,5,23,6],[20,5,20,6],[23,7,23,8],[20,9,20,10],[22,12,22,13],[23,12,23,13],[9,13,9,14],[15,9,15,10],[21,9,21,10],[22,9,22,10],[23,9,23,10]]}
[]
[]
[]
[]
[]
[null,"PROPIETARIO: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fecha Actual"]
[null,null,null,null,{"$f":"Datos!K29","v":0},null,null,null,null,null,null,null,null,"Fecha :",null,null,{"$f":"TODAY()","v":"2020-06-26"}]
[null,"UBICACIÓN DE LA OBRA:"]
[null,null,"Calle:",{"$f":"Datos!K45","v":0},null,null,"N°",{"$f":"Datos!K46","v":0},null,"Localidad:",null,{"$f":"Datos!K47","v":0}]
[null,null,"Circ.:",{"$f":"Datos!K49","v":0},"Sec.:",{"$f":"Datos!K50","v":0},"Manz.:",{"$f":"Datos!K51","v":0},"Parc.:",{"$f":"Datos!K52","v":0},"U.F.:",{"$f":"Datos!K53","v":0},"Partido:",{"$f":"Datos!K48","v":0}]
[]
[null,"Al Sr. Presidente del Colegio de Técnicos de la Provincia de Buenos Aires:"]
[]
[null,"Quien suscribe el presente, Técnico",null,null,null,null,null,null,null,null,null,null,null,"con domicilio en la calle"]
[null,null,null,null,"N°",null,"de la localidad de",null,null,null,null,null,null,"Partido: "]
["inscripto en el Colegio de Técnicos con la Matrícula: ",null,null,null,null,null,null,null,null,null,null,"se dirige al Sr. Presidente a fin de"]
["requerirle, se sirva disponer al otorgamiento del presente Certificado por TAREAS de CONSTRUCCIÓN."]
[]
[null,"1) DETERMINACIÓN  DEL MONTO DE OBRA NUEVA",null,null,null,null,null,null,"FC:",{"$f":"Anexa!G13","v":1.3},null,null,"U.R.:",{"$f":"Datos!C15","v":26000}]
[null,null,"Categoría 8º","en _________",null,{"$f":"Anexa!C14","v":0},null,"m² a razón de",null,{"$f":"Anexa!E14","v":0},null,"$ / m² =",{"$f":"Anexa!G14","v":0}]
[null,null,"Categoría 8º","en _________",null,{"$f":"Anexa!C15","v":0},null,"m² a razón de",null,{"$f":"Anexa!E15","v":0},null,"$ / m² =",{"$f":"Anexa!G15","v":0}]
[null,null,"Categoría 8º","en _________",null,{"$f":"Anexa!C16","v":0},null,"m² a razón de",null,{"$f":"Anexa!E16","v":0},null,"$ / m² =",{"$f":"Anexa!G16","v":0}]
[null,null,"Categoría 8º","en _________",null,{"$f":"Anexa!C17","v":0},null,"m² a razón de",null,{"$f":"Anexa!E17","v":0},null,"$ / m² =",{"$f":"Anexa!G17","v":0}]
[null,null,"Trabajos Faltantes",null,{"$f":"IF(Datos!D71=\"no\",\"NO\",100%-'Acta Est. Obra'!F48)","v":"NO"},{"$f":"Anexa!C18","v":0},null,{"$f":"Anexa!D18","v":" m² a razón calc."},null,{"$f":"Anexa!E18","v":0},null,"$ / m² =",{"$f":"Anexa!G18","v":0}]
[null,null,"Categoría 8º",null,null,null,null,"Computo y Presupuesto monto global",null,null,null,null,{"$f":"Anexa!G19","v":0}]
["Demolic.",null,{"$f":"IF(E26=30%,\"Estado Bueno\",IF(E26=45%,\"Estado Regular\",\"Estado peligroso\"))","v":"Estado Bueno"},null,{"$f":"Datos!E101","v":0.3},{"$f":"Anexa!A46","v":0},null,"m² a razón de",null,{"$f":"Anexa!C46","v":0},null,"$ / m² =",{"$f":"E26*F26*J26","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(M20:M26)","v":0}]
[null,"2) DETERMINACIÓN  DEL HONORARIO"]
[null,"hasta",{"$f":"Datos!AE106","v":0},null,null,"acumulado",null,null,null,{"$f":"Datos!AF106","v":0}]
[null,"el",null,{"$f":"Datos!AH106","v":1.7000000000000001E-2},null,"s/ siguientes",null,{"$f":"Datos!AG106","v":0},null,{"$f":"ROUNDUP(Datos!AI106,2)","v":0}]
[null,null,null,null,null,null,"HONORARIO TOTAL",null,null,{"$f":"SUM(J29:K30)","v":0}]
[null,null,null,null,{"$f":"IF(J34<J31,\"EL HONORARIO CONVENIDO DEBE SER IGUAL O MAYOR QUE EL HONORARIO TOTAL\",\"\")","v":""}]
[null,null,null,null,{"$f":"IF(J34<Datos!S13,\"NO CUMPLE EL MÍNIMO POR CUALQUIER TAREA PROFESIONAL \",\"\")","v":""}]
[null,null,null,null,null,"HONORARIO CONVENIDO",null,null,null,"ASDASD"]
["El honorario del presente asciende a pesos:",null,null,null,null,null,null,{"$f":"Importe!F41","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[]
[]
[]
[null,null,null,"PROPIETARIO",null,null,null,null,null,null,null,null,null,"CONSTRUCTOR"]
[null,null,{"$f":"E7","v":0},null,null,null,null,null,null,null,null,null,{"$f":"H14","v":0}]
[null,null,null,"CUIL",{"$f":"Datos!K31","v":0},null,null,null,null,null,null,null,null,"CUIT"]
[]
[null,"Cuota de Ejercicio Prof. para el Coleg. de Técnicos de la Prov. de Bs As",null,null,null,null,null,null,null,null,null,"Sellado "]
[null,"Sucursal Banco",null,null,null,"fecha",null,"nº de boleta",null,"Monto depósito",null,1.0999999999999999E-2,1.2E-2,1.2999999999999999E-2]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Datos!AC110,2)","v":{"$error":"#VALUE!"}},null,{"$f":"J34*1.1%","v":{"$error":"#VALUE!"}},{"$f":"J34*1.2%","v":{"$error":"#VALUE!"}},{"$f":"J34*1.3%","v":{"$error":"#VALUE!"}}]
[]
[null,"Aporte para la Caja de Previsión Social para Prof. de la Ingeniería de la Prov. de Bs As  AFILIADO N°"]
[null,"Sucursal Banco",null,null,null,"fecha",null,"nº de boleta",null,"Monto depósito"]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND(J34*0.1,2)","v":{"$error":"#VALUE!"}}]
[]
["    Me notifico que la presente certificación no me exime de las  ",null,null,null,null,null,null,null,null,null,null,"VISADO"]
["obligaciones legales (Código Civil Art. 1.646), Impositivas (Ingresos  "]
["Brutos, Afip; Ley de sellos) Previsionales ni Sindicales."]
[]
["   El profesional solicitante del presente tiene matrícula al día, no tiene "]
["inhabilitaciones y tiene incumbencia para realizar la tarea encomendada."]
[]
["   La liquidación por tabla desarrollada por la tarea de Constructor y/o "]
["Ejecutor es equivalente al 50 % de la Dirección de dicha obra."]

{"sheet":"Importe","index":9,"n_rows":53,"n_cols":26,"rows_kept":53,"cut":false,"hidden":true,"merged":[[16,0,16,1],[16,4,16,5],[16,9,16,11],[16,13,16,14]]}
[]
[]
[null,null,null,"NUMERO",{"$f":"Datos!H129","v":0},{"$f":"TRIM(B15)","v":"CERO CON 00/100"},null,null,null,null,null,null,null,null,null,null,null,"NUMERO",{"$f":"Datos!K153","v":0},{"$f":"TRIM(P15)","v":"CERO CON 00/100"}]
[null,null,null,"PARTE ENTERA",{"$f":"INT(E3)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"PARTE ENTERA",{"$f":"INT(S3)","v":0}]
[null,null,null,"DECIMAL",{"$f":"IF((E3-E4)=0,\"00\",ROUND((E3-E4)*100,2))","v":"00"},null,null,null,null,null,null,null,null,null,null,null,null,"DECIMAL",{"$f":"IF((S3-S4)=0,\"00\",ROUND((S3-S4)*100,2))","v":"00"}]
[null,null,null,"MONEDA",null,null,null,null,null,null,null,null,null,null,null,null,null,"MONEDA"]
[]
["MILLONES",{"$f":"INT(E3/1000000)","v":0},null,null,"MILES",{"$f":"INT(MOD(E4/1000,1000))","v":0},null,null,"CENTENAS",{"$f":"MOD(E4,1000)","v":0},null,null,null,null,"MILLONES",{"$f":"INT(S3/1000000)","v":0},null,null,"MILES",{"$f":"INT(MOD(S4/1000,1000))","v":0},null,null,"CENTENAS",{"$f":"MOD(S4,1000)","v":0}]
[]
["CENTENAS",{"$f":"B8","v":0},{"$f":"VLOOKUP(B10,$A$18:$B$28,2,1)","v":" "},null,"CENTENAS",{"$f":"F8","v":0},{"$f":"VLOOKUP(F10,$A$18:$B$28,2,1)","v":" "},null,"CENTENAS",{"$f":"J8","v":0},{"$f":"VLOOKUP(J10,$A$18:$B$28,2,1)","v":" "},null,null,null,"CENTENAS",{"$f":"P8","v":0},{"$f":"VLOOKUP(P10,$A$18:$B$28,2,1)","v":" "},null,"CENTENAS",{"$f":"T8","v":0},{"$f":"VLOOKUP(T10,$A$18:$B$28,2,1)","v":" "},null,"CENTENAS",{"$f":"X8","v":0},{"$f":"VLOOKUP(X10,$A$18:$B$28,2,1)","v":" "}]
["DECENAS ",{"$f":"MOD(B8,100)","v":0},{"$f":"VLOOKUP(B11,$E$18:$G$34,2,1)","v":" "},{"$f":"IF(AND(B11>29,B12<>0),\" Y \",\"\")","v":""},"DECENAS",{"$f":"MOD(F8,100)","v":0},{"$f":"VLOOKUP(F11,$E$18:$F$34,2,1)","v":" "},{"$f":"IF(AND(F11>29,F12<>0),\" Y \",\"\")","v":""},"DECENAS",{"$f":"MOD(J8,100)","v":0},{"$f":"VLOOKUP(J11,$E$18:$F$34,2,1)","v":" "},{"$f":"IF(AND(J11>29,J12<>0),\" Y \",\"\")","v":""},null,null,"DECENAS ",{"$f":"MOD(P8,100)","v":0},{"$f":"VLOOKUP(P11,$E$18:$G$34,2,1)","v":" "},{"$f":"IF(AND(P11>29,P12<>0),\" Y \",\"\")","v":""},"DECENAS",{"$f":"MOD(T8,100)","v":0},{"$f":"VLOOKUP(T11,$E$18:$F$34,2,1)","v":" "},{"$f":"IF(AND(T11>29,T12<>0),\" Y \",\"\")","v":""},"DECENAS",{"$f":"MOD(X8,100)","v":0},{"$f":"VLOOKUP(X11,$E$18:$F$34,2,1)","v":" "},{"$f":"IF(AND(X11>29,X12<>0),\" Y \",\"\")","v":""}]
["UNIDADES",{"$f":"MOD(B11,10)","v":0},{"$f":"IF((B11<10)+(B11>15),VLOOKUP(B12,$J$18:$L$27,3,0),\"\")","v":" "},null,"UNIDADES",{"$f":"MOD(F11,10)","v":0},{"$f":"IF(((F11<10)+(F11>15))*(F8<>1),VLOOKUP(F12,$J$18:$L$27,3,0),\"\")","v":" "},null,"UNIDADES",{"$f":"MOD(J11,10)","v":0},{"$f":"IF((J11<10)+(J11>15),VLOOKUP(J12,$J$18:$K$27,2,0),\"\")","v":" "},null,null,null,"UNIDADES",{"$f":"MOD(P11,10)","v":0},{"$f":"IF((P11<10)+(P11>15),VLOOKUP(P12,$J$18:$L$27,3,0),\"\")","v":" "},null,"UNIDADES",{"$f":"MOD(T11,10)","v":0},{"$f":"IF(((T11<10)+(T11>15))*(T8<>1),VLOOKUP(T12,$J$18:$L$27,3,0),\"\")","v":" "},null,"UNIDADES",{"$f":"MOD(X11,10)","v":0},{"$f":"IF((X11<10)+(X11>15),VLOOKUP(X12,$J$18:$K$27,2,0),\"\")","v":" "}]
["CANTIDAD",{"$f":"VLOOKUP(B8,$N$18:$O$20,2,1)","v":" "},null,null,"CANTIDAD",{"$f":"IF(F8=0,\"\",\"MIL\")","v":""},null,null,null,null,null,null,null,null,"CANTIDAD",{"$f":"VLOOKUP(P8,$N$18:$O$20,2,1)","v":" "},null,null,"CANTIDAD",{"$f":"IF(T8=0,\"\",\"MIL\")","v":""}]
[]
["UNION LETRAS",{"$f":"IF(E4=0,\"CERO\",C10&\" \"&C11&D11&C12&\" \"&B13&\" \"&G10&\" \"&G11&H11&G12&\" \"&F13&\" \"&K10&\" \"&K11&L11&K12)&\" CON \"&E5&\"/100 \"&E6","v":"CERO CON 00/100 "},null,null,null,null,null,null,null,null,null,null,null,null,"UNION LETRAS",{"$f":"IF(S4=0,\"CERO\",Q10&\" \"&Q11&R11&Q12&\" \"&P13&\" \"&U10&\" \"&U11&V11&U12&\" \"&T13&\" \"&Y10&\" \"&Y11&Z11&Y12)&\" CON \"&S5&\"/100 \"&S6","v":"CERO CON 00/100 "}]
[]
["TABLA1",null,null,null,"TABLA 2",null,null,null,null,"TABLA 3",null,null,null,"TABLA 4"]
[0," ",null,null,0," ",null,null,null,0," "," ",null,0," "]
[100,"CIEN",null,null,10,"DIEZ",null,null,null,1,"UNO","UN",null,1,"MILLON"]
[101,"CIENTO",null,null,11,"ONCE",null,null,null,2,"DOS","DOS",null,2,"MILLONES"]
[200,"DOSCIENTOS",null,null,12,"DOCE",null,null,null,3,"TRES","TRES"]
[300,"TRESCIENTOS",null,null,13,"TRECE",null,null,null,4,"CUATRO","CUATRO"]
[400,"CUATROCIENTOS",null,null,14,"CATORCE",null,null,null,5,"CINCO","CINCO",null,null,null,null,null,"NUMERO",{"$f":"Datos!H134","v":0},{"$f":"TRIM(P35)","v":"CERO CON 00/100"}]
[500,"QUINIENTOS",null,null,15,"QUINCE",null,null,null,6,"SEIS","SEIS",null,null,null,null,null,"PARTE ENTERA",{"$f":"INT(S23)","v":0}]
[600,"SEISCIENTOS",null,null,16,"DIECI",null,null,null,7,"SIETE","SIETE",null,null,null,null,null,"DECIMAL",{"$f":"IF((S23-S24)=0,\"00\",ROUND((S23-S24)*100,2))","v":"00"}]
[700,"SETECIENTOS",null,null,20,"VEINTE",null,null,null,8,"OCHO","OCHO",null,null,null,null,null,"MONEDA"]
[800,"OCHOCIENTOS",null,null,21,"VEINTI",null,null,null,9,"NUEVE","NUEVE"]
[900,"NOVECIENTOS",null,null,30,"TREINTA",null,null,null,null,null,null,null,null,"MILLONES",{"$f":"INT(S23/1000000)","v":0},null,null,"MILES",{"$f":"INT(MOD(S24/1000,1000))","v":0},null,null,"CENTENAS",{"$f":"MOD(S24,1000)","v":0}]
[null,null,null,null,40,"CUARENTA"]
[null,null,null,null,50,"CINCUENTA",null,null,null,null,null,null,null,null,"CENTENAS",{"$f":"P28","v":0},{"$f":"VLOOKUP(P30,$A$18:$B$28,2,1)","v":" "},null,"CENTENAS",{"$f":"T28","v":0},{"$f":"VLOOKUP(T30,$A$18:$B$28,2,1)","v":" "},null,"CENTENAS",{"$f":"X28","v":0},{"$f":"VLOOKUP(X30,$A$18:$B$28,2,1)","v":" "}]
[null,null,null,null,60,"SESENTA",null,null,null,null,null,null,null,null,"DECENAS ",{"$f":"MOD(P28,100)","v":0},{"$f":"VLOOKUP(P31,$E$18:$G$34,2,1)","v":" "},{"$f":"IF(AND(P31>29,P32<>0),\" Y \",\"\")","v":""},"DECENAS",{"$f":"MOD(T28,100)","v":0},{"$f":"VLOOKUP(T31,$E$18:$F$34,2,1)","v":" "},{"$f":"IF(AND(T31>29,T32<>0),\" Y \",\"\")","v":""},"DECENAS",{"$f":"MOD(X28,100)","v":0},{"$f":"VLOOKUP(X31,$E$18:$F$34,2,1)","v":" "},{"$f":"IF(AND(X31>29,X32<>0),\" Y \",\"\")","v":""}]
[null,null,null,null,70,"SETENTA",null,null,null,null,null,null,null,null,"UNIDADES",{"$f":"MOD(P31,10)","v":0},{"$f":"IF((P31<10)+(P31>15),VLOOKUP(P32,$J$18:$L$27,3,0),\"\")","v":" "},null,"UNIDADES",{"$f":"MOD(T31,10)","v":0},{"$f":"IF(((T31<10)+(T31>15))*(T28<>1),VLOOKUP(T32,$J$18:$L$27,3,0),\"\")","v":" "},null,"UNIDADES",{"$f":"MOD(X31,10)","v":0},{"$f":"IF((X31<10)+(X31>15),VLOOKUP(X32,$J$18:$K$27,2,0),\"\")","v":" "}]
[null,null,null,null,80,"OCHENTA",null,null,null,null,null,null,null,null,"CANTIDAD",{"$f":"VLOOKUP(P28,$N$18:$O$20,2,1)","v":" "},null,null,"CANTIDAD",{"$f":"IF(T28=0,\"\",\"MIL\")","v":""}]
[null,null,null,null,90,"NOVENTA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UNION LETRAS",{"$f":"IF(S24=0,\"CERO\",Q30&\" \"&Q31&R31&Q32&\" \"&P33&\" \"&U30&\" \"&U31&V31&U32&\" \"&T33&\" \"&Y30&\" \"&Y31&Z31&Y32)&\" CON \"&S25&\"/100 \"&S26","v":"CERO CON 00/100 "}]
[]
[]
[]
[]
[]
[null,null,null,"NUMERO",{"$f":"'Cert. Constructor'!J34","v":"ASDASD"},{"$f":"TRIM(B53)","v":{"$error":"#VALUE!"}}]
[null,null,null,"PARTE ENTERA",{"$f":"INT(E41)","v":{"$error":"#VALUE!"}}]
[null,null,null,"DECIMAL",{"$f":"IF((E41-E42)=0,\"00\",ROUND((E41-E42)*100,2))","v":{"$error":"#VALUE!"}}]
[null,null,null,"MONEDA"]
[]
["MILLONES",{"$f":"INT(E41/1000000)","v":{"$error":"#VALUE!"}},null,null,"MILES",{"$f":"INT(MOD(E42/1000,1000))","v":{"$error":"#VALUE!"}},null,null,"CENTENAS",{"$f":"MOD(E42,1000)","v":{"$error":"#VALUE!"}}]
[]
["CENTENAS",{"$f":"B46","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(B48,$A$18:$B$28,2,1)","v":{"$error":"#VALUE!"}},null,"CENTENAS",{"$f":"F46","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(F48,$A$18:$B$28,2,1)","v":{"$error":"#VALUE!"}},null,"CENTENAS",{"$f":"J46","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(J48,$A$18:$B$28,2,1)","v":{"$error":"#VALUE!"}}]
["DECENAS ",{"$f":"MOD(B46,100)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(B49,$E$18:$G$34,2,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(B49>29,B50<>0),\" Y \",\"\")","v":{"$error":"#VALUE!"}},"DECENAS",{"$f":"MOD(F46,100)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(F49,$E$18:$F$34,2,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(F49>29,F50<>0),\" Y \",\"\")","v":{"$error":"#VALUE!"}},"DECENAS",{"$f":"MOD(J46,100)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(J49,$E$18:$F$34,2,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(J49>29,J50<>0),\" Y \",\"\")","v":{"$error":"#VALUE!"}}]
["UNIDADES",{"$f":"MOD(B49,10)","v":{"$error":"#VALUE!"}},{"$f":"IF((B49<10)+(B49>15),VLOOKUP(B50,$J$18:$L$27,3,0),\"\")","v":{"$error":"#VALUE!"}},null,"UNIDADES",{"$f":"MOD(F49,10)","v":{"$error":"#VALUE!"}},{"$f":"IF(((F49<10)+(F49>15))*(F46<>1),VLOOKUP(F50,$J$18:$L$27,3,0),\"\")","v":{"$error":"#VALUE!"}},null,"UNIDADES",{"$f":"MOD(J49,10)","v":{"$error":"#VALUE!"}},{"$f":"IF((J49<10)+(J49>15),VLOOKUP(J50,$J$18:$K$27,2,0),\"\")","v":{"$error":"#VALUE!"}}]
["CANTIDAD",{"$f":"VLOOKUP(B46,$N$18:$O$20,2,1)","v":{"$error":"#VALUE!"}},null,null,"CANTIDAD",{"$f":"IF(F46=0,\"\",\"MIL\")","v":{"$error":"#VALUE!"}}]
[]
["UNION LETRAS",{"$f":"IF(E42=0,\"CERO\",C48&\" \"&C49&D49&C50&\" \"&B51&\" \"&G48&\" \"&G49&H49&G50&\" \"&F51&\" \"&K48&\" \"&K49&L49&K50)&\" CON \"&E43&\"/100 \"&E44","v":{"$error":"#VALUE!"}}]

{"sheet":"Cálculos","index":10,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
["            En la ciudad de",{"$f":"Datos!K37","v":0},", el día",{"$f":"Datos!K38","v":"00:00:00"},{"$f":"Datos!K39","v":0},"de",{"$f":"Datos!K40","v":0},"del año",{"$f":"Datos!K41","v":0},{"$f":"Datos!K42","v":0}]
["entre el señor",{"$f":"Datos!K29","v":0},", DNI Nº",{"$f":"Datos!K30","v":0},", con domicilio real en",{"$f":"Datos!K32","v":0},{"$f":"Datos!K33","v":0}]
[null,"de la localidad de",{"$f":"Datos!K34","v":0},", Partido de ",{"$f":"Datos!K35","v":0},", llamado en adelante el COMITENTE, y",{"$f":"Datos!K18","v":0},", DNI Nº",{"$f":"Datos!K19","v":0},", con domicilio real en"]
[{"$f":"Datos!K20","v":0},{"$f":"Datos!K21","v":0},"de la localidad de",{"$f":"Datos!K22","v":0},", Partido de",{"$f":"Datos!K23","v":0},", Con Título Profesional de",{"$f":"Datos!K24","v":0},", Matrícula del Colegio de Técnicos de la Provincia de Buenos Aires Nº",{"$f":"Datos!K26","v":0}]
[", llamado en adelante el PROFESIONAL, se conviene en celebrar el siguiente contrato de Locación de Servicios.  "]
["               Artículo 1º)   El COMITENTE encomienda al PROFESIONAL lo siguiente:",{"$f":"Datos!K55","v":0},", para la obra ubicada en",{"$f":"Datos!K45","v":0},"Nº",{"$f":"Datos!K46","v":0},", de la localidad de",{"$f":"Datos!K47","v":0},"Partido de",{"$f":"Datos!K48","v":0},"; cuya designación catastral es"]
["Circunscripción:",{"$f":"Datos!K49","v":0},"Sección:",{"$f":"Datos!K50","v":0},"Manzana:",{"$f":"Datos!K51","v":0},"Parcela:",{"$f":"Datos!K52","v":0},"U.F.:",{"$f":"Datos!K53","v":0},null,null,null,null,null,null,"HOJA  UTILIZADA POR EL PROGRAMA PARA"]
[". DESTINO:",{"$f":"Datos!K44","v":0}]
["               Artículo 2º)   Por las tareas detalladas en el artículo anterior el COMITENTE abonará al PROFESIONAL, los honorarios de común acuerdo convenidos, que ascienden a la suma de pesos: $",{"$f":"Datos!F130","v":"CERO CON 00/100"},{"$f":"Datos!H129","v":0},". Conforme a las normas legales, vigentes en la jurisdicción de la Provincia de Buenos Aires y el Código Civil.",null,null,null,null,null,null,null,null,null,null,null," CÁLCULOS INTERNOS SE RECOMIENDA NO INGRESAR"]
["               Artículo 3º)  El Sr. ",{"$f":"Datos!K29","v":0},", en su carácter de COMITENTE, toma a su exclusivo cargo, la ejecución de la obra como EMPRESARIO.","SISTEMA de EJECUCIÓN de OBRA POR:",{"$f":"Anexa!D12","v":"OTRO PROFESIONAL ASUME LA CONSTRUCCION"},{"$f":"Anexa!G12","v":"."}]
["               Artículo 4º)  El COMITENTE abonará al PROFESIONAL los honorarios pactados en la siguiente forma: $",null,{"$f":"Datos!H134","v":0},{"$f":"Datos!F136","v":"CERO CON 00/100"},"en este acto, en concepto de:",{"$f":"Datos!H137","v":0},"y el saldo, de $",{"$f":"Datos!H138","v":0},"en concepto de",{"$f":"Datos!$H$139","v":0}]
["               Artículo 5º)  Se establece el plazo de vigencia del presente contrato en:",{"$f":"Datos!K57","v":0},"meses",{"$f":"Datos!K58","v":0},". Vencido el cual, deberán ratificarse las condiciones pactadas. De no hacerse lo expresado, dentro de los quince (15) días posteriores al vencimiento, el PROFESIONAL queda liberado de sus obligaciones, sin necesidad de comunicación alguna al COMITENTE."]
["               Artículo 6º)  Con cada percepción de honorarios, el PROFESIONAL, efectuará los aportes previsionales que obliga el Art. 26 inc. b) de la Ley 12490."]
["               Artículo 7º)   La falta de pago de cualquiera de las sumas establecidas, producirá la Mora de Pleno Derecho, pudiendo el Profesional optar por cobrar un interés punitorio sobre el atraso, o dar por terminados los plazos establecidos y cobrar el saldo total de lo que se le adeudare, o rescindir el presente contrato quedando los sumas abonadas en concepto de indemnización."]
["               Artículo 8º)   En virtud de lo establecido en el artículo 3º del presente, el COMITENTE asume expresamente bajo su costa y responsabilidad, los incisos que a continuación se indican: "]
["a) La contratación de todo el personal, el pago de sus remuneraciones, aportes legales (obra social, previsional, sindical, etc.) indemnizaciones y cualquier otro crédito laboral,  como así también, toda responsabilidad laboral, civil y/o penal que pudiera derivar de dicha relación, conforme lo determinan las normativas vigentes;"]
["b) La contratación de los seguros de riesgo por accidente de trabajo, de vida y cualquier otro que exigen las normas  que rigen la actividad."]
["c) El cumplimiento de las normas sobre Seguridad e Higiene en el Trabajo y Medicina Laboral."]
["d) La compra de la totalidad de materiales que demande la construcción de la obra."]
["               Artículo 9º)  Los gastos extraordinarios serán a exclusivo costo y cargo del Comitente, como así también el pago de los Derechos de Construcción o sellados ante el Municipio respectivo, por las obras que se ejecutarán.  "]
["               Artículo 10º)  Para todos los efectos legales emergentes del presente contrato las partes constituyen domicilio legal en los arriba indicados y se someten a la jurisdicción de los Tribunales Ordinarios de ",{"$f":"Datos!K60","v":0},"renunciando a cualquier otro fuero o jurisdicción.-"]
["               Artículo 11º)  De conformidad y para que conste, se firman cinco (5) ejemplares del mismo tenor y a un solo efecto con el carácter de: ",{"$f":"Datos!K59","v":0}]
["Firma del Comitente              ","Firma del Profesional"]
[{"$f":"Datos!K29","v":0},{"$f":"Datos!K18","v":0}]
["CUIL",{"$f":"Datos!K31","v":0},"CUIT",{"$f":"Datos!K25","v":0}]

{"sheet":"Inf.Tec-","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"INF.TEC-POR M2","index":12,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,2,23,5],[1,2,1,6],[2,2,2,3],[5,3,6,3],[14,2,14,3],[14,4,14,5],[8,2,9,2],[11,2,11,6],[12,2,12,3],[12,4,12,5],[13,2,13,3],[13,4,13,5],[10,2,10,4],[10,5,10,6]]}
[]
[null,null,"       COLEGIO DE TECNICOS DE LA PROVINCIA DE BUENOS AIRES"]
[null,null,"       LEY 10.411"]
[]
[]
[null,null,null,"Coeficiente Actualización",1.3]
[]
[]
[null,null,"SUPERFICIE","CUBIERTA",{"$f":"SUM(Datos!D81:G82:'Datos'!D78)","v":0},{"$f":"SUM(Datos!L81:O82:'Datos'!L78)","v":0},{"$f":"SUM(Datos!R81:V82:'Datos'!R78)","v":0}]
[null,null,null,"SEMICUBIERTA",{"$f":"SUM(Datos!D83:G84)","v":0},{"$f":"SUM(Datos!L83:O84)","v":0},{"$f":"SUM(Datos!R83:V84)","v":0}]
[null,null,"Monto de Obra = ",null,null,{"$f":"G9+G10","v":0}]
[null,null,"INFORME TECNICO - Titulo II - Articulo 5"]
[null,null,null,null,"Inciso A =",null,1300]
[null,null,null,null,"Inciso B =",null,7150]
[null,null,null,null,"Inciso C = Valor en Juego",null,{"$f":"G23","v":0}]
[null,null,"Parcial","Acumulado","%","Parcial","Acumulado"]
[null,null,{"$f":"100000*E6","v":130000},{"$f":"C17","v":130000},2,{"$f":"IF(AND(F11<=D17),(F11)*E17%,IF(F11>D17,(D17*E17%),0))","v":0},{"$f":"F17","v":0}]
[null,null,{"$f":"400000*E6","v":520000},{"$f":"500000*E6","v":650000},1.5,{"$f":"IF(AND(F11<=D18),(F11-D17)*E18%,IF(F11>D18,(C18*E18%),0))","v":-1950},{"$f":"IF(F18>0,(F18+G17),0)","v":0}]
[null,null,{"$f":"500000*E6","v":650000},{"$f":"1000000*E6","v":1300000},1,{"$f":"IF(AND(F11<=D19),(F11-D18)*E19%,IF(F11>D19,(C19*E19%)))","v":-6500},{"$f":"IF(F19>0,(F19+G18),0)","v":0}]
[null,null,{"$f":"9000000*E6","v":11700000},{"$f":"10000000*E6","v":13000000},0.8,{"$f":"IF(AND(F11<=D20),(F11-D19)*E20%,IF(F11>D20,(C20*E20%)))","v":-10400},{"$f":"IF(F20>0,(F20+G19),0)","v":0}]
[null,null,{"$f":"(100000000-30000000)*H1","v":0},{"$f":"100000000*H1","v":0},0.5,{"$f":"IF(AND(F11<=D21),(F11-D20)*E21%,IF(F11>D21,(C21*E21%),0))","v":-65000},{"$f":"IF(F21>0,(F21+G20),0)","v":0}]
[null,null,"Excedente",{"$f":"F11-D21","v":0},0,{"$f":"IF(F11>D21,D22*E22%,0)","v":0}]
[null,null,null,null,null,"Honorario =",{"$f":"MAX(G17:G22)+F22","v":0}]
[null,null,"Honorario Minimo por Informe Tecnico =",null,null,null,{"$f":"G13+G14+G15","v":8450}]

{"sheet":"R-115U","index":13,"n_rows":48,"n_cols":13,"rows_kept":48,"cut":false,"hidden":false,"merged":[[41,1,41,2],[41,3,41,4],[47,4,47,14],[33,4,33,11],[34,12,34,13],[35,4,35,13],[36,4,36,13],[40,1,40,2],[40,3,40,10],[40,11,40,12],[32,4,32,5],[32,8,32,11],[19,8,19,10],[20,4,20,5],[20,8,20,11],[21,4,21,11],[24,4,24,13],[28,4,28,13],[29,4,29,5],[29,10,29,11],[31,8,31,10],[22,12,22,13],[23,4,23,13],[2,12,5,14],[11,5,11,13],[13,4,13,13],[16,4,16,13],[17,4,17,5],[17,10,17,11]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"R-115U"]
[]
[]
[]
[]
[]
[]
[null,null,"Datos del Contribuyente"]
[]
[null,null,"Apellido / Razon Social"]
[]
[null,null,"CUIT / CUIL / CDI",null,{"$f":"Datos!K31","v":0}]
[]
[null,null,"Domicilio Fiscal"]
[null,null,null,"Calle",{"$f":"Datos!K32","v":0}]
[null,null,null,"Número",{"$f":"Datos!K33","v":0},null,null,"Ruta",null,"Km"]
[null,null,null,"Torre",null,"Piso","-","Dpto","-","Manzana"]
[null,null,null,null,null,null,"Provincia",null,"BUENOS AIRES"]
[null,null,null,"C.Postal",8000,null,null,"Partido",{"$f":"Datos!K35","v":0}]
[null,null,null,"Localidad",{"$f":"Datos!K34","v":0}]
[null,null,null,"Telefono",null,"-",null,null,null,"Fax",null,"-"]
[null,null,null,"E-mail"]
[null,null,null,"Observaciones"]
[]
[]
[null,null,"Ubicación de la Producción, Bien o Servicio"]
[null,null,null,"Calle",{"$f":"Datos!K45","v":0}]
[null,null,null,"Número",{"$f":"Datos!K46","v":0},null,null,"Ruta",null,"Km"]
[null,null,null,null,null,"Piso","-","Dpto","-","Manzana"]
[null,null,null,null,null,null,"Provincia",null,"BUENOS AIRES"]
[null,null,null,"C.Postal",8000,null,null,"Partido",{"$f":"Datos!K48","v":0}]
[null,null,null,"Localidad",{"$f":"Datos!K47","v":0}]
[null,null,null,"Telefono",null,"-",null,null,null,"Fax",null,"-"]
[null,null,null,"E-mail"]
[null,null,null,"Observaciones"]
[]
[]
[]
[null,"   El que suscribe",null,{"$f":"Datos!K29","v":0},null,null,null,null,null,null,null,",         con "]
[null,"   CUIT/CUIL:",null,{"$f":"Datos!K31","v":0},null,"en su carácter de  PROPIETARIO , declara que los "]
[null,"   datos  consignados en este  formulario son correctos y completos , y que esta declara-"]
[null,"   ción se ha  confeccionado sin omitir ni falsear dato alguno que daba contener , siendo "]
[null,"   fiel expresión de la verdad."]
[]
[]
[null,null,null,null,"                                                                                 El presente formulario se emite en 2 ejemplares - Normativa: DN B 05-07"]