{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Hoja1","Introducción","Tablero","Glosario","Comentarios"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Hoja1","index":0,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
["Estructura Societaria",null,null,null,null,"Inmuebles","Unipersonal"]
[null,null,null,null,null,"Explotación","Sociedad Anonima"]
[null,null,null,null,null,null,"Marcar si es o no la misma sociedad…."]
[]
["Activos Inmuebles Agropecuarios"]
["Activos Muebles Agropecuarios"]
["Activos Inmuebles No Agropecuarios"]
["Activos Muebles No Agropecuarios"]
["Patrimonio Neto"]
["Resultado Promedio Ultimos 3 Años"]
[]
[]
[]
["Numero de Generaciones en la misma Actividad - Sector",null,null,null,null,null,"5ta o más"]
["Proporción del patrimonio propiedad de la generación anterior, que se mantiene",null,null,null,null,null,null,"Ajustarla mejor"]
["Numero de Generación que Dirige la Empresa",null,null,null,null,null,"1ra","¿Quién fundo?"]
["Miembros de la empresa que integran la 1ra Generación"]
["Miembros de la empresa que integran la 2da Generación",null,null,null,null,null,null,null,"¿Arbol genealogico?"]
["Miembros de la empresa que integran la 3ra Generación"]
["Miembros de la empresa que integran la 4ta Generación"]
[]
[]
["Mapa de Intereses",null,null,null,null,null,"0 a 20 años","20 a 40 años","40 a 60 años","mas de 60 años"]
["Dueño Administrador Familiar (Accionista - Empleado - Familiar)",null,null,null,null,null,null,null,null,null,null,"Suma de accionistas igual al arbol genealogico"]
["Accionista Familiar (Accionista - Familiar)",null,null,null,null,null,null,null,null,null,null,"Suma de empleados igual al arbol genealogico"]
["Accionista Estrategico (Accionista - Empleado)"]
["Accionista Potencial (Familia)"]
["Empleado Familiar (Familia - Empleado)"]
["Empleados no Familiar (Empleado)"]
["Accionista Financiero (Accionista)"]
[]
["Gobierno Actual",null,null,null,null,null,null,null,"Funcionamiento"]
["Reunion de Consejo de Familia",null,null,null,null,null,"No"]
["Asamblea de Accionistas",null,null,null,null,null,"No"]
["Reunion de Directorio",null,null,null,null,null,"No"]
["Reunion de Gerenciales",null,null,null,null,null,"No"]
[]
["Intereses",null,null,null,null,null,null,null,"Funcionamiento"]
["Intereses de los Actuales Dueños"]
["Intereses de los Potenciales"]
[]
["Información - Traerlo del DISE",null,null,null,null,null,null,null,"Funcionamiento"]
[]
["Dividendos",null,null,null,null,null,null,null,"Funcionamiento"]
["Politica de distribución de dividendos",null,null,null,null,null,"No Consensuado"]
["Distribución de dividendos",null,null,null,null,null,"Lo que se necesita"]
["Proporción Dividendos/Resultados",null,null,null,null,null,0.35]
[]
["Evolución"]
["Evolución del Negocio",null,null,null,null,null,"Lanzamiento"]
["Evolución de la Familia",null,null,null,null,null,"Ingreso a la Empresa de Descendientes"]
["Evolución de la Propiedad",null,null,null,null,null,"Dueño Controlante"]

{"sheet":"Introducción","index":1,"n_rows":75,"n_cols":37,"rows_kept":75,"cut":false,"hidden":true,"merged":[[14,28,14,31],[2,2,2,11]]}
[]
[]
[null,null,"Tablero para Diagnóstico de Situación de la Familia Empresaria (DiSFE)"]
[]
[]
[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,null,"Accionistas - Propiedad"]
[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,null,"Dueño Controlante","Sociedad Hermanos","Consorcio Primos"]
[]
[]
[]
[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,"Familia Empresaria","Familia Joven Fundadora",null,null,null,null,null,null,"Evolución de la Familia",null,"Ingreso a la Empresa de Descendientes"]
[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,"Ingreso de los Descendientes",null,null,null,null,null,null,"Evolución de la Propiedad",null,"Dueño Controlante"]
[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,"Trabajo Conjunto"]
[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,"Traspaso Bastón Mando"]
[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,null,"Edad de la próxima generación"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Accionista","Sin hijos o con menos de 20 años","20 a 35 años","35 a 50 años","Mas de 50 años"]
[]
[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,"Familia Joven Fundadora","menos de 50 años",5,3,2,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Familia Joven Fundadora","50 a 65 años",4,2,1,1]
[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,"Familia Joven Fundadora","65 a 80 años",2,1,1,1]
[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,"Familia Joven Fundadora","mas de 80 años",0,1,1,1]
[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,"Ingreso a la Empresa de Descendientes","menos de 50 años",5,5,3,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ingreso a la Empresa de Descendientes","50 a 65 años",4,3,2,1]
[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,"Ingreso a la Empresa de Descendientes","65 a 80 años",2,1,1,1]
[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,"Ingreso a la Empresa de Descendientes","mas de 80 años",0,1,1,1]
[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,"Trabajo Conjunto","menos de 50 años",0,5,5,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trabajo Conjunto","50 a 65 años",0,5,3,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trabajo Conjunto","65 a 80 años",0,3,2,1]
[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,"Trabajo Conjunto","mas de 80 años",0,1,1,1]
[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,"Traspaso Bastón de Mando","menos de 50 años",0,3,5,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Traspaso Bastón de Mando","50 a 65 años",0,3,5,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Traspaso Bastón de Mando","65 a 80 años",0,5,5,3]
[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,"Traspaso Bastón de Mando","mas de 80 años",0,5,5,3]
[]
[]
[]
[]
[]
[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,"Gobierno Actual",null,"Dueño Controlante","Sociedad de Hermanos","Consorcio Primos"]
[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,"Reunión de Consejo de Familia",null,3,2,1]
[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,"Asamblea de Accionistas",null,5,1,1]
[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,"Reunión de Directorio",null,5,1,1]
[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,"Reunión de Gerentes (cuestiones operativas)",null,5,3,1]
[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,null,null,null,null,null,"Color si no esta definido el órgano de gobierno"]
[]
[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,"Definición de Políticas",null,"Dueño Controlante","Sociedad Hermanos","Consorcio Primos"]
[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,"Política de Distribución de Dividendos",null,3,1,1]
[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,"Política de Remuneración\n     (Competitividad externa / Equidad interna)",null,3,1,1]
[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,"Política de Endeudamiento",null,3,1,1]
[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,"Perfil de Riesgo",null,2,1,1]
[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,"Política de Gestión de Activos",null,3,1,1]
[]
[]
[]
[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,"Escala",null,"0 al 25% del Resultado de la Empresa",null,"75 al 100% del Resultado de la Empresa",null,null,4]
[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,"Negocio",null,"25 al 50% del Resultado de la Empresa",null,"50 al 75% del Resultado de la Empresa",null,null,3]
[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,null,"50 al 75% del Resultado de la Empresa",null,"25 al 50% del Resultado de la Empresa",null,null,2]
[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,null,"75 al 100% del Resultado de la Empresa",null,"0 al 25% del Resultado de la Empresa",null,null,1]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[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,null,null,null,null,null,null,3]
[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,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0-25% de las necesidades de los acc. potenciales","25-50% de las necesidades de los acc. potenciales","50-75% de las necesidades de los acc. potenciales","75-100% de las necesidades de los acc. potenciales",null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0-25% de las necesidades de los accionistas actuales",1,1,2,2]
[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,"25-50% de las necesidades de los accionistas actuales",2,2,3,3,null,null,4]
[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,"50-75% de las necesidades de los accionistas actuales",3,4,5,5,null,null,3]
[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,"75-100% de las necesidades de los accionistas actuales",4,5,5,5,null,null,2]
[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,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Situación actual",null,"Situación futura"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0 a 500.000 U$S por Accionista",1,"0 a 500.000 U$S por Accionista",1]
[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,"500.000 a 1.000.000 U$S por Accionista",1,"500.000 a 1.000.000 U$S por Accionista",1]
[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,"1.000.000 a 2.500.000 U$S por Accionista",2,"1.000.000 a 2.500.000 U$S por Accionista",2]
[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,"2.500.000 a 5.000.000 U$S por Accionista",3,"2.500.000 a 5.000.000 U$S por Accionista",3]
[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,"más de  5.000.000 U$S por Accionista",3,"más de  5.000.000 U$S por Accionista",3]

{"sheet":"Tablero","index":2,"n_rows":75,"n_cols":37,"rows_kept":75,"cut":false,"hidden":false,"merged":[[15,15,16,15],[15,13,15,14],[16,13,16,14],[14,28,14,31],[10,5,12,5],[14,15,14,16],[14,13,14,14],[24,12,25,12],[24,13,24,14],[25,13,25,14],[15,3,15,4],[22,13,22,14],[17,13,17,14],[17,12,18,12],[18,13,18,14],[23,13,23,14],[14,3,14,4],[16,3,16,4],[17,3,17,4],[2,2,2,11],[6,1,8,1],[6,2,8,2],[10,1,12,1],[14,1,26,1],[18,2,21,2],[22,2,26,2],[10,3,10,4],[11,3,11,4],[12,3,12,4],[12,11,26,11],[26,13,26,14],[17,15,18,15],[24,15,25,15],[22,15,23,15],[19,13,19,14]]}
[]
[]
[null,null,"Tablero para Diagnóstico de Situación de la Familia Empresaria (DiSFE)"]
[]
[]
[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,null,"Accionistas - Propiedad"]
[null,"Situación General",{"$f":"I7","v":3.7550000000000003},null,null,null,null,null,{"$f":"SUM(I11:I27,K15:K27)","v":3.7550000000000003},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dueño Controlante","Sociedad Hermanos","Consorcio Primos"]
[]
[]
[]
[null,"\nSituación Familia Empresaria","Estado Familia Empresaria","Traspaso Bastón de Mando",null,{"$f":"IF(SUMPRODUCT((D11=AA18:AA33)*(AB18:AB33=D12)*(AC16:AF16=D13)*(AC18:AF33))=0,\"-\",SUMPRODUCT((D11=AA18:AA33)*(AB18:AB33=D12)*(AC16:AF16=D13)*(AC18:AF33)))","v":5},null,{"$f":"+IF(F11=\"-\",10,40%)","v":0.4},{"$f":"IF(F11=\"-\",5*H11,F11*H11)","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Familia Empresaria","Familia Joven Fundadora",null,null,null,null,null,null,"Evolución de la Familia",null,"Ingreso a la Empresa de Descendientes"]
[null,null,"Edad Generación Actual","50 a 65 años",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ingreso de los Descendientes",null,null,null,null,null,null,"Evolución de la Propiedad",null,"Dueño Controlante"]
[null,null,"Edad Generación Futura","35 a 50 años",null,null,null,null,null,null,null,"Situación Patrimonial","Situación actual",null,null,"Tablero","Propia",null,null,null,null,null,null,null,null,null,null,"Trabajo Conjunto"]
[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,"Traspaso Bastón Mando"]
[null,"Situación Propiedad","Propiedad","Dueño Controlante",null,null,null,null,null,null,null,null,null,"Inelástico (mensual)",null,{"$f":"IF(N15=\"Muy elástico (>70%)\",1,IF(N15=\"Elástico (50 a 70%)\",2,IF(N15=\"Inelástico (anual)\",3,IF(N15=\"Inelástico (mensual)\",4,0))))","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Edad de la próxima generación"]
[null,null,"Dueño de los Inmuebles (1)",null,null,null,null,null,null,null,null,null,"Resultado a Dividendos","50 al 75% del Resultado de la Empresa",null,{"$f":"SUMPRODUCT((N16=$AC$55:$AC$58)*(AH55:AH58))","v":2},null,null,null,null,null,null,null,null,null,null,null,"Accionista","Sin hijos o con menos de 20 años","20 a 35 años","35 a 50 años","Mas de 50 años"]
[null,null,"Dueño de la Producción (2)",null,null,null,null,null,null,2.5000000000000001E-2,{"$f":"P16*J17","v":0.05},null,"Resultado a Crecimiento",{"$f":"IF(N16=0,\"\",INDEX(AC55:AE58,MATCH(N16,AC55:AC58,0),3))","v":"25 al 50% del Resultado de la Empresa"},null,null,{"$f":"IF(Q16=0,\"\",IF(Q16=\"Insuficiente\",1,IF(Q16=\"Ajustado\",2,IF(Q16=\"Suficiente\",3,FALSE))))","v":""}]
[null,null,"Los dueños de (1) y (2) son:",null,null,null,null,null,null,2.5000000000000001E-2,{"$f":"P18*J18","v":0.125},null,"Remuneración y Dividendos\n¿Qué porcentaje cubren o cubrirían según la generación?","75-100% de las necesidades de los accionistas actuales",null,{"$f":"SUMPRODUCT((N18=AA65:AA68)*(AB64:AE64=N19)*(AB65:AE68))","v":5},null,null,null,null,null,null,null,null,null,null,"Familia Joven Fundadora","menos de 50 años",5,3,2,0]
[null,null,"Organos de Gobierno \n(Funcionamiento)","Reunión de Consejo de Familia",null,{"$f":"IF(E19=\"SI\",5,SUMPRODUCT(($D$15=$AC$39:$AE$39)*($AA$40:$AA$43=D19)*($AC$40:$AE$43)))","v":3},null,7.4999999999999997E-2,{"$f":"F19*H19","v":0.22499999999999998},null,null,null,null,"75-100% de las necesidades de los acc. potenciales",null,null,{"$f":"IF(Q18=0,\"\",IF(Q18=\"Insuficiente\",1,IF(Q18=\"Ajustado\",2,IF(Q18=\"Suficiente\",3,FALSE))))","v":""},null,null,null,null,null,null,null,null,null,"Familia Joven Fundadora","50 a 65 años",4,2,1,1]
[null,null,null,"Asamblea de Accionistas",null,{"$f":"IF(E20=\"SI\",5,SUMPRODUCT(($D$15=$AC$39:$AE$39)*($AA$40:$AA$43=D20)*($AC$40:$AE$43)))","v":5},null,7.4999999999999997E-2,0.375,2.5000000000000001E-2,{"$f":"IF(Q20=\"\",0,Q20*J20)","v":0},null,"Patrimonio Neto","1.000.000 a 2.500.000 U$S por Accionista",null,null,{"$f":"IF(P20=0,\"\",IF(P20=\"Reducido\",1,IF(P20=\"Ajustado\",2,IF(P20=\"Importante\",3,FALSE))))","v":""},null,null,null,null,null,null,null,null,null,"Familia Joven Fundadora","65 a 80 años",2,1,1,1]
[null,null,null,"Reunión de Directorio",null,{"$f":"IF(E21=\"SI\",5,SUMPRODUCT(($D$15=$AC$39:$AE$39)*($AA$40:$AA$43=D21)*($AC$40:$AE$43)))","v":5},null,2.5000000000000001E-2,0.125,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Familia Joven Fundadora","mas de 80 años",0,1,1,1]
[null,null,null,"Reunión de Gerentes (cuestiones operativas)",null,{"$f":"IF(E22=\"SI\",5,SUMPRODUCT(($D$15=$AC$39:$AE$39)*($AA$40:$AA$43=D22)*($AC$40:$AE$43)))","v":5},null,2.5000000000000001E-2,0.125,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ingreso a la Empresa de Descendientes","menos de 50 años",5,5,3,0]
[null,null,"Definición de Politicas\n(Funcionamiento)","Política de Distribución de Dividendos",null,{"$f":"IF(E23=\"SI\",5,SUMPRODUCT(($D$15=$AC$39:$AE$39)*($AA$47:$AA$51=D23)*($AC$47:$AE$51)))","v":3},null,0.02,0.06,null,null,null,"Resultado a Dividendos","75 al 100% del Resultado de la Empresa",null,{"$f":"SUMPRODUCT((N23=$AC$55:$AC$58)*(AH55:AH58))","v":1},null,null,null,null,null,null,null,null,null,null,"Ingreso a la Empresa de Descendientes","50 a 65 años",4,3,2,1]
[null,null,null,"Política de Remuneración\n     (Competitividad externa / Equidad interna)",null,{"$f":"IF(E24=\"SI\",5,SUMPRODUCT(($D$15=$AC$39:$AE$39)*($AA$47:$AA$51=D24)*($AC$47:$AE$51)))","v":3},null,0.02,{"$f":"F24*H24","v":0.06},7.4999999999999997E-2,{"$f":"P23*J24","v":7.4999999999999997E-2},null,"Resultado a Crecimiento",{"$f":"IF(N23=0,\"\",INDEX(AC55:AE58,MATCH(N23,AC55:AC58,0),3))","v":"0 al 25% del Resultado de la Empresa"},null,null,{"$f":"IF(Q23=0,\"\",IF(Q23=\"Insuficiente\",1,IF(Q23=\"Ajustado\",2,IF(Q23=\"Suficiente\",3,FALSE))))","v":""},null,null,null,null,null,null,null,null,null,"Ingreso a la Empresa de Descendientes","65 a 80 años",2,1,1,1]
[null,null,null,"Política de Endeudamiento",null,{"$f":"IF(E25=\"SI\",5,SUMPRODUCT(($D$15=$AC$39:$AE$39)*($AA$47:$AA$51=D25)*($AC$47:$AE$51)))","v":3},null,0.02,0.06,7.4999999999999997E-2,{"$f":"P25*J25","v":0.375},null,"Remuneración y Dividendos\n¿Qué porcentaje cubren o cubrirían según la generación?","75-100% de las necesidades de los accionistas actuales",null,{"$f":"SUMPRODUCT((N25=AA65:AA68)*(AB64:AE64=N26)*(AB65:AE68))","v":5},null,null,null,null,null,null,null,null,null,null,"Ingreso a la Empresa de Descendientes","mas de 80 años",0,1,1,1]
[null,null,null,"Perfil de Riesgo",null,{"$f":"IF(E26=\"SI\",5,SUMPRODUCT(($D$15=$AC$39:$AE$39)*($AA$47:$AA$51=D26)*($AC$47:$AE$51)))","v":2},null,0.02,0.04,null,null,null,null,"75-100% de las necesidades de los acc. potenciales",null,null,{"$f":"IF(Q25=0,\"\",IF(Q25=\"Insuficiente\",1,IF(Q25=\"Ajustado\",2,IF(Q25=\"Suficiente\",3,FALSE))))","v":""},null,null,null,null,null,null,null,null,null,"Trabajo Conjunto","menos de 50 años",0,5,5,0]
[null,null,null,"Política de Gestión de Activos",null,{"$f":"IF(E27=\"SI\",5,SUMPRODUCT(($D$15=$AC$39:$AE$39)*($AA$47:$AA$51=D27)*($AC$47:$AE$51)))","v":3},null,0.02,0.06,7.4999999999999997E-2,{"$f":"IF(Q27=\"\",0,Q27*J27)","v":0},null,"Patrimonio Neto","0 a 500.000 U$S por Accionista",null,null,{"$f":"IF(P27=0,\"\",IF(P27=\"Reducido\",1,IF(P27=\"Ajustado\",2,IF(P27=\"Importante\",3,FALSE))))","v":""},null,null,null,null,null,null,null,null,null,"Trabajo Conjunto","50 a 65 años",0,5,3,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trabajo Conjunto","65 a 80 años",0,3,2,1]
[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,"Trabajo Conjunto","mas de 80 años",0,1,1,1]
[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,"Traspaso Bastón de Mando","menos de 50 años",0,3,5,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Traspaso Bastón de Mando","50 a 65 años",0,3,5,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Traspaso Bastón de Mando","65 a 80 años",0,3,5,3]
[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,"Traspaso Bastón de Mando","mas de 80 años",0,3,5,3]
[]
[]
[]
[]
[]
[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,"Gobierno Actual",null,"Dueño Controlante","Sociedad de Hermanos","Consorcio Primos"]
[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,"Reunión de Consejo de Familia",null,3,2,1]
[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,"Asamblea de Accionistas",null,5,1,1]
[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,"Reunión de Directorio",null,5,1,1]
[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,"Reunión de Gerentes (cuestiones operativas)",null,5,3,1]
[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,null,null,null,null,null,"Color si no esta definido el órgano de gobierno"]
[]
[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,"Definición de Políticas",null,"Dueño Controlante","Sociedad Hermanos","Consorcio Primos"]
[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,"Política de Distribución de Dividendos",null,3,1,1]
[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,"Política de Remuneración\n     (Competitividad externa / Equidad interna)",null,3,1,1]
[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,"Política de Endeudamiento",null,3,1,1]
[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,"Perfil de Riesgo",null,2,1,1]
[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,"Política de Gestión de Activos",null,3,1,1]
[]
[]
[]
[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,"Escala",null,"0 al 25% del Resultado de la Empresa",null,"75 al 100% del Resultado de la Empresa",null,null,4]
[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,"Negocio",null,"25 al 50% del Resultado de la Empresa",null,"50 al 75% del Resultado de la Empresa",null,null,3]
[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,null,"50 al 75% del Resultado de la Empresa",null,"25 al 50% del Resultado de la Empresa",null,null,2]
[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,null,"75 al 100% del Resultado de la Empresa",null,"0 al 25% del Resultado de la Empresa",null,null,1]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[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,null,null,null,null,null,null,3]
[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,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0-25% de las necesidades de los acc. potenciales","25-50% de las necesidades de los acc. potenciales","50-75% de las necesidades de los acc. potenciales","75-100% de las necesidades de los acc. potenciales",null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0-25% de las necesidades de los accionistas actuales",1,1,2,2]
[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,"25-50% de las necesidades de los accionistas actuales",2,2,3,3,null,null,4]
[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,"50-75% de las necesidades de los accionistas actuales",3,4,5,5,null,null,3]
[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,"75-100% de las necesidades de los accionistas actuales",4,5,5,5,null,null,2]
[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,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Situación actual",null,"Situación futura"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0 a 500.000 U$S por Accionista",1,"0 a 500.000 U$S por Accionista",1]
[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,"500.000 a 1.000.000 U$S por Accionista",1,"500.000 a 1.000.000 U$S por Accionista",1]
[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,"1.000.000 a 2.500.000 U$S por Accionista",2,"1.000.000 a 2.500.000 U$S por Accionista",2]
[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,"2.500.000 a 5.000.000 U$S por Accionista",3,"2.500.000 a 5.000.000 U$S por Accionista",3]
[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,"más de  5.000.000 U$S por Accionista",3,"más de  5.000.000 U$S por Accionista",3]

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

{"sheet":"Comentarios","index":4,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Agregar elasticidad de retiros."]
["Pensar desde que generación se contesta."]
["Agregar el criterio propio del que contesta.","En la Situación patrimonial, está agregada la columna. En el glosario habría que poner lo que significa cada color para el tablero propio."]
["Opcion criterio general y criterio propio.","En la Situación patrimonial, está agregada la columna. En el glosario habría que poner lo que significa cada color para el tablero propio."]
["Pensar las preguntas de interes de la empresa…"]
["Enriquecer el glosario / Introducción."]