Curso básico de Excel
CAPITULO TRES
1. Funciones y operaciones con fechas
2. Combinar celdas y formatos de tablas
3. Funciones de unión y extracción
4. Funciòn lógica SI
5. Buscar y reemplazar datos
FECHAS DE DEUDAS Y PLAZOS DEDAD DEL DEUDOR
Plazo Fecha Fecha Edad Edad
Documento Fecha Edad Años
días Vencimiento Nacimiento Meses Dias
8853 01/01/2021 45 15/02/2021 5/22/2003 21 11 27
9395 26/01/2021 60 27/03/2021
9851 20/02/2021 30 22/03/2021
5295 13/01/2021 90 13/04/2021
9805 27/02/2021 15 14/03/2021
8531 05/01/2021 10 15/01/2021
6239 06/04/2021 45 21/05/2021
9582 06/01/2021 60 07/03/2021
7545 14/04/2021 90 13/07/2021
9368 22/02/2021 120 22/06/2021
9003 23/04/2021 240 19/12/2021
9634 06/04/2021 120 04/08/2021
9588 15/05/2021 15 30/05/2021
ESTADO
MAYOR DE EDAD
APELLIDO APELLIDO
NOMBRE NOMBRE 2
PATERNO MATERNO CONCATENAR
Perez Oyos Juan Arturo Perez Oyos Juan Arturo
Mente Saray Ana Cecilia Mente Saray Ana Cecilia
Orozco Bermudes Diana Marina Orozco Bermudes Diana Marina
Bernal Santos Juan Andres Bernal Santos Juan Andres
Peralta Ochoa Anibal Eduardo Peralta Ochoa Anibal Eduardo
Jara Mira Santisago Arturo Jara Mira Santisago Arturo
Reyes Osten Alicia Kamila Reyes Osten Alicia Kamila
Chacha Tara Meliza Aida Chacha Tara Meliza Aida
Estant Malink Peter Jean Estant Malink Peter Jean
Sarta Calto Miriam Susana Sarta Calto Miriam Susana
Amanto Lazo Fila Lorena Amanto Lazo Fila Lorena
Bermudes Ortega Juan Jose Bermudes Ortega Juan Jose
Monoz Lara Juan Adrian Monoz Lara Juan Adrian
Endara Lara Miguel Angel Endara Lara Miguel Angel
Altamirano Pare Juan Miguel Altamirano Pare Juan Miguel
Osman Lasso Maria Daniela Osman Lasso Maria Daniela
Ochos Neves Dalia Pilar Ochos Neves Dalia Pilar
Calina Mera Johana Susana Calina Mera Johana Susana
UNIR CADENAS NOMBRES
Juan Arturo Perez Oyos Juan Arturo Perez Oyos
Ana Cecilia Mente Saray Ana Cecilia Mente Saray
Diana Marina Orozco Bermudes Diana Marina Orozco Bermudes
Juan Andres Bernal Santos Juan Andres Bernal Santos
Anibal Eduardo Peralta Ochoa Anibal Eduardo Peralta Ochoa
Santisago Arturo Jara Mira Santisago Arturo Jara Mira
Alicia Kamila Reyes Osten Alicia Kamila Reyes Osten
Meliza Aida Chacha Tara Meliza Aida Chacha Tara
Peter Jean Estant Malink Peter Jean Estant Malink
Miriam Susana Sarta Calto Miriam Susana Sarta Calto
Fila Lorena Amanto Lazo Fila Lorena Amanto Lazo
Juan Jose Bermudes Ortega Juan Jose Bermudes Ortega
Juan Adrian Monoz Lara Juan Adrian Monoz Lara
Miguel Angel Endara Lara Miguel Angel Endara Lara
Juan Miguel Altamirano Pare Juan Miguel Altamirano Pare
Maria Daniela Osman Lasso Maria Daniela Osman Lasso
Dalia Pilar Ochos Neves Dalia Pilar Ochos Neves
Johana Susana Calina Mera Johana Susana Calina Mera
ITEM NRO-PARTE DESCRIPCION CANTIDADPRECIO/U PRECIO/T PESO/U PESO/T
1 31N6-10110-SK MCV SEAL KIT 3 24.72 74.16 204 612
2 S732-085030 BUSHING-DU 6 7.61 45.66 0.14 0.84
3 11N7-10020 ELEMENT-COUPLING 2 40.27 80.54 0.79 3.16
4 2474-7009 PUMP COUPLING RUBBER 2 23.8 47.6 0.68 2.04
5 2474-7009K PUMP COUPLING KIT 1 48.3 48.3 1.9 1.9
6 31N1-40941 RUBBER-T/JOINT 3 34.91 104.73 0.36 1.44
7 C011B-50146 RELIEF VALVE ASSY 1 89.98 89.98 1.2 1.2
8 K9001804 MAIN RELIEF VALVE 1 56.18 56.18 1.2 1.2
9 XJBN-00162 VALVE ASSY-RELIEF 1 56.18 56.18 0.46 0.92
10 2401-9223KT M/PUMP O-RING KIT 8 31.01 248.08 0.1 0.8
11 XKAH-00576 PLATE-SHOE 4 11.24 44.96 0.71 2.84
12 XKAQ-00228 GEAR PLANET NO.2 8 44.94 359.52 3.83 30.64
13 XKAQ-00235 GEAR SUN NO.2 2 53.72 107.44 2.36 4.72
14 XKAQ-00231 PIN NO.2 4 17.16 68.64 0.95 3.8
15 XKAQ-00232 PIN-SPRING 8 0.44 3.52 0.15 0.1
16 XKAQ-00208 RING-THRUST NO.1 2 5.17 10.34 0.02 0.04
17 XKAQ-00208 RING-THRUST NO.1 2 2.81 5.62 0.02 0.04
18 XKAQ-00237 GEAR-PLANET NO.1 3 58.21 174.63 2.95 8.85
19 XKAQ-00237 GEAR-PLANET NO.1 3 44.94 134.82 2.95 8.85
20 XKAQ-00238 BEARNG NEEDLE NO.1 6 17.85 107.1 0.15 0.9
21 XKAQ-00240 PIN NO.1 6 8.68 52.08 0.39 2.34
22 31Y1-15885 SEAL KIT, BOOM CYL 9 42.12 379.08 0.25 2.5
23 31Y1-15236 SEAL KIT, ARM CYL 5 53.92 269.6 0.38 2.28
24 31Y1-15705 SEAL KIT, BUCKET CYL 5 60.45 302.25 0.31 1.55
25 401107-00277A BOOM CYL SEAL KIT 4 42.9 171.6 0.23 0.92
26 401107-00294A BKT CYL SEAL KIT(1095~) 4 39 156 0.19 0.76
27 XKAY-00553 SEAL KIT, SWING MOTOR 4 51.68 206.72 0.1 0.5
28 XKAY-00544 VALVE PLATE 4 32.28 129.12 0.44 1.76
29 XKAY-00522 ROLLER BEARING 1 30.34 30.34 0.94 1.88
30 XKAY-00533 GUIDE-BALL 1 23.6 23.6 0.32 0.32
31 XKAY-00633 CYLINDER BLOCK 1 146.06 146.06 4.93 9.86
32 XKAY-00536 PISTON KIT(1KT:9EA),SWG 1 73.03 73.03 2.6 5.2
33 XKAY-00527 SHOE PLATE 1 15.51 15.51 0.77 0.77
34 XKAQ-00030 CAGE-NEEDLE 6 14.63 87.78 0.08 0.48
35 XKAY-00537 FRICTION PLATE 3 22.14 66.42 0.11 0.33
36 XKAY-00538 PLATE 3 19.5 58.5 0.08 0.24
37 XKAQ-00289 GEAR-SUN NO.2 5 64.55 322.75 3.79 18.95
38 XJBN-00086 SUPPORT, MAIN PUMP(XKA 8 61.8 494.4 9.53 76.24
39 XKAQ-00218 BEARING, TRV RDC GEAR 4 140.44 561.76 5.46 21.84
40 K9007403 ANGULAR BEARING: BALL 2 185.38 370.76 6 12
41 XKAQ-00219 SEAL-FLOATING 4 159.89 639.56 2.7 13.5
42 XKAQ-00246 PLUG-HYDRAULIC 15 2.34 35.1 0.09 1.35
43 P760-102030 HOSE-HYD RUBBER 3 10.73 32.19 0.82 2.46
44 800108-00150 HYD LEVEL GAGE 2 18.08 36.16 0.13 0.26
45 400603-00071 HEAD GASKET (0055,0066A 1 47.19 47.19 0.75 1.5
46 400632-00078 GASKET SET (ALL) 8027 1 225.21 225.21 2.01 2.01
47 E131-0473 GAUGE-LEVEL 4 14.14 56.56 0.12 0.48
48 33Q6-02600 GAUGE-LEVEL(31N6-02600) 3 15.41 46.23 0.13 0.39
49 800108-00150 HYD LEVEL GAGE 2 18.08 36.16 0.13 0.39
50 110-00081 DU BUSHING 12 2.7 32.4 0.19 1.52
51 110-00110 DU BUSHING;95X30 12 3.04 36.48 0.18 1.44
52 XJBN-00163 MAIN RELIEF VALVE 1 56.18 56.18 0.49 0.98
53 31N6-17400 MAIN RELIEF VALVE 1 56.18 56.18 0.53 1.06
54 XKAQ-00032 OIL SEAL, SWG RDC GEAR 10 23.31 233.1 0.09 0.54
55 XKAY-00448 [Link],TRV MOTOR 2 30.03 60.06 3.08 3.08
56 XKAQ-00019 PIN CARRIER /N 1 6 35.3 211.8
57 31N6-40950 SEAL KIT,TURNING JOINT 3 38.61 115.83 0.28 0.28
58 31E9-0126-A FILTER-DRAIN 12 4.1 49.2 0.58 6.96
59 400504-00217 AIR BREATHER FILTER 6 7.74 46.44 0.07 0.42
60 XKAY-00049 JOINT, RCV LVR 4 11.24 44.96 0.08 0.48
61 E131-0212-A ELEMENT-RETURN FILTER 8 11.9 95.2 1.87 11.22
54.25