SoP 011 - A : System Average Interrruption Frequency Index (SAIFI) for OTHER ALL 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-22 45957.00 98137.00 185350.00 1.89
2 May-22 45053.00 98272.00 204913.00 2.09
3 Jun-22 49962.00 98388.00 316730.00 3.22
  1st Qtr 140972.00 98388.00 706993.00 7.19
4 Jul-22 47902.00 98485.00 331769.00 3.37
5 Aug-22 44867.00 98910.00 229596.00 2.32
6 Sep-22 48085.00 98568.00 276889.00 2.81
  2nd Qtr 140854.00 98568.00 838254.00 8.50
7 Oct-22 0.00 0.00 0.00 #DIV/0!
8 Nov-22 0.00 0.00 0.00 #DIV/0!
9 Dec-22 0.00 0.00 0.00 #DIV/0!
  3rd Qtr 0.00 0.00 0.00 #DIV/0!
1 Jan-23 0.00 0.00 0.00 #DIV/0!
2 Feb-23 0.00 0.00 0.00 #DIV/0!
3 Mar-23 0.00 0.00 0.00 #DIV/0!
  4th Qtr 0.00 0.00 0.00 #DIV/0!
  Yearly Data 281826.00 98568.00 1545247.00 15.68
SoP 011 - B : System Average Interrruption Duration Index (SAIDI) for OTHER ALL 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-22 1:33 45957.00 71808:24 98137.00 9939.63 2:25
2 May-22 1:38 45053.00 73653:03 98272.00 11363.30 2:46
3 Jun-22 1:42 49962.00 85749:02 98388.00 18885.34 4:36
  1st Qtr 4:54 140972.00 692681:03 98388.00 40188.28 9:48
4 Jul-22 0:59 47902.00 71933:19 98485.00 17332.03 4:13
5 Aug-22 0:54 44867.00 57259:59 98910.00 10449.03 2:32
6 Sep-22 0:56 48085.00 72562:48 98568.00 15475.83 3:46
  2nd Qtr 2:50 140854.00 400387:25 98568.00 43256.89 10:31
7 Oct-22 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
8 Nov-22 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
9 Dec-22 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-23 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
2 Feb-23 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
3 Mar-23 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 7:45 281826.00 2185892:34 98568.00 83445.17 20:19
SoP 011 - C : Momentary Average Interruption Frequency Index (MAIFI) for OTHER ALL 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-22 1154.00 33213.00 38327802.00 98137.00 115274.00 1.17
2 May-22 1305.00 34652.00 45220860.00 98272.00 121604.00 1.24
3 Jun-22 1761.00 34002.00 59877522.00 98388.00 132189.00 1.34
  1st Qtr 4220.00 101867.00 429878740.00 98388.00 369067.00 3.75
4 Jul-22 2001.00 38568.00 77174568.00 98485.00 164435.00 1.67
5 Aug-22 1517.00 33208.00 50376536.00 98910.00 115556.00 1.17
6 Sep-22 1758.00 34797.00 61173126.00 98568.00 131504.00 1.33
  2nd Qtr 5276.00 106573.00 562279148.00 98568.00 411495.00 4.17
7 Oct-22 0.00 0.00 0.00 0.00 0.00 #DIV/0!
8 Nov-22 0.00 0.00 0.00 0.00 0.00 #DIV/0!
9 Dec-22 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-23 0.00 0.00 0.00 0.00 0.00 #DIV/0!
2 Feb-23 0.00 0.00 0.00 0.00 0.00 #DIV/0!
3 Mar-23 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 9496.00 208440.00 1979346240.00 98568.00 780562.00 7.92