{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["North America Transit Time","International Transit Time","ASN Instructions","Drop Ship Instructions","AFL ROUTING GUIDE","Codes and Maps"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":1,"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":"North America Transit Time","index":0,"n_rows":42,"n_cols":62,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,0,2,8],[4,3,4,6]]}
["AFL TELECOMMUNICATIONS \nNORTH AMERICA ROUTING GUIDE - LTL / TL / PARCEL"]
[]
[]
[]
[null,"Projected Ship Date","2023-12-16","Enter Projected Ship Date here to populate promise date below. Use Date format MM/DD/YYYY ie. 03/25/2023",null,null,null,null,null,null,null,null,"Duncan"]
[null,null,null,"Instructions",null,null,null,null,null,"Duncan",null,null,"Parcel"]
[null,"AFL Destination City, State","Duncan, SC","1) Check AFL PO Document for Ship To City, State",null,null,null,null,null,"Parcel",{"$f":"HLOOKUP($C$8,M7:BJ8,2,FALSE)","v":2},null,"AL","AK","AZ","AR","CA","CO","CT","DE","FL","GA","HI","ID","IL","IN","IA","KS","KY","LA","ME","MD","MA","MI","MN","MS","MO","MT","NE","NV","NH","NJ","NM","NY","NC","ND","OH","OK","OR","PA","RI","SC","SD","TN","TX","UT","VT","VA","WA","WV","WI","WY"]
[null,"Origin State","LA","2) Click on the drop down box and select Origin State/Ship from State",null,null,null,null,null,"LTL",{"$f":"HLOOKUP($C$8,M11:BJ12,2,FALSE)","v":3},null,1.1961414790996785,6.5,3.6886792452830188,3.0727272727272728,3.6194029850746268,2.2272727272727271,1.7210332103321033,1,1.8870967741935485,1.1196350118283205,1.6666666666666667,4.625,1.9948630136986301,1.8951048951048952,2.9056603773584904,2.48,1.5657894736842106,2,2.97,1.9946524064171123,1.9717362045760431,2.0028409090909092,3.0625,2.1304347826086958,2.2713936430317849,3.1666666666666665,2.774193548387097,4.0733944954128436,2.274468085106383,2.0095238095238095,3.7,2.4430217669654288,1.0721153846153846,3.1139240506329116,1.9965469613259668,2.342857142857143,4.1067961165048548,2.0275482093663912,2.0938967136150235,1.2285714285714286,3.1428571428571428,1.6183206106870229,2.3918299291371405,3.8472222222222223,3.0833333333333335,1.6923076923076923,2.8752783964365256,1.9090909090909092,2.7936507936507935,4.25]
[null,null,null,null,null,null,null,null,null,"TL",{"$f":"HLOOKUP($C$8,M15:BJ16,2,FALSE)","v":2}]
[null,"Ship Method","TL","3) Click on the drop down box and select shipment mode",null,null,null,null,null,null,null,null,"LTL"]
[null,"Average Transit Time",{"$f":"VLOOKUP($C$10,J7:K9,2,FALSE)","v":2},null,null,null,null,null,null,null,null,null,"AL","AK","AZ","AR","CA","CO","CT","DE","FL","GA","HI","ID","IL","IN","IA","KS","KY","LA","ME","MD","MA","MI","MN","MS","MO","MT","NE","NV","NH","NJ","NM","NY","NC","ND","OH","OK","OR","PA","RI","SC","SD","TN","TX","UT","VT","VA","WA","WV","WI","WY"]
[null,"Average Transit Days",{"$f":"ROUNDUP(C11,0)","v":2},null,null,null,null,null,null,null,null,null,2,10,6,2,6,4,4,3,3,2,8,8,4,4,4,6,3,3,3,2,4,4,4,3,4,6,6,7,5,4,5,4,2,4,4,6,7,4,4,2,4,2,5,5,3,2,7,2,4,5]
[null,"Promise Date",{"$f":"WORKDAY($C$5,C12)","v":"2023-12-19"},"4) Enter date shown here as the promise date in supplier portal"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"AL","AK","AZ","AR","CA","CO","CT","DE","FL","GA","HI","ID","IL","IN","IA","KS","KY","LA","ME","MD","MA","MI","MN","MS","MO","MT","NE","NV","NH","NJ","NM","NY","NC","ND","OH","OK","OR","PA","RI","SC","SD","TN","TX","UT","VT","VA","WA","WV","WI","WY"]
[null,null,null,null,null,null,null,null,null,null,null,null,1,10,4,2,5,4,2,2,2,1,8,4,2,2,2,2,2,2,2,1,2,2,2,2,2,4,3,4,3,1,4,1,1,5,2,3,5,2,2,1,3,1,2,4,2,1,6,1,2,4]
[null,null,null,"Instructions"]
[null,"AFL Destination City, State","Laredo, TX","1) Check AFL PO Document for Ship To City, State",null,null,null,null,null,null,null,null,"Laredo"]
[null,"Origin State","CA","2) Click on the drop down box and select Origin State/Ship from State",null,null,null,null,null,"Laredo",null,null,"Parcel"]
[null,null,null,null,null,null,null,null,null,"Parcel",{"$f":"HLOOKUP($C$19,M20:BJ21,2,FALSE)","v":3.0194552529182879},null,"AL","AK","AZ","AR","CA","CO","CT","DE","FL","GA","HI","ID","IL","IN","IA","KS","KY","LA","ME","MD","MA","MI","MN","MS","MO","MT","NE","NV","NH","NJ","NM","NY","NC","ND","OH","OK","OR","PA","RI","SC","SD","TN","TX","UT","VT","VA","WA","WV","WI","WY"]
[null,"Ship Method","Parcel","3) Click on the drop down box and select shipment mode",null,null,null,null,null,"LTL",{"$f":"HLOOKUP($C$19,M24:BJ25,2,FALSE)","v":6},null,2.6979166666666701,null,2.3095238095238093,null,3.0194552529182879,2.0469565217391303,4.4470046082949306,null,2.0485074626865671,2.1057082452431288,null,null,3.0183098591549298,3.2487562189054726,null,2.1071428571428572,3.2352941176470589,null,4.2222222222222223,3.625,3.5715835140997831,3.6654411764705883,2.8047808764940241,1.8,2.5436893203883497,2.6666666666666665,1.0923076923076922,2.6233766233766236,4.333333333333333,3.0560578661844486,2.0769230769230771,3.3237179487179489,2.778541226215645,3,3.0088852988691439,1,4.0263157894736841,3.613793103448276,4.4814814814814818,2.2129518072289156,null,1.9666666666666666,1.7925591882750846,3,null,2.56,2.9403553299492384,null,3.081967213114754]
[null,"Average Transit Time",{"$f":"VLOOKUP($C$21,J20:K22,2,FALSE)","v":3.0194552529182879},null,null,null,null,null,null,"TL",{"$f":"HLOOKUP($C$19,M28:BJ29,2,FALSE)","v":3}]
[null,"Average Transit Days",{"$f":"ROUNDUP(C22,0)","v":4},null,null,null,null,null,null,null,null,null,"LTL"]
[null,"Promise Date",{"$f":"WORKDAY(C5,C23)","v":"2023-12-21"},"4) Enter date shown here as the promise date in supplier portal",null,null,null,null,null,null,null,null,"AL","AK","AZ","AR","CA","CO","CT","DE","FL","GA","HI","ID","IL","IN","IA","KS","KY","LA","ME","MD","MA","MI","MN","MS","MO","MT","NE","NV","NH","NJ","NM","NY","NC","ND","OH","OK","OR","PA","RI","SC","SD","TN","TX","UT","VT","VA","WA","WV","WI","WY"]
[null,null,null,null,null,null,null,null,null,null,null,null,4,null,6,null,6,4,null,4,5,5,null,null,6,6,5,4,null,null,null,7,7,5,6,4,2,null,5,null,6,6,null,6,5,null,6,null,null,4,null,5,null,5,2,null,null,5,6,7,6]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"TL"]
[null,null,null,"Instructions",null,null,null,null,null,null,null,null,"AL","AK","AZ","AR","CA","CO","CT","DE","FL","GA","HI","ID","IL","IN","IA","KS","KY","LA","ME","MD","MA","MI","MN","MS","MO","MT","NE","NV","NH","NJ","NM","NY","NC","ND","OH","OK","OR","PA","RI","SC","SD","TN","TX","UT","VT","VA","WA","WV","WI","WY"]
[null,"AFL Destination City, State","Kent, WA","1) Check AFL PO Document for Ship To City, State",null,null,null,null,null,null,null,null,null,null,null,null,3,3,null,null,null,null,null,null,3,3,4,null,1,null,null,null,null,3,null,null,null,null,3,3,null,3,null,null,3,null,3,null,null,null,null,3,3,2,null,3,null,null,4,null,2]
[null,"Origin State","MA","2) Click on the drop down box and select Origin State/Ship from State"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Kent"]
[null,"Ship Method","LTL","3) Click on the drop down box and select shipment mode",null,null,null,null,null,"Kent",null,null,"Parcel"]
[null,"Average Transit Time",{"$f":"VLOOKUP($C$32,J33:K35,2,FALSE)","v":9},null,null,null,null,null,null,"Parcel",{"$f":"HLOOKUP($C$30,M33:BJ34,2,FALSE)","v":5.229166666666667},null,"AL","AK","AZ","AR","CA","CO","CT","DE","FL","GA","HI","ID","IL","IN","IA","KS","KY","LA","ME","MD","MA","MI","MN","MS","MO","MT","NE","NV","NH","NJ","NM","NY","NC","ND","OH","OK","OR","PA","RI","SC","SD","TN","TX","UT","VT","VA","WA","WV","WI","WY"]
[null,"Average Transit Days",{"$f":"ROUNDUP(C33,0)","v":9},null,null,null,null,null,null,"LTL",{"$f":"HLOOKUP($C$30,M37:BJ38,2,FALSE)","v":9},null,4,4.5999999999999996,3.2879409351927809,null,2.9115426105717366,3.3043478260869565,5.322916666666667,null,4.6190476190476186,4.1758241758241761,null,2.4444444444444446,3.9324324324324325,6,3.5,3.7894736842105261,4.0178571428571432,4,null,5.083333333333333,5.229166666666667,4.0999999999999996,2.8648648648648649,null,3.3720930232558142,null,3.5806451612903225,2.36,3.8,4.1528662420382165,3.6666666666666665,4.4132231404958677,4.1828193832599121,2.625,4.2413793103448274,4,1.4571428571428571,5.0221238938053094,5.75,4.4109589041095889,null,2.7333333333333334,4.0142397795130913,2.7857142857142856,null,4.2727272727272725,2.677378701953371,null,3.263157894736842,3]
[null,"Promise Date",{"$f":"WORKDAY(C5,C34)","v":"2023-12-28"},"4) Enter date shown here as the promise date in supplier portal",null,null,null,null,null,"TL",{"$f":"HLOOKUP($C$30,M41:BJ42,2,FALSE)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"LTL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"AL","AK","AZ","AR","CA","CO","CT","DE","FL","GA","HI","ID","IL","IN","IA","KS","KY","LA","ME","MD","MA","MI","MN","MS","MO","MT","NE","NV","NH","NJ","NM","NY","NC","ND","OH","OK","OR","PA","RI","SC","SD","TN","TX","UT","VT","VA","WA","WV","WI","WY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,5,null,8,null,null,11,null,null,6,8,6,7,null,null,null,null,9,null,null,null,null,null,6,null,null,8,null,8,8,null,null,null,1,9,null,8,null,null,8,null,null,null,2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"TL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"AL","AK","AZ","AR","CA","CO","CT","DE","FL","GA","HI","ID","IL","IN","IA","KS","KY","LA","ME","MD","MA","MI","MN","MS","MO","MT","NE","NV","NH","NJ","NM","NY","NC","ND","OH","OK","OR","PA","RI","SC","SD","TN","TX","UT","VT","VA","WA","WV","WI","WY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,6,null,null,5,null,null,3,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,3,null,null,null,null,5,null,null,5,1]

{"sheet":"International Transit Time","index":1,"n_rows":45,"n_cols":57,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,0,2,8],[4,3,4,6]]}
["AFL TELECOMMUNICATIONS \nINTERNATIONAL ROUTING GUIDE - PARCEL / AIR / OCEAN"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Duncan"]
[]
[null,"Projected Ship Date",null,"Enter Projected Ship Date here to populate promise date below. Use Date format MM/DD/YYYY ie. 03/25/2023",null,null,null,null,null,"Duncan",null,null,"Parcel"]
[null,null,null,"Instructions",null,null,null,null,null,"Parcel",{"$f":"HLOOKUP($C$8,M6:BE7,2,FALSE)","v":2.4678899082568808},null,"United Arab Emirates","Austria","Australia","Brazil","Belgium","Cambodia","Canada","Switzerland","China","Czechia","Germany","Denmark","Dominican Republic","Egypt","Spain","Finland","France","United Kingdom","Hong Kong","Indonesia","Ireland","Israel","India","Italy","Japan","Cambodia","Korea","Kuwait","Lithuania","Latvia","Macao","Mexico","Malaysia","Netherlands","Philippines","Poland","Puerto Rico","Sweden","Singapore","Slovakia","South Korea","Thailand","Turkey","Taiwan","Vietnam"]
[null,"AFL Destination City, State","Duncan, SC","1) Check AFL PO Document for Ship To City, State",null,null,null,null,null,"LCL",{"$f":"HLOOKUP($C$8,M9:BE10,2,FALSE)","v":24},null,4.333333333333333,2.4678899082568808,4,null,null,null,4.6788990825688073,3.8888888888888888,3.7429871114480666,5,2.7831325301204819,2,3,5,13,2.6058823529411765,2,3.893939393939394,4.0909090909090908,null,4,7.75,4.9615384615384617,7,2.0266286257727057,7,2.5,5,3.3002207505518766,4,3,2.44,1,2.5909090909090908,7,6,null,3.9693877551020407,3.3333333333333335,1.5,null,3.3576526566217288,3,3.1818181818181817,4.0816326530612246]
[null,"Origin Country","Austria","2) Click on the drop down box and select Origin Country",null,null,null,null,null,"FCL",{"$f":"HLOOKUP($C$8,M12:BE13,2,FALSE)","v":0},null,"LCL"]
[null,null,null,null,null,null,null,null,null,"AIR Freight",{"$f":"HLOOKUP($C$8,M15:BE16,2,FALSE)","v":7},null,"United Arab Emirates","Austria","Australia","Brazil","Belgium","Cambodia","Canada","Switzerland","China","Czechia","Germany","Denmark","Dominican Republic","Egypt","Spain","Finland","France","United Kingdom","Hong Kong","Indonesia","Ireland","Israel","India","Italy","Japan","Cambodia","Korea","Kuwait","Lithuania","Latvia","Macao","Mexico","Malaysia","Netherlands","Philippines","Poland","Puerto Rico","Sweden","Singapore","Slovakia","South Korea","Thailand","Turkey","Taiwan","Vietnam"]
[null,"Ship Method","LCL","3) Click on the drop down box and select shipment mode",null,null,null,null,null,null,null,null,null,24,null,null,null,null,null,null,39,null,20,null,null,null,null,null,null,21,null,null,null,null,51,null,26,null,31,null,null,null,null,null,null,null,null,null,null,null,null,null,31]
[null,"Average Transit Time",{"$f":"VLOOKUP($C$10,J6:K9,2,FALSE)","v":24},null,null,null,null,null,null,null,null,null,"FCL"]
[null,"Average Transit Days",{"$f":"ROUNDUP(C11,1)","v":24},null,null,null,null,null,null,null,null,null,"United Arab Emirates","Austria","Australia","Brazil","Belgium","Cambodia","Canada","Switzerland","China","Czechia","Germany","Denmark","Dominican Republic","Egypt","Spain","Finland","France","United Kingdom","Hong Kong","Indonesia","Ireland","Israel","India","Italy","Japan","Cambodia","Korea","Kuwait","Lithuania","Latvia","Macao","Mexico","Malaysia","Netherlands","Philippines","Poland","Puerto Rico","Sweden","Singapore","Slovakia","South Korea","Thailand","Turkey","Taiwan","Vietnam"]
[null,"Promise Date",{"$f":"WORKDAY($C$5,C12)","v":"1900-02-02"},"4) Enter date shown here as the promise date in supplier portal",null,null,null,null,null,null,null,null,null,null,null,null,16,null,null,null,38,null,17,null,null,null,null,null,null,14,null,null,null,null,null,null,37,null,42]
[null,null,null,null,null,null,null,null,null,null,null,null,"Air"]
[null,null,null,null,null,null,null,null,null,null,null,null,"United Arab Emirates","Austria","Australia","Brazil","Belgium","Cambodia","Canada","Switzerland","China","Czechia","Germany","Denmark","Dominican Republic","Egypt","Spain","Finland","France","United Kingdom","Hong Kong","Indonesia","Ireland","Israel","India","Italy","Japan","Cambodia","Korea","Kuwait","Lithuania","Latvia","Macao","Mexico","Malaysia","Netherlands","Philippines","Poland","Puerto Rico","Sweden","Singapore","Slovakia","South Korea","Thailand","Turkey","Taiwan","Vietnam"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,7,6,null,null,null,null,null,4,null,3,null,null,null,null,5,null,4,7,null,null,null,7,9,11,null,9,null,21]
[null,null,null,"Instructions"]
[null,"AFL Destination City, State","Laredo, TX","1) Check AFL PO Document for Ship To City, State",null,null,null,null,null,null,null,null,"Laredo"]
[null,"Origin Country","China","2) Click on the drop down box and select Origin Country",null,null,null,null,null,"Laredo",null,null,"Parcel"]
[null,null,null,null,null,null,null,null,null,"Parcel",{"$f":"HLOOKUP($C$19,M20:BE21,2,FALSE)","v":5.3432084963666853},null,"United Arab Emirates","Austria","Australia","Brazil","Belgium","Cambodia","Canada","Switzerland","China","Czechia","Germany","Denmark","Dominican Republic","Egypt","Spain","Finland","France","United Kingdom","Hong Kong","Indonesia","Ireland","Israel","India","Italy","Japan","Cambodia","Korea","Kuwait","Lithuania","Latvia","Macao","Mexico","Malaysia","Netherlands","Philippines","Poland","Puerto Rico","Sweden","Singapore","Slovakia","South Korea","Thailand","Turkey","Taiwan","Vietnam"]
[null,"Ship Method","Air Freight","3) Click on the drop down box and select shipment mode",null,null,null,null,null,"LCL",{"$f":"HLOOKUP($C$19,M23:BE24,2,FALSE)","v":50},null,null,null,4.6842105263157894,null,null,null,6.4577922077922079,null,5.3432084963666853,null,null,null,null,null,null,null,null,2.5,2.9651457541191379,3,null,null,null,null,2.2624113475177303,2.8285714285714287,null,null,null,null,null,3.3250000000000002,null,1.5,null,null,null,6.6923076923076925,4,null,null,null,null,2.9249999999999998,4.7006369426751595]
[null,"Average Transit Time",{"$f":"VLOOKUP($C$21,J20:K23,2,FALSE)","v":6},null,null,null,null,null,null,"FCL",{"$f":"HLOOKUP($C$19,M26:BE27,2,FALSE)","v":66},null,"LCL"]
[null,"Average Transit Days",{"$f":"ROUNDUP(C22,0)","v":6},null,null,null,null,null,null,"AIR Freight",{"$f":"HLOOKUP($C$19,M29:BE30,2,FALSE)","v":6},null,"United Arab Emirates","Austria","Australia","Brazil","Belgium","Cambodia","Canada","Switzerland","China","Czechia","Germany","Denmark","Dominican Republic","Egypt","Spain","Finland","France","United Kingdom","Hong Kong","Indonesia","Ireland","Israel","India","Italy","Japan","Cambodia","Korea","Kuwait","Lithuania","Latvia","Macao","Mexico","Malaysia","Netherlands","Philippines","Poland","Puerto Rico","Sweden","Singapore","Slovakia","South Korea","Thailand","Turkey","Taiwan","Vietnam"]
[null,"Promise Date",{"$f":"WORKDAY($C$5,C23)","v":"1900-01-09"},"4) Enter date shown here as the promise date in supplier portal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,null,null,null,null,null,null,null,null,null,45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,65]
[null,null,null,null,null,null,null,null,null,null,null,null,"FCL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"United Arab Emirates","Austria","Australia","Brazil","Belgium","Cambodia","Canada","Switzerland","China","Czechia","Germany","Denmark","Dominican Republic","Egypt","Spain","Finland","France","United Kingdom","Hong Kong","Indonesia","Ireland","Israel","India","Italy","Japan","Cambodia","Korea","Kuwait","Lithuania","Latvia","Macao","Mexico","Malaysia","Netherlands","Philippines","Poland","Puerto Rico","Sweden","Singapore","Slovakia","South Korea","Thailand","Turkey","Taiwan","Vietnam"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52]
[null,null,null,"Instructions",null,null,null,null,null,null,null,null,"Air"]
[null,"AFL Destination City, State","Kent, WA","1) Check AFL PO Document for Ship To City, State",null,null,null,null,null,null,null,null,"United Arab Emirates","Austria","Australia","Brazil","Belgium","Cambodia","Canada","Switzerland","China","Czechia","Germany","Denmark","Dominican Republic","Egypt","Spain","Finland","France","United Kingdom","Hong Kong","Indonesia","Ireland","Israel","India","Italy","Japan","Cambodia","Korea","Kuwait","Lithuania","Latvia","Macao","Mexico","Malaysia","Netherlands","Philippines","Poland","Puerto Rico","Sweden","Singapore","Slovakia","South Korea","Thailand","Turkey","Taiwan","Vietnam"]
[null,"Origin Country","South Korea","2) Click on the drop down box and select Origin Country",null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,null,6,null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,5,null,null,null,null,null,null,null,null,null,null,16,null,null,null,null,null,null,null,4,8]
[]
[null,"Ship Method","Parcel","3) Click on the drop down box and select shipment mode"]
[null,"Average Transit Time",{"$f":"VLOOKUP($C$32,J35:K38,2,FALSE)","v":0},null,null,null,null,null,null,null,null,null,"Kent"]
[null,"Average Transit Days",{"$f":"ROUNDUP(C33,0)","v":0},null,null,null,null,null,null,"Kent",null,null,"Parcel"]
[null,"Promise Date",{"$f":"WORKDAY($C$5,C34)","v":"00:00:00"},"4) Enter date shown here as the promise date in supplier portal",null,null,null,null,null,"Parcel",{"$f":"HLOOKUP($C$30,M38:BE39,2,FALSE)","v":0},null,"United Arab Emirates","Austria","Australia","Brazil","Belgium","Cambodia","Canada","Switzerland","China","Czechia","Germany","Denmark","Dominican Republic","Egypt","Spain","Finland","France","United Kingdom","Hong Kong","Indonesia","Ireland","Israel","India","Italy","Japan","Cambodia","Korea","Kuwait","Lithuania","Latvia","Macao","Mexico","Malaysia","Netherlands","Philippines","Poland","Puerto Rico","Sweden","Singapore","Slovakia","South Korea","Thailand","Turkey","Taiwan","Vietnam"]
[null,null,null,null,null,null,null,null,null,"LCL",{"$f":"HLOOKUP($C$30,M38:BE39,2,FALSE)","v":0},null,null,null,null,3,null,null,6,null,4.382645803698435,null,3,null,null,null,null,null,null,2.9696969696969697,2.7,null,2,null,8,null,2.3090909090909091,2.6363636363636362,3,null,null,null,null,null,2.4,5.083333333333333,null,null,3.3076923076923075,2,5,null,null,3.3333333333333335,null,3,3.5038314176245211]
[null,null,null,null,null,null,null,null,null,"FCL",{"$f":"HLOOKUP($C$30,M41:BE42,2,FALSE)","v":0},null,"LCL"]
[null,null,null,null,null,null,null,null,null,"AIR Freight",{"$f":"HLOOKUP($C$30,M44:BE45,2,FALSE)","v":0},null,"United Arab Emirates","Austria","Australia","Brazil","Belgium","Cambodia","Canada","Switzerland","China","Czechia","Germany","Denmark","Dominican Republic","Egypt","Spain","Finland","France","United Kingdom","Hong Kong","Indonesia","Ireland","Israel","India","Italy","Japan","Cambodia","Korea","Kuwait","Lithuania","Latvia","Macao","Mexico","Malaysia","Netherlands","Philippines","Poland","Puerto Rico","Sweden","Singapore","Slovakia","South Korea","Thailand","Turkey","Taiwan","Vietnam"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,null,null,null,null,null,null,null,null,null,45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,65]
[null,null,null,null,null,null,null,null,null,null,null,null,"FCL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"United Arab Emirates","Austria","Australia","Brazil","Belgium","Cambodia","Canada","Switzerland","China","Czechia","Germany","Denmark","Dominican Republic","Egypt","Spain","Finland","France","United Kingdom","Hong Kong","Indonesia","Ireland","Israel","India","Italy","Japan","Cambodia","Korea","Kuwait","Lithuania","Latvia","Macao","Mexico","Malaysia","Netherlands","Philippines","Poland","Puerto Rico","Sweden","Singapore","Slovakia","South Korea","Thailand","Turkey","Taiwan","Vietnam"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,null,null,null,null,null,null,null,null,21,null,null,null,null,null,null,34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54]
[null,null,null,null,null,null,null,null,null,null,null,null,"Air"]
[null,null,null,null,null,null,null,null,null,null,null,null,"United Arab Emirates","Austria","Australia","Brazil","Belgium","Cambodia","Canada","Switzerland","China","Czechia","Germany","Denmark","Dominican Republic","Egypt","Spain","Finland","France","United Kingdom","Hong Kong","Indonesia","Ireland","Israel","India","Italy","Japan","Cambodia","Korea","Kuwait","Lithuania","Latvia","Macao","Mexico","Malaysia","Netherlands","Philippines","Poland","Puerto Rico","Sweden","Singapore","Slovakia","South Korea","Thailand","Turkey","Taiwan","Vietnam"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,7,null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,6]

{"sheet":"ASN Instructions","index":2,"n_rows":35,"n_cols":2,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,"AFL Routed Freight Required Fields:"]
[null,"Uber Freight / Transplace (LTL/TL- North America) (Collect/TP terms)"]
[null,"▪ Shipment number (to be provided by Uber Freight a.k.a ME #)"]
[null,"▪ Shipment date (ship date on BOL)"]
[null,"▪ Expected receipt date (delivery date based on published transit time matrix)"]
[null,"▪ Add Waybill/Airbill Number (Note: Enter Carrier + Tracking number)- If Tracking not available at the time of the ASN Enter: \"Tracking Unavailable” "]
[]
[null,"Noatum (Ocean/Air) (E&F INCOTERMS)"]
[null,"▪ Shipment number (MIQ Reference- starts with S)"]
[null,"▪ Shipment date (ship date on BL)"]
[null,"▪ Expected receipt date (delivery date based on published transit time matrix)"]
[null,"▪ Add Waybill/Airbill Number (Note: Enter Carrier + Tracking number)- If Tracking not available at the time of the ASN Enter: \"Tracking Unavailable” "]
[]
[null,"UPS (Parcel) (Collect/TP terms- DOM) (E&F INCOTERMS- INTL)"]
[null,"▪ Shipment number (parcel tracking #)"]
[null,"▪ Shipment date (ship date on BL)"]
[null,"▪ Expected receipt date (delivery date based on published transit time matrix)"]
[null,"▪ Add Waybill/Airbill Number (Note: Enter Carrier + Tracking number)- If Tracking not available at the time of the ASN Enter: \"Tracking Unavailable” "]
[]
[null,"Non-AFL Routed Freight Required Fields:"]
[null,"PP / PP&A TERMS (DOMESTIC)"]
[null,"▪ Shipment number (packing slip/commercial invoice #)"]
[null,"▪ Shipment date (ship date on BL)"]
[null,"▪ Expected receipt date"]
[null,"▪ Add Waybill/Airbill Number (Note: Enter Carrier + Tracking number)- If Tracking not available at the time of the ASN Enter: \"Tracking Unavailable” "]
[]
[null,"D&C TERMS (INTL)"]
[null,"▪ Shipment number (packing slip/commercial invoice #)"]
[null,"▪ Shipment date (ship date on BL)"]
[null,"▪ Expected receipt date"]
[null,"▪ Add Waybill/Airbill Number (Note: Enter Carrier + Tracking number)- If Tracking not available at the time of the ASN Enter: \"Tracking Unavailable” "]
[]
[null,"ASN Shipment Lines:"]
[null,"Suppliers must input COO (Country of Origin) at the line level."]
[null,"Suppliers to provide tracking numbers, if present, and comments need to include carrier name (ex. LTL, TL, steamship line)"]

{"sheet":"Drop Ship Instructions","index":3,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,"DROP SHIP INSTRUCTIONS"]
[null,"If PO document states \"Drop Ship\" or is not delivering to AFL in Kent, Laredo, or Duncan - please follow below instructions"]
[null,"AFL Routed Freight Required Fields:"]
[null,"Uber Freight / Transplace (LTL/TL- North America) (Collect/TP terms)"]
[null,"▪ Shipment number (to be provided by Uber Freight a.k.a ME #)"]
[null,"▪ Shipment date (ship date on BOL)"]
[null,"▪ Expected receipt date - include AFL-Logistics@aflglobal.com on pickup request for expected receipt date"]
[null,"▪ Add Waybill/Airbill Number (Note: Enter Carrier + Tracking number)- If Tracking not available at the time of the ASN Enter: \"Tracking Unavailable” "]
[]
[null,"Noatum (Ocean/Air) (E&F INCOTERMS)"]
[null,"▪ Shipment number (MIQ Reference- starts with S)"]
[null,"▪ Shipment date (ship date on BL)"]
[null,"▪ Expected receipt date - include AFL-Logistics@aflglobal.com on pickup request for expected receipt date"]
[null,"▪ Add Waybill/Airbill Number (Note: Enter Carrier + Tracking number)- If Tracking not available at the time of the ASN Enter: \"Tracking Unavailable” "]
[]
[null,"UPS (Parcel) (Collect/TP terms- DOM) (E&F INCOTERMS- INTL)"]
[null,"▪ Shipment number (parcel tracking #)"]
[null,"▪ Shipment date (ship date on BL)"]
[null,"▪ Expected receipt date - enter expected date shown in parcel shipping system - if unknown, please reach out to AFL-Logistics@aflglobal.com"]
[null,"▪ Add Waybill/Airbill Number (Note: Enter Carrier + Tracking number)- If Tracking not available at the time of the ASN Enter: \"Tracking Unavailable” "]
[]
[null,"Non-AFL Routed Freight Required Fields:"]
[null,"PP / PP&A TERMS (DOM)"]
[null,"▪ Shipment number (packing slip/commercial invoice #)"]
[null,"▪ Shipment date (ship date on BL)"]
[null,"▪ Expected receipt date - include AFL-Logistics@aflglobal.com on pickup request for expected receipt date"]
[null,"▪ Add Waybill/Airbill Number (Note: Enter Carrier + Tracking number)- If Tracking not available at the time of the ASN Enter: \"Tracking Unavailable” "]
[]
[null,"D&C TERMS (INTL)"]
[null,"▪ Shipment number (packing slip/commercial invoice #)"]
[null,"▪ Shipment date (ship date on BL)"]
[null,"▪ Expected receipt date - include AFL-Logistics@aflglobal.com on pickup request for expected receipt date"]
[null,"▪ Add Waybill/Airbill Number (Note: Enter Carrier + Tracking number)- If Tracking not available at the time of the ASN Enter: \"Tracking Unavailable” "]
[]
[null,"ASN Shipment Lines:"]
[null,"Suppliers must input COO at the line level."]
[null,"Suppliers to provide tracking numbers, if present, and comments need to include carrier name (ex. LTL, TL, steamship line)"]

{"sheet":"AFL ROUTING GUIDE","index":4,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,2,14],[7,0,7,14],[24,0,24,14],[25,1,25,14],[15,1,15,14],[16,1,16,14],[17,1,17,14],[18,1,18,14],[19,1,19,14],[27,1,27,14],[6,1,6,14],[28,1,30,14],[32,1,32,14],[4,1,4,15],[5,1,5,14],[8,1,8,14],[9,1,9,14],[11,1,11,14],[20,1,22,14],[13,1,13,14],[14,1,14,14],[26,1,26,14]]}
["AFL TELECOMMUNICATIONS \nROUTING GUIDE"]
[]
[]
[]
[null,"Welcome to the AFL Telecommunications Routing Guide! Please email AFL-Logistics with any questions in regards to routing."]
[null,"AFL Logistics Email"]
[]
["North America Routing Guide"]
[null,"SHIPPING INSTRUCTIONS:"]
[null,"Parcel: (Shipments of 150 pounds or less & Individual Packages of less than 70 lbs) - Use UPS Account # provided in the PO Document. "]
[]
[null,"Less-than-truck-load: (LTL Shipments of >150lbs or & Individual Packages of > 70 lbs)- Please contact afl_traffic@transplace.com"]
[null,"LTL EMAIL"]
[null,"Truckloads: (TL includes all shipments that are greater than or equal to 20,000lbs or that occupies more than half the truck…generally 14' )\nPlease contact the AFL Traffic and AFL Logistics - afl_traffic@transplace.com & AFL-Logistics@aflglobal.com"]
[null,"TRUCKLOAD EMAIL"]
[null,"Upon contact with Traffic:"]
[null,"1. Shipment details will be entered into our TMS web system"]
[null,"2. Carrier selection will be made"]
[null,"3. Proper arrangement will be scheduled to your location for pickup"]
[null,"4. An AFL BOL will be faxed / emailed to your shipping office to provide the carrier assignment, ensure proper routing and billing instructions."]
[null,"Freight Billing Address: \nAFL c/o Uber Freight US LLC\nPO Box 425\nLowell, AR 72745"]
[]
[]
[]
["International Routing Guide"]
[null,"SHIPPING INSTRUCTIONS:"]
[null,"Parcel: (Shipments of 150 pounds or less & Individual Packages of less than 70 lbs) - Ship UPS Worldwide Express using the Account # provided in the PO Document. "]
[null,"Ocean & Air: Ship with Noatum / MIQ. All pickup requests sent to the AFL Buyer & AFL-Logistics@aflglobal.com for all E and F terms purchase orders"]
[null,"Important Notes:\n▪ The AFL PO# must be present on all paperwork! \n▪ Commerical Invoice / pack slip / and all other documents should be included in the pickup email!"]
[]
[]
[]
[null,"** Failure to abide by these instructions for AFL Routed freight without approval from AFL may result in excess charges being charged back to you **"]

{"sheet":"Codes and Maps","index":5,"n_rows":254,"n_cols":7,"rows_kept":254,"cut":false,"hidden":true,"merged":[]}
["Country Code","Definition",null,"Abbreviation","State",null,"PARCEL GROUND MAPS"]
["AF","Afghanistan",null,"AL","Alabama"]
["AX","Aland Islands",null,"AK","Alaska"]
["AL","Albania",null,"AZ","Arizona"]
["DZ","Algeria",null,"AR","Arkansas"]
["AS","American Samoa",null,"CA","California"]
["AD","Andorra",null,"CO","Colorado"]
["AO","Angola",null,"CT","Connecticut"]
["AI","Anguilla",null,"DE","Delaware"]
["AQ","Antarctica",null,"FL","Florida"]
["AG","Antigua and Barbuda",null,"GA","Georgia"]
["AR","Argentina",null,"HI","Hawaii"]
["AM","Armenia",null,"ID","Idaho"]
["AW","Aruba",null,"IL","Illinois"]
["AU","Australia",null,"IN","Indiana"]
["AT","Austria",null,"IA","Iowa"]
["AZ","Azerbaijan",null,"KS","Kansas"]
["BS","Bahamas",null,"KY","Kentucky"]
["BH","Bahrain",null,"LA","Louisiana"]
["BD","Bangladesh",null,"ME","Maine"]
["BB","Barbados",null,"MD","Maryland"]
["BY","Belarus",null,"MA","Massachusetts"]
["BE","Belgium",null,"MI","Michigan"]
["BZ","Belize",null,"MN","Minnesota"]
["BJ","Benin",null,"MS","Mississippi"]
["BM","Bermuda",null,"MO","Missouri"]
["BT","Bhutan",null,"MT","Montana"]
["BO","Bolivia",null,"NE","Nebraska"]
["BQ","Bonaire, Sint Eustatius and Saba",null,"NV","Nevada"]
["BA","Bosnia and Herzegovina",null,"NH","New Hampshire"]
["BW","Botswana",null,"NJ","New Jersey"]
["BV","Bouvet Island",null,"NM","New Mexico"]
["BR","Brazil",null,"NY","New York"]
["IO","British Indian Ocean Territory",null,"NC","North Carolina"]
["BN","Brunei Darussalam",null,"ND","North Dakota"]
["BG","Bulgaria",null,"OH","Ohio"]
["BF","Burkina Faso",null,"OK","Oklahoma"]
["BI","Burundi",null,"OR","Oregon"]
["KH","Cambodia",null,"PA","Pennsylvania"]
["CM","Cameroon",null,"RI","Rhode Island"]
["CA","Canada",null,"SC","South Carolina"]
["CV","Cape Verde",null,"SD","South Dakota"]
["KY","Cayman Islands",null,"TN","Tennessee"]
["CF","Central African Republic",null,"TX","Texas"]
["TD","Chad",null,"UT","Utah"]
["CL","Chile",null,"VT","Vermont"]
["CN","China",null,"VA","Virginia"]
["CX","Christmas Island",null,"WA","Washington"]
["CC","Cocos (Keeling) Islands",null,"WV","West Virginia"]
["CO","Colombia",null,"WI","Wisconsin"]
["KM","Comoros",null,"WY","Wyoming"]
["CG","Congo"]
["CD","Congo, The Democratic Republic of "]
["CK","Cook Islands"]
["CR","Costa Rica"]
["CI","Cote d'Ivoire"]
["HR","Croatia"]
["CU","Cuba"]
["CW","Curaçao"]
["CY","Cyprus"]
["CZ","Czechia"]
["DK","Denmark"]
["DJ","Djibouti"]
["DM","Dominica"]
["DO","Dominican Republic"]
["EC","Ecuador"]
["EG","Egypt"]
["SV","El Salvador"]
["GQ","Equatorial Guinea"]
["ER","Eritrea"]
["EE","Estonia"]
["ET","Ethiopia"]
["FK","Falkland Islands (Malvinas)"]
["FO","Faroe Islands"]
["FJ","Fiji"]
["FI","Finland"]
["FR","France"]
["GF","French Guiana"]
["PF","French Polynesia"]
["TF","French Southern Territories"]
["GA","Gabon"]
["GM","Gambia"]
["GE","Georgia"]
["DE","Germany"]
["GH","Ghana"]
["GI","Gibraltar"]
["GR","Greece"]
["GL","Greenland"]
["GD","Grenada"]
["GP","Guadeloupe"]
["GU","Guam"]
["GT","Guatemala"]
["GG","Guernsey"]
["GN","Guinea"]
["GW","Guinea-Bissau"]
["GY","Guyana"]
["HT","Haiti"]
["HM","Heard and Mc Donald Islands"]
["VA","Holy See (Vatican City State)"]
["HN","Honduras"]
["HK","Hong Kong"]
["HU","Hungary"]
["IS","Iceland"]
["IN","India"]
["ID","Indonesia"]
["IR","Iran, Islamic Republic of"]
["IQ","Iraq"]
["IE","Ireland"]
["IM","Isle of Man"]
["IL","Israel"]
["IT","Italy"]
["JM","Jamaica"]
["JP","Japan"]
["JE","Jersey"]
["JO","Jordan"]
["KZ","Kazakstan"]
["KE","Kenya"]
["KI","Kiribati"]
["KP","Korea, Democratic People's Republic of"]
["KR","Korea, Republic of"]
["XK","Kosovo (temporary code)"]
["KW","Kuwait"]
["KG","Kyrgyzstan"]
["LA","Lao, People's Democratic Republic"]
["LV","Latvia"]
["LB","Lebanon"]
["LS","Lesotho"]
["LR","Liberia"]
["LY","Libyan Arab Jamahiriya"]
["LI","Liechtenstein"]
["LT","Lithuania"]
["LU","Luxembourg"]
["MO","Macao"]
["MK","Macedonia, The Former Yugoslav Republic Of"]
["MG","Madagascar"]
["MW","Malawi"]
["MY","Malaysia"]
["MV","Maldives"]
["ML","Mali"]
["MT","Malta"]
["MH","Marshall Islands"]
["MQ","Martinique"]
["MR","Mauritania"]
["MU","Mauritius"]
["YT","Mayotte"]
["MX","Mexico"]
["FM","Micronesia, Federated States of"]
["MD","Moldova, Republic of"]
["MC","Monaco"]
["MN","Mongolia"]
["ME","Montenegro"]
["MS","Montserrat"]
["MA","Morocco"]
["MZ","Mozambique"]
["MM","Myanmar"]
["NA","Namibia"]
["NR","Nauru"]
["NP","Nepal"]
["NL","Netherlands"]
["AN","Netherlands Antilles"]
["NC","New Caledonia"]
["NZ","New Zealand"]
["NI","Nicaragua"]
["NE","Niger"]
["NG","Nigeria"]
["NU","Niue"]
["NF","Norfolk Island"]
["MP","Northern Mariana Islands"]
["NO","Norway"]
["OM","Oman"]
["PK","Pakistan"]
["PW","Palau"]
["PS","Palestinian Territory, Occupied"]
["PA","Panama"]
["PG","Papua New Guinea"]
["PY","Paraguay"]
["PE","Peru"]
["PH","Philippines"]
["PN","Pitcairn"]
["PL","Poland"]
["PT","Portugal"]
["PR","Puerto Rico"]
["QA","Qatar"]
["RS","Republic of Serbia"]
["RE","Reunion"]
["RO","Romania"]
["RU","Russia Federation"]
["RW","Rwanda"]
["BL","Saint Barthélemy"]
["SH","Saint Helena"]
["KN","Saint Kitts & Nevis"]
["LC","Saint Lucia"]
["MF","Saint Martin"]
["PM","Saint Pierre and Miquelon"]
["VC","Saint Vincent and the Grenadines"]
["WS","Samoa"]
["SM","San Marino"]
["ST","Sao Tome and Principe"]
["SA","Saudi Arabia"]
["SN","Senegal"]
["CS","Serbia and Montenegro"]
["SC","Seychelles"]
["SL","Sierra Leone"]
["SG","Singapore"]
["SX","Sint Maarten"]
["SK","Slovakia"]
["SI","Slovenia"]
["SB","Solomon Islands"]
["SO","Somalia"]
["ZA","South Africa"]
["GS","South Georgia & The South Sandwich Islands"]
["SS","South Sudan"]
["ES","Spain"]
["LK","Sri Lanka"]
["SD","Sudan"]
["SR","Suriname"]
["SJ","Svalbard and Jan Mayen"]
["SZ","Swaziland"]
["SE","Sweden"]
["CH","Switzerland"]
["SY","Syrian Arab Republic"]
["TW","Taiwan, Province of China"]
["TJ","Tajikistan"]
["TZ","Tanzania, United Republic of"]
["TH","Thailand"]
["TL","Timor-Leste"]
["TG","Togo"]
["TK","Tokelau"]
["TO","Tonga"]
["TT","Trinidad and Tobago"]
["TN","Tunisia"]
["TR","Turkey"]
["XT","Turkish Rep N Cyprus (temporary code)"]
["TM","Turkmenistan"]
["TC","Turks and Caicos Islands"]
["TV","Tuvalu"]
["UG","Uganda"]
["UA","Ukraine"]
["AE","United Arab Emirates"]
["GB","United Kingdom"]
["US","United States"]
["UM","United States Minor Outlying Islands"]
["UY","Uruguay"]
["UZ","Uzbekistan"]
["VU","Vanuatu"]
["VE","Venezuela"]
["VN","Vietnam"]
["VG","Virgin Islands, British"]
["VI","Virgin Islands, U.S."]
["WF","Wallis and Futuna"]
["EH","Western Sahara"]
["YE","Yemen"]
["ZM","Zambia"]
["ZW","Zimbabwe"]