Spreadsheet: 881811d1730010103-how-to-have-return-results-of-a-function-split-across-multiple-lines-jeff-12345-testfile-3-spill-365-aligw
Sheet: Shipping Related Charges

Test File |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 116 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 134
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assessorial Charges - Agent Releated |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | Co-Loader Related (Arrival Notice)
 |  |  |  |  |  |  |  |  |  |  | Origin Side Costs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Destination Side Costs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CFS Warehouse Related
Date | Client | Job # | POL | POD | Final Dest | # Pieces | Gross Wght (kgs) | CBM | [NAME] |  | Agent | Profit Share/ Commission | 100% Profit Share (WWL) | Ocean Freight Quote Rate: | Ocean Freight (Pre-Paid) | Ocean Freight (Collect) | Peak Season Surcharge - PSS | VGM/Solas (weighing)Handling Fee | FOB | Liability | Port Charges (Origin) | Wharfage Tax | Warehouse Charge | AMS Security Fee | ISF 10+2 | HBL Fee | [NAME] | [NAME] of Lading | Telex Release Fee | Seal Fee | Lashing Charge | Non-Stackable Charge | [NAME] | Cargo Handling Charge (CHC) | Ancillaries | THC/ Handling @ Origin | Printed Matter & Forms/ Handling Charge or Quay | Processing | DOC Charge | CFS Charge | Dest Delivery Charge | Pick-up/ Trucking Charge | Inland Trans,P/U @ Shippers | Inland Drayage | Chassis Usage Charge (CUC) | Bunker Adjustment Factor - Fuel (BAF) | [NAME] | CO2 Safety Emissions Env Fee | Energy Adjustment Levy - EAL | Comm Inspection Fee | Compliance Charge | Customs Clearance | Customs Clearance Doc | [NAME] | (Port Security) I.S.P.S. Fee | Fixed Costs | Co-Loader Chgs pre-pd (WWL) | Agent Total Chgs |  | Carrier |  |  |  | Co-Loader | Ocean Freight (Collect) | General Rate Increase (GRI) Charge | Emergency Peak Season Charge | SOLAS VGM Fee | Other Charges | Overweight/OverDim Chg | THC/ Origin HC | [NAME] to Customer | CBP Processing Fee/ACD | Stripping | Stripping Charge | De-Vanning | L.O.T. Fee | Low Water Charge | Panama Canal Charge (PCC) | CFS/ Documentation Fee | [NAME] | CFS Loading Fee | On Carriage | Loading/ Unloading Charge | Wharfage Chge | Warehouse charge | Ins or Container Protect Unlimited (Ins) | In/Out Charge/ InBound Fee | Window Facility Fee | Pier Surchg/ Container Port Charge | Port Congestion Charge | IPI (Truck/Rail) Congestion | Emergency Port Congestion Chg | [NAME] | Toll Fee | [NAME] (DAD/ DDC) | Cargo Facility Chg (CFC)/ Dest Deliv Charge | Labor & Trans/ Doc Trans Fee/ Inland Frght | Permit To Transfer (PTT) | I.T. Prep | [NAME] | Chassis Usage/ Suchg (CUC) | Turn in Fee | Equip Imbalance Chg | Equip Schg | Emission trading System (ETS) | Clean Truck (Fuel) Fee | Low Sulfur or [NAME] | CFS Fuel Schg | IMO2020 (Fuel) Charge | CFS/Port Sec I.S.P.S. Fee | Carrier Security Fee | Co-Loader Total Chgs: |  | CFS Location | CFS Charge | CFS In-Bond | Admin Fees CUCC | Documentation | [NAME] (DAD) | Facility Fee | Handling Fee | Pallet Fee | Over Dimension | Import [NAME] | CUCC Collect | [NAME] | Forklift Fee | Wage/Labor Trans Fee | Imp Ship Ins Fee | Port Drayage Srchg | [NAME] (local equip) | Total CFS Charges:
2023-08-10 00:00:00 | Client-1 | 1 | Barcelona | NY | Boston | 1-pallet | 68 | 0.315 | LCL |  | AGT-1 |  |  |  |  | 132 |  | 38.45 | 140.56 | 7.14 |  | 4.14 |  | 103.69 | 88.1 |  |  |  |  |  |  |  |  |  |  | 53.02 |  |  |  |  |  | 35.82 |  |  |  |  | 1.08 |  |  |  |  |  |  |  |  |  |  | 604 |  | CMA |  |  |  | CoLoad-1 |  |  |  |  |  |  | 50 |  |  |  | 25 |  |  |  |  |  | 55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 |  | 15 |  |  | 10 |  |  |  | 35 |  | 45 |  | 270 |  | [NAME] | 191.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 191.5
2023-09-15 00:00:00 | Client-1 | 2 | Barcelona | NY | Boston | 1-pkg | 92 | 0.24 | LCL |  | AGT-1 |  |  |  |  | 116 |  | 38.04 | 139.06 | 7.06 |  | 4.1 |  | 102.59 | 87.16 |  |  |  |  |  |  |  |  |  |  | 52.46 |  |  |  |  |  | 30.86 |  |  |  |  | 1.54 |  |  |  |  |  |  |  |  |  |  | 578.87 |  | ZIM |  |  |  | CoLoad-1 |  |  |  |  |  |  | 50 |  |  | 25 |  |  |  |  |  |  | 55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 |  | 15 |  |  | 10 |  |  |  | 35 |  | 45 |  | 270 |  | [NAME] | 191.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 191.5
2023-09-26 00:00:00 | Client-1 | 3 | Barcelona | NY | Boston | 9-box | 2136 | 2.458 | LCL |  | AGT-2 |  |  |  |  | 285.13 |  | 37.32 | 136.44 | 6.93 |  |  | 12.06 | 100.65 | 85.52 |  |  |  |  |  |  |  |  |  |  | 154.4 |  |  |  |  |  | 188.6 |  |  |  |  | 9.43 |  |  |  |  |  |  |  |  |  |  | 1016.48 |  | ZIM |  |  |  | CoLoad-1 |  |  |  |  |  |  | 61.45 |  |  | 30.73 |  |  |  |  |  |  | 55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 |  | 15 |  |  | 17.66 |  |  | 35 |  |  | 45 |  | 294.84 |  | [NAME] | 293.09 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 293.09
2023-10-04 00:00:00 | Client-1 | 4 | Barcelona | NY | Boston | 5-box | 1735 | 2.021 | LCL |  | AGT-2 |  |  |  |  | 234.44 |  | 36.88 | 134.81 | 6.84 |  | 7.95 |  | 99.45 | 84.5 |  |  |  |  |  |  |  |  |  |  | 101.71 |  |  |  |  |  | 186.34 |  |  |  |  | 9.32 |  |  |  |  |  |  |  |  |  |  | 902.24 |  | ZIM |  |  |  | CoLoad-1 |  |  |  |  |  |  | 50.53 |  |  | 25.26 |  |  |  |  |  |  | 55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 |  | 15 |  |  | 14.34 |  |  |  | 35 |  | 45 |  | 275.13 |  | [NAME] | 259.94 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 259.94
2023-10-05 00:00:00 | Client-1 | 5 | Barcelona | NY | Boston | 1-box | 72 | 0.15 | LCL |  | AGT-3 |  |  |  |  | 116 |  | 36.88 | 134.81 | 6.84 |  | 3.97 |  | 99.45 | 84.5 |  |  |  |  |  |  |  |  |  |  | 50.85 |  |  |  |  |  | 57.17 |  |  |  |  | 2.86 |  |  |  |  |  |  |  |  |  |  | 593.33 |  | ZIM |  |  |  | CoLoad-1 |  |  |  |  |  |  | 50 |  |  | 25 |  |  |  |  |  |  | 55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 |  | 15 |  |  | 10 |  |  |  | 35 |  | 45 |  | 270 |  | [NAME] | 191.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 191.5
2023-10-17 00:00:00 | Client-1 | 6 | Barcelona | NY | Boston | 1-box | 103 | 0.17 | LCL |  | AGT-3 |  |  |  |  | 110 |  | 37.11 | 135.68 | 6.89 |  | 4 |  | 100.09 | 85.04 |  |  |  |  |  |  |  |  |  |  | 51.18 |  |  |  |  |  | 75.87 |  |  |  |  | 6.07 |  |  |  |  |  |  |  |  |  |  | 611.93 |  | ZIM |  |  |  | CoLoad-1 |  |  |  |  |  |  | 50 |  |  | 25 |  |  |  |  |  |  | 55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 |  | 15 |  |  | 10 |  |  |  | 35 |  | 45 |  | 270 |  | [NAME] | 191.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 191.5
2023-10-19 00:00:00 | Client-1 | 7 | [NAME] | NY | Boston | 5-box | 1310 | 1.53 | LCL |  | AGT-4 |  |  |  |  | 219.82 |  | 37.11 | 85.63 | 6.57 |  | 8 |  | 85.04 |  |  |  |  |  |  |  |  |  |  |  | 75.7 |  |  |  |  |  | 125.23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 643.1 |  | ZIM |  |  |  | CoLoad-1 |  |  |  |  |  |  | 50 |  |  | 25 |  |  |  |  |  |  | 55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 |  | 15 |  |  | 10.83 |  |  |  | 35 |  | 45 |  | 270.83 |  | [NAME] | 224.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 224.8
2023-10-26 00:00:00 | Client-1 | 8 | [NAME] | NY | Boston | 5 | 2170 | 1.94 | LCL |  | AGT-4 |  |  |  |  | 258.03 |  | 36.95 | 85.26 | 6.55 |  |  | 11.95 | 84.68 |  |  |  |  |  |  |  |  |  |  |  | 113.06 |  |  |  |  |  | 175.97 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 772.45 |  | ZIM |  |  |  | CoLoad-1 |  |  |  |  |  |  | 54.25 |  |  | 27.13 |  |  |  |  |  |  | 55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 |  | 15 |  |  | 17.94 |  |  |  | 35 |  | 45 |  | 284.32 |  | [NAME] | 295.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 295.9
2023-07-26 00:00:00 | Client-2 | 9 | qingdao | NY | Boston | 1-pallet/ 24-bags | 630 | 1 | LCL |  | AGT-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ever |  |  |  | CoLoad-2 |  |  |  |  |  |  |  | 30 |  |  | 50 |  |  |  |  | 30 |  |  |  |  |  |  |  |  |  |  | 34.72 | 12.15 |  |  | 10 |  |  |  |  | 25 | 10 | 15 |  |  |  |  |  |  |  | 5 |  |  | 266.87 |  | CFS-2 | 255 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 255
2023-08-04 00:00:00 | Client-2 | 10 | Shanghai | NY | Boston | 1-pallet | 84 |  | LCL |  | AGT-2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ever |  |  |  | CoLoad-3 |  |  | 35 |  |  |  |  |  | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  | 20 |  |  |  |  | 75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 511.5 |  | CFS-2 |  |  |  |  |  |  | 255 |  |  |  | 70 |  |  |  |  |  |  | 325
2023-08-04 00:00:00 | Client-3 | 11 | Shanghai | Boston | Boston | 182-ctns/ 6-pallet | 3810 | 8 | LCL |  | AGT-3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ever |  |  |  | CoLoad-3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 726.48 |  | 199 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 950.48 |  | CFS-2
2023-08-11 00:00:00 | Client-3 | 12 | qingdao | NY | NY | 760-bags/ 19-pallet | 19589 | 40 | FCL |  | AGT5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MSC |  |  |  | CoLoad-4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 110 |  |  |  |  |  |  |  |  |  |  | 110 |  | CFS-3
2023-08-17 00:00:00 | Client-2 | 13 | qingdao | NY | NY | 748-bags/ 19-pallet | 19300 | 22 | FCL |  | AGT6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | CoLoad-5 |  |  |  |  |  |  | 65 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65 |  | CFS-3
 |  | **Note: This sheet it is ok to have '0.00' value columns.