Connect to your Google Sheet
Paste the Apps Script web-app link. It is saved in this browser, so you only do this once.
- Google Sheet → Extensions → Apps Script → Deploy → Manage deployments.
- Copy the Web app URL (it ends with /exec).
The dashboard could not get data from the Google Sheet
How final pendency is worked out
Pending toolkits less those in RTS, under reconciliation, or without booking details.
Pending toolkits split
Share of all pending toolkits.
Final pendency by division
Highest first. Click a bar to focus on that division.
Delivery rate by division
Delivered toolkits as a share of all toolkits, lowest first.
Final pendency by booking month
How old the still-pending toolkits are. Older months are shaded deeper.
Trend since snapshots began
Final pendency and no-booking cases on each saved snapshot date.
What is holding up pending toolkits, by division
Each bar is a division's pending toolkits split into RTS, reconciliation, no booking details and final pendency.
Final pendency = Pending less RTS, Reconciliation and No booking details. Each toolkit is removed once only (RTS first). Artisans count applications; parcels add up Barcode Count. Click a division row to focus on it.
Open cases by stage
The first step still marked No. Cases also in RTS are shown separately.
Days in transit
Open cases, excluding RTS.
Open cases by division and days in transit
Excluding RTS. Click a bar to focus on that division.
Reconciliation summary
Final pendency by booking month and region
Stacked by region, oldest month on the left.
Division-wise final pendency by booking month
Darker cells hold more pending toolkits. Columns on the right add back to total pending.