Badge export plus a supplier sheet. Match on email and company. Role columns still hold person names.
- Read the sheet
- Split names
- Match email and company
- Merge duplicates
- Set region and owner
- Save segments
| Role column | Name as written | Company | |
|---|---|---|---|
| Site lead | MOREAU ELISE | FENLOCK TREATMENT | [email protected] |
| Billing | E Moreau | Fenlock | [email protected] |
| Emergency | Elise M. | Fenlock Treatment Ltd | [email protected] |
| Director | Moreau, Elise | Fenlock | [email protected] |
| Buyer | BRIGGS, CALLUM | ASHMERE CATCHMENT | [email protected] |
| Site lead | Callum Briggs | Ashmere | [email protected] |
| Visitor | J Doyle | Rookley Works | blank |
Elise Moreau arrived four times, under Site lead, Billing, Emergency and Director. Callum Briggs, Farah Nazim and Jonah Adeyemi each arrived twice. Patrick Doyle was left out: the visitor column had no email.
| Given | Surname | Company | Action | Region | Owner |
|---|---|---|---|---|---|
| Elise | Moreau | Fenlock Treatment | Merged 4 roles | East | Rowan Hale |
| Callum | Briggs | Ashmere Catchment | Updated | North | Idris Cole |
| Farah | Nazim | Lowford Mains | Updated | North | Idris Cole |
| Freya | Lind | Calderford Pumps | Updated | Midlands | Felix Brennan |
| Nadia | Crowe | Ashmere Catchment | New | North | Idris Cole |
| Caleb | Nwosu | Nenebridge Lab | Held | Midlands | Felix Brennan |
| Greta | Holm | Whitfen Storage | New | West | Maeve Quinn |
| Hugo | Pell | Quayfield Networks | New | West | Maeve Quinn |
| Prospect | Company | Region | Owner | Status |
|---|---|---|---|---|
| Elise Moreau | Fenlock Treatment | East | Rowan Hale | Queued |
| Yusuf Demir | Rookley Works | East | Rowan Hale | Queued |
| Anika Bose | Pebbleford Estates | East | Rowan Hale | Queued |
| Nadia Crowe | Ashmere Catchment | North | Idris Cole | Queued |
| Leila Okoye | Lowford Mains | North | Idris Cole | Queued |
| Caleb Nwosu | Nenebridge Lab | Midlands | Felix Brennan | Held |
| Greta Holm | Whitfen Storage | West | Maeve Quinn | Queued |
| Hugo Pell | Quayfield Networks | West | Maeve Quinn | Queued |
| Segment | People | Owner | Status |
|---|---|---|---|
| East works managers | 3 | Rowan Hale | Saved |
| North catchment | 2 | Idris Cole | Saved |
| West networks | 2 | Maeve Quinn | Saved |
| Midlands lab visitors | 1 | Felix Brennan | Failed |
Caleb Nwosu, Nenebridge Lab. The segment refused to save because region code was empty. The correction is M-LV.
Status on this row: Held