{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ocean vessel","air under 65 KGs","air greater than 65 KGs","US "],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ocean vessel","index":0,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,0,1,1],[0,0,0,1],[16,0,21,0],[23,0,24,0],[11,0,14,0],[13,1,14,1]]}
["IMPORTS INTO THE US"]
["OCEAN VESSEL SHIPMENTS "]
[]
["Importer Security Filing (ISF) Filing Agent: ","Send ISF template and estimated time of vessel departure for \"IMPORTS into the US\" to the filing agent listed below at least 72 hours in advance of ocean vessel departure.  \n\nFor Schlage, AD Solutions, Elatec, and Triangle Brass Mfg Co, Inc DBA TRIMCO  \nISF Filing Agent: isf@iab-sd.com\nISF Contact: Steve Goding    \n\nFor Allegion Access Technologies LLC\nISF Filing Agent: isf@kuehne-nagel.com\n"]
[]
["Ocean Freight Forwarder:","Kuehne + Nagel "]
[]
["US Customs Broker for Schlage, AD Solutions, Elatec, and Triangle Brass Mfg Co, Inc DBA TRIMCO:","International Automated Brokers (IAB)"]
["US Customs Broker for Allegion Access Technologies LLC:","Kuehne+Nagel Inc (KN)"]
[]
["Sold To Party: "]
["NOTE:  The \"Sold To\" Party name and address shown on the Commercial Invoice and the Bill of Lading must agree EXACTLY with the address shown on the right.   This is critical as US Customs requires the importer name and address contained on the US Customs Surety Bond to be reflected on all documentation.  If your \"Sold To\" Party is not on this list,  contact the Trade Compliance Department.",{"$f":"VLOOKUP(B13,'US '!A1:G18,7,FALSE)","v":"Sold To Party"}]
[null,"ATTN:\n(Select ONE of the following)"]
[null,{"$f":"VLOOKUP(B13,'US '!A1:H18,8,FALSE)","v":"Address"}," "]
[]
[]
["Bill To:","ALLEGION"]
[null,"c/o Körber Supply Chain"]
[null,{"$f":"VLOOKUP($B$13,'US '!$A$1:$D$18,4,FALSE)","v":"Freight Plan Number will auto-fill upon ATTN: selection"}]
[null,"11555 N Meridian St"]
[null,"STE 200"]
[null,"Carmel IN, 46032"]
[]
["Deliver To (Final Destination): \n",{"$f":"VLOOKUP($B$13,'US '!A1:B18,2,FALSE)","v":"Deliver To:"}]
[null,{"$f":"VLOOKUP(B13,'US '!$A$1:$C$18,3,FALSE)","v":"Address will auto-fill upon ATTN: selection"}]
["              "]
["Notify Party:  \nInclude the Notify Party on one of the \ndocuments (preferably the invoice) based on the BUSINESS UNIT on your PO.\n\nEMAIL Following Documents to Notify Party BEFORE vessel arrival:\n• Importer Security Filing (ISF) (with ISF transaction number)\n• Container Inspection Checklist (CIC) for FCL\n• commercial invoice\n• packing list\n• express bill of lading\n","Notify Party for Schlage, AD Solutions, Elatec, and Triangle Brass Mfg Co, Inc DBA TRIMCO  \nInternational Automated Brokers (IAB)\nSteve Goding and James Goding\nPhone: +1-619-671-3186 / +1-619-671-3185\nFax:  +1-619- 661-6490\nEmail both: sgoding@iab-sd.com and jamesg@iab-sd.com\n\nNotify Party for Allegion Access Technologies LLC\nKuehne+Nagel Inc\n1440 Northland Drive, Suite 300\nMendota Heights, MN 55120\nEmail the following (all pre-alerts and documents should go to this email address):\nUSBRKMSPHUB@KUEHNE-NAGEL.COM "]
[]
["Additional Notify Parties:","See below"]

{"sheet":"air under 65 KGs","index":1,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,0,1,1],[0,0,0,1],[8,0,11,0],[15,0,16,0],[10,1,11,1]]}
["IMPORTS INTO THE US"]
["AIR SHIPMENTS UNDER 65 KGs "]
[]
["Air Courier:","UPS Small Package"]
[]
["US Customs Broker:","UPS Parcel (Small Package)"]
[]
["Sold To Party: "]
["NOTE:  The \"Sold To\" Party name and address shown on the Commercial Invoice and the Bill of Lading must agree EXACTLY with the address shown on the right.   This is critical as US Customs requires the importer name and address contained on the US Customs Surety Bond to be reflected on all documentation.  If your \"Sold To\" Party is not on this list,  contact the Trade Compliance Department.",{"$f":"VLOOKUP(B10,'US '!A1:I18,7,FALSE)","v":"Sold To Party"}]
[null,"ATTN:\n(Select ONE of the following)"]
[null,{"$f":"VLOOKUP(B10,'US '!A:H,8,FALSE)","v":"Address"}]
[]
[]
["UPS Small Package Account # :\n(Auto-fills once final destination is selected)",{"$f":"VLOOKUP($B$10,'US '!$A$1:$E$18,5,FALSE)","v":"UPS Parcel\n< 65kgs"}]
[]
["Deliver To (Final Destination): ",{"$f":"VLOOKUP(B10,'US '!A1:B18,2,FALSE)","v":"Deliver To:"}]
[null,{"$f":"VLOOKUP($B$10,'US '!A1:C18,3,FALSE)","v":"Address will auto-fill upon ATTN: selection"}]
["              "]
["Notify Party:  \n\nEMAIL Following Documents to Notify Party:\n• commercial invoice\n• packing list\n• express bill of lading \n\n","Notify Party:\nUPS Parcel (Small Package)\nChristina Kemp\nPhone: (502) 362-6657\nEmail both: Christinakemp@ups.com and UPSUSALLEGION@ups.com"]
[]
["Special Requirements:      ","For ALL Shipments\n   *  Include NAME / TEL. of Buyer/Planner on Documentation\n\nAll clearance paperwork (i.e. Commercial Invoice) needs to be provided with each shipment at the time of pickup with UPS.  Additionally,  Commercial Invoice currency value must match  the currency value entered on the AirwayBill. Shipments will not leave the country without proper documentation. \n\nFor additional support, please contact the UPS International Help Desk:\nEmail: goglobal@ups.com\nPhone: 1-800-782-7892\n\n"]

{"sheet":"air greater than 65 KGs","index":2,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,0,1,1],[0,0,0,1],[23,0,24,0],[14,0,19,0],[8,0,12,0],[11,1,12,1]]}
["IMPORTS INTO THE US"]
["AIR SHIPMENTS GREATER THAN 65 KGs "]
[]
["Air Freight Forwarder:","UPS Supply Chain Solutions  (UPS-SCS)                                                                          "]
[]
["US Customs Broker:","US Customs Broker for Schlage, AD Solutions, Elatec, and Triangle Brass Mfg Co, Inc DBA TRIMCO:  International Automated Brokers (IAB)\n\nUS Customs Broker for Allegion Access Technologies LLC: Kuehne+Nagel Inc (KN)"]
[]
["Sold To (Consignee): \n\n\n"]
["NOTE:  The \"Sold To\" Party name and address shown on the Commercial Invoice and the Bill of Lading must agree EXACTLY with the address shown on the right.   This is critical as US Customs requires the importer name and address contained on the US Customs Surety Bond to be reflected on all documentation.  If your \"Sold To\" Party is not on this list,  contact the Trade Compliance Department.",{"$f":"VLOOKUP(B11,'US '!A1:I18,7,FALSE)","v":"Sold To Party"}]
[]
[null,"ATTN:\n(Select ONE of the following)"]
[null,{"$f":"VLOOKUP(B11,'US '!A:H,8,FALSE)","v":"Address"}]
[]
[]
["Bill To:","ALLEGION"]
[null,"c/o Körber Supply Chain"]
[null,{"$f":"VLOOKUP($B$11,'US '!$A$1:$D$18,4,FALSE)","v":"Freight Plan Number will auto-fill upon ATTN: selection"}]
[null,"11555 N Meridian St"]
[null,"STE 200"]
[null,"Carmel IN, 46032"]
[]
["UPS-SCS Account # :\n(Auto-fills once final destination is selected)",{"$f":"VLOOKUP($B$11,'US '!$A$1:$F$18,6,FALSE)","v":"UPS-SCS \n> 65kgs"}]
[]
["Deliver To (Final Destination): ",{"$f":"VLOOKUP($B$11,'US '!$A$1:$C$18,2,FALSE)","v":"Deliver To:"}]
[null,{"$f":"VLOOKUP($B$11,'US '!$A$1:$C$18,3,FALSE)","v":"Address will auto-fill upon ATTN: selection"}]
["              "]
["Notify Party:  \nInclude the NOTIFY PARTY on one of the \ndocuments (preferably the invoice)\n\nEMAIL Following Documents to Notify Party:\n• commercial invoice\n• packing list\n• express bill of lading \n\n","Notify Party for Schlage, AD Solutions, Elatec, and Triangle Brass Mfg Co, Inc DBA TRIMCO:\nInternational Automated Brokers (IAB)\nSteve Goding and James Goding\nPhone: +1-619-671-3186 / +1-619-671-3185\nFax:  +1-619- 661-6490\nEmail both: sgoding@iab-sd.com and jamesg@iab-sd.com\n\nNotify Party for Allegion Access Technologies LLC:\nKuehne+Nagel Inc\n1440 Northland Drive, Suite 300\nMendota Heights, MN 55120\nEmail the following (all pre-alerts and documents should go to this email address):\nUSBRKMSPHUB@KUEHNE-NAGEL.COM\n"," "]
[]
["Special Requirements:      ","For ALL Shipments\n*  Include NAME and TELEPHONE NUMBER of Buyer/Planner on Documentation\n\n\n"]
[]
["For Booking UPS SCS Shipments","For ALL Shipments\nPhone: +1-913-693-6212\nEmail the following: ed.arquilla@ups.com"]
[]
["UPS SCS Contact Escalation and Support","All initial inquiries should be sent to ed.arquilla@ups.com\nFor escalations on day to day issues please contact:\n\nscscustomerservice@ups.com\nBrenda Ransburg: ransburg.brenda@ups.com\nJulie White: jmwhite@ups.com\nAnnetta Jackson: annettajackson@ups.com\n\nIf you encounter a situation that requires additional visibility or assistance, please contact:\n\nEd Arquilla: ed.arquilla@ups.com +1-630-544-4831\nAndrew Brown: ADBrown@ups.com  +1-734-735-8522\n\n"]
[]
["For UPS SCS Delivery Address Changes / Re-consignment","Please include \"Allegion Routing Change\" in the subject of the email. The body of the message should list shipment detail such as UPS-SCS tracking number,  Allegion reference number, shipper, current consignee name, address and change details. "]

{"sheet":"US ","index":3,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["ATTN:\n(Select ONE of the following)","Deliver To:","Address will auto-fill upon ATTN: selection","Freight Plan Number will auto-fill upon ATTN: selection","UPS Parcel\n< 65kgs","UPS-SCS \n> 65kgs","Sold To Party","Address"]
["Allegion-AD Systems_Everett, WA","AD Solutions, Inc.\nc/o Allegion-AD Systems","2201 100th St. SW\nEverett, WA 98204 USA","Freight Plan: 98204","R70Y08 (SHIP USING UPS EXPRESS SAVER)",710864406,"AD Solutions, Inc.","2201 100th St. SW\nEverett, WA 98204 USA"]
["Allegion-Brio USA_Everett, WA","AD Solutions, Inc.\nc/o Allegion-Brio USA","2201 100th St. SW\nEverett, WA 98204 USA","Freight Plan: 14623","39V36V (SHIP USING UPS EXPRESS SAVER)",710618661,"AD Solutions, Inc.","2201 100th St. SW\nEverett, WA 98204 USA"]
["Allegion-Steelcraft_Chino,CA","Schlage Lock Company LLC\nc/o Allegion-Steelcraft","14575 Yorba Ave.\nChino, CA 91710 USA","Freight Plan: 72184","9W01R7 (SHIP USING UPS EXPRESS SAVER)",710618620,"Schlage Lock Company LLC","11819 N. Pennsylvania St.\nCarmel, IN 46032 USA"]
["Allegion-Isonas_Boulder, CO","Isonas, Inc.\nc/o Allegion-Isonas","929 Pearl St\nSte 200\nBoulder, CO 80302 USA","Freight Plan: 80301","6W4F51 (SHIP USING UPS EXPRESS SAVER)",710932948,"Schlage Lock Company LLC","11819 N. Pennsylvania St.\nCarmel, IN 46032 USA"]
["Allegion-Test Lab_Golden, CO","Schlage Lock Company LLC\nc/o Allegion","500 Golden Ridge Rd.\nBldg 1\nGolden, CO 80401 USA","Freight Plan: 80401","53AR98 (SHIP USING UPS EXPRESS SAVER)",705281707,"Schlage Lock Company LLC","11819 N. Pennsylvania St.\nCarmel, IN 46032 USA"]
["Allegion-Schlage_Security, CO","Schlage Lock Company LLC\nc/o Allegion","3899 Hancock Expressway\nSecurity, CO 80911 USA","Freight Plan: 72392","9W02E7 (SHIP USING UPS EXPRESS SAVER)",710618554,"Schlage Lock Company LLC","11819 N. Pennsylvania St.\nCarmel, IN 46032 USA"]
["Allegion-Schlage_Olathe, KS","Schlage Lock Company LLC\nc/o Allegion","2119 E. Kansas City Rd.\nOlathe, KS 66061 USA","Freight Plan: 72394","9W01R3 (SHIP USING UPS EXPRESS SAVER)",710618448,"Schlage Lock Company LLC","11819 N. Pennsylvania St.\nCarmel, IN 46032 USA"]
["Allegion-LCN_Princeton, IL","Schlage Lock Company LLC\nc/o Allegion-LCN ","121 W. Railroad Ave.\nPrinceton, IL 61356 USA","Freight Plan: 72405","9W01F6 (SHIP USING UPS EXPRESS SAVER)",710618570,"Schlage Lock Company LLC","11819 N. Pennsylvania St.\nCarmel, IN 46032 USA"]
["Allegion-Test Lab_Indianapolis, IN","Schlage Lock Company LLC\nc/o Allegion","8750 Hague Road\nIndianapolis, IN 46256 USA","Freight Plan: 03333","53AF97 (SHIP USING UPS EXPRESS SAVER)",709915383,"Schlage Lock Company LLC","11819 N. Pennsylvania St.\nCarmel, IN 46032 USA"]
["Allegion-GJ / IVES / Zero_Greenfield, IN","Schlage Lock Company LLC\nc/o Allegion-GJ / IVES / Zero","7221 W County Rd 350 N.\nGreenfield, IN 46140 USA","Freight Plan: 46219","53AR32 (SHIP USING UPS EXPRESS SAVER)",710618588,"Schlage Lock Company LLC","11819 N. Pennsylvania St.\nCarmel, IN 46032 USA"]
["Allegion-Von Duprin_Indianapolis, IN","Schlage Lock Company LLC\nc/o Allegion-Von Duprin","2720 Tobey Dr.\nIndianapolis, IN 46219 USA","Freight Plan: 72404","9W02A3 (SHIP USING UPS EXPRESS SAVER)",710618604,"Schlage Lock Company LLC","11819 N. Pennsylvania St.\nCarmel, IN 46032 USA"]
["Allegion-Steelcraft_Blue Ash, OH","Schlage Lock Company LLC\nc/o Allegion-Steelcraft","9017 Blue Ash Rd.\nCincinnati, OH 45242 USA","Freight Plan: 97182","9W000Y (SHIP USING UPS EXPRESS SAVER)",710618612,"Schlage Lock Company LLC","11819 N. Pennsylvania St.\nCarmel, IN 46032 USA"]
["Allegion-Kryptonite_Canton, MA","Schlage Lock Company LLC\nc/o Allegion-Kryptonite ","437 Turnpike St.\nCanton, MA 02021 USA","Freight Plan: 03320","444FY7 (SHIP USING UPS EXPRESS SAVER)",710618562,"Schlage Lock Company LLC","11819 N. Pennsylvania St.\nCarmel, IN 46032 USA"]
["Allegion Access Technologies LLC_Farmington, CT","Allegion Access Technologies LLC c/o Allegion-Allegion Access Technologies LLC","65 Scott Swamp Rd\nFarmington, CT 06032","Freight Plan: 20025","0E5426 (SHIP USING UPS EXPRESS SAVER)","059912147","Allegion Access Technologies LLC","11819 N. Pennsylvania St.\nCarmel, IN 46032 USA"]
["Allegion Access Technologies LLC_Greenfield, IN","Allegion Access Technologies LLC c/o Allegion-Allegion Access Technologies LLC","6825 W 400 N\nGreenfield, IN 46140","Freight Plan: 20027","538E3X (SHIP USING UPS EXPRESS SAVER)","059912147","Allegion Access Technologies LLC","11819 N. Pennsylvania St.\nCarmel, IN 46032 USA"]
["Allegion-Trimco Hardware_Oceanside, CA","Triangle Brass MFG Co, Inc DBA Trimco","1351 Rocky Pointe Drive\nOceanside, CA 92056 USA","Freight Plan: 92056","912438 (SHIP USING UPS EXPRESS SAVER)",709949424,"Triangle Brass MFG Co, Inc DBA Trimco","1351 Rocky Pointe Drive\nOceanside, CA 92056 USA"]
["Allegion-Elatec Inc (USA)_Palm City, FL","Elatec Inc (USA)","1995 SW Martin Hwy\nPalm City, FL 34990 USA","Freight Plan: 34990","2548X2 (SHIP USING UPS EXPRESS SAVER)",710618562,"Elatec Inc (USA)","1995 SW Martin Hwy\nPalm City, FL 34990 USA"]