{"text_format":"1","workbook":"xlsx","n_sheets":90,"sheets":["1","2","3","4","2.1","2.1.1","2.1.1B","2.2C","2.2CBIS","2.3C","2.2B","2.3.1","2.3.1A","2.3.2","2.3.3","2.3.3B","2.4.1B","2.4.1C","2.4.1e","2.5.1C","2.5.2C","2.5.2D","3.1.1A","3.1.1B","3.1.1C","3.1.1D","3.1.1E","3.1.2","3.1.3","3.1.4","3.1.5","3.1.6","3.1.7","3.1.8","3.1.8B","3.1.9","3.1.9B","3.1.9C","3.1.9D","3.1.10","3.1.10B","3.2.1","3.2.2","3.2.3","3.3.2B","3.3.1","3.3.2","3.3.3","4.1.1","4.1.2","4.1.3","4.1.4","4.1.5","4.2.1","4.2.1B","4.2.2","4.2.2B","4.2.3","4.2.3B","4.2.4","4.2.4B","4.2.5","4.2.5B","4.3.0","4.4.1","4.4.2","4.5.1C","4.5.2","4.5.3","4.5.6","4.5.5","4.5.5.b","4.5.5B","4.5.7","4.5.7b","4.6.0","4.6.2","4.6.2B","4.6.3","4.6.4","4.6.5","4.6.6","4.6.7","4.6.8","TABLAITE","TABLAT","TABLAU3","TABLAU4","USOS","JCALCULO"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":262,"comments":73,"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":"1","index":0,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[[16,0,20,0],[6,1,20,1],[11,2,11,12],[18,3,18,12],[12,3,12,12],[17,3,17,12],[16,3,16,12],[13,3,13,12],[14,3,14,12],[6,2,10,3],[19,3,19,12],[20,3,20,12],[12,2,20,2],[6,4,6,12],[7,5,7,12],[8,5,8,12],[9,5,9,12],[10,5,10,12],[15,3,15,12],[5,1,5,12],[1,13,2,28],[2,1,2,12],[3,1,3,12],[4,1,4,12],[0,1,1,12]]}
[null,{"$f":"N2","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
["COAM",null,null,null,null,null,null,null,null,null,null,null,null,"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"]
[".","PREÁMBULO"]
[".","Desde enero de 2005 el Colegio calcula el precio de visado a partir de los datos aportados por el colegiado en los correspondientes impresos colegiaes"]
[null,"Este documento permite conocer con anterioridad al visado la cantidad que el Colegio facturará, mediante una hoja de cálculo que permite obtener estos valores que se puede consultar en el área de visado de la página web colegial."]
[null,"1. NORMAS GENERALES"]
[null,null,null,null,"Los trabajos se clasifican en:"]
[null,null,null,null,null,"1 Edificación."]
[null,null,null,null,null,"2 Urbanismo."]
[null,null,null,null,null,"3 Otros trabajos y documentos de arquitectura"]
[]
[null,null,"1.1 DEFINICIONES"]
[null,null,null,"1.1.1 PRECIO DEL VISADO"]
[null,null,null,"El precio del visado indica la cantidad que han de abonar los arquitectos colegiados o habilitados por el visado de sus trabajos profesionales."]
[null,null,null,"El arquitecto podrá solicitar al Colegio que el importe del Precio del Visado de su trabajo profesional sea facturado a él mismo o a su cliente"]
[null,null,null,"1.1.2 MÓDULO *"]
[null,null,null,"El precio se estima en función de un Módulo M, cuyo valor será fijado anualmente por la Junta de Gobierno y hecho público en diciembre para su aplicación durante el siguiente ejercicio. Su valor puede ser consultado en el área de visado de la página web colegial. Su valor hasta la finalización del año natural 2026 es de 538,79 €.",null,null,null,null,null,null,null,null,null,538.79]
[null,null,null,"1.1.3 MÓDULO POR HORA DE TRABAJO",null,null,null,null,null,null,null,null,null,0.21]
[null,null,null,"Se establece que el Módulo M equivale a diez horas-tipo de trabajo. El cálculo de la cuota de visado para los trabajos valorados por tiempo será igual a M/500 por hora de trabajo.",null,null,null,null,null,null,null,null,null,{"$f":"N17/500","v":1.07758}]
[null,null,null,"1.1.4 CÓDIGOS"]
[null,null,null,"Se han creado unos códigos para los tipos de trabajo y los tipos de uso que facilitan la introducción de datos. Los códigos de tipos de trabajo están en la Tabla T y los de uso en la tabla E1. "]

{"sheet":"2","index":1,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":true,"merged":[[23,1,23,12],[9,1,9,12],[0,1,1,12],[1,13,2,28],[2,1,2,12],[3,1,3,12],[13,1,13,12],[17,1,17,12]]}
[null,{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
["COAM",null,null,null,null,null,null,null,null,null,null,null,null,"CUOTAS DE VISADO PARA LOS TRABAJOS PROFESIONALES v1.1"]
[null,"2. EDIFICACIÓN"]
[null,"2.1 OBRAS DE NUEVA PLANTA"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2.1.1B'!$G$13","v":0}]
[]
[null,"2.2 OBRAS DE CONSERVACIÓN, REPARACIÓN, REFORMA, REESTRUCTURACIÓN, AMPLIACIÓN, ACONDICIONAMIENTO, REHABILITACIÓN, CONSOLIDACIÓN Y/O RESTAURACIÓN"]
[]
[]
[]
[null,"2.3 EXPEDIENTES DE LEGALIZACIÓN"]
[]
[]
[]
[null,"2.4 PROYECTO Y DIRECCIÓN DE DERRIBO DE EDIFICACIONES"]
[]
[]
[]
[]
[]
[null,"2.5 OTROS TRABAJOS DE ARQUITECTURA"]
[]
[]
[]
[]
[]
[]
[null,"*"]

{"sheet":"3","index":2,"n_rows":22,"n_cols":18,"rows_kept":22,"cut":false,"hidden":true,"merged":[[15,1,15,7],[0,1,1,16],[1,17,2,32],[3,10,3,16],[2,1,2,16],[3,1,3,7],[9,10,9,16]]}
[null,{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
["COAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CUOTAS DE VISADO PARA LOS TRABAJOS PROFESIONALES v1"]
[null,"3. URBANISMO"]
[null,"3.1 TRABAJOS DE PLANEAMIENTO, DESARROLLO Y DETALLE",null,null,null,null,null,null,null,null,"3.2 CUOTA PARA TRABAJOS DE GESTIÓN DEL PLANEAMIENTO"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"3.3 CUOTA PARA TRABAJOS DE URBANIZACIÓN"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"'3.1.7'!G19","v":0}]

{"sheet":"4","index":3,"n_rows":20,"n_cols":18,"rows_kept":20,"cut":false,"hidden":true,"merged":[[19,1,19,7],[3,10,3,16],[0,1,1,16],[1,17,2,32],[7,10,7,16],[2,1,2,16],[7,1,7,7],[3,1,3,7],[15,10,15,16]]}
[null,{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
["COAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CUOTAS DE VISADO PARA LOS TRABAJOS PROFESIONALES v1"]
[null,"4. OTROS DOCUMENTOS Y TRABAJOS DE ARQUITECTURA"]
[null,"4.1 SEGURIDAD Y SALUD",null,null,null,null,null,null,null,null,"4.4 RECONOCIMIENTOS, ANDAMIOS, EXÁMENES Y CONSULTAS"]
[]
[]
[]
[null,"4.2 DESLINDES, REPLANTEOS Y MEDICIONES",null,null,null,null,null,null,null,null,"4.5 INFORMES, PERITAJES, DICTÁMENES, CERTIFICADOS Y ARBITRAJES"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"4.6 OTROS TRABAJOS DE ARQUITECTURA Y DEL ARQUITECTO"]
[]
[]
[]
[null,"4.3 TASACIONES"]

{"sheet":"2.1","index":4,"n_rows":44,"n_cols":23,"rows_kept":44,"cut":false,"hidden":true,"merged":[[34,7,35,8],[28,14,28,16],[28,5,28,8],[37,7,37,8],[39,7,40,12],[32,4,32,8],[30,5,30,8],[0,2,0,21],[1,2,1,21],[4,2,4,10],[6,5,7,5],[28,10,28,11],[6,14,7,14],[6,18,7,18]]}
[{"$f":"'1'!$N$17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IVA","v":1.21}]
[false,null,"2.1 DETERMINACIÓN DEL PRECIO DEL VISADO PARA OBRAS DE NUEVA PLANTA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,"Se calcula mediante la siguiente fórmula:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,205]
[false,null,"PV = Módulo · C · [Σ.Si · Qv] · F / 6000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B38","v":{"$error":"#VALUE!"}}]
[null,null,"Plantas",null,null,"Num. Plantas",null,null,null,null,null,null,null,null,"Codigo del Uso",null,"Sup. Planta",null,"Total m2            Uso",null,"Qv",null,{"$f":"IF(W6*W5<W3,W3,IF(W6*W5>W4,W4,W6*W5))","v":{"$error":"#VALUE!"}}]
[null,null,"de","A"]
[null,1,null,null,null,null,null,null,{"$f":"INDEX(USOS!$C$1:$C$65,$B9)","v":0},null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B9)","v":0},null,null,"m2",{"$f":"Q9*F9","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B9)","v":0},null,{"$f":"IF(U9<>\"-\",U9*S9,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B11)","v":0},null,null,"m2",{"$f":"Q11*F11","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B11)","v":0},null,{"$f":"IF(U11<>\"-\",U11*S11,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B13)","v":0},null,null,"m2",{"$f":"Q13*F13","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B13)","v":0},null,{"$f":"IF(U13<>\"-\",U13*S13,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B15)","v":0},null,null,"m2",{"$f":"Q15*F15","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B15)","v":0},null,{"$f":"IF(U15<>\"-\",U15*S15,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B17)","v":0},null,null,"m2",{"$f":"Q17*F17","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B17)","v":0},null,{"$f":"IF(U17<>\"-\",U17*S17,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B19)","v":0},null,null,"m2",{"$f":"Q19*F19","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B19)","v":0},null,{"$f":"IF(U19<>\"-\",U19*S19,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B21)","v":0},null,null,"m2",{"$f":"Q21*F21","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B21)","v":0},null,{"$f":"IF(U21<>\"-\",U21*S21,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B23)","v":0},null,null,"m2",{"$f":"Q23*F23","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B23)","v":0},null,{"$f":"IF(U23<>\"-\",U23*S23,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B25)","v":0},null,null,"m2",{"$f":"Q25*F25","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B25)","v":0},null,{"$f":"IF(U25<>\"-\",U25*S25,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B27)","v":0},null,null,"m2",{"$f":"Q27*F27","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B27)","v":0},null,{"$f":"IF(U27<>\"-\",U27*S27,0)","v":0}]
[]
[null,null,null,null,null,"Presupuesto de ejecución material",null,null,null,"=",null,null,null,{"$f":"IF(S29=\"-\",TRUE,FALSE)","v":true},"Superficie acumulativa",null,null,"=","-","m2",{"$f":"IF(S29=\"-\",\"\",K29/(MODULO*S29))","v":""},null,{"$f":"IF(S29<>\"-\",U29*S29,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,null,null,null,{"$f":"IF(K29=0,0,CONCATENATE(ROUND(K29/S31,2),\" €/m2   \",ROUND((K29/S31)*166.386,0),\" pts/m2\"))","v":0},null,null,null,null,{"$f":"IF(S31<=300,11.75,IF(S31<=400,11.5,IF(S31<=600,10.8,IF(S31<=800,11.3,IF(S31<=1000,10,IF(S31<=2000,9,L31))))))","v":11.75},{"$f":"IF(S31<=3000,8.6,IF(S31<=5000,8,IF(S31<=8000,7.5,IF(S31<=12000,7.1,IF(S31<=20000,6.7,IF(S31<=35000,6.2,M31))))))","v":8.6},{"$f":"IF(S31<=80000,5.7,IF(S31<=120000,5.4,IF(S31<=200000,5.2,IF(S31<=400000,4.8,IF(S31<=700000,4.6,IF(S31<=1000000,4.45,4.45))))))","v":5.7},null,null,null,"Σ Si","=",{"$f":"SUM(S29,S27,S25,S23,S21,S19,S17,S15,S13,S11,S9)","v":0},"m2",null,null,{"$f":"SUM(W9,W11,W13,W15,W17,W19,W21,W23,W25,W27,W29)","v":0}]
[]
[null,null,null,null,"coeficiente por superficie construida ",null,null,null,null,"=",{"$f":"IF(S31<>0,M33,\"\")","v":""},{"$f":"IF(S31<>0,(2.6+10.2*((200/S31)^0.2)),0)","v":0},{"$f":"IF(L33>11.75,11.75,IF(L33<4.457,4.45,L33))","v":4.45},null,null,null,"Σ Si . Qv","=",{"$f":"W31","v":0}]
[]
[null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Coeficiente de FASE",null,null,{"$f":"'2.1.1B'!$G$13","v":0}]
[null,null,null,null,null,null,null,null,null,"="]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2.1.1B'!$G$13","v":0}]
[null,{"$f":"MODULO*K33*S33*K36/6000","v":{"$error":"#VALUE!"}},{"$f":"MODULO/40","v":13.469749999999999},{"$f":"IF(B38>W2,B38,W2)","v":{"$error":"#VALUE!"}},null,null,null,"Calculo",null,"=",{"$f":"IF(A5=TRUE,D38+W7,D38)","v":{"$error":"#VALUE!"}},null,null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(ROUND(K38*W1,2),\" € c/IVA\")","v":{"$error":"#VALUE!"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Arquitecto","Cliente"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"K38/3","v":{"$error":"#VALUE!"}},{"$f":"K38*2/3","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(ROUND(L43*W1,2),\" € c/IVA\")","v":{"$error":"#VALUE!"}},{"$f":"CONCATENATE(ROUND(M43*W1,2),\" € c/IVA\")","v":{"$error":"#VALUE!"}},{"$f":"CONCATENATE(ROUND(N43*Y1,2),\" € c/IVA\")","v":"0 € c/IVA"}]

{"sheet":"2.1.1","index":5,"n_rows":22,"n_cols":29,"rows_kept":22,"cut":false,"hidden":true,"merged":[[1,2,1,13],[9,9,10,11]]}
[null,"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[null,null,"2.1.1 COEFICIENTE POR FASES Y POR SUSTITUCIÓN DE DOCUMENTOS"]
[]
[null,null,null,null,null,null,null,null,null,"PORCENTAJES POR SUSTITUCIÓN DE DOCUMENTOS"]
[null,null,null,"AYUDA",null,null,null,null,null,"Porcentaje modificado","≤25 %",">25%",">50%",">75%"]
[null,null,false,"Estudios previos",null,null,{"$f":"IF( C6=TRUE,AB6,\"\")","v":""},null,null,"Memoria",null,null,null,null,null,null,false,false,false,null,false,{"$f":"IF(Q6=TRUE,0.1,0)","v":0},{"$f":"IF(R6=TRUE,0.8,0)","v":0},null,null,{"$f":"IF(U6=TRUE,0.1,0)","v":0},{"$f":"SUM(V6:Z6)","v":0},0.05,{"$f":"SUM(V6:AB6)","v":0.05}]
[null,null,false,"Anteproyecto",null,null,"",null,null,"Mediciones y presupuestos",null,null,null,null,null,null,false,false,false,null,false,{"$f":"IF(Q7=TRUE,0.15,0)","v":0},{"$f":"IF(R7=TRUE,0.75,0)","v":0},null,null,{"$f":"IF(U7=TRUE,0.1,0)","v":0},0,0.15,0.15]
[null,null,false,"Proyecto básico",null,null,"",null,null,"Planos",null,null,null,null,null,null,false,false,false,null,false,{"$f":"IF(Q8=TRUE,0.15,0)","v":0},{"$f":"IF(R8=TRUE,0.75,0)","v":0},null,null,{"$f":"IF(U8=TRUE,0.1,0)","v":0},0,0.1,0.1]
[null,null,false,"Proyecto de ejecución",null,null,"",null,null,"TOTAL",{"$f":"Q22","v":0},{"$f":"R22","v":0},{"$f":"S22","v":0},{"$f":"T22","v":0},null,null,false,false,false,false,false,{"$f":"IF(Q9=TRUE,0.12,0)","v":0},{"$f":"IF(R9=TRUE,0.53,0)","v":0},{"$f":"IF(S9=TRUE,0.1,0)","v":0},{"$f":"IF(T9=TRUE,0.12,0)","v":0},{"$f":"IF(U9=TRUE,0.13,0)","v":0},0,0.5,0.5]
[null,null,false,"Dirección de obra",null,null,"",null,null,"Coeficiente de aprovechamiento del documento anterior, según porcentaje modificado",null,null,null,null,null,null,null,false,false,null,false,null,{"$f":"IF(R10=TRUE,0.67,0)","v":0},null,null,{"$f":"IF(U10=TRUE,0.33*N13,0)","v":0},0,0.05,0.05]
[null,null,false,"Liquidación y recepción",null,null,"",null,null,null,null,null,{"$f":"SUM(K9:N9)","v":0},null,null,null,false,null,false,null,false,{"$f":"IF(Q11=TRUE,0.15,0)","v":0},null,null,null,{"$f":"IF(U11=TRUE,0.85,0)","v":0},0,0.15,0.15]
[]
[null,null,null,null,null,null,{"$f":"IF(M11=0,SUM(G6:G11),SUM(G6:G11)*M11)","v":0},null,null,null,null,null,null,1]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q16=TRUE,0,0)","v":0},{"$f":"IF(R16=TRUE,0.025,0)","v":0},{"$f":"IF(S16=TRUE,0.05,0)","v":0},{"$f":"IF(T16=TRUE,0.075,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q17=TRUE,0,0)","v":0},{"$f":"IF(R17=TRUE,0.025,0)","v":0},{"$f":"IF(S17=TRUE,0.05,0)","v":0},{"$f":"IF(T17=TRUE,0.075,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q18=TRUE,0,0)","v":0},{"$f":"IF(R18=TRUE,0.15,0)","v":0},{"$f":"IF(S18=TRUE,0.3,0)","v":0},{"$f":"IF(T18=TRUE,0.45,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q19:Q21)","v":0},{"$f":"SUM(R19:R21)","v":0},{"$f":"SUM(S19:S21)","v":0},{"$f":"SUM(T19:T21)","v":0}]

{"sheet":"2.1.1B","index":6,"n_rows":22,"n_cols":29,"rows_kept":22,"cut":false,"hidden":true,"merged":[[9,9,10,11],[1,2,1,13]]}
[null,"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[null,null,"2.1.1 COEFICIENTE POR FASES Y POR SUSTITUCIÓN DE DOCUMENTOS"]
[]
[null,null,null,null,null,null,null,null,null,"PORCENTAJES POR SUSTITUCIÓN DE DOCUMENTOS"]
[null,null,null,"AYUDA",null,null,null,null,null,"Porcentaje modificado","≤25 %",">25%",">50%",">75%"]
[null,null,false,"Estudios previos",null,null,{"$f":"IF( C6=TRUE,AB6,\"\")","v":""},null,null,"Memoria",null,null,null,null,null,null,false,false,false,null,false,{"$f":"IF(Q6=TRUE,0.1,0)","v":0},{"$f":"IF(R6=TRUE,0.8,0)","v":0},null,null,{"$f":"IF(U6=TRUE,0.1,0)","v":0},{"$f":"SUM(V6:Z6)","v":0},0.05,{"$f":"SUM(V6:AB6)","v":0.05}]
[null,null,false,"Anteproyecto",null,null,{"$f":"IF( C7=TRUE,AB7,\"\")","v":""},null,null,"Mediciones y presupuestos",null,null,null,null,null,null,false,false,false,null,false,{"$f":"IF(Q7=TRUE,0.15,0)","v":0},{"$f":"IF(R7=TRUE,0.75,0)","v":0},null,null,{"$f":"IF(U7=TRUE,0.1,0)","v":0},0,0.15,0.15]
[null,null,false,"Proyecto básico",null,null,"",null,null,"Planos",null,null,null,null,null,null,false,false,false,null,false,{"$f":"IF(Q8=TRUE,0.15,0)","v":0},{"$f":"IF(R8=TRUE,0.75,0)","v":0},null,null,{"$f":"IF(U8=TRUE,0.1,0)","v":0},0,0.1,0.1]
[null,null,false,"Proyecto de ejecución",null,null,"",null,null,"TOTAL",{"$f":"Q22","v":0},{"$f":"R22","v":0},{"$f":"S22","v":0},{"$f":"T22","v":0},null,null,false,false,false,false,false,{"$f":"IF(Q9=TRUE,0.12,0)","v":0},{"$f":"IF(R9=TRUE,0.53,0)","v":0},{"$f":"IF(S9=TRUE,0.1,0)","v":0},{"$f":"IF(T9=TRUE,0.12,0)","v":0},{"$f":"IF(U9=TRUE,0.13,0)","v":0},0,0.5,0.5]
[null,null,false,"Dirección de obra",null,null,"",null,null,"Coeficiente de aprovechamiento del documento anterior, según porcentaje modificado",null,null,null,null,null,null,null,false,false,null,false,null,{"$f":"IF(R10=TRUE,0.67,0)","v":0},null,null,{"$f":"IF(U10=TRUE,0.33*N13,0)","v":0},0,0.05,0.05]
[null,null,false,"Liquidación y recepción",null,null,"",null,null,null,null,null,{"$f":"SUM(K9:N9)","v":0},null,null,null,false,null,false,null,false,{"$f":"IF(Q11=TRUE,0.15,0)","v":0},null,null,null,{"$f":"IF(U11=TRUE,0.85,0)","v":0},0,0.15,0.15]
[]
[null,null,null,null,null,null,{"$f":"IF(M11=0,SUM(G6:G11),SUM(G6:G11)*M11)","v":0},null,null,null,null,null,null,1]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q16=TRUE,0,0)","v":0},{"$f":"IF(R16=TRUE,0.025,0)","v":0},{"$f":"IF(S16=TRUE,0.05,0)","v":0},{"$f":"IF(T16=TRUE,0.075,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q17=TRUE,0,0)","v":0},{"$f":"IF(R17=TRUE,0.025,0)","v":0},{"$f":"IF(S17=TRUE,0.05,0)","v":0},{"$f":"IF(T17=TRUE,0.075,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q18=TRUE,0,0)","v":0},{"$f":"IF(R18=TRUE,0.15,0)","v":0},{"$f":"IF(S18=TRUE,0.3,0)","v":0},{"$f":"IF(T18=TRUE,0.45,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q19:Q21)","v":0},{"$f":"SUM(R19:R21)","v":0},{"$f":"SUM(S19:S21)","v":0},{"$f":"SUM(T19:T21)","v":0}]

{"sheet":"2.2C","index":7,"n_rows":62,"n_cols":30,"rows_kept":62,"cut":false,"hidden":true,"merged":[[39,7,40,12],[28,2,28,8],[28,10,28,11],[30,5,30,8],[32,4,32,8],[34,7,35,8],[37,7,37,8],[0,2,0,21],[1,2,1,21],[4,2,4,10],[6,5,7,5],[6,14,7,14],[6,18,7,18],[6,20,7,20]]}
[{"$f":"'1'!$N$17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IVA","v":1.21}]
[false,null,"2.2 OBRAS DE INTERVENCIÓN PARCIAL: AMPLIACIÓN, REHABILITACIÓN, REFORMA…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,"Se calcula mediante una de las siguientes fórmula:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,205]
[false,null,"PV = Módulo · C · [Σ.Si · Qv] · F / 6000 · f",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B38","v":{"$error":"#VALUE!"}}]
[null,null,"Plantas",null,null,"Num. Plantas",null,null,null,null,null,null,null,null,"Codigo del Uso",null,"Sup. Planta",null,"Total m2            Uso",null,"Qv",null,{"$f":"IF(W6*W5<W3,W3,IF(W6*W5>W4,W4,W6*W5))","v":{"$error":"#VALUE!"}}]
[null,null,"de","A"]
[null,1,null,null,null,null,null,null,{"$f":"INDEX(USOS!$C$1:$C$65,$B9)","v":0},null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B9)","v":0},null,null,"m2",{"$f":"Q9*F9*AA9","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B9)","v":0},null,{"$f":"IF(U9<>\"-\",U9*S9,0)","v":0},null,null,4,{"$f":"INDEX(M44:M49,$Z9)","v":0.7},{"$f":"W9","v":0}]
[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":"W10","v":0}]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B11)","v":0},null,null,"m2",{"$f":"Q11*F11*AA11","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B11)","v":0},null,{"$f":"IF(U11<>\"-\",U11*S11,0)","v":0},null,null,1,{"$f":"INDEX(M44:M49,$Z11)","v":1},0]
[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,0]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B13)","v":0},null,null,"m2",{"$f":"Q13*F13*AA13","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B13)","v":0},null,{"$f":"IF(U13<>\"-\",U13*S13,0)","v":0},null,null,1,{"$f":"INDEX(M44:M49,$Z13)","v":1},0]
[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,0]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B15)","v":0},null,null,"m2",{"$f":"Q15*F15*AA15","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B15)","v":0},null,{"$f":"IF(U15<>\"-\",U15*S15,0)","v":0},null,null,1,{"$f":"INDEX(M44:M49,$Z15)","v":1},0]
[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,0]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B17)","v":0},null,null,"m2",{"$f":"Q17*F17*AA17","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B17)","v":0},null,{"$f":"IF(U17<>\"-\",U17*S17,0)","v":0},null,null,1,{"$f":"INDEX(M44:M49,$Z17)","v":1},0]
[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,0]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B19)","v":0},null,null,"m2",{"$f":"Q19*F19*AA19","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B19)","v":0},null,{"$f":"IF(U19<>\"-\",U19*S19,0)","v":0},null,null,1,{"$f":"INDEX(M44:M49,$Z19)","v":1},0]
[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,0]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B21)","v":0},null,null,"m2",{"$f":"Q21*F21*AA21","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B21)","v":0},null,{"$f":"IF(U21<>\"-\",U21*S21,0)","v":0},null,null,1,{"$f":"INDEX(M44:M49,$Z21)","v":1},0]
[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,0]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B23)","v":0},null,null,"m2",{"$f":"Q23*F23*AA23","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B23)","v":0},null,{"$f":"IF(U23<>\"-\",U23*S23,0)","v":0},null,null,1,{"$f":"INDEX(M44:M49,$Z23)","v":1},0]
[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,0]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B25)","v":0},null,null,"m2",{"$f":"Q25*F25*AA25","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B25)","v":0},null,{"$f":"IF(U25<>\"-\",U25*S25,0)","v":0},null,null,1,{"$f":"INDEX(M44:M49,$Z25)","v":1},0]
[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,0]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B27)","v":0},null,null,"m2",{"$f":"Q27*F27*AA27","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B27)","v":0},null,{"$f":"IF(U27<>\"-\",U27*S27,0)","v":0},null,null,1,{"$f":"INDEX(M44:M49,$Z27)","v":1},0]
[]
[null,null,"Presupuesto de ejecución material PEM",null,null,null,null,null,null,"=",null,null,"€",{"$f":"IF(S29=\"-\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,{"$f":"IF(K29=0,0,0.5+(6*((MODULO/K29)^0.2)))","v":0},{"$f":"IF(B31>=2.5,2.5,B31)","v":0},null,null,{"$f":"IF(K29=0,0,CONCATENATE(ROUND(K29/S31,2),\" €/m2   \",ROUND((K29/S31)*166.386,0),\" pts/m2\"))","v":0},null,null,null,null,{"$f":"IF(S31<=300,11.75,IF(S31<=400,11.5,IF(S31<=600,10.8,IF(S31<=800,11.3,IF(S31<=1000,10,IF(S31<=2000,9,L31))))))","v":11.75},{"$f":"IF(S31<=3000,8.6,IF(S31<=5000,8,IF(S31<=8000,7.5,IF(S31<=12000,7.1,IF(S31<=20000,6.7,IF(S31<=35000,6.2,M31))))))","v":8.6},{"$f":"IF(S31<=80000,5.7,IF(S31<=120000,5.4,IF(S31<=200000,5.2,IF(S31<=400000,4.8,IF(S31<=700000,4.6,IF(S31<=1000000,4.45,4.45))))))","v":5.7},null,null,null,"Σ Si","=",{"$f":"Q9*F9+Q11*F11+Q13*F13+Q15*F15+Q17*F17+Q19*F19+Q21*F21+Q23*F23+Q25*F25+Q25*F25+Q27*F27","v":0},"m2",null,null,{"$f":"SUM(W9,W11,W13,W15,W17,W19,W21,W23,W25,W27)","v":0}]
[]
[null,{"$f":"IF(K36=0,0,K36*K29*C31/1000)","v":0},null,null,"coeficiente por superficie construida ",null,null,null,null,"=",{"$f":"IF(S31<>0,M33,\"\")","v":""},{"$f":"IF(S31<>0,(2.6+10.2*((200/S31)^0.2)),0)","v":0},{"$f":"IF(L33>11.75,11.75,IF(L33<4.457,4.45,L33))","v":4.45},null,null,null,"Σ Si . Qv","=",{"$f":"W31","v":0},null,null,null,null,null,null,null,null,{"$f":"100*1.2","v":120},null,{"$f":"AA9*AB33","v":84}]
[]
[null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Coeficiente de FASE",null,null,{"$f":"'2.1.1B'!$G$13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q11*U11","v":0},null,{"$f":"AB35*AA11","v":0}]
[null,null,null,null,null,null,null,null,null,"=",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,{"$f":"SUM(AD33:AD35)","v":84}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"K35","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$E$2:$E$7,$X36)","v":1}]
[null,{"$f":"MODULO*K33*S33*K36/6000","v":{"$error":"#VALUE!"}},{"$f":"MODULO/40","v":13.469749999999999},null,null,{"$f":"IF(B33<B38*X37,B38*X37,B33)","v":{"$error":"#VALUE!"}},null,"Calculo",null,"=",{"$f":"IF(A5=TRUE,F39+W7,F39)","v":{"$error":"#VALUE!"}},{"$f":"IF(B33<B38,\"Calculo según Obra nueva\",\" \")","v":{"$error":"#VALUE!"}},null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"IF(F38>W2,F38,W2)","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"CONCATENATE(ROUND(K38*W1,2),\" € c/IVA\")","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"W7","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Coeficiente de minoración"]
[null,null,null,null,null,null,null,null,null,null,null,"Intervención Completa",1]
[null,null,null,null,null,null,null,null,null,null,null,"Estructura",0.4]
[null,null,null,null,null,null,null,null,null,null,null,"Estructura, instalaciones, albañileria y acabados",0.9]
[null,null,null,null,null,null,null,null,null,null,null,"Instalaciones, albañileria y acabados",0.7]
[null,null,null,null,null,null,null,null,null,null,null,"Albañileria y acabados",0.5]
[null,null,null,null,null,null,null,null,null,null,null,"Acabados",0.3]
[null,null,null,null,null,null,null,null,null,null,null,"ALBAÑILERIA",0.1]
[null,null,null,null,null,null,null,null,null,null,null,"ACABADOS",0.1]
[null,null,null,null,null,null,null,null,null,null,null,"ALBAÑILERIA+ACABADOS",0.2]
[null,null,null,null,null,null,null,null,null,null,null,"INSTALACIONES",0.4]
[null,null,null,null,null,null,null,null,null,null,null,"ESTRUCTURA",0.4]
[null,null,null,null,null,null,null,null,null,null,null,"ALBAÑILERIA+INSTALACIONES",0.5]
[null,null,null,null,null,null,null,null,null,null,null,"ALBAÑILERIA+ESTRUCTURA",0.5]
[null,null,null,null,null,null,null,null,null,null,null,"ACABADOS+INSTALACIONES",0.5]
[null,null,null,null,null,null,null,null,null,null,null,"ACABADOS+ESTRUCTURA",0.5]
[null,null,null,null,null,null,null,null,null,null,null,"ALBAÑILERIA+ACABADOS+INSTALACIONES",0.6]
[null,null,null,null,null,null,null,null,null,null,null,"ALBAÑILERIA+ACABADOS+ESTRUCTURAS",0.6]
[null,null,null,null,null,null,null,null,null,null,null,"INSTALACIONES+ESTRUCTURA",0.8]
[null,null,null,null,null,null,null,null,null,null,null,"COMPLETA",1]

{"sheet":"2.2CBIS","index":8,"n_rows":39,"n_cols":24,"rows_kept":39,"cut":false,"hidden":true,"merged":[[0,2,0,21],[1,2,1,21],[4,2,4,10],[6,5,7,5],[6,14,7,14],[6,18,7,18],[28,2,28,8],[34,7,35,8],[37,7,37,8],[39,7,40,12],[32,4,32,8],[30,5,30,8],[28,10,28,11]]}
[{"$f":"'1'!$N$17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IVA","v":1.21}]
[false,null,"2.2 OBRAS DE INTERVENCIÓN PARCIAL: AMPLIACIÓN, REHABILITACIÓN, REFORMA…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,"Se calcula mediante una de las siguientes fórmula:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200]
[false,null,"PV = Módulo · C · [Σ.Si · Qv] · F / 6000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B38","v":{"$error":"#VALUE!"}}]
[null,null,"Plantas",null,null,"Num. Plantas",null,null,null,null,null,null,null,null,"Codigo del Uso",null,"Sup. Planta",null,"Total m2            Uso",null,"Qv",null,{"$f":"IF(W6*W5<W3,W3,IF(W6*W5>W4,W4,W6*W5))","v":{"$error":"#VALUE!"}}]
[null,null,"de","A"]
[null,1,null,null,null,null,null,null,{"$f":"INDEX(USOS!$C$1:$C$65,$B9)","v":0},null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B9)","v":0},null,null,"m2",{"$f":"Q9*F9","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B9)","v":0},null,{"$f":"IF(U9<>\"-\",U9*S9,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B11)","v":0},null,null,"m2",{"$f":"Q11*F11","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B11)","v":0},null,{"$f":"IF(U11<>\"-\",U11*S11,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B13)","v":0},null,null,"m2",{"$f":"Q13*F13","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B13)","v":0},null,{"$f":"IF(U13<>\"-\",U13*S13,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B15)","v":0},null,null,"m2",{"$f":"Q15*F15","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B15)","v":0},null,{"$f":"IF(U15<>\"-\",U15*S15,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B17)","v":0},null,null,"m2",{"$f":"Q17*F17","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B17)","v":0},null,{"$f":"IF(U17<>\"-\",U17*S17,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B19)","v":0},null,null,"m2",{"$f":"Q19*F19","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B19)","v":0},null,{"$f":"IF(U19<>\"-\",U19*S19,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B21)","v":0},null,null,"m2",{"$f":"Q21*F21","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B21)","v":0},null,{"$f":"IF(U21<>\"-\",U21*S21,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B23)","v":0},null,null,"m2",{"$f":"Q23*F23","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B23)","v":0},null,{"$f":"IF(U23<>\"-\",U23*S23,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B25)","v":0},null,null,"m2",{"$f":"Q25*F25","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B25)","v":0},null,{"$f":"IF(U25<>\"-\",U25*S25,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B27)","v":0},null,null,"m2",{"$f":"Q27*F27","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B27)","v":0},null,{"$f":"IF(U27<>\"-\",U27*S27,0)","v":0}]
[]
[null,null,"Presupuesto de ejecución material PEM",null,null,null,null,null,null,"=",null,null,"€",{"$f":"IF(S29=\"-\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,{"$f":"IF(K29=0,0,0.5+(6*((MODULO/K29)^0.2)))","v":0},{"$f":"IF(B31>=2.5,2.5,B31)","v":0},null,null,{"$f":"IF(K29=0,0,CONCATENATE(ROUND(K29/S31,2),\" €/m2   \",ROUND((K29/S31)*166.386,0),\" pts/m2\"))","v":0},null,null,null,null,{"$f":"IF(S31<=300,11.75,IF(S31<=400,11.5,IF(S31<=600,10.8,IF(S31<=800,11.3,IF(S31<=1000,10,IF(S31<=2000,9,L31))))))","v":11.75},{"$f":"IF(S31<=3000,8.6,IF(S31<=5000,8,IF(S31<=8000,7.5,IF(S31<=12000,7.1,IF(S31<=20000,6.7,IF(S31<=35000,6.2,M31))))))","v":8.6},{"$f":"IF(S31<=80000,5.7,IF(S31<=120000,5.4,IF(S31<=200000,5.2,IF(S31<=400000,4.8,IF(S31<=700000,4.6,IF(S31<=1000000,4.45,4.45))))))","v":5.7},null,null,null,"Σ Si","=",{"$f":"SUM(S27,S25,S23,S21,S19,S17,S15,S13,S11,S9)","v":0},"m2",null,null,{"$f":"SUM(W9,W11,W13,W15,W17,W19,W21,W23,W25,W27)","v":0}]
[]
[null,{"$f":"IF(K36=0,0,K36*K29*C31/1000)","v":0},null,null,"coeficiente por superficie construida ",null,null,null,null,"=",{"$f":"IF(S31<>0,M33,\"\")","v":""},{"$f":"IF(S31<>0,(2.6+10.2*((200/S31)^0.2)),0)","v":0},{"$f":"IF(L33>11.75,11.75,IF(L33<4.457,4.45,L33))","v":4.45},null,null,null,"Σ Si . Qv","=",{"$f":"W31","v":0}]
[]
[null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Coeficiente de FASE",null,null,{"$f":"'2.1.1B'!$G$13","v":0}]
[null,null,null,null,null,null,null,null,null,"=",null,null,null,null,"Coeficiente de minoración",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$E$2:$E$7,$X36)","v":1}]
[null,{"$f":"MODULO*K33*S33*K36/6000","v":{"$error":"#VALUE!"}},{"$f":"MODULO/40","v":13.469749999999999},null,null,{"$f":"IF(B33<B38*X37,B38*X37,B33)","v":{"$error":"#VALUE!"}},null,"Calculo",null,"=",{"$f":"IF(A5=TRUE,F39+W7,F39)","v":{"$error":"#VALUE!"}},{"$f":"IF(B33<B38,\"Calculo según Obra nueva\",\" \")","v":{"$error":"#VALUE!"}},null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"IF(F38>W2,F38,W2)","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"CONCATENATE(ROUND(K38*W1,2),\" € c/IVA\")","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"W7","v":{"$error":"#VALUE!"}}]

{"sheet":"2.3C","index":9,"n_rows":39,"n_cols":24,"rows_kept":39,"cut":false,"hidden":true,"merged":[[28,2,28,8],[34,7,35,8],[37,7,37,8],[39,7,40,12],[32,4,32,8],[30,5,30,8],[28,10,28,11],[34,12,34,16],[35,12,35,16],[0,2,0,21],[1,2,1,21],[4,2,4,10],[6,5,7,5],[6,14,7,14],[6,18,7,18]]}
[{"$f":"'1'!$N$17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IVA","v":1.21}]
[false,null,"2.3 EXPEDIENTES DE LEGALIZACIÓN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,"Se calcula mediante una de las siguientes fórmula:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,205]
[false,null,"PV = Módulo · C · [Σ.Si · Qv] · F / 6000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B38","v":{"$error":"#VALUE!"}}]
[null,null,"Plantas",null,null,"Num. Plantas",null,null,null,null,null,null,null,null,"Codigo del Uso",null,"Sup. Planta",null,"Total m2            Uso",null,"Qv",null,{"$f":"IF(W6*W5<W3,W3,IF(W6*W5>W4,W4,W6*W5))","v":{"$error":"#VALUE!"}}]
[null,null,"de","A"]
[null,1,null,null,null,null,null,null,{"$f":"INDEX(USOS!$C$1:$C$65,$B9)","v":0},null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B9)","v":0},null,null,"m2",{"$f":"Q9*F9","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B9)","v":0},null,{"$f":"IF(U9<>\"-\",U9*S9,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B11)","v":0},null,null,"m2",{"$f":"Q11*F11","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B11)","v":0},null,{"$f":"IF(U11<>\"-\",U11*S11,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B13)","v":0},null,null,"m2",{"$f":"Q13*F13","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B13)","v":0},null,{"$f":"IF(U13<>\"-\",U13*S13,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B15)","v":0},null,null,"m2",{"$f":"Q15*F15","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B15)","v":0},null,{"$f":"IF(U15<>\"-\",U15*S15,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B17)","v":0},null,null,"m2",{"$f":"Q17*F17","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B17)","v":0},null,{"$f":"IF(U17<>\"-\",U17*S17,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B19)","v":0},null,null,"m2",{"$f":"Q19*F19","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B19)","v":0},null,{"$f":"IF(U19<>\"-\",U19*S19,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B21)","v":0},null,null,"m2",{"$f":"Q21*F21","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B21)","v":0},null,{"$f":"IF(U21<>\"-\",U21*S21,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B23)","v":0},null,null,"m2",{"$f":"Q23*F23","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B23)","v":0},null,{"$f":"IF(U23<>\"-\",U23*S23,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B25)","v":0},null,null,"m2",{"$f":"Q25*F25","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B25)","v":0},null,{"$f":"IF(U25<>\"-\",U25*S25,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B27)","v":0},null,null,"m2",{"$f":"Q27*F27","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B27)","v":0},null,{"$f":"IF(U27<>\"-\",U27*S27,0)","v":0}]
[]
[null,null,"Presupuesto de ejecución material PEM",null,null,null,null,null,null,"=",null,null,"€",{"$f":"IF(S29=\"-\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,{"$f":"IF(K29=0,0,0.5+(6*((MODULO/K29)^0.2)))","v":0},{"$f":"IF(B31>=2.5,2.5,B31)","v":0},null,null,{"$f":"IF(K29=0,0,CONCATENATE(ROUND(K29/S31,2),\" €/m2   \",ROUND((K29/S31)*166.386,0),\" pts/m2\"))","v":0},null,null,null,null,{"$f":"IF(S31<=300,11.75,IF(S31<=400,11.5,IF(S31<=600,10.8,IF(S31<=800,11.3,IF(S31<=1000,10,IF(S31<=2000,9,L31))))))","v":11.75},{"$f":"IF(S31<=3000,8.6,IF(S31<=5000,8,IF(S31<=8000,7.5,IF(S31<=12000,7.1,IF(S31<=20000,6.7,IF(S31<=35000,6.2,M31))))))","v":8.6},{"$f":"IF(S31<=80000,5.7,IF(S31<=120000,5.4,IF(S31<=200000,5.2,IF(S31<=400000,4.8,IF(S31<=700000,4.6,IF(S31<=1000000,4.45,4.45))))))","v":5.7},null,null,null,"Σ Si","=",{"$f":"SUM(S27,S25,S23,S21,S19,S17,S15,S13,S11,S9)","v":0},"m2",null,null,{"$f":"SUM(W9,W11,W13,W15,W17,W19,W21,W23,W25,W27)","v":0}]
[]
[null,{"$f":"IF(K36=0,0,K36*K29*C31/1000)","v":0},null,null,"coeficiente por superficie construida ",null,null,null,null,"=",{"$f":"IF(S31<>0,M33,\"\")","v":""},{"$f":"IF(S31<>0,(2.6+10.2*((200/S31)^0.2)),0)","v":0},{"$f":"IF(L33>11.75,11.75,IF(L33<4.457,4.45,L33))","v":4.45},null,null,null,"Σ Si . Qv","=",{"$f":"W31","v":0}]
[]
[null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Coeficiente de FASE",null,null,null,null,"Legalización completa (80%)",null,null,null,null,false,{"$f":"IF(R35=TRUE,0.8,0)","v":0},null,{"$f":"S35+S36","v":0}]
[null,null,null,null,null,null,null,null,null,"=",null,null,"Legalización sólo de dirección de obra (15%)",null,null,null,null,false,{"$f":"IF(R36=TRUE,0.15,0)","v":0},null,null,null,null,1]
[]
[null,{"$f":"MODULO*K33*S33*K36/6000","v":{"$error":"#VALUE!"}},{"$f":"MODULO/40","v":13.469749999999999},null,null,{"$f":"IF(B33<B38,B38,B33)","v":{"$error":"#VALUE!"}},null,"Calculo",null,"=",{"$f":"IF(A5=TRUE,F39+W7,F39)","v":{"$error":"#VALUE!"}},{"$f":"IF(B33<B38,\"Calculo según Obra nueva\",\" \")","v":{"$error":"#VALUE!"}},null,null,"URGENTE O RAPIDO",null,null,null,{"$f":"W7","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,{"$f":"IF(F38>W2,F38,W2)","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"CONCATENATE(ROUND(K38*W1,2),\" € c/IVA\")","v":{"$error":"#VALUE!"}}]

{"sheet":"2.2B","index":10,"n_rows":18,"n_cols":19,"rows_kept":18,"cut":false,"hidden":true,"merged":[[1,2,1,5],[13,2,14,4],[0,2,0,5],[2,2,3,2]]}
[400,"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[false,null,"2.2 OBRAS DE CONSERVACIÓN, REPARACIÓN, REFORMA, REESTRUCTURACIÓN, AMPLIACIÓN, ACONDICIONAMIENTO, REHABILITACIÓN, CONSOLIDACIÓN Y/O RESTAURACIÓN"]
[null,null,"Presupuesto de ejecución material \nde la obra       (PEM) ="]
[null,null,null,null,"€"]
[]
[{"$f":"IF(D4=0,0,0.5+(6*((MODULO/D4)^0.2)))","v":0},null,"Coeficiente CP =",{"$f":"IF(A6>=2.5,2.5,A6)","v":0}]
[]
[null,null,"Coeficiente de FASE",{"$f":"'2.1.1B'!$G$13","v":0},null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[]
[null,{"$f":"IF(D9=0,0,D9*D4*D6/1000)","v":0},"Calculo",{"$f":"IF(B12>MODULO/40,B12,IF(D9=0,0,MODULO/40))","v":0},null,null,null,null,null,null,null,null,null,null,false,false,false,false,false]
[null,null,null,{"$f":"CONCATENATE(ROUND(D12*1.16,2),\" € c/IVA\")","v":"0 € c/IVA"},null,null,null,null,null,null,null,null,null,null,null,false,null,null,false]
[null,null,"El cliente desea que la cuota variable de intervención por visado le sea facturada a su nombre",null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,false]
[]
[]
[null,null,null,"Arquitecto","Cliente"]
[null,null,null,{"$f":"D12/3","v":0},{"$f":"D12*2/3","v":0}]

{"sheet":"2.3.1","index":11,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":true,"merged":[[0,2,0,6],[1,2,1,6],[7,2,7,6],[17,2,18,4],[4,3,5,5],[4,2,5,2]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,{"$f":"IVA","v":1.21}]
[false,null,"4.1 SEGURIDAD Y SALUD",null,null,null,null,68,25]
[2,null,null,null,null,null,null,45,200]
[true,null,null,"Estudio de Seguridad y Salud",null,null,null,null,0.1]
[false,null,null,"Estudios Básicos de Seguridad y Salud, Plan de Seguridad y Salud, Coordinación y otros trabajos relacionados",null,null,null,null,{"$f":"B16","v":45}]
[null,null,null,null,null,null,null,null,{"$f":"IF(I5*I4<I2,I2,IF(I5*I4>I3,I3,I5*I4))","v":25}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A5=TRUE,I5+I6,I5)","v":45}]
[1,"è",{"$f":"INDEX(USOS!$A$1:$A$65,$A8)","v":"Seleccione USO… (coeficiente Qv)"}]
[]
[null,null,null,"Codigo de uso:",{"$f":"INDEX(USOS!$B$1:$B$68,$A8)","v":0},"Q=",{"$f":"INDEX(USOS!$C$1:$C$68,$A8)","v":0}]
[]
[{"$f":"IF(D12<I14,H14,IF(D12<I15,H15,IF(D12<I16,H16,IF(D12<I17,H17,IF(D12<I18,H18,IF(D12<I19,H19,H20))))))","v":15396.439999999999},{"$f":"IF(G10>0,0.02*A12,0)","v":0},"Superficie",null,"m2"]
[null,{"$f":"IF(A3=1,IF(B12>H2,B12,H2),IF(B12>H3,B12,H3))","v":45}]
[{"$f":"D14*0.03*0.02*0.07","v":0},{"$f":"IF(D14=0,A14,A14)","v":0},null,0,"€",null,"a",{"$f":"1.5*MODULO","v":808.18499999999995},{"$f":"IF(G10<=0,0,400.01/G10)","v":0}]
[null,null,"URGENTE O RAPIDO",null,{"$f":"I6","v":25},null,"b",{"$f":"1.5*MODULO+(D12-400)*1","v":408.18499999999995},{"$f":"IF(G10<=0,0,1000.01/G10)","v":0}]
[null,{"$f":"B13","v":45},"Calculo",{"$f":"I7","v":45},null,null,"c",{"$f":"3*MODULO+(D12-1000)*0.8","v":816.36999999999989},{"$f":"IF(G10<=0,0,2000.01/G10)","v":0}]
[null,null,null,{"$f":"CONCATENATE(ROUND(D16*H1,2),\" € c/IVA\")","v":"54,45 € c/IVA"},null,null,"d",{"$f":"5*MODULO+(D12-2000)*0.6","v":1493.9499999999998},{"$f":"IF(G10<=0,0,8000.01/G10)","v":0}]
[null,null,null,null,null,null,"e",{"$f":"14*MODULO+(D12-8000)*0.4","v":4343.0599999999995},{"$f":"IF(G10<=0,0,20000.01/G10)","v":0}]
[null,null,null,null,null,null,"f",{"$f":"26*MODULO+(D12-20000)*0.2","v":10008.539999999999},{"$f":"IF(G10<=0,0,40000.01/G10)","v":0}]
[null,null,null,null,null,null,"g",{"$f":"36*MODULO+(D12-40000)*0.1","v":15396.439999999999}]

{"sheet":"2.3.1A","index":12,"n_rows":33,"n_cols":26,"rows_kept":33,"cut":false,"hidden":true,"merged":[[22,2,22,6],[28,3,28,4],[12,2,12,6],[14,2,14,6],[16,2,16,6],[18,2,18,6],[20,2,20,6],[5,2,6,5],[3,2,3,5],[1,2,1,6],[10,2,10,6],[8,9,9,9]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,{"$f":"IVA","v":1.21}]
[false,null,"4.1 SEGURIDAD Y SALUD",null,null,null,null,68]
[1,null,null,null,null,null,null,45]
[true,null,"Estudio de Seguridad y Salud"]
[false]
[null,null,"Estudios Básicos de Seguridad y Salud, Plan de Seguridad y Salud, Coordinación y otros trabajos relacionados"]
[null,null,null,null,null,null,null,null,null,45,null,35]
[1]
[1,null,"Seleccione USO",null,null,null,null,"Codigo de uso:",null,"Qv",null,"Superficie (m²)",null,null,400,1000,2000,8000,20000,40000]
[]
[1,null,{"$f":"INDEX(USOS!$A$1:$A$65,$A11)","v":"Seleccione USO… (coeficiente Qv)"},null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$A11)","v":0},null,{"$f":"INDEX(USOS!$C$1:$C$68,$A11)","v":0},null,null,{"$f":"L11*J11","v":0},null,{"$f":"IF($L11=0,0,IF(M11<$O$9,1.5*$A$1/50,0))","v":0},{"$f":"IF($L11=0,0,IF(O11<>0,0,IF(M11<$P$9,((1.5*$A$1)+(M11-400)*1)/50,0)))","v":0},{"$f":"IF($L11=0,0,IF((P11+O11)<>0,0,IF(M11<$Q$9,((3*$A$1)+(M11-1000)*0.8)/50,0)))","v":0},{"$f":"IF($L11=0,0,IF((P11+O11+Q11)<>0,0,IF(M11<$R$9,((5*$A$1)+(M11-2000)*0.6)/50,0)))","v":0},{"$f":"IF($L11=0,0,IF((P11+O11+Q11+R11)<>0,0,IF(M11<$S$9,((14*$A$1)+(M11-8000)*0.4)/50,0)))","v":0},{"$f":"IF($L11=0,0,IF((P11+O11+Q11+R11+S11)<>0,0,IF(M11<$T$9,((26*$A$1)+(M11-20000)*0.2)/50,0)))","v":0},{"$f":"IF($L11=0,0,IF((P11+O11+Q11+R11+S11+T11)<>0,0,(36*$A$1)+(M11-40000)*0.1)/50)","v":0}]
[null,null,null,0]
[1,null,0,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$A13)","v":0},null,{"$f":"INDEX(USOS!$C$1:$C$68,$A13)","v":0},null,null,{"$f":"L13*J13","v":0},null,{"$f":"IF($L13=0,0,IF(M13<$O$9,1.5*$A$1/50,0))","v":0},{"$f":"IF($L13=0,0,IF(O13<>0,0,IF(M13<$P$9,((1.5*$A$1)+(M13-400)*1)/50,0)))","v":0},{"$f":"IF($L13=0,0,IF((P13+O13)<>0,0,IF(M13<$Q$9,((3*$A$1)+(M13-1000)*0.8)/50,0)))","v":0},{"$f":"IF($L13=0,0,IF((P13+O13+Q13)<>0,0,IF(M13<$R$9,((5*$A$1)+(M13-2000)*0.6)/50,0)))","v":0},{"$f":"IF($L13=0,0,IF((P13+O13+Q13+R13)<>0,0,IF(M13<$S$9,((14*$A$1)+(M13-8000)*0.4)/50,0)))","v":0},{"$f":"IF($L13=0,0,IF((P13+O13+Q13+R13+S13)<>0,0,IF(M13<$T$9,((26*$A$1)+(M13-20000)*0.2)/50,0)))","v":0},{"$f":"IF($L13=0,0,IF((P13+O13+Q13+R13+S13+T13)<>0,0,(36*$A$1)+(M13-40000)*0.1)/50)","v":0}]
[]
[1,null,{"$f":"INDEX(USOS!$A$1:$A$65,$A15)","v":"Seleccione USO… (coeficiente Qv)"},null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$A15)","v":0},null,{"$f":"INDEX(USOS!$C$1:$C$68,$A15)","v":0},null,null,{"$f":"L15*J15","v":0},null,{"$f":"IF($L15=0,0,IF(M15<$O$9,1.5*$A$1/50,0))","v":0},{"$f":"IF($L15=0,0,IF(O15<>0,0,IF(M15<$P$9,((1.5*$A$1)+(M15-400)*1)/50,0)))","v":0},{"$f":"IF($L15=0,0,IF((P15+O15)<>0,0,IF(M15<$Q$9,((3*$A$1)+(M15-1000)*0.8)/50,0)))","v":0},{"$f":"IF($L15=0,0,IF((P15+O15+Q15)<>0,0,IF(M15<$R$9,((5*$A$1)+(M15-2000)*0.6)/50,0)))","v":0},{"$f":"IF($L15=0,0,IF((P15+O15+Q15+R15)<>0,0,IF(M15<$S$9,((14*$A$1)+(M15-8000)*0.4)/50,0)))","v":0},{"$f":"IF($L15=0,0,IF((P15+O15+Q15+R15+S15)<>0,0,IF(M15<$T$9,((26*$A$1)+(M15-20000)*0.2)/50,0)))","v":0},{"$f":"IF($L15=0,0,IF((P15+O15+Q15+R15+S15+T15)<>0,0,(36*$A$1)+(M15-40000)*0.1)/50)","v":0}]
[]
[1,null,{"$f":"INDEX(USOS!$A$1:$A$65,$A17)","v":"Seleccione USO… (coeficiente Qv)"},null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$A17)","v":0},null,{"$f":"INDEX(USOS!$C$1:$C$68,$A17)","v":0},null,null,{"$f":"L17*J17","v":0},null,{"$f":"IF($L17=0,0,IF(M17<$O$9,1.5*$A$1/50,0))","v":0},{"$f":"IF($L17=0,0,IF(O17<>0,0,IF(M17<$P$9,((1.5*$A$1)+(M17-400)*1)/50,0)))","v":0},{"$f":"IF($L17=0,0,IF((P17+O17)<>0,0,IF(M17<$Q$9,((3*$A$1)+(M17-1000)*0.8)/50,0)))","v":0},{"$f":"IF($L17=0,0,IF((P17+O17+Q17)<>0,0,IF(M17<$R$9,((5*$A$1)+(M17-2000)*0.6)/50,0)))","v":0},{"$f":"IF($L17=0,0,IF((P17+O17+Q17+R17)<>0,0,IF(M17<$S$9,((14*$A$1)+(M17-8000)*0.4)/50,0)))","v":0},{"$f":"IF($L17=0,0,IF((P17+O17+Q17+R17+S17)<>0,0,IF(M17<$T$9,((26*$A$1)+(M17-20000)*0.2)/50,0)))","v":0},{"$f":"IF($L17=0,0,IF((P17+O17+Q17+R17+S17+T17)<>0,0,(36*$A$1)+(M17-40000)*0.1)/50)","v":0}]
[]
[1,null,{"$f":"INDEX(USOS!$A$1:$A$65,$A19)","v":"Seleccione USO… (coeficiente Qv)"},null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$A19)","v":0},null,{"$f":"INDEX(USOS!$C$1:$C$68,$A19)","v":0},null,null,{"$f":"L19*J19","v":0},null,{"$f":"IF($L19=0,0,IF(M19<$O$9,1.5*$A$1/50,0))","v":0},{"$f":"IF($L19=0,0,IF(O19<>0,0,IF(M19<$P$9,((1.5*$A$1)+(M19-400)*1)/50,0)))","v":0},{"$f":"IF($L19=0,0,IF((P19+O19)<>0,0,IF(M19<$Q$9,((3*$A$1)+(M19-1000)*0.8)/50,0)))","v":0},{"$f":"IF($L19=0,0,IF((P19+O19+Q19)<>0,0,IF(M19<$R$9,((5*$A$1)+(M19-2000)*0.6)/50,0)))","v":0},{"$f":"IF($L19=0,0,IF((P19+O19+Q19+R19)<>0,0,IF(M19<$S$9,((14*$A$1)+(M19-8000)*0.4)/50,0)))","v":0},{"$f":"IF($L19=0,0,IF((P19+O19+Q19+R19+S19)<>0,0,IF(M19<$T$9,((26*$A$1)+(M19-20000)*0.2)/50,0)))","v":0},{"$f":"IF($L19=0,0,IF((P19+O19+Q19+R19+S19+T19)<>0,0,(36*$A$1)+(M19-40000)*0.1)/50)","v":0}]
[]
[1,null,{"$f":"INDEX(USOS!$A$1:$A$65,$A21)","v":"Seleccione USO… (coeficiente Qv)"},null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$A21)","v":0},null,{"$f":"INDEX(USOS!$C$1:$C$68,$A21)","v":0},null,null,{"$f":"L21*J21","v":0},null,{"$f":"IF($L21=0,0,IF(M21<$O$9,1.5*$A$1/50,0))","v":0},{"$f":"IF($L21=0,0,IF(O21<>0,0,IF(M21<$P$9,((1.5*$A$1)+(M21-400)*1)/50,0)))","v":0},{"$f":"IF($L21=0,0,IF((P21+O21)<>0,0,IF(M21<$Q$9,((3*$A$1)+(M21-1000)*0.8)/50,0)))","v":0},{"$f":"IF($L21=0,0,IF((P21+O21+Q21)<>0,0,IF(M21<$R$9,((5*$A$1)+(M21-2000)*0.6)/50,0)))","v":0},{"$f":"IF($L21=0,0,IF((P21+O21+Q21+R21)<>0,0,IF(M21<$S$9,((14*$A$1)+(M21-8000)*0.4)/50,0)))","v":0},{"$f":"IF($L21=0,0,IF((P21+O21+Q21+R21+S21)<>0,0,IF(M21<$T$9,((26*$A$1)+(M21-20000)*0.2)/50,0)))","v":0},{"$f":"IF($L21=0,0,IF((P21+O21+Q21+R21+S21+T21)<>0,0,(36*$A$1)+(M21-40000)*0.1)/50)","v":0}]
[]
[1,null,{"$f":"INDEX(USOS!$A$1:$A$65,$A23)","v":"Seleccione USO… (coeficiente Qv)"},null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$A23)","v":0},null,{"$f":"INDEX(USOS!$C$1:$C$68,$A23)","v":0},null,null,{"$f":"L23*J23","v":0},null,{"$f":"IF($L23=0,0,IF(M23<$O$9,1.5*$A$1/50,0))","v":0},{"$f":"IF($L23=0,0,IF(O23<>0,0,IF(M23<$P$9,((1.5*$A$1)+(M23-400)*1)/50,0)))","v":0},{"$f":"IF($L23=0,0,IF((P23+O23)<>0,0,IF(M23<$Q$9,((3*$A$1)+(M23-1000)*0.8)/50,0)))","v":0},{"$f":"IF($L23=0,0,IF((P23+O23+Q23)<>0,0,IF(M23<$R$9,((5*$A$1)+(M23-2000)*0.6)/50,0)))","v":0},{"$f":"IF($L23=0,0,IF((P23+O23+Q23+R23)<>0,0,IF(M23<$S$9,((14*$A$1)+(M23-8000)*0.4)/50,0)))","v":0},{"$f":"IF($L23=0,0,IF((P23+O23+Q23+R23+S23)<>0,0,IF(M23<$T$9,((26*$A$1)+(M23-20000)*0.2)/50,0)))","v":0},{"$f":"IF($L23=0,0,IF((P23+O23+Q23+R23+S23+T23)<>0,0,(36*$A$1)+(M23-40000)*0.1)/50)","v":0}]
[46,26]
[{"$f":"IF(O25/10>206,206,O25/10)","v":0},206,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M11:M23)","v":0},null,{"$f":"SUM(O11:U23)","v":0},null,null,null,null,null,null,{"$f":"IF($J19>0,0.02*$M19,0)","v":0},null,{"$f":"IF($J21>0,0.02*$M21,0)","v":0},null,{"$f":"IF($J23>0,0.02*$M23,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,null,20,null,22]
[null,null,"URGENTE O RAPIDO",null,{"$f":"J6","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J19<=0,0,400.01/$J19)","v":0},{"$f":"1.5*MODULO","v":808.18499999999995},{"$f":"IF($J21<=0,0,400.01/$J21)","v":0},{"$f":"1.5*MODULO","v":808.18499999999995},{"$f":"IF($J23<=0,0,400.01/$J23)","v":0}]
[null,null,{"$f":"B29","v":26},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J19<=0,0,1000.01/$J19)","v":0},{"$f":"1.5*MODULO+($L21-400)*1","v":408.18499999999995},{"$f":"IF($J21<=0,0,1000.01/$J21)","v":0},{"$f":"1.5*MODULO+($L23-400)*1","v":408.18499999999995},{"$f":"IF($J23<=0,0,1000.01/$J15)","v":0}]
[{"$f":"IF(O25>46,O25,46)","v":46},{"$f":"IF(A25>B24,A25,B24)","v":26},"Calculo",{"$f":"IF(A5=FALSE,IF(A4=TRUE,A30,A29),IF(A4=TRUE,A30+B29,A29+B29))","v":36},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J19<=0,0,2000.01/$J19)","v":0},{"$f":"3*MODULO+($L21-1000)*0.8","v":816.36999999999989},{"$f":"IF($J21<=0,0,2000.01/$J21)","v":0},{"$f":"3*MODULO+($L23-1000)*0.8","v":816.36999999999989},{"$f":"IF($J23<=0,0,2000.01/$J23)","v":0}]
[36,null,null,null,{"$f":"CONCATENATE(ROUND(D29*H1,2),\" € c/IVA\")","v":"43,56 € c/IVA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J19<=0,0,8000.01/$J19)","v":0},{"$f":"5*MODULO+($L21-2000)*0.6","v":1493.9499999999998},{"$f":"IF($J21<=0,0,8000.01/$J21)","v":0},{"$f":"5*MODULO+($L23-2000)*0.6","v":1493.9499999999998},{"$f":"IF($J23<=0,0,8000.01/$J23)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J19<=0,0,20000.01/$J19)","v":0},{"$f":"14*MODULO+($L21-8000)*0.4","v":4343.0599999999995},{"$f":"IF($J21<=0,0,20000.01/$J21)","v":0},{"$f":"14*MODULO+($L23-8000)*0.4","v":4343.0599999999995},{"$f":"IF($J23<=0,0,20000.01/$J23)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J19<=0,0,40000.01/$J19)","v":0},{"$f":"26*MODULO+($L21-20000)*0.2","v":10008.539999999999},{"$f":"IF($J21<=0,0,40000.01/$J21)","v":0},{"$f":"26*MODULO+($L23-20000)*0.2","v":10008.539999999999},{"$f":"IF($J23<=0,0,40000.01/$J23)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"g",null,null,null,null,null,null,null,null,null,{"$f":"J19","v":0},{"$f":"36*MODULO+($L21-40000)*0.1","v":15396.439999999999},{"$f":"J21","v":0},{"$f":"36*MODULO+($L23-40000)*0.1","v":15396.439999999999},{"$f":"J23","v":0}]

{"sheet":"2.3.2","index":13,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":true,"merged":[[1,2,1,5],[0,2,0,5]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,{"$f":"IVA","v":1.21}]
[false,null,"2.5.1 TRABAJOS OPTATIVOS ADICIONALES Y ANEXOS A LOS PROYECTOS",null,null,null,31]
[null,null,null,null,null,null,26]
[null,null,"                 Nº horas",null,null,null,205]
[false,null,null,null,null,null,0.1]
[{"$f":"D4*MODULO/500","v":0},{"$f":"IF(A5=TRUE,A7+F9,A7)","v":31},"Calculo",{"$f":"B6","v":31},null,null,{"$f":"A6*G5","v":0}]
[{"$f":"IF(A6<=G2,G2,D4*MODULO/500)","v":31},null,null,{"$f":"IF(D6=\"\",0,D6*1.21)","v":37.51},"c/IVA",null,{"$f":"IF(G6*G5<G3,G3,IF(G6*G5>G4,G4,G6*G5))","v":26}]
[null,null,null,null,"URGENTE O RAPIDO"]

{"sheet":"2.3.3","index":14,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":true,"merged":[[1,2,1,5],[0,2,0,5],[2,2,2,5]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[null,null,"2.5.4 PROYECTOS PARCIALES VISADOS POR OTROS COLEGIOS PROFESIONALES"]
[null,null,"Los proyectos parciales firmados y visados por otros profesionales, que se aporten al COAM para su incorporación al proyecto de arquitectura, abonarán la cuota de 1/3 CV (costes indirectos colegiales sobre el visado) aplicada al porcentaje del presupuesto parcial respecto al total y sólo para las fases de proyecto de ejecución y dirección de obra."]

{"sheet":"2.3.3B","index":15,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":true,"merged":[[1,2,1,5],[0,2,0,5],[2,2,2,5]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[null,null,"2.5.5 Proyectos prototipo"]
[null,null,"El precio del visado a abonar por los proyecto-prototipo será la correspondiente a un Anteproyecto. "]

{"sheet":"2.4.1B","index":16,"n_rows":18,"n_cols":19,"rows_kept":18,"cut":false,"hidden":true,"merged":[[1,2,1,5],[13,2,14,4],[0,2,0,5],[2,2,3,2]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[false,null,"2.4.1 PROYECTO Y DIRECCIÓN DE DERRIBO PARCIAL DE EDIFICACIONES"]
[null,null,"Presupuesto de ejecución material \nde la obra       (PEM) ="]
[null,null,null,null,"€"]
[]
[{"$f":"IF(D4=0,0,0.5+(6*((MODULO/D4)^0.2)))","v":0},null,"Coeficiente CP =",{"$f":"IF(A6>=2.5,2.5,A6)","v":0}]
[]
[null,null,"Coeficiente de FASE",{"$f":"'2.1.1B'!$G$13","v":0},null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[false,null,"           Proyecto",null,null,null,{"$f":"IF(A9=TRUE,0.7,0)","v":0},null,null,null,null,null,null,null,false,false,null,null,false]
[false,null,"           Dirección de obras",null,null,null,{"$f":"IF(A10=TRUE,0.3,0)","v":0},null,null,null,null,null,null,null,false,false,null,null,false]
[null,null,null,null,null,null,{"$f":"SUM(G9:G10)","v":0}]
[null,{"$f":"G11*D4*D6/1000","v":0},"Calculo",{"$f":"IF(B12>MODULO/40,B12,IF(G11=0,0,MODULO/40))","v":0},null,null,null,null,null,null,null,null,null,null,false,false,false,false,false]
[null,null,null,{"$f":"CONCATENATE(ROUND(D12*1.16,2),\" € c/IVA\")","v":"0 € c/IVA"},null,null,null,null,null,null,null,null,null,null,null,false,null,null,false]
[null,null,"El cliente desea que la cuota variable de intervención por visado le sea facturada a su nombre",null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,false]
[]
[]
[null,null,null,"Arquitecto","Cliente"]
[null,null,null,{"$f":"D12/3","v":0},{"$f":"D12*2/3","v":0}]

{"sheet":"2.4.1C","index":17,"n_rows":18,"n_cols":19,"rows_kept":18,"cut":false,"hidden":true,"merged":[[1,2,1,5],[13,2,14,4],[0,2,0,5],[2,2,3,2]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[false,null,"2.4.1 DEMOLICIÓN PARCIAL"]
[null,null,"Presupuesto de ejecución material \nde la obra       (PEM) ="]
[null,null,null,null,"€"]
[]
[{"$f":"IF(D4=0,0,0.5+(6*((MODULO/D4)^0.2)))","v":0},null,"Coeficiente CP =",{"$f":"IF(A6>=2.5,2.5,A6)","v":0}]
[]
[null,null,"Coeficiente de FASE",{"$f":"'2.1.1B'!$G$13","v":0},null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[]
[null,null,"Calculo",{"$f":"IF(B12>MODULO/40,B12,IF(D9=0,0,MODULO/40))","v":0},null,null,null,null,null,null,null,null,null,null,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,false]
[]
[]
[null,null,null,null,"Cliente"]
[null,null,null,{"$f":"D12/3","v":0},{"$f":"D12*2/3","v":0}]

{"sheet":"2.4.1e","index":18,"n_rows":43,"n_cols":23,"rows_kept":43,"cut":false,"hidden":true,"merged":[[0,2,0,21],[1,2,1,21],[4,2,4,10],[6,5,7,5],[6,14,7,14],[6,18,7,18],[28,2,28,8],[34,7,35,8],[37,7,37,8],[39,7,40,12],[32,4,32,8],[30,5,30,8],[28,10,28,11]]}
[{"$f":"'1'!$N$17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[false,null,"2.4.1 DEMOLICIÓN PARCIAL"]
[]
[null,null,"Se calcula mediante una de las siguientes fórmula:"]
[null,null,"CV = Módulo · C · [Σ.Si · Qv] · F / 6000 ó CP · PEM · F / 1000"]
[]
[null,null,"Plantas",null,null,"Num. Plantas",null,null,null,null,null,null,null,null,"Codigo del Uso",null,"Sup. Planta",null,"Total m2            Uso",null,"Qv"]
[null,null,"de","A"]
[null,1,null,null,null,null,null,null,{"$f":"INDEX(USOS!$C$1:$C$65,$B9)","v":0},null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B9)","v":0},null,null,"m2",{"$f":"Q9*F9","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B9)","v":0},null,{"$f":"IF(U9<>\"-\",U9*S9,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B11)","v":0},null,null,"m2",{"$f":"Q11*F11","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B11)","v":0},null,{"$f":"IF(U11<>\"-\",U11*S11,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B13)","v":0},null,null,"m2",{"$f":"Q13*F13","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B13)","v":0},null,{"$f":"IF(U13<>\"-\",U13*S13,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B15)","v":0},null,null,"m2",{"$f":"Q15*F15","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B15)","v":0},null,{"$f":"IF(U15<>\"-\",U15*S15,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B17)","v":0},null,null,"m2",{"$f":"Q17*F17","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B17)","v":0},null,{"$f":"IF(U17<>\"-\",U17*S17,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B19)","v":0},null,null,"m2",{"$f":"Q19*F19","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B19)","v":0},null,{"$f":"IF(U19<>\"-\",U19*S19,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B21)","v":0},null,null,"m2",{"$f":"Q21*F21","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B21)","v":0},null,{"$f":"IF(U21<>\"-\",U21*S21,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B23)","v":0},null,null,"m2",{"$f":"Q23*F23","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B23)","v":0},null,{"$f":"IF(U23<>\"-\",U23*S23,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B25)","v":0},null,null,"m2",{"$f":"Q25*F25","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B25)","v":0},null,{"$f":"IF(U25<>\"-\",U25*S25,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B27)","v":0},null,null,"m2",{"$f":"Q27*F27","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B27)","v":0},null,{"$f":"IF(U27<>\"-\",U27*S27,0)","v":0}]
[]
[null,null,"Presupuesto de ejecución material PEM",null,null,null,null,null,null,"=",null,null,"€",{"$f":"IF(S29=\"-\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,{"$f":"IF(K29=0,0,0.5+(6*((MODULO/K29)^0.2)))","v":0},{"$f":"IF(B31>=2.5,2.5,B31)","v":0},null,null,{"$f":"IF(K29=0,0,CONCATENATE(ROUND(K29/S31,2),\" €/m2   \",ROUND((K29/S31)*166.386,0),\" pts/m2\"))","v":0},null,null,null,null,{"$f":"IF(S31<=300,11.75,IF(S31<=400,11.5,IF(S31<=600,10.8,IF(S31<=800,11.3,IF(S31<=1000,10,IF(S31<=2000,9,L31))))))","v":11.75},{"$f":"IF(S31<=3000,8.6,IF(S31<=5000,8,IF(S31<=8000,7.5,IF(S31<=12000,7.1,IF(S31<=20000,6.7,IF(S31<=35000,6.2,M31))))))","v":8.6},{"$f":"IF(S31<=80000,5.7,IF(S31<=120000,5.4,IF(S31<=200000,5.2,IF(S31<=400000,4.8,IF(S31<=700000,4.6,IF(S31<=1000000,4.45,4.45))))))","v":5.7},null,null,null,"Σ Si","=",{"$f":"SUM(S27,S25,S23,S21,S19,S17,S15,S13,S11,S9)","v":0},"m2",null,null,{"$f":"SUM(W9,W11,W13,W15,W17,W19,W21,W23,W25,W27)","v":0}]
[]
[null,{"$f":"IF(K36=0,0,K36*K29*C31/1000)","v":0},null,null,"coeficiente por superficie construida ",null,null,null,null,"=",{"$f":"IF(S31<>0,M33,\"\")","v":""},{"$f":"IF(S31<>0,(2.6+10.2*((200/S31)^0.2)),0)","v":0},{"$f":"IF(L33>11.75,11.75,IF(L33<4.457,4.45,L33))","v":4.45},null,null,null,"Σ Si . Qv","=",{"$f":"W31","v":0}]
[]
[null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Coeficiente de FASE",null,null,{"$f":"'2.1.1B'!$G$13","v":0}]
[null,null,null,null,null,null,null,null,null,"="]
[]
[null,{"$f":"MODULO*K33*S33*K36/6000","v":{"$error":"#VALUE!"}},{"$f":"MODULO/40","v":13.469749999999999},null,null,{"$f":"IF(B33<B38,B38,B33)","v":{"$error":"#VALUE!"}},null,"Calculo",null,"=",{"$f":"IF(F38>MODULO/40,F38,MODULO/40)","v":{"$error":"#VALUE!"}},{"$f":"IF(B33<B38,\"Calculo según Obra nueva\",\" \")","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(ROUND(K38*1.16,2),\" € c/IVA\")","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,"El cliente desea que la cuota variable de intervención por visado le sea facturada a su nombre"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Arquitecto","Cliente"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"K38/3","v":{"$error":"#VALUE!"}},{"$f":"K38*2/3","v":{"$error":"#VALUE!"}}]

{"sheet":"2.5.1C","index":19,"n_rows":43,"n_cols":23,"rows_kept":43,"cut":false,"hidden":true,"merged":[[28,2,28,8],[34,7,35,8],[37,7,37,8],[39,7,40,12],[32,4,32,8],[30,5,30,8],[28,10,28,11],[0,2,0,21],[1,2,1,21],[4,2,4,10],[6,5,7,5],[6,14,7,14],[6,18,7,18]]}
[{"$f":"'1'!$N$17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[false,null,"2.5.1 ARQUITECTURA MONUMENTAL Y CONMEMORATIVA"]
[]
[null,null,"Se calcula mediante una de las siguientes fórmula:"]
[null,null,"CV = Módulo · C · [Σ.Si · Qv] · F / 6000 ó CP · PEM · F / 1000"]
[]
[null,null,"Plantas",null,null,"Num. Plantas",null,null,null,null,null,null,null,null,"Codigo del Uso",null,"Sup. Planta",null,"Total m2            Uso",null,"Qv"]
[null,null,"de","A"]
[null,1,null,null,null,null,null,null,{"$f":"INDEX(USOS!$C$1:$C$65,$B9)","v":0},null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B9)","v":0},null,null,"m2",{"$f":"Q9*F9","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B9)","v":0},null,{"$f":"IF(U9<>\"-\",U9*S9,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B11)","v":0},null,null,"m2",{"$f":"Q11*F11","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B11)","v":0},null,{"$f":"IF(U11<>\"-\",U11*S11,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B13)","v":0},null,null,"m2",{"$f":"Q13*F13","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B13)","v":0},null,{"$f":"IF(U13<>\"-\",U13*S13,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B15)","v":0},null,null,"m2",{"$f":"Q15*F15","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B15)","v":0},null,{"$f":"IF(U15<>\"-\",U15*S15,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B17)","v":0},null,null,"m2",{"$f":"Q17*F17","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B17)","v":0},null,{"$f":"IF(U17<>\"-\",U17*S17,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B19)","v":0},null,null,"m2",{"$f":"Q19*F19","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B19)","v":0},null,{"$f":"IF(U19<>\"-\",U19*S19,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B21)","v":0},null,null,"m2",{"$f":"Q21*F21","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B21)","v":0},null,{"$f":"IF(U21<>\"-\",U21*S21,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B23)","v":0},null,null,"m2",{"$f":"Q23*F23","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B23)","v":0},null,{"$f":"IF(U23<>\"-\",U23*S23,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B25)","v":0},null,null,"m2",{"$f":"Q25*F25","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B25)","v":0},null,{"$f":"IF(U25<>\"-\",U25*S25,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B27)","v":0},null,null,"m2",{"$f":"Q27*F27","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B27)","v":0},null,{"$f":"IF(U27<>\"-\",U27*S27,0)","v":0}]
[]
[null,null,"Presupuesto de ejecución material PEM",null,null,null,null,null,null,"=",null,null,"€",{"$f":"IF(S29=\"-\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,{"$f":"IF(K29=0,0,0.5+(6*((MODULO/K29)^0.2)))","v":0},{"$f":"IF(B31>=2.5,2.5,B31)","v":0},null,null,{"$f":"IF(K29=0,0,CONCATENATE(ROUND(K29/S31,2),\" €/m2   \",ROUND((K29/S31)*166.386,0),\" pts/m2\"))","v":0},null,null,null,null,{"$f":"IF(S31<=300,11.75,IF(S31<=400,11.5,IF(S31<=600,10.8,IF(S31<=800,11.3,IF(S31<=1000,10,IF(S31<=2000,9,L31))))))","v":11.75},{"$f":"IF(S31<=3000,8.6,IF(S31<=5000,8,IF(S31<=8000,7.5,IF(S31<=12000,7.1,IF(S31<=20000,6.7,IF(S31<=35000,6.2,M31))))))","v":8.6},{"$f":"IF(S31<=80000,5.7,IF(S31<=120000,5.4,IF(S31<=200000,5.2,IF(S31<=400000,4.8,IF(S31<=700000,4.6,IF(S31<=1000000,4.45,4.45))))))","v":5.7},null,null,null,"Σ Si","=",{"$f":"SUM(S27,S25,S23,S21,S19,S17,S15,S13,S11,S9)","v":0},"m2",null,null,{"$f":"SUM(W9,W11,W13,W15,W17,W19,W21,W23,W25,W27)","v":0}]
[]
[null,{"$f":"IF(K36=0,0,K36*K29*C31/1000)","v":0},null,null,"coeficiente por superficie construida ",null,null,null,null,"=",{"$f":"IF(S31<>0,M33,\"\")","v":""},{"$f":"IF(S31<>0,(2.6+10.2*((200/S31)^0.2)),0)","v":0},{"$f":"IF(L33>11.75,11.75,IF(L33<4.457,4.45,L33))","v":4.45},null,null,null,"Σ Si . Qv","=",{"$f":"W31","v":0}]
[]
[null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Coeficiente de FASE",null,null,{"$f":"'2.1.1B'!$G$13","v":0}]
[null,null,null,null,null,null,null,null,null,"="]
[]
[null,{"$f":"MODULO*K33*S33*K36/6000","v":{"$error":"#VALUE!"}},{"$f":"MODULO/40","v":13.469749999999999},null,null,{"$f":"IF(B33<B38,B38,B33)","v":{"$error":"#VALUE!"}},null,"Calculo",null,"=",{"$f":"IF(F38>MODULO/40,F38,MODULO/40)","v":{"$error":"#VALUE!"}},{"$f":"IF(B33<B38,\"Calculo según Obra nueva\",\" \")","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(ROUND(K38*1.16,2),\" € c/IVA\")","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,"El cliente desea que la cuota variable de intervención por visado le sea facturada a su nombre"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Arquitecto","Cliente"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"K38/3","v":{"$error":"#VALUE!"}},{"$f":"K38*2/3","v":{"$error":"#VALUE!"}}]

{"sheet":"2.5.2C","index":20,"n_rows":43,"n_cols":23,"rows_kept":43,"cut":false,"hidden":true,"merged":[[0,2,0,21],[1,2,1,21],[4,2,4,10],[6,5,7,5],[6,14,7,14],[6,18,7,18],[28,2,28,8],[34,7,35,8],[37,7,37,8],[39,7,40,12],[32,4,32,8],[30,5,30,8],[28,10,28,11]]}
[{"$f":"'1'!$N$17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[false,null,"2.5.2 DECORACIÓN O ACABADO DE LOCALES"]
[]
[null,null,"Se calcula mediante una de las siguientes fórmula:"]
[null,null,"CV = Módulo · C · [Σ.Si · Qv] · F / 6000 ó CP · PEM · F / 1000"]
[]
[null,null,"Plantas",null,null,"Num. Plantas",null,null,null,null,null,null,null,null,"Codigo del Uso",null,"Sup. Planta",null,"Total m2            Uso",null,"Qv"]
[null,null,"de","A"]
[null,1,null,null,null,null,null,null,{"$f":"INDEX(USOS!$C$1:$C$65,$B9)","v":0},null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B9)","v":0},null,null,"m2",{"$f":"Q9*F9","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B9)","v":0},null,{"$f":"IF(U9<>\"-\",U9*S9,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B11)","v":0},null,null,"m2",{"$f":"Q11*F11","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B11)","v":0},null,{"$f":"IF(U11<>\"-\",U11*S11,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B13)","v":0},null,null,"m2",{"$f":"Q13*F13","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B13)","v":0},null,{"$f":"IF(U13<>\"-\",U13*S13,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B15)","v":0},null,null,"m2",{"$f":"Q15*F15","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B15)","v":0},null,{"$f":"IF(U15<>\"-\",U15*S15,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B17)","v":0},null,null,"m2",{"$f":"Q17*F17","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B17)","v":0},null,{"$f":"IF(U17<>\"-\",U17*S17,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B19)","v":0},null,null,"m2",{"$f":"Q19*F19","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B19)","v":0},null,{"$f":"IF(U19<>\"-\",U19*S19,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B21)","v":0},null,null,"m2",{"$f":"Q21*F21","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B21)","v":0},null,{"$f":"IF(U21<>\"-\",U21*S21,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B23)","v":0},null,null,"m2",{"$f":"Q23*F23","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B23)","v":0},null,{"$f":"IF(U23<>\"-\",U23*S23,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B25)","v":0},null,null,"m2",{"$f":"Q25*F25","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B25)","v":0},null,{"$f":"IF(U25<>\"-\",U25*S25,0)","v":0}]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(USOS!$B$1:$B$68,$B27)","v":0},null,null,"m2",{"$f":"Q27*F27","v":0},"m2",{"$f":"INDEX(USOS!$C$1:$C$68,$B27)","v":0},null,{"$f":"IF(U27<>\"-\",U27*S27,0)","v":0}]
[]
[null,null,"Presupuesto de ejecución material PEM",null,null,null,null,null,null,"=",null,null,"€",{"$f":"IF(S29=\"-\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,{"$f":"IF(K29=0,0,0.5+(6*((MODULO/K29)^0.2)))","v":0},{"$f":"IF(B31>=2.5,2.5,B31)","v":0},null,null,{"$f":"IF(K29=0,0,CONCATENATE(ROUND(K29/S31,2),\" €/m2   \",ROUND((K29/S31)*166.386,0),\" pts/m2\"))","v":0},null,null,null,null,{"$f":"IF(S31<=300,11.75,IF(S31<=400,11.5,IF(S31<=600,10.8,IF(S31<=800,11.3,IF(S31<=1000,10,IF(S31<=2000,9,L31))))))","v":11.75},{"$f":"IF(S31<=3000,8.6,IF(S31<=5000,8,IF(S31<=8000,7.5,IF(S31<=12000,7.1,IF(S31<=20000,6.7,IF(S31<=35000,6.2,M31))))))","v":8.6},{"$f":"IF(S31<=80000,5.7,IF(S31<=120000,5.4,IF(S31<=200000,5.2,IF(S31<=400000,4.8,IF(S31<=700000,4.6,IF(S31<=1000000,4.45,4.45))))))","v":5.7},null,null,null,"Σ Si","=",{"$f":"SUM(S27,S25,S23,S21,S19,S17,S15,S13,S11,S9)","v":0},"m2",null,null,{"$f":"SUM(W9,W11,W13,W15,W17,W19,W21,W23,W25,W27)","v":0}]
[]
[null,{"$f":"IF(K36=0,0,K36*K29*C31/1000)","v":0},null,null,"coeficiente por superficie construida ",null,null,null,null,"=",{"$f":"IF(S31<>0,M33,\"\")","v":""},{"$f":"IF(S31<>0,(2.6+10.2*((200/S31)^0.2)),0)","v":0},{"$f":"IF(L33>11.75,11.75,IF(L33<4.457,4.45,L33))","v":4.45},null,null,null,"Σ Si . Qv","=",{"$f":"W31","v":0}]
[]
[null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Coeficiente de FASE",null,null,{"$f":"'2.1.1B'!$G$13","v":0}]
[null,null,null,null,null,null,null,null,null,"="]
[]
[null,{"$f":"MODULO*K33*S33*K36/6000","v":{"$error":"#VALUE!"}},{"$f":"MODULO/40","v":13.469749999999999},null,null,{"$f":"IF(B33<B38,B38,B33)","v":{"$error":"#VALUE!"}},null,"Calculo",null,"=",{"$f":"IF(F38>MODULO/40,F38,MODULO/40)","v":{"$error":"#VALUE!"}},{"$f":"IF(B33<B38,\"Calculo según Obra nueva\",\" \")","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(ROUND(K38*1.16,2),\" € c/IVA\")","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,"El cliente desea que la cuota variable de intervención por visado le sea facturada a su nombre"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Arquitecto","Cliente"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"K38/3","v":{"$error":"#VALUE!"}},{"$f":"K38*2/3","v":{"$error":"#VALUE!"}}]

{"sheet":"2.5.2D","index":21,"n_rows":18,"n_cols":19,"rows_kept":18,"cut":false,"hidden":true,"merged":[[1,2,1,5],[13,2,14,4],[0,2,0,5],[2,2,3,2]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[false,null,"2.5.2 Decoración o acabado de locales"]
[null,null,"Presupuesto de ejecución material \nde la obra       (PEM) ="]
[null,null,null,null,"€"]
[]
[{"$f":"IF(D4=0,0,0.5+(6*((MODULO/D4)^0.2)))","v":0},null,"Coeficiente CP =",{"$f":"IF(A6>=2.5,2.5,A6)","v":0}]
[]
[null,null,"Coeficiente de FASE",{"$f":"'2.1.1B'!$G$13","v":0},null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[]
[null,{"$f":"D9*D4*D6/1000","v":0},"Calculo",{"$f":"IF(B12>MODULO/40,B12,IF(D9=0,0,MODULO/40))","v":0},null,null,null,null,null,null,null,null,null,null,false,false,false,false,false]
[null,null,null,{"$f":"CONCATENATE(ROUND(D12*1.16,2),\" € c/IVA\")","v":"0 € c/IVA"},null,null,null,null,null,null,null,null,null,null,null,false,null,null,false]
[null,null,"El cliente desea que la cuota variable de intervención por visado le sea facturada a su nombre",null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,false]
[]
[]
[null,null,null,"Arquitecto","Cliente"]
[null,null,null,{"$f":"D12/3","v":0},{"$f":"D12*2/3","v":0}]

{"sheet":"3.1.1A","index":22,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":true,"merged":[[1,2,1,5],[27,2,28,4],[3,2,4,2],[8,2,9,2],[11,2,11,4],[22,2,23,2]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,false]
[false,null,"3.1.1 PLANES GENERALES DE ORDENACIÓN URBANA (PGOU)",null,null,null,null,26]
[false,null,null,null,null,null,null,205]
[null,null,"Superficie total del Término Municipal",null,null,null,null,0.1]
[null,null,null,null,"Hectareas",null,null,{"$f":"B26","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(H5*H4<H2,H2,IF(H5*H4>H3,H3,H5*H4))","v":26}]
[null,null,"Población",null,null,null,null,{"$f":"IF(H1=TRUE,B26+H6,B26)","v":0}]
[]
[null,null,"residentes Término Municipal"]
[null,null,null,null,"habitantes"]
[]
[null,null,"     Presencía turística significativa"]
[]
[null,null,null,null,"nº viviendas"]
[]
[null,null,null,null,"nº plazas hoteleras"]
[]
[null,null,"Población   ",{"$f":"IF(A3=FALSE,D10,D14*3+0.5*D16)","v":0},"habitantes"]
[]
[{"$f":"IF(D18=0,0,0.008+(0.08*(1000/D18)^0.5))","v":0},null,"Coeficiente P  ",{"$f":"IF(A20>0.045,0.045,A20)","v":0},{"$f":"IF(D20=0.045,\" Valor máximo\",\"\")","v":""}]
[]
[null,null,"Coeficiente de fase",null,{"$f":"'3.1.7'!F20","v":"----------"}]
[null,null,"Coeficiente de fase =",{"$f":"'3.1.7'!G19","v":0}]
[]
[]
[null,{"$f":"D24*MODULO*((0.1*D5)+(D18*D20))/50","v":0},"Calculo",{"$f":"H7","v":0}]
[null,null,null,{"$f":"CONCATENATE(ROUND(D26*IVA,2),\" € c/IVA\")","v":"0 € c/IVA"}]
[null,null,"URGENTE O RAPIDO"]

{"sheet":"3.1.1B","index":23,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":true,"merged":[[1,2,1,5],[27,2,28,4],[3,2,4,2],[8,2,9,2],[11,2,11,4],[22,2,23,2]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,false]
[false,null,"3.1.1 NORMAS SUBSIDIARIAS (NNSS)",null,null,null,null,26]
[false,null,null,null,null,null,null,205]
[null,null,"Superficie total del Término Municipal",null,null,null,null,0.1]
[null,null,null,null,"hectareas",null,null,{"$f":"B26","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(H5*H4<H2,H2,IF(H5*H4>H3,H3,H5*H4))","v":26}]
[null,null,"Población",null,null,null,null,{"$f":"IF(H1=TRUE,B26+H6,B26)","v":0}]
[]
[null,null,"residentes Término Municipal"]
[null,null,null,null,"habitantes"]
[]
[null,null,"     Presencía turística significativa"]
[]
[null,null,null,null,"nº viviendas"]
[]
[null,null,null,null,"nº plazas hoteleras"]
[]
[null,null,"Población   ",{"$f":"IF(A3=FALSE,D10,D14*3+0.5*D16)","v":0},"habitantes"]
[]
[{"$f":"IF(D18=0,0,0.003+(0.03*(1000/D18)^0.5))","v":0},null,"Coeficiente P  ",{"$f":"IF(A20>0.02,0.02,A20)","v":0},{"$f":"IF(D20=0.02,\" Valor máximo\",\"\")","v":""}]
[]
[null,null,"Coeficiente de fase",null,{"$f":"'3.1.7'!F20","v":"----------"}]
[null,null,"Coeficiente de fase =",{"$f":"'3.1.7'!G19","v":0}]
[]
[]
[null,{"$f":"D24*MODULO*((0.1*D5)+(D18*D20))/50","v":0},"Calculo",{"$f":"H7","v":0}]
[]
[null,null,"URGENTE O RAPIDO"]

{"sheet":"3.1.1C","index":24,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":true,"merged":[[1,2,1,5],[27,2,28,4],[3,2,4,2],[8,2,9,2],[11,2,11,4],[22,2,23,2]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,false]
[false,null,"3.1.1 PROYECTOS DE DELIMITACIÓN DE SUELO URBANO (PDSU)",null,null,null,null,26]
[false,null,null,null,null,null,null,205]
[null,null,"Superficie de suelo urbano delimitado",null,null,null,null,0.1]
[null,null,null,null,"hectareas",null,null,{"$f":"B26","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(H5*H4<H2,H2,IF(H5*H4>H3,H3,H5*H4))","v":26}]
[null,null,"Población",null,null,null,null,{"$f":"IF(H1=TRUE,B26+H6,B26)","v":0}]
[]
[null,null,"residentes Término Municipal"]
[null,null,null,null,"habitantes"]
[]
[null,null,"     Presencía turística significativa"]
[]
[null,null,null,null,"nº viviendas"]
[]
[null,null,null,null,"nº plazas hoteleras"]
[]
[null,null,"Población   ",{"$f":"IF(A3=FALSE,D10,D14*3+0.5*D16)","v":0},"habitantes"]
[]
[{"$f":"IF(D18=0,0,0.003+(0.015*(1000/D18)^0.5))","v":0},null,"Coeficiente P  ",{"$f":"IF(A20>0.015,0.045,A20)","v":0},{"$f":"IF(D20=0.015,\" Valor máximo\",\"\")","v":""}]
[]
[null,null,"Coeficiente de fase",null,{"$f":"'3.1.7'!F20","v":"----------"}]
[null,null,"Coeficiente de fase =",{"$f":"'3.1.7'!G19","v":0}]
[]
[]
[null,{"$f":"D24*MODULO*((0.1*D5)+(D18*D20))/50","v":0},"Calculo",{"$f":"H7","v":0}]
[]
[null,null,"URGENTE O RAPIDO"]

{"sheet":"3.1.1D","index":25,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":true,"merged":[[1,2,1,5],[27,2,28,4],[3,2,4,2],[8,2,9,2],[11,2,11,4],[22,2,23,2]]}
[400,"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,"Seleccione planeamiento…",0,0]
[false,null,"3.1.9 ESTUDIO Y ANÁLISIS AMBIENTAL (ambito municipal)",null,null,null,null,"PLANES GENERALES DE ORDENACIÓN URBANA (PGOU)",{"$f":"IF($D$18>0,0.008+(0.08*(1000/$D$18)^0.5),0)","v":0},{"$f":"IF( I2>0.045,0.045,I2)","v":0}]
[false,null,null,null,null,null,null,"NORMAS SUBSIDIARIAS (NN.SS.)",{"$f":"IF($D$18>0,0.003+(0.03*(1000/$D$18)^0.5),0)","v":0},{"$f":"IF( I3>0.02,0.02,I3)","v":0}]
[null,null,"Superficie total del Término Municipal",null,null,null,null,"PROYECTOS DE DELIMITACIÓN DE SUELO URBANO (PDSU)",{"$f":"IF($D$18>0,0.003+(0.015*(1000/$D$18)^0.5),0)","v":0},{"$f":"IF( I4>0.015,0.015,I4)","v":0}]
[null,null,null,null,"Hectareas"]
[]
[null,null,"Población"]
[]
[null,null,"residentes Término Municipal"]
[null,null,null,null,"habitantes"]
[]
[null,null,"     Presencía turística significativa"]
[]
[null,null,null,null,"nº viviendas"]
[]
[null,null,null,null,"nº plazas hoteleras"]
[]
[null,null,"Población   ",{"$f":"IF(A3=FALSE,D10,D14*3+0.5*D16)","v":0},"habitantes"]
[1,"è"]
[{"$f":"IF(D18=0,0,0.008+(0.08*(1000/D18)^0.5))","v":0},null,"Coeficiente Pp =",{"$f":"INDEX(J1:J4,A19)","v":0}]
[]
[null,null,"Coeficiente de fase",null,{"$f":"TABLAU3!F12","v":"----"}]
[null,null,"Coeficiente de fase =",{"$f":"TABLAU3!G11","v":0}]
[]
[false,null,null,null,null,null,{"$f":"IF(A25=TRUE,1.3,1)","v":1}]
[null,null,"Calculo",{"$f":"(D24*MODULO*((0.1*D5)+(D18*D20))/50)*0.05*G25","v":0}]
[null,null,null,{"$f":"CONCATENATE(ROUND(D26*1.16,2),\" € c/IVA\")","v":"0 € c/IVA"}]
[null,null,"El cliente desea que la cuota variable de intervención por visado le sea facturada a su nombre"]
[]
[]
[null,null,null,"Arquitecto","Cliente"]
[null,null,null,{"$f":"D26/3","v":0},{"$f":"D26*2/3","v":0}]

{"sheet":"3.1.1E","index":26,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":true,"merged":[[1,2,1,5],[31,2,32,4],[3,2,4,2],[8,2,9,2],[11,2,11,4],[22,2,23,2],[24,2,25,2]]}
[400,"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,"Seleccione planeamiento…",0,0]
[false,null,"3.1.9 ESTUDIO Y ANÁLISIS AMBIENTAL (ambito submunicipal)",null,null,null,null,"PLANES GENERALES DE ORDENACIÓN URBANA (PGOU)",{"$f":"IF($D$18>0,0.008+(0.08*(1000/$D$18)^0.5),0)","v":0},{"$f":"IF( I2>0.045,0.045,I2)","v":0}]
[false,null,null,null,null,null,null,"NORMAS SUBSIDIARIAS (NN.SS.)",{"$f":"IF($D$18>0,0.003+(0.03*(1000/$D$18)^0.5),0)","v":0},{"$f":"IF( I3>0.02,0.02,I3)","v":0}]
[null,null,"Superficie total del Término Municipal",null,null,null,null,"PROYECTOS DE DELIMITACIÓN DE SUELO URBANO (PDSU)",{"$f":"IF($D$18>0,0.003+(0.015*(1000/$D$18)^0.5),0)","v":0},{"$f":"IF( I4>0.015,0.015,I4)","v":0}]
[null,null,null,null,"Hectareas"]
[]
[null,null,"Población"]
[]
[null,null,"residentes Término Municipal"]
[null,null,null,null,"habitantes"]
[]
[null,null,"     Presencía turística significativa"]
[]
[null,null,null,null,"nº viviendas"]
[]
[null,null,null,null,"nº plazas hoteleras"]
[]
[null,null,"Población   ",{"$f":"IF(A3=FALSE,D10,D14*3+0.5*D16)","v":0},"habitantes"]
[1,"è"]
[{"$f":"IF(D18=0,0,0.008+(0.08*(1000/D18)^0.5))","v":0},null,"Coeficiente Pp =",{"$f":"INDEX(J1:J4,A19)","v":0}]
[]
[null,null,"Coeficiente de fase",null,{"$f":"TABLAU3!F12","v":"----"}]
[null,null,"Coeficiente de fase =",{"$f":"TABLAU3!G11","v":0}]
[]
[null,null,"Suelo municipal incluido en el ambito"]
[null,null,null,null,"Hectareas"]
[]
[null,null,null,{"$f":"IF(D5>0,D26/D5,0)","v":0},"Porcentaje"]
[false,null,null,null,null,null,{"$f":"IF(A29=TRUE,1.3,1)","v":1}]
[null,null,"Calculo",{"$f":"(D24*MODULO*((0.1*D5)+(D18*D20))/50)*0.05*G29*D28","v":0}]
[null,null,null,{"$f":"CONCATENATE(ROUND(D30*1.16,2),\" € c/IVA\")","v":"0 € c/IVA"}]
[null,null,"El cliente desea que la cuota variable de intervención por visado le sea facturada a su nombre"]
[]
[]
[null,null,null,"Arquitecto","Cliente"]
[null,null,null,{"$f":"D30/3","v":0},{"$f":"D30*2/3","v":0}]

{"sheet":"3.1.2","index":27,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,2,1,5],[0,2,0,5],[3,2,5,5]]}
[400,"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[null,null,"3.1.2 PLANES ESPECIALES SECTORIALES"]
[]
[null,null,"La cuota para Planes Especiales Sectoriales se calcula en función de su naturaleza por analogía con otras figuras de planeamiento, desarrollo de planeamiento y/o proyectos de urbanización."]
[]
[]
[]
[]
[]
[null,null,null,"Arquitecto","Cliente"]
[null,null,null,{"$f":"D5/3","v":0},{"$f":"D5*2/3","v":0}]

{"sheet":"3.1.3","index":28,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":true,"merged":[[27,2,28,4],[0,2,0,6],[1,2,1,6],[3,2,4,2],[19,2,20,2],[2,2,2,6]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,false]
[false,null,"3.1.3 PLANES DE SECTORIZACIÓN Y PROGRAMAS DE ACTUACIÓN URBANÍSTICA",null,null,null,null,26]
[null,null,"Calculo plan parcial",null,null,null,null,205]
[null,null,"Superficie total ordenada",null,null,null,null,0.1]
[null,null,null,null,null,"Hectareas",null,{"$f":"B25","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(H5*H4<H2,H2,IF(H5*H4>H3,H3,H5*H4))","v":26}]
[null,null,null,null,null,null,null,{"$f":"IF(H1=TRUE,B26+H6,B26)","v":0}]
[]
[{"$f":"E5","v":0},null,null,null,null,null,null,{"$f":"IF(H5*H4<H2,H2,IF(H5*H4>H3,H3,H5*H4))","v":26}]
[{"$f":"IF(A9=0,0,2+30*(1/A9)^0.4)","v":0},null,"Coeficiente Ss  ",null,{"$f":"IF(A10>15,15,A10)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(H1=TRUE,B25+H9,B25)","v":0}]
[]
[{"$f":"IF(E12=0,0,0.075+2*(1/E12)^0.4)","v":0}]
[]
[]
[1]
[]
[]
[null,null,"Coeficiente de fase",null,null,{"$f":"'3.1.7'!F20","v":"----------"}]
[null,null,"Coeficiente de fase",null,{"$f":"'3.1.7'!G19","v":0}]
[null,null,null,"="]
[]
[{"$f":"INDEX(#REF!,A16)","v":{"$error":"#REF!"}}]
[null,null,"Plan Parcial","¡=",{"$f":"IF(E21=0,0,A26)","v":0}]
[{"$f":"IF(E21>0,E21*MODULO*E5*E10/50,0)","v":0},{"$f":"E24*0.25","v":0},"Calculo",null,{"$f":"H11","v":0}]
[{"$f":"IF(A25<MODULO/10,MODULO/10,A25)","v":53.878999999999998},null,null,null,{"$f":"CONCATENATE(ROUND(E25*1.16,2),\" € C/IVA\")","v":"0 € C/IVA"}]
[]
[null,null,"URGENTE O RAPIDO"]

{"sheet":"3.1.4","index":29,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":true,"merged":[[1,2,1,6],[24,2,25,5],[3,2,4,2],[19,2,20,2],[26,2,27,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,false]
[false,null,"3.1.4 PLANES PARCIALES",null,null,null,null,26]
[null,null,null,null,null,null,null,205]
[null,null,"Superficie total ordenada",null,null,null,null,0.1]
[null,null,null,null,null,"Hectareas",null,{"$f":"B25","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(H5*H4<H2,H2,IF(H5*H4>H3,H3,H5*H4))","v":26}]
[null,null,null,null,null,null,null,{"$f":"IF(H1=TRUE,B26+H6,B26)","v":0}]
[]
[{"$f":"E5","v":0}]
[{"$f":"IF(A9=0,0,2+30*(1/A9)^0.4)","v":0},null,"Coeficiente Ss  ",null,{"$f":"IF(A10>15,15,A10)","v":0},null,null,{"$f":"IF(H1=TRUE,B25+H6,B25)","v":0}]
[]
[]
[{"$f":"IF(E12=0,0,(0.075+2*((1/E12)^0.4)))","v":0}]
[]
[]
[1]
[]
[]
[null,null,"Coeficiente de fase",null,null,{"$f":"'3.1.7'!F20","v":"----------"}]
[null,null,"Coeficiente de fase",null,{"$f":"'3.1.7'!G19","v":0}]
[null,null,null,"="]
[]
[{"$f":"IF(E21>0,E21*MODULO*E5*E10/50,0)","v":0},null,"Calculo",null,{"$f":"H10","v":0}]
[{"$f":"IF(A23<MODULO/10,MODULO/10,A23)","v":53.878999999999998},null,null,null,{"$f":"CONCATENATE(ROUND(E23*1.16,2),\" € C/IVA\")","v":"0 € C/IVA"}]
[null,{"$f":"IF(E21=0,0,A24)","v":0}]
[]
[null,null,"URGENTE O RAPIDO"]

{"sheet":"3.1.5","index":30,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":true,"merged":[[27,2,28,4],[0,2,0,6],[1,2,1,6],[3,2,4,2],[19,2,20,2],[2,2,2,6]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,false]
[false,null,"3.1.5 PLANES ESPECIALES DE REFORMA INTERIOR",null,null,null,null,26]
[null,null,"Calculo plan parcial",null,null,null,null,205]
[null,null,"Superficie total ordenada",null,null,null,null,0.1]
[null,null,null,null,null,"Hectareas",null,{"$f":"A25","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(H5*H4<H2,H2,IF(H5*H4>H3,H3,H5*H4))","v":26}]
[null,null,null,null,null,null,null,{"$f":"IF(H1=TRUE,B26+H6,B26)","v":0}]
[]
[{"$f":"E5","v":0}]
[{"$f":"IF(A9=0,0,2+30*(1/A9)^0.4)","v":0},null,"Coeficiente Ss  ",null,{"$f":"IF(A10>15,15,A10)","v":0}]
[]
[]
[{"$f":"IF(E12=0,0,0.075+2*(1/E12)^0.4)","v":0}]
[null,null,null,null,null,null,null,true]
[null,null,null,null,null,null,null,25]
[1,null,null,null,null,null,null,200]
[null,null,null,null,null,null,null,0.1]
[null,null,null,null,null,null,null,{"$f":"B39","v":0}]
[null,null,"Coeficiente de fase",null,null,{"$f":"'3.1.7'!F20","v":"----------"},null,{"$f":"IF(H5*H4<H2,H2,IF(H5*H4>H3,H3,H5*H4))","v":26}]
[null,null,"Coeficiente de fase",null,{"$f":"'3.1.7'!G19","v":0},null,null,{"$f":"IF(H1=TRUE,A25+H19,A25)","v":0}]
[null,null,null,"="]
[]
[{"$f":"INDEX(#REF!,A16)","v":{"$error":"#REF!"}}]
[null,null,"Plan Parcial","¡=",{"$f":"IF(E21=0,0,A26)","v":0}]
[{"$f":"IF(E21>0,E21*MODULO*E5*E10/30,0)","v":0},null,"Calculo",null,{"$f":"H20","v":0}]
[{"$f":"IF(A25<MODULO/10,MODULO/10,A25)","v":53.878999999999998},null,null,null,{"$f":"CONCATENATE(ROUND(E25*1.16,2),\" € C/IVA\")","v":"0 € C/IVA"}]
[]
[null,null,"URGENTE O RAPIDO"]

{"sheet":"3.1.6","index":31,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":true,"merged":[[1,2,1,6],[3,2,4,2],[19,2,20,2],[2,2,2,6],[26,2,27,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,false]
[false,null,"3.1.6 ESTUDIOS DE DETALLE",null,null,null,null,26]
[null,null,"Calculo plan parcial",null,null,null,null,205]
[null,null,"Superficie total ordenada",null,null,null,null,true,0.75,{"$f":"IF(H4=TRUE,I4,0)","v":0.75}]
[null,null,null,null,null,"Hectareas",null,false,0.25,{"$f":"IF(H5=TRUE,I5,0)","v":0},{"$f":"SUM(J4:J5)","v":0.75}]
[]
[]
[]
[{"$f":"E5","v":0}]
[{"$f":"IF(A9=0,0,2+30*(1/A9)^0.4)","v":0},null,"Coeficiente Ss  ",null,{"$f":"IF(A10>15,15,A10)","v":0},null,null,0.1]
[]
[]
[{"$f":"IF(E12=0,0,0.075+2*(1/E12)^0.4)","v":0}]
[null,null,null,null,{"$f":"IF(A13=0,0,A13)","v":0}]
[]
[1]
[]
[null,null,null,null,{"$f":"A23","v":0}]
[null,null,"Coeficiente de fase",null,null,{"$f":"'3.1.7'!F20","v":"----------"},null,{"$f":"B24","v":40}]
[null,null,"Coeficiente de fase",null,{"$f":"'3.1.7'!G19","v":0},null,null,{"$f":"IF(H19*H4<H2,H2,IF(H19*H4>H3,H3,H19*H4))","v":40}]
[null,null,null,"=",null,null,null,{"$f":"IF(H1=TRUE,B24+H20,B24)","v":40}]
[]
[null,null,"Plan PARCIAL","=",{"$f":"IF(E21=0,0,A25)","v":0}]
[{"$f":"IF(E21>0,E21*MODULO*E5*E10/50,0)","v":0},{"$f":"IF(E23*K5<40,40,E23*K5)","v":40},"Calculo",null,{"$f":"H21","v":40}]
[{"$f":"IF(A24<MODULO/10,MODULO/10,A24)","v":53.878999999999998},null,null,null,{"$f":"CONCATENATE(ROUND(E24*1.16,2),\" € c/IVA\")","v":"46,4 € c/IVA"}]
[]
[null,null,"URGENTE O RAPIDO"]

{"sheet":"3.1.7","index":32,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":true,"merged":[[15,3,15,5],[19,5,19,6],[10,3,10,5],[11,3,11,5],[12,3,12,5],[13,3,13,5],[0,2,0,12],[7,3,7,5],[8,3,8,5],[9,3,9,5],[14,3,14,5],[1,2,1,6],[3,2,3,6],[5,3,5,5],[6,3,6,5]]}
[null,"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[null,null,"3.1.7 MISIÓN COMPLETA Y MISIÓN PARCIAL: DESGLOSE POR FASES"]
[]
[null,null,"Cuando el trabajo se desarrolle por fases, la cuota de cada fase se calcula con los porcentajes de la tabla U2"]
[]
[null,null,null,"Fase",null,null,"   %"]
[null,null,null,"Memoria de información urbanística",null,null,0.08,null,false,0.08,{"$f":"IF(I7=TRUE,J7,0)","v":0},{"$f":"IF(I7=TRUE,\"a\",\"-\")","v":"-"}]
[null,null,null,"Planos de información urbanística",null,null,0.1,null,false,0.1,{"$f":"IF(I8=TRUE,J8,0)","v":0},{"$f":"IF(I8=TRUE,\"b\",\"-\")","v":"-"}]
[null,null,null,"Avance, memoria",null,null,0.1,null,false,0.1,0,{"$f":"IF(I9=TRUE,\"c\",\"-\")","v":"-"}]
[null,null,null,"Avance, planos",null,null,0.12,null,false,0.12,0,{"$f":"IF(I10=TRUE,\"d\",\"-\")","v":"-"}]
[null,null,null,"Documento de aprobación inicial, memoria",null,null,0.1,null,false,0.1,0,{"$f":"IF(I11=TRUE,\"e\",\"-\")","v":"-"}]
[null,null,null,"Documento de aprobación inicial, estudio de viabilidad",null,null,0.05,null,false,0.05,0,{"$f":"IF(I12=TRUE,\"f\",\"-\")","v":"-"}]
[null,null,null,"Documento de aprobación inicial, planos",null,null,0.2,null,false,0.2,0,{"$f":"IF(I13=TRUE,\"g\",\"-\")","v":"-"}]
[null,null,null,"Documento de aprobación inicial, normas urbanísticas",null,null,0.1,null,false,0.1,0,{"$f":"IF(I14=TRUE,\"h\",\"-\")","v":"-"}]
[null,null,null,"Informe de alegaciones",null,null,0.1,null,false,0.1,0,{"$f":"IF(I15=TRUE,\"i\",\"-\")","v":"-"}]
[null,null,null,"Documento de aprobación provisional",null,null,0.05,null,false,0.05,0,{"$f":"IF(I16=TRUE,\"j\",\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K7:K16)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"K17","v":0}]
[null,null,null,null,null,{"$f":"CONCATENATE(L7,L8,L9,L10,L11,L12,L13,L14,L15,L16)","v":"----------"}]

{"sheet":"3.1.8","index":33,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":true,"merged":[[1,2,1,5],[9,2,10,4],[11,2,12,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,false]
[false,null,"3.1.8 CATÁLOGOS DE BIENES Y ESPACIOS PROTEGIDOS",null,null,null,null,26]
[null,null,null,null,null,null,null,205]
[null,null,"Nº total edificios",null,"ud.",null,null,0.1]
[null,null,null,null,null,null,null,{"$f":"B8","v":0}]
[null,null,"Nº elem. catalogados",null,"ud.",null,null,{"$f":"IF(H5*H4<H2,H2,IF(H5*H4>H3,H3,H5*H4))","v":26}]
[null,null,null,null,null,null,null,{"$f":"IF(H1=TRUE,B8+H6,B8)","v":0}]
[null,{"$f":"(MODULO*(0.005*D4+0.6*D6))/50","v":0},"Calculo",{"$f":"H7","v":0}]
[null,null,null,{"$f":"CONCATENATE(ROUND(D8*1.16,2),\" € c/IVA\")","v":"0 € c/IVA"}]
[]
[]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"H6","v":26}]

{"sheet":"3.1.8B","index":34,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":true,"merged":[[27,2,28,4],[3,2,4,2],[8,2,9,2],[11,2,11,4],[22,2,23,2]]}
[400,"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[false,null,"3.1.8 CATÁLOGOS DE BIENES Y ESPACIOS PROTEGIDOS"]
[false]
[null,null,"Superficie total del Término Municipal"]
[null,null,null,null,"Hectareas"]
[]
[null,null,"Población"]
[]
[null,null,"residentes Término Municipal"]
[null,null,null,null,"habitantes"]
[]
[null,null,"     Presencía turística significativa"]
[]
[null,null,null,null,"nº viviendas"]
[]
[null,null,null,null,"nº plazas hoteleras"]
[]
[null,null,"Población   ",{"$f":"IF(A3=FALSE,D10,D14*3+0.5*D16)","v":0},"habitantes"]
[1]
[{"$f":"IF(D18=0,0,0.008+(0.08*(1000/D18)^0.5))","v":0},{"$f":"IF(A20>0.045,0.045,A20)","v":0},"Coeficiente P  ",{"$f":"IF(A19=1,B20,B21)","v":0},{"$f":"IF(D20=0.045,\" Valor máximo\",\"\")","v":""}]
[{"$f":"IF(D18=0,0,0.003+(0.03*(1000/D18)^0.5))","v":0},{"$f":"IF(A20>0.02,0.02,A20)","v":0}]
[null,null,"Coeficiente de fase",null,{"$f":"'3.1.7'!F20","v":"----------"}]
[null,null,"Coeficiente de fase =",{"$f":"'3.1.7'!G19","v":0}]
[]
[null,null,{"$f":"IF(A19=1,\"Calculo del Plan General\",\"Calculo de la Norma Subsidiaria\")","v":"Calculo del Plan General"},{"$f":"D24*MODULO*((0.1*D5)+(D18*D20))/50","v":0}]
[null,null,"Calculo",{"$f":"MODULO*(D24*MODULO*((0.1*D5)+(D18*D20))/50)*0.03/50","v":0}]
[]
[null,null,"El cliente desea que la cuota variable de intervención por visado le sea facturada a su nombre"]
[]
[]
[null,null,null,"Arquitecto","Cliente"]
[null,null,null,{"$f":"D26/3","v":0},{"$f":"D26*2/3","v":0}]

{"sheet":"3.1.9","index":35,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":true,"merged":[[5,2,5,5],[1,2,1,5],[0,2,0,5],[3,2,3,5],[4,2,4,5],[2,2,2,5],[9,2,9,5],[6,2,8,2],[11,2,11,5],[17,3,17,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[6,3,6,5],[7,3,7,5],[8,3,8,5]]}
[400,"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[null,null,"3.1.9 ESTUDIO Y ANÁLISIS AMBIENTAL"]
[null,null,"La cuota se calcula en función de la superficie del ámbito:"]
[null,null,"• Ámbito municipal: 5% de la cuota de planeamiento general."]
[null,null,"• Ámbito sub-municipal, sobre suelo sectorizado, programado o urbano: 10% de la cuota del planeamiento de desarrollo o detalle."]
[null,null,"• Ámbito sub-municipal, sobre suelo no urbanizable, no sectorizado y/o urbanizable no programado; se calcula con el siguiente procedimiento:"]
[null,null,null,"− Se calcula el porcentaje de suelo municipal incluido en el ámbito"]
[null,null,null,"− Se aplica a la cuota de planeamiento general de todo el término"]
[null,null,null,"− Se utiliza como cuota el 5% del valor resultante."]
[null,null,"El desglose de los honorarios por fases, sería conforme a los porcentajes de la Tabla U3"]
[]
[null,null,"TABLA U3 ESTUDIOS Y ANÁLISIS AMBIENTALES: PORCENTAJES POR FASE"]
[]
[null,null,null,"Fase",null,"%"]
[null,null,null,"Estudio ambiental (información)",null,0.17499999999999999]
[null,null,null,"Análisis ambiental, previo (avance)",null,0.22500000000000001]
[null,null,null,"Análisis ambiental",null,0.45]
[null,null,null,"Análisis ambiental, definitivo (aprobación provisional)",null,0.15]

{"sheet":"3.1.9B","index":36,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":true,"merged":[[1,2,1,5],[2,2,2,5],[34,2,35,5],[3,2,4,2],[32,2,32,3]]}
[400,"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,null,"Seleccione tipo de planeamiento aplicable al ambito"]
[false,null,"3.1.9 ESTUDIO Y ANÁLISIS AMBIENTAL (ambito submunicipal)",null,null,null,null,null,"PLANES DE SECTORIZACION ",0.25]
[null,null,"Calculo del tipo de planeamiento aplicable al ambito",null,null,null,null,null,"PROGRAMAS DE ACTUACIÓN URBANISTICA",0.25]
[null,null,"Superficie total ordenada",null,null,null,null,null,"PLANES PARCIALES",1]
[null,null,null,"=",null,"Hectareas",null,null,"PLANES ESPECIALES DE REFORMA INTERIOR",1.5]
[]
[1,null,null,null,null,null,null,null,"Seleccione estudio…",0]
[null,null,null,null,null,null,null,null,"ESTUDIO Y ANÁLISIS AMBIENTAL",0.1]
[{"$f":"E5","v":0},null,null,null,null,null,null,null,"ESTUDIO DE IMPACTO MEDIO AMBIENTAL",0.13]
[{"$f":"IF(A9=0,0,2+30*(1/A9)^0.4)","v":0},null,"Coeficiente Ss  ","=",{"$f":"IF(A10>15,15,A10)","v":0}]
[null,null,null,null,null,null,null,null,"CERTIFICACIONES TÉCNICAS DE ÓRGANOS COMPETENTES",0.02]
[null,null,null,null,null,null,null,null,"ESTUDIO IMPACTO MEDIO AMBIENTAL (VER BOTON)",0]
[{"$f":"IF(E12=0,0,0.075+2*(1/E12)^0.4)","v":0},null,null,null,null,null,null,null,"ESTUDIO DE IMAPACTO ACÚSTICO",0.04]
[]
[]
[1]
[]
[]
[]
[]
[]
[]
[1,"è"]
[{"$f":"INDEX(#REF!,A16)","v":{"$error":"#REF!"}}]
[{"$f":"INDEX(J1:J5,A23)","v":0},null,"Calculo","=",{"$f":"A27","v":40}]
[{"$f":"1*MODULO*E5*E10/50*A25","v":0}]
[{"$f":"IF(A26<MODULO/10,MODULO/10,A26)","v":40},null,null,null,{"$f":"TABLAU3!G11","v":0},{"$f":"TABLAU3!F12","v":"----"}]
[null,null,"Coeficiente de fase","="]
[]
[{"$f":"0.004*E28","v":0},"è"]
[]
[]
[{"$f":"INDEX(J7:J13,A7)","v":0},null,"Calculo",null,{"$f":"E25*A33","v":0}]
[null,null,null,null,{"$f":"CONCATENATE(ROUND(E33*1.16,2),\" € c/IVA\")","v":"0 € c/IVA"}]
[null,null,"El cliente desea que la cuota variable de intervención por visado le sea facturada a su nombre"]
[]
[]
[null,null,null,null,"Arquitecto","Cliente"]
[null,null,null,null,{"$f":"E33/3","v":0},{"$f":"E33*2/3","v":0}]

{"sheet":"3.1.9C","index":37,"n_rows":16,"n_cols":19,"rows_kept":16,"cut":false,"hidden":true,"merged":[[1,2,1,5],[0,2,0,5],[14,2,15,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,false]
[false,null,"3.1.9 ESTUDIO Y ANÁLISIS AMBIENTAL",null,null,null,26]
[null,null,null,null,null,null,205]
[null,null,"Superficie ordenada =",null,"Ha",null,0.1]
[null,null,null,null,null,null,{"$f":"B12","v":53.878999999999998}]
[{"$f":"IF(D4=0,0,2+(30*(1/D4)^0.4))","v":0},null,"Coeficiente Ss =",{"$f":"IF(A6>=2.5,2.5,A6)","v":0},null,null,{"$f":"IF(G5*G4<G2,G2,IF(G5*G4>G3,G3,G5*G4))","v":26}]
[null,null,"Coeficiente de FASE",null,{"$f":"TABLAU3!F12","v":"----"},null,{"$f":"IF(H1=TRUE,B12+G6,B12)","v":53.878999999999998}]
[null,null,null,{"$f":"TABLAU3!G11","v":0},null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[]
[{"$f":"IF(D9=0,0,MODULO*D9*D4*D6/500)","v":0},{"$f":"IF(A12<(MODULO/10),(MODULO/10),A12)","v":53.878999999999998},"Calculo",{"$f":"G7","v":53.878999999999998},null,null,null,null,null,null,null,null,null,null,false,false,false,false,false]
[null,null,null,{"$f":"CONCATENATE(ROUND(D12*IVA,2),\" € c/IVA\")","v":"65,19 € c/IVA"},null,null,null,null,null,null,null,null,null,null,null,false,null,null,false]
[]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"G6","v":26}]

{"sheet":"3.1.9D","index":38,"n_rows":15,"n_cols":19,"rows_kept":15,"cut":false,"hidden":true,"merged":[[1,2,1,5],[13,2,14,4],[0,2,0,5],[2,2,3,2]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,false]
[false,null,"3.1.10 ESTUDIO DE IMPACTO MEDIO AMBIENTAL",null,null,null,null,25]
[null,null,"Presupuesto de ejecución material \nde la obra       (PEM) =",null,null,null,null,200]
[null,null,null,null,"€",null,null,0.1]
[null,null,null,null,null,null,null,{"$f":"B12","v":0}]
[{"$f":"IF(D4=0,0,0.5+(6*((MODULO/D4)^0.2)))","v":0},null,"Coeficiente Ss =",{"$f":"IF(A6>=2.5,2.5,A6)","v":0},null,null,null,{"$f":"IF(H5*H4<H2,H2,IF(H5*H4>H3,H3,H5*H4))","v":25}]
[null,null,"Coeficiente de FASE",null,{"$f":"TABLAU3!F12","v":"----"},null,null,{"$f":"IF(H1=TRUE,B12+H6,B12)","v":0}]
[null,null,null,{"$f":"TABLAU3!G11","v":0},null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[]
[null,{"$f":"D9*D4*D6/500*1.3","v":0},"Calculo",{"$f":"H7","v":0},null,null,null,null,null,null,null,null,null,null,false,false,false,false,false]
[null,null,null,{"$f":"CONCATENATE(ROUND(D12*IVA,2),\" € c/IVA\")","v":"0 € c/IVA"}]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"H6","v":25}]

{"sheet":"3.1.10","index":39,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":true,"merged":[[3,2,4,2],[19,2,20,2],[32,2,32,3],[35,2,36,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,null,"Seleccione tipo de planeamiento aplicable al ambito"]
[false,null,"3.1.10 OTROS ESTUDIOS O TRABAJOS COMPLEM. DEL PLANEAMIENTO",null,null,null,null,null,"PLANES DE SECTORIZACION ",0.25]
[null,null,"Calculo del tipo de planeamiento de desarrollo o detalle aplicable al ambito",null,null,null,null,null,"PROGRAMAS DE ACTUACIÓN URBANISTICA",0.25]
[null,null,"Superficie total ordenada",null,null,null,null,null,"PLANES PARCIALES",1]
[null,null,null,"=",null,"Hectareas",null,null,"PLANES ESPECIALES DE REFORMA INTERIOR",{"$f":"50/30","v":1.6666666666666667}]
[]
[1,null,null,null,null,null,null,null,"Seleccione estudio o trabajo complementario",0]
[null,null,null,null,null,null,null,null,"INFORME DOCUMENTAL DE LA PROMOCION",2.5000000000000001E-2]
[{"$f":"E5","v":0},null,null,null,null,null,null,null,"ESTUDIO SOBRE CONDICIONES URBANÍSTICAS",1.4999999999999999E-2]
[{"$f":"IF(A9=0,0,2+30*(1/A9)^0.4)","v":0},null,"Coeficiente Ss  ","=",{"$f":"IF(A10>15,15,A10)","v":0},null,null,null,"ESTUDIO ORIENTATIVO DE MERCADO Y DE VIABILIDAD ECONÓMICA",0.02]
[null,null,null,null,null,null,null,null,"CERTIFICACIONES TÉCNICAS DE ÓRGANOS COMPETENTES",0.02]
[null,null,null,null,null,null,null,null,"ESTUDIO IMPACTO MEDIO AMBIENTAL (VER BOTON)",0]
[{"$f":"IF(E12=0,0,0.075+2*(1/E12)^0.4)","v":0},null,null,null,null,null,null,null,"ESTUDIO DE IMPACTO ACÚSTICO",0.04]
[]
[]
[1]
[]
[]
[null,null,null,null,null,{"$f":"'3.1.7'!F20","v":"----------"}]
[null,null,"Coeficiente de fase",null,{"$f":"'3.1.7'!G19","v":0},null,null,null,false]
[null,null,null,"=",1,null,null,null,26]
[null,null,null,null,null,null,null,null,205]
[1,"è",null,null,null,null,null,null,0.1]
[{"$f":"INDEX(#REF!,A16)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,{"$f":"A33*E25","v":0}]
[{"$f":"INDEX(J1:J5,A23)","v":0},null,"Calculo","=",{"$f":"IF(E21<>0,A27,0)","v":53.878999999999998},null,null,null,{"$f":"IF(I24*I23<I21,I21,IF(I24*I23>I22,I22,I24*I23))","v":26}]
[{"$f":"IF( E21>0,E21*MODULO*E5*E10/50*A25,0)","v":0},null,null,null,null,null,null,null,{"$f":"IF(I20=TRUE,I24+I25,I24)","v":0}]
[{"$f":"IF(A26<MODULO/10,MODULO/10,A26)","v":53.878999999999998}]
[]
[]
[{"$f":"0.004*E28","v":0},"è"]
[]
[]
[{"$f":"INDEX(J7:J13,A7)","v":0},null,"Calculo",null,{"$f":"I26","v":0}]
[null,null,null,null,{"$f":"CONCATENATE(ROUND(E33*IVA,2),\" € c/IVA\")","v":"0 € c/IVA"}]
[]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"I25","v":26}]

{"sheet":"3.1.10B","index":40,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":true,"merged":[[2,2,2,6],[1,2,1,6],[34,2,35,5],[19,2,20,2],[32,2,32,3]]}
[400,"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,null,"Seleccione tipo de planeamiento aplicable al ambito"]
[false,null,"3.1.10 OTROS ESTUDIOS O TRABAJOS COMPLEM. DEL PLANEAMIENTO",null,null,null,null,null,"PLANES DE SECTORIZACION ",0.25]
[null,null,"Calculo de la cuota correspondientea la gestión del planeamiento aplicable al ambito",null,null,null,null,null,"PROGRAMAS DE ACTUACIÓN URBANISTICA",0.25]
[null,null,null,null,null,null,null,null,"PLANES PARCIALES",1]
[null,null,null,null,null,null,null,null,"PLANES ESPECIALES DE REFORMA INTERIOR",{"$f":"50/30","v":1.6666666666666667}]
[]
[1,null,null,null,null,null,null,null,"Seleccione estudio o trabajo complementario",0]
[null,null,null,null,null,null,null,null,"INFORME DOCUMENTAL DE LA PROMOCION",2.5000000000000001E-2]
[{"$f":"E5","v":0},null,null,null,null,null,null,null,"ESTUDIO SOBRE CONDICIONES URBANÍSTICAS",1.4999999999999999E-2]
[{"$f":"IF(A9=0,0,2+30*(1/A9)^0.4)","v":0},null,null,null,null,null,null,null,"ESTUDIO ORIENTATIVO DE MERCADO Y DE VIABILIDAD ECONÓMICA",0.02]
[null,null,null,null,null,null,null,null,"CERTIFICACIONES TÉCNICAS DE ÓRGANOS COMPETENTES",0.02]
[null,null,null,null,null,null,null,null,"ESTUDIO IMPACTO MEDIO AMBIENTAL (VER BOTON)",0]
[{"$f":"IF(E12=0,0,0.075+2*(1/E12)^0.4)","v":0},null,null,null,null,null,null,null,"ESTUDIO DE IMPACTO ACÚSTICO",0.04]
[]
[]
[1]
[]
[]
[]
[]
[]
[]
[1]
[]
[{"$f":"INDEX(J1:J5,A23)","v":0}]
[{"$f":"IF( E21>0,E21*MODULO*E5*E10/50*A25,0)","v":0}]
[{"$f":"IF(A26<MODULO/10,MODULO/10,A26)","v":40}]
[]
[]
[{"$f":"0.004*E28","v":0}]
[]
[]
[{"$f":"INDEX(J7:J13,A7)","v":0}]
[]
[]
[]
[]
[null,null,null,null,"Arquitecto","Cliente"]
[null,null,null,null,{"$f":"E33/3","v":0},{"$f":"E33*2/3","v":0}]

{"sheet":"3.2.1","index":41,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":true,"merged":[[1,2,1,6],[12,2,13,2],[16,2,16,3],[2,2,2,5],[18,2,19,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,false,"Seleccione tipo de planeamiento aplicable al ambito",null,null,false]
[false,null,"3.2.1 PROYECTOS DE REPARCELACIÓN, COMPENSACIÓN, COOPERACIÓN Y EXPROPIACIÓN",null,null,null,null,null,"PLANES DE SECTORIZACION ",0.25,null,26]
[null,null,null,null,null,null,null,null,"PROGRAMAS DE ACTUACIÓN URBANISTICA",0.25,null,205]
[null,null,null,null,null,null,null,null,"PLANES PARCIALES",1,null,0.1]
[null,null,"Superficie total","=",null,"Hectareas",null,null,"PLANES ESPECIALES DE REFORMA INTERIOR",1.5,null,{"$f":"B17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L5*L4<L2,L2,IF(L5*L4>L3,L3,L5*L4))","v":26}]
[{"$f":"IF(E5>0,(2+(30*(1/E5)^0.4)),0)","v":0},null,"Coeficiente Ss ","=",{"$f":"IF(A7>15,15,A7)","v":0},null,null,null,null,null,null,{"$f":"IF(L1=TRUE,B17+L6,B17)","v":0}]
[]
[1]
[{"$f":"IF(E9=0,0,0.075+2*(1/E9)^0.4)","v":0}]
[{"$f":"IF(A9=1,0.25,0.3)","v":0.25},null,null,null,{"$f":"IF(A10=0,0,A10)","v":0}]
[null,null,null,null,null,{"$f":"TABLAU4!F12","v":"----"}]
[null,null,"Coeficiente de fase",null,{"$f":"TABLAU4!G11","v":0}]
[null,null,null,"="]
[]
[{"$f":"MODULO*A11*E5*E7/50","v":0}]
[{"$f":"IF(MODULO/40>A16,MODULO/40,A16)","v":13.469749999999999},{"$f":"IF(E14=0,0,IF(A18=FALSE,A17*E14,A17*E14*0.1))","v":0},"Calculo",null,{"$f":"L7","v":0}]
[false,null,null,null,{"$f":"CONCATENATE(ROUND(E17*IVA,2),\" € c/IVA\")","v":"0 € c/IVA"}]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"L6","v":26}]
[]
[]
[1]

{"sheet":"3.2.2","index":42,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":true,"merged":[[1,2,1,6],[3,2,4,2],[15,2,16,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,false]
[false,null,"3.2.2 PROYECTOS DE PARCELACIÓN",null,null,null,null,26]
[null,null,null,null,null,null,null,205]
[null,null,"Superficie total",null,null,null,null,0.1]
[null,null,null,null,null,"Hectareas",null,{"$f":"IF(B14<30,30,B14)","v":30}]
[null,null,null,null,null,null,null,{"$f":"IF(H5*H4<H2,H2,IF(H5*H4>H3,H3,H5*H4))","v":26}]
[null,null,null,null,null,null,null,{"$f":"IF(H1=TRUE,H5+H6,H5)","v":30},null,"según me ha dicho Lazaro tiene que ver con las fechas"]
[]
[{"$f":"E5","v":0}]
[{"$f":"IF(A9=0,0,(2+(30*(1/A9)^0.4)))","v":0},null,"Coeficiente Ss  ",null,{"$f":"IF(A10>15,15,A10)","v":0}]
[]
[]
[{"$f":"IF(E5>0,0.1*MODULO*E5*E10/50,0)","v":0},null,"Calculo",null,{"$f":"H7","v":30}]
[{"$f":"IF(A13<MODULO/40,MODULO/40,A13)","v":13.469749999999999},{"$f":"IF(A19=FALSE,A14,A14*0.1)","v":13.469749999999999},null,null,{"$f":"CONCATENATE(ROUND(E13*IVA,2),\" € C/IVA\")","v":"36,3 € C/IVA"}]
[]
[1,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"H6","v":26}]
[]
[false]

{"sheet":"3.2.3","index":43,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":true,"merged":[[8,2,8,5],[7,2,7,5],[1,2,1,5],[0,2,0,5],[3,2,5,5],[6,2,6,5]]}
[400,"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[null,null,"3.2.3 TRABAJOS COMPLEMENTARIOS DE LA GESTIÓN URBANÍSTICA"]
[]
[null,null,"• Obtención de títulos de propiedad: 10% de la cuota correspondiente a la de gestión del planeamiento aplicable al ámbito."]
[]
[]
[null,null,"• Acreditaciones de titularidad: 10% de los honorarios orientativos de gestión del planeamiento aplicable al ámbito."]
[null,null,"En todos los demás casos que pudieran darse y no figuren en la anterior relación, la cuota se calcula por analogía con otras cuotas o por el total de horas con \n\n"]
[null,null,"CV = nº horas • M  / 500  y un mínimo ≮ M  / 40."]
[null,null,null,"Arquitecto","Cliente"]
[null,null,null,{"$f":"D5/3","v":0},{"$f":"D5*2/3","v":0}]

{"sheet":"3.3.2B","index":44,"n_rows":18,"n_cols":19,"rows_kept":18,"cut":false,"hidden":true,"merged":[[1,2,1,5],[13,2,14,4],[0,2,0,5],[2,2,3,2]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[false,null,"3.3.2 OBRAS URBANAS Y AMPLIACIÓN, REFORMA Y REPARACIÓN DE OBRAS DE URBANIZACIÓN"]
[null,null,"Presupuesto de ejecución material \nde la obra       (PEM) ="]
[null,null,null,null,"€"]
[]
[{"$f":"IF(D4=0,0,0.5+(6*((MODULO/D4)^0.2)))","v":0},null,"Coeficiente CP =",{"$f":"IF(A6>=2.5,2.5,A6)","v":0}]
[]
[null,null,"Coeficiente de FASE",{"$f":"'2.1.1B'!$G$13","v":0},null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[]
[null,{"$f":"D9*D4*D6/1000","v":0},"Calculo",{"$f":"IF(B12>MODULO/40,B12,IF(D9=0,0,MODULO/40))","v":0},null,null,null,null,null,null,null,null,null,null,false,false,false,false,false]
[null,null,null,{"$f":"CONCATENATE(ROUND(D12*1.16,2),\" € c/IVA\")","v":"0 € c/IVA"},null,null,null,null,null,null,null,null,null,null,null,false,null,null,false]
[null,null,"El cliente desea que la cuota variable de intervención por visado le sea facturada a su nombre",null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,false]
[]
[]
[null,null,null,"Arquitecto","Cliente"]
[null,null,null,{"$f":"D12/3","v":0},{"$f":"D12*2/3","v":0}]

{"sheet":"3.3.1","index":45,"n_rows":14,"n_cols":19,"rows_kept":14,"cut":false,"hidden":true,"merged":[[1,2,1,5],[13,2,14,4],[0,2,0,5],[2,2,3,2]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,false]
[false,null,"3.3.1 PROYECTOS DE URBANIZACIÓN",null,null,null,null,26]
[null,null,"Superficie total abarcada",null,null,null,null,205]
[null,null,null,null,"Hectareas",null,null,0.1]
[null,null,null,null,null,null,null,46]
[{"$f":"IF(D4=0,0,2+(45*(1/D4)^0.25))","v":0},null,"Coeficiente Ss =",{"$f":"IF(A6>=39.8398657,40,A6)","v":0},null,null,null,{"$f":"IF(H5*B12<H2,H2,IF(H5*B12>H3,H3,H5*B12))","v":26}]
[null,null,null,null,null,null,null,{"$f":"B12*H4","v":0}]
[null,null,"Coeficiente de FASE",null,null,null,null,{"$f":"IF(H7<H2,H2,IF(H7>H3,H3,H7))","v":26},null,null,null,null,null,null,false,false,null,null,false]
[null,null,null,null,null,null,null,{"$f":"IF(H1=TRUE,B12+H8,B12)","v":0},null,null,null,null,null,null,false,false,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[]
[null,{"$f":"D9*MODULO*D4*D6/50","v":0},"Calculo",{"$f":"H9","v":0},null,null,null,null,null,null,null,null,null,null,false,false,false,false,false]
[null,46,null,{"$f":"CONCATENATE(ROUND(D12*IVA,2),\" € c/IVA\")","v":"0 € c/IVA"},null,null,null,null,null,null,null,null,null,null,null,false,null,null,false]
[null,null,"URGENTE O RAPIDO",null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,false]

{"sheet":"3.3.2","index":46,"n_rows":23,"n_cols":19,"rows_kept":23,"cut":false,"hidden":true,"merged":[[1,2,1,5],[18,2,19,4],[0,2,0,5],[2,2,3,2],[11,2,12,2],[7,2,8,2],[10,2,10,4]]}
[400,"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[false,null,"3.3.2 PROYECTOS DE OBRAS URBANAS"]
[null,null,"Superficie total abarcada"]
[null,null,null,null,"Hectareas"]
[]
[{"$f":"IF(D4=0,0,2+(45*(1/D4)^0.25))","v":0},null,"Coeficiente Ss =",{"$f":"IF(A6>=39.8398657,40,A6)","v":0}]
[]
[null,null,"Coeficiente de FASE",{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,"Porcentaje por capitulo o tipo de obra de urbanización",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[null,null,"Calculo",{"$f":"D13*D9*MODULO*D4*D6/50","v":0},null,null,null,null,null,null,null,null,null,null,false,false,false,false,false]
[null,null,null,2.1,null,null,null,null,null,null,null,null,null,null,null,false,null,null,false]
[null,null,"El cliente desea que la cuota variable de intervención por visado le sea facturada a su nombre",null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,false]
[]
[]
[null,null,null,"Arquitecto","Cliente"]
[null,null,null,{"$f":"D17/3","v":0},{"$f":"D17*2/3","v":0}]

{"sheet":"3.3.3","index":47,"n_rows":23,"n_cols":19,"rows_kept":23,"cut":false,"hidden":true,"merged":[[1,2,1,5],[18,2,19,4],[0,2,0,5],[2,2,3,2],[11,2,12,2],[7,2,8,2],[10,2,10,4]]}
[400,"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[false,null,"3.3.3 PROYECTOS DE AMPLIACIÓN, REFORMA Y REPARACIÓN DE OBRAS DE URBANIZACIÓN"]
[null,null,"Superficie total abarcada"]
[null,null,null,null,"ha."]
[]
[{"$f":"IF(D4=0,0,2+(45*(1/D4)^0.25))","v":0},null,"S =",{"$f":"IF(A6>=39.8398657,40,A6)","v":0}]
[]
[null,null,"Coeficiente de FASE",{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,"Porcentaje por capitulo o tipo de obra de urbanización",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"Proyecto nueva urb.",{"$f":"D13*D9*MODULO*D4*D6/50","v":0}]
[]
[null,null,"Calculo",{"$f":"1.1*D13*D9*MODULO*D4*D6/50","v":0},null,null,null,null,null,null,null,null,null,null,false,false,false,false,false]
[null,null,null,{"$f":"CONCATENATE(ROUND(D17*1.16,2),\" € c/IVA\")","v":"0 € c/IVA"},null,null,null,null,null,null,null,null,null,null,null,false,null,null,false]
[null,null,"El cliente desea que la cuota variable de intervención por visado le sea facturada a su nombre",null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,false]
[]
[]
[null,null,null,"Arquitecto","Cliente"]
[null,null,null,{"$f":"D17/3","v":0},{"$f":"D17*2/3","v":0}]

{"sheet":"4.1.1","index":48,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,2,1,5],[9,2,10,4],[0,11,1,13]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,null,null,false]
[false,null,"4.2.1 DESLINDES Y SEGREGACIONES DE TERRENOS Y SOLARES",null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,205]
[null,null,null,null,null,null,null,{"$f":"0.75*MODULO/50","v":8.0818499999999993},51,0.1]
[null,null,null,null,null,null,null,{"$f":"(0.75*MODULO+(D4-50)*2)/50","v":6.0818499999999993},101,{"$f":"B7","v":52}]
[null,{"$f":"IF(D4<I4,H4,IF(D4<I5,H5,IF(D4<I6,H6,IF(D4<I7,H7,IF(D4<I8,H8,H9)))))","v":8.0818499999999993},"Calculo  ",{"$f":"IF(J1=TRUE,31+J2,31)","v":31},null,null,null,{"$f":"(MODULO+(D4-100)*0.8)/50","v":9.1757999999999988},1001,{"$f":"IF(J5*J4<J2,J2,IF(J5*J4>J3,J3,J5*J4))","v":26}]
[null,{"$f":"IF(B6<52,52,B6)","v":52},null,{"$f":"CONCATENATE(ROUND(D6*IVA,2),\" € c/IVA\")","v":"37,51 € c/IVA"},null,null,null,{"$f":"(2.8*MODULO+(D4-1000)*0.4)/50","v":22.172239999999999},5001,{"$f":"IF(J1=TRUE,B7+J6,B7)","v":52}]
[null,null,null,null,null,null,null,{"$f":"(6.8*MODULO+(D4-5000)*0.3)/50","v":43.275439999999989},10001]
[null,null,null,null,null,null,null,{"$f":"(10.55*MODULO+(D4-10000)*0.2)/50","v":73.684689999999989}]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"J6","v":26}]

{"sheet":"4.1.2","index":49,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,2,1,5],[9,2,10,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,null,null,false]
[false,null,"4.2.2 DESLINDES DE EDIFICACIONES",null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,205]
[null,null,null,null,null,null,null,{"$f":"MODULO/50","v":10.775799999999998},61,0.1]
[null,null,null,null,null,null,null,{"$f":"(MODULO+(D4-60)*5)/50","v":4.7757999999999994},101,{"$f":"B7","v":52}]
[null,{"$f":"IF(D4<I4,H4,IF(D4<I5,H5,IF(D4<I6,H6,IF(D4<I7,H7,H8))))","v":10.775799999999998},"Valor",{"$f":"IF(J1=FALSE,31,31+F11)","v":31},null,null,null,{"$f":"(1.5*MODULO+(D4-100)*2)/50","v":12.163699999999999},1001,{"$f":"IF(J5*J4<J2,J2,IF(J5*J4>J3,J3,J5*J4))","v":26}]
[null,{"$f":"IF(B6<52,52,B6)","v":52},null,{"$f":"CONCATENATE(ROUND(D6*IVA,2),\" € c/IVA\")","v":"37,51 € c/IVA"},null,null,null,{"$f":"(6*MODULO+(D4-1000)*0.6)/50","v":52.654799999999994},5001,{"$f":"IF(J1=TRUE,B7+J6,B7)","v":52}]
[null,null,null,null,null,null,null,{"$f":"(12*MODULO+(D4-5000)*0.3)/50","v":99.309599999999989}]
[]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"J6","v":26}]

{"sheet":"4.1.3","index":50,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,2,1,5],[0,2,0,5],[9,2,10,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,null,null,false]
[false,null,"4.2.3 REPLANTEOS DE LINDEROS, ALINEACIONES Y OTROS",null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,205]
[null,null,null,null,null,null,null,{"$f":"0.5*MODULO/50","v":5.3878999999999992},51,0.1]
[null,null,null,null,null,null,null,{"$f":"(0.5*MODULO+(D4-50)*2)/50","v":3.3878999999999997},101,{"$f":"B7","v":52}]
[null,{"$f":"IF(D4<I4,H4,IF(D4<I5,H5,IF(D4<I6,H6,IF(D4<I7,H7,H8))))","v":5.3878999999999992},"Valor",{"$f":"IF(J1=FALSE,31,31+F11)","v":31},null,null,null,{"$f":"(0.75*MODULO+(D4-100)*1)/50","v":6.0818499999999993},501,{"$f":"IF(J5*J4<J2,J2,IF(J5*J4>J3,J3,J5*J4))","v":26}]
[null,{"$f":"IF(B6<52,52,B6)","v":52},null,{"$f":"CONCATENATE(ROUND(D6*IVA,2),\" € c/IVA\")","v":"37,51 € c/IVA"},null,null,null,{"$f":"(1.75*MODULO+(D4-500)*0.8)/50","v":10.85765},1001,{"$f":"IF(J1=TRUE,B7+J6,B7)","v":52}]
[null,null,null,null,null,null,null,{"$f":"(2.75*MODULO+(D4-1000)*0.4)/50","v":21.633449999999996},5001]
[null,null,null,null,null,null,null,{"$f":"(6.75*MODULO+(D4-5000)*0.2)/50","v":52.73664999999999},10001]
[null,null,"URGENTE O RAPIDO",null,null,null,null,{"$f":"(9.25*MODULO+(D4-10000)*0.15)/50","v":69.676149999999993}]
[null,null,null,null,null,{"$f":"J6","v":26}]

{"sheet":"4.1.4","index":51,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,2,1,5],[9,2,10,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,null,null,false]
[false,null,"4.2.4 MEDICIÓN DE TERRENOS Y SOLARES",null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,205]
[null,null,null,null,null,null,null,{"$f":"0.6*MODULO/50","v":6.4654799999999986},101,0.1]
[null,null,null,null,null,null,null,{"$f":"(0.6*MODULO+(D4-100)*0.4)/50","v":5.6654799999999987},1001,{"$f":"B7","v":52}]
[null,{"$f":"IF(D4<I4,H4,IF(D4<I5,H5,IF(D4<I6,H6,IF(D4<I7,H7,H8))))","v":6.4654799999999986},"Valor",{"$f":"IF(J1=FALSE,31,31+F11)","v":31},null,null,null,{"$f":"(1.5*MODULO+(D4-1000)*0.2)/50","v":12.163699999999999},10001,{"$f":"IF(J5*J4<J2,J2,IF(J5*J4>J3,J3,J5*J4))","v":26}]
[null,{"$f":"IF(B6<52,52,B6)","v":52},null,{"$f":"CONCATENATE(ROUND(D6*IVA,2),\" € c/IVA\")","v":"37,51 € c/IVA"},null,null,null,{"$f":"(6*MODULO+(D4-10000)*0.1)/50","v":44.654799999999994},100001,{"$f":"IF(J1=TRUE,B7+J6,B7)","v":52}]
[null,null,null,null,null,null,null,{"$f":"(28.5*MODULO+(D4-100000)*0.05)/50","v":207.1103}]
[]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"J6","v":26}]

{"sheet":"4.1.5","index":52,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":true,"merged":[[1,2,1,5],[14,2,15,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,null,null,false]
[false,null,"4.2.5 MEDICIÓN DE EDIFICACIONES",null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,205]
[null,null,null,null,null,null,null,null,null,0.1]
[null,null,"plantas iguales a 1ª",null,"ud.",null,null,null,null,{"$f":"B12","v":49}]
[null,null,"plantas diferentes",null,"ud.",null,null,null,null,{"$f":"IF(J5*J4<J2,J2,IF(J5*J4>J3,J3,J5*J4))","v":26}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J1=TRUE,B12+J6,B12)","v":49}]
[]
[null,null,"superficie a medir",{"$f":"D4*(1+D5*0.1+D6*0.5)","v":0},"m2",null,null,{"$f":"0.75*MODULO/50","v":8.0818499999999993},101]
[null,null,null,null,null,null,null,{"$f":"(0.75*MODULO+(D9-100))/50","v":6.0818499999999993},1001]
[null,{"$f":"IF(D9<I9,H9,IF(D9<I10,H10,IF(D9<I11,H11,H12)))","v":8.0818499999999993},"Valor",{"$f":"IF(J1=FALSE,31,31+F16)","v":31},null,null,null,{"$f":"(3*MODULO+(D9-1000)*0.4)/50","v":24.327399999999997},10001]
[null,{"$f":"IF(B11<49,49,B11)","v":49},null,{"$f":"CONCATENATE(ROUND(D11*IVA,2),\" € c/IVA\")","v":"37,51 € c/IVA"},null,null,null,{"$f":"(12*MODULO+(D9-10000)*0.2)/50","v":89.309599999999989}]
[]
[]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"J2","v":26}]

{"sheet":"4.2.1","index":53,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":true,"merged":[[1,2,1,5],[14,2,15,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,null,null,false]
[false,null,"4.3.1 TASACIÓN DE TERRENOS Y SOLARES",null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,205]
[null,null,null,null,null,null,null,null,null,0.1]
[null,null,"plantas iguales a 1ª",null,"ud.",null,null,null,null,{"$f":"B12","v":49}]
[null,null,"plantas diferentes",null,"ud.",null,null,null,null,{"$f":"IF(J5*J4<J2,J2,IF(J5*J4>J3,J3,J5*J4))","v":26}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J1=TRUE,B12+J6,B12)","v":49}]
[]
[null,null,"superficie a medir",{"$f":"D4*(1+D5*0.1+D6*0.5)","v":0},"m2",null,null,{"$f":"0.75*MODULO/50","v":8.0818499999999993},101]
[null,null,null,null,null,null,null,{"$f":"(0.75*MODULO+(D9-100))/50","v":6.0818499999999993},1001]
[null,{"$f":"IF(D9<I9,H9,IF(D9<I10,H10,IF(D9<I11,H11,H12)))","v":8.0818499999999993},"Valor",{"$f":"IF(J1=FALSE,31,31+F16)","v":31},null,null,null,{"$f":"(3*MODULO+(D9-1000)*0.4)/50","v":24.327399999999997},10001]
[null,{"$f":"IF(B11<49,49,B11)","v":49},null,{"$f":"CONCATENATE(ROUND(D11*IVA,2),\" € c/IVA\")","v":"37,51 € c/IVA"},null,null,null,{"$f":"(12*MODULO+(D9-10000)*0.2)/50","v":89.309599999999989}]
[]
[]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"J2","v":26}]

{"sheet":"4.2.1B","index":54,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":true,"merged":[[1,2,1,5],[0,2,0,5],[15,2,16,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,null,null,false]
[false,null,"4.3.1 TASACIONES DE TERRENO Y SOLARES",null,null,null,null,null,null,25]
[1,null,null,null,null,null,null,null,null,200]
[false,null,"Tasación de solar",null,null,null,null,null,null,0.1]
[{"$f":"IF(A4,1,2)","v":2},null,"Tasación de terreno",null,null,null,null,1,null,{"$f":"B15","v":53}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J5*J4<J2,J2,IF(J5*J4>J3,J3,J5*J4))","v":25}]
[null,null,"NIVEL VALORACIÓN ESTIMATIVA",null,null,null,null,false,null,{"$f":"IF(J1=TRUE,J5+J6,J5)","v":53}]
[]
[]
[]
[null,null,"Valor de tasación",null,"miles €",null,null,{"$f":"MODULO/50","v":10.775799999999998},101]
[null,null,null,null,null,null,null,{"$f":"(MODULO+(D11-100)*1.6)/50","v":7.5757999999999992},601]
[null,{"$f":"IF(A4=FALSE,F14,IF( F14*0.3<0.8*MODULO/50,0.8*MODULO/50,F14*0.3))","v":10.775799999999998},"Calculo  ",{"$f":"J7","v":53},{"$f":"IF(D11<I11,H11,IF(D11<I12,H12,IF(D11<I13,H13,IF(D11<I14,H14,IF(D11<I15,H15,H16)))))","v":10.775799999999998},{"$f":"IF(A3=1,E13,E14)","v":10.775799999999998},null,{"$f":"(3*MODULO+(D11-600))/50","v":20.327399999999997},1201]
[null,{"$f":"IF(B13>53,B13,53)","v":53},null,{"$f":"CONCATENATE(ROUND(D13*IVA,2),\" € c/IVA\")","v":"64,13 € c/IVA"},{"$f":"IF(D11<I18,H18,IF(D11<I19,H19,IF(D11<I20,H20,IF(D11<I21,H21,IF(D11<I22,H22,IF(D11<I23,H23,H24))))))","v":6.2206399999999995},{"$f":"IF( F13<0.8*MODULO/50,0.8*MODULO/50,F13)","v":10.775799999999998},null,{"$f":"(4.5*MODULO+(D11-1200)*0.75)/50","v":30.491099999999996},2001]
[null,{"$f":"IF(A5=2,B14,IF(B13<30,30,B13))","v":53},null,null,null,null,null,{"$f":"(6*MODULO+(D11-2000)*0.6)/50","v":40.654799999999994},6001]
[null,null,"URGENTE O RAPIDO",null,null,null,null,{"$f":"(12*MODULO+(D11-6000)*0.4)/50","v":81.309599999999989}]
[null,null,null,null,null,{"$f":"J6","v":25}]
[null,null,null,null,null,null,null,{"$f":"0.8*MODULO/50","v":8.6206399999999999}]
[null,null,null,null,null,null,null,{"$f":"(0.8*MODULO+(D11-60)*2)/50","v":6.2206399999999995},201]
[null,null,null,null,null,null,null,{"$f":"(1.5*MODULO+(D11-200)*1.6)/50","v":9.7636999999999983},601]
[null,null,null,null,null,null,null,{"$f":"(3.1*MODULO+(D11-600)*1.2)/50","v":19.00498},1201]
[null,null,null,null,null,null,null,{"$f":"(4.9*MODULO+(D11-1200)*0.9)/50","v":31.201419999999999},2001]
[null,null,null,null,null,null,null,{"$f":"(6.7*MODULO+(D11-2000)*0.75)/50","v":42.197859999999999},6001]
[null,null,null,null,null,null,null,{"$f":"(14.2*MODULO+(D11-6000)*0.6)/50","v":81.016359999999992}]

{"sheet":"4.2.2","index":55,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":true,"merged":[[1,2,1,5],[14,2,15,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,null,null,false]
[false,null,"4.3.2 TASACIONES COMPLEMENTARIAS DE SUELO",null,null,null,null,null,26,25]
[null,null,null,null,null,null,null,null,205,200]
[null,null,null,null,null,null,null,null,null,0.1]
[null,null,"plantas iguales a 1ª",null,"ud.",null,null,null,null,{"$f":"B12","v":49}]
[null,null,"plantas diferentes",null,"ud.",null,null,null,null,{"$f":"IF(J5*J4<J2,J2,IF(J5*J4>J3,J3,J5*J4))","v":25}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J1=TRUE,B12+J6,B12)","v":49}]
[]
[null,null,"superficie a medir",{"$f":"D4*(1+D5*0.1+D6*0.5)","v":0},"m2",null,null,{"$f":"0.75*MODULO/50","v":8.0818499999999993},101]
[null,null,null,null,null,null,null,{"$f":"(0.75*MODULO+(D9-100))/50","v":6.0818499999999993},1001]
[null,{"$f":"IF(D9<I9,H9,IF(D9<I10,H10,IF(D9<I11,H11,H12)))","v":8.0818499999999993},"Valor",{"$f":"IF(J1=FALSE,31,31+F16)","v":31},null,null,null,{"$f":"(3*MODULO+(D9-1000)*0.4)/50","v":24.327399999999997},10001]
[null,{"$f":"IF(B11<49,49,B11)","v":49},null,{"$f":"CONCATENATE(ROUND(D11*IVA,2),\" € c/IVA\")","v":"37,51 € c/IVA"},null,null,null,{"$f":"(12*MODULO+(D9-10000)*0.2)/50","v":89.309599999999989}]
[]
[]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"I2","v":26}]

{"sheet":"4.2.2B","index":56,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":true,"merged":[[1,2,1,5],[0,2,0,5],[15,2,16,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,null,null,false]
[false,null,"4.3.2 TASACIONES COMPLEMENTARIAS DE SUELO",null,null,null,null,null,null,25]
[2,null,null,null,null,null,null,null,null,200]
[false,null,null,null,null,null,null,null,null,0.1]
[null,null,"Tasación de terreno",null,null,null,null,1,null,{"$f":"B15","v":53}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J5*J4<J2,J2,IF(J5*J4>J3,J3,J5*J4))","v":25}]
[null,null,"NIVEL VALORACIÓN ESTIMATIVA",null,null,null,null,false,null,{"$f":"IF(J1=TRUE,J5+J6,J5)","v":53}]
[]
[]
[]
[null,null,"Valor de tasación",null,"€",{"$f":"D11/1000","v":0},null,{"$f":"MODULO/50","v":10.775799999999998},101]
[null,null,null,null,null,null,null,{"$f":"(MODULO+(D11-100)*1.6)/50","v":7.5757999999999992},601]
[null,{"$f":"IF(A4=FALSE,F14,IF( F14*0.3<53,53,53*0.3))","v":8.6206399999999999},"Calculo  ",{"$f":"J7","v":53},{"$f":"IF(D11<I11,H11,IF(D11<I12,H12,IF(D11<I13,H13,IF(D11<I14,H14,IF(D11<I15,H15,H16)))))","v":10.775799999999998},{"$f":"IF(A3=1,E13,E14)","v":8.6206399999999999},null,{"$f":"(3*MODULO+(D11-600))/50","v":20.327399999999997},1201]
[null,{"$f":"IF(B13<53,53,B13)","v":53},null,{"$f":"CONCATENATE(ROUND(D13*IVA,2),\" € c/IVA\")","v":"64,13 € c/IVA"},{"$f":"IF(F11<I18,H18,IF(F11<I19,H19,IF(F11<I20,H20,IF(F11<I21,H21,IF(F11<I22,H22,IF(F11<I23,H23,H24))))))","v":8.6206399999999999},{"$f":"IF( F13<0.8*MODULO/50,0.8*MODULO/50,F13)","v":8.6206399999999999},null,{"$f":"(4.5*MODULO+(D11-1200)*0.75)/50","v":30.491099999999996},2001]
[{"$f":"IF(A4=FALSE,B14,B14*0.3)","v":53},{"$f":"IF(A4,IF(A15>30,A15,30),A15)","v":53},null,null,null,null,null,{"$f":"(6*MODULO+(D11-2000)*0.6)/50","v":40.654799999999994},6001]
[null,null,"URGENTE O RAPIDO",null,null,null,null,{"$f":"(12*MODULO+(D11-6000)*0.4)/50","v":81.309599999999989}]
[null,null,null,null,null,{"$f":"J6","v":25}]
[null,null,null,null,null,null,null,{"$f":"0.8*MODULO/50","v":8.6206399999999999},61]
[null,null,null,null,null,null,null,{"$f":"(0.8*MODULO+((D11/1000)-60)*2)/50","v":6.2206399999999995},201]
[null,null,null,null,null,null,null,{"$f":"(1.5*MODULO+((D11/1000)-200)*1.6)/50","v":9.7636999999999983},601]
[null,null,null,null,null,null,null,{"$f":"(3.1*MODULO+((D11/1000)-600)*1.2)/50","v":19.00498},1201]
[null,null,null,null,null,null,null,{"$f":"(4.9*MODULO+((D11/1000)-1200)*0.9)/50","v":31.201419999999999},2001]
[null,null,null,null,null,null,null,{"$f":"(6.7*MODULO+((D11/1000)-2000)*0.75)/50","v":42.197859999999999},6001]
[null,null,null,null,null,null,null,{"$f":"(14.2*MODULO+((D12/1000)-6000)*0.6)/50","v":81.016359999999992}]

{"sheet":"4.2.3","index":57,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":true,"merged":[[1,2,1,5],[14,2,15,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,null,null,false]
[false,null,"4.3.3 TASACIÓN DE EDIFICACIONES",null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,205]
[null,null,null,null,null,null,null,null,null,0.1]
[null,null,"plantas iguales a 1ª",null,"ud.",null,null,null,null,{"$f":"B12","v":49}]
[null,null,"plantas diferentes",null,"ud.",null,null,null,null,{"$f":"IF(J5*J4<J2,J2,IF(J5*J4>J3,J3,J5*J4))","v":26}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J1=TRUE,B12+J6,B12)","v":49}]
[]
[null,null,"superficie a medir",{"$f":"D4*(1+D5*0.1+D6*0.5)","v":0},"m2",null,null,{"$f":"0.75*MODULO/50","v":8.0818499999999993},101]
[null,null,null,null,null,null,null,{"$f":"(0.75*MODULO+(D9-100))/50","v":6.0818499999999993},1001]
[null,{"$f":"IF(D9<I9,H9,IF(D9<I10,H10,IF(D9<I11,H11,H12)))","v":8.0818499999999993},"Valor",{"$f":"IF(J1=FALSE,31,31+F16)","v":31},null,null,null,{"$f":"(3*MODULO+(D9-1000)*0.4)/50","v":24.327399999999997},10001]
[null,{"$f":"IF(B11<49,49,B11)","v":49},null,{"$f":"CONCATENATE(ROUND(D11*IVA,2),\" € c/IVA\")","v":"37,51 € c/IVA"},null,null,null,{"$f":"(12*MODULO+(D9-10000)*0.2)/50","v":89.309599999999989}]
[]
[]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"J2","v":26}]

{"sheet":"4.2.3B","index":58,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":true,"merged":[[1,2,1,5],[0,2,0,5]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,{"$f":"1+'1'!N18","v":1.21},null,null,false]
[false,null,"4.3.3 TASACIÓN DE EDIFICACIONES",null,null,null,null,null,null,25]
[false,null,null,null,null,null,null,null,null,200]
[false,null,"NIVEL VALORACIÓN ESTIMATIVA",null,null,null,null,null,null,0.1]
[null,null,"URGENTE O RAPIDO",null,{"$f":"J6","v":25},null,null,null,null,{"$f":"C11","v":53}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J5*J4<J2,J2,IF(J5*J4>J3,J3,J5*J4))","v":25}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J1=TRUE,C11+J6,C11)","v":53}]
[null,null,"Valor de tasación",null,"miles €",null,null,{"$f":"1.2*MODULO/50","v":12.930959999999997},101]
[null,null,null,null,null,null,null,{"$f":"(1.2*MODULO+(D8-100)*1.6)/50","v":9.7309599999999978},601]
[null,{"$f":"IF(E11<53,53,E11)","v":53},"Calculo  ",{"$f":"J7","v":53},{"$f":"IF(D8<I8,H8,IF(D8<I9,H9,IF(D8<I10,H10,IF(D8<I11,H11,IF(D8<I12,H12,H13)))))","v":12.930959999999997},null,null,{"$f":"(3.2*MODULO+(D8-600)*1.2)/50","v":20.082559999999997},1201]
[null,{"$f":"IF(A3=FALSE,B10,B10*0.3)","v":53},{"$f":"IF(A4=TRUE,B11+25,B11)","v":53},{"$f":"CONCATENATE(ROUND(D10*IVA,2),\" € c/IVA\")","v":"64,13 € c/IVA"},{"$f":"IF(E10<1.2*MODULO/50,1.2*MODULO/50,E10)","v":12.930959999999997},null,null,{"$f":"(5*MODULO+(D8-1200)*0.9)/50","v":32.278999999999996},2001]
[null,null,null,null,null,null,null,{"$f":"(6.8*MODULO+(D8-2000)*0.7)/50","v":45.275439999999989},6001]
[null,null,null,null,null,null,null,{"$f":"(13.8*MODULO+(D8-6000)*0.6)/50","v":76.706039999999987}]

{"sheet":"4.2.4","index":59,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":true,"merged":[[1,2,1,5],[14,2,15,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,null,null,false]
[false,null,"4.3.4 TASACIÓN PARCIAL DE EDIFICIOS",null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,205]
[null,null,null,null,null,null,null,null,null,0.1]
[null,null,"plantas iguales a 1ª",null,"ud.",null,null,null,null,{"$f":"B12","v":49}]
[null,null,"plantas diferentes",null,"ud.",null,null,null,null,{"$f":"IF(J5*J4<J2,J2,IF(J5*J4>J3,J3,J5*J4))","v":26}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J1=TRUE,B12+J6,B12)","v":49}]
[]
[null,null,"superficie a medir",{"$f":"D4*(1+D5*0.1+D6*0.5)","v":0},"m2",null,null,{"$f":"0.75*MODULO/50","v":8.0818499999999993},101]
[null,null,null,null,null,null,null,{"$f":"(0.75*MODULO+(D9-100))/50","v":6.0818499999999993},1001]
[null,{"$f":"IF(D9<I9,H9,IF(D9<I10,H10,IF(D9<I11,H11,H12)))","v":8.0818499999999993},"Valor",{"$f":"IF(J1=TRUE,31+J2,31)","v":31},null,null,null,{"$f":"(3*MODULO+(D9-1000)*0.4)/50","v":24.327399999999997},10001]
[null,{"$f":"IF(B11<49,49,B11)","v":49},null,{"$f":"CONCATENATE(ROUND(D11*IVA,2),\" € c/IVA\")","v":"37,51 € c/IVA"},null,null,null,{"$f":"(12*MODULO+(D9-10000)*0.2)/50","v":89.309599999999989}]
[]
[]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"J2","v":26}]

{"sheet":"4.2.4B","index":60,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":true,"merged":[[1,2,1,5],[11,2,12,4],[0,2,0,5],[13,2,14,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,{"$f":"1+'1'!N18","v":1.21},null,null,false]
[false,null,"4.3.4 TASACIÓN PARCIAL DE EDIFICIOS",null,null,null,null,null,null,25]
[false,null,null,null,null,null,null,null,null,200]
[false,null,"NIVEL VALORACIÓN ESTIMATIVA",null,null,null,null,null,null,0.1]
[null,null,"URGENTE O RAPIDO",null,{"$f":"J6","v":25},null,null,null,null,{"$f":"B11","v":53}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J5*J4<J2,J2,IF(J5*J4>J3,J3,J5*J4))","v":25}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(A4=TRUE,J5+J6,J5)","v":53}]
[null,null,"Valor de tasación",null,"miles €",null,null,{"$f":"1.2*MODULO/50","v":12.930959999999997},101]
[null,null,null,null,null,null,null,{"$f":"(1.2*MODULO+(D8-100)*1.6)/50","v":9.7309599999999978},601]
[null,{"$f":"IF(E11<53,53,E11)","v":53},"Calculo  ",{"$f":"J7","v":53},{"$f":"IF(D8<I8,H8,IF(D8<I9,H9,IF(D8<I10,H10,IF(D8<I11,H11,IF(D8<I12,H12,H13)))))","v":12.930959999999997},null,null,{"$f":"(3.2*MODULO+(D8-600)*1.2)/50","v":20.082559999999997},1201]
[null,{"$f":"IF(A3=FALSE,B10,B10*0.3)","v":53},null,{"$f":"CONCATENATE(ROUND(D10*IVA,2),\" € c/IVA\")","v":"64,13 € c/IVA"},{"$f":"IF(E10<1.2*MODULO/50,1.2*MODULO/50,E10)","v":12.930959999999997},null,null,{"$f":"(5*MODULO+(D8-1200)*0.9)/50","v":32.278999999999996},2001]
[null,null,null,null,null,null,null,{"$f":"(6.8*MODULO+(D8-2000)*0.7)/50","v":45.275439999999989},6001]
[null,null,null,null,null,null,null,{"$f":"(13.8*MODULO+(D8-6000)*0.6)/50","v":76.706039999999987}]

{"sheet":"4.2.5","index":61,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":true,"merged":[[1,2,1,5],[14,2,15,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,null,null,false]
[false,null,"4.3.5 TASACIONES DE LAS RENTAS",null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,205]
[null,null,null,null,null,null,null,null,null,0.1]
[null,null,"plantas iguales a 1ª",null,"ud.",null,null,null,null,{"$f":"B12","v":49}]
[null,null,"plantas diferentes",null,"ud.",null,null,null,null,{"$f":"IF(J5*J4<J2,J2,IF(J5*J4>J3,J3,J5*J4))","v":26}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J1=TRUE,B12+J6,B12)","v":49}]
[]
[null,null,"superficie a medir",{"$f":"D4*(1+D5*0.1+D6*0.5)","v":0},"m2",null,null,{"$f":"0.75*MODULO/50","v":8.0818499999999993},101]
[null,null,null,null,null,null,null,{"$f":"(0.75*MODULO+(D9-100))/50","v":6.0818499999999993},1001]
[null,{"$f":"IF(D9<I9,H9,IF(D9<I10,H10,IF(D9<I11,H11,H12)))","v":8.0818499999999993},"Valor",{"$f":"IF(J1=FALSE,31,31+F16)","v":31},null,null,null,{"$f":"(3*MODULO+(D9-1000)*0.4)/50","v":24.327399999999997},10001]
[null,{"$f":"IF(B11<49,49,B11)","v":49},null,{"$f":"CONCATENATE(ROUND(D11*IVA,2),\" € c/IVA\")","v":"37,51 € c/IVA"},null,null,null,{"$f":"(12*MODULO+(D9-10000)*0.2)/50","v":89.309599999999989}]
[]
[]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"J2","v":26}]

{"sheet":"4.2.5B","index":62,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":true,"merged":[[1,2,1,5],[7,2,8,4],[0,2,0,5]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,{"$f":"1+'1'!N18","v":1.21},null,null,false]
[false,null,"4.3.5 TASACIÓN DE LAS RENTAS",null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,200]
[null,null,"Valor de tasación",null,"miles €",null,null,{"$f":"1.5*MODULO/50","v":16.163699999999999},31,0.1]
[null,null,null,null,null,null,null,{"$f":"(1.5*MODULO+(D4-30)*16)/50","v":6.563699999999999},61,{"$f":"B6","v":16.163699999999999}]
[null,{"$f":"IF(D4<I4,H4,IF(D4<I5,H5,IF(D4<I6,H6,IF(D4<I7,H7,IF(D4<I8,H8,H9)))))","v":16.163699999999999},"Calculo  ",{"$f":"IF(J7<53,53,J7)","v":53},null,null,null,{"$f":"(2.7*MODULO+(D4-60)*8)/50","v":19.49466},601,{"$f":"IF(J5*J4<J2,J2,IF(J5*J4>J3,J3,J5*J4))","v":25}]
[null,null,null,{"$f":"CONCATENATE(ROUND(D6*_IVA1,2),\" € c/IVA\")","v":"64,13 € c/IVA"},null,null,null,{"$f":"(13.5*MODULO+(D4-600)*6)/50","v":73.473299999999981},3001,{"$f":"IF(J1=TRUE,J5+J6,J5)","v":16.163699999999999}]
[null,null,"URGENTE O RAPIDO",null,null,null,null,{"$f":"(49.5*MODULO+(D4-3000)*5)/50","v":233.40209999999999},6001,{"$f":"IF(J7<53,53,J7)","v":53}]
[null,null,null,null,null,{"$f":"J6","v":25},null,{"$f":"(87*MODULO+(D4-6000)*4)/50","v":457.49459999999993}]

{"sheet":"4.3.0","index":63,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":true,"merged":[[1,2,1,5],[6,2,7,4],[0,2,0,5],[8,2,9,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,false]
[false,null,"4.4 RECONOCIMIENTOS, ANDAMIOS, EXÁMENES Y CONSULTAS",null,null,null,null,26]
[null,null,null,null,null,null,null,205]
[null,null,null,31,null,null,null,0.1]
[null,null,"Calculo  ",{"$f":"H7","v":31},null,null,null,{"$f":"D4","v":31}]
[null,null,null,{"$f":"CONCATENATE(ROUND(D5*IVA,2),\" € c/IVA\")","v":"37,51 € c/IVA"},null,null,null,{"$f":"IF(H5*H4<H2,H2,IF(H5*H4>H3,H3,H5*H4))","v":26}]
[null,null,null,null,null,null,null,{"$f":"IF(H1=TRUE,D4+H6,D4)","v":31}]
[]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"H6","v":26}]

{"sheet":"4.4.1","index":64,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":true,"merged":[[1,2,1,5],[0,2,0,5],[2,2,2,5],[8,2,9,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,false]
[false,null,"4.5.1 INFORMES, PERITAJES, DICTÁMENES Y CERTIFICADOS",null,null,null,null,26]
[null,null,null,null,null,null,null,205]
[null,null,null,36,null,null,null,0.1]
[null,null,"Calculo",{"$f":"H7","v":36},null,null,null,{"$f":"D4","v":36}]
[null,null,null,{"$f":"CONCATENATE(ROUND(D5*IVA,2),\" € c/IVA\")","v":"43,56 € c/IVA"},null,null,null,{"$f":"IF(H5*H4<H2,H2,IF(H5*H4>H3,H3,H5*H4))","v":26}]
[null,null,null,null,null,null,null,{"$f":"IF(H1=TRUE,D4+H6,D4)","v":36}]
[]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"H6","v":26}]
[null,null,null,{"$f":"D5/3","v":12},{"$f":"D5*2/3","v":24}]
[null,null,null,{"$f":"CONCATENATE(ROUND(D11*1.18,2),\" € c/IVA\")","v":"14,16 € c/IVA"},{"$f":"CONCATENATE(ROUND(E11*1.18,2),\" € c/IVA\")","v":"28,32 € c/IVA"}]

{"sheet":"4.4.2","index":65,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":true,"merged":[[1,2,1,5],[0,2,0,5],[8,2,9,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,null,null,false]
[false,null,"4.5.3 ARBITRAJES",null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,200]
[null,null,"Cantidad en litigio",null,"miles €",null,null,{"$f":"(MODULO+D4*50)/50","v":10.775799999999998},6.0010000000000003,0.1]
[null,null,null,null,null,null,null,{"$f":"(MODULO+D4*40)/50","v":10.775799999999998},60.000999999999998,{"$f":"B6","v":53}]
[null,{"$f":"IF(H10<53,53,H10)","v":53},"Calculo",{"$f":"J7","v":53},null,null,null,{"$f":"(MODULO+D4*30)/50","v":10.775799999999998},300.00099999999998,{"$f":"IF(J5*J4<J2,J2,IF(J5*J4>J3,J3,J5*J4))","v":25}]
[null,null,null,{"$f":"CONCATENATE(ROUND(D6*IVA,2),\" € c/IVA\")","v":"64,13 € c/IVA"},null,null,null,{"$f":"(MODULO+D4*20)/50","v":10.775799999999998},600.00099999999998,{"$f":"IF(J1=TRUE,B6+J6,B6)","v":53}]
[null,null,null,null,null,null,null,{"$f":"(MODULO+D4*10)/50","v":10.775799999999998}]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"J6","v":25},null,{"$f":"IF(D4<I4,H4,IF(D4<I5,H5,IF(D4<I6,H6,IF(D4<I7,H7,H8))))","v":10.775799999999998}]

{"sheet":"4.5.1C","index":66,"n_rows":18,"n_cols":19,"rows_kept":18,"cut":false,"hidden":true,"merged":[[1,2,1,5],[13,2,14,4],[0,2,0,5],[2,2,3,2]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[false,null,"2.5.1 ARQUITECTURA MONUMENTAL Y CONMEMORATIVA"]
[null,null,"Presupuesto de ejecución material \nde la obra       (PEM) ="]
[null,null,null,null,"€"]
[]
[{"$f":"IF(D4=0,0,0.5+(6*((MODULO/D4)^0.2)))","v":0},null,"Coeficiente CP =",{"$f":"IF(A6>=2.5,2.5,A6)","v":0}]
[]
[null,null,"Coeficiente de FASE",{"$f":"'2.1.1B'!$G$13","v":0},null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,null,null,false]
[]
[null,{"$f":"D9*D4*D6/1000","v":0},"Calculo",{"$f":"IF(B12>MODULO/40,B12,IF(D9=0,0,MODULO/40))","v":0},null,null,null,null,null,null,null,null,null,null,false,false,false,false,false]
[null,null,null,{"$f":"CONCATENATE(ROUND(D12*1.16,2),\" € c/IVA\")","v":"0 € c/IVA"},null,null,null,null,null,null,null,null,null,null,null,false,null,null,false]
[null,null,"El cliente desea que la cuota variable de intervención por visado le sea facturada a su nombre",null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,false]
[]
[]
[null,null,null,"Arquitecto","Cliente"]
[null,null,null,{"$f":"D12/3","v":0},{"$f":"D12*2/3","v":0}]

{"sheet":"4.5.2","index":67,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":true,"merged":[[0,2,0,5],[1,2,1,5],[7,2,8,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,false]
[false,null,"4.5.2 EXPEDIENTES DE ACTIVIDAD E INSTALACIONES",null,null,null,null,26]
[null,null,null,null,null,null,null,205]
[null,null,null,{"$f":"46","v":46},null,null,null,0.1]
[null,null,"Calculo",{"$f":"H7","v":46},null,null,null,{"$f":"D4","v":46}]
[null,null,null,{"$f":"CONCATENATE(ROUND(D5*1.18,2),\" € c/IVA\")","v":"54,28 € c/IVA"},null,null,null,{"$f":"IF(H5*H4<H2,H2,IF(H5*H4>H3,H3,H5*H4))","v":26}]
[null,null,null,null,null,null,null,{"$f":"IF(H1=TRUE,D4+H6,D4)","v":46}]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"H6","v":26}]

{"sheet":"4.5.3","index":68,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":true,"merged":[[0,2,0,5],[1,2,1,5],[9,2,10,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,false]
[false,null,"4.5.3 ARBITRAJES",null,null,null,null,26]
[null,null,null,null,null,null,null,205]
[null,null,null,36,null,null,null,0.1]
[null,null,"Calculo  ",{"$f":"IF(H1=FALSE,E5,E5+F11)","v":36},36,null,null,{"$f":"D4","v":36}]
[null,null,null,{"$f":"CONCATENATE(ROUND(D5*IVA,2),\" € c/IVA\")","v":"43,56 € c/IVA"},null,null,null,{"$f":"IF(H5*H4<H2,H2,IF(H5*H4>H3,H3,H5*H4))","v":26}]
[null,null,null,null,null,null,null,{"$f":"IF(H1=TRUE,D4+H6,D4)","v":36}]
[]
[]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"H6","v":26}]

{"sheet":"4.5.6","index":69,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":true,"merged":[[11,2,12,4],[1,2,1,5],[0,2,0,5],[3,2,3,5],[4,2,4,5],[6,2,6,5]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,false]
[false,null,"4.6.1 EXPEDIENTES DE RUINA",null,null,null,null,26]
[null,null,null,null,null,null,null,205]
[null,null,"El precio de visado para expediente de Ruina Legal serán suma de los correspondientes a los distintos trabajos a realizar (levantamiento de planos, tasación de la edificación y de las reparaciones a efectuar, informe de conclusiones).",null,null,null,null,0.1]
[null,null,"La cuota por expediente de Ruina Física Inminente se podrán calcular en función el tiempo empleado",null,null,null,null,{"$f":"B10","v":"0"}]
[null,null,null,null,null,null,null,{"$f":"IF(H5*H4<H2,H2,IF(H5*H4>H3,H3,H5*H4))","v":26}]
[null,null,"Ruina fisica inminente",null,null,null,null,{"$f":"IF(H1=TRUE,B10+H6,B10)","v":"0"}]
[null,null,"                 Nº horas",null,null,null,{"$f":"D8*MODULO/500","v":0}]
[null,null,null,null,null,null,{"$f":"IF(G8<30,30,G8)","v":30}]
[null,{"$f":"IF(D8>0,G9,\"0\")","v":"0"},"Calculo  ",{"$f":"H7","v":"0"},{"$f":"IF(D8>0,CONCATENATE(ROUND(D10*IVA,2),\" € c/IVA\"),\"\")","v":""}]
[]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"H6","v":26}]

{"sheet":"4.5.5","index":70,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":true,"merged":[[1,2,1,5],[14,2,15,4],[0,2,0,5]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,{"$f":"IVA","v":1.21}]
[false,null,"2.4.1 PROYECTO Y DIRECCIÓN DE DEMOLICIÓN TOTAL DE EDIFICACIONES",null,null,null,46]
[1,null,null,null,"URGENTE O RAPIDO",null,26]
[false,null,null,null,null,null,205]
[false,null,null,null,null,{"$f":"IF(B13*G5<G3,G3,IF(B13*G5>G4,G4,B13*G5))","v":26},0.1]
[false,null,null,null,null,null,{"$f":"B13","v":0}]
[null,null,"Fases del trabajo"]
[null,null,"           Proyecto",null,null,null,{"$f":"IF(A4=TRUE,0.8,0)","v":0}]
[null,null,"           Dirección de obras",null,null,null,{"$f":"IF(A5=TRUE,0.2,0)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G8:G9)","v":0}]
[null,null,"Superficie del edificio",null,"m2",null,{"$f":"MODULO*D11*G10/5000","v":0}]
[null,null,null,null,null,null,{"$f":"IF(G11<MODULO/40,MODULO/40,G11)","v":13.469749999999999}]
[null,{"$f":"IF(G12>G2,G12,IF(G10=0,0,G2))","v":0},"Calculo",{"$f":"IF(A6=TRUE,B13+F5,B13)","v":0}]
[null,null,null,{"$f":"CONCATENATE(ROUND(D13*G1,2),\" € c/IVA\")","v":"0 € c/IVA"}]

{"sheet":"4.5.5.b","index":71,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":true,"merged":[[1,2,1,5],[14,2,15,4],[0,2,0,5]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,{"$f":"IVA","v":1.21}]
[false,null,"2.4.2 PROYECTO Y DIRECCIÓN DE DEMOLICIÓN PARCIAL DE EDIFICACIONES",null,null,null,45]
[1,null,null,null,"URGENTE O RAPIDO",null,26]
[false,null,null,null,null,null,205]
[false,null,null,null,null,{"$f":"IF(B13*G5<G3,G3,IF(B13*G5>G4,G4,B13*G5))","v":26},0.1]
[false,null,null,null,null,null,{"$f":"B13","v":0}]
[null,null,"Fases del trabajo"]
[null,null,"           Proyecto",null,null,null,{"$f":"IF(A4=TRUE,0.8,0)","v":0}]
[null,null,"           Dirección de obras",null,null,null,{"$f":"IF(A5=TRUE,0.2,0)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G8:G9)","v":0}]
[null,null,"Superficie del edificio",null,"m2",null,{"$f":"MODULO*D11*G10/5000","v":0}]
[null,null,null,null,null,null,{"$f":"IF(G11<MODULO/40,MODULO/40,G11)","v":13.469749999999999}]
[null,{"$f":"IF(G12>G2,G12,IF(G10=0,0,G2))","v":0},"Calculo",{"$f":"IF(A6=TRUE,B13+F5,B13)","v":0}]
[null,null,null,{"$f":"CONCATENATE(ROUND(D13*G1,2),\" € c/IVA\")","v":"0 € c/IVA"}]

{"sheet":"4.5.5B","index":72,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":true,"merged":[[1,2,1,5],[14,2,15,4],[0,2,0,5]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[false,null,"2.4.2 PROYECTO Y DIRECCIÓN DE DEMOLICIÓN PARCIAL DE EDIFICACIONES"]
[1,null,null,null,null,null,{"$f":"IF(A3=1,0.0025,0.0035)","v":2.5000000000000001E-3}]
[false]
[false]
[]
[null,null,"Fases del trabajo"]
[null,null,"           Proyecto",null,null,null,{"$f":"IF(A4=TRUE,0.85,0)","v":0}]
[null,null,"           Dirección de obras",null,null,null,{"$f":"IF(A5=TRUE,0.15,0)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G8:G9)","v":0}]
[null,null,"Superficie de actuación",null,"m2",null,{"$f":"MODULO*D11*G10/5000","v":0}]
[null,null,null,null,null,null,{"$f":"IF(G11<MODULO/40,MODULO/40,G11)","v":13.469749999999999}]
[null,null,"Calculo",{"$f":"IF(G12>MODULO/40,G12,IF(G10=0,0,MODULO/40))","v":0}]
[null,null,null,{"$f":"CONCATENATE(ROUND(D13*1.18,2),\" € c/IVA\")","v":"0 € c/IVA"}]
[null,null,"El cliente desea que la cuota variable de intervención por visado le sea facturada a su nombre"]
[]
[]
[null,null,null,"Arquitecto","Cliente"]
[null,null,null,{"$f":"D13/3","v":0},{"$f":"D13*2/3","v":0}]

{"sheet":"4.5.7","index":73,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,2,1,5],[6,2,7,4],[0,2,0,5]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[false,null,"4.6.2 INSPECCIÓN TÉCNICA DE EDIFICIOS"]
[]
[]
[null,null,"Calculo",{"$f":"(MODULO/18.87)","v":28.552729199788018}]
[]
[null,null,"El cliente desea que la cuota variable de intervención por visado le sea facturada a su nombre"]
[]
[]
[null,null,null,"Arquitecto","Cliente"]
[null,null,null,{"$f":"D5/3","v":9.5175763999293395},{"$f":"D5*2/3","v":19.035152799858679}]

{"sheet":"4.5.7b","index":74,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":true,"merged":[[1,2,1,6],[18,2,19,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,null,null,false]
[false,null,"4.6.2 INSPECCIÓN TÉCNICA DE EDIFICIOS",null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,200]
[null,"è","Antigüedad de la contrucción:",null,"años","A=",{"$f":"IF(D4<20,1,IF(D4<40,1.25,IF(D4<70,1.5,IF(D4<=100,1.75,2))))","v":1},null,null,0.1]
[null,null,null,null,null,null,null,null,null,{"$f":"C17","v":35}]
[null,"è","Superficie construida:",null,"m2","DE=",{"$f":"IF($D$6>9000,I6,H6)","v":1},{"$f":"IF($D$6<301,1,IF($D$6<601,1.1,IF($D$6<1201,1.2,IF($D$6<2401,1.3,IF($D$6<3601,1.4,IF($D$6<6001,1.5,1.6))))))","v":1},{"$f":"IF($D$6<9001,1.6,IF($D$6<12001,1.7,IF($D$6<15001,1.8,IF($D$6<18001,1.9,IF($D$6<21001,2.1,IF($D$6<24001,2.1,IF($D$6<27001,2.2,IF($D$6<30001,2.3,2.4))))))))","v":1.6},{"$f":"IF(J5*J4<J2,J2,IF(J5*J4>J3,J3,J5*J4))","v":25}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J1=TRUE,C17+J6,C17)","v":35}]
[null,"è","Altura de la construcción:",null,"m","h=",{"$f":"IF(D8<=6,1,IF(D8<=12,1.25,IF(D8<=24,1.5,IF(D8<=30,1.75,IF(D8<=36,2,IF(D8<=45,2.25,IF(D8<=54,2.5,IF(D8<=60,2.75,2.75+H8*0.1))))))))","v":1},{"$f":"INT((D8-60)/3)","v":-20}]
[null,null,"(aprox. 3m por planta)"]
[null,"è","Tipo de estructura:",null,null,"E=",{"$f":"LOOKUP(H10,TABLAITE!I2:J6)","v":0},1]
[]
[null,null,"Grado de complejidad:",0.8,null,"K=",{"$f":"D12","v":0.8}]
[null,null,null,"Valor erroneo (entre 0,80 y 2,00)"]
[]
[]
[null,{"$f":"(MODULO*G4*G6*G8*G10*G12*0.02)","v":0},"Calculo  ",{"$f":"J7","v":35}]
[null,null,{"$f":"IF(B16<35,35,B16)","v":35},{"$f":"CONCATENATE(ROUND(D16*IVA,2),\" € c/IVA\")","v":"42,35 € c/IVA"}]
[]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"J6","v":25}]

{"sheet":"4.6.0","index":75,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,2,1,5],[0,2,0,5],[9,2,10,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,false]
[false,null,"4.6.4 TRABAJOS DE ARQUITECTURA Y DEL ARQUITECTO POR TIEMPO",null,null,null,26]
[{"$f":"MODULO/500","v":1.07758},null,null,null,null,null,205]
[{"$f":"A3*D4","v":0},null,"                 Nº horas",null,null,null,0.1]
[31,null,null,null,null,null,{"$f":"B7","v":31}]
[{"$f":"IF(A4<A5,A5,A4)","v":31},null,"Calculo  ",{"$f":"A7","v":31},null,null,{"$f":"IF(G5*G4<G2,G2,IF(G5*G4>G3,G3,G5*G4))","v":26}]
[{"$f":"IF(G1=TRUE,A6+F11,A6)","v":31},31,null,{"$f":"CONCATENATE(ROUND(D6*IVA,2),\" € c/IVA\")","v":"37,51 € c/IVA"},null,null,{"$f":"IF(G1=TRUE,B7+G6,B7)","v":31}]
[]
[]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"G6","v":26}]

{"sheet":"4.6.2","index":76,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":true,"merged":[[0,2,0,5],[1,2,1,5],[9,2,10,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,false]
[false,null,"4.6.2 INSPECCION TECNICA DE EDIFICIOS",null,null,null,null,26]
[null,null,null,null,null,null,null,205]
[null,null,null,30,null,null,null,0.1]
[null,null,"Calculo  ",{"$f":"IF(H1=FALSE,E5,E5+F11)","v":31},31,null,null,31]
[null,null,null,{"$f":"CONCATENATE(ROUND(D5*IVA,2),\" € c/IVA\")","v":"37,51 € c/IVA"},null,null,null,{"$f":"IF(H5*H4<H2,H2,IF(H5*H4>H3,H3,H5*H4))","v":26}]
[null,null,null,null,null,null,null,{"$f":"IF(H1=TRUE,D4+H6,D4)","v":30}]
[]
[]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"H6","v":26}]

{"sheet":"4.6.2B","index":77,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":true,"merged":[[0,2,0,5],[1,2,1,5],[9,2,10,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,false]
[false,null,"4.6.3 INFORME DE EVALUACIÓN DE EDIFICIOS",null,null,null,null,25]
[null,null,null,null,null,null,null,200]
[null,null,null,30,null,null,null,0.1]
[null,null,"Calculo  ",{"$f":"IF(H1=FALSE,E5,E5+F11)","v":30},30,null,null,{"$f":"D4","v":30}]
[null,null,null,{"$f":"CONCATENATE(ROUND(D5*IVA,2),\" € c/IVA\")","v":"36,3 € c/IVA"},null,null,null,{"$f":"IF(H5*H4<H2,H2,IF(H5*H4>H3,H3,H5*H4))","v":25}]
[null,null,null,null,null,null,null,{"$f":"IF(H1=TRUE,D4+H6,D4)","v":30}]
[]
[]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"H6","v":25}]

{"sheet":"4.6.3","index":78,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":true,"merged":[[0,2,0,5],[1,2,1,5],[9,2,10,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,false]
[false,null,"4.6.3 INFORME DE EVALUACIÓN DE EDIFICIOS",null,null,null,null,26]
[null,null,null,null,null,null,null,205]
[null,null,null,36,null,null,null,0.1]
[null,null,"Calculo  ",{"$f":"H9","v":36},30,null,null,{"$f":"D4","v":36}]
[null,null,null,{"$f":"CONCATENATE(ROUND(D5*IVA,2),\" € c/IVA\")","v":"43,56 € c/IVA"},null,null,null,{"$f":"IF(H5*H4<H2,H2,IF(H5*H4>H3,H3,H5*H4))","v":26}]
[null,null,null,null,null,null,null,{"$f":"IF(H1=TRUE,D4+H6,D4)","v":36}]
[]
[null,null,null,null,null,null,null,{"$f":"IF(H1=FALSE,H5,H5+H6)","v":36}]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"H6","v":26}]

{"sheet":"4.6.4","index":79,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":true,"merged":[[0,2,0,5],[1,2,1,5],[9,2,10,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,false]
[false,null,"4.6.5 LEVANTAMIENTO DE PLANOS",null,null,null,26]
[null,null,null,null,null,null,205]
[null,null,"                 Nº horas",null,null,null,0.1]
[null,null,null,null,null,null,{"$f":"B7","v":31}]
[null,null,"Calculo  ",{"$f":"G7","v":31},null,null,{"$f":"IF(G5*G4<G2,G2,IF(G5*G4>G3,G3,G5*G4))","v":26}]
[null,{"$f":"IF(D4<32,31,D4*MODULO/500)","v":31},null,{"$f":"CONCATENATE(ROUND(D6*IVA,2),\" € c/IVA\")","v":"37,51 € c/IVA"},null,null,{"$f":"IF(G1=TRUE,B7+G6,B7)","v":31}]
[]
[]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"H7","v":0}]

{"sheet":"4.6.5","index":80,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":true,"merged":[[0,2,0,5],[1,2,1,5],[9,2,10,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,false]
[false,null,"4.6.6 REQUERIMIENTOS ADMINISTRATIVOS",null,null,null,null,26]
[null,null,null,null,null,null,null,205]
[null,null,null,30,null,null,null,0.1]
[null,null,"Calculo  ",{"$f":"H9","v":31},null,null,null,31]
[null,null,null,{"$f":"CONCATENATE(ROUND(D5*IVA,2),\" € c/IVA\")","v":"37,51 € c/IVA"},null,null,null,{"$f":"IF(H5*H4<H2,H2,IF(H5*H4>H3,H3,H5*H4))","v":26}]
[null,null,null,null,null,null,null,{"$f":"IF(H1=TRUE,D4+H6,D4)","v":30}]
[]
[null,null,null,null,null,null,null,{"$f":"IF(H1=FALSE,H5,H5+H6)","v":31}]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"H6","v":26}]

{"sheet":"4.6.6","index":81,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":true,"merged":[[3,2,3,5],[0,2,0,5],[1,2,1,5]]}
[null,"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[false,null,"4.6.7 VISADO URGENTE Y VISADO RAPIDO"]
[]
[null,null,"Por la urgencia y rapidez en el visado de los trabajos se abonará una tarifa añadida al precio de visado del 10% del precio de visado, con un mínimo de tarifa añadida por urgencia de 26 euros por expediente y un máximo de 205 euros por expediente."]
[]
[]
[]
[]
[]
[true]

{"sheet":"4.6.7","index":82,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":true,"merged":[[0,2,0,5],[1,2,1,5],[7,2,8,4]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"},null,null,null,null,false]
[false,null,"4.6.8 DOCUMENTOS PARA CONSTANCIA",null,null,null,null,26]
[null,null,null,null,null,null,null,205]
[null,null,null,31,null,null,null,0.1]
[null,null,"Calculo",{"$f":"H7","v":31},null,null,null,31]
[null,null,null,{"$f":"CONCATENATE(ROUND(D5*IVA,2),\" € c/IVA\")","v":"37,51 € c/IVA"},null,null,null,{"$f":"IF(H5*H4<H2,H2,IF(H5*H4>H3,H3,H5*H4))","v":26}]
[null,null,null,null,null,null,null,{"$f":"IF(H1=TRUE,D4+H6,D4)","v":31}]
[null,null,"URGENTE O RAPIDO"]
[null,null,null,null,null,{"$f":"H6","v":26}]

{"sheet":"4.6.8","index":83,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[[0,2,0,5],[1,2,1,5],[3,2,4,5]]}
[{"$f":"'1'!N17","v":538.79},"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[false,null,"4.6.9 TRABAJOS NO INCLUIDOS ANTERIORMENTE"]
[]
[null,null,"El precio de visado de cualquier tipo de trabajo profesional no incluido en los apartados anteriores se calculará por analogía con el más similar de ellos."]

{"sheet":"TABLAITE","index":84,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Antigüedad de construcción","A","Superficie en m2","DE","Altura en metros","número de plantas","h","Estructura",null,"E"]
["Seleccione valor…",0,"Seleccione valor…",0,"Seleccione valor…",null,0,"Seleccione valor…",1]
["hasta 20 años",1,"hasta 300 m2",1,"hasta 6 m","1 a 2 plantas",1,"Hormigón",2,1]
["de 20 a 40 años",1.25,"de 301 a 600 m2",1.1000000000000001,"de 6 a 12 m","3 a 4 plantas",1.25,"Mixta",3,1.05]
["de 40 a 70 años",1.5,"de 601 a 1.200 m2",1.2,"de 12 a 24 m","5 a 8 plantas",1.5,"Metálica",4,1.1000000000000001]
["de 70 a 100 años",1.75,"de 1.201 a 2.400 m2",1.3,"de 24 a 30 m","8 a 10 plantas",1.75,"Ladrillo-Madera",5,1.2]
["más de 100 años",2,"de 2.401 a 3.600 m2",1.4,"de 30 a 36 m","10 a 12 plantas",2]
[null,null,"de 3.601 a 6.000 m2",1.5,"de 36 a 45 m","12 a 15 plantas",2.25]
[null,null,"de 6.001 a 9.000 m2",1.6,"de 45 a 54 m","15 a 18 plantas",2.5]
[null,null,"de 9.001 a 12.000 m2",1.7,"de 54 a 60 m","18 a 20 plantas",2.75]
[null,null,"de 12.01 a 15.000 m2",1.8,"mas 60m",null,0.1]
[null,null,"de 15.001 a 18.000 m2",1.9]
[null,null,"de 18.001 a 21.000 m2",2]
[null,null,"de 21.001 a 24.000 m2",2.1]
[null,null,"de 24.001 a 27.000 m2",2.2000000000000002]
[null,null,"de 27.001 a 30.000 m2",2.2999999999999998]
[null,null,"más de 30.001 m2",2.4]

{"sheet":"TABLAT","index":85,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":true,"merged":[[0,1,0,5],[1,1,1,5],[3,1,3,2]]}
[null,{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[null,"TABLA T. CÓDIGO DEL TIPO DE TRABAJO"]
[]
[null,"EDIFICACIÓN",null,null,"OTROS DOCUMENTOS Y TRABAJOS DE ARQUITECTURA"]
[null,null,"Nueva planta",null,null,"Estudio básico de seguridad y salud, por el/los arquitecto/s"]
[null,null,"Intervención parcial: ampliación, rehabilitación, reforma…",null,null,"Estudio de seguridad y salud, por el/los arquitecto/s"]
[null,null,"Demolición parcial",null,null,"Coordinación de seguridad y salud, por el/los arquitecto/s"]
[null,null,"Demolición total",null,null,"Deslinde y segregación de terrenos y solares"]
[null,null,"Legalización de edificio u obra",null,null,"Deslinde de edificaciones"]
[null,null,"Proyecto parcial",null,null,"Replanteo"]
[null,null,"Otros",null,null,"Medición de terrenos y solares"]
[null,null,null,null,null,"Medición de edificación"]
[null,"URBANISMO",null,null,null,"Tasación de solares"]
[null,null,"Plan general de ordenación urbana",null,null,"Tasación de terrenos"]
[null,null,"Normas subsidiarias",null,null,"Tasación de edificios"]
[null,null,"Proyectos de delimitación de suelo urbano",null,null,"Tasación parcial de edificios"]
[null,null,"Planes de sectorización y Programas de actuación urbanística",null,null,"Tasación de las rentas"]
[null,null,"Planes parciales",null,null,"Reconocimiento, consulta, andamios"]
[null,null,"Planes especiales de reforma interior",null,null,"Informe, peritaje, dictamen, certificado"]
[null,null,"Estudios de detalle",null,null,"Expediente de actividad e instalaciones"]
[null,null,"Catálogos de bienes y espacios protegidos",null,null,"Arbitraje"]
[null,null,"Estudios y análisis ambientales",null,null,"Expediente de ruina"]
[null,null,"Otros estudios complementarios",null,null,"ITE; Inspección Técnica de Edificios"]
[null,null,"Proyectos de reparcelación",null,null,"IEE; Informe de Evaluación de Edificios"]
[null,null,"Proyectos de expropiación ",null,null,"Trabajo valorado por tiempo"]
[null,null,"Proyectos de cooperación",null,null,"Otros"]
[null,null,"Proyectos de compensación"]
[null,null,"Proyectos de parcelación"]
[null,null,"Obras de urbanización"]
[null,null,"Obras urbanas (intervención parcial)"]
[null,null,"Otros"]

{"sheet":"TABLAU3","index":86,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":true,"merged":[[7,3,7,5],[11,5,11,6],[4,3,4,5],[1,2,1,6],[3,3,3,5],[5,3,5,5],[6,3,6,5]]}
[null,"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[null,null,"TABLA U3 ESTUDIOS Y ANÁLISIS AMBIENTALES"]
[]
[null,null,null,"Fase",null,null,"   %"]
[null,null,null,"Estudio ambiental (información)",null,null,{"$f":"J5","v":0.18},null,false,0.18,{"$f":"IF(I5=TRUE,J5,0)","v":0},{"$f":"IF(I5=TRUE,\"a\",\"-\")","v":"-"}]
[null,null,null,"Análisis ambiental, previo (avance)",null,null,{"$f":"J6","v":0.22},null,false,0.22,{"$f":"IF(I6=TRUE,J6,0)","v":0},{"$f":"IF(I6=TRUE,\"b\",\"-\")","v":"-"}]
[null,null,null,"Análisis ambiental",null,null,{"$f":"J7","v":0.45},null,false,0.45,{"$f":"IF(I7=TRUE,J7,0)","v":0},{"$f":"IF(I7=TRUE,\"c\",\"-\")","v":"-"}]
[null,null,null,"Análisis ambiental, definitivo (aprobación provisional)",null,null,{"$f":"J8","v":0.15},null,false,0.15,{"$f":"IF(I8=TRUE,J8,0)","v":0},{"$f":"IF(I8=TRUE,\"d\",\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K5:K8)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"K9","v":0}]
[null,null,null,null,null,{"$f":"CONCATENATE(L5,L6,L7,L8)","v":"----"}]

{"sheet":"TABLAU4","index":87,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":true,"merged":[[7,3,7,5],[11,5,11,6],[4,3,4,5],[1,2,1,6],[3,3,3,5],[5,3,5,5],[6,3,6,5]]}
[null,"COAM",{"$f":"'1'!B1","v":"PRECIOS DE VISADO PARA LOS TRABAJOS PROFESIONALES v12.02 (21.01.26)"}]
[null,null,"TABLA U4 GESTIÓN URBANÍSTICA: PORCENTAJES POR FASES"]
[]
[null,null,null,"Fase",null,null,"   %"]
[null,null,null,"Bases y estatutos",null,null,{"$f":"J5","v":0.1},null,false,0.1,{"$f":"IF(I5=TRUE,J5,0)","v":0},{"$f":"IF(I5=TRUE,\"a\",\"-\")","v":"-"}]
[null,null,null,"Información y memoria",null,null,{"$f":"J6","v":0.15},null,false,0.15,{"$f":"IF(I6=TRUE,J6,0)","v":0},{"$f":"IF(I6=TRUE,\"b\",\"-\")","v":"-"}]
[null,null,null,"Plano (s) de fincas iniciales y resultantes",null,null,{"$f":"J7","v":0.15},null,false,0.15,{"$f":"IF(I7=TRUE,J7,0)","v":0},{"$f":"IF(I7=TRUE,\"c\",\"-\")","v":"-"}]
[null,null,null,"Descripciones de cada finca (fichas urbanísticas)",null,null,{"$f":"J8","v":0.6},null,false,0.6,{"$f":"IF(I8=TRUE,J8,0)","v":0},{"$f":"IF(I8=TRUE,\"d\",\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K5:K8)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"K9","v":0}]
[null,null,null,null,null,{"$f":"CONCATENATE(L5,L6,L7,L8)","v":"----"}]

{"sheet":"USOS","index":88,"n_rows":68,"n_cols":5,"rows_kept":68,"cut":false,"hidden":true,"merged":[]}
["Seleccione USO… (coeficiente Qv)",null,0,"Coeficiente de minoración"]
["10 RESIDENCIAL: VIVIENDA Y RESIDENCIA COMUNITARIA","NO VALIDO","-","Intervención Completa",1]
["    Edificio de viviendas, incluyendo zonas comunes","10 01",1.2,"Estructura",0.4]
["    Unifamiliar","10 02",1.5,"Estructura, instalaciones, albañileria y acabados",0.9]
["    Residencia comunitaria: estudiantes, 3ª edad","10 03",1.5,"Instalaciones, albañileria y acabados",0.7]
["11 HOSTELERÍA","NO VALIDO","-","Albañileria y acabados",0.5]
["    Hotel, apartotel y apartamentos turísticos 4* o mas","11 01",2.2999999999999998,"Acabados",0.3]
["    Hoteles, apartotel y otros aloj. turísticos de 3*","11 02",2]
["    Hoteles, apartotel y otros aloj. turísticos de 2* o menos","11 03",1.6]
["12 APARCAMIENTO Y DEPENDENCIAS AUXILIARES","NO VALIDO","-"]
["    Soportales, porches cubiertos, sótanos y bajo cubierta no vivideros","12 01",0.8]
["    Garaje al aire libre, descubierto o con visera","12 02",0.3]
["    Garaje en planta baja o semisótano","12 03",0.8]
["    Garaje en sótano/s, o planta 1 o superior","12 04",1]
["13. OFICINAS Y ADMINISTRATIVO","NO VALIDO","-"]
["    Locales de oficinas sin instalaciones","13 01",0.8]
["    Locales de oficinas con instalaciones y acabados","13 02",1.6]
["    Edificios de oficinas y comercial, administrasción pública","13 03",2]
["    Edificio en parque empresarial, sede institucional o ministerial","13 04",2.4]
["14. COMERCIAL","NO VALIDO","-"]
["    Locales comerciales sin instalaciones","14 01",0.7]
["    Locales comerciales con instalaciones y acabados","14 02",1.4]
["    Gran almacén, edificio en parque comercial","14 03",2.4]
["15. INDUSTRIAL","NO VALIDO","-"]
["    Nave industrial, almacén sin instalaciones","15 01",0.6]
["    Nave industrial, almacén con instalaciones ","15 02",0.8]
["    Edificio industrial o almacén  de 2 o más plantas","15 03",1.3]
["    Sede en parque industrial, laboratorios","15 04",2.4]
["16. RESTAURACIÓN","NO VALIDO","-"]
["    Casa de comidas, bar, taberna","16 01",1.3]
["    Cafetería, pub, autoservicio, restaurante < 3 tenedores","16 02",1.5]
["    Restaurante 3 o mas tenedores","16 03",2]
["17. SANITARIO","NO VALIDO","-"]
["    Centro de salud, ambulatorio, clínica, consulta","17 01",1.5]
["    Clínica o centro médico o asistencial en edificio exclusivo","17 02",2.4]
["    Hospital","17 03",3]
["18. REUNIÓN OCIO Y ESPECTÁCULOS","NO VALIDO","-"]
["    Colegio, instituto, academia, guardería, pre-escolar","18 01",1.4]
["    Formación profesional, artes y oficios, centro especializado…","18 02",1.7]
["    Universidad o investigación","18 03",2.2000000000000002]
["    Centro cívico o social < 500 m2, salas juego o recreo","18 04",1.3]
["    Biblioteca, sala reunión-exposiciones","18 05",1.8]
["    Centro cultural < 1000 m2; club o sede social en edificio exclusivo","18 06",2]
["    Centro cultural 1.000 a 2.000 m2; teatro, cine, discoteca","18 07",2.2999999999999998]
["    Centro cultural > 2.000 m2; edificio en parque temático","18 08",3]
["    Museo, auditorio, edificio de congresos","18 09",3.5]
["19. DEPORTIVO","NO VALIDO","-"]
["    Pista deportiva de hierba o especial, drenada, campos de golf","19 01",0.4]
["    Instalación semicerrada (frontón...)","19 02",0.8]
["    Piscina no cubierta","19 03",1.1000000000000001]
["    Polideportivo < 1.000 m2","19 04",1.2]
["    Centro polideportivo 1.000 a 5.000 m2, piscina cubierta","19 05",2.1]
["    Centro polideportivo > 5.000 m2","19 06",2.4]
["20. RELIGIOSO  Y FUNERARIO","NO VALIDO","-"]
["    Local de culto","20 01",1.4]
["    Centro de culto en edificio exclusivo","20 02",2]
["    Tanatorio, crematorio","20 03",1.7]
["21. TRANSPORTES (áreas cubiertas)","NO VALIDO","-"]
["    Estación de servicio, marquesina, estación de autobuses","21 01",1.7]
["    Intercambiador, estación ferroviaria o de metro ","21 02",2.8]
["22. URBANIZACIÓN  Y ACONDICIONAMIENTO DE TERRENOS","NO VALIDO","-"]
["    Espacios acondicionados no cubiertos","22 01",0.2]
["    Zonas cubiertas para instalaciones al aire libre","22 02",1.2]
["    Graderío descubierto","22 03",0.8]
["    Graderío cubierto","22 04",2]
["    Tratamiento de suelo natural en parcela o urbano","22 05",0.05]
["    Ajardinamiento","22 06",0.1]
["    Viario","22 07",0.3]

{"sheet":"JCALCULO","index":89,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,"REDONDEO 1","REDONDEO 2","SIN REDONDEO","FORMULA A EMPLEAR"]
[]
[null,null,299,null,{"$f":"ROUND((2.6+10.2*((200/C5)^0.2)),1)","v":12},{"$f":"ROUND((2.6+10.2*((200/C5)^0.2)),2)","v":12.01},{"$f":"2.6+10.2*((200/C5)^0.2)","v":12.011783602316235},{"$f":"IF(G5>11.75,11.75,IF(G5<4.457,4.45,ROUND(G5,1)))","v":11.75}]
[null,null,300,11.75,{"$f":"ROUND((2.6+10.2*((200/C6)^0.2)),1)","v":12},{"$f":"ROUND((2.6+10.2*((200/C6)^0.2)),2)","v":12.01},{"$f":"2.6+10.2*((200/C6)^0.2)","v":12.005500697113622},11.75]
[null,null,301,null,12,12,11.999242873409695,11.75]
[null,null,344.29,null,null,null,11.750004110322426,11.75]
[null,null,400,11.5,11.5,11.48,11.479615745620466,11.5]
[null,null,600,10.8,10.8,10.79,10.787963929954353,10.8]
[null,null,800,10.3,10.3,10.33,10.33015448920303,10.3]
[null,null,1000,10,10,9.99,9.9927525695124935,10]
[null,null,2000,9,9,9.0399999999999991,9.035764913697971,9]
[null,null,3000,8.6,8.5,8.5299999999999994,8.5344697433574179,8.5]
[null,null,5000,8,8,7.96,7.9581167209836838,8]
[null,null,8000,7.5,7.5,7.48,7.4773977489291887,7.5]
[null,null,12000,7.1,7.1,7.1,7.0974870517307735,7.1]
[null,null,20000,6.7,6.7,6.66,6.6606931396456712,6.7]
[null,null,35000,6.2,6.2,6.23,6.2307183654121445,6.2]
[null,null,80000,5.7,5.7,5.68,5.6774299316380326,5.7]
[null,null,120000,5.4,5.4,5.44,5.4377224869941028,5.4]
[null,null,200000,5.2,5.2,5.16,5.162124160139772,5.2]
[null,null,400000,4.8,4.8,4.83,4.8304586308442872,4.8]
[null,null,700000,4.5999999999999996,4.5999999999999996,4.59,4.5942819700493329,4.5999999999999996]
[null,null,999934.01,null,4.5,4.46,4.4569999964195111,4.45]
[null,null,999999,null,4.5,4.46,4.4569758584819219,4.45]
[null,null,1000000,4.45,4.5,4.46,4.4569754870866012,4.45]
[null,null,1000001,null,4.5,4.46,4.4569751156917281,{"$f":"IF(G28>11.75,11.75,IF(G28<4.457,4.45,ROUND(G28,1)))","v":4.45}]
[null,null,"=SI(G6>11,75;11,75;SI(G6<4,457;4,45;REDONDEAR(2,6+10,2*((200/C5)^0,2);1)))"]