CAJ | 학술논문

目的：将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.