T.Din.Datos Ext.
-
Upload
jeisson-andres-cortes -
Category
Documents
-
view
241 -
download
2
description
Transcript of T.Din.Datos Ext.
TABLAS DINAMICAS CON FUENTE DE DATOS EXTERNA
TABLAS DINAMICAS CON FUENTE DE DATOS EXTERNA
Con esto se completan las cuatro opciones que ofrece el Asistente para tablas y grficos dinmicos en el paso 1 de 3 respecto a:
Donde estn los datos que desea analizar ?
Lista o base de datos de Microsoft Excel
Fuente de datos externa
Rango de consolidacin mltiple
Otra tabla dinmica u otro grfico dinmico
Siguiendo con el mismo criterio se trabajo con el misma lista o base de datos que se empleo para realizar el trabajo hasta el momento. Pero en este caso trasladada a Microsoft Access, para realizar desde all todos los pasos de Importacin de datos externos, necesarios para realizar la tabla con Excel y comprobar los resultados finales.
Se empleo como se menciono la misma base de cuenta telefnica modificada, crendose en Access una base de datos denominada Duracin e Importes,
mediante dos tablas, la primera denominada Destino, con el contenido de los destinos, Celular, Correo, Internet, Inter-Urb y Urbanas, con su clave principal, y una tabla denominada Control de tiempos e importes, con el resto de datos correspondientes a la lista conocida, introduciendo en Destino la clave respectiva.
Por otro lado se creo la Consulta, con la vinculacin de ambas denominada Duracin e Importes. Esta Consulta nos proporciona la base de datos con la que vamos a trabajar.
Quedando por lo tanto explicar paso a paso:
Ejecucin de una Tabla Dinmica con Excel, empleando una Base de datos desde Access
Paso 1 de 3
Activar- Fuente de datos externa
Paso 2 de 3
Pulsar sobre Obtener datos
Es imprescindible tener instalado Microsoft Query para realizar esta operacin. Porque produce el enlace entre la base de datos de Access y Excel.
Caso contrario aparecer la siguiente ventana de aviso:
Microsoft Query no esta instalado
Correctamente o no tiene memoria suficiente
para ejecutarse.
Haga clic en Aceptar, cierre uno o varios programas
para liberar recursos e intente de nuevo la operacin.
Si vuelve a aparecer este mensaje, ejecute el programa
de instalacin que utilizo para instalar Excel y repare o
vuelva a instalar Query
Como instalar MS Query
Aceptar
Solucionado el inconveniente descripto, se continua con el paso 2 de 3, que como se menciono, al tener instalado el MS Query tendremos la siguiente imagen en pantalla
Imagen A
En la ficha Consulta, figuran todas las que se hallan creado y guardado con Microsoft Query.
En este caso no existe ninguna, por lo tanto la nica opcin que tenemos es:
1 Seleccionar < Nueva fuente de datos > y Aceptar
2 De la operacin anterior surge la siguiente pantalla
Imagen B
Debiendo llenarse los 4 paso a partir del primero, que simultneamente va habilitando a los restantes
En el primer paso colocamos Datos desde Access, que nos permite utilizarla en caso de querer volver a emplearla.
Como Paso 2, se despliega una lista y seleccionamos Microsoft Access Driver [*.mdb]Como Paso 3, pulsar Conectar, esta operacin procede a la instalacion del controlador.
Se presenta una pantalla con varios botones.
Deviendo pulsarse sobre Seleccionar
Dando origen a la siguiente imagen, que como se puede apreciar, al seleccionar Duracion e Importes, que correspone a nuestro archivo desde Access lo traslada a la parte superior es decir Nombre de base de datos.
Imagen C
Una ves seleccionada la base de datos correcta, se da por terminada la instalacin del controlador.
Debiendo pulsarse sobre Aceptar
Esta operacin determina la nueva imagen para terminar la instalacin
Sobre esa imagen activar Base de datos
Pulsar Aceptar
Esta operacin devuelve la Imagen C es decir Seleccionar base de datos
Se reproduce la misma operacin realizada sobre esa imagen anteriormente.
Pulsar Aceptar.Surge nuevamente la Imagen B pero completa es decir Crear nueva fuente de datos
Falta solamente el paso 4, si bien no es necesario, se puede elegir una tabla para la base de datos, mediante una lista desplegable que surge al pulsar el botn respectivo. Si seleccionamos Duracin e Importe, la misma permanecer seleccionada cuando se inicie el Asistente de consultas
Imagen B completa
Pulsar Aceptar
Surge la siguiente imagen de Elegir Fuente de datos, donde se encuentra incorporada la:
Base de datos desde Access
Imagen D
Pulsar Aceptar
Tendremos la imagen: Asistente para consulta Elegir columnas
Imagen E
En esta imagen incluiremos a la derecha en Columnas en la consulta los destinos que nos interesa incluir en la tabla mediante Seleccin y >Quedando de la siguiente manera
Pulsar Siguiente
En este paso aparece una pantalla:
Asistente de consultas Filtrar datos
Donde se especifica que filas incluir en la consulta. En este caso no filtramos ningn dato por lo tanto. Pulsar Siguiente
Saltamos a otra pantalla del Asistente de consulta Orden de resolucin
Tenemos tres opciones para ordenar los datos, en nuestro caso optamos por
Ordenar por Orden Ascendente
Destino
Fecha
Importe
Pulsar Siguiente
Tenemos la terminacin de la operacin
Asistente para consultas - FinalizarManteniendo activado
Devolver datos a Microsoft Excel
Pulsar Finalizar
Volviendo al paso 2 de 3 de Asistente de tablas y grficos dinmicos
Dnde estn guardados los datos externos?
Obtener datos Se han recuperado campos de datos
Pulsar Siguiente
En caso de adoptar en el paso de Asistente para consultasFinalizar por Activar
Ver datos o modificar consulta en Microsoft QueryAparece la siguiente figura Se podrn ver o modificar los datos antes de devolverlos a Excel pulsando el botn que se indica. Realizado esto, se vuelve tambin al paso 2 del Asistente para tablas dinmicas
Como ultima acotacin, volviendo a la pantalla Asistente para consultaFinalizarSi se pulsa Guardar consulta.
Esta se guardara en la carpeta Queries situada en
\Archivos de programa \ Microsoft Office\Queries
Encontrndonos en el paso 2 de 3, los pasos de diagramacin de la tabla ya se conocen, el mismo criterio para el paso 3 de 3 que corresponde a la ubicacin de la misma.
Cumplido estos pasos la tabla obtenida es la siguiente.
ABC
1Fecha(Todas)
2
3DestinoDatosTotal
4CelularSuma de Duracin0:35:32
5Suma de Importe$ 1,00
6CorreoSuma de Duracin4:22:44
7Suma de Importe$ 4,40
8InternetSuma de Duracin11:56:53
9Suma de Importe$ 5,03
10Inter-UrbSuma de Duracin0:29:42
11Suma de Importe$ 8,42
12UrbanasSuma de Duracin1:19:44
13Suma de Importe$ 2,59
14Total Suma de Duracin18:44:35
15Total Suma de Importe$ 21,44
Como podemos observar, la tabla obtenida produce los mismos resultados totales y parciales por destino que las desarrolladas en las opciones que presenta Excel
Si quisiramos producir de la tabla un grafico dinmico, tendramos que realizar los mismos pasos conocidos, Excel en este caso nos ofrece una opcin que la vamos a aprovechar pero maquillndola, como colocar un color por destino etc, a travs de Formato, que conocemos, quedando de la siguiente manera
Si se produciera el mismo filtrado, es decir seleccionamos la fecha 26/09/02, veremos que el resultado es el mismo.
ABC
1Fecha26/09/01mircoles
2
3DestinoDatosTotal
4CelularSuma de Duracin0:01:53
5Suma de Importe$ 0,10
6CorreoSuma de Duracin1:09:26
7Suma de Importe$ 0,99
8InternetSuma de Duracin2:33:29
9Suma de Importe$ 1,13
10UrbanasSuma de Duracin0:02:34
11Suma de Importe$ 0,19
12Total Suma de Duracin3:47:22
13Total Suma de Importe$ 2,41
Si bien el ejemplo es repetitivo, la intencin es demostrar que si bien los caminos son distintos los resultados son los mismos
El mismo procedimiento para realizar el grafico respectivo, que con retoques se muestra de la siguiente manera
Opciones de tabla dinmica
En este caso se trata de:
Opciones de datos externos
Guardar contrasea
Al guardar la contrasea de proteccin y tener habilitada esta opcin, permite acceder a los datos que tengamos protegidos sin tener que escribirla.
Consulta en segundo plano
Al no estar seleccionada, y tener que conectarse con una fuente de datos, se deber esperar mientras se actualizan los datos.
En caso de conectarse y querer seguir trabajando en Excel normalmente, seleccionar la opcin, y en la tabla dinmica aparece un icono, mientras los datos se estn actualizando.
Optimizar memoria
En caso que al finalizar el paso 4 se produzca un mensaje, indicando que no es posible crear la tabla por falta de memoria suficiente, probar activar esta opcin antes de pulsar finalizar.
Opciones avanzadas de campo de tabla dinmica
Recuperar datos externos para todos los elementos( rendimiento mas rpido)
Se selecciona siempre que al existir un problema de memoria, se halle solucionado con activar en el caso anterior Optimizar memoria.
En este caso se consigue la mxima rapidez en recuperar datos.
Consultar fuente de datos externa al seleccionar cada elemento( requiere menos memoria)
Activando esta opcin se aprovecha la memoria al mximo pero se pierde rapidez.
Para evitar errores en este caso se recomienda activar.
Deshabilitar crear tablas a partir de este campo ( recomendado)
Crear una tabla dinmica a partir de otra
Para proseguir con el tema de optimizar memoria, si la intencin es crear varias tablas dinmicas a travs de los mismos datos, debemos en el paso 1 del Asistente, optar por la opcin Otra tabla dinmica, aunque la tabla se construya con datos externos.
Caso contrario de construirse una nueva tabla con el mismo origen de datos, Excel en el ultimo paso propondr una opcin con el siguiente tipo de incrimino
En este caso pulsamos Si
Se da por terminada la opcin de Ejecucin de Tablas Dinmicas con Fuente de datos Externa
Ejecutado por
Gonzalo H. Fernndez [email protected] Buenos Aires Argentina
EMBED PBrush
EMBED PBrush
EMBED PBrush
EMBED PBrush
EMBED PBrush
EMBED PBrush
EMBED PBrush
EMBED PBrush
EMBED PBrush
EMBED PBrush
_1095010816.xlsMemoria
GrficoA.C
0.0013078704
0.1
0.0482175926
0.99
0.1065856481
1.13
0.0017824074
0.19
Total
T. Acces (2)
ABC
1Fecha9/26/01miercoles
2
3DestinoDatosTotal
4CelularSuma de Duracion0:01:53
5Suma de Importe$ 0.10
6CorreoSuma de Duracion1:09:26
7Suma de Importe$ 0.99
8InternetSuma de Duracion2:33:29
9Suma de Importe$ 1.13
10UrbanasSuma de Duracion0:02:34
11Suma de Importe$ 0.19
12Total Suma de Duracion3:47:22
13Total Suma de Importe$ 2.41
14
15
Grfico1T.G.
0.02467592591
0.18245370374.4
0.49783564815.03
0.0206258.42
0.05537037042.59
&A
Page &P
Duracion
Importe
T.din.T.G
ABCDEFGH
1
2Fechas(Todas)0
3
4Suma de ValorColumna
5DestinoDuracionImporte
6Celular0:35:32$ 1.004:29:50
7Correo4:22:44$ 4.404:22:44
8Internet11:56:53$ 5.030:07:06
9Inter-Urb0:29:42$ 8.42
10Urbanas1:19:44$ 2.59
11Total general18:44:35$ 21.44
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
Hoja2
NFechaDia semanaHora inicialDestinoNumeroDuracionHora finalImporte
19/15/01sabado0:00:04Correo61022238470:00:460:00:500.05
T.Dinamica
Dia semana(Todas)
Destino
FechaDatosCorreoInernertUrbanasCelularInter-UrbTotal general
9/15/01Suma de Duracion0:00:460:06:360:07:22
Suma de Importe0.050.190.24
9/16/01Suma de Duracion0:07:221:00:020:05:080:05:001:17:32
Suma de Importe0.150.050.092.312.60
9/17/01Suma de Duracion0:03:511:04:020:00:090:08:231:16:25
Suma de Importe0.100.470.050.230.85
9/18/01Suma de Duracion0:05:131:05:560:00:080:01:421:12:59
Suma de Importe0.190.470.050.100.81
9/19/01Suma de Duracion0:18:392:00:510:00:070:01:530:10:102:31:40
Suma de Importe0.380.800.050.054.695.97
9/20/01Suma de Duracion0:28:180:13:020:01:320:01:500:44:42
Suma de Importe0.240.330.150.050.77
9/21/01Suma de Duracion0:02:280:02:010:04:29
Suma de Importe0.100.200.30
9/23/01Suma de Duracion0:16:231:50:100:10:040:03:242:20:01
Suma de Importe0.340.750.140.051.28
9/24/01Suma de Duracion0:54:390:09:080:06:570:05:571:16:41
Suma de Importe0.710.190.140.141.18
9/25/01Suma de Duracion0:22:040:01:090:06:120:29:25
Suma de Importe0.520.200.140.86
9/26/01Suma de Duracion1:09:262:33:290:02:340:01:533:47:22
Suma de Importe0.991.130.190.102.41
9/27/01Suma de Duracion0:24:030:05:040:02:380:31:45
Suma de Importe0.390.250.090.73
9/28/01Suma de Duracion0:06:020:08:450:14:47
Suma de Importe0.190.230.42
9/30/01Suma de Duracion0:03:300:28:410:14:430:01:400:14:321:03:06
Suma de Importe0.050.190.230.051.421.94
10/1/01Suma de Duracion0:03:230:12:390:18:450:34:47
Suma de Importe0.200.392.312.90
10/2/01Suma de Duracion0:28:090:17:190:45:28
Suma de Importe0.280.520.80
10/3/01Suma de Duracion1:01:120:07:140:01:281:09:54
Suma de Importe0.050.650.100.80
10/4/01Suma de Duracion0:59:450:09:090:08:451:17:39
Suma de Importe0.510.331.162.00
10/5/01Suma de Duracion1:08:100:14:151:22:25
Suma de Importe0.710.481.19
10/8/01Suma de Duracion0:27:590:58:010:02:161:28:16
Suma de Importe0.380.380.050.81
10/9/01Suma de Duracion1:32:320:08:471:41:19
Suma de Importe0.750.381.13
10/10/01Suma de Duracion0:13:231:42:230:09:030:00:522:05:41
Suma de Importe0.190.750.380.051.37
10/11/01Suma de Duracion0:48:331:17:480:01:080:05:412:13:10
Suma de Importe0.430.660.150.091.33
10/12/01Suma de Duracion2:19:560:15:430:03:472:39:26
Suma de Importe1.700.430.192.32
10/14/01Suma de Duracion0:01:560:22:560:19:590:44:51
Suma de Importe0.100.190.330.62
10/15/01Suma de Duracion0:32:190:07:270:00:110:39:57
Suma de Importe0.620.090.050.76
10/16/01Suma de Duracion0:06:181:59:550:05:012:11:14
Suma de Importe0.090.750.191.03
10/17/01Suma de Duracion0:09:590:09:170:19:16
Suma de Importe0.190.490.68
10/18/01Suma de Duracion0:49:060:55:270:07:030:00:071:51:43
Suma de Importe0.380.570.280.051.28
10/19/01Suma de Duracion0:26:460:22:290:01:290:50:44
Suma de Importe0.520.430.151.10
10/21/01Suma de Duracion0:03:580:16:160:07:170:27:31
Suma de Importe0.050.190.200.44
10/22/01Suma de Duracion0:21:201:27:360:43:550:03:380:00:552:37:24
Suma de Importe0.340.711.080.090.522.74
10/23/01Suma de Duracion0:01:060:12:190:11:310:24:56
Suma de Importe0.050.230.380.66
10/24/01Suma de Duracion0:32:241:40:180:31:380:10:062:54:26
Suma de Importe0.330.700.864.666.55
10/25/01Suma de Duracion1:11:001:38:580:11:003:00:58
Suma de Importe0.520.700.431.65
10/26/01Suma de Duracion0:28:080:00:100:28:18
Suma de Importe0.470.100.57
10/28/01Suma de Duracion0:09:011:13:300:21:251:43:56
Suma de Importe0.190.560.421.17
10/29/01Suma de Duracion0:28:101:28:500:05:102:02:10
Suma de Importe0.390.560.191.14
10/30/01Suma de Duracion0:36:210:44:390:19:521:40:52
Suma de Importe0.750.470.711.93
10/31/01Suma de Duracion0:08:331:19:560:03:561:32:25
Suma de Importe0.240.870.251.36
11/1/01Suma de Duracion0:27:401:46:410:03:582:18:19
Suma de Importe0.570.890.151.61
11/2/01Suma de Duracion0:09:400:14:520:13:220:37:54
Suma de Importe0.290.380.611.28
11/4/01Suma de Duracion0:09:520:03:050:12:57
Suma de Importe0.190.100.29
11/5/01Suma de Duracion0:12:173:04:390:14:390:06:083:37:43
Suma de Importe0.281.360.380.092.11
11/6/01Suma de Duracion0:26:461:14:020:05:200:02:441:48:52
Suma de Importe0.240.560.140.141.08
11/7/01Suma de Duracion0:08:460:03:170:58:270:13:441:24:14
Suma de Importe0.190.100.890.241.42
11/8/01Suma de Duracion0:12:212:10:510:12:550:03:422:39:49
Suma de Importe0.190.940.480.101.71
11/9/01Suma de Duracion0:33:020:08:320:41:34
Suma de Importe0.520.380.90
11/11/01Suma de Duracion0:19:070:11:230:01:100:31:40
Suma de Importe0.370.140.100.61
9/22/01Suma de Duracion0:08:050:08:05
Suma de Importe0.290.29
9/29/01Suma de Duracion0:06:420:06:42
Suma de Importe0.140.14
10/6/01Suma de Duracion0:16:500:16:50
Suma de Importe0.330.33
10/13/01Suma de Duracion0:10:470:10:47
Suma de Importe0.290.29
10/20/01Suma de Duracion0:11:050:11:05
Suma de Importe0.280.28
10/27/01Suma de Duracion0:10:530:10:53
Suma de Importe0.280.28
11/10/01Suma de Duracion0:17:050:17:05
Suma de Importe0.330.33
Total Suma de Duracion21:11:5738:22:369:06:371:12:081:08:1371:01:31
Total Suma de Importe17.1619.1516.411.8517.0771.64
T. Acces
Fecha(Todas)
DestinoDatosTotal
CelularSuma de Duracion0:35:32
Suma de Importe1
CorreoSuma de Duracion4:22:44
Suma de Importe4.4
InternetSuma de Duracion11:56:53
Suma de Importe5.03
Inter-UrbSuma de Duracion0:29:42
Suma de Importe8.42
UrbanasSuma de Duracion1:19:44
Suma de Importe2.59
Total Suma de Duracion18:44:35
Total Suma de Importe21.44
Telefono Word (2)
ABCDEFGH
1FechaDia semanaHora inicialDestinoNumeroDuracionHora finalImporte
29/15/01sabado0:00:04Correo61022238470:00:460:00:50$ 0.05
39/15/01sabado10:42:49Urbanas46938810:06:3610:49:25$ 0.19
49/15/01sabado20:31:44Internet61022276381:28:5022:00:34$ 0.56
59/16/01domingo19:10:44Correo61022238470:03:4619:14:30$ 0.05
69/16/01domingo23:25:47Correo61022238470:01:2623:27:13$ 0.05
79/16/01domingo23:43:20Correo61022238470:02:1023:45:30$ 0.05
89/16/01domingo23:46:29Internet61022276381:00:020:46:31$ 0.05
99/16/01domingo10:11:37Urbanas46606710:05:0810:16:45$ 0.09
109/16/01domingo22:21:51Inter-Urb35142688880:05:0022:26:51$ 2.31
119/17/01lunes22:28:17Correo61022238470:01:5722:30:14$ 0.05
129/17/01lunes23:21:59Correo61022238470:01:5423:23:53$ 0.05
139/17/01lunes9:14:50Urbanas46948980:00:099:14:59$ 0.05
149/17/01lunes19:08:07Celular1550700590:08:2319:16:30$ 0.23
159/17/01lunes20:55:07Internet61022276381:04:0221:59:09$ 0.47
169/18/01martes17:59:08Correo61022238470:03:1818:02:26$ 0.09
179/18/01martes18:15:50Correo61022238470:01:0518:16:55$ 0.05
189/18/01martes18:17:45Correo61022238470:00:5018:18:35$ 0.05
199/18/01martes22:56:18Internet61022276381:05:560:02:14$ 0.47
209/18/01martes8:58:14Urbanas46948980:00:088:58:22$ 0.05
219/18/01martes20:08:33Celular1550700590:01:0320:09:36$ 0.05
229/18/01martes20:28:27Celular1550700590:00:3920:29:06$ 0.05
239/19/01miercoles7:53:57Correo61022238470:05:447:59:41$ 0.09
249/19/01miercoles8:19:33Correo61022238470:07:148:26:47$ 0.19
259/19/01miercoles21:43:26Correo61022238470:03:5621:47:22$ 0.05
269/19/01miercoles21:53:26Correo61022238470:01:4521:55:11$ 0.05
279/19/01miercoles22:44:00Internet61022276382:00:510:44:51$ 0.80
289/19/01miercoles9:03:09Urbanas46948980:00:079:03:16$ 0.05
299/19/01miercoles19:59:23Celular1550700590:01:5320:01:16$ 0.05
309/19/01miercoles22:20:56Inter-Urb35142688880:10:1022:31:06$ 4.69
319/20/01jueves19:12:50Internet61022276380:13:0219:25:52$ 0.33
329/20/01jueves22:49:43Correo61022238470:27:0323:16:46$ 0.19
339/20/01jueves23:35:35Correo61022238470:01:1523:36:50$ 0.05
349/20/01jueves8:36:30Urbanas46948980:00:068:36:36$ 0.05
359/20/01jueves12:27:05Urbanas46020960:00:4912:27:54$ 0.05
369/20/01jueves19:40:59Urbanas45396950:00:3719:41:36$ 0.05
379/20/01jueves20:06:15Celular1550700590:01:5020:08:05$ 0.05
389/21/01viernes9:21:25Correo61022238470:01:139:22:38$ 0.05
399/21/01viernes18:43:05Correo61022238470:01:1518:44:20$ 0.05
409/21/01viernes9:08:21Urbanas46948980:00:079:08:28$ 0.05
419/21/01viernes9:13:34Urbanas46938810:00:459:14:19$ 0.05
429/21/01viernes18:39:20Urbanas46948980:00:1018:39:30$ 0.05
439/21/01viernes21:05:35Urbanas46606710:00:5921:06:34$ 0.05
449/21/01viernes18:31:22Internet61022276380:02:4218:34:04$ 0.09
459/22/01sabado15:28:24Urbanas46606710:01:0715:29:31$ 0.05
469/22/01sabado19:07:03Urbanas46938810:04:5819:12:01$ 0.09
479/22/01sabado19:22:41Urbanas46605710:00:1119:22:52$ 0.05
489/22/01sabado19:23:22Urbanas46606710:01:3419:24:56$ 0.05
499/22/01sabado19:27:33Urbanas46606710:00:1519:27:48$ 0.05
509/23/01domingo20:16:13Internet61022276381:50:1022:06:23$ 0.75
519/23/01domingo22:25:50Correo61022238470:00:5822:26:48$ 0.05
529/23/01domingo22:27:12Correo61022238470:01:0022:28:12$ 0.05
539/23/01domingo22:31:12Correo61022238470:01:0022:32:12$ 0.05
549/23/01domingo22:32:36Correo61022238470:13:2522:46:01$ 0.19
559/23/01domingo11:24:48Urbanas46938810:10:0411:34:52$ 0.14
569/23/01domingo22:07:05Celular1550700590:03:2422:10:29$ 0.05
579/24/01lunes7:44:21Correo61022238470:15:267:59:47$ 0.19
589/24/01lunes18:00:48Correo61022238470:12:5618:13:44$ 0.33
599/24/01lunes20:41:42Internet61022276380:00:3320:42:15$ 0.05
609/24/01lunes20:45:47Internet61022276380:08:3520:54:22$ 0.14
619/24/01lunes22:33:00Correo61022238470:26:1722:59:17$ 0.19
629/24/01lunes9:12:38Urbanas46948980:00:089:12:46$ 0.05
639/24/01lunes15:04:30Celular1550113120:00:1815:04:48$ 0.05
649/24/01lunes20:31:09Urbanas46938810:06:4920:37:58$ 0.09
659/24/01lunes21:59:49Celular1550700590:05:3922:05:28$ 0.09
669/25/01martes8:57:12Correo61022238470:15:229:12:34$ 0.38
679/25/01martes16:09:25Correo61022238470:01:5416:11:19$ 0.05
689/25/01martes23:36:56Correo61022238470:04:4823:41:44$ 0.09
699/25/01martes9:12:51Urbanas46948980:00:079:12:58$ 0.05
709/25/01martes11:26:32Urbanas46020960:00:4011:27:12$ 0.05
719/25/01martes11:44:21Urbanas46938810:00:1311:44:34$ 0.05
729/25/01martes15:17:16Celular1550113120:00:3415:17:50$ 0.05
739/25/01martes20:47:57Celular1550700590:05:3820:53:35$ 0.09
749/25/01martes23:56:19Urbanas46948980:00:0923:56:28$ 0.05
759/26/01miercoles0:12:54Correo61022238470:08:470:21:41$ 0.14
769/26/01miercoles9:24:36Correo61022238470:27:369:52:12$ 0.38
779/26/01miercoles18:26:21Correo61022238470:33:0318:59:24$ 0.47
789/26/01miercoles20:55:34Internet61022276380:00:3320:56:07$ 0.05
799/26/01miercoles20:56:31Internet61022276381:05:5522:02:26$ 0.47
809/26/01miercoles23:33:41Internet61022276380:00:3323:34:14$ 0.05
819/26/01miercoles23:34:38Internet61022276381:26:281:01:06$ 0.56
829/26/01miercoles0:04:08Celular1550700590:00:430:04:51$ 0.05
839/26/01miercoles9:12:24Urbanas46948980:00:079:12:31$ 0.05
849/26/01miercoles11:35:23Urbanas46020960:02:1911:37:42$ 0.09
859/26/01miercoles19:52:50Celular1550700590:01:1019:54:00$ 0.05
869/26/01miercoles23:02:29Urbanas46948980:00:0823:02:37$ 0.05
879/27/01jueves1:01:50Correo61022238470:03:371:05:27$ 0.05
889/27/01jueves7:49:38Correo61022238470:00:467:50:24$ 0.05
899/27/01jueves13:30:11Correo61022238470:00:5113:31:02$ 0.05
909/27/01jueves13:32:47Correo61022238470:01:2113:34:08$ 0.05
919/27/01jueves23:10:53Correo61022238470:17:2823:28:21$ 0.19
929/27/01jueves9:19:07Urbanas46948980:00:079:19:14$ 0.05
939/27/01jueves10:20:27Urbanas46948980:00:1010:20:37$ 0.05
949/27/01jueves19:55:43Celular1550700590:02:3819:58:21$ 0.09
959/27/01jueves20:44:13Urbanas48318140:02:4820:47:01$ 0.05
969/27/01jueves22:04:38Urbanas48318140:01:4622:06:24$ 0.05
979/27/01jueves22:28:38Urbanas46948980:00:1322:28:51$ 0.05
989/28/01viernes17:12:53Correo61022238470:01:2217:14:15$ 0.05
999/28/01viernes17:15:05Correo61022238470:00:5517:16:00$ 0.05
1009/28/01viernes17:55:15Correo61022238470:03:4517:59:00$ 0.09
1019/28/01viernes11:41:20Urbanas46938810:08:4511:50:05$ 0.23
1029/29/01sabado10:02:37Urbanas46948980:00:0810:02:45$ 0.05
1039/29/01sabado13:30:25Urbanas46938810:06:3413:36:59$ 0.09
1049/30/01domingo17:18:49Correo61022238470:03:3017:22:19$ 0.05
1059/30/01domingo23:37:37Internet61022276380:28:410:06:18$ 0.19
1069/30/01domingo9:52:21Urbanas46938810:06:389:58:59$ 0.09
1079/30/01domingo10:52:50Urbanas46606710:07:4711:00:37$ 0.09
1089/30/01domingo20:38:39Celular1550113120:01:4020:40:19$ 0.05
1099/30/01domingo21:04:45Urbanas46938810:00:1821:05:03$ 0.05
1109/30/01domingo20:43:18Inter-Urb23224296220:14:3220:57:50$ 1.42
11110/1/01lunes7:41:11Correo61022238470:00:467:41:57$ 0.05
11210/1/01lunes9:10:00Correo61022238470:00:489:10:48$ 0.05
11310/1/01lunes9:12:01Correo61022238470:00:589:12:59$ 0.05
11410/1/01lunes20:57:31Correo61022238470:00:5120:58:22$ 0.05
11510/1/01lunes8:51:45Urbanas46948980:00:078:51:52$ 0.05
11610/1/01lunes10:00:49Urbanas46938810:06:2610:07:15$ 0.19
11710/1/01lunes19:11:20Urbanas46938810:00:5619:12:16$ 0.05
11810/1/01lunes21:59:32Urbanas46938810:01:5422:01:26$ 0.05
11910/1/01lunes22:06:38Urbanas45718620:03:1622:09:54$ 0.05
12010/1/01lunes19:38:34Inter-Urb114325502610:00:3319:39:07$ 0.09
12110/1/01lunes23:25:02Inter-Urb114325502610:18:1223:43:14$ 2.22
12210/2/01martes0:35:33Correo61022238470:05:550:41:28$ 0.09
12310/2/01martes20:16:49Correo61022238470:22:1420:39:03$ 0.19
12410/2/01martes9:03:55Urbanas46948980:00:089:04:03$ 0.05
12510/2/01martes12:03:24Urbanas46938810:08:3512:11:59$ 0.23
12610/2/01martes19:49:21Urbanas46938810:06:2119:55:42$ 0.19
12710/2/01martes20:44:15Urbanas45718620:02:1520:46:30$ 0.05
12810/3/01miercoles20:47:15Internet61022276380:00:3920:47:54$ 0.05
12910/3/01miercoles20:48:41Internet61022276380:00:4520:49:26$ 0.05
13010/3/01miercoles20:50:28Internet61022276380:00:3920:51:07$ 0.05
13110/3/01miercoles20:51:53Internet61022276380:00:3920:52:32$ 0.05
13210/3/01miercoles20:53:27Internet61022276380:00:3920:54:06$ 0.05
13310/3/01miercoles20:55:17Internet61022276380:00:3920:55:56$ 0.05
13410/3/01miercoles20:56:56Internet61022276380:00:3920:57:35$ 0.05
13510/3/01miercoles21:00:10Internet61022276380:00:2521:00:35$ 0.05
13610/3/01miercoles21:02:21Internet61022276380:00:2721:02:48$ 0.05
13710/3/01miercoles21:03:27Internet61022276380:00:2521:03:52$ 0.05
13810/3/01miercoles21:05:12Internet61022276380:00:2621:05:38$ 0.05
13910/3/01miercoles21:06:35Internet61022276380:00:2621:07:01$ 0.05
14010/3/01miercoles21:07:52Internet61022276380:00:2621:08:18$ 0.05
14110/3/01miercoles21:09:06Correo61022238471:01:1222:10:18$ 0.05
14210/3/01miercoles9:16:20Urbanas46948980:00:069:16:26$ 0.05
14310/3/01miercoles12:50:01Urbanas42597000:01:2212:51:23$ 0.05
14410/4/01jueves7:41:46Internet61022276380:04:407:46:26$ 0.09
14510/4/01jueves20:18:10Internet61022276380:21:3320:39:43$ 0.19
14610/4/01jueves21:53:52Internet61022276380:33:3222:27:24$ 0.23
14710/4/01jueves9:10:55Urbanas46948980:00:089:11:03$ 0.05
14810/4/01jueves9:15:23Urbanas46938810:00:029:15:25$ 0.05
14910/4/01jueves10:20:58Urbanas46938810:08:5910:29:57$ 0.23
15010/4/01jueves20:40:45Inter-Urb114325502610:02:1220:42:57$ 0.36
15110/4/01jueves23:19:14Inter-Urb114325502610:06:3323:25:47$ 0.80
15210/5/01viernes0:04:37Correo61022238470:40:290:45:06$ 0.33
15310/5/01viernes18:07:13Correo61022238470:27:4118:34:54$ 0.38
15410/5/01viernes9:18:24Urbanas46948980:00:069:18:30$ 0.05
15510/5/01viernes17:21:03Urbanas46938810:08:3217:29:35$ 0.23
15610/5/01viernes17:41:13Urbanas42326680:01:1417:42:27$ 0.05
15710/30/01martes7:41:29Correo61022238470:02:277:43:56$ 0.05
15810/30/01martes8:00:44Correo61022238470:05:508:06:34$ 0.14
15910/30/01martes8:10:23Correo61022238470:15:028:25:25$ 0.38
16010/30/01martes16:52:10Inernert61022276380:02:5116:55:01$ 0.09
16110/30/01martes20:44:35Inernert61022276380:40:1021:24:45$ 0.33
16210/30/01martes22:21:32Inernert61022276380:01:3822:23:10$ 0.05
16310/30/01martes23:22:15Correo61022238470:06:2423:28:39$ 0.09
16410/30/01martes23:45:21Correo61022238470:06:3823:51:59$ 0.09
16510/31/01miercoles8:09:48Correo61022238470:04:388:14:26$ 0.14
16610/31/01miercoles20:45:57Inernert61022276380:01:1120:47:08$ 0.05
16710/31/01miercoles20:49:47Inernert61022276380:47:4021:37:27$ 0.38
16810/31/01miercoles21:43:09Inernert61022276380:00:3321:43:42$ 0.05
16910/31/01miercoles21:44:06Inernert61022276380:00:3921:44:45$ 0.05
17010/31/01miercoles21:47:14Inernert61022276380:00:3521:47:49$ 0.05
17110/31/01miercoles21:48:19Inernert61022276380:00:2621:48:45$ 0.05
17210/31/01miercoles21:51:52Inernert61022276380:00:3121:52:23$ 0.05
17310/31/01miercoles21:56:56Inernert61022276380:28:2122:25:17$ 0.19
17410/31/01miercoles23:12:29Correo61022238470:01:3223:14:01$ 0.05
17510/31/01miercoles23:28:01Correo61022238470:02:2323:30:24$ 0.05
17610/5/01viernes19:26:07Urbanas46948980:00:0819:26:15$ 0.05
17710/5/01viernes21:34:39Urbanas42923150:00:1621:34:55$ 0.05
17810/5/01viernes21:46:17Urbanas46606710:03:5921:50:16$ 0.05
17910/6/01sabado15:21:45Urbanas46606710:00:3815:22:23$ 0.05
18010/6/01sabado17:52:35Urbanas46606710:07:5118:00:26$ 0.09
18110/6/01sabado19:37:46Urbanas46938820:00:1019:37:56$ 0.05
18210/6/01sabado19:42:36Urbanas46938810:08:1119:50:47$ 0.14
18310/8/01lunes18:00:49Correo61022238470:13:4418:14:33$ 0.19
18410/8/01lunes18:33:26Internet61022276380:28:4519:02:11$ 0.19
18510/8/01lunes21:22:52Internet61022276380:29:1621:52:08$ 0.19
18610/8/01lunes23:24:11Correo61022238470:14:1523:38:26$ 0.19
18710/8/01lunes8:41:23Urbanas46606710:02:168:43:39$ 0.05
18810/9/01martes7:08:38Correo61022238471:02:558:11:33$ 0.42
18910/9/01martes23:19:58Correo61022238470:19:4723:39:45$ 0.19
19010/9/01martes23:54:23Correo61022238470:09:500:04:13$ 0.14
19110/9/01martes0:33:02Urbanas48033810:00:590:34:01$ 0.05
19210/9/01martes9:19:59Urbanas46948980:00:079:20:06$ 0.05
19310/9/01martes9:54:06Urbanas46020960:01:219:55:27$ 0.05
19410/9/01martes12:58:06Urbanas46020960:02:5613:01:02$ 0.09
19510/9/01martes19:11:41Urbanas48033810:02:2819:14:09$ 0.09
19610/9/01martes19:41:47Urbanas48033810:00:5619:42:43$ 0.05
19710/10/01miercoles20:32:46Internet61022276381:42:2322:15:09$ 0.75
19810/10/01miercoles23:32:28Correo61022238470:09:4723:42:15$ 0.14
19910/10/01miercoles23:56:02Correo61022238470:03:3623:59:38$ 0.05
20010/10/01miercoles8:02:09Urbanas45718620:02:428:04:51$ 0.09
20110/10/01miercoles8:33:31Urbanas46948980:00:078:33:38$ 0.05
20210/10/01miercoles9:54:39Urbanas42326680:01:279:56:06$ 0.05
20310/10/01miercoles9:56:29Celular1550113120:00:529:57:21$ 0.05
20410/10/01miercoles11:36:16Urbanas48033810:00:1211:36:28$ 0.05
20510/10/01miercoles12:32:04Urbanas48033810:04:3512:36:39$ 0.14
20610/11/01jueves0:20:51Correo61022238470:00:490:21:40$ 0.05
20710/11/01jueves20:43:22Internet61022276380:36:0721:19:29$ 0.28
20810/11/01jueves21:20:22Internet61022276380:28:2121:48:43$ 0.19
20910/11/01jueves21:56:19Internet61022276380:13:2022:09:39$ 0.19
21010/11/01jueves23:28:02Correo61022238470:47:440:15:46$ 0.38
21110/11/01jueves8:37:54Urbanas46948980:00:068:38:00$ 0.05
21210/11/01jueves11:05:01Urbanas48033810:00:4511:05:46$ 0.05
21310/11/01jueves18:13:59Urbanas46948980:00:1718:14:16$ 0.05
21410/11/01jueves21:49:50Celular1545598690:05:4121:55:31$ 0.09
21510/12/01viernes7:03:53Correo61022238471:09:298:13:22$ 0.52
21610/12/01viernes8:59:42Correo61022238471:01:2810:01:10$ 0.80
21710/12/01viernes17:11:46Correo61022238470:03:2117:15:07$ 0.09
21810/12/01viernes17:22:16Correo61022238470:00:5917:23:15$ 0.05
21910/12/01viernes17:24:40Correo61022238470:00:4117:25:21$ 0.05
22010/12/01viernes17:27:13Correo61022238470:00:3517:27:48$ 0.05
22110/12/01viernes17:30:35Correo61022238470:02:1117:32:46$ 0.09
22210/12/01viernes17:36:08Correo61022238470:01:1217:37:20$ 0.05
22310/12/01viernes18:43:50Internet61022276380:00:3318:44:23$ 0.05
22410/12/01viernes18:44:47Internet61022276380:15:1018:59:57$ 0.38
22510/12/01viernes8:38:23Urbanas46948980:00:068:38:29$ 0.05
22610/12/01viernes10:28:41Urbanas48033810:00:3610:29:17$ 0.05
22710/12/01viernes18:19:52Urbanas48033810:03:0518:22:57$ 0.09
22810/13/01sabado13:15:59Urbanas48033810:01:2413:17:23$ 0.05
22910/13/01sabado13:18:33Urbanas46606710:03:2213:21:55$ 0.05
23010/13/01sabado15:12:56Urbanas48336700:00:0215:12:58$ 0.05
23110/13/01sabado16:10:57Urbanas46948980:00:1016:11:07$ 0.05
23210/13/01sabado19:05:34Urbanas46606710:05:4919:11:23$ 0.09
23310/14/01domingo19:35:17Correo61022238470:01:0519:36:22$ 0.05
23410/14/01domingo19:36:40Correo61022238470:00:5119:37:31$ 0.05
23510/14/01domingo22:06:29Internet61022276380:22:5622:29:25$ 0.19
23610/14/01domingo10:10:20Urbanas45718620:01:0010:11:20$ 0.05
23710/14/01domingo16:08:26Urbanas46948980:00:2016:08:46$ 0.05
23810/14/01domingo16:55:21Urbanas46158590:18:3917:14:00$ 0.23
23910/15/01lunes0:42:22Correo61022238470:00:480:43:10$ 0.05
24010/15/01lunes8:31:51Correo61022238470:20:078:51:58$ 0.38
24110/15/01lunes21:59:11Internet61022276380:07:2722:06:38$ 0.09
24210/15/01lunes23:18:18Correo61022238470:10:3923:28:57$ 0.14
24310/15/01lunes23:57:57Correo61022238470:00:4523:58:42$ 0.05
24410/15/01lunes8:55:28Urbanas46948980:00:118:55:39$ 0.05
24510/16/01martes22:13:58Correo61022238470:06:1822:20:16$ 0.09
24610/16/01martes22:41:31Internet61022276381:59:550:41:26$ 0.75
24710/16/01martes8:50:29Urbanas46948980:00:078:50:36$ 0.05
24810/16/01martes17:53:27Urbanas46938810:04:5417:58:21$ 0.14
24910/17/01miercoles23:15:43Correo61022238470:07:5223:23:35$ 0.09
25010/17/01miercoles23:41:23Correo61022238470:01:0023:42:23$ 0.05
25110/17/01miercoles23:42:42Correo61022238470:01:0723:43:49$ 0.05
25210/17/01miercoles8:42:26Urbanas46949980:00:028:42:28$ 0.05
25310/17/01miercoles8:42:49Urbanas46948980:00:078:42:56$ 0.05
25410/17/01miercoles9:38:21Urbanas46020960:01:539:40:14$ 0.05
25510/17/01miercoles9:40:32Urbanas46020960:01:089:41:40$ 0.05
25610/17/01miercoles10:27:47Urbanas46938810:00:0510:27:52$ 0.05
25710/17/01miercoles11:17:14Urbanas46938810:00:0411:17:18$ 0.05
25810/17/01miercoles12:45:32Urbanas46938810:03:0512:48:37$ 0.09
25910/17/01miercoles21:54:35Urbanas46938810:01:0321:55:38$ 0.05
26010/17/01miercoles22:10:19Urbanas45718620:01:5022:12:09$ 0.05
26110/18/01jueves0:03:28Internet61022276380:08:430:12:11$ 0.14
26210/18/01jueves21:41:45Internet61022276380:01:0021:42:45$ 0.05
26310/18/01jueves21:43:18Internet61022276380:45:4422:29:02$ 0.38
26410/18/01jueves23:27:27Correo61022238470:49:060:16:33$ 0.38
26510/18/01jueves8:41:42Urbanas46948980:00:078:41:49$ 0.05
26610/18/01jueves11:19:48Urbanas42176850:04:5311:24:41$ 0.14
26710/18/01jueves11:27:34Celular1550646060:00:0711:27:41$ 0.05
26810/18/01jueves19:16:49Urbanas45136600:02:0319:18:52$ 0.09
26910/19/01viernes7:26:25Correo61022238470:14:407:41:05$ 0.19
27010/19/01viernes18:01:51Internet61022276380:00:3318:02:24$ 0.05
27110/19/01viernes18:02:48Internet61022276380:21:5618:24:44$ 0.38
27210/19/01viernes18:38:35Correo61022238470:12:0618:50:41$ 0.33
27310/19/01viernes8:58:17Urbanas46948980:00:108:58:27$ 0.05
27410/19/01viernes21:42:25Urbanas46948980:00:1021:42:35$ 0.05
27510/19/01viernes22:30:21Urbanas46606710:01:0922:31:30$ 0.05
27610/20/01sabado8:44:47Urbanas46938810:06:488:51:35$ 0.19
27710/20/01sabado20:11:34Urbanas46938810:04:1720:15:51$ 0.09
27810/21/01domingo19:07:39Correo61022238470:03:5819:11:37$ 0.05
27910/21/01domingo21:24:07Internet61022276380:16:1621:40:23$ 0.19
28010/21/01domingo9:52:56Urbanas46938810:03:499:56:45$ 0.05
28110/21/01domingo16:23:16Urbanas48001190:00:1516:23:31$ 0.05
28210/21/01domingo17:44:12Urbanas46606710:01:2117:45:33$ 0.05
28310/21/01domingo19:39:37Urbanas46938810:01:5219:41:29$ 0.05
28410/22/01lunes7:35:33Correo61022238470:01:097:36:42$ 0.05
28510/22/01lunes20:33:23Internet61022276380:00:5720:34:20$ 0.05
28610/22/01lunes20:35:56Internet61022276380:01:2120:37:17$ 0.05
28710/22/01lunes20:37:44Internet61022276380:01:2220:39:06$ 0.05
28810/22/01lunes20:42:48Internet61022276381:23:5622:06:44$ 0.56
28910/22/01lunes22:07:28Correo61022238470:17:2222:24:50$ 0.19
29010/22/01lunes22:38:09Correo61022238470:01:0522:39:14$ 0.05
29110/22/01lunes23:21:27Correo61022238470:01:4423:23:11$ 0.05
29210/22/01lunes11:18:37Urbanas46938810:03:4711:22:24$ 0.09
29310/22/01lunes13:30:52Urbanas45718620:01:5213:32:44$ 0.05
29410/22/01lunes14:01:09Celular1545598690:03:3814:04:47$ 0.09
29510/22/01lunes17:32:41Urbanas48344200:38:1618:10:57$ 0.94
29610/22/01lunes19:39:58Inter-Urb35142688880:00:5519:40:53$ 0.52
29710/23/01martes18:37:15Internet61022276380:05:4518:43:00$ 0.14
29810/23/01martes22:52:25Internet61022276380:06:3422:58:59$ 0.09
29910/23/01martes22:59:42Correo61022238470:01:0623:00:48$ 0.05
30010/23/01martes7:55:20Urbanas45300030:05:488:01:08$ 0.09
30110/23/01martes9:06:53Urbanas46948980:00:069:06:59$ 0.05
30210/23/01martes10:26:51Urbanas42143010:00:0910:27:00$ 0.05
30310/23/01martes12:22:01Urbanas42143010:05:1512:27:16$ 0.14
30410/23/01martes18:32:44Urbanas46948980:00:1318:32:57$ 0.05
30510/24/01miercoles0:15:14Correo61022238470:01:100:16:24$ 0.05
30610/24/01miercoles0:29:10Correo61022238470:00:490:29:59$ 0.05
30710/24/01miercoles20:55:05Internet61022276381:40:1822:35:23$ 0.70
30810/24/01miercoles23:19:12Correo61022238470:30:2523:49:37$ 0.23
30910/24/01miercoles8:05:43Urbanas46948980:00:088:05:51$ 0.05
31010/24/01miercoles11:49:52Urbanas48243720:25:2012:15:12$ 0.61
31110/24/01miercoles20:32:16Urbanas46605870:01:3320:33:49$ 0.05
31210/24/01miercoles20:45:07Urbanas48266230:03:0420:48:11$ 0.05
31310/24/01miercoles20:48:40Urbanas42471330:00:4720:49:27$ 0.05
31410/24/01miercoles20:49:57Urbanas46925290:00:4620:50:43$ 0.05
31510/24/01miercoles22:36:36Inter-Urb35142688880:10:0622:46:42$ 4.66
31610/25/01jueves7:13:07Correo61022238471:11:008:24:07$ 0.52
31710/25/01jueves20:34:16Internet61022276381:38:5822:13:14$ 0.70
31810/25/01jueves9:02:28Urbanas46948980:00:079:02:35$ 0.05
31910/25/01jueves10:59:23Urbanas46938810:00:0110:59:24$ 0.05
32010/25/01jueves13:00:23Urbanas46938810:06:1213:06:35$ 0.19
32110/25/01jueves15:36:47Urbanas42326680:04:4015:41:27$ 0.14
32210/26/01viernes7:07:02Correo61022238470:17:287:24:30$ 0.19
32310/26/01viernes18:23:28Correo61022238470:10:4018:34:08$ 0.28
32410/26/01viernes9:24:30Urbanas46948980:00:069:24:36$ 0.05
32510/26/01viernes10:40:41Urbanas46938810:00:0410:40:45$ 0.05
32610/27/01sabado8:32:29Urbanas46938810:10:538:43:22$ 0.28
32710/28/01domingo18:41:12Correo61022238470:08:1318:49:25$ 0.14
32810/28/01domingo20:00:24Correo61022238470:00:4820:01:12$ 0.05
32910/28/01domingo20:06:56Internet61022276381:13:3021:20:26$ 0.56
33010/28/01domingo8:22:45Urbanas46606710:04:048:26:49$ 0.09
33110/28/01domingo8:52:55Urbanas46938810:06:218:59:16$ 0.09
33210/28/01domingo16:53:03Urbanas46606710:00:5416:53:57$ 0.05
33310/28/01domingo17:01:48Urbanas46938810:07:5617:09:44$ 0.09
33410/28/01domingo21:48:16Urbanas45718620:00:4421:49:00$ 0.05
33510/28/01domingo22:27:02Urbanas46938810:01:2622:28:28$ 0.05
33610/29/01lunes8:28:13Correo61022238470:01:248:29:37$ 0.05
33710/29/01lunes20:31:44Internet61022276381:28:5022:00:34$ 0.56
33810/29/01lunes22:48:51Correo61022238470:21:0323:09:54$ 0.19
33910/29/01lunes23:15:48Correo61022238470:00:5923:16:47$ 0.05
34010/29/01lunes23:17:17Correo61022238470:02:4023:19:57$ 0.05
34110/29/01lunes23:21:05Correo61022238470:02:0423:23:09$ 0.05
34210/29/01lunes9:11:27Urbanas46948980:00:079:11:34$ 0.05
34310/29/01lunes11:23:34Urbanas46938810:05:0311:28:37$ 0.14
34410/30/01martes8:46:43Urbanas46948980:00:068:46:49$ 0.05
34510/30/01martes12:15:21Urbanas46938810:10:1512:25:36$ 0.28
34610/30/01martes16:00:27Urbanas46948980:00:1616:00:43$ 0.05
34710/30/01martes16:03:14Urbanas46016150:00:1616:03:30$ 0.05
34810/30/01martes16:03:53Urbanas46948980:00:0916:04:02$ 0.05
34910/30/01martes18:36:31Urbanas46938810:08:5018:45:21$ 0.23
35010/31/01miercoles10:36:17Urbanas46948980:00:0710:36:24$ 0.05
35110/31/01miercoles20:32:47Urbanas48266230:00:4820:33:35$ 0.05
35210/31/01miercoles20:35:01Urbanas46925290:01:3120:36:32$ 0.05
35310/31/01miercoles20:37:21Urbanas42471230:00:3020:37:51$ 0.05
35410/31/01miercoles20:47:49Urbanas42326680:01:0020:48:49$ 0.05
35511/1/01jueves8:11:54Correo61022238470:00:448:12:38$ 0.05
35611/1/01jueves8:24:58Correo61022238470:00:518:25:49$ 0.05
35711/1/01jueves8:45:26Correo61022238470:18:409:04:06$ 0.38
35811/1/01jueves18:26:42Internet61022276380:01:1118:27:53$ 0.05
35911/1/01jueves18:31:22Internet61022276380:02:4218:34:04$ 0.09
36011/1/01jueves20:36:51Internet61022276381:42:4822:19:39$ 0.75
36111/1/01jueves23:37:54Correo61022238470:07:2523:45:19$ 0.09
36211/1/01jueves9:05:13Urbanas46938810:00:389:05:51$ 0.05
36311/1/01jueves18:29:41Urbanas46948980:00:1818:29:59$ 0.05
36411/1/01jueves20:33:18Urbanas45718620:03:0220:36:20$ 0.05
36511/2/01viernes0:27:05Correo61022238470:00:500:27:55$ 0.05
36611/2/01viernes1:17:29Correo61022238470:00:521:18:21$ 0.05
36711/2/01viernes17:26:32Correo61022238470:07:5817:34:30$ 0.19
36811/2/01viernes17:46:21Internet61022276380:14:5218:01:13$ 0.38
36911/2/01viernes9:09:50Urbanas46948980:00:139:10:03$ 0.13
37011/2/01viernes11:29:38Urbanas46938810:05:0311:34:41$ 0.14
37111/2/01viernes11:36:27Urbanas48437620:01:3211:37:59$ 0.05
37211/2/01viernes19:45:01Urbanas46938810:04:0419:49:05$ 0.14
37311/2/01viernes20:38:31Urbanas42923150:00:1620:38:47$ 0.05
37411/2/01viernes20:39:37Urbanas42922890:00:5520:40:32$ 0.05
37511/2/01viernes20:45:00Urbanas46606710:01:1920:46:19$ 0.05
37611/4/01domingo19:42:24Correo61022238470:07:0319:49:27$ 0.09
37711/4/01domingo22:56:46Correo61022238470:01:1022:57:56$ 0.05
37811/4/01domingo23:12:15Correo61022238470:01:3923:13:54$ 0.05
37911/4/01domingo10:14:16Urbanas46938810:02:2910:16:45$ 0.05
38011/4/01domingo11:30:41Urbanas46606710:00:3611:31:17$ 0.05
38111/5/01lunes8:09:40Correo61022238470:09:448:19:24$ 0.23
38211/5/01lunes20:34:52Internet61022276380:50:3721:25:29$ 0.38
38311/5/01lunes21:26:16Internet61022276381:13:5622:40:12$ 0.56
38411/5/01lunes23:25:39Correo61022238470:02:3323:28:12$ 0.05
38511/5/01lunes23:45:15Internet61022276381:00:060:45:21$ 0.42
38611/5/01lunes7:57:23Urbanas46948490:00:077:57:30$ 0.05
38711/5/01lunes7:58:00Urbanas46948980:00:087:58:08$ 0.05
38811/5/01lunes16:59:51Urbanas46938810:04:4917:04:40$ 0.14
38911/5/01lunes20:03:28Celular1545598690:06:0820:09:36$ 0.09
39011/5/01lunes20:19:37Urbanas42173820:09:3520:29:12$ 0.14
39111/6/01martes20:31:21Internet61022276381:14:0221:45:23$ 0.56
39211/6/01martes23:12:39Correo61022238470:03:4423:16:23$ 0.05
39311/6/01martes23:58:48Correo61022238470:23:020:21:50$ 0.19
39411/6/01martes13:06:57Celular1550113120:00:0913:07:06$ 0.05
39511/6/01martes14:42:51Celular1550127750:02:3514:45:26$ 0.09
39611/6/01martes16:54:17Urbanas46938810:05:2016:59:37$ 0.14
39711/7/01miercoles1:36:26Correo61022238470:00:461:37:12$ 0.05
39811/7/01miercoles1:57:21Correo61022238470:00:431:58:04$ 0.05
39911/7/01miercoles20:28:22Correo61022238470:07:1720:35:39$ 0.09
40011/7/01miercoles22:56:30Internet61022276380:00:3422:57:04$ 0.05
40111/7/01miercoles22:57:28Internet61022276380:02:4323:00:11$ 0.05
40211/7/01miercoles8:09:33Urbanas46948980:00:078:09:40$ 0.05
40311/7/01miercoles11:19:34Urbanas46938810:11:2511:30:59$ 0.28
40411/7/01miercoles20:56:34Celular1550127750:00:1220:56:46$ 0.05
40511/7/01miercoles20:57:22Celular1550127750:13:3221:10:54$ 0.19
40611/7/01miercoles21:36:37Urbanas45215290:46:5522:23:32$ 0.56
40711/8/01jueves20:35:34Internet61022276381:20:0521:55:39$ 0.56
40811/8/01jueves23:07:22Correo61022238470:11:3123:18:53$ 0.14
40911/8/01jueves23:43:30Correo61022238470:00:5023:44:20$ 0.05
41011/8/01jueves23:48:26Internet61022276380:50:460:39:12$ 0.38
41111/8/01jueves8:44:00Urbanas46948980:00:068:44:06$ 0.05
41211/8/01jueves10:28:45Urbanas45106530:00:2510:29:10$ 0.05
41311/8/01jueves12:29:18Celular1550113120:01:2712:30:45$ 0.05
41411/8/01jueves16:36:58Urbanas46948980:00:1416:37:12$ 0.05
41511/8/01jueves18:24:30Urbanas46931690:07:4718:32:17$ 0.19
41611/8/01jueves18:32:47Urbanas46938810:01:1518:34:02$ 0.05
41711/8/01jueves18:35:05Urbanas42209030:03:0818:38:13$ 0.09
41811/8/01jueves23:22:42Celular1550127750:02:1523:24:57$ 0.05
41911/9/01viernes8:07:15Correo61022238470:00:438:07:58$ 0.05
42011/9/01viernes16:56:42Correo61022238470:32:1917:29:01$ 0.47
42111/9/01viernes9:06:49Urbanas46948980:00:099:06:58$ 0.05
42211/9/01viernes9:42:41Urbanas46938810:00:039:42:44$ 0.05
42311/9/01viernes10:05:45Urbanas46938810:08:1310:13:58$ 0.23
42411/9/01viernes21:18:15Urbanas46948980:00:0721:18:22$ 0.05
42511/10/01sabado9:53:54Urbanas46606710:06:1810:00:12$ 0.19
42611/10/01sabado18:21:30Urbanas46938810:10:4718:32:17$ 0.14
42711/11/01domingo19:15:11Correo61022238470:04:2819:19:39$ 0.09
42811/11/01domingo20:23:02Correo61022238470:01:0720:24:09$ 0.05
42911/11/01domingo20:24:40Correo61022238470:09:0920:33:49$ 0.14
43011/11/01domingo21:52:50Correo61022238470:04:2321:57:13$ 0.09
43111/11/01domingo21:58:00Internet61022276380:11:2322:09:23$ 0.14
43211/11/01domingo11:06:42Urbanas46606710:00:5511:07:37$ 0.05
43311/11/01domingo18:06:47Urbanas46938810:00:1518:07:02$ 0.05
434
435
ABCDEFGHI
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
Hoja4
FechaDia semanaHora inicialDestinoNumeroDuracionHora finalImporte
9/24/01lunes22:33:00Correo61022238470:26:1722:59:170.19
9/24/01lunes18:00:48Correo61022238470:12:5618:13:440.33
9/24/01lunes7:44:21Correo61022238470:15:267:59:470.19
9/17/01lunes23:21:59Correo61022238470:01:5423:23:530.05
9/17/01lunes22:28:17Correo61022238470:01:5722:30:140.05
Hoja5
ABCDEFGH
1FechaDia semanaHora inicialDestinoNumeroDuracionHora finalImporte
29/26/01miercoles18:26:21Correo61022238470:33:0318:59:240.47
39/26/01miercoles9:24:36Correo61022238470:27:369:52:120.38
49/26/01miercoles0:12:54Correo61022238470:08:470:21:410.14
59/19/01miercoles21:53:26Correo61022238470:01:4521:55:110.05
69/19/01miercoles21:43:26Correo61022238470:03:5621:47:220.05
79/19/01miercoles8:19:33Correo61022238470:07:148:26:470.19
89/19/01miercoles7:53:57Correo61022238470:05:447:59:410.09
Hoja6
Fecha(Todas)
Dia semana
DestinoDatoslunesmartesmiercolesjuevesviernessabadodomingoTotal general
CelularContar de Duracion3432214
Suma de Importe0.370.240.150.140.11
CorreoContar de Duracion567751839
Suma de Importe0.810.711.370.630.290.050.544.4
InternetContar de Duracion315111315
Suma de Importe0.660.471.930.330.090.560.995.03
Inter-UrbContar de Duracion123
Suma de Importe4.693.738.42
UrbanasContar de Duracion354858538
Suma de Importe0.190.250.240.40.430.620.462.59
Total Contar de Duracion14162018111020109
Total Suma de Importe2.031.678.381.50.811.235.8221.44
Telefono Word (3)
ABCDEFGH
1FechaDia semanaHora inicialDestinoNumeroDuracionHora finalImporte
29/15/01sabado0:00:04Correo61022238470:00:460:00:50$ 0.05
39/15/01sabado10:42:49Urbanas46938810:06:3610:49:25$ 0.19
49/15/01sabado20:31:44Internet61022276381:28:5022:00:34$ 0.56
59/16/01domingo19:10:44Correo61022238470:03:4619:14:30$ 0.05
69/16/01domingo23:25:47Correo61022238470:01:2623:27:13$ 0.05
79/16/01domingo23:43:20Correo61022238470:02:1023:45:30$ 0.05
89/16/01domingo23:46:29Internet61022276381:00:020:46:31$ 0.05
99/16/01domingo10:11:37Urbanas46606710:05:0810:16:45$ 0.09
109/16/01domingo22:21:51Inter-Urb35142688880:05:0022:26:51$ 2.31
119/17/01lunes22:28:17Correo61022238470:01:5722:30:14$ 0.05
129/17/01lunes23:21:59Correo61022238470:01:5423:23:53$ 0.05
139/17/01lunes9:14:50Urbanas46948980:00:099:14:59$ 0.05
149/17/01lunes19:08:07Celular1550700590:08:2319:16:30$ 0.23
159/17/01lunes20:55:07Internet61022276381:04:0221:59:09$ 0.47
169/18/01martes17:59:08Correo61022238470:03:1818:02:26$ 0.09
179/18/01martes18:15:50Correo61022238470:01:0518:16:55$ 0.05
189/18/01martes18:17:45Correo61022238470:00:5018:18:35$ 0.05
199/18/01martes22:56:18Internet61022276381:05:560:02:14$ 0.47
209/18/01martes8:58:14Urbanas46948980:00:088:58:22$ 0.05
219/18/01martes20:08:33Celular1550700590:01:0320:09:36$ 0.05
229/18/01martes20:28:27Celular1550700590:00:3920:29:06$ 0.05
239/19/01miercoles7:53:57Correo61022238470:05:447:59:41$ 0.09
249/19/01miercoles8:19:33Correo61022238470:07:148:26:47$ 0.19
259/19/01miercoles21:43:26Correo61022238470:03:5621:47:22$ 0.05
269/19/01miercoles21:53:26Correo61022238470:01:4521:55:11$ 0.05
279/19/01miercoles22:44:00Internet61022276382:00:510:44:51$ 0.80
289/19/01miercoles9:03:09Urbanas46948980:00:079:03:16$ 0.05
299/19/01miercoles19:59:23Celular1550700590:01:5320:01:16$ 0.05
309/19/01miercoles22:20:56Inter-Urb35142688880:10:1022:31:06$ 4.69
319/20/01jueves19:12:50Internet61022276380:13:0219:25:52$ 0.33
329/20/01jueves22:49:43Correo61022238470:27:0323:16:46$ 0.19
339/20/01jueves23:35:35Correo61022238470:01:1523:36:50$ 0.05
349/20/01jueves8:36:30Urbanas46948980:00:068:36:36$ 0.05
359/20/01jueves12:27:05Urbanas46020960:00:4912:27:54$ 0.05
369/20/01jueves19:40:59Urbanas45396950:00:3719:41:36$ 0.05
379/20/01jueves20:06:15Celular1550700590:01:5020:08:05$ 0.05
389/21/01viernes9:21:25Correo61022238470:01:139:22:38$ 0.05
399/21/01viernes18:43:05Correo61022238470:01:1518:44:20$ 0.05
409/21/01viernes9:08:21Urbanas46948980:00:079:08:28$ 0.05
419/21/01viernes9:13:34Urbanas46938810:00:459:14:19$ 0.05
429/21/01viernes18:39:20Urbanas46948980:00:1018:39:30$ 0.05
439/21/01viernes21:05:35Urbanas46606710:00:5921:06:34$ 0.05
449/21/01viernes18:31:22Internet61022276380:02:4218:34:04$ 0.09
459/22/01sabado15:28:24Urbanas46606710:01:0715:29:31$ 0.05
469/22/01sabado19:07:03Urbanas46938810:04:5819:12:01$ 0.09
479/22/01sabado19:22:41Urbanas46605710:00:1119:22:52$ 0.05
489/22/01sabado19:23:22Urbanas46606710:01:3419:24:56$ 0.05
499/22/01sabado19:27:33Urbanas46606710:00:1519:27:48$ 0.05
509/23/01domingo20:16:13Internet61022276381:50:1022:06:23$ 0.75
519/23/01domingo22:25:50Correo61022238470:00:5822:26:48$ 0.05
529/23/01domingo22:27:12Correo61022238470:01:0022:28:12$ 0.05
539/23/01domingo22:31:12Correo61022238470:01:0022:32:12$ 0.05
549/23/01domingo22:32:36Correo61022238470:13:2522:46:01$ 0.19
559/23/01domingo11:24:48Urbanas46938810:10:0411:34:52$ 0.14
569/23/01domingo22:07:05Celular1550700590:03:2422:10:29$ 0.05
579/24/01lunes7:44:21Correo61022238470:15:267:59:47$ 0.19
589/24/01lunes18:00:48Correo61022238470:12:5618:13:44$ 0.33
599/24/01lunes20:41:42Internet61022276380:00:3320:42:15$ 0.05
609/24/01lunes20:45:47Internet61022276380:08:3520:54:22$ 0.14
619/24/01lunes22:33:00Correo61022238470:26:1722:59:17$ 0.19
629/24/01lunes9:12:38Urbanas46948980:00:089:12:46$ 0.05
639/24/01lunes15:04:30Celular1550113120:00:1815:04:48$ 0.05
649/24/01lunes20:31:09Urbanas46938810:06:4920:37:58$ 0.09
659/24/01lunes21:59:49Celular1550700590:05:3922:05:28$ 0.09
669/25/01martes8:57:12Correo61022238470:15:229:12:34$ 0.38
679/25/01martes16:09:25Correo61022238470:01:5416:11:19$ 0.05
689/25/01martes23:36:56Correo61022238470:04:4823:41:44$ 0.09
699/25/01martes9:12:51Urbanas46948980:00:079:12:58$ 0.05
709/25/01martes11:26:32Urbanas46020960:00:4011:27:12$ 0.05
719/25/01martes11:44:21Urbanas46938810:00:1311:44:34$ 0.05
729/25/01martes15:17:16Celular1550113120:00:3415:17:50$ 0.05
739/25/01martes20:47:57Celular1550700590:05:3820:53:35$ 0.09
749/25/01martes23:56:19Urbanas46948980:00:0923:56:28$ 0.05
759/26/01miercoles0:12:54Correo61022238470:08:470:21:41$ 0.14
769/26/01miercoles9:24:36Correo61022238470:27:369:52:12$ 0.38
779/26/01miercoles18:26:21Correo61022238470:33:0318:59:24$ 0.47
789/26/01miercoles20:55:34Internet61022276380:00:3320:56:07$ 0.05
799/26/01miercoles20:56:31Internet61022276381:05:5522:02:26$ 0.47
809/26/01miercoles23:33:41Internet61022276380:00:3323:34:14$ 0.05
819/26/01miercoles23:34:38Internet61022276381:26:281:01:06$ 0.56
829/26/01miercoles0:04:08Celular1550700590:00:430:04:51$ 0.05
839/26/01miercoles9:12:24Urbanas46948980:00:079:12:31$ 0.05
849/26/01miercoles11:35:23Urbanas46020960:02:1911:37:42$ 0.09
859/26/01miercoles19:52:50Celular1550700590:01:1019:54:00$ 0.05
869/26/01miercoles23:02:29Urbanas46948980:00:0823:02:37$ 0.05
879/27/01jueves1:01:50Correo61022238470:03:371:05:27$ 0.05
889/27/01jueves7:49:38Correo61022238470:00:467:50:24$ 0.05
899/27/01jueves13:30:11Correo61022238470:00:5113:31:02$ 0.05
909/27/01jueves13:32:47Correo61022238470:01:2113:34:08$ 0.05
919/27/01jueves23:10:53Correo61022238470:17:2823:28:21$ 0.19
929/27/01jueves9:19:07Urbanas46948980:00:079:19:14$ 0.05
939/27/01jueves10:20:27Urbanas46948980:00:1010:20:37$ 0.05
949/27/01jueves19:55:43Celular1550700590:02:3819:58:21$ 0.09
959/27/01jueves20:44:13Urbanas48318140:02:4820:47:01$ 0.05
969/27/01jueves22:04:38Urbanas48318140:01:4622:06:24$ 0.05
979/27/01jueves22:28:38Urbanas46948980:00:1322:28:51$ 0.05
989/28/01viernes17:12:53Correo61022238470:01:2217:14:15$ 0.05
999/28/01viernes17:15:05Correo61022238470:00:5517:16:00$ 0.05
1009/28/01viernes17:55:15Correo61022238470:03:4517:59:00$ 0.09
1019/28/01viernes11:41:20Urbanas46938810:08:4511:50:05$ 0.23
1029/29/01sabado10:02:37Urbanas46948980:00:0810:02:45$ 0.05
1039/29/01sabado13:30:25Urbanas46938810:06:3413:36:59$ 0.09
1049/30/01domingo17:18:49Correo61022238470:03:3017:22:19$ 0.05
1059/30/01domingo23:37:37Internet61022276380:28:410:06:18$ 0.19
1069/30/01domingo9:52:21Urbanas46938810:06:389:58:59$ 0.09
1079/30/01domingo10:52:50Urbanas46606710:07:4711:00:37$ 0.09
1089/30/01domingo20:38:39Celular1550113120:01:4020:40:19$ 0.05
1099/30/01domingo21:04:45Urbanas46938810:00:1821:05:03$ 0.05
1109/30/01domingo20:43:18Inter-Urb23224296220:14:3220:57:50$ 1.42
18:44:35$ 21.44
ABCDEFGHIJ
1Fecha(Todas)
2
3Suma de ImporteDia semana
4DestinolunesmartesmiercolesjuevesviernessabadodomingoTotal general
5Celular$ 0.37$ 0.24$ 0.15$ 0.14$ 0.10$ 1.00
6Correo$ 0.81$ 0.71$ 1.37$ 0.63$ 0.29$ 0.05$ 0.54$ 4.40
7Internet$ 0.66$ 0.47$ 1.93$ 0.33$ 0.09$ 0.56$ 0.99$ 5.03
8Inter-Urb$ 4.69$ 3.73$ 8.42
9Urbanas$ 0.19$ 0.25$ 0.24$ 0.40$ 0.43$ 0.62$ 0.46$ 2.59
10Impuesto a Celular 6%$ 0.02$ 0.01$ 0.01$ 0.01$ 0.00$ 0.00$ 0.01$ 0.06
11Impuesto a Correo 4,5%$ 0.04$ 0.03$ 0.06$ 0.03$ 0.01$ 0.00$ 0.02$ 0.20
12Impuesto a Internet 5%$ 0.03$ 0.02$ 0.10$ 0.02$ 0.00$ 0.03$ 0.05$ 0.25
13Impuesto a Inter-Urb 4%$ 0.00$ 0.00$ 0.19$ 0.00$ 0.00$ 0.00$ 0.15$ 0.34
14Impuesto a Urbanas 3%$ 0.01$ 0.01$ 0.01$ 0.01$ 0.01$ 0.02$ 0.01$ 0.08
15Total general$ 2.13$ 1.75$ 8.74$ 1.57$ 0.84$ 1.28$ 6.06$ 22.36
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
Camp.Elem
Campo calculado
Orden de resolucinCampoFrmula
1Impuesto 6%=Importe*6%
Elemento calculado
Orden de resolucinElementoFrmula
1'Impuesto a Celular 6%'=Celular*6%
2Impuesto a Correo 4,5%'=Correo *4,5%
3'Impuesto a Internet 5%'=Internet *5%
4'Impuesto a Inter-Urb 4%'='Inter-Urb' *4%
5'Impuesto a Urbanas 3%'=Urbanas *3%
Notas:Cuando una celda se actualiza con ms de una frmula,
el valor lo establece la frmula con la ltima orden de resolucin.
Para cambiar el orden de resolucin de frmulas,
use el comando Orden de resolucin en la barra de comandos de la tabla dinmica.
Telefono Word (4)
ABCDEFGH
1FechaDia semanaHora inicialDestinoNumeroDuracionHora finalImporte
29/15/01sabado0:00:04Correo61022238470:00:460:00:50$ 0.05
39/15/01sabado10:42:49Urbanas46938810:06:3610:49:25$ 0.19
49/15/01sabado20:31:44Internet61022276381:28:5022:00:34$ 0.56
59/16/01domingo19:10:44Correo61022238470:03:4619:14:30$ 0.05
69/16/01domingo23:25:47Correo61022238470:01:2623:27:13$ 0.05
79/16/01domingo23:43:20Correo61022238470:02:1023:45:30$ 0.05
89/16/01domingo23:46:29Internet61022276381:00:020:46:31$ 0.05
99/16/01domingo10:11:37Urbanas46606710:05:0810:16:45$ 0.09
109/16/01domingo22:21:51Inter-Urb35142688880:05:0022:26:51$ 2.31
119/17/01lunes22:28:17Correo61022238470:01:5722:30:14$ 0.05
129/17/01lunes23:21:59Correo61022238470:01:5423:23:53$ 0.05
139/17/01lunes9:14:50Urbanas46948980:00:099:14:59$ 0.05
149/17/01lunes19:08:07Celular1550700590:08:2319:16:30$ 0.23
159/17/01lunes20:55:07Internet61022276381:04:0221:59:09$ 0.47
169/18/01martes17:59:08Correo61022238470:03:1818:02:26$ 0.09
179/18/01martes18:15:50Correo61022238470:01:0518:16:55$ 0.05
189/18/01martes18:17:45Correo61022238470:00:5018:18:35$ 0.05
199/18/01martes22:56:18Internet61022276381:05:560:02:14$ 0.47
209/18/01martes8:58:14Urbanas46948980:00:088:58:22$ 0.05
219/18/01martes20:08:33Celular1550700590:01:0320:09:36$ 0.05
229/18/01martes20:28:27Celular1550700590:00:3920:29:06$ 0.05
239/19/01miercoles7:53:57Correo61022238470:05:447:59:41$ 0.09
249/19/01miercoles8:19:33Correo61022238470:07:148:26:47$ 0.19
259/19/01miercoles21:43:26Correo61022238470:03:5621:47:22$ 0.05
269/19/01miercoles21:53:26Correo61022238470:01:4521:55:11$ 0.05
279/19/01miercoles22:44:00Internet61022276382:00:510:44:51$ 0.80
289/19/01miercoles9:03:09Urbanas46948980:00:079:03:16$ 0.05
299/19/01miercoles19:59:23Celular1550700590:01:5320:01:16$ 0.05
309/19/01miercoles22:20:56Inter-Urb35142688880:10:1022:31:06$ 4.69
319/20/01jueves19:12:50Internet61022276380:13:0219:25:52$ 0.33
329/20/01jueves22:49:43Correo61022238470:27:0323:16:46$ 0.19
339/20/01jueves23:35:35Correo61022238470:01:1523:36:50$ 0.05
349/20/01jueves8:36:30Urbanas46948980:00:068:36:36$ 0.05
359/20/01jueves12:27:05Urbanas46020960:00:4912:27:54$ 0.05
369/20/01jueves19:40:59Urbanas45396950:00:3719:41:36$ 0.05
379/20/01jueves20:06:15Celular1550700590:01:5020:08:05$ 0.05
389/21/01viernes9:21:25Correo61022238470:01:139:22:38$ 0.05
399/21/01viernes18:43:05Correo61022238470:01:1518:44:20$ 0.05
409/21/01viernes9:08:21Urbanas46948980:00:079:08:28$ 0.05
419/21/01viernes9:13:34Urbanas46938810:00:459:14:19$ 0.05
429/21/01viernes18:39:20Urbanas46948980:00:1018:39:30$ 0.05
439/21/01viernes21:05:35Urbanas46606710:00:5921:06:34$ 0.05
449/21/01viernes18:31:22Internet61022276380:02:4218:34:04$ 0.09
459/22/01sabado15:28:24Urbanas46606710:01:0715:29:31$ 0.05
469/22/01sabado19:07:03Urbanas46938810:04:5819:12:01$ 0.09
479/22/01sabado19:22:41Urbanas46605710:00:1119:22:52$ 0.05
489/22/01sabado19:23:22Urbanas46606710:01:3419:24:56$ 0.05
499/22/01sabado19:27:33Urbanas46606710:00:1519:27:48$ 0.05
509/23/01domingo20:16:13Internet61022276381:50:1022:06:23$ 0.75
519/23/01domingo22:25:50Correo61022238470:00:5822:26:48$ 0.05
529/23/01domingo22:27:12Correo61022238470:01:0022:28:12$ 0.05
539/23/01domingo22:31:12Correo61022238470:01:0022:32:12$ 0.05
549/23/01domingo22:32:36Correo61022238470:13:2522:46:01$ 0.19
559/23/01domingo11:24:48Urbanas46938810:10:0411:34:52$ 0.14
569/23/01domingo22:07:05Celular1550700590:03:2422:10:29$ 0.05
579/24/01lunes7:44:21Correo61022238470:15:267:59:47$ 0.19
589/24/01lunes18:00:48Correo61022238470:12:5618:13:44$ 0.33
599/24/01lunes20:41:42Internet61022276380:00:3320:42:15$ 0.05
609/24/01lunes20:45:47Internet61022276380:08:3520:54:22$ 0.14
619/24/01lunes22:33:00Correo61022238470:26:1722:59:17$ 0.19
629/24/01lunes9:12:38Urbanas46948980:00:089:12:46$ 0.05
639/24/01lunes15:04:30Celular1550113120:00:1815:04:48$ 0.05
649/24/01lunes20:31:09Urbanas46938810:06:4920:37:58$ 0.09
659/24/01lunes21:59:49Celular1550700590:05:3922:05:28$ 0.09
669/25/01martes8:57:12Correo61022238470:15:229:12:34$ 0.38
679/25/01martes16:09:25Correo61022238470:01:5416:11:19$ 0.05
689/25/01martes23:36:56Correo61022238470:04:4823:41:44$ 0.09
699/25/01martes9:12:51Urbanas46948980:00:079:12:58$ 0.05
709/25/01martes11:26:32Urbanas46020960:00:4011:27:12$ 0.05
719/25/01martes11:44:21Urbanas46938810:00:1311:44:34$ 0.05
729/25/01martes15:17:16Celular1550113120:00:3415:17:50$ 0.05
739/25/01martes20:47:57Celular1550700590:05:3820:53:35$ 0.09
749/25/01martes23:56:19Urbanas46948980:00:0923:56:28$ 0.05
759/26/01miercoles0:12:54Correo61022238470:08:470:21:41$ 0.14
769/26/01miercoles9:24:36Correo61022238470:27:369:52:12$ 0.38
779/26/01miercoles18:26:21Correo61022238470:33:0318:59:24$ 0.47
789/26/01miercoles20:55:34Internet61022276380:00:3320:56:07$ 0.05
799/26/01miercoles20:56:31Internet61022276381:05:5522:02:26$ 0.47
809/26/01miercoles23:33:41Internet61022276380:00:3323:34:14$ 0.05
819/26/01miercoles23:34:38Internet61022276381:26:281:01:06$ 0.56
829/26/01miercoles0:04:08Celular1550700590:00:430:04:51$ 0.05
839/26/01miercoles9:12:24Urbanas46948980:00:079:12:31$ 0.05
849/26/01miercoles11:35:23Urbanas46020960:02:1911:37:42$ 0.09
859/26/01miercoles19:52:50Celular1550700590:01:1019:54:00$ 0.05
869/26/01miercoles23:02:29Urbanas46948980:00:0823:02:37$ 0.05
879/27/01jueves1:01:50Correo61022238470:03:371:05:27$ 0.05
889/27/01jueves7:49:38Correo61022238470:00:467:50:24$ 0.05
899/27/01jueves13:30:11Correo61022238470:00:5113:31:02$ 0.05
909/27/01jueves13:32:47Correo61022238470:01:2113:34:08$ 0.05
919/27/01jueves23:10:53Correo61022238470:17:2823:28:21$ 0.19
929/27/01jueves9:19:07Urbanas46948980:00:079:19:14$ 0.05
939/27/01jueves10:20:27Urbanas46948980:00:1010:20:37$ 0.05
949/27/01jueves19:55:43Celular1550700590:02:3819:58:21$ 0.09
959/27/01jueves20:44:13Urbanas48318140:02:4820:47:01$ 0.05
969/27/01jueves22:04:38Urbanas48318140:01:4622:06:24$ 0.05
979/27/01jueves22:28:38Urbanas46948980:00:1322:28:51$ 0.05
989/28/01viernes17:12:53Correo61022238470:01:2217:14:15$ 0.05
999/28/01viernes17:15:05Correo61022238470:00:5517:16:00$ 0.05
1009/28/01viernes17:55:15Correo61022238470:03:4517:59:00$ 0.09
1019/28/01viernes11:41:20Urbanas46938810:08:4511:50:05$ 0.23
1029/29/01sabado10:02:37Urbanas46948980:00:0810:02:45$ 0.05
1039/29/01sabado13:30:25Urbanas46938810:06:3413:36:59$ 0.09
1049/30/01domingo17:18:49Correo61022238470:03:3017:22:19$ 0.05
1059/30/01domingo23:37:37Internet61022276380:28:410:06:18$ 0.19
1069/30/01domingo9:52:21Urbanas46938810:06:389:58:59$ 0.09
1079/30/01domingo10:52:50Urbanas46606710:07:4711:00:37$ 0.09
1089/30/01domingo20:38:39Celular1550113120:01:4020:40:19$ 0.05
1099/30/01domingo21:04:45Urbanas46938810:00:1821:05:03$ 0.05
1109/30/01domingo20:43:18Inter-Urb23224296220:14:3220:57:50$ 1.42
ABCDEFGHIJ
1Fecha(Todas)
2
3Dia semana
4DestinoDatoslunesmartesmiercolesjuevesviernessabadodomingoTotal general
5CelularSuma de Duracion0:14:200:07:540:03:460:04:280:05:040:35:32
6Suma de Importe0.370.240.150.140.101.00
7Suma de Impuesto 6%$ 0.02$ 0.01$ 0.01$ 0.01$ - 0$ - 0$ 0.01$ 0.06
8CorreoSuma de Duracion0:58:300:27:171:28:050:52:210:08:300:00:460:27:154:22:44
9Suma de Importe0.810.711.370.630.290.050.544.40
10Suma de Impuesto 6%$ 0.05$ 0.04$ 0.08$ 0.04$ 0.02$ 0.00$ 0.03$ 0.26
11InternetSuma de Duracion1:13:101:05:564:34:200:13:020:02:421:28:503:18:5311:56:53
12Suma de Importe0.660.471.930.330.090.560.995.03
13Suma de Impuesto 6%$ 0.04$ 0.03$ 0.12$ 0.02$ 0.01$ 0.03$ 0.06$ 0.30
14Inter-UrbSuma de Duracion0:10:100:19:320:29:42
15Suma de Importe4.693.738.42
16Suma de Impuesto 6%$ - 0$ - 0$ 0.28$ - 0$ - 0$ - 0$ 0.22$ 0.51
17UrbanasSuma de Duracion0:07:060:01:170:02:410:06:360:10:460:21:230:29:551:19:44
18Suma de Importe0.190.250.240.400.430.620.462.59
19Suma de Impuesto 6%$ 0.01$ 0.02$ 0.01$ 0.02$ 0.03$ 0.04$ 0.03$ 0.16
20Impuesto a Celular 6%Suma de Duracion0:00:510:00:280:00:130:00:160:00:000:00:000:00:180:02:07
21Suma de Importe0.02220.01440.0090.0084000.0060.06
22Suma de Impuesto 6%$ 0.00$ 0.00$ 0.00$ 0.00$ - 0$ - 0$ 0.00$ 0.00
23Impuesto a Correo 4,5%%Suma de Duracion0:02:370:01:130:03:570:02:210:00:220:00:020:01:130:11:49
24Suma de Importe0.036450.031950.061650.028350.013050.002250.02430.198
25Suma de Impuesto 6%$ 0.00$ 0.00$ 0.00$ 0.00$ 0.00$ 0.00$ 0.00$ 0.01
26Impuesto a Internet 5%Suma de Duracion0:03:390:03:170:13:430:00:390:00:080:04:260:09:560:35:50
27Suma de Importe0.0330.02350.09650.01650.00450.0280.04950.2515
28Suma de Impuesto 6%$ 0.00$ 0.00$ 0.01$ 0.00$ 0.00$ 0.00$ 0.00$ 0.02
29Impuesto a Inter-Urb 4%Suma de Duracion0:00:000:00:000:00:240:00:000:00:000:00:000:00:460:01:11
30Suma de Importe000.18760000.14920.3368
31Suma de Impuesto 6%$ - 0$ - 0$ 0.01$ - 0$ - 0$ - 0$ 0.01$ 0.02
32Impuesto a Urbanas 3%Suma de Duracion0:00:120:00:020:00:040:00:110:00:190:00:380:00:530:02:23
33Suma de Importe0.00570.00750.00720.0120.01290.01860.01380.0777
34Suma de Impuesto 6%$ 0.00$ 0.00$ 0.00$ 0.00$ 0.00$ 0.00$ 0.00$ 0.00
35Total Suma de Duracion2:40:271:47:266:37:251:19:550:22:481:56:064:53:4819:37:57
36Total Suma de Importe2.127351.747358.741951.570.840451.278856.062822.364
37Total Suma de Impuesto 6%$ 0.13$ 0.10$ 0.52$ 0.09$ 0.05$ 0.08$ 0.36$ 1.34
38
39
40
41
42
43
44
45
46
47
48
49
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
Celular 1
AFHE
1FechaDuracionImporteNumero
149/17/010:08:23$ 0.23155070059
219/18/010:01:03$ 0.05155070059
229/18/010:00:39$ 0.05155070059
299/19/010:01:53$ 0.05155070059
379/20/010:01:50$ 0.05155070059
569/23/010:03:24$ 0.05155070059
639/24/010:00:18$ 0.05155011312
659/24/010:05:39$ 0.09155070059
729/25/010:00:34$ 0.05155011312
739/25/010:05:38$ 0.09155070059
829/26/010:00:43$ 0.05155070059
859/26/010:01:10$ 0.05155070059
949/27/010:02:38$ 0.09155070059
1089/30/010:01:40$ 0.05155011312
0:35:32$ 1.00
Telefono Word
ABCDEFGH
1FechaDia semanaHora inicialDestinoNumeroDuracionHora finalImporte
29/15/01sabado0:00:04Correo61022238470:00:460:00:50$ 0.05
39/15/01sabado10:42:49Urbanas46938810:06:3610:49:25$ 0.19
49/15/01sabado20:31:44Internet61022276381:28:5022:00:34$ 0.56
59/16/01domingo19:10:44Correo61022238470:03:4619:14:30$ 0.05
69/16/01domingo23:25:47Correo61022238470:01:2623:27:13$ 0.05
79/16/01domingo23:43:20Correo61022238470:02:1023:45:30$ 0.05
89/16/01domingo23:46:29Internet61022276381:00:020:46:31$ 0.05
99/16/01domingo10:11:37Urbanas46606710:05:0810:16:45$ 0.09
109/16/01domingo22:21:51Inter-Urb35142688880:05:0022:26:51$ 2.31
119/17/01lunes22:28:17Correo61022238470:01:5722:30:14$ 0.05
129/17/01lunes23:21:59Correo61022238470:01:5423:23:53$ 0.05
139/17/01lunes9:14:50Urbanas46948980:00:099:14:59$ 0.05
149/17/01lunes19:08:07Celular1550700590:08:2319:16:30$ 0.23
159/17/01lunes20:55:07Internet61022276381:04:0221:59:09$ 0.47
169/18/01martes17:59:08Correo61022238470:03:1818:02:26$ 0.09
179/18/01martes18:15:50Correo61022238470:01:0518:16:55$ 0.05
189/18/01martes18:17:45Correo61022238470:00:5018:18:35$ 0.05
199/18/01martes22:56:18Internet61022276381:05:560:02:14$ 0.47
209/18/01martes8:58:14Urbanas46948980:00:088:58:22$ 0.05
219/18/01martes20:08:33Celular1550700590:01:0320:09:36$ 0.05
229/18/01martes20:28:27Celular1550700590:00:3920:29:06$ 0.05
239/19/01miercoles7:53:57Correo61022238470:05:447:59:41$ 0.09
249/19/01miercoles8:19:33Correo61022238470:07:148:26:47$ 0.19
259/19/01miercoles21:43:26Correo61022238470:03:5621:47:22$ 0.05
269/19/01miercoles21:53:26Correo61022238470:01:4521:55:11$ 0.05
279/19/01miercoles22:44:00Internet61022276382:00:510:44:51$ 0.80
289/19/01miercoles9:03:09Urbanas46948980:00:079:03:16$ 0.05
299/19/01miercoles19:59:23Celular1550700590:01:5320:01:16$ 0.05
309/19/01miercoles22:20:56Inter-Urb35142688880:10:1022:31:06$ 4.69
319/20/01jueves19:12:50Internet61022276380:13:0219:25:52$ 0.33
329/20/01jueves22:49:43Correo61022238470:27:0323:16:46$ 0.19
339/20/01jueves23:35:35Correo61022238470:01:1523:36:50$ 0.05
349/20/01jueves8:36:30Urbanas46948980:00:068:36:36$ 0.05
359/20/01jueves12:27:05Urbanas46020960:00:4912:27:54$ 0.05
369/20/01jueves19:40:59Urbanas45396950:00:3719:41:36$ 0.05
379/20/01jueves20:06:15Celular1550700590:01:5020:08:05$ 0.05
389/21/01viernes9:21:25Correo61022238470:01:139:22:38$ 0.05
399/21/01viernes18:43:05Correo61022238470:01:1518:44:20$ 0.05
409/21/01viernes9:08:21Urbanas46948980:00:079:08:28$ 0.05
419/21/01viernes9:13:34Urbanas46938810:00:459:14:19$ 0.05
429/21/01viernes18:39:20Urbanas46948980:00:1018:39:30$ 0.05
439/21/01viernes21:05:35Urbanas46606710:00:5921:06:34$ 0.05
449/21/01viernes18:31:22Internet61022276380:02:4218:34:04$ 0.09
459/22/01sabado15:28:24Urbanas46606710:01:0715:29:31$ 0.05
469/22/01sabado19:07:03Urbanas46938810:04:5819:12:01$ 0.09
479/22/01sabado19:22:41Urbanas46605710:00:1119:22:52$ 0.05
489/22/01sabado19:23:22Urbanas46606710:01:3419:24:56$ 0.05
499/22/01sabado19:27:33Urbanas46606710:00:1519:27:48$ 0.05
509/23/01domingo20:16:13Internet61022276381:50:1022:06:23$ 0.75
519/23/01domingo22:25:50Correo61022238470:00:5822:26:48$ 0.05
529/23/01domingo22:27:12Correo61022238470:01:0022:28:12$ 0.05
539/23/01domingo22:31:12Correo61022238470:01:0022:32:12$ 0.05
549/23/01domingo22:32:36Correo61022238470:13:2522:46:01$ 0.19
559/23/01domingo11:24:48Urbanas46938810:10:0411:34:52$ 0.14
569/23/01domingo22:07:05Celular1550700590:03:2422:10:29$ 0.05
579/24/01lunes7:44:21Correo61022238470:15:267:59:47$ 0.19
589/24/01lunes18:00:48Correo61022238470:12:5618:13:44$ 0.33
599/24/01lunes20:41:42Internet61022276380:00:3320:42:15$ 0.05
609/24/01lunes20:45:47Internet61022276380:08:3520:54:22$ 0.14
619/24/01lunes22:33:00Correo61022238470:26:1722:59:17$ 0.19
629/24/01lunes9:12:38Urbanas46948980:00:089:12:46$ 0.05
639/24/01lunes15:04:30Celular1550113120:00:1815:04:48$ 0.05
649/24/01lunes20:31:09Urbanas46938810:06:4920:37:58$ 0.09
659/24/01lunes21:59:49Celular1550700590:05:3922:05:28$ 0.09
669/25/01martes8:57:12Correo61022238470:15:229:12:34$ 0.38
679/25/01martes16:09:25Correo61022238470:01:5416:11:19$ 0.05
689/25/01martes23:36:56Correo61022238470:04:4823:41:44$ 0.09
699/25/01martes9:12:51Urbanas46948980:00:079:12:58$ 0.05
709/25/01martes11:26:32Urbanas46020960:00:4011:27:12$ 0.05
719/25/01martes11:44:21Urbanas46938810:00:1311:44:34$ 0.05
729/25/01martes15:17:16Celular1550113120:00:3415:17:50$ 0.05
739/25/01martes20:47:57Celular1550700590:05:3820:53:35$ 0.09
749/25/01martes23:56:19Urbanas46948980:00:0923:56:28$ 0.05
759/26/01miercoles0:12:54Correo61022238470:08:470:21:41$ 0.14
769/26/01miercoles9:24:36Correo61022238470:27:369:52:12$ 0.38
779/26/01miercoles18:26:21Correo61022238470:33:0318:59:24$ 0.47
789/26/01miercoles20:55:34Internet61022276380:00:3320:56:07$ 0.05
799/26/01miercoles20:56:31Internet61022276381:05:5522:02:26$ 0.47
809/26/01miercoles23:33:41Internet61022276380:00:3323:34:14$ 0.05
819/26/01miercoles23:34:38Internet61022276381:26:281:01:06$ 0.56
829/26/01miercoles0:04:08Celular1550700590:00:430:04:51$ 0.05
839/26/01miercoles9:12:24Urbanas46948980:00:079:12:31$ 0.05
849/26/01miercoles11:35:23Urbanas46020960:02:1911:37:42$ 0.09
859/26/01miercoles19:52:50Celular1550700590:01:1019:54:00$ 0.05
869/26/01miercoles23:02:29Urbanas46948980:00:0823:02:37$ 0.05
879/27/01jueves1:01:50Correo61022238470:03:371:05:27$ 0.05
889/27/01jueves7:49:38Correo61022238470:00:467:50:24$ 0.05
899/27/01jueves13:30:11Correo61022238470:00:5113:31:02$ 0.05
909/27/01jueves13:32:47Correo61022238470:01:2113:34:08$ 0.05
919/27/01jueves23:10:53Correo61022238470:17:2823:28:21$ 0.19
929/27/01jueves9:19:07Urbanas46948980:00:079:19:14$ 0.05
939/27/01jueves10:20:27Urbanas46948980:00:1010:20:37$ 0.05
949/27/01jueves19:55:43Celular1550700590:02:3819:58:21$ 0.09
959/27/01jueves20:44:13Urbanas48318140:02:4820:47:01$ 0.05
969/27/01jueves22:04:38Urbanas48318140:01:4622:06:24$ 0.05
979/27/01jueves22:28:38Urbanas46948980:00:1322:28:51$ 0.05
989/28/01viernes17:12:53Correo61022238470:01:2217:14:15$ 0.05
999/28/01viernes17:15:05Correo61022238470:00:5517:16:00$ 0.05
1009/28/01viernes17:55:15Correo61022238470:03:4517:59:00$ 0.09
1019/28/01viernes11:41:20Urbanas46938810:08:4511:50:05$ 0.23
1029/29/01sabado10:02:37Urbanas46948980:00:0810:02:45$ 0.05
1039/29/01sabado13:30:25Urbanas46938810:06:3413:36:59$ 0.09
1049/30/01domingo17:18:49Correo61022238470:03:3017:22:19$ 0.05
1059/30/01domingo23:37:37Internet61022276380:28:410:06:18$ 0.19
1069/30/01domingo9:52:21Urbanas46938810:06:389:58:59$ 0.09
1079/30/01domingo10:52:50Urbanas46606710:07:4711:00:37$ 0.09
1089/30/01domingo20:38:39Celular1550113120:01:4020:40:19$ 0.05
1099/30/01domingo21:04:45Urbanas46938810:00:1821:05:03$ 0.05
1109/30/01domingo20:43:18Inter-Urb23224296220:14:3220:57:50$ 1.42
ABCDEFGHIJ
1Fecha(Todas)
2
3Dia semana
4DestinoDatoslunesmartesmiercolesjuevesviernessabadodomingoTotal general
5CelularSuma de Duracion0:14:200:07:540:03:460:04:280:05:040:35:32
6Suma de Importe0.370.240.150.140.101.00
7CorreoSuma de Duracion0:58:300:27:171:28:050:52:210:08:300:00:460:27:154:22:44
8Suma de Importe0.810.711.370.630.290.050.544.40
9InternetSuma de Duracion1:13:101:05:564:34:200:13:020:02:421:28:503:18:5311:56:53
10Suma de Importe0.660.471.930.330.090.560.995.03
11Inter-UrbSuma de Duracion0:10:100:19:320:29:42
12Suma de Importe4.693.738.42
13UrbanasSuma de Duracion0:07:060:01:170:02:410:06:360:10:460:21:230:29:551:19:44
14Suma de Importe0.190.250.240.400.430.620.462.59
15Impuesto a Celular 6%Suma de Duracion0:00:510:00:280:00:130:00:160:00:000:00:000:00:180:02:07
16Suma de Importe0.02220.01440.0090.0084000.0060.06
17Impuesto a Correo 4,5%%Suma de Duracion0:02:370:01:130:03:570:02:210:00:220:00:020:01:130:11:49
18Suma de Importe0.036450.031950.061650.028350.013050.002250.02430.198
19Impuesto a Internet 5%Suma de Duracion0:03:390:03:170:13:430:00:390:00:080:04:260:09:560:35:50
20Suma de Importe0.0330.02350.09650.01650.00450.0280.04950.2515
21Impuesto a Inter-Urb 4%Suma de Duracion0:00:000:00:000:00:240:00:000:00:000:00:000:00:460:01:11
22Suma de Importe000.18760000.14920.3368
23Impuesto a Urbanas 3%Suma de Duracion0:00:120:00:020:00:040:00:110:00:190:00:380:00:530:02:23
24Suma de Importe0.00570.00750.00720.0120.01290.01860.01380.0777
25Total Suma de Duracion2:40:271:47:266:37:251:19:550:22:481:56:064:53:4819:37:57
26Total Suma de Importe2.127351.747358.741951.570.840451.278856.062822.364
27
28
29
30
31
32
33
1Fecha(Todas)
2
3Dia semana
4DestinoDatoslunesmartesmiercolesjuevesviernessabadodomingoTotal general
5CelularSuma de Duracion0:14:200:07:540:03:460:04:280:05:040:35:32
6Suma de Importe0.370.240.150.140.11
7CorreoSuma de Duracion0:58:300:27:171:28:050:52:210:08:300:00:460:27:154:22:44
8Suma de Importe0.810.711.370.630.290.050.544.4
9InternetSuma de Duracion1:13:101:05:564:34:200:13:020:02:421:28:503:18:5311:56:53
10Suma de Importe0.660.471.930.330.090.560.995.03
11Inter-UrbSuma de Duracion0:10:100:19:320:29:42
12Suma de Importe4.693.738.42
13UrbanasSuma de Duracion0:07:060:01:170:02:410:06:360:10:460:21:230:29:551:19:44
14Suma de Importe0.190.250.240.40.430.620.462.59
15Total Suma de Duracion2:33:061:42:246:19:021:16:270:21:581:50:594:40:3918:44:35
16Total Suma de Importe2.031.678.381.50.811.235.8221.44
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
Telefono solo
NFechaDia semanaHora inicialDestinoNumeroDuracionHora finalImporte
29/15/01sabado10:42:49Urbanas46938810:06:3610:49:25$ 0.19
89/16/01domingo10:11:37Urbanas46606710:05:0810:16:45$ 0.09
99/16/01domingo22:21:51Inter-Urb35142688880:05:0022:26:51$ 2.31
129/17/01lunes9:14:50Urbanas46948980:00:099:14:59$ 0.05
199/18/01martes8:58:14Urbanas46948980:00:088:58:22$ 0.05
279/19/01miercoles9:03:09Urbanas46948980:00:079:03:16$ 0.05
299/19/01miercoles22:20:56Inter-Urb35142688880:10:1022:31:06$ 4.69
339/20/01jueves8:36:30Urbanas46948980:00:068:36:36$ 0.05
349/20/01jueves12:27:05Urbanas46020960:00:4912:27:54$ 0.05
359/20/01jueves19:40:59Urbanas45396950:00:3719:41:36$ 0.05
399/21/01viernes9:08:21Urbanas46948980:00:079:08:28$ 0.05
409/21/01viernes9:13:34Urbanas46938810:00:459:14:19$ 0.05
419/21/01viernes18:39:20Urbanas46948980:00:1018:39:30$ 0.05
429/21/01viernes21:05:35Urbanas46606710:00:5921:06:34$ 0.05
449/22/01sabado15:28:24Urbanas46606710:01:0715:29:31$ 0.05
459/22/01sabado19:07:03Urbanas46938810:04:5819:12:01$ 0.09
469/22/01sabado19:22:41Urbanas46605710:00:1119:22:52$ 0.05
479/22/01sabado19:23:22Urbanas46606710:01:3419:24:56$ 0.05
489/22/01sabado19:27:33Urbanas46606710:00:1519:27:48$ 0.05
549/23/01domingo11:24:48Urbanas46938810:10:0411:34:52$ 0.14
619/24/01lunes9:12:38Urbanas46948980:00:089:12:46$ 0.05
639/24/01lunes20:31:09Urbanas46938810:06:4920:37:58$ 0.09
689/25/01martes9:12:51Urbanas46948980:00:079:12:58$ 0.05
699/25/01martes11:26:32Urbanas46020960:00:4011:27:12$ 0.05
709/25/01martes11:44:21Urbanas46938810:00:1311:44:34$ 0.05
739/25/01martes23:56:19Urbanas46948980:00:0923:56:28$ 0.05
829/26/01miercoles9:12:24Urbanas46948980:00:079:12:31$ 0.05
839/26/01miercoles11:35:23Urbanas46020960:02:1911:37:42$ 0.09
859/26/01miercoles23:02:29Urbanas46948980:00:0823:02:37$ 0.05
919/27/01jueves9:19:07Urbanas46948980:00:079:19:14$ 0.05
929/27/01jueves10:20:27Urbanas46948980:00:1010:20:37$ 0.05
949/27/01jueves20:44:13Urbanas48318140:02:4820:47:01$ 0.05
959/27/01jueves22:04:38Urbanas48318140:01:4622:06:24$ 0.05
969/27/01jueves22:28:38Urbanas46948980:00:1322:28:51$ 0.05
1009/28/01viernes11:41:20Urbanas46938810:08:4511:50:05$ 0.23
1019/29/01sabado10:02:37Urbanas46948980:00:0810:02:45$ 0.05
1029/29/01sabado13:30:25Urbanas46938810:06:3413:36:59$ 0.09
1059/30/01domingo9:52:21Urbanas46938810:06:389:58:59$ 0.09
1069/30/01domingo10:52:50Urbanas46606710:07:4711:00:37$ 0.09
1089/30/01domingo21:04:45Urbanas46938810:00:1821:05:03$ 0.05
1099/30/01domingo20:43:18Inter-Urb23224296220:14:3220:57:50$ 1.42
11410/1/01lunes8:51:45Urbanas46948980:00:078:51:52$ 0.05
11510/1/01lunes10:00:49Urbanas46938810:06:2610:07:15$ 0.19
11610/1/01lunes19:11:20Urbanas46938810:00:5619:12:16$ 0.05
11710/1/01lunes21:59:32Urbanas46938810:01:5422:01:26$ 0.05
11810/1/01lunes22:06:38Urbanas45718620:03:1622:09:54$ 0.05
11910/1/01lunes19:38:34Inter-Urb114325502610:00:3319:39:07$ 0.09
12010/1/01lunes23:25:02Inter-Urb114325502610:18:1223:43:14$ 2.22
12310/2/01martes9:03:55Urbanas46948980:00:089:04:03$ 0.05
12410/2/01martes12:03:24Urbanas46938810:08:3512:11:59$ 0.23
12510/2/01martes19:49:21Urbanas46938810:06:2119:55:42$ 0.19
12610/2/01martes20:44:15Urbanas45718620:02:1520:46:30$ 0.05
14110/3/01miercoles9:16:20Urbanas46948980:00:069:16:26$ 0.05
14210/3/01miercoles12:50:01Urbanas42597000:01:2212:51:23$ 0.05
14610/4/01jueves9:10:55Urbanas46948980:00:089:11:03$ 0.05
14710/4/01jueves9:15:23Urbanas46938810:00:029:15:25$ 0.05
14810/4/01jueves10:20:58Urbanas46938810:08:5910:29:57$ 0.23
14910/4/01jueves20:40:45Inter-Urb114325502610:02:1220:42:57$ 0.36
15010/4/01jueves23:19:14Inter-Urb114325502610:06:3323:25:47$ 0.80
15310/5/01viernes9:18:24Urbanas46948980:00:069:18:30$ 0.05
15410/30/01martes7:41:29Correo61022238470:02:277:43:56$ 0.05
15510/30/01martes8:00:44Correo61022238470:05:508:06:34$ 0.14
15610/30/01martes8:10:23Correo61022238470:15:028:25:25$ 0.38
15710/30/01martes16:52:10Inernert61022276380:02:5116:55:01$ 0.09
15810/30/01martes20:44:35Inernert61022276380:40:1021:24:45$ 0.33
15910/30/01martes22:21:32Inernert61022276380:01:3822:23:10$ 0.05
16010/30/01martes23:22:15Correo61022238470:06:2423:28:39$ 0.09
16110/30/01martes23:45:21Correo61022238470:06:3823:51:59$ 0.09
16210/31/01miercoles8:09:48Correo61022238470:04:388:14:26$ 0.14
16310/31/01miercoles20:45:57Inernert61022276380:01:1120:47:08$ 0.05
16410/31/01miercoles20:49:47Inernert61022276380:47:4021:37:27$ 0.38
16510/31/01miercoles21:43:09Inernert61022276380:00:3321:43:42$ 0.05
16610/31/01miercoles21:44:06Inernert61022276380:00:3921:44:45$ 0.05
16710/31/01miercoles21:47:14Inernert61022276380:00:3521:47:49$ 0.05
16810/31/01miercoles21:48:19Inernert61022276380:00:2621:48:45$ 0.05
16910/31/01mier