Changes

← Older edit

Template RH/en

1,512 bytes added, 02:28, 5 October 2022

Updating to match new version of source page

<b style="color:red;">Notice:</b> This template has not yet been translated into ''English'' and ''Spanish''.

Through the ''HRRH'' template, the HR managers can automate, with a low cost, a generation and a distribution, with security and confidentiality, like information on the staff.

Learn through the available dashboards:

* the HR costs by cost center,

.* overtime rates by cost center,

.* which employees with the most absences,

* if the employee's level of education and age group are within the company's standards.

Download the example worksheet, using the link below, replace with your data and update the [[Data Sources|datasource]] to start analyzing immediately and improve the management of your employees. If you do not have all the data available, leave the corresponding columns blank.

[[Special:FilePath/RH.xlsx|Download Sample Worksheet]]

Information on the ''HRRH'' spreadsheet:

* '''Data Competência''': Date of data collection on the HR system

.* '''Empresa''': Employer's name

* '''Filial''': Name of the branch where the employee works

* '''Cargo''': Description of the position that the employee occupies within the company

.* '''Tipo Contrato''': Type of employment association with the employee

.* '''Situação''': Indicates whether the employee is on active staff

.* '''Tipo Situação''': Indicates the employee's dismissal reason

.* '''Periculosidade''': Indicates if the employee performs a function considered dangerous

.* '''Insalubridade''': Indicates if the employee performs a function considered unhealthy

* '''Data Admissão''': The date when the employee started working at the company

.* '''Data Demissão''': The date when the employee was dismissed from the company

.* '''Salário Mês''': The value of the salary paid to the employee in the month of competence

* '''Remuneração Mês''': The value of the employee's net remuneration in the month of competence

* '''Passivo Décimo Terceiro''': valor provisionado para o décimo terceiro salário

.* '''Passivo Férias''': Amount provisioned for vacations

* '''Passivo FGTS''': valor que foi recolhido para o FGTS do colaborador

* '''Bnf. Outros''': Amount paid under other benefits

* '''Qtd.Horas Extras''': The amount of overtime worked

* '''Valor Horas Extras''': The value of overtime worked

* '''Qtd.Horas Pagas''': The number of hours paid

* '''Qtd.Horas Faltas''': The number of hours the employee missed work

.* '''Percentual de Horas Faltas''': Percentage of absences over hours paid

Analysis:

.* '''Collaboration analysis by cost center'''

* '''Monthly Cost analysis by Cost Center'''

.* '''Management of employees by branch'''

.* '''Overtime information'''

* '''Ranking of employees with more absence'''

FuzzyBot

11,677

edits

TaticView β

Changes

Template RH/en

TaticView ^β