Compliance Report: Daily Status, Time in Range, MKT & a Chart
This lesson is part of the course
In this lesson
You turn two weeks of daily sensor summaries into a compliance report: a status per day, the days OK, the time in range, the mean kinetic temperature and a chart of the daily minimum and maximum.
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
- Timestamps & Sampling Intervals: Finding the Gaps Locked
- Resampling to Hourly Averages with HOUR & AVERAGEIFS Locked
- Threshold Excursions: Count, Minutes & the Longest Excursion Locked
- Sensor Uptime & Data Completeness % Locked
- Calibration Drift vs a Reference Sensor: SLOPE & FORECAST Locked
- Smoothing: Moving Average vs Raw Noise (with a Chart) Locked
- Alert Rules with Hysteresis: ON above X, OFF below Y Locked
- Compliance Report: Daily Status, Time in Range, MKT & a Chart Locked