Spreadsheet: 861300d1709211067-create-formula-that-resets-when-it-reaches-a-new-date-example
Sheet: Ark1

 | Values |  |  |  |  |  |  |  | Values
 | ASA incl | ASA excl |  |  |  |  |  |  | ASA incl | ASA excl
19. februar 2024 | 573.181612446959 | 158.2285714285714 |  |  | ASA incl | ASA excl |  | 19. februar 2024 | 573.181612446959 | 158.2285714285714 |  |  | ASA incl | ASA excl
Q1 | 155.7024972855592 | 71.98195488721805 |  | Team 1 |  |  |  | Q1 | 155.7024972855592 | 71.98195488721805 |  | Team 1
Q2 | 1084.148148148148 | 249.385 |  | Team 2 |  |  |  | Q2 | 1084.148148148148 | 249.385 |  | Team 2
Q3 | 107.1782106782107 | 58.61998132586368 |  | Team 3 |  |  |  | Q3 | 107.1782106782107 | 58.61998132586368 |  | Team 3
Q4 | 38.72317596566523 | 31.59216589861751 |  |  |  |  |  | Q4 | 38.72317596566523 | 31.59216589861751
Q5 | 1247.235194585448 | 448.25 |  |  |  |  |  | Q5 | 1247.235194585448 | 448.25
Q6 | 873.0894736842105 | 297.1401869158879 |  |  |  |  |  | Q6 | 873.0894736842105 | 297.1401869158879
Q7 | 306 |  |  |  |  |  |  | Q7 | 306
Q8 | 110.689873417722 | 91.65671641791045 |  |  |  |  |  | Q8 | 110.689873417722 | 91.65671641791045
Q9 | 53.64705882352941 | 49.38260869565217 |  |  |  |  |  | Q9 | 53.64705882352941 | 49.38260869565217
Q10 | 1119.256317689531 | 340.9661733615222 |  |  |  |  |  | Q10 | 1119.256317689531 | 340.9661733615222
Q11 | 730.8421768707483 | 225.8672566371681 |  |  |  |  |  | Q11 | 730.8421768707483 | 225.8672566371681
Q12 | 76.13673469387756 | 57.10044642857143 |  |  |  |  |  | Q12 | 76.13673469387756 | 57.10044642857143
20. februar 2024 | 675.178458622868 | 263.7461683812723 |  |  | ASA incl | ASA excl |  | 20. februar 2024 | 675.178458622868 | 263.7461683812723 |  |  | ASA incl | ASA excl
Q1 | 66.20890937019969 | 33.20341880341881 |  | Team 1 |  |  |  | Q1 | 66.20890937019969 | 33.20341880341881 |  | Team 1
Q2 | 1464.274509803922 | 560.253807106599 |  | Team 2 |  |  |  | Q2 | 1464.274509803922 | 560.253807106599 |  | Team 2
Q3 | 61.68263473053892 | 26.48703170028818 |  | Team 3 |  |  |  | Q3 | 61.68263473053892 | 26.48703170028818 |  | Team 3
Q4 | 44.17747440273038 | 36.38309352517986 |  |  |  |  |  | Q4 | 44.17747440273038 | 36.38309352517986
Q5 | 762.4350877192983 | 309.2881355932203 |  |  |  |  |  | Q5 | 762.4350877192983 | 309.2881355932203
Q6 | 605.7978142076503 | 167.11 |  |  |  |  |  | Q6 | 605.7978142076503 | 167.11
Q7 | 119 |  |  |  |  |  |  | Q7 | 119
Q8 | 256.8990825688073 | 185.5568181818182 |  |  |  |  |  | Q8 | 256.8990825688073 | 185.5568181818182
Q9 | 51.2621359223301 | 37.61616161616162 |  |  |  |  |  | Q9 | 51.2621359223301 | 37.61616161616162
Q10 | 1781.316176470588 | 889.9096446700507 |  |  |  |  |  | Q10 | 1781.316176470588 | 889.9096446700507
Q11 | 292.0255591054313 | 134.0807174887892 |  |  |  |  |  | Q11 | 292.0255591054313 | 134.0807174887892
Q12 | 43.68434343434343 | 38.44204851752021 |  |  |  |  |  | Q12 | 43.68434343434343 | 38.44204851752021
21. februar 2024 | 819.5994483604045 | 211.3176733780761 |  |  | ASA incl | ASA excl |  | 21. februar 2024 | 819.5994483604045 | 211.3176733780761 |  |  | ASA incl | ASA excl
Q1 | 109.2064714946071 | 63.67754318618042 |  | Team 1 |  |  |  | Q1 | 109.2064714946071 | 63.67754318618042 |  | Team 1
Q2 | 1194.564668769716 | 182.8787878787879 |  | Team 2 |  |  |  | Q2 | 1194.564668769716 | 182.8787878787879 |  | Team 2
Q3 | 56.47872340425532 | 39.13604766633565 |  | Team 3 |  |  |  | Q3 | 56.47872340425532 | 39.13604766633565 |  | Team 3
Q4 | 1583.33921302578 | 224.0473933649289 |  |  |  |  |  | Q4 | 1583.33921302578 | 224.0473933649289
Q5 | 1308.915413533835 | 407.664705882353 |  |  |  |  |  | Q5 | 1308.915413533835 | 407.664705882353
Q6 | 975.76 | 335.2478632478632 |  |  |  |  |  | Q6 | 975.76 | 335.2478632478632
Q7 | 225.8165137614679 | 121.0833333333333 |  |  |  |  |  | Q7 | 225.8165137614679 | 121.0833333333333
Q8 | 129.4710743801653 | 116.4782608695652 |  |  |  |  |  | Q8 | 129.4710743801653 | 116.4782608695652
Q9 | 1270.274451689389 | 471.329185520362 |  |  |  |  |  | Q9 | 1270.274451689389 | 471.329185520362
Q10 | 409.5362831858407 | 191.9327217125382 |  |  |  |  |  | Q10 | 409.5362831858407 | 191.9327217125382
Q11 | 919.0773480662983 | 195.7914691943128 |  |  |  |  |  | Q11 | 919.0773480662983 | 195.7914691943128
Q12 | 323 | 313 |  |  |  |  |  | Q12 | 323 | 313
22. februar 2024 | 819.5994483604045 | 211.3176733780761
Q1
Q2
Q3
Q4
Q5
Q6
Q7
Q8
Q9
Q10
Q11
Q12
23. februar 2024
Q1
Q2
Q3
Q4
Q5
Q6
Q7
Q8
Q9
Q10
Q11
Q12
24. februar 2024
Q1
Q3
Q9
Q12
25. februar 2024
Q1
Q3
Q9
Q12