Performa SoP 014: Statement Showing the ATC losses, collection 
Efficiency and Billing Efficiency YEAR 2016-17
Name of Circle Quarter Months Units input
(Mus)
Units Billed (Mus) Billing Efficiency Revenue Billed (Rs. Lacs) Revenue Collected (Rs. Lacs)  Collection Efficiency % Business Efficiency ATC Loss% Revenue Billed (Rs.CORES) Revenue Collected (Rs. CORES)
A B C = (B/A)*100 D E  F = (E/D)*100 G = (C*F)/100 H = 100 - G D E 
PGVCL I APR 2501.40 1979.62 79.14 107678.36 96332.46 89.46 70.80 29.20 521.78 20.86 1076.78 963.32
MAY 2526.79 2033.75 80.49 109858.81 111453.27 101.45 81.66 18.34 493.04 19.51 1098.59 1114.53
JUN 2523.92 2068.37 81.95 116188.37 115782.94 99.65 81.66 18.34 455.55 18.05 1161.88 1157.83
  7552.11 6081.74 80.53 333725.54 323568.67 96.96 78.08 21.92 1470.37 19.47 3337.26 3235.69
II JUL 2317.76 1998.88 86.24 117378.62 123123.03 104.89 90.46 9.54 318.88 13.76 1173.79 1231.23
AUG 2166.28 1962.68 90.60 115861.88 110378.29 95.27 86.31 13.69 203.59 9.40 1158.62 1103.78
SEP 2821.38 1991.13 70.57 112403.36 111051.60 98.80 69.72 30.28 830.26 29.43 1124.03 1110.52
  7305.42 5952.69 81.48 345643.86 344552.91 99.68 81.23 18.77 1352.74 18.52 3456.44 3445.53
III OCT     #DIV/0!     #DIV/0! #DIV/0! #DIV/0! 0.00 #DIV/0! 0.00 0.00
NOV     #DIV/0!     #DIV/0! #DIV/0! #DIV/0! 0.00 #DIV/0! 0.00 0.00
DEC     #DIV/0!     #DIV/0! #DIV/0! #DIV/0! 0.00 #DIV/0! 0.00 0.00
  0.00 0.00 #DIV/0! 0.00 0.00 #DIV/0! #DIV/0! #DIV/0! 0.00 #DIV/0! 0.00 0.00
IV JAN     #DIV/0!     #DIV/0! #DIV/0! #DIV/0! 0.00 #DIV/0! 0.00 0.00
FEB     #DIV/0!     #DIV/0! #DIV/0! #DIV/0! 0.00 #DIV/0! 0.00 0.00
MAR     #DIV/0!     #DIV/0! #DIV/0! #DIV/0! 0.00 #DIV/0! 0.00 0.00
  0.00 0.00 #DIV/0! 0.00 0.00 #DIV/0! #DIV/0! #DIV/0! 0.00 #DIV/0! 0.00 0.00
TOTAL UPTO THE QUARTER 14857.53 12034.42 81.00 679369.40 668121.58 98.34 79.66 20.34 2823.11 19.00 6793.69 6681.22