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-20 27591.00 88519.00 85660.00 0.97
2 May-20 42486.00 88532.00 146636.00 1.66
3 Jun-20 42601.00 88449.00 295630.00 3.34
  1st Qtr 112678.00 88449.00 527926.00 5.97
4 Jul-20 0.00 0.00 0.00 #DIV/0!
5 Aug-20 0.00 0.00 0.00 #DIV/0!
6 Sep-20 0.00 0.00 0.00 #DIV/0!
  2nd Qtr 0.00 0.00 0.00 #DIV/0!
7 Oct-20 0.00 0.00 0.00 #DIV/0!
8 Nov-20 0.00 0.00 0.00 #DIV/0!
9 Dec-20 0.00 0.00 0.00 #DIV/0!
  3rd Qtr 0.00 0.00 0.00 #DIV/0!
1 Jan-21 0.00 0.00 0.00 #DIV/0!
2 Feb-21 0.00 0.00 0.00 #DIV/0!
3 Mar-21 0.00 0.00 0.00 #DIV/0!
  4th Qtr 0.00 0.00 0.00 #DIV/0!
  Yearly Data 112678.00 88449.00 527926.00 5.97
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-20 1:20 27591.00 36972:13 88519.00 3550.14 0:57
2 May-20 2:22 42486.00 100749:22 88532.00 9636.07 2:36
3 Jun-20 3:09 42601.00 134620:19 88449.00 17332.48 4:42
  1st Qtr 6:52 112678.00 774254:44 88449.00 30518.69 8:16
4 Jul-20 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
5 Aug-20 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
6 Sep-20 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
  2nd Qtr 0:00 0.00 0:00 0.00 0.00 #DIV/0!
7 Oct-20 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
8 Nov-20 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
9 Dec-20 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-21 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
2 Feb-21 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
3 Mar-21 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:52 112678.00 774254:44 88449.00 30518.69 8:16
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-20 1374.00 27995.00 38465130.00 88519.00 135642.00 1.53
2 May-20 4574.00 30898.00 141327452.00 88532.00 118954.00 1.34
3 Jun-20 7013.00 32951.00 231085363.00 88449.00 176272.00 1.99
  1st Qtr 12961.00 91844.00 1190390084.00 88449.00 430868.00 4.87
4 Jul-20 0.00 0.00 0.00 0.00 0.00 #DIV/0!
5 Aug-20 0.00 0.00 0.00 0.00 0.00 #DIV/0!
6 Sep-20 0.00 0.00 0.00 0.00 0.00 #DIV/0!
  2nd Qtr 0.00 0.00 0.00 0.00 0.00 #DIV/0!
7 Oct-20 0.00 0.00 0.00 0.00 0.00 #DIV/0!
8 Nov-20 0.00 0.00 0.00 0.00 0.00 #DIV/0!
9 Dec-20 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-21 0.00 0.00 0.00 0.00 0.00 #DIV/0!
2 Feb-21 0.00 0.00 0.00 0.00 0.00 #DIV/0!
3 Mar-21 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 12961.00 91844.00 1190390084.00 88449.00 430868.00 4.87