| 数据透视表辅助功能在医院人力资源系统中的应用 |
| |
| 引用本文： | 李梅,张云宏,史江云. 数据透视表辅助功能在医院人力资源系统中的应用[J]. 中国医学装备, 2014, 0(11): 70-72 |
| |
| 作者姓名： | 李梅 张云宏 史江云 |
| |
| 作者单位： | 兰州军区乌鲁木齐总医院经济管理科 新疆 乌鲁木齐 830000 |
| |
| 摘 要： | 目的：利用数据透视表将工资表中当月新增、减少人员以及人员不增不减但金额和工作科室有变动的数据信息快速提取。方法：利用数据透视表寻找差异,通过增加辅助列标识（1、-1）解决人员工资中存在不同。结果：动态了解医院员工的流入和流出情况,以便掌握医院人力资源成本的变化情况。结论：数据透视表辅助功能可节约人力资源成本,方便快捷,提高工作效率和准确率。
|
| 关 键 词： | 人力资源 管理系统 数据透视表 差异 |
Research on the application of pivot table auxiliary function in hospital human resources system |
| |
| LI Mei,ZHANG Yun-hong,SHI Jiang-yun. Research on the application of pivot table auxiliary function in hospital human resources system[J]. China Medical Equipment, 2014, 0(11): 70-72 |
| |
| Authors: | LI Mei ZHANG Yun-hong SHI Jiang-yun |
| |
| Affiliation: | ( Financial Center in Urumqi, Lanzhou Military Region General Hospital, Urumqi 850000, China.) |
| |
| 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. |
| |
| Keywords: | Manpower resource Management system Pivot table Difference |
| 本文献已被 维普 等数据库收录！ |
|
