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-20 1346444.00 2268066.00 3975324.00 1.75
2 May-20 1884363.00 2269805.00 6723277.00 2.96
3 Jun-20 2027464.00 2266463.00 12616871.00 5.57
  1st Qtr 5258271.00 2266463.00 23315472.00 10.29
4 Jul-20 0.00 0.00 0.00 #DIV/0!
5 Aug-20 0.00 0.00 0.00 #DIV/0!
6 Sep-20 0.00 0.00 0.00 #DIV/0!
  2nd Qtr 0.00 0.00 0.00 #DIV/0!
7 Oct-20 0.00 0.00 0.00 #DIV/0!
8 Nov-20 0.00 0.00 0.00 #DIV/0!
9 Dec-20 0.00 0.00 0.00 #DIV/0!
  3rd Qtr 0.00 0.00 0.00 #DIV/0!
1 Jan-21 0.00 0.00 0.00 #DIV/0!
2 Feb-21 0.00 0.00 0.00 #DIV/0!
3 Mar-21 0.00 0.00 0.00 #DIV/0!
  4th Qtr 0.00 0.00 0.00 #DIV/0!
  Yearly Data 5258271.00 2266463.00 23315472.00 10.29
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-20 0:42 1346444.00 956362:08 2268066.00 110273.19 1:10
2 May-20 1:41 1884363.00 3182973:37 2269805.00 441886.98 4:40
3 Jun-20 1:20 2027464.00 2732157:17 2266463.00 687030.92 7:16
  1st Qtr 3:44 5258271.00 19702805:05 2266463.00 1239191.09 13:07
4 Jul-20 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
5 Aug-20 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
6 Sep-20 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-20 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
8 Nov-20 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
9 Dec-20 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-21 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
2 Feb-21 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
3 Mar-21 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:44 5258271.00 19702805:05 2266463.00 1239191.09 13:07
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-20 2791.00 1801877.00 5029038707.00 2268066.00 8986855.00 3.96
2 May-20 2421.00 1707675.00 4134281175.00 2269805.00 7389308.00 3.26
3 Jun-20 3916.00 1850010.00 7244639160.00 2266463.00 12597521.00 5.56
  1st Qtr 9128.00 5359562.00 48922081936.00 2266463.00 28973684.00 12.78
4 Jul-20 0.00 0.00 0.00 0.00 0.00 #DIV/0!
5 Aug-20 0.00 0.00 0.00 0.00 0.00 #DIV/0!
6 Sep-20 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-20 0.00 0.00 0.00 0.00 0.00 #DIV/0!
8 Nov-20 0.00 0.00 0.00 0.00 0.00 #DIV/0!
9 Dec-20 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-21 0.00 0.00 0.00 0.00 0.00 #DIV/0!
2 Feb-21 0.00 0.00 0.00 0.00 0.00 #DIV/0!
3 Mar-21 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 9128.00 5359562.00 48922081936.00 2266463.00 28973684.00 12.78