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-19 46444.00 105577.00 134393.00 1.27
2 May-19 58506.00 105905.00 224212.00 2.12
3 Jun-19 59003.00 105901.00 363583.00 3.43
  1st Qtr 163953.00 105901.00 722188.00 6.82
4 Jul-19 55470.00 106026.00 309536.00 2.92
5 Aug-19 55142.00 106210.00 333759.00 3.14
6 Sep-19 58153.00 106249.00 357003.00 3.36
  2nd Qtr 168765.00 106249.00 1000298.00 9.41
7 Oct-19 57340.00 106236.00 231308.00 2.18
8 Nov-19 55144.00 106146.00 183559.00 1.73
9 Dec-19 50557.00 106437.00 212787.00 2.00
  3rd Qtr 163041.00 106437.00 627654.00 5.90
1 Jan-20 0.00 0.00 0.00 #DIV/0!
2 Feb-20 0.00 0.00 0.00 #DIV/0!
3 Mar-20 0.00 0.00 0.00 #DIV/0!
  4th Qtr 0.00 0.00 0.00 #DIV/0!
  Yearly Data 495759.00 106437.00 2350140.00 22.08
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-19 1:31 46444.00 70523:22 105577.00 7740.97 1:45
2 May-19 1:20 58506.00 78479:54 105905.00 14127.58 3:12
3 Jun-19 1:23 59003.00 82104:07 105901.00 20147.27 4:33
  1st Qtr 4:15 163953.00 697027:14 105901.00 42015.82 9:31
4 Jul-19 1:04 55470.00 66532:49 106026.00 15677.92 3:32
5 Aug-19 1:03 55142.00 118469:21 106210.00 21002.63 4:44
6 Sep-19 1:02 58153.00 79037:51 106249.00 20825.69 4:42
  2nd Qtr 3:09 168765.00 534140:13 106249.00 57506.24 12:59
7 Oct-19 1:19 57340.00 86659:04 106236.00 17511.81 3:57
8 Nov-19 1:06 55144.00 77158:47 106146.00 9569.02 2:09
9 Dec-19 1:23 50557.00 81786:24 106437.00 17928.25 4:02
  3rd Qtr 3:48 163041.00 622162:32 106437.00 45009.09 10:08
1 Jan-20 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
2 Feb-20 0:00 0.00 #DIV/0! 0.00 0.00 #DIV/0!
3 Mar-20 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 11:13 495759.00 5568546:54 106437.00 144531.15 32:35
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-19 1285.00 38566.00 49557310.00 105577.00 138459.00 1.31
2 May-19 1134.00 45748.00 51878232.00 105905.00 158468.00 1.50
3 Jun-19 1733.00 50315.00 87195895.00 105901.00 238991.00 2.26
  1st Qtr 4152.00 134629.00 558979608.00 105901.00 535918.00 5.06
4 Jul-19 1774.00 49174.00 87234676.00 106026.00 201524.00 1.90
5 Aug-19 1716.00 44857.00 76974612.00 106210.00 193763.00 1.82
6 Sep-19 2130.00 42662.00 90870060.00 106249.00 256555.00 2.41
  2nd Qtr 5620.00 136693.00 768214660.00 106249.00 651842.00 6.14
7 Oct-19 1402.00 45638.00 63984476.00 106236.00 155217.00 1.46
8 Nov-19 1446.00 40760.00 58938960.00 106146.00 160864.00 1.52
9 Dec-19 1100.00 45337.00 49870700.00 106437.00 143466.00 1.35
  3rd Qtr 3948.00 131735.00 520089780.00 106437.00 459547.00 4.32
1 Jan-20 0.00 0.00 0.00 0.00 0.00 #DIV/0!
2 Feb-20 0.00 0.00 0.00 0.00 0.00 #DIV/0!
3 Mar-20 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 13720.00 403057.00 5529942040.00 106437.00 1647307.00 15.48