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-22 1797370.00 1979675.00 11470362.00 5.79
2 May-22 1821790.00 1980681.00 14120526.00 7.13
3 Jun-22 1927622.00 1980544.00 20048918.00 10.12
  1st Qtr 5546782.00 1980544.00 45639806.00 23.04
4 Jul-22 1925822.00 1982572.00 24906420.00 12.56
5 Aug-22 1877341.00 1984132.00 18261939.00 9.20
6 Sep-22 1862758.00 1985114.00 17623986.00 8.88
  2nd Qtr 5665921.00 1985114.00 60792345.00 30.62
7 Oct-22 1796799.00 1985502.00 11650986.00 5.87
8 Nov-22 1748680.00 1986667.00 10350168.00 5.21
9 Dec-22 1768501.00 1999944.00 10442289.00 5.22
  3rd Qtr 5313980.00 1999944.00 32443443.00 16.22
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 16526683.00 1999944.00 138875594.00 69.44
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-22 1:11 1797370.00 2138964:05 1979675.00 574178.76 6:57
2 May-22 1:36 1821790.00 2931933:50 1980681.00 992886.31 12:01
3 Jun-22 1:15 1927622.00 2429926:56 1980544.00 1041757.56 12:37
  1st Qtr 4:03 5546782.00 22519960:56 1980544.00 2608822.62 31:36
4 Jul-22 1:10 1925822.00 2266711:08 1982572.00 1218031.00 14:44
5 Aug-22 1:03 1877341.00 2002233:16 1984132.00 806390.32 9:45
6 Sep-22 1:11 1862758.00 2226333:48 1985114.00 867160.75 10:29
  2nd Qtr 3:26 5665921.00 19483500:30 1985114.00 2891582.06 34:57
7 Oct-22 1:14 1796799.00 2239704:56 1985502.00 586245.89 7:05
8 Nov-22 1:07 1748680.00 1970521:02 1986667.00 494137.29 5:58
9 Dec-22 1:18 1768501.00 2321177:15 1999944.00 557018.48 6:41
  3rd Qtr 3:41 5313980.00 19586641:18 1999944.00 1637401.66 19:38
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 11:11 16526683.00 ################### 1999944.00 7137806.34 85:39
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-22 10535.00 1806720.00 19033795200.00 1979675.00 15371622.00 7.76
2 May-22 12366.00 1829004.00 22617463464.00 1980681.00 17856542.00 9.02
3 Jun-22 16211.00 1880023.00 30477052853.00 1980544.00 22928718.00 11.58
  1st Qtr 39112.00 5515747.00 215731896664.00 1980544.00 56156882.00 28.35
4 Jul-22 17741.00 1891159.00 33551051819.00 1982572.00 25070651.00 12.65
5 Aug-22 15404.00 1847850.00 28464281400.00 1984132.00 21431720.00 10.80
6 Sep-22 14824.00 1865740.00 27657729760.00 1985114.00 21250780.00 10.71
  2nd Qtr 47969.00 5604749.00 268854204781.00 1985114.00 67753151.00 34.13
7 Oct-22 12437.00 1803468.00 22429731516.00 1985502.00 17250853.00 8.69
8 Nov-22 13151.00 1858164.00 24436714764.00 1986667.00 18061159.00 9.09
9 Dec-22 10664.00 1822569.00 19435875816.00 1999944.00 14757933.00 7.38
  3rd Qtr 36252.00 5484201.00 198813254652.00 1999944.00 50069945.00 25.04
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 123333.00 16604697.00 2047907095101.00 1999944.00 173979978.00 86.99