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×)

🔍

📋 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

Date / Time	Badge	Name	Role	+ Hours	Notes	OT Type	Remarks	Submitted By	Actions
Load a month to view adjustments.

Month Year Rota Area

Kingdom of Saudi Arabia
Ministry of National Guard Health Affairs

المملكة العربية السعودية
الشؤون الصحية بوزارة الحرس الوطني

Overtime Justification (Non-Physicians)

Click "Load & Build Forms" to generate one Overtime Justification sheet per staff member with overtime this month.

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

Ministry of National Guard Health Affairs

KAMC-WR — Pharmaceutical Care Department

Pharmaceutical Care — Staff Rota

📋 Duties Management

Area Management

👥 Staff Management

🔍 Staff Lookup

✏️ Log Adjustment

Adjustment Log

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

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

🔍 Staff Lookup

✏️ Log Adjustment

Adjustment Log

👤 Approvers for this batch