Weekly Summary Report: Time in Ranges, Targets, Highlights & a Stacked Chart
This lesson is part of the course
In this lesson
You finish a one-week CGM summary: time above range per day, the days meeting all three consensus targets, a rule that highlights the days with too little time in range, and a stacked chart of the time in ranges.
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
- Readings per Day & Data Sufficiency (% of Expected Readings) Locked
- Mean Glucose & Converting mg/dL ↔ mmol/L Locked
- Time in Range, Below & Above: COUNTIFS with 70–180 mg/dL Bands Locked
- Glucose Management Indicator: GMI = 3.31 + 0.02392 × Mean Locked
- Glucose Variability: SD, Coefficient of Variation & a Stability Flag Locked
- Daily Pattern by Hour: AVERAGEIFS & a Line Chart Locked
- Hypoglycaemia Events: Consecutive Readings Below 70 for ≥ 15 Minutes Locked
- Weekly Summary Report: Time in Ranges, Targets, Highlights & a Stacked Chart Locked