{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["RANKING","CATASTRO","Hoja6","Hoja1","Ranking por a,p,p","PARA REPORTE TOTAL"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":3},"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":"RANKING","index":0,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"RANKING"]
[null,"SECTOR FINANCIERO POPULAR Y SOLIDARIO SEGMENTO 1"]
[null,"PERIODO DEL 1 ENERO DEL 2018 AL 30 DE SEPTIEMBRE DEL 2018"]
[null,"(Dólares)",null,"*Seleccionar una solo fecha ",null,null,null,"*Seleccionar una solo cuenta"]
[]
[null,"ENTIDAD","DÓLARES","PROCENTAJE"]
[null,"Etiquetas de fila","Suma de VALOR","Suma de VALOR2"]
[null,"JUVENTUD ECUATORIANA PROGRESISTA LTDA",1821662197.21,0.1937799299487534]
[null,"JARDIN AZUAYO LTDA",835554835.00999999,8.8882427073780176E-2]
[null,"POLICIA NACIONAL LTDA",767181673.32000005,8.1609208963992722E-2]
[null,"COOPROGRESO LTDA",491638380.19999999,5.2298198327432252E-2]
[null,"29 DE OCTUBRE LTDA",483343761.31,5.1415855448539813E-2]
[null,"OSCUS LTDA",369806243.83999997,3.9338263776720277E-2]
[null,"SAN FRANCISCO LTDA",326695759.00999999,3.4752371428946452E-2]
[null,"RIOBAMBA LTDA",300393354.80000001,3.195444431979097E-2]
[null,"DE LA PEQUEÑA EMPRESA DE COTOPAXI LTDA",298273820.69999999,3.1728978165829473E-2]
[null,"ALIANZA DEL VALLE LTDA",294200150.91000003,3.1295640169493183E-2]
[null,"VICENTINA MANUEL ESTEBAN GODOY ORTEGA LTDA",278847848.12,2.9662533787994664E-2]
[null,"ANDALUCIA LTDA",250402159.62,2.6636614090414963E-2]
[null,"MUSHUC RUNA LTDA",219362338.63,2.3334742675244647E-2]
[null,"DE LA PEQUEÑA EMPRESA BIBLIAN LTDA",219270579.84,2.3324981803044733E-2]
[null,"CAJA CENTRAL FINANCOOP",212824460.61000001,2.263927369824691E-2]
[null,"TULCAN LTDA",186992297.63,1.9891368658357604E-2]
[null,"ATUNTAQUI LTDA",184550389.41,1.9631609848772814E-2]
[null,"EL SAGRARIO LTDA",183419450.16999999,1.9511305806102802E-2]
[null,"23 DE JULIO LTDA",166989066.97999999,1.7763518258847498E-2]
[null,"PABLO MUÑOZ VEGA LTDA",166339612.11000001,1.7694432278248996E-2]
[null,"SAN JOSE LTDA",149894149.43000001,1.5945040645164641E-2]
[null,"DE LOS SERVIDORES PUBLICOS DEL MINISTERIO DE EDUCACION Y CULTURA",145950148.78,1.552549624728156E-2]
[null,"CAMARA DE COMERCIO DE AMBATO LTDA",144662159.03,1.5388485903699763E-2]
[null,"FERNANDO DAQUILEMA",131802660.43000001,1.4020552407741717E-2]
[null,"DE LA PEQUEÑA EMPRESA DE PASTAZA LTDA",131018361.48999999,1.3937122343767807E-2]
[null,"CHIBULEO LTDA",128556080.01000001,1.3675196321786737E-2]
[null,"PILAHUIN TIO LTDA",126187016.98999999,1.3423186444893594E-2]
[null,"SANTA ROSA LTDA",118585187.62,1.2614539284592909E-2]
[null,"AMBATO LTDA",105745206.18000001,1.124868193310522E-2]
[null,"15 DE ABRIL LTDA",81397034.099999994,8.6586369251620242E-3]
[null,"CONSTRUCCION COMERCIO Y PRODUCCION LTDA",79128896.409999996,8.4173630142495171E-3]
[null,"Total general",9400675279.9000015,1]

{"sheet":"CATASTRO","index":1,"n_rows":27,"n_cols":20,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["NOM_RAZON_SOCIAL","NUM_RUC","Direccin","Telfono","Email","NombreGerente","SEGMENTO","ACTIVO","PASIVO","PATRIMONIO","CARTERA POR VENCER","CARTERA QUE NO DEVENGA INTERES","CARTERA VENCIDA","Microcredito2","Comercial","Consumo3","Inmobiliario","Productivo","Vivienda4","Educativo"]
["23 DE JULIO LTDA","1790093204001","SUCRE  E132 JUAN MONTALVO Y TERAN","022362191","lecheverria@coop23dejulio.fin.ec","WALTER EDUARDO AGUIRRE SOSA",1]
["29 DE OCTUBRE LTDA","1790567699001","MARISCAL SUCRE  OE6-140  CAÑARIS","022640509","eeguez@29deoctubre.fin.ec","EGUEZ LUPERA EDWIN CARLOS MARIO",1]
["ALIANZA DEL VALLE LTDA","1790501469001","DUCHICELA S/N  HUANCAVILCA","022998600","jzambrano@alianzadelvalle.fin.ec","CADENA LUCERO HECTOR ROLANDO",1]
["ANDALUCIA LTDA","1790325083001","JORGE PIEDRA  OE5-95  AZOGUES","023301920","gerenciageneral@andalucia.fin.ec","ORTIZ PAREDES MAURICIO BOLIVAR",1]
["ATUNTAQUI LTDA","1090033456001","RIO AMAZONAS 1217 SUCRE","062909399","secretaria@atuntaqui.fin.ec","BENALCAZAR MOLINA RODRIGO SANTIAGO",1]
["CAJA CENTRAL FINANCOOP","1791708040001","AV. 6 DE DICIEMBRE N33-55 AV. ELOY ALFARO","022553117","gerencia@financoop.net","MARIN LUIS  BAUTISTA QUISPE",1]
["CAMARA DE COMERCIO DE AMBATO LTDA","1890080967001","MONTALVO 3-43 ROCAFUERTE","032826057","vvaldez@ccca.fin.ec","RAMIRO MARCELO  PORTERO LOPEZ",1]
["COOPROGRESO LTDA","1790451801001","AV. MANUEL CÓRDOVA GALARZA  S/N  MARIETA DE VEINTIMILLA 9380","024000900","gerencia@cooprogreso.fin.ec","MUÑOZ LOPEZ WASHINGTON STALIN",1]
["DE LA PEQUEÑA EMPRESA BIBLIAN LTDA","0390027923001","MARISCAL SUCRE 3-38 DANIEL MUÑOZ","072230836","info@cacpebiblian.fin.ec","GONZALEZ BUSTOS JUAN PABLO",1]
["DE LA PEQUEÑA EMPRESA DE COTOPAXI LTDA","0590052000001","SANCHEZ DE ORELLANA 1544 RAMIREZ FITA","032807900","vescobar@cacpeco.com","VIRGINIA DEL CARMEN ESCOBAR  JACOME",1]
["DE LA PEQUEÑA EMPRESA DE PASTAZA LTDA","1690012606001","Atahualpa S/N GENERAL VILLAMIL","032883042","secretariacacpepas@gmail.com","ACUÑA CARRASCO EDGAR MAXTRANCEL",1]
["DE LOS SERVIDORES PUBLICOS DEL MINISTERIO DE EDUCACION Y CULTURA","1790979016001","EL ORO  N19-22  AV. UNIVERSITARIA","022237782","vinicioa@cacspmec.fin.ec","ANTAMBA GUERRA WASHINGTON VINICIO",1]
["EL SAGRARIO LTDA","1890037646001","SUCRE  S/N QUITO","032997999","fvelastegui@elsagrario.fin.ec","FREDY PATRICIO VELASTEGUI MORENO",1]
["JARDIN AZUAYO LTDA","0190155722001","BENIGNO MALO  27638 ENTRE GRAN COLOMBIA Y SIMON BOLIVAR. 9-75 GRAN COLOMBIA","072833255","coopjardinazuayo@jardinazuayo.fin.ec","URGILES MARTINEZ JUAN CARLOS",1]
["JUVENTUD ECUATORIANA PROGRESISTA LTDA","0190115798001","AV. ORDOÑEZ LAZO, KM6 SAYAUSÍ SN CENTRO PARROQUIAL SAYAUSI","074135000","falvear@coopjep.fin.ec","SALDAÑA AVILA KARINA DEL ROSARIO",1]
["MUSHUC RUNA LTDA","1890141877001","MONTALVO S/N ENTRE JUAN BENIGNO VELA Y Av. CEVALLOS","032826810","contador@mushucruna.com","CHANGO PACHA LUIS ALFONSO",1]
["OSCUS LTDA","1890001323001","LALAMA  0639 SUCRE Y BOLIVAR","032821131","asegura@oscus.coop","GALLEGOS BAYAS FREDDY BLAS",1]
["PABLO MUÑOZ VEGA LTDA","0490001883001","COLON   S/N 10 DE AGOSTO","062980382","carlosacosta@cpmv.fin.ec","CARLOS ALONSO ACOSTA CARRERA",1]
["PILAHUIN TIO LTDA","1091720902001","SUCRE 11-09 MORALES","062927234","coac@pilahuintio.ec","ANGEL ESTEBAN MAZABANDA MOPOCITA",1]
["POLICIA NACIONAL LTDA","1790866084001","VOZ ANDES N 42 – 42  AV. AMÉRICA","3984999","alejandro.rivadeneira@cooperando.fin.ec","LASCANO ENRIQUE MILTON",1]
["RIOBAMBA LTDA","0690045389001","10 DE AGOSTO  S/N  CRISTOBAL COLON","032962431","riobamba@cooprio.fin.ec","MORALES MOROCHO SEGUNDO PEDRO",1]
["SAN FRANCISCO LTDA","1890003628001","MONTALVO   S/N 12 DE NOVIEMBRE","032824270","sistemas1@coac-sanfra.com","PAREDES LOPEZ ESTUARDO RIQUELMEN",1]
["SAN JOSE LTDA","0290003288001","CHIMBORAZO 536 TRES DE MARZO","032630297","coopsanjose@andinanet.net","CAPUZ CAMACHO CESAR LUIS",1]
["SANTA ROSA LTDA","0790024656001","CUENCA  S/N  LIBERTAD","072944190","secretaria@coopacs.fin.ec","SOLANO DURAN MANUEL AGUSTIN",1]
["TULCAN LTDA","0490002669001","SUCRE 54061 ATAHUALPA","062960404","info@cooptulcan.com","MOSQUERA LOPEZ MARCO ERIC ORLANDO",1]
["VICENTINA MANUEL ESTEBAN GODOY ORTEGA LTDA","1190068389001","BOLÍVAR  1056 AZUAY","072584800","abustos@coopmego.com","ALBERTO GEOVANNY BUSTOS PARRA",1]

{"sheet":"Hoja6","index":2,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
["NOM_RAZON_SOCIAL","NUM_RUC","Telfono","Direccin","Email","NombreGerente","SEGMENTO"]
["29 DE OCTUBRE LTDA","1790567699001","022640509","MARISCAL SUCRE  OE6-140  CAÑARIS","eeguez@29deoctubre.fin.ec","EGUEZ LUPERA EDWIN CARLOS MARIO",1]
["Total general"]

{"sheet":"Hoja1","index":3,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":true,"merged":[[1,0,2,10],[18,4,18,9],[24,4,24,9]]}
[]
["REPORTE EJECUTIVO "]
[]
[]
[]
[]
[]
[]
["Razón Social: ",{"$f":"+Hoja6!A5","v":"29 DE OCTUBRE LTDA"}]
["Número de RUC: ",{"$f":"+Hoja6!B5","v":"1790567699001"},null,null,null,null,null,"Segmento: ",{"$f":"+Hoja6!G5","v":1}]
["Dirección:",{"$f":"+Hoja6!D5","v":"MARISCAL SUCRE  OE6-140  CAÑARIS"},null,null,null,null,null,"Telefono:",{"$f":"+Hoja6!C5","v":"022640509"}]
["Correo electronico : ",{"$f":"+Hoja6!E5","v":"eeguez@29deoctubre.fin.ec"}]
["Representante Legal:",{"$f":"+Hoja6!F5","v":"EGUEZ LUPERA EDWIN CARLOS MARIO"}]
["Fecha de corte:"]
[]
["Cuentas principales"]
["Cuenta","Valor","Ranking"]
["Activos: ",{"$f":"+VLOOKUP(B9,'Ranking por a,p,p'!B2:E28,2,0)","v":354485209.56999999},{"$f":"+VLOOKUP(B9,'Ranking por a,p,p'!B2:E29,4,0)","v":5}]
["Pasivos:",{"$f":"+VLOOKUP(B9,'Ranking por a,p,p'!H2:I29,2,0)","v":305817226.87},{"$f":"+VLOOKUP(B9,'Ranking por a,p,p'!H2:K29,4,0)","v":5},null,"Grafico en barra del como se encuentra la coac frente al sistema"]
["Patrimonio:",{"$f":"+VLOOKUP(B9,'Ranking por a,p,p'!N2:O29,2,0)","v":48667982.700000003},{"$f":"+VLOOKUP(B9,'Ranking por a,p,p'!N2:Q28,4,0)","v":4}]
[]
[]
[]
[]
["Cartera por tipo de crédito tabla pintado los porcentajes",null,null,null,"Composicion de la cartera"]
["Microcredito",null,null,null,null,null,"3 rubros(vencer,nodevenga,vencido)"]
["Comercial"]
["Consumo"]
["Inmobiliario"]
["Productivo"]
["Vivienda"]
["Educativo"]

{"sheet":"Ranking por a,p,p","index":4,"n_rows":29,"n_cols":17,"rows_kept":29,"cut":false,"hidden":true,"merged":[[0,13,0,15],[0,7,0,9],[0,1,0,3]]}
[null,"ACTIVOS",null,null,null,null,null,"Pasivo",null,null,null,null,null,"Patrimonio"]
[null,"ENTIDAD","DÓLARES","PROCENTAJE","Ranking",null,null,"ENTIDAD","DÓLARES","PROCENTAJE","Ranking",null,null,"ENTIDAD","DÓLARES","PROCENTAJE","Ranking"]
[null,"JUVENTUD ECUATORIANA PROGRESISTA LTDA",1187758361.24,0.17883653065190599,1,null,null,"JUVENTUD ECUATORIANA PROGRESISTA LTDA",1057048698.23,0.18661142648018128,1,null,null,"JUVENTUD ECUATORIANA PROGRESISTA LTDA",130709663.01000001,0.13376625491213717,1]
[null,"JARDIN AZUAYO LTDA",639156944.39999998,9.6235576366927922E-2,2,null,null,"JARDIN AZUAYO LTDA",552710815.58000004,9.7575593157739102E-2,2,null,null,"POLICIA NACIONAL LTDA",102546955.84,0.1049449743765896,2]
[null,"POLICIA NACIONAL LTDA",531928832.02999997,8.0090622788504956E-2,3,null,null,"POLICIA NACIONAL LTDA",429381876.19,7.5803096446477786E-2,3,null,null,"JARDIN AZUAYO LTDA",86446128.819999993,8.8467636115157677E-2,3]
[null,"COOPROGRESO LTDA",364240396.5,5.4842374475335284E-2,4,null,null,"COOPROGRESO LTDA",324624297.61000001,5.7309188638675082E-2,4,null,null,"29 DE OCTUBRE LTDA",48667982.700000003,4.9806063530357512E-2,4]
[null,"29 DE OCTUBRE LTDA",354485209.56999999,5.3373570850496391E-2,5,null,null,"29 DE OCTUBRE LTDA",305817226.87,5.3988987493182129E-2,5,null,null,"SAN FRANCISCO LTDA",48569400.009999998,4.9705175524552954E-2,5]
[null,"SAN FRANCISCO LTDA",295886817.76999998,4.4550620464903955E-2,6,null,null,"OSCUS LTDA",249940859.65000001,4.4124571018411711E-2,6,null,null,"RIOBAMBA LTDA",43885222.509999998,4.4911460453382124E-2,6]
[null,"OSCUS LTDA",286800106.89999998,4.3182466890862803E-2,7,null,null,"SAN FRANCISCO LTDA",247317417.75999999,4.3661428464808902E-2,7,null,null,"DE LA PEQUEÑA EMPRESA DE COTOPAXI LTDA",43162480.630000003,4.417181755071195E-2,7]
[null,"RIOBAMBA LTDA",264582463.12,3.9837235686826483E-2,8,null,null,"RIOBAMBA LTDA",220697240.61000001,3.8961901149336314E-2,8,null,null,"COOPROGRESO LTDA",39616098.890000001,4.0542505127097977E-2,8]
[null,"VICENTINA MANUEL ESTEBAN GODOY ORTEGA LTDA",247177992.77000001,3.7216706800817623E-2,9,null,null,"VICENTINA MANUEL ESTEBAN GODOY ORTEGA LTDA",208840209.80000001,3.6868660377195356E-2,9,null,null,"VICENTINA MANUEL ESTEBAN GODOY ORTEGA LTDA",38337782.969999999,3.9234296313187401E-2,9]
[null,"CAJA CENTRAL FINANCOOP",215084987,3.2384577642739915E-2,10,null,null,"CAJA CENTRAL FINANCOOP",200960704.74000001,3.5477612186448272E-2,10,null,null,"OSCUS LTDA",36859247.25,3.7721185641307775E-2,10]
[null,"DE LA PEQUEÑA EMPRESA DE COTOPAXI LTDA",211259111.72,3.1808529277929591E-2,11,null,null,"ALIANZA DEL VALLE LTDA",171772925.21000001,3.0324800227072308E-2,11,null,null,"MUSHUC RUNA LTDA",32757386.93,3.3523404998746391E-2,11]
[null,"ALIANZA DEL VALLE LTDA",201602637.22,3.0354588430815108E-2,12,null,null,"DE LA PEQUEÑA EMPRESA DE COTOPAXI LTDA",168096631.09,2.9675787091686345E-2,12,null,null,"ALIANZA DEL VALLE LTDA",29829712.010000002,3.0527267600560081E-2,12]
[null,"ANDALUCIA LTDA",191198132.28999999,2.8788019315789636E-2,13,null,null,"ANDALUCIA LTDA",162823783.03999999,2.874491825104411E-2,13,null,null,"DE LOS SERVIDORES PUBLICOS DEL MINISTERIO DE EDUCACION Y CULTURA",29302480.469999999,2.9987706967066874E-2,13]
[null,"MUSHUC RUNA LTDA",175740008.28999999,2.6460544842226767E-2,14,null,null,"MUSHUC RUNA LTDA",142982621.36000001,2.5242158642779525E-2,14,null,null,"ANDALUCIA LTDA",28374349.25,2.9037871778853329E-2,14]
[null,"ATUNTAQUI LTDA",152237840.31999999,2.2921907422604446E-2,15,null,null,"ATUNTAQUI LTDA",128322006.81999999,2.2653973068201379E-2,15,null,null,"EL SAGRARIO LTDA",26267293.43,2.6881543322014916E-2,15]
[null,"DE LA PEQUEÑA EMPRESA BIBLIAN LTDA",150449789.03,2.2652686931495945E-2,16,null,null,"DE LA PEQUEÑA EMPRESA BIBLIAN LTDA",125741884.73,2.2198478194110763E-2,16,null,null,"23 DE JULIO LTDA",25818719.09,2.6422479254908468E-2,16]
[null,"EL SAGRARIO LTDA",144183227.69999999,2.1709153192693537E-2,17,null,null,"EL SAGRARIO LTDA",117915934.27,2.0816884534945151E-2,17,null,null,"DE LA PEQUEÑA EMPRESA BIBLIAN LTDA",24707904.300000001,2.5285688516277736E-2,17]
[null,"CAMARA DE COMERCIO DE AMBATO LTDA",129837635.56,1.954918866439799E-2,18,null,null,"CAMARA DE COMERCIO DE AMBATO LTDA",113776903.23999999,2.0086179803888406E-2,18,null,null,"ATUNTAQUI LTDA",23915833.5,2.447509546522569E-2,18]
[null,"23 DE JULIO LTDA",129815215.19,1.9545812909431678E-2,19,null,null,"SAN JOSE LTDA",105664663.06999999,1.8654044545968494E-2,19,null,null,"TULCAN LTDA",21028387.280000001,2.1520127498702381E-2,19]
[null,"PABLO MUÑOZ VEGA LTDA",124812786.61,1.8792615119986381E-2,20,null,null,"PABLO MUÑOZ VEGA LTDA",104427417.02,1.8435621070603474E-2,20,null,null,"SANTA ROSA LTDA",20897618.460000001,2.1386300703438277E-2,20]
[null,"TULCAN LTDA",124384789.53,1.8728173129583182E-2,21,null,null,"23 DE JULIO LTDA",103996496.09999999,1.8359546271291004E-2,21,null,null,"PABLO MUÑOZ VEGA LTDA",20385369.59,2.0862073103542836E-2,21]
[null,"SAN JOSE LTDA",121429557.20999999,1.8283214363031174E-2,22,null,null,"TULCAN LTDA",103356402.25,1.824654407316172E-2,22,null,null,"DE LA PEQUEÑA EMPRESA DE PASTAZA LTDA",18698992.859999999,1.9136261144821632E-2,22]
[null,"DE LOS SERVIDORES PUBLICOS DEL MINISTERIO DE EDUCACION Y CULTURA",118232610.41,1.7801861511266077E-2,23,null,null,"DE LOS SERVIDORES PUBLICOS DEL MINISTERIO DE EDUCACION Y CULTURA",88930129.939999998,1.5699729286796152E-2,23,null,null,"CAMARA DE COMERCIO DE AMBATO LTDA",16060732.32,1.6436305963304004E-2,23]
[null,"SANTA ROSA LTDA",93632129.5,1.4097855038333421E-2,24,null,null,"PILAHUIN TIO LTDA",81969329.540000007,1.4470869259568553E-2,24,null,null,"SAN JOSE LTDA",15764894.140000001,1.6133549728704923E-2,24]
[null,"DE LA PEQUEÑA EMPRESA DE PASTAZA LTDA",93285164.930000007,1.4045613823299457E-2,25,null,null,"DE LA PEQUEÑA EMPRESA DE PASTAZA LTDA",74586172.069999993,1.3167446295506851E-2,25,null,null,"CAJA CENTRAL FINANCOOP",14124282.26,1.4454572812245648E-2,25]
[null,"PILAHUIN TIO LTDA",92384164.489999995,1.3909953407794383E-2,26,null,null,"SANTA ROSA LTDA",72734511.040000007,1.2840553970919859E-2,26,null,null,"PILAHUIN TIO LTDA",10414834.949999999,1.0658381597104655E-2,26]
[null,"Total general",6641586911.2999992,1,null,null,null,"Total general",5664437157.8299999,1,null,null,null,"Total general",977149753.47000003,1]

{"sheet":"PARA REPORTE TOTAL","index":5,"n_rows":171,"n_cols":14,"rows_kept":171,"cut":false,"hidden":true,"merged":[]}
["NOM_RAZON_SOCIAL","23 DE JULIO LTDA"]
[]
[null,"Etiquetas de columna"]
["Valores","2016-12-31"]
["Suma de A1_DE_1_A_30_DIAS",118752.28]
["Suma de A1_DE_31_A_90DIAS",87811.94]
["Suma de A1_DE_91_A_180_DIAS",134405.81]
["Suma de A1_DE_181_A_360_DIAS",252709.37]
["Suma de A1_DE_MAS_DE_360_DIAS",755762.38]
["Suma de A2_DE_1_A_30_DIAS",11600.33]
["Suma de A2_DE_31_A_90DIAS",10518.22]
["Suma de A2_DE_91_A_180_DIAS",15065]
["Suma de A2_DE_181_A_360_DIAS",29024.38]
["Suma de A2_DE_MAS_DE_360_DIAS",47963.56]
["Suma de A3_DE_1_A_30_DIAS",0]
["Suma de A3_DE_31_A_90DIAS",7378.38]
["Suma de A3_DE_91_A_180_DIAS",1791.74]
["Suma de A3_DE_181_A_360_DIAS",9642.61]
["Suma de A3_DE_MAS_DE_360_DIAS",5301.96]
["Suma de A4_DE_1_A_30_DIAS",1282868.3899999999]
["Suma de A4_DE_31_A_90DIAS",2503954.13]
["Suma de A4_DE_91_A_180_DIAS",3746133.25]
["Suma de A4_DE_MAS_DE_180_DIAS",26191357.07]
["Suma de A5_DE_1_A_30_DIAS",123525.64]
["Suma de A5_DE_31_A_90DIAS",115387.24]
["Suma de A5_DE_91_A_180_DIAS",151032.64000000001]
["Suma de A5_DE_MAS_DE_180_DIAS",520743.2]
["Suma de A6_DE_31_A_90DIAS",275.52]
["Suma de A6_DE_91_A_180_DIAS",101403.53]
["Suma de A6_DE_181_A_360_DIAS",110833.12]
["Suma de A6_DE_MAS_DE_360_DIAS",663500.32999999996]
["Suma de A7_DE_1_A_30_DIAS",129165.12]
["Suma de A7_DE_31_A_90DIAS",214687.87]
["Suma de A7_DE_181_A_360_DIAS",936038.08]
["Suma de A7_DE_MAS_DE_360_DIAS",6281839.9900000002]
["Suma de A8_DE_1_A_30_DIAS",23186.37]
["Suma de A8_DE_31_A_90DIAS",14632.91]
["Suma de A8_DE_91_A_360_DIAS",61548.58]
["Suma de A8_DE_MAS_DE_360_DIAS",265241.65999999997]
["Suma de A9_DE_1_A_30_DIAS",0]
["Suma de A9_DE_31_A_90DIAS",5253.35]
["Suma de A9_DE_91_A_360_DIAS",41731.9]
["Suma de A9_DE_MAS_DE_360_DIAS",50346.21]
["Suma de A10_DE_1_A_30_DIAS",1416981.96]
["Suma de A10_DE_31_A_90DIAS",2607159.29]
["Suma de A10_DE_91_A_180_DIAS",3853512.2]
["Suma de A10_DE_181_A_360_DIAS",7111740.96]
["Suma de A10_DE_MAS_DE_360_DIAS",18473253.010000002]
["Suma de A11_DE_1_A_30_DIAS",352035.74]
["Suma de A11_DE_31_A_90DIAS",330625.33]
["Suma de A11_DE_91_A_180_DIAS",445944.35]
["Suma de A11_DE_181_A_360_DIAS",703430.96]
["Suma de A11_DE_MAS_DE_360_DIAS",997249.55]
["Suma de A12_DE_1_A_30_DIAS",4]
["Suma de A12_DE_31_A_90DIAS",280973.31]
["Suma de A12_DE_91_A_180_DIAS",510141.02]
["Suma de A12_DE_181_A_360_DIAS",696534.49]
["Suma de A12_DE_MAS_DE_360_DIAS",1346172.34]
["Suma de A13_DE_1_A_30_DIAS",0]
["Suma de A13_DE_31_A_90DIAS",0]
["Suma de A13_DE_91_A_180_DIAS",0]
["Suma de A13_DE_181_A_360_DIAS",0]
["Suma de A13_DE_MAS_DE_360_DIAS",0]
["Suma de A14_DE_1_A_30_DIAS",0]
["Suma de A14_DE_31_A_90DIAS",0]
["Suma de A14_DE_91_A_180_DIAS",0]
["Suma de A14_DE_181_A_360_DIAS",0]
["Suma de A14_DE_MAS_DE_360_DIAS",0]
["Suma de A15_DE_1_A_30_DIAS",0]
["Suma de A15_DE_31_A_90DIAS",0]
["Suma de A15_DE_91_A_180_DIAS",0]
["Suma de A15_DE_181_A_360_DIAS",0]
["Suma de A15_DE_MAS_DE_360_DIAS",0]
["Suma de A16_DE_1_A_30_DIAS",0]
["Suma de A16_DE_31_A_90DIAS",0]
["Suma de A16_DE_91_A_180_DIAS",0]
["Suma de A16_DE_181_A_360_DIAS",0]
["Suma de A16_DE_MAS_DE_360_DIAS",0]
["Suma de A17_DE_1_A_30_DIAS",0]
["Suma de A17_DE_31_A_90DIAS",0]
["Suma de A17_DE_91_A_180_DIAS",0]
["Suma de A17_DE_181_A_360_DIAS",0]
["Suma de A17_DE_MAS_DE_360_DIAS",0]
["Suma de A18_DE_1_A_30_DIAS",0]
["Suma de A18_DE_31_A_90DIAS",0]
["Suma de A18_DE_91_A_180_DIAS",0]
["Suma de A18_DE_181_A_360_DIAS",0]
["Suma de A18_DE_MAS_DE_360_DIAS",0]
["Suma de A19_DE_1_A_30_DIAS",75454.16]
["Suma de A19_DE_31_A_90DIAS",172087.87]
["Suma de A19_DE_91_A_180_DIAS",288377.58]
["Suma de A19_DE_181_A_360_DIAS",566634.07999999996]
["Suma de A19_DE_MAS_DE_360_DIAS",3111009.78]
["Suma de A20_DE_1_A_30_DIAS",509.43]
["Suma de A20_DE_31_A_90DIAS",523.55999999999995]
["Suma de A20_DE_91_A_180_DIAS",810.35]
["Suma de A20_DE_181_A_360_DIAS",744.47]
["Suma de A20_DE_MAS_DE_360_DIAS",1378.96]
["Suma de A21_DE_1_A_30_DIAS",0]
["Suma de A21_DE_31_A_90DIAS",362.69]
["Suma de A21_DE_91_A_180_DIAS",45.28]
["Suma de A21_DE_181_A_360_DIAS",0]
["Suma de A21_DE_MAS_DE_360_DIAS",0]
["Suma de A22_DE_1_A_30_DIAS",0]
["Suma de A22_DE_31_A_90DIAS",0]
["Suma de A22_DE_91_A_360_DIAS",0]
["Suma de A22_DE_MAS_DE_360_DIAS",0]
["Suma de A23_DE_1_A_30_DIAS",0]
["Suma de A23_DE_31_A_90DIAS",0]
["Suma de A23_DE_91_A_360_DIAS",0]
["Suma de A23_DE_MAS_DE_360_DIAS",0]
["Suma de A24_DE_1_A_30_DIAS",0]
["Suma de A24_DE_31_A_90DIAS",0]
["Suma de A24_DE_91_A_360_DIAS",0]
["Suma de A24_DE_MAS_DE_360_DIAS",0]
["Suma de A25_DE_1_A_30_DIAS",0]
["Suma de A25_DE_31_A_90DIAS",0]
["Suma de A25_DE_91_A_180_DIAS",0]
["Suma de A25_DE_181_A_360_DIAS",0]
["Suma de A25_DE_MAS_DE_360_DIAS",0]
["Suma de A26_DE_1_A_30_DIAS",0]
["Suma de A26_DE_31_A_90DIAS",0]
["Suma de A26_DE_91_A_180_DIAS",0]
["Suma de A26_DE_181_A_360_DIAS",0]
["Suma de A26_DE_MAS_DE_360_DIAS",0]
["Suma de A27_DE_1_A_30_DIAS",0]
["Suma de A27_DE_31_A_90DIAS",0]
["Suma de A27_DE_91_A_180_DIAS",0]
["Suma de A27_DE_181_A_360_DIAS",0]
["Suma de A27_DE_MAS_DE_360_DIAS",0]
["Suma de carte_impr",8054414.21]
["Suma de A1499",-9804021.9100000001]
["Suma de Carte_bruta",88366110.780000001]
["Suma de A14",78562088.870000005]
[null,{"$f":"+GETPIVOTDATA(\"Suma de A14\",$A$3,\"FEC_CORTE\",DATE(2016,1,31))-GETPIVOTDATA(\"Suma de A1499\",$A$3,\"FEC_CORTE\",DATE(2016,1,31))","v":{"$error":"#REF!"}}]
[]
[]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B5:B9)","v":1349441.78},{"$f":"+SUM(C5:C9)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B10:B14)","v":114171.49},{"$f":"+SUM(C10:C14)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B15:B19)","v":24114.690000000002},{"$f":"+SUM(C15:C19)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B20:B23)","v":33724312.840000004},{"$f":"+SUM(C20:C23)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B24:B27)","v":910688.72},{"$f":"+SUM(C24:C27)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B28:B31)","v":876012.5},{"$f":"+SUM(C28:C31)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B32:B35)","v":7561731.0600000005},{"$f":"+SUM(C32:C35)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B36:B39)","v":364609.51999999996},{"$f":"+SUM(C36:C39)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B40:B43)","v":97331.459999999992},{"$f":"+SUM(C40:C43)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B44:B48)","v":33462647.420000002},{"$f":"+SUM(C44:C48)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B49:B53)","v":2829285.9299999997},{"$f":"+SUM(C49:C53)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B54:B58)","v":2833825.16},{"$f":"+SUM(C54:C58)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B59:B63)","v":0},{"$f":"+SUM(C59:C63)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B64:B68)","v":0},{"$f":"+SUM(C64:C68)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B69:B73)","v":0},{"$f":"+SUM(C69:C73)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B74:B78)","v":0},{"$f":"+SUM(C74:C78)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B79:B83)","v":0},{"$f":"+SUM(C79:C83)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B84:B88)","v":0},{"$f":"+SUM(C84:C88)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B89:B93)","v":4213563.47},{"$f":"+SUM(C89:C93)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B94:B98)","v":3966.7700000000004},{"$f":"+SUM(C94:C98)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B99:B103)","v":407.97},{"$f":"+SUM(C99:C103)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B104:B107)","v":0},{"$f":"+SUM(C104:C107)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B108:B111)","v":0},{"$f":"+SUM(C108:C111)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B112:B115)","v":0},{"$f":"+SUM(C112:C115)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B116:B120)","v":0},{"$f":"+SUM(C116:C120)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B121:B125)","v":0},{"$f":"+SUM(C121:C125)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+SUM(B126:B130)","v":0},{"$f":"+SUM(C126:C130)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["TOTAL CARTERA",{"$f":"+SUM(B138:B164)","v":88366110.780000016},{"$f":"+SUM(C138:C164)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["TOTAL CARTERA POR VENCER",{"$f":"+B138+B141+B144+B147+B150+B153+B156+B159+B162","v":80311696.570000008},{"$f":"+C138+C141+C144+C147+C150+C153+C156+C159+C162","v":0},0,0,0,0,0,0,0,0,0,0,0]
["TOTAL CARTERA QUE NO DEVENGA INTERES",{"$f":"+B139+B142+B145+B148+B151+B154+B157+B160+B163","v":4222722.43},0,0,0,0,0,0,0,0,0,0,0,0]
["TOTAL CARTERA VENCIDA",3831691.7800000003,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"+B166-B132","v":98170132.690000013}]
[null,{"$f":"+B170-B133","v":9804021.9100000113}]