Tutorvo

Missed & Shortened Treatments: Rates, Flags and Highlighting

Lesson 7 of 815 minLab

This lesson is part of the course

In this lesson

You calculate missed and shortened rates per patient and for the clinic, flag patients for a follow-up with IF and OR, count them and highlight their rows with a formula rule.

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

  1. Patient Census & Treatments per Month (3× per Week)Lab14 min Locked
  2. Chair Shifts & Utilisation: MWF and TTS SlotsLab13 min Locked
  3. Staffing Ratios per Shift: Patients per Nurse and TechnicianLab14 min Locked
  4. Supplies per Treatment & Inventory Reorder PointsLab15 min Locked
  5. Cost per Treatment: Labour, Supplies & OverheadLab15 min Locked
  6. Payer Mix & Revenue per TreatmentLab14 min Locked
  7. Missed & Shortened Treatments: Rates, Flags and HighlightingLab15 min Locked
  8. Capacity Expansion: Add a Shift or Add Chairs?Lab16 min Locked