Abstract: 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.

Key words: Implant appointment, Electronic medical record, Dental implant, Conditional format