The quarter at a glance

Built from the detailed records

Source: Avg Rev Q1 2026-2027.xlsx. Only “Q1 2026-2027 Rev” and “Q1 2025-2026 Rev” are used. Both cover April–June. Summary sheets and the old website’s figures are excluded.

Names are trimmed and matched through the confirmed identity rules. Combined-name rows are attributed to the named canonical doctor and displayed once with one Staff ID. Revenue and patient counts are added across all matching source rows, regardless of source Staff ID. Averages are revenue divided by the corresponding count; zero denominators display N/A. A missing name in a comparison period is not treated as zero.

Outpatient and inpatient revenue are the controlling amounts. Six inconsistent row totals were recalculated as their sum. Cash/credit amounts remain as reported: seven source splits disagree with their service revenue and cannot be resolved from the workbook alone. No cash/credit amount has been invented. Calculations retain source precision; one prior-year amount has four decimal places.

Identity consolidation

31 source identity rows were assigned to canonical names. The original source label and ID remain listed for auditability.

Source reconciliation

KD, four decimal places. Difference = recalculated total minus recorded total, or service revenue minus cash + credit.

Department reassignment for matching names

Records under Management or Al Seef Hospital are assigned to the single clinical department recorded for that exact name in the same period. This changes department totals, never the hospital total. Original assignments remain below.