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

{"sheet":"Formulario","index":0,"n_rows":81,"n_cols":15,"rows_kept":81,"cut":false,"hidden":false,"merged":[[72,4,72,11],[27,4,27,5],[12,6,12,11],[25,6,25,11],[40,6,40,11],[56,6,56,11],[58,4,58,5],[42,6,43,6],[42,8,43,8],[42,9,43,9],[42,10,43,10],[42,4,42,5],[42,7,43,7],[27,7,28,7],[58,7,59,7],[6,6,6,11],[58,6,59,6],[58,8,59,8],[58,9,59,9],[58,10,59,10],[58,11,59,11],[42,11,43,11],[27,6,28,6],[27,8,28,8],[27,9,28,9],[27,10,28,10],[27,11,28,11]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Formulario de Composición Accionaria / Shareholding Composition Form"]
[]
[null,null,null,null,null,null,"TIPO DE IDENTIFICACIÓN:"]
[null,null,null,null,null,null,"No DE IDENTIFICACIÓN:"]
[null,null,null,null,null,null,"RAZÓN SOCIAL:"]
[]
[null,null,null,null,null,null,"En esta formulario se debe relacionar  la información de los accionistas o asociados que tengan directa o indirectamente mas del 5% del capital social, aporte o participación. Se deben agregar tantas líneas como sean necesarias en cada una de las tablas."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Macro para agregar filas"]
[null,null,null,null,null,null,"ID","TIPO ID","Nombre / Razón Social","P. Natural / P. Jurídica","País de Origen","Participación accionaria",null,null,"Bloquear Hoja \"Listas\""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J16=Listas!$D$4,Formulario!L16>=5%),Listas!$D$6,\"\")","v":""},null,"Instrucciones"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J17=Listas!$D$4,Formulario!L17>=5%),Listas!$D$6,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J18=Listas!$D$4,Formulario!L18>=5%),Listas!$D$6,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J19=Listas!$D$4,Formulario!L19>=5%),Listas!$D$6,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J20=Listas!$D$4,Formulario!L20>=5%),Listas!$D$6,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J21=Listas!$D$4,Formulario!L21>=5%),Listas!$D$6,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J22=Listas!$D$4,Formulario!L22>=5%),Listas!$D$6,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J23=Listas!$D$4,Formulario!L23>=5%),Listas!$D$6,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J24=Listas!$D$4,Formulario!L24>=5%),Listas!$D$6,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L16:L24)","v":0},{"$f":"IF(L25>100%,Listas!D10,\"\")","v":""}]
[null,null,null,null,null,null,"Nota 1 / Note 1: Indique la composición accionaria de esta persona jurídica en la tabla de abajo. Se deben relacionar los accionistas o asociados que tengan directa o indirectamente más del 5% del capital social / Please indicate the shareholding composition of this legal entity in the table below. Shareholders or associates who have directly or indirectly more than 5% of the capital stock must be listed"]
[]
[null,null,null,null,"Repita en estas celdas el ID y Razón Social de las empresas indicadas en la tabla de arriba con una participación mayor o igual al 5%",null,"ID","TIPO ID","Nombre / Razón Social","P. Natural / P. Jurídica","País de Origen","Participación accionaria"]
[null,null,null,null,"ID ","Razón Social"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J30=Listas!$D$4,Formulario!L30>=5%),Listas!$D$7,\"\")","v":""},{"$f":"VLOOKUP(E30,$G$16:$L$24,5,0)","v":{"$error":"#N/A"}},{"$f":"L30*N30","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J31=Listas!$D$4,Formulario!L31>=5%),Listas!$D$7,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J32=Listas!$D$4,Formulario!L32>=5%),Listas!$D$7,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J33=Listas!$D$4,Formulario!L33>=5%),Listas!$D$7,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J34=Listas!$D$4,Formulario!L34>=5%),Listas!$D$7,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J35=Listas!$D$4,Formulario!L35>=5%),Listas!$D$7,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J36=Listas!$D$4,Formulario!L36>=5%),Listas!$D$7,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J37=Listas!$D$4,Formulario!L37>=5%),Listas!$D$7,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J38=Listas!$D$4,Formulario!L38>=5%),Listas!$D$7,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J39=Listas!$D$4,Formulario!L39>=5%),Listas!$D$7,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L40>100%,Listas!D10,\"\")","v":""}]
[null,null,null,null,null,null,"Nota 2 / Note 2: Indique la composición accionaria de esta persona jurídica en la tabla de abajo. Se deben relacionar los accionistas o asociados que tengan directa o indirectamente más del 5% del capital social / Please indicate the shareholding composition of this legal entity in the table below. Shareholders or associates who have directly or indirectly more than 5% of the capital stock must be listed"]
[]
[null,null,null,null,"Repita en estas celdas el ID y Razón Social de las empresas indicadas en la tabla de arriba con una participación mayor o igual al 5%",null,"ID","TIPO ID","Nombre / Razón Social","P. Natural / P. Jurídica","País de Origen","Participación accionaria"]
[null,null,null,null,"ID ","Razón Social"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J45=Listas!$D$4,Formulario!L45>=5%),Listas!$D$8,\"\")","v":""},{"$f":"O30","v":{"$error":"#N/A"}},{"$f":"L45*N45","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J46=Listas!$D$4,Formulario!L46>=5%),Listas!$D$8,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J47=Listas!$D$4,Formulario!L47>=5%),Listas!$D$8,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J48=Listas!$D$4,Formulario!L48>=5%),Listas!$D$8,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J49=Listas!$D$4,Formulario!L49>=5%),Listas!$D$8,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J50=Listas!$D$4,Formulario!L50>=5%),Listas!$D$8,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J51=Listas!$D$4,Formulario!L51>=5%),Listas!$D$8,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J52=Listas!$D$4,Formulario!L52>=5%),Listas!$D$8,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J53=Listas!$D$4,Formulario!L53>=5%),Listas!$D$8,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J54=Listas!$D$4,Formulario!L54>=5%),Listas!$D$8,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J55=Listas!$D$4,Formulario!L55>=5%),Listas!$D$8,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L56>100%,Listas!D10,\"\")","v":""}]
[null,null,null,null,null,null,"Nota 3 / Note 3: Indique la composición accionaria de esta persona jurídica en la tabla de abajo. Se deben relacionar los accionistas o asociados que tengan directa o indirectamente más del 5% del capital social / Please indicate the shareholding composition of this legal entity in the table below. Shareholders or associates who have directly or indirectly more than 5% of the capital stock must be listed"]
[]
[null,null,null,null,"Repita en estas celdas el ID y Razón Social de las empresas indicadas en la tabla de arriba con una participación mayor o igual al 5%",null,"ID","TIPO ID","Nombre / Razón Social","P. Natural / P. Jurídica","País de Origen","Participación accionaria"]
[null,null,null,null,"ID ","Razón Social"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O45","v":{"$error":"#N/A"}},{"$f":"L61*N61","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L72>100%,Listas!D10,\"\")","v":""}]
[null,null,null,null,"Declaro bajo la gravedad de juramento y con pleno conocimiento de las sanciones determinadas por el Código Penal, que los accionistas o asociados que tienen directa o indirectamente mas del 5% del capital social estan listados en las tablas de arriba. I declare under oath and with full knowledge of the penalties determined by the Penal Code, that Shareholders or associates who have directly or indirectly more than 5% of the capital stock are listed in the tables above."]
[]
[]
[]
[]
[null,null,null,null,"Firma Representante Legal"]
[null,null,null,null,"Nombres y Apellidos:"]
[null,null,null,null,"Documento de Identidad:"]
[null,null,null,null,"Fecha de diligenciamiento:"]

{"sheet":"Ejemplo","index":1,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[6,6,6,10],[7,6,7,10],[20,6,20,10],[22,4,22,5],[22,6,23,6],[22,7,23,7],[22,8,23,8],[22,9,23,9],[22,10,23,10],[34,6,34,10],[36,4,36,5],[36,6,37,6],[36,7,37,7],[36,8,37,8],[36,9,37,9],[36,10,37,10],[48,6,48,10],[50,4,50,5],[50,6,51,6],[50,7,51,7],[50,8,51,8],[50,9,51,9],[50,10,51,10]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Formulario de Composición Accionaria / Shareholding Composition Form"]
[null,null,null,null,null,null,"En esta formulario se debe relacionar  la información de los accionistas o asociados que tengan directa o indirectamente mas del 5% del capital social, aporte o participación. Se deben agregar tantas líneas como sean necesarias en cada una de las tablas."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Macro para agregar filas"]
[null,null,null,null,null,null,"ID","Nombre / Razón Social","P. Natural / P. Jurídica","País de Origen","Participación accionaria ",null,null,"Bloquear Hoja \"Listas\""]
[null,null,null,null,null,null,100258974,"Alberto Hernández  Gómez","Persona Natural / Natural Person","Colombia",0.3,{"$f":"IF(AND(I11=Listas!$D$4,Ejemplo!K11>=5%),Listas!$D$6,\"\")","v":""},null,"Instrucciones"]
[null,null,null,null,null,null,98563548,"José Gregorio Rujano Andrade","Persona Natural / Natural Person","Colombia",0.1,{"$f":"IF(AND(I12=Listas!$D$4,Ejemplo!K12>=5%),Listas!$D$6,\"\")","v":""}]
[null,null,null,null,null,null,801257842,"MERCADORA ASIA SA","Persona Jurídica / Legal Entity","Colombia",0.05,{"$f":"IF(AND(I13=Listas!$D$4,Ejemplo!K13>=5%),Listas!$D$6,\"\")","v":"Ver Nota 1 / See Note 1"}]
[null,null,null,null,null,null,99123547,"Pedro José Gonzáles Pérez","Persona Natural / Natural Person","Colombia",0.25,{"$f":"IF(AND(I14=Listas!$D$4,Ejemplo!K14>=5%),Listas!$D$6,\"\")","v":""}]
[null,null,null,null,null,null,100658942,"Jaime Humberto Sarmiento Castro","Persona Natural / Natural Person","Colombia",0.3,{"$f":"IF(AND(I15=Listas!$D$4,Ejemplo!K15>=5%),Listas!$D$6,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I16=Listas!$D$4,Ejemplo!K16>=5%),Listas!$D$6,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I17=Listas!$D$4,Ejemplo!K17>=5%),Listas!$D$6,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I18=Listas!$D$4,Ejemplo!K18>=5%),Listas!$D$6,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I19=Listas!$D$4,Ejemplo!K19>=5%),Listas!$D$6,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K11:K19)","v":1},{"$f":"IF(K20>100%,Listas!D10,\"\")","v":""}]
[null,null,null,null,null,null,"Nota 1 / Note 1: Indique la composición accionaria de esta persona jurídica en la tabla de abajo. / Please indicate the shareholding composition of this legal entity in the table below"]
[]
[null,null,null,null,"Repita en estas celdas el ID y Razón Social de las empresas indicadas en la tabla de arriba con una participación mayor o igual al 5%",null,"ID","Nombre / Razón Social","P. Natural / P. Jurídica","País de Origen","Participación accionaria "]
[null,null,null,null,"ID ","Razón Social"]
[null,null,null,null,801257842,"MERCADORA ASIA SA",569874,"José María Patiño Ortega","Persona Natural / Natural Person","Colombia",0.3,{"$f":"IF(AND(I25=Listas!$D$4,Ejemplo!K25>=5%),Listas!$D$7,\"\")","v":""},{"$f":"VLOOKUP(E25,$G$11:$K$19,5,0)","v":0.05},{"$f":"K25*M25","v":1.4999999999999999E-2}]
[null,null,null,null,801257843,"MERCADORA ASIA SA",12364789,"Luis Manuel Perea Roa","Persona Natural / Natural Person","Colombia",0.3,{"$f":"IF(AND(I26=Listas!$D$4,Ejemplo!K26>=5%),Listas!$D$7,\"\")","v":""}]
[null,null,null,null,801257844,"MERCADORA ASIA SA",10568974,"Jhon Jairo Rojas Rojas","Persona Natural / Natural Person","Colombia",0.3,{"$f":"IF(AND(I27=Listas!$D$4,Ejemplo!K27>=5%),Listas!$D$7,\"\")","v":""}]
[null,null,null,null,801257845,"MERCADORA ASIA SA",800256987,"ARTICULADORA GESECA SAS","Persona Jurídica / Legal Entity","Colombia",0.1,{"$f":"IF(AND(I28=Listas!$D$4,Ejemplo!K28>=5%),Listas!$D$7,\"\")","v":"Ver Nota 2 / See Note 2"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I29=Listas!$D$4,Ejemplo!K29>=5%),Listas!$D$7,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I30=Listas!$D$4,Ejemplo!K30>=5%),Listas!$D$7,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I31=Listas!$D$4,Ejemplo!K31>=5%),Listas!$D$7,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I32=Listas!$D$4,Ejemplo!K32>=5%),Listas!$D$7,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I33=Listas!$D$4,Ejemplo!K33>=5%),Listas!$D$7,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K25:K33)","v":0.99999999999999989},{"$f":"IF(K34>100%,Listas!D24,\"\")","v":""}]
[null,null,null,null,null,null,"Nota 2 / Note 2: Indique la composición accionaria de esta persona jurídica en la tabla de abajo. / Please indicate the shareholding composition of this legal entity in the table below"]
[]
[null,null,null,null,"Repita en estas celdas el ID y Razón Social de las empresas indicadas en la tabla de arriba con una participación mayor o igual al 5%",null,"ID","Nombre / Razón Social","P. Natural / P. Jurídica","País de Origen","Participación accionaria "]
[null,null,null,null,"ID ","Razón Social"]
[null,null,null,null,800256987,"ARTICULADORA GESECA SAS",65987456,"Angel Rodriguez Sanchez","Persona Natural / Natural Person","Colombia",0.4,{"$f":"IF(AND(I39=Listas!$D$4,Ejemplo!K39>=5%),Listas!$D$8,\"\")","v":""},{"$f":"N25","v":1.4999999999999999E-2},{"$f":"K39*M39","v":6.0000000000000001E-3}]
[null,null,null,null,800256987,"ARTICULADORA GESECA SAS",100569874,"Armando José Uribe García","Persona Natural / Natural Person","Colombia",0.2,{"$f":"IF(AND(I40=Listas!$D$4,Ejemplo!K40>=5%),Listas!$D$8,\"\")","v":""}]
[null,null,null,null,800256987,"ARTICULADORA GESECA SAS",25648975,"Andrea Margarita del Pilar Fuentes Paez","Persona Natural / Natural Person","Colombia",0.4,{"$f":"IF(AND(I41=Listas!$D$4,Ejemplo!K41>=5%),Listas!$D$8,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I42=Listas!$D$4,Ejemplo!K42>=5%),Listas!$D$8,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I43=Listas!$D$4,Ejemplo!K43>=5%),Listas!$D$8,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I44=Listas!$D$4,Ejemplo!K44>=5%),Listas!$D$8,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I45=Listas!$D$4,Ejemplo!K45>=5%),Listas!$D$8,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I46=Listas!$D$4,Ejemplo!K46>=5%),Listas!$D$8,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I47=Listas!$D$4,Ejemplo!K47>=5%),Listas!$D$8,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K39:K47)","v":1},{"$f":"IF(K48>100%,Listas!D38,\"\")","v":""}]
[null,null,null,null,null,null,"Nota 3 / Note 3: Indique la composición accionaria de esta persona jurídica en la tabla de abajo. / Please indicate the shareholding composition of this legal entity in the table below"]
[]
[null,null,null,null,"Repita en estas celdas el ID y Razón Social de las empresas indicadas en la tabla de arriba con una participación mayor o igual al 5%",null,"ID","Nombre / Razón Social","P. Natural / P. Jurídica","País de Origen","Participación accionaria "]
[null,null,null,null,"ID ","Razón Social"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N39","v":6.0000000000000001E-3},{"$f":"K53*M53","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K53:K61)","v":0},{"$f":"IF(K62>100%,Listas!D52,\"\")","v":""}]
[]
[]
[]
[]
[null,null,null,null,"Firma Representante Legal"]
[null,null,null,null,"Nombres y Apellidos:"]
[null,null,null,null,"Documento de Identidad:"]
[null,null,null,null,"Fecha de diligenciamiento:"]

{"sheet":"Listas","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,"Persona Natural / Natural Person"]
[null,null,null,"Persona Jurídica / Legal Entity"]
[]
[null,null,null,"Ver Nota 1 / See Note 1"]
[null,null,null,"Ver Nota 2 / See Note 2"]
[null,null,null,"Ver Nota 3 / See Note 3"]
[]
[null,null,null,"El porcentaje no puede ser mayor a 100%"]

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