SoP 011 - A : System Average Interrruption Frequency Index (SAIFI) for URBAN 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 1698041.00 2158944.00 6445233.00 2.99
2 May-18 1784190.00 2160194.00 6965269.00 3.22
3 Jun-18 1840513.00 2160797.00 8424321.00 3.90
  1st Qtr 5322744.00 2160797.00 21834823.00 10.10
4 Jul-18 1834807.00 2163214.00 11391398.00 5.27
5 Aug-18 1708552.00 2167077.00 8311846.00 3.84
6 Sep-18 1671868.00 2184710.00 6225332.00 2.85
  2nd Qtr 5215227.00 2184710.00 25928576.00 11.87
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!
1 Jan-19 0.00 0.00 0.00 #DIV/0!
2 Feb-19 0.00 0.00 0.00 #DIV/0!
3 Mar-19 0.00 0.00 0.00 #DIV/0!
  4th Qtr 0.00 0.00 0.00 #DIV/0!
  Yearly Data 10537971.00 2184710.00 47763399.00 21.86
SoP 011 - B : System Average Interrruption Duration Index (SAIDI) for URBAN 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:25 1698041.00 2430521:01 2158944.00 430302.47 4:47
2 May-18 1:31 1784190.00 2732449:21 2160194.00 467063.44 5:11
3 Jun-18 1:15 1840513.00 2324725:05 2160797.00 462414.29 5:08
  1st Qtr 4:13 5322744.00 22493554:13 2160797.00 1359780.21 15:06
4 Jul-18 0:59 1834807.00 1809495:05 2163214.00 473357.23 5:15
5 Aug-18 1:24 1708552.00 2391944:34 2167077.00 484536.27 5:21
6 Sep-18 1:19 1671868.00 2218969:30 2184710.00 327561.12 3:35
  2nd Qtr 3:42 5215227.00 19366368:32 2184710.00 1285454.62 14:07
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!
1 Jan-19 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
2 Feb-19 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
3 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 7:56 10537971.00 ################### 2184710.00 2645234.83 29:03
SoP 011 - C : Momentary Average Interruption Frequency Index (MAIFI) for URBAN 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 2632.00 1677160.00 4414285120.00 2158944.00 8555204.00 3.96
2 May-18 2413.00 1685999.00 4068315587.00 2160194.00 7505349.00 3.47
3 Jun-18 3398.00 1777008.00 6038273184.00 2160797.00 10383223.00 4.81
  1st Qtr 8443.00 5140167.00 43398429981.00 2160797.00 26443776.00 12.24
4 Jul-18 4131.00 1910971.00 7894221201.00 2163214.00 12803361.00 5.92
5 Aug-18 3451.00 1733418.00 5982025518.00 2167077.00 10263486.00 4.74
6 Sep-18 2756.00 1732430.00 4774577080.00 2184710.00 8295946.00 3.80
  2nd Qtr 10338.00 5376819.00 55585554822.00 2184710.00 31362793.00 14.36
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!
1 Jan-19 0.00 0.00 0.00 0.00 0.00 #DIV/0!
2 Feb-19 0.00 0.00 0.00 0.00 0.00 #DIV/0!
3 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 18781.00 10516986.00 197519514066.00 2184710.00 57806569.00 26.46