{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["US ","ocean vessel","air under 65 KGs","air greater than 65 KGs"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"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":"US ","index":0,"n_rows":16,"n_cols":8,"rows_kept":16,"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","DHL\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",98204,962164501,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",14623,969307149,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",72184,"UPS: 9W01R7",710618620,"Schlage Lock Company LLC","11819 N. Pennsylvania St.\nCarmel, IN 46032 USA"]
["Allegion-Isonas_Boulder, CO","Isonas, Inc.\nc/o Allegion-Isonas","4750 Walnut St.\nSte 110\nBoulder, CO 80301 USA",80301,964228308,710932948,"Isonas, Inc.","4750 Walnut St.\nSte 110\nBoulder, CO 80301 USA"]
["Allegion-Test Lab_Golden, CO","Schlage Lock Company LLC\nc/o Allegion","500 Golden Ridge Rd.\nBldg 1\nGolden, CO 80401 USA",80401,962165492,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",72392,962163777,710618554,"Schlage Lock Company LLC","11819 N. Pennsylvania St.\nCarmel, IN 46032 USA"]
["Allegion-Republic Doors & Frames_Irving, TX","Republic Doors & Frames LLC\nc/o Allegion","5430 FAA Blvd.\nSte 100\nIrving, TX 75061 USA",75050,"UPS: 080F1A",710864430,"Republic Doors & Frames LLC","155 Republic Dr.\nMcKenzie, TN 38201 USA"]
["Allegion-Schlage_Olathe, KS","Schlage Lock Company LLC\nc/o Allegion","2119 E. Kansas City Rd.\nOlathe, KS 66061 USA",72394,962164415,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",72405,962163917,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","6810 Hillsdale Ct.\nIndianapolis, IN 46250 USA","03333",962165489,709915383,"Schlage Lock Company LLC","11819 N. Pennsylvania St.\nCarmel, IN 46032 USA"]
["Allegion-GJ / IVES / Zero_Indianapolis, IN","Schlage Lock Company LLC\nc/o Allegion-GJ / IVES / Zero","8506 E. 30th St.\nBldgs A & B\nIndianapolis, IN 46219 USA",46219,962165322,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",72404,962164303,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",97182,"UPS: 9W000Y",710618612,"Schlage Lock Company LLC","11819 N. Pennsylvania St.\nCarmel, IN 46032 USA"]
["Allegion-Republic Doors & Frames_McKenzie, TN","Republic Doors & Frames LLC\nc/o Allegion","155 Republic Dr.\nMcKenzie, TN 38201 USA",38201,"UPS: 08W85Y",704996578,"Republic Doors & Frames LLC","155 Republic Dr.\nMcKenzie, TN 38201 USA"]
["Allegion-Kryptonite_Canton, MA","Schlage Lock Company LLC\nc/o Allegion-Kryptonite ","437 Turnpike St.\nCanton, MA 02021 USA","03320",962165463,710618562,"Schlage Lock Company LLC","11819 N. Pennsylvania St.\nCarmel, IN 46032 USA"]

{"sheet":"ocean vessel","index":1,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,0,1,1],[0,0,0,1],[15,0,20,0],[22,0,23,0],[10,0,13,0],[12,1,13,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\nISF Filing Agent: isf@iab-sd.com\nISF Contact: Steve Goding    \n"]
[]
["Ocean Freight Forwarder:","Kuehne + Nagel "]
[]
["US Customs Broker:","International Automated Brokers (IAB)"]
[]
["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(B12,'US '!A1:G17,7,FALSE)","v":"Sold To Party"}]
[null,"ATTN:\n(Select ONE of the following)"]
[null,{"$f":"VLOOKUP(B12,'US '!A1:H17,8,FALSE)","v":"Address"}," "]
[]
[]
["Bill To:","TRAX"]
[null,"c/o Allegion"]
[null,{"$f":"VLOOKUP($B$12,'US '!$A$1:$D$16,4,FALSE)","v":"Freight Plan Number will auto-fill upon ATTN: selection"}]
[null,"14500 N. Northsight Blvd."]
[null,"Suite 113"]
[null,"Scottsdale, AZ 85260-3659 USA"]
[]
["Deliver To (Final Destination): \n",{"$f":"VLOOKUP($B$12,'US '!A1:B16,2,FALSE)","v":"Deliver To:"}]
[null,{"$f":"VLOOKUP(B12,'US '!$A$1:$C$16,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 BEFORE vessel arrival:\n• Importer Security Filing (ISF)\n• Container Inspection Checklist (CIC)\n• commercial invoice\n• packing list\n• express bill of lading\n","Notify Party:\nInternational Automated Brokers (IAB)\nSteve Goding and James Goding\nPhone: +1-619-671-3186 / +1-619-671-3185\nFax:  +1-619- 661-6490\n     \nEmail  both of the following: \nsgoding@iab-sd.com \njamesg@iab-sd.com"]
[]
["Additional Notify Parties:"]

{"sheet":"air under 65 KGs","index":2,"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:","DHL Express"]
[]
["US Customs Broker:","DHL Express"]
[]
["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:I17,7,FALSE)","v":"Sold To Party"}]
[null,"ATTN:\n(Select ONE of the following)"]
[null,{"$f":"VLOOKUP(B10,'US '!A1:I17,8,FALSE)","v":"Address"}]
[]
[]
["DHL Express Account # :\n(Auto-fills once final destination is selected)",{"$f":"VLOOKUP($B$10,'US '!$A$1:$E$16,5,FALSE)","v":"DHL\n< 65kgs"}]
[]
["Deliver To (Final Destination): ",{"$f":"VLOOKUP(B10,'US '!A1:B16,2,FALSE)","v":"Deliver To:"}]
[null,{"$f":"VLOOKUP($B$10,'US '!A1:C16,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:\nTim Becker\nPhone: +1-859-496-1085\n\nEmail both of the following:\ntimothy.becker@dhl.com@ups.com\nCVGFormalManagementTeam@dhl.com\n\n\n"]
[]
["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 DHL.  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 your country specific DHL Customer Service Center by vistingn this link and selecting your country: http://www.dhl.com/en/contact_center.html\n\n\n"]

{"sheet":"air greater than 65 KGs","index":3,"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:","International Automated Brokers (IAB)"]
[]
["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:I17,7,FALSE)","v":"Sold To Party"}]
[]
[null,"ATTN:\n(Select ONE of the following)"]
[null,{"$f":"VLOOKUP(B11,'US '!A1:I17,8,FALSE)","v":"Address"}]
[]
[]
["Bill To:","TRAX"]
[null,"c/o Allegion"]
[null,{"$f":"VLOOKUP($B$11,'US '!$A$1:$D$16,4,FALSE)","v":"Freight Plan Number will auto-fill upon ATTN: selection"}]
[null,"14500 N. Northsight Blvd."]
[null,"Suite 113"]
[null,"Scottsdale, AZ 85260-3659 USA"]
[]
["UPS-SCS Account # :\n(Auto-fills once final destination is selected)",{"$f":"VLOOKUP($B$11,'US '!$A$1:$F$16,6,FALSE)","v":"UPS-SCS \n> 65kgs"}]
[]
["Deliver To (Final Destination): ",{"$f":"VLOOKUP($B$11,'US '!$A$1:$C$16,2,FALSE)","v":"Deliver To:"}]
[null,{"$f":"VLOOKUP($B$11,'US '!$A$1:$C$16,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:\nInternational Automated Brokers (IAB)\nSteve Goding and James Goding\nPhone: +1-619-671-3186 / +1-619-671-3185\nFax:  +1-619-661-6490\n     \nEmail both of the following: \nsgoding@iab-sd.com \njamesg@iab-sd.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: AllegionGFF@ups.com  "]
[]
["UPS SCS Contact Escalation and Support","All initial inquiries should be sent to AllegionGFF@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\nDirreck Williams: DirreckWilliams@ups.com +1-803-240-2563\nDon Anderson: DonAnderson@ups.com  +1-317-796-7177\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. "]