Assigning MAP Codes

Reads itemized charges, matches each product against the lookup sheet, and fills the account title column — colour-coded and annotated for review.

01Workbook

Drop the charges workbook here

.xlsx or .xlsm — it needs the itemized charges sheet and the lookup sheet, up to 25 MB.

Department / Section	Product / Service	MAP code
Nothing matches that search.

How it decides

Each step only runs when every step above it missed.

1Bracket code(GF) → Pharmacy GAA · (CS) → Pharmacy-Consignment · (SPGF)/(SP) → Pharmacy
2Keyword rules“HANDLING FEE” → Pharmacy Services · “RT PCR” → MRL - Molecular
3Exact overrides“X RAY PANORAMIC” → Radiology
4MammographyAny mammography/mammogram wording → Breast Cancer Care - Mammo, typo tolerant
5Exact lookup matchNormalized product text matched against the lookup sheet, then generalized (LAB_/MRL- → Laboratory, RAD → Radiology, RIL/FAMED → Medicine…)
6Fuzzy matchLevenshtein similarity — filled automatically above the high threshold, flagged for review above the low one
7FallbacksDextrose 5% → Pharmacy · BLOOD without a % → Laboratory · Colonogram → Radiology · IHC → Laboratory
8Left for a humanAnything still unmatched is written blank, shaded red and noted

Results are colour-coded in the downloaded workbook — green filled, yellow needs review, red no match — and every fuzzy decision leaves a cell note, same as the Apps Script version.