SoP 011 - A : System Average Interrruption Frequency Index (SAIFI) for URBAN category
Sr.
No
Month Ni - Number of Customers for each sustained interruptions (in numbers) NT - Total No of customers served
(in Numbers)
CI= Ni SAIFI = ∑ Ni/Nt
(Monthly SAIFI)
1 2 3 4 5 6=5/4
1 Apr-19 1568405.00 2190079.00 5365751.00 2.45
2 May-19 1675673.00 2206803.00 5881655.00 2.67
3 Jun-19 1856752.00 2208473.00 13034556.00 5.90
  1st Qtr 5100830.00 2208473.00 24281962.00 10.99
4 Jul-19 1811738.00 2215928.00 9416172.00 4.25
5 Aug-19 1685211.00 2220191.00 10012761.00 4.51
6 Sep-19 1790374.00 2221004.00 10154271.00 4.57
  2nd Qtr 5287323.00 2221004.00 29583204.00 13.32
7 Oct-19 0.00 0.00 0.00 #DIV/0!
8 Nov-19 0.00 0.00 0.00 #DIV/0!
9 Dec-19 0.00 0.00 0.00 #DIV/0!
  3rd Qtr 0.00 0.00 0.00 #DIV/0!
1 Jan-20 0.00 0.00 0.00 #DIV/0!
2 Feb-20 0.00 0.00 0.00 #DIV/0!
3 Mar-20 0.00 0.00 0.00 #DIV/0!
  4th Qtr 0.00 0.00 0.00 #DIV/0!
  Yearly Data 10388153.00 2221004.00 53865166.00 24.25
SoP 011 - B : System Average Interrruption Duration Index (SAIDI) for URBAN category
Sr.
No
Month Ri =
Restoration Time for each sustained interruption event
(in hours)
Ni - Number of interrupted Customers for each sustained interruption event
(in numbers)
Ri* Ni -
Total customer interrution Duration
NT - Total No of customers served
(in Numbers)
Customer Intt. Duration CMI = ΣRi*Ni SAIDI = ΣRi*Ni/Nt (Monthly SAIDI)
1 2 3 4 5 = 3 * 4 6 7 8=7/6
1 Apr-19 1:07 1568405.00 1755958:25 2190079.00 269276.45 2:57
2 May-19 1:18 1675673.00 2181161:15 2206803.00 366715.60 3:59
3 Jun-19 1:04 1856752.00 1984752:12 2208473.00 599109.93 6:30
  1st Qtr 3:29 5100830.00 17802829:04 2208473.00 1235101.98 13:25
4 Jul-19 1:04 1811738.00 1938998:09 2215928.00 458441.99 4:57
5 Aug-19 1:03 1685211.00 1780508:14 2220191.00 470714.80 5:05
6 Sep-19 1:02 1790374.00 1858771:24 2221004.00 466618.42 5:02
  2nd Qtr 3:09 5287323.00 16734345:47 2221004.00 1395775.20 15:04
7 Oct-19 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
8 Nov-19 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
9 Dec-19 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
  3rd Qtr 0:00 0.00 0:00 0.00 0.00 #DIV/0!
1 Jan-20 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
2 Feb-20 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
3 Mar-20 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
  4th Qtr 0:00 0.00 0:00 0.00 0.00 #DIV/0!
  Yearly Data 6:39 10388153.00 69134995:09 2221004.00 2630877.18 28:25
SoP 011 - C : Momentary Average Interruption Frequency Index (MAIFI) for URBAN category
Sr.
No
Month IMi =
Number of Momentary interruptions for the month
(in numbers)
Nmi =
Total no of customers for each momentary interruptions
(in numbers)
Imi =Nmi
Number of customer Momentary interruptions
(in numbers)
Nt -
Total no of customers served
(in numbers)
Customer Intt. ΣImi*Nmi MAIFI=ΣImi*Nmi/Nt
1 2 3 4 5 = 3 * 4 6 7 8=7/6
1 Apr-19 2691.00 1696262.00 4564641042.00 2190079.00 7974808.00 3.64
2 May-19 2280.00 1627622.00 3710978160.00 2206803.00 6963384.00 3.16
3 Jun-19 4252.00 1812421.00 7706414092.00 2208473.00 12409553.00 5.62
  1st Qtr 9223.00 5136305.00 47372141015.00 2208473.00 27347745.00 12.38
4 Jul-19 3590.00 1773413.00 6366552670.00 2215928.00 10725397.00 4.84
5 Aug-19 3626.00 1857420.00 6735004920.00 2220191.00 11251184.00 5.07
6 Sep-19 3521.00 1710155.00 6021455755.00 2221004.00 10752345.00 4.84
  2nd Qtr 10737.00 5340988.00 57346188156.00 2221004.00 32728926.00 14.74
7 Oct-19 0.00 0.00 0.00 0.00 0.00 #DIV/0!
8 Nov-19 0.00 0.00 0.00 0.00 0.00 #DIV/0!
9 Dec-19 0.00 0.00 0.00 0.00 0.00 #DIV/0!
  3rd Qtr 0.00 0.00 0.00 0.00 0.00 #DIV/0!
1 Jan-20 0.00 0.00 0.00 0.00 0.00 #DIV/0!
2 Feb-20 0.00 0.00 0.00 0.00 0.00 #DIV/0!
3 Mar-20 0.00 0.00 0.00 0.00 0.00 #DIV/0!
  4th Qtr 0.00 0.00 0.00 0.00 0.00 #DIV/0!
  Yearly Data 19960.00 10477293.00 209126768280.00 2221004.00 60076671.00 27.05