SoP 011 - A : System Average Interrruption Frequency Index (SAIFI) for JGY 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 1791350.00 1941299.00 10816390.00 5.57
2 May-21 1858556.00 1942933.00 19591904.00 10.08
3 Jun-21 1864645.00 1952723.00 21312385.00 10.91
  1st Qtr 5514551.00 1952723.00 51720679.00 26.49
4 Jul-21 0.00 0.00 0.00 #DIV/0!
5 Aug-21 0.00 0.00 0.00 #DIV/0!
6 Sep-21 0.00 0.00 0.00 #DIV/0!
  2nd Qtr 0.00 0.00 0.00 #DIV/0!
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 5514551.00 1952723.00 51720679.00 26.49
SoP 011 - B : System Average Interrruption Duration Index (SAIDI) for JGY 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 0:59 1791350.00 1781495:46 1941299.00 447440.54 5:31
2 May-21 2:09 1858556.00 4013122:54 1942933.00 1737843.73 21:28
3 Jun-21 1:22 1864645.00 2577931:17 1952723.00 1165114.08 14:19
  1st Qtr 4:32 5514551.00 25015659:03 1952723.00 3350398.35 41:10
4 Jul-21 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
5 Aug-21 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
6 Sep-21 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-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 4:32 5514551.00 25015659:03 1952723.00 3350398.35 41:10
SoP 011 - C : Momentary Average Interruption Frequency Index (MAIFI) for JGY 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 13884.00 1863329.00 25870459836.00 1941299.00 19941959.00 10.27
2 May-21 18147.00 1853424.00 33634085328.00 1942933.00 25809003.00 13.28
3 Jun-21 19647.00 1838021.00 36111598587.00 1952723.00 28373819.00 14.53
  1st Qtr 51678.00 5554774.00 287059610772.00 1952723.00 74124781.00 37.96
4 Jul-21 0.00 0.00 0.00 0.00 0.00 #DIV/0!
5 Aug-21 0.00 0.00 0.00 0.00 0.00 #DIV/0!
6 Sep-21 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-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 51678.00 5554774.00 287059610772.00 1952723.00 74124781.00 37.96