{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["FPN MX","ocean vessel","air under 65 KGs  ","air greater than 65 KGs "],"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":"FPN MX","index":0,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Choose from the following plant locations:","Address will auto-fill upon plant location selection","Freight Plan Number","DHL <65 KGs","UPS-SCS >65 KGs"]
["Ensenada Plant (ENS Residential)","Schlage de Mexico, S.A. de C.V. - Ensenada \nCarretera Transpeninsular KM 115 4580 Int 3, Col. Carlos Pacheco\nEnsenada, Baja California, 22890 Mexico ",72386,"964 990 311","703 075 465"]
["El Sauzal Plant (ENS Commercial )","Schlage de México, S.A. de C.V. – El Sauzal\nCarretera Transpeninsular KM 115 4580 Int 3, Col. Carlos Pacheco\nEnsenada, Baja California, 22890 Mexico",72387,"964 990 382","544 978 372"]
["Tecate Plant ","Schlage de México, S.A. de C.V. – Tecate\nCalle Los Olivos 698\nCol. Chávez, Tecate, Baja California,  21440 México ","03398","968 434 288","709 904 460"]
["Tijuana Plant","Schlage de México, S.A. de C.V. – Tijuana   \nBoulevard La Encantada, Industrial 24050\nParque Ind. Florido,  Tijuana, Baja California, 22680 México ","03362","969 603 498","709 904 478"]

{"sheet":"ocean vessel","index":1,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,0,1,3],[0,0,0,3],[31,0,32,0],[26,0,27,0],[34,1,34,3],[17,0,22,0]]}
["INBONDS TO SCHLAGE DE MEXICO "]
["OCEAN VESSEL SHIPMENTS "]
[]
[null,"Shipments with Invoice Value\nUNDER USD $1,000      \n(due to low value, these will be US Customs cleared)",null,"Shipments with Invoice Value\nEQUAL TO or OVER USD $1,000\n"," "]
[]
["Importer Security Filing (ISF) Filing Agent: ","Send ISF template for \"INBONDS to Mexico\"  to the filing agent below at least 72 hours in advance of sailing.  \nISF Filing Agent:   isf@iab-sd.com\nThe ISF contacts are Steve Goding and Edgar Cortes.\n",null,"Send ISF template for \"INBONDS to Mexico\"  to the filing agent below at least 72 hours in advance of sailing.  \nISF Filing Agent:   isf@iab-sd.com\nThe ISF contacts are Steve Goding and Edgar Cortes.\n"]
[]
["Freight Forwarder:","Kuehne + Nagel",null,"Kuehne + Nagel"]
[]
["US Customs Broker:","International Automated Brokers (IAB) - to clear",null,"Kuehne + Nagel - to cut T&E"]
[]
["Port of Discharge:","Long Beach, CA",null,"Long Beach, CA"]
[]
[null,"Schlage Lock Company, LLC",null,"Schlage Lock Company, LLC"]
["Sold To:","11819 N. Pennsylvania St.\nCarmel, IN 46032 USA",null,"11819 N. Pennsylvania St.\nCarmel, IN 46032 USA"]
[]
[]
["Bill To on BOL:\n(Freight Plan # will auto-fill based on final destination selection)","TRAX",null,"TRAX"]
[null,"c/o Allegion",null,"c/o Allegion"]
[null,{"$f":"VLOOKUP($B$27,'FPN MX'!$A$1:$C$5,3,FALSE)","v":"Freight Plan Number"},null,{"$f":"VLOOKUP($D$27,'FPN MX'!$A$1:$C$5,3,FALSE)","v":"Freight Plan Number"}]
[null,"14500 N. Northsight Blvd.",null,"14500 N. Northsight Blvd."]
[null,"Suite 113",null,"Suite 113"]
[null,"Scottsdale, AZ 85260-3659 USA",null,"Scottsdale, AZ 85260-3659 USA"]
[]
["Deliver To:","Brokerage & Logistic Solutions, Inc. (BLS)\n1659 Gailes Blvd.\nSan Diego, CA 92154\n",null,"International Automated Brokers, Inc. (IAB)\n1655 St. Andrews Cove\nSan Diego, CA  92154\n"]
[]
["Final Destination: ","Choose from the following plant locations:",null,"Choose from the following plant locations:"]
[null,{"$f":"VLOOKUP($B$27,'FPN MX'!$A$1:$C$5,2,FALSE)","v":"Address will auto-fill upon plant location selection"},null,{"$f":"VLOOKUP($D$27,'FPN MX'!$A$1:$C$5,2,FALSE)","v":"Address will auto-fill upon plant location selection"}]
[]
["Notify Parties:  \n\nEMAIL Following to Notify Parties:\n• Importer Security Filing (ISF)\n• commercial invoice\n• packing list\n• express bill of lading\n","1) Notify Party:\nInternational Automated Brokers, Inc. (IAB)                                  \n(ATTN: Steve Goding / James Goding / Edgar Cortes)\n\nEmail all of the following:                                                          \nsgoding@iab-sd.com\njamesg@iab-sd.com\nedgar.cortes@iab-sd.com\n\n2) Notify Party: \nBrokerage & Logistic Solutions, Inc. (BLS)\n(ATTN: Claudia Carrion/ Customer Service)   \n\nEmail all of the following:\nccarrion@ub.jdgroup.net\njmancillas@cd.jdgroup.net\ncustomerservice@cd.jdgroup.net",null,"1) Notify Party:\nKuehne & Nagel, Inc.\nATTN: Paige Perraino\n\nEmail the following:                                                          \nPaige.Perraino@kuehne-nagel.com\n\n2)  Notify Party:\nInternational Automated Brokers, Inc. (IAB)      \n(ATTN: Steve Goding / James Goding / Edgar Cortes)\n  \nEmail all of the following:\nsgoding@iab-sd.com\njamesg@iab-sd.com\nedgar.cortes@iab-sd.com"]
[]
["Special Requirements","Indicate on Documentation: ",null,"Include In-Bond Statement on all Documentation:"]
[null,"\"Value under $1,000, US Customs broker to file Informal Entry.\"\n",null,"\"Final Destination Mexico, moving In-Bond (via T&E) thru the U.S.\"\n"]
[]
["Additional Notify Parties"]

{"sheet":"air under 65 KGs  ","index":2,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,0,1,3],[0,0,0,3],[22,0,23,0],[18,0,19,0]]}
["INBONDS TO SCHLAGE DE MEXICO "]
["Air Shipments WEIGHING UNDER 65 KGs "]
[]
[null,"          Shipments with Invoice Value\n                      UNDER USD $800\n(Due to low value, these will be US Customs cleared)",null,"Shipments with Invoice Value\nEQUAL TO or OVER USD $800"," "]
[]
["Freight Forwarder:","DHL Express",null,"DHL Express"]
[]
["US Customs Broker:","DHL Express - to clear",null,"International Automated Brokers (IAB) - to cut T&E"]
[]
["Port of Discharge:","San Diego, CA",null,"San Diego, CA"]
[]
[null,"Schlage Lock Company, LLC",null,"Schlage Lock Company, LLC"]
["Sold To: ","11819 N. Pennsylvania St.\nCarmel, IN 46032 USA",null,"11819 N. Pennsylvania St.\nCarmel, IN 46032 USA"]
[]
["DHL Small Package Account # :\n(Auto-fills once final destination is selected)",{"$f":"VLOOKUP($B$19,'FPN MX'!$A$1:$D$5,4,FALSE)","v":"DHL <65 KGs"},null,{"$f":"VLOOKUP($D$19,'FPN MX'!$A$1:$D$5,4,FALSE)","v":"DHL <65 KGs"}]
[]
["Deliver To:","Brokerage & Logistic Solutions, Inc. (BLS)\n1659 Gailes Blvd.\nSan Diego, CA 92154\n",null,"International Automated Brokers, Inc. (IAB)\n1655 St. Andrews Cove\nSan Diego, CA  92154\n"]
[]
["Final Destination: ","Choose from the following plant locations:",null,"Choose from the following plant locations:"]
[null,{"$f":"VLOOKUP($B$19,'FPN MX'!$A$1:$D$5,2,FALSE)","v":"Address will auto-fill upon plant location selection"},null,{"$f":"VLOOKUP($D$19,'FPN MX'!$A$1:$D$5,2,FALSE)","v":"Address will auto-fill upon plant location selection"}]
["Notify Parties:  \n\nEMAIL Following to Notify Parties:\n\n• commercial invoice\n• packing list\n• express bill of lading\n","1) Notify Party:\nDHL Express\n(ATTN:  Control Tower)\n\nEmail all of the following:\ncvgcontroltower@dhl.com\n\n2) Notify Party:\nBrokerage & Logistic Solutions, Inc. (BLS)\n(ATTN: Claudia Carrion/ Customer Service)                                                                                                                                                                                                                                                                              \n                                                                                                                                                                                                                                                                                                                                           Email all of the following:\nccarrion@ub.jdgroup.net\njmancillas@cd.jdgroup.net\ncustomerservice@cd.jdgroup.net\n\n",null,"1) Notify Party:\nInternational Automated Brokers, Inc. (IAB)\n(ATTN: Steven Goding / James Goding / Edgar Cortes)\n\nEmail all of the following: \nsgoding@iab-sd.com \njamesg@iab-sd.com\nedgar.cortes@iab-sd.com\n "]
[]
["Special Requirements:","Indicate on Documentation: ",null,"Indicate on Documentation: "]
[null,"\"Value under $800, US Customs broker to file Entry.\"\n",null,"\"Value over $800, IAB to file T&E.\"\n"]

{"sheet":"air greater than 65 KGs ","index":3,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[[11,0,12,0],[14,0,19,0],[1,0,1,3],[0,0,0,3],[30,0,31,0],[25,0,26,0]]}
["INBONDS TO SCHLAGE DE MEXICO "]
["Air Shipments WEIGHING GREATER THAN 65 KGs "]
[]
[null,"Shipments with Invoice Value\nUNDER USD $1,000      \n(Due to low value, these will be US Customs cleared)",null,"Shipments with Invoice Value\nEQUAL TO or OVER USD $1,000"," "]
[]
["Freight Forwarder:","UPS Supply Chain Solutions (UPS-SCS)",null,"UPS Supply Chain Solutions (UPS-SCS)"]
[]
["US Customs Broker:","International Automated Brokers (IAB) - to clear",null,"International Automated Brokers (IAB) - to cut T&E"]
[]
["Port of Discharge:","San Diego, CA",null,"San Diego, CA"]
[]
["Sold To:","Schlage Lock Company, LLC",null,"Schlage Lock Company, LLC"]
[null,"11819 N. Pennsylvania St.\nCarmel, IN 46032 USA",null,"11819 N. Pennsylvania St.\nCarmel, IN 46032 USA"]
[]
["Bill To on AWB:\n(Freight Plan # will auto-fill based on final destination selection)","Allegion",null,"Allegion"]
[null,"c/o Körber Supply Chain",null,"c/o Körber Supply Chain"]
[null,{"$f":"VLOOKUP($B$26,'FPN MX'!$A$1:$E$5,3,FALSE)","v":"Freight Plan Number"},null,{"$f":"VLOOKUP($D$26,'FPN MX'!$A$1:$E$5,3,FALSE)","v":"Freight Plan Number"}]
[null,"11555 N Meridian St",null,"11555 N Meridian St"]
[null,"STE 200",null,"STE 200"]
[null,"Carmel IN, 46032 USA",null,"Carmel IN, 46032 USA"]
[]
["UPS SCS Account #:\n(Auto-fills once final destination is selected)",{"$f":"VLOOKUP($B$26,'FPN MX'!$A$1:$E$5,5,FALSE)","v":"UPS-SCS >65 KGs"},null,{"$f":"VLOOKUP($D$26,'FPN MX'!$A$1:$E$5,5,FALSE)","v":"UPS-SCS >65 KGs"}]
[]
["Deliver To:","Brokerage & Logistic Solutions, Inc. (BLS)\n1659 Gailes Blvd.\nSan Diego, CA 92154\n",null,"International Automated Brokers, Inc. (IAB)\n1655 St. Andrews Cove\nSan Diego, CA  92154\n"]
[]
["Final Destination: ","Choose from the following plant locations:",null,"Choose from the following plant locations:"]
[null,{"$f":"VLOOKUP($B$26,'FPN MX'!$A$1:$D$5,2,FALSE)","v":"Address will auto-fill upon plant location selection"},null,{"$f":"VLOOKUP($D$26,'FPN MX'!$A$1:$D$5,2,FALSE)","v":"Address will auto-fill upon plant location selection"}]
[]
["Notify Parties:  \n\nEMAIL Following to Notify Parties:\n• commercial invoice\n• packing list\n• express bill of lading\n","1) Notify Party:\nInternational Automated Brokers, Inc. (IAB)                                  \n(ATTN: Steve Goding / James Goding / Edgar Cortes)\n\nEmail all of the following:                                                          \nsgoding@iab-sd.com\njamesg@iab-sd.com\nedgar.cortes@iab-sd.com\n\n2) Notify Party: \nBrokerage & Logistic Solutions, Inc. (BLS)\n(ATTN: Claudia Carrion/ Customer Service)   \n\nEmail all of the following:\nccarrion@ub.jdgroup.net\njmancillas@cd.jdgroup.net\ncustomerservice@cd.jdgroup.net",null,"1) Notify Party:\nInternational Automated Brokers, Inc. (IAB)                                  \n(ATTN: Steve Goding / James Goding / Edgar Cortes)\n\nEmail all of the following:                                                          \nsgoding@iab-sd.com\njamesg@iab-sd.com\nedgar.cortes@iab-sd.com"]
[]
["Special Requirements:","Indicate on Documentation: ",null,"Include In-Bond Statement on all Documentation:"]
[null,"\"Value under $1,000, US Customs broker to file Informal Entry.\"\n",null,"\"Final Destination Mexico, moving In-Bond (via T&E) thru the U.S.\"\n"]