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 1809632.00 2129888.00 8326004.00 3.91
  1st Qtr 5291863.00 2129888.00 21736506.00 10.21
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!
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 5291863.00 2129888.00 21736506.00 10.21
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 1809632.00 2285719:45 2129888.00 455032.85 5:07
  1st Qtr 4:13 5291863.00 22363053:13 2129888.00 1352398.77 15:14
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!
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 4:13 5291863.00 22363053:13 2129888.00 1352398.77 15:14
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 1746111.00 5933285178.00 2129888.00 10195360.00 4.79
  1st Qtr 8443.00 5109270.00 43137566610.00 2129888.00 26255913.00 12.33
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!
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 8443.00 5109270.00 43137566610.00 2129888.00 26255913.00 12.33