1Load export
2Map columns
3Clinicians
4Settings
5Results
Load your EMIS export
Works with both exports from the prebuilt EMIS searches: the consultation export (full continuity analysis) or the list-sizes export (a simple list-size report — detected automatically). CSV or Excel both work. The file is read locally by your browser and never leaves this computer. New to this? Step-by-step EMIS instructions.
Choose a file or drag it here
.csv, .xlsx or .xls · one row per consultation
Usual GP list sizes
Registered patients per Usual GP
From the Usual GP field — the list each GP nominally holds
List size table
Optional: type each GP's clinical sessions per week to see patients-per-session — a fairer basis for the workload-balance conversation than raw list size.
| Usual GP | Patients | % of list | Sessions/wk | Patients per session |
|---|
Includes any sessions you've typed. Aggregate numbers only — no patient data.
Results
Practice scorecard
Three numbers worth tracking — before and after a recode exercise, and against your federation. All three cover frequent attenders only (patients with at least the minimum number of consultations).–
Usual GP accuracy — of patients who are either already correct or clearly see another GP (fragmented and departed left out), the share already correct. The recode target.
–
Mean UPC (most-seen clinician) — average share of each patient's consultations with whoever they see most. True continuity; recoding alone won't move it.
–
Consultations with recorded Usual GP — rises when the field is fixed (instantly, since EMIS shows today's Usual GP on past rows), and again if booking follows it.
Aggregate numbers only — no patient or clinician names or IDs, and counts under 5 are shown as "<5". Suitable for federation comparison.
Continuity categories
Patients with enough consultations to judge
Each GP's frequent attenders: right patients, leavers and arrivals
■ Aligned — registered to this GP and mostly see them ·
■ On their list, mostly seen elsewhere ·
■ Mostly see them, registered elsewhere ·
■ On their list, fragmented care or GP departed.
Orange and blue are different patients — they don't cancel out.
A GP's paper list is green + orange + grey; who they clearly look after is green + blue.
Recoding turns orange into green on the correct GP.
Clinician continuity — share of each clinician's consultations that are with their own registered patients
Low bars mean a clinician's workload is mostly other GPs' registered patients — often a Usual GP data-quality issue rather than a behaviour issue
Ranked recode suggestions
Impact ranks by how many consultations a change would affect (consultations with the suggested GP × mismatch weight), so large MEDIUM patients can sit above small HIGH ones. For the most certain changes first, sort by share instead. Always check the Reason column — ties and ineligible most-seen clinicians are flagged there.
The CSV contains patient identifiers — save it somewhere your IG policy allows, and delete it once the recodes are done.
| # | Patient | Current Usual GP | Suggested Usual GP | Seen suggested | Total | Share | Confidence | Reason | Impact |
|---|
Method notes
- Each patient's Usual GP is taken as the most frequent value of the Usual GP column across their rows (a tie goes to the most recent value). Note that EMIS writes the patient's current Usual GP on every row, so every past consultation is compared with today's Usual GP — after a recode, re-running the tool shows the improvement straight away, before any change in who patients see.
- The most-seen clinician is whoever the patient saw most within the analysis period, after exclusions and name merges. If the recorded Usual GP is joint-top, the patient counts as correct.
- Patients whose recorded Usual GP is marked departed are categorised DEPARTED and always suggested for recoding, using the reassignment rule chosen on the Clinicians step (most-seen clinician, a named GP, or spread evenly across active GPs).
- Who can be suggested: never a clinician marked excluded, departed or never suggest. If the patient mostly sees someone who can't hold a list (e.g. a registrar), they are judged on the best clinician who can — and if that is their recorded Usual GP, they count as correct. Ties between two equally-seen GPs are flagged TIE for the practice to choose, and suggestions of someone who holds no list at all are flagged in the Reason column.
- Confidence: HIGH — top clinician has at least the HIGH threshold share; MEDIUM — between the MEDIUM and HIGH thresholds; FRAGMENTED — no clinician reaches the MEDIUM threshold (assigning a Usual GP is a clinical decision, not a recode).
- Impact score = total consultations × suggested-clinician share × weight (2 for a clear mismatch, 1 for fragmented) — i.e. twice the consultations with the suggested clinician in the analysis period. It measures volume, not certainty: use the Share column (or sort by share) for confidence.
- Scorecard: Usual GP accuracy = CORRECT ÷ (CORRECT + HIGH + MEDIUM) — fragmented patients are left out because "correct" is undefined for them, and departed patients are reported separately. A patient counts as CORRECT when their Usual GP is their joint most-seen clinician, even if that share is modest. Mean UPC = average share of each patient's consultations with their most-seen clinician (a common variant of the Usual Provider of Care index; the classic version uses the recorded usual provider). Only patients with at least the minimum number of consultations are included, which puts a floor under UPC, so figures aren't directly comparable with published all-patient values. Consultations-with-Usual-GP = share of all analysed consultations that were with the recorded Usual GP. Federation comparisons are only fair on identical settings — use the bundled EMIS search and defaults.
- The practice summary export contains aggregate figures only — no patient or clinician names.
- Who it's for: traditional practices running usual-GP care for routine work. In total-triage or duty-heavy models a triaging GP can appear as many patients' "most-seen clinician" — that's throughput, not continuity; mark triage/duty-only clinicians never suggest on the Clinicians step and interpret with care. Frequent attenders only (4+ appointments); no frailty/age weighting yet; the appointment book is the only evidence seen.
- This tool suggests data-quality corrections. Any bulk change to the Usual GP field should go through your normal practice governance and patient communication, and can be applied via EMIS Workflow Manager → Usual GP Reallocation or the RCGP Usual GP Tool.
- All processing happens locally in this browser tab. Closing the tab discards everything.