Spreadsheet: 850703d1701094452-multiple-functions-to-resolve-price-book1_support
Sheet: Sheet1

 |  | Pallet intervals
From | From Zone | 0-3,5 | 3,5-6,5 | 6,5-10,5 | 10,5- | Fee
[NAME] | 1 | 136 | 87 | 71 | 59 | 70
[NAME] | 2 | 193 | 98 | 90 | 77 | 70
[NAME] | 3 | 236 | 106 | 100 | 84 | 70
[NAME] | 4 | 272 | 153 | 124 | 116 | 70
YearMonth | Date | Day | shipmentNo | SgeoNodeName | RgeoNodeName | RzipCode | Zone | Zone Price | Fee | Price Total | No of Pallets |  | Day | Sum of No of Pallets
 | 2022-12-19 00:00:00 | Monday |  |  | Hanry's | 72132 | 2 |  |  |  | 30 |  | 2022 | 214.5
 | 2023-06-12 00:00:00 | Monday |  |  | Heidis | 64547 | 3 |  |  |  | 26.5 |  | Sep | 16.5
 | 2023-01-30 00:00:00 | Monday |  |  | [NAME] | 64547 | 3 |  |  |  | 26 |  | Wednesday | 16.5
 | 2023-03-27 00:00:00 | Monday |  |  | Hanry's | 72132 | 2 |  |  |  | 25 |  | 2022-09-28 00:00:00 | 16.5
 | 2023-06-05 00:00:00 | Monday |  |  | Hanry's | 64547 | 3 |  |  |  | 25 |  | Oct | 15
 | 2022-12-19 00:00:00 | Monday |  |  | Hanry's | 72138 | 2 |  |  |  | 22 |  | Wednesday | 15
 | 2023-06-17 00:00:00 | Saturday |  |  | Hanry's | 72138 | 2 |  |  |  | 21 |  | 2022-10-05 00:00:00 | 15
 | 2023-02-22 00:00:00 | Wednesday |  |  | Hanry's | 74940 | 3 |  |  |  | 20 |  | Nov | 19.5
 | 2023-04-03 00:00:00 | Monday |  |  | [NAME] | 72132 | 2 |  |  |  | 20 |  | Wednesday | 19.5
 | 2023-05-24 00:00:00 | Wednesday |  |  | [NAME] | 64547 | 3 |  |  |  | 20 |  | 2022-11-23 00:00:00 | 19.5
 | 2023-05-29 00:00:00 | Monday |  |  | [NAME] | 72132 | 2 |  |  |  | 20 |  | Dec | 163.5
 | 2022-11-23 00:00:00 | Wednesday |  |  | [NAME] | 64547 | 3 |  |  |  | 19.5 |  | Monday | 52
 | 2023-05-30 00:00:00 | Tuesday |  |  | [NAME] | 63222 | 1 |  |  |  | 19.5 |  | 2022-12-19 00:00:00 | 52
 | 2023-05-17 00:00:00 | Wednesday |  |  | [NAME] | 64547 | 3 |  |  |  | 18.5 |  | Tuesday | 32
 | 2023-06-17 00:00:00 | Saturday |  |  | Hanry's | 72134 | 2 |  |  |  | 18.5 |  | 2022-12-20 00:00:00 | 18
 | 2022-12-20 00:00:00 | Tuesday |  |  | Hanry's | 63222 | 1 |  |  |  | 18 |  | 2022-12-27 00:00:00 | 14
 | 2022-12-29 00:00:00 | Thursday |  |  | Hanry's | 72136 | 2 |  |  |  | 18 |  | Wednesday | 17
 | 2023-04-19 00:00:00 | Wednesday |  |  | Hanry's | 64591 | 3 |  |  |  | 18 |  | 2022-12-07 00:00:00 | 17
 | 2023-06-17 00:00:00 | Saturday |  |  | Hanry's | 72134 | 2 |  |  |  | 18 |  | Thursday | 48
 | 2022-12-07 00:00:00 | Wednesday |  |  | Hanry's | 64547 | 3 |  |  |  | 17 |  | 2022-12-22 00:00:00 | 15
 | 2023-06-12 00:00:00 | Monday |  |  | Hanry's | 72132 | 2 |  |  |  | 17 |  | 2022-12-29 00:00:00 | 33
 | 2022-09-28 00:00:00 | Wednesday |  |  | Hanry's | 64547 | 3 |  |  |  | 16.5 |  | Friday | 14.5
 | 2023-05-08 00:00:00 | Monday |  |  | Hanry's | 64547 | 3 |  |  |  | 16.5 |  | 2022-12-16 00:00:00 | 14.5
 | 2023-04-24 00:00:00 | Monday |  |  | Hanry's | 72132 | 2 |  |  |  | 16 |  | 2023 | 468.5
 | 2023-05-31 00:00:00 | Wednesday |  |  | Hanry's | 64547 | 3 |  |  |  | 16 |  | Jan | 26
 | 2023-06-09 00:00:00 | Friday |  |  | Hanry's | 63222 | 1 |  |  |  | 16 |  | Monday | 26
 | 2023-06-26 00:00:00 | Monday |  |  | Heidis | 72132 | 2 |  |  |  | 16 |  | 2023-01-30 00:00:00 | 26
 | 2023-05-16 00:00:00 | Tuesday |  |  | Heidis | 63222 | 1 |  |  |  | 15.5 |  | Feb | 20
 | 2022-10-05 00:00:00 | Wednesday |  |  | Heidis | 64547 | 3 |  |  |  | 15 |  | Wednesday | 20
 | 2022-12-22 00:00:00 | Thursday |  |  | Heidis | 72134 | 2 |  |  |  | 15 |  | 2023-02-22 00:00:00 | 20
 | 2022-12-29 00:00:00 | Thursday |  |  | Heidis | 72134 | 2 |  |  |  | 15 |  | Mar | 25
 | 2023-04-26 00:00:00 | Wednesday |  |  | Hanry's | 74940 | 3 |  |  |  | 15 |  | Monday | 25
 | 2023-06-05 00:00:00 | Monday |  |  | Hanry's | 64547 | 3 |  |  |  | 15 |  | 2023-03-27 00:00:00 | 25
 | 2023-07-25 00:00:00 | Tuesday |  |  | Hanry's | 63222 | 1 |  |  |  | 15 |  | Apr | 83.5
 | 2022-12-16 00:00:00 | Friday |  |  | Heidis | 63222 | 1 |  |  |  | 14.5 |  | Monday | 50.5
 | 2023-04-24 00:00:00 | Monday |  |  | Heidis | 64547 | 3 |  |  |  | 14.5 |  | 2023-04-03 00:00:00 | 20
 | 2022-12-27 00:00:00 | Tuesday |  |  | Heidis | 63222 | 1 |  |  |  | 14 |  | 2023-04-24 00:00:00 | 30.5
 |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday | 33
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-04-19 00:00:00 | 18
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-04-26 00:00:00 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | May | 126
 |  |  |  |  |  |  |  |  |  |  |  |  | Monday | 36.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-05-08 00:00:00 | 16.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-05-29 00:00:00 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday | 35
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-05-16 00:00:00 | 15.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-05-30 00:00:00 | 19.5
 |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday | 54.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-05-17 00:00:00 | 18.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-05-24 00:00:00 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-05-31 00:00:00 | 16
 |  |  |  |  |  |  |  |  |  |  |  |  | Jun | 173
 |  |  |  |  |  |  |  |  |  |  |  |  | Monday | 99.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-06-05 00:00:00 | 40
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-06-12 00:00:00 | 43.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-06-26 00:00:00 | 16
 |  |  |  |  |  |  |  |  |  |  |  |  | Friday | 16
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-06-09 00:00:00 | 16
 |  |  |  |  |  |  |  |  |  |  |  |  | Saturday | 57.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-06-17 00:00:00 | 57.5
 |  |  |  |  |  |  |  |  |  |  |  |  | Jul | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-07-25 00:00:00 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 683