Excel for urine strips performance verification (Reference method comparison for 35 patients)

Calculation for 35 patients ( 10 normal patients, 10 UTI, 5 hematuria, 5 proteinuria, 5 glycosuria)

A complete, automated Excel tool designed for medical laboratories to verify the analytical performance of urine strip parameters according to EFLM recommendations. Includes agreement calculations, sensitivity, specificity, pass/fail algorithms, dropdown selection, and ready-to-print reports.

This professional Excel file helps medical laboratories verify the performance of urine strip analysis by comparing patient results with a validated reference method. The user has this posibility to fill in the cutoff for the reference method.

All calculations are fully automated and follow the latest EFLM 2023 recommendations for qualitative method evaluation.

The tool supports:

• Glucose

• Ketones

• Protein

• Nitrite

• Leukocytes

• Blood

1. Automated Agreement Calculation

For each parameter, the file calculates:

• True Positives

• True Negatives

• False Positives

• False Negatives

• Agreement (%)

• PASS/FAIL based on 100% or any threshold you choose

2. EFLM-Compliant Logic

All formulas are built following:

• Qualitative method performance verification rules

• Agreement ≥95% recommendation

• Sensitivity & Specificity guidance (optional)

3. User-Friendly Dropdowns

All dropdowns for strip results support:
✔ “Negative”
✔ “Trace”
✔ “+”, “++”, “+++”

Pass/fail indicators

Suitable for All Urine Strip Analyzers

Optimized for:

• Iris Diagnostics / iRICELL 3000

• Roche, Siemens, Beckman, Mindray

• Manual strip reading validation

🎯 Who Is This For?

This tool is ideal for:

• ISO 15189 accredited medical laboratories

• Labs preparing for accreditation

• Quality managers and specialists

• Lab technicians performing method verification

• Training and education purposes

📦 What You Receive

• The Excel file (unlocked for editing where needed)

• Instructions sheet included in Excel

• Automated calculations for 35 patients, no formulas to enter manually

• Support for any parameter adjustments

• Lifetime access to updates

⚠️ Disclaimer

This tool is designed to support laboratory performance verification according to professional guidelines.
It does not replace clinical judgment, accreditation requirements, or manufacturer instructions.