Research on the application of pivot table auxiliary function in hospital human resources system / 中国医学装备

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.

EXCEL function algorithm in the hospital department performance the application of overtime / 中国医学装备

Objective: Statistical work overtime hospital surgical performance, understand the overtime rate in all the subjects, facilitating leaders make decisions in time, reasonable allocate resources to plan as a whole. Methods:using the time function and the automatic calculation logic function, and finally use pivot table function. Results:Reflect the medical surgery, overtime data provide a reference for the head nurse in nursing management. Statistical results show that the gynecology and obstetrics, orthopaedics, thoracic surgery, secrete surgery, general surgery frequency more overtime. Facilitate the matron reasonable flexible scheduling, optimize work processes;at the same time make the nurse work enthusiasm by passive status to active status, avoid buck-passing, realize the labor remuneration is closely related to job performance. Conclusion:Inspire staff enthusiasm, to strengthen the medical management has a guiding role.