Spreadsheet: 689785d1596652059-extrapolating-existing-data-depending-on-where-in-month-and-terms-sample-workbook
Sheet: One

Country | Currency | Day | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday | Monday
 |  | Date | 2020-08-03 00:00:00 | 2020-08-04 00:00:00 | 2020-08-05 00:00:00 | 2020-08-06 00:00:00 | 2020-08-07 00:00:00 | 2020-08-10 00:00:00 | 2020-08-11 00:00:00 | 2020-08-12 00:00:00 | 2020-08-13 00:00:00 | 2020-08-14 00:00:00 | 2020-08-17 00:00:00 | 2020-08-18 00:00:00 | 2020-08-19 00:00:00 | 2020-08-20 00:00:00 | 2020-08-21 00:00:00 | 2020-08-24 00:00:00 | 2020-08-25 00:00:00 | 2020-08-26 00:00:00 | 2020-08-27 00:00:00 | 2020-08-28 00:00:00 | 2020-08-31 00:00:00
 |  | year.month | 2020.8 | 2020.8 | 2020.8 | 2020.8 | 2020.8 | 2020.8 | 2020.8 | 2020.8 | 2020.8 | 2020.8 | 2020.8 | 2020.8 | 2020.8 | 2020.8 | 2020.8 | 2020.8 | 2020.8 | 2020.8 | 2020.8 | 2020.8 | 2020.8
 |  | year.week |  |  |  | 2020.32 | 2020.32 | 2020.33 | 2020.33 | 2020.33 | 2020.33 | 2020.33 | 2020.34 | 2020.34 | 2020.34 | 2020.34 | 2020.34 | 2020.35 | 2020.35 | 2020.35 | 2020.35 | 2020.35 | 2020.36
AT | EUR | ATEUR |  |  |  | 88.14492000000001 | 0 | 44.19815 | 51.98010000000001 | 0 | 5.85419 | 0 | 27.8985 | 9.085 | 0 | 8.46 | 0 | 0 | 34.3182 | 0 | 44.7828 | 0 | 148.39788
AT | EUR | ATEUR7
AT | EUR | ATEUR14
AT | EUR | ATEUR21
AU | EUR | AUEUR21
BE | EUR | BEEUR |  |  |  | 324.68289 | 0 | 152.41069 | 184.031 | 0 | 91.52221 | 0 | 33.50251 | 158.52718 | 0 | 88.37119000000001 | 0 | 42.18064 | 132.56987 | 0 | 476.2183999999999 | 0 | 441.2892300000001
BE | EUR | BEEUR7
BE | EUR | BEEUR14
BE | EUR | BEEUR21
CA | EUR | CAEUR21
CA | EUR | CAEUR21
CH | EUR | CHEUR14
CH | EUR | CHEUR21
CH | EUR | CHEUR |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CH | EUR | CHEUR7
CH | EUR | CHEUR14
CH | EUR | CHEUR21
DE | EUR | DEEUR |  |  |  | 1845.534709999999 | 0 | 1267.15733 | 1100.60354 | 0 | 806.1943499999998 | 0 | 1199.90492 | 768.83341 | 0 | 261.79981 | 0 | 225.55013 | 274.18359 | 0 | 1796.93194 | 0 | 2325.88786
DE | EUR | DEEUR7
DE | EUR | DEEUR14
DE | EUR | DEEUR21
ES | EUR | ESEUR |  |  |  | 0 | 0 | 0 | 6.01128 | 0 | 7.124479999999999 | 0 | 16.92064 | 0 | 0 | 0 | 0 | 26.56918 | 34.41313 | 0 | 127.0885 | 0 | 98.13313
ES | EUR | ESEUR7
ES | EUR | ESEUR14
ES | EUR | ESEUR21
FR | EUR | FREUR |  |  |  | 782.3053600000001 | 0 | 64.35 | 168.27122 | 0 | 362.7027 | 0 | 57.00592999999999 | 151.4336 | 0 | 506.94235 | 0 | 108.01695 | 396.25112 | 0 | 1834.830610000001 | 0 | 223.4375
FR | EUR | FREUR7
FR | EUR | FREUR14
FR | EUR | FREUR21
IE | EUR | IEEUR |  |  |  | 81.07084 | 0 | 43.52065 | 10.71884 | 0 | 64.36783 | 0 | 36.0282 | 56.1831 | 0 | 18.91781 | 0 | 24.94887 | 11.96212 | 0 | 28.75617 | 0 | 11.8326
IE | EUR | IEEUR7
IE | EUR | IEEUR14
IE | EUR | IEEUR21
LU | EUR | [NAME] |  |  |  | 0 | 0 | 0 | 23.2128 | 0 | 15.21 | 0 | 16.23375 | 12.81969 | 0 | 0 | 0 | 0 | 11.5 | 0 | 0 | 0 | 0
LU | EUR | LUEUR7 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LU | EUR | LUEUR14 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 15.21 | 0 | 16.23375 | 20.82249 | 0 | 15.21 | 0 | 16.23375
LU | EUR | LUEUR21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
NL | EUR | NLEUR |  |  |  | 1173.07895 | 0 | 547.5156000000002 | 615.1384900000002 | 0 | 525.2553299999998 | 0 | 538.63623 | 522.96362 | 0 | 490.5851 | 0 | 396.04895 | 523.24868 | 0 | 2169.944810000002 | 0 | 2951.343599999999
NL | EUR | NLEUR7
NL | EUR | NLEUR14
NL | EUR | NLEUR21
UK | EUR | UKEUR |  |  |  | 39.33450000000001 | 0 | 23.9693 | 10.4834 | 0 | 61.35100000000001 | 0 | 55.97000000000001 | 17.3935 | 0 | 4.35 | 0 | 2.5 | 5.8268 | 0 | 5.055 | 0 | 3.96
UK | EUR | UKEUR7
UK | EUR | UKEUR14
UK | EUR | UKEUR21
US | EUR | USEUR |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
US | EUR | USEUR7 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
US | EUR | USEUR14 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
US | EUR | USEUR21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0