Subdivision Month-wise Analytics

Comparative billing, energy input, and AT&C loss trends (Jan 2026 – Jun 2026)

Substation: Feeder: Category: Data Mode:

Substation Input

4,172,600 kWh

June 2026 (Incoming Feeders)

Billed & Efficiency

71.8%

2,996,367 kWh Billed

Collections & Realisation

31.6%

₹9,941,170 Collected

AT&C Loss

77.3%

Target: < 15.0%

Efficiency Trends

Billing vs. Collection %

AT&C Loss Trend

Aggregate Loss %

Financial Performance & Loss

INR (₹)

Meter Read Quality & Defects

June 2026

Month-wise Parameter Breakdown

Month Consumers Connected Load Input Energy Billed Energy Assessment Billed Amount Collections Billing Eff. Collection Eff. Turn Up AT&C Loss ABR Through Rate Potential Loss
Click on any month row above to load its specific details into the KPI cards.

Data Quality & Systemic Recording Typology

Billing databases generated by utility reading systems occasionally log anomalies. A notable issue is Meter Reset / Cumulative Difference Typologies. When a commercial or governmental meter is replaced or reset, the difference between the closing reading of the old meter and the opening reading of the new meter is recorded as a single month's consumption (often logged as 999,999 or even 1,000,000,000 units), while the financial assessment remains locked to actual normal usage.

Impact: In March 2026, the 1 billion kWh typo on the Mahendra Gayatri Foundation College account artificially boosts the raw billed energy, creating a fake 36,120% billing efficiency. Activating Cleaned Mode filters these typos, restoring billing efficiency to a realistic 77.75%.

Typology Outlier Logs (Consumption > 100,000 kWh with Rate < ₹1.0)

Month Account ID Consumer Name Consumption (kWh) Current Assessment Unit Rate (₹/kWh) Recorded Typology Remark

Defective Meter Exception Tracking & Aging

Track defective billing cases (RDF, CDF, IDF, Bill Revised, and Provisional billing) across the subdivision. This registry computes the Aging Duration in consecutive months for each consumer meter, providing key operational insights for replacement scheduling and revenue assurance.

Defective Billing & Exception Registry (All Months)

Download Master History (.xlsx)
Month Account ID Consumer Name Substation Feeder Defect Type Assessment Defect Duration (Months)