Spreadsheet: 850707d1701097720-multiple-functions-to-resolve-price-book1_support
Sheet: Sheet1

 |  | Pallet intervals
From | From Zone | 0 | 3.5 | 6.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 | Average of No of Pallets
 | 2022-12-19 00:00:00 | Monday |  |  | Hanry's | 72132 | 2 |  |  |  | 30 |  | 2022 | 214.5 | 17.875
 | 2023-06-12 00:00:00 | Monday |  |  | Heidis | 64547 | 3 |  |  |  | 26.5 |  | Sep | 16.5 | 16.5
 | 2023-01-30 00:00:00 | Monday |  |  | [NAME] | 64547 | 3 |  |  |  | 26 |  | Wednesday | 16.5 | 16.5
 | 2023-03-27 00:00:00 | Monday |  |  | Hanry's | 72132 | 2 |  |  |  | 25 |  | 2022-09-28 00:00:00 | 16.5 | 16.5
 | 2023-06-05 00:00:00 | Monday |  |  | Hanry's | 64547 | 3 |  |  |  | 25 |  | Oct | 15 | 15
 | 2022-12-19 00:00:00 | Monday |  |  | Hanry's | 72138 | 2 |  |  |  | 22 |  | Wednesday | 15 | 15
 | 2023-06-17 00:00:00 | Saturday |  |  | Hanry's | 72138 | 2 |  |  |  | 21 |  | 2022-10-05 00:00:00 | 15 | 15
 | 2023-02-22 00:00:00 | Wednesday |  |  | Hanry's | 74940 | 3 |  |  |  | 20 |  | Nov | 19.5 | 19.5
 | 2023-04-03 00:00:00 | Monday |  |  | [NAME] | 72132 | 2 |  |  |  | 20 |  | Wednesday | 19.5 | 19.5
 | 2023-05-24 00:00:00 | Wednesday |  |  | [NAME] | 64547 | 3 |  |  |  | 20 |  | 2022-11-23 00:00:00 | 19.5 | 19.5
 | 2023-05-29 00:00:00 | Monday |  |  | [NAME] | 72132 | 2 |  |  |  | 20 |  | Dec | 163.5 | 18.16666666666667
 | 2022-11-23 00:00:00 | Wednesday |  |  | [NAME] | 64547 | 3 |  |  |  | 19.5 |  | Monday | 52 | 26
 | 2023-05-30 00:00:00 | Tuesday |  |  | [NAME] | 63222 | 1 |  |  |  | 19.5 |  | 2022-12-19 00:00:00 | 52 | 26
 | 2023-05-17 00:00:00 | Wednesday |  |  | [NAME] | 64547 | 3 |  |  |  | 18.5 |  | Tuesday | 32 | 16
 | 2023-06-17 00:00:00 | Saturday |  |  | Hanry's | 72134 | 2 |  |  |  | 18.5 |  | 2022-12-20 00:00:00 | 18 | 18
 | 2022-12-20 00:00:00 | Tuesday |  |  | Hanry's | 63222 | 1 |  |  |  | 18 |  | 2022-12-27 00:00:00 | 14 | 14
 | 2022-12-29 00:00:00 | Thursday |  |  | Hanry's | 72136 | 2 |  |  |  | 18 |  | Wednesday | 17 | 17
 | 2023-04-19 00:00:00 | Wednesday |  |  | Hanry's | 64591 | 3 |  |  |  | 18 |  | 2022-12-07 00:00:00 | 17 | 17
 | 2023-06-17 00:00:00 | Saturday |  |  | Hanry's | 72134 | 2 |  |  |  | 18 |  | Thursday | 48 | 16
 | 2022-12-07 00:00:00 | Wednesday |  |  | Hanry's | 64547 | 3 |  |  |  | 17 |  | 2022-12-22 00:00:00 | 15 | 15
 | 2023-06-12 00:00:00 | Monday |  |  | Hanry's | 72132 | 2 |  |  |  | 17 |  | 2022-12-29 00:00:00 | 33 | 16.5
 | 2022-09-28 00:00:00 | Wednesday |  |  | Hanry's | 64547 | 3 |  |  |  | 16.5 |  | Friday | 14.5 | 14.5
 | 2023-05-08 00:00:00 | Monday |  |  | Hanry's | 64547 | 3 |  |  |  | 16.5 |  | 2022-12-16 00:00:00 | 14.5 | 14.5
 | 2023-04-24 00:00:00 | Monday |  |  | Hanry's | 72132 | 2 |  |  |  | 16 |  | 2023 | 468.5 | 18.74
 | 2023-05-31 00:00:00 | Wednesday |  |  | Hanry's | 64547 | 3 |  |  |  | 16 |  | Jan | 26 | 26
 | 2023-06-09 00:00:00 | Friday |  |  | Hanry's | 63222 | 1 |  |  |  | 16 |  | Monday | 26 | 26
 | 2023-06-26 00:00:00 | Monday |  |  | Heidis | 72132 | 2 |  |  |  | 16 |  | 2023-01-30 00:00:00 | 26 | 26
 | 2023-05-16 00:00:00 | Tuesday |  |  | Heidis | 63222 | 1 |  |  |  | 15.5 |  | Feb | 20 | 20
 | 2022-10-05 00:00:00 | Wednesday |  |  | Heidis | 64547 | 3 |  |  |  | 15 |  | Wednesday | 20 | 20
 | 2022-12-22 00:00:00 | Thursday |  |  | Heidis | 72134 | 2 |  |  |  | 15 |  | 2023-02-22 00:00:00 | 20 | 20
 | 2022-12-29 00:00:00 | Thursday |  |  | Heidis | 72134 | 2 |  |  |  | 15 |  | Mar | 25 | 25
 | 2023-04-26 00:00:00 | Wednesday |  |  | Hanry's | 74940 | 3 |  |  |  | 15 |  | Monday | 25 | 25
 | 2023-06-05 00:00:00 | Monday |  |  | Hanry's | 64547 | 3 |  |  |  | 15 |  | 2023-03-27 00:00:00 | 25 | 25
 | 2023-07-25 00:00:00 | Tuesday |  |  | Hanry's | 63222 | 1 |  |  |  | 15 |  | Apr | 83.5 | 16.7
 | 2022-12-16 00:00:00 | Friday |  |  | Heidis | 63222 | 1 |  |  |  | 14.5 |  | Monday | 50.5 | 16.83333333333333
 | 2023-04-24 00:00:00 | Monday |  |  | Heidis | 64547 | 3 |  |  |  | 14.5 |  | 2023-04-03 00:00:00 | 20 | 20
 | 2022-12-27 00:00:00 | Tuesday |  |  | Heidis | 63222 | 1 |  |  |  | 14 |  | 2023-04-24 00:00:00 | 30.5 | 15.25
 |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday | 33 | 16.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-04-19 00:00:00 | 18 | 18
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-04-26 00:00:00 | 15 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | May | 126 | 18
 |  |  |  |  |  |  |  |  |  |  |  |  | Monday | 36.5 | 18.25
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-05-08 00:00:00 | 16.5 | 16.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-05-29 00:00:00 | 20 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday | 35 | 17.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-05-16 00:00:00 | 15.5 | 15.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-05-30 00:00:00 | 19.5 | 19.5
 |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday | 54.5 | 18.16666666666667
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-05-17 00:00:00 | 18.5 | 18.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-05-24 00:00:00 | 20 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-05-31 00:00:00 | 16 | 16
 |  |  |  |  |  |  |  |  |  |  |  |  | Jun | 173 | 19.22222222222222
 |  |  |  |  |  |  |  |  |  |  |  |  | Monday | 99.5 | 19.9
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-06-05 00:00:00 | 40 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-06-12 00:00:00 | 43.5 | 21.75
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-06-26 00:00:00 | 16 | 16
 |  |  |  |  |  |  |  |  |  |  |  |  | Friday | 16 | 16
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-06-09 00:00:00 | 16 | 16
 |  |  |  |  |  |  |  |  |  |  |  |  | Saturday | 57.5 | 19.16666666666667
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-06-17 00:00:00 | 57.5 | 19.16666666666667
 |  |  |  |  |  |  |  |  |  |  |  |  | Jul | 15 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday | 15 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-07-25 00:00:00 | 15 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 683 | 18.45945945945946