Spreadsheet: 489980d1479511874-sumifs-or-other-formula-needed-copy-of-seattle-consols-week-47-2016-code
Sheet:  WK

SEATTLE CONSOLS - Summary
WEEK | 47
 | Total | HKS | SZS | SHS | NGS | TPS
Total CBM
Total FMM CBM
Total IDPO CBM
Total TEU |  | 4 | 2 | 3 | 1 | 2
Containers Loaded | 7 | 2x40' | 1x40'RQ | 20'&40'H | 1X20' | 1X40'RQ
Ocean Freight |  |  | 1748.5 |  | 1441 | 1750
Drayage |  |  | 550 | 1100 | 550 | 550
Total Cost
Cost per CBM
SEATTLE CONSOLS - Details
Vessel/MBL# | HBL# | Customers |  | FTN OFFICE CONTROL | CBM |  |  |  | CONT SIZE
KKLUHC02517900 | HKS000044756 | Control4 Corporation |  | FUSSLC | 5.43
KKLUHC02517900 | HKS000044810 | Advanced Input Devices Inc |  | FUSSEA | 1.03 | 86 CTN | 1006.56
KKLUHC02517900 | HKS000044705 | Control4 [NAME] |  | FUSSLC | 27.01 | 25 CTN | 236.9
KKLUHC02517900 | HKS000044757 | Thermoworks Inc |  | FUSSLC | 9.29 | 2 CRT | 1373
KKLUHC02517900 | HKS000044801 | Control4 [NAME] |  | FUSSLC | 1.21 | 2 PLT (65 CTN) | 571.7
KKLUHC02518100 | HKS000044742 | ClearOne |  | FUSSLC | 1.98 | 40 CTN | 538
KKLUHC02518100 | HKS000044760 | Xymox Technologies Inc | FMM | FUSORD | 3.05
KKLUHC02518100 | HKS000044771 | Harber Industrials Inc | FMM | FUSORD | 3.14
KKLUHC02518100 | HKS000044789 | Siskiyou Buckle Company Inc | FMM | FUSPDX | 0.38
KKLUHC02518100 | HKS000044832 | CCX Corporation |  | FUSDEN | 8.04
KKLUHC02518100 | [NAME] | Trenton Technology Inc | FMM | FUSJFK | 10.08
KKLUHC02518100 | HKS000044768 | Jerome Industries Corporation | FMM | FUSJFK | 1.11
KKLUHC02518100 | HKS000044783 | Americord |  | FUSSLC | 4.72
KKLUHC02518100 | HKS000044785 | Panasonic Industrial Devices Sales Co |  | FUSSEA | 3.11
KKLUHC02518100 | HKS000044812 | CITY BY CITY | IDPO | FUSSEA | 10.06
YMLUW302042111 | SZS000088911 | Bandwagon Inc | IDPO | FUSSEA | 2.26
YMLUW302042111 | SZS000089085 | NWE Brands Inc |  | FUSPDX | 1.09
YMLUW302042111 | SZS000089506 | Crane Hardware LLC |  | FUSSEA | 1.55
YMLUW302042111 | SZS000089568 | NWE Brands Inc |  | FUSPDX | 5.9
YMLUW302042111 | [NAME] | NWE Brands Inc |  | FUSPDX | 3.3
YMLUW302042111 | SZS000089630 | Lenze AC Tech Corporation |  | FUSBOS | 1.83
YMLUW302042111 | SZS000089677 | Sorenson Communications Inc |  | FUSSLC | 11.78
YMLUW302042111 | SZS000089705 | NWE Brands Inc |  | FUSPDX | 4.22
YMLUW302042111 | SZS000089729 | NWE Brands Inc |  | FUSPDX | 0.54
YMLUW302042111 | SZS000089730 | Kecy Corporation | IDPO | FUSSEA | 1.42
YMLUW302042111 | SZS000089734 | Kecy Corporation | IDPO | FUSSEA | 0.92 | 86 CTN | 1006.56
KKLUSH6134285 | SHS000137777 | Thunder Box Inc |  | FUSDEN | 11.18 | 25 CTN | 236.9
KKLUSH6134285 | [NAME] | A-BOS LTD. |  | FUSBOS | 25.512 | 2 CRT | 1373
KKLUSH6134285 | SHS000137987 | Bissell Homecare Inc. | FMM | FUSSEA | 2.9 | 2 PLT (65 CTN) | 571.7
KKLUSH6134285 | SHS000138220 | Birddog Distributing Inc |  | FUSSEA | 7.26 | 40 CTN | 538
KKLUSH6134285 | SHS000138557 | Wells Vehicle Electronics L P |  | FUSSEA | 2.1
KKLUSH6134285 | SHS000138562 | Wells Vehicle Electronics L P |  | FUSSEA | 2.37
KKLUSH6134286 | SHS000137858 | Righteous Clothing Agency |  | FUSPDX | 3.82
KKLUSH6134286 | SHS000138425 | National Precision Bearing Grp |  | FUSSEA | 1.33
KKLUSH6134286 | SHS000138655 | 3Xlogic Inc |  | FUSDEN | 4.911
KKLUSH6134286 | SHS000138712 | Mechatronics Inc |  | FUSSEA | 0.3
KKLUSH6134286 | SHS000138720 | Heritage Home Group LLC DBA Broyhill | IDPO | FUSSEA | 4.4
KKLUSH6134286 | SHS000138724 | HERITAGE HOME GROUP DBA BROYHILL | IDPO | FUSSEA | 5.8
KKLUSH6134286 | SHS000138738 | ESTERLINE ADVANCED INPUT SYSTEMS |  | FUSSEA | 1.42
YMLUW232219273 | NGS000062212 | Siskiyou Buckle Company Inc |  | FUSPDX | 0.806
YMLUW232219273 | NGS000054893 | MASTERPIECES PUZZLE COMPANY | FMM | FUSPHX | 2.04
YMLUW232219273 | NGS000054900 | NLDA Associates Inc |  | FUSSEA | 0.8
YMLUW232219273 | NGS000054904 | PinPoint Optics LLC |  | FUSSEA | 11.11
YMLUW232219273 | NGS000054906 | Fremont Die Consumer Products Inc |  | FUSPDX | 0.808
YMLUW232219273 | NGS000054914 | Dwyer Instruments Inc | FMM | FUSORD | 0.75
YMLUW232219273 | NGS000054918 | The Cranestand Com |  | FUSSEA | 4.76
YMLUW232219273 | NGS000054921 | GA ICWUSA.COM INC. |  | FUSPDX | 3.56
HDMUKEWB0385125 | TPS000040314 | Memtron Technologies Co | FMM | FUSSEA | 3.41
HDMUKEWB0385125 | TPS000040324 | Strapworks LLC |  | FUSPDX | 0.66
HDMUKEWB0385125 | TPS000040415 | Yeti Cycles |  | FUSDEN | 2.26
HDMUKEWB0385125 | TPS000040461 | Siskiyou Buckle Company Inc |  | FUSPDX | 0.94
HDMUKEWB0385125 | TPS000040462 | Bestop Inc. |  | FUSDEN | 5.7
HDMUKEWB0385125 | TPS000040477 | Shogyo International Corp |  | FUSSEA | 0.51
HDMUKEWB0385125 | TPS000040486 | FXR Factory Racing Inc | FMM | FUSMSP | 0.97
HDMUKEWB0385125 | TPS000040488 | Trenton Technology Inc | FMM | FUSJFK | 15.23
HDMUKEWB0385125 | TPS000040499 | CCX Corporation |  | FUSDEN | 0.96