IEEE 33 and 199 bus microgrid formation.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Line				Switch	Load					DER
2	From	To	r (Ω)	x (Ω)	Switch	P(kW)	Q(kW)	Priority	Maximum Shedding	Shedding Step	Rated P(kW)	Rated Q(KVAr)	GFM Capability
3	1	2	0.0922	0.047	Yes	100	60	1	-	-	-	-	-
4	2	3	0.493	0.2511	-	90	40	1	-	-	-	-	-
5	3	4	0.366	0.1864	Yes	120	80	1	-	-	-	-	-
6	4	5	0.3811	0.1941	-	60	30	1	-	-	330	200	Yes
7	5	6	0.819	0.707	-	60	20	1	-	-	-	-	-
8	6	7	0.1872	0.6188	-	200	100	1	60%	20%	-	-	-
9	7	8	0.7114	0.2351	-	200	100	3	-	-	-	-	-
10	8	9	1.03	0.74	-	60	20	1	-	-	-	-	-
11	9	10	1.044	0.74	Yes	60	20	1	-	-	-	-	-
12	10	11	0.1966	0.065	-	45	30	1	-	-	-	-	-
13	11	12	0.3744	0.1238	-	60	35	1	-	-	-	-	-
14	12	13	1.468	1.155	-	60	35	1	-	-	-	-	-
15	13	14	0.5416	0.7129	Yes	120	80	1	60%	10%	-	-	-
16	14	15	0.591	0.526	-	60	10	3	-	-	-	-	-
17	15	16	0.7463	0.545	Yes	60	20	1	-	-	-	-	-
18	16	17	1.289	1.721	Yes	60	20	1	-	-	-	-	-
19	17	18	0.732	0.574	Yes	90	40	1	-	-	350	200	Yes
20	2	19	0.164	0.1565	-	90	40	1	-	-	-	-	-
21	19	20	1.5042	1.3554	Yes	90	40	1	-	-	-	-	-
22	20	21	0.4095	0.4784	-	90	40	1	-	-	-	-	-
23	21	22	0.7089	0.9373	-	90	40	1	-	-	970	450	No
24	3	23	0.4512	0.3083	Yes	90	50	1	-	-	-	-	-
25	23	24	0.898	0.7091	-	420	200	1	-	-	-	-	-
26	24	25	0.896	0.7011	-	420	200	1	-	-	-	-	-
27	6	26	0.203	0.1034	Yes	60	25	1	-	-	-	-	-
28	26	27	0.2842	0.1447	-	60	25	1	-	-	-	-	-
29	27	28	1.059	0.9337	Yes	60	20	1	-	-	-	-	-
30	28	29	0.8042	0.7006	-	120	70	1	-	-	-	-	-
31	29	30	0.5075	0.2585	-	200	600	1	-	-	-	-	-
32	30	31	0.9744	0.963	Yes	150	70	3	-	-	-	-	-
33	31	32	0.3105	0.3619	Yes	210	100	1	0%	50%	-	-	-
34	32	33	0.341	0.5302	-	60	40	1	-	-	-	-	-
35	Tie-Line
36	8	21	2	2	Yes	-	-	-	-	-	-	-	-
37	9	15	2	2	Yes	-	-	-	-	-	-	-	-
38	12	22	2	2	Yes	-	-	-	-	-	-	-	-
39	18	33	0.5	0.5	Yes	-	-	-	-	-	-	-	-
40	25	29	0.5	0.5	Yes	-	-	-	-	-	-	-	-
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100