Automatic Evaluation Model of Infusion Pump Maintenance Cost Based on Excel
BAO Lia, ZHENG Kuna,b
a. Department of Medical Equipment丨 b. Department of Logistics Support, The Children’s Hospital, Zhejiang University School of
Medicine, Hangzhou Zhejiang 310057, China
Abstract：Objective To establish an automatic evaluation model in Excel, which can quickly evaluate the infusion pump
maintenance cost, that is, whether to choose repair or not. Methods The use and repair history of the pump were reviewed and
analyzed. The calculation model was built and realize automation in Excel. Results The consistency between the automatic
evaluation model built in Excel and subjective judgment reached 75%, which could feed back the results of subjective judgment.
Conclusion The automatic evaluation model can quickly evaluate the maintenance cost, unify the evaluation standard, improve the
work efficiency, reduce the cost of use, and feature strong mobility.
鲍莉a，郑焜a,b. 基于Excel的输注泵维修费用的自动评估模型[J]. 中国医疗设备, 2022, 37(1): 12-14.
BAO Lia, ZHENG Kuna,b. Automatic Evaluation Model of Infusion Pump Maintenance Cost Based on Excel. China Medical Devices, 2022, 37(1): 12-14.
