IEEE-123 Multi-Energy Hub Simulation Inputs.xlsx

	A	B	D	E	F	G	H	I	J	K	M	N	O	P	R	S	T	U	V	W
1		Hourly Load Data	Spot Loads									Line Segment Data					Transformer Data
2	Hour	IEEE 123-bus (MW)	Node	Load	Ph-1	Ph-1	Ph-2	Ph-2	Ph-3	Ph-4	Node A	Node B	Length (ft.)	Config.
3	1	2.45		Model	kW	kVAr	kW	kVAr	kW	kVAr	1	2	175	10		kVA	kV-high	kV-low	R - %	X - %
4	2	2.38	1	Y-PQ	40	20	0	0	0	0	1	3	250	11	Substation	5,000	115 - D	4.16 Gr-W	1	8
5	3	2.33	2	Y-PQ	0	0	20	10	0	0	1	7	300	1	XFM - 1	150	4.16 - D	.480 - D	1.27	2.72
6	4	2.31	4	Y-PR	0	0	0	0	40	20	3	4	200	11
7	5	2.35	5	Y-I	0	0	0	0	20	10	3	5	325	11
8	6	2.52	6	Y-Z	0	0	0	0	40	20	5	6	250	11
9	7	2.87	7	Y-PQ	20	10	0	0	0	0	7	8	200	1
10	8	3.12	9	Y-PQ	40	20	0	0	0	0	8	12	225	10
11	9	3.25	10	Y-I	20	10	0	0	0	0	8	9	225	9
12	10	3.18	11	Y-Z	40	20	0	0	0	0	8	13	300	1
13	11	3.05	12	Y-PQ	0	0	20	10	0	0	9	14	425	9
14	12	2.98	16	Y-PQ	0	0	0	0	40	20	13	34	150	11
15	13	2.95	17	Y-PQ	0	0	0	0	20	10	13	18	825	2
16	14	3.02	19	Y-PQ	40	20	0	0	0	0	14	11	250	9
17	15	3.08	20	Y-I	40	20	0	0	0	0	14	10	250	9
18	16	3.15	22	Y-Z	0	0	40	20	0	0	15	16	375	11
19	17	3.28	24	Y-PQ	0	0	0	0	40	20	15	17	350	11
20	18	3.42	28	Y-I	40	20	0	0	0	0	18	19	250	9
21	19	3.5	29	Y-Z	40	20	0	0	0	0	18	21	300	2
22	20	3.45	30	Y-PQ	0	0	0	0	40	20	19	20	325	9
23	21	3.32	31	Y-PQ	0	0	0	0	20	10	21	22	525	10
24	22	3.18	32	Y-PQ	0	0	0	0	20	10	21	23	250	2
25	23	2.95	33	Y-I	40	20	0	0	0	0	23	24	550	11
26	24	2.68	34	Y-Z	0	0	0	0	40	20	23	25	275	2
27			35	D-PQ	40	20	0	0	0	0	25	26	350	7
28			37	Y-Z	40	20	0	0	0	0	25	28	200	2
29			38	Y-I	0	0	20	10	0	0	26	27	275	7
30			39	Y-PQ	0	0	20	10	0	0	26	31	225	11
31			41	Y-PQ	0	0	0	0	20	10	27	33	500	9
32			42	Y-PQ	20	10	0	0	0	0	28	29	300	2
33			43	Y-Z	0	0	40	20	0	0	29	30	350	2
34			45	Y-I	20	10	0	0	0	0	30	122	200	2
35			46	Y-PQ	20	10	0	0	0	0	31	32	300	11
36			47	Y-I	35	25	35	25	35	25	34	15	100	11
37			48	Y-Z	70	50	70	50	70	50	35	36	650	8
38			49	Y-PQ	35	25	70	50	35	20	35	40	250	1
39			50	Y-PQ	0	0	0	0	40	20	36	37	300	9
40			51	Y-PQ	20	10	0	0	0	0	36	38	250	10
41			52	Y-PQ	40	20	0	0	0	0	38	39	325	10
42			53	Y-PQ	40	20	0	0	0	0	40	41	325	11
43			55	Y-Z	20	10	0	0	0	0	40	42	250	1
44			56	Y-PQ	0	0	20	10	0	0	42	43	500	10
45			58	Y-I	0	0	20	10	0	0	42	44	200	1
46			59	Y-PQ	0	0	20	10	0	0	44	45	200	9
47			60	Y-PQ	20	10	0	0	0	0	44	47	250	1
48			62	Y-Z	0	0	0	0	40	20	45	46	300	9
49			63	Y-PQ	40	20	0	0	0	0	47	48	150	4
50			64	Y-I	0	0	75	35	0	0	47	49	250	4
51			65	D-Z	35	25	35	25	70	50	49	50	250	4
52			66	Y-PQ	0	0	0	0	75	35	50	51	250	4
53			68	Y-PQ	20	10	0	0	0	0	51	116	500	4
54			69	Y-PQ	40	20	0	0	0	0	52	53	200	1
55			70	Y-PQ	20	10	0	0	0	0	53	54	125	1
56			71	Y-PQ	40	20	0	0	0	0	54	55	275	1
57			73	Y-PQ	0	0	0	0	40	20	54	57	350	3
58			74	Y-Z	0	0	0	0	40	20	55	56	275	1
59			75	Y-PQ	0	0	0	0	40	20	57	58	250	10
60			76	D-I	105	80	70	50	70	50	57	60	750	3
61			77	Y-PQ	0	0	40	20	0	0	58	59	250	10
62			79	Y-Z	40	20	0	0	0	0	60	61	550	5
63			80	Y-PQ	0	0	40	20	0	0	60	62	250	12
64			82	Y-PQ	40	20	0	0	0	0	62	63	175	12
65			83	Y-PQ	0	0	0	0	20	10	63	64	350	12
66			84	Y-PQ	0	0	0	0	20	10	64	65	425	12
67			85	Y-PQ	0	0	0	0	40	20	65	66	325	12
68			86	Y-PQ	0	0	20	10	0	0	67	68	200	9
69			87	Y-PQ	0	0	40	20	0	0	67	72	275	3
70			88	Y-PQ	40	20	0	0	0	0	67	97	250	3
71			90	Y-I	0	0	40	20	0	0	68	69	275	9
72			92	Y-PQ	0	0	0	0	40	20	69	70	325	9
73			94	Y-PQ	40	20	0	0	0	0	70	71	275	9
74			95	Y-PQ	0	0	20	10	0	0	72	73	275	11
75			96	Y-PQ	0	0	20	10	0	0	72	76	200	3
76			98	Y-PQ	40	20	0	0	0	0	73	74	350	11
77			99	Y-PQ	0	0	40	20	0	0	74	75	400	11
78			100	Y-Z	0	0	0	0	40	20	76	77	400	6
79			102	Y-PQ	0	0	0	0	20	10	76	86	700	3
80			103	Y-PQ	0	0	0	0	40	20	77	78	100	6
81			104	Y-PQ	0	0	0	0	40	20	78	79	225	6
82			106	Y-PQ	0	0	40	20	0	0	78	80	475	6
83			107	Y-PQ	0	0	40	20	0	0	80	81	475	6
84			109	Y-PQ	40	20	0	0	0	0	81	82	250	6
85			111	Y-PQ	20	10	0	0	0	0	81	84	675	11
86			112	Y-I	20	10	0	0	0	0	82	83	250	6
87			113	Y-Z	40	20	0	0	0	0	84	85	475	11
88			114	Y-PQ	20	10	0	0	0	0	86	87	450	6
89			Total		1420	775	915	515	1155	630	87	88	175	9
90											87	89	275	6
91											89	90	225	10
92											89	91	225	6
93											91	92	300	11
94											91	93	225	6
95											93	94	275	9
96											93	95	300	6
97											95	96	200	10
98											97	98	275	3
99											98	99	550	3
100											99	100	300	3