基于Excel的DRG可视化运营分析系统设计与应用研究  

Design and Application of DRG Visual Operation Analysis System Based on Excel

作　　者：陈松鹤 陈志文 CHEN Song-he;CHEN Zhi-wen(Hangzhou Women's Hospital)

机构地区：[1]杭州市妇产科医院

出　　处：《医院管理论坛》2024年第9期94-96,71,共4页Hospital Management Forum

摘　　要：目的本研究旨在设计一种基于Excel的DRG(疾病相关分组)可视化运营分析系统,并将其应用于某三甲医院的病历数据分析中。方法通过实现数据准备、DRG分组、Excel数据统计与分析和图表生成等功能,实现自动计算和分析数据的功能,并生成简洁明了的医保DRG可视化图表报告。结果该系统具有操作简单、灵活性强、成本低等优点,能够为医院管理层提供及时、准确的运营分析数据支持。结论基于Excel的DRG可视化运营分析系统能有效解决医院现有DRG运营分析工具成本高、灵活性差等问题,提高医院运营管理的效率和综合效益。Objective This study aims to design an Excel-based DRG(disease related groups)visualization and operation analysis system and apply it to the medical record data analysis in a grade-A tertiary hospital.Methods By implementing the functions of data preparation,DRG grouping,Excel data statistics and analysis,and chart generation,the functions of automatic calculation and analysis of data were realized,and a concise and clear medical insurance DRG visualization chart report was generated.Results The system has the advantages of easy operation,flexibility,and low cost,which can provide timely and accurate operational analysis data support for hospital management.Conclusion The Excel-based DRG visualization operational analysis system can effectively solve the problems of high cost and poor flexibility in the existing DRG operational analysis tools used by hospitals,and improve the efficiency and comprehensive benefits of hospital operations management.

关 键 词：疾病相关分组 可视化 

分 类 号：R197.5[医药卫生—卫生事业管理]