Fun - Feb 23

Descargar como xlsx, pdf o txt
Descargar como xlsx, pdf o txt
Está en la página 1de 53

Año 2022

Enero Febrero Marzo Abril Mayo Junio Julio Agosto Septiembre


Total Total Total Total Total Total Total Total Total
Insertado 94013 119149 153321 137496 157479 154176 163590 153071 134800
Gestionado 92013 115775 149978 134134 156447 153855 163066 152686 134253
CONTACTO 46809 49704 68287 61729 77459 78897 97521 92003 97700
CONTACTO EFECTIVO 24177 29574 36119 29001 33900 35109 39156 43148 49781
CONTACTO NO EFECTIVO 8987 10569 17158 13523 26720 33105 47759 48855 43694
NO CONFORME 17574 19872 24348 19911 21697 23197 23240 29507 11083
RETENIDO 11795 13431 17413 15029 15400 16916 15907 20672 24548
BAJAS (SP) 27662 33583 43659 35691 44633 42253 47703 54784 46990
BAJAS CONT 10609 10947 15985 13652 18064 16874 23080 29391 23285
BAJAS NC 17053 22636 27674 22039 26569 25379 24623 25393 19558
BAJAS CE 2909 3769 4128 2778 3062 2898 5131 6977 7205
% BAR/INS 98% 97% 98% 98% 99% 100% 100% 100% 100%
%CONTACTO/BAR 51% 43% 46% 46% 50% 51% 60% 60% 73%
%CEF/CONT 52% 60% 53% 47% 44% 44% 40% 47% 51%
%CNE/CONT 48% 40% 47% 53% 56% 56% 60% 53% 49%
% Bajas Totales / Insertado 29% 28% 28% 26% 28% 27% 29% 36% 35%
% Bajas Contacto 23% 22% 23% 22% 23% 21% 24% 32% 24%
% Bajas No Contacto 38% 34% 34% 30% 34% 34% 38% 42% 54%
% Bajas Contacto Efectivo 12% 13% 11% 10% 9% 8% 13% 16% 14%
% Retencion 67% 68% 72% 75% 71% 73% 68% 70% 69%
Octubre Noviembre Diciembre Enero '23 Febrero '23
Total Total Total Total Bitel Sem 1 Sem 2 Movistar Sem 1 Sem 2 Total
135858 137150 142507 149471 7343 5565 1778 39198 28240 10958 46541
120%
135483 136870 142183 149170 7335 5561 1774 39121 28182 10939 46456
100969 105814 105915 97219 4802 3728 1074 27240 20001 7239 32042 100%
55584 49789 48208 41561 1193 851 342 13334 9638 3696 14527 80%
44915 56025 57707 55658 3609 2877 732 13906 10363 3543 17515 60%
12743 33657 33907 32174 1087 776 311 10183 7350 2833 11270
40%
23046 20696 19633 17961 527 385 142 5405 3956 1449 5932
46862 48396 48679 48806 4677 3639 1038 10060 7891 2169 14737 20%
27888 28959 30251 29552 2759 2213 546 6332 4995 1337 9091 0%
18974 19437 18428 19254 1918 1426 492 3728 2896 832 5646 S
IN
9154 7314 6502 5827 293 206 87 1514 1175 339 1807 R/ /B
BA TO
100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% % AC
75% 77% 74% 65% 65% 67% 61% 70% 71% 66% 69% NT
CO
55% 47% 46% 43% 25% 23% 32% 49% 48% 51% 45% %
44% 53% 54% 57% 75% 77% 68% 51% 52% 49% 55%
34% 35% 34% 33% 64% 65% 58% 26% 28% 20% 32%
28% 27% 29% 30% 57% 59% 51% 23% 25% 18% 28%
120%
55% 63% 51% 37% 76% 78% 70% 31% 35% 22% 39%
16% 15% 13% 14% 25% 24% 25% 11% 12% 9% 12% 100%
64% 61% 58% 56% 48% 50% 46% 53% 54% 51% 53%
80%
60%
40%
20%
0%
S
/ IN
B AR T
% AC
NT
CO
%
120%
100%
80%
60%
40%
20%
0%
S R T T do o to vo n
IN BA N N ct io
/ / CO CO rta ta nt
ac e cti nc
B AR TO F/ E/ ns
e on o Ef et
e
% TA
C CE CN /I sC o
C
ct
o R
N % % e s j a N ta %
CO al Ba as on
% T ot % B aj sC
as % ja
B aj Ba
% %

120%
100%
80%
60%
40%
20%
0%
S AR T T do o o vo n
/ IN B ON CO
N ta ta
ct
ta
ct cti cio
AR O/ / C / e r n n f e
et
e n
B CT CE
F E I ns o Co E
% A CN
s/ sC o ct
o R
NT % %
le aj
a
sN ta %
CO
ot
a B ja Con
% T % Ba s
as % ja
Ba
j Ba
% %
Esta forma representa una segmentación de datos. La segmentación de datos se admite en Excel 2010 y versiones
posteriores.

Si la forma se modificó en una versión anterior de Excel o si el libro se guardó en Excel 2003 o una versión anterior,
no se puede usar la segmentación de datos.
DIA INSERTADO Gestionado CONTACTO CONTACTO
EFECTIVO
CONTACTO NO
EFECTIVO
NO
CONFORME RETENIDO

### 01 5137 5127 3635 1597 2038 1210 686


### 02 4580 4571 3265 1483 1782 1152 619
### 03 4856 4848 3690 1667 2023 1325 683
### 04 4359 4355 3218 1368 1850 1038 573
848 05 2225 2220 1372 578 794 438 250
### 06 5624 5619 3908 1778 2130 1377 716
### 07 5594 5578 3518 1744 1774 1358 742
### 08 5832 5819 3963 1926 2037 1466 784
### 09 5606 5600 3780 1843 1937 1423 745
### 10 5862 5855 3806 1742 2064 1387 724
### 11 5304 5296 3251 1525 1726 1216 603
### 12 3157 3154 1737 770 967 618 330
### 13 6350 6336 3942 1798 2144 1431 690
### 14 5338 5330 3587 1668 1919 1305 656
### 15 6274 6242 3931 1773 2158 1417 634
### 16 - - - - - - -
### 17 - - - - - - -
### 18 - - - - - - -
### 19 - - - - - - -
### 20 - - - - - - -
### 21 - - - - - - -
### 22 - - - - - - -
### 23 - - - - - - -
### 24 - - - - - - -
### 25 - - - - - - -
### 26 - - - - - - -
### 27 - - - - - - -
### 28 - - - - - - -
### 29 - - - - - - -
### 30 - - - - - - -
### 31 - - - - - - -
### Total general 76098 75950 50603 23260 27343 18161 9435
### 32375 32318 22606 10215 12391 7898 4269
### 37449 37390 24066 11272 12794 8846 4532
### 6274 6242 80% 3931 1773 2158 1417 634
0 0 0 0 0 0 0 0
70%

60%

50%

40%

30%

20%

10%

0%
01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19
40%

30%

20%

10%

0%
01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19

80% 76%
74%
71% 71% 70%
70% 68% 68% 67%
63% 65% 63%
62% 61% 62%
60% 55%
50% 49% 49%
50%
44% 45% 45% 43% 42% 45% 46% 47% 44% 46% 47% 45%

40%

30%

20%

10%
0% 0% 0% 0% 0% 0%
0%
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

%CONTACTO/BAR %CEF/CONT

40% 38%
36% 36% 37% 36%
35% 34% 34%
31% 30% 32% 32% 32%
29%
30%
26% 26%
25%

20%
15% 15% 14% 15% 14% 15%
15% 12% 13% 14% 14% 13% 14%
11% 12% 11%
10%

5%
0% 0% 0% 0% 0% 0
0%
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 2

% Bajas Totales / Insertado % Bajas Contacto Efectiv


n Excel 2010 y versiones

2003 o una versión anterior, 0.31 0.780782459

BAJAS (SP) BAJAS BAJAS % BAJAS BAJAS % BAR/INS %CONTACTO/ %CEF/CONT %CNE/CONT % Bajas Totales
CONT NC CNE CE BAR / Insertado

1827 1175 652 47% 198 100% 71% 44% 56% 36%
1736 1079 657 48% 223 100% 71% 45% 55% 38%
1750 1198 552 47% 223 100% 76% 45% 55% 36%
1624 1102 522 48% 205 100% 74% 43% 57% 37%
753 459 294 47% 83 100% 62% 42% 58% 34%
2013 1198 815 44% 241 100% 70% 45% 55% 36%
1910 1065 845 45% 246 100% 63% 50% 50% 34%
1812 1108 704 41% 257 100% 68% 49% 51% 31%
1709 1070 639 41% 251 100% 68% 49% 51% 30%
1866 1114 752 40% 264 100% 65% 46% 54% 32%
1687 977 710 44% 214 100% 61% 47% 53% 32%
816 445 371 37% 84 100% 55% 44% 56% 26%
2002 1158 844 41% 275 100% 62% 46% 54% 32%
1573 974 599 39% 198 100% 67% 47% 53% 29%
1654 960 694 34% 203 99% 63% 45% 55% 26%
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
24732 15082 9650 43% 3165 100% 67% 46% 54% 33%
11613 7276 4337 1419 0.9982394 0.6994863544 0.451871185 55% 0.3587027027
11465 6846 4619 1543 0.9984245 0.6436480342 0.468378625 53% 0.3061496969
1654 960 694 203 0.9948996 0.6297661006 0.451030272
6 0%

55% 0.2636276697
0 0 0 0- - - - -
5 0%

4 0%

3 0%

2 0%

1 0%

0%

12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
3 0%

2 0%

1 0%

0%

12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

63%

45%

0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%
15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

O/BAR %CEF/CONT

26%

11%

0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%
15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

rtado % Bajas Contacto Efectivo


% Bajas
% Bajas % Bajas No %
Contacto Contacto Contacto Retencion Ocupación
Efectivo
1200%
32% 44% 12% 57%
33% 50% 15% 54%
32% 48% 13% 52% 1000%
34% 46% 15% 55%
33% 35% 14% 57% 800%
31% 48% 14% 52%
30% 41% 14% 55% 600%
28% 38% 13% 53%
28% 35% 14% 52% 400%
29% 37% 15% 52%
30% 35% 14% 50% 200%
26% 26% 11% 53%
29% 35% 15% 48%
0%
27% 34% 12% 50%
24% 30% 11% 45%
- - - -
- - - -
% Bajas Contacto Efectivo
- - - - 1200%
- - - -
- - - -
- - - -
- - - -
- - - - 1000%
- - - -
- - - -
- - - -
- - - -
- - - - 800%
- - - -
- - - -
- - - -
30% 38% 14% 52%
600%
32% 45% 0.1389133627 54%
28% 35% 0.1368878637 51%
24% 30% 0.1144952059 45%
- - - -
400%

200%

0%
200%

0%
upación Utilización
1200%

1000%

800%

600%

400%

200%

0%

ntacto Efectivo
Cumplimiento Blindaje %
15-Feb 88%

14-Feb 84%

13-Feb 81%

12-Feb 75%

11-Feb 88%

10-Feb 88%

9-Feb 92%

8-Feb 86%

7-Feb 83%

6-Feb 81%

5-Feb 68%

4-Feb 89%

3-Feb 83%

2-Feb 73%

1-Feb 80%

0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100%
3-Feb 83%

2-Feb 73%

1-Feb 80%

0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100%
e%
88%

84%

81%

75%

88%

88%

92%

86%

83%

81%

68%

89%

83%

73%

80%

70% 80% 90% 100%


83%

73%

80%

70% 80% 90% 100%


Dia Fecha # Base Dim # Insertados # Hrs Dim # Hrs Brutas # Hrs Productivdas

miércoles 2/1/2023 8553 5137 1147.1 1147.1 916.4


jueves 2/2/2023 8572 4580 1154.6 1154.6 845.6
viernes 2/3/2023 8532 4856 1151.5 1151.5 953.9
sábado 2/4/2023 7131 4359 976.0 976.0 864.2
domingo 2/5/2023 4413 2225 588.9 588.9 401.5
lunes 2/6/2023 8821 5624 1174.8 1174.8 949.3
martes 2/7/2023 8318 5594 1116.8 1116.8 926.4
miércoles 2/8/2023 8553 5832 1147.1 1147.1 981.5
jueves 2/9/2023 8572 5606 1154.6 1154.6 1063.5
viernes 2/10/2023 8532 5862 1151.5 1151.5 1009.1
Total 216922 90671 15753 15753 13098
% Cumplimiento RQ % Desvío

80% -40%
73% -47%
83% -43%
89% -39%
68% -50%
81% -36%
83% -33%
86% -32%
92% -35%
88% -31%
Esta forma representa una segmentación de Esta forma representa una segmentación de datos. La se
datos. La segmentación de datos se admite en se admite en Excel 2010 y versiones posteriores.
Excel 2010 y versiones posteriores.
Si la forma se modificó en una versión anterior de Exce
Si la forma se modificó en una versión guardó en Excel 2003 o una versión anterior, no se pued
anterior de Excel o si el libro se guardó en segmentación de datos.
Excel 2003 o una versión anterior, no se
puede usar la segmentación de datos.

CONTACTO CONTACTO NO
Fecha Insertado Gestionado CONTACTO EFECTIVO EFECTIVO NO CONFORME

08:00 727 727 610 364 244 37


08:30 1004 1003 806 448 356 68
09:00 2161 2155 1776 887 881 118
09:30 3000 2991 2348 1106 1226 187
10:00 3489 3481 2669 1239 1416 212
10:30 3723 3717 2760 1294 1450 268
11:00 3904 3893 2845 1363 1464 321
11:30 3726 3722 2647 1244 1383 276
12:00 3853 3842 2835 1303 1507 267
12:30 3580 3574 2660 1205 1438 268
13:00 3572 3566 2611 1173 1418 243
13:30 2815 2807 1987 909 1062 205
14:00 2659 2650 1861 817 1027 194
14:30 2695 2690 1866 853 986 235
15:00 3142 3132 2200 1007 1186 238
15:30 3412 3410 2254 1077 1157 283
16:00 3615 3607 2237 1084 1129 365
16:30 3688 3684 2199 1022 1148 374
17:00 3822 3815 2304 1011 1262 393
17:30 3547 3540 2135 893 1221 360
18:00 3106 3098 1825 735 1065 346
18:30 2608 2607 1430 603 803 303
19:00 2334 2333 1045 433 593 311
19:30 1972 1969 909 392 509 255
20:00 1461 1459 682 301 368 186
20:30 1248 1245 544 237 298 182
21:00 787 786 331 163 163 83
21:30 447 446 226 97 123 48
Total 76097 75949 50602 23260 26883 6626

46%
6000
34% 35% 34%
34% 34% 34% 34% 34%
32% 33% 33%
5000 31% 30% 31% 31%

4000

3000

2000

1000

0
08:00

10:00

10:30

11:00

11:30

12:00

12:30

14:00

14:30

15:00

15:30
09:00

09:30

13:00

13:30

% Bajas Totales / Insertado Insertado


0

08:00

09:00

09:30

10:00

10:30

11:00

11:30

12:00

12:30

13:00

13:30

14:00

14:30
% Bajas Totales / Insertado

15:00

15:30
Insertado
segmentación de datos. La segmentación de datos
y versiones posteriores.

n una versión anterior de Excel o si el libro se


na versión anterior, no se puede usar la

% Bajas Totales / % Bajas Contacto


RETENIDO BAJAS (SP) BAJAS CE % BAR/INS %CONTACTO/BAR %CEF/INSERT Insertado Efectivo

29 222 52 100% 84% 50% 31% 14%


31 331 77 100% 80% 45% 33% 17%
65 742 163 100% 82% 41% 34% 18%
98 1025 192 100% 79% 37% 34% 17%
127 1187 192 100% 77% 36% 34% 15%
147 1249 196 100% 74% 35% 34% 15%
227 1374 212 100% 73% 35% 35% 16%
202 1268 152 100% 71% 33% 34% 12%
130 1322 215 100% 74% 34% 34% 17%
136 1144 159 100% 74% 34% 32% 13%
129 1166 176 100% 73% 33% 33% 15%
138 848 114 100% 71% 32% 30% 13%
129 874 118 100% 70% 31% 33% 14%
149 907 107 100% 69% 32% 34% 13%
186 977 104 100% 70% 32% 31% 10%
235 1057 146 100% 66% 32% 31% 14%
322 1164 133 100% 62% 30% 32% 12%
348 1187 123 100% 60% 28% 32% 12%
304 1219 141 100% 60% 26% 32% 14%
292 1129 96 100% 60% 25% 32% 11%
254 1021 76 100% 59% 24% 33% 10%
234 863 75 100% 55% 23% 33% 12%
302 808 37 100% 45% 19% 35% 9%
262 629 31 100% 46% 20% 32% 8%
173 435 28 100% 47% 21% 30% 9%
153 314 25 100% 44% 19% 25% 11%
76 179 14 100% 42% 21% 23% 9%
31 91 11 100% 51% 22% 20% 11%
4909 24732 3165 100% 67% 31% 33% 13.6%

40%
34% 35%
33% 32% 32% 33% 33% 35%
31% 31% 32% 32% 32%
30%
30%
25%
23% 25%
20%
20%

15%

10%

5%

0%
14:00

14:30

15:00

15:30

17:30

18:00

18:30

19:00

19:30
16:00

16:30

17:00

20:00

20:30

21:00

21:30

as Totales / Insertado Insertado BAJAS (SP)


14:00

as Totales / Insertado 14:30

15:00

15:30
Insertado

16:00

16:30
BAJAS (SP)

17:00

17:30

18:00

18:30

19:00

19:30

20:00

20:30

21:00

21:30
0%
Horas Diaria

Horas
Fecha Horas On Line Dimensionada Cumplimiento Total Horas IPCC
IPCC Blindaje %
1-Feb 916.4 s
1147.1 80% 916.4
2-Feb 845.6 1154.6 73% 845.6
3-Feb 953.9 1151.5 83% 953.9
4-Feb 864.2 976.0 89% 864.2
5-Feb 401.5 588.9 68% 401.5
6-Feb 949.3 1174.8 81% 949.3
7-Feb 926.4 1116.8 83% 926.4
8-Feb 981.5 1147.1 86% 981.5
9-Feb 1063.5 1154.6 92% 1063.5
10-Feb 1009.1 1151.5 88% 1009.1
11-Feb 863.0 976.0 88% 863.0
12-Feb 439.7 588.9 75% 439.7
13-Feb 944.2 1168.2 81% 944.2
14-Feb 930.2 1110.4 84% 930.2
15-Feb 1009.2 1147.1 88% 1009.2

Total 13097.5 15753.5 83% 13097.5

Hora 01/02 02/02 03/02 04/02 05/02 06/02 07/02


08:00 29% 19% 28% 72% 22% 20% 27%
08:30 39% 34% 44% 79% 41% 36% 44%
09:00 47% 39% 43% 76% 60% 51% 56%
09:30 48% 43% 41% 67% 59% 47% 52%
10:00 53% 50% 58% 59% 55% 53% 54%
10:30 53% 49% 55% 54% 49% 56% 55%
11:00 57% 50% 56% 55% 45% 54% 54%
11:30 60% 50% 60% 58% 44% 52% 52%
12:00 64% 52% 59% 59% 44% 58% 56%
12:30 61% 58% 60% 60% 51% 61% 56%
13:00 64% 62% 64% 67% 53% 59% 61%
13:30 62% 59% 67% 53% 60% 58% 55%
14:00 59% 53% 66% 71% 56% 57% 54%
14:30 63% 48% 63% 66% 59% 56% 56%
15:00 57% 46% 53% 56% 54% 50% 52%
15:30 52% 50% 51% 54% 57% 47% 50%
16:00 54% 51% 45% 51% 52% 47% 49%
16:30 52% 50% 45% 51% 58% 48% 48%
17:00 52% 49% 47% 50% 51% 55% 47%
17:30 56% 49% 50% 45% 47% 56% 50%
18:00 57% 47% 52% 37% 34% 47% 43%
18:30 53% 51% 49% 32% 34% 45% 42%
19:00 46% 38% 51% 29% 30% 36% 42%
19:30 34% 30% 48% 30% 31% 27% 31%
20:00 41% 37% 39% 33% 36% 27% 36%
20:30 42% 41% 46% 35% 39% 36% 43%
21:00 73% 61% 80% 56% 48% 62% 73%
21:30 137% 111% 149% 68% 54% 111% 113%
Total Horas Dim Horas Facturar Cumplimiento T. Adiccional Remoto T. Adiccional T. Adiccional FTE Real Blindaje
General Surquillo Total
1147.1 916.4 80% 0:00:00 0:00:00 0:00:00 115
1154.6 845.6 73% 0:00:00 0:00:00 0:00:00 106
1151.5 953.9 83% 0:00:00 0:00:00 0:00:00 119
976.0 864.2 89% 0:00:00 0:00:00 0:00:00 108
588.9 401.5 68% 0:00:00 0:00:00 0:00:00 50
1174.8 949.3 81% 0:00:00 0:00:00 0:00:00 119
1116.8 926.4 83% 0:00:00 0:00:00 0:00:00 116
1147.1 981.5 86% 0:00:00 0:00:00 0:00:00 123
1154.6 1063.5 92% 0:00:00 0:00:00 0:00:00 133
1151.5 1009.1 88% 0:00:00 0:00:00 0:00:00 126
976.0 863.0 88% 0:00:00 0:00:00 0:00:00 108
588.9 439.7 75% 0:00:00 0:00:00 0:00:00 55
1168.2 944.2 81% 0:00:00 0:00:00 0:00:00 118
1110.4 930.2 84% 0:00:00 0:00:00 0:00:00 116
1147.1 1009.2 88% 0:00:00 0:00:00 0:00:00 126

15753.5 13097.5 83% 0:00:00 0:00:00 0:00:00 126

08/02 09/02 10/02 11/02 12/02 13/02 14/02


22% 27% 28% 34% 23% 22% 32%
40% 41% 37% 48% 32% 35% 51%
51% 48% 51% 51% 62% 55% 56%
52% 48% 47% 55% 63% 52% 52%
55% 57% 57% 54% 66% 51% 48%
54% 55% 57% 49% 57% 52% 53%
56% 58% 62% 51% 60% 49% 55%
56% 58% 61% 55% 55% 53% 49%
61% 61% 57% 56% 59% 57% 51%
62% 61% 59% 58% 66% 23% 53%
62% 65% 55% 62% 55% 13% 56%
55% 67% 49% 58% 62% 63% 58%
54% 61% 52% 76% 59% 58% 52%
57% 62% 54% 64% 58% 63% 52%
56% 62% 52% 51% 56% 55% 51%
51% 54% 51% 52% 56% 54% 50%
48% 53% 48% 46% 55% 53% 49%
48% 52% 44% 48% 56% 52% 46%
52% 59% 44% 53% 59% 55% 47%
54% 59% 50% 53% 57% 56% 50%
51% 53% 48% 51% 34% 51% 40%
51% 49% 44% 45% 35% 45% 34%
42% 37% 45% 43% 30% 38% 28%
35% 35% 38% 34% 27% 33% 26%
40% 44% 42% 36% 29% 42% 28%
42% 45% 44% 35% 31% 45% 34%
63% 66% 63% 58% 54% 64% 66%
119% 110% 120% 69% 54% 107% 106%
Bajas CE 13.61%
CE 30.6%

Hora/mes Tarifa Subtotal Actual


FTE
Dimensionados Dif Fact Hrs IPCC + Hrs ACD 13097.5 S/ 16.00 S/ 209,560.21
Blindaje Tercero
143 -29 Capacitación Aprobada 0.0 S/ -
144 -39 Subtotal S/. 209,560.21
144 -25 Descuento a favor de Claro
122 -14 Saldo a favor de proveedor
74 -23 Bono S/. 0.00
147 -28
140 -24
143 -21
144 -11
144 -18
122 -14
74 -19
146 -28
139 -23
143 -17

151 -26

15/02 16/02 17/02 18/02 19/02 20/02 21/02 22/02 23/02


20%
33%
43%
41%
48%
45%
48%
50%
52%
58%
64%
63%
56%
57%
55%
49%
48%
46%
50%
47%
46%
42%
39%
31%
36%
41%
71%
128%
40%
T. HP Contacto Efectiv

Proyeccion
%Bajas CE <=40%
S/ 421,149.25 0% >=0.00% S/ 19.50
5% >=5.00% S/ 18.50
7% >=7.00% S/ 17.50
9% >=9.00% S/ 16.50
11% >=11.00% S/ 16.00

24/02 25/02 26/02 27/02 28/02 01/03 02/03 03/03


50% 60% 70% 100%
Contacto Efectivo

<=50% <=60% <=70% <=100%


S/ 20.00 S/ 20.50 S/ 21.00 S/ 21.50
S/ 19.00 S/ 19.50 S/ 20.00 S/ 20.50
S/ 18.00 S/ 18.50 S/ 19.00 S/ 19.50
S/ 17.00 S/ 17.50 S/ 18.00 S/ 18.50
S/ 16.50 S/ 17.00 S/ 17.50 S/ 18.00

SUPERVISOR (Varios elementos)

Suma de TNETO_IDLE Etiquetas de columna


Etiquetas de fila 01 02 03 04 05 06
08:00 5:18:02 3:16:33 5:01:51 9:47:27 2:13:20 3:24:56
08:30 8:27:26 7:07:43 8:47:33 14:15:05 4:30:07 7:25:12
09:00 18:57:46 16:21:53 16:54:34 27:00:05 10:04:47 20:09:10
09:30 22:49:34 20:19:21 21:11:56 28:09:48 11:37:10 22:24:14
10:00 29:49:08 27:26:41 31:25:34 29:06:41 12:59:40 30:56:09
10:30 30:01:36 28:01:01 31:34:53 28:14:10 13:22:40 31:57:04
11:00 31:43:48 28:03:47 31:14:41 29:15:33 11:46:22 32:29:03
11:30 33:19:33 28:29:17 33:29:35 28:55:18 12:25:43 30:54:17
12:00 33:29:45 27:50:00 32:56:26 28:31:37 12:30:50 31:00:44
12:30 31:49:54 29:06:27 31:02:21 29:17:44 12:07:29 32:53:28
13:00 31:51:48 30:11:50 32:01:04 26:18:43 13:10:42 29:29:49
13:30 28:59:05 26:38:44 31:05:15 21:33:29 13:02:28 26:23:02
14:00 26:22:46 23:26:22 29:44:01 20:20:26 12:43:11 25:54:27
14:30 26:50:45 22:04:13 28:11:51 21:38:48 12:44:25 24:14:20
15:00 26:08:03 21:20:27 25:19:38 22:08:03 12:32:17 23:27:53
15:30 26:55:02 26:08:34 26:01:54 23:00:51 13:50:39 25:14:05
16:00 27:19:09 27:24:32 23:55:05 22:50:55 13:28:11 25:12:39
16:30 28:05:17 27:34:08 24:00:03 23:05:34 14:19:04 26:14:18
17:00 26:48:39 25:51:02 25:01:25 20:10:50 13:22:20 28:15:36
17:30 27:54:37 24:43:52 24:37:21 18:12:59 11:48:07 27:12:48
18:00 24:28:24 20:21:37 21:59:58 12:57:26 8:33:44 21:23:23
18:30 20:14:45 18:58:53 19:43:47 10:05:17 8:27:30 18:22:52
19:00 14:35:48 12:53:35 16:25:29 7:40:20 6:27:58 12:57:58
19:30 10:28:08 9:07:24 13:36:54 7:25:34 6:09:16 9:16:34
20:00 9:36:43 8:18:12 8:36:10 6:12:10 5:33:32 6:29:37
20:30 8:39:42 7:46:05 7:53:28 5:45:56 5:08:45 6:54:23
21:00 8:05:18 7:03:01 7:42:24 5:02:27 3:08:09 6:40:11
21:30 7:52:28 7:04:10 7:26:42 4:58:33 3:00:36 6:57:10
Total general 627:02:59 562:59:24 617:01:53 532:01:49 281:09:02 594:15:22
SUPERVISO(Todas) SUPERVISOR

Etiquetas deSuma de TNETO_IDLE Etiquetas de fila


01 916:22:45 Total general
0 02 845:36:34
0 03 953:51:43
0 04 864:12:28
0 05 401:27:24
0 06 949:16:05
0 07 926:25:41
0 08 981:27:21
0 09 ###
0 10 ###
0 11 862:58:53
0 12 439:43:02
0 13 944:13:29
0 14 930:10:25
0 15 ###
0 Total gener ###
13224.315

07 08 09 10 11 12 13
3:59:46 3:56:36 4:38:07 5:01:37 4:42:36 2:21:42 3:40:29
8:23:21 8:48:06 8:36:59 7:31:06 8:40:29 3:30:37 7:16:18
19:19:07 20:18:46 19:59:28 19:55:11 18:11:30 10:29:29 21:13:06
22:21:56 24:36:13 22:26:36 24:02:18 23:02:31 12:27:22 24:33:09
29:58:47 30:55:15 30:45:44 31:00:09 26:32:27 15:40:22 29:11:00
29:31:11 30:43:44 31:37:23 32:40:19 25:35:47 15:40:11 29:34:51
29:26:48 31:15:52 32:42:41 34:24:11 26:55:36 15:46:08 29:27:10
29:44:00 31:08:50 32:58:22 33:48:05 27:42:43 15:30:37 30:48:58
29:47:24 31:49:54 32:50:10 31:52:28 27:11:19 16:45:51 30:06:34
29:36:22 32:13:46 30:36:29 30:56:48 28:25:06 15:46:46 12:06:18
29:38:09 30:45:50 31:37:50 27:42:04 24:41:40 13:50:52 6:36:49
24:39:22 25:48:44 30:07:46 22:52:14 23:16:46 13:30:20 28:16:51
23:33:56 23:45:42 26:58:00 23:23:42 21:50:43 13:25:21 26:02:13
23:57:52 24:16:10 28:21:24 23:52:51 20:54:24 12:37:42 27:00:25
23:52:46 25:35:22 29:00:29 24:51:28 20:07:16 13:02:58 25:35:35
25:10:48 26:24:36 28:01:36 26:11:25 22:08:20 13:40:18 28:37:21
24:52:10 24:28:36 28:35:00 25:41:25 20:55:51 14:17:35 28:04:42
24:53:13 25:57:54 28:47:59 23:28:17 21:36:53 13:50:54 28:00:14
23:34:55 27:01:13 30:49:08 23:17:44 21:08:32 15:32:03 27:58:10
23:43:07 27:02:42 29:59:44 24:24:17 21:32:21 14:16:19 27:00:24
19:16:22 21:41:07 23:23:43 20:21:52 17:34:06 8:28:16 23:12:22
15:44:43 19:30:37 18:18:32 17:56:02 14:26:02 8:51:23 18:10:13
13:48:39 13:16:17 12:29:14 14:38:07 11:33:39 6:34:11 13:22:15
9:47:36 10:38:50 10:42:52 10:47:00 8:36:37 5:27:54 11:15:30
8:07:56 9:12:06 9:52:54 9:23:39 6:40:09 4:30:40 10:02:35
7:55:21 8:40:22 8:33:07 7:32:46 5:43:21 4:07:26 8:39:27
6:47:58 7:02:31 7:39:58 6:02:54 5:15:30 3:29:32 6:54:52
6:37:02 6:50:18 7:03:00 6:00:09 5:01:59 3:03:11 6:40:26
568:10:37 603:45:59 637:34:15 589:40:08 510:04:13 306:36:00 569:28:17
(Varios elementos)

Suma de TNETO_IDLE Etiquetas de fila Suma de AUX_CAPAPAGADA


01 1:23:28
02 2:59:04
03 3:19:18
04 1:41:02
05 0:00:00
06 2:45:49
07 3:42:42
08 2:10:56
09 6:11:18
10 3:43:08
11 3:13:29
12 0:55:17
13 1:50:01
14 2:26:27
15 4:58:22
Total general 41:20:21

14 15 Total general
4:50:08 3:43:42 65:56:52
9:37:12 7:14:08 120:11:22
19:05:42 17:12:26 275:13:00
22:12:54 19:27:40 321:42:42
26:07:47 26:44:17 408:39:41
28:31:01 25:48:46 412:54:37
29:41:25 26:56:07 421:09:12
28:13:48 27:48:12 425:17:18
26:52:08 27:17:21 420:52:31
28:07:58 30:03:09 404:10:05
27:04:11 31:49:11 386:50:32
25:38:17 29:30:23 371:22:46
22:27:57 24:41:12 344:39:59
22:09:00 24:15:05 343:09:15
23:40:00 25:25:40 342:07:55
25:10:32 25:13:09 361:49:10
24:35:59 24:33:31 356:15:20
23:54:51 24:35:04 358:23:43
23:43:56 25:34:02 358:09:35
23:46:25 23:38:42 349:53:45
17:56:05 19:46:55 281:25:20
12:38:55 16:09:25 237:38:56
8:57:37 12:24:56 178:06:03
8:19:12 9:36:42 141:16:03
6:19:18 8:19:09 117:14:50
6:10:49 8:33:21 108:04:19
6:09:25 7:56:52 95:01:02
6:12:14 7:23:37 92:11:35
538:14:46 561:42:44 8099:47:27
Suma de AUX_CAPAPAGADA
41:20:21
Esta forma representa una segmentación de datos. La segmentación de datos se admite en Esta forma representa un
Excel 2010 y versiones posteriores. segmentación de datos. L
segmentación de datos se
Si la forma se modificó en una versión anterior de Excel o si el libro se guardó en Excel Excel 2010 y versiones p
2003 o una versión anterior, no se puede usar la segmentación de datos.
Si la forma se modificó e
versión anterior de Excel
se guardó en Excel 2003
versión anterior, no se pu

Motivos de baja segmentación de datos.

Motivos - Sub motivo - Sub motivo 1 Activo Con SP Total general %churn
Precio y Contenido 12501 1748 14249 12.27%
Oferta Competencia 9417 1399 10816 12.93%
En el otro operador me ofrecen el servicio postpago con descuentos y/o bono de 8252 1258 9510 13.23%
En el otro operador me dan mejores incentivos 1092 129 1221 10.57%
Mis familiares y/o amigos me recomendaron otro operador. 49 8 57 14.04%
Me ofrecieron lineas adicionales pagando menos 24 4 28 14.29%
Evaluaciones Crediticias y Contenido 3084 349 3433 10.17%
El otro operador me brinda facilidades para adquirir un equipo 2711 256 2967 8.63%
Los GB de mi plan, no son suficientes 359 92 451 20.40%
Me robaron el equipo, no hay facilidades para renovar 14 1 15 6.67%
Experiencia con el Servicio 1205 454 1659 27.37%
Problemas de Cobertura 951 347 1298 26.73%
El internet es lento. 653 191 844 22.63%
No ingresa la señal en varios lugares donde uso el servicio. 191 94 285 32.98%
Por momentos se me entrecorta el servicio 85 51 136 37.50%
Problemas con las llamadas 22 11 33 33.33%
Producto y Proceso 254 107 361 29.64%
No cumplieron con lo ofrecido en la venta/postventa 172 60 232 25.86%
Tuve una mala experiencia con ustedes 82 47 129 36.43%
Sin tipificación 899 105 1004 10.46%
(en blanco) 899 105 1004 10.46%
Facturacion y Pagos 401 128 529 24.20%
Inconformidad con los cobros 172 65 237 27.43%
Me estan cobrando servicios que no reconozco 172 65 237 27.43%
Inconformidad con el recibo 181 50 231 21.65%
No entiendo el recibo 108 42 150 28.00%
No puedo pagar el recibo en la fecha que vence 69 7 76 9.21%
No hay lugar cercano para pagar el recibo. 4 1 5 20.00%
(en blanco) 48 13 61 21.31%
Equipo/ Terminales 389 55 444 12.39%
Equipo/ Terminales 389 55 444 12.39%
Mi equipo esta fallando. 389 55 444 12.39%
Economico/Necesidad 243 33 276 11.96%
Economico/Necesidad 243 33 276 11.96%
Estoy con problemas economicos 209 25 234 10.68%
No necesito el servicio postpago 29 8 37 21.62%
Tengo 2 lineas en claro, me quedo con una 5 5 0.00%
Total general 15638 2523 18161 13.89%
Esta forma representa una Esta forma representa una
segmentación de datos. La segmentación de datos. La
segmentación de datos se admite en segmentación de datos se
Excel 2010 y versiones posteriores. admite en Excel 2010 y
versiones posteriores.
Si la forma se modificó en una
versión anterior de Excel o si el libro Si la forma se modificó en
se guardó en Excel 2003 o una una versión anterior de Excel
versión anterior, no se puede usar la o si el libro se guardó en
segmentación de datos.
Acciones de retención
Excel 2003 o una versión
anterior, no se puede usar la
segmentación de datos.
Acciones de Retención Activo Con SP Total general
Ajuste OCC 4116 124 4240
50% por 6 meses 3584 107 3691
50% por 3 meses 277 10 287
50% por 1 mes 125 6 131
30% por 3 meses 67 67
20% por 6 meses 38 1 39
20% por 3 meses 14 14
S/ 5 por 3 meses 4 4
S/ 5 por 6 meses 3 3
50% por 12 meses 3 3
50% por 2 meses 1 1
Informativo 1892 151 2043
Beneficios del plan 1349 110 1459
Beneficios Claro club 200 13 213
Sobre el contrato 62 3 65
Sobre el ciclo de facturacion 50 8 58
Refinanciamiento 50 1 51
Descuento + Bono de GB 47 1 48
Derivacion a CAC 36 5 41
Claro video 37 3 40
Claro Musica 17 3 20
Sobre uso y control de GB (Mi claro) 11 3 14
Speech Indoor / Outdoor 13 13
Configuacion del dispositivo 7 7
Sobre el prorrateo 5 1 6
Derivacion a Tienda virtual 5 5
Cambio de titularidad 3 3
Cambio de Plan 1120 43 1163
Upgrade 761 33 794
Downgrade 351 10 361
Intento de cambio de plan 8 8
Reinicio problemas tecnologicos 506 56 562
Caso - Cola AT retenciones 285 34 319
Escalamiento por celdas AT 91 8 99
Reinicio (Equipo) 51 1 52
Reinicio a traves de Celdas 35 8 43
Transferencia At retenciones 23 3 26
Reinicio (Cancel location) 12 1 13
Creacion de APN 6 1 7

Cambio modo de red 3 3

(en blanco) 507 33 540

Sin tipificación 507 33 540

Renovacion 408 19 427

Renovacion en cuotas 247 10 257

Renovacion al contado 145 9 154

Renovacion Pick-UP 16 16
Bono de retencion 169 16 185

Duplica GB por 3 meses 66 4 70

Duplica GB por 6 meses 57 7 64


Bono de 5GB por 6 meses 22 3 25
30 GB para Tiktok por 3 meses 10 2 12
Bono de 5GB por 3 meses 10 10
Duplica GB por 1 mes 4 4
No califica herramienta de retencion 116 6 122
Descuento activo 82 4 86
Antigüedad 28 2 30
IMR 3 3
Bono activo 3 3
Solicitudes 86 5 91
Cambio de ciclo 76 4 80
Actualizacion de datos 5 1 6
Afiliacion a recibo electronico 4 4
Cambio de numero 1 1
Ajuste NC 44 3 47
Cobros por Reconexion - No Fundado 11 11
Descuento promocional no aplicado - Fundado 9 9
Compra de paquetes - No Fundado 7 1 8
Servicios VAS - No Fundado 5 5
Servicios VAS - Fundado 4 4
Cobros por Reconexion - Fundado 3 1 4
Compra de paquetes - Fundado 3 1 4
Por retencion 2 2
Claro Club 14 14
Bono Claro Club 5 5
Llamadas y SMS 3 3
Minutos internacionales 3 3
Alquiler de peliculas 3 3
Portabilidad 1 1
Chip suelto 1 1
Total general 8979 456 9435
%Churn
2.92%
2.90%
3.48%
4.58%
0.00%
2.56%
0.00%
0.00%
0.00%
0.00%
0.00%
7.39%
7.54%
6.10%
4.62%
13.79%
1.96%
2.08%
12.20%
7.50%
15.00%
21.43%
0.00%
0.00%
16.67%
0.00%
0.00%
3.70%
4.16%
2.77%
0.00%
9.96%
10.66%
8.08%
1.92%
18.60%
11.54%
7.69%
14.29%
0.00%
6.11%
6.11%
4.45%
3.89%
5.84%
0.00%
8.65%
5.71%
10.94%
12.00%
16.67%
0.00%
0.00%
4.92%
4.65%
6.67%
0.00%
0.00%
5.49%
5.00%
16.67%
0.00%
0.00%
6.38%
0.00%
0.00%
12.50%
0.00%
0.00%
25.00%
25.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
VISTA AGENTES FEBRERO Esta forma representa una segmentación de datos. La segmentació
datos se admite en Excel 2010 y versiones posteriores.
VISTA AGENTES FEBRERO Si la forma se modificó en una versión anterior de Excel o si el lib
guardó en Excel 2003 o una versión anterior, no se puede usar la
segmentación de datos.

Registros / cantidades Porce


Total 1 Nivel Contacto

USUARIO NOMBRE_AGENTE Gestionado % Contacto % No Contacto % CE

8 E8203622 GUTIÉRREZ CUADROS SHEYLA 453 100% 0% 28%

8 E8203644 ARELLANO MEDRANO YESENIA ANGELICA 709 95% 5% 27%

8 E8203740 VIDAL ALVAREZ ROSALINDA 407 97% 3% 22%

8 E8204311 MUGABURU ARCE MARÍA DEL ROSARIO 346 100% 0% 65%

8 E8206470 HERRERA RUIZ YESENIA ANDREA 56 100% 0% 43%

8 E8207826 BRABO TAPIA YANET CECILIA 673 98% 2% 22%

8 E8208279 VEGA MORENO JEAN CARLOS 249 100% 0% 28%

8 E8209552 ZEGARRA CARRASCO CRISTINA ISABEL 71 94% 6% 6%

8 E8210499 QUEZADA BELTRAN KAROL YELINA 411 100% 0% 60%

8 E8211215 REYNA FONSECA JOSE ROBERTO 181 98% 2% 71%

8 E8212020 PHOCCO CCUNO, MELANY NOELIA 132 100% 0% 93%

8 E8213703 MARIA FERNANDA VEGA QUINDE 421 98% 2% 64%

8 E8213704 STEFANI ESPERANZA CRUZ ROJAS 429 100% 0% 31%

8 E8213708 DELIA MELISSA VILCHEZ ALBINES 278 100% 0% 65%

8 E8213720 ELIZABETH ESPERANZA MELENDEZ MATUTE 185 85% 15% 86%

8 E8213723 GINA FABIOLA CRUZ SOSA 396 92% 8% 29%

8 E8214372 SANTOS TAPIA MARITZA 607 89% 11% 32%

8 E8215547 JULIO CESAR RAMOS GARCIA 339 99% 1% 66%

8 E8216042 ALVAN GUTIERREZ, JEAN PAUL 584 100% 0% 32%

8 E8216045 CUBAS SANDOVAL, JAMILY LIZBETH 124 100% 0% 72%

8 E8216055 ORMEÑO LOPEZ, BRYAN ALBERT 139 93% 7% 43%

8 E8216090 MELISSA STEPHANNY TEJADA TASILLA 258 100% 0% 30%

8 E8216517 DIEGO ALEXHANDER RAMIREZ CARBAJAL 404 99% 1% 51%

8 E8216832 ARCAYA CASTILLO, EDDY ALEXANDER 364 97% 3% 53%

8 E8216834 CARDOZA ISUIZA, SANDRA KATHERINE 431 98% 2% 46%

8 E8217932 HUAMAN RAMIREZ, YORELY DEL PILAR 110 86% 14% 44%

8 E8218043 PAZOS CHANGANAQUÍ JORGE ALONSO 492 99% 1% 22%

11 (en blanco) (en blanco) 25716 7% 93% 47%

8 E8218160 CARLOS JOEL MORE MORALES 280 98% 2% 73%

8 E8218140 KELLY SARAI PACHERRES NOLE 441 97% 3% 24%

8 E8218520 KRISTIN MIREYA ROJAS CALLUPE 114 100% 0% 54%

8 E8218514 JOSSELIN AURELIA CABRERA GAMARRA 36 94% 6% 44%

8 E8218600 MARVEL DAMARIS SOTO HUAMAN 108 100% 0% 72%

8 E8218581 KATIZA MILEK SILVA ALEMAN 276 96% 4% 74%

8 E8218870 NEHIMI ISABEL CONDORI PARARI 233 96% 4% 68%

8 E8218879 ALICIA ANTUANETTE PINDAY VARGAS 161 94% 6% 69%

8 E8218865 JHON FERNANDO LLAULLY GUTIERREZ 199 100% 0% 91%

8 E8219198 SILVANA URSULA SALAS BALLESTEROS 165 100% 0% 67%

8 E8219192 BETZABETH QUISPE MAMANI 271 99% 1% 58%


8 E8219191 JHOSSEP JEAN PIERRE GONZALES GUTIERREZ 479 94% 6% 40%

8 E8219028 PEÑA SIMARRA MERCEDES MELISSA 170 100% 0% 65%

8 E8219023 MEDINA MUÑOZ LEONELA SADITH 274 99% 1% 53%

8 E8219018 DE LA CRUZ LEON TATIANA MILUSKA 428 99% 1% 47%

8 E8219039 CAMACHO OLIVO AYERLIN LEXIGLEE 500 100% 0% 60%

8 E8219038 MONZON PACHERREZ ESTHEFANY YANELA 221 99% 1% 55%

8 E8219045 PEÑA VALVERDE KATHERINE GIULIANA 170 95% 5% 77%

8 E8219016 CHUECA VALLEJOS STEPHANIE LUANY 229 98% 2% 48%

8 E8219194 JACKELINE LIZET ROMUCHO FALCON 293 95% 5% 79%

8 E8219403 YESSENIA VANESSA PACARA OCHOA 193 99% 1% 41%

8 E8219599 KEVIN ARNOLD SERRANO JARAMILLO 260 97% 3% 67%

8 E8219955 CARLOS RONALD HUARACHI MAMANI 513 98% 2% 24%

8 E8219944 LUIS MIGUEL FLORES CARRILLO 436 100% 0% 46%

8 E8212171 ALEJANDRA ALISSON LOPEZ GOMEZ 192 97% 3% 58%

8 E8214868 ELIZABETH DELGADO MARRUFO 181 99% 1% 51%

8 E8213437 JOVANA ZOLA CAYCHO CORAL 386 99% 1% 57%

8 E8219980 ERINSON RUBEN LEON RUIZ 266 97% 3% 56%

8 E8219995 PAOLO ALDAYR CASTRO MONTERO 294 95% 5% 49%

8 E8219996 SOPHIA ISABELLA VERDI ALFARO 484 100% 0% 60%

8 E8220414 RICARDO AUGUSTO ALAYO JIMÉNEZ 250 93% 7% 8%

8 E8220417 LUIS MIGUEL TALLEDO YAHUANA 405 94% 6% 20%

8 E8220416 VERONICA DEL ROCIO VALENCIA BARBOZA 243 93% 7% 33%

8 E8220344 KATHERINE MISHELLE ORMEÑO LÓPEZ 272 100% 0% 52%

8 E8220329 REYSSON JHOSUE BERNAOLA RAMOS 318 99% 1% 50%

8 E8220805 CINTHIA PAOLA DEL MILAGRO RUIZ CHICOMA DE C 93 96% 4% 74%

8 E8220806 LIDIA TEREZA MARQUEZ VILLEGAS 87 95% 5% 6%

8 E8220882 MARIA VICTORIA DE LOS ANGELES CURO BALDERA 377 92% 8% 42%

8 E8221127 BETSI EDADIL RUIZ SALDARRIAGA 453 100% 0% 57%

8 E8221123 JORGE CAMILO CHÁVEZ REYES 422 100% 0% 59%

8 E8221126 TREISI LUCERO ALEJOS ZAPATA 242 100% 0% 30%

8 E8221414 ROSICELA ANTONELA GUTIERREZ CASTRO 355 99% 1% 55%

8 E8221444 BRENDA YULIANA MORALES VILLALTA 269 82% 18% 73%

8 E8221484 NICOLE STEFFI MARRUFO ABANTO 221 95% 5% 64%

8 E8221475 ENRIQUE ARTURO BORDA CABRERA 154 95% 5% 84%

8 E8222049 AMMI SUNEM MONTAÑA NEGRON 280 100% 0% 63%

8 E8222838 YANELA XIOMARA PALACIOS PURIZACA 235 99% 1% 23%

8 E8222837 FABIAN ADRIANO CHAFIO CHUMIOQUE 693 100% 0% 31%

8 E8222840 ANTHONY CLARK GONZALEZ GUTIERREZ 184 100% 0% 74%

8 E8222850 NAHOMY JANET VASQUEZ SOSA 299 97% 3% 85%

8 E8222848 MILAGROS CAROLINA VALDIVIEZO VALDIVIEZO 162 94% 6% 80%

8 E8222694 FERMIN SALIRROSAS ROJAS 335 100% 0% 53%

8 E8223079 NATALIA MARIA FARFAN RASCO 149 95% 5% 53%

8 E8223076 BRIYITH DEL MILAGRO LOPEZ PACHERRES 9 100% 0% 78%

8 E8223075 JULIO CESAR SALAZAR CASTRO 21 100% 0% 43%

8 E8222856 VERONICA NILDA PILLACA OQUICHE, 91 96% 4% 75%

8 E8223172 VICTORIA RUTH CARRANZA QUISPE 176 98% 2% 61%

8 E8223230 DANIELA ALEJANDRA MARTINEZ CHARCA 638 99% 1% 50%

8 E8223228 BILHA ZILPA BORDA PONTE 986 96% 4% 5%


8 E8223231 DIEGO ALONSO PRECIADO SALAZAR 209 96% 4% 13%

8 E8224047 RAIZA IZAMAR MONTENEGRO VILLEGAS 260 100% 0% 55%

8 E8224062 GACELA ABIJAIL MARTINEZ ODAR 349 100% 0% 41%

8 E8224048 NATALY ELIZABETH VASQUEZ CARRASCO 224 100% 0% 74%

8 E8224043 ERICK GIAMPIERE JARA VASQUEZ 383 100% 0% 41%

8 E8224082 VIVIAM ROXETH DELGADO AGUINAGA 473 100% 0% 43%

8 E8224053 LISETH MIRELLA RAMIREZ ANTON 582 99% 1% 38%

8 E8224175 DANIEL HUMBERTO RESPALDIZA ALVA 391 100% 0% 23%

8 E8224146 ANTONELLA MENDOZA ROMAN 438 95% 5% 64%

8 E8224152 JHORDANA BRIGGYE CHAVEZ ALVAREZ 329 98% 2% 55%

8 E8224177 ADELINA FLORES CHINCHAY 406 95% 5% 37%

8 E8224151 DEYVIS VALLE SOPLA 224 99% 1% 20%

8 E8224161 JHAYLA MARIA RAMOS BUDIEL 214 100% 0% 58%

8 E8224157 ROSA ESTHER QUISPE ROQUE 340 100% 0% 54%

8 E8224463 NATHALY JOHANNA ZEGARRA FALEN 175 98% 2% 52%

8 E8224462 ELBA ROSA MUÑOZ YANGUA 262 99% 1% 60%

8 E8224468 DAVIEL ANDRÉS HERNÁNDEZ VILLEGAS 367 100% 0% 55%

8 E8224472 DIANA KAROLINA SANTAMARIA RAMIREZ 426 100% 0% 62%

8 E8224902 VERONICA MARIA DE JESUS MARTINEZ CAPITAN 521 99% 1% 42%

8 E8224901 SHIRLEY KAROLA PORTAL QUEZADA 405 100% 0% 54%

8 E8224613 JOSE LUIS ALEJANDRO GARCIA OBREGON 455 100% 0% 52%

8 E8224898 RAYSA YOVANKA SANTA CRUZ RODRIGUEZ 511 86% 14% 78%

8 E8225042 LUCIA MADONNA DECURT MONTOYA 446 99% 1% 33%


8 E8225041 STEVEN ORLANDO LAGUNA OLOYA 291 100% 0% 33%
8 E8224959 JUNIOR JHANPIER HUAMANCHUMO SANTISTEBAN 326 99% 1% 46%
8 E8225043 PIERO LUIGI VELASQUEZ RODRIGUEZ 629 94% 6% 31%
8 E8224947 VERONICA ELIZABETH CORONADO PISCOYA 546 98% 2% 48%
8 E8225464 MANUEL HORACIO ESPINOZA REYES 369 96% 4% 35%
8 E8225600 Geraldine Joselyn Vilela Aponte 130 95% 5% 52%
8 E8225461 NANCY BEATRIZ CASTRO CRUZ 391 100% 0% 60%
8 E8225452 ROSA JACQUELINE QUIROZ RODRIGUEZ 324 100% 0% 44%
8 E8225459 JOSE ANTONIO IPARRAGUIRRE RIVERO 106 100% 0% 79%
8 E8225458 ROMINA REGGIARDO RUSSO 176 98% 2% 52%
8 E8226140 ERNESTO LENER GARCIA BURGOS 216 100% 0% 72%
8 E8226067 Katherine adriana Aldana Vásquez 405 100% 0% 55%
8 E8226183 GRETTY YALU YEPEZ CHICOMA 316 100% 0% 78%
8 E8226186 MARCOS DANIEL JAVES RODRIGUEZ 304 98% 2% 70%
8 E8226044 ANAYELI LORENA CIEZA ROQUE 509 100% 0% 49%
8 E8226078 Sarita Alexandra Díaz Chico 1182 99% 1% 34%
8 E8226136 MARCOS DANIEL CONDORI CASTRO 355 97% 3% 78%
8 E8226184 YINA RAQUEL SATALAY NAVARRO 690 100% 0% 33%
8 E8226052 DORIS TARRILLO PEREZ 551 99% 1% 44%
8 E8226053 EDITHA DAMARIS NIETO CONTRERAS 376 97% 3% 58%
8 E8226072 MARIA ALEJANDRA LOPEZ GAMARRA 476 99% 1% 43%
8 E8227073 Carlos Fernando Yamamoto Moron 475 99% 1% 46%
8 E8227074 Carlos Joel Llonto Ancajima 535 99% 1% 44%
8 E8227072 Angealla briguitt diaz quintana 330 95% 5% 32%
8 E8227082 Geraldine Stefania Vargas Senador 331 100% 0% 50%
8 E8227090 Leyla Belén Amaya Salazar 368 95% 5% 39%
8 E8227086 José Ernesto Villanueva Flores 552 97% 3% 47%
8 E8227429 CESAR DEL PIERO VASQUEZ VALLEJOS 194 97% 3% 71%
8 E8227393 JOHN ANDERSON RAZURI SERNAQUE 264 98% 2% 54%
8 E8227399 KATTERING JAZZMIN FLORES ARCE 280 99% 1% 24%
8 E8227386 BETTY MERCEDES BUSTILLOS DIAZ 210 96% 4% 28%
8 E8227387 RUTH ARACELY PATAZCA LEYTON 327 99% 1% 41%
8 E8227432 YESICA HAIDE CERVANTES ESCURRA 537 69% 31% 44%
8 E8227392 JENIFFER NAYELI SECLEN TINEO 370 97% 3% 44%
8 E8227430 GABRIEL JOCSAN UGAZ PARDO 429 100% 0% 37%
8 E8227418 LESLIE LIZETH PINARES DIAZ 200 94% 6% 22%
8 E8227413 HENRY ANTONY YZQUIERDO AGIP 139 85% 15% 34%
8 E8227428 DINA DEL FATIMA BERNAL MEDINA 347 98% 2% 50%
8 E8227400 EBELIN MILAGRITOS CUEVA TERRY 186 94% 6% 40%
8 E8227420 CRISTINA ELIZABETH SILVA CAMPOVERDE 236 99% 1% 16%
8 E8227870 CESAR AUGUSTO CASTRO TORRES 16 100% 0% 13%
8 E8227390 OSCAR ARSENIO CORNEJO AQUINO 127 92% 8% 26%
8 E8227398 CINTHIA LUCERO FARROÑAN URUPEQUE 188 100% 0% 53%
8 E8227528 ELIA CRISTINA ACUÑA LECCA 17 100% 0% 94%
8 E8227869 GABRIELA GUILLERMINA DE FATIMA HORNA BENSUS 6 100% 0% 83%
8 E8227722 ROCIO ELIZABETH CALDERON SIVINCHA 107 94% 6% 2%
8 E8227720 ARNOLD MANUEL REYES HUAMÁN 95 98% 2% 17%
8 E8227684 MARIA FERNANDA FLORES LAZARO 138 96% 4% 0%
8 E8227698 ADA DEL MILAGRO ASCENCIO CASTRO 87 100% 0% 16%
8 E8227715 OSCAR ANTONIO FERNANDEZ PRADA 127 98% 2% 19%
8 E8227986 MAGNA ISABEL OLAZABAL PEREZ 34 100% 0% 0%
8 E8228174 CRISTOPHER JOEL SALDAÑA PERALTA 3 100% 0% 0%
13 Total general 75950 67% 33% 46%
ión de datos. La segmentación de Esta forma representa una segmentación de datos. La CE
iones posteriores. segmentación de datos se admite en Excel 2010 y versiones <49%
posteriores. <64%
n anterior de Excel o si el libro se <79%
anterior, no se puede usar la Si la forma se modificó en una versión anterior de Excel o si <80%
el libro se guardó en Excel 2003 o una versión anterior, no se
puede usar la segmentación de datos.
Porcentajes principales
Contacto Contacto Efectivo No conforme 1 Nivel
% CNE % No tipifiación % Conforme % No conforme % Retenido % No retenido Contacto No contacto
72% 0% 2% 98% 48% 52% 58% 0%
72% 1% 5% 95% 48% 52% 56% 4%
78% 0% 0% 100% 40% 60% 57% 3%
34% 1% 8% 92% 33% 67% 23% 0%
57% 0% 4% 96% 39% 61% 34% 0%
78% 0% 5% 95% 20% 80% 61% 1%
71% 1% 4% 96% 51% 49% 58% 0%
72% 21% 25% 75% 67% 33% 58% 6%
39% 1% 1% 99% 62% 38% 19% 0%
28% 1% 40% 60% 51% 49% 25% 1%
5% 2% 18% 82% 39% 61% 17% 0%
36% 0% 12% 88% 55% 45% 18% 1%
68% 0% 7% 93% 62% 38% 56% 0%
35% 0% 14% 86% 74% 26% 17% 0%
11% 2% 21% 79% 57% 43% 13% 5%
71% 0% 7% 93% 42% 58% 55% 7%
68% 0% 4% 96% 51% 49% 52% 10%
34% 1% 24% 76% 80% 20% 23% 0%
68% 0% 2% 98% 21% 79% 21% 0%
27% 1% 18% 82% 48% 52% 12% 0%
57% 1% 18% 82% 64% 36% 25% 2%
69% 1% 11% 89% 29% 71% 26% 0%
49% 0% 12% 88% 32% 68% 26% 0%
46% 0% 47% 53% 57% 43% 23% 1%
54% 0% 12% 88% 56% 44% 21% 1%
42% 12% 10% 90% 79% 21% 27% 3%
78% 0% 7% 93% 49% 51% 60% 1%
50% 0% 28% 72% 57% 43% 2% 35%
27% 1% 14% 86% 60% 40% 23% 1%
76% 0% 9% 91% 35% 65% 56% 2%
44% 2% 13% 87% 59% 41% 18% 0%
56% 0% 0% 100% 67% 33% 33% 6%
28% 0% 10% 90% 64% 36% 15% 0%
26% 0% 22% 78% 31% 69% 23% 2%
32% 0% 4% 96% 50% 50% 18% 3%
30% 1% 22% 78% 35% 65% 22% 1%
8% 1% 2% 98% 76% 24% 15% 0%
33% 0% 17% 83% 38% 62% 21% 0%
42% 0% 33% 67% 35% 65% 22% 0%
57% 3% 46% 54% 43% 57% 29% 3%
35% 0% 20% 80% 73% 27% 19% 0%
47% 0% 27% 73% 60% 40% 33% 1%
52% 0% 36% 64% 79% 21% 22% 0%
40% 0% 45% 55% 45% 55% 23% 0%
45% 0% 7% 93% 94% 6% 14% 0%
23% 0% 28% 72% 76% 24% 15% 2%
46% 6% 27% 73% 67% 33% 20% 0%
20% 0% 19% 81% 62% 38% 17% 2%
58% 1% 59% 41% 94% 6% 23% 0%
33% 0% 10% 90% 68% 32% 22% 2%
76% 0% 74% 26% 61% 39% 27% 1%
54% 0% 23% 77% 82% 18% 23% 0%
42% 0% 31% 69% 60% 40% 23% 1%
48% 1% 25% 75% 75% 25% 30% 1%
43% 0% 27% 73% 49% 51% 25% 0%
43% 1% 2% 98% 63% 37% 28% 2%
49% 2% 17% 83% 60% 40% 17% 3%
40% 0% 10% 90% 61% 39% 28% 0%
91% 1% 6% 94% 65% 35% 54% 5%
80% 0% 41% 59% 67% 33% 26% 2%
67% 0% 11% 89% 42% 58% 57% 7%
48% 0% 31% 69% 41% 59% 24% 0%
50% 0% 27% 73% 29% 71% 25% 0%
26% 0% 3% 97% 63% 38% 14% 2%
66% 26% 20% 80% 50% 50% 64% 5%
54% 3% 29% 71% 78% 22% 22% 3%
42% 0% 18% 82% 42% 58% 21% 0%
40% 1% 9% 91% 55% 45% 24% 0%
67% 3% 27% 73% 51% 49% 27% 0%
44% 0% 18% 82% 53% 47% 19% 1%
25% 2% 11% 89% 57% 43% 23% 6%
36% 0% 23% 77% 78% 22% 18% 0%
16% 0% 14% 86% 68% 32% 14% 2%
36% 1% 9% 91% 58% 43% 16% 0%
76% 1% 2% 98% 23% 77% 51% 1%
69% 0% 34% 66% 50% 50% 29% 0%
26% 0% 38% 62% 59% 41% 17% 0%
15% 0% 4% 96% 72% 28% 10% 1%
20% 0% 13% 87% 68% 32% 11% 3%
47% 0% 27% 73% 51% 49% 18% 0%
42% 5% 20% 80% 45% 55% 32% 4%
11% 11% 29% 71% 0% 100% 44% 0%
33% 24% 0% 100% 78% 22% 33% 0%
25% 0% 17% 83% 59% 41% 18% 1%
39% 0% 11% 89% 58% 42% 21% 1%
50% 0% 41% 59% 28% 72% 28% 0%
93% 1% 10% 90% 56% 44% 60% 3%
87% 0% 22% 78% 38% 62% 25% 1%
40% 5% 12% 88% 27% 73% 23% 0%
59% 0% 14% 86% 43% 57% 29% 0%
26% 0% 16% 84% 54% 46% 16% 0%
59% 0% 31% 69% 32% 68% 28% 0%
57% 1% 26% 74% 36% 64% 30% 0%
61% 0% 15% 85% 53% 47% 27% 0%
76% 1% 13% 87% 54% 46% 60% 0%
36% 0% 9% 91% 67% 33% 19% 2%
45% 0% 13% 87% 23% 77% 27% 1%
62% 0% 41% 59% 73% 27% 26% 3%
79% 1% 40% 60% 85% 15% 57% 0%
41% 1% 28% 72% 36% 64% 27% 0%
46% 0% 16% 84% 24% 76% 28% 0%
48% 0% 11% 89% 41% 59% 21% 1%
40% 0% 4% 96% 54% 46% 30% 0%
45% 1% 13% 87% 51% 49% 21% 0%
38% 0% 5% 95% 42% 58% 22% 0%
58% 0% 28% 72% 22% 78% 25% 0%
45% 1% 11% 89% 32% 68% 24% 0%
48% 0% 32% 68% 42% 58% 23% 0%
22% 0% 41% 59% 16% 84% 23% 8%
67% 1% 26% 74% 80% 20% 28% 0%
67% 0% 45% 55% 92% 8% 23% 0%
52% 2% 30% 70% 73% 27% 26% 1%
68% 0% 4% 96% 11% 89% 28% 3%
52% 0% 10% 90% 44% 56% 29% 0%
64% 1% 17% 83% 78% 22% 62% 4%
46% 2% 46% 54% 17% 83% 28% 1%
39% 0% 45% 55% 86% 14% 18% 0%
54% 2% 14% 86% 85% 15% 23% 0%
18% 3% 64% 36% 93% 7% 16% 0%
46% 2% 31% 69% 87% 13% 26% 1%
28% 0% 20% 80% 70% 30% 21% 0%
45% 0% 3% 97% 17% 83% 34% 0%
21% 1% 49% 51% 62% 38% 22% 0%
30% 0% 17% 83% 35% 65% 23% 1%
50% 1% 23% 77% 39% 61% 29% 0%
66% 0% 5% 95% 33% 67% 27% 0%
22% 0% 19% 81% 35% 65% 19% 1%
67% 0% 3% 97% 71% 29% 24% 0%
56% 0% 14% 86% 68% 32% 24% 1%
42% 1% 30% 70% 61% 39% 23% 2%
57% 0% 18% 82% 48% 52% 27% 0%
54% 0% 41% 59% 47% 53% 34% 0%
56% 0% 9% 91% 52% 48% 27% 0%
67% 1% 42% 58% 53% 47% 30% 3%
49% 0% 28% 72% 76% 24% 27% 0%
61% 0% 61% 39% 50% 50% 32% 3%
53% 0% 38% 62% 48% 52% 24% 2%
27% 2% 25% 75% 67% 33% 21% 1%
43% 3% 43% 57% 93% 7% 22% 1%
76% 0% 59% 41% 70% 30% 27% 1%
66% 6% 56% 44% 72% 28% 24% 0%
58% 0% 46% 54% 57% 43% 27% 0%
54% 2% 43% 57% 67% 33% 17% 10%
56% 0% 38% 62% 54% 46% 27% 1%
63% 0% 29% 71% 29% 71% 28% 0%
78% 0% 33% 67% 71% 29% 23% 3%
64% 1% 33% 68% 63% 37% 26% 9%
50% 0% 22% 78% 33% 67% 24% 1%
60% 0% 70% 30% 90% 10% 11% 3%
78% 6% 47% 53% 50% 50% 33% 0%
6% 81% 0% 100% 100% 0% 44% 0%
69% 4% 35% 65% 50% 50% 28% 5%
43% 4% 39% 61% 39% 61% 29% 0%
0% 6% 69% 31% 40% 60% 18% 0%
0% 17% 0% 100% 0% 100% 17% 0%
90% 7% 0% 100% 50% 50% 10% 0%
82% 1% 13% 88% 93% 7% 12% 0%
91% 9% 0% 0% 0% 0% 19% 0%
83% 1% 36% 64% 33% 67% 17% 0%
79% 2% 65% 35% 100% 0% 18% 0%
62% 38% 0% 0% 0% 0% 26% 0%
0% 100% 0% 0% 0% 0% 33% 0%
53% 1% 22% 78% 52% 48% 20% 13%
Bajas Retencion Esta forma representa una
>11% <49% segmentación de datos. La
>6% <64% segmentación de datos se admite en
<=3% >79% Excel 2010 y versiones posteriores.
<=0% >80%
Si la forma se modificó en una
versión anterior de Excel o si el
SPlibro se/ guardó
- Churn % en Excel 2003 o una
Contacto
versión anterior, noContacto
se puede usar la
Efectivo No conforme
segmentación de datos.
CE CNE No tipifiación Conforme No conforme Retenido No Retenido
26% 71% 0% 0% 26% 5% 22%
18% 75% 50% 1% 18% 2% 17%
20% 70% 0% 0% 20% 2% 18%
15% 39% 0% 0% 14% 2% 13%
21% 44% 0% 0% 21% 0% 22%
37% 69% 0% 1% 37% 1% 37%
29% 70% 67% 1% 27% 4% 24%
0% 67% 60% 0% 0% 0% 0%
9% 34% 50% 0% 9% 1% 8%
17% 46% 100% 5% 13% 4% 17%
15% 57% 50% 2% 13% 0% 16%
8% 35% 100% 2% 7% 1% 6%
23% 71% 50% 1% 22% 6% 18%
6% 38% 0% 1% 5% 3% 3%
11% 33% 75% 1% 10% 3% 10%
24% 74% 0% 1% 23% 2% 22%
20% 76% 0% 0% 20% 3% 18%
12% 44% 67% 3% 10% 4% 8%
8% 28% 0% 0% 8% 2% 6%
8% 24% 0% 0% 8% 1% 8%
11% 40% 0% 2% 9% 2% 9%
8% 35% 0% 0% 8% 0% 9%
13% 41% 0% 4% 8% 2% 7%
12% 37% 0% 5% 7% 3% 10%
6% 34% 0% 0% 6% 1% 5%
17% 45% 38% 2% 14% 5% 11%
15% 73% 0% 0% 15% 0% 17%
17% 37% 29% 5% 12% 5% 11%
15% 45% 50% 2% 13% 2% 13%
19% 70% 0% 2% 17% 1% 18%
5% 36% 0% 2% 3% 0% 4%
7% 58% 0% 0% 7% 7% 0%
6% 37% 0% 1% 5% 3% 3%
17% 43% 0% 3% 15% 1% 18%
13% 31% 0% 0% 13% 1% 12%
18% 36% 50% 2% 16% 1% 20%
11% 50% 100% 1% 10% 5% 5%
14% 36% 0% 1% 13% 0% 15%
16% 31% 0% 4% 12% 1% 17%
15% 43% 29% 4% 11% 2% 18%
9% 38% 0% 0% 9% 3% 8%
15% 54% 0% 6% 9% 2% 10%
4% 39% 50% 2% 2% 1% 3%
17% 33% 0% 6% 11% 2% 17%
3% 28% 0% 0% 3% 2% 2%
6% 49% 0% 3% 3% 3% 1%
9% 33% 7% 1% 8% 0% 12%
11% 46% 0% 4% 7% 3% 6%
10% 32% 50% 6% 4% 6% 3%
11% 45% 0% 2% 10% 4% 7%
13% 31% 0% 9% 4% 0% 16%
15% 30% 50% 2% 13% 9% 7%
10% 42% 0% 3% 7% 1% 9%
12% 49% 0% 3% 9% 7% 4%
17% 37% 0% 4% 13% 2% 16%
13% 48% 50% 0% 13% 3% 11%
9% 25% 80% 1% 7% 3% 6%
13% 49% 0% 0% 13% 3% 12%
17% 62% 33% 6% 11% 0% 12%
13% 32% 0% 8% 5% 2% 7%
32% 75% 0% 1% 31% 3% 32%
18% 30% 0% 6% 12% 2% 15%
12% 38% 0% 1% 11% 0% 16%
11% 26% 0% 0% 11% 5% 6%
20% 71% 70% 20% 0% 0% 0%
10% 33% 55% 3% 7% 3% 7%
10% 35% 0% 0% 10% 1% 11%
17% 35% 33% 2% 15% 4% 13%
10% 34% 50% 1% 8% 6% 6%
11% 28% 0% 4% 8% 1% 9%
23% 45% 20% 1% 22% 6% 19%
9% 35% 0% 4% 4% 3% 3%
11% 30% 0% 2% 9% 4% 7%
5% 36% 0% 1% 3% 1% 3%
25% 60% 67% 2% 23% 0% 23%
13% 36% 0% 4% 9% 3% 11%
15% 23% 0% 3% 12% 2% 16%
7% 31% 0% 1% 6% 2% 4%
8% 26% 0% 1% 7% 2% 7%
10% 27% 0% 2% 7% 2% 9%
9% 60% 57% 0% 9% 2% 10%
29% 100% 100% 0% 29% 0% 40%
11% 71% 20% 0% 11% 0% 11%
15% 27% 0% 2% 14% 4% 13%
11% 37% 0% 2% 10% 0% 11%
15% 42% 100% 3% 13% 1% 21%
38% 64% 75% 6% 32% 2% 33%
4% 30% 0% 0% 4% 0% 5%
11% 34% 71% 2% 9% 0% 10%
14% 40% 0% 1% 13% 0% 15%
9% 35% 0% 1% 8% 1% 9%
13% 39% 0% 2% 11% 1% 15%
15% 40% 25% 2% 13% 5% 12%
13% 37% 0% 2% 10% 3% 9%
28% 69% 100% 3% 24% 4% 24%
8% 41% 0% 0% 8% 2% 7%
15% 42% 0% 1% 14% 1% 15%
10% 37% 50% 6% 3% 1% 5%
16% 68% 50% 9% 7% 7% 4%
20% 39% 0% 5% 15% 2% 18%
15% 43% 0% 2% 13% 1% 14%
12% 32% 0% 0% 12% 1% 13%
18% 48% 0% 2% 16% 3% 14%
11% 34% 50% 1% 9% 1% 10%
15% 34% 0% 1% 14% 2% 12%
11% 36% 0% 3% 7% 0% 10%
13% 36% 50% 1% 12% 2% 11%
15% 32% 0% 4% 11% 1% 14%
19% 56% 0% 8% 11% 0% 20%
8% 38% 25% 1% 6% 5% 4%
8% 31% 0% 2% 6% 9% 2%
13% 38% 20% 6% 7% 6% 5%
13% 38% 50% 1% 13% 0% 13%
14% 45% 0% 1% 13% 2% 13%
43% 76% 100% 11% 32% 22% 17%
22% 40% 0% 5% 17% 3% 29%
7% 34% 100% 5% 2% 2% 2%
10% 33% 40% 0% 10% 6% 6%
12% 32% 33% 10% 2% 3% 3%
12% 39% 75% 2% 10% 11% 3%
13% 41% 0% 0% 13% 5% 11%
18% 52% 0% 0% 18% 1% 18%
15% 48% 0% 6% 9% 5% 13%
12% 48% 0% 1% 11% 1% 12%
14% 44% 67% 2% 12% 1% 15%
11% 36% 25% 1% 10% 1% 11%
15% 38% 0% 3% 12% 1% 14%
10% 32% 0% 0% 10% 5% 5%
10% 36% 0% 0% 10% 4% 7%
13% 38% 0% 2% 10% 3% 12%
14% 37% 0% 2% 11% 2% 12%
18% 48% 100% 12% 6% 2% 7%
11% 40% 0% 1% 10% 1% 10%
18% 38% 50% 11% 7% 3% 9%
11% 44% 0% 4% 7% 3% 7%
20% 42% 0% 14% 7% 2% 15%
11% 38% 0% 4% 7% 3% 8%
15% 33% 100% 5% 11% 1% 13%
7% 35% 100% 3% 4% 2% 5%
12% 31% 100% 3% 9% 4% 19%
18% 28% 25% 14% 4% 0% 8%
14% 35% 100% 7% 7% 3% 11%
11% 36% 22% 3% 8% 2% 12%
15% 38% 0% 6% 8% 3% 10%
20% 32% 50% 4% 15% 5% 16%
14% 27% 0% 2% 12% 4% 14%
18% 37% 50% 8% 10% 0% 15%
12% 38% 0% 2% 11% 2% 11%
10% 13% 0% 9% 1% 0% 5%
16% 36% 46% 13% 3% 0% 5%
0% 100% 46% 0% 0% 0% 0%
13% 38% 0% 10% 3% 5% 0%
15% 43% 63% 4% 11% 2% 16%
13% 0% 100% 6% 6% 0% 20%
20% 0% 0% 0% 20% 0% 20%
0% 11% 13% 0% 0% 0% 0%
0% 14% 0% 0% 0% 0% 0%
0% 19% 25% 0% 0% 0% 0%
0% 21% 0% 0% 0% 0% 0%
4% 20% 67% 4% 0% 0% 0%
0% 29% 23% 0% 0% 0% 0%
0% 0% 33% 0% 0% 0% 0%
14% 44% 42% 3% 11% 3% 11%
TMG Quartiles
CE CNE Q1 CE Q2 Bajas Q3 Retencion
0:15:34 0:00:46 Q4 Q4 Q4
0:12:50 0:00:57 Q4 Q4 Q4
0:14:31 0:00:58 Q4 Q4 Q4
0:16:55 0:01:39 Q2 Q4 Q4
0:14:47 0:01:28 Q4 Q4 Q4
0:11:00 0:00:50 Q4 Q4 Q4
0:13:30 0:01:02 Q4 Q4 Q3
0:13:57 0:00:58 Q4 Q4 Q2
0:16:25 0:01:24 Q3 Q4 Q3
0:13:35 0:00:29 Q2 Q4 Q3
0:10:52 0:00:45 Q1 Q4 Q4
0:12:38 0:00:48 Q2 Q4 Q3
0:07:31 0:00:52 Q4 Q4 Q3
0:20:06 0:01:10 Q2 Q4 Q2
0:18:44 0:04:50 Q1 Q4 Q3
0:13:50 0:00:52 Q4 Q4 Q4
0:13:13 0:01:02 Q4 Q4 Q3
0:17:13 0:00:58 Q2 Q4 Q1
0:09:06 0:00:45 Q4 Q4 Q4
0:14:47 0:00:46 Q2 Q4 Q4
0:10:42 0:00:58 Q4 Q4 Q2
0:11:19 0:00:45 Q4 Q4 Q4
0:12:13 0:00:53 Q3 Q4 Q4
0:15:56 0:00:32 Q3 Q4 Q3
0:15:08 0:00:53 Q4 Q4 Q3
0:12:26 0:01:37 Q4 Q4 Q2
0:17:31 0:00:53 Q4 Q4 Q3
- - Q4 Q1 Q3
0:16:17 0:01:03 Q2 Q4 Q3
0:12:31 0:00:52 Q4 Q4 Q4
0:13:08 0:01:29 Q3 Q4 Q3
- - Q4 Q4 Q2
0:09:31 0:00:55 Q2 Q4 Q2
0:14:01 0:00:58 Q2 Q4 Q4
0:11:11 0:01:18 Q2 Q4 Q3
0:13:07 0:01:00 Q2 Q4 Q4
0:19:16 0:01:17 Q1 Q4 Q2
0:16:15 0:00:58 Q2 Q4 Q4
0:13:08 0:00:43 Q3 Q4 Q4
0:10:47 0:01:18 Q4 Q4 Q4
0:15:05 0:00:56 Q2 Q4 Q2
0:14:41 0:01:19 Q3 Q4 Q3
0:12:37 0:00:50 Q4 Q4 Q2
0:09:27 0:00:35 Q3 Q4 Q4
0:15:08 0:01:09 Q3 Q4 Q1
0:09:38 0:01:04 Q2 Q4 Q2
0:09:50 0:00:55 Q4 Q4 Q2
0:14:34 0:00:52 Q1 Q4 Q3
0:07:10 0:01:08 Q4 Q4 Q1
0:09:09 0:01:11 Q2 Q4 Q2
0:12:38 0:00:41 Q4 Q4 Q3
0:11:54 0:01:35 Q4 Q4 Q1
- - Q3 Q4 Q3
- - Q3 Q4 Q2
- - Q3 Q4 Q3
0:14:15 0:00:51 Q3 Q4 Q3
0:12:46 0:01:05 Q3 Q4 Q3
0:12:12 0:00:49 Q3 Q4 Q3
0:17:03 0:02:13 Q4 Q4 Q2
0:14:01 0:00:30 Q4 Q4 Q2
0:12:18 0:01:00 Q4 Q4 Q4
0:07:43 0:00:59 Q3 Q4 Q4
0:08:39 0:00:59 Q3 Q4 Q4
0:14:19 0:01:11 Q2 Q4 Q3
0:11:45 0:01:04 Q4 Q4 Q3
0:12:24 0:00:31 Q4 Q4 Q2
0:13:41 0:01:14 Q3 Q4 Q4
0:10:36 0:00:36 Q3 Q4 Q3
0:14:20 0:01:07 Q4 Q4 Q3
0:11:24 0:00:41 Q3 Q4 Q3
0:14:42 0:01:04 Q2 Q4 Q3
0:11:18 0:01:03 Q3 Q4 Q2
0:16:00 0:01:03 Q1 Q4 Q2
0:14:34 0:01:16 Q3 Q4 Q3
0:11:06 0:01:05 Q4 Q4 Q4
0:13:42 0:01:04 Q4 Q4 Q3
0:15:28 0:01:05 Q2 Q4 Q3
0:18:46 0:01:02 Q1 Q3 Q2
0:16:39 0:01:31 Q1 Q4 Q2
0:15:44 0:01:54 Q3 Q4 Q3
0:13:53 0:01:06 Q3 Q4 Q4
0:12:08 0:00:42 Q2 Q4 Q4
0:12:38 0:00:42 Q4 Q4 Q2
0:08:57 0:01:33 Q2 Q4 Q3
0:19:37 0:00:43 Q3 Q4 Q3
0:05:50 0:01:08 Q3 Q4 Q4
0:11:14 0:00:53 Q4 Q4 Q3
0:10:06 0:00:31 Q4 Q4 Q4
0:09:28 0:00:43 Q3 Q4 Q4
0:16:09 0:00:42 Q4 Q4 Q4
0:16:01 0:00:33 Q2 Q4 Q3
0:09:23 0:00:38 Q4 Q4 Q4
0:09:24 0:00:37 Q4 Q4 Q4
0:09:08 0:01:08 Q4 Q4 Q3
0:09:47 0:00:45 Q4 Q4 Q3
0:13:51 0:00:39 Q3 Q4 Q2
0:07:59 0:00:52 Q3 Q4 Q4
0:07:39 0:01:13 Q4 Q4 Q2
0:16:24 0:02:46 Q4 Q4 Q1
0:12:38 0:00:41 Q3 Q4 Q4
0:18:14 0:00:34 Q3 Q4 Q4
0:13:27 0:00:39 Q3 Q4 Q4
0:11:48 0:00:42 Q3 Q4 Q3
0:17:05 0:01:05 Q3 Q4 Q3
0:15:25 0:00:54 Q3 Q4 Q4
0:12:55 0:00:46 Q4 Q4 Q4
0:13:20 0:00:53 Q3 Q4 Q4
0:14:03 0:00:50 Q3 Q4 Q4
0:09:52 0:00:53 Q2 Q4 Q4
0:16:56 0:01:31 Q4 Q4 Q1
0:21:33 0:02:14 Q4 Q4 Q1
0:14:52 0:01:44 Q4 Q4 Q2
0:11:37 0:00:36 Q4 Q4 Q4
0:16:27 0:00:51 Q4 Q4 Q4
0:12:36 0:01:34 Q4 Q4 Q2
0:07:22 0:01:49 Q3 Q4 Q4
0:14:26 0:01:06 Q3 Q4 Q1
0:18:54 0:01:23 Q4 Q4 Q1
0:26:22 0:00:44 Q1 Q4 Q1
0:18:13 0:01:50 Q3 Q4 Q1
0:10:35 0:00:56 Q2 Q4 Q2
0:10:40 0:00:43 Q3 Q4 Q4
0:12:44 0:01:00 Q2 Q4 Q3
0:19:01 0:01:02 Q2 Q4 Q4
0:12:58 0:00:40 Q3 Q4 Q4
0:14:57 0:00:46 Q4 Q4 Q4
0:13:57 0:00:48 Q2 Q4 Q4
0:10:36 0:00:54 Q4 Q4 Q2
0:13:38 0:00:50 Q4 Q4 Q2
0:15:07 0:01:04 Q3 Q4 Q3
0:12:45 0:00:59 Q4 Q4 Q4
0:10:24 0:00:40 Q4 Q4 Q4
0:14:36 0:00:46 Q4 Q4 Q3
0:11:04 0:00:38 Q4 Q4 Q3
0:19:16 0:01:44 Q3 Q4 Q2
0:16:58 0:01:50 Q4 Q4 Q3
0:12:35 0:00:48 Q4 Q4 Q4
0:13:25 0:01:48 Q2 Q4 Q2
0:15:48 0:01:26 Q3 Q4 Q1
0:12:15 0:01:44 Q4 Q4 Q2
0:09:30 0:01:59 Q4 Q4 Q2
0:12:15 0:00:45 Q4 Q4 Q3
0:10:18 0:01:23 Q4 Q4 Q2
0:10:10 0:00:42 Q4 Q4 Q3
0:10:29 0:00:46 Q4 Q4 Q4
0:11:08 0:02:17 Q4 Q4 Q2
0:13:53 0:02:14 Q4 Q4 Q3
0:10:37 0:01:10 Q3 Q4 Q4
0:10:59 0:02:22 Q4 Q4 Q1
0:11:57 0:00:53 Q4 Q4 Q3
0:17:44 0:00:38 Q4 Q4 Q1
0:11:26 0:03:28 Q4 Q4 Q3
0:12:24 0:01:00 Q3 Q4 Q4
0:09:25 0:00:53 Q1 Q4 Q4
0:10:46 0:01:07 Q1 Q4 Q4
0:12:11 0:01:29 Q4 Q3 Q3
0:20:53 0:00:40 Q4 Q4 Q1
0:00:00 0:00:00 Q4 Q4 Q4
0:15:48 0:02:10 Q4 Q4 Q4
0:11:56 0:00:47 Q4 Q4 Q1
0:00:00 0:00:00 Q4 Q4 Q4
0:10:09 0:01:16 Q4 Q4 Q4
0:13:19 0:01:02 Q4 Q4 Q3

También podría gustarte