Source register has 4,054 data-quality flags
The dashboard reads the works sheet exactly as filed, recomputes every total, and flags anomalies for the office to fix at source — it never silently rewrites the data.
Validation flags
Each issue is flagged for review — corrected as a derived field beside the untouched source value
638
records
Cost-unit corrections
Single-work cost over ₹500 Cr — rupees mis-entered in a "Rs. in Lakhs" column (TGSPDCL transformer rows). Reconciled ÷1,00,000 → lakh; raw value preserved.
e.g. "449846" → ₹4.5 L
1,184
records
No % progress recorded
Physical-completion cell blank or unparseable. Progress is value-weighted only over works that report a figure.
shown as n/a
1,184
records
Unclear status text
Status cell empty or unmappable to a pipeline stage.
bucketed as Status Unclear
510
records
Mandal not matched to canonical
Mandal spelling could not be matched to one of the 15 official mandals — constituency fell back to the sheet column.
flagged for review
538
records
No cost recorded
Estimated-cost cell blank or zero.
treated as ₹0
Source & method
Live works register · 1,184 works · 2 mandals across 1 constituencies · generated 14/9/2026, 3:01:54 pm. Constituency is derived from the canonical mandal map (matching the Schemes lens); costs above ₹500 Cr/work are reconciled to ₹ lakh and flagged; the “Bills Not Received” status is split into its own Billing-Pending lane.