{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["INICIO","VARIABLES","B. DATOS","Memo"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":"INICIO","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"VARIABLES","index":1,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[]
["Tipo Documento","Motivo devolución","Tipo de Cuenta","Bancos"]
["C.C.","Motivos Personales","CUENTA CORRIENTE","BANCO  BANCAMÍA S.A."]
["C.E.","Credito no Aprobado / Retoma","CUENTA DE AHORROS","BANCO AGRARIO DE COLOMBIA S.A. "]
["T.I.","Saldo a Favor",null,"BANCO CAJA SOCIAL S.A.  "]
["NIT.",null,null,"BANCO COMERCIAL AV VILLAS S.A. "]
["PASAPORTE",null,null,"BANCO COMPARTIR S.A.  "]
[null,null,null,"BANCO COOMEVA S.A. "]
[null,null,null,"BANCO DAVIVIENDA "]
[null,null,null,"BANCO DE BOGOTÁ"]
[null,null,null,"BANCO DE OCCIDENTE"]
[null,null,null,"BANCO FALABELLA S.A."]
[null,null,null,"BANCO FINANDINA S.A. "]
[null,null,null,"BANCO GNB SUDAMERIS S.A"]
[null,null,null,"BANCO MULTIBANK S.A."]
[null,null,null,"BANCO MUNDO MUJER S.A. "]
[null,null,null,"BANCO PICHINCHA S.A."]
[null,null,null,"BANCO POPULAR S.A."]
[null,null,null,"BANCO PROCREDIT COLOMBIA S.A."]
[null,null,null,"BANCO SANTANDER DE NEGOCIOS COLOMBIA S. A"]
[null,null,null,"BANCO SERFINANZA S.A."]
[null,null,null,"BANCO W S.A."]
[null,null,null,"BANCOLOMBIA S.A."]
[null,null,null,"BBVA COLOMBIA "]
[null,null,null,"EL BANCO COOPERATIVO COOPCENTRAL  "]
[null,null,null,"ITAÚ CORPBANCA COLOMBIA S.A."]
[null,null,null,"SCOTIABANK COLPATRIA S.A."]

{"sheet":"B. DATOS","index":2,"n_rows":7,"n_cols":16,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14]
["Nro. ID","Valor Devolucion","Tipo ID","Fecha","Nombre Cliente","Motivo devolucion","Recibos de caja","Tipo Cuenta","Banco","Nro de Cuenta","Pago Tesoreria","Fecha Cont","Columna1","Columna2",null,"devolución por desistimiento del  negocio según carta adjunta"]
[19226266,1473000,"C.C.","23/10/2019","PEDRO ANGEL GONZALEZ GOMEZ","Saldo a Favor","RUEIRU  43748754 $ 4.000.000","CUENTA DE AHORROS","BANCO CAJA SOCIAL S.A.  ",5454545454,{"$f":"IF(F3<>\"Saldo a favor\",(B3-(A3*4/1000)),B3)","v":1473000},{"$f":"D3+1","v":"2019-10-24"},{"$f":"IF(F3=\"Saldo a Favor\",\"\",$P$2)","v":""}]
[1013581965,660000,"C.E.","23/10/2019","GIRLEZA GARCIA BETANCUR","Motivos Personales","YERUERUEYU47854857 E83948934890 $ 500000","CUENTA DE AHORROS","BANCO COMPARTIR S.A.  ",5455454547,{"$f":"IF(F4<>\"Saldo a favor\",(Tabla[[#This Row],[Valor Devolucion]]-(Tabla[[#This Row],[Valor Devolucion]]*4/1000)),Tabla[[#This Row],[Valor Devolucion]])","v":657360},{"$f":"D4+1","v":"2019-10-24"},{"$f":"IF(F4=\"Saldo a Favor\",\"\",$P$2)","v":"devolución por desistimiento del  negocio según carta adjunta"}]
[3764564756,6347564,"T.I.","24/10/2019","iosdfhodhfdhkfhkd epiofjoedfo disjdfosk","Credito no Aprobado / Retoma","thgho8495894584jhkerkel","CUENTA DE AHORROS","BANCO  BANCAMÍA S.A.",5657678687879]
[999999999,8909890,"NIT.","24/10/2019","podbdgsgñ pdpfgppfg´ edfofpdkfgkf","Motivos Personales","54859485948jhfdhghkcjdkgjdkfñlaskdñsñdfklsñ{","CUENTA CORRIENTE","BANCO DE BOGOTÁ",5848695869587956]
[8986985,898989,"C.C.","24/10/2019","bjhdbjhdjlñsñ{dn  dokofpfgpk  foofknf","Saldo a Favor","efnjdjfeklfk 3458958940895  04599509","CUENTA DE AHORROS","BANCOLOMBIA S.A."]

{"sheet":"Memo","index":3,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,10,2,10],[1,13,2,13],[33,0,33,1],[34,0,34,1],[13,0,16,6],[2,1,2,4],[6,2,6,6],[8,2,8,3],[10,2,10,3],[19,0,19,6]]}
[]
[null,null,null,null,null,null,null,null,null,null,"DEVOLUCIONES",null,null,"SALDO A FAVOR"]
[null,"MEMORANDO"]
[]
[null,null,null,null,null,null,null,null,null,null,"Con la presente me permito solicitar TRANSFERENCIA por valor de $ "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(K10,Tabla[],11,FALSE)","v":1473000}]
[null,"Para:","CONTABILIDAD  Atn: Sr. Gildardo Cuellar, Andrea Barrera.",null,null,null,null,null,null,null,"  a nombre de ","   "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(K10,Tabla[],5,FALSE)","v":"PEDRO ANGEL GONZALEZ GOMEZ"},"  "]
[null,"De:","Dirección Comercial.",null,null,null,null,null,null,null,{"$f":"VLOOKUP(K10,Tabla[],3,FALSE)","v":"C.C."},"  "]
[null,null,null,null,null,null,null,null,null,null,19226266,"  "]
[null,"Fecha:",null,null,null,null,null,null,null,null,"Por concepto de devolución por desistimiento del negocio, ",null,null,"Por concepto de  "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(K10,Tabla[],6,FALSE)","v":"Saldo a Favor"},null,null,{"$f":"VLOOKUP(K10,Tabla[],6,FALSE)","v":"Saldo a Favor"}]
[null,null,null,null,null,null,null,null,null,null,"  según recibo(s) de caja:  ",null,null," como compra del vehiculo "]
[{"$f":"IF(K12=\"Saldo a Favor\",N27,K27)","v":"Con la presente me permito solicitar TRANSFERENCIA por valor de $ 1473000  a nombre de    PEDRO ANGEL GONZALEZ GOMEZ  C.C.  19226266  Por concepto de  Saldo a Favor como compra del vehiculo RUEIRU  43748754 $ 4.000.000"},null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(K10,'B. DATOS'!$A$2:$N$447,7,FALSE)","v":"RUEIRU  43748754 $ 4.000.000"},null,null,{"$f":"VLOOKUP(K10,'B. DATOS'!$A$2:$N$447,7,FALSE)","v":"RUEIRU  43748754 $ 4.000.000"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"FAVOR CONSIGNAR EN LA ",null,null,"FAVOR CONSIGNAR EN LA "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(K10,'B. DATOS'!$A$2:$N$447,8,FALSE)","v":"CUENTA DE AHORROS"},null,null,{"$f":"VLOOKUP(K10,'B. DATOS'!$A$2:$N$447,8,FALSE)","v":"CUENTA DE AHORROS"}]
[{"$f":"CONCATENATE(K18,K19,K20,K21,K22,K23)","v":"FAVOR CONSIGNAR EN LA CUENTA DE AHORROS DE   BANCO CAJA SOCIAL S.A.   Nro.  5454545454"},null,null,null,null,null,null,null,null,null," DE   ",null,null," DE   "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(K10,'B. DATOS'!$A$2:$N$447,9,FALSE)","v":"BANCO CAJA SOCIAL S.A.  "},null,null,{"$f":"VLOOKUP(K10,'B. DATOS'!$A$2:$N$447,9,FALSE)","v":"BANCO CAJA SOCIAL S.A.  "}]
[null,null,null,null,null,null,null,null,null,null," Nro.  ",null,null," Nro.  "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(K10,'B. DATOS'!$A$2:$N$447,10,FALSE)","v":5454545454},null,null,{"$f":"VLOOKUP(K10,'B. DATOS'!$A$2:$N$447,10,FALSE)","v":5454545454}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(R15,R16,R17,S17,R18,S18,R19,S19,R20,S20,R21,R22,R23,R24)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(K5,K6,K7,L7,K8,L8,K9,L9,K10,L10,K11,K12,K13,K14)","v":"Con la presente me permito solicitar TRANSFERENCIA por valor de $ 1473000  a nombre de    PEDRO ANGEL GONZALEZ GOMEZ  C.C.  19226266  Por concepto de devolución por desistimiento del negocio, Saldo a Favor  según recibo(s) de caja:  RUEIRU  43748754 $ 4.000.000"},null,null,{"$f":"CONCATENATE(K5,K6,K7,L7,K8,L8,K9,L9,K10,L10,N11,N12,N13,N14,)","v":"Con la presente me permito solicitar TRANSFERENCIA por valor de $ 1473000  a nombre de    PEDRO ANGEL GONZALEZ GOMEZ  C.C.  19226266  Por concepto de  Saldo a Favor como compra del vehiculo RUEIRU  43748754 $ 4.000.000"}]
["Atentamente,"]
[]
[]
[]
[]
[]
["KELLY J. BELTRAN C."]
["Gerente Comercial"]