中国医学装备Issue(10)：70-71,72,3.DOI:10.3969/J.ISSN.1672-8270.2014.10.024
EXCEL函数计算方法在医院科室绩效统计中的应用
EXCEL function algorithm in the hospital department performance the application of overtime
史江云 1李梅 1李兰琴1
作者信息
- 1. 兰州军区乌鲁木齐总医院财经中心经管科 新疆 乌鲁木齐 830000
- 折叠
摘要
Abstract
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.关键词
EXCEL函数/数据透视表/手术加班绩效Key words
EXCEL function/Pivot table/Work overtime operation performance分类
医药卫生引用本文复制引用
史江云,李梅,李兰琴..EXCEL函数计算方法在医院科室绩效统计中的应用[J].中国医学装备,2014,(10):70-71,72,3.
