Spreadsheet: 851069d1701328215-getting-price-using-3-reference-points-test
Sheet: Price

A - 24 Hour
Zone | Micro Pallet | [NAME] | Half Pallet | Full Pallet 1 | Full Pallet 2 | Full Pallet 3 | Full Pallet 4 | Full Pallet 5 | Full Pallet 6 | Full Pallet 7 | Full Pallet 8 | Full Pallet 9 | Full Pallet 10 | Full Pallet 11 | Full Pallet 12 | Full Pallet 13 | [NAME] 14 | Full Pallet 15
Zone A | 24.01 | 25.26 | 26.5 | 27.75 | 53.28 | 75.4 | 96.88 | 111.01 | 121.1 | 129.51 | 136.62 | 146.2 | 153.11 | 162.81 | 171.88 | 182.28 | 190.29 | 199.81
Zone B | 35.83 | 38.19 | 41.75 | 44.62 | 85.16 | 116.3 | 145.72 | 157.09 | 170.85 | 179.87 | 167.29 | 179.02 | 187.47 | 199.35 | 210.46 | 223.19 | 233 | 244.65
Zone C | 38.41 | 40.58 | 44.14 | 48.89 | 96.59 | 143.1 | 188.43 | 232.57 | 269.6 | 295.72 | 314.25 | 336.04 | 355.8 | 357.16 | 377.06 | 399.88 | 417.46 | 438.33
Zone D | 40.08 | 42.44 | 46 | 50.75 | 100.31 | 148.68 | 195.87 | 241.87 | 286.68 | 330.31 | 372.75 | 413.76 | 437.38 | 460.65 | 486.31 | 515.75 | 538.42 | 565.34
Zone E | 42.32 | 44.93 | 49.67 | 54.42 | 107.65 | 159.69 | 210.55 | 260.22 | 308.71 | 356 | 402.12 | 447.04 | 490.78 | 539.86 | 588.94 | 637.83 | 665.86 | 699.15
Zone F | 45.5 | 48.46 | 52.02 | 56.77 | 112.34 | 166.74 | 219.94 | 271.96 | 322.8 | 372.45 | 420.91 | 468.18 | 514.27 | 565.7 | 617.13 | 668.55 | 719.98 | 771.41
Zone G | 45.76 | 52.09 | 55.65 | 60.99 | 120.79 | 179.4 | 236.83 | 293.07 | 348.13 | 401.99 | 454.68 | 506.17 | 556.48 | 612.13 | 667.78 | 723.43 | 779.08 | 834.73
Zone H | 57.91 | 62.25 | 65.81 | 69.37 | 137.55 | 204.54 | 270.35 | 334.97 | 398.4 | 460.65 | 521.71 | 580.86 | 634.84 | 642.27 | 678.05 | 719.09 | 750.7 | 788.24
B - 48 Hour
Zone | Micro Pallet | [NAME] | Half Pallet | Full Pallet 1 | Full Pallet 2 | Full Pallet 3 | Full Pallet 4 | Full Pallet 5 | Full Pallet 6 | Full Pallet 7 | Full Pallet 8 | Full Pallet 9 | Full Pallet 10 | Full Pallet 11 | Full Pallet 12 | Full Pallet 13 | [NAME] 14 | Full Pallet 15
Zone A | 22.84 | 24.02 | 25.21 | 26.39 | 50.68 | 71.71 | 92.14 | 105.58 | 115.17 | 123.17 | 129.94 | 139.05 | 145.62 | 147.1 | 155.3 | 164.7 | 171.94 | 180.54
Zone B | 33.69 | 35.82 | 38.19 | 39.57 | 76.26 | 106.51 | 135.05 | 149.67 | 163.73 | 173.64 | 167.29 | 179.02 | 187.47 | 189.38 | 199.93 | 212.03 | 221.35 | 232.42
Zone C | 33.63 | 35.5 | 37.88 | 40.25 | 79.31 | 117.19 | 153.88 | 189.39 | 223.71 | 256.84 | 288.78 | 319.54 | 338.53 | 338.3 | 358.21 | 379.89 | 396.59 | 416.41
Zone D | 35.83 | 37.96 | 40.33 | 42.7 | 84.22 | 124.55 | 163.69 | 201.65 | 238.42 | 274.01 | 308.4 | 341.62 | 373.64 | 411.01 | 448.37 | 485.73 | 551.5 | 537.07
Zone E | 38.07 | 40.44 | 42.81 | 45.19 | 89.19 | 132 | 173.63 | 214.07 | 253.33 | 291.4 | 328.28 | 363.98 | 398.49 | 438.34 | 478.18 | 518.03 | 557.88 | 597.73
Zone F | 41.25 | 43.98 | 46.35 | 48.72 | 96.26 | 142.61 | 187.77 | 231.75 | 274.54 | 316.14 | 356.56 | 395.79 | 433.84 | 477.22 | 520.61 | 563.99 | 607.38 | 650.76
Zone G | 44.52 | 47.61 | 49.98 | 52.35 | 103.51 | 153.49 | 202.28 | 249.89 | 296.51 | 341.54 | 385.59 | 428.45 | 470.12 | 517.13 | 564.14 | 611.16 | 658.17 | 705.18
Zone H | 49.92 | 53.61 | 55.98 | 58.36 | 115.53 | 171.51 | 226.31 | 279.92 | 332.25 | 383.59 | 433.64 | 482.51 | 530.19 | 583.21 | 636.22 | 683.14 | 713.17 | 748.82
Zone I | 56.84 | 58.95 | 61.32 | 63.7 | 126.2 | 187.53 | 247.66 | 306.61 | 364.38 | 420.96 | 476.35 | 530.55 | 583.57 | POA | POA | POA | POA | POA
Zone J | 50.65 | 54.42 | 56.79 | 60.31 | 119.33 | 177.49 | 234.28 | 289.89 | 344.31 | 397.54 | 449.58 | 500.44 | 550.12 | POA | POA | POA | POA | POA
Zone K | 67.28 | 72.81 | 76.55 | 82.79 | 164.32 | 244.62 | 323.66 | 401.46 | 478.01 | 553.31 | 627.36 | 700.17 | 771.73 | POA | POA | POA | POA | POA
Zone L | 86.32 | 93.85 | 97.13 | 100.42 | 195.58 | 285.49 | 370.13 | 449.51 | 523.64 | 592.5 | 656.11 | 714.45 | 767.54 | POA | POA | POA | POA | POA
Zone M | 147.55 | 147.55 | 147.55 | 147.55 | 289.1 | 433.64 | 578.19 | 722.74 | POA | POA | POA | POA | POA | POA | POA | POA | POA | POA
Zone N | 103.05 | 103.05 | 103.05 | 103.05 | 206.1 | 309.16 | 412.21 | 515.26 | POA | POA | POA | POA | POA | POA | POA | POA | POA | POA
Zone O | 118.17 | 118.17 | 118.17 | 118.17 | 236.35 | 354.52 | 472.69 | 590.87 | POA | POA | POA | POA | POA | POA | POA | POA | POA | POA
Zone P | 107.62 | 107.62 | 107.62 | 107.62 | 215.23 | 322.85 | 430.47 | 538.09 | POA | POA | POA | POA | POA | POA | POA | POA | POA | POA
Zone Q | 159.89 | 159.89 | 159.89 | 159.89 | 319.78 | 479.68 | 639.57 | 799.46 | POA | POA | POA | POA | POA | POA | POA | POA | POA | POA
Zone R | 282.55 | 282.55 | 282.55 | 282.55 | 565.09 | 847.64 | 1130.19 | 1412.73 | POA | POA | POA | POA | POA | POA | POA | POA | POA | POA
Zone S | 170.63 | 170.63 | 170.63 | 170.63 | 341.27 | 511.9 | 682.54 | 853.17 | POA | POA | POA | POA | POA | POA | POA | POA | POA | POA
Zone W | 67.72 | 67.72 | 67.72 | 67.72 | 135.45 | 203.17 | 270.89 | 338.62 | 406.34 | 474.06 | 541.79 | 609.51 | 677.24 | POA | POA | POA | POA | POA
Zone X | 70.79 | 70.79 | 70.79 | 70.79 | 141.58 | 212.37 | 283.16 | 353.95 | 424.75 | 495.54 | 566.33 | 637.12 | 707.91 | POA | POA | POA | POA | POA
Zone Y | 77.68 | 77.68 | 77.68 | 77.68 | 155.36 | 233.03 | 310.71 | 388.39 | 466.07 | 543.75 | 621.42 | 699.1 | 776.78 | POA | POA | POA | POA | POA
Zone Z | 100.37 | 100.37 | 100.37 | 100.37 | 200.75 | 301.12 | 401.5 | 501.87 | 602.25 | 702.62 | 803 | 903.37 | 1003.75 | POA | POA | POA | POA | POA