Days of Supply by Group & Red / Amber / Green Alerts
This lesson is part of the course
In this lesson
You turn units on hand into days of supply per blood group, set red, amber and green alert levels with a nested IF, calculate the units needed to reach target and colour the red rows.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Demand by Blood Group vs Donor Supply Locked
- The Red-Cell Compatibility Matrix with IF, AND, OR & SUMPRODUCT Locked
- Days of Supply by Group & Red / Amber / Green Alerts Locked
- Shelf Life & FIFO: Expiry Dates, Units Expiring Within N Days & What to Issue Next Locked
- Outdate (Wastage) Rate, Its Cost & Months Above Target Locked
- Donor Collection Planning: Deferrals, No-Shows & Sessions Locked
- Platelets: a 5-Day Shelf Life, Order-Up-To Levels & Outdates Locked
- Blood Inventory Dashboard: Days of Supply vs Target with a Chart Locked