{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["INSTRUCTIVO","MODELO","MODELO EJEMPLO","Hoja3","Hoja4"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"INSTRUCTIVO","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"MODELO","index":1,"n_rows":100,"n_cols":11,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,"Oficina A","Oficina B","Oficina C","Oficina D","Sede \nPrincipal","Entidad"]
[null,"CUENTAS Y CALCULOS",null,"A","Parámetros Generales"]
[null,null,null,null,"Tipo Oficina"]
[null,null,null,null,"Sede Propia"]
[null,null,null,null,"Departamento"]
[null,null,null,null,"Municipio"]
[null,null,null,null,"Número De Empleados",null,null,null,null,null,{"$f":"SUM(F9:J9)","v":0}]
[null,null,null,null,"Número De Asociados",null,null,null,null,null,{"$f":"SUM(F10:J10)","v":0}]
[null,null,null,null,"Número De Operaciones O Transacciones",null,null,null,null,null,{"$f":"SUM(F11:J11)","v":0}]
[null,null,null,null,"Tasa De Colocación promedio Oficina",null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F12:J12),0)","v":0}]
[null,null,null,null,"Tasa De Captación Promedio Oficina",null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F13:J13),0)","v":0}]
[null,null,null,null,"Tasa Promedio De Colocación Entidad",null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F14:J14),0)","v":0}]
[null,null,null,null,"Tasa Promedio Otras Inversiones Entidad",null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F15:J15),0)","v":0}]
[null,null,null,null,"Tasa Promedio De Inversiones Liquidez Entidad",null,null,null,null,null,0]
[null,null,null,null,"Tasa Promedio De Captación Entidad",null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F17:J17),0)","v":0}]
[]
[null,null,null,"B","Balance General",{"$f":"TRANSPOSE(Hoja3!E45:E49)","v":0.10090455107411368},0.17500167608322645,0.28605700072133378,0.21987386424648886,0.21816290787483725]
[null,100000,null,null,"ACTIVO",{"$f":"SUM(F21:F26)","v":0},0,0,0,0,{"$f":"SUM(K21:K26)","v":0}]
[null,"110500 + 111000",null,null,"Efectivo",null,null,null,null,null,{"$f":"SUM(F21:J21)","v":0}]
[null,"111500 + 120300",null,null,"Inversiones Fondo de liquidez",null,null,null,null,null,{"$f":"SUM(F22:J22)","v":0}]
[null,"120000 - 120300",null,null,"Otras Inversiones",null,null,null,null,null,{"$f":"SUM(F23:J23)","v":0}]
[null,140000,null,null,"Cartera",null,null,null,null,null,{"$f":"SUM(F24:J24)","v":0}]
[null,"130000 + 160000 + 170000 + 180000 + 190000",null,null,"Otros Activos",null,null,null,null,null,{"$f":"SUM(F25:J25)","v":0}]
[null,"Calculo",null,null,"Disponible para colocar",{"$f":"IF(F5=\"Captadora\",(F40-F21-F22-F23-F24-F25),0)","v":0},{"$f":"IF(G5=\"Captadora\",(G40-G21-G22-G23-G24-G25),0)","v":0},{"$f":"IF(H5=\"Captadora\",(H40-H21-H22-H23-H24-H25),0)","v":0},{"$f":"IF(I5=\"Captadora\",(I40-I21-I22-I23-I24-I25),0)","v":0},{"$f":"IF(J5=\"Captadora\",(J40-J21-J22-J23-J24-J25),0)","v":0},{"$f":"+F26+G26+H26+I26+J26-F26-G26-H26-I26-J26","v":0}]
[]
[null,200000,null,null,"PASIVO",{"$f":"SUM(F29:F32)","v":0},0,0,0,0,{"$f":"SUM(K29:K32)","v":0}]
[null,210000,null,null,"Depósitos",null,null,null,null,null,{"$f":"SUM(F29:J29)","v":0}]
[null,230000,null,null,"Obligaciones Financieras",null,null,null,null,null,{"$f":"SUM(F30:J30)","v":0}]
[null,"240000 + 250000 + 260000 + 270000 + 280000",null,null,"Otros pasivos",null,null,null,null,null,{"$f":"SUM(F31:J31)","v":0}]
[null,"Calculo",null,null,"Fondeo requerido",{"$f":"IF(F5=\"Colocadora\",(F20-F29-F30-F34-F31),0)","v":0},{"$f":"IF(G5=\"Colocadora\",(G20-G29-G30-G34-G31),0)","v":0},{"$f":"IF(H5=\"Colocadora\",(H20-H29-H30-H34-H31),0)","v":0},{"$f":"IF(I5=\"Colocadora\",(I20-I29-I30-I34-I31),0)","v":0},{"$f":"IF(J5=\"Colocadora\",(J20-J29-J30-J34-J31),0)","v":0},{"$f":"+F32+G32+H32+I32+J32-F32-G32-H32-I32-J32","v":0}]
[]
[null,300000,null,null,"PATRIMONIO",{"$f":"SUM(F35:F38)","v":0},0,0,0,0,{"$f":"SUM(K35:K38)","v":0}]
[null,310000,null,null,"  Aportes ",null,null,null,null,null,{"$f":"SUM(F35:J35)","v":0}]
[null,320000,null,null,"  Reservas",null,null,null,null,null,{"$f":"SUM(F36:J36)","v":0}]
[null,350000,null,null,"  Resultados",{"$f":"+F88","v":0},{"$f":"+G88","v":0},0,0,0,{"$f":"SUM(F37:J37)","v":0}]
[null,"330000 + 340000 + 360000 + 370000 + 390000",null,null,"  Otros ",null,null,null,null,null,{"$f":"SUM(F38:J38)","v":0}]
[]
[null,"Calculo",null,null,"TOTAL PASIVO + PATRIMONIO",{"$f":"+F28+F34","v":0},0,0,0,0,0]
[null,null,null,null,"Ecuación Patrimonial",{"$f":"+F40-F20","v":0},0,0,0,0,{"$f":"+K40-K20","v":0}]
[]
[null,null,null,"C","Estado de Resultados"]
[null,"Suma",null,null,"INGRESOS FINANCIEROS",{"$f":"SUM(F45:F47)","v":0},{"$f":"SUM(G45:G47)","v":0},0,0,0,0]
[null,"415000 - 417500",null,null,"Cartera",null,null,null,null,null,{"$f":"SUM(F45:J45)","v":0}]
[null,"410500 + 411000 + 413000 + 413500 + 414000 + 414500 + 414700 + 415500 + 416000 + 416500 + 417000",null,null,"Otros ingresos financieros",null,null,null,null,null,{"$f":"SUM(F46:J46)","v":0}]
[null,"Calculo",null,null,"Ingresos por recursos disponibles                                 Macro",null,null,null,null,null,{"$f":"+F47+G47+H47+I47+J47-F47-G47-H47-I47-J47","v":0}]
[null,null,null,null,null,{"$f":"(F26*(((1+((F12+F17)/2))^(3/12))-1))","v":0},{"$f":"(G26*(((1+((G12+G17)/2))^(3/12))-1))","v":0},0,0,{"$f":"(J26*(((1+((J12+J17)/2))^(3/12))-1))","v":0}]
[null,"Suma",null,null,"EGRESOS FINANCIEROS",{"$f":"SUM(F50:F52)","v":0},0,0,0,0,{"$f":"SUM(K50:K52)","v":0}]
[null,615000,null,null,"Depósitos ",null,null,null,null,null,{"$f":"SUM(F50:J50)","v":0}]
[null,"613000 + 613500 + 614000 + 614500 + 615500 + 617000 + 700000",null,null,"Otros egresos",null,null,null,null,null,{"$f":"SUM(F51:J51)","v":0}]
[null,"Calculo",null,null,"Fondeo requerido                                                          Macro",null,null,null,null,null,{"$f":"+F52+G52+H52+I52+J52-F52-G52-H52-I52-J52","v":0}]
[null,null,null,null,null,{"$f":"(F$32*(((1+(F17))^(3/12))-1))","v":0},{"$f":"(G$32*(((1+(G17))^(3/12))-1))","v":0},0,0,{"$f":"-SUM(F53:I53)+J47","v":0}]
[null,"Calculo",null,null,"UTILIDAD FINANCIERA",{"$f":"+F44-F49","v":0},0,0,0,0,0]
[null,"Indicador",null,null,"Margen Financiero",{"$f":"IFERROR(F54/F$44,0)","v":0},0,0,0,0,0]
[]
[null,"Suma",null,null,"GASTOS ADMINISTRATIVOS",{"$f":"+F58+F59+F60+F67","v":0},0,0,0,0,0]
[null,"510500 + 540500",null,null,"Beneficios a Empleados directos",null,null,null,null,null,{"$f":"SUM(F58:J58)","v":0}]
[null,null,null,null,"Beneficios a Empleados compensado directos",null,null,null,null,null,{"$f":"+F59+G59+H59+I59+J59-F59-G59-H59-I59-J59","v":0}]
[null,null,null,null,"Gastos Generales directos",{"$f":"+F61+F62+F63+F64+F65+F66","v":0},0,0,0,0,0]
[null,"511001 + 511002 + 511019 + 511024 + 511030 + 511095 + 511005 + 510700",null,null,"Gastos Generales",null,null,null,null,null,{"$f":"SUM(F61:J61)","v":0}]
[null,"511003 + 511004 + 511006 + 511007 + 511008 + 511009 + 511033 + 511031",null,null,"Gast Arriend, Mantenimiento, Papelería y Suministros",null,null,null,null,null,{"$f":"SUM(F62:J62)","v":0}]
[null,"511020 + 511021 + 511022 + 511023",null,null,"Gastos Asamblea y Directivos",null,null,null,null,null,0]
[null,"511010 + 511011 + 511015 + 511016 + 511017",null,null,"Gastos Papelería y Suministros",null,null,null,null,null,0]
[null,"511012 + 511013 + 511014 + 511029 + 511034 + 511035 + 511028",null,null,"Servicios Generales",null,null,null,null,null,0]
[null,"511018 + 511025 + 511026 + 511027 + 511032 + 541000 + 542500",null,null,"Gastos Comerciales",null,null,null,null,null,0]
[null,null,null,null,"Gastos Generales compensados directos",null,null,null,null,{"$f":"-SUM(F67:I67)","v":0},{"$f":"+F67+G67+H67+I67+J67-F67-G67-H67-I67-J67","v":0}]
[]
[null,"Indicador",null,null,"Indicador de gastos",{"$f":"IFERROR(F57/F$44,0)","v":0},0,0,0,0,0]
[]
[null,"Calculo",null,null,"DETERIORO NETO",{"$f":"+F72-F73","v":0},0,0,0,0,0]
[null,511500,null,null,"Deterioro",null,null,null,null,null,{"$f":"SUM(F72:J72)","v":0}]
[null,422500,null,null,"Recuperaciones",null,null,null,null,null,{"$f":"SUM(F73:J73)","v":0}]
[]
[null,"512000 + 542000 + 513500 + 514000 + 512500 + 541500",null,null,"DEPRECIACIONES Y AMORTIZACIONES",null,null,null,null,null,{"$f":"SUM(F75:J75)","v":0}]
[]
[null,null,null,null,"UTILIDAD OPERATIVA",{"$f":"+F54-F57-F71-F75","v":0},0,0,0,0,{"$f":"+K54-K57-K71-K75","v":0}]
[null,null,null,null,"Margen Operativo",{"$f":"IFERROR(F77/F$44,0)","v":0},0,0,0,0,0]
[]
[null,"Suma",null,null,"OTROS INGRESOS",{"$f":"+F81+F82","v":0},0,0,0,0,0]
[null,"420500 + 421000 + 422000 + 423000 + 423600 + 424000 + 424500 + 425000 + 425500 + 426000",null,null,"Otros ingresos",null,null,null,null,null,{"$f":"SUM(F81:J81)","v":0}]
[null,null,null,null,"Otros ingresos compensados directos",null,null,null,null,{"$f":"-SUM(F82:I82)","v":0},{"$f":"+F82+G82+H82+I82+J82-F82-G82-H82-I82-J82","v":0}]
[]
[null,"Suma",null,null,"OTROS EGRESOS",{"$f":"+F85+F86","v":0},0,0,0,0,0]
[null,520000,null,null,"Otros egresos",null,null,null,null,null,{"$f":"SUM(F85:J85)","v":0}]
[null,null,null,null,"Otros egresos compensados directos",null,null,null,null,{"$f":"-SUM(F86:I86)","v":0},{"$f":"+F86+G86+H86+I86+J86-F86-G86-H86-I86-J86","v":0}]
[]
[null,null,null,null,"EXCEDENTE O PERDIDA SIN IMPACTO DE SEDE PRINCIPAL",{"$f":"+F77+F80-F84","v":0},0,0,0,0,{"$f":"+K77+K80-K84","v":0}]
[null,null,null,null,"Margen Neto sin Sede Principal",{"$f":"IFERROR(F88/F$44,0)","v":0},0,0,0,0,0]
[null,null,null,null,"EXCEDENTE O PERDIDA CON IMPACTO DE SEDE PRINCIPAL",null,null,null,null,null,{"$f":"SUM(F90:J90)","v":0}]
[null,null,null,null,"Margen Neto con Sede Principal",{"$f":"IFERROR(F90/F$44,0)","v":0},{"$f":"IFERROR(G90/G$44,0)","v":0},0,0,0,0]
[]
[null,null,null,"D","Principales Indicadores"]
[null,null,null,null,"Indicador Cartera Por Riesgo"]
[null,null,null,null,"Indicador Cobertura Total Por Riesgo"]
[null,null,null,null,"Indicador Margen Financiero",{"$f":"IFERROR(F54/F$44,0)","v":0},{"$f":"IFERROR(G54/G$44,0)","v":0},0,0,0,{"$f":"IFERROR(K54/K$44,0)","v":0}]
[null,null,null,null,"Indicador Gastos Administrativos",{"$f":"IFERROR(F57/F44,0)","v":0},{"$f":"IFERROR(G57/G44,0)","v":0},0,0,0,{"$f":"IFERROR(K57/K44,0)","v":0}]
[null,null,null,null,"Indicador Margen Operativo",{"$f":"IFERROR(F77/F44,0)","v":0},{"$f":"IFERROR(G77/G44,0)","v":0},0,0,0,{"$f":"IFERROR(K77/K44,0)","v":0}]
[null,null,null,null,"Indicador Margen Neto Sin Impacto Sede Principal",{"$f":"IFERROR(F88/F44,0)","v":0},{"$f":"IFERROR(G88/G44,0)","v":0},0,0,0,{"$f":"IFERROR(K88/K44,0)","v":0}]
[null,null,null,null,"Indicador Margen Neto Con Impacto Sede Principal",{"$f":"+F91","v":0},{"$f":"+G91","v":0},0,0,0,{"$f":"+K91","v":0}]

{"sheet":"MODELO EJEMPLO","index":2,"n_rows":100,"n_cols":11,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,"Oficina A","Oficina B","Oficina C","Oficina D","Sede \nPrincipal","Entidad"]
[null,"CUENTAS Y CALCULOS",null,"A","Parámetros Generales"]
[null,null,null,null,"Tipo Oficina","Colocadora","Colocadora","Colocadora","Colocadora","Captadora","Entidad"]
[null,null,null,null,"Sede Propia","NO","SI","SI","SI","SI"]
[null,null,null,null,"Departamento","LA GUAJIRA","CESAR","LA GUAJIRA","LA GUAJIRA","ATLANTICO"]
[null,null,null,null,"Municipio","ALBANIA","VALLEDUPAR","FONSECA","RIOHACHA","BARRANQUILLA"]
[null,null,null,null,"Número De Empleados",2,4,2,3,24,{"$f":"SUM(F9:J9)","v":35}]
[null,null,null,null,"Número De Asociados",721,1505,2048,1447,2157,{"$f":"SUM(F10:J10)","v":7878}]
[null,null,null,null,"Número De Operaciones O Transacciones",7000,18000,20000,35000,40000,{"$f":"SUM(F11:J11)","v":120000}]
[null,null,null,null,"Tasa De Colocación promedio Oficina",0.126,0.13500000000000001,0.13,0.128,0.129,{"$f":"IFERROR(AVERAGE(F12:J12),0)","v":0.12959999999999999}]
[null,null,null,null,"Tasa De Captación Promedio Oficina",3.5000000000000003E-2,0.04,0.05,4.4999999999999998E-2,5.5E-2,{"$f":"IFERROR(AVERAGE(F13:J13),0)","v":4.4999999999999998E-2}]
[null,null,null,null,"Tasa Promedio De Colocación Entidad",0.13,0.13,0.13,0.13,0.13,{"$f":"IFERROR(AVERAGE(F14:J14),0)","v":0.13}]
[null,null,null,null,"Tasa Promedio Otras Inversiones Entidad",null,null,null,null,null,2.5000000000000001E-2]
[null,null,null,null,"Tasa Promedio De Inversiones Liquidez Entidad",null,null,null,null,null,3.5000000000000003E-2]
[null,null,null,null,"Tasa Promedio De Captación Entidad",4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,{"$f":"AVERAGE(F17:J17)","v":4.4999999999999998E-2}]
[]
[null,null,null,"B","Balance General",0.10090455107411368,0.17500167608322645,0.28605700072133378,0.21987386424648886,0.21816290787483725]
[null,100000,null,null,"ACTIVO",{"$f":"SUM(F21:F26)","v":9249.4406666625582},16041.571983303344,26221.485822894694,20154.792225416782,58456.089828165132,{"$f":"SUM(K21:K26)","v":92292.560148920005}]
[null,"110500 + 111000",null,null,"Efectivo",333.7548745494185,578.84071456990284,946.17058768347817,727.26128997276601,721.60208012443434,{"$f":"SUM(F21:J21)","v":3307.6295469000002}]
[null,"111500 + 120300",null,null,"Inversiones Fondo de liquidez",372.65209529402466,646.30128748584173,1056.4413552965773,812.01943162768009,805.70067325587661,{"$f":"SUM(F22:J22)","v":3693.1148429600007}]
[null,"120000 - 120300",null,null,"Otras Inversiones",0,0,0,0,627.31246480999994,{"$f":"SUM(F23:J23)","v":627.31246480999994}]
[null,140000,null,null,"Cartera",7891.279623317304,13686.07407516847,22371.198889151317,17195.320985610888,17061.514977772029,{"$f":"SUM(F24:J24)","v":78205.388551020005}]
[null,"130000 + 160000 + 170000 + 180000 + 190000",null,null,"Otros Activos",651.75407350181217,1130.3559060791288,1847.6749907633216,1420.1905182054477,1409.1392546802895,{"$f":"SUM(F25:J25)","v":6459.1147432300004}]
[null,"Calculo",null,null,"Disponible para colocar",{"$f":"IF(F5=\"Captadora\",(F40-F21-F22-F23-F24-F25),0)","v":0},{"$f":"IF(G5=\"Captadora\",(G40-G21-G22-G23-G24-G25),0)","v":0},{"$f":"IF(H5=\"Captadora\",(H40-H21-H22-H23-H24-H25),0)","v":0},{"$f":"IF(I5=\"Captadora\",(I40-I21-I22-I23-I24-I25),0)","v":0},{"$f":"IF(J5=\"Captadora\",(J40-J21-J22-J23-J24-J25),0)","v":37830.820377522505},{"$f":"+F26+G26+H26+I26+J26-F26-G26-H26-I26-J26","v":0}]
[null,null,null,null,null,4.5754326503929792E-2,8.3575072156447064E-2,0.12212457161590839,7.3746619965278482E-2,0.67479940975843622]
[null,200000,null,null,"PASIVO",{"$f":"SUM(F29:F32)","v":7050.5109339352312},12148.78164990947,18789.997689351832,12214.293238256232,46867.718672350413,{"$f":"SUM(K29:K32)","v":59240.481719579999}]
[null,210000,null,null,"Depósitos",1559.2732931599999,2848.1760730599999,4161.9142387099992,2513.2297589999994,22996.660169089995,{"$f":"SUM(F29:J29)","v":34079.253533019997}]
[null,230000,null,null,"Obligaciones Financieras",0,0,0,0,21193.923938,{"$f":"SUM(F30:J30)","v":21193.923938}]
[null,"240000 + 250000 + 260000 + 270000 + 280000",null,null,"Otros pasivos",181.52133392904207,331.56773883998096,484.50533182536333,292.57527870518902,2677.1345652604241,{"$f":"SUM(F31:J31)","v":3967.3042485599995}]
[null,"Calculo",null,null,"Fondeo requerido",{"$f":"IF(F5=\"Colocadora\",(F20-F29-F30-F34-F31),0)","v":5309.7163068461887},{"$f":"IF(G5=\"Colocadora\",(G20-G29-G30-G34-G31),0)","v":8969.037838009488},{"$f":"IF(H5=\"Colocadora\",(H20-H29-H30-H34-H31),0)","v":14143.578118816469},{"$f":"IF(I5=\"Colocadora\",(I20-I29-I30-I34-I31),0)","v":9408.4882005510444},{"$f":"IF(J5=\"Colocadora\",(J20-J29-J30-J34-J31),0)","v":0},{"$f":"+F32+G32+H32+I32+J32-F32-G32-H32-I32-J32","v":-3.637978807091713E-12}]
[null,null,null,null,null,9.670241063752974E-2,0.16025041106626495,0.29103304622366122,0.31109253563968092,0.14092159643286317]
[null,300000,null,null,"PATRIMONIO",{"$f":"SUM(F35:F38)","v":2198.9297327273266},3892.7903333938748,7431.4881335428618,7940.4989871605494,11588.371155814726,{"$f":"SUM(K35:K38)","v":33052.078342639339}]
[null,310000,null,null,"  Aportes ",2400.8665860000001,3978.5963430000002,7225.5852930000001,7723.6096706100006,3498.7126990000002,{"$f":"SUM(F35:J35)","v":24827.370591610001}]
[null,320000,null,null,"  Reservas",0,0,0,0,2740.3856883899998,{"$f":"SUM(F36:J36)","v":2740.3856883899998}]
[null,350000,null,null,"  Resultados",{"$f":"+F88","v":-201.93685327267349},{"$f":"+G88","v":-85.806009606125471},205.9028405428615,216.88931655054833,167.29557273472633,{"$f":"SUM(F37:J37)","v":302.34486694933719}]
[null,"330000 + 340000 + 360000 + 370000 + 390000",null,null,"  Otros ",0,0,0,0,5181.9771956900004,{"$f":"SUM(F38:J38)","v":5181.9771956900004}]
[]
[null,"Calculo",null,null,"TOTAL PASIVO + PATRIMONIO",{"$f":"+F28+F34","v":9249.4406666625582},16041.571983303344,26221.485822894694,20154.792225416782,58456.089828165139,92292.560062219331]
[null,null,null,null,"Ecuación Patrimonial",{"$f":"+F40-F20","v":0},0,0,0,0,{"$f":"+K40-K20","v":-8.6700674728490412E-5}]
[]
[null,null,null,"C","Estado de Resultados"]
[null,"Suma",null,null,"INGRESOS FINANCIEROS",{"$f":"SUM(F45:F47)","v":328.92537034902932},{"$f":"SUM(G45:G47)","v":614.40657909128583},917.34961088232888,895.69760424294009,1458.6890471219724,3434.2615623400006]
[null,"415000 - 417500",null,null,"Cartera",328.92537034902932,614.40657909128583,917.34961088232888,895.69760424294009,677.88239777441629,{"$f":"SUM(F45:J45)","v":3434.2615623400006}]
[null,"410500 + 411000 + 413000 + 413500 + 414000 + 414500 + 414700 + 415500 + 416000 + 416500 + 417000",null,null,"Otros ingresos financieros",0,0,0,0,0,{"$f":"SUM(F46:J46)","v":0}]
[null,"Calculo",null,null,"Ingresos por recursos disponibles                              Macro",0,0,0,0,780.80664934755612,{"$f":"+F47+G47+H47+I47+J47-F47-G47-H47-I47-J47","v":0}]
[null,null,null,null,null,{"$f":"(F26*(((1+((F12+F17)/2))^(3/12))-1))","v":0},{"$f":"(G26*(((1+((G12+G17)/2))^(3/12))-1))","v":0},0,0,{"$f":"(J26*(((1+((J12+J17)/2))^(3/12))-1))","v":797.26167762738999}]
[null,"Suma",null,null,"EGRESOS FINANCIEROS",{"$f":"SUM(F50:F52)","v":117.56548412015809},233.32844081334781,363.6355965101784,218.53265899936349,860.62652927517126,{"$f":"SUM(K50:K52)","v":1012.8819736699999}]
[null,615000,null,null,"Depósitos ",59.456498999999994,135.17222000000001,208.84974299999996,115.56713894999999,493.83637271999999,{"$f":"SUM(F50:J50)","v":1012.8819736699999}]
[null,"613000 + 613500 + 614000 + 614500 + 615500 + 617000 + 700000",null,null,"Otros egresos",0,0,0,0,0,{"$f":"SUM(F51:J51)","v":0}]
[null,"Calculo",null,null,"Fondeo requerido                                                          Macro",58.108985120158088,98.156220813347815,154.78585351017841,102.96552004936352,366.79015655517128,{"$f":"+F52+G52+H52+I52+J52-F52-G52-H52-I52-J52","v":0}]
[null,null,null,null,null,{"$f":"(F$32*(((1+(F17))^(3/12))-1))","v":58.751960488427805},{"$f":"(G$32*(((1+(G17))^(3/12))-1))","v":99.242318464079858},156.49855750867115,104.10483255044961,{"$f":"-SUM(F53:I53)+J47","v":362.20898033592766}]
[null,"Calculo",null,null,"UTILIDAD FINANCIERA",{"$f":"+F44-F49","v":211.35988622887123},381.07813827793802,553.71401437215047,677.16494524357654,598.06251784680114,2421.3795886700009]
[null,"Indicador",null,null,"Margen Financiero",{"$f":"IFERROR(F54/F$44,0)","v":0.64257702592108668},0.62023772408419975,0.60360195044894072,0.75601960085170561,0.41000000584551755,0.70506557078318377]
[]
[null,"Suma",null,null,"GASTOS ADMINISTRATIVOS",{"$f":"+F58+F59+F60+F67","v":360.39164508755078},403.62652287759062,292.09151762653448,343.89091105808723,227.58471788023701,1627.58531453]
[null,"510500 + 540500",null,null,"Beneficios a Empleados directos",96.747944000000004,121.593825,107.340395,146.57041899999999,160.856945,{"$f":"SUM(F58:J58)","v":633.10952799999995}]
[null,null,null,null,"Beneficios a Empleados compensado directos",2,3,2,4,{"$f":"-SUM(F59:I59)","v":-11},{"$f":"+F59+G59+H59+I59+J59-F59-G59-H59-I59-J59","v":0}]
[null,null,null,null,"Gastos Generales directos",{"$f":"+F61+F62+F63+F64+F65+F66","v":246.6437010875508},259.03269787759064,164.75112262653448,168.32049205808721,155.72777288023701,994.47578653000005]
[null,"511001 + 511002 + 511019 + 511024 + 511030 + 511095 + 511005 + 510700",null,null,"Gastos Generales",76.257082739572951,80.087501879054699,50.937607302241801,52.041181806150973,47.146929132979594,{"$f":"SUM(F61:J61)","v":306.47030286000006}]
[null,"511003 + 511004 + 511006 + 511007 + 511008 + 511009 + 511033 + 511031",null,null,"Gast Arriend, Mantenimiento, Papelería y Suministros",26.992049728091573,28.347869544139574,18.029937416142634,18.420559989391325,19.925294362234904,{"$f":"SUM(F62:J62)","v":111.71571104}]
[null,"511020 + 511021 + 511022 + 511023",null,null,"Gastos Asamblea y Directivos",79.310888901841864,83.294701760988573,52.977464761804654,54.125233227762841,49.034984347602077,318.74327299999999]
[null,"511010 + 511011 + 511015 + 511016 + 511017",null,null,"Gastos Papelería y Suministros",9.7488518858050277,10.238540023743484,6.5119615275966796,6.6530446112533568,6.0273539516014552,39.179752000000008]
[null,"511012 + 511013 + 511014 + 511029 + 511034 + 511035 + 511028",null,null,"Servicios Generales",39.320152424528345,41.295217021853858,26.264766646069731,26.833798611975425,24.310193535572633,158.02412823999998]
[null,"511018 + 511025 + 511026 + 511027 + 511032 + 541000 + 542500",null,null,"Gastos Comerciales",15.014675407711016,15.768867647810396,10.029384972678985,10.24667381155327,9.2830175502463366,60.342619390000003]
[null,null,null,null,"Gastos Generales compensados directos",15,20,18,25,{"$f":"-SUM(F67:I67)","v":-78},{"$f":"+F67+G67+H67+I67+J67-F67-G67-H67-I67-J67","v":0}]
[]
[null,"Indicador",null,null,"Indicador de gastos",{"$f":"IFERROR(F57/F$44,0)","v":1.0956638726442169},0.65693717582672817,0.31840806837601843,0.38393639709324678,0.15602003616141971,0.47392584547957761]
[]
[null,"Calculo",null,null,"DETERIORO NETO",{"$f":"+F72-F73","v":3.3018405996720332},5.7264774774909881,9.3604759027010971,7.1948038423222442,7.1388172178137239,32.722415040000101]
[null,511500,null,null,"Deterioro",53.82195829856186,93.344976139001929,152.58130381579068,117.27956595065919,116.3669507959864,{"$f":"SUM(F72:J72)","v":533.39475500000003}]
[null,422500,null,null,"Recuperaciones",50.520117698889827,87.618498661510941,143.22082791308958,110.08476210833695,109.22813357817267,{"$f":"SUM(F73:J73)","v":500.67233995999993}]
[]
[null,"512000 + 542000 + 513500 + 514000 + 512500 + 541500",null,null,"DEPRECIACIONES Y AMORTIZACIONES",6.0565936531570363,7.0835362688627379,5.4884975498340749,12.735063621279945,27.295549826866207,{"$f":"SUM(F75:J75)","v":58.659240920000002}]
[]
[null,null,null,null,"UTILIDAD OPERATIVA",{"$f":"+F54-F57-F71-F75","v":-158.39019311150861},-35.358398346006318,246.77352329308081,313.34416672188712,{"$f":"+J54-J57-J71-J75","v":336.04343292188423},{"$f":"+K54-K57-K71-K75","v":702.41261818000078}]
[null,null,null,null,"Margen Operativo",{"$f":"IFERROR(F77/F$44,0)","v":-0.4815383895241574},-5.754886023242424E-2,0.26900706161059806,0.34983253861299685,0.23037359030350285,0.20453090291159953]
[]
[null,"Suma",null,null,"OTROS INGRESOS",{"$f":"+F81+F82","v":4.0694756919128583},7.7335378462015987,10.560550767492165,9.3584979188772444,0.32588340551613726,32.047945630000001]
[null,"420500 + 421000 + 422000 + 423000 + 423600 + 424000 + 424500 + 425000 + 425500 + 426000",null,null,"Otros ingresos",3.0694756919128583,5.7335378462015987,8.560550767492165,8.3584979188772444,6.3258834055161373,{"$f":"SUM(F81:J81)","v":32.047945630000001}]
[null,null,null,null,"Otros ingresos compensados directos",1,2,2,1,{"$f":"-SUM(F82:I82)","v":-6},{"$f":"+F82+G82+H82+I82+J82-F82-G82-H82-I82-J82","v":0}]
[]
[null,"Suma",null,null,"OTROS EGRESOS",{"$f":"+F85+F86","v":47.616135853077729},58.181149106320753,51.431233517711469,105.81334809021601,169.07374359267405,432.11561016000002]
[null,520000,null,null,"Otros egresos",44.616135853077729,52.181149106320753,40.431233517711469,93.81334809021601,201.07374359267405,{"$f":"SUM(F85:J85)","v":432.11561016000002}]
[null,null,null,null,"Otros egresos compensados directos",3,6,11,12,{"$f":"-SUM(F86:I86)","v":-32},{"$f":"+F86+G86+H86+I86+J86-F86-G86-H86-I86-J86","v":0}]
[]
[null,null,null,null,"EXCEDENTE O PERDIDA SIN IMPACTO DE SEDE PRINCIPAL",{"$f":"+F77+F80-F84","v":-201.93685327267349},-85.806009606125471,205.9028405428615,216.88931655054833,167.29557273472633,{"$f":"+K77+K80-K84","v":302.34495365000072}]
[null,null,null,null,"Margen Neto sin Sede Principal",{"$f":"IFERROR(F88/F$44,0)","v":-0.61392908992819328},-0.13965672329393594,0.22445405557519035,0.24214569238896996,0.11468898944898806,8.8037835255621047E-2]
[null,null,null,null,"EXCEDENTE O PERDIDA CON IMPACTO DE SEDE PRINCIPAL",-228,-98,190,201,{"$f":"+K88-I90-H90-G90-F90","v":237.34495365000072},{"$f":"SUM(F90:J90)","v":302.34495365000072}]
[null,null,null,null,"Margen Neto con Sede Principal",{"$f":"IFERROR(F90/F$44,0)","v":-0.69316635490313383},{"$f":"IFERROR(G90/G$44,0)","v":-0.15950350034490693},0.20711841782682333,0.22440609313663271,0.1627111371805306,8.8037835255621047E-2]
[]
[null,null,null,"D","Principales Indicadores"]
[null,null,null,null,"Indicador Cartera Por Riesgo",{"$f":"+Hoja4!I11","v":4.1294982920636318E-2},{"$f":"+Hoja4!H11","v":5.4760020921148893E-2},{"$f":"+Hoja4!G11","v":2.677056430868693E-2},{"$f":"+Hoja4!F11","v":3.4293932637600985E-2},{"$f":"+Hoja4!E11","v":0.20107434243978717},8.0714645958194192E-2]
[null,null,null,null,"Indicador Cobertura Total Por Riesgo",{"$f":"+Hoja4!I24","v":0.87883612076064621},{"$f":"+Hoja4!H24","v":0.91829613269330268},{"$f":"+Hoja4!G24","v":1.457555169179779},{"$f":"+Hoja4!F24","v":1.278900794708008},{"$f":"+Hoja4!E24","v":0.46257159104237677},{"$f":"+Hoja4!J24","v":0.6924066168462446}]
[null,null,null,null,"Indicador Margen Financiero",{"$f":"IFERROR(F54/F$44,0)","v":0.64257702592108668},{"$f":"IFERROR(G54/G$44,0)","v":0.62023772408419975},0.60360195044894072,0.75601960085170561,0.41000000584551755,0.70506557078318377]
[null,null,null,null,"Indicador Gastos Administrativos",{"$f":"+F57/F44","v":1.0956638726442169},{"$f":"+G57/G44","v":0.65693717582672817},0.31840806837601843,0.38393639709324678,0.15602003616141971,0.47392584547957761]
[null,null,null,null,"Indicador Margen Operativo",{"$f":"+F77/F44","v":-0.4815383895241574},{"$f":"+G77/G44","v":-5.754886023242424E-2},0.26900706161059806,0.34983253861299685,0.23037359030350285,0.20453090291159953]
[null,null,null,null,"Indicador Margen Neto Sin Impacto Sede Principal",{"$f":"+F88/F44","v":-0.61392908992819328},{"$f":"+G88/G44","v":-0.13965672329393594},0.22445405557519035,0.24214569238896996,0.11468898944898806,8.8037835255621047E-2]
[null,null,null,null,"Indicador Margen Neto Con Impacto Sede Principal",{"$f":"+F91","v":-0.69316635490313383},{"$f":"+G91","v":-0.15950350034490693},0.20711841782682333,0.22440609313663271,0.1627111371805306,8.8037835255621047E-2]

{"sheet":"Hoja3","index":3,"n_rows":59,"n_cols":16384,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,1674,{"$f":"+D4/$D$9","v":0.27375306623058054},{"$f":"ROUND($F$9*E4,0)","v":2157},"Direccion General",24]
[null,null,null,1123,{"$f":"+D5/$D$9","v":0.18364677023712184},{"$f":"ROUND($F$9*E5,0)","v":1447},"Sucursal",3]
[null,null,null,1590,{"$f":"+D6/$D$9","v":0.26001635322976285},{"$f":"ROUND($F$9*E6,0)","v":2048},"Sucursal",2]
[null,null,null,1168,{"$f":"+D7/$D$9","v":0.19100572363041701},{"$f":"ROUND($F$9*E7,0)","v":1505},"Oficina",4]
[null,null,null,560,{"$f":"+D8/$D$9","v":9.1578086672117739E-2},{"$f":"ROUND($F$9*E8,0)","v":721},"Sucursal",2]
[null,null,null,{"$f":"SUM(D4:D8)","v":6115},null,7878]
[]
[]
[]
[]
[null,null,"empledado","TOTALAPORTES","TOTALCARTERA","TOTALDEPOSITOS","TOTALINGRESOS","TOTALCOSTOS","OTROSGASTOSADM","VALOREXCEDENTESOFI","TOTALASOCIADOS","TOTALEMPLEADOS","GASTOSPERSONAL","GATOSGENERALES","recuperaciones","Deterioro","Depreciones y amortizaciones","otros ingresos","otros egresos","valoracion inversiones","costo inversiones",null,null,"Gastos Generales","Gast Arriend, Mantenimiento, Papeleria Y Suministros","Gastos Asamble Y Directivos","Gastos Papeleria Y Suministros","Servicios Generales","Gastos Comerciales"]
["BARRANQUILLA","Direccion General",27,3498712699,17789571174,22996660169.09,783035047.90999997,493836372.72000003,476570648.98000002,-976810363.38,1713,24,160856945,247449170.86000001,"",""]
["RIOHACHA","Sucursal",10,7723609670.6099997,17929087008.5,2513229759,1034637599.02,115567138.95,222349708.03999999,343386387.69,3020,3,146570419,259878626.66999999,"",""]
["FONSECA","Sucursal",2,7225585293,23325832167,4161914238.71,1059648250,208849743,95827226.629999995,783049377.64999998,1503,2,107340395,165289154,"",""]
["VALLEDUPAR","Oficina",4,3978596343,14270092027,2848176073.0599999,709712904,135172220,123676038.7,382285327.63,1105,4,121593825,168870180,"",""]
["ALBANIA","Sucursal",2,2400866586,8228019651,1559273293.1600001,379948047,59456499,105745983.73,297225585.54000002,517,2,96747944,152988655,"",""]
[null,null,null,{"$f":"SUM(D15:D19)","v":24827370591.610001},{"$f":"SUM(E15:E19)","v":81542602027.5},{"$f":"SUM(F15:F19)","v":34079253533.02},3966981847.9299998,1012881973.6700001,1024169606.08,829136315.12999988,7858,35,633109528,994475786.52999997,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(XFD15:XFD19)","v":0}]
[]
[null,"Direccion General",null,{"$f":"+D$28*(D15/D$20)","v":3498712699},{"$f":"+E$28*(E15/E$20)","v":17061514977.772028},{"$f":"+F$28*(F15/F$20)","v":22996660169.089996},{"$f":"+G$28*(G15/G$20)","v":677882397.77441633},{"$f":"+H$28*(H15/H$20)","v":493836372.71999997},null,null,null,null,{"$f":"+M$28*(M15/M$20)","v":160856945},{"$f":"+N$28*(N15/N$20)","v":247449170.86000001},{"$f":"+O$28*(E15/E$20)","v":109228133.57817267},{"$f":"+P$28*(E15/E$20)","v":116366950.7959864},{"$f":"+Q$28*(I15/I$20)","v":27295549.826866206},{"$f":"+R$28*(G15/G$20)","v":6325883.4055161374},{"$f":"+S$28*(I15/I$20)","v":201073743.59267405},null,null,null,null,{"$f":"+X$27*($N22/$N$27)","v":76257082.739572957},{"$f":"+Y$27*($N22/$N$27)","v":26992049.728091571},{"$f":"+Z$27*($N22/$N$27)","v":79310888.901841864},{"$f":"+AA$27*($N22/$N$27)","v":9748851.8858050276},{"$f":"+AB$27*($N22/$N$27)","v":39320152.424528345},{"$f":"+AC$27*($N22/$N$27)","v":15014675.407711016}]
[null,"Sucursal",null,{"$f":"+D$28*(D16/D$20)","v":7723609670.6100006},17195320985.610886,2513229758.9999995,{"$f":"+G$28*(G16/G$20)","v":895697604.24294007},115567138.94999999,null,null,null,null,{"$f":"+M$28*(M16/M$20)","v":146570419},259878626.66999999,{"$f":"+O$28*(E16/E$20)","v":110084762.10833694},{"$f":"+P$28*(E16/E$20)","v":117279565.95065919},{"$f":"+Q$28*(I16/I$20)","v":12735063.621279946},{"$f":"+R$28*(G16/G$20)","v":8358497.918877244},{"$f":"+S$28*(I16/I$20)","v":93813348.090216011},null,null,null,null,{"$f":"+X$27*($N23/$N$27)","v":80087501.879054695},28347869.544139575,83294701.760988578,10238540.023743484,41295217.021853857,15768867.647810396]
[null,"Sucursal",null,7225585293,22371198889.151318,4161914238.7099996,917349610.88232887,208849742.99999997,null,null,null,null,107340395,165289154,{"$f":"+O$28*(E17/E$20)","v":143220827.91308957},{"$f":"+P$28*(E17/E$20)","v":152581303.81579068},5488497.5498340745,8560550.7674921658,40431233.517711468,null,null,null,null,50937607.302241802,18029937.416142635,52977464.761804655,6511961.5275966795,26264766.646069732,10029384.972678985]
[null,"Oficina",null,3978596343,13686074075.168468,2848176073.0599999,614406579.09128582,135172220,null,null,null,null,121593825,168870180,{"$f":"+O$28*(E18/E$20)","v":87618498.661510944},{"$f":"+P$28*(E18/E$20)","v":93344976.139001936},7083536.2688627383,5733537.8462015986,52181149.106320754,null,null,null,null,52041181.806150973,18420559.989391327,54125233.227762841,6653044.6112533566,26833798.611975424,10246673.81155327]
[null,"Sucursal",null,2400866586,7891279623.3173037,1559273293.1599998,328925370.3490293,59456498.999999993,null,null,null,null,96747944,152988655,{"$f":"+O$28*(E19/E$20)","v":50520117.698889829},{"$f":"+P$28*(E19/E$20)","v":53821958.298561864},6056593.6531570368,3069475.6919128583,44616135.853077732,null,null,null,null,47146929.132979594,{"$f":"(+Y$27*($N26/$N$27))+3237110","v":19925294.362234905},49034984.347602077,6027353.951601455,24310193.535572633,9283017.5502463374]
[null,null,null,24827.370591610001,78205.388551020005,34079.253533019997,3434.2615623400002,1012.88197367,null,null,null,null,633.10952799999995,994.47578652999994,500.67233995999999,533.39475500000003,58.659240920000002,{"$f":"21.77093034+T27","v":32.047945630000001},{"$f":"429.37504016+U27","v":432.11561016000002},10.27701529,2.74057,null,null,306.47030286,108.47860104,318.74327299999999,39.179752000000001,158.02412823999998,60.342619390000003]
[null,null,null,{"$f":"+D27*1000000","v":24827370591.610001},{"$f":"+E27*1000000","v":78205388551.020004},34079253533.019997,3434261562.3400002,1012881973.67,0,0,0,0,633109528,994475786.52999997,500672339.95999998,533394755.00000006,58659240.920000002,32047945.630000003,432115610.16000003,10277015.289999999,2740570]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Y30*1000000","v":3237110}]
[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.2371099999999999]
[null,null,null,null,null,null,null,"deprecioanes",115.849322]
[null,null,null,null,null,null,null,"Otros Gastos",409.53086738000002]
[null,null,null,null,null,null,null,"Otros Ingresos",242.76053550999998]
[null,null,null,null,null,null,null,"Valoracion Inversiones",202.43104384]
[]
[null,null,null,"TOTALAPORTES","TOTALCARTERA","TOTALDEPOSITOS","TOTALINGRESOS","TOTALCOSTOS","OTROSGASTOSADM","VALOREXCEDENTESOFI","TOTALASOCIADOS","TOTALEMPLEADOS","GASTOSPERSONAL","GATOSGENERALES","recuperaciones","Deterioro","Depreciones y amortizaciones","otros ingresos","otros egresos","valoracion inversiones","costo inversiones",null,null,"Gastos Generales","Gast Arriend, Mantenimiento, Papeleria Y Suministros","Gastos Asamble Y Directivos","Gastos Papeleria Y Suministros","Servicios Generales","Gastos Comerciales"]
[null,"Sucursal",null,{"$f":"+D26","v":2400866586},{"$f":"+E26","v":7891279623.3173037},{"$f":"+F26","v":1559273293.1599998},{"$f":"+G26","v":328925370.3490293},{"$f":"+H26","v":59456498.999999993},null,null,null,null,{"$f":"+M26","v":96747944},152988655,50520117.698889829,53821958.298561864,6056593.6531570368,3069475.6919128583,44616135.853077732,0,0,null,null,{"$f":"+X26","v":47146929.132979594},{"$f":"+Y26","v":19925294.362234905},49034984.347602077,6027353.951601455,24310193.535572633,9283017.5502463374]
[null,"Oficina",null,{"$f":"+D25","v":3978596343},{"$f":"+E25","v":13686074075.168468},{"$f":"+F25","v":2848176073.0599999},{"$f":"+G25","v":614406579.09128582},{"$f":"+H25","v":135172220},null,null,null,null,{"$f":"+M25","v":121593825},168870180,87618498.661510944,93344976.139001936,7083536.2688627383,5733537.8462015986,52181149.106320754,0,0,null,null,{"$f":"+X25","v":52041181.806150973},{"$f":"+Y25","v":18420559.989391327},54125233.227762841,6653044.6112533566,26833798.611975424,10246673.81155327]
[null,"Sucursal",null,{"$f":"+D24","v":7225585293},{"$f":"+E24","v":22371198889.151318},{"$f":"+F24","v":4161914238.7099996},{"$f":"+G24","v":917349610.88232887},{"$f":"+H24","v":208849742.99999997},null,null,null,null,{"$f":"+M24","v":107340395},165289154,143220827.91308957,152581303.81579068,5488497.5498340745,8560550.7674921658,40431233.517711468,0,0,null,null,{"$f":"+X24","v":50937607.302241802},{"$f":"+Y24","v":18029937.416142635},52977464.761804655,6511961.5275966795,26264766.646069732,10029384.972678985]
[null,"Sucursal",null,{"$f":"+D23","v":7723609670.6100006},{"$f":"+E23","v":17195320985.610886},{"$f":"+F23","v":2513229758.9999995},{"$f":"+G23","v":895697604.24294007},{"$f":"+H23","v":115567138.94999999},null,null,null,null,{"$f":"+M23","v":146570419},259878626.66999999,110084762.10833694,117279565.95065919,12735063.621279946,8358497.918877244,93813348.090216011,0,0,null,null,{"$f":"+X23","v":80087501.879054695},{"$f":"+Y23","v":28347869.544139575},83294701.760988578,10238540.023743484,41295217.021853857,15768867.647810396]
[null,"Direccion General",null,{"$f":"+D22","v":3498712699},{"$f":"+E22","v":17061514977.772028},{"$f":"+F22","v":22996660169.089996},{"$f":"+G22","v":677882397.77441633},{"$f":"+H22","v":493836372.71999997},null,null,null,null,{"$f":"+M22","v":160856945},247449170.86000001,109228133.57817267,116366950.7959864,27295549.826866206,6325883.4055161374,201073743.59267405,0,0,null,null,{"$f":"+X22","v":76257082.739572957},{"$f":"+Y22","v":26992049.728091571},79310888.901841864,9748851.8858050276,39320152.424528345,15014675.407711016]
[]
[]
[null,null,null,"PATRIMONIO","ACTIVOS","PASIVO"]
[null,"Sucursal",null,{"$f":"+D37/SUM(D$37:D$41)","v":9.670241063752974E-2},{"$f":"+E37/SUM(E$37:E$41)","v":0.10090455107411368},{"$f":"+F37/SUM(F$37:F$41)","v":4.5754326503929792E-2}]
[null,"Oficina",null,{"$f":"+D38/SUM(D$37:D$41)","v":0.16025041106626495},{"$f":"+E38/SUM(E$37:E$41)","v":0.17500167608322645},8.3575072156447064E-2]
[null,"Sucursal",null,{"$f":"+D39/SUM(D$37:D$41)","v":0.29103304622366122},0.28605700072133378,0.12212457161590839]
[null,"Sucursal",null,{"$f":"+D40/SUM(D$37:D$41)","v":0.31109253563968092},0.21987386424648886,7.3746619965278482E-2]
[null,"Direccion General",null,{"$f":"+D41/SUM(D$37:D$41)","v":0.14092159643286317},0.21816290787483725,0.67479940975843622]
[]
[]
[]
[null,null,null,"ACTIVOS","Efectivo","Inversiones","Inventarios","Cartera Créditos","Cuentas Por Cobrar Y Otras","Activos Materiales","Activos No Corrientes","Otros Activos"]
[null,"Sucursal",null,null,{"$f":"+E$59*($E37/SUM($E$37:$E$41))","v":333.7548745494185},63.298682644848782,0,7891.279623317304,377.66571571199717,259.07932012803747,0,15.009037661777585]
[null,"Oficina",null,null,{"$f":"+E$59*($E38/SUM($E$37:$E$41))","v":578.84071456990284},109.78073276965,{"$f":"+G$59*($E38/SUM($E$37:$E$41))","v":0},13686.07407516847,{"$f":"+I$59*($E38/SUM($E$37:$E$41))","v":654.99655412199013},449.32874462330182,{"$f":"+K$59*($E38/SUM($E$37:$E$41))","v":0},26.030607333836937]
[null,"Sucursal",null,null,946.17058768347817,179.44712219865582,{"$f":"+G$59*($E39/SUM($E$37:$E$41))","v":0},22371.198889151317,{"$f":"+I$59*($E39/SUM($E$37:$E$41))","v":1070.6546014212943},734.47086851726181,{"$f":"+K$59*($E39/SUM($E$37:$E$41))","v":0},42.549520824765722]
[null,"Sucursal",null,null,727.26128997276601,137.92961572776426,{"$f":"+G$59*($E40/SUM($E$37:$E$41))","v":0},17195.320985610888,{"$f":"+I$59*($E40/SUM($E$37:$E$41))","v":822.94425199931061},564.54114959655806,{"$f":"+K$59*($E40/SUM($E$37:$E$41))","v":0},32.70511660957915]
[null,"Direccion General",null,null,721.60208012443434,136.85631146908111,{"$f":"+G$59*($E41/SUM($E$37:$E$41))","v":0},17061.514977772029,{"$f":"+I$59*($E41/SUM($E$37:$E$41))","v":816.54048174540799},560.14815236484094,{"$f":"+K$59*($E41/SUM($E$37:$E$41))","v":0},32.450620570040599]
[null,null,null,null,3307.6295468999997,627.31246480999994,0,78205.388551020005,3742.8016050000001,2567.56823523,0,148.74490299999999]

{"sheet":"Hoja4","index":4,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,"BARRANQUILLA","RIOHACHA","FONSECA","VALLEDUPAR","ALBANIA"]
[null,null,"1","11","1","2","3","4","5","TOTAL"]
[null,"A",14430037431,2872269270.5,17302306701.5,13597372379,22701386474,13488661490,7888243721,74977970765.5]
[null,"B",928352405,162138195,1090490600,101809970,112673672,151194817,88651296,1544820355]
[null,"C",596021688,250584885,846606573,0,17493074,161651388,52559096,1078310131]
[null,"D",561684243,266887397,828571640,63567913,45928857,77434037,98772487,1114274934]
[null,"E",1273475406,315516205,1588991611,317488890,448350087,391150296,99793052,2845773936]
[null,"CARTERA BRUTA",17789571173,3867395952.5,21656967125.5,14080239152,23325832164,14270092028,8228019652,81561150121.5]
[null,"CARTERA VENCIA",null,null,4354660424,482866773,624445690,781430538,339775931,6583179356]
[null,null,null,null,0.20107434243978717,3.4293932637600985E-2,2.677056430868693E-2,5.4760020921148893E-2,4.1294982920636318E-2,8.0714645958194192E-2]
[]
[]
[null,"A",71289258.980000004,0,71289258.980000004,12723031,22370392,12193109,7191736,125767526.98]
[null,"B",8677319,1106426,9783745,7671564,1054165,10606739,825600,29941813]
[null,"C",58478004,12405369,70883373,0,1749307,16184680,9010223,97827583]
[null,"D",104644055,34880901,139524956,10666882,9185771,16955254,20246326,196579189]
[null,"E",1003182472,233960616,1237143088,270688661,352657684,341598318,76797229,2278884980]
[null,null,1246271108.98,282353312,1528624420.98,301750138,387017319,397538100,114071114,2729001091.98]
[null,null,null,null,0.28409633990785776,0.56058663825270083,0.56475317172899375,0.4371448278362523,0.2260231581853866,0.41454150713556831]
[]
[null,null,null,null,485717779.79895091,315788561.72779131,523146724.33153379,320046541.01384687,184536247.12787703,1829235854,null,1829.235854]
[null,null,null,null,2014342200.7789509,617538699.72779131,910164043.33153379,717584641.01384687,298607361.127877,4558236945.9799995]
[null,null,null,null,0.46257159104237677,1.278900794708008,1.457555169179779,0.91829613269330268,0.87883612076064621,0.6924066168462446]
[]
[null,"Aportes sociales",2770528711.3200016,2204067329.3200002,4974596040.6400013,3941856083.4700003,5832916804.5399923,4011708225.7199988,2359552772.8499956,21120629927.219986]