P

Aplicar formato condicional a las categorías:

A (azul)
B rojo)
C (verde)

DATOS DEL TRABAJADOR

N EMPLEADO FEC_ING DNI

1 Abanto Chavez Jesus 8/1/2007 29458745
2 Bendezu Moreno Ofelia 8/1/2007 29453260
3 Cadillo Hidalgo Pedro 4/1/2008 07818368
4 Cantu Mejia William 1/10/2006 29458748
5 Carrasco Cuzcano Maria 1/10/2006 29458749
6 Castillo Rojas Alonso 11/1/2003 29458750
7 Cruz Bustamente Dennis 8/23/2007 29453265
8 Diaz Montes Joel 11/1/2003 29447780
9 Fuentes Rivera Daniel 8/23/2007 07816913
10 Huanuco Almeida Ricardo 3/1/2008 07811428
11 Huertas Arana Raul 3/1/2008 02073544
12 Lagos Velasquez Humberto 1/10/2006 29458756
13 Laos Loayza Aurelio 8/1/2007 29458757
14 Cruz Fuentes Rodolfo 5/5/1999 89777777
15 Flores Pizarro Juan 8/7/2000 25632574
16 Godoy Arroyo Lucio 9/3/1999 25120145
17 Lopez Cabello Antonio 9/5/2001 65874125
18 Montesinos Lopez Karen 3/2/2001 32565874
19 Rojas Gomez Paul 11/10/2001 25632541
20 Silva Cabezas Gabriela 5/4/2002 21025478
21 Velasquez Tito Johana 6/7/2002 35897410
22 Belleza Alvarez Victor 12/10/2003 25471102
23 Carrasco Aquise Omar 8/5/2003 22156987
24 Castillo Mendoza Luis 9/5/2004 47851248
25 Chinchay Mulatillo Juan 3/5/2004 25896541
26 Chumacero Espinel Diego 9/5/2004 32658974
27 Espinoza Yañez Carlos 5/3/2005 25314789
28 Flores Malla Raul 4/3/2005 32561112
29 Herrera Muñoz Sandro 6/6/2005 20114587
30 Julian Aliaga Salomon 8/7/2005 41526398
31 Pacheco Saavedra Jacob 6/1/2005 32598741
32 Perez Vilchez Jose 7/3/2006 32569874
33 Reyes Ysminio Milagros 5/9/2006 12457412
34 Rodriguez Tolentino Luis 10/4/2006 32569741
35 Roman Anaya Erick 4/4/2006 32569874
36 Ruiz Suarez Armando 11/7/2006 12014785
37 Campos Nuñez Renzo 1/20/2007 35214780
38 Chavez Guadalupe Raul 5/12/2007 32659874
39 Flores Huete Diana 8/3/2007 32014587
40 Huaman Arroyo Pedro 12/12/2008 36987410
41 Matos Rojas Aida 9/5/2008 56987415
42 Piñashca Cashpa, Rosa 8/6/2008 25698741
43 Quispe Aparco, Jhon 7/3/2008 25698741
44 Trujillo Miranda, Raul 9/3/2008 23659874
45 Vilcapoma Gonzales, Kevin 1/10/2009 32569874
46 Villegas Campos, Juan 1/11/2011 32014587
47 Huaytalla Quicara Henry 10/3/2010 23569874
48 Martinez Fernandez Angela 9/4/2010 32569874
49 Reyes Huacachi Reyna 7/3/2010 20123658
50 Tipian Valentin Yolanda 8/9/2010 96325874
 PLANILLA DE REMUNERACIONES
Mes Enero 2016
las categorías:

DATOS DEL TRABAJADOR

TURNO CATEG ASIG FAM AFIL

Mañana A SI PRIMA
Mañana A NO PRIMA
Mañana A SI INTEGRA
Mañana A SI INTEGRA
Tarde B SI INTEGRA
Tarde B SI INTEGRA
Tarde B NO INTEGRA
Tarde B SI HABITAT
Tarde C NO HABITAT
Tarde C NO HABITAT
Tarde C NO HABITAT
Mañana C NO PRIMA
Mañana C NO PRIMA
Mañana C NO PRIMA
Mañana A NO PRIMA
Mañana A SI PRIMA
Mañana A SI PRIMA
Tarde B SI PROFUTURO
Tarde B SI HABITAT
Tarde B SI HABITAT
Tarde B NO HABITAT
Tarde A SI PROFUTURO
Mañana A SI PROFUTURO
Mañana A SI PROFUTURO
Mañana A SI PROFUTURO
Mañana A NO PROFUTURO
Tarde A NO HABITAT
Tarde C NO HABITAT
Tarde C NO PRIMA
Tarde C SI PRIMA
Tarde C SI PROFUTURO
Tarde B SI PROFUTURO
Mañana B SI HABITAT
Mañana B NO HABITAT
Mañana B NO ONP
Mañana A NO ONP
Mañana A SI ONP
Tarde A SI PROFUTURO
Tarde A NO ONP
Tarde C NO PROFUTURO
Tarde C NO PROFUTURO
Tarde C SI ONP
Tarde A SI ONP
Mañana A SI ONP
Mañana A SI INTEGRA
Mañana B SI INTEGRA
Mañana B SI INTEGRA
Tarde B NO PRIMA
Tarde A NO ONP
Tarde A SI PRIMA
UNERACIONES
2016

DESCUENTOS AL TRABAJADOR

BASE DE CÁLCULO ONP AFP TOTAL

BRUTO FAMILIAR REMUN ONP AOBL PRIMA COMISION TOTAL DSCTOS

S/. 650 S/. 65 S/. 715 - 71.50 6.29 12.87 90.66 S/. 90.66
S/. 850 S/. 0 S/. 850 - 85.00 7.48 15.30 107.78 S/. 107.78
S/. 900 S/. 65 S/. 965 - 96.50 8.49 17.37 122.36 S/. 122.36
S/. 650 S/. 65 S/. 715 - 71.50 6.29 13.94 91.73 S/. 91.73
S/. 700 S/. 65 S/. 765 99.45 - - - - S/. 99.45
S/. 900 S/. 65 S/. 965 - 96.50 8.49 17.37 122.36 S/. 122.36
S/. 800 S/. 0 S/. 800 - 80.00 7.20 15.84 103.04 S/. 103.04
S/. 800 S/. 65 S/. 865 - 86.50 7.61 15.57 109.68 S/. 109.68
S/. 650 S/. 0 S/. 650 84.50 - - - - S/. 84.50
S/. 650 S/. 0 S/. 650 - 65.00 5.85 12.87 83.72 S/. 83.72
S/. 1,000 S/. 0 S/. 1,000 - 100.00 8.70 15.00 123.70 S/. 123.70
S/. 600 S/. 0 S/. 600 78.00 - - - - S/. 78.00
S/. 750 S/. 0 S/. 750 97.50 - - - - S/. 97.50
S/. 650 S/. 0 S/. 650 - 65.00 5.72 12.68 83.40 S/. 83.40
S/. 900 S/. 0 S/. 900 - 90.00 7.92 17.55 115.47 S/. 115.47
S/. 900 S/. 65 S/. 965 - 96.50 8.49 18.82 123.81 S/. 123.81
S/. 900 S/. 65 S/. 965 - 96.50 8.49 18.82 123.81 S/. 123.81
S/. 900 S/. 65 S/. 965 125.45 - - - - S/. 125.45
S/. 1,200 S/. 65 S/. 1,265 - 126.50 11.13 22.77 160.40 S/. 160.40
S/. 550 S/. 65 S/. 615 - 61.50 5.41 11.07 77.98 S/. 77.98
S/. 1,000 S/. 0 S/. 1,000 - 100.00 8.80 18.00 126.80 S/. 126.80
S/. 1,000 S/. 65 S/. 1,065 - 106.50 9.37 19.17 135.04 S/. 135.04
S/. 550 S/. 65 S/. 615 - 61.50 - - 61.50 S/. 61.50
S/. 700 S/. 65 S/. 765 - 76.50 - - 76.50 S/. 76.50
S/. 700 S/. 65 S/. 765 99.45 - - - - S/. 99.45
S/. 600 S/. 0 S/. 600 78.00 - - - - S/. 78.00
S/. 650 S/. 0 S/. 650 - 65.00 - - 65.00 S/. 65.00
S/. 650 S/. 0 S/. 650 84.50 - - - - S/. 84.50
S/. 800 S/. 0 S/. 800 - 80.00 - - 80.00 S/. 80.00
S/. 800 S/. 65 S/. 865 - 86.50 - - 86.50 S/. 86.50
S/. 1,200 S/. 65 S/. 1,265 - 126.50 - - 126.50 S/. 126.50
S/. 1,200 S/. 65 S/. 1,265 164.45 - - - - S/. 164.45
S/. 650 S/. 65 S/. 715 - 71.50 6.22 10.73 88.45 S/. 88.45
S/. 900 S/. 0 S/. 900 - 90.00 7.83 13.50 111.33 S/. 111.33
S/. 900 S/. 0 S/. 900 117.00 - - - - S/. 117.00
S/. 1,200 S/. 0 S/. 1,200 156.00 - - - - S/. 156.00
S/. 1,000 S/. 65 S/. 1,065 138.45 - - - - S/. 138.45
S/. 1,000 S/. 65 S/. 1,065 - 106.50 9.27 15.98 131.74 S/. 131.74
S/. 550 S/. 0 S/. 550 71.50 - - - - S/. 71.50
S/. 550 S/. 0 S/. 550 - 55.00 4.95 10.89 70.84 S/. 70.84
S/. 550 S/. 0 S/. 550 - 55.00 4.95 10.89 70.84 S/. 70.84
S/. 550 S/. 65 S/. 615 79.95 - - - - S/. 79.95
S/. 550 S/. 65 S/. 615 79.95 - - - - S/. 79.95
S/. 550 S/. 65 S/. 615 79.95 - - - - S/. 79.95
S/. 650 S/. 65 S/. 715 - 71.50 6.44 14.16 92.09 S/. 92.09
S/. 750 S/. 65 S/. 815 - 81.50 7.09 12.23 100.82 S/. 100.82
S/. 850 S/. 65 S/. 915 - 91.50 7.96 13.73 113.19 S/. 113.19
S/. 850 S/. 0 S/. 850 - 85.00 7.48 16.58 109.06 S/. 109.06
S/. 700 S/. 0 S/. 700 91.00 - - - - S/. 91.00
S/. 700 S/. 65 S/. 765 - 76.50 6.66 11.48 94.63 S/. 94.63
 APORTES DEL
EMPLEADOR

NETO ESSALUD SCTR

S/. 624.34 S/. 64.35 S/. 8.79
S/. 742.22 S/. 76.50 S/. 10.46
S/. 842.64 S/. 86.85 S/. 11.87
S/. 623.27 S/. 64.35 S/. 8.79
S/. 665.55 S/. 68.85 S/. 9.41
S/. 842.64 S/. 86.85 S/. 11.87
S/. 696.96 S/. 72.00 S/. 9.84
S/. 755.32 S/. 77.85 S/. 10.64
S/. 565.50 S/. 58.50 S/. 8.00
S/. 566.28 S/. 58.50 S/. 8.00
S/. 876.30 S/. 90.00 S/. 12.30
S/. 522.00 S/. 58.50 S/. 7.38
S/. 652.50 S/. 67.50 S/. 9.23
S/. 566.61 S/. 58.50 S/. 8.00
S/. 784.53 S/. 81.00 S/. 11.07
S/. 841.19 S/. 86.85 S/. 11.87
S/. 841.19 S/. 86.85 S/. 11.87
S/. 839.55 S/. 86.85 S/. 11.87
S/. 1,104.60 S/. 113.85 S/. 15.56
S/. 537.02 S/. 58.50 S/. 7.56
S/. 873.20 S/. 90.00 S/. 12.30
S/. 929.96 S/. 95.85 S/. 13.10
S/. 553.50 S/. 58.50 S/. 7.56
S/. 688.50 S/. 68.85 S/. 9.41
S/. 665.55 S/. 68.85 S/. 9.41
S/. 522.00 S/. 58.50 S/. 7.38
S/. 585.00 S/. 58.50 S/. 8.00
S/. 565.50 S/. 58.50 S/. 8.00
S/. 720.00 S/. 72.00 S/. 9.84
S/. 778.50 S/. 77.85 S/. 10.64
S/. 1,138.50 S/. 113.85 S/. 15.56
S/. 1,100.55 S/. 113.85 S/. 15.56
S/. 626.55 S/. 64.35 S/. 8.79
S/. 788.67 S/. 81.00 S/. 11.07
S/. 783.00 S/. 81.00 S/. 11.07
S/. 1,044.00 S/. 108.00 S/. 14.76
S/. 926.55 S/. 95.85 S/. 13.10
S/. 933.26 S/. 95.85 S/. 13.10
S/. 478.50 S/. 58.50 S/. 6.77
S/. 479.16 S/. 58.50 S/. 6.77
S/. 479.16 S/. 58.50 S/. 6.77
S/. 535.05 S/. 58.50 S/. 7.56
S/. 535.05 S/. 58.50 S/. 7.56
S/. 535.05 S/. 58.50 S/. 7.56
S/. 622.91 S/. 64.35 S/. 8.79
S/. 714.18 S/. 73.35 S/. 10.02
S/. 801.81 S/. 82.35 S/. 11.25
S/. 740.95 S/. 76.50 S/. 10.46
S/. 609.00 S/. 63.00 S/. 8.61
S/. 670.37 S/. 68.85 S/. 9.41
 PLANILLA DE REM
Mes Enero
Aplicar formato condicional
a) Neto: relleno rojo claro a los cinco valores más altos
b) Essalud: relleno amarillo claro al tercio superior
c) SCTR: relleno verde claro a los valores por encima del promedio

DATOS DEL TRABAJADOR

N EMPLEADO FEC_ING DNI TURNO CATEG ASIG FAM AFIL

1 Abanto Chavez Jesus 8/1/2007 29458745 Mañana A SI INT
2 Bendezu Moreno Ofelia 8/1/2007 29453260 Mañana A NO INT
3 Cadillo Hidalgo Pedro 4/1/2008 07818368 Mañana A SI INT
4 Cantu Mejia William 1/10/2006 29458748 Mañana A SI HOR
5 Carrasco Cuzcano Maria 1/10/2006 29458749 Tarde B SI ONP
6 Castillo Rojas Alonso 11/1/2003 29458750 Tarde B SI INT
7 Cruz Bustamente Dennis 8/23/2007 29453265 Tarde B NO PRO
8 Diaz Montes Joel 11/1/2003 29447780 Tarde B SI INT
9 Fuentes Rivera Daniel 8/23/2007 07816913 Tarde C NO ONP
10 Huanuco Almeida Ricardo 3/1/2008 07811428 Tarde C NO PRO
11 Huertas Arana Raul 3/1/2008 02073544 Tarde C NO PRI
12 Lagos Velasquez Humberto 1/10/2006 29458756 Mañana C NO ONP
13 Laos Loayza Aurelio 8/1/2007 29458757 Mañana C NO ONP
14 Cruz Fuentes Rodolfo 5/5/1999 89777777 Mañana C NO HOR
15 Flores Pizarro Juan 8/7/2000 25632574 Mañana A NO HOR
16 Godoy Arroyo Lucio 9/3/1999 25120145 Mañana A SI HOR
17 Lopez Cabello Antonio 9/5/2001 65874125 Mañana A SI HOR
18 Montesinos Lopez Karen 3/2/2001 32565874 Tarde B SI ONP
19 Rojas Gomez Paul 11/10/2001 25632541 Tarde B SI INT
20 Silva Cabezas Gabriela 5/4/2002 21025478 Tarde B SI INT
21 Velasquez Tito Johana 6/7/2002 35897410 Tarde B NO INT
22 Belleza Alvarez Victor 12/10/2003 25471102 Tarde A SI INT
23 Carrasco Aquise Omar 8/5/2003 22156987 Mañana A SI NVU
24 Castillo Mendoza Luis 9/5/2004 47851248 Mañana A SI NVU
25 Chinchay Mulatillo Juan 3/5/2004 25896541 Mañana A SI ONP
26 Chumacero Espinel Diego 9/5/2004 32658974 Mañana A NO ONP
27 Espinoza Yañez Carlos 5/3/2005 25314789 Tarde A NO NVU
28 Flores Malla Raul 4/3/2005 32561112 Tarde C NO ONP
29 Herrera Muñoz Sandro 6/6/2005 20114587 Tarde C NO NVU
30 Julian Aliaga Salomon 8/7/2005 41526398 Tarde C SI NVU
31 Pacheco Saavedra Jacob 6/1/2005 32598741 Tarde C SI NVU
32 Perez Vilchez Jose 7/3/2006 32569874 Tarde B SI ONP
33 Reyes Ysminio Milagros 5/9/2006 12457412 Mañana B SI PRI
34 Rodriguez Tolentino Luis 10/4/2006 32569741 Mañana B NO PRI
35 Roman Anaya Erick 4/4/2006 32569874 Mañana B NO ONP
36 Ruiz Suarez Armando 11/7/2006 12014785 Mañana A NO ONP
37 Campos Nuñez Renzo 1/20/2007 35214780 Mañana A SI ONP
38 Chavez Guadalupe Raul 5/12/2007 32659874 Tarde A SI PRI
39 Flores Huete Diana 8/3/2007 32014587 Tarde A NO ONP
40 Huaman Arroyo Pedro 12/12/2008 36987410 Tarde C NO PRO
41 Matos Rojas Aida 9/5/2008 56987415 Tarde C NO PRO
42 Piñashca Cashpa, Rosa 8/6/2008 25698741 Tarde C SI ONP
43 Quispe Aparco, Jhon 7/3/2008 25698741 Tarde A SI ONP
44 Trujillo Miranda, Raul 9/3/2008 23659874 Mañana A SI ONP
45 Vilcapoma Gonzales, Kevin 1/10/2009 32569874 Mañana A SI PRO
46 Villegas Campos, Juan 1/11/2011 32014587 Mañana B SI PRI
47 Huaytalla Quicara Henry 10/3/2010 23569874 Mañana B SI PRI
48 Martinez Fernandez Angela 9/4/2010 32569874 Tarde B NO HOR
49 Reyes Huacachi Reyna 7/3/2010 20123658 Tarde A NO ONP
50 Tipian Valentin Yolanda 8/9/2010 96325874 Tarde A SI PRI
NILLA DE REMUNERACIONES
Mes Enero 2017

DESCUENTOS AL TRABAJADOR

BASE DE CÁLCULO ONP AFP TOTAL

BRUTO FAMILIAR REMUN ONP AOBL PRIMA COMISION TOTAL DSCTOS NETO
S/. 650 S/. 65 S/. 715 - 71.50 6.29 12.87 90.66 S/. 90.66 S/. 624.34
S/. 850 S/. 0 S/. 850 - 85.00 7.48 15.30 107.78 S/. 107.78 S/. 742.22
S/. 900 S/. 65 S/. 965 - 96.50 8.49 17.37 122.36 S/. 122.36 S/. 842.64
S/. 650 S/. 65 S/. 715 - 71.50 6.29 13.94 91.73 S/. 91.73 S/. 623.27
S/. 700 S/. 65 S/. 765 99.45 - - - - S/. 99.45 S/. 665.55
S/. 900 S/. 65 S/. 965 - 96.50 8.49 17.37 122.36 S/. 122.36 S/. 842.64
S/. 800 S/. 0 S/. 800 - 80.00 7.20 15.84 103.04 S/. 103.04 S/. 696.96
S/. 800 S/. 65 S/. 865 - 86.50 7.61 15.57 109.68 S/. 109.68 S/. 755.32
S/. 650 S/. 0 S/. 650 84.50 - - - - S/. 84.50 S/. 565.50
S/. 650 S/. 0 S/. 650 - 65.00 5.85 12.87 83.72 S/. 83.72 S/. 566.28
S/. 1,000 S/. 0 S/. 1,000 - 100.00 8.70 15.00 123.70 S/. 123.70 S/. 876.30
S/. 600 S/. 0 S/. 600 78.00 - - - - S/. 78.00 S/. 522.00
S/. 750 S/. 0 S/. 750 97.50 - - - - S/. 97.50 S/. 652.50
S/. 650 S/. 0 S/. 650 - 65.00 5.72 12.68 83.40 S/. 83.40 S/. 566.61
S/. 900 S/. 0 S/. 900 - 90.00 7.92 17.55 115.47 S/. 115.47 S/. 784.53
S/. 900 S/. 65 S/. 965 - 96.50 8.49 18.82 123.81 S/. 123.81 S/. 841.19
S/. 900 S/. 65 S/. 965 - 96.50 8.49 18.82 123.81 S/. 123.81 S/. 841.19
S/. 900 S/. 65 S/. 965 125.45 - - - - S/. 125.45 S/. 839.55
S/. 1,200 S/. 65 S/. 1,265 - 126.50 11.13 22.77 160.40 S/. 160.40 S/. 1,104.60
S/. 550 S/. 65 S/. 615 - 61.50 5.41 11.07 77.98 S/. 77.98 S/. 537.02
S/. 1,000 S/. 0 S/. 1,000 - 100.00 8.80 18.00 126.80 S/. 126.80 S/. 873.20
S/. 1,000 S/. 65 S/. 1,065 - 106.50 9.37 19.17 135.04 S/. 135.04 S/. 929.96
S/. 550 S/. 65 S/. 615 - 61.50 - - 61.50 S/. 61.50 S/. 553.50
S/. 700 S/. 65 S/. 765 - 76.50 - - 76.50 S/. 76.50 S/. 688.50
S/. 700 S/. 65 S/. 765 99.45 - - - - S/. 99.45 S/. 665.55
S/. 600 S/. 0 S/. 600 78.00 - - - - S/. 78.00 S/. 522.00
S/. 650 S/. 0 S/. 650 - 65.00 - - 65.00 S/. 65.00 S/. 585.00
S/. 650 S/. 0 S/. 650 84.50 - - - - S/. 84.50 S/. 565.50
S/. 800 S/. 0 S/. 800 - 80.00 - - 80.00 S/. 80.00 S/. 720.00
S/. 800 S/. 65 S/. 865 - 86.50 - - 86.50 S/. 86.50 S/. 778.50
S/. 1,200 S/. 65 S/. 1,265 - 126.50 - - 126.50 S/. 126.50 S/. 1,138.50
S/. 1,200 S/. 65 S/. 1,265 164.45 - - - - S/. 164.45 S/. 1,100.55
S/. 650 S/. 65 S/. 715 - 71.50 6.22 10.73 88.45 S/. 88.45 S/. 626.55
S/. 900 S/. 0 S/. 900 - 90.00 7.83 13.50 111.33 S/. 111.33 S/. 788.67
 S/. 900 S/. 0 S/. 900 117.00 - - - - S/. 117.00 S/. 783.00
S/. 1,200 S/. 0 S/. 1,200 156.00 - - - - S/. 156.00 S/. 1,044.00
S/. 1,000 S/. 65 S/. 1,065 138.45 - - - - S/. 138.45 S/. 926.55
S/. 1,000 S/. 65 S/. 1,065 - 106.50 9.27 15.98 131.74 S/. 131.74 S/. 933.26
S/. 550 S/. 0 S/. 550 71.50 - - - - S/. 71.50 S/. 478.50
S/. 550 S/. 0 S/. 550 - 55.00 4.95 10.89 70.84 S/. 70.84 S/. 479.16
S/. 550 S/. 0 S/. 550 - 55.00 4.95 10.89 70.84 S/. 70.84 S/. 479.16
S/. 550 S/. 65 S/. 615 79.95 - - - - S/. 79.95 S/. 535.05
S/. 550 S/. 65 S/. 615 79.95 - - - - S/. 79.95 S/. 535.05
S/. 550 S/. 65 S/. 615 79.95 - - - - S/. 79.95 S/. 535.05
S/. 650 S/. 65 S/. 715 - 71.50 6.44 14.16 92.09 S/. 92.09 S/. 622.91
S/. 750 S/. 65 S/. 815 - 81.50 7.09 12.23 100.82 S/. 100.82 S/. 714.18
S/. 850 S/. 65 S/. 915 - 91.50 7.96 13.73 113.19 S/. 113.19 S/. 801.81
S/. 850 S/. 0 S/. 850 - 85.00 7.48 16.58 109.06 S/. 109.06 S/. 740.95
S/. 700 S/. 0 S/. 700 91.00 - - - - S/. 91.00 S/. 609.00
S/. 700 S/. 65 S/. 765 - 76.50 6.66 11.48 94.63 S/. 94.63 S/. 670.37
 APORTES DEL
EMPLEADOR

ESSALUD SCTR
S/. 64.35 S/. 8.79
S/. 76.50 S/. 10.46
S/. 86.85 S/. 11.87
S/. 64.35 S/. 8.79
S/. 68.85 S/. 9.41
S/. 86.85 S/. 11.87
S/. 72.00 S/. 9.84
S/. 77.85 S/. 10.64
S/. 58.50 S/. 8.00
S/. 58.50 S/. 8.00
S/. 90.00 S/. 12.30
S/. 58.50 S/. 7.38
S/. 67.50 S/. 9.23
S/. 58.50 S/. 8.00
S/. 81.00 S/. 11.07
S/. 86.85 S/. 11.87
S/. 86.85 S/. 11.87
S/. 86.85 S/. 11.87
S/. 113.85 S/. 15.56
S/. 58.50 S/. 7.56
S/. 90.00 S/. 12.30
S/. 95.85 S/. 13.10
S/. 58.50 S/. 7.56
S/. 68.85 S/. 9.41
S/. 68.85 S/. 9.41
S/. 58.50 S/. 7.38
S/. 58.50 S/. 8.00
S/. 58.50 S/. 8.00
S/. 72.00 S/. 9.84
S/. 77.85 S/. 10.64
S/. 113.85 S/. 15.56
S/. 113.85 S/. 15.56
S/. 64.35 S/. 8.79
S/. 81.00 S/. 11.07
 S/. 81.00 S/. 11.07
S/. 108.00 S/. 14.76
S/. 95.85 S/. 13.10
S/. 95.85 S/. 13.10
S/. 58.50 S/. 6.77
S/. 58.50 S/. 6.77
S/. 58.50 S/. 6.77
S/. 58.50 S/. 7.56
S/. 58.50 S/. 7.56
S/. 58.50 S/. 7.56
S/. 64.35 S/. 8.79
S/. 73.35 S/. 10.02
S/. 82.35 S/. 11.25
S/. 76.50 S/. 10.46
S/. 63.00 S/. 8.61
S/. 68.85 S/. 9.41
 PLANILLA DE REMU
Mes Enero
Aplicar formato condicional de barras de datos a los netos

DATOS DEL TRABAJADOR

N EMPLEADO FEC_ING DNI TURNO CATEG ASIG FAM AFIL

1 Abanto Chavez Jesus 8/1/2007 29458745 Mañana A SI INT
2 Bendezu Moreno Ofelia 8/1/2007 29453260 Mañana A NO INT
3 Cadillo Hidalgo Pedro 4/1/2008 07818368 Mañana A SI INT
4 Cantu Mejia William 1/10/2006 29458748 Mañana A SI HOR
5 Carrasco Cuzcano Maria 1/10/2006 29458749 Tarde B SI ONP
6 Castillo Rojas Alonso 11/1/2003 29458750 Tarde B SI INT
7 Cruz Bustamente Dennis 8/23/2007 29453265 Tarde B NO PRO
8 Diaz Montes Joel 11/1/2003 29447780 Tarde B SI INT
9 Fuentes Rivera Daniel 8/23/2007 07816913 Tarde C NO ONP
10 Huanuco Almeida Ricardo 3/1/2008 07811428 Tarde C NO PRO
11 Huertas Arana Raul 3/1/2008 02073544 Tarde C NO PRI
12 Lagos Velasquez Humberto 1/10/2006 29458756 Mañana C NO ONP
13 Laos Loayza Aurelio 8/1/2007 29458757 Mañana C NO ONP
14 Cruz Fuentes Rodolfo 5/5/1999 89777777 Mañana C NO HOR
15 Flores Pizarro Juan 8/7/2000 25632574 Mañana A NO HOR
16 Godoy Arroyo Lucio 9/3/1999 25120145 Mañana A SI HOR
17 Lopez Cabello Antonio 9/5/2001 65874125 Mañana A SI HOR
18 Montesinos Lopez Karen 3/2/2001 32565874 Tarde B SI ONP
19 Rojas Gomez Paul 11/10/2001 25632541 Tarde B SI INT
20 Silva Cabezas Gabriela 5/4/2002 21025478 Tarde B SI INT
21 Velasquez Tito Johana 6/7/2002 35897410 Tarde B NO INT
22 Belleza Alvarez Victor 12/10/2003 25471102 Tarde A SI INT
23 Carrasco Aquise Omar 8/5/2003 22156987 Mañana A SI NVU
24 Castillo Mendoza Luis 9/5/2004 47851248 Mañana A SI NVU
25 Chinchay Mulatillo Juan 3/5/2004 25896541 Mañana A SI ONP
26 Chumacero Espinel Diego 9/5/2004 32658974 Mañana A NO ONP
27 Espinoza Yañez Carlos 5/3/2005 25314789 Tarde A NO NVU
28 Flores Malla Raul 4/3/2005 32561112 Tarde C NO ONP
29 Herrera Muñoz Sandro 6/6/2005 20114587 Tarde C NO NVU
30 Julian Aliaga Salomon 8/7/2005 41526398 Tarde C SI NVU
31 Pacheco Saavedra Jacob 6/1/2005 32598741 Tarde C SI NVU
32 Perez Vilchez Jose 7/3/2006 32569874 Tarde B SI ONP
33 Reyes Ysminio Milagros 5/9/2006 12457412 Mañana B SI PRI
34 Rodriguez Tolentino Luis 10/4/2006 32569741 Mañana B NO PRI
35 Roman Anaya Erick 4/4/2006 32569874 Mañana B NO ONP
36 Ruiz Suarez Armando 11/7/2006 12014785 Mañana A NO ONP
37 Campos Nuñez Renzo 1/20/2007 35214780 Mañana A SI ONP
38 Chavez Guadalupe Raul 5/12/2007 32659874 Tarde A SI PRI
39 Flores Huete Diana 8/3/2007 32014587 Tarde A NO ONP
40 Huaman Arroyo Pedro 12/12/2008 36987410 Tarde C NO PRO
41 Matos Rojas Aida 9/5/2008 56987415 Tarde C NO PRO
42 Piñashca Cashpa, Rosa 8/6/2008 25698741 Tarde C SI ONP
43 Quispe Aparco, Jhon 7/3/2008 25698741 Tarde A SI ONP
44 Trujillo Miranda, Raul 9/3/2008 23659874 Mañana A SI ONP
45 Vilcapoma Gonzales, Kevin 1/10/2009 32569874 Mañana A SI PRO
46 Villegas Campos, Juan 1/11/2011 32014587 Mañana B SI PRI
47 Huaytalla Quicara Henry 10/3/2010 23569874 Mañana B SI PRI
48 Martinez Fernandez Angela 9/4/2010 32569874 Tarde B NO HOR
49 Reyes Huacachi Reyna 7/3/2010 20123658 Tarde A NO ONP
50 Tipian Valentin Yolanda 8/9/2010 96325874 Tarde A SI PRI
NILLA DE REMUNERACIONES
Mes Enero 2017

DESCUENTOS AL TRABAJADOR

BASE DE CÁLCULO ONP AFP TOTAL

BRUTO FAMILIAR REMUN ONP AOBL PRIMA COMISION TOTAL DSCTOS NETO
S/. 650 S/. 65 S/. 715 - 71.50 6.29 12.87 90.66 S/. 90.66 S/. 624.34
S/. 850 S/. 0 S/. 850 - 85.00 7.48 15.30 107.78 S/. 107.78 S/. 742.22
S/. 900 S/. 65 S/. 965 - 96.50 8.49 17.37 122.36 S/. 122.36 S/. 842.64
S/. 650 S/. 65 S/. 715 - 71.50 6.29 13.94 91.73 S/. 91.73 S/. 623.27
S/. 700 S/. 65 S/. 765 99.45 - - - - S/. 99.45 S/. 665.55
S/. 900 S/. 65 S/. 965 - 96.50 8.49 17.37 122.36 S/. 122.36 S/. 842.64
S/. 800 S/. 0 S/. 800 - 80.00 7.20 15.84 103.04 S/. 103.04 S/. 696.96
S/. 800 S/. 65 S/. 865 - 86.50 7.61 15.57 109.68 S/. 109.68 S/. 755.32
S/. 650 S/. 0 S/. 650 84.50 - - - - S/. 84.50 S/. 565.50
S/. 650 S/. 0 S/. 650 - 65.00 5.85 12.87 83.72 S/. 83.72 S/. 566.28
S/. 1,000 S/. 0 S/. 1,000 - 100.00 8.70 15.00 123.70 S/. 123.70 S/. 876.30
S/. 600 S/. 0 S/. 600 78.00 - - - - S/. 78.00 S/. 522.00
S/. 750 S/. 0 S/. 750 97.50 - - - - S/. 97.50 S/. 652.50
S/. 650 S/. 0 S/. 650 - 65.00 5.72 12.68 83.40 S/. 83.40 S/. 566.61
S/. 900 S/. 0 S/. 900 - 90.00 7.92 17.55 115.47 S/. 115.47 S/. 784.53
S/. 900 S/. 65 S/. 965 - 96.50 8.49 18.82 123.81 S/. 123.81 S/. 841.19
S/. 900 S/. 65 S/. 965 - 96.50 8.49 18.82 123.81 S/. 123.81 S/. 841.19
S/. 900 S/. 65 S/. 965 125.45 - - - - S/. 125.45 S/. 839.55
S/. 1,200 S/. 65 S/. 1,265 - 126.50 11.13 22.77 160.40 S/. 160.40 S/. 1,104.60
S/. 550 S/. 65 S/. 615 - 61.50 5.41 11.07 77.98 S/. 77.98 S/. 537.02
S/. 1,000 S/. 0 S/. 1,000 - 100.00 8.80 18.00 126.80 S/. 126.80 S/. 873.20
S/. 1,000 S/. 65 S/. 1,065 - 106.50 9.37 19.17 135.04 S/. 135.04 S/. 929.96
S/. 550 S/. 65 S/. 615 - 61.50 - - 61.50 S/. 61.50 S/. 553.50
S/. 700 S/. 65 S/. 765 - 76.50 - - 76.50 S/. 76.50 S/. 688.50
S/. 700 S/. 65 S/. 765 99.45 - - - - S/. 99.45 S/. 665.55
S/. 600 S/. 0 S/. 600 78.00 - - - - S/. 78.00 S/. 522.00
S/. 650 S/. 0 S/. 650 - 65.00 - - 65.00 S/. 65.00 S/. 585.00
S/. 650 S/. 0 S/. 650 84.50 - - - - S/. 84.50 S/. 565.50
S/. 800 S/. 0 S/. 800 - 80.00 - - 80.00 S/. 80.00 S/. 720.00
S/. 800 S/. 65 S/. 865 - 86.50 - - 86.50 S/. 86.50 S/. 778.50
S/. 1,200 S/. 65 S/. 1,265 - 126.50 - - 126.50 S/. 126.50 S/. 1,138.50
S/. 1,200 S/. 65 S/. 1,265 164.45 - - - - S/. 164.45 S/. 1,100.55
S/. 650 S/. 65 S/. 715 - 71.50 6.22 10.73 88.45 S/. 88.45 S/. 626.55
S/. 900 S/. 0 S/. 900 - 90.00 7.83 13.50 111.33 S/. 111.33 S/. 788.67
S/. 900 S/. 0 S/. 900 117.00 - - - - S/. 117.00 S/. 783.00
S/. 1,200 S/. 0 S/. 1,200 156.00 - - - - S/. 156.00 S/. 1,044.00
S/. 1,000 S/. 65 S/. 1,065 138.45 - - - - S/. 138.45 S/. 926.55
S/. 1,000 S/. 65 S/. 1,065 - 106.50 9.27 15.98 131.74 S/. 131.74 S/. 933.26
S/. 550 S/. 0 S/. 550 71.50 - - - - S/. 71.50 S/. 478.50
S/. 550 S/. 0 S/. 550 - 55.00 4.95 10.89 70.84 S/. 70.84 S/. 479.16
S/. 550 S/. 0 S/. 550 - 55.00 4.95 10.89 70.84 S/. 70.84 S/. 479.16
S/. 550 S/. 65 S/. 615 79.95 - - - - S/. 79.95 S/. 535.05
S/. 550 S/. 65 S/. 615 79.95 - - - - S/. 79.95 S/. 535.05
S/. 550 S/. 65 S/. 615 79.95 - - - - S/. 79.95 S/. 535.05
S/. 650 S/. 65 S/. 715 - 71.50 6.44 14.16 92.09 S/. 92.09 S/. 622.91
S/. 750 S/. 65 S/. 815 - 81.50 7.09 12.23 100.82 S/. 100.82 S/. 714.18
S/. 850 S/. 65 S/. 915 - 91.50 7.96 13.73 113.19 S/. 113.19 S/. 801.81
S/. 850 S/. 0 S/. 850 - 85.00 7.48 16.58 109.06 S/. 109.06 S/. 740.95
S/. 700 S/. 0 S/. 700 91.00 - - - - S/. 91.00 S/. 609.00
S/. 700 S/. 65 S/. 765 - 76.50 6.66 11.48 94.63 S/. 94.63 S/. 670.37
 APORTES DEL
EMPLEADOR

ESSALUD SCTR
S/. 64.35 S/. 8.79
S/. 76.50 S/. 10.46
S/. 86.85 S/. 11.87
S/. 64.35 S/. 8.79
S/. 68.85 S/. 9.41
S/. 86.85 S/. 11.87
S/. 72.00 S/. 9.84
S/. 77.85 S/. 10.64
S/. 58.50 S/. 8.00
S/. 58.50 S/. 8.00
S/. 90.00 S/. 12.30
S/. 58.50 S/. 7.38
S/. 67.50 S/. 9.23
S/. 58.50 S/. 8.00
S/. 81.00 S/. 11.07
S/. 86.85 S/. 11.87
S/. 86.85 S/. 11.87
S/. 86.85 S/. 11.87
S/. 113.85 S/. 15.56
S/. 58.50 S/. 7.56
S/. 90.00 S/. 12.30
S/. 95.85 S/. 13.10
S/. 58.50 S/. 7.56
S/. 68.85 S/. 9.41
S/. 68.85 S/. 9.41
S/. 58.50 S/. 7.38
S/. 58.50 S/. 8.00
S/. 58.50 S/. 8.00
S/. 72.00 S/. 9.84
S/. 77.85 S/. 10.64
S/. 113.85 S/. 15.56
S/. 113.85 S/. 15.56
S/. 64.35 S/. 8.79
S/. 81.00 S/. 11.07
S/. 81.00 S/. 11.07
S/. 108.00 S/. 14.76
S/. 95.85 S/. 13.10
S/. 95.85 S/. 13.10
S/. 58.50 S/. 6.77
S/. 58.50 S/. 6.77
S/. 58.50 S/. 6.77
S/. 58.50 S/. 7.56
S/. 58.50 S/. 7.56
S/. 58.50 S/. 7.56
S/. 64.35 S/. 8.79
S/. 73.35 S/. 10.02
S/. 82.35 S/. 11.25
S/. 76.50 S/. 10.46
S/. 63.00 S/. 8.61
S/. 68.85 S/. 9.41
 PLANILLA DE REM
Mes Enero
Aplicar formato condicional de escala de colores verde y amarillo a la REMUN

DATOS DEL TRABAJADOR

N EMPLEADO FEC_ING DNI TURNO CATEG ASIG FAM AFIL

1 Abanto Chavez Jesus 8/1/2007 29458745 Mañana A SI INT
2 Bendezu Moreno Ofelia 8/1/2007 29453260 Mañana A NO INT
3 Cadillo Hidalgo Pedro 4/1/2008 07818368 Mañana A SI INT
4 Cantu Mejia William 1/10/2006 29458748 Mañana A SI HOR
5 Carrasco Cuzcano Maria 1/10/2006 29458749 Tarde B SI ONP
6 Castillo Rojas Alonso 11/1/2003 29458750 Tarde B SI INT
7 Cruz Bustamente Dennis 8/23/2007 29453265 Tarde B NO PRO
8 Diaz Montes Joel 11/1/2003 29447780 Tarde B SI INT
9 Fuentes Rivera Daniel 8/23/2007 07816913 Tarde C NO ONP
10 Huanuco Almeida Ricardo 3/1/2008 07811428 Tarde C NO PRO
11 Huertas Arana Raul 3/1/2008 02073544 Tarde C NO PRI
12 Lagos Velasquez Humberto 1/10/2006 29458756 Mañana C NO ONP
13 Laos Loayza Aurelio 8/1/2007 29458757 Mañana C NO ONP
14 Cruz Fuentes Rodolfo 5/5/1999 89777777 Mañana C NO HOR
15 Flores Pizarro Juan 8/7/2000 25632574 Mañana A NO HOR
16 Godoy Arroyo Lucio 9/3/1999 25120145 Mañana A SI HOR
17 Lopez Cabello Antonio 9/5/2001 65874125 Mañana A SI HOR
18 Montesinos Lopez Karen 3/2/2001 32565874 Tarde B SI ONP
19 Rojas Gomez Paul 11/10/2001 25632541 Tarde B SI INT
20 Silva Cabezas Gabriela 5/4/2002 21025478 Tarde B SI INT
21 Velasquez Tito Johana 6/7/2002 35897410 Tarde B NO INT
22 Belleza Alvarez Victor 12/10/2003 25471102 Tarde A SI INT
23 Carrasco Aquise Omar 8/5/2003 22156987 Mañana A SI NVU
24 Castillo Mendoza Luis 9/5/2004 47851248 Mañana A SI NVU
25 Chinchay Mulatillo Juan 3/5/2004 25896541 Mañana A SI ONP
26 Chumacero Espinel Diego 9/5/2004 32658974 Mañana A NO ONP
27 Espinoza Yañez Carlos 5/3/2005 25314789 Tarde A NO NVU
28 Flores Malla Raul 4/3/2005 32561112 Tarde C NO ONP
29 Herrera Muñoz Sandro 6/6/2005 20114587 Tarde C NO NVU
30 Julian Aliaga Salomon 8/7/2005 41526398 Tarde C SI NVU
31 Pacheco Saavedra Jacob 6/1/2005 32598741 Tarde C SI NVU
32 Perez Vilchez Jose 7/3/2006 32569874 Tarde B SI ONP
33 Reyes Ysminio Milagros 5/9/2006 12457412 Mañana B SI PRI
34 Rodriguez Tolentino Luis 10/4/2006 32569741 Mañana B NO PRI
35 Roman Anaya Erick 4/4/2006 32569874 Mañana B NO ONP
36 Ruiz Suarez Armando 11/7/2006 12014785 Mañana A NO ONP
37 Campos Nuñez Renzo 1/20/2007 35214780 Mañana A SI ONP
38 Chavez Guadalupe Raul 5/12/2007 32659874 Tarde A SI PRI
39 Flores Huete Diana 8/3/2007 32014587 Tarde A NO ONP
40 Huaman Arroyo Pedro 12/12/2008 36987410 Tarde C NO PRO
41 Matos Rojas Aida 9/5/2008 56987415 Tarde C NO PRO
42 Piñashca Cashpa, Rosa 8/6/2008 25698741 Tarde C SI ONP
43 Quispe Aparco, Jhon 7/3/2008 25698741 Tarde A SI ONP
44 Trujillo Miranda, Raul 9/3/2008 23659874 Mañana A SI ONP
45 Vilcapoma Gonzales, Kevin 1/10/2009 32569874 Mañana A SI PRO
46 Villegas Campos, Juan 1/11/2011 32014587 Mañana B SI PRI
47 Huaytalla Quicara Henry 10/3/2010 23569874 Mañana B SI PRI
48 Martinez Fernandez Angela 9/4/2010 32569874 Tarde B NO HOR
49 Reyes Huacachi Reyna 7/3/2010 20123658 Tarde A NO ONP
50 Tipian Valentin Yolanda 8/9/2010 96325874 Tarde A SI PRI
NILLA DE REMUNERACIONES
Mes Enero 2017

DESCUENTOS AL TRABAJADOR

BASE DE CÁLCULO ONP AFP TOTAL

BRUTO FAMILIAR REMUN ONP AOBL PRIMA COMISION TOTAL DSCTOS NETO
S/. 650 S/. 65 S/. 100 - 71.50 6.29 12.87 90.66 S/. 90.66 S/. 624.34
S/. 850 S/. 0 S/. 850 - 85.00 7.48 15.30 107.78 S/. 107.78 S/. 742.22
S/. 900 S/. 65 S/. 10 - 96.50 8.49 17.37 122.36 S/. 122.36 S/. 842.64
S/. 650 S/. 65 S/. 715 - 71.50 6.29 13.94 91.73 S/. 91.73 S/. 623.27
S/. 700 S/. 65 S/. 1,000 99.45 - - - - S/. 99.45 S/. 665.55
S/. 900 S/. 65 S/. 500 - 96.50 8.49 17.37 122.36 S/. 122.36 S/. 842.64
S/. 800 S/. 0 S/. 2,500 - 80.00 7.20 15.84 103.04 S/. 103.04 S/. 696.96
S/. 800 S/. 65 S/. 4,500 - 86.50 7.61 15.57 109.68 S/. 109.68 S/. 755.32
S/. 650 S/. 0 S/. 650 84.50 - - - - S/. 84.50 S/. 565.50
S/. 650 S/. 0 S/. 5,000 - 65.00 5.85 12.87 83.72 S/. 83.72 S/. 566.28
S/. 1,000 S/. 0 S/. 1,000 - 100.00 8.70 15.00 123.70 S/. 123.70 S/. 876.30
S/. 600 S/. 0 S/. 600 78.00 - - - - S/. 78.00 S/. 522.00
S/. 750 S/. 0 S/. 750 97.50 - - - - S/. 97.50 S/. 652.50
S/. 650 S/. 0 S/. 650 - 65.00 5.72 12.68 83.40 S/. 83.40 S/. 566.61
S/. 900 S/. 0 S/. 900 - 90.00 7.92 17.55 115.47 S/. 115.47 S/. 784.53
S/. 900 S/. 65 S/. 965 - 96.50 8.49 18.82 123.81 S/. 123.81 S/. 841.19
S/. 900 S/. 65 S/. 965 - 96.50 8.49 18.82 123.81 S/. 123.81 S/. 841.19
S/. 900 S/. 65 S/. 965 125.45 - - - - S/. 125.45 S/. 839.55
S/. 1,200 S/. 65 S/. 1,265 - 126.50 11.13 22.77 160.40 S/. 160.40 S/. 1,104.60
S/. 550 S/. 65 S/. 615 - 61.50 5.41 11.07 77.98 S/. 77.98 S/. 537.02
S/. 1,000 S/. 0 S/. 1,000 - 100.00 8.80 18.00 126.80 S/. 126.80 S/. 873.20
S/. 1,000 S/. 65 S/. 1,065 - 106.50 9.37 19.17 135.04 S/. 135.04 S/. 929.96
S/. 550 S/. 65 S/. 615 - 61.50 - - 61.50 S/. 61.50 S/. 553.50
S/. 700 S/. 65 S/. 765 - 76.50 - - 76.50 S/. 76.50 S/. 688.50
S/. 700 S/. 65 S/. 765 99.45 - - - - S/. 99.45 S/. 665.55
S/. 600 S/. 0 S/. 600 78.00 - - - - S/. 78.00 S/. 522.00
S/. 650 S/. 0 S/. 650 - 65.00 - - 65.00 S/. 65.00 S/. 585.00
S/. 650 S/. 0 S/. 650 84.50 - - - - S/. 84.50 S/. 565.50
S/. 800 S/. 0 S/. 800 - 80.00 - - 80.00 S/. 80.00 S/. 720.00
S/. 800 S/. 65 S/. 865 - 86.50 - - 86.50 S/. 86.50 S/. 778.50
S/. 1,200 S/. 65 S/. 1,265 - 126.50 - - 126.50 S/. 126.50 S/. 1,138.50
S/. 1,200 S/. 65 S/. 1,265 164.45 - - - - S/. 164.45 S/. 1,100.55
S/. 650 S/. 65 S/. 715 - 71.50 6.22 10.73 88.45 S/. 88.45 S/. 626.55
S/. 900 S/. 0 S/. 900 - 90.00 7.83 13.50 111.33 S/. 111.33 S/. 788.67
S/. 900 S/. 0 S/. 900 117.00 - - - - S/. 117.00 S/. 783.00
S/. 1,200 S/. 0 S/. 1,200 156.00 - - - - S/. 156.00 S/. 1,044.00
S/. 1,000 S/. 65 S/. 1,065 138.45 - - - - S/. 138.45 S/. 926.55
S/. 1,000 S/. 65 S/. 1,065 - 106.50 9.27 15.98 131.74 S/. 131.74 S/. 933.26
S/. 550 S/. 0 S/. 550 71.50 - - - - S/. 71.50 S/. 478.50
S/. 550 S/. 0 S/. 550 - 55.00 4.95 10.89 70.84 S/. 70.84 S/. 479.16
S/. 550 S/. 0 S/. 550 - 55.00 4.95 10.89 70.84 S/. 70.84 S/. 479.16
S/. 550 S/. 65 S/. 615 79.95 - - - - S/. 79.95 S/. 535.05
S/. 550 S/. 65 S/. 615 79.95 - - - - S/. 79.95 S/. 535.05
S/. 550 S/. 65 S/. 615 79.95 - - - - S/. 79.95 S/. 535.05
S/. 650 S/. 65 S/. 715 - 71.50 6.44 14.16 92.09 S/. 92.09 S/. 622.91
S/. 750 S/. 65 S/. 815 - 81.50 7.09 12.23 100.82 S/. 100.82 S/. 714.18
S/. 850 S/. 65 S/. 915 - 91.50 7.96 13.73 113.19 S/. 113.19 S/. 801.81
S/. 850 S/. 0 S/. 850 - 85.00 7.48 16.58 109.06 S/. 109.06 S/. 740.95
S/. 700 S/. 0 S/. 700 91.00 - - - - S/. 91.00 S/. 609.00
S/. 700 S/. 65 S/. 765 - 76.50 6.66 11.48 94.63 S/. 94.63 S/. 670.37
 APORTES DEL
EMPLEADOR

ESSALUD SCTR
S/. 64.35 S/. 8.79
S/. 76.50 S/. 10.46
S/. 86.85 S/. 11.87
S/. 64.35 S/. 8.79
S/. 68.85 S/. 9.41
S/. 86.85 S/. 11.87
S/. 72.00 S/. 9.84
S/. 77.85 S/. 10.64
S/. 58.50 S/. 8.00
S/. 58.50 S/. 8.00
S/. 90.00 S/. 12.30
S/. 58.50 S/. 7.38
S/. 67.50 S/. 9.23
S/. 58.50 S/. 8.00
S/. 81.00 S/. 11.07
S/. 86.85 S/. 11.87
S/. 86.85 S/. 11.87
S/. 86.85 S/. 11.87
S/. 113.85 S/. 15.56
S/. 58.50 S/. 7.56
S/. 90.00 S/. 12.30
S/. 95.85 S/. 13.10
S/. 58.50 S/. 7.56
S/. 68.85 S/. 9.41
S/. 68.85 S/. 9.41
S/. 58.50 S/. 7.38
S/. 58.50 S/. 8.00
S/. 58.50 S/. 8.00
S/. 72.00 S/. 9.84
S/. 77.85 S/. 10.64
S/. 113.85 S/. 15.56
S/. 113.85 S/. 15.56
S/. 64.35 S/. 8.79
S/. 81.00 S/. 11.07
S/. 81.00 S/. 11.07
S/. 108.00 S/. 14.76
S/. 95.85 S/. 13.10
S/. 95.85 S/. 13.10
S/. 58.50 S/. 6.77
S/. 58.50 S/. 6.77
S/. 58.50 S/. 6.77
S/. 58.50 S/. 7.56
S/. 58.50 S/. 7.56
S/. 58.50 S/. 7.56
S/. 64.35 S/. 8.79
S/. 73.35 S/. 10.02
S/. 82.35 S/. 11.25
S/. 76.50 S/. 10.46
S/. 63.00 S/. 8.61
S/. 68.85 S/. 9.41
 PLANILLA DE RE
Mes En
Aplicar formato condicional de conjunto de iconos al Total de descuentos

DATOS DEL TRABAJADOR

N EMPLEADO FEC_ING DNI TURNO CATEG ASIG FAM AFIL

1 Abanto Chavez Jesus 8/1/2007 29458745 Mañana A SI INT
2 Bendezu Moreno Ofelia 8/1/2007 29453260 Mañana A NO INT
3 Cadillo Hidalgo Pedro 4/1/2008 07818368 Mañana A SI INT
4 Cantu Mejia William 1/10/2006 29458748 Mañana A SI HOR
5 Carrasco Cuzcano Maria 1/10/2006 29458749 Tarde B SI ONP
6 Castillo Rojas Alonso 11/1/2003 29458750 Tarde B SI INT
7 Cruz Bustamente Dennis 8/23/2007 29453265 Tarde B NO PRO
8 Diaz Montes Joel 11/1/2003 29447780 Tarde B SI INT
9 Fuentes Rivera Daniel 8/23/2007 07816913 Tarde C NO ONP
10 Huanuco Almeida Ricardo 3/1/2008 07811428 Tarde C NO PRO
11 Huertas Arana Raul 3/1/2008 02073544 Tarde C NO PRI
12 Lagos Velasquez Humberto 1/10/2006 29458756 Mañana C NO ONP
13 Laos Loayza Aurelio 8/1/2007 29458757 Mañana C NO ONP
14 Cruz Fuentes Rodolfo 5/5/1999 89777777 Mañana C NO HOR
15 Flores Pizarro Juan 8/7/2000 25632574 Mañana A NO HOR
16 Godoy Arroyo Lucio 9/3/1999 25120145 Mañana A SI HOR
17 Lopez Cabello Antonio 9/5/2001 65874125 Mañana A SI HOR
18 Montesinos Lopez Karen 3/2/2001 32565874 Tarde B SI ONP
19 Rojas Gomez Paul 11/10/2001 25632541 Tarde B SI INT
20 Silva Cabezas Gabriela 5/4/2002 21025478 Tarde B SI INT
21 Velasquez Tito Johana 6/7/2002 35897410 Tarde B NO INT
22 Belleza Alvarez Victor 12/10/2003 25471102 Tarde A SI INT
23 Carrasco Aquise Omar 8/5/2003 22156987 Mañana A SI NVU
24 Castillo Mendoza Luis 9/5/2004 47851248 Mañana A SI NVU
25 Chinchay Mulatillo Juan 3/5/2004 25896541 Mañana A SI ONP
26 Chumacero Espinel Diego 9/5/2004 32658974 Mañana A NO ONP
27 Espinoza Yañez Carlos 5/3/2005 25314789 Tarde A NO NVU
28 Flores Malla Raul 4/3/2005 32561112 Tarde C NO ONP
29 Herrera Muñoz Sandro 6/6/2005 20114587 Tarde C NO NVU
30 Julian Aliaga Salomon 8/7/2005 41526398 Tarde C SI NVU
31 Pacheco Saavedra Jacob 6/1/2005 32598741 Tarde C SI NVU
32 Perez Vilchez Jose 7/3/2006 32569874 Tarde B SI ONP
33 Reyes Ysminio Milagros 5/9/2006 12457412 Mañana B SI PRI
34 Rodriguez Tolentino Luis 10/4/2006 32569741 Mañana B NO PRI
35 Roman Anaya Erick 4/4/2006 32569874 Mañana B NO ONP
36 Ruiz Suarez Armando 11/7/2006 12014785 Mañana A NO ONP
37 Campos Nuñez Renzo 1/20/2007 35214780 Mañana A SI ONP
38 Chavez Guadalupe Raul 5/12/2007 32659874 Tarde A SI PRI
39 Flores Huete Diana 8/3/2007 32014587 Tarde A NO ONP
40 Huaman Arroyo Pedro 12/12/2008 36987410 Tarde C NO PRO
41 Matos Rojas Aida 9/5/2008 56987415 Tarde C NO PRO
42 Piñashca Cashpa, Rosa 8/6/2008 25698741 Tarde C SI ONP
43 Quispe Aparco, Jhon 7/3/2008 25698741 Tarde A SI ONP
44 Trujillo Miranda, Raul 9/3/2008 23659874 Mañana A SI ONP
45 Vilcapoma Gonzales, Kevin 1/10/2009 32569874 Mañana A SI PRO
46 Villegas Campos, Juan 1/11/2011 32014587 Mañana B SI PRI
47 Huaytalla Quicara Henry 10/3/2010 23569874 Mañana B SI PRI
48 Martinez Fernandez Angela 9/4/2010 32569874 Tarde B NO HOR
49 Reyes Huacachi Reyna 7/3/2010 20123658 Tarde A NO ONP
50 Tipian Valentin Yolanda 8/9/2010 96325874 Tarde A SI PRI
ANILLA DE REMUNERACIONES
Mes Enero 2017

DESCUENTOS AL TRABAJADOR

BASE DE CÁLCULO ONP AFP TOTAL

BRUTO FAMILIAR REMUN ONP AOBL PRIMA COMISION TOTAL DSCTOS

S/. 650 S/. 65 S/. 715 - 71.50 6.29 12.87 90.66 S/. 500.00
S/. 850 S/. 0 S/. 850 - 85.00 7.48 15.30 107.78 S/. 107.78
S/. 900 S/. 65 S/. 965 - 96.50 8.49 17.37 122.36 S/. 122.36
S/. 650 S/. 65 S/. 715 - 71.50 6.29 13.94 91.73 S/. 91.73
S/. 700 S/. 65 S/. 765 99.45 - - - - S/. 99.45
S/. 900 S/. 65 S/. 965 - 96.50 8.49 17.37 122.36 S/. 300.00
S/. 800 S/. 0 S/. 800 - 80.00 7.20 15.84 103.04 S/. 400.00
S/. 800 S/. 65 S/. 865 - 86.50 7.61 15.57 109.68 S/. 109.68
S/. 650 S/. 0 S/. 650 84.50 - - - - S/. 84.50
S/. 650 S/. 0 S/. 650 - 65.00 5.85 12.87 83.72 S/. 83.72
S/. 1,000 S/. 0 S/. 1,000 - 100.00 8.70 15.00 123.70 S/. 123.70
S/. 600 S/. 0 S/. 600 78.00 - - - - S/. 78.00
S/. 750 S/. 0 S/. 750 97.50 - - - - S/. 97.50
S/. 650 S/. 0 S/. 650 - 65.00 5.72 12.68 83.40 S/. 83.40
S/. 900 S/. 0 S/. 900 - 90.00 7.92 17.55 115.47 S/. 115.47
S/. 900 S/. 65 S/. 965 - 96.50 8.49 18.82 123.81 S/. 123.81
S/. 900 S/. 65 S/. 965 - 96.50 8.49 18.82 123.81 S/. 123.81
S/. 900 S/. 65 S/. 965 125.45 - - - - S/. 125.45
S/. 1,200 S/. 65 S/. 1,265 - 126.50 11.13 22.77 160.40 S/. 160.40
S/. 550 S/. 65 S/. 615 - 61.50 5.41 11.07 77.98 S/. 77.98
S/. 1,000 S/. 0 S/. 1,000 - 100.00 8.80 18.00 126.80 S/. 126.80
S/. 1,000 S/. 65 S/. 1,065 - 106.50 9.37 19.17 135.04 S/. 135.04
S/. 550 S/. 65 S/. 615 - 61.50 - - 61.50 S/. 61.50
S/. 700 S/. 65 S/. 765 - 76.50 - - 76.50 S/. 76.50
S/. 700 S/. 65 S/. 765 99.45 - - - - S/. 99.45
S/. 600 S/. 0 S/. 600 78.00 - - - - S/. 78.00
S/. 650 S/. 0 S/. 650 - 65.00 - - 65.00 S/. 65.00
S/. 650 S/. 0 S/. 650 84.50 - - - - S/. 84.50
S/. 800 S/. 0 S/. 800 - 80.00 - - 80.00 S/. 80.00
S/. 800 S/. 65 S/. 865 - 86.50 - - 86.50 S/. 86.50
S/. 1,200 S/. 65 S/. 1,265 - 126.50 - - 126.50 S/. 126.50
S/. 1,200 S/. 65 S/. 1,265 164.45 - - - - S/. 164.45
S/. 650 S/. 65 S/. 715 - 71.50 6.22 10.73 88.45 S/. 88.45
S/. 900 S/. 0 S/. 900 - 90.00 7.83 13.50 111.33 S/. 111.33
S/. 900 S/. 0 S/. 900 117.00 - - - - S/. 117.00
S/. 1,200 S/. 0 S/. 1,200 156.00 - - - - S/. 156.00
S/. 1,000 S/. 65 S/. 1,065 138.45 - - - - S/. 138.45
S/. 1,000 S/. 65 S/. 1,065 - 106.50 9.27 15.98 131.74 S/. 131.74
S/. 550 S/. 0 S/. 550 71.50 - - - - S/. 71.50
S/. 550 S/. 0 S/. 550 - 55.00 4.95 10.89 70.84 S/. 70.84
S/. 550 S/. 0 S/. 550 - 55.00 4.95 10.89 70.84 S/. 70.84
S/. 550 S/. 65 S/. 615 79.95 - - - - S/. 79.95
S/. 550 S/. 65 S/. 615 79.95 - - - - S/. 79.95
S/. 550 S/. 65 S/. 615 79.95 - - - - S/. 79.95
S/. 650 S/. 65 S/. 715 - 71.50 6.44 14.16 92.09 S/. 92.09
S/. 750 S/. 65 S/. 815 - 81.50 7.09 12.23 100.82 S/. 100.82
S/. 850 S/. 65 S/. 915 - 91.50 7.96 13.73 113.19 S/. 113.19
S/. 850 S/. 0 S/. 850 - 85.00 7.48 16.58 109.06 S/. 109.06
S/. 700 S/. 0 S/. 700 91.00 - - - - S/. 91.00
S/. 700 S/. 65 S/. 765 - 76.50 6.66 11.48 94.63 S/. 94.63
 APORTES DEL
EMPLEADOR

NETO ESSALUD SCTR

S/. 624.34 S/. 64.35 S/. 8.79
S/. 742.22 S/. 76.50 S/. 10.46
S/. 842.64 S/. 86.85 S/. 11.87
S/. 623.27 S/. 64.35 S/. 8.79
S/. 665.55 S/. 68.85 S/. 9.41
S/. 842.64 S/. 86.85 S/. 11.87
S/. 696.96 S/. 72.00 S/. 9.84
S/. 755.32 S/. 77.85 S/. 10.64
S/. 565.50 S/. 58.50 S/. 8.00
S/. 566.28 S/. 58.50 S/. 8.00
S/. 876.30 S/. 90.00 S/. 12.30
S/. 522.00 S/. 58.50 S/. 7.38
S/. 652.50 S/. 67.50 S/. 9.23
S/. 566.61 S/. 58.50 S/. 8.00
S/. 784.53 S/. 81.00 S/. 11.07
S/. 841.19 S/. 86.85 S/. 11.87
S/. 841.19 S/. 86.85 S/. 11.87
S/. 839.55 S/. 86.85 S/. 11.87
S/. 1,104.60 S/. 113.85 S/. 15.56
S/. 537.02 S/. 58.50 S/. 7.56
S/. 873.20 S/. 90.00 S/. 12.30
S/. 929.96 S/. 95.85 S/. 13.10
S/. 553.50 S/. 58.50 S/. 7.56
S/. 688.50 S/. 68.85 S/. 9.41
S/. 665.55 S/. 68.85 S/. 9.41
S/. 522.00 S/. 58.50 S/. 7.38
S/. 585.00 S/. 58.50 S/. 8.00
S/. 565.50 S/. 58.50 S/. 8.00
S/. 720.00 S/. 72.00 S/. 9.84
S/. 778.50 S/. 77.85 S/. 10.64
S/. 1,138.50 S/. 113.85 S/. 15.56
S/. 1,100.55 S/. 113.85 S/. 15.56
S/. 626.55 S/. 64.35 S/. 8.79
S/. 788.67 S/. 81.00 S/. 11.07
S/. 783.00 S/. 81.00 S/. 11.07
S/. 1,044.00 S/. 108.00 S/. 14.76
S/. 926.55 S/. 95.85 S/. 13.10
S/. 933.26 S/. 95.85 S/. 13.10
S/. 478.50 S/. 58.50 S/. 6.77
S/. 479.16 S/. 58.50 S/. 6.77
S/. 479.16 S/. 58.50 S/. 6.77
S/. 535.05 S/. 58.50 S/. 7.56
S/. 535.05 S/. 58.50 S/. 7.56
S/. 535.05 S/. 58.50 S/. 7.56
S/. 622.91 S/. 64.35 S/. 8.79
S/. 714.18 S/. 73.35 S/. 10.02
S/. 801.81 S/. 82.35 S/. 11.25
S/. 740.95 S/. 76.50 S/. 10.46
S/. 609.00 S/. 63.00 S/. 8.61
S/. 670.37 S/. 68.85 S/. 9.41
 PLANILLA DE REM
Mes Ener

Aplicar formato condicional con fórmulas a los Netos de los trabajadores de las categorías A ó B

DATOS DEL TRABAJADOR

N EMPLEADO FEC_ING DNI TURNO CATEG ASIG FAM AFIL

1 Abanto Chavez Jesus 8/1/2007 29458745 Mañana C SI INT
2 Bendezu Moreno Ofelia 8/1/2007 29453260 Mañana A NO INT
3 Cadillo Hidalgo Pedro 4/1/2008 07818368 Mañana B SI INT
4 Cantu Mejia William 1/10/2006 29458748 Mañana A SI HOR
5 Carrasco Cuzcano Maria 1/10/2006 29458749 Tarde B SI ONP
6 Castillo Rojas Alonso 11/1/2003 29458750 Tarde B SI INT
7 Cruz Bustamente Dennis 8/23/2007 29453265 Tarde B NO PRO
8 Diaz Montes Joel 11/1/2003 29447780 Tarde C SI INT
9 Fuentes Rivera Daniel 8/23/2007 07816913 Tarde C NO ONP
10 Huanuco Almeida Ricardo 3/1/2008 07811428 Tarde C NO PRO
11 Huertas Arana Raul 3/1/2008 02073544 Tarde A NO PRI
12 Lagos Velasquez Humberto 1/10/2006 29458756 Mañana A NO ONP
13 Laos Loayza Aurelio 8/1/2007 29458757 Mañana C NO ONP
14 Cruz Fuentes Rodolfo 5/5/1999 89777777 Mañana C NO HOR
15 Flores Pizarro Juan 8/7/2000 25632574 Mañana A NO HOR
16 Godoy Arroyo Lucio 9/3/1999 25120145 Mañana A SI HOR
17 Lopez Cabello Antonio 9/5/2001 65874125 Mañana A SI HOR
18 Montesinos Lopez Karen 3/2/2001 32565874 Tarde B SI ONP
19 Rojas Gomez Paul 11/10/2001 25632541 Tarde B SI INT
20 Silva Cabezas Gabriela 5/4/2002 21025478 Tarde C SI INT
21 Velasquez Tito Johana 6/7/2002 35897410 Tarde C NO INT
22 Belleza Alvarez Victor 12/10/2003 25471102 Tarde C SI INT
23 Carrasco Aquise Omar 8/5/2003 22156987 Mañana A SI NVU
24 Castillo Mendoza Luis 9/5/2004 47851248 Mañana A SI NVU
25 Chinchay Mulatillo Juan 3/5/2004 25896541 Mañana A SI ONP
26 Chumacero Espinel Diego 9/5/2004 32658974 Mañana A NO ONP
27 Espinoza Yañez Carlos 5/3/2005 25314789 Tarde B NO NVU
28 Flores Malla Raul 4/3/2005 32561112 Tarde C NO ONP
29 Herrera Muñoz Sandro 6/6/2005 20114587 Tarde C NO NVU
30 Julian Aliaga Salomon 8/7/2005 41526398 Tarde C SI NVU
31 Pacheco Saavedra Jacob 6/1/2005 32598741 Tarde C SI NVU
32 Perez Vilchez Jose 7/3/2006 32569874 Tarde B SI ONP
33 Reyes Ysminio Milagros 5/9/2006 12457412 Mañana B SI PRI
34 Rodriguez Tolentino Luis 10/4/2006 32569741 Mañana B NO PRI
35 Roman Anaya Erick 4/4/2006 32569874 Mañana B NO ONP
36 Ruiz Suarez Armando 11/7/2006 12014785 Mañana A NO ONP
37 Campos Nuñez Renzo 1/20/2007 35214780 Mañana A SI ONP
38 Chavez Guadalupe Raul 5/12/2007 32659874 Tarde A SI PRI
39 Flores Huete Diana 8/3/2007 32014587 Tarde A NO ONP
40 Huaman Arroyo Pedro 12/12/2008 36987410 Tarde C NO PRO
41 Matos Rojas Aida 9/5/2008 56987415 Tarde C NO PRO
42 Piñashca Cashpa, Rosa 8/6/2008 25698741 Tarde C SI ONP
43 Quispe Aparco, Jhon 7/3/2008 25698741 Tarde A SI ONP
44 Trujillo Miranda, Raul 9/3/2008 23659874 Mañana A SI ONP
45 Vilcapoma Gonzales, Kevin 1/10/2009 32569874 Mañana C SI PRO
46 Villegas Campos, Juan 1/11/2011 32014587 Mañana C SI PRI
47 Huaytalla Quicara Henry 10/3/2010 23569874 Mañana B SI PRI
48 Martinez Fernandez Angela 9/4/2010 32569874 Tarde C NO HOR
49 Reyes Huacachi Reyna 7/3/2010 20123658 Tarde A NO ONP
50 Tipian Valentin Yolanda 8/9/2010 96325874 Tarde A SI PRI
NILLA DE REMUNERACIONES
Mes Enero 2017

AóB
DESCUENTOS AL TRABAJADOR

BASE DE CÁLCULO ONP AFP TOTAL

BRUTO FAMILIAR REMUN ONP AOBL PRIMA COMISION TOTAL DSCTOS NETO
S/. 650 S/. 65 S/. 715 - 71.50 6.29 12.87 90.66 S/. 90.66 S/. 624.34
S/. 850 S/. 0 S/. 850 - 85.00 7.48 15.30 107.78 S/. 107.78 S/. 742.22
S/. 900 S/. 65 S/. 965 - 96.50 8.49 17.37 122.36 S/. 122.36 S/. 842.64
S/. 650 S/. 65 S/. 715 - 71.50 6.29 13.94 91.73 S/. 91.73 S/. 623.27
S/. 700 S/. 65 S/. 765 99.45 - - - - S/. 99.45 S/. 665.55
S/. 900 S/. 65 S/. 965 - 96.50 8.49 17.37 122.36 S/. 122.36 S/. 842.64
S/. 800 S/. 0 S/. 800 - 80.00 7.20 15.84 103.04 S/. 103.04 S/. 696.96
S/. 800 S/. 65 S/. 865 - 86.50 7.61 15.57 109.68 S/. 109.68 S/. 755.32
S/. 650 S/. 0 S/. 650 84.50 - - - - S/. 84.50 S/. 565.50
S/. 650 S/. 0 S/. 650 - 65.00 5.85 12.87 83.72 S/. 83.72 S/. 566.28
S/. 1,000 S/. 0 S/. 1,000 - 100.00 8.70 15.00 123.70 S/. 123.70 S/. 876.30
S/. 600 S/. 0 S/. 600 78.00 - - - - S/. 78.00 S/. 522.00
S/. 750 S/. 0 S/. 750 97.50 - - - - S/. 97.50 S/. 652.50
S/. 650 S/. 0 S/. 650 - 65.00 5.72 12.68 83.40 S/. 83.40 S/. 566.61
S/. 900 S/. 0 S/. 900 - 90.00 7.92 17.55 115.47 S/. 115.47 S/. 784.53
S/. 900 S/. 65 S/. 965 - 96.50 8.49 18.82 123.81 S/. 123.81 S/. 841.19
S/. 900 S/. 65 S/. 965 - 96.50 8.49 18.82 123.81 S/. 123.81 S/. 841.19
S/. 900 S/. 65 S/. 965 125.45 - - - - S/. 125.45 S/. 839.55
S/. 1,200 S/. 65 S/. 1,265 - 126.50 11.13 22.77 160.40 S/. 160.40 S/. 1,104.60
S/. 550 S/. 65 S/. 615 - 61.50 5.41 11.07 77.98 S/. 77.98 S/. 537.02
S/. 1,000 S/. 0 S/. 1,000 - 100.00 8.80 18.00 126.80 S/. 126.80 S/. 873.20
S/. 1,000 S/. 65 S/. 1,065 - 106.50 9.37 19.17 135.04 S/. 135.04 S/. 929.96
S/. 550 S/. 65 S/. 615 - 61.50 - - 61.50 S/. 61.50 S/. 553.50
S/. 700 S/. 65 S/. 765 - 76.50 - - 76.50 S/. 76.50 S/. 688.50
S/. 700 S/. 65 S/. 765 99.45 - - - - S/. 99.45 S/. 665.55
S/. 600 S/. 0 S/. 600 78.00 - - - - S/. 78.00 S/. 522.00
S/. 650 S/. 0 S/. 650 - 65.00 - - 65.00 S/. 65.00 S/. 585.00
S/. 650 S/. 0 S/. 650 84.50 - - - - S/. 84.50 S/. 565.50
S/. 800 S/. 0 S/. 800 - 80.00 - - 80.00 S/. 80.00 S/. 720.00
S/. 800 S/. 65 S/. 865 - 86.50 - - 86.50 S/. 86.50 S/. 778.50
S/. 1,200 S/. 65 S/. 1,265 - 126.50 - - 126.50 S/. 126.50 S/. 1,138.50
S/. 1,200 S/. 65 S/. 1,265 164.45 - - - - S/. 164.45 S/. 1,100.55
S/. 650 S/. 65 S/. 715 - 71.50 6.22 10.73 88.45 S/. 88.45 S/. 626.55
S/. 900 S/. 0 S/. 900 - 90.00 7.83 13.50 111.33 S/. 111.33 S/. 788.67
S/. 900 S/. 0 S/. 900 117.00 - - - - S/. 117.00 S/. 783.00
S/. 1,200 S/. 0 S/. 1,200 156.00 - - - - S/. 156.00 S/. 1,044.00
S/. 1,000 S/. 65 S/. 1,065 138.45 - - - - S/. 138.45 S/. 926.55
S/. 1,000 S/. 65 S/. 1,065 - 106.50 9.27 15.98 131.74 S/. 131.74 S/. 933.26
S/. 550 S/. 0 S/. 550 71.50 - - - - S/. 71.50 S/. 478.50
S/. 550 S/. 0 S/. 550 - 55.00 4.95 10.89 70.84 S/. 70.84 S/. 479.16
S/. 550 S/. 0 S/. 550 - 55.00 4.95 10.89 70.84 S/. 70.84 S/. 479.16
S/. 550 S/. 65 S/. 615 79.95 - - - - S/. 79.95 S/. 535.05
S/. 550 S/. 65 S/. 615 79.95 - - - - S/. 79.95 S/. 535.05
S/. 550 S/. 65 S/. 615 79.95 - - - - S/. 79.95 S/. 535.05
S/. 650 S/. 65 S/. 715 - 71.50 6.44 14.16 92.09 S/. 92.09 S/. 622.91
S/. 750 S/. 65 S/. 815 - 81.50 7.09 12.23 100.82 S/. 100.82 S/. 714.18
S/. 850 S/. 65 S/. 915 - 91.50 7.96 13.73 113.19 S/. 113.19 S/. 801.81
S/. 850 S/. 0 S/. 850 - 85.00 7.48 16.58 109.06 S/. 109.06 S/. 740.95
S/. 700 S/. 0 S/. 700 91.00 - - - - S/. 91.00 S/. 609.00
S/. 700 S/. 65 S/. 765 - 76.50 6.66 11.48 94.63 S/. 94.63 S/. 670.37
 APORTES DEL
EMPLEADOR

ESSALUD SCTR
S/. 64.35 S/. 8.79
S/. 76.50 S/. 10.46
S/. 86.85 S/. 11.87
S/. 64.35 S/. 8.79
S/. 68.85 S/. 9.41
S/. 86.85 S/. 11.87
S/. 72.00 S/. 9.84
S/. 77.85 S/. 10.64
S/. 58.50 S/. 8.00
S/. 58.50 S/. 8.00
S/. 90.00 S/. 12.30
S/. 58.50 S/. 7.38
S/. 67.50 S/. 9.23
S/. 58.50 S/. 8.00
S/. 81.00 S/. 11.07
S/. 86.85 S/. 11.87
S/. 86.85 S/. 11.87
S/. 86.85 S/. 11.87
S/. 113.85 S/. 15.56
S/. 58.50 S/. 7.56
S/. 90.00 S/. 12.30
S/. 95.85 S/. 13.10
S/. 58.50 S/. 7.56
S/. 68.85 S/. 9.41
S/. 68.85 S/. 9.41
S/. 58.50 S/. 7.38
S/. 58.50 S/. 8.00
S/. 58.50 S/. 8.00
S/. 72.00 S/. 9.84
S/. 77.85 S/. 10.64
S/. 113.85 S/. 15.56
S/. 113.85 S/. 15.56
S/. 64.35 S/. 8.79
S/. 81.00 S/. 11.07
S/. 81.00 S/. 11.07
S/. 108.00 S/. 14.76
S/. 95.85 S/. 13.10
S/. 95.85 S/. 13.10
S/. 58.50 S/. 6.77
S/. 58.50 S/. 6.77
S/. 58.50 S/. 6.77
S/. 58.50 S/. 7.56
S/. 58.50 S/. 7.56
S/. 58.50 S/. 7.56
S/. 64.35 S/. 8.79
S/. 73.35 S/. 10.02
S/. 82.35 S/. 11.25
S/. 76.50 S/. 10.46
S/. 63.00 S/. 8.61
S/. 68.85 S/. 9.41
 PLANILLA DE R
Mes E
Aplicar formato de estilo de tabla (medio 2) a la siguiente planilla:

DATOS DEL TRABAJADOR

N EMPLEADO FEC_ING TURNO CATEG ASIG FAM AFIL

1 Abanto Chavez Jesus 39295 Mañana A SI INT
2 Bendezu Moreno Ofelia 39295 Mañana A NO INT
3 Cadillo Hidalgo Pedro 39539 Mañana A SI INT
4 Cantu Mejia William 38727 Mañana A SI HOR
5 Carrasco Cuzcano Maria 38727 Tarde B SI ONP
6 Castillo Rojas Alonso 37926 Tarde B SI INT
7 Cruz Bustamente Dennis 39317 Tarde B NO PRO
8 Diaz Montes Joel 37926 Tarde B SI INT
9 Fuentes Rivera Daniel 39317 Tarde C NO ONP
10 Huanuco Almeida Ricardo 39508 Tarde C NO PRO
11 Huertas Arana Raul 39508 Tarde C NO PRI
12 Lagos Velasquez Humberto 38727 Mañana C NO ONP
13 Laos Loayza Aurelio 39295 Mañana C NO ONP
14 Cruz Fuentes Rodolfo 36285 Mañana C NO HOR
15 Flores Pizarro Juan 36745 Mañana A NO HOR
16 Godoy Arroyo Lucio 36406 Mañana A SI HOR
17 Lopez Cabello Antonio 37139 Mañana A SI HOR
18 Montesinos Lopez Karen 36952 Tarde B SI ONP
19 Rojas Gomez Paul 37205 Tarde B SI INT
20 Silva Cabezas Gabriela 37380 Tarde B SI INT
PLANILLA DE REMUNERACIONES
Mes Enero 2017

DESCUENTOS AL TRABAJADOR

BASE DE CÁLCULO ONP AFP TOTAL

BRUTO FAM. REMUN ONP AOBL PRIMA COMISION TOTAL DSCTOS

650 65 715 0 71.5 6.292 12.87 90.662 90.662
850 0 850 0 85 7.48 15.3 107.78 107.78
900 65 965 0 96.5 8.492 17.37 122.362 122.362
650 65 715 0 71.5 6.292 13.9425 91.7345 91.7345
700 65 765 99.45 0 0 0 0 99.45
900 65 965 0 96.5 8.492 17.37 122.362 122.362
800 0 800 0 80 7.2 15.84 103.04 103.04
800 65 865 0 86.5 7.612 15.57 109.682 109.682
650 0 650 84.5 0 0 0 0 84.5
650 0 650 0 65 5.85 12.87 83.72 83.72
1000 0 1000 0 100 8.7 15 123.7 123.7
600 0 600 78 0 0 0 0 78
750 0 750 97.5 0 0 0 0 97.5
650 0 650 0 65 5.72 12.675 83.395 83.395
900 0 900 0 90 7.92 17.55 115.47 115.47
900 65 965 0 96.5 8.492 18.8175 123.8095 123.8095
900 65 965 0 96.5 8.492 18.8175 123.8095 123.8095
900 65 965 125.45 0 0 0 0 125.45
1200 65 1265 0 126.5 11.132 22.77 160.402 160.402
550 65 615 0 61.5 5.412 11.07 77.982 77.982
 APORTES DEL EMPLEADOR

NETO ESSALUD SCTR

624.338 64.35 8.7945
742.22 76.5 10.455
842.638 86.85 11.8695
623.2655 64.35 8.7945
665.55 68.85 9.4095
842.638 86.85 11.8695
696.96 72 9.84
755.318 77.85 10.6395
565.5 58.5 7.995
566.28 58.5 7.995
876.3 90 12.3
522 58.5 7.38
652.5 67.5 9.225
566.605 58.5 7.995
784.53 81 11.07
841.1905 86.85 11.8695
841.1905 86.85 11.8695
839.55 86.85 11.8695
1104.598 113.85 15.5595
537.018 58.5 7.5645
 REPORTE DE VENTAS Aplicar formato condicional a las venta, según Mes y Región seleccionada,
que al elegir un MES y REGION, esta quede resaltada en la lista con un fond
REGION
MES Costa Sierra Selva Mes
Enero 100 250 300 Región
Febrero 250 300 280
Marzo 130 200 150
Abril 220 280 250
Mayo 700 600 900
Junio 650 710 1100
Julio 400 700 600
Agosto 500 420 620
Septiembre 600 850 750
Octubre 800 650 710
Noviembre 500 700 810
Diciembre 650 800 750
ún Mes y Región seleccionada, de tal manera
resaltada en la lista con un fondo AMARILLO