T.Din.Datos Ext.

18
TABLAS DINAMICAS CON FUENTE DE DATOS EXTERNA

description

kjjkjlkjlj

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