SoP 011 - A : System Average Interrruption Frequency Index (SAIFI) for OTHER ALL 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 56920.00 85702.00 268685.00 3.14
2 May-18 48667.00 73202.00 188981.00 2.58
3 Jun-18 55333.00 108855.00 267498.00 2.46
  1st Qtr 160920.00 108855.00 725164.00 6.66
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 160920.00 108855.00 725164.00 6.66
SoP 011 - B : System Average Interrruption Duration Index (SAIDI) for OTHER ALL 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:50 56920.00 105034:12 85702.00 21197.67 5:56
2 May-18 1:32 48667.00 74910:00 73202.00 10893.59 3:34
3 Jun-18 1:37 55333.00 90356:01 108855.00 18338.77 4:02
  1st Qtr 5:01 160920.00 807413:08 108855.00 50430.03 11:07
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 5:01 160920.00 807413:08 108855.00 50430.03 11:07
SoP 011 - C : Momentary Average Interruption Frequency Index (MAIFI) for OTHER ALL 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 2261.00 45927.00 103840947.00 85702.00 300275.00 3.50
2 May-18 1218.00 37073.00 45154914.00 73202.00 128939.00 1.76
3 Jun-18 1851.00 45242.00 83742942.00 108855.00 210962.00 1.94
  1st Qtr 5330.00 128242.00 683529860.00 108855.00 640176.00 5.88
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 5330.00 128242.00 683529860.00 108855.00 640176.00 5.88