11,677
edits
Changes
Updating to match new version of source page
<languages/>
<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.
* the HR costs by cost center,
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]] [[Share dashboards|Share]] your information with other company managers by displaying only the information relevant to them while you still have full access to all information.
Information on the ''HRRH'' spreadsheet:
* '''Data Competência''': Date of data collection on the HR system
* '''Filial''': Name of the branch where the employee works
* '''Colaborador''': Employee's name and code
* '''Estado Civil''': Employee's marital status
* '''Tipo Contrato''': Type of employment association with the employee
* '''Remuneração Mês''': The value of the employee's net remuneration in the month of competence
* '''Bnf. Outros''': Amount paid under other benefits
* '''Qtd.Horas Extras''': The amount of overtime worked
* '''Qtd.Horas Pagas''': The number of hours paid
* '''Qtd. Horas Faltas''': The number of hours the employee missed work
Analysis:
* '''Monthly Cost analysis by Cost Center'''
* '''Ranking of employees with more absence'''