v1.8 · 26 Jun 2026

الشؤون الصحية – وزارة الحرس الوطني

Ministry of National Guard Health Affairs

KAMC-WR — Pharmaceutical Care Department

Pharmaceutical Care — Staff Rota

—

Print only staff with hours

Area Filter

All Areas

Pattern mode: OFF Click Pattern → click a day cell → enter sequence (e.g. 4NC2OFF) or add repetitions (e.g. 4NC2OFF(3) repeats 3×)

🔍

Staff Name (Badge No)

Hours

📋 Duties Management

Area filter: 🎨 Adobe Color

⬇ Import Duties from Another Area

Source: Select a source area and click Preview.

#	Code	Label	Hours	Color	Area	Start Day	Start Time	End Time	Schedule	Total Hrs	St.	Status	Remarks	Log	Actions

👥 Staff Management

Area filter: 🔗 External only

Add Staff: External Collaborator

⚙ Import & Bulk Operations

Import from Excel:

Import External Staff: Columns: Badge No. · Name · Hourly Rate · Department. Role is set to "Pharmacy aide (Collaborative)"; area left blank to assign per person.

Role Categories:

Update HRR: Columns: Badge No. · Name · HRR

Update from Manpower Report: Reads the "Employees" sheet — matches by Employee # / Badge No., updates Role + Contract Date. Only updates existing staff; shows a summary to confirm first.

Copy to Area:

#	Name	Badge	Role	Contract Date	HRR	Area	Actions

الشؤون الصحية – وزارة الحرس الوطني

Ministry of National Guard Health Affairs

KAMC-WR — Pharmaceutical Care Department

Pharmaceutical Care — Staff Rota

Settings & Tools

Schedule Setup

Rota Title

Records

Cloud & Export

Pages & Tools

🔒 Security

Total Staff

Monthly Target

Total Assigned Hrs

Balanced

Coverage

Over Target

Under Target

Duty Abbreviations

📝 Row Notes

Monthly Statistics

💾 Save Release

📂 Load Rota

🔒 OT Override

📋 Leave Types in Use

📊 Full Coverage — All Days

📋 Duties Management

Area Management

👥 Staff Management