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-22 1783809.00 2349763.00 6937356.00 2.95
2 May-22 1981923.00 2350395.00 8894776.00 3.78
3 Jun-22 2010574.00 2351111.00 12571253.00 5.35
  1st Qtr 5776306.00 2351111.00 28403385.00 12.08
4 Jul-22 0.00 0.00 0.00 #DIV/0!
5 Aug-22 0.00 0.00 0.00 #DIV/0!
6 Sep-22 0.00 0.00 0.00 #DIV/0!
  2nd Qtr 0.00 0.00 0.00 #DIV/0!
7 Oct-22 0.00 0.00 0.00 #DIV/0!
8 Nov-22 0.00 0.00 0.00 #DIV/0!
9 Dec-22 0.00 0.00 0.00 #DIV/0!
  3rd Qtr 0.00 0.00 0.00 #DIV/0!
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 5776306.00 2351111.00 28403385.00 12.08
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-22 1:11 1783809.00 2130291:50 2349763.00 323034.07 3:17
2 May-22 1:54 1981923.00 3765735:07 2350395.00 625662.48 6:23
3 Jun-22 1:14 2010574.00 2488312:26 2351111.00 587501.79 5:59
  1st Qtr 4:19 5776306.00 25022331:53 2351111.00 1536198.34 15:40
4 Jul-22 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
5 Aug-22 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
6 Sep-22 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-22 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
8 Nov-22 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
9 Dec-22 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-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 4:19 5776306.00 25022331:53 2351111.00 1536198.34 15:40
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-22 2553.00 1850394.00 4724055882.00 2349763.00 8268857.00 3.52
2 May-22 2636.00 1843634.00 4859819224.00 2350395.00 7893484.00 3.36
3 Jun-22 3456.00 1927093.00 6660033408.00 2351111.00 10797556.00 4.59
  1st Qtr 8645.00 5621121.00 48594591045.00 2351111.00 26959897.00 11.47
4 Jul-22 0.00 0.00 0.00 0.00 0.00 #DIV/0!
5 Aug-22 0.00 0.00 0.00 0.00 0.00 #DIV/0!
6 Sep-22 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-22 0.00 0.00 0.00 0.00 0.00 #DIV/0!
8 Nov-22 0.00 0.00 0.00 0.00 0.00 #DIV/0!
9 Dec-22 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-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 8645.00 5621121.00 48594591045.00 2351111.00 26959897.00 11.47