Research on the application of pivot table auxiliary function in hospital human resources system
10.3969/J.ISSN.1672-8270.2014.11.026
- VernacularTitle:数据透视表辅助功能在医院人力资源系统中的应用
- Author:
Mei LI
;
Yunhong ZHANG
;
Jiangyun SHI
- Publication Type:Journal Article
- Keywords:
Manpower resource;
Management system;
Pivot table;
Difference
- From:
China Medical Equipment
2014;(11):70-71,72
- CountryChina
- Language:Chinese
-
Abstract:
Objective:To use pivot tables will pay the most valuable information in the table, add, reduce staff this month, and does not increase don't decreases but the amount of personnel data extract and work department is changed.Methods: Use pivot table to find differences, by adding auxiliary column identifier (1,-1) to solve the existing in the personnel salary is different.Results:Dynamic understanding of the inflows and outflows of hospital employees, in order to grasp the change situation of hospital human resource cost.Conclusion: It saves the human, fast and convenient, improves the work efficiency and accuracy.