{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["PRECIO DE VISADO","COEFICIENTES TIPOLOGICOS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":70,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PRECIO DE VISADO","index":0,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Descripción identificativa",null,null,null,null,null,"EXP"]
[]
[{"$f":"HYPERLINK(\"#\"&CELL(\"direccion\",B5)&\":\"&CELL(\"direccion\",F16),\"≡\")","v":"≡"},"Uso","Tipología (T)","Variante (V)","Sup (m²)","Parcial","T","V","Vref","slug"]
[null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(Tabla1[[#This Row],[Tipología (T)]],INDIRECT(Tabla1[[#This Row],[slug]]&\"a\"),INDIRECT(Tabla1[[#This Row],[slug]]&\"b\"),\"\"),\"\")","v":""},{"$f":"IFERROR(_xlfn.XLOOKUP(Tabla1[[#This Row],[Variante (V)]],INDIRECT(Tabla1[[#This Row],[slug]]&\"c\"),INDIRECT(Tabla1[[#This Row],[slug]]&\"d\"),\"\"),\"\")","v":""},{"$f":"IFERROR(Tabla1[[#This Row],[Sup (m²)]]*Tabla1[[#This Row],[T]]*IF(Tabla1[[#This Row],[V]]=\"\",1,Tabla1[[#This Row],[V]])*IF(Tabla1[[#This Row],[Parcial]]=\"\",1,Tabla1[[#This Row],[Parcial]]),\"\")","v":""},{"$f":"LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Tabla1[[#This Row],[Uso]],\"Residencial\",\"\"),\" \",\"\"),\"á\",\"a\"),\"é\",\"e\"),\"í\",\"i\"),\"ó\",\"o\"),\"ú\",\"u\"))&\"_\"","v":"_"}]
[null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(Tabla1[[#This Row],[Tipología (T)]],INDIRECT(Tabla1[[#This Row],[slug]]&\"a\"),INDIRECT(Tabla1[[#This Row],[slug]]&\"b\"),\"\"),\"\")","v":""},{"$f":"IFERROR(_xlfn.XLOOKUP(Tabla1[[#This Row],[Variante (V)]],INDIRECT(Tabla1[[#This Row],[slug]]&\"c\"),INDIRECT(Tabla1[[#This Row],[slug]]&\"d\"),\"\"),\"\")","v":""},{"$f":"IFERROR(Tabla1[[#This Row],[Sup (m²)]]*Tabla1[[#This Row],[T]]*IF(Tabla1[[#This Row],[V]]=\"\",1,Tabla1[[#This Row],[V]])*IF(Tabla1[[#This Row],[Parcial]]=\"\",1,Tabla1[[#This Row],[Parcial]]),\"\")","v":""},{"$f":"LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Tabla1[[#This Row],[Uso]],\"Residencial\",\"\"),\" \",\"\"),\"á\",\"a\"),\"é\",\"e\"),\"í\",\"i\"),\"ó\",\"o\"),\"ú\",\"u\"))&\"_\"","v":"_"}]
[null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(Tabla1[[#This Row],[Tipología (T)]],INDIRECT(Tabla1[[#This Row],[slug]]&\"a\"),INDIRECT(Tabla1[[#This Row],[slug]]&\"b\"),\"\"),\"\")","v":""},{"$f":"IFERROR(_xlfn.XLOOKUP(Tabla1[[#This Row],[Variante (V)]],INDIRECT(Tabla1[[#This Row],[slug]]&\"c\"),INDIRECT(Tabla1[[#This Row],[slug]]&\"d\"),\"\"),\"\")","v":""},{"$f":"IFERROR(Tabla1[[#This Row],[Sup (m²)]]*Tabla1[[#This Row],[T]]*IF(Tabla1[[#This Row],[V]]=\"\",1,Tabla1[[#This Row],[V]])*IF(Tabla1[[#This Row],[Parcial]]=\"\",1,Tabla1[[#This Row],[Parcial]]),\"\")","v":""},{"$f":"LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Tabla1[[#This Row],[Uso]],\"Residencial\",\"\"),\" \",\"\"),\"á\",\"a\"),\"é\",\"e\"),\"í\",\"i\"),\"ó\",\"o\"),\"ú\",\"u\"))&\"_\"","v":"_"}]
[null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(Tabla1[[#This Row],[Tipología (T)]],INDIRECT(Tabla1[[#This Row],[slug]]&\"a\"),INDIRECT(Tabla1[[#This Row],[slug]]&\"b\"),\"\"),\"\")","v":""},{"$f":"IFERROR(_xlfn.XLOOKUP(Tabla1[[#This Row],[Variante (V)]],INDIRECT(Tabla1[[#This Row],[slug]]&\"c\"),INDIRECT(Tabla1[[#This Row],[slug]]&\"d\"),\"\"),\"\")","v":""},{"$f":"IFERROR(Tabla1[[#This Row],[Sup (m²)]]*Tabla1[[#This Row],[T]]*IF(Tabla1[[#This Row],[V]]=\"\",1,Tabla1[[#This Row],[V]])*IF(Tabla1[[#This Row],[Parcial]]=\"\",1,Tabla1[[#This Row],[Parcial]]),\"\")","v":""},{"$f":"LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Tabla1[[#This Row],[Uso]],\"Residencial\",\"\"),\" \",\"\"),\"á\",\"a\"),\"é\",\"e\"),\"í\",\"i\"),\"ó\",\"o\"),\"ú\",\"u\"))&\"_\"","v":"_"}]
[null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(Tabla1[[#This Row],[Tipología (T)]],INDIRECT(Tabla1[[#This Row],[slug]]&\"a\"),INDIRECT(Tabla1[[#This Row],[slug]]&\"b\"),\"\"),\"\")","v":""},{"$f":"IFERROR(_xlfn.XLOOKUP(Tabla1[[#This Row],[Variante (V)]],INDIRECT(Tabla1[[#This Row],[slug]]&\"c\"),INDIRECT(Tabla1[[#This Row],[slug]]&\"d\"),\"\"),\"\")","v":""},{"$f":"IFERROR(Tabla1[[#This Row],[Sup (m²)]]*Tabla1[[#This Row],[T]]*IF(Tabla1[[#This Row],[V]]=\"\",1,Tabla1[[#This Row],[V]])*IF(Tabla1[[#This Row],[Parcial]]=\"\",1,Tabla1[[#This Row],[Parcial]]),\"\")","v":""},{"$f":"LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Tabla1[[#This Row],[Uso]],\"Residencial\",\"\"),\" \",\"\"),\"á\",\"a\"),\"é\",\"e\"),\"í\",\"i\"),\"ó\",\"o\"),\"ú\",\"u\"))&\"_\"","v":"_"}]
[null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(Tabla1[[#This Row],[Tipología (T)]],INDIRECT(Tabla1[[#This Row],[slug]]&\"a\"),INDIRECT(Tabla1[[#This Row],[slug]]&\"b\"),\"\"),\"\")","v":""},{"$f":"IFERROR(_xlfn.XLOOKUP(Tabla1[[#This Row],[Variante (V)]],INDIRECT(Tabla1[[#This Row],[slug]]&\"c\"),INDIRECT(Tabla1[[#This Row],[slug]]&\"d\"),\"\"),\"\")","v":""},{"$f":"IFERROR(Tabla1[[#This Row],[Sup (m²)]]*Tabla1[[#This Row],[T]]*IF(Tabla1[[#This Row],[V]]=\"\",1,Tabla1[[#This Row],[V]])*IF(Tabla1[[#This Row],[Parcial]]=\"\",1,Tabla1[[#This Row],[Parcial]]),\"\")","v":""},{"$f":"LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Tabla1[[#This Row],[Uso]],\"Residencial\",\"\"),\" \",\"\"),\"á\",\"a\"),\"é\",\"e\"),\"í\",\"i\"),\"ó\",\"o\"),\"ú\",\"u\"))&\"_\"","v":"_"}]
[null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(Tabla1[[#This Row],[Tipología (T)]],INDIRECT(Tabla1[[#This Row],[slug]]&\"a\"),INDIRECT(Tabla1[[#This Row],[slug]]&\"b\"),\"\"),\"\")","v":""},{"$f":"IFERROR(_xlfn.XLOOKUP(Tabla1[[#This Row],[Variante (V)]],INDIRECT(Tabla1[[#This Row],[slug]]&\"c\"),INDIRECT(Tabla1[[#This Row],[slug]]&\"d\"),\"\"),\"\")","v":""},{"$f":"IFERROR(Tabla1[[#This Row],[Sup (m²)]]*Tabla1[[#This Row],[T]]*IF(Tabla1[[#This Row],[V]]=\"\",1,Tabla1[[#This Row],[V]])*IF(Tabla1[[#This Row],[Parcial]]=\"\",1,Tabla1[[#This Row],[Parcial]]),\"\")","v":""},{"$f":"LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Tabla1[[#This Row],[Uso]],\"Residencial\",\"\"),\" \",\"\"),\"á\",\"a\"),\"é\",\"e\"),\"í\",\"i\"),\"ó\",\"o\"),\"ú\",\"u\"))&\"_\"","v":"_"}]
[null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(Tabla1[[#This Row],[Tipología (T)]],INDIRECT(Tabla1[[#This Row],[slug]]&\"a\"),INDIRECT(Tabla1[[#This Row],[slug]]&\"b\"),\"\"),\"\")","v":""},{"$f":"IFERROR(_xlfn.XLOOKUP(Tabla1[[#This Row],[Variante (V)]],INDIRECT(Tabla1[[#This Row],[slug]]&\"c\"),INDIRECT(Tabla1[[#This Row],[slug]]&\"d\"),\"\"),\"\")","v":""},{"$f":"IFERROR(Tabla1[[#This Row],[Sup (m²)]]*Tabla1[[#This Row],[T]]*IF(Tabla1[[#This Row],[V]]=\"\",1,Tabla1[[#This Row],[V]])*IF(Tabla1[[#This Row],[Parcial]]=\"\",1,Tabla1[[#This Row],[Parcial]]),\"\")","v":""},{"$f":"LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Tabla1[[#This Row],[Uso]],\"Residencial\",\"\"),\" \",\"\"),\"á\",\"a\"),\"é\",\"e\"),\"í\",\"i\"),\"ó\",\"o\"),\"ú\",\"u\"))&\"_\"","v":"_"}]
[null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(Tabla1[[#This Row],[Tipología (T)]],INDIRECT(Tabla1[[#This Row],[slug]]&\"a\"),INDIRECT(Tabla1[[#This Row],[slug]]&\"b\"),\"\"),\"\")","v":""},{"$f":"IFERROR(_xlfn.XLOOKUP(Tabla1[[#This Row],[Variante (V)]],INDIRECT(Tabla1[[#This Row],[slug]]&\"c\"),INDIRECT(Tabla1[[#This Row],[slug]]&\"d\"),\"\"),\"\")","v":""},{"$f":"IFERROR(Tabla1[[#This Row],[Sup (m²)]]*Tabla1[[#This Row],[T]]*IF(Tabla1[[#This Row],[V]]=\"\",1,Tabla1[[#This Row],[V]])*IF(Tabla1[[#This Row],[Parcial]]=\"\",1,Tabla1[[#This Row],[Parcial]]),\"\")","v":""},{"$f":"LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Tabla1[[#This Row],[Uso]],\"Residencial\",\"\"),\" \",\"\"),\"á\",\"a\"),\"é\",\"e\"),\"í\",\"i\"),\"ó\",\"o\"),\"ú\",\"u\"))&\"_\"","v":"_"}]
[null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(Tabla1[[#This Row],[Tipología (T)]],INDIRECT(Tabla1[[#This Row],[slug]]&\"a\"),INDIRECT(Tabla1[[#This Row],[slug]]&\"b\"),\"\"),\"\")","v":""},{"$f":"IFERROR(_xlfn.XLOOKUP(Tabla1[[#This Row],[Variante (V)]],INDIRECT(Tabla1[[#This Row],[slug]]&\"c\"),INDIRECT(Tabla1[[#This Row],[slug]]&\"d\"),\"\"),\"\")","v":""},{"$f":"IFERROR(Tabla1[[#This Row],[Sup (m²)]]*Tabla1[[#This Row],[T]]*IF(Tabla1[[#This Row],[V]]=\"\",1,Tabla1[[#This Row],[V]])*IF(Tabla1[[#This Row],[Parcial]]=\"\",1,Tabla1[[#This Row],[Parcial]]),\"\")","v":""},{"$f":"LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Tabla1[[#This Row],[Uso]],\"Residencial\",\"\"),\" \",\"\"),\"á\",\"a\"),\"é\",\"e\"),\"í\",\"i\"),\"ó\",\"o\"),\"ú\",\"u\"))&\"_\"","v":"_"}]
[null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(Tabla1[[#This Row],[Tipología (T)]],INDIRECT(Tabla1[[#This Row],[slug]]&\"a\"),INDIRECT(Tabla1[[#This Row],[slug]]&\"b\"),\"\"),\"\")","v":""},{"$f":"IFERROR(_xlfn.XLOOKUP(Tabla1[[#This Row],[Variante (V)]],INDIRECT(Tabla1[[#This Row],[slug]]&\"c\"),INDIRECT(Tabla1[[#This Row],[slug]]&\"d\"),\"\"),\"\")","v":""},{"$f":"IFERROR(Tabla1[[#This Row],[Sup (m²)]]*Tabla1[[#This Row],[T]]*IF(Tabla1[[#This Row],[V]]=\"\",1,Tabla1[[#This Row],[V]])*IF(Tabla1[[#This Row],[Parcial]]=\"\",1,Tabla1[[#This Row],[Parcial]]),\"\")","v":""},{"$f":"LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Tabla1[[#This Row],[Uso]],\"Residencial\",\"\"),\" \",\"\"),\"á\",\"a\"),\"é\",\"e\"),\"í\",\"i\"),\"ó\",\"o\"),\"ú\",\"u\"))&\"_\"","v":"_"}]
[null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(Tabla1[[#This Row],[Tipología (T)]],INDIRECT(Tabla1[[#This Row],[slug]]&\"a\"),INDIRECT(Tabla1[[#This Row],[slug]]&\"b\"),\"\"),\"\")","v":""},{"$f":"IFERROR(_xlfn.XLOOKUP(Tabla1[[#This Row],[Variante (V)]],INDIRECT(Tabla1[[#This Row],[slug]]&\"c\"),INDIRECT(Tabla1[[#This Row],[slug]]&\"d\"),\"\"),\"\")","v":""},{"$f":"IFERROR(Tabla1[[#This Row],[Sup (m²)]]*Tabla1[[#This Row],[T]]*IF(Tabla1[[#This Row],[V]]=\"\",1,Tabla1[[#This Row],[V]])*IF(Tabla1[[#This Row],[Parcial]]=\"\",1,Tabla1[[#This Row],[Parcial]]),\"\")","v":""},{"$f":"LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Tabla1[[#This Row],[Uso]],\"Residencial\",\"\"),\" \",\"\"),\"á\",\"a\"),\"é\",\"e\"),\"í\",\"i\"),\"ó\",\"o\"),\"ú\",\"u\"))&\"_\"","v":"_"}]
[]
[null,"Fase/s a liquidar = ",null,"Nº edificios idénticos que se repiten =  ",null,null,null,"Vref (total) =",{"$f":"SUM(Tabla1[Vref])+(D20/832.62)","v":0}]
[]
[null,null,"PEM (actuaciones no sujetas a critierios de superficie y tipología) : ",null,null,null,null,"c (curvatura)",0.56999999999999995]
[null,{"$f":"IF(C18=\"\",1,_xlfn.XLOOKUP(C18,fases_a,fases_b))","v":1},null,null,null,null,null,"e (elevación)",3.87]
[]
[null,null,null,null,null,null,null,{"$f":"\"Precio de Visado = \"&(IF(B21=1,\"100% (fases completas) · \",TEXT(B21,\"0,00%\")&\" (fase) · \")&IF(I18=0,\"Vref\",TEXT(I18,\"#.###,00\"))&\" · [ \"&TEXT(I21,\"0,00\")&\" – \"&TEXT(I20,\"0,00\")&\" · log ( \"&IF(I18=0,\"Vref\",TEXT(I18,\"#.###,00\"))&\" ) ] · \"&IF(AND(I18=0,E18=\"\"),\"K\",IF(E18<10,1,TEXT(MAX(0.5,1-((E18-1)/200)),\"0,##\")))&\" =\")","v":"Precio de Visado = 100% (fases completas) · Vref · [ 3,87 – 0,57 · log ( Vref ) ] · K ="},{"$f":"IF(I18=0,0,I18*(I21-I20*LOG(I18))*IF(E18<10,1,MAX(0.5, 1-((E18-1)/200)))*IF(C18=\"\",1,_xlfn.XLOOKUP(C18,fases_a,fases_b)))","v":0}]

{"sheet":"COEFICIENTES TIPOLOGICOS","index":1,"n_rows":300,"n_cols":6,"rows_kept":300,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"791.31","v":791.31},null,null,"Coeficientes tipológicos (T) y variantes (V)"]
[]
[null,null,null,null,"Uso"]
[null,null,null,null,"Residencial viviendas"]
[null,null,null,null,"Residencial comunitario"]
[null,null,null,null,"Aparcamientos"]
[null,null,null,null,"Comercial"]
[null,null,null,null,"Oficinas"]
[null,null,null,null,"Turístico"]
[null,null,null,null,"Sociosanitario"]
[null,null,null,null,"Sociocultural"]
[null,null,null,null,"Deportivo"]
[null,null,null,null,"Industrial"]
[null,null,null,null,"Otros usos"]
[null,null,null,null,"Urbanización"]
[]
[null,null,null,null,"Residencial viviendas"]
[null,null,null,"T","Tipologías"]
[null,{"$f":"TRUE()","v":true},null,null,"Vivienda unif. aislada",1.45]
[null,{"$f":"TRUE()","v":true},null,null,"Vivienda unif. pareada o en hilera",1.26]
[null,{"$f":"TRUE()","v":true},null,null,"Vivienda unif. entre medianeras",1.1200000000000001]
[null,{"$f":"TRUE()","v":true},null,null,"Bloque de viviendas aislado",1.23]
[null,{"$f":"TRUE()","v":true},null,null,"Bloque de viviendas entre medianeras",1.1200000000000001]
[null,null,null,"V","Variantes"]
[null,null,null,null,"Viviendas < 70 m²",0.9]
[null,null,null,null,"Viviendas ≥ 70 < 130 m²",1]
[null,null,null,null,"Viviendas ≥ 130 < 180 m²",1.1000000000000001]
[null,null,null,null,"Viviendas ≥ 180 m²",1.2]
[null,null,null,null,"Soportales o terrazas cubiertas",0.45]
[null,null,null,null,"Trasteros / Lavaderos / Auxiliares",0.8]
[]
[null,null,null,null,"Residencial comunitario"]
[null,null,null,"T","Tipologías"]
[null,null,null,null,"Residencia de estudiantes",1.41]
[null,null,null,null,"Residencia de mayores",1.64]
[null,null,null,null,"Viviendas colaborativas (coliving / cohousing)",1.41]
[null,null,null,"V","Variantes"]
[null,null,null,null,"Superficie < 10.000 m²",1]
[null,null,null,null,"Superficie ≥ 10.000 m²",1.1000000000000001]
[null,null,null,null,"Soportales o terrazas cubiertas",0.45]
[null,null,null,null,"Sótano de servicio o instalaciones",0.8]
[]
[null,null,null,null,"Aparcamientos"]
[null,null,null,"T","Tipologías"]
[null,{"$f":"TRUE()","v":true},null,null,"Aparcamientos en edificios",0.84]
[null,{"$f":"FALSE()","v":false},null,null,"Aparcamientos al aire libre descubiertos",0.23]
[null,{"$f":"FALSE()","v":false},null,null,"Aparcamientos al aire libre cubiertos",0.3]
[null,null,null,"V","Variantes"]
[null,null,null,null,"En plantas sobre rasante",1]
[null,null,null,null,"En plantas bajo rasante -1",1.05]
[null,null,null,null,"En plantas bajo rasante ≥ -2",1.1000000000000001]
[]
[null,null,null,null,"Comercial"]
[null,null,null,"T","Tipologías"]
[null,{"$f":"TRUE()","v":true},null,null,"Local hostelería / Sala de fiesta",1.35]
[null,{"$f":"TRUE()","v":true},null,null,"Local comercial acondicionado en edificio",1.1599999999999999]
[null,{"$f":"TRUE()","v":true},null,null,"Local comercial sin acondicionar en edificio",0.9]
[null,{"$f":"TRUE()","v":true},null,null,"Centro comercial con locales acondicionados",1.46]
[null,{"$f":"TRUE()","v":true},null,null,"Centro comercial con locales sin acondicionar",1.22]
[null,null,null,"V","Variantes"]
[null,null,null,null,"Superficie < 10.000 m²",1]
[null,null,null,null,"Superficie ≥ 10.000 m²",1.1000000000000001]
[null,null,null,null,"Soportales o terrazas cubiertas",0.45]
[null,null,null,null,"Sótano de servicio o instalaciones",0.8]
[]
[null,null,null,null,"Oficinas  / administrativo"]
[null,null,null,"T","Tipologías"]
[null,{"$f":"FALSE()","v":false},null,null,"Oficinas en edificios de viviendas",1.05]
[null,{"$f":"TRUE()","v":true},null,null,"Edificio de oficinas",1.45]
[null,null,null,"V","Variantes"]
[null,null,null,null,"Superficie < 10.000 m²",1]
[null,null,null,null,"Superficie ≥ 10.000 m²",1.1000000000000001]
[null,null,null,null,"Soportales o terrazas cubiertas",0.45]
[null,null,null,null,"Sótano de servicio o instalaciones",0.8]
[]
[null,null,null,null,"Turístico"]
[null,null,null,"T","Tipologías"]
[null,{"$f":"TRUE()","v":true},null,null,"Hotel / Hotel urbano / Hotel rural",1.53]
[null,{"$f":"TRUE()","v":true},null,null,"Bloque de apartamentos",1.27]
[null,{"$f":"FALSE()","v":false},null,null,"Villa aislada",1.35]
[null,null,null,null,"Villa pareada o en hilera",1.29]
[null,null,null,null,"Vivienda vacacional",1.45]
[null,{"$f":"FALSE()","v":false},null,null,"Casa rural",1.35]
[null,null,null,"V","Variantes"]
[null,null,null,null,"5 estrellas gran lujo",1.47]
[null,null,null,null,"5 estrellas",1.31]
[null,null,null,null,"4 estrellas",1.17]
[null,null,null,null,"3 estrellas o categoría única",1]
[null,null,null,null,"Emblemático",1.25]
[null,null,null,null,"Soportales o terrazas cubiertas",0.45]
[null,null,null,null,"Sótano de servicio o instalaciones",0.8]
[]
[null,null,null,null,"Sociosanitario"]
[null,null,null,"T","Tipologías"]
[null,{"$f":"TRUE()","v":true},null,null,"Hospital / Clínica",1.97]
[null,{"$f":"TRUE()","v":true},null,null,"Centro de salud / Consultorio / Ambulatorio",1.64]
[null,{"$f":"TRUE()","v":true},null,null,"Centro asistencial  / Centro socio-sanitario",1.64]
[null,null,null,"V","Variantes"]
[null,null,null,null,"Superficie < 10.000 m²",1]
[null,null,null,null,"Superficie ≥ 10.000 m²",1.1000000000000001]
[null,null,null,null,"Soportales o terrazas cubiertas",0.45]
[null,null,null,null,"Sótano de servicio o instalaciones",0.8]
[]
[null,null,null,null,"Sociocultural"]
[null,null,null,"T","Tipologías"]
[null,{"$f":"TRUE()","v":true},null,null,"Local social o cultural en edificio",1.1499999999999999]
[null,{"$f":"TRUE()","v":true},null,null,"Centro social o cultural",1.4]
[null,{"$f":"TRUE()","v":true},null,null,"Centro educativo",1.3]
[null,{"$f":"TRUE()","v":true},null,null,"Museo / Auditorio / Sala de congresos / Teatro / Cine",2]
[null,null,null,"V","Variantes"]
[null,null,null,null,"Superficie < 10.000 m²",1]
[null,null,null,null,"Superficie ≥ 10.000 m²",1.1000000000000001]
[null,null,null,null,"Soportales o terrazas cubiertas",0.45]
[null,null,null,null,"Sótano de servicio o instalaciones",0.8]
[]
[null,null,null,null,"Deportivo"]
[null,null,null,"T","Tipologías"]
[null,{"$f":"FALSE()","v":false},null,null,"Cancha, campo de juego, o pista no cubierta",0.22]
[null,{"$f":"FALSE()","v":false},null,null,"Cancha, campo de juego, o pista cubierta",1.1000000000000001]
[null,{"$f":"FALSE()","v":false},null,null,"Piscina no cubierta",1]
[null,{"$f":"TRUE()","v":true},null,null,"Piscina cubierta",1.55]
[null,null,null,null,"Pabellón polideportivo",1.4]
[null,{"$f":"TRUE()","v":true},null,null,"Estadio (campo de juego aparte)",1.65]
[null,null,null,"V","Variantes"]
[null,null,null,null,"Superficie < 10.000 m²",1]
[null,null,null,null,"Superficie ≥ 10.000 m²",1.1000000000000001]
[null,null,null,null,"Soportales o terrazas cubiertas",0.45]
[null,null,null,null,"Sótano de servicio o instalaciones",0.8]
[]
[null,null,null,null,"Industrial / agrícola"]
[null,null,null,"T","Tipologías"]
[null,{"$f":"TRUE()","v":true},null,null,"Cobertizo sin cerrar",0.23]
[null,{"$f":"TRUE()","v":true},null,null,"Almacén / Agrícola",0.46]
[null,{"$f":"TRUE()","v":true},null,null,"Nave de producción",0.52]
[null,null,null,"V","Variantes"]
[null,null,null,null,"Luces < 10 metros",1]
[null,null,null,null,"Luces ≥ 10 metros",1.1000000000000001]
[]
[null,null,null,null,"Otros usos"]
[null,null,null,"T","Tipologías"]
[null,{"$f":"TRUE()","v":true},null,null,"Templo",1.55]
[null,{"$f":"TRUE()","v":true},null,null,"Tanatorio",1.6]
[null,{"$f":"TRUE()","v":true},null,null,"Estación de transporte de pasajeros",1.73]
[null,{"$f":"TRUE()","v":true},null,null,"Estación de servicio cubierta / Marquesina",0.43]
[null,{"$f":"FALSE()","v":false},null,null,"Talleres",0.84]
[null,null,null,null,"Parques de bomberos",1.34]
[null,null,null,null,"Centro penitenciario ",1.65]
[null,{"$f":"TRUE()","v":true},null,null,"Nichos funerarios (sup. por piso de enterramiento)",0.26]
[null,null,null,"V","Variantes"]
[null,null,null,null,"Superficie < 10.000 m²",1]
[null,null,null,null,"Superficie ≥ 10.000 m²",1.1000000000000001]
[null,null,null,null,"Soportales o terrazas cubiertas",0.45]
[null,null,null,null,"Sótano de servicio o instalaciones",0.8]
[]
[null,null,null,null,"Urbanización"]
[null,null,null,"T","Tipologías"]
[null,{"$f":"FALSE()","v":false},null,null,"Plazas, parques y jardines",0.28000000000000003]
[null,null,null,null,"Jardines en establecimientos turísticos",0.32]
[null,{"$f":"FALSE()","v":false},null,null,"Urbanización de calles",0.23]
[null,{"$f":"FALSE()","v":false},null,null,"Acondicionamiento de terreno",7.0000000000000007E-2]
[null,null,null,"V","Variantes"]
[null,null,null,null,"Pendiente < 20%",1]
[null,null,null,null,"Pendiente ≥ 20% < 40%",1.1000000000000001]
[null,null,null,null,"Pendiente ≥ 40% < 60%",1.2]
[null,null,null,null,"Pendiente ≥ 60%",1.3]
[]
[]
[null,null,null,null,"Liquidación por fases"]
[]
[null,null,null,null,"Estudio previo",6.25E-2]
[null,null,null,null,"Anteproyecto",0.1875]
[null,null,null,null,"Anteproyecto (solo fase sin previa)",0.125]
[null,null,null,null,"Proy. Básico",0.375]
[null,null,null,null,"Proy. básico (solo fase sin previas)",0.1875]
[null,null,null,null,"Proy. de ejecución",1]
[null,null,null,null,"Proy. de ejecución (solo fase sin previas)",0.625]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"No hay variantes para esta tipología"]
[null,null,null,null,"Logaritmo Base",{"$f":"2/5","v":0.4}]
[null,null,null,null,"Logaritmo Elevación",25.8]
[null,null,null,null,"Divisor",44]
[]
[]
["Comprobación (log)",null,null,null,"PEM","CPEM"]
[]
[{"$f":"(LOG(E243,$F$236)+$F$237)/$F$238","v":0.33999955768821549},{"$f":"E243*F243/100","v":70.009399999999999},null,null,{"$f":"ROUND(POWER($F$236,((F243*$F$238)-$F$237)),0)","v":20591},0.34]
[{"$f":"(LOG(E244,$F$236)+$F$237)/$F$238","v":0.33500031808737174},84.383150000000001,null,null,{"$f":"ROUND(POWER($F$236,((F244*$F$238)-$F$237)),0)","v":25189},{"$f":"F243-0.005","v":0.33500000000000002}]
[0.33000006429440404,101.68950000000001,null,null,30815,{"$f":"F244-0.005","v":0.33}]
[0.32500018904975786,122.51524999999999,null,null,37697,0.32500000000000001]
[0.31999976320039286,147.5744,null,null,46117,0.32]
[0.31500008069540353,177.71040000000002,null,null,56416,0.315]
[0.31000004114497259,213.9496,null,null,69016,0.31]
[0.30500002958912226,257.51149999999996,null,null,84430,0.30499999999999999]
[0.29999991123980002,309.86099999999999,null,null,{"$f":"ROUND(POWER($F$236,((F251*$F$238)-$F$237)),0)","v":103287},0.3]
[0.29499991313737389,372.74725000000001,null,null,{"$f":"ROUND(POWER($F$236,((F252*$F$238)-$F$237)),0)","v":126355},0.29499999999999998]
[0.29000007239128972,448.26459999999997,null,null,154574,0.28999999999999998]
[0.28499999292484596,538.92644999999993,null,null,189097,0.28499999999999998]
[0.27999996339412375,647.72399999999993,null,null,231330,0.27999999999999997]
[0.27499996324239184,778.23624999999981,null,null,282995,0.27499999999999997]
[0.27000002090910863,934.73459999999989,null,null,346198,0.26999999999999996]
[0.26499999140749936,1122.3226999999997,null,null,423518,0.26499999999999996]
[0.25999999444899119,1347.0755999999997,null,null,518106,0.25999999999999995]
[0.25500000414280327,1616.2384499999998,null,null,633819,0.25499999999999995]
[0.24999998709630411,1938.4399999999996,null,null,775376,0.24999999999999994]
[0.24500000430828345,2323.9401499999994,null,null,948547,0.24499999999999994]
[0.23999999333778926,2784.9479999999994,null,null,1160395,0.23999999999999994]
[0.23500000025167384,3335.9565999999991,null,null,1419556,0.23499999999999993]
[0.23000000225351316,3994.1753999999987,null,null,1736598,0.22999999999999993]
[0.22500000185800964,4780.007999999998,null,null,2124448,0.22499999999999992]
[0.22000000163036629,5717.623999999998,null,null,2598920,0.21999999999999992]
[0.21500000203845709,6835.6239999999971,null,null,3179360,0.21499999999999991]
[0.21000000146356579,8167.8134999999966,null,null,3889435,0.20999999999999991]
[0.20499999787497838,9754.1008999999958,null,null,4758098,0.2049999999999999]
[0.20000000038924848,11641.531999999996,null,null,5820766,0.1999999999999999]
[0.19499999948569177,13885.501499999991,null,null,7120770,0.1949999999999999]
[0.19000000023494862,16551.118499999993,null,null,8711115,0.18999999999999989]
[0.18500000078998491,19714.795099999988,null,null,10656646,0.18499999999999989]
[0.18000000094313887,23466.041999999983,null,null,13036690,0.17999999999999988]
[0.17500000031756463,27909.509249999981,null,null,15948291,0.17499999999999988]
[0.16999999967542612,33167.282199999972,null,null,19510166,0.16999999999999987]
[0.16499999957306527,39381.450899999967,null,null,23867546,0.16499999999999987]
[0.16000000004535198,46716.956799999956,null,null,29198098,0.15999999999999986]
[0.15500000033611425,55364.713499999947,null,null,35719170,0.15499999999999986]
[0.15000000020153434,65544.97799999993,null,null,43696652,0.14999999999999986]
[0.14499999982140224,77510.934649999923,null,null,53455817,0.14499999999999985]
[0.14000000012524383,91552.414799999897,null,null,65394582,{"$f":"F282-0.005","v":0.13999999999999985}]
[0.13500000012123695,107999.64764999988,null,null,79999739,0.13499999999999984]
[0.12999999995668118,127226.83609999984,null,null,97866797,0.12999999999999984]
[0.12500000000725431,149655.32999999978,null,null,119724264,0.12499999999999983]
[0.11999999998621896,175756.02599999975,null,null,146463355,0.11999999999999983]
[0.11500000002277706,206050.47489999968,null,null,179174326,0.11499999999999982]
[0.11000000002666957,241110.0240999996,null,null,219190931,0.10999999999999982]
[]
[]
[null,null,null,null,176971.73363999999]
[null,null,null,null,{"$f":"E292*F255/100","v":495.52085419199989}]
[null,null,null,null,{"$f":"(LOG(E292,2/5)+25.8)/45","v":0.28027386647035174}]
[null,null,null,null,{"$f":"E292*E294/100","v":496.00552043244011}]
[]
[null,null,null,null,115812191.45702153]
[null,null,null,null,{"$f":"E297*F287/100","v":138974.62974842565}]
[null,null,null,null,{"$f":"(LOG(E297,2/5)+25.8)/45","v":0.1230279213558889}]
[null,null,null,null,{"$f":"E297*E299/100","v":142481.33182627594}]