SoP 011 - A : System Average Interrruption Frequency Index (SAIFI) for JGY 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 1593147.00 1920484.00 8638940.00 4.50
2 May-18 1678506.00 1921825.00 9865707.00 5.13
3 Jun-18 1676437.00 1814936.00 14368150.00 7.92
  1st Qtr 4948090.00 1814936.00 32872797.00 18.11
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 4948090.00 1814936.00 32872797.00 18.11
SoP 011 - B : System Average Interrruption Duration Index (SAIDI) for JGY 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:00 1593147.00 1606491:35 1920484.00 423757.66 5:17
2 May-18 1:14 1678506.00 2079594:15 1921825.00 558886.03 6:58
3 Jun-18 1:14 1676437.00 2094451:31 1814936.00 782880.45 10:21
  1st Qtr 3:29 4948090.00 17301881:09 1814936.00 1765524.14 23:20
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 3:29 4948090.00 17301881:09 1814936.00 1765524.14 23:20
SoP 011 - C : Momentary Average Interruption Frequency Index (MAIFI) for JGY 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 10159.00 1742846.00 17705572514.00 1920484.00 15645711.00 8.15
2 May-18 10791.00 1796293.00 19383797763.00 1921825.00 17190205.00 8.94
3 Jun-18 15785.00 1741569.00 27490666665.00 1814936.00 23242997.00 12.81
  1st Qtr 36735.00 5280708.00 193986808380.00 1814936.00 56078913.00 30.90
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 36735.00 5280708.00 193986808380.00 1814936.00 56078913.00 30.90