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-21 1661289.00 2275915.00 5742894.00 2.52
2 May-21 2045785.00 2273119.00 12044208.00 5.30
3 Jun-21 2031543.00 2269686.00 11761788.00 5.18
  1st Qtr 5738617.00 2269686.00 29548890.00 13.02
4 Jul-21 0.00 0.00 0.00 #DIV/0!
5 Aug-21 0.00 0.00 0.00 #DIV/0!
6 Sep-21 0.00 0.00 0.00 #DIV/0!
  2nd Qtr 0.00 0.00 0.00 #DIV/0!
7 Oct-21 0.00 0.00 0.00 #DIV/0!
8 Nov-21 0.00 0.00 0.00 #DIV/0!
9 Dec-21 0.00 0.00 0.00 #DIV/0!
  3rd Qtr 0.00 0.00 0.00 #DIV/0!
1 Jan-22 0.00 0.00 0.00 #DIV/0!
2 Feb-22 0.00 0.00 0.00 #DIV/0!
3 Mar-22 0.00 0.00 0.00 #DIV/0!
  4th Qtr 0.00 0.00 0.00 #DIV/0!
  Yearly Data 5738617.00 2269686.00 29548890.00 13.02
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-21 0:59 1661289.00 1635774:04 2275915.00 228305.31 2:24
2 May-21 1:25 2045785.00 2910987:25 2273119.00 635607.24 6:42
3 Jun-21 1:09 2031543.00 2348570:14 2269686.00 550441.85 5:49
  1st Qtr 3:33 5738617.00 20450212:44 2269686.00 1414354.40 14:57
4 Jul-21 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
5 Aug-21 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
6 Sep-21 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-21 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
8 Nov-21 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
9 Dec-21 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-22 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
2 Feb-22 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
3 Mar-22 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 3:33 5738617.00 20450212:44 2269686.00 1414354.40 14:57
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-21 2969.00 1875771.00 5569164099.00 2275915.00 8950068.00 3.93
2 May-21 4039.00 1972305.00 7966139895.00 2273119.00 12389419.00 5.45
3 Jun-21 3755.00 1880589.00 7061611695.00 2269686.00 11461756.00 5.05
  1st Qtr 10763.00 5728665.00 61657621395.00 2269686.00 32801243.00 14.45
4 Jul-21 0.00 0.00 0.00 0.00 0.00 #DIV/0!
5 Aug-21 0.00 0.00 0.00 0.00 0.00 #DIV/0!
6 Sep-21 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-21 0.00 0.00 0.00 0.00 0.00 #DIV/0!
8 Nov-21 0.00 0.00 0.00 0.00 0.00 #DIV/0!
9 Dec-21 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-22 0.00 0.00 0.00 0.00 0.00 #DIV/0!
2 Feb-22 0.00 0.00 0.00 0.00 0.00 #DIV/0!
3 Mar-22 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 10763.00 5728665.00 61657621395.00 2269686.00 32801243.00 14.45