💾 Local: Auto-save ON
Date
Total Registrations / કુલ નોંધણી
0
Unique training patient records
Total Appointments / કુલ એપોઇન્ટમેન્ટ
0
All appointment records
Completed / પૂર્ણ
0
Completed appointments
Cancelled / રદ
0
Cancelled appointments
Department Summary / વિભાગ સારાંશ
Appointment Status / સ્થિતિ
Department Counts
| Department / વિભાગ | Registrations | Appointments |
|---|
Patient Registration / દર્દી નોંધણી
Add, edit, search and export fictional training records.
0
Records
0
Departments
0
Duplicate IDs
0
Average Age
| # | Patient ID | Name | Age | Department | Registration Date | Duplicate? | Actions |
|---|
Appointments / એપોઇન્ટમેન્ટ
Patient-linked appointment practice with status tracking.
0
Appointments
0
Completed
0
Scheduled
0
Cancelled
| # | Appt ID | Patient ID | Date | Time | Department | Status | Duplicate? | Actions |
|---|
Workbook / Tool Overview
- This tool is designed for hospital reception computer-skills training.
- Use only fictional practice data. Never enter real patient data.
- Registration and Appointments feed the Dashboard automatically.
- Data is stored locally in this browser using Local Storage.
Step-by-Step Practice / અભ્યાસ
- Open Registration and add a fictional patient.
- Select Department from the suggestions or type a custom department name.
- Enter age between 1 and 120.
- Create an appointment using the registered Patient ID.
- Change status and observe Dashboard totals.
- Use Search / Filter and Print Preview.
Validation Rules
- Patient ID format: TRN-001
- Appointment ID format: APT-001
- Duplicate IDs are blocked during save.
- Appointment Patient ID must exist in Registration.
- Required fields cannot be blank.
Common Errors / સામાન્ય Errors
- Duplicate ID: Use a different training ID.
- Age Error: Use a number from 1–120.
- Department: Select a suggestion or type a custom department name.
- Missing Patient: Register patient before appointment.
Skills Checklist / કૌશલ્ય ચેકલિસ્ટ
- ☐ Selected a dropdown value
- ☐ Entered valid date and age
- ☐ Used search and filter
- ☐ Added / edited appointment status
- ☐ Checked dashboard update
- ☐ Opened Print / Save PDF
Offline & Backup
- The file runs offline; no server/database is required.
- Export Backup downloads all tool data as JSON.
- Import Backup restores a JSON backup created by this tool.
- CSV export is available separately for each data table.
Original Excel Formula Concepts
COUNTIF(Registration[Department], Department) → Department total\nCOUNTIF(Appointments[Status], Status) → Status total\nCOUNTIF(ID_Column, Current_ID) > 1 → Duplicate warning\nCOUNTA(Registration IDs) → Total registrations