Example Dispatch Model.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AI
1	Digital Twin Input Variables
2	Name	Value	Description
3	Wind Power Multiplier (%)	80%	Model total installed wind power with reference to pre-existing installation
4	Solar Installation (GW)	7	Additional solar power installed in digital twin
5	Minimum Hydro	20%	Minimum operating power level for hydropower (cannot go below)
6
7	CO2 existing (g/kWh)	97.05	Existing carbon intensity of power generation
8	CO2 simulated (g/kWh)	32.38	Simulated carbon intensity of power generation
9																				Hydro, Solar and Wind:	32,776,102	80.36%
10	Power from fossil fuel existing (%)	16%	Existing share of power generation that is fossil fuel																	Total Renewable MWH:	40,036,740	98.16%
11	Power from fossil fuel simulated (%)	1.998%	Simulated share of power generation that is fossil fuel
12
13	Max hydro storage (MWh)	10000	Energy Storage available in hydropower reservoirs
14	Total Cost:	2018734680	Cost per MWh ($/MWh):	49.49584139
15	The following table models the power of different generation types in half hour intervals over the course of one year. By changing the variables above you can see the effect on carbon intensity. The two figures on the far right show an example 2 weeks in August comparing the pre-existing power generation with the simulated digital twin model. Existing model has no solar power installed.
16																	Total	Total	Total	Total:			Total:	Total:	Total:	Total:	Total:	Total:
17																	1,362,935	9,686,843	7,166,407	18,651,081			3,075,243	94,230	716,555	97,996	209	40,785,945
18																	Backcast
19					Actual Data (Existing Power Model)																Simiulated Model with Battery
20				Carbon Intensity (g/kWh)	10	9	443	960	38	14	778						9	42	38	10			10	14	443	960	778
21	Month	Date		ID	Hydro	Wind	Gas	Coal	Geo	Wood	Diesel	Demand	Others (coal, wood, diesel)	Carbon Intensity		Solar Data	Wind	Solar	Geo	Hydro	Hydro curtailed	Hydro SoC	Hydro discharge	Wood	Gas	Coal	Diesel	Demand	Others (coal, wood, diesel)	Carbon Intensity	ID	Marginal	Error	Operating reserve
22	8	8/1/2017	1	1-8-1	2,001	249	1,046	53	909	36	0	4,294	89	133	1	0	198	0	909	2,001	0	0	0	36	1,046	53	0	4,243	89	135	1-8-1	Coal	TRUE	0
23	8	8/1/2017	2	1-8-1	1,992	227	947	56	908	35	0	4,165	91	127	2	0	180	0	908	1,992	0	0	0	35	947	56	0	4,118	91	129	1-8-2	Coal	TRUE	0
24	8	8/1/2017	3	1-8-2	1,911	247	900	56	909	34	0	4,057	90	125	3	0	197	0	909	1,911	0	0	0	34	900	56	0	4,006	90	127	1-8-3	Coal	TRUE	0
25	8	8/1/2017	4	1-8-2	1,811	310	855	54	910	35	0	3,974	89	122	4	0	246	0	910	1,811	0	0	0	35	855	54	0	3,911	89	124	1-8-4	Coal	TRUE	0
26	8	8/1/2017	5	1-8-3	1,758	344	812	54	910	36	0	3,914	90	119	5	0	274	0	910	1,758	0	0	0	36	812	54	0	3,843	90	121	1-8-5	Coal	TRUE	0
27	8	8/1/2017	6	1-8-3	1,720	354	798	55	909	35	0	3,871	90	119	6	0	281	0	909	1,720	0	0	0	35	798	55	0	3,798	90	121	1-8-6	Coal	TRUE	0
28	8	8/1/2017	7	1-8-4	1,693	352	801	54	909	36	0	3,844	90	120	7	0	280	0	909	1,693	0	0	0	36	801	54	0	3,772	90	122	1-8-7	Coal	TRUE	0
29	8	8/1/2017	8	1-8-4	1,698	357	795	55	908	35	0	3,849	90	120	8	0	284	0	908	1,698	0	0	0	35	795	55	0	3,776	90	122	1-8-8	Coal	TRUE	0
30	8	8/1/2017	9	1-8-5	1,734	336	808	56	907	36	0	3,877	92	120	9	0	267	0	907	1,734	0	0	0	36	808	56	0	3,808	92	122	1-8-9	Coal	TRUE	0
31	8	8/1/2017	10	1-8-5	1,795	304	843	60	908	36	0	3,945	96	123	10	0	242	0	908	1,795	0	0	0	36	843	60	0	3,883	96	125	1-8-10	Coal	TRUE	0
32	8	8/1/2017	11	1-8-6	1,878	320	955	60	908	36	0	4,156	96	129	11	0	254	0	908	1,878	0	0	0	36	955	60	0	4,090	96	131	1-8-11	Coal	TRUE	0
33	8	8/1/2017	12	1-8-6	2,095	284	1,024	84	907	37	0	4,430	121	134	12	0	226	0	907	2,095	0	0	0	37	1,024	84	0	4,371	121	135	1-8-12	Coal	TRUE	0
34	8	8/1/2017	13	1-8-7	2,578	243	1,093	154	905	36	0	5,009	190	139	13	0	193	0	905	2,578	0	0	0	36	1,093	154	0	4,960	190	140	1-8-13	Coal	TRUE	0
35	8	8/1/2017	14	1-8-7	2,982	222	1,163	276	903	37	0	5,583	313	152	14	0	177	0	903	2,982	0	0	0	37	1,163	276	0	5,538	313	153	1-8-14	Coal	TRUE	0
36	8	8/1/2017	15	1-8-8	3,448	206	1,213	346	902	35	0	6,151	381	153	15	0	164	0	902	3,448	0	0	0	35	1,213	346	0	6,109	381	154	1-8-15	Coal	TRUE	0
37	8	8/1/2017	16	1-8-8	3,629	208	1,187	393	901	36	0	6,354	430	154	16	0	165	0	901	3,629	0	0	0	36	1,187	393	0	6,312	430	155	1-8-16	Coal	TRUE	0
38	8	8/1/2017	17	1-8-9	3,661	180	1,199	376	902	36	0	6,354	412	152	17	9	143	929	902	3,661	0	0	0	36	684	0	0	6,354	36	65	1-8-17	Gas	FALSE	0
39	8	8/1/2017	18	1-8-9	3,617	175	1,187	358	902	37	0	6,276	395	150	18	9	139	929	902	3,617	0	0	0	37	653	0	0	6,276	37	64	1-8-18	Gas	FALSE	0
40	8	8/1/2017	19	1-8-10	3,531	231	1,168	333	902	37	0	6,202	370	147	19	18	183	1,892	902	3,225	306	153	0	0	0	0	0	6,202	0	24	1-8-19	Hydro	FALSE	0
41	8	8/1/2017	20	1-8-10	3,404	240	1,147	344	902	32	0	6,069	376	150	20	18	191	1,892	902	3,084	320	313	0	0	0	0	0	6,069	0	24	1-8-20	Hydro	FALSE	0
42	8	8/1/2017	21	1-8-11	3,329	250	1,133	365	902	32	0	6,011	398	154	21	22	199	2,419	902	2,492	837	732	0	0	0	0	0	6,011	0	27	1-8-21	Hydro	FALSE	0
43	8	8/1/2017	22	1-8-11	3,289	218	1,138	332	900	33	0	5,909	364	151	22	22	174	2,419	900	2,417	872	1,168	0	0	0	0	0	5,909	0	27	1-8-22	Hydro	FALSE	0
44	8	8/1/2017	23	1-8-12	3,215	217	1,161	331	885	33	0	5,843	365	154	23	26	172	2,862	885	1,923	1,292	1,814	0	0	0	0	0	5,843	0	30	1-8-23	Hydro	FALSE	0
45	8	8/1/2017	24	1-8-12	3,121	221	1,169	303	889	32	0	5,735	335	153	24	26	176	2,862	889	1,808	1,313	2,470	0	0	0	0	0	5,735	0	30	1-8-24	Hydro	FALSE	0
46	8	8/1/2017	25	1-8-13	3,079	194	1,171	293	894	33	0	5,663	325	153	25	28	154	2,998	894	1,617	1,462	3,201	0	0	0	0	0	5,663	0	31	1-8-25	Hydro	FALSE	0
47	8	8/1/2017	26	1-8-13	3,032	196	1,165	298	895	32	0	5,618	330	155	26	28	156	2,998	895	1,569	1,463	3,932	0	0	0	0	0	5,618	0	32	1-8-26	Hydro	FALSE	0
48	8	8/1/2017	27	1-8-14	3,015	172	1,162	300	876	33	0	5,557	332	156	27	26	136	2,757	876	1,787	1,228	4,546	0	0	0	0	0	5,557	0	30	1-8-27	Hydro	FALSE	0
49	8	8/1/2017	28	1-8-14	2,941	158	1,161	299	890	32	0	5,480	331	158	28	26	125	2,757	890	1,708	1,232	5,163	0	0	0	0	0	5,480	0	31	1-8-28	Hydro	FALSE	0
50	8	8/1/2017	29	1-8-15	2,866	156	1,165	299	893	32	0	5,412	332	160	29	19	124	2,105	893	2,290	576	5,451	0	0	0	0	0	5,412	0	27	1-8-29	Hydro	FALSE	0
51	8	8/1/2017	30	1-8-15	2,837	139	1,162	299	893	32	0	5,362	331	161	30	19	111	2,105	893	2,254	583	5,742	0	0	0	0	0	5,362	0	27	1-8-30	Hydro	FALSE	0
52	8	8/1/2017	31	1-8-16	2,886	105	1,165	299	891	32	0	5,378	332	161	31	12	83	1,306	891	2,886	0	5,636	213	0	0	0	0	5,378	0	22	1-8-31	Hydro	FALSE	0
53	8	8/1/2017	32	1-8-16	3,017	87	1,168	298	890	32	0	5,493	330	158	32	12	69	1,306	890	3,017	0	5,530	211	0	0	0	0	5,493	0	22	1-8-32	Hydro	FALSE	0
54	8	8/1/2017	33	1-8-17	3,158	96	1,166	299	889	32	0	5,641	331	154	33	6	76	635	889	3,158	0	5,090	882	0	0	0	0	5,641	0	18	1-8-33	Hydro	FALSE	0
55	8	8/1/2017	34	1-8-17	3,307	99	1,169	327	890	34	0	5,826	361	154	34	6	79	635	890	3,307	0	4,632	915	0	0	0	0	5,826	0	18	1-8-34	Hydro	FALSE	0
56	8	8/1/2017	35	1-8-18	3,524	118	1,179	338	892	36	0	6,086	374	151	35	0	94	0	892	3,524	0	3,844	1,576	0	0	0	0	6,086	0	14	1-8-35	Hydro	FALSE	0
57	8	8/1/2017	36	1-8-18	3,744	141	1,215	377	894	38	0	6,407	415	152	36	0	112	0	894	3,744	0	3,015	1,658	0	0	0	0	6,407	0	14	1-8-36	Hydro	FALSE	0
58	8	8/1/2017	37	1-8-19	3,790	159	1,198	377	895	38	0	6,457	416	150	37	0	126	0	895	3,790	0	2,191	1,646	0	0	0	0	6,457	0	14	1-8-37	Hydro	FALSE	0
59	8	8/1/2017	38	1-8-19	3,748	165	1,205	344	895	38	0	6,396	382	147	38	0	132	0	895	3,748	0	1,381	1,622	0	0	0	0	6,396	0	14	1-8-38	Hydro	FALSE	0
60	8	8/1/2017	39	1-8-20	3,698	161	1,203	335	893	38	0	6,327	373	147	39	0	128	0	893	3,698	0	577	1,608	0	0	0	0	6,327	0	14	1-8-39	Hydro	FALSE	0
61	8	8/1/2017	40	1-8-20	3,609	155	1,230	334	892	38	0	6,258	372	150	40	0	123	0	892	3,609	0	0	1,153	38	443	0	0	6,258	38	45	1-8-40	Gas	FALSE	0
62	8	8/1/2017	41	1-8-21	3,507	156	1,232	337	891	38	0	6,162	375	153	41	0	124	0	891	3,507	0	0	0	38	1,232	337	0	6,130	375	153	1-8-41	Coal	TRUE	0
63	8	8/1/2017	42	1-8-21	3,396	173	1,189	311	891	37	0	5,996	348	149	42	0	137	0	891	3,396	0	0	0	37	1,189	311	0	5,960	348	150	1-8-42	Coal	TRUE	0
64	8	8/1/2017	43	1-8-22	3,181	159	1,191	280	892	37	0	5,741	317	150	43	0	126	0	892	3,181	0	0	0	37	1,191	280	0	5,708	317	151	1-8-43	Coal	TRUE	0
65	8	8/1/2017	44	1-8-22	2,951	160	1,198	237	894	37	0	5,477	274	150	44	0	127	0	894	2,951	0	0	0	37	1,198	237	0	5,444	274	151	1-8-44	Coal	TRUE	0
66	8	8/1/2017	45	1-8-23	2,658	164	1,192	177	893	36	0	5,121	213	149	45	0	130	0	893	2,658	0	0	0	36	1,192	177	0	5,087	213	149	1-8-45	Coal	TRUE	0
67	8	8/1/2017	46	1-8-23	2,379	164	1,181	127	894	37	0	4,783	165	147	46	0	131	0	894	2,379	0	0	0	37	1,181	127	0	4,750	165	148	1-8-46	Coal	TRUE	0
68	8	8/1/2017	47	1-8-24	2,218	155	1,182	116	895	38	0	4,604	154	151	47	0	123	0	895	2,218	0	0	0	38	1,182	116	0	4,573	154	152	1-8-47	Coal	TRUE	0
69	8	8/1/2017	48	1-8-24	2,107	146	1,116	96	897	38	0	4,399	133	146	48	0	116	0	897	2,107	0	0	0	38	1,116	96	0	4,369	133	147	1-8-48	Coal	TRUE	0
70	8	8/2/2017	1	2-8-1	2,011	152	1,054	62	897	38	0	4,214	100	138	1	0	121	0	897	2,011	0	0	0	38	1,054	62	0	4,183	100	139	2-8-1	Coal	TRUE	0
71	8	8/2/2017	2	2-8-1	1,984	136	982	55	897	37	0	4,091	92	133	2	0	108	0	897	1,984	0	0	0	37	982	55	0	4,063	92	134	2-8-2	Coal	TRUE	0
72	8	8/2/2017	3	2-8-2	1,892	131	969	56	896	38	0	3,982	93	135	3	0	104	0	896	1,892	0	0	0	38	969	56	0	3,955	93	136	2-8-3	Coal	TRUE	0
73	8	8/2/2017	4	2-8-2	1,852	132	921	56	896	38	0	3,895	94	132	4	0	105	0	896	1,852	0	0	0	38	921	56	0	3,868	94	133	2-8-4	Coal	TRUE	0
74	8	8/2/2017	5	2-8-3	1,792	141	916	56	895	38	0	3,838	94	134	5	0	112	0	895	1,792	0	0	0	38	916	56	0	3,810	94	135	2-8-5	Coal	TRUE	0
75	8	8/2/2017	6	2-8-3	1,764	143	901	56	895	38	0	3,796	94	133	6	0	113	0	895	1,764	0	0	0	38	901	56	0	3,767	94	134	2-8-6	Coal	TRUE	0
76	8	8/2/2017	7	2-8-4	1,761	158	855	58	893	37	0	3,762	95	130	7	0	126	0	893	1,761	0	0	0	37	855	58	0	3,730	95	131	2-8-7	Coal	TRUE	0
77	8	8/2/2017	8	2-8-4	1,732	169	852	60	893	37	0	3,742	97	130	8	0	134	0	893	1,732	0	0	0	37	852	60	0	3,708	97	132	2-8-8	Coal	TRUE	0
78	8	8/2/2017	9	2-8-5	1,753	162	853	60	894	38	0	3,760	98	130	9	0	129	0	894	1,753	0	0	0	38	853	60	0	3,726	98	131	2-8-9	Coal	TRUE	0
79	8	8/2/2017	10	2-8-5	1,728	162	961	61	894	38	0	3,844	98	140	10	0	129	0	894	1,728	0	0	0	38	961	61	0	3,811	98	141	2-8-10	Coal	TRUE	0
80	8	8/2/2017	11	2-8-6	1,894	142	1,008	62	894	37	0	4,037	99	139	11	0	113	0	894	1,894	0	0	0	37	1,008	62	0	4,008	99	140	2-8-11	Coal	TRUE	0
81	8	8/2/2017	12	2-8-6	2,160	147	1,016	88	893	37	0	4,341	125	136	12	0	117	0	893	2,160	0	0	0	37	1,016	88	0	4,311	125	137	2-8-12	Coal	TRUE	0
82	8	8/2/2017	13	2-8-7	2,565	164	1,078	158	895	38	0	4,898	196	141	13	0	130	0	895	2,565	0	0	0	38	1,078	158	0	4,865	196	142	2-8-13	Coal	TRUE	0
83	8	8/2/2017	14	2-8-7	2,988	173	1,134	275	892	38	0	5,500	313	151	14	0	137	0	892	2,988	0	0	0	38	1,134	275	0	5,465	313	152	2-8-14	Coal	TRUE	0
84	8	8/2/2017	15	2-8-8	3,436	158	1,209	331	892	37	0	6,064	368	152	15	0	126	0	892	3,436	0	0	0	37	1,209	331	0	6,031	368	153	2-8-15	Coal	TRUE	0
85	8	8/2/2017	16	2-8-8	3,669	157	1,227	346	892	37	0	6,328	383	150	16	0	125	0	892	3,669	0	0	0	37	1,227	346	0	6,296	383	151	2-8-16	Coal	TRUE	0
86	8	8/2/2017	17	2-8-9	3,681	166	1,201	339	894	38	0	6,318	377	147	17	11	132	1,179	894	3,681	0	0	0	38	395	0	0	6,318	38	47	2-8-17	Gas	FALSE	0
87	8	8/2/2017	18	2-8-9	3,575	183	1,195	330	895	38	0	6,215	367	148	18	11	145	1,179	895	3,575	0	0	0	38	383	0	0	6,215	38	47	2-8-18	Gas	FALSE	0
88	8	8/2/2017	19	2-8-10	3,525	188	1,194	303	896	37	0	6,143	340	145	19	21	150	2,320	896	2,778	747	373	0	0	0	0	0	6,143	0	26	2-8-19	Hydro	FALSE	0
89	8	8/2/2017	20	2-8-10	3,436	178	1,177	299	895	37	0	6,023	336	146	20	21	141	2,320	895	2,667	770	758	0	0	0	0	0	6,023	0	26	2-8-20	Hydro	FALSE	0
90	8	8/2/2017	21	2-8-11	3,340	177	1,169	298	896	37	0	5,917	335	148	21	29	141	3,145	896	1,736	1,605	1,560	0	0	0	0	0	5,917	0	31	2-8-21	Hydro	FALSE	0
91	8	8/2/2017	22	2-8-11	3,287	170	1,162	271	895	38	0	5,823	309	145	22	29	135	3,145	895	1,648	1,639	2,380	0	0	0	0	0	5,823	0	32	2-8-22	Hydro	FALSE	0
92	8	8/2/2017	23	2-8-12	3,214	171	1,144	267	895	38	0	5,729	305	145	23	34	136	3,683	895	1,015	2,199	3,480	0	0	0	0	0	5,729	0	35	2-8-23	Hydro	FALSE	0
93	8	8/2/2017	24	2-8-12	3,124	163	1,142	269	896	38	0	5,631	307	148	24	34	129	3,683	896	923	2,201	4,580	0	0	0	0	0	5,631	0	35	2-8-24	Hydro	FALSE	0
94	8	8/2/2017	25	2-8-13	3,011	175	1,141	269	896	37	0	5,529	306	150	25	36	139	3,847	896	647	2,365	5,763	0	0	0	0	0	5,529	0	37	2-8-25	Hydro	FALSE	0
95	8	8/2/2017	26	2-8-13	2,972	169	1,157	268	895	36	0	5,498	304	152	26	36	135	3,847	895	621	2,351	6,938	0	0	0	0	0	5,498	0	37	2-8-26	Hydro	FALSE	0
96	8	8/2/2017	27	2-8-14	2,918	175	1,167	306	892	37	0	5,494	342	159	27	33	139	3,608	892	854	2,064	7,970	0	0	0	0	0	5,494	0	36	2-8-27	Hydro	FALSE	0
97	8	8/2/2017	28	2-8-14	2,871	164	1,160	316	895	35	0	5,441	351	162	28	33	130	3,608	895	808	2,064	9,002	0	0	0	0	0	5,441	0	36	2-8-28	Hydro	FALSE	0
98	8	8/2/2017	29	2-8-15	2,834	168	1,155	317	893	32	0	5,399	350	163	29	29	134	3,110	893	1,263	1,571	9,787	0	0	0	0	0	5,399	0	33	2-8-29	Hydro	FALSE	0
99	8	8/2/2017	30	2-8-15	2,768	188	1,156	317	887	29	0	5,345	346	165	30	29	149	3,110	887	1,199	1,569	10,000	0	0	0	0	0	5,345	0	33	2-8-30	Hydro	FALSE	0
100	8	8/2/2017	31	2-8-16	2,841	209	1,154	282	875	30	0	5,390	311	157	31	21	166	2,259	875	2,090	751	10,000	0	0	0	0	0	5,390	0	28	2-8-31	Hydro	FALSE	0