EXCEL函数计算方法在医院科室绩效统计中的应用
|
摘要
目的:将EXCEL函数算法用于统计医院外科手术加班绩效,了解各科加班频率,便于领导者及时做出决策,合理统筹调配资源。方法:运用时间函数和逻辑判断函数自动计算,最后运用数据透视表功能进行统计。结果:统计结果显示,妇产科、骨科、胸外科、泌尿外科及普外科加班频率多,为护士长进行护理管理提供参考数据,便于合理实施弹性排班,优化工作流程;同时使护士工作由被动状态变为主动状态,避免工作相互推诿,实现了劳动报酬与工作业绩密切相关。结论:该方法的应用激励医务人员积极性,对加强医疗管理有指导作用。
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.
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.
引文
[1]陈月秀,杜丽萍,宋燕娇,等.绩效管理流程在手术室的应用与分析[J].护理实践与研究,2012,9(16):93-94.
[2]颜彦姝,矫艳京.依据手术时间分布实施手术室护理人员调度策图的探讨[J].中国护理管理,2013,13(4)52-53.
[3]孙丽,王巧萍,孙美红.手术室加班环境中积极情绪的培养与应用[J].天津护理,2010,18(4):237-238.
[4]陈玉巧,刘凤莲,董飞翔.量化考核在手术室绩效管理中的应用[J].中国当代医药,2011,18(31):118-119.
[5]钟瑞娟,常后婵.优化手术室管理模式对手术室工作效率作用[J].国际护理学杂志,2012,31(12):2317-2318.
[6]杨玉兰.手术室不安全因素原因分析与防范[J].中国误诊学杂志,2006,6(14):2843-2844.
[7]EXCELHOME.罗拉的奋斗EXCEL菜鸟升职记[M].北京:人民邮电出版社,2012.
[8]李红林,马君余.Excel在试剂耗材效期管理中的应用[J].现代检验医学杂志,2009(3):36-37.
[9]EXCEL研究组.EXCEL2007函数与公式应用大全[M].北京:电子工业出版社,2008:48-57.
[10]伍昊.你早该这么玩EXCELⅡ[M].北京:北京大学出版社,2012:203-208.
[11]EXCELHOME.EXCE函数与公式实战技巧精粹[M].北京:人民邮电出版社,2008:140.
[12]ATCT.如何将计算后的时间格式转换为数字格式[EB/OL].(2004-10-5)[2013-11]http://club.excelhome.net/forum.php?mod=viewthread&tid=64385&highlight.
[13]张菊芬,陈侃侃,梁敏,等.基于EXCEL数据透视表的手术分类统计探讨[J].中国病案,2010,11(11):40-41.
[14]周力,赵琳,徐梅,等.手术室实施弹性排班制度效果评价[J].护理管理,2002,2(2):57-59.
[15]吕凌云,孟宗霞.谈手术室弹性工作制后的晨间交班内容[J].中国保健,2007,15(7):76.
[2]颜彦姝,矫艳京.依据手术时间分布实施手术室护理人员调度策图的探讨[J].中国护理管理,2013,13(4)52-53.
[3]孙丽,王巧萍,孙美红.手术室加班环境中积极情绪的培养与应用[J].天津护理,2010,18(4):237-238.
[4]陈玉巧,刘凤莲,董飞翔.量化考核在手术室绩效管理中的应用[J].中国当代医药,2011,18(31):118-119.
[5]钟瑞娟,常后婵.优化手术室管理模式对手术室工作效率作用[J].国际护理学杂志,2012,31(12):2317-2318.
[6]杨玉兰.手术室不安全因素原因分析与防范[J].中国误诊学杂志,2006,6(14):2843-2844.
[7]EXCELHOME.罗拉的奋斗EXCEL菜鸟升职记[M].北京:人民邮电出版社,2012.
[8]李红林,马君余.Excel在试剂耗材效期管理中的应用[J].现代检验医学杂志,2009(3):36-37.
[9]EXCEL研究组.EXCEL2007函数与公式应用大全[M].北京:电子工业出版社,2008:48-57.
[10]伍昊.你早该这么玩EXCELⅡ[M].北京:北京大学出版社,2012:203-208.
[11]EXCELHOME.EXCE函数与公式实战技巧精粹[M].北京:人民邮电出版社,2008:140.
[12]ATCT.如何将计算后的时间格式转换为数字格式[EB/OL].(2004-10-5)[2013-11]http://club.excelhome.net/forum.php?mod=viewthread&tid=64385&highlight.
[13]张菊芬,陈侃侃,梁敏,等.基于EXCEL数据透视表的手术分类统计探讨[J].中国病案,2010,11(11):40-41.
[14]周力,赵琳,徐梅,等.手术室实施弹性排班制度效果评价[J].护理管理,2002,2(2):57-59.
[15]吕凌云,孟宗霞.谈手术室弹性工作制后的晨间交班内容[J].中国保健,2007,15(7):76.