EDF - Google Sheets

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Z
1				Totals						Days	KwH/day
2											20.76855181		28012.2163		#DIV/0!		#DIV/0!
3	Reading				Units generated	pence per	deemed			1,461.00	11.99053832	4380
4
5
6				Date							KWH/day
7				29/3/18
8				31/3/18	34.3	12.94	17.15	5.03		2	17.15		5.3
9				5/7/18	1663.7	13.47	831.85	5.24		96	17.33020833		267.69		1.040958269
10				7/10/18	1420	13.47	710	5.24		94	15.10638298		228.48
11				8/1/19	586	13.47	293	5.24		93	6.301075269		94.29
12		72.00	10.00	31/3/19	822.93	13.47	411.465	5.24		82	10.03573171		132.41
13				1/4/19	20.07	13.83	10.035	5.38		1	20.07		3.32		1.026726058
14		81.00	20.00	11/7/19	1652	13.83	826	5.38		101	16.35643564		272.91
15		72.00	18.00	9/10/19	1350	13.83	675	5.38		90	15		223.02
16		73.00	16.00	6/1/20	495	13.83	247.5	5.38		89	5.561797753		81.77
17		75.00	10.00	31/3/20	792.36	13.83	396.18	5.38		85	9.321882353		130.9
18				1/4/20	18.64	14.13	9.32	5.5		1	18.64		3.15		1.021691974		This document sets out the tariff rates for the Feed-in Tariff scheme.
19		81.00	29.00	20/7/20	1949	14.13	974.5	5.5		110	17.71818182		328.99				Relevant tariffs have been adjusted by RPI of 2.2 percent, effective from 1 April 2020.
20		63.00	36.00	27/10/20	1230	14.13	615	5.5		99	12.42424242		207.62
21		55.00	27.00	17/1/21	363	14.13	181.5	5.5		82	4.426829268		61.27
22		63.00	10.00	31/3/21	778.93	14.13	389.465	5.5		73	10.67027397		131.48
23				20/4/21	224.07	14.3	112.035	5.57		20	11.2035		38.28		1.012031139		This document sets out the tariff rates for the Feed-in Tariff scheme.
24		62.00	35.00	26/7/21	1650	14.3	825	5.57		97	17.01030928		281.9				Relevant tariffs have been adjusted by RPI of 1.2 percent, effective from 1 April 2021.
25		57.00	36.00	27/10/21	1093	14.3	546.5	5.57		93	11.75268817		186.74
26		55.00	13.00	3/1/22	318	14.3	159	5.57		68	4.676470588		54.33
27		77.00	10.00	31/3/22	889	14.3	444.5	5.57		87	10.2183908		151.89
28				1/7/22	1603	15.38	801.5	5.99		92	17.42391304		294.55
29	28,634.00			11/8/22	758	15.38	379	5.99		41	18.48780488		139.28
30
31													KwH in 1 year								1/4/22	84.72	22
32										2.00	17.15		34.3		12.94	5.03		5.3	2.65		10/3/22		3.850909091
33				18/19						365.00	12.30857534		4492.63		13.47	5.24		722.86	1.98				38.50909091
34				19/20						366.00	11.77439891		4309.43		13.83	5.38		711.92	1.95
35				20/21						365.00	11.88923288		4339.57		14.13	5.5		732.52	2.01
36				21/22						365.00	11.43580822		4174.07		14.3	5.57		713.14	1.95		2087.035
37																					125.0133965
38
39				4380		A 4kw system will, on average, generate around 3,400kwh of electricity per year.															4328.925	66578.8665
40																					2164.4625
41						16 panels		28 metre square											3333.333333		12965.13038
42													188.83	84.72	-132							79543.99688
43
44																						0.1629931973
45						15.3296
46																						0.9779591837
47						Winter	Spring	Summer	Autumn
48																						6.135225376
49						29/03/2018	21/06/2018	21/09/2018	21/12/2018			84	92	91
50					21/12	21/03/2019	21/06/2019	21/09/2019	21/12/2019		90	92	92	91
51						21/03/2020	21/06/2020	21/09/2020	21/12/2020		91	92	92	91
52						21/03/2021	21/06/2021	21/09/2021	21/12/2021		90	92	92	91
53						21/03/2022	21/06/2022	21/09/2022			90
54
55				34.30			34.3
56				1,663.70			1421.077083	242.6229167				1455.377083	1420.920789	714.2827728
57				1,420.00				1178.297872	241.7021277		835.9920378	1445.298604	1407.128713	676.011236
58				586.00		113.4193548			472.5806452		788.1299405	1547.031551	1296.554545	690.748337
59				822.93		722.5726829	100.3573171				791.7516505	1396.615415	1265.264051	680.3026565
60				20.07			20.07				847.6102096
61				1,652.00			1324.871287	327.1287129
62				1,350.00				1080	270			17.32591766	15.44479118	7.84926124
63				495.00		88.98876404			406.011236		9.28880042	15.70976744	15.29487731	7.428694901
64				792.36		699.1411765	93.21882353				8.660768577	16.81556033	14.09298419	7.590641066
65				18.64			18.64				8.797240561	15.18060234	13.75287011	7.475853369
66				1,949.00			1435.172727	513.8272727			9.417891218
67				1,230.00				782.7272727	447.2727273
68				363.00		119.5243902			243.4756098		9.041175194	15.9019767	14.38024387	7.498396445
69				778.93		672.2272603	106.7027397
70				11.20			11.2035				813.7057675			682.3540765
71				224.07			224.07					1462.981857	1322.982436
72				1,650.00			1054.639175	595.3608247
73				1,093.00				669.9032258	423.0967742		1496.059844	Autumn & winter		8.197588186
74				318.00		60.79411765			257.2058824		2785.964293	Spring & summer		15.26555777			0.8768506901
75				889.00		786.816092	102.183908
76				0.00							1289.904449	Additional spring & summer
77				0.00
78				0.00												31/3/22	21094	155	1892	12.20645161		1110	12583	11.33603604	0.8704155769
79				0.00							Elec use 6 winter months					27/10/21	19202	50	418	8.36					158.8508428
80				0.00												7/9/21	18784	905	10273	11.35138122				4137.653153
81				0.00							2081.06					17/3/19	8511	184	1566	8.510869565
82																14/9/18	6945
83											Elec use summer months
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100