{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["BD","REPORTE","BACK","COBRO","WT","BASE"],"not_rendered":{"charts":10,"images":1,"macros":1,"external_links":1,"defined_names":12,"comments":0,"pivot_tables":19},"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":"part_too_large","date_system":"1900"}

{"sheet":"BD","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"read":"part_too_large"}

{"sheet":"REPORTE","index":1,"n_rows":117,"n_cols":61,"rows_kept":117,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"WEB TRACKING",null,null,null,null,"SERVIVIOS",null,null,null,"KPI",null,null,"OTIF",null,null,null,"ASERTIVIDAD",null,null,"PEDIDO PERFECTO",null,null,"NPS"]
[null,null,null,null,null,null,null,"TOTAL",{"$f":"+GETPIVOTDATA(\"Q\",$C$15)","v":27522},null,null,"EDE",{"$f":"+GETPIVOTDATA(\"EDE (%)\",$C$15)","v":0.97211016291698993},null,"%",{"$f":"+GETPIVOTDATA(\"OTIF (%)\",$C$15)","v":0.96532195500387896},null,null,"%",{"$f":"+GETPIVOTDATA(\"% ASERT\",$C$15)","v":0.90469356089992237},null,"%",{"$f":"+GETPIVOTDATA(\"PEREFCT (%)\",$C$15)","v":0.84078191991861062},null,"ENCUESTAS",{"$f":"+GETPIVOTDATA(\"NPS (Q)\",$C$15)","v":33}]
[null,null,"EN ALMACEN NATURA",null,{"$f":"+GETPIVOTDATA(\"NÚMERO PEDIDO\",WT!$D$10)","v":10},null,null,"01. AT",{"$f":"+GETPIVOTDATA(\"AT\",$C$15)","v":25061},{"$f":"+I8/$I$7","v":0.91058062640796456},null,"OTD",{"$f":"+GETPIVOTDATA(\"OTD (%)\",$C$15)","v":0.91058062640796456},null,"FALTA",{"$f":"+GETPIVOTDATA(\"FALTA\",$C$15)","v":158},{"$f":"+P8/I7","v":5.7408618559697698E-3},null,"ANTES",{"$f":"+GETPIVOTDATA(\"ANT\",$C$15)","v":1738},null,"NC TYD",{"$f":"+GETPIVOTDATA(\"NC TYD \",$C$15)","v":8},null,"%",{"$f":"+GETPIVOTDATA(\"NPS (%)\",$C$15)","v":1.199040767386091E-3}]
[null,null,"ENTRGADOS SIN IMAGEN",null,{"$f":"+GETPIVOTDATA(\"NÚMERO PEDIDO\",WT!$I$10)","v":4697},null,null,"02. FT",{"$f":"+GETPIVOTDATA(\"FT\",$C$15)","v":719},{"$f":"+I9/$I$7","v":2.6124554901533318E-2},null,"OTIF",{"$f":"+GETPIVOTDATA(\"OTIF (%)\",$C$15)","v":0.96532195500387896},null,"DAÑO",{"$f":"+GETPIVOTDATA(\"DAÑO\",$C$15)","v":17},{"$f":"+P9/I7","v":6.1768766804738023E-4},null,"ASERT",{"$f":"+GETPIVOTDATA(\"ASE\",$C$15)","v":23323},null,"% NC TYD",{"$f":"+GETPIVOTDATA(\"NC TYD (%)\",$C$15)","v":2.9067654966935541E-4},null,"PROMO",{"$f":"+GETPIVOTDATA(\"PROM\",$C$15)","v":31}]
[null,null,"LIQUIDADOS SIN STOPPER",null,{"$f":"+GETPIVOTDATA(\"NÚMERO PEDIDO\",WT!$N$10)","v":1042},null,null,"03. NE",{"$f":"+GETPIVOTDATA(\"NE\",$C$15)","v":1683},{"$f":"+I10/$I$7","v":6.1151079136690649E-2},null,"PERFECT",{"$f":"+GETPIVOTDATA(\"PEREFCT (%)\",$C$15)","v":0.84078191991861062},null,null,null,null,null,"DESPUES",{"$f":"+GETPIVOTDATA(\"DES\",$C$15)","v":719},null,null,null,null,"NEU",{"$f":"+GETPIVOTDATA(\"NEUT\",$C$15)","v":1}]
[null,null,null,null,null,null,null,"04 .NULL",{"$f":"+GETPIVOTDATA(\"NULO\",$C$15)","v":59},{"$f":"+I11/$I$7","v":2.1437395538114962E-3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DETRACT",{"$f":"+GETPIVOTDATA(\"DETR\",$C$15)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTA",{"$f":"+GETPIVOTDATA(\"NOTA (NPS)\",$C$15)","v":0.90909090909090906}]
[]
[]
[null,null,null,"Valores"]
[null,null,null,"Q","AT","FT","EDE (%)","NE","WIP (%)","NULO","OTD (%)","FALTA","DAÑO","OTIF (%)","NC TYD ","NC TYD (%)","NC PEND","ANT","ASE","DES","% ASERT","C TEO","C REAL","DIF","PEREFCT (%)","NPS (Q)","NPS (%)","PROM","NEUT","DETR","NOTA (NPS)"]
[null,null,"Total",27522,25061,719,0.97211016291698993,1683,6.1151079136690649E-2,59,0.91058062640796456,158,17,0.96532195500387896,8,2.9067654966935541E-4,1,1738,23323,719,0.90469356089992237,1.174878279194826,1.0458882854926299,-0.16435221101629169,0.84078191991861062,33,1.199040767386091E-3,31,1,1,0.90909090909090906]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Valores"]
[null,null,"MODELO","Q","AT","FT","EDE (%)","NE","WIP (%)","NULO","OTD (%)","FALTA","DAÑO","OTIF (%)","NC TYD ","NC TYD (%)","NC PEND","ANT","ASE","DES","% ASERT","C TEO","C REAL","DIF","PEREFCT (%)","NPS (Q)","NPS (%)","PROM","NEUT","DETR","NOTA (NPS)"]
[null,null,"01. INICIO",1047,953,62,0.93891625615763552,17,1.6236867239732569E-2,15,0.91021967526265524,7,0,0.93201970443349758,0,0,0,68,885,62,0.8719211822660099,1.1728748806112703,1.1142857142857143,-7.2906403940886697E-2,0.83858643744030559,0,0,null,null,null,0]
[null,null,"02. DIAMANTE",764,752,12,0.98429319371727753,0,0,0,0.98429319371727753,9,6,0.96465968586387429,0,0,0,59,693,12,0.90706806282722519,1.2264397905759161,1.0222513089005236,-0.2356020942408377,0.88743455497382195,1,1.3089005235602095E-3,1,0,0,1]
[null,null,"03. COL",14,14,0,1,0,0,0,1,0,0,1,0,0,0,0,14,0,1,1,1,0,1,0,0,null,null,null,0]
[null,null,"04. VD",20561,19868,540,0.97353978831830656,115,5.5931131754292105E-3,38,0.96629541364719618,142,11,0.9660427283418267,7,3.4045036720003888E-4,1,1365,18503,540,0.90665425323402582,1.1841350128884782,1.0433163465307722,-0.16493531948255585,0.89212586936433058,32,1.5563445357716064E-3,30,1,1,0.90625]
[null,null,"05. VOL",2896,2786,71,0.97514875743787188,34,1.1740331491712707E-2,5,0.96201657458563539,0,0,0.97514875743787188,1,3.453038674033149E-4,0,78,2708,71,0.94784739236961846,1.0728591160220995,1.0360518025901295,-4.5502275113755687E-2,0.93473756906077343,0,0,null,null,null,0]
[null,null,"06. SAC",436,411,20,0.95359628770301619,5,1.1467889908256881E-2,0,0.94266055045871555,0,0,0.95359628770301619,0,0,0,42,369,20,0.85614849187935038,1.2637614678899083,1.0835266821345708,-0.22505800464037123,0.84633027522935778,0,0,null,null,null,0]
[null,null,"07. PROPA",171,153,14,0.91616766467065869,3,1.7543859649122806E-2,1,0.89473684210526316,0,0,0.91616766467065869,0,0,0,2,151,14,0.90419161676646709,1.0584795321637428,1.1017964071856288,0.11976047904191617,0.88304093567251463,0,0,null,null,null,0]
[null,null,"TOTAL",25889,24937,719,0.97197536638603055,174,6.7210011974197532E-3,59,0.96322762563250797,158,17,0.96515434985968196,8,3.0901154930665532E-4,1,1614,23323,719,0.90906610539444965,1.1728919618370737,1.0457202993451824,-0.1491658871219208,0.89381590636950059,33,1.2746726408899532E-3,31,1,1,0.90909090909090906]
[]
[null,null,null,"Valores"]
[null,null,"SALIDA","Q","AT","FT","EDE (%)","NE","WIP (%)","NULO","OTD (%)","FALTA","DAÑO","OTIF (%)","NC TYD ","NC TYD (%)","NC PEND","ANT","ASE","DES","% ASERT","C TEO","C REAL","DIF","PEREFCT (%)","NPS (Q)","NPS (%)","PROM","NEUT","DETR","NOTA (NPS)"]
[null,null,"01. URB",24929,24013,702,0.97159619664171559,158,6.3379999197721529E-3,56,0.96325564603473868,132,12,0.96576977544001619,8,3.2091138834289382E-4,1,854,23159,702,0.93704228201497064,1.0938264671667537,1.0405017196034796,-6.3686020635241758E-2,0.92290103895061981,32,1.2836455533715753E-3,30,1,1,0.90625]
[null,null,"02. FAU",960,924,17,0.98193411264612118,16,1.6666666666666666E-2,3,0.96250000000000002,26,5,0.94899043570669506,0,0,0,760,164,17,0.17428267800212541,3.2260416666666667,1.1827842720510096,-2.394261424017003,0.13854166666666667,1,1.0416666666666667E-3,1,0,0,1]
[null,null,"TOTAL",25889,24937,719,0.97197536638603055,174,6.7210011974197532E-3,59,0.96322762563250797,158,17,0.96515434985968196,8,3.0901154930665532E-4,1,1614,23323,719,0.90906610539444965,1.1728919618370737,1.0457202993451824,-0.1491658871219208,0.89381590636950059,33,1.2746726408899532E-3,31,1,1,0.90909090909090906]
[]
[]
[]
[null,null,"FECHA DE DESPACHO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FECHA DE COMPROMISO"]
[null,null,null,"Valores",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valores"]
[null,null,"FECHA_CIERRE_MINUTA","Q","AT","FT","EDE (%)","NE","WIP (%)","NULO","OTD (%)","FALTA","DAÑO","OTIF (%)","NC TYD ","NC TYD (%)","NC PEND","ANT","ASE","DES","% ASERT","C TEO","C REAL","DIF","PEREFCT (%)","NPS (Q)","NPS (%)","PROM","NEUT","DETR","NOTA (NPS)",null,"COMPROMISO","Q","AT","FT","EDE (%)","NE","WIP (%)","NULO","OTD (%)","FALTA","DAÑO","OTIF (%)","NC TYD ","NC TYD (%)","NC PEND","ANT","ASE","DES","% ASERT","C TEO","C REAL","DIF","PEREFCT (%)","NPS (Q)","NPS (%)","PROM","NEUT","DETR","NOTA (NPS)"]
[null,null,45691,3235,3122,96,0.9701678060907396,7,2.1638330757341576E-3,10,0.96506955177743436,35,6,0.95742697327532633,3,9.2735703245749618E-4,0,142,2980,96,0.92604101926662519,1.1341576506955178,1.0447482908638905,-8.980733374766936E-2,0.90757341576506956,8,2.4729520865533232E-3,8,0,0,1,null,45681,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,-12,1,13,0,0,0,null,null,null,0]
[null,null,45692,1002,970,30,0.97,0,0,2,0.96806387225548907,9,0,0.96099999999999997,0,0,0,268,702,30,0.70199999999999996,1.7994011976047903,1.133,-0.67600000000000005,0.69161676646706582,6,5.9880239520958087E-3,6,0,0,1,null,45684,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,-10,1,10,0,0,0,null,null,null,0]
[null,null,45693,2757,2652,86,0.96859021183345506,10,3.6271309394269131E-3,9,0.9619151251360174,18,0,0.96201607012417822,1,3.6271309394269132E-4,0,149,2503,86,0.91417092768444119,1.1552412042074718,1.0577063550036523,-0.14609203798392986,0.90097932535364522,10,3.6271309394269131E-3,9,0,1,0.8,null,45692,3092,2979,96,0.96878048780487802,7,2.2639068564036221E-3,10,0.96345407503234148,29,6,0.95739837398373984,3,9.7024579560155242E-4,0,0,2979,96,0.96878048780487802,1,1.0426016260162601,4.2926829268292686E-2,0.95116429495472188,8,2.5873221216041399E-3,8,0,0,1]
[null,null,45694,2164,2082,62,0.97108208955223885,10,4.6210720887245845E-3,10,0.96210720887245837,14,0,0.96455223880597019,2,9.2421441774491681E-4,0,183,1899,62,0.88572761194029848,1.2536968576709797,1.0592350746268657,-0.27285447761194032,0.87014787430683915,4,1.8484288354898336E-3,4,0,0,1,null,45693,734,702,30,0.95901639344262291,0,0,2,0.95640326975476841,4,0,0.95355191256830596,0,0,0,0,702,30,0.95901639344262291,1,1.0532786885245902,5.3278688524590161E-2,0.95095367847411449,5,6.8119891008174387E-3,5,0,0,1]
[null,null,45695,1127,1089,34,0.96972395369545861,2,1.7746228926353151E-3,2,0.96628216503992903,11,7,0.95369545859305427,0,0,0,157,932,34,0.82991985752448794,1.4214729370008874,1.0507569011576134,-0.4790739091718611,0.8110026619343389,4,3.5492457852706301E-3,4,0,0,1,null,45694,2606,2503,84,0.96752995747970627,10,3.8372985418265539E-3,9,0.96047582501918649,14,0,0.96211828372632391,1,3.8372985418265541E-4,0,4,2499,84,0.96598376497873983,1.0030698388334613,1.054116737533823,5.6049478160030926E-2,0.95318495778971601,9,3.4535686876438986E-3,8,0,1,0.77777777777777779]
[null,null,45696,958,923,32,0.96649214659685867,1,1.0438413361169101E-3,2,0.9634655532359081,8,0,0.95811518324607325,1,1.0438413361169101E-3,0,78,845,32,0.88481675392670156,1.2515657620041754,1.0502617801047121,-0.19895287958115182,0.87265135699373697,1,1.0438413361169101E-3,0,1,0,0,null,45695,2126,2046,62,0.97058823529411764,10,4.7036688617121351E-3,8,0.96237064910630288,18,0,0.9620493358633776,2,9.4073377234242712E-4,0,143,1903,62,0.90275142314990509,1.1966133584195673,1.0498102466793169,-0.14231499051233396,0.88570084666039506,4,1.8814675446848542E-3,4,0,0,1]
[null,null,45698,1259,1218,35,0.97206703910614523,1,7.9428117553613975E-4,5,0.96743447180301823,12,1,0.96169193934557062,0,0,0,130,1088,35,0.86831604150039909,1.318506751389992,1.0422984836392657,-0.27853152434158018,0.85385226370135026,0,0,null,null,null,0,null,45696,1234,1195,34,0.97233523189585025,2,1.6207455429497568E-3,3,0.96839546191247972,10,7,0.95850284784377537,0,0,0,265,930,34,0.75671277461350694,1.6442463533225284,1.111472742066721,-0.50691619202603744,0.73987034035656407,4,3.2414910858995136E-3,4,0,0,1]
[null,null,45699,1100,1061,35,0.96806569343065696,0,0,4,0.96454545454545459,8,0,0.96076642335766427,0,0,0,47,1014,35,0.92518248175182483,1.1245454545454545,1.042883211678832,-8.3029197080291967E-2,0.91454545454545455,0,0,null,null,null,0,null,45698,1024,991,31,0.96966731898238745,1,9.765625E-4,1,0.9677734375,13,0,0.95694716242661448,1,9.765625E-4,0,145,846,31,0.82778864970645794,1.4326171875,1.057729941291585,-0.51761252446183958,0.8125,2,1.953125E-3,1,1,0,0.5]
[null,null,45700,1033,1003,28,0.97284190106692536,0,0,2,0.97095837366892546,3,1,0.96896217264791462,0,0,0,63,940,28,0.91173617846750732,1.1800580832526621,1.0349175557710961,-0.19980601357904948,0.90609874152952563,0,0,null,null,null,0,null,45699,1312,1269,36,0.97241379310344822,1,7.6219512195121954E-4,6,0.96722560975609762,11,1,0.9632183908045977,0,0,0,183,1086,36,0.83218390804597697,1.4245426829268293,1.0659003831417624,-0.49808429118773945,0.81859756097560976,0,0,null,null,null,0]
[null,null,45701,1033,996,33,0.96793002915451898,0,0,4,0.96418199419167472,6,0,0.96209912536443154,0,0,0,54,942,33,0.91545189504373181,1.1606969990319458,1.0437317784256559,-0.16618075801749271,0.90609874152952563,0,0,null,null,null,0,null,45700,1216,1177,35,0.97112211221122113,0,0,4,0.96792763157894735,11,0,0.96204620462046209,0,0,0,160,1017,35,0.83910891089108908,1.4004934210526316,1.0396039603960396,-0.48927392739273928,0.82730263157894735,1,8.2236842105263153E-4,1,0,0,1]
[null,null,45702,894,857,31,0.96509009009009006,1,1.1185682326621924E-3,5,0.95861297539149892,7,0,0.9572072072072072,0,0,0,41,816,31,0.91891891891891897,1.1319910514541387,1.0416666666666667,-0.10022522522522523,0.90492170022371365,0,0,null,null,null,0,null,45701,1053,1022,28,0.97333333333333338,0,0,3,0.97056030389363723,0,1,0.97238095238095235,0,0,0,81,941,28,0.8961904761904762,1.2307692307692308,1.04,-0.18952380952380951,0.89268755935422606,0,0,null,null,null,0]
[null,null,45703,452,435,15,0.96666666666666667,1,2.2123893805309734E-3,1,0.96238938053097345,0,2,0.9622222222222222,1,2.2123893805309734E-3,0,29,406,15,0.90222222222222226,1.2013274336283186,1.0666666666666667,-0.13555555555555557,0.8915929203539823,0,0,null,null,null,0,null,45702,1099,1061,34,0.9689497716894977,0,0,4,0.96542311191992725,6,0,0.9634703196347032,0,0,0,121,940,34,0.85844748858447484,1.3266606005459509,1.0383561643835617,-0.28584474885844746,0.84986351228389445,0,0,null,null,null,0]
[null,null,45705,1234,1189,41,0.96666666666666667,4,3.2414910858995136E-3,0,0.9635332252836305,8,0,0.9601626016260163,0,0,0,62,1127,41,0.91626016260162602,1.0931928687196111,1.0439024390243903,-4.9593495934959347E-2,0.90680713128038903,0,0,null,null,null,0,null,45703,908,872,30,0.96674057649667411,1,1.1013215859030838E-3,5,0.96035242290748901,6,0,0.96008869179600886,0,0,0,55,817,30,0.90576496674057649,1.1916299559471366,1.0565410199556542,-0.10310421286031042,0.89317180616740088,0,0,null,null,null,0]
[null,null,45706,1424,1376,42,0.97038081805359666,5,3.5112359550561797E-3,1,0.9662921348314607,5,0,0.96685472496473912,0,0,0,84,1292,42,0.91114245416078987,1.103932584269663,1.0430183356840621,-6.2059238363892807E-2,0.9037921348314607,0,0,null,null,null,0,null,45705,479,462,15,0.96855345911949686,1,2.0876826722338203E-3,1,0.964509394572025,3,2,0.95807127882599585,1,2.0876826722338203E-3,0,57,405,15,0.84905660377358494,1.3507306889352819,1.0440251572327044,-0.42348008385744235,0.83298538622129437,0,0,null,null,null,0]
[null,null,45707,1822,1757,51,0.97179203539823011,12,6.5861690450054883E-3,2,0.96432491767288697,8,0,0.96736725663716816,0,0,0,95,1662,51,0.91924778761061943,1.0960482985729967,1.0392699115044248,-5.7522123893805309E-2,0.90779363336992314,0,0,null,null,null,0,null,45706,1229,1184,41,0.966530612244898,4,3.2546786004882017E-3,0,0.96338486574450777,8,0,0.96,0,0,0,58,1126,41,0.91918367346938779,1.144833197721725,1.0473469387755101,-0.14448979591836736,0.90968266883645243,0,0,null,null,null,0]
[null,null,45708,2371,2283,66,0.97190293742017875,22,9.2787853226486711E-3,0,0.96288485870940532,3,0,0.97062579821200512,0,0,1,127,2156,66,0.91783737760749251,1.1054407423028259,1.0344827586206897,-0.1068539804171988,0.90805567271193588,0,0,null,null,null,0,null,45707,1396,1349,41,0.97050359712230216,5,3.5816618911174787E-3,1,0.96633237822349571,10,0,0.96330935251798566,0,0,0,58,1291,41,0.92877697841726614,1.1024355300859598,1.0402877697841726,-9.0647482014388492E-2,0.91762177650429799,0,0,null,null,null,0]
[null,null,45709,2155,2048,2,0.99902439024390244,105,4.8723897911832945E-2,0,0.95034802784222738,3,0,0.9975609756097561,0,0,0,29,2019,2,0.98487804878048779,1.0338747099767982,1.0004878048780488,-4.2926829268292686E-2,0.93549883990719263,0,0,null,null,null,0,null,45708,1819,1755,52,0.97122302158273377,11,6.0472787245739413E-3,1,0.96481583287520611,8,0,0.96679579413392358,0,0,0,93,1662,52,0.91975650249031549,1.0995052226498077,1.0415052573325954,-5.9214167127836191E-2,0.90929081913139087,0,0,null,null,null,0]
[null,null,45710,1502,0,0,0,1502,1,0,0,0,0,0,0,0,0,0,0,0,0,1.0166444740346205,0,0,0,0,0,null,null,null,0,null,45709,2339,2251,67,0.97109577221742882,21,8.9781958101752893E-3,0,0.96237708422402735,4,0,0.96937014667817079,0,0,1,91,2160,67,0.93183779119930976,1.0748182984181274,1.0349439171699741,-3.8826574633304571E-2,0.92176143651132958,0,0,null,null,null,0]
[null,null,"TOTAL",27522,25061,719,0.97211016291698993,1683,6.1151079136690649E-2,59,0.91058062640796456,158,17,0.96532195500387896,8,2.9067654966935541E-4,1,1738,23323,719,0.90469356089992237,1.174878279194826,1.0458882854926299,-0.16435221101629169,0.84078191991861062,33,1.199040767386091E-3,31,1,1,0.90909090909090906,null,45710,2221,2119,1,0.99952830188679243,100,4.5024763619990998E-2,1,0.95407474110760915,3,0,0.99811320754716981,0,0,0,100,2019,1,0.95235849056603772,1.0769923457901847,1.0009433962264151,-7.7358490566037733E-2,0.90769923457901847,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45712,1573,84,0,1,1489,0.94659885568976476,0,5.3401144310235217E-2,0,0,1,0,0,0,84,0,0,0,1.1042593769866498,1.1071428571428572,-2.8214285714285716,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45713,25,17,0,1,8,0.32,0,0.68,0,0,1,0,0,0,17,0,0,0,3.2,1,-3.4705882352941178,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45714,27,16,0,1,11,0.40740740740740738,0,0.59259259259259256,0,0,1,0,0,0,16,0,0,0,4.1851851851851851,1.0625,-4.9375,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45715,8,7,0,1,1,0.125,0,0.875,0,0,1,0,0,0,7,0,0,0,5,1,-5,0,0,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",27522,25061,719,0.97211016291698993,1683,6.1151079136690649E-2,59,0.91058062640796456,158,17,0.96532195500387896,8,2.9067654966935541E-4,1,1738,23323,719,0.90469356089992237,1.174878279194826,1.0458882854926299,-0.16435221101629169,0.84078191991861062,33,1.199040767386091E-3,31,1,1,0.90909090909090906]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"CONCEPT","Q","AT","FT","EDE (%)","NE","WIP (%)","NULO","OTD (%)","FALTA","DAÑO","OTIF (%)","NC TYD ","NC TYD (%)","NC PEND","ANT","ASE","DES","% ASERT","C TEO","C REAL","DIF","PEREFCT (%)","NPS (Q)","NPS (%)","PROM","NEUT","DETR","NOTA (NPS)"]
[null,null,"La Libertad",1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,1,1,0,0,0,null,null,null,0]
[null,null,"Lima",27521,25061,718,0.97214787229915822,1683,6.1153301115511788E-2,59,0.91061371316449258,158,17,0.96535940106288065,8,2.9068711166018677E-4,1,1738,23323,718,0.90472865510686995,1.1748846335525598,1.0458900655572365,-0.16439737771053958,0.84081247047709018,33,1.1990843355982703E-3,31,1,1,0.90909090909090906]
[null,null,"Barranca",405,357,19,0.94946808510638303,27,6.6666666666666666E-2,2,0.88148148148148153,3,5,0.92819148936170215,0,0,0,94,263,19,0.69946808510638303,1.6938271604938271,1.0797872340425532,-0.77659574468085102,0.62962962962962965,0,0,null,null,null,0]
[null,null,"Cajatambo",1,1,0,1,0,0,0,1,0,0,1,0,0,0,0,1,0,1,2,2,0,1,0,0,null,null,null,0]
[null,null,"Callao",3214,2954,30,0.98994638069705099,222,6.9072806471686371E-2,8,0.91910392034847543,16,3,0.98357908847184983,1,3.1113876789047915E-4,0,0,2954,30,0.98994638069705099,0.99595519601742377,1.0137399463806971,1.8431635388739945E-2,0.91288114499066586,5,1.5556938394523958E-3,4,1,0,0.8]
[null,null,"Canta",13,12,0,1,1,7.6923076923076927E-2,0,0.92307692307692313,0,0,1,0,0,0,8,4,0,0.33333333333333331,2,1.3333333333333333,-1.0833333333333333,0.30769230769230771,0,0,null,null,null,0]
[null,null,"Huaral",677,640,3,0.99533437013996895,34,5.0221565731166914E-2,0,0.94534711964549478,2,0,0.99222395023328147,0,0,0,615,25,3,3.8880248833592534E-2,3.5952732644017726,1.0451010886469674,-3.0917573872472786,3.3973412112259974E-2,1,1.4771048744460858E-3,1,0,0,1]
[null,null,"Huarochiri",88,72,9,0.88888888888888884,6,6.8181818181818177E-2,1,0.81818181818181823,0,0,0.88888888888888884,0,0,0,14,58,9,0.71604938271604934,1.2613636363636365,1.1975308641975309,-3.7037037037037035E-2,0.65909090909090906,0,0,null,null,null,0]
[null,null,"Huaura",1078,1011,0,1,64,5.9369202226345084E-2,3,0.93784786641929496,38,0,0.96241345202769535,0,0,0,978,33,0,3.2640949554896145E-2,3.4777365491651206,1.1859545004945597,-2.8387734915924825,-4.6382189239332098E-3,2,1.8552875695732839E-3,2,0,0,1]
[null,null,"Lima",22028,19997,657,0.96819018107872568,1329,6.0332304339930996E-2,45,0.90779916469947342,98,9,0.96300958652077084,7,3.1777737425095335E-4,1,12,19985,657,0.96760917981988959,1.0009987288905029,1.0422194248087537,4.5463348503921759E-2,0.90207917196295628,25,1.1349191937534047E-3,24,0,1,0.92]
[null,null,"Oyon",17,17,0,1,0,0,0,1,1,0,0.94117647058823528,0,0,0,17,0,0,0,4.4117647058823533,1.1176470588235294,-3.8823529411764706,-5.8823529411764705E-2,0,0,null,null,null,0]
[null,null,"TOTAL",27522,25061,719,0.97211016291698993,1683,6.1151079136690649E-2,59,0.91058062640796456,158,17,0.96532195500387896,8,2.9067654966935541E-4,1,1738,23323,719,0.90469356089992237,1.174878279194826,1.0458882854926299,-0.16435221101629169,0.84078191991861062,33,1.199040767386091E-3,31,1,1,0.90909090909090906]

{"sheet":"BACK","index":2,"n_rows":59,"n_cols":23,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"EVALUACION","02. FT","EVALUACION","02. FT","EVALUACION","02. FT","EVALUACION","02. FT","EVALUACION","02. FT","EVALUACION","02. FT",null,null,null,"EVALUACION","(Varios elementos)",null,"EVALUACION","(Varios elementos)"]
[]
[null,"Etiquetas de fila","Cuenta de SERVICIO","Etiquetas de fila","Cuenta de SERVICIO","Etiquetas de fila","Cuenta de SERVICIO","Etiquetas de fila","Cuenta de SERVICIO","Etiquetas de fila","Cuenta de SERVICIO","Etiquetas de fila","Suma de SERVICIO",null,null,null,"Etiquetas de fila","Cuenta de SERVICIO",null,"Etiquetas de fila","PEDS","% EDE","NE."]
[null,"AUSENTE PRIMERA VISITA",498,45691,96,45681,1,"01. URB",702,"Barranca",19,1,509,null,null,null,1,24839,null,45681,1,0,0]
[null,"AUSENTE SEGUNDA VISITA ",112,45692,30,45684,1,"02. FAU",17,"Barranca",13,2,133,null,null,null,2,768,null,45684,1,0,0]
[null," AUSENTE PRIMERA VISITA",44,45693,86,45692,96,"Total general",719,"Supe",6,3,42,null,null,null,3,119,null,45692,3082,0.96878048780487802,7]
[null,"DIRECCION INCOMPLETA",24,45694,62,45693,30,null,null,"Callao",30,4,20,null,null,null,4,35,null,45693,732,0.95901639344262291,0]
[null,"NO VIVE AHÍ",18,45695,34,45694,84,null,null,"Callao",17,5,9,null,null,null,5,13,null,45694,2597,0.96752995747970627,10]
[null,"ENTREGADO",9,45696,32,45695,62,null,null,"La Perla",5,6,3,null,null,null,6,3,null,45695,2118,0.97058823529411764,10]
[null,"SIN CONTACTO",8,45698,35,45696,34,null,null,"Bellavista",3,10,1,null,null,null,11,1,null,45696,1231,0.97233523189585025,2]
[null,"RECHAZADO",3,45699,35,45698,31,null,null,"Carmen de La Legua",3,11,1,null,null,null,0,1,null,45698,1023,0.96966731898238745,1]
[null,"AUSENTE TERCERA VISITA ",2,45700,28,45699,36,null,null,"Ventanilla",2,13,1,null,null,null,-3,1,null,45699,1306,0.97241379310344822,1]
[null,"PROBLEMA CLIMATICO",1,45701,33,45700,35,null,null,"Huaral",3,"Total general",719,null,null,null,"Total general",25780,null,45700,1212,0.97112211221122113,0]
[null,"Total general",719,45702,31,45701,28,null,null,"Aucallama",1,null,null,null,null,null,null,null,null,45701,1050,0.97333333333333338,0]
[null,null,null,45703,15,45702,34,null,null,"Huaral",1,null,null,null,null,null,null,null,null,45702,1095,0.9689497716894977,0]
[null,null,null,45705,41,45703,30,null,null,"Chancay",1,null,null,null,null,null,null,null,null,45703,903,0.96674057649667411,1]
[null,null,null,45706,42,45709,67,null,null,"Huarochiri",9,null,null,null,null,null,null,null,null,45709,2339,0.97109577221742882,21]
[null,null,null,45707,51,45705,15,null,null,"San Antonio",5,null,null,null,null,null,null,null,null,45705,478,0.96855345911949686,1]
[null,null,null,45708,66,45706,41,null,null,"Santa Eulalia",3,null,null,null,null,null,null,null,null,45706,1229,0.966530612244898,4]
[null,null,null,45709,2,45707,41,null,null,"Matucana",1,null,null,null,null,null,null,null,null,45707,1395,0.97050359712230216,5]
[null,null,null,"Total general",719,45708,52,null,null,"Lima",657,null,null,null,null,null,null,null,null,45708,1818,0.97122302158273377,11]
[null,null,null,null,null,45710,1,null,null,"San Juan de Lurigancho",92,null,null,null,null,null,null,null,null,45710,2220,0.99952830188679243,100]
[null,null,null,null,null,"Total general",719,null,null,"Chorrillos",85,null,null,null,null,null,null,null,null,45712,1573,1,1489]
[null,null,null,null,null,null,null,null,null,"Ate",72,null,null,null,null,null,null,null,null,45713,25,1,8]
[null,null,null,null,null,null,null,null,null,"San Juan de Miraflores",63,null,null,null,null,null,null,null,null,45714,27,1,11]
[null,null,null,null,null,null,null,null,null,"Santiago de Surco",60,null,null,null,null,null,null,null,null,45715,8,1,1]
[null,null,null,null,null,null,null,null,null,"Villa El Salvador",53,null,null,null,null,null,null,null,null,"Total general",27463,0.97211016291698993,1683]
[null,null,null,null,null,null,null,null,null,"Lurigancho",38]
[null,null,null,null,null,null,null,null,null,"Lurin",37]
[null,null,null,null,null,null,null,null,null,"Villa Maria del Triunfo",32]
[null,null,null,null,null,null,null,null,null,"Lima",28]
[null,null,null,null,null,null,null,null,null,"Santa Anita",24]
[null,null,null,null,null,null,null,null,null,"Pachacamac",17]
[null,null,null,null,null,null,null,null,null,"Barranco",11]
[null,null,null,null,null,null,null,null,null,"Chaclacayo",9]
[null,null,null,null,null,null,null,null,null,"Jesus Maria",8]
[null,null,null,null,null,null,null,null,null,"La Molina",4]
[null,null,null,null,null,null,null,null,null,"San Isidro",3]
[null,null,null,null,null,null,null,null,null,"Independencia",3]
[null,null,null,null,null,null,null,null,null,"Pueblo Libre",2]
[null,null,null,null,null,null,null,null,null,"Rimac",2]
[null,null,null,null,null,null,null,null,null,"Cieneguilla",2]
[null,null,null,null,null,null,null,null,null,"Pucusana",2]
[null,null,null,null,null,null,null,null,null,"San Borja",1]
[null,null,null,null,null,null,null,null,null,"Punta Hermosa",1]
[null,null,null,null,null,null,null,null,null,"San Martin de Porres",1]
[null,null,null,null,null,null,null,null,null,"Surquillo",1]
[null,null,null,null,null,null,null,null,null,"Los Olivos",1]
[null,null,null,null,null,null,null,null,null,"Breña",1]
[null,null,null,null,null,null,null,null,null,"Comas",1]
[null,null,null,null,null,null,null,null,null,"Carabayllo",1]
[null,null,null,null,null,null,null,null,null,"Miraflores",1]
[null,null,null,null,null,null,null,null,null,"Magdalena del Mar",1]
[null,null,null,null,null,null,null,null,null,"Trujillo",1]
[null,null,null,null,null,null,null,null,null,"Trujillo",1]
[null,null,null,null,null,null,null,null,null,"Total general",719]

{"sheet":"COBRO","index":3,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"COBRO DE PEDIDOS"]
[]
[]
[null,null,"EVALUACION","03. NE"]
[]
[null,null,null,"Etiquetas de columna"]
[null,null,null,2,null,"Total Q","Total MONTO"]
[null,null,"COMPROMISO","Q","MONTO"]
[null,null,45692,7,1292.27,7,1292.27]
[null,null,45694,10,3683.2100000000009,10,3683.2100000000009]
[null,null,45695,10,2444.2199999999998,10,2444.2199999999998]
[null,null,45696,2,0,2,0]
[null,null,45698,1,0,1,0]
[null,null,45699,1,203.1,1,203.1]
[null,null,45703,1,370.78,1,370.78]
[null,null,45709,21,5144.5599999999995,21,5144.5599999999995]
[null,null,45705,1,277.39999999999998,1,277.39999999999998]
[null,null,45706,4,466.87,4,466.87]
[null,null,45707,5,1172.77,5,1172.77]
[null,null,45708,11,2356.2599999999998,11,2356.2599999999998]
[null,null,45710,100,20698.52,100,20698.52]
[null,null,45712,1489,445488.39999999979,1489,445488.39999999979]
[null,null,45713,8,1336.86,8,1336.86]
[null,null,45714,11,2333.3900000000003,11,2333.3900000000003]
[null,null,45715,1,141.6,1,141.6]
[null,null,"Total general",1683,487410.20999999973,1683,487410.20999999979]

{"sheet":"WT","index":4,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"WEB TRACKING"]
[]
[]
[null,null,null,"PEDIDOS EN ALMACEN NATURA",null,null,null,null,"PEDIDOS ENTREGADOS SIN IMAGEN",null,null,null,null,"CERRADOS SIN ACTUALIZAR"]
[null,null,null,"SIN IMAGEN","(Todas)",null,null,null,"SIN IMAGEN",1,null,null,null,"SIN IMAGEN","(Todas)"]
[null,null,null,"ULT EVE","En almacen Natura",null,null,null,"ULT EVE","(Todas)",null,null,null,"ULT EVE","(Varios elementos)"]
[null,null,null,"EVALUACION","(Todas)",null,null,null,"EVALUACION","(Varios elementos)",null,null,null,"EVALUACION","(Varios elementos)"]
[]
[null,null,null,"Etiquetas de fila","Cuenta de NÚMERO PEDIDO",null,null,null,"Etiquetas de fila","Cuenta de NÚMERO PEDIDO",null,null,null,"Etiquetas de fila","Cuenta de NÚMERO PEDIDO"]
[null,null,null,45702,1,null,null,null,45664,1,null,null,null,45665,1]
[null,null,null,45706,1,null,null,null,45672,1,null,null,null,"(en blanco)"]
[null,null,null,45708,1,null,null,null,45674,3,null,null,null,45675,1]
[null,null,null,45710,7,null,null,null,45677,1,null,null,null,45692,9]
[null,null,null,"Total general",10,null,null,null,45678,1,null,null,null,45694,2]
[null,null,null,null,null,null,null,null,45681,1,null,null,null,45696,1]
[null,null,null,null,null,null,null,null,45682,3,null,null,null,45698,1]
[null,null,null,null,null,null,null,null,45684,1,null,null,null,45702,4]
[null,null,null,null,null,null,null,null,45686,2,null,null,null,45703,2]
[null,null,null,null,null,null,null,null,45687,5,null,null,null,45705,4]
[null,null,null,null,null,null,null,null,45688,25,null,null,null,45706,14]
[null,null,null,null,null,null,null,null,45691,11,null,null,null,45707,41]
[null,null,null,null,null,null,null,null,45692,4,null,null,null,45708,173]
[null,null,null,null,null,null,null,null,45693,5,null,null,null,45709,789]
[null,null,null,null,null,null,null,null,45694,9,null,null,null,"Total general",1042]
[null,null,null,null,null,null,null,null,45695,14]
[null,null,null,null,null,null,null,null,45698,1]
[null,null,null,null,null,null,null,null,45700,11]
[null,null,null,null,null,null,null,null,45701,17]
[null,null,null,null,null,null,null,null,45702,29]
[null,null,null,null,null,null,null,null,45703,26]
[null,null,null,null,null,null,null,null,45705,52]
[null,null,null,null,null,null,null,null,45706,108]
[null,null,null,null,null,null,null,null,45707,194]
[null,null,null,null,null,null,null,null,45708,2122]
[null,null,null,null,null,null,null,null,45709,2050]
[null,null,null,null,null,null,null,null,"Total general",4697]

{"sheet":"BASE","index":5,"n_rows":9,"n_cols":56,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(OR(BG2=\"\",BG2=0,BG2<0),\"\",BG2)","v":""},{"$f":"IF(R2=1,\"04. NULL\",IF(OR(AN2=\"\",AN2=0),\"03. NE\",IF(AN2<=L2,\"01. AT\",\"02. FT\")))","v":"03. NE"},{"$f":"IF(C2>0,1,0)","v":0},{"$f":"IF(AO2=\"03. NE\",0,1)","v":0},{"$f":"IF(AO2=$DS$3,1,0)","v":0},{"$f":"IF(AO2=$DT$3,1,0)","v":0},{"$f":"IF(AO2=$DU$3,1,0)","v":0},{"$f":"IF(AO2=$DV$3,1,0)","v":0},{"$f":"IF(OR(AO2=\"01. AT\",AO2=\"02. FT\"),IF(AN2<L2,1,0),0)","v":0},{"$f":"IF(OR(AO2=\"01. AT\",AO2=\"02. FT\"),IF(AN2=L2,1,0),0)","v":0},{"$f":"IF(OR(AO2=\"01. AT\",AO2=\"02. FT\"),IF(AN2>L2,1,0),0)","v":0},{"$f":"(L2-K2)","v":0},{"$f":"IF(OR(AO2=\"01. AT\",AO2=\"02. FT\"),AN2-#REF!,\"\")","v":""},{"$f":"IF(OR(AO2=\"01. AT\",AO2=\"02. FT\"),AN2-L2,\"\")","v":""},{"$f":"IF(AO2=\"03. NE\",NETWORKDAYS.INTL(#REF!,TODAY(),11),IF(OR(AO2=\"01. AT\",AO2=\"02. FT\"),NETWORKDAYS.INTL(#REF!,BG2,11),\"\"))","v":{"$error":"#REF!"}},0.96,{"$f":"IF(R2=1,\"03. ANULADO\",IF(OR(AN2=\"\",AN2=0),\"01. TRANSITO\",IF(AN2<=L2,\"02. ENTREGADO\",\"02. ENTREGADO\")))","v":"01. TRANSITO"}]
[]
[]
[]
[]
[]
[null,null,"Cuenta de NÚMERO PEDIDO"]
[null,null,63304]