buscarv antiguedades hecho
DESCRIPTION
ejercicio completo para utilizar la funcion buscarv o consultavTRANSCRIPT
NOMBRES AFP % TRAMOS COLOR PORC.ANTIGÜEDAD
CAPITAL 12.5% 1 A AZUL 0.05%
CUPRUM 12.4% 20 B CELESTE 0.10%
HABITAT 13.3% 40 C ROJO 0.15%
PLANVITAL 12.3% 100 D NARANJO 0.20%
PROVIDA 12.1% 200 E AMARILLO 0.25%
500 F VERDE 0.30%
1000 G CAFÉ 0.35%
CUPRUM 5
RANGO NUMÉRICO
ANTIGÜEDAD PORC.
0 0.0%1 5.0%3 10.0%6 20.0%
10 40.0%15 60.0%
Nombre Fonasa Promepart Colmena Normédica ING Tres Vida Más VidaPlan en % 7.0% 8.0% 9.0% 8.0% 7.5% 9.0% 8.0%
Sfera 11.0%
Vida Plena Banmédica Sfera Consalud10.0% 9.0% 11.0% 8.0%
PLANILLA DE REMUNERACIONES
1 2 3 4 5
RUT NOMBRE NOMBRE AFP SALUD
11.111.111-1 CARLOS TAPIA UGARTE CAPITAL Fonasa $ 500,000
11.111.111-2 SERGIO SILVA PINEDA CUPRUM Promepart $ 350,000
11.111.111-3 JOSE VENEGAS FRIAS HABITAT Colmena $ 850,000
11.111.111-4 ROSA SOTO GONZALEZ PLANVITAL Normédica $ 250,000
11.111.111-5 CARMEN DUARTE RIOS PROVIDA ING $ 550,000
11.111.111-6 RODRIGO PRIETO LOBOS CAPITAL Tres Vida $ 600,000
11.111.111-7 JIMENA CAROCA TORRES CUPRUM Más Vida $ 350,000
11.111.111-8 EMILIO GARRIDO TORO HABITAT Vida Plena $ 850,000
11.111.111-9 EDUARDO RIVEROS ARANEDPLANVITAL Banmédica $ 230,000
11.111.112-1 LISET FERNANDEZ ULLOA PROVIDA Fonasa $ 260,000
11.111.112-2 CECILIA QUIROGA RETAMAL CAPITAL Fonasa $ 400,000
11.111.112-3 ALFREDO BURGOS CACERESCUPRUM Fonasa $ 550,000
100 % DE LOGRO
SUELDOIMPONIBLE
PLANILLA DE REMUNERACIONES
6 7 8 9 10 11
% AFP Desc Afp $ % Salud Desc Salud $
0 0.0 12.5% $62,500.000 7.0% $35,000.0
1 17,500.0 12.4% $43,400.000 8.0% $28,000.0
2 42,500.0 13.3% $113,050.000 9.0% $76,500.0
14 100,000.0 12.3% $30,750.000 8.0% $20,000.0
4 55,000.0 12.1% $66,550.000 7.5% $41,250.0
12 240,000.0 12.5% $75,000.000 9.0% $54,000.0
10 140,000.0 12.4% $43,400.000 8.0% $28,000.0
1 42,500.0 13.3% $113,050.000 10.0% $85,000.0
0 0.0 12.3% $28,290.000 9.0% $20,700.0
16 156,000.0 12.1% $31,460.000 7.0% $18,200.0
8 80,000.0 12.5% $50,000.000 7.0% $28,000.0
1 27,500.0 12.4% $68,200.000 7.0% $38,500.0
Antigüedad (Años)
Antigüedad Pesos
Excele
nte
Muy
bien
Notab
le
Sigue
así
Extrao
rdina
rio
RESPUESTAS CORRECTAS COMPARACIÓN ENTRE RESPUESTA ALUMNO Y R. CORRECTAS
% AFP Desc Afp $ % Salud
0 0.125 62500 0.07 35000 1
17,500 0.124 43400 0.08 28000 TRUE
42,500 0.133 113050 0.09 76500 TRUE
100,000 0.123 30750 0.08 20000 TRUE
55,000 0.121 66550 0.075 41250 TRUE
240,000 0.125 75000 0.09 54000 TRUE
140,000 0.124 43400 0.08 28000 TRUE
42,500 0.133 113050 0.1 85000 TRUE
0 0.123 28290 0.09 20700 TRUE
156,000 0.121 31460 0.07 18200 TRUE
80,000 0.125 50000 0.07 28000 TRUE
27,500 0.124 68200 0.07 38500 TRUE
1
Antigüedad Pesos
Desc Salud $
Antigüedad Pesos
Extrao
rdina
rio
COMPARACIÓN ENTRE RESPUESTA ALUMNO Y R. CORRECTAS
% AFP Desc Afp $ % Salud
1 1 1 TRUE
TRUE TRUE TRUE TRUE
TRUE TRUE TRUE TRUE
TRUE TRUE TRUE TRUE
TRUE TRUE TRUE TRUE
TRUE TRUE TRUE TRUE
TRUE TRUE TRUE TRUE
TRUE TRUE TRUE TRUE
TRUE TRUE TRUE TRUE
TRUE TRUE TRUE TRUE
TRUE TRUE TRUE TRUE
TRUE TRUE TRUE TRUE
1 1 1 TRUE
Desc Salud $
FICHA PERSONAL
RUT 11.111.111-9
NOMBRE EDUARDO RIVEROS ARANEDA
ANTIGÜEDAD $$$$ $0.00
NOMBRE AFP PLANVITAL
SUELDO IMPONIBLE $230,000.00
% AFP 12.3%
Desc Afp $ $28,290.00
% Salud 9.0%
Desc Salud $ $20,700.00
Porc. de acierto: 100.00%
Realice una validación por lista para desplegar los RUT de la Base de Datos.
EDUARDO RIVEROS ARAN TRUE
0 TRUE
PLANVITAL TRUE
230000 TRUE
0.123 TRUE
28290 TRUE
0.09 TRUE
20700 TRUE
Realice una validación por lista para desplegar los RUT de la Base de Datos.
RUT NOMBRE AFP SALUD12.639.914-5 Abarza Valenzuela Luis M 0 CAPITAL Promepart TECNICO
9.041.963-3 Aburto Meza Palmira F 4 CAPITAL Más Vida ENSEÑANZA MEDIA8.201.871-9 Acevedo Cabezas Esteban M 0 HABITAT Normédica TECNICO9.148.900-7 Acevedo Espinoza Jorge M 0 CAPITAL Más Vida TECNICO
12.416.643-8 Acevedo González Gloria F 3 CAPITAL Tres Vida PROFESIONAL5.512.105-2 Acevedo Navarro José M 0 PROVIDA ING ENSEÑANZA MEDIA8.205.013-2 Acosta Celis Carlos M 0 CAPITAL Más Vida ENSEÑANZA MEDIA
16.568.481-8 Adasme Urra Luisa F 4 HABITAT ING TECNICO6.597.566-1 Aguilera Cabrera Ivan M 0 CAPITAL Fonasa TECNICO
10.572.175-7 Aguilera Silva Rodrigo M 3 PROVIDA ING TECNICO5.744.031-7 Alarcón Casanova Sergio M 1 PLANVITAL Promepart ENSEÑANZA MEDIA
10.195.382-3 Alarcón González Luis M 3 CAPITAL Consalud ENSEÑANZA MEDIA8.368.773-8 Albornoz Sepulveda Luis M 1 CAPITAL Más Vida ENSEÑANZA MEDIA9.830.153-4 Alfaro González Sergio M 3 CAPITAL Tres Vida PROFESIONAL9.313.119-3 Alfaro Lobos Bartolome M 3 CAPITAL Más Vida TECNICO
14.396.933-9 Almeida Veliz Ángel M 3 CUPRUM Vida Plena TECNICO8.609.596-3 Altamirano Cuevas Claudio M 1 CUPRUM Vida Plena TECNICO9.635.115-2 Altamirano Quezada Jose M 1 HABITAT Promepart TECNICO6.843.720-2 Alvarez Torres Erick M 1 CUPRUM Banmédica TECNICO
13.773.889-9 Araneda Araya Victoria F 0 HABITAT Sfera TECNICO16.005.063-2 Araneda Caro Ruben M 1 CAPITAL Colmena PROFESIONAL10.742.117-3 Araneda Díaz Victor M 3 HABITAT Sfera TECNICO
9.886.745-7 Araneda Jiménez Gustavo M 1 PLANVITAL Banmédica TECNICO5.660.775-7 Aranguiz Figueroa Carlos M 3 CAPITAL Tres Vida PROFESIONAL5.299.873-5 Aranguiz Figueroa Emilio M 1 CAPITAL Fonasa PROFESIONAL7.614.081-2 Aravena Martínez Pablo M 1 PROVIDA Promepart PROFESIONAL5.990.979-7 Araya Garate Alicia F 1 CAPITAL Banmédica TECNICO7.060.885-5 Arias Soto Jorge M 1 CAPITAL Normédica ENSEÑANZA MEDIA6.091.597-0 Armijo Lizama Leonardo M 3 CUPRUM ING TECNICO9.900.908-K Arriagada Galaz Emilio M 1 CUPRUM Más Vida TECNICO7.741.350-2 Arteaga Bravo Pablo M 1 CAPITAL Vida Plena PROFESIONAL
13.452.938-5 Astudillo Guerrero Pedro M 1 PLANVITAL Promepart PROFESIONAL11.779.030-4 Astudillo Moya Carlos M 1 CUPRUM Consalud PROFESIONAL
6.633.876-2 Astudillo Pereira Verónica F 1 PROVIDA Colmena PROFESIONAL6.134.686-4 Azócar Riffo Herminda F 1 PROVIDA Consalud ENSEÑANZA MEDIA6.565.470-9 Bacián Lavín Carlos M 1 CUPRUM Normédica TECNICO
13.041.762-0 Baez Sanchez Juana F 1 CAPITAL Sfera PROFESIONAL5.972.572-6 Balmaceda Valenzuela Luis M 0 CAPITAL Fonasa ENSEÑANZA MEDIA9.102.917-0 Bascuñán Valdebenito Alfredo M 0 PROVIDA Promepart PROFESIONAL
6.434.788-8 Belmar Hormazábal Rodrigo M 0 CAPITAL Tres Vida PROFESIONAL5.338.084-0 Berríos Castro Armando M 1 HABITAT Normédica TECNICO6.235.162-4 Blanco Vera Washington M 0 PLANVITAL Vida Plena PROFESIONAL7.402.055-0 Bravo Muñoz Eduardo M 1 HABITAT Banmédica ENSEÑANZA MEDIA8.893.085-1 Briones Devlahovich Ronald M 1 CAPITAL Banmédica ENSEÑANZA MEDIA7.068.541-8 Bustamante Barra Elizabeth F 4 PLANVITAL Colmena TECNICO
14.444.328-4 Bustos Almonacid Miguel M 1 CAPITAL Promepart TECNICO16.190.038-9 Bustos Arraño Guido M 1 HABITAT Banmédica TECNICO
SEXO
Nº CARGAS
NIVEL EDUCACIONAL
12.363.857-3 Bustos Mejías Gustavo M 1 CUPRUM Sfera ENSEÑANZA MEDIA6.874.699-k Bustos Toledo Oscar M 1 CUPRUM Colmena ENSEÑANZA MEDIA
13.724.965-6 Cabello Madrid Carlos M 3 CAPITAL Sfera PROFESIONAL9.693.481-5 Cabezas Castañeda Julio M 3 PLANVITAL Vida Plena PROFESIONAL
11.483.660-5 Calderón Cruz Cesar M 3 CUPRUM Fonasa PROFESIONAL4.308.131-4 Calderón Galaz Jose M 2 PROVIDA Consalud TECNICO
11.272.423-0 Calderon Marchant Luisa F 1 CAPITAL Fonasa TECNICO17.281.737-8 Calderón Muñoz Jorge M 3 PROVIDA Colmena PROFESIONAL
7.465.885-7 Campos Carrasco Isabel F 1 CUPRUM ING TECNICO21.587.739-3 Campos Moreno Sergio M 2 PROVIDA Normédica TECNICO
8.547.643-2 Campos Reyes Juan M 2 PLANVITAL Promepart PROFESIONAL7.526.244-2 Cantillana Pavez Raul M 1 CUPRUM Colmena TECNICO
10.693.180-K Cárcamo Santander Roberto M 2 CAPITAL Tres Vida PROFESIONAL13.924.346-3 Carmona Moralez Daniel M 2 CUPRUM Consalud PROFESIONAL10.277.556-2 Caro Aranguiz Angel M 3 CUPRUM ING TECNICO10.600.081-6 Caro Garrido Karina F 0 CAPITAL Vida Plena PROFESIONAL15.408.521-1 Carrasco Hernández Georgina F 1 CAPITAL Consalud TECNICO13.773.703-5 Carrasco Salas Juan M 2 CUPRUM Vida Plena PROFESIONAL13.370.080-3 Carú Salinas Marío M 2 CAPITAL Tres Vida PROFESIONAL
7.411.669-8 Carvajal Toro Marcos M 2 PROVIDA Más Vida TECNICO3.903.946-K Castro Córdova Silvia F 1 PLANVITAL Sfera TECNICO8.462649-K Castro Mora Richard M 3 CUPRUM Normédica TECNICO6.633.613-1 Castro Vásquez Bernardo M 3 CAPITAL Consalud ENSEÑANZA MEDIA5.334.664-2 Catalán Toro Armanda F 1 HABITAT Normédica TECNICO
11.363.914-8 Catrileo Paine Eliana F 3 CUPRUM Fonasa TECNICO10.275.887-0 Chamorro Vidal Isolina F 3 PROVIDA ING TECNICO10.866.347-2 Chaparro Reyes Myriam F 4 CAPITAL Colmena PROFESIONAL
5.057.894-1 Chávez González Elsa F 3 CUPRUM Fonasa PROFESIONAL8.085.060-3 Cofré Zurita Nancy F 3 PLANVITAL Banmédica TECNICO7.349.976-3 Concha Barrera Nancy F 3 CUPRUM ING TECNICO9.688.702-4 Conejeros Pacheco Sonia F 3 CAPITAL Normédica PROFESIONAL6.388.776-5 Contreras Márquez Laura F 1 CUPRUM Más Vida TECNICO
13.341.793-1 Muñoz Lopez Jose M 3 CAPITAL Vida Plena PROFESIONAL9.043.059-9 Muñoz Lopez Maite F 3 PLANVITAL Colmena ENSEÑANZA MEDIA
13.775.025-2 Muñoz Lopez Vanessa F 3 PLANVITAL Sfera ENSEÑANZA MEDIA
100.0% Bien!
CARGO DEPARTAMENTO SUELDO BASEVENDEDOR VENTAS VENTAS 12/13/2000 $ 300,000SECRETARIA VENTAS MARKETING 4/11/2008 $ 250,000VENDEDOR VENTAS VENTAS 11/3/2000 $ 300,000ADMINISTRATIVO FINANZAS CONTABILIDAD 9/14/2000 $ 350,000SECRETARIA VENTAS PERSONAL 3/1/2009 $ 250,000ADMINISTRATIVO RR.HH CAPACITACION 10/24/2000 $ 350,000VENDEDOR RR.HH PERSONAL 9/24/2000 $ 300,000SECRETARIA FINANZAS REMUNERACIONES 10/22/2008 $ 250,000VENDEDOR VENTAS VENTAS 10/14/2000 $ 300,000ADMINISTRATIVO RR.HH MARKETING 3/11/2009 $ 350,000VENDEDOR VENTAS REMUNERACIONES 12/16/2009 $ 300,000ADMINISTRATIVO CONTABLE RR.HH REMUNERACIONES 1/30/2009 $ 380,000ADMINISTRATIVO CONTABLE VENTAS PERSONAL 2/4/2010 $ 380,000VENDEDOR VENTAS VENTAS 5/11/2005 $ 300,000ADMINISTRATIVO RR.HH PERSONAL 7/9/2009 $ 350,000ADMINISTRATIVO RR.HH PERSONAL 5/20/2009 $ 350,000ADMINISTRATIVO RR.HH PERSONAL 1/15/2010 $ 350,000ADMINISTRATIVO CONTABLE FINANZAS REMUNERACIONES 7/14/2010 $ 380,000ADMINISTRATIVO FINANZAS CAPACITACION 10/8/2005 $ 350,000SECRETARIA CONTABLE FINANZAS CONTABILIDAD 11/23/2000 $ 290,000GERENTE VENTAS CONTABILIDAD 4/15/2010 $ 990,000VENDEDOR FINANZAS VENTAS 3/21/2009 $ 300,000GERENTE FINANZAS VENTAS 3/16/2010 $ 990,000GERENTE VENTAS CAPACITACION 3/2/2005 $ 990,000CONTADOR AUDITOR FINANZAS CONTABILIDAD 5/16/2006 $ 500,000ADMINISTRATIVO FINANZAS MARKETING 1/26/2006 $ 350,000SECRETARIA VENTAS MARKETING 8/15/2000 $ 250,000VENDEDOR VENTAS VENTAS 12/6/2009 $ 300,000ADMINISTRATIVO VENTAS CONTABILIDAD 12/31/2008 $ 350,000VENDEDOR FINANZAS CONTABILIDAD 3/26/2010 $ 300,000VENDEDOR FINANZAS CONTABILIDAD 10/18/2005 $ 300,000ADMINISTRATIVO CONTABLE FINANZAS VENTAS 9/18/2005 $ 380,000GERENTE RR.HH PERSONAL 7/25/2006 $ 990,000SECRETARIA GERENCIA RR.HH PERSONAL 5/5/2010 $ 310,000SECRETARIA RR.HH CAPACITACION 7/4/2010 $ 250,000VENDEDOR VENTAS CONTABILIDAD 4/7/2000 $ 300,000SECRETARIA RR.HH REMUNERACIONES 12/26/2009 $ 250,000VENDEDOR FINANZAS MARKETING 10/2/2010 $ 300,000GERENTE FINANZAS CONTABILIDAD 11/11/2010 $ 990,000GERENTE VENTAS MARKETING 12/31/2010 $ 990,000ADMINISTRATIVO VENTAS MARKETING 2/17/2000 $ 350,000GERENTE FINANZAS CONTABILIDAD 12/1/2010 $ 990,000ADMINISTRATIVO RR.HH PERSONAL 1/5/2010 $ 350,000ADMINISTRATIVO VENTAS PERSONAL 1/28/2000 $ 350,000ADMINISTRATIVO CONTABLE FINANZAS REMUNERACIONES 10/12/2008 $ 380,000ADMINISTRATIVO VENTAS CONTABILIDAD 4/27/2000 $ 350,000ADMINISTRATIVO RR.HH PERSONAL 5/27/2000 $ 350,000
Porcentaje de logro →
CENTRO COSTO
FECHA INGRESO
VENDEDOR FINANZAS CONTABILIDAD 11/6/2009 $ 300,000VENDEDOR VENTAS VENTAS 6/14/2010 $ 300,000GERENTE RR.HH PERSONAL 5/10/2009 $ 990,000ADMINISTRATIVO FINANZAS CONTABILIDAD 3/31/2009 $ 350,000GERENTE RR.HH PERSONAL 4/30/2009 $ 990,000ADMINISTRATIVO RR.HH CAPACITACION 9/17/2009 $ 350,000SECRETARIA VENTAS VENTAS 8/23/2010 $ 250,000ADMINISTRATIVO VENTAS REMUNERACIONES 1/10/2009 $ 350,000SECRETARIA VENTAS VENTAS 8/5/2000 $ 250,000ADMINISTRATIVO CONTABLE FINANZAS REMUNERACIONES 10/7/2009 $ 380,000ADMINISTRATIVO RR.HH PERSONAL 9/27/2009 $ 350,000VENDEDOR VENTAS MARKETING 2/24/2010 $ 300,000VENDEDOR VENTAS CONTABILIDAD 8/28/2009 $ 300,000ADMINISTRATIVO CONTABLE RR.HH PERSONAL 7/30/2005 $ 380,000ADMINISTRATIVO VENTAS CONTABILIDAD 3/12/2005 $ 350,000GERENTE VENTAS MARKETING 12/21/2010 $ 990,000SECRETARIA RR.HH PERSONAL 5/15/2010 $ 250,000ADMINISTRATIVO VENTAS MARKETING 7/29/2009 $ 350,000VENDEDOR VENTAS MARKETING 8/18/2009 $ 300,000ADMINISTRATIVO VENTAS MARKETING 6/30/2005 $ 350,000SECRETARIA GERENCIA VENTAS MARKETING 6/4/2010 $ 310,000VENDEDOR VENTAS VENTAS 6/29/2009 $ 300,000ADMINISTRATIVO RR.HH CONTABILIDAD 12/21/2008 $ 350,000ADMINISTRATIVO CONTABLE VENTAS MARKETING 9/8/2005 $ 380,000ADMINISTRATIVO CONTABLE VENTAS REMUNERACIONES 1/20/2009 $ 380,000ADMINISTRATIVO CONTABLE RR.HH MARKETING 10/13/2004 $ 380,000GERENTE VENTAS VENTAS 11/1/2008 $ 990,000ADMINISTRATIVO CONTABLE FINANZAS VENTAS 11/2/2004 $ 380,000SECRETARIA FINANZAS CONTABILIDAD 5/30/2009 $ 250,000ADMINISTRATIVO CONTABLE FINANZAS REMUNERACIONES 6/9/2009 $ 380,000ADMINISTRATIVO CONTABLE FINANZAS REMUNERACIONES 7/19/2009 $ 380,000SECRETARIA CONTABLE FINANZAS CONTABILIDAD 7/24/2010 $ 290,000VENDEDOR VENTAS PERSONAL 2/19/2009 $ 300,000SECRETARIA VENTAS CAPACITACION 12/1/2008 $ 250,000SECRETARIA VENTAS PERSONAL 2/9/2009 $ 250,000
Bien! Bien! Bien! Bien! Bien! Bien!
22.4 $ 180,000 $ 15,000 $ 495,000 $ 25,000 $ 10,00015.0 $ 150,000 $ 0 $ 400,000 $ 25,000 $ 10,00022.5 $ 180,000 $ 15,000 $ 495,000 $ 25,000 $ 10,00022.6 $ 210,000 $ 17,500 $ 577,500 $ 25,000 $ 10,00014.1 $ 100,000 $ 25,000 $ 375,000 $ 25,000 $ 10,00022.5 $ 210,000 $ 0 $ 560,000 $ 25,000 $ 10,00022.6 $ 180,000 $ 0 $ 480,000 $ 25,000 $ 10,00014.5 $ 100,000 $ 12,500 $ 362,500 $ 25,000 $ 10,00022.5 $ 180,000 $ 15,000 $ 495,000 $ 25,000 $ 10,00014.1 $ 140,000 $ 17,500 $ 507,500 $ 25,000 $ 10,00013.4 $ 120,000 $ 0 $ 420,000 $ 25,000 $ 10,00014.2 $ 152,000 $ 0 $ 532,000 $ 25,000 $ 10,00013.2 $ 152,000 $ 0 $ 532,000 $ 25,000 $ 10,00018.0 $ 180,000 $ 30,000 $ 510,000 $ 25,000 $ 10,00013.8 $ 140,000 $ 17,500 $ 507,500 $ 25,000 $ 10,00013.9 $ 140,000 $ 17,500 $ 507,500 $ 25,000 $ 10,00013.3 $ 140,000 $ 17,500 $ 507,500 $ 25,000 $ 10,00012.8 $ 152,000 $ 19,000 $ 551,000 $ 25,000 $ 10,00017.5 $ 210,000 $ 17,500 $ 577,500 $ 25,000 $ 10,00022.4 $ 174,000 $ 14,500 $ 478,500 $ 25,000 $ 10,00013.0 $ 396,000 $ 99,000 $ 1,485,000 $ 25,000 $ 10,00014.1 $ 120,000 $ 15,000 $ 435,000 $ 25,000 $ 10,00013.1 $ 396,000 $ 49,500 $ 1,435,500 $ 25,000 $ 10,00018.1 $ 594,000 $ 99,000 $ 1,683,000 $ 25,000 $ 10,00016.9 $ 300,000 $ 50,000 $ 850,000 $ 25,000 $ 10,00017.2 $ 210,000 $ 35,000 $ 595,000 $ 25,000 $ 10,00022.7 $ 150,000 $ 12,500 $ 412,500 $ 25,000 $ 10,00013.4 $ 120,000 $ 0 $ 420,000 $ 25,000 $ 10,00014.3 $ 140,000 $ 17,500 $ 507,500 $ 25,000 $ 10,00013.1 $ 120,000 $ 15,000 $ 435,000 $ 25,000 $ 10,00017.5 $ 180,000 $ 30,000 $ 510,000 $ 25,000 $ 10,00017.6 $ 228,000 $ 38,000 $ 646,000 $ 25,000 $ 10,00016.8 $ 594,000 $ 99,000 $ 1,683,000 $ 25,000 $ 10,00013.0 $ 124,000 $ 31,000 $ 465,000 $ 25,000 $ 10,00012.8 $ 100,000 $ 0 $ 350,000 $ 25,000 $ 10,00023.1 $ 180,000 $ 15,000 $ 495,000 $ 25,000 $ 10,00013.3 $ 100,000 $ 25,000 $ 375,000 $ 25,000 $ 10,00012.6 $ 120,000 $ 0 $ 420,000 $ 25,000 $ 10,00012.4 $ 396,000 $ 99,000 $ 1,485,000 $ 25,000 $ 10,00012.3 $ 396,000 $ 99,000 $ 1,485,000 $ 25,000 $ 10,00023.2 $ 210,000 $ 17,500 $ 577,500 $ 25,000 $ 10,00012.4 $ 396,000 $ 99,000 $ 1,485,000 $ 25,000 $ 10,00013.3 $ 140,000 $ 0 $ 490,000 $ 25,000 $ 10,00023.2 $ 210,000 $ 0 $ 560,000 $ 25,000 $ 10,00014.5 $ 152,000 $ 19,000 $ 551,000 $ 25,000 $ 10,00023.0 $ 210,000 $ 17,500 $ 577,500 $ 25,000 $ 10,00022.9 $ 210,000 $ 17,500 $ 577,500 $ 25,000 $ 10,000
AÑOS ANTIGÜEDAD
BONO ANTIGÜEDAD
ASIGNACION PROFESIONAL
TOTAL IMPONIBLE
BONO COLACION
BONO MOVILIZACION
13.5 $ 120,000 $ 0 $ 420,000 $ 25,000 $ 10,00012.9 $ 120,000 $ 0 $ 420,000 $ 25,000 $ 10,00014.0 $ 396,000 $ 99,000 $ 1,485,000 $ 25,000 $ 10,00014.1 $ 140,000 $ 35,000 $ 525,000 $ 25,000 $ 10,00014.0 $ 396,000 $ 99,000 $ 1,485,000 $ 25,000 $ 10,00013.6 $ 140,000 $ 17,500 $ 507,500 $ 25,000 $ 10,00012.7 $ 100,000 $ 12,500 $ 362,500 $ 25,000 $ 10,00014.3 $ 140,000 $ 35,000 $ 525,000 $ 25,000 $ 10,00022.7 $ 150,000 $ 12,500 $ 412,500 $ 25,000 $ 10,00013.5 $ 152,000 $ 19,000 $ 551,000 $ 25,000 $ 10,00013.6 $ 140,000 $ 35,000 $ 525,000 $ 25,000 $ 10,00013.2 $ 120,000 $ 15,000 $ 435,000 $ 25,000 $ 10,00013.7 $ 120,000 $ 30,000 $ 450,000 $ 25,000 $ 10,00017.7 $ 228,000 $ 38,000 $ 646,000 $ 25,000 $ 10,00018.1 $ 210,000 $ 17,500 $ 577,500 $ 25,000 $ 10,00012.3 $ 396,000 $ 99,000 $ 1,485,000 $ 25,000 $ 10,00012.9 $ 100,000 $ 12,500 $ 362,500 $ 25,000 $ 10,00013.7 $ 140,000 $ 35,000 $ 525,000 $ 25,000 $ 10,00013.7 $ 120,000 $ 30,000 $ 450,000 $ 25,000 $ 10,00017.8 $ 210,000 $ 17,500 $ 577,500 $ 25,000 $ 10,00012.9 $ 124,000 $ 15,500 $ 449,500 $ 25,000 $ 10,00013.8 $ 120,000 $ 15,000 $ 435,000 $ 25,000 $ 10,00014.3 $ 140,000 $ 0 $ 490,000 $ 25,000 $ 10,00017.6 $ 228,000 $ 19,000 $ 627,000 $ 25,000 $ 10,00014.3 $ 152,000 $ 19,000 $ 551,000 $ 25,000 $ 10,00018.5 $ 228,000 $ 19,000 $ 627,000 $ 25,000 $ 10,00014.5 $ 396,000 $ 99,000 $ 1,485,000 $ 25,000 $ 10,00018.5 $ 228,000 $ 38,000 $ 646,000 $ 25,000 $ 10,00013.9 $ 100,000 $ 12,500 $ 362,500 $ 25,000 $ 10,00013.9 $ 152,000 $ 19,000 $ 551,000 $ 25,000 $ 10,00013.8 $ 152,000 $ 38,000 $ 570,000 $ 25,000 $ 10,00012.8 $ 116,000 $ 14,500 $ 420,500 $ 25,000 $ 10,00014.2 $ 120,000 $ 30,000 $ 450,000 $ 25,000 $ 10,00014.4 $ 100,000 $ 0 $ 350,000 $ 25,000 $ 10,00014.2 $ 100,000 $ 0 $ 350,000 $ 25,000 $ 10,000
Bien! Bien! Bien! Bien! Bien! Bien!
ASIGNACIÓN FAMILIAR DESCUENTO LEGAL ANTICIPO$ 0 $ 530,000 $ 101,475 $ 85,000 $ 186,475 $ 343,525
$ 6,196 $ 441,196 $ 82,000 $ 20,000 $ 102,000 $ 339,196$ 0 $ 530,000 $ 105,435 $ 50,000 $ 155,435 $ 374,565$ 0 $ 612,500 $ 118,388 $ 55,000 $ 173,388 $ 439,113
$ 4,647 $ 414,647 $ 80,625 $ 0 $ 80,625 $ 334,022$ 0 $ 595,000 $ 109,760 $ 43,000 $ 152,760 $ 442,240$ 0 $ 515,000 $ 98,400 $ 0 $ 98,400 $ 416,600
$ 6,196 $ 403,696 $ 75,400 $ 0 $ 75,400 $ 328,296$ 0 $ 530,000 $ 96,525 $ 0 $ 96,525 $ 433,475$ 0 $ 542,500 $ 99,470 $ 0 $ 99,470 $ 443,030
$ 1,549 $ 456,549 $ 85,260 $ 0 $ 85,260 $ 371,289$ 0 $ 567,000 $ 109,060 $ 0 $ 109,060 $ 457,940$ 0 $ 567,000 $ 109,060 $ 0 $ 109,060 $ 457,940$ 0 $ 545,000 $ 109,650 $ 0 $ 109,650 $ 435,350$ 0 $ 542,500 $ 104,038 $ 0 $ 104,038 $ 438,463$ 0 $ 542,500 $ 113,680 $ 0 $ 113,680 $ 428,820$ 0 $ 542,500 $ 113,680 $ 0 $ 113,680 $ 428,820$ 0 $ 586,000 $ 117,363 $ 0 $ 117,363 $ 468,637$ 0 $ 612,500 $ 123,585 $ 0 $ 123,585 $ 488,915$ 0 $ 513,500 $ 116,276 $ 85,000 $ 201,276 $ 312,225$ 0 $ 1,520,000 $ 319,275 $ 0 $ 319,275 $ 1,200,725
$ 4,647 $ 474,647 $ 105,705 $ 0 $ 105,705 $ 368,942$ 0 $ 1,470,500 $ 305,762 $ 0 $ 305,762 $ 1,164,739$ 0 $ 1,718,000 $ 361,845 $ 0 $ 361,845 $ 1,356,155$ 0 $ 885,000 $ 165,750 $ 0 $ 165,750 $ 719,250$ 0 $ 630,000 $ 119,595 $ 0 $ 119,595 $ 510,405
$ 1,549 $ 449,049 $ 88,688 $ 0 $ 88,688 $ 360,362$ 1,549 $ 456,549 $ 86,100 $ 0 $ 86,100 $ 370,449
$ 0 $ 542,500 $ 100,993 $ 0 $ 100,993 $ 441,508$ 1,549 $ 471,549 $ 88,740 $ 0 $ 88,740 $ 382,809
$ 0 $ 545,000 $ 114,750 $ 0 $ 114,750 $ 430,250$ 0 $ 681,000 $ 131,138 $ 0 $ 131,138 $ 549,862$ 0 $ 1,718,000 $ 343,332 $ 0 $ 343,332 $ 1,374,668$ 0 $ 500,000 $ 98,115 $ 0 $ 98,115 $ 401,885
$ 1,549 $ 386,549 $ 70,350 $ 50,000 $ 120,350 $ 266,199$ 0 $ 530,000 $ 100,980 $ 0 $ 100,980 $ 429,020
$ 1,549 $ 411,549 $ 88,125 $ 0 $ 88,125 $ 323,424$ 0 $ 455,000 $ 81,900 $ 0 $ 81,900 $ 373,100$ 0 $ 1,520,000 $ 298,485 $ 0 $ 298,485 $ 1,221,515$ 0 $ 1,520,000 $ 319,275 $ 0 $ 319,275 $ 1,200,725$ 0 $ 612,500 $ 123,008 $ 0 $ 123,008 $ 489,493$ 0 $ 1,520,000 $ 331,155 $ 0 $ 331,155 $ 1,188,845$ 0 $ 525,000 $ 109,270 $ 0 $ 109,270 $ 415,730$ 0 $ 595,000 $ 120,400 $ 0 $ 120,400 $ 474,600$ 0 $ 586,000 $ 117,363 $ 0 $ 117,363 $ 468,637$ 0 $ 612,500 $ 118,388 $ 0 $ 118,388 $ 494,113$ 0 $ 612,500 $ 128,783 $ 0 $ 128,783 $ 483,718
TOTAL HABER
TOTAL DESCUENTOS
SUELDO LIQUIDO
$ 1,549 $ 456,549 $ 98,280 $ 0 $ 98,280 $ 358,269$ 1,549 $ 456,549 $ 89,880 $ 0 $ 89,880 $ 366,669
$ 0 $ 1,520,000 $ 348,975 $ 0 $ 348,975 $ 1,171,025$ 0 $ 560,000 $ 117,075 $ 0 $ 117,075 $ 442,925$ 0 $ 1,520,000 $ 288,090 $ 0 $ 288,090 $ 1,231,910$ 0 $ 542,500 $ 102,008 $ 0 $ 102,008 $ 440,493
$ 1,549 $ 399,049 $ 70,688 $ 0 $ 70,688 $ 328,362$ 0 $ 560,000 $ 110,775 $ 0 $ 110,775 $ 449,225
$ 1,549 $ 449,049 $ 82,088 $ 20,000 $ 102,088 $ 346,962$ 0 $ 586,000 $ 110,751 $ 0 $ 110,751 $ 475,249$ 0 $ 560,000 $ 106,575 $ 0 $ 106,575 $ 453,425
$ 1,549 $ 471,549 $ 93,090 $ 0 $ 93,090 $ 378,459$ 3,098 $ 488,098 $ 96,750 $ 0 $ 96,750 $ 391,348
$ 0 $ 681,000 $ 131,784 $ 0 $ 131,784 $ 549,216$ 0 $ 612,500 $ 114,923 $ 0 $ 114,923 $ 497,578$ 0 $ 1,520,000 $ 334,125 $ 0 $ 334,125 $ 1,185,875
$ 1,549 $ 399,049 $ 74,313 $ 0 $ 74,313 $ 324,737$ 0 $ 560,000 $ 117,600 $ 0 $ 117,600 $ 442,400
$ 3,098 $ 488,098 $ 96,750 $ 0 $ 96,750 $ 391,348$ 0 $ 612,500 $ 116,078 $ 0 $ 116,078 $ 496,423
$ 1,549 $ 486,049 $ 104,734 $ 0 $ 104,734 $ 381,316$ 4,647 $ 474,647 $ 88,740 $ 0 $ 88,740 $ 385,907
$ 0 $ 525,000 $ 100,450 $ 0 $ 100,450 $ 424,550$ 0 $ 662,000 $ 133,551 $ 0 $ 133,551 $ 528,449$ 0 $ 586,000 $ 106,894 $ 0 $ 106,894 $ 479,106$ 0 $ 662,000 $ 122,892 $ 0 $ 122,892 $ 539,108$ 0 $ 1,520,000 $ 319,275 $ 0 $ 319,275 $ 1,200,725$ 0 $ 681,000 $ 125,324 $ 0 $ 125,324 $ 555,676
$ 4,647 $ 402,147 $ 77,213 $ 0 $ 77,213 $ 324,935$ 0 $ 586,000 $ 109,649 $ 0 $ 109,649 $ 476,351$ 0 $ 605,000 $ 116,850 $ 0 $ 116,850 $ 488,150
$ 1,549 $ 457,049 $ 85,782 $ 0 $ 85,782 $ 371,267$ 4,647 $ 489,647 $ 101,250 $ 0 $ 101,250 $ 388,397$ 4,647 $ 389,647 $ 74,550 $ 0 $ 74,550 $ 315,097$ 4,647 $ 389,647 $ 81,550 $ 0 $ 81,550 $ 308,097
SUELDO BASE BONO ANTIGÜEDAD$ 300,000 22.4 180,000.0 15,000.0 495,000.0 $ 250,000 15.0 150,000.0 - 400,000.0 $ 300,000 22.5 180,000.0 15,000.0 495,000.0 $ 350,000 22.6 210,000.0 17,500.0 577,500.0 $ 250,000 14.1 100,000.0 25,000.0 375,000.0 $ 350,000 22.5 210,000.0 - 560,000.0 $ 300,000 22.6 180,000.0 - 480,000.0 $ 250,000 14.5 100,000.0 12,500.0 362,500.0 $ 300,000 22.5 180,000.0 15,000.0 495,000.0 $ 350,000 14.1 140,000.0 17,500.0 507,500.0 $ 300,000 13.4 120,000.0 - 420,000.0 $ 380,000 14.2 152,000.0 - 532,000.0 $ 380,000 13.2 152,000.0 - 532,000.0 $ 300,000 18.0 180,000.0 30,000.0 510,000.0 $ 350,000 13.8 140,000.0 17,500.0 507,500.0 $ 350,000 13.9 140,000.0 17,500.0 507,500.0 $ 350,000 13.3 140,000.0 17,500.0 507,500.0 $ 380,000 12.8 152,000.0 19,000.0 551,000.0 $ 350,000 17.5 210,000.0 17,500.0 577,500.0 $ 290,000 22.4 174,000.0 14,500.0 478,500.0 $ 990,000 13.0 396,000.0 99,000.0 1,485,000.0 $ 300,000 14.1 120,000.0 15,000.0 435,000.0 $ 990,000 13.1 396,000.0 49,500.0 1,435,500.0 $ 990,000 18.1 594,000.0 99,000.0 1,683,000.0 $ 500,000 16.9 300,000.0 50,000.0 850,000.0 $ 350,000 17.2 210,000.0 35,000.0 595,000.0 $ 250,000 22.7 150,000.0 12,500.0 412,500.0 $ 300,000 13.4 120,000.0 - 420,000.0 $ 350,000 14.3 140,000.0 17,500.0 507,500.0 $ 300,000 13.1 120,000.0 15,000.0 435,000.0 $ 300,000 17.5 180,000.0 30,000.0 510,000.0 $ 380,000 17.6 228,000.0 38,000.0 646,000.0 $ 990,000 16.8 594,000.0 99,000.0 1,683,000.0 $ 310,000 13.0 124,000.0 31,000.0 465,000.0 $ 250,000 12.8 100,000.0 - 350,000.0 $ 300,000 23.1 180,000.0 15,000.0 495,000.0 $ 250,000 13.3 100,000.0 25,000.0 375,000.0 $ 300,000 12.6 120,000.0 - 420,000.0 $ 990,000 12.4 396,000.0 99,000.0 1,485,000.0 $ 990,000 12.3 396,000.0 99,000.0 1,485,000.0 $ 350,000 23.2 210,000.0 17,500.0 577,500.0 $ 990,000 12.4 396,000.0 99,000.0 1,485,000.0 $ 350,000 13.3 140,000.0 - 490,000.0 $ 350,000 23.2 210,000.0 - 560,000.0 $ 380,000 14.5 152,000.0 19,000.0 551,000.0 $ 350,000 23.0 210,000.0 17,500.0 577,500.0 $ 350,000 22.9 210,000.0 17,500.0 577,500.0
AÑOS ANTIGÜEDAD
ASIGNACION PROFESIONAL
TOTAL IMPONIBLE
$ 300,000 13.5 120,000.0 - 420,000.0 $ 300,000 12.9 120,000.0 - 420,000.0 $ 990,000 14.0 396,000.0 99,000.0 1,485,000.0 $ 350,000 14.1 140,000.0 35,000.0 525,000.0 $ 990,000 14.0 396,000.0 99,000.0 1,485,000.0 $ 350,000 13.6 140,000.0 17,500.0 507,500.0 $ 250,000 12.7 100,000.0 12,500.0 362,500.0 $ 350,000 14.3 140,000.0 35,000.0 525,000.0 $ 250,000 22.7 150,000.0 12,500.0 412,500.0 $ 380,000 13.5 152,000.0 19,000.0 551,000.0 $ 350,000 13.6 140,000.0 35,000.0 525,000.0 $ 300,000 13.2 120,000.0 15,000.0 435,000.0 $ 300,000 13.7 120,000.0 30,000.0 450,000.0 $ 380,000 17.7 228,000.0 38,000.0 646,000.0 $ 350,000 18.1 210,000.0 17,500.0 577,500.0 $ 990,000 12.3 396,000.0 99,000.0 1,485,000.0 $ 250,000 12.9 100,000.0 12,500.0 362,500.0 $ 350,000 13.7 140,000.0 35,000.0 525,000.0 $ 300,000 13.7 120,000.0 30,000.0 450,000.0 $ 350,000 17.8 210,000.0 17,500.0 577,500.0 $ 310,000 12.9 124,000.0 15,500.0 449,500.0 $ 300,000 13.8 120,000.0 15,000.0 435,000.0 $ 350,000 14.3 140,000.0 - 490,000.0 $ 380,000 17.6 228,000.0 19,000.0 627,000.0 $ 380,000 14.3 152,000.0 19,000.0 551,000.0 $ 380,000 18.5 228,000.0 19,000.0 627,000.0 $ 990,000 14.5 396,000.0 99,000.0 1,485,000.0 $ 380,000 18.5 228,000.0 38,000.0 646,000.0 $ 250,000 13.9 100,000.0 12,500.0 362,500.0 $ 380,000 13.9 152,000.0 19,000.0 551,000.0 $ 380,000 13.8 152,000.0 38,000.0 570,000.0 $ 290,000 12.8 116,000.0 14,500.0 420,500.0 $ 300,000 14.2 120,000.0 30,000.0 450,000.0 $ 250,000 14.4 100,000.0 - 350,000.0 $ 250,000 14.2 100,000.0 - 350,000.0
ASIGNACIÓN FAMILIAR DESCUENTO LEGAL ANTICIPO 25,000.0 10,000.0 - 530,000.0 101,475.0 85,000.0 25,000.0 10,000.0 6,196.0 441,196.0 82,000.0 20,000.0 25,000.0 10,000.0 - 530,000.0 105,435.0 50,000.0 25,000.0 10,000.0 - 612,500.0 118,387.5 55,000.0 25,000.0 10,000.0 4,647.0 414,647.0 80,625.0 - 25,000.0 10,000.0 - 595,000.0 109,760.0 43,000.0 25,000.0 10,000.0 - 515,000.0 98,400.0 - 25,000.0 10,000.0 6,196.0 403,696.0 75,400.0 - 25,000.0 10,000.0 - 530,000.0 96,525.0 - 25,000.0 10,000.0 - 542,500.0 99,470.0 - 25,000.0 10,000.0 1,549.0 456,549.0 85,260.0 - 25,000.0 10,000.0 - 567,000.0 109,060.0 - 25,000.0 10,000.0 - 567,000.0 109,060.0 - 25,000.0 10,000.0 - 545,000.0 109,650.0 - 25,000.0 10,000.0 - 542,500.0 104,037.5 - 25,000.0 10,000.0 - 542,500.0 113,680.0 - 25,000.0 10,000.0 - 542,500.0 113,680.0 - 25,000.0 10,000.0 - 586,000.0 117,363.0 - 25,000.0 10,000.0 - 612,500.0 123,585.0 - 25,000.0 10,000.0 - 513,500.0 116,275.5 85,000.0 25,000.0 10,000.0 - 1,520,000.0 319,275.0 - 25,000.0 10,000.0 4,647.0 474,647.0 105,705.0 - 25,000.0 10,000.0 - 1,470,500.0 305,761.5 - 25,000.0 10,000.0 - 1,718,000.0 361,845.0 - 25,000.0 10,000.0 - 885,000.0 165,750.0 - 25,000.0 10,000.0 - 630,000.0 119,595.0 - 25,000.0 10,000.0 1,549.0 449,049.0 88,687.5 - 25,000.0 10,000.0 1,549.0 456,549.0 86,100.0 - 25,000.0 10,000.0 - 542,500.0 100,992.5 - 25,000.0 10,000.0 1,549.0 471,549.0 88,740.0 - 25,000.0 10,000.0 - 545,000.0 114,750.0 - 25,000.0 10,000.0 - 681,000.0 131,138.0 - 25,000.0 10,000.0 - 1,718,000.0 343,332.0 - 25,000.0 10,000.0 - 500,000.0 98,115.0 - 25,000.0 10,000.0 1,549.0 386,549.0 70,350.0 50,000.0 25,000.0 10,000.0 - 530,000.0 100,980.0 - 25,000.0 10,000.0 1,549.0 411,549.0 88,125.0 - 25,000.0 10,000.0 - 455,000.0 81,900.0 - 25,000.0 10,000.0 - 1,520,000.0 298,485.0 - 25,000.0 10,000.0 - 1,520,000.0 319,275.0 - 25,000.0 10,000.0 - 612,500.0 123,007.5 - 25,000.0 10,000.0 - 1,520,000.0 331,155.0 - 25,000.0 10,000.0 - 525,000.0 109,270.0 - 25,000.0 10,000.0 - 595,000.0 120,400.0 - 25,000.0 10,000.0 - 586,000.0 117,363.0 - 25,000.0 10,000.0 - 612,500.0 118,387.5 - 25,000.0 10,000.0 - 612,500.0 128,782.5 -
BONO COLACION
BONO MOVILIZACION
TOTAL HABER
25,000.0 10,000.0 1,549.0 456,549.0 98,280.0 - 25,000.0 10,000.0 1,549.0 456,549.0 89,880.0 - 25,000.0 10,000.0 - 1,520,000.0 348,975.0 - 25,000.0 10,000.0 - 560,000.0 117,075.0 - 25,000.0 10,000.0 - 1,520,000.0 288,090.0 - 25,000.0 10,000.0 - 542,500.0 102,007.5 - 25,000.0 10,000.0 1,549.0 399,049.0 70,687.5 - 25,000.0 10,000.0 - 560,000.0 110,775.0 - 25,000.0 10,000.0 1,549.0 449,049.0 82,087.5 20,000.0 25,000.0 10,000.0 - 586,000.0 110,751.0 - 25,000.0 10,000.0 - 560,000.0 106,575.0 - 25,000.0 10,000.0 1,549.0 471,549.0 93,090.0 - 25,000.0 10,000.0 3,098.0 488,098.0 96,750.0 - 25,000.0 10,000.0 - 681,000.0 131,784.0 - 25,000.0 10,000.0 - 612,500.0 114,922.5 - 25,000.0 10,000.0 - 1,520,000.0 334,125.0 - 25,000.0 10,000.0 1,549.0 399,049.0 74,312.5 - 25,000.0 10,000.0 - 560,000.0 117,600.0 - 25,000.0 10,000.0 3,098.0 488,098.0 96,750.0 - 25,000.0 10,000.0 - 612,500.0 116,077.5 - 25,000.0 10,000.0 1,549.0 486,049.0 104,733.5 - 25,000.0 10,000.0 4,647.0 474,647.0 88,740.0 - 25,000.0 10,000.0 - 525,000.0 100,450.0 - 25,000.0 10,000.0 - 662,000.0 133,551.0 - 25,000.0 10,000.0 - 586,000.0 106,894.0 - 25,000.0 10,000.0 - 662,000.0 122,892.0 - 25,000.0 10,000.0 - 1,520,000.0 319,275.0 - 25,000.0 10,000.0 - 681,000.0 125,324.0 - 25,000.0 10,000.0 4,647.0 402,147.0 77,212.5 - 25,000.0 10,000.0 - 586,000.0 109,649.0 - 25,000.0 10,000.0 - 605,000.0 116,850.0 - 25,000.0 10,000.0 1,549.0 457,049.0 85,782.0 - 25,000.0 10,000.0 4,647.0 489,647.0 101,250.0 - 25,000.0 10,000.0 4,647.0 389,647.0 74,550.0 - 25,000.0 10,000.0 4,647.0 389,647.0 81,550.0 -
82 82 82
SUELDO BASE BONO ANTIGÜEDAD 186,475.0 343,525.0 $ 1 1.0 1.0 102,000.0 339,196.0 $ 1 1.0 1.0 155,435.0 374,565.0 $ 1 1.0 1.0 173,387.5 439,112.5 $ 1 1.0 1.0 80,625.0 334,022.0 $ 1 1.0 1.0 152,760.0 442,240.0 $ 1 1.0 1.0 98,400.0 416,600.0 $ 1 1.0 1.0 75,400.0 328,296.0 $ 1 1.0 1.0 96,525.0 433,475.0 $ 1 1.0 1.0 99,470.0 443,030.0 $ 1 1.0 1.0 85,260.0 371,289.0 $ 1 1.0 1.0 109,060.0 457,940.0 $ 1 1.0 1.0 109,060.0 457,940.0 $ 1 1.0 1.0 109,650.0 435,350.0 $ 1 1.0 1.0 104,037.5 438,462.5 $ 1 1.0 1.0 113,680.0 428,820.0 $ 1 1.0 1.0 113,680.0 428,820.0 $ 1 1.0 1.0 117,363.0 468,637.0 $ 1 1.0 1.0 123,585.0 488,915.0 $ 1 1.0 1.0 201,275.5 312,224.5 $ 1 1.0 1.0 319,275.0 1,200,725.0 $ 1 1.0 1.0 105,705.0 368,942.0 $ 1 1.0 1.0 305,761.5 1,164,738.5 $ 1 1.0 1.0 361,845.0 1,356,155.0 $ 1 1.0 1.0 165,750.0 719,250.0 $ 1 1.0 1.0 119,595.0 510,405.0 $ 1 1.0 1.0 88,687.5 360,361.5 $ 1 1.0 1.0 86,100.0 370,449.0 $ 1 1.0 1.0 100,992.5 441,507.5 $ 1 1.0 1.0 88,740.0 382,809.0 $ 1 1.0 1.0 114,750.0 430,250.0 $ 1 1.0 1.0 131,138.0 549,862.0 $ 1 1.0 1.0 343,332.0 1,374,668.0 $ 1 1.0 1.0 98,115.0 401,885.0 $ 1 1.0 1.0 120,350.0 266,199.0 $ 1 1.0 1.0 100,980.0 429,020.0 $ 1 1.0 1.0 88,125.0 323,424.0 $ 1 1.0 1.0 81,900.0 373,100.0 $ 1 1.0 1.0 298,485.0 1,221,515.0 $ 1 1.0 1.0 319,275.0 1,200,725.0 $ 1 1.0 1.0 123,007.5 489,492.5 $ 1 1.0 1.0 331,155.0 1,188,845.0 $ 1 1.0 1.0 109,270.0 415,730.0 $ 1 1.0 1.0 120,400.0 474,600.0 $ 1 1.0 1.0 117,363.0 468,637.0 $ 1 1.0 1.0 118,387.5 494,112.5 $ 1 1.0 1.0 128,782.5 483,717.5 $ 1 1.0 1.0
TOTAL DESCUENTOS
SUELDO LIQUIDO
AÑOS ANTIGÜEDAD
98,280.0 358,269.0 $ 1 1.0 1.0 89,880.0 366,669.0 $ 1 1.0 1.0 348,975.0 1,171,025.0 $ 1 1.0 1.0 117,075.0 442,925.0 $ 1 1.0 1.0 288,090.0 1,231,910.0 $ 1 1.0 1.0 102,007.5 440,492.5 $ 1 1.0 1.0 70,687.5 328,361.5 $ 1 1.0 1.0 110,775.0 449,225.0 $ 1 1.0 1.0 102,087.5 346,961.5 $ 1 1.0 1.0 110,751.0 475,249.0 $ 1 1.0 1.0 106,575.0 453,425.0 $ 1 1.0 1.0 93,090.0 378,459.0 $ 1 1.0 1.0 96,750.0 391,348.0 $ 1 1.0 1.0 131,784.0 549,216.0 $ 1 1.0 1.0 114,922.5 497,577.5 $ 1 1.0 1.0 334,125.0 1,185,875.0 $ 1 1.0 1.0 74,312.5 324,736.5 $ 1 1.0 1.0 117,600.0 442,400.0 $ 1 1.0 1.0 96,750.0 391,348.0 $ 1 1.0 1.0 116,077.5 496,422.5 $ 1 1.0 1.0 104,733.5 381,315.5 $ 1 1.0 1.0 88,740.0 385,907.0 $ 1 1.0 1.0 100,450.0 424,550.0 $ 1 1.0 1.0 133,551.0 528,449.0 $ 1 1.0 1.0 106,894.0 479,106.0 $ 1 1.0 1.0 122,892.0 539,108.0 $ 1 1.0 1.0 319,275.0 1,200,725.0 $ 1 1.0 1.0 125,324.0 555,676.0 $ 1 1.0 1.0 77,212.5 324,934.5 $ 1 1.0 1.0 109,649.0 476,351.0 $ 1 1.0 1.0 116,850.0 488,150.0 $ 1 1.0 1.0 85,782.0 371,267.0 $ 1 1.0 1.0 101,250.0 388,397.0 $ 1 1.0 1.0 74,550.0 315,097.0 $ 1 1.0 1.0 81,550.0 308,097.0 $ 1 1.0 1.0
82 82 82 82 82
ASIGNACIÓN FAMILIAR 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
ASIGNACION PROFESIONAL
TOTAL IMPONIBLE
BONO COLACION
BONO MOVILIZACION
1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
82 82 82 82 82
TOTAL HABER DESCUENTO LEGAL ANTICIPO 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
TOTAL DESCUENTOS
SUELDO LIQUIDO
1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
CARGO ANTIGÜEDADADMINISTRATIVO $ 350,000 0VENDEDOR $ 300,000 1ADMINISTRATIVO CONTABLE $ 380,000 3SECRETARIA $ 250,000 6GERENTE $ 990,000 10SECRETARIA CONTABLE $ 290,000 15SECRETARIA GERENCIA $ 310,000CONTADOR AUDITOR $ 500,000
Salud Plan AFPFonasa 7.0% CAPITALPromepart 8.0% CUPRUMColmena 9.0% HABITATNormédica 8.0% PLANVITALING 7.5% PROVIDATres Vida 9.0%Más Vida 8.0% ASIG. PROF.Vida Plena 10.0% TECNICO
Banmédica 9.0% PROFESIONAL
Sfera 11.0% ENSEÑANZA MEDIA
Consalud 8.0%
SUELDO BASE
PORC.0.0% $ 25,000 $ 10,000
5.0%10.0%20.0%40.0%60.0%
PORC.12.5%12.4%13.3%12.3%12.1% TECNICO 5%
PORC.5%
10%
0%
BONO COLACION
BONO MOVILIZACION
0 $ 6,776 $ 177,212 $ 4,902 $ 298,028 $ 1,549 $ 464,823 $ -
INGRESO MENSUAL
MONTO ASIG. FAM.
RUT NOMBRE Anticipo1 Anticipo2 Anticipo3 Anticipo4 Anticipo512.639.914-5 Abarza Valenzuela Luis $ 50,000 $ 20,000 $ 15,000
9.041.963-3 Aburto Meza Palmira $ 20,000 8.201.871-9 Acevedo Cabezas Esteban $ 30,000 $ 20,000 9.148.900-7 Acevedo Espinoza Jorge $ 55,000
12.416.643-8 Acevedo González Gloria5.512.105-2 Acevedo Navarro José $ 20,000 $ 23,000 8.205.013-2 Acosta Celis Carlos
16.568.481-8 Adasme Urra Luisa6.597.566-1 Aguilera Cabrera Ivan
10.572.175-7 Aguilera Silva Rodrigo5.744.031-7 Alarcón Casanova Sergio
10.195.382-3 Alarcón González Luis8.368.773-8 Albornoz Sepulveda Luis9.830.153-4 Alfaro González Sergio9.313.119-3 Alfaro Lobos Bartolome
14.396.933-9 Almeida Veliz Ángel8.609.596-3 Altamirano Cuevas Claudio9.635.115-2 Altamirano Quezada Jose6.843.720-2 Alvarez Torres Erick
13.773.889-9 Araneda Araya Victoria $ 50,000 $ 20,000 $ 15,000 16.005.063-2 Araneda Caro Ruben10.742.117-3 Araneda Díaz Victor
9.886.745-7 Araneda Jiménez Gustavo5.660.775-7 Aranguiz Figueroa Carlos5.299.873-5 Aranguiz Figueroa Emilio7.614.081-2 Aravena Martínez Pablo5.990.979-7 Araya Garate Alicia7.060.885-5 Arias Soto Jorge6.091.597-0 Armijo Lizama Leonardo9.900.908-K Arriagada Galaz Emilio7.741.350-2 Arteaga Bravo Pablo
13.452.938-5 Astudillo Guerrero Pedro11.779.030-4 Astudillo Moya Carlos
6.633.876-2 Astudillo Pereira Verónica6.134.686-4 Azócar Riffo Herminda $ 50,000 6.565.470-9 Bacián Lavín Carlos
13.041.762-0 Baez Sanchez Juana5.972.572-6 Balmaceda Valenzuela Luis9.102.917-0 Bascuñán Valdebenito Alfredo
6.434.788-8 Belmar Hormazábal Rodrigo5.338.084-0 Berríos Castro Armando6.235.162-4 Blanco Vera Washington7.402.055-0 Bravo Muñoz Eduardo8.893.085-1 Briones Devlahovich Ronald7.068.541-8 Bustamante Barra Elizabeth
14.444.328-4 Bustos Almonacid Miguel16.190.038-9 Bustos Arraño Guido12.363.857-3 Bustos Mejías Gustavo
6.874.699-k Bustos Toledo Oscar13.724.965-6 Cabello Madrid Carlos
9.693.481-5 Cabezas Castañeda Julio
11.483.660-5 Calderón Cruz Cesar4.308.131-4 Calderón Galaz Jose
11.272.423-0 Calderon Marchant Luisa17.281.737-8 Calderón Muñoz Jorge
7.465.885-7 Campos Carrasco Isabel $ 20,000 21.587.739-3 Campos Moreno Sergio
8.547.643-2 Campos Reyes Juan7.526.244-2 Cantillana Pavez Raul
10.693.180-K Cárcamo Santander Roberto13.924.346-3 Carmona Moralez Daniel10.277.556-2 Caro Aranguiz Angel10.600.081-6 Caro Garrido Karina15.408.521-1 Carrasco Hernández Georgina13.773.703-5 Carrasco Salas Juan13.370.080-3 Carú Salinas Marío
7.411.669-8 Carvajal Toro Marcos3.903.946-K Castro Córdova Silvia8.462649-K Castro Mora Richard6.633.613-1 Castro Vásquez Bernardo5.334.664-2 Catalán Toro Armanda
11.363.914-8 Catrileo Paine Eliana10.275.887-0 Chamorro Vidal Isolina10.866.347-2 Chaparro Reyes Myriam
5.057.894-1 Chávez González Elsa8.085.060-3 Cofré Zurita Nancy 7.349.976-3 Concha Barrera Nancy9.688.702-4 Conejeros Pacheco Sonia6.388.776-5 Contreras Márquez Laura
13.341.793-1 Muñoz Lopez Jose9.043.059-9 Muñoz Lopez Maite
13.775.025-2 Muñoz Lopez Vanessa
Suma Anticipos $ 85,000 $ 20,000 $ 50,000 $ 55,000 $ - $ 43,000 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 85,000 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 50,000 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ - $ - $ - $ - $ 20,000 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Sub Principal_2()' Sheets("DATOS_PERSONALES").Select ActiveSheet.Next.Select Do While ActiveSheet.Name <> "FIN" Application.Run "AsignaPuntos" ActiveSheet.Next.Select Loop Application.Run "Confecciona_Tabla_Resultados_2"End SubSub Confecciona_Tabla_Resultados_2()' Sheets("datos_personales").Select Range("L6").Select ActiveCell.FormulaR1C1 = "TOTAL DE PUNTOS" Range("O6").Select ActiveCell.FormulaR1C1 = _ "=SUM('datos_personales:FIN'!R[-4]C[-13]:R[-2]C[-13])" Range("L7").Select ActiveCell.FormulaR1C1 = "PTS.OBTENIDOS ALUMNO" Range("O7").Select ActiveCell.FormulaR1C1 = _ "=SUM('datos_personales:FIN'!R[-5]C[-14]:R[-3]C[-14])"
Range("L7").Select ActiveCell.FormulaR1C1 = "PTS.OBTENIDOS ALUMNO" Range("O7").Select ActiveCell.FormulaR1C1 = _ "=SUM('datos_personales:FIN'!R[-5]C[-14]:R[-3]C[-14])" Range("L8").Select ActiveCell.FormulaR1C1 = "PORCENTAJE OBTENIDO" Range("O8").Select ActiveCell.FormulaR1C1 = "=(R[-1]C*100)/R[-2]C" Range("L10").Select ActiveCell.FormulaR1C1 = "NOTA OBTENIDA (1-7)" Range("O10").Select ActiveCell.FormulaR1C1 = "=(R[-3]C*7)/R[-4]C"End SubSub AsignaPuntos()' Range("B2:B4").Select Selection.Copy Range("A2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False ActiveWindow.Zoom = 90End Sub
Sub Principal_2()' Sheets("DATOS_PERSONALES").Select ActiveSheet.Next.Select Do While ActiveSheet.Name <> "FIN" Application.Run "AsignaPuntos" ActiveSheet.Next.Select Loop Application.Run "Confecciona_Tabla_Resultados_2"End SubSub Confecciona_Tabla_Resultados_2()' Sheets("datos_personales").Select Range("L6").Select ActiveCell.FormulaR1C1 = "TOTAL DE PUNTOS" Range("O6").Select ActiveCell.FormulaR1C1 = _ "=SUM('datos_personales:FIN'!R[-4]C[-13]:R[-2]C[-13])" Range("L7").Select ActiveCell.FormulaR1C1 = "PTS.OBTENIDOS ALUMNO" Range("O7").Select ActiveCell.FormulaR1C1 = _ "=SUM('datos_personales:FIN'!R[-5]C[-14]:R[-3]C[-14])"
Range("L7").Select ActiveCell.FormulaR1C1 = "PTS.OBTENIDOS ALUMNO" Range("O7").Select ActiveCell.FormulaR1C1 = _ "=SUM('datos_personales:FIN'!R[-5]C[-14]:R[-3]C[-14])" Range("L8").Select ActiveCell.FormulaR1C1 = "PORCENTAJE OBTENIDO" Range("O8").Select ActiveCell.FormulaR1C1 = "=(R[-1]C*100)/R[-2]C" Range("L10").Select ActiveCell.FormulaR1C1 = "NOTA OBTENIDA (1-7)" Range("O10").Select ActiveCell.FormulaR1C1 = "=(R[-3]C*7)/R[-4]C"End SubSub AsignaPuntos()' Range("B2:B4").Select Selection.Copy Range("A2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False ActiveWindow.Zoom = 90End Sub
Sub Principal_2()' Sheets("DATOS_PERSONALES").Select ActiveSheet.Next.Select Do While ActiveSheet.Name <> "FIN" Application.Run "AsignaPuntos" ActiveSheet.Next.Select Loop Application.Run "Confecciona_Tabla_Resultados_2"End SubSub Confecciona_Tabla_Resultados_2()' Sheets("datos_personales").Select Range("L6").Select ActiveCell.FormulaR1C1 = "TOTAL DE PUNTOS" Range("O6").Select ActiveCell.FormulaR1C1 = _ "=SUM('datos_personales:FIN'!R[-4]C[-13]:R[-2]C[-13])" Range("L7").Select ActiveCell.FormulaR1C1 = "PTS.OBTENIDOS ALUMNO" Range("O7").Select ActiveCell.FormulaR1C1 = _ "=SUM('datos_personales:FIN'!R[-5]C[-14]:R[-3]C[-14])"
Range("L7").Select ActiveCell.FormulaR1C1 = "PTS.OBTENIDOS ALUMNO" Range("O7").Select ActiveCell.FormulaR1C1 = _ "=SUM('datos_personales:FIN'!R[-5]C[-14]:R[-3]C[-14])" Range("L8").Select ActiveCell.FormulaR1C1 = "PORCENTAJE OBTENIDO" Range("O8").Select ActiveCell.FormulaR1C1 = "=(R[-1]C*100)/R[-2]C" Range("L10").Select ActiveCell.FormulaR1C1 = "NOTA OBTENIDA (1-7)" Range("O10").Select ActiveCell.FormulaR1C1 = "=(R[-3]C*7)/R[-4]C"End SubSub AsignaPuntos()' Range("B2:B4").Select Selection.Copy Range("A2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False ActiveWindow.Zoom = 90End Sub
Sub Principal_2()' Sheets("DATOS_PERSONALES").Select ActiveSheet.Next.Select Do While ActiveSheet.Name <> "FIN" Application.Run "AsignaPuntos" ActiveSheet.Next.Select Loop Application.Run "Confecciona_Tabla_Resultados_2"End SubSub Confecciona_Tabla_Resultados_2()' Sheets("datos_personales").Select Range("L6").Select ActiveCell.FormulaR1C1 = "TOTAL DE PUNTOS" Range("O6").Select ActiveCell.FormulaR1C1 = _ "=SUM('datos_personales:FIN'!R[-4]C[-13]:R[-2]C[-13])" Range("L7").Select ActiveCell.FormulaR1C1 = "PTS.OBTENIDOS ALUMNO" Range("O7").Select ActiveCell.FormulaR1C1 = _ "=SUM('datos_personales:FIN'!R[-5]C[-14]:R[-3]C[-14])"
Range("L7").Select ActiveCell.FormulaR1C1 = "PTS.OBTENIDOS ALUMNO" Range("O7").Select ActiveCell.FormulaR1C1 = _ "=SUM('datos_personales:FIN'!R[-5]C[-14]:R[-3]C[-14])" Range("L8").Select ActiveCell.FormulaR1C1 = "PORCENTAJE OBTENIDO" Range("O8").Select ActiveCell.FormulaR1C1 = "=(R[-1]C*100)/R[-2]C" Range("L10").Select ActiveCell.FormulaR1C1 = "NOTA OBTENIDA (1-7)" Range("O10").Select ActiveCell.FormulaR1C1 = "=(R[-3]C*7)/R[-4]C"End SubSub AsignaPuntos()' Range("B2:B4").Select Selection.Copy Range("A2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False ActiveWindow.Zoom = 90End Sub