XERR OnTime

Actual OTD = completed on time ÷ (completed on time + completed late). Delivery outlook = (completed on time + future on time) ÷ all assessed activities. Outlook is the workbook-style combined measure, not an actual-completion percentage. Missing evidence is excluded and reported separately.

Due dates come from an explicitly mapped baseline XER or Excel Baseline Finish. XER target dates are not automatically treated as an approved baseline. Actual Finish is used for completed work; remaining early finish (then early finish) is used for forecasts. Unfinished work due on or before the data date is overdue. Future late compares forecast with baseline. KPI percentage rings use green at 90% or above, amber from 70% to below 90%, and red below 70%; grey means no assessed denominator. Variances use calendar days at date precision. A past data date does not reconstruct historical activity statuses.

WBS categories and available depths are read from the selected project, never fixed to the demo. Levels count below the project root; shallower branches remain at their deepest available node. WBS bars show six mutually exclusive states. The lavender OTD% line uses the right-hand 0–100% axis and the same combined measure as delivery outlook. The pink dashed OTD-QTD reference covers baseline finishes from the start of the data-date quarter through the data date, within the current scope. Unassessed groups are gaps, never zero scores. WBS points are category comparisons; due-month points form a time trend. Click any group to expand its activities inside this chart and filter the evidence table. The secondary bar view groups by baseline due month. Baselines match by exact Activity ID within the explicitly mapped project; missing and duplicate matches remain unassessed. No CPM recalculation is performed.