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-21 41994.00 97790.00 173553.00 1.77
2 May-21 47169.00 97807.00 313517.00 3.21
3 Jun-21 48844.00 97976.00 257746.00 2.63
  1st Qtr 138007.00 97976.00 744816.00 7.60
4 Jul-21 47001.00 98037.00 351298.00 3.58
5 Aug-21 41719.00 98099.00 221353.00 2.26
6 Sep-21 49218.00 98099.00 386745.00 3.94
  2nd Qtr 137938.00 98099.00 959396.00 9.78
7 Oct-21 0.00 0.00 0.00 #DIV/0!
8 Nov-21 0.00 0.00 0.00 #DIV/0!
9 Dec-21 0.00 0.00 0.00 #DIV/0!
  3rd Qtr 0.00 0.00 0.00 #DIV/0!
1 Jan-22 0.00 0.00 0.00 #DIV/0!
2 Feb-22 0.00 0.00 0.00 #DIV/0!
3 Mar-22 0.00 0.00 0.00 #DIV/0!
  4th Qtr 0.00 0.00 0.00 #DIV/0!
  Yearly Data 275945.00 98099.00 1704212.00 17.37
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-21 1:25 41994.00 59565:28 97790.00 7583.56 1:51
2 May-21 2:45 47169.00 129946:57 97807.00 23233.90 5:42
3 Jun-21 2:29 48844.00 122016:58 97976.00 15493.63 3:47
  1st Qtr 6:40 138007.00 920706:18 97976.00 46311.08 11:20
4 Jul-21 1:00 47001.00 82122:54 98037.00 19658.24 4:48
5 Aug-21 0:55 41719.00 75067:01 98099.00 11547.56 2:49
6 Sep-21 0:49 49218.00 77857:59 98099.00 19136.24 4:40
  2nd Qtr 2:46 137938.00 382660:08 98099.00 50342.04 12:18
7 Oct-21 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
8 Nov-21 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
9 Dec-21 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-22 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
2 Feb-22 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
3 Mar-22 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 9:26 275945.00 2606463:58 98099.00 96653.12 23:38
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-21 1742.00 32747.00 57045274.00 97790.00 164786.00 1.69
2 May-21 2201.00 35095.00 77244095.00 97807.00 195525.00 2.00
3 Jun-21 2129.00 31596.00 67267884.00 97976.00 159283.00 1.63
  1st Qtr 6072.00 99438.00 603787536.00 97976.00 519594.00 5.30
4 Jul-21 2239.00 37202.00 83295278.00 98037.00 196957.00 2.01
5 Aug-21 1596.00 30688.00 48978048.00 98099.00 138475.00 1.41
6 Sep-21 2425.00 39602.00 96034850.00 98099.00 235191.00 2.40
  2nd Qtr 6260.00 107492.00 672899920.00 98099.00 570623.00 5.82
7 Oct-21 0.00 0.00 0.00 0.00 0.00 #DIV/0!
8 Nov-21 0.00 0.00 0.00 0.00 0.00 #DIV/0!
9 Dec-21 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-22 0.00 0.00 0.00 0.00 0.00 #DIV/0!
2 Feb-22 0.00 0.00 0.00 0.00 0.00 #DIV/0!
3 Mar-22 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 12332.00 206930.00 2551860760.00 98099.00 1090217.00 11.11