Drug Tariff Compare

Compare Workbooks

Compare and download

Upload two files: your Mirage review workbook and the NHS Drug Tariff Part IX workbook. The system compares product rows and creates a new output file with match results.

What you will get in the output: your original sheets plus extra match columns including Price Match, Matched DT Name, Matched SNOMED, Matched Part IX Price (p), and Mirage Price Compared (p). The output file name is based on your Mirage file, for example YourReview_Part_IX_compared.xlsx.

How to read Price Match: green = price matches, amber = product matched but price differs (check pack/unit), red = no reliable Part IX match found.

After comparison, open Match Review to confirm, reject, or manually correct uncertain rows. These decisions are saved and help improve future comparisons.

Mirage drug tariff price review (.xlsx)

Use your Mirage review workbook. Expected sheets usually include Wound Care, Medical Devices, and Nutrition.

Drug Tariff Part IX (.xlsx)

Upload the NHS Drug Tariff workbook that contains a tab with Part IX in the tab name (month/year in the tab name is fine). Required data includes AMP Name, Price, and AMP SNOMED code.

Optional word aliases (comma-separated)

Use this only if you know common wording differences between Mirage and Part IX (for example abbreviations or spelling variants). Enter both lists in the same order.

Words in Mirage to replace

Match Part IX wording

Or use the command line

Same results without the browser — place files in the project folder or pass --mirage / --tariff.

pip install -r requirements.txt
python drug_tariff_comparator.py --help

Learning Health

Mapping Learning Summary

Use this report to monitor how many product mappings are learned and reused by method (manual review, accepted review, or automatic SNOMED-based learning).

This helps confirm learning quality and whether review workload is improving over time.

Open 7-day quick summary Open 30-day summary