{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Hoja1","Norte","Sur","Este","Oeste"],"not_rendered":{"charts":1,"images":3,"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":"Hoja1","index":0,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,5,1,10],[1,2,1,3],[1,11,2,11]]}
["Norte"]
["Sur",null,"VENDEDOR",null,null,"Meses",null,null,null,null,null,"Total Semestre"]
["Este",null,null,null,null,1,2,3,4,5,6]
["Oeste",null,null,null,"LINA",{"$f":"IF($E$8=\"Norte\",VLOOKUP($E4,Norte!$A$3:$G$28,Hoja1!F$3+1,0),IF(Hoja1!$E$8=\"Sur\",VLOOKUP($E4,Sur!$A$3:$G$28,Hoja1!F$3+1,0),IF(Hoja1!$E$8=\"Este\",VLOOKUP($E4,Este!$A$3:$G$28,Hoja1!F$3+1,0),IF(Hoja1!$E$8=\"Oeste\",VLOOKUP($E4,Oeste!$A$3:$G$28,Hoja1!F$3+1,0)))))","v":91705},{"$f":"IF($E$8=\"Norte\",VLOOKUP($E4,Norte!$A$3:$G$28,Hoja1!G$3+1,0),IF(Hoja1!$E$8=\"Sur\",VLOOKUP($E4,Sur!$A$3:$G$28,Hoja1!G$3+1,0),IF(Hoja1!$E$8=\"Este\",VLOOKUP($E4,Este!$A$3:$G$28,Hoja1!G$3+1,0),IF(Hoja1!$E$8=\"Oeste\",VLOOKUP($E4,Oeste!$A$3:$G$28,Hoja1!G$3+1,0)))))","v":86718},{"$f":"IF($E$8=\"Norte\",VLOOKUP($E4,Norte!$A$3:$G$28,Hoja1!H$3+1,0),IF(Hoja1!$E$8=\"Sur\",VLOOKUP($E4,Sur!$A$3:$G$28,Hoja1!H$3+1,0),IF(Hoja1!$E$8=\"Este\",VLOOKUP($E4,Este!$A$3:$G$28,Hoja1!H$3+1,0),IF(Hoja1!$E$8=\"Oeste\",VLOOKUP($E4,Oeste!$A$3:$G$28,Hoja1!H$3+1,0)))))","v":22041},{"$f":"IF($E$8=\"Norte\",VLOOKUP($E4,Norte!$A$3:$G$28,Hoja1!I$3+1,0),IF(Hoja1!$E$8=\"Sur\",VLOOKUP($E4,Sur!$A$3:$G$28,Hoja1!I$3+1,0),IF(Hoja1!$E$8=\"Este\",VLOOKUP($E4,Este!$A$3:$G$28,Hoja1!I$3+1,0),IF(Hoja1!$E$8=\"Oeste\",VLOOKUP($E4,Oeste!$A$3:$G$28,Hoja1!I$3+1,0)))))","v":64170},{"$f":"IF($E$8=\"Norte\",VLOOKUP($E4,Norte!$A$3:$G$28,Hoja1!J$3+1,0),IF(Hoja1!$E$8=\"Sur\",VLOOKUP($E4,Sur!$A$3:$G$28,Hoja1!J$3+1,0),IF(Hoja1!$E$8=\"Este\",VLOOKUP($E4,Este!$A$3:$G$28,Hoja1!J$3+1,0),IF(Hoja1!$E$8=\"Oeste\",VLOOKUP($E4,Oeste!$A$3:$G$28,Hoja1!J$3+1,0)))))","v":67465},{"$f":"IF($E$8=\"Norte\",VLOOKUP($E4,Norte!$A$3:$G$28,Hoja1!K$3+1,0),IF(Hoja1!$E$8=\"Sur\",VLOOKUP($E4,Sur!$A$3:$G$28,Hoja1!K$3+1,0),IF(Hoja1!$E$8=\"Este\",VLOOKUP($E4,Este!$A$3:$G$28,Hoja1!K$3+1,0),IF(Hoja1!$E$8=\"Oeste\",VLOOKUP($E4,Oeste!$A$3:$G$28,Hoja1!K$3+1,0)))))","v":74065},{"$f":"SUM(F4:K4)","v":406164}]
[]
[null,null,null,null,"ANGELICA",{"$f":"IF($E$8=\"Norte\",VLOOKUP($E6,Norte!$A$3:$G$28,Hoja1!F$3+1,0),IF(Hoja1!$E$8=\"Sur\",VLOOKUP($E6,Sur!$A$3:$G$28,Hoja1!F$3+1,0),IF(Hoja1!$E$8=\"Este\",VLOOKUP($E6,Este!$A$3:$G$28,Hoja1!F$3+1,0),IF(Hoja1!$E$8=\"Oeste\",VLOOKUP($E6,Oeste!$A$3:$G$28,Hoja1!F$3+1,0)))))","v":77911},{"$f":"IF($E$8=\"Norte\",VLOOKUP($E6,Norte!$A$3:$G$28,Hoja1!G$3+1,0),IF(Hoja1!$E$8=\"Sur\",VLOOKUP($E6,Sur!$A$3:$G$28,Hoja1!G$3+1,0),IF(Hoja1!$E$8=\"Este\",VLOOKUP($E6,Este!$A$3:$G$28,Hoja1!G$3+1,0),IF(Hoja1!$E$8=\"Oeste\",VLOOKUP($E6,Oeste!$A$3:$G$28,Hoja1!G$3+1,0)))))","v":53526},{"$f":"IF($E$8=\"Norte\",VLOOKUP($E6,Norte!$A$3:$G$28,Hoja1!H$3+1,0),IF(Hoja1!$E$8=\"Sur\",VLOOKUP($E6,Sur!$A$3:$G$28,Hoja1!H$3+1,0),IF(Hoja1!$E$8=\"Este\",VLOOKUP($E6,Este!$A$3:$G$28,Hoja1!H$3+1,0),IF(Hoja1!$E$8=\"Oeste\",VLOOKUP($E6,Oeste!$A$3:$G$28,Hoja1!H$3+1,0)))))","v":25825},{"$f":"IF($E$8=\"Norte\",VLOOKUP($E6,Norte!$A$3:$G$28,Hoja1!I$3+1,0),IF(Hoja1!$E$8=\"Sur\",VLOOKUP($E6,Sur!$A$3:$G$28,Hoja1!I$3+1,0),IF(Hoja1!$E$8=\"Este\",VLOOKUP($E6,Este!$A$3:$G$28,Hoja1!I$3+1,0),IF(Hoja1!$E$8=\"Oeste\",VLOOKUP($E6,Oeste!$A$3:$G$28,Hoja1!I$3+1,0)))))","v":50541},{"$f":"IF($E$8=\"Norte\",VLOOKUP($E6,Norte!$A$3:$G$28,Hoja1!J$3+1,0),IF(Hoja1!$E$8=\"Sur\",VLOOKUP($E6,Sur!$A$3:$G$28,Hoja1!J$3+1,0),IF(Hoja1!$E$8=\"Este\",VLOOKUP($E6,Este!$A$3:$G$28,Hoja1!J$3+1,0),IF(Hoja1!$E$8=\"Oeste\",VLOOKUP($E6,Oeste!$A$3:$G$28,Hoja1!J$3+1,0)))))","v":55022},{"$f":"IF($E$8=\"Norte\",VLOOKUP($E6,Norte!$A$3:$G$28,Hoja1!K$3+1,0),IF(Hoja1!$E$8=\"Sur\",VLOOKUP($E6,Sur!$A$3:$G$28,Hoja1!K$3+1,0),IF(Hoja1!$E$8=\"Este\",VLOOKUP($E6,Este!$A$3:$G$28,Hoja1!K$3+1,0),IF(Hoja1!$E$8=\"Oeste\",VLOOKUP($E6,Oeste!$A$3:$G$28,Hoja1!K$3+1,0)))))","v":95414},{"$f":"SUM(F6:K6)","v":358239}]
[]
[null,null,null,null,"Sur"]

{"sheet":"Norte","index":1,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,0,6]]}
["VENDEDOR","VENTAS"]
[null,"Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6"]
["DIANA",10211,52904,22525,15861,59973,48366]
["ISABEL",63312,65573,96783,64900,13247,6179]
["ZORAIDA",29365,97749,78747,45934,85616,96131]
["LINA",88388,81891,64429,2983,70157,6553]
["ANGELICA",63707,51601,73547,47167,39838,62282]
["MARIA",55294,87252,15948,38758,77882,73423]
["TATIANA",88294,61104,84830,80959,93384,67170]
["NATALY",61386,19199,11881,95440,24242,99810]
["JHONY",51707,73057,26453,86968,65105,55548]
["CARLOS",39940,90178,52004,38303,77964,6696]
["CARLOS",45855,2388,65185,55123,73648,24227]
["GLORIA",78923,1661,57380,77936,27682,30838]
["LADY",96166,76884,82518,76311,89870,56719]
["JORGE",24714,58490,61404,97637,27411,67395]
["DIEGO",49000,97900,72247,56296,32420,82488]
["SANTIAGO",76549,78880,37796,2193,4407,66197]
["SINDY",77542,14294,94427,84403,13385,16159]
["DIEGO",71684,85267,97111,1591,23627,14065]
["ISABEL",60332,20238,64775,77701,66675,60986]
["MARIA",85277,33708,13731,44992,62765,11033]
["MARYORI",64091,64231,71908,28736,77537,70218]
["LEIDY",41585,46011,23941,71037,42379,22972]
["MILENA",17504,2168,2401,20693,77514,8732]
["CESAR",79892,53584,23563,42807,98629,50984]
["ALEXANDER",55362,69996,96706,35378,55407,19949]
["JHON",39411,59260,83297,75467,82085,75017]

{"sheet":"Sur","index":2,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,0,6]]}
["VENDEDOR","VENTAS"]
[null,"Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6"]
["DIANA",81627,17566,52572,51534,14636,78480]
["ISABEL",85119,16184,34290,34655,30965,47789]
["ZORAIDA",57040,98204,33250,23522,60064,24524]
["LINA",91705,86718,22041,64170,67465,74065]
["ANGELICA",77911,53526,25825,50541,55022,95414]
["MARIA",40168,27697,34796,99180,50948,89310]
["TATIANA",49925,14334,12653,22569,44032,75581]
["NATALY",87260,55533,79156,81216,36243,59050]
["JHONY",40396,77488,47109,27836,35598,95526]
["CARLOS",22779,33700,28965,17320,19641,41948]
["CARLOS",15591,18850,89822,31292,62937,27922]
["GLORIA",60300,29556,28394,74893,85701,51771]
["LADY",37821,36219,30340,76128,21480,13363]
["JORGE",84338,57306,39373,38394,28748,73988]
["DIEGO",66436,90246,28098,40160,30957,64374]
["SANTIAGO",80904,66682,69077,54172,93427,43098]
["SINDY",22651,94349,97844,53194,17925,22339]
["DIEGO",41375,66658,94360,12747,21116,50521]
["ISABEL",38473,27998,97829,77425,48394,16770]
["MARIA",13162,21183,14031,77153,89799,24736]
["MARYORI",20139,91807,29643,25611,88009,41905]
["LEIDY",69646,60474,35759,79764,52138,41290]
["MILENA",59987,41572,41857,21907,32811,16360]
["CESAR",67561,96317,35455,30587,42895,12503]
["ALEXANDER",67217,46851,87642,33722,92820,11450]
["JHON",32286,42596,64671,26767,44202,13371]

{"sheet":"Este","index":3,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,0,6]]}
["VENDEDOR","VENTAS"]
[null,"Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6"]
["DIANA",92599,73814,98100,21043,24602,29478]
["ISABEL",95610,67813,98128,37561,31795,31041]
["ZORAIDA",55832,64738,18433,58458,51560,98863]
["LINA",94951,87685,50763,45104,37329,45838]
["ANGELICA",28569,30038,41269,94364,46916,37051]
["MARIA",93335,48266,51642,42254,64699,49197]
["TATIANA",82229,66969,95659,21953,84442,88584]
["NATALY",81564,11734,49417,36483,81479,96314]
["JHONY",68726,38947,61098,64903,99279,19400]
["CARLOS",10125,10305,93184,80447,23109,94902]
["CARLOS",39932,58809,96132,76853,27100,63176]
["GLORIA",85387,71568,61771,81346,32706,44896]
["LADY",72594,24215,48292,90585,39120,11552]
["JORGE",55204,86830,41145,41744,11139,21477]
["DIEGO",15547,98484,66844,70939,95431,97722]
["SANTIAGO",20485,56281,13926,49857,28475,71437]
["SINDY",13471,34483,52255,26046,81457,30997]
["DIEGO",21874,44745,76342,31190,59293,33868]
["ISABEL",54838,38908,73135,94303,64907,55728]
["MARIA",45635,39578,23439,53409,82850,81601]
["MARYORI",46398,83596,44643,53665,38706,39847]
["LEIDY",82499,25060,22373,69851,51436,54414]
["MILENA",34245,12381,40606,35226,10143,54224]
["CESAR",46557,61629,63415,92346,73246,36010]
["ALEXANDER",13866,75075,98825,12128,47401,46326]
["JHON",39123,10608,16533,89518,93760,10860]

{"sheet":"Oeste","index":4,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,0,6]]}
["VENDEDOR","VENTAS"]
[null,"Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6"]
["DIANA",84143,53268,28108,62579,37522,64877]
["ISABEL",38370,56813,74050,90858,96510,16398]
["ZORAIDA",64126,69022,37348,27491,63157,16523]
["LINA",41680,37977,31878,57816,80584,54439]
["ANGELICA",11400,87253,71025,13118,53659,32970]
["MARIA",46436,89033,53410,32887,55413,37195]
["TATIANA",25306,48760,20548,10814,70659,54068]
["NATALY",30953,31828,33329,44305,96564,77619]
["JHONY",73466,15803,59206,66666,69556,57861]
["CARLOS",42609,85551,40202,40917,47063,60069]
["CARLOS",14996,96389,43468,38062,13970,22087]
["GLORIA",83345,71113,21270,45268,11058,86041]
["LADY",98598,96650,15773,27093,56501,81612]
["JORGE",44927,79204,24285,63402,79064,47347]
["DIEGO",21197,75033,68328,35569,90656,86522]
["SANTIAGO",55430,81205,28249,75459,88739,70198]
["SINDY",77523,89676,73446,46080,63813,52283]
["DIEGO",22951,58029,75451,39365,43819,88724]
["ISABEL",30698,25199,69358,79346,43254,96904]
["MARIA",58346,82463,78630,77545,93749,56565]
["MARYORI",91714,64511,21794,87558,46062,55554]
["LEIDY",49575,28035,96742,18634,27914,86395]
["MILENA",54686,53558,75896,15819,50302,30401]
["CESAR",18159,54583,80374,16746,79552,62152]
["ALEXANDER",20371,21000,45306,51398,62414,38173]
["JHON",83272,84379,90609,87766,28744,68036]