FSC - Working Example - Google Sheets

	A	B	C	D	E	F	G	H	I	M	N
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30										EU 27 Weighed Average, excl. VAT
31			A	B = A /1000	C	B*(1+C) = D	E	(E / Total 2020 consumption) = F	G = D * F	H = Sum(G)
32	Country	Date	Gas oil automobile Automotive gas oil Dieselkraftstoff (I) 1000L	Diesel Price Per Liter	DIESEL_VAT	DIESEL_PRICE_EXCL_VAT	DIESELKRAFTSTOFF_CONSUMPTION	EU_27_WEIGHT	DIESEL_EXCL_VAT_WA	Date	Weighted Average EU27
33	AT	2022-03-28	1898	1.898	20%	1.581667	6245	0.03525161582	0.05575630568	2022-03-28	1.64
34	AT	2022-03-21	1828	1.828	20%	1.523333	6245	0.03525161582	0.05369996143	2022-03-21	1.62
35	AT	2022-03-14	2023	2.023	20%	1.685833	6245	0.03525161582	0.059428349	2022-03-14	1.69
36	AT	2022-03-07	1719	1.719	20%	1.432500	6245	0.03525161582	0.05049793966	2022-03-07	1.50
37	AT	2022-02-28	1520	1.52	20%	1.266667	6245	0.03525161582	0.0446520467	2022-02-28	1.36
38	AT	2022-02-21	1464	1.464	20%	1.220000	6245	0.03525161582	0.0430069713	2022-02-21	1.33
39	AT	2022-02-14	1457	1.457	20%	1.214167	6245	0.03525161582	0.04280133687	2022-02-14	1.32
40	AT	2022-02-07	1441	1.441	20%	1.200833	6245	0.03525161582	0.04233131533	2022-02-07	1.31
41	AT	2022-01-31	1430	1.43	20%	1.191667	6245	0.03525161582	0.04200817551	2022-01-31	1.30
42	AT	2022-01-24	1418	1.418	20%	1.181667	6245	0.03525161582	0.04165565936	2022-01-24	1.28
43	AT	2022-01-17	1408	1.408	20%	1.173333	6245	0.03525161582	0.04136189589	2022-01-17	1.26
44	AT	2022-01-10	1395	1.395	20%	1.162500	6245	0.03525161582	0.04098000339	2022-01-10	1.25
45	AT	2022-01-03	1380	1.38	20%	1.150000	6245	0.03525161582	0.04053935819	2022-01-03	1.23
46	AT	2021-12-20	1389	1.389	20%	1.157500	6245	0.03525161582	0.04080374531	2021-12-20	1.21
47	AT	2021-12-13	1388	1.388	20%	1.156667	6245	0.03525161582	0.04077436896	2021-12-13	1.22
48	AT	2021-12-06	1392	1.392	20%	1.160000	6245	0.03525161582	0.04089187435	2021-12-06	1.23
49	AT	2021-11-29	1407	1.407	20%	1.172500	6245	0.03525161582	0.04133251955	2021-11-29	1.24
50	AT	2021-11-22	1406	1.406	20%	1.171667	6245	0.03525161582	0.0413031432	2021-11-22	1.24
51	AT	2021-11-15	1418	1.418	20%	1.181667	6245	0.03525161582	0.04165565936	2021-11-15	1.25
52	AT	2021-11-08	1411	1.411	20%	1.175833	6245	0.03525161582	0.04145002493	2021-11-08	1.25
53	AT	2021-11-01	1402	1.402	20%	1.168333	6245	0.03525161582	0.04118563781	2021-11-01	1.25
54	AT	2021-10-25	1398	1.398	20%	1.165000	6245	0.03525161582	0.04106813243	2021-10-25	1.24
55	AT	2021-10-18	1380	1.38	20%	1.150000	6245	0.03525161582	0.04053935819	2021-10-18	1.23
56	AT	2021-10-11	1353	1.353	20%	1.127500	6245	0.03525161582	0.03974619683	2021-10-11	1.21
57	AT	2021-10-04	1307	1.307	20%	1.089167	6245	0.03525161582	0.03839488489	2021-10-04	1.18
58	AT	2021-09-27	1277	1.277	20%	1.064167	6245	0.03525161582	0.0375135945	2021-09-27	1.16
59	AT	2021-09-20	1259	1.259	20%	1.049167	6245	0.03525161582	0.03698482026	2021-09-20	1.15
60	AT	2021-09-13	1252	1.252	20%	1.043333	6245	0.03525161582	0.03677918584	2021-09-13	1.14
61	AT	2021-09-06	1250	1.25	20%	1.041667	6245	0.03525161582	0.03672043314	2021-09-06	1.14
62	AT	2021-08-30	1252	1.252	20%	1.043333	6245	0.03525161582	0.03677918584	2021-08-30	1.13
63	AT	2021-08-23	1240	1.24	20%	1.033333	6245	0.03525161582	0.03642666968	2021-08-23	1.12
64	AT	2021-08-16	1248	1.248	20%	1.040000	6245	0.03525161582	0.03666168045	2021-08-16	1.13
65	AT	2021-08-09	1248	1.248	20%	1.040000	6245	0.03525161582	0.03666168045	2021-08-09	1.13
66	AT	2021-08-02	1249	1.249	20%	1.040833	6245	0.03525161582	0.0366910568	2021-08-02	1.13
67	AT	2021-07-26	1243	1.243	20%	1.035833	6245	0.03525161582	0.03651479872	2021-07-26	1.13
68	AT	2021-07-19	1239	1.239	20%	1.032500	6245	0.03525161582	0.03639729333	2021-07-19	1.13
69	AT	2021-07-12	1245	1.245	20%	1.037500	6245	0.03525161582	0.03657355141	2021-07-12	1.13
70	AT	2021-07-05	1227	1.227	20%	1.022500	6245	0.03525161582	0.03604477717	2021-07-05	1.13
71	AT	2021-06-28	1224	1.224	20%	1.020000	6245	0.03525161582	0.03595664813	2021-06-28	1.12
72	AT	2021-06-21	1213	1.213	20%	1.010833	6245	0.03525161582	0.03563350832	2021-06-21	1.11
73	AT	2021-06-14	1203	1.203	20%	1.002500	6245	0.03525161582	0.03533974486	2021-06-14	1.10
74	AT	2021-06-07	1194	1.194	20%	0.995000	6245	0.03525161582	0.03507535774	2021-06-07	1.10
75	AT	2021-05-31	1188	1.188	20%	0.990000	6245	0.03525161582	0.03489909966	2021-05-31	1.09
76	AT	2021-05-24	1186	1.186	20%	0.988333	6245	0.03525161582	0.03484034697	2021-05-24	1.09
77	AT	2021-05-17	1187	1.187	20%	0.989167	6245	0.03525161582	0.03486972331	2021-05-17	1.09
78	AT	2021-05-10	1190	1.19	20%	0.991667	6245	0.03525161582	0.03495785235	2021-05-10	1.08
79	AT	2021-05-03	1173	1.173	20%	0.977500	6245	0.03525161582	0.03445845446	2021-05-03	1.07
80	AT	2021-04-26	1170	1.17	20%	0.975000	6245	0.03525161582	0.03437032542	2021-04-26	1.07
81	AT	2021-04-19	1168	1.168	20%	0.973333	6245	0.03525161582	0.03431157273	2021-04-19	1.07
82	AT	2021-04-12	1163	1.163	20%	0.969167	6245	0.03525161582	0.034164691	2021-04-12	1.07
83	AT	2021-03-29	1167	1.167	20%	0.972500	6245	0.03525161582	0.03428219638	2021-03-29	1.07
84	AT	2021-03-22	1163	1.163	20%	0.969167	6245	0.03525161582	0.034164691	2021-03-22	1.07
85	AT	2021-03-15	1168	1.168	20%	0.973333	6245	0.03525161582	0.03431157273	2021-03-15	1.07
86	AT	2021-03-08	1156	1.156	20%	0.963333	6245	0.03525161582	0.03395905657	2021-03-08	1.06
87	AT	2021-03-01	1147	1.147	20%	0.955833	6245	0.03525161582	0.03369466945	2021-03-01	1.06
88	AT	2021-02-22	1135	1.135	20%	0.945833	6245	0.03525161582	0.03334215329	2021-02-22	1.05
89	AT	2021-02-15	1123	1.123	20%	0.935833	6245	0.03525161582	0.03298963714	2021-02-15	1.03
90	AT	2021-02-08	1101	1.101	20%	0.917500	6245	0.03525161582	0.03234335751	2021-02-08	1.02
91	AT	2021-02-01	1085	1.085	20%	0.904167	6245	0.03525161582	0.03187333597	2021-02-01	1.01
92	AT	2021-01-25	1088	1.088	20%	0.906667	6245	0.03525161582	0.03196146501	2021-01-25	1.00
93	AT	2021-01-18	1083	1.083	20%	0.902500	6245	0.03525161582	0.03181458327	2021-01-18	1.00
94	AT	2021-01-11	1069	1.069	20%	0.890833	6245	0.03525161582	0.03140331442	2021-01-11	0.99
95	AT	2020-12-21	1043	1.043	20%	0.869167	6245	0.03525161582	0.03063952941	2020-12-21	0.96
96	AT	2020-12-14	1041	1.041	20%	0.867500	6245	0.03525161582	0.03058077672	2020-12-14	0.95
97	AT	2020-12-07	1042	1.042	20%	0.868333	6245	0.03525161582	0.03061015307	2020-12-07	0.94
98	AT	2020-11-30	1027	1.027	20%	0.855833	6245	0.03525161582	0.03016950787	2020-11-30	0.94
99	AT	2020-11-23	1021	1.021	20%	0.850833	6245	0.03525161582	0.02999324979	2020-11-23	0.93
100	AT	2020-11-16	1001	1.001	20%	0.834167	6245	0.03525161582	0.02940572286	2020-11-16	0.92