ACTIVIDADES DE APLICACIÓN PARA EL PORTAFOLIO:

En una hoja de cálculo la empresa SURTIMAYORISTA lleva los nombres de sus vendedores y las ventas qu

Archivo adjunto EMPRESA SURTIMAYORISTA

También lleva en la misma hoja el salario base

1.     Calcula el total de ventas por cada trimestre

2.     El máximo, mínimo y promedio de las ventas por trimestre
3.     Introduce el siguiente formato condicional:
a)     Celdas Máximo ventas: Si es superior a 10.000.000 : letra color rojo negrita, fondo marfil
b)     Celdas Mínimo Ventas: Si es menor o igual a 1.500.000: letra color blanco negrita, fondo azul tinta
c)     Celdas Promedio ventas: si es superior a 8.000.000, letra en negrita, fondo lavanda
4.     El formato del texto es Arial Narrow 11
5.     Ordena los datos por orden alfabético
PARA LOS SALARIOS
6. Ordena de la A a la Z
7, Filtre salarios entre $850000 y $1000000
8. Filtre personas que enpiecen por la letra J
9. Filtre salarios de mas de $1000000
10. Filtre para cedulas de extranjeria
dedores y las ventas que realizaron en el año 2018.

ndo marfil
rita, fondo azul tinta
 NUMERO
TIPO VENTAS VENTAS
IDENTIFICACI NOMBRE DEL VENDEDOR
ID ENERO FEBRERO
ON
CE 456580 LUIS EMILIO LOPEZ CASTELLANOS 13,300,000 6,700,000
CE 468414 LEOVICELDO ANTONIO GONZALEZ SARMIENTO 11,300,000 5,700,000
CC 474844 MARCO EMILIO PRIETO DIAZ 6,000,000 3,100,000
CC 478708 HERMES MARTIN MARTINEZ ROA 2,900,000 2,800,000
CC 479094 GABRIEL ALBERTO SERNA RESTREPO 3,600,000 1,900,000
CC 579089 GILDARDO DE JESUS RODRIGUEZ ZAPATA 2,500,000 2,300,000
CC 593511 JOSE MANUEL GALLEGO GOMEZ 4,400,000 3,300,000
CC 667778 JOSE IVAN ALVAREZ ALVAREZ 47,200,000 23,700,000
CC 785490 RICARDO TULIO SALDARRIAGA RESTREPO 2,600,000 1,400,000
CC 873996 PEDRO ADAN CASTRO BLANCO 17,700,000 8,900,000
CE 901507 ADALBERTO CORTES SUAREZ 35,900,000 18,000,000
CC 917231 HUGO CESAR PADILLA POLO 9,800,000 5,000,000
CC 1004335 MARCO TULIO ARAQUE - 10,400,000 5,300,000
CC 1004456 ALEJANDRO GIL ARAQUE 9,500,000 5,500,000
CC 1009264 TEODORO GONZALEZ 7,200,000 3,700,000
CC 1013547 WILLIAM HERNEY PEÑA WILCHES 5,900,000 3,000,000
CC 1015186 PABLO JAIRO HUERTAS TORRES 11,500,000 6,000,000
CC 1015290 HILDEBRANDO VALBUENA INFANTE 4,700,000 2,400,000
CC 1024839 JOSE MARIA SALAZAR GOMEZ 5,100,000 3,300,000
CC 1032022 NICOLAS PULIDO 9,000,000 4,600,000
CC 1037032 HECTOR RODRIGO CUADROS DUARTE 5,900,000 3,000,000
CC 1042660 JOSE DOMINGO VARGAS ROJAS 14,600,000 11,100,000
CC 1047376 PEDRO IGNACIO CHINOME MALAGON 7,400,000 3,800,000
CC 1066244 ROBERTO RAMIREZ SANDOVAL 5,100,000 4,600,000
CC 1068392 JUAN DE DIOS DUARTE SANDOVAL 8,000,000 4,100,000
CC 1068687 ALCIDES - RIAQO GAMBOA 4,700,000 3,100,000
CC 1072798 MARTIN PANQUEVA CACERES 16,000,000 8,100,000
CC 1073468 GONZALO PANQUEVA MARIN 2,400,000 1,300,000
CC 1099474 GONZALO CASTRO CASTRO 1,800,000 1,100,000
CC 1113252 AUGUSTO - MANRIQUE - 5,900,000 3,000,000
CC 1113474 TULIO CUEVAS MARCO 4,500,000 3,500,000
CC 1124184 JORGE RAMIRO SUAZO AVENDAÑO 6,000,000 3,300,000
CC 1124214 JOSE MIGUEL JEREZ GONZALEZ 2,800,000 2,200,000
CC 1128863 LUIS ALFREDO CASTIBLANCO SUAREZ 1,700,000 1,100,000
CC 1146876 MARCO ANTONIO CHAPARRO ROJAS 4,700,000 2,400,000
CC 1150059 JAIRO AUGUSTO MENDIVELSO TORRES 3,000,000 1,700,000
CC 1177606 JOSE EDUARDO RODRIGUEZ 5,900,000 3,000,000
CC 1177641 VICTOR JULIO PINTO MONTAÑEZ 5,600,000 3,600,000
CC 1210263 LUIS GONZALO CAMPIÑO MARTINEZ 8,600,000 4,400,000
CC 1211542 LUIS ARTURO TABORDA MARIN 9,200,000 8,700,000
CC 1256306 ANCIZAR CASTAQEDO ACEVEDO 8,400,000 4,300,000
CC 1310994 RUBEN DE JESUS CARDONA ATEHORTUA 7,100,000 3,600,000
CC 1311780 FIDEL ANTONIO RIVERA GRISALES 5,000,000 2,600,000
CC 1327993 JOSE CONRADO BETANCUR - 6,400,000 3,300,000
CC 1349714 CARLOS ABEL GALLEGO GALLEGO 8,400,000 5,200,000
CC 1353645 GUILLERMO ALFONSO LAGOS ROA 6,600,000 3,400,000
CC 1370012 FABIO HERRERA HERRERA 5,900,000 3,000,000
CC 1476827 JAVIER OMAR PINO MUÑOZ 5,900,000 3,000,000
CC 1592872 LUIS CARLOS BENITEZ VALENCIA 9,400,000 5,800,000
CC 1697791 ADALBERTO ENRIQUE RICO MARTINEZ 8,000,000 4,100,000
CC 1716419 LACIDES CAMARGO ARMENTA 2,900,000 1,500,000
CC 43677342 GLORIA ELENA DAVID ZAPATA 13,700,000 6,900,000
CC 70515220 HERNANDO MEJIA DIEZ 10,500,000 5,300,000
CC 7369367 JADER ANTONIO DIAZ CORDERO 1,900,000 1,800,000
CC 70559827 JAIME ALBERTO SANCHEZ OROZCO 4,100,000 2,100,000
CC 71698411 JAIRO SANCHEZ JOHN 6,900,000 4,800,000
CC 7510540 JESUS ELIAS ARANGO 2,000,000 1,900,000
CC 3515828 JOAQUIN GUILLERMO MONSALVE MACIAS 4,700,000 3,100,000
CC 3329775 JORGE ANGEL CANO BARRERA 11,800,000 6,000,000
CC 71626559 JORGE ENRIQUE GONZALEZ LARGO 15,900,000 8,000,000
CC 6783145 JORGE IGNACIO ARANGO VARGAS 6,000,000 3,100,000
CC 15919931 JORGE LINO ANDICA BUENO 4,500,000 2,300,000
CC 71265223 JUAN CAMILO BETANCUR LENIS 13,300,000 7,700,000
CC 71792551 JULIAN ALBERTO BEDOYA 1,800,000 1,100,000
CC 71389401 JULIAN VELASQUEZ MUQOZ 24,400,000 13,000,000
CC 42895889 LILIANA MARIA ALVAREZ AREIZA 1,200,000 1,100,000
CC 32102821 LILIANA MARIA HENAO CASTAÑEDA 11,800,000 6,200,000
CC 43253068 LINA MARCELA VALENCIA DURANGO 8,400,000 4,300,000
CC 43540804 LINA MARIA DE FAT PEÑA CHICA 19,400,000 9,800,000
CC 3606197 LUIS ALFONSO GONZALEZ ZULUAGA 4,100,000 2,400,000
CC 18493836 LUIS ALFREDO PAVA MESA 8,100,000 4,300,000
CC 6706578 LUIS BELTRAN USUGA VELASQUEZ 9,300,000 4,700,000
CC 98549372 LUIS ENRIQUE CASTAÑO 6,000,000 3,100,000
CC 98456394 LUIS EVELIO OSORIO HERRERA 2,600,000 1,400,000
CC 70079213 LUIS FERNANDO ROJAS RUIZ 12,000,000 6,100,000
CC 8027917 LUIS MAURICIO TABORDA GONZALEZ 7,200,000 3,700,000
CC 42886844 LUZ ELENA TAMAYO ARANGO 2,500,000 1,300,000
CC 43010607 LUZ ESTER ECHAVARRIA PEREZ 15,500,000 7,800,000
CC 32411235 LUZ HELENA CORREA DELGADO 5,600,000 2,900,000
CC 42978019 LUZ MARINA MONTES LOPEZ 2,200,000 1,200,000
CC 42966091 MARIA ALBERTINA GALLEGO GALLEGO 8,300,000 4,200,000
CC 22100801 MARIA ARACELLY MEJIA DE PEREZ 2,400,000 1,300,000
CC 42985503 MARIA CRISTINA CALDERON BETANCUR 8,900,000 4,600,000
CC 43208684 MARIA DEL CARMEN GARCIA MARTINEZ 11,700,000 5,900,000
CC 32489217 MARIA ELENA GUERRA GARCIA 5,800,000 3,500,000
CC 32469220 MARIA GLADYS MESA ALVAREZ 12,000,000 7,000,000
CC 24837406 MARIA LUCIA RODRIGUEZ JIMENEZ 4,700,000 2,400,000
CC 32544837 MARIA LUCRECIA VILLADA VELEZ 1,700,000 1,100,000
CC 32522105 MARIA MAGNELY DE J PANIAGUA GOMEZ 1,800,000 1,700,000
CC 32428108 MARIELA FORONDA DE GIRALDO 4,000,000 3,800,000
CC 70721318 MARIO DE JESUS OSORIO MARULANDA 2,300,000 1,200,000
CC 21565425 MARLENY CORTES VARGAS 4,700,000 3,100,000
CC 43824978 MARTA IRENE MUÑOZ MUÑOZ 4,500,000 2,800,000
CC 43055031 MARTHA CECILIA PIMIENTA GONZALEZ 3,500,000 1,800,000
CC 43021269 MARTHA LUCIA LOPEZ CEBALLOS 3,500,000 2,000,000
CC 32256158 MILENA PATRICIA OLAYA GALLEGO 11,200,000 5,700,000
CC 98661304 OSCAR ALBERTO GUERRA 3,600,000 2,300,000
CC 71605424 REINALDO ALONSO RUA BOHORQUEZ 3,100,000 1,600,000
CC 71684784 RODRIGO TABORDA CANO 4,100,000 2,100,000
Totales del mes: 757,500,000 419,000,000
Total Trimestre: 1,287,411,42
Promedio Trimestre 429,137,14
Valor maximo de ventas 47,200,00
Valor Minimo de ventas 535,60
VENTAS VETAS VENTAS VENTAS VENTAS VETAS
MARZO ABRIL MAYO JUNIO JULIO AGOSTO

2,495,922 1,922,267 2,800,000 2,500,000 535,600 535,600

1,595,353 1,108,615 4,000,000 2,100,000 535,600 535,600
600,000 535,600 5,000,000 2,600,000 535,600 535,600
2,268,267 2,259,575 4,000,000 3,200,000 719,690 650,156
535,600 535,600 5,100,000 2,600,000 941,116 723,823
535,600 535,600 2,500,000 1,300,000 535,600 535,600
1,040,278 944,669 2,700,000 1,400,000 1,929,256 1,816,264
4,774,159 2,731,600 3,500,000 1,800,000 535,600 535,600
535,600 535,600 11,600,000 5,900,000 1,312,686 817,257
1,770,000 890,000 9,200,000 4,700,000 1,735,196 1,344,067
4,536,860 2,981,039 2,500,000 2,300,000 535,600 535,600
2,807,618 2,390,414 30,000,000 15,100,000 7,849,250 6,732,303
1,104,622 772,163 29,700,000 14,900,000 3,797,576 2,511,198
950,000 550,000 4,700,000 2,400,000 961,951 762,041
951,090 646,879 6,400,000 3,300,000 640,000 535,600
806,964 554,903 4,200,000 2,200,000 780,609 606,774
1,150,000 600,000 7,600,000 3,900,000 948,122 626,528
535,600 535,600 5,600,000 2,900,000 705,746 535,600
535,600 535,600 2,400,000 1,300,000 535,600 535,600
1,409,145 1,122,317 7,200,000 3,700,000 720,000 535,600
857,510 605,450 3,500,000 1,800,000 535,600 535,600
1,914,749 1,610,538 3,500,000 1,800,000 535,600 535,600
1,018,465 705,562 4,600,000 3,300,000 910,022 825,277
2,636,154 2,592,696 2,400,000 1,400,000 535,600 535,600
800,000 535,600 3,100,000 1,600,000 535,600 535,600
597,193 535,600 8,300,000 4,200,000 1,408,477 1,052,116
1,600,000 833,512 10,200,000 5,200,000 1,792,189 1,357,602
535,600 535,600 3,800,000 2,000,000 906,899 750,447
535,600 535,600 4,500,000 2,300,000 1,475,868 1,284,650
590,000 535,600 6,000,000 3,100,000 639,887 535,600
632,792 545,874 3,600,000 1,900,000 765,742 617,982
784,462 549,785 1,800,000 1,100,000 535,600 535,600
535,600 535,600 5,800,000 3,900,000 2,061,247 1,896,104
535,600 535,600 5,900,000 3,000,000 642,776 535,600
535,600 535,600 4,200,000 2,200,000 535,600 535,600
535,600 535,600 6,400,000 3,300,000 1,075,896 806,452
 590,000 535,600 2,500,000 2,100,000 535,600 535,600
768,883 595,048 5,500,000 3,700,000 550,000 535,600
2,436,350 2,162,560 1,600,000 1,100,000 552,401 535,600
1,601,172 1,557,714 2,400,000 1,500,000 535,600 535,600
840,000 535,600 2,600,000 2,000,000 631,302 579,152
710,000 535,600 3,400,000 2,700,000 838,316 777,474
535,600 535,600 3,000,000 1,600,000 535,600 535,600
1,154,049 884,605 2,200,000 1,800,000 535,600 535,600
1,461,796 1,183,660 5,900,000 3,000,000 1,120,843 868,783
694,260 535,600 5,000,000 3,800,000 535,600 535,600
590,000 535,600 4,900,000 2,500,000 2,595,690 2,387,089
590,000 535,600 6,500,000 3,300,000 1,354,545 1,076,410
1,297,667 984,765 2,500,000 1,300,000 808,405 704,104
800,000 535,600 7,100,000 4,500,000 738,058 535,600
535,600 535,600 9,000,000 4,600,000 900,000 535,600
1,622,643 1,031,605 5,000,000 2,600,000 535,600 535,600
1,257,685 805,714 2,600,000 2,300,000 816,906 790,831
535,600 535,600 7,900,000 4,000,000 790,000 535,600
535,600 535,600 3,700,000 1,900,000 535,600 535,600
971,257 788,730 4,600,000 2,400,000 1,770,938 1,579,720
535,600 535,600 3,500,000 2,800,000 535,600 535,600
535,600 535,600 6,400,000 3,300,000 1,507,382 1,237,939
1,180,000 600,000 9,000,000 4,600,000 900,000 535,600
3,075,780 2,389,133 1,700,000 1,400,000 535,600 535,600
600,000 535,600 3,500,000 2,900,000 535,600 535,600
614,669 535,600 3,000,000 2,500,000 535,600 535,600
2,074,862 1,588,125 6,000,000 3,300,000 600,000 535,600
2,083,118 2,022,276 5,000,000 4,100,000 535,600 535,600
2,637,072 1,646,214 7,100,000 4,400,000 1,443,407 1,208,730
535,600 535,600 3,500,000 1,800,000 813,418 665,658
1,180,000 620,000 5,100,000 2,600,000 4,421,056 4,203,763
1,016,773 660,411 1,600,000 1,100,000 1,036,846 993,387
3,894,794 3,060,387 10,100,000 5,300,000 1,024,049 606,845
535,600 535,600 2,700,000 1,400,000 535,600 535,600
1,035,457 705,171 9,600,000 4,900,000 2,499,598 2,091,087
930,000 535,600 12,500,000 6,300,000 2,047,749 1,508,861
1,089,742 837,681 35,700,000 17,900,000 6,235,754 4,688,624
535,600 535,600 9,500,000 4,800,000 950,000 535,600
1,200,000 636,863 11,400,000 6,700,000 1,231,854 823,343
 720,000 535,600 3,700,000 1,900,000 3,636,840 3,480,389
714,501 610,200 2,400,000 1,400,000 539,603 535,600
2,497,331 1,828,067 18,100,000 9,100,000 2,628,865 1,846,609
589,375 535,600 5,900,000 4,000,000 590,000 535,600
569,382 535,600 23,600,000 11,900,000 2,360,000 1,190,000
830,000 535,600 3,000,000 2,500,000 535,600 535,600
535,600 535,600 31,300,000 15,700,000 3,930,713 2,574,801
890,000 535,600 10,300,000 6,300,000 1,507,542 1,159,872
2,052,489 1,548,368 4,200,000 2,600,000 1,125,562 986,495
580,000 535,600 14,200,000 7,200,000 1,612,596 1,004,175
1,316,943 882,356 15,000,000 7,900,000 1,500,000 792,127
535,600 535,600 3,500,000 1,800,000 1,219,051 1,071,291
535,600 535,600 3,500,000 2,800,000 535,600 535,600
535,600 535,600 4,800,000 3,400,000 535,600 535,600
539,125 535,600 12,800,000 6,500,000 1,344,860 797,281
537,688 535,600 6,000,000 4,000,000 600,000 535,600
732,363 593,295 7,400,000 4,800,000 2,257,764 2,031,778
535,600 535,600 6,100,000 3,500,000 705,077 535,600
672,586 535,600 5,900,000 3,000,000 807,228 555,167
535,600 535,600 6,300,000 4,100,000 630,000 535,600
1,146,808 668,762 4,700,000 2,600,000 555,357 535,600
607,055 535,600 2,300,000 1,200,000 535,600 535,600
1,764,949 1,634,573 3,600,000 2,800,000 535,600 535,600
535,600 535,600 14,900,000 7,500,000 1,490,000 750,000
110,911,427 86,759,741 676,600,000 375,500,000 118,543,376 96,992,826
1,287,411,427 1,138,859,741 837,336,202
429,137,142 379,619,914 279,112,067
47,200,000 35,700,000 50,000,000
535,600 535,600 535,600
 VENTAS VENTAS VENTAS VETAS
SEPTIEMBRE OCTUBRE NOVIEMBRE DICIEMBRE

6,000,000 3,100,000 854,838 602,777

2,200,000 1,900,000 535,600 535,600
12,000,000 6,400,000 1,200,000 640,000
4,900,000 2,500,000 1,142,824 934,222
6,000,000 3,100,000 835,494 583,433
3,600,000 1,900,000 535,600 535,600
6,600,000 4,300,000 834,295 634,385
1,500,000 1,400,000 679,061 670,369
5,600,000 3,900,000 722,307 574,548
1,300,000 1,100,000 583,112 570,075
6,200,000 3,300,000 934,655 682,594
1,900,000 1,600,000 555,484 535,600
3,900,000 2,000,000 752,726 587,583
5,500,000 2,800,000 2,078,046 1,843,369
4,700,000 2,400,000 729,245 535,600
1,200,000 1,100,000 1,119,856 1,111,165
6,400,000 3,900,000 640,000 535,600
9,600,000 4,900,000 1,759,125 1,350,613
4,400,000 2,300,000 535,600 535,600
2,600,000 1,400,000 535,600 535,600
7,100,000 4,200,000 710,000 535,600
4,900,000 2,500,000 879,819 671,217
5,300,000 2,700,000 535,600 535,600
2,600,000 1,400,000 535,600 535,600
1,300,000 1,100,000 538,042 535,600
4,800,000 4,500,000 1,509,557 1,483,482
2,100,000 1,500,000 535,600 535,600
4,300,000 2,200,000 898,189 715,663
7,200,000 3,700,000 720,000 535,600
1,800,000 1,300,000 535,600 535,600
4,000,000 2,800,000 612,335 535,600
5,800,000 3,000,000 732,403 535,600
8,200,000 5,900,000 2,086,757 1,886,847
6,700,000 3,400,000 699,380 535,600
15,600,000 7,900,000 1,560,000 790,000
21,900,000 11,000,000 2,781,999 1,834,600
 8,100,000 4,100,000 861,152 535,600
6,500,000 3,300,000 650,000 535,600
9,500,000 4,800,000 1,038,804 630,293
3,600,000 2,800,000 535,600 535,600
12,200,000 6,200,000 1,769,215 1,247,710
3,900,000 2,000,000 649,336 535,600
6,900,000 3,500,000 964,412 668,893
8,400,000 4,300,000 840,000 535,600
5,300,000 2,700,000 718,520 535,600
1,800,000 1,700,000 535,600 535,600
4,700,000 2,400,000 535,600 535,600
2,500,000 1,300,000 1,041,303 963,078
6,400,000 5,300,000 2,132,023 2,036,413
10,200,000 5,200,000 1,113,704 679,117
5,900,000 3,000,000 590,000 535,600
1,800,000 1,300,000 535,600 535,600
5,100,000 2,600,000 1,072,857 855,564
9,400,000 4,800,000 1,344,228 944,408
6,000,000 3,100,000 600,000 535,600
12,000,000 6,700,000 1,367,222 919,920
2,300,000 2,200,000 535,600 535,600
4,900,000 3,000,000 535,600 535,600
5,200,000 3,300,000 1,511,377 1,346,234
2,400,000 2,200,000 883,387 866,004
6,400,000 4,200,000 640,000 535,600
2,600,000 1,400,000 535,600 535,600
8,300,000 4,200,000 830,000 535,600
2,500,000 1,300,000 535,600 535,600
12,300,000 6,200,000 2,554,128 2,023,932
1,200,000 1,100,000 535,600 535,600
7,400,000 3,800,000 761,572 535,600
4,000,000 2,300,000 1,097,297 949,538
5,000,000 2,600,000 772,365 563,763
6,300,000 5,100,000 819,571 715,270
27,000,000 13,600,000 5,059,736 3,895,043
5,300,000 2,700,000 828,572 602,587
3,800,000 2,000,000 988,180 831,729
8,100,000 4,100,000 1,011,086 663,417
4,100,000 2,100,000 1,557,486 1,383,651
 5,900,000 3,000,000 1,035,763 783,703
4,700,000 3,700,000 1,092,998 1,006,081
2,600,000 1,400,000 965,037 860,736
2,500,000 1,500,000 535,600 535,600
3,200,000 1,700,000 535,600 535,600
2,400,000 1,300,000 535,600 535,600
18,000,000 9,100,000 1,800,000 910,000
5,900,000 3,600,000 879,725 679,815
2,400,000 2,000,000 563,597 535,600
6,000,000 3,100,000 915,767 663,706
1,500,000 1,100,000 535,600 535,600
6,000,000 3,300,000 600,000 535,600
8,000,000 4,900,000 800,000 535,600
2,500,000 1,300,000 535,600 535,600
6,100,000 3,100,000 2,083,236 1,822,484
6,900,000 4,500,000 876,841 668,239
50,000,000 25,100,000 5,029,313 2,865,070
4,400,000 2,300,000 665,614 535,600
9,900,000 5,000,000 1,513,098 1,087,203
6,700,000 3,400,000 670,000 535,600
1,800,000 1,700,000 535,600 535,600
7,000,000 4,600,000 944,189 735,587
6,000,000 3,300,000 600,000 535,600
2,400,000 1,300,000 1,721,935 1,626,326
621,800,000 348,200,000 100,292,995 80,371,256
837,336,202 528,864,251
279,112,067 176,288,084
50,000,000 25,100,000
535,600 535,600
 NUMERO
SALARIO
TIPO ID IDENTIFICACI NOMBRE DEL VENDEDOR
BASICO
ON

CE 901507 ADALBERTO CORTES SUAREZ 1,628,616

CC 1697791 ADALBERTO ENRIQUE RICO MARTINEZ 1,628,616
CC 1068687 ALCIDES - RIAQO GAMBOA 1,788,616
CC 1004456 ALEJANDRO GIL ARAQUE 828,616
CC 1256306 ANCIZAR CASTAQEDO ACEVEDO 908,616
CC 1113252 AUGUSTO - MANRIQUE - 1,068,616
CC 1349714 CARLOS ABEL GALLEGO GALLEGO 1,228,616
CC 1370012 FABIO HERRERA HERRERA 1,388,616
CC 1311780 FIDEL ANTONIO RIVERA GRISALES 1,068,616
CC 479094 GABRIEL ALBERTO SERNA RESTREPO 1,148,616
CC 579089 GILDARDO DE JESUS RODRIGUEZ ZAPATA 1,228,616
CC 43677342 GLORIA ELENA DAVID ZAPATA 1,788,616
CC 1099474 GONZALO CASTRO CASTRO 988,616
CC 1073468 GONZALO PANQUEVA MARIN 908,616
CC 1353645 GUILLERMO ALFONSO LAGOS ROA 1,308,616
CC 1037032 HECTOR RODRIGO CUADROS DUARTE 1,388,616
CC 478708 HERMES MARTIN MARTINEZ ROA 1,068,616
CC 70515220 HERNANDO MEJIA DIEZ 828,616
CC 1015290 HILDEBRANDO VALBUENA INFANTE 1,148,616
CC 917231 HUGO CESAR PADILLA POLO 1,708,616
CC 7369367 JADER ANTONIO DIAZ CORDERO 908,616
CC 70559827 JAIME ALBERTO SANCHEZ OROZCO 988,616
CC 1150059 JAIRO AUGUSTO MENDIVELSO TORRES 1,548,616
CC 71698411 JAIRO SANCHEZ JOHN 1,068,616
CC 1476827 JAVIER OMAR PINO MUÑOZ 1,468,616
CC 7510540 JESUS ELIAS ARANGO 1,148,616
CC 3515828 JOAQUIN GUILLERMO MONSALVE MACIAS 1,228,616
CC 3329775 JORGE ANGEL CANO BARRERA 1,308,616
CC 71626559 JORGE ENRIQUE GONZALEZ LARGO 1,388,616
CC 6783145 JORGE IGNACIO ARANGO VARGAS 1,468,616
CC 15919931 JORGE LINO ANDICA BUENO 1,548,616
CC 1124184 JORGE RAMIRO SUAZO AVENDAÑO 1,228,616
CC 1327993 JOSE CONRADO BETANCUR - 1,148,616
CC 1042660 JOSE DOMINGO VARGAS ROJAS 1,468,616
CC 1177606 JOSE EDUARDO RODRIGUEZ 1,628,616
CC 667778 JOSE IVAN ALVAREZ ALVAREZ 1,388,616
CC 593511 JOSE MANUEL GALLEGO GOMEZ 1,308,616
CC 1024839 JOSE MARIA SALAZAR GOMEZ 1,228,616
CC 1124214 JOSE MIGUEL JEREZ GONZALEZ 1,308,616
CC 71265223 JUAN CAMILO BETANCUR LENIS 1,628,616
CC 1068392 JUAN DE DIOS DUARTE SANDOVAL 1,708,616
CC 71792551 JULIAN ALBERTO BEDOYA 1,708,616
CC 71389401 JULIAN VELASQUEZ MUQOZ 1,788,616
CC 1716419 LACIDES CAMARGO ARMENTA 1,708,616
CE 468414 LEOVICELDO ANTONIO GONZALEZ SARMIENTO 908,616
CC 42895889 LILIANA MARIA ALVAREZ AREIZA 828,616
CC 32102821 LILIANA MARIA HENAO CASTAÑEDA 908,616
CC 43253068 LINA MARCELA VALENCIA DURANGO 988,616
CC 43540804 LINA MARIA DE FAT PEÑA CHICA 1,068,616
CC 3606197 LUIS ALFONSO GONZALEZ ZULUAGA 1,148,616
CC 1128863 LUIS ALFREDO CASTIBLANCO SUAREZ 1,388,616
CC 18493836 LUIS ALFREDO PAVA MESA 1,228,616
CC 1211542 LUIS ARTURO TABORDA MARIN 828,616
CC 6706578 LUIS BELTRAN USUGA VELASQUEZ 1,308,616
CC 1592872 LUIS CARLOS BENITEZ VALENCIA 1,548,616
CE 456580 LUIS EMILIO LOPEZ CASTELLANOS 828,616
CC 98549372 LUIS ENRIQUE CASTAÑO 1,388,616
CC 98456394 LUIS EVELIO OSORIO HERRERA 1,468,616
CC 70079213 LUIS FERNANDO ROJAS RUIZ 1,548,616
CC 1210263 LUIS GONZALO CAMPIÑO MARTINEZ 1,788,616
CC 8027917 LUIS MAURICIO TABORDA GONZALEZ 1,628,616
CC 42886844 LUZ ELENA TAMAYO ARANGO 1,708,616
CC 43010607 LUZ ESTER ECHAVARRIA PEREZ 1,788,616
CC 32411235 LUZ HELENA CORREA DELGADO 828,616
CC 42978019 LUZ MARINA MONTES LOPEZ 908,616
CC 1146876 MARCO ANTONIO CHAPARRO ROJAS 1,468,616
CC 474844 MARCO EMILIO PRIETO DIAZ 988,616
CC 1004335 MARCO TULIO ARAQUE - 1,788,616
CC 42966091 MARIA ALBERTINA GALLEGO GALLEGO 988,616
CC 22100801 MARIA ARACELLY MEJIA DE PEREZ 1,068,616
CC 42985503 MARIA CRISTINA CALDERON BETANCUR 1,148,616
CC 43208684 MARIA DEL CARMEN GARCIA MARTINEZ 1,228,616
CC 32489217 MARIA ELENA GUERRA GARCIA 1,308,616
CC 32469220 MARIA GLADYS MESA ALVAREZ 1,388,616
CC 24837406 MARIA LUCIA RODRIGUEZ JIMENEZ 1,468,616
CC 32544837 MARIA LUCRECIA VILLADA VELEZ 1,548,616
CC 32522105 MARIA MAGNELY DE J PANIAGUA GOMEZ 1,628,616
CC 32428108 MARIELA FORONDA DE GIRALDO 1,708,616
CC 70721318 MARIO DE JESUS OSORIO MARULANDA 1,788,616
CC 21565425 MARLENY CORTES VARGAS 828,616
CC 43824978 MARTA IRENE MUÑOZ MUÑOZ 908,616
CC 43055031 MARTHA CECILIA PIMIENTA GONZALEZ 988,616
CC 43021269 MARTHA LUCIA LOPEZ CEBALLOS 1,068,616
CC 1072798 MARTIN PANQUEVA CACERES 828,616
CC 32256158 MILENA PATRICIA OLAYA GALLEGO 1,148,616
CC 1032022 NICOLAS PULIDO 1,308,616
CC 98661304 OSCAR ALBERTO GUERRA 1,228,616
CC 1015186 PABLO JAIRO HUERTAS TORRES 1,068,616
CC 873996 PEDRO ADAN CASTRO BLANCO 1,548,616
CC 1047376 PEDRO IGNACIO CHINOME MALAGON 1,548,616
CC 71605424 REINALDO ALONSO RUA BOHORQUEZ 1,308,616
CC 785490 RICARDO TULIO SALDARRIAGA RESTREPO 1,468,616
CC 1066244 ROBERTO RAMIREZ SANDOVAL 1,628,616
CC 71684784 RODRIGO TABORDA CANO 1,388,616
CC 1310994 RUBEN DE JESUS CARDONA ATEHORTUA 988,616
CC 1009264 TEODORO GONZALEZ 908,616
CC 1113474 TULIO CUEVAS MARCO 1,148,616
CC 1177641 VICTOR JULIO PINTO MONTAÑEZ 1,708,616
CC 1013547 WILLIAM HERNEY PEÑA WILCHES 988,616
 NUMERO
SALARIO
TIPO ID IDENTIFICACI NOMBRE DEL VENDEDOR
BASICO
ON

CC 7369367 JADER ANTONIO DIAZ CORDERO 908,616

CC 70559827 JAIME ALBERTO SANCHEZ OROZCO 988,616
CC 71698411 JAIRO SANCHEZ JOHN 1,068,616
 NUMERO
SALARIO
TIPO ID IDENTIFICACI NOMBRE DEL VENDEDOR
BASICO
ON

CE 901507 ADALBERTO CORTES SUAREZ 1,628,616

CC 1697791 ADALBERTO ENRIQUE RICO MARTINEZ 1,628,616
CC 1068687 ALCIDES - RIAQO GAMBOA 1,788,616
CC 1004456 ALEJANDRO GIL ARAQUE 828,616
CC 1256306 ANCIZAR CASTAQEDO ACEVEDO 908,616
CC 1113252 AUGUSTO - MANRIQUE - 1,068,616
CC 1349714 CARLOS ABEL GALLEGO GALLEGO 1,228,616
CC 1370012 FABIO HERRERA HERRERA 1,388,616
CC 1311780 FIDEL ANTONIO RIVERA GRISALES 1,068,616
CC 479094 GABRIEL ALBERTO SERNA RESTREPO 1,148,616
CC 579089 GILDARDO DE JESUS RODRIGUEZ ZAPATA 1,228,616
CC 43677342 GLORIA ELENA DAVID ZAPATA 1,788,616
CC 1099474 GONZALO CASTRO CASTRO 988,616
CC 1073468 GONZALO PANQUEVA MARIN 908,616
CC 1353645 GUILLERMO ALFONSO LAGOS ROA 1,308,616
CC 1037032 HECTOR RODRIGO CUADROS DUARTE 1,388,616
CC 478708 HERMES MARTIN MARTINEZ ROA 1,068,616
CC 70515220 HERNANDO MEJIA DIEZ 828,616
CC 1015290 HILDEBRANDO VALBUENA INFANTE 1,148,616
CC 917231 HUGO CESAR PADILLA POLO 1,708,616
CC 7369367 JADER ANTONIO DIAZ CORDERO 908,616
CC 70559827 JAIME ALBERTO SANCHEZ OROZCO 988,616
CC 1150059 JAIRO AUGUSTO MENDIVELSO TORRES 1,548,616
CC 71698411 JAIRO SANCHEZ JOHN 1,068,616
CC 1476827 JAVIER OMAR PINO MUÑOZ 1,468,616
CC 7510540 JESUS ELIAS ARANGO 1,148,616
CC 3515828 JOAQUIN GUILLERMO MONSALVE MACIAS 1,228,616
CC 3329775 JORGE ANGEL CANO BARRERA 1,308,616
CC 71626559 JORGE ENRIQUE GONZALEZ LARGO 1,388,616
CC 6783145 JORGE IGNACIO ARANGO VARGAS 1,468,616
CC 15919931 JORGE LINO ANDICA BUENO 1,548,616
CC 1124184 JORGE RAMIRO SUAZO AVENDAÑO 1,228,616
CC 1327993 JOSE CONRADO BETANCUR - 1,148,616
CC 1042660 JOSE DOMINGO VARGAS ROJAS 1,468,616
CC 1177606 JOSE EDUARDO RODRIGUEZ 1,628,616
CC 667778 JOSE IVAN ALVAREZ ALVAREZ 1,388,616
CC 593511 JOSE MANUEL GALLEGO GOMEZ 1,308,616
CC 1024839 JOSE MARIA SALAZAR GOMEZ 1,228,616
CC 1124214 JOSE MIGUEL JEREZ GONZALEZ 1,308,616
CC 71265223 JUAN CAMILO BETANCUR LENIS 1,628,616
CC 1068392 JUAN DE DIOS DUARTE SANDOVAL 1,708,616
CC 71792551 JULIAN ALBERTO BEDOYA 1,708,616
CC 71389401 JULIAN VELASQUEZ MUQOZ 1,788,616
CC 1716419 LACIDES CAMARGO ARMENTA 1,708,616
CE 468414 LEOVICELDO ANTONIO GONZALEZ SARMIENTO 908,616
CC 42895889 LILIANA MARIA ALVAREZ AREIZA 828,616
CC 32102821 LILIANA MARIA HENAO CASTAÑEDA 908,616
CC 43253068 LINA MARCELA VALENCIA DURANGO 988,616
CC 43540804 LINA MARIA DE FAT PEÑA CHICA 1,068,616
CC 3606197 LUIS ALFONSO GONZALEZ ZULUAGA 1,148,616
CC 1128863 LUIS ALFREDO CASTIBLANCO SUAREZ 1,388,616
CC 18493836 LUIS ALFREDO PAVA MESA 1,228,616
CC 1211542 LUIS ARTURO TABORDA MARIN 828,616
CC 6706578 LUIS BELTRAN USUGA VELASQUEZ 1,308,616
CC 1592872 LUIS CARLOS BENITEZ VALENCIA 1,548,616
CE 456580 LUIS EMILIO LOPEZ CASTELLANOS 828,616
CC 98549372 LUIS ENRIQUE CASTAÑO 1,388,616
CC 98456394 LUIS EVELIO OSORIO HERRERA 1,468,616
CC 70079213 LUIS FERNANDO ROJAS RUIZ 1,548,616
CC 1210263 LUIS GONZALO CAMPIÑO MARTINEZ 1,788,616
CC 8027917 LUIS MAURICIO TABORDA GONZALEZ 1,628,616
CC 42886844 LUZ ELENA TAMAYO ARANGO 1,708,616
CC 43010607 LUZ ESTER ECHAVARRIA PEREZ 1,788,616
CC 32411235 LUZ HELENA CORREA DELGADO 828,616
CC 42978019 LUZ MARINA MONTES LOPEZ 908,616
CC 1146876 MARCO ANTONIO CHAPARRO ROJAS 1,468,616
CC 474844 MARCO EMILIO PRIETO DIAZ 988,616
CC 1004335 MARCO TULIO ARAQUE - 1,788,616
CC 42966091 MARIA ALBERTINA GALLEGO GALLEGO 988,616
CC 22100801 MARIA ARACELLY MEJIA DE PEREZ 1,068,616
CC 42985503 MARIA CRISTINA CALDERON BETANCUR 1,148,616
CC 43208684 MARIA DEL CARMEN GARCIA MARTINEZ 1,228,616
CC 32489217 MARIA ELENA GUERRA GARCIA 1,308,616
CC 32469220 MARIA GLADYS MESA ALVAREZ 1,388,616
CC 24837406 MARIA LUCIA RODRIGUEZ JIMENEZ 1,468,616
CC 32544837 MARIA LUCRECIA VILLADA VELEZ 1,548,616
CC 32522105 MARIA MAGNELY DE J PANIAGUA GOMEZ 1,628,616
CC 32428108 MARIELA FORONDA DE GIRALDO 1,708,616
CC 70721318 MARIO DE JESUS OSORIO MARULANDA 1,788,616
CC 21565425 MARLENY CORTES VARGAS 828,616
CC 43824978 MARTA IRENE MUÑOZ MUÑOZ 908,616
CC 43055031 MARTHA CECILIA PIMIENTA GONZALEZ 988,616
CC 43021269 MARTHA LUCIA LOPEZ CEBALLOS 1,068,616
CC 1072798 MARTIN PANQUEVA CACERES 828,616
CC 32256158 MILENA PATRICIA OLAYA GALLEGO 1,148,616
CC 1032022 NICOLAS PULIDO 1,308,616
CC 98661304 OSCAR ALBERTO GUERRA 1,228,616
CC 1015186 PABLO JAIRO HUERTAS TORRES 1,068,616
CC 873996 PEDRO ADAN CASTRO BLANCO 1,548,616
CC 1047376 PEDRO IGNACIO CHINOME MALAGON 1,548,616
CC 71605424 REINALDO ALONSO RUA BOHORQUEZ 1,308,616
CC 785490 RICARDO TULIO SALDARRIAGA RESTREPO 1,468,616
CC 1066244 ROBERTO RAMIREZ SANDOVAL 1,628,616
CC 71684784 RODRIGO TABORDA CANO 1,388,616
CC 1310994 RUBEN DE JESUS CARDONA ATEHORTUA 988,616
CC 1009264 TEODORO GONZALEZ 908,616
CC 1113474 TULIO CUEVAS MARCO 1,148,616
CC 1177641 VICTOR JULIO PINTO MONTAÑEZ 1,708,616
CC 1013547 WILLIAM HERNEY PEÑA WILCHES 988,616
 NUMERO
SALARIO
TIPO ID IDENTIFICACI NOMBRE DEL VENDEDOR
BASICO
ON

CE 901507 ADALBERTO CORTES SUAREZ 1,628,616

CC 1697791 ADALBERTO ENRIQUE RICO MARTINEZ 1,628,616
CC 1068687 ALCIDES - RIAQO GAMBOA 1,788,616
CC 1113252 AUGUSTO - MANRIQUE - 1,068,616
CC 1349714 CARLOS ABEL GALLEGO GALLEGO 1,228,616
CC 1370012 FABIO HERRERA HERRERA 1,388,616
CC 1311780 FIDEL ANTONIO RIVERA GRISALES 1,068,616
CC 479094 GABRIEL ALBERTO SERNA RESTREPO 1,148,616
CC 579089 GILDARDO DE JESUS RODRIGUEZ ZAPATA 1,228,616
CC 43677342 GLORIA ELENA DAVID ZAPATA 1,788,616
CC 1353645 GUILLERMO ALFONSO LAGOS ROA 1,308,616
CC 1037032 HECTOR RODRIGO CUADROS DUARTE 1,388,616
CC 478708 HERMES MARTIN MARTINEZ ROA 1,068,616
CC 1015290 HILDEBRANDO VALBUENA INFANTE 1,148,616
CC 917231 HUGO CESAR PADILLA POLO 1,708,616
CC 1150059 JAIRO AUGUSTO MENDIVELSO TORRES 1,548,616
CC 71698411 JAIRO SANCHEZ JOHN 1,068,616
CC 1476827 JAVIER OMAR PINO MUÑOZ 1,468,616
CC 7510540 JESUS ELIAS ARANGO 1,148,616
CC 3515828 JOAQUIN GUILLERMO MONSALVE MACIAS 1,228,616
CC 3329775 JORGE ANGEL CANO BARRERA 1,308,616
CC 71626559 JORGE ENRIQUE GONZALEZ LARGO 1,388,616
CC 6783145 JORGE IGNACIO ARANGO VARGAS 1,468,616
CC 15919931 JORGE LINO ANDICA BUENO 1,548,616
CC 1124184 JORGE RAMIRO SUAZO AVENDAÑO 1,228,616
CC 1327993 JOSE CONRADO BETANCUR - 1,148,616
CC 1042660 JOSE DOMINGO VARGAS ROJAS 1,468,616
CC 1177606 JOSE EDUARDO RODRIGUEZ 1,628,616
CC 667778 JOSE IVAN ALVAREZ ALVAREZ 1,388,616
CC 593511 JOSE MANUEL GALLEGO GOMEZ 1,308,616
CC 1024839 JOSE MARIA SALAZAR GOMEZ 1,228,616
CC 1124214 JOSE MIGUEL JEREZ GONZALEZ 1,308,616
CC 71265223 JUAN CAMILO BETANCUR LENIS 1,628,616
CC 1068392 JUAN DE DIOS DUARTE SANDOVAL 1,708,616
CC 71792551 JULIAN ALBERTO BEDOYA 1,708,616
CC 71389401 JULIAN VELASQUEZ MUQOZ 1,788,616
CC 1716419 LACIDES CAMARGO ARMENTA 1,708,616
CC 43540804 LINA MARIA DE FAT PEÑA CHICA 1,068,616
CC 3606197 LUIS ALFONSO GONZALEZ ZULUAGA 1,148,616
CC 1128863 LUIS ALFREDO CASTIBLANCO SUAREZ 1,388,616
CC 18493836 LUIS ALFREDO PAVA MESA 1,228,616
CC 6706578 LUIS BELTRAN USUGA VELASQUEZ 1,308,616
CC 1592872 LUIS CARLOS BENITEZ VALENCIA 1,548,616
CC 98549372 LUIS ENRIQUE CASTAÑO 1,388,616
CC 98456394 LUIS EVELIO OSORIO HERRERA 1,468,616
CC 70079213 LUIS FERNANDO ROJAS RUIZ 1,548,616
CC 1210263 LUIS GONZALO CAMPIÑO MARTINEZ 1,788,616
CC 8027917 LUIS MAURICIO TABORDA GONZALEZ 1,628,616
CC 42886844 LUZ ELENA TAMAYO ARANGO 1,708,616
CC 43010607 LUZ ESTER ECHAVARRIA PEREZ 1,788,616
CC 1146876 MARCO ANTONIO CHAPARRO ROJAS 1,468,616
CC 1004335 MARCO TULIO ARAQUE - 1,788,616
CC 22100801 MARIA ARACELLY MEJIA DE PEREZ 1,068,616
CC 42985503 MARIA CRISTINA CALDERON BETANCUR 1,148,616
CC 43208684 MARIA DEL CARMEN GARCIA MARTINEZ 1,228,616
CC 32489217 MARIA ELENA GUERRA GARCIA 1,308,616
CC 32469220 MARIA GLADYS MESA ALVAREZ 1,388,616
CC 24837406 MARIA LUCIA RODRIGUEZ JIMENEZ 1,468,616
CC 32544837 MARIA LUCRECIA VILLADA VELEZ 1,548,616
CC 32522105 MARIA MAGNELY DE J PANIAGUA GOMEZ 1,628,616
CC 32428108 MARIELA FORONDA DE GIRALDO 1,708,616
CC 70721318 MARIO DE JESUS OSORIO MARULANDA 1,788,616
CC 43021269 MARTHA LUCIA LOPEZ CEBALLOS 1,068,616
CC 32256158 MILENA PATRICIA OLAYA GALLEGO 1,148,616
CC 1032022 NICOLAS PULIDO 1,308,616
CC 98661304 OSCAR ALBERTO GUERRA 1,228,616
CC 1015186 PABLO JAIRO HUERTAS TORRES 1,068,616
CC 873996 PEDRO ADAN CASTRO BLANCO 1,548,616
CC 1047376 PEDRO IGNACIO CHINOME MALAGON 1,548,616
CC 71605424 REINALDO ALONSO RUA BOHORQUEZ 1,308,616
CC 785490 RICARDO TULIO SALDARRIAGA RESTREPO 1,468,616
CC 1066244 ROBERTO RAMIREZ SANDOVAL 1,628,616
CC 71684784 RODRIGO TABORDA CANO 1,388,616
CC 1113474 TULIO CUEVAS MARCO 1,148,616
CC 1177641 VICTOR JULIO PINTO MONTAÑEZ 1,708,616
 NUMERO
SALARIO
TIPO ID IDENTIFICACI NOMBRE DEL VENDEDOR
BASICO
ON

CE 901507 ADALBERTO CORTES SUAREZ 1,628,616

CE 468414 LEOVICELDO ANTONIO GONZALEZ SARMIENTO 908,616
CE 456580 LUIS EMILIO LOPEZ CASTELLANOS 828,616