Drop in the week's Chambers RMT report and the referee sheet. The tool matches referees, works out the response rate, and hands back the client email and a colour-coded attachment. Nothing is saved, nothing leaves this page.
The tool reads Status (K), Status reason (L) and Recommended action (M) together and assigns one of four statuses. Contacted and No reply are set from real data. The two yellow rules are provisional best guesses at Chambers' wording — edit the keywords below once Danielle confirms what she actually sees. Comma-separate the keywords. Anything matching none of the four is flagged "unclassified" rather than guessed.