Drop your Excel set checklist here
.xlsx · .xls · .csv · max 10 MB · 8000 rows max
Recent imports
| Job | Filename | Rows | Matched | Ambiguous | New | Started | Status |
|---|---|---|---|---|---|---|---|
| JOB-0042 | apollo_hyd_master_list.xlsx | 1,247 | 982 | 198 | 67 | 2026-05-18 14:30 | awaiting review |
| JOB-0041 | fortis_mum_supplemental.xlsx | 312 | 298 | 12 | 2 | 2026-05-15 11:14 | completed |
| JOB-0040 | apollo_chennai_initial.xlsx | 2,184 | 1,950 | 203 | 31 | 2026-04-22 09:00 | completed |
How it works
1. Parse Excel
Extract item name, qty, size, set context
2. Fuzzy candidates
pg_trgm similarity against Universal Master Library
3. LLM scoring
Claude scores candidates with rationale
4. Auto-match
Confidence ≥0.90 → auto · 0.6–0.9 → review · <0.6 → new master proposal
5. Human review
You approve or reject — feedback trains next batch
apollo_hyd_master_list.xlsx · 1,247 rows
Rows parsed
1,247
100%
Auto-matched
982
78.7%
Ambiguous (review)
198
15.9%
New master proposals
67
5.4%
Parse
100%
Fuzzy candidates
100%
LLM scoring
100%
Apply matches
awaits
Match distribution
Confidence ≥ 0.90 (auto-matched)
982
78.7%
Confidence 0.60-0.89 (review)
198
15.9%
Confidence < 0.60 (new proposal)
67
5.4%
All 198
Pending 198
Approved 0
Rejected 0
Row 421Excel name"Mayo H. Needle holder 7""
parsed_name=Mayo H. Needle holder · parsed_size=7"
Suggested match
Mayo Hegar Needle Holder (UIM-FRC-MAY)
0.96
LLM: 'Mayo H.' is a standard abbreviation for 'Mayo Hegar' in CSSD nomenclature across India. Size '7"' matches the canonical variant. Brand mention absent but contextually consistent.
Row 422Excel name"Tissue Forceps fine adson type"
parsed_name=Tissue Forceps fine adson · parsed_size=null
Suggested match
Adson Tissue Forceps (UIM-FRC-ADS)
0.74
LLM: 'fine adson type' suggests Adson-Brown variant but standard Adson is more common in this hospital's surgery mix (general+OBG). Size not specified — defaulting to standard 4.75". Alternate candidates: Adson-Brown (0.62), DeBakey (0.41).
Row 423Excel name"Scissor metzen 6 inch"
parsed_name=Scissor metzen · parsed_size=6 inch
Suggested match
Metzenbaum Scissors 7" (UIM-SCS-MET)
0.68
LLM: Size mismatch (excel says 6", canonical is 7") but per
universal_alias_map, these are alternate_size equivalents. Consider creating a 6" variant under the same master.Row 424Excel name"Local special bowel clamp 6"
parsed_name=Local special bowel clamp · parsed_size=6
Best candidate
(Doyen Intestinal Clamp — closest)
0.38
LLM: No close universal match. 'Local special' suggests in-house fabrication or vendor-specific item. Recommendation: create new local master with
fork_strategy='independent' and propose universal promotion if used regularly.Excel row · raw & parsed
Row number422
SheetSet definitions · Sheet 2
Raw cell value"Tissue Forceps fine adson type"
parsed_nameTissue Forceps fine adson
parsed_quantity2
parsed_size(null)
parsed_set contextAppendectomy Set
Top 5 candidates · LLM scored
| Rank | Candidate | Source | Confidence | Trgm sim |
|---|---|---|---|---|
| 1 | Adson Tissue Forceps | universal · UIM-FRC-ADS | 0.74 | 0.71 |
| 2 | Adson-Brown Forceps | universal · UIM-FRC-ADSB | 0.62 | 0.66 |
| 3 | DeBakey Tissue Forceps | universal · UIM-FRC-DEB | 0.41 | 0.39 |
| 4 | Gillies Tissue Forceps | universal · UIM-FRC-GIL | 0.32 | 0.51 |
| 5 | Russian Tissue Forceps | universal · UIM-FRC-RUS | 0.21 | 0.34 |
Decision
ReviewerPriya Menon
JobJOB-0042
Decision is logged to
master_match_suggestions.reviewed_by and feeds the learning loop.Local special bowel clamp 6
Promotion to Universal Library
Keep local (independent fork)
Propose for universal — Super Admin reviews
Why no match?
LLM confidence was 0.38 against closest candidate (Doyen Intestinal Clamp). 'Local special' suggests in-house fabrication or vendor-specific item.
Photo
Upload
All 24In flight 3Completed 19Failed 2
| Job | Hospital | File | Rows | Matched | Review queue | New masters | Status | Started |
|---|---|---|---|---|---|---|---|---|
| JOB-0044 | Apollo Hyderabad | specialty_kits.xlsx | 412 | 342 | 52 | 18 | parsing | 07:14 |
| JOB-0043 | Apollo Hyderabad | endoscopy_set.xlsx | 88 | 71 | 14 | 3 | awaiting review | 06:55 |
| JOB-0042 | Apollo Hyderabad | apollo_hyd_master_list.xlsx | 1,247 | 982 | 198 | 67 | awaiting review | yesterday |
| JOB-0041 | Fortis Mumbai | fortis_mum_supplemental.xlsx | 312 | 298 | 12 | 2 | completed | 4 days ago |
| JOB-0040 | Apollo Chennai | apollo_chennai_initial.xlsx | 2,184 | 1,950 | 203 | 31 | completed | last month |
| JOB-0039 | Manipal BLR | scratch_template.xlsx | — | — | — | — | failed · invalid sheet | last month |