FUNCION BUSCARV ''COLUMNA"

Empleado Categoria Puesto

Tabla de Puesto
A Gerentes
B Admvo
C Operario
D Group Leader

"=BUSCARV(C4,$B$12:$C$12,2)
 Data
DEPARTAMENTO NOMBRE Max - SUELDO
ADMINISTRATIVO RD$ 35,000.00
IVAN COMEZ GARCIA RD$ 35,000.00
AUDITORIA RD$ 39,000.00
JOSE LUIS NUÑEZ RD$ 39,000.00
CONTABILIDAD RD$ 33,900.00
ANA ROSARIO RD$ 33,900.00
GERENCIA RD$ 73,087.50
LUIS RODRIGUEZ RD$ 73,087.50
GESTION HUMANA RD$ 67,000.00
ALEXANDRA ESPINAL RD$ 28,300.00
CANTIDAD RAMIREZ RD$ 67,000.00
CARMEN SANTANA RD$ 59,002.55
YINET ZABALA RD$ 44,000.00
IFORMATICA RD$ 9,500.00
MELISSA MATEO RD$ 9,500.00
INFORMATICA RD$ 29,000.00
JUAN CARLOS LOPEZ RD$ 29,000.00
MANTENIMIENTO RD$ 50,000.00
ELENA PEREZ RD$ 50,000.00
MERCADEO RD$ 45,659.40
CARLOS CASTRO RD$ 45,659.40
LUCIA VIZCAINO RD$ 32,000.00
PDRODUCCION RD$ 34,897.53
CASILDA REYES RD$ 34,897.53
PRDDUCCION RD$ 53,000.00
ENRIQUE VALDEZ RD$ 53,000.00
PRODUCCION RD$ 71,267.50
BRAYAN ALMONTE RD$ 71,267.50
ZULEIKA REINOSO RD$ 40,000.00
SEGURIDAD RD$ 55,919.28
AMAURIS MEDINA RD$ 29,600.00
MERCEDES MARTINEZ RD$ 55,919.28
SEV.CLINTE RD$ 75,272.00
NICOLE PEREZ RD$ 75,272.00
SRV.CLINTE RD$ 69,000.00
ANDREA FERMIN RD$ 69,000.00
VENTA RD$ 29,700.00
RAMON JIMENEZ RD$ 29,700.00
VENTAS RD$ 100,804.50
CANDIDA RAMIREZ RD$ 19,876.14
JUAN NUÑEZ RD$ 100,804.50
 VIOLETA VALIENTE RD$ 49,000.00
WANDA JOSEFINA RD$ 38,900.00
Total Result RD$ 100,804.50

500000
400000
300000
200000 Column G
100000 Column F
0 Column E
Column D
Data
Column B
Min - SUELDO Max - SUELDO Max - SUELDO
RD$ 35,000.00 RD$ 35,000.00 RD$ 35,000.00
RD$ 35,000.00 RD$ 35,000.00 RD$ 35,000.00
RD$ 39,000.00 RD$ 39,000.00 RD$ 39,000.00
RD$ 39,000.00 RD$ 39,000.00 RD$ 39,000.00
RD$ 33,900.00 RD$ 33,900.00 RD$ 33,900.00
RD$ 33,900.00 RD$ 33,900.00 RD$ 33,900.00
RD$ 73,087.50 RD$ 73,087.50 RD$ 73,087.50
RD$ 73,087.50 RD$ 73,087.50 RD$ 73,087.50
RD$ 28,300.00 RD$ 67,000.00 RD$ 67,000.00
RD$ 28,300.00 RD$ 28,300.00 RD$ 28,300.00
RD$ 67,000.00 RD$ 67,000.00 RD$ 67,000.00
RD$ 59,002.55 RD$ 59,002.55 RD$ 59,002.55
RD$ 44,000.00 RD$ 44,000.00 RD$ 44,000.00
RD$ 9,500.00 RD$ 9,500.00 RD$ 9,500.00
RD$ 9,500.00 RD$ 9,500.00 RD$ 9,500.00
RD$ 29,000.00 RD$ 29,000.00 RD$ 29,000.00
RD$ 29,000.00 RD$ 29,000.00 RD$ 29,000.00
RD$ 50,000.00 RD$ 50,000.00 RD$ 50,000.00
RD$ 50,000.00 RD$ 50,000.00 RD$ 50,000.00
RD$ 32,000.00 RD$ 45,659.40 RD$ 45,659.40
RD$ 45,659.40 RD$ 45,659.40 RD$ 45,659.40
RD$ 32,000.00 RD$ 32,000.00 RD$ 32,000.00
RD$ 34,897.53 RD$ 34,897.53 RD$ 34,897.53
RD$ 34,897.53 RD$ 34,897.53 RD$ 34,897.53
RD$ 53,000.00 RD$ 53,000.00 RD$ 53,000.00
RD$ 53,000.00 RD$ 53,000.00 RD$ 53,000.00
RD$ 40,000.00 RD$ 71,267.50 RD$ 71,267.50
RD$ 71,267.50 RD$ 71,267.50 RD$ 71,267.50
RD$ 40,000.00 RD$ 40,000.00 RD$ 40,000.00
RD$ 29,600.00 RD$ 55,919.28 RD$ 55,919.28
RD$ 29,600.00 RD$ 29,600.00 RD$ 29,600.00
RD$ 55,919.28 RD$ 55,919.28 RD$ 55,919.28
RD$ 75,272.00 RD$ 75,272.00 RD$ 75,272.00
RD$ 75,272.00 RD$ 75,272.00 RD$ 75,272.00
RD$ 69,000.00 RD$ 69,000.00 RD$ 69,000.00
RD$ 69,000.00 RD$ 69,000.00 RD$ 69,000.00
RD$ 29,700.00 RD$ 29,700.00 RD$ 29,700.00
RD$ 29,700.00 RD$ 29,700.00 RD$ 29,700.00
RD$ 19,876.14 RD$ 100,804.50 RD$ 100,804.50
RD$ 19,876.14 RD$ 19,876.14 RD$ 19,876.14
RD$ 100,804.50 RD$ 100,804.50 RD$ 100,804.50
RD$ 49,000.00 RD$ 49,000.00 RD$ 49,000.00
RD$ 38,900.00 RD$ 38,900.00 RD$ 38,900.00
RD$ 9,500.00 RD$ 100,804.50 RD$ 100,804.50
Max - DESCUENTO Min - DESCUENTO
RD$ 700.00 RD$ 700.00
RD$ 700.00 RD$ 700.00
RD$ 800.00 RD$ 800.00
RD$ 800.00 RD$ 800.00
RD$ 800.00 RD$ 800.00
RD$ 800.00 RD$ 800.00
RD$ 600.00 RD$ 600.00
RD$ 600.00 RD$ 600.00
RD$ 600.00 RD$ 400.00
RD$ 600.00 RD$ 600.00
RD$ 400.00 RD$ 400.00
RD$ 500.00 RD$ 500.00
RD$ 400.00 RD$ 400.00
RD$ 879.00 RD$ 879.00
RD$ 879.00 RD$ 879.00
RD$ 400.00 RD$ 400.00
RD$ 400.00 RD$ 400.00
RD$ 600.00 RD$ 600.00
RD$ 600.00 RD$ 600.00
RD$ 760.00 RD$ 500.00
RD$ 760.00 RD$ 760.00
RD$ 500.00 RD$ 500.00
RD$ 740.00 RD$ 740.00
RD$ 740.00 RD$ 740.00
RD$ 549.00 RD$ 549.00
RD$ 549.00 RD$ 549.00
RD$ 800.00 RD$ 580.00
RD$ 580.00 RD$ 580.00
RD$ 800.00 RD$ 800.00
RD$ 560.00 RD$ 400.00
RD$ 400.00 RD$ 400.00
RD$ 560.00 RD$ 560.00
RD$ 400.00 RD$ 400.00
RD$ 400.00 RD$ 400.00
RD$ 1,050.00 RD$ 1,050.00
RD$ 1,050.00 RD$ 1,050.00
RD$ 1,000.00 RD$ 1,000.00
RD$ 1,000.00 RD$ 1,000.00
RD$ 970.00 RD$ 457.00
RD$ 470.00 RD$ 470.00
RD$ 457.00 RD$ 457.00
RD$ 970.00 RD$ 970.00
RD$ 740.00 RD$ 740.00
RD$ 1,050.00 RD$ 400.00
 NOMBRE DEPARTAMENTO SUELDO
LUCIA VIZCAINO MERCADEO RD$ 32,000.00
JUAN CARLOS LOPEZ INFORMATICA RD$ 29,000.00
ANA ROSARIO CONTABILIDAD RD$ 33,900.00
ALEXANDRA ESPINAL GESTION HUMANA RD$ 28,300.00
AMAURIS MEDINA SEGURIDAD RD$ 29,600.00
JOSE LUIS NUÑEZ AUDITORIA RD$ 39,000.00
RAMON JIMENEZ VENTA RD$ 29,700.00
IVAN COMEZ GARCIA ADMINISTRATIVO RD$ 35,000.00
WANDA JOSEFINA VENTAS RD$ 38,900.00
BRAYAN ALMONTE PRODUCCION RD$ 71,267.50
NICOLE PEREZ SEV.CLINTE RD$ 75,272.00
LUIS RODRIGUEZ GERENCIA RD$ 73,087.50
CARMEN SANTANA GESTION HUMANA RD$ 59,002.55
CARLOS CASTRO MERCADEO RD$ 45,659.40
MERCEDES MARTINEZ SEGURIDAD RD$ 55,919.28
CANDIDA RAMIREZ VENTAS RD$ 19,876.14
CASILDA REYES PDRODUCCION RD$ 34,897.53
JUAN NUÑEZ VENTAS RD$ 100,804.50
MELISSA MATEO IFORMATICA RD$ 9,500.00
ENRIQUE VALDEZ PRDDUCCION RD$ 53,000.00
YINET ZABALA GESTION HUMANA RD$ 44,000.00
ELENA PEREZ MANTENIMIENTO RD$ 50,000.00
ZULEIKA REINOSO PRODUCCION RD$ 40,000.00
VIOLETA VALIENTE VENTAS RD$ 49,000.00
ANDREA FERMIN SRV.CLINTE RD$ 69,000.00
CANTIDAD RAMIREZ GESTION HUMANA RD$ 67,000.00
 DESCUENTO
RD$ 500.00
RD$ 400.00
RD$ 800.00
RD$ 600.00
RD$ 400.00
RD$ 800.00
RD$ 1,000.00
RD$ 700.00
RD$ 740.00
RD$ 580.00
RD$ 400.00
RD$ 600.00
RD$ 500.00
RD$ 760.00
RD$ 560.00
RD$ 470.00
RD$ 740.00
RD$ 457.00
RD$ 879.00
RD$ 549.00
RD$ 400.00
RD$ 600.00
RD$ 800.00
RD$ 970.00
RD$ 1,050.00
RD$ 400.00