Transmission-Distribution-Hub Coordination Dataset.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	W	X	Y	Z	AA
1	Line ID	From Bus	To Bus	R (p.u.)	X (p.u.)	Thermal Limit (MVA)		Hour	Total P	Total_Q	Bus2	Bus3	Bus4	Bus5	Bus6	Bus9	Bus10	Bus11	Bus12	Bus13	Bus14	Hourly Renewable Generation Profiles
2	1	1	2	0.01775	0.05917	175		1	72.8	27.664	6.02	24.44	14.89	2.23	3.11	8.67	2.8	1.14	1.82	3.84	3.84	Hour	Solar Irradiance (kW/m²)	Wind Speed (m/s)	Solar Output (MW)	Wind Output (MW)
3	2	1	5	0.05403	0.22304	250		2	69.7	26.486	5.93	23.46	14.36	2.13	2.86	8.11	2.6	1.04	1.66	3.69	3.85	1	0	3.1	0	6
4	3	2	3	0.04699	0.19797	250		3	67.6	24.928	5.51	21.59	13.63	1.99	2.76	7.91	2.55	1.02	1.58	3.52	3.52	2	0	3.4	0	6.5
5	4	2	5	0.05214	0.17388	250		4	65.5	25.65	5.46	22.94	14.01	1.89	2.68	8.14	2.57	1	1.57	3.52	3.73	3	0	3.65	0	7
6	5	3	4	0.0335	0.17103	250		5	67.6	24.928	5.51	21.59	13.63	1.99	2.76	7.91	2.55	1.02	1.58	3.52	3.52	4	0	3.9	0	7.5
7	6	4	5	0.00668	0.04211	200		6	72.8	27.664	6.02	24.44	14.89	2.23	3.11	8.67	2.8	1.14	1.82	3.84	3.84	5	0	3.65	0	7
8	7	4	7	0.02091	0.20912	275		7	83.2	27.664	6.02	24.44	14.89	2.23	3.11	8.67	2.8	1.14	1.82	3.84	3.84	6	0	3.1	0	6
9	8	4	9	0.05562	0.55618	400		8	93.6	34.808	6.98	31.53	18.54	2.77	3.85	10.89	3.54	1.44	2.31	4.88	4.88	7	0.071	2.6	1	5
10	9	5	6	0.0252	0.25202	375		9	104	34.504	6.21	31.37	18.21	2.75	3.78	11.16	3.64	1.45	2.33	4.95	4.95	8	0.1925	2.1	4	4
11	10	6	11	0.0237	0.1989	275		10	98.8	35.568	7.43	32.94	18.5	2.69	3.74	11.12	3.53	1.42	2.32	4.95	4.95	9	0.329	1.85	7.5	3.5
12	11	6	12	0.03073	0.25581	350		11	96.7	36.746	7.73	34.01	19.1	2.78	3.86	11.48	3.65	1.47	2.39	5.12	5.12	10	0.416	1.6	10	3
13	12	6	13	0.03308	0.13027	200		12	93.6	37.468	8.38	34.34	19.64	2.83	3.92	11.59	3.7	1.47	2.39	5.17	5.17	11	0.4575	1.35	11	2.5
14	13	7	8	0.01762	0.17615	275		13	90.5	35.606	7.14	32.25	18.96	2.84	3.94	11.13	3.62	1.47	2.36	4.99	4.99	12	0.5	1.6	12.5	3
15	14	7	9	0.011	0.11001	225		14	88.4	33.592	6.01	30.61	18.12	2.79	3.74	10.59	3.48	1.37	2.21	4.74	4.74	13	0.5	2.1	12.5	4
16	15	9	10	0.00253	0.0845	200		15	86.3	30.59	5.74	27.59	16.43	2.53	3.41	9.71	3.2	1.29	2.02	4.29	4.29	14	0.481	2.6	11.5	5
17	16	9	14	0.02542	0.27038	375		16	88.4	30.894	5.95	27.71	16.59	2.56	3.44	9.81	3.24	1.3	2.04	4.33	4.33	15	0.3925	3.1	9	6
18	17	10	11	0.02462	0.19207	275		17	93.6	39.672	8.88	35.62	21.9	3.23	4.19	11.86	3.94	1.56	2.52	5.35	5.35	16	0.274	3.65	6	7
19	18	12	13	0.05997	0.19988	250		18	104	41.496	9.19	37.3	22.93	3.38	4.38	12.42	4.12	1.64	2.64	5.6	5.6	17	0.1425	3.9	3	7.5
20	19	13	14	0.08547	0.34802	325		19	109.2	39.482	8.84	35.45	21.79	3.21	4.17	11.8	3.92	1.56	2.51	5.32	5.32	18	0.071	4.15	1	8
21								20	104	37.43	7.96	33.8	20.54	3.07	4	11.29	3.74	1.51	2.39	5.1	5.1	19	0	3.9	0	7.5
22								21	98.8	35.644	7.49	32.23	19.58	2.93	3.82	10.76	3.57	1.44	2.28	4.86	4.86	20	0	3.65	0	7
23								22	93.6	36.328	7.63	32.84	19.96	2.98	3.89	10.96	3.64	1.47	2.32	4.95	4.95	21	0	3.4	0	6.5
24								23	88.4	33.592	8.53	29.76	17.5	2.62	3.63	10.27	3.34	1.36	2.18	4.6	4.6	22	0	3.1	0	6
25								24	78	29.64	6.44	26.17	15.94	2.39	3.32	9.3	3.01	1.25	1.97	4.1	4.1	23	0	3.1	0	6
26																						24	0	3.1	0	6
27	Transmission System Thermal Units Parameters
28	Bus	P_min (MW)	P_max (MW)	Q_min (MVAr)	Q_max (MVAr)	Fuel_Cost ($/MWh)	Startup_Cost ($)	Min_Up_Time (h)	Min_Down_Time (h)	Ramp_Rate (MW/h)
29	1	0	250	-10	50	45.2	150	4	4	75
30	2	10	150	-40	40	38.7	100	3	3	45
31	3	10	100	0	40	42.1	80	2	2	30
32	6	10	100	-6	24	39.8	80	2	2	30
33	8	10	100	-6	24	41.3	80	2	2	30
34
35
36
37
38
39
40
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