{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["INSTRUCCIONES","EMPRESA - DATOS GENERALES","TAMAÑO EMPRESA","Exporta participación","EMPRESA - PERSONAS FÍSICAS","PRESUPUESTO - RESUMEN","Exporta","PRESUPUESTO - DESGLOSE"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"INSTRUCCIONES","index":0,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[[1,1,1,12],[2,1,13,12]]}
[]
[null,"CONVOCATORIA 2025 DE AYUDAS PARA LA CREACIÓN Y CONSOLIDACIÓN DE EMPRESAS INNOVADORAS DE BASE TECNOLÓGICA (EIBT)"]
[null,"Este archivo es la plantilla unificada para los documentos de los puntos b) y j) de la base 8, es decir, el formulario de solicitud y el presupuesto desglosado por gastos. Es necesario cumplimentar la información de todas las pestañas y entregar el archivo en formato .XLSM \n\nCuenta con 5 hojas:\n- EMPRESA - DATOS GENERALES: Información general sobre la EIBT.\n- TAMAÑO EMPRESA: Relación de accionistas de la empresa con sus porcentajes de participación y, en el caso de empresas societarias, información necesaria para el cálculo del tamaño de empresa debido a que es necesario ser una pyme para poder optar a la subvención. \n- EMPRESA - PERSONAS FÍSICAS: Información sobre las actividades realizadas por las personas físicas participantes en el accionariado de la empresa durante los dos años anteriores a la creación de la misma\n- PRESUPUESTO - RESUMEN: Hoja resumen del presupuesto incluido en la siguiente hoja. Únicamente, es necesario introducir dos datos en esta hoja.\n- PRESUPUESTO - DESGLOSE: Hoja donde deben introducirse los gastos realizados o previstos a realizar clasificados por tipo de gasto. Se calculan a modo orientativo las ayudas correspondientes y los límites de las mismas. \n\nCada hoja y cada tabla cuenta, a su vez, con sus propias instrucciones. Rellenar únicamente las celdas en blanco no bloqueadas. El resto, se calculan automáticamente.\n\nEn caso de duda o de necesitar ampliar alguna de las tablas para incluir más información, enviar un correo electrónico a la dirección fomento.innovacion@navarra.es"]

{"sheet":"EMPRESA - DATOS GENERALES","index":1,"n_rows":109,"n_cols":26,"rows_kept":109,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,6,1,13],[3,1,3,5],[3,6,3,13],[2,1,2,6],[2,10,2,13],[2,7,2,9],[4,11,4,13],[6,1,6,3],[6,6,6,8],[6,10,6,13],[4,2,4,4],[5,1,5,4],[5,5,5,13],[4,6,4,8],[4,9,4,10],[7,1,7,2],[7,3,7,5],[7,7,7,13],[8,1,8,2],[8,3,8,5],[8,6,8,13],[9,1,9,4],[9,5,9,13],[10,1,10,4],[11,1,11,4],[10,6,10,7],[10,8,10,9],[11,6,11,7],[11,8,11,9],[11,10,11,13],[10,11,10,13],[12,1,12,3],[12,4,12,6],[12,8,12,13],[13,1,13,2],[22,1,22,4],[16,5,16,13],[14,8,14,10],[14,12,14,13],[14,1,14,3],[16,1,16,4],[18,1,18,13],[14,4,14,6],[15,1,15,13],[21,9,22,12],[17,1,17,3],[13,10,13,13],[25,2,25,13],[20,9,20,10],[20,11,20,12],[13,3,13,8],[19,1,19,4],[20,1,20,4],[17,6,17,8],[17,10,17,13],[21,1,21,4],[24,2,24,13]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seleccionar convocatoria",null,null,null,"Seleccione convocatoria en EMPRESA-DATOS GENERALES"]
[null,"CONVOCATORIA",null,null,null,null,"CONVOCATORIA 2025 DE AYUDAS PARA LA CREACIÓN Y CONSOLIDACIÓN DE EMPRESAS INNOVADORAS DE BASE TECNOLÓGICA (EIBT)",null,null,null,null,null,null,null,null,null,"F3",null,"Ayudas para realizar proyectos de I+D. Convocatoria 2024",null,null,null,"3.3. TIPO DE PROYECTO: (Seleccionardel desplegable)"]
[null,"1. IDENTIFICACIÓN DEL SOLICITANTE",null,null,null,null,null,"Fecha de creación EIBT",null,null,null,null,null,null,null,null,"Empresa",null,"Ayudas para realizar proyectos estratégicos de I+D en 2024-2027",null,null,null,"3.3. RETO EN EL QUE SE ENCUADRA EL PROYECTO: (Seleccionardel desplegable)"]
[null,"Razón social del solicitante:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Universidad"]
[null,"CIF:",null,null,null,"Acrónimo:",null,null,null,"Grupo empresarial:",null,null,null,null,null,null,"Centro de Investigación"]
[null,"Domicilio social (calle, número, etc):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instituto de Investigación Sanitaria",null,null,null,null,"J7 Y J18",null,null,null,"E6"]
[null,"Codigo Postal:",null,null,null,"Localidad:",null,null,null,"Provincia:",{"$f":"VLOOKUP(TRUNC(E7/1000),$V$7:$W$59,2,FALSE)","v":"Introducir Código Postal"},null,null,null,null,null,"Centro tecnológico",null,null,null,null,0,"Introducir Código Postal",null,null,"Acceso"]
[null,"Teléfono1:  ",null,null,null,null,"Web:",null,null,null,null,null,null,null,null,null,"Unidad de I+D+i empresarial",null,null,null,null,1,"Álava",null,null,"Acera"]
[null,"Teléfono2:  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entidad singulares",null,null,null,null,2,"Albacete",null,null,"Alameda"]
[null,"Actividad de la empresa:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coordinador de agentes de ejecución",null,null,null,null,3,"Alicante",null,null,"Aldea"]
[null,"CNAE-2009 de la actividad principal con 4 dígitos (1):",null,null,null,null,"Nº de inscripción en el Registro Industrial de Navarra (si procede) (2)",null,null,null,"Sector",null,null,null,null,null,"B5",null,null,null,null,4,"Almería",null,null,"Apartamentos"]
[null,"Persona de contacto",null,null,null,"Nombre:",null,null,"Primer apellido:",null,null,null,null,null,null,null,"Validación de DNI / NIE / NIF Y CIF",null,null,null,null,5,"Ávila",null,null,"Apeadero"]
[null,"Segundo apellido:",null,null,null,null,null,"Cargo:",null,null,null,null,null,null,null,null,{"$f":"C5","v":0},"Número a comprobar",null,null,null,6,"Badajoz",null,null,"Atajo"]
[null,"Tel. directo:",null,null,null,null,null,null,null,"Correo electrónico:",null,null,null,null,null,null,{"$f":"IF(MID(Q13,1,1)=\"X\",IF(MID(\"TRWAGMYFPDXBNJZSQVHLCKE\",1+MOD(MID(Q13,2,7),23),1)=MID(Q13,9,1),\"OK\",\"NO\"),IF(MID(Q13,1,1)=\"Y\",IF(MID(\"TRWAGMYFPDXBNJZSQVHLCKE\",1+MOD(MID(Q13,2,7)+10000000,23),1)=MID(Q13,9,1),\"OK\",\"NO\"),IF(MID(Q13,1,1)=\"Z\",IF(MID(\"TRWAGMYFPDXBNJZSQVHLCKE\",1+MOD(MID(Q13,2,7)+20000000,23),1)=MID(Q13,9,1),\"OK\",\"NO\"),IF(OR(MID(Q13,1,1)=\"0\",MID(Q13,1,1)=\"1\",MID(Q13,1,1)=\"2\",MID(Q13,1,1)=\"3\",MID(Q13,1,1)= \"4\",MID(Q13,1,1)=\"5\",MID(Q13,1,1)=\"6\",MID(Q13,1,1)=\"7\",MID(Q13,1,1)=\"8\",MID(Q13,1,1)=\"9\"),IF(MID(\"TRWAGMYFPDXBNJZSQVHLCKE\",1+MOD(MID(Q13,1,8),23),1)=MID(Q13,9,1),\"OK\",\"NO\"),\"ERROR\"))))","v":"NO"},"VALIDACIÓN COMO DNI, NIF O NIE",null,null,null,7,"Baleares",null,null,"Autovía"]
[null,"Consultoría/\nAsesoría",null,null,null,null,null,"Correo electrónico:",null,null,null,"Teléfono:",null,null,null,null,{"$f":"SUM(MID(Q13,3,1)+MID(Q13,5,1)+MID(Q13,7,1)+IF(2*MID(Q13,2,1)<10,2*MID(Q13,2,1),TRUNC(2*MID(Q13,2,1)/10)+ 2*MID(Q13,2,1)-TRUNC(2*MID(Q13,2,1)/10)*10)+IF(2*MID(Q13,4,1)<10,2*MID(Q13,4,1),TRUNC(2*MID(Q13,4,1)/10)+2*MID(Q13,4,1)-TRUNC(2*MID(Q13,4,1)/10)*10)+IF(2*MID(Q13,6,1)<10,2*MID(Q13,6,1),TRUNC(2*MID(Q13,6,1)/10)+2*MID(Q13,6,1)-TRUNC(2*MID(Q13,6,1)/10)*10)+IF(2*MID(Q13,8,1)<10,2*MID(Q13,8,1),TRUNC(2*MID(Q13,8,1)/10)+2*MID(Q13,8,1)-TRUNC(2*MID(Q13,8,1)/10)*10))","v":{"$error":"#VALUE!"}},"Operaciones sobre número para comprobar CIF",null,null,null,8,"Barcelona",null,null,"Avenida"]
[null,"Dirección completa (si es distinta del domicilio social):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(MID(Q13,1,1)=\"B\",MID(Q13,1,1)=\"E\",MID(Q13,1,1)=\"H\"),IF(TEXT(IF((Q15-TRUNC(Q15/10)*10)=0,0,10-(Q15-TRUNC(Q15/10)*10)),0)=MID(Q13,9,1),\"OK\",\"NO\"), IF(OR(MID(Q13,1,1)=\"P\",MID(Q13,1,1)=\"Q\",MID(Q13,1,1)=\"S\",MID(Q13,1,1)=\"W\"),IF(MID(\"ABCDEFGHIJ\",IF((Q15-TRUNC(Q15/10)*10)=0,10,10-(Q15-TRUNC(Q15/10)*10)),1)=MID(Q13,9,1),\"OK\",\"NO\"),IF(OR(TEXT(IF((Q15-TRUNC(Q15/10)*10)=0,0,10-(Q15-TRUNC(Q15/10)*10)),0)=MID(Q13,9,1),MID(\"ABCDEFGHIJ\",IF((Q15-TRUNC(Q15/10)*10)=0,10,10-(Q15-TRUNC(Q15/10)*10)),1)=MID(Q13,9,1)),\"OK\",\"NO\")))","v":{"$error":"#VALUE!"}},"VALIDACIÓN COMO CIF",null,null,null,9,"Burgos",null,null,"Bajada"]
[null,"Dirección (calle, número, etc):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q14=\"OK\",Q16=\"OK\"),\"OK\",\"NO\")","v":{"$error":"#VALUE!"}},"VALIDACIÓN CONJUNTA COMO DNI, NIF O NIE O BIEN COMO CIF",null,null,null,10,"Cáceres",null,null,"Barranco"]
[null,"Codigo Postal:",null,null,null,"Localidad:",null,null,null,"Provincia:",{"$f":"VLOOKUP(TRUNC(E18/1000),$V$7:$W$59,2,FALSE)","v":"Introducir Código Postal"},null,null,null,null,null,null,null,null,null,null,11,"Cádiz",null,null,"Bloque"]
[null,"Datos económicos de los últimos tres ejercicios cerrados (€)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Castellón",null,null,"Calle"]
[null,"Año datos:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K21",null,null,null,null,13,"Ciudad Real",null,null,"Calleja"]
[null,"Empleados:",null,null,null,null,null,null,null,"Tamaño de empresa",null,null,null,null,null,null,"Agente del SINAI",null,null,null,null,14,"Córdoba",null,null,"Callejuela"]
[null,"Facturación:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grande",null,null,null,null,15,"Coruña",null,null,"Camino"]
[null,"Activo total:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mediana",null,null,null,null,16,"Cuenca",null,null,"Carretera"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pequeña",null,null,null,null,17,"Girona",null,null,"Cerro"]
[null,"(1)","https://www.boe.es/buscar/act.php?id=BOE-A-2007-8824",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"Granada",null,null,"Circunvalación"]
[null,"(2)","Registro Industrial - navarra.es",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"Guadalajara",null,null,"Convento"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"Guipúzcoa",null,null,"Cooperativa"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"Huelva",null,null,"Corredera"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"Huesca",null,null,"Costa"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"Jaén",null,null,"Costanilla"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,"León",null,null,"Costera"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"Lleida",null,null,"Cruce"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,"La rioja",null,null,"Cuadra"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,"Lugo",null,null,"Cuesta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,"Madrid",null,null,"Chalet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,"Málaga",null,null,"Dehesa"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"Murcia",null,null,"Diseminado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,"Navarra",null,null,"Edificio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,"Orense",null,null,"Edificios"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,"Asturias",null,null,"Empresa"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,"Palencia",null,null,"Entrada"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,"Las Palmas",null,null,"Entradas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,"Pontevedra",null,null,"Escala"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,"Salamanca",null,null,"Escaleras"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,"Santa Cruz de Tenerife",null,null,"Escalinata"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,"Cantabria",null,null,"Estación"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,"Segovia",null,null,"Explanada"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,"Sevilla",null,null,"Extrarradio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,"Soria",null,null,"Fábrica"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,"Tarragona",null,null,"Finca"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,"Teruel",null,null,"Fincas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,"Toledo",null,null,"Galería"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,"Valencia",null,null,"Glorieta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,"Valladolid",null,null,"Granja"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,"Vizcaya",null,null,"Grupo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,"Zamora",null,null,"Grupos"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,"Zaragoza",null,null,"Lugar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,"Ceuta",null,null,"Mercado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,"Melilla",null,null,"Monasterio"]
[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,"Monte"]
[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,"Muelle"]
[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,"Núcleo"]
[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,"Nudo"]
[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,"Paraje"]
[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,"Particular"]
[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,"Partida"]
[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,"Pasadizo"]
[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,"Pasaje"]
[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,"Paseo"]
[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,"Pasillo"]
[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,"Paso"]
[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,"Paso particular"]
[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,"Patio"]
[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,"Placeta"]
[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,"Placetilla"]
[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,"Playa"]
[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,"Plaza"]
[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,"Plazoleta"]
[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,"Plazuela"]
[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,"Poblado"]
[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,"Posada"]
[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,"Prolongación"]
[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,"Pueblo"]
[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,"Puerta"]
[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,"Puerto"]
[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,"Rambla"]
[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,"Rampa"]
[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,"Replaceta"]
[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,"Rincón"]
[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,"Ronda"]
[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,"Rondin"]
[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,"Rotonda"]
[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,"Sector"]
[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,"Senda"]
[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,"Sendero"]
[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,"Subida"]
[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,"Torrente"]
[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,"Tránsito"]
[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,"Trasera"]
[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,"Travesía"]
[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,"Túnel"]
[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,"Urbanización"]
[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,"Vereda"]
[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,"Vía"]
[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,"Viaducto"]
[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,"Vial"]
[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,"Villa"]
[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,"Viviendas"]
[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,"Zona"]

{"sheet":"TAMAÑO EMPRESA","index":2,"n_rows":501,"n_cols":24,"rows_kept":501,"cut":false,"hidden":false,"merged":[[3,1,3,8],[1,1,1,8],[2,1,2,8],[29,1,29,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[7,1,7,3],[8,1,8,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[4,2,4,3],[5,1,5,9],[6,6,6,9],[16,1,16,3],[27,1,27,3],[28,1,28,3],[4,5,4,8],[47,1,47,4],[48,1,48,4],[49,1,49,4],[50,1,50,4],[51,1,51,4],[40,1,40,4],[41,1,41,4],[42,1,42,4],[43,1,43,4],[44,1,44,4],[45,1,45,4],[32,1,32,8],[33,6,33,8],[35,1,35,4],[36,1,36,4],[37,1,37,4],[38,1,38,4],[39,1,39,4],[17,1,17,3],[18,1,18,3],[19,1,19,3],[34,1,34,4],[30,1,30,5],[315,20,315,23],[211,20,211,23],[131,20,131,23],[81,3,85,3],[347,20,347,23],[323,20,323,23],[243,20,243,23],[187,20,187,23],[195,20,195,23],[203,20,203,23],[219,20,219,23],[259,20,259,23],[291,20,291,23],[299,20,299,23],[123,20,123,23],[139,20,139,23],[339,20,339,23],[109,1,109,8],[81,1,85,2],[81,4,81,5],[82,4,82,5],[83,4,83,5],[84,4,84,5],[105,4,105,5],[68,1,68,2],[69,1,73,2],[2,12,2,13],[395,20,395,23],[119,15,119,18],[287,15,287,18],[235,20,235,23],[275,20,275,23],[267,20,267,23],[55,1,55,5],[69,4,69,5],[75,1,79,2],[58,4,58,5],[227,20,227,23],[76,4,76,5],[117,2,117,5],[163,20,163,23],[80,1,80,2],[171,20,171,23],[283,20,283,23],[331,20,331,23],[307,20,307,23],[74,1,74,2],[54,1,54,8],[57,1,61,2],[62,1,62,2],[63,1,67,2],[63,3,67,3],[6,1,6,5],[57,3,61,3],[55,6,55,8],[20,1,20,3],[52,1,52,4],[63,4,63,5],[64,4,64,5],[65,4,65,5],[33,1,33,5],[56,4,56,5],[57,4,57,5],[56,1,56,2],[59,4,59,5],[60,4,60,5],[61,4,61,5],[46,1,46,4],[9,1,9,3],[85,4,85,5],[86,1,86,2],[87,1,91,2],[87,3,91,3],[87,4,87,5],[88,4,88,5],[89,4,89,5],[90,4,90,5],[91,4,91,5],[435,20,435,23],[147,20,147,23],[155,20,155,23],[500,2,500,5],[411,20,411,23],[419,20,419,23],[427,20,427,23],[403,20,403,23],[251,20,251,23],[179,20,179,23],[467,20,467,23],[475,20,475,23],[483,20,483,23],[491,20,491,23],[443,20,443,23],[451,20,451,23],[459,20,459,23],[431,15,431,18],[371,20,371,23],[379,20,379,23],[387,20,387,23],[355,20,355,23],[363,20,363,23],[496,6,500,8],[107,1,107,2],[104,4,104,5],[99,1,99,2],[94,4,94,5],[92,1,92,2],[93,1,98,2],[93,3,98,3],[93,4,93,5],[95,4,95,5],[96,4,96,5],[97,4,97,5],[98,4,98,5],[100,1,106,2],[100,3,106,3],[100,4,100,5],[101,4,101,5],[102,4,102,5],[103,4,103,5],[106,4,106,5],[77,4,77,5],[66,4,66,5],[72,4,72,5],[79,4,79,5],[71,4,71,5],[67,4,67,5],[78,4,78,5],[75,3,79,3],[75,4,75,5],[69,3,73,3],[73,4,73,5],[70,4,70,5]]}
[]
[null,"2. TAMAÑO DE EMPRESA"]
[null,"Debe cumplimentarse por todas las solicitantes. Además, durante la evaluación de las solicitudes, se podrá requerir la presentación de las cuentas cerradas de los últimos 3 ejercicios, memorias e informes, tanto de la solicitante como de sus asociadas y vinculadas para corroborar la información. Por cada fila rellena en las relaciones 1, 2 y 3, se muestra una tabla para rellenar sus datos por debajo de la solicitante.",null,null,null,null,null,null,null,null,null,null,"BLOQUEO\nAUTOMÁTICO",null,"SI"]
[null,"DATOS NECESARIOS PARA DETERMINAR EL TAMAÑO DE LA EMPRESA (ANEXO I DEL REGLAMENTO (UE) Nº 651/2014)."]
[null,null," Puede ayudarse de lo siguiente: ",null,null,"Guía sobre la definición de PYME",null,null,null,null,null,null,null,"N3, D62, D115 y sucesivos; y macro"]
[null,"1- RELACIÓN DE ACCIONISTAS DE LA EMPRESA (tanto personas físicas como jurídicas)",null,null,null,null,null,null,null,null,null,null,null,"SI"]
[null,"Después de rellenar esta tabla, rellenar los datos económicos de empresas en las inferiores",null,null,null,null,"% PARTICIPACIÓN",null,null,null,null,null,null,"NO"]
[null,"NOMBRE O RAZÓN SOCIAL",null,null,"CIF","Tipo de persona",{"$f":"'EMPRESA - DATOS GENERALES'!$F$20","v":0},{"$f":"'EMPRESA - DATOS GENERALES'!G20","v":0},{"$f":"'EMPRESA - DATOS GENERALES'!H20","v":0},"Momento de la Solicitud",null,null,null,"F8"]
[null,null,null,null,null,null,null,{"$f":"G9","v":0},{"$f":"H9","v":0},0,null,null,null,"Persona jurídica"]
[null,null,null,null,null,null,null,{"$f":"G10","v":0},{"$f":"H10","v":0},0]
[null,null,null,null,null,null,null,0,0,0,null,null,null,"Persona física"]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,"TOTAL",null,null,null,null,{"$f":"SUM(G9:G30)","v":0},{"$f":"SUM(H9:H30)","v":0},{"$f":"SUM(I9:I30)","v":0},{"$f":"SUM(J9:J30)","v":0}]
[]
[null,"2- RELACIÓN DE EMPRESAS FILIALES O PARTICIPADAS POR LA EMPRESA"]
[null,"Después de rellenar esta tabla, rellenar los datos económicos de empresas en las inferiores",null,null,null,null,"% PARTICIPACIÓN"]
[null,"RAZÓN SOCIAL",null,null,null,"CIF",{"$f":"G8","v":0},{"$f":"H8","v":0},{"$f":"I8","v":0}]
[null,null,null,null,null,null,null,{"$f":"G36","v":0},0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[]
[null,"3- Si una o más personas físicas son, de forma conjunta, accionistas mayoritarios de la empresa solicitante y también de otra u otras, indicar los siguientes datos de dichas empresas en esta tabla, y rellenar las tablas inferiores"]
[null,"Por cada empresa se debe rellenar si tiene el mismo CNAE u opera en mercado contiguo",null,null,null,null,"% PARTICIPACIÓN"]
[null,"RAZÓN SOCIAL Y CIF",null,"Actividad principal","Accionistas comunes (de la tabla 1)",null,{"$f":"G8","v":0},{"$f":"H8","v":0},{"$f":"I8","v":0}]
[null,null,null,null,null,null,null,{"$f":"G58","v":0},0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,"¿Tiene el mismo CNAE?",null,null,"¿Mercado contiguo?",null,{"$f":"SUM(G58:G62)","v":0},{"$f":"SUM(H58:H62)","v":0},{"$f":"SUM(I58:I62)","v":0}]
[null,null,null,null,null,null,null,{"$f":"G64","v":0},0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,"¿Tiene el mismo CNAE?",null,null,"¿Mercado contiguo?",null,{"$f":"SUM(G64:G68)","v":0},{"$f":"SUM(H64:H68)","v":0},{"$f":"SUM(I64:I68)","v":0}]
[null,null,null,null,null,null,null,{"$f":"G70","v":0},0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,"¿Tiene el mismo CNAE?",null,null,"¿Mercado contiguo?",null,{"$f":"SUM(G70:G74)","v":0},{"$f":"SUM(H70:H74)","v":0},{"$f":"SUM(I70:I74)","v":0}]
[null,null,null,null,null,null,null,{"$f":"G76","v":0},0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,"¿Tiene el mismo CNAE?",null,null,"¿Mercado contiguo?",null,{"$f":"SUM(G76:G80)","v":0},{"$f":"SUM(H76:H80)","v":0},{"$f":"SUM(I76:I80)","v":0}]
[null,null,null,null,null,null,null,{"$f":"G82","v":0},0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,"¿Tiene el mismo CNAE?",null,null,"¿Mercado contiguo?",null,{"$f":"SUM(G82:G86)","v":0},{"$f":"SUM(H82:H86)","v":0},{"$f":"SUM(I82:I86)","v":0}]
[null,null,null,null,null,null,null,{"$f":"G88","v":0},0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,"¿Tiene el mismo CNAE?",null,null,"¿Mercado contiguo?",null,{"$f":"SUM(G88:G92)","v":0},{"$f":"SUM(H88:H92)","v":0},{"$f":"SUM(I88:I92)","v":0}]
[null,null,null,null,null,null,null,{"$f":"G94","v":0},{"$f":"H94","v":0}]
[null,null,null,null,null,null,null,{"$f":"G95","v":0},{"$f":"H95","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,"¿Tiene el mismo CNAE?",null,null,"¿Mercado contiguo?",null,{"$f":"SUM(G94:G99)","v":0},{"$f":"SUM(H94:H99)","v":0},{"$f":"SUM(I94:I99)","v":0}]
[null,null,null,null,null,null,null,{"$f":"G101","v":0},{"$f":"H101","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,{"$f":"G105","v":0},{"$f":"H105","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,"¿Tiene el mismo CNAE?",null,null,"¿Mercado contiguo?",null,{"$f":"SUM(G101:G107)","v":0},{"$f":"SUM(H101:H107)","v":0},{"$f":"SUM(I101:I107)","v":0}]
[]
[null,"Rellenar una Tabla de Empresa por cada empresa asociada (participación entre el 25% y el 50%) o vinculada (>50%).\nEl nombre de la empresa proviene de las tablas de más arriba: T1 empresas participantes. T2 empresas participadas y T3 empresas asociadas o vinculadas a través de persona física."]
[]
[null,null,"SOLICITANTE",{"$f":"'EMPRESA - DATOS GENERALES'!F20","v":0},{"$f":"'EMPRESA - DATOS GENERALES'!G20","v":0},{"$f":"'EMPRESA - DATOS GENERALES'!H20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C112","v":"SOLICITANTE"},0,0,0]
[null,null,"Nº de empleados",{"$f":"'EMPRESA - DATOS GENERALES'!F21","v":0},{"$f":"'EMPRESA - DATOS GENERALES'!G21","v":0},{"$f":"'EMPRESA - DATOS GENERALES'!H21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nº de empleados",0,0,0]
[null,null,"Facturación (€)",{"$f":"'EMPRESA - DATOS GENERALES'!F22","v":0},{"$f":"'EMPRESA - DATOS GENERALES'!G22","v":0},{"$f":"'EMPRESA - DATOS GENERALES'!H22","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Facturación (€)",0,0,0]
[null,null,"Activo total (€)",{"$f":"'EMPRESA - DATOS GENERALES'!F23","v":0},{"$f":"'EMPRESA - DATOS GENERALES'!G23","v":0},{"$f":"'EMPRESA - DATOS GENERALES'!H23","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Activo total (€)",0,0,0]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?"]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas"]
[null,null,"En caso de que la empresa de esta tabla tenga empresas vinculadas deberá rellenar otra tabla con los datos de la empresa vinculada. En caso de que la empresa de la tabla sea vinculada a la solicitante y tenga empresas asociadas, también deberán incluirse "]
[]
[null,null,{"$f":"IF(INDIRECT(O121)=$N$9,INDIRECT(O123),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C120=\"\",AND(D124=0,E124=0,F124=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.","TABLA 1",null,null,null,null,{"$f":"C120","v":""},{"$f":"D120","v":0},{"$f":"E120","v":0},{"$f":"F120","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M120","v":"Ocultar fila"},9,{"$f":"CONCATENATE(\"F\",N121)","v":"F9"},"Celda donde se selecciona si persona física o jurídica",null,null,null,null,{"$f":"C121","v":"Nº de empleados"},{"$f":"ROUND(D121*D124,2)+V113","v":0},{"$f":"ROUND(E121*E124,2)+W113","v":0},{"$f":"ROUND(F121*F124,2)+X113","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M121","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C122","v":"Facturación (€)"},{"$f":"ROUND(D122*D124,2)+V114","v":0},{"$f":"ROUND(E122*E124,2)+W114","v":0},{"$f":"ROUND(F122*F124,2)+X114","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N121)","v":"B9"},"Contiene nombre de la empresa",null,null,null,null,{"$f":"C123","v":"Activo total (€)"},{"$f":"ROUND(D123*D124,2)+V115","v":0},{"$f":"ROUND(E123*E124,2)+W115","v":0},{"$f":"ROUND(F123*F124,2)+X115","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C120=\"\",0,IF(INDIRECT(O124)>0.5,1,IF(INDIRECT(O124)>=0.25,INDIRECT(O124),0)))","v":0},{"$f":"IF(C120=\"\",0,IF(INDIRECT(O125)>0.5,1,IF(INDIRECT(O125)>=0.25,INDIRECT(O125),0)))","v":0},{"$f":"IF(C120=\"\",0,IF(INDIRECT(O126)>0.5,1,IF(INDIRECT(O126)>=0.25,INDIRECT(O126),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N121)","v":"G9"},"Contiene% de participación del primer año",null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N121)","v":"H9"},"Contiene% de participación del segundo año"]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N121)","v":"I9"},"Contiene% de participación del tercer año"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O129)=$N$9,INDIRECT(O131),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C128=\"\",AND(D132=0,E132=0,F132=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C128","v":""},{"$f":"D128","v":0},{"$f":"E128","v":0},{"$f":"F128","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M128","v":"Ocultar fila"},{"$f":"N121+1","v":10},{"$f":"CONCATENATE(\"F\",N129)","v":"F10"},null,null,null,null,null,{"$f":"C129","v":"Nº de empleados"},{"$f":"ROUND(D129*D132,2)+V121","v":0},{"$f":"ROUND(E129*E132,2)+W121","v":0},{"$f":"ROUND(F129*F132,2)+X121","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M129","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C130","v":"Facturación (€)"},{"$f":"ROUND(D130*D132,2)+V122","v":0},{"$f":"ROUND(E130*E132,2)+W122","v":0},{"$f":"ROUND(F130*F132,2)+X122","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N129)","v":"B10"},null,null,null,null,null,{"$f":"C131","v":"Activo total (€)"},{"$f":"ROUND(D131*D132,2)+V123","v":0},{"$f":"ROUND(E131*E132,2)+W123","v":0},{"$f":"ROUND(F131*F132,2)+X123","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C128=\"\",0,IF(INDIRECT(O132)>0.5,1,IF(INDIRECT(O132)>=0.25,INDIRECT(O132),0)))","v":0},{"$f":"IF(C128=\"\",0,IF(INDIRECT(O133)>0.5,1,IF(INDIRECT(O133)>=0.25,INDIRECT(O133),0)))","v":0},{"$f":"IF(C128=\"\",0,IF(INDIRECT(O134)>0.5,1,IF(INDIRECT(O134)>=0.25,INDIRECT(O134),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N129)","v":"G10"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N129)","v":"H10"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N129)","v":"I10"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O137)=$N$9,INDIRECT(O139),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C136=\"\",AND(D140=0,E140=0,F140=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C136","v":""},{"$f":"D136","v":0},{"$f":"E136","v":0},{"$f":"F136","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M136","v":"Ocultar fila"},{"$f":"N129+1","v":11},{"$f":"CONCATENATE(\"F\",N137)","v":"F11"},null,null,null,null,null,{"$f":"C137","v":"Nº de empleados"},{"$f":"ROUND(D137*D140,2)+V129","v":0},{"$f":"ROUND(E137*E140,2)+W129","v":0},{"$f":"ROUND(F137*F140,2)+X129","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M137","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C138","v":"Facturación (€)"},{"$f":"ROUND(D138*D140,2)+V130","v":0},{"$f":"ROUND(E138*E140,2)+W130","v":0},{"$f":"ROUND(F138*F140,2)+X130","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N137)","v":"B11"},null,null,null,null,null,{"$f":"C139","v":"Activo total (€)"},{"$f":"ROUND(D139*D140,2)+V131","v":0},{"$f":"ROUND(E139*E140,2)+W131","v":0},{"$f":"ROUND(F139*F140,2)+X131","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C136=\"\",0,IF(INDIRECT(O140)>0.5,1,IF(INDIRECT(O140)>=0.25,INDIRECT(O140),0)))","v":0},{"$f":"IF(C136=\"\",0,IF(INDIRECT(O141)>0.5,1,IF(INDIRECT(O141)>=0.25,INDIRECT(O141),0)))","v":0},{"$f":"IF(C136=\"\",0,IF(INDIRECT(O142)>0.5,1,IF(INDIRECT(O142)>=0.25,INDIRECT(O142),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N137)","v":"G11"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N137)","v":"H11"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N137)","v":"I11"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O145)=$N$9,INDIRECT(O147),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C144=\"\",AND(D148=0,E148=0,F148=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C144","v":""},{"$f":"D144","v":0},{"$f":"E144","v":0},{"$f":"F144","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M144","v":"Ocultar fila"},{"$f":"N137+1","v":12},{"$f":"CONCATENATE(\"F\",N145)","v":"F12"},null,null,null,null,null,{"$f":"C145","v":"Nº de empleados"},{"$f":"ROUND(D145*D148,2)+V137","v":0},{"$f":"ROUND(E145*E148,2)+W137","v":0},{"$f":"ROUND(F145*F148,2)+X137","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M145","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C146","v":"Facturación (€)"},{"$f":"ROUND(D146*D148,2)+V138","v":0},{"$f":"ROUND(E146*E148,2)+W138","v":0},{"$f":"ROUND(F146*F148,2)+X138","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N145)","v":"B12"},null,null,null,null,null,{"$f":"C147","v":"Activo total (€)"},{"$f":"ROUND(D147*D148,2)+V139","v":0},{"$f":"ROUND(E147*E148,2)+W139","v":0},{"$f":"ROUND(F147*F148,2)+X139","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C144=\"\",0,IF(INDIRECT(O148)>0.5,1,IF(INDIRECT(O148)>=0.25,INDIRECT(O148),0)))","v":0},{"$f":"IF(C144=\"\",0,IF(INDIRECT(O149)>0.5,1,IF(INDIRECT(O149)>=0.25,INDIRECT(O149),0)))","v":0},{"$f":"IF(C144=\"\",0,IF(INDIRECT(O150)>0.5,1,IF(INDIRECT(O150)>=0.25,INDIRECT(O150),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N145)","v":"G12"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N145)","v":"H12"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N145)","v":"I12"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O153)=$N$9,INDIRECT(O155),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C152=\"\",AND(D156=0,E156=0,F156=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C152","v":""},{"$f":"D152","v":0},{"$f":"E152","v":0},{"$f":"F152","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M152","v":"Ocultar fila"},{"$f":"N145+1","v":13},{"$f":"CONCATENATE(\"F\",N153)","v":"F13"},null,null,null,null,null,{"$f":"C153","v":"Nº de empleados"},{"$f":"ROUND(D153*D156,2)+V145","v":0},{"$f":"ROUND(E153*E156,2)+W145","v":0},{"$f":"ROUND(F153*F156,2)+X145","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M153","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C154","v":"Facturación (€)"},{"$f":"ROUND(D154*D156,2)+V146","v":0},{"$f":"ROUND(E154*E156,2)+W146","v":0},{"$f":"ROUND(F154*F156,2)+X146","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N153)","v":"B13"},null,null,null,null,null,{"$f":"C155","v":"Activo total (€)"},{"$f":"ROUND(D155*D156,2)+V147","v":0},{"$f":"ROUND(E155*E156,2)+W147","v":0},{"$f":"ROUND(F155*F156,2)+X147","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C152=\"\",0,IF(INDIRECT(O156)>0.5,1,IF(INDIRECT(O156)>=0.25,INDIRECT(O156),0)))","v":0},{"$f":"IF(C152=\"\",0,IF(INDIRECT(O157)>0.5,1,IF(INDIRECT(O157)>=0.25,INDIRECT(O157),0)))","v":0},{"$f":"IF(C152=\"\",0,IF(INDIRECT(O158)>0.5,1,IF(INDIRECT(O158)>=0.25,INDIRECT(O158),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N153)","v":"G13"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N153)","v":"H13"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N153)","v":"I13"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O161)=$N$9,INDIRECT(O163),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C160=\"\",AND(D164=0,E164=0,F164=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C160","v":""},{"$f":"D160","v":0},{"$f":"E160","v":0},{"$f":"F160","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M160","v":"Ocultar fila"},{"$f":"N153+1","v":14},{"$f":"CONCATENATE(\"F\",N161)","v":"F14"},null,null,null,null,null,{"$f":"C161","v":"Nº de empleados"},{"$f":"ROUND(D161*D164,2)+V153","v":0},{"$f":"ROUND(E161*E164,2)+W153","v":0},{"$f":"ROUND(F161*F164,2)+X153","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M161","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C162","v":"Facturación (€)"},{"$f":"ROUND(D162*D164,2)+V154","v":0},{"$f":"ROUND(E162*E164,2)+W154","v":0},{"$f":"ROUND(F162*F164,2)+X154","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N161)","v":"B14"},null,null,null,null,null,{"$f":"C163","v":"Activo total (€)"},{"$f":"ROUND(D163*D164,2)+V155","v":0},{"$f":"ROUND(E163*E164,2)+W155","v":0},{"$f":"ROUND(F163*F164,2)+X155","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C160=\"\",0,IF(INDIRECT(O164)>0.5,1,IF(INDIRECT(O164)>=0.25,INDIRECT(O164),0)))","v":0},{"$f":"IF(C160=\"\",0,IF(INDIRECT(O165)>0.5,1,IF(INDIRECT(O165)>=0.25,INDIRECT(O165),0)))","v":0},{"$f":"IF(C160=\"\",0,IF(INDIRECT(O166)>0.5,1,IF(INDIRECT(O166)>=0.25,INDIRECT(O166),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N161)","v":"G14"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N161)","v":"H14"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N161)","v":"I14"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O169)=$N$9,INDIRECT(O171),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C168=\"\",AND(D172=0,E172=0,F172=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C168","v":""},{"$f":"D168","v":0},{"$f":"E168","v":0},{"$f":"F168","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M168","v":"Ocultar fila"},{"$f":"N161+1","v":15},{"$f":"CONCATENATE(\"F\",N169)","v":"F15"},null,null,null,null,null,{"$f":"C169","v":"Nº de empleados"},{"$f":"ROUND(D169*D172,2)+V161","v":0},{"$f":"ROUND(E169*E172,2)+W161","v":0},{"$f":"ROUND(F169*F172,2)+X161","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M169","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C170","v":"Facturación (€)"},{"$f":"ROUND(D170*D172,2)+V162","v":0},{"$f":"ROUND(E170*E172,2)+W162","v":0},{"$f":"ROUND(F170*F172,2)+X162","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N169)","v":"B15"},null,null,null,null,null,{"$f":"C171","v":"Activo total (€)"},{"$f":"ROUND(D171*D172,2)+V163","v":0},{"$f":"ROUND(E171*E172,2)+W163","v":0},{"$f":"ROUND(F171*F172,2)+X163","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C168=\"\",0,IF(INDIRECT(O172)>0.5,1,IF(INDIRECT(O172)>=0.25,INDIRECT(O172),0)))","v":0},{"$f":"IF(C168=\"\",0,IF(INDIRECT(O173)>0.5,1,IF(INDIRECT(O173)>=0.25,INDIRECT(O173),0)))","v":0},{"$f":"IF(C168=\"\",0,IF(INDIRECT(O174)>0.5,1,IF(INDIRECT(O174)>=0.25,INDIRECT(O174),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N169)","v":"G15"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N169)","v":"H15"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N169)","v":"I15"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O177)=$N$9,INDIRECT(O179),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C176=\"\",AND(D180=0,E180=0,F180=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C176","v":""},{"$f":"D176","v":0},{"$f":"E176","v":0},{"$f":"F176","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M176","v":"Ocultar fila"},{"$f":"N169+1","v":16},{"$f":"CONCATENATE(\"F\",N177)","v":"F16"},null,null,null,null,null,{"$f":"C177","v":"Nº de empleados"},{"$f":"ROUND(D177*D180,2)+V169","v":0},{"$f":"ROUND(E177*E180,2)+W169","v":0},{"$f":"ROUND(F177*F180,2)+X169","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M177","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C178","v":"Facturación (€)"},{"$f":"ROUND(D178*D180,2)+V170","v":0},{"$f":"ROUND(E178*E180,2)+W170","v":0},{"$f":"ROUND(F178*F180,2)+X170","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N177)","v":"B16"},null,null,null,null,null,{"$f":"C179","v":"Activo total (€)"},{"$f":"ROUND(D179*D180,2)+V171","v":0},{"$f":"ROUND(E179*E180,2)+W171","v":0},{"$f":"ROUND(F179*F180,2)+X171","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C176=\"\",0,IF(INDIRECT(O180)>0.5,1,IF(INDIRECT(O180)>=0.25,INDIRECT(O180),0)))","v":0},{"$f":"IF(C176=\"\",0,IF(INDIRECT(O181)>0.5,1,IF(INDIRECT(O181)>=0.25,INDIRECT(O181),0)))","v":0},{"$f":"IF(C176=\"\",0,IF(INDIRECT(O182)>0.5,1,IF(INDIRECT(O182)>=0.25,INDIRECT(O182),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N177)","v":"G16"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N177)","v":"H16"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N177)","v":"I16"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O185)=$N$9,INDIRECT(O187),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C184=\"\",AND(D188=0,E188=0,F188=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C184","v":""},{"$f":"D184","v":0},{"$f":"E184","v":0},{"$f":"F184","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M184","v":"Ocultar fila"},{"$f":"N177+1","v":17},{"$f":"CONCATENATE(\"F\",N185)","v":"F17"},null,null,null,null,null,{"$f":"C185","v":"Nº de empleados"},{"$f":"ROUND(D185*D188,2)+V177","v":0},{"$f":"ROUND(E185*E188,2)+W177","v":0},{"$f":"ROUND(F185*F188,2)+X177","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M185","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C186","v":"Facturación (€)"},{"$f":"ROUND(D186*D188,2)+V178","v":0},{"$f":"ROUND(E186*E188,2)+W178","v":0},{"$f":"ROUND(F186*F188,2)+X178","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N185)","v":"B17"},null,null,null,null,null,{"$f":"C187","v":"Activo total (€)"},{"$f":"ROUND(D187*D188,2)+V179","v":0},{"$f":"ROUND(E187*E188,2)+W179","v":0},{"$f":"ROUND(F187*F188,2)+X179","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C184=\"\",0,IF(INDIRECT(O188)>0.5,1,IF(INDIRECT(O188)>=0.25,INDIRECT(O188),0)))","v":0},{"$f":"IF(C184=\"\",0,IF(INDIRECT(O189)>0.5,1,IF(INDIRECT(O189)>=0.25,INDIRECT(O189),0)))","v":0},{"$f":"IF(C184=\"\",0,IF(INDIRECT(O190)>0.5,1,IF(INDIRECT(O190)>=0.25,INDIRECT(O190),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N185)","v":"G17"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N185)","v":"H17"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N185)","v":"I17"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O193)=$N$9,INDIRECT(O195),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C192=\"\",AND(D196=0,E196=0,F196=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C192","v":""},{"$f":"D192","v":0},{"$f":"E192","v":0},{"$f":"F192","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M192","v":"Ocultar fila"},{"$f":"N185+1","v":18},{"$f":"CONCATENATE(\"F\",N193)","v":"F18"},null,null,null,null,null,{"$f":"C193","v":"Nº de empleados"},{"$f":"ROUND(D193*D196,2)+V185","v":0},{"$f":"ROUND(E193*E196,2)+W185","v":0},{"$f":"ROUND(F193*F196,2)+X185","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M193","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C194","v":"Facturación (€)"},{"$f":"ROUND(D194*D196,2)+V186","v":0},{"$f":"ROUND(E194*E196,2)+W186","v":0},{"$f":"ROUND(F194*F196,2)+X186","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N193)","v":"B18"},null,null,null,null,null,{"$f":"C195","v":"Activo total (€)"},{"$f":"ROUND(D195*D196,2)+V187","v":0},{"$f":"ROUND(E195*E196,2)+W187","v":0},{"$f":"ROUND(F195*F196,2)+X187","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C192=\"\",0,IF(INDIRECT(O196)>0.5,1,IF(INDIRECT(O196)>=0.25,INDIRECT(O196),0)))","v":0},{"$f":"IF(C192=\"\",0,IF(INDIRECT(O197)>0.5,1,IF(INDIRECT(O197)>=0.25,INDIRECT(O197),0)))","v":0},{"$f":"IF(C192=\"\",0,IF(INDIRECT(O198)>0.5,1,IF(INDIRECT(O198)>=0.25,INDIRECT(O198),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N193)","v":"G18"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N193)","v":"H18"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N193)","v":"I18"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O201)=$N$9,INDIRECT(O203),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C200=\"\",AND(D204=0,E204=0,F204=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C200","v":""},{"$f":"D200","v":0},{"$f":"E200","v":0},{"$f":"F200","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M200","v":"Ocultar fila"},{"$f":"N193+1","v":19},{"$f":"CONCATENATE(\"F\",N201)","v":"F19"},null,null,null,null,null,{"$f":"C201","v":"Nº de empleados"},{"$f":"ROUND(D201*D204,2)+V193","v":0},{"$f":"ROUND(E201*E204,2)+W193","v":0},{"$f":"ROUND(F201*F204,2)+X193","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M201","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C202","v":"Facturación (€)"},{"$f":"ROUND(D202*D204,2)+V194","v":0},{"$f":"ROUND(E202*E204,2)+W194","v":0},{"$f":"ROUND(F202*F204,2)+X194","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N201)","v":"B19"},null,null,null,null,null,{"$f":"C203","v":"Activo total (€)"},{"$f":"ROUND(D203*D204,2)+V195","v":0},{"$f":"ROUND(E203*E204,2)+W195","v":0},{"$f":"ROUND(F203*F204,2)+X195","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C200=\"\",0,IF(INDIRECT(O204)>0.5,1,IF(INDIRECT(O204)>=0.25,INDIRECT(O204),0)))","v":0},{"$f":"IF(C200=\"\",0,IF(INDIRECT(O205)>0.5,1,IF(INDIRECT(O205)>=0.25,INDIRECT(O205),0)))","v":0},{"$f":"IF(C200=\"\",0,IF(INDIRECT(O206)>0.5,1,IF(INDIRECT(O206)>=0.25,INDIRECT(O206),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N201)","v":"G19"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N201)","v":"H19"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N201)","v":"I19"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O209)=$N$9,INDIRECT(O211),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C208=\"\",AND(D212=0,E212=0,F212=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C208","v":""},{"$f":"D208","v":0},{"$f":"E208","v":0},{"$f":"F208","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M208","v":"Ocultar fila"},{"$f":"N201+1","v":20},{"$f":"CONCATENATE(\"F\",N209)","v":"F20"},null,null,null,null,null,{"$f":"C209","v":"Nº de empleados"},{"$f":"ROUND(D209*D212,2)+V201","v":0},{"$f":"ROUND(E209*E212,2)+W201","v":0},{"$f":"ROUND(F209*F212,2)+X201","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M209","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C210","v":"Facturación (€)"},{"$f":"ROUND(D210*D212,2)+V202","v":0},{"$f":"ROUND(E210*E212,2)+W202","v":0},{"$f":"ROUND(F210*F212,2)+X202","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N209)","v":"B20"},null,null,null,null,null,{"$f":"C211","v":"Activo total (€)"},{"$f":"ROUND(D211*D212,2)+V203","v":0},{"$f":"ROUND(E211*E212,2)+W203","v":0},{"$f":"ROUND(F211*F212,2)+X203","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C208=\"\",0,IF(INDIRECT(O212)>0.5,1,IF(INDIRECT(O212)>=0.25,INDIRECT(O212),0)))","v":0},{"$f":"IF(C208=\"\",0,IF(INDIRECT(O213)>0.5,1,IF(INDIRECT(O213)>=0.25,INDIRECT(O213),0)))","v":0},{"$f":"IF(C208=\"\",0,IF(INDIRECT(O214)>0.5,1,IF(INDIRECT(O214)>=0.25,INDIRECT(O214),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N209)","v":"G20"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N209)","v":"H20"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N209)","v":"I20"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O217)=$N$9,INDIRECT(O219),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C216=\"\",AND(D220=0,E220=0,F220=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C216","v":""},{"$f":"D216","v":0},{"$f":"E216","v":0},{"$f":"F216","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M216","v":"Ocultar fila"},{"$f":"N209+1","v":21},{"$f":"CONCATENATE(\"F\",N217)","v":"F21"},null,null,null,null,null,{"$f":"C217","v":"Nº de empleados"},{"$f":"ROUND(D217*D220,2)+V209","v":0},{"$f":"ROUND(E217*E220,2)+W209","v":0},{"$f":"ROUND(F217*F220,2)+X209","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M217","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C218","v":"Facturación (€)"},{"$f":"ROUND(D218*D220,2)+V210","v":0},{"$f":"ROUND(E218*E220,2)+W210","v":0},{"$f":"ROUND(F218*F220,2)+X210","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N217)","v":"B21"},null,null,null,null,null,{"$f":"C219","v":"Activo total (€)"},{"$f":"ROUND(D219*D220,2)+V211","v":0},{"$f":"ROUND(E219*E220,2)+W211","v":0},{"$f":"ROUND(F219*F220,2)+X211","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C216=\"\",0,IF(INDIRECT(O220)>0.5,1,IF(INDIRECT(O220)>=0.25,INDIRECT(O220),0)))","v":0},{"$f":"IF(C216=\"\",0,IF(INDIRECT(O221)>0.5,1,IF(INDIRECT(O221)>=0.25,INDIRECT(O221),0)))","v":0},{"$f":"IF(C216=\"\",0,IF(INDIRECT(O222)>0.5,1,IF(INDIRECT(O222)>=0.25,INDIRECT(O222),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N217)","v":"G21"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N217)","v":"H21"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N217)","v":"I21"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O225)=$N$9,INDIRECT(O227),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C224=\"\",AND(D228=0,E228=0,F228=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C224","v":""},{"$f":"D224","v":0},{"$f":"E224","v":0},{"$f":"F224","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M224","v":"Ocultar fila"},{"$f":"N217+1","v":22},{"$f":"CONCATENATE(\"F\",N225)","v":"F22"},null,null,null,null,null,{"$f":"C225","v":"Nº de empleados"},{"$f":"ROUND(D225*D228,2)+V217","v":0},{"$f":"ROUND(E225*E228,2)+W217","v":0},{"$f":"ROUND(F225*F228,2)+X217","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M225","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C226","v":"Facturación (€)"},{"$f":"ROUND(D226*D228,2)+V218","v":0},{"$f":"ROUND(E226*E228,2)+W218","v":0},{"$f":"ROUND(F226*F228,2)+X218","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N225)","v":"B22"},null,null,null,null,null,{"$f":"C227","v":"Activo total (€)"},{"$f":"ROUND(D227*D228,2)+V219","v":0},{"$f":"ROUND(E227*E228,2)+W219","v":0},{"$f":"ROUND(F227*F228,2)+X219","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C224=\"\",0,IF(INDIRECT(O228)>0.5,1,IF(INDIRECT(O228)>=0.25,INDIRECT(O228),0)))","v":0},{"$f":"IF(C224=\"\",0,IF(INDIRECT(O229)>0.5,1,IF(INDIRECT(O229)>=0.25,INDIRECT(O229),0)))","v":0},{"$f":"IF(C224=\"\",0,IF(INDIRECT(O230)>0.5,1,IF(INDIRECT(O230)>=0.25,INDIRECT(O230),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N225)","v":"G22"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N225)","v":"H22"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N225)","v":"I22"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O233)=$N$9,INDIRECT(O235),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C232=\"\",AND(D236=0,E236=0,F236=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C232","v":""},{"$f":"D232","v":0},{"$f":"E232","v":0},{"$f":"F232","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M232","v":"Ocultar fila"},{"$f":"N225+1","v":23},{"$f":"CONCATENATE(\"F\",N233)","v":"F23"},null,null,null,null,null,{"$f":"C233","v":"Nº de empleados"},{"$f":"ROUND(D233*D236,2)+V225","v":0},{"$f":"ROUND(E233*E236,2)+W225","v":0},{"$f":"ROUND(F233*F236,2)+X225","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M233","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C234","v":"Facturación (€)"},{"$f":"ROUND(D234*D236,2)+V226","v":0},{"$f":"ROUND(E234*E236,2)+W226","v":0},{"$f":"ROUND(F234*F236,2)+X226","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N233)","v":"B23"},null,null,null,null,null,{"$f":"C235","v":"Activo total (€)"},{"$f":"ROUND(D235*D236,2)+V227","v":0},{"$f":"ROUND(E235*E236,2)+W227","v":0},{"$f":"ROUND(F235*F236,2)+X227","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C232=\"\",0,IF(INDIRECT(O236)>0.5,1,IF(INDIRECT(O236)>=0.25,INDIRECT(O236),0)))","v":0},{"$f":"IF(C232=\"\",0,IF(INDIRECT(O237)>0.5,1,IF(INDIRECT(O237)>=0.25,INDIRECT(O237),0)))","v":0},{"$f":"IF(C232=\"\",0,IF(INDIRECT(O238)>0.5,1,IF(INDIRECT(O238)>=0.25,INDIRECT(O238),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N233)","v":"G23"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N233)","v":"H23"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N233)","v":"I23"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O241)=$N$9,INDIRECT(O243),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C240=\"\",AND(D244=0,E244=0,F244=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C240","v":""},{"$f":"D240","v":0},{"$f":"E240","v":0},{"$f":"F240","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M240","v":"Ocultar fila"},{"$f":"N233+1","v":24},{"$f":"CONCATENATE(\"F\",N241)","v":"F24"},null,null,null,null,null,{"$f":"C241","v":"Nº de empleados"},{"$f":"ROUND(D241*D244,2)+V233","v":0},{"$f":"ROUND(E241*E244,2)+W233","v":0},{"$f":"ROUND(F241*F244,2)+X233","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M241","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C242","v":"Facturación (€)"},{"$f":"ROUND(D242*D244,2)+V234","v":0},{"$f":"ROUND(E242*E244,2)+W234","v":0},{"$f":"ROUND(F242*F244,2)+X234","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N241)","v":"B24"},null,null,null,null,null,{"$f":"C243","v":"Activo total (€)"},{"$f":"ROUND(D243*D244,2)+V235","v":0},{"$f":"ROUND(E243*E244,2)+W235","v":0},{"$f":"ROUND(F243*F244,2)+X235","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C240=\"\",0,IF(INDIRECT(O244)>0.5,1,IF(INDIRECT(O244)>=0.25,INDIRECT(O244),0)))","v":0},{"$f":"IF(C240=\"\",0,IF(INDIRECT(O245)>0.5,1,IF(INDIRECT(O245)>=0.25,INDIRECT(O245),0)))","v":0},{"$f":"IF(C240=\"\",0,IF(INDIRECT(O246)>0.5,1,IF(INDIRECT(O246)>=0.25,INDIRECT(O246),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N241)","v":"G24"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N241)","v":"H24"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N241)","v":"I24"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O249)=$N$9,INDIRECT(O251),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C248=\"\",AND(D252=0,E252=0,F252=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C248","v":""},{"$f":"D248","v":0},{"$f":"E248","v":0},{"$f":"F248","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M248","v":"Ocultar fila"},{"$f":"N241+1","v":25},{"$f":"CONCATENATE(\"F\",N249)","v":"F25"},null,null,null,null,null,{"$f":"C249","v":"Nº de empleados"},{"$f":"ROUND(D249*D252,2)+V241","v":0},{"$f":"ROUND(E249*E252,2)+W241","v":0},{"$f":"ROUND(F249*F252,2)+X241","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M249","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C250","v":"Facturación (€)"},{"$f":"ROUND(D250*D252,2)+V242","v":0},{"$f":"ROUND(E250*E252,2)+W242","v":0},{"$f":"ROUND(F250*F252,2)+X242","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N249)","v":"B25"},null,null,null,null,null,{"$f":"C251","v":"Activo total (€)"},{"$f":"ROUND(D251*D252,2)+V243","v":0},{"$f":"ROUND(E251*E252,2)+W243","v":0},{"$f":"ROUND(F251*F252,2)+X243","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C248=\"\",0,IF(INDIRECT(O252)>0.5,1,IF(INDIRECT(O252)>=0.25,INDIRECT(O252),0)))","v":0},{"$f":"IF(C248=\"\",0,IF(INDIRECT(O253)>0.5,1,IF(INDIRECT(O253)>=0.25,INDIRECT(O253),0)))","v":0},{"$f":"IF(C248=\"\",0,IF(INDIRECT(O254)>0.5,1,IF(INDIRECT(O254)>=0.25,INDIRECT(O254),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N249)","v":"G25"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N249)","v":"H25"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N249)","v":"I25"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O257)=$N$9,INDIRECT(O259),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C256=\"\",AND(D260=0,E260=0,F260=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C256","v":""},{"$f":"D256","v":0},{"$f":"E256","v":0},{"$f":"F256","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M256","v":"Ocultar fila"},{"$f":"N249+1","v":26},{"$f":"CONCATENATE(\"F\",N257)","v":"F26"},null,null,null,null,null,{"$f":"C257","v":"Nº de empleados"},{"$f":"ROUND(D257*D260,2)+V249","v":0},{"$f":"ROUND(E257*E260,2)+W249","v":0},{"$f":"ROUND(F257*F260,2)+X249","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M257","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C258","v":"Facturación (€)"},{"$f":"ROUND(D258*D260,2)+V250","v":0},{"$f":"ROUND(E258*E260,2)+W250","v":0},{"$f":"ROUND(F258*F260,2)+X250","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N257)","v":"B26"},null,null,null,null,null,{"$f":"C259","v":"Activo total (€)"},{"$f":"ROUND(D259*D260,2)+V251","v":0},{"$f":"ROUND(E259*E260,2)+W251","v":0},{"$f":"ROUND(F259*F260,2)+X251","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C256=\"\",0,IF(INDIRECT(O260)>0.5,1,IF(INDIRECT(O260)>=0.25,INDIRECT(O260),0)))","v":0},{"$f":"IF(C256=\"\",0,IF(INDIRECT(O261)>0.5,1,IF(INDIRECT(O261)>=0.25,INDIRECT(O261),0)))","v":0},{"$f":"IF(C256=\"\",0,IF(INDIRECT(O262)>0.5,1,IF(INDIRECT(O262)>=0.25,INDIRECT(O262),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N257)","v":"G26"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N257)","v":"H26"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N257)","v":"I26"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O265)=$N$9,INDIRECT(O267),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C264=\"\",AND(D268=0,E268=0,F268=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C264","v":""},{"$f":"D264","v":0},{"$f":"E264","v":0},{"$f":"F264","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M264","v":"Ocultar fila"},{"$f":"N257+1","v":27},{"$f":"CONCATENATE(\"F\",N265)","v":"F27"},null,null,null,null,null,{"$f":"C265","v":"Nº de empleados"},{"$f":"ROUND(D265*D268,2)+V257","v":0},{"$f":"ROUND(E265*E268,2)+W257","v":0},{"$f":"ROUND(F265*F268,2)+X257","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M265","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C266","v":"Facturación (€)"},{"$f":"ROUND(D266*D268,2)+V258","v":0},{"$f":"ROUND(E266*E268,2)+W258","v":0},{"$f":"ROUND(F266*F268,2)+X258","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N265)","v":"B27"},null,null,null,null,null,{"$f":"C267","v":"Activo total (€)"},{"$f":"ROUND(D267*D268,2)+V259","v":0},{"$f":"ROUND(E267*E268,2)+W259","v":0},{"$f":"ROUND(F267*F268,2)+X259","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C264=\"\",0,IF(INDIRECT(O268)>0.5,1,IF(INDIRECT(O268)>=0.25,INDIRECT(O268),0)))","v":0},{"$f":"IF(C264=\"\",0,IF(INDIRECT(O269)>0.5,1,IF(INDIRECT(O269)>=0.25,INDIRECT(O269),0)))","v":0},{"$f":"IF(C264=\"\",0,IF(INDIRECT(O270)>0.5,1,IF(INDIRECT(O270)>=0.25,INDIRECT(O270),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N265)","v":"G27"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N265)","v":"H27"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N265)","v":"I27"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O273)=$N$9,INDIRECT(O275),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C272=\"\",AND(D276=0,E276=0,F276=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C272","v":""},{"$f":"D272","v":0},{"$f":"E272","v":0},{"$f":"F272","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M272","v":"Ocultar fila"},{"$f":"N265+1","v":28},{"$f":"CONCATENATE(\"F\",N273)","v":"F28"},null,null,null,null,null,{"$f":"C273","v":"Nº de empleados"},{"$f":"ROUND(D273*D276,2)+V265","v":0},{"$f":"ROUND(E273*E276,2)+W265","v":0},{"$f":"ROUND(F273*F276,2)+X265","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M273","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C274","v":"Facturación (€)"},{"$f":"ROUND(D274*D276,2)+V266","v":0},{"$f":"ROUND(E274*E276,2)+W266","v":0},{"$f":"ROUND(F274*F276,2)+X266","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N273)","v":"B28"},null,null,null,null,null,{"$f":"C275","v":"Activo total (€)"},{"$f":"ROUND(D275*D276,2)+V267","v":0},{"$f":"ROUND(E275*E276,2)+W267","v":0},{"$f":"ROUND(F275*F276,2)+X267","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C272=\"\",0,IF(INDIRECT(O276)>0.5,1,IF(INDIRECT(O276)>=0.25,INDIRECT(O276),0)))","v":0},{"$f":"IF(C272=\"\",0,IF(INDIRECT(O277)>0.5,1,IF(INDIRECT(O277)>=0.25,INDIRECT(O277),0)))","v":0},{"$f":"IF(C272=\"\",0,IF(INDIRECT(O278)>0.5,1,IF(INDIRECT(O278)>=0.25,INDIRECT(O278),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N273)","v":"G28"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N273)","v":"H28"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N273)","v":"I28"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O281)=$N$9,INDIRECT(O283),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C280=\"\",AND(D284=0,E284=0,F284=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C280","v":""},{"$f":"D280","v":0},{"$f":"E280","v":0},{"$f":"F280","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M280","v":"Ocultar fila"},{"$f":"N273+1","v":29},{"$f":"CONCATENATE(\"F\",N281)","v":"F29"},null,null,null,null,null,{"$f":"C281","v":"Nº de empleados"},{"$f":"ROUND(D281*D284,2)+V273","v":0},{"$f":"ROUND(E281*E284,2)+W273","v":0},{"$f":"ROUND(F281*F284,2)+X273","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M281","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C282","v":"Facturación (€)"},{"$f":"ROUND(D282*D284,2)+V274","v":0},{"$f":"ROUND(E282*E284,2)+W274","v":0},{"$f":"ROUND(F282*F284,2)+X274","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N281)","v":"B29"},null,null,null,null,null,{"$f":"C283","v":"Activo total (€)"},{"$f":"ROUND(D283*D284,2)+V275","v":0},{"$f":"ROUND(E283*E284,2)+W275","v":0},{"$f":"ROUND(F283*F284,2)+X275","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C280=\"\",0,IF(INDIRECT(O284)>0.5,1,IF(INDIRECT(O284)>=0.25,INDIRECT(O284),0)))","v":0},{"$f":"IF(C280=\"\",0,IF(INDIRECT(O285)>0.5,1,IF(INDIRECT(O285)>=0.25,INDIRECT(O285),0)))","v":0},{"$f":"IF(C280=\"\",0,IF(INDIRECT(O286)>0.5,1,IF(INDIRECT(O286)>=0.25,INDIRECT(O286),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N281)","v":"G29"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N281)","v":"H29"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N281)","v":"I29"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O291)<>\"\",INDIRECT(O291),\"\")","v":"RAZÓN SOCIAL"},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C288=\"\",AND(D292=0,E292=0,F292=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.","TABLA 2",null,null,null,null,{"$f":"C288","v":"RAZÓN SOCIAL"},{"$f":"D288","v":0},{"$f":"E288","v":0},{"$f":"F288","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M288","v":"Ocultar fila"},{"$f":"N281+6","v":35},null,null,null,null,null,null,{"$f":"C289","v":"Nº de empleados"},{"$f":"ROUND(D289*D292,2)+V281","v":0},{"$f":"ROUND(E289*E292,2)+W281","v":0},{"$f":"ROUND(F289*F292,2)+X281","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M289","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C290","v":"Facturación (€)"},{"$f":"ROUND(D290*D292,2)+V282","v":0},{"$f":"ROUND(E290*E292,2)+W282","v":0},{"$f":"ROUND(F290*F292,2)+X282","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N289)","v":"B35"},"Contiene nombre de la empresa",null,null,null,null,{"$f":"C291","v":"Activo total (€)"},{"$f":"ROUND(D291*D292,2)+V283","v":0},{"$f":"ROUND(E291*E292,2)+W283","v":0},{"$f":"ROUND(F291*F292,2)+X283","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C288=\"\",0,IF(INDIRECT(O292)>0.5,1,IF(INDIRECT(O292)>=0.25,INDIRECT(O292),0)))","v":0},{"$f":"IF(C288=\"\",0,IF(INDIRECT(O293)>0.5,1,IF(INDIRECT(O293)>=0.25,INDIRECT(O293),0)))","v":0},{"$f":"IF(C288=\"\",0,IF(INDIRECT(O294)>0.5,1,IF(INDIRECT(O294)>=0.25,INDIRECT(O294),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N289)","v":"G35"},"Contiene% de participación del primer año",null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N289)","v":"H35"},"Contiene% de participación del segundo año"]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N289)","v":"I35"},"Contiene% de participación del tercer año"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O299)<>\"\",INDIRECT(O299),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C296=\"\",AND(D300=0,E300=0,F300=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C296","v":""},{"$f":"D296","v":0},{"$f":"E296","v":0},{"$f":"F296","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M296","v":"Ocultar fila"},{"$f":"N289+1","v":36},null,null,null,null,null,null,{"$f":"C297","v":"Nº de empleados"},{"$f":"ROUND(D297*D300,2)+V289","v":0},{"$f":"ROUND(E297*E300,2)+W289","v":0},{"$f":"ROUND(F297*F300,2)+X289","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M297","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C298","v":"Facturación (€)"},{"$f":"ROUND(D298*D300,2)+V290","v":0},{"$f":"ROUND(E298*E300,2)+W290","v":0},{"$f":"ROUND(F298*F300,2)+X290","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N297)","v":"B36"},null,null,null,null,null,{"$f":"C299","v":"Activo total (€)"},{"$f":"ROUND(D299*D300,2)+V291","v":0},{"$f":"ROUND(E299*E300,2)+W291","v":0},{"$f":"ROUND(F299*F300,2)+X291","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C296=\"\",0,IF(INDIRECT(O300)>0.5,1,IF(INDIRECT(O300)>=0.25,INDIRECT(O300),0)))","v":0},{"$f":"IF(C296=\"\",0,IF(INDIRECT(O301)>0.5,1,IF(INDIRECT(O301)>=0.25,INDIRECT(O301),0)))","v":0},{"$f":"IF(C296=\"\",0,IF(INDIRECT(O302)>0.5,1,IF(INDIRECT(O302)>=0.25,INDIRECT(O302),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N297)","v":"G36"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N297)","v":"H36"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N297)","v":"I36"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O307)<>\"\",INDIRECT(O307),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C304=\"\",AND(D308=0,E308=0,F308=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C304","v":""},{"$f":"D304","v":0},{"$f":"E304","v":0},{"$f":"F304","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M304","v":"Ocultar fila"},{"$f":"N297+1","v":37},null,null,null,null,null,null,{"$f":"C305","v":"Nº de empleados"},{"$f":"ROUND(D305*D308,2)+V297","v":0},{"$f":"ROUND(E305*E308,2)+W297","v":0},{"$f":"ROUND(F305*F308,2)+X297","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M305","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C306","v":"Facturación (€)"},{"$f":"ROUND(D306*D308,2)+V298","v":0},{"$f":"ROUND(E306*E308,2)+W298","v":0},{"$f":"ROUND(F306*F308,2)+X298","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N305)","v":"B37"},null,null,null,null,null,{"$f":"C307","v":"Activo total (€)"},{"$f":"ROUND(D307*D308,2)+V299","v":0},{"$f":"ROUND(E307*E308,2)+W299","v":0},{"$f":"ROUND(F307*F308,2)+X299","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C304=\"\",0,IF(INDIRECT(O308)>0.5,1,IF(INDIRECT(O308)>=0.25,INDIRECT(O308),0)))","v":0},{"$f":"IF(C304=\"\",0,IF(INDIRECT(O309)>0.5,1,IF(INDIRECT(O309)>=0.25,INDIRECT(O309),0)))","v":0},{"$f":"IF(C304=\"\",0,IF(INDIRECT(O310)>0.5,1,IF(INDIRECT(O310)>=0.25,INDIRECT(O310),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N305)","v":"G37"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N305)","v":"H37"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N305)","v":"I37"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O315)<>\"\",INDIRECT(O315),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C312=\"\",AND(D316=0,E316=0,F316=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C312","v":""},{"$f":"D312","v":0},{"$f":"E312","v":0},{"$f":"F312","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M312","v":"Ocultar fila"},{"$f":"N305+1","v":38},null,null,null,null,null,null,{"$f":"C313","v":"Nº de empleados"},{"$f":"ROUND(D313*D316,2)+V305","v":0},{"$f":"ROUND(E313*E316,2)+W305","v":0},{"$f":"ROUND(F313*F316,2)+X305","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M313","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C314","v":"Facturación (€)"},{"$f":"ROUND(D314*D316,2)+V306","v":0},{"$f":"ROUND(E314*E316,2)+W306","v":0},{"$f":"ROUND(F314*F316,2)+X306","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N313)","v":"B38"},null,null,null,null,null,{"$f":"C315","v":"Activo total (€)"},{"$f":"ROUND(D315*D316,2)+V307","v":0},{"$f":"ROUND(E315*E316,2)+W307","v":0},{"$f":"ROUND(F315*F316,2)+X307","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C312=\"\",0,IF(INDIRECT(O316)>0.5,1,IF(INDIRECT(O316)>=0.25,INDIRECT(O316),0)))","v":0},{"$f":"IF(C312=\"\",0,IF(INDIRECT(O317)>0.5,1,IF(INDIRECT(O317)>=0.25,INDIRECT(O317),0)))","v":0},{"$f":"IF(C312=\"\",0,IF(INDIRECT(O318)>0.5,1,IF(INDIRECT(O318)>=0.25,INDIRECT(O318),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N313)","v":"G38"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N313)","v":"H38"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N313)","v":"I38"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O323)<>\"\",INDIRECT(O323),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C320=\"\",AND(D324=0,E324=0,F324=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C320","v":""},{"$f":"D320","v":0},{"$f":"E320","v":0},{"$f":"F320","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M320","v":"Ocultar fila"},{"$f":"N313+1","v":39},null,null,null,null,null,null,{"$f":"C321","v":"Nº de empleados"},{"$f":"ROUND(D321*D324,2)+V313","v":0},{"$f":"ROUND(E321*E324,2)+W313","v":0},{"$f":"ROUND(F321*F324,2)+X313","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M321","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C322","v":"Facturación (€)"},{"$f":"ROUND(D322*D324,2)+V314","v":0},{"$f":"ROUND(E322*E324,2)+W314","v":0},{"$f":"ROUND(F322*F324,2)+X314","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N321)","v":"B39"},null,null,null,null,null,{"$f":"C323","v":"Activo total (€)"},{"$f":"ROUND(D323*D324,2)+V315","v":0},{"$f":"ROUND(E323*E324,2)+W315","v":0},{"$f":"ROUND(F323*F324,2)+X315","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C320=\"\",0,IF(INDIRECT(O324)>0.5,1,IF(INDIRECT(O324)>=0.25,INDIRECT(O324),0)))","v":0},{"$f":"IF(C320=\"\",0,IF(INDIRECT(O325)>0.5,1,IF(INDIRECT(O325)>=0.25,INDIRECT(O325),0)))","v":0},{"$f":"IF(C320=\"\",0,IF(INDIRECT(O326)>0.5,1,IF(INDIRECT(O326)>=0.25,INDIRECT(O326),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N321)","v":"G39"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N321)","v":"H39"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N321)","v":"I39"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O331)<>\"\",INDIRECT(O331),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C328=\"\",AND(D332=0,E332=0,F332=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C328","v":""},{"$f":"D328","v":0},{"$f":"E328","v":0},{"$f":"F328","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M328","v":"Ocultar fila"},{"$f":"N321+1","v":40},null,null,null,null,null,null,{"$f":"C329","v":"Nº de empleados"},{"$f":"ROUND(D329*D332,2)+V321","v":0},{"$f":"ROUND(E329*E332,2)+W321","v":0},{"$f":"ROUND(F329*F332,2)+X321","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M329","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C330","v":"Facturación (€)"},{"$f":"ROUND(D330*D332,2)+V322","v":0},{"$f":"ROUND(E330*E332,2)+W322","v":0},{"$f":"ROUND(F330*F332,2)+X322","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N329)","v":"B40"},null,null,null,null,null,{"$f":"C331","v":"Activo total (€)"},{"$f":"ROUND(D331*D332,2)+V323","v":0},{"$f":"ROUND(E331*E332,2)+W323","v":0},{"$f":"ROUND(F331*F332,2)+X323","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C328=\"\",0,IF(INDIRECT(O332)>0.5,1,IF(INDIRECT(O332)>=0.25,INDIRECT(O332),0)))","v":0},{"$f":"IF(C328=\"\",0,IF(INDIRECT(O333)>0.5,1,IF(INDIRECT(O333)>=0.25,INDIRECT(O333),0)))","v":0},{"$f":"IF(C328=\"\",0,IF(INDIRECT(O334)>0.5,1,IF(INDIRECT(O334)>=0.25,INDIRECT(O334),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N329)","v":"G40"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N329)","v":"H40"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N329)","v":"I40"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O339)<>\"\",INDIRECT(O339),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C336=\"\",AND(D340=0,E340=0,F340=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C336","v":""},{"$f":"D336","v":0},{"$f":"E336","v":0},{"$f":"F336","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M336","v":"Ocultar fila"},{"$f":"N329+1","v":41},null,null,null,null,null,null,{"$f":"C337","v":"Nº de empleados"},{"$f":"ROUND(D337*D340,2)+V329","v":0},{"$f":"ROUND(E337*E340,2)+W329","v":0},{"$f":"ROUND(F337*F340,2)+X329","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M337","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C338","v":"Facturación (€)"},{"$f":"ROUND(D338*D340,2)+V330","v":0},{"$f":"ROUND(E338*E340,2)+W330","v":0},{"$f":"ROUND(F338*F340,2)+X330","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N337)","v":"B41"},null,null,null,null,null,{"$f":"C339","v":"Activo total (€)"},{"$f":"ROUND(D339*D340,2)+V331","v":0},{"$f":"ROUND(E339*E340,2)+W331","v":0},{"$f":"ROUND(F339*F340,2)+X331","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C336=\"\",0,IF(INDIRECT(O340)>0.5,1,IF(INDIRECT(O340)>=0.25,INDIRECT(O340),0)))","v":0},{"$f":"IF(C336=\"\",0,IF(INDIRECT(O341)>0.5,1,IF(INDIRECT(O341)>=0.25,INDIRECT(O341),0)))","v":0},{"$f":"IF(C336=\"\",0,IF(INDIRECT(O342)>0.5,1,IF(INDIRECT(O342)>=0.25,INDIRECT(O342),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N337)","v":"G41"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N337)","v":"H41"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N337)","v":"I41"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O347)<>\"\",INDIRECT(O347),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C344=\"\",AND(D348=0,E348=0,F348=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C344","v":""},{"$f":"D344","v":0},{"$f":"E344","v":0},{"$f":"F344","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M344","v":"Ocultar fila"},{"$f":"N337+1","v":42},null,null,null,null,null,null,{"$f":"C345","v":"Nº de empleados"},{"$f":"ROUND(D345*D348,2)+V337","v":0},{"$f":"ROUND(E345*E348,2)+W337","v":0},{"$f":"ROUND(F345*F348,2)+X337","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M345","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C346","v":"Facturación (€)"},{"$f":"ROUND(D346*D348,2)+V338","v":0},{"$f":"ROUND(E346*E348,2)+W338","v":0},{"$f":"ROUND(F346*F348,2)+X338","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N345)","v":"B42"},null,null,null,null,null,{"$f":"C347","v":"Activo total (€)"},{"$f":"ROUND(D347*D348,2)+V339","v":0},{"$f":"ROUND(E347*E348,2)+W339","v":0},{"$f":"ROUND(F347*F348,2)+X339","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C344=\"\",0,IF(INDIRECT(O348)>0.5,1,IF(INDIRECT(O348)>=0.25,INDIRECT(O348),0)))","v":0},{"$f":"IF(C344=\"\",0,IF(INDIRECT(O349)>0.5,1,IF(INDIRECT(O349)>=0.25,INDIRECT(O349),0)))","v":0},{"$f":"IF(C344=\"\",0,IF(INDIRECT(O350)>0.5,1,IF(INDIRECT(O350)>=0.25,INDIRECT(O350),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N345)","v":"G42"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N345)","v":"H42"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N345)","v":"I42"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O355)<>\"\",INDIRECT(O355),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C352=\"\",AND(D356=0,E356=0,F356=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C352","v":""},{"$f":"D352","v":0},{"$f":"E352","v":0},{"$f":"F352","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M352","v":"Ocultar fila"},{"$f":"N345+1","v":43},null,null,null,null,null,null,{"$f":"C353","v":"Nº de empleados"},{"$f":"ROUND(D353*D356,2)+V345","v":0},{"$f":"ROUND(E353*E356,2)+W345","v":0},{"$f":"ROUND(F353*F356,2)+X345","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M353","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C354","v":"Facturación (€)"},{"$f":"ROUND(D354*D356,2)+V346","v":0},{"$f":"ROUND(E354*E356,2)+W346","v":0},{"$f":"ROUND(F354*F356,2)+X346","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N353)","v":"B43"},null,null,null,null,null,{"$f":"C355","v":"Activo total (€)"},{"$f":"ROUND(D355*D356,2)+V347","v":0},{"$f":"ROUND(E355*E356,2)+W347","v":0},{"$f":"ROUND(F355*F356,2)+X347","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C352=\"\",0,IF(INDIRECT(O356)>0.5,1,IF(INDIRECT(O356)>=0.25,INDIRECT(O356),0)))","v":0},{"$f":"IF(C352=\"\",0,IF(INDIRECT(O357)>0.5,1,IF(INDIRECT(O357)>=0.25,INDIRECT(O357),0)))","v":0},{"$f":"IF(C352=\"\",0,IF(INDIRECT(O358)>0.5,1,IF(INDIRECT(O358)>=0.25,INDIRECT(O358),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N353)","v":"G43"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N353)","v":"H43"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N353)","v":"I43"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O363)<>\"\",INDIRECT(O363),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C360=\"\",AND(D364=0,E364=0,F364=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C360","v":""},{"$f":"D360","v":0},{"$f":"E360","v":0},{"$f":"F360","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M360","v":"Ocultar fila"},{"$f":"N353+1","v":44},null,null,null,null,null,null,{"$f":"C361","v":"Nº de empleados"},{"$f":"ROUND(D361*D364,2)+V353","v":0},{"$f":"ROUND(E361*E364,2)+W353","v":0},{"$f":"ROUND(F361*F364,2)+X353","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M361","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C362","v":"Facturación (€)"},{"$f":"ROUND(D362*D364,2)+V354","v":0},{"$f":"ROUND(E362*E364,2)+W354","v":0},{"$f":"ROUND(F362*F364,2)+X354","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N361)","v":"B44"},null,null,null,null,null,{"$f":"C363","v":"Activo total (€)"},{"$f":"ROUND(D363*D364,2)+V355","v":0},{"$f":"ROUND(E363*E364,2)+W355","v":0},{"$f":"ROUND(F363*F364,2)+X355","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C360=\"\",0,IF(INDIRECT(O364)>0.5,1,IF(INDIRECT(O364)>=0.25,INDIRECT(O364),0)))","v":0},{"$f":"IF(C360=\"\",0,IF(INDIRECT(O365)>0.5,1,IF(INDIRECT(O365)>=0.25,INDIRECT(O365),0)))","v":0},{"$f":"IF(C360=\"\",0,IF(INDIRECT(O366)>0.5,1,IF(INDIRECT(O366)>=0.25,INDIRECT(O366),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N361)","v":"G44"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N361)","v":"H44"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N361)","v":"I44"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O371)<>\"\",INDIRECT(O371),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C368=\"\",AND(D372=0,E372=0,F372=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C368","v":""},{"$f":"D368","v":0},{"$f":"E368","v":0},{"$f":"F368","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M368","v":"Ocultar fila"},{"$f":"N361+1","v":45},null,null,null,null,null,null,{"$f":"C369","v":"Nº de empleados"},{"$f":"ROUND(D369*D372,2)+V361","v":0},{"$f":"ROUND(E369*E372,2)+W361","v":0},{"$f":"ROUND(F369*F372,2)+X361","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M369","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C370","v":"Facturación (€)"},{"$f":"ROUND(D370*D372,2)+V362","v":0},{"$f":"ROUND(E370*E372,2)+W362","v":0},{"$f":"ROUND(F370*F372,2)+X362","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N369)","v":"B45"},null,null,null,null,null,{"$f":"C371","v":"Activo total (€)"},{"$f":"ROUND(D371*D372,2)+V363","v":0},{"$f":"ROUND(E371*E372,2)+W363","v":0},{"$f":"ROUND(F371*F372,2)+X363","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C368=\"\",0,IF(INDIRECT(O372)>0.5,1,IF(INDIRECT(O372)>=0.25,INDIRECT(O372),0)))","v":0},{"$f":"IF(C368=\"\",0,IF(INDIRECT(O373)>0.5,1,IF(INDIRECT(O373)>=0.25,INDIRECT(O373),0)))","v":0},{"$f":"IF(C368=\"\",0,IF(INDIRECT(O374)>0.5,1,IF(INDIRECT(O374)>=0.25,INDIRECT(O374),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N369)","v":"G45"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N369)","v":"H45"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N369)","v":"I45"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O379)<>\"\",INDIRECT(O379),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C376=\"\",AND(D380=0,E380=0,F380=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C376","v":""},{"$f":"D376","v":0},{"$f":"E376","v":0},{"$f":"F376","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M376","v":"Ocultar fila"},{"$f":"N369+1","v":46},null,null,null,null,null,null,{"$f":"C377","v":"Nº de empleados"},{"$f":"ROUND(D377*D380,2)+V369","v":0},{"$f":"ROUND(E377*E380,2)+W369","v":0},{"$f":"ROUND(F377*F380,2)+X369","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M377","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C378","v":"Facturación (€)"},{"$f":"ROUND(D378*D380,2)+V370","v":0},{"$f":"ROUND(E378*E380,2)+W370","v":0},{"$f":"ROUND(F378*F380,2)+X370","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N377)","v":"B46"},null,null,null,null,null,{"$f":"C379","v":"Activo total (€)"},{"$f":"ROUND(D379*D380,2)+V371","v":0},{"$f":"ROUND(E379*E380,2)+W371","v":0},{"$f":"ROUND(F379*F380,2)+X371","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C376=\"\",0,IF(INDIRECT(O380)>0.5,1,IF(INDIRECT(O380)>=0.25,INDIRECT(O380),0)))","v":0},{"$f":"IF(C376=\"\",0,IF(INDIRECT(O381)>0.5,1,IF(INDIRECT(O381)>=0.25,INDIRECT(O381),0)))","v":0},{"$f":"IF(C376=\"\",0,IF(INDIRECT(O382)>0.5,1,IF(INDIRECT(O382)>=0.25,INDIRECT(O382),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N377)","v":"G46"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N377)","v":"H46"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N377)","v":"I46"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O387)<>\"\",INDIRECT(O387),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C384=\"\",AND(D388=0,E388=0,F388=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C384","v":""},{"$f":"D384","v":0},{"$f":"E384","v":0},{"$f":"F384","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M384","v":"Ocultar fila"},{"$f":"N377+1","v":47},null,null,null,null,null,null,{"$f":"C385","v":"Nº de empleados"},{"$f":"ROUND(D385*D388,2)+V377","v":0},{"$f":"ROUND(E385*E388,2)+W377","v":0},{"$f":"ROUND(F385*F388,2)+X377","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M385","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C386","v":"Facturación (€)"},{"$f":"ROUND(D386*D388,2)+V378","v":0},{"$f":"ROUND(E386*E388,2)+W378","v":0},{"$f":"ROUND(F386*F388,2)+X378","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N385)","v":"B47"},null,null,null,null,null,{"$f":"C387","v":"Activo total (€)"},{"$f":"ROUND(D387*D388,2)+V379","v":0},{"$f":"ROUND(E387*E388,2)+W379","v":0},{"$f":"ROUND(F387*F388,2)+X379","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C384=\"\",0,IF(INDIRECT(O388)>0.5,1,IF(INDIRECT(O388)>=0.25,INDIRECT(O388),0)))","v":0},{"$f":"IF(C384=\"\",0,IF(INDIRECT(O389)>0.5,1,IF(INDIRECT(O389)>=0.25,INDIRECT(O389),0)))","v":0},{"$f":"IF(C384=\"\",0,IF(INDIRECT(O390)>0.5,1,IF(INDIRECT(O390)>=0.25,INDIRECT(O390),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N385)","v":"G47"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N385)","v":"H47"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N385)","v":"I47"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O395)<>\"\",INDIRECT(O395),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C392=\"\",AND(D396=0,E396=0,F396=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C392","v":""},{"$f":"D392","v":0},{"$f":"E392","v":0},{"$f":"F392","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M392","v":"Ocultar fila"},{"$f":"N385+1","v":48},null,null,null,null,null,null,{"$f":"C393","v":"Nº de empleados"},{"$f":"ROUND(D393*D396,2)+V385","v":0},{"$f":"ROUND(E393*E396,2)+W385","v":0},{"$f":"ROUND(F393*F396,2)+X385","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M393","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C394","v":"Facturación (€)"},{"$f":"ROUND(D394*D396,2)+V386","v":0},{"$f":"ROUND(E394*E396,2)+W386","v":0},{"$f":"ROUND(F394*F396,2)+X386","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N393)","v":"B48"},null,null,null,null,null,{"$f":"C395","v":"Activo total (€)"},{"$f":"ROUND(D395*D396,2)+V387","v":0},{"$f":"ROUND(E395*E396,2)+W387","v":0},{"$f":"ROUND(F395*F396,2)+X387","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C392=\"\",0,IF(INDIRECT(O396)>0.5,1,IF(INDIRECT(O396)>=0.25,INDIRECT(O396),0)))","v":0},{"$f":"IF(C392=\"\",0,IF(INDIRECT(O397)>0.5,1,IF(INDIRECT(O397)>=0.25,INDIRECT(O397),0)))","v":0},{"$f":"IF(C392=\"\",0,IF(INDIRECT(O398)>0.5,1,IF(INDIRECT(O398)>=0.25,INDIRECT(O398),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N393)","v":"G48"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N393)","v":"H48"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N393)","v":"I48"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O403)<>\"\",INDIRECT(O403),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C400=\"\",AND(D404=0,E404=0,F404=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C400","v":""},{"$f":"D400","v":0},{"$f":"E400","v":0},{"$f":"F400","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M400","v":"Ocultar fila"},{"$f":"N393+1","v":49},null,null,null,null,null,null,{"$f":"C401","v":"Nº de empleados"},{"$f":"ROUND(D401*D404,2)+V393","v":0},{"$f":"ROUND(E401*E404,2)+W393","v":0},{"$f":"ROUND(F401*F404,2)+X393","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M401","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C402","v":"Facturación (€)"},{"$f":"ROUND(D402*D404,2)+V394","v":0},{"$f":"ROUND(E402*E404,2)+W394","v":0},{"$f":"ROUND(F402*F404,2)+X394","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N401)","v":"B49"},null,null,null,null,null,{"$f":"C403","v":"Activo total (€)"},{"$f":"ROUND(D403*D404,2)+V395","v":0},{"$f":"ROUND(E403*E404,2)+W395","v":0},{"$f":"ROUND(F403*F404,2)+X395","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C400=\"\",0,IF(INDIRECT(O404)>0.5,1,IF(INDIRECT(O404)>=0.25,INDIRECT(O404),0)))","v":0},{"$f":"IF(C400=\"\",0,IF(INDIRECT(O405)>0.5,1,IF(INDIRECT(O405)>=0.25,INDIRECT(O405),0)))","v":0},{"$f":"IF(C400=\"\",0,IF(INDIRECT(O406)>0.5,1,IF(INDIRECT(O406)>=0.25,INDIRECT(O406),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N401)","v":"G49"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N401)","v":"H49"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N401)","v":"I49"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O411)<>\"\",INDIRECT(O411),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C408=\"\",AND(D412=0,E412=0,F412=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C408","v":""},{"$f":"D408","v":0},{"$f":"E408","v":0},{"$f":"F408","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M408","v":"Ocultar fila"},{"$f":"N401+1","v":50},null,null,null,null,null,null,{"$f":"C409","v":"Nº de empleados"},{"$f":"ROUND(D409*D412,2)+V401","v":0},{"$f":"ROUND(E409*E412,2)+W401","v":0},{"$f":"ROUND(F409*F412,2)+X401","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M409","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C410","v":"Facturación (€)"},{"$f":"ROUND(D410*D412,2)+V402","v":0},{"$f":"ROUND(E410*E412,2)+W402","v":0},{"$f":"ROUND(F410*F412,2)+X402","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N409)","v":"B50"},null,null,null,null,null,{"$f":"C411","v":"Activo total (€)"},{"$f":"ROUND(D411*D412,2)+V403","v":0},{"$f":"ROUND(E411*E412,2)+W403","v":0},{"$f":"ROUND(F411*F412,2)+X403","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C408=\"\",0,IF(INDIRECT(O412)>0.5,1,IF(INDIRECT(O412)>=0.25,INDIRECT(O412),0)))","v":0},{"$f":"IF(C408=\"\",0,IF(INDIRECT(O413)>0.5,1,IF(INDIRECT(O413)>=0.25,INDIRECT(O413),0)))","v":0},{"$f":"IF(C408=\"\",0,IF(INDIRECT(O414)>0.5,1,IF(INDIRECT(O414)>=0.25,INDIRECT(O414),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N409)","v":"G50"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N409)","v":"H50"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N409)","v":"I50"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O419)<>\"\",INDIRECT(O419),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C416=\"\",AND(D420=0,E420=0,F420=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C416","v":""},{"$f":"D416","v":0},{"$f":"E416","v":0},{"$f":"F416","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M416","v":"Ocultar fila"},{"$f":"N409+1","v":51},null,null,null,null,null,null,{"$f":"C417","v":"Nº de empleados"},{"$f":"ROUND(D417*D420,2)+V409","v":0},{"$f":"ROUND(E417*E420,2)+W409","v":0},{"$f":"ROUND(F417*F420,2)+X409","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M417","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C418","v":"Facturación (€)"},{"$f":"ROUND(D418*D420,2)+V410","v":0},{"$f":"ROUND(E418*E420,2)+W410","v":0},{"$f":"ROUND(F418*F420,2)+X410","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N417)","v":"B51"},null,null,null,null,null,{"$f":"C419","v":"Activo total (€)"},{"$f":"ROUND(D419*D420,2)+V411","v":0},{"$f":"ROUND(E419*E420,2)+W411","v":0},{"$f":"ROUND(F419*F420,2)+X411","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C416=\"\",0,IF(INDIRECT(O420)>0.5,1,IF(INDIRECT(O420)>=0.25,INDIRECT(O420),0)))","v":0},{"$f":"IF(C416=\"\",0,IF(INDIRECT(O421)>0.5,1,IF(INDIRECT(O421)>=0.25,INDIRECT(O421),0)))","v":0},{"$f":"IF(C416=\"\",0,IF(INDIRECT(O422)>0.5,1,IF(INDIRECT(O422)>=0.25,INDIRECT(O422),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N417)","v":"G51"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N417)","v":"H51"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N417)","v":"I51"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(INDIRECT(O427)<>\"\",INDIRECT(O427),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C424=\"\",AND(D428=0,E428=0,F428=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C424","v":""},{"$f":"D424","v":0},{"$f":"E424","v":0},{"$f":"F424","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M424","v":"Ocultar fila"},{"$f":"N417+1","v":52},null,null,null,null,null,null,{"$f":"C425","v":"Nº de empleados"},{"$f":"ROUND(D425*D428,2)+V417","v":0},{"$f":"ROUND(E425*E428,2)+W417","v":0},{"$f":"ROUND(F425*F428,2)+X417","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,{"$f":"M425","v":"Ocultar fila"},null,null,null,null,null,null,null,{"$f":"C426","v":"Facturación (€)"},{"$f":"ROUND(D426*D428,2)+V418","v":0},{"$f":"ROUND(E426*E428,2)+W418","v":0},{"$f":"ROUND(F426*F428,2)+X418","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N425)","v":"B52"},null,null,null,null,null,{"$f":"C427","v":"Activo total (€)"},{"$f":"ROUND(D427*D428,2)+V419","v":0},{"$f":"ROUND(E427*E428,2)+W419","v":0},{"$f":"ROUND(F427*F428,2)+X419","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C424=\"\",0,IF(INDIRECT(O428)>0.5,1,IF(INDIRECT(O428)>=0.25,INDIRECT(O428),0)))","v":0},{"$f":"IF(C424=\"\",0,IF(INDIRECT(O429)>0.5,1,IF(INDIRECT(O429)>=0.25,INDIRECT(O429),0)))","v":0},{"$f":"IF(C424=\"\",0,IF(INDIRECT(O430)>0.5,1,IF(INDIRECT(O430)>=0.25,INDIRECT(O430),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N425)","v":"G52"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N425)","v":"H52"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N425)","v":"I52"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(OR(INDIRECT(O433)=$N$6,INDIRECT(O434)=$N$6),INDIRECT(O435),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C432=\"\",AND(D436=0,E436=0,F436=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.","TABLA 3",null,null,null,null,{"$f":"C432","v":""},{"$f":"D432","v":0},{"$f":"E432","v":0},{"$f":"F432","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M432","v":"Ocultar fila"},{"$f":"N425+10","v":62},{"$f":"CONCATENATE(\"D\",N433)","v":"D62"},"Celda donde se selecciona si tiene el mismo CNAE",null,null,null,null,{"$f":"C433","v":"Nº de empleados"},{"$f":"ROUND(D433*D436,2)+V425","v":0},{"$f":"ROUND(E433*E436,2)+W425","v":0},{"$f":"ROUND(F433*F436,2)+X425","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"F\",N433)","v":"F62"},"Celda donde se selecciona si son mercados contiguos",null,null,null,null,{"$f":"C434","v":"Facturación (€)"},{"$f":"ROUND(D434*D436,2)+V426","v":0},{"$f":"ROUND(E434*E436,2)+W426","v":0},{"$f":"ROUND(F434*F436,2)+X426","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N433-5)","v":"B57"},"Contiene nombre de la empresa",null,null,null,null,{"$f":"C435","v":"Activo total (€)"},{"$f":"ROUND(D435*D436,2)+V427","v":0},{"$f":"ROUND(E435*E436,2)+W427","v":0},{"$f":"ROUND(F435*F436,2)+X427","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C432=\"\",0,IF(INDIRECT(O436)>0.5,1,IF(INDIRECT(O436)>=0.25,INDIRECT(O436),0)))","v":0},{"$f":"IF(C432=\"\",0,IF(INDIRECT(O437)>0.5,1,IF(INDIRECT(O437)>=0.25,INDIRECT(O437),0)))","v":0},{"$f":"IF(C432=\"\",0,IF(INDIRECT(O438)>0.5,1,IF(INDIRECT(O438)>=0.25,INDIRECT(O438),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N433)","v":"G62"},"Contiene% de participación del primer año",null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N433)","v":"H62"},"Contiene% de participación del segundo año"]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N433)","v":"I62"},"Contiene% de participación del tercer año"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(OR(INDIRECT(O441)=$N$6,INDIRECT(O442)=$N$6),INDIRECT(O443),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C440=\"\",AND(D444=0,E444=0,F444=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C440","v":""},{"$f":"D440","v":0},{"$f":"E440","v":0},{"$f":"F440","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M440","v":"Ocultar fila"},{"$f":"N433+6","v":68},{"$f":"CONCATENATE(\"D\",N441)","v":"D68"},null,null,null,null,null,{"$f":"C441","v":"Nº de empleados"},{"$f":"ROUND(D441*D444,2)+V433","v":0},{"$f":"ROUND(E441*E444,2)+W433","v":0},{"$f":"ROUND(F441*F444,2)+X433","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"F\",N441)","v":"F68"},null,null,null,null,null,{"$f":"C442","v":"Facturación (€)"},{"$f":"ROUND(D442*D444,2)+V434","v":0},{"$f":"ROUND(E442*E444,2)+W434","v":0},{"$f":"ROUND(F442*F444,2)+X434","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N441-5)","v":"B63"},null,null,null,null,null,{"$f":"C443","v":"Activo total (€)"},{"$f":"ROUND(D443*D444,2)+V435","v":0},{"$f":"ROUND(E443*E444,2)+W435","v":0},{"$f":"ROUND(F443*F444,2)+X435","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C440=\"\",0,IF(INDIRECT(O444)>0.5,1,IF(INDIRECT(O444)>=0.25,INDIRECT(O444),0)))","v":0},{"$f":"IF(C440=\"\",0,IF(INDIRECT(O445)>0.5,1,IF(INDIRECT(O445)>=0.25,INDIRECT(O445),0)))","v":0},{"$f":"IF(C440=\"\",0,IF(INDIRECT(O446)>0.5,1,IF(INDIRECT(O446)>=0.25,INDIRECT(O446),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N441)","v":"G68"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N441)","v":"H68"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N441)","v":"I68"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(OR(INDIRECT(O449)=$N$6,INDIRECT(O450)=$N$6),INDIRECT(O451),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C448=\"\",AND(D452=0,E452=0,F452=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C448","v":""},{"$f":"D448","v":0},{"$f":"E448","v":0},{"$f":"F448","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M448","v":"Ocultar fila"},{"$f":"N441+6","v":74},{"$f":"CONCATENATE(\"D\",N449)","v":"D74"},null,null,null,null,null,{"$f":"C449","v":"Nº de empleados"},{"$f":"ROUND(D449*D452,2)+V441","v":0},{"$f":"ROUND(E449*E452,2)+W441","v":0},{"$f":"ROUND(F449*F452,2)+X441","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"F\",N449)","v":"F74"},null,null,null,null,null,{"$f":"C450","v":"Facturación (€)"},{"$f":"ROUND(D450*D452,2)+V442","v":0},{"$f":"ROUND(E450*E452,2)+W442","v":0},{"$f":"ROUND(F450*F452,2)+X442","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N449-5)","v":"B69"},null,null,null,null,null,{"$f":"C451","v":"Activo total (€)"},{"$f":"ROUND(D451*D452,2)+V443","v":0},{"$f":"ROUND(E451*E452,2)+W443","v":0},{"$f":"ROUND(F451*F452,2)+X443","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C448=\"\",0,IF(INDIRECT(O452)>0.5,1,IF(INDIRECT(O452)>=0.25,INDIRECT(O452),0)))","v":0},{"$f":"IF(C448=\"\",0,IF(INDIRECT(O453)>0.5,1,IF(INDIRECT(O453)>=0.25,INDIRECT(O453),0)))","v":0},{"$f":"IF(C448=\"\",0,IF(INDIRECT(O454)>0.5,1,IF(INDIRECT(O454)>=0.25,INDIRECT(O454),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N449)","v":"G74"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N449)","v":"H74"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N449)","v":"I74"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(OR(INDIRECT(O457)=$N$6,INDIRECT(O458)=$N$6),INDIRECT(O459),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C456=\"\",AND(D460=0,E460=0,F460=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C456","v":""},{"$f":"D456","v":0},{"$f":"E456","v":0},{"$f":"F456","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,{"$f":"M456","v":"Ocultar fila"},{"$f":"N449+6","v":80},{"$f":"CONCATENATE(\"D\",N457)","v":"D80"},null,null,null,null,null,{"$f":"C457","v":"Nº de empleados"},{"$f":"ROUND(D457*D460,2)+V449","v":0},{"$f":"ROUND(E457*E460,2)+W449","v":0},{"$f":"ROUND(F457*F460,2)+X449","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"F\",N457)","v":"F80"},null,null,null,null,null,{"$f":"C458","v":"Facturación (€)"},{"$f":"ROUND(D458*D460,2)+V450","v":0},{"$f":"ROUND(E458*E460,2)+W450","v":0},{"$f":"ROUND(F458*F460,2)+X450","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N457-5)","v":"B75"},null,null,null,null,null,{"$f":"C459","v":"Activo total (€)"},{"$f":"ROUND(D459*D460,2)+V451","v":0},{"$f":"ROUND(E459*E460,2)+W451","v":0},{"$f":"ROUND(F459*F460,2)+X451","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C456=\"\",0,IF(INDIRECT(O460)>0.5,1,IF(INDIRECT(O460)>=0.25,INDIRECT(O460),0)))","v":0},{"$f":"IF(C456=\"\",0,IF(INDIRECT(O461)>0.5,1,IF(INDIRECT(O461)>=0.25,INDIRECT(O461),0)))","v":0},{"$f":"IF(C456=\"\",0,IF(INDIRECT(O462)>0.5,1,IF(INDIRECT(O462)>=0.25,INDIRECT(O462),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N457)","v":"G80"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N457)","v":"H80"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N457)","v":"I80"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(OR(INDIRECT(O465)=$N$6,INDIRECT(O466)=$N$6),INDIRECT(O467),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C464=\"\",AND(D468=0,E468=0,F468=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C464","v":""},{"$f":"D464","v":0},{"$f":"E464","v":0},{"$f":"F464","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,"Ocultar fila",{"$f":"N457+6","v":86},{"$f":"CONCATENATE(\"D\",N465)","v":"D86"},null,null,null,null,null,{"$f":"C465","v":"Nº de empleados"},{"$f":"ROUND(D465*D468,2)+V457","v":0},{"$f":"ROUND(E465*E468,2)+W457","v":0},{"$f":"ROUND(F465*F468,2)+X457","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"F\",N465)","v":"F86"},null,null,null,null,null,{"$f":"C466","v":"Facturación (€)"},{"$f":"ROUND(D466*D468,2)+V458","v":0},{"$f":"ROUND(E466*E468,2)+W458","v":0},{"$f":"ROUND(F466*F468,2)+X458","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N465-5)","v":"B81"},null,null,null,null,null,{"$f":"C467","v":"Activo total (€)"},{"$f":"ROUND(D467*D468,2)+V459","v":0},{"$f":"ROUND(E467*E468,2)+W459","v":0},{"$f":"ROUND(F467*F468,2)+X459","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C464=\"\",0,IF(INDIRECT(O468)>0.5,1,IF(INDIRECT(O468)>=0.25,INDIRECT(O468),0)))","v":0},{"$f":"IF(C464=\"\",0,IF(INDIRECT(O469)>0.5,1,IF(INDIRECT(O469)>=0.25,INDIRECT(O469),0)))","v":0},{"$f":"IF(C464=\"\",0,IF(INDIRECT(O470)>0.5,1,IF(INDIRECT(O470)>=0.25,INDIRECT(O470),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N465)","v":"G86"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N465)","v":"H86"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N465)","v":"I86"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(OR(INDIRECT(O473)=$N$6,INDIRECT(O474)=$N$6),INDIRECT(O475),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C472=\"\",AND(D476=0,E476=0,F476=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C472","v":""},{"$f":"D472","v":0},{"$f":"E472","v":0},{"$f":"F472","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,"Ocultar fila",{"$f":"N465+6","v":92},{"$f":"CONCATENATE(\"D\",N473)","v":"D92"},null,null,null,null,null,{"$f":"C473","v":"Nº de empleados"},{"$f":"ROUND(D473*D476,2)+V465","v":0},{"$f":"ROUND(E473*E476,2)+W465","v":0},{"$f":"ROUND(F473*F476,2)+X465","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"F\",N473)","v":"F92"},null,null,null,null,null,{"$f":"C474","v":"Facturación (€)"},{"$f":"ROUND(D474*D476,2)+V466","v":0},{"$f":"ROUND(E474*E476,2)+W466","v":0},{"$f":"ROUND(F474*F476,2)+X466","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N473-5)","v":"B87"},null,null,null,null,null,{"$f":"C475","v":"Activo total (€)"},{"$f":"ROUND(D475*D476,2)+V467","v":0},{"$f":"ROUND(E475*E476,2)+W467","v":0},{"$f":"ROUND(F475*F476,2)+X467","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C472=\"\",0,IF(INDIRECT(O476)>0.5,1,IF(INDIRECT(O476)>=0.25,INDIRECT(O476),0)))","v":0},{"$f":"IF(C472=\"\",0,IF(INDIRECT(O477)>0.5,1,IF(INDIRECT(O477)>=0.25,INDIRECT(O477),0)))","v":0},{"$f":"IF(C472=\"\",0,IF(INDIRECT(O478)>0.5,1,IF(INDIRECT(O478)>=0.25,INDIRECT(O478),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N473)","v":"G92"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N473)","v":"H92"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N473)","v":"I92"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(OR(INDIRECT(O481)=$N$6,INDIRECT(O482)=$N$6),INDIRECT(O483),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C480=\"\",AND(D484=0,E484=0,F484=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C480","v":""},{"$f":"D480","v":0},{"$f":"E480","v":0},{"$f":"F480","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,"Ocultar fila",{"$f":"N473+6+1","v":99},{"$f":"CONCATENATE(\"D\",N481)","v":"D99"},"Tiene 1 accionista más",null,null,null,null,{"$f":"C481","v":"Nº de empleados"},{"$f":"ROUND(D481*D484,2)+V473","v":0},{"$f":"ROUND(E481*E484,2)+W473","v":0},{"$f":"ROUND(F481*F484,2)+X473","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"F\",N481)","v":"F99"},null,null,null,null,null,{"$f":"C482","v":"Facturación (€)"},{"$f":"ROUND(D482*D484,2)+V474","v":0},{"$f":"ROUND(E482*E484,2)+W474","v":0},{"$f":"ROUND(F482*F484,2)+X474","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N481-5-1)","v":"B93"},"Tiene 1 accionista más",null,null,null,null,{"$f":"C483","v":"Activo total (€)"},{"$f":"ROUND(D483*D484,2)+V475","v":0},{"$f":"ROUND(E483*E484,2)+W475","v":0},{"$f":"ROUND(F483*F484,2)+X475","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C480=\"\",0,IF(INDIRECT(O484)>0.5,1,IF(INDIRECT(O484)>=0.25,INDIRECT(O484),0)))","v":0},{"$f":"IF(C480=\"\",0,IF(INDIRECT(O485)>0.5,1,IF(INDIRECT(O485)>=0.25,INDIRECT(O485),0)))","v":0},{"$f":"IF(C480=\"\",0,IF(INDIRECT(O486)>0.5,1,IF(INDIRECT(O486)>=0.25,INDIRECT(O486),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N481)","v":"G99"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N481)","v":"H99"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N481)","v":"I99"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,{"$f":"IF(OR(INDIRECT(O489)=$N$6,INDIRECT(O490)=$N$6),INDIRECT(O491),\"\")","v":""},{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0},null,null,null,null,null,null,{"$f":"IF(OR($C488=\"\",AND(D492=0,E492=0,F492=0)), \"Ocultar fila\",\"\")","v":"Ocultar fila"},"FILA REF.","CELDAS REF.",null,null,null,null,null,{"$f":"C488","v":""},{"$f":"D488","v":0},{"$f":"E488","v":0},{"$f":"F488","v":0}]
[null,null,"Nº de empleados",null,null,null,null,null,null,null,null,null,"Ocultar fila",{"$f":"N481+6+2","v":107},{"$f":"CONCATENATE(\"D\",N489)","v":"D107"},"Tiene 2 accionistas más",null,null,null,null,{"$f":"C489","v":"Nº de empleados"},{"$f":"ROUND(D489*D492,2)+V481","v":0},{"$f":"ROUND(E489*E492,2)+W481","v":0},{"$f":"ROUND(F489*F492,2)+X481","v":0}]
[null,null,"Facturación (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"F\",N489)","v":"F107"},null,null,null,null,null,{"$f":"C490","v":"Facturación (€)"},{"$f":"ROUND(D490*D492,2)+V482","v":0},{"$f":"ROUND(E490*E492,2)+W482","v":0},{"$f":"ROUND(F490*F492,2)+X482","v":0}]
[null,null,"Activo total (€)",null,null,null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"B\",N489-5-2)","v":"B100"},"Tiene 2 accionistas más",null,null,null,null,{"$f":"C491","v":"Activo total (€)"},{"$f":"ROUND(D491*D492,2)+V483","v":0},{"$f":"ROUND(E491*E492,2)+W483","v":0},{"$f":"ROUND(F491*F492,2)+X483","v":0}]
[null,null,"% part. Aplicable",{"$f":"IF(C488=\"\",0,IF(INDIRECT(O492)>0.5,1,IF(INDIRECT(O492)>=0.25,INDIRECT(O492),0)))","v":0},{"$f":"IF(C488=\"\",0,IF(INDIRECT(O493)>0.5,1,IF(INDIRECT(O493)>=0.25,INDIRECT(O493),0)))","v":0},{"$f":"IF(C488=\"\",0,IF(INDIRECT(O494)>0.5,1,IF(INDIRECT(O494)>=0.25,INDIRECT(O494),0)))","v":0},null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"G\",N489)","v":"G107"},null,null,null,null,null,"% APLICADO Y SUMADO AL ANTERIOR"]
[null,null,"¿Esta empresa tiene empresas vinculadas?",null,"¿Esta empresa tiene empresas asociadas?",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"H\",N489)","v":"H107"}]
[null,null,"Listado de empresas vinculadas",null,"Listado empresas asociadas",null,null,null,null,null,null,null,"Ocultar fila",null,{"$f":"CONCATENATE(\"I\",N489)","v":"I107"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ocultar fila"]
[null,null,"SUMA",{"$f":"$D$112","v":0},{"$f":"$E$112","v":0},{"$f":"$F$112","v":0}]
[null,null,"Nº de empleados",{"$f":"V489","v":0},0,0,"En caso de fusión o absorción, el tamaño cambia inmediatamente, sin tener en cuenta los dos ejercicios precedentes"]
[null,null,"Facturación (€)",0,0,0]
[null,null,"Activo total (€)",0,0,0]
[null,null,"TAMAÑO",{"$f":"IF(AND(D497<50,OR(D498<=10000000,D499<=10000000)),\"PEQUEÑA\",IF(AND(D497<250,OR(D498<=50000000,D499<=43000000)),\"MEDIANA\",\"GRANDE\"))","v":"PEQUEÑA"},{"$f":"IF(AND(E497<50,OR(E498<=10000000,E499<=10000000)),\"PEQUEÑA\",IF(AND(E497<250,OR(E498<=50000000,E499<=43000000)),\"MEDIANA\",\"GRANDE\"))","v":"PEQUEÑA"},{"$f":"IF(AND(F497<50,OR(F498<=10000000,F499<=10000000)),\"PEQUEÑA\",IF(AND(F497<250,OR(F498<=50000000,F499<=43000000)),\"MEDIANA\",\"GRANDE\"))","v":"PEQUEÑA"}]
[null,null,{"$f":"IF(F500=E500,F500,IF(E500=D500,E500,\"El tamaño es el que se se haya mantenido durante dos años consecutivos\"))","v":"PEQUEÑA"}]

{"sheet":"Exporta participación","index":3,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["Razón Social","CIF","Fecha de creación","Nombre","CIF","Tipo","Participación"]
[{"$f":"+'EMPRESA - DATOS GENERALES'!$G$4","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$C$5","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$K$3","v":"00:00:00"},{"$f":"+'TAMAÑO EMPRESA'!B9","v":0},{"$f":"+'TAMAÑO EMPRESA'!E9","v":0},{"$f":"+'TAMAÑO EMPRESA'!F9","v":0},{"$f":"+'TAMAÑO EMPRESA'!J9","v":0}]
[{"$f":"+'EMPRESA - DATOS GENERALES'!$G$4","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$C$5","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$K$3","v":"00:00:00"},{"$f":"+'TAMAÑO EMPRESA'!B10","v":0},{"$f":"+'TAMAÑO EMPRESA'!E10","v":0},{"$f":"+'TAMAÑO EMPRESA'!F10","v":0},{"$f":"+'TAMAÑO EMPRESA'!J10","v":0}]
[{"$f":"+'EMPRESA - DATOS GENERALES'!$G$4","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$C$5","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$K$3","v":"00:00:00"},{"$f":"+'TAMAÑO EMPRESA'!B11","v":0},{"$f":"+'TAMAÑO EMPRESA'!E11","v":0},{"$f":"+'TAMAÑO EMPRESA'!F11","v":0},{"$f":"+'TAMAÑO EMPRESA'!J11","v":0}]
[{"$f":"+'EMPRESA - DATOS GENERALES'!$G$4","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$C$5","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$K$3","v":"00:00:00"},{"$f":"+'TAMAÑO EMPRESA'!B12","v":0},{"$f":"+'TAMAÑO EMPRESA'!E12","v":0},{"$f":"+'TAMAÑO EMPRESA'!F12","v":0},{"$f":"+'TAMAÑO EMPRESA'!J12","v":0}]
[{"$f":"+'EMPRESA - DATOS GENERALES'!$G$4","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$C$5","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$K$3","v":"00:00:00"},{"$f":"+'TAMAÑO EMPRESA'!B13","v":0},{"$f":"+'TAMAÑO EMPRESA'!E13","v":0},{"$f":"+'TAMAÑO EMPRESA'!F13","v":0},{"$f":"+'TAMAÑO EMPRESA'!J13","v":0}]
[{"$f":"+'EMPRESA - DATOS GENERALES'!$G$4","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$C$5","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$K$3","v":"00:00:00"},{"$f":"+'TAMAÑO EMPRESA'!B14","v":0},{"$f":"+'TAMAÑO EMPRESA'!E14","v":0},{"$f":"+'TAMAÑO EMPRESA'!F14","v":0},{"$f":"+'TAMAÑO EMPRESA'!J14","v":0}]
[{"$f":"+'EMPRESA - DATOS GENERALES'!$G$4","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$C$5","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$K$3","v":"00:00:00"},{"$f":"+'TAMAÑO EMPRESA'!B15","v":0},{"$f":"+'TAMAÑO EMPRESA'!E15","v":0},{"$f":"+'TAMAÑO EMPRESA'!F15","v":0},{"$f":"+'TAMAÑO EMPRESA'!J15","v":0}]
[{"$f":"+'EMPRESA - DATOS GENERALES'!$G$4","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$C$5","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$K$3","v":"00:00:00"},{"$f":"+'TAMAÑO EMPRESA'!B16","v":0},{"$f":"+'TAMAÑO EMPRESA'!E16","v":0},{"$f":"+'TAMAÑO EMPRESA'!F16","v":0},{"$f":"+'TAMAÑO EMPRESA'!J16","v":0}]
[{"$f":"+'EMPRESA - DATOS GENERALES'!$G$4","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$C$5","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$K$3","v":"00:00:00"},{"$f":"+'TAMAÑO EMPRESA'!B17","v":0},{"$f":"+'TAMAÑO EMPRESA'!E17","v":0},{"$f":"+'TAMAÑO EMPRESA'!F17","v":0},{"$f":"+'TAMAÑO EMPRESA'!J17","v":0}]
[{"$f":"+'EMPRESA - DATOS GENERALES'!$G$4","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$C$5","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$K$3","v":"00:00:00"},{"$f":"+'TAMAÑO EMPRESA'!B18","v":0},{"$f":"+'TAMAÑO EMPRESA'!E18","v":0},{"$f":"+'TAMAÑO EMPRESA'!F18","v":0},{"$f":"+'TAMAÑO EMPRESA'!J18","v":0}]
[{"$f":"+'EMPRESA - DATOS GENERALES'!$G$4","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$C$5","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$K$3","v":"00:00:00"},{"$f":"+'TAMAÑO EMPRESA'!B19","v":0},{"$f":"+'TAMAÑO EMPRESA'!E19","v":0},{"$f":"+'TAMAÑO EMPRESA'!F19","v":0},{"$f":"+'TAMAÑO EMPRESA'!J19","v":0}]
[{"$f":"+'EMPRESA - DATOS GENERALES'!$G$4","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$C$5","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$K$3","v":"00:00:00"},{"$f":"+'TAMAÑO EMPRESA'!B20","v":0},{"$f":"+'TAMAÑO EMPRESA'!E20","v":0},{"$f":"+'TAMAÑO EMPRESA'!F20","v":0},{"$f":"+'TAMAÑO EMPRESA'!J20","v":0}]
[{"$f":"+'EMPRESA - DATOS GENERALES'!$G$4","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$C$5","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$K$3","v":"00:00:00"},{"$f":"+'TAMAÑO EMPRESA'!B21","v":0},{"$f":"+'TAMAÑO EMPRESA'!E21","v":0},{"$f":"+'TAMAÑO EMPRESA'!F21","v":0},{"$f":"+'TAMAÑO EMPRESA'!J21","v":0}]
[{"$f":"+'EMPRESA - DATOS GENERALES'!$G$4","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$C$5","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$K$3","v":"00:00:00"},{"$f":"+'TAMAÑO EMPRESA'!B22","v":0},{"$f":"+'TAMAÑO EMPRESA'!E22","v":0},{"$f":"+'TAMAÑO EMPRESA'!F22","v":0},{"$f":"+'TAMAÑO EMPRESA'!J22","v":0}]
[{"$f":"+'EMPRESA - DATOS GENERALES'!$G$4","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$C$5","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$K$3","v":"00:00:00"},{"$f":"+'TAMAÑO EMPRESA'!B23","v":0},{"$f":"+'TAMAÑO EMPRESA'!E23","v":0},{"$f":"+'TAMAÑO EMPRESA'!F23","v":0},{"$f":"+'TAMAÑO EMPRESA'!J23","v":0}]
[{"$f":"+'EMPRESA - DATOS GENERALES'!$G$4","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$C$5","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$K$3","v":"00:00:00"},{"$f":"+'TAMAÑO EMPRESA'!B24","v":0},{"$f":"+'TAMAÑO EMPRESA'!E24","v":0},{"$f":"+'TAMAÑO EMPRESA'!F24","v":0},{"$f":"+'TAMAÑO EMPRESA'!J24","v":0}]
[{"$f":"+'EMPRESA - DATOS GENERALES'!$G$4","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$C$5","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$K$3","v":"00:00:00"},{"$f":"+'TAMAÑO EMPRESA'!B25","v":0},{"$f":"+'TAMAÑO EMPRESA'!E25","v":0},{"$f":"+'TAMAÑO EMPRESA'!F25","v":0},{"$f":"+'TAMAÑO EMPRESA'!J25","v":0}]
[{"$f":"+'EMPRESA - DATOS GENERALES'!$G$4","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$C$5","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$K$3","v":"00:00:00"},{"$f":"+'TAMAÑO EMPRESA'!B26","v":0},{"$f":"+'TAMAÑO EMPRESA'!E26","v":0},{"$f":"+'TAMAÑO EMPRESA'!F26","v":0},{"$f":"+'TAMAÑO EMPRESA'!J26","v":0}]
[{"$f":"+'EMPRESA - DATOS GENERALES'!$G$4","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$C$5","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$K$3","v":"00:00:00"},{"$f":"+'TAMAÑO EMPRESA'!B27","v":0},{"$f":"+'TAMAÑO EMPRESA'!E27","v":0},{"$f":"+'TAMAÑO EMPRESA'!F27","v":0},{"$f":"+'TAMAÑO EMPRESA'!J27","v":0}]
[{"$f":"+'EMPRESA - DATOS GENERALES'!$G$4","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$C$5","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$K$3","v":"00:00:00"},{"$f":"+'TAMAÑO EMPRESA'!B28","v":0},{"$f":"+'TAMAÑO EMPRESA'!E28","v":0},{"$f":"+'TAMAÑO EMPRESA'!F28","v":0},{"$f":"+'TAMAÑO EMPRESA'!J28","v":0}]
[{"$f":"+'EMPRESA - DATOS GENERALES'!$G$4","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$C$5","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$K$3","v":"00:00:00"},{"$f":"+'TAMAÑO EMPRESA'!B29","v":0},{"$f":"+'TAMAÑO EMPRESA'!E29","v":0},{"$f":"+'TAMAÑO EMPRESA'!F29","v":0},{"$f":"+'TAMAÑO EMPRESA'!J29","v":0}]
[{"$f":"+'EMPRESA - DATOS GENERALES'!$G$4","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$C$5","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!$K$3","v":"00:00:00"},{"$f":"+'TAMAÑO EMPRESA'!B30","v":0},{"$f":"+'TAMAÑO EMPRESA'!E30","v":0},{"$f":"+'TAMAÑO EMPRESA'!F30","v":0},{"$f":"+'TAMAÑO EMPRESA'!J30","v":0}]

{"sheet":"EMPRESA - PERSONAS FÍSICAS","index":4,"n_rows":63,"n_cols":12,"rows_kept":63,"cut":false,"hidden":false,"merged":[[65,9,65,10],[65,11,65,12],[66,7,66,8],[66,9,66,10],[66,11,66,12],[67,7,67,8],[67,9,67,10],[67,11,67,12],[60,7,60,8],[60,9,60,10],[60,11,60,12],[62,7,62,8],[62,9,62,10],[62,11,62,12],[63,7,63,8],[63,9,63,10],[63,11,63,12],[64,7,64,8],[64,9,64,10],[64,11,64,12],[65,7,65,8],[61,10,61,12],[61,8,61,9],[56,9,56,10],[56,11,56,12],[57,7,57,8],[57,9,57,10],[57,11,57,12],[58,7,58,8],[58,9,58,10],[58,11,58,12],[59,7,59,8],[59,9,59,10],[59,11,59,12],[52,7,52,8],[52,9,52,10],[52,11,52,12],[53,7,53,8],[53,9,53,10],[53,11,53,12],[55,7,55,8],[55,9,55,10],[55,11,55,12],[34,7,34,8],[34,9,34,10],[34,11,34,12],[35,7,35,8],[35,9,35,10],[35,11,35,12],[36,7,36,8],[36,9,36,10],[36,11,36,12],[30,7,30,8],[30,9,30,10],[30,11,30,12],[31,7,31,8],[31,9,31,10],[31,11,31,12],[32,7,32,8],[32,9,32,10],[32,11,32,12],[27,7,27,8],[27,9,27,10],[27,11,27,12],[28,7,28,8],[28,9,28,10],[28,11,28,12],[29,7,29,8],[29,9,29,10],[29,11,29,12],[9,7,9,8],[10,7,10,8],[11,7,11,8],[6,9,6,10],[7,9,7,10],[8,9,8,10],[9,9,9,10],[10,9,10,10],[11,9,11,10],[63,1,63,2],[63,5,63,6],[64,1,64,2],[66,1,66,2],[66,5,66,6],[67,1,67,2],[67,5,67,6],[64,5,64,6],[65,1,65,2],[65,5,65,6],[5,10,5,12],[6,1,6,2],[56,5,56,6],[54,1,54,2],[54,3,54,7],[54,8,54,9],[54,10,54,12],[55,1,55,2],[55,5,55,6],[40,1,40,2],[40,3,40,7],[40,8,40,9],[40,10,40,12],[41,1,41,2],[41,5,41,6],[42,1,42,2],[6,11,6,12],[7,11,7,12],[8,11,8,12],[9,11,9,12],[10,11,10,12],[42,5,42,6],[41,7,41,8],[8,7,8,8],[1,1,1,12],[3,5,3,9],[3,10,3,12],[5,1,5,2],[5,3,5,7],[5,8,5,9],[11,1,11,2],[7,5,7,6],[10,5,10,6],[11,5,11,6],[8,1,8,2],[8,5,8,6],[9,1,9,2],[9,5,9,6],[7,1,7,2],[10,1,10,2],[2,1,2,12],[4,1,4,12],[3,1,3,2],[6,5,6,6],[3,3,3,4],[11,11,11,12],[6,7,6,8],[7,7,7,8],[62,5,62,6],[56,1,56,2],[57,1,57,2],[57,5,57,6],[58,1,58,2],[58,5,58,6],[60,5,60,6],[61,1,61,2],[61,3,61,7],[62,1,62,2],[59,5,59,6],[60,1,60,2],[56,7,56,8],[59,1,59,2],[41,9,41,10],[41,11,41,12],[42,7,42,8],[42,9,42,10],[42,11,42,12],[43,1,43,2],[43,5,43,6],[44,1,44,2],[44,5,44,6],[45,1,45,2],[45,5,45,6],[43,7,43,8],[43,9,43,10],[43,11,43,12],[44,7,44,8],[44,9,44,10],[44,11,44,12],[45,7,45,8],[45,9,45,10],[45,11,45,12],[46,1,46,2],[46,5,46,6],[47,1,47,2],[47,3,47,7],[47,8,47,9],[47,10,47,12],[48,1,48,2],[48,5,48,6],[46,7,46,8],[46,9,46,10],[46,11,46,12],[48,7,48,8],[48,9,48,10],[48,11,48,12],[49,1,49,2],[49,5,49,6],[50,1,50,2],[50,5,50,6],[51,1,51,2],[51,5,51,6],[49,7,49,8],[49,9,49,10],[49,11,49,12],[50,7,50,8],[50,9,50,10],[50,11,50,12],[51,7,51,8],[51,9,51,10],[51,11,51,12],[52,1,52,2],[52,5,52,6],[53,1,53,2],[53,5,53,6],[26,1,26,2],[26,3,26,7],[26,8,26,9],[26,10,26,12],[27,1,27,2],[27,5,27,6],[28,1,28,2],[28,5,28,6],[29,1,29,2],[29,5,29,6],[30,1,30,2],[30,5,30,6],[31,1,31,2],[31,5,31,6],[33,1,33,2],[33,3,33,7],[33,8,33,9],[33,10,33,12],[32,1,32,2],[32,5,32,6],[34,1,34,2],[34,5,34,6],[39,1,39,2],[39,5,39,6],[36,1,36,2],[36,5,36,6],[37,1,37,2],[37,5,37,6],[38,1,38,2],[38,5,38,6],[35,1,35,2],[35,5,35,6],[37,7,37,8],[37,9,37,10],[37,11,37,12],[38,7,38,8],[38,9,38,10],[38,11,38,12],[39,7,39,8],[39,9,39,10],[39,11,39,12],[12,1,12,2],[12,3,12,7],[12,8,12,9],[12,10,12,12],[13,1,13,2],[13,5,13,6],[14,1,14,2],[14,5,14,6],[15,1,15,2],[15,5,15,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[14,7,14,8],[14,9,14,10],[14,11,14,12],[15,7,15,8],[15,9,15,10],[15,11,15,12],[17,7,17,8],[17,9,17,10],[17,11,17,12],[18,7,18,8],[18,9,18,10],[18,11,18,12],[16,1,16,2],[16,5,16,6],[17,1,17,2],[17,5,17,6],[18,1,18,2],[18,5,18,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[22,1,22,2],[22,5,22,6],[23,1,23,2],[23,5,23,6],[24,1,24,2],[24,5,24,6],[23,7,23,8],[19,8,19,9],[19,10,19,12],[20,1,20,2],[20,5,20,6],[21,1,21,2],[21,5,21,6],[19,1,19,2],[19,3,19,7],[20,7,20,8],[20,9,20,10],[20,11,20,12],[21,7,21,8],[21,9,21,10],[21,11,21,12],[22,7,22,8],[22,9,22,10],[22,11,22,12],[23,9,23,10],[23,11,23,12],[24,7,24,8],[24,9,24,10],[24,11,24,12],[25,7,25,8],[25,9,25,10],[25,1,25,2],[25,5,25,6],[25,11,25,12]]}
[]
[null,"Personas físicas"]
[null,"En el caso de que se trate de una persona autónoma o, si en una empresa societaria o sociedad irregular la participación de personas físicas en el capital de la EIBT\nsupere el 50%, estas no deben haber realizado una actividad del mismo “grupo” (tres\ndígitos) de la CNAE 2009 por cuenta propia (directamente o mediante su\nparticipación en otras sociedades), en los dos años anteriores a la fecha de\nconstitución de la empresa"]
[null,"Fecha de creación",null,{"$f":"+'EMPRESA - DATOS GENERALES'!K3","v":"00:00:00"},null,"Fecha para declaración actividad",null,null,null,null,{"$f":"+D4-2*365","v":-730}]
[null,"Listar para cada persona autónoma o persona física que participe en el capital de la EIBT (siempre que la suma de las participaciones superen el 50%) las actividades realizadas entre la fecha de creación y la fecha de declaración de la actividad (dos años antes). En caso de no haber tenido actividad o haber sido autónomo sin razón social, indicarlo en la casilla Observaciones. "]
[null,"Nombre y apellidos",null,null,null,null,null,null,"NIF"]
[null,"Razón Social",null,"CIF","CNAE","Tipo",null,"Fecha inicio",null,"Fecha fin",null,"Observaciones"]
[]
[]
[]
[]
[]
[null,"Nombre y apellidos",null,null,null,null,null,null,"NIF"]
[null,"Razón Social",null,"CIF","CNAE","Tipo",null,"Fecha inicio",null,"Fecha fin",null,"Observaciones"]
[]
[]
[]
[]
[]
[null,"Nombre y apellidos",null,null,null,null,null,null,"NIF"]
[null,"Razón Social",null,"CIF","CNAE","Tipo",null,"Fecha inicio",null,"Fecha fin",null,"Observaciones"]
[]
[]
[]
[]
[]
[null,"Nombre y apellidos",null,null,null,null,null,null,"NIF"]
[null,"Razón Social",null,"CIF","CNAE","Tipo",null,"Fecha inicio",null,"Fecha fin",null,"Observaciones"]
[]
[]
[]
[]
[]
[null,"Nombre y apellidos",null,null,null,null,null,null,"NIF"]
[null,"Razón Social",null,"CIF","CNAE","Tipo",null,"Fecha inicio",null,"Fecha fin",null,"Observaciones"]
[]
[]
[]
[]
[]
[null,"Nombre y apellidos",null,null,null,null,null,null,"NIF"]
[null,"Razón Social",null,"CIF","CNAE","Tipo",null,"Fecha inicio",null,"Fecha fin",null,"Observaciones"]
[]
[]
[]
[]
[]
[null,"Nombre y apellidos",null,null,null,null,null,null,"NIF"]
[null,"Razón Social",null,"CIF","CNAE","Tipo",null,"Fecha inicio",null,"Fecha fin",null,"Observaciones"]
[]
[]
[]
[]
[]
[null,"Nombre y apellidos",null,null,null,null,null,null,"NIF"]
[null,"Razón Social",null,"CIF","CNAE","Tipo",null,"Fecha inicio",null,"Fecha fin",null,"Observaciones"]
[]
[]
[]
[]
[]
[null,"Nombre y apellidos",null,null,null,null,null,null,"NIF"]
[null,"Razón Social",null,"CIF","CNAE","Tipo",null,"Fecha inicio",null,"Fecha fin",null,"Observaciones"]

{"sheet":"PRESUPUESTO - RESUMEN","index":5,"n_rows":26,"n_cols":20,"rows_kept":26,"cut":false,"hidden":false,"merged":[[13,2,14,12],[2,2,3,5],[2,6,3,12],[8,6,9,12],[4,2,6,10],[4,11,6,12],[8,2,9,5],[10,2,11,5],[10,6,11,12],[25,2,25,9],[20,2,20,9],[21,2,21,9],[22,2,22,9],[23,2,23,9],[17,18,18,18],[17,19,18,19],[21,12,22,12],[16,2,16,9],[24,2,24,9],[19,2,19,9],[17,2,17,9],[18,2,18,9]]}
[]
[]
[null,null,"% de mujeres en plantilla"]
[]
[null,null,"¿La EIBT tuvo la oportunidad de ser beneficiaria en la\nconvocatoria del año 2024 (BON nº 178, de 2 de septiembre de 2024) porque cumplía, en\nel momento de la solicitud, el punto 2.3 de la base 2 de sus bases reguladoras?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fechas Intensidad"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-01",0.75]
[null,null,"Periodo de ejecución de las actuaciones",null,null,null,{"$f":"+IF(L5=\"\",\"\",IF(L5=\"Sí\",\"01/11/24 - 30/09/25 (Periodo limitado)\",\"01/11/23 - 30/09/25 (Periodo completo)\"))","v":""},null,null,null,null,null,null,null,null,null,"2020-01-01",0.55000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-12-01",0.35]
[null,null,"Intensidad de ayuda (dato orientativo a falta de validar, en el momento de evaluación de las solicitudes)",null,null,null,{"$f":"+IF(G3=\"\",\"\",IF('EMPRESA - DATOS GENERALES'!K3>='PRESUPUESTO - RESUMEN'!Q8,'PRESUPUESTO - RESUMEN'!R8,IF('EMPRESA - DATOS GENERALES'!K3>='PRESUPUESTO - RESUMEN'!Q9,'PRESUPUESTO - RESUMEN'!R9,'PRESUPUESTO - RESUMEN'!R10))+IF(G3>40%,5%,0))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Periodo limitado","Periodo total"]
[null,null,"Tenga en cuenta los límites de ayuda (que surge del presupuesto aceptado multiplicado por la intensidad de ayuda concedida) de la base 6.2. Además, el presupuesto debe ser realista debido a la existencia de las penalizaciones por inejecuciones de la base 14.2.",null,null,null,null,null,null,null,null,null,null,null,null,null,"a) Gastos de personal ",null,35000,60000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b) Gastos de formación",null,3000,6000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c) Gastos de asistencia a ferias como expositor",null,3000,6000]
[null,null,"CONCEPTO DE GASTO",null,null,null,null,null,null,null,"PRESUPUESTO","AYUDA","LIMITES AYUDA ORIENTATIVOS",null,null,null,"d) Gastos de realización de maquetas y prototipos",null,15000,25000]
[null,null,"a) Gastos de personal ",null,null,null,null,null,null,null,{"$f":"+'PRESUPUESTO - DESGLOSE'!H7","v":0},{"$f":"+'PRESUPUESTO - DESGLOSE'!H8","v":0},{"$f":"'PRESUPUESTO - DESGLOSE'!N12","v":60000},null,null,null,"e) Cuotas por servicios prestados entidades de alojamiento de start-ups y/o asociaciones o clústers",null,15000,27000]
[null,null,"b) Gastos de formación",null,null,null,null,null,null,null,{"$f":"+'PRESUPUESTO - DESGLOSE'!H31","v":0},{"$f":"+'PRESUPUESTO - DESGLOSE'!H32","v":0},{"$f":"'PRESUPUESTO - DESGLOSE'!N13","v":6000},null,null,null,"f) Gastos de alquiler de locales"]
[null,null,"c) Gastos de asistencia a ferias como expositor",null,null,null,null,null,null,null,{"$f":"+'PRESUPUESTO - DESGLOSE'!H46","v":0},{"$f":"+'PRESUPUESTO - DESGLOSE'!H47","v":0},{"$f":"'PRESUPUESTO - DESGLOSE'!N14","v":6000},null,null,null,"g) Consultoría y asistencia técnica externa",null,10000,13000]
[null,null,"d) Gastos de realización de maquetas y prototipos",null,null,null,null,null,null,null,{"$f":"+'PRESUPUESTO - DESGLOSE'!H57","v":0},{"$f":"+'PRESUPUESTO - DESGLOSE'!H58","v":0},{"$f":"'PRESUPUESTO - DESGLOSE'!N15","v":25000},null,null,null,"h) Gastos de patentes y marcas",null,3000,6000]
[null,null,"e) Cuotas por servicios prestados entidades de alojamiento de start-ups y/o asociaciones o clústers",null,null,null,null,null,null,null,{"$f":"+'PRESUPUESTO - DESGLOSE'!H68","v":0},{"$f":"+'PRESUPUESTO - DESGLOSE'!H69","v":0},{"$f":"'PRESUPUESTO - DESGLOSE'!N16","v":27000},null,null,null,"Total",null,50000,100000]
[null,null,"f) Gastos de alquiler de locales",null,null,null,null,null,null,null,{"$f":"+'PRESUPUESTO - DESGLOSE'!H79","v":0},{"$f":"+'PRESUPUESTO - DESGLOSE'!H80","v":0}]
[null,null,"g) Consultoría y asistencia técnica externa",null,null,null,null,null,null,null,{"$f":"+'PRESUPUESTO - DESGLOSE'!H90","v":0},{"$f":"+'PRESUPUESTO - DESGLOSE'!H91","v":0},{"$f":"'PRESUPUESTO - DESGLOSE'!N18","v":13000}]
[null,null,"h) Gastos de patentes y marcas",null,null,null,null,null,null,null,{"$f":"+'PRESUPUESTO - DESGLOSE'!H101","v":0},{"$f":"+'PRESUPUESTO - DESGLOSE'!H102","v":0},{"$f":"'PRESUPUESTO - DESGLOSE'!N19","v":6000}]
[null,null,"TOTAL",null,null,null,null,null,null,null,{"$f":"SUM(K18:K25)","v":0},{"$f":"IF(SUM(L18:L25)<'PRESUPUESTO - DESGLOSE'!N20,SUM(L18:L25),'PRESUPUESTO - DESGLOSE'!N20)","v":0},{"$f":"'PRESUPUESTO - DESGLOSE'!N20","v":100000}]

{"sheet":"Exporta","index":6,"n_rows":2,"n_cols":32,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Razón Social","CIF","Fecha de creación","Código Postal","CNAE","Sector","Contacto","Teléfono","Mail","Tamaño de empresa","% mujeres","Intensidad","Cumplía 2024","Periodo","CostePersonal","AyudaPersonal","CosteFormación","AyudaFormacion","CosteFerias","AyudaFerias","CostePrototipos","AyudaPrototipos","CosteServicios","AyudaServicios","CosteAlquiler","AyudaAlquiler","CosteConsultoría","AyudaConsultoría","CostePatentes","AyudaPatentes","CosteTotal","AyudaTotal"]
[{"$f":"+'EMPRESA - DATOS GENERALES'!G4","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!C5","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!K3","v":"00:00:00"},{"$f":"+'EMPRESA - DATOS GENERALES'!E7","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!F11","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!L11","v":0},{"$f":"+CONCATENATE('EMPRESA - DATOS GENERALES'!G12,\" \",'EMPRESA - DATOS GENERALES'!K12,\" \",'EMPRESA - DATOS GENERALES'!E13)","v":"  "},{"$f":"+'EMPRESA - DATOS GENERALES'!D14","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!K14","v":0},{"$f":"+'EMPRESA - DATOS GENERALES'!L21","v":0},{"$f":"+'PRESUPUESTO - RESUMEN'!G3","v":0},{"$f":"+'PRESUPUESTO - RESUMEN'!G11","v":""},{"$f":"+'PRESUPUESTO - RESUMEN'!L5","v":0},{"$f":"+'PRESUPUESTO - RESUMEN'!G9","v":""},{"$f":"+'PRESUPUESTO - RESUMEN'!K18","v":0},{"$f":"+'PRESUPUESTO - RESUMEN'!L18","v":0},{"$f":"+'PRESUPUESTO - RESUMEN'!K19","v":0},{"$f":"+'PRESUPUESTO - RESUMEN'!L19","v":0},{"$f":"+'PRESUPUESTO - RESUMEN'!K20","v":0},{"$f":"+'PRESUPUESTO - RESUMEN'!L20","v":0},{"$f":"+'PRESUPUESTO - RESUMEN'!K21","v":0},{"$f":"+'PRESUPUESTO - RESUMEN'!L21","v":0},{"$f":"+'PRESUPUESTO - RESUMEN'!K22","v":0},{"$f":"+'PRESUPUESTO - RESUMEN'!L22","v":0},{"$f":"+'PRESUPUESTO - RESUMEN'!K23","v":0},{"$f":"+'PRESUPUESTO - RESUMEN'!L23","v":0},{"$f":"+'PRESUPUESTO - RESUMEN'!K24","v":0},{"$f":"+'PRESUPUESTO - RESUMEN'!L24","v":0},{"$f":"+'PRESUPUESTO - RESUMEN'!K25","v":0},{"$f":"+'PRESUPUESTO - RESUMEN'!L25","v":0},{"$f":"+'PRESUPUESTO - RESUMEN'!K26","v":0},{"$f":"+'PRESUPUESTO - RESUMEN'!L26","v":0}]

{"sheet":"PRESUPUESTO - DESGLOSE","index":7,"n_rows":109,"n_cols":14,"rows_kept":109,"cut":false,"hidden":false,"merged":[[105,1,105,5],[106,1,106,5],[107,1,107,5],[108,1,108,5],[96,1,96,5],[97,1,97,5],[98,1,99,1],[98,2,99,7],[82,1,82,5],[83,1,83,5],[84,1,84,5],[85,1,85,5],[86,1,86,5],[87,1,88,1],[87,2,88,7],[102,1,102,5],[104,1,104,5],[91,1,91,5],[92,1,92,5],[93,1,93,5],[94,1,94,5],[95,1,95,5],[103,1,103,5],[100,1,101,4],[89,1,90,4],[89,5,89,6],[90,5,90,6],[100,5,100,6],[101,5,101,6],[72,1,72,5],[73,1,73,5],[74,1,74,5],[75,1,75,5],[76,1,77,1],[76,2,77,7],[80,1,80,5],[81,1,81,5],[78,1,79,4],[78,5,78,6],[79,5,79,6],[62,1,62,5],[63,1,63,5],[64,1,64,5],[65,1,66,1],[65,2,66,7],[69,1,69,5],[70,1,70,5],[71,1,71,5],[67,1,68,4],[67,5,67,6],[68,5,68,6],[59,1,59,5],[60,1,60,5],[61,1,61,5],[50,1,50,5],[51,1,51,5],[52,1,52,5],[53,1,53,5],[54,1,55,1],[54,2,55,7],[56,1,57,4],[56,5,56,6],[57,5,57,6],[43,1,44,1],[43,2,44,7],[47,1,47,5],[48,1,48,5],[49,1,49,5],[40,1,40,5],[41,1,41,5],[42,1,42,5],[58,1,58,5],[26,1,26,3],[28,1,29,1],[28,2,29,7],[32,1,32,5],[33,1,33,5],[16,1,16,3],[17,1,17,3],[22,1,22,3],[23,1,23,3],[1,1,1,7],[2,1,2,7],[3,1,3,7],[6,5,6,6],[7,5,7,6],[14,1,14,3],[15,1,15,3],[8,1,8,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[9,1,9,3],[9,11,9,13],[30,1,31,4],[31,5,31,6],[45,1,46,4],[45,5,45,6],[46,5,46,6],[15,13,16,13],[6,1,7,4],[4,1,5,1],[4,2,5,7],[39,1,39,5],[37,1,37,5],[38,1,38,5],[34,1,34,5],[35,1,35,5],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[27,1,27,3],[24,1,24,3],[30,5,30,6],[36,1,36,5],[25,1,25,3]]}
[]
[null,"DESGLOSE DE PRESUPUESTO "]
[null,"Importante: Los valores calculados de ayuda y los límites aplicados son orientativos. Aunque se superen, se recomienda incluir todos los gastos que haya habido o se pretendan llevar a cabo puesto que algunos podrían no ser aceptados después en el momento de la justificación. Siempre teniendo en cuenta que el presupuesto debe ser realista debido a la existencia de las penalizaciones por inejecuciones de la base 14.2. "]
[null,"Tener en cuenta la nota informativa sobre doble financiación"]
[null,"a) Gastos de personal ","Gastos de las personas contratadas por cuenta ajena en la EIBT\no el de aquellas personas autónomas socias de la misma siempre que se justifiquen\nmediante nómina. Incluir también, si lo hay, el coste de la Seguridad Social de la empresa. No se subvencionarán los gastos de kilometraje (salvo el caso\nespecificado en la letra c), dietas, indemnizaciones u horas extra"]
[]
[null,"Indicar el coste total presupuestado para cada persona y las nuevas contrataciones si las hay previstas. Hay que tener en cuenta que la ayuda máxima es de 1500 euros por persona y mes. Por lo tanto, el coste imputado máximo por persona y mes será 1500 euros dividido por la intensidad de ayuda concedida.",null,null,null,"Coste Total",null,{"$f":"+SUM(G10:G28)","v":0}]
[null,null,null,null,null,"Ayuda total",null,{"$f":"+IF(SUM(H10:H28)<N12,SUM(H10:H28),N12)","v":0}]
[null,"Nombre y apellidos",null,null,"Tipo","Número de meses imputados","Coste total imputado","Ayuda total orientativa calculada "]
[null,null,null,null,null,null,null,{"$f":"+IF(G10=\"\",\"\",IF(G10*'PRESUPUESTO - RESUMEN'!$G$11<'PRESUPUESTO - DESGLOSE'!F10*1500,G10*'PRESUPUESTO - RESUMEN'!$G$11,'PRESUPUESTO - DESGLOSE'!F10*1500))","v":""},null,null,null,"Limites aplicables"]
[null,null,null,null,null,null,null,{"$f":"+IF(G11=\"\",\"\",IF(G11*'PRESUPUESTO - RESUMEN'!$G$11<'PRESUPUESTO - DESGLOSE'!F11*1500,G11*'PRESUPUESTO - RESUMEN'!$G$11,'PRESUPUESTO - DESGLOSE'!F11*1500))","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G12=\"\",\"\",IF(G12*'PRESUPUESTO - RESUMEN'!$G$11<'PRESUPUESTO - DESGLOSE'!F12*1500,G12*'PRESUPUESTO - RESUMEN'!$G$11,'PRESUPUESTO - DESGLOSE'!F12*1500))","v":""},null,null,null,"a) Gastos de personal ",null,{"$f":"+IF('PRESUPUESTO - RESUMEN'!$L$5=\"Sí\",'PRESUPUESTO - RESUMEN'!S14,'PRESUPUESTO - RESUMEN'!T14)","v":60000}]
[null,null,null,null,null,null,null,{"$f":"+IF(G13=\"\",\"\",IF(G13*'PRESUPUESTO - RESUMEN'!$G$11<'PRESUPUESTO - DESGLOSE'!F13*1500,G13*'PRESUPUESTO - RESUMEN'!$G$11,'PRESUPUESTO - DESGLOSE'!F13*1500))","v":""},null,null,null,"b) Gastos de formación",null,{"$f":"+IF('PRESUPUESTO - RESUMEN'!$L$5=\"Sí\",'PRESUPUESTO - RESUMEN'!S15,'PRESUPUESTO - RESUMEN'!T15)","v":6000}]
[null,null,null,null,null,null,null,{"$f":"+IF(G14=\"\",\"\",IF(G14*'PRESUPUESTO - RESUMEN'!$G$11<'PRESUPUESTO - DESGLOSE'!F14*1500,G14*'PRESUPUESTO - RESUMEN'!$G$11,'PRESUPUESTO - DESGLOSE'!F14*1500))","v":""},null,null,null,"c) Gastos de asistencia a ferias como expositor",null,{"$f":"+IF('PRESUPUESTO - RESUMEN'!$L$5=\"Sí\",'PRESUPUESTO - RESUMEN'!S16,'PRESUPUESTO - RESUMEN'!T16)","v":6000}]
[null,null,null,null,null,null,null,{"$f":"+IF(G15=\"\",\"\",IF(G15*'PRESUPUESTO - RESUMEN'!$G$11<'PRESUPUESTO - DESGLOSE'!F15*1500,G15*'PRESUPUESTO - RESUMEN'!$G$11,'PRESUPUESTO - DESGLOSE'!F15*1500))","v":""},null,null,null,"d) Gastos de realización de maquetas y prototipos",null,{"$f":"+IF('PRESUPUESTO - RESUMEN'!$L$5=\"Sí\",'PRESUPUESTO - RESUMEN'!S17,'PRESUPUESTO - RESUMEN'!T17)","v":25000}]
[null,null,null,null,null,null,null,{"$f":"+IF(G16=\"\",\"\",IF(G16*'PRESUPUESTO - RESUMEN'!$G$11<'PRESUPUESTO - DESGLOSE'!F16*1500,G16*'PRESUPUESTO - RESUMEN'!$G$11,'PRESUPUESTO - DESGLOSE'!F16*1500))","v":""},null,null,null,"e) Cuotas por servicios prestados entidades de alojamiento de start-ups y/o asociaciones o clústers",null,{"$f":"+IF('PRESUPUESTO - RESUMEN'!$L$5=\"Sí\",'PRESUPUESTO - RESUMEN'!S18,'PRESUPUESTO - RESUMEN'!T18)","v":27000}]
[null,null,null,null,null,null,null,{"$f":"+IF(G17=\"\",\"\",IF(G17*'PRESUPUESTO - RESUMEN'!$G$11<'PRESUPUESTO - DESGLOSE'!F17*1500,G17*'PRESUPUESTO - RESUMEN'!$G$11,'PRESUPUESTO - DESGLOSE'!F17*1500))","v":""},null,null,null,"f) Gastos de alquiler de locales"]
[null,null,null,null,null,null,null,{"$f":"+IF(G18=\"\",\"\",IF(G18*'PRESUPUESTO - RESUMEN'!$G$11<'PRESUPUESTO - DESGLOSE'!F18*1500,G18*'PRESUPUESTO - RESUMEN'!$G$11,'PRESUPUESTO - DESGLOSE'!F18*1500))","v":""},null,null,null,"g) Consultoría y asistencia técnica externa",null,{"$f":"+IF('PRESUPUESTO - RESUMEN'!$L$5=\"Sí\",'PRESUPUESTO - RESUMEN'!S20,'PRESUPUESTO - RESUMEN'!T20)","v":13000}]
[null,null,null,null,null,null,null,{"$f":"+IF(G19=\"\",\"\",IF(G19*'PRESUPUESTO - RESUMEN'!$G$11<'PRESUPUESTO - DESGLOSE'!F19*1500,G19*'PRESUPUESTO - RESUMEN'!$G$11,'PRESUPUESTO - DESGLOSE'!F19*1500))","v":""},null,null,null,"h) Gastos de patentes y marcas",null,{"$f":"+IF('PRESUPUESTO - RESUMEN'!$L$5=\"Sí\",'PRESUPUESTO - RESUMEN'!S21,'PRESUPUESTO - RESUMEN'!T21)","v":6000}]
[null,null,null,null,null,null,null,{"$f":"+IF(G20=\"\",\"\",IF(G20*'PRESUPUESTO - RESUMEN'!$G$11<'PRESUPUESTO - DESGLOSE'!F20*1500,G20*'PRESUPUESTO - RESUMEN'!$G$11,'PRESUPUESTO - DESGLOSE'!F20*1500))","v":""},null,null,null,"Total",null,{"$f":"+IF('PRESUPUESTO - RESUMEN'!$L$5=\"Sí\",'PRESUPUESTO - RESUMEN'!S22,'PRESUPUESTO - RESUMEN'!T22)","v":100000}]
[null,null,null,null,null,null,null,{"$f":"+IF(G21=\"\",\"\",IF(G21*'PRESUPUESTO - RESUMEN'!$G$11<'PRESUPUESTO - DESGLOSE'!F21*1500,G21*'PRESUPUESTO - RESUMEN'!$G$11,'PRESUPUESTO - DESGLOSE'!F21*1500))","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G22=\"\",\"\",IF(G22*'PRESUPUESTO - RESUMEN'!$G$11<'PRESUPUESTO - DESGLOSE'!F22*1500,G22*'PRESUPUESTO - RESUMEN'!$G$11,'PRESUPUESTO - DESGLOSE'!F22*1500))","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G23=\"\",\"\",IF(G23*'PRESUPUESTO - RESUMEN'!$G$11<'PRESUPUESTO - DESGLOSE'!F23*1500,G23*'PRESUPUESTO - RESUMEN'!$G$11,'PRESUPUESTO - DESGLOSE'!F23*1500))","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G24=\"\",\"\",IF(G24*'PRESUPUESTO - RESUMEN'!$G$11<'PRESUPUESTO - DESGLOSE'!F24*1500,G24*'PRESUPUESTO - RESUMEN'!$G$11,'PRESUPUESTO - DESGLOSE'!F24*1500))","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G25=\"\",\"\",IF(G25*'PRESUPUESTO - RESUMEN'!$G$11<'PRESUPUESTO - DESGLOSE'!F25*1500,G25*'PRESUPUESTO - RESUMEN'!$G$11,'PRESUPUESTO - DESGLOSE'!F25*1500))","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G26=\"\",\"\",IF(G26*'PRESUPUESTO - RESUMEN'!$G$11<'PRESUPUESTO - DESGLOSE'!F26*1500,G26*'PRESUPUESTO - RESUMEN'!$G$11,'PRESUPUESTO - DESGLOSE'!F26*1500))","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G27=\"\",\"\",IF(G27*'PRESUPUESTO - RESUMEN'!$G$11<'PRESUPUESTO - DESGLOSE'!F27*1500,G27*'PRESUPUESTO - RESUMEN'!$G$11,'PRESUPUESTO - DESGLOSE'!F27*1500))","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G28=\"\",\"\",IF(G28*'PRESUPUESTO - RESUMEN'!$G$11<'PRESUPUESTO - DESGLOSE'!F28*1500,G28*'PRESUPUESTO - RESUMEN'!$G$11,'PRESUPUESTO - DESGLOSE'!F28*1500))","v":""}]
[null,"b) Gastos de formación","Formación vinculada exclusivamente al desarrollo de la actividad principal de la\nempresa"]
[]
[null,"Listar las formaciones realizadas o previstas y su coste total durante el periodo (no es necesario especificar personas, fechas, lugares, etc)",null,null,null,"Total",null,{"$f":"+SUM(G34:G43)","v":0}]
[null,null,null,null,null,"Ayuda total",null,{"$f":"+IF(SUM(H34:H43)<N13,SUM(H34:H43),N13)","v":0}]
[null,"Formación",null,null,null,null,"Coste total imputado","Ayuda total orientativa calculada "]
[null,null,null,null,null,null,null,{"$f":"+IF(G34=\"\",\"\",G34*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G35=\"\",\"\",G35*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G36=\"\",\"\",G36*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G37=\"\",\"\",G37*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G38=\"\",\"\",G38*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G39=\"\",\"\",G39*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G40=\"\",\"\",G40*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G41=\"\",\"\",G41*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G42=\"\",\"\",G42*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G43=\"\",\"\",G43*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,"c) Gastos de ferias","Asistencia a ferias como expositor y los viajes asociados, incluido el kilometraje para el\ncaso de viajes por carretera siempre que pueda justificarse mediante ingreso en\nnómina"]
[]
[null,"Listar las ferias a las que se ha acudido o se va a acudir como expositor y su coste total asociado durante el periodo (no es necesario desglosar cada feria)",null,null,null,"Total",null,{"$f":"+SUM(G49:G54)","v":0}]
[null,null,null,null,null,"Ayuda total",null,{"$f":"+IF(SUM(H49:H54)<N14,SUM(H49:H54),N14)","v":0}]
[null,"Feria",null,null,null,null,"Coste total imputado","Ayuda total orientativa calculada "]
[null,null,null,null,null,null,null,{"$f":"+IF(G49=\"\",\"\",G49*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G50=\"\",\"\",G50*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G51=\"\",\"\",G51*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G52=\"\",\"\",G52*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G53=\"\",\"\",G53*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G54=\"\",\"\",G54*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,"d) Maquetas o prototipos","Excluidos gastos de personal"]
[]
[null,"Listar agrupados por tipología o prototipo los costes realizados en maquetas o protopipos (por ejemplo: prototipo 200W, material eléctrico, material mecánico, etc)",null,null,null,"Total",null,{"$f":"+SUM(G60:G65)","v":0}]
[null,null,null,null,null,"Ayuda total",null,{"$f":"+IF(SUM(H60:H65)<N15,SUM(H60:H65),N15)","v":0}]
[null,"Concepto, tipo o prototipo",null,null,null,null,"Coste total imputado","Ayuda total orientativa calculada "]
[null,null,null,null,null,null,null,{"$f":"+IF(G60=\"\",\"\",G60*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G61=\"\",\"\",G61*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G62=\"\",\"\",G62*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G63=\"\",\"\",G63*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G64=\"\",\"\",G64*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G65=\"\",\"\",G65*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,"e) Cuotas servicios","Cuotas abonadas por servicios prestados por viveros, incubadoras, parques científicos\nu otras entidades de alojamiento de start-ups y/o cuotas de asociaciones empresariales\no clústers"]
[]
[null,"Listar las entidades, asociaciones, clusters etc y su coste total durante el periodo",null,null,null,"Total",null,{"$f":"+SUM(G71:G76)","v":0}]
[null,null,null,null,null,"Ayuda total",null,{"$f":"+IF(AND(SUM(H71:H76)>=N16,SUM(H82:H87)>=N16),N16/2,IF((SUM(H71:H76)+SUM(H82:H87))<N16,SUM(H71:H76),IF(SUM(H71:H76)>SUM(H82:H87),N16-SUM(H82:H87),SUM(H71:H76))))","v":0}]
[null,"Entidad, asociación, cluster",null,null,null,null,"Coste total imputado","Ayuda total orientativa calculada "]
[null,null,null,null,null,null,null,{"$f":"+IF(G71=\"\",\"\",G71*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G72=\"\",\"\",G72*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G73=\"\",\"\",G73*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G74=\"\",\"\",G74*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G75=\"\",\"\",G75*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G76=\"\",\"\",G76*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,"f) Cuotas alquiler","Cuota de alquiler de locales ubicados en Navarra."]
[]
[null,"Listar los locales alquilados y su coste total durante el periodo",null,null,null,"Total",null,{"$f":"+SUM(G82:G87)","v":0}]
[null,null,null,null,null,"Ayuda total",null,{"$f":"+IF(AND(SUM(H71:H76)>=N16,SUM(H82:H87)>=N16),N16/2,IF((SUM(H71:H76)+SUM(H82:H87))<N16,SUM(H82:H87),IF(SUM(H71:H76)>SUM(H82:H87),SUM(H82:H87),N16-SUM(H71:H76))))","v":0}]
[null,"Local",null,null,null,null,"Coste total imputado","Ayuda total orientativa calculada "]
[null,null,null,null,null,null,null,{"$f":"+IF(G82=\"\",\"\",G82*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G83=\"\",\"\",G83*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G84=\"\",\"\",G84*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G85=\"\",\"\",G85*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G86=\"\",\"\",G86*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G87=\"\",\"\",G87*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,"g) Consultoría"," Consultoría y asistencia técnica externa relacionados con el desarrollo de la actividad\nprincipal de la empresa"]
[]
[null,"Listar los servicios contratados o previstos y su relación con el desarrollo de la actividad así como su coste total",null,null,null,"Total",null,{"$f":"+SUM(G93:G98)","v":0}]
[null,null,null,null,null,"Ayuda total",null,{"$f":"+IF(SUM(H93:H98)<N18,SUM(H93:H98),N18)","v":0}]
[null,"Servicio",null,null,null,null,"Coste total imputado","Ayuda total orientativa calculada "]
[null,null,null,null,null,null,null,{"$f":"+IF(G93=\"\",\"\",G93*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G94=\"\",\"\",G94*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G95=\"\",\"\",G95*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G96=\"\",\"\",G96*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G97=\"\",\"\",G97*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G98=\"\",\"\",G98*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,"h) Patentes y marcas","Gastos de solicitud, concesión y registro de patentes, modelos de utilidad y marcas comerciales."]
[]
[null,"Listar las patentes, modelos de utilidad o marcas solicitadas o previstas a solicitar durante el periodo y su coste total",null,null,null,"Total",null,{"$f":"+SUM(G104:G109)","v":0}]
[null,null,null,null,null,"Ayuda total",null,{"$f":"+IF(SUM(H104:H109)<N19,SUM(H104:H109),N19)","v":0}]
[null,"Patente, modelo de utilidad o marca",null,null,null,null,"Coste total imputado","Ayuda total orientativa calculada "]
[null,null,null,null,null,null,null,{"$f":"+IF(G104=\"\",\"\",G104*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G105=\"\",\"\",G105*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G106=\"\",\"\",G106*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G107=\"\",\"\",G107*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G108=\"\",\"\",G108*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(G109=\"\",\"\",G109*'PRESUPUESTO - RESUMEN'!$G$11)","v":""}]