【A】 COMMERCIAL PARAMETER-------CURRENT MONTH ---------(👇 ONLY FEED INPUT ENERGY IN MWH)
0 SS
| SUBSTATION | BILLABLE CONSUMER | LOAD (KW) | INPUT ENERGY (MWH) | BILLED ENERGY (MWH) | CURRENT ASSESMENT (LACS) | REALIZATION (LACS) | TURN UP (NO) | TURN UP (%) | BILLING EFF (%) | LINE LOSS (%) | COLL EFF (%) | ABR (Rs/Unit) | THR RATE (Rs/Unit) | AT&C (%) | ARREAR (LACS) | TOTAL OUTSTANDING (LACS) | CA_EX SUBS (LACS) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Upload Excel to load data | |||||||||||||||||
【B】 FEEDER WISE---------COMMERCIAL PARAMETER--------CURRENT MONTH --------(👇 ONLY FEED INPUT ENERGY IN MWH)
0 Feeders
Upload Excel - Feeder Wise Data
【C】 LMV1 ----------TOTAL_OUTSTANDING----------------DEFAULTER TYPE0 SS
| SUBSTATION | NEVER PAID (NO.) | NEVER PAID (LACS) | LONG UNPAID (NO.) | LONG UNPAID (LACS) | 5K-10K (NO.) | 5K-10K (LACS) | 10K-25K (NO.) | 10K-25K (LACS) | 25K-50K (NO.) | 25K-50K (LACS) | 50K-1LAC (NO.) | 50K-1LAC (LACS) | ABOVE 1LAC (NO.) | ABOVE 1LAC (LACS) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Upload Excel - LMV1 | ||||||||||||||
【D】 LMV2------------TOTAL_OUTSTANDING----------------DEFAULTER TYPE0 SS
| SUBSTATION | NEVER PAID (NO.) | NEVER PAID (LACS) | LONG UNPAID (NO.) | LONG UNPAID (LACS) | 5K-10K (NO.) | 5K-10K (LACS) | 10K-25K (NO.) | 10K-25K (LACS) | 25K-50K (NO.) | 25K-50K (LACS) | 50K-1LAC (NO.) | 50K-1LAC (LACS) | ABOVE 1LAC (NO.) | ABOVE 1LAC (LACS) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Upload Excel - LMV2 | ||||||||||||||
【E】 TOTAL_OUTSTANDING -----------(LACS)0 SS
| SUBSTATION | HV2 | HV1 | LMV1 | LMV2 | LMV3 | LMV4A | LMV4B | LMV5 | LMV6 | LMV7 | LMV8 | LMV9 | LMV10 | LMV11 | EXC.(GOVT + PTW) | TOTAL |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Upload Excel | ||||||||||||||||
【F】 ARREAR --------------- (LACS)0 SS
| SUBSTATION | HV2 | HV1 | LMV1 | LMV2 | LMV3 | LMV4A | LMV4B | LMV5 | LMV6 | LMV7 | LMV8 | LMV9 | LMV10 | LMV11 | EXC.(GOVT + PTW) | TOTAL |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Upload Excel | ||||||||||||||||
【G】 CURRENT ASSESMENT ------------ (LACS)0 SS
| SUBSTATION | HV2 | HV1 | LMV1 | LMV2 | LMV3 | LMV4A | LMV4B | LMV5 | LMV6 | LMV7 | LMV8 | LMV9 | LMV10 | LMV11 | EXC.(GOVT + PTW) | TOTAL |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Upload Excel | ||||||||||||||||
【H】 REVENUE REALIZATION ------------- (LACS)0 SS
| SUBSTATION | HV2 | HV1 | LMV1 | LMV2 | LMV3 | LMV4A | LMV4B | LMV5 | LMV6 | LMV7 | LMV8 | LMV9 | LMV10 | LMV11 | EXC.(GOVT + PTW) | TOTAL |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Upload Excel | ||||||||||||||||
【I】 TURN UP (CONSUMER PAID) -------------- (NO.)0 SS
| SUBSTATION | HV2 | HV1 | LMV1 | LMV2 | LMV3 | LMV4A | LMV4B | LMV5 | LMV6 | LMV7 | LMV8 | LMV9 | LMV10 | LMV11 | EXC.(GOVT + PTW) | TOTAL |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Upload Excel | ||||||||||||||||
【J】 TOTAL CATEGORY WISE CONSUMER ------------- (NO.)0 SS
| SUBSTATION | HV2 | HV1 | LMV1 | LMV2 | LMV3 | LMV4A | LMV4B | LMV5 | LMV6 | LMV7 | LMV8 | LMV9 | LMV10 | LMV11 | EXC.(GOVT + PTW) | TOTAL |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Upload Excel | ||||||||||||||||