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-20 27591.00 88023.00 85660.00 0.97
2 May-20 42486.00 88036.00 146636.00 1.67
3 Jun-20 42601.00 87953.00 295630.00 3.36
  1st Qtr 112678.00 87953.00 527926.00 6.00
4 Jul-20 47971.00 88163.00 328391.00 3.72
5 Aug-20 47145.00 88027.00 362630.00 4.12
6 Sep-20 48330.00 88030.00 339261.00 3.85
  2nd Qtr 143446.00 88030.00 1030282.00 11.70
7 Oct-20 44738.00 88053.00 281120.00 3.19
8 Nov-20 37354.00 88243.00 174688.00 1.98
9 Dec-20 43236.00 88479.00 197799.00 2.24
  3rd Qtr 125328.00 88479.00 653607.00 7.39
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 381452.00 88479.00 2211815.00 25.00
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-20 1:20 27591.00 36972:13 88023.00 3550.14 0:58
2 May-20 2:22 42486.00 100749:22 88036.00 9636.07 2:37
3 Jun-20 3:09 42601.00 134620:19 87953.00 17332.48 4:43
  1st Qtr 6:52 112678.00 774254:44 87953.00 30518.69 8:19
4 Jul-20 1:06 47971.00 62943:32 88163.00 15527.91 4:13
5 Aug-20 0:51 47145.00 67624:41 88027.00 17082.91 4:39
6 Sep-20 1:06 48330.00 25780:00 88030.00 17502.18 4:46
  2nd Qtr 3:04 143446.00 440866:39 88030.00 50112.99 13:39
7 Oct-20 1:19 44738.00 74871:36 88053.00 14774.89 4:01
8 Nov-20 1:08 37354.00 47977:53 88243.00 9401.98 2:33
9 Dec-20 1:14 43236.00 63944:14 88479.00 9396.99 2:32
  3rd Qtr 3:42 125328.00 465290:57 88479.00 33573.86 9:06
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 13:39 381452.00 5209633:25 88479.00 114205.54 30:58
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-20 1374.00 27995.00 38465130.00 88023.00 135642.00 1.54
2 May-20 4574.00 30898.00 141327452.00 88036.00 118954.00 1.35
3 Jun-20 7013.00 32951.00 231085363.00 87953.00 176272.00 2.00
  1st Qtr 12961.00 91844.00 1190390084.00 87953.00 430868.00 4.90
4 Jul-20 1962.00 39620.00 77734440.00 88163.00 205519.00 2.33
5 Aug-20 2503.00 38104.00 95374312.00 88027.00 221648.00 2.52
6 Sep-20 2271.00 41651.00 94589421.00 88030.00 228886.00 2.60
  2nd Qtr 6736.00 119375.00 804110000.00 88030.00 656053.00 7.45
7 Oct-20 2184.00 35712.00 77995008.00 88053.00 191226.00 2.17
8 Nov-20 2158.00 32180.00 69444440.00 88243.00 236380.00 2.68
9 Dec-20 1799.00 33015.00 59393985.00 88479.00 177885.00 2.01
  3rd Qtr 6141.00 100907.00 619669887.00 88479.00 605491.00 6.84
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 25838.00 312126.00 8064711588.00 88479.00 1692412.00 19.13