Paid on delivery
NEED THREE SHEETS
Patient Entry Sheet
Last Visit Date
Follow-Up Interval (in days/weeks)
Next Appointment Date (automatically calculated)
Description/Notes (for treatment notes or other relevant information)
Purpose: To enter and store patient details, calculate their next appointment date, and record any notes or treatment descriptions.
Today's Call List Sheet
Next Appointment Date
Call Status (checkbox or dropdown for 'Called', 'Not Called', etc.)
Description/Notes (pulled from the Patient Entry Sheet)
Purpose: To display patients who need to be called today, along with relevant notes.
Additional Requirement: If the Call Status is not marked as 'Called', the patient should remain on the list for the next day.
Complete Patient List Sheet
Columns: A comprehensive list of all patient details, including notes.
Purpose: To maintain a complete record of all patients, their appointment history, and any notes or treatment descriptions.
Automated Date Calculation: The system should automatically calculate the Next Appointment Date based on the Last Visit Date and Follow-Up Interval.
PLEASE ALSO SUGGEST SOME OTHER TOOLS TO MAKE THIS EASY
Project ID: #37489908
About the project
33 freelancers are bidding on average ₹1606 for this job
Hi, i am an expert in Excel. Excellent Knowledge in formulae. Don't just wait, share me the details about job. I assure you that your job will be completed in time in with clear and nice format.