{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["DATOS Y PREMISAS","Indice","Leeme_contenidos","Proyecto","Inversion Inicial","Financiacion","Inversion vs Financiacion","Ingresos","Gastos Fijos","Gastos Variables","Cuenta Resultados","6.UMBRAL RENTABILIDAD","Liquidacion Impuestos","Hoja2","Balance de Situacion","Info_Tablas Amortizacion"],"not_rendered":{"charts":8,"images":4,"macros":1,"external_links":0,"defined_names":4,"comments":4,"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":"DATOS Y PREMISAS","index":0,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":true,"merged":[[1,1,1,9],[3,2,3,5],[22,4,22,6],[20,4,20,6],[21,4,21,6],[19,4,19,6],[6,3,6,12],[5,1,5,2],[23,4,23,6],[24,4,24,6],[25,4,25,6],[5,3,5,9],[7,2,7,9],[17,1,17,2],[17,4,17,7],[11,1,13,9],[8,2,8,9],[15,1,15,9]]}
[]
[null,"DATOS DEL PROYECTO "]
[]
[null,"Denominación abreviada",null,null,null,null,"Ejercicio >",0,"Primer mes >","Enero"]
[]
[null,"Datos de la empresa"]
[]
[null,"Teléfono"]
[null,"Correo electrónico"]
[]
[null,"NOTAS"]
[]
[]
[]
[]
[null,"PREMISAS"]
[]
[null,"IMPUESTOS",null,null,"AMORTIZACIÓN AÑOS"]
[]
[null,"% Impuestos s/beneficios >",null,null,"Terrenos, construcciones y edificaciones",null,null,20]
[null,"Prever la devolución del I.V.A. >",null,null,"Otras instalaciones",null,null,10]
[null,"% I.V.A. a REPERCUTIR (ventas) >",null,null,"Maquinaria, utillaje y herramientas",null,null,5]
[null,"% I.V.A. a SOPORTAR (compras) >",null,null,"Vehículos y elementos de transporte",null,null,5]
[null,"% impagados >",null,null,"Mobiliario y equipos oficina",null,null,10]
[null,null,null,null,"Equipos informáticos",null,null,5]
[null,null,null,null,"Activos intangibles amortizables",null,null,10]

{"sheet":"Indice","index":1,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[9,2,9,4],[0,0,1,2],[35,5,38,5],[6,2,6,4],[7,2,7,4],[8,2,8,4],[18,2,18,4],[17,2,17,4],[16,2,16,4],[15,2,15,4],[14,2,14,4],[13,2,13,4],[12,2,12,4],[11,2,11,4],[10,2,10,4]]}
["\nAlgunos derechos reservados: Herramienta de viabildad por Economistas sin Fronteras se distribuye bajo una Licencia Creative Commons Atribución-NoComercial 4.0 Internacional Para mas información: https://creativecommons.org/licenses/by-nc/4.0/deed"]
[]
[]
["Resumen"]
[]
["INDICE"]
[null,"Título de pestaña","Corresponde a…."]
[null,"Indice","Esta pestaña a modo de guía"]
[null,"Leeme contenidos ","Para conocer parte de teoría "]
[null,"Proyecto","Descripción del proyecto"]
[null,"Inversión Inicial","Antes Inicio Proyecto"]
[null,"Financiación","Antes Inicio Proyecto"]
[null,"Inversion-financiacion","Situación Económica al Inicio"]
[null,"Ingresos","Situación Económica durante el proyecto"]
[null,"Gastos Fijos","Situación Económica durante el proyecto"]
[null,"Gastos Variables","Situación Económica durante el proyecto"]
[null,"Cuenta de resultados","Situación Económica durante el proyecto"]
[null,"Liquidación IMPUESTOS","Situación Económica durante el proyecto"]
[null,"Balance de Situación","Situación Económica durante el proyecto"]
[]
[]
["¿Cómo completar esta base de datos? "]
[null,"PASO 1: Revisar la pestaña Leeme contenido. IMPORTANTE RELLENAR PESTAÑA \"PROYECTO\" CON LA FECHA DE INICIO "]
[null,"PASO 2:  Seguir este código de colores "]
[]
[null,null,"datos a rellenar"]
[null,null,"formulas -> no tocar"]
[null,null,"formulas -> no tocar"]
[]
["MAPA CONCEPTUAL"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"∞"]

{"sheet":"Leeme_contenidos","index":2,"n_rows":148,"n_cols":5,"rows_kept":148,"cut":false,"hidden":false,"merged":[[36,0,36,9],[76,0,76,7],[89,0,89,7],[74,0,75,9],[86,0,87,9],[58,0,58,9],[60,0,61,9],[34,0,35,9],[100,0,106,7],[3,0,7,9],[28,0,28,3],[29,0,29,3],[24,0,24,9],[19,0,23,9],[26,4,26,9],[27,4,27,9],[28,4,28,9],[29,4,29,9],[26,0,26,3],[27,0,27,3],[99,0,99,7],[63,0,69,9],[62,0,62,9]]}
["Plan de Negocio y Plan Econonómico Financiero "]
[]
[]
["El Plan de Negocio es una HERRAMIENTA que nos permite:\n- Establecer los objetivos de la empresa y las líneas de actuación básicas.\n- Sacar a la luz aspectos no tenidos en cuenta anteriormente.\n- “Hacer números”, elaborar presupuestos.\n- Situarnos en distintos escenarios posibles y prever acciones.\n- Analizar posteriormente desviaciones.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["El Plan Económico Financiero (PEF) es la versión cuantificada del Plan de Empresa.\n- Qué fondos se necesitan para poner en marcha una empresa. \n- Cómo se van a cubrir los gastos de operación con los ingresos generados. \n- Cómo se puede retribuir y devolver los fondos ajenos que se soliciten. \n- Si el negocio será VIABLE o SOSTENIBLE EN EL TIEMPO."]
[]
[]
[]
[]
["El PEF consta de 4 herramientas fundamentales"]
[]
["Plan Inversión – Financiación Inicial ",null,null,null,"¿Qué y cuánto necesitamos para comenzar? ¿Dónde obtendremos los recursos?"]
["Cuenta de resultados Previsional",null,null,null,"Conocer si vamos a obtener beneficios o pérdidas.   BENEFICIO O SOSTENIBILIDAD \n¿Cuál va a ser el resultado mensual de la iniciativa de emprendimiento?"]
["Plan de tesorería",null,null,null,"Prever si algún mes nos va hacer falta dinero, y en tal caso, planificar cómo lo vamos a conseguir.  LIQUIDEZ"]
["Balance previsional ",null,null,null,"Saber y conocer que PATRIMONIO tiene el emprendimiento,  lo que le pueden deber a la iniciativa y lo que la iniciativa emprendedora debe. \n¿Qué es lo que tiene la iniciativa emprendedora, qué debe o que le deben?"]
[]
[]
["Sobre Inversión Inicial"]
[]
["* Son los bienes o activos no corrientes; materiales, inmateriales y financieros  que necesitamos disponer para poner en marcha la empresa más los bienes  o activos corrientes ; existencias, IVA de las inversiones  y tesorería inicial."]
[]
["* Es todo aquello que necesitamos para comenzar la actividad:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["* En la inversión inicial los importes deben incluirse con IVA"]
[]
["* En la inversión inicial, como hipótesis consideraremos que en la tesorería inicial debemos contar con 3 meses de los gastos fijos. Aunque depende de la actividad."]
[]
["PRÁCTICA:"]
["Tu iniciativa tiene que comenzar la actividad en los próximos meses. Documenta la inversión inicial mínima con la que debes contar incluyéndola en los siguientes grupos:\n\n- Gastos de establecimiento\n- Activo no Corriente\n- Activo Corriente"]
[]
[]
[]
[]
[]
[]
[]
[]
["Sobre Financiación"]
[]
["* Financiar es conseguir recursos y medios de pago para destinarlos a la adquisición de bienes y servicios, necesarios para el desarrollo de las correspondientes actividades económicas. Se pueden clasificar en base a:\n"]
[]
["Procedencia:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*Conceptos básicos Financiación Ajena: Comisión apertura, comisión mantenimiento, comisión estudio, tipo de interés nominal o TAE, tipo de interés fijo o variable, seguros asociados, comisión cancelación, garantías o avales, plazo de amortización y periodo de carencia.\n"]
[]
[]
["Plazo de vencimiento:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Préstamo vs Crédito"]
["* Préstamo: Operación financiera en la que una entidad o persona (el prestamista) entrega a otra (el prestatario) una cantidad fija de dinero al comienzo de la operación, con la condiciónd e que el prestatario devuelva esa cantidad junto con los intereses pactados en un plazo determinado. La amortización(devolución) del préstamo normalmente se realiza mediante unas cuotas. La operación tiene una vida determinada previamente. Los intereses se cobran sobre el total del dinero prestado.\n* Crédito: Cantidad de dinero, con un límite fijado, que una entidad pone a disposición de un cliente. Al cliente no se le entrega la cantidad de golpe al inicio de la operación, sino que podrá utilizarla según las necesidades de cada momento, utilizando una cuenta o una tarjeta de crédito. Los intereses suelen ser más altos que los de un préstamo, pero sólo se paga por la cantidad utilizada.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["GASTOS FIJOS Y GASTOS VARIABLES …"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["INGRESOS "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CUENTA DE RESULTADOS "]

{"sheet":"Proyecto","index":3,"n_rows":35,"n_cols":2,"rows_kept":35,"cut":false,"hidden":false,"merged":[[32,1,32,5],[26,1,26,5],[29,1,29,5],[9,1,9,5],[2,1,2,5],[12,1,16,5],[20,1,20,5],[23,1,23,5]]}
[]
[]
[null,"DATOS GENERALES PROYECTO"]
[]
[]
[null,"Fecha Inicio Actividad DIA/MES/AÑO"]
[]
[]
[null,"Nombre emprendimiento"]
[]
[]
[null,"Breve descripción emprendimiento"]
[]
[]
[]
[]
[]
[]
[]
[null,"Nombre de la persona que rellena la tabla "]
[]
[]
[null,"Rol dentro del proyecto"]
[]
[]
[null,"Fecha inicio completar la tabla "]
[]
[]
[null,"Web del proyecto y RRSS (si la tiene) "]
[]
[]
[null,"Forma juridica (o persona fisica autonomos)"]
[]
[]
[null,"¿tiene impuesto sobre beneficio esta forma juridica (o persona fisica)? Indicar porcentaje (ejemplo 20%)"]

{"sheet":"Inversion Inicial","index":4,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[[4,1,4,3],[12,5,12,8],[12,9,12,13]]}
[]
[null,"CUADRO INVERSIÓN INICIAL"]
[]
[]
[null,"INVERSIÓN INICIAL "]
[]
[null,"IVA","GASTOS DE ESTABLECIMIENTO",{"$f":"SUM(D8:D13)","v":0}]
[null,null,"Licencia Actividad"]
[null,null,"Permisos",null,"Inm. Inmaterial"]
[null,null,"Gastos Constitución"]
[null,null,"Obras y reformas"]
[null,null,"Fianza o Aval Alquiler Local",null,"Inm. Material"]
[null,null,null,null,null,"INVERSION DESPUES DEL PRIMER AÑO ",null,null,null,"AMORTIZACION"]
[null,"IVA","ACTIVO NO CORRIENTE",{"$f":"SUM(D15:D25)","v":0},null,"AÑO 1","AÑO 2","AÑO 3","AÑO 4","Amortizacion anual %","AÑO 1","AÑO 2","AÑO 3","AÑO 4"]
[null,null,"Terrenos y bienes naturales",null,null,null,null,null,null,0.03,{"$f":"+(D15+F15)*J15","v":0},{"$f":"+K15+(G15*J15)","v":0},0,{"$f":"+L15+(I15*J15)","v":0}]
[null,null,"Construcciones",null,null,null,null,null,null,0.1,0,0,0,0]
[null,null,"Maquinaria",null,null,null,null,null,null,{"$f":"0.125*100%","v":0.125},0,0,0,0]
[null,null,"Utillaje y herramienta",null,"Inm. Material",null,null,null,null,0.2,0,0,0,0]
[null,null,"Otras instalaciones",null,null,null,null,null,null,0.1,0,0,0,0]
[null,null,"Mobiliario",null,null,null,null,null,null,0.1,0,0,0,0]
[null,null,"Equipos para proceso de información",null,null,null,null,null,null,0.25,0,0,0,0]
[null,null,"Elementos de transporte",null,null,null,null,null,null,{"$f":"0.142857142857143*100%","v":0.14285714285714299},0,0,0,0]
[null,null,"Gastos de inv.y des., pro. intelectual y derechos de traspaso",null,null,null,null,null,null,0.2,0,0,0,0]
[null,null,"Aplicaciones informáticas",null,"Inm. Inmaterial",null,null,null,null,0.33300000000000002,0,0,0,0]
[null,null,null,null,"Inm. Financiero "]
[]
[null,"IVA","ACTIVO CORRIENTE",{"$f":"+SUM(D28:D32)","v":0}]
[null,null,"Stock Inicial de material para la venta",null,"Existencias"]
[]
[null,null,null,null,"Deudores"]
[]
[null,null,"Tesorería ( incluir 3 meses de gastos fijos aprox)",null,"Tesorería (Efectivo)"]
[]
[null,null,"TOTAL INVERSION INICIAL",{"$f":"+D27+D14+D7","v":0}]

{"sheet":"Financiacion","index":5,"n_rows":380,"n_cols":18,"rows_kept":380,"cut":false,"hidden":false,"merged":[[18,15,19,15],[18,16,19,16],[18,17,19,17],[18,14,19,14],[4,1,4,2],[4,5,4,9],[4,12,4,16],[18,13,19,13],[18,12,19,12],[18,5,19,5],[18,6,19,6],[18,7,19,7],[18,8,19,8],[18,9,19,9],[18,10,19,10]]}
[]
[null,"CUADRO FINANCIACIÓN",null,null,null,"SIMULADOR DE PRÉSTAMOS "]
[]
[]
[null,"FINANCIACIÓN",null,null,null,"EJEMPLO DE PRESTAMO 1",null,null,null,null,null,null,"EJEMPLO DE PRESTAMO 2"]
[]
[null,"Recuerda !  Ha de cuadrar con el total de Inversión Inicial ",{"$f":"+IF('Inversion Inicial'!D34=C25,\"Si, cuadra\",\"No cuadra, revisar\")","v":"Si, cuadra"},null,null,"CANTIDAD A SOLICITAR (EUROS):",null,null,null,null,null,null,"CANTIDAD A SOLICITAR (EUROS):"]
[null,null,null,null,null,"PERIODO DE DEVOLUCION (AÑOS)",null,null,null,null,null,null,"PERIODO DE DEVOLUCION (AÑOS)"]
[null,"FONDOS PROPIOS",{"$f":"SUM(C10:C14)","v":0},null,null,"TIPO DE INTERES (%)",null,null,null,null,null,null,"TIPO DE INTERES (%)"]
[null,"Capital Social",null,null,null,"COSTES DE LA OPERACIÓN (%)",null,null,null,null,null,null,"COSTES DE LA OPERACIÓN (%)"]
[null,"Pago único prestación desempleo"]
[null,"Subvenciones",null,null,null,"CUADRO DE AMORTIZACION","AÑO 1","AÑO 2","AÑO 3",null,null,null,"CUADRO DE AMORTIZACION","AÑO 1","AÑO 2","AÑO 3"]
[null,".",null,null,null,"Intereses",{"$f":"+SUM(H21:H32)","v":0},{"$f":"SUM(H33:H44)","v":0},{"$f":"SUM(H45:H56)","v":0},null,null,null,"Intereses",{"$f":"+SUM(O21:O32)","v":0},{"$f":"SUM(O33:O44)","v":0},{"$f":"SUM(O45:O56)","v":0}]
[null,".",null,null,null,"Devolución del principal",{"$f":"SUM(I21:I32)","v":0},{"$f":"SUM(I33:I44)","v":0},{"$f":"SUM(I45:I56)","v":0},null,null,null,"Devolución del principal",{"$f":"SUM(P21:P32)","v":0},{"$f":"SUM(P33:P44)","v":0},{"$f":"SUM(P45:P56)","v":0}]
[null,"FINANCIACIÓN AJENA A L/P",{"$f":"SUM(C16:C18)","v":0},null,null,"Importe total de las cuotas",{"$f":"+G13+G14","v":0},{"$f":"+H13+H14","v":0},{"$f":"+I13+I14","v":0},null,null,null,"Importe total de las cuotas",{"$f":"+N13+N14","v":0},{"$f":"+O13+O14","v":0},{"$f":"+P13+P14","v":0}]
[null,"Deudas con entidades de crédito a largo plazo",{"$f":"+G7","v":0},null,null,"Comisiones apertura",{"$f":"+G7*G10","v":0},null,null,null,null,null,"Comisiones apertura",{"$f":"+N7*N10","v":0}]
[null,"Otras deudas a largo plazo"]
[null,"Otro a largo plazo "]
[null,"FINANCIACIÓN AJENA A C/P",{"$f":"+SUM(C20:C23)","v":0},null,null,"Periodo","Cuota mensual","Intereses","Amortizado","Capital amortizado","Capital pendiente",null,"Periodo","Cuota mensual","Intereses","Amortizado","Capital amortizado","Capital pendiente"]
[null,"Proveedores",null,null,null,null,null,null,null,"amortizado","pendiente",null,null,null,null,null,"amortizado","pendiente"]
[null,"Deudas con entidades de crédito a corto plazo",null,null,1,{"$f":"+IF(($G$8*12-E21)>=0,E21,\"\")","v":""},{"$f":"+IF(F21<>\"\",($G$7*$G$9/12)/(1-(1+($G$9/12))^(-$G$8*12)),0)","v":0},{"$f":"+IF(F21<>\"\",$G$7*$G$9/12,\"\")","v":""},{"$f":"+IF(F21<>\"\",G21-H21,\"\")","v":""},{"$f":"+IF(F21<>\"\",I21,\"\")","v":""},{"$f":"+IF(F21<>\"\",$G$7-J21,\"\")","v":""},null,{"$f":"+IF(($N$8*12-E21)>=0,E21,\"\")","v":""},{"$f":"+IF(M21<>\"\",($N$7*$N$9/12)/(1-(1+($N$9/12))^(-$N$8*12)),0)","v":0},{"$f":"+IF(M21<>\"\",$N$7*$N$9/12,\"\")","v":""},{"$f":"+IF(M21<>\"\",N21-O21,\"\")","v":""},{"$f":"+IF(M21<>\"\",P21,\"\")","v":""},{"$f":"+IF(M21<>\"\",$N$7-Q21,\"\")","v":""}]
[null,"Deudas con las Administraciones Públicas",null,null,2,"",0,{"$f":"+IF(F22<>\"\",K21*$G$9/12,\"\")","v":""},{"$f":"+IF(F22<>\"\",G22-H22,\"\")","v":""},{"$f":"+IF(F22<>\"\",I22+J21,\"\")","v":""},"",null,"",0,{"$f":"+IF(M22<>\"\",R21*$N$9/12,\"\")","v":""},{"$f":"+IF(M22<>\"\",N22-O22,\"\")","v":""},{"$f":"+IF(M22<>\"\",P22+Q21,\"\")","v":""},""]
[null,"Otras deudas a corto plazo",{"$f":"+G16","v":0},null,3,"",0,"",{"$f":"+IF(F23<>\"\",G23-H23,\"\")","v":""},{"$f":"+IF(F23<>\"\",I23+J22,\"\")","v":""},"",null,"",0,"",{"$f":"+IF(M23<>\"\",N23-O23,\"\")","v":""},{"$f":"+IF(M23<>\"\",P23+Q22,\"\")","v":""},""]
[null,null,null,null,4,"",0,"","","","",null,"",0,"","","",""]
[null,"TOTAL FINANCIACION",{"$f":"+C9+C15+C19","v":0},null,5,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,6,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,7,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,{"$f":"+E27+1","v":8},"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,{"$f":"+E28+1","v":9},"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,10,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,11,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,12,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,13,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,14,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,15,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,16,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,17,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,18,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,19,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,20,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,21,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,22,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,23,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,24,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,25,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,26,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,27,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,28,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,29,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,30,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,31,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,32,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,33,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,34,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,35,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,36,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,37,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,38,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,39,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,40,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,41,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,42,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,43,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,44,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,45,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,46,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,47,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,48,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,49,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,50,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,51,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,52,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,53,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,54,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,55,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,56,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,57,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,58,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,59,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,60,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,61,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,62,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,63,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,64,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,65,{"$f":"+IF(($G$8*12-E85)>=0,E85,\"\")","v":""},{"$f":"+IF(F85<>\"\",($G$7*$G$9/12)/(1-(1+($G$9/12))^(-$G$8*12)),0)","v":0},"","","",{"$f":"+IF(F85<>\"\",$G$7-J85,\"\")","v":""},null,{"$f":"+IF(($N$8*12-E85)>=0,E85,\"\")","v":""},{"$f":"+IF(M85<>\"\",($N$7*$N$9/12)/(1-(1+($N$9/12))^(-$N$8*12)),0)","v":0},"","","",{"$f":"+IF(M85<>\"\",$N$7-Q85,\"\")","v":""}]
[null,null,null,null,66,"",0,{"$f":"+IF(F86<>\"\",K85*$G$9/12,\"\")","v":""},"","","",null,"",0,{"$f":"+IF(M86<>\"\",R85*$N$9/12,\"\")","v":""},"","",""]
[null,null,null,null,67,"",0,"",{"$f":"+IF(F87<>\"\",G87-H87,\"\")","v":""},{"$f":"+IF(F87<>\"\",I87+J86,\"\")","v":""},"",null,"",0,"",{"$f":"+IF(M87<>\"\",N87-O87,\"\")","v":""},{"$f":"+IF(M87<>\"\",P87+Q86,\"\")","v":""},""]
[null,null,null,null,68,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,69,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,70,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,71,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,72,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,{"$f":"+E92+1","v":73},"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,74,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,75,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,76,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,77,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,78,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,79,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,80,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,81,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,82,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,83,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,84,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,85,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,86,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,87,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,88,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,89,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,90,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,91,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,92,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,93,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,94,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,95,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,96,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,97,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,98,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,99,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,100,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,101,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,102,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,103,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,104,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,105,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,106,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,107,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,108,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,109,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,110,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,111,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,112,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,113,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,114,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,115,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,116,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,117,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,118,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,119,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,120,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,121,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,122,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,123,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,124,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,125,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,126,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,127,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,128,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,129,{"$f":"+IF(($G$8*12-E149)>=0,E149,\"\")","v":""},{"$f":"+IF(F149<>\"\",($G$7*$G$9/12)/(1-(1+($G$9/12))^(-$G$8*12)),0)","v":0},"","","",{"$f":"+IF(F149<>\"\",$G$7-J149,\"\")","v":""},null,{"$f":"+IF(($N$8*12-E149)>=0,E149,\"\")","v":""},{"$f":"+IF(M149<>\"\",($N$7*$N$9/12)/(1-(1+($N$9/12))^(-$N$8*12)),0)","v":0},"","","",{"$f":"+IF(M149<>\"\",$N$7-Q149,\"\")","v":""}]
[null,null,null,null,130,"",0,{"$f":"+IF(F150<>\"\",K149*$G$9/12,\"\")","v":""},"","","",null,"",0,{"$f":"+IF(M150<>\"\",R149*$N$9/12,\"\")","v":""},"","",""]
[null,null,null,null,131,"",0,"",{"$f":"+IF(F151<>\"\",G151-H151,\"\")","v":""},{"$f":"+IF(F151<>\"\",I151+J150,\"\")","v":""},"",null,"",0,"",{"$f":"+IF(M151<>\"\",N151-O151,\"\")","v":""},{"$f":"+IF(M151<>\"\",P151+Q150,\"\")","v":""},""]
[null,null,null,null,132,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,133,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,134,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,135,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,136,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,{"$f":"+E156+1","v":137},"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,138,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,139,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,140,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,141,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,142,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,143,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,144,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,145,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,146,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,147,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,148,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,149,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,150,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,151,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,152,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,153,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,154,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,155,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,156,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,157,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,158,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,159,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,160,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,161,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,162,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,163,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,164,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,165,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,166,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,167,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,168,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,169,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,170,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,171,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,172,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,173,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,174,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,175,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,176,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,177,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,178,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,179,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,180,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,181,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,182,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,183,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,184,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,185,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,186,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,187,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,188,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,189,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,190,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,191,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,192,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,193,{"$f":"+IF(($G$8*12-E213)>=0,E213,\"\")","v":""},{"$f":"+IF(F213<>\"\",($G$7*$G$9/12)/(1-(1+($G$9/12))^(-$G$8*12)),0)","v":0},"","","",{"$f":"+IF(F213<>\"\",$G$7-J213,\"\")","v":""},null,{"$f":"+IF(($N$8*12-E213)>=0,E213,\"\")","v":""},{"$f":"+IF(M213<>\"\",($N$7*$N$9/12)/(1-(1+($N$9/12))^(-$N$8*12)),0)","v":0},"","","",{"$f":"+IF(M213<>\"\",$N$7-Q213,\"\")","v":""}]
[null,null,null,null,194,"",0,{"$f":"+IF(F214<>\"\",K213*$G$9/12,\"\")","v":""},"","","",null,"",0,{"$f":"+IF(M214<>\"\",R213*$N$9/12,\"\")","v":""},"","",""]
[null,null,null,null,195,"",0,"",{"$f":"+IF(F215<>\"\",G215-H215,\"\")","v":""},{"$f":"+IF(F215<>\"\",I215+J214,\"\")","v":""},"",null,"",0,"",{"$f":"+IF(M215<>\"\",N215-O215,\"\")","v":""},{"$f":"+IF(M215<>\"\",P215+Q214,\"\")","v":""},""]
[null,null,null,null,196,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,197,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,198,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,199,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,200,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,{"$f":"+E220+1","v":201},"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,202,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,203,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,204,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,205,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,206,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,207,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,208,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,209,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,210,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,211,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,212,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,213,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,214,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,215,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,216,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,217,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,218,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,219,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,220,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,221,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,222,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,223,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,224,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,225,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,226,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,227,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,228,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,229,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,230,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,231,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,232,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,233,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,234,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,235,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,236,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,237,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,238,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,239,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,240,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,241,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,242,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,243,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,244,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,245,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,246,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,247,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,248,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,249,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,250,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,251,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,252,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,253,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,254,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,255,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,256,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,257,{"$f":"+IF(($G$8*12-E277)>=0,E277,\"\")","v":""},{"$f":"+IF(F277<>\"\",($G$7*$G$9/12)/(1-(1+($G$9/12))^(-$G$8*12)),0)","v":0},"","","",{"$f":"+IF(F277<>\"\",$G$7-J277,\"\")","v":""},null,{"$f":"+IF(($N$8*12-E277)>=0,E277,\"\")","v":""},{"$f":"+IF(M277<>\"\",($N$7*$N$9/12)/(1-(1+($N$9/12))^(-$N$8*12)),0)","v":0},"","","",{"$f":"+IF(M277<>\"\",$N$7-Q277,\"\")","v":""}]
[null,null,null,null,258,"",0,{"$f":"+IF(F278<>\"\",K277*$G$9/12,\"\")","v":""},"","","",null,"",0,{"$f":"+IF(M278<>\"\",R277*$N$9/12,\"\")","v":""},"","",""]
[null,null,null,null,259,"",0,"",{"$f":"+IF(F279<>\"\",G279-H279,\"\")","v":""},{"$f":"+IF(F279<>\"\",I279+J278,\"\")","v":""},"",null,"",0,"",{"$f":"+IF(M279<>\"\",N279-O279,\"\")","v":""},{"$f":"+IF(M279<>\"\",P279+Q278,\"\")","v":""},""]
[null,null,null,null,260,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,261,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,262,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,263,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,264,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,{"$f":"+E284+1","v":265},"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,266,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,267,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,268,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,269,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,270,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,271,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,272,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,273,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,274,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,275,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,276,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,277,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,278,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,279,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,280,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,281,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,282,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,283,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,284,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,285,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,286,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,287,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,288,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,289,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,290,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,291,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,292,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,293,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,294,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,295,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,296,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,297,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,298,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,299,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,300,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,301,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,302,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,303,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,304,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,305,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,306,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,307,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,308,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,309,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,310,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,311,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,312,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,313,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,314,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,315,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,316,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,317,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,318,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,319,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,320,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,321,{"$f":"+IF(($G$8*12-E341)>=0,E341,\"\")","v":""},{"$f":"+IF(F341<>\"\",($G$7*$G$9/12)/(1-(1+($G$9/12))^(-$G$8*12)),0)","v":0},"","","",{"$f":"+IF(F341<>\"\",$G$7-J341,\"\")","v":""},null,{"$f":"+IF(($N$8*12-E341)>=0,E341,\"\")","v":""},{"$f":"+IF(M341<>\"\",($N$7*$N$9/12)/(1-(1+($N$9/12))^(-$N$8*12)),0)","v":0},"","","",{"$f":"+IF(M341<>\"\",$N$7-Q341,\"\")","v":""}]
[null,null,null,null,322,"",0,{"$f":"+IF(F342<>\"\",K341*$G$9/12,\"\")","v":""},"","","",null,"",0,{"$f":"+IF(M342<>\"\",R341*$N$9/12,\"\")","v":""},"","",""]
[null,null,null,null,323,"",0,"",{"$f":"+IF(F343<>\"\",G343-H343,\"\")","v":""},{"$f":"+IF(F343<>\"\",I343+J342,\"\")","v":""},"",null,"",0,"",{"$f":"+IF(M343<>\"\",N343-O343,\"\")","v":""},{"$f":"+IF(M343<>\"\",P343+Q342,\"\")","v":""},""]
[null,null,null,null,324,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,325,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,326,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,327,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,328,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,{"$f":"+E348+1","v":329},"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,330,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,331,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,332,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,333,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,334,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,335,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,336,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,337,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,338,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,339,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,340,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,341,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,342,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,343,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,344,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,345,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,346,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,347,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,348,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,349,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,350,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,351,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,352,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,353,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,354,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,355,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,356,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,357,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,358,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,359,"",0,"","","","",null,"",0,"","","",""]
[null,null,null,null,360,"",0,"","","","",null,"",0,"","","",""]

{"sheet":"Inversion vs Financiacion","index":6,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,1,1,5],[5,8,5,9],[5,12,5,13],[7,10,9,10],[7,11,9,11]]}
[]
[null,"CUADRO INVERSION INICIAL  / FINANCIACION ",null,null,null,null,null,null,"RESUMEN INVERSIÓN INICIAL / FINANCIACIÓN"]
[]
[null,"Inversión y Financiación ¿Estan cuadradas? ",{"$f":"+IF(C6=F6, \"SI\", \"No cuadra, REVISAR\")","v":"SI"},null,null,null,null,null,"Resumen Cuadro Inversión / Financiación"]
[]
[null,{"$f":"+IF('Inversion Inicial'!C34<>\"\",'Inversion Inicial'!C34,\"\")","v":"TOTAL INVERSION INICIAL"},{"$f":"+IF('Inversion Inicial'!D34<>\"\",'Inversion Inicial'!D34,\"\")","v":0},null,{"$f":"+IF(Financiacion!B25<>\"\",Financiacion!B25,\"\")","v":"TOTAL FINANCIACION"},{"$f":"+IF(Financiacion!C25<>\"\",Financiacion!C25,\"\")","v":0},null,null,"INVERSIÓN",null,null,null,"FINANCIACIÓN"]
[]
[null,{"$f":"+IF('Inversion Inicial'!C7<>\"\",'Inversion Inicial'!C7,\"\")","v":"GASTOS DE ESTABLECIMIENTO"},{"$f":"+IF('Inversion Inicial'!D7<>\"\",'Inversion Inicial'!D7,\"\")","v":0},null,{"$f":"+Financiacion!B9","v":"FONDOS PROPIOS"},{"$f":"+Financiacion!C9","v":0},null,null,"Gastos Establecimiento",{"$f":"+C8","v":0},{"$f":"+IFERROR(N11/J11,0)","v":0},{"$f":"+J11-N11","v":0},"Fondos Propios",{"$f":"+F8","v":0}]
[null,{"$f":"+IF('Inversion Inicial'!C8<>\"\",'Inversion Inicial'!C8,\"\")","v":"Licencia Actividad"},{"$f":"+IF('Inversion Inicial'!D8<>\"\",'Inversion Inicial'!D8,\"\")","v":""},null,{"$f":"+IF(Financiacion!B10<>\"\",Financiacion!B10,\"\")","v":"Capital Social"},{"$f":"+IF(Financiacion!C10<>\"\",Financiacion!C10,\"\")","v":""},null,null,"Activo No Corriente",{"$f":"+C15","v":0},null,null,"Financiación Ajena L/P",{"$f":"+F14","v":0}]
[null,{"$f":"+IF('Inversion Inicial'!C9<>\"\",'Inversion Inicial'!C9,\"\")","v":"Permisos"},{"$f":"+IF('Inversion Inicial'!D9<>\"\",'Inversion Inicial'!D9,\"\")","v":""},null,{"$f":"+IF(Financiacion!B11<>\"\",Financiacion!B11,\"\")","v":"Pago único prestación desempleo"},{"$f":"+IF(Financiacion!C11<>\"\",Financiacion!C11,\"\")","v":""},null,null,"Activo Corriente",{"$f":"+C28","v":0},null,null,"Financiación Ajena C/P",{"$f":"+F18","v":0}]
[null,{"$f":"+IF('Inversion Inicial'!C10<>\"\",'Inversion Inicial'!C10,\"\")","v":"Gastos Constitución"},{"$f":"+IF('Inversion Inicial'!D10<>\"\",'Inversion Inicial'!D10,\"\")","v":""},null,{"$f":"+IF(Financiacion!B12<>\"\",Financiacion!B12,\"\")","v":"Subvenciones"},{"$f":"+IF(Financiacion!C12<>\"\",Financiacion!C12,\"\")","v":""},null,null,null,{"$f":"+SUM(J8:J10)","v":0},null,null,null,{"$f":"+SUM(N8:N10)","v":0}]
[null,{"$f":"+IF('Inversion Inicial'!C11<>\"\",'Inversion Inicial'!C11,\"\")","v":"Obras y reformas"},{"$f":"+IF('Inversion Inicial'!D11<>\"\",'Inversion Inicial'!D11,\"\")","v":""},null,{"$f":"+IF(Financiacion!B13<>\"\",Financiacion!B13,\"\")","v":"."},{"$f":"+IF(Financiacion!C13<>\"\",Financiacion!C13,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C12<>\"\",'Inversion Inicial'!C12,\"\")","v":"Fianza o Aval Alquiler Local"},null,null,{"$f":"+IF(Financiacion!B14<>\"\",Financiacion!B14,\"\")","v":"."},{"$f":"+IF(Financiacion!C14<>\"\",Financiacion!C14,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C13<>\"\",'Inversion Inicial'!C13,\"\")","v":""},{"$f":"+IF('Inversion Inicial'!D13<>\"\",'Inversion Inicial'!D13,\"\")","v":""},null,{"$f":"+IF(Financiacion!B15<>\"\",Financiacion!B15,\"\")","v":"FINANCIACIÓN AJENA A L/P"},{"$f":"+IF(Financiacion!C15<>\"\",Financiacion!C15,\"\")","v":0}]
[null,{"$f":"+IF('Inversion Inicial'!C14<>\"\",'Inversion Inicial'!C14,\"\")","v":"ACTIVO NO CORRIENTE"},{"$f":"+IF('Inversion Inicial'!D14<>\"\",'Inversion Inicial'!D14,\"\")","v":0},null,{"$f":"+IF(Financiacion!B16<>\"\",Financiacion!B16,\"\")","v":"Deudas con entidades de crédito a largo plazo"},{"$f":"+IF(Financiacion!C16<>\"\",Financiacion!C16,\"\")","v":0}]
[null,{"$f":"+IF('Inversion Inicial'!C15<>\"\",'Inversion Inicial'!C15,\"\")","v":"Terrenos y bienes naturales"},{"$f":"+IF('Inversion Inicial'!D15<>\"\",'Inversion Inicial'!D15,\"\")","v":""},null,{"$f":"+IF(Financiacion!B17<>\"\",Financiacion!B17,\"\")","v":"Otras deudas a largo plazo"},{"$f":"+IF(Financiacion!C17<>\"\",Financiacion!C17,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C16<>\"\",'Inversion Inicial'!C16,\"\")","v":"Construcciones"},{"$f":"+IF('Inversion Inicial'!D16<>\"\",'Inversion Inicial'!D16,\"\")","v":""},null,{"$f":"+IF(Financiacion!B18<>\"\",Financiacion!B18,\"\")","v":"Otro a largo plazo "},{"$f":"+IF(Financiacion!C18<>\"\",Financiacion!C18,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C17<>\"\",'Inversion Inicial'!C17,\"\")","v":"Maquinaria"},{"$f":"+IF('Inversion Inicial'!D17<>\"\",'Inversion Inicial'!D17,\"\")","v":""},null,{"$f":"+IF(Financiacion!B19<>\"\",Financiacion!B19,\"\")","v":"FINANCIACIÓN AJENA A C/P"},{"$f":"+IF(Financiacion!C19<>\"\",Financiacion!C19,\"\")","v":0}]
[null,{"$f":"+IF('Inversion Inicial'!C18<>\"\",'Inversion Inicial'!C18,\"\")","v":"Utillaje y herramienta"},{"$f":"+IF('Inversion Inicial'!D18<>\"\",'Inversion Inicial'!D18,\"\")","v":""},null,{"$f":"+IF(Financiacion!B20<>\"\",Financiacion!B20,\"\")","v":"Proveedores"},{"$f":"+IF(Financiacion!C20<>\"\",Financiacion!C20,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C19<>\"\",'Inversion Inicial'!C19,\"\")","v":"Otras instalaciones"},{"$f":"+IF('Inversion Inicial'!D19<>\"\",'Inversion Inicial'!D19,\"\")","v":""},null,{"$f":"+IF(Financiacion!B21<>\"\",Financiacion!B21,\"\")","v":"Deudas con entidades de crédito a corto plazo"},{"$f":"+IF(Financiacion!C21<>\"\",Financiacion!C21,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C20<>\"\",'Inversion Inicial'!C20,\"\")","v":"Mobiliario"},{"$f":"+IF('Inversion Inicial'!D20<>\"\",'Inversion Inicial'!D20,\"\")","v":""},null,{"$f":"+IF(Financiacion!B22<>\"\",Financiacion!B22,\"\")","v":"Deudas con las Administraciones Públicas"},{"$f":"+IF(Financiacion!C22<>\"\",Financiacion!C22,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C21<>\"\",'Inversion Inicial'!C21,\"\")","v":"Equipos para proceso de información"},{"$f":"+IF('Inversion Inicial'!D21<>\"\",'Inversion Inicial'!D21,\"\")","v":""},null,{"$f":"+IF(Financiacion!B23<>\"\",Financiacion!B23,\"\")","v":"Otras deudas a corto plazo"},{"$f":"+IF(Financiacion!C23<>\"\",Financiacion!C23,\"\")","v":0}]
[null,{"$f":"+IF('Inversion Inicial'!C22<>\"\",'Inversion Inicial'!C22,\"\")","v":"Elementos de transporte"},{"$f":"+IF('Inversion Inicial'!D22<>\"\",'Inversion Inicial'!D22,\"\")","v":""},null,{"$f":"+IF(Financiacion!B24<>\"\",Financiacion!B24,\"\")","v":""},{"$f":"+IF(Financiacion!C24<>\"\",Financiacion!C24,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C23<>\"\",'Inversion Inicial'!C23,\"\")","v":"Gastos de inv.y des., pro. intelectual y derechos de traspaso"},{"$f":"+IF('Inversion Inicial'!D23<>\"\",'Inversion Inicial'!D23,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C24<>\"\",'Inversion Inicial'!C24,\"\")","v":"Aplicaciones informáticas"},{"$f":"+IF('Inversion Inicial'!D24<>\"\",'Inversion Inicial'!D24,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C25<>\"\",'Inversion Inicial'!C25,\"\")","v":""},{"$f":"+IF('Inversion Inicial'!D25<>\"\",'Inversion Inicial'!D25,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C26<>\"\",'Inversion Inicial'!C26,\"\")","v":""},{"$f":"+IF('Inversion Inicial'!D26<>\"\",'Inversion Inicial'!D26,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C27<>\"\",'Inversion Inicial'!C27,\"\")","v":"ACTIVO CORRIENTE"},{"$f":"+IF('Inversion Inicial'!D27<>\"\",'Inversion Inicial'!D27,\"\")","v":0}]
[null,{"$f":"+IF('Inversion Inicial'!C28<>\"\",'Inversion Inicial'!C28,\"\")","v":"Stock Inicial de material para la venta"},{"$f":"+IF('Inversion Inicial'!D28<>\"\",'Inversion Inicial'!D28,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C29<>\"\",'Inversion Inicial'!C29,\"\")","v":""},{"$f":"+IF('Inversion Inicial'!D29<>\"\",'Inversion Inicial'!D29,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C30<>\"\",'Inversion Inicial'!C30,\"\")","v":""},{"$f":"+IF('Inversion Inicial'!D30<>\"\",'Inversion Inicial'!D30,\"\")","v":""},null,null,null,null,null,"RESUMEN FINANCIACION"]
[null,{"$f":"+IF('Inversion Inicial'!C31<>\"\",'Inversion Inicial'!C31,\"\")","v":""},{"$f":"+IF('Inversion Inicial'!D31<>\"\",'Inversion Inicial'!D31,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C32<>\"\",'Inversion Inicial'!C32,\"\")","v":"Tesorería ( incluir 3 meses de gastos fijos aprox)"},{"$f":"+IF('Inversion Inicial'!D32<>\"\",'Inversion Inicial'!D32,\"\")","v":""},null,null,null,null,null,"Estructura de Financiación Necesaria"]
[null,{"$f":"+IF('Inversion Inicial'!C33<>\"\",'Inversion Inicial'!C33,\"\")","v":""},{"$f":"+IF('Inversion Inicial'!D33<>\"\",'Inversion Inicial'!D33,\"\")","v":""}]
[null,null,null,null,null,null,null,null,"FINANCIACIÓN","%","TOTAL"]
[null,{"$f":"+IF('Inversion Inicial'!C35<>\"\",'Inversion Inicial'!C35,\"\")","v":""},{"$f":"+IF('Inversion Inicial'!D35<>\"\",'Inversion Inicial'!D35,\"\")","v":""},null,null,null,null,null,"F. Propia",{"$f":"+IFERROR(K36/$K$38,0)","v":0},{"$f":"+N8","v":0}]
[null,{"$f":"+IF('Inversion Inicial'!C36<>\"\",'Inversion Inicial'!C36,\"\")","v":""},{"$f":"+IF('Inversion Inicial'!D36<>\"\",'Inversion Inicial'!D36,\"\")","v":""},null,null,null,null,null,"F. Ajena",{"$f":"+IFERROR(K37/$K$38,0)","v":0},{"$f":"+K38-K36","v":0}]
[null,{"$f":"+IF('Inversion Inicial'!C37<>\"\",'Inversion Inicial'!C37,\"\")","v":""},{"$f":"+IF('Inversion Inicial'!D37<>\"\",'Inversion Inicial'!D37,\"\")","v":""},null,null,null,null,null,"Total",{"$f":"+IFERROR(K38/$K$38,0)","v":0},{"$f":"+J11","v":0}]
[null,{"$f":"+IF('Inversion Inicial'!C38<>\"\",'Inversion Inicial'!C38,\"\")","v":""},{"$f":"+IF('Inversion Inicial'!D38<>\"\",'Inversion Inicial'!D38,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C39<>\"\",'Inversion Inicial'!C39,\"\")","v":""},{"$f":"+IF('Inversion Inicial'!D39<>\"\",'Inversion Inicial'!D39,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C40<>\"\",'Inversion Inicial'!C40,\"\")","v":""},{"$f":"+IF('Inversion Inicial'!D40<>\"\",'Inversion Inicial'!D40,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C41<>\"\",'Inversion Inicial'!C41,\"\")","v":""},{"$f":"+IF('Inversion Inicial'!D41<>\"\",'Inversion Inicial'!D41,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C42<>\"\",'Inversion Inicial'!C42,\"\")","v":""},{"$f":"+IF('Inversion Inicial'!D42<>\"\",'Inversion Inicial'!D42,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C43<>\"\",'Inversion Inicial'!C43,\"\")","v":""},{"$f":"+IF('Inversion Inicial'!D43<>\"\",'Inversion Inicial'!D43,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C44<>\"\",'Inversion Inicial'!C44,\"\")","v":""},{"$f":"+IF('Inversion Inicial'!D44<>\"\",'Inversion Inicial'!D44,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C45<>\"\",'Inversion Inicial'!C45,\"\")","v":""},{"$f":"+IF('Inversion Inicial'!D45<>\"\",'Inversion Inicial'!D45,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C46<>\"\",'Inversion Inicial'!C46,\"\")","v":""},{"$f":"+IF('Inversion Inicial'!D46<>\"\",'Inversion Inicial'!D46,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C47<>\"\",'Inversion Inicial'!C47,\"\")","v":""},{"$f":"+IF('Inversion Inicial'!D47<>\"\",'Inversion Inicial'!D47,\"\")","v":""}]
[null,{"$f":"+IF('Inversion Inicial'!C48<>\"\",'Inversion Inicial'!C48,\"\")","v":""}]

{"sheet":"Ingresos","index":7,"n_rows":63,"n_cols":30,"rows_kept":63,"cut":false,"hidden":false,"merged":[[47,23,47,24],[45,8,47,13],[42,2,42,4],[36,17,36,19],[40,21,40,22],[47,16,47,18],[32,1,36,13]]}
[]
[null,"INGRESOS"]
[]
[null,"VENTAS PRODUCTOS / SERVICIOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INGRESOS PRODUCTOS / SERVICIOS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"En Euros ",{"$f":"+C19","v":""},"","","","","","","","","","","","TOTAL"]
[null,"Productos o Servicios ","Precio Unidad (Precio de Venta)",null,null,null,null,"año 2","año 3 ","año 4",null,null,null,null,null,null,"TOTAL VENTAS POR INGRESOS",{"$f":"+R23","v":0},{"$f":"+S23","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"producto o servicio 1 ",null,null,null," INCREMENTO SOBRE AÑO 1 EN %",null,null,null,null,null,null,null,null,null,null,"TOTAL OTROS INGRESOS",{"$f":"+R30","v":0},{"$f":"+S30","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"producto o servicio 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL INGRESOS",{"$f":"+R7+R8","v":0},{"$f":"+S7+S8","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"producto o servicio 3"]
[null,"producto o servicio 4"]
[null,"producto o servicio 5",null,null,null,null,null,null,null,null,null,null,null,null,null,"IVA %","Ingresos",{"$f":"+C19","v":""},"","","","","","","","","","","","TOTAL"]
[null,"producto o servicio 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(B20=\"\",\"\",B20)","v":"producto o servicio 1 "},{"$f":"+IFERROR(VLOOKUP($Q13,$B$8:$C$17,2,FALSE)*C20,0)","v":0},{"$f":"+IFERROR(VLOOKUP($Q13,$B$8:$C$17,2,FALSE)*D20,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R13:AC13)","v":0}]
[null,"producto o servicio 7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"producto o servicio 2",{"$f":"+IFERROR(VLOOKUP($Q14,$B$8:$C$17,2,FALSE)*C21,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"producto o servicio 8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"producto o servicio 3",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"producto o servicio 9",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"producto o servicio 4",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"producto o servicio 10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"producto o servicio 5",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"producto o servicio 6",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Ventas/uds",{"$f":"+'Cuenta Resultados'!C9","v":""},{"$f":"+'Cuenta Resultados'!D9","v":""},{"$f":"+'Cuenta Resultados'!E9","v":""},{"$f":"+'Cuenta Resultados'!F9","v":""},{"$f":"+'Cuenta Resultados'!G9","v":""},{"$f":"+'Cuenta Resultados'!H9","v":""},{"$f":"+'Cuenta Resultados'!I9","v":""},{"$f":"+'Cuenta Resultados'!J9","v":""},{"$f":"+'Cuenta Resultados'!K9","v":""},{"$f":"+'Cuenta Resultados'!L9","v":""},{"$f":"+'Cuenta Resultados'!M9","v":""},{"$f":"+'Cuenta Resultados'!N9","v":""},null,null,"producto o servicio 7",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"+B8","v":"producto o servicio 1 "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"producto o servicio 8",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"producto o servicio 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"producto o servicio 9",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"producto o servicio 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"producto o servicio 10",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"producto o servicio 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VENTAS ",{"$f":"SUM(R13:R22)","v":0},{"$f":"SUM(S13:S22)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"producto o servicio 5"]
[null,"producto o servicio 6"]
[null,"producto o servicio 7",null,null,null,null,null,null,null,null,null,null,null,null,null,"IVA %","OTROS INGRESOS",{"$f":"+R12","v":""},{"$f":"+S12","v":""},"","","","","","","","","","","TOTAL"]
[null,"producto o servicio 8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R27:AC27)","v":0}]
[null,"producto o servicio 9",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R28:AC28)","v":0}]
[null,"producto o servicio 10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R29:AC29)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL OTROS INGRESOS",{"$f":"+SUM(R27:R29)","v":0},{"$f":"+SUM(S27:S29)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL VENTAS en unidades",{"$f":"SUM(C20:C30)","v":0},{"$f":"SUM(D20:D30)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Razones de porque escenario"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CALCULO PRECIOS PRODUCTOS"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Producto",null,null,null,null,null,null,null,null,null,null,"EN TEORÍA…"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COSTES VARIABLES POR UNIDAD",null,null,null,null,"COSTES FIJOS POR UNIDAD"]
[]
[null,"CALCULO PRECIOS SERVICIOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Concepto","Precio","Uds","Coste Ud",null,"Concepto",null,"Precio","Uds","Coste Ud"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IFERROR(R42/S42,0)","v":0},null,null,null,null,null,{"$f":"+IFERROR(Z48/Y42,0)","v":0}]
[null,"Servicio",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IFERROR(R43/S43,0)","v":0}]
[null,null,null,null,null,null,null,null,"EN TEORÍA…",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Concepto","VALOR",null,null,null,null,null,"Un buen precio de producto es clave para conseguir buenas ventas. Que sea atractivo para el consumidor, pero que nos deje suficiente margen comercial. ",null,null,null,null,null,null,null,null,null,null,0]
[null,"dias de trabajo mensual",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"horas dedicadas al dia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",null,null,{"$f":"SUM(T42:T47)","v":0},null,null,null,"TOTAL",null,{"$f":"SUM(X42:X47)","v":0}]
[null,"Salario mensual deseado"]
[null,"días de vacaciones al año",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coste Total Unidad Producto",null,null,null,null,{"$f":"(+Z42+T48)","v":0}]
[null,"diás festivos al año"]
[null,"días inactividad al año",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Margen de Beneficio"]
[null,"% tiempo reuniones"]
[null,"aproximación de gastos mensuales fijos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Precio Venta",null,null,null,null,{"$f":"+V50+(V52*V50)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Precio Otras Empresas"]
[null,"Horas mensuales",null,null,null,null,{"$f":"+C47*C48","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"¿Cuánto están dispuestos a pagar los clientes?"]
[null,"Horas dedicadas al proyecto mensuales",null,null,null,null,{"$f":"+G57-((C50+C51+C52)*7/12)","v":0}]
[]
[null,"Horas facturadas",null,null,null,null,{"$f":"G59-(G59*C53)","v":0}]
[]
[null,"Precio hora",null,null,null,null,{"$f":"+IFERROR((C49+C54)/G61,0)","v":0}]

{"sheet":"Gastos Fijos","index":8,"n_rows":79,"n_cols":16,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
[]
[null,"GASTOS FIJOS"]
[]
[]
[null,null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,"PREVISIÓN MENSUAL DE GASTOS FIJOS","IVA",{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+C5>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+C5-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+C5<10,\"0\"&MONTH(Proyecto!$B$7)+C5,MONTH(Proyecto!$B$7)+C5)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+D5>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+D5-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+D5<10,\"0\"&MONTH(Proyecto!$B$7)+D5,MONTH(Proyecto!$B$7)+D5)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+E5>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+E5-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+E5<10,\"0\"&MONTH(Proyecto!$B$7)+E5,MONTH(Proyecto!$B$7)+E5)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+F5>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+F5-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+F5<10,\"0\"&MONTH(Proyecto!$B$7)+F5,MONTH(Proyecto!$B$7)+F5)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+G5>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+G5-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+G5<10,\"0\"&MONTH(Proyecto!$B$7)+G5,MONTH(Proyecto!$B$7)+G5)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+H5>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+H5-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+H5<10,\"0\"&MONTH(Proyecto!$B$7)+H5,MONTH(Proyecto!$B$7)+H5)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+I5>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+I5-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+I5<10,\"0\"&MONTH(Proyecto!$B$7)+I5,MONTH(Proyecto!$B$7)+I5)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+J5>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+J5-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+J5<10,\"0\"&MONTH(Proyecto!$B$7)+J5,MONTH(Proyecto!$B$7)+J5)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+K5>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+K5-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+K5<10,\"0\"&MONTH(Proyecto!$B$7)+K5,MONTH(Proyecto!$B$7)+K5)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+L5>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+L5-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+L5<10,\"0\"&MONTH(Proyecto!$B$7)+L5,MONTH(Proyecto!$B$7)+L5)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+M5>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+M5-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+M5<10,\"0\"&MONTH(Proyecto!$B$7)+M5,MONTH(Proyecto!$B$7)+M5)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+N5>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+N5-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+N5<10,\"0\"&MONTH(Proyecto!$B$7)+N5,MONTH(Proyecto!$B$7)+N5)))","v":""},"TOTAL"]
[null,"Alquileres y cánones",null,null,{"$f":"+D7","v":0},{"$f":"+E7","v":0},0,0,0,0,0,0,0,0,0,{"$f":"+SUM(D7:O7)","v":0}]
[null,"Renting",null,null,{"$f":"+D8","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(D8:O8)","v":0}]
[null,"Conservación (Mantenimiento y reparaciones)",null,null,{"$f":"+D9","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Servicios profesionales",null,null,{"$f":"+D10","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Transporte",null,null,{"$f":"+D11","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Seguros",null,null,{"$f":"+D12","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Gastos bancarios",null,null,{"$f":"+D13","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Publicidad y comunicación",null,null,{"$f":"+D14","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Suministros",null,null,{"$f":"+D15","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Otros gastos y servicios",null,null,{"$f":"+D16","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Seguros",null,null,{"$f":"+D17","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Impuestos y tasas",null,null,{"$f":"+D18","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Material de Oficina",null,null,{"$f":"+D19","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Sueldo bruto de los trabajadores autónomos",null,null,{"$f":"+D20","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Cotización a la Seguridad Social de los trabajadores autónomos",null,null,{"$f":"+D21","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Sueldo bruto de los trabajadores en régimen general",null,null,{"$f":"+D22","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Cotización a la Seguridad Social de los trabajadores en régimen general",null,null,{"$f":"+D23","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Previsión Mensual de Compras",null,null,{"$f":"+D24","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Retenciones IRPF",null,null,{"$f":"+D25","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Amortizaciones",null,{"$f":"+SUM('Inversion Inicial'!K15:K24)/12","v":0},{"$f":"+D26","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Cuota de préstamo (gastos financieros)",null,{"$f":"+Financiacion!G21","v":0},{"$f":"+D27","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"+D28","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"+D29","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"+D30","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total Base Gastos Fijos",null,{"$f":"SUM(D7:D30)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Iva Gastos Fijos",null,{"$f":"SUMPRODUCT($C$7:$C$30,D7:D30)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Importe Gastos Fijos",null,{"$f":"D32+D33","v":0},{"$f":"E32+E33","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"P32+P33","v":0}]
[]
[null,"TOTAL GASTOS FIJOS",null,{"$f":"D32","v":0},{"$f":"E32","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[null,"PREVISIÓN MENSUAL DE OTROS GASTOS","IVA",{"$f":"+D6","v":""},{"$f":"+E6","v":""},"","","","","","","","","","","TOTAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(B43:O43)","v":0}]
[null,"TOTAL OTROS GASTOS ",null,{"$f":"D40","v":0},{"$f":"E40","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Gastos Variables","index":9,"n_rows":33,"n_cols":18,"rows_kept":33,"cut":false,"hidden":false,"merged":[[7,1,7,9],[3,1,3,9],[20,1,20,17]]}
[]
[null," GASTOS VARIABLES"]
[]
[null,"Instrucciones:  introduce el  porcentaje sobre el precio de venta que suponen los costes variables de cada uno de los productos o servicios de tu negocio. En muchas ocasiones puede que no se den este tipo de costes. Sin embargo son fundamentales en el comercio, la hostelería y la artesanía.  Introduce también el nº medio de días que tardas en pagar a tus proveedores de costes variables."]
[null,"En la tabla inferior obtendrás los costes variables expresados en  euros."]
[]
[]
[null,"GASTOS VARIABLES EN RELACION A LAS VENTAS (en porcentajes)"]
[null,"Producto/Servicio","Mercancía y Mat. Prima","Coste de producción","Coste de transporte","Comisiones comerciales","Comisiones bancarias","Mermas y deterioro","Otros","Coste variable total"]
[null,{"$f":"+Ingresos!B8","v":"producto o servicio 1 "},null,null,null,null,null,null,null,{"$f":"+SUM(C10:I10)","v":0}]
[null,{"$f":"+Ingresos!B9","v":"producto o servicio 2"},null,null,null,null,null,null,null,0]
[null,{"$f":"+Ingresos!B10","v":"producto o servicio 3"},null,null,null,null,null,null,null,0]
[null,{"$f":"+Ingresos!B11","v":"producto o servicio 4"},null,null,null,null,null,null,null,0]
[null,{"$f":"+Ingresos!B12","v":"producto o servicio 5"},null,null,null,null,null,null,null,0]
[null,{"$f":"+Ingresos!B13","v":"producto o servicio 6"},null,null,null,null,null,null,null,0]
[null,{"$f":"+Ingresos!B14","v":"producto o servicio 7"},null,null,null,null,null,null,null,0]
[null,{"$f":"+Ingresos!B15","v":"producto o servicio 8"},null,null,null,null,null,null,null,0]
[null,{"$f":"+Ingresos!B16","v":"producto o servicio 9"},null,null,null,null,null,null,null,0]
[null,{"$f":"+Ingresos!B17","v":"producto o servicio 10"},null,null,null,null,null,null,null,0]
[]
[null,"GASTOS VARIABLES POR  PRODUCTO O SERVICIO (en euros)"]
["IVA","MES/PRODUCTO",{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+R7>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+R7-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+R7<10,\"0\"&MONTH(Proyecto!$B$7)+R7,MONTH(Proyecto!$B$7)+R7)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+S7>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+S7-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+S7<10,\"0\"&MONTH(Proyecto!$B$7)+S7,MONTH(Proyecto!$B$7)+S7)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+T7>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+T7-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+T7<10,\"0\"&MONTH(Proyecto!$B$7)+T7,MONTH(Proyecto!$B$7)+T7)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+U7>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+U7-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+U7<10,\"0\"&MONTH(Proyecto!$B$7)+U7,MONTH(Proyecto!$B$7)+U7)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+V7>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+V7-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+V7<10,\"0\"&MONTH(Proyecto!$B$7)+V7,MONTH(Proyecto!$B$7)+V7)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+W7>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+W7-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+W7<10,\"0\"&MONTH(Proyecto!$B$7)+W7,MONTH(Proyecto!$B$7)+W7)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+X7>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+X7-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+X7<10,\"0\"&MONTH(Proyecto!$B$7)+X7,MONTH(Proyecto!$B$7)+X7)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+Y7>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+Y7-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+Y7<10,\"0\"&MONTH(Proyecto!$B$7)+Y7,MONTH(Proyecto!$B$7)+Y7)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+Z7>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+Z7-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+Z7<10,\"0\"&MONTH(Proyecto!$B$7)+Z7,MONTH(Proyecto!$B$7)+Z7)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+AA7>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+AA7-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+AA7<10,\"0\"&MONTH(Proyecto!$B$7)+AA7,MONTH(Proyecto!$B$7)+AA7)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+AB7>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+AB7-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+AB7<10,\"0\"&MONTH(Proyecto!$B$7)+AB7,MONTH(Proyecto!$B$7)+AB7)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+AC7>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+AC7-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+AC7<10,\"0\"&MONTH(Proyecto!$B$7)+AC7,MONTH(Proyecto!$B$7)+AC7)))","v":""},"Año 1","Año 2","Año 3","Año 4"]
[{"$f":"+Ingresos!P13","v":0},{"$f":"+B10","v":"producto o servicio 1 "},{"$f":"+$J10*Ingresos!R13","v":0},{"$f":"+$J$10*Ingresos!S13","v":0},{"$f":"+$J$10*Ingresos!T13","v":0},{"$f":"+$J$10*Ingresos!U13","v":0},{"$f":"+$J$10*Ingresos!V13","v":0},{"$f":"+$J$10*Ingresos!W13","v":0},{"$f":"+$J$10*Ingresos!X13","v":0},{"$f":"+$J$10*Ingresos!Y13","v":0},{"$f":"+$J$10*Ingresos!Z13","v":0},{"$f":"+$J$10*Ingresos!AA13","v":0},{"$f":"+$J$10*Ingresos!AB13","v":0},{"$f":"+$J$10*Ingresos!AC13","v":0},{"$f":"+SUM(C23:N23)","v":0},{"$f":"+O23*(1+Ingresos!$H$8)","v":0},{"$f":"+P23*(1+Ingresos!$I$8)","v":0},{"$f":"+Q23*(1+Ingresos!$J$8)","v":0}]
[{"$f":"+Ingresos!P14","v":0},"producto o servicio 2",{"$f":"+$J$11*Ingresos!R14","v":0},{"$f":"+$J$11*Ingresos!S14","v":0},{"$f":"+$J$11*Ingresos!T14","v":0},{"$f":"+$J$11*Ingresos!U14","v":0},{"$f":"+$J$11*Ingresos!V14","v":0},{"$f":"+$J$11*Ingresos!W14","v":0},{"$f":"+$J$11*Ingresos!X14","v":0},{"$f":"+$J$11*Ingresos!Y14","v":0},{"$f":"+$J$11*Ingresos!Z14","v":0},{"$f":"+$J$11*Ingresos!AA14","v":0},{"$f":"+$J$11*Ingresos!AB14","v":0},{"$f":"+$J$11*Ingresos!AC14","v":0},0,{"$f":"+O24*(1+Ingresos!$H$8)","v":0},{"$f":"+P24*(1+Ingresos!$I$8)","v":0},{"$f":"+Q24*(1+Ingresos!$J$8)","v":0}]
[{"$f":"+Ingresos!P15","v":0},"producto o servicio 3",{"$f":"+$J$12*Ingresos!R15","v":0},{"$f":"+$J$12*Ingresos!S15","v":0},{"$f":"+$J$12*Ingresos!T15","v":0},{"$f":"+$J$12*Ingresos!U15","v":0},{"$f":"+$J$12*Ingresos!V15","v":0},{"$f":"+$J$12*Ingresos!W15","v":0},{"$f":"+$J$12*Ingresos!X15","v":0},{"$f":"+$J$12*Ingresos!Y15","v":0},{"$f":"+$J$12*Ingresos!Z15","v":0},{"$f":"+$J$12*Ingresos!AA15","v":0},{"$f":"+$J$12*Ingresos!AB15","v":0},{"$f":"+$J$12*Ingresos!AC15","v":0},0,{"$f":"+O25*(1+Ingresos!$H$8)","v":0},{"$f":"+P25*(1+Ingresos!$I$8)","v":0},{"$f":"+Q25*(1+Ingresos!$J$8)","v":0}]
[{"$f":"+Ingresos!P16","v":0},"producto o servicio 4",{"$f":"+$J$13*Ingresos!R16","v":0},{"$f":"+$J$13*Ingresos!S16","v":0},{"$f":"+$J$13*Ingresos!T16","v":0},{"$f":"+$J$13*Ingresos!U16","v":0},{"$f":"+$J$13*Ingresos!V16","v":0},{"$f":"+$J$13*Ingresos!W16","v":0},{"$f":"+$J$13*Ingresos!X16","v":0},{"$f":"+$J$13*Ingresos!Y16","v":0},{"$f":"+$J$13*Ingresos!Z16","v":0},{"$f":"+$J$13*Ingresos!AA16","v":0},{"$f":"+$J$13*Ingresos!AB16","v":0},{"$f":"+$J$13*Ingresos!AC16","v":0},0,{"$f":"+O26*(1+Ingresos!$H$8)","v":0},{"$f":"+P26*(1+Ingresos!$I$8)","v":0},{"$f":"+Q26*(1+Ingresos!$J$8)","v":0}]
[{"$f":"+Ingresos!P17","v":0},"producto o servicio 5",{"$f":"+$J$14*Ingresos!R17","v":0},{"$f":"+$J$14*Ingresos!S17","v":0},{"$f":"+$J$14*Ingresos!T17","v":0},{"$f":"+$J$14*Ingresos!U17","v":0},{"$f":"+$J$14*Ingresos!V17","v":0},{"$f":"+$J$14*Ingresos!W17","v":0},{"$f":"+$J$14*Ingresos!X17","v":0},{"$f":"+$J$14*Ingresos!Y17","v":0},{"$f":"+$J$14*Ingresos!Z17","v":0},{"$f":"+$J$14*Ingresos!AA17","v":0},{"$f":"+$J$14*Ingresos!AB17","v":0},{"$f":"+$J$14*Ingresos!AC17","v":0},0,{"$f":"+O27*(1+Ingresos!$H$8)","v":0},{"$f":"+P27*(1+Ingresos!$I$8)","v":0},{"$f":"+Q27*(1+Ingresos!$J$8)","v":0}]
[{"$f":"+Ingresos!P18","v":0},"producto o servicio 6",{"$f":"+$J$15*Ingresos!R18","v":0},{"$f":"+$J$15*Ingresos!S18","v":0},{"$f":"+$J$15*Ingresos!T18","v":0},{"$f":"+$J$15*Ingresos!U18","v":0},{"$f":"+$J$15*Ingresos!V18","v":0},{"$f":"+$J$15*Ingresos!W18","v":0},{"$f":"+$J$15*Ingresos!X18","v":0},{"$f":"+$J$15*Ingresos!Y18","v":0},{"$f":"+$J$15*Ingresos!Z18","v":0},{"$f":"+$J$15*Ingresos!AA18","v":0},{"$f":"+$J$15*Ingresos!AB18","v":0},{"$f":"+$J$15*Ingresos!AC18","v":0},0,{"$f":"+O28*(1+Ingresos!$H$8)","v":0},{"$f":"+P28*(1+Ingresos!$I$8)","v":0},{"$f":"+Q28*(1+Ingresos!$J$8)","v":0}]
[{"$f":"+Ingresos!P19","v":0},"producto o servicio 7",{"$f":"+$J$16*Ingresos!R19","v":0},{"$f":"+$J$16*Ingresos!S19","v":0},{"$f":"+$J$16*Ingresos!T19","v":0},{"$f":"+$J$16*Ingresos!U19","v":0},{"$f":"+$J$16*Ingresos!V19","v":0},{"$f":"+$J$16*Ingresos!W19","v":0},{"$f":"+$J$16*Ingresos!X19","v":0},{"$f":"+$J$16*Ingresos!Y19","v":0},{"$f":"+$J$16*Ingresos!Z19","v":0},{"$f":"+$J$16*Ingresos!AA19","v":0},{"$f":"+$J$16*Ingresos!AB19","v":0},{"$f":"+$J$16*Ingresos!AC19","v":0},0,{"$f":"+O29*(1+Ingresos!$H$8)","v":0},{"$f":"+P29*(1+Ingresos!$I$8)","v":0},{"$f":"+Q29*(1+Ingresos!$J$8)","v":0}]
[{"$f":"+Ingresos!P20","v":0},"producto o servicio 8",{"$f":"+$J$17*Ingresos!R20","v":0},{"$f":"+$J$17*Ingresos!S20","v":0},{"$f":"+$J$17*Ingresos!T20","v":0},{"$f":"+$J$17*Ingresos!U20","v":0},{"$f":"+$J$17*Ingresos!V20","v":0},{"$f":"+$J$17*Ingresos!W20","v":0},{"$f":"+$J$17*Ingresos!X20","v":0},{"$f":"+$J$17*Ingresos!Y20","v":0},{"$f":"+$J$17*Ingresos!Z20","v":0},{"$f":"+$J$17*Ingresos!AA20","v":0},{"$f":"+$J$17*Ingresos!AB20","v":0},{"$f":"+$J$17*Ingresos!AC20","v":0},0,{"$f":"+O30*(1+Ingresos!$H$8)","v":0},{"$f":"+P30*(1+Ingresos!$I$8)","v":0},{"$f":"+Q30*(1+Ingresos!$J$8)","v":0}]
[{"$f":"+Ingresos!P21","v":0},"producto o servicio 9",{"$f":"+$J$18*Ingresos!R21","v":0},{"$f":"+$J$18*Ingresos!S21","v":0},{"$f":"+$J$18*Ingresos!T21","v":0},{"$f":"+$J$18*Ingresos!U21","v":0},{"$f":"+$J$18*Ingresos!V21","v":0},{"$f":"+$J$18*Ingresos!W21","v":0},{"$f":"+$J$18*Ingresos!X21","v":0},{"$f":"+$J$18*Ingresos!Y21","v":0},{"$f":"+$J$18*Ingresos!Z21","v":0},{"$f":"+$J$18*Ingresos!AA21","v":0},{"$f":"+$J$18*Ingresos!AB21","v":0},{"$f":"+$J$18*Ingresos!AC21","v":0},0,{"$f":"+O31*(1+Ingresos!$H$8)","v":0},{"$f":"+P31*(1+Ingresos!$I$8)","v":0},{"$f":"+Q31*(1+Ingresos!$J$8)","v":0}]
[{"$f":"+Ingresos!P22","v":0},"producto o servicio 10",{"$f":"+$J$19*Ingresos!R22","v":0},{"$f":"+$J$19*Ingresos!S22","v":0},{"$f":"+$J$19*Ingresos!T22","v":0},{"$f":"+$J$19*Ingresos!U22","v":0},{"$f":"+$J$19*Ingresos!V22","v":0},{"$f":"+$J$19*Ingresos!W22","v":0},{"$f":"+$J$19*Ingresos!X22","v":0},{"$f":"+$J$19*Ingresos!Y22","v":0},{"$f":"+$J$19*Ingresos!Z22","v":0},{"$f":"+$J$19*Ingresos!AA22","v":0},{"$f":"+$J$19*Ingresos!AB22","v":0},{"$f":"+$J$19*Ingresos!AC22","v":0},0,{"$f":"+O32*(1+Ingresos!$H$8)","v":0},{"$f":"+P32*(1+Ingresos!$I$8)","v":0},{"$f":"+Q32*(1+Ingresos!$J$8)","v":0}]
[null,"Total",{"$f":"+SUM(C23:C32)","v":0},{"$f":"+SUM(D23:D32)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(P23:P32)","v":0},{"$f":"+SUM(Q23:Q32)","v":0},{"$f":"+SUM(R23:R32)","v":0}]

{"sheet":"Cuenta Resultados","index":10,"n_rows":41,"n_cols":24,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[null,"CUENTA DE RESULTADOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RESUMEN"]
[]
[null,"GASTOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RESUMEN GASTOS"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% AÑO 2","% AÑO 3","% AÑO 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null," INCREMENTO SOBRE AÑO 1",null,{"$f":"+Ingresos!H8","v":0},{"$f":"+Ingresos!I8","v":0},{"$f":"+Ingresos!J8","v":0},null,"GASTOS "]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+B8>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+B8-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+B8<10,\"0\"&MONTH(Proyecto!$B$7)+B8,MONTH(Proyecto!$B$7)+B8)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+C8>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+C8-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+C8<10,\"0\"&MONTH(Proyecto!$B$7)+C8,MONTH(Proyecto!$B$7)+C8)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+D8>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+D8-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+D8<10,\"0\"&MONTH(Proyecto!$B$7)+D8,MONTH(Proyecto!$B$7)+D8)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+E8>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+E8-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+E8<10,\"0\"&MONTH(Proyecto!$B$7)+E8,MONTH(Proyecto!$B$7)+E8)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+F8>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+F8-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+F8<10,\"0\"&MONTH(Proyecto!$B$7)+F8,MONTH(Proyecto!$B$7)+F8)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+G8>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+G8-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+G8<10,\"0\"&MONTH(Proyecto!$B$7)+G8,MONTH(Proyecto!$B$7)+G8)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+H8>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+H8-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+H8<10,\"0\"&MONTH(Proyecto!$B$7)+H8,MONTH(Proyecto!$B$7)+H8)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+I8>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+I8-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+I8<10,\"0\"&MONTH(Proyecto!$B$7)+I8,MONTH(Proyecto!$B$7)+I8)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+J8>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+J8-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+J8<10,\"0\"&MONTH(Proyecto!$B$7)+J8,MONTH(Proyecto!$B$7)+J8)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+K8>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+K8-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+K8<10,\"0\"&MONTH(Proyecto!$B$7)+K8,MONTH(Proyecto!$B$7)+K8)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+L8>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+L8-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+L8<10,\"0\"&MONTH(Proyecto!$B$7)+L8,MONTH(Proyecto!$B$7)+L8)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+M8>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+M8-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+M8<10,\"0\"&MONTH(Proyecto!$B$7)+M8,MONTH(Proyecto!$B$7)+M8)))","v":""},"AÑO 1","AÑO 2","AÑO 3","AÑO 4",null,null,"AÑO 1","AÑO 2","AÑO 3","AÑO 4"]
[null,"GASTOS FIJOS",{"$f":"+'Gastos Fijos'!D36","v":0},{"$f":"+'Gastos Fijos'!E36","v":0},{"$f":"+'Gastos Fijos'!F36","v":0},{"$f":"+'Gastos Fijos'!G36","v":0},{"$f":"+'Gastos Fijos'!H36","v":0},{"$f":"+'Gastos Fijos'!I36","v":0},{"$f":"+'Gastos Fijos'!J36","v":0},{"$f":"+'Gastos Fijos'!K36","v":0},{"$f":"+'Gastos Fijos'!L36","v":0},{"$f":"+'Gastos Fijos'!M36","v":0},{"$f":"+'Gastos Fijos'!N36","v":0},{"$f":"+'Gastos Fijos'!O36","v":0},{"$f":"+SUM(C10:N10)","v":0},{"$f":"+$O10*(1+P$7)","v":0},0,0,null,"GASTOS FIJOS",{"$f":"+O$10","v":0},{"$f":"+P$10","v":0},{"$f":"+Q$10","v":0},{"$f":"+R$10","v":0}]
[null,"OTROS GASTOS",{"$f":"+'Gastos Fijos'!D44","v":0},{"$f":"+'Gastos Fijos'!E44","v":0},{"$f":"+'Gastos Fijos'!F44","v":0},{"$f":"+'Gastos Fijos'!G44","v":0},{"$f":"+'Gastos Fijos'!H44","v":0},{"$f":"+'Gastos Fijos'!I44","v":0},{"$f":"+'Gastos Fijos'!J44","v":0},{"$f":"+'Gastos Fijos'!K44","v":0},{"$f":"+'Gastos Fijos'!L44","v":0},{"$f":"+'Gastos Fijos'!M44","v":0},{"$f":"+'Gastos Fijos'!N44","v":0},{"$f":"+'Gastos Fijos'!O44","v":0},{"$f":"+'Gastos Fijos'!P44","v":0},{"$f":"+'Gastos Fijos'!Q44","v":0},{"$f":"+'Gastos Fijos'!R44","v":0},{"$f":"+'Gastos Fijos'!S44","v":0},null,"OTROS GASTOS",{"$f":"+O11","v":0},0,0,0]
[null,"GASTOS VARIABLES",{"$f":"+'Gastos Variables'!C33","v":0},{"$f":"+'Gastos Variables'!D33","v":0},{"$f":"+'Gastos Variables'!E33","v":0},{"$f":"+'Gastos Variables'!F33","v":0},{"$f":"+'Gastos Variables'!G33","v":0},{"$f":"+'Gastos Variables'!H33","v":0},{"$f":"+'Gastos Variables'!I33","v":0},{"$f":"+'Gastos Variables'!J33","v":0},{"$f":"+'Gastos Variables'!K33","v":0},{"$f":"+'Gastos Variables'!L33","v":0},{"$f":"+'Gastos Variables'!M33","v":0},{"$f":"+'Gastos Variables'!N33","v":0},{"$f":"+SUM(C12:N12)","v":0},{"$f":"+$O12*(1+P$7)","v":0},{"$f":"+$O12*(1+Q$7)","v":0},{"$f":"+$O12*(1+R$7)","v":0},null,"GASTOS VARIABLES",0,0,0,0]
[null,"TOTAL GASTOS ",{"$f":"+C10+C12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+R10+R12","v":0},null,"TOTAL",{"$f":"SUM(U10:U11)","v":0},{"$f":"SUM(V10:V11)","v":0},{"$f":"SUM(W10:W11)","v":0},{"$f":"SUM(X10:X11)","v":0}]
[]
[null,"INGRESOS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RESUMEN INGRESOS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% AÑO 2","% AÑO 3","% AÑO 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null," INCREMENTO SOBRE AÑO 1",null,{"$f":"+Ingresos!H8","v":0},{"$f":"+Ingresos!I8","v":0},{"$f":"+Ingresos!J8","v":0}]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,null,null,null,null,null,"INGRESOS    ","AÑO 1","AÑO 2","AÑO 3","AÑO 4"]
[null,null,{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+B19>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+B19-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+B19<10,\"0\"&MONTH(Proyecto!$B$7)+B19,MONTH(Proyecto!$B$7)+B19)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+C19>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+C19-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+C19<10,\"0\"&MONTH(Proyecto!$B$7)+C19,MONTH(Proyecto!$B$7)+C19)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+D19>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+D19-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+D19<10,\"0\"&MONTH(Proyecto!$B$7)+D19,MONTH(Proyecto!$B$7)+D19)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+E19>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+E19-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+E19<10,\"0\"&MONTH(Proyecto!$B$7)+E19,MONTH(Proyecto!$B$7)+E19)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+F19>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+F19-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+F19<10,\"0\"&MONTH(Proyecto!$B$7)+F19,MONTH(Proyecto!$B$7)+F19)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+G19>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+G19-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+G19<10,\"0\"&MONTH(Proyecto!$B$7)+G19,MONTH(Proyecto!$B$7)+G19)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+H19>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+H19-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+H19<10,\"0\"&MONTH(Proyecto!$B$7)+H19,MONTH(Proyecto!$B$7)+H19)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+I19>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+I19-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+I19<10,\"0\"&MONTH(Proyecto!$B$7)+I19,MONTH(Proyecto!$B$7)+I19)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+J19>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+J19-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+J19<10,\"0\"&MONTH(Proyecto!$B$7)+J19,MONTH(Proyecto!$B$7)+J19)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+K19>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+K19-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+K19<10,\"0\"&MONTH(Proyecto!$B$7)+K19,MONTH(Proyecto!$B$7)+K19)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+L19>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+L19-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+L19<10,\"0\"&MONTH(Proyecto!$B$7)+L19,MONTH(Proyecto!$B$7)+L19)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+M19>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+M19-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+M19<10,\"0\"&MONTH(Proyecto!$B$7)+M19,MONTH(Proyecto!$B$7)+M19)))","v":""},"AÑO 1","AÑO 2","AÑO 3","AÑO 4",null,"INGRESOS VENTAS",{"$f":"+O21","v":0},0,{"$f":"+Q21","v":0},{"$f":"+R21","v":0}]
[null,"INGRESOS VENTAS",{"$f":"+Ingresos!R7","v":0},{"$f":"+Ingresos!S7","v":0},{"$f":"+Ingresos!T7","v":0},{"$f":"+Ingresos!U7","v":0},{"$f":"+Ingresos!V7","v":0},{"$f":"+Ingresos!W7","v":0},{"$f":"+Ingresos!X7","v":0},{"$f":"+Ingresos!Y7","v":0},{"$f":"+Ingresos!Z7","v":0},{"$f":"+Ingresos!AA7","v":0},{"$f":"+Ingresos!AB7","v":0},{"$f":"+Ingresos!AC7","v":0},{"$f":"+SUM(C21:N21)","v":0},{"$f":"+O21*(1+$P$18)","v":0},{"$f":"+O21*(1+$Q$18)","v":0},{"$f":"+P21*(1+$R$18)","v":0},null,"OTROS INGRESOS",0,0,{"$f":"+Q22","v":0},{"$f":"+R22","v":0}]
[null,"OTROS INGRESOS",{"$f":"+Ingresos!R8","v":0},{"$f":"+Ingresos!S8","v":0},{"$f":"+Ingresos!T8","v":0},{"$f":"+Ingresos!U8","v":0},{"$f":"+Ingresos!V8","v":0},{"$f":"+Ingresos!W8","v":0},{"$f":"+Ingresos!X8","v":0},{"$f":"+Ingresos!Y8","v":0},{"$f":"+Ingresos!Z8","v":0},{"$f":"+Ingresos!AA8","v":0},{"$f":"+Ingresos!AB8","v":0},{"$f":"+Ingresos!AC8","v":0},{"$f":"+SUM(C22:N22)","v":0},{"$f":"+O22*(1+$P$18)","v":0},{"$f":"+O22*(1+$Q$18)","v":0},{"$f":"+P22*(1+$R$18)","v":0},null,"TOTAL",{"$f":"SUM(U19:U21)","v":0},{"$f":"SUM(V19:V21)","v":0},{"$f":"SUM(W19:W21)","v":0},{"$f":"SUM(X19:X21)","v":0}]
[null,"TOTAL INGRESOS",{"$f":"+C21+C22","v":0},{"$f":"+D21+D22","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(C23:N23)","v":0},{"$f":"+P21+P22","v":0},0,{"$f":"+R21+R22","v":0}]
[]
[]
[]
[null,"CUENTA DE RESULTADOS"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,null,null,null,null,null,"CUENTA DE PÉRDIDAS Y GANANCIAS"]
[null,null,{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+B28>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+B28-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+B28<10,\"0\"&MONTH(Proyecto!$B$7)+B28,MONTH(Proyecto!$B$7)+B28)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+C28>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+C28-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+C28<10,\"0\"&MONTH(Proyecto!$B$7)+C28,MONTH(Proyecto!$B$7)+C28)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+D28>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+D28-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+D28<10,\"0\"&MONTH(Proyecto!$B$7)+D28,MONTH(Proyecto!$B$7)+D28)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+E28>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+E28-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+E28<10,\"0\"&MONTH(Proyecto!$B$7)+E28,MONTH(Proyecto!$B$7)+E28)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+F28>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+F28-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+F28<10,\"0\"&MONTH(Proyecto!$B$7)+F28,MONTH(Proyecto!$B$7)+F28)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+G28>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+G28-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+G28<10,\"0\"&MONTH(Proyecto!$B$7)+G28,MONTH(Proyecto!$B$7)+G28)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+H28>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+H28-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+H28<10,\"0\"&MONTH(Proyecto!$B$7)+H28,MONTH(Proyecto!$B$7)+H28)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+I28>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+I28-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+I28<10,\"0\"&MONTH(Proyecto!$B$7)+I28,MONTH(Proyecto!$B$7)+I28)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+J28>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+J28-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+J28<10,\"0\"&MONTH(Proyecto!$B$7)+J28,MONTH(Proyecto!$B$7)+J28)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+K28>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+K28-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+K28<10,\"0\"&MONTH(Proyecto!$B$7)+K28,MONTH(Proyecto!$B$7)+K28)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+L28>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+L28-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+L28<10,\"0\"&MONTH(Proyecto!$B$7)+L28,MONTH(Proyecto!$B$7)+L28)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+M28>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+M28-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+M28<10,\"0\"&MONTH(Proyecto!$B$7)+M28,MONTH(Proyecto!$B$7)+M28)))","v":""},"AÑO 1","AÑO 2","AÑO 3","AÑO 4"]
[null,"INGRESOS POR VENTAS",{"$f":"+C21","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+R21","v":0},null,"PERDIDAS Y GANANCIAS","AÑO 1","AÑO 2","AÑO 3","AÑO 4"]
[null,"GASTOS VARIABLES",{"$f":"+C12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+R12","v":0},null,"MARGEN BRUTO",{"$f":"+O32","v":0},{"$f":"+P32","v":0},{"$f":"+Q32","v":0},{"$f":"+R32","v":0}]
[null,"MARGEN BRUTO",{"$f":"C30-C31","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"R30-R31","v":0},null,"EBITDA",{"$f":"+O35","v":0},{"$f":"+P35","v":0},{"$f":"+Q35","v":0},{"$f":"+R35","v":0}]
[null,"OTROS INGRESOS",{"$f":"+C22","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+R22","v":0},null,"BAI",{"$f":"+O37","v":0},{"$f":"+P37","v":0},{"$f":"+Q37","v":0},{"$f":"+R37","v":0}]
[null,"GASTOS FIJOS",{"$f":"+C$10","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"RESULTADO",{"$f":"+O39","v":0},{"$f":"+P39","v":0},{"$f":"+Q39","v":0},{"$f":"+R39","v":0}]
[null,"EBITDA",{"$f":"C32+C33-C34","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"R32+R33-R34","v":0}]
[null,"OTROS GASTOS",{"$f":"+C11","v":0},{"$f":"+D11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+R11","v":0}]
[null,"BAI",{"$f":"+C35-C36","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+R35-R36","v":0}]
[null,"IMPUESTO S/ BENEFICIOS (según % indicado en pestaña \"proyecto\") ",{"$f":"+IF(C37<0,0,C37*(Proyecto!$F$35))","v":0},{"$f":"+IF(D37<0,0,D37*(Proyecto!$F$35))","v":0},{"$f":"+IF(E37<0,0,E37*(Proyecto!$F$35))","v":0},{"$f":"+IF(F37<0,0,F37*(Proyecto!$F$35))","v":0},{"$f":"+IF(G37<0,0,G37*(Proyecto!$F$35))","v":0},{"$f":"+IF(H37<0,0,H37*(Proyecto!$F$35))","v":0},{"$f":"+IF(I37<0,0,I37*(Proyecto!$F$35))","v":0},{"$f":"+IF(J37<0,0,J37*(Proyecto!$F$35))","v":0},{"$f":"+IF(K37<0,0,K37*(Proyecto!$F$35))","v":0},{"$f":"+IF(L37<0,0,L37*(Proyecto!$F$35))","v":0},{"$f":"+IF(M37<0,0,M37*(Proyecto!$F$35))","v":0},{"$f":"+IF(N37<0,0,N37*(Proyecto!$F$35))","v":0},{"$f":"+IF(O37<0,0,O37*0.25)","v":0},0,0,{"$f":"+IF(R37<0,0,R37*0.25)","v":0}]
[null,"RESULTADO",{"$f":"+C37-C38","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+R37-R38","v":0}]
[]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12]

{"sheet":"6.UMBRAL RENTABILIDAD","index":11,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":true,"merged":[[31,2,31,6],[28,2,28,6],[29,2,29,6],[30,2,30,6],[0,2,1,8],[7,2,7,6],[8,2,8,6],[4,2,4,6],[5,2,5,6],[6,2,6,6]]}
[null,null,"Umbral de rentabilidad o punto de equilibrio"]
["OPCIÓN A"]
["PRECIO"]
[]
["Gastos variables mensuales",{"$f":"#REF!","v":{"$error":"#REF!"}},"dado de los gastos variables mensuales"]
["Gastos fijos mensuales",{"$f":"#REF!","v":{"$error":"#REF!"}},"dado de los gastos fijos mensuales"]
["Precio medio",{"$f":"+D17","v":0},"precio medio ponderado"]
["URENTABILIDAD",{"$f":"(B5+B6)/B7","v":{"$error":"#REF!"}},"numero de unidades que tengo que vender al mes para que mi negocio sea rentable"]
["URENTABILIDAD dia",{"$f":"B8/24","v":{"$error":"#REF!"}},"numero de unidades que tengo que vender al dia para que mi negocio sea rentable, considerendo mes comercial son 21 dias "]
[]
["CONCEPTO","PRECIO","PONDERACIONES","PRECIO MEDIO PONDERADO"]
["producto/servicio 1"]
["producto/servicio 2"]
["producto/servicio 3"]
["producto/servicio 4"]
["producto/servicio 5"]
[null,{"$f":"SUM(B12:B16)","v":0},{"$f":"SUM(C12:C16)","v":0},{"$f":"SUM(D12:D16)","v":0}]
[]
["OPCION B"]
["PRECIO"]
[]
["COSTE VARIABLE UNITARIO","GASTOS VARIABLES/UNIDADES"]
["x","CF/(P-CVU)"]
[]
[]
["OPCIÓN C"]
["INGRESOS"]
[]
["Gastos variables mensuales",{"$f":"#REF!","v":{"$error":"#REF!"}},"dado de los gastos variables mensuales"]
["Gastos fijos mensuales",{"$f":"#REF!","v":{"$error":"#REF!"}},"dado de los gastos fijos mensuales"]
["Precio medio",{"$f":"+H35","v":0},"precio medio ponderado"]
["URENTABILIDAD",{"$f":"+(B29+B30)","v":{"$error":"#REF!"}},"euros que tengo que ingresar  al mes para que mi negocio sea rentable"]
["URENTABILIDAD dia",{"$f":"+B32/21","v":{"$error":"#REF!"}},"euros que tengo que ingresar  al dia para que mi negocio sea rentable, considerendo mes comercial son 21 dias "]

{"sheet":"Liquidacion Impuestos","index":12,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[null,"LIQUIDACION IMPUESTOS"]
[]
[]
[]
[]
[null,"IVA"]
[]
[null,"IVA REPERCUTIDO",{"$f":"+'Cuenta Resultados'!C9","v":""},{"$f":"+'Cuenta Resultados'!D9","v":""},{"$f":"+'Cuenta Resultados'!E9","v":""},{"$f":"+'Cuenta Resultados'!F9","v":""},{"$f":"+'Cuenta Resultados'!G9","v":""},{"$f":"+'Cuenta Resultados'!H9","v":""},{"$f":"+'Cuenta Resultados'!I9","v":""},{"$f":"+'Cuenta Resultados'!J9","v":""},{"$f":"+'Cuenta Resultados'!K9","v":""},{"$f":"+'Cuenta Resultados'!L9","v":""},{"$f":"+'Cuenta Resultados'!M9","v":""},{"$f":"+'Cuenta Resultados'!N9","v":""},"TOTAL"]
[null,"IVA GASTOS FIJOS",{"$f":"+'Gastos Fijos'!D33","v":0},{"$f":"+'Gastos Fijos'!E33","v":0},{"$f":"+'Gastos Fijos'!F33","v":0},{"$f":"+'Gastos Fijos'!G33","v":0},{"$f":"+'Gastos Fijos'!H33","v":0},{"$f":"+'Gastos Fijos'!I33","v":0},{"$f":"+'Gastos Fijos'!J33","v":0},{"$f":"+'Gastos Fijos'!K33","v":0},{"$f":"+'Gastos Fijos'!L33","v":0},{"$f":"+'Gastos Fijos'!M33","v":0},{"$f":"+'Gastos Fijos'!N33","v":0},{"$f":"+'Gastos Fijos'!O33","v":0},{"$f":"+SUM(C9:N9)","v":0}]
[null,"IVA GASTOS VARIABLES ",{"$f":"+SUMPRODUCT('Gastos Variables'!$A$23:$A$32,'Gastos Variables'!C23:C32)","v":0},{"$f":"+SUMPRODUCT('Gastos Variables'!$A$23:$A$32,'Gastos Variables'!D23:D32)","v":0},{"$f":"+SUMPRODUCT('Gastos Variables'!$A$23:$A$32,'Gastos Variables'!E23:E32)","v":0},{"$f":"+SUMPRODUCT('Gastos Variables'!$A$23:$A$32,'Gastos Variables'!F23:F32)","v":0},{"$f":"+SUMPRODUCT('Gastos Variables'!$A$23:$A$32,'Gastos Variables'!G23:G32)","v":0},{"$f":"+SUMPRODUCT('Gastos Variables'!$A$23:$A$32,'Gastos Variables'!H23:H32)","v":0},{"$f":"+SUMPRODUCT('Gastos Variables'!$A$23:$A$32,'Gastos Variables'!I23:I32)","v":0},{"$f":"+SUMPRODUCT('Gastos Variables'!$A$23:$A$32,'Gastos Variables'!J23:J32)","v":0},{"$f":"+SUMPRODUCT('Gastos Variables'!$A$23:$A$32,'Gastos Variables'!K23:K32)","v":0},{"$f":"+SUMPRODUCT('Gastos Variables'!$A$23:$A$32,'Gastos Variables'!L23:L32)","v":0},{"$f":"+SUMPRODUCT('Gastos Variables'!$A$23:$A$32,'Gastos Variables'!M23:M32)","v":0},{"$f":"+SUMPRODUCT('Gastos Variables'!$A$23:$A$32,'Gastos Variables'!N23:N32)","v":0},{"$f":"+SUM(C10:N10)","v":0}]
[null,"IVA OTROS GASTOS ",{"$f":"+'Gastos Fijos'!$C$43*'Gastos Fijos'!D43","v":0},{"$f":"+'Gastos Fijos'!$C$43*'Gastos Fijos'!E43","v":0},{"$f":"+'Gastos Fijos'!$C$43*'Gastos Fijos'!F43","v":0},{"$f":"+'Gastos Fijos'!$C$43*'Gastos Fijos'!G43","v":0},{"$f":"+'Gastos Fijos'!$C$43*'Gastos Fijos'!H43","v":0},{"$f":"+'Gastos Fijos'!$C$43*'Gastos Fijos'!I43","v":0},{"$f":"+'Gastos Fijos'!$C$43*'Gastos Fijos'!J43","v":0},{"$f":"+'Gastos Fijos'!$C$43*'Gastos Fijos'!K43","v":0},{"$f":"+'Gastos Fijos'!$C$43*'Gastos Fijos'!L43","v":0},{"$f":"+'Gastos Fijos'!$C$43*'Gastos Fijos'!M43","v":0},{"$f":"+'Gastos Fijos'!$C$43*'Gastos Fijos'!N43","v":0},{"$f":"+'Gastos Fijos'!$C$43*'Gastos Fijos'!O43","v":0}]
[]
[null,"IVA DEVENGADO",{"$f":"+C8","v":""},{"$f":"+D8","v":""},"","","","","","","","","","","TOTAL"]
[null,"IVA INGRESOS ",{"$f":"+SUMPRODUCT(Ingresos!$P$13:$P$22*Ingresos!R13:R22)","v":0},{"$f":"+SUMPRODUCT(Ingresos!$P$13:$P$22*Ingresos!S13:S22)","v":0},{"$f":"+SUMPRODUCT(Ingresos!$P$13:$P$22*Ingresos!T13:T22)","v":0},{"$f":"+SUMPRODUCT(Ingresos!$P$13:$P$22*Ingresos!U13:U22)","v":0},{"$f":"+SUMPRODUCT(Ingresos!$P$13:$P$22*Ingresos!V13:V22)","v":0},{"$f":"+SUMPRODUCT(Ingresos!$P$13:$P$22*Ingresos!W13:W22)","v":0},{"$f":"+SUMPRODUCT(Ingresos!$P$13:$P$22*Ingresos!X13:X22)","v":0},{"$f":"+SUMPRODUCT(Ingresos!$P$13:$P$22*Ingresos!Y13:Y22)","v":0},{"$f":"+SUMPRODUCT(Ingresos!$P$13:$P$22*Ingresos!Z13:Z22)","v":0},{"$f":"+SUMPRODUCT(Ingresos!$P$13:$P$22*Ingresos!AA13:AA22)","v":0},{"$f":"+SUMPRODUCT(Ingresos!$P$13:$P$22*Ingresos!AB13:AB22)","v":0},{"$f":"+SUMPRODUCT(Ingresos!$P$13:$P$22*Ingresos!AC13:AC22)","v":0},{"$f":"+SUM(C14:N14)","v":0}]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,"LIQUIDACIÓN IVA",{"$f":"+C13","v":""},{"$f":"+D13","v":""},"","","","","","","","","","","TOTAL"]
[null,"LIQUIDACIÓN IVA ",{"$f":"+C14-C$9-C10","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(C17:N17)","v":0}]
[]
[]
[null,"RETENCIONES IRPF"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null," RETENCIONES IRPF",{"$f":"+C16","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+C21>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+C21-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+C21<10,\"0\"&MONTH(Proyecto!$B$7)+C21,MONTH(Proyecto!$B$7)+C21)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+D21>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+D21-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+D21<10,\"0\"&MONTH(Proyecto!$B$7)+D21,MONTH(Proyecto!$B$7)+D21)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+E21>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+E21-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+E21<10,\"0\"&MONTH(Proyecto!$B$7)+E21,MONTH(Proyecto!$B$7)+E21)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+F21>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+F21-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+F21<10,\"0\"&MONTH(Proyecto!$B$7)+F21,MONTH(Proyecto!$B$7)+F21)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+G21>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+G21-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+G21<10,\"0\"&MONTH(Proyecto!$B$7)+G21,MONTH(Proyecto!$B$7)+G21)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+H21>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+H21-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+H21<10,\"0\"&MONTH(Proyecto!$B$7)+H21,MONTH(Proyecto!$B$7)+H21)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+I21>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+I21-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+I21<10,\"0\"&MONTH(Proyecto!$B$7)+I21,MONTH(Proyecto!$B$7)+I21)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+J21>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+J21-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+J21<10,\"0\"&MONTH(Proyecto!$B$7)+J21,MONTH(Proyecto!$B$7)+J21)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+K21>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+K21-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+K21<10,\"0\"&MONTH(Proyecto!$B$7)+K21,MONTH(Proyecto!$B$7)+K21)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+L21>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+L21-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+L21<10,\"0\"&MONTH(Proyecto!$B$7)+L21,MONTH(Proyecto!$B$7)+L21)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+M21>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+M21-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+M21<10,\"0\"&MONTH(Proyecto!$B$7)+M21,MONTH(Proyecto!$B$7)+M21)))","v":""},"TOTAL"]
[null,"RETENCIONES IRPF ",{"$f":"+'Gastos Fijos'!D25","v":0},{"$f":"+'Gastos Fijos'!E25","v":0},{"$f":"+'Gastos Fijos'!F25","v":0},{"$f":"+'Gastos Fijos'!G25","v":0},{"$f":"+'Gastos Fijos'!H25","v":0},{"$f":"+'Gastos Fijos'!I25","v":0},{"$f":"+'Gastos Fijos'!J25","v":0},{"$f":"+'Gastos Fijos'!K25","v":0},{"$f":"+'Gastos Fijos'!L25","v":0},{"$f":"+'Gastos Fijos'!M25","v":0},{"$f":"+'Gastos Fijos'!N25","v":0},{"$f":"+'Gastos Fijos'!O25","v":0},{"$f":"+SUM(C23:N23)","v":0}]
[]
[]
[null,"IMPUESTO BENEFICIOS (IRPF o IS)"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,"IMPUESTO BENEFICIOS (IRPF o IS)",{"$f":"+C22","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+C27>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+C27-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+C27<10,\"0\"&MONTH(Proyecto!$B$7)+C27,MONTH(Proyecto!$B$7)+C27)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+D27>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+D27-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+D27<10,\"0\"&MONTH(Proyecto!$B$7)+D27,MONTH(Proyecto!$B$7)+D27)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+E27>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+E27-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+E27<10,\"0\"&MONTH(Proyecto!$B$7)+E27,MONTH(Proyecto!$B$7)+E27)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+F27>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+F27-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+F27<10,\"0\"&MONTH(Proyecto!$B$7)+F27,MONTH(Proyecto!$B$7)+F27)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+G27>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+G27-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+G27<10,\"0\"&MONTH(Proyecto!$B$7)+G27,MONTH(Proyecto!$B$7)+G27)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+H27>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+H27-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+H27<10,\"0\"&MONTH(Proyecto!$B$7)+H27,MONTH(Proyecto!$B$7)+H27)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+I27>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+I27-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+I27<10,\"0\"&MONTH(Proyecto!$B$7)+I27,MONTH(Proyecto!$B$7)+I27)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+J27>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+J27-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+J27<10,\"0\"&MONTH(Proyecto!$B$7)+J27,MONTH(Proyecto!$B$7)+J27)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+K27>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+K27-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+K27<10,\"0\"&MONTH(Proyecto!$B$7)+K27,MONTH(Proyecto!$B$7)+K27)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+L27>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+L27-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+L27<10,\"0\"&MONTH(Proyecto!$B$7)+L27,MONTH(Proyecto!$B$7)+L27)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+M27>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+M27-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+M27<10,\"0\"&MONTH(Proyecto!$B$7)+M27,MONTH(Proyecto!$B$7)+M27)))","v":""},"TOTAL"]
[null,"IMPUESTO BENEFICIOS (IRPF o IS)",{"$f":"+'Cuenta Resultados'!C38","v":0},{"$f":"+'Cuenta Resultados'!D38","v":0},{"$f":"+'Cuenta Resultados'!E38","v":0},{"$f":"+'Cuenta Resultados'!F38","v":0},{"$f":"+'Cuenta Resultados'!G38","v":0},{"$f":"+'Cuenta Resultados'!H38","v":0},{"$f":"+'Cuenta Resultados'!I38","v":0},{"$f":"+'Cuenta Resultados'!J38","v":0},{"$f":"+'Cuenta Resultados'!K38","v":0},{"$f":"+'Cuenta Resultados'!L38","v":0},{"$f":"+'Cuenta Resultados'!M38","v":0},{"$f":"+'Cuenta Resultados'!N38","v":0},{"$f":"+SUM(C29:N29)","v":0}]
[]
[]
[null,"LIQUIDACIÓN IVA e IRPF e IMPUESTO SOBRE BENEFICIOS"]
[]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,"PAGOS IVA",{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+B34>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+B34-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+B34<10,\"0\"&MONTH(Proyecto!$B$7)+B34,MONTH(Proyecto!$B$7)+B34)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+C34>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+C34-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+C34<10,\"0\"&MONTH(Proyecto!$B$7)+C34,MONTH(Proyecto!$B$7)+C34)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+D34>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+D34-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+D34<10,\"0\"&MONTH(Proyecto!$B$7)+D34,MONTH(Proyecto!$B$7)+D34)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+E34>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+E34-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+E34<10,\"0\"&MONTH(Proyecto!$B$7)+E34,MONTH(Proyecto!$B$7)+E34)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+F34>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+F34-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+F34<10,\"0\"&MONTH(Proyecto!$B$7)+F34,MONTH(Proyecto!$B$7)+F34)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+G34>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+G34-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+G34<10,\"0\"&MONTH(Proyecto!$B$7)+G34,MONTH(Proyecto!$B$7)+G34)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+H34>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+H34-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+H34<10,\"0\"&MONTH(Proyecto!$B$7)+H34,MONTH(Proyecto!$B$7)+H34)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+I34>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+I34-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+I34<10,\"0\"&MONTH(Proyecto!$B$7)+I34,MONTH(Proyecto!$B$7)+I34)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+J34>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+J34-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+J34<10,\"0\"&MONTH(Proyecto!$B$7)+J34,MONTH(Proyecto!$B$7)+J34)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+K34>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+K34-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+K34<10,\"0\"&MONTH(Proyecto!$B$7)+K34,MONTH(Proyecto!$B$7)+K34)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+L34>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+L34-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+L34<10,\"0\"&MONTH(Proyecto!$B$7)+L34,MONTH(Proyecto!$B$7)+L34)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+M34>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+M34-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+M34<10,\"0\"&MONTH(Proyecto!$B$7)+M34,MONTH(Proyecto!$B$7)+M34)))","v":""},"TOTAL"]
[null,"LIQUIDACIÓN IVA ",null,{"$f":"+IF(RIGHT(D$35,2)=\"01\",C17,IF(RIGHT(D$35,2)=\"04\",C17,IF(RIGHT(D$35,2)=\"07\",C17,IF(RIGHT(D$35,2)=\"10\",C17,0))))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(C36:N36)","v":0}]
[]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,"PAGOS RETENCIONES IRPF",{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+B38>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+B38-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+B38<10,\"0\"&MONTH(Proyecto!$B$7)+B38,MONTH(Proyecto!$B$7)+B38)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+C38>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+C38-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+C38<10,\"0\"&MONTH(Proyecto!$B$7)+C38,MONTH(Proyecto!$B$7)+C38)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+D38>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+D38-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+D38<10,\"0\"&MONTH(Proyecto!$B$7)+D38,MONTH(Proyecto!$B$7)+D38)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+E38>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+E38-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+E38<10,\"0\"&MONTH(Proyecto!$B$7)+E38,MONTH(Proyecto!$B$7)+E38)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+F38>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+F38-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+F38<10,\"0\"&MONTH(Proyecto!$B$7)+F38,MONTH(Proyecto!$B$7)+F38)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+G38>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+G38-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+G38<10,\"0\"&MONTH(Proyecto!$B$7)+G38,MONTH(Proyecto!$B$7)+G38)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+H38>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+H38-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+H38<10,\"0\"&MONTH(Proyecto!$B$7)+H38,MONTH(Proyecto!$B$7)+H38)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+I38>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+I38-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+I38<10,\"0\"&MONTH(Proyecto!$B$7)+I38,MONTH(Proyecto!$B$7)+I38)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+J38>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+J38-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+J38<10,\"0\"&MONTH(Proyecto!$B$7)+J38,MONTH(Proyecto!$B$7)+J38)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+K38>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+K38-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+K38<10,\"0\"&MONTH(Proyecto!$B$7)+K38,MONTH(Proyecto!$B$7)+K38)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+L38>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+L38-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+L38<10,\"0\"&MONTH(Proyecto!$B$7)+L38,MONTH(Proyecto!$B$7)+L38)))","v":""},{"$f":"+IF(Proyecto!$B$7=\"\",\"\",IF(MONTH(Proyecto!$B$7)+M38>12,YEAR(Proyecto!$B$7)+1&\"0\"& (MONTH(Proyecto!$B$7)+M38-12),YEAR(Proyecto!$B$7)&IF(MONTH(Proyecto!$B$7)+M38<10,\"0\"&MONTH(Proyecto!$B$7)+M38,MONTH(Proyecto!$B$7)+M38)))","v":""},"TOTAL"]
[null,"PAGOS RETENCIONES IRPF",null,{"$f":"+IF(RIGHT(D39,2)=\"01\",C23,IF(RIGHT(D39,2)=\"04\",C23,IF(RIGHT(D39,2)=\"07\",C23,IF(RIGHT(D39,2)=\"10\",C23,0))))","v":0},{"$f":"+IF(RIGHT(E39,2)=\"01\",C23+D23,IF(RIGHT(E39,2)=\"04\",C23+D23,IF(RIGHT(E39,2)=\"07\",C23+D23,IF(RIGHT(E39,2)=\"10\",C23+D23,0))))","v":0},{"$f":"+IF(RIGHT(F39,2)=\"01\",C23+D23+E23,IF(RIGHT(F39,2)=\"04\",C23+D23+E23,IF(RIGHT(F39,2)=\"07\",C23+D23+E23,IF(RIGHT(F39,2)=\"10\",C23+D23+E23,0))))","v":0},0,0,0,0,0,0,0,0,{"$f":"+SUM(C40:N40)","v":0}]
[]
[null,"IMPUESTO BENEFICIOS (IRPF o IS)",{"$f":"+C39","v":""},{"$f":"+D39","v":""},{"$f":"+E39","v":""},"","","","","","","","","","TOTAL"]
[null,"IMPUESTO BENEFICIOS (IRPF o IS)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(C29:N29)","v":0},{"$f":"+SUM(C43:N43)","v":0}]

{"sheet":"Hoja2","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Balance de Situacion","index":14,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["BALANCE DE SITUACIÓN",null,null,null,null,null,null,null,"RATIOS ECONÓMICOS Y FINANCIEROS"]
[]
[]
[]
[]
["ACTIVO","INICIAL","AÑO 1","AÑO 2","AÑO 3","AÑO 4",null,null,"RATIOS FINANCIEROS","Inicial","AÑO 1","AÑO 2","AÑO 3","AÑO 4",null,"COMENTARIOS A LA EVOLUCIÓN"]
[null,null,null,null,null,null,null,null,"GARANTIA",{"$f":"+IFERROR(B17/(B25+B29),0)","v":0},{"$f":"+IFERROR(B17/(B25+B29),0)","v":0},{"$f":"+IFERROR(C17/(C25+C29),0)","v":0},{"$f":"+IFERROR(D17/(D25+D29),0)","v":0},{"$f":"+IFERROR(E17/(E25+E29),0)","v":0},null,"Crecimiento del ratio de garantía para los tres años previstos."]
["ACTIVO NO CORRIENTE ",{"$f":"+SUM(B9:B11)","v":0},{"$f":"+SUM(C9:C11)","v":0},{"$f":"+SUM(D9:D11)","v":0},{"$f":"+SUM(E9:E11)","v":0},{"$f":"+SUM(F9:F11)","v":0},null,null,"LIQUIDEZ",{"$f":"+IFERROR(B12/B29,0)","v":0},{"$f":"+IFERROR(B12/B29,0)","v":0},{"$f":"+IFERROR(C12/C29,0)","v":0},{"$f":"+IFERROR(D12/D29,0)","v":0},{"$f":"+IFERROR(E12/E29,0)","v":0},null,"Crecimiento del ratio de liquidez para los tres años previstos."]
["Inmovilizado Material",{"$f":"+SUM('Inversion Inicial'!D15:D22)+SUM('Inversion Inicial'!D11:D13)","v":0},{"$f":"+B9+SUM('Inversion Inicial'!F15:F22)","v":0},{"$f":"+C9+SUM('Inversion Inicial'!G15:G22)","v":0},{"$f":"+D9+SUM('Inversion Inicial'!H15:H22)","v":0},{"$f":"+E9+SUM('Inversion Inicial'!I15:I22)","v":0},null,null,"TESORERÍA",{"$f":"+IFERROR(B15/B29,0)","v":0},{"$f":"+IFERROR(B15/B29,0)","v":0},{"$f":"+IFERROR(C15/C29,0)","v":0},{"$f":"+IFERROR(D15/D29,0)","v":0},{"$f":"+IFERROR(E15/E29,0)","v":0},null,"Crecimiento del ratio de tesorería para los tres años previstos."]
["Inmovilizado Inmaterial",{"$f":"+'Inversion Inicial'!D23+'Inversion Inicial'!D24+'Inversion Inicial'!D8+'Inversion Inicial'!D9+'Inversion Inicial'!D10","v":0},{"$f":"+B10+'Inversion Inicial'!F23+'Inversion Inicial'!F24","v":0},{"$f":"+C10+'Inversion Inicial'!G23+'Inversion Inicial'!G24","v":0},{"$f":"+D10+'Inversion Inicial'!H23+'Inversion Inicial'!H24","v":0},{"$f":"+E10+'Inversion Inicial'!I23+'Inversion Inicial'!I24","v":0},null,null,"ENDEUDAMIENTO",{"$f":"+IFERROR((B25+B29)/B35,0)","v":0},{"$f":"+IFERROR((B25+B29)/B35,0)","v":0},{"$f":"+IFERROR((C25+C29)/C35,0)","v":0},{"$f":"+IFERROR((D25+D29)/D35,0)","v":0},{"$f":"+IFERROR((E25+E29)/E35,0)","v":0},null,"Disminución del ratio de endeudamiento para los tres años previstos."]
["Inmovilizado Financiero",{"$f":"+'Inversion Inicial'!D25","v":0},{"$f":"+B11","v":0},{"$f":"+C11","v":0},{"$f":"+D11","v":0},{"$f":"+E11","v":0},null,null,"AUTONOMÍA FINANCIERA ",{"$f":"+IFERROR(B21/(B25+B29),0)","v":0},{"$f":"+IFERROR(B21/(B25+B29),0)","v":0},{"$f":"+IFERROR(C21/(C25+C29),0)","v":0},{"$f":"+IFERROR(D21/(D25+D29),0)","v":0},{"$f":"+IFERROR(E21/(E25+E29),0)","v":0},null,"Incremento de la autonomia financiera para los tres años previstos."]
["ACTIVO CORRIENTE",{"$f":"+SUM(B13:B15)","v":0},{"$f":"+SUM(C13:C15)","v":0},0,0,{"$f":"+SUM(F13:F15)","v":0},null,null,"FONDO DE MANIOBRA",{"$f":"+B12-B29","v":0},{"$f":"+C12-C29","v":0},{"$f":"+D12-D29","v":0},{"$f":"+E12-E29","v":0},{"$f":"+F12-F29","v":0},null,"Aumento del fondo de maniobra en los tres años previstos."]
["Existencias",{"$f":"+'Inversion Inicial'!D28","v":0},{"$f":"+B13","v":0},{"$f":"+C13","v":0},{"$f":"+D13","v":0},{"$f":"+E13","v":0}]
["Deudores",{"$f":"+'Inversion Inicial'!D29++'Inversion Inicial'!D30+'Inversion Inicial'!D31","v":0},{"$f":"+B14","v":0},{"$f":"+B14","v":0},{"$f":"+B14","v":0},{"$f":"+C14","v":0}]
["Efectivo",{"$f":"+'Inversion Inicial'!D32","v":0},{"$f":"+B15","v":0},{"$f":"+C15","v":0},{"$f":"+C15","v":0},{"$f":"+D15","v":0}]
[]
["TOTAL ACTIVO",{"$f":"+B8+B12","v":0},{"$f":"+C8+C12","v":0},{"$f":"+D8+D12","v":0},{"$f":"+E8+E12","v":0},{"$f":"+F8+F12","v":0}]
[]
["PASIVO","INICIAL","AÑO 1","AÑO 2","AÑO 3","AÑO 4"]
[]
["PATRIMONIO NETO",{"$f":"+SUM(B22:B24)","v":0},{"$f":"+SUM(C22:C24)","v":0},{"$f":"+SUM(D22:D24)","v":0},0,{"$f":"+SUM(F22:F24)","v":0}]
["Fondos Propios",{"$f":"+Financiacion!C9","v":0},{"$f":"+B22","v":0},{"$f":"+C22","v":0},{"$f":"+D22","v":0},{"$f":"+E22","v":0}]
["Resultado del ejercicio",null,{"$f":"+'Cuenta Resultados'!U34","v":0},{"$f":"+'Cuenta Resultados'!V34","v":0},{"$f":"+'Cuenta Resultados'!X34","v":0},{"$f":"+'Cuenta Resultados'!Y34","v":0}]
["Resultados de ejercicios anteriores",null,null,{"$f":"+C23","v":0},{"$f":"+D23","v":0},{"$f":"+E23","v":0}]
["PASIVO NO CORRIENTE",{"$f":"+SUM(B26:B27)","v":0},{"$f":"+SUM(C26:C27)","v":0},{"$f":"+SUM(D26:D27)","v":0},0,{"$f":"+SUM(F26:F27)","v":0},null,null,"RATIOS ECONÓMICOS","AÑO 1","AÑO 2","AÑO 3","AÑO 4","COMENTARIOS A LA EVOLUCIÓN"]
["Deudas con entidades de crédito a largo plazo",{"$f":"+Financiacion!C16","v":0},{"$f":"+IFERROR(Financiacion!C16-Financiacion!G13-Financiacion!G14,0)","v":0},{"$f":"+IFERROR(C26-Financiacion!H13-Financiacion!H14,0)","v":0},{"$f":"+IFERROR(D26-Financiacion!I13-Financiacion!I14,0)","v":0},{"$f":"+IFERROR(E26-Financiacion!J13-Financiacion!J14,0)","v":0},null,null,"RENTABILIDAD ECONÓMICA",{"$f":"+IFERROR('Cuenta Resultados'!O35/C17,0)","v":0},{"$f":"+IFERROR('Cuenta Resultados'!P35/D17,0)","v":0},{"$f":"+IFERROR('Cuenta Resultados'!Q35/E17,0)","v":0},{"$f":"+IFERROR('Cuenta Resultados'!R35/F17,0)","v":0},"Crecimiento del ratio Rentabilidad Económica durante los cuatro años previstos."]
["Otras deudas a largo plazo",{"$f":"+Financiacion!C17","v":0},{"$f":"+B27","v":0},{"$f":"+B27","v":0},{"$f":"+B27","v":0},{"$f":"+C27","v":0},null,null,"RENTABILIDAD FINANCIERA",{"$f":"+IFERROR('Cuenta Resultados'!O35/C25,0)","v":0},{"$f":"+IFERROR('Cuenta Resultados'!P35/D25,0)","v":0},{"$f":"+IFERROR('Cuenta Resultados'!Q35/E25,0)","v":0},{"$f":"+IFERROR('Cuenta Resultados'!R35/F25,0)","v":0},"Crecimiento del ratio Rentabilidad Financiera durante los cuatro años previstos."]
["Otro a largo plazo ",{"$f":"+Financiacion!C18","v":0},{"$f":"+B28","v":0},{"$f":"+B28","v":0},{"$f":"+B28","v":0},{"$f":"+C28","v":0},null,null,"PUNTO DE EQUILIBRIO",{"$f":"+IFERROR('Cuenta Resultados'!O34/(1-('Cuenta Resultados'!O31/'Cuenta Resultados'!O30)),0)","v":0},{"$f":"+IFERROR('Cuenta Resultados'!P34/(1-('Cuenta Resultados'!P31/'Cuenta Resultados'!P30)),0)","v":0},{"$f":"+IFERROR('Cuenta Resultados'!Q34/(1-('Cuenta Resultados'!Q31/'Cuenta Resultados'!Q30)),0)","v":0},{"$f":"+IFERROR('Cuenta Resultados'!R34/(1-('Cuenta Resultados'!R31/'Cuenta Resultados'!R30)),0)","v":0},"Crecimiento del ratio Punto de Equilibrio durante los cuatro años previstos."]
["PASIVO CORRIENTE",{"$f":"+SUM(B30:B33)","v":0},{"$f":"+SUM(C30:C33)","v":0},0,0,0]
["Proveedores",{"$f":"+Financiacion!C20","v":0},{"$f":"+B30","v":0},0,0,0]
["Deudas con entidades de crédito a corto plazo",{"$f":"+Financiacion!C21","v":0},0,0,0,0]
["Deudas con las Administraciones Públicas",{"$f":"+Financiacion!C22","v":0},{"$f":"+B32","v":0},{"$f":"+B32","v":0},{"$f":"+B32","v":0},{"$f":"+C32","v":0}]
["Otras deudas a corto plazo",{"$f":"+Financiacion!C23","v":0},{"$f":"+B33","v":0},{"$f":"+C33","v":0},0,0]
["Otro a corto plazo ",{"$f":"+Financiacion!C24","v":0},{"$f":"+B34","v":0},0,0,0]
["TOTAL PASIVO",{"$f":"+B21+B25+B29","v":0},{"$f":"+C21+C25+C29","v":0},{"$f":"+D21+D25+D29","v":0},{"$f":"+E21+E25+E29","v":0},{"$f":"+F21+F25+F29","v":0}]
[]
["Descuadre entre activo y pasivo ",{"$f":"+B17-B35","v":0},{"$f":"+C17-C35","v":0},{"$f":"+D17-D35","v":0},{"$f":"+E17-E35","v":0},{"$f":"+F17-F35","v":0}]

{"sheet":"Info_Tablas Amortizacion","index":15,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Tabla de coeficientes de amortización lineal"]
["NOTA: Esta tabla cambia cada año. Actualizado a 24/02/2023 fuente: https://www.iberley.es/temas/tablas-amortizacion-i-sociedades-30681"]
["Tipo de elemento","Coeficiente lineal máximo","Período de años máximo"]
["Obra civil"]
["Obra civil general",0.02,100]
["Pavimentos",0.06,34]
["Infraestructuras y obras mineras",7.0000000000000007E-2,30]
["Centrales"]
["Centrales hidráulicas",0.02,100]
["Centrales nucleares",0.03,60]
["Centrales de carbón",0.04,50]
["Centrales renovables",7.0000000000000007E-2,30]
["Otras centrales",0.05,40]
["Edificios"]
["Edificios industriales",0.03,68]
["Terrenos dedicados exclusivamente a escombreras",0.04,50]
["Almacenes y depósitos (gaseosos, líquidos y sólidos)",7.0000000000000007E-2,30]
["Edificios comerciales, administrativos, de servicios y viviendas",0.02,100]
["Instalaciones"]
["Subestaciones. Redes de transportes y distribución de energía",0.05,40]
["Cables",7.0000000000000007E-2,30]
["Resto instalaciones",0.1,20]
["Maquinaria",0.12,18]
["Equipos médicos y asimilados",0.15,14]
["Elementos de transporte"]
["Locomotoras, vagones y equipos de tracción",0.08,25]
["Buques, aeronaves",0.1,20]
["Elementos de transporte interno",0.1,20]
["Elementos de transporte externo",0.16,14]
["Autocamiones",0.2,10]
["Mobiliario y enseres"]
["Mobiliario",0.1,20]
["Lencería",0.25,8]
["Cristalería",0.5,4]
["Útiles y herramientas",0.25,8]
["Moldes, matrices y modelos",0.33,6]
["Otros enseres",0.15,14]
["Equipos electrónicos e informáticos. Sistemas y programas"]
["Equipos electrónicos",0.2,10]
["Equipos para procesos de información",0.25,8]
["Sistemas y programas informáticos",0.33,6]
["Producciones cinematográficas, fonográficas, videos y series audiovisuales",0.33,6]
["Otros elementos",0.1,20]