摘要
目的:探讨建立种植修复患者的预约表格,通过其颜色改变,提示各种植修复患者的预约时间,并通过其与相应种植电子病历文档的链接和编号,实现种植电子病历库的建立和科学管理。方法:以Windows XP为操作系统,2003 Microsoft Excel应用软件为基础,设计成Excel表格。通过对Excel应用软件中"条件格式"命令的设置,使表格相应行随患者预约时间变化而改变颜色,达到提醒预约时间的目的,并对表格中种植患者姓名或种植电子病历编号与相应种植电子病历库中的文档建立相应链接。结果:建立并设置了Excel表格。当天进行种植Ⅰ期手术的患者,该行底色自动显示为红色;种植术后患者骨结合时间即将到来前2周,该行底色自动显示为黄色;当天预约好进行Ⅱ期手术或上部结构修复的复诊患者,该行底色自动显示为绿色;已经种植修复完成的患者,该行底色设置为灰色。通过点击患者姓名或种植编号,可以直接打开该患者的种植电子病历,查阅其种植基本情况。结论:通过表格颜色的变化提示种植患者的预约时间,并通过表格中患者姓名或编号的相应链接直接查阅患者的种植电子病历,具有一定的临床实用价值。
PURPOSE： To design an excel form which can prompt dental implant patient appointment through color change, which can scientifically manage implant EMR library through appropriate interlinkage and number. METHODS： An excel form based on operating system Windows XP was designed and software 2003 Microsoft excel was used, which was configured to change color with the passage of time by the use of command ＂conditional format＂. RESULTS： An excel form was designed. The color turned to red automatically on the day the patient underwent implant surgery. It turned to yellow when the patient recalled 2 weeks after the first operation, to green when the patient underwent secondary operation. It was designed to be gray when all the procedures of implant restoration was finished. In addition, we could know patients＇ main implant situation through directly opening his EMR when clicking on his name or number. CONCLUSIONS： Dentists can remind the implant patient appointment schedule through color change of an excel form, and can consult the implant patient EMR directly through interlinkage or number.
出处
《上海口腔医学》
CAS
CSCD
北大核心
2013年第5期562-566,共5页
Shanghai Journal of Stomatology
关键词
种植预约
电子病历
口腔种植
条件格式
Implant appointment
Electronic medical record
Dental implant
Conditional format
