0% encontró este documento útil (0 votos)
25 vistas77 páginas

Base de Datos

El documento contiene una tabla con registros de estacionamiento que incluyen número de celda, fecha, número de horas, placa, vehículo, valor por hora y total pagado. También contiene instrucciones para realizar cálculos en una hoja externa usando funciones como SUMAR.SI.

Cargado por

kevin martinez
Derechos de autor
© © All Rights Reserved
Nos tomamos en serio los derechos de los contenidos. Si sospechas que se trata de tu contenido, reclámalo aquí.
Formatos disponibles
Descarga como XLSX, PDF, TXT o lee en línea desde Scribd
0% encontró este documento útil (0 votos)
25 vistas77 páginas

Base de Datos

El documento contiene una tabla con registros de estacionamiento que incluyen número de celda, fecha, número de horas, placa, vehículo, valor por hora y total pagado. También contiene instrucciones para realizar cálculos en una hoja externa usando funciones como SUMAR.SI.

Cargado por

kevin martinez
Derechos de autor
© © All Rights Reserved
Nos tomamos en serio los derechos de los contenidos. Si sospechas que se trata de tu contenido, reclámalo aquí.
Formatos disponibles
Descarga como XLSX, PDF, TXT o lee en línea desde Scribd

1.

Realice un botón por cada hoja con el fin de hacer un


hipervinculo, por ejemplo si doy clic en el botón parking ll
dicha hoja y de esta misma hoja regresar al menú.

PARKING
CONSULTA

FILTRO FILTRO A
on el fin de hacer un
en el botón parking llegará a
esar al menú.

ESTADIS GRAFICO

FUNCIONES TABL
SUBTOTAL BD
TABLA D
CONSULTA
# DE CELDA 011
PROPIETARIO PEDRO MATURANA
PLACA PAM-815
VEHICULO COLECTIVO
5. Utilizando la funcion si.error y busca
VALOR $ 3,000 lo que se pide desde la celda A3 hasta
TOTAL HORAS 249
6. Con la funcion sumar. si , resuelve lo
la celda A7, así.

=SUMAR.SI(PARKING!H:H,B3,PARKING

7. Calcule cuanto paga el propietario, e


debe multiplicar valor por total horas.
PROPIETARIO TOTAL
PEDRO MATURANA $ 747,000

ndo la funcion si.error y buscarv, se resuelve


pide desde la celda A3 hasta la A6.

funcion sumar. si , resuelve lo que se pide en


A7, así.

SI(PARKING!H:H,B3,PARKING!C:C)

e cuanto paga el propietario, en la celda F2, MENÚ


tiplicar valor por total horas.
# DE CELDA FECHA # DE HORAS PLACA VEHICULO VALOR HORA TOTAL
005 31/03/2017 1 HRP-000 MOTO $1,000 $1,000
011 31/03/2017 2 PAM-815 COLECTIVO $3,000 $6,000
004 30/03/2017 3 BLN-210 PARTICULAR $4,500 $13,500
010 30/03/2017 4 JEA-211 MOTO $1,000 $4,000
003 29/03/2017 5 ANA-520 PARTICULAR $4,500 $22,500
009 29/03/2017 6 JPA-906 PARTICULAR $4,500 $27,000
002 28/03/2017 7 TTZ-004 TAXI $2,500 $17,500
008 28/03/2017 8 JFR-128 PARTICULAR $4,500 $36,000
001 27/03/2017 9 OYK-089 PARTICULAR $4,500 $40,500
007 27/03/2017 10 HSM-315 PARTICULAR $4,500 $45,000
006 26/03/2017 11 WWW-882 TAXI $2,500 $27,500
011 26/03/2017 12 PAM-815 COLECTIVO $3,000 $36,000
005 25/03/2017 13 HRP-000 MOTO $1,000 $13,000
010 25/03/2017 14 JEA-211 MOTO $1,000 $14,000
004 24/03/2017 15 BLN-210 PARTICULAR $4,500 $67,500
009 24/03/2017 16 JPA-906 PARTICULAR $4,500 $72,000
003 23/03/2017 17 ANA-520 PARTICULAR $4,500 $76,500
008 23/03/2017 18 JFR-128 PARTICULAR $4,500 $81,000
002 22/03/2017 19 TTZ-004 TAXI $2,500 $47,500
007 22/03/2017 20 HSM-315 PARTICULAR $4,500 $90,000
001 21/03/2017 21 OYK-089 PARTICULAR $4,500 $94,500
006 21/03/2017 22 WWW-882 TAXI $2,500 $55,000
005 20/03/2017 23 HRP-000 MOTO $1,000 $23,000
011 20/03/2017 24 PAM-815 COLECTIVO $3,000 $72,000
004 19/03/2017 1 BLN-210 PARTICULAR $4,500 $4,500
010 19/03/2017 2 JEA-211 MOTO $1,000 $2,000
003 18/03/2017 3 ANA-520 PARTICULAR $4,500 $13,500
009 18/03/2017 4 JPA-906 PARTICULAR $4,500 $18,000
002 17/03/2017 5 TTZ-004 TAXI $2,500 $12,500
008 17/03/2017 6 JFR-128 PARTICULAR $4,500 $27,000
001 16/03/2017 7 OYK-089 PARTICULAR $4,500 $31,500
007 16/03/2017 8 HSM-315 PARTICULAR $4,500 $36,000
006 15/03/2017 9 WWW-882 TAXI $2,500 $22,500
011 15/03/2017 10 PAM-815 COLECTIVO $3,000 $30,000
005 14/03/2017 11 HRP-000 MOTO $1,000 $11,000
010 14/03/2017 12 JEA-211 MOTO $1,000 $12,000
004 13/03/2017 13 BLN-210 PARTICULAR $4,500 $58,500
009 13/03/2017 14 JPA-906 PARTICULAR $4,500 $63,000
003 12/03/2017 15 ANA-520 PARTICULAR $4,500 $67,500
008 12/03/2017 16 JFR-128 PARTICULAR $4,500 $72,000
002 11/03/2017 17 TTZ-004 TAXI $2,500 $42,500
007 11/03/2017 18 HSM-315 PARTICULAR $4,500 $81,000
001 10/03/2017 19 OYK-089 PARTICULAR $4,500 $85,500
006 10/03/2017 20 WWW-882 TAXI $2,500 $50,000
005 09/03/2017 21 HRP-000 MOTO $1,000 $21,000
011 09/03/2017 22 PAM-815 COLECTIVO $3,000 $66,000
004 08/03/2017 23 BLN-210 PARTICULAR $4,500 $103,500
010 08/03/2017 24 JEA-211 MOTO $1,000 $24,000
003 07/03/2017 1 ANA-520 PARTICULAR $4,500 $4,500
009 07/03/2017 2 JPA-906 PARTICULAR $4,500 $9,000
002 06/03/2017 3 TTZ-004 TAXI $2,500 $7,500
008 06/03/2017 4 JFR-128 PARTICULAR $4,500 $18,000
001 05/03/2017 5 OYK-089 PARTICULAR $4,500 $22,500
007 05/03/2017 6 HSM-315 PARTICULAR $4,500 $27,000
006 04/03/2017 7 WWW-882 TAXI $2,500 $17,500
011 04/03/2017 8 PAM-815 COLECTIVO $3,000 $24,000
010 03/03/2017 9 JEA-211 MOTO $1,000 $9,000
009 02/03/2017 10 JPA-906 PARTICULAR $4,500 $45,000
008 01/03/2017 11 JFR-128 PARTICULAR $4,500 $49,500
007 28/02/2017 12 HSM-315 PARTICULAR $4,500 $54,000
006 27/02/2017 13 WWW-882 TAXI $2,500 $32,500
005 26/02/2017 14 HRP-000 MOTO $1,000 $14,000
004 25/02/2017 15 BLN-210 PARTICULAR $4,500 $67,500
003 24/02/2017 16 ANA-520 PARTICULAR $4,500 $72,000
002 23/02/2017 17 TTZ-004 TAXI $2,500 $42,500
001 22/02/2017 18 OYK-089 PARTICULAR $4,500 $81,000
011 21/02/2017 19 PAM-815 COLECTIVO $3,000 $57,000
010 20/02/2017 20 JEA-211 MOTO $1,000 $20,000
009 19/02/2017 21 JPA-906 PARTICULAR $4,500 $94,500
008 18/02/2017 22 JFR-128 PARTICULAR $4,500 $99,000
007 17/02/2017 23 HSM-315 PARTICULAR $4,500 $103,500
006 16/02/2017 24 WWW-882 TAXI $2,500 $60,000
005 15/02/2017 1 HRP-000 MOTO $1,000 $1,000
004 14/02/2017 2 BLN-210 PARTICULAR $4,500 $9,000
003 13/02/2017 3 ANA-520 PARTICULAR $4,500 $13,500
002 12/02/2017 4 TTZ-004 TAXI $2,500 $10,000
001 11/02/2017 5 OYK-089 PARTICULAR $4,500 $22,500
011 10/02/2017 6 PAM-815 COLECTIVO $3,000 $18,000
010 09/02/2017 7 JEA-211 MOTO $1,000 $7,000
009 08/02/2017 8 JPA-906 PARTICULAR $4,500 $36,000
008 07/02/2017 9 JFR-128 PARTICULAR $4,500 $40,500
007 06/02/2017 10 HSM-315 PARTICULAR $4,500 $45,000
006 05/02/2017 11 WWW-882 TAXI $2,500 $27,500
005 04/02/2017 12 HRP-000 MOTO $1,000 $12,000
004 03/02/2017 13 BLN-210 PARTICULAR $4,500 $58,500
003 02/02/2017 14 ANA-520 PARTICULAR $4,500 $63,000
002 01/02/2017 15 TTZ-004 TAXI $2,500 $37,500
001 31/01/2017 16 OYK-089 PARTICULAR $4,500 $72,000
011 30/01/2017 17 PAM-815 COLECTIVO $3,000 $51,000
010 29/01/2017 18 JEA-211 MOTO $1,000 $18,000
009 28/01/2017 19 JPA-906 PARTICULAR $4,500 $85,500
008 27/01/2017 20 JFR-128 PARTICULAR $4,500 $90,000
007 26/01/2017 21 HSM-315 PARTICULAR $4,500 $94,500
006 25/01/2017 22 WWW-882 TAXI $2,500 $55,000
005 24/01/2017 23 HRP-000 MOTO $1,000 $23,000
004 23/01/2017 24 BLN-210 PARTICULAR $4,500 $108,000
003 22/01/2017 1 ANA-520 PARTICULAR $4,500 $4,500
002 21/01/2017 2 TTZ-004 TAXI $2,500 $5,000
001 20/01/2017 3 OYK-089 PARTICULAR $4,500 $13,500
011 19/01/2017 4 PAM-815 COLECTIVO $3,000 $12,000
010 18/01/2017 5 JEA-211 MOTO $1,000 $5,000
009 17/01/2017 6 JPA-906 PARTICULAR $4,500 $27,000
008 16/01/2017 7 JFR-128 PARTICULAR $4,500 $31,500
007 15/01/2017 8 HSM-315 PARTICULAR $4,500 $36,000
006 14/01/2017 9 WWW-882 TAXI $2,500 $22,500
005 13/01/2017 10 HRP-000 MOTO $1,000 $10,000
004 12/01/2017 11 BLN-210 PARTICULAR $4,500 $49,500
003 11/01/2017 12 ANA-520 PARTICULAR $4,500 $54,000
002 10/01/2017 13 TTZ-004 TAXI $2,500 $32,500
001 09/01/2017 14 OYK-089 PARTICULAR $4,500 $63,000
011 08/01/2017 15 PAM-815 COLECTIVO $3,000 $45,000
010 07/01/2017 16 JEA-211 MOTO $1,000 $16,000
009 06/01/2017 17 JPA-906 PARTICULAR $4,500 $76,500
008 05/01/2017 18 JFR-128 PARTICULAR $4,500 $81,000
007 04/01/2017 19 HSM-315 PARTICULAR $4,500 $85,500
006 03/01/2017 20 WWW-882 TAXI $2,500 $50,000
005 02/01/2017 21 HRP-000 MOTO $1,000 $21,000
004 01/01/2017 22 BLN-210 PARTICULAR $4,500 $99,000
003 31/12/2016 23 ANA-520 PARTICULAR $4,500 $103,500
002 30/12/2016 24 TTZ-004 TAXI $2,500 $60,000
001 29/12/2016 1 OYK-089 PARTICULAR $4,500 $4,500
011 28/12/2016 2 PAM-815 COLECTIVO $3,000 $6,000
010 27/12/2016 3 JEA-211 MOTO $1,000 $3,000
009 26/12/2016 4 JPA-906 PARTICULAR $4,500 $18,000
008 25/12/2016 5 JFR-128 PARTICULAR $4,500 $22,500
007 24/12/2016 6 HSM-315 PARTICULAR $4,500 $27,000
006 23/12/2016 7 WWW-882 TAXI $2,500 $17,500
005 22/12/2016 8 HRP-000 MOTO $1,000 $8,000
004 21/12/2016 9 BLN-210 PARTICULAR $4,500 $40,500
003 20/12/2016 10 ANA-520 PARTICULAR $4,500 $45,000
002 19/12/2016 11 TTZ-004 TAXI $2,500 $27,500
001 18/12/2016 12 OYK-089 PARTICULAR $4,500 $54,000
011 17/12/2016 13 PAM-815 COLECTIVO $3,000 $39,000
010 16/12/2016 14 JEA-211 MOTO $1,000 $14,000
009 15/12/2016 15 JPA-906 PARTICULAR $4,500 $67,500
008 14/12/2016 16 JFR-128 PARTICULAR $4,500 $72,000
007 13/12/2016 17 HSM-315 PARTICULAR $4,500 $76,500
006 12/12/2016 18 WWW-882 TAXI $2,500 $45,000
005 11/12/2016 19 HRP-000 MOTO $1,000 $19,000
004 10/12/2016 20 BLN-210 PARTICULAR $4,500 $90,000
003 09/12/2016 21 ANA-520 PARTICULAR $4,500 $94,500
002 08/12/2016 22 TTZ-004 TAXI $2,500 $55,000
001 07/12/2016 23 OYK-089 PARTICULAR $4,500 $103,500
011 06/12/2016 24 PAM-815 COLECTIVO $3,000 $72,000
010 05/12/2016 1 JEA-211 MOTO $1,000 $1,000
009 04/12/2016 2 JPA-906 PARTICULAR $4,500 $9,000
008 03/12/2016 3 JFR-128 PARTICULAR $4,500 $13,500
007 02/12/2016 4 HSM-315 PARTICULAR $4,500 $18,000
006 01/12/2016 5 WWW-882 TAXI $2,500 $12,500
005 30/11/2016 6 HRP-000 MOTO $1,000 $6,000
004 29/11/2016 7 BLN-210 PARTICULAR $4,500 $31,500
003 28/11/2016 8 ANA-520 PARTICULAR $4,500 $36,000
002 27/11/2016 9 TTZ-004 TAXI $2,500 $22,500
001 26/11/2016 10 OYK-089 PARTICULAR $4,500 $45,000
011 25/11/2016 11 PAM-815 COLECTIVO $3,000 $33,000
010 24/11/2016 12 JEA-211 MOTO $1,000 $12,000
009 23/11/2016 13 JPA-906 PARTICULAR $4,500 $58,500
008 22/11/2016 14 JFR-128 PARTICULAR $4,500 $63,000
007 21/11/2016 15 HSM-315 PARTICULAR $4,500 $67,500
006 20/11/2016 16 WWW-882 TAXI $2,500 $40,000
005 19/11/2016 17 HRP-000 MOTO $1,000 $17,000
004 18/11/2016 18 BLN-210 PARTICULAR $4,500 $81,000
003 17/11/2016 19 ANA-520 PARTICULAR $4,500 $85,500
002 16/11/2016 20 TTZ-004 TAXI $2,500 $50,000
001 15/11/2016 21 OYK-089 PARTICULAR $4,500 $94,500
011 14/11/2016 22 PAM-815 COLECTIVO $3,000 $66,000
010 13/11/2016 23 JEA-211 MOTO $1,000 $23,000
009 12/11/2016 24 JPA-906 PARTICULAR $4,500 $108,000
007 10/11/2016 1 HSM-315 PARTICULAR $4,500 $4,500
006 09/11/2016 2 WWW-882 TAXI $2,500 $5,000
005 08/11/2016 3 HRP-000 MOTO $1,000 $3,000
004 07/11/2016 4 BLN-210 PARTICULAR $4,500 $18,000
001 06/11/2016 5 OYK-089 PARTICULAR $4,500 $22,500
001 06/11/2016 6 OYK-089 PARTICULAR $4,500 $27,000
001 06/11/2016 7 OYK-089 PARTICULAR $4,500 $31,500
003 06/11/2016 8 ANA-520 PARTICULAR $4,500 $36,000
003 06/11/2016 9 ANA-520 PARTICULAR $4,500 $40,500
004 06/11/2016 10 BLN-210 PARTICULAR $4,500 $45,000
007 06/11/2016 11 HSM-315 PARTICULAR $4,500 $49,500
008 06/11/2016 12 JFR-128 PARTICULAR $4,500 $54,000
008 06/11/2016 13 JFR-128 PARTICULAR $4,500 $58,500
009 06/11/2016 14 JPA-906 PARTICULAR $4,500 $63,000
009 06/11/2016 15 JPA-906 PARTICULAR $4,500 $67,500
002 05/11/2016 16 TTZ-004 TAXI $2,500 $40,000
001 04/11/2016 17 OYK-089 PARTICULAR $4,500 $76,500
011 03/11/2016 18 PAM-815 COLECTIVO $3,000 $54,000
010 02/11/2016 19 JEA-211 MOTO $1,000 $19,000
008 31/10/2016 20 JFR-128 PARTICULAR $4,500 $90,000
007 30/10/2016 21 HSM-315 PARTICULAR $4,500 $94,500
006 29/10/2016 22 WWW-882 TAXI $2,500 $55,000
005 28/10/2016 23 HRP-000 MOTO $1,000 $23,000
004 27/10/2016 24 BLN-210 PARTICULAR $4,500 $108,000
003 26/10/2016 1 ANA-520 PARTICULAR $4,500 $4,500
002 25/10/2016 2 TTZ-004 TAXI $2,500 $5,000
011 23/10/2016 3 PAM-815 COLECTIVO $3,000 $9,000
010 22/10/2016 4 JEA-211 MOTO $1,000 $4,000
009 21/10/2016 5 JPA-906 PARTICULAR $4,500 $22,500
007 19/10/2016 6 HSM-315 PARTICULAR $4,500 $27,000
006 18/10/2016 7 WWW-882 TAXI $2,500 $17,500
005 17/10/2016 8 HRP-000 MOTO $1,000 $8,000
004 16/10/2016 9 BLN-210 PARTICULAR $4,500 $40,500
003 15/10/2016 10 ANA-520 PARTICULAR $4,500 $45,000
002 14/10/2016 11 TTZ-004 TAXI $2,500 $27,500
001 13/10/2016 12 OYK-089 PARTICULAR $4,500 $54,000
011 12/10/2016 13 PAM-815 COLECTIVO $3,000 $39,000
010 11/10/2016 14 JEA-211 MOTO $1,000 $14,000
008 09/10/2016 15 JFR-128 PARTICULAR $4,500 $67,500
007 08/10/2016 16 HSM-315 PARTICULAR $4,500 $72,000
006 07/10/2016 17 WWW-882 TAXI $2,500 $42,500
005 06/10/2016 18 HRP-000 MOTO $1,000 $18,000
004 05/10/2016 19 BLN-210 PARTICULAR $4,500 $85,500
003 04/10/2016 20 ANA-520 PARTICULAR $4,500 $90,000
002 03/10/2016 21 TTZ-004 TAXI $2,500 $52,500
002 01/10/2016 22 TTZ-004 TAXI $2,500 $55,000
005 01/10/2016 23 HRP-000 MOTO $1,000 $23,000
006 01/10/2016 24 WWW-882 TAXI $2,500 $60,000
008 01/10/2016 1 JFR-128 PARTICULAR $4,500 $4,500
009 01/10/2016 2 JPA-906 PARTICULAR $4,500 $9,000
010 01/10/2016 3 JEA-211 MOTO $1,000 $3,000
011 01/10/2016 4 PAM-815 COLECTIVO $3,000 $12,000
PROPIETARIO
2. El valor depende del tipo de vehiculo, si es
AMPARO CORREA
moto paga 1000, colectivo paga 3000,
PEDRO MATURANA particular 4500, taxi 2500, este valor es por
BLANCA GARCIA hora, se hace con la función si anidada.
CARLOS ANDRADE
ANA ANDRADE 3. Digite la cantidad de horas, pero antes las
valida para que permita mínimo 1 hasta 24.
PAOLA ANDRADE
ADRIAN BERNAL 4. Calcule el total.
JESUS RENTERIA A.
LINA MARIN
HECTOR MOSQUERA
ROBERTO GARCIA
PEDRO MATURANA
AMPARO CORREA
CARLOS ANDRADE
BLANCA GARCIA
PAOLA ANDRADE
ANA ANDRADE
JESUS RENTERIA A.
ADRIAN BERNAL
HECTOR MOSQUERA
LINA MARIN
ROBERTO GARCIA
AMPARO CORREA
PEDRO MATURANA
BLANCA GARCIA
CARLOS ANDRADE
ANA ANDRADE
PAOLA ANDRADE
ADRIAN BERNAL
JESUS RENTERIA A.
LINA MARIN
HECTOR MOSQUERA
ROBERTO GARCIA
PEDRO MATURANA
AMPARO CORREA
CARLOS ANDRADE
BLANCA GARCIA
PAOLA ANDRADE
ANA ANDRADE
JESUS RENTERIA A.
ADRIAN BERNAL
HECTOR MOSQUERA
LINA MARIN
ROBERTO GARCIA
AMPARO CORREA
PEDRO MATURANA
BLANCA GARCIA
CARLOS ANDRADE
ANA ANDRADE
PAOLA ANDRADE
ADRIAN BERNAL
JESUS RENTERIA A.
LINA MARIN
HECTOR MOSQUERA
ROBERTO GARCIA
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
LINA MARIN
LINA MARIN
LINA MARIN
ANA ANDRADE
ANA ANDRADE
BLANCA GARCIA
HECTOR MOSQUERA
JESUS RENTERIA A.
JESUS RENTERIA A.
PAOLA ANDRADE
PAOLA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
ADRIAN BERNAL
AMPARO CORREA
ROBERTO GARCIA
JESUS RENTERIA A.
PAOLA ANDRADE
CARLOS ANDRADE
PEDRO MATURANA
culo, si es
0,
es por
ada.

antes las
asta 24.

MENÚ
ESTADISTICA
# DE VEHICULOS
# DE PARTICULARES 120
# DE MOTOS 40
# DE COLECTIVOS 20 8. Utilizando la funciones estadistica
# DE TAXI 40 lo que se pide desde la B2 hasta B11
VALOR MAS CARO $108,000
VAOR MAS ECONOMICO $1,000
VALOR MEDIO $36,000
VALOR PROMEDIO $40,832
VALOR MAS COMUN $22,500
o la funciones estadisticas, se resuelve
de desde la B2 hasta B11.

MENÚ
MENÚ
# DE PARTICULARES 120 9. Traiga de la hoja estadisticas el resultado
# DE MOTOS 40 luego realice una grafica, con esta infomac
# DE COLECTIVOS 20 dicha gráfica debe quedar en la misma hoja
# DE TAXI 40

140

120

100

80

60

40

20

0
# DE PARTICULARES # DE M
a hoja estadisticas el resultado y
una grafica, con esta infomación,
debe quedar en la misma hoja.

Vehiculos
140

120

100 MENÚ
80

60

40

20

0
# DE PARTICULARES # DE MOTOS # DE COLECTIVOS # DE TAXI
MENÚ
# DE CELDA FECHA # DE HORAS PLACA VEHICULO VALOR HORA TOTAL
005 31/03/2017 1 HRP-000 MOTO $1,000 $1,000
004 30/03/2017 3 BLN-210 PARTICULAR $4,500 $13,500
010 30/03/2017 4 JEA-211 MOTO $1,000 $4,000
003 29/03/2017 5 ANA-520 PARTICULAR $4,500 $22,500
009 29/03/2017 6 JPA-906 PARTICULAR $4,500 $27,000
008 28/03/2017 8 JFR-128 PARTICULAR $4,500 $36,000
001 27/03/2017 9 OYK-089 PARTICULAR $4,500 $40,500
007 27/03/2017 10 HSM-315 PARTICULAR $4,500 $45,000
005 25/03/2017 13 HRP-000 MOTO $1,000 $13,000
010 25/03/2017 14 JEA-211 MOTO $1,000 $14,000
004 24/03/2017 15 BLN-210 PARTICULAR $4,500 $67,500
009 24/03/2017 16 JPA-906 PARTICULAR $4,500 $72,000
003 23/03/2017 17 ANA-520 PARTICULAR $4,500 $76,500
008 23/03/2017 18 JFR-128 PARTICULAR $4,500 $81,000
007 22/03/2017 20 HSM-315 PARTICULAR $4,500 $90,000
001 21/03/2017 21 OYK-089 PARTICULAR $4,500 $94,500
005 20/03/2017 23 HRP-000 MOTO $1,000 $23,000
004 19/03/2017 1 BLN-210 PARTICULAR $4,500 $4,500
010 19/03/2017 2 JEA-211 MOTO $1,000 $2,000
003 18/03/2017 3 ANA-520 PARTICULAR $4,500 $13,500
009 18/03/2017 4 JPA-906 PARTICULAR $4,500 $18,000
008 17/03/2017 6 JFR-128 PARTICULAR $4,500 $27,000
001 16/03/2017 7 OYK-089 PARTICULAR $4,500 $31,500
007 16/03/2017 8 HSM-315 PARTICULAR $4,500 $36,000
005 14/03/2017 11 HRP-000 MOTO $1,000 $11,000
010 14/03/2017 12 JEA-211 MOTO $1,000 $12,000
004 13/03/2017 13 BLN-210 PARTICULAR $4,500 $58,500
009 13/03/2017 14 JPA-906 PARTICULAR $4,500 $63,000
003 12/03/2017 15 ANA-520 PARTICULAR $4,500 $67,500
008 12/03/2017 16 JFR-128 PARTICULAR $4,500 $72,000
007 11/03/2017 18 HSM-315 PARTICULAR $4,500 $81,000
001 10/03/2017 19 OYK-089 PARTICULAR $4,500 $85,500
005 09/03/2017 21 HRP-000 MOTO $1,000 $21,000
004 08/03/2017 23 BLN-210 PARTICULAR $4,500 $103,500
010 08/03/2017 24 JEA-211 MOTO $1,000 $24,000
003 07/03/2017 1 ANA-520 PARTICULAR $4,500 $4,500
009 07/03/2017 2 JPA-906 PARTICULAR $4,500 $9,000
008 06/03/2017 4 JFR-128 PARTICULAR $4,500 $18,000
001 05/03/2017 5 OYK-089 PARTICULAR $4,500 $22,500
007 05/03/2017 6 HSM-315 PARTICULAR $4,500 $27,000
010 03/03/2017 9 JEA-211 MOTO $1,000 $9,000
009 02/03/2017 10 JPA-906 PARTICULAR $4,500 $45,000
008 01/03/2017 11 JFR-128 PARTICULAR $4,500 $49,500
007 28/02/2017 12 HSM-315 PARTICULAR $4,500 $54,000
005 26/02/2017 14 HRP-000 MOTO $1,000 $14,000
004 25/02/2017 15 BLN-210 PARTICULAR $4,500 $67,500
003 24/02/2017 16 ANA-520 PARTICULAR $4,500 $72,000
001 22/02/2017 18 OYK-089 PARTICULAR $4,500 $81,000
010 20/02/2017 20 JEA-211 MOTO $1,000 $20,000
009 19/02/2017 21 JPA-906 PARTICULAR $4,500 $94,500
008 18/02/2017 22 JFR-128 PARTICULAR $4,500 $99,000
007 17/02/2017 23 HSM-315 PARTICULAR $4,500 $103,500
005 15/02/2017 1 HRP-000 MOTO $1,000 $1,000
004 14/02/2017 2 BLN-210 PARTICULAR $4,500 $9,000
003 13/02/2017 3 ANA-520 PARTICULAR $4,500 $13,500
001 11/02/2017 5 OYK-089 PARTICULAR $4,500 $22,500
010 09/02/2017 7 JEA-211 MOTO $1,000 $7,000
009 08/02/2017 8 JPA-906 PARTICULAR $4,500 $36,000
008 07/02/2017 9 JFR-128 PARTICULAR $4,500 $40,500
007 06/02/2017 10 HSM-315 PARTICULAR $4,500 $45,000
005 04/02/2017 12 HRP-000 MOTO $1,000 $12,000
004 03/02/2017 13 BLN-210 PARTICULAR $4,500 $58,500
003 02/02/2017 14 ANA-520 PARTICULAR $4,500 $63,000
001 31/01/2017 16 OYK-089 PARTICULAR $4,500 $72,000
010 29/01/2017 18 JEA-211 MOTO $1,000 $18,000
009 28/01/2017 19 JPA-906 PARTICULAR $4,500 $85,500
008 27/01/2017 20 JFR-128 PARTICULAR $4,500 $90,000
007 26/01/2017 21 HSM-315 PARTICULAR $4,500 $94,500
005 24/01/2017 23 HRP-000 MOTO $1,000 $23,000
004 23/01/2017 24 BLN-210 PARTICULAR $4,500 $108,000
003 22/01/2017 1 ANA-520 PARTICULAR $4,500 $4,500
001 20/01/2017 3 OYK-089 PARTICULAR $4,500 $13,500
010 18/01/2017 5 JEA-211 MOTO $1,000 $5,000
009 17/01/2017 6 JPA-906 PARTICULAR $4,500 $27,000
008 16/01/2017 7 JFR-128 PARTICULAR $4,500 $31,500
007 15/01/2017 8 HSM-315 PARTICULAR $4,500 $36,000
005 13/01/2017 10 HRP-000 MOTO $1,000 $10,000
004 12/01/2017 11 BLN-210 PARTICULAR $4,500 $49,500
003 11/01/2017 12 ANA-520 PARTICULAR $4,500 $54,000
001 09/01/2017 14 OYK-089 PARTICULAR $4,500 $63,000
010 07/01/2017 16 JEA-211 MOTO $1,000 $16,000
009 06/01/2017 17 JPA-906 PARTICULAR $4,500 $76,500
008 05/01/2017 18 JFR-128 PARTICULAR $4,500 $81,000
007 04/01/2017 19 HSM-315 PARTICULAR $4,500 $85,500
005 02/01/2017 21 HRP-000 MOTO $1,000 $21,000
004 01/01/2017 22 BLN-210 PARTICULAR $4,500 $99,000
003 31/12/2016 23 ANA-520 PARTICULAR $4,500 $103,500
001 29/12/2016 1 OYK-089 PARTICULAR $4,500 $4,500
010 27/12/2016 3 JEA-211 MOTO $1,000 $3,000
009 26/12/2016 4 JPA-906 PARTICULAR $4,500 $18,000
008 25/12/2016 5 JFR-128 PARTICULAR $4,500 $22,500
007 24/12/2016 6 HSM-315 PARTICULAR $4,500 $27,000
005 22/12/2016 8 HRP-000 MOTO $1,000 $8,000
004 21/12/2016 9 BLN-210 PARTICULAR $4,500 $40,500
003 20/12/2016 10 ANA-520 PARTICULAR $4,500 $45,000
001 18/12/2016 12 OYK-089 PARTICULAR $4,500 $54,000
010 16/12/2016 14 JEA-211 MOTO $1,000 $14,000
009 15/12/2016 15 JPA-906 PARTICULAR $4,500 $67,500
008 14/12/2016 16 JFR-128 PARTICULAR $4,500 $72,000
007 13/12/2016 17 HSM-315 PARTICULAR $4,500 $76,500
005 11/12/2016 19 HRP-000 MOTO $1,000 $19,000
004 10/12/2016 20 BLN-210 PARTICULAR $4,500 $90,000
003 09/12/2016 21 ANA-520 PARTICULAR $4,500 $94,500
001 07/12/2016 23 OYK-089 PARTICULAR $4,500 $103,500
010 05/12/2016 1 JEA-211 MOTO $1,000 $1,000
009 04/12/2016 2 JPA-906 PARTICULAR $4,500 $9,000
008 03/12/2016 3 JFR-128 PARTICULAR $4,500 $13,500
007 02/12/2016 4 HSM-315 PARTICULAR $4,500 $18,000
005 30/11/2016 6 HRP-000 MOTO $1,000 $6,000
004 29/11/2016 7 BLN-210 PARTICULAR $4,500 $31,500
003 28/11/2016 8 ANA-520 PARTICULAR $4,500 $36,000
001 26/11/2016 10 OYK-089 PARTICULAR $4,500 $45,000
010 24/11/2016 12 JEA-211 MOTO $1,000 $12,000
009 23/11/2016 13 JPA-906 PARTICULAR $4,500 $58,500
008 22/11/2016 14 JFR-128 PARTICULAR $4,500 $63,000
007 21/11/2016 15 HSM-315 PARTICULAR $4,500 $67,500
005 19/11/2016 17 HRP-000 MOTO $1,000 $17,000
004 18/11/2016 18 BLN-210 PARTICULAR $4,500 $81,000
003 17/11/2016 19 ANA-520 PARTICULAR $4,500 $85,500
001 15/11/2016 21 OYK-089 PARTICULAR $4,500 $94,500
010 13/11/2016 23 JEA-211 MOTO $1,000 $23,000
009 12/11/2016 24 JPA-906 PARTICULAR $4,500 $108,000
007 10/11/2016 1 HSM-315 PARTICULAR $4,500 $4,500
005 08/11/2016 3 HRP-000 MOTO $1,000 $3,000
004 07/11/2016 4 BLN-210 PARTICULAR $4,500 $18,000
001 06/11/2016 5 OYK-089 PARTICULAR $4,500 $22,500
001 06/11/2016 6 OYK-089 PARTICULAR $4,500 $27,000
001 06/11/2016 7 OYK-089 PARTICULAR $4,500 $31,500
003 06/11/2016 8 ANA-520 PARTICULAR $4,500 $36,000
003 06/11/2016 9 ANA-520 PARTICULAR $4,500 $40,500
004 06/11/2016 10 BLN-210 PARTICULAR $4,500 $45,000
007 06/11/2016 11 HSM-315 PARTICULAR $4,500 $49,500
008 06/11/2016 12 JFR-128 PARTICULAR $4,500 $54,000
008 06/11/2016 13 JFR-128 PARTICULAR $4,500 $58,500
009 06/11/2016 14 JPA-906 PARTICULAR $4,500 $63,000
009 06/11/2016 15 JPA-906 PARTICULAR $4,500 $67,500
001 04/11/2016 17 OYK-089 PARTICULAR $4,500 $76,500
010 02/11/2016 19 JEA-211 MOTO $1,000 $19,000
008 31/10/2016 20 JFR-128 PARTICULAR $4,500 $90,000
007 30/10/2016 21 HSM-315 PARTICULAR $4,500 $94,500
005 28/10/2016 23 HRP-000 MOTO $1,000 $23,000
004 27/10/2016 24 BLN-210 PARTICULAR $4,500 $108,000
003 26/10/2016 1 ANA-520 PARTICULAR $4,500 $4,500
010 22/10/2016 4 JEA-211 MOTO $1,000 $4,000
009 21/10/2016 5 JPA-906 PARTICULAR $4,500 $22,500
007 19/10/2016 6 HSM-315 PARTICULAR $4,500 $27,000
005 17/10/2016 8 HRP-000 MOTO $1,000 $8,000
004 16/10/2016 9 BLN-210 PARTICULAR $4,500 $40,500
003 15/10/2016 10 ANA-520 PARTICULAR $4,500 $45,000
001 13/10/2016 12 OYK-089 PARTICULAR $4,500 $54,000
010 11/10/2016 14 JEA-211 MOTO $1,000 $14,000
008 09/10/2016 15 JFR-128 PARTICULAR $4,500 $67,500
007 08/10/2016 16 HSM-315 PARTICULAR $4,500 $72,000
005 06/10/2016 18 HRP-000 MOTO $1,000 $18,000
004 05/10/2016 19 BLN-210 PARTICULAR $4,500 $85,500
003 04/10/2016 20 ANA-520 PARTICULAR $4,500 $90,000
005 01/10/2016 23 HRP-000 MOTO $1,000 $23,000
008 01/10/2016 1 JFR-128 PARTICULAR $4,500 $4,500
009 01/10/2016 2 JPA-906 PARTICULAR $4,500 $9,000
010 01/10/2016 3 JEA-211 MOTO $1,000 $3,000
PROPIETARIO
10. Realice un filtro que muestre los vehiculos,
AMPARO CORREA
motos y particular.
BLANCA GARCIA
CARLOS ANDRADE
ANA ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
LINA MARIN
HECTOR MOSQUERA
AMPARO CORREA
CARLOS ANDRADE
BLANCA GARCIA
PAOLA ANDRADE
ANA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
LINA MARIN
AMPARO CORREA
BLANCA GARCIA
CARLOS ANDRADE
ANA ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
LINA MARIN
HECTOR MOSQUERA
AMPARO CORREA
CARLOS ANDRADE
BLANCA GARCIA
PAOLA ANDRADE
ANA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
LINA MARIN
AMPARO CORREA
BLANCA GARCIA
CARLOS ANDRADE
ANA ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
LINA MARIN
HECTOR MOSQUERA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
LINA MARIN
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
LINA MARIN
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
LINA MARIN
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
LINA MARIN
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
LINA MARIN
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
LINA MARIN
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
LINA MARIN
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
LINA MARIN
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
LINA MARIN
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
LINA MARIN
CARLOS ANDRADE
PAOLA ANDRADE
HECTOR MOSQUERA
AMPARO CORREA
BLANCA GARCIA
LINA MARIN
LINA MARIN
LINA MARIN
ANA ANDRADE
ANA ANDRADE
BLANCA GARCIA
HECTOR MOSQUERA
JESUS RENTERIA A.
JESUS RENTERIA A.
PAOLA ANDRADE
PAOLA ANDRADE
LINA MARIN
CARLOS ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
CARLOS ANDRADE
PAOLA ANDRADE
HECTOR MOSQUERA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
LINA MARIN
CARLOS ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
AMPARO CORREA
JESUS RENTERIA A.
PAOLA ANDRADE
CARLOS ANDRADE
s vehiculos,

MENÚ
# DE CELDA FECHA # DE HORAS PLACA VEHICULO VALOR HORA TOTAL
005 31/03/2017 1 HRP-000 MOTO $1,000 $1,000
011 31/03/2017 2 PAM-815 COLECTIVO $3,000 $6,000
004 30/03/2017 3 BLN-210 PARTICULAR $4,500 $13,500
010 30/03/2017 4 JEA-211 MOTO $1,000 $4,000
003 29/03/2017 5 ANA-520 PARTICULAR $4,500 $22,500
009 29/03/2017 6 JPA-906 PARTICULAR $4,500 $27,000
002 28/03/2017 7 TTZ-004 TAXI $2,500 $17,500
008 28/03/2017 8 JFR-128 PARTICULAR $4,500 $36,000
001 27/03/2017 9 OYK-089 PARTICULAR $4,500 $40,500
007 27/03/2017 10 HSM-315 PARTICULAR $4,500 $45,000
006 26/03/2017 11 WWW-882 TAXI $2,500 $27,500
011 26/03/2017 12 PAM-815 COLECTIVO $3,000 $36,000
005 25/03/2017 13 HRP-000 MOTO $1,000 $13,000
010 25/03/2017 14 JEA-211 MOTO $1,000 $14,000
004 24/03/2017 15 BLN-210 PARTICULAR $4,500 $67,500
009 24/03/2017 16 JPA-906 PARTICULAR $4,500 $72,000
003 23/03/2017 17 ANA-520 PARTICULAR $4,500 $76,500
008 23/03/2017 18 JFR-128 PARTICULAR $4,500 $81,000
002 22/03/2017 19 TTZ-004 TAXI $2,500 $47,500
007 22/03/2017 20 HSM-315 PARTICULAR $4,500 $90,000
001 21/03/2017 21 OYK-089 PARTICULAR $4,500 $94,500
006 21/03/2017 22 WWW-882 TAXI $2,500 $55,000
005 20/03/2017 23 HRP-000 MOTO $1,000 $23,000
011 20/03/2017 24 PAM-815 COLECTIVO $3,000 $72,000
004 19/03/2017 1 BLN-210 PARTICULAR $4,500 $4,500
010 19/03/2017 2 JEA-211 MOTO $1,000 $2,000
003 18/03/2017 3 ANA-520 PARTICULAR $4,500 $13,500
009 18/03/2017 4 JPA-906 PARTICULAR $4,500 $18,000
002 17/03/2017 5 TTZ-004 TAXI $2,500 $12,500
008 17/03/2017 6 JFR-128 PARTICULAR $4,500 $27,000
001 16/03/2017 7 OYK-089 PARTICULAR $4,500 $31,500
007 16/03/2017 8 HSM-315 PARTICULAR $4,500 $36,000
006 15/03/2017 9 WWW-882 TAXI $2,500 $22,500
011 15/03/2017 10 PAM-815 COLECTIVO $3,000 $30,000
005 14/03/2017 11 HRP-000 MOTO $1,000 $11,000
010 14/03/2017 12 JEA-211 MOTO $1,000 $12,000
004 13/03/2017 13 BLN-210 PARTICULAR $4,500 $58,500
009 13/03/2017 14 JPA-906 PARTICULAR $4,500 $63,000
003 12/03/2017 15 ANA-520 PARTICULAR $4,500 $67,500
008 12/03/2017 16 JFR-128 PARTICULAR $4,500 $72,000
002 11/03/2017 17 TTZ-004 TAXI $2,500 $42,500
007 11/03/2017 18 HSM-315 PARTICULAR $4,500 $81,000
001 10/03/2017 19 OYK-089 PARTICULAR $4,500 $85,500
006 10/03/2017 20 WWW-882 TAXI $2,500 $50,000
005 09/03/2017 21 HRP-000 MOTO $1,000 $21,000
011 09/03/2017 22 PAM-815 COLECTIVO $3,000 $66,000
004 08/03/2017 23 BLN-210 PARTICULAR $4,500 $103,500
010 08/03/2017 24 JEA-211 MOTO $1,000 $24,000
003 07/03/2017 1 ANA-520 PARTICULAR $4,500 $4,500
009 07/03/2017 2 JPA-906 PARTICULAR $4,500 $9,000
002 06/03/2017 3 TTZ-004 TAXI $2,500 $7,500
008 06/03/2017 4 JFR-128 PARTICULAR $4,500 $18,000
001 05/03/2017 5 OYK-089 PARTICULAR $4,500 $22,500
007 05/03/2017 6 HSM-315 PARTICULAR $4,500 $27,000
006 04/03/2017 7 WWW-882 TAXI $2,500 $17,500
011 04/03/2017 8 PAM-815 COLECTIVO $3,000 $24,000
010 03/03/2017 9 JEA-211 MOTO $1,000 $9,000
009 02/03/2017 10 JPA-906 PARTICULAR $4,500 $45,000
008 01/03/2017 11 JFR-128 PARTICULAR $4,500 $49,500
007 28/02/2017 12 HSM-315 PARTICULAR $4,500 $54,000
006 27/02/2017 13 WWW-882 TAXI $2,500 $32,500
005 26/02/2017 14 HRP-000 MOTO $1,000 $14,000
004 25/02/2017 15 BLN-210 PARTICULAR $4,500 $67,500
003 24/02/2017 16 ANA-520 PARTICULAR $4,500 $72,000
002 23/02/2017 17 TTZ-004 TAXI $2,500 $42,500
001 22/02/2017 18 OYK-089 PARTICULAR $4,500 $81,000
011 21/02/2017 19 PAM-815 COLECTIVO $3,000 $57,000
010 20/02/2017 20 JEA-211 MOTO $1,000 $20,000
009 19/02/2017 21 JPA-906 PARTICULAR $4,500 $94,500
008 18/02/2017 22 JFR-128 PARTICULAR $4,500 $99,000
007 17/02/2017 23 HSM-315 PARTICULAR $4,500 $103,500
006 16/02/2017 24 WWW-882 TAXI $2,500 $60,000
005 15/02/2017 1 HRP-000 MOTO $1,000 $1,000
004 14/02/2017 2 BLN-210 PARTICULAR $4,500 $9,000
003 13/02/2017 3 ANA-520 PARTICULAR $4,500 $13,500
002 12/02/2017 4 TTZ-004 TAXI $2,500 $10,000
001 11/02/2017 5 OYK-089 PARTICULAR $4,500 $22,500
011 10/02/2017 6 PAM-815 COLECTIVO $3,000 $18,000
010 09/02/2017 7 JEA-211 MOTO $1,000 $7,000
009 08/02/2017 8 JPA-906 PARTICULAR $4,500 $36,000
008 07/02/2017 9 JFR-128 PARTICULAR $4,500 $40,500
007 06/02/2017 10 HSM-315 PARTICULAR $4,500 $45,000
006 05/02/2017 11 WWW-882 TAXI $2,500 $27,500
005 04/02/2017 12 HRP-000 MOTO $1,000 $12,000
004 03/02/2017 13 BLN-210 PARTICULAR $4,500 $58,500
003 02/02/2017 14 ANA-520 PARTICULAR $4,500 $63,000
002 01/02/2017 15 TTZ-004 TAXI $2,500 $37,500
001 31/01/2017 16 OYK-089 PARTICULAR $4,500 $72,000
011 30/01/2017 17 PAM-815 COLECTIVO $3,000 $51,000
010 29/01/2017 18 JEA-211 MOTO $1,000 $18,000
009 28/01/2017 19 JPA-906 PARTICULAR $4,500 $85,500
008 27/01/2017 20 JFR-128 PARTICULAR $4,500 $90,000
007 26/01/2017 21 HSM-315 PARTICULAR $4,500 $94,500
006 25/01/2017 22 WWW-882 TAXI $2,500 $55,000
005 24/01/2017 23 HRP-000 MOTO $1,000 $23,000
004 23/01/2017 24 BLN-210 PARTICULAR $4,500 $108,000
003 22/01/2017 1 ANA-520 PARTICULAR $4,500 $4,500
002 21/01/2017 2 TTZ-004 TAXI $2,500 $5,000
001 20/01/2017 3 OYK-089 PARTICULAR $4,500 $13,500
011 19/01/2017 4 PAM-815 COLECTIVO $3,000 $12,000
010 18/01/2017 5 JEA-211 MOTO $1,000 $5,000
009 17/01/2017 6 JPA-906 PARTICULAR $4,500 $27,000
008 16/01/2017 7 JFR-128 PARTICULAR $4,500 $31,500
007 15/01/2017 8 HSM-315 PARTICULAR $4,500 $36,000
006 14/01/2017 9 WWW-882 TAXI $2,500 $22,500
005 13/01/2017 10 HRP-000 MOTO $1,000 $10,000
004 12/01/2017 11 BLN-210 PARTICULAR $4,500 $49,500
003 11/01/2017 12 ANA-520 PARTICULAR $4,500 $54,000
002 10/01/2017 13 TTZ-004 TAXI $2,500 $32,500
001 09/01/2017 14 OYK-089 PARTICULAR $4,500 $63,000
011 08/01/2017 15 PAM-815 COLECTIVO $3,000 $45,000
010 07/01/2017 16 JEA-211 MOTO $1,000 $16,000
009 06/01/2017 17 JPA-906 PARTICULAR $4,500 $76,500
008 05/01/2017 18 JFR-128 PARTICULAR $4,500 $81,000
007 04/01/2017 19 HSM-315 PARTICULAR $4,500 $85,500
006 03/01/2017 20 WWW-882 TAXI $2,500 $50,000
005 02/01/2017 21 HRP-000 MOTO $1,000 $21,000
004 01/01/2017 22 BLN-210 PARTICULAR $4,500 $99,000
003 31/12/2016 23 ANA-520 PARTICULAR $4,500 $103,500
002 30/12/2016 24 TTZ-004 TAXI $2,500 $60,000
001 29/12/2016 1 OYK-089 PARTICULAR $4,500 $4,500
011 28/12/2016 2 PAM-815 COLECTIVO $3,000 $6,000
010 27/12/2016 3 JEA-211 MOTO $1,000 $3,000
009 26/12/2016 4 JPA-906 PARTICULAR $4,500 $18,000
008 25/12/2016 5 JFR-128 PARTICULAR $4,500 $22,500
007 24/12/2016 6 HSM-315 PARTICULAR $4,500 $27,000
006 23/12/2016 7 WWW-882 TAXI $2,500 $17,500
005 22/12/2016 8 HRP-000 MOTO $1,000 $8,000
004 21/12/2016 9 BLN-210 PARTICULAR $4,500 $40,500
003 20/12/2016 10 ANA-520 PARTICULAR $4,500 $45,000
002 19/12/2016 11 TTZ-004 TAXI $2,500 $27,500
001 18/12/2016 12 OYK-089 PARTICULAR $4,500 $54,000
011 17/12/2016 13 PAM-815 COLECTIVO $3,000 $39,000
010 16/12/2016 14 JEA-211 MOTO $1,000 $14,000
009 15/12/2016 15 JPA-906 PARTICULAR $4,500 $67,500
008 14/12/2016 16 JFR-128 PARTICULAR $4,500 $72,000
007 13/12/2016 17 HSM-315 PARTICULAR $4,500 $76,500
006 12/12/2016 18 WWW-882 TAXI $2,500 $45,000
005 11/12/2016 19 HRP-000 MOTO $1,000 $19,000
004 10/12/2016 20 BLN-210 PARTICULAR $4,500 $90,000
003 09/12/2016 21 ANA-520 PARTICULAR $4,500 $94,500
002 08/12/2016 22 TTZ-004 TAXI $2,500 $55,000
001 07/12/2016 23 OYK-089 PARTICULAR $4,500 $103,500
011 06/12/2016 24 PAM-815 COLECTIVO $3,000 $72,000
010 05/12/2016 1 JEA-211 MOTO $1,000 $1,000
009 04/12/2016 2 JPA-906 PARTICULAR $4,500 $9,000
008 03/12/2016 3 JFR-128 PARTICULAR $4,500 $13,500
007 02/12/2016 4 HSM-315 PARTICULAR $4,500 $18,000
006 01/12/2016 5 WWW-882 TAXI $2,500 $12,500
005 30/11/2016 6 HRP-000 MOTO $1,000 $6,000
004 29/11/2016 7 BLN-210 PARTICULAR $4,500 $31,500
003 28/11/2016 8 ANA-520 PARTICULAR $4,500 $36,000
002 27/11/2016 9 TTZ-004 TAXI $2,500 $22,500
001 26/11/2016 10 OYK-089 PARTICULAR $4,500 $45,000
011 25/11/2016 11 PAM-815 COLECTIVO $3,000 $33,000
010 24/11/2016 12 JEA-211 MOTO $1,000 $12,000
009 23/11/2016 13 JPA-906 PARTICULAR $4,500 $58,500
008 22/11/2016 14 JFR-128 PARTICULAR $4,500 $63,000
007 21/11/2016 15 HSM-315 PARTICULAR $4,500 $67,500
006 20/11/2016 16 WWW-882 TAXI $2,500 $40,000
005 19/11/2016 17 HRP-000 MOTO $1,000 $17,000
004 18/11/2016 18 BLN-210 PARTICULAR $4,500 $81,000
003 17/11/2016 19 ANA-520 PARTICULAR $4,500 $85,500
002 16/11/2016 20 TTZ-004 TAXI $2,500 $50,000
001 15/11/2016 21 OYK-089 PARTICULAR $4,500 $94,500
011 14/11/2016 22 PAM-815 COLECTIVO $3,000 $66,000
010 13/11/2016 23 JEA-211 MOTO $1,000 $23,000
009 12/11/2016 24 JPA-906 PARTICULAR $4,500 $108,000
007 10/11/2016 1 HSM-315 PARTICULAR $4,500 $4,500
006 09/11/2016 2 WWW-882 TAXI $2,500 $5,000
005 08/11/2016 3 HRP-000 MOTO $1,000 $3,000
004 07/11/2016 4 BLN-210 PARTICULAR $4,500 $18,000
001 06/11/2016 5 OYK-089 PARTICULAR $4,500 $22,500
001 06/11/2016 6 OYK-089 PARTICULAR $4,500 $27,000
001 06/11/2016 7 OYK-089 PARTICULAR $4,500 $31,500
003 06/11/2016 8 ANA-520 PARTICULAR $4,500 $36,000
003 06/11/2016 9 ANA-520 PARTICULAR $4,500 $40,500
004 06/11/2016 10 BLN-210 PARTICULAR $4,500 $45,000
007 06/11/2016 11 HSM-315 PARTICULAR $4,500 $49,500
008 06/11/2016 12 JFR-128 PARTICULAR $4,500 $54,000
008 06/11/2016 13 JFR-128 PARTICULAR $4,500 $58,500
009 06/11/2016 14 JPA-906 PARTICULAR $4,500 $63,000
009 06/11/2016 15 JPA-906 PARTICULAR $4,500 $67,500
002 05/11/2016 16 TTZ-004 TAXI $2,500 $40,000
001 04/11/2016 17 OYK-089 PARTICULAR $4,500 $76,500
011 03/11/2016 18 PAM-815 COLECTIVO $3,000 $54,000
010 02/11/2016 19 JEA-211 MOTO $1,000 $19,000
008 31/10/2016 20 JFR-128 PARTICULAR $4,500 $90,000
007 30/10/2016 21 HSM-315 PARTICULAR $4,500 $94,500
006 29/10/2016 22 WWW-882 TAXI $2,500 $55,000
005 28/10/2016 23 HRP-000 MOTO $1,000 $23,000
004 27/10/2016 24 BLN-210 PARTICULAR $4,500 $108,000
003 26/10/2016 1 ANA-520 PARTICULAR $4,500 $4,500
002 25/10/2016 2 TTZ-004 TAXI $2,500 $5,000
011 23/10/2016 3 PAM-815 COLECTIVO $3,000 $9,000
010 22/10/2016 4 JEA-211 MOTO $1,000 $4,000
009 21/10/2016 5 JPA-906 PARTICULAR $4,500 $22,500
007 19/10/2016 6 HSM-315 PARTICULAR $4,500 $27,000
006 18/10/2016 7 WWW-882 TAXI $2,500 $17,500
005 17/10/2016 8 HRP-000 MOTO $1,000 $8,000
004 16/10/2016 9 BLN-210 PARTICULAR $4,500 $40,500
003 15/10/2016 10 ANA-520 PARTICULAR $4,500 $45,000
002 14/10/2016 11 TTZ-004 TAXI $2,500 $27,500
001 13/10/2016 12 OYK-089 PARTICULAR $4,500 $54,000
011 12/10/2016 13 PAM-815 COLECTIVO $3,000 $39,000
010 11/10/2016 14 JEA-211 MOTO $1,000 $14,000
008 09/10/2016 15 JFR-128 PARTICULAR $4,500 $67,500
007 08/10/2016 16 HSM-315 PARTICULAR $4,500 $72,000
006 07/10/2016 17 WWW-882 TAXI $2,500 $42,500
005 06/10/2016 18 HRP-000 MOTO $1,000 $18,000
004 05/10/2016 19 BLN-210 PARTICULAR $4,500 $85,500
003 04/10/2016 20 ANA-520 PARTICULAR $4,500 $90,000
002 03/10/2016 21 TTZ-004 TAXI $2,500 $52,500
002 01/10/2016 22 TTZ-004 TAXI $2,500 $55,000
005 01/10/2016 23 HRP-000 MOTO $1,000 $23,000
006 01/10/2016 24 WWW-882 TAXI $2,500 $60,000
008 01/10/2016 1 JFR-128 PARTICULAR $4,500 $4,500
009 01/10/2016 2 JPA-906 PARTICULAR $4,500 $9,000
010 01/10/2016 3 JEA-211 MOTO $1,000 $3,000
011 01/10/2016 4 PAM-815 COLECTIVO $3,000 $12,000
PROPIETARIO
11. Realice un filtro avanzdo que muestre los
AMPARO CORREA
vehiculos, motos y particular.
PEDRO MATURANA
BLANCA GARCIA
CARLOS ANDRADE
ANA ANDRADE
PAOLA ANDRADE
ADRIAN BERNAL
JESUS RENTERIA A.
LINA MARIN
HECTOR MOSQUERA
ROBERTO GARCIA
PEDRO MATURANA
AMPARO CORREA
CARLOS ANDRADE
BLANCA GARCIA
PAOLA ANDRADE
ANA ANDRADE
JESUS RENTERIA A.
ADRIAN BERNAL
HECTOR MOSQUERA
LINA MARIN
ROBERTO GARCIA
AMPARO CORREA
PEDRO MATURANA
BLANCA GARCIA
CARLOS ANDRADE
ANA ANDRADE
PAOLA ANDRADE
ADRIAN BERNAL
JESUS RENTERIA A.
LINA MARIN
HECTOR MOSQUERA
ROBERTO GARCIA
PEDRO MATURANA
AMPARO CORREA
CARLOS ANDRADE
BLANCA GARCIA
PAOLA ANDRADE
ANA ANDRADE
JESUS RENTERIA A.
ADRIAN BERNAL
HECTOR MOSQUERA
LINA MARIN
ROBERTO GARCIA
AMPARO CORREA
PEDRO MATURANA
BLANCA GARCIA
CARLOS ANDRADE
ANA ANDRADE
PAOLA ANDRADE
ADRIAN BERNAL
JESUS RENTERIA A.
LINA MARIN
HECTOR MOSQUERA
ROBERTO GARCIA
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
LINA MARIN
LINA MARIN
LINA MARIN
ANA ANDRADE
ANA ANDRADE
BLANCA GARCIA
HECTOR MOSQUERA
JESUS RENTERIA A.
JESUS RENTERIA A.
PAOLA ANDRADE
PAOLA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
ADRIAN BERNAL
AMPARO CORREA
ROBERTO GARCIA
JESUS RENTERIA A.
PAOLA ANDRADE
CARLOS ANDRADE
PEDRO MATURANA
uestre los

# DE CELDA FECHA # DE HORAS PLACA VEHICULO VALOR HORA TOTAL


005 31/03/2017 1 HRP-000 MOTO $1,000 $1,000
011 31/03/2017 2 PAM-815 COLECTIVO $3,000 $6,000
004 30/03/2017 3 BLN-210 PARTICULAR $4,500 $13,500
010 30/03/2017 4 JEA-211 MOTO $1,000 $4,000
003 29/03/2017 5 ANA-520 PARTICULAR $4,500 $22,500
009 29/03/2017 6 JPA-906 PARTICULAR $4,500 $27,000
002 28/03/2017 7 TTZ-004 TAXI $2,500 $17,500
008 28/03/2017 8 JFR-128 PARTICULAR $4,500 $36,000
001 27/03/2017 9 OYK-089 PARTICULAR $4,500 $40,500
007 27/03/2017 10 HSM-315 PARTICULAR $4,500 $45,000
006 26/03/2017 11 WWW-882 TAXI $2,500 $27,500
011 26/03/2017 12 PAM-815 COLECTIVO $3,000 $36,000
005 25/03/2017 13 HRP-000 MOTO $1,000 $13,000
010 25/03/2017 14 JEA-211 MOTO $1,000 $14,000
004 24/03/2017 15 BLN-210 PARTICULAR $4,500 $67,500
009 24/03/2017 16 JPA-906 PARTICULAR $4,500 $72,000
003 23/03/2017 17 ANA-520 PARTICULAR $4,500 $76,500
008 23/03/2017 18 JFR-128 PARTICULAR $4,500 $81,000
002 22/03/2017 19 TTZ-004 TAXI $2,500 $47,500
007 22/03/2017 20 HSM-315 PARTICULAR $4,500 $90,000
001 21/03/2017 21 OYK-089 PARTICULAR $4,500 $94,500
006 21/03/2017 22 WWW-882 TAXI $2,500 $55,000
005 20/03/2017 23 HRP-000 MOTO $1,000 $23,000
011 20/03/2017 24 PAM-815 COLECTIVO $3,000 $72,000
004 19/03/2017 1 BLN-210 PARTICULAR $4,500 $4,500
010 19/03/2017 2 JEA-211 MOTO $1,000 $2,000
003 18/03/2017 3 ANA-520 PARTICULAR $4,500 $13,500
009 18/03/2017 4 JPA-906 PARTICULAR $4,500 $18,000
002 17/03/2017 5 TTZ-004 TAXI $2,500 $12,500
008 17/03/2017 6 JFR-128 PARTICULAR $4,500 $27,000
001 16/03/2017 7 OYK-089 PARTICULAR $4,500 $31,500
007 16/03/2017 8 HSM-315 PARTICULAR $4,500 $36,000
006 15/03/2017 9 WWW-882 TAXI $2,500 $22,500
011 15/03/2017 10 PAM-815 COLECTIVO $3,000 $30,000
005 14/03/2017 11 HRP-000 MOTO $1,000 $11,000
010 14/03/2017 12 JEA-211 MOTO $1,000 $12,000
004 13/03/2017 13 BLN-210 PARTICULAR $4,500 $58,500
009 13/03/2017 14 JPA-906 PARTICULAR $4,500 $63,000
003 12/03/2017 15 ANA-520 PARTICULAR $4,500 $67,500
008 12/03/2017 16 JFR-128 PARTICULAR $4,500 $72,000
002 11/03/2017 17 TTZ-004 TAXI $2,500 $42,500
007 11/03/2017 18 HSM-315 PARTICULAR $4,500 $81,000
001 10/03/2017 19 OYK-089 PARTICULAR $4,500 $85,500
006 10/03/2017 20 WWW-882 TAXI $2,500 $50,000
005 09/03/2017 21 HRP-000 MOTO $1,000 $21,000
011 09/03/2017 22 PAM-815 COLECTIVO $3,000 $66,000
004 08/03/2017 23 BLN-210 PARTICULAR $4,500 $103,500
010 08/03/2017 24 JEA-211 MOTO $1,000 $24,000
003 07/03/2017 1 ANA-520 PARTICULAR $4,500 $4,500
009 07/03/2017 2 JPA-906 PARTICULAR $4,500 $9,000
002 06/03/2017 3 TTZ-004 TAXI $2,500 $7,500
008 06/03/2017 4 JFR-128 PARTICULAR $4,500 $18,000
001 05/03/2017 5 OYK-089 PARTICULAR $4,500 $22,500
007 05/03/2017 6 HSM-315 PARTICULAR $4,500 $27,000
006 04/03/2017 7 WWW-882 TAXI $2,500 $17,500
011 04/03/2017 8 PAM-815 COLECTIVO $3,000 $24,000
010 03/03/2017 9 JEA-211 MOTO $1,000 $9,000
009 02/03/2017 10 JPA-906 PARTICULAR $4,500 $45,000
008 01/03/2017 11 JFR-128 PARTICULAR $4,500 $49,500
007 28/02/2017 12 HSM-315 PARTICULAR $4,500 $54,000
006 27/02/2017 13 WWW-882 TAXI $2,500 $32,500
005 26/02/2017 14 HRP-000 MOTO $1,000 $14,000
004 25/02/2017 15 BLN-210 PARTICULAR $4,500 $67,500
003 24/02/2017 16 ANA-520 PARTICULAR $4,500 $72,000
002 23/02/2017 17 TTZ-004 TAXI $2,500 $42,500
001 22/02/2017 18 OYK-089 PARTICULAR $4,500 $81,000
011 21/02/2017 19 PAM-815 COLECTIVO $3,000 $57,000
010 20/02/2017 20 JEA-211 MOTO $1,000 $20,000
009 19/02/2017 21 JPA-906 PARTICULAR $4,500 $94,500
008 18/02/2017 22 JFR-128 PARTICULAR $4,500 $99,000
007 17/02/2017 23 HSM-315 PARTICULAR $4,500 $103,500
006 16/02/2017 24 WWW-882 TAXI $2,500 $60,000
005 15/02/2017 1 HRP-000 MOTO $1,000 $1,000
004 14/02/2017 2 BLN-210 PARTICULAR $4,500 $9,000
003 13/02/2017 3 ANA-520 PARTICULAR $4,500 $13,500
002 12/02/2017 4 TTZ-004 TAXI $2,500 $10,000
001 11/02/2017 5 OYK-089 PARTICULAR $4,500 $22,500
011 10/02/2017 6 PAM-815 COLECTIVO $3,000 $18,000
010 09/02/2017 7 JEA-211 MOTO $1,000 $7,000
009 08/02/2017 8 JPA-906 PARTICULAR $4,500 $36,000
008 07/02/2017 9 JFR-128 PARTICULAR $4,500 $40,500
007 06/02/2017 10 HSM-315 PARTICULAR $4,500 $45,000
006 05/02/2017 11 WWW-882 TAXI $2,500 $27,500
005 04/02/2017 12 HRP-000 MOTO $1,000 $12,000
004 03/02/2017 13 BLN-210 PARTICULAR $4,500 $58,500
003 02/02/2017 14 ANA-520 PARTICULAR $4,500 $63,000
002 01/02/2017 15 TTZ-004 TAXI $2,500 $37,500
001 31/01/2017 16 OYK-089 PARTICULAR $4,500 $72,000
011 30/01/2017 17 PAM-815 COLECTIVO $3,000 $51,000
010 29/01/2017 18 JEA-211 MOTO $1,000 $18,000
009 28/01/2017 19 JPA-906 PARTICULAR $4,500 $85,500
008 27/01/2017 20 JFR-128 PARTICULAR $4,500 $90,000
007 26/01/2017 21 HSM-315 PARTICULAR $4,500 $94,500
006 25/01/2017 22 WWW-882 TAXI $2,500 $55,000
005 24/01/2017 23 HRP-000 MOTO $1,000 $23,000
004 23/01/2017 24 BLN-210 PARTICULAR $4,500 $108,000
003 22/01/2017 1 ANA-520 PARTICULAR $4,500 $4,500
002 21/01/2017 2 TTZ-004 TAXI $2,500 $5,000
001 20/01/2017 3 OYK-089 PARTICULAR $4,500 $13,500
011 19/01/2017 4 PAM-815 COLECTIVO $3,000 $12,000
010 18/01/2017 5 JEA-211 MOTO $1,000 $5,000
009 17/01/2017 6 JPA-906 PARTICULAR $4,500 $27,000
008 16/01/2017 7 JFR-128 PARTICULAR $4,500 $31,500
007 15/01/2017 8 HSM-315 PARTICULAR $4,500 $36,000
006 14/01/2017 9 WWW-882 TAXI $2,500 $22,500
005 13/01/2017 10 HRP-000 MOTO $1,000 $10,000
004 12/01/2017 11 BLN-210 PARTICULAR $4,500 $49,500
003 11/01/2017 12 ANA-520 PARTICULAR $4,500 $54,000
002 10/01/2017 13 TTZ-004 TAXI $2,500 $32,500
001 09/01/2017 14 OYK-089 PARTICULAR $4,500 $63,000
011 08/01/2017 15 PAM-815 COLECTIVO $3,000 $45,000
010 07/01/2017 16 JEA-211 MOTO $1,000 $16,000
009 06/01/2017 17 JPA-906 PARTICULAR $4,500 $76,500
008 05/01/2017 18 JFR-128 PARTICULAR $4,500 $81,000
007 04/01/2017 19 HSM-315 PARTICULAR $4,500 $85,500
006 03/01/2017 20 WWW-882 TAXI $2,500 $50,000
005 02/01/2017 21 HRP-000 MOTO $1,000 $21,000
004 01/01/2017 22 BLN-210 PARTICULAR $4,500 $99,000
003 31/12/2016 23 ANA-520 PARTICULAR $4,500 $103,500
002 30/12/2016 24 TTZ-004 TAXI $2,500 $60,000
001 29/12/2016 1 OYK-089 PARTICULAR $4,500 $4,500
011 28/12/2016 2 PAM-815 COLECTIVO $3,000 $6,000
010 27/12/2016 3 JEA-211 MOTO $1,000 $3,000
009 26/12/2016 4 JPA-906 PARTICULAR $4,500 $18,000
008 25/12/2016 5 JFR-128 PARTICULAR $4,500 $22,500
007 24/12/2016 6 HSM-315 PARTICULAR $4,500 $27,000
006 23/12/2016 7 WWW-882 TAXI $2,500 $17,500
005 22/12/2016 8 HRP-000 MOTO $1,000 $8,000
004 21/12/2016 9 BLN-210 PARTICULAR $4,500 $40,500
003 20/12/2016 10 ANA-520 PARTICULAR $4,500 $45,000
002 19/12/2016 11 TTZ-004 TAXI $2,500 $27,500
001 18/12/2016 12 OYK-089 PARTICULAR $4,500 $54,000
011 17/12/2016 13 PAM-815 COLECTIVO $3,000 $39,000
010 16/12/2016 14 JEA-211 MOTO $1,000 $14,000
009 15/12/2016 15 JPA-906 PARTICULAR $4,500 $67,500
008 14/12/2016 16 JFR-128 PARTICULAR $4,500 $72,000
007 13/12/2016 17 HSM-315 PARTICULAR $4,500 $76,500
006 12/12/2016 18 WWW-882 TAXI $2,500 $45,000
005 11/12/2016 19 HRP-000 MOTO $1,000 $19,000
004 10/12/2016 20 BLN-210 PARTICULAR $4,500 $90,000
003 09/12/2016 21 ANA-520 PARTICULAR $4,500 $94,500
002 08/12/2016 22 TTZ-004 TAXI $2,500 $55,000
001 07/12/2016 23 OYK-089 PARTICULAR $4,500 $103,500
011 06/12/2016 24 PAM-815 COLECTIVO $3,000 $72,000
010 05/12/2016 1 JEA-211 MOTO $1,000 $1,000
009 04/12/2016 2 JPA-906 PARTICULAR $4,500 $9,000
008 03/12/2016 3 JFR-128 PARTICULAR $4,500 $13,500
007 02/12/2016 4 HSM-315 PARTICULAR $4,500 $18,000
006 01/12/2016 5 WWW-882 TAXI $2,500 $12,500
005 30/11/2016 6 HRP-000 MOTO $1,000 $6,000
004 29/11/2016 7 BLN-210 PARTICULAR $4,500 $31,500
003 28/11/2016 8 ANA-520 PARTICULAR $4,500 $36,000
002 27/11/2016 9 TTZ-004 TAXI $2,500 $22,500
001 26/11/2016 10 OYK-089 PARTICULAR $4,500 $45,000
011 25/11/2016 11 PAM-815 COLECTIVO $3,000 $33,000
010 24/11/2016 12 JEA-211 MOTO $1,000 $12,000
009 23/11/2016 13 JPA-906 PARTICULAR $4,500 $58,500
008 22/11/2016 14 JFR-128 PARTICULAR $4,500 $63,000
007 21/11/2016 15 HSM-315 PARTICULAR $4,500 $67,500
006 20/11/2016 16 WWW-882 TAXI $2,500 $40,000
005 19/11/2016 17 HRP-000 MOTO $1,000 $17,000
004 18/11/2016 18 BLN-210 PARTICULAR $4,500 $81,000
003 17/11/2016 19 ANA-520 PARTICULAR $4,500 $85,500
002 16/11/2016 20 TTZ-004 TAXI $2,500 $50,000
001 15/11/2016 21 OYK-089 PARTICULAR $4,500 $94,500
011 14/11/2016 22 PAM-815 COLECTIVO $3,000 $66,000
010 13/11/2016 23 JEA-211 MOTO $1,000 $23,000
009 12/11/2016 24 JPA-906 PARTICULAR $4,500 $108,000
007 10/11/2016 1 HSM-315 PARTICULAR $4,500 $4,500
006 09/11/2016 2 WWW-882 TAXI $2,500 $5,000
005 08/11/2016 3 HRP-000 MOTO $1,000 $3,000
004 07/11/2016 4 BLN-210 PARTICULAR $4,500 $18,000
001 06/11/2016 5 OYK-089 PARTICULAR $4,500 $22,500
001 06/11/2016 6 OYK-089 PARTICULAR $4,500 $27,000
001 06/11/2016 7 OYK-089 PARTICULAR $4,500 $31,500
003 06/11/2016 8 ANA-520 PARTICULAR $4,500 $36,000
003 06/11/2016 9 ANA-520 PARTICULAR $4,500 $40,500
004 06/11/2016 10 BLN-210 PARTICULAR $4,500 $45,000
007 06/11/2016 11 HSM-315 PARTICULAR $4,500 $49,500
008 06/11/2016 12 JFR-128 PARTICULAR $4,500 $54,000
008 06/11/2016 13 JFR-128 PARTICULAR $4,500 $58,500
009 06/11/2016 14 JPA-906 PARTICULAR $4,500 $63,000
009 06/11/2016 15 JPA-906 PARTICULAR $4,500 $67,500
002 05/11/2016 16 TTZ-004 TAXI $2,500 $40,000
001 04/11/2016 17 OYK-089 PARTICULAR $4,500 $76,500
011 03/11/2016 18 PAM-815 COLECTIVO $3,000 $54,000
010 02/11/2016 19 JEA-211 MOTO $1,000 $19,000
008 31/10/2016 20 JFR-128 PARTICULAR $4,500 $90,000
007 30/10/2016 21 HSM-315 PARTICULAR $4,500 $94,500
006 29/10/2016 22 WWW-882 TAXI $2,500 $55,000
005 28/10/2016 23 HRP-000 MOTO $1,000 $23,000
004 27/10/2016 24 BLN-210 PARTICULAR $4,500 $108,000
003 26/10/2016 1 ANA-520 PARTICULAR $4,500 $4,500
002 25/10/2016 2 TTZ-004 TAXI $2,500 $5,000
011 23/10/2016 3 PAM-815 COLECTIVO $3,000 $9,000
010 22/10/2016 4 JEA-211 MOTO $1,000 $4,000
009 21/10/2016 5 JPA-906 PARTICULAR $4,500 $22,500
007 19/10/2016 6 HSM-315 PARTICULAR $4,500 $27,000
006 18/10/2016 7 WWW-882 TAXI $2,500 $17,500
005 17/10/2016 8 HRP-000 MOTO $1,000 $8,000
004 16/10/2016 9 BLN-210 PARTICULAR $4,500 $40,500
003 15/10/2016 10 ANA-520 PARTICULAR $4,500 $45,000
002 14/10/2016 11 TTZ-004 TAXI $2,500 $27,500
001 13/10/2016 12 OYK-089 PARTICULAR $4,500 $54,000
011 12/10/2016 13 PAM-815 COLECTIVO $3,000 $39,000
010 11/10/2016 14 JEA-211 MOTO $1,000 $14,000
008 09/10/2016 15 JFR-128 PARTICULAR $4,500 $67,500
007 08/10/2016 16 HSM-315 PARTICULAR $4,500 $72,000
006 07/10/2016 17 WWW-882 TAXI $2,500 $42,500
005 06/10/2016 18 HRP-000 MOTO $1,000 $18,000
004 05/10/2016 19 BLN-210 PARTICULAR $4,500 $85,500
003 04/10/2016 20 ANA-520 PARTICULAR $4,500 $90,000
002 03/10/2016 21 TTZ-004 TAXI $2,500 $52,500
002 01/10/2016 22 TTZ-004 TAXI $2,500 $55,000
005 01/10/2016 23 HRP-000 MOTO $1,000 $23,000
006 01/10/2016 24 WWW-882 TAXI $2,500 $60,000
008 01/10/2016 1 JFR-128 PARTICULAR $4,500 $4,500
009 01/10/2016 2 JPA-906 PARTICULAR $4,500 $9,000
010 01/10/2016 3 JEA-211 MOTO $1,000 $3,000
011 01/10/2016 4 PAM-815 COLECTIVO $3,000 $12,000
PROPIETARIO
AMPARO CORREA
PEDRO MATURANA
BLANCA GARCIA
CARLOS ANDRADE
ANA ANDRADE
PAOLA ANDRADE
ADRIAN BERNAL
JESUS RENTERIA A.
MENÚ
LINA MARIN
HECTOR MOSQUERA
ROBERTO GARCIA
PEDRO MATURANA
AMPARO CORREA
CARLOS ANDRADE
BLANCA GARCIA
PAOLA ANDRADE
ANA ANDRADE
JESUS RENTERIA A.
ADRIAN BERNAL
HECTOR MOSQUERA
LINA MARIN
ROBERTO GARCIA
AMPARO CORREA
PEDRO MATURANA
BLANCA GARCIA
CARLOS ANDRADE
ANA ANDRADE
PAOLA ANDRADE
ADRIAN BERNAL
JESUS RENTERIA A.
LINA MARIN
HECTOR MOSQUERA
ROBERTO GARCIA
PEDRO MATURANA
AMPARO CORREA
CARLOS ANDRADE
BLANCA GARCIA
PAOLA ANDRADE
ANA ANDRADE
JESUS RENTERIA A.
ADRIAN BERNAL
HECTOR MOSQUERA
LINA MARIN
ROBERTO GARCIA
AMPARO CORREA
PEDRO MATURANA
BLANCA GARCIA
CARLOS ANDRADE
ANA ANDRADE
PAOLA ANDRADE
ADRIAN BERNAL
JESUS RENTERIA A.
LINA MARIN
HECTOR MOSQUERA
ROBERTO GARCIA
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
LINA MARIN
LINA MARIN
LINA MARIN
ANA ANDRADE
ANA ANDRADE
BLANCA GARCIA
HECTOR MOSQUERA
JESUS RENTERIA A.
JESUS RENTERIA A.
PAOLA ANDRADE
PAOLA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
ADRIAN BERNAL
AMPARO CORREA
ROBERTO GARCIA
JESUS RENTERIA A.
PAOLA ANDRADE
CARLOS ANDRADE
PEDRO MATURANA
# DE CELDA FECHA # DE HORAS PLACA VEHICULO VALOR HORA TOTAL
002 28/03/2017 7 TTZ-004 TAXI $2,500 $17,500
002 22/03/2017 19 TTZ-004 TAXI $2,500 $47,500
002 17/03/2017 5 TTZ-004 TAXI $2,500 $12,500
002 11/03/2017 17 TTZ-004 TAXI $2,500 $42,500
002 06/03/2017 3 TTZ-004 TAXI $2,500 $7,500
002 23/02/2017 17 TTZ-004 TAXI $2,500 $42,500
002 12/02/2017 4 TTZ-004 TAXI $2,500 $10,000
002 01/02/2017 15 TTZ-004 TAXI $2,500 $37,500
002 21/01/2017 2 TTZ-004 TAXI $2,500 $5,000
002 10/01/2017 13 TTZ-004 TAXI $2,500 $32,500
002 30/12/2016 24 TTZ-004 TAXI $2,500 $60,000
002 19/12/2016 11 TTZ-004 TAXI $2,500 $27,500
002 08/12/2016 22 TTZ-004 TAXI $2,500 $55,000
002 27/11/2016 9 TTZ-004 TAXI $2,500 $22,500
002 16/11/2016 20 TTZ-004 TAXI $2,500 $50,000
002 05/11/2016 16 TTZ-004 TAXI $2,500 $40,000
002 25/10/2016 2 TTZ-004 TAXI $2,500 $5,000
002 14/10/2016 11 TTZ-004 TAXI $2,500 $27,500
002 03/10/2016 21 TTZ-004 TAXI $2,500 $52,500
002 01/10/2016 22 TTZ-004 TAXI $2,500 $55,000
$650,000
005 31/03/2017 1 HRP-000 MOTO $1,000 $1,000
005 25/03/2017 13 HRP-000 MOTO $1,000 $13,000
005 20/03/2017 23 HRP-000 MOTO $1,000 $23,000
005 14/03/2017 11 HRP-000 MOTO $1,000 $11,000
005 09/03/2017 21 HRP-000 MOTO $1,000 $21,000
005 26/02/2017 14 HRP-000 MOTO $1,000 $14,000
005 15/02/2017 1 HRP-000 MOTO $1,000 $1,000
005 04/02/2017 12 HRP-000 MOTO $1,000 $12,000
005 24/01/2017 23 HRP-000 MOTO $1,000 $23,000
005 13/01/2017 10 HRP-000 MOTO $1,000 $10,000
005 02/01/2017 21 HRP-000 MOTO $1,000 $21,000
005 22/12/2016 8 HRP-000 MOTO $1,000 $8,000
005 11/12/2016 19 HRP-000 MOTO $1,000 $19,000
005 30/11/2016 6 HRP-000 MOTO $1,000 $6,000
005 19/11/2016 17 HRP-000 MOTO $1,000 $17,000
005 08/11/2016 3 HRP-000 MOTO $1,000 $3,000
005 28/10/2016 23 HRP-000 MOTO $1,000 $23,000
005 17/10/2016 8 HRP-000 MOTO $1,000 $8,000
005 06/10/2016 18 HRP-000 MOTO $1,000 $18,000
005 01/10/2016 23 HRP-000 MOTO $1,000 $23,000
$275,000
003 29/03/2017 5 ANA-520 PARTICULAR $4,500 $22,500
003 23/03/2017 17 ANA-520 PARTICULAR $4,500 $76,500
003 18/03/2017 3 ANA-520 PARTICULAR $4,500 $13,500
003 12/03/2017 15 ANA-520 PARTICULAR $4,500 $67,500
003 07/03/2017 1 ANA-520 PARTICULAR $4,500 $4,500
003 24/02/2017 16 ANA-520 PARTICULAR $4,500 $72,000
003 13/02/2017 3 ANA-520 PARTICULAR $4,500 $13,500
003 02/02/2017 14 ANA-520 PARTICULAR $4,500 $63,000
003 22/01/2017 1 ANA-520 PARTICULAR $4,500 $4,500
003 11/01/2017 12 ANA-520 PARTICULAR $4,500 $54,000
003 31/12/2016 23 ANA-520 PARTICULAR $4,500 $103,500
003 20/12/2016 10 ANA-520 PARTICULAR $4,500 $45,000
003 09/12/2016 21 ANA-520 PARTICULAR $4,500 $94,500
003 28/11/2016 8 ANA-520 PARTICULAR $4,500 $36,000
003 17/11/2016 19 ANA-520 PARTICULAR $4,500 $85,500
003 06/11/2016 8 ANA-520 PARTICULAR $4,500 $36,000
003 06/11/2016 9 ANA-520 PARTICULAR $4,500 $40,500
003 26/10/2016 1 ANA-520 PARTICULAR $4,500 $4,500
003 15/10/2016 10 ANA-520 PARTICULAR $4,500 $45,000
003 04/10/2016 20 ANA-520 PARTICULAR $4,500 $90,000
$972,000
004 30/03/2017 3 BLN-210 PARTICULAR $4,500 $13,500
004 24/03/2017 15 BLN-210 PARTICULAR $4,500 $67,500
004 19/03/2017 1 BLN-210 PARTICULAR $4,500 $4,500
004 13/03/2017 13 BLN-210 PARTICULAR $4,500 $58,500
004 08/03/2017 23 BLN-210 PARTICULAR $4,500 $103,500
004 25/02/2017 15 BLN-210 PARTICULAR $4,500 $67,500
004 14/02/2017 2 BLN-210 PARTICULAR $4,500 $9,000
004 03/02/2017 13 BLN-210 PARTICULAR $4,500 $58,500
004 23/01/2017 24 BLN-210 PARTICULAR $4,500 $108,000
004 12/01/2017 11 BLN-210 PARTICULAR $4,500 $49,500
004 01/01/2017 22 BLN-210 PARTICULAR $4,500 $99,000
004 21/12/2016 9 BLN-210 PARTICULAR $4,500 $40,500
004 10/12/2016 20 BLN-210 PARTICULAR $4,500 $90,000
004 29/11/2016 7 BLN-210 PARTICULAR $4,500 $31,500
004 18/11/2016 18 BLN-210 PARTICULAR $4,500 $81,000
004 07/11/2016 4 BLN-210 PARTICULAR $4,500 $18,000
004 06/11/2016 10 BLN-210 PARTICULAR $4,500 $45,000
004 27/10/2016 24 BLN-210 PARTICULAR $4,500 $108,000
004 16/10/2016 9 BLN-210 PARTICULAR $4,500 $40,500
004 05/10/2016 19 BLN-210 PARTICULAR $4,500 $85,500
$1,179,000
010 30/03/2017 4 JEA-211 MOTO $1,000 $4,000
010 25/03/2017 14 JEA-211 MOTO $1,000 $14,000
010 19/03/2017 2 JEA-211 MOTO $1,000 $2,000
010 14/03/2017 12 JEA-211 MOTO $1,000 $12,000
010 08/03/2017 24 JEA-211 MOTO $1,000 $24,000
010 03/03/2017 9 JEA-211 MOTO $1,000 $9,000
010 20/02/2017 20 JEA-211 MOTO $1,000 $20,000
010 09/02/2017 7 JEA-211 MOTO $1,000 $7,000
010 29/01/2017 18 JEA-211 MOTO $1,000 $18,000
010 18/01/2017 5 JEA-211 MOTO $1,000 $5,000
010 07/01/2017 16 JEA-211 MOTO $1,000 $16,000
010 27/12/2016 3 JEA-211 MOTO $1,000 $3,000
010 16/12/2016 14 JEA-211 MOTO $1,000 $14,000
010 05/12/2016 1 JEA-211 MOTO $1,000 $1,000
010 24/11/2016 12 JEA-211 MOTO $1,000 $12,000
010 13/11/2016 23 JEA-211 MOTO $1,000 $23,000
010 02/11/2016 19 JEA-211 MOTO $1,000 $19,000
010 22/10/2016 4 JEA-211 MOTO $1,000 $4,000
010 11/10/2016 14 JEA-211 MOTO $1,000 $14,000
010 01/10/2016 3 JEA-211 MOTO $1,000 $3,000
$224,000
007 27/03/2017 10 HSM-315 PARTICULAR $4,500 $45,000
007 22/03/2017 20 HSM-315 PARTICULAR $4,500 $90,000
007 16/03/2017 8 HSM-315 PARTICULAR $4,500 $36,000
007 11/03/2017 18 HSM-315 PARTICULAR $4,500 $81,000
007 05/03/2017 6 HSM-315 PARTICULAR $4,500 $27,000
007 28/02/2017 12 HSM-315 PARTICULAR $4,500 $54,000
007 17/02/2017 23 HSM-315 PARTICULAR $4,500 $103,500
007 06/02/2017 10 HSM-315 PARTICULAR $4,500 $45,000
007 26/01/2017 21 HSM-315 PARTICULAR $4,500 $94,500
007 15/01/2017 8 HSM-315 PARTICULAR $4,500 $36,000
007 04/01/2017 19 HSM-315 PARTICULAR $4,500 $85,500
007 24/12/2016 6 HSM-315 PARTICULAR $4,500 $27,000
007 13/12/2016 17 HSM-315 PARTICULAR $4,500 $76,500
007 02/12/2016 4 HSM-315 PARTICULAR $4,500 $18,000
007 21/11/2016 15 HSM-315 PARTICULAR $4,500 $67,500
007 10/11/2016 1 HSM-315 PARTICULAR $4,500 $4,500
007 06/11/2016 11 HSM-315 PARTICULAR $4,500 $49,500
007 30/10/2016 21 HSM-315 PARTICULAR $4,500 $94,500
007 19/10/2016 6 HSM-315 PARTICULAR $4,500 $27,000
007 08/10/2016 16 HSM-315 PARTICULAR $4,500 $72,000
$1,134,000
008 28/03/2017 8 JFR-128 PARTICULAR $4,500 $36,000
008 23/03/2017 18 JFR-128 PARTICULAR $4,500 $81,000
008 17/03/2017 6 JFR-128 PARTICULAR $4,500 $27,000
008 12/03/2017 16 JFR-128 PARTICULAR $4,500 $72,000
008 06/03/2017 4 JFR-128 PARTICULAR $4,500 $18,000
008 01/03/2017 11 JFR-128 PARTICULAR $4,500 $49,500
008 18/02/2017 22 JFR-128 PARTICULAR $4,500 $99,000
008 07/02/2017 9 JFR-128 PARTICULAR $4,500 $40,500
008 27/01/2017 20 JFR-128 PARTICULAR $4,500 $90,000
008 16/01/2017 7 JFR-128 PARTICULAR $4,500 $31,500
008 05/01/2017 18 JFR-128 PARTICULAR $4,500 $81,000
008 25/12/2016 5 JFR-128 PARTICULAR $4,500 $22,500
008 14/12/2016 16 JFR-128 PARTICULAR $4,500 $72,000
008 03/12/2016 3 JFR-128 PARTICULAR $4,500 $13,500
008 22/11/2016 14 JFR-128 PARTICULAR $4,500 $63,000
008 06/11/2016 12 JFR-128 PARTICULAR $4,500 $54,000
008 06/11/2016 13 JFR-128 PARTICULAR $4,500 $58,500
008 31/10/2016 20 JFR-128 PARTICULAR $4,500 $90,000
008 09/10/2016 15 JFR-128 PARTICULAR $4,500 $67,500
008 01/10/2016 1 JFR-128 PARTICULAR $4,500 $4,500
$1,071,000
001 27/03/2017 9 OYK-089 PARTICULAR $4,500 $40,500
001 21/03/2017 21 OYK-089 PARTICULAR $4,500 $94,500
001 16/03/2017 7 OYK-089 PARTICULAR $4,500 $31,500
001 10/03/2017 19 OYK-089 PARTICULAR $4,500 $85,500
001 05/03/2017 5 OYK-089 PARTICULAR $4,500 $22,500
001 22/02/2017 18 OYK-089 PARTICULAR $4,500 $81,000
001 11/02/2017 5 OYK-089 PARTICULAR $4,500 $22,500
001 31/01/2017 16 OYK-089 PARTICULAR $4,500 $72,000
001 20/01/2017 3 OYK-089 PARTICULAR $4,500 $13,500
001 09/01/2017 14 OYK-089 PARTICULAR $4,500 $63,000
001 29/12/2016 1 OYK-089 PARTICULAR $4,500 $4,500
001 18/12/2016 12 OYK-089 PARTICULAR $4,500 $54,000
001 07/12/2016 23 OYK-089 PARTICULAR $4,500 $103,500
001 26/11/2016 10 OYK-089 PARTICULAR $4,500 $45,000
001 15/11/2016 21 OYK-089 PARTICULAR $4,500 $94,500
001 06/11/2016 5 OYK-089 PARTICULAR $4,500 $22,500
001 06/11/2016 6 OYK-089 PARTICULAR $4,500 $27,000
001 06/11/2016 7 OYK-089 PARTICULAR $4,500 $31,500
001 04/11/2016 17 OYK-089 PARTICULAR $4,500 $76,500
001 13/10/2016 12 OYK-089 PARTICULAR $4,500 $54,000
$1,039,500
009 29/03/2017 6 JPA-906 PARTICULAR $4,500 $27,000
009 24/03/2017 16 JPA-906 PARTICULAR $4,500 $72,000
009 18/03/2017 4 JPA-906 PARTICULAR $4,500 $18,000
009 13/03/2017 14 JPA-906 PARTICULAR $4,500 $63,000
009 07/03/2017 2 JPA-906 PARTICULAR $4,500 $9,000
009 02/03/2017 10 JPA-906 PARTICULAR $4,500 $45,000
009 19/02/2017 21 JPA-906 PARTICULAR $4,500 $94,500
009 08/02/2017 8 JPA-906 PARTICULAR $4,500 $36,000
009 28/01/2017 19 JPA-906 PARTICULAR $4,500 $85,500
009 17/01/2017 6 JPA-906 PARTICULAR $4,500 $27,000
009 06/01/2017 17 JPA-906 PARTICULAR $4,500 $76,500
009 26/12/2016 4 JPA-906 PARTICULAR $4,500 $18,000
009 15/12/2016 15 JPA-906 PARTICULAR $4,500 $67,500
009 04/12/2016 2 JPA-906 PARTICULAR $4,500 $9,000
009 23/11/2016 13 JPA-906 PARTICULAR $4,500 $58,500
009 12/11/2016 24 JPA-906 PARTICULAR $4,500 $108,000
009 06/11/2016 14 JPA-906 PARTICULAR $4,500 $63,000
009 06/11/2016 15 JPA-906 PARTICULAR $4,500 $67,500
009 21/10/2016 5 JPA-906 PARTICULAR $4,500 $22,500
009 01/10/2016 2 JPA-906 PARTICULAR $4,500 $9,000
$976,500
011 31/03/2017 2 PAM-815 COLECTIVO $3,000 $6,000
011 26/03/2017 12 PAM-815 COLECTIVO $3,000 $36,000
011 20/03/2017 24 PAM-815 COLECTIVO $3,000 $72,000
011 15/03/2017 10 PAM-815 COLECTIVO $3,000 $30,000
011 09/03/2017 22 PAM-815 COLECTIVO $3,000 $66,000
011 04/03/2017 8 PAM-815 COLECTIVO $3,000 $24,000
011 21/02/2017 19 PAM-815 COLECTIVO $3,000 $57,000
011 10/02/2017 6 PAM-815 COLECTIVO $3,000 $18,000
011 30/01/2017 17 PAM-815 COLECTIVO $3,000 $51,000
011 19/01/2017 4 PAM-815 COLECTIVO $3,000 $12,000
011 08/01/2017 15 PAM-815 COLECTIVO $3,000 $45,000
011 28/12/2016 2 PAM-815 COLECTIVO $3,000 $6,000
011 17/12/2016 13 PAM-815 COLECTIVO $3,000 $39,000
011 06/12/2016 24 PAM-815 COLECTIVO $3,000 $72,000
011 25/11/2016 11 PAM-815 COLECTIVO $3,000 $33,000
011 14/11/2016 22 PAM-815 COLECTIVO $3,000 $66,000
011 03/11/2016 18 PAM-815 COLECTIVO $3,000 $54,000
011 23/10/2016 3 PAM-815 COLECTIVO $3,000 $9,000
011 12/10/2016 13 PAM-815 COLECTIVO $3,000 $39,000
011 01/10/2016 4 PAM-815 COLECTIVO $3,000 $12,000
$747,000
006 26/03/2017 11 WWW-882 TAXI $2,500 $27,500
006 21/03/2017 22 WWW-882 TAXI $2,500 $55,000
006 15/03/2017 9 WWW-882 TAXI $2,500 $22,500
006 10/03/2017 20 WWW-882 TAXI $2,500 $50,000
006 04/03/2017 7 WWW-882 TAXI $2,500 $17,500
006 27/02/2017 13 WWW-882 TAXI $2,500 $32,500
006 16/02/2017 24 WWW-882 TAXI $2,500 $60,000
006 05/02/2017 11 WWW-882 TAXI $2,500 $27,500
006 25/01/2017 22 WWW-882 TAXI $2,500 $55,000
006 14/01/2017 9 WWW-882 TAXI $2,500 $22,500
006 03/01/2017 20 WWW-882 TAXI $2,500 $50,000
006 23/12/2016 7 WWW-882 TAXI $2,500 $17,500
006 12/12/2016 18 WWW-882 TAXI $2,500 $45,000
006 01/12/2016 5 WWW-882 TAXI $2,500 $12,500
006 20/11/2016 16 WWW-882 TAXI $2,500 $40,000
006 09/11/2016 2 WWW-882 TAXI $2,500 $5,000
006 29/10/2016 22 WWW-882 TAXI $2,500 $55,000
006 18/10/2016 7 WWW-882 TAXI $2,500 $17,500
006 07/10/2016 17 WWW-882 TAXI $2,500 $42,500
006 01/10/2016 24 WWW-882 TAXI $2,500 $60,000
$715,000
$8,983,000
PROPIETARIO
12. Realice un subtotal por propietario.
ADRIAN BERNAL
ADRIAN BERNAL
ADRIAN BERNAL
ADRIAN BERNAL
ADRIAN BERNAL
ADRIAN BERNAL
ADRIAN BERNAL
ADRIAN BERNAL
ADRIAN BERNAL
ADRIAN BERNAL
ADRIAN BERNAL
ADRIAN BERNAL
ADRIAN BERNAL
ADRIAN BERNAL
ADRIAN BERNAL
ADRIAN BERNAL MENÚ
ADRIAN BERNAL
ADRIAN BERNAL
ADRIAN BERNAL
ADRIAN BERNAL
Total ADRIAN BERNAL
AMPARO CORREA
AMPARO CORREA
AMPARO CORREA
AMPARO CORREA
AMPARO CORREA
AMPARO CORREA
AMPARO CORREA
AMPARO CORREA
AMPARO CORREA
AMPARO CORREA
AMPARO CORREA
AMPARO CORREA
AMPARO CORREA
AMPARO CORREA
AMPARO CORREA
AMPARO CORREA
AMPARO CORREA
AMPARO CORREA
AMPARO CORREA
AMPARO CORREA
Total AMPARO CORREA
ANA ANDRADE
ANA ANDRADE
ANA ANDRADE
ANA ANDRADE
ANA ANDRADE
ANA ANDRADE
ANA ANDRADE
ANA ANDRADE
ANA ANDRADE
ANA ANDRADE
ANA ANDRADE
ANA ANDRADE
ANA ANDRADE
ANA ANDRADE
ANA ANDRADE
ANA ANDRADE
ANA ANDRADE
ANA ANDRADE
ANA ANDRADE
ANA ANDRADE
Total ANA ANDRADE
BLANCA GARCIA
BLANCA GARCIA
BLANCA GARCIA
BLANCA GARCIA
BLANCA GARCIA
BLANCA GARCIA
BLANCA GARCIA
BLANCA GARCIA
BLANCA GARCIA
BLANCA GARCIA
BLANCA GARCIA
BLANCA GARCIA
BLANCA GARCIA
BLANCA GARCIA
BLANCA GARCIA
BLANCA GARCIA
BLANCA GARCIA
BLANCA GARCIA
BLANCA GARCIA
BLANCA GARCIA
Total BLANCA GARCIA
CARLOS ANDRADE
CARLOS ANDRADE
CARLOS ANDRADE
CARLOS ANDRADE
CARLOS ANDRADE
CARLOS ANDRADE
CARLOS ANDRADE
CARLOS ANDRADE
CARLOS ANDRADE
CARLOS ANDRADE
CARLOS ANDRADE
CARLOS ANDRADE
CARLOS ANDRADE
CARLOS ANDRADE
CARLOS ANDRADE
CARLOS ANDRADE
CARLOS ANDRADE
CARLOS ANDRADE
CARLOS ANDRADE
CARLOS ANDRADE
Total CARLOS ANDRADE
HECTOR MOSQUERA
HECTOR MOSQUERA
HECTOR MOSQUERA
HECTOR MOSQUERA
HECTOR MOSQUERA
HECTOR MOSQUERA
HECTOR MOSQUERA
HECTOR MOSQUERA
HECTOR MOSQUERA
HECTOR MOSQUERA
HECTOR MOSQUERA
HECTOR MOSQUERA
HECTOR MOSQUERA
HECTOR MOSQUERA
HECTOR MOSQUERA
HECTOR MOSQUERA
HECTOR MOSQUERA
HECTOR MOSQUERA
HECTOR MOSQUERA
HECTOR MOSQUERA
Total HECTOR MOSQUERA
JESUS RENTERIA A.
JESUS RENTERIA A.
JESUS RENTERIA A.
JESUS RENTERIA A.
JESUS RENTERIA A.
JESUS RENTERIA A.
JESUS RENTERIA A.
JESUS RENTERIA A.
JESUS RENTERIA A.
JESUS RENTERIA A.
JESUS RENTERIA A.
JESUS RENTERIA A.
JESUS RENTERIA A.
JESUS RENTERIA A.
JESUS RENTERIA A.
JESUS RENTERIA A.
JESUS RENTERIA A.
JESUS RENTERIA A.
JESUS RENTERIA A.
JESUS RENTERIA A.
Total JESUS RENTERIA A.
LINA MARIN
LINA MARIN
LINA MARIN
LINA MARIN
LINA MARIN
LINA MARIN
LINA MARIN
LINA MARIN
LINA MARIN
LINA MARIN
LINA MARIN
LINA MARIN
LINA MARIN
LINA MARIN
LINA MARIN
LINA MARIN
LINA MARIN
LINA MARIN
LINA MARIN
LINA MARIN
Total LINA MARIN
PAOLA ANDRADE
PAOLA ANDRADE
PAOLA ANDRADE
PAOLA ANDRADE
PAOLA ANDRADE
PAOLA ANDRADE
PAOLA ANDRADE
PAOLA ANDRADE
PAOLA ANDRADE
PAOLA ANDRADE
PAOLA ANDRADE
PAOLA ANDRADE
PAOLA ANDRADE
PAOLA ANDRADE
PAOLA ANDRADE
PAOLA ANDRADE
PAOLA ANDRADE
PAOLA ANDRADE
PAOLA ANDRADE
PAOLA ANDRADE
Total PAOLA ANDRADE
PEDRO MATURANA
PEDRO MATURANA
PEDRO MATURANA
PEDRO MATURANA
PEDRO MATURANA
PEDRO MATURANA
PEDRO MATURANA
PEDRO MATURANA
PEDRO MATURANA
PEDRO MATURANA
PEDRO MATURANA
PEDRO MATURANA
PEDRO MATURANA
PEDRO MATURANA
PEDRO MATURANA
PEDRO MATURANA
PEDRO MATURANA
PEDRO MATURANA
PEDRO MATURANA
PEDRO MATURANA
Total PEDRO MATURANA
ROBERTO GARCIA
ROBERTO GARCIA
ROBERTO GARCIA
ROBERTO GARCIA
ROBERTO GARCIA
ROBERTO GARCIA
ROBERTO GARCIA
ROBERTO GARCIA
ROBERTO GARCIA
ROBERTO GARCIA
ROBERTO GARCIA
ROBERTO GARCIA
ROBERTO GARCIA
ROBERTO GARCIA
ROBERTO GARCIA
ROBERTO GARCIA
ROBERTO GARCIA
ROBERTO GARCIA
ROBERTO GARCIA
ROBERTO GARCIA
Total ROBERTO GARCIA
Total general
rio.
PROPIETARIO
ADRIAN BERNAL 13. Utilizabdo la funciones para base
resuelva lo que se pide desde la B3 ha
$650,000 TOTAL A PAGAR
base de datos a consultar es parking.
$32,500 PAGO PROMEDIO
$5,000 PAGO MAS BAJO
$60,000 PAGO MA ALTO
Err:504 # DE INGRESOS
260 TOTAL HORAS
funciones para base de datos,
se pide desde la B3 hasta la B8, la
consultar es parking.

MENÚ
MENÚ
# DE CELDA FECHA # DE HORAS PLACA VEHICULO VALOR HORA TOTAL
005 31/03/2017 1 HRP-000 MOTO $1,000 $1,000
011 31/03/2017 2 PAM-815 COLECTIVO $3,000 $6,000
004 30/03/2017 3 BLN-210 PARTICULAR $4,500 $13,500
010 30/03/2017 4 JEA-211 MOTO $1,000 $4,000
003 29/03/2017 5 ANA-520 PARTICULAR $4,500 $22,500
009 29/03/2017 6 JPA-906 PARTICULAR $4,500 $27,000
002 28/03/2017 7 TTZ-004 TAXI $2,500 $17,500
008 28/03/2017 8 JFR-128 PARTICULAR $4,500 $36,000
001 27/03/2017 9 OYK-089 PARTICULAR $4,500 $40,500
007 27/03/2017 10 HSM-315 PARTICULAR $4,500 $45,000
006 26/03/2017 11 WWW-882 TAXI $2,500 $27,500
011 26/03/2017 12 PAM-815 COLECTIVO $3,000 $36,000
005 25/03/2017 13 HRP-000 MOTO $1,000 $13,000
010 25/03/2017 14 JEA-211 MOTO $1,000 $14,000
004 24/03/2017 15 BLN-210 PARTICULAR $4,500 $67,500
009 24/03/2017 16 JPA-906 PARTICULAR $4,500 $72,000
003 23/03/2017 17 ANA-520 PARTICULAR $4,500 $76,500
008 23/03/2017 18 JFR-128 PARTICULAR $4,500 $81,000
002 22/03/2017 19 TTZ-004 TAXI $2,500 $47,500
007 22/03/2017 20 HSM-315 PARTICULAR $4,500 $90,000
001 21/03/2017 21 OYK-089 PARTICULAR $4,500 $94,500
006 21/03/2017 22 WWW-882 TAXI $2,500 $55,000
005 20/03/2017 23 HRP-000 MOTO $1,000 $23,000
011 20/03/2017 24 PAM-815 COLECTIVO $3,000 $72,000
004 19/03/2017 1 BLN-210 PARTICULAR $4,500 $4,500
010 19/03/2017 2 JEA-211 MOTO $1,000 $2,000
003 18/03/2017 3 ANA-520 PARTICULAR $4,500 $13,500
009 18/03/2017 4 JPA-906 PARTICULAR $4,500 $18,000
002 17/03/2017 5 TTZ-004 TAXI $2,500 $12,500
008 17/03/2017 6 JFR-128 PARTICULAR $4,500 $27,000
001 16/03/2017 7 OYK-089 PARTICULAR $4,500 $31,500
007 16/03/2017 8 HSM-315 PARTICULAR $4,500 $36,000
006 15/03/2017 9 WWW-882 TAXI $2,500 $22,500
011 15/03/2017 10 PAM-815 COLECTIVO $3,000 $30,000
005 14/03/2017 11 HRP-000 MOTO $1,000 $11,000
010 14/03/2017 12 JEA-211 MOTO $1,000 $12,000
004 13/03/2017 13 BLN-210 PARTICULAR $4,500 $58,500
009 13/03/2017 14 JPA-906 PARTICULAR $4,500 $63,000
003 12/03/2017 15 ANA-520 PARTICULAR $4,500 $67,500
008 12/03/2017 16 JFR-128 PARTICULAR $4,500 $72,000
002 11/03/2017 17 TTZ-004 TAXI $2,500 $42,500
007 11/03/2017 18 HSM-315 PARTICULAR $4,500 $81,000
001 10/03/2017 19 OYK-089 PARTICULAR $4,500 $85,500
006 10/03/2017 20 WWW-882 TAXI $2,500 $50,000
005 09/03/2017 21 HRP-000 MOTO $1,000 $21,000
011 09/03/2017 22 PAM-815 COLECTIVO $3,000 $66,000
004 08/03/2017 23 BLN-210 PARTICULAR $4,500 $103,500
010 08/03/2017 24 JEA-211 MOTO $1,000 $24,000
003 07/03/2017 1 ANA-520 PARTICULAR $4,500 $4,500
009 07/03/2017 2 JPA-906 PARTICULAR $4,500 $9,000
002 06/03/2017 3 TTZ-004 TAXI $2,500 $7,500
008 06/03/2017 4 JFR-128 PARTICULAR $4,500 $18,000
001 05/03/2017 5 OYK-089 PARTICULAR $4,500 $22,500
007 05/03/2017 6 HSM-315 PARTICULAR $4,500 $27,000
006 04/03/2017 7 WWW-882 TAXI $2,500 $17,500
011 04/03/2017 8 PAM-815 COLECTIVO $3,000 $24,000
010 03/03/2017 9 JEA-211 MOTO $1,000 $9,000
009 02/03/2017 10 JPA-906 PARTICULAR $4,500 $45,000
008 01/03/2017 11 JFR-128 PARTICULAR $4,500 $49,500
007 28/02/2017 12 HSM-315 PARTICULAR $4,500 $54,000
006 27/02/2017 13 WWW-882 TAXI $2,500 $32,500
005 26/02/2017 14 HRP-000 MOTO $1,000 $14,000
004 25/02/2017 15 BLN-210 PARTICULAR $4,500 $67,500
003 24/02/2017 16 ANA-520 PARTICULAR $4,500 $72,000
002 23/02/2017 17 TTZ-004 TAXI $2,500 $42,500
001 22/02/2017 18 OYK-089 PARTICULAR $4,500 $81,000
011 21/02/2017 19 PAM-815 COLECTIVO $3,000 $57,000
010 20/02/2017 20 JEA-211 MOTO $1,000 $20,000
009 19/02/2017 21 JPA-906 PARTICULAR $4,500 $94,500
008 18/02/2017 22 JFR-128 PARTICULAR $4,500 $99,000
007 17/02/2017 23 HSM-315 PARTICULAR $4,500 $103,500
006 16/02/2017 24 WWW-882 TAXI $2,500 $60,000
005 15/02/2017 1 HRP-000 MOTO $1,000 $1,000
004 14/02/2017 2 BLN-210 PARTICULAR $4,500 $9,000
003 13/02/2017 3 ANA-520 PARTICULAR $4,500 $13,500
002 12/02/2017 4 TTZ-004 TAXI $2,500 $10,000
001 11/02/2017 5 OYK-089 PARTICULAR $4,500 $22,500
011 10/02/2017 6 PAM-815 COLECTIVO $3,000 $18,000
010 09/02/2017 7 JEA-211 MOTO $1,000 $7,000
009 08/02/2017 8 JPA-906 PARTICULAR $4,500 $36,000
008 07/02/2017 9 JFR-128 PARTICULAR $4,500 $40,500
007 06/02/2017 10 HSM-315 PARTICULAR $4,500 $45,000
006 05/02/2017 11 WWW-882 TAXI $2,500 $27,500
005 04/02/2017 12 HRP-000 MOTO $1,000 $12,000
004 03/02/2017 13 BLN-210 PARTICULAR $4,500 $58,500
003 02/02/2017 14 ANA-520 PARTICULAR $4,500 $63,000
002 01/02/2017 15 TTZ-004 TAXI $2,500 $37,500
001 31/01/2017 16 OYK-089 PARTICULAR $4,500 $72,000
011 30/01/2017 17 PAM-815 COLECTIVO $3,000 $51,000
010 29/01/2017 18 JEA-211 MOTO $1,000 $18,000
009 28/01/2017 19 JPA-906 PARTICULAR $4,500 $85,500
008 27/01/2017 20 JFR-128 PARTICULAR $4,500 $90,000
007 26/01/2017 21 HSM-315 PARTICULAR $4,500 $94,500
006 25/01/2017 22 WWW-882 TAXI $2,500 $55,000
005 24/01/2017 23 HRP-000 MOTO $1,000 $23,000
004 23/01/2017 24 BLN-210 PARTICULAR $4,500 $108,000
003 22/01/2017 1 ANA-520 PARTICULAR $4,500 $4,500
002 21/01/2017 2 TTZ-004 TAXI $2,500 $5,000
001 20/01/2017 3 OYK-089 PARTICULAR $4,500 $13,500
011 19/01/2017 4 PAM-815 COLECTIVO $3,000 $12,000
010 18/01/2017 5 JEA-211 MOTO $1,000 $5,000
009 17/01/2017 6 JPA-906 PARTICULAR $4,500 $27,000
008 16/01/2017 7 JFR-128 PARTICULAR $4,500 $31,500
007 15/01/2017 8 HSM-315 PARTICULAR $4,500 $36,000
006 14/01/2017 9 WWW-882 TAXI $2,500 $22,500
005 13/01/2017 10 HRP-000 MOTO $1,000 $10,000
004 12/01/2017 11 BLN-210 PARTICULAR $4,500 $49,500
003 11/01/2017 12 ANA-520 PARTICULAR $4,500 $54,000
002 10/01/2017 13 TTZ-004 TAXI $2,500 $32,500
001 09/01/2017 14 OYK-089 PARTICULAR $4,500 $63,000
011 08/01/2017 15 PAM-815 COLECTIVO $3,000 $45,000
010 07/01/2017 16 JEA-211 MOTO $1,000 $16,000
009 06/01/2017 17 JPA-906 PARTICULAR $4,500 $76,500
008 05/01/2017 18 JFR-128 PARTICULAR $4,500 $81,000
007 04/01/2017 19 HSM-315 PARTICULAR $4,500 $85,500
006 03/01/2017 20 WWW-882 TAXI $2,500 $50,000
005 02/01/2017 21 HRP-000 MOTO $1,000 $21,000
004 01/01/2017 22 BLN-210 PARTICULAR $4,500 $99,000
003 31/12/2016 23 ANA-520 PARTICULAR $4,500 $103,500
002 30/12/2016 24 TTZ-004 TAXI $2,500 $60,000
001 29/12/2016 1 OYK-089 PARTICULAR $4,500 $4,500
011 28/12/2016 2 PAM-815 COLECTIVO $3,000 $6,000
010 27/12/2016 3 JEA-211 MOTO $1,000 $3,000
009 26/12/2016 4 JPA-906 PARTICULAR $4,500 $18,000
008 25/12/2016 5 JFR-128 PARTICULAR $4,500 $22,500
007 24/12/2016 6 HSM-315 PARTICULAR $4,500 $27,000
006 23/12/2016 7 WWW-882 TAXI $2,500 $17,500
005 22/12/2016 8 HRP-000 MOTO $1,000 $8,000
004 21/12/2016 9 BLN-210 PARTICULAR $4,500 $40,500
003 20/12/2016 10 ANA-520 PARTICULAR $4,500 $45,000
002 19/12/2016 11 TTZ-004 TAXI $2,500 $27,500
001 18/12/2016 12 OYK-089 PARTICULAR $4,500 $54,000
011 17/12/2016 13 PAM-815 COLECTIVO $3,000 $39,000
010 16/12/2016 14 JEA-211 MOTO $1,000 $14,000
009 15/12/2016 15 JPA-906 PARTICULAR $4,500 $67,500
008 14/12/2016 16 JFR-128 PARTICULAR $4,500 $72,000
007 13/12/2016 17 HSM-315 PARTICULAR $4,500 $76,500
006 12/12/2016 18 WWW-882 TAXI $2,500 $45,000
005 11/12/2016 19 HRP-000 MOTO $1,000 $19,000
004 10/12/2016 20 BLN-210 PARTICULAR $4,500 $90,000
003 09/12/2016 21 ANA-520 PARTICULAR $4,500 $94,500
002 08/12/2016 22 TTZ-004 TAXI $2,500 $55,000
001 07/12/2016 23 OYK-089 PARTICULAR $4,500 $103,500
011 06/12/2016 24 PAM-815 COLECTIVO $3,000 $72,000
010 05/12/2016 1 JEA-211 MOTO $1,000 $1,000
009 04/12/2016 2 JPA-906 PARTICULAR $4,500 $9,000
008 03/12/2016 3 JFR-128 PARTICULAR $4,500 $13,500
007 02/12/2016 4 HSM-315 PARTICULAR $4,500 $18,000
006 01/12/2016 5 WWW-882 TAXI $2,500 $12,500
005 30/11/2016 6 HRP-000 MOTO $1,000 $6,000
004 29/11/2016 7 BLN-210 PARTICULAR $4,500 $31,500
003 28/11/2016 8 ANA-520 PARTICULAR $4,500 $36,000
002 27/11/2016 9 TTZ-004 TAXI $2,500 $22,500
001 26/11/2016 10 OYK-089 PARTICULAR $4,500 $45,000
011 25/11/2016 11 PAM-815 COLECTIVO $3,000 $33,000
010 24/11/2016 12 JEA-211 MOTO $1,000 $12,000
009 23/11/2016 13 JPA-906 PARTICULAR $4,500 $58,500
008 22/11/2016 14 JFR-128 PARTICULAR $4,500 $63,000
007 21/11/2016 15 HSM-315 PARTICULAR $4,500 $67,500
006 20/11/2016 16 WWW-882 TAXI $2,500 $40,000
005 19/11/2016 17 HRP-000 MOTO $1,000 $17,000
004 18/11/2016 18 BLN-210 PARTICULAR $4,500 $81,000
003 17/11/2016 19 ANA-520 PARTICULAR $4,500 $85,500
002 16/11/2016 20 TTZ-004 TAXI $2,500 $50,000
001 15/11/2016 21 OYK-089 PARTICULAR $4,500 $94,500
011 14/11/2016 22 PAM-815 COLECTIVO $3,000 $66,000
010 13/11/2016 23 JEA-211 MOTO $1,000 $23,000
009 12/11/2016 24 JPA-906 PARTICULAR $4,500 $108,000
007 10/11/2016 1 HSM-315 PARTICULAR $4,500 $4,500
006 09/11/2016 2 WWW-882 TAXI $2,500 $5,000
005 08/11/2016 3 HRP-000 MOTO $1,000 $3,000
004 07/11/2016 4 BLN-210 PARTICULAR $4,500 $18,000
001 06/11/2016 5 OYK-089 PARTICULAR $4,500 $22,500
001 06/11/2016 6 OYK-089 PARTICULAR $4,500 $27,000
001 06/11/2016 7 OYK-089 PARTICULAR $4,500 $31,500
003 06/11/2016 8 ANA-520 PARTICULAR $4,500 $36,000
003 06/11/2016 9 ANA-520 PARTICULAR $4,500 $40,500
004 06/11/2016 10 BLN-210 PARTICULAR $4,500 $45,000
007 06/11/2016 11 HSM-315 PARTICULAR $4,500 $49,500
008 06/11/2016 12 JFR-128 PARTICULAR $4,500 $54,000
008 06/11/2016 13 JFR-128 PARTICULAR $4,500 $58,500
009 06/11/2016 14 JPA-906 PARTICULAR $4,500 $63,000
009 06/11/2016 15 JPA-906 PARTICULAR $4,500 $67,500
002 05/11/2016 16 TTZ-004 TAXI $2,500 $40,000
001 04/11/2016 17 OYK-089 PARTICULAR $4,500 $76,500
011 03/11/2016 18 PAM-815 COLECTIVO $3,000 $54,000
010 02/11/2016 19 JEA-211 MOTO $1,000 $19,000
008 31/10/2016 20 JFR-128 PARTICULAR $4,500 $90,000
007 30/10/2016 21 HSM-315 PARTICULAR $4,500 $94,500
006 29/10/2016 22 WWW-882 TAXI $2,500 $55,000
005 28/10/2016 23 HRP-000 MOTO $1,000 $23,000
004 27/10/2016 24 BLN-210 PARTICULAR $4,500 $108,000
003 26/10/2016 1 ANA-520 PARTICULAR $4,500 $4,500
002 25/10/2016 2 TTZ-004 TAXI $2,500 $5,000
011 23/10/2016 3 PAM-815 COLECTIVO $3,000 $9,000
010 22/10/2016 4 JEA-211 MOTO $1,000 $4,000
009 21/10/2016 5 JPA-906 PARTICULAR $4,500 $22,500
007 19/10/2016 6 HSM-315 PARTICULAR $4,500 $27,000
006 18/10/2016 7 WWW-882 TAXI $2,500 $17,500
005 17/10/2016 8 HRP-000 MOTO $1,000 $8,000
004 16/10/2016 9 BLN-210 PARTICULAR $4,500 $40,500
003 15/10/2016 10 ANA-520 PARTICULAR $4,500 $45,000
002 14/10/2016 11 TTZ-004 TAXI $2,500 $27,500
001 13/10/2016 12 OYK-089 PARTICULAR $4,500 $54,000
011 12/10/2016 13 PAM-815 COLECTIVO $3,000 $39,000
010 11/10/2016 14 JEA-211 MOTO $1,000 $14,000
008 09/10/2016 15 JFR-128 PARTICULAR $4,500 $67,500
007 08/10/2016 16 HSM-315 PARTICULAR $4,500 $72,000
006 07/10/2016 17 WWW-882 TAXI $2,500 $42,500
005 06/10/2016 18 HRP-000 MOTO $1,000 $18,000
004 05/10/2016 19 BLN-210 PARTICULAR $4,500 $85,500
003 04/10/2016 20 ANA-520 PARTICULAR $4,500 $90,000
002 03/10/2016 21 TTZ-004 TAXI $2,500 $52,500
002 01/10/2016 22 TTZ-004 TAXI $2,500 $55,000
005 01/10/2016 23 HRP-000 MOTO $1,000 $23,000
006 01/10/2016 24 WWW-882 TAXI $2,500 $60,000
008 01/10/2016 1 JFR-128 PARTICULAR $4,500 $4,500
009 01/10/2016 2 JPA-906 PARTICULAR $4,500 $9,000
010 01/10/2016 3 JEA-211 MOTO $1,000 $3,000
011 01/10/2016 4 PAM-815 COLECTIVO $3,000 $12,000
PROPIETARIO
AMPARO CORREA 14. Realice una tabla dínamica, que muestre los
PEDRO MATURANA propietarios.
BLANCA GARCIA
CARLOS ANDRADE
ANA ANDRADE
PAOLA ANDRADE
ADRIAN BERNAL
JESUS RENTERIA A.
LINA MARIN
HECTOR MOSQUERA
ROBERTO GARCIA
PEDRO MATURANA MENÚ
AMPARO CORREA
CARLOS ANDRADE
BLANCA GARCIA
PAOLA ANDRADE
ANA ANDRADE
JESUS RENTERIA A.
ADRIAN BERNAL
HECTOR MOSQUERA
LINA MARIN
ROBERTO GARCIA
AMPARO CORREA
PEDRO MATURANA
BLANCA GARCIA
CARLOS ANDRADE
ANA ANDRADE
PAOLA ANDRADE
ADRIAN BERNAL
JESUS RENTERIA A.
LINA MARIN
HECTOR MOSQUERA
ROBERTO GARCIA
PEDRO MATURANA
AMPARO CORREA
CARLOS ANDRADE
BLANCA GARCIA
PAOLA ANDRADE
ANA ANDRADE
JESUS RENTERIA A.
ADRIAN BERNAL
HECTOR MOSQUERA
LINA MARIN
ROBERTO GARCIA
AMPARO CORREA
PEDRO MATURANA
BLANCA GARCIA
CARLOS ANDRADE
ANA ANDRADE
PAOLA ANDRADE
ADRIAN BERNAL
JESUS RENTERIA A.
LINA MARIN
HECTOR MOSQUERA
ROBERTO GARCIA
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
LINA MARIN
LINA MARIN
LINA MARIN
ANA ANDRADE
ANA ANDRADE
BLANCA GARCIA
HECTOR MOSQUERA
JESUS RENTERIA A.
JESUS RENTERIA A.
PAOLA ANDRADE
PAOLA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
PEDRO MATURANA
CARLOS ANDRADE
PAOLA ANDRADE
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
LINA MARIN
PEDRO MATURANA
CARLOS ANDRADE
JESUS RENTERIA A.
HECTOR MOSQUERA
ROBERTO GARCIA
AMPARO CORREA
BLANCA GARCIA
ANA ANDRADE
ADRIAN BERNAL
ADRIAN BERNAL
AMPARO CORREA
ROBERTO GARCIA
JESUS RENTERIA A.
PAOLA ANDRADE
CARLOS ANDRADE
PEDRO MATURANA
e muestre los
# DE CELDA - all -

Count - TOTAL PLACA


PROPIETARIO ANA-520 BLN-210 HRP-000 HSM-315 JEA-211
ADRIAN BERNAL
AMPARO CORREA 20
ANA ANDRADE 20
BLANCA GARCIA 20
CARLOS ANDRADE 20
HECTOR MOSQUERA 20
JESUS RENTERIA A.
LINA MARIN
PAOLA ANDRADE
PEDRO MATURANA
ROBERTO GARCIA
(empty)
Total Result 20 20 20 20 20
JFR-128 JPA-906 OYK-089 PAM-815 TTZ-004 WWW-882 (empty) Total Result
20 20
20
20
20
20
20
20 20
20 20
20 20
20 20
20 20

20 20 20 20 20 20 220

También podría gustarte