Prueba de conocimientos Excel ingeniería

Bienvenido a su prueba de conocimientos en Excel (Intermedio-Avanzado) a continuación diligencie los siguientes

Nombre completo:
C.C:
Edad:
Nivel de estudio: Tecnologo en Gestión Industrial . Pregrado Ingenieria Industrial
Cargo al que aplica: Analista de producto

1. Formulación 2. Tablas 3. Grabadora de

3. Grabadora de
Macros
 HDR Codigo Maquina Pedido Articulo Descripcion
50146519 TIBE93 BEAM # 93 410146006 T1512 DESTELLANTE
50146535 TIBE93 BEAM # 93 410145556 T1389 PACIFICPLUSSEC/
50146722 TIBE93 BEAM # 93 410146080 T258 POWER
 TipoArticulo Color Numero Cliente
N/R BTE 40/12-LYC 40 BLANCO 61149 STOCK DEUDA
P/R SM 50/24-LYC 40 ROSA 50611 STOCK
N/R OPACO 50/10-LYC 40 AZUL 6045 STOCK DEUDA
 Operario/Paro Fase Inicio Fin Kilos T
HECTOR DAVID SOTO ARIAS TEÑIRENBEAM 9/22/2020 9/30/2020 361.5 2
TARCISIO ALEXANDER TOQUICA NEG TEÑIRENBEAM 9/22/2020 9/29/2020 359 1
JOSE ELBER ROJAS TORRES TEÑIRENBEAM 9/22/2020 9/27/2020 363.5 3
 Hi HF HhMm Tecnologia Reprocesos ARYA
12:06 12: 6 0: 0 TRICOT 0 BEAM
0:56 0:57 0: 0 TRICOT 0 BEAM
18:29 18:29 0: 0 TRICOT 0 BEAM
 Diferencia
7.49563657407271 STOCK DEUDA
6.96063657407649 STOCK
4.22983796296467 STOCK DEUDA
60124471 0
30731470 0
60124452 0
60124627 0
60124630 0
60124629 0
60124633 0
60124632 0
60124556 0
60124689 0
60124555 0
60124558 0
60124631 0
60124687 0
60124554 0
60124557 0
60124685 0
60124541 0
60124639 0
60124640 0
60124641 0
60124688 0
60124692 0
60124041 0
60124460 0
60124241 -1
30731581 0
30731789 0
30731607 0
30731886 0
30731831 0
30731608 0
30731770 0
30731919 0
60124279 0
60124280 0
60124034 0
60124272 0
60124252 0
60124141 0
60124190 0
60124027 0
60124376 0
60124413 0
60123992 -1
60124490 0
60124508 0
60123860 -1
60124287 0
60124288 0
60124590 0
60124591 0
60124592 0
60124511 0
60124625 0
60124626 0
60124513 0
60124643 0
60124627 0
50146657 0
50146744 0
50146726 0
50146738 0
50146743 0
50146725 0
50146759 0
50146766 0
50146754 0
50146751 0
50146755 0
50146762 0
50146767 0
50146782 0
50146779 0
50146724 0
50146745 0
50146748 0
50146649 0
50146654 0
50146729 0
50146749 0
50146769 0
50146746 0
50146763 0
50146760 0
50146765 0
50146739 0
50146742 0
50146770 0
50146787 0
50146785 0
50146783 0
50146780 0
30731165 0
30730699 0
30730438 0
30731389 0
30731419 0
30731368 0
30731270 0
30731314 0
30731366 0
90432116 0
90432331 0
90432121 0
90432120 0
30731269 0
30731358 0
50146643 0
30730663 0
30730147 0
30730887 0
30730537 0
30731469 0
30729653 0
30731263 0
30731112 0
80249553 0
80249527 0
80249678 0
60124214 0
60124509 0
80249681 0
80249682 0
80249586 0
80249166 -1
30731048 0
30730546 0
30731049 0
30730547 0
30731050 0
30730548 0
30730598 0
30731129 0
30731130 0
30731131 0
30731132 0
30731133 0
30730757 0
30730767 0
30730871 0
30731056 0
30730878 0
30730879 0
30730880 0
30730881 0
30730882 0
30730883 0
30730884 0
30730885 0
30730962 0
30730875 0
30730927 0
30731067 0
30731087 0
30731088 0
30731089 0
30731145 0
30731146 0
80249661 0
30731345 0
30731336 0
30731712 0
30730423 0
30731017 0
30730682 0
80249542 0
50146547 0
60124466 0
30730733 0
30731191 0
30731198 0
80249497 0
30731764 0
30731547 0
30731767 0
30731817 0
50146545 0
50146612 0
50146641 0
30731252 0
30731178 0
30730751 0
30731078 0
30730891 0
30730987 0
30731511 0
30731706 0
30731334 0
30730799 0
30731496 0
30731651 0
30731688 0
60124313 0
30731694 0
30731294 0
30731730 0
30731700 0
50146526 0
50146546 0
50146548 0
50146549 0
50146585 0
30731861 0
30731918 0
30731443 0
30730808 0
30730863 0
30730915 0
30731027 0
30731224 0
30731216 0
30731262 0
30730867 0
30730934 0
30731187 0
30731228 0
30731267 0
30731209 0
30731209 0
30731267 0
30730938 0
30731229 0
30731227 0
30731251 0
30731215 0
30731171 0
30730967 0
30730839 0
30730094 0
30729965 0
30730164 0
30731020 0
30730777 0
30730170 0
30730384 0
30730303 0
30731234 0
30731235 0
30731246 0
30731247 0
30731248 0
30731264 0
30731210 0
30731331 0
30731219 0
30731431 0
30731317 0
30731425 0
30731858 0
30731947 0
60124458 0
60124459 0
60124491 0
30730886 0
30731462 0
30731467 0
30730701 0
30731211 0
30730016 0
30730072 0
30729758 0
30729947 0
30730226 0
30730280 0
 Actividad
1. Utilizando la base de datos de la hoja "Base", traiga los valores para cada columna de la (Tabla 1).
Encuentre una fórmula donde se evidencie la diferencia entre "F. Inicio" (Columna F) y "F. Fin"(Columna G). Si la fó
2. cuenta fines de semana obtendrá puntos adicionales en la calificación.
Mediante el uso de fórmulas, con base en la columna "Kilos"(Columna H), genere las siguientes categorías:
"Pequeña" ---> de 0 a 150 Kilogramos
3. "Media" ---> de 150 a 300 Kilogramos
"Grande" ---> 300 o más

Aplique una función que traiga de la hoja "Base", la suma de los kilos por máquina y color específicados en la (Tabl
4.

Tabla 1.
HDR Código Máquina ArtÍculo Color Inicio Fin
30727237 AEP801 PERCHA 01 SF10207 MORADO 9/22/2020 9/25/2020
30728053 AECO06 COMPACTADORA 06 SL4906 NARANJA 9/22/2020 9/23/2020
30728102 AECO06 COMPACTADORA 06 D89551 NARANJA 9/22/2020 9/27/2020
30728199 AEP803 PERCHA 03 SF10207 ROSA 9/22/2020 9/30/2020
30728658 TIAB01 ABRIDORA 1 CC08-0130APJQ MORADO 9/22/2020 9/29/2020
30728862 AECO06 COMPACTADORA 06 FL5735 AZUL 9/22/2020 9/24/2020
30728879 TIFG78 FONGS # 78 DQ8353 NARANJA 9/22/2020 9/23/2020
30729132 TIAB06 ABRIDORA 6 OQ5588 BLANCO 9/21/2020 9/24/2020
30729210 TIAB03 ABRIDORA 3 SF10178 AZUL 9/22/2020 9/28/2020
30729216 TIAB06 ABRIDORA 6 OM2094-C1 NARANJA 9/22/2020 9/25/2020
30729383 TIAB03 ABRIDORA 3 OQ5588 BLANCO 9/22/2020 9/25/2020
30729514 TIFG81 FONG # 81 SF6832-K ROSA 9/22/2020 9/23/2020
30729635 TIAB06 ABRIDORA 6 OM2094-C1 MORADO 9/22/2020 9/30/2020
30729653 TIAB03 ABRIDORA 3 OM2094-C1 ROSA 9/22/2020 9/23/2020
30729715 TIAB06 ABRIDORA 6 SF1333 AZUL 9/22/2020 9/29/2020
30729758 TIAB03 ABRIDORA 3 SF6832-K BLANCO 9/22/2020 9/23/2020
30729857 AEPE01 PERCHA 01 SF10207 NARANJA 9/22/2020 9/28/2020
30729868 TIAB06 ABRIDORA 6 OM2094-C1 AZUL 9/21/2020 9/27/2020
30729910 TIAB03 ABRIDORA 3 OM4299 BLANCO 9/22/2020 9/30/2020
30729925 TIAB03 ABRIDORA 3 OM2094-C1 MORADO 9/22/2020 9/25/2020
30729947 TIAB03 ABRIDORA 3 SF6832-K NARANJA 9/22/2020 9/25/2020
30729965 TIAB06 ABRIDORA 6 SF6832-K BLANCO 9/22/2020 9/27/2020
30730009 TIAB06 ABRIDORA 6 DF9994 ROSA 9/22/2020 9/30/2020
30730016 TIAB06 ABRIDORA 6 SF6832 BLANCO 9/22/2020 9/29/2020
30730043 AESC01 SECADOR CUELLO01 CC01-30PA MORADO 9/22/2020 9/26/2020
30730052 TIAB03 ABRIDORA 3 D83674-38 ROSA 9/21/2020 9/22/2020
30730053 TIAB03 ABRIDORA 3 OM2094-C1 ROSA 9/22/2020 9/30/2020
30730063 TIAB11 ABRIDORA 11 DEL9670-36 ROSA 9/22/2020 9/27/2020
30730067 TIFG83 FONG # 83 SF10049 AZUL 9/22/2020 9/27/2020
30730072 TIAB03 ABRIDORA 3 SF6832 ROSA 9/22/2020 9/25/2020
30730094 TIAB03 ABRIDORA 3 SF6832 AZUL 9/22/2020 9/29/2020
30730115 AECO06 COMPACTADORA 06 SL4302 MORADO 9/22/2020 9/25/2020
30730116 TIAB12 ABRIDORA 12 OM2094-C1 MORADO 9/22/2020 9/25/2020
30730147 TIAB06 ABRIDORA 6 SF4030 AZUL 9/22/2020 9/26/2020
30730164 TITH62 THEN # 62 SF6832 ROSA 9/22/2020 9/23/2020
30730170 TIAB04 ABRIDORA 4 SF6832 MORADO 9/22/2020 9/27/2020
30730179 AEP801 PERCHA 01 SF10207 NARANJA 9/22/2020 9/24/2020
30730226 TITI25 THIES 25 SF6832 AZUL 9/22/2020 9/29/2020
30730229 AESC01 SECADOR CUELLO01 CC01-30PA ROSA 9/22/2020 9/28/2020
30730232 AESC01 SECADOR CUELLO01 CC01-30PA BLANCO 9/22/2020 9/30/2020
30730252 AESC01 SECADOR CUELLO01 CC01-30PA AZUL 9/22/2020 9/24/2020
30730261 TIAB07 ABRIDORA 7 SF2442-C1 NARANJA 9/22/2020 9/24/2020
30730270 TIAB03 ABRIDORA 3 DF9994 NARANJA 9/22/2020 9/26/2020
30730280 TITI25 THIES 25 SF6832 NARANJA 9/22/2020 9/30/2020
30730303 TIAB03 ABRIDORA 3 SK5725-26 NARANJA 9/22/2020 9/25/2020
30730311 AEFC01 FUSIONADORA 01 CC01-30PA BLANCO 9/22/2020 9/25/2020
30730314 TIAB07 ABRIDORA 7 OF2442-C1 ROSA 9/22/2020 9/23/2020
30730326 TIAB06 ABRIDORA 6 SF3605-C1 NARANJA 9/22/2020 9/27/2020
30730384 TIAB03 ABRIDORA 3 SF10178 AZUL 9/22/2020 9/28/2020
30730388 TIAB06 ABRIDORA 6 SF6832-K NARANJA 9/22/2020 9/23/2020
30730408 TIAB06 ABRIDORA 6 SF6832-K MORADO 9/22/2020 9/26/2020
30730411 TIAB11 ABRIDORA 11 DEL9670-36 MORADO 9/22/2020 9/23/2020
30730421 AEP810 PERCHA 10 TE2188 MORADO 9/22/2020 9/23/2020
30730423 TIAB11 ABRIDORA 11 D85080-38 ROSA 9/22/2020 9/23/2020
30730432 TIAB06 ABRIDORA 6 OM2094-C1 ROSA 9/22/2020 9/23/2020
30730438 TIAB04 ABRIDORA 4 DJ3028-C4 ROSA 9/22/2020 9/24/2020
30730456 TIFG57 FONGS # 57 SL5052 MORADO 9/22/2020 9/23/2020
30730465 TIAB03 ABRIDORA 3 SF6832-K AZUL 9/22/2020 9/26/2020
30730472 TIAB03 ABRIDORA 3 SF6832-K ROSA 9/22/2020 9/23/2020
30730501 AEP806 PERCHA 06 D85080-38 NARANJA 9/22/2020 9/26/2020
30730528 TIAB03 ABRIDORA 3 OM2094-C1 BLANCO 9/21/2020 9/25/2020
30730537 TIAB11 ABRIDORA 11 DF5344 NARANJA 9/22/2020 9/25/2020
30730545 TIAB07 ABRIDORA 7 D81538 BLANCO 9/22/2020 9/24/2020
30730546 TIAB04 ABRIDORA 4 D81538 NARANJA 9/22/2020 9/27/2020
30730547 TIAB11 ABRIDORA 11 D81538 ROSA 9/22/2020 9/25/2020
30730548 TISC03 SCHOLL # 03 D81538 ROSA 9/22/2020 9/24/2020
30730550 AEP806 PERCHA 06 DJ5080 AZUL 9/22/2020 9/23/2020
30730590 TIAI23 AIRTINT # 23 SF6832-K BLANCO 9/22/2020 9/25/2020
30730598 TISC03 SCHOLL # 03 D81538 BLANCO 9/22/2020 9/26/2020
30730614 TIAB07 ABRIDORA 7 D85080-38 MORADO 9/22/2020 9/23/2020
30730627 TIAB07 ABRIDORA 7 SF2442-C1 AZUL 9/22/2020 9/27/2020
30730631 TIAI23 AIRTINT # 23 SF6832-K AZUL 9/22/2020 9/25/2020
30730636 AEP810 PERCHA 10 TJE3606 ROSA 9/22/2020 9/23/2020
30730651 TIAB06 ABRIDORA 6 SF6832-K NARANJA 9/21/2020 9/30/2020
30730657 TIAB07 ABRIDORA 7 SF2442-C1 NARANJA 9/22/2020 9/24/2020
30730658 AEES02 ESMERILADORA 02 SF8098-C3 MORADO 9/21/2020 9/29/2020
30730663 TIAB09 ABRIDORA 9 DF8410 BLANCO 9/22/2020 9/23/2020
30730682 TITC36 THECNO DYE # 36 SJ4552 MORADO 9/22/2020 9/25/2020
30730699 TIAB13 ABRIDORA 13 DF5344 NARANJA 9/22/2020 9/29/2020
30730701 TITI16 THIES # 16 SF4303 BLANCO 9/22/2020 9/28/2020
30730716 TIAB04 ABRIDORA 4 OM10204 MORADO 9/22/2020 9/27/2020
30730733 TIAB11 ABRIDORA 11 SF2442-C1 BLANCO 9/22/2020 9/28/2020
30730746 AECO06 COMPACTADORA 06 SL5052 AZUL 9/22/2020 9/23/2020
30730750 TIFG89 FONGS # 89 SF5430 AZUL 9/22/2020 9/27/2020
30730751 TITH33 THEN # 33 SF4303 BLANCO 9/22/2020 9/27/2020
30730752 TIAB03 ABRIDORA 3 SF6832-K AZUL 9/21/2020 9/27/2020
30730757 TIAB13 ABRIDORA 13 D81538 AZUL 9/22/2020 9/30/2020
30730767 TIAB13 ABRIDORA 13 D81538 NARANJA 9/22/2020 9/28/2020
30730777 TIAB06 ABRIDORA 6 SF2842 AZUL 9/22/2020 9/26/2020
30730799 TITH38 THEN # 38 SK8632 NARANJA 9/22/2020 9/25/2020
30730808 TIAB07 ABRIDORA 7 SF2442-C1 BLANCO 9/22/2020 9/30/2020
30730823 TIAB06 ABRIDORA 6 SF6832-K MORADO 9/21/2020 9/23/2020
30730839 TITH49 THEN # 49 SF2442-C1 AZUL 9/22/2020 9/23/2020
30730863 TIAB11 ABRIDORA 11 SF2442-C1 MORADO 9/22/2020 9/23/2020
30730867 TIAB06 ABRIDORA 6 SF6832 BLANCO 9/22/2020 9/27/2020
30730871 TIAB13 ABRIDORA 13 D81538 MORADO 9/22/2020 9/27/2020
30730874 TIAB04 ABRIDORA 4 D81538 ROSA 9/22/2020 9/23/2020
30730875 TIAB04 ABRIDORA 4 D81538 BLANCO 9/22/2020 9/27/2020
30730877 TIAB04 ABRIDORA 4 D81538 AZUL 9/22/2020 9/25/2020
30730878 TIAB04 ABRIDORA 4 D81538 NARANJA 9/22/2020 9/25/2020
30730879 TIAB07 ABRIDORA 7 D81538 NARANJA 9/22/2020 9/23/2020
30730880 TIAB04 ABRIDORA 4 D81538 BLANCO 9/22/2020 9/23/2020
30730881 TIAB13 ABRIDORA 13 D81538 BLANCO 9/22/2020 9/26/2020
30730882 TIAB04 ABRIDORA 4 D81538 BLANCO 9/22/2020 9/27/2020
30730883 TISC09 SCHOLL # 09 D81538 BLANCO 9/22/2020 9/27/2020
30730884 TIAB13 ABRIDORA 13 D81538 ROSA 9/22/2020 9/24/2020
30730885 TISC09 SCHOLL # 09 D81538 NARANJA 9/22/2020 9/24/2020
30730886 TITI16 THIES # 16 DK9740 NARANJA 9/22/2020 9/30/2020
30730887 TIAB04 ABRIDORA 4 DJ3028-C4 MORADO 9/22/2020 9/23/2020
30730888 TIAB03 ABRIDORA 3 SF6832-K AZUL 9/21/2020 9/30/2020
30730889 AECO06 COMPACTADORA 06 SL5052 ROSA 9/22/2020 9/24/2020
30730891 TIAB07 ABRIDORA 7 DK9740 AZUL 9/22/2020 9/28/2020
30730892 TIAB07 ABRIDORA 7 SF3733 ROSA 9/21/2020 9/25/2020
30730898 TIAB12 ABRIDORA 12 SF6832 ROSA 9/22/2020 9/30/2020
30730899 AECO06 COMPACTADORA 06 SF5655 BLANCO 9/22/2020 9/27/2020
30730902 TIAB03 ABRIDORA 3 OM2094-C1 BLANCO 9/22/2020 9/26/2020
30730915 TIAB11 ABRIDORA 11 SF2442-C1 ROSA 9/22/2020 9/25/2020
30730922 TIFG56 FONGS # 56 SK9084 BLANCO 9/22/2020 9/25/2020
30730927 TIAB04 ABRIDORA 4 D81538 BLANCO 9/22/2020 9/26/2020
30730933 TIAB11 ABRIDORA 11 SK10267 BLANCO 9/22/2020 9/26/2020
30730934 TIAB06 ABRIDORA 6 SF6832 AZUL 9/22/2020 9/23/2020
30730938 TIAB03 ABRIDORA 3 SK9084 NARANJA 9/22/2020 9/24/2020
30730947 TIAB03 ABRIDORA 3 SF6832-K NARANJA 9/21/2020 9/28/2020
30730948 TIAB06 ABRIDORA 6 SF6832-K NARANJA 9/21/2020 9/25/2020
30730958 TIFG89 FONGS # 89 SF5430 NARANJA 9/22/2020 9/26/2020
30730962 TISC09 SCHOLL # 09 D81538 MORADO 9/22/2020 9/26/2020
30730965 AEP810 PERCHA 10 TJE3606 BLANCO 9/22/2020 9/24/2020
30730966 TIFG88 FONGS # 88 DJ3182 ROSA 9/22/2020 9/27/2020
30730967 TIAB06 ABRIDORA 6 SF6832 ROSA 9/22/2020 9/25/2020
30730971 TIAB03 ABRIDORA 3 SK9084 BLANCO 9/22/2020 9/28/2020
30730978 TIAB03 ABRIDORA 3 SK9084 MORADO 9/22/2020 9/28/2020
30730984 TIAB07 ABRIDORA 7 DK9740 AZUL 9/22/2020 9/23/2020
30730986 AEFC01 FUSIONADORA 01 CC01-30PA ROSA 9/22/2020 9/30/2020
30730987 TIAB04 ABRIDORA 4 DK9740 ROSA 9/22/2020 9/27/2020
30730997 TIAB04 ABRIDORA 4 SK10240-26 MORADO 9/22/2020 9/23/2020
30731000 TIAB13 ABRIDORA 13 DK9740 AZUL 9/22/2020 9/30/2020
30731010 TIAB11 ABRIDORA 11 SK10262 AZUL 9/22/2020 9/25/2020
30731017 TIAB06 ABRIDORA 6 SJ4552 ROSA 9/22/2020 9/23/2020
30731020 TIAB06 ABRIDORA 6 SF6832-K MORADO 9/22/2020 9/23/2020
30731027 TIAB11 ABRIDORA 11 DJ7431 AZUL 9/22/2020 9/23/2020
30731028 TIAB03 ABRIDORA 3 DF9994 ROSA 9/22/2020 9/25/2020
30731048 TIAB13 ABRIDORA 13 D81538 AZUL 9/22/2020 9/25/2020
30731049 TISC03 SCHOLL # 03 D81538 AZUL 9/22/2020 9/27/2020
30731050 TISC03 SCHOLL # 03 D81538 MORADO 9/22/2020 9/24/2020
30731056 TISC08 SCHOLL # 08 D81538 ROSA 9/22/2020 9/23/2020
30731067 TIAB04 ABRIDORA 4 D81538 AZUL 9/22/2020 9/28/2020
30731074 TIAB11 ABRIDORA 11 DJ5080 BLANCO 9/22/2020 9/27/2020
30731075 TIFG88 FONGS # 88 DJ3182 BLANCO 9/22/2020 9/27/2020
30731078 TIAB04 ABRIDORA 4 SK8632 MORADO 9/22/2020 9/26/2020
30731087 TIAB13 ABRIDORA 13 D81538 BLANCO 9/22/2020 9/27/2020
30731088 TIAB03 ABRIDORA 3 D81538 MORADO 9/22/2020 9/23/2020
30731089 TIAB03 ABRIDORA 3 D81538 NARANJA 9/22/2020 9/25/2020
30731104 TIAB04 ABRIDORA 4 SF1702 ROSA 9/22/2020 9/28/2020
30731112 TIAB03 ABRIDORA 3 SF6832-K NARANJA 9/22/2020 9/25/2020
30731123 TIAB12 ABRIDORA 12 SF6832 ROSA 9/22/2020 9/24/2020
30731125 TIAB13 ABRIDORA 13 D81538 NARANJA 9/22/2020 9/30/2020
30731129 TIAB13 ABRIDORA 13 D81538 BLANCO 9/22/2020 9/23/2020
30731130 TIAB07 ABRIDORA 7 D81538 ROSA 9/22/2020 9/27/2020
30731131 TIAB04 ABRIDORA 4 D81538 NARANJA 9/22/2020 9/26/2020
30731132 TIAB13 ABRIDORA 13 D81538 NARANJA 9/22/2020 9/25/2020
30731133 TIAB11 ABRIDORA 11 D81538 MORADO 9/22/2020 9/25/2020
30731145 TIAB13 ABRIDORA 13 D81538 BLANCO 9/22/2020 9/23/2020
30731146 TIAB11 ABRIDORA 11 D81538 AZUL 9/22/2020 9/25/2020
30731163 TIFG88 FONGS # 88 D86186 BLANCO 9/22/2020 9/29/2020
30731165 TIAB11 ABRIDORA 11 DF5344 NARANJA 9/22/2020 9/27/2020
30731171 TIAB03 ABRIDORA 3 SF6832 BLANCO 9/22/2020 9/29/2020
30731177 TIAB01 ABRIDORA 1 DK9740 NARANJA 9/22/2020 9/29/2020
30731178 TIAB03 ABRIDORA 3 SF6832 BLANCO 9/22/2020 9/30/2020
30731187 TIAB03 ABRIDORA 3 SF6832-K AZUL 9/22/2020 9/27/2020
30731191 TIAB03 ABRIDORA 3 SF6832 AZUL 9/22/2020 9/28/2020
30731198 TITH27 THEN # 27 SF2442-C1 ROSA 9/22/2020 9/29/2020
30731204 TIAB11 ABRIDORA 11 D84557-38 NARANJA 9/22/2020 9/23/2020
30731209 TITH47 THEN # 47 SF6832-K AZUL 9/22/2020 9/27/2020
30731210 TIAB13 ABRIDORA 13 SK8632 ROSA 9/22/2020 9/23/2020
30731211 TITI16 THIES # 16 SF4303 AZUL 9/22/2020 9/25/2020
30731213 TIAB07 ABRIDORA 7 SL5351 ROSA 9/22/2020 9/28/2020
30731214 TIFG88 FONGS # 88 SF5859 AZUL 9/22/2020 9/24/2020
30731215 TIAB03 ABRIDORA 3 SF6832 AZUL 9/22/2020 9/27/2020
30731216 TIAB03 ABRIDORA 3 DJ5447 MORADO 9/22/2020 9/28/2020
30731217 TIAB06 ABRIDORA 6 DQ9850 BLANCO 9/22/2020 9/30/2020
30731219 TIAB13 ABRIDORA 13 DJ3182 MORADO 9/22/2020 9/24/2020
30731224 TIAB03 ABRIDORA 3 SJ4552 AZUL 9/22/2020 9/23/2020
30731227 TIAB03 ABRIDORA 3 SK9084 ROSA 9/22/2020 9/30/2020
30731228 TIAB03 ABRIDORA 3 SF6832-K NARANJA 9/22/2020 9/28/2020
30731229 TIAB03 ABRIDORA 3 SK9084 MORADO 9/22/2020 9/26/2020
30731234 TIAB13 ABRIDORA 13 DK9740 MORADO 9/22/2020 9/23/2020
30731235 TIAB13 ABRIDORA 13 DK9740 ROSA 9/22/2020 9/23/2020
30731238 TIAB11 ABRIDORA 11 FLL10254 BLANCO 9/22/2020 9/28/2020
30731246 TIAB07 ABRIDORA 7 DK9740 BLANCO 9/22/2020 9/23/2020
30731247 TIAB01 ABRIDORA 1 DK9740 ROSA 9/22/2020 9/23/2020
30731248 TIAB01 ABRIDORA 1 DK9740 BLANCO 9/22/2020 9/29/2020
30731249 TIAB06 ABRIDORA 6 DJ5447 BLANCO 9/22/2020 9/29/2020
30731251 TIAB03 ABRIDORA 3 SK9084 BLANCO 9/22/2020 9/27/2020
30731252 TIAB03 ABRIDORA 3 SF6135 AZUL 9/22/2020 9/28/2020
30731262 TITH41 THEN # 41 SF4384 BLANCO 9/22/2020 9/26/2020
30731263 TIAB11 ABRIDORA 11 SF5331 AZUL 9/22/2020 9/29/2020
30731264 TIAB07 ABRIDORA 7 DK9740 AZUL 9/22/2020 9/23/2020
30731267 TITH47 THEN # 47 SF6832-K BLANCO 9/22/2020 9/26/2020
30731269 TIAB11 ABRIDORA 11 DJ5700 AZUL 9/22/2020 9/23/2020
30731270 TIMC12 MCS # 12 DF5344 NARANJA 9/22/2020 9/27/2020
30731271 AEFC01 FUSIONADORA 01 CP01-0030PA NARANJA 9/22/2020 9/24/2020
30731272 AEFC01 FUSIONADORA 01 CP01-0030PA MORADO 9/22/2020 9/23/2020
30731275 TIAB11 ABRIDORA 11 SF10242 NARANJA 9/22/2020 9/28/2020
30731281 TIAI04 AIRTINT # 4 SK9084 BLANCO 9/22/2020 9/28/2020
30731283 TIAB07 ABRIDORA 7 DK9740 NARANJA 9/22/2020 9/23/2020
30731294 TIAB04 ABRIDORA 4 SK10251 ROSA 9/22/2020 9/28/2020
30731304 TIAB03 ABRIDORA 3 SF2842 ROSA 9/22/2020 9/29/2020
30731314 TIAB04 ABRIDORA 4 DF5344 AZUL 9/22/2020 9/29/2020
30731317 TIAB13 ABRIDORA 13 DJ7431 NARANJA 9/22/2020 9/24/2020
30731331 TIAB13 ABRIDORA 13 SK8632 MORADO 9/22/2020 9/30/2020
30731334 TIAB03 ABRIDORA 3 SK5725-26 NARANJA 9/22/2020 9/24/2020
30731335 TIAB12 ABRIDORA 12 OM2094-C1 BLANCO 9/22/2020 9/29/2020
30731336 TIAB06 ABRIDORA 6 OM2094-C1 AZUL 9/22/2020 9/26/2020
30731341 TIAB07 ABRIDORA 7 DJ5080 BLANCO 9/21/2020 9/24/2020
30731345 TIAB11 ABRIDORA 11 SF8098-C3 ROSA 9/22/2020 9/29/2020
30731353 AEP806 PERCHA 06 D85080-38 BLANCO 9/22/2020 9/30/2020
30731358 TIAB11 ABRIDORA 11 DF5344 MORADO 9/22/2020 9/29/2020
30731366 TIMC12 MCS # 12 DF5344 ROSA 9/22/2020 9/26/2020
30731367 TIAB11 ABRIDORA 11 SK5731-26 AZUL 9/22/2020 9/26/2020
30731368 TIAB03 ABRIDORA 3 DJ3028-C4 NARANJA 9/22/2020 9/28/2020
30731374 TIAB07 ABRIDORA 7 SL5351 MORADO 9/22/2020 9/23/2020
30731378 TIAB09 ABRIDORA 9 FL10237 AZUL 9/22/2020 9/24/2020
30731380 TIAB11 ABRIDORA 11 DF8410 BLANCO 9/22/2020 9/24/2020
30731381 TIFG88 FONGS # 88 SJ4552 NARANJA 9/22/2020 9/28/2020
30731384 TIAB03 ABRIDORA 3 SJ4552 AZUL 9/22/2020 9/23/2020
30731389 TIAB13 ABRIDORA 13 DK9740 AZUL 9/22/2020 9/23/2020
30731419 TIAB04 ABRIDORA 4 DF5344 ROSA 9/22/2020 9/26/2020
30731425 TIAB04 ABRIDORA 4 DJ7431 BLANCO 9/22/2020 9/23/2020
30731431 TIAB13 ABRIDORA 13 DJ3182 ROSA 9/22/2020 9/25/2020
30731443 TITH39 THEN # 39 DJ7431 MORADO 9/22/2020 9/26/2020
30731448 TIAI22 AIRTINT # 22 D85080-38 BLANCO 9/22/2020 9/25/2020
30731462 TIAB13 ABRIDORA 13 DK9740 AZUL 9/22/2020 9/30/2020
30731467 TITI16 THIES # 16 DK9740 ROSA 9/22/2020 9/23/2020
30731468 TIFG66 FONGS # 66 SF6832 NARANJA 9/22/2020 9/29/2020
30731469 TIAB11 ABRIDORA 11 SF1702 NARANJA 9/22/2020 9/27/2020
30731470 TIAB11 ABRIDORA 11 SF5859 NARANJA 9/22/2020 9/25/2020
30731475 TIAB06 ABRIDORA 6 SJ4552 ROSA 9/21/2020 9/28/2020
30731496 TITH38 THEN # 38 D86186 MORADO 9/22/2020 9/26/2020
30731511 TIAB03 ABRIDORA 3 SK9084-J AZUL 9/22/2020 9/23/2020
30731519 TIFG88 FONGS # 88 SJ4552 AZUL 9/22/2020 9/23/2020
30731520 TIAB11 ABRIDORA 11 DJ7431 MORADO 9/22/2020 9/28/2020
30731547 TITH32 THEN # 32 OF3170 NARANJA 9/22/2020 9/29/2020
30731550 TIFG88 FONGS # 88 SJ4552 MORADO 9/22/2020 9/24/2020
30731552 TIFG88 FONGS # 88 SJ4552 MORADO 9/22/2020 9/30/2020
30731576 TIFG89 FONGS # 89 SF5430 ROSA 9/22/2020 9/29/2020
30731581 TIAB06 ABRIDORA 6 SF6135 NARANJA 9/22/2020 9/25/2020
30731584 TIAB03 ABRIDORA 3 D83674-38 ROSA 9/22/2020 9/30/2020
30731600 TIAB07 ABRIDORA 7 DF8410 ROSA 9/22/2020 9/23/2020
30731601 TIAB11 ABRIDORA 11 SL5351 AZUL 9/22/2020 9/26/2020
30731607 TIAB03 ABRIDORA 3 SF6832-K ROSA 9/22/2020 9/23/2020
30731608 TIAB06 ABRIDORA 6 SF6135 MORADO 9/22/2020 9/30/2020
30731609 TIFG88 FONGS # 88 SJ4552 ROSA 9/22/2020 9/25/2020
30731616 TIFG89 FONGS # 89 SF6832 NARANJA 9/22/2020 9/25/2020
30731617 TIFG89 FONGS # 89 SF5430 BLANCO 9/22/2020 9/24/2020
30731618 TIAB03 ABRIDORA 3 SF6135 MORADO 9/21/2020 9/27/2020
30731639 TIFG89 FONGS # 89 SF6832 MORADO 9/22/2020 9/23/2020
30731647 TIFG56 FONGS # 56 D83674-38 AZUL 9/22/2020 9/28/2020
30731651 TITH38 THEN # 38 SK5725-26 ROSA 9/22/2020 9/23/2020
30731655 TIAB12 ABRIDORA 12 SF5430 BLANCO 9/22/2020 9/27/2020
30731659 TIAB07 ABRIDORA 7 D88384MJ NARANJA 9/22/2020 9/30/2020
30731676 TIAB11 ABRIDORA 11 D85080-38 BLANCO 9/22/2020 9/27/2020
30731688 TIAB12 ABRIDORA 12 SF5430 AZUL 9/22/2020 9/24/2020
30731691 TIAB03 ABRIDORA 3 SJ4552 MORADO 9/22/2020 9/30/2020
30731694 TIAB12 ABRIDORA 12 DJ5447 NARANJA 9/22/2020 9/27/2020
30731700 TITH39 THEN # 39 SF10178-A-J BLANCO 9/22/2020 9/30/2020
30731701 TIAB06 ABRIDORA 6 SJ4552 ROSA 9/22/2020 9/23/2020
30731706 TIAB03 ABRIDORA 3 DJ3182 ROSA 9/22/2020 9/26/2020
30731712 TITC34 THECNO DYE # 34 SF8098-C3 BLANCO 9/22/2020 9/29/2020
30731730 TITH39 THEN # 39 SF5430 ROSA 9/22/2020 9/26/2020
30731744 TIAI20 AIRTINT # 20 SF5859 MORADO 9/22/2020 9/23/2020
30731764 TIAB12 ABRIDORA 12 SK9084-J AZUL 9/22/2020 9/30/2020
30731767 TIAB12 ABRIDORA 12 SF5331 NARANJA 9/22/2020 9/29/2020
30731770 TIAB03 ABRIDORA 3 SF6135 NARANJA 9/22/2020 9/26/2020
30731789 TIAB03 ABRIDORA 3 SF6135 MORADO 9/22/2020 9/23/2020
30731817 TIAB12 ABRIDORA 12 SF5331 MORADO 9/22/2020 9/26/2020
30731823 TIAB11 ABRIDORA 11 SF5859 ROSA 9/22/2020 9/30/2020
30731831 TIAB03 ABRIDORA 3 SF6832-K MORADO 9/22/2020 9/30/2020
30731832 TIFG88 FONGS # 88 SJ4552 NARANJA 9/22/2020 9/25/2020
30731856 TIFG66 FONGS # 66 D143900 MORADO 9/22/2020 9/23/2020
30731858 TIAB03 ABRIDORA 3 SK5725-26 MORADO 9/22/2020 9/29/2020
30731861 TITH39 THEN # 39 DJ3182 AZUL 9/22/2020 9/29/2020
30731886 TIAB03 ABRIDORA 3 SF6832-K BLANCO 9/22/2020 9/23/2020
30731918 TIAB12 ABRIDORA 12 SF5430 ROSA 9/22/2020 9/24/2020
30731919 TIJM43 JUMBO # 43 SF6135 AZUL 9/22/2020 9/29/2020
30731947 TIAB03 ABRIDORA 3 SK5725-26 BLANCO 9/22/2020 9/24/2020
30731964 TIFG56 FONGS # 56 D84557-38 NARANJA 9/22/2020 9/24/2020
30732005 TIAB11 ABRIDORA 11 D88384MJ MORADO 9/22/2020 9/24/2020
30732009 AETP03 TOMBLER PENTEK03 DEL8311-36 BLANCO 9/22/2020 9/24/2020
30732048 AETP03 TOMBLER PENTEK03 DEL9085-36 ROSA 9/22/2020 9/29/2020
30732049 AETP03 TOMBLER PENTEK03 DEL8655-36 MORADO 9/22/2020 9/23/2020
30732063 TIFG44 FONGS # 44 SF2421 MORADO 9/22/2020 9/24/2020
30732066 TIFG44 FONGS # 44 SF6832 ROSA 9/22/2020 9/23/2020
30732084 AETP03 TOMBLER PENTEK03 DEL9978-36 NARANJA 9/22/2020 9/25/2020
50146040 TIAB07 ABRIDORA 7 T956 MORADO 9/22/2020 9/26/2020
50146240 TIAB07 ABRIDORA 7 T911-C1 MORADO 9/22/2020 9/25/2020
50146310 TIAB06 ABRIDORA 6 T1327 NARANJA 9/22/2020 9/29/2020
50146327 TIFG73 FONGS # 73 T1287 MORADO 9/22/2020 9/28/2020
50146338 TIAB06 ABRIDORA 6 T1211 MORADO 9/22/2020 9/28/2020
50146339 TIAB03 ABRIDORA 3 T1211 BLANCO 9/22/2020 9/24/2020
50146346 TIFG86 FONG # 86 T570-C2 BLANCO 9/22/2020 9/27/2020
50146371 TIAB04 ABRIDORA 4 T1088 BLANCO 9/22/2020 9/23/2020
50146372 TIAB07 ABRIDORA 7 T1088 ROSA 9/22/2020 9/29/2020
50146373 TIAB04 ABRIDORA 4 T1088 AZUL 9/22/2020 9/23/2020
50146374 TIAB04 ABRIDORA 4 T1088 AZUL 9/22/2020 9/23/2020
50146383 TIFG85 FONG # 85 T1244 ROSA 9/22/2020 9/24/2020
50146393 TIAB08 ABRIDORA 8 TRENCJ0043 BLANCO 9/22/2020 9/26/2020
50146394 TIAB08 ABRIDORA 8 TRENCJ0550 ROSA 9/22/2020 9/27/2020
50146431 TIBE92 BEAM # 92 T1432 AZUL 9/22/2020 9/28/2020
50146435 TIBE92 BEAM # 92 T1432 BLANCO 9/22/2020 9/23/2020
50146476 TIAB08 ABRIDORA 8 TRENCJ0341 MORADO 9/22/2020 9/25/2020
50146519 TIBE93 BEAM # 93 T1512 BLANCO 9/22/2020 9/30/2020
50146526 TITH39 THEN # 39 TRENCJ0006 AZUL 9/22/2020 9/24/2020
50146535 TIBE93 BEAM # 93 T1389 ROSA 9/22/2020 9/29/2020
50146536 TIBE92 BEAM # 92 T1432 NARANJA 9/22/2020 9/26/2020
50146545 TITH32 THEN # 32 TRENCJ0379 BLANCO 9/22/2020 9/24/2020
50146546 TITH39 THEN # 39 TRENCJ0006 NARANJA 9/22/2020 9/25/2020
50146547 TITH17 THEN # 17 TRENC0053 BLANCO 9/22/2020 9/28/2020
50146548 TITH39 THEN # 39 TRENC0183 MORADO 9/22/2020 9/27/2020
50146549 TITH39 THEN # 39 TRENC0183 ROSA 9/22/2020 9/27/2020
50146550 TIFG59 FONGS # 59 TRENC0052 ROSA 9/22/2020 9/29/2020
50146557 TIBE90 BEAM # 90 T1389 ROSA 9/22/2020 9/26/2020
50146560 TIBE90 BEAM # 90 T1391 AZUL 9/22/2020 9/27/2020
50146561 TIBE94 BEAM # 94 T1409-C1 MORADO 9/22/2020 9/24/2020
50146563 TIBE91 BEAM # 91 T1389 NARANJA 9/22/2020 9/28/2020
50146564 TIBE90 BEAM # 90 T1389 MORADO 9/22/2020 9/28/2020
50146569 TIBE90 BEAM # 90 T1389 NARANJA 9/22/2020 9/23/2020
50146575 TIBE90 BEAM # 90 T1389 BLANCO 9/22/2020 9/28/2020
50146585 TITH39 THEN # 39 TRENCJ0006 BLANCO 9/22/2020 9/29/2020
50146591 TIBE94 BEAM # 94 T1409-C1 NARANJA 9/22/2020 9/28/2020
50146592 TIBE92 BEAM # 92 T1389 MORADO 9/22/2020 9/24/2020
50146611 TIAB08 ABRIDORA 8 TRENC0052 AZUL 9/22/2020 9/24/2020
50146612 TITH32 THEN # 32 TRENCJ0389 AZUL 9/22/2020 9/23/2020
50146613 TIAB08 ABRIDORA 8 TRENC0112 NARANJA 9/22/2020 9/24/2020
50146615 TIFG44 FONGS # 44 TRENCJ0543 NARANJA 9/22/2020 9/28/2020
50146641 TITH32 THEN # 32 TRENC0260 NARANJA 9/22/2020 9/23/2020
50146642 TIAB08 ABRIDORA 8 TRENCJ0389 MORADO 9/22/2020 9/27/2020
50146643 TIMC24 MCS # 24 T1158 AZUL 9/22/2020 9/26/2020
50146644 TIBE91 BEAM # 91 T1389 MORADO 9/22/2020 9/24/2020
50146649 TILV02 LAFER 2 T258 BLANCO 9/22/2020 9/25/2020
50146654 TILV02 LAFER 2 T1409-C1 AZUL 9/22/2020 9/26/2020
50146657 TILV01 LAFER 1 T1313 NARANJA 9/21/2020 9/26/2020
50146668 TIBE91 BEAM # 91 T1391 ROSA 9/22/2020 9/29/2020
50146722 TIBE93 BEAM # 93 T258 AZUL 9/22/2020 9/27/2020
50146724 TILV02 LAFER 2 T1391 NARANJA 9/21/2020 9/29/2020
50146725 TILV01 LAFER 1 T1389 NARANJA 9/22/2020 9/24/2020
50146726 TILV01 LAFER 1 T1474 ROSA 9/22/2020 9/26/2020
50146729 TILV02 LAFER 2 T1449 NARANJA 9/22/2020 9/30/2020
50146738 TILV01 LAFER 1 T1389 BLANCO 9/22/2020 9/24/2020
50146739 TILV02 LAFER 2 T1389 ROSA 9/22/2020 9/26/2020
50146742 TILV02 LAFER 2 T1389 BLANCO 9/22/2020 9/29/2020
50146743 TILV01 LAFER 1 T1389 AZUL 9/22/2020 9/23/2020
50146744 TILV01 LAFER 1 T1389 MORADO 9/22/2020 9/30/2020
50146745 TILV02 LAFER 2 T1389 MORADO 9/22/2020 9/28/2020
50146746 TILV02 LAFER 2 T1389 BLANCO 9/22/2020 9/23/2020
50146748 TILV02 LAFER 2 T1409-C1 ROSA 9/22/2020 9/30/2020
50146749 TILV02 LAFER 2 T1006 MORADO 9/22/2020 9/29/2020
50146751 TILV01 LAFER 1 T1432 AZUL 9/22/2020 9/23/2020
50146754 TILV01 LAFER 1 T1065-C1 BLANCO 9/22/2020 9/30/2020
50146755 TILV01 LAFER 1 T1065-C1 NARANJA 9/22/2020 9/29/2020
50146759 TILV01 LAFER 1 T1389 MORADO 9/22/2020 9/23/2020
50146760 TILV02 LAFER 2 T1389 NARANJA 9/22/2020 9/24/2020
50146762 TILV01 LAFER 1 T1065-C1 MORADO 9/22/2020 9/29/2020
50146763 TILV02 LAFER 2 T1409-C1 AZUL 9/22/2020 9/23/2020
50146765 TILV02 LAFER 2 T1389 MORADO 9/22/2020 9/30/2020
50146766 TILV01 LAFER 1 T1389 ROSA 9/22/2020 9/30/2020
50146767 TILV01 LAFER 1 T1287 ROSA 9/22/2020 9/26/2020
50146769 TILV02 LAFER 2 T1389 ROSA 9/22/2020 9/29/2020
50146770 TILV02 LAFER 2 T1389 AZUL 9/22/2020 9/30/2020
50146779 TILV01 LAFER 1 T1389 AZUL 9/22/2020 9/25/2020
50146780 TILV02 LAFER 2 T1389 BLANCO 9/22/2020 9/29/2020
50146782 TILV01 LAFER 1 T570-C2 BLANCO 9/22/2020 9/30/2020
50146783 TILV02 LAFER 2 T1389 ROSA 9/22/2020 9/23/2020
50146785 TILV02 LAFER 2 T1389 MORADO 9/22/2020 9/27/2020
50146787 TILV02 LAFER 2 T1409-C1 NARANJA 9/22/2020 9/26/2020
60123860 TIAB13 ABRIDORA 13 PANTC-00018-C3 MORADO 9/22/2020 9/28/2020
60123987 AECA01 CALANDRA 01 PC30C-03016-C3 BLANCO 9/21/2020 9/27/2020
60123992 TILG01 LAV GOLLER 01 PANTC-00018-C3 NARANJA 9/22/2020 9/28/2020
60124027 TIAB13 ABRIDORA 13 PANTC-00018-C3 AZUL 9/22/2020 9/26/2020
60124034 TIEG ESTACION DE GIRO PDRILY-06793 BLANCO 9/22/2020 9/24/2020
60124041 PLSA02 SANFORIZADORA 02 PCM7550DC-03498 NARANJA 9/22/2020 9/25/2020
60124071 PLSA02 SANFORIZADORA 02 PDOBL-06988 NARANJA 9/22/2020 9/27/2020
60124120 TIAB11 ABRIDORA 11 PPANBY-03150 NARANJA 9/22/2020 9/23/2020
60124125 TIAB09 ABRIDORA 9 PANTC-00018-C3 BLANCO 9/22/2020 9/23/2020
60124128 PLSA02 SANFORIZADORA 02 PANTC-00018-C3 AZUL 9/22/2020 9/23/2020
60124135 PLSA02 SANFORIZADORA 02 PANTC-00018-C3 NARANJA 9/22/2020 9/28/2020
60124141 AECA01 CALANDRA 01 PC30C-03016-C3 MORADO 9/22/2020 9/24/2020
60124157 TIAB11 ABRIDORA 11 PPANBY-03150 ROSA 9/22/2020 9/27/2020
60124179 TIAB07 ABRIDORA 7 PPANBY-03150 BLANCO 9/22/2020 9/25/2020
60124180 TIAB11 ABRIDORA 11 PPANBY-03150 NARANJA 9/22/2020 9/30/2020
60124181 TIAB09 ABRIDORA 9 PPANBY-03150 NARANJA 9/22/2020 9/29/2020
60124190 TILG01 LAV GOLLER 01 PANTC-00018-C3 MORADO 9/22/2020 9/30/2020
60124196 PLSA02 SANFORIZADORA 02 PANTC-00018-C3 MORADO 9/22/2020 9/29/2020
60124214 TIPB01 COLD PAD BATCH01 PDRILY-06793 MORADO 9/22/2020 9/27/2020
60124215 TIAB07 ABRIDORA 7 PPANBY-03150 AZUL 9/22/2020 9/26/2020
60124223 TIAB09 ABRIDORA 9 PPANBY-03150 MORADO 9/22/2020 9/28/2020
60124241 TIFG99 FONGS # 99 PCO150C-05841 ROSA 9/22/2020 9/29/2020
60124252 AECA01 CALANDRA 01 PC30C-03016-C3 AZUL 9/22/2020 9/28/2020
60124272 AECA01 CALANDRA 01 PC30C-03016-C3 NARANJA 9/22/2020 9/25/2020
60124279 TIAB13 ABRIDORA 13 PANTC-00018-C3 BLANCO 9/21/2020 9/27/2020
60124280 TILG01 LAV GOLLER 01 PANTC-00018-C3 MORADO 9/21/2020 9/23/2020
60124283 TIFG83 FONG # 83 PANTC-00018-C3 BLANCO 9/22/2020 9/30/2020
60124287 TIAB13 ABRIDORA 13 PANTC-00018-C3 ROSA 9/22/2020 9/30/2020
60124288 TIAB13 ABRIDORA 13 PANTC-00018-C3 BLANCO 9/22/2020 9/26/2020
60124289 TIFG87 FONG # 87 PANTC-00018-C3 ROSA 9/22/2020 9/25/2020
60124313 TIAB04 ABRIDORA 4 PCHAC-05617 NARANJA 9/22/2020 9/23/2020
60124314 TIAB11 ABRIDORA 11 PCHAC-05617 MORADO 9/22/2020 9/24/2020
60124323 PLSA02 SANFORIZADORA 02 PDOBL-06988 MORADO 9/22/2020 9/25/2020
60124376 TILG01 LAV GOLLER 01 PANTC-06977 BLANCO 9/22/2020 9/25/2020
60124387 PLSA02 SANFORIZADORA 02 PCHAC-06165 AZUL 9/22/2020 9/28/2020
60124403 PLSA02 SANFORIZADORA 02 PCHAC-05665 AZUL 9/22/2020 9/23/2020
60124413 TILG01 LAV GOLLER 01 PANTC-00018-C3 AZUL 9/22/2020 9/28/2020
60124414 TIAB11 ABRIDORA 11 PANTC-00018-C3 AZUL 9/22/2020 9/23/2020
60124417 TIFG67 FONGS # 67 PANTC-00018-C3 ROSA 9/22/2020 9/30/2020
60124441 TIAB11 ABRIDORA 11 PPANBY-03150 ROSA 9/22/2020 9/26/2020
60124442 TIAB09 ABRIDORA 9 PPANBY-03150 ROSA 9/22/2020 9/27/2020
60124443 TIAB09 ABRIDORA 9 PPANBY-03150 AZUL 9/22/2020 9/27/2020
60124452 TIAB11 ABRIDORA 11 PANTC-00018-C3 NARANJA 9/22/2020 9/23/2020
60124458 TIAB03 ABRIDORA 3 PCHAC-06165 MORADO 9/22/2020 9/23/2020
60124459 TIAB03 ABRIDORA 3 PCHAC-06165 ROSA 9/22/2020 9/26/2020
60124460 TIJI96 JIGGER96 PINDU1-02107 NARANJA 9/22/2020 9/26/2020
60124466 TITH17 THEN # 17 PPANBY-03150 AZUL 9/22/2020 9/25/2020
60124471 TIAB11 ABRIDORA 11 PCHADC-03183 BLANCO 9/22/2020 9/23/2020
60124472 PLSA02 SANFORIZADORA 02 PCHALYC-06075 NARANJA 9/22/2020 9/27/2020
60124481 TIAB11 ABRIDORA 11 PANTC-00018-C3 MORADO 9/22/2020 9/23/2020
60124483 TIAB11 ABRIDORA 11 PANTC-00018-C3 BLANCO 9/22/2020 9/28/2020
60124486 PLSA02 SANFORIZADORA 02 PC30C-03016-C3 BLANCO 9/22/2020 9/23/2020
60124487 PLSA02 SANFORIZADORA 02 PC30C-03016-C3 AZUL 9/22/2020 9/25/2020
60124490 TIEG ESTACION DE GIRO PCA301C-05024 NARANJA 9/22/2020 9/23/2020
60124491 TIAB03 ABRIDORA 3 PCHAC-06165 AZUL 9/22/2020 9/30/2020
60124508 TIEG ESTACION DE GIRO PTWILA-05741 MORADO 9/22/2020 9/30/2020
60124509 TIEG ESTACION DE GIRO PPOAS-04649 AZUL 9/22/2020 9/26/2020
60124511 TILG02 LAV GOLLER 02 PC30C-03016-C3 AZUL 9/22/2020 9/23/2020
60124512 PLSA02 SANFORIZADORA 02 PC30C-03016-C3 MORADO 9/22/2020 9/29/2020
60124513 TILG02 LAV GOLLER 02 PCA301C-05024 ROSA 9/22/2020 9/23/2020
60124526 AEES03 ESMERILADORA MIC PANTC-06983 AZUL 9/22/2020 9/30/2020
60124529 PLSA02 SANFORIZADORA 02 PC30C-03016-C3 ROSA 9/22/2020 9/29/2020
60124539 PLSA02 SANFORIZADORA 02 PC30P1-05454 BLANCO 9/22/2020 9/27/2020
60124541 TIGA02 GASEADORA 02 PC40P7-06996 BLANCO 9/22/2020 9/27/2020
60124554 TIEG ESTACION DE GIRO PC30C-05260 ROSA 9/22/2020 9/23/2020
60124555 TIEG ESTACION DE GIRO PC30C-05260 BLANCO 9/22/2020 9/25/2020
60124556 TIEG ESTACION DE GIRO PC30C-05260 MORADO 9/22/2020 9/23/2020
60124557 TIEG ESTACION DE GIRO PC30C-05260 BLANCO 9/22/2020 9/23/2020
60124558 TIEG ESTACION DE GIRO PC30C-05260 AZUL 9/22/2020 9/25/2020
60124590 TILG02 LAV GOLLER 02 PINDU1-02107 MORADO 9/21/2020 9/23/2020
60124591 TILG02 LAV GOLLER 02 PINDU1-02107 ROSA 9/21/2020 9/29/2020
60124592 TILG02 LAV GOLLER 02 PINDU1-02107 BLANCO 9/21/2020 9/25/2020
60124600 TIEG ESTACION DE GIRO PTWILA-05741 ROSA 9/21/2020 9/27/2020
60124606 AEES03 ESMERILADORA MIC PANTC-06983 ROSA 9/22/2020 9/23/2020
60124625 TILG02 LAV GOLLER 02 PC30C-03016-C3 NARANJA 9/22/2020 9/26/2020
60124626 TILG02 LAV GOLLER 02 PC30C-03016-C3 MORADO 9/22/2020 9/24/2020
60124627 TIEG ESTACION DE GIRO PC30C-05260 AZUL 9/22/2020 9/29/2020
60124629 TIEG ESTACION DE GIRO PC30C-05260 ROSA 9/22/2020 9/23/2020
60124630 TIGA02 GASEADORA 02 PC30C-05260 NARANJA 9/21/2020 9/28/2020
60124631 TIEG ESTACION DE GIRO PC30C-05260 ROSA 9/22/2020 9/24/2020
60124632 TIEG ESTACION DE GIRO PC30C-05260 NARANJA 9/22/2020 9/25/2020
60124633 TIEG ESTACION DE GIRO PC30C-05260 BLANCO 9/22/2020 9/23/2020
60124639 TIGA02 GASEADORA 02 PC40P7-06994 AZUL 9/22/2020 9/25/2020
60124640 TIGA02 GASEADORA 02 PC40P7-06995 NARANJA 9/22/2020 9/27/2020
60124641 TIGA02 GASEADORA 02 PC40P7-06996 MORADO 9/22/2020 9/23/2020
60124643 TILG02 LAV GOLLER 02 PCA301C-05024 BLANCO 9/22/2020 9/28/2020
60124685 TIEG ESTACION DE GIRO PCM4075C-05985 MORADO 9/22/2020 9/25/2020
60124687 TIEG ESTACION DE GIRO PLAL16C-04162-C2 NARANJA 9/22/2020 9/26/2020
60124688 TIGA02 GASEADORA 02 PLVL12C-04163 ROSA 9/22/2020 9/24/2020
60124689 TIEG ESTACION DE GIRO PPOAS-04649 ROSA 9/22/2020 9/29/2020
60124692 TIGA02 GASEADORA 02 PC40P7-06995 BLANCO 9/22/2020 9/23/2020
70026044 THLE LLENADO DE ESPIG HPR01650 AZUL 9/21/2020 9/28/2020
70026054 THLE LLENADO DE ESPIG HPR01650 NARANJA 9/22/2020 9/24/2020
70026058 THLE LLENADO DE ESPIG HPR01650 AZUL 9/22/2020 9/30/2020
70026059 THFG13 FONGS # 13 HPR01650 BLANCO 9/22/2020 9/23/2020
70026062 THLE LLENADO DE ESPIG HPR01650 MORADO 9/22/2020 9/30/2020
70026065 THSC29 SCHOLL # 29 HPR01697 AZUL 9/22/2020 9/28/2020
70026066 THLE LLENADO DE ESPIG HPR01697 MORADO 9/22/2020 9/25/2020
70026067 THCN01 CONOPRINT 01 HPR08087 ROSA 9/22/2020 9/28/2020
70026070 THLE LLENADO DE ESPIG HPR01650 ROSA 9/22/2020 9/24/2020
80248473 TIFG78 FONGS # 78 SF5121-26 MORADO 9/22/2020 9/30/2020
80249034 PLSA02 SANFORIZADORA 02 PCHADC-03183 NARANJA 9/22/2020 9/28/2020
80249166 TIPB01 COLD PAD BATCH01 PDRILSA-03080 MORADO 9/22/2020 9/25/2020
80249191 AECO06 COMPACTADORA 06 SF5745 NARANJA 9/22/2020 9/28/2020
80249192 TIAB11 ABRIDORA 11 SF5745 MORADO 9/22/2020 9/24/2020
80249193 TIFG80 FONGS # 80 SF5745 AZUL 9/22/2020 9/29/2020
80249281 TIFG78 FONGS # 78 SOHO-IN BLANCO 9/22/2020 9/24/2020
80249435 PLSA02 SANFORIZADORA 02 PCHATC-04841 AZUL 9/22/2020 9/25/2020
80249485 TIAB03 ABRIDORA 3 PBEN4C-04600 NARANJA 9/22/2020 9/29/2020
80249497 TITH32 THEN # 32 SF1059 BLANCO 9/22/2020 9/28/2020
80249506 AECO06 COMPACTADORA 06 SF6832-K BLANCO 9/22/2020 9/28/2020
80249527 TIPB01 COLD PAD BATCH01 PTWILA-05741 AZUL 9/22/2020 9/26/2020
80249542 TIAB03 ABRIDORA 3 PPANBY-05805-C1 NARANJA 9/22/2020 9/26/2020
80249552 TIAB04 ABRIDORA 4 PC50VC-05168 AZUL 9/22/2020 9/24/2020
80249553 TIPB01 COLD PAD BATCH01 PPOPAT-05740 BLANCO 9/21/2020 9/30/2020
80249554 TIAB04 ABRIDORA 4 PC30C-02016-C2 NARANJA 9/22/2020 9/24/2020
80249579 TIAB09 ABRIDORA 9 SF6832 ROSA 9/22/2020 9/27/2020
80249584 TIFG58 FONGS # 58 SF5387 NARANJA 9/22/2020 9/27/2020
80249585 TIAB03 ABRIDORA 3 DF9994 BLANCO 9/22/2020 9/25/2020
80249586 TIPB01 COLD PAD BATCH01 PC30C-03016 NARANJA 9/22/2020 9/26/2020
80249622 AECO06 COMPACTADORA 06 SF4303 BLANCO 9/21/2020 9/28/2020
80249626 TIFG79 FONGS # 79 SF1702 BLANCO 9/22/2020 9/23/2020
80249631 TIFG79 FONGS # 79 SF1702 ROSA 9/22/2020 9/29/2020
80249653 TIFG66 FONGS # 66 SF8098 AZUL 9/22/2020 9/25/2020
80249661 TISC10 SCHOLL # 10 SF5859 NARANJA 9/22/2020 9/30/2020
80249677 PLSA01 SANFORIZADORA 01 PINDU1-02107 BLANCO 9/21/2020 9/30/2020
80249678 TIPB01 COLD PAD BATCH01 PPOPAT-05740 NARANJA 9/22/2020 9/27/2020
80249681 TIEG ESTACION DE GIRO PDRILSA-01241-C2 BLANCO 9/22/2020 9/25/2020
80249682 TIEG ESTACION DE GIRO PDRILSA-01241-C2 AZUL 9/22/2020 9/27/2020
80249707 TIAB03 ABRIDORA 3 OF3734 MORADO 9/22/2020 9/26/2020
80249716 TIFG66 FONGS # 66 D81538 BLANCO 9/22/2020 9/28/2020
80249736 AECO06 COMPACTADORA 06 T258 MORADO 9/22/2020 9/29/2020
80249922 AETR01 TRANSFER No 1 DF9994 AZUL 9/22/2020 9/25/2020
80249923 AETR01 TRANSFER No 1 DF9994 NARANJA 9/22/2020 9/27/2020
80249924 AETR01 TRANSFER No 1 DF9994 MORADO 9/22/2020 9/28/2020
80249925 AETR01 TRANSFER No 1 DF9994 ROSA 9/22/2020 9/28/2020
80249926 AETR01 TRANSFER No 1 DF9994 BLANCO 9/22/2020 9/28/2020
80249927 AETR01 TRANSFER No 1 DF9994 AZUL 9/22/2020 9/24/2020
80249928 AETR01 TRANSFER No 1 DF9994 NARANJA 9/22/2020 9/23/2020
80249929 AETR01 TRANSFER No 1 DF9994 MORADO 9/22/2020 9/26/2020
80249930 AETR01 TRANSFER No 1 DF9994 ROSA 9/22/2020 9/24/2020
90431912 AECO06 COMPACTADORA 06 SF4303 ROSA 9/21/2020 9/25/2020
90431974 TIAB08 ABRIDORA 8 T1006 ROSA 9/22/2020 9/30/2020
90431989 TIAB08 ABRIDORA 8 SF4303 ROSA 9/22/2020 9/25/2020
90431990 TIAB08 ABRIDORA 8 SF4303 BLANCO 9/22/2020 9/25/2020
90432003 TIAB08 ABRIDORA 8 T1389 MORADO 9/22/2020 9/28/2020
90432004 TIAB08 ABRIDORA 8 T1389 NARANJA 9/22/2020 9/29/2020
90432005 TIAB08 ABRIDORA 8 T1389 BLANCO 9/21/2020 9/26/2020
90432116 TIAB08 ABRIDORA 8 T1389 AZUL 9/22/2020 9/27/2020
90432120 TIAB06 ABRIDORA 6 T1389 MORADO 9/22/2020 9/25/2020
90432121 TIAB08 ABRIDORA 8 T1389 NARANJA 9/22/2020 9/25/2020
90432130 AETR01 TRANSFER No 1 OM2822 BLANCO 9/22/2020 9/25/2020
90432135 TIAB08 ABRIDORA 8 PPOAS-01928 NARANJA 9/22/2020 9/29/2020
90432165 AECO06 COMPACTADORA 06 SL4668-C2 AZUL 9/22/2020 9/30/2020
90432216 TIAB08 ABRIDORA 8 T1389 BLANCO 9/22/2020 9/25/2020
90432217 TIAB08 ABRIDORA 8 T1389 AZUL 9/22/2020 9/30/2020
90432237 AETR01 TRANSFER No 1 OM2822 NARANJA 9/22/2020 9/24/2020
90432245 TIAB08 ABRIDORA 8 T1409-C1 AZUL 9/22/2020 9/25/2020
90432253 TIAB08 ABRIDORA 8 TE2188 MORADO 9/22/2020 9/26/2020
90432254 TIAB08 ABRIDORA 8 TE2188 ROSA 9/22/2020 9/30/2020
90432255 TIAB08 ABRIDORA 8 TE2188 NARANJA 9/22/2020 9/25/2020
90432286 AECO06 COMPACTADORA 06 SL5402 ROSA 9/22/2020 9/28/2020
90432331 TIAB08 ABRIDORA 8 T1389 ROSA 9/22/2020 9/26/2020
90432336 TIAB08 ABRIDORA 8 PPANBY-03150 BLANCO 9/22/2020 9/27/2020
90432346 TIAB08 ABRIDORA 8 PPANBY-03150 AZUL 9/22/2020 9/30/2020
90432357 AECO06 COMPACTADORA 06 SL5402 BLANCO 9/22/2020 9/29/2020
90432361 AECO06 COMPACTADORA 06 SL5402 AZUL 9/22/2020 9/24/2020
90432368 AETR01 TRANSFER No 1 OM2822 ROSA 9/22/2020 9/23/2020
90432386 TIAB08 ABRIDORA 8 PPOAS-01928 MORADO 9/22/2020 9/29/2020
90432405 TIAB08 ABRIDORA 8 PCREPVC-04003 NARANJA 9/22/2020 9/28/2020
90432422 TIAB08 ABRIDORA 8 SF2562 AZUL 9/22/2020 9/30/2020
90432425 PLSA02 SANFORIZADORA 02 PC30C-03016-C3 MORADO 9/22/2020 9/28/2020
90432426 PLSA02 SANFORIZADORA 02 PC30C-03016-C3 ROSA 9/22/2020 9/27/2020
90432525 PLSA02 SANFORIZADORA 02 PPOPAT-05740 BLANCO 9/22/2020 9/26/2020
90432526 TIAB08 ABRIDORA 8 T1389 BLANCO 9/22/2020 9/26/2020
90432601 AETR01 TRANSFER No 1 T1389 AZUL 9/21/2020 9/27/2020
90432602 AETR01 TRANSFER No 1 T1389 MORADO 9/22/2020 9/27/2020
na de la (Tabla 1).
na F) y "F. Fin"(Columna G). Si la fórmula tiene en
Volver
e las siguientes categorías:

na y color específicados en la (Tabla 2.)

Tabla 2.
Kilos Días Capacidad MÁQUINA/COLOR AZUL BLANCO MORADO
334 3 Grande TIBE90 364.0 355.5 354.5
107 1 Pequeña TIBE91 0.0 0.0 358.0
21 5 Pequeña TIBE92 45.0 257.5 359.5
226 8 Media TIBE93 363.5 361.5 0.0
17.68 7 Pequeña TIBE94 0.0 0.0 360.0
455 2 Grande
100 1 Pequeña TOTAL 772.5 974.5 1,432.0
398 3 Grande
454 6 Grande
399 3 Grande
101 3 Pequeña
452 1 Grande
400 8 Grande
308 1 Grande
446 7 Grande
454 1 Grande
445 6 Grande
402 6 Grande
396 8 Grande
400 3 Grande
452 3 Grande
441 5 Grande
448 8 Grande
448 7 Grande
48.65 4 Pequeña
0 1 Pequeña
409 8 Grande
310 5 Grande
402 5 Grande
447 3 Grande
449 7 Grande
204 3 Media
406 3 Grande
335 4 Grande
447 1 Grande
451 5 Grande
449 2 Grande
457 7 Grande
39.7 6 Pequeña
4.43 8 Pequeña
8.1 2 Pequeña
301 2 Grande
455 4 Grande
449 8 Grande
452 3 Grande
49.53 3 Pequeña
106 1 Pequeña
403 5 Grande
455 6 Grande
448 1 Grande
452 4 Grande
301 1 Grande
451 1 Grande
461 1 Grande
407 1 Grande
327 2 Grande
396 1 Grande
447 4 Grande
453 1 Grande
455 4 Grande
0 4 Pequeña
332 3 Grande
331 2 Grande
339 5 Grande
338 3 Grande
337 2 Grande
450 1 Grande
445 3 Grande
335 4 Grande
452 1 Grande
306 5 Grande
451 3 Grande
450 1 Grande
451 9 Grande
302 2 Grande
449 8 Grande
326 1 Grande
456 3 Grande
330 7 Grande
452 6 Grande
399 5 Grande
302 6 Grande
395 1 Grande
452 5 Grande
455 5 Grande
0 6 Pequeña
280 8 Media
286 6 Media
452 4 Grande
450 3 Grande
299 8 Media
450 2 Grande
306 1 Grande
301 1 Grande
454 5 Grande
284 5 Media
283 1 Media
288 5 Media
271 3 Media
284 3 Media
279 1 Media
281 1 Media
271 4 Media
298 5 Media
262 5 Media
284 2 Media
292 2 Media
300 8 Media
334 1 Grande
451 9 Grande
394 2 Grande
310 6 Grande
102 4 Pequeña
452 8 Grande
454 5 Grande
409 4 Grande
303 3 Grande
95 3 Pequeña
293 4 Media
71 4 Pequeña
448 1 Grande
453 2 Grande
452 7 Grande
445 4 Grande
299 4 Media
272 4 Media
450 2 Grande
442 5 Grande
458 3 Grande
455 6 Grande
448 6 Grande
307 1 Grande
19.37 8 Pequeña
308 5 Grande
255 1 Media
310 8 Grande
79 3 Pequeña
452 1 Grande
446 1 Grande
396 1 Grande
450 3 Grande
272 3 Media
284 5 Media
282 2 Media
275 1 Media
296 6 Media
451 5 Grande
450 5 Grande
451 4 Grande
282 5 Media
282 1 Media
289 3 Media
328 6 Grande
448 3 Grande
445 2 Grande
307 8 Grande
274 1 Media
278 5 Media
291 4 Media
280 3 Media
279 3 Media
272 1 Media
280 3 Media
444 7 Grande
328 5 Grande
451 7 Grande
301 7 Grande
449 8 Grande
450 5 Grande
454 6 Grande
304 7 Grande
453 1 Grande
0 5 Pequeña
452 1 Grande
450 3 Grande
250 6 Media
443 2 Grande
440 5 Grande
453 6 Grande
157 8 Media
456 2 Grande
450 1 Grande
449 8 Grande
451 6 Grande
453 4 Grande
306 1 Grande
312 1 Grande
51 6 Pequeña
299 1 Media
300 1 Media
301 7 Grande
455 7 Grande
449 5 Grande
444 6 Grande
453 4 Grande
396 7 Grande
302 1 Grande
0 4 Pequeña
337 1 Grande
328 5 Grande
15.38 2 Pequeña
15.46 1 Pequeña
63 6 Pequeña
450 6 Grande
298 1 Media
65 6 Pequeña
451 7 Grande
329 7 Grande
451 2 Grande
453 8 Grande
449 2 Grande
395 7 Grande
396 4 Grande
458 3 Grande
448 7 Grande
451 8 Grande
337 7 Grande
330 4 Grande
445 4 Grande
337 6 Grande
250 1 Media
43 2 Pequeña
100 2 Pequeña
461 6 Grande
460 1 Grande
301 1 Grande
328 4 Grande
458 1 Grande
451 3 Grande
451 4 Grande
456 3 Grande
297 8 Media
296 1 Media
152 7 Media
329 5 Grande
394 3 Grande
456 7 Grande
447 4 Grande
448 1 Grande
447 1 Grande
153 6 Media
404 7 Grande
448 2 Grande
445 8 Grande
449 7 Grande
302 3 Grande
445 8 Grande
152 1 Media
250 4 Media
300 1 Media
298 8 Media
451 3 Grande
448 3 Grande
449 2 Grande
296 6 Media
450 1 Grande
34 6 Pequeña
449 1 Grande
454 5 Grande
105 8 Pequeña
450 5 Grande
446 2 Grande
452 8 Grande
451 5 Grande
456 8 Grande
451 1 Grande
444 4 Grande
448 7 Grande
449 4 Grande
442 1 Grande
446 8 Grande
392 7 Grande
295 4 Media
302 1 Grande
395 4 Grande
150 8 Media
300 8 Media
459 3 Grande
180 1 Media
444 7 Grande
453 7 Grande
298 1 Media
452 2 Grande
295 7 Media
449 2 Grande
35 2 Pequeña
102 2 Pequeña
299 2 Media
304 7 Grande
301 1 Grande
36 2 Pequeña
35 1 Pequeña
546 3 Grande
298.8 4 Media
403 3 Grande
354 7 Grande
443 6 Grande
357 6 Grande
361 2 Grande
440 5 Grande
441 1 Grande
279.4 7 Media
451 1 Grande
217 1 Media
443 2 Grande
38 4 Pequeña
65.5 5 Pequeña
45 6 Pequeña
257.5 1 Media
102.8 3 Pequeña
361.5 8 Grande
37.9 2 Pequeña
359 7 Grande
302 4 Grande
134 2 Pequeña
38.1 3 Pequeña
90.7 6 Pequeña
38.6 5 Pequeña
44.3 5 Pequeña
63.4 7 Pequeña
357 4 Grande
364 5 Grande
360 2 Grande
360 6 Grande
354.5 6 Grande
359.5 1 Grande
355.5 6 Grande
38 7 Pequeña
363 6 Grande
359.5 2 Grande
62.8 2 Pequeña
63 1 Pequeña
64.5 2 Pequeña
15 6 Pequeña
98.7 1 Pequeña
44.8 5 Pequeña
176 4 Media
358 2 Grande
362.5 3 Grande
364 4 Grande
268 5 Media
364 7 Grande
363.5 5 Grande
362 8 Grande
362 2 Grande
361 4 Grande
359 8 Grande
359.5 2 Grande
360 4 Grande
360.5 7 Grande
362.5 1 Grande
359 8 Grande
361 6 Grande
363.5 1 Grande
358 8 Grande
435.5 7 Grande
302 1 Grande
438 8 Grande
421 7 Grande
359 1 Grande
361.5 2 Grande
442 7 Grande
358 1 Grande
358 8 Grande
359 8 Grande
444 4 Grande
359 7 Grande
361 8 Grande
364 3 Grande
358.5 7 Grande
441 8 Grande
360 1 Grande
360.5 5 Grande
357 4 Grande
268 6 Media
391 6 Grande
300 6 Media
284 4 Media
386 2 Grande
344 3 Grande
299 5 Media
277 1 Media
70 1 Pequeña
298 1 Media
307 6 Grande
527 2 Grande
282 5 Media
298 3 Media
281 8 Media
284 7 Media
145 8 Pequeña
268 7 Media
283 5 Media
292 4 Media
284 6 Media
368 7 Grande
113 6 Pequeña
400 3 Grande
304 6 Grande
273 2 Media
266 8 Media
277 8 Media
279 4 Media
279 3 Media
80 1 Pequeña
283 2 Media
177 3 Media
80 3 Pequeña
316 6 Grande
325 1 Grande
70 6 Pequeña
188 1 Media
155 8 Media
295 4 Media
286 5 Media
289 5 Media
152 1 Media
151 1 Media
257 4 Media
286 4 Media
93 3 Pequeña
151 1 Media
158 5 Media
160 1 Media
140 6 Pequeña
582 1 Grande
506 3 Grande
195 1 Media
282 8 Media
211 8 Media
260 4 Media
147 1 Pequeña
594 7 Grande
294 1 Media
334 8 Grande
635 7 Grande
94 5 Pequeña
200 5 Media
284 1 Media
72 3 Pequeña
348 1 Grande
366 1 Grande
340 3 Grande
288 2 Media
292 8 Media
287 4 Media
244 6 Media
0 1 Pequeña
512 4 Grande
667 2 Grande
288 7 Media
170 1 Media
285 7 Media
140 2 Pequeña
333 3 Grande
437 1 Grande
125 3 Pequeña
110 5 Pequeña
198 1 Media
593 6 Grande
234 3 Media
371 4 Grande
375 2 Grande
411 7 Grande
97 1 Pequeña
471.3 7 Grande
465.8 2 Grande
469.1 8 Grande
844.7 1 Grande
480.6 8 Grande
392.8 6 Grande
388 3 Grande
389.8 6 Grande
470 2 Grande
77.8 8 Pequeña
98.6 6 Pequeña
158.1 3 Media
458 6 Grande
450 2 Grande
400 7 Grande
99.15 2 Pequeña
93.6 3 Pequeña
250 7 Media
450 6 Grande
176 6 Media
60 4 Pequeña
119 4 Pequeña
108 2 Pequeña
170.4 9 Media
48.5 2 Pequeña
80 5 Pequeña
83.2 5 Pequeña
60 3 Pequeña
40 4 Pequeña
54.2 7 Pequeña
109 1 Pequeña
110 7 Pequeña
118 3 Pequeña
300 8 Media
94.5 9 Pequeña
61.1 5 Pequeña
102 3 Pequeña
65 5 Pequeña
250 4 Media
108 6 Pequeña
45.5 7 Pequeña
14.5 3 Pequeña
9.6 5 Pequeña
11.2 6 Pequeña
6.4 6 Pequeña
4.8 6 Pequeña
4.8 2 Pequeña
6.4 1 Pequeña
4.8 4 Pequeña
3.5 2 Pequeña
147.1 4 Pequeña
277 8 Media
172.6 3 Media
170.2 3 Media
339 6 Grande
336 7 Grande
341 5 Grande
352 5 Grande
372 3 Grande
360 3 Grande
91.2 3 Pequeña
67 7 Pequeña
 48 8 Pequeña
270 3 Media
269 8 Media
89.1 2 Pequeña
267 3 Media
126 4 Pequeña
147 8 Pequeña
127 3 Pequeña
113.1 6 Pequeña
260.5 4 Media
157 5 Media
157 8 Media
109.4 7 Pequeña
108.3 2 Pequeña
93 1 Pequeña
69 7 Pequeña
569.1 6 Grande
174 8 Media
94 6 Pequeña
94 5 Pequeña
36.4 4 Pequeña
368.8 4 Grande
199 6 Media
200 5 Media
NARANJA ROSA
359.5 357.0
360.0 364.0
302.0 0.0
0.0 359.0
363.0 0.0

1,384.5 1,080.0
 Actividad
Desarrolle una tabla dinámica con base a la información de la Tabla 1, dónde se observe la suma de los kilos por
capacidad (Grande, mediana, pequeña) y color.
1.
2. Elabore un gráfico que represente la información de dicha tabla.
3. Inserte un segmentador de datos por color para dicho gráfico.
bserve la suma de los kilos por
Volver
 Grabe una macro que organice los datos consignados e
para macro), en esta hoja (3. Grabadora de Macros), de
3. Grabadora de macros número. Posteriormente a la organización de la base a
boton rojo de la parte superior derecha.

1 2 3 4

BASE PARA MACRO

1 2 3
30727237 PERCHA 01 SF10207
30728053 COMPACTADORA 06 SL4906
30728102 COMPACTADORA 06 D89551
30728199 PERCHA 03 SF10207
30728658 ABRIDORA 1 CC08-0130APJQ
30728862 COMPACTADORA 06 FL5735
30728879 FONGS # 78 DQ8353
30729132 ABRIDORA 6 OQ5588

4 5 6
MORADO CORTE B JUAN CARLOS ROMERO CARDONA
NARANJA STOCK LINEA RICARDO GARZON CASTRO
NARANJA PEPAL JOSE FERNANDO GUTIERREZ QUEVED
ROSA CORTE B CARLOS ALBERTO SALAMANCA COLOR
MORADO PEPAL OPERARIO PRUEBA
AZUL STOCK RICARDO GARZON CASTRO
NARANJA STOCK LINEA JEISSON ARVEY GARCIA LOPEZ
BLANCO STOCK LINEA RAMIREZ YAIR
 datos consignados en la hoja (Base Volver
adora de Macros), debajo de cada
MACRO
nización de la base asisgne la macro al
recha.

5 6
 Fecha Vendedor
3/17/2017 Carlos Vasquez
3/20/2017 Juan Carlos
3/22/2017 Pedro Noriega
4/20/2017 José Almanares
4/17/2017 Carlos Vasquez
5/22/2017 Juan Carlos
5/22/2017 Pedro Noriega
5/24/2017 José Almanares
5/17/2017 José Almanares
5/20/2017 Carlos Vasquez
5/27/2017 Juan Carlos
5/20/2017 Pedro Noriega
5/17/2017 José Almanares
5/18/2018 Carlos Vasquez
6/16/2018 Juan Carlos
6/17/2018 Pedro Noriega
6/20/2018 José Almanares
6/19/2018 Carlos Vasquez
7/5/2018 Juan Carlos
7/6/2018 Pedro Noriega
7/8/2018 José Almanares
8/4/2018 Carlos Vasquez
8/6/2018 Juan Carlos
8/7/2018 Pedro Noriega
9/1/2018 José Almanares
9/4/2018 Carlos Vasquez
9/5/2019 Juan Carlos
9/8/2019 Pedro Noriega
9/20/2019 José Almanares
 Tienda Producto Importe MOSTRAR SU
Tienda A Laptop i3 S/1,000.00
Y APLIC
Tienda B Impresora S/200.00
Tienda B Laptop i5 S/3,500.00
Tienda C Impresora S/100.00
Tienda A Pantalla 42 S/100.00
Tienda C Teclado S/20.00
Tienda C Mouse S/10.00
Tienda A Teclado S/20.00
Tienda D Laptop i7 S/4,000.00
Tienda C Laptop i7 S/4,000.00
Tienda C Pantalla 17 S/180.00
Tienda A Mouse S/10.00
Tienda D Teclado S/30.00
Tienda B Laptop i3 S/1,000.00
Tienda C USB 3.0.1 S/15.00
Tienda A Laptop i7 S/4,000.00
Tienda C USB 3.0.1 S/15.00
Tienda A Impresora S/100.00
Tienda D Pantalla 42 S/100.00
Tienda A Laptop i3 S/15.00
Tienda C Pantalla 42 S/100.00
Tienda D USB 3.0.1 S/15.00
Tienda C Pantalla 42 S/100.00
Tienda A Laptop i7 S/4,000.00
Tienda A Pantalla 42 S/100.00
Tienda B Impresora S/100.00
Tienda A Laptop i3 S/1,000.00
Tienda D Laptop i5 S/3,500.00
Tienda B USB 3.0.1 S/15.00
MOSTRAR SUMA DE VENTAS POR TIENDA, AGRUPAR POR FECHAS(AÑO,
Y APLICAR SEGMENTACIÓN POR VENDEDOR Y ESCALA DE TIEMPO
POR FECHAS(AÑO, MES)
SCALA DE TIEMPO