{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Intoduccion","segmento","Valor","Canales","clientes","Ingresos","Recursos","Actividades","Aliados","costos","Flujo de fondos","Resultado"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Intoduccion","index":0,"n_rows":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,5,28,9],[28,3,28,4],[3,2,3,10],[4,2,4,10],[10,3,10,9],[11,3,11,9],[19,5,19,9],[13,5,13,9],[15,5,15,9],[12,5,12,9],[18,5,18,9],[26,5,27,9],[18,3,18,4],[14,3,14,4],[26,3,27,4],[13,3,13,4],[15,3,15,4],[12,3,12,4],[23,3,25,4],[23,5,25,9],[14,5,14,9],[20,5,22,9],[16,5,17,9],[20,3,22,4],[16,3,17,4],[19,3,19,4]]}
[]
[]
[]
[null,null,"Plantilla para comparar proyectos de inversión"]
[null,null,"Presentación"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"www.asesoriasmipyme.com"]
[]
[]
[]
[]
[null,null,null,"Introducción"]
[null,null,null,"Esta plantilla de Excel permite realizar un resumen ejecutivo basado en el modelo Canvas, para comparar dos proyectos. Describir las estrategias que se realizaran para proporcionar valor al modelo de negocio. Adicionalmente, puede responder de manera simple y precisa que proyecto de inversión es más factible. Realiza la ponderación de cada una de las estrategias de valor y compara la tasa de retorno de la inversión de los dos proyectos."]
[null,null,null," 1.  Segmento de mercado",null,"Describe los segmentos del mercado donde la empresa ofrece sus servicios. "]
[null,null,null,"2. Propuesta de Valor",null,"Describe las ventajas que ofrece a los clientes. Recuerda que la propuesta de valor puede ser innovadora o parecida a otras ofertas existentes más una característica adicional. "]
[null,null,null,"3. Canales ",null,"Describe los canales de comunicación y venta por los cuales llegara la propuesta de valor."]
[null,null,null,"4. Relación con los Clientes",null,"Describir: ¿Cómo será la relación con los clientes?, ¿Cómo se mantendrá de forma independiente en los diferentes segmentos de mercado?"]
[null,null,null,"5. Ingresos",null,"Describe las fuentes de ingresos que se generan cuando los clientes adquieren las propuestas de valor ofrecidas."]
[]
[null,null,null,"6. Recursos claves",null,"Describe los recursos clave, que corresponden a los activos que debe tener la empresa mínimo para el funcionamiento."]
[null,null,null," 7.Actividades Claves",null,"Describe las acciones más importantes que debe realizar la empresa para tener éxito."]
[null,null,null,"8. Asociaciones claves o aliados claves.",null,"Ingresa las actividades que se externalizan y los recursos se adquieren por fuera de la empresa.\n"]
[]
[]
[null,null,null,"9. Estructura de costos",null,"Describe los diferentes elementos del modelo de negocio \nConforman la estructura de costes.\n"]
[]
[]
[null,null,null,"10. Flujo de fondos",null,"\nIngresa los flujos de fondo que realiza la empresa durante los primeros 5 años.  Para este punto te recomendamos utilizar esta plantilla para obtener el cálculo de los flujos de fondo. https://www.asesoriasmipyme.com/2022/09/plan-de-negocios-en-excel.html\n\n"]
[]
[null,null,null,"11. Resultados",null,"En la última hoja realiza una comparación de los dos proyectos arrojando los valores de acuerdo a la ponderación y el valor actual neto. "]

{"sheet":"segmento","index":1,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[36,1,38,1],[36,2,38,2],[36,3,38,3],[36,4,38,4],[36,5,38,5],[30,1,32,1],[30,2,32,2],[30,3,32,3],[30,4,32,4],[30,5,32,5],[33,1,35,1],[33,2,35,2],[33,3,35,3],[33,4,35,4],[33,5,35,5],[24,1,26,1],[24,2,26,2],[24,3,26,3],[24,4,26,4],[24,5,26,5],[27,1,29,1],[27,2,29,2],[27,3,29,3],[27,4,29,4],[27,5,29,5],[18,1,20,1],[18,2,20,2],[18,3,20,3],[18,4,20,4],[18,5,20,5],[21,1,23,1],[21,2,23,2],[21,3,23,3],[21,4,23,4],[21,5,23,5],[12,1,14,1],[12,2,14,2],[12,3,14,3],[12,4,14,4],[12,5,14,5],[15,1,17,1],[15,2,17,2],[15,3,17,3],[15,4,17,4],[15,5,17,5],[2,1,2,5],[3,1,3,4],[7,1,8,1],[9,1,11,1],[9,2,11,2],[9,3,11,3],[9,4,11,4],[9,5,11,5]]}
[]
[]
[null,"¿A quién pretende servir tu modelo de negocios?"]
[null,"            Plantilla para comparar proyectos"]
[]
[null,null,null,null,null,null,null,null,null,null,"www.asesoriasmipyme.com"]
[]
[null,"Numero",{"$f":"Aliados!C9","v":"Proyecto 1"},"Peso",{"$f":"Aliados!E9","v":"Proyecto 2"},"Peso"]
[null,null,"Segmento de mercado","Escala ","Segmento de mercado","Escala "]
[null,1,null,null,null,null,3,"Proyecto 1","Proyecto 2"]
[null,null,null,null,null,null,null,{"$f":"D10*$G$10","v":0},{"$f":"F10*$G$10","v":0}]
[null,null,null,null,null,null,null,{"$f":"D11*$G$10","v":0},{"$f":"F11*$G$10","v":0}]
[null,2,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,3,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,4,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,5,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,6,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,7,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,8,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,9,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,10,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(H11:H39)","v":0},{"$f":"SUM(I11:I39)","v":0}]

{"sheet":"Valor","index":2,"n_rows":42,"n_cols":12,"rows_kept":42,"cut":false,"hidden":false,"merged":[[38,1,40,1],[38,2,40,2],[38,3,40,3],[38,4,40,4],[38,5,40,5],[32,1,34,1],[32,2,34,2],[32,3,34,3],[32,4,34,4],[32,5,34,5],[35,1,37,1],[35,2,37,2],[35,3,37,3],[35,4,37,4],[35,5,37,5],[26,1,28,1],[26,2,28,2],[26,3,28,3],[26,4,28,4],[26,5,28,5],[29,1,31,1],[29,2,31,2],[29,3,31,3],[29,4,31,4],[29,5,31,5],[20,1,22,1],[20,2,22,2],[20,3,22,3],[20,4,22,4],[20,5,22,5],[23,1,25,1],[23,2,25,2],[23,3,25,3],[23,4,25,4],[23,5,25,5],[14,1,16,1],[14,2,16,2],[14,3,16,3],[14,4,16,4],[14,5,16,5],[17,1,19,1],[17,2,19,2],[17,3,19,3],[17,4,19,4],[17,5,19,5],[4,1,4,5],[5,1,5,5],[6,1,6,5],[9,1,10,1],[11,1,13,1],[11,2,13,2],[11,3,13,3],[11,4,13,4],[11,5,13,5]]}
[]
[]
[]
[]
[null,"¿Qué ofrecerá a tu segmento de clientes? "]
[null," ¿De qué forma resolverá sus problemas?"]
[null,null,null,null,null,null,null,null,null,null,null,"www.asesoriasmipyme.com"]
[]
[]
[null,"Numero",{"$f":"Aliados!C9","v":"Proyecto 1"},"Peso",{"$f":"Aliados!E9","v":"Proyecto 2"},"Peso"]
[null,null,"Propuesta de valor","Escala","Propuesta de valor","Escala ",4,"Proyecto 1","Proyecto 2"]
[null,1,null,null,null,null,null,{"$f":"D12*$G$11","v":0},{"$f":"F12*$G$11","v":0}]
[null,null,null,null,null,null,null,{"$f":"D13*$G$11","v":0},{"$f":"F13*$G$11","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,2,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,3,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,4,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,5,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,6,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,7,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,8,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,9,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,10,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H12:H41)","v":0},{"$f":"SUM(I12:I41)","v":0}]

{"sheet":"Canales","index":3,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[36,1,38,1],[36,2,38,2],[36,3,38,3],[36,4,38,4],[36,5,38,5],[30,1,32,1],[30,2,32,2],[30,3,32,3],[30,4,32,4],[30,5,32,5],[33,1,35,1],[33,2,35,2],[33,3,35,3],[33,4,35,4],[33,5,35,5],[24,1,26,1],[24,2,26,2],[24,3,26,3],[24,4,26,4],[24,5,26,5],[27,1,29,1],[27,2,29,2],[27,3,29,3],[27,4,29,4],[27,5,29,5],[18,1,20,1],[18,2,20,2],[18,3,20,3],[18,4,20,4],[18,5,20,5],[21,1,23,1],[21,2,23,2],[21,3,23,3],[21,4,23,4],[21,5,23,5],[12,1,14,1],[12,2,14,2],[12,3,14,3],[12,4,14,4],[12,5,14,5],[15,1,17,1],[15,2,17,2],[15,3,17,3],[15,4,17,4],[15,5,17,5],[9,5,11,5],[2,1,2,6],[3,1,3,6],[7,1,8,1],[9,1,11,1],[9,2,11,2],[9,3,11,3],[9,4,11,4]]}
[]
[]
[null,"¿Cómo te conocerán y evaluaran, y como decidirán, compraran  y recibirán soporte post ventas tus clientes?"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"www.asesoriasmipyme.com"]
[]
[null,"Numero",{"$f":"Aliados!C9","v":"Proyecto 1"},"Peso",{"$f":"Aliados!E9","v":"Proyecto 2"},"Peso"]
[null,null,"Canales","Escala ","Canales","Escala"]
[null,1,null,null,null,null,3,"Proyecto 1","Proyecto 2"]
[null,null,null,null,null,null,null,{"$f":"D10*$G$10","v":0},{"$f":"F10*$G$10","v":0}]
[null,null,null,null,null,null,null,{"$f":"D11*$G$10","v":0},{"$f":"F11*$G$10","v":0}]
[null,2,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,3,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,4,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,5,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,6,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,7,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,8,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,9,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,10,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(H11:H39)","v":0},{"$f":"SUM(I11:I39)","v":0}]

{"sheet":"clientes","index":4,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[37,1,39,1],[37,2,39,2],[37,3,39,3],[37,4,39,4],[37,5,39,5],[31,1,33,1],[31,2,33,2],[31,3,33,3],[31,4,33,4],[31,5,33,5],[34,1,36,1],[34,2,36,2],[34,3,36,3],[34,4,36,4],[34,5,36,5],[25,1,27,1],[25,2,27,2],[25,3,27,3],[25,4,27,4],[25,5,27,5],[28,1,30,1],[28,2,30,2],[28,3,30,3],[28,4,30,4],[28,5,30,5],[19,1,21,1],[19,2,21,2],[19,3,21,3],[19,4,21,4],[19,5,21,5],[22,1,24,1],[22,2,24,2],[22,3,24,3],[22,4,24,4],[22,5,24,5],[13,1,15,1],[13,2,15,2],[13,3,15,3],[13,4,15,4],[13,5,15,5],[16,1,18,1],[16,2,18,2],[16,3,18,3],[16,4,18,4],[16,5,18,5],[3,1,3,6],[8,1,9,1],[10,1,12,1],[10,2,12,2],[10,3,12,3],[10,4,12,4],[10,5,12,5]]}
[]
[]
[null,"¿Qué tipo de relación mantendrá con tu segmento de clientes?"]
[null,"            Plantilla para comparar proyectos"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"www.asesoriasmipyme.com"]
[]
[null,"Numero",{"$f":"Aliados!C9","v":"Proyecto 1"},"Peso",{"$f":"Aliados!E9","v":"Proyecto 2"},"Peso"]
[null,null,"Relación con los clientes","Escala ","Relación con los clientes","Escala"]
[null,1,null,null,null,null,3,"Proyecto 1","Proyecto 2"]
[null,null,null,null,null,null,null,{"$f":"D11*$G$11","v":0},{"$f":"F11*$G$11","v":0}]
[null,null,null,null,null,null,null,{"$f":"D12*$G$11","v":0},{"$f":"F12*$G$11","v":0}]
[null,2,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,3,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,4,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,5,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,6,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,7,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,8,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,9,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,10,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H12:H40)","v":0},{"$f":"SUM(I12:I40)","v":0}]

{"sheet":"Ingresos","index":5,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[37,1,39,1],[37,2,39,2],[37,3,39,3],[37,4,39,4],[37,5,39,5],[31,1,33,1],[31,2,33,2],[31,3,33,3],[31,4,33,4],[31,5,33,5],[34,1,36,1],[34,2,36,2],[34,3,36,3],[34,4,36,4],[34,5,36,5],[25,1,27,1],[25,2,27,2],[25,3,27,3],[25,4,27,4],[25,5,27,5],[28,1,30,1],[28,2,30,2],[28,3,30,3],[28,4,30,4],[28,5,30,5],[19,1,21,1],[19,2,21,2],[19,3,21,3],[19,4,21,4],[19,5,21,5],[22,1,24,1],[22,2,24,2],[22,3,24,3],[22,4,24,4],[22,5,24,5],[13,1,15,1],[13,2,15,2],[13,3,15,3],[13,4,15,4],[13,5,15,5],[16,1,18,1],[16,2,18,2],[16,3,18,3],[16,4,18,4],[16,5,18,5],[10,5,12,5],[2,1,2,5],[3,1,3,4],[8,1,9,1],[10,1,12,1],[10,2,12,2],[10,3,12,3],[10,4,12,4]]}
[]
[]
[null,"¿Qué estrategias se implementan para la generación de ganancia?"]
[null,"            Plantilla para comparar proyectos"]
[]
[null,null,null,null,null,null,null,null,null,null,"www.asesoriasmipyme.com"]
[]
[]
[null,"Numero",{"$f":"Aliados!C9","v":"Proyecto 1"},"Peso",{"$f":"Aliados!E9","v":"Proyecto 2"},"Peso"]
[null,null,"Ingresos ","Escala ","Ingresos ","Escala"]
[null,1,null,null,null,null,4,"Proyecto 1","Proyecto 2"]
[null,null,null,null,null,null,null,{"$f":"D11*$G$11","v":0},{"$f":"F11*$G$11","v":0}]
[null,null,null,null,null,null,null,{"$f":"D12*$G$11","v":0},{"$f":"F12*$G$11","v":0}]
[null,2,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,3,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,4,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,5,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,6,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,7,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,8,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,9,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,10,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(H12:H40)","v":0},{"$f":"SUM(I12:I40)","v":0}]

{"sheet":"Recursos","index":6,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[37,1,39,1],[37,2,39,2],[37,3,39,3],[37,4,39,4],[37,5,39,5],[28,1,30,1],[28,2,30,2],[28,3,30,3],[28,4,30,4],[28,5,30,5],[25,1,27,1],[25,2,27,2],[25,3,27,3],[25,4,27,4],[25,5,27,5],[31,1,33,1],[31,2,33,2],[31,3,33,3],[31,4,33,4],[31,5,33,5],[34,1,36,1],[34,2,36,2],[34,3,36,3],[34,4,36,4],[34,5,36,5],[19,1,21,1],[19,2,21,2],[19,3,21,3],[19,4,21,4],[19,5,21,5],[22,1,24,1],[22,2,24,2],[22,3,24,3],[22,4,24,4],[22,5,24,5],[13,1,15,1],[13,2,15,2],[13,3,15,3],[13,4,15,4],[13,5,15,5],[16,1,18,1],[16,2,18,2],[16,3,18,3],[16,4,18,4],[16,5,18,5],[3,1,3,6],[2,1,2,6],[8,1,9,1],[10,1,12,1],[10,2,12,2],[10,3,12,3],[10,4,12,4],[10,5,12,5]]}
[]
[]
[null,"¿Qué se requiere para iniciar y sostener el proyecto?"]
[null,"            Plantilla para comparar proyectos"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"www.asesoriasmipyme.com"]
[null,"Numero",{"$f":"Aliados!C9","v":"Proyecto 1"},"Peso",{"$f":"Aliados!E9","v":"Proyecto 2"},"Peso"]
[null,null,"Recursos claves","Escala ","Recursos claves","Escala "]
[null,1,null,null,null,null,2,"Proyecto 1","Proyecto 2"]
[null,null,null,null,null,null,null,{"$f":"D11*$G$11","v":0},{"$f":"F11*$G$11","v":0}]
[null,null,null,null,null,null,null,{"$f":"D12*$G$11","v":0},{"$f":"F12*$G$11","v":0}]
[null,2,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,3,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,4,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,5,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,6,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,7,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,8,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,9,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,10,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(H12:H40)","v":0},{"$f":"SUM(I12:I40)","v":0}]

{"sheet":"Actividades","index":7,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[37,1,39,1],[37,2,39,2],[37,3,39,3],[37,4,39,4],[37,5,39,5],[31,1,33,1],[31,2,33,2],[31,3,33,3],[31,4,33,4],[31,5,33,5],[34,1,36,1],[34,2,36,2],[34,3,36,3],[34,4,36,4],[34,5,36,5],[25,1,27,1],[25,2,27,2],[25,3,27,3],[25,4,27,4],[25,5,27,5],[28,1,30,1],[28,2,30,2],[28,3,30,3],[28,4,30,4],[28,5,30,5],[19,1,21,1],[19,2,21,2],[19,3,21,3],[19,4,21,4],[19,5,21,5],[22,1,24,1],[22,2,24,2],[22,3,24,3],[22,4,24,4],[22,5,24,5],[13,1,15,1],[13,2,15,2],[13,3,15,3],[13,4,15,4],[13,5,15,5],[16,1,18,1],[16,2,18,2],[16,3,18,3],[16,4,18,4],[16,5,18,5],[3,1,3,6],[8,1,9,1],[10,1,12,1],[10,2,12,2],[10,3,12,3],[10,4,12,4],[10,5,12,5]]}
[]
[]
[null,"¿Qué hace falta hacer para iniciar y sostener la idea de negocio?"]
[null,"            Plantilla para comparar proyectos"]
[]
[null,null,null,null,null,null,null,null,null,null,"www.asesoriasmipyme.com"]
[]
[]
[null,"Numero",{"$f":"Aliados!C9","v":"Proyecto 1"},"Peso",{"$f":"Aliados!E9","v":"Proyecto 2"},"Peso"]
[null,null,"Actividades  claves ","Escala","Actividades claves","Escala ",4,"Proyecto 1","Proyecto 2"]
[null,1,null,null,null,null,null,{"$f":"D11*$G$10","v":0},{"$f":"F11*G10","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"F13*$G$10","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,2,null,null,null,null,null,{"$f":"D15*$G$10","v":0},0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,3,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0]
[null,4,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,5,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,6,null,null,null,null,null,"kkk",0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0,0]
[null,7,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,8,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,9,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,10,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(H11:H41)","v":0},{"$f":"SUM(I11:I41)","v":0}]

{"sheet":"Aliados","index":8,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,5,33,5],[34,5,36,5],[37,5,39,5],[31,4,33,4],[34,4,36,4],[37,4,39,4],[31,3,33,3],[34,3,36,3],[37,3,39,3],[25,4,27,4],[28,4,30,4],[25,5,27,5],[28,5,30,5],[16,5,18,5],[19,5,21,5],[22,5,24,5],[37,1,39,1],[37,2,39,2],[10,3,12,3],[13,3,15,3],[16,3,18,3],[19,3,21,3],[22,3,24,3],[25,3,27,3],[28,3,30,3],[28,1,30,1],[28,2,30,2],[31,1,33,1],[31,2,33,2],[34,1,36,1],[34,2,36,2],[22,1,24,1],[25,1,27,1],[25,2,27,2],[16,1,18,1],[16,2,18,2],[19,1,21,1],[19,2,21,2],[10,4,12,4],[13,4,15,4],[10,5,12,5],[13,5,15,5],[22,2,24,2],[16,4,18,4],[19,4,21,4],[22,4,24,4],[8,1,9,1],[10,2,12,2],[10,1,12,1],[13,1,15,1],[13,2,15,2]]}
[]
[]
[null,null,"¿Quiénes brindan apoyo en la ejecución del negocio?"]
[null,null,null,"                                                                       Plantilla para comparar proyectos"]
[]
[null,null,null,null,null,null,null,null,null,"www.asesoriasmipyme.com"]
[]
[]
[null,"Numero","Proyecto 1","Peso","Proyecto 2","Peso",null,"Proyecto 1","Proyecto 2"]
[null,null,"Aliados claves ","Escala","Aliados claves","Escala ",4,{"$f":"D11*$G$10","v":0},{"$f":"F11*$G$10","v":0}]
[null,1,null,null,null,null,null,{"$f":"D12*$G$10","v":0},{"$f":"F12*$G$10","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,2,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,3,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,4,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,5,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,6,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,7,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,8,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,9,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,10,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H10:H40)","v":0},{"$f":"SUM(I10:I40)","v":0}]

{"sheet":"costos","index":9,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[37,1,39,1],[37,2,39,2],[37,3,39,3],[37,4,39,4],[37,5,39,5],[31,1,33,1],[31,2,33,2],[31,3,33,3],[31,4,33,4],[31,5,33,5],[34,1,36,1],[34,2,36,2],[34,3,36,3],[34,4,36,4],[34,5,36,5],[25,1,27,1],[25,2,27,2],[25,3,27,3],[25,4,27,4],[25,5,27,5],[28,1,30,1],[28,2,30,2],[28,3,30,3],[28,4,30,4],[28,5,30,5],[19,1,21,1],[19,2,21,2],[19,3,21,3],[19,4,21,4],[19,5,21,5],[22,1,24,1],[22,2,24,2],[22,3,24,3],[22,4,24,4],[22,5,24,5],[13,1,15,1],[13,2,15,2],[13,3,15,3],[13,4,15,4],[13,5,15,5],[16,1,18,1],[16,2,18,2],[16,3,18,3],[16,4,18,4],[16,5,18,5],[10,5,12,5],[2,1,2,5],[3,1,3,4],[8,1,9,1],[10,1,12,1],[10,2,12,2],[10,3,12,3],[10,4,12,4]]}
[]
[]
[null,"¿Qué costos y gastos requiere el proyecto?"]
[null,"            Plantilla para comparar proyectos"]
[]
[null,null,null,null,null,null,null,null,null,null,"www.asesoriasmipyme.com"]
[]
[]
[null,"Numero",{"$f":"Aliados!C9","v":"Proyecto 1"},"Peso",{"$f":"Aliados!E9","v":"Proyecto 2"},"Peso"]
[null,null,"Estructura de costos","Escala ","Estructura de costos","Escala"]
[null,1,null,null,null,null,2,"Proyecto1","Proyecto2"]
[null,null,null,null,null,null,null,{"$f":"D11*$G$11","v":0},{"$f":"F11*$G$11","v":0}]
[null,null,null,null,null,null,null,{"$f":"D12*$G$11","v":0},{"$f":"F12*$G$11","v":0}]
[null,2,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,3,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,4,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,5,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,6,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,7,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,8,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,9,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,10,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H12:H40)","v":0},{"$f":"SUM(I12:I40)","v":0}]

{"sheet":"Flujo de fondos","index":10,"n_rows":45,"n_cols":18,"rows_kept":45,"cut":false,"hidden":false,"merged":[[3,1,3,6],[4,1,4,6]]}
[]
[]
[]
[null,"Cálculo de TIR y VAN para decisión de inversión"]
[null,"            Plantilla para comparar proyectos"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"www.asesoriasmipyme.com"]
[null,null,null,null,null,null,null,null,null,null,"www.asesoriasmipyme.com"]
[]
[null,null,null,{"$f":"Aliados!C9","v":"Proyecto 1"},null,{"$f":"Aliados!E9","v":"Proyecto 2"}]
[null,null,"Tasa de "]
[null,null,"descuento"]
[]
[]
[null,null,"Período","Flujo de Fondos",null,"Flujo de Fondos"]
[null,null,0]
[null,null,1]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
[null,null,8]
[null,null,9]
[null,null,10]
[null,null,11]
[null,null,12]
[null,null,13]
[null,null,14]
[null,null,15]
[null,null,16]
[null,null,17]
[null,null,18]
[null,null,19]
[null,null,20]
[null,null,21]
[null,null,22]
[null,null,23]
[null,null,24]
[null,null,25]
[null,null,26]
[null,null,27]
[null,null,28]
[null,null,29]
[null,null,30]

{"sheet":"Resultado","index":11,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,1,31,4],[30,1,30,4],[1,1,1,6],[2,1,2,6],[22,1,22,2],[24,1,24,4],[25,1,25,4]]}
[]
[null,"Resultado"]
[null,"            Plantilla para comparar proyectos"]
[]
[]
[]
[null,null,null,null,null,null,null,"www.asesoriasmipyme.com"]
[null,"Período",{"$f":"Actividades!C9","v":"Proyecto 1"},null,{"$f":"Actividades!E9","v":"Proyecto 2"}]
[null,"Aliados claves",{"$f":"Aliados!H41","v":0},null,{"$f":"Aliados!I41","v":0}]
[null,"Actividades claves",{"$f":"Actividades!H43","v":0},null,{"$f":"Actividades!I43","v":0}]
[null,"Propuesta de valor",{"$f":"Valor!H42","v":0},null,{"$f":"Valor!I42","v":0}]
[null,"Relación con los clientes",{"$f":"clientes!H41","v":0},null,{"$f":"clientes!I41","v":0}]
[null,"Segmento de mercado",{"$f":"segmento!H41","v":0},null,{"$f":"segmento!I41","v":0}]
[null,"Recursos claves",{"$f":"Recursos!H42","v":0},null,{"$f":"Recursos!I42","v":0}]
[null,"Canales",{"$f":"Canales!H41","v":0},null,{"$f":"Canales!I41","v":0}]
[null,"Estructura de costos",{"$f":"costos!H41","v":0},null,{"$f":"costos!I41","v":0}]
[null,"Ingresos",{"$f":"Ingresos!H42","v":0},null,{"$f":"Ingresos!I42","v":0}]
[null,"Total",{"$f":"SUM(C9:C17)","v":0},null,{"$f":"SUM(E9:E17)","v":0}]
[null,"Tasa de descuento",{"$f":"'Flujo de fondos'!D10","v":0},null,{"$f":"'Flujo de fondos'!F10","v":0}]
[null,"TIR ",{"$f":"IF(OR('Flujo de fondos'!D15=\"\",'Flujo de fondos'!D16=\"\"),0,IRR('Flujo de fondos'!$D$15:'Flujo de fondos'!$D$45))","v":0},null,{"$f":"IF(OR('Flujo de fondos'!F15=\"\",'Flujo de fondos'!F16=\"\"),0,IRR('Flujo de fondos'!$F$15:'Flujo de fondos'!$F$45))","v":0}]
[null,"Van ",{"$f":"NPV('Flujo de fondos'!$D$10,'Flujo de fondos'!$D$16:'Flujo de fondos'!$D$45)+'Flujo de fondos'!$D$15","v":0},null,{"$f":"NPV('Flujo de fondos'!F10,'Flujo de fondos'!$F$16:'Flujo de fondos'!$F$45)+'Flujo de fondos'!$F$15","v":0}]
[]
[null,"Decisión de proyecto versus no hacerlo"]
[]
[null,{"$f":"IF(AND(C20>E20,C20>C19),CONCATENATE(\"Me conviene hacer el \",C8,\" dado que me da un retorno mayor al mercado en comparacion con el proyecto 2\"),CONCATENATE(\"No me conviene hacer el \",C8,\" dado que da un retorno menor al del mercado en comparacion con el proyecto 2\"))","v":"No me conviene hacer el Proyecto 1 dado que da un retorno menor al del mercado en comparacion con el proyecto 2"},null,null,null,{"$f":"C19","v":0}]
[null,{"$f":"IF(AND(E20>C20,E20>E19),CONCATENATE(\"Me conviene hacer el \",E8,\" dado que me da un retorno mayor al mercado en comparacion con el proyecto 1\"),CONCATENATE(\"No me conviene hacer el \",E8,\" dado que da un retorno menor al del mercado en comparacion con el proyecto 1\"))","v":"No me conviene hacer el Proyecto 2 dado que da un retorno menor al del mercado en comparacion con el proyecto 1"},null,null,null,{"$f":"E19","v":0}]
[]
[]
[null,"Decision entre proyectos:"]
[]
[null,{"$f":"IF(C21>E21,CONCATENATE(\"El \", $C$8, \" es el que me conviene hacer dado que tiene un VAN mayor\", \" que el \", $E$8),CONCATENATE(\"El \", $E$8, \" es el que me conviene hacer dado que su VAN es mayor al \",$C$8))","v":"El Proyecto 2 es el que me conviene hacer dado que su VAN es mayor al Proyecto 1"}]
[null,{"$f":"IF(C18>E18,CONCATENATE(\"El \", $C$18, \" es el que me conviene hacer dado que tiene un ponderacion mayor\", \" que el \", $E$18),CONCATENATE(\"El \", $E$18, \" es el que me conviene hacer dado que su ponderacion es mayor al \",$C$18))","v":"El 0 es el que me conviene hacer dado que su ponderacion es mayor al 0"}]