How status is decided
- On target the result is in the Green band
- At risk the result is in the Amber band
- Off target the result is in the Red band
- No target reported, but no bands set for this KPI yet
- Not reported due for this period, not entered
Health score = average of scored KPIs (Green 100, Amber 50, Red 0). Thresholds for function health are on the workbook's Settings sheet.