11,677
edits
Changes
Updating to match new version of source page
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 distribution of labor force 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]]
Information on the ''HRRH'' spreadsheet:
* '''Data Competência''': Date of data collection on the HR system
* '''Centro de Custo''': Name of the cost center where the employee is designated
* '''Colaborador''': Employee's name and code
* '''Estado Civil''': Employee's marital status
* '''Tipo Contrato''': Type of employment association with the employee
* '''Periculosidade''': Indicates if the employee performs a function considered dangerous
* '''Insalubridade''': Indicates if the employee performs a function considered unhealthy
* '''Data Demissão''': The date when the employee was dismissed from the company
* '''Remuneração Mês''': The value of the employee's net remuneration in the month of competence
* '''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
* '''Collaboration analysis by cost center'''
* '''Management of employees by branch'''
* '''Ranking of employees with more absence'''