From: Amina Hassan, Head of KilelePay

The agent network team runs on Excel, so the Coast case has to be a workbook. The extract is Kilele_Withdrawals_Extract.xlsx: Withdrawals is every withdrawal in the sample (197,134 rows, with region and is_payday already joined, plus status, fail_reason, amount and fee) and Agents is the complete agents table (1,500 rows).

Build: 1. A PivotTable of withdrawals and float failures by region and payday flag, with the failure rate as a formula beside it. 2. The Coast payday money: SUMIFS for KES not served and for fees forgone, where fail_reason is insufficient_agent_float. 3. Average, minimum and maximum float limit by region and agent type from Agents, with AVERAGEIFS, MINIFS and MAXIFS. 4. A "what if Coast matched the rest" cell: Coast payday withdraw…