Spreadsheet: 731627d1620463937-create-dynamic-range-from-another-file-split-range
Sheet: Report

 |  | The Result |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | Diff
Date | Company | Truck | No1 | No2 | No3 | No4 | Quantity |  | Date | Company | Truck | No1 | No2 | No3 | No4 | Quantity |  | Date | Company | Truck | No1 | No2 | No3 | No4 | Quantity
2021-04-01 00:00:00 | Company1 | 6578, 7496 | 20.66 | 29.51 | 4398 |  | 37.46 |  |  |  | 6578, 7496
2021-04-01 00:00:00 | Company2 | 2951 | 20.21 | 32.35 | 4106 |  | 48.02 |  |  |  | 2951
2021-04-01 00:00:00 | Company3 | 2971 | 16.44 | 23.76 | 4484 |  | 26.78 |  |  |  | 2971
2021-04-01 00:00:00 | Company4 | 2473 | 18.26 | 30.33 | 4432 |  | 106.54 |  |  |  | 2473
2021-04-01 00:00:00 | Company4 | 7416 | 18.26 | 30.33 | 4432 |  | 106.54 |  |  |  | 7416
2021-04-01 00:00:00 | Company5 | 9241 | 22.75 | 31 | 4186 |  | 222.44 |  |  |  | 9241
2021-04-01 00:00:00 | Company5 | 8162 | 22.75 | 31 | 4186 |  | 222.44 |  |  |  | 8162
2021-04-01 00:00:00 | Company5 | 2493 | 22.75 | 31 | 4186 |  | 222.44 |  |  |  | 2493
2021-04-01 00:00:00 | Company5 | 3697 | 22.75 | 31 | 4186 |  | 222.44 |  |  |  | 3697
2021-04-02 00:00:00 | Company4 | 3724 | 20.51 | 29.65 | 4432 |  | 192.32 |  |  |  | 3724
2021-04-02 00:00:00 | Company4 | 1564 | 20.51 | 29.65 | 4432 |  | 192.32 |  |  |  | 1564
2021-04-02 00:00:00 | Company4 | 4571 | 20.51 | 29.65 | 4432 |  | 192.32 |  |  |  | 4571
2021-04-02 00:00:00 | Company4 | 8947 | 20.51 | 29.65 | 4432 |  | 192.32 |  |  |  | 8947
2021-04-02 00:00:00 | Company2 | 7415 | 18.85 | 34.31 | 4106 |  | 42 |  |  |  | 7415
2021-04-02 00:00:00 | Company6 | 5312 | 25.14 | 24 | 4596 |  | 42.14 |  |  |  | 5312
2021-04-02 00:00:00 | Company1 | 6578, 7496 | 20.39 | 30.15 | 4398 |  | 61.1 |  |  |  | 6578, 7496
2021-04-02 00:00:00 | Company7 | 1589 | 22.71 | 29.71 | 4411 |  | 33.04 |  |  |  | 1589
2021-04-03 00:00:00 | Company5 | 5761 | 21.87 | 31.39 | 4186 |  | 57.44 |  |  |  | 5761
2021-04-03 00:00:00 | Company3 | 8129 | 16 | 22.85 | 4484 |  | 75.74 |  |  |  | 8129
2021-04-03 00:00:00 | Company3 | 9481 | 16 | 22.85 | 4484 |  | 75.74 |  |  |  | 9481
2021-04-03 00:00:00 | Company1 | 6578, 7496 | 20.13 | 29.15 | 4398 |  | 36.4 |  |  |  | 6578, 7496
2021-04-04 00:00:00 | Company4 | 6741 | 20.41 | 30.45 | 4486 |  | 95.74 |  |  |  | 6741
2021-04-04 00:00:00 | Company4 | 7492 | 20.41 | 30.45 | 4486 |  | 95.74 |  |  |  | 7492
2021-04-04 00:00:00 | Company1 | 6578, 7496 | 21.77 | 30.18 | 4347 |  | 57.66 |  |  |  | 6578, 7496
2021-04-04 00:00:00 | Company7 | 1589 | 22.15 | 29.71 | 4466 |  | 33 |  |  |  | 1589
2021-04-05 00:00:00 | Company4 | 8524 | 19.61 | 30.45 | 4486 |  | 201.82 |  |  |  | 8524
2021-04-05 00:00:00 | Company4 | 9516 | 19.61 | 30.45 | 4486 |  | 201.82 |  |  |  | 9516
2021-04-05 00:00:00 | Company4 | 7416 | 19.61 | 30.45 | 4486 |  | 201.82 |  |  |  | 7416
2021-04-05 00:00:00 | Company4 | 2473 | 19.61 | 30.45 | 4486 |  | 201.82 |  |  |  | 2473
2021-04-05 00:00:00 | Company6 | 9423 | 23.21 | 23.31 | 4588 |  | 76.52 |  |  |  | 9423
2021-04-05 00:00:00 | Company6 | 9138 | 23.21 | 23.31 | 4588 |  | 76.52 |  |  |  | 9138
2021-04-05 00:00:00 | Company1 | 6578, 7496 | 20.17 | 29.55 | 4347 |  | 58.56 |  |  |  | 6578, 7496
2021-04-06 00:00:00 | Company4 | 1564 | 18.55 | 30.37 | 4486 |  | 94.5 |  |  |  | 1564
2021-04-06 00:00:00 | Company4 | 8126 | 18.55 | 30.37 | 4486 |  | 94.5 |  |  |  | 8126
2021-04-06 00:00:00 | Company6 | 5312 | 22.11 | 26.71 | 4588 |  | 40.88 |  |  |  | 5312
2021-04-06 00:00:00 | Company8 | 8462 | 20.89 | 29.79 | 4480 |  | 76.32 |  |  |  | 8462
2021-04-06 00:00:00 | Company8 | 3598 | 20.89 | 29.79 | 4480 |  | 76.32 |  |  |  | 3598
2021-04-06 00:00:00 | Company1 | 6578, 7496 | 20.31 | 28.22 | 4347 |  | 33.94 |  |  |  | 6578, 7496
2021-04-06 00:00:00 | Company7 | 1589 | 23.94 | 29.73 | 4466 |  | 36.4 |  |  |  | 1589
2021-04-07 00:00:00 | Company5 | 7981 | 20.16 | 31.44 | 4185 |  | 43.9 |  |  |  | 7981
2021-04-07 00:00:00 | Company4 | 6741 | 18.84 | 30.73 | 4387 |  | 100.1 |  |  |  | 6741
2021-04-07 00:00:00 | Company4 | 2951 | 18.84 | 30.73 | 4387 |  | 100.1 |  |  |  | 2951
2021-04-07 00:00:00 | Company2 | 3984 | 18.19 | 33.67 | 4056 |  | 49.62 |  |  |  | 3984
2021-04-07 00:00:00 | Company8 | 8462 | 17.71 | 28.31 | 4429 |  | 77.48 |  |  |  | 8462
2021-04-07 00:00:00 | Company8 | 3598 | 17.71 | 28.31 | 4429 |  | 77.48 |  |  |  | 3598
2021-04-07 00:00:00 | Company1 | 6578, 7496 | 19.55 | 28.77 | 4436 |  | 34.72 |  |  |  | 6578, 7496
2021-04-07 00:00:00 | Company7 | 1589 | 21.18 | 29.15 | 4352 |  | 35.84 |  |  |  | 1589
2021-04-07 00:00:00 | Company11 |  |  |  |  |  | 35.84
2021-04-06 00:00:00 | Company1 | 6578, 7496 | 20.31 | 28.22 | 4347 |  | 33.94 |  |  |  | 6578, 7496
2021-04-06 00:00:00 | Company7 | 1589 | 23.94 | 29.73 | 4466 |  | 36.4 |  |  |  | 1589
2021-04-07 00:00:00 | Company5 | 7981 | 20.16 | 31.44 | 4185 |  | 43.9 |  |  |  | 7981
2021-04-07 00:00:00 | Company4 | 6741 | 18.84 | 30.73 | 4387 |  | 100.1 |  |  |  | 6741
2021-04-07 00:00:00 | Company4 | 2951 | 18.84 | 30.73 | 4387 |  | 100.1 |  |  |  | 2951