Scribd Logo
Upload

Welcome to Scribd!

  • 30 views

    TALLER+DE+REPASO+1 Bryan CASQUINO

    Uploaded by

    Bryan Casquino
    The document contains a payroll sheet listing employees of a company with their codes, names, gender, salary, pension system, hire date, family charges, assignments, bonuses, contributions and net pay. It includes statistics, filters and a dynamic table function to analyze the payroll data.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    TALLER+DE+REPASO+1 Bryan CASQUINO

    Uploaded by

    Bryan Casquino
    30 views11 pages
    The document contains a payroll sheet listing employees of a company with their codes, names, gender, salary, pension system, hire date, family charges, assignments, bonuses, contributions and net pay. It includes statistics, filters and a dynamic table function to analyze the payroll data.

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains a payroll sheet listing employees of a company with their codes, names, gender, salary, pension system, hire date, family charges, assignments, bonuses, contributions and net pay. It includes statistics, filters and a dynamic table function to analyze the payroll data.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    30 views11 pages

    TALLER+DE+REPASO+1 Bryan CASQUINO

    Uploaded by

    Bryan Casquino
    The document contains a payroll sheet listing employees of a company with their codes, names, gender, salary, pension system, hire date, family charges, assignments, bonuses, contributions and net pay. It includes statistics, filters and a dynamic table function to analyze the payroll data.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 11

    FÓRMULAS Y FUNCIONES

    PLANILLA
    RMV S/.930.00

    SUELDO
    CÓDIGO TRABAJADOR GÉNERO SISTEMA FECHA INGRESO
    BÁSICO

    SP2012 Salinas/Patricia M S/. 930.00 PROFUTURO 9/1/2012


    CR2012 Cuadros/Ruth M S/. 930.00 ONP 9/1/2012
    VM2013 Valdivia/Marianela M S/. 930.00 PRIMA 1/17/2013
    VL2013 Valdez/Luisa M S/. 930.00 PROFUTURO 1/18/2013
    TS2013 Torres/Shirley M S/. 930.00 PRIMA 1/19/2013
    SP2012 Segovia/Pamela M S/. 930.00 PRIMA 9/1/2012
    SV2012 Salinas/Victor H S/. 930.00 HABITAT 9/1/2012
    RJ2013 Ruiz/Jaqueline M S/. 930.00 HABITAT 1/17/2013
    LJ2012 Lazarte/Jacqueline M S/. 930.00 PRIMA 9/1/2012
    MF2012 Manchego/Francis H S/. 930.00 PROFUTURO 9/1/2012
    ME2013 Mamani/Edwin H S/. 930.00 INTEGRA 1/17/2013
    PJ2013 Perez/Juan H S/. 930.00 INTEGRA 1/18/2013
    GK2013 Gonzales/Karelia M S/. 930.00 INTEGRA 1/19/2013
    HM2012 Huaracha/Martín H S/. 930.00 ONP 9/1/2012
    MK2012 Manrique/Kattya M S/. 930.00 PRIMA 9/1/2012
    HE2013 Hachira/Enrique H S/. 930.00 HABITAT 1/19/2013
    GM2012 Gutiérrez/Mauricio H S/. 930.00 HABITAT 9/1/2012
    GV2013 Garzón/Vannesa M S/. 930.00 PRIMA 1/17/2013
    GA2013 García/Arturo H S/. 930.00 PROFUTURO 1/18/2013
    FJ2013 Flores/Javier H S/. 930.00 HABITAT 1/19/2013
    EP2014 Escobedo/Peter H S/. 930.00 HABITAT 9/1/2014
    EP2012 Escalante/Pablo H S/. 930.00 PRIMA 9/1/2012
    DK2013 Diaz/Katia M S/. 930.00 PROFUTURO 1/19/2013
    FP2015 Fernandez/Pedro H S/. 930.00 INTEGRA 9/1/2015
    CM2015 Chavez/Miguel H S/. 930.00 INTEGRA 7/1/2015
    CJ2017 Chaico/Jesús H S/. 930.00 INTEGRA 6/30/2017
    CA2012 Castillo/Antonio H S/. 930.00 ONP 9/2/2012
    CA2012 Carpio/Angel H S/. 930.00 PRIMA 9/3/2012
    BJ2015 Bueno/Jorge H S/. 930.00 HABITAT 7/1/2015
    BJ2017 Ballenas/Juan H S/. 930.00 ONP 6/30/2017
    Y FUNCIONES

    NILLA

    CARGA ASIGNACIÓN BONO DE APORTE


    DIAS TRAB PRODUCTIVIDA NETO A PAGAR
    FAMILIAR FAMILIAR SISTEMA
    D
    30 1 S/. 1,023.00 S/. 46.50 S/. 121.37 S/. 2,120.87
    30 S/. - S/. 46.50 S/. 120.90 S/. 1,097.40
    29 2 S/. 1,023.00 S/. - S/. 120.53 S/. 2,073.53
    28 3 S/. 1,023.00 S/. - S/. 121.37 S/. 2,074.37
    30 1 S/. 1,023.00 S/. 46.50 S/. 120.53 S/. 2,120.03
    27 S/. - S/. - S/. 120.53 S/. 1,050.53
    30 1 S/. 1,023.00 S/. 46.50 S/. 119.32 S/. 2,118.82
    30 2 S/. 1,023.00 S/. 46.50 S/. 119.32 S/. 2,118.82
    30 3 S/. 1,023.00 S/. 46.50 S/. 120.53 S/. 2,120.03
    29 1 S/. 1,023.00 S/. - S/. 121.37 S/. 2,074.37
    30 2 S/. 1,023.00 S/. 46.50 S/. 120.06 S/. 2,119.56
    30 1 S/. 1,023.00 S/. 46.50 S/. 120.06 S/. 2,119.56
    28 4 S/. 1,023.00 S/. - S/. 120.06 S/. 2,073.06
    30 1 S/. 1,023.00 S/. 46.50 S/. 120.90 S/. 2,120.40
    30 S/. - S/. 46.50 S/. 120.53 S/. 1,097.03
    27 2 S/. 1,023.00 S/. - S/. 119.32 S/. 2,072.32
    30 3 S/. 1,023.00 S/. 46.50 S/. 119.32 S/. 2,118.82
    30 1 S/. 1,023.00 S/. 46.50 S/. 120.53 S/. 2,120.03
    29 1 S/. 1,023.00 S/. - S/. 121.37 S/. 2,074.37
    30 2 S/. 1,023.00 S/. 46.50 S/. 119.32 S/. 2,118.82
    30 2 S/. 1,023.00 S/. 46.50 S/. 119.32 S/. 2,118.82
    29 S/. - S/. - S/. 120.53 S/. 1,050.53
    30 5 S/. 1,023.00 S/. 46.50 S/. 121.37 S/. 2,120.87
    30 1 S/. 1,023.00 S/. 46.50 S/. 120.06 S/. 2,119.56
    28 S/. - S/. - S/. 120.06 S/. 1,050.06
    30 2 S/. 1,023.00 S/. 46.50 S/. 120.06 S/. 2,119.56
    25 4 S/. 1,023.00 S/. - S/. 120.90 S/. 2,073.90
    30 2 S/. 1,023.00 S/. 46.50 S/. 120.53 S/. 2,120.03
    30 5 S/. 1,023.00 S/. 46.50 S/. 119.32 S/. 2,118.82
    30 S/. - S/. 46.50 S/. 120.90 S/. 1,097.40
    APORTE AL FONDO DE
    SISTEMA COMISIÓN PRIMA DE SEGUROS TOTAL
    PENSIONES

    HABITAT 10.00% 1.47% 1.36% 13%


    INTEGRA 10.00% 1.55% 1.36% 13%
    PRIMA 10.00% 1.60% 1.36% 13%
    PROFUTURO 10.00% 1.69% 1.36% 13%
    ONP 13.00%

    ESTADÍSTICAS
    1º Carga familiar del trabajador cuyo código se encuentra en la celda D8
    2º Media o promedio de aportes al Sistema de todos los trabajadores
    3º Mayor monto que se pagará por concepto Bono de Productividad
    4º Cantidad de mujeres que laboran en la empresa 12
    5º Día de la semana en que ingresó a trabajar el trabajador de código ME2013
    6º Suma total de los sueldos netos a pagar de los trabjadores que si tienen hijos
    ME2013
    FILTROS AVANZADOS

    1º Filtrar a todos los trabajadores cuyo código termine con 13, que estén afiliados a la AFP Habitat y cuyo ap

    2º Filtrar a todos los trabajadoras que tengan más de dos hijos y cuyo neto a pagar sea igual o mayor a s/. 8
    a la AFP Habitat y cuyo apellido no empiece con R.

    ar sea igual o mayor a s/. 800 y menor o igual a s/. 950


    TABLAS DINÁMICAS

    Crear una tabla dinámica que muestre a los trabajadores por Sistema de Pensión, además muestre los totales de
    ón, además muestre los totales de aportes al sistema y los promedios de sus sueldos Netos a pagar.
    FUNCIONES FINANCIERAS
    5000
    Cantidad 15
    TEA
    Meses
    Pago mensual
    36
    SOLVER

    You might also like