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 1788344.00 1930842.00 15053959.00 7.80
  1st Qtr 5059997.00 1930842.00 33558606.00 17.38
4 Jul-18 1826100.00 1932677.00 22657127.00 11.72
5 Aug-18 1805002.00 1947238.00 17580450.00 9.03
6 Sep-18 1696282.00 1956417.00 12182494.00 6.23
  2nd Qtr 5327384.00 1956417.00 52420071.00 26.79
7 Oct-18 1729014.00 2020162.00 11604785.00 5.74
8 Nov-18 1688374.00 2022958.00 8959060.00 4.43
9 Dec-18 1836828.00 2028812.00 12030796.00 5.93
  3rd Qtr 5254216.00 2028812.00 32594641.00 16.07
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 15641597.00 2028812.00 118573318.00 58.44
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 1788344.00 2234262:11 1930842.00 812769.43 10:06
  1st Qtr 3:29 5059997.00 17693183:59 1930842.00 1795413.11 22:19
4 Jul-18 1:08 1826100.00 2097430:49 1932677.00 1061770.10 13:11
5 Aug-18 1:11 1805002.00 2138679:26 1947238.00 886536.70 10:55
6 Sep-18 1:06 1696282.00 1868790:02 1956417.00 579331.70 7:06
  2nd Qtr 3:26 5327384.00 18300337:49 1956417.00 2527638.50 31:00
7 Oct-18 1:04 1729014.00 1868692:45 2020162.00 595776.21 7:04
8 Nov-18 0:55 1688374.00 1552031:16 2022958.00 377091.26 4:28
9 Dec-18 1:04 1836828.00 1973433:36 2028812.00 610389.25 7:13
  3rd Qtr 3:04 5254216.00 16153570:44 2028812.00 1583256.71 18:43
1 Jan-19 0:00 0.00   0.00 0.00 #DIV/0!
2 Feb-19 0:00 0.00   0.00 0.00 #DIV/0!
3 Mar-19 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 10:00 15641597.00 ########################## 1956417.00 5906308.33 72:27
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 1857480.00 29320321800.00 1930842.00 24546288.00 12.71
  1st Qtr 36735.00 5396619.00 198244798965.00 1930842.00 57382204.00 29.72
4 Jul-18 19759.00 1857112.00 36694676008.00 1932677.00 29963507.00 15.50
5 Aug-18 15981.00 1879415.00 30034931115.00 1947238.00 24479856.00 12.57
6 Sep-18 11250.00 1851692.00 20831535000.00 1956417.00 17921263.00 9.16
  2nd Qtr 46990.00 5588219.00 262590410810.00 1956417.00 72364626.00 36.99
7 Oct-18 11259.00 1835337.00 20664059283.00 2020162.00 18239791.00 9.03
8 Nov-18 11575.00 1909366.00 22100911450.00 2022958.00 18759389.00 9.27
9 Dec-18 10092.00 1931412.00 19491809904.00 2028812.00 16517798.00 8.14
  3rd Qtr 32926.00 5676115.00 186891762490.00 2028812.00 53516978.00 26.38
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 116651.00 16660953.00 1943516828403.00 1956417.00 183263808.00 93.67