Spreadsheet: 756801d1637786599-replace-sumproduct-with-sumifs-replace-sumproduct-with-pq
Sheet: Report

 | Report | 2017 |  |  |  |  |  |  |  |  |  |  |  | 2018 |  |  |  |  |  |  |  |  |  |  |  | 2019 |  |  |  |  |  |  |  |  |  |  |  | 2020 |  |  |  |  |  |  |  |  |  |  |  | 2021
 |  | 2017-01-01 00:00:00 | 2017-02-01 00:00:00 | 2017-03-01 00:00:00 | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-01 00:00:00 | 2017-07-01 00:00:00 | 2017-08-01 00:00:00 | 2017-09-01 00:00:00 | 2017-10-01 00:00:00 | 2017-11-01 00:00:00 | 2017-12-01 00:00:00 | 2018-01-01 00:00:00 | 2018-02-01 00:00:00 | 2018-03-01 00:00:00 | 2018-04-01 00:00:00 | 2018-05-01 00:00:00 | 2018-06-01 00:00:00 | 2018-07-01 00:00:00 | 2018-08-01 00:00:00 | 2018-09-01 00:00:00 | 2018-10-01 00:00:00 | 2018-11-01 00:00:00 | 2018-12-01 00:00:00 | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
 | Material 1
 | Material 2
 | Material 3
 | Material 4
 | Material 5
 | Material 6
 | Material 7
 | Material 8
 | Material 9
 | Material 10
 | Material 11
 | Material 12
 | Material 13
 | Date | 01/01/2017 | 01/02/2017 | 01/03/2017 | 01/04/2017 | 01/05/2017 | 01/06/2017 | 01/07/2017 | 01/08/2017 | 01/09/2017 | 01/10/2017 | 01/11/2017 | 01/12/2017 | 01/01/2018 | 01/02/2018 | 01/03/2018 | 01/04/2018 | 01/05/2018 | 01/06/2018 | 01/07/2018 | 01/08/2018 | 01/09/2018 | 01/10/2018 | 01/11/2018 | 01/12/2018 | [NAME] | 01/02/2019 | 01/03/2019 | 01/04/2019 | [NAME] | 01/06/2019 | 01/07/2019 | 01/08/2019 | 01/09/2019 | 01/10/2019 | 01/11/2019 | 01/12/2019 | 01/01/2020 | 01/02/2020 | 01/03/2020 | 01/04/2020 | 01/05/2020 | 01/06/2020 | 01/07/2020 | 01/08/2020 | 01/09/2020 | 01/10/2020 | 01/11/2020 | 01/12/2020 | 01/01/2021 | 01/02/2021 | 01/03/2021 | 01/04/2021 | 01/05/2021 | 01/06/2021 | 01/07/2021 | 01/08/2021 | 01/09/2021 | 01/10/2021 | 01/11/2021
 | Material 1 | 7.6 | 4.9 | 101.3 | 8.2 |  | 52.56 | 49.04 | 51.92 | 44.6 | 15.08 | 5.38 |  |  | 53.84 | 27.22 |  | 11.22 | 8.18 | 77.24 |  | 183.18 | 239.22 | 15.48 |  | 7.6 | 4.9 | 101.3 | 8.2 |  | 52.56 | 49.04 | 51.92 | 44.6 | 15.08 | 5.38 |  |  | 53.84 | 20.02 | 15.9 |  |  |  |  | 14.58 | 74.2 |  |  |  |  | 68.26 |  | 59.84 | 13.66 | 93.92 | 69.86 | 17.4 |  | 13.84
 | Material 2
 | Material 3 |  | 4.46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.46
 | Material 4 |  |  |  |  | 36.48 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36.48
 | Material 5 |  |  |  |  |  |  |  |  |  |  |  | 29.42 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29.42
 | Material 6 |  | 195.14 | 60.88 | 61.76 | 62.06 | 30.38 | 163.58 | 99.78 | 30.18 | 97.28 | 35.16 |  |  | 201.28 |  |  |  |  |  |  |  |  | 61.34 |  |  | 195.14 | 60.88 | 61.76 | 62.06 | 30.38 | 163.58 | 99.78 | 30.18 | 97.28 | 35.16 |  |  | 201.28 |  |  |  |  |  |  |  |  |  | 92.92 | 79.58 |  | 147.82 |  | 72.3 | 159.36 | 61.82 | 36.5 | 65.98 | 64.96
 | Material 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 144.98
 | Material 8
 | Material 9 |  |  |  |  |  |  |  |  |  |  | 5.72 |  | 7.42 |  | 29.88 |  | 32.8 | 64.68 | 20.8 |  | 14.16 | 23 |  |  |  |  |  |  |  |  |  |  |  |  | 5.72 |  | 7.42 |  | 18.28 |  | 49.36 | 35.77999999999999 | 14.74000000000001 |  | 18.88 |  |  | 4.48 |  |  |  |  |  | 11.5 |  |  |  |  | 37.66
 | Material 10
 | Material 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14.48 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29.74 |  |  |  |  |  |  |  |  | 14.4
 | Material 12
 | Material 13 |  |  |  |  |  |  |  |  |  | 100.06 | 37.42 | 41.4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100.06 | 37.42 | 41.4
 | Material 32
 | Material 33
 | Material 34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.86
 | Material 35
 | Material 46 |  |  |  |  |  |  |  |  | 40.12 |  | 133.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40.12 |  | 133.1 |  |  |  | 93.32 |  |  | 93.56 |  |  |  |  |  |  |  |  | 89.94 | 222.44 |  |  | 47.16 |  |  |  | 61.4
 | Material 47 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30.3 | 33.66 |  |  |  |  |  |  | 59.68 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30.56 | 30.36 |  |  |  |  |  | 105.08 |  |  | 33.52 |  | 41.16 | 106.54 | 43.86 |  | 38.4 |  | 241.66 | 93.88 | 107.22
 | Material 48 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29.28 |  |  |  | 30.42 |  |  |  |  | 38.98 |  | 48.02 | 274.1 | 208.24 | 189.06 |  | 56.7
 | Material 49 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100.82 | 117.94
 | Material 410
 | Material 411
 | Material 412 |  |  |  |  |  |  |  |  |  | 44.96 |  |  | 145.08 |  |  |  | 154.72 | 292.7 | 62.24 |  |  |  | 56.3 |  |  |  |  |  |  |  |  |  |  | 44.96 |  |  | 145.08 |  |  |  | 56.6 | 171.98 |  |  |  |  |  | 117.84 |  | 56.6 | 60.28 |  | 257.48 | 55 | 64.68 |  | 117.4 | 52.66 | 51.12
 | Material 413 |  |  |  |  |  |  |  | 42.14 |  |  |  |  |  |  |  |  | 77.9 |  |  |  |  |  | 37.92 |  |  |  |  |  |  |  |  | 42.14 |  |  |  |  |  |  |  |  | 137.64 |  |  |  | 93.28 |  | 169.56 | 52.88 |  |  |  |  |  |  |  |  | 98.26 | 109.62 | 29.9
 | Material 414 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26.78 |  |  |  | 86.56 | 43.86 |  | 47.92
 | Material 415
 | Material 416
 | Material 417
 | Material 418
 | Material 419
 | Material 420
 | Material 521 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22.4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41.6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 250.88
 | Material 522
 | Material 523 |  |  |  |  |  |  |  |  |  |  | 210 |  |  |  | 119 | 187.6 | 122.76 |  |  |  |  |  | 44.52 |  |  |  |  |  |  |  |  |  |  |  | 210 |  |  |  | 93.58 | 131.66 | 66.2 |  |  |  |  |  | 72.28 |  | 88.6 |  |  |  | 586.74 |  |  |  |  | 86.34 | 47.92
 | Material 524
 | Material 525
 | Material 526 |  |  |  |  |  | 37.34 |  |  |  | 34.2 |  | 37.4 | 80.18 |  |  |  | 76.48 | 94.24 |  |  | 136.66 | 43.56 |  |  |  |  |  |  |  | 37.34 |  |  |  | 34.2 |  | 37.4 | 80.18 |  |  |  |  |  |  |  | 127.92 | 39.56 |  |  |  |  |  |  | 47.26
 | Material 527 | 45.7 |  |  |  |  |  |  |  |  |  |  |  |  | 48.78 |  |  |  | 89.66 |  |  |  |  |  |  | 45.7 |  |  |  |  |  |  |  |  |  |  |  |  | 48.78 | 43.96 |  | 39.16 | 100.08
 | Material 528 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 53.6
 | Material 529
 | Material 530
 | Material 531 |  | 278.74 | 225.24 |  | 66.68 | 128.12 |  |  | 168.22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 278.74 | 225.24 |  | 66.68 | 128.12 |  |  | 168.22
 | Material 532 |  |  | 33.46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33.46
 | Material 533 |  |  | 132.68 |  |  | 33.84 | 79.56 |  |  |  | 45.84 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 132.68 |  |  | 33.84 | 79.56 |  |  |  | 45.84
 | Material 534
 | Material 535 | 25.48 |  |  |  | 22.26 | 41.38 | 38.24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25.48 |  |  |  | 22.26 | 41.38 | 38.24
 | Material 536 | 80.38 | 35.84 |  | 64.82 | 47.84 | 51.12 | 71.58 | 46.26 | 68.06 | 37.88 | 63.02 | 62.42 | 64.48 | 91.08 | 71.12 | 43.46 | 58.02 | 53.12 | 66.74 |  |  | 34.32 | 58.96 | 63.5 | 80.38 | 35.84 |  | 64.82 | 47.84 | 51.12 | 71.58 | 46.26 | 68.06 | 37.88 | 63.02 | 62.42 | 64.48 | 91.08 | 47.84 | 44.54 | 41.62 | 62.04 | 41.06 |  |  | 54.16 | 60.9 | 57.56 | 40.28 | 60.4 | 68.72 | 37.46 | 63.64 | 58.26 | 58.98 | 35.82 | 48.94 | 54.72 | 59.28
 | Material 537 |  |  |  |  | 33.22 |  | 36.32 | 35.72 | 31.08 | 41.06 |  | 31.18 | 34.8 |  |  | 34.56 |  |  | 35.14 |  |  | 34.9 |  | 33.32 |  |  |  |  | 33.22 |  | 36.32 | 35.72 | 31.08 | 41.06 |  | 31.18 | 34.8 |  |  | 34.78 | 36.38 | 33.42 |  |  | 33.1 | 33.98 | 34.2 |  |  | 33.7 |  |  |  |  | 36.46 |  | 31.02
 | Material 538 | 30.3 | 21.26 | 27.24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30.3 | 21.26 | 27.24
 | Material 539
 | Material 540
 | Material 541
 | Material 542
 | Material 543
 | Material 645 | 56.02 | 27.86 |  |  |  |  |  |  |  |  |  |  |  | 24.08 |  |  |  |  | 64.16 |  |  |  |  |  | 56.02 | 27.86 |  |  |  |  |  |  |  |  |  |  |  | 24.08 |  |  |  |  |  |  |  |  |  |  | 27.7 |  | 52.1
 | Material 646 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 58.1
 | Material 647 | 144.02 | 20.7 | 35.16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 144.02 | 20.7 | 35.16
 | Material 648 |  |  |  | 89.32 | 25.26 | 89.56 | 118.8 | 107.48 | 32.94 | 47.24 | 68.18 |  |  | 89.62 |  |  |  |  |  |  |  |  |  |  |  |  |  | 89.32 | 25.26 | 89.56 | 118.8 | 107.48 | 32.94 | 47.24 | 68.18 |  |  | 89.62 |  |  |  |  |  |  | 110.9 | 31.08 | 98.36 |  | 66.4 |  |  | 132
 | Material 649 |  |  |  | 52.18 | 57.98 |  | 217.16 |  | 33.84 | 88.4 |  | 78.3 |  | 23.38 |  |  |  |  | 25.5 |  | 66.54 |  |  |  |  |  |  | 52.18 | 57.98 |  | 217.16 |  | 33.84 | 88.4 |  | 78.3 |  | 23.38 |  |  |  |  | 104.74 |  |  | 118.42 |  |  | 40.48 | 72.16 | 26.02 | 95.62 |  |  |  | 151.5 |  | 178.3 | 83.98
 | Material 650 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26.44 |  |  | 173.02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49.2 |  |  | 91.82 | 23.96
 | Material 651
 | Material 652
 | Material 653 | 31.96 | 90.5 | 61.6 | 101.48 | 140.06 | 73.94 | 255.7 |  | 29.36 | 120.06 | 204.54 | 142.92 |  |  |  |  |  |  |  |  | 144.8 | 63.06 | 33.74 |  | 31.96 | 90.5 | 61.6 | 101.48 | 140.06 | 73.94 | 255.7 |  | 29.36 | 120.06 | 204.54 | 142.92 |  |  |  |  |  |  |  |  | 190.58 | 206.18 |  |  |  |  |  |  | 47.94 | 217.5 | 155.58 | 60.52 | 33.38 |  | 35.52
 | Material 654
 | Material 855
 | Material 856