Rating Distribution, one working day
Two ways to read a half-finished cycle, and only one of them holds
One row per working day the window is open. The last row is the cycle. Every row before it is a forecast, and the sheet is explicit about which is which.
Submitted And Outstanding
Counts, not percentages. On day one this pair is the only honest thing on the row, and the sheet says so in the note column rather than leaving somebody to work it out.
Running Share Above The Middle
The share of what has arrived that sits away from the middle and above it. This is the number every review platform shows you and the number that will mislead you, because a manager writing an easy review submits it on Tuesday and a manager writing a hard one submits it on the last afternoon.
Projected Close, Each Manager's Own Prior Rate
Every outstanding review weighted at the rate its own manager produced last cycle, added to what has already arrived. This is the column to plan against, and the per-manager part is not a refinement. A manager who put nobody above the middle last time contributes nobody this time.
Projected Close, Company Prior Rate
The same arithmetic with one company average standing in for every manager. It is here as a control, so the sheet can show what the shortcut costs rather than assert it.
Evidence Returns Issued, Cumulative
The one mid-window figure anybody should act on. It is about how an evidence box was filled in, it belongs to one named manager, and it decays: a return issued on day nine cannot be answered before the window shuts.