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-19 1554815.00 1890454.00 8636156.00 4.57
2 May-19 1682344.00 1909372.00 9712760.00 5.09
3 Jun-19 1710659.00 1907222.00 19833701.00 10.40
  1st Qtr 4947818.00 1907222.00 38182617.00 20.02
4 Jul-19 1746849.00 1927095.00 18428044.00 9.56
5 Aug-19 1766683.00 1929005.00 18923365.00 9.81
6 Sep-19 1698154.00 1931773.00 18579971.00 9.62
  2nd Qtr 5211686.00 1931773.00 55931380.00 28.95
7 Oct-19 0.00 0.00 0.00 #DIV/0!
8 Nov-19 0.00 0.00 0.00 #DIV/0!
9 Dec-19 0.00 0.00 0.00 #DIV/0!
  3rd Qtr 0.00 0.00 0.00 #DIV/0!
1 Jan-20 0.00 0.00 0.00 #DIV/0!
2 Feb-20 0.00 0.00 0.00 #DIV/0!
3 Mar-20 0.00 0.00 0.00 #DIV/0!
  4th Qtr 0.00 0.00 0.00 #DIV/0!
  Yearly Data 10159504.00 1931773.00 94113997.00 48.72
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-19 1:00 1554815.00 1567995:22 1890454.00 390032.70 4:57
2 May-19 1:03 1682344.00 1792903:24 1909372.00 490910.84 6:10
3 Jun-19 1:10 1710659.00 2013947:42 1907222.00 1007271.00 12:40
  1st Qtr 3:15 4947818.00 16087771:25 1907222.00 1888214.53 23:45
4 Jul-19 1:03 1746849.00 1836946:02 1927095.00 899831.07 11:12
5 Aug-19 1:15 1766683.00 2210435:04 1929005.00 1038427.19 12:55
6 Sep-19 1:05 1698154.00 1860462:37 1931773.00 916367.51 11:23
  2nd Qtr 3:23 5211686.00 17711052:03 1931773.00 2854625.77 35:27
7 Oct-19 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
8 Nov-19 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
9 Dec-19 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-20 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
2 Feb-20 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
3 Mar-20 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:38 10159504.00 67558898:53 1931773.00 4742840.31 58:55
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-19 9497.00 1759652.00 16711415044.00 1890454.00 13891949.00 7.35
2 May-19 9434.00 1789699.00 16884020366.00 1909372.00 14217910.00 7.45
3 Jun-19 17703.00 1811998.00 32077800594.00 1907222.00 25969634.00 13.62
  1st Qtr 36634.00 5361349.00 196407659266.00 1907222.00 54079493.00 28.36
4 Jul-19 17646.00 1906059.00 33634317114.00 1927095.00 26110501.00 13.55
5 Aug-19 15934.00 1883255.00 30007785170.00 1929005.00 23619256.00 12.24
6 Sep-19 17204.00 1852378.00 31868311112.00 1931773.00 25523979.00 13.21
  2nd Qtr 50784.00 5641692.00 286507686528.00 1931773.00 75253736.00 38.96
7 Oct-19 0.00 0.00 0.00 0.00 0.00 #DIV/0!
8 Nov-19 0.00 0.00 0.00 0.00 0.00 #DIV/0!
9 Dec-19 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-20 0.00 0.00 0.00 0.00 0.00 #DIV/0!
2 Feb-20 0.00 0.00 0.00 0.00 0.00 #DIV/0!
3 Mar-20 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 87418.00 11003041.00 961863838138.00 1931773.00 129333229.00 66.95