SoP 011 - A : System Average Interrruption Frequency Index (SAIFI) for AG. Dominant 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-18 871457.00 912153.00 8134021.00 8.92
2 May-18 902844.00 926917.00 9924956.00 10.71
3 Jun-18 1023236.00 1029677.00 16306237.00 15.84
  1st Qtr 2797537.00 1029677.00 34365214.00 33.37
4 Jul-18 0.00 0.00 0.00 #DIV/0!
5 Aug-18 0.00 0.00 0.00 #DIV/0!
6 Sep-18 0.00 0.00 0.00 #DIV/0!
  2nd Qtr 0.00 0.00 0.00 #DIV/0!
7 Oct-18 0.00 0.00 0.00 #DIV/0!
8 Nov-18 0.00 0.00 0.00 #DIV/0!
9 Dec-18 0.00 0.00 0.00 #DIV/0!
  3rd Qtr 0.00 0.00 0.00 #DIV/0!
10 Jan-19 0.00 0.00 0.00 #DIV/0!
11 Feb-19 0.00 0.00 0.00 #DIV/0!
12 Mar-19 0.00 0.00 0.00 #DIV/0!
  4th Qtr 0.00 0.00 0.00 #DIV/0!
  Yearly Data 2797537.00 1029677.00 34365214.00 33.37
SoP 011 - B : System Average Interrruption Duration Index (SAIDI) for AG. Dominant 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-18 1:39 871457.00 1450551:58 912153.00 631291.13 16:36
2 May-18 1:54 902844.00 1716494:55 926917.00 848753.12 21:58
3 Jun-18 2:13 1023236.00 2280936:47 1029677.00 1594333.02 37:09
  1st Qtr 5:47 2797537.00 16211343:06 1029677.00 3074377.27 71:39
4 Jul-18 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
5 Aug-18 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
6 Sep-18 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-18 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
8 Nov-18 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
9 Dec-18 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!
10 Jan-19 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
11 Feb-19 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
12 Mar-19 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 5:47 2797537.00 16211343:06 1029677.00 3074377.27 71:39
SoP 011 - C : Momentary Average Interruption Frequency Index (MAIFI) for AG. Dominant 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-18 34440.00 890149.00 30656731560.00 912153.00 10843726.00 11.89
2 May-18 37330.00 899738.00 33587219540.00 926917.00 11782583.00 12.71
3 Jun-18 52784.00 1016094.00 53633505696.00 1029677.00 18521423.00 17.99
  1st Qtr 124554.00 2805981.00 349496157474.00 1029677.00 41147732.00 39.96
4 Jul-18 0.00 0.00 0.00 0.00 0.00 #DIV/0!
5 Aug-18 0.00 0.00 0.00 0.00 0.00 #DIV/0!
6 Sep-18 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-18 0.00 0.00 0.00 0.00 0.00 #DIV/0!
8 Nov-18 0.00 0.00 0.00 0.00 0.00 #DIV/0!
9 Dec-18 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!
10 Jan-19 0.00 0.00 0.00 0.00 0.00 #DIV/0!
11 Feb-19 0.00 0.00 0.00 0.00 0.00 #DIV/0!
12 Mar-19 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 124554.00 2805981.00 349496157474.00 1029677.00 41147732.00 39.96