EXAMEN PARCIAL

Alumno:

Grupo:

Docente:

Fecha: Wednesday 28 de September de 2022

 Computación II

EN PARCIAL

Consideraciones:

- Trabajar desde este mismo archivo

- Guardar el archivo constantemente
- Subirlo al Trilce

de September de 2022
smo archivo
stantemente
 Se quiere demostrar la tasa de la siguiente proforma que me alcanzaron por whatsapp del banco BANBIF.
El valor del departamento es de 211,600 soles, de los cuales se reduce la inicial 25 mil soles, el bono del estado mi vivienda
18,800 y el restante es lo que se debe financiar en 20 años, si se cancela 181 soles ¿Cuánto es la tasa de interés que ofrece
banco? No debe haber más de 1% de diferencia con la tasa ofrecida en la imagen.

VALOR DEPARTAMENTO
INICIAL
BONO MI VIVENDA
MONTO A FINANCIAR
PAGO MENSUAL
CUOTAS

TASA
 BANBIF.
ono del estado mi vivienda de
asa de interés que ofrece el
 A partir de la celda P10 muestra a todos los empleados de la sucursal La Victoria que trabajen en Ventas y a los
sueldos mayores a 4000 soles

Fecha de Fecha de
Sexo Status Sucursal Área Cat Cod DNI
Nacimiento ingreso
M Activo 12/24/1988 Jesús María Marketing 8/12/2019 A 2 24607136
F Activo 10/20/1972 S.M.P. Administración 5/28/2013 A 1 67616741
M Activo 10/5/1971 S.M.P. Administración 6/16/2015 C 1 54465826
M Activo 11/6/1976 Jesús María Ventas 11/4/2014 B 1 60907093
M Activo 2/4/1976 La Victoria Ventas 5/16/2020 B 1 88274025
M Activo 10/1/2000 S.M.P. Administración 7/14/2014 B 1 35376800
M Activo 7/10/1985 S.M.P. Administración 5/18/2018 A 1 52551056
M Activo 8/7/1984 Jesús María Ventas 5/4/2019 A 2 34644155
M Activo 9/18/1978 La Victoria Ventas 8/22/2014 C 2 77896942
M Activo 4/24/1990 Lince Marketing 7/17/2019 B 1 87464581
M Activo 1/3/1991 La Victoria Ventas 1/19/2017 A 2 27833402
M Activo 10/24/1991 Jesús María Ventas 8/2/2019 B 1 62491144
F Activo 5/2/1983 Breña Administración 7/7/2013 B 1 67180607
M Activo 10/12/1975 Jesús María Ventas 4/29/2017 C 2 20624534
F Activo 12/18/1971 Callao Administración 9/11/2016 C 2 28861914
M Activo 2/27/2001 Barrios Altos Administración 4/11/2020 A 1 26856473
M Activo 4/21/1972 La Victoria Ventas 3/29/2018 C 2 40188533
F Activo 12/23/1976 Jesús María Counter 8/20/2013 A 2 71355426
M Activo 8/2/1981 Jesús María Counter 1/28/2018 C 2 26881916
F Activo 3/18/1989 La Victoria Ventas 8/8/2015 A 2 78973224
M Activo 7/24/2000 Breña Administración 9/10/2017 A 2 90971821
M Activo 12/11/1994 S.M.P. Administración 7/25/2015 C 1 26707296
M inactivo 1/16/1981 San Isidro Counter 5/13/2018 A 2 77258085
M Activo 7/20/1972 Barrios Altos Administración 6/11/2019 C 1 45052133
M Activo 12/3/1970 Lima Ventas 3/30/2017 B 1 53131983
M Activo 12/3/1974 Jesús María Ventas 7/18/2016 B 2 17828201
F Activo 8/15/1974 Breña Administración 8/13/2015 C 2 39635066
F Activo 2/20/1980 Chorrillos Counter 5/3/2017 A 1 45799446
M Activo 10/13/1996 Callao Counter 10/5/2017 A 1 70145226
F Activo 6/14/2001 Callao Counter 1/15/2016 A 2 37398274
M Activo 2/13/1997 Lima Ventas 5/16/2017 B 1 66309324
F Inactivo 4/15/1997 Jesús María Ventas 4/2/2020 B 1 60825592
M Activo 7/30/1986 Surquillo Administración 4/24/2015 C 2 26164939
F Activo 12/6/1999 Callao Counter 2/18/2017 C 2 43752233
M Activo 9/9/1974 S.M.P. Administración 3/28/2016 C 1 83060775
M Activo 3/13/1970 Breña Administración 5/3/2016 C 2 82532565
M Activo 9/25/1973 Barrios Altos Administración 11/15/2016 C 1 20072540
M Activo 11/11/1999 Barrios Altos Administración 3/15/2013 C 2 42366418
F Activo 6/18/1990 S.M.P. Administración 9/25/2013 C 2 77251723
M Activo 5/14/1992 San Miguel Counter 1/27/2015 A 2 36024816
M Inactivo 12/26/1985 Chimbote Administración 7/13/2013 A 1 79628457
F Inactivo 5/30/1974 Callao Administración 1/14/2019 A 2 12080474
M Activo 7/4/1986 Callao Ventas 7/31/2018 A 1 71001357
M Activo 9/14/2002 La Victoria Ventas 12/22/2015 C 1 45362607
M Activo 2/6/1994 La Victoria Ventas 8/20/2013 B 1 28272857
M Inactivo 1/19/1984 San isidro Marketing 4/14/2013 A 1 83971306
M Activo 4/26/1975 Callao Ventas 5/19/2019 C 2 31087296
F Activo 10/5/1983 San Juan de Miraflores Administración 4/26/2020 C 2 38988013
M Inactivo 4/16/1982 Lince Counter 5/8/2018 A 2 38667272
M Activo 12/9/1978 Callao Ventas 10/4/2017 B 2 75112091
F Activo 1/29/1990 Lima Administración 6/10/2016 C 1 38025890
M Activo 8/2/1972 Jesús María Counter 7/18/2019 B 1 59841322
F Activo 2/14/1971 Jesús María Ventas 4/14/2014 C 2 90686331
M Activo 4/29/2002 San Juan de Miraflores Administración 1/19/2014 A 1 87860439
M Activo 1/24/1970 Jesús María Ventas 1/26/2017 C 1 68453327
F Activo 3/6/1993 Jesús María Counter 5/7/2014 A 2 32316423
M Activo 7/8/1979 La Victoria Ventas 8/26/2019 C 1 41447339
F Activo 11/14/1980 Barranco Counter 6/19/2014 A 2 29872349
M Activo 12/21/1972 Barranco Counter 12/29/2019 B 2 45144628
M Inactivo 5/24/1974 Piura Ventas 3/7/2016 A 2 16372601
M Activo 5/22/1984 Breña Administración 10/31/2015 A 2 68510400
M Activo 1/23/1983 Jesús María Counter 6/14/2014 A 1 60516897
F Activo 8/21/1977 Jesús María Ventas 6/6/2019 B 2 35158277
F Activo 5/24/1996 Jesús María Ventas 10/2/2015 B 2 81791691
M Activo 7/11/1972 Lima Administración 8/8/2014 A 1 52267648
M Activo 9/28/1975 El Agustino Administración 6/3/2014 C 1 78662806
M Activo 4/15/1983 La Victoria Ventas 9/15/2013 A 1 78237187
F Activo 3/1/1999 Callao Ventas 1/24/2013 A 2 82535735
F inactivo 9/14/1975 La Victoria Ventas 11/19/2019 C 1 51887191
M Inactivo 7/24/1992 Chimbote Administración 3/26/2017 A 2 36643399
M Activo 9/2/1971 Lima Marketing 3/4/2019 A 1 47047292
F Activo 10/7/1970 Breña Administración 11/6/2019 A 2 27807910
M Activo 2/28/1989 San Miguel Counter 8/23/2018 A 2 16886958
M Activo 11/25/1982 Callao Counter 2/26/2017 B 2 87061010
M Activo 12/17/1998 San Juan de Miraflores Administración 7/17/2016 A 1 50235820
M Activo 1/19/1993 Barrios Altos Administración 11/1/2014 A 2 67626914
M Activo 6/5/1995 Barrios Altos Administración 12/20/2015 A 2 12684872
F Activo 7/22/1998 Jesús María Counter 10/21/2016 B 1 93711802
F Activo 3/30/2000 Jesús María Ventas 11/13/2013 B 1 76185293
M Activo 5/22/2000 La Victoria Ventas 12/16/2019 A 2 64962932
M Activo 11/3/1972 La Victoria Ventas 6/30/2019 B 2 44151477
M Activo 2/22/1985 Jesús María Ventas 9/6/2019 B 2 83674710
M Activo 9/11/2001 Lima Administración 7/3/2020 C 2 45791925
F Activo 2/7/1974 San Isidro Counter 10/4/2018 A 1 73162808
M Activo 10/1/2002 Callao Administración 10/20/2015 A 2 63325654
F Activo 2/22/1972 Callao Counter 12/8/2016 A 2 91069056
M Activo 3/28/1992 Callao Ventas 5/20/2019 C 2 89003214
F Activo 5/14/1975 Jesús María Counter 11/18/2014 A 2 92269736
M Activo 5/1/1970 Jesús María Marketing 7/18/2013 A 2 22729527
F Activo 10/12/1982 Callao Counter 4/9/2013 A 2 45063285
M Activo 11/15/1983 Lima Administración 11/11/2016 B 2 62411533
M Activo 7/17/1976 San Borja Marketing 7/3/2013 A 1 24477767
F Inactivo 10/12/1983 Callao Administración 1/22/2013 A 2 63663975
F Activo 5/12/1975 Lima Administración 4/14/2020 C 2 50040424
F Activo 5/3/1981 Pueblo Libre Administración 7/15/2014 C 2 64747071
F Activo 2/26/1993 Callao Ventas 7/25/2017 A 2 46556919
M Activo 12/14/1997 Callao Administración 4/21/2015 B 1 52334735
M Activo 7/29/1998 San Isidro Marketing 4/10/2018 A 2 36236588
F Activo 5/3/1986 S.M.P. Administración 7/17/2013 A 2 14509356
M Activo 3/12/1996 Jesús María Counter 1/25/2015 B 1 27215371
M Activo 12/1/1972 Jesús María Administración 10/29/2014 A 2 58810587
M Activo 12/19/1994 Barranco Counter 6/12/2013 A 1 44339097
M Activo 11/20/1983 La Victoria Ventas 1/30/2016 B 1 19529409
M Activo 8/12/1991 San Isidro Counter 8/18/2017 A 2 95603141
M Activo 5/5/1983 Jesús María Ventas 11/18/2018 B 2 54942894
F Inactivo 7/11/1985 Pueblo Libre Administración 8/20/2019 A 1 33431833
F Activo 6/16/1976 San Juan de Miraflores Administración 12/19/2015 B 1 20745954
F Activo 10/19/1990 Jesús María Ventas 2/14/2019 A 1 98757921
F Activo 11/10/1984 San Miguel Counter 7/29/2019 A 2 87152593
F Activo 7/7/1989 La Victoria Ventas 5/31/2019 A 1 95562701
M Activo 6/29/1999 Callao Counter 11/26/2017 A 2 84077738
F Inactivo 4/13/1981 Jesús María Counter 10/12/2016 A 1 42278374
F Activo 9/14/1981 Barranco Counter 6/29/2013 A 2 93582647
F Activo 12/19/1972 Pueblo Libre Administración 9/10/2019 A 1 59419874
M Activo 3/19/1986 Surquillo Administración 6/14/2013 A 2 23692113
M Activo 1/23/1971 Callao Counter 9/20/2014 B 2 24024651
F Activo 7/20/1990 Callao Ventas 3/22/2013 B 1 66772326
M Activo 11/14/1973 Lima Administración 1/3/2018 A 1 36944320
M Activo 3/30/1998 El Agustino Administración 9/23/2017 A 2 50028415
M Activo 10/28/1980 Barrios Altos Administración 3/12/2016 A 2 65106060
M Activo 3/13/1994 San Juan de Miraflores Administración 4/6/2013 A 2 61037850
M Activo 5/30/1982 Lima Administración 8/18/2013 A 2 29922640
M Activo 12/1/1973 San Miguel Counter 2/13/2020 B 2 13990905
M Activo 1/2/1974 San Miguel Counter 3/10/2014 A 1 90037097
M Inactivo 4/16/1998 El Agustino Administración 12/6/2017 A 1 72283439
F Activo 10/27/1993 Breña Administración 4/14/2017 A 1 14635767
F Activo 5/9/1999 El Agustino Administración 5/24/2017 A 2 48572120
M Activo 1/4/1994 El Agustino Administración 8/15/2019 A 1 81903860
F Activo 11/21/1982 Jesús María Counter 4/27/2018 A 1 21163848
M Inactivo 4/2/1997 Breña Administración 6/13/2016 A 2 40818040
F Activo 9/4/1986 Callao Counter 11/15/2018 A 2 70897264
M Activo 5/23/1995 S.M.P. Administración 6/29/2019 B 2 83062942
F Inactivo 4/3/1986 San Borja Administración 3/17/2015 A 2 85871520
F Activo 9/30/1983 Breña Administración 6/8/2019 A 1 41956840
M inactivo 6/5/1971 Jesús María Ventas 12/13/2017 A 1 37621263
M Activo 4/16/1975 San Juan de Miraflores Administración 3/18/2013 A 2 89166938
F Activo 5/3/1972 Callao Counter 12/26/2013 A 1 16322633
F Activo 2/1/1994 San Isidro Counter 4/11/2014 A 1 71227110
M Activo 12/12/1990 Breña Administración 2/18/2018 B 2 40829750
M Activo 2/2/1996 Jesús María Administración 4/30/2018 B 2 91256998
M Activo 8/1/1975 Jesús María Counter 12/11/2015 A 2 38697245
M Activo 3/3/1975 Jesús María Ventas 11/14/2019 B 1 12671382
F Activo 6/14/1987 Surco Marketing 1/26/2018 A 2 49248727
M Activo 6/14/1996 Callao Administración 1/28/2017 A 1 44356719
F inactivo 9/8/2000 La Victoria Ventas 10/1/2013 B 2 47435905
M Activo 2/6/1991 Callao Ventas 2/18/2015 B 1 79040064
M Activo 4/2/1984 Surquillo Administración 11/8/2019 A 2 41415659
F inactivo 5/21/1985 Callao Counter 4/17/2018 A 1 81698161
M Activo 6/25/1975 Barranco Counter 6/5/2017 A 1 56264802
F Activo 1/21/2001 Surquillo Administración 6/28/2016 A 1 65331546
F Activo 7/20/1986 Callao Ventas 4/21/2017 A 1 31029807
M Activo 5/13/1974 Callao Ventas 5/7/2015 A 1 27422331
M inactivo 7/2/1986 Jesús María Ventas 10/24/2013 A 2 19953747
F Activo 7/24/1995 Callao Ventas 9/11/2018 A 1 67210101
F Inactivo 5/6/1985 Lima Administración 5/8/2019 A 2 19395329
M Activo 3/11/1983 Callao Administración 8/28/2017 A 2 48281679
F Activo 6/19/1989 Lima Administración 1/16/2014 A 2 32819299
F Activo 12/21/1995 Jesús María Administración 3/22/2020 A 2 84861057
M Activo 4/1/1985 La Victoria Ventas 6/25/2014 A 2 19248669
M Inactivo 8/19/1997 San Miguel Counter 12/12/2018 A 2 66940736
M Inactivo 10/7/1993 Lima Administración 5/7/2014 A 1 59434726
M Activo 1/4/1971 Lima Administración 9/3/2017 A 1 87141262
e trabajen en Ventas y a los de Breña que trabajen en Administración. Ambos deben tener

Nombre Apellido Sueldo Descuento Total a pagar

Guillermo Zumaeta Abanto S/ 7,458.00 S/ 372.90 S/ 7,085.10

Maria Angelica Zavala Alban S/ 3,402.00 S/ 170.10 S/ 3,231.90
Jose Eduardo Villena Alegria S/ 6,277.00 S/ 313.85 S/ 5,963.15
Eduardo Villaran Alvarez S/ 5,828.00 S/ 291.40 S/ 5,536.60
Luis Miguel Villanueva Alvarez S/ 6,950.00 S/ 347.50 S/ 6,602.50
Elmer Alejandro Vicuña Apac S/ 6,515.00 S/ 325.75 S/ 6,189.25
Pedro Esteban Velarde Arce S/ 6,469.00 S/ 323.45 S/ 6,145.55
Roberto Abel Vega Arciniega S/ 5,880.00 S/ 294.00 S/ 5,586.00
Jorge Manuel Vasquez Arrospide S/ 4,253.00 S/ 212.65 S/ 4,040.35
Ciro Peregrino Vasquez Astocondor S/ 6,010.00 S/ 300.50 S/ 5,709.50
Juan Octavio Vasquez Bandan S/ 5,879.00 S/ 293.95 S/ 5,585.05
Miguel Angel Vargas Barco S/ 6,138.00 S/ 306.90 S/ 5,831.10
Ana Luz Vargas Barrueto S/ 5,707.00 S/ 285.35 S/ 5,421.65
Fernando Cruz Valladares Barzola S/ 6,800.00 S/ 340.00 S/ 6,460.00
Maria Luisa Valencia Bazalar S/ 5,185.00 S/ 259.25 S/ 4,925.75
Marcos Angel Valdiviezo Becerra S/ 5,588.00 S/ 279.40 S/ 5,308.60
Luis Ricardo Ticona Cabrejos S/ 2,348.00 S/ 117.40 S/ 2,230.60
Guadalupe Terashima Calero S/ 6,259.00 S/ 312.95 S/ 5,946.05
Luis Andres Tagle Camones S/ 3,965.00 S/ 198.25 S/ 3,766.75
Lidia Veronica Suyon Campos S/ 5,287.00 S/ 264.35 S/ 5,022.65
Juan Francisco Soria Castillo S/ 4,847.00 S/ 242.35 S/ 4,604.65
Juan Ignacio Solorzano Castillo S/ 7,359.00 S/ 367.95 S/ 6,991.05
Julio Solano Castro S/ 3,800.00 S/ 190.00 S/ 3,610.00
Eduardo Romulo Seas Castro S/ 7,559.00 S/ 377.95 S/ 7,181.05
Humberto Sanchez Chavez S/ 5,080.00 S/ 254.00 S/ 4,826.00
Nestor Abel Sanchez Chinchay S/ 4,956.00 S/ 247.80 S/ 4,708.20
Lenka Angelica Samalvides Collantes S/ 4,347.00 S/ 217.35 S/ 4,129.65
Paula Salvatierra Concha S/ 3,656.00 S/ 182.80 S/ 3,473.20
Pablo Salazar Cordero S/ 7,279.00 S/ 363.95 S/ 6,915.05
Carmen Ruelas Cordova S/ 5,760.00 S/ 288.00 S/ 5,472.00
Alberto Roman Cortez S/ 3,556.00 S/ 177.80 S/ 3,378.20
Rossana Monica Rodriguez Cruz S/ 6,930.00 S/ 346.50 S/ 6,583.50
Luis Ernesto Ramon Rafael Rodriguez Cuba S/ 5,028.00 S/ 251.40 S/ 4,776.60
Sofia Rodriguez Cubas S/ 2,392.00 S/ 119.60 S/ 2,272.40
Carlos Rafael Robles Cuentas S/ 5,473.00 S/ 273.65 S/ 5,199.35
Jorge Luis Rivera De S/ 2,074.00 S/ 103.70 S/ 1,970.30
Jorge Antonio Revolle De S/ 7,253.00 S/ 362.65 S/ 6,890.35
Victor Manuel Ramos Del S/ 4,139.00 S/ 206.95 S/ 3,932.05
Frine Ramirez Delgado S/ 3,840.00 S/ 192.00 S/ 3,648.00
John Richard Raez Delgado S/ 5,617.00 S/ 280.85 S/ 5,336.15
Ricardo Zenon Portillo Delgado S/ 4,885.00 S/ 244.25 S/ 4,640.75
Sonia Mercedes Poma Esparza S/ 4,534.00 S/ 226.70 S/ 4,307.30
Jaime Victor Pinto Falcon S/ 4,979.00 S/ 248.95 S/ 4,730.05
Jose Pinedo Fernandez S/ 6,344.00 S/ 317.20 S/ 6,026.80
Juan Pilares Ferrer S/ 7,510.00 S/ 375.50 S/ 7,134.50
Martin Peralta Figueroa S/ 6,420.00 S/ 321.00 S/ 6,099.00
Jesus Paz Flores S/ 4,821.00 S/ 241.05 S/ 4,579.95
Patricia Renee Paredes Flores S/ 6,374.00 S/ 318.70 S/ 6,055.30
Carlos Enrique Palomino Flores S/ 5,336.00 S/ 266.80 S/ 5,069.20
Cesar Alberto Padilla Fuentes S/ 5,990.00 S/ 299.50 S/ 5,690.50
Adelina Zarela Padilla Gambirazio S/ 4,105.00 S/ 205.25 S/ 3,899.75
Percy Ordaya Garay S/ 5,217.00 S/ 260.85 S/ 4,956.15
Milagros Olano Garcia S/ 4,331.00 S/ 216.55 S/ 4,114.45
Fernando Martin Ñavincopa Gentille S/ 6,451.00 S/ 322.55 S/ 6,128.45
Marco Antonio Nuñez Gil S/ 2,489.00 S/ 124.45 S/ 2,364.55
Lourdes Niño Gonzales S/ 3,301.00 S/ 165.05 S/ 3,135.95
Raul Neira Granda S/ 6,789.00 S/ 339.45 S/ 6,449.55
Rosa Mercedes Muñoz Gronerth S/ 6,440.00 S/ 322.00 S/ 6,118.00
Alberto Martin Muñoz Guevara S/ 2,256.00 S/ 112.80 S/ 2,143.20
Arnaldo Muñoz Guzman S/ 7,293.00 S/ 364.65 S/ 6,928.35
Javier Arnulfo Mosquera Guzman S/ 2,149.00 S/ 107.45 S/ 2,041.55
Miguel Angel Mory Herencia S/ 3,472.00 S/ 173.60 S/ 3,298.40
Doris Lida Montoya Herrera S/ 3,009.00 S/ 150.45 S/ 2,858.55
Rosa Zoila Montiel Huaman S/ 4,864.00 S/ 243.20 S/ 4,620.80
Aldo Javier Montes Huaman S/ 6,360.00 S/ 318.00 S/ 6,042.00
Eduardo Montalvan Huamani S/ 3,333.00 S/ 166.65 S/ 3,166.35
Pedro Martin Mestanza Iturri S/ 7,762.00 S/ 388.10 S/ 7,373.90
Claudia Maria Mercado Iwashita S/ 6,760.00 S/ 338.00 S/ 6,422.00
Lourdes Mendoza Jurado S/ 7,196.00 S/ 359.80 S/ 6,836.20
Igor Mario Mendo Jurado S/ 5,308.00 S/ 265.40 S/ 5,042.60
Santiago Mendivil Leiva S/ 7,774.00 S/ 388.70 S/ 7,385.30
Janetliz Mejia Leiva S/ 4,149.00 S/ 207.45 S/ 3,941.55
Hector Javier Matos Lencinas S/ 4,918.00 S/ 245.90 S/ 4,672.10
Alejandro Martinez Leon S/ 4,471.00 S/ 223.55 S/ 4,247.45
Alejandro Jose Maguiña Leon S/ 2,267.00 S/ 113.35 S/ 2,153.65
Vladimir Yuri Mac Lescano S/ 2,506.00 S/ 125.30 S/ 2,380.70
Gonzalo Antonio Luy Liza S/ 7,159.00 S/ 357.95 S/ 6,801.05
Victoria Luccheti Lizarraga S/ 7,906.00 S/ 395.30 S/ 7,510.70
Carla Gioconda Lozano Lossio S/ 4,758.00 S/ 237.90 S/ 4,520.10
Alex Michael Lopez Lozano S/ 5,753.00 S/ 287.65 S/ 5,465.35
Jaime Lopez Machaca S/ 7,784.00 S/ 389.20 S/ 7,394.80
Dario Loayza Marca S/ 4,126.00 S/ 206.30 S/ 3,919.70
Eduardo Demetrio Llanos Mayco S/ 2,493.00 S/ 124.65 S/ 2,368.35
Silvana Leon Medina S/ 7,796.00 S/ 389.80 S/ 7,406.20
Nilo Legua Medina S/ 3,674.00 S/ 183.70 S/ 3,490.30
Rocio Lachira Melgar S/ 4,539.00 S/ 226.95 S/ 4,312.05
Luis La Mendoza S/ 3,135.00 S/ 156.75 S/ 2,978.25
Milagros Kolevic Miñano S/ 5,723.00 S/ 286.15 S/ 5,436.85
Martin Jauregui Miranda S/ 6,046.00 S/ 302.30 S/ 5,743.70
Rosio Isabel Infante Miraval S/ 6,812.00 S/ 340.60 S/ 6,471.40
Jorge Luis Illescas Montes S/ 4,089.00 S/ 204.45 S/ 3,884.55
Jose Luis Holguin Morales S/ 2,294.00 S/ 114.70 S/ 2,179.30
Rocio Estther Livia Hinostroza Moscol S/ 4,043.00 S/ 202.15 S/ 3,840.85
Yvett Hidalgo Mucha S/ 4,081.00 S/ 204.05 S/ 3,876.95
Maria Isabel Hidalgo Noriega S/ 2,647.00 S/ 132.35 S/ 2,514.65
Paola Ivette Hercilla Nuñez S/ 2,774.00 S/ 138.70 S/ 2,635.30
Juan Carlos Gutierrez Oliva S/ 5,291.00 S/ 264.55 S/ 5,026.45
Juan Carlos Guerra Ortiz S/ 7,102.00 S/ 355.10 S/ 6,746.90
Coralith Marlinda Gotuzzo Paredes S/ 2,243.00 S/ 112.15 S/ 2,130.85
Juan Jose Gonzalez Pera S/ 6,633.00 S/ 331.65 S/ 6,301.35
Carlos Manuel Gonzales Pereyra S/ 5,764.00 S/ 288.20 S/ 5,475.80
Carlos Alberto Gonzales Perez S/ 3,109.00 S/ 155.45 S/ 2,953.55
Pablo Gomez Perez S/ 5,113.00 S/ 255.65 S/ 4,857.35
Alfredo Gomez Piazze S/ 3,087.00 S/ 154.35 S/ 2,932.65
Javier Omar Garcia Pimentel S/ 2,154.00 S/ 107.70 S/ 2,046.30
Clariza Edith Garcia Ponce S/ 5,201.00 S/ 260.05 S/ 4,940.95
Karina Del Pilar Garcia Prado S/ 5,823.00 S/ 291.15 S/ 5,531.85
Ana Garcia Quiroz S/ 2,939.00 S/ 146.95 S/ 2,792.05
Esmelda Garavito Rae S/ 5,652.00 S/ 282.60 S/ 5,369.40
Maria Cecilia Galloso Ramirez S/ 2,418.00 S/ 120.90 S/ 2,297.10
Luis Alberto Flores Ramirez S/ 3,645.00 S/ 182.25 S/ 3,462.75
Fabiola Flores Ramos S/ 3,439.00 S/ 171.95 S/ 3,267.05
Mey Yeni Flores Renteria S/ 5,638.00 S/ 281.90 S/ 5,356.10
Yolanda Flores Revilla S/ 4,482.00 S/ 224.10 S/ 4,257.90
Juan Isidro Ferrandiz Robles S/ 5,999.00 S/ 299.95 S/ 5,699.05
Raul Fernandez Roca S/ 7,743.00 S/ 387.15 S/ 7,355.85
Erika Cecilia Farroñay Rodriguez S/ 6,837.00 S/ 341.85 S/ 6,495.15
Eddie Alessandro Espinoza Rosa S/ 7,551.00 S/ 377.55 S/ 7,173.45
Pedro Espichan Rosas S/ 6,941.00 S/ 347.05 S/ 6,593.95
Jaime Ismael Echevarria Rosas S/ 3,895.00 S/ 194.75 S/ 3,700.25
Ruben Dario Diaz Ruiz S/ 4,621.00 S/ 231.05 S/ 4,389.95
Leonel Diaz Sagastiegui S/ 7,446.00 S/ 372.30 S/ 7,073.70
Manuel Vicente Dedios Sanchez S/ 5,035.00 S/ 251.75 S/ 4,783.25
Jorge Luis Davalos Sandoval S/ 6,158.00 S/ 307.90 S/ 5,850.10
Jose Wagner Cuentas Santillan S/ 2,474.00 S/ 123.70 S/ 2,350.30
Luisa Veronika Margaret Cuellar Saona S/ 6,727.00 S/ 336.35 S/ 6,390.65
Lucy Amparo Cucho Saravia S/ 5,619.00 S/ 280.95 S/ 5,338.05
Luis Enrique Cuadros Sihuas S/ 7,412.00 S/ 370.60 S/ 7,041.40
Flor De Maria Conde Sota S/ 5,875.00 S/ 293.75 S/ 5,581.25
Johan Arturo Collins Tacuche S/ 4,061.00 S/ 203.05 S/ 3,857.95
Jackeline Choque Talledo S/ 4,516.00 S/ 225.80 S/ 4,290.20
Fernando Chong Ticona S/ 4,952.00 S/ 247.60 S/ 4,704.40
Lidia Patricia Chenda Tineo S/ 4,014.00 S/ 200.70 S/ 3,813.30
Graciela Emilia Chavez Torres S/ 5,131.00 S/ 256.55 S/ 4,874.45
Eloy Enrique Chavez Torres S/ 6,015.00 S/ 300.75 S/ 5,714.25
Carlos Alberto Chavez Tuchia S/ 6,390.00 S/ 319.50 S/ 6,070.50
Paola Chavez Ulfe S/ 2,794.00 S/ 139.70 S/ 2,654.30
Sabina Chavez Urbina S/ 2,802.00 S/ 140.10 S/ 2,661.90
Jorge Jesus Cevallos Urribarri S/ 2,556.00 S/ 127.80 S/ 2,428.20
Lisset Cebrian Valdivia S/ 4,944.00 S/ 247.20 S/ 4,696.80
Hector Ignacio Cavalcanti Valdivia S/ 6,525.00 S/ 326.25 S/ 6,198.75
Roberto Josue Castro Vargas S/ 6,976.00 S/ 348.80 S/ 6,627.20
Jessica Castro Vargas S/ 7,370.00 S/ 368.50 S/ 7,001.50
Roy David Castillo Vargas S/ 4,977.00 S/ 248.85 S/ 4,728.15
Li Castañeda Vasquez S/ 7,798.00 S/ 389.90 S/ 7,408.10
Carlos Carpio Vasquez S/ 6,500.00 S/ 325.00 S/ 6,175.00
Alexis Cano Vega S/ 6,734.00 S/ 336.70 S/ 6,397.30
Sofia Candela Ventura S/ 5,939.00 S/ 296.95 S/ 5,642.05
Javier Antonio Campos Vergaray S/ 6,485.00 S/ 324.25 S/ 6,160.75
Diana Cabrera Vidal S/ 3,988.00 S/ 199.40 S/ 3,788.60
Iliana Bustios Villafane S/ 4,406.00 S/ 220.30 S/ 4,185.70
Yetmany Bonifacio Villafuertes S/ 4,744.00 S/ 237.20 S/ 4,506.80
Jose Biminchumo Villena S/ 3,456.00 S/ 172.80 S/ 3,283.20
Ysabel Marlene Benites Vizcarra S/ 5,650.00 S/ 282.50 S/ 5,367.50
Carmen Domenica Beltran Wong S/ 5,252.00 S/ 262.60 S/ 4,989.40
Natividad Becerra Yanqui S/ 4,986.00 S/ 249.30 S/ 4,736.70
Claudia Barrantes Yparre S/ 7,722.00 S/ 386.10 S/ 7,335.90
Katty Arevalo Zamora S/ 3,396.00 S/ 169.80 S/ 3,226.20
Humberto Ricardo Angles Zarate S/ 5,783.00 S/ 289.15 S/ 5,493.85
Jose Alave Zavaleta S/ 4,223.00 S/ 211.15 S/ 4,011.85
Omar Agurto Zevallos S/ 3,558.00 S/ 177.90 S/ 3,380.10
Jorge Aguirre Zuñiga S/ 2,403.00 S/ 120.15 S/ 2,282.85
 Crecimiento anual de los ingresos 8.65%
Crecimiento anual de los gastos 3.75%
Indice de Precios al Consumidor 2.33%

Año 1 Año 2 Año 3 Año 4 Año 5

Ingresos 987,000.00 1,072,375.50 1,165,135.98 1,265,920.24 1,375,422.34
Gastos 712,000.00 755,289.60 801,211.21 849,924.85 901,600.28
Utilidad bruta 275,000.00 317,085.90 363,924.77 415,995.39 473,822.06
Utilidad (%) 28% 30% 31% 33% 34%

Escenarios
Celdas
cambiantes
Valores actuales Moderado Pesimista Optimista Crear un reporte de es
Las celdas cambiantes
G3 8.65% 10.0% 6.50% 12.5%
G4 3.75% 4.2% 2.5% 4.4%
G5 2.33% 2.5% 1.8% 2.6%
C9 987,000 1,000,000 950,000 1,100,000
C10 712,000 750,000 800,000 700,000

Celdas de Resultado: C12:G12

rear un reporte de escenarios con los datos de los escenarios de la tabla Escenarios
as celdas cambiantes son G3, G4, G5, C9 y C10.
 Números Longitud de
Números enteros Lista 1 Lista 2 Fecha Hora
decimales texto
 Ciudades

Lima
Trujillo - En la columna A se pueden ingresar solo números
Chiclayo enteros entre 150 y 550.
Piura - En la columna B se pueden ingresar solo números
Tumbes enteros o decimales mayores a 1,000.
- En la columna C se pueden ingresar solo las ciudades
Arequipa que se encuentran en el rango J2:J9
Moquegua - En la columna D se pueden ingresar solo las siguientes
Tacna profesiones: Administrador, Contador, Ingeniero,
Abogado o Vendedor.
- En la columna E se pueden ingresar fechas
correspondientes al año 2020.
- En la columna F se pueden ingresar solo horas entre las
7:00 y las 17:30
- En la columna G se pueden ingresar palabras con 3 a 6
caracteres.
 RECORD DE VENTAS 2020
N° Código Apellido Nombre Sucursal F. Ingreso Ventas realizadas
1 ADEYR04 Ada Beakley Arequipa 4/30/2020 S/ 35,426
2 ADAMH08 Ada Kilham Chiclayo 8/24/2019 S/ 64,713
3 AGLLI07 Aguilera Russell Piura 7/15/2020 S/ 18,501
4 AGEYI01 Aguilera Bailey Lima 1/22/2019 S/ 27,754
5 AKRSI01 Akeman Rogers Piura 1/29/2019 S/ 58,287
6 ALONI12 Alarcón Garrison Piura 12/22/2020 S/ 37,737
7 ALELI01 Alden Isabel Lima 1/22/2020 S/ 93,308
8 ALONI03 Alexander Hansson Lima 3/1/2019 S/ 94,847
9 ALONI10 Alfort Johansson Lima 10/31/2020 S/ 11,513
10 ALRDR03 Alfort Sandford Arequipa 3/5/2019 S/ 32,645
11 ALRDI03 Alice Hazard Piura 3/5/2019 S/ 34,265
12 ALEYR12 Allan Blaney Arequipa 12/2/2020 S/ 43,247
13 ALZAH07 Almeida Souza Chiclayo 7/26/2019 S/ 20,726
14 ALTEH12 Alsop Foote Chiclayo 12/26/2020 S/ 57,041
15 ALEYR05 Alvarado Ockley Arequipa 5/22/2020 S/ 14,020
16 ALFFR02 Alvarado Cliff Trujillo 2/13/2020 S/ 20,417
17 ALERH10 Alvarado Baker Chiclayo 10/15/2019 S/ 19,811
18 ALESH07 Alverston Gonçalves Chiclayo 7/7/2020 S/ 19,644
19 ALAMR07 Alverton Ingham Arequipa 7/24/2020 S/ 65,558
20 ALTER04 Alves Poblete Trujillo 4/6/2019 S/ 63,957
21 ALLLI11 Alves Crosswell Lima 11/12/2020 S/ 87,433
22 ALRRI03 Alvin Kerr Lima 3/30/2020 S/ 83,770
23 ANEYI07 Andarton Ouseley Piura 7/18/2019 S/ 23,631
24 ANCEH09 Andersen Nance Chiclayo 9/20/2020 S/ 82,265
25 ANENR03 Andersson Rodden Arequipa 3/22/2020 S/ 86,402
26 ANASH05 Annan Farías Chiclayo 5/20/2019 S/ 75,447
27 APOXH06 Appleby Cox Chiclayo 6/26/2019 S/ 94,779
28 ARSTR03 Aravena Amherst Arequipa 3/14/2019 S/ 28,643
29 ARAMR01 Armitage Kilham Arequipa 1/6/2020 S/ 31,982
30 ARAYI06 Armitage Fay Piura 6/30/2019 S/ 60,261
31 ASTII06 Ashburton Conti Lima 6/18/2020 S/ 37,157
32 ASAMI03 Ashley Bingham Piura 3/19/2019 S/ 96,353
33 ASOWI06 Astley Glasgow Piura 6/24/2019 S/ 37,622
34 ATLER10 Atherton Mansle Trujillo 10/10/2019 S/ 25,400
35 ATONI09 Athill Felton Piura 9/24/2019 S/ 83,625
36 AUBYR09 Audley Grimsby Trujillo 9/3/2020 S/ 67,062
37 AYONI11 Ayres Hatton Piura 11/7/2020 S/ 63,463
38 BAEYR12 Bagley Ouseley Arequipa 12/11/2020 S/ 61,066
39 BAUSH09 Bagley Adolphus Chiclayo 9/2/2019 S/ 30,579
40 BAONR02 Bailey Burton Trujillo 2/3/2019 S/ 13,595
41 BAERI08 Balcombe Gauthier Lima 8/28/2020 S/ 89,244
42 BAFFI04 Ballantine Cliff Piura 4/22/2019 S/ 31,300
43 BARSR10 Ballantine Rynders Arequipa 10/18/2019 S/ 22,971
44 BAUSH10 Ballantyne Adolphus Chiclayo 10/24/2019 S/ 13,275
45 BAONI02 Bancroft Milton Lima 2/1/2020 S/ 19,442
46 BAAMI01 Barnard Adlam Lima 1/17/2019 S/ 76,361
47 BAEYH06 Barnes Polley Chiclayo 6/13/2020 S/ 28,772
48 BAENR01 Barnum Jacobsen Trujillo 1/3/2020 S/ 85,266
49 BANDI07 Barros Sunderland Piura 7/15/2020 S/ 38,012
50 BADOI01 Barrow Alvarado Piura 1/6/2020 S/ 67,705
51 BAONH01 Barry Petersson Chiclayo 1/29/2019 S/ 59,011
52 BAERR04 Barton Lester Trujillo 4/28/2019 S/ 33,564
53 BARAH06 Barwick Aguilera Chiclayo 6/11/2019 S/ 29,378
54 BAEZR02 Bathurst Fernández Trujillo 2/24/2019 S/ 71,482
55 BELLH01 Beakley Kendall Chiclayo 1/25/2019 S/ 94,615
56 BERDI08 Beal Richard Piura 8/30/2019 S/ 60,720
57 BERAI11 Beckett Jara Piura 11/22/2019 S/ 64,527
58 BELYH08 Beckwith D'Oily Chiclayo 8/28/2020 S/ 80,929
59 BEERR12 Beckwith Fisher Arequipa 12/5/2019 S/ 39,616
60 BEREI06 Bedford Moore Lima 6/3/2019 S/ 90,127
61 BEEEI02 Beers Eberlee Lima 2/12/2019 S/ 77,327
62 BERNH09 Belden Cobern Chiclayo 9/5/2020 S/ 70,156
63 BERNR01 Belden Severn Trujillo 1/28/2020 S/ 28,694
64 BEESR05 Bellamy Fernandes Trujillo 5/19/2020 S/ 96,485
65 BEEYI09 Bengtsson Carey Piura 9/23/2019 S/ 47,808
66 BEINI01 Bentley Martin Lima 1/23/2020 S/ 97,346
67 BEBER05 Bernard Edgecumbe Arequipa 5/3/2019 S/ 80,418
68 BEENI05 Berwick Pedersen Lima 5/6/2020 S/ 94,076
69 BELLI09 Berwick Pickersgill Piura 9/30/2019 S/ 23,626
70 BEEYR10 Bethune Chadsey Trujillo 10/26/2020 S/ 92,511
71 BEONR07 Beveridge Ferguson Arequipa 7/25/2020 S/ 99,527
72 BEONR10 Beverly Stoughton Trujillo 10/5/2019 S/ 40,486
73 BIOWH04 Biggar Barstow Chiclayo 4/23/2020 S/ 25,032
74 BISER11 Binney Rheese Arequipa 11/4/2020 S/ 19,366
75 BIWEH08 Birch Rowe Chiclayo 8/5/2019 S/ 26,924
76 BIENI12 Birch Pedersen Piura 12/3/2020 S/ 79,729
77 BIONR06 Birney Ferguson Arequipa 6/15/2020 S/ 22,533
78 BIESR06 Birney Thwaytes Arequipa 6/16/2019 S/ 48,233
79 BLNER10 Black Bowne Trujillo 10/11/2019 S/ 87,619
80 BLUER09 Blackwood Rue Arequipa 9/25/2019 S/ 17,271
81 BLONI02 Bloss Gustavsson Lima 2/16/2019 S/ 58,290
82 BLRDH12 Bloss Hungerford Chiclayo 12/8/2020 S/ 34,436
83 BOSTH11 Bodley Hurst Chiclayo 11/27/2020 S/ 91,220
84 BOEZR11 Bolingbroke Fernández Trujillo 11/13/2020 S/ 16,683
85 BOANI02 Borland Ryan Lima 2/20/2019 S/ 15,939
86 BOONI04 Bowne Dinton Lima 4/14/2019 S/ 12,407
87 BRRYH05 Brandon Perry Chiclayo 5/13/2020 S/ 47,700
88 BRNER05 Breck Bowne Trujillo 5/12/2019 S/ 56,119
 89 BRADR09 Breck Halstead Arequipa 9/4/2020 S/ 70,474
90 BRZOI02 Breckenridge Rizzo Piura 2/13/2020 S/ 96,514
91 BRRTR11 Breckenridge Lamport Arequipa 11/7/2020 S/ 41,732
92 BRANI01 Breckenridge Akeman Lima 1/15/2019 S/ 70,789
93 BRODR09 Brenin Blackwood Arequipa 9/12/2019 S/ 61,139
94 BRRDR04 Brenin Crawford Trujillo 4/8/2019 S/ 17,146
95 BRERR09 Brenin Dolbeer Arequipa 9/20/2019 S/ 28,889
96 BRAYH08 Brentwood Clay Chiclayo 8/21/2020 S/ 53,282
97 BRCEI10 Brienne Price Piura 10/8/2020 S/ 30,081
98 BRINH07 Brighton Corwin Chiclayo 7/23/2020 S/ 37,575
99 BRRAH01 Brighton Herrera Chiclayo 1/17/2019 S/ 68,359
100 BRTEH04 Bristed Navarrete Chiclayo 4/14/2020 S/ 37,419
101 BRROR12 Bristow Ribeiro Arequipa 12/28/2020 S/ 55,835
102 BRESR07 Bristow Gonçalves Trujillo 7/17/2019 S/ 26,859
103 BRLNI04 Brocklesby Lincoln Piura 4/7/2020 S/ 98,120
104 BRRER04 Brodt Eure Trujillo 4/27/2020 S/ 17,525
105 BROTI12 Bromfield Lippencot Lima 12/19/2019 S/ 29,326
106 BRBYR03 Broughton Brocklesby Trujillo 3/31/2019 S/ 93,904
107 BROWI04 Broughton Barstow Lima 4/5/2020 S/ 34,863
108 BRONR12 Broughton Brighton Arequipa 12/20/2019 S/ 68,812
109 BRASR11 Bryne Contreras Trujillo 11/10/2020 S/ 63,288
110 BRROR05 Bryne Guerrero Trujillo 5/5/2020 S/ 75,264
111 BRNER06 Bryne Kilburne Trujillo 6/28/2019 S/ 72,242
112 BULER11 Buchan Poole Arequipa 11/16/2019 S/ 69,410
113 BUADI07 Buckminster Halstead Piura 7/27/2020 S/ 34,070
114 BUNOR02 Burbeck Marino Arequipa 2/10/2020 S/ 15,411
115 BURDI06 Burgoyne Giffard Lima 6/10/2020 S/ 34,348
116 BUERI03 Burr Buckminster Lima 3/22/2020 S/ 56,409
117 BUESI05 Burrard Cáceres Piura 5/26/2019 S/ 84,285
118 BUNDR05 Bushwell Sunderland Trujillo 5/2/2019 S/ 39,142
119 BUEYI10 Bustamante Bromley Lima 10/26/2020 S/ 88,224
120 CAESI05 Cadwell Olivares Piura 5/19/2019 S/ 29,232
121 CAONR09 Caldwell Gustavsson Trujillo 9/2/2019 S/ 61,222
122 CANGI06 Canning Irving Lima 6/28/2019 S/ 53,854
123 CÁLYH03 Cárdenas O'Reilly Chiclayo 3/2/2019 S/ 12,865
124 CÁONH02 Cárdenas Sutton Chiclayo 2/2/2019 S/ 50,712
125 CANER06 Cardoso Mayne Arequipa 6/15/2020 S/ 54,421
126 CAENR09 Carmichael Nilsen Trujillo 9/9/2020 S/ 37,109
127 CAOWR11 Carrasco Onslow Arequipa 11/29/2020 S/ 34,556
128 CABYR03 Carwin Derby Trujillo 3/2/2020 S/ 68,018
129 CALIR07 Cary Ali Arequipa 7/3/2019 S/ 50,494
130 CAONI11 Castillo Byington Piura 11/6/2019 S/ 84,961
131 CAGHR03 Caw Hough Trujillo 3/15/2020 S/ 74,319
132 CARTH08 Caxton Harcourt Chiclayo 8/10/2019 S/ 56,980
133 CAPYI01 Caxton Sheppy Lima 1/29/2020 S/ 27,661
134 CATAH10 Cayly Costa Chiclayo 10/28/2019 S/ 69,559
135 CHCKR07 Chadsey Paddock Trujillo 7/6/2019 S/ 56,139
136 CHRDH02 Chan McHard Chiclayo 2/12/2020 S/ 66,370
137 CHEZR01 Channing Gutiérrez Arequipa 1/12/2019 S/ 20,115
138 CHONI09 Channing Jonsson Piura 9/3/2020 S/ 91,204
139 CHNGI05 Chatham Long Piura 5/30/2019 S/ 92,199
140 CHEER03 Chatham Buckbee Arequipa 3/23/2019 S/ 33,567
141 CHGEI05 Chatsworth Eytinge Piura 5/8/2020 S/ 58,682
142 CHAYR06 Chilton Courtenay Arequipa 6/26/2019 S/ 33,917
143 CLONR05 Clarke Hansson Trujillo 5/10/2020 S/ 16,346
144 CLLDR03 Clarke Hatfield Trujillo 3/7/2019 S/ 68,318
145 CLAMR11 Clauson Brougham Trujillo 11/23/2019 S/ 26,344
146 CLESI11 Cliff Gonçalves Piura 11/6/2019 S/ 65,600
147 CLEDI08 Cliff Alfred Piura 8/25/2020 S/ 13,883
148 CLINI09 Cliff Rollin Piura 9/25/2020 S/ 68,691
149 CLONI06 Clifton Plympton Piura 6/25/2020 S/ 77,428
150 CLONI12 Clowes Seton Piura 12/10/2020 S/ 66,769
151 CLESR03 Clum Ayres Arequipa 3/30/2019 S/ 91,235
152 CODEI07 Cochran De Piura 7/2/2019 S/ 16,179
153 COELR11 Cogswell Isabel Trujillo 11/23/2019 S/ 87,560
154 COENR11 Colby Nguyen Arequipa 11/25/2020 S/ 37,761
155 COONI02 Colvin Seaton Piura 2/17/2020 S/ 23,497
156 COONH05 Contin Hansson Chiclayo 5/12/2020 S/ 90,302
157 COERI11 Contin Lancaster Lima 11/3/2020 S/ 56,627
158 COOWR06 Contreras Barstow Arequipa 6/17/2020 S/ 19,735
159 COTER08 Corbin Shute Arequipa 8/9/2020 S/ 63,508
160 COORR03 Corbin Dinsmor Arequipa 3/3/2019 S/ 14,292
161 COEDR08 Costa Reed Arequipa 8/13/2020 S/ 13,502
162 COERR01 Costa Challoner Trujillo 1/21/2020 S/ 16,949
163 COONI01 Cotesworth Davidson Piura 1/17/2020 S/ 35,779
164 COSSI06 Courtenay Cross Piura 6/22/2020 S/ 68,517
165 CORDR01 Cox Godard Arequipa 1/9/2019 S/ 68,489
166 CRETI02 Crayford Ouellet Lima 2/23/2020 S/ 48,845
167 CRIZI12 Crittenden Ortiz Lima 12/3/2020 S/ 86,033
168 CRAMH09 Crittenden Cunningham Chiclayo 9/18/2020 S/ 54,948
169 CRTII08 Cross Conti Piura 8/4/2020 S/ 49,828
170 CUONI09 Cummings Denton Lima 9/6/2020 S/ 47,939
171 CUANI07 Cupar Khan Lima 7/12/2019 S/ 95,848
172 CUEZR11 Cupar Martínez Arequipa 11/28/2019 S/ 40,621
173 DARTI07 Daggett Robert Piura 7/21/2020 S/ 25,362
174 DAGEI01 Daggett Rusbridge Piura 1/15/2019 S/ 61,308
175 DAONI08 Dalton Sheldon Piura 8/27/2019 S/ 96,305
176 DAENI02 Davidson Hansen Piura 2/19/2020 S/ 50,809
177 DEENH12 De Hansen Chiclayo 12/29/2019 S/ 77,656
178 DERDI06 Denton Bernard Piura 6/7/2020 S/ 27,491
179 DEONR09 Denton Chatterton Arequipa 9/24/2020 S/ 20,473
180 DEEYI05 Dering Peney Lima 5/3/2019 S/ 48,194
181 DEFTH01 Dering Bancroft Chiclayo 1/15/2020 S/ 55,963
182 DEESR11 Devenish Rhodes Arequipa 11/11/2020 S/ 49,973
183 DEONH05 Devenish Jakobsson Chiclayo 5/26/2020 S/ 10,158
184 DEEYR12 Devlin Huntley Arequipa 12/23/2019 S/ 93,730
185 DÍSEI01 Díaz Rheese Piura 1/15/2019 S/ 39,570
186 DÍRDI12 Díaz Orchard Piura 12/25/2019 S/ 35,408
187 DINGR12 Digby King Trujillo 12/10/2019 S/ 69,195
188 DIERI02 Dinsmor Turner Lima 2/1/2020 S/ 33,207
189 DIRSI07 Dinsmor Conyers Piura 7/30/2020 S/ 82,905
190 DICKR01 Dinton Paddock Arequipa 1/30/2020 S/ 75,875
191 DIOWH12 Dinton Bristow Chiclayo 12/22/2019 S/ 95,015
192 DIPHR11 Dinton Randolph Arequipa 11/21/2019 S/ 72,470
193 D'ENH10 D'Oily Hansen Chiclayo 10/3/2019 S/ 84,863
194 DOENH10 Dolbeer Ramsden Chiclayo 10/1/2019 S/ 98,152
195 DOONH01 Dorset Jansson Chiclayo 1/18/2019 S/ 83,329
196 DOINI07 Doyle Keigwin Lima 7/27/2019 S/ 32,058
197 DOONR07 Doyle Pettersson Arequipa 7/18/2020 S/ 98,403
198 DUONI08 Dudley Gihon Piura 8/9/2019 S/ 84,190
199 DUNOR03 Dunbar Moreno Arequipa 3/16/2019 S/ 31,223
200 DUINH11 Dunham Corbin Chiclayo 11/2/2019 S/ 91,804
201 DURAI12 Dunipace Pereira Lima 12/7/2020 S/ 79,045
202 DUIEI03 Dunipace Ogilvie Lima 3/3/2020 S/ 81,611
203 DUONH02 Dunlevy Eton Chiclayo 2/22/2019 S/ 52,968
204 DURNR11 Dunlevy Osborn Arequipa 11/22/2019 S/ 68,228
205 DUANI11 Dunstan Duncan Piura 11/18/2019 S/ 92,428
206 DUIRH08 Durban Playfair Chiclayo 8/9/2019 S/ 75,818
207 DUELR03 Durham Shiel Trujillo 3/12/2019 S/ 47,651
208 EACHR07 Eaton Kinloch Trujillo 7/7/2020 S/ 24,756
209 EAÍNR03 Eaton San Martín Trujillo 3/9/2019 S/ 91,246
210 EDADR05 Edgecumbe Read Trujillo 5/11/2019 S/ 44,518
211 EDUNR05 Edgecumbe Dun Arequipa 5/22/2020 S/ 34,954
212 EDSEI05 Edith Rheese Piura 5/23/2019 S/ 93,152
213 EGETI03 Eggleston Dorset Piura 3/23/2020 S/ 32,517
214 ELURR01 Ely Arthur Arequipa 1/15/2020 S/ 79,425
215 EMLLI06 Emerson Ewell Lima 6/27/2019 S/ 93,776
216 ESOXR08 Espinoza Knox Trujillo 8/21/2020 S/ 69,792
217 ESLLR11 Espinoza Hall Trujillo 11/1/2020 S/ 90,997
218 ESEYI09 Espinoza Ripley Lima 9/5/2020 S/ 79,351
219 EUTER12 Eure Eastcote Trujillo 12/20/2020 S/ 81,474
220 EVONH04 Everard Clauson Chiclayo 4/8/2019 S/ 66,117
221 FACKR03 Fales Black Arequipa 3/14/2019 S/ 38,572
222 FAERR12 Falkland Butler Arequipa 12/13/2020 S/ 22,044
223 FAUZR06 Falkland Cruz Trujillo 6/15/2019 S/ 46,044
224 FACER02 Fanshaw Alice Trujillo 2/4/2020 S/ 20,283
225 FALER01 Farnham Lonsdale Arequipa 1/7/2020 S/ 48,184
226 FANTH08 Farnham Pennant Chiclayo 8/22/2020 S/ 20,831
227 FEINH07 Ferguson Corbin Chiclayo 7/7/2019 S/ 44,914
228 FEENR09 Fernandes Andreassen Arequipa 9/29/2019 S/ 48,184
229 FEESI12 Fernandes Cáceres Lima 12/18/2019 S/ 65,111
230 FERDR05 Ferrari Rutherford Arequipa 5/14/2019 S/ 66,798
231 FEERR08 Ferreira Gallagher Trujillo 8/30/2020 S/ 93,792
232 FEEZI10 Ferrers Sáez Piura 10/15/2020 S/ 75,936
233 FITER01 Fife Navarrete Arequipa 1/15/2019 S/ 68,210
234 FIANI08 Fifield Ackman Lima 8/6/2019 S/ 45,525
235 FIOWR09 Fifield Bristow Arequipa 9/29/2020 S/ 59,444
236 FIARR01 Fifield Escobar Arequipa 1/10/2019 S/ 60,969
237 FIROI03 Figueroa Castro Piura 3/18/2019 S/ 65,824
238 FIONH04 Figueroa Rawdon Chiclayo 4/12/2020 S/ 79,109
239 FIGHI01 Filley Harleigh Lima 1/13/2020 S/ 25,722
240 FLARI03 Fleming Biggar Piura 3/14/2019 S/ 45,405
241 FLLLH03 Fleming Hubbell Chiclayo 3/25/2019 S/ 41,938
242 FLERI11 Flores Buckminster Lima 11/7/2019 S/ 64,109
243 FOARR10 Foote Bonar Trujillo 10/10/2019 S/ 36,088
244 FOOTR06 Foote Arbuthnot Trujillo 6/5/2019 S/ 28,852
245 FOEYI09 Forbes Filey Piura 9/30/2020 S/ 76,304
246 FOASH11 Fosdyke Salinas Chiclayo 11/18/2020 S/ 48,865
247 FONSI05 Fothergill Hoskins Piura 5/30/2019 S/ 76,100
248 FOAFI06 Fotheringham Medcaf Piura 6/10/2019 S/ 95,124
249 FRESR01 Fremont Alves Arequipa 1/14/2019 S/ 90,360
250 FROZI09 Fry Muñoz Piura 9/2/2019 S/ 42,466
251 FRESH02 Fry Reyes Chiclayo 2/10/2019 S/ 31,864
252 FURNH04 Fuentes Colburn Chiclayo 4/14/2019 S/ 55,691
253 FUNDR01 Fulham Holland Trujillo 1/8/2020 S/ 64,986
254 FULLI04 Fulke Cogswell Piura 4/20/2019 S/ 42,887
255 FUESR01 Fulke Temes Trujillo 1/30/2019 S/ 37,158
256 FUESI01 Fulke Gonçalves Piura 1/2/2019 S/ 19,543
257 FUONH06 Fulsom Buddington Chiclayo 6/14/2020 S/ 28,349
258 GALER11 Gagné Peele Trujillo 11/23/2020 S/ 51,120
259 GAERI06 Gallagher Hunter Piura 6/27/2019 S/ 59,978
260 GAENR04 Gallo Chittenden Arequipa 4/25/2020 S/ 66,283
261 GARDR10 Gano Burrard Trujillo 10/28/2019 S/ 37,178
262 GAIDH07 García Reid Chiclayo 7/18/2019 S/ 81,029
263 GENDI06 Getty Northumberland Piura 6/24/2020 S/ 94,765
264 GIELI04 Giffard Arundel Lima 4/17/2020 S/ 59,507
265 GIENR01 Gihon Andreassen Arequipa 1/14/2019 S/ 58,267
266 GICKR11 Gill Paddock Arequipa 11/4/2020 S/ 37,656
267 GIONR06 Gill Hansson Arequipa 6/1/2020 S/ 81,078
268 GIONI04 Girdwood Eton Piura 4/12/2019 S/ 37,152
269 GLONI06 Gliston Kingston Piura 6/19/2020 S/ 20,636
270 GLGHR11 Gliston Scarborough Arequipa 11/10/2020 S/ 85,057
271 GLONI01 Gloucester Gustavsson Lima 1/15/2020 S/ 16,038
272 GOEZR10 Godolphin Martínez Arequipa 10/24/2019 S/ 80,688
273 GORSR04 Gollah Sears Arequipa 4/1/2019 S/ 90,365
274 GOENR09 Gomes Ogden Trujillo 9/13/2019 S/ 71,341
275 GÓRYR10 Gómez Cary Arequipa 10/20/2020 S/ 35,478
276 GOONH04 Gonçalves Simpson Chiclayo 4/26/2020 S/ 71,840
277 GRNEH07 Graham Bryne Chiclayo 7/1/2020 S/ 95,255
278 GRROI05 Grant Castro Piura 5/31/2019 S/ 17,305
279 GRRER04 Grant Lechmere Trujillo 4/7/2020 S/ 73,740
280 GRENR12 Grasse Durden Trujillo 12/21/2019 S/ 53,865
281 GRLNR05 Gray Lincoln Arequipa 5/24/2019 S/ 39,534
282 GRCYI11 Gray Piercy Lima 11/6/2020 S/ 55,542
283 GRLLI04 Gray Pickersgill Lima 4/24/2019 S/ 33,922
284 GRNOI09 Greco Romanno Lima 9/18/2020 S/ 50,799
285 GRAYR08 Griffith Kay Trujillo 8/2/2019 S/ 64,092
286 GRERH09 Griffith Chichester Chiclayo 9/9/2019 S/ 71,314
287 GUCKR05 Gustavsson Black Arequipa 5/18/2019 S/ 67,043
288 GURYH01 Gustavsson Sarisbury Chiclayo 1/19/2020 S/ 26,022
289 GUNDH10 Guzmán Sigismund Chiclayo 10/24/2020 S/ 45,658
290 HAAMR08 Haineau Buckingham Arequipa 8/2/2019 S/ 96,150
291 HAKSR01 Haineau Brooks Trujillo 1/26/2019 S/ 16,836
292 HAÖMR08 Haineau Lindström Trujillo 8/23/2019 S/ 34,367
293 HATEI05 Haineau Paquette Piura 5/12/2020 S/ 80,951
294 HAEYR01 Halifax Moxley Arequipa 1/7/2019 S/ 94,407
295 HAVAR11 Halstead Leiva Trujillo 11/18/2020 S/ 18,878
296 HAONI11 Hamilton Persson Piura 11/2/2020 S/ 52,526
297 HAETI01 Hamilton Gavet Lima 1/28/2019 S/ 33,478
298 HARDR02 Hamilton Oxford Arequipa 2/8/2019 S/ 95,298
299 HACOI01 Hamlin Carrasco Piura 1/10/2020 S/ 59,036
300 HAUSI05 Harcourt Adolphus Lima 5/20/2019 S/ 78,713
301 HAONR06 Harding Skeffington Trujillo 6/8/2020 S/ 25,509
302 HAPHR09 Hargill Randulph Arequipa 9/15/2020 S/ 96,749
303 HAAYI08 Hargill Courtenay Lima 8/26/2020 S/ 47,412
304 HAONI02 Harley Harrington Lima 2/9/2019 S/ 26,317
305 HAEYI08 Harris Berkeley Lima 8/5/2019 S/ 49,530
306 HAETR02 Harris Dorset Trujillo 2/27/2020 S/ 24,400
307 HAERI12 Hartwell Barringer Lima 12/30/2020 S/ 97,588
308 HAERR03 Hartwell Baker Arequipa 3/8/2020 S/ 77,477
309 HANDR02 Hathaway Roland Arequipa 2/15/2020 S/ 39,122
310 HANSR05 Hatton Haskins Trujillo 5/22/2019 S/ 70,317
311 HAERI04 Hatton Gauthier Lima 4/12/2020 S/ 53,149
312 HAENI01 Haugen Larsen Piura 1/9/2020 S/ 77,078
313 HAHAR05 Haydyn Rocha Arequipa 5/20/2020 S/ 83,822
314 HAONH11 Haydyn Heaton Chiclayo 11/7/2020 S/ 43,939
315 HARDR05 Hayman Banvard Trujillo 5/28/2019 S/ 90,843
316 HAELH10 Haynsworth Patel Chiclayo 10/29/2019 S/ 53,010
317 HENSI12 Hedges Collins Piura 12/17/2019 S/ 42,826
318 HETHR04 Hedon Beckwith Arequipa 4/27/2019 S/ 12,599
319 HEONR06 Hedon Buxton Arequipa 6/28/2020 S/ 70,061
320 HEAYH06 Henderson Fay Chiclayo 6/3/2020 S/ 69,684
321 HEOTR04 Henley Arbuthnot Arequipa 4/1/2019 S/ 67,996
322 HEENI05 Henríquez Haugen Piura 5/9/2019 S/ 84,950
323 HEBYR04 Herbert Digby Trujillo 4/20/2020 S/ 94,027
324 HERSR06 Herman Ackers Trujillo 6/29/2019 S/ 81,134
325 HEAWR08 Hernández Caw Arequipa 8/28/2019 S/ 80,665
326 HIESR03 Hindon Flores Trujillo 3/17/2020 S/ 24,476
327 HIONR02 Hindon Peterson Arequipa 2/17/2020 S/ 49,194
328 HIONR01 Hippisley Stretton Trujillo 1/7/2020 S/ 88,536
329 HICYI08 Hippisley Percy Lima 8/23/2020 S/ 33,413
330 HOAMI05 Holbech Durham Piura 5/19/2020 S/ 73,988
331 HOVAR02 Holcombe Silva Trujillo 2/16/2019 S/ 21,230
332 HOLEI04 Holywell Holsapple Lima 4/28/2020 S/ 75,665
333 HOEYI08 Hosford Pressley Lima 8/24/2019 S/ 55,064
334 HOAMR01 Hoskins Fordham Arequipa 1/10/2020 S/ 65,658
335 HOENR01 Hoskins Redden Arequipa 1/25/2020 S/ 41,530
336 HONEI08 Houghton Bowne Piura 8/5/2020 S/ 42,270
337 HONGR02 Houghton Harding Arequipa 2/16/2020 S/ 71,876
338 HOLDR09 Houghton Garfield Trujillo 9/13/2019 S/ 14,002
339 HOINI11 Houston Colvin Lima 11/18/2020 S/ 84,728
340 HUESI12 Huddleston Fernandes Lima 12/21/2019 S/ 77,907
341 HUINH01 Huddleston Stein Chiclayo 1/6/2019 S/ 71,972
342 HUBYI10 Hull Colby Lima 10/1/2019 S/ 76,550
343 HUASI07 Hull Thomas Lima 7/16/2019 S/ 98,681
344 HUANH01 Huntington Allan Chiclayo 1/28/2020 S/ 67,055
345 HUEYI05 Huntington Hippisley Piura 5/18/2020 S/ 34,705
346 HURGR09 Huntley Lindberg Trujillo 9/27/2020 S/ 67,441
347 HUNGH06 Huntley Dering Chiclayo 6/13/2019 S/ 26,665
348 HUEYH04 Hurst Binney Chiclayo 4/12/2020 S/ 93,706
349 INONR06 Ingham Jönsson Arequipa 6/5/2019 S/ 75,667
350 INANH11 Ingoldsby Trevelyan Chiclayo 11/3/2019 S/ 18,326
351 IREYI09 Ireton Ramsey Lima 9/20/2019 S/ 15,916
352 IRESI01 Irving Fales Piura 1/19/2019 S/ 52,814
353 IRADI02 Irving Olmstead Lima 2/29/2020 S/ 96,398
354 ISTTR11 Islip Moffatt Arequipa 11/29/2020 S/ 45,544
355 IVESI02 Ives Gonçalves Piura 2/17/2019 S/ 37,737
356 JAEYI12 Jackson Chatsey Lima 12/16/2019 S/ 93,848
357 JELER09 Jensen Rowle Arequipa 9/3/2019 S/ 92,691
358 JOSSR11 Johnsen Cross Arequipa 11/17/2020 S/ 52,983
359 JOAYR08 Johnson Courtenay Trujillo 8/2/2019 S/ 18,285
360 JOONR06 Johnson Andarton Trujillo 6/1/2019 S/ 83,918
361 JORDI03 Jonsson Barnard Piura 3/20/2019 S/ 21,576
362 JODER12 Jonsson Slade Trujillo 12/10/2020 S/ 45,849
363 JÖRAI05 Jönsson Rivera Piura 5/21/2019 S/ 67,628
364 KETER06 Kelly Northcote Arequipa 6/26/2020 S/ 47,006
365 KELLI09 Kendall Bell Piura 9/7/2020 S/ 61,535
366 KEENR02 Kennicot Chittenden Trujillo 2/22/2019 S/ 87,020
367 KENOH02 Kent Giordano Chiclayo 2/26/2020 S/ 35,403
368 KEEYR07 Kerr Chedsey Trujillo 7/15/2020 S/ 92,363
369 KESOR07 Kerr Russo Trujillo 7/18/2020 S/ 80,419
370 KINGI02 Kilburne King Lima 2/8/2020 S/ 92,900
371 KIRDI11 Kilham Edward Lima 11/8/2020 S/ 18,375
372 KIANI06 Kinghorn Morgan Piura 6/10/2020 S/ 45,204
373 KILLI02 Kingston Bunnell Lima 2/15/2020 S/ 60,535
374 KIEZR06 Kirkaldy Álvarez Trujillo 6/9/2019 S/ 81,724
375 KIRTI12 Kirkpatrick Alfort Lima 12/12/2019 S/ 46,536
376 KNNGI07 Knox Cutting Piura 7/21/2020 S/ 76,161
377 KYENR02 Kyle Karlsen Trujillo 2/4/2019 S/ 79,156
378 LAESI12 Landon Morales Piura 12/9/2020 S/ 57,637
379 LAHYI01 Langton McCarthy Piura 1/1/2019 S/ 83,686
380 LAORI04 Lavoie Dinsmor Lima 4/9/2020 S/ 38,474
381 LEONR06 Lechmere Clifton Arequipa 6/8/2019 S/ 96,464
382 LEDER01 Lee Hyde Trujillo 1/27/2019 S/ 23,174
383 LEOSR07 Leiva Bustos Trujillo 7/11/2020 S/ 11,982
384 LENEI12 Leiva Elphinstone Lima 12/19/2020 S/ 23,940
385 LEONR09 Leland Buckston Arequipa 9/4/2019 S/ 81,511
386 LÉAMR05 Lévesque Durham Arequipa 5/22/2020 S/ 90,137
387 LEIER01 Lewes Lavoie Arequipa 1/30/2019 S/ 91,658
388 LELDH02 Lewknor Bromfield Chiclayo 2/19/2019 S/ 65,965
389 LEOZR06 Leycester Muñoz Trujillo 6/18/2019 S/ 98,331
390 LIEYR10 Li Ripley Arequipa 10/26/2019 S/ 85,883
391 LIUEI08 Lincoln Rue Lima 8/7/2019 S/ 88,085
392 LIEZI04 Lindgren Gómez Piura 4/11/2020 S/ 21,075
393 LIONR05 Lindsay Goon Trujillo 5/14/2020 S/ 93,022
394 LIONR06 Lindsay Teddington Trujillo 6/21/2020 S/ 41,764
395 LIFFH10 Linne Radcliff Chiclayo 10/1/2020 S/ 76,898
396 LIERR11 Linton Otter Trujillo 11/21/2019 S/ 45,969
397 LIRAR06 Linton Herrera Trujillo 6/15/2019 S/ 64,027
398 LINTR07 Livingstone Kent Trujillo 7/14/2020 S/ 82,627
399 LOGER09 Lonsdale Armitage Arequipa 9/21/2020 S/ 37,178
400 LOERR09 Lonsdale Chichester Trujillo 9/3/2020 S/ 48,137
401 LÓBYH05 López Ingoldsby Chiclayo 5/24/2019 S/ 12,873
402 LÓNER10 López Brienne Arequipa 10/10/2019 S/ 83,874
403 LÓEYI01 López Filey Lima 1/30/2019 S/ 74,393
404 LUONR06 Ludlow Pendleton Arequipa 6/6/2020 S/ 68,159
405 MAISR02 Maldonado Paris Arequipa 2/17/2020 S/ 43,664
406 MAINR03 Maldonado Coffin Arequipa 3/31/2019 S/ 12,186
407 MATHI02 Maldonado Cotesworth Lima 2/29/2020 S/ 68,652
408 MADAH01 Maldonado Almeida Chiclayo 1/2/2019 S/ 67,325
409 MAEYI03 Mansfield Beakley Lima 3/20/2020 S/ 76,496
410 MARYI05 Mansle Cary Lima 5/22/2019 S/ 59,056
411 MAEYR08 Mansle Audley Trujillo 8/8/2020 S/ 75,998
412 MAHII03 Mar Bianchi Lima 3/26/2019 S/ 20,199
413 MAISR05 Marchi Morris Arequipa 5/22/2020 S/ 85,332
414 MAEEI01 Marchi Saterlee Lima 1/10/2019 S/ 89,200
415 MAINI04 Marchi Rollin Lima 4/12/2019 S/ 40,997
416 MACOI11 Marino Carrasco Piura 11/21/2020 S/ 52,601
417 MAODI03 Martin Stanwood Lima 3/19/2019 S/ 45,774
418 MANTH03 Martínez Nogent Chiclayo 3/6/2020 S/ 97,143
419 MARRI07 Mayo Burr Piura 7/24/2019 S/ 75,539
420 MAROI09 Mayo Castro Lima 9/9/2019 S/ 52,429
421 MCISI04 McCarthy Artois Lima 4/8/2020 S/ 31,962
422 MCINI11 McCarthy Carwin Lima 11/20/2019 S/ 27,001
423 MCINH05 McDonald Swithin Chiclayo 5/27/2020 S/ 35,072
424 MCEYH05 McDonald Harley Chiclayo 5/1/2019 S/ 56,462
425 MCRGI06 McHarg Berg Piura 6/24/2019 S/ 83,650
426 MEPHI12 Medcaf Randulph Piura 12/12/2020 S/ 69,734
427 MERRI03 Medina Burr Lima 3/31/2019 S/ 40,447
428 MENÉI11 Menteth Gagné Piura 11/21/2019 S/ 63,414
429 MEANR05 Menteth McLean Trujillo 5/6/2020 S/ 35,295
430 MEDAI05 Merton Sepúlveda Lima 5/27/2019 S/ 86,682
431 MEPHR05 Merton Randulph Trujillo 5/21/2020 S/ 52,391
432 MIUNR01 Middleditch Dun Trujillo 1/11/2019 S/ 87,125
433 MIUSR04 Middleton Angus Arequipa 4/13/2019 S/ 48,671
434 MIANI12 Middleton Butman Lima 12/15/2020 S/ 52,262
435 MIARI08 Miller Bar Piura 8/25/2019 S/ 55,401
436 MILLH07 Mills Marshall Chiclayo 7/12/2019 S/ 14,244
437 MOICH09 Monroe Theodoric Chiclayo 9/24/2020 S/ 65,974
438 MOLOR10 Monteith Castillo Arequipa 10/31/2019 S/ 98,283
439 MOWNI10 Morales Brown Piura 10/25/2019 S/ 55,446
440 MOERI01 Moray Challoner Piura 1/15/2020 S/ 64,165
441 MOONH01 Moray Houghton Chiclayo 1/22/2020 S/ 14,569
442 MOONH12 Morgan Byington Chiclayo 12/16/2019 S/ 17,967
443 MUNER10 Munsel Ballantine Arequipa 10/26/2019 S/ 35,390
444 MUONR02 Murray Peterson Trujillo 2/19/2019 S/ 80,381
445 NAINH04 Nance Devlin Chiclayo 4/28/2019 S/ 87,507
446 NALLI03 Navarrete Howell Piura 3/28/2020 S/ 79,848
447 NANNR11 Navarrete Linn Arequipa 11/14/2020 S/ 31,104
448 NEOSR10 Needham Santos Arequipa 10/4/2020 S/ 72,179
449 NEDOH05 Nelson Maldonado Chiclayo 5/9/2019 S/ 16,323
450 NEZAR01 Newton Souza Arequipa 1/17/2020 S/ 53,685
451 NGRYH09 Nguyen Coventry Chiclayo 9/26/2019 S/ 62,292
452 NINGH01 Nilsen Goring Chiclayo 1/13/2020 S/ 97,043
453 NINDH09 Nilsson Ackland Chiclayo 9/28/2019 S/ 92,319
454 NOKSH06 Nogent Brooks Chiclayo 6/25/2020 S/ 27,225
455 NOTHI01 Norcutt Hainsworth Lima 1/23/2019 S/ 74,176
456 NOSAI03 Northop Barbosa Piura 3/18/2019 S/ 83,346
457 NOALI01 Northumberland Randal Lima 1/25/2019 S/ 59,140
458 NOTEI11 Norwich Northcote Piura 11/10/2019 S/ 84,107
459 NOONH03 Nottingham Houston Chiclayo 3/9/2020 S/ 78,211
460 NOONI07 Nottingham Jakobsson Lima 7/6/2019 S/ 89,846
461 NÚRNR09 Núñez Pangbourn Arequipa 9/6/2020 S/ 18,617
462 OANOI07 Oakham Giordano Piura 7/28/2019 S/ 73,082
463 O'RYI06 O'Brien Coventry Piura 6/19/2020 S/ 24,022
464 OCUNH12 Ockley Dun Chiclayo 12/11/2019 S/ 74,045
465 O'ANI12 O'Connor Ackerman Piura 12/29/2019 S/ 87,803
466 OLONR07 Olivares Jansson Trujillo 7/15/2019 S/ 93,989
467 OLERI04 Olivares Chichester Piura 4/24/2020 S/ 87,285
468 OLERI07 Ollendorff Lester Piura 7/17/2019 S/ 52,688
469 OLRYR12 Olsen Torry Arequipa 12/3/2020 S/ 87,616
470 OLDER12 Olsen Hyde Trujillo 12/23/2020 S/ 25,879
471 OLAWR09 Olsson Haw Arequipa 9/9/2020 S/ 75,212
472 ORIZR07 Orton Ortiz Arequipa 7/30/2019 S/ 65,658
473 OSHIR10 Osborn Bianchi Arequipa 10/17/2020 S/ 52,863
474 O'INI10 O'Sullivan Stein Piura 10/18/2020 S/ 56,994
475 OSTHI04 Oswald Bath Lima 4/17/2020 S/ 74,873
476 OTRYH03 Otter Newbury Chiclayo 3/30/2019 S/ 44,802
477 OUESH06 Ouellet Thwaytes Chiclayo 6/12/2019 S/ 42,906
478 OUGHI08 Ouseley Legh Lima 8/30/2020 S/ 60,938
479 OXNDH03 Oxford Roland Chiclayo 3/12/2019 S/ 72,337
480 PAONR02 Paquette Boughton Trujillo 2/27/2019 S/ 79,363
481 PALLR01 Paquette Powell Arequipa 1/24/2019 S/ 27,243
482 PAAYR01 Paquette Kay Trujillo 1/28/2020 S/ 61,657
483 PARNR05 Paquette Swinburn Arequipa 5/1/2019 S/ 70,077
484 PADYR09 Parker Kirkaldy Arequipa 9/7/2020 S/ 18,863
485 PAONR10 Parra Orton Arequipa 10/26/2019 S/ 48,284
486 PARTI03 Patel Stewart Lima 3/25/2020 S/ 55,657
487 PEEZI06 Peake Pérez Lima 6/1/2019 S/ 60,990
488 PERDI08 Peake Gifford Piura 8/2/2019 S/ 16,107
489 PEONH02 Pedin Eaton Chiclayo 2/21/2019 S/ 30,478
490 PELER10 Pedin Rowle Trujillo 10/2/2020 S/ 10,576
491 PEPEI04 Pendleton Hope Lima 4/17/2020 S/ 39,308
492 PEONI06 Pennington Davidson Piura 6/14/2019 S/ 34,873
493 PERYR10 Percy Torry Arequipa 10/3/2020 S/ 38,957
494 PEDEI09 Percy Hyde Piura 9/15/2019 S/ 91,852
495 PÉKEH02 Pérez Peake Chiclayo 2/17/2020 S/ 86,370
496 PÉONR11 Pérez Olsson Arequipa 11/19/2020 S/ 73,411
497 PENDR04 Perry Roland Trujillo 4/3/2019 S/ 20,327
498 PEENR04 Pettersson Carden Arequipa 4/29/2019 S/ 87,540
499 PEGER03 Pevensey Rusbridge Trujillo 3/4/2019 S/ 56,432
500 PIRFI10 Pickering Allendorf Lima 10/18/2019 S/ 16,347
501 PIONI04 Piercy Gaston Lima 4/25/2020 S/ 45,657
502 PITHI12 Piercy Danforth Lima 12/4/2019 S/ 48,882
503 PLEYI09 Playfair Moxley Lima 9/7/2019 S/ 83,847
504 PLIAR09 Playfair Correia Trujillo 9/17/2020 S/ 15,081
505 POONR06 Poblete Seaton Arequipa 6/23/2019 S/ 36,245
506 POLLR04 Pollock Bushwell Arequipa 4/2/2020 S/ 70,651
507 QUUEI06 Quinn Bogue Lima 6/10/2020 S/ 74,531
508 RAEZH10 Ralph Álvarez Chiclayo 10/29/2020 S/ 58,353
509 REHAR01 Reed Cunha Arequipa 1/20/2019 S/ 79,063
510 RECER12 Reese Alice Arequipa 12/27/2020 S/ 86,373
511 REANH02 Reinard Annan Chiclayo 2/13/2019 S/ 44,376
512 RELLR04 Reyes Hargill Trujillo 4/19/2019 S/ 39,546
513 RETHI11 Reyes Smith Lima 11/16/2019 S/ 36,357
514 REARR03 Reyes Dunbar Arequipa 3/9/2020 S/ 59,761
515 RELEI11 Reynold Doyle Lima 11/5/2019 S/ 73,045
516 REEYI12 Reynolds Hadley Lima 12/28/2020 S/ 52,965
517 RHCKH10 Rhodes Hasbrouck Chiclayo 10/22/2019 S/ 94,275
518 RIROI04 Ricard Romero Lima 4/21/2020 S/ 69,798
519 RIONI08 Richard Gihon Piura 8/15/2020 S/ 83,230
520 RIURR02 Riddell Arthur Arequipa 2/19/2020 S/ 67,363
521 RIESH07 Ripley Hales Chiclayo 7/12/2020 S/ 59,344
522 RILLR08 Riquelme Ewell Arequipa 8/26/2020 S/ 93,417
523 ROAYI12 Robert Mackay Lima 12/11/2020 S/ 47,168
524 ROESR06 Roberts Geddes Arequipa 6/28/2019 S/ 27,310
525 RODSI06 Roberts Edwards Piura 6/29/2019 S/ 96,800
526 ROINI11 Robinson Corwin Piura 11/7/2020 S/ 45,576
527 ROONI08 Rocha Denton Lima 8/13/2020 S/ 94,865
528 RODEI05 Rochester De Lima 5/13/2019 S/ 58,228
529 ROERR04 Rodrigues Cleaver Trujillo 4/12/2019 S/ 43,882
530 ROKER07 Rodríguez Bolingbroke Arequipa 7/21/2020 S/ 34,054
531 ROBYR11 Rogers Stokesby Trujillo 11/24/2020 S/ 17,525
532 ROEYR08 Roland Ashley Arequipa 8/14/2020 S/ 76,400
533 ROSTI02 Roland Hurst Piura 2/25/2019 S/ 25,555
534 ROESI04 Root Thwaytes Piura 4/24/2020 S/ 29,521
535 RORDR09 Rossi Reynard Trujillo 9/4/2020 S/ 97,743
536 RORDR02 Rowen Seaford Arequipa 2/9/2020 S/ 82,148
537 ROINR06 Rowena Edwin Trujillo 6/26/2020 S/ 40,022
538 ROEYR07 Rowle Moxley Trujillo 7/1/2019 S/ 32,053
539 ROONR07 Roy Peterson Arequipa 7/18/2020 S/ 79,351
540 RUANI04 Rue Allan Lima 4/5/2020 S/ 63,099
541 RUONR10 Ruiz Preston Arequipa 10/30/2019 S/ 30,161
542 RUCEI07 Rusbridge Alice Piura 7/4/2019 S/ 92,045
543 RURDR02 Russell Giffard Trujillo 2/24/2020 S/ 31,919
544 RUONI01 Rutherford Gustavsson Piura 1/26/2020 S/ 94,766
545 RYSEI08 Rynders Rose Piura 8/21/2019 S/ 26,895
546 SÁONI11 Sáez Alverton Lima 11/19/2020 S/ 45,665
547 SAONH10 Salazar Nelson Chiclayo 10/28/2019 S/ 29,658
548 SAÖMR11 San Martín Lindström Arequipa 11/12/2020 S/ 45,858
549 SALLR12 San Martín Parshall Arequipa 12/9/2019 S/ 91,601
550 SASTR08 Sandford Amherst Trujillo 8/24/2019 S/ 28,464
551 SAAMH05 Sarisbury Chatham Chiclayo 5/1/2019 S/ 89,294
552 SANGI04 Saterlee Harding Piura 4/16/2019 S/ 89,604
553 SCTHI10 Schellden Menteth Piura 10/2/2019 S/ 80,283
554 SCISR03 Schellden Harris Arequipa 3/4/2020 S/ 24,356
555 SCRYI10 Scott Barry Lima 10/3/2019 S/ 67,158
556 SCDAR01 Scott Miranda Arequipa 1/2/2019 S/ 86,123
557 SEERI10 Selby Gloucester Lima 10/19/2020 S/ 58,246
558 SETER04 Selkirk Paquette Arequipa 4/14/2019 S/ 98,155
559 SENAR07 Selkirk Orellana Trujillo 7/13/2020 S/ 99,521
560 SEENI06 Sepúlveda Rodden Piura 6/17/2019 S/ 47,348
561 SHTHI10 Shelley Cotesworth Piura 10/8/2020 S/ 84,175
562 SHNEI05 Shiel Ballantine Lima 5/9/2019 S/ 12,290
563 SHBSR07 Shiel Coombs Arequipa 7/28/2019 S/ 58,967
564 SHRNH06 Shiel Kinghorn Chiclayo 6/28/2019 S/ 10,206
565 SHERH10 Shurtliff Challoner Chiclayo 10/21/2019 S/ 88,182
566 SHENH01 Shute Johnsen Chiclayo 1/10/2019 S/ 12,445
567 SIDOI11 Sigismund Maldonado Piura 11/22/2020 S/ 44,003
568 SIEYR09 Silva Filey Arequipa 9/17/2019 S/ 33,031
569 SIRDI03 Silva Seaford Piura 3/26/2019 S/ 19,111
570 SIDTR02 Simpson Brodt Trujillo 2/3/2019 S/ 72,298
571 SIRKR09 Simpson Clark Trujillo 9/13/2020 S/ 63,855
572 SIESR10 Simpson Ives Trujillo 10/13/2019 S/ 26,905
573 SLTAI08 Slade Costa Piura 8/10/2019 S/ 26,542
574 SLLEI08 Slater Kyle Piura 8/13/2020 S/ 41,486
575 SLERI05 Slater Baker Piura 5/13/2019 S/ 34,346
576 SMGEI06 Smith Trowbridge Piura 6/29/2020 S/ 28,965
577 SNNGR12 Snodgrass Ting Trujillo 12/27/2020 S/ 69,858
578 SOGHR03 Soto Harleigh Trujillo 3/10/2019 S/ 66,586
579 SOROI07 Southwell Romero Lima 7/11/2019 S/ 21,254
580 SOEYI06 Souza Filley Lima 6/5/2020 S/ 37,410
581 SPLDI11 Spalding MacDonald Piura 11/3/2019 S/ 29,772
582 STRDR10 Stanhope Danford Trujillo 10/8/2020 S/ 12,482
583 STEYI06 Stanhope Halsey Piura 6/3/2019 S/ 62,214
584 STLLR06 Stanhope Riddell Arequipa 6/13/2020 S/ 87,173
585 STESI03 Stanwood Morales Piura 3/17/2019 S/ 20,764
586 STEYR09 Stanwood Astley Arequipa 9/3/2020 S/ 70,078
587 STLOH11 Stewart Castillo Chiclayo 11/6/2020 S/ 99,262
588 STCEI06 Stockton Price Lima 6/6/2019 S/ 82,455
589 STONI07 Stretton Hutton Piura 7/27/2019 S/ 20,355
590 STBEI08 Stretton Edgecumbe Lima 8/15/2020 S/ 36,273
591 STONH05 Stubbins Merton Chiclayo 5/16/2019 S/ 73,194
592 SWCHI03 Swift Norwich Piura 3/9/2020 S/ 37,706
593 SYJOH06 Symington Araújo Chiclayo 6/9/2019 S/ 29,283
594 TAGHR06 Tattersall Scarborough Arequipa 6/20/2020 S/ 72,694
595 TAKSR03 Taylor Brooks Trujillo 3/2/2020 S/ 12,868
596 TATEI05 Taylor Poblete Lima 5/1/2020 S/ 55,474
597 TEIEH04 Teddington Ogilvie Chiclayo 4/16/2020 S/ 72,422
598 TEONR03 Teesdale Sheldon Trujillo 3/8/2020 S/ 24,177
599 TERTH03 Teft Harcourt Chiclayo 3/23/2020 S/ 21,720
600 TEEER07 Telfair Buckbee Trujillo 7/5/2020 S/ 34,700
601 TEREI06 Telfair Lechmere Piura 6/16/2020 S/ 77,241
602 TEDTH05 Telford Brodt Chiclayo 5/2/2020 S/ 15,943
603 THRTH03 Theodoric Ackart Chiclayo 3/21/2020 S/ 34,867
604 THANH05 Thomas Morgan Chiclayo 5/10/2020 S/ 61,196
605 THERR08 Thurston Boucher Arequipa 8/30/2020 S/ 99,738
606 THESH05 Thwaite Gomes Chiclayo 5/22/2019 S/ 93,747
607 TIENR10 Tillinghast Crittenden Trujillo 10/24/2020 S/ 40,778
608 TIRYR07 Ting Coventry Trujillo 7/19/2020 S/ 20,723
609 TOANI05 Toro Allan Piura 5/25/2020 S/ 36,665
610 TOINR12 Torres Pedin Trujillo 12/5/2020 S/ 81,299
611 TOOTR08 Torry Root Trujillo 8/25/2019 S/ 82,210
612 TRTAI03 Tracy Costa Piura 3/2/2019 S/ 74,104
613 TRBEI01 Trelawney Balcombe Lima 1/26/2019 S/ 46,904
614 TRENR08 Tremaine Leven Trujillo 8/11/2019 S/ 25,505
615 TRSER06 Trevelyan Reese Arequipa 6/30/2019 S/ 65,863
616 TRERR08 Trowbridge Pelletier Trujillo 8/1/2019 S/ 60,086
617 TRARR06 Truax Biggar Arequipa 6/27/2019 S/ 25,220
618 TRNER04 Truax Bryne Trujillo 4/5/2019 S/ 46,218
619 TRONR05 Truax Cameron Arequipa 5/13/2020 S/ 24,522
Categoría
Encontrar la categoría dependiendo de las ventas realizadas según la tabla
mostrada. Utilizar funciones de búsqueda adecuadas

Ventas S/ 10,000.0 S/ 30,000.0 S/ 60,000.0 S/ 90,000.0

Categoría D C B A
 En una nueva hoja, muestra qué porcentaje de bonificación se destina a cada departamento (filas) y en cada su

Código 1er. Apellido 2do. Apellido Nombres Sexo F. Nacimiento

GE-OAN94 Curci Sanchez Milton Eugenio M 10/31/1981
SE-OEC57 Zarauz Recuero Carlos Humberto M 8/30/1982
GE-SAR51 Areosa Martinez Luis M 4/14/1981
SU-AHI98 Carresse Chirelli Cecilia F 6/30/1984
ED-AIG66 Coustard Vignola Maria Fernanda F 12/27/1983
ED-SEJ97 Alvez Tejera Jorge Andres M 5/24/1984
ED-SAC88 Lopez Machado Elias Moises M 6/15/1984
DI-LER98 Minola Perdomo Miguel Angel M 2/16/1982
ED-OAZ93 Rovira Lazzo Eduardo M 4/15/1981
JU-EUT49 Olivera Cutinella Eduardo Jorge M 10/24/1984
ED-OOC60 Varela Rocha Zosimo M 4/25/1980
MI-EON29 Balcarcel Poniachjk Amavira Haydee F 10/5/1983
DI-AOR46 Dotti Moreira Ana F 6/13/1983
MI-RLB28 De Oliveira Albert Victor M 8/5/1984
JU-OSB17 De La Iglesia Isbarbo Carlos Valerio M 5/21/1980
ED-A85 Motta Blanca Mariela F 9/21/1980
ED-OAS81 Pinheiro Nasta Hugo M 2/15/1980
DI-DER50 Dominguez Perez Diego Eward M 6/25/1981
JU-OEN54 Ferreira Benitez Fernando Augusto M 5/22/1981
MI-OST29 Reyes Estefan Carlos Mario M 3/18/1980
JU-NON42 Ibarra Montaldo Allen M 6/8/1984
FI-AAB54 Sanguinetti Cabaña Lucía María F 11/29/1981
rtamento (filas) y en cada sucursal (columnas).

Estado Civil Hijos Departamento Sucursal Ingreso

Viudo 1 Administración Arequipa 1/19/2000
Viudo 2 Administración Chiclayo 10/11/2009
Viudo 4 Logística Chiclayo
Soltero 5 Recursos Humanos Lima 7/16/2008
Casado 1 Marketing Trujillo 5/8/2011
Viudo 6 Logística Chiclayo
Casado 3 Contabilidad Chiclayo 1/22/2010
Soltero 5 Logística Arequipa 11/25/2017
Soltero 6 Contabilidad Chiclayo 7/31/2011
Divorciado 6 Logística Lima
Divorciado 5 Contabilidad Chiclayo 1/25/2003
Divorciado 1 Logística Lima
Soltero 4 Administración Trujillo 11/2/2004
Casado 0 Marketing Arequipa 3/15/2007
Soltero 6 Contabilidad Trujillo 5/5/2005
Divorciado 1 Contabilidad Lima 11/21/2005
Viudo 0 Administración Trujillo
Casado 1 Logística Trujillo 12/17/2004
Casado 2 Logística Trujillo 3/4/2004
Soltero 3 Recursos Humanos Arequipa 6/29/2010
Soltero 5 Administración Lima 5/17/2016
Casado 4 Contabilidad Trujillo 4/14/2009
 Sueldo Bonificación
S/ 7,876.85 S/ 393.84
S/ 6,028.52 S/ 301.43
S/ 6,373.64 S/ 318.68
S/ 2,191.33 S/ 109.57
S/ 2,156.76 S/ 107.84
S/ 5,664.51 S/ 283.23
S/ 6,319.52 S/ 315.98
S/ 4,664.64 S/ 233.23
S/ 8,336.62 S/ 416.83
S/ 7,425.17 S/ 371.26
S/ 2,246.99 S/ 112.35
S/ 6,130.64 S/ 306.53
S/ 3,150.73 S/ 157.54
S/ 3,435.77 S/ 171.79
S/ 1,545.99 S/ 77.30
S/ 4,534.69 S/ 226.73
S/ 2,855.61 S/ 142.78
S/ 6,623.87 S/ 331.19
S/ 3,531.08 S/ 176.55
S/ 4,737.20 S/ 236.86
S/ 2,556.18 S/ 127.81
S/ 5,915.78 S/ 295.79
 Código 1er. Apellido 2do. Apellido Nombres F. Nacimiento
GE-OAN94 Curci Sanchez Milton Eugenio 10/31/1981
SE-OEC57 Zarauz Recuero Carlos Humberto 8/30/1982
GE-SAR51 Areosa Martinez Luis 4/14/1981
SU-AHI98 Carresse Chirelli Cecilia 6/30/1984
ED-AIG66 Coustard Vignola Maria Fernanda 12/27/1983
ED-SEJ97 Alvez Tejera Jorge Andres 5/24/1984
ED-SAC88 Lopez Machado Elias Moises 6/15/1984
DI-LER98 Minola Perdomo Miguel Angel 2/16/1982
ED-OAZ93 Rovira Lazzo Eduardo 4/15/1981
JU-EUT49 Olivera Cutinella Eduardo Jorge 10/24/1984
ED-OOC60 Varela Rocha Zosimo 4/25/1980
MI-EON29 Balcarcel Poniachjk Amavira Haydee 10/5/1983
DI-AOR46 Dotti Moreira Ana 6/13/1983
MI-RLB28 De Oliveira Albert Victor 8/5/1984
JU-OSB17 De La Iglesia Isbarbo Carlos Valerio 5/21/1980
ED-A85 Motta Blanca Mariela 9/21/1980
ED-OAS81 Pinheiro Nasta Hugo 2/15/1980
DI-DER50 Dominguez Perez Diego Eward 6/25/1981
JU-OEN54 Ferreira Benitez Fernando Augusto 5/22/1981
MI-OST29 Reyes Estefan Carlos Mario 3/18/1980
JU-NON42 Ibarra Montaldo Allen 6/8/1984
FI-AAB54 Sanguinetti Cabaña Lucía María 11/29/1981
 Departamento Sucursal Ingreso Sueldo Bonificación
Administración Arequipa 1/19/2000 S/ 7,876.85 S/ 393.84 Se planea aplicar un
Administración Chiclayo 10/11/2009 S/ 6,028.52 S/ 301.43 Insertar una tabla din
Logística Chiclayo S/ 6,373.64 S/ 318.68 campo llamado Nuev
diferencia entre el su
Recursos Humanos Lima 7/16/2008 S/ 2,191.33 S/ 109.57 Colocar un gráfico din
Marketing Trujillo 5/8/2011 S/ 2,156.76 S/ 107.84
Logística Chiclayo S/ 5,664.51 S/ 283.23
Contabilidad Chiclayo 1/22/2010 S/ 6,319.52 S/ 315.98
Logística Arequipa 11/25/2017 S/ 4,664.64 S/ 233.23
Contabilidad Chiclayo 7/31/2011 S/ 8,336.62 S/ 416.83
Logística Lima S/ 7,425.17 S/ 371.26
Contabilidad Chiclayo 1/25/2003 S/ 2,246.99 S/ 112.35
Logística Lima S/ 6,130.64 S/ 306.53
Administración Trujillo 11/2/2004 S/ 3,150.73 S/ 157.54
Marketing Arequipa 3/15/2007 S/ 3,435.77 S/ 171.79
Contabilidad Trujillo 5/5/2005 S/ 1,545.99 S/ 77.30
Contabilidad Lima 11/21/2005 S/ 4,534.69 S/ 226.73
Administración Trujillo S/ 2,855.61 S/ 142.78
Logística Trujillo 12/17/2004 S/ 6,623.87 S/ 331.19
Logística Trujillo 3/4/2004 S/ 3,531.08 S/ 176.55
Recursos Humanos Arequipa 6/29/2010 S/ 4,737.20 S/ 236.86
Administración Lima 5/17/2016 S/ 2,556.18 S/ 127.81
Contabilidad Trujillo 4/14/2009 S/ 5,915.78 S/ 295.79
Se planea aplicar un recorte de sueldo de 5% en cada sucursal de la empresa.
Insertar una tabla dinámica en una hoja y usando el comando campos calculados inserta un
campo llamado Nuevo sueldo y otro llamado diferencia. Este último debe mostrar la
diferencia entre el sueldo actual y el nuevo sueldo.
Colocar un gráfico dinámico comparativo entre los tres campos.