Spreadsheet: 886070d1736052306-sum-or-filter-question-testfile
Sheet: Weights-CBM

Compare Weight & CBM |  |  |  |  | Job-1: | 1 | Job-2: | 2 | Job-3: | 3 | Job-4: | 4
Compare-1:
 | Client-1 | 1 | Barcelona | NY | Boston | 1-pallet | 68 | 0.315 | LCL | 0 | AGT-1 | 604 | CMA | 0 | 0 | 0 | 0 | 132 | 0 | 38.45 | 140.56 | 7.14 | 0 | 4.14 | 0 | 103.69 | 88.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 53.02 | 0 | 0 | 0 | 0 | 0 | 35.82 | 0 | 0 | 0 | 0 | 1.08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | CoLoad-1 | 270 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 0 | 0 | 0 | 25 | 0 | 0 | 0 | 0 | 0 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35 | 0 | 15 | 0 | 0 | 10 | 0 | 0 | 0 | 35 | 0 | 45 | 0 | 0 | [NAME] | 191.5 | 191.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Compare-2:
 | Client-1 | 2 | Barcelona | NY | Boston | 1-pkg | 92 | 0.24 | LCL | 0 | AGT-1 | 578.87 | ZIM | 0 | 0 | 0 | 0 | 116 | 0 | 38.04 | 139.06 | 7.06 | 0 | 4.1 | 0 | 102.59 | 87.16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 52.46 | 0 | 0 | 0 | 0 | 0 | 30.86 | 0 | 0 | 0 | 0 | 1.54 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | CoLoad-1 | 270 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 0 | 0 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35 | 0 | 15 | 0 | 0 | 10 | 0 | 0 | 0 | 35 | 0 | 45 | 0 | 0 | [NAME] | 191.5 | 191.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Compare-3:
 | Client-1 | 3 | Barcelona | NY | Boston | 9-box | 2136 | 2.458 | LCL | 0 | AGT-2 | 1016.48 | ZIM | 0 | 0 | 0 | 0 | 285.13 | 0 | 37.32 | 136.44 | 6.93 | 0 | 0 | 12.06 | 100.65 | 85.52 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 154.4 | 0 | 0 | 0 | 0 | 0 | 188.6 | 0 | 0 | 0 | 0 | 9.43 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | CoLoad-1 | 294.84 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 61.45 | 0 | 0 | 30.73 | 0 | 0 | 0 | 0 | 0 | 0 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35 | 0 | 15 | 0 | 0 | 17.66 | 0 | 0 | 35 | 0 | 0 | 45 | 0 | 0 | [NAME] | 293.09 | 293.09 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Compare-4:
 | Client-1 | 4 | Barcelona | NY | Boston | 5-box | 1735 | 2.021 | LCL | 0 | AGT-2 | 902.24 | ZIM | 0 | 0 | 0 | 0 | 234.44 | 0 | 36.88 | 134.81 | 6.84 | 0 | 7.95 | 0 | 99.45 | 84.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 101.71 | 0 | 0 | 0 | 0 | 0 | 186.34 | 0 | 0 | 0 | 0 | 9.32 | 0 | 0 | 0 | 0 | 4 | 5 | 6 | 0 | 0 | 0 | 0 | CoLoad-1 | 275.13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50.53 | 0 | 0 | 25.26 | 0 | 0 | 0 | 0 | 0 | 0 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35 | 0 | 15 | 0 | 0 | 14.34 | 0 | 0 | 0 | 35 | 0 | 45 | 0 | 0 | [NAME] | 259.94 | 259.94 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Client-1 | 1 | Barcelona | NY | Boston | 1-pallet | 68 | 0.315 | LCL | 0 | AGT-1 | 604 | CMA | 0 | 0 | 0 | 0 | 132 | 0 | 38.45 | 140.56 | 7.14 | 0 | 4.14 | 0 | 103.69 | 88.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 53.02 | 0 | 0 | 0 | 0 | 0 | 35.82 | 0 | 0 | 0 | 0 | 1.08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | CoLoad-1 | 270 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 0 | 0 | 0 | 25 | 0 | 0 | 0 | 0 | 0 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35 | 0 | 15 | 0 | 0 | 10 | 0 | 0 | 0 | 35 | 0 | 45 | 0 | 0 | [NAME] | 191.5 | 191.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Client-1 | 1 | Barcelona | NY | Boston | 1-pallet | 68 | 0.315 | LCL | 0 | AGT-1 | 0 | 0 | 0 | 0 | 132 | 0 | 38.45 | 140.56 | 7.14 | 0 | 4.14 | 0 | 103.69 | 88.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 53.02 | 0 | 0 | 0 | 0 | 0 | 35.82 | 0 | 0 | 0 | 0 | 1.08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 604 | 0 | CMA | 0 | 0 | 0 | CoLoad-1 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 0 | 0 | 0 | 25 | 0 | 0 | 0 | 0 | 0 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35 | 0 | 15 | 0 | 0 | 10 | 0 | 0 | 0 | 35 | 0 | 45 | 0 | 270 | 0 | [NAME] | 191.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 191.5
45204 | Client-1 | 5 | Barcelona | NY | Boston | 1-box | 72 | 0.15 | LCL | 0 | AGT-3 | 0 | 0 | 0 | 0 | 116 | 0 | 36.88 | 134.81 | 6.84 | 0 | 3.97 | 0 | 99.45 | 84.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50.85 | 0 | 0 | 0 | 0 | 0 | 57.17 | 0 | 0 | 0 | 0 | 2.86 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 593.33 | 0 | ZIM | 0 | 0 | 0 | CoLoad-1 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 0 | 0 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35 | 0 | 15 | 0 | 0 | 10 | 0 | 0 | 0 | 35 | 0 | 45 | 0 | 270 | 0 | [NAME] | 191.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 191.5
45142 | Client-2 | 10 | Shanghai | NY | Boston | 1-pallet | 84 | 0.5 | LCL | 0 | AGT-2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Ever | 0 | 0 | 0 | CoLoad-3 | 0 | 0 | 35 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 511.5 | 0 | CFS-2 | 0 | 0 | 0 | 0 | 0 | 0 | 255 | 0 | 0 | 0 | 70 | 0 | 0 | 0 | 0 | 0 | 0 | 325
45184 | Client-1 | 2 | Barcelona | NY | Boston | 1-pkg | 92 | 0.24 | LCL | 0 | AGT-1 | 0 | 0 | 0 | 0 | 116 | 0 | 38.04 | 139.06 | 7.06 | 0 | 4.1 | 0 | 102.59 | 87.16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 52.46 | 0 | 0 | 0 | 0 | 0 | 30.86 | 0 | 0 | 0 | 0 | 1.54 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 578.87 | 0 | ZIM | 0 | 0 | 0 | CoLoad-1 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 0 | 0 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35 | 0 | 15 | 0 | 0 | 10 | 0 | 0 | 0 | 35 | 0 | 45 | 0 | 270 | 0 | [NAME] | 191.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 191.5
45216 | Client-1 | 6 | Barcelona | NY | Boston | 1-box | 103 | 0.17 | LCL | 0 | AGT-3 | 0 | 0 | 0 | 0 | 110 | 0 | 37.11 | 135.68 | 6.89 | 0 | 4 | 0 | 100.09 | 85.04 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 51.18 | 0 | 0 | 0 | 0 | 0 | 75.87 | 0 | 0 | 0 | 0 | 6.07 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 611.93 | 0 | ZIM | 0 | 0 | 0 | CoLoad-1 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 0 | 0 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35 | 0 | 15 | 0 | 0 | 10 | 0 | 0 | 0 | 35 | 0 | 45 | 0 | 270 | 0 | [NAME] | 191.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 191.5
45133 | Client-2 | 9 | qingdao | NY | Boston | 1-pallet/ 24-bags | 630 | 1 | LCL | 0 | AGT-1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Ever | 0 | 0 | 0 | CoLoad-2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30 | 0 | 0 | 50 | 0 | 0 | 0 | 0 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34.72 | 12.15 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 25 | 10 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 266.87 | 0 | CFS-2 | 255 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 255
45218 | Client-1 | 7 | [NAME] | NY | Boston | 5-box | 1310 | 1.53 | LCL | 0 | AGT-4 | 0 | 0 | 0 | 0 | 219.82 | 0 | 37.11 | 85.63 | 6.57 | 0 | 8 | 0 | 85.04 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 75.7 | 0 | 0 | 0 | 0 | 0 | 125.23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 643.1 | 0 | ZIM | 0 | 0 | 0 | CoLoad-1 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 0 | 0 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35 | 0 | 15 | 0 | 0 | 10.83 | 0 | 0 | 0 | 35 | 0 | 45 | 0 | 270.83 | 0 | [NAME] | 224.8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 224.8
45203 | Client-1 | 4 | Barcelona | NY | Boston | 5-box | 1735 | 2.021 | LCL | 0 | AGT-2 | 0 | 0 | 0 | 0 | 234.44 | 0 | 36.88 | 134.81 | 6.84 | 0 | 7.95 | 0 | 99.45 | 84.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 101.71 | 0 | 0 | 0 | 0 | 0 | 186.34 | 0 | 0 | 0 | 0 | 9.32 | 0 | 0 | 0 | 0 | 4 | 5 | 6 | 0 | 0 | 0 | 902.24 | 0 | ZIM | 0 | 0 | 0 | CoLoad-1 | 0 | 0 | 0 | 0 | 0 | 0 | 50.53 | 0 | 0 | 25.26 | 0 | 0 | 0 | 0 | 0 | 0 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35 | 0 | 15 | 0 | 0 | 14.34 | 0 | 0 | 0 | 35 | 0 | 45 | 0 | 275.13 | 0 | [NAME] | 259.94 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 259.94
45195 | Client-1 | 3 | Barcelona | NY | Boston | 9-box | 2136 | 2.458 | LCL | 0 | AGT-2 | 0 | 0 | 0 | 0 | 285.13 | 0 | 37.32 | 136.44 | 6.93 | 0 | 0 | 12.06 | 100.65 | 85.52 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 154.4 | 0 | 0 | 0 | 0 | 0 | 188.6 | 0 | 0 | 0 | 0 | 9.43 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1016.48 | 0 | ZIM | 0 | 0 | 0 | CoLoad-1 | 0 | 0 | 0 | 0 | 0 | 0 | 61.45 | 0 | 0 | 30.73 | 0 | 0 | 0 | 0 | 0 | 0 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35 | 0 | 15 | 0 | 0 | 17.66 | 0 | 0 | 35 | 0 | 0 | 45 | 0 | 294.84 | 0 | [NAME] | 293.09 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 293.09
45225 | Client-1 | 8 | [NAME] | NY | Boston | 5 | 2170 | 1.94 | LCL | 0 | AGT-4 | 0 | 0 | 0 | 0 | 258.03 | 0 | 36.95 | 85.26 | 6.55 | 0 | 0 | 11.95 | 84.68 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 113.06 | 0 | 0 | 0 | 0 | 0 | 175.97 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 772.45 | 0 | ZIM | 0 | 0 | 0 | CoLoad-1 | 0 | 0 | 0 | 0 | 0 | 0 | 54.25 | 0 | 0 | 27.13 | 0 | 0 | 0 | 0 | 0 | 0 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35 | 0 | 15 | 0 | 0 | 17.94 | 0 | 0 | 0 | 35 | 0 | 45 | 0 | 284.32 | 0 | [NAME] | 295.9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 295.9
45142 | Client-3 | 11 | Shanghai | Boston | Boston | 182-ctns/ 6-pallet | 3810 | 8 | LCL | 0 | AGT-3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Ever | 0 | 0 | 0 | CoLoad-3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 726.48 | 0 | 199 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 950.48 | 0 | CFS-2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
45155 | Client-2 | 13 | qingdao | NY | NY | 748-bags/ 19-pallet | 19300 | 22 | FCL | 0 | AGT6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | [NAME] | 0 | 0 | 0 | CoLoad-5 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 0 | CFS-3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
45149 | Client-3 | 12 | qingdao | NY | NY | 760-bags/ 19-pallet | 19589 | 40 | FCL | 0 | AGT5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | MSC | 0 | 0 | 0 | CoLoad-4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 110 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 110 | 0 | CFS-3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Client | Job # | POL | POD | Final Dest | # Pieces | Gross Wght (kgs) | CBM | [NAME] | 0 | Agent | Agent Total Chgs | Carrier | Ocean Freight (Collect) | VGM/Solas (weighing)Handling Fee | FOB | Liability | Wharfage Tax | AMS Security Fee | ISF 10+2 | THC/ Handling @ Origin | Pick-up/ Trucking Charge | [NAME] | Co-Loader Total Chgs: | THC/ Origin HC | Stripping Charge | [NAME] | I.T. Prep | Chassis Usage/ Suchg (CUC) | Equip Schg | CFS Fuel Schg | CFS/Port Sec I.S.P.S. Fee | Total CFS Charges: | CFS Charge
2023-08-10 00:00:00 | Client-1 | 1 | Barcelona | NY | Boston | 1-pallet | 68 | 0.315 | LCL | 0 | AGT-1 | 604 | CMA | 132 | 38.45 | 140.56 | 7.14 | 4.14 | 103.69 | 88.1 | 53.02 | 35.82 | 1.08 | 270 | 50 | 25 | 55 | 35 | 15 | 10 | 35 | 45 | 191.5 | 191.5