Datos_práctica3.xlsx

	A	B	C	D	E	F	G	H	I	J
1	CURSO EFICIENCIA ENERGÉTICA Y ENERGÍA SOLAR TÉRMICA
2
3	Prácticas
4
5	Mes	Día	Hora	Periodo tarifario	Precio de compra indexado (€/MWh)	Precio de venta (€/MWh)	Consumo (MWh)	Generación (MWh)	Precio producción fotovoltaica (€/MWh)	7,4
6	1	1	1	6	63,90416151	43,26208	0	0	Precio potencia contratada periodo 1 (€/kW año)	20,55785
7	1	1	2	6	64,48335271	42,82312	0	0	Precio potencia contratada periodo 2 (€/kW año)	12,762884
8	1	1	3	6	60,94559026	38,1508	0	0	Precio potencia contratada periodo 3 (€/kW año)	9,926251
9	1	1	4	6	57,54200337	34,66888	0	0	Precio potencia contratada periodo 4 (€/kW año)	7,84838
10	1	1	5	6	54,66393746	33,34456	0	0	Precio potencia contratada periodo 5 (€/kW año)	0,325141
11	1	1	6	6	52,87269364	32,608	0	0	Precio potencia contratada periodo 6 (€/kW año)	0,325141
12	1	1	7	6	52,35835397	32,608	0	0	Precio exceso de potencia (€/kW)	3,566788
13	1	1	8	6	52,40978794	32,77168	0	0	K periodo 1	1
14	1	1	9	6	51,70536621	32,39968	0	0	K periodo 2	0,620828
15	1	1	10	6	52,13920054	33,07672	0	0	K periodo 3	0,482845
16	1	1	11	6	51,68076736	33,89512	0	0,0102235	K periodo 4	0,38177
17	1	1	12	6	53,93268062	35,14504	0	0,04882325	K periodo 5	0,015816
18	1	1	13	6	54,97030501	36,38008	0	0,1226015	K periodo 6	0,015816
19	1	1	14	6	54,12723519	35,72536	0	0,06395725
20	1	1	15	6	52,57079862	34,6168	0	0,3639405
21	1	1	16	6	53,07172073	34,10344	0	0,32823875
22	1	1	17	6	53,69563712	34,11088	0	0,101752
23	1	1	18	6	58,94637431	37,88296	0	0,01449
24	1	1	19	6	63,87061762	43,44808	0	0
25	1	1	20	6	64,23289165	45,7024	0	0
26	1	1	21	6	65,49637824	47,2648	0	0
27	1	1	22	6	62,51320813	44,65336	0	0
28	1	1	23	6	61,75735244	43,44808	0	0
29	1	1	24	6	56,58488433	38,188	0	0
30	1	2	1	6	60,74656317	40,41256	0	0
31	1	2	2	6	56,55581296	36,83392	0	0
32	1	2	3	6	54,22563061	34,5424	0	0
33	1	2	4	6	52,61999632	33,56032	0	0
34	1	2	5	6	52,52830969	32,97256	0	0
35	1	2	6	6	54,12499893	34,3936	0	0
36	1	2	7	6	58,06305183	36,87856	0	0
37	1	2	8	6	62,98729514	43,44808	0	0
38	1	2	9	2	88,22222884	47,84512	0	0
39	1	2	10	1	86,7556899	47,87488	0	0
40	1	2	11	1	98,46713375	50,45656	0	0,05027225
41	1	2	12	1	96,69832434	48,59656	0	0,07889
42	1	2	13	1	96,28963048	48,418	0	0,18003825
43	1	2	14	1	86,02466284	47,84512	0	0,176778
44	1	2	15	2	83,12970598	45,02536	0	0,110768
45	1	2	16	2	82,19461922	43,92424	0	0,619367
46	1	2	17	2	82,87855558	44,85424	0	0,259854
47	1	2	18	2	89,83452472	50,97736	0	0,0451605
48	1	2	19	1	102,7935757	53,1796	0	0
49	1	2	20	1	103,9361606	53,9608	0	0
50	1	2	21	1	100,187603	51,66184	0	0
51	1	2	22	1	86,82071991	47,84512	0	0
52	1	2	23	2	82,61170828	44,2144	0	0
53	1	2	24	2	82,68346554	43,23232	0	0
54	1	3	1	6	58,91506668	40,18192	0	0
55	1	3	2	6	57,40335529	38,73856	0	0
56	1	3	3	6	55,0642279	36,142	0	0
57	1	3	4	6	50,89360403	32,98	0	0
58	1	3	5	6	50,99870822	33,11392	0	0
59	1	3	6	6	55,00832142	36,142	0	0
60	1	3	7	6	61,49347382	42,3916	0	0
61	1	3	8	6	71,17424098	51,95944	0	0
62	1	3	9	2	91,65760754	52,77784	0	0
63	1	3	10	1	92,68239087	53,58136	0	0,003059
64	1	3	11	1	104,632698	54,05752	0	0,021252
65	1	3	12	1	105,1644395	54,04264	0	0,46130525
66	1	3	13	1	103,0220927	53,59624	0	0,4756745
67	1	3	14	1	93,48966002	52,83736	0	0,59252025
68	1	3	15	2	91,7136679	51,95944	0	0,588938
69	1	3	16	2	90,87724737	51,53536	0	0,52369275
70	1	3	17	2	91,56791097	52,40584	0	0,398958
71	1	3	18	2	93,4403269	53,63344	0	0,018998
72	1	3	19	1	104,8722014	54,32536	0	0
73	1	3	20	1	105,5533578	54,77176	0	0
74	1	3	21	1	105,3643918	55,2256	0	0
75	1	3	22	1	92,08815108	52,76296	0	0
76	1	3	23	2	89,98252406	50,63512	0	0
77	1	3	24	2	88,86355933	49,66048	0	0
78	1	4	1	6	65,4986145	46,14136	0	0
79	1	4	2	6	60,14277312	41,19376	0	0
80	1	4	3	6	57,87073351	39,7504	0	0
81	1	4	4	6	56,23826412	38,188	0	0
82	1	4	5	6	55,40861186	37,71184	0	0
83	1	4	6	6	56,85994424	38,94688	0	0
84	1	4	7	6	64,64659965	45,9256	0	0
85	1	4	8	6	72,12241499	53,30608	0	0
86	1	4	9	2	92,98063197	53,81944	0	0
87	1	4	10	1	95,00104725	53,812	0	0
88	1	4	11	1	104,0350382	53,7004	0	0,052325
89	1	4	12	1	104,1646776	53,44744	0	0,46186875
90	1	4	13	1	100,3172425	52,85968	0	0,56482825
91	1	4	14	1	91,00058015	52,76296	0	0,592319
92	1	4	15	2	89,1259218	50,836	0	0,174524
93	1	4	16	2	87,66162527	49,44472	0	0,1021545
94	1	4	17	2	88,32762232	50,28544	0	0,0359835
95	1	4	18	2	92,01863624	53,1796	0	0,00511175
96	1	4	19	1	105,4566776	54,05752	0	0
97	1	4	20	1	105,0150245	54,32536	0	0
98	1	4	21	1	104,4239565	53,42512	0	0
99	1	4	22	1	90,24937136	51,08896	0	0
100	1	4	23	2	86,10314734	47,84512	0	0