{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["US ","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":1,"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":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["ATTN: (Select ONE of the following):","Deliver to:","Address will auto-fill upon plant location selection","Freight Plan Number","UPS  < 65kgs","UPS - SCS  > 65kgs"]
["ATTN: Schlage  ","Allegion - Schlage Olathe Distribution Service Center ","2119 E. Kansas City Rd., Olathe, KS 66061",72394,"9W01R3",710618448]
["ATTN: Schlage Electronic Security","Allegion - Schlage Electronics","3899 Hancock Expressway, Colorado Springs, CO 80911","04403","6Y3Y53",710618455]
["ATTN: RSI","Allegion - RSI - Schlage","3899 Hancock Expressway, Colorado Springs, CO 80911","04401","3E8Y76",710618471]
["ATTN: XceedID ","Allegion - Xceed ID","3899 Hancock Expressway, Colorado Springs, CO 80911",73600,"9W02F3",710618489]
["ATTN: Schlage","Allegion - Security Plant ","3899 Hancock Expressway, Colorado Springs, CO 80911",72392,"9W02E7",710618554]
["ATTN: Kryptonite ","Allegion - Kryptonite ","437 Turnpike St., Canton, MA 02021","03320","041738",710618562]
["ATTN: LCN ","Allegion - LCN ","121 W. Railroad Ave., Princeton, IL 61356",72405,"9W01F6",710618570]
["ATTN: IVES","Allegion - IVES","8506-A E. 30th St., Indianapolis, IN 46219",72404,"9W02A3",710618588]
["ATTN: ZERO","Allegion - ZERO","8506-A E. 30th St., Indianapolis, IN 46219",72404,"9W02A3",710618588]
["ATTN: Von Duprin","Allegion - Von Duprin","2720 Tobey Drive., Indianapolis, IN 46219",72404,"9W02A3",710618604]
["ATTN: Steelcraft ","Allegion - Steelcraft","9017 Blue Ash Rd., Cincinnati, OH 45242",97182,"9W000Y",710618612]
["ATTN: Steelcraft","Allegion - Steelcraft","13770 Ramona Ave., Chino, CA 91710",72184,"9W01R7",710618620]
["ATTN: Brio ","Allegion - Brio USA ","85 Mushroom Blvd., Rochester, NY 14623",14623,"39V36V",710618661]
["ATTN: Republic Doors & Frames","Allegion - Republic Doors & Frames","155 Republic Dr, McKenzie, TN 38201",38201,318494,703133371]

{"sheet":"vessel","index":1,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,0,1,1],[0,0,0,1],[15,0,19,0],[21,0,22,0],[10,0,13,0]]}
["IMPORTS INTO THE US"]
["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 below at least 72 hours in advance of sailing.  \n\nISF Filing Agent   isf@iab-sd.com\nThe ISF contact is Steve Goding.    \n"]
[]
["Freight Forwarder:","Kuehne + Nagel "]
[]
["US Customs Broker:","International Automated Brokers (IAB)"]
[]
["Sold To/Consignee: "]
["NOTE:  The \"Sold To\" name and address shown on the Commercial Invoice and the \"Consignee\" shown on the Bills 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.","Schlage Lock Co., LLC "]
[null,"ATTN: (Select ONE of the following):"]
[null,"11819 North Pennsylvania Street"," "]
[null,"Carmel, IN 46032 USA"]
[]
["Bill To:\n(Freight Plan will auto-fill upon \"ATTN\" selection)","Cass Information Systems"]
[null,"c/o Allegion"]
[null,{"$f":"VLOOKUP($B$12,'US '!$A$1:$D$15,4,FALSE)","v":"Freight Plan Number"}]
[null,"P.O. Box 67"]
[null,"St.Louis, MO 63166"]
[]
["Deliver To / Final Destination: \n(Deliver to Address will auto-fill upon \"ATTN\" selection)",{"$f":"VLOOKUP($B$12,'US '!A1:B15,2,FALSE)","v":"Deliver to:"}]
[null,{"$f":"VLOOKUP(B12,'US '!$A$1:$C$15,3,FALSE)","v":"Address will auto-fill upon plant location 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: (619) 671-3186/ (619) 671-3185\nFax:  (619) 661-6490\n     \nEmail  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]]}
["IMPORTS INTO THE US"]
["AIR SHIPMENTS UNDER 65KGs "]
[]
["Air Courier:","UPS Small Package"]
[]
["US Customs Broker:","UPS  "]
[]
["Sold To/Consignee: "]
["NOTE:  The \"Sold To\" name and address shown on the Commercial Invoice and the \"Consignee\" shown on the Bills 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.","Schlage Lock Co., LLC "]
[null,"ATTN: (Select ONE of the following):"]
[null,"11819 North Pennsylvania Street"]
[null,"Carmel, IN 46032 USA"]
[]
["UPS Small Package Account # :\n(Auto-fills once final destination is selected)",{"$f":"VLOOKUP($B$10,'US '!$A$1:$E$15,5,FALSE)","v":"UPS  < 65kgs"}]
[]
["Deliver To / Final Destination: ",{"$f":"VLOOKUP($B$10,'US '!A1:B15,2,FALSE)","v":"Deliver to:"}]
[null,{"$f":"VLOOKUP($B$10,'US '!A1:C15,3,FALSE)","v":"Address will auto-fill upon plant location 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:\nMichaela Ehrich  \n1930 Bishop Lane, Suite #200 \nLouisville, Kentucky  40218 \nTelephone:  502-485-2600 \nmichaelaehrich@ups.com \nUPSUSAllegion@ups.com"]
[]
["Special Requirements:      ","For ALL Shipments\n   *  Include NAME / TEL. of Buyer/Planner on Documentation\n\n"]

{"sheet":"air greater than 65 KGs","index":3,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,0,1,1],[0,0,0,1],[22,0,23,0],[14,0,18,0],[8,0,12,0]]}
["IMPORTS INTO THE US"]
["AIR SHIPMENTS GREATER THAN 65KGs "]
[]
["Air Courier:","UPS Supply Chain Solutions  (UPS - SCS)                                                                          "]
[]
["US Customs Broker:","International Automated Brokers (IAB)"]
[]
["Sold To/Consignee: \n\n\n"]
["NOTE:  The \"Sold To\" name and address shown on the Commercial Invoice and the \"Consignee\" shown on the Bills 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.","Schlage Lock Co., LLC"]
[]
[null,"ATTN: (Select ONE of the following):"]
[null,"11819 North Pennsylvania Street"]
[null,"Carmel, IN 46032 USA"]
[]
["Bill To:\n(Freight Plan # will auto-fill based on final destination selection)","Cass Information Systems "]
[null,"c/o Allegion"]
[null,{"$f":"VLOOKUP($B$11,'US '!$A$1:$D$15,4,FALSE)","v":"Freight Plan Number"}]
[null,"P.O. Box 67"]
[null,"St. Louis, MO 63166"]
[]
["UPS - SCS Account # :\n(Auto-fills once final destination is selected)",{"$f":"VLOOKUP($B$11,'US '!$A$1:$F$15,6,FALSE)","v":"UPS - SCS  > 65kgs"}]
[]
["Deliver To / Final Destination: ",{"$f":"VLOOKUP($B$11,'US '!$A$1:$C$15,2,FALSE)","v":"Deliver to:"}]
[null,{"$f":"VLOOKUP($B$11,'US '!$A$1:$C$15,3,FALSE)","v":"Address will auto-fill upon plant location 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: (619) 671-3186/ (619) 671-3185\nFax:  (619) 661-6490\n     \nEmail  the following: \nsgoding@iab-sd.com \njamesg@iab-sd.com\n"," "]
[]
["Special Requirements:      ","For ALL Shipments\n   *  Include NAME / TEL. of Buyer/Planner on Documentation\n\n\n"]
[]
[" For Booking UPS SCS Shipments","For Pickup Of All UPS-SCS Shipments\nPhone: 800-648-9333 or 913-693-6300 from outside the US\nEmail the following: AllegionGFF@ups.com  "]
[]
["UPS SCS Contact Escalation and Support","All intial inquiries should be sent to AllegionGFF@ups.com. \nFor escalations on day to day issues please contact the following: CustomerServ@ups.com.\n\nIf you encounter a situation that requires additional visibility or assistance, please contact\nBusiness Development team:\nDirreck Williams – DirreckWilliams@ups.com 803-240-2563 (UPS SCS)\nDon Anderson - DonAnderson@ups.com  317-796-7177 (UPS Small Package)\n\n"]
[]
["For UPS SCS Delivery Address Changes and 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 tracking number,  Allegion reference number, shipper, current consignee name, address and change details. "]